VTSAX: Complete Guide to Vanguard's Total Stock Market Fund (2026)

M
MarketXLS Team
Published
VTSAX Vanguard Total Stock Market Fund analysis in Excel using MarketXLS showing dividends and performance

VTSAX is one of the most widely held mutual funds in the world, offering investors comprehensive exposure to the entire United States stock market in a single, low-cost investment. The Vanguard Total Stock Market Index Fund Admiral Shares - known by its ticker symbol VTSAX - tracks the CRSP US Total Market Index and includes thousands of stocks spanning large-cap, mid-cap, small-cap, and micro-cap companies. Whether you are a first-time investor building a simple three-fund portfolio or an experienced analyst evaluating total market exposure for a client, this 2026 guide covers everything you need to know about VTSAX, including performance analysis, dividend tracking, comparisons with alternatives, and how to use MarketXLS to analyze it directly in Excel.

What Is VTSAX?

VTSAX stands for Vanguard Total Stock Market Index Fund Admiral Shares. It is a passively managed mutual fund that seeks to track the performance of the CRSP US Total Market Index, which represents approximately 100% of the investable US equity market. This means that when you invest in VTSAX, you are effectively buying a small piece of virtually every publicly traded company in the United States.

Key characteristics of VTSAX include:

  • Fund type: Mutual fund (Admiral Shares class)
  • Benchmark: CRSP US Total Market Index
  • Holdings: Approximately 3,600+ individual stocks
  • Market coverage: Large-cap, mid-cap, small-cap, and micro-cap US equities
  • Expense ratio: 0.04% - one of the lowest in the industry
  • Minimum investment: $3,000 for Admiral Shares
  • Distribution frequency: Quarterly dividends
  • Tax efficiency: Relatively high due to low turnover and index-tracking approach

The fund was created by Vanguard, the pioneer of index fund investing founded by John C. Bogle. VTSAX represents the Admiral Shares version of the fund, which offers a lower expense ratio compared to the Investor Shares class (VTSMX) in exchange for a higher minimum investment.

Several factors contribute to VTSAX's enduring popularity:

Ultra-Low Expense Ratio

At 0.04% (4 basis points), VTSAX's expense ratio is among the lowest available for any mutual fund. This means that for every $10,000 invested, you pay approximately $4 per year in fund expenses. Over decades of compounding, this cost advantage translates into significantly higher returns compared to funds charging 0.50% or more. To check the current expense ratio, use =FundExpenseRatio("VTSAX") in MarketXLS.

Complete US Market Exposure

Unlike S&P 500 index funds that only hold approximately 500 large-cap stocks, VTSAX covers the entire US equity market. This includes:

  • Large-cap stocks (approximately 70-75% of the fund) - companies like Apple, Microsoft, and Amazon
  • Mid-cap stocks (approximately 15-20%) - growing companies transitioning to large-cap status
  • Small-cap stocks (approximately 5-8%) - smaller companies with higher growth potential
  • Micro-cap stocks (approximately 1-2%) - the smallest publicly traded companies

This broader coverage means VTSAX captures returns from every segment of the market, including small-cap stocks that have historically generated higher long-term returns than large-cap stocks (though with higher volatility).

Simplicity

VTSAX offers a "one fund" solution for US equity exposure. Instead of selecting individual stocks or managing multiple sector funds, a single investment in VTSAX provides instant diversification across thousands of companies and every sector of the economy.

Proven Track Record

VTSAX has consistently tracked its benchmark index with minimal tracking error, delivering returns that closely mirror the overall US stock market. While past performance does not guarantee future results, the fund's long history demonstrates the reliability of its index-tracking approach.

VTSAX vs VTI: Mutual Fund vs ETF

One of the most common questions investors ask is whether to choose VTSAX (the mutual fund) or VTI (the Vanguard Total Stock Market ETF). Both track the same index and have nearly identical holdings, but they differ in structure:

VTSAX (Mutual Fund)

  • Trades once per day at the closing NAV (Net Asset Value)
  • Minimum investment of $3,000
  • Can purchase fractional shares (invest any dollar amount above the minimum)
  • Automatic investment features available
  • Dividends can be automatically reinvested at no cost
  • No trading commissions at Vanguard

VTI (ETF)

  • Trades throughout the day like a stock at market prices
  • No minimum investment (buy as little as one share)
  • Fractional shares available at some brokers
  • Slightly lower expense ratio (0.03% vs 0.04%)
  • Can be purchased at any brokerage
  • Intraday price fluctuations above or below NAV

For most long-term investors using dollar-cost averaging through regular automatic investments, VTSAX is the more convenient choice due to its automatic investment features and fractional share purchasing. For investors who want intraday trading flexibility or are using a non-Vanguard brokerage, VTI may be more practical.

Use MarketXLS to compare both side by side:

