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 78
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.854Discussadd_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,688Discussadd_shopping_cartfreeFree Cash Flow to Equity (FCFE) Stable Growth Model
Value the equity in a stable firm on the basis of free cashflows to equity571Discussadd_shopping_cartfreeValue of Equity in a Bank
Estimate the value of equity in a bank1,434Discussadd_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 Valuation1,920Discussadd_shopping_cartfreeTwo-Stage Free Cash Flow to Equity (FCFE) Discount Model
Value the equity in a firm with two stages of growth3,056Discussadd_shopping_cartfreeDividend Discount Model: Gordon Growth, FCFF & FCFE
This video gives an explanation of the Dividend Discount Model and income based valuation approaches.173Discussfreeby Finance Walk
An Introduction to Leverage Analysis
A quick and informative video on leverage analysis.157DiscussFCFE (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,857Discussadd_shopping_cartfreeThree-Stage Dividend Discount Model
Value the equity in a firm with three stages of growth2,586Discussadd_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,833Discussadd_shopping_cart$89.00by Mahender K. Punhani
Mobile App Startup Excel Financial Model Template
A complete mobile app startup financial model excel template for you to build your own from.3,046Discussadd_shopping_cart$89.00Startup Cap Table Excel Model Template
A complete startup cap table to help you manage your fundraising with your investors.1,729Discussadd_shopping_cart$19.00Pizza and Mediterranean Food Financial Projections
Incredibly detailed and extensive financial model for your pizza or Mediterranean restaurant or takeaway.1,6552add_shopping_cart$89.00Integrated Financial Statements
Excel financial model for integrated financial statements.1,7002add_shopping_cart$49.00Healthcare Chain Financial Projections Excel Model Template
Financial model for healthcare chains, perfect for modeling financial projections.565Discussadd_shopping_cart$19.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.940Discussadd_shopping_cart$49.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,211Discussadd_shopping_cart$89.00Brewery Financial Projection Model
Incredibly detailed financial model for monitoring and projecting the finances of your brewery project5622add_shopping_cart$79.00IT Consulting Financial Projections
Incredibly detailed financial model and projections for an IT consulting firm3802add_shopping_cart$29.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.334Discussadd_shopping_cart$39.00Startup Nursery School Financial Projections Excel Template
This is a comprehensive financial model for creating projections for a startup Nursery School.697Discussadd_shopping_cart$89.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