STRATEGY STUDIO / PUBLIC DATA EXPLORER

W CLARK HAGAN TRUST: Form 990PF, tax year 2017

View the entire original 990 at ProPublica ↗

Organization
W CLARK HAGAN TRUST (EIN 25-6070592)
Tax period
2017-01-01 to 2017-12-31
Filed
2018-04-20
IRS object ID
201811109349100916
Schema version
2017v2.2
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 ReturnHeader

FieldValueIRS element (for citing)
Return2018-04-20T17:00:41-05:00ReturnTs
Tax Period End2017-12-31TaxPeriodEndDt
Return Type990PFReturnTypeCd
Tax Period Begin2017-01-01TaxPeriodBeginDt

Filer Filer

FieldValueIRS element (for citing)
EIN256070592EIN

Business Name BusinessName

FieldValueIRS element (for citing)
Business Name Line1W CLARK HAGAN TRUSTBusinessNameLine1Txt
FieldValueIRS element (for citing)
Business Name ControlHAGABusinessNameControlTxt
Phone4127623792PhoneNum

US Address USAddress

FieldValueIRS element (for citing)
Address Line1116 ALLEGHENY CENTER MALL P8YB3502LAddressLine1Txt
CityPITTSBURGHCityNm
State AbbreviationPAStateAbbreviationCd
ZIP15212ZIPCd

Business Officer BusinessOfficerGrp

FieldValueIRS element (for citing)
PersonPNC BANK N A BYPersonNm
Person TitleVICE PRESIDENTPersonTitleTxt
Phone4127623792PhoneNum
Signature2018-04-06SignatureDt
FieldValueIRS element (for citing)
Tax2017TaxYr
Build TS2022-09-23 18:48:47ZBuildTS

Form 990-PF IRS990PF

FieldValueIRS element (for citing)
Organization4947a1 Trtd PFYes (X)Organization4947a1TrtdPFInd
FMV Assets EOY$887,770FMVAssetsEOYAmt

Analysis Of Revenue And Expenses AnalysisOfRevenueAndExpenses

FieldValueIRS element (for citing)
Schedule B Not RequiredYes (X)ScheduleBNotRequiredInd
Dividends Rev And Expnss$17,872DividendsRevAndExpnssAmt
Dividends Net Invst Incm$17,872DividendsNetInvstIncmAmt
Net Gain Sale Ast Rev And Expnss$13,516NetGainSaleAstRevAndExpnssAmt
Gross Sales Price$213,569GrossSalesPriceAmt
Cap Gain Net Incm Net Invst Incm$13,516CapGainNetIncmNetInvstIncmAmt
Net ST Capital Gain Adj Net Incm$0NetSTCapitalGainAdjNetIncmAmt
Total Rev And Expnss$31,388TotalRevAndExpnssAmt
Total Net Invst Incm$31,388TotalNetInvstIncmAmt
Comp Ofcr Dir Trst Rev And Expnss$12,296CompOfcrDirTrstRevAndExpnssAmt
Comp Ofcr Dir Trst Net Invst Incm$11,066CompOfcrDirTrstNetInvstIncmAmt
Comp Ofcr Dir Trst Dsbrs Chrtbl$1,230CompOfcrDirTrstDsbrsChrtblAmt
Oth Empl Slrs Wgs Net Invst Incm$0OthEmplSlrsWgsNetInvstIncmAmt
Oth Empl Slrs Wgs Adj Net Incm$0OthEmplSlrsWgsAdjNetIncmAmt
Oth Empl Slrs Wgs Dsbrs Chrtbl$0OthEmplSlrsWgsDsbrsChrtblAmt
Pension Empl Bnft Net Invst Incm$0PensionEmplBnftNetInvstIncmAmt
Pension Empl Bnft Adj Net Incm$0PensionEmplBnftAdjNetIncmAmt
Legal Fees Dsbrs Chrtbl$0LegalFeesDsbrsChrtblAmt
Other Prof Fees Dsbrs Chrtbl$0OtherProfFeesDsbrsChrtblAmt
Interest Dsbrs Chrtbl$0InterestDsbrsChrtblAmt
Taxes Rev And Expnss$2,216TaxesRevAndExpnssAmt
Taxes Net Invst Incm$87TaxesNetInvstIncmAmt
Taxes Dsbrs Chrtbl$0TaxesDsbrsChrtblAmt
Deprec And Dpltn Rev And Expnss$0DeprecAndDpltnRevAndExpnssAmt
Deprec And Dpltn Net Invst Incm$0DeprecAndDpltnNetInvstIncmAmt
Trav Conf Meeting Net Invst Incm$0TravConfMeetingNetInvstIncmAmt
Trav Conf Meeting Adj Net Incm$0TravConfMeetingAdjNetIncmAmt
Printing And Pub Net Invst Incm$0PrintingAndPubNetInvstIncmAmt
Printing And Pub Adj Net Incm$0PrintingAndPubAdjNetIncmAmt
Tot Opr Expenses Rev And Expnss$14,512TotOprExpensesRevAndExpnssAmt
Tot Opr Expenses Net Invst Incm$11,153TotOprExpensesNetInvstIncmAmt
Tot Opr Expenses Adj Net Incm$0TotOprExpensesAdjNetIncmAmt
Tot Opr Expenses Dsbrs Chrtbl$1,230TotOprExpensesDsbrsChrtblAmt
Contri Paid Rev And Expnss$37,607ContriPaidRevAndExpnssAmt
Contri Paid Dsbrs Chrtbl$37,607ContriPaidDsbrsChrtblAmt
Total Expenses Rev And Expnss$52,119TotalExpensesRevAndExpnssAmt
Total Expenses Net Invst Incm$11,153TotalExpensesNetInvstIncmAmt
Total Expenses Adj Net Incm$0TotalExpensesAdjNetIncmAmt
Total Expenses Dsbrs Chrtbl$38,837TotalExpensesDsbrsChrtblAmt
Excess Revenue Over Expenses-$20,731ExcessRevenueOverExpensesAmt
Net Investment Income$20,235NetInvestmentIncomeAmt
Adjusted Net Income$0AdjustedNetIncomeAmt

Form990 PF Balance Sheets Form990PFBalanceSheetsGrp

