PMT function is an in-built function used to compute the loan payment based on the fixed interest rates and constant payments. Firms or individual who deal with loans mostly uses the function. Therefore, learning how to use this function in Excel is beneficial. In this article, we shall discuss various workarounds and related methods.
PMT Function Syntax
To use the PMT function effectively, you need to learn and understand its syntax. Unlike other financial functions, the syntax of the PMT function is straightforward. Therefore, new Excel users find it easy to use the function. Below is the syntax of the PMT function:
=PMT (rate, nper, pv, [fv], [type])
Each of the arguments of the function is discussed below:
Rate: This argument entails the interest of the loan.
Nper: This is the total number of payments for the loan.
Pv: This is the principal of a loan.
Fv: This is an optional argument. It entails the future value after the last payment has been made.
Type: This is an optional argument. This is the type of day count used in the payment of a loan.
How to use PMT Function
A] Using the Formula bar
Here are the steps to follow:
1. Open the Excel application.
2. Open the Workbook containing your dataset or a new worksheet.
3. If you open a new worksheet, ensure you have all the required arguments in different cells.
4. Click on an empty cell that will hold the results, and then click on the Formula bar.
5. Type the Equal sign followed by the PMT function. That is, =PMT (
6. Select the cells with your arguments using a comma as the separator. For Example, =PMT (B1, B2, B3…)
7. Finally, hit the Enter key.
B] Using the Insert Function Tool
Steps to follow:
1. Open the Excel application.
2. Open the Workbook containing your dataset or a new worksheet.
3. Click on the Formulas tab on the screen, and then locate the Function Library section.
4. Click the Insert Function button to open the Insert Function dialogue box.
5. In the Search for a Function section, type PMT and press the Go button.
6. Select the PMT option in the Select a Function section and then hit the Ok button.
7. Fill in the sections in the Function Arguments dialogue box. Remember, the Fv and the Type sections are optional.
8. Finally, click the OK button.
C] Using the Financial Tool
Steps to follow:
1. Open the Excel application.
2. Open the Workbook containing your dataset or click on the cell containing the results of the computation.
3. Click on the Formulas tab on the screen, and then locate the Function Library section.
4. Click the Financial drop-down button. From the menu, click the PMT option.
5. Fill in the sections in the Function Arguments dialogue box. Remember, the Fv and the Type sections are optional.
6. Finally, click the OK button.