=LAST("VTSAX")          - VTSAX current price/NAV
=LAST("VTI")            - VTI current price
=DividendYield("VTSAX") - VTSAX dividend yield
=DividendYield("VTI")   - VTI dividend yield
=BETA("VTSAX")          - VTSAX beta (should be near 1.0)
=BETA("VTI")            - VTI beta

VTSAX Dividend Analysis

VTSAX distributes dividends quarterly, reflecting the aggregate dividends paid by its underlying holdings. For income-focused investors or those tracking their portfolio's cash flow, understanding VTSAX's dividend profile is important.

Tracking VTSAX Dividends with MarketXLS

MarketXLS provides several functions for detailed dividend analysis:

=DividendPerShare("VTSAX")                              - Trailing twelve-month dividend per share
=DividendYield("VTSAX")                                 - Current dividend yield (TTM)
=ForwardAnnualDividendRate("VTSAX")                     - Expected annual dividend rate
=DividendPayoutRatio("VTSAX")                           - Percentage of earnings paid as dividends
=DividendBetweenTwoDates("VTSAX", "2025/01/01", "2025/12/31") - Total dividends in a date range

These functions let you build a comprehensive dividend tracking worksheet directly in Excel. You can monitor dividend trends over time, compare yields across funds, and calculate your expected income from VTSAX holdings.

Dividend Reinvestment

One of the most powerful features of VTSAX is automatic dividend reinvestment (DRIP). When enabled through Vanguard, all quarterly dividend distributions are automatically used to purchase additional shares of the fund. Over decades, this compounding effect significantly boosts total returns.

For example, if VTSAX distributes approximately $1.50 per share annually and you own 1,000 shares, your $1,500 in annual dividends automatically purchases approximately 12-13 additional shares at current prices. Those new shares then generate their own dividends, creating a compounding cycle.

VTSAX Compared to Alternatives

Understanding how VTSAX stacks up against competing total market funds helps you make an informed choice:

VTSAX vs FSKAX (Fidelity Total Market Index Fund)

Fidelity's FSKAX tracks a different index (Dow Jones US Total Stock Market Index) but provides nearly identical market exposure. Key differences:

  • FSKAX has no minimum investment requirement (vs $3,000 for VTSAX)
  • FSKAX expense ratio is 0.015% (vs 0.04% for VTSAX)
  • Both provide total US market exposure with thousands of holdings
  • Performance tracking is virtually identical over long periods

For investors at Fidelity, FSKAX offers a slight cost advantage. For Vanguard investors, VTSAX is the natural choice given the platform integration.

VTSAX vs SWTSX (Schwab Total Stock Market Index Fund)

Schwab's SWTSX offers another total market alternative:

  • No minimum investment requirement
  • 0.03% expense ratio
  • Tracks the Dow Jones US Total Stock Market Index
  • Available at Schwab without commissions

VTSAX vs VOO (Vanguard S&P 500 ETF)

VOO tracks only the S&P 500, which covers approximately 80% of the US market by capitalization. The key difference is that VTSAX includes mid-cap, small-cap, and micro-cap stocks that VOO excludes. Historically, this broader exposure has provided a slight return premium over very long periods, though the difference is small.

Use MarketXLS to compare all these funds in a single dashboard:

=LAST("VTSAX")              =LAST("FSKAX")              =LAST("VOO")
=DividendYield("VTSAX")     =DividendYield("FSKAX")     =DividendYield("VOO")
=PERatio("VTSAX")           =PERatio("FSKAX")           =PERatio("VOO")
=BETA("VTSAX")              =BETA("FSKAX")              =BETA("VOO")
=FundExpenseRatio("VTSAX")  =FundExpenseRatio("FSKAX")  =FundExpenseRatio("VOO")

Building a Three-Fund Portfolio with VTSAX

One of the most popular investment strategies in the personal finance community is the "three-fund portfolio" (also known as the Boglehead portfolio), which uses just three funds to achieve global diversification:

  1. VTSAX - Total US stock market (domestic equity exposure)
  2. VTIAX - Vanguard Total International Stock Index Fund (international equity exposure)
  3. VBTLX - Vanguard Total Bond Market Index Fund (fixed income exposure)

Sample Allocations by Risk Profile

  • Aggressive (age 25-35): 60% VTSAX, 25% VTIAX, 15% VBTLX
  • Moderate (age 35-50): 45% VTSAX, 20% VTIAX, 35% VBTLX
  • Conservative (age 50-65): 30% VTSAX, 15% VTIAX, 55% VBTLX
  • Retirement (age 65+): 20% VTSAX, 10% VTIAX, 70% VBTLX

These are general guidelines for educational purposes. Individual circumstances, risk tolerance, and financial goals should determine your specific allocation.

Tracking Your Three-Fund Portfolio in Excel

