Civic Intelligence

C W Ahrens Charitable Trust

990PF • Fiscal year 2012 • EIN 42-1239527

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

Organization Profile
PO Box 68650112
Siviq Scores

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

Liabilities / Assets

35th percentile

0.00x

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

2012 filings • $500k-$1M 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

72nd percentile

$0

Higher top officer pay than 72% of similar nonprofits.

2012 filings • $500k-$1M nonprofits • Source year 2012

Asset Growth

42nd percentile

-0.9%

Faster asset growth than 42% of similar nonprofits.

2012 filings • $500k-$1M nonprofits • Annualized from 2011 to 2012

Revenue Growth

Score unavailable

No value available

No valid filing value is available for this score.

Balance Sheet
Liabilities / Assets35th percentile

Assets

Down

$932,383

Down $8,608 (-0.9%) from 2011

Net Assets

Down

$932,383

Down $8,608 (-0.9%) from 2011

Liabilities

Flat

$0

Flat from 2011

Revenue And Expenses
Liabilities / RevenueScore unavailableNet MarginScore unavailable

Revenue

-

No earlier filing loaded for comparison.

Expenses

Down

$64,169

Down $3,539 (-5.2%) from 2011

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset Growth42nd percentile

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

$1.0M$500K$0Assets 2010: $981,158Liabilities 2010: $0Net Assets 2010: $981,1582010Assets 2011: $940,991Liabilities 2011: $0Net Assets 2011: $940,9912011Assets 2012: $932,383Liabilities 2012: $0Net Assets 2012: $932,3832012Assets 2013: $953,196Liabilities 2013: $0Net Assets 2013: $953,1962013Assets 2014: $938,500Liabilities 2014: $0Net Assets 2014: $938,5002014Assets 2015: $886,204Liabilities 2015: $0Net Assets 2015: $886,2042015Assets 2016: $875,655Liabilities 2016: $0Net Assets 2016: $875,6552016Assets 2017: $897,985Liabilities 2017: $0Net Assets 2017: $897,9852017Assets 2018: $915,080Liabilities 2018: $0Net Assets 2018: $915,0802018Assets 2019: $875,005Liabilities 2019: $0Net Assets 2019: $875,0052019Assets 2020: $847,263Liabilities 2020: $0Net Assets 2020: $847,2632020Assets 2021: $889,076Liabilities 2021: $0Net Assets 2021: $889,0762021Assets 2022: $854,080Liabilities 2022: $0Net Assets 2022: $854,0802022Assets 2023: $813,033Liabilities 2023: $0Net Assets 2023: $813,0332023Assets 2024: $0Liabilities 2024: $0Net Assets 2024: $02024

Highlighted filing

2012

Assets$932,383
Liabilities$0
Net Assets$932,383
Open 2012 Filing

Operations Trend

Revenue GrowthScore unavailable

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

$1.0M$500K$0-$500K-$1.0MExpenses 2010: $76,7922010Expenses 2011: $67,7082011Expenses 2012: $64,1692012Revenue 2013: $78,551Expenses 2013: $57,738Net Income 2013: $20,8132013Revenue 2014: $48,331Expenses 2014: $63,027Net Income 2014: -$14,6962014Revenue 2015: $20,379Expenses 2015: $72,675Net Income 2015: -$52,2962015Revenue 2016: $51,851Expenses 2016: $62,400Net Income 2016: -$10,5492016Revenue 2017: $70,205Expenses 2017: $47,875Net Income 2017: $22,3302017Revenue 2018: $73,311Expenses 2018: $56,216Net Income 2018: $17,0952018Revenue 2019: $16,018Expenses 2019: $56,093Net Income 2019: -$40,0752019Revenue 2020: $24,612Expenses 2020: $52,354Net Income 2020: -$27,7422020Revenue 2021: $99,342Expenses 2021: $57,529Net Income 2021: $41,8132021Revenue 2022: $24,081Expenses 2022: $59,077Net Income 2022: -$34,9962022Revenue 2023: $17,070Expenses 2023: $58,117Net Income 2023: -$41,0472023Revenue 2024: $25,022Expenses 2024: $838,055Net Income 2024: -$813,0332024

Highlighted filing

2012

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

Employees

NameTitleFull / Part TimeBaseOtherTotal
SUSAN WITTTrustee-$0--
CHAD AHRENSTrustee-$0--
Grants and Assistance

Foundation Grants and Related Investments

