Lumen Technologies, Inc. (LUMN) 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
Lumen Technologies, Inc. (LUMN) Bundle
Gain insight into your Lumen Technologies, Inc. (LUMN) valuation analysis with our sophisticated DCF Calculator! Featuring real-time data for (LUMN), this Excel template enables you to adjust forecasts and assumptions, allowing for precise calculations of Lumen Technologies' intrinsic value.
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 | 22,401.0 | 20,712.0 | 19,687.0 | 17,478.0 | 14,557.0 | 13,086.0 | 11,763.6 | 10,574.8 | 9,506.2 | 8,545.5 |
| Revenue Growth, % | 0 | -7.54 | -4.95 | -11.22 | -16.71 | -10.11 | -10.11 | -10.11 | -10.11 | -10.11 |
| EBITDA | 3,290.0 | 5,898.0 | 8,517.0 | 3,580.0 | -6,094.0 | 1,702.4 | 1,530.3 | 1,375.7 | 1,236.7 | 1,111.7 |
| EBITDA, % | 14.69 | 28.48 | 43.26 | 20.48 | -41.86 | 13.01 | 13.01 | 13.01 | 13.01 | 13.01 |
| Depreciation | 5,157.0 | 5,074.0 | 4,377.0 | 3,239.0 | 2,985.0 | 2,847.2 | 2,559.5 | 2,300.9 | 2,068.3 | 1,859.3 |
| Depreciation, % | 23.02 | 24.5 | 22.23 | 18.53 | 20.51 | 21.76 | 21.76 | 21.76 | 21.76 | 21.76 |
| EBIT | -1,867.0 | 824.0 | 4,140.0 | 341.0 | -9,079.0 | -1,144.9 | -1,029.2 | -925.2 | -831.7 | -747.6 |
| EBIT, % | -8.33 | 3.98 | 21.03 | 1.95 | -62.37 | -8.75 | -8.75 | -8.75 | -8.75 | -8.75 |
| Total Cash | 1,690.0 | 406.0 | 354.0 | 1,251.0 | 2,234.0 | 884.8 | 795.4 | 715.0 | 642.7 | 577.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 2,336.0 | 2,035.0 | 1,723.0 | 1,528.0 | 1,610.0 | 1,277.4 | 1,148.3 | 1,032.3 | 927.9 | 834.2 |
| Account Receivables, % | 10.43 | 9.83 | 8.75 | 8.74 | 11.06 | 9.76 | 9.76 | 9.76 | 9.76 | 9.76 |
| Inventories | 105.0 | 105.0 | 96.0 | 236.0 | 209.0 | 111.2 | 100.0 | 89.9 | 80.8 | 72.6 |
| Inventories, % | 0.46873 | 0.50695 | 0.48763 | 1.35 | 1.44 | 0.84986 | 0.84986 | 0.84986 | 0.84986 | 0.84986 |
| Accounts Payable | 1,255.0 | 805.0 | 758.0 | 1,044.0 | 1,134.0 | 709.3 | 637.6 | 573.2 | 515.3 | 463.2 |
| Accounts Payable, % | 5.6 | 3.89 | 3.85 | 5.97 | 7.79 | 5.42 | 5.42 | 5.42 | 5.42 | 5.42 |
| Capital Expenditure | -3,628.0 | -3,729.0 | -2,900.0 | -3,016.0 | -3,100.0 | -2,289.6 | -2,058.2 | -1,850.2 | -1,663.2 | -1,495.2 |
| Capital Expenditure, % | -16.2 | -18 | -14.73 | -17.26 | -21.3 | -17.5 | -17.5 | -17.5 | -17.5 | -17.5 |
| Tax Rate, % | -0.59588 | -0.59588 | -0.59588 | -0.59588 | -0.59588 | -0.59588 | -0.59588 | -0.59588 | -0.59588 | -0.59588 |
| EBITAT | -2,064.0 | 1,298.2 | 3,116.1 | 532.7 | -9,133.1 | -1,088.2 | -978.3 | -879.4 | -790.5 | -710.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1,721.0 | 2,494.2 | 4,867.1 | 1,096.7 | -9,213.1 | -524.9 | -408.3 | -367.1 | -330.0 | -296.6 |
| WACC, % | 6.64 | 6.64 | 5.53 | 6.64 | 6.64 | 6.42 | 6.42 | 6.42 | 6.42 | 6.42 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -1,632.9 | |||||||||
| Long Term Growth Rate, % | 3.40 | |||||||||
| Free cash flow (T + 1) | -307 | |||||||||
| Terminal Value | -10,157 | |||||||||
| Present Terminal Value | -7,441 | |||||||||
| Enterprise Value | -9,074 | |||||||||
| Net Debt | 18,022 | |||||||||
| Equity Value | -27,096 | |||||||||
| Diluted Shares Outstanding, MM | 983 | |||||||||
| Equity Value Per Share | -27.56 |
What You Will Get
- Real LUMN Financial Data: Pre-filled with Lumen Technologies’ historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Lumen Technologies’ 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 LUMN Data: Pre-filled with Lumen Technologies' historical performance metrics and future projections.
- Flexible Input Options: Modify revenue growth rates, profit margins, WACC, tax rates, and capital expenditures as needed.
- Interactive Valuation Model: Automatically recalculates Net Present Value (NPV) and intrinsic value based on user inputs.
- Scenario Analysis: Develop various forecast scenarios to evaluate different valuation possibilities.
- Intuitive User Interface: Designed for ease of use, catering to both professionals and newcomers.
How It Works
- Download the Template: Gain immediate access to the Excel-based LUMN DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other parameters.
- Instant Calculations: The model will automatically refresh Lumen Technologies' intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation shifts.
- Analyze and Decide: Leverage the results to inform your investment or financial strategy.
Why Choose This Calculator for Lumen Technologies, Inc. (LUMN)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for Lumen Technologies.
- Flexible Inputs: Modify the yellow-highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Lumen’s intrinsic value and Net Present Value.
- Preloaded Information: Historical and projected data provide reliable baselines.
- Expert-Level Tool: Perfect for financial analysts, investors, and business advisors focusing on Lumen Technologies.
Who Should Use This Product?
- Investors: Evaluate Lumen Technologies’ valuation before making stock transactions.
- CFOs and Financial Analysts: Enhance valuation workflows and assess forecasts.
- Startup Founders: Discover how leading public companies like Lumen Technologies are appraised.
- Consultants: Provide expert valuation reports for your clientele.
- Students and Educators: Utilize real-time data to learn and teach valuation methodologies.
What the Template Contains
- Pre-Filled DCF Model: Lumen Technologies’ financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Lumen Technologies’ profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.