Civic Intelligence

John B Cooley Charitable Trust #2

990PF • Fiscal year 2017 • EIN 34-7218369

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

116 Allegheny Center Mall P8yb3502lPittsburgh, PA 15212

(412) 768-9969

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

10th percentile

-47%

Higher net margin than 10% of similar nonprofits.

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

Top Officer Pay

79th percentile

$2,500

Higher top officer pay than 79% of similar nonprofits.

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

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

Asset Growth

39th percentile

-2.8%

Faster asset growth than 39% of similar nonprofits.

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

Revenue Growth

8th percentile

-53%

Faster revenue growth than 8% of similar nonprofits.

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

Assets

Down

$128,724

Down $3,767 (-2.8%) from 2016

Net Assets

Down

$128,724

Down $3,767 (-2.8%) from 2016

Liabilities

Flat

$0

Flat from 2016

Revenue

Down

$8,068

Down $9,112 (-53%) from 2016

Expenses

Up

$11,838

Up $3,385 (+40%) from 2016

Net Income

Down

-$3,770

Down $12,497 (-143%) from 2016

Historical Trend

Balance Sheet Trend

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

$200K$150K$100K$50K$0Assets 2010: $135,429Liabilities 2010: $0Net Assets 2010: $135,4292010Assets 2011: $131,158Liabilities 2011: $0Net Assets 2011: $131,1582011Assets 2012: $128,451Liabilities 2012: $0Net Assets 2012: $128,4512012Assets 2013: $126,160Liabilities 2013: $0Net Assets 2013: $126,1602013Assets 2014: $125,884Liabilities 2014: $0Net Assets 2014: $125,8842014Assets 2015: $123,769Liabilities 2015: $0Net Assets 2015: $123,7692015Assets 2016: $132,491Liabilities 2016: $0Net Assets 2016: $132,4912016Assets 2017: $128,724Liabilities 2017: $0Net Assets 2017: $128,7242017Assets 2018: $141,598Liabilities 2018: $0Net Assets 2018: $141,5982018Assets 2019: $150,523Liabilities 2019: $0Net Assets 2019: $150,5232019Assets 2020: $144,190Liabilities 2020: $0Net Assets 2020: $144,1902020Assets 2021: $147,606Liabilities 2021: $0Net Assets 2021: $147,6062021Assets 2022: $137,636Liabilities 2022: $0Net Assets 2022: $137,6362022Assets 2023: $129,860Liabilities 2023: $0Net Assets 2023: $129,8602023Assets 2024: $126,911Liabilities 2024: $0Net Assets 2024: $126,9112024

Highlighted filing

2017

Assets$128,724
Liabilities$0
Net Assets$128,724

Operations Trend

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

$30K$20K$10K$0-$10K-$20KExpenses 2010: $8,5942010Expenses 2011: $7,2262011Expenses 2012: $13,5342012Revenue 2013: $7,331Expenses 2013: $9,622Net Income 2013: -$2,2912013Revenue 2014: $10,162Expenses 2014: $10,440Net Income 2014: -$2782014Revenue 2015: $8,293Expenses 2015: $10,409Net Income 2015: -$2,1162015Revenue 2016: $17,180Expenses 2016: $8,453Net Income 2016: $8,7272016Revenue 2017: $8,068Expenses 2017: $11,838Net Income 2017: -$3,7702017Revenue 2018: $23,013Expenses 2018: $10,137Net Income 2018: $12,8762018Revenue 2019: $19,297Expenses 2019: $10,369Net Income 2019: $8,9282019Revenue 2020: $4,882Expenses 2020: $10,931Net Income 2020: -$6,0492020Revenue 2021: $14,173Expenses 2021: $10,772Net Income 2021: $3,4012021Revenue 2022: $1,141Expenses 2022: $11,235Net Income 2022: -$10,0942022Revenue 2023: $3,222Expenses 2023: $11,116Net Income 2023: -$7,8942023Revenue 2024: $6,989Expenses 2024: $9,896Net Income 2024: -$2,9072024

Highlighted filing

2017

Revenue$8,068
Expenses$11,838
Net Income-$3,770
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Apr 16, 2018
Return Version
2017v2.2
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
PNC BANK NATrustee-$2,500-$2,500
Filing and Contact Details

