Accountio / Templates / Startup fundraising / Three-statement model

Three statement model template in Excel for startups

Enter your drivers and monthly costs once and get a profit and loss, balance sheet and cash flow that link and balance for 24 months, with the month your cash runs out. This three statement model template is one Excel workbook where you only fill in the Assumptions sheet and everything else is worked out.

Finance teams
$15
In the pack
Startup fundraising
Files
5, Excel and Word
Buy the pack · $15
US library · 52 packs

Get this pack and 51 more for $79

Startup fundraising · this packBookkeeping and advisory lettersAudit and AUP lettersBook-to-tax reconciliationCompilation and review lettersIndependent contractorsCPA verification letters1040 checklistsIRS notices+ 43 more
$79$69889% off
Buy the US library · $79

Want every pack, for every region? Global library, 110 packs, $99

What the model looks like

Three-statement model template
What the model coversSheet or row in the model
Revenue and margin drivers
✓
AssumptionsRevenue in month 1, monthly growth for year 1 and year 2, and cost of sales as a % of revenue
Working capital and other rates
✓
Customers pay after (days), We pay suppliers after (days)Plus the years equipment is written off over, the loan interest rate and the tax rate
Where you start
✓
Opening balance sheet (the day before month 1)Cash, receivables, equipment, payables, loan, tax and share capital, with retained earnings worked out so it balances
Month-by-month inputs
✓
Monthly inputsStaff, marketing, premises and other costs, equipment bought, new equity, loans and tax paid
Profit and loss
✓
P&LRevenue, gross profit and margin, operating costs, EBITDA, depreciation, interest, tax and profit after tax
Balance sheet
✓
Balance sheetEquipment, receivables, cash, payables, tax payable, loan and equity at each month end
Proof that it balances
✓
Balance checkNet assets less total equity is zero in every month, or the month is flagged
Cash flow
✓
Cash flowCash from operations, equipment, equity and loans, with opening and closing cash
Burn and runway
✓
Monthly burn, Months of cash left at this burnCash out before funding, and how long the cash lasts
The answers investors ask for
✓
SummaryYear 1 and year 2 figures, lowest cash and its month, the first month cash falls below zero and the balance check

When you need a three statement model

A three statement model links the profit and loss, the balance sheet and the cash flow statement, so a change in one assumption flows through all three. Investors expect one in a funding round because it shows how much cash the business needs and when. Use this one when:

  • You are raising a seed or Series A round and need to show how long the money lasts
  • Your forecast is a profit and loss only, with no balance sheet or cash flow behind it
  • You need to know the month cash falls below zero to plan when the next round must close
  • An investor has asked for monthly figures for the next two years

How to use the three statement model template

  1. Fill in the drivers. On the Assumptions sheet, enter the first month of the model, revenue in month 1, monthly growth, cost of sales and payment days. Choose your currency.
  2. Enter the opening balance sheet. Copy the figures from your latest balance sheet. Retained earnings are worked out so the opening position balances.
  3. Add the monthly inputs. Enter costs as positive amounts, then equipment, the month and amount of the equity round, loans drawn or repaid and tax paid.
  4. Check it balances. The Summary shows OK when every month balances. If a month is flagged, look at the inputs for that month.
  5. Read the runway. The first month cash falls below zero tells you how much to raise and by when. Change the round size or costs and see the effect at once.

Questions

What is a three statement model?

A financial model in which the profit and loss, balance sheet and cash flow statement are linked. Profit flows into retained earnings on the balance sheet, and the cash flow explains the change in cash between two balance sheets.

How are the three statements linked?

Profit after tax goes to the balance sheet and starts the cash flow. Depreciation is added back, and changes in receivables, payables and tax payable adjust cash. Closing cash on the cash flow is the cash on the balance sheet.

How do you build a three statement model?

Set the assumptions first, then build the profit and loss, then the balance sheet, then the cash flow from the movements between balance sheets. Finish with a check that assets less liabilities equals equity in every period.

Why doesn't my balance sheet balance?

Usually because a movement is in one statement but not another, such as equipment bought that is not in the cash flow, or a loan drawn that is not on the balance sheet. This workbook flags each month that does not balance.

What is runway?

How many months the business can keep going on the cash it has. The model divides cash at the end of the month by that month's burn, the cash going out before any funding.

Also in the startup fundraising

See the whole pack →

Who it's for

Founders and finance leads at startups preparing a funding round, and the accountants who support them.

Last checked

Checked in November 2026.