Civic Intelligence

Herbert W Mehl Trust

990PF • Fiscal year 2012 • EIN 42-6300079

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

PO Box 28052627-2805
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

78th percentile

$5,208

Higher top officer pay than 78% of similar nonprofits.

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

Asset Growth

35th percentile

-2.2%

Faster asset growth than 35% 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.

Assets

Down

$638,632

Down $14,655 (-2.2%) from 2011

Net Assets

$638,632

No earlier filing loaded for comparison.

Liabilities

Flat

$0

Flat from 2011

Revenue

-

No earlier filing loaded for comparison.

Expenses

Down

$54,374

Down $1,111 (-2.0%) from 2011

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

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

$800K$600K$400K$200K$0Assets 2011: $653,287Liabilities 2011: $02011Assets 2012: $638,632Liabilities 2012: $0Net Assets 2012: $638,6322012Assets 2013: $621,767Liabilities 2013: $02013Assets 2014: $727,462Liabilities 2014: $0Net Assets 2014: $727,4622014Assets 2015: $701,777Liabilities 2015: $0Net Assets 2015: $701,7772015Assets 2016: $676,305Liabilities 2016: $0Net Assets 2016: $676,3052016Assets 2017: $652,325Liabilities 2017: $0Net Assets 2017: $652,3252017Assets 2018: $642,906Liabilities 2018: $0Net Assets 2018: $642,9062018Assets 2019: $627,052Liabilities 2019: $0Net Assets 2019: $627,0522019Assets 2020: $608,840Liabilities 2020: $0Net Assets 2020: $608,8382020Assets 2021: $592,611Liabilities 2021: $0Net Assets 2021: $592,6112021Assets 2022: $569,924Liabilities 2022: $0Net Assets 2022: $569,9242022Assets 2023: $546,105Liabilities 2023: $0Net Assets 2023: $546,1052023Assets 2024: $543,827Liabilities 2024: $0Net Assets 2024: $543,8272024

Highlighted filing

2012

Assets$638,632
Liabilities$0
Net Assets$638,632

Operations Trend

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

$200K$150K$100K$50K$0-$50KRevenue 2011: $23,914Expenses 2011: $55,485Net Income 2011: -$31,5712011Expenses 2012: $54,3742012Revenue 2013: $38,805Expenses 2013: $55,671Net Income 2013: -$16,8662013Revenue 2014: $159,683Expenses 2014: $53,988Net Income 2014: $105,6952014Revenue 2015: $33,252Expenses 2015: $58,937Net Income 2015: -$25,6852015Revenue 2016: $31,402Expenses 2016: $56,874Net Income 2016: -$25,4722016Revenue 2017: $31,940Expenses 2017: $55,920Net Income 2017: -$23,9802017Revenue 2018: $50,179Expenses 2018: $59,598Net Income 2018: -$9,4192018Revenue 2019: $34,653Expenses 2019: $50,507Net Income 2019: -$15,8542019Revenue 2020: $40,495Expenses 2020: $58,709Net Income 2020: -$18,2142020Revenue 2021: $43,458Expenses 2021: $59,687Net Income 2021: -$16,2292021Revenue 2022: $37,779Expenses 2022: $60,466Net Income 2022: -$22,6872022Revenue 2023: $27,298Expenses 2023: $51,117Net Income 2023: -$23,8192023Revenue 2024: $50,479Expenses 2024: $52,757Net Income 2024: -$2,2782024

Highlighted filing

2012

Revenue-
Expenses$54,374
Net Income-
Jump To
Filing Snapshot
Filing Period
Jan 1, 2012 to Dec 31, 2012
Signed
May 14, 2013
Return Version
2012v2.1
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
Lee County Bank and Trust NATrustee-$5,208-$5,208
Grants and Assistance

Foundation Grants and Related Investments

TypeRecipientPurposeStatusLocationAmount
Paid Grant-General gift per TrustPublicAkron, PA, US$8,928
Paid Grant-General gift per TrustPublicDes Moines, IA, US$8,928
Paid Grant-General gift per TrustPublicSaint Charles, MO, US$8,928
Paid Grant-General gift per TrustPublicTampa, FL, US$8,928
Paid Grant-General gift per TrustPublicPiney Woods, MS, US$8,928
Paid Grant-General Gift per TrustPublicBurlington, IA, US$1,000
Filing and Contact Details

