Skip to content
The first pages of the Three-Year Forecast for Small Businesses template

Three-Year Forecast for Small Businesses

Document template for Google Docs and Word

Make a copy in Google Docs
Price
Free
Style
Minimal
Difficulty
Beginner
Updated
October 30, 2026

Every page (8)

Overview

Lenders and grant panels do not want a hopeful percentage on last year's sales. They want to see what drives revenue, where costs sit, when cash is tightest and what happens if sales fall. This template sets out a plain three-year forecast in that order, starting with the business today and ending with notes on terms and reforecasting.

The sample follows Ironvale Group, a café and wholesale bakery business asking for a £250,000 loan for a central kitchen. It builds sales from covers and spend, shows a monthly cost variance, a three-year cash flow that ties to its totals, and a downside case with 20% less sales. Replace the drivers, tables and notes with your own, keeping the totals tied to cash.

Useful for

  • A café or shop owner attaching a three-year forecast to a bank loan application
  • A founder answering a grant panel's questions about sales assumptions and cash headroom
  • A finance lead showing the board a base case and downside case before approving a new site

What's included

  • Opening page with the business today, headline figures and three points behind the forecast
  • Assumptions page comparing base and downside drivers, with definitions and exclusions
  • Sales page with a monthly trend chart, sales mix, drivers and a key figures table
  • Cost variance table showing budget, forecast and actual with a cause for each material line
  • Three-year cash flow statement with receipts, payments, loan, closing cash and headroom
  • Glossary, reader quotes on the forecast and a guide page for replacing the sample

How to use it

  1. 1

    Click Make a copy in Google Docs, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Replace the assumptions with your own price, volume, wage and inflation inputs, and set the downside percentage from what has moved in your market.

  3. 3

    Rebuild the sales, cost and cash tables from those drivers, and check that every total ties to the cash flow.

  4. 4

    Enter your real opening cash and overdraft or facility limits in the headroom rows, and add the date of your next reforecast.

  5. 5

    Delete the Make it yours guide page, then share the forecast with your lender or present it.

What you need

Requirements

  • A Google account with access to Google Drive

Works with

  • Google Docs
  • Microsoft Word (download the .docx)

Questions

Why include a downside case?

Lenders judge whether a plan is believable by how it behaves under stress. Showing sales 20% lower, with the cash headroom that remains, builds more trust than a single optimistic case.

Are Ironvale Group and its numbers real?

No. Ironvale Group, its people and every figure are fictional sample data. Replace the drivers and tables with your own before you send anything to a lender.

Does the forecast tie profit to cash?

The cash flow page is built from the same sales and cost drivers, so receipts, payments, the loan and closing cash add up. Keep that link when you replace the figures.

  • #financial-forecast
  • #three-year-forecast
  • #cash-flow
  • #loan-application
  • #small-business
  • #break-even
  • #finance
  • #google-docs

More financial projections templates

See all 6

Also in Finance

All finance templates
Get this template

Preparing your template…