Civic Intelligence

Wendell & Doris Rogers Charitable Foundation

990PF • Fiscal year 2017 • EIN 38-3383862

Jan 01, 2017 to Dec 31, 2017 • Filed on Oct 31, 2018

Organization Profile
500 Woodward Ave No 3500Detroit, MI 48226-3435

(313) 965-8417

Siviq Scores

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

Liabilities / Assets

25th percentile

0.00x

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

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

Liabilities / Revenue

25th percentile

0.00x

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

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

Net Margin

97th percentile

89%

Higher net margin than 97% of similar nonprofits.

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

Top Officer Pay

42nd percentile

$0

Higher top officer pay than 42% of similar nonprofits.

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

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

Asset Growth

71st percentile

10%

Faster asset growth than 71% of similar nonprofits.

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

Revenue Growth

1st percentile

-86%

Faster revenue growth than 1% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets25th percentile

Assets

Up

$1,084,167

Up $102,053 (+10%) from 2016

Net Assets

Up

$1,084,167

Up $102,053 (+10%) from 2016

Liabilities

Flat

$0

Flat from 2016

Revenue And Expenses
Liabilities / Revenue25th percentileNet Margin97th percentile

Revenue

Down

$129,268

Down $813,379 (-86%) from 2016

Expenses

Down

$14,338

Down $591,392 (-98%) from 2016

Net Income

Down

$114,930

