DCF Model of Dr. Reddy’s Laboratories (5 years Actual and 5 years projection)

Dr. Reddy’s Laboratories is an Indian multinational pharmaceutical company located in Hyderabad, India. The company was founded by Anji Reddy, who previously worked at the mentor institute Indian Drugs and Pharmaceuticals Limited. Dr. Reddy’s manufactures and markets a wide range of pharmaceuticals in India and overseas. The company has over 190 medications and 60 active pharmaceutical ingredients (APIs) for drug manufacture, diagnostic kits, critical care, and biotechnology products.

Dr. Reddy’s began as a supplier to Indian drug manufacturers, but it soon started exporting to other less-regulated markets that had the advantage of not having to spend time and money on a manufacturing plant that would gain approval from a drug licensing body such as the U.S. Food and Drug Administration.

Content:

Financial statement forecast: This includes Source Data of Profit and loss statement, Balance Sheet, and Cash Flow Statement of the past five years.
Assumptions: This includes making 3 types of cases, namely Best Case, Base Case, and Worst Case.
Output: This includes the final profit and loss statement, Balance sheet, and Cash flows for a period of 5 years.
DCF model: This contains the estimated discounted value of cash flows of Dr. Reddy’s Laboratories.
Beta & WACC calculation, along with ratios and sensitivity analysis