DCA calculator
Enter a ticker, a monthly amount and a start date. The calculator buys at each month's first close in the stock's real price history and shows the shares accumulated, the amount invested, the average cost, the value today and the yearly rate, beside investing the same total on the first day.
Calculator
Price return — dividends not included: the source gave no dividend-adjusted closes for this ticker. Prices can be delayed, and a weekly or monthly history buys at the first close on or after a date. Past returns say nothing certain about future ones.
How it is calculated
The purchases
One purchase a month, on the same day of the month as the start date, at the first close on or after it. Fractional shares are allowed. Purchases stop at the latest price in the history.
Dividends
Dividends are approximated as reinvested by valuing each purchase with dividend-adjusted closes: a purchase of A at a point is worth A × adjusted_now ÷ adjusted_then today. The share count and average cost are of the shares actually bought, without the shares dividends would add. Where the source gives no adjusted closes the value is on price alone, and the page says so.
The yearly rate
For the monthly plan the yearly rate is the internal rate of return: the single annual rate at which all the payments grow to today's value, each for as long as it was invested. For the lump sum it is the plain compound rate.
The formula
shares = Σ amount ÷ close_i average = invested ÷ shares value = Σ amount × adjusted_end ÷ adjusted_i lump sum = invested × adjusted_end ÷ adjusted_first
A worked example (hypothetical prices)
The defaults read live prices, so this example uses made-up ones with no dividends. $500 goes in each month for three months, at $50, $40 and $25 a share: 10 + 12.5 + 20 = 42.5 shares for $1,500, an average cost of $35.29.
With the share at $40 today the shares are worth $1,700. The same $1,500 put in on the first day at $50 would have bought 30 shares, worth $1,200. Averaging in came out ahead here because the price fell after the first purchase; in a market that mostly rises, the lump sum usually ends ahead.
Questions and answers
What is dollar-cost averaging?
Investing a fixed amount at regular intervals whatever the price, so the same money buys more shares when the price is low and fewer when it is high.
Is dollar-cost averaging better than a lump sum?
Not on average in a market that rises over time: money invested earlier has longer to grow, so a lump sum usually ends higher. Averaging in lowers the risk of investing everything just before a fall. The table shows both for your stock and dates.
How are dividends handled?
The value counts dividends as reinvested, using the dividend-adjusted closes in the price history. The share count shows only the shares bought with your monthly amount.
Why is the yearly rate lower than the stock's own return?
Most of a monthly plan's money was invested for less than the full period, so the same growth adds less to it. The internal rate of return weighs each payment by how long it was invested.
Sources
- What is the adjusted close? — Yahoo Help
- Dollar cost averaging — Investor.gov (U.S. Securities and Exchange Commission)
Related
Updated . Results are arithmetic on the figures you enter, not advice.
Cite this page
Funkfolio, “DCA calculator: dollar-cost averaging a real stock”. https://funkfolio.com/tools/dca-calculator