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.
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.
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
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
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
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
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.
| Year | Cost (£) | 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.
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.
Your work stays in this browser until you save it. The file is yours; load it here on any machine.