Civic Intelligence

Rachel L Hensal Scholarship Trust

EIN 31-1634642 • 501(c)3 • Panora, IA

Profile

Award scholarships to panorama students

222 E Market PO Box 127Panora, IA 50215

n/A

Siviq Scores

Precomputed percentiles relative to similar nonprofits. These scores are descriptive rather than judgmental.

Liabilities / Assets

Score unavailable

No value available

Liabilities-to-assets requires both liabilities and assets on the latest valid filing.

Source year 2024

Liabilities / Revenue

Score unavailable

No value available

Liabilities-to-revenue requires both liabilities and revenue on the latest valid filing.

Source year 2024

Net Margin

41st percentile

-1.5%

Higher net margin than 41% of similar nonprofits.

501(c)3 • <$500k nonprofits • Source year 2024

Top Officer Pay

81st percentile

$0

Higher top officer pay than 81% of similar nonprofits.

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

501(c)3 • <$500k nonprofits • Source year 2024

Asset Growth

64th percentile

6.4%

Faster asset growth than 64% of similar nonprofits.

501(c)3 • <$500k nonprofits • Annualized from 2023 to 2024

Revenue Growth

73rd percentile

22%

Faster revenue growth than 73% of similar nonprofits.

501(c)3 • <$500k nonprofits • Annualized from 2023 to 2024

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Up

$356,366

Up $12,118 (+3.5%) from 2022

Liabilities

-

No earlier filing loaded for comparison.

Net Assets

Up

$356,366

Up $12,118 (+3.5%) from 2022

Operations
Liabilities / RevenueScore unavailableNet Margin41st percentile

Revenue

Up

$34,300

Up $9,966 (+41%) from 2022

Expenses

Up

$34,811

Up $6,461 (+23%) from 2022

Net Income

Up

-$511

Up $3,505 (+87%) from 2022

Trend Graphs

Balance Sheet Trend

Asset Growth64th percentile

Grouped bars show assets, liabilities, and net assets across loaded filings.

$400K$300K$200K$100K$0Assets 2020: $355,467Net Assets 2020: $355,4672020Assets 2021: $368,118Net Assets 2021: $368,1182021Assets 2022: $344,248Net Assets 2022: $344,2482022Assets 2024: $356,366Net Assets 2024: $356,3662024

Highlighted filing

2024

Assets$356,366
Liabilities-
Net Assets$356,366
Open 2024 Filing

Operations Trend

Revenue Growth73rd percentile

Revenue, expenses, and net income by year, with the latest filing highlighted.

$40K$30K$20K$10K$0-$10KRevenue 2020: $24,549Expenses 2020: $18,458Net Income 2020: $6,0912020Revenue 2021: $26,878Expenses 2021: $24,082Net Income 2021: $2,7962021Revenue 2022: $24,334Expenses 2022: $28,350Net Income 2022: -$4,0162022Revenue 2024: $34,300Expenses 2024: $34,811Net Income 2024: -$5112024

Highlighted filing

2024

Revenue$34,300
Expenses$34,811
Net Income-$511
Open 2024 Filing

Filings

Most recent year

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

Open filing
Assets
$356,366
Liabilities
-
Net assets
$356,366
Revenue
$34,300
Expenses
$34,811
Net income
-$511
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$3.56$3.56$0.34$0.35$0.01
2022XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$3.44$3.44$0.24$0.28$0.04
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$3.68$3.68$0.27$0.24$0.03
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$3.55$3.55$0.25$0.18$0.06
Latest Filing Detail
Jump To
Filing Snapshot
Filing Period
Jan 1, 2024 to Dec 31, 2024
Signed
May 14, 2025
Return Version
2024v5.1
Gross Receipts
$34,300
Mission and Program Overview

Mission

Award scholarships to panorama students

Program Services

DescriptionGrantsExpenses
16 SCHOLARSHIPS AWARDED TO PAST PANORAMA SCHOOL GRADUATES IN 2024.$29,950-
Compensation and Service Providers
Top Officer Pay81st percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
KASEY HUEBNERTrustee-$0--
THAD STANLEYTrustee-$0--
MARIBEE BURNHAMTrustee-$0--
DEB WESTERGAARDTrustee-$0--
WILLIAM E BUMPTrustee-$0--
Filing and Contact Details

Filer

Filer Name
Rachel L Hensal Scholarship Trust
EIN
31-1634642
Phone
6417552131
Address
222 E MARKET PO BOX 127, PANORA, IA 50215

Signing Officer

Name
William E Bump
Title
Trustee
Signed
2025-05-14
Discuss with paid preparer
Yes

Preparer

Firm
Calvert Langgaard & Co PLLC
Address
306 State Street, Guthrie Center, IA 50115
Preparer
Sarah Langgaard
Phone
6413322115
Supplemental Narrative

Additional Explanations

Other Expenses.1

“PROPERTY TAXES $2888”

Other Expenses.2

