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 discount rate is a critical input of the DCF model. Here is an example, using the calculator at GuruFocus to determine the fair, or present, value of Microsoft (NASDAQ:MSFT) and starting with ...