Return on investment and payback
General calculation · any country
Before investing in equipment, a refurbishment or a project, check how much it returns and how long it takes to get your money back.
Total return (ROI)
—
Payback period
—
Discounted payback
—
Net gain
—
Net present value (NPV)
—
See year-by-year detail
| Year | Cash flow | Cumulative | Discounted cumulative |
|---|
How it is calculated
- ROI = (sum of cash flows − investment) ÷ investment.
- Payback: the point where the cumulative total stops being negative, assuming cash arrives evenly within each year.
- With a discount rate, each year is divided by (1 + rate)^year: discounted payback, and NPV = sum of discounted cash flows − investment.
Assumptions
- Net cash flows at the end of each year.
- No taxes or inflation unless you include them in the cash flows.
- Total ROI ignores when the money arrives; NPV does not.