Civic Intelligence

Cern Foundation

990PF • Fiscal year 2019 • EIN 26-3525721

Jan 01, 2019 to Dec 31, 2019 • Filed on Jul 16, 2020

Organization Profile
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

69th percentile

0.01x

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

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

Liabilities / Revenue

77th percentile

0.04x

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

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

Net Margin

10th percentile

-54%

Higher net margin than 10% of similar nonprofits.

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

Top Officer Pay

88th percentile

$24,039

Higher top officer pay than 88% of similar nonprofits.

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

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

Asset Growth

23rd percentile

-14%

Faster asset growth than 23% of similar nonprofits.

2019 filings • <$500k nonprofits • Annualized from 2018 to 2019

Revenue Growth

8th percentile

-61%

Faster revenue growth than 8% of similar nonprofits.

2019 filings • <$500k nonprofits • Annualized from 2018 to 2019

Balance Sheet
Liabilities / Assets69th percentile

Assets

Down

$473,796

Down $77,734 (-14%) from 2018

Net Assets

Down

$467,884

Down $78,742 (-14%) from 2018

Liabilities

Up

$5,912

Up $1,008 (+21%) from 2018

Revenue And Expenses
Liabilities / Revenue77th percentileNet Margin10th percentile

Revenue

Down

$146,605

Down $227,377 (-61%) from 2018

Expenses

Down

$225,347

Down $88,150 (-28%) from 2018

Net Income

Down

-$78,742

Down $139,227 (-230%) from 2018

Historical Trend

Balance Sheet Trend

Asset Growth23rd percentile

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

2019

Assets$473,796
Liabilities$5,912
Net Assets$467,884
Open 2019 Filing

Operations Trend

Revenue Growth8th percentile

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

2019

Revenue$146,605
Expenses$225,347
Net Income-$78,742
Open 2019 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2019 to Dec 31, 2019
Signed
Jul 16, 2020
Return Version
2019v5.1
Compensation and Service Providers
Top Officer Pay88th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
Chas HaynesExecutive DirectorPT$24,039-$24,039
Kimberly WallgrenPresident/Chairperson Of The BoardPT$20,069-$20,069
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--
Grants and Assistance

Foundation Grants and Related Investments

