How to use the PMT function in Excel
Learn how to use the PMT function in Microsoft Excel. This tutorial demonstrates how to use Excel PMT to calculate a loan payment amount given a principal amount, interest rate and constant payment schedule. Watch our easy to follow example that takes you step-by-step through the different options when entering your formula.
00:00 - Overview
00:05 - What is PMT function?
00:18 - Simple Example of PMT Function
00:44 - Parameter 1 (Interest Rate)
01:06 - Parameter 2 (Number of Payments)
01:21 - Parameter 3 (PV)
01:37 - Results
PMT Function:
https://www.techonthenet.com/excel/fo...
Excel Functions/Formulas:
https://www.techonthenet.com/excel/fo...
Excel Tutorials:
https://www.techonthenet.com/excel/in...
Don't forget to subscribe to our channel for more great Excel tutorials!
Visit us at: https://www.techonthenet.com
or follow us on:
Facebook: / techonthenetcom
Twitter: / tech_on_the_net
Pinterest: / techonthenetcom
