Merck & Co., Inc. (MRK) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Merck & Co., Inc. (MRK) Bundle
Simplify Merck & Co., Inc. (MRK) valuation with this customizable DCF Calculator! Featuring real Merck & Co., Inc. (MRK) financials and adjustable forecast inputs, you can test scenarios and uncover Merck & Co., Inc. (MRK) fair value in minutes.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 46,840.0 | 41,518.0 | 48,704.0 | 59,283.0 | 60,115.0 | 64,483.9 | 69,170.4 | 74,197.4 | 79,589.8 | 85,374.1 |
| Revenue Growth, % | 0 | -11.36 | 17.31 | 21.72 | 1.4 | 7.27 | 7.27 | 7.27 | 7.27 | 7.27 |
| EBITDA | 16,009.0 | 10,180.0 | 17,899.0 | 21,315.0 | 6,907.0 | 18,428.5 | 19,767.8 | 21,204.5 | 22,745.6 | 24,398.6 |
| EBITDA, % | 34.18 | 24.52 | 36.75 | 35.95 | 11.49 | 28.58 | 28.58 | 28.58 | 28.58 | 28.58 |
| Depreciation | 3,652.0 | 3,486.0 | 3,214.0 | 3,909.0 | 3,872.0 | 4,620.5 | 4,956.3 | 5,316.5 | 5,702.9 | 6,117.4 |
| Depreciation, % | 7.8 | 8.4 | 6.6 | 6.59 | 6.44 | 7.17 | 7.17 | 7.17 | 7.17 | 7.17 |
| EBIT | 12,357.0 | 6,694.0 | 14,685.0 | 17,406.0 | 3,035.0 | 13,808.0 | 14,811.5 | 15,888.0 | 17,042.6 | 18,281.2 |
| EBIT, % | 26.38 | 16.12 | 30.15 | 29.36 | 5.05 | 21.41 | 21.41 | 21.41 | 21.41 | 21.41 |
| Total Cash | 10,450.0 | 8,062.0 | 8,096.0 | 13,192.0 | 7,093.0 | 11,917.0 | 12,783.0 | 13,712.1 | 14,708.6 | 15,777.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 6,778.0 | 7,240.0 | 9,230.0 | 9,450.0 | 10,349.0 | 10,835.3 | 11,622.8 | 12,467.5 | 13,373.6 | 14,345.6 |
| Account Receivables, % | 14.47 | 17.44 | 18.95 | 15.94 | 17.22 | 16.8 | 16.8 | 16.8 | 16.8 | 16.8 |
| Inventories | 5,978.0 | 6,310.0 | 5,953.0 | 5,911.0 | 6,358.0 | 7,832.3 | 8,401.6 | 9,012.1 | 9,667.1 | 10,369.7 |
| Inventories, % | 12.76 | 15.2 | 12.22 | 9.97 | 10.58 | 12.15 | 12.15 | 12.15 | 12.15 | 12.15 |
| Accounts Payable | 3,738.0 | 4,327.0 | 4,609.0 | 4,264.0 | 3,922.0 | 5,362.8 | 5,752.5 | 6,170.6 | 6,619.1 | 7,100.1 |
| Accounts Payable, % | 7.98 | 10.42 | 9.46 | 7.19 | 6.52 | 8.32 | 8.32 | 8.32 | 8.32 | 8.32 |
| Capital Expenditure | -3,473.0 | -4,684.0 | -4,448.0 | -4,388.0 | -3,863.0 | -5,372.4 | -5,762.9 | -6,181.7 | -6,630.9 | -7,112.9 |
| Capital Expenditure, % | -7.41 | -11.28 | -9.13 | -7.4 | -6.43 | -8.33 | -8.33 | -8.33 | -8.33 | -8.33 |
| Tax Rate, % | 80.68 | 80.68 | 80.68 | 80.68 | 80.68 | 80.68 | 80.68 | 80.68 | 80.68 | 80.68 |
| EBITAT | 10,609.7 | 5,381.2 | 13,806.8 | 15,368.4 | 586.4 | 10,159.5 | 10,897.9 | 11,689.9 | 12,539.5 | 13,450.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 1,770.7 | 3,978.2 | 11,221.8 | 14,366.4 | -1,092.6 | 8,887.8 | 9,124.4 | 9,787.5 | 10,498.8 | 11,261.9 |
| WACC, % | 6.07 | 6.04 | 6.11 | 6.08 | 5.7 | 6 | 6 | 6 | 6 | 6 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 41,454.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 11,487 | |||||||||
| Terminal Value | 287,139 | |||||||||
| Present Terminal Value | 214,562 | |||||||||
| Enterprise Value | 256,016 | |||||||||
| Net Debt | 29,359 | |||||||||
| Equity Value | 226,657 | |||||||||
| Diluted Shares Outstanding, MM | 2,547 | |||||||||
| Equity Value Per Share | 88.99 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real MRK financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the highlighted cells).
- Forecast Flexibility: Modify forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on Merck's valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation frameworks tailored for Merck & Co., Inc. (MRK).
- WACC Calculator: Pre-designed Weighted Average Cost of Capital sheet with adjustable inputs specific to the pharmaceutical sector.
- Customizable Forecast Assumptions: Adjust growth projections, capital expenditures, and discount rates as per Merck's market dynamics.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Merck & Co., Inc. (MRK).
- Visual Dashboard and Charts: Graphical representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Download the Template: Gain immediate access to the Excel-based MRK DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Merck’s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for Merck & Co., Inc. (MRK)?
- All-in-One Solution: Incorporates DCF, WACC, and financial ratio analyses tailored for Merck.
- Flexible Inputs: Modify yellow-highlighted fields to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Merck’s intrinsic value and Net Present Value.
- Preloaded Information: Historical and projected data provide reliable starting points for analysis.
- High-Quality Standards: Perfect for financial analysts, investors, and business advisors focusing on Merck.
Who Should Use This Product?
- Investors: Evaluate Merck’s valuation prior to buying or selling stocks.
- CFOs and Financial Analysts: Optimize valuation processes and assess financial projections.
- Startup Founders: Understand how large public companies like Merck are valued.
- Consultants: Provide expert valuation reports for clients.
- Students and Educators: Utilize real-world data to practice and teach valuation methodologies.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring intricate valuation calculations.
- Real-World Data: Merck & Co., Inc.'s (MRK) historical and projected financials preloaded for analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables presenting clear, actionable results.