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.................