This guide helps you understand the importance of budgeting and how to create and use a budget effectively, so you can keep your business financially on track.
This guide covers:
Budgeting: why bother and what’s involved?
If you’re thinking of starting a business, a budget shows you and your potential backers whether your idea is viable. Once your business is up and running, a budget provides a blueprint for your business’ success, and an accurate measure of how it is performing against your blueprint, month by month.
Budgeting helps you forecast:
Building a detailed budget at the beginning of each year or financial period helps you make these forecasts more accurately. As each month ends, you can update your budget with actual data and adjust future estimates accordingly. This provides an accurate, at-a-glance projection of the business’s financial position at the end of the budget period.
A detailed budget helps you:
Creating your first budget
Where to begin? Every new business starts with a zero-based budget – ie figures for sales, costs and profit based purely on estimates. The figures you use should reflect your business goals and ambitions.
If you know your marketplace, the figures should be an honest assessment of what you expect your business to achieve in the given budget period. If you have no experience in your marketplace, your first task should be to seek the advice of someone who does. Their guidance and help will ensure your estimates are more realistic.
In future years you can produce historically-based budgets, using sales, cost and profit data from past years as an accurate starting-point to budget for the coming year.
Prepare best-case and worst-case figures
To help you plan both for a great year and poor year, creating two budgets using best-case and worst-case figures can be helpful. Then you can think through the implications of each scenario and prepare accordingly.
Getting the basics of budgeting right
Whether you decide to compile your budgets on paper or on a computer-based spreadsheet, the more accurate and up-to-date you make them – using all available data – the more useful they become. Regularly reviewing, updating and recalculating your budgets is an essential discipline, focusing your mind on costs, reminding you of business issues and giving you an accurate snapshot of how the company is performing against targets.
Even as you prepare to launch your business, you should be tweaking your budget as you gain more insight into production costs.
Annual budgeting is best done on a month-by-month basis, making sure you adjust monthly predictions if your business is likely to experience seasonal sales peaks during a year. For long-term financial planning, quarterly budgets are more useful.
Sales budgets – building and using yours
Building your sales budget
For each product (or product group if you have lots), consider carefully the most accurate answers to these key questions:
Enter your results in a table like this:
Table 1
January | February | March | Quarter 1 Total | |
|---|---|---|---|---|
Product A | ||||
Sales units (UA) | 1000 | 1500 | 3000 | 5500 |
Selling price (PA) | £5 | £5 | £4.50 | |
Sales value (VA = UA x PA) | £5000 | £7500 | £13500 | £26000 |
Product B | ||||
Sales units (UB) | 500 | 400 | 600 | 1500 |
Selling price (PB) | £9 | £9 | £8 | |
Sales value (VB = UB x PB) | £4500 | £3600 | £4800 | £12900 |
Total sales value (VA + VB) | £9500 | £11100 | £18300 | £28900 |
(Key: U = Units sold, P = Price per unit, V = Sales Value)
Using the simple formula sales units x sales price = sales value, you can calculate sales values for each month in a given period, adding them up to give you a quarterly figure (as in the illustration) and combine these to get yearly totals.
Using your sales budget
To make best use of your budget, plot your actual performance against it. You can then calculate how much over or under you are for your budget targets, identifying which products are over or under-performing. This is called a variance report.
If you have computerised accounting software, you should be able to input your monthly figures and the program will produce variance reports for you, both for that month and for the year to date. If not, you can construct your own report, like this one:
Table 2
January (£) | February (£) | March (£) | |
|---|---|---|---|
Actual sales | 8000 | 10500 | 19000 |
Budgeted sales | 9500 | 11100 | 18300 |
Variance | (1500) | (600) | 700 |
Year to date | |||
Actual sales | 8000 | 18500 | 37500 |
Budgeted sales | 9500 | 20600 | 38900 |
Variance | (1500) | (2100) | (1400) |
Figures in brackets are negative.
The variance figure is produced by taking the budgeted figures away from the actual figures. The year-to-date figure is an accumulation of the amounts for each month.
By producing this variance report you can see several things clearly:
Why are these figures useful? The variance report gives you a snapshot of where your business stands financially compared to your budget. It also shows you in which months you have sold more than you thought you would and in which months you have sold less. By adding actual data you can easily spot trends. You can use this information to adjust future budgeted figures. This enables you to see – using all available data and having adjusted future budget figures – where the company will stand financially at the end of the budget period.
For instance, if you have an average positive variance of 10 per cent for the first six months of the year, it’s reasonable to adjust your budgeted figures upwards for the rest of the year.
Profit and loss budgets – building and using yours
Your sales budget feeds into a profit and loss budget which, taking all your other costs into consideration, enables you to work out how much profit you make each month and how much you’re likely to make in your budget period.
Working our the cost of sales
Cost of sales is a key part of working out how much profit you are making. Total revenue from sales minus total cost of sales equals profit.
First you need to work out how much it costs to produce the product, ie labour costs, materials etc. This is your unit cost. If you buy in your products, your unit cost is the wholesale price you pay for the product.
You then need to work out other costs per unit, ie every other cost involved in producing and selling each product. These include:
You need to work out what these costs are for each unit you sell. If the costs do not apply to individual units, such as utility bills and storage, take an average monthly cost and divide it by the number of units you think you will sell each month. This gives you an average estimated cost per unit for these costs. For instance: staff commission = £25p per unit; utility bills per month = £100 divided by an estimated 2000 units sold = 5p per unit; and so on.
If you take all of these costs and spread them over the months of the budget, you get total sales costs per month. From your sales budget use the predicted number of units per month and divide your sales costs by your number of sales. This gives you sales costs per unit. Add your unit cost to your sales cost per unit and you have your total cost of sale per unit.
To calculate your monthly cost of sales:
Table 3
Units Sold | Unit Cost | Other Costs of Sales | Cost of Sales | |
|---|---|---|---|---|
Product A | 21000 | £2.48 | £0.52 | £63000 |
Product B | 6000 | £3.74 | £0.26 | £24000 |
Total cost of sales | £87000 |
Calculating your gross profit< /STRONG >
Gross profit is the surplus of money you’ve taken (turnover) once you’ve taken away your cost of sales. To calculate gross profit:
Table 4
£ | ||
Sales value | [T] | 150500 |
Less cost of sales | [C] | 87000 |
Gross profit | [G = T - C] | 63500 |
Calculate your net profit
To find your real profit, you now need to deduct other costs not directly linked to sales and unit production. An example is rent, which won’t vary however many units you sell. These are called fixed costs or overheads.
For your overheads, take into account all your other costs, including:
Remember, most overheads will change over time (due to inflation, for instance), although costs like office rent might be fixed for at least a year ahead. So when you’re budgeting, it is important to include everything, be realistic and build in rising costs when you think they may occur. Most start-ups underestimate a lot of these overhead costs and end up with inaccurate profit estimates.
Note: if you are a manufacturer, be careful not to double-count items like labour costs and electricity that you have already built into your cost of sales.
Depreciation
Typically, to run a business you will need things like furniture, cars, computers, machine tools and so on. These are called capital items or fixed assets, and their purchase cost is not included in the budget. Instead, there is a special charge that accountants call depreciation. This is not an expense as such because it doesn't involve parting with any cash, but it does represent an estimate of the proportion of the value of your fixed assets that is used up during the year.
For example, if you buy a new machine every four years, and the last one cost you £1000, you should include a depreciation charge of 25% of this £1000, ie £250 in each of the four years. By doing so, you’re building into your accounting surplus cash to buy new equipment when it is needed.
Let's extend our table with a few overhead items. Your list of items will probably be much longer, but this example is merely to illustrate the format.
Add up all the Overheads and deduct from your Gross Profit to give a Net Profit of £18,800 for the year.
Table 5
£ | £ | % of sales | |
|---|---|---|---|
Sales value (turnover) | 150500 | 100% | |
Less cost of sales | 87000 | 58% | |
Gross profit | 63500 | 42% | |
Less overheads | 44700 | ||
Office/management salaries | 21000 | ||
Rent/rates | 3500 | ||
Selling costs/advertising | 9500 | ||
Telephones | 1800 | ||
Electricity | 1200 | ||
Postage/stationery | 1900 | ||
Professional fees – legal and accountancy | 2100 | ||
Interest paid | 1500 | ||
Depreciation | 2200 | ||
Total overheads | 44700 | 30% | |
Net profit | 18800 | 12% |
Add in actual figures and variance
Take Table 5 and add two extra columns – one for actual figures and one for variance. The actual figures again come from your accounting records and again exclude VAT. And the variance is calculated as the difference between the actual and budget column figures.
Table 6
Actual | Budget | Variance | |
|---|---|---|---|
Turnover | £145000 | £150000 | (£5500) |
Cost of sales | £85000 | £87000 | £2000 |
Gross profit | £60000 | £63000 | (£3500) |
Overheads | £47500 | £44700 | (£2800) |
Net profit | £12500 | £18800 | (£6300) |
Note that if turnover or profit is less than budget, the variance is negative (ie in brackets). However, if costs or overheads are less than budget, the variance is positive.
Table 6 gives you a simplified overview. It clearly shows you where your budget varies compared to your actual figures. This enables you to pinpoint areas that need attention, or areas that are more cost-efficient for the company.
The importance of cashflow
Just as important as your profitability is your cashflow. You can’t sell things unless you buy or make them, both of which may involve paying out cash before getting any return from them. Most businesses that fail do so because they run out of available cash, often despite showing good profits. Cashflow problems can also arise in seasonal businesses or those with poor credit control.
So another vital table is a cashflow forecast, where you list all your cash inflows and outflows and when you expect them to occur. This highlights periods when you may need a temporary overdraft. If you have a detailed annual budget that shows cashflow issues in the short term but good profits at the end of the year, this will help obtaining finance.
Useful contacts
For more information about budgeting, contact your local Business Link service on 0845 600 9006 or visit www.businesslink.gov.uk
