Pmt

The function wizard for the Pmt function looks as follows:

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, it is available to specify either the parameter value or the cell address where it is located.

    Description

    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 terms:

    • The interest rate 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 terms:

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

    • The total number of payments is specified in the B0 cell, the 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 │ Finance │ Ppmt │ IFinance.Pmt