MarketXLS makes it easy to monitor a three-fund portfolio:

=LAST("VTSAX")          - US equity value
=LAST("VTIAX")          - International equity value
=LAST("VBTLX")          - Bond value
=DividendYield("VTSAX") - US equity income
=DividendYield("VTIAX") - International income
=DividendYield("VBTLX") - Bond income
=BETA("VTSAX")          - US equity risk
=BETA("VTIAX")          - International risk
=BETA("VBTLX")          - Bond risk

By multiplying each fund's value by your share count and calculating weights, you can track whether your actual allocation has drifted from your targets and determine when rebalancing is needed.

How to Analyze VTSAX Performance in Excel

For investors who want to go deeper than basic price and dividend tracking, MarketXLS provides advanced analytical capabilities:

Valuation Metrics

=PERatio("VTSAX")           - Price-to-earnings ratio of the fund
=FiftyTwoWeekHigh("VTSAX")  - 52-week high price
=FiftyTwoWeekLow("VTSAX")   - 52-week low price
=BETA("VTSAX")              - Fund beta (market sensitivity)

Since VTSAX tracks the total US market, its beta should be very close to 1.0, confirming that it moves in lockstep with the broader market. A significantly different beta reading would suggest tracking issues.

Risk-Adjusted Performance

=SharpeRatio("VTSAX")   - Risk-adjusted return
=SortinoRatio("VTSAX")  - Downside risk-adjusted return
=CAGR("VTSAX")          - Compound annual growth rate

These metrics help you evaluate whether VTSAX is delivering appropriate returns relative to the risk taken. Comparing these ratios across different funds and time periods provides context for your investment decisions.

Dividend Analysis Over Time

=DividendBetweenTwoDates("VTSAX", "2024/01/01", "2024/12/31") - 2024 total dividends
=DividendBetweenTwoDates("VTSAX", "2025/01/01", "2025/12/31") - 2025 total dividends
=ForwardAnnualDividendRate("VTSAX")                            - Forward-looking estimate

Tracking dividends year over year helps you understand the income growth trajectory of your VTSAX holdings.

Common Questions About VTSAX

Is VTSAX an ETF or a Mutual Fund?

VTSAX is a mutual fund, specifically the Admiral Shares class of Vanguard's Total Stock Market Index Fund. It trades once per day at the closing NAV, unlike ETFs which trade throughout the day on exchanges. The ETF equivalent is VTI (Vanguard Total Stock Market ETF), which tracks the same index with a nearly identical portfolio.

What Is the Minimum Investment for VTSAX?

The minimum initial investment for VTSAX (Admiral Shares) is $3,000. After meeting this minimum, you can make additional investments in any amount. If $3,000 is above your budget, consider VTI (the ETF version) which has no minimum beyond the price of a single share, or FSKAX (Fidelity's equivalent) which has no minimum at all.

How Often Does VTSAX Pay Dividends?

VTSAX distributes dividends quarterly, typically in March, June, September, and December. Capital gains distributions, if any, are typically made annually in December. You can track dividend amounts and dates using =DividendPerShare("VTSAX") and =DividendBetweenTwoDates() in MarketXLS.

Can I Hold VTSAX in a Taxable Account?

Yes. VTSAX is relatively tax-efficient for a mutual fund due to its low turnover and index-tracking approach. Vanguard's unique ETF share class structure also helps minimize capital gains distributions. However, for maximum tax efficiency in taxable accounts, some investors prefer VTI (the ETF) since ETFs generally have a structural tax advantage over mutual funds.

Download Free Excel Templates

We have created two templates to help you analyze VTSAX and build your total market fund tracking dashboard:

Sample Workbook (Static Data) Pre-filled with comparative data for VTSAX and competing total market funds, scenario analysis for different market conditions, strategy frameworks for three-fund portfolios, and a correlation matrix showing fund relationships.

Live Template (MarketXLS Formulas) Contains live MarketXLS formulas that update automatically when the add-in is active. Yellow-highlighted cells are inputs where you can enter your own fund tickers and allocation percentages. Includes dividend tracking, performance metrics, and fund comparisons.

Both templates include six sheets: How To Use, Main Dashboard, Scenario Analysis, Strategy, Portfolio Comparison, and Correlation Matrix.

Using MarketXLS for VTSAX Analysis

MarketXLS provides the complete toolkit for analyzing VTSAX and building fund comparison dashboards in Excel:

  • Real-time pricing with =LAST("VTSAX") for instant valuation
  • Dividend analysis including =DividendPerShare(), =DividendYield(), =ForwardAnnualDividendRate(), and =DividendBetweenTwoDates()
  • Fund metrics such as =FundExpenseRatio() for cost comparison
  • Risk analytics including =BETA(), =SharpeRatio(), and =SortinoRatio()
  • Valuation data like =PERatio() and 52-week range tracking
  • Performance measurement with =CAGR() for compound growth analysis
  • Portfolio analytics using =PortfolioVolatility() for multi-fund risk assessment

The platform works in Excel on both Windows and Mac, allowing you to build sophisticated fund analysis dashboards without expensive proprietary software. Visit MarketXLS to explore all features, check pricing plans, or book a demo for a personalized walkthrough.

Frequently Asked Questions

Is VTSAX a good investment for beginners?

VTSAX is widely considered one of the best starting points for new investors due to its broad diversification, ultra-low costs, and simplicity. A single investment provides exposure to the entire US stock market. Many financial educators recommend VTSAX as the foundation of a long-term investment strategy. However, all investments carry risk, and the US stock market can experience significant short-term volatility.

What is the difference between VTSAX and VOO?

VTSAX tracks the entire US stock market (approximately 3,600+ stocks including large, mid, small, and micro-cap), while VOO tracks only the S&P 500 (approximately 500 large-cap stocks). VTSAX provides broader diversification by including smaller companies. The performance difference between the two is typically small since large-cap stocks dominate both funds, but VTSAX offers more complete market coverage.

How do I track VTSAX dividends in Excel?

Use MarketXLS functions in Excel: =DividendPerShare("VTSAX") returns the trailing twelve-month dividend, =DividendYield("VTSAX") shows the current yield, and =DividendBetweenTwoDates("VTSAX", "2025/01/01", "2025/12/31") calculates total dividends paid in a specific period. These functions update automatically, giving you a live dividend tracking dashboard.

Should I choose VTSAX or FSKAX?

Both funds provide nearly identical total US market exposure. FSKAX has a slightly lower expense ratio (0.015% vs 0.04%) and no minimum investment, making it marginally cheaper. VTSAX has a $3,000 minimum but benefits from Vanguard's unique fund structure. The choice often comes down to which brokerage you use - if you are at Fidelity, choose FSKAX; if at Vanguard, choose VTSAX.

Can I use VTSAX in a retirement account?

Yes. VTSAX is available in most retirement account types including traditional IRAs, Roth IRAs, and many employer-sponsored 401(k) plans (when Vanguard funds are offered). Holding VTSAX in a tax-advantaged retirement account eliminates concerns about capital gains distributions and dividend taxation during the accumulation phase.

What happens to VTSAX during a market crash?

Since VTSAX tracks the total US stock market, it will decline when the market declines. During the 2020 market crash, for example, VTSAX fell approximately 34% from peak to trough before recovering. This is the nature of equity investing - short-term volatility is the price of long-term growth. Investors with long time horizons have historically been rewarded for staying invested through downturns.

Summary

VTSAX remains one of the most efficient and accessible ways to invest in the US stock market in 2026. Its ultra-low 0.04% expense ratio, comprehensive coverage of approximately 3,600+ stocks across all market capitalizations, and quarterly dividend distributions make it a cornerstone holding for millions of investors. Whether used as a standalone investment or as the domestic equity component of a diversified multi-fund portfolio, VTSAX delivers on its promise of broad market exposure at minimal cost.

For investors who want to analyze VTSAX performance, track dividends, compare it against alternatives, and build comprehensive fund dashboards, MarketXLS provides all the tools you need directly in Excel. Functions like =LAST("VTSAX"), =DividendYield("VTSAX"), =FundExpenseRatio("VTSAX"), and =SharpeRatio("VTSAX") give you instant access to the data that matters, helping you make informed decisions about your total market fund allocation.

Important Disclaimer

The information provided in this article is for educational and informational purposes only and should not be construed as investment advice, a recommendation, or an offer to buy or sell any securities. MarketXLS is a financial data platform and is not a registered investment advisor, broker-dealer, or financial planner. Always conduct your own research and consult with a qualified financial professional before making any investment decisions. Past performance is not indicative of future results. Trading and investing involve substantial risk of loss.

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
I agree to the MarketXLS Terms and Conditions
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement "your own" investment strategies in Excel with thousands of MarketXLS functions and templates.
MarketXLS provides all the tools I need for in-depth stock analysis. It's user-friendly and constantly improving. A must-have for serious investors.

John D.

Financial Analyst

I have been using MarketXLS for the last 6+ years and they really enhanced the product every year and now in the journey of bringing in AI...

Kirubakaran K.

Investment Professional

MarketXLS is a powerful tool for financial modeling. It integrates seamlessly with Excel and provides real-time data.

David L.

Financial Analyst

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel.

Lloyd L.

Professional Trader

Meet The Ultimate Excel Solution for Investors

Live Streaming Prices in your Excel
All historical (intraday) data in your Excel
Real time option greeks and analytics in your Excel
Leading data service for Investment Managers, RIAs, Asset Managers
Easy to use with formulas and pre-made sheets