Excel's Financial Functions
Calculating Loan Payments Using Excel PMT Function
The PMT function, one of Excel's Financial functions, can be used to calculate loan repayments or the future value of an investment. This article covers using the PMT function to determine loan repayment.
Calculating Future Value Using Excel's PMT Function
Future value of investments is one use for the Excel PMT function. This article includes an example of using the PMT function in Excel 2007 to determine future value.