|
<br />2007 MONTHLY CASH/GENERAL LEDGER BALANCE RECONCILlATI(
<br /> 2007 Interest 5/31/2007 6/30/2007 7/31/2007 8/31/2007
<br />Bank Checking Statement Balance $ 868,757.06 $ 1,049,995.79 $ 1,647,556.50 $ 909,521.85
<br />Outstanding Deposits $ 0.02 $ 0.02 $ 12,988.14
<br />Outstanding Checks $ (101,475.21) $ (168,777.25) $ (356,833.97) $ (60,366.86)
<br />Monthly Interest $ 39,573.33 $ 3,158.33 $ 2,598.58 $ 5,737.63 $ 4,402.25
<br />Net Checking Account Balance $ 767,281.87 $ 881,218.56 $ 1,303,710.67 $ 849,154.99
<br />Investments
<br />Mainstreet Bank Flex CD
<br /> Beginning $ 268,885.31 $ 268,885.31 $ 51,870.09 $ 151,870.09
<br /> Other T ansactions $ (220,000.00) $ 100,000.00 $ 2,000,000.00
<br /> Monthly Interest $ 5,935.56 $ 2,984.78
<br /> Ending Balance $ 268,885.31 $ 51,870.09 $ 151,870.09 $ 2,151,870.09
<br />Mainstreet Bank CD's
<br /> Beginning
<br /> 1000669381 CDARS
<br /> 5.12% 1002328085 CDARS $ 1,120,602.82
<br /> 5.41 % 1001349356 CDARS $ 3,039,673.91 $ 3,039,673.91 $ 3,039,673.91 $
<br /> Other Transactions
<br /> Monthly Interest - CD $
<br /> Monthly Interest - CDARS $ 120,602.82 $ 80,928.91
<br /> Ending Balance $ 3,039,673.91 $ 3,039,673.91 $ 3,039,673.91 $ 1,120,602.82
<br />Mainstreet Bank - Subtotal $ 4,075,841.09 $ 3,972,762.56 $ 4,495,254.67 $ 4,121,627.90
<br />Smith Barney
<br />Smith Barney Money Fund
<br /> Beginning $ 49,701.84 $ 132,873.17 $ 104,276.39 $ 9,285.93
<br /> Monthly Adjustments $ 61,977.16 $ 3,171.33 $ 5,403.22 $ 5,009.54 $ 9,660.43
<br /> Other Transactions $ 80,000.00 $ (34,000.00) $ (100,000.00) $
<br /> Ending Balance $ 132,873.17 $ 104,276.39 $ 9,285.93 $ 18,946.36
<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 DTD 9/29/03 $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00
<br /> FHLB DTD 6/30/03 $ 100,411.37 $ 100,411.37 $ 100,411.37 $ 100,411.37
<br /> FHLMC DTD 8/14/03 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00
<br /> FHLMC DTD 6/30/03 $ 99,750.00 $ 99,750.00 $ 99,750.00 $ 99,750.00
<br /> FNMA DTD 2/7/03 $ 205,000.00 $ 205,000.00 $ 205,000.00 $ 205,000.00
<br /> FNMA DTD 3/30/04 $ 100,000.12 $ 100,000.12 $ 100,000.12 $ 100,000.12
<br /> FNMA DTD 4/8/04 $ 200,394.17 $ 200,394.17 $ 200,394.17 $ 200,394.17
<br /> FHLB DTD 4/19/04 $ 250,000.00 $ 250,000.00 $ 250,000.00 $ 250,000.00
<br /> FHLM DTD 11/28/03 $ $ $ $
<br /> FHLM DTD 3/25/04 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00
<br /> FHLM DTD 3/17/04 $ 99,937.50 $ 99,937.50 $ 99,937.50 $ 99,937.50
<br /> FHLM DTD 3/24/04 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00
<br /> FHLM DTD 2/27/03 $ 165,000.00 $ 165,000.00 $ 165,000.00 $ 165,000.00
<br /> Other Transactions
<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 $ 457,100.00 $ 377,100.00 $ 281,100.00 $ 281,100.00
<br /> Direct Merchants Bank
<br /> Capitol One Bank
<br /> Hemisphere Natl Bank $ 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 sl. Natl Bk of Nevada $
<br /> Cofe Taylor Bank $ 96,000.00 $ 96,000.00 $ 96,000.00 $ 96,000.00
<br /> Other Transactions
<br /> Monthly Adjustments $
<br /> Ending Balance $ 377,100.00 $ 281.100:1lO__.~ 281 ,100.00 $ 281,100.00
<br />Smith Barney - Subtotal $ 2,280,466.33 $ 2,155,869.55 $ 2,060,879.09 $ 2,070,539.52
<br />Total Cash/lnvestments Per Statement $ 6,356,307.42 $ 6,128,632.11 $ 6,556,133.76 $ 6,192,167.42
<br />General Ledger Cash Balance $ 6,356,307.42 $ 6,128,632.11 $ 6,556,133.76 $ 6,192,167.42
<br />Total Monthly Interest & Adjustments $ 228,088.87 $ 6,329.66 $ -10,986.58 $ 10,747.17 $ 94,991.59
<br />
|