Ellington Financial Inc. (EFC) 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
Ellington Financial Inc. (EFC) Bundle
Looking to determine the intrinsic value of Ellington Financial Inc.? Our EFC DCF Calculator integrates real-world data with comprehensive customization options, enabling you to refine your forecasts and enhance your investment strategies.
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 | 85.2 | 31.3 | 122.0 | 43.1 | 256.5 | 302.7 | 357.3 | 421.7 | 497.6 | 587.3 |
| Revenue Growth, % | 0 | -63.3 | 290.19 | -64.62 | 494.48 | 18.02 | 18.02 | 18.02 | 18.02 | 18.02 |
| EBITDA | 59.5 | .0 | .0 | .0 | .0 | 42.3 | 49.9 | 58.9 | 69.5 | 82.1 |
| EBITDA, % | 69.86 | 0 | 0 | 0 | 0 | 13.97 | 13.97 | 13.97 | 13.97 | 13.97 |
| Depreciation | 69.4 | 66.4 | 81.9 | 184.3 | .0 | 211.0 | 249.1 | 293.9 | 346.9 | 409.4 |
| Depreciation, % | 81.44 | 212.4 | 67.12 | 427.25 | 0 | 69.71 | 69.71 | 69.71 | 69.71 | 69.71 |
| EBIT | -9.9 | -66.4 | -81.9 | -184.3 | .0 | -168.7 | -199.1 | -235.0 | -277.4 | -327.4 |
| EBIT, % | -11.58 | -212.4 | -67.12 | -427.25 | 0 | -55.74 | -55.74 | -55.74 | -55.74 | -55.74 |
| Total Cash | 72.3 | 111.6 | 92.7 | 217.1 | 228.9 | 272.5 | 321.6 | 379.6 | 448.0 | 528.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 202.9 | 112.5 | 215.7 | 176.2 | .0 | 242.2 | 285.8 | 337.3 | 398.1 | 469.9 |
| Account Receivables, % | 238.32 | 359.82 | 176.89 | 408.31 | 0 | 80 | 80 | 80 | 80 | 80 |
| Inventories | 30.6 | 23.6 | 24.7 | 28.4 | .0 | 119.6 | 141.1 | 166.5 | 196.5 | 232.0 |
| Inventories, % | 35.91 | 75.5 | 20.24 | 65.83 | 0 | 39.5 | 39.5 | 39.5 | 39.5 | 39.5 |
| Accounts Payable | 80.4 | 13.7 | 54.0 | 84.0 | 71.9 | 188.1 | 222.0 | 262.0 | 309.2 | 364.9 |
| Accounts Payable, % | 94.45 | 43.91 | 44.27 | 194.73 | 28.02 | 62.13 | 62.13 | 62.13 | 62.13 | 62.13 |
| Capital Expenditure | 49.8 | 30.6 | 172.8 | -39.1 | .0 | -54.9 | -64.8 | -76.4 | -90.2 | -106.5 |
| Capital Expenditure, % | 58.43 | 98.04 | 141.72 | -90.64 | 0 | -18.13 | -18.13 | -18.13 | -18.13 | -18.13 |
| Tax Rate, % | 5.75 | 5.75 | 5.75 | 5.75 | 5.75 | 5.75 | 5.75 | 5.75 | 5.75 | 5.75 |
| EBITAT | -10.5 | 348.4 | -78.9 | -53.6 | .0 | -107.9 | -127.3 | -150.3 | -177.3 | -209.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -44.5 | 476.2 | 111.8 | 157.5 | 192.4 | -197.2 | 25.7 | 30.3 | 35.8 | 42.2 |
| WACC, % | 5.01 | 0.82007 | 4.85 | 2.04 | 4.77 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -72.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 43 | |||||||||
| Terminal Value | 2,880 | |||||||||
| Present Terminal Value | 2,425 | |||||||||
| Enterprise Value | 2,353 | |||||||||
| Net Debt | -229 | |||||||||
| Equity Value | 2,582 | |||||||||
| Diluted Shares Outstanding, MM | 69 | |||||||||
| Equity Value Per Share | 37.38 |
What You Will Get
- Real EFC 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: Intrinsic value and NPV are updated automatically.
- Scenario Analysis: Evaluate various scenarios to assess Ellington Financial's future performance.
- User-Friendly Design: Tailored for professionals while remaining approachable for newcomers.
Key Features
- Customizable Financial Inputs: Adjust essential metrics such as interest rates, loan-to-value ratios, and dividend yields.
- Instant DCF Analysis: Automatically computes intrinsic value, net present value, and additional financial metrics.
- High-Precision Valuation: Leverages Ellington Financial’s (EFC) actual performance data for accurate valuation insights.
- Effortless Scenario Testing: Easily explore various financial scenarios and assess their potential impacts.
- Efficiency Booster: Streamline your valuation process without the hassle of constructing intricate financial models from the ground up.
How It Works
- Step 1: Download the prebuilt Excel template featuring Ellington Financial Inc. (EFC) data.
- Step 2: Review the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly access recalculated results, showcasing Ellington Financial Inc.’s (EFC) intrinsic value.
- Step 5: Make well-informed investment choices or create reports based on the outputs.
Why Choose This Calculator for Ellington Financial Inc. (EFC)?
- Designed for Experts: A sophisticated tool utilized by financial analysts, portfolio managers, and investors.
- Comprehensive Data: Ellington Financial’s historical and projected financials are preloaded for precise analysis.
- What-If Scenarios: Effortlessly simulate various forecasts and assumptions to explore potential outcomes.
- Detailed Results: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Clear, step-by-step instructions make the process straightforward and accessible.
Who Should Use This Product?
- Institutional Investors: Develop comprehensive and accurate valuation models for investment analysis in Ellington Financial Inc. (EFC).
- Financial Analysts: Evaluate various valuation scenarios to inform investment strategies and recommendations.
- Wealth Managers: Offer clients precise valuation insights and investment opportunities related to Ellington Financial Inc. (EFC).
- Students and Educators: Utilize real market data to enhance learning and practice in financial modeling and analysis.
- Market Enthusiasts: Gain insights into how financial firms like Ellington Financial Inc. (EFC) are assessed and valued in the market.
What the Template Contains
- Historical Data: Includes Ellington Financial Inc.'s (EFC) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Ellington Financial Inc.'s (EFC) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Ellington Financial Inc.'s (EFC) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.