Macroeconomic Scenario ModelFree Financial Model Download
Build base, upside, and downside macro scenarios with linked economic drivers to stress-test company financials and valuations. Assign scenario probabilities, weight outcomes, and show how enterprise value and equity returns shift across different economic regimes.
Free download. No sign-up required.
About this model
A Macroeconomic Scenario Model stress-tests a mid-market manufacturer across four economic environments—Recession, Base, Boom, and Stagflation—each with distinct GDP, inflation, FX, and wage impacts. The model captures how domestic revenue (GDP-driven) and export revenue (foreign GDP and FX-driven) diverge from COGS escalation, creating margin compression or expansion. In Recession, domestic revenue declines 2.5% while materials cost escalates only 1.0% inflation—seemingly favorable, but weak volumes dominate. In Stagflation, nominal revenue grows 6.5% but material costs inflate 7.0% and interest expense soars to 11.5%, compressing net margins by 400+ bps relative to Base.
The Assumptions sheet houses a scenario toggle (user selects 1=Recession, 2=Base, 3=Boom, or 4=Stagflation in cell C5); CHOOSE formulas in column G pull the active scenario's assumption values. Revenue projections compound from prior year at scenario-specific rates (GDP + CPI + company alpha). COGS applies dual escalation: materials per unit escalates at Commodity_Inflation (independent of selling price inflation), and labor per unit at Wage_Inflation—this divergence is the core macro sensitivity. Fixed OpEx (SG&A, R&D) escalates at CPI. Working capital days vary by scenario—DSO extends in Recession (customers pay slower), compresses in Boom. The Macro_Dashboard sheet displays all four scenario KPIs side-by-side (Year 5 revenues, EBITDA, cash, debt levels) without requiring the user to toggle, enabling visual comparison.
This model suits corporate CFOs, board risk committees, lenders, and investors modeling downside resilience or upside optionality. Key metrics include revenue CAGR, EBITDA margin (range 12-22% depending on scenario), net margin (5-12%), interest coverage (1.5-3.5×), and cash position. A typical mid-cap manufacturer's Stagflation case reveals whether current debt levels are sustainable if rates spike and input costs soar—critical for investment-grade rating maintenance.
Recolor to your brand.
Formatted to IB standards.
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with blue inputs, black formulas, and green cross-sheet links.
- Brand-ready
- Institutional grade
- Fully auditable
What's included
- Macroeconomic variables including GDP, inflation, unemployment, and interest rates
- Industry-specific economic indicators and sensitivities
- Scenario definitions for base, upside, and downside cases with key assumptions
- Company P&L linkages to economic variables
- Valuation impact across scenarios with probability-weighted expected value
Multi-variable scenario construction
Define consistent sets of economic assumptions so that recession scenarios include higher unemployment and lower capex, rather than isolated single-variable shocks.
Industry sensitivity flexing
Apply different P&L sensitivities by industry sector to show which businesses are most cyclical and which are more defensive in a downturn.
Probability-weighted outcomes
Assign scenario probabilities and calculate expected value, volatility, and confidence intervals for financials and valuation across the scenario set.
Frequently asked
How many scenarios should I model?+
Start with three: base (most likely), upside (strong growth, low inflation), and downside (recession, high inflation). Add a severe stress scenario if needed, but too many scenarios can dilute focus and communication.
How do I calibrate scenario assumptions?+
Use consensus economist forecasts for the base case. For upside and downside, move key variables such as GDP and unemployment by one to two standard deviations from historical norms.
How do I assign scenario probabilities?+
Use market-implied probabilities from bond spreads and volatility indices where available. A common starting point is 50% base, 25% upside, and 25% downside, adjusted for current conditions.
Who uses macroeconomic scenario models?+
Economic analysts, risk managers, strategy teams, and investors use these models for strategic planning, risk budgeting, and valuation sensitivity analysis across economic cycles.
How do I link macro variables to company P&L?+
Identify the key economic drivers of each revenue and cost line, for example linking consumer spending growth to retail revenue or unemployment to credit losses, and build regression-based or judgment-based sensitivity coefficients.
Alex Tapio
Founder of Finamodel • Professional Financial Modeller • Ex-Deloitte
Related templates
Credit Stress Testing Framework
Quantitative stress test model for credit portfolios showing default probability, loss severity, and portfolio loss distribution under adverse scenarios.
Risk Parity Portfolio Model
Allocation framework that weights assets by inverse volatility to achieve equal risk contribution across equities, bonds, and alternatives.
Multi-Asset Portfolio Allocation
Asset allocation model optimizing portfolio construction across equities, bonds, alternatives, and real assets.
Public Housing Authority Operating Model
Unit mix, rent roll, operating expenses, and asset replacement reserve for public housing portfolios.