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