Polaris Inc. (PII) 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
Polaris Inc. (PII) Bundle
Evaluate Polaris Inc.'s financial outlook like an expert! This (PII) DCF Calculator provides pre-filled financial data along with complete flexibility to modify revenue growth, WACC, margins, and other essential 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 | 6,782.5 | 7,027.9 | 8,198.2 | 8,589.0 | 8,934.4 | 9,583.4 | 10,279.6 | 11,026.4 | 11,827.4 | 12,686.7 |
| Revenue Growth, % | 0 | 3.62 | 16.65 | 4.77 | 4.02 | 7.26 | 7.26 | 7.26 | 7.26 | 7.26 |
| EBITDA | 719.0 | 462.7 | 881.2 | 1,066.9 | 1,013.1 | 990.8 | 1,062.8 | 1,140.0 | 1,222.8 | 1,311.7 |
| EBITDA, % | 10.6 | 6.58 | 10.75 | 12.42 | 11.34 | 10.34 | 10.34 | 10.34 | 10.34 | 10.34 |
| Depreciation | 234.5 | 260.7 | 216.4 | 232.8 | 258.9 | 295.5 | 316.9 | 339.9 | 364.6 | 391.1 |
| Depreciation, % | 3.46 | 3.71 | 2.64 | 2.71 | 2.9 | 3.08 | 3.08 | 3.08 | 3.08 | 3.08 |
| EBIT | 484.5 | 202.0 | 664.8 | 834.1 | 754.2 | 695.4 | 745.9 | 800.1 | 858.2 | 920.5 |
| EBIT, % | 7.14 | 2.87 | 8.11 | 9.71 | 8.44 | 7.26 | 7.26 | 7.26 | 7.26 | 7.26 |
| Total Cash | 157.1 | 634.7 | 509.2 | 324.5 | 367.8 | 487.9 | 523.3 | 561.3 | 602.1 | 645.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 190.4 | 261.1 | 231.9 | 363.3 | 315.4 | 328.0 | 351.8 | 377.3 | 404.8 | 434.2 |
| Account Receivables, % | 2.81 | 3.72 | 2.83 | 4.23 | 3.53 | 3.42 | 3.42 | 3.42 | 3.42 | 3.42 |
| Inventories | 1,121.1 | 1,177.6 | 1,644.8 | 1,896.1 | 1,810.5 | 1,834.1 | 1,967.3 | 2,110.2 | 2,263.5 | 2,427.9 |
| Inventories, % | 16.53 | 16.76 | 20.06 | 22.08 | 20.26 | 19.14 | 19.14 | 19.14 | 19.14 | 19.14 |
| Accounts Payable | 450.2 | 782.2 | 776.0 | 847.6 | 713.1 | 864.1 | 926.9 | 994.2 | 1,066.4 | 1,143.9 |
| Accounts Payable, % | 6.64 | 11.13 | 9.47 | 9.87 | 7.98 | 9.02 | 9.02 | 9.02 | 9.02 | 9.02 |
| Capital Expenditure | -251.4 | -213.9 | -298.3 | -306.6 | -412.6 | -356.0 | -381.9 | -409.7 | -439.4 | -471.3 |
| Capital Expenditure, % | -3.71 | -3.04 | -3.64 | -3.57 | -4.62 | -3.72 | -3.72 | -3.72 | -3.72 | -3.72 |
| Tax Rate, % | 18.96 | 18.96 | 18.96 | 18.96 | 18.96 | 18.96 | 18.96 | 18.96 | 18.96 | 18.96 |
| EBITAT | 384.9 | 178.3 | 524.8 | 661.0 | 611.2 | 565.9 | 607.0 | 651.1 | 698.4 | 749.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -493.3 | 429.9 | -1.3 | 276.1 | 456.5 | 620.2 | 447.8 | 480.3 | 515.2 | 552.6 |
| WACC, % | 9.03 | 9.24 | 9.02 | 9.03 | 9.07 | 9.08 | 9.08 | 9.08 | 9.08 | 9.08 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,036.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 564 | |||||||||
| Terminal Value | 7,962 | |||||||||
| Present Terminal Value | 5,156 | |||||||||
| Enterprise Value | 7,193 | |||||||||
| Net Debt | 1,685 | |||||||||
| Equity Value | 5,508 | |||||||||
| Diluted Shares Outstanding, MM | 58 | |||||||||
| Equity Value Per Share | 95.46 |
What You Will Get
- Real PII Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Automated Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess Polaris' future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Polaris Inc. (PII).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with customizable inputs specific to Polaris Inc. (PII).
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit Polaris Inc. (PII) projections.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Polaris Inc. (PII).
- Interactive Dashboard and Charts: Visual representations summarize key valuation metrics for straightforward analysis of Polaris Inc. (PII).
How It Works
- Download the Template: Gain immediate access to the Excel-based PII DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates Polaris’s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation shifts.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis.
Why Choose This Calculator for Polaris Inc. (PII)?
- Precise Financials: Utilize real Polaris Inc. financial data for trustworthy valuation outcomes.
- Flexible Options: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Efficient: Built-in calculations save you the hassle of starting from the ground up.
- Expert-Level Tool: Tailored for investors, analysts, and consultants in the industry.
- Easy to Use: User-friendly design and clear, step-by-step guidance cater to all experience levels.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Polaris Inc. (PII) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Polaris Inc. (PII).
- Consultants: Deliver professional valuation insights on Polaris Inc. (PII) to clients quickly and accurately.
- Business Owners: Understand how companies like Polaris Inc. (PII) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Polaris Inc. (PII).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Polaris Inc. (PII) 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 Polaris Inc. (PII).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.