Skip to content
Felix
  • Topics
    • My List
    • Felix Guide
    • Asset Management
    • Coding and Data Analysis
      • Data Analysis and Visualization
      • Financial Data Tools
      • Python
      • SQL
    • Credit
      • Credit Analysis
      • Restructuring
    • Financial Literacy Essentials
      • Financial Data Tools
      • Financial Math
      • Foundations of Accounting
    • Industry Specific
      • Banks
      • Chemicals
      • Consumer
      • ESG
      • Insurance
      • Oil and Gas
      • Pharmaceuticals
      • Project Finance
      • Real Estate
      • Renewable Energy
      • Technology
      • Telecoms
    • Introductory Courses
    • Investment Banking
      • Accounting
      • Financial Modeling
      • M&A and Divestitures
      • Private Debt
      • Private Equity
      • Valuation
      • Venture Capital
    • Markets
      • Economics
      • Equity Markets and Derivatives
      • Fixed Income and Derivatives
      • Introduction to Markets
      • Options and Structured Products
      • Other Capital Markets
      • Securities Services
    • Microsoft Office
      • Excel
      • PowerPoint
      • Word & Outlook
    • Professional Skills
      • Career Development
      • Expert Interviews
      • Interview Skills
    • Risk Management
    • Transaction Banking
    • Felix Live
  • Pathways
    • Investment Banking
    • Asset Management
    • Equity Research
    • Sales and Trading
    • Commercial Banking
    • Engineering
    • Operations
    • Private Equity
    • Credit Analysis
    • Restructuring
    • Venture Capital
    • CFA Institute
  • Certified Courses
  • Ask An Instructor
  • Support
  • Log in
  • Topics
    • My List
    • Felix Guide
    • Asset Management
    • Coding and Data Analysis
      • Data Analysis and Visualization
      • Financial Data Tools
      • Python
      • SQL
    • Credit
      • Credit Analysis
      • Restructuring
    • Financial Literacy Essentials
      • Financial Data Tools
      • Financial Math
      • Foundations of Accounting
    • Industry Specific
      • Banks
      • Chemicals
      • Consumer
      • ESG
      • Insurance
      • Oil and Gas
      • Pharmaceuticals
      • Project Finance
      • Real Estate
      • Renewable Energy
      • Technology
      • Telecoms
    • Introductory Courses
    • Investment Banking
      • Accounting
      • Financial Modeling
      • M&A and Divestitures
      • Private Debt
      • Private Equity
      • Valuation
      • Venture Capital
    • Markets
      • Economics
      • Equity Markets and Derivatives
      • Fixed Income and Derivatives
      • Introduction to Markets
      • Options and Structured Products
      • Other Capital Markets
      • Securities Services
    • Microsoft Office
      • Excel
      • PowerPoint
      • Word & Outlook
    • Professional Skills
      • Career Development
      • Expert Interviews
      • Interview Skills
    • Risk Management
    • Transaction Banking
    • Felix Live
  • Pathways
    • Investment Banking
    • Asset Management
    • Equity Research
    • Sales and Trading
    • Commercial Banking
    • Engineering
    • Operations
    • Private Equity
    • Credit Analysis
    • Restructuring
    • Venture Capital
    • CFA Institute
  • Certified Courses
Felix
  • Data
    • Company Analytics
    • My Filing Annotations
    • Market & Industry Data
    • United States
    • Relative Valuation
    • Discount Rate
    • Building Forecasts
    • Capital Structure Analysis
    • Europe
    • Relative Valuation
    • Discount Rate
    • Building Forecasts
    • Capital Structure Analysis
  • Models
  • Account
    • Edit my profile
    • My List
    • Restart Homepage Tour
    • Restart Company Analytics Tour
    • Restart Filings Tour
  • Log in
  • Ask An Instructor
    • Email Our Experts
    • Felix User Guide
    • Contact Support

Bank Modeling

Understand the basics of how to forecast and model a bank's financial statements.

Unlock Your Certificate   
 
0% Complete

13 Lessons (30m)

Show lesson playlist
  • Description & Objectives

  • 1. Bank Modeling Steps

    01:56
  • 2. Bank Model - Model Intro

    01:41
  • 3. Bank Model - Historical Subtotals

    02:58
  • 4. Bank Model - Balance Sheet Assets 1

    02:02
  • 5. Bank Model - Balance Sheet Assets 2

    03:10
  • 6. Bank Model - Balance Sheet Liabilities

    01:11
  • 7. Bank Model - BS Interbank Deposits-Loans

    02:22
  • 8. Bank Model - Income Statement Interest

    03:13
  • 9. Bank Model - Income Statement Finished

    01:31
  • 10. Bank Model - Equity Calculation

    02:53
  • 11. Bank Model - Equity Calculation Example

    03:32
  • 12. Bank Model - Equity in BS and Circular

    02:38
  • 13. Bank Modeling Tryout


Prev: Bank Regulations Next: Bank Valuation

Bank Model - Equity Calculation Example

  • Notes
  • Questions
  • Transcript
  • 03:32

Understand how to forecast a bank's shareholder's equity

Downloads

Model - Equity Calculation EmptyModel - Equity Calculation Full

Glossary

Bank Capital Contribution Bank Dividends Bank Shareholders' Equity Common Tier 1 Equity Risk Weighted Assets
Back to top
Financial Edge Training

© Financial Edge Training 2025

Topics
Introduction to Finance Accounting Financial Modeling Valuation M&A and Divestitures Private Equity
Venture Capital Project Finance Credit Analysis Transaction Banking Restructuring Capital Markets
Asset Management Risk Management Economics Data Science and System
Request New Content
System Account User Guide Privacy Policy Terms & Conditions Log in
Transcript

