Skip to content

Startup financial model, 3 years

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

Startup financial model, 3 years template, first page

Fill it in and preview

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 nerixA 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 All free Excel and spreadsheet templates

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 startoptional

    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 monthoptional

    For example: 9000

  • Salary increase each year (%)optional

    For example: 5

  • Rent and tools per monthoptional

    For example: 1800

  • Marketing (% of revenue)optional

    For example: 12

Finance and accounting

What is inside

The parts of this document, in order.

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

Templates

How it works

  1. 01

    Open

    Open the spreadsheet in nerix and fill in the short form. Your answers go straight into its cells.

  2. 02

    Change

    Every figure is a live formula. Change any cell and the totals, differences and charts work themselves out.

  3. 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

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.