Lee Enterprises, Incorporated (LEE) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Lee Enterprises, Incorporated (LEE) Bundle
Discover the true potential of Lee Enterprises, Incorporated (LEE) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and evaluate how changes affect Lee Enterprises' valuation – all within a single Excel template.
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 | 618.0 | 794.6 | 781.0 | 691.1 | 611.4 | 602.5 | 593.7 | 585.0 | 576.5 | 568.1 |
| Revenue Growth, % | 0 | 28.58 | -1.72 | -11.5 | -11.54 | -1.46 | -1.46 | -1.46 | -1.46 | -1.46 |
| EBITDA | 95.2 | 97.8 | 105.6 | 69.0 | 37.7 | 69.1 | 68.1 | 67.1 | 66.1 | 65.2 |
| EBITDA, % | 15.4 | 12.3 | 13.52 | 9.98 | 6.16 | 11.47 | 11.47 | 11.47 | 11.47 | 11.47 |
| Depreciation | 36.1 | 42.8 | 36.5 | 30.6 | 27.6 | 30.0 | 29.5 | 29.1 | 28.7 | 28.3 |
| Depreciation, % | 5.85 | 5.39 | 4.68 | 4.43 | 4.52 | 4.97 | 4.97 | 4.97 | 4.97 | 4.97 |
| EBIT | 59.0 | 54.9 | 69.0 | 38.4 | 10.0 | 39.2 | 38.6 | 38.0 | 37.5 | 36.9 |
| EBIT, % | 9.55 | 6.91 | 8.84 | 5.55 | 1.64 | 6.5 | 6.5 | 6.5 | 6.5 | 6.5 |
| Total Cash | 33.7 | 26.1 | 16.2 | 14.5 | 9.6 | 17.5 | 17.2 | 17.0 | 16.7 | 16.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 52.6 | 65.1 | 69.5 | 69.1 | 60.6 | 54.8 | 54.0 | 53.3 | 52.5 | 51.7 |
| Account Receivables, % | 8.51 | 8.19 | 8.9 | 10 | 9.92 | 9.1 | 9.1 | 9.1 | 9.1 | 9.1 |
| Inventories | 7.5 | 6.3 | 8.3 | 7.5 | 5.6 | 6.1 | 6.0 | 5.9 | 5.9 | 5.8 |
| Inventories, % | 1.22 | 0.79243 | 1.06 | 1.09 | 0.92299 | 1.02 | 1.02 | 1.02 | 1.02 | 1.02 |
| Accounts Payable | 17.2 | 20.4 | 28.6 | 36.3 | 36.3 | 24.3 | 24.0 | 23.6 | 23.3 | 22.9 |
| Accounts Payable, % | 2.78 | 2.57 | 3.66 | 5.25 | 5.94 | 4.04 | 4.04 | 4.04 | 4.04 | 4.04 |
| Capital Expenditure | -8.1 | -7.5 | -7.5 | -5.1 | -9.2 | -6.6 | -6.5 | -6.4 | -6.3 | -6.2 |
| Capital Expenditure, % | -1.31 | -0.94117 | -0.96496 | -0.73893 | -1.51 | -1.09 | -1.09 | -1.09 | -1.09 | -1.09 |
| Tax Rate, % | 24.4 | 24.4 | 24.4 | 24.4 | 24.4 | 24.4 | 24.4 | 24.4 | 24.4 | 24.4 |
| EBITAT | -26.2 | 39.0 | 78.0 | 65.6 | 7.6 | 27.1 | 26.7 | 26.4 | 26.0 | 25.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -41.1 | 66.4 | 108.8 | 100.0 | 36.3 | 43.9 | 50.3 | 49.6 | 48.9 | 48.1 |
| WACC, % | 6.6 | 30.23 | 39.9 | 39.9 | 31.77 | 29.68 | 29.68 | 29.68 | 29.68 | 29.68 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 116.9 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 50 | |||||||||
| Terminal Value | 195 | |||||||||
| Present Terminal Value | 53 | |||||||||
| Enterprise Value | 170 | |||||||||
| Net Debt | 38 | |||||||||
| Equity Value | 132 | |||||||||
| Diluted Shares Outstanding, MM | 6 | |||||||||
| Equity Value Per Share | 22.54 |
What You Will Receive
- Customizable Excel Template: A fully editable Excel-based DCF Calculator featuring pre-filled real LEE financials.
- Actual Data: Historical performance data and forward-looking projections (highlighted in the yellow cells).
- Assumption Flexibility: Modify forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect Lee Enterprises’ valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for clarity and user-friendliness, complete with step-by-step guidance.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Lee Enterprises, Incorporated (LEE).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with customizable parameters for accurate analysis.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit your projections.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Lee Enterprises, Incorporated (LEE).
- Interactive Dashboard and Charts: Visual representations that summarize key valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the prebuilt Excel template featuring Lee Enterprises, Incorporated (LEE) data.
- Step 2: Review the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Immediately see recalculated results, including Lee Enterprises, Incorporated (LEE)'s intrinsic value.
- Step 5: Use the outputs to make informed investment decisions or create detailed reports.
Why Choose This Calculator for Lee Enterprises, Incorporated (LEE)?
- User-Friendly Interface: Perfect for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Valuation: Observe immediate updates to Lee Enterprises’ valuation as you change inputs.
- Preloaded Data: Comes with Lee Enterprises’ actual financial information for swift evaluations.
- Preferred by Experts: Utilized by investors and analysts for making well-informed choices.
Who Should Use Lee Enterprises, Incorporated (LEE)?
- Investors: Gain insights into the media industry with a reliable analysis tool tailored for Lee Enterprises.
- Financial Analysts: Streamline your workflow with a comprehensive financial model designed for the unique aspects of LEE.
- Consultants: Effortlessly modify the template for impactful client presentations or detailed reports on Lee Enterprises.
- Media Enthusiasts: Enhance your knowledge of the publishing sector through practical examples related to LEE.
- Educators and Students: Utilize it as a hands-on resource for finance and media studies courses.
What the Template Contains
- Historical Data: Includes Lee Enterprises’ past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Lee Enterprises’ 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 Lee Enterprises’ financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.