Civic Intelligence

Esther Hutmacher Parriott Scholarship Farm Trust

990 • Fiscal year 2018 • EIN 36-3450044

Jul 01, 2017 to Jun 30, 2018 • Filed on Oct 03, 2018

Organization ProfileWWW.ROE8.COM/SCHOLARSHIPS.HTM
27 S State 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.

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

Liabilities / Revenue

26th percentile

0.02x

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

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

Net Margin

5th percentile

-63%

Higher net margin than 5% of similar nonprofits.

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

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.

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

Asset Growth

29th percentile

-3.5%

Faster asset growth than 29% of similar nonprofits.

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

Revenue Growth

11th percentile

-26%

Faster revenue growth than 11% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets17th percentile

Assets

Down

$1,833,140

Down $66,540 (-3.5%) from 2017

Net Assets

Down

$1,831,140

Down $66,540 (-3.5%) from 2017

Liabilities

Flat

$2,000

Flat from 2017

Revenue And Expenses
Liabilities / Revenue26th percentileNet Margin5th percentile

Revenue

Down

$106,345

Down $36,604 (-26%) from 2017

Expenses

Up

$172,885

Up $85 (+0.0%) from 2017

Net Income

Down

-$66,540

Down $36,689 (-123%) from 2017

Historical Trend

Balance Sheet Trend

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

2018

Assets$1,833,140
Liabilities$2,000
Net Assets$1,831,140
Open 2018 Filing

Operations Trend

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

2018

Revenue$106,345
Expenses$172,885
Net Income-$66,540
Open 2018 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2017 to Jun 30, 2018
Signed
Oct 3, 2018
Return Version
2017v2.3
Gross Receipts
$674,492
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,105,134$1,119,391▲ $14,257
Land, Buildings, and Equipment, Net$636,463$632,371▼ $4,092
Savings and Temporary Cash Investments$43,763$43,760▼ $3
Cash and Non-Interest-Bearing Accounts$114,320$37,618▼ $76,702
Total Assets$1,899,680$1,833,140▼ $66,540
Liabilities
Other Liabilities$2,000$2,000→ $0
Total Liabilities$2,000$2,000→ $0
Net Assets / Fund Balance
Permanently Rstr Net Assets$1,764,938$1,782,998▲ $18,060
Unrestricted Net Assets$132,742$48,142▼ $84,600
Total Net Assets Fund Balance$1,897,680$1,831,140▼ $66,540
Total Liabilities and Net Assets / Fund Balance$1,899,680$1,833,140▼ $66,540

Asset Categories

AssetBook ValueDepreciationBasis
Land$600,017-$600,017
Buildings$21,867$131,360$153,227
Other Land Buildings$10,487$104,552$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
$34,110
Other Revenue
$72,235
Change in Net Assets
$-66,540
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Grants and Similar Amounts Paid$157,250
Other Expenses$15,635
Professional Fundraising Fees$0
Salaries, Compensation, and Employee Benefits$0
Total Fundraising Expense$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Grants to Domestic Individuals$157,250--$157,250
Other Expenses-$578-$578
Total Functional Expenses$157,250$15,635$0$172,885
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 S STATE AVE SUITE 101, FREEPORT, IL 61032

Signing Officer

