Financial Forecast Template

Company: [Company name] Prepared by: [Your name / role] Period: [3 years, starting Year 1 = YYYY] Currency: [USD] Last updated: [Date]

---

1. Key assumptions

List the drivers everything else depends on, so a reader can sanity-check the whole forecast at a glance. Change one value here and the projections below should move with it.

Driver	Value	Source / basis
New customers per month (Year 1)	[number]	[pilot data / benchmark]
Average revenue per customer / month	[amount]	[pricing / plan mix]
Monthly churn rate	[percent]	[comparable / target]
Cost of goods sold (% of revenue)	[percent]	[unit economics]
Fully-loaded headcount multiplier	[e.g. salary + 25%]	[taxes, benefits, equipment]
Customer payment terms	[e.g. net 30]	[contract standard]

2. Revenue drivers (build bottom-up)

Driver	Year 1	Year 2	Year 3
Customers at year end	[number]	[number]	[number]
Average revenue per customer / year	[amount]	[amount]	[amount]
New customers added in year	[number]	[number]	[number]
Customers lost (churn) in year	[number]	[number]	[number]
Total revenue	[amount]	[amount]	[amount]

3. Profit and loss by quarter (Year 1)

Line	Q1	Q2	Q3	Q4
Revenue	[amount]	[amount]	[amount]	[amount]
Cost of goods sold	[amount]	[amount]	[amount]	[amount]
Gross profit	[amount]	[amount]	[amount]	[amount]
Operating expenses (people)	[amount]	[amount]	[amount]	[amount]
Operating expenses (other)	[amount]	[amount]	[amount]	[amount]
Operating profit / (loss)	[amount]	[amount]	[amount]	[amount]

4. Cash flow summary by quarter (Year 1)

Line	Q1	Q2	Q3	Q4
Opening cash	[amount]	[amount]	[amount]	[amount]
Cash in (collections, funding)	[amount]	[amount]	[amount]	[amount]
Cash out (costs, capex)	[amount]	[amount]	[amount]	[amount]
Net cash movement	[amount]	[amount]	[amount]	[amount]
Closing cash	[amount]	[amount]	[amount]	[amount]

5. Scenarios

Scenario	Year 3 revenue	Year 3 operating margin	Lowest cash point
Base case	[amount]	[percent]	[amount, month]
Downside (slower growth, higher churn)	[amount]	[percent]	[amount, month]
Upside (faster growth or new raise)	[amount]	[percent]	[amount, month]

6. Notes

[Record which assumptions are firm vs. tentative, what you would cut first in the downside case, and the date you last compared this forecast against actual results. Re-baseline at least quarterly.]