![]() =IPMT(rate, period, number_of_periods, present_value, ,) IPMT(): The IPMT function calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate. =PPMT(rate, period, number_of_periods, present_value, ) PPMT(): The PPMT function calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate. You can calculate these principal and interest payments using using PPMT() and IPMT() equation. ![]() However, your principal and interest are not the same each month. In the above section, we calculated the total payment you need to pay to the bank each month. ![]() Calculating the amount of principal and interest for each month ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |