Central Securities Corp. (CET) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Central Securities Corp. (CET) Bundle
Whether you’re an investor or analyst, this Central Securities Corp. (CET) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from Central Securities Corp., you can adjust forecasts and observe the effects immediately.
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 | 257.0 | 79.9 | 360.3 | -152.6 | 230.4 | 133.1 | 76.9 | 44.4 | 25.7 | 14.8 |
Revenue Growth, % | 0 | -68.91 | 350.98 | -142.37 | -250.96 | -42.23 | -42.23 | -42.23 | -42.23 | -42.23 |
EBITDA | 251.0 | 73.7 | 354.0 | -158.7 | 223.9 | 129.2 | 74.7 | 43.1 | 24.9 | 14.4 |
EBITDA, % | 97.69 | 92.28 | 98.24 | 103.94 | 97.14 | 97.07 | 97.07 | 97.07 | 97.07 | 97.07 |
Depreciation | .0 | .0 | .4 | .2 | .2 | .0 | .0 | .0 | .0 | .0 |
Depreciation, % | 0.00145273 | 0.00915832 | 0.10941 | -0.11836 | 0.09472307 | 0.01927502 | 0.01927502 | 0.01927502 | 0.01927502 | 0.01927502 |
EBIT | 251.0 | 73.7 | 353.6 | -158.8 | 223.6 | 129.2 | 74.6 | 43.1 | 24.9 | 14.4 |
EBIT, % | 97.68 | 92.27 | 98.13 | 104.06 | 97.05 | 97.03 | 97.03 | 97.03 | 97.03 | 97.03 |
Total Cash | .7 | 1.0 | .6 | .6 | 82.4 | 9.9 | 5.7 | 3.3 | 1.9 | 1.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .4 | .6 | .7 | .9 | 1.0 | .3 | .2 | .1 | .1 | .0 |
Account Receivables, % | 0.16277 | 0.80191 | 0.19219 | -0.59542 | 0.41426 | 0.19514 | 0.19514 | 0.19514 | 0.19514 | 0.19514 |
Inventories | 67.2 | 29.6 | 17.6 | 88.7 | 83.4 | 12.3 | 7.1 | 4.1 | 2.4 | 1.4 |
Inventories, % | 26.14 | 36.99 | 4.9 | -58.1 | 36.19 | 9.22 | 9.22 | 9.22 | 9.22 | 9.22 |
Accounts Payable | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Accounts Payable, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Capital Expenditure | .0 | .0 | .0 | .0 | -1.2 | -.1 | -.1 | .0 | .0 | .0 |
Capital Expenditure, % | 0 | 0 | 0 | 0 | -0.52127 | -0.10425 | -0.10425 | -0.10425 | -0.10425 | -0.10425 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | 251.0 | 73.7 | 353.6 | -158.8 | 223.6 | 129.2 | 74.6 | 43.1 | 24.9 | 14.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 183.4 | 111.1 | 365.8 | -229.9 | 227.9 | 200.9 | 79.9 | 46.1 | 26.7 | 15.4 |
WACC, % | 8.21 | 8.21 | 8.21 | 8.21 | 8.21 | 8.21 | 8.21 | 8.21 | 8.21 | 8.21 |
PV UFCF | ||||||||||
SUM PV UFCF | 320.0 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 15 | |||||||||
Terminal Value | 201 | |||||||||
Present Terminal Value | 135 | |||||||||
Enterprise Value | 455 | |||||||||
Net Debt | 2 | |||||||||
Equity Value | 453 | |||||||||
Diluted Shares Outstanding, MM | 28 | |||||||||
Equity Value Per Share | 15.96 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled financial data for CET.
- Authentic Financial Data: Access to historical figures and forward-looking projections (highlighted in the yellow cells).
- Flexible Forecasting: Modify forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs influence the valuation of Central Securities Corp. (CET).
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- User-Centric Layout: Organized for simplicity and efficiency, complete with step-by-step guidance.
Key Features
- Accurate Financial Data: Gain access to reliable pre-loaded historical figures and future forecasts for Central Securities Corp. (CET).
- Tailored Forecast Inputs: Modify highlighted fields such as WACC, growth rates, and profit margins to suit your analysis.
- Automated Calculations: Instant updates to DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Intuitive charts and summaries to easily interpret your valuation findings.
- Designed for All Skill Levels: A straightforward, user-centric layout ideal for investors, CFOs, and consultants alike.
How It Works
- Download: Obtain the comprehensive Excel file featuring Central Securities Corp.'s (CET) financial data.
- Customize: Tailor your forecasts, including revenue growth, EBITDA %, and WACC.
- Update Automatically: Watch as the intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various projections and instantly compare the results.
- Make Decisions: Leverage the valuation insights to inform your investment strategy.
Why Choose This Calculator for Central Securities Corp. (CET)?
- User-Friendly Interface: Perfect for both novice and seasoned users.
- Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
- Real-Time Feedback: Observe immediate changes to Central Securities Corp.’s valuation as you modify inputs.
- Pre-Configured Data: Comes with Central Securities Corp.’s latest financial information for swift evaluations.
- Relied Upon by Experts: Preferred by investors and analysts for making well-informed choices.
Who Should Use Central Securities Corp. (CET)?
- Finance Students: Explore investment strategies and apply them using real market data.
- Academics: Utilize comprehensive models for teaching and research purposes.
- Investors: Evaluate your investment hypotheses and assess the performance of Central Securities Corp. (CET).
- Analysts: Enhance your analysis with a ready-to-use, adaptable financial model.
- Small Business Owners: Understand the evaluation methods used for publicly traded companies like Central Securities Corp. (CET).
What the Template Contains
- Preloaded CET 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.