Walker & Dunlop, Inc. (WD) 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
Walker & Dunlop, Inc. (WD) Bundle
Explore the financial future of Walker & Dunlop, Inc. (WD) with our user-friendly DCF Calculator! Enter your assumptions regarding growth, margins, and costs to determine the intrinsic value of Walker & Dunlop, Inc. (WD) and shape your investment strategy.
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 | 817.2 | 1,083.7 | 1,259.2 | 1,258.8 | 1,054.4 | 1,140.2 | 1,233.0 | 1,333.2 | 1,441.7 | 1,558.9 |
| Revenue Growth, % | 0 | 32.61 | 16.19 | -0.03375218 | -16.23 | 8.13 | 8.13 | 8.13 | 8.13 | 8.13 |
| EBITDA | 382.8 | 499.3 | 562.3 | 500.0 | 363.5 | 482.9 | 522.2 | 564.7 | 610.6 | 660.3 |
| EBITDA, % | 46.84 | 46.07 | 44.66 | 39.72 | 34.47 | 42.35 | 42.35 | 42.35 | 42.35 | 42.35 |
| Depreciation | 629.5 | 745.1 | 902.7 | 995.0 | 226.8 | 725.2 | 784.2 | 848.0 | 917.0 | 991.6 |
| Depreciation, % | 77.02 | 68.76 | 71.69 | 79.05 | 21.5 | 63.6 | 63.6 | 63.6 | 63.6 | 63.6 |
| EBIT | -246.6 | -245.8 | -340.4 | -495.0 | 136.8 | -242.3 | -262.0 | -283.3 | -306.4 | -331.3 |
| EBIT, % | -30.18 | -22.69 | -27.03 | -39.32 | 12.97 | -21.25 | -21.25 | -21.25 | -21.25 | -21.25 |
| Total Cash | 120.7 | 321.1 | 305.6 | 225.9 | 328.7 | 268.6 | 290.5 | 314.1 | 339.6 | 367.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 52.1 | 65.7 | 212.0 | 202.3 | 233.6 | 153.9 | 166.5 | 180.0 | 194.6 | 210.5 |
| Account Receivables, % | 6.38 | 6.07 | 16.84 | 16.07 | 22.15 | 13.5 | 13.5 | 13.5 | 13.5 | 13.5 |
| Inventories | 433.7 | 700.2 | 901.3 | 200.2 | .0 | 467.9 | 505.9 | 547.1 | 591.6 | 639.7 |
| Inventories, % | 53.07 | 64.61 | 71.58 | 15.91 | 0 | 41.03 | 41.03 | 41.03 | 41.03 | 41.03 |
| Accounts Payable | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Accounts Payable, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Capital Expenditure | -4.7 | -3.0 | -9.2 | -22.0 | -16.2 | -11.1 | -12.0 | -13.0 | -14.0 | -15.2 |
| Capital Expenditure, % | -0.57647 | -0.27526 | -0.73127 | -1.75 | -1.54 | -0.97336 | -0.97336 | -0.97336 | -0.97336 | -0.97336 |
| Tax Rate, % | 22.32 | 22.32 | 22.32 | 22.32 | 22.32 | 22.32 | 22.32 | 22.32 | 22.32 | 22.32 |
| EBITAT | -185.6 | -183.3 | -256.9 | -399.4 | 106.2 | -185.9 | -201.0 | -217.4 | -235.1 | -254.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -46.7 | 278.9 | 289.2 | 1,284.3 | 485.7 | 140.0 | 520.6 | 562.9 | 608.7 | 658.2 |
| WACC, % | 9.12 | 9.11 | 9.12 | 9.2 | 9.15 | 9.14 | 9.14 | 9.14 | 9.14 | 9.14 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,852.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 671 | |||||||||
| Terminal Value | 9,404 | |||||||||
| Present Terminal Value | 6,073 | |||||||||
| Enterprise Value | 7,925 | |||||||||
| Net Debt | 1,142 | |||||||||
| Equity Value | 6,783 | |||||||||
| Diluted Shares Outstanding, MM | 33 | |||||||||
| Equity Value Per Share | 206.32 |
What You Will Get
- Real WD Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Automatic computation of intrinsic value and NPV.
- Scenario Testing: Evaluate various scenarios to assess Walker & Dunlop’s future performance.
- User-Friendly Interface: Designed for industry professionals while remaining accessible to newcomers.
Key Features
- Comprehensive DCF Model: Features both unlevered and levered DCF valuation frameworks tailored for Walker & Dunlop, Inc. (WD).
- WACC Analysis Tool: Pre-configured Weighted Average Cost of Capital worksheet with adjustable parameters.
- Customizable Forecast Inputs: Alter growth projections, capital investments, and discount rates as needed.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Walker & Dunlop, Inc. (WD).
- Interactive Dashboard and Visualizations: Graphical representations that highlight essential valuation metrics for straightforward assessment.
How It Works
- Download the Template: Gain immediate access to the Excel-based WD DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Walker & Dunlop’s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial strategy.
Why Choose This Calculator for Walker & Dunlop, Inc. (WD)?
- Accurate Data: Utilize real Walker & Dunlop financials for dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from zero.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the real estate finance sector.
- User-Friendly: An intuitive design and straightforward instructions ensure ease of use for everyone.
Who Should Use Walker & Dunlop, Inc. (WD)?
- Real Estate Investors: Leverage expert insights to make informed investment decisions in commercial real estate.
- Financial Analysts: Streamline your analysis with comprehensive market data and tools tailored for real estate.
- Consultants: Efficiently customize reports and presentations to meet client needs in the real estate sector.
- Real Estate Enthusiasts: Enhance your knowledge of market trends and financing strategies with practical case studies.
- Educators and Students: Utilize resources for hands-on learning in real estate finance and investment courses.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Walker & Dunlop, Inc. (WD) 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 Walker & Dunlop, Inc. (WD).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.