Otter Tail Corporation (OTTR) 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
Otter Tail Corporation (OTTR) Bundle
Evaluate Otter Tail Corporation's (OTTR) financial outlook like an expert! This (OTTR) DCF Calculator provides pre-filled financial data while allowing you the freedom to modify revenue growth, WACC, margins, and other crucial assumptions to align with your projections.
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 | 919.5 | 890.1 | 1,196.8 | 1,460.2 | 1,349.2 | 1,503.2 | 1,674.8 | 1,866.0 | 2,079.0 | 2,316.3 |
| Revenue Growth, % | 0 | -3.2 | 34.46 | 22 | -7.6 | 11.42 | 11.42 | 11.42 | 11.42 | 11.42 |
| EBITDA | 213.8 | 232.5 | 342.0 | 486.1 | 499.1 | 445.6 | 496.5 | 553.2 | 616.4 | 686.7 |
| EBITDA, % | 23.25 | 26.13 | 28.57 | 33.29 | 36.99 | 29.65 | 29.65 | 29.65 | 29.65 | 29.65 |
| Depreciation | 78.1 | 82.0 | 91.4 | 92.6 | 98.0 | 117.1 | 130.4 | 145.3 | 161.9 | 180.4 |
| Depreciation, % | 8.49 | 9.22 | 7.63 | 6.34 | 7.26 | 7.79 | 7.79 | 7.79 | 7.79 | 7.79 |
| EBIT | 135.7 | 150.5 | 250.6 | 393.6 | 401.2 | 328.6 | 366.1 | 407.9 | 454.4 | 506.3 |
| EBIT, % | 14.76 | 16.91 | 20.94 | 26.95 | 29.73 | 21.86 | 21.86 | 21.86 | 21.86 | 21.86 |
| Total Cash | 21.2 | 1.2 | 1.5 | 119.0 | 230.4 | 83.5 | 93.1 | 103.7 | 115.5 | 128.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 98.9 | 114.0 | 175.0 | 144.4 | 157.1 | 179.5 | 200.0 | 222.8 | 248.3 | 276.6 |
| Account Receivables, % | 10.75 | 12.8 | 14.62 | 9.89 | 11.65 | 11.94 | 11.94 | 11.94 | 11.94 | 11.94 |
| Inventories | 97.9 | 92.2 | 148.5 | 146.0 | 149.7 | 163.8 | 182.5 | 203.4 | 226.6 | 252.5 |
| Inventories, % | 10.64 | 10.35 | 12.41 | 10 | 11.1 | 10.9 | 10.9 | 10.9 | 10.9 | 10.9 |
| Accounts Payable | 120.8 | 120.6 | 135.1 | 104.4 | 94.4 | 156.7 | 174.6 | 194.5 | 216.7 | 241.5 |
| Accounts Payable, % | 13.13 | 13.55 | 11.29 | 7.15 | 7 | 10.42 | 10.42 | 10.42 | 10.42 | 10.42 |
| Capital Expenditure | -207.4 | -371.6 | -171.8 | -171.1 | -287.1 | -335.7 | -374.0 | -416.7 | -464.3 | -517.3 |
| Capital Expenditure, % | -22.55 | -41.74 | -14.36 | -11.72 | -21.28 | -22.33 | -22.33 | -22.33 | -22.33 | -22.33 |
| Tax Rate, % | 19.06 | 19.06 | 19.06 | 19.06 | 19.06 | 19.06 | 19.06 | 19.06 | 19.06 | 19.06 |
| EBITAT | 113.0 | 124.3 | 208.1 | 312.8 | 324.7 | 269.0 | 299.7 | 333.9 | 372.0 | 414.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -92.2 | -174.8 | 24.8 | 236.7 | 109.0 | 76.2 | 34.8 | 38.8 | 43.3 | 48.2 |
| WACC, % | 6.19 | 6.18 | 6.18 | 6.15 | 6.16 | 6.17 | 6.17 | 6.17 | 6.17 | 6.17 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 204.9 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 48 | |||||||||
| Terminal Value | 854 | |||||||||
| Present Terminal Value | 633 | |||||||||
| Enterprise Value | 838 | |||||||||
| Net Debt | 675 | |||||||||
| Equity Value | 163 | |||||||||
| Diluted Shares Outstanding, MM | 42 | |||||||||
| Equity Value Per Share | 3.88 |
What You Will Receive
- Customizable Excel Template: A fully adaptable Excel-based DCF Calculator featuring pre-filled financial data for Otter Tail Corporation (OTTR).
- Accurate Data: Access to historical performance data and forward-looking projections (highlighted in the yellow cells).
- Adjustable Forecasts: Modify key assumptions such as revenue growth rates, EBITDA margins, and WACC.
- Instant Calculations: Quickly observe how your inputs influence the valuation of Otter Tail Corporation (OTTR).
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for clarity and ease of navigation, complete with step-by-step guidance.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Otter Tail Corporation (OTTR).
- WACC Calculator: Features a pre-constructed Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates as needed.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Otter Tail Corporation (OTTR).
- Visual Dashboard and Charts: Graphical outputs provide a summary of essential valuation metrics for straightforward analysis.
How It Works
- Download the Template: Gain immediate access to the Excel-based OTTR DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates Otter Tail Corporation’s intrinsic value.
- Test Scenarios: Explore various assumptions to assess potential changes in valuation.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis.
Why Choose This Calculator for Otter Tail Corporation (OTTR)?
- Comprehensive Tool: Incorporates DCF, WACC, and financial ratio analyses tailored for Otter Tail Corporation (OTTR).
- Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios for Otter Tail Corporation (OTTR).
- Detailed Insights: Automatically computes Otter Tail Corporation’s (OTTR) intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable starting points for analysis.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focusing on Otter Tail Corporation (OTTR).
Who Should Use This Product?
- Investors: Assess Otter Tail Corporation's (OTTR) valuation before making stock transactions.
- CFOs and Financial Analysts: Enhance valuation workflows and evaluate financial forecasts.
- Startup Founders: Understand the valuation methods applied to established companies like Otter Tail Corporation.
- Consultants: Provide detailed valuation analyses for client projects.
- Students and Educators: Utilize real-time data to practice and instruct on valuation strategies.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Otter Tail Corporation (OTTR) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters such as Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models that display intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate thorough analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Otter Tail Corporation (OTTR).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to simplify result analysis.