please answer all parts

Question 1 (11 points) A debt of $25,000 is to be amortized by making payments at the end of every six months for three years. Interest on the debt is 8.5% compounded semi-annually. a. Calculate the amount of the semi-annual loan payments. Copy this table to use in your answer. Beg / End write here P/Y C/Y N 1/Y PV PMT FV Show all your work. b) Using the AMORT function, copy and complete this partial amortization table. b) Using the AMORT function, copy and complete this partial amortization table. Copy this table Payment # Amount Paid Interest Paid Principal Paid Balance 0 (XXX 1 2 3 4 5 6 Totals XXXXXXXXX c) What is the outstanding balance after the 6th payment. d) What is the loan balance after 1 year? Format BIU