Apple products on tableImage Source: Unsplash 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, Apple Inc (AAPL).
 ProfileApple is among the largest companies in the world, with a broad portfolio of hardware and software products targeted at consumers and businesses. Apple’s iPhone makes up a majority of the firm sales, and Apple’s other products like Mac, iPad, and Watch are designed around the iPhone as the focal point of an expansive software ecosystem. Apple has progressively worked to add new applications, like streaming video, subscription bundles, and augmented reality. The firm designs its own software and semiconductors while working with subcontractors like Foxconn and TSMC to build its products and chips. Slightly less than half of Apple’s sales come directly through its flagship stores, with a majority of sales coming indirectly through partnerships and distribution.
 Recent PerformanceOver the past twelve months the share price is up 21%.Source: Google FinanceInputs

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

    Year FCF (billions) PV(billions) 2024 109 99.09 2025 121 100.00 2026 135 101.43 2027 150 102.45 2028 167 103.69

    Terminal ValueTerminal Value = FCF * (1 + g) / (r – g) = 2129.25 billionPresent Value of Terminal ValuePV of Terminal Value = Terminal Value / (1 + WACC)^5 = 1322.10 billionPresent Value of Free Cash FlowsPresent Value of FCFs = ? (FCF / (1 + r)^n) = 506.66 billionEnterprise ValueEnterprise Value = Present Value of FCFs + Present Value of Terminal Value = 1828.76 billionNet DebtNet Debt = Total Debt – Total Cash = 37.44 billionEquity ValueEquity Value = Enterprise Value – Net Debt = 1791.32 billionPer-Share DCF ValuePer-Share DCF Value = Enterprise Value / Number of Shares Outstanding = $116.32
     Conclusion

    DCF Value Current Price Margin of Safety $116.32 $227.57 -95.64%

    Based on the DCF valuation, the stock is overvalued. The DCF value of $116.32 share is lower than the current market price of $227.57. The Margin of Safety is -95.64%. More By This Author:Coca-Cola Co Valuation: Is The Stock Undervalued?Why Peabody Energy Corp Stock Is A Buy?Mastercard Incorporated DCF Valuation: Is The Stock Undervalued?