ÎncepețiÎncepe gratuit

Practice with APR

In this exercise, you will get practice using the RATE() function and the PMT() function to calculate APR when there are fees on a loan.

Remember:

  • Points are 0.01% of the opening balance of a loan.
  • Since you put a negative on the PMT() to make it a positive number, you need to put a negative on the payment in the RATE() function to calculate properly.
  • To fully amortize a loan, all fees need to be included before calculating payments.

Acest exercițiu face parte din cursul

Amortizarea împrumuturilor în Google Sheets

Vezi cursul

Instrucțiuni pentru exercițiu

  • In column G, fill in the correct fee based on the principal and number of points.
  • In column E, fill in the PMT() formula based on the principal and fees.
  • In column H, calculate the APR using the RATE() function.

Exercițiu interactiv practic

Transformă teoria în practică cu unul dintre exercițiile noastre interactive

Începe exercițiul