LSI Industries Inc. (LYTS) DCF Valuation

LSI Industries Inc. (LYTS) 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

LSI Industries Inc. (LYTS) 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:

Designed for accuracy, our (LYTS) DCF Calculator empowers you to evaluate LSI Industries Inc. valuation using real-world financial data, while offering complete flexibility to modify all essential parameters for improved projections.


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 305.6 315.6 455.1 497.0 469.6 529.7 597.5 674.0 760.2 857.5
Revenue Growth, % 0 3.29 44.2 9.2 -5.5 12.8 12.8 12.8 12.8 12.8
EBITDA 21.3 16.4 31.2 46.7 45.3 40.3 45.4 51.2 57.8 65.2
EBITDA, % 6.96 5.18 6.85 9.39 9.64 7.6 7.6 7.6 7.6 7.6
Depreciation 8.7 8.1 10.1 9.7 10.0 12.4 14.0 15.8 17.8 20.1
Depreciation, % 2.84 2.58 2.22 1.94 2.13 2.34 2.34 2.34 2.34 2.34
EBIT 12.6 8.2 21.1 37.0 35.3 27.9 31.4 35.4 40.0 45.1
EBIT, % 4.11 2.6 4.63 7.45 7.51 5.26 5.26 5.26 5.26 5.26
Total Cash 3.5 2.3 2.5 1.8 4.1 3.9 4.4 4.9 5.6 6.3
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 40.6 59.0 78.8 80.8 81.8
Account Receivables, % 13.29 18.68 17.31 16.26 17.42
Inventories 38.8 58.9 74.4 63.7 70.9 80.1 90.4 101.9 115.0 129.7
Inventories, % 12.68 18.68 16.35 12.82 15.1 15.13 15.13 15.13 15.13 15.13
Accounts Payable 14.2 33.0 34.8 29.2 32.2 37.6 42.4 47.8 53.9 60.8
Accounts Payable, % 4.65 10.45 7.64 5.88 6.85 7.1 7.1 7.1 7.1 7.1
Capital Expenditure -2.7 -2.2 -2.1 -3.2 -5.4 -4.1 -4.6 -5.2 -5.9 -6.6
Capital Expenditure, % -0.89639 -0.70751 -0.46625 -0.6455 -1.15 -0.77258 -0.77258 -0.77258 -0.77258 -0.77258
Tax Rate, % 24.54 24.54 24.54 24.54 24.54 24.54 24.54 24.54 24.54 24.54
EBITAT 10.3 6.1 16.6 28.6 26.6 21.6 24.4 27.5 31.0 35.0
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -48.9 -7.8 -8.9 38.2 26.0 20.0 17.1 19.2 21.7 24.5
WACC, % 8 7.96 7.99 7.98 7.97 7.98 7.98 7.98 7.98 7.98
PV UFCF
SUM PV UFCF 81.1
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 25
Terminal Value 418
Present Terminal Value 285
Enterprise Value 366
Net Debt 68
Equity Value 298
Diluted Shares Outstanding, MM 30
Equity Value Per Share 9.90

What You Will Get

  • Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to generate various scenarios.
  • Real-World Data: LSI Industries Inc.'s (LYTS) financial data pre-loaded to accelerate your analysis.
  • Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
  • Customizable and Professional: A sleek Excel model that adjusts to your valuation requirements.
  • Built for Analysts and Investors: Perfect for assessing projections, validating strategies, and enhancing efficiency.

Key Features

  • Comprehensive DCF Calculator: Features both unlevered and levered DCF valuation models tailored for LSI Industries Inc. (LYTS).
  • WACC Calculator: User-friendly Weighted Average Cost of Capital sheet with adjustable parameters.
  • Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates as needed.
  • Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to LSI Industries Inc. (LYTS).
  • Interactive Dashboard and Charts: Visual representations highlight essential valuation metrics for straightforward analysis.

How It Works

  • 1. Access the Template: Download and open the Excel file featuring LSI Industries Inc.'s (LYTS) preloaded data.
  • 2. Adjust Assumptions: Modify essential inputs such as growth projections, WACC, and capital expenditures.
  • 3. Analyze Results Instantly: The DCF model automatically computes intrinsic value and NPV.
  • 4. Explore Scenarios: Evaluate various forecasts to assess different valuation results.
  • 5. Present with Assurance: Deliver expert valuation insights to enhance your decision-making.

Why Choose This Calculator for LSI Industries Inc. (LYTS)?

  • Accurate Data: Access to real LSI Industries financials ensures dependable valuation outcomes.
  • Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
  • Time-Saving: Built-in calculations save you from starting from the ground up.
  • Professional-Grade Tool: Crafted for investors, analysts, and consultants in the industry.
  • User-Friendly: Easy-to-navigate design and step-by-step guidance simplify the experience for all users.

Who Should Use This Product?

  • Investors: Evaluate LSI Industries Inc.'s (LYTS) performance before making investment decisions.
  • CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts for LSI Industries Inc. (LYTS).
  • Startup Founders: Gain insights into how established companies like LSI Industries Inc. (LYTS) are valued in the market.
  • Consultants: Provide detailed valuation assessments and reports for clients interested in LSI Industries Inc. (LYTS).
  • Students and Educators: Utilize real-time data from LSI Industries Inc. (LYTS) to learn and teach valuation practices.

What the Template Contains

  • Historical Data: Includes LSI Industries Inc.’s past financials and baseline forecasts.
  • DCF and Levered DCF Models: Detailed templates to calculate LSI Industries Inc.’s intrinsic value.
  • WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
  • Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
  • Quarterly and Annual Statements: A complete breakdown of LSI Industries Inc.’s financials.
  • Interactive Dashboard: Visualize valuation results and projections dynamically.

No products were found matching.