Google Sheets-Funktion

ISPMT

Calculates the interest paid during a specific period of an investment.

Formel mit KI erstellen Dieselbe Funktion in Excel

Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.

Syntax

ISPMT(rate, per, nper, pv)

The ISPMT function calculates the interest portion of a loan or investment payment for a specific period. It assumes a linear amortization schedule where the principal is paid off in equal installments.

Argumente

rateerforderlichThe interest rate for the investment.
pererforderlichThe specific period for which you want to calculate the interest (must be between 1 and nper).
npererforderlichThe total number of payment periods for the investment.
pverforderlichThe present value of the investment.

Beispiele

=ISPMT(0.05, 1, 3, 10000)

Ergebnis: -500

Calculates the interest for the first period of a 3-year loan of 10,000 at 5% interest.

FAQ

How does ISPMT differ from IPMT?

ISPMT assumes a linear amortization schedule, whereas IPMT assumes a constant payment amount (annuity) where interest decreases over time.

ISPMT

Syntax

Argumente

Beispiele

FAQ

Verwandte Funktionen

ISPMT

Syntax

Argumente

Beispiele

FAQ

Verwandte Funktionen