Funzione di Google Sheets

ISPMT

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

Genera una formula con l'IA La stessa funzione in Excel

Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.

Sintassi

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.

Argomenti

rateobbligatorioThe interest rate for the investment.
perobbligatorioThe specific period for which you want to calculate the interest (must be between 1 and nper).
nperobbligatorioThe total number of payment periods for the investment.
pvobbligatorioThe present value of the investment.

Esempi

=ISPMT(0.05, 1, 3, 10000)

Risultato: -500

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

Domande frequenti

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.

Funzioni correlate

IPMT PPMT PMT