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
- SPY SPDR S&P 500 ETF Trust · USD%since 2006
- BND Vanguard Total Bond Market ETF · USD%since 2007
● Total 100% · up to 10 holdings · rebalanced yearly
2 · Your plan
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
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 tableShowHide
| Year | Invested in the year | Total invested | Value | In 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.
- 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.
| Fund or portfolio | Final value | Gain | Return of the plan | Fund return | Worst fall | Lump 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
| Fund or portfolio | Periods tested | Lump sum ended higher | Median result, monthly plan | Median result, lump sum | Worst result, monthly plan | Worst result, lump sum |
|---|---|---|---|---|---|---|
| SPYSPDR S&P 500 ETF Trust | 180 | 158 (88%) | +40% | +90% | +12% | −5% |
| QQQInvesco QQQ Trust | 180 | 170 (94%) | +59% | +126% | +18% | +22% |
| IWMiShares Russell 2000 ETF | 180 | 151 (84%) | +29% | +51% | −13% | −4% |
| BNDVanguard Total Bond Market ETF | 175 | 148 (85%) | +7% | +14% | −10% | −6% |
| TLTiShares 20+ Year Treasury Bond ETF | 180 | 146 (81%) | +11% | +25% | −31% | −41% |
| GLDSPDR Gold Shares | 180 | 135 (75%) | +18% | +40% | −24% | −34% |
| 60/40 Portfoliolazy portfolio, rebalanced yearly | 120 | 120 (100%) | +24% | +50% | +5% | +28% |
| All Weather Portfoliolazy portfolio, rebalanced yearly | 120 | 112 (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
- 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
- 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
- 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
- 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
- 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
- Retirement calculatorMonte Carlo on historical returns
- Compound interest calculatorWith historical return ranges
- Rolling returnsBest and worst 1–15 year periods
- Rebalancing calculatorTrades to get back to target weights
- Portfolio diversification guideFormulas, calculators and data
- ETF returns and comparisonsReturns, drawdowns and risk
- Lazy portfolios comparedBacktests of famous portfolios
- Simulatore PAC (in italiano)Piano di accumulo su ETF europei
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.