Wabash National Corporation (WNC) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Wabash National Corporation (WNC) Bundle
Explore Wabash National Corporation's (WNC) financial outlook with our user-friendly DCF Calculator! Enter your projections for growth, profit margins, and expenses to calculate WNC's intrinsic value and inform your investment decisions.
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 | 2,319.1 | 1,481.9 | 1,803.3 | 2,502.1 | 2,536.5 | 2,699.6 | 2,873.1 | 3,057.8 | 3,254.4 | 3,463.6 |
Revenue Growth, % | 0 | -36.1 | 21.69 | 38.76 | 1.37 | 6.43 | 6.43 | 6.43 | 6.43 | 6.43 |
EBITDA | 142.8 | -37.1 | 73.3 | 214.3 | 359.9 | 164.5 | 175.1 | 186.3 | 198.3 | 211.1 |
EBITDA, % | 6.16 | -2.5 | 4.06 | 8.56 | 14.19 | 6.09 | 6.09 | 6.09 | 6.09 | 6.09 |
Depreciation | 42.4 | 48.0 | 48.8 | 47.0 | 45.3 | 61.8 | 65.7 | 69.9 | 74.4 | 79.2 |
Depreciation, % | 1.83 | 3.24 | 2.71 | 1.88 | 1.79 | 2.29 | 2.29 | 2.29 | 2.29 | 2.29 |
EBIT | 100.4 | -85.0 | 24.4 | 167.3 | 314.5 | 102.8 | 109.4 | 116.4 | 123.9 | 131.8 |
EBIT, % | 4.33 | -5.74 | 1.35 | 6.69 | 12.4 | 3.81 | 3.81 | 3.81 | 3.81 | 3.81 |
Total Cash | 140.5 | 217.7 | 71.8 | 58.2 | 179.3 | 184.2 | 196.1 | 208.7 | 222.1 | 236.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 172.7 | 101.3 | 176.5 | 255.6 | 183.0 | 224.1 | 238.5 | 253.8 | 270.1 | 287.5 |
Account Receivables, % | 7.45 | 6.84 | 9.79 | 10.21 | 7.21 | 8.3 | 8.3 | 8.3 | 8.3 | 8.3 |
Inventories | 186.9 | 163.8 | 237.6 | 243.9 | 267.6 | 283.9 | 302.2 | 321.6 | 342.3 | 364.3 |
Inventories, % | 8.06 | 11.05 | 13.18 | 9.75 | 10.55 | 10.52 | 10.52 | 10.52 | 10.52 | 10.52 |
Accounts Payable | 134.8 | 104.4 | 174.0 | 189.1 | 156.6 | 195.7 | 208.2 | 221.6 | 235.9 | 251.0 |
Accounts Payable, % | 5.81 | 7.05 | 9.65 | 7.56 | 6.17 | 7.25 | 7.25 | 7.25 | 7.25 | 7.25 |
Capital Expenditure | -37.6 | -20.1 | -49.1 | -57.1 | -98.1 | -64.0 | -68.1 | -72.5 | -77.2 | -82.1 |
Capital Expenditure, % | -1.62 | -1.36 | -2.72 | -2.28 | -3.87 | -2.37 | -2.37 | -2.37 | -2.37 | -2.37 |
Tax Rate, % | 21.53 | 21.53 | 21.53 | 21.53 | 21.53 | 21.53 | 21.53 | 21.53 | 21.53 | 21.53 |
EBITAT | 76.4 | -75.8 | 22.0 | 128.2 | 246.8 | 84.4 | 89.8 | 95.6 | 101.7 | 108.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -143.7 | 16.2 | -57.8 | 48.0 | 210.3 | 63.8 | 67.3 | 71.7 | 76.3 | 81.2 |
WACC, % | 9.06 | 9.27 | 9.29 | 9.07 | 9.1 | 9.16 | 9.16 | 9.16 | 9.16 | 9.16 |
PV UFCF | ||||||||||
SUM PV UFCF | 276.2 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 84 | |||||||||
Terminal Value | 1,358 | |||||||||
Present Terminal Value | 876 | |||||||||
Enterprise Value | 1,153 | |||||||||
Net Debt | 226 | |||||||||
Equity Value | 926 | |||||||||
Diluted Shares Outstanding, MM | 48 | |||||||||
Equity Value Per Share | 19.29 |
What You Will Get
- Real WNC Financial Data: Pre-filled with Wabash National 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 Wabash National 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 WNC Financials: Gain access to precise pre-loaded historical data and future forecasts.
- Adjustable Forecast Parameters: Modify highlighted cells such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to clearly present your valuation outcomes.
- Designed for All Skill Levels: An intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the prebuilt Excel template featuring Wabash National Corporation’s (WNC) data.
- Step 2: Navigate through 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 updated results, including Wabash National Corporation’s (WNC) intrinsic value.
- Step 5: Use the outputs to make informed investment choices or create detailed reports.
Why Choose This Calculator for Wabash National Corporation (WNC)?
- User-Friendly Interface: Crafted for both novices and seasoned professionals.
- Customizable Inputs: Adjust variables effortlessly to suit your financial analysis.
- Real-Time Valuation: Observe immediate updates to Wabash National's valuation with input changes.
- Preloaded Data: Comes with Wabash National's actual financial metrics for swift evaluation.
- Preferred by Experts: Utilized by investors and analysts for making well-informed choices.
Who Should Use Wabash National Corporation (WNC) Products?
- Fleet Managers: Optimize your operations with innovative trailer solutions designed for efficiency.
- Logistics Coordinators: Streamline your supply chain with durable and reliable transportation equipment.
- Manufacturers: Enhance productivity with cutting-edge technology and customizable products.
- Environmental Advocates: Promote sustainability with eco-friendly transportation solutions.
- Industry Educators and Students: Utilize our resources for hands-on learning in transportation and logistics courses.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Wabash National Corporation (WNC).
- Real-World Data: Wabash National'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 for enhanced insights into WNC's performance.
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to Wabash National Corporation (WNC).
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results regarding WNC.