1.Macroeconomic Regimes and Discount Rate Scenarios
Scenario Analysis Dashboard · 2026
A financial analyst built a dashboard to construct defensible discount rates for a DCF valuation model, translating 13,000 daily macroeconomic data points into Base, Bull, and Bear regimes. The heatmap spans 2005 to 2025, while the scenario summary table quantifies metrics like the Risk-Free Rate and Fed Funds rate. For instance, the Bear regime shows a 4.10% Risk-Free Rate and 3.94% Fed Funds rate, yielding a 5.10% Proxy WACC and a Present Value of $1,376.2, whereas the Base regime yields a 4.08% Proxy WACC and a PV of $1,478.6. These precise inputs mirror those required when applying an incremental borrowing rate calculation formula during a lease remeasurement.
What it shows:
How to classify macroeconomic data into regimes for valuation models.