Filer

EIN
42-6300079
Raw XML Appendix395 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
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/EOYBookValue029932
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/EOYBookValue129801
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/EOYBookValue231118
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/EOYBookValue327857
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/EOYBookValue450125
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/EOYBookValue528709
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/EOYBookValue650004
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/EOYFMV035332
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/EOYFMV132530
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/EOYFMV236120
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/EOYFMV333450
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/EOYFMV462160
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/EOYFMV530934
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/EOYFMV654755
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/NameOfBond0American Home Prods
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/NameOfBond1Coca Cola
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/NameOfBond2Dell Computer
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/NameOfBond3DuPont
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/NameOfBond4GE Cap
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/NameOfBond5McDonalds
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/NameOfBond6Principal Life
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYBookValue05500
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYBookValue111307
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYBookValue220424
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYBookValue323593
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYBookValue416814
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYBookValue59332
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYFMV034450
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYFMV115586
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYFMV230678
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYFMV330120
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYFMV428854
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYFMV516180
InvestmentsCorpStockSchedule/InvestmentsCorpStock/NameOfStock0Meredith Corp
InvestmentsCorpStockSchedule/InvestmentsCorpStock/NameOfStock1Vanguard Emerging Markets
InvestmentsCorpStockSchedule/InvestmentsCorpStock/NameOfStock2Vanguard Sector Index-energy
InvestmentsCorpStockSchedule/InvestmentsCorpStock/NameOfStock3Vanguard Sector Index-util
InvestmentsCorpStockSchedule/InvestmentsCorpStock/NameOfStock4Vanguard Index mid cap vipers
InvestmentsCorpStockSchedule/InvestmentsCorpStock/NameOfStock5Vanguard Index small cap viper
InvestmentsOtherSchedule2/InvestmentsOther/BookValue078341
InvestmentsOtherSchedule2/InvestmentsOther/BookValue143612
InvestmentsOtherSchedule2/InvestmentsOther/BookValue2100239
InvestmentsOtherSchedule2/InvestmentsOther/CategoryOrItem0Federated Equity Inc Fd
InvestmentsOtherSchedule2/InvestmentsOther/CategoryOrItem1Vanguard Health Care Fd
InvestmentsOtherSchedule2/InvestmentsOther/CategoryOrItem2Vanguard Total Stock Mkt Idx
InvestmentsOtherSchedule2/InvestmentsOther/EOYFMV080829
InvestmentsOtherSchedule2/InvestmentsOther/EOYFMV151459
InvestmentsOtherSchedule2/InvestmentsOther/EOYFMV2106898
IRS990PF/AnalysisIncomeProducingActy/DividendsAndIntFromSecPartVII/RelatedOrExemptFunctionIncome010340
IRS990PF/AnalysisIncomeProducingActy/GainSalesAssetsOthThanInvntry/RelatedOrExemptFunctionIncome014285
IRS990PF/AnalysisIncomeProducingActy/IntOnSavingsAndTempCashInvst/RelatedOrExemptFunctionIncome014786
IRS990PF/AnalysisIncomeProducingActy/OtherRevenueDescribed/Description0Federated litigation
IRS990PF/AnalysisIncomeProducingActy/OtherRevenueDescribed/RelatedOrExemptFunctionIncome0307
IRS990PF/AnalysisIncomeProducingActy/SubtotalsPartXVIA/RelatedOrExemptFunctionIncome039718
IRS990PF/AnalysisIncomeProducingActy/TotalPartXVIA039718
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncome00
IRS990PF/AnalysisOfRevenueAndExpenses/CapitalGainNetIncmNetInvstIncm014285
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidDsbrsChrtblPrps045640
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidRevAndExpnss045640
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncm010340
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnss010340
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessOfRevenueOverExpenses0-14656
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPrice037811
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavingsNetInvstIncm014786
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavingsRevAndExpnss014786
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesDsbrsChrtblPrps01662
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesNetInvstIncm01663
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesRevAndExpnss03325
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAssetsRevAndExpnss014285
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncome035255
IRS990PF/AnalysisOfRevenueAndExpenses/NotRequiredToAttachScheduleB0X
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesDsbrsChrtblPrps05
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesNetInvstIncm05
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnss010
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeNetInvstIncm0307
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeRevAndExpnss0307
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesDsbrsChrtblPrps02604
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesNetInvstIncm02604
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesRevAndExpnss05208
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncm0191
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnss0191
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblPrps049911
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncm04463
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnss054374
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvestmentIncome039718
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevenueAndExpenses039718
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblPrps04271
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncm04463
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnss08734
IRS990PF/BalanceSheets/InvestmentsCorpBondsBOY0247546
IRS990PF/BalanceSheets/InvestmentsCorpBondsEOY0247546
IRS990PF/BalanceSheets/InvestmentsCorpBondsEOYFMV0285281
IRS990PF/BalanceSheets/InvestmentsCorpStockBOY0110496
IRS990PF/BalanceSheets/InvestmentsCorpStockEOY086970
IRS990PF/BalanceSheets/InvestmentsCorpStockEOYFMV0155868
IRS990PF/BalanceSheets/InvestmentsOtherBOY0221316
IRS990PF/BalanceSheets/InvestmentsOtherEOY0222192
IRS990PF/BalanceSheets/InvestmentsOtherEOYFMV0239186
IRS990PF/BalanceSheets/OrgThatFollowSFAS1170X
IRS990PF/BalanceSheets/SavingsAndTempCashInvstBOY073929
IRS990PF/BalanceSheets/SavingsAndTempCashInvstEOY081924
IRS990PF/BalanceSheets/SavingsAndTempCashInvstEOYFMV081924
IRS990PF/BalanceSheets/TotalAssetsBOY0653287
IRS990PF/BalanceSheets/TotalAssetsEOY0638632
IRS990PF/BalanceSheets/TotalAssetsEOYFMV0762259
IRS990PF/BalanceSheets/TotalLiabilitiesBOY00
IRS990PF/BalanceSheets/TotalLiabilitiesEOY00
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsBOY0653287
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsEOY0638632
IRS990PF/BalanceSheets/TotalNetAssetsBOY0653287
IRS990PF/BalanceSheets/TotalNetAssetsEOY0638632
IRS990PF/BalanceSheets/UnrestrictedBOY0653287
IRS990PF/BalanceSheets/UnrestrictedEOY0638632
IRS990PF/CapitalGainsAndLosses/CapitalGainNetIncome014285
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/CostOrOtherBasis04846
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/CostOrOtherBasis16808
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/CostOrOtherBasis27206
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/CostOrOtherBasis34666
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DateAcquired02011-07-01
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DateAcquired12009-06-15
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DateAcquired22008-12-30
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DateAcquired32009-06-15
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DateAcquired42009-06-15
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DateSold02012-12-26
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DateSold12012-09-24
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DateSold22012-09-24
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DateSold32012-09-24
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DateSold42012-09-24
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DescriptionOfAsset0Vanguard Health Care--CG reinvest
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DescriptionOfAsset1Vanguard Emerging Markets
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DescriptionOfAsset2Vanguard Sector Index
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DescriptionOfAsset3Vanguard Index Fds Mid Cap
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DescriptionOfAsset4Vanguard Index FDS Small cap
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainOrLoss0714
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainOrLoss11319
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainOrLoss23922
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainOrLoss34949
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainOrLoss43381
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainsMinusExcessOrLosses0714
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainsMinusExcessOrLosses11319
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainsMinusExcessOrLosses23922
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainsMinusExcessOrLosses34949
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainsMinusExcessOrLosses43381
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GrossSalesPrice0714
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GrossSalesPrice16165
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GrossSalesPrice210730
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GrossSalesPrice312155
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GrossSalesPrice48047
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/HowAcquired0P
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/HowAcquired1P
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/HowAcquired2P
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/HowAcquired3P
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/HowAcquired4P
IRS990PF/ChangesInNetAssetsFundBalances/ExcessOfRevenueOverExpenses0-14656
IRS990PF/ChangesInNetAssetsFundBalances/OtherIncreases01
IRS990PF/ChangesInNetAssetsFundBalances/Subtotal0638632
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesBOY0653287
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesEOY0638632
IRS990PF/DistributableAmount/DistributableAmountAsAdjusted033801
IRS990PF/DistributableAmount/DistributableAmountBeforeAdj033801
IRS990PF/DistributableAmount/DistributableAmountBeforeDed033801
IRS990PF/DistributableAmount/MinimumInvestmentReturn034154
IRS990PF/DistributableAmount/TaxBasedOnInvestmentIncome0353
IRS990PF/DistributableAmount/TotalTax0353
IRS990PF/ExciseTaxBasedOnInvestmentIncm/DomesticOrgMeetingSect4940e0X
IRS990PF/ExciseTaxBasedOnInvestmentIncm/InvestmentIncomeExciseTax0353
IRS990PF/ExciseTaxBasedOnInvestmentIncm/SubtitleATax00
IRS990PF/ExciseTaxBasedOnInvestmentIncm/Subtotal0353
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxBasedOnInvestmentIncome0353
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxDue0353
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxUnderSection51100
IRS990PF/ExemptPF0X
IRS990PF/FMVAssetsEOY0762259
IRS990PF/MethodOfAccountingCash0X
IRS990PF/MinimumInvestmentReturn/AcquisitionIndebtedness00
IRS990PF/MinimumInvestmentReturn/AdjTotalFMVOfUnusedAssets0693486
IRS990PF/MinimumInvestmentReturn/AvgMonthlyCashBalances061019
IRS990PF/MinimumInvestmentReturn/AvgMonthlyFMVOfSecurities0632467
IRS990PF/MinimumInvestmentReturn/CashDeemedCharitable010402
IRS990PF/MinimumInvestmentReturn/FMVAllOtherNoncharitableAssets00
IRS990PF/MinimumInvestmentReturn/MinimumInvestmentReturn034154
IRS990PF/MinimumInvestmentReturn/NetNoncharitableAssets0683084
IRS990PF/MinimumInvestmentReturn/TotalFMVOfUnusedAssets0693486
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHighestPaidEmplNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition00.00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation05208
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ContriToEmplBenefitPlansEtc00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ExpenseAccountOtherAllowances00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/PersonName0Lee County Bank and Trust NA
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title0Trustee
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine10PO Box 280
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City0Fort Madison
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State0IA
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode0526272805
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/TotNumberOfOthEmplPaidOver50k00
IRS990PF/QlfyUndSect4940eForReducedTax/AdjNonchrtblAssetsAndOnePct048496
IRS990PF/QlfyUndSect4940eForReducedTax/AdjustedNoncharitableAssets048143
IRS990PF/QlfyUndSect4940eForReducedTax/AverageDistributionRatio00.070479
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear100.070692
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear200.068043
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear300.068454
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear400.079685
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear500.06552
IRS990PF/QlfyUndSect4940eForReducedTax/NetNoncharitableAssets0683084
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear10653685
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear20709287
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear30657832
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear40745284
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear50930854
IRS990PF/QlfyUndSect4940eForReducedTax/OnePercentNetInvestmentIncome0353
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributions049911
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear1046210
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear2048262
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear3045031
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear4059388
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear5060990
IRS990PF/QlfyUndSect4940eForReducedTax/TotalDistributionRatio00.352394
IRS990PF/QualifyingDistributions/AdjQualifyingDistributions049558
IRS990PF/QualifyingDistributions/ExpensesAndContributions049911
IRS990PF/QualifyingDistributions/OnePctSect4940eOrgNetInvstIncm0353
IRS990PF/QualifyingDistributions/QualifyingDistributions049911
IRS990PF/StatementsRegardingActivities/ActivitiesNotPrevReported0false
IRS990PF/StatementsRegardingActivities/ApplicableInsuranceContract0false
IRS990PF/StatementsRegardingActivities/AtLeast5000InAssets0true
IRS990PF/StatementsRegardingActivities/BooksInCareOfPersonName0Lee County Bank and Trust NA
IRS990PF/StatementsRegardingActivities/BooksInCareOfPhoneNumber03193722243
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/AddressLine10PO Box 280
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/City0Fort Madison
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/State0IA
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/ZIPCode0526272805
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/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/ProhibitedTaxShelterTransactn0false
IRS990PF/StatementsRegardingActy4720/RcvFundsToPayPrsnlBnftContract0false
IRS990PF/StatementsRegardingActy4720/SaleOrExchangeWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/TransferAssetsToDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/UncorrectedPriorActs0false
IRS990PF/StatementsRegardingActy4720/UndistributedIncomePriorYears0false
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount01000
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount18928
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount28928
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount38928
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount48928
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount58928
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution0General Gift per Trust
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution1General gift per Trust
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution2General gift per Trust
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution3General gift per Trust
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution4General gift per Trust
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution5General gift per Trust
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus0Public
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus1Public
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus2Public
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus3Public
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus4Public
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus5Public
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientPersonName0Salvation Army
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientPersonName1Mennonite Central Committee
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientPersonName2Easter Seal Society of Iowa
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientPersonName3Emmaus Homes Inc
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientPersonName4Shriners Hospitals for Childre
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientPersonName5Piney Woods Country Life Schoo
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine10PO Box 67
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine1121 S 12th St PO Box 500
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine12PO Box 4001
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine13PO Box 220
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine142900 Rocky Point Dr
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine15PO Box 57
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City0Burlington
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City1Akron
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City2Des Moines
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City3Saint Charles
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City4Tampa
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City5Piney Woods
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State0IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State1PA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State2IA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State3MO
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State4FL
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State5MS
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode052601
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode117501
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode250313
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode363301
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode433607
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode539148
IRS990PF/SupplementaryInformation/OnlyContributesToPreselected0X
IRS990PF/SupplementaryInformation/TotGrantOrContriPaidDuringYear045640
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/AppliedToCurrentYear033801
IRS990PF/UndistributedIncome/DistributableAmountAsAdjusted033801
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear1013908
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear2013250
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear3012532
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear4020074
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear5015701
IRS990PF/UndistributedIncome/ExcessDistriCyovAppCYCorpus016110
IRS990PF/UndistributedIncome/ExcessDistriCyovAppliedCY016110
IRS990PF/UndistributedIncome/ExcessDistriCyovToNextYear075465
IRS990PF/UndistributedIncome/ExcessFromCurrentYear016110
IRS990PF/UndistributedIncome/ExcessFromYear1013908
IRS990PF/UndistributedIncome/ExcessFromYear2013250
IRS990PF/UndistributedIncome/ExcessFromYear3012532
IRS990PF/UndistributedIncome/ExcessFromYear4019665
IRS990PF/UndistributedIncome/QualifyingDistributions049911
IRS990PF/UndistributedIncome/RemainingDistriFromCorpus016110
IRS990PF/UndistributedIncome/TotalCorpus075465
IRS990PF/UndistributedIncome/TotalExcessDistriCarryover075465
IRS990PF/UndistributedIncome/UndistributedIncomeCY00
LegalFeesSchedule/LegalFees/AdjustedNetIncome00
LegalFeesSchedule/LegalFees/Amount03325
LegalFeesSchedule/LegalFees/Category0attorney fees
LegalFeesSchedule/LegalFees/DisbursementsCharitablePrps01662
LegalFeesSchedule/LegalFees/NetInvestmentIncome01663
OtherExpensesSchedule/OtherExpenses/AdjustedNetIncome00
OtherExpensesSchedule/OtherExpenses/Description0Court Costs
OtherExpensesSchedule/OtherExpenses/DisbursementsCharitablePrps05
OtherExpensesSchedule/OtherExpenses/NetInvestmentIncome05
OtherExpensesSchedule/OtherExpenses/RevenueAndExpensesPerBooks010
OtherIncomeSchedule2/OtherIncome/AdjustedNetIncome00
OtherIncomeSchedule2/OtherIncome/Description0Litigation proceeds-Federated
OtherIncomeSchedule2/OtherIncome/NetInvestmentIncome0307
OtherIncomeSchedule2/OtherIncome/RevenueAndExpensesPerBooks0307
OtherIncreasesSchedule/OtherIncreases/Amount01
OtherIncreasesSchedule/OtherIncreases/Description0addition for rounding fractions
OtherProfessionalFeesSchedule/OtherProfessionalFees/AdjustedNetIncome00
OtherProfessionalFeesSchedule/OtherProfessionalFees/Amount05208
OtherProfessionalFeesSchedule/OtherProfessionalFees/Category0Trustee Fees
OtherProfessionalFeesSchedule/OtherProfessionalFees/DisbursementsCharitablePrps02604
OtherProfessionalFeesSchedule/OtherProfessionalFees/NetInvestmentIncome02604
TaxesSchedule/Taxes/AdjustedNetIncome00
TaxesSchedule/Taxes/Amount0191
TaxesSchedule/Taxes/Category0Federal Excise Tax
TaxesSchedule/Taxes/DisbursementsCharitablePrps00
TaxesSchedule/Taxes/NetInvestmentIncome0191
ReturnHeader/BuildTS02016-02-25 16:41:14Z
ReturnHeader/Filer/EIN0426300079
ReturnHeader/Filer/Name/BusinessNameLine10Herbert W Mehl Trust
ReturnHeader/Filer/NameControl0HERB
ReturnHeader/Filer/USAddress/AddressLine10PO Box 280
ReturnHeader/Filer/USAddress/City0Fort Madison
ReturnHeader/Filer/USAddress/State0IA
ReturnHeader/Filer/USAddress/ZIPCode0526272805
ReturnHeader/Officer/AuthorizeThirdParty0true
ReturnHeader/Officer/DateSigned02013-05-14
ReturnHeader/Officer/Name0Julia M Patterson
ReturnHeader/Officer/Phone03193722243
ReturnHeader/Officer/Title0VP & Trust Offi
ReturnHeader/Preparer/DatePrepared02013-05-14
ReturnHeader/PreparerFirm/EIN0391883919
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10Napier Wolf Popejoy & Auge LLP
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine10607 8th St Ste 1
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0Fort Madison
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0IA
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode052627
ReturnHeader/Preparer/Name0Christy L Popejoy
ReturnHeader/Preparer/Phone03193722934
ReturnHeader/Preparer/SelfEmployed0X
ReturnHeader/ReturnType0990PF
ReturnHeader/TaxPeriodBeginDate02012-01-01
ReturnHeader/TaxPeriodEndDate02012-12-31
ReturnHeader/TaxYear02012
ReturnHeader/Timestamp02013-05-14T14:28:44-05:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$5.44$0.00$5.44$0.50$0.53$0.02
2023Detailed filing. Detailed filing data is available for this year.$5.46$0.00$5.46$0.27$0.51$0.24
2022Detailed filing. Detailed filing data is available for this year.$5.70$0.00$5.70$0.38$0.60$0.23
2021Detailed filing. Detailed filing data is available for this year.$5.93$0.00$5.93$0.43$0.60$0.16
2020Detailed filing. Detailed filing data is available for this year.$6.09$0.00$6.09$0.40$0.59$0.18
2019Detailed filing. Detailed filing data is available for this year.$6.27$0.00$6.27$0.35$0.51$0.16
2018Detailed filing. Detailed filing data is available for this year.$6.43$0.00$6.43$0.50$0.60$0.09
2017Detailed filing. Detailed filing data is available for this year.$6.52$0.00$6.52$0.32$0.56$0.24
2016Detailed filing. Detailed filing data is available for this year.$6.76$0.00$6.76$0.31$0.57$0.25
2015Detailed filing. Detailed filing data is available for this year.$7.02$0.00$7.02$0.33$0.59$0.26
2014Detailed filing. Detailed filing data is available for this year.$7.27$0.00$7.27$1.60$0.54$1.06
2013Summary only. Only limited summary data is available for this year.$6.22$0.00$0.39$0.56$0.17
2012Detailed filing. Detailed filing data is available for this year.$6.39$0.00$6.39$0.54
2011Summary only. Only limited summary data is available for this year.$6.53$0.00$0.24$0.55$0.32