syntax:functions:pmt

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

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: | Category: | ||

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: | ** Calculate the annual payment: | ||

- | 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: | ** Calculate the monthly payment: | ||

- | pmt(0.06/ //Returns -234.85 (monthly payment, rounded) | + | pmt(0.06/ |

\\ | \\ | ||

** Calculate the monthly payment: | ** Calculate the monthly payment: | ||

- | pmt(0.10/ //Returns -366.11 (monthly payment, rounded) | + | pmt(0.10/ |

\\ | \\ | ||

===== See also ===== | ===== See also ===== | ||

- | * [[syntax:ppmt|PPMT(rate, per, num_per, curr_val)]] | + | * [[syntax:fv|FV(rate, num_per, payment)]] |

- | * [[syntax:IPMT(rate, per, num_per, curr_val)]] | + | * [[syntax:, curr_val)]] |

+ | * [[syntax:IPmt(rate, per, num_per, curr_val)]] | ||

+ | * [[syntax: | ||

+ | * [[syntax: | ||

+ | * [[syntax: | ||

+ | * [[syntax: |

syntax/functions/pmt.txt · Last modified: 2021/10/24 00:26 by craigt