Ppmt

Syntax

Ppmt(Rate, Period, PaymentCount, PresentValue, FutureValue, Type)

Parameters

Rate. The interest rate per period for a loan.

Period. Period.

PeriodCount. The total number of payments for a loan.

PresentValue. The present value: the total amount that a series of future payments is worth now.

FutureValue. The required value of future cost or the remainder after the last payment.

Type. Selecting payment time. The parameter may take the following values:

NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.

Description

It returns the payment on the principal for a given investment based on periodic, constant payments and a constant interest rate.

Example

Formula Result Description
=Ppmt(0.01, 3, 12, 50000, 0, 0) -4021,68

Payment amount based on the following terms:

  • The interest rate is 0.01.

  • The period is 3.

  • The total number of payments is 12.

  • The capital is 50000.

  • The future value is 0.

  • The payment is effected at the end of period.
=Ppmt(A0, E0, B0, 12000, 0, 1) 541,58

Payment amount based on the following terms:

  • The interest rate is specified in the A0 cell, the value is 0.2.

  • The period is specified in the E0 cell, value is 5.

  • The total number of payments is specified in the B0 cell, value is 15.

  • The capital is 12000.

  • The future value is 0.

  • The payment is effected at the beginning of period.

See also:

Function Wizard │ Financial Functions │ Pmt