← All prebuilt solutions
Lite & Free

12-Month Business Plan – Lite

A one-year business plan – monthly profit, cash, VAT quarters, a loan and corporation tax

£5

Secure checkout. Your download link is sent as soon as payment clears.

12-Month Business Plan – Lite

Overview

Before you borrow money, take on staff or buy equipment, you need to know two things: will the business make a profit over the next year, and will there be enough money in the bank every single month? This Lite edition answers both. You describe your sales, staff, running costs, equipment and loan; the workbook builds a 12-month profit and loss account, a month-by-month cash flow with VAT quarters and loan repayments, an estimate of corporation tax and a dashboard with traffic-light health checks.

Price
£5
Who it’s for
Lite & Free
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Revenue

Revenue streams, seasonality patterns and the monthly calculations of sales, cost of sales, VAT and cash received. What you do: fill in the streams and check the patterns.

Revenue
Staff

Step 2

Staff

Up to 8 people and the monthly staff costs: gross pay, employer NI, Employment Allowance and pension. What you do: fill in one line per person.

Step 3

Overheads

Up to 15 running costs, the monthly cost of each, totals by category and the VAT on them. What you do: fill in one line per cost.

Overheads
P&L

Step 4

P&L

Monthly profit and loss for 12 months with a year total and % of sales, plus the corporation tax estimate. What you do: nothing – it's all calculated.

Who it is for

Made for people like you

  • Example – text
  • Limited companies planning the year ahead – A monthly P&L and closing bank balance for the next 12 months.
  • Businesses applying for a loan – Repayments built into the cash flow, plus a debt service cover check against your lender's minimum.
  • Start-ups and growing businesses – When cash is tightest, whether you dip below your safety buffer and what the business will owe at the year end.
  • Owners who want something simple – Four short input sheets – no balance sheet, scenarios or three-year model to maintain.
  • TIP – Need three years, a balance sheet, scenarios or lender ratios for a bank pack? The full 3-Year Business Plan does all of that – see the panel on the Dashboard.

Quick start

Up and running in minutes

  1. Example – text
  1. Setup – Enter the business name, the first month of the plan, your VAT position and quarters, the tax year for rates, your opening bank balance and what's owed to and by the business, dividends, the loan and any equipment you'll buy.
  2. Revenue – Fill in up to 4 revenue streams – units, growth, price, seasonality pattern, start month, cost of sales %, VAT rate and customer payment months. Check the seasonality patterns underneath.
  3. Staff – List each person with their salary, start month, any leave month, pay rise and employer pension %.
  4. Overheads – Add each running cost with the amount per payment, how often it's paid, the first month, and whether VAT is charged.
  5. Read the Dashboard – Look at profit before tax, the lowest bank balance and the four health checks. Then open the P&L and Cash Flow sheets for the month-by-month detail.
  6. Adjust until it works – If a health check is red or amber, change the plan – timing of the loan or equipment, prices, costs or dividends – and watch the Dashboard update.

Key features

  • Up to 4 revenue streams (units × price with monthly growth and seasonality), each with its own cost of sales, VAT rate and customer payment terms.
  • Up to 8 staff with employer NI, the Employment Allowance and pension; 15 overheads paid monthly, quarterly, annually or one-off; 4 equipment purchases.
  • A monthly P&L with a corporation tax estimate, and a cash flow with VAT quarters, one loan with repayments and the closing bank balance every month.
  • A dashboard with eight headline figures, four traffic-light health checks and four charts.

What’s included

  • Dashboard – The plan at a glance
  • Setup – Business, VAT, opening cash, loan and equipment
  • Revenue – Revenue streams
  • Staff – Staff and payroll costs
  • Overheads – Running costs
  • P&L – Monthly profit and loss and tax estimate
  • Cash Flow – Bank balance, VAT and loan
  • Tax Rates – UK tax rates by year
  • Guide – How to use this workbook

How buying works

Your file is only released once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your download link arrives as soon as payment clears.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions