|
<br />2007 MONTHLY CASH/GENERAL LEDGER BALANCE RECONaUAnC
<br /> 2007 Interest 9/3012007 10/31/2007 11130/2007 12131/2007
<br />Bank Checking Statement Balance $ 680,707.06 $ 295,959.39 $ 469,617.90 $ 1,636,979.05
<br />Outstanding Deposits $ 0.34 $ 0.34 $
<br />Outstanding Checks $ (391,383.40) $ (129,905.26) $ (189,458.57) $ (69,733.70)
<br />Monthly Interest $ 53,039.00 $ 2,329.67 $ 1,087.93 $ 1 ,295.68 $ 8,752.39
<br />Net Checking Account Balance $ 289,323.66 $ 166,054.47 $ 280,159.67 $ 1,567,245.35
<br />Investments
<br />Mainstreet Bank Flex CD
<br /> Beginning $ 2,151,870.09 $ 2,161,618.09 $ 2,161,618.09 $ 1,961,818.09
<br /> Other T ansactions $ $ (200,000.00) $ 2,000,000.00
<br /> Monthly Interest $ 37,827.74 $ 9,748.00 $ 22,144.18
<br /> Ending Balance $ 2,161,618.09 $ 2,161,618.09 $ 1,961,618.09 $ 3,983,762.27
<br />Mainstreet Bank CD's
<br /> Beginning
<br /> 1000669381 CDARS
<br /> 5.12% 1002328085 CDARS $ 1,120,602.82 $ 1,120,602.82 $ 1,120,602.82 $ 1,120,602.82
<br /> 5.41% 1001349356 CDARS
<br /> Other Transactions
<br /> Monthly Interest - CD $
<br /> Monthly Interest - CDARS $ 120,602.82
<br /> Ending Balance $ 1,120,602.82 $ 1,120,602.82 $ 1,120,602.82 $ 1,120,602.82
<br />Malnstreet Bank - Subtotal $ 3,571,544.57 $ 3,448,275.38 $ 3,362,380.58 $ 6,671,610.44
<br />Smith Barney
<br />Smith Barney Money Fund
<br /> Beginning $ 18,946.36 $ 27,020.03 $ 43,079.50 $ 44,618.88
<br /> Monthly Adjustments $ 94,511.32 $ 8,073.67 $ 16,059.47 $ 1,537.18 $ 8,883.84
<br /> Other Transactions
<br /> Ending Balance $ 27,020.03 $ 43,079.50 $ 44,616.68 $ 51,480.52
<br />Smith Barney Gov't Bonds
<br /> Beginning $ 1,770,493.16 $ 1,770,493.16 $ 1,770,493.16 $ 1,770,493.18
<br /> FHLB OlD 9/29/03 $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00
<br /> FHLB DlD 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 2fT/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. $ 281,100.00 $ 281,100.00 $ 281,100.00 $ 281,100.00
<br /> Direct Merchants Bank
<br /> Capitol One Bank
<br /> Hemisphere NatJ Bank $ $ $ $
<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. NatJ 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,078,613.19 $ 2,094,672.66 $ 2,096,209.84 $ 2,103,073.88
<br />Total Cash/Investments Per Statement $ 5,650,157.76 $ 5,542,948.04 $ 5,458,590.42 $ 8,774,684.12
<br />General Ledger Cash Balance $ 5,650, 157.76 $ 5,542,948.04 $ 5,458,590.42 $ 8,774,684.12
<br />Total Monthly Interest & Adjustments $ 305,980.88 $ 20,151.34 $ 17,147.40 $ 2,832.86 $ 37,780.41
<br />
|