Civic Intelligence

Hauenstein Foundation

990PF • Fiscal year 2017 • EIN 38-2898214

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

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

25th percentile

0.00x

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

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

Liabilities / Revenue

25th percentile

0.00x

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

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

Net Margin

95th percentile

76%

Higher net margin than 95% of similar nonprofits.

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

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.

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

Asset Growth

44th percentile

1.1%

Faster asset growth than 44% of similar nonprofits.

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

Revenue Growth

1st percentile

-99%

Faster revenue growth than 1% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets25th percentile

Assets

Up

$1,035,106

Up $11,567 (+1.1%) from 2016

Net Assets

Up

$1,035,106

Up $11,567 (+1.1%) from 2016

Liabilities

Flat

$0

Flat from 2016

Revenue And Expenses
Liabilities / Revenue25th percentileNet Margin95th percentile

Revenue

Down

$15,636

Down $1,051,717 (-99%) from 2016

Expenses

Down

$3,726

Down $303,405 (-99%) from 2016

Net Income

Down

$11,910

Down $748,312 (-98%) from 2016

Historical Trend

Balance Sheet Trend

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

2017

Assets$1,035,106
Liabilities$0
Net Assets$1,035,106
Open 2017 Filing

Operations Trend

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

2017

Revenue$15,636
Expenses$3,726
Net Income$11,910
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Mar 15, 2018
Return Version
2017v2.3
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
2018-03-15

Preparer

Firm
Bdo USA Llp
Address
200 OTTAWA AVE NW STE 300, GRAND RAPIDS, MI 49503
Raw XML Appendix321 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/Amt02945
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0TAX PREPARATION FEE
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt01472
AccountingFeesSchedule/AccountingFeesDetail/NetInvestmentIncomeAmt01473
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt026301
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt126511
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt027124
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt121437
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm0STOCK - DUKE ENERGY CORP NEW
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm1STOCK - PPL CORPORATION
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt025276
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt1164961
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt0FUNDS - ISHARES U.S. PREFERRED
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt1FUNDS -VANGUARD 500 INDEX FUND
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt024365
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt1201601
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd0FMV
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd1FMV
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt07544
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt0-3515
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionAmt011607
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt015636
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt015636
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesChrtblPrpsAmt01472
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncmAmt01473
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt02945
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriRcvdRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt07544
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt07544
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt011910
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt0134948
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavNetInvstIncmAmt011607
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavRevAndExpnssAmt011607
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt0-3515
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt016897
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesNetInvstIncmAmt0150
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt0150
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesNetInvstIncmAmt0631
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesRevAndExpnssAmt0631
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt01472
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt02254
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt03726
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt019151
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt015636
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt01472
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt02254
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt03726
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt01162
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt1137301
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt0-60
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt1-3455
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt0-60
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt1-3455
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt01102
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt1133846
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0PUBLICLY TRADED SECURITIES
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc1PUBLICLY TRADED SECURITIES
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt0-3515
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt011910
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt0343
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt01035449
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt01023539
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt01035106
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt050790
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt050790
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt050790
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt051128
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0338
IRS990PF/DistributableAmountGrp/TotalTaxAmt0338
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt01531
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt01869
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0338
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/OverpaymentAmt01531
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0338
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0338
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt01869
IRS990PF/FMVAssetsEOYAmt01053411
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt0166338
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt0166338
IRS990PF/Form990PFBalanceSheetsGrp/CashBOYAmt017444
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYAmt052057
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYFMVAmt052057
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt078822
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt052812
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt048561
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsBOYAmt0157273
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYAmt0190237
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt0225966
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt0857201
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt0868768
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt0770000
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt0740000
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt0726827
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt01023539
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt01035106
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt01053411
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt01023539
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt01035106
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt01023539
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt01035106
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt01038137
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt029602
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt01008535
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt015572
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt051128
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt01022565
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt01038137
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/AdjNetVlNoncharitableAssetsAmt0296808
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt0296977
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt0299348
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt0111588
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt0164860
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt058250
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt070500
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.290258
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.460762
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.317277
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.358934
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt00.136914
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt00.177405
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd0false
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt0169
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt01022565
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt0649680
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt0351705
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt0459304
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt0425448
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt0397396
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt01472
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt01.451292
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt01472
IRS990PF/QualifyingDistriPartXIIGrp/CharitableAssetsAcquisPaidAmt00
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt01472
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt01472
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/AppliedToCurrentYearAmt01472
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt050790
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt049318
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr1Amt0268168
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr2Amt098027
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr3Amt0143075
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr4Amt038554
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr5Amt051836
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt049318
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt02518
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt0547824
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt0268168
IRS990PF/UndistributedIncomeGrp/ExcessFromYear2Amt098027
IRS990PF/UndistributedIncomeGrp/ExcessFromYear3Amt0143075
IRS990PF/UndistributedIncomeGrp/ExcessFromYear4Amt038554
IRS990PF/UndistributedIncomeGrp/PriorYear1Yr02015
IRS990PF/UndistributedIncomeGrp/PriorYear2Yr02014
IRS990PF/UndistributedIncomeGrp/PriorYear3Yr02013
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt01472
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt0550342
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt0599660
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt00
OtherDecreasesSchedule/OtherDecreasesDetail/Amt0343
OtherDecreasesSchedule/OtherDecreasesDetail/Desc0OTHER DECREASES
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0ANNUAL ACCOUNT FEE
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt0150
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt0150
OtherIncomeSchedule2/OtherIncomeDetail/Desc0NONDIVIDEND DISTRIBUTIONS
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/Amt0631
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/CategoryTxt0COMMISSIONS/TRADING FEES
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/NetInvestmentIncomeAmt0631
TaxesSchedule/TaxesDetail/CategoryTxt0FEDERAL INCOME TAX
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/PersonNm0RALPH D HAUENSTEIN
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum06165408139
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-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/AtSubmissionCreationDeviceId0330F8D7AF8D657EE5B4C36991DC33192E31A3A76
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0A8C94039D3A9BFBEA94A7566F22BD140A9846A72
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionId038868920181355000012
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionIdDt02018-05-15
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt050.233.169.122
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/ReturnTs02018-05-15T12:37:10-05:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02017-01-01
ReturnHeader/TaxPeriodEndDt02017-12-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$1,035,106
Liabilities
$0
Net assets
$1,035,106
Revenue
$15,636
Expenses
$3,726
Net income
$11,910
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