Civic Intelligence

Cern Foundation

990PF • Fiscal year 2017 • EIN 26-3525721

Jan 01, 2017 to Dec 31, 2017 • Filed on May 14, 2018

PO Box 217Zionsville, IN 46077

(513) 289-3440

Siviq Scores

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

Liabilities / Assets

63rd percentile

0.01x

Higher debt load relative to assets than 63% of similar nonprofits.

2017 filings • <$500k nonprofits • Source year 2017

Liabilities / Revenue

64th percentile

0.01x

Higher debt load relative to revenue than 64% of similar nonprofits.

2017 filings • <$500k nonprofits • Source year 2017

Net Margin

56th percentile

5.8%

Higher net margin than 56% of similar nonprofits.

2017 filings • <$500k nonprofits • Source year 2017

Top Officer Pay

88th percentile

$25,000

Higher top officer pay than 88% of similar nonprofits.

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

2017 filings • <$500k nonprofits • Source year 2017

Asset Growth

57th percentile

4.6%

Faster asset growth than 57% of similar nonprofits.

2017 filings • <$500k nonprofits • Annualized from 2016 to 2017

Revenue Growth

33rd percentile

-9.3%

Faster revenue growth than 33% of similar nonprofits.

2017 filings • <$500k nonprofits • Annualized from 2016 to 2017

Assets

Up

$488,589

Up $21,461 (+4.6%) from 2016

Net Assets

Up

$486,141

Up $19,702 (+4.2%) from 2016

Liabilities

Up

$2,448

Up $1,759 (+255%) from 2016

Revenue

Down

$339,615

Down $34,964 (-9.3%) from 2016

Expenses

Up

$319,913

Up $46,314 (+17%) from 2016

Net Income

Down

$19,702

Down $81,278 (-80%) from 2016

Historical Trend

Balance Sheet Trend

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

$600K$400K$200K$0Assets 2016: $467,128Liabilities 2016: $689Net Assets 2016: $466,4392016Assets 2017: $488,589Liabilities 2017: $2,448Net Assets 2017: $486,1412017Assets 2018: $551,530Liabilities 2018: $4,904Net Assets 2018: $546,6262018Assets 2019: $473,796Liabilities 2019: $5,912Net Assets 2019: $467,8842019Assets 2020: $0Liabilities 2020: $0Net Assets 2020: $02020

Highlighted filing

2017

Assets$488,589
Liabilities$2,448
Net Assets$486,141

Operations Trend

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

$400K$200K$0-$200KRevenue 2016: $374,579Expenses 2016: $273,599Net Income 2016: $100,9802016Revenue 2017: $339,615Expenses 2017: $319,913Net Income 2017: $19,7022017Revenue 2018: $373,982Expenses 2018: $313,497Net Income 2018: $60,4852018Revenue 2019: $146,605Expenses 2019: $225,347Net Income 2019: -$78,7422019Revenue 2020: $26,599Expenses 2020: $67,417Net Income 2020: -$40,8182020

Highlighted filing

2017

Revenue$339,615
Expenses$319,913
Net Income$19,702
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
May 14, 2018
Return Version
2017v2.3
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
Chas HaynesExecutive DirectorPT$25,000-$25,000
Kimberly WallgrenPresident/Chairperson Of The BoardPT$12,500-$12,500
Dallas MathileVice President-$0--
Janice MathileVice President-$0--
Jake WallgrenCFO/TreasurerPT$0--
Donna TweelSecretary-$0--
Diane HirakawaBoard Of Trustees-$0--
Terri ArmstrongBoard Of TrusteesPT$0--
Filing and Contact Details

Filer

Filer Name
CERN Foundation
EIN
26-3525721
Phone
5132893440
Address
PO Box 217, Zionsville, IN 46077

Signing Officer

Name
Jake Wallgren
Title
Chief Financial Officer
Signed
2018-05-14
Discuss with paid preparer
Yes

Preparer