Filer

Filer Name
JOHN B COOLEY CHARITABLE TRUST #2
EIN
34-7218369
Phone
4127689969
Address
116 ALLEGHENY CENTER MALL P8YB3502L, PITTSBURGH, PA 15212

Signing Officer

Name
Pnc Bank N a by
Title
Vice President
Phone
4127689969
Signed
2018-04-16
Raw XML Appendix342 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
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt046911
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt175593
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt0MUTUAL FUNDS - FIXED
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt1MUTUAL FUNDS - EQUITY
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt046699
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt1106224
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd0AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd1AT COST
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt03105
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt04963
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt08068
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt08068
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt04963
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt01250
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt01250
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt02500
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt08771
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt08771
IRS990PF/AnalysisOfRevenueAndExpenses/DeprecAndDpltnNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DeprecAndDpltnRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt03105
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt03105
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-3770
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt010605
IRS990PF/AnalysisOfRevenueAndExpenses/InterestDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt04963
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt06818
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/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt0567
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt010021
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt01250
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt011838
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt08068
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt08068
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt01250
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt01250
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt03067
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingNetInvstIncmAmt00
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt02016-11-02
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt12012-12-14
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt22016-11-02
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt32016-11-02
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt42012-12-14
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt52016-11-02
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt01481
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt1743
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt2930
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt3635
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt4350
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt51503
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt0170
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt1367
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt295
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt3118
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt4205
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt5372
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt63636
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt0170
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt1367
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt295
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt3118
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt4205
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt5372
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt01651
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt11110
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt21025
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt3753
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt4555
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt51875
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc07. ISHARES TR S&P 500 INDEX FD
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc129.365 MFS VALUE FUND CLASS I FUND 893
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc217.551 T ROWE PRICE GROWTH STOCK FUND
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc33. ISHARES TR S&P 500 INDEX FD
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc413.827 MFS VALUE FUND CLASS I FUND 893
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc528.362 T ROWE PRICE GROWTH STOCK FUND
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc6CAPITAL GAIN DIVIDENDS
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt02017-03-24
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt12017-03-24
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt22017-03-24
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt32017-09-26
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt42017-09-26
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt52017-09-26
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt04963
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-3770
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt03
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0128724
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0132491
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0128724
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt07552
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt07552
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt07552
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt07620
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt068
IRS990PF/DistributableAmountGrp/TotalTaxAmt068
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt068
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/DomesticOrgMeetingSect4940eInd0X
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EsPenaltyAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt0320
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExtsnRequestIncomeTaxPaidAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt068
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/OverpaymentAmt0252
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/RefundAmt0184
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt068
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt068
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt0320
IRS990PF/FMVAssetsEOYAmt0159143
IRS990PF/Form990PFBalanceSheetsGrp/AcctRcvblEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AcctRcvblEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt0130987
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt0125441
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsBOYAmt0128145
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYAmt0122504
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt0152923
IRS990PF/Form990PFBalanceSheetsGrp/OtherRcvblAllwncDbtflAcctAmt00
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt01504
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt03283
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt04346
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt06220
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt06220
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0132491
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0128724
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0159143
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0132491
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0128724
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0132491
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0128724
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0154713
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt00
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0154713
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt02321
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt07620
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0152392
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0154713
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt01
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt02500
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0PNC BANK NA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt0116 ALLEGHENY CENTER MALL
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0PITTSBURGH
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0PA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd015212
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt09428
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt09496
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt07156
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt08972
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt09076
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt08136
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt012168
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.061868
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.049956
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.059316
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.058767
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt00.055723
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt00.08558
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd0false
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt068
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt0152392
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt0143245
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt0151258
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt0154441
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt0146009
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt0142182
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt010021
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.309342
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt09953
IRS990PF/QualifyingDistriPartXIIGrp/CharitableAssetsAcquisPaidAmt00
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt010021
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt068
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt010021
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/AddressLine1Txt0116 ALLEGHENY CENTER MALL
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0PITTSBURGH
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0PA
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd015212
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0PA
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine1Txt0PNC BANK NA
IRS990PF/StatementsRegardingActyGrp/PhoneNum04127689969
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0true
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt05552
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt13219
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0GENERAL SUPPORT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1GENERAL SUPPORT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt0PRESBYTERIAN CHURCH (USA) FDN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt1WITTENBERG COLLEGE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt1PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt1NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt0200 EAST 12TH STREET
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt1PO BOX 720
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0JEFFERSONVILLE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm1SPRINGFIELD
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0IN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd1OH
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd0471303854
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd1455010720
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt08771
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/AppliedToCurrentYearAmt07552
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt00
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt07552
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr1Amt0313
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr2Amt01549
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr3Amt01532
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr4Amt0125
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt05988
IRS990PF/UndistributedIncomeGrp/ExcessFromCurrentYearAmt02469
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt0313
IRS990PF/UndistributedIncomeGrp/ExcessFromYear2Amt01549
IRS990PF/UndistributedIncomeGrp/ExcessFromYear3Amt01532
IRS990PF/UndistributedIncomeGrp/ExcessFromYear4Amt0125
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt010021
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt02469
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt05988
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt03519
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt00
OtherIncreasesSchedule/OtherIncreasesDetail/Amt03
OtherIncreasesSchedule/OtherIncreasesDetail/Desc0ROUNDING ADJ FOR SALES AND TRANSACTIONS
TaxesSchedule/TaxesDetail/Amt0247
TaxesSchedule/TaxesDetail/Amt1320
TaxesSchedule/TaxesDetail/CategoryTxt0FEDERAL TAX PAYMENT - PRIOR YE
TaxesSchedule/TaxesDetail/CategoryTxt1FEDERAL ESTIMATES - PRINCIPAL
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt00
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt10
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt00
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt10
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/PersonNm0PNC BANK N A BY
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0VICE PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum04127689969
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-04-16
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0JOHN B COOLEY CHARITABLE TRUST #2
ReturnHeader/Filer/BusinessNameControlTxt0JOHN
ReturnHeader/Filer/EIN0347218369
ReturnHeader/Filer/PhoneNum04127689969
ReturnHeader/Filer/USAddress/AddressLine1Txt0116 ALLEGHENY CENTER MALL P8YB3502L
ReturnHeader/Filer/USAddress/CityNm0PITTSBURGH
ReturnHeader/Filer/USAddress/StateAbbreviationCd0PA
ReturnHeader/Filer/USAddress/ZIPCd015212
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId01CC7BA5074E8AB1797D9DE59A1DFA746CF600023
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId01CC7BA5074E8AB1797D9DE59A1DFA746CF600023
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0161.150.240.4
ReturnHeader/ReturnTs02018-04-17T17:01:05-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

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$1.27$0.00$1.27$0.07$0.10$0.03
2023Detailed filing. Detailed filing data is available for this year.$1.30$0.00$1.30$0.03$0.11$0.08
2022Detailed filing. Detailed filing data is available for this year.$1.38$0.00$1.38$0.01$0.11$0.10
2021Detailed filing. Detailed filing data is available for this year.$1.48$0.00$1.48$0.14$0.11$0.03
2020Detailed filing. Detailed filing data is available for this year.$1.44$0.00$1.44$0.05$0.11$0.06
2019Detailed filing. Detailed filing data is available for this year.$1.51$0.00$1.51$0.19$0.10$0.09
2018Detailed filing. Detailed filing data is available for this year.$1.42$0.00$1.42$0.23$0.10$0.13
2017Detailed filing. Detailed filing data is available for this year.$1.29$0.00$1.29$0.08$0.12$0.04
2016Detailed filing. Detailed filing data is available for this year.$1.32$0.00$1.32$0.17$0.08$0.09
2015Detailed filing. Detailed filing data is available for this year.$1.24$0.00$1.24$0.08$0.10$0.02
2014Detailed filing. Detailed filing data is available for this year.$1.26$0.00$1.26$0.10$0.10$0.00
2013Detailed filing. Detailed filing data is available for this year.$1.26$0.00$1.26$0.07$0.10$0.02
2012Detailed filing. Detailed filing data is available for this year.$1.28$0.00$1.28$0.14
2011Detailed filing. Detailed filing data is available for this year.$1.31$0.00$1.31$0.07
2010Detailed filing. Detailed filing data is available for this year.$1.35$0.00$1.35$0.09