What do you think about my comps?
I've done a comparable companies analysis to value Universal Logistics Holdings (ULH) as a personal project and I'd like some harsh and brutal feedback about it to get better. I've used Rosenbaum as source of inspiration and managed to produce a football field that doesn't look absolutely terrible, but I fear that my numbers may be wrong because of 1) general inexperience 2) lack of access to high-quality Bloomberg data.
Thank you in advance!
| Attachment | Size |
|---|---|
| comps_ulh.xlsx 99.18 KB | 99.18 KB |
bump
Paste a picture, it will make it easier
I edited my first post. WSO resizes pictures though, so some may be difficult to read.
Use an IF function to take out any severe negative percentages. Like a -327% historical EPS for YRC is "NM" (not meaningful). Also learn about custom formatting that way your decimals can line up (Your SP, MV and EV numbers are not aligned at all). You're going to want to align right before custom formatting. As a summer analyst and analyst, being able to cleanly format things are critical
I added an IF function to replace negative percentages and multiples, and am currently working on custom formatting. Thanks!
Bump, any other advice?
Pretty solid, one thing you may want to consider is doing some further research on the differences between asset-based vs asset-light 3PL providers. They usually have different benchmarks in terms of ROA so gaining a better understanding of that will help you confirm that you are choosing/using the most relevant companies for your comps.
Thanks, I'll see if I can create two groups of comps - asset-based and asset-light
Update: from my comps, ULH is actually the only one to be fully asset-light. All of the other companies are nearly entirely asset-based, apart from ARCB whose asset-light division represents 30% of its revenue.
Take a look at the proxy peers
Will do, thanks
Vel quia qui non ad reprehenderit est id a. Aperiam asperiores commodi aspernatur et qui. Est vitae repudiandae sit totam architecto delectus illum.
Unde asperiores quia adipisci occaecati corporis eum dolores. Illum qui in alias aut. Sint aut quos ea vel aliquam dolores voluptatem 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...