Firm
M M Lett Associates
Address
3480 E Fall Creek Pkwy N Dr, Indianapolis, IN 46205
Preparer
Mary M Lett
Phone
3179029892
Raw XML Appendix381 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
AccountingFeesSchedule/AccountingFeesDetail/Amt02500
AccountingFeesSchedule/AccountingFeesDetail/Amt1585
AccountingFeesSchedule/AccountingFeesDetail/Amt2484
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0Brixey Meyer - Accounting Services
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt1Marty Weaver - Accounting Services
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt2Intuit - Accounting Software
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt02500
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt1585
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt2484
GeneralExplanationAttachment/GeneralExplanationGrp/FormAndLineReferenceDesc0Enter election title here Election for Treatment of Unused Prior Year Corpus Distributions Pursuant
GeneralExplanationAttachment/GeneralExplanationGrp/MediumExplanationTxt0Enter election title here Election for Treatment of Unused Prior Year Corpus Distributions Pursuant to IRC Section 4942g)3) and Reg. 53.4942a)3c)2)iv) the Foundation elects to treat unused prior tax years distributions that were treated as corpus distributions from corpus in the current tax year. Enter statement title here CERN Foundation Distributions out of Corpus Election FEIN XXX-XX-XXXX Tax Year Ending 12/31/17 Pursuant to Reg. Sec. 53.4942a)3c)2) the CERN Foundation hereby elects to treat 195000 as distributions out of corpus to satisfy the requirement of Sec. 4942g)3).
IRS990PF/AnalysisIncomeProducingActyGrp/OtherRevenueDescribedGrp/Desc0Contributions, Gifts, Grants, Etc
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesChrtblPrpsAmt03569
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt03569
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt037500
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt037500
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt0187000
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt0187000
IRS990PF/AnalysisOfRevenueAndExpenses/ContriRcvdRevAndExpnssAmt0339615
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt019702
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesDsbrsChrtblAmt033710
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt033710
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesDsbrsChrtblAmt037614
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesRevAndExpnssAmt037614
IRS990PF/AnalysisOfRevenueAndExpenses/PrintingAndPubDsbrsChrtblAmt06452
IRS990PF/AnalysisOfRevenueAndExpenses/PrintingAndPubRevAndExpnssAmt06452
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblAmt02969
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt02969
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt0319913
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt0319913
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt0339615
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt0132913
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt0132913
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingDsbrsChrtblAmt011099
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingRevAndExpnssAmt011099
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt019702
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0486141
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0466439
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0486141
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt00
IRS990PF/DistributableAmountGrp/Sect4942j3j5FndtnAndFrgnOrgInd0X
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt00
IRS990PF/FMVAssetsEOYAmt0488589
IRS990PF/Form990PFBalanceSheetsGrp/AccountsPayableBOYAmt0689
IRS990PF/Form990PFBalanceSheetsGrp/AccountsPayableEOYAmt02448
IRS990PF/Form990PFBalanceSheetsGrp/CashBOYAmt0467128
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYAmt0483589
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYFMVAmt0483589
IRS990PF/Form990PFBalanceSheetsGrp/OrganizationFollowsSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/PrepaidExpensesEOYAmt05000
IRS990PF/Form990PFBalanceSheetsGrp/PrepaidExpensesEOYFMVAmt05000
IRS990PF/Form990PFBalanceSheetsGrp/TemporarilyRestrictedBOYAmt014745
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0467128
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0488589
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0488589
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt0689
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt02448
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0467128
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0488589
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0466439
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0486141
IRS990PF/Form990PFBalanceSheetsGrp/UnrestrictedBOYAmt0451694
IRS990PF/Form990PFBalanceSheetsGrp/UnrestrictedEOYAmt0486141
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0479740
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt0479740
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt00
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt07196
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt023627
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0472544
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0479740
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt0005.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt1020.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt2001.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt3001.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt4005.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt5001.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt6001.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt7005.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt025000
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt112500
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt30
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt40
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt50
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt60
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt70
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0Chas Haynes
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm1Kimberly Wallgren
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm2Dallas Mathile
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm3Janice Mathile
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm4Jake Wallgren
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm5Donna Tweel
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm6Diane Hirakawa
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm7Terri Armstrong
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0Executive Director
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt1President/Chairperson of the Board
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt2Vice President
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt3Vice President
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt4CFO/Treasurer
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt5Secretary
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt6Board of Trustees
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt7Board of Trustees
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt0PO Box 217
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt1PO Box 217
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt2PO Box 217
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt3PO Box 217
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt4PO Box 217
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt5PO Box 217
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt6PO Box 217
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt7PO Box 217
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0Zionsville
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm1Zionsville
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm2Zionsville
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm3Zionsville
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm4Zionsville
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm5Zionsville
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm6Zionsville
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm7Zionsville
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0IN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd1IN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd2IN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd3IN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd4IN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd5IN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd6IN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd7IN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd046077
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd146077
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd246077
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd346077
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd446077
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd546077
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd646077
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd746077
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/PrivateOperatingFoundationsGrp/LessorAdjNetIncmMinInvstRetGrp/CurrentYearAmt00
IRS990PF/PrivateOperatingFoundationsGrp/LessorAdjNetIncmMinInvstRetGrp/TotalAmt011671
IRS990PF/PrivateOperatingFoundationsGrp/LessorAdjNetIncmMinInvstRetGrp/Year3Amt011671
IRS990PF/PrivateOperatingFoundationsGrp/Pct85LessorAdjIncmOrMinRetGrp/TotalAmt09920
IRS990PF/PrivateOperatingFoundationsGrp/Pct85LessorAdjIncmOrMinRetGrp/Year3Amt09920
IRS990PF/PrivateOperatingFoundationsGrp/PrivateOperatingFndtnRulingDt02016-03-02
IRS990PF/PrivateOperatingFoundationsGrp/QualifyingDistributionsGrp/CurrentYearAmt0319913
IRS990PF/PrivateOperatingFoundationsGrp/QualifyingDistributionsGrp/TotalAmt01063790
IRS990PF/PrivateOperatingFoundationsGrp/QualifyingDistributionsGrp/Year1Amt0273599
IRS990PF/PrivateOperatingFoundationsGrp/QualifyingDistributionsGrp/Year2Amt0184286
IRS990PF/PrivateOperatingFoundationsGrp/QualifyingDistributionsGrp/Year3Amt0285992
IRS990PF/PrivateOperatingFoundationsGrp/QualifyingDistriMadeDrtGrp/CurrentYearAmt0319913
IRS990PF/PrivateOperatingFoundationsGrp/QualifyingDistriMadeDrtGrp/TotalAmt01063790
IRS990PF/PrivateOperatingFoundationsGrp/QualifyingDistriMadeDrtGrp/Year1Amt0273599
IRS990PF/PrivateOperatingFoundationsGrp/QualifyingDistriMadeDrtGrp/Year2Amt0184286
IRS990PF/PrivateOperatingFoundationsGrp/QualifyingDistriMadeDrtGrp/Year3Amt0285992
IRS990PF/PrivateOperatingFoundationsGrp/Section4942j3Ind0X
IRS990PF/PrivateOperatingFoundationsGrp/TotalAssetsGrp/TotalAmt0996382
IRS990PF/PrivateOperatingFoundationsGrp/TotalAssetsGrp/Year1Amt0467128
IRS990PF/PrivateOperatingFoundationsGrp/TotalAssetsGrp/Year2Amt0343565
IRS990PF/PrivateOperatingFoundationsGrp/TotalAssetsGrp/Year3Amt0185689
IRS990PF/PrivateOperatingFoundationsGrp/TotalAssetsSect4942j3BiGrp/TotalAmt0996382
IRS990PF/PrivateOperatingFoundationsGrp/TotalAssetsSect4942j3BiGrp/Year1Amt0467128
IRS990PF/PrivateOperatingFoundationsGrp/TotalAssetsSect4942j3BiGrp/Year2Amt0343565
IRS990PF/PrivateOperatingFoundationsGrp/TotalAssetsSect4942j3BiGrp/Year3Amt0185689
IRS990PF/PrivateOperatingFoundationsGrp/TwoThirdsMinimumInvstRetGrp/CurrentYearAmt015751
IRS990PF/PrivateOperatingFoundationsGrp/TwoThirdsMinimumInvstRetGrp/TotalAmt029071
IRS990PF/PrivateOperatingFoundationsGrp/TwoThirdsMinimumInvstRetGrp/Year1Amt013320
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt0273599
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt0246673
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt0285992
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt0362680
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt0396919
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt0002.527318
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt0000.684679
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt0001.338534
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt0001.225277
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt0005.647110
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt0003.740990
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt0399602
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt0184286
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt0233410
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt064224
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt0106100
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt0012.636590
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt0319913
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt0319913
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt0319913
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/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/IndividualWithBooksNm0Jake Wallgren
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt02814 E High Grove Cir
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0Zionsville
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0IN
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd046077
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0IN
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd1OH
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd2TX
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PhoneNum05132893440
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0true
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0true
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0www.cern-foundation.org
IRS990PF/SummaryOfDirectChrtblActyGrp/Description1Txt0The Cern Foundation is working to develop new treatments for ependymoma, thereby improving the ourtcomes and care of patients and, ultimately, leading to a cure. Cern's research focuses on the following main projects: clinical trials, tumor profiling and pathalogy, developmental therapeutics and tumor stem cell and laboratory model.
IRS990PF/SummaryOfDirectChrtblActyGrp/Expenses1Amt0319913
IRS990PF/SupplementaryInformationGrp/ContributingManagerNm0None
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt085000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt150000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt252000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0Ependymoma Research
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1Outcomes
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt2Brain Nervous System Advancement
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt0University of Texas
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt1The Hospital for Sick Children
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt2NOBNCI
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientForeignAddress/AddressLine1Txt0555 University Ave
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientForeignAddress/CityNm0Toronto
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientForeignAddress/CountryCd0CA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0POF
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt1POF
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt2POF
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0Grantee
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt1Grantee
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt2Grantee
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt06431 Fannin
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt1Building 82 Rm 225
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0Houston
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm1Bethesda
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0TX
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd1MD
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd077030
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd1208928202
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/ShareholderManagerNm0None
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt0187000
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/TransferScheduleDetail/NoncharitableExemptOrgName/BusinessNameLine1Txt0NA
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd0false
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt0195000
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr3Amt024321
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr5Amt0297979
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt0322300
IRS990PF/UndistributedIncomeGrp/ExcessFromYear3Amt024321
IRS990PF/UndistributedIncomeGrp/ExcessFromYear4Amt0297979
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt0322300
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt0322300
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
IRS990ScheduleB/ContributorInformationGrp/ContributorNum01
IRS990ScheduleB/ContributorInformationGrp/ContributorNum12
IRS990ScheduleB/ContributorInformationGrp/ContributorPersonNm0Mathile Family Foundation
IRS990ScheduleB/ContributorInformationGrp/ContributorPersonNm1The Mathile Philanthropic Trust
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine1Txt06450 Sand Lake Rd Ste 200
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine1Txt16450 Sand Lake Rd Ste 200
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/CityNm0Dayton
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/CityNm1Dayton
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/StateAbbreviationCd0OH
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/StateAbbreviationCd1OH
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/ZIPCd045414
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/ZIPCd145414
IRS990ScheduleB/ContributorInformationGrp/PersonContributionInd0X
IRS990ScheduleB/ContributorInformationGrp/PersonContributionInd1X
IRS990ScheduleB/ContributorInformationGrp/TotalContributionsAmt085000
IRS990ScheduleB/ContributorInformationGrp/TotalContributionsAmt1215000
IRS990ScheduleB/GeneralRuleInd0X
IRS990ScheduleB/Organization501c3ExemptPFInd0X
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0Professional Development Research
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc1Bank Charges
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc2Tech Services Fees
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc3Payroll Service Fees
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc4Office Supplies
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc5Insurance
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc6Postage
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc7Telephone/Internet
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc8Dues Subscription
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc9Misc
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt018266
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt1652
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt29190
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt31020
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt4581
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt53205
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt6460
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt7228
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt895
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt913
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt018266
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt1652
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt29190
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt31020
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt4581
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt53205
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt6460
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt7228
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt895
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt913
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/Amt036694
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/Amt1920
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/CategoryTxt0K Odom Communications - Contract Services
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/CategoryTxt1Brittany Codeiro - Contract Services
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/DisbursementsCharitablePrpsAmt036694
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/DisbursementsCharitablePrpsAmt1920
TaxesSchedule/TaxesDetail/Amt02869
TaxesSchedule/TaxesDetail/Amt1100
TaxesSchedule/TaxesDetail/CategoryTxt0Payroll Taxes
TaxesSchedule/TaxesDetail/CategoryTxt1Treasurer State of Ohio
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt02869
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt1100
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0Jake Wallgren
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Chief Financial Officer
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-05-14
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0CERN Foundation
ReturnHeader/Filer/BusinessNameControlTxt0CERN
ReturnHeader/Filer/EIN0263525721
ReturnHeader/Filer/PhoneNum05132893440
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO Box 217
ReturnHeader/Filer/USAddress/CityNm0Zionsville
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IN
ReturnHeader/Filer/USAddress/ZIPCd046077
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0A539A0976F4B14C08CDD42A6E9E021640BE424A5
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0A539A0976F4B14C08CDD42A6E9E021640BE424A5
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt050.90.182.146
ReturnHeader/FilingSecurityInformation/IPDt02018-05-15
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0ED
ReturnHeader/FilingSecurityInformation/IPTm013:38:16
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0M M Lett Associates
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt03480 E Fall Creek Pkwy N Dr
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Indianapolis
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IN
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd046205
ReturnHeader/PreparerPersonGrp/PhoneNum03179029892
ReturnHeader/PreparerPersonGrp/PreparationDt02018-05-14
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Mary M Lett
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02018-05-14T01:20:33-00: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