financial functions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

amy howell - 18 Mar 2008 00:06 GMT

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?

Signature

Amy Howell

Reply to this Message

Jim Thomlinson - 18 Mar 2008 00:14 GMT

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.

Signature

HTH...

Jim Thomlinson

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

Reply to this Message

amy howell - 18 Mar 2008 00:40 GMT

thank you very much for your response.

Signature

Amy Howell

> Pmt - is the payment function for a loan
> ipmt - is the interest portion of the total payment
[quoted text clipped - 10 lines]
> > difference between pmt, ipmt, ppmt? Also, what do i use pv, nper, and rate
> > for?

Reply to this Message

Pete_UK - 18 Mar 2008 01:50 GMT

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

Pete

> Whenever I encounter financial functions, I get totally petrified because
> I
[quoted text clipped - 3 lines]
> rate
> for?

Reply to this Message