Civic Intelligence

Hans F Hansen T U W

990PF • Fiscal year 2020 • EIN 38-6061778

Aug 01, 2019 to Jul 31, 2020 • Filed on Nov 28, 2020

PO Box 75000Detroit, MI 48275-7874

(616) 752-4730

Siviq Scores

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

Liabilities / Assets

39th percentile

0.00x

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

2020 filings • $500k-$1M nonprofits • Source year 2020

Liabilities / Revenue

39th percentile

0.00x

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

2020 filings • $500k-$1M nonprofits • Source year 2020

Net Margin

92nd percentile

64%

Higher net margin than 92% of similar nonprofits.

2020 filings • $500k-$1M nonprofits • Source year 2020

Top Officer Pay

60th percentile

$7,436

Higher top officer pay than 60% of similar nonprofits.

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

2020 filings • $500k-$1M nonprofits • Source year 2020

Asset Growth

49th percentile

2.7%

Faster asset growth than 49% of similar nonprofits.

2020 filings • $500k-$1M nonprofits • Annualized from 2019 to 2020

Revenue Growth

51st percentile

-2.0%

Faster revenue growth than 51% of similar nonprofits.

2020 filings • $500k-$1M nonprofits • Annualized from 2019 to 2020

Assets

Up

$513,618

Up $13,654 (+2.7%) from 2019

Net Assets

Up

$513,618

Up $13,654 (+2.7%) from 2019

Liabilities

Up

$1

Up $1 from 2019

Revenue

Down

$21,216

Down $434 (-2.0%) from 2019

Expenses

Down

$7,533

Down $25,612 (-77%) from 2019

Net Income

Up

$13,683

Up $25,178 (+219%) from 2019

Historical Trend

Balance Sheet Trend

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

2020

Assets$513,618
Liabilities$1
Net Assets$513,618

Operations Trend

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

2020

Revenue$21,216
Expenses$7,533
Net Income$13,683
Jump To
Filing Snapshot
Filing Period
Aug 1, 2019 to Jul 31, 2020
Signed
Nov 28, 2020
Return Version
2019v5.0
Compensation and Service Providers

Employees

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

Filer

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

Signing Officer

Name
Matthew Cleary
Title
Trust Tax Offic
Phone
6167524730
Signed
2020-11-28

Preparer

