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.

The IRR formula is complex, so it's rarely calculated manually. In most cases, investors use an IRR calculator or an Excel spreadsheet, which has a built-in function to determine a project's IRR.