Doing so allows us to determine the internal ... 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 the discount rate ...