Merck & Co Inc (MRK) DCF Valuation: Is The Stock Undervalued?


As part of a new series, each week we typically conduct a DCF on one of the companies in our screens. This week we thought we’d take a look at one of the stocks that is not currently in our screens, Merck & Co Inc (MRK).
 ProfileMerck makes pharmaceutical products to treat several conditions in a number of therapeutic areas, including cardiometabolic disease, cancer, and infections. Within cancer, the firm’s immuno-oncology platform is growing as a major contributor to overall sales. The company also has a substantial vaccine business, with treatments to prevent pediatric diseases as well as human papillomavirus, or HPV. Additionally, Merck sells animal health-related drugs. From a geographical perspective, just under half of the company’s sales are generated in the United States.
 Recent PerformanceOver the past twelve months, the share price is down 5.47%.Source: Google FinanceInputs

  • Discount Rate: 6%
  • Terminal Growth Rate: 2%
  • WACC: 6%
  • Forecasted Free Cash Flows (FCFs)

    Year FCF (billions) PV(billions) 2024 12.19 11.50 2025 13.08 11.64 2026 14.03 11.78 2027 15.05 11.92 2028 16.14 12.06

    Terminal ValueTerminal Value = FCF * (1 + g) / (r – g) = 411.57 billionPresent Value of Terminal ValuePV of Terminal Value = Terminal Value / (1 + WACC)^5 = 307.55 billionPresent Value of Free Cash FlowsPresent Value of FCFs = ∑ (FCF / (1 + r)^n) = 58.90 billionEnterprise ValueEnterprise Value = Present Value of FCFs + Present Value of Terminal Value = 366.45 billionNet DebtNet Debt = Total Debt – Total Cash = 23.54 billionEquity ValueEquity Value = Enterprise Value – Net Debt = 342.91 billionPer-Share DCF ValuePer-Share DCF Value = Enterprise Value / Number of Shares Outstanding = $135.54
     Conclusion

    DCF Value Current Price Margin of Safety $135.54 $101.25 25.30%

    Based on the DCF valuation, the stock is undervalued. The DCF value of $135.54 per share is higher than the current market price of $101.25. The Margin of Safety is 25.30%.More By This Author:Banco BBVA Argentina: Is This Deeply Undervalued Stock A Hidden Gem?
    Salesforce Inc. (CRM) DCF Valuation: Is The Stock Undervalued?
    Home Depot Inc (HD): Is It a Buy?

    Reviews

    • Total Score 0%
    User rating: 0.00% ( 0
    votes )



    Leave a Reply

    Your email address will not be published. Required fields are marked *