User Tools

Site Tools


syntax:functions:ppmt

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
syntax:functions:ppmt [2021/10/23 20:45]
craigt [Examples]
syntax:functions:ppmt [2021/10/24 00:29] (current)
craigt minor edits, updated See Also section
Line 1: Line 1:
-====== PPMT(rate, per, num_per, curr_val) ======+====== PPmt(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.
-  PPMT(rate, per, num_per, curr_val, fut_val)+  PPmt(rate, per, num_per, curr_val, fut_val)
 \\  \\ 
 Optional //payments due// (pay_due) argument. 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 37: Line 37:
 \\  \\ 
 ** 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). ** 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 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. ** 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 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. ** 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 ===== ===== 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)]]
syntax/functions/ppmt.txt · Last modified: 2021/10/24 00:29 by craigt