Returns the end-of-period principal payment for given present value at specified rate for specified period.
Syntax
|
Returns the end-of-period principal payment for given present value at specified rate for specified period. |
|
PPMT(rate, period, totalPeriods, presentValue) |
|
Arguments: |
|
|
rate |
Numeric - the interest rate. |
|
|
period |
Numeric - the period for which to calculate the principal. |
|
|
totalPeriods |
Numeric - the total number of periods. |
|
|
presentValue |
Numeric - the present value or principal. |
Remarks
- Example: PPMT(0.06 / 12, 3, 12, 100000) returns -8187.912066.
Comments
0 comments
Article is closed for comments.