Financial model and numbers

How to build a financial model investors trust

Short answer

Investors trust a model when revenue is built from drivers such as customers, price and retention; every input sits on one assumptions sheet; the three statements tie together; and the assumptions match your history. They test three or four assumptions, not the totals, so know which ones your forecast depends on.

Work it out with a free toolFinancial model template24-month Excel model for SaaS, D2C and marketplacesOpen the tool

Seven rules

  1. Build revenue from drivers. New customers, churn, price, order frequency. Never a typed-in growth percentage on last month's revenue with nothing behind it.
  2. One assumptions sheet. Every input in one place, clearly marked. No numbers hidden inside formulas.
  3. Tie costs to activity. Hiring to a headcount plan, marketing to customers acquired, servers to usage.
  4. Link the three statements. Profit and loss, cash flow and balance sheet, with a check row that reads zero.
  5. Start from actuals. The first forecast month should follow naturally from the last real month.
  6. Include scenarios. Base, downside and upside, switched from one cell.
  7. Keep it readable. Monthly columns, clear labels, no macros, no colour codes that need a legend.

What investors actually do with it

They open the assumptions sheet first. They find the growth rate, the churn rate, the acquisition cost and the hiring plan. They change one and watch what happens to cash. Then they ask you why your number is what it is.

So the real work is not the spreadsheet. It is being able to say: "Churn is 2.5% a month because that is the average of our last nine cohorts; here they are."

The assumptions that matter

Assumption Evidence to have ready
New customers a month Pipeline, channel tests, sales capacity
Retention or repeat Cohort table
Price Signed contracts, price tests
Acquisition cost Spend ÷ customers, by channel
Hiring pace Roles, salaries, start months
Gross margin Supplier quotes, hosting bills

Signs of a weak model

  • Revenue grows faster every year with no change in sales capacity
  • Costs grow more slowly than revenue for no stated reason
  • Cash never falls below the opening balance
  • The balance sheet is missing
  • The deck's numbers do not match

Getting started

Download the free template, or use Model Builder for a 36-month, three-statement version. If you would rather have it built around your business, see the financial model service.

Quick answers

How many years should the model cover?

Three years by month is standard at seed. Add a five-year annual summary only if investors ask.

Should I build it in Excel or Google Sheets?

Either. Excel is what most investors and advisers open; Sheets is easier to share. Avoid tools that lock the formulas.

How optimistic can the projections be?

Ambitious but explainable. Every growth rate should trace to something you have observed or a named comparable.

See where your deck stands before an investor does

Deck Score checks your PDF in your own browser and tells you what to fix first. It is free and nothing is uploaded.