Organon & Co. (OGN) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Organon & Co. (OGN) Bundle
Gain insights into your Organon & Co. (OGN) valuation analysis using our state-of-the-art DCF Calculator! This Excel template is preloaded with real (OGN) data, enabling you to adjust forecasts and assumptions for a precise calculation of Organon & Co.'s intrinsic value.
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 | 7,777.0 | 8,096.0 | 6,304.0 | 6,174.0 | 6,263.0 | 5,970.9 | 5,692.5 | 5,427.0 | 5,174.0 | 4,932.7 |
| Revenue Growth, % | 0 | 4.1 | -22.13 | -2.06 | 1.44 | -4.66 | -4.66 | -4.66 | -4.66 | -4.66 |
| EBITDA | 4,180.0 | 2,989.0 | 1,814.0 | 1,690.0 | 1,436.0 | 2,027.1 | 1,932.5 | 1,842.4 | 1,756.5 | 1,674.6 |
| EBITDA, % | 53.75 | 36.92 | 28.78 | 27.37 | 22.93 | 33.95 | 33.95 | 33.95 | 33.95 | 33.95 |
| Depreciation | 354.0 | 142.0 | 195.0 | 212.0 | 236.0 | 198.2 | 189.0 | 180.2 | 171.8 | 163.8 |
| Depreciation, % | 4.55 | 1.75 | 3.09 | 3.43 | 3.77 | 3.32 | 3.32 | 3.32 | 3.32 | 3.32 |
| EBIT | 3,826.0 | 2,847.0 | 1,619.0 | 1,478.0 | 1,200.0 | 1,828.8 | 1,743.5 | 1,662.2 | 1,584.7 | 1,510.8 |
| EBIT, % | 49.2 | 35.17 | 25.68 | 23.94 | 19.16 | 30.63 | 30.63 | 30.63 | 30.63 | 30.63 |
| Total Cash | 319.0 | 500.0 | 737.0 | 706.0 | 693.0 | 531.0 | 506.3 | 482.7 | 460.2 | 438.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,560.0 | 1,090.0 | 1,382.0 | 1,475.0 | 1,744.0 | 1,280.0 | 1,220.3 | 1,163.4 | 1,109.1 | 1,057.4 |
| Account Receivables, % | 20.06 | 13.46 | 21.92 | 23.89 | 27.85 | 21.44 | 21.44 | 21.44 | 21.44 | 21.44 |
| Inventories | 1,071.0 | 913.0 | 915.0 | 1,003.0 | 1,315.0 | 917.2 | 874.4 | 833.6 | 794.8 | 757.7 |
| Inventories, % | 13.77 | 11.28 | 14.51 | 16.25 | 21 | 15.36 | 15.36 | 15.36 | 15.36 | 15.36 |
| Accounts Payable | 258.0 | 259.0 | 1,382.0 | 1,132.0 | 1,314.0 | 809.1 | 771.4 | 735.4 | 701.1 | 668.4 |
| Accounts Payable, % | 3.32 | 3.2 | 21.92 | 18.33 | 20.98 | 13.55 | 13.55 | 13.55 | 13.55 | 13.55 |
| Capital Expenditure | -92.0 | -278.0 | -488.0 | -427.0 | -261.0 | -279.9 | -266.9 | -254.4 | -242.6 | -231.3 |
| Capital Expenditure, % | -1.18 | -3.43 | -7.74 | -6.92 | -4.17 | -4.69 | -4.69 | -4.69 | -4.69 | -4.69 |
| Tax Rate, % | -52.01 | -52.01 | -52.01 | -52.01 | -52.01 | -52.01 | -52.01 | -52.01 | -52.01 | -52.01 |
| EBITAT | 3,331.2 | 2,294.6 | 1,430.5 | 1,208.0 | 1,824.1 | 1,601.1 | 1,526.5 | 1,455.3 | 1,387.4 | 1,322.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 1,220.2 | 2,787.6 | 1,966.5 | 562.0 | 1,400.1 | 1,876.4 | 1,513.3 | 1,442.8 | 1,375.5 | 1,311.3 |
| WACC, % | 6.15 | 5.88 | 6.2 | 5.92 | 6.69 | 6.17 | 6.17 | 6.17 | 6.17 | 6.17 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 6,370.7 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 1,318 | |||||||||
| Terminal Value | 23,259 | |||||||||
| Present Terminal Value | 17,245 | |||||||||
| Enterprise Value | 23,615 | |||||||||
| Net Debt | 8,067 | |||||||||
| Equity Value | 15,548 | |||||||||
| Diluted Shares Outstanding, MM | 256 | |||||||||
| Equity Value Per Share | 60.67 |
What You Will Get
- Real Organon Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Organon & Co. (OGN).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to Organon & Co. (OGN).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Organon & Co.'s (OGN) fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for Organon & Co. (OGN).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Organon & Co. (OGN).
Key Features
- 🔍 Real-Life OGN Financials: Pre-filled historical and projected data for Organon & Co. (OGN).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Organon’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Organon’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Organon & Co.'s pre-filled financial data and forecasts.
- Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch the DCF model update instantly as you tweak assumptions.
- Step 5: Analyze the outputs and use the results for investment decisions regarding Organon & Co. (OGN).
Why Choose This Calculator for Organon & Co. (OGN)?
- Comprehensive Tool: Offers DCF, WACC, and financial ratio analyses all in one solution.
- Customizable Inputs: Modify the yellow-highlighted cells to explore different scenarios.
- Detailed Insights: Automatically determines Organon & Co.'s intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable starting points.
- Professional Quality: Perfect for financial analysts, investors, and business consultants.
Who Should Use Organon & Co. (OGN)?
- Healthcare Investors: Make informed investment choices with reliable insights into the pharmaceutical sector.
- Market Analysts: Streamline your research with comprehensive data and analysis tools specific to Organon & Co. (OGN).
- Consultants: Efficiently tailor reports and presentations for clients focusing on women's health and biosimilars.
- Pharmaceutical Enthusiasts: Enhance your knowledge of healthcare innovations and market trends surrounding Organon & Co. (OGN).
- Students and Educators: Utilize it as a valuable resource in healthcare management and business courses.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Organon & Co. (OGN) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Organon & Co. (OGN).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.