FieldValueIRS element (for citing)
Sav And Temp Cash Invst BOY$34,820SavAndTempCashInvstBOYAmt
Sav And Temp Cash Invst EOY$39,267SavAndTempCashInvstEOYAmt
Sav And Temp Cash Invst EOYFMV$39,267SavAndTempCashInvstEOYFMVAmt
Acct Rcvbl EOY$0AcctRcvblEOYAmt
Acct Rcvbl EOYFMV$0AcctRcvblEOYFMVAmt
Other Rcvbl Allwnc Dbtfl Acct$0OtherRcvblAllwncDbtflAcctAmt
Corporate Stock BOY$197,053CorporateStockBOYAmt
Corporate Stock EOY$175,258CorporateStockEOYAmt
Corporate Stock EOYFMV$222,594CorporateStockEOYFMVAmt
Other Investments BOY$578,472OtherInvestmentsBOYAmt
Other Investments EOY$575,092OtherInvestmentsEOYAmt
Other Investments EOYFMV$625,909OtherInvestmentsEOYFMVAmt
Total Assets BOY$810,345TotalAssetsBOYAmt
Total Assets EOY$789,617TotalAssetsEOYAmt
Total Assets EOYFMV$887,770TotalAssetsEOYFMVAmt
Total Liabilities EOY$0TotalLiabilitiesEOYAmt
Org Does Not Follow SFAS117Yes (X)OrgDoesNotFollowSFAS117Ind
Capital Stock BOY$807,718CapitalStockBOYAmt
Capital Stock EOY$786,763CapitalStockEOYAmt
Retained Earning BOY$2,627RetainedEarningBOYAmt
Retained Earning EOY$2,854RetainedEarningEOYAmt
Tot Net Ast Or Fund Balances BOY$810,345TotNetAstOrFundBalancesBOYAmt
Tot Net Ast Or Fund Balances EOY$789,617TotNetAstOrFundBalancesEOYAmt
Total Liabilities Net Ast BOY$810,345TotalLiabilitiesNetAstBOYAmt
Total Liabilities Net Ast EOY$789,617TotalLiabilitiesNetAstEOYAmt

Chg In Net Assets Fund Balances ChgInNetAssetsFundBalancesGrp

FieldValueIRS element (for citing)
Tot Net Ast Or Fund Balances BOY$810,345TotNetAstOrFundBalancesBOYAmt
Excess Revenue Over Expenses-$20,731ExcessRevenueOverExpensesAmt
Other Increases$3OtherIncreasesAmt
Subtotal$789,617SubtotalAmt
Other Decreases$0OtherDecreasesAmt
Tot Net Ast Or Fund Balances EOY$789,617TotNetAstOrFundBalancesEOYAmt

Cap Gains Loss Tx Invst Incm Detail CapGainsLossTxInvstIncmDetail

Cap Gains Loss Tx Invst Incm CapGainsLossTxInvstIncmGrp (224 entries)

