Monthly ETF Investment Plan Calculator: Compound Growth

Calculate ETF dollar cost averaging final value with compound interest, expense ratio and capital gains tax. Estimate capital, net gain and TER impact for long-term plans.

Calculation parameters
Was this calculator useful?

The monthly ETF investment plan calculator estimates the final capital of a dollar-cost averaging strategy through regular contributions in Exchange Traded Funds (equity, bond or balanced). It applies compound interest formula on monthly cash flows, subtracts the expense ratio (annual TER) and calculates net gain after applicable capital gains tax (US long-term 0/15/20%, depending on income IRC Section 1(h), or 26% Italy/30% Germany for international users). It is the cornerstone tool for retirement planning, college savings or financial independence following principles in Benjamin Graham's The Intelligent Investor (Harper, 1949) and Burton Malkiel's A Random Walk Down Wall Street (Norton, 1973), popularized by John Bogle's Vanguard since 1976.

Mathematical formula

The calculation combines the future value of an ordinary annuity with cost adjustment:

  • Net rate = Expected return − Expense ratio
  • Monthly rate = Net rate / 12
  • Future value gross = PMT × [(1 + r)n − 1] / r
  • Gross gain = Future value − Total contributions
  • Net gain = Gain × (1 − tax rate)

Where PMT is the monthly payment, r is the monthly net rate, n = years × 12 is the number of payments. The formula derives from Fisher's The Theory of Interest (1930) and codifies the dollar cost averaging concept formalized by Benjamin Graham in 1949 and popularized by John Bogle, founder of Vanguard with the first index fund in 1976.

History and context of ETFs

The first ETF in history, the Toronto 35 Index Participation Fund (TIP 35), listed in Toronto in 1990. The SPDR S&P 500 (ticker SPY) by State Street launched on the New York Stock Exchange January 22, 1993, marking the start of the modern ETF era. According to Investment Company Institute Fact Book 2024, US ETF assets reached $8.1 trillion in 2024, growing 23% year-over-year. The Securities and Exchange Commission Rule 6c-11 (2019) standardized the ETF approval process. ETFs trade like stocks but track indices passively, with much lower fees than actively managed mutual funds. Key references: Common Sense on Mutual Funds by John Bogle (Wiley, 1999), The Little Book of Common Sense Investing (Wiley, 2007), The Bogleheads' Guide to Investing (Wiley, 2014).

Typical US ETFs comparison 2024

ETFIndexExpense ratioHistorical annual return30-year capital at $300/mo
VOO Vanguard S&P 500S&P 5000.03%10.5%~$687,000
VTI Vanguard Total Stock MarketCRSP US Total0.03%10.0%~$632,000
VT Vanguard Total WorldFTSE Global All Cap0.07%8.5%~$478,000
VEA Vanguard FTSE DevelopedFTSE Developed All Cap0.05%6.8%~$364,000
BND Vanguard Total BondBloomberg US Aggregate0.03%4.2%~$210,000

Sources: Vanguard prospectus 2024, S&P CRSP MSCI Bloomberg index returns 1970-2024, ICI Investment Company Fact Book 2024, Morningstar.com 2024.

Five worked examples

Example 1 — Roth IRA retirement 30 years. $500/month × 30 years = $180,000 contributed. VOO S&P 500 10% return, 0.03% expense (net 9.97%). Future value $1,134,000. Gross gain $954,000, tax-free in Roth IRA per IRC 408A. Final net $1,134,000.

Example 2 — 529 college plan 18 years. $250/month × 18 years = $54,000. Total stock market 8.5% return, 0.05% TER. Future value $114,000. Tax-free if used for qualified education per IRC 529. Net $114,000.

Example 3 — Taxable brokerage FIRE 20 years. $1,500/month × 20 years = $360,000. VTI 9.5% return, 0.03% TER. Future value $1,033,000. Gross gain $673,000. Net after 15% LTCG: $572,000. Final net $932,000.

Example 4 — Conservative bond portfolio. $800/month × 15 years = $144,000. BND 4% return. Future value $197,000. Gain $53,000, taxed as ordinary income or LTCG. Net ~$45,000. Final net $189,000.

Example 5 — Impact of high expense ratio. $400/month × 30 years at 8% return. ETF 0.03% vs actively managed mutual fund 1.0%. ETF: $592,000 final. Fund: $474,000 final. Difference $118,000 lost to fees alone.

Model limitations

The calculator assumes constant return, but markets have high volatility: S&P 500 standard deviation 15-20% annually 1970-2024. The sequence of returns risk matters: a crash early in the plan is less harmful than one near retirement. The model ignores inflation (Federal Reserve target 2%, but US CPI 2022 peak 9.1%): real value is lower than nominal. Doesn't include differentiated taxation on qualified dividends (0/15/20%) vs ordinary dividends (income tax brackets). Doesn't model tax-loss harvesting or Roth conversion ladders. Doesn't include the backdoor Roth for high earners (IRC 408A loophole confirmed by IRS 2017). For sophisticated investors, consider asset location optimization (tax-efficient placement across taxable, traditional, Roth accounts).

