ThinkingApplied.com

Mind Tools: Applications and Solutions


 

Understanding Banks' Earnings:
An Evaluation & Forecasting Technique
Part 1

Download complete article as PDF file

Lee Humphries

 

The year-to-year change in a bank's earnings per share (EPS) is driven by the fluctuating values of nine critical ratios.  This paper defines those ratios and shows how to integrate them into a spreadsheet routine that will:

• isolate their respective dollar-and-cents contributions to annual changes in EPS,

• measure their relative power to improve EPS, and

• calculate future EPS based on their projected values.

This analytical technique is useful to both investors and managers.  It quantifies for investors the effect on EPS of past ratio changes, and it helps them evaluate the bank's capacity for future earnings increases.  It reveals to managers those operational areas where improvements will yield the greatest bottom line benefits, and it allows them to calculate the EPS effect of targeted ratio changes.

 

I. Nine Critical Ratios

Definitions

A bank's EPS is determined by the interaction of nine critical ratios, which we define in the following way.

Ratio 1: interest expense ÷ average liabilities—the average interest rate paid on total average liabilities.

Ratio 2: provision for loan losses ÷ interest income—the loan loss provision rate.

Ratio 3: interest income ÷ total revenue—the percent of revenue derived from interest income.

Ratio 4: non-interest expense ÷ total revenue less interest expensecommonly known as the efficiency ratio.  A bank with significant tax exempt interest income will sometimes increase the ratio's denominator, total revenue less interest expense, adding to it the tax benefit that results from exempt interest income.  This adjustment produces a lower—and, at first glance, better—efficiency ratio than the one calculated by the standard method.  We will avoid this needless complication.  Any tax benefit arising from exempt income will be readily apparent in the below-normal tax rate calculated by the next ratio.

Ratio 5: income tax ÷ pretax earnings—the effective tax rate.

Ratio 6: total revenue ÷ average assets—the rate of asset turnover.

Ratio 7: average common equity ÷ average assetsthe common equity ratio.  Changes in the common equity ratio will always be examined in conjunction with changes in the preferred equity ratio (average preferred equity ÷ average assets).

Ratio 8: preferred charges ÷ average common equity—the reduction in return on common equity arising from the payment of preferred dividends and preferred stock retirement premiums.

Ratio 9: average common equity ÷ average common shares outstanding—the book value.

 

The Effect of Critical Ratio Value Changes on EPS

We shall now see how the values of these ratios shaped the EPS change of a $66 billion dollar bank holding company headquartered in the Midwest.  The bank's annual report shows that earnings for the latest fiscal year were thirty-one cents per share higher than earnings for the previous fiscal year.

Using the procedure explained below, we can trace those thirty-one cents back to specific increases and decreases in the year-to-year values of the nine critical ratios.  As Exhibit 1, Column D shows (see below):

Ratio 1.  The average interest rate paid on total liabilities increased, costing about 27 cents per share.

Ratio 2.  The loan loss provision rate increased, costing about 15 cents per share.

Ratio 3.  The percent of interest revenue to total revenue increased, costing about one cent per share.  (This is a roundabout way of saying that there was a decrease in the percent of non-interest revenue to total revenue.  For mathematical simplicity, we use the percent of interest revenue rather than non-interest revenue.)

Ratio 4.  The efficiency ratio decreased, adding about 31 cents per share.

Ratio 5.  The tax rate increased, costing about 2 cents per share.

Ratio 6.  The asset turnover increased, adding about 15 cents per share.

Ratio 7.  The common equity ratio decreased (partially offset by an increase in the preferred equity ratio), adding about 12 cents per share.

Ratio 8.  The preferred charge to common equity increased, costing about 2 cents per share.

Ratio 9.  The book value increased, adding about 20 cents per share.

When the positive and negative effects of these ratio changes are summed, the result is $0.31.  Adding this amount to the Previous Year's EPS of $2.45, we arrive at the Latest Year's EPS of $2.76.  Let's find out how the figures were derived.

Exhibit 1—EPS Effect of Year-to-year Changes in Critical Ratios

Column A
Column B
Column C
Column D
Critical Ratio
$ Effect of Changing One Ratio at a Time
x
Coefficient of Ratio Interaction
 =
$ Effect of Changing All Ratios at Once
1
Interest Rate
-$0.29022
x
93.700%
 =
-$0.27194
2
Loan Loss Provision Rate
-$0.16175
x
93.700%
 =
-$0.15156
3
Interest Revenue/Total Revenue
-$0.01249
x
93.700%
 =
-$0.01170
4
Efficiency Ratio
$0.33500
x
93.700%
 =
$0.31390
5
Tax Rate
-$0.02265
x
93.700%
 =
-$0.02122
6
Asset Turnover
$0.16057
x
93.700%
 =
$0.15045
7
Equity Ratio (Preferred + Common)
$0.12615
x
93.700%
 =
$0.11820
8
Preferred Charge to Common Equity
-$0.02585
x
93.700%
 =
-$0.02422
9
Book Value
$0.21793
x
93.700%
 =
$0.20420
10
Sum of All $ Effects
=
$0.32669
=
$0.30611
11
Previous Year's EPS
 +
$2.45198
 +
$2.45198
12
Latest Year's EPS: derived
 =
$2.77867
 =
$2.75809
13
Latest Year's EPS: actual
 -
$2.75809
 -
$2.75809
14
$ over(under)-statement of EPS
 =
$0.02058
 =
$0.00000
15
Coefficient of Ratio Interaction:
93.700%
 = actual $ change in EPS ÷ derived $ change in EPS
 =          [B13 - B11]       ÷              B10                


Continue to Part 2 (of 4)

© 2000-2003 ThinkingApplied.com

Bookmark and Share

About the author
Return to Home Page
E-mail us