00 / Free tool
"What If" Scenario Planner
Model the financial impact of business decisions before you make them. Adjust growth, hiring, expenses, and investments to compare outcomes.
01 / Calculator
"What If" Scenario Planner
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
$80,000
Revenue
$65,000
Expenses
$15,000
Net Income
$380,000
Cash Balance
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 |
02 / Notes
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.
Formula
Revenue (month m) = Base Revenue x (1 + price increase %) x (1 + growth rate)^(m-1) Expenses (month m) = Non-salary x (1 - reduction %) + (Headcount + New Hires) x Avg Salary Net Income = Revenue - Expenses Cash (month 1) = Starting Cash - One-time Investment + Net Income Cash (month m) = Previous Cash + Net Income
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.
04 / Next step
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.