Comparable Sector Analysis


Sector analysis serves to provide an investor with a judgment about how well companies in the sector are expected to perform. Using Marketxls functions the investor can assess how the various sectors are performing on various financial indicators like dividend yield, price-to-earnings ratio and return on equity, as well as the past returns. Ranks have been provided on the basis of these above parameters, so that the investor can choose, the top 2 or top 3, as per their choice. The one with the minimum value in the total of the ranks column, is the best performing sector.

About the Author

Follow me

Educated in Finance, Business and Statistics, Ankur is passionate about finance, investing, trading and programming.

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}