CMS Case Study
Balance Sheet Comparison - 6/30/2021
JUN 21
MAR 21
VARIANCE
Balance Rate
Balance Rate
Balance Rate
Install Fixed - I/O LOC Total Install Fixed
4 5.75
4 5.75
1 --
7,691 6.17
7,982 6.18
-292 -0.01
Install Adj 1M (Prime) Install Adj 1M (Prime) I/O Install Adj 1M (Prime) I/O LOC
764 3.50 247 3.25 1,156 4.63 2,167 4.08
777 3.50 247 3.25 1,138 4.73 2,162 4.12
-13 -- 0 0.00 18 -0.10 5 -0.04
Total Install Adj
TOTAL INSTALLMENTS
9,858 5.71
10,144 5.74
-286 -0.03
Gov&Agy Fixed -
1,537 0.80 22,028 1.00 23,564 0.99
1,560 0.84 22,386 1.00 23,946 0.99
-23 -0.03 -358 -- -381 0.00
Gov&Agy Fixed - PPP Total Gov&Agy Fixed
TOTAL GOV&AGY GUARANTEED
23,564 0.99
23,946 0.99
-381 0.00
Loans Held For Sale (Manual) LOAND HELD FOR SALE
1,622 -- 1,622 --
1,113 -- 1,113 --
509 -- 509 --
Other Loan Items
-482 -- -1,306 -- 265 -- -6,133 -- 390,119 4.25 10,181 -- 16,710 -- 17,429 -- 11,295 -- 55,614 -- -9 --
-383 -- -819 -- 865 -- -21 -- -6,082 -- 396,557 4.31 9,572 -- 15,330 -- 16,664 -- 10,306 -- 51,872 --
-98 -- -487 -- -600 -- 13 -- -51 -- -6,438 -0.06 609 -- 1,379 -- 765 -- 989 -- 3,742 --
Unearned SBA PPP Orig. Fees
Loan Suspense ICPT Loan Adjustment Loan Loss Reserve TOTAL NET LOANS
Cash & Due
BOLI
Fixed Assets Other Assets
TOTAL OTHER ASSETS
TOTAL ASSETS
830,396 2.66
790,352 2.70
40,044 -0.04
Cloyd Bank & Trust - Page 65
Made with FlippingBook PDF to HTML5