Certified Bank Modelling & Valuation Professional

NAME OF THE COURSE
Certified Bank Modelling & Valuation Professional
 
CERTIFICATION
Certified Bank Modelling & Valuation Professional
 
COURSE OVERVIEW
Developing a financial model for a bank is quite different compared to other industries. The analysis operates on unique methodologies that differ vastly from traditional approaches.
 
TRAINING DURATION
Total Training Hours : 22 Hours
Training Duration      : 1 Week
Total Training  Days  : 4-5 Working Days
 
TRAINING SCHEDULE
Weekdays (Sunday to Thursday)
Regular Sessions : 4 – 6 Hrs Per day (9am to 2pm or 3.00pm to 9.00 pm)
Food & refreshments Included
Weekends (Friday & Saturday)
Fast Track Sessions: 8 Hours per day (9am to 5pm)
Food & refreshments Included
 
CERTIFICATION
Globally recognized certificate from “Kings Global Career Academy”
 
TEST
No
 
LEARNING AIDS
Yes
 
COURSE MATERIAL
Hard & Soft Copies of Study Material
 
LANGUAGE OF INSTRUCTION
English
 
INSTRUCTOR HELPLINE
Yes
1. Email
2. Social Media (For Emergency requirements)
 
REGISTRATION REQUIREMENTS
1. Passport Copy
2. Curriculum Vitae
3. Passport size photographs
4. Course Fee
 
MODE OF PAYMENT
Cash / Cheque / Credit Card / Bank Transfer.
 
ELIGIBILITY CRITERIA
Professionals working or aspiring to work in:
  • Asset management
  • Banking
  • Investment Banking
  • Sovereign Wealth Fund
  • Regulation
  • Central Bank
 
COURSE BENEFITS
  • Forecast and develop an integrated bank financial model starting from a blank excel
  • Analyze a bank’s financial statements and interaction between its key assets and liabilities
  • Discover the impact of IFRS 9 & Basel III on a bank’s financial health
  • Value a bank using cash flows and multiples-based valuation tools
  • Learn and apply advanced Excel tools and functions
  • Understand why banks are regulated
 
COURSE CONTENTS
 
Overview of Bank financial modelling
  • Key Excel tools used in bank financial modelling (Logical & Date functions, Data Tables, Index & Match, Choose, etc.)
  • Introducing the case study bank
  • Model design and structure for the case study bank
  • Know the key model outputs and their drivers
  • Understand the requisite inputs
  • Developing cell styles for model transparency and review
  • Introduction to the bank’s financial statements
  • Understanding a bank’s balance sheet – Key assets and liabilities
  • Understanding a bank’s income statement and different sources of income
  • Understanding a bank’s risk evaluation metrics
  • Extracting, cleaning and normalizing historical financial statements of a bank from annual reports
  • Building error checks in the model
 
Forecasting a Bank’s Financial Statements – Balance Sheet
  • Loan portfolio – overall and segmental breakdown
  • NPL and credit loss provisions
  • Trading assets and investments
  • Other non – core assets: PP&E, etc.
  • Deposits portfolio – overall and segmental breakdown
  • Central Bank, Interbank and other liabilities
  • Funding requirement – Debt and Equity
  • Regulatory Tier 1 and Tier 2 capital requirement for a bank
  • The Model Balancer of the bank’s balance sheet
  • Forecasting a Bank’s Financial Statements – Income Statement
  • Net Interest Income
  • Interest Income – Overall and segmental breakdown
  • Interest Expense – Overall and segmental breakdown
 
Forecasting a Bank’s Financial Statements – Income Statement
  • Net Fee & Commission Income
  • Trading Income
  • Credit loss provisions
  • Other operating costs and taxes
  • Dividend Pay-out Ratio:
  • Using historical or a target pay-out ratio
  • Linking dividends pay-out  to target capital requirements (surplus capital method)
  • Analysing a bank’s forecasted financial statements:
  • Profitability Ratios: NIM, ROA, ROE, the cost to income, the cost to an asset, etc.
  • Capital Ratios:
  • Tier 1 and Tier 2 capital ratios
  • Gross and Net leverage ratios
  • Asset quality ratios:
  • Gross and Net NPL ratios
  • Coverage ratio and more
  • Bank Valuation – Discounted Cash Flows & Trading Comps
  • Calculating a bank’s Cost of Equity and understanding the right selection for different CAPM inputs
  • Estimating terminal value  – growth rate and multiple methods
  • Valuation using DDM and FCFE methods
  • Performing scenario and sensitivity analysis to DCF valuation outputs
  • Selecting the right set of comps to the subjected comps
  • Normalizing the financial metrics of peer groups
  • Using P/E and P/B multiples to value the subject banks
  • Presenting the model outputs using high quality and flexible charts and creating a management dashboard.
  • Combo charts, Football Field Chart, etc.
  • Camera tools
  • Dashboard with scenario manager switch
REGISTER NOW