|
Cohen & Steers, Inc. (CNS) DCF Valuation
US | Financial Services | Asset Management | NYSE
|
- ✓ 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
Cohen & Steers, Inc. (CNS) Bundle
Gain insight into your Cohen & Steers, Inc. (CNS) valuation analysis using our state-of-the-art DCF Calculator! This Excel template comes preloaded with real CNS data, enabling you to adjust forecasts and assumptions to accurately determine the intrinsic value of Cohen & Steers, Inc.
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 | 410.8 | 427.5 | 583.8 | 566.9 | 489.6 | 519.1 | 550.4 | 583.6 | 618.7 | 656.0 |
| Revenue Growth, % | 0 | 4.07 | 36.56 | -2.9 | -13.63 | 6.02 | 6.02 | 6.02 | 6.02 | 6.02 |
| EBITDA | 181.9 | 114.7 | 279.3 | 240.2 | 198.7 | 209.6 | 222.3 | 235.6 | 249.8 | 264.9 |
| EBITDA, % | 44.27 | 26.83 | 47.84 | 42.37 | 40.59 | 40.38 | 40.38 | 40.38 | 40.38 | 40.38 |
| Depreciation | 241.3 | 331.2 | 313.1 | 383.2 | 19.6 | 271.4 | 287.8 | 305.1 | 323.5 | 343.0 |
| Depreciation, % | 58.72 | 77.47 | 53.62 | 67.6 | 4.01 | 52.28 | 52.28 | 52.28 | 52.28 | 52.28 |
| EBIT | -59.4 | -216.5 | -33.8 | -143.0 | 179.1 | -61.8 | -65.5 | -69.5 | -73.7 | -78.1 |
| EBIT, % | -14.45 | -50.64 | -5.78 | -25.22 | 36.58 | -11.9 | -11.9 | -11.9 | -11.9 | -11.9 |
| Total Cash | 101.4 | 41.2 | 184.4 | 262.7 | 187.4 | 156.3 | 165.7 | 175.7 | 186.3 | 197.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 60.8 | 74.8 | 87.7 | 72.3 | 73.6 | 78.0 | 82.7 | 87.6 | 92.9 | 98.5 |
| Account Receivables, % | 14.81 | 17.5 | 15.01 | 12.75 | 15.02 | 15.02 | 15.02 | 15.02 | 15.02 | 15.02 |
| Inventories | -15.0 | -18.7 | -23.7 | -15.3 | .0 | -15.3 | -16.3 | -17.2 | -18.3 | -19.4 |
| Inventories, % | -3.65 | -4.37 | -4.06 | -2.7 | 0 | -2.96 | -2.96 | -2.96 | -2.96 | -2.96 |
| Accounts Payable | 7.3 | 7.7 | 10.2 | 8.4 | 10.1 | 9.2 | 9.8 | 10.4 | 11.0 | 11.7 |
| Accounts Payable, % | 1.78 | 1.81 | 1.74 | 1.49 | 2.07 | 1.78 | 1.78 | 1.78 | 1.78 | 1.78 |
| Capital Expenditure | -2.8 | -2.5 | -2.7 | -4.2 | -57.0 | -14.6 | -15.5 | -16.5 | -17.4 | -18.5 |
| Capital Expenditure, % | -0.66986 | -0.58521 | -0.46161 | -0.74492 | -11.64 | -2.82 | -2.82 | -2.82 | -2.82 | -2.82 |
| Tax Rate, % | 28.41 | 28.41 | 28.41 | 28.41 | 28.41 | 28.41 | 28.41 | 28.41 | 28.41 | 28.41 |
| EBITAT | -42.6 | -177.6 | -25.3 | -124.2 | 128.2 | -47.9 | -50.7 | -53.8 | -57.0 | -60.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 157.3 | 141.3 | 279.7 | 260.0 | 76.0 | 219.0 | 218.3 | 231.4 | 245.4 | 260.2 |
| WACC, % | 11.29 | 11.3 | 11.29 | 11.31 | 11.29 | 11.3 | 11.3 | 11.3 | 11.3 | 11.3 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 853.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 265 | |||||||||
| Terminal Value | 2,855 | |||||||||
| Present Terminal Value | 1,672 | |||||||||
| Enterprise Value | 2,525 | |||||||||
| Net Debt | -47 | |||||||||
| Equity Value | 2,572 | |||||||||
| Diluted Shares Outstanding, MM | 50 | |||||||||
| Equity Value Per Share | 51.90 |
What You Will Get
- Real Cohen & Steers Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Cohen & Steers, Inc. (CNS).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to Cohen & Steers, Inc. (CNS).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Cohen & Steers, Inc.'s (CNS) fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for Cohen & Steers, Inc. (CNS).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Cohen & Steers, Inc. (CNS).
Key Features
- Comprehensive Historical Data: Access Cohen & Steers, Inc.'s (CNS) past financial statements and projected forecasts.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins to suit your analysis.
- Real-Time Valuation: Watch Cohen & Steers, Inc.'s (CNS) intrinsic value update instantly.
- Intuitive Visualizations: Interactive dashboard charts illustrate valuation outcomes and essential metrics.
- Designed for Precision: A reliable resource for analysts, investors, and finance professionals.
How It Works
- Download the Template: Gain immediate access to the Excel-based CNS DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model will automatically refresh to display Cohen & Steers' intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Leverage the results to inform your investment or financial strategy.
Why Choose Cohen & Steers, Inc. (CNS) Calculator?
- Comprehensive Tool: Integrates DCF, WACC, and financial ratio analyses into a single platform.
- Customizable Inputs: Modify yellow-highlighted cells to explore different investment scenarios.
- Detailed Insights: Automatically computes Cohen & Steers’ intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable starting points for analysis.
- Professional Quality: Perfect for financial analysts, investors, and business consultants.
Who Should Use This Product?
- Investors: Evaluate Cohen & Steers' valuation before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
- Asset Managers: Understand how leading firms like Cohen & Steers are appraised in the market.
- Consultants: Provide comprehensive valuation analyses for clients in the asset management sector.
- Students and Educators: Utilize real market data to learn and instruct on valuation principles.
What the Template Contains
- Pre-Filled Data: Includes Cohen & Steers, Inc.'s (CNS) historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Cohen & Steers, Inc.'s (CNS) profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.