Bore Family Office
Valuation Report — Merck & Co. (MRK) • March 10, 2026
Unlevered DCF (FCFF @ WACC) • Discount Rate: 7.50% • Current Price: $117.09
Prepared by Lurch • Bore Family Office • Data: Finnhub, StockAnalysis.com, S&P Global Market Intelligence
🏢 Business Overview
Merck & Co. (NYSE: MRK) is one of the world's largest pharmaceutical companies, with ~$65B in annual revenue. Its primary products span oncology, vaccines, animal health, and hospital acute care. Merck operates in over 140 countries and employs ~71,000 people globally.
Keytruda (pembrolizumab) is the dominant revenue driver — the world's best-selling oncology drug with ~$29B in 2025 global sales, representing ~45% of total company revenue. Keytruda faces U.S. patent expiration in 2028, with biosimilar entry expected in 2028-2029. Merck is developing a subcutaneous formulation (QLEX) which, if approved, could extend commercial exclusivity several years.
Pipeline offsets: Winrevair (sotatercept, PAH) launched in 2024 and ramped to nearly $1B in its first year. Capvaxive (pneumococcal vaccine) has $2B+ peak sales potential. MK-1654 (RSV mAb) and Efineptazone are in late-stage. Animal Health (~$5.9B revenue) is a growing, higher-multiple segment. Merck spent $17.9B on R&D in 2024 and has made significant acquisitions (Prometheus, Harpoon) to bolster the post-Keytruda pipeline.
2026 outlook: EPS expected to dip to ~$5.18 (non-GAAP basis differs; GAAP reflects acquisition charges) as Keytruda growth moderates and R&D investment peaks. Recovery expected in 2027+ as pipeline drugs scale and Keytruda erosion is offset by new launches.
| Business Segment | Revenue | % of Total | YoY Growth | Margin | Notes |
|---|
| Pharmaceutical — Oncology (Keytruda) | — | — | +5.0% | 42.0% | — |
| Pharmaceutical — Vaccines & Other | — | — | +3.0% | 35.0% | — |
| Animal Health | — | — | +6.0% | 30.0% | — |
📊 Financial Snapshot
| Metric | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|
| Revenue ($M) | — | — | — | — | — |
| EBITDA ($M) | $15,752 | $21,854 | $6,227 | $24,411 | $27,056 |
| Operating Income ($M) | — | — | — | — | — |
| Net Income ($M) | — | — | — | — | — |
| EPS (diluted) | $4.86 | $5.71 | $0.14 | $6.74 | $7.28 |
| Free Cash Flow ($M) | $9,661 | $14,707 | $9,143 | $18,096 | $12,360 |
| Annual DPS | $2.600 | $2.760 | $2.920 | $3.080 | $3.240 |
| Total Debt ($M) | — | — | — | — | — |
| Rev YoY Growth | — | — | — | — | — |
⚙️ WACC Build (DCF)
| Input | Value | Notes |
|---|
| Risk-Free Rate (Rf) | 4.30% | 10-yr US Treasury yield |
| Beta (β) | 0.260 | Market beta (Finnhub) |
| Equity Risk Premium (ERP) | 5.5% | Damodaran US ERP |
| Cost of Equity (Ke) | 5.73% | Ke = Rf + β × ERP |
| Pre-Tax Cost of Debt | 4.00% | Interest exp / gross debt |
| After-Tax Cost of Debt (Kd) | 3.44% | × (1 − 14%) |
| Weight Equity (We) | 77.0% | Mkt cap $0.0B |
| Weight Debt (Wd) | 23.0% | Gross debt $0.0B |
| WACC | 7.50% | DCF discount rate |
📈 DCF Scenarios
| Scenario | Stage 1 (Yrs 1–5) | Stage 2 (Yrs 6–10) | Terminal g | WACC | Intrinsic Value | vs Price |
|---|
| 🔴 Bear | 2.0% | -1.0% | 2.0% | 7.50% | $86 | ▼26.2% |
| 📊 Base | 4.0% | 3.0% | 2.5% | 7.50% | $120 | ▲2.1% |
| 🚀 Bull | 7.0% | 5.0% | 3.0% | 7.50% | $162 | ▲38.2% |


📋 Full 10-Year Projection Tables
Bear Scenario
Stage 1: 2.0% | Stage 2: -1.0% | Terminal: 2.0%
| Period | Stage | FCFF | PV of FCFF | Cumulative EV |
|---|
| Year 1 | Stage 1 | $15.30B | $14.23B | $14.23B |
| Year 2 | Stage 1 | $15.61B | $13.50B | $27.74B |
| Year 3 | Stage 1 | $15.92B | $12.81B | $40.55B |
| Year 4 | Stage 1 | $16.24B | $12.16B | $52.71B |
| Year 5 | Stage 1 | $16.56B | $11.54B | $64.24B |
| Year 6 | Stage 2 | $16.40B | $10.62B | $74.87B |
| Year 7 | Stage 2 | $16.23B | $9.78B | $84.65B |
| Year 8 | Stage 2 | $16.07B | $9.01B | $93.66B |
| Year 9 | Stage 2 | $15.91B | $8.30B | $101.96B |
| Year 10 | Stage 2 | $15.75B | $7.64B | $109.60B |
| Terminal | — | TV=$292.1B | PV(TV)=$141.7B (56% of EV) | EV=$251.3B |
Base Scenario
Stage 1: 4.0% | Stage 2: 3.0% | Terminal: 2.5%
| Period | Stage | FCFF | PV of FCFF | Cumulative EV |
|---|
| Year 1 | Stage 1 | $15.60B | $14.51B | $14.51B |
| Year 2 | Stage 1 | $16.22B | $14.04B | $28.55B |
| Year 3 | Stage 1 | $16.87B | $13.58B | $42.13B |
| Year 4 | Stage 1 | $17.55B | $13.14B | $55.27B |
| Year 5 | Stage 1 | $18.25B | $12.71B | $67.98B |
| Year 6 | Stage 2 | $18.80B | $12.18B | $80.16B |
| Year 7 | Stage 2 | $19.36B | $11.67B | $91.83B |
| Year 8 | Stage 2 | $19.94B | $11.18B | $103.02B |
| Year 9 | Stage 2 | $20.54B | $10.71B | $113.73B |
| Year 10 | Stage 2 | $21.16B | $10.27B | $123.99B |
| Terminal | — | TV=$433.7B | PV(TV)=$210.4B (63% of EV) | EV=$334.4B |
Bull Scenario
Stage 1: 7.0% | Stage 2: 5.0% | Terminal: 3.0%
| Period | Stage | FCFF | PV of FCFF | Cumulative EV |
|---|
| Year 1 | Stage 1 | $16.05B | $14.93B | $14.93B |
| Year 2 | Stage 1 | $17.17B | $14.86B | $29.79B |
| Year 3 | Stage 1 | $18.38B | $14.79B | $44.58B |
| Year 4 | Stage 1 | $19.66B | $14.72B | $59.31B |
| Year 5 | Stage 1 | $21.04B | $14.65B | $73.96B |
| Year 6 | Stage 2 | $22.09B | $14.31B | $88.27B |
| Year 7 | Stage 2 | $23.19B | $13.98B | $102.25B |
| Year 8 | Stage 2 | $24.35B | $13.66B | $115.91B |
| Year 9 | Stage 2 | $25.57B | $13.34B | $129.25B |
| Year 10 | Stage 2 | $26.85B | $13.03B | $142.28B |
| Terminal | — | TV=$614.6B | PV(TV)=$298.2B (68% of EV) | EV=$440.5B |
🔲 Sensitivity Table
| WACC \ gT | 1.5% | 2.0% | 2.5% | 3.0% | 3.5% |
|---|
| 5.5% | $166 | $185 | $210 | $244 | $296 |
| 6.0% | $146 | $160 | $177 | $201 | $234 |
| 6.5% | $129 | $140 | $153 | $170 | $193 |
| 7.0% | $116 | $124 | $135 | $147 | $164 |
| 7.5% | $105 | $112 | $120 | $129 | $142 |
| 8.0% | $95 | $101 | $107 | $115 | $124 |
| 8.5% | $87 | $92 | $97 | $103 | $111 |
| 9.0% | $80 | $84 | $88 | $93 | $99 |
| 9.5% | $74 | $77 | $81 | $85 | $90 |
Green = >10% above current price. Red = >10% below. Gold = within ±10%.
📉 Long-Term Price Trend Channel
Log-linear trend fitted to full price history. ±1.5σ bands. Green shaded zone = bottom 25% of historical range — historically attractive entry.

🏦 Comparable Valuation
| Company | Ticker | P/E (fwd) | EV/EBITDA | FCF Yield | Div Yield | Rev Growth |
|---|
| Merck & Co. | MRK | 22.6x | 12.5x | 4.2% | 2.9% | 1% |
| Eli Lilly | LLY | 35.0x | 30.0x | 1.5% | 0.6% | 32% |
| AbbVie | ABBV | 14.5x | 12.0x | 5.8% | 3.4% | 4% |
| Bristol-Myers | BMY | 11.0x | 9.0x | 7.1% | 4.1% | 5% |
| Johnson & Johnson | JNJ | 15.0x | 12.5x | 5.2% | 3.1% | 4% |
| Pfizer | PFE | 10.5x | 8.0x | 6.5% | 6.4% | -7% |
💰 Dividend / Distribution Analysis
| Metric | Value |
|---|
| Annual DPS | $3.400 |
| Current Yield | 2.90% |
| Consecutive Growth Years | 15 |
| 1-yr DPS CAGR | +5.2% |
| 3-yr DPS CAGR | +5.6% |
| 5-yr DPS CAGR | +5.7% |
| 10-yr DPS CAGR | +7.3% |
| Payout Ratio (DPS/EPS) | 46.7% |
| FCF Payout Ratio | 27.6% |
| Sustainability Verdict | Safe — strong FCF coverage; payout ratio well within sustainable range |
Merck has raised its dividend for 15+ consecutive years with a 5-6% CAGR. The payout ratio is ~47% of earnings and only ~28% of FCF — extremely well covered. Even under the Bear scenario (Keytruda biosimilar pressure), FCF supports the dividend. The main risk to the dividend is not financial but strategic: if Merck over-spends on acquisitions to fill the pipeline gap, FCF could compress temporarily. However, the track record is strong and the balance sheet can absorb it. Ex-dividend date is March 16, 2026.