Firm
Kpmg Llp
Address
60 E RIO SALADO PKWY SUITE 800, TEMPE, AZ 85281
Preparer
Bradley N Sprong
Phone
8558073423
Raw XML Appendix327 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/BondNm0JANUS HENDERSON FLEXIBLE BOND
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/BondNm1TEMPLETON INTERNATIONAL BOND F
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/BondNm2BAIRD AGGREGATE BOND FUND
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/BondNm3VANGUARD SHORT TERM INVESTMENT
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt053790
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt139318
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt255035
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt326897
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt060674
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt133666
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt259513
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt327965
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt018191
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt112727
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt216089
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt316757
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt479162
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt512358
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt6112330
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt714053
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt019991
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt113558
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt220778
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt311434
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt4108604
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt519044
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt6101324
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt713533
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm0COLUMBIA EMERGING MARKETS FUND
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm1HARDING LOEVNER FDS INC
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm2WCM FOCUSED INTERNATIONAL GROW
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm3NORTHERN SMALL CAP VALUE FD
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm4TIAA-CREF MUT FDS L/C GROW IND
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm5VIRTUS KAR SMALL-CAP GROWTH FU
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm6TIAA-CREF MUT FDS L/C VAL INDE
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm7VICTORY TRIVALENT INTERNATIONA
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt010898
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt09753
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/OtherRevenueDescribedGrp/Desc0OTHER REVENUE
IRS990PF/AnalysisIncomeProducingActyGrp/OtherRevenueDescribedGrp/ExclusionAmt0565
IRS990PF/AnalysisIncomeProducingActyGrp/OtherRevenueDescribedGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt021216
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt021216
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt09753
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt0744
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt06692
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt07436
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DeprecAndDpltnNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DeprecAndDpltnRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt010898
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt010898
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt013683
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt021733
IRS990PF/AnalysisOfRevenueAndExpenses/InterestDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt09753
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt013862
IRS990PF/AnalysisOfRevenueAndExpenses/NetSTCapitalGainAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OthEmplSlrsWgsAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OthEmplSlrsWgsDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OthEmplSlrsWgsNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesNetInvstIncmAmt01
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt01
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeRevAndExpnssAmt0565
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/PensionEmplBnftAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/PensionEmplBnftNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/PrintingAndPubAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/PrintingAndPubNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncmAmt096
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt096
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt0744
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt06789
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt07533
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt020651
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt021216
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt0744
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt06789
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt07533
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingNetInvstIncmAmt00
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt02018-04-18
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt011980
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt03079
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt16674
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt03079
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt015059
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0397.23 TIAA-CREF MUT FDS L/C GROW INDX- INST
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc1CAPITAL GAIN DIVIDENDS
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt02020-06-11
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt09753
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt013683
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt040
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt011
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0513658
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0499964
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0513618
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt025136
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt025136
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt025136
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt025413
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0277
IRS990PF/DistributableAmountGrp/TotalTaxAmt0277
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt019
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EsPenaltyAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt0296
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExtsnRequestIncomeTaxPaidAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0277
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/OverpaymentAmt019
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/RefundAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0277
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0277
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt0296
IRS990PF/FMVAssetsEOYAmt0546995
IRS990PF/Form990PFBalanceSheetsGrp/AcctRcvblEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AcctRcvblEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt0499964
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt0513618
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsBOYAmt0175081
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYAmt0175040
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYFMVAmt0181818
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt0278660
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt0281667
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt0308266
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowFASB117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/OtherRcvblAllwncDbtflAcctAmt00
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt046223
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt056911
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt056911
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0499964
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0513618
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0546995
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0499964
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0513618
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0499964
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0513618
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0515994
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt053644
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0462350
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt07740
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt025413
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0508254
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0515994
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt01
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt07436
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/AdjNetVlNoncharitableAssetsAmt020793
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt020932
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt024163
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt09446
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt0698
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt011368
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt052004
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.040911
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.048833
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.018646
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.001468
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt00.02536
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt00.110246
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd0false
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt0139
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt0508254
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt0494813
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt0506602
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt0475596
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt0448268
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt0471710
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt0744
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.204553
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt0744
IRS990PF/QualifyingDistriPartXIIGrp/CharitableAssetsAcquisPaidAmt00
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt0744
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt00
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt0744
IRS990PF/QualifyingDistriPartXIIGrp/SetAsideCashDistriTestAmt00
IRS990PF/QualifyingDistriPartXIIGrp/SetAsideSuitabilityTestAmt00
IRS990PF/StatementsRegardingActy4720Grp/ActsFailToQlfyAsExceptionsInd0false
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/SubjToTaxRmnrtnExPrchtPymtInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd0false
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd0false
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd0true
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd0false
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd0true
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd0false
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd0false
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd0false
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd0true
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt0411 WEST LAFAYETTE M/C 3420
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0DETROIT
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0MI
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd048226
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0MI
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine1Txt0COMERICA BANK
IRS990PF/StatementsRegardingActyGrp/PhoneNum03132223568
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0true
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
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/AppliedToCurrentYearAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt0744
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt025136
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/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt0744
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt022971
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt00
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt00
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt025136
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt023715
OtherDecreasesSchedule/OtherDecreasesDetail/Amt040
OtherDecreasesSchedule/OtherDecreasesDetail/Desc0RETURN OF CAPITAL PRIOR YEAR ADJ
OtherIncreasesSchedule/OtherIncreasesDetail/Amt011
OtherIncreasesSchedule/OtherIncreasesDetail/Desc0TIMING DIFFERENCE
ReturnHeader/BuildTS02021-04-22 16:20:28Z
ReturnHeader/BusinessOfficerGrp/PersonNm0MATTHEW CLEARY
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUST TAX OFFIC
ReturnHeader/BusinessOfficerGrp/PhoneNum06167524730
ReturnHeader/BusinessOfficerGrp/SignatureDt02020-11-28
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0HANSEN HANS F TUW
ReturnHeader/Filer/BusinessNameControlTxt0HANS
ReturnHeader/Filer/EIN0386061778
ReturnHeader/Filer/PhoneNum06167524730
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 75000
ReturnHeader/Filer/USAddress/CityNm0DETROIT
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MI
ReturnHeader/Filer/USAddress/ZIPCd0482757874
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0F254D76E3EC05F422E9B1F2AEF997908212130F3
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0CB3A3BD7D5C182E9AD63D140370BD18B5BC22597
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0199.206.0.5
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0135565207
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0KPMG LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt060 E RIO SALADO PKWY SUITE 800
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0TEMPE
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0AZ
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd085281
ReturnHeader/PreparerPersonGrp/PhoneNum08558073423
ReturnHeader/PreparerPersonGrp/PreparationDt02020-11-28
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0BRADLEY N SPRONG
ReturnHeader/ReturnTs02020-12-02T11:00:25-06:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02019-08-01
ReturnHeader/TaxPeriodEndDt02020-07-31
ReturnHeader/TaxYr02019

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

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
2020Detailed filing. Detailed filing data is available for this year.$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
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. 2020 filings • $500k-$1M nonprofits