Please SUBSCRIBE:
https://www.youtube.com/subscription_center?add_user=mjmacarty
How to Use the Excel PMT Function
http://alphabench.com/data/excel-PMT-function.html

The PMT or Payment function is part of the family of financial functions in Excel. It is useful for calculating a steady stream of payments required to bring any loan balance to zero over a specific period of time. More simply, PMT is a loan payment calculator, and is well suited in Excel to explore different scenarios.

The PMT Function can also be used to evaluate leases, where effectively the loan does not have a 0 balance at the end of its life.

Calculate:
Mortgage loan payments
Auto loan payments
Personal Loan payments

Please take the opportunity to connect and share this video with your friends and family if you find it useful.