Startup Financial Model: How to Build One in 7 Steps, With an Example
A startup financial model is one spreadsheet that turns your assumptions about price and costs into a monthly forecast of revenue and runway, linked into the three financial statements. You build it in seven steps: set the question and horizon, lay out the sheets, forecast revenue from drivers, estimate costs, plan cash, link the statements, run scenarios. Every input is either a measured figure with its source or a marked assumption.
What a startup financial model is, and what it is not
A budget caps what each team may spend this year. A forecast states expected revenue and costs. A model shows what happens to cash when one input changes, because every number flows from a driver.
A business plan tells the story; the model holds its numbers. Build the model first, then write the business plan around it.
The model decides whether the business pays at this price after the cost of winning each customer, how long the cash lasts if launch slips a quarter, and how much to raise by when.
What goes into the model
Every model has four layers, left to right: inputs you type, assumptions applied to them, calculations that are formulas only, and outputs. A typed number in a calculation cell breaks the chain.
The outputs are three statements:
- The income statement goes from revenue to profit; income tax expense is its own line after income before taxes1.
- The cash flow statement separates operating cash from investing and financing cash.
- The balance sheet holds what you own and owe.
Net income flows to retained earnings and to the top of the cash flow statement; ending cash becomes cash on the balance sheet. Those two links make one model.
Where each input comes from
- Your own data: paying customers, prices, invoices. Leave paused and delinquent accounts out of revenue.
- Customer conversations: what people pay and how often.
- Market sizing and competitor analysis: the ceiling and going prices.
- Peer benchmarks, each with its source and year.
Each input cell’s note names its source, or says «assumption».
How to build a startup financial model in 7 steps
1. Set the question and the horizon
Put the decision the model answers, like whether to raise now, atop the input sheet. Investors in early-stage startups expect monthly projections for the first 12 months and annual projections for the next three to five years2.
2. Lay out the sheets
One input sheet, and every other cell is a formula:
| sheet | what it holds | what it feeds |
|---|---|---|
| Inputs | Prices, volumes, rates, dates, each sourced or «assumption» | Every sheet |
| Revenue | Units × volume × price by month | Cash, Statements |
| Costs and headcount | Cost per unit, hires, operating lines | Cash, Statements |
| Cash | Opening balance, receipts, payments, financing | Statements, runway |
| Statements | Income, cash flow, balance sheet | Investor view |
| Scenarios | Base, downside, upside lever values | Inputs, by one switch |
Months go in the same columns on every sheet, with an actuals column beside each forecast month.
3. Forecast revenue from drivers, then check it top-down
Build revenue bottom-up: products, the unit each is sold in, volume per month, price. Volume comes from a driver chain, such as leads × conversion rate × purchases per customer.
Then check it top-down. Size the market: TAM is the whole market, SAM the part you serve, SOM the share you can win within the horizon. The market size calculator does the arithmetic. If revenue needs more of SOM than your channels explain, cut the volume.
4. Estimate costs from drivers
Tie each cost line to a driver:
| cost line | class | driver |
|---|---|---|
| Wood, fuel, delivery | Direct: cost of goods | Cords delivered |
| Sales hire | Indirect, labor | Revenue it must carry |
| Rent, software | Indirect, non-labor | Month |
List hires by start month and load each salary with payroll taxes and benefits at a rate marked «assumption». Track revenue per employee.
Budget for costs not yet paid: future hires and income tax. Startup costs are deductible up to $5,000 in the first year, less any amount over $50,000; the rest amortizes over 180 months3.
5. Plan cash and runway
Build a 12-month cash budget: categories in rows, months in columns, from the opening balance. Customer prepayments land before delivery; under ASC 606 a prepayment received before delivery is a contract liability, deferred revenue, until the goods are delivered4. Each monthly equipment loan payment splits into interest and principal. Runway in months equals cash on hand divided by monthly net burn5.
6. Link the three statements
Wire the two links from the section above; the balance sheet must balance every month. Under US GAAP (ASC 230), interest paid is an operating cash outflow, while IFRS (IAS 7) allows operating or financing6.
Financed equipment goes on the balance sheet and is depreciated. Public Law 119-21 restored 100% bonus depreciation for qualified property acquired after January 19, 20257. Working capital equals current assets minus current liabilities8, so prepayments raise current liabilities until you deliver.
7. Run scenarios and sanity checks
Change one lever at a time: hiring plan, raise timing, sales ramp, price, gross margin. Keep the scenarios as value sets on one sheet, never as copies of the file.
In our example, a downside case cuts margin to 0.20:
| case | margin | LTV | LTV/CAC | payback |
|---|---|---|---|---|
| Base, example by our method | 0.35ex | $187.11ex | 6.24ex | 1.9 monthsex |
| Downside, assumption | 0.20 | $106.92 | 3.56 | 3.4 months |
Check that cash never drops below zero without a funding line.
Worked example: firewood delivery in Burlington, Vermont
The example by our method is a system idea check of October 15, 2026: «Seasonal firewood cutting and delivery in suburban Burlington, Vermont: log processor on equipment financing, homeowners prepaying cords for fall and winter delivery»ex.
The top-down side: in the example, demand has no measured sourceex, so it stays an assumption until you test demand. The example’s TAM is $90 millionex, from a Vermont state source. It counts 7ex direct competitors; the most visible holds 33%ex of search visibility, the next 24%ex.
The bottom-up side, in the example: price $44.55ex, 1 purchase a monthex, margin 0.35ex, lifetime 12 monthsex, CAC $30ex. Monthly contribution is 44.55 × 1 × 0.35 = $15.59, so LTV in the example is $15.59 × 12 = $187.11ex, LTV/CAC 6.24ex and payback 1.9 monthsex.
The check flags its weak spot: these unit figures are estimated from a different category, so margins may be lowerex. They describe a customer-month, and a cord has its own price. Vermont requires firewood to be sold by the cord, 128 cubic feet stacked9, so your first edit is a measured per-cord quote, with margin rebuilt from what a cord costs you to deliver.
Prepaid cords enter cash when paid and sit as deferred revenue until delivery: a homeowner prepaying six months (an assumption) at $44.55ex adds $267.30 to cash and deferred revenue, which falls $44.55 per delivery. For a fully financed $60,000 processor (an assumption), each payment splits into interest and principal; seven-year straight-line depreciation (an assumption) is $714 monthly.
Run these inputs in the unit economics calculator.
How we calculate unit economics
Our idea check uses four formulas, which the example reproduces:
- monthly contribution = price × purchases a month × margin
- LTV = monthly contribution × lifetime in months
- LTV/CAC = LTV ÷ CAC
- payback in months = CAC ÷ monthly contribution
| variable | means | comes from |
|---|---|---|
| Price | Revenue per purchase | Price list or quote |
| Purchases a month | How often a customer buys | Orders, interviews |
| Margin | Share left after direct costs | Invoices, unit cost |
| CAC | Cost to win a paying customer | Spend ÷ new customers |
| Lifetime | Months a customer keeps buying | Cohorts or assumption |
The rules:
- The weakest input sets the confidence; replace an input borrowed from another category first.
- Our LTV/CAC reading: 3 or more holds, 1 to 3 is thin, under 1 loses money on every customer. As a market reference, 3:1 is the commonly cited benchmark for venture-backed startups10.
What investors check, and the mistakes that sink a model
Before a pitch, check your model for:
- monthly detail for the first year, annual after it;
- runway at the current burn, and the month the raise must close;
- burn that falls as revenue grows;
- the gross margin trend;
- LTV/CAC and payback, each input sourced;
- a ramp that fits your stage.
Five mistakes sink a model: a generic template that ignores your drivers; typed numbers in calculation cells; revenue with no driver chain; no actuals column; unpaid future costs left out.
Next step
Check your idea for free for measured unit inputs, then build the concept with the research behind it.
FAQ
Is there a startup financial model template I can start from?
Step 2’s table is the template: create one tab per row, Inputs first; every other cell is a formula.
How many years should a startup financial model cover?
Monthly for the first 12 months and annual for the next three to five years, as early-stage investors expect2.
Do I need a financial model before I have revenue?
Yes. It shows the price and CAC the idea needs, plus the cash. A free idea check gives you measured inputs.
How often should I update the model?
Monthly: replace the forecast with actuals when the month closes. Review the assumptions before every raise.
Sources
- sec.gov, 09/24/2026
- startup-movers.com, 10/09/2026
- uscode.house.gov, 10/17/2026
- dart.deloitte.com, 10/02/2026
- startups.com, 05/25/2026
- rsmus.com, 08/16/2026
- irs.gov, 10/02/2026
- accountingtools.com, 04/12/2026
- agriculture.vermont.gov, 10/10/2026
- stealthagents.com, 06/19/2026
Check your idea for free
Describe your idea and the check collects demand, competitors, complaints and prices, with sources.
