Civic Intelligence

Hans F Hansen T U W

990PF • Fiscal year 2015 • EIN 38-6061778

Aug 01, 2014 to Jul 31, 2015 • Filed on Aug 20, 2015

Organization Profile
PO Box 75000Detroit, MI 48275-7874

(231) 739-0364

Siviq Scores

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

Liabilities / Assets

59th percentile

0.00x

Higher debt load relative to assets than 59% of similar nonprofits.

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

Liabilities / Revenue

59th percentile

0.00x

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

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

Net Margin

7th percentile

-106%

Higher net margin than 7% of similar nonprofits.

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

Top Officer Pay

84th percentile

$12,979

Higher top officer pay than 84% of similar nonprofits.

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

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

Asset Growth

31st percentile

-6.9%

Faster asset growth than 31% of similar nonprofits.

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

Revenue Growth

38th percentile

-6.8%

Faster revenue growth than 38% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets59th percentile

Assets

Down

$460,535

Down $33,962 (-6.9%) from 2014

Net Assets

Down

$460,535

Down $33,962 (-6.9%) from 2014

Liabilities

Flat

$1

Flat from 2014

Revenue And Expenses
Liabilities / Revenue59th percentileNet Margin7th percentile

Revenue

Down

$31,129

Down $2,265 (-6.8%) from 2014

Expenses

Up

$64,178

Up $9,148 (+17%) from 2014

Net Income

Down

-$33,049

Down $11,413 (-53%) from 2014

Historical Trend

Balance Sheet Trend

Asset Growth31st percentile

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

$600K$400K$200K$0Assets 2011: $532,618Liabilities 2011: $02011Assets 2012: $532,073Liabilities 2012: $0Net Assets 2012: $532,0732012Assets 2013: $517,294Liabilities 2013: $1Net Assets 2013: $517,2942013Assets 2014: $494,497Liabilities 2014: $1Net Assets 2014: $494,4972014Assets 2015: $460,535Liabilities 2015: $1Net Assets 2015: $460,5352015Assets 2016: $461,578Liabilities 2016: $1Net Assets 2016: $461,5782016Assets 2017: $472,738Liabilities 2017: $0Net Assets 2017: $472,7382017Assets 2018: $519,166Liabilities 2018: $0Net Assets 2018: $519,1662018Assets 2019: $499,964Liabilities 2019: $0Net Assets 2019: $499,9642019Assets 2020: $513,618Liabilities 2020: $1Net Assets 2020: $513,6182020Assets 2021: $451,310Liabilities 2021: $1Net Assets 2021: $451,3102021Assets 2022: $440,777Liabilities 2022: $1Net Assets 2022: $440,7772022Assets 2023: $416,614Liabilities 2023: $12023Assets 2024: $486,674Liabilities 2024: $12024Assets 2025: $486,360Liabilities 2025: $0Net Assets 2025: $486,3602025

Highlighted filing

2015

Assets$460,535
Liabilities$1
Net Assets$460,535
Open 2015 Filing

Operations Trend

Revenue Growth38th percentile

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

$100K$50K$0-$50K-$100KRevenue 2011: $52,683Expenses 2011: $21,080Net Income 2011: $31,6032011Expenses 2012: $17,8712012Revenue 2013: $29,208Expenses 2013: $44,397Net Income 2013: -$15,1892013Revenue 2014: $33,394Expenses 2014: $55,030Net Income 2014: -$21,6362014Revenue 2015: $31,129Expenses 2015: $64,178Net Income 2015: -$33,0492015Revenue 2016: $29,562Expenses 2016: $17,474Net Income 2016: $12,0882016Revenue 2017: $6,412Expenses 2017: $7,348Net Income 2017: -$9362017Revenue 2018: $64,451Expenses 2018: $16,557Net Income 2018: $47,8942018Revenue 2019: $21,650Expenses 2019: $33,145Net Income 2019: -$11,4952019Revenue 2020: $21,216Expenses 2020: $7,533Net Income 2020: $13,6832020Revenue 2021: $28,055Expenses 2021: $90,285Net Income 2021: -$62,2302021Revenue 2022: $25,228Expenses 2022: $35,712Net Income 2022: -$10,4842022Revenue 2023: $21,345Expenses 2023: $45,648Net Income 2023: -$24,3032023Revenue 2024: $86,908Expenses 2024: $16,847Net Income 2024: $70,0612024Revenue 2025: $18,966Expenses 2025: $19,282Net Income 2025: -$3162025

Highlighted filing

2015

Revenue$31,129
Expenses$64,178
Net Income-$33,049
Open 2015 Filing
Jump To
Filing Snapshot
Filing Period
Aug 1, 2014 to Jul 31, 2015
Signed
Aug 20, 2015
Return Version
2014v5.0
Compensation and Service Providers
Top Officer Pay84th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
COMERICA BANKTrustee-$12,979-$12,979
Filing and Contact Details

