Civic Intelligence

Walter Ramsey Charitable Trust

990 • Fiscal year 2017 • EIN 23-7359233

Jul 01, 2016 to Jun 30, 2017 • Filed on Nov 07, 2017

Organization ProfileN/A
PO Box 0634Milwaukee, WI 53201-0634

(651) 466-8040

Siviq Scores

Precomputed percentiles for this filing year versus similar nonprofits in the same peer cohort.

Liabilities / Assets

14th percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

2017 filings • 501(c)3 • $1M-$5M nonprofits • Source year 2017

Liabilities / Revenue

14th percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

2017 filings • 501(c)3 • $1M-$5M nonprofits • Source year 2017

Net Margin

1st percentile

-241%

Higher net margin than 1% of similar nonprofits.

2017 filings • 501(c)3 • $1M-$5M nonprofits • Source year 2017

Top Officer Pay

39th percentile

$23,501

Higher top officer pay than 39% of similar nonprofits.

Top officer pay equals 72.9% of source-year revenue.

2017 filings • 501(c)3 • $1M-$5M nonprofits • Source year 2017

Asset Growth

21st percentile

-4.3%

Faster asset growth than 21% of similar nonprofits.

2017 filings • 501(c)3 • $1M-$5M nonprofits • Annualized from 2016 to 2017

Revenue Growth

67th percentile

14%

Faster revenue growth than 67% of similar nonprofits.

2017 filings • 501(c)3 • $1M-$5M nonprofits • Annualized from 2016 to 2017

Balance Sheet
Liabilities / Assets14th percentile

Assets

Down

$1,731,554

Down $77,805 (-4.3%) from 2016

Net Assets

Down

$1,731,554

Down $77,805 (-4.3%) from 2016

Liabilities

Flat

$0

Flat from 2016

Revenue And Expenses
Liabilities / Revenue14th percentileNet Margin1st percentile

Revenue

Up

$32,246

Up $3,909 (+14%) from 2016

Expenses

Down

$110,051

Down $4,373 (-3.8%) from 2016

Net Income

Up

-$77,805

Up $8,282 (+9.6%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth21st percentile

The highlighted filing sits inside the broader history for assets, liabilities, and net assets.

$2.0M$1.5M$1.0M$500K$0Assets 2011: $1,627,903Liabilities 2011: $0Net Assets 2011: $1,627,9032011Assets 2012: $1,577,228Liabilities 2012: $53Net Assets 2012: $1,577,1752012Assets 2013: $1,897,907Liabilities 2013: $0Net Assets 2013: $1,897,9072013Assets 2014: $1,877,745Liabilities 2014: $0Net Assets 2014: $1,877,7452014Assets 2016: $1,809,359Liabilities 2016: $0Net Assets 2016: $1,809,3592016Assets 2017: $1,731,554Liabilities 2017: $0Net Assets 2017: $1,731,5542017Assets 2018: $1,728,725Liabilities 2018: $0Net Assets 2018: $1,728,7252018Assets 2019: $1,673,988Liabilities 2019: $0Net Assets 2019: $1,673,9882019Assets 2020: $1,514,693Liabilities 2020: $0Net Assets 2020: $1,514,6932020Assets 2021: $1,464,811Liabilities 2021: $0Net Assets 2021: $1,464,8112021Assets 2022: $1,632,910Liabilities 2022: $0Net Assets 2022: $1,632,9102022Assets 2023: $1,567,006Liabilities 2023: $0Net Assets 2023: $1,567,0062023Assets 2024: $1,522,742Liabilities 2024: $0Net Assets 2024: $1,522,7422024Assets 2025: $1,477,899Liabilities 2025: $0Net Assets 2025: $1,477,8992025

Highlighted filing

2017

Assets$1,731,554
Liabilities$0
Net Assets$1,731,554
Open 2017 Filing

Operations Trend

Revenue Growth67th percentile

Revenue, expenses, and net income across loaded years, with this filing highlighted.

$400K$200K$0-$200KExpenses 2011: $119,0002011Expenses 2012: $97,6912012Expenses 2013: $122,6072013Revenue 2014: $128,288Expenses 2014: $148,453Net Income 2014: -$20,1652014Revenue 2016: $28,337Expenses 2016: $114,424Net Income 2016: -$86,0872016Revenue 2017: $32,246Expenses 2017: $110,051Net Income 2017: -$77,8052017Revenue 2018: $87,126Expenses 2018: $89,956Net Income 2018: -$2,8302018Revenue 2019: $55,031Expenses 2019: $109,777Net Income 2019: -$54,7462019Revenue 2020: -$20,334Expenses 2020: $138,879Net Income 2020: -$159,2132020Revenue 2021: $73,085Expenses 2021: $122,969Net Income 2021: -$49,8842021Revenue 2022: $301,300Expenses 2022: $133,194Net Income 2022: $168,1062022Revenue 2023: $56,531Expenses 2023: $122,806Net Income 2023: -$66,2752023Revenue 2024: $48,576Expenses 2024: $92,627Net Income 2024: -$44,0512024Revenue 2025: $107,679Expenses 2025: $152,524Net Income 2025: -$44,8452025

Highlighted filing

2017

Revenue$32,246
Expenses$110,051
Net Income-$77,805
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2016 to Jun 30, 2017
Signed
Nov 7, 2017
Return Version
2016v3.0
Gross Receipts
$404,908
Mission and Program Overview

Mission

Specific support for fellowships for physicians at children's hospital, st. Paul, minnesota

Balance Sheet Detail
LineBeginningEndChange
Assets
Investments in Publicly Traded Securities$1,792,916$1,719,613▼ $73,303
Rtn Earn Endowment Incm Other Fnds$1,112,004$1,034,199▼ $77,805
Cap Stk Tr Prin Current Funds$697,355$697,355→ $0
Savings and Temporary Cash Investments$16,443$11,941▼ $4,502
Total Assets$1,809,359$1,731,554▼ $77,805
Liabilities
Total Liabilities$0$0→ $0
Net Assets / Fund Balance
Total Net Assets Fund Balance$1,809,359$1,731,554▼ $77,805
Total Liabilities and Net Assets / Fund Balance$1,809,359$1,731,554▼ $77,805
Compensation and Service Providers
Top Officer Pay39th percentile

Employees

NameTitleBaseTotal
-Trustee$23,501$23,501
Revenue and Support

Revenue Composition

Contributions and Grants
$0
Program Service Revenue
$0
Investment Income
$32,246
Other Revenue
$0
Change in Net Assets
$-77,805
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Grants and Similar Amounts Paid$84,470
Salaries, Compensation, and Employee Benefits$23,500
Other Expenses$2,081
Professional Fundraising Fees$0
Total Fundraising Expense$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Grants to Domestic Orgs$84,470--$84,470
Current Officers, Directors, Trustees, and Key Employees$2,350$21,150-$23,500
Fees for Services Accounting-$1,000-$1,000
Other Expenses$25$894-$894
Fees for Services Legal$81$81-$162
Total Functional Expenses$86,926$23,125$0$110,051
Fundraising, Events, and Gaming
Fundraising activities
No
Gaming activities
No
Professional fundraiser used
No

Fundraising and Gaming Totals

Line ItemAmount
Professional Fundraising Fees$0
Political and Lobbying Activity
Political campaign activity
No
Lobbying activity
No
Subject to proxy tax
No
Governance and Compliance

Governance Checklist

Compiled or reviewed by an accountant
No
Business relationship with family members
No
Business relationship with organization members
No
Material changes to governing documents
No
Compensation from other sources disclosed
No
CEO compensation reviewed
Yes
Other officer compensation reviewed
No
Conflict-of-interest policy
No
Audited financial statements prepared
No
Key decisions subject to board approval
No
Management duties delegated
No

Governance Explanations

Form 990, Page 6, Part VI, Line 11-description of Process for Review

“No review was or will be conducted”

FORM 990, PAGE 6, PART VI, LINE 15A

“Fee is reviewed periodically by the sole beneficiary, children's health care foundation”

Form 990, Page 6, Part VI, Line 19

“AVAILABLE UPON REQUEST”

Filing and Contact Details

Filer

Filer Name
Walter Ramsey Charitable Trust
EIN
23-7359233
Phone
6514668040
Address
PO BOX 0634, MILWAUKEE, WI 53201-0634

Signing Officer

Name
U S Bank N a by
Title
Trustee
Phone
6514668040
Signed
2017-11-07
Discuss with paid preparer
Yes

Organization Details

Formed
1973
Legal Domicile
Mn
Voting Board Members
1
Independent Board Members
1
Employees
0

Preparer

Firm
Pricewaterhousecoopers Llp
Address
600 GRANT STREET, PITTSBURGH, PA 15219
Preparer
Joseph J Castriano
Phone
4123556000
Supplemental Narrative

Additional Explanations

Explanation for Form 990, Part XI, Line 9

“ROUNDING DIFFERENCES”

Raw XML Appendix368 raw XML fields

This appendix keeps the raw XML leaves available for debugging and edge-case review. The human report above is the primary experience.

Path#Value
IRS990/AccountantCompileOrReviewInd0false
IRS990/ActivitiesConductedPrtshpInd0false
IRS990/ActivityOrMissionDesc0SPECIFIC SUPPORT FOR FELLOWSHIPS FOR PHYSICIANS AT CHILDREN'S HOSPITAL, ST. PAUL, MINNESOTA
IRS990/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt0US BANK NA
IRS990/BooksInCareOfDetail/PhoneNum06514668040
IRS990/BooksInCareOfDetail/USAddress/AddressLine1Txt0101 E FIFTH STREET
IRS990/BooksInCareOfDetail/USAddress/CityNm0ST PAUL
IRS990/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MN
IRS990/BooksInCareOfDetail/USAddress/ZIPCd0551011860
IRS990/BusinessRlnWithFamMemInd0false
IRS990/BusinessRlnWithOfficerEntInd0false
IRS990/BusinessRlnWithOrgMemInd0false
IRS990/CapStkTrPrinCurrentFundsGrp/BOYAmt0697355
IRS990/CapStkTrPrinCurrentFundsGrp/EOYAmt0697355
IRS990/ChangeToOrgDocumentsInd0false
IRS990/CollectionsOfArtInd0false
IRS990/CompCurrentOfcrDirectorsGrp/ManagementAndGeneralAmt021150
IRS990/CompCurrentOfcrDirectorsGrp/ProgramServicesAmt02350
IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt023500
IRS990/CompensationFromOtherSrcsInd0false
IRS990/CompensationProcessCEOInd0true
IRS990/CompensationProcessOtherInd0false
IRS990/ConflictOfInterestPolicyInd0false
IRS990/ConservationEasementsInd0false
IRS990/ConsolidatedAuditFinclStmtInd0false
IRS990/CreditCounselingInd0false
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt00
IRS990/CYGrantsAndSimilarPaidAmt084470
IRS990/CYInvestmentIncomeAmt032246
IRS990/CYOtherExpensesAmt02081
IRS990/CYOtherRevenueAmt00
IRS990/CYProgramServiceRevenueAmt00
IRS990/CYRevenuesLessExpensesAmt0-77805
IRS990/CYSalariesCompEmpBnftPaidAmt023500
IRS990/CYTotalExpensesAmt0110051
IRS990/CYTotalFundraisingExpenseAmt00
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt032246
IRS990/DecisionsSubjectToApprovaInd0false
IRS990/DeductibleArtContributionInd0false
IRS990/DeductibleNonCashContriInd0false
IRS990/DelegationOfMgmtDutiesInd0false
IRS990/Desc0SUPPORTED FELLOWSHIPS FOR PHYSICIANS AT CHILDREN'S HOSPITAL, ST. PAUL, MINNESOTA
IRS990/DescribedInSection501c3Ind0true
IRS990/DisregardedEntityInd0false
IRS990/DocumentRetentionPolicyInd0false
IRS990/DonorAdvisedFundInd0false
IRS990/ElectionOfBoardMembersInd0false
IRS990/EmployeeCnt00
IRS990/EngagedInExcessBenefitTransInd0false
IRS990/FamilyOrBusinessRlnInd0false
IRS990/FederalGrantAuditRequiredInd0false
IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt01000
IRS990/FeesForServicesAccountingGrp/TotalAmt01000
IRS990/FeesForServicesLegalGrp/ManagementAndGeneralAmt081
IRS990/FeesForServicesLegalGrp/ProgramServicesAmt081
IRS990/FeesForServicesLegalGrp/TotalAmt0162
IRS990/ForeignActivitiesInd0false
IRS990/ForeignFinancialAccountInd0false
IRS990/ForeignOfficeInd0false
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt01.0
IRS990/Form990PartVIISectionAGrp/BusinessName/BusinessNameLine1Txt0US BANK
IRS990/Form990PartVIISectionAGrp/InstitutionalTrusteeInd0X
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt023501
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt00
IRS990/Form990PartVIISectionAGrp/TitleTxt0TRUSTEE
IRS990/Form990ProvidedToGvrnBodyInd0false
IRS990/FormationYr01973
IRS990/FormerOfcrEmployeesListedInd0false
IRS990/FSAuditedInd0false
IRS990/FundraisingActivitiesInd0false
IRS990/GainOrLossGrp/SecuritiesAmt0-10863
IRS990/GamingActivitiesInd0false
IRS990/GoverningBodyVotingMembersCnt01
IRS990/GrantsToDomesticOrgsGrp/ProgramServicesAmt084470
IRS990/GrantsToDomesticOrgsGrp/TotalAmt084470
IRS990/GrantsToIndividualsInd0false
IRS990/GrantsToOrganizationsInd0false
IRS990/GrantToRelatedPersonInd0false
IRS990/GrossAmountSalesAssetsGrp/SecuritiesAmt0361799
IRS990/GrossReceiptsAmt0404908
IRS990/GroupReturnForAffiliatesInd0false
IRS990/IncludeFIN48FootnoteInd0false
IRS990/IndependentAuditFinclStmtInd0false
IRS990/IndependentVotingMemberCnt01
IRS990/IndoorTanningServicesInd0false
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InfoInScheduleOPartXIInd0X
IRS990/InvestmentIncomeGrp/ExclusionAmt043109
IRS990/InvestmentIncomeGrp/RelatedOrExemptFuncIncomeAmt00
IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt043109
IRS990/InvestmentIncomeGrp/UnrelatedBusinessRevenueAmt00
IRS990/InvestmentInJointVentureInd0false
IRS990/InvestmentsPubTradedSecGrp/BOYAmt01792916
IRS990/InvestmentsPubTradedSecGrp/EOYAmt01719613
IRS990/IRPDocumentCnt00
IRS990/IRPDocumentW2GCnt00
IRS990/LegalDomicileStateCd0MN
IRS990/LessCostOthBasisSalesExpnssGrp/SecuritiesAmt0372662
IRS990/LoanOutstandingInd0false
IRS990/LobbyingActivitiesInd0false
IRS990/LocalChaptersInd0false
IRS990/MaterialDiversionOrMisuseInd0false
IRS990/MembersOrStockholdersInd0false
IRS990/MethodOfAccountingCashInd0X
IRS990/MinutesOfCommitteesInd0true
IRS990/MinutesOfGoverningBodyInd0true
IRS990/MissionDesc0SPECIFIC SUPPORT FOR FELLOWSHIPS FOR PHYSICIANS AT CHILDREN'S HOSPITAL, ST. PAUL, MINNESOTA
IRS990/MoreThan5000KToIndividualsInd0false
IRS990/MoreThan5000KToOrgInd0false
IRS990/NetAssetsOrFundBalancesBOYAmt01809359
IRS990/NetAssetsOrFundBalancesEOYAmt01731554
IRS990/NetGainOrLossInvestmentsGrp/ExclusionAmt0-10863
IRS990/NetGainOrLossInvestmentsGrp/TotalRevenueColumnAmt0-10863
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NondeductibleContributionsInd0false
IRS990/OfficerMailingAddressInd0false
IRS990/OperateHospitalInd0false
IRS990/Organization501c3Ind0X
IRS990/OrgDoesNotFollowSFAS117Ind0X
IRS990/OtherExpensesGrp/Desc0FILING FEES
IRS990/OtherExpensesGrp/Desc1FOREIGN TAXES
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt0894
IRS990/OtherExpensesGrp/ProgramServicesAmt025
IRS990/OtherExpensesGrp/TotalAmt025
IRS990/OtherExpensesGrp/TotalAmt1894
IRS990/OtherRevenueMiscGrp/BusinessCd0900001
IRS990/OtherRevenueMiscGrp/Desc0NET SETLEMENT FROM CLASS
IRS990/PartialLiquidationInd0false
IRS990/PoliticalCampaignActyInd0false
IRS990/ProfessionalFundraisingInd0false
IRS990/ProhibitedTaxShelterTransInd0false
IRS990/PYExcessBenefitTransInd0false
IRS990/PYGrantsAndSimilarPaidAmt088769
IRS990/PYInvestmentIncomeAmt028337
IRS990/PYOtherExpensesAmt02436
IRS990/PYRevenuesLessExpensesAmt0-86087
IRS990/PYSalariesCompEmpBnftPaidAmt023219
IRS990/PYTotalExpensesAmt0114424
IRS990/PYTotalRevenueAmt028337
IRS990/ReconcilationRevenueExpnssAmt0-77805
IRS990/RelatedEntityInd0true
IRS990/RelatedOrganizationCtrlEntInd0false
IRS990/ReportInvestmentsOtherSecInd0false
IRS990/ReportLandBuildingEquipmentInd0false
IRS990/ReportOtherAssetsInd0false
IRS990/ReportOtherLiabilitiesInd0false
IRS990/ReportProgramRelatedInvstInd0false
IRS990/RtnEarnEndowmentIncmOthFndsGrp/BOYAmt01112004
IRS990/RtnEarnEndowmentIncmOthFndsGrp/EOYAmt01034199
IRS990/SavingsAndTempCashInvstGrp/BOYAmt016443
IRS990/SavingsAndTempCashInvstGrp/EOYAmt011941
IRS990ScheduleA/AdjustedNetIncomeGrp/AdjustedGrossIncomeGrp/CurrentYearAmt043109
IRS990ScheduleA/AdjustedNetIncomeGrp/AdjustedGrossIncomeGrp/PriorYearAmt036862
IRS990ScheduleA/AdjustedNetIncomeGrp/DepreciationDepletionGrp/PriorYearAmt00
IRS990ScheduleA/AdjustedNetIncomeGrp/NetSTCapitalGainAdjNetIncmGrp/PriorYearAmt00
IRS990ScheduleA/AdjustedNetIncomeGrp/OtherExpensesGrp/CurrentYearAmt01081
IRS990ScheduleA/AdjustedNetIncomeGrp/OtherExpensesGrp/PriorYearAmt01315
IRS990ScheduleA/AdjustedNetIncomeGrp/OtherGrossIncomeGrp/CurrentYearAmt043109
IRS990ScheduleA/AdjustedNetIncomeGrp/OtherGrossIncomeGrp/PriorYearAmt036862
IRS990ScheduleA/AdjustedNetIncomeGrp/ProductionIncomeGrp/CurrentYearAmt021150
IRS990ScheduleA/AdjustedNetIncomeGrp/ProductionIncomeGrp/PriorYearAmt020897
IRS990ScheduleA/AdjustedNetIncomeGrp/RecoveriesPYDistributionsGrp/PriorYearAmt00
IRS990ScheduleA/AdjustedNetIncomeGrp/TotalAdjustedNetIncomeGrp/CurrentYearAmt020878
IRS990ScheduleA/AdjustedNetIncomeGrp/TotalAdjustedNetIncomeGrp/PriorYearAmt014650
IRS990ScheduleA/DistributableAmountGrp/CYAdjNetIncomeDistributableAmt014650
IRS990ScheduleA/DistributableAmountGrp/CYDistributableAsAdjustedAmt058720
IRS990ScheduleA/DistributableAmountGrp/CYGreaterAdjustedMinimumAmt058720
IRS990ScheduleA/DistributableAmountGrp/CYIncomeTaxImposedPYAmt00
IRS990ScheduleA/DistributableAmountGrp/CYPct85AdjustedNetIncomeAmt012453
IRS990ScheduleA/DistributableAmountGrp/CYTotalMinAstDistributableAmt058720
IRS990ScheduleA/DistributionAllocationsGrp/CYDistribAppUnderdistriPYAmt00
IRS990ScheduleA/DistributionAllocationsGrp/CYDistributableAsAdjustedAmt058720
IRS990ScheduleA/DistributionAllocationsGrp/CyovAppliedUnderdistrCPYAmt058720
IRS990ScheduleA/DistributionAllocationsGrp/CyovAppliedUnderdistriPYAmt00
IRS990ScheduleA/DistributionAllocationsGrp/CYTotalAnnualDistributionsAmt086926
IRS990ScheduleA/DistributionAllocationsGrp/ExcessDistributionAmt086926
IRS990ScheduleA/DistributionAllocationsGrp/ExcessDistributionCyovAmt037200
IRS990ScheduleA/DistributionAllocationsGrp/ExcessDistributionCyovYr1Amt091431
IRS990ScheduleA/DistributionAllocationsGrp/ExcessDistributionCyovYr2Amt04489
IRS990ScheduleA/DistributionAllocationsGrp/ExcessDistributionCyovYr3Amt00
IRS990ScheduleA/DistributionAllocationsGrp/ExcessDistriCyovToNextYrAmt0124126
IRS990ScheduleA/DistributionAllocationsGrp/ExcessFromYear1Amt086926
IRS990ScheduleA/DistributionAllocationsGrp/ExcessFromYear2Amt037200
IRS990ScheduleA/DistributionAllocationsGrp/ExcessFromYear3Amt00
IRS990ScheduleA/DistributionAllocationsGrp/ExcessFromYear4Amt00
IRS990ScheduleA/DistributionAllocationsGrp/RemainingUnderdistriCYAmt00
IRS990ScheduleA/DistributionAllocationsGrp/RemainingUnderdistriPYAmt00
IRS990ScheduleA/DistributionAllocationsGrp/TotalExcessDistributionCyovAmt095920
IRS990ScheduleA/DistributionAllocationsGrp/UnderdistributionsAmt00
IRS990ScheduleA/DistributionsGrp/CYAdministrativeExpensePaidAmt02456
IRS990ScheduleA/DistributionsGrp/CYDistriAttentiveSuprtOrgAmt00
IRS990ScheduleA/DistributionsGrp/CYDistributableAsAdjustedAmt058720
IRS990ScheduleA/DistributionsGrp/CYDistributionYrRt00
IRS990ScheduleA/DistributionsGrp/CYOtherDistributionsAmt00
IRS990ScheduleA/DistributionsGrp/CYPaidAccomplishExemptPrpsAmt084470
IRS990ScheduleA/DistributionsGrp/CYPdInExcessIncomeActivityAmt00
IRS990ScheduleA/DistributionsGrp/CYTotalAnnualDistributionsAmt086926
IRS990ScheduleA/DistributionsGrp/ExemptUseAssetsAcquisPaidAmt00
IRS990ScheduleA/DistributionsGrp/QualifiedSetAsideAmt00
IRS990ScheduleA/Form990SchASupportingOrgGrp/Contribution35ControlledInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ContributionControllerInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ContributionFamilyInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ControlledDisqualifiedPrsnInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/DisqualifiedPrsnControllIntInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/DisqualifiedPrsnOwnrIntInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ExcessBusinessHoldingsRulesInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ListedByNameGoverningDocInd0true
IRS990ScheduleA/Form990SchASupportingOrgGrp/LoanDisqualifiedPersonInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/OrganizationChangeSuprtOrgInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/PaymentSubstantialContribtrInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SupportedOrgNotOrganizedUSInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SupportedOrgSectionC456Ind0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SupportNonSupportedOrgInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SuprtOrgNoIRSDeterminationInd0false
IRS990ScheduleA/Form990SchAType3SprtOrgAllGrp/OfficersCloseRelationshipInd0false
IRS990ScheduleA/Form990SchAType3SprtOrgAllGrp/SupportedOrgVoiceInvestmentInd0true
IRS990ScheduleA/Form990SchAType3SprtOrgAllGrp/TimelyProvidedDocumentsInd0true
IRS990ScheduleA/MinimumAssetAmountGrp/AcquisitionIndebtednessGrp/PriorYearAmt00
IRS990ScheduleA/MinimumAssetAmountGrp/AdjustedFMVLessIndebtednessGrp/CurrentYearAmt01752866
IRS990ScheduleA/MinimumAssetAmountGrp/AdjustedFMVLessIndebtednessGrp/PriorYearAmt01703258
IRS990ScheduleA/MinimumAssetAmountGrp/AverageMonthlyCashBalancesGrp/CurrentYearAmt024941
IRS990ScheduleA/MinimumAssetAmountGrp/AverageMonthlyCashBalancesGrp/PriorYearAmt026237
IRS990ScheduleA/MinimumAssetAmountGrp/AverageMonthlyFMVOfSecGrp/CurrentYearAmt01727925
IRS990ScheduleA/MinimumAssetAmountGrp/AverageMonthlyFMVOfSecGrp/PriorYearAmt01677021
IRS990ScheduleA/MinimumAssetAmountGrp/CashDeemedCharitableGrp/CurrentYearAmt026293
IRS990ScheduleA/MinimumAssetAmountGrp/CashDeemedCharitableGrp/PriorYearAmt025549
IRS990ScheduleA/MinimumAssetAmountGrp/DiscountClaimedAmt00
IRS990ScheduleA/MinimumAssetAmountGrp/FMVOtherNonExemptUseAssetGrp/PriorYearAmt00
IRS990ScheduleA/MinimumAssetAmountGrp/NetVlNonExemptUseAssetsGrp/CurrentYearAmt01726573
IRS990ScheduleA/MinimumAssetAmountGrp/NetVlNonExemptUseAssetsGrp/PriorYearAmt01677709
IRS990ScheduleA/MinimumAssetAmountGrp/PctOfNetVlNonExemptUseAstGrp/CurrentYearAmt060430
IRS990ScheduleA/MinimumAssetAmountGrp/PctOfNetVlNonExemptUseAstGrp/PriorYearAmt058720
IRS990ScheduleA/MinimumAssetAmountGrp/RecoveriesPYDistriMinAssetGrp/PriorYearAmt00
IRS990ScheduleA/MinimumAssetAmountGrp/TotalFMVOfNonExemptUseAssetGrp/CurrentYearAmt01752866
IRS990ScheduleA/MinimumAssetAmountGrp/TotalFMVOfNonExemptUseAssetGrp/PriorYearAmt01703258
IRS990ScheduleA/MinimumAssetAmountGrp/TotalMinimumAssetGrp/CurrentYearAmt060430
IRS990ScheduleA/MinimumAssetAmountGrp/TotalMinimumAssetGrp/PriorYearAmt058720
IRS990ScheduleA/OtherSupportSumAmt00
IRS990ScheduleA/SupportedOrganizationsCnt01
IRS990ScheduleA/SupportedOrganizationsTotalCnt01
IRS990ScheduleA/SupportedOrgInformationGrp/EIN0411814223
IRS990ScheduleA/SupportedOrgInformationGrp/GoverningDocumentListedInd0true
IRS990ScheduleA/SupportedOrgInformationGrp/OrganizationTypeCd04
IRS990ScheduleA/SupportedOrgInformationGrp/OtherSupportAmt00
IRS990ScheduleA/SupportedOrgInformationGrp/SupportAmt00
IRS990ScheduleA/SupportedOrgInformationGrp/SupportedOrganizationName/BusinessNameLine1Txt0CHILDRENS HEALTHCARE FDN
IRS990ScheduleA/SupportingOrganization509a3Ind0X
IRS990ScheduleA/SupportingOrgType3NonFuncInd0X
IRS990ScheduleA/SupportSumAmt00
IRS990/ScheduleBRequiredInd0false
IRS990/ScheduleJRequiredInd0false
IRS990/ScheduleORequiredInd0true
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0NO REVIEW WAS OR WILL BE CONDUCTED
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1FEE IS REVIEWED PERIODICALLY BY THE SOLE BENEFICIARY, CHILDREN'S HEALTH CARE FOUNDATION
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2AVAILABLE UPON REQUEST
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3ROUNDING DIFFERENCES
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990, PAGE 6, PART VI, LINE 11-DESCRIPTION OF PROCESS FOR REVIEW
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990, PAGE 6, PART VI, LINE 15a
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990, PAGE 6, PART VI, LINE 19
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3EXPLANATION FOR FORM 990, PART XI, LINE 9
IRS990ScheduleR/AssetExchangeInd0false
IRS990ScheduleR/AssetPurchaseFromOtherOrgInd0false
IRS990ScheduleR/AssetSaleToOtherOrgInd0false
IRS990ScheduleR/GiftGrntCapContriFromOthOrgInd0false
IRS990ScheduleR/GiftGrntOrCapContriToOthOrgInd0true
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ControlledOrganizationInd0false
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/DirectControllingNACd0N/A
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/DisregardedEntityName/BusinessNameLine1Txt0CHILDREN'S HEALTH CARE FOUNDATION
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/EIN0411814223
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/ExemptCodeSectionTxt03
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/LegalDomicileStateCd0MN
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/PrimaryActivitiesTxt0CHILDREN'S HEALTH CARE
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/AddressLine1Txt02910 CENTRE POINTE DRIVE
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/CityNm0ROSEVILLE
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/StateAbbreviationCd0MN
IRS990ScheduleR/IdRelatedTaxExemptOrgGrp/USAddress/ZIPCd055113
IRS990ScheduleR/LoansOrGuaranteesFromOthOrgInd0false
IRS990ScheduleR/LoansOrGuaranteesToOtherOrgInd0false
IRS990ScheduleR/PaidEmployeesSharingInd0false
IRS990ScheduleR/PerformOfServicesByOtherOrgInd0false
IRS990ScheduleR/PerformOfServicesForOthOrgInd0false
IRS990ScheduleR/ReceiptOfIntAnntsRntsRyltsInd0false
IRS990ScheduleR/ReimbursementPaidByOtherOrgInd0false
IRS990ScheduleR/ReimbursementPaidToOtherOrgInd0false
IRS990ScheduleR/RentalOfFacilitiesToOthOrgInd0false
IRS990ScheduleR/RentalOfFcltsFromOthOrgInd0false
IRS990ScheduleR/SharingOfFacilitiesInd0false
IRS990ScheduleR/TransferFromOtherOrgInd0false
IRS990ScheduleR/TransferToOtherOrgInd0false
IRS990/SchoolOperatingInd0false
IRS990/SignificantChangeInd0false
IRS990/SignificantNewProgramSrvcInd0false
IRS990/StatesWhereCopyOfReturnIsFldCd0MN
IRS990/SubjectToProxyTaxInd0false
IRS990/TaxablePartyNotificationInd0false
IRS990/TaxExemptBondsInd0false
IRS990/TempOrPermanentEndowmentsInd0false
IRS990/TerminateOperationsInd0false
IRS990/TotalAssetsBOYAmt01809359
IRS990/TotalAssetsEOYAmt01731554
IRS990/TotalAssetsGrp/BOYAmt01809359
IRS990/TotalAssetsGrp/EOYAmt01731554
IRS990/TotalCompGreaterThan150KInd0false
IRS990/TotalEmployeeCnt00
IRS990/TotalFunctionalExpensesGrp/FundraisingAmt00
IRS990/TotalFunctionalExpensesGrp/ManagementAndGeneralAmt023125
IRS990/TotalFunctionalExpensesGrp/ProgramServicesAmt086926
IRS990/TotalFunctionalExpensesGrp/TotalAmt0110051
IRS990/TotalGrossUBIAmt00
IRS990/TotalLiabilitiesBOYAmt00
IRS990/TotalLiabilitiesEOYAmt00
IRS990/TotalLiabilitiesGrp/BOYAmt00
IRS990/TotalLiabilitiesGrp/EOYAmt00
IRS990/TotalNetAssetsFundBalanceGrp/BOYAmt01809359
IRS990/TotalNetAssetsFundBalanceGrp/EOYAmt01731554
IRS990/TotalOtherCompensationAmt00
IRS990/TotalReportableCompFromOrgAmt023501
IRS990/TotalRevenueGrp/ExclusionAmt032246
IRS990/TotalRevenueGrp/RelatedOrExemptFuncIncomeAmt00
IRS990/TotalRevenueGrp/TotalRevenueColumnAmt032246
IRS990/TotalRevenueGrp/UnrelatedBusinessRevenueAmt00
IRS990/TotLiabNetAssetsFundBalanceGrp/BOYAmt01809359
IRS990/TotLiabNetAssetsFundBalanceGrp/EOYAmt01731554
IRS990/TotReportableCompRltdOrgAmt00
IRS990/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990/TypeOfOrganizationTrustInd0X
IRS990/UnrelatedBusIncmOverLimitInd0false
IRS990/UponRequestInd0X
IRS990/VotingMembersGoverningBodyCnt01
IRS990/VotingMembersIndependentCnt01
IRS990/WebsiteAddressTxt0N/A
IRS990/WhistleblowerPolicyInd0false
ReturnHeader/BuildTS02017-02-10 21:41:12Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0U S BANK N A BY
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum06514668040
ReturnHeader/BusinessOfficerGrp/SignatureDt02017-11-07
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0WALTER RAMSEY CHARITABLE TRUST
ReturnHeader/Filer/BusinessNameControlTxt0RAMS
ReturnHeader/Filer/EIN0237359233
ReturnHeader/Filer/PhoneNum06514668040
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 0634
ReturnHeader/Filer/USAddress/CityNm0MILWAUKEE
ReturnHeader/Filer/USAddress/StateAbbreviationCd0WI
ReturnHeader/Filer/USAddress/ZIPCd0532010634
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId09DFA6AEAC18A3C2A99BF63D0504D612709B35FC3
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId09E1B593DB857E74EE153996372FF1A551E8DCB88
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0155.201.188.12
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0134008324
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0PRICEWATERHOUSECOOPERS LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0600 GRANT STREET
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0PITTSBURGH
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0PA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd015219
ReturnHeader/PreparerPersonGrp/PhoneNum04123556000
ReturnHeader/PreparerPersonGrp/PreparationDt02017-11-07
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0JOSEPH J CASTRIANO
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02017-11-08T17:00:24-06:00
ReturnHeader/ReturnTypeCd0990
ReturnHeader/TaxPeriodBeginDt02016-07-01
ReturnHeader/TaxPeriodEndDt02017-06-30
ReturnHeader/TaxYr02016

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2017 • Form 990Detailed filing. Detailed filing data is available for this year.

Open filing
Assets
$1,731,554
Liabilities
$0
Net assets
$1,731,554
Revenue
$32,246
Expenses
$110,051
Net income
-$77,805
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2025XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.48$0.00$1.48$0.11$0.15$0.04
2024XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.52$0.00$1.52$0.05$0.09$0.04
2023Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.57$0.00$1.57$0.06$0.12$0.07
2022Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.63$0.00$1.63$0.30$0.13$0.17
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.46$0.00$1.46$0.07$0.12$0.05
2020Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.51$0.00$1.51$0.02$0.14$0.16
2019XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.67$0.00$1.67$0.06$0.11$0.05
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.73$0.00$1.73$0.09$0.09$0.00
2017Detailed filing. Detailed filing data is available for this year.$1.73$0.00$1.73$0.03$0.11$0.08
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.81$0.00$1.81$0.03$0.11$0.09
2014Detailed filing. Detailed filing data is available for this year.$1.88$0.00$1.88$0.13$0.15$0.02
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.90$0.00$1.90$0.12
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.58$0.00$1.58$0.10
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.63$0.00$1.63$0.12