5 year business plan template with the financials already laid out
Year one month by month, years two to five as annual totals. This page covers how far to take each year, and a worked five year summary you can copy the shape of. No email required.
- How much detail each of the five years actually needs
- Running a base case and a slower case without doubling the work
- Word, Google Docs or PDF, whichever you work in
Word
Google DocsThirty-one pages: the eleven chapters, with every financial table running Year 1 to Year 5 rather than stopping at three.
What goes in each of the five years
A five year plan is not year one repeated five times. The detail should drop off sharply, and a reader expects it to.
Year 1
Month by monthTwelve columns. Seasonality, the ramp before you hit steady trading, when each hire starts, when big one-off costs land. This is the year a lender actually scrutinises, and the only one where monthly precision is credible.
Years 2 and 3
Quarterly or annualClose enough to plan against, far enough out that months are invented. Name what changes: a second location, a price rise, a new channel, the hire that lifts capacity. Growth with a reason attached reads as a plan; growth without one reads as a wish.
Years 4 and 5
Annual totals onlyDirection, not forecast. These two years exist to show the shape the business settles into and when it stops needing cash. A reader who sees monthly detail in year five trusts the earlier years less, not more.
What five years of numbers actually looks like
A made-up coffee roastery, in dollars. The useful part is not the figures, it is how much thinner the basis gets each year. A reader judges a long forecast on whether you admit that.
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
|---|---|---|---|---|---|
| Revenue | 186,000 | 243,000 | 292,000 | 321,000 | 353,000 |
| Cost of goods | 74,400 | 95,000 | 113,000 | 122,000 | 134,000 |
| Staff | 52,000 | 71,000 | 88,000 | 95,000 | 104,000 |
| Everything else | 38,000 | 44,000 | 49,000 | 52,000 | 55,000 |
| Profit before tax | 21,600 | 33,000 | 42,000 | 52,000 | 60,000 |
Year 1
Built month by month from a real opening date, with the first two months at roughly half volume while the wholesale accounts come on.
Year 2
Still quarterly. Growth comes from two named things: the fourth wholesale account, and Saturday market trading from April.
Year 3
Annual. The second roaster lands here, which is why cost of goods rises more slowly than revenue from this point.
Years 4 and 5
One assumption each: ten percent then ten percent, no new capacity. Anyone reading this knows those two numbers are a straight line, and saying so is more credible than dressing them up.
How to fill in the years nobody can predict
The template handles the structure. These are the judgement calls that decide whether the numbers in it are believable.
Year one is monthly, years two to five are annual
Nobody can forecast month 47, and a lender does not expect you to. Detail the first twelve months month by month, then move to yearly totals. A plan that claims monthly precision five years out reads as invented rather than thorough.
Say what drives the growth
A line that rises 20% a year without explanation is a guess with a trend line on it. Tie each step up to something specific: a second location in year three, a price rise in year two, a new channel in year four.
Three cases, not one
Run a base case, a slow case and a good case. The slow case is the one lenders read most carefully, because it shows whether the business survives when the plan does not land.
Five years is a planning horizon, not a promise
The far years exist to show the shape of the business and when it stops needing cash, not to be accurate. Revisit the whole thing yearly and treat the later columns as direction rather than forecast.
Want the longer read on whether five years is even the right horizon? Our guide to five year business planning covers that side of it.
Change one assumption and watch all five years update.
Run the numbers three ways
One projection over five years is a guess with a trend line on it. Three cases take an afternoon and change how the plan reads.
Base case
The one you presentWhat you genuinely expect if nothing unusual happens. Every assumption at the value you would defend if challenged on it.
What to change: Your honest estimate of price, volume and growth rate.
Slow case
The one a lender reads hardestLaunch slips a quarter, sales come in below plan, a customer pays late all year. The question it answers is whether the business survives and can still service debt when the plan does not land.
What to change: Cut volume by a third, push the revenue ramp back three to six months, stretch payment terms.
Good case
The one that shapes decisionsUseful less for optimism than for planning. It tells you when you would need a second hire, more space, or more stock, and whether you could fund any of that.
What to change: Raise volume by a third and ask what breaks first: cash, capacity or people.
Not quite the right one?
Same template underneath. What changes is the guidance around it, and which sections do the work.
- Startup business plan templatePre-revenue, forecasting from assumptions with no trading history behind you.
- Small business plan templateAlready trading, writing from your own accounts rather than guesses.
- Simple business plan templateSix chapters instead of eleven, and which four you can safely cut.
- One page business plan templateThe whole business on a single sheet, with a worked example.
- Nonprofit business plan templatePrograms, funding mix, governance and the impact section funders score.
Or go back to the full business plan template.
Five years of numbers, without five years of spreadsheets
Set your assumptions once. Profit and loss, cash flow and the balance sheet rebuild themselves every time you change one.
- No risk
- Cancel at any time
- 15 Day money back guarantee