answer needs to be entered by formula not numbers

Excel assignment

Loan amount $ 67,500 Interest rate 7% Loan term 5 Complete the following analysis. Do not hard code values in your calculations. All answers should be positive.

Loan payment:.....................

year- beginning balance- total payment- interest paid- principal paid- ending balance

1

2

3

4

5

Total interest paid.................