Civic Intelligence

The Robert W Hemelgarn Memorial Foundation

990PF • Fiscal year 2018 • EIN 93-1216871

Jan 01, 2018 to Dec 31, 2018 • Filed on Sep 20, 2019

Organization Profile
4725 S Holladay Blvd Ste 210Salt Lake City, UT 84117-5482

(801) 272-5214

Siviq Scores

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

Liabilities / Assets

59th percentile

0.00x

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

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

Liabilities / Revenue

59th percentile

0.00x

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

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

Net Margin

90th percentile

47%

Higher net margin than 90% of similar nonprofits.

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

Top Officer Pay

77th percentile

$0

Higher top officer pay than 77% of similar nonprofits.

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

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

Asset Growth

66th percentile

9.4%

Faster asset growth than 66% of similar nonprofits.

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

Revenue Growth

82nd percentile

37%

Faster revenue growth than 82% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets59th percentile

Assets

Up

$41,497

Up $9,783 (+31%) from 2015

Net Assets

$41,497

No earlier filing loaded for comparison.

Liabilities

Flat

$0

Flat from 2015

Revenue And Expenses
Liabilities / Revenue59th percentileNet Margin90th percentile

Revenue

Up

$24,625

Up $15,000 (+156%) from 2015

Expenses

Up

$13,121

Up $3,343 (+34%) from 2015

Net Income

Up

$11,504

Up $11,657 (+7619%) from 2015

Historical Trend

Balance Sheet Trend

Asset Growth66th percentile

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

$300K$200K$100K$0Assets 2011: $12,474Liabilities 2011: $02011Assets 2012: $16,313Liabilities 2012: $02012Assets 2013: $19,118Liabilities 2013: $02013Assets 2014: $31,867Liabilities 2014: $02014Assets 2015: $31,714Liabilities 2015: $02015Assets 2018: $41,497Liabilities 2018: $0Net Assets 2018: $41,4972018Assets 2019: $44,104Liabilities 2019: $0Net Assets 2019: $44,1042019Assets 2020: $40,373Liabilities 2020: $0Net Assets 2020: $40,3732020Assets 2021: $26,006Liabilities 2021: $0Net Assets 2021: $26,0062021Assets 2022: $25,485Liabilities 2022: $0Net Assets 2022: $25,4852022Assets 2023: $28,852Liabilities 2023: $0Net Assets 2023: $28,8522023Assets 2024: $224,364Liabilities 2024: $0Net Assets 2024: $224,3642024

Highlighted filing

2018

Assets$41,497
Liabilities$0
Net Assets$41,497
Open 2018 Filing

Operations Trend

Revenue Growth82nd percentile

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

$300K$200K$100K$0-$100KRevenue 2011: $10,625Expenses 2011: $10,685Net Income 2011: -$602011Revenue 2012: $8,424Expenses 2012: $4,585Net Income 2012: $3,8392012Revenue 2013: $8,700Expenses 2013: $5,895Net Income 2013: $2,8052013Revenue 2014: $24,100Expenses 2014: $11,351Net Income 2014: $12,7492014Revenue 2015: $9,625Expenses 2015: $9,778Net Income 2015: -$1532015Revenue 2018: $24,625Expenses 2018: $13,121Net Income 2018: $11,5042018Revenue 2019: $7,734Expenses 2019: $5,127Net Income 2019: $2,6072019Revenue 2020: $750Expenses 2020: $4,481Net Income 2020: -$3,7312020Revenue 2021: $10,025Expenses 2021: $24,392Net Income 2021: -$14,3672021Revenue 2022: $13,676Expenses 2022: $14,197Net Income 2022: -$5212022Revenue 2023: $12,280Expenses 2023: $8,913Net Income 2023: $3,3672023Revenue 2024: $209,880Expenses 2024: $14,368Net Income 2024: $195,5122024

Highlighted filing

2018

Revenue$24,625
Expenses$13,121
Net Income$11,504
Open 2018 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2018 to Dec 31, 2018
Signed
Sep 20, 2019
Return Version
2018v3.1
Compensation and Service Providers
Top Officer Pay77th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
Ronald HemelgarnPresident-$0--
Helen HemelgarnVice President-$0--
Rhonda HemelgarnSecretary-$0--
Amy HemelgarnTreasurer-$0--
Filing and Contact Details

