Fountain Corp will take a loan of 280000.00 that is to be amortized by making payments at the end of quarter for 29 years. Interest on the debt is 12.00% compounded quarterly. 1 - Calculate the amount of the semi-annual loan payments. Round to 2 decimal places 2 - Using the AMORT function, find the values for the blanks in the table below. Amount paid Interest paid Principal Paid Balance Payment # 0 8,400.00 281.50 278,718.50 1 per calculation 8,255.71 2 274,764.41 15 per calculation 8,047.42 607.08 3 27 per calculation 4 1,096.45 251,738.38 47 per calculation ED Ali Yahya: Attempt 1 Amount paid Interest paid Principal Paid Balance Payment # 0 1 per calculation 8,400.00 281.50 278,718.50 15 per calculation 8,255.71 2 274,764.41 27 per calculation 8,047.42 607.08 3 47 per calculation 1,096.45 251,738.38 7 6 5 8 FINAL Total Interest Paid Total Cost of Loan 9 10 Start by calculating the payment amount required to pay off the loan Start by calculating the payment amount required to pay off the loan NOTE: the number in brackets shows the points value for that blank. It does not form part of your calculations. END/BEG (1) P/Y (1) C/Y (1) N (2) 1/Y (1 All 60... M Connect Purchase Post Attendee - Zo. G Google VitalSource FN1120 - Assignment 4 - Winter 2021 Est. Length: 25:00:00 Ali Yahya: Attempt 1 Page 1: 2 3 I/Y (1) 4 in > PV (1) FV (1) PMT(4) 2 - Using the AMORT Function fill in the blanks from the amortization schedule shown above. UJIben 4 Winter 2021 ength: 25:00:00 Ali Yahya: Attempt 1 1: 2 - Using the AMORT Function fill in the blanks from the amortization schedule shown above. 2 3 1 - Balance at the beginning of the loan (1) un 2 - Principal paid as part of the 15th payment (2) 3 - Balance owing after the 27th payment (2) 4 - Interest paid as part of the 47th payment (2) 5- Balance owing after the final payment (1) 0 Assignment 4 - Winter 2021 est. Length: 25:00:00 Ali Yahya: Attempt 1 Page 1: 6 - Principal paid with the final payment (4) 1 3 2. 7 - Interest paid with the final payment (4) u 8 - Amount of final payment (4) 9 - Total interest paid on the loan (4) 10 - Total cost of the loan (4) o 0