Down $221,987 (-66%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth71st percentile

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

$8.0M$6.0M$4.0M$2.0M$0Assets 2010: $132,206Liabilities 2010: $0Net Assets 2010: $132,2062010Assets 2011: $101,649Liabilities 2011: $0Net Assets 2011: $101,6492011Assets 2012: $112,919Liabilities 2012: $0Net Assets 2012: $112,9192012Assets 2013: $890,230Liabilities 2013: $1Net Assets 2013: $890,2302013Assets 2014: $720,807Liabilities 2014: $600Net Assets 2014: $720,2072014Assets 2016: $982,114Liabilities 2016: $0Net Assets 2016: $982,1142016Assets 2017: $1,084,167Liabilities 2017: $0Net Assets 2017: $1,084,1672017Assets 2018: $2,081,933Liabilities 2018: $0Net Assets 2018: $2,081,9332018Assets 2019: $7,100,357Liabilities 2019: $1Net Assets 2019: $7,100,3572019Assets 2020: $7,548,296Liabilities 2020: $1Net Assets 2020: $7,548,2962020Assets 2021: $7,562,069Liabilities 2021: $1Net Assets 2021: $7,562,0692021Assets 2022: $6,835,748Liabilities 2022: $1Net Assets 2022: $6,835,7482022Assets 2023: $6,770,102Liabilities 2023: $1Net Assets 2023: $6,770,1022023Assets 2024: $6,803,470Liabilities 2024: $0Net Assets 2024: $6,803,4702024

Highlighted filing

2017

Assets$1,084,167
Liabilities$0
Net Assets$1,084,167
Open 2017 Filing

Operations Trend

Revenue Growth1st percentile

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

$6.0M$4.0M$2.0M$0-$2.0MExpenses 2010: $31,7472010Expenses 2011: $43,6542011Expenses 2012: $4,5632012Revenue 2013: $859,897Expenses 2013: $35,402Net Income 2013: $824,4952013Revenue 2014: $44,604Expenses 2014: $214,627Net Income 2014: -$170,0232014Revenue 2016: $942,647Expenses 2016: $605,730Net Income 2016: $336,9172016Revenue 2017: $129,268Expenses 2017: $14,338Net Income 2017: $114,9302017Revenue 2018: $1,088,177Expenses 2018: $90,411Net Income 2018: $997,7662018Revenue 2019: $5,587,772Expenses 2019: $569,348Net Income 2019: $5,018,4242019Revenue 2020: $968,066Expenses 2020: $520,127Net Income 2020: $447,9392020Revenue 2021: $567,990Expenses 2021: $554,217Net Income 2021: $13,7732021Revenue 2022: -$210,190Expenses 2022: $516,131Net Income 2022: -$726,3212022Revenue 2023: $470,929Expenses 2023: $533,777Net Income 2023: -$62,8482023Revenue 2024: $588,902Expenses 2024: $558,332Net Income 2024: $30,5702024

Highlighted filing

2017

Revenue$129,268
Expenses$14,338
Net Income$114,930
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Oct 31, 2018
Return Version
2017v2.3
Compensation and Service Providers
Top Officer Pay42nd percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
DONALD CLAYTONPresident-$0--
JOHN E BERGTreasurer-$0--
J THOMAS MACFARLANESecretary-$0--
Filing and Contact Details

Filer

Filer Name
Wendell & Doris Rogers Charitable
EIN
38-3383862
Phone
3139658417
Address
500 WOODWARD AVE NO 3500, DETROIT, MI 48226-3435

Signing Officer

Name
J Thomas Macfarlane
Title
Secretary
Phone
3139658417
Signed
2018-10-31
Discuss with paid preparer
Yes

Preparer

Firm
Clark Hill Plc
Address
500 WOODWARD AVE SUITE 3500, DETROIT, MI 48226
Preparer
J Thomas Macfarlane
Phone
3139658300
Raw XML Appendix346 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/BondNm0CORPORATE BONDS
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt0101633
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt0100451
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt0269376
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt0344427
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm0EQUITIES
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt0462543
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt1228990
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt0MUTUAL FUNDS
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt1OTHER ASSETS
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt0472075
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt1253674
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd0AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd1AT COST
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt035997
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt093261
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionAmt010
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt0129268
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/RelatedOrExemptFunctionIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/UnrelatedBusinessTaxblIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt0129268
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt093261
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt035997
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt035997
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0114930
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt01472
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavNetInvstIncmAmt010
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavRevAndExpnssAmt010
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesDsbrsChrtblAmt02716
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesNetInvstIncmAmt02717
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesRevAndExpnssAmt05433
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt093261
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt0121262
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesNetInvstIncmAmt010
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt010
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesDsbrsChrtblAmt03616
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesNetInvstIncmAmt03617
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesRevAndExpnssAmt07233
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncmAmt01662
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt01662
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt06332
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt08006
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt014338
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt0129268
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt0129268
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt06332
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt08006
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt014338
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt094206
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt1-2417
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt21472
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt094206
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt1-2417
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt21472
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt01472
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd1P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd2P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0CHARLES SCHWAB LONG TERM SALES
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc1CHARLES SCHWAB SHORT TERM SALES
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc2CAPITAL GAINS DIVIDENDS
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt02017-12-31
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt12017-12-31
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt093261
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0114930
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt012877
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt01097044
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0982114
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt01084167
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt052742
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt052742
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt052742
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt055167
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt02425
IRS990PF/DistributableAmountGrp/TotalTaxAmt02425
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt0132
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/BackupWithholdingWithheldAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EsPenaltyAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt02557
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExtsnRequestIncomeTaxPaidAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt02425
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/OverpaymentAmt0132
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/RefundAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt02425
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt02425
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt02557
IRS990PF/FMVAssetsEOYAmt01192252
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt0984766
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt01099696
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsBOYAmt0240318
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYAmt0101633
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYFMVAmt0100451
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt0332532
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt0269376
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt0344427
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsBOYAmt0373632
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYAmt0691533
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt0725749
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt0-2652
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt0-15529
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt035632
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt021625
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt021625
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0982114
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt01084167
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt01192252
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0982114
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt01084167
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0982114
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt01084167
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt01120138
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt013081
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt01107057
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt016802
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt055167
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt01103336
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt01120138
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt11.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt21.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0DONALD CLAYTON
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm1JOHN E BERG
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm2J THOMAS MACFARLANE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0PRESIDENT
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt1TREASURER
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt2SECRETARY
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt02000 TOWN CENTER STE 1825
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt1500 WOODWARD AVE STE 3500
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt2151 S OLD WOODWARD AVE STE 200
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0SOUTHFIELD
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm1DETROIT
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm2BIRMINGHAM
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0MI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd1MI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd2MI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd048075
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd148226
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd248009
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt0263524
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt0264737
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt0599757
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt0199453
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt0199554
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt030000
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt00
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.238843
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.585502
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.295623
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.243278
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt00.069811
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt00.000000
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd00
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt01213
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt01103336
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt01024347
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt0674687
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt0820272
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt0429730
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt0163765
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt06332
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt01.194214
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt06332
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt06332
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt00
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt06332
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd00
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd00
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd00
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd00
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd00
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd00
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd00
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd00
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd00
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd00
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd00
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd00
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd00
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd00
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd01
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd00
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd01
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd00
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd00
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd00
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd01
IRS990PF/StatementsRegardingActyGrp/IndividualWithBooksNm0JOHN BERG
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd00
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt0500 WOODWARD AVE SUITE 3500
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0DETROIT
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0MI
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd0482263435
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd00
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd00
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd00
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0MI
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd00
IRS990PF/StatementsRegardingActyGrp/PhoneNum03139658300
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd00
IRS990PF/StatementsRegardingActyGrp/Section4955ManagersTaxAmt00
IRS990PF/StatementsRegardingActyGrp/Section4955OrganizationTaxAmt00
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd01
IRS990PF/StatementsRegardingActyGrp/TaxReimbursedAmt00
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd00
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SumOfProgramRelatedInvstGrp/TotalAmt00
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt00
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/LoansOrLoanGuaranteesInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PerformanceOfServicesEtcInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PurchaseOfAssetsNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/ReimbursementArrangementsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RelationshipsNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RentalOfFacilitiesOthAssetsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SalesOrExchangesOfAssetsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SharingOfFacilitiesEtcInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd00
IRS990PF/UndistributedIncomeGrp/AppliedToCurrentYearAmt06332
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt00
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt052742
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt046410
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr1Amt0549026
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr2Amt0166813
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr3Amt0159432
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr4Amt09981
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt046410
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt0838842
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt0549026
IRS990PF/UndistributedIncomeGrp/ExcessFromYear2Amt0166813
IRS990PF/UndistributedIncomeGrp/ExcessFromYear3Amt0123003
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt06332
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt0838842
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt0885252
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt00
LegalFeesSchedule/LegalFeesGrp/CategoryTxt0CLARK HILL PLC
LegalFeesSchedule/LegalFeesGrp/DisbursementsCharitablePrpsAmt02716
LegalFeesSchedule/LegalFeesGrp/LegalFeesAmt05433
LegalFeesSchedule/LegalFeesGrp/NetInvestmentIncomeAmt02717
OtherDecreasesSchedule/OtherDecreasesDetail/Amt012877
OtherDecreasesSchedule/OtherDecreasesDetail/Desc0BOOK TO TAX ADJUSTMENT
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0ADR FEE
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt010
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt010
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/Amt07233
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/CategoryTxt0CHARLES SCHWAB
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/DisbursementsCharitablePrpsAmt03616
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/NetInvestmentIncomeAmt03617
TaxesSchedule/TaxesDetail/Amt01662
TaxesSchedule/TaxesDetail/CategoryTxt0TAXES PAID NET OF REFUNDS
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt00
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt01662
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0J THOMAS MACFARLANE
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0SECRETARY
ReturnHeader/BusinessOfficerGrp/PhoneNum03139658417
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-10-31
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0WENDELL & DORIS ROGERS CHARITABLE
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0WEND
ReturnHeader/Filer/EIN0383383862
ReturnHeader/Filer/PhoneNum03139658417
ReturnHeader/Filer/USAddress/AddressLine1Txt0500 WOODWARD AVE NO 3500
ReturnHeader/Filer/USAddress/CityNm0DETROIT
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MI
ReturnHeader/Filer/USAddress/ZIPCd0482263435
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId07FEE9562B197BB9C8DCC8337254487FB6A0F6D83
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId07FEE9562B197BB9C8DCC8337254487FB6A0F6D83
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0206.181.8.130
ReturnHeader/FilingSecurityInformation/IPDt02018-10-31
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0ED
ReturnHeader/FilingSecurityInformation/IPTm015:55:20
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0380425840
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0CLARK HILL PLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0500 WOODWARD AVE SUITE 3500
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0DETROIT
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MI
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd048226
ReturnHeader/PreparerPersonGrp/PhoneNum03139658300
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0J THOMAS MACFARLANE
ReturnHeader/ReturnTs02018-11-07T09:01:54-06:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02017-01-01
ReturnHeader/TaxPeriodEndDt02017-12-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$1,084,167
Liabilities
$0
Net assets
$1,084,167
Revenue
$129,268
Expenses
$14,338
Net income
$114,930
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$6.80$0.00$6.80$0.59$0.56$0.03
2023XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$6.77$0.00$6.77$0.47$0.53$0.06
2022Detailed filing. Detailed filing data is available for this year.$6.84$0.00$6.84$0.21$0.52$0.73
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$7.56$0.00$7.56$0.57$0.55$0.01
2020Detailed filing. Detailed filing data is available for this year.$7.55$0.00$7.55$0.97$0.52$0.45
2019Detailed filing. Detailed filing data is available for this year.$7.10$0.00$7.10$5.59$0.57$5.02
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.08$0.00$2.08$1.09$0.09$1.00
2017Detailed filing. Detailed filing data is available for this year.$1.08$0.00$1.08$0.13$0.01$0.11
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.98$0.00$0.98$0.94$0.61$0.34
2014Detailed filing. Detailed filing data is available for this year.$0.72$0.00$0.72$0.04$0.21$0.17
2013XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.89$0.00$0.89$0.86$0.04$0.82
2012Detailed filing. Detailed filing data is available for this year.$0.11$0.00$0.11$0.00
2011Detailed filing. Detailed filing data is available for this year.$0.10$0.00$0.10$0.04
2010Detailed filing. Detailed filing data is available for this year.$0.13$0.00$0.13$0.03