Blog · Finance metrics and formulas · Finance and FP&A teams
Financial analysis for startups compares actual cash burn, revenue and committed spending with the operating plan. Use a worked monthly review to reconcile the figures and separate runway from funding assumptions.
Financial analysis for startups compares actual revenue, cash burn and spending with the operating plan to identify what changed and what needs action. Begin with reconciled cash, then read revenue quality and commitments alongside runway. This is an operating review, separate from investment valuation or building a new financial plan.
Collect the monthly income statement, bank reconciliation, invoice and receipt exports, unpaid supplier bills, payroll totals and the approved operating plan. Add a commitment list for signed hires, renewals and purchases that have not yet reached the accounts. Use the same entity, currency and month labels across all files.
Keep recognized revenue separate from cash collected. IRS Publication 538 explains that accrual income is generally reported when earned, regardless of when payment arrives. For this review, record the accounting basis in the workbook rather than combining a cash-basis plan with accrual actuals.
Freeze the approved plan as a comparison column. If assumptions change, keep the revised outlook separately. Replacing the original plan with a new estimate every month removes the evidence of which assumptions failed.
Net operating cash burn = Operating cash payments − Customer cash receipts
Runway at a constant burn rate = Available cash / Average monthly net cash burn
This definition excludes financing flows. Equipment purchases and debt payments need separate lines if present. A period with net cash generation does not produce a meaningful positive burn-based runway; use a dated cash schedule instead.
A US subscription-services startup reviews January through March 2027. The example has no equipment purchases, debt payments, financing flows or restricted cash. Dollar figures are exact; percentages and runway are rounded to one decimal place from unrounded calculations.
| Month | Customer receipts (USD) | Operating cash payments (USD) | Net cash burn (USD) | Opening cash (USD) | Closing cash (USD) |
|---|---|---|---|---|---|
| January | 70,000 | 155,000 | 85,000 | 900,000 | 815,000 |
| February | 90,000 | 170,000 | 80,000 | 815,000 | 735,000 |
| March | 110,000 | 185,000 | 75,000 | 735,000 | 660,000 |
| Quarter | 270,000 | 510,000 | 240,000 | 900,000 | 660,000 |
The bank check is $900,000 + $270,000 − $510,000 = $660,000. Each closing balance must also match that month's bank reconciliation. Transfers between company bank accounts disappear from the consolidated cash movement rather than becoming receipts and payments.
Put the table's monthly rows in rows 2 through 4, with columns A through F in the displayed order. Net burn in D2 and closing cash in F2 are:
=C2-B2
=E2+B2-C2
Fill down, setting E3 to =F2 and E4 to =F3. The trailing average burn and runway are:
=AVERAGE(D2:D4)
=F4/AVERAGE(D2:D4)
Average burn is $80,000 per month, producing 8.3 months of runway at that unchanged rate. The exact calculation is 660,000 / 80,000 = 8.25. This is a sensitivity to a stated rate, not a promise about when cash will run out; the cash-runway definition covers the metric itself.
Suppose management wants to preserve $180,000. At the same burn rate, months before reaching that reserve are (660000-180000)/80000, or 6.0. Keep the reserve separate from total available cash so the team can distinguish its action threshold from exhausting the balance.
The income statement and plan show the following. Direct costs are the expenses of delivering the services, while operating expenses exclude those direct costs.
| Month | Planned revenue (USD) | Actual revenue (USD) | Actual direct costs (USD) | Planned operating expenses (USD) | Actual operating expenses (USD) |
|---|---|---|---|---|---|
| January | 90,000 | 85,000 | 25,500 | 135,000 | 140,000 |
| February | 110,000 | 105,000 | 31,500 | 140,000 | 150,000 |
| March | 130,000 | 120,000 | 36,000 | 145,000 | 165,000 |
| Quarter | 330,000 | 310,000 | 93,000 | 420,000 | 455,000 |
Using these columns as A through F on a separate sheet, revenue variance in G2 and expense variance in H2 are:
=C2-B2
=F2-E2
For percentage variance use =IF(B2=0,NA(),G2/B2) for revenue, with the equivalent planned-expense denominator for expenses. A positive expense variance means overspending; label that convention explicitly.
Quarter revenue is $20,000 below plan, or 6.1%. Operating expenses are $35,000 above plan, or 8.3%. Actual gross profit is $310,000 − $93,000 = $217,000, and the gross margin is 70.0%. Actual operating loss is $217,000 − $455,000 = $238,000.
The stable delivery margin does not remove the spending problem. Ask which expense categories explain the overrun, whether they recur and whether a manager approved the commitment. Use unit economics for the separate question of what individual customers or transactions contribute.
The invoice export shows $60,000 of opening receivables. All recognized revenue in this example was invoiced on credit, so closing receivables are $60,000 + $310,000 − $270,000 = $100,000. Receivables therefore increased by $40,000 even as cash receipts improved each month.
Total direct costs and operating expenses are $548,000, compared with $510,000 paid. Assume that difference is entirely an increase in unpaid operating bills, with no other noncash or timing adjustments. The cash reconciliation is:
| Operating cash reconciliation | Amount (USD) |
|---|---|
| Operating loss | -238,000 |
| Subtract increase in receivables | -40,000 |
| Add increase in unpaid operating bills | 38,000 |
| Net operating cash movement | -240,000 |
That matches the burn table. Improved collection totals alone do not prove better collection quality: receivables still rose. Review overdue invoices, disputed charges and customer concentration before assuming every outstanding dollar will arrive on schedule.
Separate recurring spending from isolated costs, following the SBA's distinction between monthly and one-time startup expenses. For each future commitment, record amount, payment date, owner and whether it can still be changed. Signed spending can raise future burn before it appears in a historical average.
Finance owns the reconciliation; the founder and operating managers own decisions about hiring, purchases and revenue assumptions. Translate the revised cash schedule into financial gap analysis when it shows a dated funding requirement.
Upload your actuals, operating plan and cash workbook; Covirage maps the columns, and its tools compute and check the comparisons. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for finance teams for the supporting business context.
Close and compare the accounts monthly, then review cash more frequently when payment dates or available funds demand it. The cadence should reflect the business's commitments and cash position. A monthly profit report alone can miss a shortage before a major payroll or supplier payment.
No. Revenue can grow before customers pay, and serving new customers may require hiring or purchases first. Compare recognized revenue, customer receipts and the cash cost of delivery separately. Runway improves only when the resulting cash requirement falls or available funding increases.
Keep uncommitted fundraising out of the base case. Show it as a separate scenario with its assumed date, amount and conditions. Otherwise a hoped-for financing event can conceal the point at which existing cash no longer covers operating commitments.