In Excel, you find the IRR using the "=IRR()" function with a discount rate of zero.

Name: In Excel, you find the IRR using the "=IRR()" function with a discount rate of zero.
Brand: Quizplus
Rating: 4.8 (39 reviews)

Question

Quizplus · Accepted Answer

The "=IRR()" function in Excel calculates the internal rate of return for a series of cash flows represented by the numbers in the function's argument. It does not require a discount rate; instead, it estimates the rate of return where the net present value of the cash flows equals zero.

In Excel, You Find the IRR Using the "=IRR()" Function