Lake Shore Bancorp, Inc. (LSBK) DCF Valuation

Lake Shore Bancorp, Inc. (LSBK) 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

Lake Shore Bancorp, Inc. (LSBK) 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:

Gain mastery over your Lake Shore Bancorp, Inc. (LSBK) valuation analysis with our sophisticated DCF Calculator! Preloaded with real (LSBK) data, this Excel template enables you to adjust forecasts and assumptions to accurately determine the intrinsic value of Lake Shore Bancorp, Inc.


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 21.6 22.9 25.2 27.0 28.0 29.9 32.0 34.2 36.5 39.0
Revenue Growth, % 0 6.32 9.85 7.39 3.67 6.81 6.81 6.81 6.81 6.81
EBITDA 5.6 6.2 8.3 7.7 7.0 8.4 8.9 9.5 10.2 10.9
EBITDA, % 25.74 27.14 33.12 28.57 25.06 27.93 27.93 27.93 27.93 27.93
Depreciation .8 .8 .9 .9 .8 1.0 1.1 1.2 1.2 1.3
Depreciation, % 3.75 3.66 3.43 3.17 2.88 3.38 3.38 3.38 3.38 3.38
EBIT 4.7 5.4 7.5 6.9 6.2 7.4 7.9 8.4 9.0 9.6
EBIT, % 21.99 23.48 29.68 25.4 22.18 24.55 24.55 24.55 24.55 24.55
Total Cash 101.5 122.3 156.8 9.6 53.7 26.1 27.9 29.8 31.8 34.0
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 2.2 3.0 2.5 .0 .0
Account Receivables, % 9.99 13.03 9.86 0 0
Inventories -33.2 -46.0 -70.2 60.5 .0 -12.0 -12.8 -13.7 -14.6 -15.6
Inventories, % -154.07 -200.75 -278.73 223.77 0 -40 -40 -40 -40 -40
Accounts Payable .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Accounts Payable, % 0.000004637789 0 0 0 0.000003566843 0.000001640926 0.000001640926 0.000001640926 0.000001640926 0.000001640926
Capital Expenditure -.8 -.4 -.6 -.4 -.4 -.7 -.7 -.7 -.8 -.8
Capital Expenditure, % -3.76 -1.74 -2.49 -1.5 -1.39 -2.18 -2.18 -2.18 -2.18 -2.18
Tax Rate, % 22.5 22.5 22.5 22.5 22.5 22.5 22.5 22.5 22.5 22.5
EBITAT 4.1 4.6 6.2 5.7 4.8 6.1 6.5 6.9 7.4 7.9
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 35.2 17.0 31.1 -122.1 65.8 16.5 7.6 8.1 8.6 9.2
WACC, % 11.92 11.8 11.64 11.66 11.2 11.64 11.64 11.64 11.64 11.64
PV UFCF
SUM PV UFCF 37.5
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 9
Terminal Value 98
Present Terminal Value 56
Enterprise Value 94
Net Debt -18
Equity Value 112
Diluted Shares Outstanding, MM 6
Equity Value Per Share 19.17

What You Will Get

  • Real LSBK 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 in real-time.
  • Scenario Analysis: Evaluate various scenarios to assess Lake Shore Bancorp’s future performance.
  • User-Friendly Design: Tailored for professionals while remaining accessible for newcomers.

Key Features

  • Comprehensive Financial Data: Lake Shore Bancorp, Inc.'s historical financial statements and pre-filled projections.
  • Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
  • Real-Time Valuation: Instantly view Lake Shore Bancorp, Inc.'s intrinsic value as it updates live.
  • Intuitive Visualizations: Dashboard charts clearly present valuation results and essential metrics.
  • Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.

How It Works

  1. Download the Template: Gain immediate access to the Excel-based LSBK 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 Lake Shore Bancorp's intrinsic value.
  4. Test Scenarios: Experiment with various assumptions to assess potential valuation shifts.
  5. Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.

Why Choose This Calculator for Lake Shore Bancorp, Inc. (LSBK)?

  • User-Friendly Interface: Crafted for both novices and seasoned professionals.
  • Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
  • Real-Time Valuation: Observe immediate updates to Lake Shore Bancorp’s valuation as you change inputs.
  • Preloaded Data: Comes with Lake Shore Bancorp’s actual financial metrics for swift evaluation.
  • Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.

Who Should Use Lake Shore Bancorp, Inc. (LSBK)?

  • Finance Students: Explore banking fundamentals and apply them using real-world financial data.
  • Academics: Integrate industry-specific models into your curriculum or research projects.
  • Investors: Evaluate your investment strategies and assess the financial health of Lake Shore Bancorp, Inc. (LSBK).
  • Analysts: Enhance your analysis with a customizable financial model tailored for banking institutions.
  • Small Business Owners: Understand the financial metrics that drive the performance of publicly traded banks like Lake Shore Bancorp, Inc. (LSBK).

What the Template Contains

  • Pre-Filled Data: Includes Lake Shore Bancorp, Inc.'s (LSBK) 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 Lake Shore Bancorp, Inc.'s (LSBK) 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.