Dollar-Cost Averaging Calculator: DCA vs. Lump Sum

Disclaimer: This calculator is provided for educational and estimation purposes only and does not constitute formal financial advice.

What this calculator is actually testing

“Dollar-cost averaging always wins” is repeated often enough that it is worth testing directly rather than taking on faith. Dollar-cost averaging (DCA) means committing a fixed dollar amount on a set schedule — monthly, in this calculator — no matter what the price is doing that period. A lump sum means investing the entire pool of money on day one and then leaving it alone. Both strategies end up owning the same asset over the same horizon; the only difference is the timing of when each dollar goes to work.

That timing difference is not cosmetic. A dollar invested in month one is exposed to every period’s return between month one and the end of the plan. A dollar invested in the final month is exposed to exactly one period’s return. Averaging a fixed contribution across many periods necessarily gives most of the money less time in the market than a lump sum gets, which is precisely why the two strategies produce different ending balances even when both are investing in the identical asset.

How this calculator builds the price path

There is no live market feed behind a static page, so this tool does not try to fetch or predict a real price history. It builds a deterministic, documented price path from two numbers you set: an assumed average annual return and a swing around that average. The swing alternates up in odd periods and down in even periods, which is what lets a fixed contribution buy more units in the low-price periods and fewer in the high-price ones — the mechanic dollar-cost averaging is actually built to exploit. Converting both to a monthly figure:

where r is the average annual return and s is the annualized swing, both as decimals. Each period’s return alternates around that monthly baseline:

so odd periods (1, 3, 5, …) get the baseline plus the swing and even periods get the baseline minus the swing. An internal index price starts at 100 — never shown, and never relevant on its own — and evolves period by period:

Every contribution buys units at the price prevailing the instant it lands, before that period’s return is applied — the same instant a lump sum would already be fully invested at, which is what makes the two strategies directly comparable rather than one getting a head start the other did not.

The two ending values, and the average cost per unit

With a fixed contribution C paid every period for N periods, DCA’s ending value is the units bought each period, revalued at the final price P_N:

The lump sum invests the same total capital, C · N, at the starting price P_0 and rides the entire path to P_N:

Average cost per unit is total dollars spent divided by total units bought — a harmonic average, since it is weighted by equal dollar amounts rather than equal unit counts:

That harmonic average is never larger than the plain arithmetic average of the same prices, $\bar{P} = \frac{1}{N}\sum P_{t-1}$ — buying more units when the price is down pulls the weighted average down every time. This is the one part of dollar-cost averaging that is unconditionally true regardless of market direction; whether it translates into a higher ending balance than a lump sum depends entirely on which way the asset actually moved.

Same swing, different trend: when DCA wins

Holding the swing at 15% and the horizon at 24 months, moving only the assumed average annual return shows exactly where the crossover sits. Every row here — including the 0% one — still carries that same 15% swing, so the 0% row is not a flat, no-movement path; a genuinely flat path is covered separately below.

The pattern is exactly what “more time in the market” would predict: every assumed uptrend favors the lump sum, and only once the assumed trend turns meaningfully negative does phasing the money in gradually start to help. The crossover in this model sits between 0% and roughly −1% — a market that is flat to mildly declining is close to indifferent between the two strategies, and the swing itself (buying more on dips) is what keeps DCA from losing by even more than the pure time-in-market gap would otherwise produce.

The gap compounds with the horizon

Holding the return at 8% and the swing at 15%, only stretching the number of months shows how much the stakes of this choice scale with time:

Doubling the horizon from 60 to 120 months more than quintuples the gap, not merely doubles it — the lump sum’s extra time-in-market advantage compounds on itself the same way regular compound interest does. This is the practical argument for lump-sum investing whenever the full amount is genuinely available: the longer the horizon, the more expensive it becomes to phase money in instead of putting it to work immediately.

The cost-basis benefit survives even when DCA loses

The gap above measures who ends up with more money. It says nothing about whether dollar-cost averaging still did its one guaranteed job: lowering the average price paid per unit. Using the same return scenarios as the first table, average cost per unit versus the simple average price:

The average-cost column sits below the simple-average column in every single row, whether or not dollar-cost averaging won the larger battle over ending value. That consistency is the mathematical guarantee: a fixed dollar amount buying a varying number of units always produces a harmonic average at or below the arithmetic one. It just is not, by itself, a guarantee of beating a lump sum — those are two different claims that get conflated constantly in casual investing advice.

Volatility drag: why a flat average can still lose ground

Set the average annual return to 0% and the swing to anything above zero and both strategies still end up slightly behind where they started — $11,914 for DCA and $11,978 for the lump sum on $12,000 invested, at the calculator’s defaults with the return zeroed out. That is not a bug; it is volatility drag (sometimes called variance drain), and it is worth understanding on its own because it shows up in real markets too, not just this model.

Alternating a fixed percentage up and then down does not return a price to where it started, because a percentage loss needs a larger percentage gain to offset it than the size of the loss itself. Swinging 15% up and then 15% down across two periods multiplies the price by $1.15 \times 0.85 = 0.9775$ — a net loss of 2.25% — even though the simple average of +15% and −15% is exactly 0%. The wider the swing around a flat trend, the larger this drag. It is a real feature of compounding returns, and it is one reason a volatile asset with a 0% average annual return can still lose money over time even before fees or taxes enter the picture.

What this model deliberately does not do

This calculator is a teaching tool for the mechanics of dollar-cost averaging, not a market simulator or a forecasting tool, and the simplifications are worth stating plainly. The alternating up-then-down pattern is an artificial device chosen to make the “buy more on dips” mechanic visible and auditable — real prices do not move in a fixed two-period cycle, and no real asset’s future returns are known in advance the way this model’s inputs are. The model also ignores dividends, capital-gains and income taxes, brokerage fees, bid-ask spreads, and any behavioral factor — such as an investor stopping contributions during a real downturn, which is the single most common way dollar-cost averaging fails in practice, and something a static formula cannot capture. Use this tool to understand why the two strategies produce different numbers, then apply that understanding with real, asset-specific return assumptions — or, more honestly, with the acknowledgment that nobody knows the sequence of returns in advance, which is the actual reason DCA appeals to many investors regardless of what the expected-value math says.