To calculate shareholders equity we need to do some calculations. So let's go find them above the income statements. So here's our equity section and we start with our estimated common equity tier one ratio. I can find that up in my assumptions. I need 13% of risk weighted assets. Next up, I need to calculate my risk weighted assets. Risk weighted assets, again, go up to your assumption, it's going to be 37.5% of my total assets. So down to my balance sheet, find total assets. There they are. Just because I double check, we just recalculate it here. So risk weighted assets divided by my total assets, yes, gives me the same 37.5.

Okay, so my estimated common equity tier one's going to be 13% of my risk weighted assets, 448.6. That's the equity the regulator says has to be put aside in case of risk weighted assets. However, that's not the equity we're going to have on our balance sheet, although it does drive it. What we need to do is we need to get that equity up here via deferred tax assets and intangibles. Let's go get intangibles from the balance sheets, but I need to times this by minus one. You'll notice the intangibles are shown as negatives. Same for deferred tax assets. Let's do the same thing again. We find that, time's that by minus one, it's now a negative. So what do we need to show here? Well, what we're saying is that the equity on the balance sheet here, well that's the same as your net assets, and that includes things like deferred tax assets and intangibles which the regulator deems to have no value. So in order for us to have 448.6 of equity set aside in case of risk weighted assets, we actually need to have more than that on the balance sheet. So I take my 448.6, subtract off the negatives, meaning I end up with 528 of equity. Now I can read it a little bit easier. Of that 528, you then subtract 36.4, subtract the 43 intangibles to get to your estimated common equity tier one of 448.6. Great. Now let's use base analysis to find out the dividends or capital contribution. I know my beginning balance of equity, it's last year's ending. I know this year's ending, it's what we've just calculated. Shareholders equity of 528. I know my net income, that's from the income statements, 8.9. So I can now calculate whether this bank can pay a dividend or whether it needs a capital contribution. So we start with 407.2 of equity at the start of the year. Unfortunately, we then add on a loss, but we need to get to the end of the year with 528 of equity. So what do I need? I need 129.7 of a capital contribution. Let's copy all of that to the right. We'll see what happens to equity over time. And we see in the first few years it is going up from 528 to 745 to 1022.6 and that's all via capital contributions. But we do see in columns I and J the bank is able to pay a dividend and its equity is still able to go up as well. Basically, it's net income is high enough to afford dividends and to afford the equity level required by the regulator.

Content Requests and Questions

You are trying to access premium learning content.

Discover our full catalogue and purchase a course Access all courses with our premium plans or log in to your account
Help

You need an account to contact support.

Create a free account or log in to an existing one

Sorry, you don't have access to that yet!

You are trying to access premium learning content.

Discover our full catalogue and purchase a course Access all courses with our premium plans or log in to your account

You have reached the limit of annotations (10) under our premium subscription. Upgrade to unlock unlimited annotations.

Find out more about our premium plan

You are trying to access content that requires a free account. Sign up or login in seconds!

Create a free account or log in to an existing one

You are trying to access content that requires a premium plan.

Find out more about our premium plan or log in to your account

Only US listed companies are available under our Free and Boost plans. Upgrade to Pro to access over 7,000 global companies across the US, UK, Canada, France, Italy, Germany, Hong Kong and more.

Find out more about our premium plan or log in to your account

A pro account is required for the Excel Add In

Find out more about our premium plan

Congratulations on completing

This field is hidden when viewing the form
Name(Required)
This field is hidden when viewing the form
Rate this course out of 5, where 5 is excellent and 1 is terrible.
Were the stated learning objectives met?(Required)
Were the stated prerequisite requirements appropriate and sufficient?(Required)
Were the program materials, including the qualified assessment, relevant and did they contribute to the achievement of the learning objectives?(Required)
Was the time allotted to the learning activity appropriate?(Required)
Are you happy for us to use your feedback and details in future marketing?(Required)

Thank you for already submitting feedback for this course.

CPE

What is CPE?

CPE stands for Continuing Professional Education, by completing learning activities you earn CPE credits to retain your professional credentials. CPE is required for Certified Public Accountants (CPAs). Financial Edge Training is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors.

What are CPE credits?

For self study programs, 1 CPE credit is awarded for every 50 minutes of elearning content, this includes videos, workouts, tryouts, and exams.

CPE Exams

You must complete the CPE exam within 1 year of accessing a related playlist or course to earn CPE credits. To see how long you have left to complete a CPE exam, hover over the locked CPE credits button.

What if I'm not collecting CPE credits?

CPE exams do not count towards your FE certification. You do not need to complete the CPE exam if you are not collecting CPE credits, but you might find it useful for your own revision.


Further Help
  • Felix How to Guide walks you through the key functions and tools of the learning platform.
  • Playlists & Tryouts: Playlists are a collection of videos that teach you a specific skill and are tested with a tryout at the end. A tryout is a quiz that tests your knowledge and understanding of what you have just learned.
  • Exam: If you are collecting CPE points you must pass the relevant CPE exam within 1 year to receive credits.
  • Glossary: A glossary can be found below each video and provides definitions and explanations for terms and concepts. They are organized alphabetically to make it easy for you to find the term you need.
  • Search function: Use the Felix search function on the homepage to find content related to what you want to learn. Find related video content, lessons, and questions people have asked on the topic.
  • Closed Captions & Transcript: Closed captions and transcripts are available on videos. The video transcript can be found next to the closed captions in the video player. The transcript feature allows you to read the transcript of the video and search for key terms within the transcript.
  • Questions: If you have questions about the course content, you will find a section called Ask a Question underneath each video where you can submit questions to our expert instructor team.