question a is obvious. the confusing part is filling out this table for question b

3. A $20,000 loan requires equal annual end-of-year payments for four years. EXCEL The interest rate is 10 percent. a. What is the amount of each loan payment? b. Construct a loan amortization schedule to include the amount of interest. and principal paid each year as well as the remaining balance at the end of each year