JOHN C WILLIAMS CHARITABLE TR 8024: Form 990PF, tax year 2018
View the entire original 990 at ProPublica ↗
- Organization
- JOHN C WILLIAMS CHARITABLE TR 8024 (EIN 25-6024153)
- Tax period
- 2018-01-01 to 2018-12-31
- Filed
- 2019-05-13
- IRS object ID
- 201931339349102883
- Schema version
- 2018v3.0
- Source
- Download XML · Original 990 at ProPublica
Every field in the e-filed return. Faint text is the IRS element name, for citing.
- Return header
- Form 990-PF
- Other Assets Schedule
- Other Decreases Schedule
- Other Expenses Schedule
- Taxes Schedule
Return header ReturnHeader
| Field | Value | IRS element (for citing) |
|---|---|---|
| Return | 2019-05-13T17:54:14-05:00 | ReturnTs |
| Tax Period End | 2018-12-31 | TaxPeriodEndDt |
| Return Type | 990PF | ReturnTypeCd |
| Tax Period Begin | 2018-01-01 | TaxPeriodBeginDt |
Filer Filer
| Field | Value | IRS element (for citing) |
|---|---|---|
| EIN | 256024153 | EIN |
Business Name BusinessName
| Field | Value | IRS element (for citing) |
|---|---|---|
| Business Name Line1 | JOHN C WILLIAMS CHARITABLE TR 8024 | BusinessNameLine1Txt |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Business Name Control | WILL | BusinessNameControlTxt |
| Phone | 4127623792 | PhoneNum |
US Address USAddress
| Field | Value | IRS element (for citing) |
|---|---|---|
| Address Line1 | 116 ALLEGHENY CENTER MALL P8YB3502L | AddressLine1Txt |
| City | PITTSBURGH | CityNm |
| State Abbreviation | PA | StateAbbreviationCd |
| ZIP | 15212 | ZIPCd |
Business Officer BusinessOfficerGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Person | PNC BANK N A BY | PersonNm |
| Person Title | VICE PRESIDENT | PersonTitleTxt |
| Phone | 4127623792 | PhoneNum |
| Signature | 2019-05-08 | SignatureDt |
Filing Security Information FilingSecurityInformation
IP Address IPAddress
| Field | Value | IRS element (for citing) |
|---|---|---|
| I Pv4 Address | 161.150.240.4 | IPv4AddressTxt |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Filing License Type | P | FilingLicenseTypeCd |
| At Submission Creation Device Id | 3BB8C0E9FEC78F69228AD1801D614A994052CE46 | AtSubmissionCreationDeviceId |
| At Submission Filing Device Id | 3BB8C0E9FEC78F69228AD1801D614A994052CE46 | AtSubmissionFilingDeviceId |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Tax | 2018 | TaxYr |
| Build TS | 2019-02-21 02:37:17Z | BuildTS |
Form 990-PF IRS990PF
| Field | Value | IRS element (for citing) |
|---|---|---|
| Organization501c3 Exempt PF | Yes (X) | Organization501c3ExemptPFInd |
| FMV Assets EOY | $7,637,669 | FMVAssetsEOYAmt |
Analysis Of Revenue And Expenses AnalysisOfRevenueAndExpenses
| Field | Value | IRS element (for citing) |
|---|---|---|
| Schedule B Not Required | Yes (X) | ScheduleBNotRequiredInd |
| Dividends Rev And Expnss | $196,347 | DividendsRevAndExpnssAmt |
| Dividends Net Invst Incm | $196,347 | DividendsNetInvstIncmAmt |
| Net Gain Sale Ast Rev And Expnss | $1,450,558 | NetGainSaleAstRevAndExpnssAmt |
| Gross Sales Price | $4,712,539 | GrossSalesPriceAmt |
| Cap Gain Net Incm Net Invst Incm | $1,450,558 | CapGainNetIncmNetInvstIncmAmt |
| Net ST Capital Gain Adj Net Incm | $0 | NetSTCapitalGainAdjNetIncmAmt |
| Total Rev And Expnss | $1,646,905 | TotalRevAndExpnssAmt |
| Total Net Invst Incm | $1,646,905 | TotalNetInvstIncmAmt |
| Comp Ofcr Dir Trst Rev And Expnss | $67,771 | CompOfcrDirTrstRevAndExpnssAmt |
| Comp Ofcr Dir Trst Net Invst Incm | $60,993 | CompOfcrDirTrstNetInvstIncmAmt |
| Comp Ofcr Dir Trst Dsbrs Chrtbl | $6,778 | CompOfcrDirTrstDsbrsChrtblAmt |
| Oth Empl Slrs Wgs Net Invst Incm | $0 | OthEmplSlrsWgsNetInvstIncmAmt |
| Oth Empl Slrs Wgs Adj Net Incm | $0 | OthEmplSlrsWgsAdjNetIncmAmt |
| Oth Empl Slrs Wgs Dsbrs Chrtbl | $0 | OthEmplSlrsWgsDsbrsChrtblAmt |
| Pension Empl Bnft Net Invst Incm | $0 | PensionEmplBnftNetInvstIncmAmt |
| Pension Empl Bnft Adj Net Incm | $0 | PensionEmplBnftAdjNetIncmAmt |
| Legal Fees Dsbrs Chrtbl | $0 | LegalFeesDsbrsChrtblAmt |
| Other Prof Fees Dsbrs Chrtbl | $0 | OtherProfFeesDsbrsChrtblAmt |
| Interest Dsbrs Chrtbl | $0 | InterestDsbrsChrtblAmt |
| Taxes Rev And Expnss | $12,116 | TaxesRevAndExpnssAmt |
| Taxes Net Invst Incm | $1,466 | TaxesNetInvstIncmAmt |
| Taxes Dsbrs Chrtbl | $0 | TaxesDsbrsChrtblAmt |
| Deprec And Dpltn Rev And Expnss | $0 | DeprecAndDpltnRevAndExpnssAmt |
| Deprec And Dpltn Net Invst Incm | $0 | DeprecAndDpltnNetInvstIncmAmt |
| Trav Conf Meeting Net Invst Incm | $0 | TravConfMeetingNetInvstIncmAmt |
| Trav Conf Meeting Adj Net Incm | $0 | TravConfMeetingAdjNetIncmAmt |
| Printing And Pub Net Invst Incm | $0 | PrintingAndPubNetInvstIncmAmt |
| Printing And Pub Adj Net Incm | $0 | PrintingAndPubAdjNetIncmAmt |
| Other Expenses Rev And Expnss | $26,106 | OtherExpensesRevAndExpnssAmt |
| Other Expenses Net Invst Incm | $3,124 | OtherExpensesNetInvstIncmAmt |
| Other Expenses Dsbrs Chrtbl | $22,982 | OtherExpensesDsbrsChrtblAmt |
| Tot Opr Expenses Rev And Expnss | $105,993 | TotOprExpensesRevAndExpnssAmt |
| Tot Opr Expenses Net Invst Incm | $65,583 | TotOprExpensesNetInvstIncmAmt |
| Tot Opr Expenses Adj Net Incm | $0 | TotOprExpensesAdjNetIncmAmt |
| Tot Opr Expenses Dsbrs Chrtbl | $29,760 | TotOprExpensesDsbrsChrtblAmt |
| Contri Paid Rev And Expnss | $382,372 | ContriPaidRevAndExpnssAmt |
| Contri Paid Dsbrs Chrtbl | $382,372 | ContriPaidDsbrsChrtblAmt |
| Total Expenses Rev And Expnss | $488,365 | TotalExpensesRevAndExpnssAmt |
| Total Expenses Net Invst Incm | $65,583 | TotalExpensesNetInvstIncmAmt |
| Total Expenses Adj Net Incm | $0 | TotalExpensesAdjNetIncmAmt |
| Total Expenses Dsbrs Chrtbl | $412,132 | TotalExpensesDsbrsChrtblAmt |
| Excess Revenue Over Expenses | $1,158,540 | ExcessRevenueOverExpensesAmt |
| Net Investment Income | $1,581,322 | NetInvestmentIncomeAmt |
| Adjusted Net Income | $0 | AdjustedNetIncomeAmt |
Form990 PF Balance Sheets Form990PFBalanceSheetsGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Sav And Temp Cash Invst BOY | $214,401 | SavAndTempCashInvstBOYAmt |
| Sav And Temp Cash Invst EOY | $318,186 | SavAndTempCashInvstEOYAmt |
| Sav And Temp Cash Invst EOYFMV | $318,186 | SavAndTempCashInvstEOYFMVAmt |
| Acct Rcvbl EOY | $0 | AcctRcvblEOYAmt |
| Acct Rcvbl EOYFMV | $0 | AcctRcvblEOYFMVAmt |
| Other Rcvbl Allwnc Dbtfl Acct | $0 | OtherRcvblAllwncDbtflAcctAmt |
| Corporate Stock BOY | $3,608,486 | CorporateStockBOYAmt |
| Corporate Stock EOY | $1,517,391 | CorporateStockEOYAmt |
| Corporate Stock EOYFMV | $1,558,313 | CorporateStockEOYFMVAmt |
| Corporate Bonds BOY | $2,528,215 | CorporateBondsBOYAmt |
| Other Investments EOYFMV | $0 | OtherInvestmentsEOYFMVAmt |
| Other Assets EOY | $5,674,061 | OtherAssetsEOYAmt |
| Other Assets EOYFMV | $5,761,170 | OtherAssetsEOYFMVAmt |
| Total Assets BOY | $6,351,102 | TotalAssetsBOYAmt |
| Total Assets EOY | $7,509,638 | TotalAssetsEOYAmt |
| Total Assets EOYFMV | $7,637,669 | TotalAssetsEOYFMVAmt |
| Total Liabilities EOY | $0 | TotalLiabilitiesEOYAmt |
| Org Does Not Follow SFAS117 | Yes (X) | OrgDoesNotFollowSFAS117Ind |
| Capital Stock BOY | $6,351,102 | CapitalStockBOYAmt |
| Capital Stock EOY | $7,509,638 | CapitalStockEOYAmt |
| Tot Net Ast Or Fund Balances BOY | $6,351,102 | TotNetAstOrFundBalancesBOYAmt |
| Tot Net Ast Or Fund Balances EOY | $7,509,638 | TotNetAstOrFundBalancesEOYAmt |
| Total Liabilities Net Ast BOY | $6,351,102 | TotalLiabilitiesNetAstBOYAmt |
| Total Liabilities Net Ast EOY | $7,509,638 | TotalLiabilitiesNetAstEOYAmt |
Chg In Net Assets Fund Balances ChgInNetAssetsFundBalancesGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Tot Net Ast Or Fund Balances BOY | $6,351,102 | TotNetAstOrFundBalancesBOYAmt |
| Excess Revenue Over Expenses | $1,158,540 | ExcessRevenueOverExpensesAmt |
| Other Increases | $0 | OtherIncreasesAmt |
| Subtotal | $7,509,642 | SubtotalAmt |
| Other Decreases | $4 | OtherDecreasesAmt |
| Tot Net Ast Or Fund Balances EOY | $7,509,638 | TotNetAstOrFundBalancesEOYAmt |
Cap Gains Loss Tx Invst Incm Detail CapGainsLossTxInvstIncmDetail
Cap Gains Loss Tx Invst Incm CapGainsLossTxInvstIncmGrp (367 entries)
| PropertyPropertyDesc | AcquiredAcquiredDt | SoldSoldDt | Gross Sales PriceGrossSalesPriceAmt | Cost Or Other BasisCostOrOtherBasisAmt | Gain Or LossGainOrLossAmt | Gains Minus Excess Or LossesGainsMinusExcessOrLossesAmt | How AcquiredHowAcquiredCd |
|---|---|---|---|---|---|---|---|
| 140. AGILENT TECHNOLOGIES (IPO) | 2017-08-18 | 2018-01-04 | $9,656 | $8,606 | $1,050 | $1,050 | |
| 19. AGILENT TECHNOLOGIES (IPO) | 2017-04-24 | 2018-01-04 | $1,310 | $1,033 | $277 | $277 | |
| 41. AGILENT TECHNOLOGIES (IPO) | 2017-04-24 | 2018-01-04 | $2,844 | $2,229 | $615 | $615 | |
| 60. THERMO ELECTRON CORP COM | 2015-08-20 | 2018-01-04 | $11,943 | $7,979 | $3,964 | $3,964 | |
| 133. WYNDHAM WORLDWIDE CORP | 2013-03-18 | 2018-01-04 | $15,432 | $9,328 | $6,104 | $6,104 | |
| 287. WYNDHAM WORLDWIDE CORP | 2013-03-18 | 2018-01-05 | $32,383 | $17,943 | $14,440 | $14,440 | |
| 260. ABBVIE INC | 2017-12-08 | 2018-01-18 | $26,948 | $24,959 | $1,989 | $1,989 | |
| 130. AETNA INC NEW | 2013-05-30 | 2018-01-18 | $24,118 | $8,007 | $16,111 | $16,111 | |
| 340. AGILENT TECHNOLOGIES (IPO) | 2017-04-21 | 2018-01-18 | $24,519 | $18,116 | $6,403 | $6,403 | |
| 70. ALPHABET INC/CA-CL A | 2009-01-27 | 2018-01-18 | $79,298 | $35,064 | $44,234 | $44,234 | |
| 370. ALTRIA GROUP INC | 2013-05-13 | 2018-01-18 | $25,921 | $13,682 | $12,239 | $12,239 | |
| 260. AMERICAN WATER WORKS CO INC | 2016-02-05 | 2018-01-18 | $21,437 | $16,815 | $4,622 | $4,622 | |
| 240. AMGEN INC | 2013-12-30 | 2018-01-18 | $44,877 | $27,958 | $16,919 | $16,919 | |
| 140. ANALOG DEVICES INC | 2017-09-01 | 2018-01-18 | $13,641 | $11,787 | $1,854 | $1,854 | |
| 240. ANALOG DEVICES INC | 2017-06-14 | 2018-01-18 | $23,385 | $19,508 | $3,877 | $3,877 | |
| 240. APPLE INC | 2017-03-13 | 2018-01-18 | $42,988 | $34,253 | $8,735 | $8,735 | |
| 390. APPLE INC | 2006-08-08 | 2018-01-18 | $69,856 | $3,648 | $66,208 | $66,208 | |
| 490. APPLIED MATERIALS INC | 2016-07-13 | 2018-01-18 | $28,087 | $12,687 | $15,400 | $15,400 | |
| 430. BANK NEW YORK MELLON CORP COM | 2016-04-29 | 2018-01-18 | $23,824 | $17,250 | $6,574 | $6,574 | |
| 350. BAXTER INTERNATIONAL INC | 2018-01-04 | 2018-01-18 | $24,209 | $23,944 | $265 | $265 | |
| 600. BERRY GLOBAL GROUP INC | 2016-08-25 | 2018-01-18 | $35,410 | $27,048 | $8,362 | $8,362 | |
| 20. BIOGEN INC | 2017-02-17 | 2018-01-18 | $6,873 | $5,820 | $1,053 | $1,053 | |
| 100. BIOGEN INC | 2016-08-02 | 2018-01-18 | $34,365 | $29,513 | $4,852 | $4,852 | |
| 100. BOEING CO | 2017-10-20 | 2018-01-18 | $34,037 | $26,456 | $7,581 | $7,581 | |
| 680. BORG WARNER INC. | 2017-08-18 | 2018-01-18 | $38,855 | $32,323 | $6,532 | $6,532 | |
| 40. BURLINGTON STORES INC | 2017-03-13 | 2018-01-18 | $4,928 | $3,760 | $1,168 | $1,168 | |
| 250. BURLINGTON STORES INC | 2016-08-31 | 2018-01-18 | $30,799 | $20,463 | $10,336 | $10,336 | |
| 360. CBS CORP CLASS B WI | 2016-08-05 | 2018-01-18 | $21,685 | $18,750 | $2,935 | $2,935 | |
| 520. CISCO SYS INC COM | 2011-11-11 | 2018-01-18 | $21,435 | $9,882 | $11,553 | $11,553 | |
| 380. CITIGROUP INC | 2017-07-28 | 2018-01-18 | $29,340 | $25,673 | $3,667 | $3,667 | |
| 930. CITIZENS FINANCIAL GROUP | 2016-11-11 | 2018-01-18 | $42,344 | $28,384 | $13,960 | $13,960 | |
| 1210. COMCAST CORPORATION CL A | 2011-10-12 | 2018-01-18 | $50,476 | $14,330 | $36,146 | $36,146 | |
| 430. CONOCOPHILLIPS | 2017-11-03 | 2018-01-18 | $25,677 | $22,906 | $2,771 | $2,771 | |
| 240. CONSTELLATION BRANDS INC CL A | 2014-05-15 | 2018-01-18 | $52,220 | $19,414 | $32,806 | $32,806 | |
| 130. CUMMINS INC | 2017-02-17 | 2018-01-18 | $23,862 | $20,024 | $3,838 | $3,838 | |
| 480. DOWDUPONT INC | 2015-04-28 | 2018-01-18 | $36,540 | $25,016 | $11,524 | $11,524 | |
| 390. FACEBOOK INC | 2016-03-02 | 2018-01-18 | $70,214 | $44,176 | $26,038 | $26,038 | |
| 140. GENERAL DYNAMICS CORP | 2015-05-27 | 2018-01-18 | $29,055 | $19,669 | $9,386 | $9,386 | |
| 540. HALLIBURTON CO | 2017-01-27 | 2018-01-18 | $28,267 | $31,418 | -$3,151 | -$3,151 | |
| 8314.571 HARBOR FD INTL FD | 2003-12-23 | 2018-01-18 | $592,413 | $305,613 | $286,800 | $286,800 | |
| 290. HOME DEPOT INC COM | 2012-01-09 | 2018-01-18 | $57,611 | $14,146 | $43,465 | $43,465 | |
| 170. HONEYWELL INTL INC | 2015-02-02 | 2018-01-18 | $26,836 | $16,696 | $10,140 | $10,140 | |
| 220. ILLINOIS TOOL WORKS INC COM | 2016-02-17 | 2018-01-18 | $37,437 | $20,891 | $16,546 | $16,546 | |
| 540. INTEL CORP | 2016-08-19 | 2018-01-18 | $24,048 | $19,062 | $4,986 | $4,986 | |
| 790. J P MORGAN CHASE & CO COM | 2004-12-27 | 2018-01-18 | $89,402 | $29,584 | $59,818 | $59,818 | |
| 170. JOHNSON & JOHNSON COM | 1989-06-27 | 2018-01-18 | $24,974 | $1,082 | $23,892 | $23,892 | |
| 130. LAM RESEARCH CORP | 2015-06-02 | 2018-01-18 | $26,681 | $10,371 | $16,310 | $16,310 | |
| 310. LAUDER ESTEE COS INC CL A | 2017-09-01 | 2018-01-18 | $40,625 | $33,432 | $7,193 | $7,193 | |
| 230. MARRIOTT INTERNATIONAL INC CL A | 2018-01-04 | 2018-01-18 | $32,435 | $31,330 | $1,105 | $1,105 | |
| 150. MCDONALDS CORP COM | 2017-06-19 | 2018-01-18 | $26,218 | $22,960 | $3,258 | $3,258 | |
| 80. MCDONALDS CORP COM | 2017-07-28 | 2018-01-18 | $13,983 | $12,460 | $1,523 | $1,523 | |
| 360. MICROSOFT CORP | 2002-10-16 | 2018-01-18 | $32,475 | $9,084 | $23,391 | $23,391 | |
| 30. MOHAWK INDS INC | 2017-08-18 | 2018-01-18 | $8,320 | $7,462 | $858 | $858 | |
| 10. MOHAWK INDS INC | 2017-03-13 | 2018-01-18 | $2,773 | $2,300 | $473 | $473 | |
| 90. MOHAWK INDS INC | 2016-08-05 | 2018-01-18 | $24,961 | $19,185 | $5,776 | $5,776 | |
| 650. MORGAN STANLEY | 2016-10-21 | 2018-01-18 | $36,156 | $21,723 | $14,433 | $14,433 | |
| 100. NORTHROP GRUMMAN CORPORATION | 2015-02-19 | 2018-01-18 | $31,410 | $16,606 | $14,804 | $14,804 | |
| 170. PARKER HANNIFIN CORP | 2017-04-07 | 2018-01-18 | $35,766 | $27,392 | $8,374 | $8,374 | |
| 300. PEPSICO INC COM | 2016-06-02 | 2018-01-18 | $35,729 | $31,245 | $4,484 | $4,484 | |
| 910. PFIZER INC COM | 2017-11-10 | 2018-01-18 | $33,597 | $31,888 | $1,709 | $1,709 | |
| 330. PRICE T ROWE GROUP INC COM | 2017-08-28 | 2018-01-18 | $38,219 | $27,751 | $10,468 | $10,468 | |
| 370. PROLOGIS INC | 2016-10-24 | 2018-01-18 | $22,804 | $19,565 | $3,239 | $3,239 | |
| 260. PROLOGIS INC | 2017-06-02 | 2018-01-18 | $16,024 | $14,790 | $1,234 | $1,234 | |
| 140. RAYTHEON COMPANY | 2016-01-29 | 2018-01-18 | $27,399 | $17,820 | $9,579 | $9,579 | |
| 370. ROYAL DUTCH SHELL PLC ADR A | 2017-10-20 | 2018-01-18 | $25,907 | $22,661 | $3,246 | $3,246 | |
| 250. S&P GLOBAL INC | 2016-05-20 | 2018-01-18 | $44,567 | $27,109 | $17,458 | $17,458 | |
| 60. SHERWIN-WILLIAMS CO | 2017-06-19 | 2018-01-18 | $25,838 | $21,375 | $4,463 | $4,463 | |
| 140. STANLEY BLACK & DECKER INC | 2017-11-06 | 2018-01-18 | $24,449 | $23,085 | $1,364 | $1,364 | |
| 400. STATE STR CORP COM | 2016-09-07 | 2018-01-18 | $41,963 | $28,216 | $13,747 | $13,747 | |
| 150. STRYKER CORP | 2017-03-13 | 2018-01-18 | $24,037 | $19,721 | $4,316 | $4,316 | |
| 650. SUNTRUST BANKS INC COM | 2016-06-23 | 2018-01-18 | $44,123 | $26,758 | $17,365 | $17,365 | |
| 380. T-MOBILE US INC | 2017-05-01 | 2018-01-18 | $23,799 | $25,794 | -$1,995 | -$1,995 | |
| 450. TEXAS INSTRS INC COM | 2015-11-11 | 2018-01-18 | $52,363 | $25,990 | $26,373 | $26,373 | |
| 120. THERMO ELECTRON CORP COM | 2015-08-20 | 2018-01-18 | $25,510 | $15,958 | $9,552 | $9,552 | |
| 580. TOTAL FINA S A | 2015-08-12 | 2018-01-18 | $33,691 | $28,735 | $4,956 | $4,956 | |
| 440. TRANSCANADA CORP (HOLDING CO) | 2017-06-02 | 2018-01-18 | $21,153 | $20,757 | $396 | $396 | |
| 220. TYSON FDS INC COM | 2017-09-29 | 2018-01-18 | $17,348 | $15,522 | $1,826 | $1,826 | |
| 190. TYSON FDS INC COM | 2016-03-11 | 2018-01-18 | $14,983 | $12,831 | $2,152 | $2,152 | |
| 190. UNITED RENTALS INC COM | 2017-05-25 | 2018-01-18 | $34,388 | $21,363 | $13,025 | $13,025 | |
| 130. UNITEDHEALTH GROUP INC COM | 2016-10-27 | 2018-01-18 | $31,578 | $18,474 | $13,104 | $13,104 | |
| 40. UNITEDHEALTH GROUP INC COM | 2017-01-27 | 2018-01-18 | $9,716 | $6,519 | $3,197 | $3,197 | |
| 300. VISA INC CLASS A SHARES | 2013-02-08 | 2018-01-18 | $36,893 | $11,817 | $25,076 | $25,076 | |
| 580. WEC ENERGY GROUP INC | 2009-03-13 | 2018-01-18 | $36,737 | $11,074 | $25,663 | $25,663 | |
| 440. TE CONNECTIVITY LTD SEDOL B62B7C3 ISIN CH0102993182 | 2017-05-25 | 2018-01-18 | $43,969 | $34,675 | $9,294 | $9,294 | |
| 270. ROYAL CARRIBEAN CRUISES LTD SEDOL 2754907 ISIN LR0008862868 | 2017-04-07 | 2018-01-18 | $34,950 | $26,441 | $8,509 | $8,509 | |
| 2. TRANSCANADA CORP (HOLDING CO) | 2017-06-02 | 2018-01-19 | $96 | $94 | $2 | $2 | |
| 29. TRANSCANADA CORP (HOLDING CO) | 2017-06-02 | 2018-01-19 | $1,391 | $1,362 | $29 | $29 | |
| 39. TRANSCANADA CORP (HOLDING CO) | 2017-06-02 | 2018-01-19 | $1,872 | $1,832 | $40 | $40 | |
| 20. TRANSCANADA CORP (HOLDING CO) | 2017-06-02 | 2018-01-22 | $959 | $939 | $20 | $20 | |
| 100. TRANSCANADA CORP (HOLDING CO) | 2017-06-02 | 2018-01-22 | $4,796 | $4,697 | $99 | $99 | |
| 6. ALIBABA GROUP HOLDING LTD ADR SEDOL BP41ZD1 | 2018-01-22 | 2018-01-25 | $1,191 | $1,098 | $93 | $93 | |
| 8. ASML HOLDING NV-NY SEDOL B908F01 | 2018-01-22 | 2018-01-25 | $1,629 | $1,640 | -$11 | -$11 | |
| 29. SILICON MOTION TECHNOL ADR | 2018-01-22 | 2018-01-26 | $1,436 | $1,433 | $3 | $3 | |
| 65. VMWARE INC CLASS A | 2018-01-24 | 2018-01-30 | $7,995 | $8,880 | -$885 | -$885 | |
| 90. APPLE INC | 2018-01-24 | 2018-01-31 | $15,148 | $15,730 | -$582 | -$582 | |
| 160. CBS CORP CLASS B WI | 2016-08-08 | 2018-02-02 | $8,952 | $8,329 | $623 | $623 | |
| 15. HOME DEPOT INC COM | 2012-01-09 | 2018-02-02 | $2,930 | $648 | $2,282 | $2,282 | |
| 15. MOHAWK INDS INC | 2016-08-05 | 2018-02-02 | $4,070 | $3,198 | $872 | $872 | |
| 22. APTIV PLC-WHEN ISSUED SEDOL B783TY6 | 2018-01-22 | 2018-02-05 | $2,075 | $2,052 | $23 | $23 | |
| 311. BARCLAYS PLC ADR | 2018-01-22 | 2018-02-07 | $3,312 | $3,637 | -$325 | -$325 | |
| 163. DEUTSCHE BOERSE AG UNSPN ADR | 2018-01-22 | 2018-02-07 | $2,091 | $1,977 | $114 | $114 | |
| 9. CHECK POINT SOFTWARE COM | 2018-01-22 | 2018-02-08 | $892 | $943 | -$51 | -$51 | |
| 46. VALEO SPONSORED ADR | 2018-01-22 | 2018-02-09 | $1,609 | $1,851 | -$242 | -$242 | |
| 3. AMAZON.COM INC | 2018-01-24 | 2018-02-15 | $4,380 | $4,065 | $315 | $315 | |
| 43. AMERICAN TOWER CORP | 2018-01-24 | 2018-02-15 | $5,861 | $6,075 | -$214 | -$214 | |
| 85. NIELSEN HOLDINGS PLC SEDOL BWFY550 | 2018-01-22 | 2018-02-15 | $2,802 | $3,132 | -$330 | -$330 | |
| 43. AMERICAN TOWER CORP | 2018-01-24 | 2018-02-16 | $6,033 | $6,075 | -$42 | -$42 | |
| 14. BIOGEN INC | 2018-01-24 | 2018-02-16 | $4,091 | $4,803 | -$712 | -$712 | |
| 308. NORDEA BK AB ADR SEDOL B40B033 | 2018-01-22 | 2018-02-16 | $3,652 | $3,884 | -$232 | -$232 | |
| 130. PEPSICO INC COM | 2016-06-02 | 2018-02-23 | $14,233 | $13,239 | $994 | $994 | |
| 212. PROLOGIS INC | 2016-10-21 | 2018-02-23 | $12,979 | $11,126 | $1,853 | $1,853 | |
| 954.198 VANGUARD TOTL BD MKT IDX-ADM | 2016-07-12 | 2018-02-23 | $10,000 | $10,601 | -$601 | -$601 | |
| 14. BIOGEN INC | 2018-01-24 | 2018-02-26 | $4,053 | $4,803 | -$750 | -$750 | |
| 68. PROLOGIS INC | 2016-10-21 | 2018-02-26 | $4,160 | $3,558 | $602 | $602 | |
| 19. SHERWIN-WILLIAMS CO | 2017-06-19 | 2018-03-02 | $7,441 | $6,761 | $680 | $680 | |
| 1. SHERWIN-WILLIAMS CO | 2017-06-19 | 2018-03-05 | $389 | $356 | $33 | $33 | |
| 10. AMGEN INC | 2013-12-30 | 2018-03-07 | $1,897 | $1,154 | $743 | $743 | |
| 7. APPLE INC | 2006-08-08 | 2018-03-07 | $1,226 | $65 | $1,161 | $1,161 | |
| 5. BOEING CO | 2017-10-20 | 2018-03-07 | $1,737 | $1,317 | $420 | $420 | |
| 32. COMCAST CORPORATION CL A | 2011-10-12 | 2018-03-07 | $1,168 | $379 | $789 | $789 | |
| 7. CONSTELLATION BRANDS INC CL A | 2014-05-15 | 2018-03-07 | $1,549 | $557 | $992 | $992 | |
| 6. NORTHROP GRUMMAN CORPORATION | 2015-03-27 | 2018-03-07 | $2,043 | $962 | $1,081 | $1,081 | |
| 10. STATE STR CORP COM | 2016-09-09 | 2018-03-07 | $1,055 | $704 | $351 | $351 | |
| 19. WEC ENERGY GROUP INC | 2009-03-13 | 2018-03-07 | $1,132 | $359 | $773 | $773 | |
| 60. STANLEY BLACK & DECKER INC | 2017-11-03 | 2018-03-09 | $9,593 | $9,773 | -$180 | -$180 | |
| 42. CIGNA CORP | 2018-01-24 | 2018-03-13 | $6,877 | $9,295 | -$2,418 | -$2,418 | |
| 47. ELECTRONIC ART | 2018-01-24 | 2018-03-13 | $5,933 | $5,482 | $451 | $451 | |
| 45. MOHAWK INDS INC | 2016-08-05 | 2018-04-05 | $10,776 | $9,593 | $1,183 | $1,183 | |
| 185. SODEXHO SA SPON ADR | 2018-01-22 | 2018-04-05 | $3,565 | $4,912 | -$1,347 | -$1,347 | |
| 77. YUM! BRANDS INC | 2018-01-24 | 2018-04-05 | $6,616 | $6,563 | $53 | $53 | |
| 31460.674 COLUMBIA FLOATING RATE FUND INSTITUTIONAL | 2016-08-17 | 2018-04-12 | $287,236 | $280,000 | $7,236 | $7,236 | |
| 60. AMERICAN AIRLINES GROUP INC | 2018-01-24 | 2018-04-13 | $2,762 | $3,234 | -$472 | -$472 | |
| 8. INTUITIVE SURGICAL INC | 2018-01-24 | 2018-04-13 | $3,327 | $3,471 | -$144 | -$144 | |
| 97. MORGAN STANLEY | 2018-01-24 | 2018-04-13 | $5,169 | $5,553 | -$384 | -$384 | |
| 66. XILINX INC COM | 2018-01-24 | 2018-04-13 | $4,564 | $4,857 | -$293 | -$293 | |
| 43. ACUITY BRANDS INC | 2018-01-24 | 2018-04-20 | $5,509 | $7,145 | -$1,636 | -$1,636 | |
| 23. APPLE INC | 2018-01-24 | 2018-04-20 | $3,839 | $4,020 | -$181 | -$181 | |
| 6. INTUITIVE SURGICAL INC | 2018-01-24 | 2018-04-20 | $2,731 | $2,603 | $128 | $128 | |
| 18. SERVICE NOW INC | 2018-01-24 | 2018-04-20 | $3,048 | $2,618 | $430 | $430 | |
| 41. XILINX INC COM | 2018-01-24 | 2018-04-23 | $2,617 | $3,017 | -$400 | -$400 | |
| 1. JPMORGAN CHASE 46625H100 | 2001-01-01 | 2018-04-24 | $100 | $25 | $75 | $75 | |
| 60. AETNA INC NEW | 2013-05-30 | 2018-04-26 | $10,742 | $3,695 | $7,047 | $7,047 | |
| 31. ILLINOIS TOOL WORKS INC COM | 2016-02-16 | 2018-04-26 | $4,460 | $2,888 | $1,572 | $1,572 | |
| 105. AMERICAN AIRLINES GROUP INC | 2018-01-24 | 2018-04-27 | $4,544 | $5,659 | -$1,115 | -$1,115 | |
| 57. APPLE INC | 2018-01-24 | 2018-04-27 | $9,286 | $9,962 | -$676 | -$676 | |
| 59. ILLINOIS TOOL WORKS INC COM | 2016-02-16 | 2018-04-27 | $8,398 | $5,489 | $2,909 | $2,909 | |
| 160. ALTRIA GROUP INC | 2013-05-13 | 2018-05-04 | $9,020 | $5,916 | $3,104 | $3,104 | |
| 115. COMCAST CORPORATION CL A | 2011-10-12 | 2018-05-04 | $3,664 | $1,362 | $2,302 | $2,302 | |
| 30. ROYAL CARRIBEAN CRUISES LTD SEDOL 2754907 ISIN LR0008862868 | 2017-04-07 | 2018-05-04 | $3,212 | $2,920 | $292 | $292 | |
| 3. ALIBABA GROUP HOLDING LTD ADR SEDOL BP41ZD1 | 2018-01-22 | 2018-05-11 | $581 | $549 | $32 | $32 | |
| 3. ASML HOLDING NV-NY SEDOL B908F01 | 2018-01-22 | 2018-05-11 | $595 | $615 | -$20 | -$20 | |
| 29. BERRY GLOBAL GROUP INC | 2016-10-14 | 2018-05-15 | $1,386 | $1,293 | $93 | $93 | |
| 132. BERRY GLOBAL GROUP INC | 2016-08-24 | 2018-05-15 | $6,280 | $5,798 | $482 | $482 | |
| 74. HONEYWELL INTL INC | 2015-02-02 | 2018-05-15 | $10,893 | $7,268 | $3,625 | $3,625 | |
| 6. HONEYWELL INTL INC | 2015-02-02 | 2018-05-15 | $882 | $589 | $293 | $293 | |
| 38. BERRY GLOBAL GROUP INC | 2016-08-24 | 2018-05-16 | $1,813 | $1,646 | $167 | $167 | |
| 38. BERRY GLOBAL GROUP INC | 2016-08-24 | 2018-05-16 | $1,814 | $1,646 | $168 | $168 | |
| 15. BERRY GLOBAL GROUP INC | 2016-08-24 | 2018-05-16 | $715 | $650 | $65 | $65 | |
| 6. BERRY GLOBAL GROUP INC | 2016-08-24 | 2018-05-17 | $285 | $260 | $25 | $25 | |
| 2. BERRY GLOBAL GROUP INC | 2016-08-24 | 2018-05-17 | $95 | $87 | $8 | $8 | |
| 170. ANALOG DEVICES INC | 2017-06-14 | 2018-05-23 | $16,054 | $13,818 | $2,236 | $2,236 | |
| 93. SANTEN PHARMACEUTICAL-UN ADR ADR SEDOL B3SKBC1 | 2018-01-22 | 2018-06-05 | $1,568 | $1,497 | $71 | $71 | |
| 11. SAP SE SPONSORED ADR | 2018-01-22 | 2018-06-05 | $1,278 | $1,238 | $40 | $40 | |
| 87. KAO CORP ADR SEDOL BFZPL12 | 2018-01-22 | 2018-06-08 | $1,302 | $1,211 | $91 | $91 | |
| 148. BRAMBLES LTD-SPONSORED ADR ADR SEDOL BYM1B61 | 2018-01-22 | 2018-06-12 | $2,002 | $2,347 | -$345 | -$345 | |
| 230. HALLIBURTON CO | 2017-01-30 | 2018-06-13 | $11,006 | $12,978 | -$1,972 | -$1,972 | |
| 25. SMUCKER J M CO COM NEW | 2018-02-27 | 2018-06-13 | $2,619 | $3,205 | -$586 | -$586 | |
| .157 FERGUSON PLC-ADR ADR SEDOL BFML715 | 2018-02-09 | 2018-06-14 | $1 | $1 | |||
| 27. SMUCKER J M CO COM NEW | 2018-02-26 | 2018-06-14 | $2,806 | $3,429 | -$623 | -$623 | |
| 29. AGILENT TECHNOLOGIES (IPO) | 2017-04-21 | 2018-06-15 | $1,906 | $1,536 | $370 | $370 | |
| 121. AGILENT TECHNOLOGIES (IPO) | 2017-04-21 | 2018-06-15 | $7,975 | $6,411 | $1,564 | $1,564 | |
| 68. SMUCKER J M CO COM NEW | 2018-02-23 | 2018-06-15 | $7,124 | $8,491 | -$1,367 | -$1,367 | |
| 110. AMERICAN AIRLINES GROUP INC | 2018-01-24 | 2018-06-25 | $4,340 | $5,929 | -$1,589 | -$1,589 | |
| 65. TEXAS INSTRS INC COM | 2018-01-24 | 2018-06-25 | $7,130 | $7,203 | -$73 | -$73 | |
| 24. UNILEVER N V N Y SHS NEW | 2018-01-22 | 2018-06-27 | $1,322 | $1,380 | -$58 | -$58 | |
| 10. TE CONNECTIVITY LTD SEDOL B62B7C3 ISIN CH0102993182 | 2018-01-22 | 2018-06-27 | $938 | $1,011 | -$73 | -$73 | |
| 5. BAIDU INC | 2018-01-22 | 2018-06-28 | $1,193 | $1,268 | -$75 | -$75 | |
| 5. ARKEMA ADR W/I SPONSORED ADR | 2018-01-22 | 2018-06-29 | $586 | $660 | -$74 | -$74 | |
| 50. CONSTELLATION BRANDS INC CL A | 2014-05-15 | 2018-07-02 | $10,747 | $3,980 | $6,767 | $6,767 | |
| 37. CUMMINS INC | 2017-02-17 | 2018-07-02 | $4,886 | $5,636 | -$750 | -$750 | |
| 23. CUMMINS INC | 2017-02-17 | 2018-07-03 | $3,038 | $3,504 | -$466 | -$466 | |
| 66. TOKYO ELECTRON LTD ADR | 2018-01-22 | 2018-07-06 | $2,615 | $3,230 | -$615 | -$615 | |
| 2. BOOKING HOLDINGS INC | 2018-01-24 | 2018-07-10 | $4,137 | $3,903 | $234 | $234 | |
| 54. CROWN CASTLE INTL CORP | 2018-01-24 | 2018-07-10 | $5,941 | $5,915 | $26 | $26 | |
| 53. CONSTELLATION BRANDS INC CL A | 2014-05-15 | 2018-07-13 | $11,434 | $4,218 | $7,216 | $7,216 | |
| 16. GENERAL DYNAMICS CORP | 2015-05-27 | 2018-07-13 | $3,086 | $2,248 | $838 | $838 | |
| 7. GENERAL DYNAMICS CORP | 2015-05-27 | 2018-07-13 | $1,353 | $983 | $370 | $370 | |
| 28. THERMO ELECTRON CORP COM | 2015-08-20 | 2018-07-13 | $5,917 | $3,724 | $2,193 | $2,193 | |
| 37. GENERAL DYNAMICS CORP | 2015-05-27 | 2018-07-16 | $7,090 | $5,192 | $1,898 | $1,898 | |
| 22. THERMO ELECTRON CORP COM | 2015-08-20 | 2018-07-16 | $4,609 | $2,925 | $1,684 | $1,684 | |
| 35. BROADCOM INC | 2018-02-16 | 2018-07-20 | $7,328 | $8,760 | -$1,432 | -$1,432 | |
| 28. PARKER HANNIFIN CORP | 2017-04-07 | 2018-07-27 | $4,609 | $4,512 | $97 | $97 | |
| 41. STATE STR CORP COM | 2016-09-09 | 2018-07-27 | $3,573 | $2,886 | $687 | $687 | |
| 122. STATE STR CORP COM | 2016-09-09 | 2018-07-27 | $10,618 | $8,586 | $2,032 | $2,032 | |
| 7. STATE STR CORP COM | 2016-09-09 | 2018-07-27 | $610 | $492 | $118 | $118 | |
| 51. TYSON FDS INC COM | 2016-03-11 | 2018-07-27 | $3,255 | $3,444 | -$189 | -$189 | |
| 10. TYSON FDS INC COM | 2016-03-11 | 2018-07-27 | $638 | $675 | -$37 | -$37 | |
| 22. TE CONNECTIVITY LTD SEDOL B62B7C3 ISIN CH0102993182 | 2018-01-22 | 2018-07-27 | $2,081 | $2,224 | -$143 | -$143 | |
| 42. PARKER HANNIFIN CORP | 2017-04-07 | 2018-07-30 | $6,923 | $6,768 | $155 | $155 | |
| 55. TYSON FDS INC COM | 2016-03-11 | 2018-07-30 | $3,218 | $3,714 | -$496 | -$496 | |
| 64. TYSON FDS INC COM | 2016-03-11 | 2018-07-30 | $3,790 | $4,322 | -$532 | -$532 | |
| 30. ABBVIE INC | 2017-12-08 | 2018-07-31 | $2,765 | $2,880 | -$115 | -$115 | |
| 10. ALPHABET INC/CA-CL A | 2009-03-13 | 2018-07-31 | $12,302 | $1,614 | $10,688 | $10,688 | |
| 5. AMAZON.COM INC | 2018-05-04 | 2018-07-31 | $8,880 | $7,905 | $975 | $975 | |
| 35. AMERICAN WATER WORKS CO INC | 2016-02-08 | 2018-07-31 | $3,080 | $2,228 | $852 | $852 | |
| 30. AMGEN INC | 2013-12-30 | 2018-07-31 | $5,870 | $3,463 | $2,407 | $2,407 | |
| 75. APPLE INC | 2006-08-08 | 2018-07-31 | $14,329 | $702 | $13,627 | $13,627 | |
| 60. APPLIED MATERIALS INC | 2016-07-13 | 2018-07-31 | $2,921 | $1,553 | $1,368 | $1,368 | |
| 35. AUTOMATIC DATA PROCESSING INC | 2018-05-25 | 2018-07-31 | $4,711 | $4,571 | $140 | $140 | |
| 135. BANK OF AMERICA CORP | 2018-07-27 | 2018-07-31 | $4,202 | $4,192 | $10 | $10 | |
| 55. BANK NEW YORK MELLON CORP COM | 2016-04-29 | 2018-07-31 | $2,946 | $2,206 | $740 | $740 | |
| 40. BAXTER INTERNATIONAL INC | 2018-01-04 | 2018-07-31 | $2,889 | $2,737 | $152 | $152 | |
| 15. BIOGEN INC | 2017-01-27 | 2018-07-31 | $5,074 | $3,831 | $1,243 | $1,243 | |
| 10. BOEING CO | 2017-10-20 | 2018-07-31 | $3,572 | $2,634 | $938 | $938 | |
| 85. BORG WARNER INC. | 2017-08-18 | 2018-07-31 | $3,917 | $3,779 | $138 | $138 | |
| 35. BURLINGTON STORES INC | 2016-08-31 | 2018-07-31 | $5,345 | $2,824 | $2,521 | $2,521 | |
| 105. CBRE GROUP INC | 2018-02-27 | 2018-07-31 | $5,231 | $4,953 | $278 | $278 | |
| 45. CSX CORP COM | 2018-07-27 | 2018-07-31 | $3,185 | $3,162 | $23 | $23 | |
| 30. CELANESE CORP | 2018-05-16 | 2018-07-31 | $3,541 | $3,337 | $204 | $204 | |
| 25. CENTENE CORP | 2018-04-27 | 2018-07-31 | $3,254 | $2,758 | $496 | $496 | |
| 45. CHEVRON CORPORATION | 2018-06-13 | 2018-07-31 | $5,732 | $5,723 | $9 | $9 | |
| 105. CISCO SYS INC COM | 2018-04-26 | 2018-07-31 | $4,449 | $4,642 | -$193 | -$193 | |
| 45. CITIGROUP INC | 2017-07-28 | 2018-07-31 | $3,252 | $3,040 | $212 | $212 | |
| 115. CITIZENS FINANCIAL GROUP | 2016-11-11 | 2018-07-31 | $4,580 | $3,425 | $1,155 | $1,155 | |
| 105. COMCAST CORPORATION CL A | 2011-10-12 | 2018-07-31 | $3,758 | $1,243 | $2,515 | $2,515 | |
| 55. CONOCOPHILLIPS | 2017-11-03 | 2018-07-31 | $3,978 | $2,912 | $1,066 | $1,066 | |
| 10. COSTCO WHSL CORP NEW COM | 2018-07-27 | 2018-07-31 | $2,193 | $2,197 | -$4 | -$4 | |
| 30. DANAHER CORP | 2018-06-15 | 2018-07-31 | $3,082 | $3,062 | $20 | $20 | |
| 122.715 DODGE & COX INTERNATIONAL STOCK FUND | 2011-12-21 | 2018-07-31 | $5,532 | $3,950 | $1,582 | $1,582 | |
| 60. DOWDUPONT INC | 2015-04-28 | 2018-07-31 | $4,140 | $3,093 | $1,047 | $1,047 | |
| 30. EASTMAN CHEM CO | 2018-03-06 | 2018-07-31 | $3,115 | $3,148 | -$33 | -$33 | |
| 45. FACEBOOK INC | 2016-03-02 | 2018-07-31 | $7,768 | $4,930 | $2,838 | $2,838 | |
| 10. FEDEX CORPORATION | 2018-05-15 | 2018-07-31 | $2,473 | $2,473 | |||
| 30. HOME DEPOT INC COM | 2012-01-09 | 2018-07-31 | $5,928 | $1,296 | $4,632 | $4,632 | |
| 65. INTEL CORP | 2016-08-19 | 2018-07-31 | $3,151 | $2,292 | $859 | $859 | |
| 95. J P MORGAN CHASE & CO COM | 2008-10-28 | 2018-07-31 | $11,021 | $3,228 | $7,793 | $7,793 | |
| 20. JOHNSON & JOHNSON COM | 1989-06-27 | 2018-07-31 | $2,642 | $127 | $2,515 | $2,515 | |
| 45. KOHLS CORP COM | 2018-04-05 | 2018-07-31 | $3,348 | $2,993 | $355 | $355 | |
| 15. LAM RESEARCH CORP | 2015-12-18 | 2018-07-31 | $2,859 | $1,163 | $1,696 | $1,696 | |
| 40. LAUDER ESTEE COS INC CL A | 2017-09-01 | 2018-07-31 | $5,412 | $4,313 | $1,099 | $1,099 | |
| 30. LILLY ELI & CO | 2018-07-13 | 2018-07-31 | $2,966 | $2,686 | $280 | $280 | |
| 30. MARRIOTT INTERNATIONAL INC CL A | 2018-01-04 | 2018-07-31 | $3,831 | $4,087 | -$256 | -$256 | |
| 25. MCCORMICK & CO INC COM NON VTG | 2018-07-13 | 2018-07-31 | $2,926 | $2,973 | -$47 | -$47 | |
| 30. MCDONALDS CORP COM | 2017-06-19 | 2018-07-31 | $4,731 | $4,592 | $139 | $139 | |
| 70. MICROSOFT CORP | 2018-07-02 | 2018-07-31 | $7,436 | $6,975 | $461 | $461 | |
| 80. MORGAN STANLEY | 2016-10-21 | 2018-07-31 | $4,059 | $2,674 | $1,385 | $1,385 | |
| 10. NORTHROP GRUMMAN CORPORATION | 2015-03-27 | 2018-07-31 | $3,009 | $1,603 | $1,406 | $1,406 | |
| 40. OCCIDENTAL PETE CORP COM | 2018-01-19 | 2018-07-31 | $3,371 | $3,018 | $353 | $353 | |
| 110. PFIZER INC COM | 2017-11-10 | 2018-07-31 | $4,364 | $3,855 | $509 | $509 | |
| 40. PRICE T ROWE GROUP INC COM | 2017-08-25 | 2018-07-31 | $4,783 | $3,358 | $1,425 | $1,425 | |
| 15. RAYTHEON COMPANY | 2016-01-29 | 2018-07-31 | $2,962 | $1,909 | $1,053 | $1,053 | |
| 45. ROYAL DUTCH SHELL PLC ADR A | 2017-10-20 | 2018-07-31 | $3,092 | $2,747 | $345 | $345 | |
| 30. S&P GLOBAL INC | 2016-05-20 | 2018-07-31 | $6,021 | $3,248 | $2,773 | $2,773 | |
| 20. STRYKER CORP | 2017-03-14 | 2018-07-31 | $3,288 | $2,618 | $670 | $670 | |
| 80. SUNTRUST BANKS INC COM | 2016-06-24 | 2018-07-31 | $5,810 | $3,271 | $2,539 | $2,539 | |
| 45. T-MOBILE US INC | 2017-05-01 | 2018-07-31 | $2,698 | $3,044 | -$346 | -$346 | |
| 55. TEXAS INSTRS INC COM | 2015-12-18 | 2018-07-31 | $6,120 | $3,039 | $3,081 | $3,081 | |
| 70. TOTAL FINA S A | 2016-05-05 | 2018-07-31 | $4,573 | $3,421 | $1,152 | $1,152 | |
| 20. UNITED RENTALS INC COM | 2017-05-25 | 2018-07-31 | $2,981 | $2,249 | $732 | $732 | |
| 80. US FOODS HOLDING CORP | 2018-06-15 | 2018-07-31 | $2,690 | $3,007 | -$317 | -$317 | |
| 30. UNITED TECHNOLOGIES CORP COM | 2018-07-13 | 2018-07-31 | $4,070 | $3,885 | $185 | $185 | |
| 20. UNITEDHEALTH GROUP INC COM | 2016-10-27 | 2018-07-31 | $5,084 | $2,842 | $2,242 | $2,242 | |
| 9606.148 VANGUARD TOTL BD MKT IDX-ADM | 2009-04-02 | 2018-07-31 | $100,000 | $101,094 | -$1,094 | -$1,094 | |
| 35. VISA INC CLASS A SHARES | 2013-02-08 | 2018-07-31 | $4,785 | $1,379 | $3,406 | $3,406 | |
| 65. WEC ENERGY GROUP INC | 2009-03-13 | 2018-07-31 | $4,289 | $1,230 | $3,059 | $3,059 | |
| 60. WASTE MANAGEMENT INC | 2018-03-09 | 2018-07-31 | $5,380 | $5,212 | $168 | $168 | |
| 55. TE CONNECTIVITY LTD SEDOL B62B7C3 ISIN CH0102993182 | 2017-05-25 | 2018-07-31 | $5,169 | $4,287 | $882 | $882 | |
| 25. ROYAL CARRIBEAN CRUISES LTD SEDOL 2754907 ISIN LR0008862868 | 2017-04-07 | 2018-07-31 | $2,825 | $2,434 | $391 | $391 | |
| 60. AIR LIQUIDE ADR | 2018-01-22 | 2018-08-08 | $1,504 | $1,613 | -$109 | -$109 | |
| 61. JOHNSON & JOHNSON COM | 1989-06-27 | 2018-08-16 | $8,065 | $388 | $7,677 | $7,677 | |
| 38. LAUDER ESTEE COS INC CL A | 2017-09-01 | 2018-08-16 | $5,077 | $4,098 | $979 | $979 | |
| 21. LAUDER ESTEE COS INC CL A | 2017-09-01 | 2018-08-16 | $2,809 | $2,265 | $544 | $544 | |
| 55. FACEBOOK INC | 2016-03-02 | 2018-08-17 | $9,525 | $6,026 | $3,499 | $3,499 | |
| 2. LAUDER ESTEE COS INC CL A | 2017-09-01 | 2018-08-17 | $270 | $216 | $54 | $54 | |
| 39. LAUDER ESTEE COS INC CL A | 2017-09-01 | 2018-08-17 | $5,274 | $4,204 | $1,070 | $1,070 | |
| 32. ALEXION PHARMACEUTICALS INC | 2018-01-24 | 2018-08-21 | $3,733 | $3,997 | -$264 | -$264 | |
| 4. BOOKING HOLDINGS INC | 2018-01-24 | 2018-08-21 | $7,557 | $7,806 | -$249 | -$249 | |
| 143. MORGAN STANLEY | 2018-01-24 | 2018-08-21 | $6,965 | $8,187 | -$1,222 | -$1,222 | |
| 1. NETFLIX.COM INC | 2018-01-24 | 2018-08-21 | $338 | $254 | $84 | $84 | |
| 75. PAYPAL HOLDINGS INC-W/I | 2018-01-24 | 2018-08-21 | $6,529 | $6,272 | $257 | $257 | |
| 44. PEPSICO INC COM | 2018-06-25 | 2018-08-21 | $5,006 | $4,784 | $222 | $222 | |
| 52. SALESFORCE.COM | 2018-01-24 | 2018-08-21 | $7,694 | $5,855 | $1,839 | $1,839 | |
| 34. SERVICE NOW INC | 2018-01-24 | 2018-08-21 | $6,270 | $4,946 | $1,324 | $1,324 | |
| 12. DELPHI TECHNOLOGIES PLC-W/I SEDOL BD85SC5 | 2018-06-05 | 2018-08-21 | $474 | $623 | -$149 | -$149 | |
| 29. DELPHI TECHNOLOGIES PLC-W/I SEDOL BD85SC5 | 2018-01-22 | 2018-08-21 | $1,145 | $1,512 | -$367 | -$367 | |
| 13. ROYAL DUTCH SHELL PLC ADR A | 2017-10-20 | 2018-08-23 | $843 | $794 | $49 | $49 | |
| 2. ROYAL DUTCH SHELL PLC ADR A | 2017-10-20 | 2018-08-24 | $132 | $122 | $10 | $10 | |
| 53. ROYAL DUTCH SHELL PLC ADR A | 2017-10-20 | 2018-08-24 | $3,486 | $3,236 | $250 | $250 | |
| 38. FACEBOOK INC | 2018-01-24 | 2018-08-27 | $6,758 | $7,141 | -$383 | -$383 | |
| 45. MICROSOFT CORP | 2018-04-27 | 2018-08-27 | $4,909 | $4,583 | $326 | $326 | |
| 46. ROYAL DUTCH SHELL PLC ADR A | 2017-10-20 | 2018-08-27 | $3,037 | $2,808 | $229 | $229 | |
| 1. ROYAL DUTCH SHELL PLC ADR A | 2017-10-20 | 2018-08-27 | $66 | $61 | $5 | $5 | |
| 74. DANSKE BANK A/S - SPON ADR ADR SEDOL BD981Y6 | 2018-06-15 | 2018-09-11 | $969 | $1,245 | -$276 | -$276 | |
| 14. TAIWAN SEMICONDUCTOR MTG CO ADR | 2018-01-22 | 2018-09-13 | $612 | $648 | -$36 | -$36 | |
| 45. LAM RESEARCH CORP | 2015-12-18 | 2018-09-14 | $6,890 | $3,489 | $3,401 | $3,401 | |
| 30. MARRIOTT INTERNATIONAL INC CL A | 2018-01-04 | 2018-09-14 | $3,917 | $4,087 | -$170 | -$170 | |
| 4. MARRIOTT INTERNATIONAL INC CL A | 2018-01-04 | 2018-09-14 | $520 | $545 | -$25 | -$25 | |
| 50. STRYKER CORP | 2017-03-14 | 2018-09-14 | $8,539 | $6,546 | $1,993 | $1,993 | |
| 36. MARRIOTT INTERNATIONAL INC CL A | 2018-01-04 | 2018-09-17 | $4,672 | $4,904 | -$232 | -$232 | |
| 103. DANSKE BANK A/S - SPON ADR ADR SEDOL BD981Y6 | 2018-06-15 | 2018-09-18 | $1,389 | $1,664 | -$275 | -$275 | |
| 9. HENKEL AG & COMPANY KGAA SPONS ADR PFD ADR | 2018-01-22 | 2018-09-18 | $1,093 | $1,258 | -$165 | -$165 | |
| 93. SCHNEIDER ELECTRIC SE | 2018-01-22 | 2018-09-18 | $1,486 | $1,733 | -$247 | -$247 | |
| 5. GARRETT MOTION INC-WI | 2018-01-24 | 2018-10-02 | $85 | $84 | $1 | $1 | |
| 45. TESLA INC | 2018-01-24 | 2018-10-05 | $12,017 | $15,605 | -$3,588 | -$3,588 | |
| 19. TESLA INC | 2018-04-13 | 2018-10-05 | $5,074 | $5,713 | -$639 | -$639 | |
| 8. BORG WARNER INC. | 2017-08-18 | 2018-10-11 | $312 | $356 | -$44 | -$44 | |
| 11. BORG WARNER INC. | 2017-08-18 | 2018-10-11 | $426 | $489 | -$63 | -$63 | |
| 41. BORG WARNER INC. | 2017-08-18 | 2018-10-11 | $1,562 | $1,823 | -$261 | -$261 | |
| .9 GARRETT MOTION INC-WI | 2018-01-24 | 2018-10-11 | $14 | $15 | -$1 | -$1 | |
| 20. US FOODS HOLDING CORP | 2018-06-18 | 2018-10-11 | $584 | $747 | -$163 | -$163 | |
| 185. US FOODS HOLDING CORP | 2018-06-13 | 2018-10-11 | $5,248 | $6,883 | -$1,635 | -$1,635 | |
| 58. BORG WARNER INC. | 2017-08-18 | 2018-10-12 | $2,192 | $2,579 | -$387 | -$387 | |
| 47. BORG WARNER INC. | 2017-08-18 | 2018-10-15 | $1,789 | $2,089 | -$300 | -$300 | |
| 8. BORG WARNER INC. | 2017-08-18 | 2018-10-15 | $306 | $356 | -$50 | -$50 | |
| 30. BORG WARNER INC. | 2017-08-18 | 2018-10-16 | $1,145 | $1,333 | -$188 | -$188 | |
| 12. BORG WARNER INC. | 2017-08-18 | 2018-10-16 | $458 | $533 | -$75 | -$75 | |
| 11. SAP SE SPONSORED ADR | 2018-01-22 | 2018-10-16 | $1,287 | $1,238 | $49 | $49 | |
| 803. LLOYDS TSB GROUP PLC SPONSORED ADR | 2018-01-22 | 2018-10-23 | $2,313 | $3,316 | -$1,003 | -$1,003 | |
| 2. APPLIED MATERIALS INC | 2016-07-13 | 2018-10-25 | $65 | $52 | $13 | $13 | |
| 143. APPLIED MATERIALS INC | 2016-07-13 | 2018-10-25 | $4,666 | $3,702 | $964 | $964 | |
| 130. DOWDUPONT INC | 2015-04-28 | 2018-10-25 | $6,888 | $6,699 | $189 | $189 | |
| 16. DOWDUPONT INC | 2015-04-29 | 2018-10-25 | $853 | $824 | $29 | $29 | |
| 5. APPLIED MATERIALS INC | 2016-07-13 | 2018-10-26 | $159 | $129 | $30 | $30 | |
| 4. DOWDUPONT INC | 2015-04-29 | 2018-10-26 | $209 | $206 | $3 | $3 | |
| 5. HOYA CORP SPONSORED ADR | 2018-01-22 | 2018-10-26 | $269 | $258 | $11 | $11 | |
| 12. HOYA CORP SPONSORED ADR | 2018-08-17 | 2018-10-26 | $647 | $706 | -$59 | -$59 | |
| 4. AMAZON.COM INC | 2018-07-10 | 2018-10-30 | $6,003 | $6,986 | -$983 | -$983 | |
| 2. BOOKING HOLDINGS INC | 2018-01-24 | 2018-10-30 | $3,634 | $3,903 | -$269 | -$269 | |
| 35. CROWN CASTLE INTL CORP | 2018-01-24 | 2018-10-30 | $3,808 | $3,834 | -$26 | -$26 | |
| 25. HONEYWELL INTL INC | 2018-01-24 | 2018-10-30 | $3,527 | $3,831 | -$304 | -$304 | |
| 51. INTERCONTINENTAL EXCHANGE INC | 2018-01-24 | 2018-10-30 | $3,706 | $3,842 | -$136 | -$136 | |
| 70. J P MORGAN CHASE & CO COM | 2018-01-24 | 2018-10-30 | $7,370 | $8,092 | -$722 | -$722 | |
| 25. NEXTERA ENERGY INC | 2018-01-24 | 2018-10-30 | $4,308 | $3,787 | $521 | $521 | |
| 38. PHILIP MORRIS INTERNAT-W/I | 2018-01-24 | 2018-10-30 | $3,447 | $4,199 | -$752 | -$752 | |
| .833 RESIDEO TECHNOLOGIES INC-W/I | 2018-01-24 | 2018-11-01 | $19 | $24 | -$5 | -$5 | |
| 234. FIRST DATA CORP- CLASS A | 2018-08-17 | 2018-11-02 | $4,380 | $5,889 | -$1,509 | -$1,509 | |
| 9. RESIDEO TECHNOLOGIES INC-W/I | 2018-01-24 | 2018-11-02 | $194 | $257 | -$63 | -$63 | |
| 6. TEXAS INSTRS INC COM | 2015-12-18 | 2018-11-02 | $571 | $331 | $240 | $240 | |
| 129. TEXAS INSTRS INC COM | 2015-12-18 | 2018-11-02 | $12,246 | $7,123 | $5,123 | $5,123 | |
| 38. FIRST DATA CORP- CLASS A | 2018-08-17 | 2018-11-05 | $701 | $939 | -$238 | -$238 | |
| 4. FIRST DATA CORP- CLASS A | 2018-08-17 | 2018-11-05 | $74 | $99 | -$25 | -$25 | |
| 33. FIRST DATA CORP- CLASS A | 2018-08-17 | 2018-11-06 | $616 | $815 | -$199 | -$199 | |
| 6. FIRST DATA CORP- CLASS A | 2018-08-17 | 2018-11-06 | $112 | $148 | -$36 | -$36 | |
| 48. MITSUBISHI ELEC CORP UNSPON ADR | 2018-05-15 | 2018-11-06 | $1,239 | $1,447 | -$208 | -$208 | |
| 25. ROYAL CARRIBEAN CRUISES LTD SEDOL 2754907 ISIN LR0008862868 | 2017-04-07 | 2018-11-08 | $2,709 | $2,434 | $275 | $275 | |
| 30. ROYAL CARRIBEAN CRUISES LTD SEDOL 2754907 ISIN LR0008862868 | 2017-04-07 | 2018-11-09 | $3,229 | $2,915 | $314 | $314 | |
| 5. ROYAL CARRIBEAN CRUISES LTD SEDOL 2754907 ISIN LR0008862868 | 2017-04-07 | 2018-11-09 | $539 | $485 | $54 | $54 | |
| 5. ROYAL CARRIBEAN CRUISES LTD SEDOL 2754907 ISIN LR0008862868 | 2017-04-07 | 2018-11-12 | $532 | $485 | $47 | $47 | |
| 14. ALIBABA GROUP HOLDING LTD ADR SEDOL BP41ZD1 | 2018-01-24 | 2018-11-13 | $2,028 | $2,733 | -$705 | -$705 | |
| 33. FEDEX CORPORATION | 2018-05-15 | 2018-11-16 | $7,474 | $8,162 | -$688 | -$688 | |
| 2. FEDEX CORPORATION | 2018-05-15 | 2018-11-16 | $452 | $495 | -$43 | -$43 | |
| 1. NU SKIN ENTERPRISES 67018T105 | 2001-01-01 | 2018-11-23 | $520 | $25 | $495 | $495 | |
| 65. VALEO SPONSORED ADR | 2018-01-22 | 2018-12-03 | $994 | $2,616 | -$1,622 | -$1,622 | |
| 36. L OREAL CO UNSPONSORED ADR | 2018-01-22 | 2018-12-11 | $1,684 | $1,641 | $43 | $43 | |
| 20. UNILEVER N V N Y SHS NEW | 2018-01-22 | 2018-12-11 | $1,112 | $1,150 | -$38 | -$38 | |
| 75. DEUTSCHE BOERSE AG UNSPN ADR | 2018-01-22 | 2018-12-13 | $907 | $910 | -$3 | -$3 | |
| 25. SGS S.A. UNSPONSORED ADR | 2018-01-22 | 2018-12-13 | $590 | $682 | -$92 | -$92 | |
| 111. SUNCOR ENERGY INC ISIN CA8672241079 SEDOL B3NB1P2 | 2018-08-24 | 2018-12-13 | $3,405 | $4,632 | -$1,227 | -$1,227 | |
| 75. UNITED TECHNOLOGIES CORP COM | 2018-07-13 | 2018-12-13 | $8,952 | $9,713 | -$761 | -$761 | |
| 7. AON PLC | 2018-01-22 | 2018-12-13 | $1,089 | $949 | $140 | $140 | |
| 74. SUNCOR ENERGY INC ISIN CA8672241079 SEDOL B3NB1P2 | 2018-08-23 | 2018-12-14 | $2,200 | $3,052 | -$852 | -$852 | |
| 1. WYETH XXX-XX-XXXX | 2001-01-01 | 2018-12-17 | $22 | $22 | |||
| 254. CIELO S.A. ADR | 2018-01-22 | 2018-12-20 | $592 | $2,164 | -$1,572 | -$1,572 | |
| 28. CROWN CASTLE INTL CORP | 2018-01-24 | 2018-12-20 | $3,080 | $3,067 | $13 | $13 | |
| 24. NEXTERA ENERGY INC | 2018-01-24 | 2018-12-20 | $4,189 | $3,636 | $553 | $553 | |
| 27. CHUBB LTD SEDOL B3BQMF6 | 2018-01-24 | 2018-12-20 | $3,350 | $4,150 | -$800 | -$800 | |
| CAPITAL GAIN DIVIDENDS | $101,860 | P |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Capital Gain Net Income | $1,450,558 | CapitalGainNetIncomeAmt |
Qlfy Und Sect4940e Reduced Tax QlfyUndSect4940eReducedTaxGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Liable Section4942 Tax | false | LiableSection4942TaxInd |
| Adjusted Qlfy Distri Yr1 | $378,079 | AdjustedQlfyDistriYr1Amt |
| Net Vl Noncharitable Assets Yr1 | $8,084,571 | NetVlNoncharitableAssetsYr1Amt |
| Distribution Yr1 | 0.046765 | DistributionYr1Rt |
| Adjusted Qlfy Distri Yr2 | $339,108 | AdjustedQlfyDistriYr2Amt |
| Net Vl Noncharitable Assets Yr2 | $7,541,554 | NetVlNoncharitableAssetsYr2Amt |
| Distribution Yr2 | 0.044965 | DistributionYr2Rt |
| Adjusted Qlfy Distri Yr3 | $320,982 | AdjustedQlfyDistriYr3Amt |
| Net Vl Noncharitable Assets Yr3 | $7,867,307 | NetVlNoncharitableAssetsYr3Amt |
| Distribution Yr3 | 0.040799 | DistributionYr3Rt |
| Adjusted Qlfy Distri Yr4 | $375,334 | AdjustedQlfyDistriYr4Amt |
| Net Vl Noncharitable Assets Yr4 | $7,799,878 | NetVlNoncharitableAssetsYr4Amt |
| Distribution Yr4 | 0.04812 | DistributionYr4Rt |
| Adjusted Qlfy Distri Yr5 | $373,270 | AdjustedQlfyDistriYr5Amt |
| Net Vl Noncharitable Assets Yr5 | $7,292,359 | NetVlNoncharitableAssetsYr5Amt |
| Distribution Yr5 | 0.051186 | DistributionYr5Rt |
| Total Distribution | 0.231835 | TotalDistributionRt |
| Average Distribution | 0.046367 | AverageDistributionRt |
| Net Vl Noncharitable Assets | $8,279,204 | NetVlNoncharitableAssetsAmt |
| Adj Net Vl Noncharitable Assets | $383,882 | AdjNetVlNoncharitableAssetsAmt |
| Net Investment Income Pct | $15,813 | NetInvestmentIncomePctAmt |
| Adj Nonchrtbl Net Invst Incm Pct | $399,695 | AdjNonchrtblNetInvstIncmPctAmt |
| Qualifying Distributions | $412,132 | QualifyingDistributionsAmt |
Excise Tax Based On Invst Incm ExciseTaxBasedOnInvstIncmGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Domestic Org Meeting Sect4940e | Yes (X) | DomesticOrgMeetingSect4940eInd |
| Investment Income Excise Tax | $15,813 | InvestmentIncomeExciseTaxAmt |
| Tax Under Section511 | $0 | TaxUnderSection511Amt |
| Subtotal | $15,813 | SubtotalAmt |
| Subtitle A Tax | $0 | SubtitleATaxAmt |
| Tax Based On Investment Income | $15,813 | TaxBasedOnInvestmentIncomeAmt |
| Estimated Plus Ovpmt Incm Tx | $8,238 | EstimatedPlusOvpmtIncmTxAmt |
| Extsn Request Income Tax Paid | $0 | ExtsnRequestIncomeTaxPaidAmt |
| Total Payments And Credits | $8,238 | TotalPaymentsAndCreditsAmt |
| Es Penalty | $0 | EsPenaltyAmt |
| Tax Due | $7,575 | TaxDueAmt |
| Applied To ES Tax | $0 | AppliedToESTaxAmt |
| Refund | $0 | RefundAmt |
Statements Regarding Acty StatementsRegardingActyGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Legislative Political Acty | false | LegislativePoliticalActyInd |
| More Than100 Spent | false | MoreThan100SpentInd |
| Form1120 POL Filed | false | Form1120POLFiledInd |
| Activities Not Previously Rpt | false | ActivitiesNotPreviouslyRptInd |
| Changes To Articles Or Bylaws | false | ChangesToArticlesOrBylawsInd |
| Unrelated Bus Incm Over Limit | false | UnrelatedBusIncmOverLimitInd |
| Organization Dissolved Etc | false | OrganizationDissolvedEtcInd |
| Section508e Rqr Satisfied | Yes (true) | Section508eRqrSatisfiedInd |
| At Least5000 In Assets | Yes (true) | AtLeast5000InAssetsInd |
| Org Report Or Register State | PA | OrgReportOrRegisterStateCd |
| Form990 PF Filed With Atty Gen | Yes (true) | Form990PFFiledWithAttyGenInd |
| Private Operating Foundation | false | PrivateOperatingFoundationInd |
| New Substantial Contributors | false | NewSubstantialContributorsInd |
| Own Controlled Entity | false | OwnControlledEntityInd |
| Donor Advised Fund | false | DonorAdvisedFundInd |
| Comply With Public Insp Rqr | Yes (true) | ComplyWithPublicInspRqrInd |
| Website Address | SEE FOOTNOTE | WebsiteAddressTxt |
Persons With Books Name PersonsWithBooksName
| Field | Value | IRS element (for citing) |
|---|---|---|
| Business Name Line1 | PNC BANK NA | BusinessNameLine1Txt |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Phone | 4127623792 | PhoneNum |
Location Of Books US Address LocationOfBooksUSAddress
| Field | Value | IRS element (for citing) |
|---|---|---|
| Address Line1 | 116 ALLEGHENY CENTER MALL | AddressLine1Txt |
| City | PITTSBURGH | CityNm |
| State Abbreviation | PA | StateAbbreviationCd |
| ZIP | 15212 | ZIPCd |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Foreign Accounts Question | false | ForeignAccountsQuestionInd |
Statements Regarding Acty4720 StatementsRegardingActy4720Grp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Sale Or Exch Disqualified Prsn | false | SaleOrExchDisqualifiedPrsnInd |
| Brrw Or Lend Disqualified Prsn | false | BrrwOrLendDisqualifiedPrsnInd |
| Furn Goods Disqualified Prsn | false | FurnGoodsDisqualifiedPrsnInd |
| Pay Comp Disqualified Prsn | Yes (true) | PayCompDisqualifiedPrsnInd |
| Transfer Ast Disqualified Prsn | false | TransferAstDisqualifiedPrsnInd |
| Payment To Government Official | false | PaymentToGovernmentOfficialInd |
| Acts Fail To Qlfy As Exceptions | false | ActsFailToQlfyAsExceptionsInd |
| Uncorrected Prior Acts | false | UncorrectedPriorActsInd |
| Undistributed Income PY | false | UndistributedIncomePYInd |
| Business Holdings | false | BusinessHoldingsInd |
| Jeopardy Investments | false | JeopardyInvestmentsInd |
| Uncorrected PY Jeopardy Invst | false | UncorrectedPYJeopardyInvstInd |
| Influence Legislation | false | InfluenceLegislationInd |
| Influence Election | false | InfluenceElectionInd |
| Grants To Individuals | false | GrantsToIndividualsInd |
| Grants To Organizations | false | GrantsToOrganizationsInd |
| Noncharitable Purpose | false | NoncharitablePurposeInd |
| Rcv Fnds To Pay Prsnl Bnft Cntrct | false | RcvFndsToPayPrsnlBnftCntrctInd |
| Pay Premiums Prsnl Bnft Cntrct | false | PayPremiumsPrsnlBnftCntrctInd |
| Prohibited Tax Shelter Trans | false | ProhibitedTaxShelterTransInd |
| Subj To Tax Rmnrtn Ex Prcht Pymt | false | SubjToTaxRmnrtnExPrchtPymtInd |
Officer Dir Trst Key Empl Info OfficerDirTrstKeyEmplInfoGrp
Officer Dir Trst Key Empl OfficerDirTrstKeyEmplGrp
Business Name BusinessName
| Field | Value | IRS element (for citing) |
|---|---|---|
| Business Name Line1 | PNC BANK NA | BusinessNameLine1Txt |
US Address USAddress
| Field | Value | IRS element (for citing) |
|---|---|---|
| Address Line1 | 116 ALLEGHENY CENTER MALL | AddressLine1Txt |
| City | PITTSBURGH | CityNm |
| State Abbreviation | PA | StateAbbreviationCd |
| ZIP | 15212 | ZIPCd |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Title | TRUSTEE | TitleTxt |
| Average Hrs Per Wk Devoted To Pos | 14 | AverageHrsPerWkDevotedToPosRt |
| Compensation | $67,771 | CompensationAmt |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Comp Of Hghst Pd Empl Or NONE | NONE | CompOfHghstPdEmplOrNONETxt |
| Other Employee Paid Over50k | 0 | OtherEmployeePaidOver50kCnt |
| Comp Of Hghst Pd Cntrct Or NONE | NONE | CompOfHghstPdCntrctOrNONETxt |
| Contractor Paid Over50k | 0 | ContractorPaidOver50kCnt |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Summary Of Direct Chrtbl Acty | SummaryOfDirectChrtblActyGrp | |
| Sum Of Program Related Invst | SumOfProgramRelatedInvstGrp |
Minimum Investment Return MinimumInvestmentReturnGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Average Monthly FMV Of Sec | $8,405,283 | AverageMonthlyFMVOfSecAmt |
| Average Monthly Cash Balances | $0 | AverageMonthlyCashBalancesAmt |
| FMV All Other Noncharitable Ast | $0 | FMVAllOtherNoncharitableAstAmt |
| Total FMV Of Unused Assets | $8,405,283 | TotalFMVOfUnusedAssetsAmt |
| Reduction Claimed | $0 | ReductionClaimedAmt |
| Acquisition Indebtedness | $0 | AcquisitionIndebtednessAmt |
| Adjusted Total FMV Of Unused Ast | $8,405,283 | AdjustedTotalFMVOfUnusedAstAmt |
| Cash Deemed Charitable | $126,079 | CashDeemedCharitableAmt |
| Net Vl Noncharitable Assets | $8,279,204 | NetVlNoncharitableAssetsAmt |
| Minimum Investment Return | $413,960 | MinimumInvestmentReturnAmt |
Distributable Amount DistributableAmountGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Minimum Investment Return | $413,960 | MinimumInvestmentReturnAmt |
| Tax Based On Investment Income | $15,813 | TaxBasedOnInvestmentIncomeAmt |
| Total Tax | $15,813 | TotalTaxAmt |
| Distributable Before Adj | $398,147 | DistributableBeforeAdjAmt |
| Recoveries Qualfied Distri | $0 | RecoveriesQualfiedDistriAmt |
| Distributable Before Ded | $398,147 | DistributableBeforeDedAmt |
| Deduction From Distributable | $0 | DeductionFromDistributableAmt |
| Distributable As Adjusted | $398,147 | DistributableAsAdjustedAmt |
Qualifying Distri Part XII QualifyingDistriPartXIIGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Expenses And Contributions | $412,132 | ExpensesAndContributionsAmt |
| Program Related Invst Total | $0 | ProgramRelatedInvstTotalAmt |
| Charitable Assets Acquis Paid | $0 | CharitableAssetsAcquisPaidAmt |
| Set Aside Suitability Test | $0 | SetAsideSuitabilityTestAmt |
| Set Aside Cash Distri Test | $0 | SetAsideCashDistriTestAmt |
| Qualifying Distributions | $412,132 | QualifyingDistributionsAmt |
| Pct Sect4940e Org Net Invst Incm | $15,813 | PctSect4940eOrgNetInvstIncmAmt |
| Adjusted Qualifying Distri | $396,319 | AdjustedQualifyingDistriAmt |
Undistributed Income UndistributedIncomeGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Distributable As Adjusted | $398,147 | DistributableAsAdjustedAmt |
| Undistributed Income PY | $382,372 | UndistributedIncomePYAmt |
| Total For Prior Years | $0 | TotalForPriorYearsAmt |
| Excess Distribution Cyov Yr5 | $0 | ExcessDistributionCyovYr5Amt |
| Excess Distribution Cyov Yr4 | $0 | ExcessDistributionCyovYr4Amt |
| Excess Distribution Cyov Yr3 | $0 | ExcessDistributionCyovYr3Amt |
| Excess Distribution Cyov Yr2 | $0 | ExcessDistributionCyovYr2Amt |
| Excess Distribution Cyov Yr1 | $0 | ExcessDistributionCyovYr1Amt |
| Total Excess Distribution Cyov | $0 | TotalExcessDistributionCyovAmt |
| Qualifying Distributions | $412,132 | QualifyingDistributionsAmt |
| Applied To Year1 | $382,372 | AppliedToYear1Amt |
| Applied To Prior Years | $0 | AppliedToPriorYearsAmt |
| Treated As Distri From Corpus | $0 | TreatedAsDistriFromCorpusAmt |
| Applied To Current Year | $29,760 | AppliedToCurrentYearAmt |
| Remaining Distri From Corpus | $0 | RemainingDistriFromCorpusAmt |
| Excess Distri Cyov App CY Corpus | $0 | ExcessDistriCyovAppCYCorpusAmt |
| Excess Distribution Cyov App CY | $0 | ExcessDistributionCyovAppCYAmt |
| Total Corpus | $0 | TotalCorpusAmt |
| Prior Year Undistributed Incm | $0 | PriorYearUndistributedIncmAmt |
| Prior Year Deficiency Or Tax | $0 | PriorYearDeficiencyOrTaxAmt |
| Taxable1 | $0 | Taxable1Amt |
| Taxable2 | $0 | Taxable2Amt |
| Undistributed Income CY | $368,387 | UndistributedIncomeCYAmt |
| Corpus Distri170b1 E Or4942g3 | $0 | CorpusDistri170b1EOr4942g3Amt |
| Excess Distri Cyov From Yr5 | $0 | ExcessDistriCyovFromYr5Amt |
| Excess Distri Cyov To Next Yr | $0 | ExcessDistriCyovToNextYrAmt |
| Excess From Year4 | $0 | ExcessFromYear4Amt |
| Excess From Year3 | $0 | ExcessFromYear3Amt |
| Excess From Year2 | $0 | ExcessFromYear2Amt |
| Excess From Year1 | $0 | ExcessFromYear1Amt |
| Excess From Current Year | $0 | ExcessFromCurrentYearAmt |
Supplementary Information SupplementaryInformationGrp
Application Submission Info ApplicationSubmissionInfoGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Recipient Person | PNC Charitable Trust Grant Review C | RecipientPersonNm |
Recipient US Address RecipientUSAddress
| Field | Value | IRS element (for citing) |
|---|---|---|
| Address Line1 | The Tower at PNC Plaza 300 Fifth A | AddressLine1Txt |
| City | Pittsburgh | CityNm |
| State Abbreviation | PA | StateAbbreviationCd |
| ZIP | 15222 | ZIPCd |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Recipient Phone | 4127625157 | RecipientPhoneNum |
| Form And Info And Materials | Please reference the name of the trust in all communications | FormAndInfoAndMaterialsTxt |
| Submission Deadlines | SEE FOONOTE | SubmissionDeadlinesTxt |
| Restrictions On Awards | SEE FOOTNOTE | RestrictionsOnAwardsTxt |
Grant Or Contribution Pd Dur Yr GrantOrContributionPdDurYrGrp (14 entries)
| Address Line1RecipientUSAddress/AddressLine1Txt | CityRecipientUSAddress/CityNm | State AbbreviationRecipientUSAddress/StateAbbreviationCd | ZIPRecipientUSAddress/ZIPCd | Recipient RelationshipRecipientRelationshipTxt | Recipient Foundation StatusRecipientFoundationStatusTxt | Grant Or Contribution PurposeGrantOrContributionPurposeTxt | AmtAmt |
|---|---|---|---|---|---|---|---|
| THE SALVATION ARMY | |||||||
| 796 COVE RD | WEIRTON | WV | 26062 | NONE | PC | 2014 EMERGENCY & RENT | $10,000 |
| WEIRTON CHRISTIAN CENTER | |||||||
| 3012 ELM STREET | WEIRTON | WV | 26062 | N/A | PUBLIC CHARITY | WCC EXPANSION | $84,328 |
| CITY OF WEIRTON BOARD OF PARKS | |||||||
| 601 COLLIERS WAY | WEIRTON | WV | 26062 | N/A | PUBLIC CHARITY | COURTS RESURFACE | $50,000 |
| HANCOCK COUNTY SHELTERED WORKSHOP | |||||||
| 1100 PENNSYLVANIA AVE | WEIRTON | WV | 26062 | NONE | PC | ROOF REPLACEMENT | $37,244 |
| DIRTY VAGABOND MINISTRIES | |||||||
| PO BOX 4284 | STEUBENVILLE | OH | 43952 | NONE | PC | FEED THE TEENS | $23,000 |
| COMMUNITY BREAD BASKET INC | |||||||
| PO BOX 154 | WEIRTON | WV | 26062 | NONE | PC | CLIENT UTILITY ASSISTANCE | $20,000 |
| URBAN MISSION MINISTRIES | |||||||
| 301 NORTH 5TH STREET | STEUBENVILLE | OH | 43952 | N/A | PUBLIC CHARITY | SHELTER RESTROOM RENOVATION | $37,500 |
| JEFFERSON COUNTY ANIMAL WELFARE LEAGUE | |||||||
| 129 MEADOW RD | WINTERSVILLE | OH | 43953 | NONE | PC | ANIMAL CARE | $29,800 |
| Weirton Madonna HIgh School | |||||||
| 150 MICHAEL WAY | Weirton | WV | 26062 | NONE | PC | GENERAL SUPPORT | $15,000 |
| Mary H Weir Public Library | |||||||
| 3442 MAIN STREET | Weirton | WV | 26062 | NONE | PC | GENERAL SUPPORT | $22,500 |
| Restoration of Weirton Nativity Set Fund | |||||||
| 208 HILLCREST ROAD | Weirton | WV | 26062 | NONE | PC | GENERAL SUPPORT | $17,000 |
| Old Fort Steuben Project Inc | |||||||
| 120 S THIRD STREET | Steubenville | OH | 43952 | NONE | PC | GENERAL PURPOSE | $9,000 |
| Young Women's Christian Association | |||||||
| 310 E CHARLES STREET | Munice | IN | 47305 | NONE | PC | GENERAL SUPPORT | $12,000 |
| Trinity Health Foundation | |||||||
| 2701 17TH STREET | Rock Island | IL | 61201 | NONE | PC | GENERAL SUPPORT | $15,000 |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Total Grant Or Contri Pd Dur Yr | $382,372 | TotalGrantOrContriPdDurYrAmt |
Analysis Income Producing Acty AnalysisIncomeProducingActyGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Fees Contracts From Govt Ag | FeesContractsFromGovtAgGrp | |
| Membership Dues And Assmnt | MembershipDuesAndAssmntGrp | |
| Int On Sav And Temp Cash Invst | IntOnSavAndTempCashInvstGrp |
Div And Int From Sec Part VII DivAndIntFromSecPartVIIGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Exclusion | 14 | ExclusionCd |
| Exclusion | $196,347 | ExclusionAmt |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Net Rntl Incm Re Debt Fincd Prop | NetRntlIncmReDebtFincdPropGrp | |
| Net Rntl Incm Re Not Debt Fincd Prop | NetRntlIncmReNotDebtFincdProp | |
| Net Rental Income Personal Prop | NetRentalIncomePersonalPropGrp | |
| Other Investment Incm Part VII | OtherInvestmentIncmPartVIIGrp |
Gain Sales Ast Oth Than Invntry GainSalesAstOthThanInvntryGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Exclusion | 18 | ExclusionCd |
| Exclusion | $1,450,558 | ExclusionAmt |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Net Income Loss From Special Evt | NetIncomeLossFromSpecialEvtGrp | |
| Gross Profit Loss Sls Of Invntry | GrossProfitLossSlsOfInvntryGrp |
Subtotals Incm Producing Acty SubtotalsIncmProducingActyGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Exclusion | $1,646,905 | ExclusionAmt |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Total Income Producing Acty | $1,646,905 | TotalIncomeProducingActyAmt |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Rln Of Acty To Accom Of Exmpt Prps | RlnOfActyToAccomOfExmptPrpsGrp |
Trnsfr Trans Rln Nonchrtbl EO TrnsfrTransRlnNonchrtblEOGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Trnsfr Of Cash To Nonchrtbl EO | false | TrnsfrOfCashToNonchrtblEOInd |
| Trnsfr Other Asset Nonchrtbl EO | false | TrnsfrOtherAssetNonchrtblEOInd |
| Sales Or Exchanges Of Assets | false | SalesOrExchangesOfAssetsInd |
| Purchase Of Assets Nonchrtbl EO | false | PurchaseOfAssetsNonchrtblEOInd |
| Rental Of Facilities Oth Assets | false | RentalOfFacilitiesOthAssetsInd |
| Reimbursement Arrangements | false | ReimbursementArrangementsInd |
| Loans Or Loan Guarantees | false | LoansOrLoanGuaranteesInd |
| Performance Of Services Etc | false | PerformanceOfServicesEtcInd |
| Sharing Of Facilities Etc | false | SharingOfFacilitiesEtcInd |
| Relationships Nonchrtbl EO | false | RelationshipsNonchrtblEOInd |
Other Assets Schedule OtherAssetsSchedule
Other Assets Schedule OtherAssetsScheduleGrp (3 entries)
| DescDesc | EOY Book ValueEOYBookValueAmt | EOYFMVEOYFMVAmt |
|---|---|---|
| ETF - EQUITY | $690,364 | $705,826 |
| MUTUAL FUNDS - EQUITY | $2,212,177 | $2,365,672 |
| MUTUAL FUNDS - FIXED INCOME | $2,771,520 | $2,689,672 |
Other Decreases Schedule OtherDecreasesSchedule
Other Decreases Detail OtherDecreasesDetail
| Field | Value | IRS element (for citing) |
|---|---|---|
| Desc | ROUNDING ADJ FOR SALES AND TRANSACTIONS | Desc |
| Amt | $4 | Amt |
Other Expenses Schedule OtherExpensesSchedule
Other Expenses Schedule OtherExpensesScheduleGrp (3 entries)
| DescDesc | Revenue And Expenses Per BooksRevenueAndExpensesPerBooksAmt | Net Investment IncomeNetInvestmentIncomeAmt | Disbursements Charitable PrpsDisbursementsCharitablePrpsAmt |
|---|---|---|---|
| MAP MANAGEMENT FEES | $2,865 | $2,865 | $0 |
| GRANTMAKING FEES | $22,982 | $0 | $22,982 |
| ADR SERVICE FEES | $259 | $259 | $0 |
Taxes Schedule TaxesSchedule
Taxes Detail TaxesDetail (3 entries)
| CategoryCategoryTxt | AmtAmt | Net Investment IncomeNetInvestmentIncomeAmt | Disbursements Charitable PrpsDisbursementsCharitablePrpsAmt |
|---|---|---|---|
| FOREIGN TAXES | $1,466 | $1,466 | $0 |
| FEDERAL TAX PAYMENT - PRIOR YE | $2,412 | $0 | $0 |
| FEDERAL ESTIMATES - PRINCIPAL | $8,238 | $0 | $0 |
Comments