syntax:functions:ppmt

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

Both sides previous revision Previous revision | |||

syntax:functions:ppmt [2021/10/23 20:45] craigt [Examples] |
syntax:functions:ppmt [2021/10/24 00:29] (current) craigt minor edits, updated See Also section |
||
---|---|---|---|

Line 1: | Line 1: | ||

- | ====== PPMT(rate, per, num_per, curr_val) ====== | + | ====== PPmt(rate, per, 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. | ||

- | PPMT(rate, per, num_per, curr_val, fut_val) | + | PPmt(rate, per, num_per, curr_val, fut_val) |

\\ | \\ | ||

Optional //payments due// (pay_due) argument. | Optional //payments due// (pay_due) argument. | ||

- | PPMT(rate, per, num_per, curr_val, fut_val, pay_due) | + | PPmt(rate, per, num_per, curr_val, fut_val, pay_due) |

\\ | \\ | ||

Line 37: | Line 37: | ||

\\ | \\ | ||

** Calculate the monthly principal payment for period 24:** Annual rate of 6%, number of periods is 48 months, value is $10,000, final value is 0 (paid off). | ** Calculate the monthly principal payment for period 24:** Annual rate of 6%, number of periods is 48 months, value is $10,000, final value is 0 (paid off). | ||

- | ppmt(0.06/ //Returns -207.32 (monthly payment, rounded) | + | ppmt(0.06/ |

\\ | \\ | ||

** Calculate the monthly principal payment for period 20:** 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 principal payment for period 20:** 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. | ||

- | ppmt(0.10/ //Returns -351.23 (monthly payment, rounded) | + | ppmt(0.10/ |

\\ | \\ | ||

** Calculate the monthly principal payment for period 25:** 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 principal payment for period 25:** 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. | ||

- | ppmt(0.10/ //Returns an error. | + | ppmt(0.10/ |

\\ | \\ | ||

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

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

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

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

+ | * [[syntax: | ||

+ | * [[syntax: | ||

+ | * [[syntax: |

syntax/functions/ppmt.txt · Last modified: 2021/10/24 00:29 by craigt