FP&A Scenario Planner

About This Tool

The problem this planner solves, how it works, and the model behind the numbers.

Business Problem

Modern FP&A teams are asked to model an ever-wider range of futures, yet the tools they rely on were never designed for it. Financial models live in sprawling spreadsheets where formulas break silently when a row is inserted or a sheet is renamed, and nobody discovers the damage until the numbers stop reconciling.

When leadership asks "what happens to EBITDA if demand drops 6% and we freeze hiring?", answering means rebuilding a model by hand — a process that takes days and often arrives after the decision has already been made. In the meantime, assumptions are scattered across business units: sales plans its pipeline in one file, HR models headcount in another, and finance reconciles them in a third. There is no single source of truth, so every scenario comparison starts with a debate about whose numbers are current.

Solution

This interactive scenario planner replaces the fragile spreadsheet chain with one standardized model. Assumptions are captured once as structured drivers — revenue, growth, expenses, headcount, salaries, marketing, and tax — and every page in the app reads from the same record, so the dashboard, reports, and exports can never disagree.

Adjust a driver and the forecast recomputes in real time. Scenarios are saved side by side, so the CFO dashboard can compare any combination of best, base, and worst cases — or your own custom cases — on a single chart, in seconds instead of days. When the conversation moves to the boardroom, a one-click executive summary turns the active scenario into a presentation-ready report with narrative insights built in.

Key Features
The core workflows of the planner.

Interactive Dashboard

CFO-grade KPI cards for revenue, EBITDA, net income, and cash — with a multi-scenario comparison chart that plots any combination of cases side by side.

Live Assumptions

Every driver — growth, expenses, headcount, salaries, marketing, tax — is an editable numeric input or slider. Change a value, save, and every view updates instantly.

Multi-Scenario Comparison

Best, base, and worst cases — plus your own custom scenarios — compared on one chart with an interactive legend and per-metric toggles.

Executive Summary Generator

A board-ready one-pager with KPIs, the 12-month projection chart, key assumptions, and a written narrative that explains the numbers.

PDF & CSV Exports

One-click print-styled PDF export of the executive summary, and a structured CSV with metadata, assumptions, KPIs, and monthly projections.

Forecast Model Methodology
The engine computes a simplified, fully auditable 12-month forecast from each scenario's drivers. Every metric below is calculated per month from the active scenario.
  1. 01Annual Revenue Forecast = Base Revenue × (1 + Growth Rate)

    The base annual revenue is uplifted once by the scenario's growth rate to produce the full-year revenue forecast.

  2. 02Monthly Revenue Forecast = Annual Revenue Forecast ÷ 12

    Revenue is distributed evenly across the twelve months — no fractional compounding — so charts stay simple and auditable.

  3. 03EBITDA = Monthly Revenue − Operating Expenses − (Headcount × Average Salary) − Marketing Budget

    Operating profit after core operating expenses, payroll (headcount times the average salary per employee), and the marketing budget. Cost lines are annual figures divided by 12 for each month.

  4. 04Net Income = EBITDA × (1 − Tax Rate)

    Operating profit is reduced by the scenario's effective tax rate to arrive at net income.

  5. 05Cash Flow = Net Income + Depreciation Add-back (5% of Opex) − CapEx (3% of Revenue)

    Cash flow adds back the non-cash depreciation estimate (5% of operating expenses) and subtracts the capital expenditure estimate (3% of revenue).

Scenario inputs are annual figures; the engine divides cost lines by twelve to compute each month. Growth is applied once per year rather than compounding monthly, keeping the model transparent and easy to trace back to its assumptions.