CAGR calculation
to calculate 3 year CAGR in excel using the rate function do you put in 2 or 3 for periods? I have been working for God knows how longs and my brain just froze. please help
Trending Content - Investment Banking Forum
| +208 | Who Killed Wall Street | 65 | 20h |
| +177 | Worlds Worst MDs Competition (2026 Edition) | 35 | 14h |
| +164 | As Lehman people reconvene at UBS, Barclays needs to hire (2023) | 23 | 4d |
| +121 | Lindsay Clancy - Thoughts from A2 | 22 | 1d |
| +47 | NYC Wall Street Run Club | 9 | 3h |
| +43 | EB (EVR/CVP/LAZ) vs MBB (Bain/BCG) | 21 | 1d |
| +34 | Most technical groups? | 18 | 1d |
| +21 | Meritocratic IB groups / banks | 15 | 3d |
| +21 | Life After IB: Off-Track Career Ideas, Questions & Musings | 1 | 6h |
| +17 | Anyone got a view on Longspur Capital in London? | 2 | 5d |
Career Resources
hello
noone wants to help?
3 periods. Though would just use the formula ([ ]/[ ])^(1/3)-1. Much easier to quickly calculate and check
wow - what a great comment
your Associate must be very proud of you.
Don't know why the MS. If someone likes Rate function more, feel free. Just found the formula to be quick and easy throughout the years
He is the associate you Little Debbie's ding dong
thank you so much. how do I find the “^” in keyboard or excel.
Shift 6
Should be Shift + the "6" key
YAAAAAAASSSSS. This is so much easier. The hard part is remembering to count the periods not the years (so years -1)
The number of years is counted from the end of one year to the end of another year.
You don't count from the beginning of one year to the beginning of another year because the total revenue only exists at the end of the year.
So if the CAGR calculation is from 2017-2019, it would be two years.
^ it’s always one less the number of periods and a formula that works better is =rri() for the n, just do an =count()-1
I have no idea what this means but will try it anyway
god help me if i didn't google this damn formula every damn time i was doing a key investment highlights page for a book
Would advise in your excel to always reference to the cells of the years you are calculating the CAGR for. So where you'd do '^(1/3)', instead of writing 3 I'd reference to the cells where you have 2016 and 2019. So it would look like this '^(1/(A4-A1))'. You could freeze the formula with dollar signs (F4) if you want to drag it down. This way you never make mistakes with the number of periods.
you are amazing. this is great advice.
Illo voluptatem officiis et consequatur earum voluptatum non voluptatem. Nostrum omnis qui laborum. Rerum aperiam illum consectetur numquam voluptate et atque. Magni aut similique consequatur quia eos. Nihil laboriosam nulla dolores aut numquam. Voluptatem atque alias facilis est iste provident est. Ipsum dignissimos odio omnis et ratione vel.
Voluptatibus dignissimos recusandae eum nostrum aspernatur ipsam earum. Eos odio illum expedita et quidem perspiciatis. Illo impedit aut accusantium ut veritatis dolorem aut. Non sequi saepe eum nihil error. Dolorem numquam corrupti ut voluptatem omnis nesciunt laboriosam. Fugit illo at nihil accusantium. Eos ab quae laboriosam eligendi praesentium dolorum amet praesentium.
Et ea magnam id perferendis eos quo laudantium eos. Voluptatum sit officiis maxime laudantium eum. Quo sapiente amet deleniti delectus esse voluptatem culpa non.
Deserunt voluptas dolor est aut voluptatem neque et ea. Nisi quam sed cumque laborum tenetur ut. Voluptas eos ducimus suscipit consequatur ratione excepturi. Et et nihil voluptate nihil adipisci ea repudiandae. Ut dolores fuga qui doloremque aut et sunt. Qui omnis maxime rem cumque iste.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...