Civic Intelligence

Hauenstein Foundation

990PF • Fiscal year 2018 • EIN 38-2898214

Jan 01, 2018 to Dec 31, 2018 • Filed on Mar 15, 2019

Organization Profile
6768 N Whitefish RoadHoward City, MI 49329

(616) 540-8139

Siviq Scores

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

Liabilities / Assets

26th percentile

0.00x

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

2018 filings • $1M-$5M nonprofits • Source year 2018

Liabilities / Revenue

26th percentile

0.00x

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

2018 filings • $1M-$5M nonprofits • Source year 2018

Net Margin

94th percentile

68%

Higher net margin than 94% of similar nonprofits.

2018 filings • $1M-$5M nonprofits • Source year 2018

Top Officer Pay

42nd percentile

$0

Higher top officer pay than 42% of similar nonprofits.

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

2018 filings • $1M-$5M nonprofits • Source year 2018

Asset Growth

50th percentile

0.8%

Faster asset growth than 50% of similar nonprofits.

2018 filings • $1M-$5M nonprofits • Annualized from 2017 to 2018

Revenue Growth

11th percentile

-30%

Faster revenue growth than 11% of similar nonprofits.

2018 filings • $1M-$5M nonprofits • Annualized from 2017 to 2018

Balance Sheet
Liabilities / Assets26th percentile

Assets

Up

$1,043,552

Up $8,446 (+0.8%) from 2017

Net Assets

Up

$1,043,552

Up $8,446 (+0.8%) from 2017

Liabilities

Flat

$0

Flat from 2017

Revenue And Expenses
Liabilities / Revenue26th percentileNet Margin94th percentile

Revenue

Down

$10,975

Down $4,661 (-30%) from 2017

Expenses

Down

$3,502

Down $224 (-6.0%) from 2017

Net Income

Down

$7,473

Down $4,437 (-37%) from 2017

Historical Trend

Balance Sheet Trend

Asset Growth50th percentile

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

$1.5M$1.0M$500K$0Assets 2010: $331,433Liabilities 2010: $0Net Assets 2010: $331,4332010Assets 2011: $260,316Liabilities 2011: $0Net Assets 2011: $260,3162011Assets 2012: $251,260Liabilities 2012: $0Net Assets 2012: $216,7952012Assets 2013: $285,337Liabilities 2013: $1Net Assets 2013: $285,3372013Assets 2014: $175,248Liabilities 2014: $1Net Assets 2014: $175,2482014Assets 2015: $263,317Liabilities 2015: $1Net Assets 2015: $263,3172015Assets 2016: $1,023,539Liabilities 2016: $0Net Assets 2016: $1,023,5392016Assets 2017: $1,035,106Liabilities 2017: $0Net Assets 2017: $1,035,1062017Assets 2018: $1,043,552Liabilities 2018: $0Net Assets 2018: $1,043,5522018Assets 2019: $1,081,571Liabilities 2019: $1Net Assets 2019: $1,081,5712019Assets 2020: $1,000,397Liabilities 2020: $1Net Assets 2020: $1,000,3972020Assets 2021: $870,205Liabilities 2021: $1Net Assets 2021: $870,2052021Assets 2022: $852,302Liabilities 2022: $1Net Assets 2022: $852,3022022Assets 2023: $870,840Liabilities 2023: $1Net Assets 2023: $870,8402023Assets 2024: $304,169Liabilities 2024: $0Net Assets 2024: $304,1692024

Highlighted filing

2018

Assets$1,043,552
Liabilities$0
Net Assets$1,043,552
Open 2018 Filing

Operations Trend

Revenue Growth11th percentile

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

$1.5M$1.0M$500K$0-$500K-$1.0MExpenses 2010: $115,6232010Expenses 2011: $64,4362011Expenses 2012: $70,6702012Revenue 2013: $95,007Expenses 2013: $60,930Net Income 2013: $34,0772013Revenue 2014: $60,117Expenses 2014: $170,206Net Income 2014: -$110,0892014Revenue 2015: $204,380Expenses 2015: $116,311Net Income 2015: $88,0692015Revenue 2016: $1,067,353Expenses 2016: $307,131Net Income 2016: $760,2222016Revenue 2017: $15,636Expenses 2017: $3,726Net Income 2017: $11,9102017Revenue 2018: $10,975Expenses 2018: $3,502Net Income 2018: $7,4732018Revenue 2019: $40,724Expenses 2019: $2,809Net Income 2019: $37,9152019Revenue 2020: $21,323Expenses 2020: $102,120Net Income 2020: -$80,7972020Revenue 2021: $21,875Expenses 2021: $152,067Net Income 2021: -$130,1922021Revenue 2022: $19,148Expenses 2022: $37,051Net Income 2022: -$17,9032022Revenue 2023: $94,256Expenses 2023: $75,718Net Income 2023: $18,5382023Revenue 2024: $234,897Expenses 2024: $801,568Net Income 2024: -$566,6712024

