Appearance

Language

Long-term investing

Dollar-Cost Averaging Calculator 2026: Backtest Monthly Investing in the S&P 500 (VOO) or 0050 and Find the Worst Start Month

Backtested on real monthly data: NT$10,000 a month into the S&P 500 from 2006/10 to 2026/10 put in NT$2.4 million and is worth about NT$11.28 million after the 30% US dividend withholding, 13.7% a year (13.3% in US dollars). Over 10 years, someone who started in early 1999 still lost money, and the calculator shows the worst start month for any 5- to 20-year period.

Kelvin Wang · · 11 min read

Key points

  1. NT$10,000 a month into the S&P 500, 2006/10–2026/10: NT$2.4 million put in, about NT$11.28 million now, 13.7% a year in NT dollars after the 30% US dividend withholding; in US dollars the same plan returned about 13.3% a year.
  2. Over 10 years the S&P 500 offers 285 start months, and 16 of them ended in a loss, the worst starting 1999/02 (−7% a year); none of the 165 twenty-year start months lost money.
  3. NT$5,000 a month into Taiwan's 0050, 2016/10–2026/10: NT$600,000 put in, about NT$2.61 million now (27.7% a year), a lucky decade: the middle 10-year start returned 10.9%.
  4. The annual return shown is what your money earned (IRR), not how much the asset rose; money added each month spends less time in the market.

Most DCA calculators assume the same return every year. This one replays actual month-end prices instead, so it can answer two questions a fixed rate can’t: what a plan started 10 or 20 years ago would be worth today, and which start month in that stretch turned out worst. Enter the same fields as each example and you get the same numbers.

NT$10,000 a month into the S&P 500, 2006/10–2026/10, NT$2.4M put in
≈ NT$11.28M
The same plan in US dollars (US$1,000 a month), per year; calculated outside the calculator
13.3%
Annual return of the worst 10-year S&P 500 start month (1999/02)
−7%
10-year S&P 500 start months that ended in a loss
16 / 285

1928–2025: annual return with dividends 10.02%, worst fall −55.2% (2007–2009). The future sketch assumes 8%–12% a year.

500 large US companies; no 20-year stretch in 98 years lost money. The top ten are about 40% of it.

Source: Damodaran, Historical Returns on Stocks, Bonds, Bills and Gold (NYU Stern)

How you invest
Period
Charged on every amount you put in. Default 0.1425% with no minimum; most brokers discount monthly plans or set a minimum per purchase, so enter your own broker's terms.
Dividends
Income tax bracket (Taiwan)
The US withholds 30% of dividends; gains count as overseas income, assumed under NT$1M a year, so no further tax.

Worth now

NT$2.82M

Monthly from 2016/10 to 2026/10

Put in
NT$1.2M
Annual return
16.3%
Worst fall
−15.9%2020/01 → 2020/03

Broker fees NT$1,710.

Account value NT$, month end, 2016/10–2026/10
  • Account value
  • Put in
Fall from the high Below the previous peak
Which start month The same plan for 10 years, started in every month 1993/02–2016/10; each dot is the annual return
Worst start
−7%From 1999/02, ends at about NT$852K
Middle
9.8%From 1993/12, ends at about NT$1.99M
Best start
16.5%From 2016/05, ends at about NT$2.86M

Of 285 start months, 16 ended with less than was put in.

The same plan in each asset, same period 2016/10–2026/10
  • Taiwan 0050NT$5.21M
  • Taiwan 0056NT$3.59M
  • S&P 500NT$2.82M
  • Nasdaq-100NT$3.53M
  • Global stocks (VT)NT$2.44M
  • BitcoinNT$12.93M
Year by year (NT$)
YearPut inValueReturn
201620K21K11.9%
2017140K153K14.8%
2018260K263K−4.8%
2019380K468K26.3%
2020500K655K12.7%
2021620K967K26.9%
2022740K990K−9.4%
2023860K1.38M25.2%
2024980K1.97M33.1%
20251.1M2.35M12.6%
2026 (10)1.2M2.82M15.8%

Actual month-end prices, broker fee on every amount put in; US stocks and Bitcoin converted to NT$, so currency moves count. Dividends are estimated from the yield; Taiwan ETFs pay in their current months and lose 2.11% NHI premium on single payouts of NT$20,000 or more.

It opens on the S&P 500 at NT$10,000 a month for 10 years: NT$1.2 million put in from October 2016 is worth about NT$2.82 million, 16.3% a year. It shows NT dollars and uses Taiwan’s tax rules, because I built it in Taiwan; the S&P 500 backtest converts SPY’s month-end value with dividends reinvested at each month’s actual USD/TWD rate, so it includes the NT dollar’s moves 1 2. The calculator also has its own page, and opening a link with parameters applies those settings, as this link to the 20-year S&P 500 plan does.

