|
Macy's, Inc. (M) Valoración de DCF
US | Consumer Cyclical | Department Stores | NYSE
|
- ✓ 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
Macy's, Inc. (M) Bundle
¡Simplifique la valoración de Macy's, Inc. (M) con esta calculadora DCF personalizable! Con el Real Macy's, Inc. (M) Financials y las entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Macy's, Inc. (M) en minutos.
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 | 25,331.0 | 18,097.0 | 25,292.0 | 25,305.0 | 23,866.0 | 24,198.0 | 24,534.7 | 24,876.0 | 25,222.1 | 25,573.0 |
| Revenue Growth, % | 0 | -28.56 | 39.76 | 0.05139965 | -5.69 | 1.39 | 1.39 | 1.39 | 1.39 | 1.39 |
| EBITDA | 1,914.0 | -3,542.0 | 2,996.0 | 2,537.0 | 1,156.0 | 711.4 | 721.3 | 731.3 | 741.5 | 751.8 |
| EBITDA, % | 7.56 | -19.57 | 11.85 | 10.03 | 4.84 | 2.94 | 2.94 | 2.94 | 2.94 | 2.94 |
| Depreciation | 981.0 | 959.0 | 874.0 | 857.0 | 897.0 | 956.9 | 970.2 | 983.7 | 997.4 | 1,011.3 |
| Depreciation, % | 3.87 | 5.3 | 3.46 | 3.39 | 3.76 | 3.95 | 3.95 | 3.95 | 3.95 | 3.95 |
| EBIT | 933.0 | -4,501.0 | 2,122.0 | 1,680.0 | 259.0 | -245.6 | -249.0 | -252.4 | -256.0 | -259.5 |
| EBIT, % | 3.68 | -24.87 | 8.39 | 6.64 | 1.09 | -1.01 | -1.01 | -1.01 | -1.01 | -1.01 |
| Total Cash | 685.0 | 1,679.0 | 1,712.0 | 862.0 | 1,034.0 | 1,282.0 | 1,299.8 | 1,317.9 | 1,336.3 | 1,354.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 409.0 | 276.0 | 297.0 | 300.0 | 293.0 | 325.6 | 330.1 | 334.7 | 339.4 | 344.1 |
| Account Receivables, % | 1.61 | 1.53 | 1.17 | 1.19 | 1.23 | 1.35 | 1.35 | 1.35 | 1.35 | 1.35 |
| Inventories | 5,188.0 | 3,774.0 | 4,383.0 | 4,267.0 | 4,361.0 | 4,539.5 | 4,602.7 | 4,666.7 | 4,731.7 | 4,797.5 |
| Inventories, % | 20.48 | 20.85 | 17.33 | 16.86 | 18.27 | 18.76 | 18.76 | 18.76 | 18.76 | 18.76 |
| Accounts Payable | 2,659.0 | 2,856.0 | 3,280.0 | 2,874.0 | 2,523.0 | 2,960.7 | 3,001.9 | 3,043.6 | 3,086.0 | 3,128.9 |
| Accounts Payable, % | 10.5 | 15.78 | 12.97 | 11.36 | 10.57 | 12.24 | 12.24 | 12.24 | 12.24 | 12.24 |
| Capital Expenditure | -1,157.0 | -466.0 | -597.0 | -1,295.0 | -993.0 | -908.9 | -921.6 | -934.4 | -947.4 | -960.6 |
| Capital Expenditure, % | -4.57 | -2.58 | -2.36 | -5.12 | -4.16 | -3.76 | -3.76 | -3.76 | -3.76 | -3.76 |
| Tax Rate, % | 15.32 | 15.32 | 15.32 | 15.32 | 15.32 | 15.32 | 15.32 | 15.32 | 15.32 | 15.32 |
| EBITAT | 722.8 | -3,706.0 | 1,626.2 | 1,302.6 | 219.3 | -195.8 | -198.5 | -201.3 | -204.1 | -206.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -2,391.2 | -1,469.0 | 1,697.2 | 571.6 | -314.7 | 78.8 | -176.4 | -178.8 | -181.3 | -183.8 |
| WACC, % | 8.29 | 8.41 | 8.27 | 8.29 | 8.47 | 8.35 | 8.35 | 8.35 | 8.35 | 8.35 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -472.8 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | -185 | |||||||||
| Terminal Value | -2,354 | |||||||||
| Present Terminal Value | -1,576 | |||||||||
| Enterprise Value | -2,049 | |||||||||
| Net Debt | 5,308 | |||||||||
| Equity Value | -7,357 | |||||||||
| Diluted Shares Outstanding, MM | 278 | |||||||||
| Equity Value Per Share | -26.45 |
What You Will Get
- Real Macy's Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Macy's fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Macy's, Inc. (M).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to retail.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit Macy's business model.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios for Macy's, Inc. (M).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- 1. Access the Template: Download and open the Excel file featuring Macy's, Inc. (M) preloaded data.
- 2. Adjust Assumptions: Modify key variables such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically computes intrinsic value and NPV.
- 4. Analyze Scenarios: Evaluate various forecasts to assess different valuation results.
- 5. Present with Confidence: Deliver professional valuation insights to back your decisions.
Why Choose This Calculator for Macy's, Inc. (M)?
- All-in-One Solution: Features DCF, WACC, and key financial ratios for comprehensive analysis.
- Flexible Parameters: Modify the highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Macy's intrinsic value and Net Present Value.
- Rich Data Set: Comes with historical and projected data to provide reliable benchmarks.
- High Standards: Perfect for financial analysts, investors, and business advisors.
Who Should Use This Product?
- Investors: Accurately estimate Macy's, Inc. (M)'s fair value before making investment decisions.
- CFOs: Leverage a professional-grade DCF model for financial reporting and analysis related to Macy's, Inc. (M).
- Consultants: Quickly adapt the template for valuation reports for clients interested in Macy's, Inc. (M).
- Entrepreneurs: Gain insights into financial modeling used by leading retail companies like Macy's, Inc. (M).
- Educators: Use it as a teaching tool to demonstrate valuation methodologies applicable to Macy's, Inc. (M).
What the Template Contains
- Pre-Filled DCF Model: Macy's, Inc. (M) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Macy's, Inc. (M) 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.