Civic Intelligence

Jonan Haskell Scholarship Trust

990PF • Fiscal year 2016 • EIN 42-6612322

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

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

58th percentile

0.00x

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

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

Liabilities / Revenue

58th percentile

0.00x

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

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

Net Margin

21st percentile

-16%

Higher net margin than 21% of similar nonprofits.

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

Top Officer Pay

78th percentile

$1,596

Higher top officer pay than 78% of similar nonprofits.

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

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

Asset Growth

44th percentile

-1.2%

Faster asset growth than 44% of similar nonprofits.

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

Revenue Growth

52nd percentile

0.9%

Faster revenue growth than 52% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets58th percentile

Assets

Down

$138,386

Down $1,685 (-1.2%) from 2015

Net Assets

Down

$138,386

Down $1,685 (-1.2%) from 2015

Liabilities

Flat

$0

Flat from 2015

Revenue And Expenses
Liabilities / Revenue58th percentileNet Margin21st percentile

Revenue

Up

$10,148

Up $94 (+0.9%) from 2015

Expenses

Up

$11,746

Up $3,967 (+51%) from 2015

Net Income

Down

-$1,598

Down $3,873 (-170%) from 2015

Historical Trend

Balance Sheet Trend

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

2016

Assets$138,386
Liabilities$0
Net Assets$138,386
Open 2016 Filing

Operations Trend

Revenue Growth52nd 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

2016

Revenue$10,148
Expenses$11,746
Net Income-$1,598
Open 2016 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2016 to Dec 31, 2016
Signed
May 3, 2017
Return Version
2016v3.0
Compensation and Service Providers
Top Officer Pay78th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
-Trustee-$1,596-$1,596
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
2017-05-03

Preparer

