TrustCo Bank Corp NY (TRST) DCF Valuation

TrustCo Bank Corp NY (TRST) 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

TrustCo Bank Corp NY (TRST) 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 TrustCo Bank Corp NY (TRST) valuation analysis using our sophisticated DCF Calculator! This Excel template comes preloaded with real TRST data, enabling you to adjust forecasts and assumptions to accurately determine the intrinsic value of TrustCo Bank Corp NY.


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.4 170.8 178.3 189.9 190.2 194.4 198.8 203.2 207.8 212.5
Revenue Growth, % 0 -2.09 4.45 6.51 0.11214 2.24 2.24 2.24 2.24 2.24
EBITDA 86.5 79.6 92.7 110.0 88.4 98.2 100.4 102.7 105.0 107.3
EBITDA, % 49.6 46.61 51.99 57.9 46.49 50.52 50.52 50.52 50.52 50.52
Depreciation 10.0 10.1 10.6 10.6 10.8 11.2 11.5 11.7 12.0 12.2
Depreciation, % 5.73 5.94 5.93 5.56 5.67 5.77 5.77 5.77 5.77 5.77
EBIT 76.5 69.4 82.1 99.4 77.6 87.0 89.0 91.0 93.0 95.1
EBIT, % 43.87 40.67 46.05 52.34 40.81 44.75 44.75 44.75 44.75 44.75
Total Cash 622.0 486.3 456.1 650.6 578.0 194.4 198.8 203.2 207.8 212.5
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables .0 .0 .0 .0 .0
Account Receivables, % 0 0 0 0 0
Inventories .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Inventories, % 0 0 0 0 0 0 0 0 0 0
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 -3.9 -3.8 -2.8 -3.8 -5.7 -4.3 -4.4 -4.5 -4.6 -4.7
Capital Expenditure, % -2.23 -2.24 -1.59 -1.99 -2.98 -2.21 -2.21 -2.21 -2.21 -2.21
Tax Rate, % 24.44 24.44 24.44 24.44 24.44 24.44 24.44 24.44 24.44 24.44
EBITAT 57.8 52.5 61.5 75.2 58.6 65.6 67.1 68.6 70.2 71.7
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 63.9 58.8 69.3 82.0 63.8 72.6 74.2 75.9 77.6 79.3
WACC, % 13.82 13.82 13.77 13.83 13.82 13.81 13.81 13.81 13.81 13.81
PV UFCF
SUM PV UFCF 260.3
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 81
Terminal Value 685
Present Terminal Value 359
Enterprise Value 619
Net Debt -5
Equity Value 624
Diluted Shares Outstanding, MM 19
Equity Value Per Share 32.78

What You Will Receive

  • Comprehensive Financial Model: TrustCo Bank Corp NY’s (TRST) actual data allows for accurate DCF valuation.
  • Complete Forecast Control: Modify revenue growth, profit margins, WACC, and other essential metrics.
  • Real-Time Calculations: Automatic updates provide immediate insights as adjustments are made.
  • Professional-Grade Template: A polished Excel file crafted for high-quality valuation purposes.
  • Flexible and Reusable: Designed for adaptability, enabling ongoing use for in-depth forecasts.

Key Features

  • Comprehensive TRST Data: Pre-filled with TrustCo Bank Corp NY's historical financials and future projections.
  • Fully Customizable Inputs: Modify revenue growth, margins, WACC, tax rates, and capital expenditures to suit your analysis.
  • Dynamic Valuation Model: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on your custom inputs.
  • Scenario Testing: Develop various forecast scenarios to explore different valuation results.
  • User-Friendly Design: Intuitive layout that caters to both professionals and newcomers.

How It Works

  • Download: Obtain the pre-formatted Excel file containing TrustCo Bank Corp NY’s (TRST) financial data.
  • Customize: Modify projections, including loan growth, net interest margin, and cost of capital.
  • Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
  • Test Scenarios: Develop various forecasts and analyze results immediately.
  • Make Decisions: Leverage the valuation insights to inform your investment choices.

Why Choose This Calculator?

  • User-Friendly Interface: Perfectly crafted for both novices and seasoned professionals.
  • Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
  • Real-Time Valuation: Observe immediate updates to TrustCo Bank Corp NY’s valuation as you modify inputs.
  • Preloaded Data: Comes equipped with TrustCo Bank Corp NY’s actual financial information for swift evaluations.
  • Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.

Who Should Use This Product?

  • Finance Students: Master the principles of banking and apply them to real-world scenarios with TrustCo Bank Corp NY (TRST).
  • Academics: Utilize industry-specific models in your research or teaching related to banking and finance.
  • Investors: Evaluate your investment strategies by analyzing financial metrics and performance indicators of TrustCo Bank Corp NY (TRST).
  • Analysts: Enhance your analysis process with a tailored, efficient financial model for TrustCo Bank Corp NY (TRST).
  • Small Business Owners: Learn from the financial practices of established banks like TrustCo Bank Corp NY (TRST) to improve your own financial management.

What the Template Contains

  • Comprehensive DCF Model: Editable template featuring detailed valuation calculations for TrustCo Bank Corp NY (TRST).
  • Real-World Data: TrustCo Bank's historical and projected financials preloaded for thorough analysis.
  • Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
  • Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into TrustCo Bank's performance.
  • Key Ratios: Integrated analysis for assessing profitability, efficiency, and leverage metrics.
  • Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results regarding TrustCo Bank Corp NY (TRST).

No products were found matching.