Skip to content

DCA calculator: dollar-cost averaging on real returns

Dollar-cost averaging (DCA) means investing a fixed amount at regular intervals instead of all at once. This free calculator backtests a regular plan on the real monthly returns of ETFs and whole portfolios, projects a future plan at a return you choose, works out your average cost and compares each plan with a lump sum.

1 · Your portfolio

Start from
  • SPY SPDR S&P 500 ETF Trust · USD%
  • BND Vanguard Total Bond Market ETF · USD%

● Total 100% · up to 10 holdings · rebalanced yearly

2 · Your plan

Compare with

These funds have less than a year of history in common: try others.

Returns with dividends reinvested, each fund in its trading currency; the funds’ own costs are already included. Taxes and trading costs are not. The part beyond the real history is an average, not a forecast. Not investment advice.

DCA projection calculator: what a plan could grow to

The backtest above looks back. To plan ahead, set how much you invest, how often and for how long, and the yearly return you consider reasonable. The result shows the future value, how much of it is growth, and what it is worth in today’s money once inflation is taken out.

Total invested
$120,000
Value after 20 years
$255,203
$135,203 of growth
In today’s money
$171,744
at 2% inflation
At 5% and 9%
$203,729 – $321,728
two points either side
$0$67k$134k$201k$268k15101520
Money invested GrowthYear of the plan on the horizontal axis

Investing $500 every month for 20 years puts in $120,000. At a constant 7% a year it grows to $255,203, worth $171,744 in today’s money. 53% of the final value is growth, not contributions.

Year-by-year tableShow
YearInvested in the yearTotal investedValueIn today’s money
1$6,000$6,000$6,225$6,103
2$6,000$12,000$12,886$12,386
3$6,000$18,000$20,013$18,859
4$6,000$24,000$27,639$25,534
5$6,000$30,000$35,799$32,424
6$6,000$36,000$44,530$39,542
7$6,000$42,000$53,873$46,899
8$6,000$48,000$63,869$54,511
9$6,000$54,000$74,565$62,392
10$6,000$60,000$86,009$70,558
11$6,000$66,000$98,255$79,023
12$6,000$72,000$111,358$87,805
13$6,000$78,000$125,378$96,922
14$6,000$84,000$140,380$106,391
15$6,000$90,000$156,432$116,231
16$6,000$96,000$173,607$126,463
17$6,000$102,000$191,985$137,108
18$6,000$108,000$211,649$148,188
19$6,000$114,000$232,690$159,725
20$6,000$120,000$255,203$171,744

A constant return is an assumption, not a forecast: real markets do not rise by the same amount every year, which is what the backtest above shows. Each investment is made at the start of its period. Before taxes and costs.

Average cost calculator: your cost per share after several purchases

Enter each purchase you made, with the number of shares or units and the price paid. The calculator returns your average cost and break-even price, the result at the price now, and how many more shares at that price would bring the average to a target. It works for stocks, ETFs and crypto.

Shares or unitsPrice paid ($)
1
2
3
Average cost
$80.00
per share or unit
Total shares
30
Total invested
$2,400
Result at the price now
−$300
−12.5%

Your average cost is $80.00: $2,400 invested divided by 30 shares. The position breaks even at $80.00; at $70.00 it is down 12.5%.

To reach the target average

Buying 30 more at $70.00, for $2,100, brings the average to $75.00. The position would then be 60 shares and $4,500 invested.

Average cost = total amount paid ÷ total shares. Fees and taxes are not included; add them to the price paid if you want them in the average. Buying more of a falling position lowers the average and raises the amount at risk.

What $500 a month became in 10 years

The same plan in each fund: $500 at the start of every month for 10 years, $60,000 in total, on real monthly total returns with dividends reinvested, ending Sep 2026, the last complete month for all of them. The last column invests the same total on the first day.

Result of investing $500 a month for 10 years in popular ETFs and lazy portfolios
Fund or portfolioFinal valueGainReturn of the planFund returnWorst fallLump sum instead
QQQInvesco QQQ Trust$181,233$121,233+21.0%+20.9%−33%$400,566
VXUSVanguard Total International Stock ETF$104,900$44,900+10.8%+9.2%−28%$144,472
SCHDSchwab U.S. Dividend Equity ETF$102,764$42,764+10.4%+10.3%−22%$160,493
BNDVanguard Total Bond Market ETF$62,871$2,871+0.9%+1.1%−18%$66,920
GLDSPDR Gold Shares$136,931$76,931+15.8%+11.7%−24%$181,867
SWDAiShares Core MSCI World UCITS ETF (Acc)€122,731€62,731+13.7%+12.8%−19%€200,291
CSSPXiShares Core S&P 500 UCITS ETF (Acc)€132,329€72,329+15.1%+14.7%−18%€236,641
60/40 Portfoliolazy portfolio, rebalanced yearly$98,488$38,488+9.6%+9.3%−21%$146,553
All Weather Portfoliolazy portfolio, rebalanced yearly$79,356$19,356+5.5%+5.3%−22%$100,213

