Bank Analysis School Case Study

Sunny State Bank

AGRICULTURAL MIX & GROWTH

Agricultural Mix (Single Quarter)

Agricultural Loan Volume & Mix Over Time

800K 1.2M 1.6M 2M 2.4M 2.8M 3.2M

Quarter

20X5 Q4

Metrics

Farmland Ag Production

400K

20X0 Q4

20X1 Q1

20X1 Q2

20X1 Q3

20X1 Q4

20X2 Q1

20X2 Q2

20X2 Q3

20X2 Q4

20X3 Q1

20X3 Q2

20X3 Q3

20X4 Q1

20X4 Q2

20X4 Q3

20X5 Q1

20X5 Q2

20X5 Q3

20X5 Q4

20X3 Q4

20X4 Q4

25.2%

Agricultural Subsets as % of Tier 1 Capital + ALLL

Quarter

20X5 Q4

Farmland

Ag Production

100%

74.8%

80%

60%

40%

16%

20%

6%

Ag Mix and Subsets Qtr

20X5 Q4