Free 3-year startup profit and loss calculator
If you are starting a business and want to understand what revenue growth, cost of goods sold, salaries, marketing and operating costs could mean for future profit, this free Startup P&L Calculator Excel template provides a simple place to start.
The calculator turns a small set of business assumptions into a three-year profit and loss projection. You enter the figures in the clearly marked input cells and the spreadsheet calculates the forecast automatically.
There is no balance sheet, cash-flow statement or complicated financial-modelling setup. This is deliberately a focused, single-purpose free profit and loss forecast template designed to answer one practical question:
If revenue grows at this rate and costs behave this way, what could profit look like over the next three years?
What problem does this free P&L calculator solve?
New businesses often begin with a sales target but no structured view of what happens after the costs of generating those sales are included.
Revenue alone does not show whether a business is profitable.
A business might forecast £150,000 of sales, but the result changes substantially depending on:
- cost of goods sold; - salaries and team costs; - marketing and sales expenditure; - other operating costs; - cost inflation; - revenue growth; - tax assumptions.
The Simple Startup P&L Calculator brings these assumptions into one straightforward Excel spreadsheet so you can see the relationship between revenue, gross profit, operating expenses and projected profit.
What does the Startup P&L Calculator calculate?
The workbook creates a three-year projection using your assumptions for:
- Year 1 revenue; - annual revenue growth; - cost of goods sold as a percentage of revenue; - salaries and team costs; - marketing and sales spend as a percentage of revenue; - other annual operating costs; - annual cost inflation; - tax rate.
From these inputs, the model calculates the three-year revenue and expense projection automatically.
What is included?
- Editable Microsoft Excel workbook - Simple input section - Three-year revenue projection - Cost of goods sold - Gross profit - Salaries and team costs - Marketing and sales costs - Other operating expenses - Total operating expenses - Profit projection - Quick-start PDF guide - Cover image - Free download
Who is this free startup financial projection template for?
This calculator is designed for:
- people planning a new business; - founders creating an initial financial forecast; - small-business owners who want a simple P&L projection; - entrepreneurs testing an early business idea; - users who do not need a full three-statement financial model yet; - anyone looking for a straightforward startup profit and loss template in Excel.
You do not need financial-modelling experience to use the calculator. The workbook identifies the cells intended for user inputs and calculates the forecast from those assumptions.
Startup revenue forecast
The model starts with Year 1 revenue and an annual growth assumption.
This creates projected revenue for Years 2 and 3 without requiring the user to build formulas manually.
For example, if you want to test a business starting with £100,000 of annual revenue and growing by 20% per year, changing those two inputs updates the forecast.
This makes the spreadsheet useful for testing alternative startup revenue scenarios rather than committing to one static set of figures.
Cost of goods sold and gross profit
For businesses with direct costs attached to sales, revenue is not the same as gross profit.
The calculator allows cost of goods sold to be entered as a percentage of revenue.
As projected revenue changes, the associated cost of goods sold changes automatically, allowing the workbook to calculate gross profit.
This can help answer questions such as:
- What happens to profit if gross margin is lower than expected? - How much gross profit is available to cover salaries and overhead? - Does higher revenue actually produce a worthwhile improvement in profit?
Salaries, marketing and operating expenses
The calculator separates several important operating-cost categories.
Salaries and team costs are entered as an annual amount.
Marketing and sales expenditure is modelled as a percentage of revenue, allowing it to grow alongside sales.
Other operating costs can be entered separately, while an annual inflation assumption increases relevant costs in later forecast years.
This provides a clearer picture than simply subtracting one headline expense number from revenue.
Free small business P&L template for scenario planning
A forecast is not a prediction.
Its value comes from testing assumptions.
You can change the input cells to examine different scenarios:
- lower or higher revenue growth; - different gross margins; - additional team costs; - increased marketing expenditure; - higher operating costs; - different inflation assumptions.
The calculated three-year P&L then updates automatically.
That makes this free Excel calculator useful as an early small business profit projection tool as well as a startup planning spreadsheet.
What this free calculator does not include
The Simple Startup P&L Calculator is intentionally narrow.
It does not include:
- a balance sheet; - a cash-flow statement; - working-capital modelling; - debt schedules; - fixed-asset schedules; - detailed funding analysis.
That simplicity is deliberate. If you only need a quick three-year profit-and-loss forecast, you should not have to work through a much larger financial model.
Need a complete business financial model?
If you need the profit and loss statement to connect to a balance sheet and cash-flow forecast, the next step is the Integrated 3-Statement Business Plan Model.
That paid model provides a five-year linked income statement, balance sheet and cash-flow model together with debt, fixed assets, ratios and funding analysis.
The free Startup P&L Calculator is therefore useful for an initial profitability forecast; the Integrated 3-Statement model is designed for users who need a more complete business-planning model.
Download the free Startup P&L Calculator
The Simple Startup P&L Calculator is a free Excel download from James Edison Business Solutions.
Use it to enter your own revenue and cost assumptions and create a three-year startup profit-and-loss projection without building the spreadsheet from scratch.
Download the Free Startup P&L Calculator →
Important
This calculator is a financial planning and modelling template. It is not financial, investment, accounting, tax or legal advice. Results depend entirely on the assumptions entered. Verify your figures and obtain appropriate professional advice where required.