시작하기무료로 시작하기

Max interest rate with APR

This example brings in every concept from this chapter - but all you will need to fill in is the maximum interest rate. In this case, there is an amortizing fee on the loan that needs to be taken into account when calculating the maximum interest rate.

The only difference between having a fee and having no fee for the purpose of maximum interest rate is that the monthly payment changes. Fill in the maximum interest rate using the APR rate instead of the loan rate, then calculate the annualized max rate!

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

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

강의 보기

연습 안내

  • Add in the monthly payment from the APR function in cell B27.
  • Calculate the maximum monthly rate in cell B28.
  • Annualize the maximum rate in cell B29.

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

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

연습 시작