|
<br />2007 MONTHLY CASH/GENERAL LEDGER BALANCE RECONClUAll0NS
<br /> 2007 Interest 1/3112007 212812007 3/3112007 413012007
<br />Bank Checking statement Balance $ 2,231,704.28 $ 2,184,289.31 $ 1,139,180.91 $ 999,165.22
<br />Outstanding Deposits $ 992.34 $ 0.02 $ 0.02 $ 0.02
<br />Outstanding Checks $ (94,070.87) $ (886,419.20) $ (138,499.23) $ (112,664.71)
<br />Monthly Interest $ 26,834.87 $ 8,899.97 $ 6,737.63 $ 4,342.26 $ 3,696.68
<br />Net Checking Account Balance $ 2,138,625.75 $ 1,297,870.13. $ 1,000,681.70 $ 886,500.53
<br />Investments
<br />MaInstreet Bank Rex CO
<br /> Beginning $ 265,934.53 $ 265,934.53 $ 265,934.53 $ 268,885.31
<br /> Other Tansactlons $
<br /> Monthly Interest $ 2,950.78 $ $ 2,950.78
<br /> ending Balance $ 265,934.53 $ 265,934.53 $ 268,885.31 $ 268,885.31
<br />Malnstreet Bank CD's
<br /> Beginning
<br /> 1000669381 COARS
<br /> 4.24% 1000532637 COARS
<br /> 5.41% 1001349356 COARS $ 3,000,000.00 $ 3,000,000.00 $ 3,039,673.91 $ 3,039,673.91
<br /> Other Transactions
<br /> Monthly Interest - CD $ $ $ $
<br /> Monthly Interest - COARS $ 39,673.91 $ 39,673.91
<br /> EndIng Balance $ 3,000,000.00 $ 3,000,000.00 $ 3,039,673.91 $ 3,039,673.91
<br />MaInstreet Bank - Subtotal $ 5,404,560.28 $ 4,563,804.66 $ 4,309,240.92 $ 4,195,059.75
<br />Smith Barney
<br />Smith Bamey Money Fund
<br /> Beginning $ 10,969.20 $ 15,887.73 $ 25,533.32 $ 38,122.30
<br /> Monthly Adjustments $ 41,903.97 $ 4,918.53 $ 9,645.59 $ 12,588.98 $ 11,579.54
<br /> Other Transactions
<br /> endIng Balance. $ 15,887.73 $ 25,533.32 $ 38,122.30 $ 49,701.84
<br />Smith Barney Gov't Bonds
<br /> Beginning $ 1,770,493.16 $ 1,770,493.16 $ 1,770,493.16 $ 1,770,493.16
<br /> FHLB OTD 9/29103 $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00
<br /> FHLB OTD 6I30I03 $ 100,411.37 $ 100,411.37 $ 100,411.37 $ 100,411.37
<br /> FHLMC OTD 8/14/03 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00
<br /> FHLMC OTD 6/30/03 $ 99,750.00 $ 99,750.00 $ 99,750.00 $ 99,750.00
<br /> FNMA OTD 217103 $ 205,000.00 $ 205,000.00 $ 205,000.00 $ 205,000.00
<br /> FNMA OTD 3130104 $ 100,000.12 $ 100,000.12 $ 100,000.12 $ 100,000.12
<br /> FNMA OTD 4/8/04 $ 200,394.17 $ 200,394.17 $ 200,394.17 $ 200,394.17
<br /> FHLB OTD 4/19104 $ 250,000.00 $ 250,000.00 $ 250,000.00 $ 250,000.00
<br /> FHLM OTD 1 ~128103 $ $ $ $
<br /> FHLM OTD 3/25/04 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00
<br /> FHLM OTD 3/17/04 $ 99,937.50 $ 99,937.50 $ 99,937.50 $ 99,937.50
<br /> FHLM OTD 3/24/04 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00
<br /> FHLM OTD 2127/03 $ 165,000.00 $ 165,000.00 $ 165,000.00 $ 165,000.00
<br /> Other TJ'anSl!Ictlons
<br /> Monthly FaIr Market Adjustments $
<br /> EndIng Balance $ 1,770,493.16 $ 1,770,493.16 $ 1,770,493.16 $ 1,770,493.16
<br />Smith Barney CD's
<br /> BegInning $ 475,100.00 $ 475,100.00 $ 475,100.00 $ 475,100.00
<br /> DIrect Merchants Bank $ $ $ $
<br /> Capitol One Bank $ $ $ $
<br /> Hemisphere NatJ Bank $ 96,000.00 $ 96,000.00 $ 96,000.00 $ 96,000.00
<br /> Lehman Brothers Bank $ 96,000.00 $ 96,000.00 $ 96,000.00 $ 96,000.00
<br /> CIB Bank $ 89,100.00 $ 89,100.00 $ 89,100.00 $ 89,100.00
<br /> Compass Bank $ $ $ $
<br /> 1 st. NatJ Bk of Nevada $ 80,000.00 $ 80,000.00 $ 80,000.00 $ 80,000.00
<br /> Cole Taylor Bank $ 96,000.00 $ 96,000.00 $ 96,000.00 $ 96,000.00
<br /> Other Transactions
<br /> Monthly Adjustments $
<br /> EndIng Balance $ 457,100.00 $ 457,100.00 $ 457,100.00 $ 457,100.00
<br />Smith Barney - Subtotal $ 2,243,480.89 $ 2,253,126.48 $ 2,265,715.46 $ 2,277,295.00
<br />Total Cashllnvestments Per Statement $ 7,648,041.17 $ 6,816,931.14 $ 6,574,956.38 $ 6,472,354.75
<br />General Ledger Cash Balance $ 7,648,041.17 $ 6,816,931.14 $ 6,574,956.38 $ 6,472,354.75
<br />Total Monthly Interest & Adjustments $ 111,363.53 $ 13,818.50 $ 16,383.22 $ 59,555.93 $ 15,276.22
<br />
|