Civic Intelligence

C W Ahrens Charitable Trust

990PF • Fiscal year 2016 • EIN 42-1239527

Jan 01, 2016 to Dec 31, 2016 • Filed on May 26, 2017

Organization Profile
PO Box 686Grinnell, IA 50112

(641) 236-5822

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.

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

Liabilities / Revenue

35th percentile

0.00x

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

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

Net Margin

19th percentile

-20%

Higher net margin than 19% of similar nonprofits.

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

Top Officer Pay

54th percentile

$0

Higher top officer pay than 54% of similar nonprofits.

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

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

Asset Growth

41st percentile

-1.2%

Faster asset growth than 41% of similar nonprofits.

2016 filings • $500k-$1M nonprofits • Annualized from 2015 to 2016

Revenue Growth

95th percentile

154%

Faster revenue growth than 95% of similar nonprofits.

2016 filings • $500k-$1M nonprofits • Annualized from 2015 to 2016

Balance Sheet
Liabilities / Assets35th percentile

Assets

Down

$875,655

Down $10,549 (-1.2%) from 2015

Net Assets

Down

$875,655

Down $10,549 (-1.2%) from 2015

Liabilities

Flat

$0

Flat from 2015

Revenue And Expenses
Liabilities / Revenue35th percentileNet Margin19th percentile

Revenue

Up

$51,851

Up $31,472 (+154%) from 2015

Expenses

Down

$62,400

Down $10,275 (-14%) from 2015

Net Income

Up

-$10,549

Up $41,747 (+80%) from 2015

Historical Trend

Balance Sheet Trend

Asset Growth41st 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

2016

Assets$875,655
Liabilities$0
Net Assets$875,655
Open 2016 Filing

Operations Trend

Revenue Growth95th percentile

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

2016

Revenue$51,851
Expenses$62,400
Net Income-$10,549
Open 2016 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2016 to Dec 31, 2016
Signed
May 26, 2017
Return Version
2016v3.0
Compensation and Service Providers
Top Officer Pay54th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
SUSAN WITTTrustee-$0--
CHAD AHRENSTrustee-$0--
Filing and Contact Details

Filer

Filer Name
C W Ahrens Charitable Trust
EIN
42-1239527
Phone
6412365822
Address
PO BOX 686, GRINNELL, IA 50112

Signing Officer

Name
Susan Witt
Title
Trustee
Phone
6412365822
Signed
2017-05-26

Preparer

