# Startup Financial Model Template, Free

Source: https://nerix.ai/templates/startup-financial-model

A 36 month forecast of customers, revenue, costs, profit and cash from a few assumptions.

Before you send it

A model is only as good as its assumptions. These are your guesses, not predictions, and the sheet ignores tax, loans, investment and seasonality. Test the numbers with real data and an accountant before you rely on them.

## Fill it in and preview

You are signed in. Fill it in your workspace and it is kept as a document you can send, share and have signed. [Open in your workspace](https://app.nerix.ai/documents/templates/startup-financial-model)

### Startup financial model, 3 years

A simple three year model for a subscription style startup. Enter your price, how many customers you start with and add, how fast the monthly intake grows, how many customers you lose, and your costs. The Model sheet works out 36 months of customers, revenue, cost of goods, salaries, other costs, profit before tax and cash. The Summary sheet gives each year's totals, the lowest cash balance, the first month cash would run out and a chart of cash. Download it as Excel, OpenDocument, PDF or CSV.

## Inputs

Startup financial model, 3 years

Change the yellow assumptions. The Model sheet works out 36 months and the Summary sheet shows each year and your cash.

**Company** Lumen Meal Kits

**First month** 2027-01-01

**Cash at the start** 120,000.00

**Price per customer per month** 29.00

**Customers at the start** 0

**New customers in the first month** 40

**Growth of new customers each month (%)** 6

**Customers lost each month (%)** 4

**Cost of goods (% of revenue)** 45

**Salaries per month** 9,000.00

**Salary increase each year (%)** 5

**Rent and tools per month** 1,800.00

**Marketing (% of revenue)** 12

## Model

Monthly model

Every cell is worked out from the Inputs sheet. Do not type here.

| Month number | Month | Customers at month end | New customers | Customers lost | Revenue | Cost of goods |

| 1 | 2027-01-01 | 40 | 40.0 | 0.0 | 1,160 | 522 |

| 2 | 2027-02-01 | 81 | 42.4 | 1.6 | 2,343 | 1,054 |

| 3 | 2027-03-01 | 123 | 44.9 | 3.2 | 3,553 | 1,599 |

| 4 | 2027-04-01 | 165 | 47.6 | 4.9 | 4,792 | 2,157 |

| 5 | 2027-05-01 | 209 | 50.5 | 6.6 | 6,065 | 2,729 |

| 6 | 2027-06-01 | 254 | 53.5 | 8.4 | 7,375 | 3,319 |

| 7 | 2027-07-01 | 301 | 56.7 | 10.2 | 8,725 | 3,926 |

| 8 | 2027-08-01 | 349 | 60.1 | 12.0 | 10,121 | 4,554 |

| 9 | 2027-09-01 | 399 | 63.8 | 14.0 | 11,565 | 5,204 |

| 10 | 2027-10-01 | 450 | 67.6 | 16.0 | 13,062 | 5,878 |

| 11 | 2027-11-01 | 504 | 71.6 | 18.0 | 14,617 | 6,578 |

| 12 | 2027-12-01 | 560 | 75.9 | 20.2 | 16,234 | 7,305 |

| 13 | 2028-01-01 | 618 | 80.5 | 22.4 | 17,919 | 8,063 |

| 14 | 2028-02-01 | 678 | 85.3 | 24.7 | 19,676 | 8,854 |

| 15 | 2028-03-01 | 742 | 90.4 | 27.1 | 21,512 | 9,680 |

| 16 | 2028-04-01 | 808 | 95.9 | 29.7 | 23,431 | 10,544 |

| 17 | 2028-05-01 | 877 | 101.6 | 32.3 | 25,441 | 11,448 |

| 18 | 2028-06-01 | 950 | 107.7 | 35.1 | 27,547 | 12,396 |

| 19 | 2028-07-01 | 1,026 | 114.2 | 38.0 | 29,756 | 13,390 |

| 20 | 2028-08-01 | 1,106 | 121.0 | 41.0 | 32,076 | 14,434 |

## Summary

Summary by year

| Item | Year 1 | Year 2 | Year 3 | | Words shown |

| Revenue | 99,611 | 351,332 | 799,404 | | **None** |

| Cost of goods | 44,825 | 158,099 | 359,732 | | |

| Gross profit | 54,786 | 193,233 | 439,672 | | |

| Salaries | 108,000 | 113,400 | 119,070 | | |

| Rent, tools and marketing | 33,553 | 63,760 | 117,529 | | |

| Profit before tax | -86,767 | 16,073 | 203,074 | | |

| Customers at year end | 560 | 1,469 | 3,167 | | |

| Cash at year end | 33,233 | 49,306 | 252,379 | | |

| Lowest cash during the year | 33,233 | 23,414 | 57,193 | | |

| Months with a profit | 0 | 7 | 12 | | |

| First month with negative cash | None | | | | |

| Gross margin in year 3 | 55.0% | | | | |

[Open this spreadsheet in nerix](https://app.nerix.ai/documents/templates/startup-financial-model) A preview of the first rows with sample figures. Open it in nerix to fill in your own and change any cell.

Templates are a careful starting point, not legal advice. Where the law matters, check what applies where you are.

Finance and accounting

## What this template is for

A startup financial model template in Excel: set price, growth, churn and costs, and get a 36 month forecast of revenue, profit and cash with a yearly summary.

It is free to fill in online, needs no account, and downloads as a Word document or a PDF. [See all Finance and accounting templates](https://nerix.ai/templates/finance-accounting) [All free Excel and spreadsheet templates](https://nerix.ai/templates/spreadsheets)

Finance and accounting

## What you fill in

The form asks for 13 details. The document fills itself in as you type.

- ### Company For example: Lumen Meal Kits
- ### First month The first day of the month the forecast starts. For example: 2027-01-01
- ### Cash at the start For example: 120000
- ### Price per customer per month For example: 29
- ### Customers at the start optional For example: 0
- ### New customers in the first month For example: 40
- ### Growth of new customers each month (%) optional How much the number of new customers grows each month. For example: 6
- ### Customers lost each month (%) optional For example: 4
- ### Cost of goods (% of revenue) optional For example: 45
- ### Salaries per month optional For example: 9000
- ### Salary increase each year (%) optional For example: 5
- ### Rent and tools per month optional For example: 1800
- ### Marketing (% of revenue) optional For example: 12

Finance and accounting

## What is inside

The parts of this document, in order.

- 1 A simple three year model for a subscription style startup. Enter your price, how many customers you start with and a...

Templates

## How it works

- 01 ### Open Open the spreadsheet in nerix and fill in the short form. Your answers go straight into its cells.
- 02 ### Change Every figure is a live formula. Change any cell and the totals, differences and charts work themselves out.
- 03 ### Download Save it as an Excel file, an OpenDocument sheet, a PDF or CSV.

### Make it yours with AI

Open it in the chat and ask for changes: shorter, firmer, another situation, another language.

[Adapt it with nerix](https://nerix.ai/try?template=startup-financial-model)

### Was this template helpful?

Finance and accounting

## Questions people ask

### What details does this template ask for?

The form asks for 13 details, starting with Company, First month, Cash at the start, Price per customer per month, New customers in the first month. 8 more are optional.

### Can I download this template as Word or PDF?

Yes. Open it in nerix and the finished spreadsheet downloads as Excel, OpenDocument, PDF or CSV. It is free and the page only shows sample figures.

### Is what I type sent anywhere?

No. What you type stays in your browser while you fill in the document. It only goes to nerix if you choose to open the template in the chat.

### What should I check before I use this template?

A model is only as good as its assumptions. These are your guesses, not predictions, and the sheet ignores tax, loans, investment and seasonality. Test the numbers with real data and an accountant before you rely on them.

### Are these finance templates free?

Most are. Fill in and download them for free as Word or PDF, with no account. A few longer documents are premium: free to fill in, paid once to download, and marked with their price.

### Do these templates include tax rules?

No. Tax and invoicing rules differ by country. Each template has fields for amounts and references, and you add the tax details your local rules require.

### Can I use them with my accounting software?

Yes. They are plain documents. Download the Word version, or copy the figures into your software.

Templates

## More in Finance and accounting

- [Account reconciliation sign-off Show that a ledger balance matches the bank or statement, with the differences explained and signed off. Finance and accounting](https://nerix.ai/templates/account-reconciliation-sign-off)
- [Bad debt write-off memo Record and approve writing off a debt that cannot be collected, with the steps already tried. Finance and accounting](https://nerix.ai/templates/bad-debt-write-off-memo)
- [Balance sheet Show what a business owns and owes on one date, with totals and a check that both sides match. Finance and accounting](https://nerix.ai/templates/balance-sheet)
- [New Break even analysis Find how many units you must sell to cover your costs, with a chart of sales against costs. Finance and accounting Spreadsheet](https://nerix.ai/templates/break-even-analysis)
- [Budget Plan income and costs for a period in tables that add up by themselves, with risks and approval. Finance and accounting](https://nerix.ai/templates/budget)
- [Budget variance report Compare budget with actual results, explain the gaps and say what you will do about them. Finance and accounting](https://nerix.ai/templates/budget-variance-report)

[See all Finance and accounting templates](https://nerix.ai/templates/finance-accounting)

Templates

## More kinds of documents

Every category has its own page, so you can see all of its templates at once.

## Use it in nerix

### Use it in nerix

- [Templates](https://nerix.ai/product/templates)
- [Money](https://nerix.ai/product/money)
- [The Sheet](https://nerix.ai/product/sheet)

### Learn more

- [How to Make a Document From a Template](https://nerix.ai/help/make-a-document-from-a-template)
- [Finance and accounting](https://nerix.ai/templates/finance-accounting)
