Bank Modeling Valuation

Fitch Learning

How long?

  • 3 days
  • online

Fitch Learning


Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Read more about Economics

Regardless of your specialization, economics surrounds you everywhere, and at some point in time, it will be necessary for you to understand the basic...

Read more about Finance

Finance is an integral and most important component of any business, so everyone needs to improve their competence in this area. Finance courses will ...

Read more about Marketing

Marketing courses will plunge you into the vast field of marketing. In these courses, you will learn a variety of topics that cover each stage of runn...

Read more about Strategy

In order to keep the company that you are managing or your own business competitive, you need to have a clear plan of action, in other words, you must...


Comprehensive course analysis

Unbiased reviews from past participants
Global companies alumni of this course worked for
Positions of participants who took this course
Countries where most past participants are from
Individual needs analysis

Who should attend

This course is suitable for equity analysts and investors, M&A and finance professionals working on model building and analysing banks.

About the course

A three day intensive, computer modeling course offering a structured approach to building a robust bank forecasting model and carrying out sensitivity analysis.

Key Learning Outcomes:

  • Plan and design a bank valuation model and build a portfolio of excel shortcuts to aid modeling efficiency
  • Extract financial data from the annual reports and normalise these for forecasting purposes
  • Understand the relationship of the key assets and liabilities on a bank’s balance sheet and derive an income statement and model a detailed loan portfolio
  • Add detailed scenario flexibility, Key Performance Indicators (KPI’s) and model equity distribution within the constraints of regulatory capital requirements
  • Develop a back end equity model and carry out sensitivity analysis.

Analytic Overview

The aim of this section is to set out the parameters of how to build and run a flexible and robust financial model which can be used to run numerous scenarios.

  • Key steps to setting up a model; good and bad practice
  • Understanding the structure of a model; inputs, workings and outputs
  • Scope limitations: output requirements versus input source
  • Using group edit tools to quickly set up a robust, consistent and printable financial model
  • Input sheets; creating underlying assumptions/forecasts
  • Model plan
  • Workbook setup
  • Inputting base data
  • Setting up date flexibility throughout the model using various date functions.

Building Financials

The aim of this section is to build financials within the model using normalised historics for the inputs.

  • Deciding which key lines to have in the model’s financial statements
  • Entering and normalising the historics
  • Review the structure of the model
  • Reconciling the financials and creating a robust model providing the foundations for forecasting.

Building the balance sheet

The objective of this section is for the participants to build the basic balance sheet structure of their forecasting model.

Establishing the loan portfolio

  • Drivers of growth
  • Non-performing loans and provisions for credit loss

Trading assets & investments

  • Derivative exposures under different accounting treatments
  • Securities held for trading and investment

Trading liabilities, derivatives versus short sold securities

  • Cash and central bank balances

Liquid assets


  • Drivers and limitations of deposit growth

Wholesale sources of funding

  • Money markets versus capital markets

Subordinated debt and hybrid capital


Estimating regulatory capital requirements for the balance sheet

Reconciling the financials and creating a robust model providing the foundations for forecasting.

Deriving the income statement

The objective of this section is to take the balance sheet for each forecasting period derived above and use it to establish an income statement for each accounting period.

Net interest margin

  • Establishing interest rate scenarios
  • Setting appropriate margins for assets and liabilities
  • Dealing with interest rate hedging
  • Building up a line by line net interest margin

Fee and commission income

  • Establishing the drivers of core fee and commission income; new business related, back-book related and transactional income
  • Drivers of other lines of business income; asset management, insurance and investment banking

Trading income

  • Modeling trading income by product line
  • Estimating volatility of trading income
  • Modeling the risks

Credit losses

  • Accounting entries in the loan provisioning, write-off and recovery cycle
  • Utilising non-performing loan forecasts and write off-rates to establish a cost of provisioning for the income statement


  • Drivers of costs in banking business models
  • Differentiating fixed and variable costs
  • Establishing a cost forecast for the business model

Other income statement items

  • Estimating tax rates
  • Establishing a dividend pay-out rate
  • Other income statement items; extraordinary items, discontinued business lines, etc.

Linking the income statement to the balance sheet

  • Retained earnings
  • Impact upon liquid assets.

