Civic Intelligence

Ruth Lilly Philanthropic Foundation

990T • Fiscal year 2020 • EIN 34-7206415

Jan 01, 2020 to Dec 31, 2020 • Filed on Nov 12, 2021

2751 Centerville Rd Ste 400Wilmington, DE 19808

(302) 246-5400

Siviq Scores

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

Liabilities / Assets

Score unavailable

No value available

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

Source year 2020

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2020

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2020

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2020

Asset Growth

Score unavailable

No value available

No valid filing value is available for this score.

Revenue Growth

Score unavailable

No value available

No valid filing value is available for this score.

Assets

-

No earlier filing loaded for comparison.

Net Assets

-

No earlier filing loaded for comparison.

Liabilities

-

No earlier filing loaded for comparison.

Revenue

-

No earlier filing loaded for comparison.

Expenses

-

No earlier filing loaded for comparison.

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

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

$150M$100M$50M$0Assets 2011: $94,148,666Liabilities 2011: $0Net Assets 2011: $94,148,6662011Assets 2012: $147,668,468Liabilities 2012: $0Net Assets 2012: $147,668,4682012Assets 2013: $140,551,829Liabilities 2013: $0Net Assets 2013: $140,551,8292013Assets 2020: $86,361,476Liabilities 2020: $0Net Assets 2020: $86,361,4762020Assets 2021: $89,481,864Liabilities 2021: $0Net Assets 2021: $89,481,8642021Assets 2022: $87,606,517Liabilities 2022: $0Net Assets 2022: $87,606,5172022Assets 2023: $87,032,273Liabilities 2023: $0Net Assets 2023: $87,032,2732023Assets 2024: $90,591,775Liabilities 2024: $0Net Assets 2024: $90,591,7752024

Latest loaded filing

2024

Assets$90,591,775
Liabilities$0
Net Assets$90,591,775

Operations Trend

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

$20M$10M$0-$10MExpenses 2011: $17,084,4182011Expenses 2012: $17,114,2382012Revenue 2013: $10,817,905Expenses 2013: $19,217,242Net Income 2013: -$8,399,3372013Revenue 2020: $5,779,951Expenses 2020: $9,505,250Net Income 2020: -$3,725,2992020Revenue 2021: $12,222,478Expenses 2021: $8,588,222Net Income 2021: $3,634,2562021Revenue 2022: $6,093,112Expenses 2022: $7,715,353Net Income 2022: -$1,622,2412022Revenue 2023: $5,034,545Expenses 2023: $5,906,166Net Income 2023: -$871,6212023Revenue 2024: $7,656,153Expenses 2024: $7,089,749Net Income 2024: $566,4042024

Latest loaded filing

2024

Revenue$7,656,153
Expenses$7,089,749
Net Income$566,404
Jump To
Filing Snapshot
Filing Period
Jan 1, 2020 to Dec 31, 2020
Signed
Nov 12, 2021
Return Version
2020v1.1
Filing and Contact Details

Filer

Filer Name
Ruth Lilly Foundation
EIN
34-7206415
Phone
3022465400
Address
2751 CENTERVILLE RD STE 400, WILMINGTON, DE 19808

Signing Officer

Name
Arden Trust Company
Title
Trustee
Phone
3022465400
Signed
2021-11-12
Discuss with paid preparer
Yes

Preparer

Firm
Pricewaterhousecoopers Llp
Address
301 GRANT STREET45TH FLOOR, PITTSBURGH, PA 15219
Preparer
Shawn P Hanlon
Phone
4123556000
Raw XML Appendix64 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
IRS990T/BalanceDueAmt00
IRS990T/BooksInCareOfDetail/PersonNm0ARDEN TRUST
IRS990T/BooksInCareOfDetail/PhoneNum03022465400
IRS990T/BooksInCareOfDetail/USAddress/AddressLine1Txt02751 CENTERVILLE RD STE 400
IRS990T/BooksInCareOfDetail/USAddress/CityNm0WILMINGTON
IRS990T/BooksInCareOfDetail/USAddress/StateAbbreviationCd0DE
IRS990T/BooksInCareOfDetail/USAddress/ZIPCd019808
IRS990T/BookValueAssetsEOYAmt086361476
IRS990T/ChangeInMethodOfAccountingInd0false
IRS990T/ForeignAccountsQuestionInd0false
IRS990T/ForeignTrustQuestionInd0false
IRS990T/Form990TScheduleAAttachedCnt01
IRS990T/Organization501cTrustInd0X
IRS990T/Organization501IndicatorGrp/Organization501cTypeTxt0c3
IRS990T/Organization501IndicatorGrp/Organization501Ind0X
IRS990TScheduleA/CapitalGainNetIncomeAmt00
IRS990TScheduleA/NetOperatingLossDeductionAmt051101
IRS990TScheduleA/PrincipalBusinessActivityCd0900099
IRS990TScheduleA/SequenceReferenceNum01
IRS990TScheduleA/SequenceTotalNum01
IRS990TScheduleA/TotalPrtshpSCorpIncomeAmt051101
IRS990TScheduleA/TotNetUnrltTrdBusIncmAmt051101
IRS990TScheduleA/TotUnrltTrdBusIncmAmt051101
IRS990TScheduleA/TotUnrltTrdBusIncmExpnssAmt00
IRS990TScheduleA/TradeOrBusinessDesc0PUBLICLY TRADED PARTNERSHIPS
IRS990TScheduleA/UBIBeforeNOLDedAmt051101
IRS990T/SpecificDeductionAmt01000
IRS990T/SubsidiaryCorporationInd0false
IRS990T/TaxableTrustAmt00
IRS990T/TaxLessCreditsAmt00
IRS990T/TaxRateScheduleInd0X
IRS990T/TotalDeductionAmt01000
IRS990T/TotalTaxAmt00
IRS990T/TotalTaxComputationAmt00
IRS990T/TotalUBTIAmt00
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0ARDEN TRUST COMPANY
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum03022465400
ReturnHeader/BusinessOfficerGrp/SignatureDt02021-11-12
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0RUTH LILLY FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0LILL
ReturnHeader/Filer/EIN0347206415
ReturnHeader/Filer/PhoneNum03022465400
ReturnHeader/Filer/USAddress/AddressLine1Txt02751 CENTERVILLE RD STE 400
ReturnHeader/Filer/USAddress/CityNm0WILMINGTON
ReturnHeader/Filer/USAddress/StateAbbreviationCd0DE
ReturnHeader/Filer/USAddress/ZIPCd019808
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0134008324
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0PRICEWATERHOUSECOOPERS LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0301 GRANT STREET45TH FLOOR
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0PITTSBURGH
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0PA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd015219
ReturnHeader/PreparerPersonGrp/PhoneNum04123556000
ReturnHeader/PreparerPersonGrp/PreparationDt02021-11-12
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0SHAWN P HANLON
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02021-11-15T09:00:18-06:00
ReturnHeader/ReturnTypeCd0990T
ReturnHeader/TaxPeriodBeginDt02020-01-01
ReturnHeader/TaxPeriodEndDt02020-12-31
ReturnHeader/TaxYr02020

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings