Forecasting & Scenario Modeling
Build rolling 12-month forecasts, model base, conservative, and aggressive scenarios, and make data-driven decisions about hiring, spending, and fundraising.
Fundamentals
How Forecasting Works
Forecasting in James is built on a simple principle: take what you know (historical data and current trends), combine it with what you assume (growth rates, planned hires, expected deals), and project forward 12 months. The result is a month-by-month projection of your income statement and cash position that updates automatically as new actuals come in.
Unlike a static budget that is set once a year, a rolling forecast always looks 12 months ahead from the current date. As each month closes and actual results are recorded, the forecast window shifts forward by one month. This means you always have a full year of forward visibility, and the forecast is continuously refined with the latest real-world data. The further out you project, the less certain the numbers become — but even a rough 12-month outlook is infinitely more useful than flying blind.
James uses your historical financial data as the baseline for the forecast. Revenue trends, expense patterns, seasonality, and growth rates are analyzed automatically. You then layer your assumptions on top — planned headcount changes, expected revenue deals, pricing adjustments, or cost savings initiatives. The combination of historical patterns and forward-looking assumptions produces a forecast that is both grounded and customizable.
Step by Step
Creating a Forecast
Select Baseline
Choose which historical period James should use as the starting point. Recent months are typically best, but you can exclude anomalous periods (like a one-time large deal) to avoid skewing the projection.
Set Growth Assumptions
Define your expected revenue growth rate — month-over-month or year-over-year. You can set different rates for different revenue streams if you have multiple product lines or service offerings.
Define Cost Structure
Specify which costs are fixed (rent, salaries) and which scale with revenue or headcount. Set your hiring plan, planned capital expenditures, and any known one-time expenses.
After setting up these three components, James generates your 12-month projection. You will see a month-by-month income statement showing projected revenue, expenses, and net income. Below that, a cash projection shows your expected cash balance at the end of each month — accounting for the timing differences between when revenue is recognized and when cash actually arrives.
The forecast is interactive. Change any assumption — increase the growth rate, add a new hire in month 4, remove a planned expense — and the entire projection recalculates instantly. This is what makes James forecasting fundamentally different from a spreadsheet: the model is live, connected, and responsive to changes.
Scenarios
Scenario Modeling
A single forecast gives you a plan. Multiple scenarios give you a strategy. James supports three standard scenarios — Base, Conservative, and Aggressive — plus custom scenarios for specific what-if analyses. Each scenario uses the same underlying model structure but with different assumptions, letting you see the range of possible outcomes.
Your Base scenario represents your most likely outcome — the plan you are actually operating against. Revenue grows at the rate you are currently seeing, expenses follow the hiring plan, and no major surprises occur. This is your default planning assumption and the one you compare actuals against.
The Conservative scenario answers the question: what if things go worse than expected? Typically, this means reducing the revenue growth rate by 20-30%, delaying expected deals by one to two months, and assuming one or two key customers churn. The conservative scenario is your stress test — it shows you the worst plausible outcome so you can ensure your business survives even if things do not go as planned.
The Aggressive scenario models what happens if everything goes right. Revenue grows faster than expected, you close that large enterprise deal, and a new channel starts generating leads. This scenario is useful for capacity planning — if growth accelerates, do you have the infrastructure, team, and cash to support it?
Base Case
- Current growth rate continues
- Planned hires on schedule
- No major customer changes
- Standard operating costs
Conservative
- Growth rate reduced 20-30%
- Deals delayed 1-2 months
- 1-2 key customer churns
- Unexpected cost increase 10%
Aggressive
- Growth rate increased 30-50%
- Enterprise deal closes early
- New channel contribution
- Team scales with demand
Runway Impact
Runway Modeling
For startups and growth-stage companies, the most critical output of scenario modeling is its impact on cash runway. Each scenario produces a different runway number because each one generates a different burn rate trajectory. Understanding this range — not just a single number — is essential for making informed decisions about hiring, spending, and fundraising timing.
James displays a runway impact table that shows how specific decisions affect your cash-out date across scenarios. This makes abstract strategy conversations concrete: instead of debating whether to hire two engineers, you can see that in the base case it reduces runway from 14 months to 11 months, and in the conservative case it drops to 8 months.
| Impact Factor | Base | Conservative | Aggressive |
|---|---|---|---|
| Delay next 2 hires by 3 months | +2.5 months | +3.1 months | +1.8 months |
| Close enterprise deal ($50K/yr) | +1.2 months | +1.0 months | +0.8 months |
| Lose 2nd largest customer | -2.8 months | -3.4 months | -2.1 months |
| Cut marketing spend 50% | +1.8 months | +2.2 months | +1.4 months |
The impact table is particularly useful in board meetings and strategic planning sessions. When an investor asks "what happens if that deal does not close?" you can show the exact runway impact across all three scenarios in seconds rather than scrambling to update a spreadsheet. This level of preparedness builds confidence — both your own and your stakeholders'.
Decision Making
Comparing Scenarios
James provides a side-by-side scenario comparison view that shows all your scenarios on a single screen. For each month in the forecast horizon, you can see projected revenue, expenses, net income, and cash balance across all scenarios simultaneously. Charts overlay the scenarios with distinct colors so trends and divergence points are immediately visible.
The key metrics comparison table sits at the top of the view, showing you the most important numbers at a glance: end-of-period cash balance, runway in months, total revenue, total expenses, and net income — for each scenario. This summary makes it easy to assess the overall range of outcomes without getting lost in month-by-month details.
When using scenario comparisons for decision-making, adopt this framework: if a decision looks good in the base case but creates serious risk in the conservative case, proceed cautiously or build in contingency plans. If it looks good across all three scenarios, move confidently. If it only works in the aggressive case, recognize that you are betting on optimism and plan accordingly. The goal is not to predict the future — it is to make decisions that are robust across a range of plausible outcomes.
Maintenance
Updating Forecasts
A forecast is only valuable if it reflects your current reality. As actual results come in from your connected accounting software, James automatically replaces projected months with real numbers. If January was forecasted at $85K revenue but actual came in at $92K, the forecast incorporates that actual and adjusts the remaining months accordingly — especially if growth rate assumptions were tied to the baseline.
Beyond automatic updates, you should manually re-examine your forecast assumptions at least once a quarter. Have your growth assumptions held? Did you hire on the planned timeline? Are any major expenses coming that were not in the original model? James makes this easy by highlighting which assumptions have diverged from reality and suggesting adjustments.
When to fully re-forecast versus simply tweaking assumptions depends on the magnitude of the change. If your business is tracking within 10-15% of the base case, updating individual assumptions is sufficient. If you have experienced a fundamental shift — a major customer loss, a pivot in strategy, a new funding round — it is worth building a new forecast from scratch with updated assumptions across the board.
Pro Tip
Always maintain at least two active scenarios — your base case and a conservative case. The base case is your operating plan, and the conservative case is your safety net. When actuals start trending closer to the conservative case than the base case, that is your signal to act: cut costs, accelerate revenue initiatives, or begin fundraising conversations. Having the conservative scenario already built means you can recognize the early warning signs and respond quickly, rather than scrambling to model downside risk after the fact.
Start Forecasting
Build your first forecast in minutes and model the scenarios that matter to your business.