← All business plan templates

Free Excel workbook · South Africa

Business plan financial projections template in Excel

The financial workbook is the companion to both business plan templates. You enter your assumptions, start-up costs and running costs, and it calculates a 12-month cash flow, a three-year income statement, a loan schedule and a summary of the figures the plan asks for.

It comes filled in with figures for an example coffee shop so you can see how the sheets connect. Replace them with your own. Each block on the Summary sheet names the plan sections it belongs to, so you know where every figure goes.

When to use it

  • Before you write the financial plan, funding request or occupancy cost sections of either business plan.
  • When you need to know how much to borrow, and whether the business can repay it.
  • When a landlord asks whether the rent is affordable on your forecast.
  • When you want to test what happens to cash if sales come in 10% or 20% below forecast.

The figures lenders and landlords check

The funding gap
Start-up costs must equal the money coming in from owners, loans and other finance. The Summary sheet shows the gap, which must be zero.
The lowest cash month
The cash flow shows the month your bank balance is lowest. The plan must say how that month is covered.
Repayment cover
The debt service cover ratio for years 1 to 3, calculated from the loan schedule and the income statement.
Occupancy cost
Mark rent and premises costs as occupancy costs on the Operating Costs sheet and the workbook works out the ratio landlords check.

What the workbook contains

  1. Start Here: how to complete the workbook and the colour key
  2. Assumptions: business name, first trading month, tax rate, growth, cost increases, credit sales, revenue lines and loan terms
  3. Start-up Costs: uses and sources of funds, with the funding gap
  4. Operating Costs: monthly running costs for three years, with occupancy costs marked
  5. Cash Flow: a 12-month forecast of cash in, cash out and the closing balance, calculated for you
  6. Income Statement: three years from revenue to net profit after tax, with estimated closing cash
  7. Loan Schedule: monthly opening balance, instalment, interest and capital repaid
  8. Summary: the financial highlights, funding, break-even, cash and sensitivity figures to copy into the plan

How to complete it

  1. Start with the Assumptions sheet: business name, first month of trading, tax rate, growth, revenue lines and loan terms.
  2. Enter your start-up costs and sources of funds until the funding gap is zero.
  3. Enter monthly operating costs and the month each one starts. Mark rent and premises costs as occupancy costs.
  4. Check the Cash Flow, Income Statement and Loan Schedule sheets, which calculate automatically.
  5. Copy the figures from the Summary sheet into your business plan.

Questions people ask

Do I need to be an accountant to use the workbook?

No. You enter assumptions and costs on three sheets and the rest calculates. Ask your accountant to check the assumptions before you send the plan, particularly the tax rate and any growth figures.

Does it work in Google Sheets?

It is built in Excel. It opens in Google Sheets and other spreadsheet programs, but check that the formulas on the Cash Flow and Summary sheets still calculate after you upload it.

Which tax rate should I use?

The company rate is 27%. Small business corporations and sole proprietors are taxed on a sliding scale, so check the right rate with your accountant.

The plans it goes with

Further reading