VTSAX is the Admiral Shares class of the Vanguard Total Stock Market Index Fund, a mutual fund that tracks the CRSP US Total Market Index and holds about 3,600+ US stocks across large, mid, small, and micro caps. It charges a 0.04% expense ratio, requires a $3,000 minimum investment, and pays dividends quarterly. Its ETF twin, VTI, holds the same portfolio at a 0.03% expense ratio with no minimum beyond one share. This guide covers VTSAX's costs, dividends, alternatives (VTI, FSKAX, SWTSX, VOO), its role in a three-fund portfolio, and how to track it in Excel with MarketXLS.
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.
Why VTSAX Is a Popular Choice for Long-Term Investors
Several factors contribute to VTSAX's enduring popularity:
Ultra-Low Expense Ratio
VTSAX charges 0.04% (4 basis points) a year, so every $10,000 invested costs about $4 per year in fund expenses. Compared with a fund charging 0.50%, that saves about $46 per $10,000 each year, and the savings compound over decades. 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.
Close Index Tracking
VTSAX is designed to track its benchmark index closely, so its returns mirror the overall US stock market, minus the expense ratio. Past performance does not guarantee future results.
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
Formula documentation: LAST, DividendYield, 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
Formula documentation: DividendPerShare, DividendYield, ForwardAnnualDividendRate, DividendPayoutRatio, DividendBetweenTwoDates
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")
Formula documentation: LAST, DividendYield, PERatio, BETA, FundExpenseRatio
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:
- VTSAX - Total US stock market (domestic equity exposure)
- VTIAX - Vanguard Total International Stock Index Fund (international equity exposure)
- 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
Formula documentation: LAST, DividendYield, BETA
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)
Formula documentation: PERatio, FiftyTwoWeekHigh, FiftyTwoWeekLow, BETA
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
Formula documentation: SharpeRatio, SortinoRatio, CAGR
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
Formula documentation: DividendBetweenTwoDates, ForwardAnnualDividendRate
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:
- Pricing with
=LAST("VTSAX")(as a mutual fund, VTSAX prices once a day at NAV; ETFs such as VTI trade intraday) - 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
MarketXLS works in Excel on Windows (desktop add-in) and on Mac and Excel for the web (Microsoft 365 add-in, where formulas use the mxls. prefix, such as =mxls.Last("VTSAX")). Some functions differ by platform; check the formula list. 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 a common starting point for new investors because of its broad diversification, low cost, 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 gives broad US stock market exposure at low cost in a single fund. 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 pulls the data into 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.