HomeMy WebLinkAbout[06a] Financial Reportc:z~• o~ s'r..it~h rH
Council Agenda Item
MEETING DATE: October 15, 2009
AGENDA ITEM: Financial Report -Requested Action: Accept the 3`d Quarter 2009 and
September 2009 Financial Reports
SUBMITTED BY: Finance
BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N/A
PREVIOUS COUNCIL ACTION: None
BACKGROUND INFORMATION: Quarterly and monthly reconciled cash/investment and budget to
actual position are provided for Council review. The charts presented are to assist your visual
understanding of the last quarter's financial summaries. The numbers presented are the numbers as of
September 30, 2009.
There are a couple points I would like to highlight from the reports.
CASH POSITION:
- The City has investments in money market accounts, bank CDs, brokered CDs and government
securities. The City has reviewed other investment options, but the rates of return are less
favorable and more volatile in the current market. The City holds an investment for the 2009A
cross-over refunding bonds. The 2009A bond investment is held in escrow until the cross-over
date of December 1, 2009. Bond escrow money is not available for current City expenses.
- Overall, the cash and investments balance increased to $4,915,882 ($1,930,562 without the
2009A bonds) from the beginning of the year. The increase is amibutable to two other refunding
bonds issued in 2009. The principal portion of the bond payments due December 1s` will draw
down the cash and investments balance.
- The cash position represents 2.25 months of the year's expenditures.
FUNDS REPORT:
- The General fund spent down 69% of the 2009 budget and received 58% of the revenue budget.
Without the transfers made into the General fund, the revenues received represent 51% of the
revenue budget. The City anticipates receiving the first half market value credit state aid the end
of October. The state police and fire aid was received on September 30`". The remaining
significant General fund revenues will be received in December including the second half
property tax settlement from Stearns County and the second half LGA and market value credit
from the State.
- The transfers approved at the October 1 S` Council meeting will be reflected in the next month's
Treasurer's report. The funds will be moved to make bond payments in November.
- The Enterprise Funds show expenses greater than revenues. This is due to 9 months worth of
expenses incurred, but only 8 months of utility usage has been billed as of September 30`h. The
July and August 2009 utility usage was billed in September, but the due date is not until October.
A significant portion of this billing period will be collected after September and will not be
reflected in the current financial reports.
CIP REPORTS:
- The 2009 CIP reports are shown without the 2008 and 2009 capital budgets as a result of the
Council's decision to reduce the capital expenditures to cover portions of the Governor's
unallotment. There is also a column showing the CIP amounts if the capital budget for 2008 and
2009 was still in place. There has been very little capital expenditure activity in 2009.
- The crack fill project completed in 2009 is reflected in the General fund budget versus the capital
reports. The Council approved the funding for the project to come from the Streets department.
The crack fill project cost approximately $65,000.
BUDGET/FISCAL IMPACT: Information Only
ATTACHMENTS: 3`d Quarter 2009 Financial Position Summaries/CIP Updates
September 2009 Treasurer's Report
REQUESTED COUNCIL ACTION: Accept the 3`d Quarter 2009 and September 2009 financial
reports as presented.
r CITY OF ST JOSEPH
/
~
~
~ ~~~
Cash and Inv estment- Council Report
Current Period: September 2009
Current
FUND FUND Descr Begin Yr YTD Debit YTD Credit Balance
101 General $505,737.24 $2,192,022.50 $2,311,911.72 $385,848.02
105 Fire Fund $476,173.24 $254,905.12 $162,693.86 $568,384.50
108 Cable Access Fee $18,081.74 $6,795.64 $799.74 $24,077.64
150 Economic Development $21,974.87 $33,046.32 $43,849.83 $11,171.36
156 TIF 1-4 St. Joe Development $26,638.18 $57,228.25 $53,347.16 $30,519.27
157 TIF 2-1 Millstream $5,747.09 $8,969.09 $14,573.76 $142.42
200 State Collected Sales Tax $624,429.86 $210,631.59 $2,995.95 $832,065.50
205 Park Dedication $59,424.72 $2,932.48 $16,859.57 $45,497.63
210 Recreation Center $48,136.81 $1,587.40 $24.56 $49,699.65
215 Charitable Gambling $0.00 $6,704.89 $2,102.98 $4,601.91
230 Lake Wobegon Trail $22.92 $5,000.00 $0.00 $5,022.92
232 City Beautification-College Av $59.11 $0.00 $0.00 $59.11
250 Revolving Loan Fund $52,547.82 $1,732.84 $26.81 $54,253.85
318 2009A CrossoverRefunding Bonds $0.00 $5,990,590.24 $3,005,270.60 $2,985,319.64
318 2009A CrossoverRefunding Bonds $0.00 $1,971.33 $976.94 $994.39
320 2007 Refunding (98/99 St Bond) $380,307.69 $81,669.69 $43,822.59 $418,154.79
321 Joseph Street Improvement $33,433.39 $2,353.06 $259.38 $35,527.07
322 City Hall Refunded, 2005 $3,922.27 $87,824.39 $46,195.34 $45,551.32
323 20041mprovements/Northland $83,613.05 $30,347.14 $13,577.81 $100,382.38
325 2002 Street Improvement $623,881.81 $184,561.92 $88,684.80 $719,758.93
328 2003 Liberty Pointe Street Imp $303.32 $1,157.79 $220.26 $1,240.85
329 2003 Maintenance Facility $2.63 $532,905.84 $32,661.36 $500,247.11
331 2003 Refunding Fire Hall $137,738.87 $89,998.83 $40,806.14 $186,931.56
332 2003 Cross Over (93 Streets) $124,351.76 $34,395.11 $12,831.41 $145,915.46
333 2005 Improve (HilUClover) $602,729.24 $84,349.23 $58,114.18 $628,964.29
335 Northland Heights(frans Corrid $564,379.94 $671,377.31 $330,433.40 $905,323.85
337 2006 Equipment Certificate $7,900.37 $55,553.40 $24,564.24 $38,889.53
338 2006 Interior St Improvements $785,185.12 $156,810.79 $86,962.45 $855,033.46
341 2007 St Imprv-E Side/Jade/8 Av $372,036.99 $360,903.43 $134,708.45 $598,231.97
342 2008 Equipment Certificates $9,523.23 $50,619.49 $25,444.20 $34,698.52
343 20098 GO CIP Bonds $0.00 $19,637.20 $19,055.75 $581.45
390 Debt Service Relief $116,642.75 $4,883.48 $566.46 $120,959.77
435 Northland HeightslTrans Corrid $548,205.56 $23,690.56 $223,863.20 $348,032.92
441 2007 Street Impr (Jade Rd/E $504,478.86 $8,411.89 $20,057.86 $492,832.89
490 Capital Outlay $346,461.81 $21,984.13 $119,276.04 $249,169.90
501 Water Extension $514,426.39 $283,779.78 $262.71 $797,943.46
502 Sewer Extension $608,551.30 $162,857.60 $29,306.08 $742,102.82
601 Water Fund $640,567.84 $398,464.86 $501,969.61 $537,063.09
602 Sewer Fund $564,840.08 $528,635.96 $320,538.58 $772,937.46
603 Refuse Collection $273,169.52 $237,662.99 $236,464.49 $274,368.02
651 Storm Water Utility $263,517.22 $96,307.19 $43,298.79 $316,525.62
10/06/09 3:08 PM
Page 1
$9,949,144.61 $12,985,260.75 $8,069,379.06 $14,865,026.30
i CITY OF ST JOSEPH
Council Month End Expenditure -Enterprise Funds
Current Period: September 2009
Description DEPART Descr
FUND 601 Water
Water Fund
Water Fund
Water Fund
Water Fund
Water Fund
Water Fund
Water Fund
Water Fund
Water Fund
Water Fund
Water Fund
Water Fund
Fund
Bond Payment (P 8 I)
Other Financing Uses
Power and Pumping
Purification
Purification-Plana 2
Distribution
CIP-Wellhead Protection
Storage
Wa Meter Installation
Water Maintenance
Administration and general
Depreciation Expense
FUND 601 Water Fund
FUND 602 Sewer Fund
Sewer Fund Bond Payment (P & I)
Sewer Fund Other Financing Uses
Sewer Fund Sanitary Sewer Maintenanc
Sewer Fund Lift Station-Baker Street
Sewer Fund Lift Station-DBL Labs Area
Sewer Fund Lift Station-Northland
Sewer Fund Lift Station-CR 121
Sewer Fund Sewage TreatmenUMain St
Sewer Fund Administration and general
Sewer Fund Depreciation Expense
FUND 602 Sewer Fund
FUND 603 Refuse Collection
Refuse Collectio Waste Collection
Refuse Collectio Other Financing Uses
Refuse Collectio Administration and general
FUND 603 Refuse Collection
FUND 651 Storm Water Utility
Storm Water Uti- Other Financing Uses
Storm Water Util Administration and general
Storm Water Util Storm Water Maintenance
Storm Water Util Depreciation Expense
FUND 651 Storm Water Utility
2009 September 2009
YTD Budget 2009 Amt YTD Amt
$545,192.00 $0.00 -$213,107.05
$55,000.00 $0.00 $0.00
$16,700.00 $12,300.31 $19,276.96
$16,320.00 $150.72 $11,425.70
$46,520.00 $6,040.67 $48,139.01
$22,200.00 $5,820.26 $21,678.75
$1,000.00 $0.00 $0.00
$2,300.00 $174.86 $1,903.47
$0.00 $0.00 $148.19
$227,145.00 $11,100.92 $129,677.90
$0.00 $2,820.45 $23,033.86
$185,000.00 $0.00 $0.00
$1,117,377.00 $38,408.19 $42,176.79
$47,663.00 $b.00 -$15,326.48
$55,000.00 $0.00 $0.00
$162,505.00 $7,984.01 $71,350.04
$5,000.00 $2,666.18 $5,205.64
$4,500.00 $150.71 $2,169.04
$3,800.00 $115.63 $2,061.15
$4,000.00 $1,255.00 $4,426.89
$170,600.00 $12,872.07 $107,332.68
$55,595.00 -$f 1,731.33 $60,826.14
$200,000.00 $0.00 $0.00
$708,663.00 $13,312.27 $238,045.10
$280,280.00 $25,311.98 $196,883.66
$0.00 $0.00 $0.00
$0.00 $0.00 $27.59
$280,280.00 $25,311.98 $196,911.25
$44,075.00 $0.00 $0.00
$0.00 $1,472.63 $13,292.96
$39,545.00 $5,069.88 $27,127.50
$80,000.00 $0.00 $0.00
$163,620.00 $6,542.51 $40,420.46
$2,269,940.00 $83,574.95 $517,553.60
10/06/09 3:13 PM
Page 1
rl CITY OF ST JOSEPH
~
Council Month End Expenditure -G eneral Fund
Current Period: September 2009
2009 September 2009
Description DEPART Descr YTD Budget 2009 Amt YTD Amt
FUND 101 General
General Council $55,995.00 $3,605.78 $26,457.07
General Legislative Commities $10,230.00 $0.00 $2,088.19
General Ordinance 8 Proceedings $9,950.00 $784.99 $1,450.19
General Mayor $12,425.00 $896.98 $5,940.26
General Elections $2,000.00 $0.00 $295.51
General Salaries &Adminstrative $219,515.00 $18,923.89 $145,092.59
General Accounting $163,330.00 $7,500.29 $90,511.12
General Audit Service $25,650.00 $0.00 $23,920.00
General Assessing $19,000.00 $0.00 $18,570.79
General City Attorney $28,000.00 -$216.75 $9,250.40
General Planning and Zoning $54,270.00 $56.00 $2,452.20
General General Government $28,200.00 $1,347.95 $13,449.56
General City Offices $24,050.00 $3,069.66 $19,679.16
General Facilites and Planning $10,000.00 $0.00 $0.00
General Cable Access $14,540.00 $1,124.94 $8,664.57
General Crime Control 8 Investigation $812,010.00 $56,988.58 $574,956.39
General Police Training $10,000.00 $6.00 $4,513.44
General Communication Service $21,670.00 $570.71 $7,452.84
General Automotive Services $73,475.00 $3,749.45 $33,414.64
General Building Inspec. Admistration $121,050.00 $9,750.00 $74,265.94
General Emergency Management $2,950.00 $7.23 $1,813.86
General Signal Lights $400.00 $69.39 $619.37
General Animal Control $1,600.00 $90.20 $792.85
General Ordinance/Easement Enforcement $600.00 $0.00 $0.00
General Street Maintanence $224,365.00 $73,852.40 $188,292.32
General Ice 8 Snow Removal $70,385.00 $0.00 $46,941.20
General Engineering Fee $40,000.00 -$6,252.99 $20,201.52
General Street Lighting $45,000.00 $9,182.71 $33,446.85
General Street Cleaning $23,240.00 $0.00 $9,440.30
General Ball Park and Skating Rink $5,250.00 $35.51 $2,533.74
General Maint Shop $45,395.00 $1,340.76 $13,251.91
General Park Areas $242,486.00 $20,728.44 $149,245.56
General Communty Support $11,100.00 $220.99 $4,313.54
General Other Financing Uses $42,010.00 $0.00 $21,005.00
General Fire Protection $84,800.00 $0.00 $73,555.95
_.
FUND 101 General $2,554,941.00 $207,433.11 $1,627,878.83
FUND 108 Cable Access Fee
Cable Access Fee Cable Access $0.00 $0.00 $799.74
FUND 150 Economic Development
Economic Development Economic Development Authority $35,540.00 $2,612.07 $37,865.26
FUND 150 Economic Development $35,540.00 $2,612.07 $37,865.26
FUND 490 Capital Outlay
Capital Outlay Elections $0.00 $0.00 $0.00
Capital Outlay Salaries &Adminstrative $0.00 $287.49 $3,836.02
Capital Outlay City Offices $0.00 $0.00 $0.00
Capital Outlay Cable Access $0.00 $0.00 $0.00
Capital Outlay Crime Control 8 Investigation $0.00 $0.00 $1,329.07
Capital Outlay Communication Service $0.00 $0.00 $0.00
Capital Outlay Automotive Services $0.00 $0.00 $0.00
Capital Outlay Emergency Management $0.00 $0.00 $0.00
Capital Outlay Street Maintanence $0.00 $0.00 $1,654.06
Capital Outlay Ice 8 Snow Removal $0.00 $0.00 $0.00
10/06/09 3:12 PM
Page 1
r'
~~r ~~~ 7 .
Description
Capital Outlay
Capital Outlay
Capital Outlay
Capital Outlay
Capital Outlay
FUND 490 Capital Outlay
CITY OF ST JOSEPH
Council Month End Expenditure -General Fund
Current Period: September 2009
2009 September 2009
DEPART Descr YTD Budget 2009 Amt YTD Amt
Street Lighting $0.00 $0.00 $0.00
Ball Park and Skating Rink $0.00 $0.00 $0.00
Maint Shop $0.00 $0.00 $0.00
Park Areas $0.00 $0.00 $52.06
Other Financing Uses $0.00 $0.00 $0.00
$0.00 $287.49 $6,871.21
$2,590,481.00 $210,332.67 $1,673,415.04
10/06/09 3:12 PM
Page 2
fi
CITY OF ST JOSEPH
Council Month End Expenditure Summary
Current Period: September 2009
2009 September 2009
FUND Description YTD Budget 2009 Amt YTD Amt
101 General $2,355,641.00 $207,433.11 $1,627,878.83
105 Fire Fund $239,295.00 $13,046.82 $114,287.40
108 Cable Access Fee $0.00 $0.00 $799.74
150 Economic Development $31,700.00 $2,612.07 $37,865.26
155 TIF 1-3 Borgert (SKN) $0.00 $0.00 $5,948.15
156 TIF 1-4 St. Joe Development $0.00 $0.00 $30,166.31
157 TIF 2-1 Millstream $0.00 $0.00 $8,945.33
200 State Collected Sales Tax $0.00 $0.00 $130.80
205 Park Dedication $0.00 $134.22 $16,702.76
215 Charitable Gambling $0.00 $0.00 $2,100.00
318 2009A CrossoverRefunding Bonds $0.00 $0.00 $73,075.71
320 2007 Refunding (98/99 St Bond) $0.00 $0.00 $16,349.01
322 City Hall Refunded, 2005 $0.00 $0.00 $11,210.26
323 20041mprovements/Northland $0.00 $0.00 $2,470.26
325 2002 Street Improvement $0.00 $0.00 $54,122.76
328 2003 Liberty Pointe Street Imp $0.00 $0.00 $220.26
329 2003 Maintenance Facility $0.00 $0.00 $11,611.51
331 2003 Refunding Fire Hall $0.00 $0.00 $11,519.01
332 2003 Cross Over (93 Streets) $0.00 $0.00 $2,986.51
333 2005 Improve (Hill/Clover) $0.00 $0.00 $27,752.76
335 Northland Heights/Trans Corrid $0.00 $0.00 $28,132.76
337 2006 Equipment Certificate $0.00 $0.00 $2,560.27
338 2006 Interior St Improvements $0.00 $0.00 $44,104.64
341 2007 St Imprv-E Side/Jade/8 Av $0.00 $0.00 $47,754.64
342 2008 Equipment Certificates $0.00 $0.00 $5,075.27
343 20098 GO CIP Bonds $0.00 $18,282.50 $18,316.34
435 Northland HeighislTrans Corrid $0.00 $1,451.25 $188,740.87
441 2t)07 Street Impr (Jade Rd/E $0.00 $54.30 -$70,045.80
442 2008 Equipment Certificates $0.00 $0.00 $8,513.81
490 Capital Outlay $0.00 $287.49 $6,871.21
502 Sewer Extension $0.00 $28,995.49 $28,995.49
601 Water Fund $868,802.00 $38,408.19 $42,176.79
602 Sewer Fund $418,398.00 $13,312.27 $238,045.10
603 Refuse Collection $280,030.00 $25,311.98 $196,911.25
651 Storm Water Utility $38,625.00 $6,542.51 $40,420.46
10/06/09 3:12 PM
Page 1
$4,232,491.00 $355,872.20 $2,882,715.73
(I
CITY OF ST JOSEPH
Council Month End Revenue -Enterprise Funds
Current Period: September 2009
FUND 2009 September 2009
FUND Descr SOURCE Descr YTD Budget 2009 Amt YTD Amt
FUND 601 Water Fund
601 Water Fund Connection/Reconnection tees $150.00 $25.00 $225.00
601 Water Fund Transfers from Other Funds $479,000.00 $0.00 $0.00
601 Water Fund Contributed Revenue $0.00 $0.00 $0.00
601 Water Fund MDS Test Fee $9,000.00 $809.57 $5,866.11
601 Water Fund Water Line Charge $90,000.00 $8,264.23 $55,621.65
601 Water Fund Inspection Fees $9,000.00 $100.00 $100.00
601 Water Fund State Sales Tax $200.00 $346.32 $270.92
601 Water Fund Penalties and Forteited Disc $500.00 $764.54 $5,701.42
601 Water Fund Undesignated Funds $0.00 -$5,559.80 -$4,748.36
601 Water Fund Bulk Water $0.00 $32.00 $3,288.16
601 Water Fund Rate Class One $300,000.00 $35,935.17 $160,949.66
601 Water Fund Reimbursement $0.00 $0.00 $0.00
601 Water Fund Surplus Property $0.00 $0.00 $0.00
601 Water Fund Water Tower Antenna Lease $22,000.00 $2,177.05 $20,386.09
601 Water Fund Amortization of Bond Premium $0.00 $0.00 $0.00
601 Water Fund Interest Earnings $50,000.00 $2,606.17 $16,878.68
601 Water Fund Special Assessments $1,550.00 $0.00 -$2,139.20
601 Water Fund Water Meter $4,000.00 $0.00 $5,141.00
FUND 601 Water Fund $965,400.00 $45,500.25 $267,541.13
FUND 602 Sewer Fund
602 Sewer Fund Sanitary Sewer Service $206,795.00 $18,466.55 $97,081.06
602 Sewer Fund Special Assessments $555.00 $0.00 -$195.11
602 Sewer Fund Interest Earnings $35,000.00 $4,035.85 $18,325.60
602 Sewer Fund Surplus Property $0.00 $150.00 $150.00
602 Sewer Fund St. Benedict Sewer Charges $187,300.00 $0.00 -$21,054.84
602 Sewer Fund Penalties and Forfeited Disc $2,000.00 $538.95 $3,306.03
602 Sewer Fund Sewer Line Charge $50,000.00 $9,223.87 $62,655.74
602 Sewer Fund Sewer Inspection Fee $1,000.00 $100.00 $100.00
602 Sewer Fund Sewer Surcharge - (Monthly) $1,000.00 $0.00 $0.00
602 Sewer Fund Transfers from Other Funds $47,200.00 $0.00 $0.00
602 Sewer Fund Reimbursement $0.00 $0.00 $0.00
602 Sewer Fund Contributed Revenue $0.00 $0.00 $0.00
FUND 602 Sewer Fund $530,850.00 $32,515.22 $160,368.48
FUND 603 Refuse Collection
603 Refuse Collect Refuse Collection Charges $240,000.00 $19,450.57 $146,090.06
603 Refuse Collect Contributions from Private Sou $0.00 $0.00 $150.00
603 Refuse Coifed Interest Earnings $10,000.00 $1,482.26 $8,206.04
603 Refuse Collect Penalties and Forfeifted Disc $2,000.00 $451.29 $4,577.96
603 Refuse Collect Licenses & Permits $8,000.00 $65.00 $10,480.00
603 Refuse Collect State Sales Tax $17,000.00 -$923.27 -$990.81
603 Refuse Collect Special Assessments $1,600.00 $0.00 -$612.49
_
FUND 603 Refuse Collection $278,600.00 $20,525.85 ,
$167,900.76
FUND 651 Storm Water Utility
651 Storm Water Transfers from Other Funds $0.00 $0.00 $97.00
651 Storm Water Special Assessments $1,200.00 $0.00 -$689.51
651 Storm Water Interest Earnings $7,000.00 $1,620.89 $8,613.41
651 Storm Water Reimbursement $0.00 $0.00 $0.00
651 Storm Water Contributed Revenue $0.00 $0.00 $0.00
651 Storm Water Development Fee $20,000.00 $0.00 $0.00
651 Storm Water Rate Class One $80,000.00 $10,423.60 $63,704.11
651 Storm Water Penalties and Forteifted Disc $500.00 $232.64 $1,408.85
FUND 651 Storm Water Utility $108,700.00 $12,277.13 $73,133.86
10/06/09 3:14 PM
Page 1
ri ~~ h ~
~rn.'U/ ~Jl..~'"'v t~ ...
CITY OF ST JOSEPH
Council Month End Revenue -Enterprise Funds
Current Period: September 2009
FUND 2009 September 2009
FUND Descr SOURCE Descr YTD Budget 2009 Amt YTD Amt
$1,883,550.00 $110,818.45
$668,944.23
10/06/09 3:15 PM
Page 2
~l CITY OF ST JOSEPH
Council Month End Revenue -General Fund
Current Period: September 2009
2009 September 2009
FUND FUND Descr SOURCE Descr YTD Budget 2009 Amt YTD Amt
FUND 101 General
101 General Current Ad Valorem Taxes $1,179,551.00 $0.00 $543,942.84
101 General Special Levy- City St. Joe $0.00 $0.00 $0.00
101 General State Sales Tax $125.00 -$33.27 $438.88
101 General Gas Franchise $30,500.00 $0.00 $14,817.47
101 General Electric Franchise $50,000.00 $1,394.05 $25,087.56
101 General Beer $2,000.00 $0.00 $0.00
101 General Liquor $22,200.00 $0.00 $11,210.00
101 General Outdoor Liquor Permit $1,200.00 $0.00 $1,800.00
101 General Gambling Permits $200.00 $0.00 $110.00
101 General AmusemenUHunting Permit $1,500.00 $0.00 $0.00
101 General Contractors License $100.00 $0.00 $0.00
101 General Excavation Permit $500.00 $50.00 $200.00
101 General Cigarette License $500.00 $0.00 $0.00
101 General Cable Franchise Fee $21,700.00 $0.00 $12,229.67
101 General Building Permits $122,000.00 $40,680.07 $120,140.06
101 General Animal License $2,500.00 -$442.00 $3,150.00
101 General Rental Housing Registration $17,000.00 $6,860.00 $19,754.00
101 General Federal Grants -Other $2,000.00 $526.33 $4,603.58
101 General Local Government Aid $865,754.00 $0.00 $388,591.50
101 General Market Value Credit $0.00 $0.00 $0.00
101 General PERA Rate Increase Aid $1,541.00 $0.00 $770.50
101 General Police Training Reim $3,500.00 $0.00 $3,567.72
101 General State Municipal Funds Aid $6,200.00 $0.00 $6,180.00
101 General State Police Aid $35,000.00 $54,009.00 $54,009.00
101 General County Grants -Road Maintena $7,750.00 $0.00 $0.00
101 General Zoning and Subdivision Fee $1,250.00 $0.00 $1,170.00
101 General land Use Deposit Fee $4,000.00 $0.00 $3,798.80
101 General Sale of Maps and Publications $100.00 $5.00 $98.80
101 General Assessments Search $4,000.00 $300.00 $3,250.00
101 General Special Hearing $4,000.00 $600.00 $4,760.00
101 General Administration Reimb $15,000.00 $0.00 $16.00
101 General Weed Cutting $1,500.00 $300.00 $1,100.00
101 General Park Fees $5,000.00 $175.00 $4,600.00
101 General Summer Recreation Charges $0.00 $0.00 $0.00
101 General Kennel Fees $1,000.00 $563.00 $712.00
101 General County Fines $45,000.00 $1,897.50 $20,703.98
101 General Policy Fines $27,000.00 $2,925.00 $16,060.50
101 General Accident Report Fee $1,000.00 $45.00 $474.05
101 General Seized Property $1,500.00 $950.00 $3,123.10
101 General Special Assessments $1,500.00 $0.00 $1,705.75
101 General Interest Earnings $20,000.00 $3,206.04 $13,768.90
101 General Interest Charges $300.00 $27.19 -$494.94
101 General Co-op Dividend-MN League of C $10,000.00 $0.00 $0.00
101 General Water Tower Antenna Lease $1,100.00 $205.90 $2,834.95
101 General Land Rental $0.00 $0.00 $1,500.00
101 General Contributions from Private Sou $0.00 $500.00 $500.00
101 General Contribution -Health Ins Div $10,000.00 $0.00 -$15,000.00
101 General Contributions-Pule Christmas $0.00 $0.00 $3,000.00
101 General Contributions -Parks $600.00 $170.50 $847.28
101 General Surplus Properly $250.00 $0.00 $35.00
101 General Reimbursement $4,050.00 $0.00 $9,639.13
101 General Transfers from Other Funds $14,000.00 $0.00 $188,792.78
FUND 1 01 General $2,545,471.00 $114,914.31 $1,477,598.86
FUND 1 08 Cable Access Fee
108 Cable Access Fee Cable Franchise Fee $0.00 $0.00 $5,346.44
10/06/09 3:10 PM
Page 1
I't CITY OF ST JOSEPH
~n.~/ NJI..'J...
Council Month End Revenue -General Fund
Current Period: September 2009
FUND FUND Descr SOURCE Descr
FUND 150 Economic Development
150 Economic Development TIF/MIF Deposit
150 Economic Development Interest Earnings
150 Economic Development Transfers from Other Funds
FUND 150 Economic Development
2009 September
YTD Budget 2009 Amt
$0.00
$3,000.00
$42,010.00
$45,010.00
2009
YTD Amt
$0.00 $7,500.00
$105.57 $502.82
$0.00 $21,320.60
$105.57 $29,323.42
10/06/09 3:10 PM
Page 2
$2,590,481.00 $115,019.88 $1,512,268.72
~~/rl~~~~ ~ A CITY OF ST JOSEPH
~J V'~ Council Month End Revenue Summary
Current Period: September 2009
2009 September 2009
FUND FUND Descr YTD Budget 2009 Amt YTD Amt
101 General $2,545,471.00 $114,914.31 $1,477,598.86
105 Fire Fund $258,150.00 $35,295.82 $191,923.15
108 Cable Access Fee $0.00 $0.00 $5,346.44
150 Economic Development $45,010.00 $105.57 $29,323.42
155 TIF 1-3 Borgert (SKN) $0.00 $0.00 $0.00
156 TIF 1-4 St. Joe Development $0.00 $196.69 $33,980.71
157 TIF 2-1 Millstream $0.00 $0.08 $3,326.22
200 State Collected Sales Tax $0.00 $32,404.51 $144,583.76
205 Park Dedication $0.00 $261.65 $1,736.68
210 Recreation Center $0.00 $262.80 $1,471.32
215 Charitable Gambling $0.00 $24.34 $6,701.91
230 Lake Wobegon Trail $0.00 $5,000.00 $5,000.00
232 City Beautification-College Av $0.00 $0.00 $0.00
250 Revolving Loan Fund $0.00 $286.89 $1,606.23
318 2009A CrossoverRefunding Bonds $0.00 $5.25 $3,059,389.74
320 2007 Refunding (98/99 St Bond) $2,500.00 $2,192.01 $53,332.32
321 Joseph Street Improvement $0.00 $187.69 $1,387.61
322 City Hall Refunded, 2005 $110,000.00 $123.69 $50,737.02
323 20041mprovements/Northland $33,000.00 $522.18 $18,542.99
325 2002 Street Improvement $66,000.00 $3,728.62 $147,638.66
328 2003 Liberty Pointe Street Imp $0.00 $0.00 $591.81
329 2003 Maintenance Facility $66,000.00 $480,090.59 $510,500.41
331 2003 Refunding Fire Hall $77,120.00 $962.43 $59,558.95
332 2003 Cross Over (93 Streets) $14,000.00 $761.24 $23,696.44
333 2005 Improve (Hill/Clover) $15,000.00 $3,306.16 $52,425.82
335 Northland Heights/Trans Corrid $55,000.00 $6,998.48 $344,312.21
337 2006 Equipment Certificate $69,000.00 $188.56 $32,257.51
338 2006 Interior St Improvements $61,000.00 $4,478.36 $111,273.88
341 2007 St Imprv-E Side/JadelB Av $36,000.00 $5,590.18 $271,061.94
342 2008 Equipment Certificates $65,500.00 $167.68 $30,060.23
343 20096 GO CIP Bonds $0.00 $18,897.79 $18,897.79
390 Debt Service Relief $0.00 $639.20 $4,193.22
441 2007 Street Impr (Jade RdlE $0.00 $0.00 $0.00
490 Capital Outlay $0.00 $0.00 $0.00
501 Water Extension $0.00 $236,982.24 $281,917.37
502 Sewer Extension $0.00 $123,443.08 $161,101.08
601 Water Fund $965,400.00 $45,500.25 $267,541.13
602 Sewer Fund $530,850.00 $32,515.22 $160,368.48
603 Refuse Collection $278,600.00 $20,525.85 $167,900.76
651 Storm Water Utility $108,700.00 $12,277.13 $73,133.86
10/06/09 3:09 PM
Page 1
$5,402,301.00 $1,188,836.54 $7,804,419.93
City of St. Joseph, Minnesota
Cash Position
As of 9130!09
First State Bank Maturity Date Interest Current Balance # Securities % of Total
Checking Account (Reconciled) N/A 0.3°~ $ 251,282 N/A
Money Market Savings N/A 1.56% 1,471,732 N/A
Bank Certificates of Deposit Tiered 2-39 months 4.55°k avg 3,950,562 10
averages 18 months 4.27%
Total FSB $ 5,673,576 38°~
Central MN Federal Credit Union
Share Savings Account N/A 1.1 B°~ $ 10 N/A
Money Market Savings N/A 1.45°k 118,063 N/A
Power Money Market Checking N/A 2.30% 1,329,323 N/A
Jumbo Bank Certificates of Deposit Tiered 2-51 months 3.55% avg 2,755,603 5
averages 12 months 3.07%
Total CMFCU $ 4,202,998 28%
Total Deposits $ 9,876,574
Salomon Smith Barnev
Brokered Money Market Savings N/A 0.01% $ 126,501 N/A
Govemment Securities/Notes 108 months 3.00°k avg 124,370 1
Brokered Certificates of Deposit Tiered 12-62 months 4.59% avg 1,189,958 12
averages 42 months 4.15%
Total SSB $ 1,440,829 10%
Northland Securities
Brokered Money Market Savings N/A 0.00% $ 8,793 N/A
Brokered Certificates of Deposit Tiered 1-4 months 2.09°~ avg 678,510 4
averages 3 months 1.67%
Total NS $ 687,303 5%
Cash Held in Escrow (Cross-Over Bond Refunding) 0.54°~ $ 2,985,320 20%
Totallnvestments $ 5,113,452
Totai Deposits and Investments 3 14,990,027
Average Interest APY 3.29% (125,000) Investment purchased, not settled
14,865,027 Cash and Investment Balance
Petty Cash
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 FDIC/SPIC/NCUSIF or secured by pertected pledged col lateral.
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 tavorable and depending on cash flow needs to lock into a favorable rate.
Credit Risk: There are no instruments exposed to credN risk. Maturity
Concentration of Credit Risk: The City invests in various instruments and several financial institutions. # Securities Averages
Brokered Money Markets : 135,294 1X WA
(over 5% of investment portfolio) Brokered Certifkates of Depoaft S 1,565,465 12X 1.75 years
Govemment Bonds/Notes S 724,370 2X 9 years
State/Local Govemment Securities s 2,985,320 55X NIA
Foreign Currency Risk: The City only invests in USA and USA territories
LL O N (D n .•. Ob V ~(D 10
w N t0 ~ O~ n O o N
Q~ ~ ' ~
O
N9 to 69 d9 M IA f9 f9
O O M ~ n V n ~ N O c0 O n ~ ap < O
w~ N
~ rn rn N
r~ O
c, o0
u~ M
r; n
v_ O
n O
o O
cD ~
m
rn O a
~n O
r~ ~. M
~ N
.r
N
~ w rn O~
N n
M V
v ~ (O N ~ -O)
op
ap ~
~ n
ca O
m n.
m M
n
o
V ~ n N N Op
~ .- v n
Os
O /A 1A
r0 O O O O G O
~ r ~ O ~ 0
-
"7 ~.
~' Y7 a0 O
N ' 'O ~
~ O
D
O p n
p
N
N ~ n ~ ~ N O
'
N t
0 ,
m .
O!
"
O ~
.- .i
i
i v~ '~ aO 'rn N
~
p
~ f0~7 "''t0 M ~ N n '.n r d
U
W rn ;~ N' N ~ ~ ~ eLu
J rn ,.- oo
v
~
~
c
~ , a
O m
~ o
~ ~
~
Asa
vi
'w
vi ~
L V
C
C ~ O
C o~ ~ a ~ M o N o, .n r u7 ,
- o <c
~ p
N O
Z 1A N
o
oo
~D
O
~
O
n
'
O
~
'
~
`N
o
N
'
O
rn
~
~
V
O _
~
N
Y
P N
L
,~,,
Q. O yj ~
d M I~
M ~
~ 'm N -~
N r
~ aD
N .N
'a CO
M (p
~OJ O
Y N
W C
O
p
C O :.
l0 :
M ~ - N cp
,
d L M
LL N
C ~
~
N
N
O
~
N
p~
U Q ...
w
0 d ~O
~
b O
~
~
~
~ ,~
' N
~ l'O
~ D
~ tl7
N
m i :a0.
O
m u
7 _ -. <
:
~
n t
O,
U L 11a ~'
d N N M
~
M
~ ':n
N M
~ W N
U
o-
0
rsi
f0 ~
w O ~
) ~
n N
.tfl
[O cD
ca
O a0
,4>
-
at 0
o
n ,N
O.
t0 M '~
<v ail
O V
~n
N ~D
.o
n cp
c0
~0 M
iC M
o
- -c''i
:gyp
C n
M
O '.aO
-~G
? t0
N 10
N N O
a0 V'
V O f!
Z Oi ?CD
~ CO
~
~.O
M
N
M '
:~
~
m
~
;Q'
u~
V
u'i i
rtV
N
O
'7 ~
n
O) '
N
V
,n
M
N
n !?
;:V
n t1Y
f0 O
~ O O
p O~
tp ~~ ao ~ -{+7 0o n n ~~ n '.N e%~ ap0. rn OOirn
Q BOO ;'. ~ oo R
m
S
H
Q -
V
~ vi vi
N
x - - ~ c m
A
~
~
`
~ ~ ~
m
~
.~
-
C
~
N c
~ ~ ~ LL t L
Z ~ L C ~ ~- '~ .; LL LL LL ~
t "~ U
~ 'p .d, ~ U 'N O 'V. L
O ff. ~ y ~.q a .
~ E' O
O
~ ~ , ~ ' O C ~ ~ O
N
LL :'O a N o `
i ~ O
_ d
a ~ ,p
o m
L .a
' a . V L
` o d
~ o M
c
~ ~
L ~
LL ~
7 U D .~ A
~ ~ _
~ ~
LL « '¢ a i?
". . ;~ t
l
~ `
' d
d ~ d .
d
~ O LL
= ~ t6 d t ~ ~~ d ~~ W A
3 A d ' d ,~Oi
c7 w - m a ~ U J v ~ 4 v . u~ ~ rn ~ N
c
N
L
~_
X
W~
V
LL~
(T
V
Q
O
L~
^T^'
hW
M11/
Y
4~
~ U
m Q
C
T
C O
7 .~..
O C
U ~
a~
~_ o
i L ~
O ~
i Q
~+ 'O _
~ O C
Q m O
N ~ d
Q o ~ O
p ti N
w O :~' ~
U ~
..
,~ c
c ~
~ a
LL N
N ~~
O
LL
~ ~
C C
LL
~ O
~ O
C ~
41 ~
O O O O O O '
O O O O O O
O O O O O O
O ul O 1r1 O u'1
~--
d
.~
v
d
0
u~
cc
m
.~
m
0
d
.~
d
0
v ~
v v
a >
x v
w ~
^ ~
~`/_
•_
V
Q
^~
W
i
Q.
~+
W
0
0
0
0
0
m
0
0
0
0
N
O
O
O
O
0
N
O
O
O
O
.--i
0
0
0
0
0
0
0
0
0
v vii v v
>~ ,~ 3 a
> ~ to
E
L
0
Y
Y
Y
~
C (O
~ c
G
f
D
~ ~
++ ~
Y O ~
co ~ U
C
~ v v
a U
Y
U N
~
Y Ql
Y N
Y
L O ~ O O
U ~ o~ c0 m
v ^
0
00
1-
O
2
~^
A^
W
^~
`W
s
V
0
M
r-1
Ol
n
r-I
00
N
r-I
N
N
N
N
V
i-1
n
.-i
N
M
W
0
n
L!1
rv
n
00
.1
..
'O
7
L
Q1
O
L
3
N
OC
'O
7
Q1
O
00
O
O
3
~c o v m oo r-I ~ oo ~ o 0 0 '-I o o v o 0 0 0 0 0 o v o0 0 0 0 0
I~ lT m 00 lD 00 V m m O O O N O o Q1 0 0 0 0 0 0 0 Ql 00 01 0 0 0
OD N o0 m 0~ N Ol V N In O O r-I V O iD O O O O O M O ' lD O V O O O
C d
' ~ O1 I~ ul Ol N N r-I m N O O 111 .--I Il) 01 O 111 O O O N O V 00 V1 O 111 In
E u Ql ,--I l0 m m 1D 00 ID DD V V V u'f .-I I~ .~ o to .-i O O V O I~ O1 .-I O .--I o
C
A 10 00 tD I~ 111 111 V m V Vl N Ql l0 N Ql 00 O 111 V V ~"I O M N N
~
~
a m r-I l0 N N N N Ql 111 r-1 N V r-I lD N a O
~ m N a
1'
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o c c o
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o c o
d! pl 0
O 0 0 0 0
0 0 0 0 o
0 In o In o 0
N 0
N 0 0 0 0 0 0 0 0 0
O vl 0 0 0 0 0 0 0 0
v1 0
~ 0 0
O C 0
O
04 0
~ O O O O O O O N N O O
V N .--+ M O .--I vl h Il) O tD lD O O 111 V 1
In m C m
3 N O N N N .--I I~ m Ol t` m r-I V t\ m ri .--I N lD r-1 t11 N .--I ry 0 0
(d ri N m l0 N N
n ~
~
~
~ ~
m
V
O ~
~ ~ 0 O O
f
l'1 0
0 l
0 W l'1 I
i'1 O O
f N 1 0 0 O O 0
1
O Q O
0 i
0 O
m
C V N
tf W ll'1 O 01
01 P IA 01 N
N 01 01 N V1
1~ n 00 I~ O 8 lD
ri V ' t0 S7 C ' ' ' crI p ' l0
ci Ol `y' Vl N
~ O
P'f Ql
~D O O
O In O
In
~C Ol .~-1 l~ m m l0 Ol N m N m V 111 8
~-i lD V In Ql i~ O '-I M 00 In
C
'~ N pp N' O M .--1
fYl N I~
F n lD N 00 m ~ m
' ~ 00 .-i ~ O N .~-~
l t0 N OO 01 In In
E f0
m N [ N d ~ r e~-1 N
C
N
C
d
L
f0 ~ C
N ^
~
E _
'O
E ¢
7 ~
~ ~
~ C O
O 61 m Q1
G
£ ~ O
C C
1
r
N d
C
C
c °-
a ~ o n
In
v u m
~ `° v
t
a ~ v ~
v ra c
~ ~
O d
-
~ OJ
-
,
c ~ v
In
In v o a ~ -c
m
o
,~ E
O N N O a c
j d u
~ o v a ¢ ~
v o, a
E -oo
ro
.Q
u
N
O
00
m
n 001 M Ol l~0
N 00 m l0 O1
a m n oo rn
m .ti O ti m
Op N O I~ N
N m rl
N N
~ ~
c c 3 3
v v ~
E E ~ o
>
'n a
a x In
3 _
_
7 O
in
? Q Q Q! N
W W > 7
+~ v ~ a a
w ~
Y O O v° v
~V
10
LL
C
C Q
LL R
~ C C C N
~ o 0 0 'c
o 'c c c
C ~~ U
E LL W Q Q Q r
d
0
a
O O O r-1 N
O m I~ 00 W
A m In vl In In
Y
0 0 0 0
C V
V N N N N N
V V V V '7
a~+ .--I O O O O
~
H ~ V V V
n
I I ~ ~ I
M
a oo m o 0 0100
vl m m 0 0 0 N
W Q1 N V1 O O In
o m m ~ o o v
m .-I oo N oo v o0
Ol tD N W m V V
I-i V
l0 lD N
O O .-I
I m l l ~ l ~ l l l m~
In Il) O
00 m 1~
O O O O O O O O
ti ~ O~ nmi o O m
.-~ In o In rn o ~ r`
V Ol .--1 O1 O N N O1
~ e-i lD N l11
0n on
-o
~ c
N
m v v m
E
~ C
C
t0 ~ ~
c c ~ ~ ro c c c~ c Y c
v In v ~+ v c v v v~ v v
n
E
n a `~ a L
a
n .~ n
E v e ~ .`_'
~
a
~
~~ ~~ ~ ~~ o v ~~
o v E
Q ~ O"
j
W W v
~ ~ O' In Q ~ Q ~ 6 ~ ~ ~
W W W
W
W
W
p
Q C
~
]
m
O
O
C N O v O C
L ~ L Q v O N to N N GJ ~ N
O N
Q "O L ~ L L L •= L d ~ L
O
u 0~ 0~ vl ~~ O o 0 0 0 m 0~~ 0
C
O
f0 N Q1 '^ N N 41 N fo ~
N
V ~ ~ u
c ' _
C C C C p Y
O
j
~ ° °
E E E v ro to ro ro Y
C C C C ~ ~ ~ ~
v v v v
3
°° vl c
c c~ c
c
E
a
~ ~ ~ ~ c
a a
'
'
~ !'
~
o
u Q Q ~ ~
,0
~ ,~ o v
o o ~
~~~~
A N
L
~ ~
a
o I
iI
In V
m a
v v v v v `
V U U V V ~ Iq N ~ ~ ~ OZ{ ~ ~ ,C C LL Y Y
to la f0
O O O O O E O
LL a o
o to to to
~
" in 1%1 ~ ~ m LL d
/
i
v
V 0
F
_ a
_ w r 1
1
n
l
O O O O .--I O O O O N O 0 0 0 0 0 0 0
00 0o In oo m oo m In m o0 00 0o m N ao m In m
In In In vl vl vl
O N N N N O vl vl In In In vl vl vl In In vl vl
0 0 0 0 l11 O O N N M N N
N V7 In V"J to O N N N N N N lD O O N O O
N N N r-1 N l!1 N '-i r-1 N .--1 N r7 N N N N N
N N N N N N
v v v v v v m M m m m M m lif lA 111 Vl l11
v v v v a a v a v v v v
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Ol Ol Ol Ql 01 01 Ql Q1 Ol Ol Ol Ql Q1 Ol Ql Ol Ol Ql
v v v a v v v v v v v v a v v a a a
I i l l l
O O
O O
O O
m m
v
3
a° ~
p1 OD
7 ~
a a
E Q
u° ~W
W O
C Q Q ~
~ ~ ~ ~
o,
~o
a
N OQ
O ~ ~
U ~ b
e a a
1~ o N