RGC Resources, Inc. (RGCO) DCF Valuation

RGC Resources, Inc. (RGCO) DCF Valuation
  • ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
  • ✓ Professional Design: Trusted, Industry-Standard Templates
  • ✓ Pre-Built For Quick And Efficient Use
  • ✓ No Expertise Is Needed; Easy To Follow

RGC Resources, Inc. (RGCO) 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:

As an investor or analyst, the DCF Calculator for RGC Resources, Inc. (RGCO) is your go-to resource for accurate valuation. With real data from RGC Resources, Inc. preloaded, you can easily adjust forecasts and observe the effects in real-time.


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 68.6 75.2 84.2 97.4 84.6 89.8 95.2 100.9 107.0 113.5
Revenue Growth, % 0 9.55 11.96 15.77 -13.13 6.04 6.04 6.04 6.04 6.04
EBITDA 20.7 24.0 -29.5 30.4 27.0 16.2 17.2 18.2 19.3 20.5
EBITDA, % 30.23 31.92 -35.01 31.2 31.85 18.04 18.04 18.04 18.04 18.04
Depreciation 8.1 8.7 9.2 10.0 10.5 10.2 10.8 11.5 12.2 12.9
Depreciation, % 11.84 11.53 10.91 10.26 12.43 11.39 11.39 11.39 11.39 11.39
EBIT 12.6 15.3 -38.6 20.4 16.4 6.0 6.3 6.7 7.1 7.5
EBIT, % 18.39 20.39 -45.92 20.95 19.42 6.65 6.65 6.65 6.65 6.65
Total Cash .3 1.5 4.9 1.5 1.8 2.1 2.3 2.4 2.5 2.7
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 3.4 4.9 5.4 4.2 4.5
Account Receivables, % 4.96 6.58 6.36 4.31 5.3
Inventories 6.7 8.9 18.1 12.9 10.3 12.3 13.1 13.8 14.7 15.6
Inventories, % 9.82 11.84 21.56 13.2 12.16 13.71 13.71 13.71 13.71 13.71
Accounts Payable 4.4 7.7 8.6 5.8 5.4 7.1 7.5 7.9 8.4 8.9
Accounts Payable, % 6.47 10.28 10.22 5.99 6.41 7.88 7.88 7.88 7.88 7.88
Capital Expenditure -22.9 -20.0 -25.5 -25.3 -22.1 -25.5 -27.1 -28.7 -30.4 -32.3
Capital Expenditure, % -33.39 -26.56 -30.25 -25.97 -26.1 -28.46 -28.46 -28.46 -28.46 -28.46
Tax Rate, % 23.91 23.91 23.91 23.91 23.91 23.91 23.91 23.91 23.91 23.91
EBITAT 9.5 11.6 -28.4 15.6 12.5 4.5 4.8 5.1 5.4 5.7
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -11.0 -.1 -53.5 4.0 2.8 -11.6 -12.1 -12.8 -13.6 -14.4
WACC, % 4.52 4.53 4.49 4.54 4.54 4.52 4.52 4.52 4.52 4.52
PV UFCF
SUM PV UFCF -56.3
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) -15
Terminal Value -582
Present Terminal Value -467
Enterprise Value -523
Net Debt 148
Equity Value -671
Diluted Shares Outstanding, MM 10
Equity Value Per Share -66.04

What You Will Get

  • Pre-Filled Financial Model: RGC Resources, Inc.'s (RGCO) actual data allows for accurate DCF valuation.
  • Full Forecast Control: Modify revenue growth, profit margins, WACC, and other essential factors.
  • Instant Calculations: Real-time updates ensure you see the impact of your adjustments immediately.
  • Investor-Ready Template: A polished Excel file crafted for high-quality valuation presentations.
  • Customizable and Reusable: Designed for adaptability, enabling multiple uses for comprehensive forecasts.

Key Features

  • 🔍 Real-Life RGCO Financials: Pre-filled historical and projected data for RGC Resources, Inc. (RGCO).
  • ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
  • 📊 Professional DCF Valuation: Built-in formulas calculate RGC Resources’ intrinsic value using the Discounted Cash Flow method.
  • ⚡ Instant Results: Visualize RGC Resources’ valuation instantly after making changes.
  • Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.

How It Works

  • Download: Obtain the pre-prepared Excel file containing RGC Resources, Inc. (RGCO) financial data.
  • Customize: Modify forecasts, including revenue growth, EBITDA %, and WACC as needed.
  • Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
  • Test Scenarios: Generate various projections and analyze results immediately.
  • Make Decisions: Utilize the valuation outcomes to inform your investment choices.

Why Choose RGC Resources, Inc. (RGCO) Calculator?

  • Save Time: Skip the hassle of building a financial model from the ground up – our tool is ready to go.
  • Enhance Accuracy: Dependable financial metrics and formulas help minimize valuation errors.
  • Completely Customizable: Adjust the model to align with your unique assumptions and forecasts.
  • User-Friendly Interface: Intuitive graphs and outputs simplify result interpretation.
  • Endorsed by Professionals: Crafted for industry experts who prioritize accuracy and functionality.

Who Should Use This Product?

  • Investors: Develop comprehensive and accurate valuation models for evaluating RGC Resources, Inc. (RGCO).
  • Corporate Finance Departments: Assess valuation scenarios to inform strategic decisions within the organization.
  • Consultants and Financial Advisors: Deliver precise valuation analyses to clients interested in RGC Resources, Inc. (RGCO).
  • Students and Instructors: Utilize real-life financial data to enhance learning and practice in financial modeling.
  • Energy Sector Enthusiasts: Gain insights into how utility companies like RGC Resources, Inc. (RGCO) are valued in the market.

What the Template Contains

  • Pre-Filled DCF Model: RGC Resources, Inc.'s (RGCO) financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital specific to RGC Resources, Inc. (RGCO).
  • Financial Ratios: Evaluate RGC Resources, Inc.'s (RGCO) profitability, leverage, and efficiency metrics.
  • Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios for RGC Resources, Inc. (RGCO).
  • Financial Statements: Annual and quarterly reports for RGC Resources, Inc. (RGCO) to support detailed analysis.
  • Interactive Dashboard: Easily visualize key valuation metrics and results for RGC Resources, Inc. (RGCO).

Es wurden keine passenden Produkte gefunden.