=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 kommentar(er)