TypeRecipientPurposeStatusLocationAmount
Paid GrantUniversity HeidelbergCancer ResearchPOFHeidelberg, GM$50,000
Paid GrantUniversity of CambridgeCancer ResearchPOFCambridge, UK$50,000
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
2020-07-16
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 Appendix334 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/Amt0780
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0Intuit - Accounting Software
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt0780
IRS990PF/AnalysisIncomeProducingActyGrp/OtherRevenueDescribedGrp/Desc0Contributions, Gifts, Grants, Etc
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesChrtblPrpsAmt0780
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt0780
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt044108
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt044108
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt0100000
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt0100000
IRS990PF/AnalysisOfRevenueAndExpenses/ContriRcvdRevAndExpnssAmt0146605
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-78742
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesDsbrsChrtblAmt060575
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt060575
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblAmt03607
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt03607
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt0225347
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt0225347
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt0146605
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt0125347
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt0125347
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingDsbrsChrtblAmt016277
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingRevAndExpnssAmt016277
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-78742
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0467884
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0546626
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0467884
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt024291
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt024291
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt024291
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt024291
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt00
IRS990PF/FMVAssetsEOYAmt0469006
IRS990PF/Form990PFBalanceSheetsGrp/AccountsPayableBOYAmt04904
IRS990PF/Form990PFBalanceSheetsGrp/AccountsPayableEOYAmt05912
IRS990PF/Form990PFBalanceSheetsGrp/CashBOYAmt0547143
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYAmt0464619
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYFMVAmt0464619
IRS990PF/Form990PFBalanceSheetsGrp/DonorRstrNetAssetsBOYAmt050000
IRS990PF/Form990PFBalanceSheetsGrp/NoDonorRstrNetAssestsBOYAmt0496626
IRS990PF/Form990PFBalanceSheetsGrp/NoDonorRstrNetAssestsEOYAmt0467884
IRS990PF/Form990PFBalanceSheetsGrp/OrganizationFollowsFASB117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherAssetsEOYAmt04790
IRS990PF/Form990PFBalanceSheetsGrp/PrepaidExpensesBOYAmt04387
IRS990PF/Form990PFBalanceSheetsGrp/PrepaidExpensesEOYAmt04387
IRS990PF/Form990PFBalanceSheetsGrp/PrepaidExpensesEOYFMVAmt04387
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0551530
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0473796
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0469006
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt04904
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt05912
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0551530
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0473796
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0546626
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0467884
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0493224
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt0493224
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt00
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt07398
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt024291
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0485826
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0493224
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/CompensationAmt024039
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt120069
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/TotalAmt00
IRS990PF/PrivateOperatingFoundationsGrp/PrivateOperatingFndtnRulingDt02016-03-02
IRS990PF/PrivateOperatingFoundationsGrp/QualifyingDistributionsGrp/CurrentYearAmt0225347
IRS990PF/PrivateOperatingFoundationsGrp/QualifyingDistributionsGrp/TotalAmt01132356
IRS990PF/PrivateOperatingFoundationsGrp/QualifyingDistributionsGrp/Year1Amt0313497
IRS990PF/PrivateOperatingFoundationsGrp/QualifyingDistributionsGrp/Year2Amt0319913
IRS990PF/PrivateOperatingFoundationsGrp/QualifyingDistributionsGrp/Year3Amt0273599
IRS990PF/PrivateOperatingFoundationsGrp/QualifyingDistriMadeDrtGrp/CurrentYearAmt0225347
IRS990PF/PrivateOperatingFoundationsGrp/QualifyingDistriMadeDrtGrp/TotalAmt01132356
IRS990PF/PrivateOperatingFoundationsGrp/QualifyingDistriMadeDrtGrp/Year1Amt0313497
IRS990PF/PrivateOperatingFoundationsGrp/QualifyingDistriMadeDrtGrp/Year2Amt0319913
IRS990PF/PrivateOperatingFoundationsGrp/QualifyingDistriMadeDrtGrp/Year3Amt0273599
IRS990PF/PrivateOperatingFoundationsGrp/Section4942j3Ind0X
IRS990PF/PrivateOperatingFoundationsGrp/TotalAssetsGrp/TotalAmt0467128
IRS990PF/PrivateOperatingFoundationsGrp/TotalAssetsGrp/Year3Amt0467128
IRS990PF/PrivateOperatingFoundationsGrp/TotalAssetsSect4942j3BiGrp/TotalAmt0467128
IRS990PF/PrivateOperatingFoundationsGrp/TotalAssetsSect4942j3BiGrp/Year3Amt0467128
IRS990PF/PrivateOperatingFoundationsGrp/TwoThirdsMinimumInvstRetGrp/CurrentYearAmt016194
IRS990PF/PrivateOperatingFoundationsGrp/TwoThirdsMinimumInvstRetGrp/TotalAmt061262
IRS990PF/PrivateOperatingFoundationsGrp/TwoThirdsMinimumInvstRetGrp/Year1Amt015997
IRS990PF/PrivateOperatingFoundationsGrp/TwoThirdsMinimumInvstRetGrp/Year2Amt015751
IRS990PF/PrivateOperatingFoundationsGrp/TwoThirdsMinimumInvstRetGrp/Year3Amt013320
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt0313497
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt0319913
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt0273599
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt0246673
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt0285992
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt0000000.915747
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt0000000.653244
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt0000000.677002
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt0000000.684679
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt0000001.338534
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt0000001.225277
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt0479908
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt0472544
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt0399602
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt0184286
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt0233410
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt0000004.578736
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt0225347
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt0225347
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt0225347
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/SubjToTaxRmnrtnExPrchtPymtInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd0false
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd0false
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd0true
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd0false
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd0false
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd0false
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd0false
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd0false
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd0true
IRS990PF/StatementsRegardingActyGrp/IndividualWithBooksNm0Jake Wallgren
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt02814 E High Grove Cir
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0Zionsville
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0IN
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd046077
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/Section508eRqrSatisfiedInd0false
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/Expenses1Amt0225347
IRS990PF/SupplementaryInformationGrp/ContributingManagerNm0None
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt050000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt150000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0Cancer Research
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1Cancer Research
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt0University Heidelberg
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt1University of Cambridge
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientForeignAddress/AddressLine1Txt0Grabengasse 1
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientForeignAddress/AddressLine1Txt1Trinity Lane
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientForeignAddress/CityNm0Heidelberg
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientForeignAddress/CityNm1Cambridge
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientForeignAddress/CountryCd0GM
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientForeignAddress/CountryCd1UK
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientForeignAddress/ForeignPostalCd069117
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientForeignAddress/ForeignPostalCd1CB21TN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0POF
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt1POF
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0Grantee
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt1Grantee
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/ShareholderManagerNm0None
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt0100000
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/AppliedToCurrentYearAmt024291
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt024291
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr1Amt0289502
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr5Amt024321
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt024321
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt0490558
IRS990PF/UndistributedIncomeGrp/ExcessFromCurrentYearAmt0201056
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt0289502
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt0225347
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt0201056
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt0514879
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt0313823
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
IRS990ScheduleB/Organization501c3ExemptPFInd0X
OtherAssetsSchedule/OtherAssetsScheduleGrp/Desc0Software
OtherAssetsSchedule/OtherAssetsScheduleGrp/EOYBookValueAmt04790
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0Marketing and Promotional Materials
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/Desc9Consulting Fees
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt010908
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt11046
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt25203
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt3807
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt4681
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt53359
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt61072
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt7222
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt895
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt937182
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt010908
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt11046
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt25203
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt3807
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt4681
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt53359
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt61072
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt7222
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt895
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt937182
TaxesSchedule/TaxesDetail/Amt03407
TaxesSchedule/TaxesDetail/Amt1200
TaxesSchedule/TaxesDetail/CategoryTxt0Payroll Taxes
TaxesSchedule/TaxesDetail/CategoryTxt1Treasurer State of Ohio
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt03407
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt1200
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0Jake Wallgren
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Chief Financial Officer
ReturnHeader/BusinessOfficerGrp/SignatureDt02020-07-16
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/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/PreparationDt02020-07-16
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Mary M Lett
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02020-07-16T01:30:46-00:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02019-01-01
ReturnHeader/TaxPeriodEndDt02019-12-31
ReturnHeader/TaxYr02019

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$473,796
Liabilities
$5,912
Net assets
$467,884
Revenue
$146,605
Expenses
$225,347
Net income
-$78,742
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2020Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.27$0.67$0.41
2019Detailed filing. Detailed filing data is available for this year.$4.74$0.06$4.68$1.47$2.25$0.79
2018Detailed filing. Detailed filing data is available for this year.$5.52$0.05$5.47$3.74$3.13$0.60
2017Detailed filing. Detailed filing data is available for this year.$4.89$0.02$4.86$3.40$3.20$0.20
2016Detailed filing. Detailed filing data is available for this year.$4.67$0.01$4.66$3.75$2.74$1.01