Common mistakes

  • Underestimating expense ratio impact: 1% TER difference over 30 years can cost 25-30% of final capital.
  • Confusing historical and expected returns: past doesn't guarantee future; use conservative 6-7% for global equity.
  • Stopping contributions during crashes: dollar cost averaging works precisely by buying more when prices fall.
  • Ignoring international diversification: 100% US exposure misses broader global growth (VT/VXUS recommended).
  • Not considering inflation: $100 today equals $55 in 30 years at 2% inflation, $30 at 4%.

Practical applications

  1. Plan retirement using Roth IRA, traditional IRA, or 401(k) with employer match.
  2. Save for college via 529 plans (IRC 529, state tax deduction in many states).
  3. Build FIRE (Financial Independence Retire Early) portfolio with 25× annual expenses.
  4. Plan future home purchase or major expenses.
  5. Compare low-cost ETFs vs traditional actively managed mutual funds.
  6. Decide between Vanguard, Fidelity, Schwab, BlackRock iShares ETF families.
  7. Estimate impact of long-term capital gains tax (0/15/20% LTCG) vs ordinary income tax.

Updated July 2026

Frequently Asked Questions

What is the expense ratio and why does it matter?

The expense ratio is the annual cost of an ETF or mutual fund expressed as percentage of assets under management. Includes management fee, custody, audit, but excludes trading commissions. US passive ETFs range from 0.03% (Vanguard VOO, Fidelity ZERO ETFs) to 0.75% (sector and thematic ETFs). Over 30 years, 1% expense ratio difference compounds to 25-30% less final capital due to inverse compound interest. SEC requires disclosure in prospectus per Investment Company Act 1940.

How are US ETFs taxed?

US ETFs are taxed as long-term capital gains (LTCG) at 0/15/20% rates if held >1 year, per IRC Section 1(h). Short-term gains <1 year taxed as ordinary income (10-37% federal brackets 2024). Qualified dividends from US-domiciled ETFs taxed at LTCG rates per IRC 1(h)(11), non-qualified at ordinary rates. Tax-advantaged accounts: Roth IRA tax-free withdrawals (IRC 408A), Traditional IRA/401(k) tax-deferred, 529 plans tax-free for qualified education. Wash sale rules apply (IRC 1091).

What is dollar cost averaging?

Dollar cost averaging (DCA) means investing a fixed amount at regular intervals (e.g., $300 every month) regardless of current price. This reduces market timing risk: when prices are high you buy fewer shares, when low you buy more. Benjamin Graham formalized it in The Intelligent Investor (1949). Vanguard 2012 study showed lump sum beats DCA in 67% of 10-year periods, but DCA reduces emotional volatility and matches paycheck-based contribution patterns most workers naturally have.

What is the S&P 500 and why is it important?

The S&P 500 is a market-capitalization-weighted index of 500 large US companies, covering about 80% of US equity market cap. Created by Standard & Poor's in 1957. Returned approximately 10% annualized 1957-2024 nominal (Wharton CRSP database). ETFs replicating it (VOO, IVV, SPY) are the most popular for retirement plans due to ultra-low expense ratios (0.03-0.09%) and high liquidity ($1+ billion daily volume for SPY).

Should I choose accumulating or distributing ETFs?

In the US, distributing (income) ETFs are standard since US tax code requires fund-level distributions of net income annually per IRC Section 851. European-style accumulating ETFs are uncommon for US investors. To reinvest dividends automatically, use DRIP (Dividend Reinvestment Plan) at your broker (Fidelity, Schwab, Vanguard offer free DRIP). For taxable accounts, qualified dividends taxed at LTCG rates 0/15/20%; in tax-advantaged accounts (Roth IRA, 401k) no immediate tax impact.

What expected return should I use?

For conservative long-term estimates 20-30 years: US total stock market 7-8% nominal; S&P 500 7-9%; international developed 5-6%; emerging markets 6-7%; bonds 3-4%. Historical 1970-2024 returns were higher (10% S&P 500), but current valuations (CAPE Shiller >30) suggest lower future returns. Vanguard Capital Markets Model 2024 projects 4-6% real after inflation for US equity over next 10 years. Bogleheads recommend 6-7% nominal as planning baseline.

Roth IRA, Traditional IRA or 401(k)?

Choice depends on current vs expected retirement tax bracket. Roth IRA: contributions taxed now, withdrawals tax-free; best if expecting higher future tax rate. 2024 limit $7,000 ($8,000 over 50). Traditional IRA: tax-deductible contributions, withdrawals taxed; best if higher current rate. 401(k): employer match (typically 50-100% on first 6%), 2024 limit $23,000 ($30,500 over 50). Always max employer match first—it's free money. Then Roth IRA, then 401k beyond match.

Formula

FV = PMT \cdot \frac{\left(1 + \frac{r - TER}{12}\right)^{12t} - 1}{\frac{r - TER}{12}}

Comments (0)

No comments yet. Be the first!