Varex Imaging Corporation (VREX) 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
Varex Imaging Corporation (VREX) Bundle
Engineered for accuracy, our VREX (VREX) DCF Calculator enables you to assess Varex Imaging Corporation's valuation using up-to-date financial data and offers complete flexibility to modify all essential parameters for improved projections.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 738.3 | 818.1 | 859.4 | 893.4 | 811.0 | 832.5 | 854.5 | 877.1 | 900.4 | 924.2 |
Revenue Growth, % | 0 | 10.81 | 5.05 | 3.96 | -9.22 | 2.65 | 2.65 | 2.65 | 2.65 | 2.65 |
EBITDA | -1.7 | 112.4 | 123.6 | 110.3 | 67.2 | 80.8 | 82.9 | 85.1 | 87.4 | 89.7 |
EBITDA, % | -0.23026 | 13.74 | 14.38 | 12.35 | 8.29 | 9.7 | 9.7 | 9.7 | 9.7 | 9.7 |
Depreciation | 39.5 | 37.3 | 33.6 | 33.2 | 31.1 | 35.6 | 36.5 | 37.5 | 38.5 | 39.5 |
Depreciation, % | 5.35 | 4.56 | 3.91 | 3.72 | 3.83 | 4.27 | 4.27 | 4.27 | 4.27 | 4.27 |
EBIT | -41.2 | 75.1 | 90.0 | 77.1 | 36.1 | 45.2 | 46.4 | 47.6 | 48.9 | 50.2 |
EBIT, % | -5.58 | 9.18 | 10.47 | 8.63 | 4.45 | 5.43 | 5.43 | 5.43 | 5.43 | 5.43 |
Total Cash | 100.6 | 144.6 | 89.4 | 152.6 | 200.5 | 139.0 | 142.7 | 146.5 | 150.4 | 154.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 123.8 | 155.3 | 173.3 | 163.6 | 157.7 | 156.0 | 160.1 | 164.3 | 168.7 | 173.1 |
Account Receivables, % | 16.77 | 18.98 | 20.17 | 18.31 | 19.45 | 18.73 | 18.73 | 18.73 | 18.73 | 18.73 |
Inventories | 271.9 | 224.8 | 303.2 | 277.5 | 264.8 | 271.9 | 279.1 | 286.5 | 294.1 | 301.8 |
Inventories, % | 36.83 | 27.48 | 35.28 | 31.06 | 32.65 | 32.66 | 32.66 | 32.66 | 32.66 | 32.66 |
Accounts Payable | 72.9 | 58.8 | 78.2 | 64.7 | 59.1 | 67.7 | 69.5 | 71.4 | 73.3 | 75.2 |
Accounts Payable, % | 9.87 | 7.19 | 9.1 | 7.24 | 7.29 | 8.14 | 8.14 | 8.14 | 8.14 | 8.14 |
Capital Expenditure | -23.5 | -15.1 | -21.3 | -20.7 | -26.9 | -21.9 | -22.5 | -23.1 | -23.7 | -24.3 |
Capital Expenditure, % | -3.18 | -1.85 | -2.48 | -2.32 | -3.32 | -2.63 | -2.63 | -2.63 | -2.63 | -2.63 |
Tax Rate, % | 1054 | 1054 | 1054 | 1054 | 1054 | 1054 | 1054 | 1054 | 1054 | 1054 |
EBITAT | -32.5 | 45.7 | 61.3 | 118.7 | -344.4 | 27.8 | 28.6 | 29.3 | 30.1 | 30.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -339.3 | 69.4 | -3.4 | 153.1 | -327.2 | 44.8 | 33.1 | 34.0 | 34.9 | 35.8 |
WACC, % | 6.2 | 5.68 | 5.89 | 6.82 | 3.92 | 5.7 | 5.7 | 5.7 | 5.7 | 5.7 |
PV UFCF | ||||||||||
SUM PV UFCF | 155.8 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 37 | |||||||||
Terminal Value | 1,363 | |||||||||
Present Terminal Value | 1,033 | |||||||||
Enterprise Value | 1,189 | |||||||||
Net Debt | 302 | |||||||||
Equity Value | 887 | |||||||||
Diluted Shares Outstanding, MM | 41 | |||||||||
Equity Value Per Share | 21.75 |
What You Will Get
- Editable Forecast Inputs: Easily modify key assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Varex Imaging Corporation’s (VREX) financial data pre-loaded to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically for you.
- Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Customizable Financial Inputs: Adjust essential parameters such as revenue projections, operating margins, and capital investments.
- Instant DCF Valuation: Provides immediate calculations of intrinsic value, NPV, and other financial metrics.
- High-Precision Accuracy: Leverages Varex Imaging’s actual financial data for credible valuation results.
- Effortless Scenario Analysis: Easily explore various assumptions and assess different outcomes.
- Efficiency Booster: Streamline the valuation process without the hassle of creating intricate models from the ground up.
How It Works
- Step 1: Download the prebuilt Excel template featuring Varex Imaging Corporation’s (VREX) 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 see the recalculated results, including Varex Imaging Corporation’s (VREX) intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose This Calculator for Varex Imaging Corporation (VREX)?
- Precise Financials: Up-to-date Varex Imaging financial data guarantees trustworthy valuation outcomes.
- Fully Customizable: Tailor essential inputs such as growth rates, WACC, and tax rates to align with your forecasts.
- Efficient: Built-in calculations save you time by eliminating the need to start from the ground up.
- Expert-Level Tool: Crafted for investors, analysts, and financial consultants.
- Easy to Use: User-friendly design and clear instructions make it accessible for everyone.
Who Should Use This Product?
- Investors: Evaluate Varex Imaging Corporation’s (VREX) valuation before making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts.
- Startup Founders: Understand the valuation processes of established companies like Varex Imaging.
- Consultants: Provide comprehensive valuation reports for their clientele.
- Students and Educators: Utilize current data to practice and teach valuation strategies.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Varex Imaging Corporation (VREX) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Varex Imaging Corporation (VREX).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.