Civic Intelligence

John J and Judy a Arledge Charitable Foundation

990PF • Fiscal year 2012 • EIN 30-0348285

Jan 01, 2012 to Dec 31, 2012 • Filed on May 10, 2013

Organization Profile
222 North Main Street52601
Siviq Scores

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

Liabilities / Assets

58th percentile

0.00x

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

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

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2012

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2012

Top Officer Pay

84th percentile

$216

Higher top officer pay than 84% of similar nonprofits.

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

Asset Growth

Score unavailable

No value available

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

Source year 2012

Revenue Growth

Score unavailable

No value available

No valid filing value is available for this score.

Balance Sheet
Liabilities / Assets58th percentile

Assets

$1,723

No earlier filing loaded for comparison.

Net Assets

$1,723

No earlier filing loaded for comparison.

Liabilities

$0

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / RevenueScore unavailableNet MarginScore unavailable

Revenue

-

No earlier filing loaded for comparison.

Expenses

$573

No earlier filing loaded for comparison.

Net Income

-

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.

$200K$150K$100K$50K$0Assets 2012: $1,723Liabilities 2012: $0Net Assets 2012: $1,7232012Assets 2013: $28,666Liabilities 2013: $0Net Assets 2013: $28,6662013Assets 2014: $1,476Liabilities 2014: $0Net Assets 2014: $1,4762014Assets 2015: $866Liabilities 2015: $0Net Assets 2015: $8662015Assets 2016: $575Liabilities 2016: $0Net Assets 2016: $5752016Assets 2017: $1,233Liabilities 2017: $0Net Assets 2017: $1,2332017Assets 2018: $2,462Liabilities 2018: $0Net Assets 2018: $2,4622018Assets 2019: $51,568Liabilities 2019: $0Net Assets 2019: $51,5682019Assets 2020: $116,578Liabilities 2020: $0Net Assets 2020: $116,5782020Assets 2021: $183,506Liabilities 2021: $0Net Assets 2021: $183,5062021Assets 2022: $133,115Liabilities 2022: $0Net Assets 2022: $133,1152022Assets 2023: $107,760Liabilities 2023: $0Net Assets 2023: $107,7602023Assets 2024: $132,399Liabilities 2024: $0Net Assets 2024: $132,3992024

Highlighted filing

2012

Assets$1,723
Liabilities$0
Net Assets$1,723
Open 2012 Filing

Operations Trend

Revenue GrowthScore unavailable

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

$150K$100K$50K$0-$50K-$100KExpenses 2012: $5732012Revenue 2013: $37,536Expenses 2013: $10,593Net Income 2013: $26,9432013Revenue 2014: $54,506Expenses 2014: $81,696Net Income 2014: -$27,1902014Revenue 2015: $48,754Expenses 2015: $49,364Net Income 2015: -$6102015Revenue 2016: $47,832Expenses 2016: $48,123Net Income 2016: -$2912016Revenue 2017: $55,236Expenses 2017: $54,578Net Income 2017: $6582017Revenue 2018: $112,260Expenses 2018: $111,031Net Income 2018: $1,2292018Revenue 2019: $122,206Expenses 2019: $73,100Net Income 2019: $49,1062019Revenue 2020: $145,071Expenses 2020: $80,061Net Income 2020: $65,0102020Revenue 2021: $133,506Expenses 2021: $66,578Net Income 2021: $66,9282021Revenue 2022: $31,240Expenses 2022: $81,631Net Income 2022: -$50,3912022Revenue 2023: $9,494Expenses 2023: $34,850Net Income 2023: -$25,3562023Revenue 2024: $131,838Expenses 2024: $54,203Net Income 2024: $77,6352024

Highlighted filing

2012

Revenue-
Expenses$573
Net Income-
Open 2012 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2012 to Dec 31, 2012
Signed
May 10, 2013
Return Version
2012v2.0
Compensation and Service Providers
Top Officer Pay84th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
-Trustee-$216-$216
Filing and Contact Details

Filer