Firm
Menke & Company
Address
320 N 3RD ST STE 300, BURLINGTON, IA 52601-5313
Preparer
Jay W Henrich
Phone
3197532000
Raw XML Appendix352 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/CategoryTxt0INDIRECT ACCOUNTING FEES
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt0275
AccountingFeesSchedule/AccountingFeesDetail/NetInvestmentIncomeAmt0275
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/BondNm0AT&T
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/BondNm1VERIZON
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt012399
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt17372
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt24358
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt313686
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt411614
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt518889
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt614225
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt716207
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt820429
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt96401
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt0WELLS FARGO CD
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt1AMERICAN CENTURY HERITAGE
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt2FIDELITY ADV NEW INSIGHTS
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt3GS-LARGE CAP GROWTH INSIGHTSFUND-A
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt4JP MORGAN US SMALL
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt5JP MORGAN S/C VALUE FUND
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt6MFS RESEARCH
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt7MASS INV TRUST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt8OPPENHEIMER INTL
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt9PRINCIPAL EQUITY INCOME
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt10WRIGHT SELECT BLUE CHIP
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt11FUNDAMENTAL INVESTORS CLASS F-1
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt12PARAMETRIC EQUITY FD-A
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt13JANUS ENTERPRISE FUND-A
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt013036
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt18742
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt24327
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt316694
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt414170
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt519530
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt615205
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt716031
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt821533
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt96454
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
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd12AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd13AT COST
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt01505
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt07918
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionAmt0725
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt010148
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt010148
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesChrtblPrpsAmt0275
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncmAmt0275
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt0550
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt02230
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt07918
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt0798
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt0798
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt01596
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt09508
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt09508
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsAdjNetIncmAmt01505
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt01505
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt01505
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-1598
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt082921
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavingsAdjNetIncmAmt0725
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavNetInvstIncmAmt0725
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavRevAndExpnssAmt0725
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt07918
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt09075
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt092
IRS990PF/AnalysisOfRevenueAndExpenses/TotalAdjNetIncmAmt02230
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt010581
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt01073
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt011746
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt010148
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt010148
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt01073
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt01073
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt02238
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt02016-04-18
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt12011-12-06
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt05132
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt169871
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt0-104
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt15890
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt0-104
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt15890
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt05028
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt175761
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd1P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0NET STCG
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc1NET LTCG
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt02016-12-22
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt12016-12-22
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt07918
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-1598
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt087
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0138473
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0140071
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0138386
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt07168
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt07168
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt07168
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt07259
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt091
IRS990PF/DistributableAmountGrp/TotalTaxAmt091
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/DomesticOrgMeetingSect4940eInd0X
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt091
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt091
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt091
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxDueAmt091
IRS990PF/FMVAssetsEOYAmt0148528
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt0136217
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt0136217
IRS990PF/Form990PFBalanceSheetsGrp/CashBOYAmt09465
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYAmt012806
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYFMVAmt012806
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsBOYAmt020024
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsBOYAmt090585
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYAmt0125580
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt0135722
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt03854
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt02169
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0140071
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0138386
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0148528
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0140071
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0138386
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0140071
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0138386
IRS990PF/Form990PFBalanceSheetsGrp/USGovernmentObligationsBOYAmt019997
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0147397
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt026694
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0120703
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt02211
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt07259
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0145186
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0147397
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/BusinessName/BusinessNameLine1Txt0FARMERS & MERCHANTS BANK & TRUST
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt01596
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/AdjNetVlNoncharitableAssetsAmt06476
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt06567
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt06790
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt07673
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt07838
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt02625
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt08190
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.044608
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.044052
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.048602
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.051394
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt00.018738
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt00.060253
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd0false
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt091
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt0145186
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt0154135
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt0157874
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt0152508
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt0140088
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt0135927
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt010581
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.223039
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt010490
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt010581
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt091
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt010581
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/Amt01863
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/GrantOrContributionPurposeTxt0SCHOLARSHIP
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/RecipientFoundationStatusTxt0N/A
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/RecipientPersonNm0RILEY MESSINGER
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/RecipientRelationshipTxt0NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/RecipientUSAddress/AddressLine1Txt03606 MEMORIAL PARK RD
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/RecipientUSAddress/CityNm0BURLINGTON
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/RecipientUSAddress/StateAbbreviationCd0IA
IRS990PF/SupplementaryInformationGrp/GrantOrContriApprvForFutGrp/RecipientUSAddress/ZIPCd052601
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt01960
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt11960
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt21862
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt31863
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt41863
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0SCHOLARSHIP
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1SCHOLARSHIP
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt2SCHOLARSHIP
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt3SCHOLARSHIP-EQUIPMENT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt4SCHOLARSHIP
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0N/A
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt1N/A
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt2N/A
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt3NA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt4N/A
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm0GRACE ROSSON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm1JACE BLOOMER
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm2LAUREN GALVIN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm3LAUREN GALVIN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm4RILEY MESSINGER
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt1NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt2NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt3NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt4NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt0604 SWEENY AVE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt11009 HAGEMANN AVE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt2820 RANDALL LANE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt3820 RANDALL LANE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt43606 MEMORIAL PARK RD
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0BURLINGTON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm1BURLINGTON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm2BURLINGTON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm3BURLINGTON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm4BURLINGTON
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/ZIPCd052601
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd152601
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd252601
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd352601
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd452601
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt01863
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt09508
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/AppliedToCurrentYearAmt03137
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt07444
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt07168
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt010581
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt04031
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt07444
OtherDecreasesSchedule/OtherDecreasesDetail/Amt087
OtherDecreasesSchedule/OtherDecreasesDetail/Desc0NET CHANGE IN PURCHASES
TaxesSchedule/TaxesDetail/Amt092
TaxesSchedule/TaxesDetail/CategoryTxt0TAX ON INVESTMENT INCOME
ReturnHeader/BuildTS02017-02-10 21:41:12Z
ReturnHeader/BusinessOfficerGrp/PersonNm0FARMERS MERCHANTS BANK TRUST
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/SignatureDt02017-05-03
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/AtSubmissionCreationDeviceId0035FB0DDC4646044A49DF462A52681AAAD0147C6
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0E2088E6D5C65EC7C0B9D4344ED0C9BEB2B7F9092
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/PreparationDt02017-05-11
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0JAY W HENRICH
ReturnHeader/ReturnTs02017-05-11T15:37:34-05:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02016-01-01
ReturnHeader/TaxPeriodEndDt02016-12-31
ReturnHeader/TaxYr02016

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$138,386
Liabilities
$0
Net assets
$138,386
Revenue
$10,148
Expenses
$11,746
Net income
-$1,598
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
2017XML 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
2016Detailed filing. Detailed filing data is available for this year.$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