Relative Valuation Dashboard (Dr. Reddy Labs, CIPLA, Biocon, Aurobindo Pharma, Sun Pharmaceuticals)
  • Relative Valuation Dashboard (Dr. Reddy Labs, CIPLA, Biocon, Aurobindo Pharma, Sun Pharmaceuticals)
  • Relative Valuation Dashboard (Dr. Reddy Labs, CIPLA, Biocon, Aurobindo Pharma, Sun Pharmaceuticals)
  • Relative Valuation Dashboard (Dr. Reddy Labs, CIPLA, Biocon, Aurobindo Pharma, Sun Pharmaceuticals)
Originally published: 05/10/2020 08:39
Publication number: ELQ-47491-1
View all versions & Certificate
certified

Relative Valuation Dashboard (Dr. Reddy Labs, CIPLA, Biocon, Aurobindo Pharma, Sun Pharmaceuticals)

Excel Dashboard (Dr. Reddy Labs, CIPLA, Biocon, Aurobindo Pharma, Sun Pharmaceuticals)

Description
The company is evaluated considering a group of 5 peer companies according to the market classifications. The company's shares relative valuation and peer comparison is done using our 5-10-5 -star rating methodology (5 companies, 10 parameters, Out of 5 stars). From this, we will arrive at a combined peer rating for the company. Companies considered in this analysis are as follows.

Dr. Reddy Labs, CIPLA, Biocon, Aurobindo Pharma, Sun Pharmaceuticals

Parameters on which analysis is done are as follows
Market Capitalization
Price/ Earnings Ratio
Price/ Book Value Ratio
Dividend Yield
Price to Sales
ROCE
ROA
Price/ Cashflow
Earnings Per Share
ROE

The overall rating is arrived by taking the average of the above 10 parameter ratings and rounded up if it is above 0.5 and rounded down if it is below 0.5. The stock is undervalued if the rating is above 3 (i.e 4 or 5 stars), it is fairly valued if the rating is around 3 and is overvalued if the rating is below 3 (i.e 2 or 1 star). The ratings are exclusive to each company so more than 2 companies can have the same ratings within the peer group.

(Note: All the research done by me is only for educational purposes and should not be seen as Investment recommendations. I am a Research analyst and not a SEBI registered Investment Advisor. My research completely reflects my personal opinions and not of my employers. Kindly do your own due diligence before Investing)

This Best Practice includes
1 Excel Workbook

Billion Dollar Valuation offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

Relative Valuation for Stocks Listed in India

Dashboard and Presentation

Reviews

  • Rate this Downloadable Best Practice

    Write a review

  • Sharad Chandak(last updated: 25/10/2020 12:14)

keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Billion Dollar Valuation

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Relative Valuation Dashboard (Dr. Reddy Labs, CIPLA, Biocon, Aurobindo Pharma, Sun Pharmaceuticals)?

The user community and author are here to help. Go ahead!


5.0 / 5 (1 votes)

please wait...