Lamar Advertising Company (LAMR) 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
Lamar Advertising Company (LAMR) Bundle
Looking to determine Lamar Advertising Company's intrinsic value? Our (LAMR) DCF Calculator integrates real-world data with extensive customization features, enabling you to adjust forecasts and enhance your investment strategies.
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 | 1,753.6 | 1,568.9 | 1,787.4 | 2,032.1 | 2,111.0 | 2,221.6 | 2,338.1 | 2,460.6 | 2,589.6 | 2,725.3 |
| Revenue Growth, % | 0 | -10.54 | 13.93 | 13.69 | 3.88 | 5.24 | 5.24 | 5.24 | 5.24 | 5.24 |
| EBITDA | 760.5 | 652.4 | 793.8 | 916.0 | 973.5 | 980.0 | 1,031.3 | 1,085.4 | 1,142.3 | 1,202.1 |
| EBITDA, % | 43.37 | 41.58 | 44.41 | 45.08 | 46.11 | 44.11 | 44.11 | 44.11 | 44.11 | 44.11 |
| Depreciation | 1,254.8 | 1,180.5 | 1,268.3 | 1,469.9 | 293.4 | 1,350.7 | 1,421.5 | 1,496.0 | 1,574.4 | 1,656.9 |
| Depreciation, % | 71.55 | 75.25 | 70.96 | 72.33 | 13.9 | 60.8 | 60.8 | 60.8 | 60.8 | 60.8 |
| EBIT | -494.2 | -528.1 | -474.6 | -553.8 | 680.1 | -370.7 | -390.2 | -410.6 | -432.1 | -454.8 |
| EBIT, % | -28.18 | -33.66 | -26.55 | -27.25 | 32.22 | -16.69 | -16.69 | -16.69 | -16.69 | -16.69 |
| Total Cash | 26.2 | 121.6 | 99.8 | 52.6 | 44.6 | 86.8 | 91.3 | 96.1 | 101.1 | 106.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 254.9 | 240.9 | 269.9 | 285.0 | 301.2 | 325.6 | 342.7 | 360.7 | 379.6 | 399.4 |
| Account Receivables, % | 14.54 | 15.35 | 15.1 | 14.03 | 14.27 | 14.66 | 14.66 | 14.66 | 14.66 | 14.66 |
| Inventories | .0 | .0 | .0 | -337.7 | .0 | -73.8 | -77.7 | -81.8 | -86.1 | -90.6 |
| Inventories, % | 0.000000057 | 0.0000000637 | 0 | -16.62 | 0 | -3.32 | -3.32 | -3.32 | -3.32 | -3.32 |
| Accounts Payable | 15.0 | 12.0 | 16.4 | 19.6 | 18.2 | 19.4 | 20.4 | 21.5 | 22.6 | 23.8 |
| Accounts Payable, % | 0.85388 | 0.76597 | 0.91916 | 0.96662 | 0.86396 | 0.87392 | 0.87392 | 0.87392 | 0.87392 | 0.87392 |
| Capital Expenditure | -141.0 | -62.3 | -126.1 | -167.1 | -178.3 | -158.7 | -167.1 | -175.8 | -185.0 | -194.7 |
| Capital Expenditure, % | -8.04 | -3.97 | -7.05 | -8.22 | -8.44 | -7.15 | -7.15 | -7.15 | -7.15 | -7.15 |
| Tax Rate, % | 2.14 | 2.14 | 2.14 | 2.14 | 2.14 | 2.14 | 2.14 | 2.14 | 2.14 | 2.14 |
| EBITAT | -499.9 | -518.2 | -463.5 | -532.6 | 665.5 | -363.2 | -382.2 | -402.2 | -423.3 | -445.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 373.9 | 611.1 | 654.1 | 1,095.9 | 425.4 | 879.3 | 860.0 | 905.1 | 952.5 | 1,002.5 |
| WACC, % | 9.75 | 9.73 | 9.73 | 9.71 | 9.73 | 9.73 | 9.73 | 9.73 | 9.73 | 9.73 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 3,487.9 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 1,038 | |||||||||
| Terminal Value | 16,654 | |||||||||
| Present Terminal Value | 10,469 | |||||||||
| Enterprise Value | 13,957 | |||||||||
| Net Debt | 4,598 | |||||||||
| Equity Value | 9,358 | |||||||||
| Diluted Shares Outstanding, MM | 102 | |||||||||
| Equity Value Per Share | 91.65 |
What You Will Get
- Real Lamar Data: Preloaded financials – covering metrics from revenue to EBIT – based on actual and projected figures.
- Full Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to evaluate the effects of changes on Lamar’s fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and comprehensive projections.
- Time-Saving and Accurate: Avoid building models from the ground up while ensuring precision and adaptability.
Key Features
- Customizable Revenue Inputs: Adjust key metrics such as advertising revenue growth, operating margins, and capital investments.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and various financial outputs.
- High-Precision Accuracy: Leverages Lamar Advertising's actual financial data for credible valuation results.
- Effortless Scenario Analysis: Evaluate different scenarios and easily compare the results.
- Efficiency Booster: Remove the hassle of creating intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Lamar Advertising Company (LAMR) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Lamar Advertising Company’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose Lamar Advertising Company (LAMR)?
- Industry Leader: Benefit from a company with extensive experience in outdoor advertising.
- Wide Reach: Access to a vast network of billboard locations across the country.
- Innovative Solutions: Utilize cutting-edge technology to enhance your advertising campaigns.
- Data-Driven Insights: Leverage analytics to optimize your advertising strategy and maximize impact.
- Client-Centric Approach: Enjoy personalized service and support tailored to your business needs.
Who Should Use This Product?
- Individual Investors: Gain insights to make informed decisions about buying or selling Lamar Advertising Company (LAMR) stock.
- Financial Analysts: Enhance valuation processes with comprehensive financial models tailored for Lamar Advertising Company (LAMR).
- Consultants: Provide clients with accurate and timely valuation insights related to Lamar Advertising Company (LAMR).
- Business Owners: Learn how advertising companies like Lamar Advertising Company (LAMR) are valued to inform your own business strategies.
- Finance Students: Explore valuation techniques using real-world data and case studies from Lamar Advertising Company (LAMR).
What the Template Contains
- Preloaded LAMR Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.