how pmt function works, what is its background / machanizm? in Excel Worksheet Functions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
Mujeeb ur Rehman, FBL-GRW-PK 9/12/2006 10:29 PM PST
  Question
  Even I have obtained the result by using the function PMT. But I still
consfuse that how PMT function works, what is its background / machanizm.
When we give parameters in this function, how this function manipulate the
parameters and give us result?

Also how can find any function's background / machanizm in excel help?
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
joeu2004@hotmail.com 9/12/2006 10:57 PM PST
  Answer
  Mujeeb wrote:
> Even I have obtained the result by using the function PMT. But I still
> consfuse that how PMT function works, what is its background / machanizm.
> When we give parameters in this function, how this function manipulate the
> parameters and give us result?

Take a look at the mathematical formula at the bottom of the Help page
for the PV() function. Algebraically solve for "pmt". If that does
not sufficiently answer your question, you might google for "present
value formulas" (without quotes). For example,
http://en.wikipedia.org/wiki/Present_value might be useful.

 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Shaz 9/13/2006 2:59 AM PST
  Answer
  PMT is an annuity see this:

http://groups.google.com/group/microsoft.public.excel.worksheet.functions/browse_thread/thread/c8a82d3ffc88f222/ccb55a9758c3034f?lnk=gst&q=pmt&rnum=4#ccb55a9758c3034f



Mujeeb wrote:
> Even I have obtained the result by using the function PMT. But I still
> consfuse that how PMT function works, what is its background / machanizm.
> When we give parameters in this function, how this function manipulate the
> parameters and give us result?
>
> Also how can find any function's background / machanizm in excel help?

 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
JRW 11/9/2006 2:22 PM PST
  Answer
  Here's the equation I found for calculating payment (PMT) if PV (mortgage
amount), n (number of payment periods) and i (interest rate) are known:

http://www.frickcpa.com/tvom/TVOM_formulas.asp

(see PMT - Present value of Annuity) Note that "i" is the interest rate per
payment period. If payment period is monthly, "i" is (annual interest
rate/12) and the annual interest rate is in decimal form (0.08) vs..
percentage (8%).

The formula here is a lot easer to follow, IMHO.

Hope that this helps.



"Mujeeb ur Rehman, FBL-GRW-PK" wrote:

> Even I have obtained the result by using the function PMT. But I still
> consfuse that how PMT function works, what is its background / machanizm.
> When we give parameters in this function, how this function manipulate the
> parameters and give us result?
>
> Also how can find any function's background / machanizm in excel help?
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies