User Tools

Site Tools


syntax:functions:pmt

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:pmt [2021/10/23 16:47]
craigt
syntax:functions:pmt [2021/10/24 00:26] (current)
craigt minor edits, updated See Also section
Line 1: Line 1:
-====== PMT(rate, num_per, curr_val) ======+====== Pmt(rate, 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.
-  PMT(rate, num_per, curr_val, fut_val)+  pmt(rate, num_per, curr_val, fut_val)
 \\  \\ 
 Optional //payments due// (pay_due) argument. Optional //payments due// (pay_due) argument.
-  PMT(rate, num_per, curr_val, fut_val, pay_due)+  pmt(rate, num_per, curr_val, fut_val, pay_due)
  
 \\  \\ 
Line 33: Line 33:
 =====Examples===== =====Examples=====
 ** Calculate the annual payment:**  Annual rate of 8%, number of periods is 3 years, value is $20,000, (final value = default, 0). ** Calculate the annual payment:**  Annual rate of 8%, number of periods is 3 years, value is $20,000, (final value = default, 0).
-  pmt(0.08, 3, 20000)  //Returns -7760.67 (annual payment, rounded)+  pmt(0.08, 3, 20000) //Returns -7760.67 (annual payment, rounded)
 \\  \\ 
 ** Calculate the monthly payment:**  Annual rate of 6%, number of periods is 48 months, value is $10,000, final value is 0 (paid off). ** Calculate the monthly payment:**  Annual rate of 6%, number of periods is 48 months, value is $10,000, final value is 0 (paid off).
-  pmt(0.06/12, 48, 10000)  //Returns -234.85 (monthly payment, rounded)+  pmt(0.06/12, 48, 10000) //Returns -234.85 (monthly payment, rounded)
 \\  \\ 
 ** Calculate the monthly payment:**  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 payment:**  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.
-  pmt(0.10/12, 2*12, 8000,0,1)  //Returns -366.11 (monthly payment, rounded)+  pmt(0.10/12, 2*12, 8000, 0, 1) //Returns -366.11 (monthly payment, rounded)
  
  
 \\  \\ 
 ===== See also ===== ===== See also =====
-  * [[syntax:functions:ppmt|PPMT(rate, per, num_per, curr_val)]] +  * [[syntax:functions:fv|FV(rate, num_per, payment)]] 
-  * [[syntax:functions:ipmt|IPMT(rate, per, 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: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/pmt.txt · Last modified: 2021/10/24 00:26 by craigt