2009
PMT (Payment) Useful Financial Function
Prasad Prakash Gavkar Mobile : 99045 66049 26/03/2009
Excel PMT (Payment) Financial Function METHOD – 1 : If you want to make monthly payment on Rs. 1,00,000/‐ loan at an annual rate of 15% that you must pay off in 60 months. Formula : PMT(15%/12,60,100000) Result : Rs. 2378.99 For the same loan, if payments are due at the beginning of the period, the payment is with the help of the formula, Formula : PMT(15%/12,60,100000,0,1) Result : Rs. 2349.62 METHOD – 2 : The following formula is very useful when, the amount someone must pay to you, each month if you loan that person Rs. 5000/‐ @ 12% interest and want to be paid back in five (5) months. Formula : PMT(12%/12,5,‐5000) Result : Rs. 1030.20
METHOD – 3 : You can use PMT for your PPF Account to determine payments to annuities other than loans. For instance, if you want to save Rs. 5,00,000/‐ in 18 years by saving a constant amount each month, you can use PMT to determine how much you will be must save. If you assume you will be able to earn 12% interest on your savings, you can use PMT to determine how much to save each month. Formula : PMT(12%/12,18*12,0,500000) Result : Rs. 659.75 The above financial formulas are very useful for Accountants, Engineers and other Professionals.