🔮 Analyst Forecast Section
(a) EPS Consensus
| Year | Low / Actual | Avg | High | # Analysts | Type |
|---|
| 2024 | $6.74 | — | — | — | Actual |
| 2025 | $7.28 | — | — | — | Actual |
| 2026 | $4.90 | $5.18 | $5.57 | 31 | Estimate |
| 2027 | $8.92 | $9.85 | $10.95 | 31 | Estimate |
(b) Revenue Consensus
| Year | Low / Actual | Avg | High | # Analysts | Type |
|---|
| 2024 | $64.2B | — | — | — | Actual |
| 2025 | $65.0B | — | — | — | Actual |
| 2026 | $64.8B | $67.4B | $70.8B | 31 | Estimate |
| 2027 | $65.8B | $71.1B | $75.9B | 31 | Estimate |
(c) Individual Analyst Price Targets
Consensus: Avg $123.21 | Range $90–$142
| Analyst | Firm | Rating | PT | Upside |
|---|
| Trung Huynh | RBC Capital | Buy | $142 | +21.3% |
| Emily Field | Barclays | Buy | $140 | +19.6% |
| Vamil Divan | Guggenheim | Strong Buy | $140 | +19.6% |
| Geoff Meacham | Citigroup | Hold | $120 | +2.5% |
| Carter Gould | Cantor Fitzgerald | Hold | $120 | +2.5% |
(d) Earnings Surprise History
| Quarter | EPS Act vs Est | EPS Beat/Miss | Rev Act vs Est | Rev Beat/Miss | Guidance |
|---|
| Q4 2025 | $1.72 vs $1.68 | +$0.04 ✅ | $15.6B vs $15.3B | +$0.3B ✅ | FY26 EPS ~$8.88-9.03 non-GAAP |
| Q3 2025 | $1.57 vs $1.50 | +$0.07 ✅ | $16.7B vs $16.2B | +$0.5B ✅ | — |
| Q2 2025 | $2.14 vs $2.07 | +$0.07 ✅ | $16.1B vs $15.7B | +$0.4B ✅ | — |
| Q1 2025 | $2.22 vs $2.14 | +$0.08 ✅ | $15.5B vs $15.1B | +$0.4B ✅ | — |
(e) Confidence Band Commentary
14 analysts covering MRK. Consensus Buy with avg PT $123.21 (~5% upside from current). Wide PT range ($90–$142) reflects genuine uncertainty around the Keytruda cliff timeline. Bulls (RBC, Barclays, Guggenheim at $140-142) believe subQ Keytruda + pipeline fill-in story; Bears cite biosimilar entry risk and 2026 EPS trough. MRK has beaten EPS estimates in each of the last 4 quarters by 4-5%.


💡 Investment Thesis
The core question: Is the Keytruda cliff already priced in at $117? Yes — and then some. MRK fell from $125 to $73 in 2025 on patent cliff fears, then recovered. At 16x trailing EPS and 23x forward (trough year), the stock is pricing in meaningful pain.
Bull case: Subcutaneous Keytruda (QLEX) gets approved and extends commercial exclusivity well past 2028. Winrevair ($1B run-rate in year 1) is a blockbuster with room to grow. Capvaxive, the next-gen pneumococcal vaccine, could be a $2B+ product. Animal Health trades at 20x+ earnings as a standalone — it's a hidden gem inside MRK. At $117, you get the #1 oncology drug, a growing pipeline, 3% yield, and 15 years of dividend growth for 16x earnings.
Bear case: Keytruda accounts for ~45% of revenue. Even with subQ, biosimilars will erode sales starting 2028-2029. R&D spend of $17-18B/year is enormous — if acquisitions (Prometheus, Harpoon) disappoint, there's no backstop. The 2026 EPS trough (~$5.18 consensus) reflects the inflection point — if the pipeline doesn't deliver, multiple compression follows.
My take: Accumulate. MRK is the rare large-cap pharma where the bear case is well-understood and well-discounted. The dividend is safe, the pipeline is credible, and subQ Keytruda is a legitimate optionality event. Ex-dividend date is March 16 — worth noting for timing. I'd build a full position at current levels. Strong Buy below $110.
⚖️ DCF Verdict: Hold — Merck & Co. (MRK)
Current price: $117.09 | Analyst Avg PT: $123.21
| Tier | Price | Action |
|---|
| Tier 1 — Starter | ≤$110 | Begin position |
| Tier 2 — Add | ≤$103 | Add on weakness |
| Tier 3 — Full | ≤$91 | Full allocation |
| Sell Alert | ≥$138 | Above fair value — consider trimming |
Build a position at current levels. Keytruda cliff is well-priced; pipeline + subQ QLEX provides upside optionality. 3% yield with 15 years of growth. Strong Buy below $110.
Bore Family Office • Analysis generated by Lurch • Not investment advice.