Get startedGet started for free

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

View Course

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

Start Exercise