The Excel formula for calculating the discount rate is =RATE (nper ... We can therefore just take our calculated IRR and put ...