Pmt

Syntax

Pmt(Rate, PaymentCount, PresentValue, FutureValue, Type)

Parameters

Rate. The interest rate per period for a loan.

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 calculates the payment for a loan based on constant payments and a constant interest rate.

Example

Formula Result Description
=Pmt(0.01, 12, 50000, 0, 0) -4442,44

The amount of periodic payment based on the following conditions:

  • The interest rate is 0.01.

  • 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.
=Pmt(A0, B0, 12000, 0, 1) -2138,82

The amount of periodic payment based on the following conditions:

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

  • 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 │ Ppmt