Firm
Tl Baker & Co Llp
Address
808 COMMERCIAL ST, GRINNELL, IA 50112-2143
Preparer
Timothy L Baker
Phone
6412368083
Raw XML Appendix292 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/Amt02525
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0ACCOUNTING FEES
AccountingFeesSchedule/AccountingFeesDetail/NetInvestmentIncomeAmt02525
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/AcquiredDt02013-11
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/AssetDesc0MORGAN STANLEY
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/BasisAmt0985814
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/GrossSalesPriceAmt01020919
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/HowAcquiredTxt0PURCHASE
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/SoldDt02016-05
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/TotalNetAmt035105
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt0865893
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt0835605
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm0COMMON STOCKS & MUTUAL FUNDS
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt013143
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt0587
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/RelatedOrExemptFunctionIncmAmt035105
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionAmt03016
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt016746
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/RelatedOrExemptFunctionIncmAmt035105
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt051851
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncmAmt02525
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt02525
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt035692
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt050000
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt050000
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt013143
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt013143
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-10549
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt01021506
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavNetInvstIncmAmt03016
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavRevAndExpnssAmt03016
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt035692
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt039540
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesNetInvstIncmAmt09287
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesRevAndExpnssAmt09287
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncmAmt0499
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt0588
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt050000
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt012311
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt062400
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt051851
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt051851
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt012311
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt012400
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt0985814
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt035105
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt035105
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt01020919
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0CAPTIAL GAIN - INVESTMENT INC
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt035692
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-10549
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0875655
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0886204
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0875655
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt041526
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt041526
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt041526
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt041921
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0395
IRS990PF/DistributableAmountGrp/TotalTaxAmt0395
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToEsTaxAmt0500
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt0105
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/DomesticOrgMeetingSect4940eInd0X
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0395
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/OverpaymentAmt0105
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0395
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0395
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt0500
IRS990PF/FMVAssetsEOYAmt0845367
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt0883829
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt0865893
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt0835605
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt0886204
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt0875655
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt02375
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt09762
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt09762
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0886204
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0875655
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0845367
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0886204
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0875655
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0886204
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0875655
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0851178
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt06068
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0845110
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt012768
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt041921
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0838410
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0851178
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt11.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0SUSAN WITT
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm1CHAD AHRENS
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt1TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt01928 PRAIRIE ST
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt12207 CAE DR
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0GRINNELL
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm1IOWA CITY
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0IA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd1IA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd050112
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd152246
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt044821
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt045216
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt060411
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt049155
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt044000
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt050500
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt051397
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.053459
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.067535
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.050990
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.043460
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt00.052130
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt00.053178
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd0false
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt0395
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt0838410
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt0894512
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt0964004
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt01012421
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt0968725
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt0966500
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt050000
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.267293
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt049605
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt050000
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt0395
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt050000
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/PayPremiumsPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd0false
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd0false
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd0false
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd0true
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd0false
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd0true
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd0false
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd0false
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd0false
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd0true
IRS990PF/StatementsRegardingActyGrp/IndividualWithBooksNm0MICHAEL WITT
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt0PO BOX 686
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0GRINNELL
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0IA
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd050112
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0IA
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PhoneNum06412365822
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0true
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SumOfProgramRelatedInvstGrp/Description1Txt0N/A
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/FormAndInfoAndMaterialsTxt0LETTER FORM
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientPersonNm0SUSAN WITT
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientPhoneNum06412365822
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientUSAddress/AddressLine1Txt0PO BOX 686
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientUSAddress/CityNm0GRINNELL
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientUSAddress/StateAbbreviationCd0IA
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientUSAddress/ZIPCd050112
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RestrictionsOnAwardsTxt0PROMOTING CHRISTIAN CHURCHES AND CHRISTIAN ORGANIZATIONS DIRECTLY OR THROUGH SCHOLARSHIPS.
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/SubmissionDeadlinesTxt0NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt011000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt112500
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt21000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt3500
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt425000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0CHARITABLE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1CHARITABLE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt2CHARITABLE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt3CHARITABLE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt4CHARITABLE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt0GRINNELL REGION MED CNTR
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt1ST FRANCIS MANOR
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt2BIG BROTHERS BIG SISTERS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt3GRINNELL HIGH SCHOOL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt4MAYFLOWER HOME
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt0210 4TH AVE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt12021 4TH AVE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt297 14TH AVE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt31333 SUNSET ST
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt4927 FIRST AVE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0GRINNELL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm1GRINNELL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm2GRINNELL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm3GRINNELL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm4GRINNELL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0IA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd1IA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd2IA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd3IA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd4IA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd050112
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd150112
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd250112
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd350112
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd450112
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt050000
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/TrnsfrOfCashToNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd0false
IRS990PF/UndistributedIncomeGrp/AppliedToCurrentYearAmt018386
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt031614
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt041526
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt050000
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt023140
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt031614
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/Amt09287
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/CategoryTxt0INVESTMENT FEES
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/NetInvestmentIncomeAmt09287
TaxesSchedule/TaxesDetail/Amt0499
TaxesSchedule/TaxesDetail/Amt189
TaxesSchedule/TaxesDetail/CategoryTxt0FOREIGN TAX EXPENSE
TaxesSchedule/TaxesDetail/CategoryTxt1NET INVESTMENT INCOME TAX EXP.
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt0499
ReturnHeader/BuildTS02017-02-10 21:41:12Z
ReturnHeader/BusinessOfficerGrp/PersonNm0SUSAN WITT
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum06412365822
ReturnHeader/BusinessOfficerGrp/SignatureDt02017-05-26
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0C W AHRENS CHARITABLE TRUST
ReturnHeader/Filer/BusinessNameControlTxt0CWAH
ReturnHeader/Filer/EIN0421239527
ReturnHeader/Filer/PhoneNum06412365822
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 686
ReturnHeader/Filer/USAddress/CityNm0GRINNELL
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IA
ReturnHeader/Filer/USAddress/ZIPCd050112
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId00E78F9FC9782366EC8BCF4774FEB7F8C9CD2EBD2
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0AFB5F2223C4B292A982AB18322EFE325887FE94D
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0453514343
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0TL BAKER & CO LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0808 COMMERCIAL ST
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0GRINNELL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0501122143
ReturnHeader/PreparerPersonGrp/PhoneNum06412368083
ReturnHeader/PreparerPersonGrp/PreparationDt02017-07-17
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0TIMOTHY L BAKER
ReturnHeader/ReturnTs02017-07-24T10:17:07-05:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02016-01-01
ReturnHeader/TaxPeriodEndDt02016-12-31
ReturnHeader/TaxYr02016

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$875,655
Liabilities
$0
Net assets
$875,655
Revenue
$51,851
Expenses
$62,400
Net income
-$10,549
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