View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default How do I calculate CAGR in Excel?

CAGR = ((FV/PV)^(1/n)) - 1
where FV is the future value, PV is the present value, and n is the number
of years.

(and next time, please ask your question in the body of the message, not
just in the subject line)
--
David Biddulph

"melshult" wrote in message
...