Start Excel. Download, save, and open the workbook named g016_xi_ch04_grader_4e_as.xisx. In cell 35. insert the PMT function using the data from the range 32:34be sure to divide the interest rate by 12, multiply the years by 12, and display the payment as a positive number. 0.000 10.000 Use Goal Seek to change the amount of the loan so that the payment is $4,200 [4200). 8.000 In cell A1r apply the Title cell style. In AT. type Option #1 Reduce the Loan and then Copy the format from cell A1 to cell Air'. Copy the range A2:35. and then Paste the Values 8.: Number Formatting to cell A8. In cell 32, type 425000 to restore the original ioan amount. Use Goal Seek to change the period of the loan so that the payment is $4,200. In A13, type lI0ption #2 Increase Years. Format the cell the same as cell A7. Copy the range A235. and then Paste the Values EL Number Formatting to cell A14. Display the value in 315 with two decimal places, and then in cell 33. type 10 to restore the original value. On the Payment Table worksheet. in the range A2:34. enter the following row titles and data. Format the Amount of Loan as Currency with 0 decimals. Format the Interest as Percentage with 2 decimals. Amount of Loan $425,000 Period [months] 120 Interest rate {per year} 5.25% In cell C8, type 60the number of months in a 5year loan. In D8, type 120the number of months in a 10year loan. Fill the series through cell H8. Apply Bold and center the range C3:H8. In the range 391316, enter varying interest rates in decrements of .5% beginning with 2.0% and ending with 3.5%. If necessary format all the interest rates with two decimal places, and then bold and center the range. 4.000 8.000 4.000 8.000 4.000 4.000 10 In cell 33, entera PMT function using the infom'ration in cells 32:34. Be sure that you convert the interest rate to a monthly rate and that the result displays as a positive number. 8.000