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 theRATE()function to calculate properly. - To fully amortize a loan, all fees need to be included before calculating payments.
本练习是课程的一部分
在 Google Sheets 中进行贷款摊销
练习说明
- In column
G, fill in the correct fee based on the principal and number of points. - In column
E, fill in thePMT()formula based on the principal and fees. - In column
H, calculate the APR using theRATE()function.