PropertyPropertyDescAcquiredAcquiredDtSoldSoldDtGross Sales PriceGrossSalesPriceAmtCost Or Other BasisCostOrOtherBasisAmtGain Or LossGainOrLossAmtGains Minus Excess Or LossesGainsMinusExcessOrLossesAmtHow AcquiredHowAcquiredCd
99. ISHARES MSCI EMERGING MKTS INDEX FUND2014-06-172017-01-01$3,472$4,293-$821-$821
74. SECTOR SPDR TR SBI INT-TECH2016-10-062017-01-01$3,582$3,534$48$48
75. SECTOR SPDR TR SHS BEN INT-UTILITIES2016-10-312017-01-01$3,658$3,707-$49-$49
4. GENERAL DYNAMICS CORP2016-10-062017-01-12$706$616$90$90
7. HONEYWELL INTL INC2016-10-062017-01-12$823$810$13$13
3. NORTHROP GRUMMAN CORPORATION2016-10-062017-01-12$688$645$43$43
53. PFIZER INC COM2016-10-062017-01-27$1,666$1,781-$115-$115
40. SCHLUMBERGER LTD COM2016-10-062017-01-27$3,396$3,258$138$138
57. INDUSTRIAL SELECT SECTOR SPDR ETF LARGE CAP2016-12-302017-01-31$3,599$3,557$42$42
16. VULCAN MATERIALS CO2016-10-062017-02-13$1,986$1,762$224$224
6. BIOVERATIV INC-W/I2016-10-062017-02-17$276$290-$14-$14
66. GENERAL ELEC CO COM2016-10-062017-02-17$2,001$1,933$68$68
33. DICK'S SPORTING GOODS, INC.2016-10-062017-03-13$1,553$1,909-$356-$356
67. PFIZER INC COM2016-10-062017-03-13$2,276$2,246$30$30
47. SECTOR SPDR TR SBI INT-ENERGY2016-12-302017-03-31$3,282$3,555-$273-$273
1. CINTAS CORP2016-10-142017-04-07$123$110$13$13
23. CINTAS CORP2016-10-062017-04-07$2,828$2,569$259$259
11. O REILLY AUTOMOTIVE INC2016-10-062017-04-07$2,807$3,041-$234-$234
18. JOHNSON & JOHNSON COM2016-10-062017-04-21$2,195$2,136$59$59
566.546 T ROWE PRICE REAL ESTATE FUND FD 1222016-07-142017-04-27$15,954$17,132-$1,178-$1,178
11.677 T ROWE PRICE REAL ESTATE FUND FD 1222016-11-162017-04-27$329$320$9$9
22. ISHARES TR S&P MIDCAP 4002017-03-312017-04-28$3,806$3,776$30$30
35. VANTIV INC CLASS A NAME CHG 01/16/182016-10-062017-04-28$2,161$1,991$170$170
71. VERIZON COMMUNICATIONS COM2016-10-062017-04-28$3,286$3,569-$283-$283
49. HD SUPPLY HOLDINGS INC2017-01-122017-05-25$2,024$2,094-$70-$70
15. LAM RESEARCH CORP2016-10-062017-05-25$2,310$1,494$816$816
53. ISHARES TR S&P SMLCAP 6002016-12-302017-05-31$3,603$3,647-$44-$44
48. DEVON ENERGY CORP NEW2016-10-062017-06-02$1,614$2,098-$484-$484
9. SIMON PROPERTY GROUP INC2016-10-062017-06-02$1,394$1,773-$379-$379
20. ACCENTURE PLC CLASS A SEDOL B4BNMY32016-10-062017-06-14$2,551$2,375$176$176
49. APPLIED MATERIALS INC2016-10-062017-06-19$2,159$1,463$696$696
16. EQUIFAX INC2016-10-062017-06-19$2,288$2,118$170$170
4. LAM RESEARCH CORP2016-10-062017-06-19$602$398$204$204
48. NIKE INC CL B2016-10-062017-06-19$2,468$2,502-$34-$34
35. NUCOR CORP2017-02-132017-06-19$1,988$2,224-$236-$236
40. NORTHERN TRUST CORP2016-10-062017-07-28$3,490$2,878$612$612
91. ISHARES MSCI EMERGING MKTS INDEX FUND2014-06-172017-07-31$3,976$3,946$30$30
1. SECTOR SPDR TR SBI INT-TECH2017-04-282017-07-31$57$54$3$3
37. DISNEY WALT CO2016-10-062017-08-18$3,741$3,435$306$306
49. WELLS FARGO & CO NEW COM2016-10-062017-08-25$2,551$2,218$333$333
57. INDUSTRIAL SELECT SECTOR SPDR ETF LARGE CAP2017-07-312017-08-31$3,896$3,907-$11-$11
39. KRAFT HEINZ CO/THE2016-10-062017-09-01$3,137$3,430-$293-$293
41. DR PEPPER SNAPPLE GROUP INC2016-10-062017-09-29$3,631$3,610$21$21
5. ABBOTT LABORATORIES INC2016-10-062017-10-06$273$215$58$58
16.352 CAMBIAR INTL EQUITY FUND-INS2016-12-202017-10-06$458$397$61$61
2. AETNA INC NEW2016-10-062017-10-06$323$228$95$95
4. AGILENT TECHNOLOGIES (IPO)2017-08-182017-10-06$265$243$22$22
1. ALPHABET INC/CA-CL A2016-10-142017-10-06$992$809$183$183
3. ALTRIA GROUP INC2016-10-062017-10-06$187$185$2$2
3. AMERICAN WATER WORKS CO INC2016-10-062017-10-06$248$213$35$35
2. AMGEN INC2016-10-062017-10-06$372$334$38$38
4. ANALOG DEVICES INC2017-09-012017-10-06$350$339$11$11
6. APPLE INC2017-04-282017-10-06$930$862$68$68
5. APPLIED MATERIALS INC2016-10-062017-10-06$260$149$111$111
8.351 ARTISAN INTERNATIONAL FD-ADV2009-10-192017-10-06$270$176$94$94
37.176 ARTISAN INTERNATIONAL FD-ADV2016-10-142017-10-06$1,203$1,006$197$197
100.694 BAIRD MIDCAP INST2016-10-062017-10-06$1,931$1,581$350$350
4. BANK NEW YORK MELLON CORP COM2016-10-062017-10-06$218$163$55$55
5. BERRY GLOBAL GROUP INC2016-10-142017-10-06$296$221$75$75
1. BIOGEN INC2017-02-172017-10-06$328$290$38$38
6. BORG WARNER INC.2017-09-292017-10-06$311$307$4$4
3. BURLINGTON STORES INC2017-03-132017-10-06$279$282-$3-$3
3. CBS CORP CLASS B WI2016-10-062017-10-06$174$170$4$4
5. CSX CORP COM2017-06-192017-10-06$261$267-$6-$6
5. CISCO SYS INC COM2016-10-062017-10-06$168$158$10$10
4. CITIGROUP INC2017-07-282017-10-06$302$270$32$32
9. CITIZENS FINANCIAL GROUP2016-11-112017-10-06$337$268$69$69
10. COMCAST CORPORATION CL A2016-10-062017-10-06$380$329$51$51
2. CONSTELLATION BRANDS INC CL A2016-10-062017-10-06$417$341$76$76
1. CUMMINS INC2017-02-172017-10-06$172$151$21$21
8. XTRACKERS MSCI JAPAN HEDGED ETF2016-10-062017-10-06$326$268$58$58
5. DOWDUPONT INC2016-10-142017-10-06$355$269$86$86
2. EDWARDS LIFESCIENCES CORP2016-10-062017-10-06$222$240-$18-$18
1. EXXON MOBIL CORP2016-10-062017-10-06$81$87-$6-$6
4. FACEBOOK INC A2016-10-062017-10-06$685$516$169$169
1. GENERAL DYNAMICS CORP2016-10-062017-10-06$212$154$58$58
5. HALLIBURTON CO2017-01-272017-10-06$224$290-$66-$66
48.559 HARDING LOEVNER INTERNATIONAL EQUITY PORTFOLIO2016-10-062017-10-06$1,082$917$165$165
2. HOME DEPOT INC COM2016-10-062017-10-06$332$259$73$73
1. HONEYWELL INTL INC2016-10-062017-10-06$143$116$27$27
2. ILLINOIS TOOL WORKS INC COM2016-10-062017-10-06$303$239$64$64
5. INTEL CORP2016-10-062017-10-06$198$190$8$8
69. ISHARES MSCI EMERGING MKTS INDEX FUND2017-08-312017-10-06$3,144$3,095$49$49
2. ISHARES TR S&P SMLCP GROW2016-10-062017-10-06$333$274$59$59
22. ISHARES EDGE MSCI USA QUALITY FACTOR ETF2017-04-282017-10-06$1,719$1,612$107$107
12. ISHARES EDGE MSCI USA VALUE FACTOR ETF2016-10-062017-10-06$943$787$156$156
8. J P MORGAN CHASE & CO COM2016-10-062017-10-06$775$542$233$233
2. JOHNSON & JOHNSON COM2016-10-062017-10-06$266$237$29$29
2. LAM RESEARCH CORP2016-10-062017-10-06$367$199$168$168
3. LAUDER ESTEE COS INC CL A2017-09-292017-10-06$328$325$3$3
29.201 MAINSTAY EPOCH GLOBAL EQUITY YIELD FUND CLASS I2013-10-042017-10-06$569$561$8$8
2. MCDONALDS CORP COM2017-07-282017-10-06$320$311$9$9
3. MICROSOFT CORP2016-10-062017-10-06$227$173$54$54
2. MOHAWK INDS INC2017-08-182017-10-06$513$497$16$16
6. MORGAN STANLEY2016-10-212017-10-06$298$198$100$100
1. NORTHROP GRUMMAN CORPORATION2016-10-062017-10-06$293$215$78$78
1. PARKER HANNIFIN CORP2017-04-072017-10-06$177$161$16$16
5. PEPSICO INC COM2016-10-062017-10-06$550$532$18$18
3. PRICE T ROWE GROUP INC COM2017-08-252017-10-06$275$252$23$23
5. PROLOGIS INC2017-06-022017-10-06$321$284$37$37
2. RAYTHEON COMPANY2016-10-062017-10-06$375$276$99$99
.748 ROWE T PRICE VALUE FD INC COM2016-10-062017-10-06$29$25$4$4
3. S&P GLOBAL INC2016-10-062017-10-06$475$375$100$100
10. AMEX FINANCIAL SELECT SPDR2017-01-312017-10-06$263$235$28$28
3. SECTOR SPDR TR SBI INT-TECH2017-04-282017-10-06$179$163$16$16
3. STATE STR CORP COM2016-10-062017-10-06$296$217$79$79
2. STRYKER CORP2017-03-132017-10-06$297$262$35$35
6. SUNTRUST BANKS INC COM2016-10-062017-10-06$365$275$90$90
4. T-MOBILE US INC2017-04-282017-10-06$249$270-$21-$21
34.824 TEMPLETON INSTL FDS INC FOREIGN EQUITY SER2016-10-062017-10-06$770$664$106$106
4. TEXAS INSTRS INC COM2016-10-062017-10-06$364$283$81$81
1. THERMO ELECTRON CORP COM2016-10-062017-10-06$192$158$34$34
6. TOTAL FINA S A2016-10-062017-10-06$320$291$29$29
5. TRANSCANADA CORP (HOLDING CO)2017-06-022017-10-06$245$234$11$11
1. UNITED RENTALS INC COM2017-05-252017-10-06$142$112$30$30
2. UNITEDHEALTH GROUP INC COM2017-01-272017-10-06$397$327$70$70
3. VALERO ENERGY CORP NEW COM2016-12-092017-10-06$231$204$27$27
3. VISA INC CLASS A SHARES2016-10-062017-10-06$320$250$70$70
5. WEC ENERGY GROUP INC2016-10-062017-10-06$320$286$34$34
154.074 WASATCH INTL OPPORTUNIT-INST2016-10-062017-10-06$539$495$44$44
51. WISDOMTREE U.S. QUALITY DIVI ETF2016-10-062017-10-06$1,964$1,644$320$320
2. WYNDHAM WORLDWIDE CORP2016-10-062017-10-06$214$134$80$80
2. INGERSOLL-RAND PLC SEDOL: B6330302016-10-062017-10-06$183$137$46$46
4. TE CONNECTIVITY LTD SEDOL B62B7C3 ISIN CH01029931822017-06-192017-10-06$343$318$25$25
3. ROYAL CARRIBEAN CRUISES LTD SEDOL 2754907 ISIN LR00088628682017-04-072017-10-06$369$294$75$75
55. CSX CORP COM2017-06-192017-10-20$2,995$2,940$55$55
22. EXXON MOBIL CORP2016-10-062017-10-20$1,819$1,921-$102-$102
18. ISHARES MSCI EMERGING MKTS INDEX FUND2017-08-312017-10-31$830$807$23$23
67. ISHARES MSCI EMERGING MKTS INDEX FUND2014-06-172017-10-31$3,090$2,905$185$185
2. SECTOR SPDR TR SBI INT-TECH2017-04-282017-10-31$125$109$16$16
28. VALERO ENERGY CORP NEW COM2016-12-092017-11-03$2,267$1,901$366$366
27. INGERSOLL-RAND PLC SEDOL: B6330302016-10-062017-11-03$2,325$1,843$482$482
4. AETNA INC NEW2016-10-062017-11-10$688$456$232$232
24. EDWARDS LIFESCIENCES CORP2016-10-062017-11-10$2,486$2,872-$386-$386
2. ABBOTT LABORATORIES INC2016-10-062017-11-14$110$86$24$24
11.415 CAMBIAR INTL EQUITY FUND-INS2016-12-202017-11-14$321$277$44$44
1. AETNA INC NEW2016-10-062017-11-14$171$114$57$57
3. AGILENT TECHNOLOGIES (IPO)2017-08-182017-11-14$203$182$21$21
2. ALTRIA GROUP INC2016-10-062017-11-14$132$123$9$9
1. AMERICAN WATER WORKS CO INC2016-10-062017-11-14$90$71$19$19
1. AMGEN INC2016-10-062017-11-14$169$167$2$2
2. ANALOG DEVICES INC2017-09-012017-11-14$179$169$10$10
3. APPLE INC2017-04-282017-11-14$519$431$88$88
2. APPLIED MATERIALS INC2016-10-062017-11-14$113$60$53$53
17.379 ARTISAN INTERNATIONAL FD-ADV2009-10-192017-11-14$570$366$204$204
31.571 BAIRD MIDCAP INST2016-10-062017-11-14$603$496$107$107
3. BANK NEW YORK MELLON CORP COM2016-10-062017-11-14$155$122$33$33
3. BERRY GLOBAL GROUP INC2016-10-142017-11-14$175$133$42$42
1. BIOGEN INC2016-10-062017-11-14$312$282$30$30
57.995 BLACKROCK STRATEGIC INCOME OPPORTUNITIES PORTFOLIO2017-10-062017-11-14$575$579-$4-$4
4. BORG WARNER INC.2017-09-292017-11-14$208$205$3$3
2. BURLINGTON STORES INC2017-03-132017-11-14$194$188$6$6
2. CBS CORP CLASS B WI2016-10-062017-11-14$112$113-$1-$1
2. CISCO SYS INC COM2016-10-062017-11-14$68$63$5$5
2. CITIGROUP INC2017-07-282017-11-14$143$135$8$8
5. CITIZENS FINANCIAL GROUP2016-11-112017-11-14$190$149$41$41
6. COMCAST CORPORATION CL A2016-10-062017-11-14$221$197$24$24
2. CONOCOPHILLIPS2017-11-032017-11-14$103$106-$3-$3
2. CONSTELLATION BRANDS INC CL A2016-10-062017-11-14$438$341$97$97
1. CUMMINS INC2017-02-172017-11-14$169$151$18$18
18. XTRACKERS MSCI JAPAN HEDGED ETF2016-10-062017-11-14$775$603$172$172
18. XTRACKERS MSCI EUROPE HEDGED ETF2017-10-062017-11-14$510$515-$5-$5
13. XTRACKERS MSCI EUROPE HEDGED ETF2017-04-272017-11-14$369$359$10$10
2. DOWDUPONT INC2016-10-142017-11-14$138$107$31$31
2. FACEBOOK INC A2016-10-062017-11-14$356$258$98$98
1. GENERAL DYNAMICS CORP2016-10-062017-11-14$200$154$46$46
2. HALLIBURTON CO2017-01-272017-11-14$87$116-$29-$29
17.301 HARDING LOEVNER INTERNATIONAL EQUITY PORTFOLIO2016-10-062017-11-14$392$327$65$65
2. HOME DEPOT INC COM2016-10-062017-11-14$332$259$73$73
1. HONEYWELL INTL INC2016-10-062017-11-14$147$116$31$31
1. ILLINOIS TOOL WORKS INC COM2016-10-062017-11-14$158$119$39$39
2. INTEL CORP2016-10-062017-11-14$91$76$15$15
9. ISHARES TIPS BOND ETF2016-10-062017-11-14$1,023$1,041-$18-$18
26. ISHARES CORE US AGGREGATE BOND ETF2016-10-062017-11-14$2,835$2,901-$66-$66
15. ISHARES MSCI EMERGING MKTS INDEX FUND2014-06-172017-11-14$688$650$38$38
2. ISHARES TR S&P SMLCAP 6002017-10-312017-11-14$147$150-$3-$3
1. ISHARES TR S&P SMLCP VALU2016-10-062017-11-14$146$124$22$22
1. ISHARES TR S&P SMLCP GROW2016-10-062017-11-14$163$137$26$26
29. ISHARES EDGE MSCI USA QUALITY FACTOR ETF2016-10-062017-11-14$2,314$1,950$364$364
18. ISHARES EDGE MSCI USA VALUE FACTOR ETF2016-10-062017-11-14$1,431$1,181$250$250
4. J P MORGAN CHASE & CO COM2016-10-062017-11-14$389$271$118$118
1. LAUDER ESTEE COS INC CL A2017-09-292017-11-14$126$108$18$18
68.805 MAINSTAY EPOCH GLOBAL EQUITY YIELD FUND CLASS I2013-10-042017-11-14$1,354$1,269$85$85
1. MCDONALDS CORP COM2017-07-282017-11-14$168$156$12$12
2. MICROSOFT CORP2016-10-062017-11-14$168$116$52$52
3. MORGAN STANLEY2016-10-212017-11-14$145$99$46$46
1. PARKER HANNIFIN CORP2017-04-072017-11-14$180$161$19$19
2. PEPSICO INC COM2016-10-062017-11-14$230$213$17$17
5. PFIZER INC COM2017-11-102017-11-14$178$175$3$3
1. PRICE T ROWE GROUP INC COM2017-08-252017-11-14$94$84$10$10
3. PROLOGIS INC2017-06-022017-11-14$200$171$29$29
14.918 ROWE T PRICE VALUE FD INC COM2016-10-062017-11-14$577$495$82$82
2. ROYAL DUTCH SHELL PLC ADR A2017-10-202017-11-14$128$122$6$6
1. S&P GLOBAL INC2016-10-062017-11-14$159$125$34$34
3. AMEX FINANCIAL SELECT SPDR2017-01-312017-11-14$78$70$8$8
4. SECTOR SPDR TR SBI INT-TECH2017-04-282017-11-14$253$218$35$35
1. STANLEY BLACK & DECKER INC2017-11-032017-11-14$164$163$1$1
2. STATE STR CORP COM2016-10-062017-11-14$183$145$38$38
3. SUNTRUST BANKS INC COM2016-10-062017-11-14$173$137$36$36
2. T-MOBILE US INC2017-04-282017-11-14$113$135-$22-$22
26.559 TEMPLETON GLOBAL BOND FUND AD FUND2013-10-042017-11-14$319$346-$27-$27
21.598 TEMPLETON INSTL FDS INC FOREIGN EQUITY SER2016-10-062017-11-14$480$412$68$68
3. TEXAS INSTRS INC COM2016-10-062017-11-14$290$212$78$78
1. THERMO ELECTRON CORP COM2016-10-062017-11-14$190$158$32$32
3. TOTAL FINA S A2016-10-062017-11-14$166$145$21$21
2. TRANSCANADA CORP (HOLDING CO)2017-06-022017-11-14$99$94$5$5
6. TYSON FDS INC COM2016-10-062017-11-14$458$447$11$11
1. UNITED RENTALS INC COM2017-05-252017-11-14$145$112$33$33
1. UNITEDHEALTH GROUP INC COM2017-01-272017-11-14$212$164$48$48
244.441 VANGUARD TOTL BD MKT IDX-ADM2016-10-062017-11-14$2,628$2,689-$61-$61
2. VISA INC CLASS A SHARES2016-10-062017-11-14$223$167$56$56
78.319 VIRTUS SEIX FLOATING RATE HIGH INCOME FUND CLASS I2017-10-062017-11-14$681$683-$2-$2
3. WEC ENERGY GROUP INC2016-10-062017-11-14$207$172$35$35
59.578 WASATCH INTL OPPORTUNIT-INST2016-10-062017-11-14$208$191$17$17
8.338 WELLS FARGO SPECIAL US MID CAP VALUE I2017-10-062017-11-14$319$323-$4-$4
1.657 WELLS FARGO SPECIAL US MID CAP VALUE I2016-10-062017-11-14$63$56$7$7
52. WISDOMTREE U.S. QUALITY DIVI ETF2016-10-062017-11-14$2,050$1,676$374$374
2. WYNDHAM WORLDWIDE CORP2016-10-062017-11-14$212$134$78$78
3. TE CONNECTIVITY LTD SEDOL B62B7C3 ISIN CH01029931822017-06-192017-11-14$279$238$41$41
1. ROYAL CARRIBEAN CRUISES LTD SEDOL 2754907 ISIN LR00088628682017-04-072017-11-14$123$98$25$25
51. ISHARES TR S&P SMLCAP 6002017-10-312017-11-30$3,960$3,818$142$142
144. AMEX FINANCIAL SELECT SPDR2017-01-312017-11-30$3,970$3,353$617$617
43. ABBOTT LABORATORIES INC2016-10-062017-12-08$2,340$1,842$498$498
CAPITAL GAIN DIVIDENDS$3,057P
FieldValueIRS element (for citing)
Capital Gain Net Income$13,516CapitalGainNetIncomeAmt

