How this calculator works
Dollar cost averaging, or DCA, means putting the same amount into the same investment on a schedule, every month or every payday, whatever the price is. When the price is low, the money buys more units, or shares. When it’s high, it buys fewer. The calculator buys at each month’s price, adds up the units and values them at the last price.
With the numbers already in the boxes, $500 went into the S&P 500 every month from January 2000 to September 2026, starting near the top of the dot-com bubble, with the dividends reinvested after a 15% tax. That’s $160,500 put in, and in September 2026 it would be worth $940,629. The yearly rate for that money comes to about 11.4%. In September 2026 money, the deposits add up to $236,593, so after inflation the money grew about 8.5% a year.
With the S&P 500 history, the calculator uses Robert J. Shiller’s monthly data back to 1871. Each month has one price, the average of its daily closes, so each buy is at its month’s average price. Over many months, that comes out close to buying on the same day every month, and it makes crashes look smaller: in 2020 the S&P 500 fell about 34% from its February high to its March low, and only about 19% on monthly averages. Each month’s dividend is a twelfth of the yearly rate in Shiller’s data, paid on the units you already held. His dividends go up to June 2026, and the months after that repeat the June rate. Inflation is the US consumer price index from the Bureau of Labor Statistics from 1913, and from Shiller’s data before that.
The yearly rate for your money counts each deposit from the month it went in, the same way the XIRR function in Excel does. The index’s own rate is for one dollar put in on the first month and left alone. They differ because most of your money went in later, at other prices.
Every month, or all at once?
People mix up two cases here. If you invest part of every paycheck, there’s no lump sum to compare with: you’re putting money in as you earn it. The lump sum case comes up when you already have the money in hand and wonder whether to put it all in today or spread it out.
The “All now or spread out?” tab puts the two side by side, with the waiting money earning what 3-month US Treasury bills paid each year. With $60,000 starting in January 2000, all at once ended up 2.3% behind spreading it over 12 monthly buys, measured when the last buy went in. Across all 1,174 start months since 1928, all at once came out ahead in 69% of them, and at the middle start it was 3.8% ahead. Spreading it out did better in the years the market fell soon after the start, and in those years the gap could be large.
What the falls looked like
Starting near the 2000 top, the plan spent 53 of its 321 months worth less than what had gone in. The longest run lasted 39 months. In March 2009 the account was 30% below the money put in, and from October 2007 to March 2009 it fell 40% even with $500 going in every month. If you had stopped buying every time the S&P 500 fell 20% below its high, kept the saved money in Treasury bills and waited for the price to get back there, you’d have sat out 142 of the 321 buys and ended with $793,941, which is $146,688 less. If you had kept the money in Treasury bills and only bought after 20% falls, you’d have ended with $863,955, which is $76,674 less. The test in the calculator runs both for your own months.
The data: Robert J. Shiller, shillerdata.com; Treasury bill rates from Aswath Damodaran, NYU Stern; and Vanguard’s study of investing all at once or over time (February 2023).
S&P 500 is a registered trademark of Standard & Poor’s Financial Services LLC, and the index is a product of S&P Dow Jones Indices LLC. Bufetico isn’t affiliated with them or endorsed by them.
What a dollar cost averaging calculator doesn’t see
A dollar cost averaging calculator can leave out seven things that change the answer.
- A smooth return. With one fixed rate, the price never falls, so the calculator never shows the cheap months that make regular buying work. Use the history, or test a fall with the steady return.
- Stopping in the falls. The plan only does its job if the money keeps going in when the news is at its worst. The stopping test above shows what sitting out would have cost.
- Inflation. A dollar you put in back in 2000 bought more than a dollar does now. Count what you put in at today’s prices before you call the result a gain.
- Fees on small buys. A flat fee that looks tiny is a big share of a small deposit. A $3 monthly fee on $100 a month takes 3% of every deposit.
- Taxes along the way. In a taxable US account, the IRS counts reinvested dividends as income in the year they’re paid. Each buy is its own tax lot, with its own cost and date, and the stock average calculator keeps track of them. And if you sell some shares at a loss while a monthly buy lands within 30 days before or after, the US wash sale rule can delay the tax benefit of the loss (IRS Publication 550). The stock profit calculator checks for it.
- One company is not an index. The S&P 500 regularly swaps companies that have shrunk for bigger ones. A single company can keep falling for good, and buying more of it every month makes that bet bigger.
- The data itself. Monthly averages make crashes look smaller. Before March 1957 the series is what Shiller uses in place of the S&P 500: the 90-stock S&P Composite from 1926 and the Cowles index before that. And it’s in US dollars: if you invest from another currency, the exchange rate moves your result too.
What I correct when I measure a company in Bufetico is on the Method page.
Questions people ask
What is dollar cost averaging?
Dollar cost averaging, or DCA, means putting the same amount into the same investment on a schedule, like $500 every month, whatever the price is. In India a plan like this is called a SIP, a systematic investment plan, and in the UK, pound cost averaging.
Is dollar cost averaging better than investing a lump sum?
If you already have the money, history says putting it all in at once usually came out ahead. Vanguard found that all at once beat a three-month split 68% of the time, measured after one year, in a world stock index from 1976 to 2022, with no interest on the waiting money. With Treasury bill interest, it was 65%. In this calculator’s data, with the waiting money in Treasury bills, all at once beat a three-month split in 62% of the start months since 1928, and a 12-month split in 69%. Spreading it out did better when the market fell soon after the start, and it makes that first year easier to sit through.
What if I had invested $100 a month in the S&P 500?
From October 2006 to September 2026, $100 a month with the dividends reinvested, in a tax-sheltered account and with no fees, would have grown to $113,928 from $24,000 put in. Change the months, the amount and the taxes above to see your own case.
Does dollar cost averaging lower your average cost?
In one narrow way, yes. With equal amounts, the average cost of your units always comes out at or below the average of the prices you bought at, because the money buys more units when the price is low. In the example above, the units cost $1,697 on average, against an average price of $2,409. That doesn’t mean you end up with more money. Putting it all in at once usually came out ahead.
Is it better to invest weekly, every two weeks or monthly?
For the same total each year, the difference over the years is small. Weekly buys inside a month land close to that month’s average price, and the average is what this calculator uses for every choice, so weekly and monthly come out the same here, apart from fees. If your broker charges for each buy, fewer buys cost less. Monthly averages also can’t test which day of the month is best.
Does dollar cost averaging work in a bear market?
A falling market is when the same money buys the most units, and that pays off only if prices recover. The hard part is holding on. In the example above, which starts near the top in January 2000, the account was worth less than what had been put in for 53 months, and in March 2009 it was 30% below.
Should I stop investing when the market drops?
That’s your call. In the example above, stopping every time the S&P 500 fell 20% below its high, keeping the saved money in Treasury bills and waiting until the price got back there, would have left $146,688 less at the end. The “Test the hard part” box runs it for your own months.
Is it better to keep cash and wait for a dip?
In the example above, keeping the money in Treasury bills and buying only after the S&P 500 fell 20% below its high would have left $863,955, which is $76,674 less than buying every month. The money went in 76 times out of 321, and $25,607 was still waiting at the end. The same box tests waiting for a 10%, 20% or 30% fall.
What if I start at an all-time high?
History has both kinds of start. Take the same $500 a month for 20 years in this calculator’s data, started in every month since 1871. The 250 starts at a record high made a median of $1.69 for each dollar put in, after inflation, against $2.00 for all 1630 starts, and 9% of the record-high starts ended with less than was put in, against 7% of all starts. You can pick any start month above and see how it went. Those are past starts, and they don’t tell you how the next one will go.
Can I use it for crypto, gold, an ETF or a single stock?
Yes, with your own prices. Pick “My own prices” and paste one line per buy, with the date if you have it. Most brokers and finance sites let you download a price history as a spreadsheet. The calculator doesn’t download prices from anywhere. The math runs in your browser, and Bufetico doesn’t keep what you type. Your numbers do go into the page address, so you can share the result. If you share that address, your numbers go with it, and they’re still there when you reload the page.
Is my 401(k) dollar cost averaging?
In a way. The same amount goes in from every paycheck, whatever the price. The all-at-once question only comes up when you already have the money, and the “All now or spread out?” tab covers that case.
What is value averaging?
It’s a version of the same idea, described by Michael Edleson in 1988. You aim for the account to grow by a set amount each period, so you put in more after a fall and less after a rise. It needs spare cash on the side for the big months, and after a strong rise the amount can turn negative, which means selling. Simon Hayley, of City University London, argued in 2010 that much of its apparent edge comes from the way the return is measured. This calculator sticks to the same amount every time.
How are taxes handled here?
In a taxable account, the tax on each dividend comes out when it’s paid, even if it’s reinvested, and the end value is before the tax on a sale. A separate line shows what a sale at the end would leave after the tax on the gain. In a tax-sheltered account, like a 401(k), an IRA, an ISA, a TFSA or an RRSP, nothing is taxed along the way. In a traditional 401(k), IRA or RRSP, the tax comes later, when you take the money out, so the end value is before that tax.
Does it work outside the US?
Yes, with two things to keep in mind. The S&P 500 history is in US dollars, so if you invest from euros, pounds or rupees, the exchange rate moves your result too, and that isn’t in this math. The currency menu only changes the symbol. To include the exchange rate, paste your fund’s prices in your own currency under “My own prices.” For taxes, put in your own rates, or pick a tax-sheltered account.
How do I do this in Excel?
With a steady return, =FV((1+rate)^(1/12)-1, months, -amount) comes close to this calculator, with rate as the price growth plus the dividend yield. With real prices, put each month’s price in a column and, in the next column, the amount divided by that price. Then add up the units and multiply by the last price. The CSV button downloads that table, month by month.
Why does the S&P 500 here go back to 1871?
Robert J. Shiller, the Yale economist, rebuilt monthly prices, dividends and inflation for US stocks back to 1871, and he publishes them at shillerdata.com. The S&P 500 itself started in March 1957. Before that, his series uses the 90-stock S&P Composite from 1926 and the Cowles index before then.