What do you fill in?

The calculator opens on Backtest. Fill it in this order:

  1. Pick an asset. The S&P 500, the Nasdaq-100, Global stocks (VT), Bitcoin, or Taiwan’s 0050 and 0056. The US funds use Yahoo Finance’s monthly adjusted close (SPY, QQQ, VT) 1, Taiwan’s ETFs use the Taiwan Stock Exchange’s prices and dividend records 3 4, and Bitcoin uses Coin Metrics’ community API 5. VOO tracks the same index as SPY for 0.03% a year against SPY’s 0.0945% 6 7, so over the long run it should do a little better than the backtest.
  2. Choose Monthly, set Starting amount to 0 and enter Each month. Amounts are in NT$: at the end of October 2026 a US dollar was about NT$32.6 2. If you already have a sum to invest first, put it in Starting amount.
  3. Pick a Period. 5, 10, 15 or 20 yrs, or All, each ending at the last month of data (2026/10 now); Custom sets both months. Periods longer than an asset’s history can’t be picked: Bitcoin, for example, has no 15- or 20-year option.
  4. Enter your Broker fee and Minimum fee. The default is 0.1425% of every purchase with no minimum. Enter 0 if your broker charges no commission. For a fixed charge per order, set the fee to 0 and enter the charge in NT$ as the minimum. IBKR Pro Fixed, for example, charges US$0.005 a share with a US$1 minimum per order, capped at 1% of the trade value 8; for a hypothetical fixed charge of US$1 per purchase, enter about NT$33 at the end-of-October rate. Check fractional-share and recurring-investment fees separately before applying this example to your broker.
  5. Reinvest dividends or Take as cash. Cash doesn’t compound; the result then shows the holding and the dividends separately.
  6. Pick an Income tax bracket (Taiwan). It follows Taiwan resident rules: 30% US withholding on US funds, Taiwan income tax and the NHI premium on Taiwan’s ETFs. If you don’t live in Taiwan, compare No tax with the default: for US funds the default takes the full 30% US withholding, but neither includes tax your own country may charge, and Taiwan taxes non-residents’ dividends from 0050 and 0056 differently.

The big number, Worth now, is the holding plus any dividends taken out; under it are Put in, Annual return and Worst fall, then the broker fees paid in total and, for Taiwan’s ETFs, the NHI premium.

How far back each asset goes, in the calculator’s data:

  • S&P 500 (SPY). From February 1993, so every period including 20 years.
  • Nasdaq-100 (QQQ). From April 1999, every period.
  • Taiwan’s 0050. From February 2004, every period.
  • Taiwan’s 0056. From December 2007, 226 months: 5, 10 or 15 yrs, or All (almost 19 years).
  • Global stocks (VT). From July 2008, 219 months: 5, 10 or 15 yrs, or All (about 18 years).
  • Bitcoin. From December 2012, 166 months: 5 or 10 yrs, or All (almost 14 years).

The TWD deposit option has no history, so it works only in the Future sketch.

What does the tax bracket do if you don’t live in Taiwan?

The bracket buttons apply Taiwan’s tax to each asset:

  • US ETFs: 30% of dividends withheld. The US withholds 30% of dividends paid to non-US investors, or a lower treaty rate 9. Taiwan has no tax treaty in force with the US 10, so at any bracket above No tax the calculator takes 30%.
  • Taiwan’s ETFs: Taiwan income tax and the NHI premium. Dividends are taxed at your bracket less an 8.5% credit (the NT$80,000 household cap on the credit is left out), or at the separate 28% rate where that is lower (the 40% bracket) 11; single payouts of NT$20,000 or more lose 2.11% to the National Health Insurance supplementary premium 12; and selling costs a 0.1% securities transaction tax 13.
  • Bitcoin: gains taxed at your bracket. The result adds a line for what’s left after selling and paying tax on the gain.
  • No tax removes every tax. The 30% US withholding, the NHI premium and the 0.1% sale tax all go to zero, as does the tax on Bitcoin’s gain, so the result is before any tax.

If a treaty lowers your US withholding, your result lands between the No tax result and the default. For the 20-year S&P 500 plan (NT$10,000 a month, 2006/10–2026/10), a 15% rate gives about NT$11.50 million, 13.8% a year; the calculator has no 15% setting, so that figure comes from running its code with 15%. Your own country may also tax the dividends and gains. For Taiwan’s two ways of taxing dividends, see the dividend tax calculator.

NT$10,000 a month into the S&P 500 (VOO): what is it worth after 20 years?

