3-Year Cash Flow Projection Template for Business Plans

A three-year cash flow projection answers the big questions in a business plan: how much money does the business need, when does it stop needing outside funding, and can it repay a loan over its full term? It’s less precise than a monthly forecast, and that’s fine. Its job is to show the shape of the next three years and the assumptions behind it.

The standard format

• Year one, month by month: the detailed forecast, including start-up costs, the sales ramp-up and the lowest point.
• Years two and three, annual totals: built from year one plus explained growth rates.
• Opening and closing balances for every period.
• An assumptions page.

Some investors ask for five years, and some lenders want quarterly detail in year two. Ask what the reader expects.

Building it

Year one in detail

Build year one as a normal 12-month forecast: receipts in the month they arrive, every payment including tax, loan repayments and owner pay. This is the foundation; the later years inherit its structure.

Years two and three from growth rates

For each line, apply a growth rate to the year-one total:

Year 2 = Year 1 × (1 + growth rate)

Use separate rates for cash in and cash out, because costs rarely grow at the same rate as sales. Some costs, such as rent, may be fixed by a lease; others, such as materials, rise with sales.

Funding and one-offs separately

Don’t grow loans, investment, grants or one-off purchases. Enter any you expect in later years directly. Our templates do this automatically: financing lines don’t grow in the 3-year view, and there are input cells for any funding you expect.

Worked example

Assumptions: cash in grows 12 percent in year two and 10 percent in year three; cash out grows 8 percent and 7 percent. Year one is roughly break-even as the business invests in equipment and pays quarterly taxes; years two and three build a cash cushion because income grows faster than costs.

A reader will immediately ask why income grows faster than costs. The assumptions page should answer: perhaps staff costs are largely fixed, and year-one prices were introductory.

Annual, quarterly or monthly for later years?

Annual totals are standard for years two and three, but they hide seasonality. If your business has a strong seasonal pattern, or a loan repayment schedule that changes during year two, consider showing year two by quarter. The lowest point in a seasonal business’s second year can be well below what the annual total suggests. A quick check: take year one’s monthly pattern, scale it by year two’s growth rate, and see where the low month falls. If it’s uncomfortably close to zero, show it.

Capital spending and tax in later years

Two lines are often missing from later years. Capital spending: vehicles, computers and equipment bought in year one will need replacing, and growth often needs more of them. Tax: if the business becomes profitable in year two, income or corporation tax is usually paid later, sometimes in year three. Both can take a large bite out of a projection that otherwise looks comfortable.

The assumptions page

Show a downside case

Build a second version with slower growth, perhaps half the rates you expect, or year-two income flat. Show whether the business still has cash throughout, and what you’d change if not. Investors and lenders give far more weight to a projection that has been stress-tested. The downside case doesn’t need to be dramatic; it needs to be plausible, and you should be able to say what you would do if it happened. See scenario planning.

What readers look for

1. When the business becomes self-funding, with cash rising without new funding.
2. The lowest point in year one, and whether funding covers it with a buffer.
3. Growth that’s explained, not a line that curves upward on its own.
4. Loan repayments covered across the full term.
5. Consistency with the profit forecast and the business plan text.

Projections for startups and investors

Startups raising equity usually show three to five years, and the projection plays a different role: it shows how the funding round is spent, when the company reaches the next milestone, and how much runway the round buys. Keep revenue growth, hiring and burn visible, show the month cash would run out without further funding, and treat any later rounds as separate scenarios rather than certainties. The cash runway guide explains the calculations investors expect.

Common mistakes

• Applying one growth rate to everything, including rent, loans and one-off costs.
• Hockey-stick growth with no explanation.
• Ignoring tax as profits rise.
• Forgetting capital spending in later years, such as replacement equipment or vehicles.
• Leaving out owner pay.
• Treating years two and three as precise. They’re directional; round them.
• Not updating it. A projection prepared for a loan two years ago tells you little about the next three years. Refresh it annually.
• Mixing profit and cash. Depreciation, accruals and sales not yet paid belong in the profit forecast; the cash projection shows money moving.

Link it to your monthly forecast

Once the business is trading, the 3-year projection shouldn’t sit in a drawer. Roll year one forward each month with actual figures, and revisit the growth assumptions each year. That keeps the long view honest and gives you an up-to-date projection whenever a lender or investor asks.

Templates

Premium templates include a 3-Year tab built from the 12-month forecast and your growth rates, with separate rates for cash in and cash out, loans and investment excluded from growth, and a scenario switch that flows through all three years. For a business plan, see also what to include in a business plan forecast.