need help with question 10

X fox B E F j L M Rate (in 10. The manager of Clearline Manufacturing is interested in refinancing a loan for either $125,000 or $300,000 and wants to determine the monthly payments. Insert the PMT function into cell E4, to determine the monthly payments. (3 marks) 11. Copy the formula down the range. 12. Format range B4:37, E4:E7 with the accounting style format. Format range C4:C7 with the percentage format. (2 marks) 13. Save the file and close. CLEARLINE MANUFACTURING Refinance Plan Interest Term (in Monthly Lender Amount months) Years) Payments Keystone Mortgage 125000 0.075 10 Keystone Mortgage 300000 0.072 10 Willows Credit Union 125000 0.074 8 Willows Credit Union 300000 0.071 8 X fox B E F j L M Rate (in 10. The manager of Clearline Manufacturing is interested in refinancing a loan for either $125,000 or $300,000 and wants to determine the monthly payments. Insert the PMT function into cell E4, to determine the monthly payments. (3 marks) 11. Copy the formula down the range. 12. Format range B4:37, E4:E7 with the accounting style format. Format range C4:C7 with the percentage format. (2 marks) 13. Save the file and close. CLEARLINE MANUFACTURING Refinance Plan Interest Term (in Monthly Lender Amount months) Years) Payments Keystone Mortgage 125000 0.075 10 Keystone Mortgage 300000 0.072 10 Willows Credit Union 125000 0.074 8 Willows Credit Union 300000 0.071 8