Keep the S&P 500 and NT$10,000 a month, and set the Period to 20 yrs. Starting October 2006, NT$2.4 million went in; by October 2026 it is about NT$11.28 million, 13.7% a year. These 20 years include the 2008 crisis, but the account was still small then; the worst fall was January to March 2020, −18.9%.

NT$10,000 a month into the S&P 500 NT$10,000s, end of each October; SPY with dividends in NT$, 30% US dividend withholding and 0.1425% broker fee
  • Account value
  • Put in

Dividends reinvested after US withholding; currency moves included.

Source: yahoo.com

In US dollars, US$1,000 a month over the same 20 years put in US$240,000 and grew to about US$1.07 million, 13.3% a year after the 30% withholding and the default 0.1425% broker fee. That figure is calculated outside the calculator, from SPY’s monthly adjusted close in US dollars 1, with the calculator’s dividend, withholding and fee model; the other US-dollar figures (the worst start months and loss counts) use the same assumptions.

Two more things for US stocks:

  • Dividends lose 30% first. With the bracket set to No tax the result is about NT$11.73 million, 14.0% a year; the gap of about NT$450,000 is 20 years of withheld dividends and the compounding they missed.
  • The exchange rate changes the NT$ result. Each month’s money is converted to US dollars at that month’s rate and the end value back to NT$, so a stronger NT$ shrinks a US account in NT$ terms. The US-dollar figures leave that effect out; if you spend another currency, the same applies with your own rate.

NT$5,000 a month into Taiwan’s 0050: what is it worth after 10 years?

0050, which tracks Taiwan’s 50 largest listed companies 14, is one of the calculator’s assets. Switch the asset to Taiwan 0050, Each month to 5,000 and the Period to 10 yrs, and keep the 12% bracket (Taiwan resident rules, so the tax and NHI figures apply to a Taiwan resident): starting October 2016, NT$600,000 went in by October 2026 and is now worth about NT$2.61 million, an annual return of 27.7%.

NT$5,000 a month into 0050 NT$10,000s, end of each October; 0.1425% broker fee, 12% bracket, NHI premium
  • Account value
  • Put in

Dividends reinvested, bought at each month-end price.

Source: twse.com.tw

How to read it:

  • 27.7% is a lucky decade. 0050 has 153 possible 10-year start months; the middle one returned 10.9% a year and the worst, January 2006, 4.9%. The calculator’s “Which start month” chart shows this, and it reruns when you change the asset or the period.
  • Worst fall −22.4%, January to October 2022. The longer you invest, the bigger the account, so the same fall costs more money.
  • Broker fees NT$855 over 10 years: NT$5,000 × 0.1425% ≈ NT$7 a month. On small amounts a minimum matters more than the rate: NT$1,000 a month with a NT$20 minimum costs NT$2,400 in fees over ten years, 2% off every purchase.
  • NHI premium NT$1,127, charged on the January and July 2026 payouts, the first to reach NT$20,000. While the account was small, no payout reached that threshold.

Take the dividends as cash instead and the result is about NT$2.34 million: a holding of about NT$2.19 million plus about NT$157,000 of dividends after tax. The gap of about NT$264,000 is the compounding those dividends would have added.

Which start month was the worst?

The “Which start month” chart runs the same amount for the same number of years from every possible start month in the data. Each dot is one start month’s annual return; the three numbers above it are the worst, middle and best.

NT$10,000 a month into the S&P 500 for 10 years, the plan the calculator opens on, has 285 possible start months. The middle one returned 9.8% a year. The worst started in February 1999: NT$1.2 million went in and by February 2009 it was about NT$852,000, −7% a year. Sixteen start months ended in a loss, all from late 1998 to 2000: they met the dot-com bust first, and their ten years ended right around the 2008 crisis. In US dollars the worst start is the same month, at −8.2% a year, and 14 start months lost money.

S&P 500 monthly plan: worst and best result for each start year Annual return (%), NT$10,000 a month, after 30% US withholding and broker fees; last 20-year start: 2006
  • 10 years, best start month that year
  • 10 years, worst start month that year
  • 20 years, worst start month that year

1993 starts in February, 2016 ends in October. The last 10-year start month is 2016/10, the last 20-year one 2006/10.

Source: yahoo.com

The longer the plan, the less bad the worst start. Over 15 years the worst S&P 500 start (1994/02) returned 0.3% a year and none of 225 lost money in NT dollars; in US dollars, three did (the January to March 1994 starts), the worst at −1.7% a year. Over 20 years the worst (1993/02) returned 6.2% and none of 165 lost money in either currency. None of 0050’s 153 ten-year start months lost money either; the worst, January 2006, returned 4.9%.

