Your "friend," the loan shark
In this first exercise, you have borrowed $50 from a friend.
This friend that you have borrowed the money from is running a money lending business on the side and has offered to let you pay back the loan in 6 daily installments of $10.
You will fill out the amortization schedule for this loan - while the rate says 5%, this is over the 6-day period. In reality, your annualized interest is over 300%!
This exercise is part of the course
Loan Amortization in Google Sheets
Exercise instructions
- Enter the correct daily payment amount into cell
B4
. - Enter the correct amount borrowed into cell
E4
.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