Qlfy Und Sect4940e Reduced Tax QlfyUndSect4940eReducedTaxGrp

FieldValueIRS element (for citing)
Liable Section4942 TaxfalseLiableSection4942TaxInd
Adjusted Qlfy Distri Yr1$37,950AdjustedQlfyDistriYr1Amt
Net Vl Noncharitable Assets Yr1$801,590NetVlNoncharitableAssetsYr1Amt
Distribution Yr10.047343DistributionYr1Rt
Adjusted Qlfy Distri Yr2$40,537AdjustedQlfyDistriYr2Amt
Net Vl Noncharitable Assets Yr2$835,831NetVlNoncharitableAssetsYr2Amt
Distribution Yr20.048499DistributionYr2Rt
Adjusted Qlfy Distri Yr3$37,017AdjustedQlfyDistriYr3Amt
Net Vl Noncharitable Assets Yr3$843,073NetVlNoncharitableAssetsYr3Amt
Distribution Yr30.043907DistributionYr3Rt
Adjusted Qlfy Distri Yr4$35,950AdjustedQlfyDistriYr4Amt
Net Vl Noncharitable Assets Yr4$790,922NetVlNoncharitableAssetsYr4Amt
Distribution Yr40.045453DistributionYr4Rt
Adjusted Qlfy Distri Yr5$36,376AdjustedQlfyDistriYr5Amt
Net Vl Noncharitable Assets Yr5$743,383NetVlNoncharitableAssetsYr5Amt
Distribution Yr50.048933DistributionYr5Rt
Total Distribution0.234135TotalDistributionRt
Average Distribution0.046827AverageDistributionRt
Net Vl Noncharitable Assets$849,910NetVlNoncharitableAssetsAmt
Adj Net Vl Noncharitable Assets$39,799AdjNetVlNoncharitableAssetsAmt
Net Investment Income Pct$202NetInvestmentIncomePctAmt
Adj Nonchrtbl Net Invst Incm Pct$40,001AdjNonchrtblNetInvstIncmPctAmt
Qualifying Distributions$38,837QualifyingDistributionsAmt

