U.S. Energy Corp. (USEG) DCF Valuation

U.S. Energy Corp. (USEG) 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

U.S. Energy Corp. (USEG) 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:

Looking to determine the intrinsic value of U.S. Energy Corp.? Our USEG DCF Calculator integrates real-world data with extensive customization features, enabling you to refine your forecasts and enhance your investment choices.


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 6.6 2.3 6.7 44.6 32.3 41.0 52.1 66.2 84.1 106.7
Revenue Growth, % 0 -64.55 185.75 569.15 -27.46 27 27 27 27 27
EBITDA .0 -2.0 -1.0 7.5 -20.7 -12.1 -15.3 -19.5 -24.7 -31.4
EBITDA, % -0.09128252 -84.12 -15.53 16.83 -64.13 -29.41 -29.41 -29.41 -29.41 -29.41
Depreciation .8 .5 .7 9.8 11.4 8.4 10.7 13.6 17.2 21.9
Depreciation, % 12.6 22.32 10.2 22.02 35.31 20.49 20.49 20.49 20.49 20.49
EBIT -.8 -2.5 -1.7 -2.3 -32.1 -19.9 -25.3 -32.2 -40.9 -51.9
EBIT, % -12.69 -106.44 -25.73 -5.19 -99.43 -48.61 -48.61 -48.61 -48.61 -48.61
Total Cash 1.8 3.0 4.6 4.5 3.5 17.9 22.8 28.9 36.7 46.6
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables .7 .5 .9 3.6 2.7
Account Receivables, % 10.89 22.06 14.01 8.02 8.47
Inventories .0 1.0 .3 .3 .0 3.8 4.8 6.1 7.8 9.9
Inventories, % 0 41.85 3.75 0.70255 0 9.26 9.26 9.26 9.26 9.26
Accounts Payable 1.0 1.5 .9 2.6 1.9 8.4 10.7 13.6 17.2 21.9
Accounts Payable, % 14.82 62.53 13.38 5.76 6.02 20.5 20.5 20.5 20.5 20.5
Capital Expenditure -.4 -1.2 -1.6 -19.3 -3.9 -11.1 -14.1 -17.9 -22.8 -28.9
Capital Expenditure, % -5.72 -50.39 -24.09 -43.28 -11.97 -27.09 -27.09 -27.09 -27.09 -27.09
Tax Rate, % 2.68 2.68 2.68 2.68 2.68 2.68 2.68 2.68 2.68 2.68
EBITAT -.4 -2.5 -2.1 -.8 -31.3 -15.1 -19.2 -24.4 -31.0 -39.3
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF .3 -3.4 -3.3 -11.3 -23.2 -17.6 -22.8 -28.9 -36.8 -46.7
WACC, % 7.01 8.22 8.24 6.66 8.17 7.66 7.66 7.66 7.66 7.66
PV UFCF
SUM PV UFCF -118.9
Long Term Growth Rate, % 1.00
Free cash flow (T + 1) -47
Terminal Value -708
Present Terminal Value -490
Enterprise Value -609
Net Debt 2
Equity Value -611
Diluted Shares Outstanding, MM 25
Equity Value Per Share -24.13

What You Will Get

  • Real USEG 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 computed automatically.
  • Scenario Analysis: Evaluate various scenarios to assess U.S. Energy Corp.'s future performance.
  • User-Friendly Design: Designed for professionals but easy to navigate for newcomers.

Key Features

  • Customizable Energy Metrics: Adjust essential inputs like production levels, operating costs, and capital expenditures.
  • Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial metrics.
  • Industry-Leading Precision: Leverages U.S. Energy Corp.'s (USEG) actual financial data for accurate valuation results.
  • Effortless Scenario Analysis: Explore various assumptions and assess results effortlessly.
  • Efficiency Booster: Avoid the complexities of creating detailed valuation models from the ground up.

How It Works

  1. Download the Template: Gain immediate access to the Excel-based USEG DCF Calculator.
  2. Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
  3. Instant Calculations: The model automatically recalculates U.S. Energy Corp.'s intrinsic value.
  4. Test Scenarios: Experiment with different assumptions to assess potential changes in valuation.
  5. Analyze and Decide: Leverage the results to inform your investment or financial analysis.

Why Choose This Calculator for U.S. Energy Corp. (USEG)?

  • User-Friendly Interface: Perfectly crafted for both novices and seasoned professionals.
  • Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
  • Real-Time Feedback: Instantly observe changes in U.S. Energy Corp.'s (USEG) valuation as you modify inputs.
  • Pre-Configured: Comes with U.S. Energy Corp.'s (USEG) actual financial metrics for quick evaluations.
  • Relied Upon by Experts: A go-to tool for investors and analysts to enhance decision-making.

Who Should Use This Product?

  • Individual Investors: Make informed decisions about buying or selling U.S. Energy Corp. (USEG) stock.
  • Financial Analysts: Streamline valuation processes with ready-to-use financial models for U.S. Energy Corp. (USEG).
  • Consultants: Deliver professional valuation insights for U.S. Energy Corp. (USEG) to clients quickly and accurately.
  • Business Owners: Understand how energy companies like U.S. Energy Corp. (USEG) are valued to guide your own strategy.
  • Finance Students: Learn valuation techniques using real-world data and scenarios related to U.S. Energy Corp. (USEG).

What the Template Contains

  • Pre-Filled Data: Includes U.S. Energy Corp.'s 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 U.S. Energy Corp.'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.