Function Explained
PMT function is used to calculate the amount to be paid in each period on a loan or other financial instrument, such as bonds.
Syntax
=PMT(rate,nper,pv,[fv],[type])
rate – The periodic interest rate
nper – The number of periods for payment
pv – The Present Value (PV) of the loan, or any other instrument.
[fv] – The Future Value (FV) – the amount left after all payments are done. This argument is optional, meaning that if left empty, the default FV will be 0 (meaning no balance is left) [type] – Are payments being made at the beginning or at the end of each period. 1 is for beginning, 0 is for the end of the period. As this argument is optional, if omitted, the default is 0 (End of period)Example
Let’s assume we have taken a loan in the of 150,000$ to buy ourselves a brand new sports car 🙂
The loan is for 10 years, bearing a yearly interest rate of 5%. What would be the annual payment?
In this example, we did not type any value in [fv] as the Future Value of the loan is 0. We kept [type] empty as well, meaning that payments are made at the end of each period.