syntax:functions:ppmt
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
syntax:functions:ppmt [2021/10/23 20:45] – [Examples] craigt | syntax:functions:ppmt [2021/10/24 00:29] (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 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/ | + | 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/ | + | 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/ | + | ppmt(0.10/ |
\\ | \\ | ||
===== See also ===== | ===== See also ===== | ||
- | * [[syntax: | + | * [[syntax: |
- | * [[syntax: | + | * [[syntax: |
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: |
syntax/functions/ppmt.txt · Last modified: 2021/10/24 00:29 by craigt