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.
