SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Strategies & Market Trends : Technical analysis for shorts & longs
SPY 681.43+1.6%Nov 10 4:00 PM EST

 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
To: Johnny Canuck who wrote (67468)11/2/2025 1:48:32 AM
From: Johnny Canuck1 Recommendation

Recommended By
E_K_S

  Read Replies (1) of 67816
 
Chain of Thought for DCF Valuation of Novo Nordisk (NVO) To determine the Discounted Cash Flow (DCF) intrinsic value per share for Novo Nordisk (NVO), we use a two-stage DCF model. This approach projects free cash flows (FCF) over a high-growth period (typically 5 years), calculates a terminal value for perpetuity beyond that, discounts everything back to present value using the weighted average cost of capital (WACC), and divides by shares outstanding to get the per-share value. The model assumes no significant net debt adjustment (NVO has low debt), so enterprise value approximates equity value.

Step 1: Gather Key Inputs Based on recent financial data (as of November 1, 2025):

  • Trailing Twelve Months (TTM) FCF: $9.3 billion USD (from GuruFocus, as of June 2025). This serves as the base for projections.
  • High-Growth Rate (Years 1-5): 10% annually. This is a conservative estimate given recent analyst revisions; Novo Nordisk lowered its 2025 sales growth guidance to ~8-10% due to competition in GLP-1 drugs (e.g., Ozempic/Wegovy), but historical momentum and pipeline support this range.
  • Terminal Growth Rate: 3%. This aligns with long-term inflation/GDP proxies and pharma sector perpetuity assumptions from multiple sources (e.g., ValueSense, Reddit analyses).
  • Discount Rate (WACC): 7%. This is an average from reliable estimates (Finbox: 7.2%, AlphaSpread: 6.24%, adjusted for NVO's beta ~0.9 and risk-free rate ~4%). Lower figures (e.g., GuruFocus 1.19%) seem outlier-low and were excluded.
  • Shares Outstanding: 4.45 billion (diluted, from Yahoo Finance and Macrotrends, Q2 2025).
All figures are in USD for consistency (using ~6.47 DKK/USD exchange rate).

Step 2: Project Future Free Cash Flows Start with FCF0 = $9.3B. Grow at 10% for 5 years:

  • Year 1: $9.3B × 1.10 = $10.23B
  • Year 2: $10.23B × 1.10 = $11.25B
  • Year 3: $11.25B × 1.10 = $12.38B
  • Year 4: $12.38B × 1.10 = $13.62B
  • Year 5: $13.62B × 1.10 = $14.98B
Step 3: Calculate Terminal Value At the end of Year 5, assume perpetual growth at 3%. Terminal value (TV) = FCF6 / (WACC - g), where FCF6 = $14.98B × 1.03 = $15.43B. TV = $15.43B / (0.07 - 0.03) = $15.43B / 0.04 = $385.68B.

Step 4: Discount to Present Value Discount each FCF and TV at WACC = 7%:

  • PV(Year 1 FCF) = $10.23B / 1.07¹ = $9.56B
  • PV(Year 2 FCF) = $11.25B / 1.07² = $9.83B
  • PV(Year 3 FCF) = $12.38B / 1.07³ = $10.10B
  • PV(Year 4 FCF) = $13.62B / 1.074 = $10.39B
  • PV(Year 5 FCF) = $14.98B / 1.075 = $10.68B
  • Sum of PV(FCFs) = $50.56B
  • PV(TV) = $385.68B / 1.075 = $274.98B
Enterprise Value (EV) = Sum PV(FCFs) + PV(TV) = $50.56B + $274.98B = $325.54B.

Step 5: Derive Per-Share Value Intrinsic Value per Share = EV / Shares Outstanding = $325.54B / 4.45B = $73.16.

Step 6: Interpretation and Sensitivity
  • Current stock price (Nov 1, 2025): ~$49.50. This implies ~32% undervaluation, consistent with broader estimates (e.g., ValueSense: $80.20, undervalued 56%; GuruFocus dividend-based: $72.70). Higher-growth scenarios (e.g., Simply Wall St's $120.72) assume 15%+ growth; lower ones (e.g., AlphaSpread ~$61) use ~8% growth and 2% terminal.
  • Sensitivity: If growth = 12%, value rises to ~$85; if WACC = 8%, value falls to ~$65. DCF is sensitive to assumptions—use for directional insight, not precision.
This model can be replicated in a spreadsheet or Python (as I did for verification). For custom tweaks, adjust inputs based on latest earnings (Q3 due Nov 5, 2025).
Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext