please answer both the parts (Ms excel is preferred as you have to make an ammortization table)

Question 6 of 7 Caleb purchased a machine for $25,000 for her company. She paid 5.00% of this amount as a down payment and financed the rest at 5.52% compounded monthly. She paid $1,125 at the end of every month to settle the loan. a. What was the principal portion of payment number 4? Round to the nearest cent Question 6 of 7 a. What was the principal portion of payment number 4? Round to the nearest cent b. What was the interest portion of payment number 42 Round to the nearest cent