It is used to calculate the net present value of future cash flows from a project and to compare this amount to the initial investment. The discount factor used in this calculation is the company ...

Let’s assume that we didn’t calculate the IRR of 57% as we did above and have no idea what the correct discount rate is. We can use Excel’s What-If calculator in this case.