Dollar-Cost Averaging vs Lump Sum Calculator

Understanding the DCA vs lump sum calculator — concept and principle

If you have a sum ready to invest, you can put it all in today (lump sum) or spread it over several months (dollar-cost averaging, DCA). This calculator compares the two at the end of your holding horizon, assuming the market rises at a steady rate, so you can see what waiting costs in a rising market.

How it is calculated

• Monthly rate: i = (1 + annual return)^(1/12) − 1.
• Lump sum: LS = A × (1 + i)^N, with N = horizon in years × 12.
• DCA: A ÷ k is invested at the start of each of k months; the payment in month j grows for N − j months, and DCA = Σ (A/k) × (1 + i)^(N − j) for j = 0 … k − 1.
• The difference is LS − DCA. Cash waiting to be invested earns nothing in this model.
• "Uninvested cash (avg.)" is shown as A ÷ 2, a rough guide to how much money sits idle during the DCA period.

The principle

With a positive expected return, money that is invested earlier has more time to compound. DCA keeps part of the money out of the market for a while, so in a steadily rising market it always ends behind. Its value lies elsewhere: in a volatile market it lowers the risk of investing everything just before a fall and buys more units when prices are low. Vanguard's 2012 study of US, UK and Australian markets found lump sum ahead in about two-thirds of historical periods.

Worked example

1. Inputs: $12,000, DCA over 12 months, 7% a year, 10-year horizon.
2. Monthly rate: 1.07^(1/12) − 1 ≈ 0.5654%; N = 120 months.
3. Lump sum: 12,000 × 1.07¹⁰ = $23,606.
4. DCA: $1,000 a month for 12 months; the first grows 120 months to about $1,967, the last 109 months. Their total is $22,889.
5. Lump sum ahead by 23,606 − 22,889 = $716.

How to read the result

The gap is the cost of waiting in a market that only goes up, here about 3% of the final value. A longer DCA period or a higher return widens it. In real markets the outcome varies: a crash during the DCA months would make DCA win. If a sudden drop right after investing would make you sell in panic, a short DCA period may still be the better behavioural choice.

Common mistakes

• Thinking DCA lowers market risk. Once fully invested you carry the same risk; DCA only spreads the entry point.
• Confusing this choice with regular saving from salary, which is investing money as it arrives, not delaying money you already have.
• Forgetting that cash waiting for DCA can earn interest, which narrows the gap.

Frequently asked questions

Is lump sum always better?

Not always. It wins on average when expected returns are positive, but DCA wins whenever prices fall during the spreading period.

How long should a DCA period be?

Shorter periods cost less in a rising market. Many investors use 3 to 12 months as a compromise.

Does DCA lower my average cost?

Buying a fixed amount buys more units at low prices, so your average cost is at or below the average price, but that does not guarantee a better final result.

Sources: Vanguard Research, "Dollar-cost averaging just means taking risk later" (2012) · Z. Bodie, A. Kane, A. J. Marcus, Investments, McGraw-Hill