What is the PMT or payment function and how do I use it in Excel 2007? The PMT function can calculate savings and loans like a car, or home loan and show you how long it will take to pay off that loan, over a period on a fixed interest rate. The payment function by itself is fairly simple to implement, but there is an additional fix you'll have to add in in order to get the results you want as I just explained it. You can see this PMT function in action and even the setup of the spreadsheet to accommodate the PMT function in an nice structured, organized format. Watch this and other Excel 2007 training videos by purchasing our Excel 2007 training videos by levels!

Purchase the training video and you can see this in action for yourself!