Return Attribution — PNC Financial Services
← Portfolio Analysis
Clone backtest (value-weighted, one-quarter signal lag): each position's contribution = its portfolio weight × next-quarter return. Contribution sums equal the segment return of the clone.
PNC Financial Services (13F portfolio cloned at quarter-end weights) delivered a +2.96% return over the 2026-Q2 → latest period. The clone return is the sum of each position's contribution — portfolio weight times next-quarter price return.
Top drivers in 2026-Q2 → latest: GOOGL (+2.47%), MSFT (+0.70%), AAPL (+0.44%). Biggest drags: LLY (-0.31%), LRCX (-0.14%), HD (-0.10%). Across all 20 segmented periods, 25 stocks made a positive cumulative contribution and 24 subtracted from performance.
This attribution is a diagnostic tool, not a trading signal. The clone uses end-of-quarter holdings (45+ days after filing, so stale by design), applies quarter-end prices only, and ignores intra-quarter trades, shorts, and derivatives that 13F cannot show.
2026-Q2 → latest segment return
+2.96%
Top contributors
| Symbol | Weight | Return | Contrib |
|---|
| GOOGL |
1.5% |
+162.0% |
+2.47% |
| MSFT |
1.7% |
+41.0% |
+0.7% |
| AAPL |
2.7% |
+16.5% |
+0.44% |
| NVDA |
1.1% |
+19.0% |
+0.21% |
| XOM |
0.7% |
+20.3% |
+0.13% |
Biggest drags
| Symbol | Weight | Return | Contrib |
|---|
| LLY |
30.5% |
-1.0% |
-0.31% |
| LRCX |
0.6% |
-23.9% |
-0.14% |
| HD |
0.6% |
-18.5% |
-0.1% |
| VFC |
0.6% |
-13.8% |
-0.08% |
| CQQQ |
0.3% |
-22.1% |
-0.07% |
2026-Q1 → 2026-Q2 segment return
+16.11%
Top contributors
| Symbol | Weight | Return | Contrib |
|---|
| LLY |
27.3% |
+30.4% |
+8.3% |
| IVV |
5.9% |
+14.6% |
+0.87% |
| AAPL |
2.8% |
+13.4% |
+0.37% |
| LRCX |
0.3% |
+98.5% |
+0.32% |
| AIQ |
0.7% |
+40.6% |
+0.3% |
Biggest drags
| Symbol | Weight | Return | Contrib |
|---|
| XOM |
1.0% |
-18.7% |
-0.19% |
| CVX |
0.5% |
-19.1% |
-0.09% |
| MCD |
0.5% |
-12.4% |
-0.06% |
| PEP |
0.4% |
-12.7% |
-0.05% |
| ACN |
0.1% |
-36.7% |
-0.03% |
2025-Q4 → 2026-Q1 segment return
-5.58%
Top contributors
| Symbol | Weight | Return | Contrib |
|---|
| XOM |
0.7% |
+39.7% |
+0.27% |
| JNJ |
0.7% |
+18.2% |
+0.12% |
| CVX |
0.3% |
+34.6% |
+0.11% |
| LRCX |
0.3% |
+27.4% |
+0.07% |
| MRK |
0.4% |
+15.1% |
+0.07% |
Biggest drags
| Symbol | Weight | Return | Contrib |
|---|
| LLY |
30.1% |
-14.3% |
-4.32% |
| MSFT |
2.4% |
-22.8% |
-0.55% |
| IVV |
5.9% |
-4.6% |
-0.27% |
| AAPL |
2.8% |
-6.3% |
-0.18% |
| JPM |
1.2% |
-8.5% |
-0.1% |
2025-Q3 → 2025-Q4 segment return
+11.0%
Top contributors
| Symbol | Weight | Return | Contrib |
|---|
| LLY |
23.8% |
+42.0% |
+9.99% |
| AAPL |
3.0% |
+7.3% |
+0.22% |
| VFC |
0.7% |
+25.3% |
+0.17% |
| IVV |
6.3% |
+2.3% |
+0.15% |
| GOOG |
0.4% |
+29.2% |
+0.12% |
Biggest drags
| Symbol | Weight | Return | Contrib |
|---|
| MSFT |
2.9% |
-6.1% |
-0.18% |
| ORCL |
0.5% |
-30.9% |
-0.17% |
| HD |
0.8% |
-15.0% |
-0.12% |
| ERIE |
0.9% |
-9.9% |
-0.09% |
| KTB |
0.3% |
-23.4% |
-0.08% |
2025-Q2 → 2025-Q3 segment return
+4.01%
Top contributors
| Symbol | Weight | Return | Contrib |
|---|
| AAPL |
2.5% |
+23.4% |
+0.59% |
| IVV |
6.2% |
+7.8% |
+0.48% |
| NVDA |
1.0% |
+17.9% |
+0.18% |
| AVGO |
0.9% |
+20.0% |
+0.17% |
| VFC |
0.6% |
+22.8% |
+0.13% |
Biggest drags
| Symbol | Weight | Return | Contrib |
|---|
| LLY |
25.8% |
-2.8% |
-0.73% |
| ERIE |
1.1% |
-8.3% |
-0.09% |
| PM |
0.3% |
-10.9% |
-0.04% |
| ACN |
0.2% |
-17.1% |
-0.03% |
| V |
0.6% |
-3.8% |
-0.02% |
2025-Q1 → 2025-Q2 segment return
+1.41%
Top contributors
| Symbol | Weight | Return | Contrib |
|---|
| MSFT |
1.8% |
+33.0% |
+0.59% |
| IVV |
4.5% |
+10.5% |
+0.47% |
| AVGO |
0.4% |
+65.7% |
+0.28% |
| NVDA |
0.5% |
+46.5% |
+0.25% |
| JPM |
0.9% |
+18.4% |
+0.16% |
Biggest drags
| Symbol | Weight | Return | Contrib |
|---|
| LLY |
43.8% |
-5.5% |
-2.4% |
| ERIE |
1.1% |
-17.2% |
-0.19% |
| AAPL |
2.2% |
-7.1% |
-0.16% |
| VFC |
0.6% |
-24.3% |
-0.15% |
| UNH |
0.3% |
-40.5% |
-0.13% |
2024-Q4 → 2025-Q1 segment return
-0.25%
Top contributors
| Symbol | Weight | Return | Contrib |
|---|
| LLY |
26.5% |
+6.7% |
+1.78% |
| ABBV |
0.5% |
+19.0% |
+0.09% |
| XOM |
0.8% |
+10.6% |
+0.08% |
| PM |
0.2% |
+33.1% |
+0.07% |
| JNJ |
0.6% |
+12.0% |
+0.07% |
Biggest drags
| Symbol | Weight | Return | Contrib |
|---|
| AAPL |
3.2% |
-11.7% |
-0.38% |
| VFC |
1.1% |
-27.7% |
-0.3% |
| MSFT |
2.6% |
-11.3% |
-0.29% |
| IVV |
6.0% |
-4.5% |
-0.27% |
| AVGO |
0.7% |
-28.2% |
-0.21% |
2024-Q3 → 2024-Q4 segment return
-3.28%
Top contributors
| Symbol | Weight | Return | Contrib |
|---|
| AAPL |
2.9% |
+7.4% |
+0.22% |
| AVGO |
0.6% |
+34.6% |
+0.19% |
| AMZN |
0.8% |
+18.3% |
+0.14% |
| JPM |
0.9% |
+13.8% |
+0.13% |
| IVV |
5.5% |
+2.3% |
+0.12% |
Biggest drags
| Symbol | Weight | Return | Contrib |
|---|
| LLY |
29.2% |
-12.7% |
-3.7% |
| MRK |
0.6% |
-11.7% |
-0.07% |
| JNJ |
0.6% |
-10.8% |
-0.07% |
| XOM |
0.8% |
-8.1% |
-0.07% |
| IEFA |
0.7% |
-8.5% |
-0.06% |
2024-Q2 → 2024-Q3 segment return
+1.68%
Top contributors
| Symbol | Weight | Return | Contrib |
|---|
| AAPL |
2.8% |
+10.2% |
+0.29% |
| IVV |
5.4% |
+5.2% |
+0.28% |
| HD |
0.7% |
+17.5% |
+0.13% |
| MCD |
0.5% |
+20.2% |
+0.1% |
| SPY |
1.6% |
+5.3% |
+0.08% |
Biggest drags
| Symbol | Weight | Return | Contrib |
|---|
| LLY |
31.1% |
-2.4% |
-0.75% |
| MSFT |
2.8% |
-4.1% |
-0.12% |
| MRK |
0.7% |
-7.7% |
-0.05% |
| GOOG |
0.4% |
-9.2% |
-0.03% |
| AMZN |
0.8% |
-3.9% |
-0.03% |
2024-Q1 → 2024-Q2 segment return
+5.89%
Top contributors
| Symbol | Weight | Return | Contrib |
|---|
| LLY |
27.9% |
+16.7% |
+4.66% |
| AAPL |
2.4% |
+23.6% |
+0.58% |
| IVV |
5.5% |
+4.2% |
+0.23% |
| MSFT |
2.9% |
+6.5% |
+0.19% |
| NVDA |
0.4% |
+37.3% |
+0.13% |
Biggest drags
| Symbol | Weight | Return | Contrib |
|---|
| HD |
0.9% |
-10.1% |
-0.09% |
| INTC |
0.2% |
-29.8% |
-0.06% |
| JNJ |
0.7% |
-7.6% |
-0.05% |
| MCD |
0.6% |
-9.0% |
-0.05% |
| MRK |
0.8% |
-5.6% |
-0.04% |
2023-Q4 → 2024-Q1 segment return
+11.39%
Top contributors
| Symbol | Weight | Return | Contrib |
|---|
| LLY |
23.8% |
+33.5% |
+7.97% |
| IVV |
5.5% |
+10.0% |
+0.55% |
| MSFT |
2.9% |
+11.8% |
+0.34% |
| NVDA |
0.2% |
+82.7% |
+0.18% |
| JPM |
1.0% |
+17.6% |
+0.17% |
Biggest drags
| Symbol | Weight | Return | Contrib |
|---|
| AAPL |
3.1% |
-10.9% |
-0.34% |
| INTC |
0.3% |
-12.2% |
-0.03% |
| UNH |
0.5% |
-6.1% |
-0.03% |
| MCD |
0.7% |
-4.4% |
-0.03% |
| NKE |
0.1% |
-17.8% |
-0.03% |
2023-Q3 → 2023-Q4 segment return
+6.67%
Top contributors
| Symbol | Weight | Return | Contrib |
|---|
| LLY |
23.9% |
+8.6% |
+2.06% |
| IVV |
5.3% |
+11.1% |
+0.59% |
| MSFT |
2.7% |
+18.9% |
+0.51% |
| AAPL |
3.1% |
+12.2% |
+0.38% |
| QQQ |
1.4% |
+14.3% |
+0.21% |
Biggest drags
| Symbol | Weight | Return | Contrib |
|---|
| XOM |
1.1% |
-14.6% |
-0.17% |
| CVX |
0.6% |
-11.6% |
-0.07% |
| BMY |
0.2% |
-10.7% |
-0.03% |
| CSCO |
0.4% |
-6.1% |
-0.02% |
| SLB |
0.1% |
-10.3% |
-0.01% |
2023-Q2 → 2023-Q3 segment return
+1.12%
Top contributors
| Symbol | Weight | Return | Contrib |
|---|
| LLY |
20.8% |
+14.1% |
+2.95% |
| XOM |
1.0% |
+9.2% |
+0.1% |
| ABBV |
0.6% |
+11.9% |
+0.07% |
| AMGN |
0.2% |
+21.1% |
+0.04% |
| CVX |
0.6% |
+7.4% |
+0.04% |
Biggest drags
| Symbol | Weight | Return | Contrib |
|---|
| AAPL |
3.6% |
-11.9% |
-0.42% |
| MSFT |
3.0% |
-7.3% |
-0.21% |
| IVV |
5.4% |
-3.5% |
-0.19% |
| NEE |
0.4% |
-22.8% |
-0.1% |
| MRK |
0.9% |
-10.2% |
-0.09% |
2023-Q1 → 2023-Q2 segment return
+9.14%
Top contributors
| Symbol | Weight | Return | Contrib |
|---|
| LLY |
15.7% |
+37.6% |
+5.91% |
| AAPL |
3.2% |
+17.8% |
+0.57% |
| MSFT |
2.6% |
+18.0% |
+0.47% |
| IVV |
4.8% |
+8.0% |
+0.38% |
| QQQ |
1.6% |
+15.1% |
+0.23% |
Biggest drags
| Symbol | Weight | Return | Contrib |
|---|
| ABBV |
0.7% |
-14.7% |
-0.1% |
| XOM |
1.1% |
-2.2% |
-0.02% |
| DIS |
0.2% |
-11.1% |
-0.02% |
| CVX |
0.6% |
-3.6% |
-0.02% |
| BMY |
0.3% |
-7.0% |
-0.02% |
2022-Q4 → 2023-Q1 segment return
+1.14%
Top contributors
| Symbol | Weight | Return | Contrib |
|---|
| AAPL |
2.8% |
+26.9% |
+0.76% |
| MSFT |
2.4% |
+20.1% |
+0.49% |
| QQQ |
1.6% |
+20.5% |
+0.33% |
| IVV |
4.0% |
+7.3% |
+0.29% |
| SPY |
1.7% |
+7.1% |
+0.12% |
Biggest drags
| Symbol | Weight | Return | Contrib |
|---|
| LLY |
18.4% |
-7.0% |
-1.29% |
| JNJ |
1.2% |
-12.3% |
-0.15% |
| HD |
1.1% |
-6.8% |
-0.07% |
| CVX |
0.7% |
-9.3% |
-0.07% |
| VZ |
0.3% |
-22.0% |
-0.06% |
2022-Q3 → 2022-Q4 segment return
+9.26%
Top contributors
| Symbol | Weight | Return | Contrib |
|---|
| LLY |
17.7% |
+13.5% |
+2.39% |
| XOM |
1.1% |
+26.4% |
+0.28% |
| MRK |
0.8% |
+29.7% |
+0.25% |
| PG |
1.2% |
+20.9% |
+0.25% |
| IVV |
3.3% |
+7.1% |
+0.24% |
Biggest drags
| Symbol | Weight | Return | Contrib |
|---|
| AMZN |
0.8% |
-25.7% |
-0.19% |
| VFC |
2.4% |
-7.7% |
-0.19% |
| AAPL |
3.3% |
-5.5% |
-0.18% |
| TSLA |
0.1% |
-53.6% |
-0.06% |
| GOOG |
0.3% |
-7.6% |
-0.03% |
2022-Q2 → 2022-Q3 segment return
-5.45%
Top contributors
| Symbol | Weight | Return | Contrib |
|---|
| ERIE |
0.9% |
+15.7% |
+0.15% |
| AMZN |
0.7% |
+5.9% |
+0.04% |
| ADP |
0.3% |
+7.9% |
+0.02% |
| AAPL |
3.2% |
+0.6% |
+0.02% |
| DE |
0.1% |
+11.9% |
+0.02% |
Biggest drags
| Symbol | Weight | Return | Contrib |
|---|
| VFC |
3.4% |
-32.3% |
-1.09% |
| MSFT |
2.7% |
-9.3% |
-0.25% |
| IVV |
3.3% |
-5.4% |
-0.18% |
| PG |
1.3% |
-11.6% |
-0.16% |
| IEFA |
1.2% |
-10.5% |
-0.12% |
2022-Q1 → 2022-Q2 segment return
-4.81%
Top contributors
| Symbol | Weight | Return | Contrib |
|---|
| LLY |
13.2% |
+13.2% |
+1.74% |
| VZ |
0.4% |
+33.4% |
+0.13% |
| MRK |
0.7% |
+12.0% |
+0.08% |
| IBM |
0.1% |
+27.3% |
+0.04% |
| XOM |
0.9% |
+3.8% |
+0.03% |
Biggest drags
| Symbol | Weight | Return | Contrib |
|---|
| AAPL |
3.7% |
-21.8% |
-0.8% |
| IVV |
3.4% |
-16.7% |
-0.57% |
| QQQ |
2.4% |
-22.7% |
-0.54% |
| MSFT |
3.0% |
-17.0% |
-0.51% |
| AMZN |
0.9% |
-34.8% |
-0.31% |
2021-Q4 → 2022-Q1 segment return
-1.82%
Top contributors
| Symbol | Weight | Return | Contrib |
|---|
| LLY |
12.0% |
+3.7% |
+0.45% |
| XOM |
0.6% |
+35.5% |
+0.21% |
| CVX |
0.4% |
+38.7% |
+0.15% |
| ABBV |
0.6% |
+21.0% |
+0.12% |
| BMY |
0.3% |
+19.0% |
+0.05% |
Biggest drags
| Symbol | Weight | Return | Contrib |
|---|
| HD |
1.3% |
-27.8% |
-0.36% |
| MSFT |
3.1% |
-7.9% |
-0.24% |
| QQQ |
2.5% |
-8.9% |
-0.22% |
| META |
0.5% |
-33.8% |
-0.15% |
| IVV |
3.2% |
-4.6% |
-0.15% |
2021-Q3 → 2021-Q4 segment return
+5.97%
Top contributors
| Symbol | Weight | Return | Contrib |
|---|
| LLY |
11.2% |
+19.7% |
+2.21% |
| AAPL |
3.2% |
+25.4% |
+0.81% |
| MSFT |
2.9% |
+19.3% |
+0.57% |
| IVV |
3.2% |
+10.5% |
+0.34% |
| HD |
1.2% |
+26.0% |
+0.3% |
Biggest drags
| Symbol | Weight | Return | Contrib |
|---|
| PYPL |
0.2% |
-27.7% |
-0.06% |
| CMCSA |
0.4% |
-10.0% |
-0.04% |
| JPM |
1.2% |
-2.9% |
-0.04% |
| DIS |
0.4% |
-8.7% |
-0.03% |
| INTC |
0.5% |
-3.5% |
-0.02% |
Cumulative Contribution (all segments)