Excise Tax Based On Invst Incm ExciseTaxBasedOnInvstIncmGrp

FieldValueIRS element (for citing)
Investment Income Excise Tax$405InvestmentIncomeExciseTaxAmt
Tax Under Section511$0TaxUnderSection511Amt
Subtotal$405SubtotalAmt
Subtitle A Tax$0SubtitleATaxAmt
Tax Based On Investment Income$405TaxBasedOnInvestmentIncomeAmt
Estimated Plus Ovpmt Incm Tx$1,264EstimatedPlusOvpmtIncmTxAmt
Extsn Request Income Tax Paid$0ExtsnRequestIncomeTaxPaidAmt
Total Payments And Credits$1,264TotalPaymentsAndCreditsAmt
Es Penalty$0EsPenaltyAmt
Overpayment$859OverpaymentAmt
Applied To ES Tax$408AppliedToESTaxAmt
Refund$451RefundAmt

Statements Regarding Acty StatementsRegardingActyGrp

FieldValueIRS element (for citing)
Legislative Political ActyfalseLegislativePoliticalActyInd
More Than100 SpentfalseMoreThan100SpentInd
Form1120 POL FiledfalseForm1120POLFiledInd
Activities Not Previously RptfalseActivitiesNotPreviouslyRptInd
Changes To Articles Or BylawsfalseChangesToArticlesOrBylawsInd
Unrelated Bus Incm Over LimitfalseUnrelatedBusIncmOverLimitInd
Organization Dissolved EtcfalseOrganizationDissolvedEtcInd
Section508e Rqr SatisfiedYes (true)Section508eRqrSatisfiedInd
At Least5000 In AssetsYes (true)AtLeast5000InAssetsInd
Org Report Or Register StatePAOrgReportOrRegisterStateCd
Form990 PF Filed With Atty GenYes (true)Form990PFFiledWithAttyGenInd
Private Operating FoundationfalsePrivateOperatingFoundationInd
New Substantial ContributorsfalseNewSubstantialContributorsInd
Own Controlled EntityfalseOwnControlledEntityInd
Donor Advised FundfalseDonorAdvisedFundInd
Comply With Public Insp RqrYes (true)ComplyWithPublicInspRqrInd
Website AddressSEE FOOTNOTEWebsiteAddressTxt

