From Beyond AmazingLeadership coaching & consulting

Playbook

Work it through: Can We Afford It?

The question underneath most other questions, answered in order: see when the cash actually runs short, work out what the purchase has to earn to pay for itself, read what the accounts say you can carry, then weigh it against the other things that money could do.

Seven steps, in the order the playbook gives them. Your work stays in this browser until you save it to a file.

1

Your ducks

Start with what the people believe, what the paperwork says and what actually happens. The issues where your ducks disagree are the ones to carry into the homework.

You have not filled in the ducks sheet yet.

Start with your ducks

2

The homework

What has to be found before any of the four frameworks is worth running. Put a name and a date against each one, and tick it when you have it in your hands.

The ducks

For Cash Flow Forecasting

For Break-even Analysis

For Financial Ratio Analysis

For Cost-Benefit Analysis

3

Step 1 of 4: Cash Flow Forecasting

Start with cash, because profit does not pay wages and a business can be profitable on paper and overdrawn on the day it matters. Lay the purchase into a month-by-month forecast and look for the trough, not the total: the month when the new outgoing lands on top of the VAT quarter and the big customer has not paid yet. If the trough breaches the facility, the answer is no for now, however good the case, and the rest of this sequence is about making it yes later.

Watch forA forecast that places income on the invoice date rather than the day the money clears. That single habit flatters every forecast that later goes wrong.

Inputs

Result

Net movement this period
£5,000
Closing cash balance
£20,000
Cash runway at this burn rate
1 units

Read the full entry

4

Step 2 of 4: Break-even Analysis

Now ask what the thing has to earn to pay for itself, and how much room you have to be wrong. A new machine, a new hire, a second site: each adds fixed cost, and break-even tells you the extra volume that fixed cost needs before it stops losing money. The number that matters is the margin of safety, the gap between the volume you expect and the volume you need. A thin margin means the plan works only if everything goes right, and nothing goes right every month.

Watch forExpected sales taken from the optimistic case. Run the break-even against the volume you would bet your own money on, not the one in the pitch.

Inputs

Result

Contribution per unit
£5.7
Contribution margin ratio
60%
Break-even point
600 units
Break-even revenue
£5,700
Margin of safety
33.3%

Break-even chart

600 units
Revenue (solid) crosses total cost (dashed) at the break-even point. Quantity runs left to right; money bottom to top.

Read the full entry

5

Step 3 of 4: Financial Ratio Analysis

The accounts have an opinion, and the bank will read it even if you do not. Liquidity says whether you can meet what falls due; gearing says how much debt the business already carries; profitability and efficiency say whether the engine underneath is sound. A purchase that is affordable on cash and break-even can still push gearing past what a lender will accept, or expose a business whose current ratio was already thin. Read the ratios before you ask for the facility, so the conversation starts with you knowing the answer.

Watch forRatios read in isolation. Each one is a comparison, against last year, against the sector, against the covenant; a number on its own tells you nothing.

Inputs

Result

Gross margin
22.9%
Operating margin
4.8%
Return on capital employed (ROCE)
19.2%
Current ratio
1.2:1
Quick ratio (acid-test)
1:1
Gearing
130.8%
Debtor days
57.8 days

Read the full entry

6

Step 4 of 4: Cost-Benefit Analysis

Only now, with the cash, the earning and the strength known, is it worth asking whether this is the best use of the money. Put every material cost and benefit into today's pounds, including the ones that are awkward (the owner's time, the disruption, the thing you will not do because you did this), and compare the totals with the alternatives, doing nothing among them. The discipline is the list, not the arithmetic: most bad purchases were never compared with anything.

Watch forBenefits that cannot honestly be priced forced into pounds anyway. Where reputation or safety dominates, say so in words and use a decision matrix instead of pretending.

YearCost (£)Benefit (£)Present value
0
£0
1
£0
2
£0
Net present value
£0
Benefit-cost ratio
–

A benefit-cost ratio near 1 means the case rests on the precision of the estimates. Flex the fragile years and see how few points of shortfall turn the net present value negative.

Read the full entry

7

The review date

Set the date you will come back and ask whether it worked. Put it in your diary; this site will not remind you.

Print the dossier

Your work stays in this browser until you save it. The file is yours; load it here on any machine.