The URL can be used to link to this page

Home My WebLink About[04g] Treasurer's ReportC[7'S' [K' ;lIT.J Council Agenda Item 4(g) MEETING DATE: April 17, 2008 AGENDA ITEM: Treasurer's Report -Requested Action: Accept the March 2008 Treasurer's Report. SUBMITTED BY: Finance BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N/A PREVIOUS COUNCIL ACTION: None BACKGROUND INFORMATION: March 2008 reconciled cash/investment and budget to actual position for Council review. BUDGETJFISCAL IMPACT: ATTACHMENTS: None March 2008 Financial Reports REQUESTED COUNCIL ACTION: Accept the March 2008 Treasurer's Report as presented. CITY OF ST JOSEPH Cash and Invesfineht- Council Report Current Period: March 2008 FUND Current FUND Descr Begin Yr MTD Debit MTD Credit Balance General $718,994.10 $21,984.78 $149,082.31 $214,148.92 Fire Fund $463,459.20 $5,904.57 $8,756.84 $469,091.69 Cable Access Fee $10,899.41 $495.60 $1,028.12 $12,274.89 Economic Develop $30,981.57 $109.19 $2,400.67 $16,201.17 TIF 1-3 Borgert (S $4,877.97 $29.00 $0.00 $4,940.25 TIF 1-4 St. Joe De $39,643.59 $235.65 $0.00 $40,145.11 TIF 2-1 Millstream $10,778.20 $64.07 $0.00 $10,915.02 State Collected Sal $398,283.22 $7,042.48 $0.00 $470,337.49 Park Dedication $60,418.08 $340.58 $69.55 $57,953.67 Recreation Center $45,913.82 $272.92 $0.00 $46,493.93 Lake Wobegon Tra $2.92 $0.00 $0.00 $22.92 City Beautification- $59.11 $0.00 $0.00 $10,059.11 Revolving Loan Fu $50,121.12 $297.91 $0.00 $50,754.37 2004 Equipment C $6,318.53 $42.87 $0.00 $7,302.51 2007 Refunding (9 $414,767.74 $2,465.63 $0.00 $420,048.67 Joseph Street Impr $30,932.03 $185.97 $0.00 $31,682.57 City Hall Refunded, $449.50 $0.00 $0.00 $1,643.90 20041mprovement $184,621.02 $1,098.60 $0.00 $187,158.14 2002 Street Improv $476,330.37 $2,857.74 $0.00 $487,740.61 2003 Liberty Pointe $335,425.25 $2,046.54 $0.00 $348,651.68 2003 Maintenance $405.57 $0.00 $0.00 $1,160.92 2003 Refunding Fir $130,662.44 $831.04 $0.00 $141,576.95 2003 Cross Over ( $180,854.04 $1,076.83 $0.00 $183,451.32 2005 Improve (Hill/ $561,077.97 $3,337.02 $0.00 $568,498.08 Northland Heights/ $600,966.55 $7,714.96 $0.00 $618,712.79 2006 Equipment C $5,517.17 $37.53 $0.00 ~ $6,392.74 2006 Interior St Im $554,153.55 $5,886.40 $82.12 $567,496.08 2007 St Imprv-E Si $625,993.93 $8,617.27 $0.00 $657,010.52 Debt Service Relief $60,516.25 $1,112.39 $0.00 $62,498.21 Northland Heights/ $702,669.96 $0.00 $0.00 $695,618.07 2006 Interior St Im $436,557.41 $0.00 $160,539.96 $274,696.65 2007 Street Impr (J $826,249.63 $0.00 $3,401.29 $807,636.68 2008 Equipment C $0.00 $51,461.13 $98,837.37 -$47,376.24 Capital0utlay $274,834.83 $66,218.58 $47,345.43 $254,882.55 Utility Extension - $844,788.18 $5,021.46 $0.00 $855,461.82 Utility Extension - $964,794.42 $5,734.77 $0.00 $976,984.29 Water Fund $1,421,118.14 $36,540.72 $64,870.94 $966,677.99 Sewer Fund $1,064,465.47 $31,444.64 $37,624.00 $1,036,354.57 Refuse Collection $266,049.96 $14,088.15 $23,825.08 $249,864.95 Storm Water Utility $294,715.41 $6,968.98 $71.58 $310,450.57 $13,099,667.63 $12,075,616.13 04/10/08 3:51 PM Page 1 CITY OF ST JOSEPH Council Month End Revenue Summary Current Period: March 2008 2008 2008 YTD March 2008 2008 ND % of FUND FUND Descr Budget 2008 Amt YTD Amt Balance Budget 101 General $1,601,810.00 $20,922.16 $81,674.77 $1,520,135.23 5.10°!0 105 Fire Fund $262,300.00 $5,861.62 $50,817.98 $211,482.02 19.37% 108 Cable Access Fee $0.00 -$532.52 $1,375.48 -$1,375.48 0.00% 150 Economic Development $3,000.00 $109.19 $311.28 $2,688.72 10.38°I° 155 TIF 1-3 Borgert (SKN) $0.00 $29.00 $62.28 -$62.28 0.00% 156 TIF 1-4 St. Joe Development $0.00 $235.65 $501.52 -$501.52 0.00% 157 TIF 2-1 Millstream $0.00 $64.07 $136.82 -$136.82 0.00% 200 State Collected Sales Tax $0.00 $7,042.48 $72,054.27 -$72,054.27 0.00% 205 Park Dedication $0.00 $340.58 $743.24 -$743.24 0.00% 210 Recreation Center $0.00 $272.92 $580.11 -$580.11 0.00% 230 Lake Wobegon Trail $0.00 $0.00 $20.00 -$20.00 0.00% 232 City Beautification-College Av $0.00 $0.00 $10,000.00 -$10,000.00 0.00% 250 Revolving Loan Fund $0.00 $297.91 $633.25 -$633.25 0.00% 307 2004 Equipment Certificates $81,000.00 $42.87 $983.98 $80,016.02 1.21% 320 2007 Refunding (98/99 St Bon $0.00 $2,465.63 $5,280.93 -$5,280.93 0.00% 321 Joseph Street Improvement $29,863.00 $185.97 $750.54 $29,112.46 2.51% 322 City Hall Refunded, 2005 $97,000.00 $0.00 $1,194.40 $95,805.60 1.23% 323 2004 ImprovementslNorthland $17,000.00 $1,098.60 $2,537.12 $14,462.88 14.92% 325 2002 Street Improvement $48,000.00 $2,857.74 $11,410.24 $36,589.76 23.77% 328 2003 Liberty Pointe Street Imp $0.00 $2,046.54 $13,226.43 -$13,226.43 0.00% 329 2003 Maintenance Facility $64,000.00 $0.00 $755.35 $63,244.65 1.18% 331 2003 Refunding Fire Hall $82,180.00 $831.04 $12,664.51 $69,515.49 15.41% 332 2003 Cross Over (93 Streets) $22,000.00 $1,076.83 $2,597.28 $19,402.72 11.81% 333 2005 Improve (Hill/Clover) $22,000.00 $3,337.02 $7,420.11 $14,579.89 33.73°k 335 Northland Heights/Trans Corri $55,000.00 $7,714.96 $17,746.24 $37,253.76 32.27% 337 2006 Equipment Certificate $69,000.00 $37.53 $875.57 $68,124.43 1.27% 338 2006 Interior St Improvements $55,000.00 $5,804.28 $13,342.53 $41,657.47 24.26% 341 2007 St Imprv-E Side/Jade/8 $0.00 $8,617.27 $31,016.59 -$31,016.59 0.00% 390 Debt Service Relief $0.00 $1,112.39 $1,981.96 -$1,981.96 0.00% 501 Utility Extension -Water $0.00 $5,021.46 $10,673.64 -$10,673.64 0.00% 502 Utility Extension-Sewer $0.00 $5,734.77 $12,189.87 -$12,189.87 0.00% 601 Water Fund $471,700.00 $23,517.57 $94,655.04 $377,044.96 20.07% 602 Sewer Fund $293,795.00 $18,717.25 $74,659.97 $219,135.03 25.41% 603 Refuse Collection $266,170.00 $11,452.00 $50,169.48 $216,000.52 18.85% 651 Storm Water Utility $83,500.00 $6,959.90 $26,327.91 $57,172.09 31.53% $3,624,318.00 $143,274.70 $611,370.69 $3,012,947.31 16.87% 04/10/08 3:54 PM Page 1 CITY OF ST JOSEPH Council Month End Expenditure Summary Current Period: March 2008 2008 2008 2008 YTD March 2008 YTD %YTD FUND Description Budget 2008 Amt YTD Amt Balance Balance 101 General $2,075,495.00 $148,166.92 $591,486.42 $1,484,008.58 72.00% 105 Fire Fund $147,700.00 $8,713.89 $45,185.49 $102,514.51 69.00% 150 Economic Development $10,450.00 $2,400.67 $15,091.68 -$4,641.68 -44.00% 205 Park Dedication $0.00 $69.55 $3,207.65 -$3,207.65 0.00% 225 DARE $0.00 $0.00 $373.67 -$373.67 0.00% 331 2003 Refunding Fire Hall $0.00 $0.00 $1,750.00 -$1,750.00 0.00% 435 Northland Heights/Trans Corrid $0.00 $0.00 $7,051.89 -$7,051.89 0.00% 438 20061nteriorSt Improvements $0.00 $160,539.96 $161,860.76 -$161,860.76 0.00% 441 2007 Street lmpr (Jade Rd/E $0.00 $3,401.29 $18,612.95 -$18,612.95 0.00% 442 2008 Equipment Certificates $60,250.00 $47,376.24 $47,376.24 $12,873.76 21.00°~ 490 Capital Outlay $14,715.00 $13,634.44 $19,952.28 -$5,237.28 -36.00% 601 Water Fund $692,800.00 $51,847.79 $549,095.19 $143,704.81 21.00% 602 Sewer Fund $394,020.00 $31,214.46 $102,770.87 $291,249.13 74.00% 603 Refuse Collection $257,585.00 $21,188.93 $66,354.49 $191,230.51 74.00% 651 Storm Water Utility $300.00 $62.50 $10,592.75 -$10,292.75 -3431.00% $3,653,315.00 $488,616.64 $1,640,762.33 $2,012,552.67 55.00% 04/10/08 3:52 PM Page 1 CITY OF ST JOSEPH Council Month End Revenue -General Fund Current Period: March 2008 2008 of FUND 2008 YTD March 2008 2008 YTD Budget FUND Descr SOURCE Descr Budget 2008 Amt YTD Amt Balance Remain FUND 101 General 101 General Current Ad Valorem Taxes $1,130,260.00 $0.00 $10,922.99 $1,119,337.01 99.03% 101 General State Sales Tax $5,100.00 -$5.25 $27.30 $5,072.70 99.46% 101 General Gas Franchise $30,000.00 $0.00 $6,464.68 $23,535.32 78.45% 101 General Electric Franchise $45,000.00 $1,374.78 ,$11,316.64 $33,683.36 74.85% 101 General Gambling Permits $0.00 $25.00 $50.00 -$50.00 0.00% 101 General Amusement/Hunting Permi $2,000.00 $0.00 $330.00 $1,670.00 83.50°l0 101 General Excavation Permit $1,000.00 $50.00 $100.00 $900.00 90.00% 101 General Cable Franchise Fee $19,000.00 $0.00 $5,402.80 $13,597.20 71.56% 101 General Building Permits $200,000.00 $1,639.47 $4,877.19 $195,122.81 97.56% 101 General Animal License $2,000.00 $50.00 $125.00 $1,875.00 93.75°k 101 General Rental Housing Registratio $15,000.00 $0.00 $50.00 $14,950.00 99.67% 101 General Federal Grants -Other $500.00 $1,195.25 $1,195.25 -$695.25 -139.05% 101 General State Aid, Municipal Funds $0.00 $0.00 $3,067.50 -$3,067.50 0.00% 101 General Zoning and Subdivision Fe $2,000.00 $115.00 $115.00 $1,885.00 94.25% 101 General Land Use Deposit Fee $20,000.00 $1,500.00 $1,500.00 $18,500.00 92.50°k 101 General Sale of Maps and Publicati $500.00 $14.00 $24.50 $475.50 95.10°~ 101 General Assessments and research $5,000.00 $320.00 $757.00 $4,243.00 84.86% 101 General Special Hearing $4,000.00 $900.00 $1,350.00 $2,650.00 66.25% 101 General Administration Reimb $11,250.00 -$28.00 -$12.00 $11,262.00 100.11% 101 General Park Fees $5,000.00 $285.00 $1,980.00 $3,020.00 60.40°k 101 General Kennel Fees $1,000.00 $67.00 $193.00 $807.00 80.70% 101 General County Fines $45,000.00 $4,906.47 $11,756.41 $33,243.59 73.87% 101 General Policy Fines $27,000.00 $1,685.00 $4,895.00 $22,105.00 81.87% 101 General Accident Report Fee $1,500.00 $15.25 $205.50 $1,294.50 86.3Q% 101 General Seized Property $1,500.00 $1,115.50 $1,115.50 $384.50 25.63% 101 General Special Assessments $1,200.00 $0.00 $5.50 $1,194.50 99.54°k 101 General Interest Earnings $25,000.00 $3,641.75 $11,546.13 $13,453.87 53.82% 101 General Interest Charges $300.00 $0.00 -$20.00 $320.00 106.67°k 101 General Water Tower Antenna Leas $1,200.00 $88.96 $266.88 $933.12 77.76% 101 General Reimbursement $500.00 $1,967.00 $2,067.00 -$1,567.00 ° -313.40% FUND 1 01 General $1,601,810.00 $20,922.18 $81,674.77 $1,520,135.23 94.90% FUND 1 05 Fire Fund 105 Fire Fund State Grants and Aids $50,000.00 $3,000.00 $3,000.00 $47,000.00 94.00% 105 Fire Fund Special Fire Service $178,800.00 $0.00 $25,849.14 $152,950.86 85.54% 105 Fire Fund Fire Hall Rental $3,000.00 $75.00 $1,025.00 $1,975.00 65.83% 105 Fire Fund Interest Earnings $15,000.00 $2,786.62 $5,943.84 $9,056.16 60.37°~ 105 Fire Fund Contributions from Private $15,500.00 $0.00 $15,000.00 $500.00 3.23°k FUND 1 05 Fire Fund $262,300.00 $5,861.62 $50,817.98 $211,482.02 80.63°k FUND 1 08 Cable Acces s Fee 108 Cable Access Cable Franchise Fee $0.00 -$532.52 $1,375.48 -$1,375.48 0.00% FUND 108 Cable Access Fee $0.00 -$532.52 $1,375.48 -$1,375.48 0.00% FUND 150 Economic Development 150 Economic Dev Interest Earnings $3,000.00 $109.19 $311.28 $2,688.72 89.62% FUND 150 Economic Development $3,000.00 $109.19 $311.28 $2,688.72 89.62% FUND 155 TIF 1-3 Borg ert (SKN) 155 TIF 1-3 Borge Interest Earnings $0.00 $29.00 $62.28 -$62.28 0.00% FUND 155 TIF 1-3 Borg ert (SKN) $0.00 $29.00 $62.28 -$62.28 0.00°k FUND 156 TIF 1-4 St. J oe Development 156 TIF 1-4 St. Jo Interest Earnings $0.00 $235.65 $501.52 -$501.52 0.00% 04/10/08 3:54 PM Page 1 FUND FUND Descr SOURCE Descr FUND 156 TIF 1-4 St. Joe Development FUND 157 TIF 2-1 Millstream 157 TIF 2-1 Millstr Interest Earnings FUND 157 TIF 2-1 Millstream CITY OF ST JOSEPH Council Month End Revenue -General Fund Current Period: March 2008 2008 of 2008 YTD March 2008 2008 YTD Budget Budget 2008 Amt YTD Amt Balance Remain $0.00 $235.65 $501.52 -$501.52 0.00% $0.00 $64.07 $136.82 -$136.82 0.00% $0.00 $64.07 $136.82 -$136.82 0.00% $1,867,110.00 $26,689.19 $134,880.13 $1,732,229.87 92.78% 04/10/08 3:54 PM Page 2 CITY OF ST JOSEPH Council Month End Expenditure -General Fund Current Period: March 2008 2008 2008 2008 YTD March 2008 YTD °!° YTD Description DEPART Descr Budget 2008 Amt YTD Amt Balance Balance FUND 101 General General Council $50,715.00 $2,235.60 $21,262.93 $29,452.07 58.00% General Legislative Committie $6,040.00 $270.00 $1,154.01 $4,885.99 81.00% General Ordinance & Proceedi $8,000.00 $498.41 $3,416.66 $4,583.34 57.00% General Mayor $11,700.00 $581.56 $795.32 $10,904.68 93.00% General Salaries & Adminstrati $210,300.00 $13,644.21 $56,955.23 $153,344.77 73.00% General Accounting $161,460.00 $11,149.39 $43,890.34 $117,569.66 73.00% General Audit Service $28,000.00 $12,500.00 $15,000.00 $13,000.00 46.00% General City Attorney $25,000.00 $2,504.12 $6,365.12 $18,634.88 75.00°k General Planning and Zonning $1,000.00 $0.00 $46.00 $954.00 95.00% General Community Center $29,035.00 $1,496.60 $7,836.21 $21,198.79 73.00% General City Offices $27,050.00 $673.40 $5,940.52 $21,109.48 78.00% General Cable Access $9,435.00 $990.92 $2,533.02 $6,901.98 73.00% General Crime Control & Inves $764,185.00 $51,571.78 $212,912.15 $551,272.85 72.00% General Police Training $11,500.00 $182.93 $532.93 $10,967.07 95.00°~ General Communication Servic $9,000.00 $618.39 $7,050.79 $1,949.21 22.00% General Automotive Services $57,680.00 $3,937.12 $12,772.89 $44,907.11 78.00% General Building Inspec. Admi $135,000.00 $8,400.00 $30,082.34 $104,917.66 78.00% General Emergency Managem $1,850.00 $648.87 $759.60 $1,090.40 59.00% General Signal Lights $750.00 $0.00 $73.75 $676.25 90.00% General Animal Control $1,100.00 $322.29 $669.64 $430.36 39.00% General Street Maintanence $207,010.00 $16,563.25 $69,528.79 $137,481.21 66.00% General Ice & Snow Removal $50,360.00 $10,124.54 $28,378.33 $21,981.67 44.00% General Engineering Fee $40,000.00 $0.00 $6,736.08 $33,263.92 83.00°10 General Street Lighting $36,000.00 $1,107.17 $9,264.07 $26,735.93 74.00% General Street Cleaning $21,430.00 $1,171.07 -$1,523.44 $22,953.44 107.00% General Bafl Park and Skating $4,400.00 $2,007.68 $3,577.14 $822.86 19.00% General Maint Shop $21,700.00 $1,536.15 $7,164.01 $14,535.99 67.00% General Park Areas $145,795.00 $3,431.47 $38,311.99 $107,483.01 74.00% FUND 101 General $2,075,495.00 $148,166.92 $591,486.42 $1,484,008.58 72.00% FUND 105 Fire Fun d Fire Fund Fire Administration $2,300.00 $1,736.52 $2,301.87 -$1.87 0.00% Fire Fund Fire Fighting $118,800.00 $4,234.34 $27,535.78 $91,264.22 77.00% Fire Fund Fire Training $5,000.00 $862.05 $8,246.05 -$3,246.05 -65.00% Fire Fund Fire Communications $4,000.00 $382.47 $1,472.65 $2,527.35 63.00% Fire Fund Medical Services $1,500.00 $0.00 $109.20 $1,390.80 93.00% Fire Fund Fire Station and Buiidi $15,600.00 $1,498.51 $5,490.63 $10,109.37 65.00% Fire Fund Community Room $500.00 $0.00 $29.31 $470.69 94.00% FUND 105 Fire Fund $147,700.00 $8,713.89 $45,185.49 $102,514.51 69.00% FUND 150 Econom ic Development Economic De Economic Developme $10,450.00 $2,400.67 $15,091.68 -$4,641.68 -44.00°10 FUND 150 Economic Development $10,450.00 $2,400.67 $15,091.68 -$4,641.68 -44.00% $2,233,645.00 $159,281.48 $651,763.59 $1,581,881.41 71.00% 04!10/08 3:53 PM Page 1 CITY OF ST JOSEPH Council Month End Revenue -Enterprise Funds Current Period: March 2008 2008 Of FUND 2008 YTD March 2008 2008 YTD Budget FUND Descr SOURCE Descr Budget 2008 Amt YTD Amt Balance Remain FUND 601 Water Fund 601 Water Fund Interest Eamings $50,000.00 $5,875.07 $15,017.53 $34,982.47 69.96% 601 Water Fund Water Tower Antenna Lease $22,000.00 $1,680.11 $5,040.33 $16,959.67 77.09% 601 Water Fund Rate Class One $300,000.00 $10,374.73 $49,838.46 $250,161.54 83.39% 601 Water Fund Undesignated Funds $0.00 $589.69 $2,696.61 -$2,696.61 0.00% 601 Water Fund Penalties and Forfeited Disc $500.00 $293.67 $1,590.89 -$1,090.89 -218.18% 601 Water Fund Water Surcharge - (Monthly} $90,000.00 $4,209.71 $19,194.40 $70,805.60 78.67% 601 Water Fund MDS Test Fee $9,000.00 $482.54 $2,191.24 $6,808.76 75.65% 601. Water Fund State Sales Tax $200.00 $12.05 -$914.42 $1,114.42 557.21% FUND 601 Water Fund $471,700.00 $23,517.57 $94,655.04 $377,044.96 79.93% FUND 602 Sewer Fund 602 Sewer Fund Penalties and Forfeited Disc $2,000.00 $201.08 $962.10 $1,037.90 51.90% 602 Sewer Fund Sanitary Sewer Service $206,795.00 $9,155.71 $45,699.58 $161,095.42 77.90% 602 Sewer Fund Sewer Line Charge $50,000.00 $3,199.49 $14,659.51 $35,340.49 70.68°k 602 Sewer Fund Interest Earnings $35,000.00 $6,160.97 $13,338.78 $21,661.22 61.89% FUND 602 Sewer Fund $293,795.00 $18,717.25 $74,659.97 $219,135.03 74.59% FUND 603 Refuse Collection 603 Refuse Collec State Sales Tax $17,000.00 -$1,424.35 -$5,581.47 $22,581.47 132.83% 603 Refuse Collec Refuse Collection Charges $237,170.00 $11,025.38 $50,961.65 $186,208.35 78.51% 603 Refuse Collec Penalties and Forteifted Disc $2,000.00 $318.15 $1,493.60 $506.40 25.32% 603 Refuse Collec Interest Eamings $10,000.00 $1,532.82 $3,295.70 $6,704.30 67.04% FUND 603 Refuse Collection $266,170.00 $11,452.00 $50,169.48 $216,000.52 81.15°k FUND 651 Storm Water Utility 651 Storm Water Penalties and Forteifted Disc $500.00 $60.84 $415.60 $84.40 16.88% 651 Storm Water Interest Earnings $3,000.00 $1,792.34 $3,768.45 -$768.45 -25.62% 651 Storm Water Rate Class One $80,000.00 $5,106.72 $22,143.86 $57,856.14 72.32% FUND 651 Storm Water Utility $83,500.00 $6,959.90 $26,327.91 $57,172.09 68.47% $1,115,165.00 $60,646.72 $245,812.40 $869,352.60 77.96°~ 04/10/08 3:55 PM Page 1 CITY OF ST JOSEPH Council Month End Expenditure -Enterprise Funds Description DEPART Descr FUND 601 Water Fund Water Fund Bond Payment (P & I) Water Fund Other Financing Uses Water Fund Power and Pumping Water Fund Purification Water Fund Purification-Plant 2 Water Fund Distribution Water Fund CIP-Treatment Plant Water Fund CIP-Trunk Water Mains Water Fund CIP-Municipal Wells Water Fund CIP-Wellhead Protection Water Fund Storage Water Fund Storage-Tower 2 Water Fund Wa Meter Installation Water Fund Administration and Gene Water Fund Depreciation Expense FUND 601 Water Fund Current Period: March 2008 2008 2008 2008 YTD March 2008 YTD %YTD Budget 2008 Amt YTD Amt Balance Balance $657,660.00 $50,000.00 $13,600.00 $13,225.00 $39,600.00 $25,200.00 $0.00 $0.00 $0.00 $1,000.00 $2,400.00 $0.00 $413,000.00 $202,245.00 $0.00 $1,417,930.00 $0.00 $0.00 $510.51 $257.81 $6,346.33 $0.00 $2,822.42 $0.00 $0.00 $0.00 $314.69 $8,375.00 $4,118.72 $29,102.31 $0.00 $51,847.79 $0.00 $0.00 $2,621.62 $2,214.85 $15,844.28 $5,420.14 $61,303.17 $0.00 $0.00 $0.00 $924.83 $16,750.00 $70,060.42 $373,955.88 $0.00 $549,095.19 $657,660.00 $50,000.00 $10,978.38 $11,010.15 $23,755.72 $19,779.86 -$61,303.17 $0.00 $0.00 $1,000.00 $1,475.17 -$16,750.00 $342,939.58 -$171,710.88 $0.00 $868,834.81 100.00% 100.00% 81.00% 83.00% 60.00% 78.00% 0.00% 0.00% 0.00% 100.00% 61.00% 0.00% 83.00% -85.00% 0.00% 61.00% FUND 602 Sewer Fund Sewer Fund Bond Payment (P & I) $48,690.00 $0.00 $0.00 $48,690.00 100.00% Sewer Fund Other Financing Uses $50,000.00 $0.00 $0.00 $50,000.00 100.00% Sewer Fund Sanitary Sewer Maintena $157,585.00 $7,225.93 $23,293.28 $134,291.72 85.00% Sewer Fund Lift Station-Baker Street $4,000.00 $409.93 $1,587.12 $2,412.88 60.00°k Sewer Fund Lift Station-DBL Labs Ar $3,500.00 $407.20 $1,527.02 $1,972.98 56.00°k Sewer Fund Lift Station-Northland $2,800.00 $368.54 $1,413.90 $1,386.10 50.00% Sewer Fund Lift Station-CR 121 $3,000.00 $1,651.91 $2,704.58 $295.42 10.00% Sewer Fund Sewage Treatment Plant $216,020.00 $16,862.03 $56,955.17 $159,064.83 74.00% Sewer Fund Administration and gener $45,255.00 -$2,028.93 $15,289.80 $29,965.20 66.00% Sewer Fund Depreciation Expense $0.00 $0.00 $0.00 $0.00 0.00% FUND 602 Sewer Fund $530,850.00. $24,896.61 $102,770.87 $428,079.13 81.00% FUND 603 Refuse Collection Refuse Colie Waste Collection $275,770.00 $21,188.93 $66,354.49 $209,415.51 76.00% Refuse Colle Other Financing Uses $0.00 $0.00 $0.00 $0.00 0.00% FUND 603 Refuse Collection $275,770.00 $21,188.93 $66,354.49 $209,415.51 76.00% FUND 651 Storm Water Utility Storm Water Other Financing Uses $69,275.00 $0.00 $0.00 $69,275.00 100.00°h Storm Water Storm Water Administrati $3,300.00 $62.50 $10,592.75 -$7,292.75 -221.00% Storm Water Depreciation Expense $0.00 $0.00 $0.00 $0.00 0.00% FUND 651 Storm Water Utility $72,575.00 $62.50 $10,592.75 $61,982.25 85.00% $2,297,125.00 $97,995.83 $728,813.30 $1,568,311.70 68.00% 04/10/08 3:53 PM Page 1 Council A enda Item 4 CITY qF' NT..JC1Fil~l~t g MEETING DATE: April 17, 2008 AGENDA ITEM: Quarterly Finance Position -Requested Action: Accept the 1 S` Quarter 2008 Financial Reports SUBMITTED BY: Finance BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N/A PREVIOUS COUNCIL ACTION: None BACKGROUND INFORMATION: Quarterly reconciled cash/investment and budget to actual position for Council review. BUDGET/FISCAL IMPACT: None ATTACHMENTS: ls` Quarter 2008 Financial Position Summaries/CIP Updates REQUESTED COUNCIL ACTION: Accept the ]S` quarter 2008 financial positions as presented. City of St. Joseph, Minnesota Cash Position AS of 3/31 J08 First State Bank Checking Account (Reconciled) Money Market Savings Brokered Certificates of Deposit averages Total FSB Central MN Federal Credit Union Share Savings Account Money Market Savings Power Money Market Checking Jumbo Bank Certificates of Deposit averages Total CMFCU Total Deposits Salomon Smith Barney Brokered Money Market Savings Government Securities/Notes Brokered Certificates of Deposit averages Total SSB Northland Securities Brokered Money Market Savings Brokered Certificates of Deposit avereges Total NS Cash Neld in Escrow (Bands) Totat Investments Total Deposits and Investments Average Interest APY Petty Cash Maturity Date Interest Current Balance # Securities % of Total N/A 0.4% $ 153,118 N/A N/A 2.35% 12,614 N/A Tiered 1-60 months 4.80% avg 7,783,979 19 21 months 3.58°~ $ 7,949,711 66% N/A 0% $ - N/A N/A 0.50% 12 N/A N/A 1.00% 5,286 N/A Tiered 9-72 months 4.73% avg 2,045,126 7 21 months 2.61% $ 2,050,424 17°k $ 10,000,135 N/A 2.64% $ 239,793 N/A all called early 0.00% avg - 0 Tiered 3-80 months 4.63% avg 1,539,289 16 49 months 3.B3% $ 1,779,082 15% N/A 2.27% $ 577 N/A 12 month CDs 5.02% avg 295,823 3 6 months 3.64% $ 296,400 2% $ - 0% $ 2,075,482 $ 12,075,617 3.37% Administration N/A N/A $ 200 Police Department N/A N/A 75 Total Petty Cash $ 275 Custodial Credit Risk: All deposits and investments insured by FDIClSPIC/NCUSIF or secured by pertected pledged collateral. Interest Rate Risk: The City is not exposed to interest rate risk because the City does not invest in highly sensitive, interest fluctuating investments. The City attempts to purchase longer termed investments when the interest rates are favorable and depending on cash flow needs to lock into a favorable rate. Credit Risk: There are no instruments exposed to credit risk. Concentration of Credit Risk: The City invests in various instruments and several financial institutions. Brokered Money Markets $ 240,370 12% Brokered Certificates of Deposit $ 1,835,112 88% Govemment Bonds/Notes $ - 0°k State/Local Govemment Securities $ - 0°k Foreign Currency Risk: The City only invests in USA and USA territories. C o o - ~ ~ ~ ~~ ~ 0 r y : W O ~~ h N O fA 64 u~ ~v W ~ 4f7 ~ 00 N O ~ 'tD . Gp- ` u~ . (O (~l cp M ~ O ~ o ~_ .r1 P. .~ ~. ~ . s W (h O P ~ r' N !~ O 'f'7 N f' V V' ~ h`" O ~ ~ _ U ~ ~ Y ' 1. f0 W ~ y .. $ 1~ -~~ Q: 0 ~ ~ ~ ~ O ~ f0 O ~ W V ~ . _ ~ [h ~-co -~ `,. .fir i -~ ^ N N m N ~:~ k' t: s O ~ i ' ~a* / 6, = o o ~,". o ~ ~ R I~ co ~ al y .~a N a1 '~ e 1: '~ ~~ '~~ ~q'ri 5~: fi ~' m d' lt7 u (`. ~ ~ ~1 ~ ii. , M O O ~~ c., C' ' ~1; d C 'C LL aD ~~ W c, cr - p= C C W J m C ~ O C ~ ~ c E F V U ~ e. r N _ . fl. ~ ~ C 1 A A ~ i ~ ~' + ~ I.;, N V M ~ M O , N .. m ~ ~b r3h~j c~ ~. -.. ro ~A Y oil N O ~ 0 ~ v~ O ~; H O m N ~ s ~ cJ ~ u~ f ti r T: ~ .. ~ ~2] m 07 rn c0 n N t ~'' ~¢ V1 v W rn u~ a M v ~ ~ ci ~ s ~. ~. ~r, '~ P O m O ~ = o ~ y ~ ~- ~ O n ~ ' m ~ » ~ _ V N (0 U ~ ` O O ~ O O CD G O j m n '- Ut N n i` .. W N <r tS ~ O t. 4,; ~O N O a~ N o r~ o-i n V'. ~~ rn (~ , m N vJ V CC ~ a ~ , ~ r rt ~~ L] r- in u~ ~ '_n '~ CO ~f) ~ N W U f7 O cV (`'J ~" V' D ,GJ I~ O u7 !V C I cD ,S? (0 w ,<f ~O fD ~ O si O C Z O) a0 ~ cV r_ o n i- [ ~~ C O ~ ~~ ~ m o ~ I . ~ M cD cO :rr] v 1~ O N ~~ ~ ° ~ "?~" N M e- m ~ ~. N U ' ; is ' r , ~~ r ~? ~' ~ t~ w,t 3 x m c ~ o ~ 'o f•._ ' N 'L '7 N C m tl! ~{ s ~ ~: ` c ~ w G Gam: u ~ ~ ~ lL tq n N N rt ; . ~ ~ ,.,~ ~ Z in 'C ~ C! C ~ ~ 1 O ~ ti (0 LL~ C ~ "' Ui o ~. O ~ 9 T O O U lL ~ .- O ~• 3 rn Z '~ C ~ M LL a i-c ~ p x ~, ~' ~ ~.ta ~ '~ - ~ a S~ ~ ~i rkC. ~ ~'. ~ ~ ? p ~ ` i 'm m i 'tt ~o y m L ^ ' ~ ~ d '~ ~ m m t0 A 'm ar =~ C7 u: w ~ a -~ ~ v ~ o v ;~ ~ -m ~ .tq City of St. Joseph, Minnesota Capital Improvement Plan -Department Summary 2008 Equipment Certificates Council Approved March 6, 2008 As of March 31, 2008 Reserve Adopted Spent Account Code Department Object Funds 2008 2008 442-41430-570 Administration Offce Equipment 11,000.00 15,000.00 442-41430-581 Administration Computer Hardware 18,953.00 12,000.00 6,649.86 442-41430-582 Administration Computer Software - 22,000.00 442-41530-581 Finance Receipting Work Station - 3,000.00 Total Administration 29,953.00 52,000.00 6,649.86 442-42120-580 Police -General General Equipment - 10,650.00 697.53 442-42151-580 Police -Communications Communication Equipment - 17,500.00 17,500.00 442-42152-550 Police -Automotive Motor Vehicles - 35,000.00 Total Police - 63,150.00 18,197.53 442-43125-520 Ice & Snow Removal Buildings & Structures - 100,000.00 442-43125-580 Ice & Snow Removal Other Equipment - 35,000.00 442-45201-580 Maintenance Communication Equipment 13,000.00 17,500.00 22,528.85 Total Public Works 13,000.00 152,500.00 22,528.85 Total Capital Imp rovement -Equipment Certificates 42,953.00 267,650.00 47,376.24 f0 ~, 3 v V1 pp O W m 0J '~'' .+~-' O c ~ e ~ ~ .-i _ ~ f`6 M O. C N t N ~ ~ L O a °' ~ ~ ~ V1 ~ O O w ~ ON ~ o ~ ~ Q o a t~ Cam, a G ~ M Q 'c S6 v O O N N N ~+ O O i N M O O ~ ° ~ v ~ ~ O o. ~ a1 O O O O O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O O O O O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O ,a O 0 0 ~ 0 0 0 V1 ~ 111 O I.f1 0 0 V1 0 0 0 0 0 0 0 0 0 0 0 ~ + CO a O O O O O N .-~ O h 0 0 ~--~ 0 0 0 0 0 0 0 0 0 0 0 rl Q 0 O O O O O 'c!' N O 01 M O 01 0 0 V1 O u1 O X11 u1 O u1 V1 ~ 0 ,~ N N N M O O N O1 M tD N r-I N ~ ~f1 ~ M ^ ~!1 ~ r-1 M V1 ~ a f ~ .~ , ~ 0 0 01 0 0 ~-1 o rn o 0 0 0 o a1 0 0 0 0 ~ o 0 0 0 0 ~ v ~ o o m o o ~o o ul N OO O O O VI oo o o o m o o o o ~rl ~c ao N y~ O nl M O O Op IJ) l0 O ~ v1 LI') O M 00 O O O m 0 0 0 0 I~ 01 N ~ . ~= 0 O ' 00 lD N ~"'~ ' O O O O V1 1.11 N a h N ri L/1 ~!1 r-I h N M M O ct h M ei ~ Ql O C~ O to O O ' M O ~-i N h N O ~ O 0 Ql 0 N Q~ t0 00 ~ y 3 OO n N l0 O 01 tD h N 00 Ol Gr 00 00 Il) M M M t1) 01 r-1 O 00 h llf ~ H. N N N h e-1 ~ Lf1 h 00 r1 M N Q a 'O C ~ ~ m N ~ m ~ C ~ ~ j Y C ~ V ~+ c ++ c 3 _ 3 c c Y c c°0a ~ c ~ c ~ c ~ ~ G1 ~ 41 ~ O N $ >, "p G1 ~ H y 41 ~ i ~ ~^ N N ~ C ~ N ~ d ~ L v N ~ L ~ ~ O o. '_ a '3 x ~ O v1 L 3 rn tr a 7 ~ ~ o. ~7 -c O " 'L O_ 7 ~ a ~3 _Q. ~7 ' ~ _c 3 s O Q. 3 ~ ~ ~ +~+ en ,4; 6 N ~ ~ y ~ O > O' y of ~ a '^ dD ~ y 6 W W ~ ~ ~ (0 ~ W L W a > ~ W f9 m W L c i > L t ;} E ~ 'v c E t O t Q N a O t ++ s .c - t a L +-' O '+- O O v O U to LL N C~ O v +' O ~ +~ O f° ~ ~n ~ ~ ++ O N o t+ 0 ++ 0 ~ m t+ 0 ~ +-~ O - U U U m C i~+ > > tOi C C U C C > O ~ Y ~ ~ 41 ~ ~ ~, O }, O > ~a co ro ~ ~ ~p Y 3 ~ _ O O O %1 p N O ~ C ' Q ~ = O O 1 a + + a .+ a ~ + O d f° ~ o ~ a ~ o ~ _ £ .r 3 +~ O ~, a ~ !~ c 'fC c 'rp c ~fC c 'cp ~ ., t a O O. O c ~ v d p n ~ ~ y 'a Q Q ~ p ~ ~ ~ ~ °c ~ ~ i Y ~ = ~ c ,, c 'c ' a o. N v i `0 a o_ +' ' ' c ' ;,., v ~ v v a~ a~ ~ .~ ~ +~ +. ~ .r .., .r C a N _ ~ ~ ~ - 10 U U U ,U U U y t6 N GJ ~ ~ Ol ~ . f0~ -_ Y f0 C Q O O O O O O O E O +`+ .~ +~+ +`.+ U a`+ cc C ~ t0 O W a Q LL ~ d a a a a a w ~- to v1 cn N v1 G G m O. ~ O d Q, O O O ~ N O O ~-i 0 0 0 0 O O O N O 0 0 0 0 0 U 00 h 00 00 O 00 00 00 111 00 00 00 M lf1 00 00 00 00 N 00 M Op ~ ~+ 1.(1 111 L17 l!1 M 111 L11 LI'1 lrl L(1 111 L(1 L/1 ul L(1 lfl Lf1 111 ~ 111 L!1 L!1 C O O i O O O O M O ~ O i c-1 N i N N i O O ~ O ~ O ~ O ~ 111 O ~ r'I e-i ~ M i N ~ O ri M M M ~ N N Lfl Lf1 111 Lry O N N N N N l0 O O N O a O V Ct ~ CF ~ Ol ei ei c-i ~-i ei r-I t11 ri ei N rl ri e-I N ' N r-I N V U e-1 .1 e-1 r-1 s-~ N N N N N N N M M M M M M u 1 ul 111 In Q a' d' ~ ~ cr tt ~ d' d' d' ~ ~ ~ ct ~ ~ ~ d' ~ ~ ~ ~ ~ O O O O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ++ 01 O1 01 O1 01 O1 01 41 01 01 O1 01 O1 41 O1 01 O1 O1 O1 O1 Q1 01 O d' el' d' ~ ~ ct ~ d' ~ ~ ~ ~ ~ C ~ d' ~ ~ ~ ct ~ ~ 1- v v v a > x v w ~ v v 0 0 0 .+-+ .; ++ V Q N C LL N ~L Q. L W Y i-~ ~ U m Q ^V/ W C C. K W c~ V Q O m (d 0 m Y N d a 0 W v v v °o °o °o °o °o 0 0 0 0 0 °o °o °o o °o in o vi o ~n N N H ~--I