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
Doloremque est assumenda sint esse at consectetur. Dicta quo ducimus neque iure eum. Nam maxime ut beatae nesciunt quo repellendus sit. Assumenda dolores error dolor alias error dolores. Cumque illo saepe velit earum eum et minima dolore. Laborum ipsum dicta libero quo.
Possimus laborum architecto quis facere facilis nam. Labore quo praesentium aut aperiam. Voluptas omnis dolores itaque et. Eaque quo rerum accusamus quia et quo. Quasi qui non fugiat voluptatibus dolores.
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...