The PMT function is one of the built-in financial functions of the Excel software used to calculate the payment for a loan based on regular payments and a constant interest rate. The PMT function is not only useful for businesses, but also very practical for users if you want to calculate a loan.
Example: A loan worth VND 100,000,000 million has an interest rate of 27% per annum, made for 5 years. So, what is the average amount that needs to be paid each year to pay off the loan in five years? That sounds complicated, right? To solve the above problem, Dexterity Software will guide you on how to apply PMT.
Function structure and usage
The PMT function has the following structure: = PMT (rate, nper, pv, [fv], [type])
In which the arguments:
Note:
Specific examples
Example 1: With the problem like the example at the beginning, you enter the following formula in any cell = PMT (27%, 5,100000000,0,0); The result is -38,719,579.42. That is, to borrow one amount of VND 100,000,000 million, an interest rate of 27% per annum, pay for 5 years, and the interest paid at the end of the term, you will have to pay VND 38,719,579.42 annually.
The result of the PMT function automatically adjusts the currency format. If you want to remove the dollar symbol and change the format of the result, select the cell you want to edit, press Ctrl + 1 and switch to the desired format.
Example 2: You set a goal of monthly bank deposits within 2 years, the interest rate is 6% per year, the amount you want to collect after one year is 100,000,000 VND. To calculate the monthly amount to send to the bank, you use the formula: = PMT (6% / 12.2 * 12,0,100,000,00000). Because you do it monthly, interest rates and the total number of payment terms must be converted into months. And the results obtained monthly you must deposit at least VND 3,932,061.03.
Hopefully the article above helps you to apply the PMT function in Excel. Good luck!
ncG1vNJzZmismaXArq3KnmWcp51kva7AjJ%2Bsp5uknryvecinZJ6wk5q5bsHSmp6eZZGjsW6x15qkqaSVqA%3D%3D