The Macerich Company (MAC) 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
The Macerich Company (MAC) Bundle
Designed for accuracy, our (MAC) DCF Calculator empowers you to evaluate The Macerich Company's valuation using real-world financial data and offers complete flexibility to modify all key parameters for enhanced 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 | 927.5 | 786.0 | 847.4 | 859.2 | 881.4 | 873.7 | 866.1 | 858.6 | 851.2 | 843.8 |
| Revenue Growth, % | 0 | -15.25 | 7.81 | 1.38 | 2.58 | -0.86716 | -0.86716 | -0.86716 | -0.86716 | -0.86716 |
| EBITDA | 585.4 | 155.7 | 452.2 | 436.4 | 190.7 | 364.7 | 361.6 | 358.4 | 355.3 | 352.2 |
| EBITDA, % | 63.12 | 19.81 | 53.36 | 50.79 | 21.64 | 41.74 | 41.74 | 41.74 | 41.74 | 41.74 |
| Depreciation | 644.7 | 558.4 | 731.1 | 732.7 | 296.4 | 604.1 | 598.9 | 593.7 | 588.6 | 583.5 |
| Depreciation, % | 69.51 | 71.04 | 86.27 | 85.28 | 33.63 | 69.15 | 69.15 | 69.15 | 69.15 | 69.15 |
| EBIT | -59.3 | -402.7 | -278.9 | -296.3 | -105.7 | -239.4 | -237.4 | -235.3 | -233.3 | -231.2 |
| EBIT, % | -6.39 | -51.23 | -32.91 | -34.49 | -11.99 | -27.4 | -27.4 | -27.4 | -27.4 | -27.4 |
| Total Cash | 100.0 | 465.3 | 112.5 | 100.3 | 94.9 | 184.7 | 183.1 | 181.5 | 179.9 | 178.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 150.2 | 240.8 | 211.4 | 186.9 | 188.2 | 200.7 | 199.0 | 197.3 | 195.6 | 193.9 |
| Account Receivables, % | 16.19 | 30.64 | 24.94 | 21.75 | 21.36 | 22.98 | 22.98 | 22.98 | 22.98 | 22.98 |
| Inventories | 278.6 | 17.4 | 54.5 | .0 | .0 | 67.6 | 67.0 | 66.4 | 65.9 | 65.3 |
| Inventories, % | 30.04 | 2.21 | 6.43 | 0 | 0 | 7.74 | 7.74 | 7.74 | 7.74 | 7.74 |
| Accounts Payable | 51.0 | 68.8 | 59.2 | 63.1 | 64.2 | 62.7 | 62.1 | 61.6 | 61.1 | 60.5 |
| Accounts Payable, % | 5.5 | 8.76 | 6.99 | 7.35 | 7.28 | 7.18 | 7.18 | 7.18 | 7.18 | 7.18 |
| Capital Expenditure | -199.8 | -71.5 | -110.9 | -97.9 | .0 | -96.3 | -95.5 | -94.7 | -93.8 | -93.0 |
| Capital Expenditure, % | -21.54 | -9.1 | -13.09 | -11.4 | 0 | -11.03 | -11.03 | -11.03 | -11.03 | -11.03 |
| Tax Rate, % | -0.18057 | -0.18057 | -0.18057 | -0.18057 | -0.18057 | -0.18057 | -0.18057 | -0.18057 | -0.18057 | -0.18057 |
| EBITAT | -55.1 | -402.0 | -172.1 | -299.6 | -105.9 | -217.6 | -215.8 | -213.9 | -212.0 | -210.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 12.0 | 273.4 | 430.7 | 418.1 | 190.3 | 208.6 | 289.4 | 286.9 | 284.4 | 282.0 |
| WACC, % | 10.18 | 10.33 | 9.48 | 10.33 | 10.33 | 10.13 | 10.13 | 10.13 | 10.13 | 10.13 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,010.3 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 288 | |||||||||
| Terminal Value | 3,538 | |||||||||
| Present Terminal Value | 2,184 | |||||||||
| Enterprise Value | 3,194 | |||||||||
| Net Debt | 4,215 | |||||||||
| Equity Value | -1,021 | |||||||||
| Diluted Shares Outstanding, MM | 216 | |||||||||
| Equity Value Per Share | -4.73 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: The Macerich Company’s (MAC) financial information pre-loaded to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A sleek Excel model tailored to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for assessing projections, confirming strategies, and enhancing efficiency.
Key Features
- Real-Life MAC Data: Pre-filled with The Macerich Company's historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth, operating margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Instant updates to Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Testing: Develop various forecast scenarios to evaluate different valuation results.
- User-Friendly Design: Intuitive, organized, and crafted for both professionals and novices.
How It Works
- Download the Template: Gain immediate access to the Excel-based MAC DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model automatically recalculates The Macerich Company’s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.
Why Choose This Calculator for The Macerich Company (MAC)?
- Accuracy: Utilize real Macerich financials to ensure precise data.
- Flexibility: Tailored for users to easily test and adjust inputs as needed.
- Time-Saving: Eliminate the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling expertise.
Who Should Use This Product?
- Investors: Evaluate The Macerich Company's (MAC) market value before making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts.
- Real Estate Developers: Understand how large REITs like The Macerich Company (MAC) are appraised.
- Consultants: Provide detailed valuation analyses for real estate clients.
- Students and Educators: Utilize current market data to teach and learn valuation principles.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Macerich Company (MAC) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Macerich Company (MAC).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.