Civic Intelligence

John Ruan Foundation Trust

990T • Fiscal year 2022 • EIN 42-6059463

Jul 01, 2021 to Jun 30, 2022 • Filed on Oct 10, 2022

Organization Profile
11207 NW Aurora AvenueUrbandale, IA 50322

(515) 245-2552

Siviq Scores

Scores are not available for this record yet.

Balance Sheet

Assets

-

No earlier filing loaded for comparison.

Net Assets

-

No earlier filing loaded for comparison.

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses

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 2012: $3,847,120Liabilities 2012: $78,3242012Assets 2013: $3,892,047Liabilities 2013: $02013Assets 2014: $4,911,995Liabilities 2014: $125,3952014Assets 2015: $8,277,280Liabilities 2015: $231,0732015Assets 2016: $15,102,093Liabilities 2016: $181,0452016Assets 2020: $100,640,820Liabilities 2020: $02020Assets 2021: $103,561,030Liabilities 2021: $2,276,562Net Assets 2021: $101,284,4682021Assets 2022: $110,876,833Liabilities 2022: $7,935,313Net Assets 2022: $102,941,5202022Assets 2023: $98,778,410Liabilities 2023: $0Net Assets 2023: $98,778,4102023Assets 2024: $99,450,504Liabilities 2024: $0Net Assets 2024: $99,450,5042024Assets 2025: $100,195,996Liabilities 2025: $0Net Assets 2025: $100,195,9962025

Latest loaded filing

2025

Assets$100,195,996
Liabilities$0
Net Assets$100,195,996
Open 2025 Filing

Operations Trend

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

$10M$5.0M$0-$5.0MRevenue 2012: $699,501Expenses 2012: $594,378Net Income 2012: $105,1232012Revenue 2013: $805,051Expenses 2013: $681,800Net Income 2013: $123,2512013Revenue 2014: $1,550,852Expenses 2014: $656,299Net Income 2014: $894,5532014Revenue 2015: $4,177,333Expenses 2015: $917,726Net Income 2015: $3,259,6072015Revenue 2016: $7,757,054Expenses 2016: $882,213Net Income 2016: $6,874,8412016Revenue 2020: $7,281,473Expenses 2020: $5,131,654Net Income 2020: $2,149,8192020Revenue 2021: $6,342,431Expenses 2021: $5,698,783Net Income 2021: $643,6482021Revenue 2022: $7,230,015Expenses 2022: $5,572,963Net Income 2022: $1,657,0522022Revenue 2023: $553,935Expenses 2023: $4,717,045Net Income 2023: -$4,163,1102023Revenue 2024: $5,106,530Expenses 2024: $4,434,436Net Income 2024: $672,0942024Revenue 2025: $5,235,570Expenses 2025: $4,490,078Net Income 2025: $745,4922025

Latest loaded filing

2025

Revenue$5,235,570
Expenses$4,490,078
Net Income$745,492
Open 2025 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2021 to Jun 30, 2022
Signed
Oct 10, 2022
Return Version
2021v4.3
Filing and Contact Details

Filer

Filer Name
John Ruan Foundation Trust
EIN
42-6059463
Phone
5152452552
Address
11207 NW Aurora Avenue, Urbandale, IA 50322

Signing Officer

Name
John Ruan IV
Title
Trustee
Phone
5152452552
Signed
2022-10-10
Discuss with paid preparer
Yes

Preparer

