Please solve this ASAP using excel

Question 2 of 9 General Computers Inc. purchased a computer server for $70,500. It paid 40.00% of the value as a down payment and received a loan for the balance at 7.00% compounded semi-annually. It made payments of $2,800.59 at the end of every quarter to settle the loan. a. How many payments are required to settle the loan? 18 payments Question 2 of 9 b. Fill in the partial amortization schedule for the loan, rounding your answers to two decimal places. Payment Interest Portion Payment Number Principal Portion Principal Balance O $42,300.00 Question 2 of 9 $2,800.59 $740.25 $0.00 $0.00 1 $2,800.59 $1,480.50 $0.00 $0.00 2. 30 Question 2 of 9 17 $2,800.59 50.00 0.00 $0.00 X (C) 18 S2,800.59 $0.00 $0.00 0.00 $0.00 $0.00 Total