Name
Aaron Mercier
Title
Trustee
Phone
8155991408
Signed
2018-10-03
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
Lucas a Beggin
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 Appendix299 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/BOYAmt0114320
IRS990/CashNonInterestBearingGrp/EOYAmt037618
IRS990/ChangeToOrgDocumentsInd0false
IRS990/CollectionsOfArtInd0false
IRS990/CompensationFromOtherSrcsInd0false
IRS990/CompensationProcessCEOInd0false
IRS990/CompensationProcessOtherInd0false
IRS990/ConflictOfInterestPolicyInd0false
IRS990/ConservationEasementsInd0false
IRS990/ConsolidatedAuditFinclStmtInd0false
IRS990/CreditCounselingInd0false
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt00
IRS990/CYGrantsAndSimilarPaidAmt0157250
IRS990/CYInvestmentIncomeAmt034110
IRS990/CYOtherExpensesAmt015635
IRS990/CYOtherRevenueAmt072235
IRS990/CYProgramServiceRevenueAmt00
IRS990/CYRevenuesLessExpensesAmt0-66540
IRS990/CYSalariesCompEmpBnftPaidAmt00
IRS990/CYTotalExpensesAmt0172885
IRS990/CYTotalFundraisingExpenseAmt00
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt0106345
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/ExpenseAmt0157250
IRS990/FamilyOrBusinessRlnInd0false
IRS990/FederalGrantAuditRequiredInd0false
IRS990/ForeignActivitiesInd0false
IRS990/ForeignFinancialAccountInd0false
IRS990/ForeignOfficeInd0false
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/OtherAmt05722
IRS990/GainOrLossGrp/SecuritiesAmt0280
IRS990/GamingActivitiesInd0false
IRS990/GoverningBodyVotingMembersCnt01
IRS990/GrantAmt0157250
IRS990/GrantsToDomesticIndividualsGrp/ProgramServicesAmt0157250
IRS990/GrantsToDomesticIndividualsGrp/TotalAmt0157250
IRS990/GrantsToIndividualsInd0true
IRS990/GrantsToOrganizationsInd0false
IRS990/GrantToRelatedPersonInd0false
IRS990/GrossAmountSalesAssetsGrp/OtherAmt05722
IRS990/GrossAmountSalesAssetsGrp/SecuritiesAmt0521085
IRS990/GrossReceiptsAmt0674492
IRS990/GrossRentsGrp/RealAmt0118677
IRS990/GroupReturnForAffiliatesInd0false
IRS990/IncludeFIN48FootnoteInd0false
IRS990/IndependentAuditFinclStmtInd0false
IRS990/IndependentVotingMemberCnt01
IRS990/IndoorTanningServicesInd0false
IRS990/InfoInScheduleOPartIIIInd0X
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InvestmentIncomeGrp/RelatedOrExemptFuncIncomeAmt028108
IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt028108
IRS990/InvestmentInJointVentureInd0false
IRS990/InvestmentsPubTradedSecGrp/BOYAmt01105134
IRS990/InvestmentsPubTradedSecGrp/EOYAmt01119391
IRS990/IRPDocumentCnt01
IRS990/IRPDocumentW2GCnt00
IRS990/LandBldgEquipAccumDeprecAmt0235912
IRS990/LandBldgEquipBasisNetGrp/BOYAmt0636463
IRS990/LandBldgEquipBasisNetGrp/EOYAmt0632371
IRS990/LandBldgEquipCostOrOtherBssAmt0868283
IRS990/LegalDomicileStateCd0IL
IRS990/LessCostOthBasisSalesExpnssGrp/SecuritiesAmt0520805
IRS990/LessRentalExpensesGrp/RealAmt047342
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/NetAssetsOrFundBalancesBOYAmt01897680
IRS990/NetAssetsOrFundBalancesEOYAmt01831140
IRS990/NetGainOrLossInvestmentsGrp/RelatedOrExemptFuncIncomeAmt06002
IRS990/NetGainOrLossInvestmentsGrp/TotalRevenueColumnAmt06002
IRS990/NetRentalIncomeOrLossGrp/RelatedOrExemptFuncIncomeAmt071335
IRS990/NetRentalIncomeOrLossGrp/TotalRevenueColumnAmt071335
IRS990/NoListedPersonsCompensatedInd0X
IRS990/NondeductibleContributionsInd0false
IRS990/OfficerMailingAddressInd0false
IRS990/OperateHospitalInd0false
IRS990/Organization501c3Ind0X
IRS990/OrganizationFollowsSFAS117Ind0X
IRS990/OtherExpensesGrp/Desc0TRUST MANAGEMENT FEES
IRS990/OtherExpensesGrp/Desc1DUES
IRS990/OtherExpensesGrp/Desc2MISCELLANEOUS
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt011933
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt13124
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt2578
IRS990/OtherExpensesGrp/TotalAmt011933
IRS990/OtherExpensesGrp/TotalAmt13124
IRS990/OtherExpensesGrp/TotalAmt2578
IRS990/OtherLiabilitiesGrp/BOYAmt02000
IRS990/OtherLiabilitiesGrp/EOYAmt02000
IRS990/OtherRevenueMiscGrp/Desc0HUNTING RIGHTS
IRS990/OtherRevenueMiscGrp/RelatedOrExemptFuncIncomeAmt0900
IRS990/OtherRevenueMiscGrp/TotalRevenueColumnAmt0900
IRS990/OtherRevenueTotalAmt0900
IRS990/PartialLiquidationInd0false
IRS990/PermanentlyRstrNetAssetsGrp/BOYAmt01764938
IRS990/PermanentlyRstrNetAssetsGrp/EOYAmt01782998
IRS990/PoliticalCampaignActyInd0false
IRS990/PrincipalOfficerNm0AARON MERCIER
IRS990/ProfessionalFundraisingInd0false
IRS990/ProhibitedTaxShelterTransInd0false
IRS990/PYExcessBenefitTransInd0false
IRS990/PYGrantsAndSimilarPaidAmt0160250
IRS990/PYInvestmentIncomeAmt033759
IRS990/PYOtherExpensesAmt012550
IRS990/PYOtherRevenueAmt0109190
IRS990/PYRevenuesLessExpensesAmt0-29851
IRS990/PYTotalExpensesAmt0172800
IRS990/PYTotalRevenueAmt0142949
IRS990/ReconcilationRevenueExpnssAmt0-66540
IRS990/RelatedEntityInd0false
IRS990/RelatedOrganizationCtrlEntInd0false
IRS990/RentalIncomeOrLossGrp/RealAmt071335
IRS990/ReportInvestmentsOtherSecInd0false
IRS990/ReportLandBuildingEquipmentInd0true
IRS990/ReportOtherAssetsInd0false
IRS990/ReportOtherLiabilitiesInd0true
IRS990/ReportProgramRelatedInvstInd0false
IRS990/SavingsAndTempCashInvstGrp/BOYAmt043763
IRS990/SavingsAndTempCashInvstGrp/EOYAmt043760
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/BookValueAmt021867
IRS990ScheduleD/BuildingsGrp/DepreciationAmt0131360
IRS990ScheduleD/BuildingsGrp/OtherCostOrOtherBasisAmt0153227
IRS990ScheduleD/LandGrp/BookValueAmt0600017
IRS990ScheduleD/LandGrp/OtherCostOrOtherBasisAmt0600017
IRS990ScheduleD/OtherLandBuildingsGrp/BookValueAmt010487
IRS990ScheduleD/OtherLandBuildingsGrp/DepreciationAmt0104552
IRS990ScheduleD/OtherLandBuildingsGrp/OtherCostOrOtherBasisAmt0115039
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt02000
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc0SECURITY DEPOSIT PAYABLE
IRS990ScheduleD/TotalBookValueLandBuildingsAmt0632371
IRS990ScheduleD/TotalLiabilityAmt02000
IRS990ScheduleI/GrantRecordsMaintainedInd0false
IRS990ScheduleI/GrantsOtherAsstToIndivInUSGrp/CashGrantAmt0157250
IRS990ScheduleI/GrantsOtherAsstToIndivInUSGrp/GrantTypeTxt0COLLEGE SCHOLARSHIPS
IRS990ScheduleI/GrantsOtherAsstToIndivInUSGrp/RecipientCnt077
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/TotalAssetsBOYAmt01899680
IRS990/TotalAssetsEOYAmt01833140
IRS990/TotalAssetsGrp/BOYAmt01899680
IRS990/TotalAssetsGrp/EOYAmt01833140
IRS990/TotalCompGreaterThan150KInd0false
IRS990/TotalEmployeeCnt00
IRS990/TotalFunctionalExpensesGrp/FundraisingAmt00
IRS990/TotalFunctionalExpensesGrp/ManagementAndGeneralAmt015635
IRS990/TotalFunctionalExpensesGrp/ProgramServicesAmt0157250
IRS990/TotalFunctionalExpensesGrp/TotalAmt0172885
IRS990/TotalGrossUBIAmt00
IRS990/TotalLiabilitiesBOYAmt02000
IRS990/TotalLiabilitiesEOYAmt02000
IRS990/TotalLiabilitiesGrp/BOYAmt02000
IRS990/TotalLiabilitiesGrp/EOYAmt02000
IRS990/TotalNetAssetsFundBalanceGrp/BOYAmt01897680
IRS990/TotalNetAssetsFundBalanceGrp/EOYAmt01831140
IRS990/TotalProgramServiceExpensesAmt0157250
IRS990/TotalRevenueGrp/RelatedOrExemptFuncIncomeAmt0106345
IRS990/TotalRevenueGrp/TotalRevenueColumnAmt0106345
IRS990/TotLiabNetAssetsFundBalanceGrp/BOYAmt01899680
IRS990/TotLiabNetAssetsFundBalanceGrp/EOYAmt01833140
IRS990/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990/TypeOfOrganizationTrustInd0X
IRS990/UnrelatedBusIncmOverLimitInd0false
IRS990/UnrestrictedNetAssetsGrp/BOYAmt0132742
IRS990/UnrestrictedNetAssetsGrp/EOYAmt048142
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/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0AARON MERCIER
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum08155991408
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-10-03
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0ESTHER HUTMACHER PARRIOTT
ReturnHeader/Filer/BusinessNameControlTxt0ESTH
ReturnHeader/Filer/EIN0363450044
ReturnHeader/Filer/PhoneNum08155991408
ReturnHeader/Filer/USAddress/AddressLine1Txt027 S STATE AVE SUITE 101
ReturnHeader/Filer/USAddress/CityNm0FREEPORT
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IL
ReturnHeader/Filer/USAddress/ZIPCd061032
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0242B36AEC4A03B0D4F0801D3731D2401FA9B5D7B
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0E5800506F0345399F33B4CA2C1A414A045ED87D6
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt098.142.196.58
ReturnHeader/FilingSecurityInformation/IPDt02018-11-01
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CD
ReturnHeader/FilingSecurityInformation/IPTm011:26:35
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/PreparationDt02018-10-17
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0LUCAS A BEGGIN
ReturnHeader/ReturnTs02018-11-01T11:26:35-05:00
ReturnHeader/ReturnTypeCd0990
ReturnHeader/TaxPeriodBeginDt02017-07-01
ReturnHeader/TaxPeriodEndDt02018-06-30
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$1,833,140
Liabilities
$2,000
Net assets
$1,831,140
Revenue
$106,345
Expenses
$172,885
Net income
-$66,540
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
2018Detailed filing. Detailed filing data is available for this year.$1.83$0.00$1.83$0.11$0.17$0.07
2017Facts available. Structured filing facts are available, but richer extracted sections are limited.$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