1 * 2 *The monthly amount of loan interest and payment is computed with function 3 * mon_pay(s,p,n):=FIN.PMT(s,p/12,12*n) ACCURACY=2 4 *where 5 * s is the loan amount, 6 * p is the annual interest rate in percentages, and 7 * n is the loan period in years. 8 * 9 *For example, when s=450000, for different interest rates and loan periods 10 *we obtain results like 11 *mon_pay(s,7,10).= 12 *mon_pay(s,7,15).= 13 *mon_pay(s,6.5,15).= 14 *
1 * 2 *The monthly amount of loan interest and payment is computed with function 3 * mon_pay(s,p,n):=FIN.PMT(s,p/12,12*n) ACCURACY=2 4 *where 5 * s is the loan amount, 6 * p is the annual interest rate in percentages, and 7 * n is the loan period in years. 8 * 9 *For example, when s=450000, for different interest rates and loan periods 10 *we obtain results like 11 *mon_pay(s,7,10).=5225 12 *mon_pay(s,7,15).=4045 13 *mon_pay(s,6.5,15).=3920 14 *
This is an example of simultaneous activation (all results in one).