Calculating CAGR (compound annual growth rate) when the beginning value is negative

Corporate finance, Personal finance

I regularly receive emails from readers posing questions based on my previous posts on things like , , and other financial and Excel questions.

One of the most common questions I receive is how to calculate a when the beginning value is negative.

The basic answer is that you can’t. Why?

Let’s look at the formula for calculating CAGR:


CAGR = (ending amount / beginning amount)(1 / # of years) – 1

Mathematically, because you’re taking a root of a number, if you have a negative beginning amount and a positive ending amount, you’d be taking the root of a negative number. Unless you have an odd # of years, you can’t compute this mathematically without going into

Even if you do happen to have (or force) a negative # of years, the result will also be a negative growth rate, which also doesn’t make sense in terms of what’s going on.

The best way to deal with situations where you have a negative initial value is to just footnote it and calculate CAGR based on the first positive initial value you have. So, for example, if you had a project that lost $500 in year 2003, then gained $100 in year 2004, and ended in year 2007 with $500, you might write the following:

    Revenues grew from $100 to $500 during the period from 2004-2007 (CAGR of 71%). Note that this excludes the initial 2003 year, when the project lost $500.

Remember, your goal is to present an accurate picture of what’s going on. That almost always means using a few more words to reflect and explain reality rather than just provide a single, calculated figure.

As a reminder, you can also always use the on this site to do some quick calcs and checks if you need to :)

***************************************************

Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss


***************************************************

8 Feedbacks on "Calculating CAGR (compound annual growth rate) when the beginning value is negative"

Business blog » Blog Archive » Calculating CAGR (compound annual growth rate) when the beginning …

[...] Read the rest of this great post here [...]



BizBlogged

Thanks for posting a useful calculation content.. How Blogging is effective can be determined by this kind of posts.

Finance blog, finance, economics, Corporate finance, Personal finance, Investing, Marketing



Andrew Knight

Hi Experiments in Finance,

I’m emailing you in regards to an email I sent to you last month about a partnership, have you had a chance to think about it?

If you have any questions or would more information, please advise me and we can go from there.

Kind Regards,
Andrew Knight.
Website Manager
Banking & Finance Division
Asia-Pacific Region

Online Marketing Group Pty Limited
Email: andrew.knight@omg.com.au
Web: http://www.omg.com.au



Caren

Hi,
My name is Caren.
I find your site http://www.experiglot.com/ extremely interesting!
I have a few good credit card websites that could be useful for your readers. They have many visitors, high Alexa rank and PR from 0 to 4 and one of them takes its place in the Google top 10 credit card sites.

I would like to buy a link in a fresh post or at some pages of your site.

Please let me know if you are interested and how much you charge via email.
Thank you for your time,
Regards,Caren.



eyelash tint

The report also reviews the competitive landscape, key pipeline products and technology offerings.

Now there is a product that you do not need a prescription and is
1/2 the price of competitors like Latisse, and this is Altisce.

Take off the makeup slowly and softly; take care of your eyelashes by treating them gently, right.



Coy

Link exchange is nothing else but it is simply placing the other person’s weblog link
on your page at suitable place and other person will also do similar in
support of you.



indian bride groom

Actually no matter iif someone doesn’t be aware of afterward its up to other users that they will help, so here
it occurs.



Anonymous

First of all I would like to say superb blog!
I had a quick question in which I’d like to ask if you do
not mind. I was curious to find out how you center yourself
and clear your thoughts before writing. I have had difficulty clearing my
thoughts in getting my thoughts out there. I do enjoy writing however it just seems like the first 10 to 15 minutes are generally lost just trying to figure out how to begin.
Any recommendations or hints? Many thanks!



Comments

Please Leave a Comment!





Please note: Comments may be moderated. It may take a while for them to show on the page.