Firm
Eide Bailly LLP
Address
800 Nicollet Mall Ste 1300, Minneapolis, MN 55402-7033
Preparer
Deb Nelson CPA
Phone
6122536500
Raw XML Appendix110 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
IRS1041ScheduleI/AdjAlternativeMinTaxableIncAmt0368400
IRS1041ScheduleI/AdjustedRegularTaxAmt0134256
IRS1041ScheduleI/AdjustedTotalIncomeAmt0368400
IRS1041ScheduleI/AlternativeMinimumTaxAmt00
IRS1041ScheduleI/AlternativeMinTaxableIncomeAmt0368400
IRS1041ScheduleI/EstateOrTrustShrLessExemptAmt0368400
IRS1041ScheduleI/MaximumCapitalGainsOrNetAmt099154
IRS1041ScheduleI/TentativeAlternativeMinTaxAmt099154
IRS990T/AddressChangeInd0X
IRS990T/BalanceDueAmt057955
IRS990T/BooksInCareOfDetail/PersonNm0Tracey Ball
IRS990T/BooksInCareOfDetail/PhoneNum05152452552
IRS990T/BooksInCareOfDetail/USAddress/AddressLine1Txt011207 NW Aurora Avenue
IRS990T/BooksInCareOfDetail/USAddress/CityNm0Urbandale
IRS990T/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IA
IRS990T/BooksInCareOfDetail/USAddress/ZIPCd050322
IRS990T/BookValueAssetsEOYAmt0110876833
IRS990T/ChangeInMethodOfAccountingInd00
IRS990T/CharitableContributionsDedAmt00
IRS990T/ESPenaltyAmt03699
IRS990T/ExtsnRequestIncomeTaxPaidAmt080000
IRS990T/ForeignAccountsQuestionInd00
IRS990T/ForeignTrustQuestionInd00
IRS990T/Form2220AttachedInd0X
IRS990T/Form990TScheduleAAttachedCnt01
IRS990T/Organization501cTrustInd0X
IRS990T/Organization501IndicatorGrp/Organization501cTypeTxt0c3
IRS990T/Organization501IndicatorGrp/Organization501Ind0X
IRS990T/PaidTaxLiabilityAmt00
IRS990TScheduleA/NetOperatingLossDeductionAmt00
IRS990TScheduleA/NetUnrelatedDebtFincdIncmAmt0368400
IRS990TScheduleA/PrincipalBusinessActivityCd0525990
IRS990TScheduleA/SequenceReferenceNum01
IRS990TScheduleA/SequenceTotalNum01
IRS990TScheduleA/TotalAllocableDeductionsAmt04669
IRS990TScheduleA/TotalCtrlOrgDeductionAmt00
IRS990TScheduleA/TotalCtrlOrgPymtGrossIncmAmt00
IRS990TScheduleA/TotalDeductionsAmt00
IRS990TScheduleA/TotalDeductionSetAsidesAmt00
IRS990TScheduleA/TotalDirectAdvertisingCostAmt00
IRS990TScheduleA/TotalDividendsReceivedDedAmt00
IRS990TScheduleA/TotalGrossAdvertisingIncomeAmt00
IRS990TScheduleA/TotalGrossDebtFinancedIncmAmt0373069
IRS990TScheduleA/TotalInvestmentIncomeAmt00
IRS990TScheduleA/TotalRentDeductionsAmt00
IRS990TScheduleA/TotalRentIncomeAmt00
IRS990TScheduleA/TotalUnrelatedBusinessCompAmt00
IRS990TScheduleA/TotExcessReadershipCostsDedAmt00
IRS990TScheduleA/TotNetUnrltTrdBusIncmAmt0368400
IRS990TScheduleA/TotUnrltTrdBusIncmAmt0373069
IRS990TScheduleA/TotUnrltTrdBusIncmExpnssAmt04669
IRS990TScheduleA/TradeOrBusinessDesc0Unrelated Debt Financed Investment Income
IRS990TScheduleA/UBIBeforeNOLDedAmt0368400
IRS990TScheduleA/UnrelatedBusinessTaxblIncmAmt0368400
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/AllocableDeductionAmt04669
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/AverageAcquisitionAdjBasisPct00.05160
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/AverageAcquisitionDebtAmt05532224
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/AverageAdjustedBasisAmt0107155312
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/GrossIncomeAmt07230015
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/GrossIncomeReportableAmt0373069
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/OtherDebtFinancedDeductionAmt090484
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/PropertyDesc0Debt-Financed Investm
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/StraightLineDepreciationDedAmt00
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/TotalDebtFinancedDeductionAmt090484
IRS990T/SpecificDeductionAmt01000
IRS990T/SubsidiaryCorporationInd00
IRS990T/TaxableTrustAmt0134256
IRS990T/TaxLessCreditsAmt0134256
IRS990T/TaxRateScheduleInd0X
IRS990T/TotalDeductionAmt01000
IRS990T/TotalPaymentsAmt080000
IRS990T/TotalTaxAmt0134256
IRS990T/TotalTaxComputationAmt0134256
IRS990T/TotalUBTIAmt0367400
IRS990T/TotalUBTIBeforeNOLSpecificAmt0368400
IRS990T/TotalUBTIBeforeSection199AAmt0368400
IRS990T/TotalUBTIComputedAmt0368400
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd0AAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd0IAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd00
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0John Ruan IV
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Trustee
ReturnHeader/BusinessOfficerGrp/PhoneNum05152452552
ReturnHeader/BusinessOfficerGrp/SignatureDt02022-10-10
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0John Ruan Foundation Trust
ReturnHeader/Filer/BusinessNameControlTxt0JOHN
ReturnHeader/Filer/EIN0426059463
ReturnHeader/Filer/PhoneNum05152452552
ReturnHeader/Filer/USAddress/AddressLine1Txt011207 NW Aurora Avenue
ReturnHeader/Filer/USAddress/CityNm0Urbandale
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IA
ReturnHeader/Filer/USAddress/ZIPCd050322
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0450250958
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Eide Bailly LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0800 Nicollet Mall Ste 1300
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Minneapolis
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MN
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0554027033
ReturnHeader/PreparerPersonGrp/PhoneNum06122536500
ReturnHeader/PreparerPersonGrp/PreparationDt02022-10-10
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Deb Nelson CPA
ReturnHeader/ReturnTs02022-10-19T13:40:07-05:00
ReturnHeader/ReturnTypeCd0990T
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0John
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0Ruan IV
ReturnHeader/TaxPeriodBeginDt02021-07-01
ReturnHeader/TaxPeriodEndDt02022-06-30
ReturnHeader/TaxYr02021

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2022 • Form 990TFacts available. Structured filing facts are available, but richer extracted sections are limited.

Open filing
Assets
-
Liabilities
-
Net assets
-
Revenue
-
Expenses
-
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2025Detailed filing. Detailed filing data is available for this year.$100$0.00$100$5.24$4.49$0.75
2024Detailed filing. Detailed filing data is available for this year.$99.5$0.00$99.5$5.11$4.43$0.67
2023Detailed filing. Detailed filing data is available for this year.$98.8$0.00$98.8$0.55$4.72$4.16
2022Detailed filing. Detailed filing data is available for this year.$111$7.94$103$7.23$5.57$1.66
2022Facts available. Structured filing facts are available, but richer extracted sections are limited.
2021Detailed filing. Detailed filing data is available for this year.$104$2.28$101$6.34$5.70$0.64
2020Summary only. Only limited summary data is available for this year.$101$0.00$7.28$5.13$2.15
2016Summary only. Only limited summary data is available for this year.$15.1$0.18$7.76$0.88$6.87
2015Summary only. Only limited summary data is available for this year.$8.28$0.23$4.18$0.92$3.26
2014Summary only. Only limited summary data is available for this year.$4.91$0.13$1.55$0.66$0.89
2013Summary only. Only limited summary data is available for this year.$3.89$0.00$0.81$0.68$0.12
2012Summary only. Only limited summary data is available for this year.$3.85$0.08$0.70$0.59$0.11