Financial Modelling. Discounted Cash Flow (DCF) and Relative Valuation Report

Submitted Assignment from the year 2025 in the subject Business economics - Investment and Finance, course: Bachelor of Business Administration / 3rd Year, language: English, abstract: This study conducts a comprehensive valuation analysis of Cipla Ltd. using Discounted Cash Flow (DCF) valuation and Relative Valuation methodologies. The DCF model estimates the company's intrinsic value by forecasting future Free Cash Flows to the Firm (FCFF) and discounting them using the Weighted Average Cost of Capital (WACC). Additionally, sensitivity analysis is performed to assess how variations in key assumptions impact valuation outcomes. The Relative Valuation approach compares Cipla's financial metrics with industry peers to determine whether the stock is overvalued or undervalued based on market multiples such as EV/Revenue, EV/EBITDA, and Price-to-Earnings (P/E) ratios. Furthermore, the Football Field Analysis consolidates valuation estimates from different approaches to provide a comprehensive perspective. This report also discusses key factors influencing Cipla's valuation, including growth catalysts, investment strategies, and potential risks, offering a holistic understanding of the company's financial position.