“Return of the plan” is the yearly money-weighted return of the contributions; “Fund return” is the fund’s own yearly return over the same 10 years. European funds are in euros. Before taxes and trading costs. Past performance is not a forecast. Source: MEDGE Capital calculations on end-of-day prices.

DCA vs lump sum: what the data and the research say

The comparison only makes sense in one situation: you already hold a sum and are deciding whether to invest it today or in instalments. If you invest part of your income as it arrives, there is no lump sum to compare with: that is simply dollar-cost averaging.

For that decision the research is consistent. Constantinides showed that dollar-cost averaging is a suboptimal investment policy.[1] Knight and Mandell tested the advice to split a lump sum into instalments on historical stock returns and simulations, and found that it brought no benefit over investing at once.[2] Rozeff reached the same conclusion comparing the two directly.[3] The reason is arithmetic: markets have risen more often than they have fallen, and money waiting to be invested does not take part.

What the instalments buy is a smaller chance of a large loss early on. Trainor measured the exposure to loss during the investment period, not only at its end, and found that dollar-cost averaging reduces the probability, the size and the duration of a large loss compared with a lump sum.[4] Statman proposed a behavioural explanation for why investors keep choosing it, based on how people weigh gains against losses, on the wish to avoid regret and on self-control.[5]

Every 5-year period in our data: monthly plan against the same total invested at once

How often a lump sum ended higher than a monthly plan over every 5-year period
Fund or portfolioPeriods testedLump sum ended higherMedian result, monthly planMedian result, lump sumWorst result, monthly planWorst result, lump sum
SPYSPDR S&P 500 ETF Trust180158 (88%)+40%+90%+12%−5%
QQQInvesco QQQ Trust180170 (94%)+59%+126%+18%+22%
IWMiShares Russell 2000 ETF180151 (84%)+29%+51%−13%−4%
BNDVanguard Total Bond Market ETF175148 (85%)+7%+14%−10%−6%
TLTiShares 20+ Year Treasury Bond ETF180146 (81%)+11%+25%−31%−41%
GLDSPDR Gold Shares180135 (75%)+18%+40%−24%−34%
60/40 Portfoliolazy portfolio, rebalanced yearly120120 (100%)+24%+50%+5%+28%
All Weather Portfoliolazy portfolio, rebalanced yearly120112 (93%)+14%+26%−7%+11%

One period for every possible start month in each fund’s history, complete months only. Results are the gain or loss on the total amount invested after 5 years. The periods overlap, so they are not independent observations. Source: MEDGE Capital calculations on end-of-day prices.

Across these funds the lump sum ended higher in 1140 of 1315 periods (87%). Its median result was the higher one in 8 of 8 funds, and its worst result was the lower one in 3 of 8. The table compares end values only: the losses during the period, which is what Trainor measured, show in the backtest above as the worst fall along the way.

What dollar-cost averaging is, with the formulas

With a fixed amount, each purchase buys more shares when the price is low and fewer when it is high. The result is an average cost per share below the average of the prices at which you bought. The average cost is the total amount paid divided by the total number of shares:

average cost = Σ (shares × price) ÷ Σ shares

Example: $300 invested three times, at $100, $75, $50, buys 3, 4, 6 shares. That is $900 for 13 shares: an average cost of $69.23, against an average price of $75.00. The gap is not a gain in itself: what counts is where the price goes afterwards.

The future value of a plan at a constant return, with each amount invested at the start of its period, is:

FV = P₀ × (1 + R)ⁿ + A × (1 + r) × ((1 + r)ᴺ − 1) ÷ r

P₀ is the initial amount, R the yearly return, n the years, A the regular amount, N the number of contributions and r the return per period, (1 + R)^(1/periods per year) − 1. At 7% a year, $500 a month for 20 years puts in $120,000 and grows to $255,203. The projection calculator above applies this formula and adds contributions that grow each year and inflation.

When it helps, and when it does not

  • It turns saving into investing. A fixed amount leaves with each pay cheque and is invested the same day, without a decision each time.
  • It softens a bad start. A fall soon after the first purchase hits only the little invested so far, and later purchases are made at lower prices.
  • It does not raise the expected result. For money you already hold, the instalments keep part of it out of the market, and markets have risen more often than not.
  • It does not protect what is already invested. Late in a plan the balance is large and the contributions small: a fall then weighs on almost everything.

How the calculator works

Data. Real monthly total returns of each ETF, with dividends reinvested, computed from end-of-day prices, and of each lazy portfolio. The backtest uses only the months all the chosen funds have in common, so every fund is measured over the same period.

