Excel · .xlsx, no macros · 11 sheets
Startup 3-Statement Model (5-year)
A five-year model where the P&L, balance sheet and cash flow are linked, built from assumptions you can read on one tab.
- Excel for Microsoft 365 Yes
- Excel for Mac (Microsoft 365) Yes
- Excel for the web Partly
- Excel 2021 Yes
- Full matrix
Dashboard
| Y1 | Y2 | Y3 | Y4 | Y5 | |
|---|---|---|---|---|---|
| Revenue | 0.62 | 1.48 | 2.71 | 3.86 | 4.95 |
| EBITDA | (0.41) | (0.18) | 0.12 | 0.39 | 0.68 |
Blue = inputs you change. Black = formulas.
Data
| Check | Result |
|---|---|
| Balance sheet balances | all 60 months |
| Cash below zero | never |
Assumptions sheet. Seed round €1.2m in month 1.
Read me
- 1Read me: What it is, seven steps to use it, a guide to each tab, the colour code (mint cells are inputs, grey cells are formulas), the limits, the no-advice line, licence and support.
- 2Assumptions: The only tab with inputs. Start month, currency and tax rate; the opening balance sheet; receivable, payable and inventory days; two revenue streams (price, price change, month-one units, growth, cost of goods); salary increase and a 12-row headcount plan; eight overhead lines; eight equipment purchases; three equity rounds; two loans.
- 3Revenue: Units, price, revenue and cost of goods for each of the two streams, month by month.
- 4Headcount: Full-time equivalents per role by month, payroll cost per role with social charges, and payroll by department.
- 5.xlsx, no macros, no circular references, sheets unprotected. 60 monthly columns plus Year 1 to 5 roll-ups. The sample company is a made-up Verdella Home.
Rendered from the template's own layout with made-up numbers for Verdella Home, a company that doesn't exist.
What it answers
- How much money do we need to raise, and when does it run out?
- When do we break even on EBITDA, if these assumptions hold?
- What happens to cash if we hire three people six months earlier?
- Does the balance sheet actually balance?
- Which assumption moves the result most?
- How do I show the board the plan without walking them through 60 columns?
What's in the file
| Sheet | What it does |
|---|---|
| Read me | What it is, seven steps to use it, a guide to each tab, the colour code (mint cells are inputs, grey cells are formulas), the limits, the no-advice line, licence and support. |
| Assumptions | The only tab with inputs. Start month, currency and tax rate; the opening balance sheet; receivable, payable and inventory days; two revenue streams (price, price change, month-one units, growth, cost of goods); salary increase and a 12-row headcount plan; eight overhead lines; eight equipment purchases; three equity rounds; two loans. |
| Revenue | Units, price, revenue and cost of goods for each of the two streams, month by month. |
| Headcount | Full-time equivalents per role by month, payroll cost per role with social charges, and payroll by department. |
| Opex | Payroll by department, plus the non-payroll overhead lines. |
| Capex & funding | Equipment purchases, depreciation, net fixed assets, equity raised and the loan schedules. |
| P&L | Revenue by stream down to net income, monthly for 60 months, with tax carrying losses forward and a Year 1 to 5 roll-up on the right. |
| Balance sheet | An opening column and 60 month-ends, with year-end columns. |
| Cash flow | Indirect method: net income, depreciation and working-capital changes, then capex, equity and loans, to closing cash. Net burn and runway (capped at 36 months). |
| Checks | TRUE or FALSE for each month: the balance sheet balances, balance sheet cash equals cash-flow cash, revenue ties to the revenue build, payroll ties out, and fixed assets and loans aren't negative. Cash below zero and unassigned payroll show as warnings. |
| Summary | A flag that says whether all integrity checks pass, a five-year table (revenue, growth, margins, EBITDA, net income, capex, cash, debt, headcount, equity raised), key points such as the lowest cash and the first month cash goes negative, and four charts. |
| Format | .xlsx, no macros, no circular references, sheets unprotected. 60 monthly columns plus Year 1 to 5 roll-ups. The sample company is a made-up Verdella Home. |
Plugging in your own data
Work through the Assumptions tab top to bottom. Everything else follows.
- 1
Set the start month, currency and tax rate, then the opening balance sheet.
- 2
Describe your revenue: two streams, each a price and month-one units, with growth and cost of goods.
- 3
List your team by role, department, salary and start and end month.
- 4
Add overheads, equipment purchases, equity rounds and loans.
- 5
Read the Checks tab. Every row should say TRUE; the Summary shows one flag for all of them.
- 6
Read the Summary.
- 7
To compare cases, change one input at a time and save a copy of the file for each.
Will it work on your machine?
| App and version | Works? | Notes | |
|---|---|---|---|
| Windows | |||
| Excel for Microsoft 365 | Yes | ||
| Excel 2021 | Yes | ||
| Excel 2019 | Yes | Excel 2019: fine. The formulas stick to SUMIFS, INDEX and MATCH, nothing that needs dynamic arrays. | |
| Excel 2016 | Partly | Excel 2016: should open and calculate. Some chart formatting may look different. | |
| Mac | |||
| Excel for Mac (Microsoft 365) | Yes | Excel for Mac (Microsoft 365): fine. Nothing in the file uses Power Pivot or macros, which is what usually breaks on a Mac. | |
| Browser | |||
| Excel for the web | Partly | Excel for the web: opens, calculates, slicers and drop-downs work. Editing gets slower in the bigger tabs. | |
- 60 columns and three linked statements: comfortable in desktop Excel, slower to edit in Excel for the web.
Built for the versions marked ✓. We check every file before it goes on sale, but we haven't tried every setup. If something doesn't work in yours, tell us and we'll fix it or refund you.
No macros in any file. Nothing asks you to enable content.
What the licence lets you do
| What you can do | Single | Team |
|---|---|---|
| Who can use the file | You, one named person | Up to 10 named people in the same company |
| Use it in your own business or job | Yes | Yes |
| Send the outputs (charts, PDFs, slides) to anyone, clients included | Yes | Yes |
| Edit anything: formulas, colours, layout, logo | Yes | Yes |
| Pass the file itself to someone else | No | Only inside the team of 10 |
| Resell, upload, rebrand or publish it as a template | No | No |
| Price | €99 | €199 |
More than 10 people? Ask us at office@primedigitallabs.com. Both licences are a one-off price. Nothing renews.
Updates and help
- Bug fixes
- Bug fixes are free for as long as we sell this template. Get the newest version any time with your order number on the download page.
- Support
- Questions go to office@primedigitallabs.com. We usually reply within 2 working days.
- What support covers
- Support covers how the template works and anything that's broken. Rebuilding it around a different data structure is custom work, and we're happy to quote for that.
Probably not for you if
- You need a model built on your actual historic accounts for a bank or a due-diligence process. We do that as custom modelling, from €1,500.
- Your revenue is subscriptions with churn and expansion. The SaaS model handles that properly.
- You want IFRS or local GAAP reporting. It's a planning model; statutory accounts are another job.
Goes well with
- Sample data, fictionalSample data, fictionalSample data, fictional
Startup Finance Pack
Also in the Startup Finance Pack: 3 templates for €159 instead of €187.
Bundle · 3 files€159 - Sample data, fictional
SaaS Financial Model (MRR/ARR)
New, expansion and churned MRR, through to cash and runway.
Excel · .xlsx, no macros13 sheetsWin YesMac YesWeb Partly€129 - Sample data, fictional
SaaS Financial Model (MRR/ARR)
New, expansion and churned MRR, through to cash and runway.
Excel · .xlsx, no macros13 sheetsWin YesMac YesWeb Partly€129
Questions people ask about this one
Can I enter historic months?
Not as a separate actuals section. Start the model at the current month and put today's balances in as the opening balance sheet on Assumptions.
Are there scenarios?
There's no scenario switch. Change one input at a time, read the Summary, and save a copy of the file for each case you want to keep.
Does it do French tax?
It applies one corporate tax rate you choose, and carries losses forward against later profits. It doesn't model tax credits such as CIR or local rules. Ask your accountant for those numbers.
Can I add a third revenue stream?
The layout has two streams. A third is a change to the file, and a template tune-up if you'd like us to do it, from €290.
Will investors accept it?
We can't say what any investor will accept. It's a standard three-statement layout that balances; what makes it credible is your assumptions.