Cushman & Wakefield plc (CWK) DCF Valuation
- ✓ 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
Cushman & Wakefield plc (CWK) Bundle
Enhance your investment choices with the (CWK) DCF Calculator! Utilize real financial data from Cushman & Wakefield, adjust growth predictions and expenses, and instantly observe how these alterations affect the intrinsic value of (CWK).
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 | 8,751.0 | 7,843.7 | 9,388.7 | 10,105.7 | 9,493.7 | 9,752.6 | 10,018.7 | 10,291.9 | 10,572.6 | 10,861.0 |
| Revenue Growth, % | 0 | -10.37 | 19.7 | 7.64 | -6.06 | 2.73 | 2.73 | 2.73 | 2.73 | 2.73 |
| EBITDA | 491.7 | 267.6 | 795.7 | 780.2 | 494.5 | 593.6 | 609.8 | 626.5 | 643.5 | 661.1 |
| EBITDA, % | 5.62 | 3.41 | 8.48 | 7.72 | 5.21 | 6.09 | 6.09 | 6.09 | 6.09 | 6.09 |
| Depreciation | 8,555.8 | 7,840.3 | 8,847.3 | 9,644.2 | 243.4 | 7,606.2 | 7,813.7 | 8,026.8 | 8,245.7 | 8,470.6 |
| Depreciation, % | 97.77 | 99.96 | 94.23 | 95.43 | 2.56 | 77.99 | 77.99 | 77.99 | 77.99 | 77.99 |
| EBIT | -8,064.1 | -7,572.7 | -8,051.6 | -8,864.0 | 251.1 | -7,012.6 | -7,203.9 | -7,400.3 | -7,602.2 | -7,809.5 |
| EBIT, % | -92.15 | -96.54 | -85.76 | -87.71 | 2.64 | -71.9 | -71.9 | -71.9 | -71.9 | -71.9 |
| Total Cash | 813.2 | 1,074.8 | 770.7 | 644.5 | 767.7 | 890.8 | 915.1 | 940.0 | 965.7 | 992.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,837.6 | 1,592.7 | 1,794.9 | 1,462.4 | 1,846.1 | 1,840.1 | 1,890.3 | 1,941.8 | 1,994.8 | 2,049.2 |
| Account Receivables, % | 21 | 20.31 | 19.12 | 14.47 | 19.45 | 18.87 | 18.87 | 18.87 | 18.87 | 18.87 |
| Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Inventories, % | 0 | 0.0000000127 | 0 | 0 | 0 | 0.00000000255 | 0.00000000255 | 0.00000000255 | 0.00000000255 | 0.00000000255 |
| Accounts Payable | 1,145.3 | 1,054.4 | 1,106.2 | 1,199.0 | 1,157.7 | 1,216.6 | 1,249.8 | 1,283.8 | 1,318.9 | 1,354.8 |
| Accounts Payable, % | 13.09 | 13.44 | 11.78 | 11.86 | 12.19 | 12.47 | 12.47 | 12.47 | 12.47 | 12.47 |
| Capital Expenditure | -80.3 | -41.0 | -53.8 | -50.7 | -51.0 | -59.5 | -61.2 | -62.8 | -64.5 | -66.3 |
| Capital Expenditure, % | -0.91761 | -0.52271 | -0.57303 | -0.5017 | -0.5372 | -0.61045 | -0.61045 | -0.61045 | -0.61045 | -0.61045 |
| Tax Rate, % | -18 | -18 | -18 | -18 | -18 | -18 | -18 | -18 | -18 | -18 |
| EBITAT | -37.7 | -9,455.2 | -5,922.0 | -5,150.6 | 296.3 | -4,658.1 | -4,785.2 | -4,915.7 | -5,049.8 | -5,187.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 7,745.5 | -1,501.9 | 2,721.1 | 4,868.2 | 63.7 | 2,953.5 | 2,950.4 | 3,030.8 | 3,113.5 | 3,198.4 |
| WACC, % | 4.84 | 9.12 | 7.99 | 7.32 | 9.12 | 7.68 | 7.68 | 7.68 | 7.68 | 7.68 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 12,240.0 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 3,310 | |||||||||
| Terminal Value | 79,196 | |||||||||
| Present Terminal Value | 54,706 | |||||||||
| Enterprise Value | 66,946 | |||||||||
| Net Debt | 2,799 | |||||||||
| Equity Value | 64,147 | |||||||||
| Diluted Shares Outstanding, MM | 227 | |||||||||
| Equity Value Per Share | 282.71 |
What You Will Get
- Real CWK Financial Data: Pre-filled with Cushman & Wakefield’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Cushman & Wakefield’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive CWK Data: Pre-loaded with Cushman & Wakefield's historical performance metrics and future outlook estimates.
- Customizable Assumptions: Modify parameters such as revenue growth, operating margins, discount rates, tax implications, and capital investments.
- Interactive Valuation Framework: Real-time updates to Net Present Value (NPV) and intrinsic value based on user-defined inputs.
- Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
- Intuitive Interface: Designed to be straightforward and accessible for both industry experts and newcomers.
How It Works
- Step 1: Download the Excel file for Cushman & Wakefield plc (CWK).
- Step 2: Review the pre-filled financial data and forecasts for Cushman & Wakefield plc (CWK).
- 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 This Calculator for Cushman & Wakefield plc (CWK)?
- User-Friendly Interface: Perfectly crafted for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters effortlessly to suit your evaluation needs.
- Real-Time Adjustments: Observe immediate changes to CWK’s valuation as you modify inputs.
- Pre-Loaded Data: Comes with Cushman & Wakefield's actual financial metrics for swift assessments.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Real Estate Investors: Assess Cushman & Wakefield's (CWK) market position before making investment decisions.
- Corporate Real Estate Executives: Optimize property valuation processes and evaluate strategic decisions.
- Property Developers: Understand the valuation methodologies used by leading firms like Cushman & Wakefield.
- Consultants: Provide comprehensive valuation analyses and reports for clients in the real estate sector.
- Students and Educators: Utilize real estate data to learn and teach valuation principles and practices.
What the Template Contains
- Preloaded CWK Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.