HomeMy WebLinkAbout[04c] Financial Report
Council Agenda Item 4c
MEETING DATE: October 24, 2017
AGENDA ITEM: Financial Report – 3rd Quarter 2017 & September 2017 Financial
Reports
SUBMITTED BY: Finance
BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N/A
PREVIOUS COUNCIL ACTION: Council adopted the 2017 budget on December 5, 2016.
BACKGROUND INFORMATION: Quarterly and monthly reconciled cash/investment and budget to
actual position are provided for Council review. The numbers presented are the cash balances as of
September 30, 2017.
CASH POSITION:
- The market rate of return (ROR) is approximately 1.125% with an average maturity of 16
months. The federal markets improved significantly in 2017. St. Joseph’s rate of return is slightly
less than the treasury markets. The City tiers the maturity dates within the boundaries of the
Investment Policy. The tiered maturity dates has helped the City maintain a higher rate of return
than the current market over time.
- In March and September the Federal Open Market Committee \[FOMC\] increased the federal fund
rates to 1.0 to 1.25% citing improving economic activity. The economic outlook has excited
investors. The FOMC stated the outlook is positive and they predict a third rate increase in 2017.
- Interest earnings for 2017 amounts to $53,272. The City’s policy is to hold investments until
maturity. GASB 30 requires the City to mark investments at the current market value as of the
close of each month. In doing so, earnings will show fluctuations.
- Overall, the cash and investments balance decreased $553,784 from the beginning of the year.
Bond proceeds for the government center and Field Street are significantly spent down. CBD
Alleys and water plant 1 improvements bond proceeds will be mainly spent in 2017. The first
half tax settlement and LGA were received this summer, the remaining taxes and LGA will be
received in December.
FUNDS REPORT:
- The General fund spent 67% of the 2017 expenditure budget and received 62% of the revenue
budget. Expenditures and revenues are mainly operational in nature. One area under budget is the
ice and snow removal. The winter time during the 2017 report year has been mild. Planning and
zoning shows over budget. The comp plan update was funded with excess building permit
revenues carried over from 2016. The budget will show over-spent as a result. City offices is
over budget due to unanticipated expenses for janitorial services. These services require 8-12
hours per week in the government center versus a couple hours a week the City contracted for in
the old city hall. There are also costs in staff time for moving and settling into the new facility
coded under city offices. The building permit revenue is $169,000 over budget in 2017.
- The Enterprise Funds represent 6.5 months utility billing revenue collected while expenses
represent nine months of activity. Water revenue is showing higher than expenses as expected.
Rates were increased to cover debt payment in May and Nov. The St. Cloud sewer debts are paid
monthly. There are also St. Cloud charges for the design costs of their NR2 Biosolids project.
Overall, 39% of expenses have been incurred (less depreciation); 48% of the revenue budget has
been received (less bond proceeds).
Water fund analysis (fund 601/501) – The enclosed spreadsheet shows an analysis of the water fund,
including the Water fund (601) and the Water Access fund (WAC-501). The WAC and trunk fees
received for the year total $378,490, including fees collected for 12 single family homes, O’Reilly’s auto
parts store, CSB athletic fields, Kwik Trip 2, Bed & Breakfast, Fortitude Senior Housing, Country Manor
and a connection fee from a homeowner that was sewer only (final partial payment). Water revenues
represent 20%, expenses 564% of the budget at the end of September.
Sewer fund analysis (fund 602/502) – The enclosed spreadsheet shows an analysis of the sewer fund,
including the Sewer fund (602) and the Sewer Access fund (SAC-502). Sewer SAC/Trunk fees totaled
$116,975. Sewer connections include 12 single family homes, O’Reilly’s, CSB athletic fields, CSB
administrative/art buildings, Bed & Breakfast, Country Manor and Kwik Trip 2. Sewer expenses are at
44% of the budget, while revenues are at 57% of the budget.
½ ¢ Sales Tax (fund 200): The sales tax fund has a balance of $1,069,488. The City anticipates
collecting $4,000,000 in sales tax revenue through 2018 ($3,372,754 original estimate); $3,611,150 was
collected to date. Collections have continually increased over the years, even during most of the
recession years. The anticipated remaining expenditures total $766,215 for the projects approved by
Council.
CIP REPORTS:
- General capital equipment purchases include: AED defibulators, squad 701 replacement, squad
laptops, Centennial Park fencing, fire hall parking lot, turnout gear and pagers. The comp plan
update is near completion.
- The Park Board completed phase 1 and part of phase 2 of the dog park project. The Millstream
park shelter will complete construction in October. Beginning discussions on the East Park canoe
access are beginning. The City received notification the Initiative Foundation is granting the City
$2,500 towards the design and community involvement costs.
- The government center construction wrapped up, Field Street is open (final wear course will be
applied in 2018), the CBD Alleys are open (final wear course in 2018), Wobegon Trail extension
to Waite Park began (St. Joseph contributed $200,000). Right of Way acquisitions are being
negotiated to begin the CR2 phase II/III trail project. Water Treatment Plant 1 improvements will
begin in November/December; bidding is in process. The SCADA communication system
between water and sewer locations is in process. Finally, Stearns County substantially completed
the Minnesota Street East resurfacing project. The City’s portion of the costs is included in the
checks for Council approval. Finally, the Jacob Wetterling Rec Center completed initial concept
plans. The community center group is fundraising to begin phase 1 design and construction.
Donations have been slow. The fundraising group is working on plans to revamp their efforts.
- The EDA has been working with interested parties and the State to fund the Parkway Industrial
Park expansion. The EDA recommended amendments to the TIF agreement for Bayou Blues to
th
help construction get on the way. Council action is included in the Oct. 24 agenda.
BUDGET/FISCAL IMPACT: Information Only
ATTACHMENTS: Request for Council Action – Quarterly and December Financial Reports
3rd Quarter Reports:
Cash Position as of 9/30/17
Cash and Investment Holdings Chart
Cash Balances by Fund/Remaining Budget
General & Fire Budget to Actual Expenditures & Revenues
Enterprise Funds Activity Graph
Quarterly Water Fund Analysis
Half Cent Sales Tax Fund Summary
September Treasurer’s Reports:
Cash and Investment – Council Report
Council Month End Revenue Summary
Council Month End Revenue – General Fund
Council Month End Revenue – Enterprise Funds
Council Month End Expenditure Summary
Council Month End Expenditure – General Fund
Council Month End Expenses - Enterprise Funds
Capital Improvement Summary Reports:
General Fund Capital Improvement Plan - Summary
General Fund Capital Improvement Plan - Fire
General Fund Capital Improvement Plan - EDA
Enterprise Capital Improvement Plan – Public Works
Capital Improvement Budget Summary – Park Board
REQUESTED COUNCIL ACTION: Accept the financial reports as presented.
avg
Total Sentry Bank
avg
Total CMCU
Total Deposits4,534,742$
avg
avg
Total MS
Total Investments3,705,167$
ağƩƉĻƷ
{ğǝźƓŭƭ
{ĻĭǒƩźƷźĻƭ
aƚƓĻǤ/5ƭ/5ƭ
ağƩƉĻƷ
/5ƭ
/ŷĻĭƉźƓŭaƚƓĻǤ.ğƓƉ.ƩƚƉĻƩĻķDƚǝĻƩƓƒĻƓƷ.ƩƚƉĻƩĻķ.ƩƚƉĻƩĻķ
ЎЉі
Ͳ
ЍͲЉБЏͲАЊЌ
Љі
Ͳ
IƚƌķźƓŭƭ
ЋЌͲЋЊЌ
Ўі
Ͳ
ЍЋЍͲБЊЏ
LƓǝĻƭƷƒĻƓƷ
ğƓķ
Љі
Ͳ
/ğƭŷ
ЋЏͲББА
Ѝі
Ͳ
ЍЊі
Ͳ
ЋВБͲЌЋЏ
ЌͲЌАВͲВЎЍ
BudgetActual
Budget
BudgetActual
ExpExpRevRevRev
$210,294
$323,020
Fund
$218,751
Revenues
&
$367,020
Expenditures
Actual
to
$1,717,952
Budget
FundFire
$2,749,455
Fire
&
General
$1,860,634
General
$2,794,765
$$
000
,
000
,
$500,000
$3,000,000$2,500,000$2000000$2$1,500,000$1,000,000
9ǣƦĻƓƭĻwĻǝĻƓǒĻ
υВЌЊͲВЍЊ
υЊͲЉЉЉͲЉЉЉυͲͲ
υВЉЉͲЉЉЉυͲ
υАЌЌͲЎЋЏ
υБЉЉͲЉЉЉυͲ
υЏЏЋͲБАБ
υАЉЉͲЉЉЉυͲ
Activity
υЏЉЉͲЉЉЉυͲ
Funds
υЎЉЉͲЉЉЉυͲ
υЌЌЏͲЍЍЏ
υЍЉЉͲЉЉЉυͲ
Enterprise
υЌЉЉͲЉЉЉυͲ
υЊВБͲВЍЎ
υЊЏБͲВЏЏ
υЋЉЉͲЉЉЉυͲ
ВЏЎ
Ͳ
υЍЋͲЍЎЍ
υЌЏВЏЎυЌЏ
υЎЍͲЉЋЉ
υЍЍͲЏЎЋ
υЊЉЉͲЉЉЉυͲ
υυ
er
t
a
Light
Sewer
WaterWtW
Refuse
Street
Storm
2017 Revenue Budget (excludes bond proceeds)1,699,845.00 (includes fund 501)
2017 Expense Budget(1,699,345.00) (excludes depreciation, includes 501)
plus bond proceeds - WTP1 Project353,000.00
The balances represent the cash balance as of 9/30/17
2017 Revenue Budget1,494,805.00 (includes fund 501)
2017 Expense Budget(1,494,305.00) (excludes depreciation,includes fund 5
The balances represent the cash balance as of 9/30/17.
$500,000 MSAS advanced$40,000 Lion's donation$4M donations estimated
(2,000,000.00)
Less: Bonded ProjectsCommitted - to be funded
As of September 30, 2017
Totals
Maximum Funding Available
Sales Tax Funding
uncommitted annually (5 yr Average)
Projects that have been discussed for
Anticipated 2017 September Balance including funding commitments
anticipated remaining 2017 sales tax revenues to collect165,000.00Committed - to be funded
MTDMTDCurrent
FUND DescrAccountBegin YrDebitCreditBalance
Last Dim 10100
GeneralG 101-10100$1,766,671.46$99,557.89$193,982.93$1,536,021.75
Employee Retirement ReserveG 102-10100$99,763.34$0.00$0.00$115,843.34
Fire FundG 105-10100$563,122.18$768.20$73,830.90$527,332.94
Cable Access FeeG 108-10100$25,893.55$958.46$0.00$31,773.79
Economic DevelopmentG 150-10100$123,620.69$1,579.41$3,199.42$126,866.87
TIF 3-1 CMCUG 152-10100$154.37$3.33$0.00$642.80
TIF 4-1 Fortitude Senior AptsG 153-10100$1.38$0.94$0.00$2,281.29
TIF 2-1 MillstreamG 157-10100$20,737.15$15.68$0.00$21,364.61
TIF 2-2 Meat MarketG 158-10100$316.33$0.80$0.00$375.00
TIF 2-3 Bayou Blues/Alley FlatG 159-10100$30.97$0.00$0.00-$2,124.39
State Collected Sales TaxG 200-10100$1,481,459.54$45,681.83$62,273.56$1,069,487.95
Park DedicationG 205-10100$120,162.18$332.98$14,462.00$107,584.67
Charitable GamblingG 215-10100$2,067.07$1.28$0.00$2,085.71
Lodging TaxG 220-10100$7,675.51$1,317.20$0.00$13,657.32
DEED CDAP GrantG 225-10100$0.00$6.86$0.00$11,140.81
Revolving Loan FundG 250-10100$25,212.38$661.50$0.00$38,587.21
2016 CIP Bonds \[govt center\]G 301-10100$56,584.50$0.00$61.57$128,749.32
2017A CIP Bonds \[Gov Center\]G 303-10100$0.00$1.26$575.00$5,501.26
2016 Street Impr \[Field St\]G 304-10100$1,376.01$356.51$0.00$952.55
2017B Impr Bonds \[CBD AlleysG 305-10100$0.00$65.95$1,372.00$34,628.17
2009A CrossoverRefunding BonG 318-10100$159,645.38$147.69$0.00$249,267.94
2011A Refunding Fire HallG 331-10100$22,252.66$26.03$76,245.00-$30,413.34
2010B Refundin \[Hill/Clover\]G 333-10100$157,765.71$116.30$0.00$191,926.72
2011A CO Refund\[Interior St\]G 338-10100$116,941.10$97.66$137,115.00$27,443.80
2009B GO CIP BondsG 343-10100$5,746.75$20.63$0.00$36,838.44
2010B Street Impr \[16th Ave\]G 345-10100$195,202.21$123.53$0.00$201,894.85
2011A Pumper Truck CertificatG 346-10100$3,525.84$9.22$42,180.00-$24,858.89
2011A GO CIP Bonds\[roof/gar\]G 347-10100$59.72$6.84$21,060.00-$8,632.39
2013 Street Improve BondsG 348-10100$130,929.47$968.69$0.00$139,444.77
2013 Equipment CertificatesG 349-10100$7,430.98$20.26$0.00$35,831.40
2014 Street Impr \[ParkTerraceG 350-10100$182,088.00$236.84$0.00$220,646.70
2015 Street\[Clinton/Northland\]G 351-10100$31,684.84$127.03$0.00$106,804.00
2015 Equipment CertificatesG 352-10100$1,243.62$33.52$0.00$60,387.28
2015 Abatement Bonds\[KenneG 353-10100$12,168.01$60.09$0.00$152,265.04
Debt Service ReliefG 390-10100$220,080.03$0.00$0.00$224,809.27
2016 Government CenterG 401-10100$663,617.86$500.00$1,947.23-$5,068.58
Community Center phase IG 402-10100$0.00$0.64$0.00$1,038.80
2016 Imp Field StG 404-10100$1,292,725.42$0.00$18,313.16$235,337.59
2017 CBD Alley Improve ph 1G 405-10100$0.00$0.00$188,956.77$96,036.82
2014 Imp Park TerraceG 450-10100$174,269.28$0.00$356.48$173,912.80
2015 Street\[Clinton/Northland\]G 451-10100$208,291.12$0.00$0.00$109,076.88
2015 Equipment CertificatesG 452-10100$9,075.06$0.00$0.00$0.00
Capital OutlayG 490-10100$263,036.29$335.00$8,744.14$303,858.34
WAC FundG 501-10100$51,304.65$15,140.89$0.00$420,131.12
SAC FundG 502-10100$11,182.25$6,925.94$0.00$91,959.09
Water FundG 601-10100$60,868.49$82,452.63$48,321.22$778,952.79
Sewer FundG 602-10100$5,777.56$61,316.34$42,307.89$133,484.55
Refuse CollectionG 603-10100$247,661.61$15,961.00$24,951.54$249,258.26
Storm Water UtilityG 651-10100$241,498.11$6,197.06$3,134.19$271,806.10
Street Light UtilityG 652-10100$22,772.31$3,036.87$4,449.89$23,715.93
2017September2017
FUNDFUND DescrYTD Budget2017 AmtYTD Amt
101General$2,680,270.00$92,979.68$1,696,665.47
102Employee Retirement Reserve$0.00$0.00$16,080.00
105Fire Fund$323,020.00$705.89$210,293.61
108Cable Access Fee$6,700.00$958.46$5,206.64
150Economic Development$95,320.00$1,579.41$44,375.78
152TIF 3-1 CMCU$0.00$3.33$21,317.57
153TIF 4-1 Fortitude Senior Apts$0.00$0.94$1.79
157TIF 2-1 Millstream$275.00$15.68$18,311.81
158TIF 2-2 Meat Market$5.00$0.80$4,187.78
159TIF 2-3 Bayou Blues/Alley Flat$0.00$0.00$44.36
200State Collected Sales Tax$408,000.00$45,681.83$226,296.92
205Park Dedication$583,520.00$332.98$15,318.65
215Charitable Gambling$4,540.00$1.28$14.09
220Lodging Tax$0.00$1,317.20$5,603.28
225DEED CDAP Grant$0.00$6.86$11,140.81
250Revolving Loan Fund$10,500.00$661.50$4,725.58
3012016 CIP Bonds \[govt center\]$230,955.00-$61.57$118,933.19
3032017A CIP Bonds \[Gov Center\]$0.00$1.26$11,254.26
3042016 Street Impr \[Field St\]$63,585.00$356.51$8,022.48
3052017B Impr Bonds \[CBD Alleys\]$0.00$65.95$38,549.64
3182009A CrossoverRefunding Bonds$199,480.00$147.69$93,799.01
3312011A Refunding Fire Hall$56,700.00$26.03$24,163.73
3332010B Refundin \[Hill/Clover\]$65,560.00$116.30$39,622.73
3382011A CO Refund\[Interior St\]$124,670.00$97.66$52,180.07
3432009B GO CIP Bonds$65,000.00$20.63$33,344.21
3452010B Street Impr \[16th Ave\]$42,285.00$123.53$12,356.98
3462011A Pumper Truck Certificate$45,365.00$9.22$15,896.59
3472011A GO CIP Bonds\[roof/gar\]$26,000.00$6.84$13,232.55
3482013 Street Improve Bonds$21,460.00$968.69$12,488.84
3492013 Equipment Certificates$57,075.00$20.26$29,257.35
3502014 Street Impr \[ParkTerrace\]$108,230.00$236.84$63,115.44
3512015 Street\[Clinton/Northland\]$61,305.00$127.03$79,716.71
3522015 Equipment Certificates$32,005.00$33.52$59,452.56
3532015 Abatement Bonds\[Kennedy\]$162,300.00$60.09$162,217.44
390Debt Service Relief$0.00$0.00$4,702.16
4012016 Government Center$0.00$500.00$340,832.98
402Community Center phase I$0.00$0.64$1,213.80
4042016 Imp Field St$0.00$0.00$0.00
4052017 CBD Alley Improve ph 1$0.00$0.00$335,855.00
4502014 Imp Park Terrace$0.00$0.00$0.00
4512015 Street\[Clinton/Northland\]$0.00$0.00$0.00
2017September2017
FUNDFUND DescrSOURCE DescrYTD Budget2017 AmtYTD Amt
FUND 101 General
101GeneralCurrent Ad Valorem Taxes$1,060,000.00$0.00$508,557.83
101GeneralSpecial Levy- City St. Joe$0.00$0.00$8.39
101GeneralState Sales Tax$0.00$32.57$56.77
101GeneralGas Franchise$30,500.00$0.00$15,424.20
101GeneralElectric Franchise$55,800.00$2,015.92$32,836.30
101GeneralLicenses & Permits$0.00$2,400.00$6,900.00
101GeneralBeer$1,625.00$0.00$1,668.33
101GeneralLiquor$21,860.00$0.00$24,372.28
101GeneralOutdoor Liquor Permit$2,500.00$0.00$1,882.00
101GeneralGambling Permits$250.00$0.00$390.00
101GeneralAmusement/Hunt/Peddler/Golf$1,300.00$210.00$990.00
101GeneralExcavation Permit$500.00$50.00$350.00
101GeneralCigarette License$600.00$0.00$62.50
101GeneralCable Franchise Fee$33,300.00$1,319.16$19,153.15
101GeneralBuilding Permits$99,000.00$9,409.14$267,516.71
101GeneralAnimal License$3,400.00$60.00$2,785.00
101GeneralRental Housing Registration$26,000.00$0.00$28,653.28
101GeneralFederal Grants - Other$60,800.00$0.00$3,750.61
101GeneralState Grants and Aids$950.00$0.00$0.00
101GeneralLocal Government Aid$919,430.00$0.00$459,707.50
101GeneralPERA Rate Increase Aid$1,540.00$0.00$770.50
101GeneralPolice Training Reim$3,500.00$0.00$3,179.27
101GeneralState Municipal Funds Aid$50,000.00$0.00$49,961.00
101GeneralState Police Aid$60,000.00$68,577.92$68,577.92
101GeneralOther Grants/Aids$0.00$0.00$0.00
101GeneralOther Governmental Unit$10,000.00$0.00$10,000.00
101GeneralCounty Grants - Road Maint.$4,500.00$0.00$0.00
101GeneralZoning and Subdivision Fee$5,000.00$800.00$2,900.00
101GeneralLand Use Deposit Fee$4,000.00-$5,000.00$46,000.00
101GeneralSale of Maps and Publications$50.00$0.25$5.75
101GeneralAssessments Search$2,750.00$420.00$3,880.00
101GeneralSpecial Hearing$5,000.00$1,200.00$5,399.16
101GeneralAdministration Reimb$12,635.00$0.00$43.48
101GeneralWeed Cutting$500.00$100.00$500.00
101GeneralAdmission Fee$0.00$0.00$0.00
101GeneralShelter/Room Rental Fees$8,200.00$0.00$4,689.30
101GeneralBall Field Donation$250.00$0.00$23.09
101GeneralSchneider Field Rental$1,500.00$0.00$1,570.00
101GeneralRents and Royalties$53,450.00$4,324.42$38,919.78
101GeneralKennel Fees$700.00$52.00$144.00
FUND2017September2017
FUNDDescrSOURCE DescrYTD Budget2017 AmtYTD Amt
FUND 601 Water Fund
601Water FundWater Meter$5,000.00$1,450.00$22,535.00
601Water FundCurrent Ad Valorem Taxes$23,500.00$0.00$11,735.49
601Water FundBond Premium Proceeds$0.00$0.00$0.00
601Water FundGeneral Oblig. Bond Proceeds$0.00$0.00$353,000.00
601Water FundTransfers from Other Funds$290,990.00$0.00$0.00
601Water FundContributed Revenue$0.00$0.00$0.00
601Water FundWater Line Charge$294,600.00$18,153.37$159,149.56
601Water FundPenalties and Forfeited Disc$8,000.00$86.24$6,665.63
601Water FundConnection/Reconnection fees$200.00$0.00$0.00
601Water FundUndesignated Funds$0.00-$7,842.48$2,777.65
601Water FundInterest Earnings$31,500.00$312.16$1,994.63
601Water FundState Sales Tax$0.00$410.04$732.80
601Water FundMDS Test Fee$12,085.00$658.84$6,336.44
601Water FundSpecial Assessments$400.00$0.00-$604.53
601Water FundBulk Water$2,500.00$49.25$567.70
601Water FundAmortization of Bond Premium$0.00$0.00$0.00
601Water FundWater Tower Antenna Lease$34,480.00$2,873.25$24,355.25
601Water FundSurplus Property$0.00$0.00$0.00
601Water FundReimbursement$0.00$0.00$0.00
601Water FundRate Class One$705,100.00$56,299.70$342,695.61
FUND 601 Water Fund$1,408,355.00$72,450.37$931,941.23
FUND 602 Sewer Fund
602Sewer FundReimbursement$0.00$0.00$15,018.49
602Sewer FundContributed Revenue$0.00$0.00$0.00
602Sewer FundOther Governmental Unit$1,500.00$0.00$0.00
602Sewer FundSpecial Assessments$300.00$0.00$0.00
602Sewer FundInterest Earnings$500.00$943.02$11,796.41
602Sewer FundAmortization of Bond Premium$0.00$0.00$0.00
602Sewer FundContributions - General$0.00$87.75$430.70
602Sewer FundOther Grants/Aids$0.00$0.00$0.00
602Sewer FundSanitary Sewer Service$799,645.00$34,049.50$427,825.49
602Sewer FundPenalties and Forfeited Disc$7,075.00$218.75$6,181.42
602Sewer FundSewer Line Charge$493,105.00$25,953.77$272,273.28
602Sewer FundTransfers from Other Funds$96,090.00$0.00$0.00
602Sewer FundSurplus Property$0.00$0.00$0.00
FUND 602 Sewer Fund$1,398,215.00$61,252.79$733,525.79
FUND 603 Refuse Collection
603Refuse CollectPenalties and Forfeifted Disc$5,700.00$150.13$4,007.33
603Refuse CollectReimbursement$2,515.00$0.00$2,097.00
603Refuse CollectContributions - General$0.00$0.00$0.00
603Refuse CollectSpecial Assessments$400.00$0.00$0.00
603Refuse CollectContributed Revenue$0.00$0.00$0.00
603Refuse CollectRefuse Collection Charges$263,205.00$13,899.93$145,897.30
603Refuse CollectLicenses & Permits$18,350.00$355.00$18,560.00
603Refuse CollectState Sales Tax$0.00-$1,436.14-$3,405.27
603Refuse CollectInterest Earnings$4,000.00$156.93$1,810.08
FUND 603 Refuse Collection$294,170.00$13,125.85$168,966.44
FUND 651 Storm Water Utility
2017September2017
DescriptionYTD Budget2017 Amt YTD Amt
General$2,792,755.00$187,927.47$1,860,634.24
Employee Retirement Reserve$0.00$0.00$0.00
Fire Fund$367,020.00$73,768.59$195,494.97
Cable Access Fee$2,010.00$0.00$0.00
Economic Development$95,320.00$3,199.42$39,239.57
TIF 3-1 CMCU$795.00$0.00$20,829.14
TIF 4-1 Fortitude Senior Apts$0.00$0.00$0.00
TIF 2-1 Millstream$34,545.00$0.00$17,788.94
TIF 2-2 Meat Market$4,545.00$0.00$4,130.01
TIF 2-3 Bayou Blues/Alley Flat$795.00$0.00$1,499.72
State Collected Sales Tax$1,187,050.00$62,273.56$726,397.64
Park Dedication$653,350.00$14,462.00$28,034.99
Charitable Gambling$4,500.00$0.00$0.00
Lodging Tax$0.00$0.00$0.00
DEED CDAP Grant$0.00$0.00$0.00
Revolving Loan Fund$0.00$0.00$0.00
2016 CIP Bonds \[govt center\]$271,945.00$0.00$48,371.25
2017A CIP Bonds \[Gov Center\]$0.00$575.00$5,753.00
2016 Street Impr \[Field St\]$28,855.00$0.00$8,617.78
2017B Impr Bonds \[CBD Alleys\]$0.00$1,372.00$3,921.47
2009A CrossoverRefunding Bon$360,350.00$0.00$5,075.00
2011A Refunding Fire Hall$76,700.00$76,245.00$76,995.00
2010B Refundin \[Hill/Clover\]$142,050.00$0.00$5,923.75
2011A CO Refund\[Interior St\]$144,830.00$137,115.00$144,230.00
2009B GO CIP Bonds$64,800.00$0.00$2,595.00
2010B Street Impr \[16th Ave\]$63,855.00$0.00$6,827.50
2011A Pumper Truck Certificate$44,560.00$42,180.00$44,360.00
2011A GO CIP Bonds\[roof/gar\]$22,320.00$21,060.00$22,120.00
2013 Street Improve Bonds$43,670.00$0.00$4,235.00
2013 Equipment Certificates$57,500.00$0.00$1,150.00
2014 Street Impr \[ParkTerrace\]$161,835.00$0.00$25,817.50
2015 Street\[Clinton/Northland\]$66,810.00$0.00$5,805.00
2015 Equipment Certificates$32,310.00$0.00$1,055.00
2015 Abatement Bonds\[Kenned$154,835.00$0.00$22,167.49
Debt Service Relief$141,000.00$0.00$0.00
2016 Government Center$0.00$1,947.23$814,139.20
Community Center phase I$0.00$0.00$175.00
2016 Imp Field St$0.00$18,313.16$998,151.30
2017 CBD Alley Improve ph 1$0.00$188,956.77$239,818.18
2014 Imp Park Terrace$0.00$356.48$356.48
2015 Street\[Clinton/Northland\]$0.00$0.00$20,870.30
2017September2017
DescriptionDEPART DescrYTD Budget2017 Amt YTD Amt
FUND 101 General
GeneralCouncil$64,010.00$1,808.12$39,138.20
GeneralLegislative Committees$7,485.00$7.32$1,302.32
GeneralOrdinance & Proceedings$2,400.00$0.00-$5,838.17
GeneralMayor$11,930.00$862.79$5,933.69
GeneralElections$750.00$0.00$1,291.19
GeneralGeneral Adminstration$249,295.00$18,004.71$182,218.04
GeneralFinance$130,230.00$11,318.36$86,636.20
GeneralAudit Service$28,000.00$0.00$27,450.00
GeneralAssessing$23,500.00$0.00$0.00
GeneralCity Attorney$18,000.00$595.00$2,202.92
GeneralPlanning and Zoning$71,925.00$6,546.29$107,569.68
GeneralGeneral Government$21,850.00$3,447.65$28,783.77
GeneralCity Offices$22,600.00$2,356.26$33,753.10
GeneralCable Access$10,950.00$448.77$5,013.43
GeneralCrime Control & Investigation$1,063,225.00$83,327.57$699,860.84
GeneralPolice Training$9,545.00$75.00$3,396.33
GeneralCommunication Service$12,390.00$868.79$8,257.89
GeneralAutomotive Services$54,050.00$3,918.82$23,346.03
GeneralBuilding Inspec. Admistration$94,000.00$7,500.00$62,121.75
GeneralEmergency Management$995.00$7.82$842.73
GeneralAnimal Control$815.00$0.00$275.50
GeneralStreet Maintanence$309,240.00$21,585.00$160,265.68
GeneralIce & Snow Removal$113,465.00$0.00$29,612.62
GeneralEngineering Fee$35,000.00$3,033.64$12,612.86
GeneralStreet Cleaning$13,800.00$241.08$8,463.41
GeneralSkate Park and Ice Rink$5,590.00$157.05$2,589.24
GeneralBall Park$1,750.00$206.41$620.21
GeneralMaintenance Shop$21,315.00$1,338.39$14,677.24
GeneralPark Areas$224,015.00$19,522.75$178,940.57
GeneralCommunity Center$68,115.00$749.88$33,401.67
GeneralOther Financing Uses$0.00$0.00$13,000.00
GeneralFire Protection$102,520.00$0.00$92,895.30
FUND 101 General$2,792,755.00$187,927.47$1,860,634.24
FUND 102 Employee Retirement Reserve
Employee Retirement ReservGeneral Adminstration$0.00$0.00$0.00
FUND 102 Employee Retirement Reserve$0.00$0.00$0.00
FUND 108 Cable Access Fee
Cable Access FeeCable Access$2,010.00$0.00$0.00
FUND 108 Cable Access Fee$2,010.00$0.00$0.00
2017September2017
DescriptionDEPART DescrYTD Budget2017 Amt YTD Amt
FUND 601 Water Fund
Water FundBond Payment (P & I)$618,775.00$1,428.00$59,940.78
Water FundOther Financing Uses$36,770.00$0.00$770.00
Water FundPower and Pumping$18,690.00$745.29$4,243.66
Water FundPurification-Plant 1$348,985.00$1,913.61$18,243.21
Water FundPurification-Plant 2$86,210.00$5,489.99$53,723.38
Water FundDistribution$10,000.00$4,504.62$23,121.10
Water FundWellhead Protection$3,000.00$0.00$0.00
Water FundStorage-Tower 1$15,630.00$203.28$4,149.44
Water FundWater Maintenance$238,235.00$22,103.89$148,522.45
Water FundAdministration and General$32,060.00$1,930.28$23,731.86
Water FundDepreciation Expense$400,000.00$0.00$0.00
FUND 601 Water Fund$1,808,355.00$38,318.96$336,445.88
FUND 602 Sewer Fund
Sewer FundBond Payment (P & I)$234,320.00$26,325.00$48,383.75
Sewer FundOther Financing Uses$37,540.00$0.00$1,540.00
Sewer FundSanitary Sewer Maintenanc$216,790.00$10,595.01$123,149.67
Sewer FundLift Station-Baker Street$92,390.00$240.20$4,086.48
Sewer FundLift Station-Ridgewood/DBL$2,810.00$145.50$1,389.22
Sewer FundLift Station-Northland$4,425.00$122.47$1,162.58
Sewer FundLift Station-CR 121$4,650.00$143.21$1,394.46
Sewer FundLift Station-Main$769,100.00$2,599.82$457,202.05
Sewer FundAdministration and General$36,190.00$2,073.13$24,569.42
Sewer FundDepreciation Expense$450,000.00$0.00$0.00
FUND 602 Sewer Fund$1,848,215.00$42,244.34$662,877.63
FUND 603 Refuse Collection
Refuse CollectioWaste Collection$291,230.00$22,116.39$198,175.21
Refuse CollectioOther Financing Uses$770.00$0.00$770.00
Refuse CollectioDepreciation Expense$6,675.00$0.00$0.00
FUND 603 Refuse Collection$298,675.00$22,116.39$198,945.21
FUND 651 Storm Water Utility
Storm Water UtiOther Financing Uses$19,250.00$0.00$0.00
Storm Water UtiAdministration and General$16,580.00$932.83$12,950.95
Storm Water UtiStorm Water Maintenance$109,910.00$2,191.74$31,701.02
Storm Water UtiDepreciation Expense$115,000.00$0.00$0.00
FUND 651 Storm Water Utility$260,740.00$3,124.57$44,651.97
FUND 652 Street Light Utility
Street Light UtiliStreet Lighting$71,970.00$4,445.18$42,453.98
FUND 652 Street Light Utility$71,970.00$4,445.18$42,453.98
0.95
6,174.689,639.439,912.613,060.002,125.003,440.003,310.001,898.58
14,988.0410,823.1315,252.8412,185.0131,773.7991,197.4926,743.2826,035.3024,275.5396,607.1011,250.0025,177.6861,816.6223,970.0072,500.87
133,629.69340,279.86146,963.26148,861.84
676,946.29
750.00750.00750.00250.00500.00
5,000.001,100.007,500.003,450.007,350.004,200.001,500.002,000.002,000.006,000.007,800.007,000.003,600.002,000.00
15,100.0011,230.0029,730.0036,000.0018,600.0084,000.0048,600.0049,100.00
177,930.00
9/30
260.30
1,291.192,987.303,277.756,795.008,102.008,362.304,117.984,117.98
54,176.8755,468.0613,060.05
81,008.39
9/30through
201720172017Balance
Summary
5,206.645,206.641,120.002,594.60
(5,000.00)(5,000.00)
20,870.4024,585.00
24,791.64
2016
Plan
5,
2017
30,
964.90
4,685.015,424.688,056.735,295.957,912.611,060.001,375.003,190.005,250.001,310.001,398.58
Expenditures
15,529.2360,000.0014,152.8426,567.1519,393.2813,728.6855,352.1597,889.9917,377.6854,816.6220,370.0062,002.8799,245.28
Availablethrough 126,358.91264,642.16100,643.86
December
546,997.08
Improvement
September
Capital
of
adopted
Capital
As
2017
Final
Fund
Total EDA CIP
Total Police CIP
General
Total Public Works CIP
Total Administration CIP
CodeEquipmentBalanceGrant
150-46500-582Computer Software150-46500-588EDA ProgramsTotal General Capital Improvements
ProjectBudgetReserveTransferred/SpentBudgetRemaining
DepartmentAccount
SoftwareProjects
Election101-41410-xxxElection EquipmentPlanning101-41941-300Comp Plan UpdateAdministration490-41430-570Administration EquipmentAdministration490-41430-581Computer ReplacementAdministration490-41430-5
82Computer SoftwareCable Access108-41950-580Cable EquipmentPolice - General490-42120-580Police EquipmentPolice-Communications490-42151-580Communication EquipmentPolice - Automotive490-42152-550Police
SquadsPolice - Automotive490-42152-580Vehicle/EquipmentPolice - Automotive490-42152-581Squad LaptopsEmergency Services490-42500-580Emergency ServicesStreets101-43120-530Street ImprovementsStreets490
-43120-550Street Motor VehiclesStreets490-43120-580Street EquipmentStreets490-43120-582Street SoftwareStreets490-43120-530Street ImprovementsStreet Sweeping490-43220-580Street Sweeping
EquipmentSnow Removal490-43125-580Snow Removal EquipmentMaintenance490-45201-580Maintenance Shop EquipmentParks490-45202-530Parks ImprovementsParks490-45202-580Parks EquipmentParks490-45202-550Parks
Motor Vehicles EDAEDA
3,332.79 3,332.79 1,203.959,250.005,376.621,927.57 1,927.57
(6,758.16)
10,137.53 10,137.53 25,562.40 25,562.40 50,259.5875,823.7767,250.0071,000.0017,501.0012,592.1770,908.25 76,284.87 22,266.9210,450.00
(39,475.08)
304,880.47415,367.47
788.53 788.53
1,978.95 1,978.95 2,119.95 2,119.95
59,967.00 59,967.0064,854.43
u
k
2,500.00 2,500.002,500.00
ment + trade in val
y
750.00200.00 200.00 500.00
1,300.00 1,300.00 5,000.00 5,000.00 4,000.00 4,000.00 8,500.002,500.002,250.001,900.003,000.001,500.001,000.00 3,000.00
BudgetAdjustmentsSpentReserve
10,000.0010,000.0012,000.00 47,900.00 16,700.00 19,700.0081,100.00
er with new tan
g
h
cas
y
last lon
2,032.797,116.48 7,000.00 1,727.57
y
21,562.4057,373.4050,208.84
AvailableGrants/9/30Available256,600.42396,621.90
12/31/20169/30
2
2021 - 10% down pa
-
203
-
#257,250.00
2022 - pa
-
#359,000.00
Equip21,562.40
#415,001.00
Lot19,991.92
2028 - ma
Gear7,116.48
Van41,759.58-
Radios54,208.25
Truck65,823.77
Repairs20,766.92
Rig
Truck
Wheeler453.95
MHz
Computers2,032.79
Air Packs
Replacement10,312.12Replacement3,165.15Replacement1,727.57
Building
Rescue VanPumper TruckLadder Truck #2Tanker #4
n/an/an/an/a
1996/2005Extrication
PurchasedReserve
Building
Building2008Painting9,450.00
than
than
other
other
2017
ReserveReserve2011Parking
Hardware/Software
Equipment20126Equipment2012RescueEquipment2012PumperEquipment2001LadderEquipment1997GrassEquipment1999TankerEquipment2013EquipmentEquipment2012Equipment2012Equipment2001Equipment1999
Hardware/Software2010/20113
Equipmentn/aTurnoutEquipment2007800EquipmentEquipment
Reserve
PayableImprovements
Equipment
Computer
for
Equipment
Equipment
Department
Building
Plan
OtherEquipmentEquipment
&
Fire
Services
BuildingEquipment
BuildingEquipmentBuildingImprovements
CǒƓķ
&&&
AdministrationFightingFightingFightingCommunicationsStation
ServicesOther
CźƩĻ
Joseph
FireFireFireFireFireMedicalFire
Improvement
AdministrationComputerFightingOtherFightingFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterComm
unicationOtherCommunicationOtherStationStationStationFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighter
Adopted December 4, 2016
St.
Proposed Debts
TotalTotalTotalTotalTotalTotalTotal
Capital
580Fire584Fire585Fire585Fire585Fire585Fire585Fire585Fire585Fire585Fire580Fire580Fire580Medical530Fire530Fire530Fire585Fire585Fire585Fire585Fire
LƒƦƩƚǝĻƒĻƓƷ
581/582Fire
CodeDepartmentObjectYearDescriptionFunds201720172017Funds
4222042220422204222042220422204222042220422204222042250422504227042280422804228042220422204222042220
/ğƦźƷğƌ
42210
Account
105105105105105105105105105105105105105105105105105105105105
105
ƚƷğƌ Note: The fire department is funded by the City of St. Joseph, St. Joseph Township and St. Wendel Township.
CIP #
FD-1401FD-1402FD-1404FD-1403FD-1405FD-1406FD-1407FD-1408FD-1409FD-1417FD-1410FD-1411FD-1412FD-1413FD-1414FD-1415FD-1416FD-1405FD-1406FD-1407FD-1409
A
1,898.586,327.026,710.80
ED
53,339.5059,722.3112,627.67
140,625.88
138,727.30
Plan
s
2016
2016
20,
9/30
4,
445.00
4,117.98
July
3,672.984,117.98
Expenditure
Improvement
December
Capital
9/30through
Capital
Recommended:
(5,000.00)
(5,000.00)(5,000.00)
2017
Adopted
Fund
EDA
General
500.00
5,000.00
49,100.00
10,000.0023,600.0010,000.0048,600.00
1,398.586,710.80
43,339.5036,567.3112,627.6799,245.28
100,643.86
Availablethrough
12/31/2016
Computer SoftwareLet's Go DowntownBusiness Development/TIFParkway Business CenterBusiness Demolition ProgramBFA Grant/RLF Loan ProgramCSAH 2/3 Collection Street2017 - moved $5,000 budget
to Great St. Cloud Partnership dues
EDA-1401EDA-1402EDA-1407EDA-1407EDA-1408EDA-1403EDA-1405
CodeNumberEquipmentBalance201720172017Balance
P
ProjectProjectReserveBudgetGrants/AidsSpent2017
DepartmentAccount
EDA150-46500-582EDA150-46500-588 TOTAL EDA CI
0000000000400
0000000
4
60.0060.0060.0060.00
4,750.05,250.07,560.09,200.09,200.05,692.62
9,150.07,000.0
5,752.62
11,250.017,500.032,000.017,000.035,000.014,000.011,800.013,550.070,619.442,000.077,902.217,000.060,000.0
47,960.0017,000.0060,000.00
142,820.00204,131.6
Works
)
Public
6
s
201
9/302017
Plan
4,
of
(6,460.60
(6,460.60)
as
))
Expenditure
/
December
Capital
Improvement
(2,000.00
(2,000.00)
(13,350.00
(13,350.00)
2017
Adopted
0000000000000000
Capital
60.0060.0060.0060.00
500.00500.00500.00
2,000.01,250.05,000.05,000.02,000.07,000.02,300.02,300.02,200.02,000.01,000.01,000.06,000.0
1,060.006,000.00
15,000.020,000.012,000.0
13,810.0051,360.0015,560.00
Enterprise
00000000000000000400
4
2,750.05,560.06,500.06,900.06,900.09,600.04,692.62
4,692.62
10,750.019,000.010,000.015,000.014,000.013,050.075,080.030,000.076,902.211,000.060,000.0
47,500.0093,460.0011,000.0060,000.00
195,032.2
12/31/2016Grants
)
S
LS
L
S
Terrace
L
g
S
r
L
s
S
St
e
L
(Park
Foamin
)
RidgewoodBakerNorthlandCR121
Main
(1/4
System
Programme Funding
Replacement4,000.0
Improvement
r
r
g
pumpspumpspumpspumps
g
BathroomsBathrooms
RoofLoader
))
Meter
Easements/Acquir
Project
UBUBUBUB
Repairs17,500.0Repairs12,500.0
Quality
LininTelevising/RootSample
SweepeLightin
ReplacementMapping
(1/4(1/4
End
12
#4/5
TruckPrinterHandheldKlinefelterWellWTPWTPTruckPrinterSewerSewerKlinefelterSewerPumpSubmersibleSubmersibleSubmersibleSubmersiblePrinterAerialWaterStreetPropertyPrinterFrontStreetCommunications
Residual
8
1401140140214031403140314031403
15031503
14031629140316291629140716291425
14011402140314031407
140414051406
1410
SSSSSSSL
PWPWWTWTWTWTPWPWPWPWPWPWWT
ENGWWWWENGWWWWWWWWWWWW
550582580530220580580550581530300530580580530530530530582530530580510581580530580
CodeNumberEquipmentBalance201720172017Balance
494404949049490494404941049420494214945049490494504945049450494804948049471494704947249473494904990049900499004990043230432304316043120
601601601601601601601602602602602602602602602602602602651651651651651603603652450
g
ProjectProjectReserveBudgetTransfersSpentAvailable
Lightin
DepartmentAccount
WaterSewerStormwaterRefuseSt.Streets
City of St. Joseph Park Board
2017 Capital Improvement Budget Summary
Adopted December 4, 2016
General FundsBalance
Park Dedication Cash September 30, 2017107,585$
(Unaudited)
Adjustments
Starting Balance107,585$
2017 General Levy-remaining11,005$
Other Revenues-remaining32,196$
Potential Projects:PotentialProposed
Millstream Cottages-phase 223,400$
Sunset Ridge-phase 2 - 4 lots2,000$
Ending Balance for 2017150,786$
Projects - Budget201620172018201920202021Total 17-21
PTR-01 (Millstream)350,000$$ -40,000$ -$ -$ -$ 40,000$
PTR-02 (Northland)-$ -$ -$ -$ -$ -$ -$
PTR-03 (Klinefelter)-$ -$ -$ -$ -$ 20,200$ 20,200$
PTR-04 (Wobegon)-$ -$ -$ -$ -$ -$ -$
PTR-05 (Memorial)-$ 3,200$ -$ -$ -$ -$ 3,200$
PTR-06 (Centennial)-$ -$ -$ -$ -$ -$ -$
PTR-07 (Monument)30,400$$ 25035,250$ 250$ 250$ 250$ 36,250$
PTR-08 (Hollow)-$ -$ -$ -$ -$ -$ -$
PTR-09 (Cloverdale)-$ -$ -$ -$ -$ -$ -$
PTR-10 (East Park)-$ 10,000$ -$ 10,000$ -$ -$ 20,000$
PTR-11 (West Park)-$ -$ -$ -$ -$ -$ -$
PTR-12 (Trails)10,000$ 10,000$ 10,000$ 10,000$ 10,000$ 10,000$ 50,000$
PTR-13 (Trees)1,500$ 1,500$ 1,500$ 1,500$ 1,500$ 1,500$ 7,500$
PTR-14 (Dog Park)-$ 20,000$ 5,000$ -$ -$ -$ 25,000$
Total391,900$ 119,950$ 11,750$ 21,750$ 11,750$ 31,950$ 177,150$
Projects - ActualSpent 2016201717 Snow Town Expenses:Avail. Rev
PTR-01 (Millstream)2,500$ 7,800$ Millstream Shelter$ 905-$
PTR-02 (Northland)2,351$ -$ Footgolf
PTR-03 (Klinefelter)4,000$ -$ Prairie RestorationOther 17 Expenses:2017 YTD
PTR-04 (Wobegon)-$ -$ Real Estate Taxes-$ 4,014$
PTR-05 (Memorial)-$ -$ A-1 Toilets1,600$ 657$
PTR-06 (Centennial)-$ -$
PTR-07 (Monument)-$ -$ 2017 Revenue:2017 YTD
PTR-08 (Hollow)-$ -$ Interest1,000$ 860$
PTR-09 (Cloverdale)-$ -$ Round Up120$ 102$
PTR-10 (East Park)-$ 435$ phase 1 canoe areaGF Levy20,000$ 8,995$
PTR-11 (West Park)-$ -$ Land Rent5,400$ 1,060$
PTR-12 (Trails)-$ -$ Transfer525,000$ -$
PTR-13 (Trees)-$ -$ Donations30,000$ 4,302$
PTR-14 (Dog Park)-$ 15,128.86$ phase 1 dog parkPark Dedic.2,000$ -$
Total8,851$ 23,364$
17 Millstream 5k Expenses:Avail. Rev
aźƌƌƭƷƩĻğƒ{ŷĻƌƷĻƩ Spent 20162017$ 3,024-$
{ğƌĻƭğǣCǒƓķƭВͲЎЉЉυυЋЍЉͲЊБЎ
Dog Park Donations2016/2017
pavers/treats-$ 1,149$
cash10,000$ 5,339$ thru 10/3/17
In 2015, the Park Board requested updating the Master Park Planlast completed in 2008.
Millstream Shelter - Council approved using $7,500 half cent sales tax funding in 2015
Millstream Shelter - Council approved using $2,500 excess bldg permit revenue in 2016