Olin Corporation (OLN) 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
Olin Corporation (OLN) Bundle
Discover the true potential of Olin Corporation (OLN) with our advanced DCF Calculator! Adjust key assumptions, explore various scenarios, and evaluate how changes affect Olin Corporation (OLN) valuation – all within a comprehensive Excel template.
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 | 6,110.0 | 5,758.0 | 8,910.6 | 9,376.2 | 6,833.0 | 7,295.8 | 7,789.9 | 8,317.5 | 8,880.9 | 9,482.4 |
| Revenue Growth, % | 0 | -5.76 | 54.75 | 5.23 | -27.12 | 6.77 | 6.77 | 6.77 | 6.77 | 6.77 |
| EBITDA | 827.0 | -142.5 | 2,324.7 | 2,439.7 | 1,300.5 | 1,199.5 | 1,280.7 | 1,367.4 | 1,460.1 | 1,558.9 |
| EBITDA, % | 13.54 | -2.47 | 26.09 | 26.02 | 19.03 | 16.44 | 16.44 | 16.44 | 16.44 | 16.44 |
| Depreciation | 619.0 | 585.2 | 592.0 | 619.8 | 533.4 | 603.4 | 644.3 | 687.9 | 734.5 | 784.3 |
| Depreciation, % | 10.13 | 10.16 | 6.64 | 6.61 | 7.81 | 8.27 | 8.27 | 8.27 | 8.27 | 8.27 |
| EBIT | 208.0 | -727.7 | 1,732.7 | 1,819.9 | 767.1 | 596.0 | 636.4 | 679.5 | 725.5 | 774.7 |
| EBIT, % | 3.4 | -12.64 | 19.45 | 19.41 | 11.23 | 8.17 | 8.17 | 8.17 | 8.17 | 8.17 |
| Total Cash | 220.9 | 189.7 | 180.5 | 194.0 | 170.3 | 196.9 | 210.3 | 224.5 | 239.7 | 256.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 774.3 | 786.0 | 1,106.8 | 967.8 | 890.0 | 906.0 | 967.4 | 1,032.9 | 1,102.9 | 1,177.5 |
| Account Receivables, % | 12.67 | 13.65 | 12.42 | 10.32 | 13.03 | 12.42 | 12.42 | 12.42 | 12.42 | 12.42 |
| Inventories | 695.7 | 674.7 | 868.3 | 941.9 | 858.8 | 809.3 | 864.1 | 922.6 | 985.1 | 1,051.8 |
| Inventories, % | 11.39 | 11.72 | 9.74 | 10.05 | 12.57 | 11.09 | 11.09 | 11.09 | 11.09 | 11.09 |
| Accounts Payable | 651.9 | 729.2 | 847.7 | 837.7 | 775.4 | 775.2 | 827.7 | 883.8 | 943.7 | 1,007.6 |
| Accounts Payable, % | 10.67 | 12.66 | 9.51 | 8.93 | 11.35 | 10.63 | 10.63 | 10.63 | 10.63 | 10.63 |
| Capital Expenditure | -385.6 | -298.9 | -200.6 | -236.9 | -236.0 | -287.9 | -307.4 | -328.3 | -350.5 | -374.2 |
| Capital Expenditure, % | -6.31 | -5.19 | -2.25 | -2.53 | -3.45 | -3.95 | -3.95 | -3.95 | -3.95 | -3.95 |
| Tax Rate, % | 17.72 | 17.72 | 17.72 | 17.72 | 17.72 | 17.72 | 17.72 | 17.72 | 17.72 | 17.72 |
| EBITAT | 63.7 | -692.0 | 1,460.2 | 1,440.8 | 631.2 | 442.8 | 472.8 | 504.8 | 539.0 | 575.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -521.0 | -319.1 | 1,455.7 | 1,879.1 | 1,027.2 | 791.6 | 745.9 | 796.5 | 850.4 | 908.0 |
| WACC, % | 7.34 | 8.92 | 8.66 | 8.53 | 8.61 | 8.41 | 8.41 | 8.41 | 8.41 | 8.41 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 3,211.8 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 913 | |||||||||
| Terminal Value | 11,532 | |||||||||
| Present Terminal Value | 7,700 | |||||||||
| Enterprise Value | 10,912 | |||||||||
| Net Debt | 2,852 | |||||||||
| Equity Value | 8,060 | |||||||||
| Diluted Shares Outstanding, MM | 129 | |||||||||
| Equity Value Per Share | 62.57 |
What You Will Receive
- Authentic OLN Financial Data: Pre-filled with Olin Corporation’s historical and forecasted data for accurate analysis.
- Completely Customizable Template: Easily adjust key inputs such as revenue growth, WACC, and EBITDA %.
- Instant Calculations: Watch Olin Corporation’s intrinsic value update immediately based on your modifications.
- Expert Valuation Tool: Tailored for investors, analysts, and consultants in search of precise DCF results.
- Intuitive Design: Clear layout and straightforward instructions suitable for all experience levels.
Key Features
- 🔍 Real-Life OLN Financials: Pre-filled historical and projected data for Olin Corporation (OLN).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Olin’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Olin’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 prebuilt Excel template with Olin Corporation’s (OLN) data included.
- Step 2: Explore the pre-filled sheets and understand the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including Olin Corporation’s (OLN) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose This Calculator for Olin Corporation (OLN)?
- User-Friendly Interface: Perfect for both novices and seasoned analysts.
- Customizable Inputs: Adjust parameters effortlessly to suit your evaluation needs.
- Real-Time Feedback: Instantly view updates on Olin’s valuation as you tweak inputs.
- Preloaded Data: Comes equipped with Olin’s latest financial metrics for immediate analysis.
- Preferred by Experts: Valued by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Investors: Accurately assess Olin Corporation’s (OLN) fair value prior to making investment choices.
- CFOs: Utilize a high-quality DCF model for comprehensive financial reporting and analysis of Olin Corporation (OLN).
- Consultants: Efficiently customize the template for valuation reports tailored to Olin Corporation (OLN) clients.
- Entrepreneurs: Acquire knowledge of financial modeling practices employed by leading companies like Olin Corporation (OLN).
- Educators: Implement it as a learning resource to illustrate various valuation methodologies related to Olin Corporation (OLN).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Olin Corporation (OLN) 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 Olin Corporation (OLN).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.