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.
この演習はコースの一部です
Google Sheetsで学ぶローン返済（アモチゼーション）
演習の手順
- 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.)
