In cell c9, create a formula using the pmt functio to calculate the monthly loan payment using interest rate, and loan period values in cell c4:c8. enter the formula with a