• Originally published: 26/09/2018 12:45
Last version published: 29/06/2020 11:12
Publication number: ELQ-34016-5
View all versions & Certificate

# Bank Valuation Excel Model Template

This Excel model contains a template for calculating the value of a bank.

Description
This model is a useful template for predicting and calculating the value of a given bank – in this example, the Bank of America in 2012. A bank valuation model can be used to measure the fundamental value of a bank’s equity.
The Excel template model includes 9 different functional tabs which enable the user to run their own evaluation and calculations.

These tabs are:

- Expected Return Using DDM
- Assumption & Working
- Beta Calculator
- Du Pont
- Du Pont Chart
- FCFE Valuation
- Constant Growth DDM
- Multi Stage DDM
- Leverage

The Expected Return tab includes a calculation using DDM, Dividend Discount Model. There are three similar methods with their given formulas.

The Assumption and Working tab also uses DDM, including factors such as Net Income to Common Shareholders, EPS (Earnings per Share), and DPS (Dividend per Share).

The Beta Calculator and the Du Pont tabs hold the data, with the Du Pont Chart containing a visual representation of the Income Statement and the Balance Sheet.

The FCFE Valuation tab, which stands for the Free Cash Flow to Equity, shows the value of each share, as well as the formula used to calculate the FCFE.

The Constant Growth DDM, Multi Stage DDM and Leverage tabs contain tables that concisely show the value of shares at different stages.

This Best Practice includes

Discuss

See all

## Discussion feed for Bank Valuation Excel Model Template

The user community and author are here to help. Go ahead!

• Hey Mahender. I purchased your Excel file. How do I change from Bank of America to TD Dominion Bank? How do I update the years in the cells?
• Hi Aiman, I have uploaded a new version of model. Please change year in cell C5 of Assumption & Working tab and F5 of DuPont tab. For Beta calculation you can change the period for which you want to calculate Beta. Let me know if there is any problem.

• 100%
• -
• -
• -
• -