need help with highlighted calculations on the first table. For the second table (period, remaining principal, interest/principal payment) Im looking for a formula to autofill ALL slots in the table.

- Thanks :))

here are clearer photos:

Uue the soproprian Enance function to talowate the misving information is the table below: 1210 Choose a loan option that you think will be opcimat for the business and create an amortization schedule for the same. Use the appropriate finance function to calculate the misting information in the table below. Choose u lean eption that vou think will bo optimat far the butiness and Meate an atnorvrrtien whedule for the saene. Uue the soproprian Enance function to talowate the misving information is the table below: 1210 Choose a loan option that you think will be opcimat for the business and create an amortization schedule for the same. Use the appropriate finance function to calculate the misting information in the table below. Choose u lean eption that vou think will bo optimat far the butiness and Meate an atnorvrrtien whedule for the saene