HomeMy WebLinkAbout04 - Investments STAGECOACH SWEEP
WELLS FARGO BANK, N.A.
Con firmation
Repurchase Agreement
CITY OF BROOKLYN CENTER
6301 SHINGLE CREEK PKWY
BROOKLYN CENTER MN 55430 -2113
ACCOUNT SUMMARY
Date 12/31/2007
Account 1010016
ACCOUNT DETAIL
Investment Repurchase Agreement
From Date 12/31/2007
To Date 01/02/2008
Rate 1.87500000 0
Principal $ 575,259.58
Interest $ 59.92
REPURCHASE AGREEMENT DETAIL
Collateralized By $ 619,927.74
FNCL 00950891
Due 6.00 %
Maturity Date 10/01/2037
CUSIP 31413N2Y0
Sequence 008563
Price 101.574219
Accrued Interest $ 3,099.64
INVESTMENTS NOT FDIC INSURED
CITY OF BROOKLYN CENTER
CASH AND INVESTMENT BALANCES BY MONTH
2007
FUND NAME Jan Feb Mar Apr May Jun Jul
10100 GENERAL $ 6,948,652.55 $ 6,038,021.09 $ 4,677,688.00 $ 3,855,629.51 $ 2,772,339.59 $ 6,149,219.57 $ 6,756,728.04
46321 HRA 1,984.29 1,984.29 1,984.29 1,984.29 1,984.29 1,984.29 126,813.71
46310 EDA 1,801,924.51 1,790,539.97 1,718,624.30 1,702,462.17 1,692,576.34 1,683,707.49 1,647,682.66
46323 CDBG - - - - - - -
42190 POLICE FORFEITURE 55,751.47 53,855.48 54,065.25 53,949.59 45,285.68 46,532.99 46,030.16
46411 TIF DISTRICT #1 410,221.26 411,105.04 412,706.34 413,826.65 415,472.85 417,119.98 517,762.32
46412 TIF DISTRICT #2 4,672.27 4,382.39 3,293.87 2,328.93 2,338.19 2,349.06 320,944.39
46413 TIF DISTRICT #3 18,804,748.48 18,791,434.67 15,011,376.68 14,950,938.73 14,938,431.00 14,947,894.96 15,227,807.70
46414 TIF DISTRICT #4 95,382.20 - - - - - -
28600 CITY INITIATIVES GRANT 138,236.12 148,922.18 134,056.81 128,138.71 153,882.00 127,773.91 134,569.06
TOTAL SPECIAL REV 21,312,920.60 21,202,224.02 17,336,107.54 17,253,629.07 17,249,970.35 17,227,362.68 18,021,610.00
47513 GO IMP BONDS -1996A 320,702.90 321,393.82 322,645.69 323,824.41 323,812.58 325,096.32 -
47514 GO IMP BONDS -1997A 13,977.22 14,007.33 13,598.39 13,455.20 13,508.72 13,499.77 367,799.74
47516 GO IMP BONDS -1998A 196,018.91 196,441.21 196,960.37 197,874.48 198,661.62 200,433.02 225,652.51
47518 GO IMP BONDS -1999A 176,665.44 177,046.05 177,118.03 178,236.27 178,945.29 180,216.71 232,220.26
47519 GO IMP BONDS -2000A 437,907.98 439,329.31 441,107.30 442,792.72 445,421.15 447,187.01 465,492.65
47520 GO IMP BONDS -2001A 290,804.82 293,863.33 292,994.71 296,478.60 298,573.99 299,757.68 317,077.64
47521 GO IMP BONDS -2003A 157,513.21 158,109.34 160,882.44 162,964.29 163,612.56 164,261.20 210,455.23
47522 GO IMP BONDS -2004C 299,805.11 300,451.01 307,448.00 310,553.71 311,789.09 318,202.37 356,618.66
47523 GO BLDG REF -POL &FIRE 2004, 449,085.31 450,052.82 451,374.58 453,103.88 454,906.32 456,709.78 771,230.79
47524 GO IMP BONDS -2006A 241,077.51 267,417.76 268,919.41 274,555.51 278,728.49 279,833.50 348,505.99
47614 GO TIF REF -2004B - - - - - - -
47615 GO TIF BONDS -2004D - - - - - - -
TOTAL DEBT SERVICE 2,583,558.41 2,618,111.98 2,633,048.92 2,653,839.07 2,667,959.81 2,685,197.36 3,295,053.47
40100 CAPITAL IMPROVEMENTS 575,130.60 570,071.72 569,892.21 572,329.86 580,716.44 572,236.63 573,735.83
40200 MUNICIPAL STATE AID CONST 262,795.36 364,417.61 365,837.06 306,426.08 725,244.98 726,446.83 769,679.14
40600 CAPITAL RESERVE EMERGEN( 1,326,629.88 1,362,595.84 1,343,553.05 1,349,299.94 1,490,578.84 1,496,488.19 1,502,153.78
40700 INFRASTRUCTURE CONSTRU( - - - - - - -
40800 EBHC CAPITAL 217,490.87 196,805.08 197,571.66 198,416.75 199,206.05 429,995.80 431,623.73
40900 STREET RECONSTRUCTION 1,815,313.27 1,983,759.72 1,991,486.69 2,165,947.90 2,174,564.03 2,183,185.02 2,255,942.96
41000 TECHNOLOGY 486,430.86 487,478.83 488,602.18 490,692.12 492,644.09 478,783.93 479,232.57
TOTAL CAPITAL PROJECTS 4,683,790.84 4,965,128.80 4,956,942.85 5,083,112.65 5,662,954.43 5,887,136.40 6,012,368.01
49141 WATER UTILITY 1,177,192.68 1,284,643.27 1,396,721.54 1,397,681.91 1,299,164.41 1,363,419.60 1,492,479.01
49251 SEWER UTILITY 2,453,495.91 2,554,621.67 2,474,108.03 2,546,246.73 2,255,221.15 2,209,236.48 2,336,451.73
49611 /12 BROOKLYN CENTER LIQUOR 966,017.03 1,062,765.57 1,005,328.33 1,027,716.53 981,956.75 1,077,787.66 1,146,223.91
49721 CENTERBROOK GOLF COURSI 69,939.43 60,746.58 57,026.13 66,404.83 74,783.06 88,429.36 108,945.13
49851 EARLE BROWN HERITAGE CEf 1,106,933.72 1,043,530.74 1,083,602.86 1,172,652.81 1,274,920.58 1,151,255.27 1,238,660.88
49411 STORM SEWER UTILITY 1,607,989.51 1,677,579.46 1,720,765.38 1,823,205.63 1,941,344.75 1,987,015.67 2,103,124.40
49571 STREET LIGHT UTILITY 141,495.08 143,411.75 138,832.59 147,854.60 160,714.51 159,107.21 167,485.97
49311 RECYCLING 39,097.56 39,774.91 28,435.42 28,734.67 35,770.95 25,139.63 24,801.15
TOTAL ENTERPRISE S 7,562,160.92 7,867,073.95 7,904,820.28 8,210,497.71 8,023,876.16 8,061,390.88 8,618,172.18
49951 CENTRAL GARAGE 4,994,324.28 4,916,734.51 4,977,272.39 4,825,296.19 4,850,364.35 4,240,677.67 4,327,684.62
49961 EMPLOYEE RETIREMENT BENI 1,495,136.14 1,490,758.31 1,479,321.19 1,489,471.66 1,488,006.57 1,486,621.48 1,485,902.93
49971 COMPENSATED ABSENCES 964,248.19 966,325.57 970,089.52 974,238.96 978,114.48 981,992.18 976,967.04
TOTAL INTERNAL SER FND 7,453,708.61 7,373,818.39 7,426,683.10 7,289,006.81 7,316,485.40 6,709,291.33 6,790,554.59
GRAND TOTAL $ 50,544,791.93 $ 50,064,378.23 $ 44,935,290.69 $ 44,345,714.82 $ 43,693,585.74 $ 46,719,598.22 $ 49,494,486.29
90400 PAYROLL 83,985.49 42,907.10 346,298.63 468,706.00 568,254.58 115,170.56 27,730.10
NEGATIVE BALANCES (335,442.76) (372,123.82) (399,115.68) (346,177.30) (443,598.89) (520,112.54) (1,011,944.76)
TOTAL POOLED C & 1 $ 50,293,334.66 $ 49,735,161.51 $ 44,882,473.64 $ 44,468,243.52 $ 43,818,241.43 $ 46,314,656.24 $ 48,510,271.63
INTEREST TO BE ALLOCATED
SOURCE OF INTEREST Jan Feb Mar Apr May Jun Jul
90300 INTEREST ON INVESTMENTS $ 108,893.71 $ 195,006.39 $ 192,205.42 $ 176,406.96 $ 173,221.77 $ 176,876.71 $ 193,940.11
MARKET INTEREST -FAIR VALU - - - - - - -
ACCRUED INTEREST - - - - - - -
TOTAL INTEREST 108,893.71 195,006.39 192,205.42 176,406.96 173,221.77 176,876.71 193,940.11
Interest allocation 1
CITY OF BROOKLYN CENTER
INTEREST ALLOCATION BY MONTH
2007
BU FUND NAME Jan Feb Mar Apr May Jun Jul
10100 GENERAL $ 14,970.18 $ 23,518.79 $ 20,008.27 $ 15,337.67 $ 10,990.85 $ 23,280.46 $ 26,475.70
46321 H RA - - - - - - -
46310 EDA 3,886.34 6,982.08 7,359.70 6,780.28 6,718.03 6,381.90 6,953.22
46323 CDBG - - - - - - -
42190 POLICE FORFEITURE 120.11 209.77 231.26 214.61 179.53 176.17 180.37
46411 TIF DISTRICT #1 883.78 1,601.30 1,765.30 1,646.20 1,647.13 1,579.18 2,028.81
46412 TIF DISTRICT #2 10.07 17.07 14.09 9.26 9.27 8.89 1,257.59
46413 TIF DISTRICT #3 40,512.95 73,194.75 64,209.40 59,474.74 59,222.91 56,591.55 59,668.92
46414 TIF DISTRICT #4 205.49 - - - - - -
28600 CITY INITIATIVES GRANT 297.82 580.07 573.41 509.73 610.06 483.74 527.30
TOTAL SPECIAL REV 45,916.56 82,585.04 74,153.16 68,634.82 68,386.93 65,221.43 70,616.21
47513 GO IMP BONDS -1996A 690.92 1,251.87 1,380.08 1,288.17 1,283.74 1,230.79 -
47514 GO IMP BONDS -1997A 30.11 54.56 58.17 53.52 53.55 51.11 1,441.19
47516 GO IMP BONDS -1998A 422.30 765.16 842.47 787.14 787.59 758.82 884.20
47518 GO IMP BONDS -1999A 380.61 689.61 757.60 709.02 709.42 682.29 909.94
47519 GO IMP BONDS -2000A 943.43 1,711.24 1,886.78 1,761.43 1,765.86 1,693.01 1,824.00
47520 GO IMP BONDS-2001A 626.51 1,144.63 1,253.25 1,179.39 1,183.69 1,134.86 1,242.44
47521 GO IMP BONDS -2003A 339.35 615.85 688.16 648.27 648.64 621.88 824.65
47522 GO IMP BONDS -2004C 645.90 1,170.29 1,315.07 1,235.38 1,236.08 1,204.69 1,397.38
47523 GO BLDG REF -POL &FIRE 2004, 967.51 1,753.01 1,930.70 1,802.44 1,803.46 1,729.07 3,022.00
47524 GO IMP BONDS -2006A 519.38 1,041.62 1,150.27 1,092.18 1,105.01 1,059.43 1,365.59
47614 GO TIF REF -2004B - - - - - - -
47615 GO TIF BONDS -2004D - - - - - - -
TOTAL DEBT SERVICE 5,566.02 10,197.84 11,262.55 10,556.94 10,577.04 10,165.95 12,911.39
40100 CAPITAL IMPROVEMENTS 1,239.06 2,220.49 2,437.65 2,276.72 2,302.23 2,166.44 2,248.14
40200 MUNICIPAL STATE AID CONST 566.17 1,419.45 1,564.82 1,218.96 2,875.21 2,750.27 3,015.92
40600 CAPITAL RESERVE EMERGEN( 2,858.09 5,307.46 5,746.89 5,367.51 5,909.35 5,665.59 5,886.07
40700 INFRASTRUCTURE CONSTRUC - - - - - - -
40800 EBHC CAPITAL 468.56 766.58 845.09 789.30 789.75 1,627.93 1,691.28
40900 STREET RECONSTRUCTION 3,910.91 7,726.97 8,518.35 8,616.13 8,620.99 8,265.37 8,839.73
41000 TECHNOLOGY 1,047.97 1,898.78 2,089.94 1,951.97 1,953.07 1,812.64 1,877.83
TOTAL CAPITAL PROJECTS 10,090.76 19,339.73 21,202.74 20,220.59 22,450.60 22,288.24 23,558.97
49141 WATER UTILITY 2,536.14 5,003.83 5,974.31 5,559.97 5,150.49 5,161.80 5,848.16
49251 SEWER UTILITY 5,285.81 9,950.54 10,582.71 10,128.95 8,940.75 8,363.99 9,155.20
49611 /12 BROOKLYN CENTER LIQUOR 2,081.19 4,139.60 4,300.18 4,088.25 3,892.94 4,080.42 4,491.38
49721 CENTERBROOK GOLF COURSI 150.68 236.61 243.92 264.16 296.47 334.79 426.89
49851 EARLE BROWN HERITAGE CEf 2,384.78 4,064.67 4,634.98 4,664.81 5,054.38 4,358.56 4,853.59
49411 STORM SEWER UTILITY 3,464.25 6,534.36 7,360.37 7,252.70 7,696.40 7,522.68 8,240.92
49571 STREET LIGHT UTILITY 304.84 558.60 593.84 588.16 637.15 602.37 656.28
49311 RECYCLING 84.23 154.93 121.63 114.31 141.81 95.18 97.18
TOTAL ENTERPRISE 16,291.92 30,643.14 33,811.94 32,661.31 31,810.39 30,519.79 33,769.60
49951 CENTRAL GARAGE 10,759.77 19,151.23 21,289.70 19,195.00 19,229.11 16,054.87 16,957.68
49961 EMPLOYEE RETIREMENT BENI 3,221.12 5,806.67 6,327.62 5,925.11 5,899.15 5,628.23 5,822.39
49971 COMPENSATED ABSENCES 2,077.38 3,763.95 4,149.44 3,875.52 3,877.70 3,717.74 3,828.17
TOTAL INTERNAL SERVICE 16,058.27 28,721.85 31,766.76 28,995.63 29,005.96 25,400.84 26,608.24
$ 108,893.71 $ 195,006.39 $ 192,205.42 $ 176,406.96 $ 173,221.77 $ 176,876.71 $ 193,940.11
Interest allocation 2
CITY OF BROOKLYN CENTER
CASH AND INVESTMENT BALANCES BY MONTH
2007
Change in
FUND NAME Aug Sep Oct Nov Dec TOTAL Fair Value
10100 GENERAL $ 5,793,891.19 $ 4,455,412.03 $ 4,140,844.14 $ 3,259,915.14 $ 8,207,137.41 $ 8,207,137.41
46321 HRA 126,748.71 126,748.71 133,363.77 133,363.77 - -
46310 EDA 1,638,195.59 1,604,872.58 1,599,258.93 1,588,024.03 1,821,497.41 1,821,497.41
46323 CDBG - - - - - -
42190 POLICE FORFEITURE 30,281.42 23,532.32 24,652.51 17,557.16 - -
46411 TIF DISTRICT #1 519,791.13 - - - - -
46412 TIF DISTRICT #2 322,201.98 323,578.14 324,952.18 326,106.26 295,806.31 295,806.31
46413 TIF DISTRICT #3 15,090,853.25 15,036,855.90 14,535,495.96 13,905,021.87 15,192,098.79 15,192,098.79
46414 TIF DISTRICT #4 - - - - 125,585.34 125,585.34
28600 CITY INITIATIVES GRANT 114,404.08 86,399.77 88,528.02 86,798.05 65,088.56 65,088.56
TOTAL SPECIAL REV 17,842,476.16 17,201,987.42 16,706,251.37 16,056,871.14 17,500,076.41 17,500,076.41
47513 GO IMP BONDS -1996A - - - - - -
47514 GO IMP BONDS -1997A 369,240.93 370,818.00 372,392.64 373,715.20 405,431.67 405,431.67
47516 GO IMP BONDS -1998A 226,809.71 227,778.44 231,032.99 231,853.51 266,001.26 266,001.26
47518 GO IMP BONDS -1999A 234,254.20 235,177.09 236,737.75 238,140.53 300,779.39 300,779.39
47519 GO IMP BONDS -2000A 467,316.65 469,312.61 471,305.50 472,979.35 497,692.70 497,692.70
47520 GO IMP BONDS -2001A 318,320.08 319,679.66 321,037.15 322,177.32 346,654.50 346,654.50
47521 GO IMP BONDS -2003A 211,279.88 213,777.28 217,875.06 218,648.85 277,138.86 277,138.86
47522 GO IMP BONDS -2004C 360,008.04 361,545.67 365,669.54 366,968.22 413,245.89 413,245.89
47523 GO BLDG REF -POL &FIRE 2004, 774,252.79 777,559.71 780,861.54 783,634.79 1,149,050.60 1,149,050.60
47524 GO IMP BONDS -2006A 356,185.98 379,250.10 386,146.75 387,518.16 492,038.52 492,038.52
47614 GO TIF REF -2004B - - - - - -
47615 GO TIF BONDS -2004D - - - - - -
TOTAL DEBT SERVICE 3,317,668.26 3,354,898.56 3,383,058.92 3,395,635.93 4,148,033.39 4,148,033.39
40100 CAPITAL IMPROVEMENTS 576,427.83 551,970.85 547,283.23 526,128.19 631,430.71 631,430.71
40200 MUNICIPAL STATE AID CONST 768,650.57 730,850.13 733,953.61 736,560.26 59,897.46 59,897.46
40600 CAPITAL RESERVE EMERGEN( 1,508,039.85 1,378,569.46 1,384,423.42 1,389,340.23 1,394,084.64 1,394,084.64
40700 INFRASTRUCTURE CONSTRU( - - - - - -
40800 EBHC CAPITAL 433,315.01 415,136.74 416,899.58 418,380.21 419,808.92 419,808.92
40900 STREET RECONSTRUCTION 2,364,656.18 2,374,755.88 2,548,966.79 2,558,019.50 1,520,381.69 1,520,381.69
41000 TECHNOLOGY 480,671.24 482,724.24 484,774.08 466,332.95 536,742.81 536,742.81
TOTAL CAPITAL PROJECTS 6,131,760.68 5,934,007.30 6,116,300.71 6,094,761.34 4,562,346.23 4,562,346.23
49141 WATER UTILITY 1,516,047.58 1,714,453.62 2,248,547.05 2,344,065.51 2,139,888.94 2,139,888.94
49251 SEWER UTILITY 2,458,187.66 2,483,407.39 2,368,962.58 2,434,027.52 2,466,626.48 2,466,626.48
49611 /12 BROOKLYN CENTER LIQUOR 1,182,539.68 1,192,574.38 1,242,543.25 1,174,527.17 1,189,260.60 1,189,260.60
49721 CENTERBROOK GOLF COURSI 117,054.45 69,411.77 57,757.19 47,417.57 51,593.48 51,593.48
49851 EARLE BROWN HERITAGE CEf 1,188,133.98 1,002,162.95 1,098,693.69 1,096,410.15 1,147,372.94 1,147,372.94
49411 STORM SEWER UTILITY 2,234,072.87 2,284,169.08 2,308,585.69 2,427,747.55 1,328,262.69 1,328,262.69
49571 STREET LIGHT UTILITY 179,756.28 178,555.15 173,541.91 177,556.61 153,111.33 153,111.33
49311 RECYCLING 31,906.90 21,745.86 4,423.55 3,020.07 762.63 762.63
TOTAL ENTERPRISE S 8,907,699.40 8,946,480.20 9,503,054.91 9,704,772.15 8,476,879.09 8,476,879.09
49951 CENTRAL GARAGE 4,146,406.43 4,166,179.20 4,205,131.70 4,203,985.30 4,292,459.63 4,292,459.63
49961 EMPLOYEE RETIREMENT BENI 1,483,226.97 1,492,191.48 1,493,093.25 1,490,581.96 1,485,673.97 1,485,673.97
49971 COMPENSATED ABSENCES 980,795.21 984,984.29 989,166.93 992,679.98 917,370.84 917,370.84
TOTAL INTERNAL SER FND 6,610,428.61 6,643,354.97 6,687,391.88 6,687,247.24 6,695,504.44 6,695,504.44
GRAND TOTAL $ 48,603,924.30 $ 46,536,140.48 $ 46,536,901.93 $ 45,199,202.94 $ 49,589,976.97 $ 49,589,976.97
90400 PAYROLL (7,123.58) 498,719.89 469,221.57 179,892.88 87,327.62 87,327.62
NEGATIVE BALANCES (2,159,850.43) (2,839,966.25) (3,795,982.70) (4,397,084.55) (1,157,423.58) (1,157,423.58)
TOTAL POOLED C & 1 $ 46,436,950.29 $ 44,194,894.12 $ 43,210,140.80 $ 40,982,011.27 $ 48,519,881.01 $ 48,519,881.01
Change in
SOURCE OF INTEREST Aug Sep Oct Nov Dec TOTAL Fair Value
90300 INTEREST ON INVESTMENTS $ 207,592.52 $ 197,611.25 $ 165,276.89 $ 154,349.17 $ 169,161.40 $ 2,110,542.30 $ -
MARKET INTEREST -FAIR VALU - - - - - - 31,355.00
ACCRUED INTEREST - - - - 116,674.04 116,674.04 -
TOTAL INTEREST 207,592.52 197,611.25 165,276.89 154,349.17 285,835.44 2,227,216.34 31,355.00
Interest allocation 3
CITY OF BROOKLYN CENTER
INTEREST ALLOCATION BY MONTH
2007
Change in
BU FUND NAME Aug Sep Oct Nov Dec TOTAL Fair Value
10100 GENERAL $ 24,746.31 $ 18,919.51 $ 14,706.30 $ 11,132.17 $ 47,305.74 $ 251,391.95 $ 5,189.25
46321 H RA - - - - - - -
46310 EDA 7,538.26 7,353.16 6,153.45 5,878.31 10,499.07 82,483.80 1,151.71
46323 CDBG - - - - - - -
42190 POLICE FORFEITURE 129.34 99.93 87.55 59.96 - 1,688.60 -
46411 TIF DISTRICT #1 2,220.08 - - - - 13,371.78 -
46412 TIF DISTRICT #2 1,376.16 1,374.04 1,154.08 1,113.61 1,705.02 8,049.15 187.03
46413 TIF DISTRICT #3 64,454.64 63,852.56 51,623.15 47,483.77 87,566.89 727,856.23 9,605.74
46414 TIF DISTRICT #4 - - - - 723.87 929.36 79.41
28600 CITY INITIATIVES GRANT 488.63 366.89 314.41 296.40 375.17 5,423.63 41.15
TOTAL SPECIAL REV 76,207.11 73,046.58 59,332.64 54,832.05 100,870.02 839,802.55 11,065.04
47513 GO IMP BONDS -1996A - - - - - 7,125.57 -
47514 GO IMP BONDS -1997A 1,577.07 1,574.64 1,322.56 1,276.19 2,336.90 9,829.57 256.35
47516 GO IMP BONDS -1998A 968.73 967.24 820.52 791.75 1,533.22 10,329.14 168.19
47518 GO IMP BONDS -1999A 1,000.52 998.66 840.78 813.22 1,733.69 10,225.36 190.18
47519 GO IMP BONDS -2000A 1,995.96 1,992.89 1,673.85 1,615.16 2,868.69 21,732.30 314.68
47520 GO IMP BONDS-2001A 1,359.58 1,357.49 1,140.17 1,100.19 1,998.11 14,720.31 219.18
47521 GO IMP BONDS -2003A 902.40 907.78 773.79 746.66 1,597.42 9,314.85 175.23
47522 GO IMP BONDS -2004C 1,537.63 1,535.27 1,298.68 1,253.15 2,381.94 16,211.46 261.29
47523 GO BLDG REF -POL &FIRE 2004, 3,306.92 3,301.83 2,773.25 2,676.01 6,623.10 31,689.30 726.53
47524 GO IMP BONDS -2006A 1,521.31 1,610.45 1,371.41 1,323.32 2,836.10 15,996.07 311.11
47614 GO TIF REF -2004B - - - - - - -
47615 GO TIF BONDS -2004D - - - - - - -
TOTAL DEBT SERVICE 14,170.12 14,246.25 12,015.01 11,595.65 23,909.17 147,173.93 2,622.74
40100 CAPITAL IMPROVEMENTS 2,461.98 2,343.89 1,943.69 1,796.66 3,639.55 27,076.50 399.24
40200 MUNICIPAL STATE AID CONST 3,282.99 3,103.48 2,606.65 2,515.25 345.25 25,264.42 37.87
40600 CAPITAL RESERVE EMERGEN( 6,441.00 5,853.96 4,916.81 4,744.41 8,035.47 66,732.61 881.46
40700 INFRASTRUCTURE CONSTRUC - - - - - - -
40800 EBHC CAPITAL 1,850.73 1,762.84 1,480.63 1,428.71 2,419.77 15,921.17 265.44
40900 STREET RECONSTRUCTION 10,099.70 10,084.17 9,052.71 8,735.29 8,763.44 101,233.76 961.31
41000 TECHNOLOGY 2,053.00 2,049.84 1,721.69 1,592.46 3,093.77 23,142.96 339.37
TOTAL CAPITAL PROJECTS 26,189.40 25,198.18 21,722.18 20,812.78 26,297.25 259,371.42 2,884.69
49141 WATER UTILITY 6,475.20 7,280.26 7,985.77 8,004.67 12,334.27 77,314.87 1,353.02
49251 SEWER UTILITY 10,499.18 10,545.55 8,413.43 8,311.88 14,217.58 114,395.57 1,559.61
49611 /12 BROOKLYN CENTER LIQUOR 5,050.76 5,064.16 4,412.92 4,010.84 6,854.88 52,467.52 751.96
49721 CENTERBROOK GOLF COURSI 499.95 294.75 205.12 161.92 297.38 3,412.64 32.62
49851 EARLE BROWN HERITAGE CEf 5,074.65 4,255.59 3,902.04 3,744.09 6,613.43 53,605.57 725.47
49411 STORM SEWER UTILITY 9,541.96 9,699.50 8,199.00 8,290.43 7,656.07 91,458.64 839.84
49571 STREET LIGHT UTILITY 767.76 758.22 616.34 606.33 882.53 7,572.42 96.81
49311 RECYCLING 136.28 92.34 15.71 10.31 4.40 1,068.31 0.48
TOTAL ENTERPRISE 38,045.74 37,990.37 33,750.33 33,140.47 48,860.54 401,295.54 5,359.81
49951 CENTRAL GARAGE 17,709.74 17,691.27 14,934.62 14,356.04 24,741.63 212,070.66 2,714.06
49961 EMPLOYEE RETIREMENT BENI 6,335.02 6,336.45 5,302.76 5,090.14 8,563.39 70,258.05 939.37
49971 COMPENSATED ABSENCES 4,189.08 4,182.64 3,513.05 3,389.87 5,287.70 45,852.24 580.04
TOTAL INTERNAL SERVICE 28,233.84 28,210.36 23,750.43 22,836.05 38,592.72 328,180.95 4,233.47
$ 207,592.52 $ 197,611.25 $ 165,276.89 $ 154,349.17 $ 285,835.44 $ 2,227,216.34 $ 31,355.00
Interest allocation 4
CITY OF BROOKLYN CENTER
INTEREST BY FUND
12/31/2007
Interest on Change in Interest- Total
Fund /Description Investments Fair Value Other Interest
MAJOR FUNDS:
GENERAL FUND 256
GENERAL 251, 391.94 5 -
PAYROLL - - -
SPECIAL REVENUE FUNDS:
TIF DISTRICT #3 727 9 - 737
DEBT SERVICE FUND:
SPECIAL ASSESSMENT BONDS 117
GO IMPROVEMENT BONDS -1996A 7 - -
GO IMPROVEMENT BONDS -1997A 9 256.35 -
GO IMPROVEMENT BONDS -1998A 10 168.19 -
GO IMPROVEMENT BONDS -1999A 10 190.18 -
GO IMPROVEMENT BONDS -2000A 21 314.68 -
GO IMPROVEMENT BONDS -2001A 14 219.18 -
GO IMPROVEMENT BONDS -2003A 9 175.23 -
GO IMPROVEMENT BONDS -2004C 16 261.29 -
GO IMPROVEMENT BONDS -2006A 15 311.11 -
CAPITAL PROJECTS FUNDS:
INFRASTRUCTURE CONSTRUCTION - - - -
ENTERPRISE FUNDS:
MUNICIPAL LIQUOR
MUNICIPAL LIQUOR 52 751.96 - 53
GOLF COURSE
CENTERBROOK GOLF COURSE 3 32.62 - 3
EARLE BROWN HERITAGE CENTER
EARLE BROWN HERITAGE CENTER 53 725.47 - 54
WATER UTILITY
WATER UTILITY 77 1 - 78
SANITARY SEWER UTILITY
SANITARY SEWER UTILITY 114 1 - 115
STORM SEWER UTILITY
STORM SEWER UTILITY 91 839.84 - 92
Interest by Fund 1
CITY OF BROOKLYN CENTER
INTEREST BY FUND
12/31/2007
Interest on Change in Interest- Total
Fund /Description Investments Fair Value Other Interest
NONMAJOR FUNDS:
SPECIAL REVENUE FUNDS:
H RA - - - -
E DA 82, 483.80 1 - 83, 635.51
CDBG - - - -
EARLE BROWN TIF DISTRICT 21
TIF DISTRICT #1 13 - -
TIF DISTRICT #2 8 187.03 -
TIF DISTRICT #4 929.36 79.41 - 1
POLICE FORFEITURE 1 - - 1
CITY INITIATIVES GRANT 5 41.15 - 5
TOTAL SPECIAL REVENUE FUNDS 113
DEBT SERVICE FUND:
GENERAL OBLIGATION BONDS 32
GO BLDG BONDS - POL &FIRE REF - 2004A 31 726.53 -
GO TAX INCREMENT BONDS -
GO TAX INCREMENT REF -2004B - - -
GO TAX INCREMENT BONDS -2004D - - -
TOTAL DEBT SERVICE FUNDS 32
CAPITAL PROJECTS FUNDS:
CAPITAL RESERVE EMERGENCY FUND 66 881.46 - 67
CAPITAL IMPROVEMENTS FUND 27 399.24 - 27
MUNICIPAL STATE AID CONSTRUCT 25 37.87 - 25
E B H C CAPITAL FUND 15, 921.17 265.44 - 16
STREET RECONSTRUCTION 101 961.31 - 102
TECHNOLOGY FUND 23 339.37 - 23
TOTAL CAPITAL PROJECT FUNDS 262
ENTERPRISE FUNDS:
RECYCLING 1 0.48 - 1
STREET LIGHT UTILITY 7 96.81 - 7
TOTAL ENTERPRISE FUNDS 8
Interest by Fund 2
CITY OF BROOKLYN CENTER
INTEREST BY FUND
12/31/2007
Interest on Change in Interest- Total
Fund /Description Investments Fair Value Other Interest
INTERNAL SERVICE FUNDS:
CENTRAL GARAGE 212 2 - 214
EMPLOYEE RETIREMENT BENEFIT 70 939.37 - 71
COMPENSATED ABSENCES 45 580.04 - 46
TOTAL INTERNAL SERVICE FUNDS 332
TOTAL ALL FUNDS 2 31 - 2
TOTAL ALL FUNDS FROM STATEMENT 2
Governmental 1
Business -Type 406
2,258,771.00
Interest by Fund 3
CITY OF BROOKLYN CENTER
INTEREST RECEIVABLE
12/31/07
Accrual
Date Days 2007
Type of Purchase Maturity Interest Purchase Par Last interest since last Accrued
Investment Date Date Rate Price Value received /paid interest pymt Interest
WELLS FARGO TRUST MONEY MARK DEC 31ST VALUE 11/30/2007 Monthly 94
FED HOME LOAN BANK 06/25/2003 02/06/2008 3.750% 844 833 08/06/2007 147.00 12
FED NATL MORT ASSN 06/25/2003 03/17/2008 3.250% 1 1 09/17/2007 105.00 9
WF GENERAL CHECKING (SWEEP) 59.92
1, 849, 367.50 116, 674.04
Interest Receivable
CITY OF BROOKLYN CENTER
GASB 31 CALCULATIONS DECEMBER
FOR THE YEAR ENDED DECEMBER 31, 2007
2006 2007 2007 2007 2007
Type of Purchase Maturity Interest Purchase Fair Value Purchase Sales Fair Value Change in
Investment CUSIP Date Date Rate Price Fair Value
4M Money Market DEC 31 ST VALUE IS 21761,889.63 10,358,364.38 25,934,868.39 27,605,416.21 8,687,816.56 0.00
4M Plus Money Market DEC 31ST VALUE IS 3,937,919.00 16,072,107.32 687,571.79 7,000,000.00 9,759,679.11 0.00
I
WF Money Market DEC 31ST VALUE IS 21,414,706.49 25,995,144.00 1,322,505.02 771.63 27,316,877.39 0.00
FHLB 3133MVNP4 06/25/2003 02/06/2008 3.750% 844,737.50 820,575.00 832,550.00 11,975.00
FNMA 3136F3CT1 06/25/2003 03/17/2008 3.250% 1,004,630.00 977,810.00 997,190.00 19,380.00
0.00
0.00
0.00
0.00
0.00
0.00
Wells Fargo Checking 712,024.77
Wells Fargo Checking -Repo 575,259.58
48,963,882.62 54,224,000.70 27,944,945.20 34,606,187.84 48,881,397.41 31,355.00
48,881,397.41
Fair Value + Accrued Interest for YE 48,998,071.45
90300 -1010 1,287,284.35
90300 -1022 27,316,877.39
90300 -1023 9,759,679.11
90300 -1024 8,687,816.56
90300 -1110 833,333.33
90300 -1120 1,000,000.00
90300 -1132 (12,187.50)
90300 -1134 (7,440.00)
90300 -1140 116,674.04
90300 -1145 16,034.17
48,998,071.45
Investments - 2007 1
FEB-20-2008 12:03 From:WELLE FARGO 6123163948 To:91E665E1539E F.1/3
T
s.
-,...
ACCEPTANCE O SERVICES
(Wells Fargo Stagecoach Sweepl'm)
Part I — Certification
Bank: Wells Far Bank, N.. A. ("Bank")
Q New Agreement ❑ Additional Service
Each person signing this Acceptance of Services ( "Acceptance") certifies that:
(a ) the undersigned Company has received and agrees to be bound by the Service
Documentation, as defined in the Master Agreement for Treasury Management Service$
between the Company identified in the signature block of this Acceptance and Bark
("Agreernent"), and the weep Options Company has elected in this Acceptance;
b he or she has full authority to execute this Acceptance on behalf of Company, to enter into
other agreements with Bank for Treasurer Management services now or hereafter offered by
Bank (the "Services"), and to amend, terminate or otherwise act on behalf of Company with
respect to the Services; and
() Company's use of any Services confirms its agreement to be bound by the ervi e
Documentation ntation relating to that Service,
dart 11— Sweep Options
A. DESIGNATION OF SWEEP OPTION
Company designates the following S weep O ptiono
El Yes ❑ No Wells Fargo Stagecoach Sweep"', Preferred Option with secondary
Wells Fargo Stagecoach weep", Repurchase Agreement
❑ Yes El N o Wells Fargo Stagecoach weeFsm, Preferred Option.
El Yes ❑ No Wells Fargo Stagecoach weep`, Repurchase Agreement with
secondary Wells Fargo Stagecoach Sweep", Preferred Option.
Yes El No Wells Fargo Stagecoach weep`, Repurchase hase Agreement.
❑ Yes ❑ No Wells Fargo Stagecoach rep ", Money Market Funds. (Check one
box to designate a Fund- If no box, or more than one box, is checked the
designated Fund will be the -
❑ California Tax Free Money Market Mutual Fund -Class A - Fund
❑ Treasury Plus Money market Fund -Class A - Fund 453
El National Tax -Free Morey Market Fund -Class A - Fund 452
TM -1526 Arceptonce of Services with Alternative Morey Ms rket Fund Sweep Page 1 of 2
Revised 10 -6 -06
02/20/2008 1 0 : Al (GMT-06:00
FEB-20-2008 12:03 From:WELLE FARO 61E316394E To:91E665E1539E F.E /3
!r•-• *�
�. C��ITi�1�.II�1FF�lVIT���
C hecking AGc ount N urnb r:
Credit Sweep Option 0 Yes No LOC Nu mber ,
Stat and/or r onfirmatio n will be seat to Company by electronic means unle
otherwi r by Company. Electronic means include Bank' Commercial Electronic
Office 0, facsimile and /or Secure E- !Mail.
Fart III — Signature
Agreed To and Accepted B
or
om .
By,
C ompany entification lu mber.
Title.
D ate
TM-1 526 Acceptance of Services with Alternative Money M arket Fund S weep Page 2 of
e vise d 10-
02/20/2008 10:5 Al 1T- 06:00)
FEB-20-2008 12:03 Frcm:WELLE FARO 61E316394E Tc:91E665E1539E F.3/3
r
1%
i
Form W M 9 Re
quest f Taxpayer Gins form to the
(Ruv. Novomber 2 5) Identification Number and Ce rtifidation re Do not
aupwtmiint of the Treatury send to the IRS.
Internal Revenue service
Ci IN1,1rrtke (as sh(; Wrl orl your ini J%JX rdtUrM)
I C ity of Brooklyn Center, Minnesota
Bueineae name, If different from above
Individual/ f� �9t Exempt from backup
L ChQok - appeo�tiri; o bo ❑ Sole proprietor ❑ Corporation El F�artrt�rship � ��h��' 0- -�- - - - e_r- - - - - me - - - - - - - - � Wlthholdirl�
Apdre� (nU(ryr)0r, ,-rlr00t, and apt, or suite no.) Requester narne grid addrozis �Optiurwal)
CL
6301 Shingle Creek Parkway
City, ate, and ZIP 000e
Brooklyn Center, MIS 56430
List account number(a) herB (opticnno
Tai er Identifloation Number (TIN
Etter your TIN i n the appropriate box, The TIN provided must mortrh the name given on Line I to avoid $ J01 secudly number
backup lthholding- F <>r individuals, this is your soclal securlty nufnr)or ( SN). Howev%, for a resident
alien, sole proprletor or disr arded entity, see the Part I Instructions on page �. For #thFLr• entities, it is
your employer identification numbor (rHIN). If yQu do not have a number, see How to 00t a TIN on page 3, or
Note. If the account is Its more than arse name, see the chart on page 4 for gwidolin on whose EMPIOyer idantificatiors number
number to enter, 'I ,5 1l .. . ;
Certification
Under penalties of pedury, I CMIfy that:
1. The nurnbo� r Shown on this form Is my correct ti4xpayer identification number (or 1 4rn waiting for a number to be issued to me), and
. l am riot subject to backup withholding because (a) I anti oxornpt from backup withholding, or (b) I have not been notified by tho Intemal
Revenue Service (IRS) that I $m subject t o backup withhoks inn 05 a result of a failure to report all intorest or dividends, or (C) tho li�S haS
notified me that I am no longer sut)joot to backup withholding, and
. 1 am a U .S. p erson (ncluding a U .S. resi dent alie
Certification instructfon5. You must cross out item 2 Above if you have t) son notified by the IRS that you are currently sUbject to backup
withholding because your have failed to report all interest and dividends on your tax return, For real estate transactions, �em 2 does not apply.
For mortgage Interest paid, acquisition or abandonment of secured property, cancellation of debt, contributions to Sr, individual retirement
arror,gernent (IRA), and general payments other than Int St and dividends, you are not required to sign the Certification, but you must
provide your rQrrect TIN, (Seq irlstruqtjons on page 4.)
Sign $Ignaturs of
Here U.S. person PP-
Date
Purpose of Fora � 0 A n indivi w ho Is a citizen or raaident of t he U nited
person who i r�equIred to file an inf ormation return vvt h ��� ti�t��,
IRS, ,dust obtain your correct taxpayer identification nurn 0 A partnership, corporation, c ompany, or association
(Tii) to report, fir example, Income paid to yQu, real estato created Qr organized irl the United States or tinder the laws
transar,tions, mortgage interest you paid, acquisition or of the United states, or
eibendonment o f secured property, cancellation of debt or * Any estate (other than a forelp estate) or trust. See
contri you made to an IRA. Regulations sections X301,7701- and 7 (a) for addIticriei
U.S. person. Use Form -9 only If you are a U.S. perso infe rfia tion.
(including a resident alien to provide yo ur correct TIN to the $pedal ru les f or partnorships. Partrierships that co nduct a
person requesting it (the requ tar) arid, when applirable, to; trade or b us i ness in t he i. shed S tates are g required
1. Certify that the TIN you are g1 ing is correct (or you are to pay a w ithholding tax on an y fore lgin partners' share of
waitirig for a number to be issued) Irieorrts from such business Further, in Certain cases w a
2 . Certify that y ou are not sul�aac# to backup withholding, or Form W-9 has not been received, a partnership i� required to
3 . lalm' exBmption from backup withholding if u are a presume thiat a par her I8 a foreign person and pay the
U.S- exempt payee- withholding tax- Therefore, if you are a U.S. person that i s a
In 3 above, If applicable, you are also QertifyIng that a5 a partner In a partnership conducting a trade or business in the
United $fates, provide Form l- to the partnership to
U. person, y our allocable share of a ny partnership incorno est�bll�h your U. etat� and avoid w ithholding �n
from a U.S. trade or business i not subject to the y our
�r
withholding tax on foreign partners' sham of effectively share of partnership irlccmo_
connected income. The person who gives Form W to the partnership for
Dote. If a requester gives you a form other than Form - 9 t purposes o f e8tadlishing Its U.S status and avoiding
request your TIN, you Must use the requester's fora If it is ithh�l�il�� on its allocable share �f not in �n�� from the
substantially similar t o this Fora, W,9. p artnership cond uct i ng a trade or busini s in t U nited
Statos Is lrl the following rase%
For federal tai p�irpo5es, you aim Considered a person if you � The U.S. i�r of � disregarded entity art n '
are; ter � of the entity,
(W. NO, 10231 F�)rrrl
02/20/2008 10: AM MT- 06:00)
• ' i
ITS MINNESOTA
MAC 9309 -050
5TH & MAR JUETTE
MINNEAPOL Ss MN 55479
CITY OF BROOKLYN CENTER
ACCOUNT NUMBER 13455300
ANNUAL STATEMENT
JANUARY Is 2007 THROUGH DECEMBER 319 2007
ACCOUNT MANAGER: DARCY KENT
TELEPHONE NUMBER: 612 - 667 -5502
CEO# CITY OF BROOKLYN CENTER INVESTMENT CONTACT: NON— MANAGED
TELEPHONE NUMBER:
CHILGER
@CI.BROOKLYN— CENTER.MN.US ADMINISTRATOR: ITS TX SERVICE CENTER
TELEPHONE NUMBER: 1 -866- 706 -2809
00508 SN
• ' i
TABLE OF CONTENTS C I TY OF BROOKLYN CENTER
FOR TH E PE RIOD JANUARY 1 _ D E EM 1, _UQ7 _ _ _ _ _ _ _ _ _ AC NT NUM 1 345 00._
PAGE
R EP O RT N NUMB
ASSETSUMMARY ................................................... ............................... 1
STATEMENT OF ASSETS AND LIABILITIES ............................. ............................... 2
CASHSUMMARY .................................................... ............................... 3
STATEMENT OF TRANSACTIONS ....................................... ............................... 4
• i
PAGE 1
ASSET SUMMARY C I TY OF BROOKLYN CENTER
A F DE EM 31 2 EL- - - -- - - - -- - - - - -- - - - -- - - - -- - AS�Q l�N T NUM 1 � 0 -
ASSET SUMMARY
% TOTAL UNREALIZED ESTIMATED CURRENT ACCRUED
I. NV ESTME NT CATEGO _ _ _ COST V E _ M V _ M SA I I�LU5 -- A AL I N EQ ME _ Y _ I N M
CASH 0.00 0.00 0.00
CASH EQUIVALENTS 2723162877.39 2723162877.39 93 .72 0.00 121442054 4.19 94
B AN N 1 2 84 92 3 6 7. 50 12 6 1 92 6 27 .5 0- 632750 3.48 21, 975.70
TOTAL INVESTMENTS 2921662244.89 2921462617.39 100.00 192627.50- 122072804 4.14 116 654.88
T AC 11 6 1 16 65
TOTAL ACCRUALS AND INVESTMENTS 2992829899.77 2992639272.27 199627.50- 192079804 4.14 116 654.88
• i
PAGE 2
STATEMENT OF ASSETS AND L I A B I L I T I E S C I TY OF BROOKLYN CENTER
A F DE EM 31 2 07 - - - -- - - - -- - - - - -- - - - -- - - - -- - AS�Q l�N T NUM 1 � 0 -
STATEMENT OF ASSETS AND LIABILITIES
COST VALUE MARKET VALUE TOTAL UNREALIZED
_ VA L�l H D E S� I PT I (�N__ _ _ _ _ _ _� UNIT Q�T _
- L-UNIT P R I � M A R KE T _ CiA I N 1L�( ��_ ACC R ED IN
PRINCIPAL CASH 14 14 50.24 -
INCOME CASH 14 ,643 588.71 14 ,643 588.71 50.24
BASH E QUJ I V A LE N -
2723162877.39 WELLS FARGO ADVANTAGE GOVERNMENT 2723162877.39 2723162877.39 93 .72 0.00 94
M MA S - #7 1. 1
TOTAL CASH EQUIVALENTS 2723162877.39 2723162877.39 93 .72 0.00 94
BBB & N T E �- - -- - - - -- - - - -- - - - - -- - - - -- - - - -- - - - - - -- 8332 FED HOME LN BK SER DE08 8442737.50 8322550.00 2.86 122187.50- 122586.81
DTD 02/06 03 3.750 02/06/2008 101.369 99.906
MOODY 'S RATING AAA
CUSIP 3133MVNP4
120002000 FED NATL MTG ASSN 1, 004 630 .00 997190.00 3.42 72440.00- 9 388 .89
DTD 03Z17/03 3.250 03/17/2008 100.463 99.719
MOODY 'S RATING AAA
C US I P 31 F 1
TOTAL BOND & NOTES 12849 1,829 740.00 6.28 192627.50- 212975.70
TOTAL INVESTMENTS 2991669244.89 2991469617.39 100.00 199627.50- 116 654.88
T AC 11 6 54 . 88 1 16 65
TOTAL ACCRUALS AND INVESTMENTS 2992829899.77 2992639272.27
• i
PAGE 3
CASH SUMMARY C I TY OF BROOKLYN CENTER
FOR TH E PE RIOD JANUARY 1 _ D E EM 1, _UQ7 _ _ _ _ _ _ _ _ _ AC NT NUM 1 345 QQ_
CASH SUMMARY
_ D ESC R I PT I QN_ _ _ _ _ _ _ _ _ _ _ _ P R I N APA L FAQ_ _ _ _ 1 0-01 FAH_
BEGINNING BALANCE 1393209821.85- 1393209821.85
RECEIPTS
NET INTEREST COLLECTED 0.00 123222766.86
CASH MANAGEMENT SALES 12033.47 0.00
TOTAL CASH RECEIPTS 12033.47 123222766.86
DISBURSEMENTS
ADM I N I STRAT I VE EXPENSES 12033.47- 0.00
CASH MANAGEMENT PURCHASES 123222766.86- 0.00
TOTAL CASH DISBURSEMENTS 123232800.33- 0.00
ENDING BALANCE 1496439588.71- 1496439588.71
. • PAGE 4
STATEMENT OF TRANSACTIONS CITY OF BROOKLYN CENTER
FOR THE PERIOD JANUARY 12 THROUGH DECEMBER 31, 2007 ACCOUNT NUMBER 13455300
STATEMENT OF TRANSACTIONS
REALIZED
DATE PAR VALUE /SHARES DESCRIPTION PRINCIPAL CASH INCOME CASH COST VALUE GAIN /LOSS
BEGINNING BALANCE 13,320,821.85- 13,320,821.85 27,844,511.50
01102107 INTEREST RECEIVED 1072034.23
WF ADV GOVERNMENT MM FD -SVC #743
INTEREST FROM 12/1/06 TO 12/31/06
01122107 ADMINISTRATIVE FEE EXPENSE 254.94-
WELLS FARGO BANK F E
02101107 INTEREST RECEIVED 106 984.04
WF ADV GOVERNMENT MM FD -SVC #743
INTEREST FROM 111107 TO 1/31/07
02/06/07 INTEREST RECEIVED 15 625.00
FED HOME LN BK 3.750% 2/06/08
CUSIP 3133MVNP4
INTEREST ON 833 333.330 UNITS
03/01/07 INTEREST RECEIVED 972110.68
WF ADV GOVERNMENT MM FD -SVC #743
INTEREST FROM 211107 TO 2/28/07
03/19/07 INTEREST RECEIVED 162250.00
FED NATL MTG ASSN 3.250% 3/17/08
CUSIP 3136F3CT1
INTEREST ON 1,000 000.000 UNITS
04/02/07 INTEREST RECEIVED 1082179.15
WF ADV GOVERNMENT MM FD -SVC #743
INTEREST FROM 3/1/07 TO 3/31/07
04/20/07 ADMINISTRATIVE FEE EXPENSE 261.27-
WELLS FARGO BANK F
. • PAGE 5
STATEMENT OF TRANSACTIONS CITY OF BROOKLYN CENTER
FOR THE PERIOD JANUARY 12 THROUGH DECEMBER 31, 2007 ACCOUNT NUMBER 13455300
STATEMENT OF TRANSACTIONS
REALIZED
DATE PAR VALUE /SHARES DESCRIPTION PRINCIPAL CASH INCOME CASH COST VALUE GAIN /LOSS
05/01/07 INTEREST RECEIVED 32497.46
WF ADV GOVERNMENT MM FD -SVC #743
INTEREST ON 2624452810.890 UNITS
RATE ADJUSTMENT FOR 4/30/07
05/01/07 INTEREST RECEIVED 1012366.73
WF ADV GOVERNMENT MM FD -SVC #743
INTEREST FROM 4/1/07 TO 4/30/07
06/01/07 INTEREST RECEIVED 108 437.28
WF ADV GOVERNMENT MM FD -SVC #743
INTEREST FROM 5/1/07 TO 5/31/07
07102107 INTEREST RECEIVED 105 775.57
WF ADV GOVERNMENT MM FD -SVC #743
INTEREST FROM 6/1/07 TO 6/30/07
07120107 ADMINISTRATIVE FEE EXPENSE 255.42-
WELLS FARGO BANK F E
08/01/07 INTEREST RECEIVED 1092676.28
WF ADV GOVERNMENT MM FD -SVC #743
INTEREST FROM 711107 TO 7131107
08/06/07 INTEREST RECEIVED 152625.00
FED HOME LN BK 3.750% 2/06/08
CUSIP 3133MVNP4
INTEREST ON 833,333.330 UNITS
09/04/07 INTEREST RECEIVED 109 557.07
WF ADV GOVERNMENT MM FD -SVC #743
INTEREST FROM 8/1/07 TO 8/31/07
09/17/07 INTEREST RECEIVED 16 250.00
FED NATL MTG ASSN 3.250% 3/17/08
CUSIP 3136F3CT1
INTEREST ON 1,000,000.000 UNITS
. • PAGE 6
STATEMENT OF TRANSACTIONS CITY OF BROOKLYN CENTER
FOR THE PERIOD JANUARY 12 THROUGH DECEMBER 31, 2007 ACCOUNT NUMBER 13455300
STATEMENT OF TRANSACTIONS
REALIZED
DATE PAR VALUE /SHARES DESCRIPTION PRINCIPAL CASH INCOME CASH COST VALUE GAIN /LOSS
10101107 INTEREST RECEIVED 1042108.19
WF ADV GOVERNMENT MM FD -SVC #743
INTEREST FROM 9/1/07 TO 9/30/07
10122107 ADMINISTRATIVE FEE EXPENSE 261.84-
WELLS FARGO BANK F
11101107 INTEREST RECEIVED 1022776.75
WF ADV GOVERNMENT MM FD -SVC #743
INTEREST FROM 1011107 TO 10/31/07
12/03/07 INTEREST RECEIVED 942513.43
WF ADV GOVERNMENT MM FD -SVC #743
INTEREST FROM 1111107 TO 11/30/07
12/31/07 123222766.86 CASH SWEEP PURCHASES FOR STMT PERIOD 123222766.86- 123222766.86
WF ADV GOVERNMENT MM FD -SVC #743
17 TRANSACTIONS
12/31/07 12033.47- CASH SWEEP SALES FOR STMT PERIOD 12033.47 1,033.47-
WF ADV GOVERNMENT MM FD -SVC #743
4 TRANSACTIONS
ENDING BALANCE 14,643,588.71- 14,643,588.71 29,166,244.89
City of Brooklyn Center
Cash and Investments
YE 12 -31 -07
Cost or Total
PY ending Change in Deposits Maturities
Account Int. Moody's Maturity fair value Accrued fair value Fair Value at and
Bank or Institution Number Rate Rating Date w/o interest interest 2007 12/31/2007 Petty Cash < 1 1 -5 6 -10
Money Market Account MN-01-0026-0001 4M NA 12/31/2007 8 (0.07) 8 8 0 0
Money Market Account MN -01- 0026 -2001 4M Plus NA 12/31/2007 9 9 9 0 0
0.00 0 0 0
0.00 0 0 0
Money Market Account WF Trust NA 12/31/2007 27 94 -0.08 27 27 0 0
US Government Securities FHLB 3.750% AAA 02/06/2008 844 12 - 12 845 845 0 0
US Government Securities FNMA 3.250% AAA 03/17/2008 1 9 - 7 1 1 0 0
0.00 0 0 0
Repurchase Agreement 000 - 1000016 1.875% (unknown) 01/02/2008 575 59.92 575 575
0.00 0 0 0
Total Investments in Investment Fund 48 116 (19,627.58) 48 48 0 0
Checking Account 000 - 1000016 general NA 712 712 712
Checking Account 000- 1000008 payroll NA 0.00 0
0
Cash on Hand (Petty Cash and Change Funds) NA 8 8 8
Total cash per financial statements 48 116 (19,627.58) 49 720 48 0 0
per statements 49 49
difference 0.30
FV GAS B 31 sch 48, 286, 046.68
FV this schedule 48
difference 0.15
G:\Annual Audit Files \2007 Audit\Audit Workpapers \4 - Investments \YE Investment Balances 1