Finance template
Startup financial model
A three year quarterly model for a subscription startup: customers, revenue, hiring plan, operating costs and cash. Change the assumptions and every quarter recalculates.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
3 sheets
- Summary
- Assumptions
- Model
278 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 405 filled cells in all.
Built in
- Charts
- Conditional formatting
- Named ranges
- Dynamic arrays
- Frozen headers
- 2 charts
A look at the Summary sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Startup financial model | |||||||
| 2 | Orbitwell Labs, three year plan by quarter. Edit the Assumptions sheet. | |||||||
| 3 | ||||||||
| 4 | YEAR 3 REVENUE | YEAR 3 EBITDA | LOWEST CASH | FIRST PROFITABLE QUARTER | ||||
| 5 | $3,892,359 | $853,627 | $1,251,735 | Y2 Q4 | ||||
| 6 | ||||||||
| 7 | ||||||||
| 8 | Year | Revenue | Gross profit | Operating costs | EBITDA | Customers | Headcount | Cash at end |
| 9 | Year 1 | $571,662 | $468,763 | $989,718 | -$520,955 | 248 | 6 | $1,479,045 |
| 10 | Year 2 | $1,771,053 | $1,452,263 | $1,665,136 | -$212,872 | 584 | 9 | $1,266,173 |
| 11 | Year 3 | $3,892,359 | $3,191,734 | $2,338,107 | $853,627 | 1,148 | 12 | $2,119,799 |
| 12 | ||||||||
- financial model
- startup
- saas
- forecast
- runway
More finance templates
FinancePersonal monthly budgetPlan income and spending for the month and see what is left at a glance. Compare planned and actual amounts by category with a chart.
FinanceInvoice trackerTrack every invoice you send, what has been paid and what is overdue today. An aging summary groups open balances by how late they are.
FinanceBreak-even analysisFind how many units you need to sell to cover fixed costs, and what it takes to hit a profit goal. A chart shows revenue crossing total cost.
FinanceCap tableModel ownership through seed and Series A rounds with share prices worked out from each pre-money valuation. See fully diluted ownership and a simple payout at an exit value.
Start your startup financial model now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.