Please solve using excel function

A C D E F G H J 1 Problem 5-47 N Loan payment. Determine the equal, end-of-year payment required each year over the life of the loans shown in the following table to repay them fully during the stated term of the loan. 3 4 5 Loan 6 Term of loan (years) 3 10 $ 7 Principal 12,000 60,000 75,000 4.000 A B D Interest rate 8% 12 10 15 00 30 ON 5 10 D E F F c Solution 11 12 13 14 15 16 17 18 Loan A Number of years Annual interest rate Present value Annual deposit 3 8% 12,000 $ 13 20 21 22 Loan B Number of years Annual interest rate Present valve Annual deposit 10 12% 60,000 $ 23 24 Loan C Number of years Annual interest rate Present valve Annual deposit 30 10% 75,000 $ 25 26 27 28 29 30 31 32 33 34 35 36 Loan D Number of years Annual interest rate Present valve Annual deposit 5 15% 4,000 $ c E F G H J Points 1 39 1 40 38 Requirements 1 In cell E17, by using cell references to the given data and the function PMT, calculate the annual payment for loan A. Note: the annual payment will be a negative valve since it is a cash outflow. 2 In cell E23, by using cell references to the given data and the function PMT, calculate the annual payment for loan B. Note: the annual payment will be a negative valve since it is a cash outflow. 3 In cell E29, by using cell references to the given data and the function PMT, calculate the annual payment for loan C. Note: the annual payment will be a negative valve since it is a cash outflow. 4 In cell E35, by using cell references to the given data and the function PMT, calculate the annual payment for loan D. Note: the annual payment will be a negative valve since it is a cash outflow. 5 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 41 1 42 43 0