Civic Intelligence

John Buchanan

990PF • Fiscal year 2017 • EIN 23-6201538

Jan 01, 2017 to Dec 31, 2017 • Filed on Mar 19, 2018

116 Allegheny Center Mall P8yb3502lPittsburgh, PA 15212

(412) 768-5898

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

17th percentile

-20%

Higher net margin than 17% of similar nonprofits.

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

Top Officer Pay

82nd percentile

$7,627

Higher top officer pay than 82% of similar nonprofits.

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

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

Asset Growth

42nd percentile

-1.3%

Faster asset growth than 42% of similar nonprofits.

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

Revenue Growth

26th percentile

-16%

Faster revenue growth than 26% of similar nonprofits.

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

Assets

Down

$358,106

Down $4,572 (-1.3%) from 2016

Net Assets

Down

$358,106

Down $4,572 (-1.3%) from 2016

Liabilities

Flat

$0

Flat from 2016

Revenue

Down

$22,517

Down $4,312 (-16%) from 2016

Expenses

Down

$27,090

Down $583 (-2.1%) from 2016

Net Income

Down

-$4,573

Down $3,729 (-442%) from 2016

Historical Trend

Balance Sheet Trend

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

$600K$400K$200K$0Assets 2011: $323,742Liabilities 2011: $0Net Assets 2011: $323,7422011Assets 2012: $349,906Liabilities 2012: $0Net Assets 2012: $349,9062012Assets 2013: $376,689Liabilities 2013: $0Net Assets 2013: $376,6892013Assets 2014: $370,384Liabilities 2014: $0Net Assets 2014: $370,3842014Assets 2015: $363,524Liabilities 2015: $0Net Assets 2015: $363,5242015Assets 2016: $362,678Liabilities 2016: $0Net Assets 2016: $362,6782016Assets 2017: $358,106Liabilities 2017: $0Net Assets 2017: $358,1062017Assets 2018: $405,246Liabilities 2018: $0Net Assets 2018: $405,2462018Assets 2019: $416,649Liabilities 2019: $0Net Assets 2019: $416,6492019Assets 2020: $401,119Liabilities 2020: $0Net Assets 2020: $401,1192020Assets 2021: $411,142Liabilities 2021: $0Net Assets 2021: $411,1422021Assets 2022: $378,796Liabilities 2022: $0Net Assets 2022: $378,7962022Assets 2023: $360,410Liabilities 2023: $0Net Assets 2023: $360,4102023Assets 2024: $354,828Liabilities 2024: $0Net Assets 2024: $354,8282024

Highlighted filing

2017

Assets$358,106
Liabilities$0
Net Assets$358,106

Operations Trend

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

$100K$50K$0-$50KExpenses 2011: $12,7842011Expenses 2012: $18,9062012Revenue 2013: $49,276Expenses 2013: $22,493Net Income 2013: $26,7832013Revenue 2014: $22,121Expenses 2014: $26,691Net Income 2014: -$4,5702014Revenue 2015: $21,184Expenses 2015: $28,042Net Income 2015: -$6,8582015Revenue 2016: $26,829Expenses 2016: $27,673Net Income 2016: -$8442016Revenue 2017: $22,517Expenses 2017: $27,090Net Income 2017: -$4,5732017Revenue 2018: $75,109Expenses 2018: $27,972Net Income 2018: $47,1372018Revenue 2019: $40,724Expenses 2019: $29,320Net Income 2019: $11,4042019Revenue 2020: $12,338Expenses 2020: $27,086Net Income 2020: -$14,7482020Revenue 2021: $38,710Expenses 2021: $28,722Net Income 2021: $9,9882021Revenue 2022: -$1,386Expenses 2022: $30,214Net Income 2022: -$31,6002022Revenue 2023: $7,393Expenses 2023: $27,064Net Income 2023: -$19,6712023Revenue 2024: $20,844Expenses 2024: $26,388Net Income 2024: -$5,5442024

Highlighted filing

2017

Revenue$22,517
Expenses$27,090
Net Income-$4,573
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Mar 19, 2018
Return Version
2017v2.2
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
PNC BANK NATrustee-$7,627-$7,627
Filing and Contact Details

Filer

Filer Name
John Buchanan
EIN
23-6201538
Phone
4127685898
Address
116 ALLEGHENY CENTER MALL P8YB3502L, PITTSBURGH, PA 15212

Signing Officer

