DCF Model of a Pharma Company

This is the Discounted Cash Flow Model of DR. Reddy's Laboratories (India) prepared in October 2020

by Shubham Patil
Financial Modeling and ValuationFollow

1 review126 views|1 comment|Bookmark Add to cart - $20.00

Description
Dr. Reddy's Laboratories is an Indian multinational pharmaceutical company located in Hyderabad, India. The company was founded by Anji Reddy, who previously worked in 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, 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 past five years.
. Assumptions: This includes making 3 types of cases namely Best case, Base Case and Worst case.
.Output: This includes final profit and loss statement, Balance sheet and Cash flows for period of 5 years.
. DCF model: This conatains estimated discounted value of cash flows of Dr. Reddy's Laboratories.
. Beta & WACC calculation along with ratios and sensitivity analysis.

This Best Practice includes
1 Excel file Containing 12 Sheets.