Documentation/Calc Functions/ISPMT

Function name:
ISPMT

Category:
Financial Analysis

Summary:
Calculates the level of interest for unchanged amortization installments.

Syntax:
ISPMT(Rate; Period; Total Periods; Invest)

Returns:
Returns a real number (in currency units) which is the interest payment of an amortized loan for a given period.

Arguments:
Rate is a real number or a reference to the cell containing that number which is the periodic interest rate.

Period is a real number or a reference to the cell containing that number which is the number of installments for calculation of interest.

Total Periods is a real number or a reference to the cell containing that number which is the total number of installment periods.

Invest is a real number or a reference to the cell containing that number which is the amount of the investment.


 * If any of the argument is not a real number(except for TRUE and FALSE) then the function returns an #VALUE error.
 * If Total Periods is 0 then the function returns a numeric (#NUM!) error.

Additional details:
None

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/FV FV]

[[Special:MyLanguage/Documentation/Calc_Functions/NPER NPER]

[[Special:MyLanguage/Documentation/Calc_Functions/PMT PMT]

[[Special:MyLanguage/Documentation/Calc_Functions/PV PV]

[[Special:MyLanguage/Documentation/Calc_Functions/RATE RATE]

ODF standard:
Section 6.12.25, part 2

Equivalent Excel functions:
ISPMT