This 5-year financial model template in Excel brings your profit and loss, balance sheet and cash flow together in one connected forecast. You enter your assumptions on the Drivers sheet, covering revenue, costs, working capital, capital spending, borrowing and dividends. The workbook then calculates the five-year projections and checks that the balance sheet balances.
The model is driven from a single Drivers sheet, where you set revenue growth by stream, cost-of-sales percentages, overhead growth, capital spending, depreciation, working-capital days, borrowing and dividend policy. The other sheets calculate from these assumptions, allowing you to see how they flow through the five-year forecast.
Start by entering the opening balance sheet using your current financial position. The model calculates retained earnings as the balancing figure, so the opening assets, liabilities and equity are consistent before the forecast begins. The Balance Sheet sheet also includes an integrity check confirming that total assets equal total liabilities and equity, both at the start and at each of the five year-ends.
The Summary sheet brings the main results together on one screen, including revenue, margins, free cash flow, the lowest year-end cash balance and cumulative cash. It also calculates the NPV of free cash flows using your selected discount rate. These figures are based entirely on your assumptions and are intended for financial analysis, not as a business valuation.
What you get
- 5-year P&L, balance sheet and cash flow, fully linked
- Single Drivers sheet holding every assumption
- Reducing-balance depreciation that never goes negative
- Debt schedule that never repays more than is owed
- Working capital on DSO, DIO and DPO
- Balance-sheet integrity check in plain English
- NPV and IRR on free cash flow, clearly labelled as arithmetic
- Revenue, EBITDA and cash chart
- Configurable currency — no currency is hard-coded
- No country’s tax rates or statutory rules built in
- Sheets protected without a password
- No macros, no add-ins, no internet connection required
Who it is for
Founders raising money, finance managers building a plan, and advisers who need a working three-statement model without building one from scratch.
In the download
- Excel workbook, fully formula-driven
- README with the full usage guide
- License covering commercial and client use
- Worked sample data throughout, clearly labelled
Sheets in the workbook
-
- Instructions: How to use the file, colour key, assumptions and limitations.
- Setup: Set the currency, first forecast year, tax rate and discount rate.
- Drivers: Enter the operating assumptions that drive the financial model, including revenue growth, costs, capital spending, depreciation, working capital, borrowing and dividends.
- P&L: Five-year profit and loss.
- Balance Sheet: The opening position and five year ends.
- Cash Flow: Operating, investing and financing cash, and the cash balance.
- Summary: The headline numbers on one screen, with NPV and IRR.
- Model Chart: Revenue, EBITDA and cash as a column chart.
Requirements
-
- Microsoft Excel 2016 or later, or Microsoft 365
- The workbook can also be opened in LibreOffice Calc, Google Sheets (after importing the file) and Apple Numbers. Some formatting or formula behaviour may differ between applications.
- No macros, no add-ins, no internet connection required
Please read
-
-
This workbook is a financial modelling tool, not financial, tax, accounting or investment advice.
-
NPV and IRR are calculated from your own assumptions. They are analytical outputs, not a valuation of the business.
-
No country’s tax rules, tax allowances or capital-allowance regime are built into the workbook.
-
The model’s results depend on the accuracy of your inputs. Review the assumptions and outputs with your accountant before sharing the model with a lender or investor.
-
Sample data is included for demonstration only. Replace it with your own figures before using the model for business decisions.
-
Frequently asked questions
What does the Five-Year Financial Model Template include?
The workbook includes a five-year profit and loss statement, balance sheet and cash flow statement, all linked through a central financial model. It also includes assumption sheets, a summary dashboard, NPV and IRR calculations, and a chart showing revenue, EBITDA and cash.
Can I customise the financial model for my business?
Yes. You can enter your own currency, first forecast year, tax rate and discount rate on the Setup sheet. The Drivers sheet lets you adjust operating assumptions such as revenue growth, costs, capital spending, depreciation, working capital, borrowing and dividends.
Does the template automatically calculate all three financial statements?
Yes. Once you enter your opening financial position and assumptions, the workbook calculates the projected profit and loss, balance sheet and cash flow for five years. The statements are linked, and the Balance Sheet sheet includes a check to help confirm that assets equal liabilities and equity.
Can I use this template for a business plan or funding application?
Yes. It can help prepare financial projections for business planning, internal analysis and discussions with potential lenders or investors. However, you should review and validate the assumptions and outputs before using or submitting the model.
Does the workbook calculate business valuation using NPV and IRR?
No. The workbook calculates NPV and IRR from the free cash flow and discount rate assumptions you provide. These are analytical calculations, not a business valuation.
Does the template include tax rules for a specific country?
No. The workbook does not contain country-specific tax rates, tax allowances or capital-allowance rules. You can enter an appropriate tax rate, but you should check the relevant tax treatment for your business and location.










Reviews
There are no reviews yet.