1.Scenario Analysis and Regime Mapping Dashboard
heatmap and summary table · 2026
A financial analyst built this dashboard to construct defensible discount rates for a DCF valuation model by translating 13,000 daily macroeconomic data points into Base, Bull, and Bear regimes. The top visualization features a monthly regime map across the historical sample, presented as a heatmap spanning from 2005 to 2025. Below this, a scenario summary table quantifies metrics like the Risk-Free Rate and Fed Funds rate, showing that the Bear regime results in a Proxy WACC of 5.10% and a Present Value of $1,376.2, while the Base regime yields a 4.08% Proxy WACC and a PV of $1,478.6.
What it shows:
How to use heatmaps and scenario tables to categorize large datasets into distinct operational regimes.




