开始使用免费开始使用

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.

动手互动练习

通过我们的互动练习之一,将理论转化为实践

开始练习