Paying off your student loan in 1 year
No more borrowing money from your "friend" anymore! In this exercise, you have decided to pay off your $10,000 student loan in 1 year.
The bank has offered you $850 monthly installments, which equates to a 3.67% annualized interest rate.
The monthly interest rate of 0.31% is the annual rate divided by 12. You know that the interest is paid at the end of the period, so you can multiply the opening balance by the monthly interest rate to get the interest paid.
You are trying to find out what your interest is every month.
Cet exercice fait partie du cours
Loan Amortization in Google Sheets
Instructions
- In column
C, enter the correct interest in every month by multiplying the opening balance by the interest rate in cellB17. - Copy the formula down to every cell until the closing balance becomes zero. (In this case, the balance will be -$0.10; this is due to rounding.)
Exercice interactif pratique
Passez de la théorie à la pratique avec l’un de nos exercices interactifs
Commencer l’exercice