Estimate project NPV, a unique IRR and end-year payback from an upfront cost, constant annual net cash and residual proceeds.
The interactive form requires JavaScript. The worked example, formulas and source links below remain available.
Read the calculator result
A machine can improve capacity or reduce labor time without immediately producing enough cash to justify its purchase. This calculator connects an upfront outlay with an assumed annual net cash benefit and final sale proceeds. It calculates net present value, a modeled internal rate of return, and the year-end dates when the initial cost is recovered.
The tool is designed for a simple project: one initial investment, the same nonnegative operating cash inflow every year, and an optional residual receipt in the final year. It’s useful for screening an equipment proposal before constructing a more detailed budget. It doesn’t forecast demand, verify a supplier’s performance claims, arrange financing, or determine a tax deduction.
The most valuable part of the exercise is often documenting the cash-flow assumption. A precise formula can’t rescue a benefit estimate that counts unfilled capacity as sales or treats time saved as payroll cash that will actually remain unchanged.
Equipment investment: build the initial cost and annual cash estimate
Enter the upfront equipment investment as the cash committed at time zero. Include installation, setup, or other initial project costs if they belong in the scenario. Don’t enter only a financing down payment while also using cash benefits intended to justify the entire asset; that would mix a project comparison with an incomplete borrowing model.
Annual net cash inflow is the expected annual cash benefit after the relevant operating costs you have chosen to include. For a replacement machine, it might consist of incremental revenue and cash cost savings, less added maintenance, supplies, power, and other operating outlays. Existing revenue that continues regardless of the purchase isn’t automatically a new project benefit.
Use cash timing consistently. A large customer order that won’t be collected until a later period doesn’t support an earlier year-end cash inflow merely because it’s recorded as revenue. The model assumes each annual net amount is received at that year’s end.
Iowa State Extension’s capital-budgeting guidance distinguishes project cash flows from accounting profit and describes present-value and payback methods. Depreciation is a noncash allocation; tax effects associated with it require a separate cash-flow estimate. This calculator doesn’t automatically add those effects.
How the calculator works
The evaluation life is a whole number of years over which the same annual net inflow is modeled. The residual input is an additional receipt at the end of the final year. It should represent the sale proceeds available under your assumption, after any sale-related costs you have already considered. It isn’t added in every year.
Don’t add a separate perpetual value to the result. The calculator stops at the chosen life and includes only the entered residual receipt. If the equipment will be kept longer, a longer life with defensible cash estimates is a different scenario.
The annual discount rate expresses the return requirement or opportunity-cost assumption used to value future cash today. It’s supplied by you and isn’t automatically the loan rate, an observed market return, or a guarantee. A higher positive discount rate gives less present value to the same future receipts.
How NPV, IRR, and payback differ
Let C be the initial cost, A the annual operating cash inflow, S the final residual receipt, n the life, and r the annual discount rate as a decimal. NPV = −C + sum of A ÷ (1 + r)t for years 1 through n + S ÷ (1 + r)n. Present value of inflows is the discounted receipt total before subtracting C.
Internal rate of return, or IRR, is the rate that makes this projected cash-flow NPV zero. This restricted cash pattern has one initial outflow and nonnegative later inflows. When any later cash is positive, it has a unique IRR above −100%, which may itself be negative. With no later receipts, IRR is undefined.
OpenStax’s capital-investment lesson explains the distinction between discounting cash flows into a dollar value and solving for an internal rate. Here, both measures describe the entered projections. Neither is an observed return already earned by the equipment.
Simple payback is the first full year-end when cumulative receipts recover the initial cost. Discounted payback uses discounted receipts instead. Both include final residual proceeds when relevant. This calculator doesn’t interpolate a fraction of a year between receipts that are expressly assumed to arrive at year-end.
Equipment investment calculator example: a $50,000 equipment purchase
Suppose equipment requires $50,000 now, produces $14,000 of net cash at each year-end for five years, and returns another $5,000 when sold at the end of year five. Use a 10% annual discount rate for this illustration.
| Year | Cash receipt | Present value | Cumulative net cash | Cumulative discounted net cash |
|---|---|---|---|---|
| 0 | −$50,000.00 | −$50,000.00 | −$50,000.00 | −$50,000.00 |
| 1 | $14,000.00 | $12,727.27 | −$36,000.00 | −$37,272.73 |
| 2 | $14,000.00 | $11,570.25 | −$22,000.00 | −$25,702.48 |
| 3 | $14,000.00 | $10,518.41 | −$8,000.00 | −$15,184.07 |
| 4 | $14,000.00 | $9,562.19 | $6,000.00 | −$5,621.88 |
| 5 | $19,000.00 | $11,797.51 | $25,000.00 | $6,175.62 |
Total undiscounted receipts are $75,000, leaving a $25,000 undiscounted gain after the initial investment. Their present value at 10% is $56,175.62, so NPV is $6,175.62. The projected IRR is approximately 14.53%.
Simple payback occurs at the end of year four. Discounted payback occurs at the end of year five. At year four the project has recovered its initial dollars in nominal terms, but its discounted receipts are still $5,621.88 short. The final year supplies the remaining discounted recovery.
Test weaker cash benefits before relying on a positive NPV
Reduce annual net cash to $10,000 while leaving the $50,000 cost, five-year life, $5,000 residual, and 10% discount rate unchanged. Total receipts are still $55,000, which exceed the initial cost by $5,000 in undiscounted dollars.
NPV, however, becomes −$8,987.53 and the modeled IRR falls to about 3.07%. Simple payback occurs at year five; discounted payback isn’t reached within the evaluation life. Recovering more nominal cash than you spent doesn’t necessarily meet the chosen return requirement.
As another check, set only the original example’s discount rate to zero. NPV becomes $25,000, and ordinary and discounted payback both occur at year four. The IRR doesn’t change because it’s solved from the cash flows themselves, independently of the discount rate chosen for the NPV comparison.
Read the chart as a cash-flow model
The chart begins at the negative initial investment and shows cumulative net cash and cumulative discounted net cash at each year-end. A line crossing zero identifies the modeled recovery point under its method. The two lines aren’t separate streams of money that should be added together.
The final jump includes the residual receipt once. If most recovery depends on that receipt, investigate the assumption carefully. A specialized asset may be difficult to sell at the projected price or date; the calculator doesn’t validate a resale market.
Payback also omits information that NPV retains. Once the initial cost is recovered, later cash still contributes to NPV. Two projects with the same payback year can have different lives, later benefits, risk, and scale. A single recovery date doesn’t summarize all of those differences.
Turn the project screen into an operating plan
Document where each benefit comes from: additional accepted units, avoided downtime, reduced consumable spending, or a specific cash expense that will disappear. Check whether staff time saved actually reduces payroll or instead creates capacity that needs customers before it generates revenue.
Then stress the annual benefit, initial cost, useful life, and residual separately. A result that remains positive under modest changes is different from one that depends on a precise resale price or full utilization immediately after installation. These are scenario tests, not probabilities of success.
If borrowing will finance the purchase, prepare a separate payment calendar. A project can have positive NPV and still need additional working cash before its benefits arrive. This annual model doesn’t establish that a monthly installment can be paid on its due date. Reconcile the financing plan with actual collections and reserves instead of interpreting the year-end surplus as cash available throughout the year.
Use the make vs buy calculator for same-period production and supplier costs, the business break-even calculator for contribution needed to cover fixed costs, and the straight-line depreciation calculator for a separate book-expense schedule.
The model can’t represent negative annual operating cash, irregular overhaul payments, different annual benefits, or a negative net disposal cost directly. Averaging those cash flows into one annual number can change their present value. Use a dated cash-flow model when the timing is material, and keep financing and tax treatment consistent with the comparison’s purpose.
Equipment investment calculator questions
Does positive NPV mean the purchase is approved?
No. It means the projected receipts exceed the initial cost after discounting at the entered rate. Funding, execution, capacity, and uncertainty remain separate decisions.
Why is simple payback a whole year?
Receipts occur at year-end in this model. The calculator reports the first actual modeled receipt date that completes recovery, without assuming cash arrives evenly between those dates.
Is IRR available when no cash comes back?
No. With zero annual inflow and zero residual, there’s no future receipt stream that can recover the initial investment. NPV remains negative and IRR is undefined.
Does this calculate tax depreciation?
No. It evaluates cash flows. Tax depreciation, deductions, financing payments, and applicable tax rules aren’t automatically included.
Questions or corrections?
Send a question or report an issue with a published page.