Need to know total interest over the life of a loan

[Guest]

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

 

[Don Guillett]

look in the help index for
CUMIPMT

 

[Fred Smith]

One way:

= Pmt * Term - PV

 

[Guest]

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

 

[Guest]

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