+ Reply to Thread
Results 1 to 3 of 3

Compound annual growth rate [CAGR]

  1. #1
    Paul
    Guest

    Compound annual growth rate [CAGR]

    Does anybody have the excel formula for CAGR?

  2. #2
    Don Guillett
    Guest

    Re: Compound annual growth rate [CAGR]

    =rate
    or
    =(EndValue/StartValue)^(1/YearÂ*s)

    --
    Don Guillett
    SalesAid Software
    [email protected]
    "Paul" <[email protected]> wrote in message
    news:[email protected]...
    > Does anybody have the excel formula for CAGR?




  3. #3
    KemS
    Guest

    Re: Compound annual growth rate [CAGR]

    Don,

    If you wanted the CAGR wouldn't you apend a -1 to your formula?
    =(EndValue/StartValue)^(1/3)-1
    e.g (15000/10000)^(1/3)-1 = 14.47%
    otherwise you get 114.47%.

    Maybe just another way to look at it?

    Best Regard,
    Kem

    "Don Guillett" wrote:

    > =rate
    > or
    > =(EndValue/StartValue)^(1/YearÂÂ*s)
    >
    > --
    > Don Guillett
    > SalesAid Software
    > [email protected]
    > "Paul" <[email protected]> wrote in message
    > news:[email protected]...
    > > Does anybody have the excel formula for CAGR?

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1