A startup financial model should answer practical questions: when might cash run short, which spending decisions can change that date, and what funding would be needed to carry out the plan?
Start with the business drivers and cash timing. A valuation estimate does not pay payroll, and an annual profit forecast can hide a shortage within the year. This guide uses a fictional three-month cash example that you can rebuild in Excel.
Choose the question and the forecast period
Define who will use the model and what they need to decide. A founder planning hiring needs a cash schedule. A lender may need repayment analysis. An investor may also need ownership and valuation information. These are related outputs, but they are not interchangeable.
Choose a period that captures the decision and the timing of receipts and payments. Monthly forecasts are useful for many operating plans; very tight liquidity may require weekly detail. Three months here illustrates the mechanics, not a recommended forecast horizon for every startup.
Build revenue from operating drivers
Choose drivers that fit the business. A product business may use units and price. A subscription business may need opening customers, additions, cancellations, billing terms and collection timing. A service firm may use available staff, billable capacity and realized rates.
Record evidence and uncertainty beside the assumptions. Another startup’s sales are not automatically a suitable forecast for yours. Use comparisons as context and explain the actual capacity, customer acquisition or conversion assumptions behind your plan.
Keep revenue separate from collections. If customers pay later, the sale and receipt fall into different periods. If they pay in advance, billing and cash can precede recognized revenue.
Map the spending and its timing
- People: hiring dates, pay, employer costs and payment dates.
- Variable costs: the driver, rate and supplier payment terms.
- Other operating costs: software, premises, marketing and professional services.
- Investment: equipment, setup spending and other capital requirements.
- Financing: committed funding, fees, interest and repayments.
Do not enter a proposed investment as received cash before it is committed and its timing is supported. Show an unfunded gap clearly rather than creating an automatic financing assumption that makes it disappear.
A three-month cash example
Opening cash is 30,000. Assume the collections below, variable cash payments of 20% of collections, payroll and other cash costs as shown, and equipment spending of 3,000 in Month 1. These are fictional inputs in one currency. There are no taxes, interest, borrowing or other transactions in this teaching case.
| Cash item | Month 1 | Month 2 | Month 3 |
|---|---|---|---|
| Opening cash | 30,000 | 15,200 | 3,000 |
| Customer collections | 4,000 | 6,000 | 9,000 |
| Variable cash payments | −800 | −1,200 | −1,800 |
| Payroll payments | −10,000 | −12,000 | −12,000 |
| Other operating payments | −5,000 | −5,000 | −5,000 |
| Equipment payment | −3,000 | 0 | 0 |
| Net cash change before funding | −14,800 | −12,200 | −9,800 |
| Closing cash before funding | 15,200 | 3,000 | −6,800 |
The negative Month 3 figure is an unfunded shortfall, not permission to spend money the business does not have. The plan requires changed spending, additional collections or funding before that point. Monthly totals do not reveal the exact day cash runs short.
Rebuild the cash schedule in Excel
Use columns B:D for the three months. Put opening cash in row 2, collections in row 3 and cash outflows as negative values in rows 4:7. In B8 enter =SUM(B3:B7). In B9 enter =B2+B8. Link C2 to B9 and D2 to C9, then copy the cash-change and closing-cash formulas across.
Add a separate row for actual financing receipts if you want to test funding. Do not overwrite closing cash with a desired amount. Record the source and conditions of each financing assumption.
Calculate the funding gap against a cash buffer
Assume a minimum month-end cash buffer of 5,000. Without funding, the example breaches that buffer in Month 2 and becomes negative in Month 3.
The lowest projected month-end balance is −6,800. An upfront cash injection of 11,800 would raise that lowest balance to 5,000 if all operating assumptions remain unchanged. The funded closing balances would be 27,000, 14,800 and 5,000.
This is the arithmetic funding need for the stated plan and buffer. It is not evidence that funding is available or sufficient for risks omitted from the case. Check within-month payments, fees, contingencies and the timing of the proposed funding.
Use burn and runway carefully
Define whether your burn measure includes only operating cash or also equipment and financing payments. State the period and whether the amount is gross outflow or net of collections.
Dividing available cash by a constant monthly net burn gives a simple runway estimate. It becomes less informative when collections, hiring or capital spending change materially. In this example, use the monthly cash forecast to locate the shortage instead of assuming one month’s burn stays constant forever.
Connect the statements when the task requires them
A direct cash forecast is not a complete income statement or balance sheet. A fuller model needs revenue recognition, receivables, payables, assets, depreciation, debt and equity. Keep the dates and periods consistent across those schedules.
For a worked set of links, use the three-statement Excel example. If you forecast receivables using days sales outstanding, match the day count to the revenue period; dividing annual revenue by 30 mixes annual and monthly bases.
Test a decision and update the forecast
Try delaying the Month 2 payroll increase until Month 3. Month 2 cash improves by 2,000 and Month 3 closing cash also improves by 2,000. Explain the operational consequences before treating that as an available action.
Replace completed periods with actual collections and payments. Explain variances and update the remaining assumptions. Preserve the previous forecast so you can see what changed.
Keep valuation separate from the cash plan
There is no universal Series A valuation range or one valuation method that fits every startup. A DCF can be highly sensitive when future cash flows are uncertain. Financing terms, ownership rights and the evidence behind the business assumptions also matter.
Use the enterprise-to-equity bridge when learning valuation mechanics. For the immediate operating plan, first make the cash timing, spending choices and unfunded gap visible.
