Advice for best approach to 1) Compare each company with its alike ones in the same sub-sector. 2) Compare each sub-sector with the rest of other sub-sectors.
Hi,
I've been assigned a task to give a conclusion or recommendations for two things:
- Which company has a better performance compared to its like companies in the same sub-sector?
- For each sub-sector, which sub-sector as a whole has a better performance?
The real situation is as follows:
- The industry is telecom.
- The authority issues licenses to service providers, which in turn they are providing the service to the end user.
- The industry has several sub-sectors, like:
- Mobile operators.
- Sattalitte services.
- several other sub-sectors.
- Each sub-sector includes several companies.
The reasons for that task are:
- The authority would like to know which sub-sector is more profitable, to provide more new licenses for that sub-sector, or even add a new related sub-sector.
- Which companies are not performed well and might close in the near 1 to 3 future years?
What I've done so far:
I've built a model with Excel that calculates all financial ratios for each company individually and made it under categories like profitability, ...etc.
But top management is not satisfied with these Excel files, and keeps asking, so what!? what do these numbers mean?
And I keep replying that you do not understand the meaning of the numbers, that is your problem and not mine, as this is the financial analysis by the book to the letter.
Then I thought that it could be my problem and not their problem, so I thought to ask about it here.
So after calculating all ratios, what else should I do to give that conclusion, recommendations, or insights?
Thanks
Sunt numquam voluptas facere nesciunt rerum. A eum accusantium quam esse. Asperiores minima officiis consectetur totam modi.
Vitae doloremque quidem blanditiis eius dicta reiciendis porro. Voluptas qui aut dolorem nihil voluptate sapiente doloremque. Et ut minima dolorem culpa. Ut ipsam nisi expedita. Reprehenderit quas vel eveniet ducimus. Sint iusto odit quos est non totam.
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...