Question

The financial statements for People’s National Bank (PNB) are shown below:

Peoples’ National Bank
Balance Sheet
As of December 31, 20XX
Assets Liabilities & Equity
Cash 600 Demand deposits 5,590
Demand Deposits from other FIs 1,890 Small time deposits 9,867
Investment 3,680 Jumbo CDs 3,198
Federal funds sold 1,988 Federal funds purchased 2,500
Loans 16,145 Equity 3,728
Reserve for loan losses (1,040)
Premises 1,620
Total Assets 24,883 Total Liabilities and Equity 24,883
Peoples’ National Bank
Income Statement
For the Year Ended December 31, 20XX
Interest on fees and loan 1,200
Interest on investment securities 700
Interest on repurchase agreement 780
Interest on deposits in banks 265
Total Interest Income 2,945
Interest on deposits 945
Interest on debentures 689
Total Interest Expense 1,634
Provision for loan losses 140
Noninterest income 185
Noninterest expense 281
Total 236
Income before taxes 1,075
Taxes 215
Net Income 860
Analyze the following eight ratios for PNB’s financial statements:
Earning Assets, Return on Assets, Total Operating Income, Asset Utilization, Net Interest Margin, Spread, Overhead Efficiency, and Tax Ratios.

Answer 1

Earning Assets ratio = Earning Assets/Total assets

Total asset = 24,883: Earning Assets = 1890 + 3680 + 1988 + 16145 = 23703

Earning Assets ratio = 23703 / 24,883

Earning Assets ratio = 0.9525781

Earning Assets ratio = 95.25%

Return on Assets = Net income / Total assets

Return on Assets = 860 / 24,883

Return on Assets = 0.034561748985251

Return on Assets = 3.456%

Total Operating Income = Operating income / Interest income

Total Operating Income = 1075 / 2945

Total Operating Income = 0.365025467

Total Operating Income = 36.50%

Net Interest Margin = (Interest income - Interest expenses) / Average earnin asset

Net Interest Margin = (2,945-1,634) / 23,703

Net Interest Margin = 1,311 / 23,703

Net Interest Margin = 0.0553094544994305

Net Interest Margin = 5.53%

Assets utilization ratio = Revenue / Total assets

Assets utilization ratio = 2,945 / 24,883

Assets utilization ratio = 0.1183538962343769

Assets utilization ratio = 11.84%

Overhead efficiency ratio = 281 / 3,130

Overhead efficiency ratio = 0.089776357827476

Overhead efficiency ratio = 8.98%

Tax ratio = Tax expenses / Income

Tax ratio = 215 / 1,075

Tax ratio = 0.2

Tax ratio = 20%