The yearly return an investment earns on its cash flows.
Your figures
Keep units consistent: kg with kg, minutes with minutes. Results update as you type.
IRR
—
Total cash back
—
Formula
The discount rate at which the net present value is zero
=IRR(B2:B12)Excel: the investment as a negative number in B2, then each year's cash flow down column B
Save this calculation
Enter your figures (or try the worked example) to save them.
General calculation. Confirm your site's own definitions, validated limits and specifications before using a result for process control or product release.