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
What the workbook contains
- Start Here: how to complete the workbook and the colour key
- Assumptions: business name, first trading month, tax rate, growth, cost increases, credit sales, revenue lines and loan terms
- Start-up Costs: uses and sources of funds, with the funding gap
- Operating Costs: monthly running costs for three years, with occupancy costs marked
- Cash Flow: a 12-month forecast of cash in, cash out and the closing balance, calculated for you
- Income Statement: three years from revenue to net profit after tax, with estimated closing cash
- Loan Schedule: monthly opening balance, instalment, interest and capital repaid
- Summary: the financial highlights, funding, break-even, cash and sensitivity figures to copy into the plan
How to complete it
- Start with the Assumptions sheet: business name, first month of trading, tax rate, growth, revenue lines and loan terms.
- Enter your start-up costs and sources of funds until the funding gap is zero.
- Enter monthly operating costs and the month each one starts. Mark rent and premises costs as occupancy costs.
- Check the Cash Flow, Income Statement and Loan Schedule sheets, which calculate automatically.
- 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
- Business plan for lenders: For a bank loan, asset finance or an application to a development finance institution.
- Business plan for landlords: For an application to lease a shop, restaurant, office or industrial unit.
- Business contract templates: free Word templates for the contracts and policies a new business needs.
