Oshkosh Corporation (OSK) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Oshkosh Corporation (OSK) Bundle
Designed for accuracy, our (OSK) DCF Calculator enables you to evaluate Oshkosh Corporation's valuation using real-world financial data, offering complete flexibility to modify all key parameters for improved 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 | 8,382.0 | 6,856.8 | 7,737.3 | 8,282.0 | 9,648.3 | 10,086.9 | 10,545.4 | 11,024.7 | 11,525.9 | 12,049.8 |
Revenue Growth, % | 0 | -18.2 | 12.84 | 7.04 | 16.5 | 4.55 | 4.55 | 4.55 | 4.55 | 4.55 |
EBITDA | 920.3 | 602.6 | 650.1 | 444.3 | 988.7 | 883.2 | 923.4 | 965.4 | 1,009.3 | 1,055.1 |
EBITDA, % | 10.98 | 8.79 | 8.4 | 5.36 | 10.25 | 8.76 | 8.76 | 8.76 | 8.76 | 8.76 |
Depreciation | 115.2 | 104.2 | 104.0 | 72.0 | 144.9 | 133.3 | 139.4 | 145.7 | 152.4 | 159.3 |
Depreciation, % | 1.37 | 1.52 | 1.34 | 0.86936 | 1.5 | 1.32 | 1.32 | 1.32 | 1.32 | 1.32 |
EBIT | 805.1 | 498.4 | 546.1 | 372.3 | 843.8 | 749.9 | 784.0 | 819.6 | 856.9 | 895.8 |
EBIT, % | 9.61 | 7.27 | 7.06 | 4.5 | 8.75 | 7.43 | 7.43 | 7.43 | 7.43 | 7.43 |
Total Cash | 448.4 | 582.9 | 1,375.8 | 805.9 | 125.4 | 860.7 | 899.8 | 940.7 | 983.4 | 1,028.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1,631.8 | 1,341.2 | 1,716.5 | 1,769.9 | 2,130.2 | 2,111.4 | 2,207.4 | 2,307.7 | 2,412.6 | 2,522.3 |
Account Receivables, % | 19.47 | 19.56 | 22.18 | 21.37 | 22.08 | 20.93 | 20.93 | 20.93 | 20.93 | 20.93 |
Inventories | 1,249.2 | 1,505.4 | 1,267.4 | 1,865.6 | 2,131.6 | 1,974.2 | 2,063.9 | 2,157.7 | 2,255.8 | 2,358.3 |
Inventories, % | 14.9 | 21.95 | 16.38 | 22.53 | 22.09 | 19.57 | 19.57 | 19.57 | 19.57 | 19.57 |
Accounts Payable | 795.5 | 577.8 | 860.4 | 1,129.0 | 1,214.5 | 1,114.7 | 1,165.4 | 1,218.4 | 1,273.8 | 1,331.7 |
Accounts Payable, % | 9.49 | 8.43 | 11.12 | 13.63 | 12.59 | 11.05 | 11.05 | 11.05 | 11.05 | 11.05 |
Capital Expenditure | -195.0 | -130.2 | -114.8 | -279.7 | -325.3 | -251.3 | -262.7 | -274.7 | -287.2 | -300.2 |
Capital Expenditure, % | -2.33 | -1.9 | -1.48 | -3.38 | -3.37 | -2.49 | -2.49 | -2.49 | -2.49 | -2.49 |
Tax Rate, % | 25.03 | 25.03 | 25.03 | 25.03 | 25.03 | 25.03 | 25.03 | 25.03 | 25.03 | 25.03 |
EBITAT | 621.4 | 368.3 | 518.5 | 234.9 | 632.6 | 576.1 | 602.3 | 629.6 | 658.3 | 688.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -1,543.9 | 159.0 | 653.0 | -355.8 | -88.6 | 534.6 | 343.9 | 359.5 | 375.8 | 392.9 |
WACC, % | 9.24 | 9.21 | 9.4 | 9.1 | 9.22 | 9.23 | 9.23 | 9.23 | 9.23 | 9.23 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,570.0 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 401 | |||||||||
Terminal Value | 5,541 | |||||||||
Present Terminal Value | 3,563 | |||||||||
Enterprise Value | 5,133 | |||||||||
Net Debt | 952 | |||||||||
Equity Value | 4,181 | |||||||||
Diluted Shares Outstanding, MM | 66 | |||||||||
Equity Value Per Share | 63.47 |
What You Will Get
- Real OSK Financial Data: Pre-filled with Oshkosh Corporation’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Oshkosh Corporation’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive DCF Calculator: Features both unlevered and levered DCF valuation models tailored for Oshkosh Corporation (OSK).
- WACC Tool: A ready-to-use Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Inputs: Alter growth projections, capital expenditures, and discount rates as needed.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Oshkosh Corporation (OSK).
- Visual Dashboard and Charts: Graphical representations that highlight essential valuation metrics for streamlined analysis.
How It Works
- Step 1: Download the prebuilt Excel template featuring Oshkosh Corporation’s (OSK) data.
- Step 2: Review the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Adjust forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see recalibrated results, highlighting Oshkosh Corporation’s (OSK) intrinsic value.
- Step 5: Make well-informed investment choices or create reports based on the outputs.
Why Choose This Calculator for Oshkosh Corporation (OSK)?
- User-Friendly Interface: Crafted for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Valuation: Observe immediate updates to Oshkosh’s valuation as you tweak the inputs.
- Preloaded Data: Comes equipped with Oshkosh’s latest financial information for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making strategic decisions.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for assessing investments in Oshkosh Corporation (OSK).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights to clients investing in Oshkosh Corporation (OSK).
- Students and Educators: Utilize real-world data for hands-on experience in financial modeling and analysis.
- Industry Enthusiasts: Gain insights into how companies like Oshkosh Corporation (OSK) are valued in the market.
What the Oshkosh Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Oshkosh Corporation (OSK).
- Real-World Data: Oshkosh’s historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns to provide deeper insights into performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to Oshkosh Corporation (OSK).
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results.