Lesson 8 of 8

Measuring your performance honestly

Step 3 of 6

Worked example

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.