CCalclabhub

Finance · 109 calculators

How To Dollar-Cost Average Calculator

Dollar-cost averaging is the discipline of investing a fixed amount on a fixed schedule, whatever the market is doing. It replaces a timing decision with a calendar.

Last updated

Portfolio value

$44,730.08

Total invested
$31,000.00
Growth
$13,730.08
Value per £1 invested
1.4429
Contributions made
120
Monthly return
0.005654145387

Values update as you type. This calculator covers the single scenario its formula assumes — see Common Mistakes for what it leaves out.

The formula this calculator uses

value = initial x (1+r)^n + payment x ((1+r)^n - 1) / r

P
Initial lump sum invested at the start
A
Amount invested each period
r
Return per period, monthly rather than annual
n
Number of periods, in months

How to check the result by hand

  1. 1

    Convert the annual return to a monthly one

    Take the twelfth root of one plus the annual rate and subtract one. Dividing by twelve understates the monthly rate and understates the final value.

  2. 2

    Count the periods

    Multiply the number of years by twelve. A ten-year horizon is 120 contributions, and the count drives the compounding far more than the return does.

  3. 3

    Project the initial lump sum

    Multiply the starting amount by one plus the monthly rate raised to the number of months. Every month of the horizon compounds it.

  4. 4

    Project the stream of contributions

    Use the annuity formula, then multiply by one plus the monthly rate if the contributions are made at the start of the month rather than the end.

  5. 5

    Separate growth from investment

    Subtract the total contributed, which is the lump sum plus every payment, from the final value. The remainder is growth, and it is the part that grows with time.

Common Questions

How does the How To Dollar-Cost Average Calculator work?

£1,000 up front plus £250 a month for ten years at 7% is £31,000 invested and £44,730.08 in the account. £13,730.08 of that, about 31%, is growth.

What do I need to enter in the How To Dollar-Cost Average Calculator?

It takes 5 inputs: Initial lump sum, Monthly contribution, Years, Annual return (percent), Contribution timing. Fields that expect a unit say so next to the label.

Where does Portfolio value come from?

It comes from FV = A x ((1+r)^n - 1) / r — this is the ordinary annuity future-value formula. Each payment compounds for the months remaining after it is made, and the sum of all those factors collapses into a single closed form.

What is the most common mistake with the How To Dollar-Cost Average Calculator?

Dividing the annual rate by twelve. Twelfth-rooting converts a compounding rate correctly while dividing by twelve does not. On a ten-year projection the difference between the two is several hundred pounds.

For worked examples, common mistakes and the limits of this formula, read the full How To Dollar-Cost Average page.