"What If" Scenario Planner
Model the financial impact of business decisions before you make them. Adjust growth, hiring, expenses, and investments to compare outcomes.
Baseline
Scenario Adjustments
Impact Summary
Total Revenue (12 months)
Current
$960,000
Cash at Month 12
Current
$380,000
Cash Runway
Current
12+ months
Month 12 Snapshot
Revenue
$80,000
Expenses
$65,000
Net Income
$15,000
Cash Balance
$380,000
12-Month Projection
Cash Balance
Monthly Breakdown (Scenario)
| Month | Revenue | Expenses | Net Income | Cash |
|---|---|---|---|---|
| Month 1 | $80,000 | $65,000 | $15,000 | $215,000 |
| Month 2 | $80,000 | $65,000 | $15,000 | $230,000 |
| Month 3 | $80,000 | $65,000 | $15,000 | $245,000 |
| Month 4 | $80,000 | $65,000 | $15,000 | $260,000 |
| Month 5 | $80,000 | $65,000 | $15,000 | $275,000 |
| Month 6 | $80,000 | $65,000 | $15,000 | $290,000 |
| Month 7 | $80,000 | $65,000 | $15,000 | $305,000 |
| Month 8 | $80,000 | $65,000 | $15,000 | $320,000 |
| Month 9 | $80,000 | $65,000 | $15,000 | $335,000 |
| Month 10 | $80,000 | $65,000 | $15,000 | $350,000 |
| Month 11 | $80,000 | $65,000 | $15,000 | $365,000 |
| Month 12 | $80,000 | $65,000 | $15,000 | $380,000 |
How it works
This tool projects your financials 12 months forward under two conditions: your current trajectory (no changes) and a scenario you define using the sliders. Revenue growth compounds monthly -- a 5% monthly growth rate means each month's revenue is 5% higher than the previous month. New hires add to your salary expenses starting in month 2. Expense reductions apply to non-salary costs. The one-time investment is deducted from your cash balance in month 1. Price increases raise your revenue immediately and compound on top of growth.
The formula
Why it matters for your business
Every significant business decision -- hiring a team, raising prices, cutting costs, making an investment -- has cascading financial effects. Scenario planning lets you stress-test those decisions against your actual numbers before committing. When a VC asks "what happens if growth slows by 50%?" or a board member asks "can we afford 5 new hires?", having a modeled answer ready demonstrates operational maturity and builds confidence.
Pro tip
VCs ask "what happens if growth slows by 50%?" -- having a modeled answer ready shows operational maturity.
Get deeper insights with James FP&A
These calculators are just the start. Connect your accounting data and get automated financial analysis, forecasting, and real-time dashboards.