financial functions

[amy howell]

Whenever I encounter financial functions, I get totally petrified because I
don't know which function to use for which value. Is there an easy way to
determine which functions go with which value? For example, what is the
difference between pmt, ipmt, ppmt? Also, what do i use pv, nper, and rate
for?

 

[Jim Thomlinson]

Pmt - is the payment function for a loan
ipmt - is the interest portion of the total payment
ppmt - is the principal portion of the total payment.
pv - is the present value of the loan
nper - is the total number of periods
rate - is the interest rate

The Help menu is your friend with these functions.

 

[amy howell]

thank you very much for your response.

 

[Pete_UK]

Have you tried looking in Excel Help for a description of how to use these
functions?

Pete