Hingham Institution for Savings (HIFS) DCF Valuation

Hingham Institution for Savings (HIFS) 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

Hingham Institution for Savings (HIFS) 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:

Discover the true value of Hingham Institution for Savings (HIFS) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and assess how changes affect HIFS valuation – all within a single Excel template.


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 74.2 92.1 114.7 80.9 63.5 63.1 62.8 62.4 62.1 61.7
Revenue Growth, % 0 24.2 24.58 -29.49 -21.53 -0.56184 -0.56184 -0.56184 -0.56184 -0.56184
EBITDA 54.2 70.8 93.2 54.8 35.9 44.9 44.6 44.4 44.1 43.9
EBITDA, % 73.08 76.9 81.23 67.74 56.57 71.11 71.11 71.11 71.11 71.11
Depreciation .7 .7 .5 .5 .7 .5 .5 .5 .5 .5
Depreciation, % 0.87914 0.76323 0.47322 0.61058 1.08 0.76103 0.76103 0.76103 0.76103 0.76103
EBIT 53.5 70.1 92.7 54.3 35.2 44.4 44.2 43.9 43.7 43.4
EBIT, % 72.2 76.14 80.76 67.13 55.49 70.35 70.35 70.35 70.35 70.35
Total Cash 252.2 234.0 271.2 362.0 5.7 51.6 51.3 51.1 50.8 50.5
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 4.9 5.3 .0 .0 8.6
Account Receivables, % 6.64 5.72 0 0 13.47
Inventories -257.1 -243.1 -276.6 -369.2 .0 -50.5 -50.2 -49.9 -49.7 -49.4
Inventories, % -346.63 -263.91 -241.08 -456.27 0 -80 -80 -80 -80 -80
Accounts Payable 1.0 .3 .2 4.5 12.3 3.4 3.3 3.3 3.3 3.3
Accounts Payable, % 1.29 0.27359 0.17256 5.6 19.31 5.33 5.33 5.33 5.33 5.33
Capital Expenditure -.6 -1.5 -1.6 -2.5 -1.3 -1.1 -1.1 -1.1 -1.1 -1.1
Capital Expenditure, % -0.8724 -1.66 -1.39 -3.12 -2.05 -1.82 -1.82 -1.82 -1.82 -1.82
Tax Rate, % 25.15 25.15 25.15 25.15 25.15 25.15 25.15 25.15 25.15 25.15
EBITAT 38.9 50.8 67.5 37.5 26.4 32.1 32.0 31.8 31.6 31.4
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 292.0 34.9 105.2 132.3 -344.2 78.4 31.0 30.8 30.7 30.5
WACC, % 6.32 6.31 6.33 6.12 6.45 6.31 6.31 6.31 6.31 6.31
PV UFCF
SUM PV UFCF 173.3
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 31
Terminal Value 722
Present Terminal Value 532
Enterprise Value 705
Net Debt 1,330
Equity Value -625
Diluted Shares Outstanding, MM 2
Equity Value Per Share -284.97

What You Will Gain

  • Comprehensive Financial Model: HIFS’s actual data facilitates accurate DCF valuation.
  • Complete Forecast Management: Modify revenue growth, profit margins, WACC, and other essential factors.
  • Real-Time Calculations: Automatic updates allow you to see results instantly as you make adjustments.
  • Professional-Grade Template: A polished Excel file crafted for high-quality valuation.
  • Flexible and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasts.

Key Features

  • Comprehensive Financial Data: Hingham Institution for Savings’ (HIFS) historical financial statements and pre-filled projections.
  • Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
  • Real-Time Valuation: Observe HIFS’ intrinsic value recalculating instantly.
  • Intuitive Visualizations: Dashboard graphs showcase valuation outcomes and essential metrics.
  • Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.

How It Works

  1. Step 1: Download the Excel file for Hingham Institution for Savings (HIFS).
  2. Step 2: Review HIFS's pre-filled financial data and projections.
  3. Step 3: Adjust key inputs such as loan growth, interest rates, and operating expenses (highlighted cells).
  4. Step 4: Observe the DCF model update in real-time as you modify your assumptions.
  5. Step 5: Evaluate the outputs and leverage the results for your investment strategies.

Why Choose HIFS Calculator?

  • User-Friendly Interface: Perfect for both novices and seasoned professionals.
  • Customizable Inputs: Adjust parameters to suit your specific financial analysis.
  • Real-Time Adjustments: Observe immediate changes to Hingham Institution for Savings’ (HIFS) valuation as you modify inputs.
  • Preloaded Data: Comes with HIFS’s actual financial information for swift evaluations.
  • Relied Upon by Experts: A go-to tool for investors and analysts making strategic decisions.

Who Should Use This Product?

  • Investors: Evaluate Hingham Institution for Savings’ (HIFS) performance before making investment decisions.
  • CFOs and Financial Analysts: Optimize financial assessments and validate forecasts for HIFS.
  • Banking Professionals: Understand the valuation metrics of community banks like HIFS.
  • Consultants: Provide detailed valuation analyses and reports tailored to client needs regarding HIFS.
  • Students and Educators: Utilize HIFS data to enhance learning and practice valuation methodologies.

What the Template Contains

  • Pre-Filled Data: Contains Hingham Institution for Savings’ (HIFS) historical financials and projections.
  • Discounted Cash Flow Model: Fully editable DCF valuation model featuring automatic calculations.
  • Weighted Average Cost of Capital (WACC): A dedicated worksheet for calculating WACC using custom inputs.
  • Key Financial Ratios: Evaluate Hingham Institution for Savings’ (HIFS) profitability, efficiency, and leverage metrics.
  • Customizable Inputs: Easily modify revenue growth rates, profit margins, and tax rates.
  • Clear Dashboard: Visual representations and tables summarizing essential valuation outcomes.

No products were found matching.