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

PMT

PRESENT_VALUE

Last updated 11 months ago

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`

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