Differences

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

--- syntax:functions:ppmt [2021/10/23 16:49] – created craigt
+++ syntax:functions:ppmt [2021/10/24 00:29] (current) – minor edits, updated See Also section craigt
@@ Line 1: / Line 1: @@
-====== PPMT(rate, per, num_per, curr_val) ======
+====== PPmt(rate, per, num_per, curr_val) ======
 Category:  Number (Financial) function
@@ Line 9: / Line 9: @@
 =====Additional syntax=====
 Optional //future value// (fut_val) argument.
-  PPMT(rate, per, num_per, curr_val, fut_val)
+  PPmt(rate, per, num_per, curr_val, fut_val)
 \\
 Optional //payments due// (pay_due) argument.
-  PPMT(rate, per, num_per, curr_val, fut_val, pay_due)
+  PPmt(rate, per, num_per, curr_val, fut_val, pay_due)
 \\
@@ Line 33: / Line 33: @@
 \\
 =====Examples=====
-** Calculate the annual payment for period 1:**  Annual rate of 8%, for period 1, number of periods is 3 years, value is $20,000, (final value = default, 0).
+** Calculate the annual principal payment for period 1:**  Annual rate of 8%, for period 1, number of periods is 3 years, value is $20,000, (final value = default, 0).
   ppmt(0.08, 1,  3, 20000) //Returns -6160.67 (annual payment, rounded)
 \\
-** Calculate the monthly payment for period 24:**  Annual rate of 6%, number of periods is 48 months, value is $10,000, final value is 0 (paid off).
+** Calculate the monthly principal payment for period 24:**  Annual rate of 6%, number of periods is 48 months, value is $10,000, final value is 0 (paid off).
-  ppmt(0.06/12, 24, 48, 10000, 0)  //Returns -207.32 (monthly payment, rounded)
+  ppmt(0.06/12, 24, 48, 10000, 0) //Returns -207.32 (monthly payment, rounded)
 \\
-** Calculate the monthly 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 principal 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.
-  ppmt(0.10/12,20, 2*12, 8000,0,1)  //Returns -351.23 (monthly payment, rounded)
+  ppmt(0.10/12,20, 2*12, 8000, 0, 1) //Returns -351.23 (monthly payment, rounded)
 \\
-** Calculate the monthly payment for period 25:**  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 principal payment for period 25:**  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.
-  ppmt(0.10/12,25, 2*12, 8000,0,1)  //Returns an error.  "Per" is outside of 1 to 24 (the # of months).
+  ppmt(0.10/12,25, 2*12, 8000, 0, 1) //Returns an error.  "Per" is outside of 1 to 24 (the # of months).
 \\
 ===== See also =====
-  * [[syntax:functions:ppmt|PMT(rate, num_per, curr_val)]]
+  * [[syntax:functions:fv|FV(rate, num_per, payment)]]
-  * [[syntax:functions:ipmt|IPMT(rate, num_per, curr_val)]]
+  * [[syntax:functions:nper|NPer(rate, payment, curr_val)]]
+  * [[syntax:functions:ipmt|IPmt(rate, per, num_per, curr_val)]]
+  * [[syntax:functions:pmt|Pmt(rate, num_per, curr_val)]]
+  * [[syntax:functions:pv|PV(rate, num_per, payment)]]
+  * [[syntax:functions:rate|Rate(num_per, payment, curr_val)]]