Value of Equity in a Bank

Estimate the value of equity in a bank

bankequityfinanceinvestmentpresent valuevalue

Description
Estimates the value of equity in a bank by discounting expected excess returns to equity investors over time and adding them to book value of equity.

Inputs needed:
1. Length of high growth period
2. Expected growth rate in earnings during the high growth period.
3. Dividend payout ratio during the high growth period.
4. Expected growth rate in earnings during the stable growth period.
5. Expected payout ratio during the stable growth period.
6. Current Earnings per share
7. Inputs for the Cost of Equity

Options: You can make this model into a three stage model by answering yes to the question of whether you want me to adjust the inputs in the second half of the high growth period. If you do, I will adjust the growth rate, the payout ratio and the cost of equity from high-growth levels to stable growth levels gradually. You can also make this a stable growth model by setting the high
growth period to zero.

Note: this model is being shared with the authorization of Professor Aswath Damodaran from NYU Stern Business School (www.damodaran.com)

This business tool includes
1 Excel Model File

Prof. Aswath Damodaran offers you this business tool for free!

Download for free

Discuss

Further information

The objective of this model is to get the following output values:
- Equity Invested
- PV of Equity Excess Return
- Value of Equity
- Value Per Share

1. The firm is expected to grow at a higher growth rate in the first period.
2. The growth rate will drop at the end of the first period to the stable growth rate.
3. The dividend payout ratio is consistent with the expected growth rate.

Reviews

  • No review yet!

Any questions on Value Of Equity In A Bank?

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

please wait...