Civic Intelligence

Alex Barba Tr UW

990PF • Fiscal year 2017 • EIN 38-6061007

Jan 01, 2017 to Dec 31, 2017 • Filed on Apr 25, 2018

Organization Profile
PO Box 75000Detroit, MI 48275-7874

(734) 930-2405

Siviq Scores

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

Liabilities / Assets

59th percentile

0.00x

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

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

Liabilities / Revenue

59th percentile

0.00x

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

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

Net Margin

6th percentile

-108%

Higher net margin than 6% of similar nonprofits.

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

Top Officer Pay

82nd percentile

$7,173

Higher top officer pay than 82% of similar nonprofits.

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

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

Asset Growth

33rd percentile

-5.9%

Faster asset growth than 33% of similar nonprofits.

2017 filings • <$500k nonprofits • Annualized from 2016 to 2017

Revenue Growth

14th percentile

-36%

Faster revenue growth than 14% of similar nonprofits.

2017 filings • <$500k nonprofits • Annualized from 2016 to 2017

Balance Sheet
Liabilities / Assets59th percentile

Assets

Down

$389,636

Down $24,428 (-5.9%) from 2016

Net Assets

Down

$389,636

Down $24,428 (-5.9%) from 2016

Liabilities

Flat

$0

Flat from 2016

Revenue And Expenses
Liabilities / Revenue59th percentileNet Margin6th percentile

Revenue

Down

$21,123

Down $11,656 (-36%) from 2016

Expenses

Down

$44,037

Down $14,620 (-25%) from 2016

Net Income

Up

-$22,914