“SURITY BOND $460”

Other Expenses.3

“INSURANCE $102”

Other Expenses.4

“BANK CHARGES $10”

Raw XML Appendix151 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
IRS990EZ/ActivitiesNotPreviouslyRptInd0false
IRS990EZ/BooksInCareOfDetail/PersonNm0WILLIAM BUMP
IRS990EZ/BooksInCareOfDetail/PhoneNum06417552131
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0222 E MARKET PO BOX 127
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0PANORA
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IA
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd050216
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt0158003
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0179366
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/CostOrOtherBasisExpenseSaleAmt00
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-511
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt01401
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0335003
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0356366
IRS990EZ/FundraisingGrossIncomeAmt00
IRS990EZ/GrantsAndSimilarAmountsPaidAmt029950
IRS990EZ/GrossReceiptsAmt034300
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt034300
IRS990EZ/LandAndBuildingsGrp/BOYAmt0177000
IRS990EZ/LandAndBuildingsGrp/EOYAmt0177000
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0335003
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0356366
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0335003
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0356366
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0KASEY HUEBNER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1THAD STANLEY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2MARIBEE BURNHAM
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3DEB WESTERGAARD
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4WILLIAM E BUMP
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0Trustee
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1Trustee
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2Trustee
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3Trustee
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4Trustee
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherChangesInNetAssetsAmt021874
IRS990EZ/OtherExpensesTotalAmt03460
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0AWARD SCHOLARSHIPS TO PANORAMA STUDENTS
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt016 SCHOLARSHIPS AWARDED TO PAST PANORAMA SCHOOL GRADUATES IN 2024.
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt029950
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt00
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TaxImposedOnOrganizationMgrAmt00
IRS990EZ/TaxImposedUnderIRC4911Amt00
IRS990EZ/TaxImposedUnderIRC4912Amt00
IRS990EZ/TaxImposedUnderIRC4955Amt00
IRS990EZ/TaxReimbursedByOrganizationAmt00
IRS990EZ/TotalExpensesAmt034811
IRS990EZ/TotalRevenueAmt034300
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationTrustInd0X
IRS990EZ/WebsiteAddressTxt0N/A
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/Form990SchAType1SuprtOrgGrp/OperateBenefitNonSuprtOrgInd0false
IRS990ScheduleA/Form990SchAType1SuprtOrgGrp/PowerAppointMajorityDirTrstInd0true
IRS990ScheduleA/IRSWrittenDeterminationInd0X
IRS990ScheduleA/OtherSupportSumAmt00
IRS990ScheduleA/SupportedOrganizationsCnt01
IRS990ScheduleA/SupportedOrganizationsTotalCnt01
IRS990ScheduleA/SupportedOrgInformationGrp/EIN0420865843
IRS990ScheduleA/SupportedOrgInformationGrp/GoverningDocumentListedInd0false
IRS990ScheduleA/SupportedOrgInformationGrp/OrganizationTypeCd02
IRS990ScheduleA/SupportedOrgInformationGrp/OtherSupportAmt00
IRS990ScheduleA/SupportedOrgInformationGrp/SupportAmt00
IRS990ScheduleA/SupportedOrgInformationGrp/SupportedOrganizationName/BusinessNameLine1Txt0PANORAMA SCHOOL
IRS990ScheduleA/SupportingOrganization509a3Ind0X
IRS990ScheduleA/SupportingOrgType1Ind0X
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0PROPERTY TAXES $2888
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1SURITY BOND $460
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2INSURANCE $102
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3BANK CHARGES $10
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Other Expenses.1
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Other Expenses.2
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Other Expenses.3
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3Other Expenses.4
ReturnHeader/BuildTS02025-03-06 01:10:19Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0WILLIAM E BUMP
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Trustee
ReturnHeader/BusinessOfficerGrp/SignatureDt02025-05-14
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0RACHEL L HENSAL SCHOLARSHIP TRUST
ReturnHeader/Filer/BusinessNameControlTxt0RACH
ReturnHeader/Filer/EIN0311634642
ReturnHeader/Filer/PhoneNum06417552131
ReturnHeader/Filer/USAddress/AddressLine1Txt0222 E MARKET PO BOX 127
ReturnHeader/Filer/USAddress/CityNm0PANORA
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IA
ReturnHeader/Filer/USAddress/ZIPCd050215
ReturnHeader/IRSResponsiblePrtyInfoCurrInd0true
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0934767533
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Calvert Langgaard & Co PLLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0306 State Street
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Guthrie Center
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd050115
ReturnHeader/PreparerPersonGrp/PhoneNum06413322115
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0SARAH LANGGAARD
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02025-05-14T09:39:41-07:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02024-01-01
ReturnHeader/TaxPeriodEndDt02024-12-31
ReturnHeader/TaxYr02024

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Peer Organizations

Similar nonprofits based on the same Siviq industry and scale cohort. 501(c)3 • <$500k nonprofits