Financial Forecast

Financial Forecast

Build rigorous financial forecasts that model revenue, expenses, and cash flow across multiple scenarios. This skill produces a structured forecast with transparent assumptions, sensitivity analysis, and clear narrative.

Step 1 — Establish Forecast Parameters

Define the scope and ground rules before modeling.

Checklist

• Historical data validated and reconciled (minimum 12 months)
• Accounting basis confirmed (accrual vs. cash)
• One-time items identified and normalized from base period
• Seasonality patterns documented
• External benchmarks sourced (industry, peers)

Step 2 — Revenue Modeling

Build the revenue forecast from drivers, not just growth rates.

Revenue Driver Framework

Revenue Build Template

Step 3 — Expense Projections

Model costs using a combination of committed, planned, and variable components.

Expense Categories and Drivers

Expense Summary Template

Step 4 — Cash Flow Analysis

Translate the P&L forecast into cash movements.

1. Operating Cash Flow: Start with net income; add back non-cash items (D&A, stock-based comp); adjust for working capital changes (AR, AP, deferred revenue).
2. Investing Cash Flow: CapEx, acquisitions, asset disposals.
3. Financing Cash Flow: Debt draws/repayments, equity raises, dividends.
4. Net Cash Position: Ending cash = beginning cash + net cash flow.

Cash Flow Template

Cash Runway Calculation

• Monthly burn rate = average of last 3 months operating cash flow (if negative)
• Cash runway (months) = current cash balance / monthly burn rate
• Flag if runway < 12 months

Step 5 — Scenario Planning

Model three scenarios to bound the range of outcomes.

Scenario Summary

Scenario Triggers

Define what real-world events would push toward each scenario:

• Worst Case: Major customer loss, market downturn, regulatory change, key hire departures.
• Best Case: Viral adoption, large enterprise deal, favorable market shift, successful product launch.

Step 6 — Assumptions Documentation

Every forecast is only as good as its assumptions. Document them explicitly.

Assumptions Log

Output Format

## Financial Forecast — [Entity] — [Horizon]

### 1. Executive Summary
- Key takeaway in 3-5 bullets
- Headline numbers: revenue, EBITDA, cash position

### 2. Revenue Forecast
[Driver-based revenue build with monthly/quarterly detail]

### 3. Expense Forecast
[Categorized expense projections]

### 4. P&L Summary
[Income statement: revenue through net income]

### 5. Cash Flow Forecast
[Operating, investing, financing cash flows; ending balance]

### 6. Scenario Analysis
[Side-by-side comparison of worst/base/best]

### 7. Assumptions & Risks
[Numbered assumptions log; key risks and mitigants]

### 8. Appendix
- Monthly detail tables
- Sensitivity tables (e.g., revenue +/- 10%, COGS +/- 5%)
- Bridge from prior forecast to current

Quality Checklist

• Revenue drivers are bottom-up, not just "last year + X%"
• Expenses tie to headcount plan and committed contracts
• Cash flow reflects working capital timing, not just P&L
• Three scenarios are meaningfully different, not just +/- 10%
• Every assumption has a source and confidence level
• Model balances (assets = liabilities + equity, if full balance sheet)
• Forecast is compared to prior forecast and actuals (bridge analysis)
• Seasonality is reflected in monthly/quarterly phasing

Edge Cases