Hello,
I need a function that will tell me the total interest paid over the life of
a loan, given the usual variables, interest, number of periods, present
value, etc. Is there a single function that does this?

Keith

look in the help index for
CUMIPMT

--
Don Guillett
SalesAid Software

"Keith" wrote in message
...
Hello,
I need a function that will tell me the total interest paid over the life
of
a loan, given the usual variables, interest, number of periods, present
value, etc. Is there a single function that does this?

Keith

One way:

= Pmt * Term - PV

--
Regards,
Fred


"Keith" wrote in message
...
Hello,
I need a function that will tell me the total interest paid over the life of
a loan, given the usual variables, interest, number of periods, present
value, etc. Is there a single function that does this?

Keith

Hi Fred,
thanks very much. this is helpful.
Keith

"Fred Smith" wrote:

One way:

= Pmt * Term - PV

--
Regards,
Fred


"Keith" wrote in message
...
Hello,
I need a function that will tell me the total interest paid over the life of
a loan, given the usual variables, interest, number of periods, present
value, etc. Is there a single function that does this?

Keith

Hi Don,
thanks very much.
I"ll look it up. Very helpful.
Keith

"Don Guillett" wrote:

look in the help index for
CUMIPMT

--
Don Guillett
SalesAid Software

"Keith" wrote in message
...
Hello,
I need a function that will tell me the total interest paid over the life
of
a loan, given the usual variables, interest, number of periods, present
value, etc. Is there a single function that does this?

Keith