CapEx Payback and NPV Calculator for Manufacturing Investments
This free CapEx payback and NPV calculator builds the financial case for an equipment, automation, or ERP investment, and is designed for plant managers, engineering leaders, IT directors, and CFOs at discrete manufacturers. Enter capital cost, implementation cost, annual savings, incremental operating cost, analysis period, discount rate, and salvage value, and the tool returns simple payback, net present value, and lifetime ROI. Capital requests fail far more often on missing implementation cost and inflated savings than on a weak asset, so the model forces both onto the page where a review committee can see them.
Your numbers
Purchase price of the asset, software licenses, or subscription prepayment.
Rigging, integration, training, consulting, and internal time consumed at go-live.
Labor avoided, scrap reduced, capacity added, or margin gained. Use cash, not accounting profit.
Maintenance contracts, subscription fees, added utilities, and support headcount.
How long the benefit stream is credible. Be conservative; finance discounts optimistic horizons.
Your weighted average cost of capital or the internal hurdle rate finance applies to projects.
Realistic resale value at the end of the analysis period. Use zero for software.
Your results
Estimates only. This model assumes level annual cash flows and ignores tax effects, bonus depreciation, and financing structure. Have finance validate the after-tax case before submitting a capital request.
Get your full investment case analysis
We will email you a personalized expert breakdown of your payback and NPV scenarios with sensitivity ranges, and a Netray manufacturing systems specialist will follow up with concrete next steps.
No spam. Your results stay private. Unsubscribe anytime.
How payback and NPV are calculated here
Total outlay is capital plus implementation, so $750,000 of equipment with $120,000 of installation and training is $870,000. Net annual cash flow is savings less incremental operating cost, so $245,000 less $35,000 is $210,000. Simple payback divides outlay by that flow, giving about 4.1 years. Net present value discounts seven years of $210,000 at 10%, which is a present value of roughly $1.02 million, adds the discounted $60,000 salvage, and subtracts the $870,000 outlay, leaving an NPV near $183,000. Lifetime ROI ignores discounting entirely and compares total return to outlay, producing about 76%. Payback tells you about risk; NPV tells you about value.
Hurdle rates and payback expectations
Different investment types face different bars in manufacturing, and knowing which bar applies before you build the case saves a rejected submission and a quarter of lost momentum. A capacity project competing against a productivity project on the same criteria will usually lose, because capacity spending is larger and slower to pay back even when the strategic case is stronger. Ask finance which lens they will apply before you start modeling. These are the thresholds we most often see applied in mid-market discrete manufacturers, and they tighten noticeably when the company is carrying debt covenants or operating under private equity ownership.
- Capacity expansion with a signed customer commitment is often approved at three to four year payback.
- Productivity and automation projects typically need to clear two to three years to compete for capital.
- ERP and systems investments are usually evaluated on NPV over five to seven years rather than payback.
- Compliance-driven spending such as CMMC or ITAR remediation is evaluated on risk avoided, not payback.
Where capital requests actually fail
Three patterns account for most rejections. Implementation cost is understated, often by half, because internal labor, training downtime, and integration work never make the request. Savings are double counted against another project that already claimed the same headcount or the same scrap reduction. And the analysis period stretches to ten or twelve years to make the NPV work, which finance discounts heavily because technology and demand assumptions do not survive that long. Before you submit, name the person who will sign for each savings line, cut the horizon to what you would personally defend, and show the NPV at a discount rate two points above the official hurdle.
How Netray builds defensible investment cases
Netray builds capital business cases from your own ERP data rather than from vendor claims. We pull actual labor hours, scrap dollars, downtime, and margin by product from SyteLine, LN, Baan, or M3 to size the savings, and we scope implementation cost from real project history rather than optimistic estimates. For automation and on-prem AI projects we run a bounded pilot first so the savings number in the capital request is measured rather than modeled. Everything runs inside your firewall, which keeps ITAR and CMMC obligations intact while the business case gets built.
Frequently Asked Questions
Should I use payback or NPV to justify a project?
Use both, because they answer different questions. Payback measures how long your capital is exposed, which is what operations leaders and lenders care about when demand is uncertain. NPV measures how much value the project creates after accounting for the cost of capital, which is what a CFO evaluates when ranking competing requests. A project with a three-year payback and a negative NPV is destroying value slowly; one with a five-year payback and a large NPV may still be the best use of capital.
How conservative should the savings estimate be?
Conservative enough that you would personally commit to delivering it. A practical discipline is to build the case at 70% of the engineering estimate and check that it still clears the hurdle rate. If the project only works at 100% realization, it will not survive contact with reality, because ramp-up, training, and process adjustment always consume part of the first year. Naming an owner for each savings line and reporting against it post-implementation also improves the quality of future requests dramatically.
How should ERP and software projects be evaluated differently?
Software rarely has a salvage value, and its benefits accrue as avoided cost, faster decisions, and reduced working capital rather than as direct labor savings. Use NPV over five to seven years, set salvage to zero, and include ongoing subscription and support as operating cost so the total cost of ownership is honest. Where benefits are genuinely hard to quantify, such as audit readiness or compliance posture, present them separately as risk reduction rather than forcing a dollar figure into the cash flow.
Get a personalized investment case review and a data-backed savings model from Netray's manufacturing systems specialists.
Related Tools
Machine Hour Rate Calculator
Build a defensible machine hour rate from depreciation, maintenance, energy, and facility overhead, and see how utilization changes the number.
ERP OperationsWorking Capital Release Calculator
Compute days inventory, days sales outstanding, and your cash conversion cycle, then see how much cash a realistic improvement target would free up.
ERP OperationsFinancial Close Cycle Time Calculator
Quantify the labor hours and annual cost consumed by manual journal entries and reconciliations, and model a realistic automated close target.
Go Deeper
Finite Capacity Scheduling: A Practical Guide
Finite capacity scheduling explained: how it differs from infinite MRP loading, APS options for SyteLine and LN, data prerequisites, and AI-assisted scheduling.
Multi-Site ERP Deployment: Strategies and Pitfalls
Plan multi-site ERP deployment successfully. Single instance vs multi-instance, rollout sequencing, data harmonization, and template-based approaches.