LCI Industries (LCII) DCF Valuation

LCI Industries (LCII) 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

LCI Industries (LCII) 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:

Discover the true potential of LCI Industries (LCII) with our advanced DCF Calculator! Adjust key assumptions, explore various scenarios, and see how different changes affect LCI Industries (LCII) valuation – all within a user-friendly Excel template.


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,371.5 2,796.2 4,472.7 5,207.1 3,784.8 4,418.5 5,158.3 6,021.9 7,030.2 8,207.2
Revenue Growth, % 0 17.91 59.96 16.42 -27.32 16.74 16.74 16.74 16.74 16.74
EBITDA 275.6 320.9 510.7 682.2 255.2 480.4 560.8 654.7 764.3 892.3
EBITDA, % 11.62 11.48 11.42 13.1 6.74 10.87 10.87 10.87 10.87 10.87
Depreciation 75.4 98.0 112.3 129.2 131.8 133.9 156.4 182.5 213.1 248.8
Depreciation, % 3.18 3.5 2.51 2.48 3.48 3.03 3.03 3.03 3.03 3.03
EBIT 200.2 222.9 398.4 553.0 123.4 346.5 404.5 472.2 551.2 643.5
EBIT, % 8.44 7.97 8.91 10.62 3.26 7.84 7.84 7.84 7.84 7.84
Total Cash 35.4 51.8 62.9 47.5 66.2 65.5 76.5 89.3 104.2 121.6
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 200.0 268.6 319.8 214.3 214.7
Account Receivables, % 8.43 9.61 7.15 4.11 5.67
Inventories 393.6 493.9 1,095.9 1,029.7 768.4 873.5 1,019.7 1,190.4 1,389.7 1,622.4
Inventories, % 16.6 17.66 24.5 19.77 20.3 19.77 19.77 19.77 19.77 19.77
Accounts Payable 99.3 184.9 282.2 143.5 183.7 218.4 255.0 297.7 347.5 405.7
Accounts Payable, % 4.19 6.61 6.31 2.76 4.85 4.94 4.94 4.94 4.94 4.94
Capital Expenditure -58.2 -57.3 -98.5 -130.6 -62.2 -96.0 -112.0 -130.8 -152.7 -178.3
Capital Expenditure, % -2.45 -2.05 -2.2 -2.51 -1.64 -2.17 -2.17 -2.17 -2.17 -2.17
Tax Rate, % 22.66 22.66 22.66 22.66 22.66 22.66 22.66 22.66 22.66 22.66
EBITAT 153.2 168.6 300.1 415.7 95.5 263.3 307.4 358.9 418.9 489.1
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -323.9 126.0 -242.1 447.3 466.0 136.6 190.3 222.1 259.3 302.7
WACC, % 8.86 8.85 8.84 8.84 8.87 8.85 8.85 8.85 8.85 8.85
PV UFCF
SUM PV UFCF 841.1
Long Term Growth Rate, % 1.00
Free cash flow (T + 1) 306
Terminal Value 3,893
Present Terminal Value 2,548
Enterprise Value 3,389
Net Debt 1,040
Equity Value 2,348
Diluted Shares Outstanding, MM 25
Equity Value Per Share 92.32

What You Will Get

  • Editable Forecast Inputs: Effortlessly modify key assumptions (growth %, margins, WACC) to generate various scenarios.
  • Real-World Data: LCI Industries’ financial data pre-loaded to facilitate your analysis.
  • Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically for you.
  • Customizable and Professional: A sleek Excel model tailored to meet your valuation requirements.
  • Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.

Key Features

  • Comprehensive Historical Data: LCI Industries’ (LCII) past financial statements and pre-populated forecasts.
  • Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
  • Real-Time Calculations: View LCI Industries’ (LCII) intrinsic value update instantly.
  • Intuitive Visualizations: Dashboard graphs showcase valuation results and essential metrics.
  • Designed for Precision: A reliable tool for analysts, investors, and finance professionals.

How It Works

  1. Step 1: Download the Excel file for LCI Industries (LCII).
  2. Step 2: Review LCI Industries’ pre-filled financial data and forecasts.
  3. Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
  4. Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
  5. Step 5: Analyze the outputs and leverage the results for your investment decisions.

Why Choose LCI Industries (LCII)?

  • Save Time: Skip the hassle of building a model from the ground up – it’s ready for immediate use.
  • Enhance Accuracy: Dependable financial data and formulas minimize valuation errors.
  • Completely Customizable: Adjust the model to mirror your own assumptions and forecasts.
  • User-Friendly: Intuitive charts and outputs simplify result analysis.
  • Endorsed by Professionals: Crafted for experts who prioritize accuracy and functionality.

Who Should Use This Product?

  • Investors: Evaluate LCI Industries’ (LCII) valuation before making investment decisions.
  • CFOs and Financial Analysts: Enhance valuation processes and assess financial forecasts.
  • Startup Founders: Understand the valuation methods of established companies like LCI Industries.
  • Consultants: Provide comprehensive valuation reports for your clients regarding LCI Industries.
  • Students and Educators: Utilize real-time data to learn and teach valuation methodologies.

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled LCI Industries 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 LCI Industries (LCII).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.

Es wurden keine passenden Produkte gefunden.