compoundcoast
Accumulate · signature

DCA vs Lump Sum — rolling-window backtest

You have a windfall: invest it all at once, or drip it in? This rolls the decision across every start year since 1928 on S&P 500 total return, credits undeployed cash the T-bill, and puts the win-rate and the 5th-percentile downside on screen — net of fees, tax, and inflation.

S&P 500 total return · asOf 2026-01 3-mo T-bill · asOf 2026-01 CPI-U · asOf 2026-01 Updated 2026-07-22

Assumptions

live · every start year since 1928
The windfall you are choosing how to invest.
DCA invests an equal tranche at the start of each year (annual granularity).
Account type
Taxable applies 15% long-term capital-gains tax at liquidation.
Reinvest dividends
On uses S&P 500 total return. Off subtracts an approximate 1.9% yield.
Credit undeployed cash (T-bill)
DCA cash waiting to be invested earns the 3-month T-bill.
Show results in
Real deflates each window by December CPI-U over its span.
100 bps = 1.00%/yr, dragged off the invested market return.
Run the backtest across every start year since 1928.
Lump median terminal 5th-pct downside
Median lump-sum path Range across start years (p5–p95)
Set your inputs — this rolls the decision across every start year, not one lucky date. Markets vary, so the honest answer is a range, not a single number.

Terminal value range

lump sum p5 · median · p95

Coral = 5th-percentile downside, green = median, lime = 95th-percentile upside. The band spans the DCA outcome range for the same windows.

Lump − DCA spread

% of capital, every start year

Bars right of the “tie” line are start years where investing all at once ended ahead; bars left are where DCA won.

Lump IRR p5–p95
DCA IRR p5–p95
Methodology & sources
Show the math
Run the backtest to see the worked numbers for your inputs.
Assumptions & sources
AssumptionValueSource · asOf
Equity return S&P 500 total return Damodaran (NYU Stern), annual · asOf 2026-01 · dividends reinvested
Undeployed cash 3-month T-bill Damodaran (NYU Stern), avg rate in year · asOf 2026-01
Inflation (real mode) CPI-U, Dec/Dec BLS · asOf 2026-01
Coverage 1928–2025 every start year with a full deployment window
Taxable liquidation 15% LTCG on gains applied at end of window; annual dividend tax not modeled (v1)

Outcomes are evaluated at the end of the deployment window, where both strategies are fully invested and compound identically thereafter. Annual granularity uses the Damodaran yearly series; monthly Shiller granularity is a planned refinement.

Common questions

Is it better to invest a lump sum or dollar-cost average?

Rather than pick a winner, this tool rolls the choice across every start year since 1928 on S&P 500 total return and reports how often each approach ended ahead, the 5th-percentile downside, and the Lump minus DCA spread as a percent of capital. Because markets vary, the honest answer is a range across start years, not one date. Bars right of the tie line are years lump-sum led; bars left are years DCA led.

What is dollar-cost averaging and how does this backtest model it?

Dollar-cost averaging spreads a windfall into equal tranches invested at the start of each year instead of deploying it all immediately. In this backtest you choose a span of 2, 3, 4, 5, or 10 years, with 3 the default, and the cash still waiting to be invested earns the 3-month T-bill. Both strategies are compared at the end of the deployment window, where each is fully invested and compounds identically after that.

How does the cash waiting to be invested affect DCA results?

While a dollar-cost-averaging plan holds money back, that undeployed cash earns the 3-month T-bill rather than the S&P 500 total return, and the tool lets you switch that credit on or off, where off treats it as 0 percent. Whether investing all at once ends ahead depends on how equities performed against the T-bill over each window since 1928, which is why the result is shown as a distribution rather than a verdict.

How does the calculator handle taxes, fees, and inflation?

Results are net of fees, tax, and inflation. A taxable account applies 15 percent long-term capital-gains tax at liquidation, while the IRA or Roth setting applies none; annual dividend tax is not modeled in this version. An annual fee in basis points is dragged off the invested market return. Real mode deflates each window by December CPI-U over its span, and turning dividend reinvestment off subtracts an approximate 1.9 percent yield.

Written by Chris Park · Updated 2026-07-22
Embed this calculator on your site

Drop the snippet into a post or page — everything runs client-side. The credit line is optional: removing it or adding nofollow is fine, and the embed stays free either way. Sizing, theming, and the full list ›

<iframe src="https://compoundcoast.com/accumulate/dca-vs-lump-sum/?embed=1" title="DCA vs Lump Sum Calculator — compoundcoast" width="100%" height="1800" loading="lazy" style="border:1px solid #2a3350;border-radius:12px"></iframe>
<p>Calculator by <a href="https://compoundcoast.com/accumulate/dca-vs-lump-sum/" rel="nofollow">compoundcoast</a></p>

Related