Civic Intelligence

Jonan Haskell Scholarship Trust

990PF • Fiscal year 2017 • EIN 42-6612322

Jan 01, 2017 to Dec 31, 2017 • Filed on May 10, 2018

Organization Profile
PO Box 928Burlington, IA 52601

(319) 753-2000

Siviq Scores

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

Liabilities / Assets

59th percentile

0.00x

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

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

Liabilities / Revenue

59th percentile

0.00x

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

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

Net Margin

72nd percentile

16%

Higher net margin than 72% of similar nonprofits.

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

Top Officer Pay

78th percentile

$1,723

Higher top officer pay than 78% of similar nonprofits.

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

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

Asset Growth

50th percentile

1.1%

Faster asset growth than 50% of similar nonprofits.

2017 filings • <$500k nonprofits • Annualized from 2016 to 2017

Revenue Growth

37th percentile

-6.2%

Faster revenue growth than 37% of similar nonprofits.

2017 filings • <$500k nonprofits • Annualized from 2016 to 2017

Balance Sheet
Liabilities / Assets59th percentile

Assets

Up

$139,924

Up $1,538 (+1.1%) from 2016

Net Assets

Up

$139,924

Up $1,538 (+1.1%) from 2016

Liabilities

Flat

$0

Flat from 2016

Revenue And Expenses
Liabilities / Revenue59th percentileNet Margin72nd percentile

Revenue

Down

$9,515

Down $633 (-6.2%) from 2016

Expenses

Down

$7,977

Down $3,769 (-32%) from 2016

Net Income

Up

$1,538

