MidWestOne Financial Group, Inc. (MOFG) DCF Valuation

MidWestOne Financial Group, Inc. (MOFG) DCF Valuation

US | Financial Services | Banks - Regional | NASDAQ
MidWestOne Financial Group, Inc. (MOFG) 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

MidWestOne Financial Group, Inc. (MOFG) Bundle

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

TOTAL:

Engineered for accuracy, our (MOFG) DCF Calculator enables you to evaluate MidWestOne Financial Group, Inc. valuation using real-world financial data and the complete flexibility to modify all essential parameters for enhanced projections.


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 174.9 191.6 198.7 213.9 162.6 161.3 160.1 158.9 157.6 156.4
Revenue Growth, % 0 9.54 3.73 7.62 -23.98 -0.77097 -0.77097 -0.77097 -0.77097 -0.77097
EBITDA 53.0 17.9 91.0 86.8 .0 40.7 40.3 40.0 39.7 39.4
EBITDA, % 30.28 9.33 45.81 40.56 0 25.2 25.2 25.2 25.2 25.2
Depreciation 10.8 12.1 10.2 11.2 .0 7.4 7.3 7.2 7.2 7.1
Depreciation, % 6.18 6.3 5.11 5.22 0 4.56 4.56 4.56 4.56 4.56
EBIT 42.2 5.8 80.9 75.6 .0 33.3 33.0 32.8 32.5 32.3
EBIT, % 24.1 3.03 40.7 35.34 0 20.63 20.63 20.63 20.63 20.63
Total Cash 859.3 1,739.9 2,491.9 1,240.0 871.4 161.3 160.1 158.9 157.6 156.4
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 35.3 .0 32.8 43.1 .0
Account Receivables, % 20.19 0 16.53 20.15 0
Inventories -98.6 -106.7 -224.5 -116.0 .0 -85.9 -85.3 -84.6 -84.0 -83.3
Inventories, % -56.38 -55.68 -112.96 -54.23 0 -53.26 -53.26 -53.26 -53.26 -53.26
Accounts Payable .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Accounts Payable, % 0 0 0 0 0 0 0 0 0 0
Capital Expenditure -2.2 -2.1 -2.0 -2.7 -4.1 -2.3 -2.3 -2.3 -2.2 -2.2
Capital Expenditure, % -1.25 -1.11 -1.01 -1.25 -2.49 -1.42 -1.42 -1.42 -1.42 -1.42
Tax Rate, % 16 16 16 16 16 16 16 16 16 16
EBITAT 36.6 2.9 62.8 60.0 .0 25.1 25.0 24.8 24.6 24.4
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 108.5 56.2 155.9 -50.2 -77.0 97.8 29.5 29.2 29.0 28.8
WACC, % 15.15 10.71 14.05 14.26 14.8 13.79 13.79 13.79 13.79 13.79
PV UFCF
SUM PV UFCF 160.9
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 29
Terminal Value 249
Present Terminal Value 130
Enterprise Value 291
Net Debt 342
Equity Value -50
Diluted Shares Outstanding, MM 16
Equity Value Per Share -3.21

What You Will Get

  • Real MidWestOne Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
  • Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
  • Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on MidWestOne’s fair value.
  • Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
  • Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.

Key Features

  • Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for MidWestOne Financial Group, Inc. (MOFG).
  • WACC Calculator: Ready-to-use Weighted Average Cost of Capital sheet with adjustable inputs specific to MOFG.
  • Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates as per your analysis needs.
  • Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to MidWestOne Financial Group, Inc. (MOFG).
  • Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered MidWestOne Financial Group data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for MidWestOne Financial Group’s intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose This Calculator for MidWestOne Financial Group, Inc. (MOFG)?

  • Accurate Data: Reliable financials from MidWestOne ensure trustworthy valuation outcomes.
  • Customizable: Tailor key inputs such as growth rates, WACC, and tax rates to fit your forecasts.
  • Time-Saving: Built-in calculations save you the effort of starting from the ground up.
  • Professional-Grade Tool: Crafted for investors, analysts, and financial consultants.
  • User-Friendly: Easy-to-navigate design and clear instructions cater to users of all experience levels.

Who Should Utilize MidWestOne Financial Group, Inc. (MOFG)?

  • Investors: Make informed decisions with a reliable financial services provider.
  • Financial Analysts: Streamline your analysis with comprehensive data and insights from MOFG.
  • Consultants: Easily tailor financial solutions for your clients using MOFG's offerings.
  • Finance Enthusiasts: Enhance your knowledge of banking and financial services through real-world applications.
  • Educators and Students: Leverage MOFG as a case study in finance and investment courses.

What the Template Contains

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

No products were found matching.