Key Ratios and Measuring Key Performance Indicators (KPI’s)

The objective of this section is to provide participants with the ability to model typical bank KPI’s from the financial statements they have built in the previous sections. These ratios can then be used to evaluate the integrity of the model, facilitate interpretation of the model and enable comparison against peer institutions.

Asset quality indicators

  • Non-performing loan ratio
  • Coverage ratio
  • Provisioning and write-off ratios
  • Net non-performing loan measures

Liquidity measures

  • Minimum risk asset and liquid asset measures
  • Comparing liquid assets to total assets, deposits and funded liabilities
  • Cross balance sheet ratios; loan to deposits, inter-bank, liquid assets to wholesale funding
  • Measures of funding concentration

Capital ratios

  • BIS regulatory capital ratios; Core Tier 1, Tier 1 and Tier 2
  • Net and gross leverage ratios, estimating the BIS leverage ratio
  • Capital formation rate

Profitability measures

  • Net interest margin
  • Return on assets and return on equity
  • Efficiency ratios; cost to income and cost to asset

Graphical representation of model outputs and efficient building of charts within the model structure.

Bank Valuation and Cost of Equity

The aim of this section is to review the bank valuation and equity outputs of the model and review quality controls.

  • Equity; multiple versus cash flow valuation, price to book multiples
  • DDM
  • FCFE
  • Terminal value estimates
  • Valuation: key sanity checks
  • CAPM
  • Finding and evaluating the input data
  • Risk free rates
  • Equity market risk premiums
  • Beta releveraging and comparables, raw and adjusted betas, interpretation of Bloomberg beta
  • Internal regression

Quality controls

  • Checks
  • Error flags if balance sheet does not balance or financials don’t reconcile
  • Charts as controls

Scenario Analysis and Stress Testing Outputs

The aim of this section is to test model inputs, review scenario analysis and look at stress testing assumptions.

Data (sensitivity) tables

  • Data tables are very useful in testing sensitivity of various inputs to a model.
  • 1-dimensional data tables
  • 2-dimensional data tables
  • Efficient techniques for updating data tables as inputs change
  • Self-centring data tables

Building a scenario manager and switch

  • Adding flexibility so the model can be run under different net interest margin scenarios or macroeconomic drivers– i.e. base, upside, downside, management etc
  • Drop down menus/Visual basic tools to enable the efficient switching between different scenarios will be introduced

Adding the final touches

  • Adding a dashboard to run the model
  • Text strings – to summarise key aspects of the model
  • Benchmarking forecasts against consensus
  • Developing the equity story to support consensus divergence
  • Use of the camera
  • Graphs – with dynamic headers.

Model Debugging Skills

The aim of this section is to build and run a diagnostic function into the model.

  • Building diagnostics into model
  • Balance sheet checks
  • Using ratios to debug
  • Auditing skills
  • Watch windows
  • Link elimination
  • Circularity issues
  • Unnecessary macro creation
  • F5 special functionality.

Videos and materials

Bank Modeling Valuation at Fitch Learning

From  $2,812
Add coaching to your course booking

Coaching can personalize and deepen learning for you and your organization.

Something went wrong. We're trying to fix this error.

Thank you for your application

We will contact the provider to ensure that seats are available and, if there is an admissions process, that you satisfy any requirements or prerequisites.

We may ask you for additional information.

To finalize your enrollment we will be in touch shortly.


Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Read more about Economics

When it comes to dealing with the economical side of any business process, it is essential to build a basic framework for studying market analysis, microeconomic and macroeconomic concepts, and competition models. How can an organization's objectives...

Read more about Finance

During Finance courses, you will get acquainted with a huge number of financial analyst tools and learn how to work with them. So, you will learn how to make and analyze financial reporting, calculate the main financial indicators of the company and ...

Read more about Marketing

During Marketing courses, you will learn how to develop a business idea and create the right website to promote your product. You will gain the skills to analyze your business performance and make key decisions that improve the efficiency of your bus...

Read more about Strategy

Strategy courses contain a large amount of practice. You will be able to analyze the company's performance and make a strategic development plan. All practices are based on real cases that each of you may encounter. The courses will also introduce yo...

Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.

We are happy to help you find a suitable online alternative.