PMT

Calculates the payment for a loan based on constant payments and a constant interest rate.

Syntax

PMT(rate, nper, pv, [fv], [type])

Argument	Description	Required
`rate`	The interest rate per period.	Required
`nper`	The total number of payment periods.	Required
`pv`	The present value, or lump-sum amount.	Required
`fv`	The future value, or cash balance you want to attain after the last payment is made. Default is 0.	Optional
`type`	When payments are due. 0 = end of period, 1 = beginning of period. Default is 0.	Optional

=PMT(0.08/12, 10*12, 10000)

Result ⇒ -121.3276

=PMT(0.06, 18, 0, 50000)

Result ⇒ -1617.8270

=PMT(A1/12, A2*12, A3)

Result ⇒ -164.9889

Other Financial functions:

CUMIPMT - Returns the cumulative interest paid between start_period and end_period
CUMPRINC - Returns the cumulative principal paid on a loan between start_period and end_period
DB - Returns the depreciation of an asset for a specified period using the fixed-declining balance method
DISC - Returns the discount rate for a security
EFFECT - Returns the effective annual interest rate
FV - Returns the future value of an investment.
FVSCHEDULE - Returns the future value of an initial principal after applying a series of compound interest rates
IPMT - Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.
IRR - Returns the internal rate of return for a series of cash flows
NOMINAL - Returns the annual nominal interest rate
NPER - Returns the number of periods for an investment
NPV - Calculates the net present value of a series of cash flows at a given discount rate
PPMT - Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate.
PV - Returns the present value of an investment.
RATE - Returns the interest rate per period of a loan or investment.
SLN - Returns the straight-line depreciation of an asset for one period
XIRR - Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic
XNPV - Returns the net present value for a schedule of cash flows that is not necessarily periodic