financial functions

A

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?
 
J

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.
 
P

Pete_UK

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

Pete
 
Top