Civic Intelligence

Walter Ramsey Charitable Trust

990 • Fiscal year 2018 • EIN 23-7359233

Jul 01, 2017 to Jun 30, 2018 • Filed on Oct 18, 2018

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.

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

Liabilities / Revenue

14th percentile

0.00x

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

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

Net Margin

31st percentile

-3.2%

Higher net margin than 31% of similar nonprofits.

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

Top Officer Pay

39th percentile

$24,726

Higher top officer pay than 39% of similar nonprofits.

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

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

Asset Growth

45th percentile

-0.2%

Faster asset growth than 45% of similar nonprofits.

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

Revenue Growth

96th percentile

170%

Faster revenue growth than 96% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets14th percentile

Assets

Down

$1,728,725

Down $2,829 (-0.2%) from 2017

Net Assets

Down

$1,728,725

Down $2,829 (-0.2%) from 2017

Liabilities

Flat

$0

Flat from 2017

Revenue And Expenses
Liabilities / Revenue14th percentileNet Margin31st percentile

Revenue

Up

$87,126

Up $54,880 (+170%) from 2017

Expenses

Down

$89,956

Down $20,095 (-18%) from 2017

Net Income

Up

-$2,830

Up $74,975 (+96%) from 2017

Historical Trend

Balance Sheet Trend

Asset Growth45th 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

2018

Assets$1,728,725
Liabilities$0
Net Assets$1,728,725
Open 2018 Filing

Operations Trend

Revenue Growth96th 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

2018

Revenue$87,126
Expenses$89,956
Net Income-$2,830
Open 2018 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2017 to Jun 30, 2018
Signed
Oct 18, 2018
Return Version
2017v2.2
Gross Receipts
$244,842
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,719,613$1,693,638▼ $25,975
Rtn Earn Endowment Incm Other Fnds$1,034,199$1,031,370▼ $2,829
Cap Stk Tr Prin Current Funds$697,355$697,355→ $0
Savings and Temporary Cash Investments$11,941$34,003▲ $22,062
Cash and Non-Interest-Bearing Accounts-$1,084-
Total Assets$1,731,554$1,728,725▼ $2,829
Liabilities
Total Liabilities$0$0→ $0
Net Assets / Fund Balance
Total Net Assets Fund Balance$1,731,554$1,728,725▼ $2,829
Total Liabilities and Net Assets / Fund Balance$1,731,554$1,728,725▼ $2,829
Compensation and Service Providers
Top Officer Pay39th percentile

Employees

NameTitleBaseTotal
-Trustee$24,726$24,726
Revenue and Support

Revenue Composition

Contributions and Grants
$0
Program Service Revenue
$0
Investment Income
$87,126
Other Revenue
$0
Change in Net Assets
$-2,830
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Grants and Similar Amounts Paid$63,881
Salaries, Compensation, and Employee Benefits$24,727
Other Expenses$1,348
Professional Fundraising Fees$0
Total Fundraising Expense$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Grants to Domestic Orgs$63,881--$63,881
Current Officers, Directors, Trustees, and Key Employees$2,473$22,254-$24,727
Other Expenses$25$1,161-$1,161
Fees for Services Legal$81$81-$162
Total Functional Expenses$66,460$23,496$0$89,956
International Activity

Grant and Assistance Recipients

RecipientLocationCategoryPurposeAmount
CHILDREN'S HEALTH CARE FOUNDATIONRoseville, MN501(c)(3)PHYSICIANS ARE SELECTED BY THE GRANTEE FOR THE SCHOLARSHIPS SOLELY FOR THEIR WORK AT CHILDREN'S HOSPITAL, ST. PAUL, MINNESOTA$63,881
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
2018-10-18
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”

