Question 1 (40 points) Start by calculating the payment amount required to pay off the loan END/BEG (1) P/Y (1) Question 1 options A debt of QAR 30,000.00 is to be amortized by making payments at the end of every six months for 3 years. Interest on the debt is 6.5% compounded semi-annually. Note: the number in brackets shows the points value for that blank. 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. C/Y (1) N (2) 1/Y (1) py (1) FV (1) Amount paid Interest pold Principal Pald Balance 0 -55839 -975 46089 25391.1 2 -55839 2 -4758.69 2063241 -5583.9 370 55 15719.06 4 -55839 -510 67 -5073.03 5 55839 -346 -52379541.13 6 B 6 Total interest Paid g Total Cost of loan 10 PMT(4) Start by calculating the payment amount required to pay off the loan Fountain Corp will take a loan of 310,000.00 that is to be amortized by making payments at the end of quarter for 23 years. Interest on the debt is 11% compounded quarterly. Note: the number in brackets shows the points value for that blank END/BEG (1) P/Y (1) 1 Calculate the amount of the semi-annual loan payments. Round to 2 decimal places C/Y (1) 2 -Using the AMORT function, find the values for the blanks in the table below. N (2) I/Y (1) Payment Amount pald Interest paid Principal Pald Balance o 1 per calculation 8,525.00 765.82 309,234.18 BE 15 per calculation 8,171.20 296,014.76 PV (1) 27 per calculation 7,740.38 1.550.44 47 per calculation 2.667.42 238,183.60 FV (1) FINAL 2 PMT(4) Total Interest Paid Total Cost of Loan Question 3 (12 points) Question 3 options: UDC issues a QR. 400,000, 9 year strip bond to yield 4.5% compounded quarterly. Determine the proceeds from the sale of the bond. END/BEG (1) P/Y (1) C/Y (1) N (2) 1/Y (1) PV (3) PMT (1) FV (2)