Investment Priorities Plan · October 2026

Penwardine Engineering Ltd

Precision CNC machining and steel fabrication for makers of agricultural and off-highway machinery, from one site in Dudley. 86 staff.

Worked example. Penwardine Engineering and its figures are fictional. All figures come from the worked-example spreadsheet: ALL CHECKS PASSED (with 3 notes).
The headline

Three chosen projects worth £194,613; the best combination beats the ranked order by £15,971

Chosen projects
£194,613
net present value after tax; −£98,038 if the benefits come half as well
Must-dos
−£82,223
two compliance projects, £110,000 of cash; plan total £112,391
Cash committed
£500,000
of £500,000; £0 left
Payback
47 months
recommended plan, must-dos included, before tax

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 A against Plan B

Ranking by value per £ isn't the best use of the budget

PlanCash committedNPV of chosen projectsMust-dosTotal 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.

Funding order

Plan A’s ranked order, and the recommended plan

#ProjectCashNPVPer £PaybackPlan APlan
1Weld shop fume extraction upgrade
Compliance · no benefit claimed
£68,000−£61,637-0.89neverFunded (must-do)Funded (must-do)
2Paint booth fire suppression (insurer requirement)
Compliance · quotation or measured
£42,000−£20,586-0.48183Funded (must-do)Funded (must-do)
3Inspection machine (CMM)
Cut cost · own past project
£88,000£60,3560.6638FundedFunded
4Replace the 2004 CNC lathe
Replace · own past project
£185,000£107,8280.5838FundedWaits
5Fibre laser cutter: bring subcontracted cutting in-house
Cut cost · quotation or measured
£260,000£126,4470.4638WaitsFunded
6Delivery van to replace couriers
Cut cost · quotation or measured
£42,000£7,8110.1543FundedFunded
7Solar panels on the factory roof
Cut cost · quotation or measured
£145,000£21,1010.1472WaitsWaits
85-axis machining centre for new contract work
Grow · estimate
£360,000£48,0700.1359WaitsWaits
9Electric forklift to replace the diesel one
Replace · quotation or measured
£34,000£2,6480.0851FundedWaits
10Production planning software (MRP)
Cut cost · estimate
£95,000−£12,466-0.1157RejectedRejected
11Second shift on the machining cell
Grow · estimate
£37,000−£12,843-0.11100RejectedRejected
12Take on the unit next door
Grow · hunch
£270,000−£328,688-1.07neverRejectedRejected
13Trade shows and an agent in Germany
Grow · hunch
£55,000−£37,819-0.47168RejectedRejected

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.

Value by project

Net present value after tax at the 8% after-tax hurdle rate

Weld shop fume extraction upgrade−£61,637Paint booth fire suppression (insurer re…−£20,586Inspection machine (CMM)£60,356Replace the 2004 CNC lathe£107,828Fibre laser cutter: bring subcontracted …£126,447Delivery van to replace couriers£7,811Solar panels on the factory roof£21,1015-axis machining centre for new contract…£48,070Electric forklift to replace the diesel …£2,648Production planning software (MRP)−£12,466Second shift on the machining cell−£12,843Take on the unit next door−£328,688Trade shows and an agent in Germany−£37,819

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 by project

Benefit, the chance it delivers, and the tax relief

ProjectBenefit a yearChanceExpectedRunning costSimple returnTax relief todayNPV if half as well
Weld shop fume extraction upgrade
Plant: main rate · 15 years
£00%£0£1,500-18%£14,858−£61,637
Paint booth fire suppression (insurer requirement)
Plant: main rate · 15 years
£4,00090%£3,600£8000%£9,177−£28,947
Inspection machine (CMM)
Plant: main rate · 12 years
£45,00075%£33,750£3,00048%£19,228−£10,560
Replace the 2004 CNC lathe
Plant: main rate · 10 years
£85,00075%£63,750£044%£40,422−£16,251
Fibre laser cutter: bring subcontracted cutting in-house
Plant: main rate · 8 years
£120,00090%£108,000£14,00044%£56,810−£61,064
Delivery van to replace couriers
Plant: main rate · 6 years
£24,00090%£21,600£9,00028%£9,177−£26,413
Solar panels on the factory roof
Plant: special rate · 25 years
£30,00090%£27,000£1,50027%£31,682−£50,726
5-axis machining centre for new contract work
Plant: main rate · 10 years · working capital £40,000
£190,00050%£95,000£12,00025%£69,920−£128,431
Electric forklift to replace the diesel one
Plant: main rate · 7 years
£9,00090%£8,100£021%£7,429−£11,311
Production planning software (MRP)
Deducted as spent · 7 years
£90,00050%£45,000£18,00028%£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,00050%£85,000£78,00015%£2,622−£134,973
Take on the unit next door
Building · 15 years · working capital £30,000
£70,00025%£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,00025%£30,000£25,000-24%£8,740−£62,048
How confident are we?

What this rests on

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.