Persons With Books Name PersonsWithBooksName

FieldValueIRS element (for citing)
Business Name Line1PNC BANK NABusinessNameLine1Txt
FieldValueIRS element (for citing)
Phone4127623792PhoneNum

Location Of Books US Address LocationOfBooksUSAddress

FieldValueIRS element (for citing)
Address Line1116 ALLEGHENY CENTER MALLAddressLine1Txt
CityPITTSBURGHCityNm
State AbbreviationPAStateAbbreviationCd
ZIP15212ZIPCd
FieldValueIRS element (for citing)
NECT Filing In Lieu OF Form1041Yes (X)NECTFilingInLieuOFForm1041Ind
Foreign Accounts QuestionfalseForeignAccountsQuestionInd

Statements Regarding Acty4720 StatementsRegardingActy4720Grp

FieldValueIRS element (for citing)
Sale Or Exch Disqualified PrsnfalseSaleOrExchDisqualifiedPrsnInd
Brrw Or Lend Disqualified PrsnfalseBrrwOrLendDisqualifiedPrsnInd
Furn Goods Disqualified PrsnfalseFurnGoodsDisqualifiedPrsnInd
Pay Comp Disqualified PrsnYes (true)PayCompDisqualifiedPrsnInd
Transfer Ast Disqualified PrsnfalseTransferAstDisqualifiedPrsnInd
Payment To Government OfficialfalsePaymentToGovernmentOfficialInd
Acts Fail To Qlfy As ExceptionsfalseActsFailToQlfyAsExceptionsInd
Uncorrected Prior ActsfalseUncorrectedPriorActsInd
Undistributed Income PYfalseUndistributedIncomePYInd
Business HoldingsfalseBusinessHoldingsInd
Jeopardy InvestmentsfalseJeopardyInvestmentsInd
Uncorrected PY Jeopardy InvstfalseUncorrectedPYJeopardyInvstInd
Influence LegislationfalseInfluenceLegislationInd
Influence ElectionfalseInfluenceElectionInd
Grants To IndividualsfalseGrantsToIndividualsInd
Grants To OrganizationsfalseGrantsToOrganizationsInd
Noncharitable PurposefalseNoncharitablePurposeInd
Rcv Fnds To Pay Prsnl Bnft CntrctfalseRcvFndsToPayPrsnlBnftCntrctInd
Pay Premiums Prsnl Bnft CntrctfalsePayPremiumsPrsnlBnftCntrctInd
Prohibited Tax Shelter TransfalseProhibitedTaxShelterTransInd

