Compound Annual Growth Rate (CAGR) calculator (.xls)

Corporate finance, Excel spreadsheets (.xls), Personal finance

If you want to learn Excel, keep reading or Get 10 days of free unlimited access to Lynda.com. for professional help and Excel Tutorials
***************

Description: A simple MS Excel template (Office 2003) you can use to calculate CAGR given initial investment, ending investment, and # of years of investment, or ending investment or # of years of required investment given the other three inputs. To download this spreadsheet, right click on this link and choose “Save target as…” or “Save link as…” from the menu items.

Enter your data in the white cells. Greyed out areas are calculations and should not be changed. A few examples have been prefilled in blue.

You may use, distribute, and modify this spreadsheet however you wish. For more information on how to use it, you may want to . (Update: I’ve also added an .) Comments, corrections, additions, and suggestions are welcome below.

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

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


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

92 Feedbacks on "Compound Annual Growth Rate (CAGR) calculator (.xls)"

Emma

Im guessing that the last three questions about calculation quarterly date are from people having to send in their economis ‘case’ assessments by 5am tomorrow???

Sooo stuck aswel!



Jason

Hi,

I’m building a revenue forecast tool in Excel that applies an annual growth % for Years 1 to 4. This is then presented back by Year as monthly growth using = ((FV/PV)^(1/12)) – 1. However, I also have Seasonal Weightings that I would like to apply to each of the months (ie Jan:11%, Feb:6%, Mar:7%, etc, so that 100% across the Year). How can I apply Seasonal Weightings to the CAGR formula above?



vikram

excellent contents, thanks a ton



nandakumar

Dear sir,
kindly send me the Sip formula.
nandakumar



Dustin

Nice work. The excel template is exactly what I need. Thank you.



Mayank Umbarkar

Hi Ricemutt,
Could you explain how to calculate the CAGR for Systematic Investment plan??
Thanks in anticipation.
Mayank



Sensex

Use MS excel and get the CAGR plugin from the net it’s really simple dude :)



Bob S

if i have a current value on a regular savng plan how can i work out the CAGR – say $500 pcm for last 5 years, currently worth $55,000 (overall growth/profit as % is easy, but how do i get the CAGR taking account of the rising capital balance?).



Maverick

hi, Thanks a lot for your template! I am already looking for this for ages!



SURESH SHARMA

please note i have tried CAGR USING EXCEL AND I GOT THE RESULT , BUT WHEN I USE THE SAME DATA TO CALCULATE USING NORMAL CAGR FORMULAE THE RESULT IS DIFFERENT .PLEASE EXPLAIN



Sensex

Thanks a lot!! really helpful tools.I wanted to combine all such usefull tools in one xl file and post…:)



Rahel

Thanks I’ve learnt a lot. But how can I calculate the annual average growth if i have many data over 5 or 6 years?



Alana

Thank you very much for sharing this resource!



Arav

can anybody mail me Principles of corporate finance all answer in .xls form please help me as soon as possible. thanks



monstars Import

Hi to all, it’s truly a pleasant for me to pay a quick visit this site, it contains helpful Information.



whatsapp

I have read so many content on the topic of the blogger lovers however this
post is genuinely a pleasant piece of writing, keep it up.



Karol

Howdy! I know this is kinda off topic but I was wondering which blog platform are you using for
this site? I’m getting fed up of WordPress because I’ve had problems with hackers and I’m looking at alternatives for another platform. I would be fantastic if you could point me in the direction of a good platform.



Analisa

Someone necessarily lend a hand to make significantly posts I’d state. That is the first time I frequented your web page and up to now? I surprised with the research you made to create this actual put up extraordinary. Magnificent job!



viagra

If you want to increase your knowledge just keep visiting this web page and be updated with the most up-to-date news posted here.



How To Create A Blog

I’m truly enjoying the design and layout of your blog. It’s a very easy on the eyes which makes it much more enjoyable for me to come here and visit more often.

Did you hire out a designer to create your theme?
Fantastic work!



how to win one direction concert tickets 2013

Concerts 8Th June 2013 online can bring about fraudulent activities.
The demand for concerts 8th june 2013 has reached the
sky. 24 Hour Fitness, Mark Mastrov hired Mark Golob as vice president of strategy and business development, says:
” This year we will probably never see again.



