View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default Need to know total interest over the life of a loan

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