|
3M Company (MMM) DCF Valuation
US | Industrials | Conglomerates | NYSE
|
- ✓ 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
3M Company (MMM) Bundle
Designed for accuracy, our 3M DCF Calculator (MMM) enables you to evaluate 3M Company's valuation using real-world financial data, offering complete flexibility to modify all key parameters for improved projections.
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 | 32,136.0 | 32,184.0 | 35,355.0 | 34,229.0 | 32,681.0 | 32,868.5 | 33,057.1 | 33,246.7 | 33,437.4 | 33,629.3 |
| Revenue Growth, % | 0 | 0.14937 | 9.85 | -3.18 | -4.52 | 0.57369 | 0.57369 | 0.57369 | 0.57369 | 0.57369 |
| EBITDA | 7,736.0 | 9,259.0 | 9,576.0 | 8,721.0 | -6,747.0 | 5,571.9 | 5,603.9 | 5,636.0 | 5,668.3 | 5,700.9 |
| EBITDA, % | 24.07 | 28.77 | 27.09 | 25.48 | -20.65 | 16.95 | 16.95 | 16.95 | 16.95 | 16.95 |
| Depreciation | 1,593.0 | 1,911.0 | 1,915.0 | 1,831.0 | 1,987.0 | 1,823.6 | 1,834.0 | 1,844.6 | 1,855.1 | 1,865.8 |
| Depreciation, % | 4.96 | 5.94 | 5.42 | 5.35 | 6.08 | 5.55 | 5.55 | 5.55 | 5.55 | 5.55 |
| EBIT | 6,143.0 | 7,348.0 | 7,661.0 | 6,890.0 | -8,734.0 | 3,748.3 | 3,769.8 | 3,791.4 | 3,813.2 | 3,835.1 |
| EBIT, % | 19.12 | 22.83 | 21.67 | 20.13 | -26.73 | 11.4 | 11.4 | 11.4 | 11.4 | 11.4 |
| Total Cash | 2,451.0 | 5,038.0 | 4,765.0 | 3,893.0 | 5,986.0 | 4,368.1 | 4,393.2 | 4,418.4 | 4,443.7 | 4,469.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 4,791.0 | 4,705.0 | 4,660.0 | 4,532.0 | 4,750.0 | 4,633.3 | 4,659.9 | 4,686.6 | 4,713.5 | 4,740.6 |
| Account Receivables, % | 14.91 | 14.62 | 13.18 | 13.24 | 14.53 | 14.1 | 14.1 | 14.1 | 14.1 | 14.1 |
| Inventories | 4,134.0 | 4,239.0 | 4,985.0 | 5,372.0 | 4,822.0 | 4,640.0 | 4,666.6 | 4,693.4 | 4,720.3 | 4,747.4 |
| Inventories, % | 12.86 | 13.17 | 14.1 | 15.69 | 14.75 | 14.12 | 14.12 | 14.12 | 14.12 | 14.12 |
| Accounts Payable | 2,228.0 | 2,561.0 | 2,994.0 | 3,183.0 | 3,245.0 | 2,799.6 | 2,815.6 | 2,831.8 | 2,848.0 | 2,864.4 |
| Accounts Payable, % | 6.93 | 7.96 | 8.47 | 9.3 | 9.93 | 8.52 | 8.52 | 8.52 | 8.52 | 8.52 |
| Capital Expenditure | -1,699.0 | -1,501.0 | -1,603.0 | -1,749.0 | -1,615.0 | -1,612.9 | -1,622.2 | -1,631.5 | -1,640.9 | -1,650.3 |
| Capital Expenditure, % | -5.29 | -4.66 | -4.53 | -5.11 | -4.94 | -4.91 | -4.91 | -4.91 | -4.91 | -4.91 |
| Tax Rate, % | 27.8 | 27.8 | 27.8 | 27.8 | 27.8 | 27.8 | 27.8 | 27.8 | 27.8 | 27.8 |
| EBITAT | 4,914.8 | 5,966.2 | 6,296.6 | 6,227.1 | -6,306.2 | 3,043.4 | 3,060.9 | 3,078.4 | 3,096.1 | 3,113.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1,888.2 | 6,690.2 | 6,340.6 | 6,239.1 | -5,540.2 | 3,107.3 | 3,235.6 | 3,254.2 | 3,272.8 | 3,291.6 |
| WACC, % | 8.28 | 8.3 | 8.31 | 8.39 | 8.2 | 8.3 | 8.3 | 8.3 | 8.3 | 8.3 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 12,779.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 3,357 | |||||||||
| Terminal Value | 53,324 | |||||||||
| Present Terminal Value | 35,798 | |||||||||
| Enterprise Value | 48,577 | |||||||||
| Net Debt | 10,921 | |||||||||
| Equity Value | 37,656 | |||||||||
| Diluted Shares Outstanding, MM | 554 | |||||||||
| Equity Value Per Share | 67.98 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real 3M Company (MMM) financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Quickly observe the effects of your inputs on 3M Company’s (MMM) 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
- Comprehensive 3M Financials: Gain access to precise historical data and forward-looking projections for 3M Company (MMM).
- Adjustable Forecast Parameters: Modify highlighted cells for WACC, growth rates, and profit margins to fit your analysis.
- Real-Time Calculations: Instant updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries for clear visualization of your valuation outcomes.
- Suitable for All Levels: An intuitive design tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file for 3M Company (MMM).
- Step 2: Review 3M's pre-filled financial data and projections.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify assumptions.
- Step 5: Evaluate the outputs and leverage the results for investment strategies.
Why Choose 3M Company (MMM) Products?
- Innovative Solutions: Benefit from cutting-edge technology and research-driven products.
- Proven Quality: Trusted by industries worldwide for reliability and performance.
- Diverse Applications: A wide range of products tailored for various sectors and needs.
- Commitment to Sustainability: Dedicated to environmentally responsible practices and products.
- Expert Support: Access to knowledgeable professionals ready to assist you with your needs.
Who Should Use This Product?
- Individual Investors: Gain insights to make informed decisions regarding buying or selling 3M Company (MMM) stock.
- Financial Analysts: Enhance valuation methodologies with comprehensive financial models tailored for 3M Company (MMM).
- Consultants: Provide clients with precise valuation analysis and recommendations related to 3M Company (MMM).
- Business Owners: Learn from the valuation strategies of established firms like 3M Company (MMM) to inform your own business approach.
- Finance Students: Explore practical valuation techniques using data and case studies from 3M Company (MMM).
What the Template Contains
- Historical Data: Includes 3M Company’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate 3M Company’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 3M Company’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.