Startup Financial Model Template: What Investors Expect

Most first-time founder models get the format right and the substance wrong. The tabs look correct, income statement, balance sheet, cash flow, but the numbers underneath are typed in rather than driven by assumptions, and the balance sheet does not actually balance. Investors notice within the first two minutes of opening the file. This guide covers how to build a model that holds up, and the specific things a diligence-minded investor checks before they check anything else.

Driver-based vs. top-down

A top-down model starts from a market size and assumes a share of it: "the market is $10B, if we capture 1% that's $100M." It is fast to build and tells an investor almost nothing about how the business actually works.

A driver-based model starts from the mechanics of the business: how many leads you generate, what fraction convert, what they pay, how long they stay, what it costs to serve them, and how many people you need to hire to support that growth. Revenue and costs are formulas built from those drivers, not typed-in targets.

The test is simple: if you change one assumption cell, for example the sales conversion rate, does the effect ripple correctly through pipeline, revenue, cost of goods sold, headcount, and cash. In a driver-based model it does. In a top-down model, nothing moves, because nothing was ever connected.

The three statements, and why the balance sheet must balance

A complete model has three linked statements:

The income statement, which shows whether the business is profitable on paper.
The cash flow statement, which shows what actually happened to cash, including timing effects that the income statement ignores.
The balance sheet, which shows what the company owns and owes at a point in time.

The balance sheet has to balance: Assets = Liabilities + Equity, every month, every year, with no plug. If it does not balance, something in the model is broken, usually a cash flow item that is not flowing back into the cash balance, or a change in a balance sheet account that never hit the cash flow statement. Investors who know how to build models will check this first, often by scrolling straight to the balance sheet tab and looking at whether assets minus liabilities minus equity nets to zero in every column. A model that fails this test does not get a second look, regardless of how good the story is.

The 8 assumptions investors pull on

These are the cells an experienced investor clicks into first, because they reveal whether the founder understands their own unit economics or is telling a story on top of round numbers.

Growth rate. Month-over-month or year-over-year, and whether it is consistent with what similar companies actually achieved at the same stage, not an aspirational curve that bends upward for no operational reason.
Churn. Monthly logo churn and revenue churn, separately. A model with 2% monthly churn typed in but no explanation of how that compares to the company's actual cohort data is a red flag.
CAC (customer acquisition cost). Fully loaded, including sales and marketing salaries, not just ad spend. A model that only counts ad spend in CAC is undercounting it, often by half or more.
CAC payback period. How many months of gross profit from a customer it takes to recover the cost of acquiring them. Investors read this as a proxy for capital efficiency.
Gross margin. The percentage of revenue left after the direct cost of delivering the product, and whether it is trending toward a defensible long-run number for the business model, not held flat at an optimistic figure indefinitely.
Hiring plan. Headcount by function and month, each with a fully loaded cost (salary, payroll tax, benefits, roughly 1.25 to 1.3x base salary). This is usually the largest cost line and the one most often modeled with a single "average salary" number instead of role-by-role detail.
Burn multiple. Net burn divided by net new annualized recurring revenue over the same period. It answers: how much cash does it take to generate a dollar of new recurring revenue.
Runway. Months of cash remaining at the current or projected burn rate, and whether it is calculated against a burn rate that changes over time (it almost always does) rather than a single static number.

A worked runway and raise-sizing example

Say the company has $600,000 in the bank. Current monthly revenue is $40,000 and current monthly operating expense is $140,000, for a net monthly burn of $100,000.

Runway today = Cash / Monthly burn = 600,000 / 100,000 = 6 months

The company plans to hire four people at a fully loaded cost of $12,000 per month each, adding $48,000 a month in new operating expense starting immediately.

New monthly burn = 100,000 + 48,000 = $148,000

The target is 18 months of runway after the raise closes. The raise amount needed:

Raise = (New monthly burn × Target runway in months) − Cash on hand
Raise = (148,000 × 18) − 600,000 = 2,664,000 − 600,000 = $2,064,000

Add a buffer for one-time costs (legal fees, a security deposit on new office space, a slower-than-planned ramp in revenue), typically 10% to 15%:

Raise with buffer = 2,064,000 × 1.15 ≈ $2,373,600

So the founder should be raising roughly $2.1M to $2.4M, not a round number pulled from what a peer company raised. That is the difference between a raise size that is defensible in a partner meeting and one that is not.

For the burn multiple check on this same business: if the $48,000 in new hires is expected to drive $1,200,000 in net new annualized recurring revenue over the following year, and annualized net burn is 148,000 × 12 = $1,776,000:

Burn multiple = Net burn / Net new ARR = 1,776,000 / 1,200,000 ≈ 1.5

A burn multiple near 1.5 is reasonable for an early-stage company still building its go-to-market motion; below 1 is strong, and above 2 to 3 invites questions about whether growth spend is actually working.

Common mistakes

Typing in revenue instead of deriving it from leads, conversion rate, and average deal size, or from signups, activation rate, and pricing.
Flat gross margin forever, with no modeling of how margin improves (or does not) as the business scales.
A hiring plan with no start dates, so every new hire's cost hits the model on day one of the year instead of the month they actually start.
A balance sheet that does not balance, usually because retained earnings is not correctly rolling forward net income, or a cash flow line item was never linked back to its balance sheet account.
CAC that excludes salaries, which understates the true cost of growth and makes the payback period look better than it is.
No sensitivity or downside case, so the only version of the future in the model is the one where everything goes right.
Circular references left unresolved, commonly from a revolving credit line or cash-interest calculation, that make the file recalculate unpredictably or crash when opened on someone else's machine.

Checklist

Before sending a model to an investor, confirm:

Revenue and costs are formulas driven by assumptions, not typed-in numbers.
The balance sheet balances in every period, with no plug.
All three statements are linked, so a change in one flows through the others.
Growth, churn, CAC, payback, and gross margin are each in their own labeled assumption cell, with an inline note on the source (actual data vs. estimate).
The hiring plan has a start month for every role and a fully loaded cost, not a base salary alone.
Burn multiple and runway are calculated as formulas, not typed in, so they update automatically as assumptions change.
There is a base case, an upside case, and a downside case, not just one scenario.
The file opens cleanly with no broken links, no broken cell references, and no unresolved circular references.

If you want a starting point that already has these links built correctly, see a finished startup financial model template. For a quick runway and raise-size check without opening a full model, try the free runway calculator.