Scenario analysis
Turn “what if?” into a finance answer.
Ask Rebase a business question. It gathers the relevant plans, assumptions and financial position, runs the scenario through your existing model or defined finance logic, and explains the result.
Leadership asks the question. Finance keeps control of the assumptions.
Leadership asks in sentences. FP&A answers in models.
Every question from the leadership team turns into an afternoon in the model. The asking takes a minute; the answer takes the rest.
What leadership asks
- CEO
Can we hire another 40 engineers?
- VP Sales
What happens if we add 20 account executives?
- CFO
What if growth comes in five points lower?
- COO
Can we open Europe next year?
What FP&A normally does
Translate
- Find the assumptions
- Open the latest model
- Find the latest forecast
Model
- Update the inputs
- Check the dependencies
- Calculate cash
- Build the scenarios
Validate
- Validate the outputs
Communicate
- Explain the results
- Prepare the slides
Rebase handles the model work between the question and the answer.
How a scenario runs.
The question is the only thing that arrives in plain language. Everything after it is assumptions, logic and arithmetic you can check.
Can we hire 40 engineers from January?
- Understand the decisionTurn the question into the financial variables it involves.Variableshires 40 · start Jan 2027 · loaded cost · ramp · recruiting · minimum cash
- Gather the right assumptionsPlans, contracts, headcount, pipeline, cash, pricing and commitments.Models + assumptionsForecast Model v12 · Headcount Plan: $145K, 4 months, $12K · Cash Plan: $20M minimum
- Use trusted logicRun it through your existing models, spreadsheet formulas, SQL logic and defined business rules.ƒxCalculation40 × $145K × 10/12 = $4.8M of FY27 opex
- Calculate the impactsP&L, cash, the balance sheet where relevant, headcount, runway, and the budget and forecast.ImpactsFY26 +$0.48M · FY27 +$4.8M · cash low $20.7M, May 2027
- Compare optionsRun alternative values without rebuilding the model by hand.Scenarios20 hires: all limits met · 40: 1 limit exceeded · 60: 3 limits exceeded
- Explain the trade-offGive leadership the answer, and finance the calculation underneath it.Decision40 from January: $1.8M over the FY27 plan. 20 fits every limit.
Decisions finance gets asked to model.
Six questions that land on FP&A every quarter. Each one is a set of assumptions, run through the model the team already trusts.
- Hiring
“Can we hire another 40 engineers?”
Start dates, loaded cost, ramp and recruiting, run against this year's forecast, next year's plan and cash.
CalculatesOpex by year · cash low point · headcount
- Pricing
“What happens if prices increase 5%?”
Price, volume and churn assumptions, run through revenue, gross margin and collections.
CalculatesRevenue · gross margin · cash
- Cost reduction
“What if operating costs need to fall 10%?”
Which lines can move and when, with contracts, notice periods and commitments respected.
CalculatesOpex by line · run rate · EBITDA
- Sales capacity
“What does adding 20 account executives do to revenue, burn and cash?”
Ramp, quota, attainment and cost per rep, against pipeline and the cash plan.
CalculatesBookings · burn · cash low point
- New market
“What does entering a new region cost before breakeven?”
Set-up, hiring and the revenue ramp for the region, month by month.
CalculatesInvestment · breakeven month · cash
- Vendor commitments
“Can we sign a three-year infrastructure commitment?”
Committed spend against expected usage, discounts and the cash plan, year by year.
CalculatesCommitment · savings · cash by year
Worked example
From one question to three scenarios.
The same hiring question at 20, 40 and 60 engineers, each tested against the same three limits. Change an assumption and every figure is calculated again.
| Scenario | Hires | FY26 recruiting · current year | FY27 opex · next year | Minimum cash | Result |
|---|---|---|---|---|---|
| Up to $0.5M | Up to $3.0M | At least $20M | |||
| 0 | Baseline | Baseline | $22.6M | Within plan | |
| 20 | +$0.24M | +$2.4M | $21.6M | Within plan | |
| 40 | +$0.48M | +$4.8M | $20.7M | FY27 exceeds plan | |
| 60 | +$0.72M | +$7.3M | $19.7M | Exceeds all three limits |
Assumptions
- Additional hires40
- Start date
- Average loaded cost$145KHeadcount Plan.xlsx
- Hiring ramp, monthsHeadcount Plan.xlsx
- Recruiting cost / hire$12KHeadcount Plan.xlsx
Policy limit
Minimum operating cash$20MTreasury policy: a limit, not an assumptionResult
1 limit exceededFY27 plan- FY26 recruiting+$0.48MLimit $0.5M · Oct–Dec 2026Within limit
- FY27 operating expense+$4.8MRoom $3.0M · Jan–Dec 2027Exceeds limit
- Lowest cash$20.7MMinimum $20M · May 2027Within limit
Rebase summary
40 engineers from January break one limit: $1.8M more in FY27 than the plan allows.
AI understands the question. Finance math answers it.
Two layers, kept apart on purpose. The language model reads the question and writes the explanation; the figures come from your models, formulas and rules.
The explanation can be AI-generated. The numbers are calculated.
Keep asking without rebuilding the model.
Each follow-up changes an assumption, not the spreadsheet. Rebase recalculates, keeps the previous answers, and says what moved.
Keep the assumptions attached to the decision.
The scenario that went to the board is a record, not a screenshot: who asked, what it assumed, how it was calculated and who signed it off.
- Asked by
- CEO
- Prepared by
- Rebase
- Reviewed by
- Sarah ChenVP FP&A
- Models
- 3 models
- Assumptions
- 5 defined
- Calculation version
- v3.5
- Included in
- Q3 Board Report.pptxSlide 9
Assumptions5 defined
- Additional hires
- 30From the v3.5 options
- Start date
- Apr 1, 2027From the v3.5 options
- Loaded cost
- $145K US · $110K EuropeHeadcount Plan.xlsx
- Hiring ramp
- 4 monthsHeadcount Plan.xlsx
- Recruiting cost / hire
- $12KHeadcount Plan.xlsx
ResultsAll three limits met
- FY26 recruiting · Oct–Dec 2026+$0.36M
- FY27 opex · Jan–Dec 2027+$2.2M
- Cash low · May 2027$22.1M
Calculation versionsv3.2 to v3.5
- v3.240 engineers from January
- v3.3Start moved to March
- v3.4Half in Europe
- v3.5Options with cash above $22M
The scenario, assumptions and calculations remain attached to the decision.
Questions
Where Rebase starts and stops.
Does AI calculate the scenario?
No. The AI reads the question and explains the answer. The figures come from your models, formulas, defined assumptions and business rules.
Can Rebase use our existing financial models?
Yes. Rebase runs a scenario through the models your team already trusts, such as the forecast model, the headcount plan and the cash plan, or through finance logic you define.
Can we change the assumptions?
Yes. Every assumption is shown with where it came from. Change one and the scenario is calculated again.
Can we compare scenarios?
Yes. Options run side by side against the same limits, so the trade-off between them is plain.
Is there a record of the scenario behind a decision?
Yes. The scenario keeps its assumptions, the model and calculation version, its results and who reviewed it.
Bring the question leadership asked this week.
We'll show you how Rebase would assemble the inputs, run the model and prepare the answer.