Differences

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

--- syntax:functions:ipmt [2021/10/23 20:45] – created craigt
+++ syntax:functions:ipmt [2021/10/24 00:32] (current) – minor edits, updated See Also section craigt
@@ Line 1: / Line 1: @@
-====== IPMT(rate, per, num_per, curr_val) ======
+====== IPmt(rate, per, num_per, curr_val) ======
 Category:  Number (Financial) function
@@ Line 9: / Line 9: @@
 =====Additional syntax=====
 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.
-  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.
-  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 =====
-  * [[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)]]