Civic Intelligence

The Merwin Foundation

990PF • Fiscal year 2017 • EIN 36-7699613

Jan 01, 2017 to Dec 31, 2017 • Filed on Jun 18, 2018

Organization Profile
PO Box 1665Bloomington, IL 61702-1665

(309) 664-2135

Siviq Scores

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

Liabilities / Assets

17th percentile

0.00x

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

2017 filings • $5M-$10M nonprofits • Source year 2017

Liabilities / Revenue

Score unavailable

No value available

Liabilities-to-revenue requires both liabilities and revenue on this filing.

Source year 2017

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2017

Top Officer Pay

28th percentile

$0

Higher top officer pay than 28% of similar nonprofits.

2017 filings • $5M-$10M nonprofits • Source year 2017

Asset Growth

Score unavailable

No value available

No earlier valid filing was available within the previous three public years.

Source year 2017

Revenue Growth

Score unavailable

No value available

No earlier valid filing was available within the previous three public years.

Source year 2017

Balance Sheet
Liabilities / Assets17th percentile

Assets

$5,514,595

No earlier filing loaded for comparison.

Net Assets

$5,514,595

No earlier filing loaded for comparison.

Liabilities

$0

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / RevenueScore unavailableNet MarginScore unavailable

Revenue

$0

No earlier filing loaded for comparison.

Expenses

$0

No earlier filing loaded for comparison.

Net Income

$0

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset GrowthScore unavailable

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

$8.0M$6.0M$4.0M$2.0M$0Assets 2017: $5,514,595Liabilities 2017: $0Net Assets 2017: $5,514,5952017Assets 2018: $4,829,822Liabilities 2018: $0Net Assets 2018: $4,829,8222018Assets 2019: $6,072,381Liabilities 2019: $0Net Assets 2019: $6,072,3812019Assets 2020: $5,644,726Liabilities 2020: $0Net Assets 2020: $5,644,7262020Assets 2021: $6,495,199Liabilities 2021: $0Net Assets 2021: $6,495,1992021Assets 2022: $4,498,016Liabilities 2022: $0Net Assets 2022: $4,498,0162022Assets 2023: $5,045,208Liabilities 2023: $0Net Assets 2023: $5,045,2082023Assets 2024: $5,436,676Liabilities 2024: $0Net Assets 2024: $5,436,6762024

Highlighted filing

2017

Assets$5,514,595
Liabilities$0
Net Assets$5,514,595
Open 2017 Filing

Operations Trend

Revenue GrowthScore unavailable

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

$1.0M$500K$0-$500K-$1.0MRevenue 2017: $0Expenses 2017: $0Net Income 2017: $02017Revenue 2018: $21,638Expenses 2018: $344,566Net Income 2018: -$322,9282018Revenue 2019: $247,293Expenses 2019: $301,152Net Income 2019: -$53,8592019Revenue 2020: -$262,666Expenses 2020: $289,284Net Income 2020: -$551,9502020Revenue 2021: $832,109Expenses 2021: $369,901Net Income 2021: $462,2082021Revenue 2022: $69,112Expenses 2022: $736,062Net Income 2022: -$666,9502022Revenue 2023: $100,823Expenses 2023: $434,607Net Income 2023: -$333,7842023Revenue 2024: $199,126Expenses 2024: $392,058Net Income 2024: -$192,9322024

Highlighted filing

2017

Revenue$0
Expenses$0
Net Income$0
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Jun 18, 2018
Return Version
2017v2.3
Compensation and Service Providers
Top Officer Pay28th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
SHARON MERWINPresident-$0--
LAURA REARDONVice-Pres-$0--
GUY FRAKERSec/Treas-$0--
Filing and Contact Details

Filer

Filer Name
The Merwin Foundation
EIN
36-7699613
Phone
3096642135
Address
PO BOX 1665, BLOOMINGTON, IL 61702-1665

Signing Officer

Name
Sharon Merwin
Title
President
Phone
3096642135
Signed
2018-06-18
Discuss with paid preparer
Yes

Preparer

