Civic Intelligence

Esther Hutmacher Parriott Scholarship Farm Trust

990 • Fiscal year 2017 • EIN 36-3450044

Jul 01, 2016 to Jun 30, 2017 • Filed on Nov 01, 2017

Organization ProfileWWW.ROE8.COM/SCHOLARSHIPS.HTM
27 Sstate Ave Suite 101Freeport, IL 61032

(815) 599-1408

Siviq Scores

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

Liabilities / Assets

17th percentile

0.00x

Higher debt load relative to assets than 17% of similar nonprofits.

2017 filings • 501(c)3 • $1M-$5M nonprofits • Source year 2017

Liabilities / Revenue

24th percentile

0.01x

Higher debt load relative to revenue than 24% of similar nonprofits.

2017 filings • 501(c)3 • $1M-$5M nonprofits • Source year 2017

Net Margin

13th percentile

-21%

Higher net margin than 13% of similar nonprofits.

2017 filings • 501(c)3 • $1M-$5M nonprofits • Source year 2017

Top Officer Pay

35th percentile

$0

Higher top officer pay than 35% of similar nonprofits.

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

2017 filings • 501(c)3 • $1M-$5M nonprofits • Source year 2017

Asset Growth

32nd percentile

-1.5%

Faster asset growth than 32% of similar nonprofits.

2017 filings • 501(c)3 • $1M-$5M nonprofits • Annualized from 2016 to 2017

Revenue Growth

16th percentile

-14%

Faster revenue growth than 16% of similar nonprofits.

2017 filings • 501(c)3 • $1M-$5M nonprofits • Annualized from 2016 to 2017

Balance Sheet
Liabilities / Assets17th percentile

Assets

Down

$1,899,680

Down $29,851 (-1.5%) from 2016

Net Assets

Down

$1,897,680

Down $29,851 (-1.5%) from 2016

Liabilities

Flat

$2,000

Flat from 2016

Revenue And Expenses
Liabilities / Revenue24th percentileNet Margin13th percentile

Revenue

Down

$142,949

Down $23,948 (-14%) from 2016

Expenses

Up

$172,800

Up $33,457 (+24%) from 2016

Net Income

Down

-$29,851