What are the backtest’s limits?

  • The annual return is what your money earned. It is the IRR: money added in different months spends different lengths of time in the market, so it is the return of your plan, not how much the S&P 500 rose in ten years.
  • Dividends are estimated from the yield. The history is total return; the calculator splits it into price and dividends using each asset’s current yield (S&P 500 1%, 0050 3%, 0056 5%). Taiwan’s ETFs pay in their current payout months (0050 in January and July, 0056 four times a year) and US assets spread dividends over every month, so the NHI premium’s count and amount are estimates.
  • Bought at month-end prices. Real recurring purchases happen on a set day of the month, often just after payday. Over long periods the day barely matters: in the lump sum vs dollar-cost averaging backtest, buying on the 6th, 16th or 26th changed the annual return by less than 0.1 percentage points. Over a year or two the gap can be larger.
  • SPY stands in for the S&P 500. VOO has a lower fee and only began trading in September 2010 6 15; read the backtest as a slightly conservative VOO.
  • Selling costs tax for Taiwan’s ETFs and Bitcoin. With a bracket set, the result adds a line for what’s left after selling: the 0.1% transaction tax on Taiwan’s ETFs, or tax at your bracket on Bitcoin’s gain.

FAQ

What broker fee should I enter?

What your broker actually charges per purchase: 0 if it charges no commission on ETF purchases, otherwise its percentage, plus any per-order minimum converted to NT$. On small monthly amounts the minimum matters more than the rate.

Can I use it in US dollars or my own currency?

Not directly: amounts are in NT$. Convert your monthly amount at about NT$32.6 per US dollar (end of October 2026) 2, and read the results as NT$. The annual return is in NT dollars too: for US assets it includes USD/TWD moves, which the US-dollar S&P 500 figures leave out.

Can I backtest VOO?

The calculator’s S&P 500 stands in for VOO, SPY, IVV and the other S&P 500 ETFs. The data uses SPY, which has the longest history, from 1993. For the funds, their costs and how to buy them from outside the US, see the S&P 500 guide:

Go deeper S&P 500 Monthly Investing for 20 Years (2026): Returns, Crashes and How to Buy VOO or CSPX From Outside the US Almost a century of returns, the big crashes, VOO vs CSPX, and US dividend withholding for non-US investors.

Why does 0050’s worst start differ from the 0050 article?

The 0050 article gives lump-sum returns with dividends; the calculator gives the annual return of a monthly plan. Different calculation, different number. Switch to Taiwan 0050 and Lump sum, enter an Amount, and look at the same chart to see the calculator’s lump-sum version (after tax and fees, so still not identical).

None of this is investment advice, and there are no affiliate or broker referral links.

Sources

  1. 1. Yahoo Finance: SPY, QQQ and VT monthly adjusted close · finance.yahoo.com · 1993-02 to 2026-10
  2. 2. FRED: Taiwan Dollars to U.S. Dollar Spot Exchange Rate (DEXTAUS) · Federal Reserve Bank of St. Louis · 1993-02 to 2026-10
  3. 3. Taiwan Stock Exchange: daily trading by stock · twse.com.tw · to 2026-10
  4. 4. Taiwan Stock Exchange: ex-rights and ex-dividend results · twse.com.tw · to 2026-10
  5. 5. Coin Metrics API reference (v4), Community API: BTC PriceUSD · Coin Metrics · 2012-12 to 2026-10
  6. 6. Vanguard S&P 500 ETF (VOO) Fact Sheet · Vanguard · data as of 2026-09-30
  7. 7. State Street SPDR S&P 500 ETF Trust (SPY) · State Street · checked 2026-11-18
  8. 8. Commissions: Stocks, ETFs and Warrants · Interactive Brokers · checked 2026-11-18
  9. 9. IRS: Federal income tax withholding and reporting on other kinds of U.S. source income paid to nonresident aliens · IRS · updated 2026-07-23
  10. 10. IRS: United States income tax treaties - A to Z · IRS · updated 2026-01-03
  11. 11. Income Tax Act, article 15 · Laws & Regulations Database of the ROC · checked 2026-11-18
  12. 12. NHI supplementary premium overview (115.01.05 edition) · National Health Insurance Administration · 2026-01-05
  13. 13. Taiwan Stock Exchange: ETF trading rules (in Chinese) · twse.com.tw · checked 2026-11-18
  14. 14. Yuanta Funds: Yuanta Taiwan Top 50 (0050), basic information · Yuanta Funds · checked 2026-11-18
  15. 15. Yahoo Finance: VOO historical prices · finance.yahoo.com · checked 2026-11-18

About the author

Kelvin Wang

Electrical engineer building tools with AI agents, sharing hands-on notes on engineering and investing.

More about me