EIN
30-0348285
Raw XML Appendix191 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
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncm0350
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnss0350
IRS990PF/AnalysisOfRevenueAndExpenses/CapitalGainNetIncmNetInvstIncm00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncm0216
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnss0216
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidDsbrsChrtblPrps00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidRevAndExpnss00
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessOfRevenueOverExpenses0-573
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncome00
IRS990PF/AnalysisOfRevenueAndExpenses/NotRequiredToAttachScheduleB0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncm07
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnss07
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblPrps00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncm0573
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnss0573
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvestmentIncome00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevenueAndExpenses00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblPrps00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncm0573
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnss0573
IRS990PF/BalanceSheets/CapitalStockBOY02296
IRS990PF/BalanceSheets/CapitalStockEOY01723
IRS990PF/BalanceSheets/OrgThatDoNotFollowSFAS1170X
IRS990PF/BalanceSheets/SavingsAndTempCashInvstBOY02296
IRS990PF/BalanceSheets/SavingsAndTempCashInvstEOY01723
IRS990PF/BalanceSheets/SavingsAndTempCashInvstEOYFMV01723
IRS990PF/BalanceSheets/TotalAssetsBOY02296
IRS990PF/BalanceSheets/TotalAssetsEOY01723
IRS990PF/BalanceSheets/TotalAssetsEOYFMV01723
IRS990PF/BalanceSheets/TotalLiabilitiesEOY00
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsBOY02296
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsEOY01723
IRS990PF/BalanceSheets/TotalNetAssetsBOY02296
IRS990PF/BalanceSheets/TotalNetAssetsEOY01723
IRS990PF/ChangesInNetAssetsFundBalances/ExcessOfRevenueOverExpenses0-573
IRS990PF/ChangesInNetAssetsFundBalances/Subtotal01723
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesBOY02296
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesEOY01723
IRS990PF/DistributableAmount/DistributableAmountAsAdjusted098
IRS990PF/DistributableAmount/DistributableAmountBeforeAdj098
IRS990PF/DistributableAmount/DistributableAmountBeforeDed098
IRS990PF/DistributableAmount/MinimumInvestmentReturn098
IRS990PF/ExciseTaxBasedOnInvestmentIncm/AmountCreditedToNextYear00
IRS990PF/ExciseTaxBasedOnInvestmentIncm/InvestmentIncomeExciseTax00
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxBasedOnInvestmentIncome00
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxUnderSection51100
IRS990PF/ExemptPF0X
IRS990PF/FMVAssetsEOY01723
IRS990PF/MethodOfAccountingCash0X
IRS990PF/MinimumInvestmentReturn/AdjTotalFMVOfUnusedAssets01996
IRS990PF/MinimumInvestmentReturn/AvgMonthlyCashBalances01996
IRS990PF/MinimumInvestmentReturn/AvgMonthlyFMVOfSecurities00
IRS990PF/MinimumInvestmentReturn/CashDeemedCharitable030
IRS990PF/MinimumInvestmentReturn/FMVAllOtherNoncharitableAssets00
IRS990PF/MinimumInvestmentReturn/MinimumInvestmentReturn098
IRS990PF/MinimumInvestmentReturn/NetNoncharitableAssets01966
IRS990PF/MinimumInvestmentReturn/TotalFMVOfUnusedAssets01996
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHghstPaidCntrctNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHighestPaidEmplNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition01.00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/BusinessName/BusinessNameLine10TWO RIVERS BANK & TRUST
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation0216
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ContriToEmplBenefitPlansEtc00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ExpenseAccountOtherAllowances00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title0Trustee
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine10222 NORTH MAIN STREET
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City0BURLINGTON
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State0IA
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode052601
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/TotNumberOfCntrctPaidOver50k00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/TotNumberOfOthEmplPaidOver50k00
IRS990PF/QlfyUndSect4940eForReducedTax/AdjNonchrtblAssetsAndOnePct02107
IRS990PF/QlfyUndSect4940eForReducedTax/AdjustedNoncharitableAssets02107
IRS990PF/QlfyUndSect4940eForReducedTax/AverageDistributionRatio01.071940
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear102.466623
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear200.000000
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear300.000000
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear401.786205
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear501.106870
IRS990PF/QlfyUndSect4940eForReducedTax/LiableFor4942Tax0false
IRS990PF/QlfyUndSect4940eForReducedTax/NetNoncharitableAssets01966
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear107700
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear2025
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear30243
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear403639
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear505502
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributions00
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear1018993
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear406500
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear506090
IRS990PF/QlfyUndSect4940eForReducedTax/TotalDistributionRatio05.359698
IRS990PF/QualifyingDistributions/ExpensesAndContributions00
IRS990PF/StatementsRegardingActivities/ActivitiesNotPrevReported0false
IRS990PF/StatementsRegardingActivities/ApplicableInsuranceContract0false
IRS990PF/StatementsRegardingActivities/AtLeast5000InAssets0true
IRS990PF/StatementsRegardingActivities/BooksInCareOfBusinessName/BusinessNameLine10TWO RIVERS BANK & TRUST
IRS990PF/StatementsRegardingActivities/BooksInCareOfPhoneNumber03197539130
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/AddressLine10222 NORTH MAIN STREET
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/City0BURLINGTON
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/State0IA
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/ZIPCode052601
IRS990PF/StatementsRegardingActivities/ChangesToArticlesOrBylaws0false
IRS990PF/StatementsRegardingActivities/ComplyWithPublicInspectionRqr0true
IRS990PF/StatementsRegardingActivities/ForeignBank0false
IRS990PF/StatementsRegardingActivities/Form1120POLFiled0false
IRS990PF/StatementsRegardingActivities/Form990PFFiledWithAG0true
IRS990PF/StatementsRegardingActivities/InterestInControlledEntity0false
IRS990PF/StatementsRegardingActivities/LegislativePoliticalActivities0false
IRS990PF/StatementsRegardingActivities/MoreThan100Spent0false
IRS990PF/StatementsRegardingActivities/NewSubstantialContributors0false
IRS990PF/StatementsRegardingActivities/PrivateOperatingFoundation0false
IRS990PF/StatementsRegardingActivities/RequirementsOfSect508e0true
IRS990PF/StatementsRegardingActivities/StatesFiledWith0IA
IRS990PF/StatementsRegardingActivities/TerminationEtc0false
IRS990PF/StatementsRegardingActivities/UnrelatedBusIncomeOver10000false
IRS990PF/StatementsRegardingActivities/WebsiteAddress0N/A
IRS990PF/StatementsRegardingActy4720/BorrowOrLendWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/BusinessHoldings0false
IRS990PF/StatementsRegardingActy4720/FurnishedGoodsWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/GrantsToIndividuals0false
IRS990PF/StatementsRegardingActy4720/GrantsToOrganizations0false
IRS990PF/StatementsRegardingActy4720/InfluenceElection0false
IRS990PF/StatementsRegardingActy4720/InfluenceLegislation0false
IRS990PF/StatementsRegardingActy4720/JeopardyInvestments0false
IRS990PF/StatementsRegardingActy4720/NoncharitablePurpose0false
IRS990PF/StatementsRegardingActy4720/PayCompensationToDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/PaymentToGovernmentOffical0false
IRS990PF/StatementsRegardingActy4720/PayPremiumsPrsnlBnftContract0false
IRS990PF/StatementsRegardingActy4720/ProhibitedTaxShelterTransactn0false
IRS990PF/StatementsRegardingActy4720/RcvFundsToPayPrsnlBnftContract0false
IRS990PF/StatementsRegardingActy4720/SaleOrExchangeWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/TransferAssetsToDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/UncorrectedJeopardyInvestments0false
IRS990PF/StatementsRegardingActy4720/UncorrectedPriorActs0false
IRS990PF/StatementsRegardingActy4720/UndistributedIncomePriorYears0false
IRS990PF/SupplementaryInformation/ContributingManager0NONE
IRS990PF/SupplementaryInformation/OnlyContributesToPreselected0X
IRS990PF/SupplementaryInformation/ShareholderManager0NONE
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/LoansOrLoanGuarantees0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/PerformanceOfServicesEtc0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/PurchaseAssetsNoncharitableEO0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/ReimbursementArrangements0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/RelationshipsNoncharitableEOs0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/RentalOfFacilitiesEtc0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/SalesOrExchangesOfAssets0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/SharingOfFacilitiesEtc0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/TrnsfrOfCashToNoncharitableEO0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/TrnsfrOthAssetsNoncharitableEO0false
IRS990PF/UndistributedIncome/DistributableAmountAsAdjusted098
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear1019000
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear406315
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear505936
IRS990PF/UndistributedIncome/ExcessDistriCyovAppCYCorpus098
IRS990PF/UndistributedIncome/ExcessDistriCyovAppliedCY098
IRS990PF/UndistributedIncome/ExcessDistriCyovFromYear505838
IRS990PF/UndistributedIncome/ExcessDistriCyovToNextYear025315
IRS990PF/UndistributedIncome/ExcessFromYear1019000
IRS990PF/UndistributedIncome/ExcessFromYear406315
IRS990PF/UndistributedIncome/TotalCorpus031153
IRS990PF/UndistributedIncome/TotalExcessDistriCarryover031251
IRS990PF/UndistributedIncome/UndistributedIncomeCY00
TaxesSchedule/Taxes/Amount07
TaxesSchedule/Taxes/Category0Excise taxes
TaxesSchedule/Taxes/NetInvestmentIncome07
ReturnHeader/BuildTS02016-02-25 16:41:14Z
ReturnHeader/Filer/EIN0300348285
ReturnHeader/Filer/Name/BusinessNameLine10JOHN J & JUDY A ARLEDGE CHARITABLE TRUST
ReturnHeader/Filer/NameControl0JOHN
ReturnHeader/Filer/Phone03197539136
ReturnHeader/Filer/USAddress/AddressLine10222 NORTH MAIN STREET
ReturnHeader/Filer/USAddress/City0BURLINGTON
ReturnHeader/Filer/USAddress/State0IA
ReturnHeader/Filer/USAddress/ZIPCode052601
ReturnHeader/Officer/DateSigned02013-05-10
ReturnHeader/Officer/Name0JOHN WALZ
ReturnHeader/Officer/Phone03197539136
ReturnHeader/Officer/Title0TRUST OFFICER
ReturnHeader/Preparer/DatePrepared02013-05-15
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10JEAN BALLINGER CPA
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine10201 JEFFERSON SUITE 208
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0BURLINGTON
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0IA
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode052601
ReturnHeader/Preparer/Name0JEAN E BALLINGER
ReturnHeader/Preparer/Phone03197527500
ReturnHeader/Preparer/SelfEmployed0X
ReturnHeader/ReturnType0990PF
ReturnHeader/TaxPeriodBeginDate02012-01-01
ReturnHeader/TaxPeriodEndDate02012-12-31
ReturnHeader/TaxYear02012
ReturnHeader/Timestamp02013-05-15T13:26:43-07:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$1,723
Liabilities
$0
Net assets
$1,723
Revenue
-
Expenses
$573
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$1.32$0.00$1.32$1.32$0.54$0.78
2023Detailed filing. Detailed filing data is available for this year.$1.08$0.00$1.08$0.09$0.35$0.25
2022Detailed filing. Detailed filing data is available for this year.$1.33$0.00$1.33$0.31$0.82$0.50
2021Detailed filing. Detailed filing data is available for this year.$1.84$0.00$1.84$1.34$0.67$0.67
2020Detailed filing. Detailed filing data is available for this year.$1.17$0.00$1.17$1.45$0.80$0.65
2019Detailed filing. Detailed filing data is available for this year.$0.52$0.00$0.52$1.22$0.73$0.49
2018Detailed filing. Detailed filing data is available for this year.$0.02$0.00$0.02$1.12$1.11$0.01
2017Detailed filing. Detailed filing data is available for this year.$0.01$0.00$0.01$0.55$0.55$0.01
2016Detailed filing. Detailed filing data is available for this year.$0.01$0.00$0.01$0.48$0.48$0.00
2015Detailed filing. Detailed filing data is available for this year.$0.01$0.00$0.01$0.49$0.49$0.01
2014Detailed filing. Detailed filing data is available for this year.$0.01$0.00$0.01$0.55$0.82$0.27
2013Detailed filing. Detailed filing data is available for this year.$0.29$0.00$0.29$0.38$0.11$0.27
2012Detailed filing. Detailed filing data is available for this year.$0.02$0.00$0.02$0.01