Use the PMT function in Excel to compute the monthly payment on a home each month if you borrowed $530,000 at an annual interest rate of 5.83% 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).