Officer Dir Trst Key Empl Info OfficerDirTrstKeyEmplInfoGrp

Officer Dir Trst Key Empl OfficerDirTrstKeyEmplGrp

Business Name BusinessName

FieldValueIRS element (for citing)
Business Name Line1PNC BANKNABusinessNameLine1Txt

US Address USAddress

FieldValueIRS element (for citing)
Address Line1116 Allegheny Center MallAddressLine1Txt
CityPITTSBURGHCityNm
State AbbreviationPAStateAbbreviationCd
ZIP15212ZIPCd
FieldValueIRS element (for citing)
TitleTRUSTEETitleTxt
Average Hrs Per Wk Devoted To Pos2AverageHrsPerWkDevotedToPosRt
Compensation$12,296CompensationAmt
FieldValueIRS element (for citing)
Comp Of Hghst Pd Empl Or NONENONECompOfHghstPdEmplOrNONETxt
Other Employee Paid Over50k0OtherEmployeePaidOver50kCnt
Comp Of Hghst Pd Cntrct Or NONENONECompOfHghstPdCntrctOrNONETxt
Contractor Paid Over50k0ContractorPaidOver50kCnt
FieldValueIRS element (for citing)
Summary Of Direct Chrtbl ActySummaryOfDirectChrtblActyGrp
Sum Of Program Related InvstSumOfProgramRelatedInvstGrp

Minimum Investment Return MinimumInvestmentReturnGrp

FieldValueIRS element (for citing)
Average Monthly FMV Of Sec$862,857AverageMonthlyFMVOfSecAmt
Average Monthly Cash Balances-$4AverageMonthlyCashBalancesAmt
FMV All Other Noncharitable Ast$0FMVAllOtherNoncharitableAstAmt
Total FMV Of Unused Assets$862,853TotalFMVOfUnusedAssetsAmt
Reduction Claimed$0ReductionClaimedAmt
Acquisition Indebtedness$0AcquisitionIndebtednessAmt
Adjusted Total FMV Of Unused Ast$862,853AdjustedTotalFMVOfUnusedAstAmt
Cash Deemed Charitable$12,943CashDeemedCharitableAmt
Net Vl Noncharitable Assets$849,910NetVlNoncharitableAssetsAmt
Minimum Investment Return$42,496MinimumInvestmentReturnAmt

Distributable Amount DistributableAmountGrp

FieldValueIRS element (for citing)
Minimum Investment Return$42,496MinimumInvestmentReturnAmt
Tax Based On Investment Income$405TaxBasedOnInvestmentIncomeAmt
Total Tax$405TotalTaxAmt
Distributable Before Adj$42,091DistributableBeforeAdjAmt
Recoveries Qualfied Distri$0RecoveriesQualfiedDistriAmt
Distributable Before Ded$42,091DistributableBeforeDedAmt
Deduction From Distributable$0DeductionFromDistributableAmt
Distributable As Adjusted$42,091DistributableAsAdjustedAmt

Qualifying Distri Part XII QualifyingDistriPartXIIGrp

FieldValueIRS element (for citing)
Expenses And Contributions$38,837ExpensesAndContributionsAmt
Program Related Invst Total$0ProgramRelatedInvstTotalAmt
Charitable Assets Acquis Paid$0CharitableAssetsAcquisPaidAmt
Set Aside Suitability Test$0SetAsideSuitabilityTestAmt
Set Aside Cash Distri Test$0SetAsideCashDistriTestAmt
Qualifying Distributions$38,837QualifyingDistributionsAmt
Pct Sect4940e Org Net Invst Incm$0PctSect4940eOrgNetInvstIncmAmt
Adjusted Qualifying Distri$38,837AdjustedQualifyingDistriAmt

Undistributed Income UndistributedIncomeGrp

FieldValueIRS element (for citing)
Distributable As Adjusted$42,091DistributableAsAdjustedAmt
Undistributed Income PY$37,607UndistributedIncomePYAmt
Total For Prior Years$0TotalForPriorYearsAmt
Excess Distribution Cyov Yr5$0ExcessDistributionCyovYr5Amt
Excess Distribution Cyov Yr4$0ExcessDistributionCyovYr4Amt
Excess Distribution Cyov Yr3$0ExcessDistributionCyovYr3Amt
Excess Distribution Cyov Yr2$0ExcessDistributionCyovYr2Amt
Excess Distribution Cyov Yr1$0ExcessDistributionCyovYr1Amt
Total Excess Distribution Cyov$0TotalExcessDistributionCyovAmt
Qualifying Distributions$38,837QualifyingDistributionsAmt
Applied To Year1$37,607AppliedToYear1Amt
Applied To Prior Years$0AppliedToPriorYearsAmt
Treated As Distri From Corpus$0TreatedAsDistriFromCorpusAmt
Applied To Current Year$1,230AppliedToCurrentYearAmt
Remaining Distri From Corpus$0RemainingDistriFromCorpusAmt
Excess Distri Cyov App CY Corpus$0ExcessDistriCyovAppCYCorpusAmt
Excess Distribution Cyov App CY$0ExcessDistributionCyovAppCYAmt
Total Corpus$0TotalCorpusAmt
Prior Year Undistributed Incm$0PriorYearUndistributedIncmAmt
Prior Year Deficiency Or Tax$0PriorYearDeficiencyOrTaxAmt
Taxable1$0Taxable1Amt
Taxable2$0Taxable2Amt
Undistributed Income CY$40,861UndistributedIncomeCYAmt
Corpus Distri170b1 E Or4942g3$0CorpusDistri170b1EOr4942g3Amt
Excess Distri Cyov From Yr5$0ExcessDistriCyovFromYr5Amt
Excess Distri Cyov To Next Yr$0ExcessDistriCyovToNextYrAmt
Excess From Year4$0ExcessFromYear4Amt
Excess From Year3$0ExcessFromYear3Amt
Excess From Year2$0ExcessFromYear2Amt
Excess From Year1$0ExcessFromYear1Amt
Excess From Current Year$0ExcessFromCurrentYearAmt