Plan. Each amount is invested at the start of the month, quarter or year and earns that period’s return. Total invested is the initial amount plus every contribution; final value is before taxes. A portfolio is rebalanced to its target weights every January.

Chart. The blue line is your portfolio. The dashed orange line runs the same plan, with the same amounts on the same dates, in the fund or portfolio you compare with. The grey line is the money you put in.

Beyond the history. When the years you ask for go beyond the history the funds share, the real months come first and the rest continues at the portfolio’s own historical average return, marked by a vertical line in the chart. That part is an average, not a forecast.

Timing. Within the real history, the calculator repeats the plan from every other start month and compares it with investing the same total at the start: the most honest way to see how much timing matters.

Costs. The funds’ own costs are already in their returns. You can add a yearly advisory or platform fee. Taxes and trading costs are not included.

Dollar-cost averaging: questions

What is dollar-cost averaging (DCA)?

Dollar-cost averaging means investing a fixed amount at regular intervals, usually every month, instead of investing a sum all at once. You buy more shares when prices are low and fewer when they are high, and the position builds up from savings over time.

How does the DCA calculator work?

It has three parts. The backtest invests your regular amount in a portfolio of ETFs using their real monthly total returns, with dividends reinvested, and compares it with a benchmark and with a lump sum. The projection grows a plan at a constant return you choose. The average cost calculator turns a list of purchases into your cost per share. Everything runs in the browser, with no sign-up.

Is DCA better than investing a lump sum?

If you already hold the money, investing it at once has ended higher in most historical periods, because the money spends more time invested; academic studies reach the same conclusion. Spreading the purchases lowers the chance of a large loss early on. For savings that arrive month by month there is no lump sum to compare with: investing them as they arrive is dollar-cost averaging.

How do you calculate the average cost of an investment?

Divide the total amount paid by the total number of shares bought. For example, $300 invested at $100, $75, $50 buys 3, 4, 6 shares: $900 for 13 shares, an average cost of $69.23, below the $75.00 average of the three prices.

What is the "annual return of the plan"?

It is the money-weighted return (internal rate of return) of your contributions: each amount is counted for the time it was actually invested. It differs from the fund’s own annual return, which assumes all the money was invested on the first day.

Should I invest weekly or monthly?

With the same total per year the difference is small. In the projection at a constant 7% a year, $6,000 a year for 20 years grows to $254,651 invested weekly, $255,203 monthly and $263,191 once a year at the start of the year. The amount, the years invested and any cost per purchase matter more than the frequency.

Can dollar-cost averaging lose money?

Yes. If the investment falls and stays below your average cost, the plan is worth less than the amount put in. The backtest counts in how many start months the plan ended below the money invested, and the worst fall along the way.

Which returns does the calculator use?

Real monthly total returns of each ETF with dividends reinvested, computed from end-of-day prices, or of each lazy portfolio, over the months all the chosen funds have in common; your portfolio is rebalanced to its weights every January. Beyond that history the plan continues at the portfolio’s own historical average return, clearly marked.

Does the calculator work for stocks and crypto?

The backtest covers the ETFs in the catalogue, US-listed and European, including spot bitcoin ETFs, and ready-made lazy portfolios. For any other asset, including single stocks and coins, the average cost calculator works with the prices you paid and the projection with the return you assume.

Does past performance tell me what DCA will return in future?

No. The historical results show how wide the range of outcomes was depending on when you started, which is useful for setting expectations, but they are not a forecast.

Sources

  1. Constantinides, G. M. (1979). A Note on the Suboptimality of Dollar-Cost Averaging as an Investment Policy. The Journal of Financial and Quantitative Analysis, 14(2), 443–450. doi.org/10.2307/2330513
  2. Knight, J. R., & Mandell, L. (1992). Nobody Gains from Dollar Cost Averaging: Analytical, Numerical and Empirical Results. Financial Services Review, 2(1), 51–61. doi.org/10.1016/1057-0810(92)90015-5
  3. Rozeff, M. S. (1994). Lump-Sum Investing versus Dollar-Averaging. The Journal of Portfolio Management, 20(2), 45–50. doi.org/10.3905/jpm.1994.409474
  4. Trainor, W. J. (2005). Within-horizon exposure to loss for dollar cost averaging and lump sum investing. Financial Services Review, 14(4), 319–330. doi.org/10.61190/fsr.v14i4.4835
  5. Statman, M. (1995). A Behavioral Framework for Dollar-Cost Averaging. The Journal of Portfolio Management, 22(1), 70–78. doi.org/10.3905/jpm.1995.409537

More free tools

Source: MarketStack end-of-day prices, total return with dividends reinvested; academic sources listed above. Figures are historical and descriptive; they are not forecasts and not investment advice. MEDGE Capital does not recommend buying or selling any instrument. Risk disclaimer.