Civic Intelligence

Hans F Hansen T U W

990PF • Fiscal year 2014 • EIN 38-6061778

Aug 01, 2013 to Jul 31, 2014 • Filed on Aug 12, 2014

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

58th percentile

0.00x

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

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

Liabilities / Revenue

58th percentile

0.00x

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

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

Net Margin

9th percentile

-65%

Higher net margin than 9% of similar nonprofits.

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

Top Officer Pay

81st percentile

$7,754

Higher top officer pay than 81% of similar nonprofits.

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

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

Asset Growth

35th percentile

-4.4%

Faster asset growth than 35% of similar nonprofits.

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

Revenue Growth

68th percentile

14%

Faster revenue growth than 68% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets58th percentile

Assets

Down

$494,497

Down $22,797 (-4.4%) from 2013

Net Assets

Down

$494,497

Down $22,797 (-4.4%) from 2013

Liabilities

Flat

$1

Flat from 2013

Revenue And Expenses
Liabilities / Revenue58th percentileNet Margin9th percentile

Revenue

Up

$33,394

Up $4,186 (+14%) from 2013

Expenses

Up

$55,030

Up $10,633 (+24%) from 2013

Net Income

Down

-$21,636

Down $6,447 (-42%) from 2013

Historical Trend

Balance Sheet Trend

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

2014

Assets$494,497
Liabilities$1
Net Assets$494,497
Open 2014 Filing

Operations Trend

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

2014

Revenue$33,394
Expenses$55,030
Net Income-$21,636
Open 2014 Filing
Jump To
Filing Snapshot
Filing Period
Aug 1, 2013 to Jul 31, 2014
Signed
Aug 12, 2014
Return Version
2013v3.1
Compensation and Service Providers
Top Officer Pay81st percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
COMERICA BANKTrustee-$7,754-$7,754
Filing and Contact Details

Filer

EIN
38-6061778
Phone
2317390364

Signing Officer

Name
Jackie Sparks Walker
Title
Vice President
Phone
2317390364
Signed
2014-08-12
Discuss with paid preparer
Yes

Preparer

