PPMT

Investment's payment on interest

Description

Calculates an investment's payment on interest. This is done based on a constant interest rate and periodic payments of constant amounts.

Function signature

PPMT(rate: Number, period: Number, numberofperiods: Number, presentvalue: Number, futurevalue: Number, paymentsatthebeginningofperiod: Boolean) => Number

Parameter

Description

Rate

The interest rate

Period

The amortization period, between 1 and Number of periods.

Number of periods

The number of payments to be made

Present value

The current value of the annuity.

Future value

The future value remaining after the final payment has been made (Default is 0).

Payments at the beginning of period

Whether payments are due at the end (false) or beginning (true) of each period

Examples

Formula

Return value

PPMT(0.1, 4, 12, 100)

-6.22

PPMT(0.5, 4, 12, 100)

-1.31

PPMT(0.5, 6, 12, 100)

-2.95

PPMT(0.5, 6, 12, 100, 200)

-8.85

PPMT(0.5, 6, 12, 100, 200, true)

-5.9