APTIV FOUNDATION INC: Form 990PF, tax year 2020
View the entire original 990 at ProPublica ↗
- Organization
- APTIV FOUNDATION INC (EIN 38-3442971)
- Tax period
- 2020-01-01 to 2020-12-31
- Filed
- 2021-09-30
- IRS object ID
- 202132739349100718
- Schema version
- 2020v4.1
- Source
- Download XML · Original 990 at ProPublica
Every field in the e-filed return. Faint text is the IRS element name, for citing.
- Return header
- Form 990-PF
- Accounting Fees Schedule
- Investments Corp Bonds Schedule
- Investments Corp Stock Schedule
- Investments Other Schedule2
- Other Expenses Schedule
- Other Increases Schedule
- Other Professional Fees Schedule
- Taxes Schedule
Return header ReturnHeader
| Field | Value | IRS element (for citing) |
|---|---|---|
| Return | 2021-09-30T14:19:46-05:00 | ReturnTs |
| Tax Period End | 2020-12-31 | TaxPeriodEndDt |
Preparer Firm PreparerFirmGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Preparer Firm EIN | 382029668 | PreparerFirmEIN |
Preparer Firm Name PreparerFirmName
| Field | Value | IRS element (for citing) |
|---|---|---|
| Business Name Line1 | GEORGE JOHNSON & COMPANY | BusinessNameLine1Txt |
Preparer US Address PreparerUSAddress
| Field | Value | IRS element (for citing) |
|---|---|---|
| Address Line1 | 1200 BUHL BUILDING 535 GRISWOLD | AddressLine1Txt |
| City | DETROIT | CityNm |
| State Abbreviation | MI | StateAbbreviationCd |
| ZIP | 482263689 | ZIPCd |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Return Type | 990PF | ReturnTypeCd |
| Tax Period Begin | 2020-01-01 | TaxPeriodBeginDt |
Filer Filer
| Field | Value | IRS element (for citing) |
|---|---|---|
| EIN | 383442971 | EIN |
Business Name BusinessName
| Field | Value | IRS element (for citing) |
|---|---|---|
| Business Name Line1 | APTIV FOUNDATION INC | BusinessNameLine1Txt |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Business Name Control | APTI | BusinessNameControlTxt |
| Phone | 2488132531 | PhoneNum |
US Address USAddress
| Field | Value | IRS element (for citing) |
|---|---|---|
| Address Line1 | PO BOX 5086 | AddressLine1Txt |
| City | TROY | CityNm |
| State Abbreviation | MI | StateAbbreviationCd |
| ZIP | 480985086 | ZIPCd |
Business Officer BusinessOfficerGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Person | RACHELLE VALDEZ | PersonNm |
| Person Title | PRESIDENT | PersonTitleTxt |
| Phone | 2488132531 | PhoneNum |
| Signature | 2021-09-30 | SignatureDt |
| Discuss With Paid Preparer | Yes (1) | DiscussWithPaidPreparerInd |
Signing Officer SigningOfficerGrp
Person Full Name PersonFullName
| Field | Value | IRS element (for citing) |
|---|---|---|
| Person First | RACHELLE | PersonFirstNm |
| Person Last | VALDEZ | PersonLastNm |
| Field | Value | IRS element (for citing) |
|---|---|---|
| SSN | 999009999 | SSN |
Preparer Person PreparerPersonGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Preparer Person | MICHAEL R NICHOLAS | PreparerPersonNm |
| PTIN | P00966144 | PTIN |
| Phone | 3139652655 | PhoneNum |
Additional Filer Information AdditionalFilerInformation
Trusted Customer TrustedCustomerGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Trusted Customer | 2 | TrustedCustomerCd |
| Authentication Assurance Level | AAL1 | AuthenticationAssuranceLevelCd |
| Identity Assurance Level | IAL1 | IdentityAssuranceLevelCd |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Tax | 2020 | TaxYr |
| Build TS | 2022-09-23 18:48:47Z | BuildTS |
Form 990-PF IRS990PF
| Field | Value | IRS element (for citing) |
|---|---|---|
| Organization501c3 Exempt PF | Yes (X) | Organization501c3ExemptPFInd |
| FMV Assets EOY | $17,418,363 | FMVAssetsEOYAmt |
| Method Of Accounting Accrual | Yes (X) | MethodOfAccountingAccrualInd |
Analysis Of Revenue And Expenses AnalysisOfRevenueAndExpenses
| Field | Value | IRS element (for citing) |
|---|---|---|
| Schedule B Not Required | Yes (X) | ScheduleBNotRequiredInd |
| Interest On Sav Rev And Expnss | $166,705 | InterestOnSavRevAndExpnssAmt |
| Interest On Sav Net Invst Incm | $166,705 | InterestOnSavNetInvstIncmAmt |
| Dividends Rev And Expnss | $191,278 | DividendsRevAndExpnssAmt |
| Dividends Net Invst Incm | $191,278 | DividendsNetInvstIncmAmt |
| Net Gain Sale Ast Rev And Expnss | $63,585 | NetGainSaleAstRevAndExpnssAmt |
| Gross Sales Price | $2,484,218 | GrossSalesPriceAmt |
| Cap Gain Net Incm Net Invst Incm | $63,585 | CapGainNetIncmNetInvstIncmAmt |
| Total Rev And Expnss | $421,568 | TotalRevAndExpnssAmt |
| Total Net Invst Incm | $421,568 | TotalNetInvstIncmAmt |
| Comp Ofcr Dir Trst Rev And Expnss | $0 | CompOfcrDirTrstRevAndExpnssAmt |
| Comp Ofcr Dir Trst Net Invst Incm | $0 | CompOfcrDirTrstNetInvstIncmAmt |
| Comp Ofcr Dir Trst Dsbrs Chrtbl | $0 | CompOfcrDirTrstDsbrsChrtblAmt |
| Accounting Fees Rev And Expnss | $14,950 | AccountingFeesRevAndExpnssAmt |
| Accounting Fees Net Invst Incm | $7,475 | AccountingFeesNetInvstIncmAmt |
| Accounting Fees Chrtbl Prps | $7,475 | AccountingFeesChrtblPrpsAmt |
| Other Prof Fees Rev And Expnss | $48,313 | OtherProfFeesRevAndExpnssAmt |
| Other Prof Fees Net Invst Incm | $48,313 | OtherProfFeesNetInvstIncmAmt |
| Other Prof Fees Dsbrs Chrtbl | $0 | OtherProfFeesDsbrsChrtblAmt |
| Taxes Rev And Expnss | $33,175 | TaxesRevAndExpnssAmt |
| Taxes Net Invst Incm | $0 | TaxesNetInvstIncmAmt |
| Taxes Dsbrs Chrtbl | $0 | TaxesDsbrsChrtblAmt |
| Other Expenses Rev And Expnss | $25 | OtherExpensesRevAndExpnssAmt |
| Other Expenses Net Invst Incm | $25 | OtherExpensesNetInvstIncmAmt |
| Other Expenses Dsbrs Chrtbl | $0 | OtherExpensesDsbrsChrtblAmt |
| Tot Opr Expenses Rev And Expnss | $96,463 | TotOprExpensesRevAndExpnssAmt |
| Tot Opr Expenses Net Invst Incm | $55,813 | TotOprExpensesNetInvstIncmAmt |
| Tot Opr Expenses Dsbrs Chrtbl | $7,475 | TotOprExpensesDsbrsChrtblAmt |
| Contri Paid Rev And Expnss | $1,064,000 | ContriPaidRevAndExpnssAmt |
| Contri Paid Dsbrs Chrtbl | $1,064,000 | ContriPaidDsbrsChrtblAmt |
| Total Expenses Rev And Expnss | $1,160,463 | TotalExpensesRevAndExpnssAmt |
| Total Expenses Net Invst Incm | $55,813 | TotalExpensesNetInvstIncmAmt |
| Total Expenses Dsbrs Chrtbl | $1,071,475 | TotalExpensesDsbrsChrtblAmt |
| Excess Revenue Over Expenses | -$738,895 | ExcessRevenueOverExpensesAmt |
| Net Investment Income | $365,755 | NetInvestmentIncomeAmt |
Form990 PF Balance Sheets Form990PFBalanceSheetsGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Sav And Temp Cash Invst BOY | $430,730 | SavAndTempCashInvstBOYAmt |
| Sav And Temp Cash Invst EOY | $574,243 | SavAndTempCashInvstEOYAmt |
| Sav And Temp Cash Invst EOYFMV | $574,243 | SavAndTempCashInvstEOYFMVAmt |
| Acct Rcvbl | $25,169 | AcctRcvblAmt |
| Acct Rcvbl BOY | $6,667 | AcctRcvblBOYAmt |
| Acct Rcvbl EOY | $25,169 | AcctRcvblEOYAmt |
| Acct Rcvbl EOYFMV | $25,169 | AcctRcvblEOYFMVAmt |
| Prepaid Expenses BOY | $5,666 | PrepaidExpensesBOYAmt |
| Prepaid Expenses EOY | $650 | PrepaidExpensesEOYAmt |
| Prepaid Expenses EOYFMV | $650 | PrepaidExpensesEOYFMVAmt |
| Corporate Stock BOY | $8,565,384 | CorporateStockBOYAmt |
| Corporate Stock EOY | $9,138,044 | CorporateStockEOYAmt |
| Corporate Stock EOYFMV | $9,138,044 | CorporateStockEOYFMVAmt |
| Corporate Bonds BOY | $526,430 | CorporateBondsBOYAmt |
| Corporate Bonds EOY | $576,467 | CorporateBondsEOYAmt |
| Corporate Bonds EOYFMV | $576,467 | CorporateBondsEOYFMVAmt |
| Other Investments BOY | $7,231,680 | OtherInvestmentsBOYAmt |
| Other Investments EOY | $7,103,790 | OtherInvestmentsEOYAmt |
| Other Investments EOYFMV | $7,103,790 | OtherInvestmentsEOYFMVAmt |
| Total Assets BOY | $16,766,557 | TotalAssetsBOYAmt |
| Total Assets EOY | $17,418,363 | TotalAssetsEOYAmt |
| Total Assets EOYFMV | $17,418,363 | TotalAssetsEOYFMVAmt |
| Accounts Payable BOY | $34,201 | AccountsPayableBOYAmt |
| Accounts Payable EOY | $82,487 | AccountsPayableEOYAmt |
| Total Liabilities BOY | $34,201 | TotalLiabilitiesBOYAmt |
| Total Liabilities EOY | $82,487 | TotalLiabilitiesEOYAmt |
| Organization Follows FASB117 | Yes (X) | OrganizationFollowsFASB117Ind |
| No Donor Rstr Net Assests BOY | $16,732,356 | NoDonorRstrNetAssestsBOYAmt |
| No Donor Rstr Net Assests EOY | $17,335,876 | NoDonorRstrNetAssestsEOYAmt |
| Tot Net Ast Or Fund Balances BOY | $16,732,356 | TotNetAstOrFundBalancesBOYAmt |
| Tot Net Ast Or Fund Balances EOY | $17,335,876 | TotNetAstOrFundBalancesEOYAmt |
| Total Liabilities Net Ast BOY | $16,766,557 | TotalLiabilitiesNetAstBOYAmt |
| Total Liabilities Net Ast EOY | $17,418,363 | TotalLiabilitiesNetAstEOYAmt |
Chg In Net Assets Fund Balances ChgInNetAssetsFundBalancesGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Tot Net Ast Or Fund Balances BOY | $16,732,356 | TotNetAstOrFundBalancesBOYAmt |
| Excess Revenue Over Expenses | -$738,895 | ExcessRevenueOverExpensesAmt |
| Other Increases | $1,342,415 | OtherIncreasesAmt |
| Subtotal | $17,335,876 | SubtotalAmt |
| Other Decreases | $0 | OtherDecreasesAmt |
| Tot Net Ast Or Fund Balances EOY | $17,335,876 | TotNetAstOrFundBalancesEOYAmt |
Cap Gains Loss Tx Invst Incm Detail CapGainsLossTxInvstIncmDetail
Cap Gains Loss Tx Invst Incm CapGainsLossTxInvstIncmGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Property | PUBLICLY-TRADED SECURITIES | PropertyDesc |
| How Acquired | P | HowAcquiredCd |
| Gross Sales Price | $2,484,218 | GrossSalesPriceAmt |
| Cost Or Other Basis | $2,420,633 | CostOrOtherBasisAmt |
| Gain Or Loss | $63,585 | GainOrLossAmt |
| Gains Minus Excess Or Losses | $63,585 | GainsMinusExcessOrLossesAmt |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Capital Gain Net Income | $63,585 | CapitalGainNetIncomeAmt |
Excise Tax Based On Invst Incm ExciseTaxBasedOnInvstIncmGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Investment Income Excise Tax | $5,084 | InvestmentIncomeExciseTaxAmt |
| Tax Under Section511 | $0 | TaxUnderSection511Amt |
| Subtotal | $5,084 | SubtotalAmt |
| Subtitle A Tax | $0 | SubtitleATaxAmt |
| Tax Based On Investment Income | $5,084 | TaxBasedOnInvestmentIncomeAmt |
| Estimated Plus Ovpmt Incm Tx | $5,812 | EstimatedPlusOvpmtIncmTxAmt |
| Exempt Frgn Org Tax Wthld At Srce | $0 | ExemptFrgnOrgTaxWthldAtSrceAmt |
| Extsn Request Income Tax Paid | $0 | ExtsnRequestIncomeTaxPaidAmt |
| Backup Withholding Withheld | $0 | BackupWithholdingWithheldAmt |
| Total Payments And Credits | $5,812 | TotalPaymentsAndCreditsAmt |
| Es Penalty | $0 | EsPenaltyAmt |
| Overpayment | $728 | OverpaymentAmt |
| Applied To ES Tax | $728 | AppliedToESTaxAmt |
| Refund | $0 | RefundAmt |
Statements Regarding Acty StatementsRegardingActyGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Legislative Political Acty | 0 | LegislativePoliticalActyInd |
| More Than100 Spent | 0 | MoreThan100SpentInd |
| Form1120 POL Filed | 0 | Form1120POLFiledInd |
| Section4955 Organization Tax | $0 | Section4955OrganizationTaxAmt |
| Section4955 Managers Tax | $0 | Section4955ManagersTaxAmt |
| Tax Reimbursed | $0 | TaxReimbursedAmt |
| Activities Not Previously Rpt | 0 | ActivitiesNotPreviouslyRptInd |
| Changes To Articles Or Bylaws | 0 | ChangesToArticlesOrBylawsInd |
| Unrelated Bus Incm Over Limit | 0 | UnrelatedBusIncmOverLimitInd |
| Organization Dissolved Etc | 0 | OrganizationDissolvedEtcInd |
| Section508e Rqr Satisfied | Yes (1) | Section508eRqrSatisfiedInd |
| At Least5000 In Assets | Yes (1) | AtLeast5000InAssetsInd |
| Org Report Or Register State | MI | OrgReportOrRegisterStateCd |
| Form990 PF Filed With Atty Gen | Yes (1) | Form990PFFiledWithAttyGenInd |
| Private Operating Foundation | 0 | PrivateOperatingFoundationInd |
| New Substantial Contributors | 0 | NewSubstantialContributorsInd |
| Own Controlled Entity | 0 | OwnControlledEntityInd |
| Donor Advised Fund | 0 | DonorAdvisedFundInd |
| Comply With Public Insp Rqr | Yes (1) | ComplyWithPublicInspRqrInd |
| Website Address | WWW.APTIV.COM/LEGAL-COMPLIANCE/FOUNDATION | WebsiteAddressTxt |
| Individual With Books | RACHEL FRIEDENBERG | IndividualWithBooksNm |
| Phone | 2482851238 | PhoneNum |
Location Of Books US Address LocationOfBooksUSAddress
| Field | Value | IRS element (for citing) |
|---|---|---|
| Address Line1 | 5725 INNOVATION DRIVE | AddressLine1Txt |
| City | TROY | CityNm |
| State Abbreviation | MI | StateAbbreviationCd |
| ZIP | 480985086 | ZIPCd |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Foreign Accounts Question | 0 | ForeignAccountsQuestionInd |
Statements Regarding Acty4720 StatementsRegardingActy4720Grp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Sale Or Exch Disqualified Prsn | 0 | SaleOrExchDisqualifiedPrsnInd |
| Brrw Or Lend Disqualified Prsn | 0 | BrrwOrLendDisqualifiedPrsnInd |
| Furn Goods Disqualified Prsn | 0 | FurnGoodsDisqualifiedPrsnInd |
| Pay Comp Disqualified Prsn | 0 | PayCompDisqualifiedPrsnInd |
| Transfer Ast Disqualified Prsn | 0 | TransferAstDisqualifiedPrsnInd |
| Payment To Government Official | 0 | PaymentToGovernmentOfficialInd |
| Uncorrected Prior Acts | 0 | UncorrectedPriorActsInd |
| Undistributed Income PY | 0 | UndistributedIncomePYInd |
| Business Holdings | 0 | BusinessHoldingsInd |
| Jeopardy Investments | 0 | JeopardyInvestmentsInd |
| Uncorrected PY Jeopardy Invst | 0 | UncorrectedPYJeopardyInvstInd |
| Influence Legislation | 0 | InfluenceLegislationInd |
| Influence Election | 0 | InfluenceElectionInd |
| Grants To Individuals | 0 | GrantsToIndividualsInd |
| Grants To Organizations | 0 | GrantsToOrganizationsInd |
| Noncharitable Purpose | 0 | NoncharitablePurposeInd |
| Rcv Fnds To Pay Prsnl Bnft Cntrct | 0 | RcvFndsToPayPrsnlBnftCntrctInd |
| Pay Premiums Prsnl Bnft Cntrct | 0 | PayPremiumsPrsnlBnftCntrctInd |
| Prohibited Tax Shelter Trans | 0 | ProhibitedTaxShelterTransInd |
| Subj To Tax Rmnrtn Ex Prcht Pymt | 0 | SubjToTaxRmnrtnExPrchtPymtInd |
Officer Dir Trst Key Empl Info OfficerDirTrstKeyEmplInfoGrp
Officer Dir Trst Key Empl OfficerDirTrstKeyEmplGrp (6 entries)
| Address Line1USAddress/AddressLine1Txt | CityUSAddress/CityNm | State AbbreviationUSAddress/StateAbbreviationCd | ZIPUSAddress/ZIPCd | TitleTitleTxt | Average Hrs Per Wk Devoted To PosAverageHrsPerWkDevotedToPosRt | CompensationCompensationAmt | Employee Benefit ProgramEmployeeBenefitProgramAmt | Expense Account Other AllwncExpenseAccountOtherAllwncAmt |
|---|---|---|---|---|---|---|---|---|
| RACHELLE VALDEZ | ||||||||
| 5725 INNOVATION DRIVE | TROY | MI | 480985086 | CHAIR/PRESIDENT/TRUSTEE | 1.00 | $0 | $0 | $0 |
| JEREMY JENSEN | ||||||||
| 5725 INNOVATION DRIVE | TROY | MI | 480985086 | TREASURER/TRUSTEE | 1.00 | $0 | $0 | $0 |
| RACHEL FRIEDENBERG | ||||||||
| 5725 INNOVATION DRIVE | TROY | MI | 480985086 | SECRETARY/TRUSTEE | 1.00 | $0 | $0 | $0 |
| CHARLENE CHU | ||||||||
| 5725 INNOVATION DRIVE | TROY | MI | 480985086 | TRUSTEE | 1.00 | $0 | $0 | $0 |
| CHRIS HONG | ||||||||
| 5725 INNOVATION DRIVE | TROY | MI | 480985086 | TRUSTEE | 1.00 | $0 | $0 | $0 |
| JADA SMITH | ||||||||
| 5725 INNOVATION DRIVE | TROY | MI | 480985086 | TRUSTEE | 1.00 | $0 | $0 | $0 |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Comp Of Hghst Pd Empl Or NONE | NONE | CompOfHghstPdEmplOrNONETxt |
| Other Employee Paid Over50k | 0 | OtherEmployeePaidOver50kCnt |
| Comp Of Hghst Pd Cntrct Or NONE | NONE | CompOfHghstPdCntrctOrNONETxt |
| Contractor Paid Over50k | 0 | ContractorPaidOver50kCnt |
Sum Of Program Related Invst SumOfProgramRelatedInvstGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Total | $0 | TotalAmt |
Minimum Investment Return MinimumInvestmentReturnGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Average Monthly FMV Of Sec | $15,295,077 | AverageMonthlyFMVOfSecAmt |
| Average Monthly Cash Balances | $369,155 | AverageMonthlyCashBalancesAmt |
| FMV All Other Noncharitable Ast | $0 | FMVAllOtherNoncharitableAstAmt |
| Total FMV Of Unused Assets | $15,664,232 | TotalFMVOfUnusedAssetsAmt |
| Reduction Claimed | $0 | ReductionClaimedAmt |
| Acquisition Indebtedness | $0 | AcquisitionIndebtednessAmt |
| Adjusted Total FMV Of Unused Ast | $15,664,232 | AdjustedTotalFMVOfUnusedAstAmt |
| Cash Deemed Charitable | $234,963 | CashDeemedCharitableAmt |
| Net Vl Noncharitable Assets | $15,429,269 | NetVlNoncharitableAssetsAmt |
| Minimum Investment Return | $771,463 | MinimumInvestmentReturnAmt |
Distributable Amount DistributableAmountGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Minimum Investment Return | $771,463 | MinimumInvestmentReturnAmt |
| Tax Based On Investment Income | $5,084 | TaxBasedOnInvestmentIncomeAmt |
| Total Tax | $5,084 | TotalTaxAmt |
| Distributable Before Adj | $766,379 | DistributableBeforeAdjAmt |
| Recoveries Qualfied Distri | $0 | RecoveriesQualfiedDistriAmt |
| Distributable Before Ded | $766,379 | DistributableBeforeDedAmt |
| Deduction From Distributable | $0 | DeductionFromDistributableAmt |
| Distributable As Adjusted | $766,379 | DistributableAsAdjustedAmt |
Qualifying Distri Part XII QualifyingDistriPartXIIGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Expenses And Contributions | $1,071,475 | ExpensesAndContributionsAmt |
| Program Related Invst Total | $0 | ProgramRelatedInvstTotalAmt |
| Qualifying Distributions | $1,071,475 | QualifyingDistributionsAmt |
| Pct Sect4940e Org Net Invst Incm | $0 | PctSect4940eOrgNetInvstIncmAmt |
| Adjusted Qualifying Distri | $1,071,475 | AdjustedQualifyingDistriAmt |
Undistributed Income UndistributedIncomeGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Distributable As Adjusted | $766,379 | DistributableAsAdjustedAmt |
| Undistributed Income PY | $0 | UndistributedIncomePYAmt |
| Total For Prior Years | $0 | TotalForPriorYearsAmt |
| Excess Distribution Cyov Yr5 | $196,861 | ExcessDistributionCyovYr5Amt |
| Excess Distribution Cyov Yr4 | $288,985 | ExcessDistributionCyovYr4Amt |
| Excess Distribution Cyov Yr3 | $288,541 | ExcessDistributionCyovYr3Amt |
| Excess Distribution Cyov Yr2 | $286,040 | ExcessDistributionCyovYr2Amt |
| Excess Distribution Cyov Yr1 | $26,342 | ExcessDistributionCyovYr1Amt |
| Total Excess Distribution Cyov | $1,086,769 | TotalExcessDistributionCyovAmt |
| Qualifying Distributions | $1,071,475 | QualifyingDistributionsAmt |
| Applied To Year1 | $0 | AppliedToYear1Amt |
| Applied To Prior Years | $0 | AppliedToPriorYearsAmt |
| Treated As Distri From Corpus | $0 | TreatedAsDistriFromCorpusAmt |
| Applied To Current Year | $766,379 | AppliedToCurrentYearAmt |
| Remaining Distri From Corpus | $305,096 | RemainingDistriFromCorpusAmt |
| Excess Distri Cyov App CY Corpus | $0 | ExcessDistriCyovAppCYCorpusAmt |
| Excess Distribution Cyov App CY | $0 | ExcessDistributionCyovAppCYAmt |
| Total Corpus | $1,391,865 | TotalCorpusAmt |
| Prior Year Undistributed Incm | $0 | PriorYearUndistributedIncmAmt |
| Prior Year Deficiency Or Tax | $0 | PriorYearDeficiencyOrTaxAmt |
| Taxable1 | $0 | Taxable1Amt |
| Taxable2 | $0 | Taxable2Amt |
| Undistributed Income CY | $0 | UndistributedIncomeCYAmt |
| Corpus Distri170b1 E Or4942g3 | $0 | CorpusDistri170b1EOr4942g3Amt |
| Excess Distri Cyov From Yr5 | $196,861 | ExcessDistriCyovFromYr5Amt |
| Excess Distri Cyov To Next Yr | $1,195,004 | ExcessDistriCyovToNextYrAmt |
| Excess From Year4 | $288,985 | ExcessFromYear4Amt |
| Excess From Year3 | $288,541 | ExcessFromYear3Amt |
| Excess From Year2 | $286,040 | ExcessFromYear2Amt |
| Excess From Year1 | $26,342 | ExcessFromYear1Amt |
| Excess From Current Year | $305,096 | ExcessFromCurrentYearAmt |
Supplementary Information SupplementaryInformationGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Only Contri To Preselected | Yes (X) | OnlyContriToPreselectedInd |
Grant Or Contribution Pd Dur Yr GrantOrContributionPdDurYrGrp (18 entries)
| Address Line1RecipientUSAddress/AddressLine1Txt | CityRecipientUSAddress/CityNm | State AbbreviationRecipientUSAddress/StateAbbreviationCd | ZIPRecipientUSAddress/ZIPCd | Recipient RelationshipRecipientRelationshipTxt | Recipient Foundation StatusRecipientFoundationStatusTxt | Grant Or Contribution PurposeGrantOrContributionPurposeTxt | AmtAmt |
|---|---|---|---|---|---|---|---|
| CARNEGIE MELLON UNIVERSITY | |||||||
| 5000 FORBES AVENUE GATE 6105 | PITTSBURGH | PA | 15213 | NONE | PC | ON-GOING UNIVERSITY SUPPORT | $60,000 |
| CODE2COLLEGE | |||||||
| 19112 LEIGH LANE | PFLUGERVILLE | TX | 78660 | NONE | PC | SCIENCE, TECHNOLOGY, ENGINEERING, AND MATH | $75,000 |
| DETROIT SYMPHONY ORCHESTRA INC | |||||||
| 3711 WOODWARD AVENUE | DETROIT | MI | 48201 | NONE | PC | ORCHESTRA EDUCATIONAL SUPPORT | $5,000 |
| FIRST ROBOTICS | |||||||
| 7400 BAY ROAD UNIVERSITY CENTER | SAGINAW | MI | 48604 | NONE | PC | FIRST ROBOTICS SEASON 2020-2021 | $78,500 |
| FOCUS HOPE | |||||||
| 1400 OAKMAN BOULEVARD | DETROIT | MI | 48238 | NONE | PC | VIRTUAL SUPPORT PROGRAM | $15,000 |
| FREE BIKES 4 KIDZ | |||||||
| 1200 OAKMAN BOULEVARD | DETROIT | MI | 48238 | NONE | PC | DONATION FOR BIKE HELMETS | $5,000 |
| GIRLS ON THE RUN | |||||||
| 1401 BROADWAY STREET | DETROIT | MI | 48226 | NONE | PC | VIRTUAL SUPPORT PROGRAM | $10,000 |
| GLOBAL GIVING | |||||||
| 1 THOMAS CIRCLE NW SUITE 800 | WASHINGTON | DC | 20005 | NONE | PC | COVID-19 | $500,000 |
| GREENLIGHT FUND | |||||||
| 120 ST JAMES AVENUE 6TH FLOOR | BOSTON | MA | 02116 | NONE | PC | CONTRACT OBLIGATION | $25,000 |
| JEWISH NATIONAL FUND | |||||||
| 78 RANDALL AVENUE | ROCKVILLE CENTER | NY | 11570 | NONE | PC | MEMORIAL FOR ADAM LOWELL JOHNSON/TREE GARDEN IN ISRAEL | $500 |
| MASSACHUSETTS INSTITUTE OF TECHNOLOGY | |||||||
| 600 MEMORIAL DRIVE | CAMBRIDGE | MA | 02139 | NONE | PC | ON-GOING UNIVERSITY SUPPORT | $80,000 |
| MICHIGAN STATE UNIVERSITY | |||||||
| 535 CHESTNUT ROAD ROOM 300 | LANSING | MI | 48824 | NONE | GOV | ON-GOING UNIVERSITY SUPPORT | $12,500 |
| THE OHIO STATE UNIVERSITY FOUNDATION | |||||||
| 1480 WEST LANE AVENUE | COLUMBUS | MI | 43221 | NONE | GOV | ON-GOING UNIVERSITY SUPPORT | $12,500 |
| PURDUE UNIVERSITY | |||||||
| 610 PURDUE MALL | WEST LAFAYETTE | IN | 47907 | NONE | PC | ON-GOING UNIVERSITY SUPPORT | $60,000 |
| UNITED WAY FOR SOUTHEASTERN MICHIGAN | |||||||
| 3011 WEST GRAND BOULEVARD SUITE 500 | DETROIT | MI | 48202 | NONE | PC | MEXICO - IWD (THREE CHARITIES) | $30,000 |
| UNITED WAY WORLDWIDE | |||||||
| PO BOX 418607 | BOSTON | MA | 022418607 | NONE | PC | HONDURAS HURRICANE | $30,000 |
| UNIVERSITY OF MICHIGAN | |||||||
| 500 SOUTH STATE STREET | ANN ARBOR | MI | 48109 | NONE | GOV | ON-GOING UNIVERSITY SUPPORT | $60,000 |
| WINNING FUTURES | |||||||
| 27500 COSGROVE DRIVE | WARREN | MI | 48092 | NONE | PC | CORKS AND FORKS | $5,000 |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Total Grant Or Contri Pd Dur Yr | $1,064,000 | TotalGrantOrContriPdDurYrAmt |
| Total Grant Or Contri Apprv Fut | $0 | TotalGrantOrContriApprvFutAmt |
Analysis Income Producing Acty AnalysisIncomeProducingActyGrp
Int On Sav And Temp Cash Invst IntOnSavAndTempCashInvstGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Exclusion | 14 | ExclusionCd |
| Exclusion | $166,705 | ExclusionAmt |
Div And Int From Sec Part VII DivAndIntFromSecPartVIIGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Exclusion | 14 | ExclusionCd |
| Exclusion | $191,278 | ExclusionAmt |
Gain Sales Ast Oth Than Invntry GainSalesAstOthThanInvntryGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Exclusion | 18 | ExclusionCd |
| Exclusion | $63,585 | ExclusionAmt |
Subtotals Incm Producing Acty SubtotalsIncmProducingActyGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Unrelated Business Taxbl Incm | $0 | UnrelatedBusinessTaxblIncmAmt |
| Exclusion | $421,568 | ExclusionAmt |
| Related Or Exempt Function Incm | $0 | RelatedOrExemptFunctionIncmAmt |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Total Income Producing Acty | $421,568 | TotalIncomeProducingActyAmt |
Trnsfr Trans Rln Nonchrtbl EO TrnsfrTransRlnNonchrtblEOGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Trnsfr Of Cash To Nonchrtbl EO | 0 | TrnsfrOfCashToNonchrtblEOInd |
| Trnsfr Other Asset Nonchrtbl EO | 0 | TrnsfrOtherAssetNonchrtblEOInd |
| Sales Or Exchanges Of Assets | 0 | SalesOrExchangesOfAssetsInd |
| Purchase Of Assets Nonchrtbl EO | 0 | PurchaseOfAssetsNonchrtblEOInd |
| Rental Of Facilities Oth Assets | 0 | RentalOfFacilitiesOthAssetsInd |
| Reimbursement Arrangements | 0 | ReimbursementArrangementsInd |
| Loans Or Loan Guarantees | 0 | LoansOrLoanGuaranteesInd |
| Performance Of Services Etc | 0 | PerformanceOfServicesEtcInd |
| Sharing Of Facilities Etc | 0 | SharingOfFacilitiesEtcInd |
| Relationships Nonchrtbl EO | 0 | RelationshipsNonchrtblEOInd |
Accounting Fees Schedule AccountingFeesSchedule
Accounting Fees Detail AccountingFeesDetail
| Field | Value | IRS element (for citing) |
|---|---|---|
| Category | ACCOUNTING FEES | CategoryTxt |
| Amt | $14,950 | Amt |
| Net Investment Income | $7,475 | NetInvestmentIncomeAmt |
| Disbursements Charitable Prps | $7,475 | DisbursementsCharitablePrpsAmt |
Investments Corp Bonds Schedule InvestmentsCorpBondsSchedule
Investments Corporate Bonds InvestmentsCorporateBondsGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Bond | ISHARES TIPS BOND FUND | BondNm |
| EOY Book Value | $576,467 | EOYBookValueAmt |
| EOYFMV | $576,467 | EOYFMVAmt |
Investments Corp Stock Schedule InvestmentsCorpStockSchedule
Investments Corporate Stock InvestmentsCorporateStockGrp (6 entries)
| StockStockNm | EOY Book ValueEOYBookValueAmt | EOYFMVEOYFMVAmt |
|---|---|---|
| PUBLICLY-TRADED STOCKS | $3,188,259 | $3,188,259 |
| ISHARES CORE S&P 500 FUND | $3,431,440 | $3,431,440 |
| VANGUARD REIT FUND | $515,355 | $515,355 |
| ISHARES RUSSELL 1000 GROWTH FUND | $441,527 | $441,527 |
| HARDING LOEVNER INSTITUTIONAL EMERGING MARKETS FUND | $643,845 | $643,845 |
| ISHARES MSCI EAFE ETF | $917,618 | $917,618 |
Investments Other Schedule2 InvestmentsOtherSchedule2
Investments Other InvestmentsOtherGrp (6 entries)
| Category Or ItemCategoryOrItemTxt | Listed At Cost Or FMVListedAtCostOrFMVCd | Book ValueBookValueAmt | EOYFMVEOYFMVAmt |
|---|---|---|---|
| DODGE & COX INCOME FUND | FMV | $1,624,403 | $1,624,403 |
| BLACKROCK STRATEGIC INCOME OPPORTUNITIES PORTFOLIO FUND | FMV | $825,391 | $825,391 |
| BAIRD AGGREGATE BOND FUND | FMV | $1,791,389 | $1,791,389 |
| FEDERATED INTERNATIONAL EQUITY FUND | FMV | $1,783,039 | $1,783,039 |
| LAZARD GLOBAL FUND | FMV | $471,558 | $471,558 |
| ISHARES CORE S&P SMALL CAP FUND | FMV | $608,010 | $608,010 |
Other Expenses Schedule OtherExpensesSchedule
Other Expenses Schedule OtherExpensesScheduleGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Desc | OTHER EXPENSES | Desc |
| Revenue And Expenses Per Books | $25 | RevenueAndExpensesPerBooksAmt |
| Net Investment Income | $25 | NetInvestmentIncomeAmt |
| Disbursements Charitable Prps | $0 | DisbursementsCharitablePrpsAmt |
Other Increases Schedule OtherIncreasesSchedule
Other Increases Detail OtherIncreasesDetail
| Field | Value | IRS element (for citing) |
|---|---|---|
| Desc | CHANGE IN UNREALIZED NET GAINS ON INVESTMENTS | Desc |
| Amt | $1,342,415 | Amt |
Other Professional Fees Schedule OtherProfessionalFeesSchedule
Other Professional Fees Detail OtherProfessionalFeesDetail
| Field | Value | IRS element (for citing) |
|---|---|---|
| Category | CUSTODIAL FEES | CategoryTxt |
| Amt | $48,313 | Amt |
| Net Investment Income | $48,313 | NetInvestmentIncomeAmt |
| Disbursements Charitable Prps | $0 | DisbursementsCharitablePrpsAmt |
Taxes Schedule TaxesSchedule
Taxes Detail TaxesDetail
| Field | Value | IRS element (for citing) |
|---|---|---|
| Category | FEDERAL EXCISE TAX | CategoryTxt |
| Amt | $33,175 | Amt |
| Net Investment Income | $0 | NetInvestmentIncomeAmt |
| Disbursements Charitable Prps | $0 | DisbursementsCharitablePrpsAmt |
Comments