Hi. Please help and provide all steps and functions! My course requires the use of functions even when there is an easier way. Thanks!

X Calibri (Body) 11 Enable Editing PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. B I ab Paste x x Aav A A Paragraph Styles Editing Dictate Sensitivity Editor Reuse Files A21 VIX fx & A O A D E F G H J K Undo Clipboard Font Styles Voice Sensitivity Editor Reuse Files A B Monthly Mortgage 2 Mortgage principal $ 240,000 3 Annual interest rate 8.00% 4 5 6 7 1. Your local bank has offered you a 15-year, $240,000 mortgage. The bank is charging 1.5 points, with "processing" costs of $800; both points and processing costs are deducted from the mortgage when it is given. The mortgage carries an 8% annual interest rate and is paid in equal monthly payments. (8 points) a. Calculate the monthly payment on the mortgage, show the amortization table, and compute the EAIR. b. Use Cumipmt to get the total interest paid over the duration of the loan. 9 10 11 12 13 14 15 16 17 18