Bank Analysis School Case Study

Sunny State Bank 12/31/20X6 Budget Summary

20X6 Budget

20X4

20X5

Acct #

Account Description

Summary Budget Loan Income Security Income Other Interest Income

2,486,736 607,232

2,410,302 647,001

2,665,139 628,747

9,056

6,453

6,002

Total Interest Income

3,103,023

3,063,755

3,299,888

Service Charges on Accounts Other Noninterest Income Total Noninterest Income

140,246 325,011 465,256

149,530 276,438 425,968

148,200 281,512 429,712

Total Income

3,568,279

3,489,723

3,729,600

Interest on Trx Accounts Interest on Nontrx Accounts Total Interest Expense

81,638 241,803 323,441

140,345 251,365 391,710

158,461 221,259 379,720

Salaries - EE Benefits

1,453,723 422,402 1,447,616 3,323,740

1,251,974 431,414 1,422,457 3,105,846

1,396,198 422,216 1,230,620 3,049,034

Premises - Fixed Asset Expense Misc Noninterest Expenses Total Noninterest Expenses

Net Income before Taxes

7,215,461

6,987,279

7,158,353

Federal Income Tax Expense

163,523 3,810,705

(38,700)

33,000

Total Expense

3,458,856

3,461,753

Net Income

(242,425)

30,867

267,846

Average Assets Budgeted ROAA

83,550,139

81,530,999

83,500,000

-0.29%

0.04%

0.32%

Page 3 of 3