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 read some background on CAGR. (Update: I’ve also added an online CAGR calculator.) Comments, corrections, additions, and suggestions are welcome below.
***************************************************
Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss
***************************************************
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?
farmacia levitra
Farmaco del da no erettile levitra disfunzione cialis collaterali danni rx farmacia italia sicura
proxy list daily
Hi there,I check your blog named “Experiments in Finance Compound Annual Growth Rate (CAGR) calculator (.xls)” on a regular basis.Your writing style is witty, keep up the good work! And you can look our website about proxy list daily.