Evercore Inc. (EVR) 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
Evercore Inc. (EVR) Bundle
Designed for accuracy, our (EVR) DCF Calculator enables you to assess Evercore Inc. valuation using real-world financial data, offering complete flexibility to modify all key parameters for improved 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 | 2,008.7 | 2,263.9 | 3,289.5 | 2,762.0 | 2,442.7 | 2,628.4 | 2,828.2 | 3,043.2 | 3,274.5 | 3,523.5 |
Revenue Growth, % | 0 | 12.71 | 45.3 | -16.03 | -11.56 | 7.6 | 7.6 | 7.6 | 7.6 | 7.6 |
EBITDA | .0 | .0 | .0 | .0 | 445.3 | 95.8 | 103.1 | 110.9 | 119.4 | 128.5 |
EBITDA, % | 0 | 0 | 0 | 0 | 18.23 | 3.65 | 3.65 | 3.65 | 3.65 | 3.65 |
Depreciation | 1,559.8 | 1,690.3 | 2,178.5 | 2,062.9 | 66.5 | 1,555.7 | 1,674.0 | 1,801.3 | 1,938.2 | 2,085.6 |
Depreciation, % | 77.65 | 74.66 | 66.23 | 74.69 | 2.72 | 59.19 | 59.19 | 59.19 | 59.19 | 59.19 |
EBIT | -1,559.8 | -1,690.3 | -2,178.5 | -2,062.9 | 378.8 | -1,459.9 | -1,570.9 | -1,690.3 | -1,818.8 | -1,957.1 |
EBIT, % | -77.65 | -74.66 | -66.23 | -74.69 | 15.51 | -55.54 | -55.54 | -55.54 | -55.54 | -55.54 |
Total Cash | 848.6 | 829.6 | 719.5 | 786.3 | 2,033.8 | 1,117.0 | 1,201.9 | 1,293.3 | 1,391.6 | 1,497.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 296.4 | 368.3 | 351.7 | 385.1 | 397.4 | 378.1 | 406.8 | 437.8 | 471.0 | 506.9 |
Account Receivables, % | 14.75 | 16.27 | 10.69 | 13.94 | 16.27 | 14.39 | 14.39 | 14.39 | 14.39 | 14.39 |
Inventories | -136.3 | -115.8 | -83.7 | -225.5 | .0 | -118.9 | -127.9 | -137.6 | -148.1 | -159.3 |
Inventories, % | -6.79 | -5.12 | -2.55 | -8.16 | 0 | -4.52 | -4.52 | -4.52 | -4.52 | -4.52 |
Accounts Payable | 39.7 | 38.0 | 31.6 | 28.8 | 26.0 | 35.3 | 38.0 | 40.9 | 44.0 | 47.4 |
Accounts Payable, % | 1.98 | 1.68 | 0.96164 | 1.04 | 1.06 | 1.34 | 1.34 | 1.34 | 1.34 | 1.34 |
Capital Expenditure | -70.8 | -53.3 | -28.0 | -23.2 | -20.0 | -44.1 | -47.5 | -51.1 | -55.0 | -59.1 |
Capital Expenditure, % | -3.53 | -2.36 | -0.85031 | -0.83949 | -0.82074 | -1.68 | -1.68 | -1.68 | -1.68 | -1.68 |
Tax Rate, % | 30.16 | 30.16 | 30.16 | 30.16 | 30.16 | 30.16 | 30.16 | 30.16 | 30.16 | 30.16 |
EBITAT | -1,034.0 | -1,095.7 | -1,444.0 | -1,396.2 | 264.5 | -977.9 | -1,052.2 | -1,132.2 | -1,218.3 | -1,310.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 334.7 | 447.0 | 684.8 | 748.9 | 70.5 | 681.2 | 557.3 | 599.6 | 645.2 | 694.3 |
WACC, % | 10.3 | 10.3 | 10.3 | 10.31 | 10.31 | 10.31 | 10.31 | 10.31 | 10.31 | 10.31 |
PV UFCF | ||||||||||
SUM PV UFCF | 2,383.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 708 | |||||||||
Terminal Value | 8,527 | |||||||||
Present Terminal Value | 5,222 | |||||||||
Enterprise Value | 7,605 | |||||||||
Net Debt | 248 | |||||||||
Equity Value | 7,358 | |||||||||
Diluted Shares Outstanding, MM | 40 | |||||||||
Equity Value Per Share | 183.49 |
What You Will Receive
- Comprehensive Financial Model: Evercore Inc.’s (EVR) actual data facilitates accurate DCF valuation.
- Complete Forecasting Control: Modify revenue growth, profit margins, WACC, and other essential variables.
- Real-Time Calculations: Automatic updates allow you to view results immediately as you adjust inputs.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Flexible and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasting.
Key Features
- Comprehensive Financial Data: Evercore Inc.’s historical financial statements and pre-filled projections.
- Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Calculations: Observe Evercore’s intrinsic value update instantly.
- Intuitive Visual Outputs: Dashboard graphs illustrate valuation results and essential metrics.
- Designed for Precision: A professional-grade tool for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the prebuilt Excel template featuring Evercore Inc.'s (EVR) data.
- Step 2: Review the pre-filled sheets to familiarize yourself with the key financial metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth rates, profit margins).
- Step 4: Instantly observe recalculated results, including Evercore Inc.'s (EVR) intrinsic value.
- Step 5: Utilize the outputs to make informed investment decisions or create detailed reports.
Why Choose Evercore's Services?
- Comprehensive Advisory: Offers M&A advisory, restructuring, and capital markets expertise in one firm.
- Tailored Solutions: Customized strategies to meet the unique needs of each client.
- In-Depth Analysis: Provides detailed market insights and financial assessments for informed decision-making.
- Proven Track Record: Extensive experience with high-profile transactions and a strong reputation in the industry.
- Expert Team: Led by seasoned professionals with deep industry knowledge and relationships.
Who Should Use This Product?
- Institutional Investors: Develop comprehensive and accurate valuation models for investment strategies involving Evercore Inc. (EVR).
- Corporate Finance Departments: Evaluate valuation scenarios to inform corporate decision-making and strategy at Evercore Inc. (EVR).
- Financial Consultants: Deliver precise valuation analyses and insights for clients interested in Evercore Inc. (EVR).
- Academic Scholars and Students: Utilize real-time data to enhance learning and practice in financial modeling with Evercore Inc. (EVR).
- Market Analysts: Gain insights into the valuation processes of investment banking firms like Evercore Inc. (EVR).
What the Template Contains
- Pre-Filled DCF Model: Evercore Inc.’s (EVR) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Evercore Inc.’s (EVR) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.