|
<br />2008 MONTHLY CASH/GENERAL LEDGER BALANCE RECONCILIA nONS
<br /> 2008 Interest 1/31/2008 2/29/2008 3/31/2008 4/30/2008
<br />Bank Checking Statement Balance $ 822,161.45 $ 269,787.19 $ 303,692.74 $ 466,315.07
<br />Outstanding Deposits $ (0.30) $ 1,611.00 $
<br />Outstanding Checks $ (236,373.33) $ (1,184,996.39) $ (224,443.78) $ (123,369.65)
<br />Monthly Interest $ 15,530.03 $ 4,443.88 $ 1,244.55 $ 1,208.47 $ 763.83
<br />Net Checking Account Balance $ 585,788.12 $ (915,209.50) $ 80,859.96 $ 342,945.42
<br />Investments
<br />Mainstreet Bank Flex CD
<br /> Beginning $ 3,983,762.27 $ 2,983,762.27 $ 2,983,762.27 $ 1,774,215.68
<br /> Other T ansactions $ (1,000,000.00) $ $ (1,235,000.00) $ (200,000.00)
<br /> Monthly Interest $ 35,877.53 $ 25,453.41
<br /> Ending Balance $ 2,983,762.27 $ 2,983,762.27 $ 1,774,215.68 $ 1,574,215.68
<br />Mainstreet Bank CD's
<br /> Beginning
<br /> 1003302586 CDARS $ 600,000.00 $ 600,000.00
<br /> 1003111039 CDARS $ 675,000.00 $ 675,000.00 $ 675,000.00
<br /> 1003154544 CDARS $ 1,120,602.82 $ 1,149,561.76 $ 1,149,561.76 $ 1,149,561.76
<br /> 1003638274 CDARS
<br /> 1004175111 CDARS
<br /> 1004296636 CDARS
<br /> Monthly Interest - CDARS $ 62,761.14 $ 28,958.94
<br /> Ending Balance $ 1,120,602.82 $ 1,824,561.76 $ 2,424,561.76 $ 2,424,561.76
<br />Mainstreet Bank - Subtotal $ 4,690,153.21 $ 3,893,114.53 $ 4,279,637.40 $ 4,341,722.86
<br />Smith Barney
<br />Smith Bamey Money Fund
<br /> Beginning $ 51,480.52 $ 676,120.30 $ 567,830.28 $ 106,961.07
<br /> Monthly Adjustments $ 21,866.38 $ 1,652.98 $ 2,523.70 $ 4,130.79 $ 6,508.82
<br /> Other Transactions $ 622,986.80 $ (110,813.72) $ (465,000.00) $ 250,000.00
<br /> Ending Balance $ 676,120.30 $ 567,830.28 $ 106,961.07 $ 363,469.89
<br />Smith Bamey Gov't Bonds
<br /> Beginning $ 1,770,493.16 $ 1,155,493.16 $ 600,493.16 $ 500,493.16
<br /> FHLB DTD 9/29/03 $ 100,000.00 $
<br /> FHLB DTD 6130/03 $ 100,411.37 $ 100,411.37 $ 411.37 $ 411.37
<br /> FHLMC DTD 8/14/03 $
<br /> FHLMC DTD 6/30/03 $ 99,750.00 $ 99,750.00 $ 99,750.00 $ 99,750.00
<br /> FNMA DTD 217/03 $ 205,000.00 $
<br /> FNMA DTD 3/30/04 $ 100,000.12 $ 0.12 $ 0.12 $ 0.12
<br /> FNMA DTD 4/8/04 $ 394.17 $ 394.17 $ 394.17 $ 394.17
<br /> FHLB DTD 4/19/04 $ 250,000.00 $ 250,000.00 $ 250,000.00 $
<br /> FHLM DTD 11/28/03 $ $
<br /> FHLM DTD 3/25104 $ 150,000.00 $
<br /> FHLM DTD 3/17/04 $ (62.50) $ (62.50) $ (62.50) $ (62.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 $
<br /> Other Transactions
<br /> Annual Fair Market Adjustments $
<br /> Ending Balance $ 1,155,493.16 $ 600,493.16 $ 500,493.16 $ 250,493.16
<br />Smith Barney CD's
<br /> Beginning $ 281,100.00 $ 281,100.00 $ 281,100.00 $ 281,100.00
<br /> Direct Merchants Bank
<br /> Capitol One Bank $ 90,000.00 $ 90,000.00
<br /> Hemisphere Natl Bank $ $
<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 $ (900.00) $ (900.00)
<br /> Compass Bank
<br /> 1 st. Natl Bk of Nevada
<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 $ 281,100.00 $ 281,100.00 $ 281,100.00 $ 281,100.00
<br />Smith Barney - Subtotal $ 2,112,713.46 $ 1,449,423.44 $ 888,554.23 $ 895,063.05
<br />Total Cashllnvestments Per Statement $ 6,802,866.67 $ 5,342,537.97 $ 5,168,191.63 $ 5,236,785.91
<br />General Ledger Cash Balance $ 6,802,866.67 $ 5,342,537.97 $ 5,168,191.63 $ 5,236,785.91
<br />Total Monthly Interest & Adjustments $ 136,035.08 $ 6,096.86 $ 32,727.19 $ 30,792.67 $ 7,272.65
<br />
|