Documentation/Calc Functions/ISPMT

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

ISPMT

Category:

Financial Analysis

Summary:

Calculates the level of interest for unchanged amortization installments.

Syntax:

ISPMT(Rate; Period; Total Periods; Invest)

Returns:

Arguments:

Rate sets the periodic interest rate.

Period is the number of installments for calculation of interest.

Total Periods is the total number of installment periods.

Invest is the amount of the investment.

Additional details:

Examples:

For a credit amount of 120,000 currency units with a two-year term and monthly installments, at a yearly interest rate of 12% the level of interest after 1.5 years is required.

=ISPMT(1%;18;24;120000) = -300 currency units. The monthly interest after 1.5 years amounts to 300 currency units.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: