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?
--
Amy Howell

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.

--
HTH...

Jim Thomlinson


"amy howell" wrote:

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?
--
Amy Howell

thank you very much for your response.
--
Amy Howell


"Jim Thomlinson" wrote:

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.

--
HTH...

Jim Thomlinson


"amy howell" wrote:

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?
--
Amy Howell

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

Pete

"amy howell" wrote in message
...
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?
--
Amy Howell