Funzione di Google Sheets

CUMPRINC

Returns the cumulative principal paid on a loan between two periods.

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

CUMPRINC(rate, nper, pv, start_period, end_period, type)

The CUMPRINC function calculates the total principal portion of loan payments within a specified range of periods. It is useful for determining how much of a loan balance has been paid off between a start and end period.

Argomenti

rateobbligatorioThe interest rate per period.
nperobbligatorioThe total number of payment periods.
pvobbligatorioThe present value or total amount of the loan.
start_periodobbligatorioThe first period in the calculation.
end_periodobbligatorioThe last period in the calculation.
typeobbligatorioWhen payments are due: 0 for end of period, 1 for beginning of period.

Esempi

=CUMPRINC(0.05/12, 360, 200000, 1, 12, 0)

Risultato: -4356.51

Calculates the cumulative principal paid in the first year of a 30-year loan at 5% interest.

Domande frequenti

Why is the result negative?

CUMPRINC returns a negative value because it represents an outgoing cash flow (payment) from the borrower's perspective.

Funzioni correlate

CUMIPMT PPMT PMT