Project Case StudyScenario Engine

Financial Modeling Scenario Engine

Built to bring my graduate “Financial Modeling” workbook to life online. This project transforms a complex multi-sheet Excel model into a reusable data layer and interactive Next.js experience, helping hiring managers and teammates test real-time valuation scenarios without opening the spreadsheet.

Skills: Next.js · TypeScript · Scenario Modeling · Data StorytellingYear: 2025
← Back to all projects

Why it matters

Delivering valuation clarity beyond Excel

Analysts often hand over spreadsheets with little context. I wanted a cleaner way to show how different assumptions move revenue, EBITDA, and cash flow. By codifying the workbook and hosting it on my site, I give recruiters and teammates a self-guided demo that mirrors my valuation thinking.

Excel Model DemoInteractive Dashboard

Financial Statement Forecast Playground

Explore the interactive view of my “Financial Modeling” workbook. The visuals below recreate the base-case statements, KPIs, and scenario levers so you can understand the model's story without opening Excel.

Key Scenario SnapshotScenario: Base Case

Revenue CAGR

2.1%

2022 to 2026 cumulative annualized growth

Peak EBITDA

$128

Highest projected annual EBITDA in the forecast window

Avg. Operating Cash Flow

$74.1

Mean projected operating cash flow across the forecast period

Forecast Dashboard

Scenario: Base Case

Revenue & Profit Trajectory

Operating Margin Profile

Scenario Assumption Explorer

Toggle between scenarios to examine the drivers originally embedded in the workbook. Each card highlights the time series for a key assumption along with how the alternatives diverge by the end of the forecast.

Scenario Input

Cost of Inflation

20222.0%
20232.0%
20242.0%
20252.5%
20262.5%

Active: Base Case

Base Case2.5%Best Case2.0%Worst Case2.5%

Scenario Input

Sales Price

2022$800
2023$725
2024$825
2025$800
2026$750

Active: Base Case

Base Case$750Best Case$780Worst Case$720

Scenario Input

Sales Volume Growth

20225.0%
20234.0%
20244.0%
20254.0%
20264.0%

Active: Base Case

Base Case4.0%Best Case4.0%Worst Case2.0%

Income Statement & Cash Flow Snapshot

Scenario: Base Case
Metric20222023202420252026
Gross Revenue$289.4$272.7$322.7$325.5$315
Net Revenue$252.5$233.6$281.2$281.2$268.2
EBITDA$110.8$86.2$128$121$101.2
EBIT$94.6$69.5$110.7$103.1$82.7
Net Income$53.7$38.4$65.9$62.1$49.9
Operating Cash Flow$71.6$63.7$81.4$80.4$73.3
EBITDA Margin38.3%31.6%39.7%37.2%32.1%
EBIT Margin32.7%25.5%34.3%31.7%26.3%

Model Notes

  • Scenario engine mirrors the Excel workbook assumptions for inflation, pricing, and volume growth.
  • Financial statements adjust dynamically per scenario, re-computing revenue, margins, and cash flow.
  • Working capital adjustments reuse the Excel base-case deltas to keep cash flow behaviour consistent.

Implementation Notes

  • Extracted workbook logic into strongly typed TypeScript data (`lib/financialModel.ts`), so the UI can render scenarios without shipping proprietary files.
  • Built a reusable `ModelDemo` component featuring KPIs, charts, scenario tables, and copy that mirrors my finance storytelling.
  • Highlights base/best/worst case drivers, portfolio sensitivities, and takeaways recruiters can discuss in interviews.