Supplementary Information SupplementaryInformationGrp

Application Submission Info ApplicationSubmissionInfoGrp

FieldValueIRS element (for citing)
Recipient PersonPNC CHARITABLE TRUST GRANT REVIEW CRecipientPersonNm

Recipient US Address RecipientUSAddress

FieldValueIRS element (for citing)
Address Line1THE TOWER AT PNC PLAZA 300 FIFTH AAddressLine1Txt
CityPITTSBURGHCityNm
State AbbreviationPAStateAbbreviationCd
ZIP15222ZIPCd
FieldValueIRS element (for citing)
Recipient Phone4127625157RecipientPhoneNum
Form And Info And MaterialsPlease reference the name of the trust in all communications See footnoteFormAndInfoAndMaterialsTxt
Submission DeadlinesSee footnoteSubmissionDeadlinesTxt
Restrictions On AwardsSee footnoteRestrictionsOnAwardsTxt

Grant Or Contribution Pd Dur Yr GrantOrContributionPdDurYrGrp

Recipient Business Name RecipientBusinessName

FieldValueIRS element (for citing)
Business Name Line1The Baltimore IncBusinessNameLine1Txt

Recipient US Address RecipientUSAddress

FieldValueIRS element (for citing)
Address Line1140 WEST STREETAddressLine1Txt
CityBaltimoreCityNm
State AbbreviationMDStateAbbreviationCd
ZIP21230ZIPCd
FieldValueIRS element (for citing)
Recipient RelationshipNONERecipientRelationshipTxt
Recipient Foundation StatusPCRecipientFoundationStatusTxt
Grant Or Contribution PurposeGENERAL SUPPORTGrantOrContributionPurposeTxt
Amt$37,607Amt
FieldValueIRS element (for citing)
Total Grant Or Contri Pd Dur Yr$37,607TotalGrantOrContriPdDurYrAmt

Analysis Income Producing Acty AnalysisIncomeProducingActyGrp

FieldValueIRS element (for citing)
Fees Contracts From Govt AgFeesContractsFromGovtAgGrp
Membership Dues And AssmntMembershipDuesAndAssmntGrp
Int On Sav And Temp Cash InvstIntOnSavAndTempCashInvstGrp

Div And Int From Sec Part VII DivAndIntFromSecPartVIIGrp

FieldValueIRS element (for citing)
Exclusion14ExclusionCd
Exclusion$17,872ExclusionAmt
FieldValueIRS element (for citing)
Net Rntl Incm Re Debt Fincd PropNetRntlIncmReDebtFincdPropGrp
Net Rntl Incm Re Not Debt Fincd PropNetRntlIncmReNotDebtFincdProp
Net Rental Income Personal PropNetRentalIncomePersonalPropGrp
Other Investment Incm Part VIIOtherInvestmentIncmPartVIIGrp

Gain Sales Ast Oth Than Invntry GainSalesAstOthThanInvntryGrp

FieldValueIRS element (for citing)
Exclusion18ExclusionCd
Exclusion$13,516ExclusionAmt
FieldValueIRS element (for citing)
Net Income Loss From Special EvtNetIncomeLossFromSpecialEvtGrp
Gross Profit Loss Sls Of InvntryGrossProfitLossSlsOfInvntryGrp

Subtotals Incm Producing Acty SubtotalsIncmProducingActyGrp

FieldValueIRS element (for citing)
Exclusion$31,388ExclusionAmt
FieldValueIRS element (for citing)
Total Income Producing Acty$31,388TotalIncomeProducingActyAmt
FieldValueIRS element (for citing)
Rln Of Acty To Accom Of Exmpt PrpsRlnOfActyToAccomOfExmptPrpsGrp

Trnsfr Trans Rln Nonchrtbl EO TrnsfrTransRlnNonchrtblEOGrp

FieldValueIRS element (for citing)
Trnsfr Of Cash To Nonchrtbl EOfalseTrnsfrOfCashToNonchrtblEOInd
Trnsfr Other Asset Nonchrtbl EOfalseTrnsfrOtherAssetNonchrtblEOInd
Sales Or Exchanges Of AssetsfalseSalesOrExchangesOfAssetsInd
Purchase Of Assets Nonchrtbl EOfalsePurchaseOfAssetsNonchrtblEOInd
Rental Of Facilities Oth AssetsfalseRentalOfFacilitiesOthAssetsInd
Reimbursement ArrangementsfalseReimbursementArrangementsInd
Loans Or Loan GuaranteesfalseLoansOrLoanGuaranteesInd
Performance Of Services EtcfalsePerformanceOfServicesEtcInd
Sharing Of Facilities EtcfalseSharingOfFacilitiesEtcInd
Relationships Nonchrtbl EOfalseRelationshipsNonchrtblEOInd

Investments Other Schedule2 InvestmentsOtherSchedule2

Investments Other InvestmentsOtherGrp (2 entries)

Category Or ItemCategoryOrItemTxtListed At Cost Or FMVListedAtCostOrFMVCdBook ValueBookValueAmtEOYFMVEOYFMVAmt
MUTUAL FUNDS - FIXEDAT COST$281,047$275,924
MUTUAL FUNDS - EQUITYAT COST$294,045$349,985

Other Increases Schedule OtherIncreasesSchedule

Other Increases Detail OtherIncreasesDetail

FieldValueIRS element (for citing)
DescROUNDING ADJ FOR SALES AND TRANSACTIONSDesc
Amt$3Amt

Taxes Schedule TaxesSchedule

Taxes Detail TaxesDetail (4 entries)

CategoryCategoryTxtAmtAmtNet Investment IncomeNetInvestmentIncomeAmtDisbursements Charitable PrpsDisbursementsCharitablePrpsAmt
FOREIGN TAXES$81$81$0
FEDERAL TAX PAYMENT - PRIOR YE$865$0$0
FEDERAL ESTIMATES - PRINCIPAL$1,264$0$0
FOREIGN TAXES ON QUALIFIED FOR$6$6$0