Discover The PMT, IPMT And PPMT Functions In Excel

If you've used the Excel PMT function, you'll know that it can be used to calculate period repayments for a loan, such as a mortgage, taken out for a particular term at a fixed interest rate. This article recaps how to use the PMT payment function, and also describes two other very useful payment functions IPMT and PPMT used to calculate the interest and capital elements of these period repayments.

The full article appears here:
http://www.microsofttraining.net/article-1619-discover-pmt-ipmt-and-ppmt-functions-in-excel.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com