Filer

Filer Name
Hansen Hans F Tuw
EIN
38-6061778
Phone
2317390364
Address
PO BOX 75000, DETROIT, MI 48275-7874

Signing Officer

Name
Jacquelyn Sparks-walker
Title
Vice President
Phone
2317390364
Signed
2015-08-20

Preparer

Firm
Kpmg Llp
Address
2020 N CENTRAL AVE STE 700, PHOENIX, AZ 85004
Preparer
Jeffrey E Kuhlin
Phone
8558073423
Raw XML Appendix351 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
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/BondNm0CORPORTAE BOND FUNDS
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt081205
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt078299
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt0357931
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt0370089
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm0CORPORATE STOCKS
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt014114
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt017015
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt031129
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt031129
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt017015
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt01298
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt011681
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt012979
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt050900
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt050900
IRS990PF/AnalysisOfRevenueAndExpenses/DeprecAndDpltnNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DeprecAndDpltnRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt014114
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt014114
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-33049
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt039530
IRS990PF/AnalysisOfRevenueAndExpenses/InterestDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt017015
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt019448
IRS990PF/AnalysisOfRevenueAndExpenses/NetSTCapitalGainAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OthEmplSlrsWgsAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OthEmplSlrsWgsDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OthEmplSlrsWgsNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/PensionEmplBnftAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/PensionEmplBnftNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/PrintingAndPubAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/PrintingAndPubNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt0299
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt052198
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt011681
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt064178
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt031129
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt031129
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt01298
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt011681
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt013278
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingNetInvstIncmAmt00
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt02013-11-20
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt12013-11-20
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt22013-11-20
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt32013-11-20
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt42013-11-20
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt52013-11-20
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt62011-06-24
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt72011-06-24
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt82011-06-24
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt03134
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt11730
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt2218
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt34289
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt41824
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt51636
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt64443
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt74074
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt81167
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt080
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt1205
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt29
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt3429
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt4-3
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt546
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt6-53
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt7-66
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt8-56
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt9251
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt080
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt1205
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt29
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt3429
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt4-3
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt546
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt6-53
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt7-66
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt8-56
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt03214
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt11935
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt2227
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt34718
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt41821
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt51682
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt64390
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt74008
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt81111
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc028. ISHARES BARCLAYS US TREASURY INFLATION PROTECTED SECURITY FUND
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc140. ISHARES S&P NORTH AMERICAN NATURAL RESOURCES SECTOR INDEX FD
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc22. ISHARES JP MORGAN USD EMERGING MARKETS B
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc3110. ISHARES S&P GLOBAL INFRASTRUCURE INDX FD
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc445. SPDR BARCLAYS CAPITAL HIGH YIELD BOND ET
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc528. SPDR LEHMAN INTL TREASURY BD ETF
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc652. VANGUARD INTERMED-TERM BOND ETF
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc750. VANGUARD SHORT-TERM BOND ETF
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc825. VANGUARD EMERGING MARKETS ETF CLOSED-END FUND
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc9CAPITAL GAIN DIVIDENDS
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt02014-08-04
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt12014-08-04
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt22014-08-04
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt32014-08-04
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt42014-08-04
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt52014-08-04
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt62014-08-04
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt72014-08-04
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt82014-08-04
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt017015
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-33049
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt0913
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0461448
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0494497
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0460535
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt023392
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt023392
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt023392
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt023586
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0194
IRS990PF/DistributableAmountGrp/TotalTaxAmt0194
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToEsTaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt076
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/DomesticOrgMeetingSect4940eInd0X
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EsPenaltyAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt0270
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0194
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/OverpaymentAmt076
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/RefundAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0194
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0194
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt0270
IRS990PF/FMVAssetsEOYAmt0469787
IRS990PF/Form990PFBalanceSheetsGrp/AcctRcvblEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AcctRcvblEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt0494497
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt0460535
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsBOYAmt093401
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYAmt081205
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYFMVAmt078299
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt0353172
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt0357931
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt0370089
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/OtherRcvblAllwncDbtflAcctAmt00
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt047924
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt021399
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt021399
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0494497
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0460535
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0469787
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0494497
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0460535
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0494497
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0460535
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0478893
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt018433
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0460460
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt07183
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt023586
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0471710
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0478893
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt01
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt012979
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0COMERICA BANK
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt0PO BOX 75000 M/C 3302
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0DETROIT
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0MI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd0482753302
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt021609
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt021803
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt047552
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt034534
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt09580
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt013648
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt013597
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.045809
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.091459
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.065617
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.018502
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt00.026276
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt00.02719
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd0false
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt0194
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt0471710
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt0519927
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt0526296
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt0517785
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt0519412
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt0500077
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt052198
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.229044
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt052004
IRS990PF/QualifyingDistriPartXIIGrp/CharitableAssetsAcquisPaidAmt00
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt052198
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt0194
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt052198
IRS990PF/QualifyingDistriPartXIIGrp/SetAsideCashDistriTestAmt00
IRS990PF/QualifyingDistriPartXIIGrp/SetAsideSuitabilityTestAmt00
IRS990PF/StatementsRegardingActy4720Grp/ActsFailToQlfyAsExceptionsInd00
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/PayCompDisqualifiedPrsnInd0true
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd0false
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistrIncmSect4942a2NotAppInd0false
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/AddressLine1Txt0101 NORTH MAIN STREET
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0ANN ARBOR
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0MI
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd048104
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0MI
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine1Txt0COMERICA BANK
IRS990PF/StatementsRegardingActyGrp/PhoneNum08774051091
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0true
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt050900
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0SUPPORT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt0MERCY HEALTH PARTNERS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0EXEMPT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt01500 E SHERMAN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0MUSKEGON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0MI
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd049444
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt050900
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/AppliedToCurrentYearAmt023392
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt04000
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt023392
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr1Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr2Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr3Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr4Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt024806
IRS990PF/UndistributedIncomeGrp/ExcessFromCurrentYearAmt024806
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt00
IRS990PF/UndistributedIncomeGrp/ExcessFromYear2Amt00
IRS990PF/UndistributedIncomeGrp/ExcessFromYear3Amt00
IRS990PF/UndistributedIncomeGrp/ExcessFromYear4Amt00
IRS990PF/UndistributedIncomeGrp/PriorYear1Yr02012
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt052198
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt024806
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt024806
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt00
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt04000
OtherDecreasesSchedule/OtherDecreasesDetail/Amt0913
OtherDecreasesSchedule/OtherDecreasesDetail/Desc0DIFFERENCE BETWEEN CASH RECEIPTS AND TAXABLE INCOME
ReturnHeader/BuildTS02016-03-07 17:11:31Z
ReturnHeader/BusinessOfficerGrp/PersonNm0JACQUELYN SPARKS-WALKER
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0VICE PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum02317390364
ReturnHeader/BusinessOfficerGrp/SignatureDt02015-08-20
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0HANSEN HANS F TUW
ReturnHeader/Filer/BusinessNameControlTxt0HANS
ReturnHeader/Filer/EIN0386061778
ReturnHeader/Filer/PhoneNum02317390364
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 75000
ReturnHeader/Filer/USAddress/CityNm0DETROIT
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MI
ReturnHeader/Filer/USAddress/ZIPCd0482757874
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0KPMG LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt02020 N CENTRAL AVE STE 700
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0PHOENIX
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0AZ
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd085004
ReturnHeader/PreparerPersonGrp/PhoneNum08558073423
ReturnHeader/PreparerPersonGrp/PreparationDt02015-08-20
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0JEFFREY E KUHLIN
ReturnHeader/ReturnTs02015-08-20T21:00:26-05:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02014-08-01
ReturnHeader/TaxPeriodEndDt02015-07-31
ReturnHeader/TaxYr02014

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$460,535
Liabilities
$1
Net assets
$460,535
Revenue
$31,129
Expenses
$64,178
Net income
-$33,049
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2025XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$4.86$0.00$4.86$0.19$0.19$0.00
2024XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$4.87$0.00$0.87$0.17$0.70
2023XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$4.17$0.00$0.21$0.46$0.24
2022XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$4.41$0.00$4.41$0.25$0.36$0.10
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$4.51$0.00$4.51$0.28$0.90$0.62
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$5.14$0.00$5.14$0.21$0.08$0.14
2019Import issue. A filing source exists for this year, but detailed import did not complete cleanly.$5.00$0.00$5.00$0.22$0.33$0.11
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$5.19$0.00$5.19$0.64$0.17$0.48
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$4.73$0.00$4.73$0.06$0.07$0.01
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$4.62$0.00$4.62$0.30$0.17$0.12
2015Detailed filing. Detailed filing data is available for this year.$4.61$0.00$4.61$0.31$0.64$0.33
2014XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$4.94$0.00$4.94$0.33$0.55$0.22
2013Detailed filing. Detailed filing data is available for this year.$5.17$0.00$5.17$0.29$0.44$0.15
2012Detailed filing. Detailed filing data is available for this year.$5.32$0.00$5.32$0.18
2011Summary only. Only limited summary data is available for this year.$5.33$0.00$0.53$0.21$0.32
Peer Organizations

Similar nonprofits based on the same Siviq industry and scale cohort. 2015 filings • <$500k nonprofits