|
Rex American Resources Corporation (REX) DCF Valoración
US | Basic Materials | Chemicals - Specialty | NYSE
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
REX American Resources Corporation (REX) Bundle
¡Simplifique la valoración de Rex American Resources Corporation (REX) con esta calculadora DCF personalizable! Con Real Rex Financials y Entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Rex en minutos.
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 | 418.0 | 372.8 | 774.8 | 855.0 | 833.4 | 1,035.5 | 1,286.7 | 1,598.7 | 1,986.4 | 2,468.2 |
Revenue Growth, % | 0 | -10.81 | 107.81 | 10.35 | -2.53 | 24.25 | 24.25 | 24.25 | 24.25 | 24.25 |
EBITDA | 21.1 | 25.4 | 92.7 | 49.1 | 91.9 | 84.0 | 104.4 | 129.7 | 161.2 | 200.3 |
EBITDA, % | 5.04 | 6.8 | 11.96 | 5.74 | 11.02 | 8.11 | 8.11 | 8.11 | 8.11 | 8.11 |
Depreciation | 29.3 | 23.5 | 23.6 | 23.3 | 23.0 | 45.2 | 56.2 | 69.8 | 86.8 | 107.8 |
Depreciation, % | 7.01 | 6.3 | 3.04 | 2.73 | 2.76 | 4.37 | 4.37 | 4.37 | 4.37 | 4.37 |
EBIT | -8.2 | 1.9 | 69.1 | 25.8 | 68.8 | 38.8 | 48.2 | 59.9 | 74.4 | 92.5 |
EBIT, % | -1.97 | 0.50798 | 8.92 | 3.01 | 8.26 | 3.75 | 3.75 | 3.75 | 3.75 | 3.75 |
Total Cash | 205.7 | 180.7 | 255.7 | 280.9 | 378.7 | 432.8 | 537.8 | 668.2 | 830.2 | 1,031.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 19.0 | 25.7 | 32.5 | 28.1 | 28.9 | 46.4 | 57.6 | 71.6 | 89.0 | 110.6 |
Account Receivables, % | 4.54 | 6.9 | 4.19 | 3.29 | 3.47 | 4.48 | 4.48 | 4.48 | 4.48 | 4.48 |
Inventories | 35.6 | 37.9 | 42.2 | 48.7 | 27.0 | 68.5 | 85.1 | 105.7 | 131.4 | 163.3 |
Inventories, % | 8.52 | 10.16 | 5.45 | 5.7 | 3.24 | 6.61 | 6.61 | 6.61 | 6.61 | 6.61 |
Accounts Payable | 18.9 | 16.6 | 32.3 | 34.1 | 42.1 | 45.9 | 57.0 | 70.9 | 88.1 | 109.4 |
Accounts Payable, % | 4.52 | 4.44 | 4.16 | 3.99 | 5.05 | 4.43 | 4.43 | 4.43 | 4.43 | 4.43 |
Capital Expenditure | -3.8 | -10.4 | -5.1 | -15.6 | -37.7 | -22.2 | -27.5 | -34.2 | -42.5 | -52.8 |
Capital Expenditure, % | -0.90328 | -2.79 | -0.66159 | -1.82 | -4.52 | -2.14 | -2.14 | -2.14 | -2.14 | -2.14 |
Tax Rate, % | 38.13 | 38.13 | 38.13 | 38.13 | 38.13 | 38.13 | 38.13 | 38.13 | 38.13 | 38.13 |
EBITAT | 81.9 | -7.2 | 47.7 | 20.6 | 42.6 | 16.4 | 20.3 | 25.3 | 31.4 | 39.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 71.7 | -5.4 | 70.7 | 28.0 | 56.9 | -15.7 | 32.3 | 40.1 | 49.8 | 61.9 |
WACC, % | 8.72 | 8.72 | 8.78 | 8.79 | 8.77 | 8.76 | 8.76 | 8.76 | 8.76 | 8.76 |
PV UFCF | ||||||||||
SUM PV UFCF | 120.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 63 | |||||||||
Terminal Value | 935 | |||||||||
Present Terminal Value | 614 | |||||||||
Enterprise Value | 735 | |||||||||
Net Debt | -211 | |||||||||
Equity Value | 945 | |||||||||
Diluted Shares Outstanding, MM | 18 | |||||||||
Equity Value Per Share | 53.77 |
What You Will Receive
- Pre-Filled Financial Model: REX American Resources Corporation’s actual data enables accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, margins, WACC, and other essential drivers.
- Real-Time Calculations: Automatic updates allow you to view results instantly as you make adjustments.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation.
- Flexible and Reusable: Designed for adaptability, allowing continuous use for in-depth forecasts.
Key Features
- Real-Life REX Data: Pre-filled with REX American Resources Corporation's historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth rates, profit margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Testing: Develop various forecast scenarios to evaluate different valuation results.
- User-Friendly Design: Intuitive layout, structured for both professionals and newcomers.
How It Works
- Step 1: Download the prebuilt Excel template featuring REX American Resources Corporation’s (REX) data.
- Step 2: Navigate through 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 REX’s intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose the REX Calculator?
- Accuracy: Utilizes authentic REX financials for precise data.
- Flexibility: Tailored for users to easily experiment with and adjust inputs.
- Time-Saving: Eliminate the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without advanced financial modeling skills.
Who Should Use This Product?
- Investors: Evaluate REX American Resources Corporation’s valuation before making stock transactions.
- CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts.
- Startup Founders: Discover how established companies like REX are appraised in the market.
- Consultants: Provide detailed valuation analyses and reports for clients regarding REX.
- Students and Educators: Utilize actual market data to teach and learn valuation strategies.
What the Template Contains
- Pre-Filled Data: Includes REX American Resources Corporation's (REX) 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 REX's profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.