Please answer using Excel and please include total of payment, interest portion and principal portion in the end and please answer both the parts a and b

Allison received a loan of $33,000 at 5.5% compounded quarterly. She had to make payments at the end of every quarter for a period of 7 years to settle the loan. a. Calculate the size of payments. Round to the nearest cent 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 0 $33,000.00 1 (c) 2 X (8) (X) 27 (3) 28 ... 1 0.00 Total