Highlighted filing

2018

Revenue$10,975
Expenses$3,502
Net Income$7,473
Open 2018 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2018 to Dec 31, 2018
Signed
Mar 15, 2019
Return Version
2018v3.1
Compensation and Service Providers
Top Officer Pay42nd percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
RALPH D HAUENSTEINPresident-$0--
WILLIAM F ROTHSecretary-$0--
RALPH D HAUENSTEINTreasurer-$0--
JAMES G STAHLVice President-$0--
Filing and Contact Details

Filer

Filer Name
Hauenstein Foundation
EIN
38-2898214
In Care Of
% RALPH D HAUENSTEIN
Phone
6165408139
Address
6768 N WHITEFISH ROAD, HOWARD CITY, MI 49329

Signing Officer

Name
Ralph D Hauenstein
Title
President
Phone
6165408139
Signed
2019-03-15

Preparer

Firm
Bdo USA Llp
Address
200 OTTAWA AVE NW STE 300, GRAND RAPIDS, MI 49503
Raw XML Appendix318 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/Amt02969
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0TAX PREPARATION FEE
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt01484
AccountingFeesSchedule/AccountingFeesDetail/NetInvestmentIncomeAmt01485
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt00
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt10
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt00
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt10
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm0STOCK - DUKE ENERGY CORP NEW
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm1STOCK - PPL CORPORATION
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt00
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt1231433
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt0FUNDS - ISHARES U.S. PREFERRED
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt1FUNDS -VANGUARD 500 INDEX FUND
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt00
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt1248532
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd0FMV
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd1FMV
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt06036
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt0-7608
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionAmt012547
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt010975
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt010975
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesChrtblPrpsAmt01484
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncmAmt01485
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt02969
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriRcvdRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt06036
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt06036
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt07473
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt0180753
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavNetInvstIncmAmt012547
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavRevAndExpnssAmt012547
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt0-7608
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt016565
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesNetInvstIncmAmt0150
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt0150
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesNetInvstIncmAmt0383
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesRevAndExpnssAmt0383
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt01484
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt02018
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt03502
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt018583
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt010975
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt01484
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt02018
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt03502
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt02235
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt1186126
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt0-242
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt1-7366
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt0-242
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt1-7366
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt01993
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt1178760
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0ST PUBLICLY TRADED SECURITIES
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc1LT PUBLICLY TRADED SECURITIES
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt0-7608
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt07473
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt0973
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt01043552
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt01035106
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt01043552
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt051651
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt051651
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt051651
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt051982
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0331
IRS990PF/DistributableAmountGrp/TotalTaxAmt0331
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt01200
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt01531
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0331
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/OverpaymentAmt01200
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0331
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0331
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt01531
IRS990PF/FMVAssetsEOYAmt01034096
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt0166338
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt0166338
IRS990PF/Form990PFBalanceSheetsGrp/CashBOYAmt052057
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYAmt012119
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYFMVAmt012119
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt052812
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsBOYAmt0190237
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYAmt0231433
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt0248532
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt0868768
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt0877214
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt0740000
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt0800000
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt0773445
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt01035106
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt01043552
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt01034096
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt01035106
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt01043552
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt01035106
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt01043552
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt01055466
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt013812
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt01041654
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt015832
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt051982
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt01039634
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt01055466
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt30
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt30
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt30
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt30
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0RALPH D HAUENSTEIN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm1WILLIAM F ROTH
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm2RALPH D HAUENSTEIN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm3JAMES G STAHL
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0PRESIDENT
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt1SECRETARY
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt2TREASURER
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt3VICE PRESIDENT
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt06768 N WHITEFISH ROAD
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt1200 OTTAWA AVE NW SUITE 300
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt26768 WHITEFISH RD
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt38585 ANCHOR ON LANIER
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0HOWARD CITY
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm1GRAND RAPIDS
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm2HOWARD CITY
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm3GAINSVILLE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0MI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd1MI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd2MI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd3GA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd049329
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd149503
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd249329
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd330506
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt0265174
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt0265340
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt01472
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt0299348
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt0111588
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt0164860
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt058250
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.255065
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.00144
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.460762
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.317277
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt00.358934
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt00.136914
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd0false
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt0166
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt01039634
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt01022565
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt0649680
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt0351705
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt0459304
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt0425448
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt01484
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt01.275327
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt01484
IRS990PF/QualifyingDistriPartXIIGrp/CharitableAssetsAcquisPaidAmt00
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt01484
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt01484
IRS990PF/QualifyingDistriPartXIIGrp/SetAsideCashDistriTestAmt00
IRS990PF/QualifyingDistriPartXIIGrp/SetAsideSuitabilityTestAmt00
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/NoncharitablePurposeInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProceedsOrNetIncomeInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd0false
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd0false
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/AddressLine1Txt06768 N WHITEFISH ROAD
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0HOWARD CITY
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0MI
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd049329
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0true
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0MI
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine1Txt0RALPH D HAUENSTEIN
IRS990PF/StatementsRegardingActyGrp/PhoneNum06165408139
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0true
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SummaryOfDirectChrtblActyGrp/Description1Txt0N/A
IRS990PF/SumOfProgramRelatedInvstGrp/Description1Txt0N/A
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/ShareholderManagerNm0NONE
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/AppliedToCurrentYearAmt01484
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt051651
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt050167
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr2Amt0268168
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr3Amt098027
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr4Amt0143075
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr5Amt038554
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt050167
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt0497657
IRS990PF/UndistributedIncomeGrp/ExcessFromYear2Amt0268168
IRS990PF/UndistributedIncomeGrp/ExcessFromYear3Amt098027
IRS990PF/UndistributedIncomeGrp/ExcessFromYear4Amt0131462
IRS990PF/UndistributedIncomeGrp/PriorYear1Yr02016
IRS990PF/UndistributedIncomeGrp/PriorYear2Yr02015
IRS990PF/UndistributedIncomeGrp/PriorYear3Yr02014
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt01484
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt0497657
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt0547824
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0ANNUAL ACCOUNT FEE
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt0150
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt0150
OtherIncomeSchedule2/OtherIncomeDetail/Desc0NONDIVIDEND DISTRIBUTIONS
OtherIncreasesSchedule/OtherIncreasesDetail/Amt0973
OtherIncreasesSchedule/OtherIncreasesDetail/Desc0OTHER INCREASES
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/Amt0383
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/CategoryTxt0COMMISSIONS/TRADING FEES
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/NetInvestmentIncomeAmt0383
TaxesSchedule/TaxesDetail/CategoryTxt0FEDERAL INCOME TAX
ReturnHeader/BuildTS02019-02-21 02:37:17Z
ReturnHeader/BusinessOfficerGrp/PersonNm0RALPH D HAUENSTEIN
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum06165408139
ReturnHeader/BusinessOfficerGrp/SignatureDt02019-03-15
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0HAUENSTEIN FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0HAUE
ReturnHeader/Filer/EIN0382898214
ReturnHeader/Filer/InCareOfNm0% RALPH D HAUENSTEIN
ReturnHeader/Filer/PhoneNum06165408139
ReturnHeader/Filer/USAddress/AddressLine1Txt06768 N WHITEFISH ROAD
ReturnHeader/Filer/USAddress/CityNm0HOWARD CITY
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MI
ReturnHeader/Filer/USAddress/ZIPCd049329
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0773CE6DAE30CE0BC541BB26E05521EC2F83ED7C5
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0773CE6DAE30CE0BC541BB26E05521EC2F83ED7C5
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionId038868920190845000007
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionIdDt02019-03-25
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt050.203.204.82
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0BDO USA LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0200 OTTAWA AVE NW STE 300
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0GRAND RAPIDS
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MI
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd049503
ReturnHeader/ReturnTs02019-03-25T15:46:59-05: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
$1,043,552
Liabilities
$0
Net assets
$1,043,552
Revenue
$10,975
Expenses
$3,502
Net income
$7,473
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$0.30$0.00$0.30$0.23$0.80$0.57
2023Detailed filing. Detailed filing data is available for this year.$0.87$0.00$0.87$0.09$0.08$0.02
2022Detailed filing. Detailed filing data is available for this year.$0.85$0.00$0.85$0.02$0.04$0.02
2021Detailed filing. Detailed filing data is available for this year.$0.87$0.00$0.87$0.02$0.15$0.13
2020Detailed filing. Detailed filing data is available for this year.$1.00$0.00$1.00$0.02$0.10$0.08
2019Detailed filing. Detailed filing data is available for this year.$1.08$0.00$1.08$0.04$0.00$0.04
2018Detailed filing. Detailed filing data is available for this year.$1.04$0.00$1.04$0.01$0.00$0.01
2017Detailed filing. Detailed filing data is available for this year.$1.04$0.00$1.04$0.02$0.00$0.01
2016Detailed filing. Detailed filing data is available for this year.$1.02$0.00$1.02$1.07$0.31$0.76
2015Detailed filing. Detailed filing data is available for this year.$0.26$0.00$0.26$0.20$0.12$0.09
2014Detailed filing. Detailed filing data is available for this year.$0.18$0.00$0.18$0.06$0.17$0.11
2013Detailed filing. Detailed filing data is available for this year.$0.29$0.00$0.29$0.10$0.06$0.03
2012Detailed filing. Detailed filing data is available for this year.$0.25$0.00$0.22$0.07
2011Detailed filing. Detailed filing data is available for this year.$0.26$0.00$0.26$0.06
2010Detailed filing. Detailed filing data is available for this year.$0.33$0.00$0.33$0.12