Up $3,136 (+196%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth50th percentile

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

$200K$150K$100K$50K$0Assets 2011: $137,962Liabilities 2011: $02011Assets 2012: $138,176Liabilities 2012: $12012Assets 2013: $136,513Liabilities 2013: $02013Assets 2014: $137,796Liabilities 2014: $0Net Assets 2014: $137,7962014Assets 2015: $140,071Liabilities 2015: $0Net Assets 2015: $140,0712015Assets 2016: $138,386Liabilities 2016: $0Net Assets 2016: $138,3862016Assets 2017: $139,924Liabilities 2017: $0Net Assets 2017: $139,9242017Assets 2018: $153,930Liabilities 2018: $0Net Assets 2018: $153,9302018Assets 2019: $163,335Liabilities 2019: $0Net Assets 2019: $163,3352019Assets 2020: $147,904Liabilities 2020: $0Net Assets 2020: $147,9042020Assets 2021: $159,646Liabilities 2021: $0Net Assets 2021: $159,6462021Assets 2022: $163,357Liabilities 2022: $0Net Assets 2022: $163,3572022Assets 2023: $157,905Liabilities 2023: $0Net Assets 2023: $157,9052023Assets 2024: $162,744Liabilities 2024: $0Net Assets 2024: $162,7442024

Highlighted filing

2017

Assets$139,924
Liabilities$0
Net Assets$139,924
Open 2017 Filing

Operations Trend

Revenue Growth37th percentile

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

$30K$20K$10K$0-$10K-$20KRevenue 2011: $11,933Expenses 2011: $10,388Net Income 2011: $1,5452011Revenue 2012: $5,004Expenses 2012: $4,790Net Income 2012: $2142012Revenue 2013: $8,898Expenses 2013: $10,561Net Income 2013: -$1,6632013Revenue 2014: $10,273Expenses 2014: $8,990Net Income 2014: $1,2832014Revenue 2015: $10,054Expenses 2015: $7,779Net Income 2015: $2,2752015Revenue 2016: $10,148Expenses 2016: $11,746Net Income 2016: -$1,5982016Revenue 2017: $9,515Expenses 2017: $7,977Net Income 2017: $1,5382017Revenue 2018: $22,413Expenses 2018: $8,407Net Income 2018: $14,0062018Revenue 2019: $14,772Expenses 2019: $5,367Net Income 2019: $9,4052019Revenue 2020: -$2,301Expenses 2020: $13,130Net Income 2020: -$15,4312020Revenue 2021: $24,218Expenses 2021: $12,476Net Income 2021: $11,7422021Revenue 2022: $10,010Expenses 2022: $6,299Net Income 2022: $3,7112022Revenue 2023: $4,155Expenses 2023: $9,607Net Income 2023: -$5,4522023Revenue 2024: $13,237Expenses 2024: $8,398Net Income 2024: $4,8392024

Highlighted filing

2017

Revenue$9,515
Expenses$7,977
Net Income$1,538
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
May 10, 2018
Return Version
2017v2.3
Compensation and Service Providers
Top Officer Pay78th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
-Trustee-$1,723-$1,723
Filing and Contact Details

Filer

Filer Name
Jonan Haskell Scholarship Trust
EIN
42-6612322
Address
PO BOX 928, BURLINGTON, IA 52601

Signing Officer

Name
Farmers Merchants Bank Trust
Title
Trustee
Signed
2018-05-10

Preparer

Firm
Menke & Company
Address
320 N 3RD ST STE 300, BURLINGTON, IA 52601-5313
Preparer
Jay W Henrich
Phone
3197532000
Raw XML Appendix332 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/Amt0550
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0ACCOUNTING FEES
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt0275
AccountingFeesSchedule/AccountingFeesDetail/NetInvestmentIncomeAmt0275
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt012399
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt113686
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt211614
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt318889
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt414225
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt516207
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt620430
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt76401
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt84358
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt98840
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt0GS-LARGE CAP GROWTH INSIGHTSFUND-A
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt1JP MORGAN US SMALL
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt2JP MORGAN S/C VALUE FUND
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt3MASS INV TRUST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt4OPPENHEIMER INTL
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt5PRINCIPAL EQUITY INCOME
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt6WRIGHT SELECT BLUE CHIP
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt7FUNDAMENTAL INVESTORS CLASS F-1
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt8PARAMETRIC EQUITY FD-A
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt9JANUS ENTERPRISE FUND-A
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt10JP MORGAN S/C VALUE FUND
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt11FULLER & THALER BEHAVIORAL SML
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt016107
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt119209
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt217833
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt322119
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt416287
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt518316
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt624845
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt77866
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt84173
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt99033
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd0AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd1AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd2AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd3AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd4AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd5AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd6AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd7AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd8AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd9AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd10AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd11AT COST
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt02102
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt07413
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt09515
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt09515
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesChrtblPrpsAmt0275
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncmAmt0275
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt0550
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt02264
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt07413
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt0861
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt0862
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt01723
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt05613
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt05613
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsAdjNetIncmAmt02102
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt02102
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt02102
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt01538
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt014785
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt07413
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt08378
IRS990PF/AnalysisOfRevenueAndExpenses/NetSTCapitalGainAdjNetIncmAmt0162
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt091
IRS990PF/AnalysisOfRevenueAndExpenses/TotalAdjNetIncmAmt02264
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt06749
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt01137
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt07977
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt09515
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt09515
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt01136
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt01137
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt02364
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt02016-12-22
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt12016-04-05
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt02700
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt14672
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt0162
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt11787
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt0162
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt11787
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt02862
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt16459
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd1P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0NET STCG
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc1NET LTCG
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt02017-10-06
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt12017-10-06
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt07413
IRS990PF/CapGainsLossTxInvstIncmDetail/NetShortTermCapitalGainLossAmt0162
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt01538
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0139924
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0138386
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0139924
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt07626
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt07626
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt07626
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt07794
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0168
IRS990PF/DistributableAmountGrp/TotalTaxAmt0168
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0168
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0168
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0168
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxDueAmt0168
IRS990PF/FMVAssetsEOYAmt0168663
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt0136217
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt0136217
IRS990PF/Form990PFBalanceSheetsGrp/CashBOYAmt012806
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYAmt012875
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYFMVAmt012875
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsBOYAmt0125580
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYAmt0127049
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt0155788
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt02169
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt03707
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0138386
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0139924
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0168663
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0138386
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0139924
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0138386
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0139924
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0158245
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt09102
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0149143
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt02374
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt07794
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0155871
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0158245
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/BusinessName/BusinessNameLine1Txt0FARMERS & MERCHANTS BANK & TRUST
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt01723
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt0PO BOX 928
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0BURLINGTON
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0IA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd052601
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt07327
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt07411
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt010490
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt06790
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt07673
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt07838
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt02625
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.047008
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.072252
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.044052
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.048602
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt00.051394
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt00.018738
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd0false
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt084
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt0155871
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt0145186
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt0154135
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt0157874
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt0152508
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt0140088
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt06749
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.235038
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt06749
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt06749
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt06749
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd0false
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd0true
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/TransactionsFailToQlfyAsExcInd0false
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/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt0PO BOX 928
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0BURLINGTON
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0IA
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd052601
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine1Txt0FARMERS & MERCHANTS TRUST
IRS990PF/StatementsRegardingActyGrp/PhoneNum03197542250
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0true
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SumOfProgramRelatedInvstGrp/Description1Txt0N/A
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/FormAndInfoAndMaterialsTxt0SEE TRUSTEE.
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientPersonNm0BURLINGTON HIGH SCHOOL GUIDANCE OFF
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientPhoneNum03197536634
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientUSAddress/AddressLine1Txt0421 TERRACE DR
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientUSAddress/CityNm0BURLINGTON
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientUSAddress/StateAbbreviationCd0IA
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientUSAddress/ZIPCd052601
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RestrictionsOnAwardsTxt0BURLINGTON COMMUNITY HIGH SCHOOL STUDENT THAT PLANS TO ATTEND AN ACCREDITED COLLEGE OR UNIVERSITY
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/SubmissionDeadlinesTxt0FEBRUARY 28
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/Amt02100
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/Amt12100
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/GrantOrContributionPurposeTxt0SCHOLARSHIP
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/GrantOrContributionPurposeTxt1SCHOLARSHIP
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/RecipientFoundationStatusTxt0N/A
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/RecipientFoundationStatusTxt1N/A
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/RecipientPersonNm0DANIEL TOPPING
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/RecipientPersonNm1JOSHUA GULICK
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/RecipientRelationshipTxt0NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/RecipientRelationshipTxt1NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/RecipientUSAddress/AddressLine1Txt02516 312TH ST
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/RecipientUSAddress/AddressLine1Txt12824 HERBLO DR
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/RecipientUSAddress/CityNm0DANVILLE
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/RecipientUSAddress/CityNm1BURLINGTON
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/RecipientUSAddress/StateAbbreviationCd0IA
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/RecipientUSAddress/StateAbbreviationCd1IA
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/RecipientUSAddress/ZIPCd052623
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/RecipientUSAddress/ZIPCd152601
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt01863
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt11875
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt21875
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0SCHOLARSHIP
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1SCHOLARSHIP
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt2SCHOLARSHIP
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0N/A
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt1NA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt2N/A
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm0RILEY MESSINGER
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm1RYAN Z KENDALL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm2COURTNEY N BRINKLEY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt1NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt2NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt03606 MEMORIAL PARK RD
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt12606 SUNNYSIDE AVE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt22608 LAVENDER LANE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0BURLINGTON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm1BURLINGTON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm2BURLINGTON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0IA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd1IA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd2IA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd052601
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd152601
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd252601
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt04200
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt05613
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/AppliedToCurrentYearAmt02718
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt04031
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt07626
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt06749
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt04908
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt04031
TaxesSchedule/TaxesDetail/Amt091
TaxesSchedule/TaxesDetail/CategoryTxt0TAX ON INVESTMENT INCOME
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/PersonNm0FARMERS MERCHANTS BANK TRUST
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-05-10
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0JONAN HASKELL SCHOLARSHIP TRUST
ReturnHeader/Filer/BusinessNameControlTxt0JONA
ReturnHeader/Filer/EIN0426612322
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 928
ReturnHeader/Filer/USAddress/CityNm0BURLINGTON
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IA
ReturnHeader/Filer/USAddress/ZIPCd052601
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId08CC986F7156BB2F67A1060121B947C405BE52E92
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId04CF8849768035064A66AD088D3D0337596F8C4C7
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0192.119.236.34
ReturnHeader/FilingSecurityInformation/IPDt02018-05-14
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CD
ReturnHeader/FilingSecurityInformation/IPTm014:15:40
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0421363298
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0MENKE & COMPANY
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0320 N 3RD ST STE 300
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0BURLINGTON
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0526015313
ReturnHeader/PreparerPersonGrp/PhoneNum03197532000
ReturnHeader/PreparerPersonGrp/PreparationDt02018-05-11
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0JAY W HENRICH
ReturnHeader/ReturnTs02018-05-14T14:15:40-05:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02017-01-01
ReturnHeader/TaxPeriodEndDt02017-12-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$139,924
Liabilities
$0
Net assets
$139,924
Revenue
$9,515
Expenses
$7,977
Net income
$1,538
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.63$0.00$1.63$0.13$0.08$0.05
2023XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.58$0.00$1.58$0.04$0.10$0.05
2022XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.63$0.00$1.63$0.10$0.06$0.04
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.60$0.00$1.60$0.24$0.12$0.12
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.48$0.00$1.48$0.02$0.13$0.15
2019XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.63$0.00$1.63$0.15$0.05$0.09
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.54$0.00$1.54$0.22$0.08$0.14
2017Detailed filing. Detailed filing data is available for this year.$1.40$0.00$1.40$0.10$0.08$0.02
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.38$0.00$1.38$0.10$0.12$0.02
2015XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.40$0.00$1.40$0.10$0.08$0.02
2014Detailed filing. Detailed filing data is available for this year.$1.38$0.00$1.38$0.10$0.09$0.01
2013Summary only. Only limited summary data is available for this year.$1.37$0.00$0.09$0.11$0.02
2012Summary only. Only limited summary data is available for this year.$1.38$0.00$0.05$0.05$0.00
2011Summary only. Only limited summary data is available for this year.$1.38$0.00$0.12$0.10$0.02