Firm
Graham Newlin LLC
Address
202 N CENTER ST, BLOOMINGTON, IL 61701-3901
Preparer
Bruce W Breitweiser
Phone
3122781130
Raw XML Appendix254 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
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt01
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt1163580
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt2209280
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt3177550
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt4145800
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt5177120
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt6297330
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt7316163
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt873052
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt9166515
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt10252832
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt1153730
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt12267498
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt13113420
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt14323120
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt15192913
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt16213880
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt17158730
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt18162780
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt19176423
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt20109968
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt21225180
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt22180900
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt23222160
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt24167509
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt2584636
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt26220353
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt01
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt1163580
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt2209280
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt3177550
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt4145800
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt5177120
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt6297330
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt7316163
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt873052
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt9166515
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt10252832
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt1153730
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt12267498
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt13113420
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt14323120
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt15192913
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt16213880
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt17158730
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt18162780
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt19176423
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt20109968
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt21225180
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt22180900
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt23222160
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt24167509
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt2584636
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt26220353
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm0ACULON, INC. SERIES B PREFERRED STK
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm1ALLERGAN PLC
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm2ALPHABET INC.
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm3AON
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm4AT&T
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm5BANK OF AMERICA
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm6BERSHIRE HATHAWAY
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm7CBRE GROUP INC
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm8CELGENE CORP
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm9CROWN CASTLE INTL CORP NEW
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm10EATON CORP
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm11GILEAD SCIENCES INC
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm12GOLDMAN SACHS
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm13GRUPO TELEVISA SA SPONS ADR
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm14INTEL CORP
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm15JELD-WEN HOLDINGS
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm16JP MORGAN CHASE & CO
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm17LIBERTY INTERACTIVE CORP QVC GROUP
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm18MARSH & MCLENNAN
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm19MCDONALD'S CORP
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm20METLIFE INC
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm21NIKE INC
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm22PEMBINA PIPELINE
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm23ROBERT HALF INTL INC
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm24VALEO SA
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm25WELBILT INC.
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm26T ROWE PRICE GROUP
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt05514595
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt05514595
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt05514595
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt0251242
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt0251242
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt0251242
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt0251242
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt00
IRS990PF/FMVAssetsEOYAmt05514595
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt04852423
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt04852423
IRS990PF/Form990PFBalanceSheetsGrp/OrganizationFollowsSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt0662172
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt0662172
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt05514595
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt05514595
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt05514595
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt05514595
IRS990PF/Form990PFBalanceSheetsGrp/UnrestrictedEOYAmt05514595
IRS990PF/InitialReturnInd0X
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt05101356
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt01260714
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt03840642
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt076520
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt0251242
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt05024836
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt05101356
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt0000.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt1000.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt2000.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0SHARON MERWIN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm1LAURA REARDON
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm2GUY FRAKER
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0PRESIDENT
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt1VICE-PRES
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt2SEC/TREAS
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt0PO BOX 1665
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt1PO BOX 1665
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt2101 N MAIN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0BLOOMINGTON
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm1BLOOMINGTON
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm2BLOOMINGTON
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0IL
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd1IL
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd2IL
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd0617021665
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd1617021665
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd261701
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt00
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd0false
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd0false
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd0false
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd0false
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd0false
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd0false
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd0true
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd0false
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd0true
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd0false
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd0false
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd0false
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd0true
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt0PO BOX 1270
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0TULSA
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0OK
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd0741011270
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0IL
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine1Txt0COLORADO STATE BANK AND TRUST
IRS990PF/StatementsRegardingActyGrp/PhoneNum03038647253
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0true
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SumOfProgramRelatedInvstGrp/Description1Txt0N/A
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/LoansOrLoanGuaranteesInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PerformanceOfServicesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PurchaseOfAssetsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/ReimbursementArrangementsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RelationshipsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RentalOfFacilitiesOthAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SalesOrExchangesOfAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SharingOfFacilitiesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd0false
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt0251242
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt0251242
OtherIncreasesSchedule/OtherIncreasesDetail/Amt05514595
OtherIncreasesSchedule/OtherIncreasesDetail/Desc0TRANSFER FROM EIN 37-1401906
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0SHARON MERWIN
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum03096642135
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-06-18
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0THE MERWIN FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0MERW
ReturnHeader/Filer/EIN0367699613
ReturnHeader/Filer/PhoneNum03096642135
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 1665
ReturnHeader/Filer/USAddress/CityNm0BLOOMINGTON
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IL
ReturnHeader/Filer/USAddress/ZIPCd0617021665
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId09FAAF1616B4CCCDB4442939EE88CB87B1EA87359
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId09FAAF1616B4CCCDB4442939EE88CB87B1EA87359
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0167.68.16.49
ReturnHeader/FilingSecurityInformation/IPDt02018-06-21
ReturnHeader/FilingSecurityInformation/IPTm010:02:32
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0464411427
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0GRAHAM NEWLIN LLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0202 N CENTER ST
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0BLOOMINGTON
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0617013901
ReturnHeader/PreparerPersonGrp/PhoneNum03122781130
ReturnHeader/PreparerPersonGrp/PreparationDt02018-06-21
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0BRUCE W BREITWEISER
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02018-06-21T12:05:36-05:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02017-01-01
ReturnHeader/TaxPeriodEndDt02017-12-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$5,514,595
Liabilities
$0
Net assets
$5,514,595
Revenue
$0
Expenses
$0
Net income
$0
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$5.44$0.00$5.44$0.20$0.39$0.19
2023Detailed filing. Detailed filing data is available for this year.$5.05$0.00$5.05$0.10$0.43$0.33
2022Detailed filing. Detailed filing data is available for this year.$4.50$0.00$4.50$0.07$0.74$0.67
2021Detailed filing. Detailed filing data is available for this year.$6.50$0.00$6.50$0.83$0.37$0.46
2020Detailed filing. Detailed filing data is available for this year.$5.64$0.00$5.64$0.26$0.29$0.55
2019Detailed filing. Detailed filing data is available for this year.$6.07$0.00$6.07$0.25$0.30$0.05
2018Detailed filing. Detailed filing data is available for this year.$4.83$0.00$4.83$0.02$0.34$0.32
2017Detailed filing. Detailed filing data is available for this year.$5.51$0.00$5.51$0.00$0.00$0.00