The benchmark: SPY over one year, 19 Nov 2025 to 19 Nov 2026 (Yahoo, closing prices, checked 20 Nov 2026):
| SPY | 19 Nov 2025 | 19 Nov 2026 | Return |
|---|---|---|---|
| Close (price-only) | $662.63 | $715.87 | +8.03% |
| Adj Close (with dividends) | $655.56 | $715.87 | +9.20% |
Price-only: 715.87 ÷ 662.63 − 1 = +8.03%
Total: 715.87 ÷ 655.56 − 1 = +9.20%
SPY paid four dividends in that year, $7.58 a share in all. (Adj Close rewrites past prices downward to fold the dividends in, which is why the two start values differ.)
Your portfolio: $100,000 on 19 Nov 2025, no deposits or withdrawals, $110,000 on 19 Nov 2026 including dividends received and every position held or sold. Return: 110,000 ÷ 100,000 − 1 = +10.0%.
| Compared with | Benchmark | You beat it by |
|---|---|---|
| SPY price-only (wrong) | 8.03% | 1.97 points |
| SPY total return (right) | 9.20% | 0.80 points |
The price-only comparison flatters you by 1.17 points, roughly the dividends, and it does so every year you make the mistake.
Is 0.8 points skill? One year can't tell you: one lucky pick, or a sector you happened to hold, can produce it. You need several years, scored the same way.
For scale, in 2025 professionals mostly lost this game. The SPIVA U.S. Year-End 2025 Scorecard from S&P Dow Jones Indices found that "79% of all active large-cap U.S. equity funds underperformed the S&P 500" in calendar 2025, as quoted by InvestmentNews.
The sheet. One row per month, plus a row on any day you add or withdraw money. Record the value before that day's deposit:
| Date | Portfolio value | Deposit that day | SPY Adj Close |
|---|---|---|---|
| 19 Nov 2025 | $100,000 | $0 | $655.56 |
| … | … | … | … |
| 19 Nov 2026 | $110,000 | $0 | $715.87 |
With dates in column A from row 2 and the last row in row 14: in E3, the stretch return =B3/(B2+C2)-1 (start value plus that day's deposit), copied down; your year =PRODUCT(1+E3:E14)-1 (older Excel needs Ctrl+Shift+Enter); the benchmark =D14/D2-1.