Entering loan terms
In this exercise, you will enter the number of annual payment periods and the payment formula for non-annual repayments.
All the rates and terms are provided.
There are 52 annual weekly payments, 12 annual monthly payments, and 4 annual quarterly payments.
Deze oefening maakt deel uit van de cursus
Loan Amortization in Google Sheets
Oefeninstructies
- Enter the correct number of annual payments in column
F. This is the total per year, not the total overall. - Enter the correct
PMT()formula in columnG. - Remember to put a negative before the
PMT()formula!
Praktische interactieve oefening
Zet theorie om in actie met een van onze interactieve oefeningen.
Begin met trainen