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.
Este ejercicio forma parte del curso
Loan Amortization in Google Sheets
Instrucciones del ejercicio
- 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.)
Ejercicio interactivo práctico
Pon en práctica la teoría con uno de nuestros ejercicios interactivos
Empieza el ejercicio