Down $57,405 (-208%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth32nd percentile

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

$3.0M$2.0M$1.0M$0Assets 2011: $1,699,617Liabilities 2011: $1,500Net Assets 2011: $1,698,1172011Assets 2012: $1,744,238Liabilities 2012: $2,000Net Assets 2012: $1,742,2382012Assets 2014: $1,888,105Liabilities 2014: $2,000Net Assets 2014: $1,886,1052014Assets 2015: $1,901,977Liabilities 2015: $2,000Net Assets 2015: $1,899,9772015Assets 2016: $1,929,531Liabilities 2016: $2,000Net Assets 2016: $1,927,5312016Assets 2017: $1,899,680Liabilities 2017: $2,000Net Assets 2017: $1,897,6802017Assets 2018: $1,833,140Liabilities 2018: $2,000Net Assets 2018: $1,831,1402018Assets 2019: $1,823,826Liabilities 2019: $2,000Net Assets 2019: $1,821,8262019Assets 2020: $1,798,011Liabilities 2020: $2,000Net Assets 2020: $1,796,0112020Assets 2021: $1,826,750Liabilities 2021: $2,000Net Assets 2021: $1,824,7502021Assets 2022: $1,823,911Liabilities 2022: $2,000Net Assets 2022: $1,821,9112022Assets 2023: $1,880,853Liabilities 2023: $2,000Net Assets 2023: $1,878,8532023Assets 2024: $1,949,020Liabilities 2024: $2,000Net Assets 2024: $1,947,0202024Assets 2025: $2,089,747Liabilities 2025: $2,000Net Assets 2025: $2,087,7472025

Highlighted filing

2017

Assets$1,899,680
Liabilities$2,000
Net Assets$1,897,680
Open 2017 Filing

Operations Trend

Revenue Growth16th percentile

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

$300K$200K$100K$0-$100KExpenses 2011: $86,5682011Expenses 2012: $86,3812012Revenue 2014: $167,582Expenses 2014: $89,631Net Income 2014: $77,9512014Revenue 2015: $140,968Expenses 2015: $127,095Net Income 2015: $13,8732015Revenue 2016: $166,897Expenses 2016: $139,343Net Income 2016: $27,5542016Revenue 2017: $142,949Expenses 2017: $172,800Net Income 2017: -$29,8512017Revenue 2018: $106,345Expenses 2018: $172,885Net Income 2018: -$66,5402018Revenue 2019: $163,371Expenses 2019: $172,685Net Income 2019: -$9,3142019Revenue 2020: $144,763Expenses 2020: $170,578Net Income 2020: -$25,8152020Revenue 2021: $161,025Expenses 2021: $132,286Net Income 2021: $28,7392021Revenue 2022: $145,379Expenses 2022: $148,218Net Income 2022: -$2,8392022Revenue 2023: $184,692Expenses 2023: $127,750Net Income 2023: $56,9422023Revenue 2024: $176,167Expenses 2024: $108,000Net Income 2024: $68,1672024Revenue 2025: $249,477Expenses 2025: $108,750Net Income 2025: $140,7272025

Highlighted filing

2017

Revenue$142,949
Expenses$172,800
Net Income-$29,851
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2016 to Jun 30, 2017
Signed
Nov 1, 2017
Return Version
2016v3.0
Gross Receipts
$364,061
Mission and Program Overview

Mission

The esther hutmacher parriott scholarship farm trust's mission and most significant activity is to provide college scholarships for students in stephenson county, illinois who come from farm families and choose to further their education by selecting degrees in an agricultural - related field of study.

Balance Sheet Detail
LineBeginningEndChange
Assets
Investments in Publicly Traded Securities$1,066,604$1,105,134▲ $38,530
Land, Buildings, and Equipment, Net$640,911$636,463▼ $4,448
Cash and Non-Interest-Bearing Accounts$178,275$114,320▼ $63,955
Savings and Temporary Cash Investments$43,741$43,763▲ $22
Total Assets$1,929,531$1,899,680▼ $29,851
Liabilities
Other Liabilities$2,000$2,000→ $0
Total Liabilities$2,000$2,000→ $0
Net Assets / Fund Balance
Permanently Rstr Net Assets$1,747,227$1,764,938▲ $17,711
Unrestricted Net Assets$180,304$132,742▼ $47,562
Total Net Assets Fund Balance$1,927,531$1,897,680▼ $29,851
Total Liabilities and Net Assets / Fund Balance$1,929,531$1,899,680▼ $29,851

Asset Categories

AssetBook ValueDepreciationBasis
Land$600,017-$600,017
Buildings$24,746$128,481$153,227
Other Land Buildings$11,700$103,339$115,039
Compensation and Service Providers
Top Officer Pay35th percentile

Board Members and Trustees

NameTitle
Aaron MercierTrustee
Revenue and Support

Revenue Composition

Contributions and Grants
$0
Program Service Revenue
$0
Investment Income
$33,759
Other Revenue
$109,190
Change in Net Assets
$-29,851
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Grants and Similar Amounts Paid$160,250
Other Expenses$12,550
Professional Fundraising Fees$0
Salaries, Compensation, and Employee Benefits$0
Total Fundraising Expense$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Grants to Domestic Individuals$160,250--$160,250
Other Expenses-$75-$75
Total Functional Expenses$160,250$12,550$0$172,800
Fundraising, Events, and Gaming
Fundraising activities
No
Gaming activities
No
Professional fundraiser used
No

Fundraising and Gaming Totals

Line ItemAmount
Professional Fundraising Fees$0
Political and Lobbying Activity
Political campaign activity
No
Lobbying activity
No
Subject to proxy tax
No
Debt and Bond Financing

Other Reported Liabilities

LiabilityAmount
Security Deposit Payable$2,000
Governance and Compliance

Governance Checklist

Compiled or reviewed by an accountant
Yes
Business relationship with family members
No
Business relationship with organization members
No
Material changes to governing documents
No
Compensation from other sources disclosed
No
CEO compensation reviewed
No
Other officer compensation reviewed
No
Conflict-of-interest policy
No
Audited financial statements prepared
No
Key decisions subject to board approval
No
Management duties delegated
No

Governance Explanations

Form 990, Page 6, Part VI, Line 11B

“No review was or will be conducted.”

Form 990, Page 6, Part VI, Line 19

“The governing documents of the trust are made available to anyone upon either verbal or written request.”

Filing and Contact Details

Filer

Filer Name
Esther Hutmacher Parriott
EIN
36-3450044
Phone
8155991408
Address
27 SSTATE AVE SUITE 101, FREEPORT, IL 61032

Signing Officer

Name
Aaron Mercier
Title
Trustee
Phone
8155991408
Signed
2017-11-01
Discuss with paid preparer
Yes

Organization Details

Principal Officer
Aaron Mercier
Legal Domicile
Il
Voting Board Members
1
Independent Board Members
1
Employees
0

Preparer

Firm
Beggin Tipp Lamm LLC
Address
524 W STEPHENSON ST STE 200, FREEPORT, IL 61032
Preparer
Richard Lamm
Phone
8152359610
Supplemental Narrative

Additional Explanations

FORM 990 - ORGANIZATION'S MISSION

“The esther hutmacher parriott scholarship farm trust's mission and most significant activity is to provide college scholarships for students in stephenson county, illinois who come from farm families and choose to further their education by selecting degrees in an agricultural - related field of study.”

Raw XML Appendix297 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
IRS990/AccountantCompileOrReviewInd0true
IRS990/AcctCompileOrReviewBasisGrp/SeparateBasisFinclStmtInd0X
IRS990/ActivitiesConductedPrtshpInd0false
IRS990/ActivityOrMissionDesc0THE ESTHER HUTMACHER PARRIOTT SCHOLARSHIP FARM TRUST'S MISSION AND MOST SIGNIFICANT ACTIVITY IS TO PROVIDE COLLEGE SCHOLARSHIPS FOR STUDENTS IN STEPHENSON COUNTY, ILLINOIS WHO COME FROM FARM FAMILIES AND CHOOSE TO FURTHER THEIR EDUCATION BY SELECTING DEGREES IN AN AGRICULTURAL - RELATED FIELD OF STUDY.
IRS990/BooksInCareOfDetail/PersonNm0DENISE BALBACH
IRS990/BooksInCareOfDetail/PhoneNum08155991408
IRS990/BooksInCareOfDetail/USAddress/AddressLine1Txt027 S STATE AVE SUITE 101
IRS990/BooksInCareOfDetail/USAddress/CityNm0FREEPORT
IRS990/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IL
IRS990/BooksInCareOfDetail/USAddress/ZIPCd061032
IRS990/BusinessRlnWithFamMemInd0false
IRS990/BusinessRlnWithOfficerEntInd0false
IRS990/BusinessRlnWithOrgMemInd0false
IRS990/CashNonInterestBearingGrp/BOYAmt0178275
IRS990/CashNonInterestBearingGrp/EOYAmt0114320
IRS990/ChangeToOrgDocumentsInd0false
IRS990/CollectionsOfArtInd0false
IRS990/CompensationFromOtherSrcsInd0false
IRS990/CompensationProcessCEOInd0false
IRS990/CompensationProcessOtherInd0false
IRS990/ConflictOfInterestPolicyInd0false
IRS990/ConservationEasementsInd0false
IRS990/ConsolidatedAuditFinclStmtInd0false
IRS990/CreditCounselingInd0false
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt00
IRS990/CYGrantsAndSimilarPaidAmt0160250
IRS990/CYInvestmentIncomeAmt033759
IRS990/CYOtherExpensesAmt012550
IRS990/CYOtherRevenueAmt0109190
IRS990/CYProgramServiceRevenueAmt00
IRS990/CYRevenuesLessExpensesAmt0-29851
IRS990/CYSalariesCompEmpBnftPaidAmt00
IRS990/CYTotalExpensesAmt0172800
IRS990/CYTotalFundraisingExpenseAmt00
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt0142949
IRS990/DecisionsSubjectToApprovaInd0false
IRS990/DeductibleArtContributionInd0false
IRS990/DeductibleNonCashContriInd0false
IRS990/DelegationOfMgmtDutiesInd0false
IRS990/Desc0THE EXEMPT PURPOSE IS TO PROVIDE QUALIFIED STUDENTS WITH COLLEGE SCHOLARSHIPS IF THEY MEET THE REQUIREMENTS SET FORTH BY THE TRUST. THE AMOUNT REPRESENTED HERE INDICATES THAT MULTIPLE STUDENTS HAVE MET THESE REQUIREMENTS AND HAVE RECEIVED COLLEGE SCHOLARSHIPS.
IRS990/DescribedInSection501c3Ind0true
IRS990/DisregardedEntityInd0false
IRS990/DocumentRetentionPolicyInd0false
IRS990/DonorAdvisedFundInd0false
IRS990/ElectionOfBoardMembersInd0false
IRS990/EmployeeCnt00
IRS990/EngagedInExcessBenefitTransInd0false
IRS990/ExpenseAmt0160250
IRS990/FamilyOrBusinessRlnInd0false
IRS990/ForeignActivitiesInd0false
IRS990/ForeignFinancialAccountInd0false
IRS990/ForeignOfficeInd0false
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt00.00
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd0X
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt00
IRS990/Form990PartVIISectionAGrp/PersonNm0AARON MERCIER
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt00
IRS990/Form990PartVIISectionAGrp/TitleTxt0TRUSTEE
IRS990/Form990ProvidedToGvrnBodyInd0false
IRS990/FormerOfcrEmployeesListedInd0false
IRS990/FSAuditedInd0false
IRS990/FundraisingActivitiesInd0false
IRS990/GainOrLossGrp/OtherAmt02091
IRS990/GainOrLossGrp/SecuritiesAmt06949
IRS990/GamingActivitiesInd0false
IRS990/GoverningBodyVotingMembersCnt01
IRS990/GrantAmt0160250
IRS990/GrantsToDomesticIndividualsGrp/ProgramServicesAmt0160250
IRS990/GrantsToDomesticIndividualsGrp/TotalAmt0160250
IRS990/GrantsToIndividualsInd0true
IRS990/GrantsToOrganizationsInd0false
IRS990/GrantToRelatedPersonInd0false
IRS990/GrossAmountSalesAssetsGrp/OtherAmt02091
IRS990/GrossAmountSalesAssetsGrp/SecuritiesAmt0185741
IRS990/GrossReceiptsAmt0364061
IRS990/GrossRentsGrp/RealAmt0150610
IRS990/GroupReturnForAffiliatesInd0false
IRS990/IncludeFIN48FootnoteInd0false
IRS990/IndependentAuditFinclStmtInd0false
IRS990/IndependentVotingMemberCnt01
IRS990/IndoorTanningServicesInd0false
IRS990/InfoInScheduleOPartIIIInd0X
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InvestmentIncomeGrp/RelatedOrExemptFuncIncomeAmt024719
IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt024719
IRS990/InvestmentInJointVentureInd0false
IRS990/InvestmentsPubTradedSecGrp/BOYAmt01066604
IRS990/InvestmentsPubTradedSecGrp/EOYAmt01105134
IRS990/IRPDocumentCnt00
IRS990/IRPDocumentW2GCnt00
IRS990/LandBldgEquipAccumDeprecAmt0231820
IRS990/LandBldgEquipBasisNetGrp/BOYAmt0640911
IRS990/LandBldgEquipBasisNetGrp/EOYAmt0636463
IRS990/LandBldgEquipCostOrOtherBssAmt0868283
IRS990/LegalDomicileStateCd0IL
IRS990/LessCostOthBasisSalesExpnssGrp/SecuritiesAmt0178792
IRS990/LessRentalExpensesGrp/RealAmt042320
IRS990/LoanOutstandingInd0false
IRS990/LobbyingActivitiesInd0false
IRS990/LocalChaptersInd0false
IRS990/MaterialDiversionOrMisuseInd0false
IRS990/MembersOrStockholdersInd0false
IRS990/MethodOfAccountingCashInd0X
IRS990/MinutesOfCommitteesInd0true
IRS990/MinutesOfGoverningBodyInd0true
IRS990/MissionDesc0THE ESTHER HUTMACHER PARRIOTT SCHOLARSHIP FARM TRUST'S MISSION AND MOST SIGNIFICANT ACTIVITY IS TO PROVIDE COLLEGE SCHOLARSHIPS FOR STUDENTS IN STEPHENSON COUNTY, ILLINOIS WHO COME FROM FARM FAMILIES AND CHOOSE TO FURTHER THEIR EDUCATION BY SELECTING DEGREES IN AN AGRICULTURAL - RELATED FIELD OF STUDY.
IRS990/MoreThan5000KToIndividualsInd0false
IRS990/MoreThan5000KToOrgInd0false
IRS990/NetAssetsOrFundBalancesBOYAmt01927531
IRS990/NetAssetsOrFundBalancesEOYAmt01897680
IRS990/NetGainOrLossInvestmentsGrp/RelatedOrExemptFuncIncomeAmt09040
IRS990/NetGainOrLossInvestmentsGrp/TotalRevenueColumnAmt09040
IRS990/NetRentalIncomeOrLossGrp/RelatedOrExemptFuncIncomeAmt0108290
IRS990/NetRentalIncomeOrLossGrp/TotalRevenueColumnAmt0108290
IRS990/NoListedPersonsCompensatedInd0X
IRS990/NondeductibleContributionsInd0false
IRS990/OfficerMailingAddressInd0false
IRS990/OperateHospitalInd0false
IRS990/Organization501c3Ind0X
IRS990/OrganizationFollowsSFAS117Ind0X
IRS990/OtherExpensesGrp/Desc0TRUST MANAGEMENT FEES
IRS990/OtherExpensesGrp/Desc1MISCELLANEOUS
IRS990/OtherExpensesGrp/Desc2OFFICE EXPENSE
IRS990/OtherExpensesGrp/Desc3DUES
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt011569
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt1641
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt2265
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt375
IRS990/OtherExpensesGrp/TotalAmt011569
IRS990/OtherExpensesGrp/TotalAmt1641
IRS990/OtherExpensesGrp/TotalAmt2265
IRS990/OtherExpensesGrp/TotalAmt375
IRS990/OtherLiabilitiesGrp/BOYAmt02000
IRS990/OtherLiabilitiesGrp/EOYAmt02000
IRS990/OtherRevenueMiscGrp/Desc0HUNTING RIGHTS
IRS990/OtherRevenueMiscGrp/RelatedOrExemptFuncIncomeAmt0900
IRS990/OtherRevenueMiscGrp/TotalRevenueColumnAmt0900
IRS990/OtherRevenueTotalAmt0900
IRS990/PartialLiquidationInd0false
IRS990/PermanentlyRstrNetAssetsGrp/BOYAmt01747227
IRS990/PermanentlyRstrNetAssetsGrp/EOYAmt01764938
IRS990/PoliticalCampaignActyInd0false
IRS990/PrincipalOfficerNm0AARON MERCIER
IRS990/ProfessionalFundraisingInd0false
IRS990/ProhibitedTaxShelterTransInd0false
IRS990/PYExcessBenefitTransInd0false
IRS990/PYGrantsAndSimilarPaidAmt0127500
IRS990/PYInvestmentIncomeAmt031444
IRS990/PYOtherExpensesAmt011843
IRS990/PYOtherRevenueAmt0135453
IRS990/PYRevenuesLessExpensesAmt027554
IRS990/PYTotalExpensesAmt0139343
IRS990/PYTotalRevenueAmt0166897
IRS990/ReconcilationRevenueExpnssAmt0-29851
IRS990/RelatedEntityInd0false
IRS990/RelatedOrganizationCtrlEntInd0false
IRS990/RentalIncomeOrLossGrp/RealAmt0108290
IRS990/ReportInvestmentsOtherSecInd0false
IRS990/ReportLandBuildingEquipmentInd0true
IRS990/ReportOtherAssetsInd0false
IRS990/ReportOtherLiabilitiesInd0true
IRS990/ReportProgramRelatedInvstInd0false
IRS990/SavingsAndTempCashInvstGrp/BOYAmt043741
IRS990/SavingsAndTempCashInvstGrp/EOYAmt043763
IRS990ScheduleA/Form990SchASupportingOrgGrp/Contribution35ControlledInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ContributionControllerInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ContributionFamilyInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ControlledDisqualifiedPrsnInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/DisqualifiedPrsnControllIntInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/DisqualifiedPrsnOwnrIntInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ExcessBusinessHoldingsRulesInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ListedByNameGoverningDocInd0true
IRS990ScheduleA/Form990SchASupportingOrgGrp/LoanDisqualifiedPersonInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/OrganizationChangeSuprtOrgInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/PaymentSubstantialContribtrInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SupportedOrgNotOrganizedUSInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SupportedOrgSectionC456Ind0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SupportNonSupportedOrgInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SuprtOrgNoIRSDeterminationInd0false
IRS990ScheduleA/MajorityDirTrstSupportedOrgInd0true
IRS990ScheduleA/OtherSupportSumAmt00
IRS990ScheduleA/SupportedOrganizationsCnt01
IRS990ScheduleA/SupportedOrganizationsTotalCnt01
IRS990ScheduleA/SupportedOrgInformationGrp/EIN0362827613
IRS990ScheduleA/SupportedOrgInformationGrp/GoverningDocumentListedInd0true
IRS990ScheduleA/SupportedOrgInformationGrp/OrganizationTypeCd02
IRS990ScheduleA/SupportedOrgInformationGrp/OtherSupportAmt00
IRS990ScheduleA/SupportedOrgInformationGrp/SupportAmt00
IRS990ScheduleA/SupportedOrgInformationGrp/SupportedOrganizationName/BusinessNameLine1Txt0REGIONAL OFFICE OF EDUCATION 8
IRS990ScheduleA/SupportingOrganization509a3Ind0X
IRS990ScheduleA/SupportingOrgType2Ind0X
IRS990/ScheduleBRequiredInd0false
IRS990ScheduleD/BuildingsGrp/BookValueAmt024746
IRS990ScheduleD/BuildingsGrp/DepreciationAmt0128481
IRS990ScheduleD/BuildingsGrp/OtherCostOrOtherBasisAmt0153227
IRS990ScheduleD/LandGrp/BookValueAmt0600017
IRS990ScheduleD/LandGrp/OtherCostOrOtherBasisAmt0600017
IRS990ScheduleD/OtherLandBuildingsGrp/BookValueAmt011700
IRS990ScheduleD/OtherLandBuildingsGrp/DepreciationAmt0103339
IRS990ScheduleD/OtherLandBuildingsGrp/OtherCostOrOtherBasisAmt0115039
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt02000
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc0SECURITY DEPOSIT PAYABLE
IRS990ScheduleD/TotalBookValueLandBuildingsAmt0636463
IRS990ScheduleD/TotalLiabilityAmt02000
IRS990ScheduleI/GrantRecordsMaintainedInd0false
IRS990ScheduleI/GrantsOtherAsstToIndivInUSGrp/CashGrantAmt0160250
IRS990ScheduleI/GrantsOtherAsstToIndivInUSGrp/GrantTypeTxt0COLLEGE SCHOLARSHIPS
IRS990ScheduleI/GrantsOtherAsstToIndivInUSGrp/RecipientCnt074
IRS990ScheduleI/SupplementalInformationDetail/ExplanationTxt0THE TRUST HAS AN ESTABLISHED COMMITTEE THAT MEETS ONCE ANNUALLY TO REVIEW ALL OF THE REQUIREMENTS SET FORTH BY THE TRUST, TO ENABLE INDIVIDUALS THAT QUALIFY TO RECEIVE COLLEGE SCHOLARSHIPS. APPLICATIONS FOR THE SCHOLARSHIPS ARE READ AND REVIEWED BY COMMITTEE MEMBERS AND SELECTIONS ARE MADE FOR CERTAIN QUALIFYING RECIPIENTS. EARLY IN THE FALL, EACH QUALIFYING STUDENT MUST PROVIDE THE COMMITTEE WITH AN APPROVED CLASS SCHEDULE FROM THE COLLEGE TO PROVE ENROLLMENT. AT THE END OF THE SEMESTER, EACH STUDENT MUST ADDITIONALLY SUPPLY THE COMMITTEE WITH A TRANSCRIPT OF HIS/HER FINAL GRADES TO PROVE WHETHER OR NOT THEY QUALIFY FOR SECOND SEMESTER SCHOLARSHIP AWARDS. ALL SCHOLARSHIPS ARE PAID DIRECTLY TO THE COLLEGE WHERE THE RECIPIENT IS ATTENDING; THE STUDENT NEVER DIRECTLY RECEIVES ANY OF THE AWARD.
IRS990ScheduleI/SupplementalInformationDetail/FormAndLineReferenceDesc0SCHEDULE I, PAGE 1, PART I, LINE 2
IRS990/ScheduleJRequiredInd0false
IRS990/ScheduleORequiredInd0true
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0THE ESTHER HUTMACHER PARRIOTT SCHOLARSHIP FARM TRUST'S MISSION AND MOST SIGNIFICANT ACTIVITY IS TO PROVIDE COLLEGE SCHOLARSHIPS FOR STUDENTS IN STEPHENSON COUNTY, ILLINOIS WHO COME FROM FARM FAMILIES AND CHOOSE TO FURTHER THEIR EDUCATION BY SELECTING DEGREES IN AN AGRICULTURAL - RELATED FIELD OF STUDY.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1NO REVIEW WAS OR WILL BE CONDUCTED.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2THE GOVERNING DOCUMENTS OF THE TRUST ARE MADE AVAILABLE TO ANYONE UPON EITHER VERBAL OR WRITTEN REQUEST.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990 - ORGANIZATION'S MISSION
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990, PAGE 6, PART VI, LINE 11B
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990, PAGE 6, PART VI, LINE 19
IRS990/SchoolOperatingInd0false
IRS990/SignificantChangeInd0false
IRS990/SignificantNewProgramSrvcInd0false
IRS990/StatesWhereCopyOfReturnIsFldCd0IL
IRS990/SubjectToProxyTaxInd0false
IRS990/TaxablePartyNotificationInd0false
IRS990/TaxExemptBondsInd0false
IRS990/TempOrPermanentEndowmentsInd0false
IRS990/TerminateOperationsInd0false
IRS990/TotalAssetsBOYAmt01929531
IRS990/TotalAssetsEOYAmt01899680
IRS990/TotalAssetsGrp/BOYAmt01929531
IRS990/TotalAssetsGrp/EOYAmt01899680
IRS990/TotalCompGreaterThan150KInd0false
IRS990/TotalEmployeeCnt00
IRS990/TotalFunctionalExpensesGrp/FundraisingAmt00
IRS990/TotalFunctionalExpensesGrp/ManagementAndGeneralAmt012550
IRS990/TotalFunctionalExpensesGrp/ProgramServicesAmt0160250
IRS990/TotalFunctionalExpensesGrp/TotalAmt0172800
IRS990/TotalGrossUBIAmt00
IRS990/TotalLiabilitiesBOYAmt02000
IRS990/TotalLiabilitiesEOYAmt02000
IRS990/TotalLiabilitiesGrp/BOYAmt02000
IRS990/TotalLiabilitiesGrp/EOYAmt02000
IRS990/TotalNetAssetsFundBalanceGrp/BOYAmt01927531
IRS990/TotalNetAssetsFundBalanceGrp/EOYAmt01897680
IRS990/TotalProgramServiceExpensesAmt0160250
IRS990/TotalRevenueGrp/RelatedOrExemptFuncIncomeAmt0142949
IRS990/TotalRevenueGrp/TotalRevenueColumnAmt0142949
IRS990/TotLiabNetAssetsFundBalanceGrp/BOYAmt01929531
IRS990/TotLiabNetAssetsFundBalanceGrp/EOYAmt01899680
IRS990/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990/TypeOfOrganizationTrustInd0X
IRS990/UnrelatedBusIncmOverLimitInd0false
IRS990/UnrestrictedNetAssetsGrp/BOYAmt0180304
IRS990/UnrestrictedNetAssetsGrp/EOYAmt0132742
IRS990/UponRequestInd0X
IRS990/USAddress/AddressLine1Txt027 S STATE AVE
IRS990/USAddress/AddressLine2Txt0SUITE 101
IRS990/USAddress/CityNm0FREEPORT
IRS990/USAddress/StateAbbreviationCd0IL
IRS990/USAddress/ZIPCd061032
IRS990/VotingMembersGoverningBodyCnt01
IRS990/VotingMembersIndependentCnt01
IRS990/WebsiteAddressTxt0HTTP://WWW.ROE8.COM/SCHOLARSHIPS.HTM
IRS990/WhistleblowerPolicyInd0false
ReturnHeader/BuildTS02017-02-10 21:41:12Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0AARON MERCIER
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum08155991408
ReturnHeader/BusinessOfficerGrp/SignatureDt02017-11-01
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0ESTHER HUTMACHER PARRIOTT
ReturnHeader/Filer/BusinessNameControlTxt0ESTH
ReturnHeader/Filer/EIN0363450044
ReturnHeader/Filer/PhoneNum08155991408
ReturnHeader/Filer/USAddress/AddressLine1Txt027 SSTATE AVE SUITE 101
ReturnHeader/Filer/USAddress/CityNm0FREEPORT
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IL
ReturnHeader/Filer/USAddress/ZIPCd061032
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId09BB5C3B212E3F3E89449FE741B3EF41EA9F16E80
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0F943EBE9321C1663AD883F8E47E487E16213D2F4
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0273238017
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0BEGGIN TIPP LAMM LLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0524 W STEPHENSON ST STE 200
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0FREEPORT
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd061032
ReturnHeader/PreparerPersonGrp/PhoneNum08152359610
ReturnHeader/PreparerPersonGrp/PreparationDt02017-11-09
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0RICHARD LAMM
ReturnHeader/ReturnTs02017-11-14T10:11:34-06:00
ReturnHeader/ReturnTypeCd0990
ReturnHeader/TaxPeriodBeginDt02016-07-01
ReturnHeader/TaxPeriodEndDt02017-06-30
ReturnHeader/TaxYr02016

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$1,899,680
Liabilities
$2,000
Net assets
$1,897,680
Revenue
$142,949
Expenses
$172,800
Net income
-$29,851
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2025XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.09$0.00$2.09$0.25$0.11$0.14
2024XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.95$0.00$1.95$0.18$0.11$0.07
2023XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.88$0.00$1.88$0.18$0.13$0.06
2022Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.82$0.00$1.82$0.15$0.15$0.00
2021Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.83$0.00$1.82$0.16$0.13$0.03
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.80$0.00$1.80$0.14$0.17$0.03
2019XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.82$0.00$1.82$0.16$0.17$0.01
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.83$0.00$1.83$0.11$0.17$0.07
2017Detailed filing. Detailed filing data is available for this year.$1.90$0.00$1.90$0.14$0.17$0.03
2016Detailed filing. Detailed filing data is available for this year.$1.93$0.00$1.93$0.17$0.14$0.03
2015Detailed filing. Detailed filing data is available for this year.$1.90$0.00$1.90$0.14$0.13$0.01
2014Detailed filing. Detailed filing data is available for this year.$1.89$0.00$1.89$0.17$0.09$0.08
2012XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.74$0.00$1.74$0.09
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.70$0.00$1.70$0.09