Charles Esplin Tua

990PF • Fiscal year 2017 • EIN 36-6052501

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

Organization Profile

C/O Pnc Bank Na PO Box 609Pittsburgh, PA 15230-9738

(216) 257-4701

Siviq Scores

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

0.00x

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

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

0.00x

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

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

-57%

Higher net margin than 8% of similar nonprofits.

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

$11,158

Higher top officer pay than 47% of similar nonprofits.

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

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

-2.1%

Faster asset growth than 29% of similar nonprofits.

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

74%

Faster revenue growth than 88% of similar nonprofits.

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

Balance Sheet

Liabilities / Assets25th percentile

Assets

Down

$1,224,302

Down $26,878 (-2.1%) from 2016

Net Assets

Down

$1,224,302

Down $26,878 (-2.1%) from 2016

Liabilities

Flat

Flat from 2016

Revenue And Expenses

Liabilities / Revenue25th percentile Net Margin8th percentile

Revenue

$47,481

Up $20,181 (+74%) from 2016

Expenses

Down

$74,401

Down $5,268 (-6.6%) from 2016

Net Income

-$26,920

Up $25,449 (+49%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth29th percentile

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

Highlighted filing

2017

Assets$1,224,302

Liabilities$0

Net Assets$1,224,302

Open 2017 Filing

Operations Trend

Revenue Growth88th percentile

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

Highlighted filing

2017

Revenue$47,481

Expenses$74,401

Net Income-$26,920

Open 2017 Filing

Jump To

Filing Snapshot

Filing Period: Jan 1, 2017 to Dec 31, 2017
Signed: Apr 8, 2018
Return Version: 2017v2.2

Compensation and Service Providers

Top Officer Pay47th percentile

Employees

Name	Title	Full / Part Time	Base	Other	Total
PNC BANK NA	Trustee	-	$11,158	-	$11,158

Filing and Contact Details

Filer

Filer Name: Charles Esplin Tua
EIN: 36-6052501
Phone: 2162574701
Address: C/O PNC BANK NA PO BOX 609, PITTSBURGH, PA 15230-9738

Signing Officer

Name: Pnc Bank N a by
Title: Vice President
Phone: 2162574701
Signed: 2018-04-08

Raw XML Appendix341 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
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt	0	28163
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd	0	14
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt	0	17268
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd	0	18
IRS990PF/AnalysisIncomeProducingActyGrp/OtherRevenueDescribedGrp/Desc	0	TAX REFUND
IRS990PF/AnalysisIncomeProducingActyGrp/OtherRevenueDescribedGrp/Desc	1	RECOVERY OF GRANTS
IRS990PF/AnalysisIncomeProducingActyGrp/OtherRevenueDescribedGrp/ExclusionAmt	0	422
IRS990PF/AnalysisIncomeProducingActyGrp/OtherRevenueDescribedGrp/ExclusionAmt	1	1628
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt	0	47481
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt	0	47481
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt	0	0
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt	0	17268
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt	0	5579
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt	0	5579
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt	0	11158
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt	0	63110
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt	0	63110
IRS990PF/AnalysisOfRevenueAndExpenses/DeprecAndDpltnNetInvstIncmAmt	0	0
IRS990PF/AnalysisOfRevenueAndExpenses/DeprecAndDpltnRevAndExpnssAmt	0	0
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt	0	28163
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt	0	28163
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt	0	-26920
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt	0	32666
IRS990PF/AnalysisOfRevenueAndExpenses/InterestDsbrsChrtblAmt	0	0
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesDsbrsChrtblAmt	0	0
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt	0	17268
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt	0	39852
IRS990PF/AnalysisOfRevenueAndExpenses/NetSTCapitalGainAdjNetIncmAmt	0	0
IRS990PF/AnalysisOfRevenueAndExpenses/OthEmplSlrsWgsAdjNetIncmAmt	0	0
IRS990PF/AnalysisOfRevenueAndExpenses/OthEmplSlrsWgsDsbrsChrtblAmt	0	0
IRS990PF/AnalysisOfRevenueAndExpenses/OthEmplSlrsWgsNetInvstIncmAmt	0	0
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesDsbrsChrtblAmt	0	15
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt	0	15
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeRevAndExpnssAmt	0	2050
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesDsbrsChrtblAmt	0	0
IRS990PF/AnalysisOfRevenueAndExpenses/PensionEmplBnftAdjNetIncmAmt	0	0
IRS990PF/AnalysisOfRevenueAndExpenses/PensionEmplBnftNetInvstIncmAmt	0	0
IRS990PF/AnalysisOfRevenueAndExpenses/PrintingAndPubAdjNetIncmAmt	0	0
IRS990PF/AnalysisOfRevenueAndExpenses/PrintingAndPubNetInvstIncmAmt	0	0
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd	0	X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblAmt	0	0
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt	0	118
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesAdjNetIncmAmt	0	0
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt	0	68704
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt	0	5579
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt	0	74401
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt	0	45431
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt	0	47481
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesAdjNetIncmAmt	0	0
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt	0	5594
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt	0	5579
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt	0	11291
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingAdjNetIncmAmt	0	0
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingNetInvstIncmAmt	0	0
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt	0	2009-04-15
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt	1	2004-05-24
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt	2	2013-01-10
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt	3	2001-10-05
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt	4	2004-05-24
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt	5	2004-05-24
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt	0	716
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt	1	3543
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt	2	1011
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt	3	3926
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt	4	5003
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt	5	1199
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt	0	1084
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt	1	3157
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt	2	589
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt	3	2074
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt	4	4997
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt	5	1301
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt	6	4066
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt	0	1084
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt	1	3157
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt	2	589
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt	3	2074
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt	4	4997
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt	5	1301
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt	0	1800
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt	1	6700
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt	2	1600
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt	3	6000
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt	4	10000
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt	5	2500
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd	0	P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc	0	77.088 PNC INTERNATIONAL EQUITY FUND CLASS I FUND 409
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc	1	193.418 PNC MULTI FACTOR LARGE CAP GROWTH CLASS I FUND 411
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc	2	66.034 PNC SMALL CAP FUND CLASS I
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc	3	251.046 PNC MULTI FACTOR LARGE CAP VALUE CLASS I FUND 412
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc	4	273.075 PNC MULTI FACTOR LARGE CAP GROWTH CLASS I FUND 411
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc	5	65.462 PNC MULTI FACTOR LARGE CAP GROWTH CLASS I FUND 411
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc	6	CAPITAL GAIN DIVIDENDS
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt	0	2017-09-21
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt	1	2017-09-21
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt	2	2017-09-21
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt	3	2017-09-21
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt	4	2017-10-27
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt	5	2017-12-22
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt	0	17268
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt	0	-26920
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt	0	0
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt	0	42
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt	0	1224302
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt	0	1251180
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt	0	1224302
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt	0	0
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt	0	68730
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt	0	67102
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt	0	68730
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt	0	67899
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt	0	1628
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt	0	797
IRS990PF/DistributableAmountGrp/TotalTaxAmt	0	797
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt	0	0
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EsPenaltyAmt	0	0
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt	0	236
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExtsnRequestIncomeTaxPaidAmt	0	0
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt	0	797
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/RefundAmt	0	0
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt	0	0
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt	0	797
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt	0	797
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxDueAmt	0	561
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt	0	0
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt	0	236
IRS990PF/FMVAssetsEOYAmt	0	1383358
IRS990PF/Form990PFBalanceSheetsGrp/AcctRcvblEOYAmt	0	0
IRS990PF/Form990PFBalanceSheetsGrp/AcctRcvblEOYFMVAmt	0	0
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt	0	1251180
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt	0	1224302
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsBOYAmt	0	1000000
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYAmt	0	1000000
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYFMVAmt	0	977883
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt	0	230723
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt	0	215324
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt	0	396497
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind	0	X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt	0	0
IRS990PF/Form990PFBalanceSheetsGrp/OtherRcvblAllwncDbtflAcctAmt	0	0
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt	0	20457
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt	0	8978
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt	0	8978
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt	0	1251180
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt	0	1224302
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt	0	1383358
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt	0	0
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt	0	1251180
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt	0	1224302
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt	0	1251180
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt	0	1224302
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt	0	0
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt	0	1378657
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt	0	0
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt	0	1378657
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt	0	20680
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt	0	0
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt	0	67899
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt	0	1357977
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt	0	0
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt	0	1378657
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt	0	NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt	0	NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt	0	0
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt	0	2
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt	0	11158
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm	0	PNC BANK NA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt	0	TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt	0	PO BOX 609
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm	0	PITTSBURGH
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd	0	PA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd	0	152309738
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt	0	0
IRS990PF/Organization4947a1TrtdPFInd	0	X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt	0	70455
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt	0	70854
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt	0	74534
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt	0	70933
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt	0	72617
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt	0	76698
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt	0	68108
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt	0	0.051882
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt	0	0.054891
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt	0	0.051197
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt	0	0.050699
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt	0	0.054403
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt	0	0.048222
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd	0	false
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt	0	399
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt	0	1357977
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt	0	1357852
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt	0	1385495
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt	0	1432315
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt	0	1409812
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt	0	1412390
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt	0	68704
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt	0	0.259412
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt	0	68704
IRS990PF/QualifyingDistriPartXIIGrp/CharitableAssetsAcquisPaidAmt	0	0
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt	0	68704
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt	0	0
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt	0	0
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt	0	68704
IRS990PF/QualifyingDistriPartXIIGrp/SetAsideCashDistriTestAmt	0	0
IRS990PF/QualifyingDistriPartXIIGrp/SetAsideSuitabilityTestAmt	0	0
IRS990PF/StatementsRegardingActy4720Grp/ActsFailToQlfyAsExceptionsInd	0	false
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd	0	false
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd	0	false
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd	0	false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd	0	true
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd	0	false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd	0	false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd	0	false
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd	0	false
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd	0	false
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd	0	true
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd	0	false
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd	0	false
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd	0	false
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd	0	false
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd	0	false
IRS990PF/StatementsRegardingActy4720Grp/TransactionsFailToQlfyAsExcInd	0	false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd	0	false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd	0	false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd	0	false
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd	0	false
IRS990PF/StatementsRegardingActy4720Grp/UndistrIncmSect4942a2NotAppInd	0	false
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd	0	false
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd	0	true
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd	0	false
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd	0	true
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd	0	false
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd	0	false
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd	0	false
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd	0	true
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd	0	false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt	0	PO BOX 609
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm	0	PITTSBURGH
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd	0	PA
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd	0	152309738
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd	0	false
IRS990PF/StatementsRegardingActyGrp/NECTFilingInLieuOFForm1041Ind	0	X
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd	0	false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd	0	false
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd	0	IL
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd	0	false
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine1Txt	0	PNC BANK NA
IRS990PF/StatementsRegardingActyGrp/PhoneNum	0	2162574701
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd	0	false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd	0	true
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd	0	false
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt	0	63110
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt	0	SCHOLARSHIPS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt	0	SCHOLARSHIP RECIPIENTS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt	0	PUBLIC CHARITIES
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt	0	NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt	0	PO BOX 609
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm	0	PITTSBURGH
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd	0	PA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd	0	15230
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd	0	X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt	0	63110
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/LoansOrLoanGuaranteesInd	0	false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PerformanceOfServicesEtcInd	0	false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PurchaseOfAssetsNonchrtblEOInd	0	false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/ReimbursementArrangementsInd	0	false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RelationshipsNonchrtblEOInd	0	false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RentalOfFacilitiesOthAssetsInd	0	false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SalesOrExchangesOfAssetsInd	0	false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SharingOfFacilitiesEtcInd	0	false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd	0	false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd	0	false
IRS990PF/UndistributedIncomeGrp/AppliedToCurrentYearAmt	0	5649
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt	0	0
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt	0	63055
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt	0	0
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt	0	68730
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt	0	0
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr1Amt	0	0
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr2Amt	0	0
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr3Amt	0	0
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr4Amt	0	0
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr5Amt	0	0
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt	0	0
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt	0	0
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt	0	0
IRS990PF/UndistributedIncomeGrp/ExcessFromCurrentYearAmt	0	0
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt	0	0
IRS990PF/UndistributedIncomeGrp/ExcessFromYear2Amt	0	0
IRS990PF/UndistributedIncomeGrp/ExcessFromYear3Amt	0	0
IRS990PF/UndistributedIncomeGrp/ExcessFromYear4Amt	0	0
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt	0	0
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt	0	0
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt	0	68704
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt	0	0
IRS990PF/UndistributedIncomeGrp/Taxable1Amt	0	0
IRS990PF/UndistributedIncomeGrp/Taxable2Amt	0	0
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt	0	0
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt	0	0
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt	0	0
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt	0	0
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt	0	63081
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt	0	63055
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc	0	STATE FILING FEES
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt	0	15
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt	0	0
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt	0	15
OtherIncomeSchedule2/OtherIncomeDetail/Desc	0	REFUND OF TAXES
OtherIncomeSchedule2/OtherIncomeDetail/Desc	1	RECOVERY OF GRANTS
OtherIncomeSchedule2/OtherIncomeDetail/NetInvestmentIncomeAmt	0	0
OtherIncomeSchedule2/OtherIncomeDetail/NetInvestmentIncomeAmt	1	0
OtherIncomeSchedule2/OtherIncomeDetail/RevenueAndExpensesPerBooksAmt	0	422
OtherIncomeSchedule2/OtherIncomeDetail/RevenueAndExpensesPerBooksAmt	1	1628
OtherIncreasesSchedule/OtherIncreasesDetail/Amt	0	42
OtherIncreasesSchedule/OtherIncreasesDetail/Desc	0	COST BASIS ADJUSTMENT
TaxesSchedule/TaxesDetail/Amt	0	118
TaxesSchedule/TaxesDetail/CategoryTxt	0	FEDERAL ESTIMATES - PRINCIPAL
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt	0	0
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt	0	0
ReturnHeader/BuildTS	0	2018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/PersonNm	0	PNC BANK N A BY
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt	0	VICE PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum	0	2162574701
ReturnHeader/BusinessOfficerGrp/SignatureDt	0	2018-04-08
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt	0	CHARLES ESPLIN TUA
ReturnHeader/Filer/BusinessNameControlTxt	0	CHAR
ReturnHeader/Filer/EIN	0	366052501
ReturnHeader/Filer/PhoneNum	0	2162574701
ReturnHeader/Filer/USAddress/AddressLine1Txt	0	C/O PNC BANK NA PO BOX 609
ReturnHeader/Filer/USAddress/CityNm	0	PITTSBURGH
ReturnHeader/Filer/USAddress/StateAbbreviationCd	0	PA
ReturnHeader/Filer/USAddress/ZIPCd	0	152309738
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId	0	A3CAA5659CC950C8F6A031F3C97E712F44929D78
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId	0	3BB8C0E9FEC78F69228AD1801D614A994052CE46
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd	0	P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt	0	161.150.112.69
ReturnHeader/ReturnTs	0	2018-04-08T21:00:29-05:00
ReturnHeader/ReturnTypeCd	0	990PF
ReturnHeader/TaxPeriodBeginDt	0	2017-01-01
ReturnHeader/TaxPeriodEndDt	0	2017-12-31
ReturnHeader/TaxYr	0	2017

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,224,302
Liabilities: $0
Net assets: $1,224,302
Revenue: $47,481
Expenses: $74,401
Net income: -$26,920

	Balance Sheet			Operations
Year	Assets	Liabilities	Net Assets	Revenue	Expenses	Net Income
2024Detailed filing. Detailed filing data is available for this year.	$1.34	$0.00	$1.34	$0.01	$0.07	$0.06
2023Detailed filing. Detailed filing data is available for this year.	$1.40	$0.00	$1.40	$0.05	$0.07	$0.02
2022Detailed filing. Detailed filing data is available for this year.	$1.33	$0.00	$1.33	$0.08	$0.09	$0.01
2021Detailed filing. Detailed filing data is available for this year.	$1.34	$0.00	$1.34	$0.13	$0.07	$0.05
2020Detailed filing. Detailed filing data is available for this year.	$1.28	$0.00	$1.28	$0.03	$0.08	$0.05
2019Detailed filing. Detailed filing data is available for this year.	$1.33	$0.00	$1.33	$0.17	$0.08	$0.09
2018Detailed filing. Detailed filing data is available for this year.	$1.24	$0.00	$1.24	$0.09	$0.08	$0.02
2017Detailed filing. Detailed filing data is available for this year.	$1.22	$0.00	$1.22	$0.05	$0.07	$0.03
2016Detailed filing. Detailed filing data is available for this year.	$1.25	$0.00	$1.25	$0.03	$0.08	$0.05
2015Detailed filing. Detailed filing data is available for this year.	$1.30	$0.00	$1.30	$0.04	$0.07	$0.04
2014Detailed filing. Detailed filing data is available for this year.	$1.34	$0.00	$1.34	$0.03	$0.08	$0.05
2013Detailed filing. Detailed filing data is available for this year.	$1.38	$0.00	$1.38	$0.06	$0.08	$0.03