Civic Intelligence

Donald H & Elizabeth J Werling Scholarship Fund C/O Hills Bank Ttee

990PF • Fiscal year 2015 • EIN 42-6423052

Jan 01, 2015 to Dec 31, 2015 • Filed on May 16, 2016

Organization Profile
590 W Forevergreen RdNorth Liberty, IA 52317-8507

(319) 338-1522

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.

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

Liabilities / Revenue

58th percentile

0.00x

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

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

Net Margin

6th percentile

-138%

Higher net margin than 6% of similar nonprofits.

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

Top Officer Pay

78th percentile

$1,994

Higher top officer pay than 78% of similar nonprofits.

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

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

Asset Growth

35th percentile

-4.5%

Faster asset growth than 35% of similar nonprofits.

2015 filings • <$500k nonprofits • Annualized from 2014 to 2015

Revenue Growth

36th percentile

-8.4%

Faster revenue growth than 36% of similar nonprofits.

2015 filings • <$500k nonprofits • Annualized from 2014 to 2015

Balance Sheet
Liabilities / Assets58th percentile

Assets

Down

$218,436

Down $10,301 (-4.5%) from 2014

Net Assets

Down

$218,436

Down $10,301 (-4.5%) from 2014

Liabilities

Flat

$0

Flat from 2014

Revenue And Expenses
Liabilities / Revenue58th percentileNet Margin6th percentile

Revenue

Down

$7,470

Down $683 (-8.4%) from 2014

Expenses

Up

$17,771

Up $10,876 (+158%) from 2014

Net Income

Down

-$10,301

Down $11,559 (-919%) from 2014

Historical Trend

Balance Sheet Trend

Asset Growth35th percentile

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

$300K$200K$100K$0Assets 2011: $229,051Liabilities 2011: $02011Assets 2012: $225,833Liabilities 2012: $02012Assets 2013: $227,479Liabilities 2013: $02013Assets 2014: $228,737Liabilities 2014: $0Net Assets 2014: $228,7372014Assets 2015: $218,436Liabilities 2015: $0Net Assets 2015: $218,4362015Assets 2016: $205,325Liabilities 2016: $0Net Assets 2016: $205,3252016Assets 2017: $196,458Liabilities 2017: $0Net Assets 2017: $196,4582017Assets 2018: $193,000Liabilities 2018: $0Net Assets 2018: $193,0002018Assets 2019: $195,013Liabilities 2019: $0Net Assets 2019: $195,0132019Assets 2020: $182,916Liabilities 2020: $0Net Assets 2020: $182,9162020Assets 2021: $181,267Liabilities 2021: $0Net Assets 2021: $181,2672021Assets 2022: $159,024Liabilities 2022: $0Net Assets 2022: $159,0242022Assets 2023: $153,578Liabilities 2023: $12023

Highlighted filing

2015

Assets$218,436
Liabilities$0
Net Assets$218,436
Open 2015 Filing

Operations Trend

Revenue Growth36th percentile

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

$40K$20K$0-$20K-$40KRevenue 2011: $5,174Expenses 2011: $7,966Net Income 2011: -$2,7922011Revenue 2012: $5,133Expenses 2012: $8,351Net Income 2012: -$3,2182012Revenue 2013: $7,620Expenses 2013: $5,973Net Income 2013: $1,6472013Revenue 2014: $8,153Expenses 2014: $6,895Net Income 2014: $1,2582014Revenue 2015: $7,470Expenses 2015: $17,771Net Income 2015: -$10,3012015Revenue 2016: $8,055Expenses 2016: $21,110Net Income 2016: -$13,0552016Revenue 2017: $5,119Expenses 2017: $13,986Net Income 2017: -$8,8672017Revenue 2018: $10,375Expenses 2018: $13,833Net Income 2018: -$3,4582018Revenue 2019: $5,904Expenses 2019: $3,891Net Income 2019: $2,0132019Revenue 2020: $5,990Expenses 2020: $18,087Net Income 2020: -$12,0972020Revenue 2021: $12,375Expenses 2021: $13,996Net Income 2021: -$1,6212021Revenue 2022: -$9,521Expenses 2022: $12,704Net Income 2022: -$22,2252022Revenue 2023: $6,946Expenses 2023: $12,374Net Income 2023: -$5,4282023

Highlighted filing

2015

Revenue$7,470
Expenses$17,771
Net Income-$10,301
Open 2015 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2015 to Dec 31, 2015
Signed
May 16, 2016
Return Version
2015v2.1
Compensation and Service Providers
Top Officer Pay78th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
HILLS BANK AND TRUST COMPANYTrustee-$1,994-$1,994
Filing and Contact Details

Filer

Filer Name
Donald H and Elizabeth J Werling
EIN
42-6423052
Phone
3193381522
Address
590 W FOREVERGREEN RD, NORTH LIBERTY, IA 52317-8507

Signing Officer

Name
Julie Burton
Title
Trust Officer
Phone
3193381522
Signed
2016-05-16
Discuss with paid preparer
Yes

