Winnebago Industries, Inc. (WGO) DCF Valuation

Winnebago Industries, Inc. (WGO) 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

Winnebago Industries, Inc. (WGO) 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:

Simplify Winnebago Industries, Inc. (WGO) valuation with this customizable DCF Calculator! Featuring real Winnebago Industries, Inc. (WGO) financials and adjustable forecast inputs, you can test scenarios and uncover Winnebago Industries, Inc. (WGO) fair value in minutes.


Discounted Cash Flow (DCF) - (USD MM)

Year AY1
2020		 AY2
2021		 AY3
2022		 AY4
2023		 AY5
2024		 FY1
2025		 FY2
2026		 FY3
2027		 FY4
2028		 FY5
2029
Revenue 2,355.5 3,629.8 4,957.7 3,490.7 2,973.5 3,317.5 3,701.3 4,129.4 4,607.2 5,140.1
Revenue Growth, % 0 54.1 36.58 -29.59 -14.82 11.57 11.57 11.57 11.57 11.57
EBITDA 152.8 440.7 609.7 346.6 118.1 297.4 331.8 370.2 413.1 460.8
EBITDA, % 6.49 12.14 12.3 9.93 3.97 8.97 8.97 8.97 8.97 8.97
Depreciation 38.1 32.6 53.7 46.9 58.6 45.9 51.2 57.1 63.7 71.0
Depreciation, % 1.62 0.89706 1.08 1.34 1.97 1.38 1.38 1.38 1.38 1.38
EBIT 114.7 408.1 556.0 299.7 59.5 251.6 280.7 313.2 349.4 389.8
EBIT, % 4.87 11.24 11.22 8.59 2 7.58 7.58 7.58 7.58 7.58
Total Cash 292.6 434.6 282.2 309.9 330.9 332.3 370.8 413.7 461.5 514.9
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 220.8 253.8 254.1 178.5 183.5
Account Receivables, % 9.37 6.99 5.13 5.11 6.17
Inventories 182.9 341.5 525.8 470.6 438.7 371.7 414.6 462.6 516.1 575.8
Inventories, % 7.77 9.41 10.61 13.48 14.75 11.2 11.2 11.2 11.2 11.2
Accounts Payable 132.5 180.0 217.5 146.9 144.7 159.5 178.0 198.6 221.6 247.2
Accounts Payable, % 5.62 4.96 4.39 4.21 4.87 4.81 4.81 4.81 4.81 4.81
Capital Expenditure -32.4 -44.9 -88.0 -83.2 -45.0 -55.0 -61.3 -68.4 -76.3 -85.1
Capital Expenditure, % -1.37 -1.24 -1.77 -2.38 -1.51 -1.66 -1.66 -1.66 -1.66 -1.66
Tax Rate, % 66.15 66.15 66.15 66.15 66.15 66.15 66.15 66.15 66.15 66.15
EBITAT 91.2 313.1 422.0 231.8 20.1 172.7 192.7 215.0 239.9 267.6
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -174.3 156.8 240.5 255.7 58.4 211.6 132.9 148.2 165.4 184.5
WACC, % 9.09 9.05 9.03 9.05 8.38 8.92 8.92 8.92 8.92 8.92
PV UFCF
SUM PV UFCF 658.8
Long Term Growth Rate, % 0.50
Free cash flow (T + 1) 185
Terminal Value 2,202
Present Terminal Value 1,437
Enterprise Value 2,095
Net Debt 411
Equity Value 1,685
Diluted Shares Outstanding, MM 30
Equity Value Per Share 57.10

What You Will Get

  • Pre-Filled Financial Model: Winnebago’s actual data facilitates accurate DCF valuation.
  • Full Forecast Control: Modify revenue growth, margins, WACC, and other essential drivers.
  • Instant Calculations: Automatic updates provide real-time results as you make adjustments.
  • Investor-Ready Template: A polished Excel file crafted for high-quality valuation.
  • Customizable and Reusable: Designed for versatility, allowing repeated application for in-depth forecasts.

Key Features

  • Comprehensive Financial Data: Winnebago Industries' historical financial statements and pre-filled projections.
  • Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
  • Real-Time Analysis: View Winnebago's intrinsic value update instantly.
  • Intuitive Visualizations: Dashboard graphs showcase valuation results and essential metrics.
  • Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered Winnebago data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for Winnebago’s intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose This Calculator?

  • Designed for Industry Experts: A sophisticated tool favored by analysts, CFOs, and consultants in the recreational vehicle sector.
  • Comprehensive Data: Winnebago's historical and projected financials preloaded for enhanced accuracy.
  • Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
  • Insightful Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
  • User-Friendly Interface: Step-by-step guidance makes the process straightforward.

Who Should Use This Product?

  • Investors: Evaluate Winnebago's valuation before making stock transactions.
  • CFOs and Financial Analysts: Enhance valuation workflows and assess financial forecasts.
  • Startup Founders: Discover how established companies like Winnebago are appraised.
  • Consultants: Provide detailed valuation reports for your clients.
  • Students and Educators: Utilize real-world examples to learn and teach valuation methodologies.

What the Template Contains

  • Pre-Filled Data: Includes Winnebago Industries’ historical financials and forecasts.
  • Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
  • Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
  • Key Financial Ratios: Analyze Winnebago Industries’ profitability, efficiency, and leverage.
  • Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
  • Clear Dashboard: Charts and tables summarizing key valuation results.

No products were found matching.