Step Instruction 12 Use the SUM function in cell G7 to calculate the total amount paid over the course of the loan. Use the SUM function in cell G8 to calculate the total interest paid over the course of the loan Both functions should return negative values 13 Format all cells containing dollar amounts to currency, if necessary. Format all colls containing dates to display the Calon DA Pe 11AA 2 Wrap Text - A. Merge & Center General BIU $ - % Clipboard Font Alignment 16 Number 5 f A 1 D E I Wanna Cool Boat! F G 2 3 4 5 Enter Loan Parameters as indicated Principal $65,000 Annual interest 8.50% Date of First Payment 9/1/2017 Term of Lanyar Term Loan (month) 50 Loan Summary Information Monthly Payment J$1.333.57 Payoff Date 8/1/2022 7 3 9 Total S Payments to Make Total interest to be paid Paymen Number 10 Date 11 12 Interest Pald 1 2 Principal Reduction Ending Balance 1 15 4 5 Beginning Regular Balance Payment 5/1/2017 565.000 1.33.57 10/1/2017 $54,126.84 ($1:333.57) 11/11/2017 563,267.50 151 13357) 12/1/2017 562,16153 154 13157 1/1/2018 $61.470.05.17 1/2018 560,57232 (513137 sh/2018 599,06740 A1120155.79547 1511357 25 57,30 San 1/2 556,91520 L1 12 11 7 5460:42 54543 11.00 546173 -$4154 942905 -942264 -$4159 -S485 4.15 -873.1578696 -879 3427373 35 5714156 891 442131 198 1694 -1055234198 330330450 - 97.382343 11 564,126.84 563.247.50 $62361.93 $61.470.OR 560, 571 $59.867.40 $S756,47 $37.339.00 555,915.20 $55.954.7 DEL 530.051708 Preto O 5 2 7 es 2 3 4 % 5 & 77 Q W GO 8 9 E R