Kennedy-Wilson Holdings, Inc. (KW) 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
Kennedy-Wilson Holdings, Inc. (KW) Bundle
Simplify Kennedy-Wilson Holdings, Inc. (KW) valuation with this customizable DCF Calculator! Featuring real Kennedy-Wilson Holdings, Inc. (KW) financials and adjustable forecast inputs, you can test scenarios and uncover Kennedy-Wilson Holdings, Inc. (KW) fair value in minutes.
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 | 569.7 | 450.9 | 453.6 | 540.0 | 562.6 | 566.8 | 571.0 | 575.3 | 579.5 | 583.9 |
| Revenue Growth, % | 0 | -20.85 | 0.5988 | 19.05 | 4.19 | 0.74463 | 0.74463 | 0.74463 | 0.74463 | 0.74463 |
| EBITDA | 337.6 | 205.1 | 454.3 | 400.6 | 212.1 | 358.9 | 361.6 | 364.3 | 367.0 | 369.7 |
| EBITDA, % | 59.26 | 45.49 | 100.15 | 74.19 | 37.7 | 63.33 | 63.33 | 63.33 | 63.33 | 63.33 |
| Depreciation | 599.8 | 508.1 | 549.6 | 484.4 | 157.8 | 473.6 | 477.1 | 480.6 | 484.2 | 487.8 |
| Depreciation, % | 105.28 | 112.69 | 121.16 | 89.7 | 28.05 | 83.55 | 83.55 | 83.55 | 83.55 | 83.55 |
| EBIT | -262.2 | -303.0 | -95.3 | -83.8 | 54.3 | -158.8 | -160.0 | -161.2 | -162.4 | -163.6 |
| EBIT, % | -46.02 | -67.2 | -21.01 | -15.52 | 9.65 | -28.02 | -28.02 | -28.02 | -28.02 | -28.02 |
| Total Cash | 573.9 | 965.1 | 524.8 | 439.3 | 313.7 | 495.5 | 499.2 | 502.9 | 506.7 | 510.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 111.3 | 99.5 | 80.4 | 83.0 | 359.3 | 157.1 | 158.2 | 159.4 | 160.6 | 161.8 |
| Account Receivables, % | 19.54 | 22.07 | 17.72 | 15.37 | 63.86 | 27.71 | 27.71 | 27.71 | 27.71 | 27.71 |
| Inventories | 675.8 | 1,064.6 | 605.2 | -12.7 | .0 | 337.4 | 339.9 | 342.5 | 345.0 | 347.6 |
| Inventories, % | 118.62 | 236.11 | 133.42 | -2.35 | 0 | 59.53 | 59.53 | 59.53 | 59.53 | 59.53 |
| Accounts Payable | 20.4 | 30.1 | 18.6 | 16.2 | 17.9 | 23.3 | 23.5 | 23.6 | 23.8 | 24.0 |
| Accounts Payable, % | 3.58 | 6.68 | 4.1 | 3 | 3.18 | 4.11 | 4.11 | 4.11 | 4.11 | 4.11 |
| Capital Expenditure | -191.1 | -194.1 | -139.2 | -160.9 | -217.2 | -199.1 | -200.6 | -202.1 | -203.6 | -205.1 |
| Capital Expenditure, % | -33.54 | -43.05 | -30.69 | -29.8 | -38.61 | -35.14 | -35.14 | -35.14 | -35.14 | -35.14 |
| Tax Rate, % | 9.77 | 9.77 | 9.77 | 9.77 | 9.77 | 9.77 | 9.77 | 9.77 | 9.77 | 9.77 |
| EBITAT | -232.3 | -220.3 | -68.1 | -56.9 | 49.0 | -124.1 | -125.1 | -126.0 | -126.9 | -127.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -590.3 | -273.6 | 809.3 | 879.5 | -297.7 | 20.5 | 147.9 | 149.0 | 150.1 | 151.2 |
| WACC, % | 5.47 | 4.85 | 4.8 | 4.66 | 5.53 | 5.06 | 5.06 | 5.06 | 5.06 | 5.06 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 523.3 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 154 | |||||||||
| Terminal Value | 5,036 | |||||||||
| Present Terminal Value | 3,934 | |||||||||
| Enterprise Value | 4,457 | |||||||||
| Net Debt | 4,984 | |||||||||
| Equity Value | -527 | |||||||||
| Diluted Shares Outstanding, MM | 139 | |||||||||
| Equity Value Per Share | -3.80 |
What You Will Get
- Editable Forecast Inputs: Effortlessly modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Kennedy-Wilson Holdings, Inc. (KW)’s financial data pre-loaded to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model tailored to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Accurate Kennedy-Wilson Financials: Gain access to reliable pre-loaded historical data and future forecasts.
- Adjustable Forecast Parameters: Modify highlighted fields such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Instant updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Clear charts and summaries for easy visualization of your valuation findings.
- Designed for All Skill Levels: An intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file for Kennedy-Wilson Holdings, Inc. (KW).
- Step 2: Review the pre-filled financial data and forecasts for Kennedy-Wilson.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model refresh in real-time as you modify your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose Kennedy-Wilson Holdings, Inc. (KW)?
- Time Efficiency: Skip the hassle of building a financial model from the ground up – our tools are ready to go.
- Enhanced Precision: Dependable financial insights and calculations minimize valuation inaccuracies.
- Completely Customizable: Adjust the model to align with your specific assumptions and forecasts.
- User-Friendly: Intuitive charts and outputs simplify the analysis of results.
- Endorsed by Professionals: Crafted for experts who prioritize accuracy and functionality.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Kennedy-Wilson Holdings, Inc. (KW).
- Financial Analysts: Streamline valuation processes with ready-to-use financial models specific to Kennedy-Wilson Holdings, Inc. (KW).
- Consultants: Deliver professional valuation insights on Kennedy-Wilson Holdings, Inc. (KW) to clients quickly and accurately.
- Business Owners: Understand how real estate investment firms like Kennedy-Wilson Holdings, Inc. (KW) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Kennedy-Wilson Holdings, Inc. (KW).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Kennedy-Wilson Holdings, Inc. (KW) 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 Kennedy-Wilson Holdings, Inc. (KW).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.