Use the pmt function in excel to compute the monthly payment on a home each month if you borrowed $400,000 at an annual interest rate of 5.39% over 30 years, where the interest is compounded monthly. hint: the pmt (payment) function is entered in excel as =pmt(rate, nper, pv, fv, type).