The Bank Balance Sheet Ratio Calculator is a tool that you can use to determine a bank’s financial stability and liquidity using items found on a balance sheet. Using the inputs, the calculator will produce ratios that are important for the analysis of a bank’s balance sheet.
This template includes the following ratios:
Loan to Deposit Ratio
Common Equity Tier 1 (CET1) Ratio
Leverage Ratio
Here is a quick preview of CFI’s Bank Balance Sheet Ratio Calculator:
Loan to Deposit Ratio (LDR)
The loan to deposit ratio is used to determine a bank’s liquidity by comparing the total amount of loan outstanding to deposits stored in a bank.
The formula for the loan to deposit ratio is:
Loan to Deposit = Total Loans / Total Deposits
A high LDR means a bank has a relatively higher amount of capital in loans than deposits. While having a high LDR means a bank has good liquidity, it could also imply that they are not utilizing their capital efficiently. An exceptionally low LDR means the bank is not using the deposits (capital) to generate profit through loans.
Common Equity Tier 1 (CET1) Ratio
The Common Equity Tier 1 (CET1) Ratio is a requirement set by Basel III. This ratio measures the financial strength of a bank. This is done by comparing a bank’s core capital to its risk-weighted assets.
The formula for the CET1 ratio is:
CET1 Ratio = Common Equity Tier 1 Capital / Risk Weighted Assets
Basel III requires all banks to have a ratio of above 4.5%. This helps protect a bank as if assets suddenly lose value, there is still enough liquid capital to cover losses.
Leverage Ratio
The leverage ratio is another requirement introduced by Basel III. Similar to the CET1 ratio, it also compares capital to assets. However, for the leverage ratio, the asset is not weighted by risk and tier 1 capital is used.
The formula for the leverage ratio is:
Leverage Ratio: Tier 1 Capital / Total Assets (Exposure)
Basel III set a minimum leverage ratio requirement of 3%. This helps regulators ensure a bank has enough high-quality capital to cover its exposures.
Below is a break down of subject weightings in the FMVA® financial analyst program. As you can see there is a heavy focus on financial modeling, finance, Excel, business valuation, budgeting/forecasting, PowerPoint presentations, accounting and business strategy.
A well rounded financial analyst possesses all of the above skills!
Additional Questions & Answers
CFI is the global institution behind the financial modeling and valuation analyst FMVA® Designation. CFI is on a mission to enable anyone to be a great financial analyst and have a great career path. In order to help you advance your career, CFI has compiled many resources to assist you along the path.
In order to become a great financial analyst, here are some more questions and answers for you to discover:
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.