Filer

Filer Name
Robert W Hemelgarn Memorial Foundation
EIN
93-1216871
Address
4725 S Holladay Blvd Ste 210, Salt Lake City, UT 84117-5482

Signing Officer

Name
Ronald Hemelgarn
Title
President
Phone
8012725214
Signed
2019-09-20
Discuss with paid preparer
Yes

Preparer

Firm
Charles R Larson CPA PLLC
Address
PO Box 17868, Salt Lake City, UT 84117-0868
Preparer
Charles R Larson CPA
Phone
8012782497
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
AccountingFeesSchedule/AccountingFeesDetail/Amt0931
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0Accounting
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt0186
AccountingFeesSchedule/AccountingFeesDetail/NetInvestmentIncomeAmt0745
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesChrtblPrpsAmt0186
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncmAmt0745
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt0931
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt010438
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt010438
IRS990PF/AnalysisOfRevenueAndExpenses/ContriRcvdRevAndExpnssAmt024625
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt011504
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesDsbrsChrtblAmt0351
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesNetInvstIncmAmt01401
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt01752
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt010975
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt02146
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt013121
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt024625
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt0537
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt02146
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt02683
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt011504
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt041497
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt029993
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt041497
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt01760
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt01760
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt01760
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt01760
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt00
IRS990PF/FMVAssetsEOYAmt041497
IRS990PF/Form990PFBalanceSheetsGrp/CashBOYAmt029993
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYAmt041497
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYFMVAmt041497
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt029993
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt041497
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt029993
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt041497
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt041497
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt029993
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt041497
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt029993
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt041497
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt035745
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt035745
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt00
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt0536
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt01760
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt035209
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt035745
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt0000.10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt1000.10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt2000.10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt3000.10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt30
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0Ronald Hemelgarn
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm1Helen Hemelgarn
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm2Rhonda Hemelgarn
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm3Amy Hemelgarn
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0President
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt1Vice president
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt2Secretary
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt3Treasurer
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt02515 W Stein Rd
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt12515 W Stein Rd
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt22565 W Stein Rd
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt32635 W Stein Rd
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0La Salle
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm1La Salle
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm2La Salle
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm3La Salle
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0MI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd1MI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd2MI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd3MI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd048145
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd148145
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd248145
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd348145
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt010149
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt010149
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt010796
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt05948
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt08476
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt010110
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt04220
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt0000.288238
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt0000.342371
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt0000.183694
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt0000.270678
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt0000.402612
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt0000.241834
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt035209
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt031533
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt032380
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt031314
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt025111
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt017450
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt010975
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt0001.441189
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt010975
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt010975
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt010975
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd0false
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd0false
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd0false
IRS990PF/StatementsRegardingActy4720Grp/MaintainedExpenditureRspnsInd0false
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd0false
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/SubjToTaxRmnrtnExPrchtPymtInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd0false
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/AddressLine1Txt04725 S Holladay Blvd Ste 210
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0Salt Lake City
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0UT
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd084117
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0UT
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine1Txt0Service Specialties Inc
IRS990PF/StatementsRegardingActyGrp/PhoneNum08012725214
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0true
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SummaryOfDirectChrtblActyGrp/Description1Txt0N/A
IRS990PF/SummaryOfDirectChrtblActyGrp/Expenses1Amt00
IRS990PF/SumOfProgramRelatedInvstGrp/Description1Txt0NONE
IRS990PF/SupplementaryInformationGrp/ContributingManagerNm0NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt01786
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt12121
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt24781
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt3500
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt4250
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt5500
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt6500
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0Charitable
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1Charitable
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt2Charitable
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt3Scholarship
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt4Charitable
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt5Scholarship
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt6Scholarship
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt0Mercy St Vincent NW Region
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt1Mercy health Physicians
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt2Michigan Medicine University of Michigan
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt3Monroe Community College
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt4Race For The Kids
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt5Schoolcraft College
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt6University of Michigan
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt1PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt2PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt3PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt4PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt5PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt6PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt0PO Box 636447
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt1PO Box 630584
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt2Dept CH 14410
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt37704 Dunbar Rd
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt42299 Manhattan St
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt518600 Haggerty Rd
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt62673 Morin Grove St
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0Cincinnati
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm1Cincinnati
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm2Palatine
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm3Ida
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm4Erie
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm5Livonia
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm6Erie
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0OH
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd1OH
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd2IL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd3MI
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd4MI
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd5MI
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd6MI
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd045263
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd145263
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd260055
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd348140
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd448133
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd548152
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd648133
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/ShareholderManagerNm0NONE
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt010438
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/AppliedToCurrentYearAmt01760
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt01760
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr1Amt09219
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr2Amt04329
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr3Amt06910
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr4Amt08854
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr5Amt03347
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt03347
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt038527
IRS990PF/UndistributedIncomeGrp/ExcessFromCurrentYearAmt09215
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt09219
IRS990PF/UndistributedIncomeGrp/ExcessFromYear2Amt04329
IRS990PF/UndistributedIncomeGrp/ExcessFromYear3Amt06910
IRS990PF/UndistributedIncomeGrp/ExcessFromYear4Amt08854
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt010975
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt09215
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt041874
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt032659
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0Office expense
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc1Bank charges
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc2Advertising
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt03
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt1114
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt2234
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt010
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt1456
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt2935
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt013
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt1570
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt21169
ReturnHeader/BuildTS02019-02-21 02:37:17Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0Ronald Hemelgarn
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0President
ReturnHeader/BusinessOfficerGrp/PhoneNum08012725214
ReturnHeader/BusinessOfficerGrp/SignatureDt02019-09-20
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0Robert W Hemelgarn Memorial Foundation
ReturnHeader/Filer/BusinessNameControlTxt0ROBE
ReturnHeader/Filer/EIN0931216871
ReturnHeader/Filer/USAddress/AddressLine1Txt04725 S Holladay Blvd Ste 210
ReturnHeader/Filer/USAddress/CityNm0Salt Lake City
ReturnHeader/Filer/USAddress/StateAbbreviationCd0UT
ReturnHeader/Filer/USAddress/ZIPCd0841175482
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0E11F10CDB13A4B43BCCBCAA2E8B42346D9F28B8D
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0E11F10CDB13A4B43BCCBCAA2E8B42346D9F28B8D
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt075.145.56.130
ReturnHeader/FilingSecurityInformation/IPDt02019-09-26
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0US
ReturnHeader/FilingSecurityInformation/IPTm015:02:32
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Charles R Larson CPA PLLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0PO Box 17868
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Salt Lake City
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0UT
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0841170868
ReturnHeader/PreparerPersonGrp/PhoneNum08012782497
ReturnHeader/PreparerPersonGrp/PreparationDt02019-09-20
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Charles R Larson CPA
ReturnHeader/ReturnTs02019-09-20T05:26:58-00:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02018-01-01
ReturnHeader/TaxPeriodEndDt02018-12-31
ReturnHeader/TaxYr02018

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$41,497
Liabilities
$0
Net assets
$41,497
Revenue
$24,625
Expenses
$13,121
Net income
$11,504
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$2.24$0.00$2.24$2.10$0.14$1.96
2023Detailed filing. Detailed filing data is available for this year.$0.29$0.00$0.29$0.12$0.09$0.03
2022Detailed filing. Detailed filing data is available for this year.$0.25$0.00$0.25$0.14$0.14$0.01
2021Detailed filing. Detailed filing data is available for this year.$0.26$0.00$0.26$0.10$0.24$0.14
2020Detailed filing. Detailed filing data is available for this year.$0.40$0.00$0.40$0.01$0.04$0.04
2019Detailed filing. Detailed filing data is available for this year.$0.44$0.00$0.44$0.08$0.05$0.03
2018Detailed filing. Detailed filing data is available for this year.$0.41$0.00$0.41$0.25$0.13$0.12
2015Summary only. Only limited summary data is available for this year.$0.32$0.00$0.10$0.10$0.00
2014Summary only. Only limited summary data is available for this year.$0.32$0.00$0.24$0.11$0.13
2013Summary only. Only limited summary data is available for this year.$0.19$0.00$0.09$0.06$0.03
2012Summary only. Only limited summary data is available for this year.$0.16$0.00$0.08$0.05$0.04
2011Summary only. Only limited summary data is available for this year.$0.12$0.00$0.11$0.11$0.00