Phone
4198612300
Raw XML Appendix337 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/EOYBookValueAmt093401
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt093637
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt0353172
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt0396272
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm0CORPORATE STOCKS
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt014087
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt019307
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt033394
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt033394
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt019307
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt0775
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt06978
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt07754
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt047041
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt047041
IRS990PF/AnalysisOfRevenueAndExpenses/DeprecAndDpltnNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DeprecAndDpltnRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt014087
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt014087
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-21636
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt0198634
IRS990PF/AnalysisOfRevenueAndExpenses/InterestDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt019307
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt026416
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/TaxesRevAndExpnssAmt0235
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt047816
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt06978
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt055030
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt033394
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt033394
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt0775
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt06978
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt07989
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingNetInvstIncmAmt00
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt02011-06-24
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt12011-07-06
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt22011-06-24
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt32011-07-06
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt42011-06-24
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt52011-06-24
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt62011-06-24
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt08978
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt113931
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt28460
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt332395
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt412140
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt551270
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt652153
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt03319
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt1439
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt24096
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt3-4752
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt41164
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt5-1086
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt6-614
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt7285
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt03319
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt1439
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt24096
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt3-4752
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt41164
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt5-1086
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt6-614
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt012297
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt114370
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt212556
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt327643
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt413304
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt550184
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt651539
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc095. ISHARES S&P MIDCAP 400
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc1186. ISHARES COHEN & STEERS REALTY MAJOR INDEX FUND (REITS)
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc2120. ISHARES TR-S&P SMALL CAP 600
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc31100. POWERSHARES DB COMMODITY INDEX TRACKING FUND
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc4400. SPDR S&P INTL SMALL CAP
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc5600. VANGUARD INTERMED-TERM BOND ETF
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc6640. VANGUARD SHORT-TERM BOND ETF
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc7CAPITAL GAIN DIVIDENDS
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt02013-11-20
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt12013-11-20
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt22013-11-20
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt32013-11-12
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt42013-11-20
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt52013-11-20
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt62013-11-20
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt019307
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-21636
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt01161
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0495658
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0517294
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0494497
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt025732
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt025732
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt025732
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt025996
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0264
IRS990PF/DistributableAmountGrp/TotalTaxAmt0264
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToEsTaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/DomesticOrgMeetingSect4940eInd0X
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EsPenaltyAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt0235
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0264
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/RefundAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0264
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0264
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxDueAmt029
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt0235
IRS990PF/FMVAssetsEOYAmt0537833
IRS990PF/Form990PFBalanceSheetsGrp/AcctRcvblEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AcctRcvblEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt0517294
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt0494497
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsBOYAmt0160998
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYAmt093401
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYFMVAmt093637
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt0273342
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt0353172
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt0396272
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/OtherRcvblAllwncDbtflAcctAmt00
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt082954
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt047924
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt047924
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0517294
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0494497
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0537833
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0517294
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0494497
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0517294
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0494497
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0527845
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt052508
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0475337
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt07918
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt025996
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0519927
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0527845
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt01
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt07754
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0COMERICA BANK
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine10PO BOX 75000 M/C 3302
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/City0DETROIT
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/State0MI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCode0482753302
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt020235
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt020499
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt034534
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt09580
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt013648
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt013597
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt027001
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.038918
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.065617
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.018502
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.026276
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt00.02719
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt00.057007
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd0false
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt0264
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt0519927
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt0526296
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt0517785
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt0519412
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt0500077
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt0473643
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt047816
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.194592
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt047552
IRS990PF/QualifyingDistriPartXIIGrp/CharitableAssetsAcquisPaidAmt00
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt047816
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt0264
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt047816
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/AtLeast5000InAssetsInd0false
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd0false
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd0true
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd0false
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd0false
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd0false
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine10101 NORTH MAIN STREET
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/City0ANN ARBOR
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/State0MI
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCode048104
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0MI
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine10COMERICA BANK
IRS990PF/StatementsRegardingActyGrp/PhoneNum08774051091
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0true
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt047041
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0SUPPORT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine10MERCY HEALTH PARTNERS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0EXEMPT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine101415 LLEAHY STREET
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/City0MUSKEGON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/State0MI
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCode049444
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt047041
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/AppliedToCurrentYearAmt021732
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt026084
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt025732
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/ExcessDistriCyovToNextYrAmt00
IRS990PF/UndistributedIncomeGrp/ExcessFromCurrentYearAmt00
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt00
IRS990PF/UndistributedIncomeGrp/ExcessFromYear2Amt00
IRS990PF/UndistributedIncomeGrp/ExcessFromYear3Amt00
IRS990PF/UndistributedIncomeGrp/ExcessFromYear4Amt00
IRS990PF/UndistributedIncomeGrp/PriorYear1Yr02011
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt047816
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt00
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt00
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt04000
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt026084
OtherDecreasesSchedule/OtherDecreasesDetail/Amount01161
OtherDecreasesSchedule/OtherDecreasesDetail/Description0DIFFERENCE BETWEEN CASH RECEIPTS AND TAXABLE INCOME
ReturnHeader/BuildTS02015-12-30 17:16:21Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0JACKIE SPARKS WALKER
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0VICE PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum02317390364
ReturnHeader/BusinessOfficerGrp/SignatureDt02014-08-12
ReturnHeader/Filer/BusinessName/BusinessNameLine10HANSEN HANS F TUW
ReturnHeader/Filer/BusinessNameControlTxt0HANS
ReturnHeader/Filer/EIN0386061778
ReturnHeader/Filer/PhoneNum02317390364
ReturnHeader/Filer/USAddress/AddressLine10PO BOX 75000
ReturnHeader/Filer/USAddress/City0DETROIT
ReturnHeader/Filer/USAddress/State0MI
ReturnHeader/Filer/USAddress/ZIPCode0482757874
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine10THOMSON REUTERS TAX & ACCOUNTING
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine106135 TRUST DRIVE SUITE 118
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/City0HOLLAND
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/State0OH
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCode043528
ReturnHeader/PreparerPersonGrp/PhoneNum04198612300
ReturnHeader/PreparerPersonGrp/PreparationDt02014-08-12
ReturnHeader/ReturnTs02014-08-21T08:26:18-06:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02013-08-01
ReturnHeader/TaxPeriodEndDt02014-07-31
ReturnHeader/TaxYr02013

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$494,497
Liabilities
$1
Net assets
$494,497
Revenue
$33,394
Expenses
$55,030
Net income
-$21,636
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
2015XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$4.61$0.00$4.61$0.31$0.64$0.33
2014Detailed filing. Detailed filing data is available for this year.$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