You can solve for the discount rate in Excel in two ways: Find the IRR in Excel by employing the IRR function, then use it as ...

Excel has three functions to calculate the IRR ... Getty Images IRR computes the rate of return that results in a net present value (NPV) equal to zero. NPV is the difference between the present ...