Both sides previous revisionPrevious revision | |
syntax:functions:pmt [2021/10/23 16:47] – craigt | syntax:functions:pmt [2021/10/24 00:26] (current) – minor edits, updated See Also section craigt |
---|
====== PMT(rate, num_per, curr_val) ====== | ====== Pmt(rate, num_per, curr_val) ====== |
Category: Number (Financial) function | Category: Number (Financial) function |
| |
=====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) |
| |
\\ | \\ |
=====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)]] |