Originally published: 26/09/2018 12:45
Last version published: 29/06/2020 11:12
Publication number: ELQ-34016-5
View all versions & Certificate
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.
by Mahender K. PunhaniFreelance Financial Analyst experienced in Excel Financial Modelling , Equity Research, Investment Banking and Start-ups.Follow 80
Reviews
Write a review
People using this Best Practice also downloaded
Dealing with Employee Options
Learn how to value employee options and inserting this share in the value of your equity per share.964Discussadd_shopping_cartfreeby Aswath Damodaran
Three-Stage Free Cash Flow to Equity (FCFE) Discount Model
Value the equity in a firm with three stages of growth1,874Discussadd_shopping_cartfreeFree Cash Flow to Equity (FCFE) Stable Growth Model
Value the equity in a stable firm on the basis of free cashflows to equity597Discussadd_shopping_cartfreeValue of Equity in a Bank
Estimate the value of equity in a bank1,490Discussadd_shopping_cartfreeComparing Dividend Discount Model (DDM) and Free Cash Flow to Equity (FCFE) Excel Models: Two Stage Valuation
This Excel Valuation model compares the DDM and FCFE models for a Two Stage Valuation2,037Discussadd_shopping_cartfreeTwo-Stage Free Cash Flow to Equity (FCFE) Discount Model
Value the equity in a firm with two stages of growth3,242Discussadd_shopping_cartfreeDividend Discount Model: Gordon Growth, FCFF & FCFE
This video gives an explanation of the Dividend Discount Model and income based valuation approaches.192Discussfreeby Finance Walk
An Introduction to Leverage Analysis
A quick and informative video on leverage analysis.169DiscussThree-Stage Dividend Discount Model
Value the equity in a firm with three stages of growth2,706Discussadd_shopping_cartfreeFCFE (Free Cash Flow to Equity) Valuation Model
A complete FCFE valuation model that allows you to capital R&D and deal with options in the context of a valuation model1,957Discussadd_shopping_cartfree
More Best Practices from Mahender K. Punhani
Start-up Airlines Proforma Excel Model Template
This was a financial model for a start-up airlines to raise funds from the investors and banks.1,977Discussadd_shopping_cart$89.00by Mahender K. Punhani
Startup Cap Table Excel Model Template
A complete startup cap table to help you manage your fundraising with your investors.2,007Discussadd_shopping_cart$19.00Mobile App Startup Excel Financial Model Template
A complete mobile app startup financial model excel template for you to build your own from.3,423Discussadd_shopping_cart$89.00Healthcare Chain Financial Projections Excel Model Template
Financial model for healthcare chains, perfect for modeling financial projections.693Discussadd_shopping_cart$19.00Integrated Financial Statements
Excel financial model for integrated financial statements.1,8012add_shopping_cart$49.00Pizza and Mediterranean Food Financial Projections
Incredibly detailed and extensive financial model for your pizza or Mediterranean restaurant or takeaway.1,7832add_shopping_cart$89.00Hotel Investment Appraisal Excel Model Template
Download this read-to-use Hotel Investment Appraisal to help assess the viability of an investment into a hotel.979Discussadd_shopping_cart$49.00IT Consulting Financial Projections
Incredibly detailed financial model and projections for an IT consulting firm4192add_shopping_cart$29.00Gym Financial Projections Excel Model Template
This ready-to-use Excel spreadsheet offers a detailed and clear financial projections model template for a gym.1,383Discussadd_shopping_cart$89.00Brewery Financial Projection Model
Incredibly detailed financial model for monitoring and projecting the finances of your brewery project6142add_shopping_cart$79.00SaaS (Software as a Service) Business Pro Forma Excel Model Template
This is an extremely detailed Pro Forma Financial Model designed to help your SaaS Business.370Discussadd_shopping_cart$39.00Apartment Rental Business Financial Projections Excel Model Template
This is a high quality Excel spreadsheet template to help project the finances of your apartment rental business.709Discussadd_shopping_cart$29.00
Discussion feed for Bank Valuation Excel Model Template
The user community and author are here to help. Go ahead!
- 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.
Downloadable Best Practice Useredit