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 numbers 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, churn, gross margin and the hiring plan are inputs. CAC comes from your spend and new customer counts, and payback, burn multiple and runway are outputs, so an investor tests those four by tracing them back to the inputs.

1. 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.
2. 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.
3. 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.
4. 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.
5. 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.
6. 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.
7. 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.
8. 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
• Runway after the hires = 600,000 / 148,000 ≈ 4.1 months

That second line matters. Hiring before the round closes cuts the time left to raise from 6 months to about 4.

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

• Raise = (New monthly burn × Target runway in months) − Cash at close
• If the round closed today: (148,000 × 18) − 600,000 = 2,664,000 − 600,000 = $2,064,000

Rounds rarely close today. If it takes 4 months, the company burns 4 × 148,000 = 592,000 while raising, so cash at close is only 8,000:

• Raise if it closes in month 4 = 2,664,000 − 8,000 = $2,656,000

Subtracting today's cash instead of cash at close understates the raise by almost $600,000 here. Use the cash balance you expect on the day the money lands.

Look at that $8,000 again. At $148,000 a month it is under two days of cash, so a round that slips one week puts this company out of money. Holding the hires until the round closes changes both numbers. Burn stays at 100,000 while raising, so cash at close is 600,000 − 400,000 = 200,000, which is two months of cushion:

• Raise if the hires wait for the close = 2,664,000 − 200,000 = $2,464,000

That is $192,000 less to raise, exactly the four months of hiring cost you did not spend early. The tradeoff is real, because those hires may be what makes the round possible. Run both versions before you pick one.

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, closing today = 2,064,000 × 1.15 ≈ $2,373,600
• Raise with buffer, closing in month 4 = 2,656,000 × 1.15 ≈ $3,054,400

So the founder should be raising roughly $2.4M to $3.1M depending on how long the round takes, 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. This version holds burn flat at 148,000, which is conservative if revenue grows. When the model has burn changing month to month, size the raise on the lowest cash point, not on an average.

For the burn multiple check on this same business: say the $48,000 a month in new hires is expected to drive $1,200,000 in net new annualized recurring revenue over the following year. That is $100,000 of new monthly revenue by month 12.

The quick version holds burn at 148,000 for all 12 months, so net burn is 148,000 × 12 = $1,776,000:

• Quick burn multiple = 1,776,000 / 1,200,000 ≈ 1.48

That overstates it, because the new revenue reduces burn as it arrives. If new monthly revenue ramps evenly from $8,333 in month 1 to $100,000 in month 12, it adds up to $650,000 over the year. Subtracting all of it gives net burn of 1,776,000 − 650,000 = $1,126,000:

• Burn multiple with no cost to serve = 1,126,000 / 1,200,000 ≈ 0.94

That one is too kind, because new customers cost money to serve. Only the gross profit on that revenue reduces burn. At an illustrative 80% gross margin, the new revenue offsets 650,000 × 0.80 = $520,000, so net burn is 1,776,000 − 520,000 = $1,256,000:

• Burn multiple = Net burn / Net new ARR = 1,256,000 / 1,200,000 ≈ 1.05

Same business, same plan, and the answer runs from 1.48 to 0.94 depending on what you subtract. The honest figure sits at 1.05. Below 1 is strong, around 1.5 is reasonable for an early-stage company still building its go-to-market motion, and above 2 to 3 invites questions about whether growth spend is actually working. So this plan is close to strong and not past it, and an investor who sees 0.94 will ask where the cost to serve went.

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 with the three statements already linked, see a finished startup financial model template. One thing to change when you use it: its Unit Economics tab counts the marketing budget only in CAC, so add sales and marketing payroll yourself to get the fully loaded number this guide describes. For a quick runway and raise-size check without opening a full model, try the free runway calculator.

This guide was written with AI assistance. Every figure was re-checked by recalculation.

For education and planning only, not financial advice.