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 teamsGet this pack and 51 more for $79
Want every pack, for every region? Global library, 110 packs, $99
What the model looks like

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
- 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.
- Enter the opening balance sheet. Copy the figures from your latest balance sheet. Retained earnings are worked out so the opening position balances.
- 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.
- Check it balances. The Summary shows OK when every month balances. If a month is flagged, look at the inputs for that month.
- 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
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.
