REX American Resources Corporation (REX) DCF Valuation

REX American Resources Corporation (REX) 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

REX American Resources Corporation (REX) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Simplify REX American Resources Corporation (REX) valuation with this customizable DCF Calculator! Featuring real REX financials and adjustable forecast inputs, you can test scenarios and uncover REX fair value in minutes.


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
Account Receivables, % 4.54 6.9 4.19 3.29 3.47
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.

No products were found matching.