Google Sheets-functie

PPMT

Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate.

Formule genereren met AI Dezelfde functie in Excel

Deze functie werkt in Google Spreadsheets hetzelfde als in Excel — dezelfde syntaxis en argumenten.

Syntaxis

PPMT(rate, per, nper, pv, [fv], [type])

The PPMT function calculates the principal portion of a loan payment for a specific period. It assumes that the interest rate and payment amounts remain constant throughout the life of the loan.

Argumenten

ratevereistThe interest rate per period.
pervereistThe period for which you want to find the principal payment (must be in the range 1 to nper).
npervereistThe total number of payment periods in an investment.
pvvereistThe present value, or the total amount that a series of future payments is worth now.
fvoptioneelThe future value or a cash balance you want to attain after the last payment is made (defaults to 0).
typeoptioneelThe number 0 or 1 and indicates when payments are due (0 = end of period, 1 = beginning of period).

Voorbeelden

=PPMT(0.05/12, 1, 36, 10000)

Resultaat: -260.44

Calculates the principal portion of the first payment for a $10,000 loan at 5% annual interest over 36 months.

Veelgestelde vragen

Why is the result of PPMT negative?

In Excel financial functions, cash outflows (payments) are represented as negative numbers.

Gerelateerde functies

IPMT PMT NPER PV