Financial Planning
Startup Financial Model: Assumptions and Scenarios
Build a startup financial model around cash timing, explicit assumptions, and scenarios. Use a worked example and a copyable assumptions register.
What you will learn
- Connect commercial assumptions to monthly cash
- Build base and downside scenarios
- Maintain an auditable assumptions register
A startup financial model is a structured explanation of how operating decisions affect revenue, spending, and cash. Start with assumptions you can discuss and update. A beautiful spreadsheet is less useful than a simple model whose inputs, dates, and limitations are clear.
Build the monthly bridge
- Define the time period and opening cash balance.
- Model customer activity and pricing separately from collection timing.
- List recurring operating payments and one-off obligations.
- Calculate closing cash each month, then carry it forward.
- Compare actual results with the forecast and update the assumptions that changed.
Closing cash = opening cash + cash collected − cash paid out
Next month’s opening cash = this month’s closing cashRevenue, invoices, and collections may occur in different months. A signed annual contract can be valuable without putting a year of cash in the bank immediately. Keep financing separate so the model works even before a round closes.
A worked three-month cash scenario
Fictional startup, simplified for teaching: opening cash is $180,000. Monthly payments are $45,000. The base case collects $15,000, $20,000, and $25,000. The downside case collects $10,000 each month. Neither case assumes new investment.
| Month | Base closing cash | Downside closing cash |
|---|---|---|
| 1 | $150,000 | $145,000 |
| 2 | $125,000 | $110,000 |
| 3 | $105,000 | $75,000 |
The base case uses $75,000 over three months; the downside uses $105,000. That difference comes from collections, not a different hiring plan. This lets the team debate a specific assumption rather than argue about whether the whole forecast is optimistic.
Give every important input an owner
| Assumption | Basis | Owner | Update trigger |
|---|---|---|---|
| New paying customers | Dated funnel evidence or hypothesis | Commercial lead | Conversion or timing changes |
| Collections | Contract terms and payment history | Finance owner | Invoice delay or contract change |
| Hiring | Approved roles and start dates | Leadership | Offer or start-date change |
| Delivery cost | Observed usage and service requirements | Operations | Vendor or workload changes |
Use one register for inputs, definitions, source documents, and review dates. Make assumptions editable in one place rather than hiding different versions across tabs. Keep a revision note explaining which operating decision changed.
Your first-model brief
Purpose of this model: [decision]
Period and currency: [months + units]
Actual data through: [date]
Opening available cash: [source]
Customer and pricing assumptions: [evidence]
Collection timing: [terms]
Payments and one-off obligations: [owners]
Base case: [inputs]
Downside case: [changed inputs]
Next decision checkpoint: [date]Before sharing, ask a teammate to change one major input and follow its effect through the model. If the output does not move as expected, fix the logic before adding more detail. Use our established model-mistakes article as a separate review checklist.
Put the lesson to work
Keep the model, source register, and investor questions together so follow-up starts from the same assumptions. Explore Finta Academy.
A Finta Field Guide based on our Fundraising Academy teaching. Worksheets and fictional examples are original educational exercises, not customer results or personalized financial, legal, or tax advice.
Continue with an established guide
This lesson covers a specific exercise. For the broader resource, read Startup Financial Projections: 7 Financial Model Mistakes.