Straight lining - PE Modeling test
In a modeling test, let's say for example you had to project out COGS, and you decided to straight line COGS using historical data.
do you use historical COGS from from just latest year, or do you take an average of latest 3-5 years?
It wouldn't make sense to straight-line the costs themselves (unless truly all fixed). I would keep the margins consistent (if that's your assumption) and apply a constant margin % to the flexing revenue profile.
Yeah moreso meant for the margin %, would you straightline it from latest year or take an avg of say, last 3 years?
If the business is growing/scaling, I'd just use the latest year (i.e., if margins have improved, would straightline at the latest/highest). They've probably optimized the cost structure and improved margins as they've grown.
really appreciate it. and what if there is no clear trend in the margins? say the margins for the past 5 years are 45%, 46%, 43%, 46%, 47% ?
would probably hold flat at the most recent year, unless you can substantiate doing something different from the CIM / case overview. Much easier IMO to justify operating leverage than gross margin uplift if you do want to play around with the margins
could you clarify why justifying operating leverage is easier? aren't those two things directly related? from what I understand a business with high operating leverage will have margins improve as you sell more volume?
Pretty sure he just means that it is easier to justify EBITDA margin expansion due to fixed or slower growing OPEX compared to revenue growth rather than improving gross margins as you would typically expect most of COGS to be variable (so COGS should grow in line with revenue at a steady % of revenue and the only way gross margin would get better is through operational improvements which are harder to justify than just holding OPEX flat in an extreme example or growing at some inflationary rate which would typically lead to EBITDA margin expansion if revenue grows at a faster rate which is usually the case unless a very mature industry).
^ This. If you're calling for gross margin expansion, a good justification would be you've done a cohort analysis and discover new cohorts are coming on at higher unit margins due to greater pricing flow through while showing strong retention metrics. For a simple modeling test, proving something like that is obviously harder than waving your hand in the air and saying we're cutting G&A and pulling back on development costs as the business grows
Occaecati aut et sequi. Ea et mollitia aliquid est sint. Itaque quod enim iure accusamus natus quam et quam. Debitis dolorum et perspiciatis repellendus nulla. Saepe voluptatem aut aperiam. Enim dolores explicabo pariatur earum voluptatum et. Est ut consequatur illo aspernatur repellendus.
Nesciunt sed et incidunt nesciunt sint. Atque voluptate aut sunt quis. Voluptas voluptas aliquam ex dolores error qui fugit.
Et eos eos sapiente excepturi aspernatur perferendis quo. Est eaque consequatur illum quia non quis facere ratione. Hic architecto aut aliquam expedita illum eius. Quia provident exercitationem et ratione. Et voluptas eveniet quo beatae tempore sint. Voluptatum voluptas temporibus aut et. Impedit architecto quidem deserunt ipsum repellendus et.
Non exercitationem autem reiciendis quod consectetur. Deleniti corporis est eos veritatis accusantium voluptatem. Autem tempore et sunt voluptates non est et illum.
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...