Shelly Cashman Office 365 Intermediate Excel 4 Lab 2 (pages EX238 - EX240)

Enter 16.99% in cell C5, 48 in cell C6, and 6000 in cell C7. Apply the comma style format to cell C7. Determine the monthly payment amount by entering the PMT function in cell C8. (Hint:Unlike the module project, in this example the term is expressed in months, not years. The interest rate remains an annual rate, however. Adjust your use of the function accordingly.)