|
<br />2008 MONTHLY CASH/GENERAL LEDGER BALANCE RECONCILIA nONS
<br /> 2008 Interest 5/31/2008 6/30/2008 7/31/2008 8/31/2008
<br />Bank Checking Statement Balance $ 1,080,097.20 $ 306,244.12 $ 1,584,635.74 $ 1,632,393.89
<br />Outstanding Deposits $ (3,522.80)
<br />Outstanding Checks $ (654,752.61) $ (220,287.73) $ (79,816.75) $ (174,487.15)
<br />Monthly Interest $ 15,530.03 $ 962.86 $ 1,021.41 $ 2,690.19 $ 3,194.84
<br />Net Checking Account Balance $ 425,344.59 $ 82,433.59 $ 1,504,818.99 $ 1,457,906.74
<br />Investments
<br />Mainstreet Bank Flex CD
<br /> Beginning $ 1,574,215.68 $ 887,215.68 $ 897,639.80 $ 697,639.80
<br /> Other T ansactions $ (687,000.00) $ (200,000.00)
<br /> Monthly Interest $ 35,877.53 $ 10,424.12
<br /> Ending Balance $ 887,215.68 $ 897,639.80 $ 697,639.80 $ 697,639.80
<br />Mainstreet Bank CD's
<br /> Beginning
<br /> 1003302586 CDARS $ 600,000.00 $ 600,000.00 $ 600,000.00 $ 600,000.00
<br /> 1003111039 CDARS $ 675,000.00 $ 675,000.00 $ 675,000.00 $
<br /> 1003154544 CDARS $ 1,149,561.76 $ 1,149,561.76 $ 1,149,561.76
<br /> 1003638274 CDARS $ 350,000.00 $ 350,000.00 $ 350,000.00 $ 350,000.00
<br /> 1004175111 CDARS $ 687,505.19
<br /> 1004296636 CDARS $ 1,170,858.77
<br /> Monthly Interest - CDARS $ 62,761.14 $ 33,802.20
<br /> Ending Balance $ 2,774,561.76 $ 2,774,561.76 $ 2,774,561.76 $ 2,808,363.96
<br />Malnstreet Bank - Subtotal $ 4,087,122.03 $ 3,754,635.15 $ 4,977,020.55 $ 4,963,910.50
<br />Smith Barney
<br />Smith Barney Money Fund
<br /> Beginning $ 363,469.89 $ 1,596.50 $ 102,200.26 $ 102,852.33
<br /> Monthly Adjustments $ 21,866.38 $ 1,126.61 $ 4,603.76 $ 652.07 $ 667.65
<br /> Other Transactions $ (363,000.00) $ 96,000.00 $
<br /> Ending Balance $ 1,596.50 $ 102,200.26 $ 102,852.33 $ 103,519.98
<br />Smith Barney Gov't Bonds
<br /> Beginning $ 250,493.16 $ 250,493.16 $ 250,493.16 $ 250,493.16
<br /> FHLB DTD 9/29/03
<br /> FHLB DTD 6/30/03 $ 411.37 $ 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
<br /> FNMA DTD 3/30/04 $ 0.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 $ $ $ $
<br /> FHLM DTD 11/28/03
<br /> FHLM DTD 3/25/04
<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 $ 250,493.16 $ 250,493.16 $ 250,493.16 $ 250,493.16
<br />Smith Barney CD's
<br /> Beginning $ 281,100.00 $ 281,100.00 $ 185,100.00 $ 185,100.00
<br /> Direct Merchants Bank
<br /> Capitol One Bank $ 90,000.00 $ 90,000.00 $ 90,000.00 $ 90,000.00
<br /> Hemisphere Natl Bank
<br /> Lehman Brothers Bank $ 96,000.00 $ $ $
<br /> CIB Bank $ (900.00) $ (900.00) $ (900.00) $ (900.00)
<br /> Compass Bank
<br /> 1 st. Nall 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 $ 185,100.00 $ 185,100.00 $ 185,100.00
<br />Smith Barney - Subtotal $ 533,189.66 $ 537,793.42 $ 538,445.49 $ 539,113.14
<br />Total Cashllnvestments Per Statement $ 4,620,311.69 $ 4,292,428.57 $ 5,515,466.04 $ 5,503,023.64
<br />General Ledger Cash Balance $ 4,620,311.69 $ 4,292,428.57 $ 5,515,466.04 $ 5,503,023.64
<br />Total Monthly Interest & Adjustments $ 136,035.08 $ 2,089.47 $ 16,049.29 $ 3,342.26 $ 37,664.69
<br />
|