HomeMy WebLinkAbout[04g] Treasurer Report I
CITY OF ST.JOSEPH Council Agenda Item
MEETING DATE: October 15, 2018
AGENDA ITEM: Financial Report—3rd Quarter 2018 & September 2018 Financial
Reports
SUBMITTED BY: Finance
BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N/A
PREVIOUS COUNCIL ACTION: Council adopted the 2018 budget on December 4, 2017.
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,2018.
CASH POSITION:
- The market rate of return(ROR)is approximately 2.28%with an average maturity of 25 months.
The federal markets continue to improve in 2018. 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 addition, one of the goals is to invest locally. The City's more
immediate cash flow needs are held at local financial institutions.
- In September,the Federal Open Market Committee [FOMC] increased the federal fund rates to
2.0 to 2.25%citing the labor market conditions continue to strengthen,the GDP is solid and
inflation remains around 2%.The FOMC indicated another potential rate hike in December if the
economy continues to be strong.
- Interest earnings for 2018 amounts to a$4,145. The City's policy is to hold investments until
maturity. GASB 31 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 increased$480,963 from the beginning of the year.
The first half tax settlement and state aids were received. Development fees such as building
permit revenue are well above budget. The bulk of the bond principal payments will be paid in
November;partly was the tax settlement proceeds pay for.
- In October, staff was notified Morgan Stanley is discontinuing their government client division.
Our financial advisor,Rich Knowlton,took a new position at RBC Financial. RBC Financial is
an official depository of the City,although they have not held investments for the City to date.
Staff transferred our Morgan Stanley investments to RBC Financial with Rich continuing as our
financial advisor. The transfer will be reflected in the 4th quarter financial reports.
FUNDS REPORT:
- The General fund spent 74%of the 2018 expenditure budget and received 58%of the revenue
budget. Expenditures and revenues are mainly operational in nature. To note,building permit
revenue has exceeded budget by$105,482 the end of September.
- The Enterprise Funds represent 8 months utility billing revenue collected while expenses
represent nine months of activity. Overall, 56%of expenses have been incurred(less
depreciation); 51%of the revenue budget has been received. Water expenses include final
construction payments for the water treatment plant 1 improvements.
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$216,897, including fees collected for a connection fee from three homeowners
that were sewer only(final partial payment). Also included are partial WAC fees for the 24 College
North and Country Manor projects.Water revenues represent 64%,expenses 61%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
$66,847 for the three quarters of 2018. Collections include fees for 18 single family homes and a partial
payment for 24 College North. Sewer expenses are at 51%of the budget,while revenues are at 52%of
the budget.
'A ¢ Sales Tax(fund 200): The sales tax fund has a cash balance of$1,000,325. The City anticipates
collecting$4,250,000 in sales tax revenue through 2018 ($3,372,754 original estimate); $4,047,950 was
collected to date. Collections have continually increased over the years, even during most of the
recession years. It is reasonable to estimate the 2018 collections will be approximately$425,000. The
anticipated remaining 2018 expenditures total $1,153,198 for the projects approved by Council.
The Supreme court ruled on the case between the State of North Dakota and Wayfair, Inc. The court
stated states have the right to collect sales tax across state lines from online sales. This will have a
positive impact on sales tax collections. However, significant increases are not anticipated for our area
due to the bulk of the online sales come from companies with buildings in Minnesota. If they have
property in Minnesota,the companies are already collecting and submitting sales taxes in Minnesota.
CIP REPORTS:
- General capital equipment purchases include: Public Works truck replacements,mowers, skid
loader and computer replacements. Also, seal coating,crack filling and sewer main televising
maintenance has been completed. The police department took possession of the new squad 704
as part of the 4-year lease rotation. The Comp Plan update was accepted by council on Oct. 1st
Administration purchased forms software and updating some security features in the computer
programs. Election equipment contracts with Stearns County were paid for along with some
election administration expenses.
- The Park Board completed the East Park master park plan with S.E.H. and approved Millstream
Park play equipment.
- The Fire Board approved lighting repairs and painting on the outside of the building. Uniforms
were purchased. The fire department accepted a donation from Kwik Trip East to purchase
defibulators.
- The EDA has been working with interested parties and the State to fund the Parkway Industrial
Park expansion.The City was awarded a 1.2M BDPI grant for infrastructure expenses.The EDA
recommended amendments to the TIF agreement for Bayou Blues to help construction get on the
way. In addition,the EDA completed a hotel study
BUDGET/FISCAL IMPACT: Information Only
ATTACHMENTS: Request for Council Action—Quarterly and September Financial Reports
3rd Quarter Reports:
Cash Position as of 9/30/18
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: Consider accepting the 3rd quarter and September financial
reports.
City of St. Joseph 10/10/18 3:12 PM
Page 1
Council Month End Revenue Summary
Current Period:September 2018
2018 September 2018
FUND FUND Descr YTD Budget 2018 Amt YTD Amt
101 General $2,961,415.00 $21,851.49 $1,712,008.74
102 Employee Retirement Reserve $6,500.00 $0.00 $6,500.00
105 Fire Fund $342,995.00 $22,484.58 $241,507.83
108 Cable Access Fee $7,935.00 $599.14 $4,963.22
150 Economic Development $119,025.00 $22.96 $55,126.63
152 TIF 3-1 CMCU $0.00 $8.38 $21,668.93
153 TIF 4-1 Fortitude Senior Apts $0.00 $6.11 $17,562.12
157 TIF 2-1 Millstream $0.00 $26.94 $14,425.49
158 TIF 2-2 Meat Market $0.00 $0.87 $2,191.51
159 TIF 2-3 Bayou Blues/Alley Flat $0.00 $0.07 $148.25
200 State Collected Sales Tax $425,000.00 $47,741.01 $226,950.74
205 Park Dedication $35,240.00 $144.27 $10,806.33
215 Charitable Gambling $0.00 $2.10 $1.73
220 Lodging Tax $0.00 $2,646.92 $12,163.32
225 DEED CDAP Grant $0.00 $7,581.03 $15,767.34
250 Revolving Loan Fund $0.00 $211.11 $5,615.50
301 2016 CIP Bonds[govt center] $270,005.00 $136.94 $178,340.39
303 2017A CIP Bonds[Gov Center] $55,500.00 $89,464.55 $99,570.59
304 2016 Street Impr[Field St] $55,290.00 $110.07 $25,235.18
305 2017B Impr Bonds[CBD Alleys] $48,085.00 $103.24 $18,507.34
306 2018 Equip Certificates $0.00 $150.40 $17,176.76
333 2010B Refundin[Hill/Clover] $178,360.00 $139.19 $37,594.25
338 2011A CO Refund[Interior St] $118,950.00 $142.99 $52,038.50
343 2009B GO CIP Bonds $57,050.00 $37.02 $30,242.52
345 2010B Street Impr[16th Ave] $41,120.00 $179.86 $18,513.26
346 2011A Pumper Truck Certificate $43,660.00 $3,405.70 $31,631.78
347 2011A GO CIP Bonds[roof/gar] $23,035.00 $60,013.48 $72,199.89
348 2013 Street Improve Bonds $20,585.00 $116.42 $9,834.75
349 2013 Equipment Certificates $57,065.00 $33.89 $30,202.59
350 2014 Street Impr[ParkTerrace] $101,395.00 $8,339.45 $66,315.10
351 2015 Street[Clinton/Northland] $44,160.00 $2,690.33 $55,786.77
352 2015 Equipment Certificates $37,005.00 $73.14 $79,779.10
353 2015 Abatement Bonds[Kennedy] $160,185.00 $160.53 $160,653.97
390 Debt Service Relief $28,000.00 $0.00 $4,713.88
402 Community Center phase I $0.00 $2.48 $581.50
406 2018 Equip Certificates $0.00 $0.00 $271,460.40
490 Capital Outlay $77,320.00 $0.00 $39,985.17
501 WAC Fund $0.00 $11,785.54 $218,268.49
502 SAC Fund $162,500.00 $11,206.30 $67,096.81
601 Water Fund $1,281,170.00 $59,214.40 $598,976.10
602 Sewer Fund $1,421,370.00 $48,274.34 $741,567.59
City of St. Joseph 10/10/18 3:12 PM
Page 2
Council Month End Revenue Summary
Current Period:September 2018
2018 September 2018
FUND FUND Descr YTD Budget 2018 Amt YTD Amt
603 Refuse Collection $280,200.00 $9,467.07 $162,852.47
651 Storm Water Utility $60,940.00 $2,819.50 $31,748.77
652 Street Light Utility $80,815.00 $2,716.24 $48,946.61
$8,601,875.00 $414,110.05 $5,517,228.21
City of St. Joseph 10/10/18 3:12 PM
Page 1
Council Month End Revenue -General Fund
Current Period:September 2018
2018 September 2018
FUND FUND Descr SOURCE Descr YTD Budget 2018 Amt YTD Amt
FUND 101 General
101 General Current Ad Valorem Taxes $1,282,660.00 $0.00 $608,969.60
101 General Special Levy-City St.Joe $0.00 $0.00 $0.00
101 General State Sales Tax $0.00 -$108.58 $59.67
101 General Gravel Tax $0.00 $0.00 $0.00
101 General Solar Production Tax $0.00 $0.00 $0.00
101 General Gas Franchise $31,210.00 $0.00 $15,599.71
101 General Electric Franchise $58,335.00 $2,087.07 $33,729.19
101 General Licenses&Permits $10,000.00 $0.00 $10,200.00
101 General Beer $1,950.00 $0.00 $3,205.44
101 General Liquor $29,135.00 $2,749.99 $27,166.24
101 General Outdoor Liquor Permit $1,775.00 $300.00 $3,130.00
101 General Gambling Permits $375.00 $0.00 $315.00
101 General Amusement/Hunt/Peddler/Golf $1,400.00 $80.00 $395.00
101 General Excavation Permit $500.00 $100.00 $500.00
101 General Cigarette License $675.00 $0.00 $62.50
101 General Cable Franchise Fee $34,000.00 $1,211.61 $19,053.73
101 General Building Permits $115,000.00 $2,591.89 $220,482.18
101 General Animal License $3,400.00 $60.00 $2,985.00
101 General Rental Housing Registration $30,305.00 $0.00 $30,551.12
101 General Federal Grants-Other $12,000.00 $0.00 $1,873.65
101 General State Grants and Aids $1,100.00 $0.00 $0.00
101 General Local Government Aid $989,464.00 $0.00 $494,732.00
101 General PERA Rate Increase Aid $1,541.00 $0.00 $770.50
101 General Police Training Reim $3,500.00 $0.00 $9,570.04
101 General State Municipal Funds Aid $50,000.00 $0.00 $56,098.00
101 General State Police Aid $62,000.00 $0.00 $576.50
101 General Other Grants/Aids $0.00 $0.00 $0.00
101 General Other Governmental Unit $10,000.00 $0.00 $10,000.00
101 General County Grants-Road Maint. $6,500.00 $0.00 $0.00
101 General Zoning and Subdivision Fee $5,000.00 $0.00 $6,310.00
101 General Land Use Deposit Fee $4,000.00 $0.00 $4,100.00
101 General Sale of Maps and Publications $50.00 $1.50 $16.25
101 General Assessments Search $4,000.00 $510.00 $5,160.00
101 General Special Hearing $5,500.00 $500.00 $1,500.00
101 General Administration Reimb $12,745.00 $25.00 $84.40
101 General Weed Cutting $500.00 $200.00 $200.00
•
101 General Admission Fee $1,000.00 $0.00 $0.00
101 General Shelter/Room Rental Fees $7,500.00 $585.00 $9,030.00
101 General Ball Field Donation $100.00 $0.00 $0.00
101 General Schneider Field Rental $1,500.00 $0.00 $1,325.00
City of St. Joseph 10/10/18 3:12 PM
Page 2
Council Month End Revenue -General Fund
Current Period:September 2018
2018 September 2018
FUND FUND Descr SOURCE Descr YTD Budget 2018 Amt YTD Amt
101 General Rents and Royalties $53,450.00 $5,089.40 $45,804.60
101 General Kennel Fees $500.00 $0.00 $117.00
101 General County Fines $40,000.00 $2,282.92 $22,484.44
101 General Policy Fines $15,000.00 $52.00 $14,912.15
101 General Accident Report Fee $1,200.00 $0.00 $1,158.00
101 General Seized Property $500.00 $0.00 $2,268.05
101 General Special Assessments $3,000.00 $0.00 $3,963.95
101 General Interest Earnings $20,000.00 $1,813.02 -$1,226.38
101 General Interest Charges $200.00 $7.06 $21.33
101 General Co-op Dividend-LMCIT $14,000.00 $0.00 $0.00
101 General Water Tower Antenna Lease $3,930.00 $181.21 $7,656.85
101 General Advertising $1,200.00 $0.00 $600.00
101 General Contributions-General $500.00 $0.00 $5,396.00
101 General Contributions-Parks $500.00 $114.00 $373.74
101 General Surplus Property $0.00 $0.00 $0.00
101 General Reimbursement $28,715.00 $1,418.40 $26,309.76
101 General Insurance Recovery $0.00 $0.00 $4,418.53
101 General Transfers from Other Funds $0.00 $0.00 $0.00
FUND 101 General $2,961,415.00 $21,851.49 $1,712,008.74
FUND 102 Employee Retirement Reserve
102 Employee Retirement Res Transfers from Other Funds $6,500.00 $0.00 $6,500.00
FUND 102 Employee Retirement Reserve $6,500.00 $0.00 $6,500.00
FUND 108 Cable Access Fee
108 Cable Access Fee Cable Franchise Fee $7,935.00 $599.14 $4,963.22
108 Cable Access Fee Transfers from Other Funds $0.00 $0.00 $0.00
FUND 108 Cable Access Fee $7,935.00 $599.14 $4,963.22
FUND 150 Economic Development
150 Economic Development Current Ad Valorem Taxes $114,325.00 $0.00 $53,866.15
150 Economic Development Federal Grants-Other $0.00 $0.00 $0.00
150 Economic Development TIF/MIF Deposit $3,600.00 $0.00 $1,500.00
150 Economic Development Tax Abatement Reimbursement $0.00 $0.00 $0.00
150 Economic Development Interest Earnings $1,100.00 $22.96 -$239.52
150 Economic Development Transfers from Other Funds $0.00 $0.00 $0.00
FUND 150 Economic Development $119,025.00 $22.96 $55,126.63
FUND 490 Capital Outlay
490 Capital Outlay Current Ad Valorem Taxes $77,320.00 $0.00 $36,485.17
490 Capital Outlay Federal Grants-Other $0.00 $0.00 $0.00
490 Capital Outlay Surplus Property $0.00 $0.00 $3,500.00
FUND 490 Capital Outlay $77,320.00 $0.00 $39,985.17
City of St. Joseph 10/10/18 3:12 PM
Page 3
Council Month End Revenue -General Fund
Current Period:September 2018
2018 September 2018
FUND FUND Descr SOURCE Descr YTD Budget 2018 Amt YTD Amt
$3,172,195.00 $22,473.59 $1,818,583.76
City of St. Joseph 10/10/18 3:11 PM
Page 1
Council Month End Revenue -Enterprise Funds
Current Period:September 2018
FUND 2018 September 2018
FUND Descr SOURCE Descr YTD Budget 2018 Amt YTD Amt
FUND 601 Water Fund
601 Water Fund Penalties and Forfeited Disc $8,110.00 $193.21 $5,684.41
601 Water Fund General Oblig. Bond Proceeds $0.00 $0.00 $0.00
601 Water Fund Transfers from Other Funds $207,000.00 $0.00 $0.00
601 Water Fund Contributed Revenue $0.00 $0.00 $0.00
601 Water Fund MDS Test Fee $12,250.00 $528.99 $6,446.06
601 Water Fund Current Ad Valorem Taxes $22,500.00 $0.00 $11,662.92
601 Water Fund Water Meter $5,000.00 $570.00 $15,750.00
601 Water Fund Connection/Reconnection fees $0.00 $0.00 $0.00
601 Water Fund Undesignated Funds $0.00 -$3,023.85 -$2,445.66
601 Water Fund Bulk Water $2,500.00 $0.00 $3,319.09
601 Water Fund State Grants and Aids $0.00 $0.00 -$48.00
601 Water Fund Water Fixed Charge $319,230.00 $14,374.44 $181,586.07
601 Water Fund State Sales Tax $0.00 $166.69 -$2,532.48
601 Water Fund Usage Rate $635,545.00 $44,092.81 $354,381.17
601 Water Fund Special Assessments $400.00 $0.00 -$704.08
601 Water Fund Interest Earnings $33,250.00 $606.27 $273.97
601 Water Fund Amortization of Bond Premium $0.00 $0.00 $0.00
601 Water Fund Water Tower Antenna Lease $35,385.00 $1,630.84 $25,464.63
601 Water Fund Surplus Property $0.00 $0.00 $0.00
601 Water Fund Reimbursement $0.00 $75.00 $138.00
FUND 601 Water Fund $1,281,170.00 $59,214.40 $598,976.10
FUND 602 Sewer Fund
602 Sewer Fund Penalties and Forfeited Disc $7,500.00 $161.65 $5,742.62
602 Sewer Fund Other Governmental Unit $0.00 $0.00 $0.00
602 Sewer Fund Special Assessments $400.00 $0.00 $61.90
602 Sewer Fund Interest Earnings $15,000.00 $1,160.11 $826.14
602 Sewer Fund Amortization of Bond Premium $0.00 $0.00 $0.00
602 Sewer Fund Contributions-General $0.00 $156.75 $596.75
602 Sewer Fund Surplus Property $0.00 $0.00 $0.00
602 Sewer Fund Reimbursement $4,000.00 $0.00 $0.00
602 Sewer Fund State Grants and Aids $0.00 $0.00 -$39.00
602 Sewer Fund Contributed Revenue $0.00 $0.00 $0.00
602 Sewer Fund Sewer Fixed Charge $541,935.00 $19,987.34 $291,257.26
602 Sewer Fund Transfers from Other Funds $0.00 $0.00 $0.00
602 Sewer Fund Sanitary Sewer Use Service $852,535.00 $26,808.49 $443,121.92
FUND 602 Sewer Fund $1,421,370.00 $48,274.34 $741,567.59
FUND 603 Refuse Collection
603 Refuse Collect Penalties and Forfeifted Disc $5,700.00 $83.11 $2,592.73
603 Refuse Collect Contributed Revenue $0.00 $0.00 $0.00
603 Refuse Collect Reimbursement $1,850.00 $0.00 $1,286.64
603 Refuse Collect Contributions-General $0.00 $0.00 $0.00
603 Refuse Collect Special Assessments $200.00 $0.00 $12.40
603 Refuse Collect Refuse Collection Charges $269,450.00 $10,430.36 $137,662.54
603 Refuse Collect State Grants and Aids $0.00 $0.00 -$5.00
603 Refuse Collect Licenses&Permits $0.00 $470.00 $24,385.60
603 Refuse Collect State Sales Tax $0.00 -$1,805.46 -$3,326.90
603 Refuse Collect Interest Earnings $3,000.00 $289.06 $244.46
FUND 603 Refuse Collection $280,200.00 $9,467.07 $162,852.47
City of St. Joseph 10/10/18 3:11 PM
Page 2
Council Month End Revenue -Enterprise Funds
Current Period:September 2018
FUND 2018 September 2018
FUND Descr SOURCE Descr YTD Budget 2018 Amt YTD Amt
FUND 651 Storm Water Utility
651 Storm Water State Grants and Aids $0.00 $0.00 -$10.00
651 Storm Water Storm Water Develop Fee $4,000.00 $0.00 $2,698.00
651 Storm Water Storm Water Use Service $51,920.00 $2,598.74 $29,853.57
651 Storm Water Penalties and Forfeifted Disc $2,120.00 $9.24 $517.68
651 Storm Water Contributed Revenue $0.00 $0.00 $0.00
651 Storm Water Special Assessments $400.00 $0.00 -$1,392.95
651 Storm Water Other Grants/Aids $0.00 $0.00 $0.00
651 Storm Water Interest Earnings $2,500.00 $211.52 $82.47
FUND 651 Storm Water Utility $60,940.00 $2,819.50 $31,748.77
FUND 652 Street Light Utility
652 Street Light U State Grants and Aids $0.00 $0.00 -$2.00
652 Street Light U Other Grants/Aids $0.00 $0.00 $571.00
652 Street Light U Special Assessments $50.00 $0.00 $2.02
652 Street Light U Interest Earnings $400.00 $200.11 $349.19
652 Street Light U Contributions-General $0.00 $0.00 $7,000.00
652 Street Light U Reimbursement $3,000.00 $0.00 $0.00
652 Street Light U Usage Rate $76,365.00 $2,503.72 $40,556.50
652 Street Light U Penalties and Forfeited Disc $1,000.00 $12.41 $469.90
FUND 652 Street Light Utility $80,815.00 $2,716.24 $48,946.61
$3,124,495.00 $122,491.55 $1,584,091.54
City of St. Joseph 10/10/18 3:10 PM
Page 1
Council Month End Expenditure - Summary
Current Period:September 2018
2018 September 2018
Description YTD Budget 2018 Amt YTD Amt
General $2,961,415.00 $194,590.12 $2,150,987.99
Employee Retirement Reserve $0.00 $0.00 $0.00
Fire Fund $346,465.00 $5,555.02 $130,935.80
Cable Access Fee $7,935.00 $0.00 $36,000.00
Economic Development $119,025.00 $6,139.90 $64,140.39
TIF 3-1 CMCU $795.00 $0.00 $20,891.05
TIF 4-1 Fortitude Senior Apts $0.00 $0.00 $17,780.24
TIF 2-1 Millstream $34,545.00 $0.00 $14,365.84
TIF 2-2 Meat Market $4,545.00 $0.00 $2,136.16
TIF 2-3 Bayou Blues/Alley Flat $795.00 $0.00 $1,593.06
State Collected Sales Tax $1,110,000.00 $9,444.19 $272,814.49
Park Dedication $143,190.00 $139.00 $18,410.50
Charitable Gambling $4,500.00 $0.00 $0.00
Lodging Tax $0.00 $0.00 $4,000.00
DEED CDAP Grant $0.00 $0.00 $1,834.00
Revolving Loan Fund $0.00 $0.00 $35.00
2016 CIP Bonds[govt center] $273,345.00 $0.00 $46,621.25
2017A CIP Bonds[Gov Center] $55,070.00 $0.00 $8,261.77
2016 Street Impr[Field St] $63,950.00 $3,147.90 $26,625.57
2017B Impr Bonds[CBD Alleys] $46,745.00 $0.00 $7,136.88
2018 Equip Certificates $0.00 $0.00 $11,258.00
2010B Refundin[Hill/Clover] $144,350.00 $0.00 $4,624.00
2011A CO Refund[Interior St] $141,730.00 $136,310.00 $142,125.00
2009B GO CIP Bonds $62,745.00 $0.00 $1,125.00
2010B Street Impr[16th Ave] $62,755.00 $0.00 $6,327.50
2011A Pumper Truck Certificate $43,660.00 $41,780.00 $43,560.00
2011A GO CIP Bonds[roof/gar] $21,820.00 $81,110.00 $81,970.00
2013 Street Improve Bonds $42,870.00 $0.00 $3,885.00
2013 Equipment Certificates $61,300.00 $0.00 $600.00
2014 Street Impr[ParkTerrace] $164,535.00 $0.00 $24,717.50
2015 Street[Clinton/Northland] $71,050.00 $0.00 $5,475.00
2015 Equipment Certificates $36,850.00 $0.00 $875.00
2015 Abatement Bonds[Kenned $152,235.00 $0.00 $21,067.50
Debt Service Relief $141,000.00 $60,000.00 $122,809.93
Community Center phase I $0.00 $0.00 $0.00
2016 Imp Field St $0.00 $0.00 $0.00
2017 CBD Alley Improve ph 1 $0.00 $353.25 $10,907.32
2018 Equip Certificates $0.00 $392.92 $133,653.72
Capital Outlay $77,320.00 $3,386.50 $22,166.02
WAC Fund $200,000.00 $0.00 $0.00
SAC Fund $96,090.00 $0.00 $0.00
City of St. Joseph 10/10/18 3:10 PM
Page 2
Council Month End Expenditure - Summary
Current Period:September 2018
2018 September 2018
Description YTD Budget 2018 Amt YTD Amt
Water Fund $1,612,550.00 $33,273.58 $620,258.43
Sewer Fund $1,812,260.00 $173,149.72 $734,479.62
Refuse Collection $293,185.00 $23,658.13 $216,641.88
Storm Water Utility $256,345.00 $5,506.09 $82,641.59
Street Light Utility $80,975.00 $4,436.76 $51,999.48
$10,747,945.00 $782,373.08 $5,167,737.48
City of St. Joseph 10/10/18 3:09 PM
Page 1
Council Month End Expenditure - General Fund
Current Period:September 2018
2018 September 2018
Description DEPART Descr YTD Budget 2018 Amt YTD Amt
FUND 101 General
General Council $64,605.00 $1,636.78 $42,791.81
General Legislative Committees $5,945.00 $0.00 $1,093.21
General Ordinance&Proceedings $2,600.00 $107.67 $1,369.42
General Mayor $11,845.00 $781.34 $7,270.65
General Elections $2,500.00 $72.89 $1,523.77
General General Adminstration $269,605.00 $16,069.40 $200,973.75
General Finance $139,945.00 $9,435.72 $98,089.17
General Audit Service $30,000.00 $0.00 $27,750.00
General Assessing $24,000.00 $0.00 $24,579.83
General City Attorney $18,000.00 $3,255.00 $16,463.71
General Planning and Zoning $76,065.00 $7,855.59 $73,865.96
General General Government $38,960.00 $3,129.37 $29,687.87
General City Offices $38,510.00 $2,262.68 $38,532.08
General Cable Access $6,390.00 $422.95 $3,252.94
General Crime Control&Investigation $1,127,945.00 $65,757.75 $761,034.14
General Police Training $9,545.00 $0.00 $5,874.33
General Communication Service $12,780.00 $1,449.16 $8,979.72
General Automotive Services $57,360.00 $6,804.64 $35,164.19
General Building Inspec.Admistration $95,200.00 $7,500.00 $63,899.45
General Emergency Management $975.00 $7.04 $1,686.29
General Animal Control $815.00 $0.00 $403.99
General Street Maintanence $297,290.00 $12,522.24 $203,299.24
General Ice&Snow Removal $120,235.00 $15,175.18 $75,303.63
General Engineering Fee $35,000.00 $2,942.85 $39,002.12
General Street Cleaning $14,095.00 $0.00 $6,893.25
General Skate Park and Ice Rink $5,410.00 $203.04 $3,818.18
General Ball Park $1,750.00 $215.25 $3,878.60
General Maintenance Shop $26,475.00 $5,561.18 $24,226.10
General Park Areas $230,050.00 $21,044.28 $195,768.97
General Community Center $63,115.00 $2,814.68 $42,218.94
General Other Financing Uses $0.00 $7,563.44 $12,563.44
General Fire Protection $134,405.00 $0.00 $99,729.24
FUND 101 General $2,961,415.00 $194,590.12 $2,150,987.99
FUND 102 Employee Retirement Reserve
Employee Retirement Resery General 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 Fee Cable Access $7,935.00 $0.00 $0.00
Cable Access Fee Other Financing Uses $0.00 $0.00 $36,000.00
City of St. Joseph 10/10/18 3:09 PM
Page 2
Council Month End Expenditure - General Fund
Current Period:September 2018
2018 September 2018
Description DEPART Descr YTD Budget 2018 Amt YTD Amt
FUND 108 Cable Access Fee $7,935.00 $0.00 $36,000.00
FUND 150 Economic Development
Economic Development Economic Development Authority $119,025.00 $6,139.90 $64,140.39
Economic Development Other Financing Uses $0.00 $0.00 $0.00
FUND 150 Economic Development $119,025.00 $6,139.90 $64,140.39
FUND 490 Capital Outlay
Capital Outlay General Adminstration $11,300.00 $0.00 $6,464.56
Capital Outlay Crime Control&Investigation $3,380.00 $0.00 $0.00
Capital Outlay Communication Service $4,875.00 $0.00 $0.00
Capital Outlay Automotive Services $13,595.00 $0.00 $2,459.25
Capital Outlay Emergency Management $1,500.00 $0.00 $0.00
Capital Outlay Street Maintanence $3,750.00 $0.00 $3,810.00
Capital Outlay Ice&Snow Removal $7,500.00 $0.00 $992.86
Capital Outlay Street Cleaning $2,750.00 $0.00 $0.00
Capital Outlay Maintenance Shop $5,000.00 $0.00 $0.00
Capital Outlay Park Areas $23,670.00 $3,386.50 $8,439.35
Capital Outlay Community Center $0.00 $0.00 $0.00
Capital Outlay Other Financing Uses $0.00 $0.00 $0.00
FUND 490 Capital Outlay $77,320.00 $3,386.50 $22,166.02
$3,165,695.00 $204,116.52 $2,273,294.40
City of St. Joseph 10/10/18 3:11 PM
Page 1
Council Month End Expense - Enterprise Funds
Current Period:September 2018
2018 September 2018
Description DEPART Descr YTD Budget 2018 Amt YTD Amt
FUND 601 Water Fund
Water Fund Bond Payment(P&I) $706,535.00 $0.00 $56,838.06
Water Fund Other Financing Uses $41,500.00 $0.00 $500.00
Water Fund Power and Pumping $28,925.00 $718.93 $2,719.82
Water Fund Purification-Plant 1 $31,170.00 $3,350.87 $274,295.68
Water Fund Purification-Plant 2 $85,300.00 $8,164.72 $63,357.97
Water Fund Distribution $10,000.00 $0.00 $17,030.57
Water Fund Wellhead Protection $3,000.00 $0.00 $0.00
Water Fund Storage-Tower 1 $15,890.00 $525.33 $4,520.92
Water Fund Water Maintenance $262,325.00 $18,418.92 $169,078.26
Water Fund Administration and General $27,905.00 $2,094.81 $31,917.15
Water Fund Depreciation Expense $400,000.00 $0.00 $0.00
FUND 601 Water Fund $1,612,550.00 $33,273.58 $620,258.43
FUND 602 Sewer Fund
Sewer Fund Bond Payment(P&I) $230,360.00 $26,075.00 $8,482.00
Sewer Fund Other Financing Uses $7,500.00 $0.00 $500.00
Sewer Fund Sanitary Sewer Maintenanc $209,845.00 $8,331.89 $112,752.07
Sewer Fund Lift Station-Baker Street $5,865.00 $190.54 $2,776.64
Sewer Fund Lift Station-Ridgewood/DBL $2,695.00 $157.73 $1,209.63
Sewer Fund Lift Station-Northland $4,665.00 $79.75 $728.42
Sewer Fund Lift Station-CR 121 $5,340.00 $4,648.20 $43,377.96
Sewer Fund Lift Station-Main $813,930.00 $131,292.53 $528,191.07
Sewer Fund Administration and General $32,060.00 $2,374.08 $36,461.83
Sewer Fund Depreciation Expense $500,000.00 $0.00 $0.00
FUND 602 Sewer Fund $1,812,260.00 $173,149.72 $734,479.62
FUND 603 Refuse Collection
Refuse Collectio Waste Collection $286,010.00 $23,658.13 $216,141.88
Refuse Collectio Other Financing Uses $500.00 $0.00 $500.00
Refuse Collectio Depreciation Expense $6,675.00 $0.00 $0.00
FUND 603 Refuse Collection $293,185.00 $23,658.13 $216,641.88
FUND 651 Storm Water Utility
Storm Water Uti Other Financing Uses $19,250.00 $0.00 $0.00
Storm Water Uti Administration and General $14,165.00 $1,093.12 $14,805.18
Storm Water Uti Storm Water Maintenance $107,930.00 $4,412.97 $67,836.41
Storm Water Uti Depreciation Expense $115,000.00 $0.00 $0.00
FUND 651 Storm Water Utility $256,345.00 $5,506.09 $82,641.59
FUND 652 Street Light Utility
Street Light Utili Street Lighting $80,975.00 $4,436.76 $51,999.48
FUND 652 Street Light Utility $80,975.00 $4,436.76 $51,999.48
City of St. Joseph 10/10/18 3.11 PM
Page 2
Council Month End Expense - Enterprise Funds
Current Period:September 2018
2018 September 2018
Description DEPART Descr YTD Budget 2018 Amt YTD Amt
$4,055,315.00 $240,024.28 $1,706,021.00
2018 Capital Expenditures
General Fund Capital Equipment Plan-Summary
Final adopted December 4,2017
As of September 30,2018
Available through 9/30 through 9/30
Project Budget Reserve Transferred/ Spent Budget Remaining
Department Account Code Equipment Balance Grant 2018 2018 2018 Balance
Election 101-41410-xxx Election Equipment 14,988.04 - 1,523.77 2,500.00 15,964.27
Planning 101-41941-300 Comp Plan Update 4,915.04 - 1,172.50 2;500.00 6,242.54
Finance 101-41530-300 GASB Updates 5,200.00 - 1,800.00 2,600.00 6,000.00
Administration 490-41430-570 Administration Equipment 20,252.84 - - 3,050.00 23,302.84
Administration 490-41430-581 Computer Replacement 11,687.01 - 64.56 7,500.00 19,122.45
Administration 490-41430-582 Computer Software 6,174.68 - 6,400.00 750.00 524.68
Cable Access 108-41950-580 Cable Equipment 33,717.49 4,963.22 36,000.00 - 2,680.71
Total Administration CEP 96,935.10 4,963.22 46,960.83 18,900.00 73,837.49
Police-General 490-42120-580 Police Equipment 9,639.43 - - 3,380.00 13,019.43
Police-Communications 490-42151-580 Communication Equipment 26,743.28 - - 4,875.00 31,618.28
Police-Automotive 490-42152-550 Police Squads 21,709.36 - - 1,500.00 23,209.36
Police-Automotive 490-42152-580 Vehicle/Equipment 22,942.08 - 2,459.25 10,895.00' 31,377.83
Police-Automotive 490-42152-581 Squad Laptops 0.95 - - 1,200.00' 1,200.95
Emergency Services 490-42500-580 Emergency Services 9,912.61 - - 1,500.00 11,412.61
Total Police CEP 90,947.71 - 2,459.25 23,350.00 111,838.46
Streets 101-43120-530 Street Improvements 135,894.61 38,249.00 33,424.77 21,500.00 162,218.84
Streets 490-43120-550 Street Motor Vehicles 3,060.00 1,750.00 3,810.00 3,000.00 4,000.00
Streets 490-43120-580 Street Equipment 2,125.00 - - 500.00 2,625.00
Streets 490-43120-582 Street Software 3,440.00 - - 250.00 3,690.00
Street Sweeping 490-43220-580 Street Sweeping Equipment 11,250.00 - - 2,750.00 14,000.00
Snow Removal 490-43125-580 Snow Removal Equipment 25,177.68 - 992.86 7,500.00 31,684.82
Maintenance 490-45201-520 Maintenance Cold Storage - - - - -
Maintenance 490-45201-580 Maintenance Shop Equipment 61,816.62 - 5,000.00 66,816.62
Parks 490-45202-530 Parks Improvements 23,970.00 - - 3,400.00 27,370.00
Parks 490-45202-580 Parks Equipment 72,500.87 - 4,379.35 17,270.00 85,391.52
Parks 490-45202-550 Parks Motor Vehicles 3,310.00 1,750.00 4,060.00 3,000.00 4,000.00
Total Public Works CEP 342,544.78 41,749.00 46,666.98 64,170.00 401,796.80
EDA Software 150-46500-582 Computer Software 1,898.58 - - 500.00 2,398.58
EDA Projects 250/150-46500-588 EDA Programs 136,713.66 (5,000.00) 22,851.07 56,100.00 210,664.73
Total EDA CIP 138,612.24 (5,000.00) 22,851.07 56,600.00 213,063.31
Total General Capital Improvements 669,039.83 41,712.22 118,938.13 163,020.00 800,536.06
St.Joseph Fire Department
Capital Equipment Plan-for Payable 2018
Adopted December 4,2017
12/31/2017 9/30
Available Grants/ 9/30 Available
Purchased Replace Reserve Budget Adjustments Spent Reserve
CIP# Account Code Department Object Year Year Description Funds 2018 2018 2018 Funds',
FD-1401 105-42210-581/582 Fire Administration Computer Hardware/Software 2010-2011 2017-2018 3 Computers 3,332.79 1,300.00 4,632.79
Total Fire Administration Computer Hardware/Software 3,332.79 1,300.00 - - 4,632.79
FD-1402 105-42220-580 Fire Fighting Other Equipment annual annual Turnout Gear 7,755.66 5,000.00 3,983.95 8,771.71
Total Fire Fighting Other Equipment 7,755.66 5,000.00 - 3,983.95 8,771.71
FD-1404 105-42220-584 Fire Fighting 1996-2006 2019-2026 Extrication Equip 25,562.40 2,750.00 28,312.40
Total Fire Fighting Equipment Reserve 25,562.40 2,750.00 - 28,312.40
FD-1403 105-42220-585 Fire Fighting Firefighter Equipment 2012 2024 6 Wheeler 1,203.95 750.00 1,953.95
FD-1405 105-42220-585 Fire Fighting Firefighter Equipment 2012 2022 Rescue Van 50,259.58 9,500.00 59,759.58
FD-1406 105-42220-585 Fire Fighting Firefighter Equipment 2012 2032 Pumper Truck 75,823.77 11,000.00 86,823.77
FD-1407 105-42220-585 Fire Fighting Firefighter Equipment 2001 2021 Ladder Truck#2 67,250.00 10,000.00 77,250.00
FD-1408 105-42220-585 Fire Fighting Firefighter Equipment 1997 2022 Grass Rig#3 71,000.00 1,500.00 72,500.00
FD-1409 105-42220-585 Fire Fighting Firefighter Equipment 1999 2028 Tanker#4 17,501.00 2,500.00 20,001.00
FD-1417 105-42220-585 Fire Fighting Firefighter Equipment 2013 2019 Air Packs 9,250.00 2,250.00 11,500.00
FD-1410 105-42220-585 Fire Fighting Firefighter Equipment on going on going Replacement 12,592.17 2,000.00 1,205.04 13,387.13
Total Fire Fighting Equipment 304,880.47 39,500.001,205.04 343,175.43
FD-1411 105-42250-580 Fire Communication Other Equipment 2007 2017 800 MHz Radios 70,908.25 10,000.00 80,908.25
FD-1412 105-42250-580 Fire Communication Other Equipment on going on going Replacement 5,376.62 3,000.00 8,376.62
Total Fire Communications Equipment 76,284.87 >13,000.00 - 89,284.87
FD-1413 105-42270-580 Medical Services Other Equipment on going on going Replacement 1,927.57 200.00 1,000.00 3,127.57
Total Medical Services Equipment 1,927.57 200.00 1,000.00 - 3,127.57
FD-1414 105-42280-530 Fire Station&Building Equipment Reserve on going on going Building Repairs 22,266.92 1,500.00 (18,000.00) 5,578.82 188.10
FD-1415 105-42280-530 Fire Station&Building Equipment Reserve 2011 2017-2022 Parking Lot (44,027.58 25,500.00 19,000.00 - 472.42
FD-1416 105-42280-530 Fire Station&Building Improvements other than Building 2008 2017-2024 Painting 10,450.00 1,000.00 (1,000.00) 8,000.00 2,450.00
Total Fire Station&Building improvements other than Building (11,310.66 28,000.00 - 13,578.82 3,110.52
Total Capital Equipment-Fire Fund 408,433.30 89,750.00 1,000.00 18,767.81 480,415.29
Note: The fire department is funded_by the City of St.Joseph,St.Joseph Township and St.Wendel Township.
m iiiWit Debs:..
FD-1405 105-42220-585 Fire Fighting Firefighter Equipment 2012 2022 Rescue Van-2022-pay casl-
FD-1406 105-42220-585 Fire Fighting Firefighter Equipment 2012 2032 Pumper Truck-2032
FD-1407 105-42220-585 Fire Fighting Firefighter Equipment 2001 2021 Ladder Truck#2.2021 -10%down payment+trade in valu
FD-1409 105-42220-585 Fire Fighting Firefighter Equipment 1999 2028 Tanker#4.2028-may last longer with new tan
2018 Capital Expenditures
Enterprise Capital Equipment Plan-Public Works
Adopted December 4,2017
########q# Grants/ as of 9/30 2018
Project Project Purchase Replace Reserve Budget Transfers Spent Available
Department Account Code Number Equipment Year Year Balance 2018 2018 2018 Balance
1984/2005
2006/2008 2018/2020
Water- 601-49440-55C PW-1403 Truck(1/4) 2013 /2021 4,750.00 3,000.00 (7,750.00) -
601-49440-58C WT-1804 Fuel Tank new 2020 - 500.00 500.00
601-49440-52CENG-1503Klinefelter Bathrooms new 2022 - -
601-49440-52C PW-1411 PW Building Expansion new 2022 - 20,000.00 20,000.00
601-49440-30C WT-1805 Water Supply Plan 2017 2027 - - -
601-49440-30C WT-1805 Water Distribution System Model Study 2006 2021 - - -
601-49434-30C WT-1805 Wellhead Protection Plan 2010 2020 -
601-49490-582 WT-1705 Printer-UB 2016 2021 60.00 60.00 x' 120.00
601-49490-58C WT-1401'Handheld Meter Programmer zoos 2017 11,250.00 500.00 11,750.00
601-49490-30CWT-1803-Comprehensive Rate Study 2015 2020 - -
601-49435-53CWT-1712 Water Tower Maintenance 2014 2022 - 10,000.00'' 10,000.00
601-49410-22C WT-1402 Well#4/5 Roof Replacement 1995 est.2020 5,250.00 1,000.00 6,250.00
601-49420-58C WT-1403 WTP 1 Repairs on going on going 9,150.00 5,000.00 1,875.87 16,025.87
60149421-58C WT-1403 WTP 2 Repairs on going on going 17,500.00 5,000.00 773.00 23,273.00
47,960.00 45,060.00 - (5,101.13) 87,918.87
1984/2005
2006/2008 2018/2020
Sewer- 602-49450-55C PW-1403 Truck(1/4) 2013 /2021 7,560.00 3,000.00 (7,856.95) 2,703.05
602-49450-58CWW-1804 Fuel Tank new 2020 - 500.00. 500.00
602-49450-53CWW-1401`Sewer Lining on going on going 25,848.50 15,000.00 40,848.50
602-49450-52C PW-1411 PW Building Expansion new 2022
602-49450-52CENG-1503 Klinefelter Bathrooms new 2022 - -
602-49450-30CWW-1408 Sewer Televising/Root Foaming on going on going 17,000.00 10,000.00 (7,395.06) 19,604.94
602-49450-30CWW-1805 Comprehensive Sewer Plan 2008/2009 2022 -
602-49490-30CWW-1803 Comprehensive Rate Study 2015 2020 - -
602-49490-581WW-1705 Printer-UB 2016 2021 60.00 60.00 120.00
602-49480-58CWW-1402 Sewer Sampler 2016 2021 7,000.00 500.00 7,500.00
602-49480-58CWW-1403 Pump Replacement-Main LS 35,000.00 20,000.00` 55,000.00
602-49471-53CWW-1403 Submersible pumps-Ridgewood LS 14,000.00 14,000.00
602-49470-53CWW-1403 Submersible pumps-Baker St LS 9,200.00 2,300.00 11,500.00
602-49472-53CWW-1403 Submersible pumps-Northland LS 9,200.00 2,300.00 11,500.00
602-49473-53CWW-1403 Submersible pumps-CR121 LS 11,800.00 2,200.00 14,000.00
######### 55,860.00 - ######### 177,276.49
2018 Capital Expenditures
Enterprise Capital Improvement Plan-Public Works
Adopted December 4,2017
########## Grants/ as of 9/30 2018
Project Project begin complete Reserve Budget '' Transfers Spent Available
Department Account Code Number Equipment Year Year Balance 2018 2018 2018 Balance
Stormwater- 651-49490-581 SS-1705 Printer-UB 2016 2021 60.00 60.00 120.00
651-49900-303 SS-1712 Update MS4 SWPPP/Permit Compliance - 1,000.00 1,000.00
651-49900-302 SS-1805 Pond Maintenance Schedule - - -
651-49900-53C SS-1404 Aerial Mapping 13,550.00 500.00 14,050.00
651-49900-53C 55-1405 Water Quality Improvements on going on going 69,190.20 2,000.00 ######### 61,061.25
651-49900-58C PW-1407 Street Sweeper 1997 2020 42,000.00 11,000.00 53,000.00
651-49900-51C SS-1406 Property Easements/Acquire on going on going 77,902.24 1,000.00 78,902.24
######### 15,560.00 - ######### 208,133.49
Refuse- 603-43230-581 RF-1705` Printer-UB 2016 2021 60.00 60.00 120.00
603-43230-58C PW-1425 Front End Loader(1/4) 2002/2014 2023/2029 5,692.62 1,000.00 6,692.62_
5,752.62 1,060.00 - - 6,812.62
St.Lighting- 652-43160-53C SL-1410 Street Lighting on going on going 17,000.00 7,000.00 24,000.00
17,000.00 7,000.00 - - 24,000.00
City of St. Joseph Park Board
2018 Capital Improvement Budget Summary
Council adopted December 4,2017
General Funds Balance
Park Dedication Cash September 30, 2018 $ 113,777
(Unaudited)
Adjustments
Starting Balance $ 113,777
2018 General Levy-remaining $ 10,579
Other Revenues-remaining $ 13,855
Potential Projects: Potential Proposed
Millstream Cottages-phase 2 $ 23,400
Southview Heights phase 1 [2019] $ 35,100
Southview Heights phase 2[2020] $ 35,100
Industrial Park[2019+] $ 8,580
Sunset Ridge-phase 2-4 lots $ 2,000
Ending Balance for 2018 $ 146,791
Projects-Budget 2017 2018 2019 2020 2021 2022 Total 18-22
PTR-01 (Millstream) $ 540,000 $ 40,000 $ - $ - $ 100,000 $ - $ 140,000
PTR-02(Northland) $ - $ - $ - $ 180,000 $ - $ - $ 180,000
PTR-03(Klinefelter) $ - $ - $ - $ - $ - $ 250,200 $ 250,200
PTR-04(Wobegon) $ - $ - $ - $ - $ - $ - $ -
PTR-05(Memorial) $ - $ 5,200 $ - $ - $ - $ - $ 5,200
PTR-06(Centennial) $ - $ - $ - $ - $ - $ - $ -
PTR-07(Monument) $ 25,250 $ 35,250 $ 250 $ 250 $ 250 $ 250 $ 36,250
PTR-08(Hollow) $ - $ 1,000 $ - $ - $ - $ - $ 1,000
PTR-09(Cloverdale) $ - $ - $ - $ - $ - $ - $ -
PTR-10(East Park) $ 4,500 $ 24,620 $ 598,730 $ - $ - $ - $ 623,350
PTR-12(Trails) $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 50,000
PTR-13(Trees) $ 1,500 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 10,000
PTR-14(Dog Park) $ 20,000 $ 20,000 $ - $ - $ 10,000 $ - $ 30,000
Total $ 601,250 $ 138,070 $ 610,980 $ 192,250 $ 122,250 $ 262,450 $ 1,296,000
Projects-Actual Spent 2017 2018 1.8 Snow Town Ex•enses: Avail.Rev
PTR-01 (Millstream) $ 7,837 $ 263 Millstream play equip $ - $ 905
PTR-02(Northland) $ - $ -
PTR-03(Klinefelter) $ - $ - Other 18 Expenses Budget: 2018 YTD
PTR-04(Wobegon) $ - $ - Real Estate Taxes $ 4,020 $ 3,862
PTR-05(Memorial) $ - $ - A-1 Toilets $ 1,600 $ 931
PTR-06(Centennial) $ - $ -
PTR-07(Monument) $ - $ - 2018 Reven e Budget: 2018 YTD
PTR-08(Hollow) $ - $ - Interest $ 1,000 $ 80
PTR-09(Cloverdale) $ - $ - Round Up $ 120 $ 98
PTR-10(East Park) $ 435 $ 12,355 phase 1 design GF Levy $ 20,000 $ 9,421
PTR-11 (West Park) $ - $ - Land Rent $ 2,120 $ 1,060
PTR-12(Trails) $ - $ - Transfer $ - $ -
PTR-13(Trees) $ - $ 1,000 Donations $ 10,000 $ 147
PTR-14(Dog Park) $ 15,504 $ - phase 1 dog park Park Dedic. $ 2,000 $ -
Total $ 23,776 $ 13,618
18 Millstream 5k Expenses: Avail.Rev
$ - $ 3,024
18 Dog Park Donation Budget: 2016/2017/2018
pavers/treats $ 1,149
cash $ 10,000 $ 5,593
thru 9/30/18
City of St. Joseph 10/10/18 3:07 PM
Page 1
Cash Balances Only
Current Period:September 2018
MTD MTD Current
FUND Descr Account Begin Yr Debit Credit Balance
Last Dim 10100
General G 101-10100 $1,835,385.36 $25,994.30 $198,571.80 $1,275,779.19
Employee Retirement Reserve G 102-10100 $115,843.34 $0.00 $0.00 $122,343.34
Fire Fund G 105-10100 $521,806.17 $22,496.52 $5,566.96 $580,095.49
Cable Access Fee G 108-10100 $33,717.49 $599.14 $0.00 $3,333.49
Economic Development G 150-10100 $27,549.20 $22.96 $6,139.90 $17,059.54
TIF 3-1 CMCU G 152-10100 $2,759.65 $8.38 $0.00 $3,541.49
TIF 4-1 Fortitude Senior Apts G 153-10100 $2,136.02 $6.11 $0.00 $1,920.44
TIF 2-1 Millstream G 157-10100 $23,356.90 $26.94 $0.00 $23,470.96
TIF 2-2 Meat Market G 158-10100 $332.52 $0.87 $0.00 $389.23
TIF 2-3 Bayou Blues/Alley Flat G 159-10100 $119.95 $0.07 $0.00 -$1,324.86
State Collected Sales Tax G 200-10100 $961,315.04 $47,741.01 $9,444.19 $1,000,324.53
Park Dedication G 205-10100 $121,019.37 $144.27 $139.00 $113,777.49
Charitable Gambling G 215-10100 $2,084.77 $2.10 $0.00 $2,091.63
Lodging Tax G 220-10100 $20,177.02 $2,646.92 $0.00 $28,917.74
DEED CDAP Grant G 225-10100 $11,126.43 $7,581.03 $0.00 $25,078.77
Revolving Loan Fund G 250-10100 $205,554.66 $211.11 $0.00 $211,235.16
2016 CIP Bonds[govt center] G 301-10100 $17,890.40 $136.94 $0.00 $150,445.85
2017A CIP Bonds[Gov Center] G 303-10100 $55,005.64 $89,464.55 $0.00 $146,207.96
2016 Street Impr[Field St] G 304-10100 $190,459.50 $110.07 $3,147.90 $108,240.97
2017B Impr Bonds[CBD Alleys G 305-10100 $44,961.76 $103.24 $0.00 $56,368.28
2018 Equip Certificates G 306-10100 $0.00 $150.40 $0.00 $5,918.76
2010B Refundin [Hill/Clover] G 333-10100 $108,556.26 $139.19 $0.00 $141,881.48
2011A CO Refund[Interior St] G 338-10100 $100,177.59 $142.99 $136,310.00 $10,927.20
2009B GO CIP Bonds G 343-10100 $10,633.34 $37.02 $0.00 $39,855.83
2010B Street Impr[16th Ave] G 345-10100 $169,832.48 $6,560.60 $6,380.74 $182,416.84
2011A Pumper Truck Certificat G 346-10100 $27.97 $3,405.70 $41,780.00 -$11,971.87
2011A GO CIP Bonds[roof/gar] G 347-10100 $3,319.92 $60,013.48 $81,110.00 -$6,485.47
2013 Street Improve Bonds G 348-10100 $110,704.94 $116.42 $0.00 $116,893.01
2013 Equipment Certificates G 349-10100 $7,044.14 $33.89 $0.00 $36,733.63
2014 Street Impr[ParkTerrace G 350-10100 $249,175.21 $8,339.45 $0.00 $291,765.27
2015 Street[Clinton/Northland] G 351-10100 $146,996.79 $2,690.33 $0.00 $198,034.76
2015 Equipment Certificates G 352-10100 $1,527.89 $73.14 $0.00 $80,717.79
2015 Abatement Bonds[Kenne G 353-10100 $20,204.35 $160.53 $0.00 $159,808.56
Debt Service Relief G 390-10100 $392,280.94 $0.00 $60,000.00 $274,256.58
Community Center phase I G 402-10100 $1,884.67 $2.48 $0.00 $2,467.99
2017 CBD Alley Improve ph 1 G 405-10100 $62,955.96 $0.00 $353.25 $41,388.84
2018 Equip Certificates G 406-10100 $0.00 $0.00 $392.92 $137,806.68
Capital Outlay G 490-10100 $347,121.83 $0.00 $3,386.50 $363,210.77
WAC Fund G 501-10100 $241,291.01 $11,785.54 $0.00 $459,989.24
SAC Fund G 502-10100 $6,318.77 $11,206.30 $0.00 $73,454.99
Water Fund G 601-10100 $670,381.85 $63,919.08 $37,978.26 $774,193.77
Sewer Fund G 602-10100 $2,345.84 $48,299.52 $173,174.90 $126,545.72
Refuse Collection G 603-10100 $257,764.40 $12,292.02 $26,483.08 $235,532.55
Storm Water Utility G 651-10100 $280,964.44 $2,819.50 $5,506.09 $257,617.39
Street Light Utility G 652-10100 $23,576.76 $2,716.24 $4,436.76 $26,394.57
Last Dim 10100 $7,407,688.54 $432,200.35 $800,302.25 $7,888,651.57
Last Dim 10200
General G 101-10200 $275.00 $0.00 $0.00 $275.00
Last Dim 10200 $275.00 $0.00 $0.00 $275.00
City of St. Joseph 10/10/18 3:07 PM
Page 2
Cash Balances Only
Current Period:September 2018
MTD MTD Current
FUND Descr Account Begin Yr Debit Credit Balance
$7,407,963.54 $432,200.35 $800,302.25 $7,888,926.57
Cash and Investment Holdings
860,865 , 11%
' rte
4,201,400, 53% - , l'`-vs
'4f ::-
,-
2,507,836, 32%
u A �
d
Tf Checking
- - } t ' :144,''i-z4,--,f-s-,:2,..4`-
,
;.}. ,,,,,,-,t7;47,-..--
`- ,.r
* Money Market Savings
-� 4 _ -�"` Bank CDs
r. Brokered Money Market
ph " Government Securities
,,4.,,,..",,,t--1,`"",;,:-
-"--.0, Brokered CDs
k
23,911 , 0% , 0%
294,639, 4%
Enterprise Funds Activity
Street Light vimpir $51,999
$48,947
$82,642
Storm Water Ivor
$31,749
i E
Refuse $216,642
I$162,852 ea Expense
N Revenue
Sewer $734,480
______74000.0001000_
$741,568
58
. _ . .,, ... $6202
Water
$598,976
$- $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 $800,000
Storm Water Refuse Sewer Water Street Lights
% Revenue to Expenses 38% 75% 101% 97% 94%
Utilities represents 8 months revenue collected with 9 months expensed.
General & Fire Budget to Actual Expenditures & Revenues
$3,500,000 -
$3,000,000 $2,969,350 $2,975,850
$2,500,000
$2,186,988
$2,000,000
$1,723,472 o Exp Budget
•Exp Actual
$1,500,000 ` - _Rev Budget
o Rev Actual
$1,000,000
$500,000
$346,465 $342,995
$241,508
$130,936
General Fund Fire Fund
City of St. Joseph, Minnesota
Cash Position
As of 9/30/18
Sentry Bank Maturity Date Interest Current Balance #Securities %of Total
Checking Account(Reconciled) N/A 0.15% $ 207,618 N/A
Money Market Savings N/A 0.80% 2,505,126 N/A
Jacob Wetterling Rec Center Savings N/A 0.15% 2,646 N/A
Bank Certificates of Deposit N/A - N/A
averages N/A 1.00%
Total SB $ 2,715,390 34%
Central MN Credit Union
Share Savings Account N/A 0.00% $ 5 N/A
Business Advantage Checking N/A 1.40% 653,247 N/A
Money Market Savings N/A 0.41% 59 N/A
averages N/A 1.40%
Total CMCU $ 653,311 8%
Total Deposits $ 3,368.701
Morgan Stanley
Brokered Money Market Savings N/A 1.69% $ 20,079 N/A
Government Securities/Notes 76 months 2.03% avg 294,639 1
Brokered Certificates of Deposit Tiered 1-61 months 2.12% avg 3,605,100 19
averages 37 months 2.12%,
Total MS $ 3,919,818 50%
PMA 4M-US Bank
Brokered Money Market Savings N/A 1.75% $ 3,832 N/A
Brokered Certificates of Deposit Tiered 10-16 months 2.44% avg 596,300 3
averages 12 months 2.44%
Total 4M $ 600,132 8%
Total Investments $ 4,519,950
2018 YTD
Total Deposits and Investments $ 7,888,651 Interest Earned
Average Interest APY 25 months 2.28`/: $4,145
Total Deposits&Investments $ 7,888,651 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/NCUA or secured by perfected 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. Maturity
Concentration of Credit Risk: The City invests in various instruments and several financial institutions. %Securities Averages
Brokered Money Markets $ 23,911 0.30% N/A
Brokered Certificates of Deposit $ 4,201,400 53.26% 2.65 years
Government Bonds/Notes $ 294,639 3.73% N/A
Foreign Currency Risk: The City only invests in USA and USA territories.
City of St. Joseph
Quarterly Sewer Fund Analysis
As of September 30,2018
Fund 602+502,Sewer/SAC Fund Balance as of December 31,2017(audited) $ 125,815.93
SAC fees collected for:
Year to Date Revenue: 19 single family homes(2 were prepaid hook up fees)
Interest Earnings 1,076.07 Partial 24 College North
Sewer Usage Charge 443,121.92
Sewer Fixed Charge 291,257.26
Penalties/Other Usage Fees 5,765.52
SAC/Trunk Fees 66,846.90
RV Dump Donations 596.75
Transfers from other Funds -
Total Revenue 808,664.42 51.06% budget collected
2018 revenue Budget 1,583,870.00 (includes fund 501)
Year to Date Expenses by Department:
Debt Payments (8,482.00)
Transfers to Other Funds (500.00)
Sewer Maintenance (112,752.07)
Baker Street Lift Station (2,776.64)
Ridgewood Lift Station (1,209.63)
Northland Lift Station (728.42)
CR121 Lift Station (43,377.96)
Main Lift Station (528,191.07)
Sewer Administration (36,461.83)
Total Expenses (734,479.62) 52.15% budget expensed
2018 Expense Budget (1,408,350.00) (excludes depreciation,includes fund
Fund Summary as of September 30,2018:
Sewer Fund Cash Balance-Fund 602+502-unaudited $ 200,000.73
Fund 502 $ 73,454.99
Fund 602 $ 126,545.72
The balances represent the cash balance as of 9/30/18.
City of St.Joseph
Quarterly Water Fund Analysis
As of September 30,2018
Fund 601+501,Water/WAC Fund Balance as of December 31,2017(audited) $ 1,037,196.85
WAC fees collected for:
Year to Date Revenue: 3 sewer only SF home as required by Council
Interest Earnings 1,645.56 19 single family homes(2 were prepaid hook up fees)
Ad Valorem Taxes 11,662.92 Partial 24 College North
Water Usage Charge 354,381.17 Partial Country Manor
Water Fixed Charge 181,586.07
Penalties/Other Usage Fees 6,538.25
WAC/Trunk Fees 216,896.90
Antenna Lease Revenue 25,464.63
Water Meters 15,750.00
Bulk Water Sales 3,319.09
Transfers from other Funds -
Total Revenue 817,244.59 63.79% budget collected
2018 Revenue Budget 1,281,170.00 (includes fund 501)
Year to Date Expenses by Department:
Debt Payments (56,838.06)
Transfers to Other Funds (500.00)
Power and Pumping (2,719.82)
Water Treatment Plant 1 (274,295.68) WTP1 expenses include contract to refurbish
Water Treatment Plant 2 (63,357.97)
Distribution (17,030.57)
Wellhead Protection -
Water Tower (4,520.92)
Water Maintenance (169,078.26)
Water Administration (31,917.15)
Total Expenses (620,258.43) 61.26% budget expensed
2018 Expense Budget (1,012,550.00) (excludes depreciation,includes 501)
Fund Summary as of September 30,2018:
Water Fund Cash Balance-Fund 601+501 -unaudited $ 1,234,183.01
Fund 501 $ 459,989.24
Fund 601 $ 774,193.77
The balances represent the cash balance as of 9/30/18