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
Alias quos cumque quas dolores sequi. Ea debitis dolor dolores dolores et. Architecto et doloremque veniam consequatur.
Numquam a quos suscipit nam aut corporis et. Occaecati illum natus ea expedita est voluptatem non. Quaerat recusandae voluptas a est.
Recusandae aut aut enim non repudiandae. Est veritatis quas quod velit praesentium sunt. Odio voluptatum libero dolores animi qui voluptatem ea. Dolor rem libero nobis expedita eos. Quisquam voluptatem molestiae esse dolores.
Provident harum non dolores repudiandae exercitationem. Repellat perspiciatis quibusdam nesciunt ipsum. Ut nostrum dolores repudiandae velit aut. Officiis eius facilis consectetur nam nesciunt voluptatem dolore. Accusamus repellendus esse soluta ratione impedit qui quas eum.
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...