Oconee Federal Financial Corp. (OFED) DCF Valuation

Oconee Federal Financial Corp. (OFED) 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

Oconee Federal Financial Corp. (OFED) 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:

Reveal the true potential of Oconee Federal Financial Corp. (OFED) with our advanced DCF Calculator! Adjust key assumptions, explore various scenarios, and assess how changes affect Oconee Federal Financial Corp. (OFED) valuation – all within one comprehensive Excel template.


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 16.6 16.5 16.6 21.0 30.7 36.2 42.8 50.5 59.6 70.4
Revenue Growth, % 0 -0.46346 0.45958 26.12 46.3 18.1 18.1 18.1 18.1 18.1
EBITDA 6.5 7.0 6.7 4.8 7.2 12.2 14.4 17.0 20.1 23.8
EBITDA, % 39 42.58 40.43 22.99 23.64 33.73 33.73 33.73 33.73 33.73
Depreciation .7 .7 .7 .6 .6 1.3 1.5 1.8 2.1 2.4
Depreciation, % 4.27 4.41 4.01 2.84 1.8 3.47 3.47 3.47 3.47 3.47
EBIT 5.8 6.3 6.1 4.2 6.7 11.0 12.9 15.3 18.0 21.3
EBIT, % 34.73 38.17 36.42 20.15 21.84 30.26 30.26 30.26 30.26 30.26
Total Cash 125.2 169.7 161.0 -4.7 .0 20.1 23.8 28.1 33.1 39.1
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables .0 .0 1.4 .0 .0
Account Receivables, % 0 0 8.5 0 0
Inventories -36.2 -32.0 .0 .0 .0 -14.5 -17.1 -20.2 -23.9 -28.2
Inventories, % -217.76 -193.66 0 0 0 -40 -40 -40 -40 -40
Accounts Payable 1.2 .7 .9 .0 .0 1.2 1.4 1.7 2.0 2.3
Accounts Payable, % 7.13 4.15 5.13 0 0 3.28 3.28 3.28 3.28 3.28
Capital Expenditure -1.8 -.3 -.2 -.4 -.1 -1.2 -1.4 -1.6 -1.9 -2.3
Capital Expenditure, % -11.12 -1.56 -1.29 -1.79 -0.29688 -3.21 -3.21 -3.21 -3.21 -3.21
Tax Rate, % 6.63 6.63 6.63 6.63 6.63 6.63 6.63 6.63 6.63 6.63
EBITAT 4.7 5.0 4.9 3.3 6.3 9.1 10.7 12.6 14.9 17.6
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 40.9 .8 -27.9 4.1 6.7 24.2 13.5 16.0 18.9 22.3
WACC, % 4.88 4.84 4.87 4.84 5.14 4.92 4.92 4.92 4.92 4.92
PV UFCF
SUM PV UFCF 82.4
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 23
Terminal Value 780
Present Terminal Value 614
Enterprise Value 696
Net Debt 56
Equity Value 640
Diluted Shares Outstanding, MM 6
Equity Value Per Share 112.36

What You Will Receive

  • Comprehensive Financial Model: Oconee Federal Financial Corp.'s actual data facilitates accurate DCF valuation.
  • Complete Forecast Control: Modify revenue growth, profit margins, WACC, and other critical factors.
  • Real-Time Calculations: Automatic updates provide immediate feedback as you adjust inputs.
  • Professional-Grade Template: An expertly crafted Excel file ready for investor presentations.
  • Flexible and Reusable: Designed for adaptability, allowing for repeated application in detailed forecasting.

Key Features

  • Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Oconee Federal Financial Corp. (OFED).
  • WACC Calculator: Ready-to-use Weighted Average Cost of Capital sheet with adjustable inputs specific to OFED.
  • Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to suit your analysis of OFED.
  • Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Oconee Federal Financial Corp. (OFED).
  • User-Friendly Dashboard and Charts: Visual representations summarize key valuation metrics for straightforward analysis of OFED.

How It Works

  • Step 1: Download the prebuilt Excel template featuring Oconee Federal Financial Corp.'s (OFED) 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 view the updated results, including Oconee Federal Financial Corp.'s (OFED) intrinsic value.
  • Step 5: Make well-informed investment decisions or create reports based on the generated outputs.

Why Choose This Calculator for Oconee Federal Financial Corp. (OFED)?

  • Accurate Data: Utilize real financials from Oconee Federal for trustworthy valuation outcomes.
  • Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
  • Time-Saving: Built-in calculations streamline your process, eliminating the need to start from scratch.
  • Professional-Grade Tool: Crafted for investors, analysts, and financial consultants.
  • User-Friendly: Designed with an intuitive interface and clear instructions for ease of use by all.

Who Should Use Oconee Federal Financial Corp. (OFED)?

  • Institutional Investors: Develop comprehensive valuation models for assessing investment opportunities in OFED.
  • Financial Analysts: Evaluate financial performance and forecast future growth for informed decision-making.
  • Advisors and Consultants: Deliver precise valuation assessments and insights for clients interested in OFED.
  • Students and Academics: Utilize practical data to enhance learning and teaching in finance and investment courses.
  • Community Bank Supporters: Gain insights into the valuation of local financial institutions like Oconee Federal.

What the Template Contains

  • Pre-Filled Data: Includes Oconee Federal Financial 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 Oconee Federal Financial 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.