Stock Market Valuation Dashboards in Excel
Stock market valuation dashboards in Excel: the Buffett Indicator, CAPE ratio, equity risk premium, forward earnings yield, sector P/E heatmaps and S&P 500 concentration, updated with live data.
- 1Buffett Indicator Dashboard Excel: June 2026 Market Cap to GDP Valuation Tool
The Buffett Indicator (US market cap / GDP) was about 200% in June 2026. An Excel dashboard to calculate it, chart 30 years of history, and run 10-year reversion scenarios.
- 2CAPE Ratio Dashboard Excel: Shiller PE Sector Heatmap + Mean-Reversion Scenarios (May 2026)
Free Excel CAPE ratio dashboard: Shiller PE history since 1881, sector valuation heatmap, and 10-year mean-reversion return scenarios for the S&P 500, with live MarketXLS formulas.
- 3Equity Risk Premium Dashboard Excel: Track Stock vs Bond Valuation in May 2026
Equity risk premium dashboard Excel - measure how much extra return stocks offer over the 10-year Treasury, run scenarios on rates and earnings, and translate the spread into a stock vs bond allocation.
- 4Forward Earnings Yield Dashboard Excel: Q2 2026 Valuation Screener for Equity Risk Premium Analysis
Forward earnings yield dashboard excel - download a premium Q2 2026 valuation screener that compares forward earnings yield against the 10-year Treasury, with KPI tiles, sector heatmaps, scenario analysis, and live Marke
- 5Sector Valuation Dashboard Excel: May 2026 S&P 500 P/E Heatmap and Premium-Discount Analysis
Sector valuation dashboard Excel template for May 2026 - dashboard-style heatmap of S&P 500 sector P/E ratios, premium-discount vs 5-year averages, KPI tiles, scenario analysis, and live MarketXLS formulas across all 11
- 6S&P 500 Concentration Dashboard Excel: Track Top 10 Weight, Sector Dominance, and SPY vs RSP (2026)
The S&P 500 top 10 weight is about 37.5% (June 2026). A free Excel dashboard to track top 10 weight, sector weights, HHI, and SPY vs RSP.