Verizon Samsung Galaxy S4 Coupons

Now I am ready to do my breakfast, later than having my breakfast coming
again to read other news.



Wusthof classic knife block set

For an old couple who have their set of utensils and other kitchen equipment have been the mainstay of any kitchen design.

Another great idea where kitchen organizer is concerned is
the use of lofts and niches in the kitchen but eat it elsewhere,
such as papers, bills, projects to do, junk mail, and school papers.
To Alphabetize or Not to Alphabetize Your Spice
RackYou will be amazed how much easier it will be difficult to keep your items fresh for a long time.



modern interior design

Thanks for another clarifying internet site.
Where else could I get that kind of information printed in
such a great means? I have a mission that I’m simply now operating on, and I have been at the glance out for such info.



Domain Registrar

You are so awesome! I don’t believe I’ve read anything
like that before. So great to discover somebody with a few genuine thoughts on
this subject. Seriously.. many thanks for starting this up.
This website is one thing that’s needed on the web, someone with some originality!



Domain Name Registrar

Simply desire to say your article is as amazing.
The clearness in your post is simply cool and i can assume you
are an expert on this subject. Well with your permission allow me to grab
your RSS feed to keep up to date with forthcoming post.

Thanks a million and please carry on the rewarding
work.



Godaddy Discount Coupons

Hello my loved one! I want to say that this article is awesome,
nice written and include almost all vital infos. I would like to see extra posts like this
.



Godaddy Promo Codes

Asking questions are in fact pleasant thing if you are not
understanding something entirely, except this piece of writing presents good understanding yet.



Go Daddy

I have read so many content about the blogger lovers however this paragraph is actually a pleasant post,
keep it up.



Go Daddy Coupon Code

Today, I went to the beachfront with my kids.
I found a sea shell and gave it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.” She placed
the shell to her ear and screamed. There was a hermit crab inside
and it pinched her ear. She never wants to go back!
LoL I know this is totally off topic but I had to tell someone!



blossomy

I like the helpful info you provide in your articles.

I’ll bookmark your weblog and check again here regularly. I am quite sure I’ll learn many new stuff
right here! Best of luck for the next!



Karolin

My brother recommended I might like this website. He was totally right.
This post actually made my day. You can not imagine just how much time I had spent for
this info! Thanks!



http://yousearch.mobi

Elemente Charme Stift Muffins Hauptvorteil wenn und n



Shweta

VEry good tool for the mathematically disabled and for me who has forgotten all mathematical tools



chunky beaded necklaces

It’s awesome to pay a quick visit this web site and reading the views
of all colleagues on the topic of this post, while I am also keen of getting knowledge.



Miranda

Austin has beeen labelled as the live music capital oof the world making Austin daing
be one of the most successful social activities in thhe area.
With Paltalk Video, you can view webcam videos, listen inn and speak wijth othger Paltalk
mmbers and send photos. It doesn’t take a rocket scientist
to figure this stuff out.



youtube.com

Hmm it appears like your blog ate my first comment (it was super long) so I guess I’ll just sum it up what I had written and say,
I’m thoroughly enjoying your blog. I too am
an aspiring blog blogger but I’m still new to the whole
thing. Do you have any helpful hints for rookie blog writers?
I’d definitely appreciate it.



Beulah

Awesome website, previously been scouting forever for tips on the
best rattan furniture pieces for our home and in our patio.

This website seriously helpedgreat blog some great info here



Abraham

Terrific steam showers, my family had a unit hooked up
about five years ago and it could do with modernizing, never get a boring
old routine kind of shower again



lace wedding dress

Check out some beautiful wedding gowns in the slideshow to the left that
are perfect for a tall figure. Outfits with this neckline are ideal
for you if you have a petite body. From putting
together the budget and guest list to choosing flower bouquets and bridesmaid dresses, it can be a
dizzying amount of tasks to take on at any given time.



of candid photographers in chennai|candid photographers in chennai|pre wedding shoot locations in chennai|pre wedding shoot chennai|pre wedding shoot ideas chennai|candid wedding photography cost in chennai|candid photography for wedding in chennai|candid

I have read so many articles or reviews about the blogger lovers but this article is truly a fastidious article, keep it up.|



Mugdha

Hi, whats the formula for weighted CAGR?



Comments

Please Leave a Comment!





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