TypeRecipientPurposeStatusLocationAmount
Paid GrantGRINNELL REGION MED CNTRCHARITABLE-GRINNELL, IA, US$25,000
Paid GrantUNITED CHURCH OF CHRISTCHARITABLE-GRINNELL, IA, US$5,000
Paid GrantST MARY'S CHURCHCHARITABLE-GRINNELL, IA, US$5,000
Paid GrantGALAXY YOUTH CENTERCHARITABLE-GRINNELL, IA, US$3,000
Paid GrantGRINNELL COMM DAY CARECHARITABLE-GRINNELL, IA, US$3,000
Paid GrantCENTRAL IOWA CHRISTIAN SCHOOLCHARITABLE-GRINNELL, IA, US$2,500
Paid GrantGRINNELL COLLEGECHARITABLE-GRINNELL, IA, US$2,500
Paid GrantMID-IOWA COMMUNITY ACTION INCCHARITABLE-GRINNELL, IA, US$2,000
Paid GrantUNITED WAY OF GRINNELLCHARITABLE-GRINNELL, IA, US$1,250
Paid GrantOTHER LOCAL 503(C) ORGCHARITABLE-GRINNELL, IA, US$1,250
Filing and Contact Details

Filer

EIN
42-1239527
Raw XML Appendix331 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/AccountingFees/Amount02350
AccountingFeesSchedule/AccountingFees/Category0ACCOUNTING FEES
AccountingFeesSchedule/AccountingFees/NetInvestmentIncome02350
CompensationExplanation/Compensation/PersonName0SUSAN WITT
CompensationExplanation/Compensation/PersonName1CHAD AHRENS
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYBookValue0875935
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYFMV0951190
InvestmentsCorpStockSchedule/InvestmentsCorpStock/NameOfStock0COMMON STOCKS & MUTUAL FUNDS
InvestmentsOtherSchedule2/InvestmentsOther/BookValue054067
InvestmentsOtherSchedule2/InvestmentsOther/CategoryOrItem0OTHER INVESTMENTS
InvestmentsOtherSchedule2/InvestmentsOther/EOYFMV054067
IRS990PF/AnalysisIncomeProducingActy/DividendsAndIntFromSecPartVII/ExclusionAmount017871
IRS990PF/AnalysisIncomeProducingActy/DividendsAndIntFromSecPartVII/ExclusionCode014
IRS990PF/AnalysisIncomeProducingActy/GainSalesAssetsOthThanInvntry/ExclusionAmount020161
IRS990PF/AnalysisIncomeProducingActy/GainSalesAssetsOthThanInvntry/ExclusionCode014
IRS990PF/AnalysisIncomeProducingActy/IntOnSavingsAndTempCashInvst/ExclusionAmount018434
IRS990PF/AnalysisIncomeProducingActy/IntOnSavingsAndTempCashInvst/ExclusionCode014
IRS990PF/AnalysisIncomeProducingActy/OtherRevenueDescribed/Description0OTHER INCOME
IRS990PF/AnalysisIncomeProducingActy/OtherRevenueDescribed/ExclusionAmount0-905
IRS990PF/AnalysisIncomeProducingActy/OtherRevenueDescribed/ExclusionCode014
IRS990PF/AnalysisIncomeProducingActy/SubtotalsPartXVIA/ExclusionAmount055561
IRS990PF/AnalysisIncomeProducingActy/TotalPartXVIA055561
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncm02350
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnss02350
IRS990PF/AnalysisOfRevenueAndExpenses/CapitalGainNetIncmNetInvstIncm020161
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidDsbrsChrtblPrps050500
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidRevAndExpnss050500
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncm017871
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnss017871
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessOfRevenueOverExpenses0-8608
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPrice020161
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavingsNetInvstIncm018434
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavingsRevAndExpnss018434
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAssetsRevAndExpnss020161
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncome042797
IRS990PF/AnalysisOfRevenueAndExpenses/NotRequiredToAttachScheduleB0X
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesNetInvstIncm01187
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnss01187
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeRevAndExpnss0-905
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesNetInvstIncm09763
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesRevAndExpnss09763
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncm0369
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnss0369
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblPrps050500
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncm013669
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnss064169
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvestmentIncome056466
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevenueAndExpenses055561
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblPrps00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncm013669
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnss013669
IRS990PF/BalanceSheets/InvestmentsCorpStockBOY0879849
IRS990PF/BalanceSheets/InvestmentsCorpStockEOY0875935
IRS990PF/BalanceSheets/InvestmentsCorpStockEOYFMV0951190
IRS990PF/BalanceSheets/InvestmentsOtherBOY050911
IRS990PF/BalanceSheets/InvestmentsOtherEOY054067
IRS990PF/BalanceSheets/InvestmentsOtherEOYFMV054067
IRS990PF/BalanceSheets/OrgThatDoNotFollowSFAS1170X
IRS990PF/BalanceSheets/RetainedEarningsBOY0940991
IRS990PF/BalanceSheets/RetainedEarningsEOY0932383
IRS990PF/BalanceSheets/SavingsAndTempCashInvstBOY010231
IRS990PF/BalanceSheets/SavingsAndTempCashInvstEOY02381
IRS990PF/BalanceSheets/SavingsAndTempCashInvstEOYFMV02381
IRS990PF/BalanceSheets/TotalAssetsBOY0940991
IRS990PF/BalanceSheets/TotalAssetsEOY0932383
IRS990PF/BalanceSheets/TotalAssetsEOYFMV01007638
IRS990PF/BalanceSheets/TotalLiabilitiesEOY00
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsBOY0940991
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsEOY0932383
IRS990PF/BalanceSheets/TotalNetAssetsBOY0940991
IRS990PF/BalanceSheets/TotalNetAssetsEOY0932383
IRS990PF/CapitalGainsAndLosses/CapitalGainNetIncome020161
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/CostOrOtherBasis0217532
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DescriptionOfAsset0CAPTIAL GAIN - INVESTMENT INC
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainOrLoss015616
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainsMinusExcessOrLosses015616
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GrossSalesPrice0233148
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/HowAcquired0P
IRS990PF/ChangesInNetAssetsFundBalances/ExcessOfRevenueOverExpenses0-8608
IRS990PF/ChangesInNetAssetsFundBalances/Subtotal0932383
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesBOY0940991
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesEOY0932383
IRS990PF/DistributableAmount/DistributableAmountAsAdjusted047580
IRS990PF/DistributableAmount/DistributableAmountBeforeAdj047580
IRS990PF/DistributableAmount/DistributableAmountBeforeDed047580
IRS990PF/DistributableAmount/MinimumInvestmentReturn048436
IRS990PF/DistributableAmount/TaxBasedOnInvestmentIncome0856
IRS990PF/DistributableAmount/TotalTax0856
IRS990PF/ExciseTaxBasedOnInvestmentIncm/AmountCreditedToNextYear0564
IRS990PF/ExciseTaxBasedOnInvestmentIncm/EstTaxPaymentsAndOverpayment01420
IRS990PF/ExciseTaxBasedOnInvestmentIncm/InvestmentIncomeExciseTax0856
IRS990PF/ExciseTaxBasedOnInvestmentIncm/Overpayment0564
IRS990PF/ExciseTaxBasedOnInvestmentIncm/Subtotal0856
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxBasedOnInvestmentIncome0856
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TotalCreditsAndPayments01420
IRS990PF/ExemptPF0X
IRS990PF/FMVAssetsEOY01007638
IRS990PF/MethodOfAccountingCash0X
IRS990PF/MinimumInvestmentReturn/AdjTotalFMVOfUnusedAssets0983477
IRS990PF/MinimumInvestmentReturn/AvgMonthlyCashBalances06306
IRS990PF/MinimumInvestmentReturn/AvgMonthlyFMVOfSecurities0924682
IRS990PF/MinimumInvestmentReturn/CashDeemedCharitable014752
IRS990PF/MinimumInvestmentReturn/FMVAllOtherNoncharitableAssets052489
IRS990PF/MinimumInvestmentReturn/MinimumInvestmentReturn048436
IRS990PF/MinimumInvestmentReturn/NetNoncharitableAssets0968725
IRS990PF/MinimumInvestmentReturn/TotalFMVOfUnusedAssets0983477
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHghstPaidCntrctNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHighestPaidEmplNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition01.00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition11.00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation10
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ContriToEmplBenefitPlansEtc00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ContriToEmplBenefitPlansEtc10
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ExpenseAccountOtherAllowances00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ExpenseAccountOtherAllowances10
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/PersonName0SUSAN WITT
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/PersonName1CHAD AHRENS
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title0TRUSTEE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title1TRUSTEE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine101928 PRAIRIE ST
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine112207 CAE DR
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City0GRINNELL
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City1IOWA CITY
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State0IA
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State1IA
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode050112
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode152246
IRS990PF/QlfyUndSect4940eForReducedTax/AdjNonchrtblAssetsAndOnePct051355
IRS990PF/QlfyUndSect4940eForReducedTax/AdjustedNoncharitableAssets050927
IRS990PF/QlfyUndSect4940eForReducedTax/AverageDistributionRatio00.052571
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear100.053178
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear200.052458
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear300.055009
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear400.052245
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear500.049966
IRS990PF/QlfyUndSect4940eForReducedTax/LiableFor4942Tax0false
IRS990PF/QlfyUndSect4940eForReducedTax/NetNoncharitableAssets0968725
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear10966500
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear201002636
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear301082695
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear401166468
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear501231450
IRS990PF/QlfyUndSect4940eForReducedTax/OnePercentNetInvestmentIncome0428
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributions050500
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear1051397
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear2052596
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear3059558
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear4060942
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear5061531
IRS990PF/QlfyUndSect4940eForReducedTax/TotalDistributionRatio00.262856
IRS990PF/QualifyingDistributions/AdjQualifyingDistributions050500
IRS990PF/QualifyingDistributions/ExpensesAndContributions050500
IRS990PF/QualifyingDistributions/QualifyingDistributions050500
IRS990PF/StatementsRegardingActivities/ActivitiesNotPrevReported0false
IRS990PF/StatementsRegardingActivities/ApplicableInsuranceContract0false
IRS990PF/StatementsRegardingActivities/AtLeast5000InAssets0true
IRS990PF/StatementsRegardingActivities/BooksInCareOfPersonName0MICHAEL WITT
IRS990PF/StatementsRegardingActivities/BooksInCareOfPhoneNumber06412365822
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/AddressLine10PO BOX 686
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/City0GRINNELL
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/State0IA
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/ZIPCode050112
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/UndistributedIncomePriorYears0false
IRS990PF/SumOfProgramRelatedInvestments/Description10N/A
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/FormAndInfoAndMaterials0LETTER FORM
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientName0SUSAN WITT
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientPhoneNumber06412368083
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientUSAddress/AddressLine10PO BOX 686
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientUSAddress/City0GRINNELL
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientUSAddress/State0IA
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientUSAddress/ZIPCode050112
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RestrictionsOnAwards0PROMOTING CHRISTIAN CHURCHES AND CHRISTIAN ORGANIZATIONS DIRECTLY OR THROUGH SCHOLARSHIPS.
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/SubmissionDeadlines0NONE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount02000
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount15000
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount225000
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount35000
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount43000
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount53000
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount61250
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount72500
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount82500
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount91250
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution0CHARITABLE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution1CHARITABLE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution2CHARITABLE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution3CHARITABLE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution4CHARITABLE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution5CHARITABLE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution6CHARITABLE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution7CHARITABLE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution8CHARITABLE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution9CHARITABLE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine10MID-IOWA COMMUNITY ACTION INC
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine11UNITED CHURCH OF CHRIST
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine12GRINNELL REGION MED CNTR
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine13ST MARY'S CHURCH
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine14GALAXY YOUTH CENTER
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine15GRINNELL COMM DAY CARE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine16UNITED WAY OF GRINNELL
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine17CENTRAL IOWA CHRISTIAN SCHOOL
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine18GRINNELL COLLEGE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine19OTHER LOCAL 503(C) ORG
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine10611 4TH AVE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine11927 4TH AVE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine12210 4TH AVE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine131002 BROAD ST
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine14PO BOX 29
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine151436 PENROSE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine16PO BOX 121
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine17201 380TH AVE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine18GRINNELL COLLEGE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine19LOCAL
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City0GRINNELL
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City1GRINNELL
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City2GRINNELL
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City3GRINNELL
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City4GRINNELL
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City5GRINNELL
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City6GRINNELL
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City7GRINNELL
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City8GRINNELL
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City9GRINNELL
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State0IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State1IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State2IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State3IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State4IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State5IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State6IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State7IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State8IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State9IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode050112
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode150112
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode250112
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode350112
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode450112
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode550112
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode650112
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode750112
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode850112
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode950112
IRS990PF/SupplementaryInformation/TotGrantOrContriPaidDuringYear050500
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/AppliedToCurrentYear03775
IRS990PF/UndistributedIncome/AppliedToYear1046725
IRS990PF/UndistributedIncome/DistributableAmountAsAdjusted047580
IRS990PF/UndistributedIncome/QualifyingDistributions050500
IRS990PF/UndistributedIncome/UndistributedIncomeCY043805
IRS990PF/UndistributedIncome/UndistributedIncomePriorYear046725
OtherExpensesSchedule/OtherExpenses/Description0EXPENSES
OtherExpensesSchedule/OtherExpenses/Description1OTHER EXPENSE - K-1'S
OtherExpensesSchedule/OtherExpenses/NetInvestmentIncome01187
OtherExpensesSchedule/OtherExpenses/RevenueAndExpensesPerBooks01187
OtherIncomeSchedule2/OtherIncome/Description0OTHER INCOME
OtherIncomeSchedule2/OtherIncome/RevenueAndExpensesPerBooks0-905
OtherProfessionalFeesSchedule/OtherProfessionalFees/Amount09763
OtherProfessionalFeesSchedule/OtherProfessionalFees/Category0INVESTMENT FEES
OtherProfessionalFeesSchedule/OtherProfessionalFees/NetInvestmentIncome09763
TaxesSchedule/Taxes/Amount0369
TaxesSchedule/Taxes/Category0FOREIGN TAX EXPENSE
TaxesSchedule/Taxes/NetInvestmentIncome0369
ReturnHeader/BuildTS02016-02-25 16:41:14Z
ReturnHeader/Filer/EIN0421239527
ReturnHeader/Filer/Name/BusinessNameLine10C W AHRENS CHARITABLE TRUST
ReturnHeader/Filer/NameControl0CWAH
ReturnHeader/Filer/Phone06412365822
ReturnHeader/Filer/USAddress/AddressLine10PO BOX 686
ReturnHeader/Filer/USAddress/City0GRINNELL
ReturnHeader/Filer/USAddress/State0IA
ReturnHeader/Filer/USAddress/ZIPCode050112
ReturnHeader/Officer/DateSigned02013-05-09
ReturnHeader/Officer/Name0SUSAN WITT
ReturnHeader/Officer/Phone06412365822
ReturnHeader/Officer/Title0TRUSTEE
ReturnHeader/Preparer/DatePrepared02013-05-15
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10TL BAKER & CO LLP
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine10808 COMMERCIAL ST
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0GRINNELL
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0IA
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode0501122143
ReturnHeader/Preparer/Name0TIMOTHY L BAKER
ReturnHeader/Preparer/Phone06412368083
ReturnHeader/ReturnType0990PF
ReturnHeader/TaxPeriodBeginDate02012-01-01
ReturnHeader/TaxPeriodEndDate02012-12-31
ReturnHeader/TaxYear02012
ReturnHeader/Timestamp02013-05-15T11:29:00-05: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
$932,383
Liabilities
$0
Net assets
$932,383
Revenue
-
Expenses
$64,169
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.25$8.38$8.13
2023Detailed filing. Detailed filing data is available for this year.$8.13$0.00$8.13$0.17$0.58$0.41
2022Detailed filing. Detailed filing data is available for this year.$8.54$0.00$8.54$0.24$0.59$0.35
2021Detailed filing. Detailed filing data is available for this year.$8.89$0.00$8.89$0.99$0.58$0.42
2020Detailed filing. Detailed filing data is available for this year.$8.47$0.00$8.47$0.25$0.52$0.28
2019Detailed filing. Detailed filing data is available for this year.$8.75$0.00$8.75$0.16$0.56$0.40
2018Detailed filing. Detailed filing data is available for this year.$9.15$0.00$9.15$0.73$0.56$0.17
2017Detailed filing. Detailed filing data is available for this year.$8.98$0.00$8.98$0.70$0.48$0.22
2016Detailed filing. Detailed filing data is available for this year.$8.76$0.00$8.76$0.52$0.62$0.11
2015Detailed filing. Detailed filing data is available for this year.$8.86$0.00$8.86$0.20$0.73$0.52
2014Detailed filing. Detailed filing data is available for this year.$9.39$0.00$9.39$0.48$0.63$0.15
2013Detailed filing. Detailed filing data is available for this year.$9.53$0.00$9.53$0.79$0.58$0.21
2012Detailed filing. Detailed filing data is available for this year.$9.32$0.00$9.32$0.64
2011Detailed filing. Detailed filing data is available for this year.$9.41$0.00$9.41$0.68
2010Detailed filing. Detailed filing data is available for this year.$9.81$0.00$9.81$0.77