Raw XML Appendix394 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/CashNonInterestBearingGrp/EOYAmt01084
IRS990/ChangeToOrgDocumentsInd0false
IRS990/CollectionsOfArtInd0false
IRS990/CompCurrentOfcrDirectorsGrp/ManagementAndGeneralAmt022254
IRS990/CompCurrentOfcrDirectorsGrp/ProgramServicesAmt02473
IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt024727
IRS990/CompensationFromOtherSrcsInd0false
IRS990/CompensationProcessCEOInd0true
IRS990/CompensationProcessOtherInd0false
IRS990/ConflictOfInterestPolicyInd0false
IRS990/ConservationEasementsInd0false
IRS990/ConsolidatedAuditFinclStmtInd0false
IRS990/CreditCounselingInd0false
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt00
IRS990/CYGrantsAndSimilarPaidAmt063881
IRS990/CYInvestmentIncomeAmt087126
IRS990/CYOtherExpensesAmt01348
IRS990/CYOtherRevenueAmt00
IRS990/CYProgramServiceRevenueAmt00
IRS990/CYRevenuesLessExpensesAmt0-2830
IRS990/CYSalariesCompEmpBnftPaidAmt024727
IRS990/CYTotalExpensesAmt089956
IRS990/CYTotalFundraisingExpenseAmt00
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt087126
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/ExpenseAmt066460
IRS990/FamilyOrBusinessRlnInd0false
IRS990/FederalGrantAuditRequiredInd0false
IRS990/FeesForServicesLegalGrp/ManagementAndGeneralAmt081
IRS990/FeesForServicesLegalGrp/ProgramServicesAmt081
IRS990/FeesForServicesLegalGrp/TotalAmt0162
IRS990/ForeignActivitiesInd0false
IRS990/ForeignFinancialAccountInd0false
IRS990/ForeignOfficeInd0false
IRS990/Form8282PropertyDisposedOfInd0false
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt01.0
IRS990/Form990PartVIISectionAGrp/BusinessName/BusinessNameLine1Txt0US BANK
IRS990/Form990PartVIISectionAGrp/InstitutionalTrusteeInd0X
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt024726
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt00
IRS990/Form990PartVIISectionAGrp/TitleTxt0TRUSTEE
IRS990/Form990ProvidedToGvrnBodyInd0false
IRS990/FormationYr01973
IRS990/FormerOfcrEmployeesListedInd0false
IRS990/FSAuditedInd0false
IRS990/FundraisingActivitiesInd0false
IRS990/GainOrLossGrp/SecuritiesAmt042340
IRS990/GamingActivitiesInd0false
IRS990/GoverningBodyVotingMembersCnt01
IRS990/GrantAmt063881
IRS990/GrantsToDomesticOrgsGrp/ProgramServicesAmt063881
IRS990/GrantsToDomesticOrgsGrp/TotalAmt063881
IRS990/GrantsToIndividualsInd0false
IRS990/GrantsToOrganizationsInd0true
IRS990/GrantToRelatedPersonInd0false
IRS990/GrossAmountSalesAssetsGrp/SecuritiesAmt0200056
IRS990/GrossReceiptsAmt0244842
IRS990/GroupReturnForAffiliatesInd0false
IRS990/IncludeFIN48FootnoteInd0false
IRS990/IndependentAuditFinclStmtInd0false
IRS990/IndependentVotingMemberCnt01
IRS990/IndoorTanningServicesInd0false
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InfoInScheduleOPartXIInd0X
IRS990/InvestmentIncomeGrp/ExclusionAmt044786
IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt044786
IRS990/InvestmentInJointVentureInd0false
IRS990/InvestmentsPubTradedSecGrp/BOYAmt01719613
IRS990/InvestmentsPubTradedSecGrp/EOYAmt01693638
IRS990/IRPDocumentCnt00
IRS990/IRPDocumentW2GCnt00
IRS990/LegalDomicileStateCd0MN
IRS990/LessCostOthBasisSalesExpnssGrp/SecuritiesAmt0157716
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/NetAssetsOrFundBalancesBOYAmt01731554
IRS990/NetAssetsOrFundBalancesEOYAmt01728725
IRS990/NetGainOrLossInvestmentsGrp/ExclusionAmt042340
IRS990/NetGainOrLossInvestmentsGrp/TotalRevenueColumnAmt042340
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NondeductibleContributionsInd0false
IRS990/OfficerMailingAddressInd0false
IRS990/OperateHospitalInd0false
IRS990/Organization501c3Ind0X
IRS990/OrgDoesNotFollowSFAS117Ind0X
IRS990/OtherChangesInNetAssetsAmt01
IRS990/OtherExpensesGrp/Desc0FILING FEES
IRS990/OtherExpensesGrp/Desc1FOREIGN TAXES
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt01161
IRS990/OtherExpensesGrp/ProgramServicesAmt025
IRS990/OtherExpensesGrp/TotalAmt025
IRS990/OtherExpensesGrp/TotalAmt11161
IRS990/OtherRevenueMiscGrp/BusinessCd0900001
IRS990/OtherRevenueMiscGrp/Desc0NET SETLEMENT FROM CLASS
IRS990/PartialLiquidationInd0false
IRS990/PayPremiumsPrsnlBnftCntrctInd0false
IRS990/PoliticalCampaignActyInd0false
IRS990/ProfessionalFundraisingInd0false
IRS990/ProhibitedTaxShelterTransInd0false
IRS990/PYExcessBenefitTransInd0false
IRS990/PYGrantsAndSimilarPaidAmt084470
IRS990/PYInvestmentIncomeAmt032246
IRS990/PYOtherExpensesAmt02081
IRS990/PYRevenuesLessExpensesAmt0-77805
IRS990/PYSalariesCompEmpBnftPaidAmt023500
IRS990/PYTotalExpensesAmt0110051
IRS990/PYTotalRevenueAmt032246
IRS990/QuidProQuoContributionsInd0false
IRS990/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990/ReconcilationRevenueExpnssAmt0-2830
IRS990/RelatedEntityInd0true
IRS990/RelatedOrganizationCtrlEntInd0false
IRS990/ReportInvestmentsOtherSecInd0false
IRS990/ReportLandBuildingEquipmentInd0false
IRS990/ReportOtherAssetsInd0false
IRS990/ReportOtherLiabilitiesInd0false
IRS990/ReportProgramRelatedInvstInd0false
IRS990/RtnEarnEndowmentIncmOthFndsGrp/BOYAmt01034199
IRS990/RtnEarnEndowmentIncmOthFndsGrp/EOYAmt01031370
IRS990/SavingsAndTempCashInvstGrp/BOYAmt011941
IRS990/SavingsAndTempCashInvstGrp/EOYAmt034003
IRS990ScheduleA/AdjustedNetIncomeGrp/AdjustedGrossIncomeGrp/CurrentYearAmt044786
IRS990ScheduleA/AdjustedNetIncomeGrp/AdjustedGrossIncomeGrp/PriorYearAmt043109
IRS990ScheduleA/AdjustedNetIncomeGrp/DepreciationDepletionGrp/PriorYearAmt00
IRS990ScheduleA/AdjustedNetIncomeGrp/NetSTCapitalGainAdjNetIncmGrp/PriorYearAmt00
IRS990ScheduleA/AdjustedNetIncomeGrp/OtherExpensesGrp/CurrentYearAmt01242
IRS990ScheduleA/AdjustedNetIncomeGrp/OtherExpensesGrp/PriorYearAmt01081
IRS990ScheduleA/AdjustedNetIncomeGrp/OtherGrossIncomeGrp/CurrentYearAmt044786
IRS990ScheduleA/AdjustedNetIncomeGrp/OtherGrossIncomeGrp/PriorYearAmt043109
IRS990ScheduleA/AdjustedNetIncomeGrp/ProductionIncomeGrp/CurrentYearAmt022254
IRS990ScheduleA/AdjustedNetIncomeGrp/ProductionIncomeGrp/PriorYearAmt021150
IRS990ScheduleA/AdjustedNetIncomeGrp/RecoveriesPYDistributionsGrp/PriorYearAmt00
IRS990ScheduleA/AdjustedNetIncomeGrp/TotalAdjustedNetIncomeGrp/CurrentYearAmt021290
IRS990ScheduleA/AdjustedNetIncomeGrp/TotalAdjustedNetIncomeGrp/PriorYearAmt020878
IRS990ScheduleA/DistributableAmountGrp/CYAdjNetIncomeDistributableAmt020878
IRS990ScheduleA/DistributableAmountGrp/CYDistributableAsAdjustedAmt060430
IRS990ScheduleA/DistributableAmountGrp/CYGreaterAdjustedMinimumAmt060430
IRS990ScheduleA/DistributableAmountGrp/CYIncomeTaxImposedPYAmt00
IRS990ScheduleA/DistributableAmountGrp/CYPct85AdjustedNetIncomeAmt017746
IRS990ScheduleA/DistributableAmountGrp/CYTotalMinAstDistributableAmt060430
IRS990ScheduleA/DistributionAllocationsGrp/CYDistribAppUnderdistriPYAmt00
IRS990ScheduleA/DistributionAllocationsGrp/CYDistributableAsAdjustedAmt060430
IRS990ScheduleA/DistributionAllocationsGrp/CyovAppliedUnderdistrCPYAmt060430
IRS990ScheduleA/DistributionAllocationsGrp/CyovAppliedUnderdistriPYAmt00
IRS990ScheduleA/DistributionAllocationsGrp/CYTotalAnnualDistributionsAmt066460
IRS990ScheduleA/DistributionAllocationsGrp/ExcessDistributionAmt066460
IRS990ScheduleA/DistributionAllocationsGrp/ExcessDistributionCyovAmt063696
IRS990ScheduleA/DistributionAllocationsGrp/ExcessDistributionCyovYr1Amt086926
IRS990ScheduleA/DistributionAllocationsGrp/ExcessDistributionCyovYr2Amt037200
IRS990ScheduleA/DistributionAllocationsGrp/ExcessDistributionCyovYr3Amt00
IRS990ScheduleA/DistributionAllocationsGrp/ExcessDistributionCyovYr4Amt00
IRS990ScheduleA/DistributionAllocationsGrp/ExcessDistriCyovToNextYrAmt0130156
IRS990ScheduleA/DistributionAllocationsGrp/ExcessFromYear1Amt066460
IRS990ScheduleA/DistributionAllocationsGrp/ExcessFromYear2Amt063696
IRS990ScheduleA/DistributionAllocationsGrp/ExcessFromYear3Amt00
IRS990ScheduleA/DistributionAllocationsGrp/ExcessFromYear4Amt00
IRS990ScheduleA/DistributionAllocationsGrp/ExcessFromYear5Amt00
IRS990ScheduleA/DistributionAllocationsGrp/RemainingUnderdistriCYAmt00
IRS990ScheduleA/DistributionAllocationsGrp/RemainingUnderdistriPYAmt00
IRS990ScheduleA/DistributionAllocationsGrp/TotalExcessDistributionCyovAmt0124126
IRS990ScheduleA/DistributionAllocationsGrp/UnderdistributionsAmt00
IRS990ScheduleA/DistributionsGrp/CYAdministrativeExpensePaidAmt02579
IRS990ScheduleA/DistributionsGrp/CYDistriAttentiveSuprtOrgAmt063881
IRS990ScheduleA/DistributionsGrp/CYDistributableAsAdjustedAmt060430
IRS990ScheduleA/DistributionsGrp/CYDistributionYrRt01.0
IRS990ScheduleA/DistributionsGrp/CYOtherDistributionsAmt00
IRS990ScheduleA/DistributionsGrp/CYPaidAccomplishExemptPrpsAmt063881
IRS990ScheduleA/DistributionsGrp/CYPdInExcessIncomeActivityAmt00
IRS990ScheduleA/DistributionsGrp/CYTotalAnnualDistributionsAmt066460
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/ExcessBusinessHoldingsInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ExcessBusinessHoldingsRulesInd0true
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/Form990ScheduleAPartVIGrp/ExplanationTxt0THE TRUSTEE OF THE SUPPORTING ORGANIZATION MAINTAINS REGULAR COMMUNICATION WITH REPRESENTATIVES OF THE SUPPORTED ORGANIZATION THROUGHOUT THE YEAR. THE TRUSTEE ADVISES ON THE REQUIRED PAYOUT AND MAKES QUARTERLY DISTRIBUTIONS TO THE SUPPORTED ORGANIZATION.
IRS990ScheduleA/Form990ScheduleAPartVIGrp/ExplanationTxt1THE SUPPORTED ORGANIZATION IS SOLEY RESPONSIBLE FOR SELECTING THE GRANT RECIPIENTS OF THE WALTER AND RUTH RAMSEY SCHOLARSHIP FOR PEDIATRIC RESIDENT PHYSICIANS.
IRS990ScheduleA/Form990ScheduleAPartVIGrp/ExplanationTxt2THE AMOUNT RECEIVED FROM THE SUPPORTING ORGANIZATION IS NECESSARY TO PROVIDE FELLOWSHIPS TO PEDIATRIC PHYSICIANS AT CHILDREN'S HOSPITAL ST. PAUL.
IRS990ScheduleA/Form990ScheduleAPartVIGrp/FormAndLineReferenceDesc0PART IV, SECTION D, LINE 2
IRS990ScheduleA/Form990ScheduleAPartVIGrp/FormAndLineReferenceDesc1PART IV, SECTION D, LINE 3
IRS990ScheduleA/Form990ScheduleAPartVIGrp/FormAndLineReferenceDesc2PART V, SECTION D, LINE 8
IRS990ScheduleA/MinimumAssetAmountGrp/AcquisitionIndebtednessGrp/PriorYearAmt00
IRS990ScheduleA/MinimumAssetAmountGrp/AdjustedFMVLessIndebtednessGrp/CurrentYearAmt01885140
IRS990ScheduleA/MinimumAssetAmountGrp/AdjustedFMVLessIndebtednessGrp/PriorYearAmt01752866
IRS990ScheduleA/MinimumAssetAmountGrp/AverageMonthlyCashBalancesGrp/CurrentYearAmt046088
IRS990ScheduleA/MinimumAssetAmountGrp/AverageMonthlyCashBalancesGrp/PriorYearAmt024941
IRS990ScheduleA/MinimumAssetAmountGrp/AverageMonthlyFMVOfSecGrp/CurrentYearAmt01839052
IRS990ScheduleA/MinimumAssetAmountGrp/AverageMonthlyFMVOfSecGrp/PriorYearAmt01727925
IRS990ScheduleA/MinimumAssetAmountGrp/CashDeemedCharitableGrp/CurrentYearAmt028277
IRS990ScheduleA/MinimumAssetAmountGrp/CashDeemedCharitableGrp/PriorYearAmt026293
IRS990ScheduleA/MinimumAssetAmountGrp/DiscountClaimedAmt00
IRS990ScheduleA/MinimumAssetAmountGrp/FMVOtherNonExemptUseAssetGrp/PriorYearAmt00
IRS990ScheduleA/MinimumAssetAmountGrp/NetVlNonExemptUseAssetsGrp/CurrentYearAmt01856863
IRS990ScheduleA/MinimumAssetAmountGrp/NetVlNonExemptUseAssetsGrp/PriorYearAmt01726573
IRS990ScheduleA/MinimumAssetAmountGrp/PctOfNetVlNonExemptUseAstGrp/CurrentYearAmt064990
IRS990ScheduleA/MinimumAssetAmountGrp/PctOfNetVlNonExemptUseAstGrp/PriorYearAmt060430
IRS990ScheduleA/MinimumAssetAmountGrp/RecoveriesPYDistriMinAssetGrp/PriorYearAmt00
IRS990ScheduleA/MinimumAssetAmountGrp/TotalFMVOfNonExemptUseAssetGrp/CurrentYearAmt01885140
IRS990ScheduleA/MinimumAssetAmountGrp/TotalFMVOfNonExemptUseAssetGrp/PriorYearAmt01752866
IRS990ScheduleA/MinimumAssetAmountGrp/TotalMinimumAssetGrp/CurrentYearAmt064990
IRS990ScheduleA/MinimumAssetAmountGrp/TotalMinimumAssetGrp/PriorYearAmt060430
IRS990ScheduleA/OtherSupportSumAmt00
IRS990ScheduleA/SupportedOrganizationsCnt01
IRS990ScheduleA/SupportedOrganizationsTotalCnt01
IRS990ScheduleA/SupportedOrgInformationGrp/EIN0411814223
IRS990ScheduleA/SupportedOrgInformationGrp/GoverningDocumentListedInd0true
IRS990ScheduleA/SupportedOrgInformationGrp/OrganizationTypeCd07
IRS990ScheduleA/SupportedOrgInformationGrp/OtherSupportAmt00
IRS990ScheduleA/SupportedOrgInformationGrp/SupportAmt063881
IRS990ScheduleA/SupportedOrgInformationGrp/SupportedOrganizationName/BusinessNameLine1Txt0CHILDRENS HEALTHCARE FDN
IRS990ScheduleA/SupportingOrganization509a3Ind0X
IRS990ScheduleA/SupportingOrgType3NonFuncInd0X
IRS990ScheduleA/SupportSumAmt063881
IRS990/ScheduleBRequiredInd0false
IRS990ScheduleI/GrantRecordsMaintainedInd0true
IRS990ScheduleI/RecipientTable/CashGrantAmt063881
IRS990ScheduleI/RecipientTable/IRCSectionDesc0501(c)(3)
IRS990ScheduleI/RecipientTable/PurposeOfGrantTxt0PHYSICIANS ARE SELECTED BY THE GRANTEE FOR THE SCHOLARSHIPS SOLELY FOR THEIR WORK AT CHILDREN'S HOSPITAL, ST. PAUL, MINNESOTA
IRS990ScheduleI/RecipientTable/RecipientBusinessName/BusinessNameLine1Txt0CHILDREN'S HEALTH CARE FOUNDATION
IRS990ScheduleI/RecipientTable/RecipientEIN0411814223
IRS990ScheduleI/RecipientTable/USAddress/AddressLine1Txt02910 CENTRE POINTE DRIVE
IRS990ScheduleI/RecipientTable/USAddress/CityNm0ROSEVILLE
IRS990ScheduleI/RecipientTable/USAddress/StateAbbreviationCd0MN
IRS990ScheduleI/RecipientTable/USAddress/ZIPCd055113
IRS990ScheduleI/SupplementalInformationDetail/ExplanationTxt0DETAILED SCHOLARSHIP REPORTS ANNUALLY, ANNUAL REPORTS FROM THE GRANTEE, SITE VISITS, AND MEETINGS
IRS990ScheduleI/SupplementalInformationDetail/FormAndLineReferenceDesc0EXPLANATION FOR FORM 990, SCHEDULE I, PART 1, LINE 2
IRS990ScheduleI/Total501c3OrgCnt01
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
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/DivRelatedOrganizationInd0false
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/TotalAssetsBOYAmt01731554
IRS990/TotalAssetsEOYAmt01728725
IRS990/TotalAssetsGrp/BOYAmt01731554
IRS990/TotalAssetsGrp/EOYAmt01728725
IRS990/TotalCompGreaterThan150KInd0false
IRS990/TotalEmployeeCnt00
IRS990/TotalFunctionalExpensesGrp/FundraisingAmt00
IRS990/TotalFunctionalExpensesGrp/ManagementAndGeneralAmt023496
IRS990/TotalFunctionalExpensesGrp/ProgramServicesAmt066460
IRS990/TotalFunctionalExpensesGrp/TotalAmt089956
IRS990/TotalGrossUBIAmt00
IRS990/TotalLiabilitiesBOYAmt00
IRS990/TotalLiabilitiesEOYAmt00
IRS990/TotalLiabilitiesGrp/BOYAmt00
IRS990/TotalLiabilitiesGrp/EOYAmt00
IRS990/TotalNetAssetsFundBalanceGrp/BOYAmt01731554
IRS990/TotalNetAssetsFundBalanceGrp/EOYAmt01728725
IRS990/TotalOtherCompensationAmt00
IRS990/TotalProgramServiceExpensesAmt066460
IRS990/TotalReportableCompFromOrgAmt024726
IRS990/TotalRevenueGrp/ExclusionAmt087126
IRS990/TotalRevenueGrp/TotalRevenueColumnAmt087126
IRS990/TotLiabNetAssetsFundBalanceGrp/BOYAmt01731554
IRS990/TotLiabNetAssetsFundBalanceGrp/EOYAmt01728725
IRS990/TotReportableCompRltdOrgAmt00
IRS990/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990/TypeOfOrganizationTrustInd0X
IRS990/UnrelatedBusIncmOverLimitInd0false
IRS990/UponRequestInd0X
IRS990/VotingMembersGoverningBodyCnt01
IRS990/VotingMembersIndependentCnt01
IRS990/WebsiteAddressTxt0N/A
IRS990/WhistleblowerPolicyInd0false
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0U S BANK N A BY
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum06514668040
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-10-18
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/AtSubmissionCreationDeviceId0D15B6E5F7E1F5A63C9C759381E6F3302D40930CB
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId057623ED0AE1821D5CE0A508C54E4C9AF0C12734B
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0155.201.188.27
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/PreparationDt02018-10-18
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0JOSEPH J CASTRIANO
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02018-10-26T09:00:34-05:00
ReturnHeader/ReturnTypeCd0990
ReturnHeader/TaxPeriodBeginDt02017-07-01
ReturnHeader/TaxPeriodEndDt02018-06-30
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$1,728,725
Liabilities
$0
Net assets
$1,728,725
Revenue
$87,126
Expenses
$89,956
Net income
-$2,830
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
2018Detailed filing. Detailed filing data is available for this year.$1.73$0.00$1.73$0.09$0.09$0.00
2017Facts available. Structured filing facts are available, but richer extracted sections are limited.$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