Norwood Financial Corp. (NWFL) DCF Valuation

Norwood Financial Corp. (NWFL) DCF Valuation
  • ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
  • ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
  • ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
  • ✓ No Se Necesita Experiencia; Fáciles De Seguir

Norwood Financial Corp. (NWFL) 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:

Maximize efficiency and improve precision with our (NWFL) DCF Calculator! Utilizing authentic data from Norwood Financial Corp. and customizable assumptions, this tool empowers you to forecast, analyze, and evaluate (NWFL) like a seasoned investor.


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 45.4 58.3 73.6 78.3 64.6 71.7 79.5 88.2 97.8 108.5
Revenue Growth, % 0 28.36 26.4 6.37 -17.47 10.92 10.92 10.92 10.92 10.92
EBITDA 17.9 19.8 32.5 38.0 22.6 28.8 32.0 35.5 39.3 43.6
EBITDA, % 39.51 33.99 44.09 48.46 34.97 40.2 40.2 40.2 40.2 40.2
Depreciation 1.1 1.4 1.6 1.6 1.5 1.6 1.8 2.0 2.2 2.5
Depreciation, % 2.44 2.46 2.18 2.01 2.26 2.27 2.27 2.27 2.27 2.27
EBIT 16.8 18.4 30.9 36.4 21.1 27.2 30.2 33.5 37.1 41.2
EBIT, % 37.07 31.53 41.91 46.45 32.71 37.93 37.93 37.93 37.93 37.93
Total Cash 225.6 338.3 613.5 450.8 66.1 71.7 79.5 88.2 97.8 108.5
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables .0 6.2 5.9 6.9 .0
Account Receivables, % 0 10.7 8 8.83 0
Inventories -20.7 -118.9 -214.3 -39.1 .0 -42.4 -47.0 -52.1 -57.8 -64.1
Inventories, % -45.59 -204.08 -291.03 -49.95 0 -59.11 -59.11 -59.11 -59.11 -59.11
Accounts Payable 2.4 1.6 1.2 2.7 10.5 4.2 4.7 5.2 5.8 6.4
Accounts Payable, % 5.36 2.75 1.63 3.39 16.26 5.88 5.88 5.88 5.88 5.88
Capital Expenditure -1.6 -.7 -1.3 -2.2 -1.4 -1.6 -1.8 -2.0 -2.3 -2.5
Capital Expenditure, % -3.58 -1.29 -1.71 -2.75 -2.18 -2.3 -2.3 -2.3 -2.3 -2.3
Tax Rate, % 20.75 20.75 20.75 20.75 20.75 20.75 20.75 20.75 20.75 20.75
EBITAT 14.2 15.1 24.9 29.2 16.8 22.1 24.6 27.2 30.2 33.5
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 36.8 106.9 120.6 -146.1 -7.5 54.3 29.2 32.4 35.9 39.8
WACC, % 13.35 13.11 12.97 12.93 12.82 13.03 13.03 13.03 13.03 13.03
PV UFCF
SUM PV UFCF 136.8
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 41
Terminal Value 368
Present Terminal Value 200
Enterprise Value 336
Net Debt 48
Equity Value 288
Diluted Shares Outstanding, MM 8
Equity Value Per Share 35.65

What You Will Receive

  • Adjustable Forecast Parameters: Modify key assumptions (growth %, margins, WACC) to explore various scenarios.
  • Comprehensive Financial Data: Norwood Financial Corp. (NWFL) financial information pre-loaded to facilitate your analysis.
  • Automated DCF Calculations: The model computes Net Present Value (NPV) and intrinsic value automatically.
  • Tailored and Professional Design: A refined Excel template that customizes to your valuation requirements.
  • Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.

Key Features

  • Customizable Financial Inputs: Adjust essential parameters such as loan growth, interest rates, and operating expenses.
  • Instant Valuation Metrics: Automatically computes intrinsic value, net present value (NPV), and other key financial indicators.
  • High-Precision Estimates: Leverages Norwood Financial Corp.'s (NWFL) actual financial data for accurate valuation results.
  • Streamlined Scenario Testing: Easily explore various assumptions and analyze different outcomes.
  • Efficiency Booster: Remove the hassle of constructing intricate financial models from the ground up.

How It Works

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

Why Choose Norwood Financial Corp. (NWFL) Calculator?

  • User-Friendly Interface: Tailored for both novice users and seasoned professionals.
  • Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
  • Real-Time Valuation: Observe immediate updates to Norwood’s valuation with each input change.
  • Preloaded Data: Comes with Norwood’s current financial metrics for swift evaluations.
  • Relied Upon by Experts: A go-to tool for investors and analysts aiming for informed decision-making.

Who Should Use Norwood Financial Corp. (NWFL)?

  • Institutional Investors: Develop comprehensive and precise valuation models for investment analysis.
  • Financial Analysts: Evaluate valuation scenarios to inform corporate strategy and decision-making.
  • Investment Advisors: Offer clients reliable valuation assessments for Norwood Financial Corp. (NWFL) stock.
  • Academics and Students: Utilize real market data to enhance learning and practice in financial modeling.
  • Finance Enthusiasts: Gain insights into how financial institutions like Norwood Financial Corp. (NWFL) are valued in the industry.

What the Template Contains

  • Historical Data: Includes Norwood Financial Corp.'s (NWFL) past financials and baseline forecasts.
  • DCF and Levered DCF Models: Detailed templates to calculate Norwood Financial Corp.'s (NWFL) intrinsic value.
  • WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
  • Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
  • Quarterly and Annual Statements: A complete breakdown of Norwood Financial Corp.'s (NWFL) financials.
  • Interactive Dashboard: Visualize valuation results and projections dynamically.

No products were found matching.