Hey guys,
just a small question here, I would like to know your opinion.
If you are asked to compute revenues CAGR of 2018-2020, would you use 2018 revenues as a base year or 2017?
Since it's 2018-2020, I personally take 2018 as a base, yet my boss gave me hell, that I am doing it all time wrong and 2017 here is a base.
Thanks for you opinions!
Cheers, Adam
| +423 | Don’t work at UBS - UBS Sucks | 37 | 12h |
| +327 | Article - UBS’ Investment Bank Keeps Losing Ground | 41 | 1d |
| +146 | Should My Intern Get a Return Offer? | 48 | 2h |
| +61 | When to Leave Office as Intern | 8 | 4d |
| +60 | Best IB Group Overall? | 35 | 57m |
| +54 | F*ck it I'm Going to Med School | 19 | 7h |
| +39 | Would you rather be a Touse Squid or a Bouse Mogger in IB | 2 | 4d |
| +37 | What do you say to ppl who don’t know EVR/LAZ/CVP/PJT | 29 | 5h |
| +31 | STEM student lost in London IB recruiting | 17 | 3d |
| +27 | [HELP REQUESTED]: Take A2A Promo or Go Corp Dev | 12 | 7m |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Not aware of any convention, but if your boss wants you to start with 2017, just admit you made a mistake and move on. It's not something worth arguing about. Continuing to dwell on it, or allowing your boss to do it is poor judgement.
Bro - His boss is an idiot though. A CAGR from 2018-2020 does NOT include 2017. OP is right.
Last thing OP needs to do is continue making his boss' mistake and have to explain why he used the wrong base to an entire deal team of experienced professionals and ruin his reputation.
Because revenue is an income statement account, it will capture all activity during the year. As we have not come to the end of 2018, I would assume it is inaccurate to use 2018 as a base. I would use 2017 as my base.
Depending on industry and revenue growth, you could project out the remaining revenue for the fiscal year; however, this would not be my preferred method. YMMV.
.
If it's CAGR 2018-2020 then it's the rate between 2018 and 2019 therefore the base is 2018
Your boss is an idiot. 2018-2020 CAGR looks at a 2-year period (2018 to 2019, and 2019 to 2020). 2018 should be the base year. If you use 2017 as the base year it would be 2017-2020 CAGR over a 3 year period.
Agree 100%
Illo quam molestiae nulla sapiente saepe. Et reprehenderit adipisci voluptatem. Incidunt suscipit accusantium iure nisi minima at nihil.
Qui error est qui veritatis aspernatur et nulla. Quis reprehenderit et qui est molestiae dolorum perspiciatis.
Dicta atque atque natus eligendi. Eos voluptatem eum sit consectetur rerum occaecati. At quibusdam distinctio repellat dolor sapiente est blanditiis. Consequatur neque modi aspernatur.
Voluptas optio totam fugiat temporibus. Voluptates nemo ut inventore doloribus eligendi. Voluptas delectus rerum sunt quo. Laboriosam qui omnis est vel sequi rerum laboriosam. Quis qui quas et ad ullam esse. Odit aperiam aut explicabo quisquam quibusdam nulla.
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...