Altria Group, Inc. (MO) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Altria Group, Inc. (MO) Bundle
Explore Altria Group, Inc. (MO) financial future with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to determine Altria Group, Inc. (MO) intrinsic value and inform your investment decisions.
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 | 19,796.0 | 20,841.0 | 21,111.0 | 20,688.0 | 20,502.0 | 20,690.2 | 20,880.1 | 21,071.8 | 21,265.2 | 21,460.4 |
Revenue Growth, % | 0 | 5.28 | 1.3 | -2 | -0.89907 | 0.9179 | 0.9179 | 0.9179 | 0.9179 | 0.9179 |
EBITDA | 11,028.0 | 11,751.0 | 12,163.0 | 12,527.0 | 12,349.0 | 12,020.7 | 12,131.0 | 12,242.4 | 12,354.7 | 12,468.1 |
EBITDA, % | 55.71 | 56.38 | 57.61 | 60.55 | 60.23 | 58.1 | 58.1 | 58.1 | 58.1 | 58.1 |
Depreciation | 226.0 | 257.0 | 244.0 | 226.0 | 272.0 | 246.2 | 248.5 | 250.7 | 253.0 | 255.4 |
Depreciation, % | 1.14 | 1.23 | 1.16 | 1.09 | 1.33 | 1.19 | 1.19 | 1.19 | 1.19 | 1.19 |
EBIT | 10,802.0 | 11,494.0 | 11,919.0 | 12,301.0 | 12,077.0 | 11,774.5 | 11,882.5 | 11,991.6 | 12,101.7 | 12,212.8 |
EBIT, % | 54.57 | 55.15 | 56.46 | 59.46 | 58.91 | 56.91 | 56.91 | 56.91 | 56.91 | 56.91 |
Total Cash | 2,117.0 | 4,945.0 | 4,544.0 | 4,030.0 | 3,686.0 | 3,865.1 | 3,900.6 | 3,936.4 | 3,972.5 | 4,009.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 268.0 | 137.0 | 47.0 | 1,721.0 | .0 | 436.7 | 440.7 | 444.7 | 448.8 | 452.9 |
Account Receivables, % | 1.35 | 0.65736 | 0.22263 | 8.32 | 0 | 2.11 | 2.11 | 2.11 | 2.11 | 2.11 |
Inventories | 2,293.0 | 1,966.0 | 1,194.0 | 1,180.0 | 1,215.0 | 1,585.0 | 1,599.5 | 1,614.2 | 1,629.0 | 1,644.0 |
Inventories, % | 11.58 | 9.43 | 5.66 | 5.7 | 5.93 | 7.66 | 7.66 | 7.66 | 7.66 | 7.66 |
Accounts Payable | 325.0 | 380.0 | 449.0 | 552.0 | 582.0 | 459.3 | 463.5 | 467.7 | 472.0 | 476.4 |
Accounts Payable, % | 1.64 | 1.82 | 2.13 | 2.67 | 2.84 | 2.22 | 2.22 | 2.22 | 2.22 | 2.22 |
Capital Expenditure | -246.0 | -231.0 | -169.0 | -205.0 | -196.0 | -211.0 | -212.9 | -214.9 | -216.8 | -218.8 |
Capital Expenditure, % | -1.24 | -1.11 | -0.80053 | -0.99091 | -0.956 | -1.02 | -1.02 | -1.02 | -1.02 | -1.02 |
Tax Rate, % | 25.6 | 25.6 | 25.6 | 25.6 | 25.6 | 25.6 | 25.6 | 25.6 | 25.6 | 25.6 |
EBITAT | -18,304.2 | 7,451.9 | 7,714.3 | 9,595.7 | 8,984.8 | 6,639.9 | 6,700.8 | 6,762.3 | 6,824.4 | 6,887.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -20,560.2 | 7,990.9 | 8,720.3 | 8,059.7 | 10,776.8 | 5,745.7 | 6,722.0 | 6,783.7 | 6,846.0 | 6,908.8 |
WACC, % | 5.94 | 6.57 | 6.57 | 6.7 | 6.67 | 6.49 | 6.49 | 6.49 | 6.49 | 6.49 |
PV UFCF | ||||||||||
SUM PV UFCF | 27,308.8 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 6,943 | |||||||||
Terminal Value | 115,908 | |||||||||
Present Terminal Value | 84,637 | |||||||||
Enterprise Value | 111,946 | |||||||||
Net Debt | 22,547 | |||||||||
Equity Value | 89,399 | |||||||||
Diluted Shares Outstanding, MM | 1,777 | |||||||||
Equity Value Per Share | 50.31 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator with pre-filled real MO financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the highlighted cells).
- Forecast Flexibility: Modify forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on Altria’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- 🔍 Real-Life MO Financials: Pre-filled historical and projected data for Altria Group, Inc. (MO).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Altria's intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Altria's valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the prebuilt Excel template with Altria Group, Inc.'s (MO) data included.
- Step 2: Explore the pre-filled sheets and understand the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including Altria Group, Inc.'s (MO) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose This Calculator for Altria Group, Inc. (MO)?
- Accuracy: Utilizes real Altria financials to ensure precise data.
- Flexibility: Built for users to easily test and adjust inputs as needed.
- Time-Saving: Avoid the complexity of constructing a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected by CFOs.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling backgrounds.
Who Should Use This Product?
- Investors: Evaluate Altria Group's valuation prior to making stock transactions.
- CFOs and Financial Analysts: Enhance valuation methodologies and validate forecasts.
- Startup Founders: Understand the valuation strategies of established companies like Altria.
- Consultants: Provide detailed valuation assessments for clients in various sectors.
- Students and Educators: Utilize real-time data to practice and instruct on valuation methods.
What the Template Contains
- Pre-Filled DCF Model: Altria Group’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Altria’s 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.