|
<br />2007 MONTHLY CASHIGENERAl. LEDGER BALANCE RECONQUATIONS
<br /> 2007 Interest 1/31/2007 2/2812007 3/31/2007 4130/2007
<br />Bank Checking Statement Balance $ 2,231,704.28 $ 2.184,289.31 $ 1.139.180.91 $ 999,186.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,684.71)
<br />Monthly Interest $ 23,676.54 $ 8,899.97 $ 6,737.63 $ 4,342.26 $ 3,618.68
<br />Net Checking Account Balance $ 2,138,625.75 $ 1,297,870.13 $ 1,000,681.70 $ 888,500.53
<br />Investments
<br />Malnstreet 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 CO'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,03I,m.I1
<br /> Other Transactions
<br /> Monthly Interest - CO $ $ $ $
<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,038,873.11
<br />Malnstreet Bank - Subtotal $ 5,404,560.28 $ 4,563,804.66 $ 4,309,240.92 $ 4,196,069.76
<br />Smith Barney
<br />SmUh Barney Money Fund
<br /> Beginning $ 10,969.20 $ 15,887.73 $ 25,533.32 $ 38,122.30
<br /> Monthly Adjustments $ 38,732.64 $ 4,918.53 $ 9,645.59 $ 12,588.98 $ 11,678.64
<br /> Other Transactions
<br /> Ending Balance $ 15,887.73 $ 25,533.32 $ 38,122.30 $ 48,701.84
<br />SmUh Barney Gov't Bonds
<br /> Beginning $ 1,nO,493.16 $ 1,nO,493.16 $ 1,nO,493.16 $ 1,770,483.18
<br /> FHLB OTD 9129103 $ 100,000.00 $ 100,OOQ.OO $ 100,000.00 $ 100,000.00
<br /> FHLB OTD 6130/03 $ 100,411.37 $ 100,411.37 $ 100,411.37 $ 100,411.37
<br /> FHLMC OTD 8f14/03 $ 150,000.00. $ 150,000.00 $ 150,000.00 $ 160,000.00
<br /> FHLMC OTD 6130/03 $ 99,750.00 $ 99,750.00 $ 99,750.00 $ 98,7&0.00
<br /> FNMA OTD 217103 $ 205,000.00 $ 205,000.00 $ 205,000.00 $ 206,000.00
<br /> FNMA OTD 3I30I04 $ 100,000.12 $ 100,000.12 $ 100,000.12 $ 100,000.12
<br /> FNMA OTD 418/04 $ 200,394.17 $ 200,394.17 $ 200.394.17 $ 200,394.17
<br /> FHLB OTO 4/19/04 $ 250,000.00 $ 250,000.00 $ 250,000.00 $ 2&0,000.00
<br /> FHLM OTD 11/28103 $ $ $ $
<br /> FHLM OTD 3/25104 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 1&0,000.00
<br /> FHLM OTD 3/17/04 $ 99,937.50 $ 99,937.50 $ 99,937.50 $ 98,837.60
<br /> FHLM OTD 3i24J04 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 160,000.00
<br /> FHLM OTD 2/27/03 $ 165,000.00 $ 165;000.00 $ 165,000.00 $ 186,000.00
<br /> Other Transactions
<br /> Monthly Fair Market Adjustments $
<br /> EndIng Balance $ 1,nO,493.16 $ 1,nO,493.16 $ 1,nO,493.16 $ 1,770,483.18
<br />SmUh Barney CD's
<br /> Beginning $ 475,100.00 $ 475,100.00 $ 475,100.00 $ 47&,100.00
<br /> DJntct Merchants Bank $ $ $ $
<br /> Capitol One Bank $ $ $ $
<br /> Hemisphere Nail Bank $ 96,000.00 $ 96,000.00 $ 96.000.00 $ 98,000.00
<br /> Lehman Brothers Bank $ 96,000.00 $ 96,000.00 $ 96.000.00 $ 98,000.00
<br /> CIB Bank $ 89,100.00 $ 89,100.00 $ 89,100.00 $ 89,100.00
<br /> Compass Bank $ $ $ $
<br /> 1 st. Nail Bk of Nevada $ 80,000.00 $ SO,OOO.OO $ 80,000.00 $ 80,000.00
<br /> Cole Taylor Bank $ 96,000.00 $ 96,000.00 $ 96.000.00 $ 98,000.00
<br /> Other Transactions
<br /> Monthly Adjustments $
<br /> Ending Balance $ 457,100.00 $ 457,100.00 $ 457,100.00 $ 467,100.00
<br />Smith Barney - Subtotal $ 2,243,480.89 $ 2,253,126.48 $ 2,265.715.46 $ 2,277,295.00
<br />Total CasMnvestments Per Statement $ 7,648,041.17 $ 6,816,931.14 $ 6,574,956.38 $ 8,472,354.76
<br />General Ledger Cash Balance $ 7,648,041.17 $ 6,816,931.14 $ 6,574,956.38 $ 8,472,364.76
<br />Total Monthly Interest & Adjustments $ 105,033.87 $ 13,818.50 $ 16,383.22 $ 59,555.93 $ 16,278.22
<br />
|