can anyone explain the excel method for this question please?

A design studio received a loan of $9,600 at 3.70% compounded semi-annually to purchase a camera. If they settled the loan in 3 years by making quarterly payments, construct the amortization schedule for the loan and answer the following questions: a. What was the payment size? Round to the nearest cent b. What was the size of the interest portion on the first payment? b. What was the size of the interest portion on the first payment? Round to the nearest cent c. What was the balance of the loan at end of the first year? Round to the nearest cent d. What was the size of the interest portion on the last payment