syntax:functions:pmt
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
syntax:functions:pmt [2021/10/23 13:28] – created craigt | syntax:functions:pmt [2021/10/24 00:26] (current) – minor edits, updated See Also section craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== | + | ====== |
Category: | Category: | ||
Line 9: | Line 9: | ||
=====Additional syntax===== | =====Additional syntax===== | ||
Optional //future value// (fut_val) argument. | Optional //future value// (fut_val) argument. | ||
- | | + | |
\\ | \\ | ||
Optional //payments due// (pay_due) argument. | Optional //payments due// (pay_due) argument. | ||
- | | + | |
\\ | \\ | ||
Line 33: | Line 33: | ||
=====Examples===== | =====Examples===== | ||
** Calculate the annual payment: | ** Calculate the annual payment: | ||
- | pmt(0.08, 3, 20000) | + | pmt(0.08, 3, 20000) //Returns -7760.67 (annual payment, rounded) |
\\ | \\ | ||
** Calculate the monthly payment: | ** Calculate the monthly payment: | ||
- | pmt(0.06/ | + | pmt(0.06/ |
\\ | \\ | ||
** Calculate the monthly payment: | ** Calculate the monthly payment: | ||
- | pmt(0.10/ | + | pmt(0.10/ |
\\ | \\ | ||
===== See also ===== | ===== See also ===== | ||
- | * [[syntax: | + | * [[syntax: |
- | * [[syntax: | + | * [[syntax: |
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: |
syntax/functions/pmt.txt · Last modified: 2021/10/24 00:26 by craigt