Up $2,964 (+11%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth33rd percentile

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

$600K$400K$200K$0Assets 2010: $444,890Liabilities 2010: $0Net Assets 2010: $444,8902010Assets 2011: $489,359Liabilities 2011: $12011Assets 2012: $470,958Liabilities 2012: $12012Assets 2013: $456,518Liabilities 2013: $1Net Assets 2013: $456,5182013Assets 2014: $431,755Liabilities 2014: $12014Assets 2015: $439,260Liabilities 2015: $02015Assets 2016: $414,064Liabilities 2016: $0Net Assets 2016: $414,0642016Assets 2017: $389,636Liabilities 2017: $0Net Assets 2017: $389,6362017Assets 2018: $455,141Liabilities 2018: $0Net Assets 2018: $455,1412018Assets 2019: $438,893Liabilities 2019: $1Net Assets 2019: $438,8932019Assets 2020: $441,659Liabilities 2020: $1Net Assets 2020: $441,6592020Assets 2021: $446,280Liabilities 2021: $1Net Assets 2021: $446,2802021Assets 2022: $427,538Liabilities 2022: $12022Assets 2023: $410,985Liabilities 2023: $12023Assets 2024: $399,538Liabilities 2024: $0Net Assets 2024: $399,5382024

Highlighted filing

2017

Assets$389,636
Liabilities$0
Net Assets$389,636
Open 2017 Filing

Operations Trend

Revenue Growth14th percentile

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

$150K$100K$50K$0-$50KExpenses 2010: $21,0872010Revenue 2011: $66,248Expenses 2011: $37,344Net Income 2011: $28,9042011Revenue 2012: $14,801Expenses 2012: $37,134Net Income 2012: -$22,3332012Revenue 2013: $16,225Expenses 2013: $31,496Net Income 2013: -$15,2712013Revenue 2014: $10,062Expenses 2014: $35,487Net Income 2014: -$25,4252014Revenue 2015: $16,196Expenses 2015: $8,053Net Income 2015: $8,1432015Revenue 2016: $32,779Expenses 2016: $58,657Net Income 2016: -$25,8782016Revenue 2017: $21,123Expenses 2017: $44,037Net Income 2017: -$22,9142017Revenue 2018: $105,416Expenses 2018: $35,688Net Income 2018: $69,7282018Revenue 2019: $25,296Expenses 2019: $34,871Net Income 2019: -$9,5752019Revenue 2020: $17,084Expenses 2020: $26,945Net Income 2020: -$9,8612020Revenue 2021: $35,434Expenses 2021: $31,861Net Income 2021: $3,5732021Revenue 2022: $19,032Expenses 2022: $37,715Net Income 2022: -$18,6832022Revenue 2023: $19,264Expenses 2023: $35,830Net Income 2023: -$16,5662023Revenue 2024: $27,235Expenses 2024: $36,910Net Income 2024: -$9,6752024

Highlighted filing

2017

Revenue$21,123
Expenses$44,037
Net Income-$22,914
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Apr 25, 2018
Return Version
2017v2.2
Compensation and Service Providers
Top Officer Pay82nd percentile

Employees

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

Filer

Filer Name
Alex Barba Tuw
EIN
38-6061007
Phone
7349302405
Address
PO BOX 75000, DETROIT, MI 48275-7874

Signing Officer

Name
Jacquelyn Sparks-walker
Title
Vice President
Phone
7349302405
Signed
2018-04-25

Preparer

Firm
Kpmg Llp
Address
2020 N CENTRAL AVE STE 700, PHOENIX, AZ 85004
Preparer
Christopher L Gillam
Phone
8558073423
Raw XML Appendix288 raw XML fields

This appendix keeps the raw XML leaves available for debugging and edge-case review. The human report above is the primary experience.

Path#Value
AccountingFeesSchedule/AccountingFeesDetail/Amt0900
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0TAX PREPARATION FEE (NON-ALLOC
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt0450
AccountingFeesSchedule/AccountingFeesDetail/NetInvestmentIncomeAmt0450
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt0408979
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt0CHARITABLE TOTAL RETURN INVEST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt0501583
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd0AT COST
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt011032
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt010091
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt021123
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt021123
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesChrtblPrpsAmt0450
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncmAmt0450
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt0900
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt010091
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt07173
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt07173
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt035114
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt035115
IRS990PF/AnalysisOfRevenueAndExpenses/DeprecAndDpltnNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DeprecAndDpltnRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt011032
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt011032
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-22914
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt010091
IRS990PF/AnalysisOfRevenueAndExpenses/InterestDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt010091
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt013500
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/TaxesRevAndExpnssAmt0849
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt035564
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt07623
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt044037
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt021123
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt021123
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt0450
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt07623
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt08922
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingNetInvstIncmAmt00
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt010091
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-22914
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt01514
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0391150
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0414064
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0389636
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt023806
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt023806
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt023806
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt024076
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0270
IRS990PF/DistributableAmountGrp/TotalTaxAmt0270
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt0242
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EsPenaltyAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt0512
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExtsnRequestIncomeTaxPaidAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0270
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/OverpaymentAmt0242
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/RefundAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0270
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0270
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt0512
IRS990PF/FMVAssetsEOYAmt0482240
IRS990PF/Form990PFBalanceSheetsGrp/AcctRcvblEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AcctRcvblEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt0414064
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt0389636
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsBOYAmt0414350
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYAmt0408979
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt0501583
IRS990PF/Form990PFBalanceSheetsGrp/OtherRcvblAllwncDbtflAcctAmt00
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt0-286
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt0-19343
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt0-19343
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0414064
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0389636
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0482240
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0414064
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0389636
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0414064
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0389636
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0488844
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt05128
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0483716
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt07333
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt024076
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0481511
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0488844
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt01
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt07173
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0COMERICA BANK
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt0PO BOX 75000 M/C 9413
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0DETROIT
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0MI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd0482759413
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization4947a1TrtdPFInd0X
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt035564
IRS990PF/QualifyingDistriPartXIIGrp/CharitableAssetsAcquisPaidAmt00
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt035564
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt00
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt035564
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/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/NECTFilingInLieuOFForm1041Ind0X
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/ContributingManagerNm0NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt017557
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt117557
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0SCHOLARSHIPS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1SCHOLARSHIP
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt0UNIVERSITY OF DETROIT MERCY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt1WAYNE STATE UNIVERSITY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine2Txt0FUND OFFICE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0EXEMPT UNIVERSITY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt1EXEMPT UNIVERSITY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt1NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt04001 W MCNICHOLS ROAD
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt15475 WOODWARD AVE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0DETROIT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm1DETROIT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0MI
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd1MI
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd0482213038
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd148202
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/ShareholderManagerNm0NONE
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt035114
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/AppliedToCurrentYearAmt020037
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt015527
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt023806
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/QualifyingDistributionsAmt035564
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt00
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt00
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt03769
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt015527
OtherDecreasesSchedule/OtherDecreasesDetail/Amt01513
OtherDecreasesSchedule/OtherDecreasesDetail/Amt11
OtherDecreasesSchedule/OtherDecreasesDetail/Desc0DIFFERENCE BETWEEN RECEIPTS AND TAXABLE INCOME
OtherDecreasesSchedule/OtherDecreasesDetail/Desc1ROUNDING
TaxesSchedule/TaxesDetail/Amt0337
TaxesSchedule/TaxesDetail/Amt1512
TaxesSchedule/TaxesDetail/CategoryTxt0FEDERAL TAX PAYMENT - PRIOR YE
TaxesSchedule/TaxesDetail/CategoryTxt1FEDERAL ESTIMATES - INCOME
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt00
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt10
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt00
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt10
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/PersonNm0JACQUELYN SPARKS-WALKER
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0VICE PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum07349302405
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-04-25
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0ALEX BARBA TUW
ReturnHeader/Filer/BusinessNameControlTxt0BARB
ReturnHeader/Filer/EIN0386061007
ReturnHeader/Filer/PhoneNum07349302405
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 75000
ReturnHeader/Filer/USAddress/CityNm0DETROIT
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MI
ReturnHeader/Filer/USAddress/ZIPCd0482757874
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0A1855B3351E2246CB82CD120E042FD23ABFBC88E
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0480FC8D519018E79AD7902E4D7F150C63246CC1C
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0199.207.253.96
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0135565207
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/PreparationDt02018-04-25
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0CHRISTOPHER L GILLAM
ReturnHeader/ReturnTs02018-04-29T11:00:32-05:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02017-01-01
ReturnHeader/TaxPeriodEndDt02017-12-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$389,636
Liabilities
$0
Net assets
$389,636
Revenue
$21,123
Expenses
$44,037
Net income
-$22,914
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$4.00$0.00$4.00$0.27$0.37$0.10
2023XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$4.11$0.00$0.19$0.36$0.17
2022XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$4.28$0.00$0.19$0.38$0.19
2021Detailed filing. Detailed filing data is available for this year.$4.46$0.00$4.46$0.35$0.32$0.04
2020Detailed filing. Detailed filing data is available for this year.$4.42$0.00$4.42$0.17$0.27$0.10
2019Detailed filing. Detailed filing data is available for this year.$4.39$0.00$4.39$0.25$0.35$0.10
2018Detailed filing. Detailed filing data is available for this year.$4.55$0.00$4.55$1.05$0.36$0.70
2017Detailed filing. Detailed filing data is available for this year.$3.90$0.00$3.90$0.21$0.44$0.23
2016Detailed filing. Detailed filing data is available for this year.$4.14$0.00$4.14$0.33$0.59$0.26
2015Summary only. Only limited summary data is available for this year.$4.39$0.00$0.16$0.08$0.08
2014XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$4.32$0.00$0.10$0.35$0.25
2013Import issue. A filing source exists for this year, but detailed import did not complete cleanly.$4.57$0.00$4.57$0.16$0.31$0.15
2012Summary only. Only limited summary data is available for this year.$4.71$0.00$0.15$0.37$0.22
2011Summary only. Only limited summary data is available for this year.$4.89$0.00$0.66$0.37$0.29
2010Detailed filing. Detailed filing data is available for this year.$4.45$0.00$4.45$0.21