Startup financial model: revenue, costs and cash runway

A startup financial model connects the customers you expect to serve, the people and services you expect to pay for, and the cash available each month. Begin with actual exports, build explicit operating assumptions and compare the resulting cash schedule with the approved plan.

The useful output is a dated picture of cash needs, with the assumptions visible. A revenue target alone cannot tell leadership whether payroll is affordable before the next customer payment or funding receipt.

1. Start with the files you already have

Collect a customer billing export, bank transactions, payroll costs, unpaid supplier bills and the latest balance sheet. Preserve the approved budget workbook as a separate version. Actual rows should carry a period, account or category, amount, source identifier and a flag distinguishing actuals from assumptions.

Reconcile opening cash to bank records, then separate unrestricted operating cash from amounts the business cannot spend. Identify card balances, payroll liabilities and unpaid invoices so a low bank payment month is not mistaken for a permanently lower cost base.

The SBA's startup-cost guidance separates one-time costs from recurring monthly expenses. Use the same distinction in the workbook: a security deposit and a recurring software bill have different timing, even when both need funding.

For the broader links between assumptions and statements, see financial modeling. The steps here focus on a startup's monthly operating and cash comparison.

2. Build revenue from a driver you can measure

An illustrative US subscription startup begins January with 50 paying customers. The workbook assumes 10 additions and 5 departures each month. Each month-end customer pays $500 for that month, with additions and departures effective at the start of the month; no partial-month charges apply.

This deliberately simple billing convention makes the arithmetic reproducible. Replace it with your actual activation, cancellation and billing rules before using it for a company forecast.

Closing customers = Opening customers + New customers − Departing customers

Monthly revenue = Billable customers × Monthly price

Closing cash = Opening cash + Collections + Funding − Cash payments

Use these rows in Excel, with January in column B, February in C and March in D. Enter source inputs in the named input rows; the table gives the calculated rows.

The example assumes customers pay in the billing month, so revenue and collections are equal. The SEC's financial statements guide distinguishes accounting performance from cash flows. If customers pay later, add a receivables schedule and calculate collections separately rather than shifting revenue to the payment date.

3. Add hiring, delivery costs and other payments

Assume delivery costs are $100 per billable customer. Loaded monthly payroll includes employer costs and benefits: $45,000 in January and February, rising to $50,000 in March under the supplied hiring plan. Other operating payments are $15,000 monthly. There are no separate taxes, capital purchases, financing or working capital movements in this example.

For February, set C14=B15 and copy the calculated formulas across with relative references. In March, change payroll to the approved $50,000 input. Microsoft documents SUM as adding values, cell references or ranges; using a continuous range also makes the payment total easy to inspect. Covirage is not affiliated with Microsoft.

Do not assume planned revenue can occur without the people to sell and deliver it. Capacity planning connects staffing assumptions to the work that the budget requires.

4. Work the monthly cash schedule

All dollar amounts below are exact. Runway ratios in the next section are rounded to one decimal place; retain full precision in the workbook.

The quarter's collections total $90,000. Payments total $203,000, leaving net cash burn of $113,000. The cash check is $240,000 + $90,000 − $203,000 = $127,000, matching March's closing balance.

Also check customer continuity: every month's opening count must equal the preceding month's closing count. Tie actual collections and payments to the bank reconciliation, rather than comparing a cash plan with invoice totals.

5. Calculate runway with a stated starting point

Static runway in months = Available unrestricted cash / Monthly net cash burn

At the start of January, $240,000 / $38,000 gives 6.3 months if January's burn repeats. At the end of January, $202,000 / $38,000 gives 5.3 remaining months under that same assumption. The dates matter: using opening cash while describing remaining runway after the month ends overstates the available time.

In Excel, starting runway is =B14/B13 and closing runway is =B15/B13, provided burn is positive. If burn is zero or negative, label the ratio as not applicable and inspect the monthly cash schedule instead of presenting a misleading negative runway.

Here burn changes as customers and payroll change. Extend the dated monthly schedule to find when cash falls below the company's required reserve. Neither static ratio identifies that date by itself, and the example does not assume an unconfirmed funding round will close.

Sector operating drivers differ: a manufacturing financial model needs production and inventory assumptions, while a fintech financial model requires its own business-specific volume and cost inputs.

6. Compare actuals without rewriting the plan

Suppose January actuals show 8 new customers, the planned 5 departures, payroll of $47,000 and other payments of $16,000. Price and unit delivery cost stay unchanged. Collections still occur in the billing month.

Two fewer customers reduce receipts by $1,000 and delivery payments by $200, increasing burn by $800. Payroll adds $2,000 and other payments add $1,000: $800 + $2,000 + $1,000 = the $3,800 burn variance. The proof is $240,000 − $41,800 = $198,200.

Actual closing runway at unchanged actual burn is $198,200 / $41,800 = 4.7 months. A separate $10,000 collection delay would reduce closing cash to $188,200 without changing earned revenue. Keep that timing variation distinct from the customer-growth variance. Use financial data reconciliation to resolve unmatched source rows before interpreting differences.

Where a startup financial model goes wrong

• Fundraising as guaranteed operating cash. Keep unconfirmed funding in a separate scenario with an explicit receipt date.
• Incomplete hiring costs. Salaries alone omit employer taxes, benefits, recruiting and the timing of cash payments.
• Revenue counted as immediate cash. Annual contracts, advance payments and late collections need explicit schedules.
• A single burn average hiding commitments. New hires, insurance renewals and supplier deposits can change the month cash runs short.
• Actuals replacing the approved budget. Preserve versions so leadership can distinguish execution gaps from changed assumptions.

Compare your startup plan with actual files in Covirage

Bring your startup budget workbook and a sample of your own billing, spending and cash exports; Covirage maps the columns, and its tools compute and check the supplied plan against actual results. The external AI model explains the differences with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your files.

See Covirage for finance teams for the supporting finance workflow.