• Bajaj Consumer Care Ltd.: Discounted Cash Flow (DCF) Valuation - Instructor Spreadsheet

    Instructor spreadsheet to accompany product 8B20N009.
    詳細資料
  • Bajaj Consumer Care Ltd.: Discounted Cash Flow (DCF) Valuation - Student Spreadsheet

    Student spreadsheet for product 9B20N009.
    詳細資料
  • Bajaj Consumer Care Ltd.: Discounted Cash Flow (DCF) Valuation

    In July 2017, a financial analyst from an Indian investment bank was assigned the task of identifying a suitable company from the fast-moving consumer goods (FMCG) sector for the bank’s portfolio. The bank wanted to expand its investment portfolio from the mobile Internet, information technology, health care, financial technology, and e-commerce sectors into the FMCG sector. After researching three significant players in the personal care segment and comparing these companies’ key ratios, the analyst determined that one of them, Bajaj Consumer Care Ltd., was a suitable candidate for valuation. Now, he had to perform a buy-side valuation of the company using the discounted cash flow technique to determine whether Bajaj Consumer Care Ltd. would be the right fit for his company’s investment plans.
    詳細資料
  • Bajaj Consumer Care Ltd.: Discounted Cash Flow (DCF) Valuation

    In July 2017, a financial analyst from an Indian investment bank was assigned the task of identifying a suitable company from the fast-moving consumer goods (FMCG) sector for the bank's portfolio. The bank wanted to expand its investment portfolio from the mobile Internet, information technology, health care, financial technology, and e-commerce sectors into the FMCG sector. After researching three significant players in the personal care segment and comparing these companies' key ratios, the analyst determined that one of them, Bajaj Consumer Care Ltd., was a suitable candidate for valuation. Now, he had to perform a buy-side valuation of the company using the discounted cash flow technique to determine whether Bajaj Consumer Care Ltd. would be the right fit for his company's investment plans.
    詳細資料
  • Bajaj Consumer Care Ltd.: Discounted Cash Flow (DCF) Valuation, Student Spreadsheet

    Student spreadsheet to case W20181
    詳細資料
  • Talbros Automotive Components Limited: Relative Valuation - Instructor Spreadsheet

    Instructor spreadsheet for product 8B16N054.
    詳細資料
  • Talbros Automotive Components Limited: Relative Valuation

    In 2015, an ancillary client of a leading investment bank based in New Delhi, was looking to increase revenues from the two-wheeler and four-wheeler vehicle segments by acquiring customers that were original equipment manufacturers. A financial analyst was assigned the task of evaluating the options and identifying the right target to acquire for the client. The analyst used comparable company analysis and comparable transaction analysis, as well as valuation ratios (enterprise value-to-sales; enterprise value-to-earnings before interest, tax, depreciation, and amortization; and price-to-earnings per share) to arrive at Talbros Automotive Components Limited as the best target for the client. For comparable company analysis, the analyst also compiled a list of four publicly traded firms that were similar to Talbros Automotive Components Limited. The analyst needed to arrive at the final valuation range by combining the results of both techniques (i.e., comparable company analysis and comparable transaction analysis), which could be achieved by using a football field analysis.
    詳細資料
  • Talbros Automotive Components Limited: Relative Valuation

    In 2015, an ancillary client of a leading investment bank based in New Delhi, was looking to increase revenues from the two-wheeler and four-wheeler vehicle segments by acquiring customers that were original equipment manufacturers. A financial analyst was assigned the task of evaluating the options and identifying the right target to acquire for the client. The analyst used comparable company analysis and comparable transaction analysis, as well as valuation ratios (enterprise value-to-sales; enterprise value-to-earnings before interest, tax, depreciation, and amortization; and price-to-earnings per share) to arrive at Talbros Automotive Components Limited as the best target for the client. For comparable company analysis, the analyst also compiled a list of four publicly traded firms that were similar to Talbros Automotive Components Limited. The analyst needed to arrive at the final valuation range by combining the results of both techniques (i.e., comparable company analysis and comparable transaction analysis), which could be achieved by using a football field analysis.
    詳細資料