Bank valuation model - use M&A industry techniques to value any bank of your choice
Originally published: 12/08/2020 19:29
Publication number: ELQ-15442-1
View all versions & Certificate
certified

Bank valuation model - use M&A industry techniques to value any bank of your choice

M&A analysis of a bank using Discount Dividend Method, Gordon Growth Method, Book Values and Industry Multiples

Description
This Commercial Banking Valuation Model values any bank of your choice using a wide range of industry valuation methods, including Discount Dividend Method, Gordon Growth Method, Book Values, Industry Multiples, and Broker Consensus.

Use this model to value any Bank using professional industry methodologies. Input the previous year’s financials into the template provided and make growth assumptions based on previous year growth, industry growth, and news articles.

This model analyses your bank based on its financial profile, 20 industry competitors, and analyst reports – all of which can be updated or toggled on/off so you can build the valuation model you want.

The model is fully automated for all cells in black and editable for the bank of your choice across any geography. The model uses Discount Dividend Method, Gordon Growth Method, Book Values, Industry Multiples, and Broker Consensus to create a valuation taking into account a number of lenses – just like industry analysts. The weighting of these can be adjusted to make sure your final valuation is as accurate as possible based on your bank. (The example bank used is Bank of America)

Any of the inputs can be toggled on or off for ease to build up a picture of how you would value the bank. Dependent on the type of valuation methods you use, you can weight the outcome i.e. consistent dividend producing bank may rely more heavily on the DDM than one with heavy asset allocations.

This Best Practice includes
1 Excel model

Acquire business license for $39.95

Add to cart

Add to bookmarks

Discuss

Further information

- Value any bank with a variety of industry leading methodologies
- Produce a target share price value and a buy / sell / hold recommendation
- Weight the different methodologies to truly value the bank of your choice

- Understanding of the bank you are looking to value (or an interest in it)
- Knowledge of how to use excel and can work through models
- Knowing this is not a recommendation for purchasing shares / offering financial advice

- Needs excel
- Should have some basic financial knowledge


5.0 / 5 (2 votes)

please wait...