User Tools

Site Tools


syntax:functions:ipmt

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

syntax:functions:ipmt [2021/10/23 20:45]
craigt created
syntax:functions:ipmt [2021/10/24 00:32] (current)
craigt minor edits, updated See Also section
Line 1: Line 1:
-====== IPMT(rate, per, num_per, curr_val) ======+====== IPmt(rate, per, num_per, curr_val) ======
 Category:  Number (Financial) function Category:  Number (Financial) function
  
Line 9: Line 9:
 =====Additional syntax===== =====Additional syntax=====
 Optional //future value// (fut_val) argument. Optional //future value// (fut_val) argument.
-  IPMT(rate, per, num_per, curr_val, fut_val)+  IPmt(rate, per, num_per, curr_val, fut_val)
 \\  \\ 
 Optional //payments due// (pay_due) argument. Optional //payments due// (pay_due) argument.
-  IPMT(rate, per, num_per, curr_val, fut_val, pay_due)+  IPmt(rate, per, num_per, curr_val, fut_val, pay_due)
  
 \\  \\ 
Line 40: Line 40:
 \\  \\ 
 ** Calculate the monthly interest payment for period 20:**  Annual rate of 10%, number of periods is 2 years, value is $8,000, final value is 0 (paid off), with payments due at the end of the period. ** Calculate the monthly interest payment for period 20:**  Annual rate of 10%, number of periods is 2 years, value is $8,000, final value is 0 (paid off), with payments due at the end of the period.
-  ipmt(0.10/12,20, 2*12, 8000,0,1)  //Returns -14.88 (monthly payment, rounded)+  ipmt(0.10/12,20, 2*12, 8000, 0, 1)  //Returns -14.88 (monthly payment, rounded)
  
 \\  \\ 
Line 48: Line 48:
 \\  \\ 
 ===== See also ===== ===== See also =====
-  * [[syntax:functions:ppmt|PMT(rate, num_per, curr_val)]] +  * [[syntax:functions:fv|FV(rate, num_per, payment)]] 
-  * [[syntax:functions:ppmt|PPMT(rate, num_per, curr_val)]] +  * [[syntax:functions:nper|NPer(rate, payment, curr_val)]] 
 +  * [[syntax:functions:pmt|Pmt(rate, num_per, curr_val)]] 
 +  * [[syntax:functions:ppmt|PPmt(rate, num_per, curr_val)]] 
 +  * [[syntax:functions:pv|PV(rate, num_per, payment)]] 
 +  * [[syntax:functions:rate|Rate(num_per, payment, curr_val)]]
syntax/functions/ipmt.txt · Last modified: 2021/10/24 00:32 by craigt