|
<br />2006 MONTHLY CASH/GENERAL LEDGER BALANCE RECONCILlAT
<br /> 2006 Interest 5/31/2006 6/30/2006 7/31/2006
<br />Bank Checking Statement Balance $ 294,770.44 $ 1,274,368.71 $ 1,004,807.57
<br />Outstanding Deposits $ 0.01 $ 0.01
<br />Outstanding Checks $ (141,163.62) $ (883,640.87) $ (507,562.15)
<br />Monthly Interest $ 14,855.51 $ 1,314.32 $ 2,103.75 $ 3,672.17
<br />Net Checking Account Balance $ 153,606.82 $ 390,727.85 $ 497,245.43
<br />Investments
<br />Mainstreet Bank Flex CD
<br /> Beginning $ 1,001,304.48 $ 1,001,304.48 $ 676,138.90
<br /> Other Tansactions $ (336,295.42) $ (300,000.00)
<br /> Monthly Interest $ 7,356.06 $ 11,129.84 $
<br /> Ending Balance $ 1,001,304.48 $ 676,138.90 $ .c';~::376,138.90
<br />Mainstreet Bank CD's
<br /> Beginning $ 3,676,577.55 $ 3,676,577.55 $ 2,599,341.31
<br /> 1000532645 CDARS $ $ $
<br /> 1000669381 CDARS $ 1,104,034.85 $ $
<br /> 1000532637 CDARS $ 2,572,542.70 $ 2,599,341.31 $ 2,599,341.31
<br /> Other Transactions
<br /> Monthly Interest - CD $
<br /> Monthly Interest - CDARS $ 35,541.45 $ 36,468.34 $
<br /> Ending Balance $ 3,676,577.55 $ 2,599,341.31 $ 2,599,341.31
<br />Mainstreet Bank - Subtotal $ 4,831,488.85 $ 3,666,208.06 $ 3,472,725.64
<br />Smith Barney
<br />Smith Bamey Money Fund
<br /> Beginning $ 36,025.39 $ 40,370.79 $ 50,163.12
<br /> Monthly Adjustments $ 38,522.77 $ 4,345.40 $ 9,792.33 $ 1,948.81
<br /> Other Transactions
<br /> Ending Balance $ 40,370.79 $ 50,163.12 $ 52,111.93
<br />Smith Barney Gov't Bonds
<br /> Beginning $ 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
<br /> FHLB DTD 6/30/03 $ 100,411.37 $ 100,411.37 $ 100,411.37
<br /> FHLMC DTD 8/14/03 $ 150,000.00 $ 150,000.00 $ 150,000.00
<br /> FHLMC DTD 6/30103 $ 99,750.00 $ 99,750.00 $ 99,750.00
<br /> FNMA DTD 2/7/03 $ 205,000.00 $ 205,000.00 $ 205,000.00
<br /> FNMA DTD 3/30/04 $ 100,000.12 $ 100,000.12 $ 100,000.12
<br /> FNMA DTD 4/8/04 $ 200,394.17 $ 200,394.17 $ 200,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 $ 150,000.00 $ 150,000.00
<br /> FHLM DTD 3/17/04 $ 99,937.50 $ 99,937.50 $ 99,937.50
<br /> FHLM DTD 3/24/04 $ 150,000.00 $ 150,000.00 $ 150,000.00
<br /> FHLM DTD 2/27/03 $ 165,000.00 $ 165,000.00 $ 165,000.00
<br /> Other Transactions
<br /> Monthly Adjustments $
<br /> Ending Balance $ 1,770,493.16 $ 1,770,493.16 $ 1,770,493.16
<br />Smith Barney CD's
<br /> Beginning $ 657,100.00 $ 657,100.00 $ 557,100.00
<br /> Direct Merchants Bank $ 100,000.00 $ $
<br /> Capitol One Bank $ 100,000.00 $ 100,000.00 $ 100,000.00
<br /> Hemisphere Natl Bank $ 96,000.00 $ 96,000.00 $ 96,000.00
<br /> Lehman Brothers Bank $ 96,000.00 $ 96,000.00 $ 96,000.00
<br /> CIB Bank $ 89,100.00 $ 89,100.00 $ 89,100.00
<br /> Compass Bank $ $ $
<br /> 1st. Nail Bk of Nevada $ 80,000.00 $ 80,000.00 $ 80,000.00
<br /> Cole Taylor Bank $ 96,000.00 $ 96,000.00 $ 96,000.00
<br /> Other Transactions
<br /> Monthly Adjustments $
<br /> Ending Balance $ 657,100.00 $ 557,100.00 $ ...:.c ~557,tO.0.00
<br />Smith Barney - Subtotal $ 2,467,963.95 $ 2,377,756.28 $ 2,379,705.09
<br />Total Cashllnvestments Per Statement $ 7,299,452.80 $ 6,043,964.34 $ 5,852,430.73
<br />General Ledger Cash Balance $ 7,299,452.80 $ 6,043,964.34 $. 5,852,430.73
<br />Total Monthly Interest $ 96,275.79 $ 5,659.72 $ 59,494.26 $ 5,620.98
<br />
|