Name
Pnc Bank N a by
Title
Vice President
Phone
4127685898
Signed
2018-03-19
Raw XML Appendix306 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/BookValueAmt0134770
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt1204846
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt0MUTUAL FUNDS - FIXED
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt1MUTUAL FUNDS - EQUITY
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt0132946
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt1283762
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd0AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd1AT COST
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt08656
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt013861
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt022517
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt022517
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt013861
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt0381
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt07246
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt07627
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt019204
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt019204
IRS990PF/AnalysisOfRevenueAndExpenses/DeprecAndDpltnNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DeprecAndDpltnRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt08656
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt08656
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-4573
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt023074
IRS990PF/AnalysisOfRevenueAndExpenses/InterestDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt013861
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt015271
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/TaxesRevAndExpnssAmt0259
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt019585
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt07246
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt027090
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt022517
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt022517
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt0381
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt07246
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt07886
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingNetInvstIncmAmt00
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt02016-12-13
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt12012-10-12
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt03435
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt15778
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt0444
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt14962
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt28455
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt0444
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt14962
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt03879
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt110740
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc015. ISHARES TR S&P 500 INDEX FD
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc1153.56 T ROWE PRICE GROWTH STOCK FUND
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc2CAPITAL GAIN DIVIDENDS
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt02017-10-30
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt12017-10-30
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt013861
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-4573
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt01
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0358106
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0362678
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0358106
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt020704
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt020704
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt020704
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt020857
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0153
IRS990PF/DistributableAmountGrp/TotalTaxAmt0153
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt047
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/DomesticOrgMeetingSect4940eInd0X
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EsPenaltyAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt0200
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExtsnRequestIncomeTaxPaidAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0153
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/OverpaymentAmt047
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/RefundAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0153
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0153
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt0200
IRS990PF/FMVAssetsEOYAmt0435198
IRS990PF/Form990PFBalanceSheetsGrp/AcctRcvblEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AcctRcvblEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt0360248
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt0355709
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsBOYAmt0348829
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYAmt0339616
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt0416708
IRS990PF/Form990PFBalanceSheetsGrp/OtherRcvblAllwncDbtflAcctAmt00
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt02430
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt02397
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt013849
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt018490
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt018490
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0362678
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0358106
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0435198
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0362678
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0358106
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0362678
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0358106
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0423486
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt00
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0423486
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt06352
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt020857
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0417134
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0423486
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt02
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt07627
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/Organization4947a1TrtdPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt019343
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt019496
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt020422
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt020784
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt018909
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt017191
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt015209
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.046372
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.051746
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.050039
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.044829
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt00.043351
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt00.041894
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd0false
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt0153
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt0417134
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt0394657
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt0415358
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt0421805
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt0396558
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt0363039
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt019585
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.231859
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt019432
IRS990PF/QualifyingDistriPartXIIGrp/CharitableAssetsAcquisPaidAmt00
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt019585
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt0153
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt019585
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/NECTFilingInLieuOFForm1041Ind0X
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0PA
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine1Txt0PNC BANK TRUSTEE
IRS990PF/StatementsRegardingActyGrp/PhoneNum04127685898
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0true
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt019204
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0GENERAL SUPPORT OF FOREIGN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt0MISSION TO THE WORLD
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt01600 NORTH BROWN ROAD
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0LAWRENCEVILLE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0GA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd030043
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt019204
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/AppliedToCurrentYearAmt0414
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt019171
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt020704
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/QualifyingDistributionsAmt019585
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt00
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt00
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt020290
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt019171
OtherIncreasesSchedule/OtherIncreasesDetail/Amt01
OtherIncreasesSchedule/OtherIncreasesDetail/Desc0ROUNDING ADJ FOR SALES AND TRANSACTIONS
TaxesSchedule/TaxesDetail/Amt059
TaxesSchedule/TaxesDetail/Amt1200
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/PhoneNum04127685898
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-03-19
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0JOHN BUCHANAN
ReturnHeader/Filer/BusinessNameControlTxt0BUCH
ReturnHeader/Filer/EIN0236201538
ReturnHeader/Filer/PhoneNum04127685898
ReturnHeader/Filer/USAddress/AddressLine1Txt0116 ALLEGHENY CENTER MALL P8YB3502L
ReturnHeader/Filer/USAddress/CityNm0PITTSBURGH
ReturnHeader/Filer/USAddress/StateAbbreviationCd0PA
ReturnHeader/Filer/USAddress/ZIPCd015212
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0775AC9AF59FC72ED61B8D791BFA73B7758C13598
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId01CC7BA5074E8AB1797D9DE59A1DFA746CF600023
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0161.150.240.3
ReturnHeader/ReturnTs02018-04-02T15:58:52-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.$3.55$0.00$3.55$0.21$0.26$0.06
2023Detailed filing. Detailed filing data is available for this year.$3.60$0.00$3.60$0.07$0.27$0.20
2022Detailed filing. Detailed filing data is available for this year.$3.79$0.00$3.79$0.01$0.30$0.32
2021Detailed filing. Detailed filing data is available for this year.$4.11$0.00$4.11$0.39$0.29$0.10
2020Detailed filing. Detailed filing data is available for this year.$4.01$0.00$4.01$0.12$0.27$0.15
2019Detailed filing. Detailed filing data is available for this year.$4.17$0.00$4.17$0.41$0.29$0.11
2018Detailed filing. Detailed filing data is available for this year.$4.05$0.00$4.05$0.75$0.28$0.47
2017Detailed filing. Detailed filing data is available for this year.$3.58$0.00$3.58$0.23$0.27$0.05
2016Detailed filing. Detailed filing data is available for this year.$3.63$0.00$3.63$0.27$0.28$0.01
2015Detailed filing. Detailed filing data is available for this year.$3.64$0.00$3.64$0.21$0.28$0.07
2014Detailed filing. Detailed filing data is available for this year.$3.70$0.00$3.70$0.22$0.27$0.05
2013Detailed filing. Detailed filing data is available for this year.$3.77$0.00$3.77$0.49$0.22$0.27
2012Detailed filing. Detailed filing data is available for this year.$3.50$0.00$3.50$0.19
2011Detailed filing. Detailed filing data is available for this year.$3.24$0.00$3.24$0.13