Wabash National Corporation (WNC) DCF Valuation

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

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 7.45 6.84 9.79 10.21 7.21
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.