| 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)]] |
