A five-year projections template provides a structure for outlining expected business performance over five financial years. Organize assumptions about sales, costs, cash movements, assets, liabilities, and equity, then review whether the projected statements are consistent.
The free Excel workbook below places three summary sections on one worksheet: an income statement, cash flow statement, and balance sheet. It includes selected formulas, but it is not a fully integrated forecasting model. Several important figures and links must be entered or added separately.
Download the Free Five-Year Projections Template for Excel
File format: Excel workbook (.xlsx). Included: Five year columns, three financial summary sections, selected subtotal formulas, and preparation and approval fields.
Preview of the five-year financial summary layout. Select the image to view it at full size.
Calculation scope: The workbook does not automatically forecast growth, connect every statement, carry opening cash forward, or confirm that the balance sheet balances. Review inputs and formulas before relying on the results.
Open the workbook in Microsoft Excel and save a working copy. A separate Word or PDF file is not included. Review our Terms & Conditions for usage information.
What Does the Workbook Include?
Income summary: Net sales, cost of goods sold, a row labeled “Net Operatin Income,” operating expenses, and net income.
Balance sheet: Current and fixed assets, current and long-term liabilities, equity, and totals.
Review fields: Prepared By, Approved By, and Dated.
The five-column layout is an annual summary. It has no monthly or quarterly detail, dedicated assumptions tab, scenario selector, loan schedule, depreciation schedule, or tax model. Prepare supporting calculations separately.
For the initial cost plan of a new venture, review our start-up budget templates. Those costs should be reflected consistently in the relevant forecast periods.
How to Prepare Five-Year Business Projections
1. Define the years and assumptions
Label the columns with financial years and identify the preparation date. Keep historical actuals distinct from forecasts. Document the assumptions behind prices, sales volumes, costs, collection timing, investment, and funding.
Use consistent currency and units throughout. If figures are in thousands, label that clearly. Growth assumptions describe a scenario; they do not establish what will happen.
2. Build sales and cost estimates
Prepare sales estimates from quantities, prices, capacity, or another appropriate basis. Estimate related costs separately rather than assuming every expense grows at the same rate.
A monthly sales projections template can support more detailed first-year estimates. Transfer the annual total into the relevant year without adding the monthly figures twice.
3. Review the income-section labels and formulas
In the original first year, Net Sales is D8, Cost of Goods Sold is D9, the intermediate income row is D10, and Operating Expenses is D11. The Net Income formula in D12 is =D10-D11.
D10 has no installed sales-minus-cost formula. If you intend D10 to mean gross profit, relabel it “Gross Profit” and add =D8-D9. Apply the corresponding formula in the other year columns.
Under that simplified structure, D12 is profit after operating expenses, not necessarily final after-tax net income. Relabel it accordingly or expand the statement to include any additional items needed for your reporting purpose.
Use a business budget to support operating-cost estimates rather than entering unsupported totals.
4. Prepare cash movements separately
Record beginning cash, expected receipts, and payments for each year. The original closing-cash formula in D19 is =(D16+D17)-D18.
Do not substitute sales revenue for cash receipts without considering collection timing. Asset purchases, borrowing, loan repayments, and owner transactions may also affect cash without matching income-statement amounts.
Enter assets, liabilities, and equity for each year-end on a consistent basis. The workbook calculates current-asset, total-asset, liability, and liability-plus-equity totals.
It does not derive receivables, inventory, debt, or equity from the other sections. Prepare the supporting movements and reconcile them. Do not insert an unexplained equity amount simply to force the totals to match.
The following are additions to the original workbook. Adjust references if you change its layout.
Cash carry-forward: Enter =D19 in E16 for Year 2 opening cash, then link each later opening balance to the preceding closing balance.
Balance-sheet cash: Where both sections cover the same cash accounts and dates, D23 can link to ending cash with =D19. Repeat consistently across years.
Balance-sheet difference: In a separate labeled check cell, use =D29-D38. A nonzero value indicates a difference between total assets and total liabilities plus equity.
A zero difference alone does not establish that all forecasts are correct. Check the source assumptions, classifications, and movements. Test changed inputs and confirm that the intended dependent figures update.
Simple Projection Example
Suppose one year has sales of 100,000, cost of goods sold of 40,000, and operating expenses of 35,000. Gross profit is 60,000, and profit after those operating expenses is 25,000, before any additional items not modeled.
If opening cash is 10,000, receipts are 90,000, and payments are 85,000, ending cash is 15,000. The profit and cash figures differ because the sections measure different things.
These hypothetical amounts illustrate the arithmetic, not expected business performance.
Review Assumptions and Actual Results
Keep the original forecast before revising it. Test alternative sales, cost, and timing assumptions in clearly labeled copies or supporting calculations. The template has no automatic sensitivity-analysis feature.
Use the quarterly budget analysis template for a separate review of actual results against budget. Explain changes before updating later forecast years.
For a funding request, the projections can support a budget proposal, but a lender or investor may require a different format and additional information.
Five-Year Projections Template FAQs
Is the Excel template free?
Yes. Download it above and review the site’s usage terms before using or distributing it.
Does it forecast automatically from past results?
No. You supply the estimates and supporting assumptions. Selected totals calculate from the entries.
Are all three statements linked?
No. Cash carry-forward, balance-sheet cash, and other relationships need separate inputs or added links.
Does it include monthly first-year projections?
No. The original layout has five annual columns. Prepare monthly or quarterly detail separately.
Does a balanced balance sheet validate the forecast?
No. It is one reconciliation check, not proof that the assumptions or all calculations are sound.
Can I open it in Google Sheets?
You can try importing the .xlsx file. Review formulas, formatting, added links, and print layout after import.
Pingback: Free Business Acquisition Worksheet - Blue Layouts