시작하기무료로 시작하기

Maximum annual rate

On floating rate loans, when a condition is breached such as amortization exceeding a certain amount of time or becoming negative, the payment is adjusted on the loan. For this course, the condition will be that negative amortization cannot occur.

The maximum interest rate is the point where the entire payment goes to the interest payment, and none is used to pay down the principal. The rate will increase over the term of the loan, but the lowest point will be in the first period.

Calculate the maximum rate with the formula: Payment Amount / Opening Balance. Remember, this is a periodic rate, which needs to be annualized!

이 연습은 강의의 일부입니다

Google Sheets로 하는 대출 상환 일정표

강의 보기

연습 안내

  • Add the PMT() formula for a monthly installment into cell B12.
  • Calculate the periodic maximum interest rate in cell B13.
  • Annualize the rate in cell B14.

실습형 인터랙티브 연습문제

이론을 실습으로 바꾸는 인터랙티브 연습 중 하나를 만나보세요

연습 시작