ThinkingApplied.com

Mind Tools: Applications and Solutions 
Understanding Banks'
Earnings:
An Evaluation & Forecasting Technique
Part 1
Download
complete article as PDF file
The yeartoyear 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 dollarandcents 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.
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: noninterest expense ÷ total revenue less interest expense—commonly 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 belownormal 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 assets—the 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.
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 thirtyone cents per share higher than earnings for the previous fiscal year.
Using the procedure explained below, we can trace those thirtyone cents back to specific increases and decreases in the yeartoyear 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 noninterest revenue to total revenue. For mathematical simplicity, we use the percent of interest revenue rather than noninterest 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 Yeartoyear 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 Equit 
$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 EP 
=

$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) 
© 20002003 ThinkingApplied.com