|
The paper below attempts to answer the
question of what the profit "Should Be" given the risks
associated with investment in a small or medium size business.
My opinion is that the risk involved in investing in such a
business, is at least 3 times that of a safe investment or twice
the borrowing rate, whichever is the higher. These two
calculations are on a gross return before tax basis and often
give a very similar result. This criterion can of course be
varied to suit local opinion and circumstances.
Operating Profit measured on this basis is therefore before
interest and tax but is after deducting a management salary for
the owner(s) that reflect a fair reward for their management
activity (including overtime at home).
The calculations below assume a safe
investment return of 8% and a borrowing cost of 12.5%. Given
these parameters the Operating Profit should be at least 25% of
the Operational Investment in the Company. Operational
investment being:-
Fixed Assets (ideally valued at replacement value) plus Net
Current Assets, which is Stock, plus Debtors (excluding any
finance or tax balances), less Creditors (excluding any finance
or tax balances).
The calculations require that the accounts of the business can
be analysed into fixed and variable expenses.
The calculations illustrate the sales activity required to
achieve the "Should Be" Operating Profit, based on the actual
profitability and efficiency historically achieved, or the level
of price increase required, or the degree of savings in cost
required. If a business' profitability falls short of the
"Should Be" Operating Profit criteria, the actions a management
can take to improve profitability are of course many and varied.
They are likely to include a combination of these and other
actions.
|
A Company Ltd |
|
Activity required to achieve "Should Be" Operating Profit |
|
Assumptions |
|
Borrowing Rate
Safe Investment return
Criteria Multiplier - Borrowing
Criteria Multiplier - Investment
Rent return
Fixed Asset Replacement Adj. |
12.5%
8.0%
2.0
3.0
11.0%
5.0% |
|
|
Capital Employed
|
Actual
Investment |
Profit Criteria
|
"Should Be"
Profit |
Land & Buildings |
4,842 |
Rent
Equivalent |
533 |
Fixed Assets
(Cost) |
466,691 |
12.5%
x 2 |
116,673 |
Fixed Asset
Replacement Adj. |
23,335 |
12.5%
x 2 |
5,834 |
Intangible
Assets |
10,000 |
12.5%
x 2 |
2,500 |
Current
Assets |
143,200 |
12.5%
x 2 |
35,800 |
Current
Liabilities |
(91,904) |
12.5%
x 2 |
(22,976) |
|
Capital Employed |
556,164 |
"Should Be"
Operating Profit |
138,363
|
|
Reconciliation |
|
Add: |
|
|
Capital Employed (WDV) |
357,440 |
Proprietor Salary Adj. |
0 |
|
Depreciation Reserve |
175,389 |
Total
Fixed Costs |
210,946 |
|
Fixed Asset Replacement Adj. |
_23,335 |
"Should Be" |
|
|
|
556,164 |
Contribution |
349,309 |
|
Profit & Loss A/c Analysis |
|
|
|
|
Sales |
743,235 |
Sales Required |
856,177 |
|
Variable Costs |
|
OR |
+15.2% |
|
Cost of Sales |
395,764 |
Price Increase Required |
46,079 |
|
Manufacturing |
31,541 |
OR |
6.2% |
|
Selling |
2,414 |
Cost Reduction Required |
46,079 |
|
Administration |
_10,286 |
|
7.1% |
|
Total Variable Cost |
440,005 |
|
|
|
% of Sales |
59.2% |
Super Profit Calculation |
|
|
Contribution |
303,230 |
Capital Employed |
556,164 |
|
% of Sales |
40.8% |
Less:
Land & Buildings |
__4,842 |
|
Fixed Costs |
|
|
551,322 |
|
Manufacturing |
49,253 |
Safe
Return at 8.0% |
44,106 |
|
Selling |
0 |
Rent
Equivalent |
___533 |
|
Administration |
161,693 |
Total
Safe Return |
44,639 |
|
Total Fixed Cost |
210,946 |
"Should Be" Profit |
138,363 |
|
Operating Profit |
_92,284 |
Super Profit |
_93,724 |
Rent Return:-
If it is considered relevant, the criteria can be varied for
different categories of investment. To illustrate this, an
amount is included for a rental charge for owned land and
buildings, rather than the criteria multiplier.
Fixed Asset Replacement Adjustment:-
It is considered that the proprietor manager of a small to
medium sized business, should be able to make a reasonable
estimate of an adjustment factor to be applied to the cost of
fixed assets. The factor should represent the difference between
the cost and the estimated replacement value of fixed assets.
Proprietor Salary Adjustment:-
If the accounts do not include a salary for the proprietors,
that represents a fair reward for their involvement in the
management of the business, then an adjustment should be
included.
Super Profit
Super Profit (my terminology) is the extent to which "Should Be"
profit exceeds a safe return on the level of operating capital
employed in the business.
The "Should Be" profit calculation
could be applied to the financial data included in business
plans and budgets. It can also be used in the setting of targets
and objectives.
If a business is highly seasonal,
resulting in significant variations in operating capital
employed during the course of the year, then the calculation can
be applied to averaged data
A spreadsheet template and example are
available to download. You can replace the data, in the example,
with your own, to automatically calculate a "Should Be" profit
for your business
Three types of spreadsheet template are
available:-
- Microsoft Excel 97
- Microsoft Works version 6
- Lotus 123 Release 2.2 This is a DOS
version and now somewhat old. It has the advantage that it can
probably be read by many other spreadsheet programmes.
Download Microsoft Excel template.
Download Microsoft Works template.
Download Lotus 2.2 template
Warning: Always check downloaded files for viruses before
opening them.
E-mail us your queries and
comments.
Reproduced with Permission
Copyright Len Bainbridge (Unregistered)
|