Value of Equity in a Bank
![Value of Equity in a Bank - Templarket - Business Templates Marketplace]()
![Value of Equity in a Bank - Templarket - Business Templates Marketplace]()
![Value of Equity in a Bank - Templarket - Business Templates Marketplace]()
![Value of Equity in a Bank - Templarket - Business Templates Marketplace]()
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)
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)
