The Bank Balance Sheet Ratio Calculator is a tool that you can use to determine a bank's financial strength and stability using items found on a balance sheet. This calculator uses several inputs such as common shares, risk-weighted assets, and total deposits. 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

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. A high LDR means a bank has a relatively higher amount of capital in loans than deposits. By having more funds tied up in loans, this increases the risk that the bank would not have enough capital for customers that wants to take out their deposit. The formula for the loan to deposit ratio is: Loan to Deposit = Total Loans / Total Deposits

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 allows the regulators to ensure the bank remains solvent even during times of financial stress.

Leverage Ratio

The leverage ratio is another requirement introduced by Basel III. It is similar to the CET1 ratio as it also compares capital to assets. However, for the leverage ratio, the Tier 1 capital is used and the total asset is not weighted by risk. 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 requirement ensures the bank has enough liquid capital to cover its exposure (assets).  
Reviews Add a review
No reviews yet

More From Corporate Finance Institute®

Browse our top rated business templates. See All
REIT Financial Model Template
This REIT financial model template acts as a guideline for modeling a real estate investment trust (REIT). This model will…
Energy Industry Comps Template Energy Industry Comps Template
This energy industry comps template provides a guideline and example of what a comparables universe would look like for a…
Financial Institution Dividend Discount Model
The financial institution dividend discount model uses future dividends to find the implied share price. This model is based on…
Loan Payment Calculator
The loan payment calculator allows users to determine the principal and interest payment each month until the full balance of…
DDM - Excel Dividend Discount Model Template
The dividend discount model template allows investors to value a company base on future dividend payments. This is based on…
Non-directional trading strategy template Non-directional Trading Strategies Template
The non-directional trading strategies template allow users to determine the profit when buying options. This template focuses on non-directional strategies…
See All