Please make an ammortization table using excel and solve all the parts also at the last give the total of payment, interest portion, and principal portion

Question 2 of 7 General Computers Inc. purchased a computer server for $54,500. It paid 45.00% of the value as a down payment and received a loan for the balance at 5.50% compounded semi-annually. It made payments of $2,350.84 at the end of every quarter to settle the loan. a. How many payments are required to settle the loan? 15 payments Round up to the next payment Question 2 of 7 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 $29,975.00 0 $2.350.84 $409.36 $1,941.48 $28,033.52 1 K 7 Question 2 of 7 $2,350.84 $382.84 $1,968.00 $26.065.52 2 :: :: 14 $2,350.84 $34.85 $2,316.00 $236.00 1 Question 2 of 7 14 $2.350.84 $34.85 $2,316.00 $236.00 X 15 $238.50 $3.21 $235.29 0.00 x S0.00 $0.00 0 Total