|
<br />2006 MONTHLY CASH/GENERAL LEDGER BALANCE RECONCILIATIONS
<br /> 2006 Interest 1/31/2006 2/28/2006 3/31/2006 413012006
<br />Bank Checking Statement Balance $ 803,247.18 $ 576,893.86 $ 550,921.59 $ 419,865.91
<br />OufstandIng Deposits $ $ $ 0.40 $
<br />OUtstanding Checks $ (67,n1.16) $ (63,380.72) $ (36,184.21) $ (111,439.11)
<br />Monthly Interest $ 54,083.60 $ 2,751.26 $ 1,773.36 $ 1,915.44 $ 1,325.21
<br />Net Checking Account Balance $ 735,476.02 $ 513,513.14 $ 514,737.78 $ 308,426.80
<br />Investments
<br />Malnstreet Bank Rex CD
<br /> Beginning $ 823,948.42 $ 823,948.42 $ 993,948.42 $ 1,001,304.48
<br /> Other Tansactions $ $ 170,000.00 $
<br /> Monthly Interest $ 26,053.47 $ $ $ 7,356.06
<br /> Ending Balance $ 823,948.42 $ 993,948.42 $ 1,001,304.48 $ 1,001,304.48
<br />Malnstreet Bank CD's
<br /> Beginning $ 3,641,036.10 $ 3,641,036.10 $ 3,641,036.10 $ 3,676,5n.55
<br /> 1000669381 CDARS $ 1,094,725.69 $ 1,094,725.69 $ $
<br /> 4.24% 1000532637 CDARS $ 1,104,034.85 $ 1,104,034.85
<br /> 5.41 % 1001349356 CDARS $ 2,546,310.41 $ 2,546,310.41 $ 2,572,542.70 $ 2,572,542.70
<br /> Other Transactions
<br /> Monthly Interest - CD $ $ $ $
<br /> Monthly Interest - CDARS $ 117,396.54 $ $ $ 35,541.45
<br /> Ending Balance $ 3,641,036.10 $ 3,641,036.10 $ 3,676,577.55 $ 3,676,577.55
<br />Malnstreet Bank. Subtotal $ 5,200,460.54 $ 5,148,497.66 $ 5,192,619.81 $ 4,986,308.83
<br />Smith Barney
<br />Smith Barney Money Fund
<br /> Beginning $ 167,502.62 $ 170,287.32 $ 11,183.42 $ 23,972.05
<br /> Monthly Adjustments $ 98,466.58 $ 2,764:70 $ 10,896.10 $ 12,788.63 $ 12,053.34
<br /> Other Transactions $ $ (170,000.00) $
<br /> Ending Balance $ 170,287.32 $ 11,183.42 $ 23,972.05 $ 36,025.39
<br />Smith Barney Gov't Bonds
<br /> Beginning $ 1,nO,493.16 $ 1,nO,493.16 $ 1,nO,493.16 $ 1,nO,493.16
<br /> FHLB DID 9129103 $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00
<br /> FHLB DID 6130103 $ 100,411.37 $ 100,411.37 $ 100,411.37 $ 100,411.37
<br /> FHLMC DID 8/14/03 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00
<br /> FHLMC DTD 6130103 $ 99,750.00 $ 99,750.00 $ 99,750.00 $ 99,750.00
<br /> FNMA DID 217103 $ 205,000.00 $ 205,000.00 $ 205,000.00 $ 205,000.00
<br /> FNMA DTD 3130104 $ 100,000.12 $ 100,000.12 $ 100,000.12 $ 100,000.12
<br /> FNMA DID4/8/04 $ 200,394.17 $ 200,394.17 $ 200,394.17 $ 200,394.17
<br /> FHLB DID 4/19/04 $ 250,000.00 $ 250,000.00 $ 250,000.00 $ 250,000.00
<br /> FHLM DID 11/28/03 $ $ $ $
<br /> FHLM DID 3/25/04 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00
<br /> FHLM DID 3/17/04 $ 99,937.50 $ 99,937.50 $ 99,937.50 $ 99,937.50
<br /> FHLM DID 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 Adjustments $
<br /> Ending Balance $ 1,nO,493.16 $ 1,nO,493.16 $ 1,nO,493.16 $ 1,nO,493.16
<br />Smith Barney CD's
<br /> Beginning $ 657,100.00 $ 657,100.00 $ 657,100.00 $ 657,100.00
<br /> DIrect Merchants Bank $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00
<br /> Capitol One Bank $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00
<br /> Hemisphere NatI Bank $ 96,000.00 $ 96,000.00 $ 96,opO.OO $ 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 /> 1st NatI Bk of Nevada $ 80,000.00 $ 80,000.00 $ 80,000.00 $ 80,000.00
<br /> Cole Taylor Bank $ 96,000.00 $ 98,000.00 $ 96,000.00 $ 96,000.00
<br /> Other Transactions
<br /> Monthly Adjustments $
<br /> Ending Balance $ 657,100.00 $ 657,100.00 $ 657,100.00 $ 657,100.00
<br />Smith Barney . Subtotal $ 2,597,880.48 $ 2,438,n6.58 $ 2,451,565.21 $ 2,463,618.55
<br />Total CasMnvestments Per Statement $ 7,798,341.02 $ 7,587,274.24 $ 7,644,185.02 $ 7,449,927.38
<br />General Ledger Cash Balance $ 7,798,341.02 $ 7,587,274.24 $ 7,644,185.02 $ 7,449,927.38
<br />Total Monthly Interest & Adjustments $ 296,000.19 $ 5,535.96 $ 12,669.48 $ 57,601.58 $ 13,378.55
<br />
|