Preparer

Firm
Rsm US Llp
Address
221 THIRD AVENUE SE STE 300, CEDAR RAPIDS, IA 52401-1512
Preparer
Carley Umstead
Phone
3192985333
Raw XML Appendix363 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/Amt01190
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0TAX PREPARATION FEE
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt0595
AccountingFeesSchedule/AccountingFeesDetail/NetInvestmentIncomeAmt0595
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/BondNm0FEDERATED BOND FUND-IS
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/BondNm1FEDERATED TOTAL RETURN BOND FUND-IN
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/BondNm2FLEXSHARES IBOXX 3-YEAR TARG
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/BondNm3GOLDMAN SACHS SHORT DURATION GOV-IN
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/BondNm4GOLDMAN SACHS STRAT INC-INST
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/BondNm5HBT CD #10208676 1.84% DUE 12/05/15
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/BondNm6U OF I CREDIT UNION 2.230% 3/13/15
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/BondNm7UICCU #1013 1.990% 11/13/17
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/BondNm8VANGUARD INTM TERM CORP-ADM
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/BondNm9VANGUARD S/T INVEST GR-ADM
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/BondNm10VANGUARD TOTAL BD MKT IDX ADM
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt014696
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt146846
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt26245
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt38000
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt421500
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt50
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt60
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt725000
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt815203
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt921541
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt1011697
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt013471
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt145207
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt26045
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt37875
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt419494
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt50
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt60
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt725000
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt814434
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt921183
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt1011369
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt03433
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt12720
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt24991
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt3943
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt41137
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt5939
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt6651
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt71755
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt83689
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt91401
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt101801
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt11213
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt121614
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt03954
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt13764
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt27524
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt31120
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt4798
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt51524
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt61019
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt71718
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt85369
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt91736
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt101580
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt11294
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt121492
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm0AMERICAN BEACON L/C VALU-IS
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm1DODGE & COX STOCK FUND
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm2HARBOR CAP APPRECIATION FUND-INST
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm3LOOMIS SAYLES S/C GROWTH-INS
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm4ROYCE OPPORTUNITY FUND INV
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm5SPDR S&P MIDCAP 400 ETF TRUST
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm6T ROWE PRICE GROWTH STK
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm7T. ROWE PRICE MID-CAP GROWTH FUND
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm8VANGUARD 500 INDEX FUND-ADM
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm9VANGUARD SELECTED VALUE F IV
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm10DODGE & COX INTL STOCK FUND
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm11ISHARES MSCI EAFE ETF
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm12WILLIAM BLAIR INTL GROWTH FUND-I
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt05828
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt01642
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt07470
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/RelatedOrExemptFunctionIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/UnrelatedBusinessTaxblIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt07470
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesChrtblPrpsAmt0595
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncmAmt0595
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt01190
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt01642
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt0997
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt0997
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt01994
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt010462
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt014462
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt05828
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt05828
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-10301
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt026642
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt01642
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt05878
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt0125
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt012054
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt01592
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt017771
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt07470
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt07470
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt01592
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt01592
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt03309
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt025000
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt00
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt11642
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt00
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt11642
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt025000
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt11642
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0PUBLICLY TRADED SECURITIES
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc1CAPITAL GAINS DIVIDENDS
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt01642
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-10301
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0218436
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0228737
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0218436
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt011449
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt011449
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt011449
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt011508
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt059
IRS990PF/DistributableAmountGrp/TotalTaxAmt059
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/DomesticOrgMeetingSect4940eInd0X
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt059
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt059
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt059
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxDueAmt059
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt00
IRS990PF/FMVAssetsEOYAmt0218391
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsBOYAmt0200487
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYAmt0170728
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYFMVAmt0164078
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt023648
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt025287
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt031892
IRS990PF/Form990PFBalanceSheetsGrp/OrganizationFollowsSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt04602
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt022421
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt022421
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0228737
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0218436
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0218391
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0228737
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0218436
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0228737
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0218436
IRS990PF/Form990PFBalanceSheetsGrp/UnrestrictedBOYAmt0228737
IRS990PF/Form990PFBalanceSheetsGrp/UnrestrictedEOYAmt0218436
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0233659
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt013511
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0220148
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt03505
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt011508
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0230154
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0233659
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt01994
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0HILLS BANK AND TRUST COMPANY
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt0590 W FOREVERGREEN RD
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0NORTH LIBERTY
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0IA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd052317
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt0995
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt01054
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt01004
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.004324
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.004324
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd00
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt059
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt0230154
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt0232181
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt012054
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.004324
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt011995
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt012054
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt059
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt012054
IRS990PF/StatementsRegardingActy4720Grp/ActsFailToQlfyAsExceptionsInd00
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd00
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd01
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd00
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd00
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd00
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd00
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd00
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd01
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd00
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd00
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd00
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/TransactionsFailToQlfyAsExcInd01
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd00
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd00
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd00
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd00
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd01
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd00
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd01
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd00
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd00
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd00
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd01
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd00
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt0590 W FOREVERGREEN RD
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0NORTH LIBERTY
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0IA
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd0523178507
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd00
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd00
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd00
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0IA
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd00
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine1Txt0HILLS BANK AND TRUST COMPANY
IRS990PF/StatementsRegardingActyGrp/PhoneNum03193381522
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd00
IRS990PF/StatementsRegardingActyGrp/Section4955ManagersTaxAmt00
IRS990PF/StatementsRegardingActyGrp/Section4955OrganizationTaxAmt00
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd01
IRS990PF/StatementsRegardingActyGrp/TaxReimbursedAmt00
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd00
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SumOfProgramRelatedInvstGrp/TotalAmt00
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt01000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt11000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt210462
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt31000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt41000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0SCHOLARSHIP
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1SCHOLARSHIP
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt2SCHOLARSHIPS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt3SCHOLARSHIP
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt4SCHOLARSHIP
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt0IOWA STATE UNIVERSITY FBO KODY WALLICK
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt1UNIVERSITY OF NORTHERN IOWA FBO SARAH BECKER
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt2TIPTON COMMUNITY SCHOOL DISTRICT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt3UNIVERSITY OF NORTHERN IOWA FBO TRENT SCHROEDER
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt4UNIVERSITY OF IOWA FBO DEREK NEBERGALL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0I
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt1I
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt2PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt3I
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt4I
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt00210 BEARDSHEAR HALL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt1105 GILCHRIST HALL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt2400 E 6TH ST
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt3105 GILCHRIST HALL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt4208 CALVIN HALL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0AMES
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm1CEDAR FALLS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm2TIPTON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm3CEDAR FALLS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm4IOWA CITY
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/ZIPCd050011
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd150614
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd252772
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd350614
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd452242
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt00
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt014462
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/LoansOrLoanGuaranteesInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PerformanceOfServicesEtcInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PurchaseOfAssetsNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/ReimbursementArrangementsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RelationshipsNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RentalOfFacilitiesOthAssetsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SalesOrExchangesOfAssetsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SharingOfFacilitiesEtcInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd00
IRS990PF/UndistributedIncomeGrp/AppliedToCurrentYearAmt01592
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt010462
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt011449
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt012054
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt00
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt00
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt09857
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt010462
TaxesSchedule/TaxesDetail/Amt0125
TaxesSchedule/TaxesDetail/CategoryTxt0EXCISE TAX
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt00
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt00
ReturnHeader/BuildTS02016-09-27 15:27:22Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0JULIE BURTON
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUST OFFICER
ReturnHeader/BusinessOfficerGrp/PhoneNum03193381522
ReturnHeader/BusinessOfficerGrp/SignatureDt02016-05-16
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0DONALD H AND ELIZABETH J WERLING
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0SCHOLARSHIP FUND C/O HILLS BANK TTEE
ReturnHeader/Filer/BusinessNameControlTxt0DONA
ReturnHeader/Filer/EIN0426423052
ReturnHeader/Filer/PhoneNum03193381522
ReturnHeader/Filer/USAddress/AddressLine1Txt0590 W FOREVERGREEN RD
ReturnHeader/Filer/USAddress/CityNm0NORTH LIBERTY
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IA
ReturnHeader/Filer/USAddress/ZIPCd0523178507
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0420714325
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0RSM US LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0221 THIRD AVENUE SE STE 300
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0CEDAR RAPIDS
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0524011512
ReturnHeader/PreparerPersonGrp/PhoneNum03192985333
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0CARLEY UMSTEAD
ReturnHeader/ReturnTs02016-05-16T14:42:22-05:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02015-01-01
ReturnHeader/TaxPeriodEndDt02015-12-31
ReturnHeader/TaxYr02015

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$218,436
Liabilities
$0
Net assets
$218,436
Revenue
$7,470
Expenses
$17,771
Net income
-$10,301
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2023Summary only. Only limited summary data is available for this year.$1.54$0.00$0.07$0.12$0.05
2022XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.59$0.00$1.59$0.10$0.13$0.22
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.81$0.00$1.81$0.12$0.14$0.02
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.83$0.00$1.83$0.06$0.18$0.12
2019Detailed filing. Detailed filing data is available for this year.$1.95$0.00$1.95$0.06$0.04$0.02
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.93$0.00$1.93$0.10$0.14$0.03
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.96$0.00$1.96$0.05$0.14$0.09
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.05$0.00$2.05$0.08$0.21$0.13
2015Detailed filing. Detailed filing data is available for this year.$2.18$0.00$2.18$0.07$0.18$0.10
2014Detailed filing. Detailed filing data is available for this year.$2.29$0.00$2.29$0.08$0.07$0.01
2013Summary only. Only limited summary data is available for this year.$2.27$0.00$0.08$0.06$0.02
2012Summary only. Only limited summary data is available for this year.$2.26$0.00$0.05$0.08$0.03
2011Summary only. Only limited summary data is available for this year.$2.29$0.00$0.05$0.08$0.03