Precision CNC machining and steel fabrication for makers of agricultural and off-highway machinery, from one site in Dudley. 86 staff.
Verdict: 5 of the 13 projects are funded, using £500,000 of the £500,000 budget (£110,000 on must-dos), leaving £0 uncommitted. The chosen projects are expected to add £194,613 after tax in today’s money at an after-tax hurdle rate of 8% (-£98,038 if the benefits come half as well); the must-dos cost £82,223; together £112,391, paying back in about 47 months. Recommended: Plan B: it drops Replace the 2004 CNC lathe; Electric forklift to replace the diesel one and adds Fibre laser cutter: bring subcontracted cutting in-house, for £15,971 more net present value. 4 worthwhile project(s) wait for cash, worth £179,647; next in line: Replace the 2004 CNC lathe: needs £185,000 more cash. 0 marginal; 4 rejected: they don’t earn the hurdle rate on the expected benefit. Best for the money: “Inspection machine (CMM)”; weakest: “Take on the unit next door”.
| Plan | Cash committed | NPV of chosen projects | Must-dos | Total NPV |
|---|---|---|---|---|
| Plan A ranked by value per £ of first-year cash | £459,000 | £178,642 | −£82,223 | £96,420 |
| Plan B (recommended) best combination within the budget | £500,000 | £194,613 | −£82,223 | £112,391 |
Plan B: it drops Replace the 2004 CNC lathe; Electric forklift to replace the diesel one and adds Fibre laser cutter: bring subcontracted cutting in-house, for £15,971 more net present value. The laser cutter is bigger than the next projects in the ranked order, so the ranked fill passed over it; tried in every combination of the worthwhile projects, it wins. The lathe replacement now waits; it is next in line if more cash or borrowing comes available.
| # | Project | Cash | NPV | Per £ | Payback | Plan A | Plan |
|---|---|---|---|---|---|---|---|
| 1 | Weld shop fume extraction upgrade Compliance · no benefit claimed | £68,000 | −£61,637 | -0.89 | never | Funded (must-do) | Funded (must-do) |
| 2 | Paint booth fire suppression (insurer requirement) Compliance · quotation or measured | £42,000 | −£20,586 | -0.48 | 183 | Funded (must-do) | Funded (must-do) |
| 3 | Inspection machine (CMM) Cut cost · own past project | £88,000 | £60,356 | 0.66 | 38 | Funded | Funded |
| 4 | Replace the 2004 CNC lathe Replace · own past project | £185,000 | £107,828 | 0.58 | 38 | Funded | Waits |
| 5 | Fibre laser cutter: bring subcontracted cutting in-house Cut cost · quotation or measured | £260,000 | £126,447 | 0.46 | 38 | Waits | Funded |
| 6 | Delivery van to replace couriers Cut cost · quotation or measured | £42,000 | £7,811 | 0.15 | 43 | Funded | Funded |
| 7 | Solar panels on the factory roof Cut cost · quotation or measured | £145,000 | £21,101 | 0.14 | 72 | Waits | Waits |
| 8 | 5-axis machining centre for new contract work Grow · estimate | £360,000 | £48,070 | 0.13 | 59 | Waits | Waits |
| 9 | Electric forklift to replace the diesel one Replace · quotation or measured | £34,000 | £2,648 | 0.08 | 51 | Funded | Waits |
| 10 | Production planning software (MRP) Cut cost · estimate | £95,000 | −£12,466 | -0.11 | 57 | Rejected | Rejected |
| 11 | Second shift on the machining cell Grow · estimate | £37,000 | −£12,843 | -0.11 | 100 | Rejected | Rejected |
| 12 | Take on the unit next door Grow · hunch | £270,000 | −£328,688 | -1.07 | never | Rejected | Rejected |
| 13 | Trade shows and an agent in Germany Grow · hunch | £55,000 | −£37,819 | -0.47 | 168 | Rejected | Rejected |
Cash is up front plus working capital; NPV is after tax in today’s money; per £ is NPV per £ of first-year cash (up front, working capital and a year’s running cost); payback in months, before tax. Plan is the recommended plan.
Net present value after tax at the hurdle rate, in the ranked order. Black: must-do; red: funded in the recommended plan; grey: waiting for cash; light: rejected.
The fume extraction and the paint booth fire suppression are funded whatever they return: one follows HSE guidance on welding fume, the other is the insurer’s condition. Together they take £110,000, 22% of the budget.
| Project | Benefit a year | Chance | Expected | Running cost | Simple return | Tax relief today | NPV if half as well |
|---|---|---|---|---|---|---|---|
| Weld shop fume extraction upgrade Plant: main rate · 15 years | £0 | 0% | £0 | £1,500 | -18% | £14,858 | −£61,637 |
| Paint booth fire suppression (insurer requirement) Plant: main rate · 15 years | £4,000 | 90% | £3,600 | £800 | 0% | £9,177 | −£28,947 |
| Inspection machine (CMM) Plant: main rate · 12 years | £45,000 | 75% | £33,750 | £3,000 | 48% | £19,228 | −£10,560 |
| Replace the 2004 CNC lathe Plant: main rate · 10 years | £85,000 | 75% | £63,750 | £0 | 44% | £40,422 | −£16,251 |
| Fibre laser cutter: bring subcontracted cutting in-house Plant: main rate · 8 years | £120,000 | 90% | £108,000 | £14,000 | 44% | £56,810 | −£61,064 |
| Delivery van to replace couriers Plant: main rate · 6 years | £24,000 | 90% | £21,600 | £9,000 | 28% | £9,177 | −£26,413 |
| Solar panels on the factory roof Plant: special rate · 25 years | £30,000 | 90% | £27,000 | £1,500 | 27% | £31,682 | −£50,726 |
| 5-axis machining centre for new contract work Plant: main rate · 10 years · working capital £40,000 | £190,000 | 50% | £95,000 | £12,000 | 25% | £69,920 | −£128,431 |
| Electric forklift to replace the diesel one Plant: main rate · 7 years | £9,000 | 90% | £8,100 | £0 | 21% | £7,429 | −£11,311 |
| Production planning software (MRP) Deducted as spent · 7 years | £90,000 | 50% | £45,000 | £18,000 | 28% | £20,757 | −£79,405 |
| Second shift on the machining cell Deducted as spent · 5 years · working capital £25,000 · £20,000 a year taken off as an overlap | £190,000 | 50% | £85,000 | £78,000 | 15% | £2,622 | −£134,973 |
| Take on the unit next door Building · 15 years · working capital £30,000 | £70,000 | 25% | £17,500 | £36,000 | -23% | £25,046 | −£365,722 |
| Trade shows and an agent in Germany Deducted as spent · 3 years · working capital £15,000 | £120,000 | 25% | £30,000 | £25,000 | -24% | £8,740 | −£62,048 |
Benefits are the owner’s figures for gross profit gained or costs saved, counted at the chance they deliver on their evidence (90% quotation or measured, 75% own past project, 50% estimate, 25% hunch: assumed), with any amount also claimed in another project taken off the lower-ranked one. Running costs start at once; working capital goes out at the start and comes back at the end. Each project is valued over its life or 5 years, whichever is shorter, at an after-tax hurdle rate of 8% (the owner’s choice), with 50% of what a longer-lived asset earns after that counted, and management time at £45 an hour. Tax at 25%, paid 9 months after each year end, with capital allowances simplified (100% of main-rate plant relieved in year one, 14% a year on the rest, each asset as if in its own pool, relief assumed usable at once): check with your accountant. Not investment advice.
What would change the order: If the benefits came half as well, 3 of the 3 chosen projects would lose money. Chosen projects resting on an estimate or a hunch: 0; firming up those benefits (a quotation, a trial, a customer’s order) matters most. A higher hurdle rate favours quick paybacks; more cash or borrowing funds the next in line.
The second shift’s benefit overlaps the lathe’s by £20,000 a year of overtime; it is taken off the shift, the lower-ranked of the two, and with wages running from day one and £25,000 of working capital the shift no longer earns the hurdle rate. Year-one allowances of £500,000 exceed the expected taxable profit of £450,000, so some relief is carried forward (roughly £926 of value, not deducted above). The tax treatment is simplified: the accountant should confirm it, and how the excess is used, before orders are placed.