HomeMy WebLinkAbout[04c] Treasurer Report
4(c)
Council Agenda Item
MEETING DATE:
January 17, 2013
th
AGENDA ITEM:
Financial Report – Requested Action: Accept the 4 Quarter 2012 and
December 2012 Financial Reports
SUBMITTED BY:
Finance
BOARD/COMMISSION/COMMITTEE RECOMMENDATION:
N/A
PREVIOUS COUNCIL ACTION:
Council accepted the October and November 2012 Financial
Reports.
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
December 31, 2012. The final year-end report with accruals recorded will be presented in the audited
financial statements in May.
There are a couple points to highlight from the reports.
CASH POSITION
:
- The market rate of return is approximately 2.13%, higher than the 10-year Treasury Notes. I
attended a seminar in November with a panel of other MN cities discussing the rate of return on
their portfolios. St. Joseph is higher than many other large and small cities investing funds. Even
St. Paul was about the same rate of return as St. Joseph. Securities available just do not have a
high rate of return in today’s economy. It will likely be a couple years with lower rates yet. St.
Joseph if fortunate to have local financial institutions paying a higher rate of return on money
market funds. The bulk of the City’s cash is held locally. This is also positive for our financial
institutions.
- Overall, the cash and investments balance decreased $1,691,801 from the beginning of the year.
The cash decreased due to no project bonds issued as in previous years. The bonds funds have
been further spent down on capital purchases projected for the bond funds. In addition, the City
opted to use ½ cent sales tax money to fund trail projects. This is an expense that was much
lower in previous years when the sales tax received was invested for future use.
- The cash position represents 0.8 months of the year’s expenditures.
FUNDS REPORT
:
General fund
- The spent 103% of the 2012 budget and received 105% of the revenue budget.
Revenues that came in higher than budgeted include building permit and development revenue,
contributions and donations, interest earnings, cooperative dividends, and reimbursements.
Expenditures higher than budgeted include city hall operating expenses and transferring the CIP
budget to the Capital Outlay fund 490. There were a couple capital expenditures made from the
General fund that were budgeted in previous years (seal coating, elections and facility planning).
Enterprise Funds
- The show expenses more than revenues with exception of the storm water
fund. I show 11.5 months of expenses recorded with 10 months utility revenue received. The
expenses are not shown at 12 months due to year-end accruals not recorded. The Nov/Dec utility
usage was just billed in January.
Water fund analysis (fund 601/501)
– The enclosed spreadsheet shows an analysis of the Water fund for
2012. Included in the spreadsheet are the Water fund (601) and the Water Access fund (WAC-501). The
water connection activity for 2012 has been good considering the US economic conditions. The City
received $67,698.44 in WAC and Trunk fees this year. The connection fees include completion of a
River’s Bend patio home deferred payment, seven new homes, Laundromat deferred monthly payments,
Precise Refrigeration addition, church addition and McDonald’s.
The water fund does show a cash deficit of $103,000 at the end of December. Much of the fund deficit
will be covered by the Nov/Dec utility payments once accruals are recorded. However, the cash deficit
must be covered by another fund for the financial statements. I will present options at a future meeting
once year end entries are recorded. The cash deficit was anticipated in the rate projections.
½ ¢ Sales Tax (fund 200):
The sales tax fund has a balance of $1,215,123 at the end of December before
accrual adjustments. The City anticipates collecting $3,000,000 in sales tax revenue through 2017;
$1,762,378 collected to date. The anticipated expenditures approved by Council totals $906,974 leaving
approximately $2,093,026 remaining for future projects. I added a line of $1,000,000 for the community
center. This is just a representation that the Council is still looking at options for a community center, but
nothing is decided right now. The number is just a place holder in the report.
CIP REPORTS:
st
- The 2012 CIP summary is included to show the capital expenditures through December 31. The
capital expenditures include a fire department 6-wheeler, pumper truck, rescue van, water
softener and turnout gear. Police and administration computers, sewer root control, seal coating,
facilities study, Northland Park phase III playground equipment, a mower, scoreboard, and EDA
budgeted programs were other capital expenditures.
BUDGET/FISCAL IMPACT:
Information Only
ATTACHMENTS:
Request for Council Action – Quarterly and December Financial Reports
th
4 Quarter Reports:
Cash Position as of 12/31/12
Cash and Investment Holdings Chart
Cash Balances by Fund/Remaining Budget
General Budget to Actual Revenue Graph
General Budget to Actual Expenditures Graph
Enterprise Funds Activity Graph
Quarterly Water Fund Analysis
½ ¢ Sales Tax Fund Summary
December 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 Summary Reports:
General Fund Capital Improvement Plan – Summary
Fire Fund Capital Improvement Plan
Park Board Capital Improvement Plan – Summary
Capital Improvement Plan – Enterprise
REQUESTED COUNCIL ACTION:
Accept the financial reports as presented.
City of St. Joseph, Minnesota
Cash Position
As of 12/31/12
Sentry BankMaturity DateInterestCurrent Balance# Securities% of Total
Checking Account (Reconciled)N/A0.15%315,231$ N/A
Money Market SavingsN/A0.65%2,799,423 N/A
Bank Certificates of DepositTiered 1-22 months2.00%avg 3850,000
averages12 months1.36%
$3,964,653
Total Sentry Bank
53%
Central MN Credit Union
Share Savings AccountN/A0.50%30$ N/A
Money Market SavingsN/A0.85%247,221 N/A
Power Money Market CheckingN/A0.90%1,070,275 N/A
Jumbo Bank Certificates of Deposit12 months4.45%avg 1248,678
averages12 months2.07%
$1,566,204
Total CMCU
21%
Total Deposits5,530,858$
Morgan Stanley Smith Barne
y
Brokered Money Market SavingsN/A0.01%9,752$ N/A
Government Securities/NotesN/A0.00%avg 0-
Brokered Certificates of DepositTiered 1-45 months2.97%avg 151,908,358
averages24 months2.97%
Total SB
$ 26%1,918,110
Northland Securities
Brokered Money Market SavingsN/A0.00%1,832$ N/A
Brokered Certificates of DepositN/AN/Aavg 0-
averages0.00%
N/A
Total NS
$ 0%1,832
Total Investments1,919,942$
Total Deposits and Investments$7,450,800
Average Interest APY16 months2.13%
2012 YTD
Cash Held With Fiscal Agent - Northland SecuritiesInterest Earned
(2011A/2012A Crossover Refunding Bonds)
$228,400
Brokered Money Market SavingsN/A0.39%avg 6,223,611
Total Cash Held With Fiscal Agent$6,223,611
Total Deposits, Investments & Cash w/Fiscal Agent
$ Cash and Investment Balance13,674,411
Petty Cash
AdministrationN/AN/A200$
Police DepartmentN/AN/A75
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.
% SecuritiesAverages
Brokered Money Markets11,585$ 0%N/A
Brokered Certificates of Deposit1,908,358$ 25.61%2 years
Government Bonds/Notes-$ 0.00%N/A
State/Local Government Securities-$ 0%N/A
Foreign Currency Risk: The City only invests in USA and USA territories.
01/14/13 8:33 AM
CITY OF ST JOSEPH
Page 1
Cash Balances Only
Current Period: December 2012
MTDMTDCurrent
FUND DescrAccountBegin YrDebitCreditBalance
Last Dim 10100
GeneralG 101-10100$1,096,812.16$970,720.25$223,783.16$1,130,055.69
Fire FundG 105-10100$625,739.17$38,494.30$135,503.14$512,371.42
Cable Access FeeG 108-10100-$1,237.61$411.00$0.00$7,978.69
Economic DevelopmentG 150-10100$51,328.42$35,370.59$54,369.10$79,292.86
TIF 1-4 St. Joe DevelopmentG 156-10100$17.95$30,600.89$31,430.34$0.00
TIF 2-1 MillstreamG 157-10100$8,443.84$13,614.00$12,239.75$10,776.04
TIF 2-2 Meat MarketG 158-10100$3.26$0.00$0.00-$169.98
State Collected Sales TaxG 200-10100$1,240,510.91$60,242.19$127,880.85$1,215,122.64
Park DedicationG 205-10100$72,835.88$204.07$144.28$70,387.96
Recreation CenterG 210-10100$52,273.94$92.97$0.00$27,101.13
Charitable GamblingG 215-10100$5,092.24$14.38$0.00$5,202.07
Revolving Loan FundG 250-10100$14,158.07$732.33$0.00$22,611.85
2009A CrossoverRefunding BonG 318-10100$489,013.10$85,993.98$0.00$431,879.51
2007 Refunding (98/99 St BonG 320-10100$269,082.34$36,338.71$0.00$196,203.42
City Hall Refunded, 2005G 322-10100$5,442.91$46,883.05$0.00$772.18
2011A Refunding Fire HallG 331-10100$126,537.01$15,884.56$0.00$118,682.65
2005 Improve (Hill/Clover)G 333-10100$452,837.96$31,172.89$0.00$378,485.07
2006 Interior St ImprovementsG 338-10100$276,886.58$59,205.77$0.00$245,992.97
2007 St Imprv-E Side/Jade/8 AG 341-10100$271,757.08$193,586.43$0.00$137,082.37
2008 Equipment CertificatesG 342-10100$8,944.04$33,399.35$0.00$12,104.02
2009B GO CIP BondsG 343-10100$3,825.31$33,272.49$0.00$4,212.26
2010 Equipment CertificatesG 344-10100$1,247.83$17,069.14$0.00$2,360.93
2010B Street Impr (16th Ave)G 345-10100$235,563.66$18,139.20$0.00$243,975.56
2011A Pumper Truck CertificatG 346-10100$4,196.58$7,323.03$0.00$8,272.87
2011A GO CIP BondsG 347-10100$5,603.83$12,821.58$0.00$20,948.21
Debt Service ReliefG 390-10100$339,854.04$1,677.08$0.00$355,610.22
Northland Heights/Trans CorridG 435-10100$274,071.30$0.00$32.75$249,853.54
2007 Street Impr (Jade Rd/EG 441-10100$365,338.49$0.00$0.00$366,958.57
2011A Pumper Truck CertificatG 446-10100$383,405.58$0.00$0.00$0.00
2011A GO CIP BondsG 447-10100$173,332.63$0.00$0.00$174,042.45
Capital OutlayG 490-10100$222,287.15$2,000.00$4,283.33$219,954.43
Water ExtensionG 501-10100$735.86$92.63$0.00$14,055.15
Sewer ExtensionG 502-10100$723,179.50$1,918.71$0.00$561,689.84
Water FundG 601-10100$237,621.48$86,065.50$33,481.76-$103,190.79
Sewer FundG 602-10100$672,223.82$74,648.85$113,391.94$273,759.83
Refuse CollectionG 603-10100$258,434.00$35,003.84$23,893.52$265,564.38
Storm Water UtilityG 651-10100$175,200.83$14,338.02$3,501.64$190,800.25
Street Light UtilityG 652-10100$0.00$0.00$0.00$0.00
Last Dim 10100$9,142,601.14$1,957,331.78$763,935.56$7,450,800.26
Last Dim 10200
GeneralG 101-10200$275.00$0.00$0.00$275.00
Last Dim 10200$275.00$0.00$0.00$275.00
Last Dim 10300
2005 Improve (Hill/Clover)G 333-10300$1,002,063.22$2,384.45$0.00$0.00
2006 Interior St ImprovementsG 338-10300$1,468,731.57$0.00$7,116.46$1,452,878.26
Water FundG 601-10300$0.00$12,595.98$0.00$4,770,732.87
Last Dim 10300$2,470,794.79$14,980.43$7,116.46$6,223,611.13
$11,613,670.93$1,972,312.21$771,052.02$13,674,686.39
01/09/13 12:12 PM
CITY OF ST JOSEPH
Page 1
Council Month End Revenue Summary
Current Period: December 2012
2012December2012
FUNDFUND DescrYTD Budget2012 AmtYTD Amt
101General$2,183,300.00$943,789.28$2,266,643.28
105Fire Fund$247,445.00$38,334.53$349,403.72
108Cable Access Fee$0.00$411.00$8,325.13
150Economic Development$70,725.00$34,860.59$120,323.37
156TIF 1-4 St. Joe Development$0.00$30,600.89$61,203.74
157TIF 2-1 Millstream$0.00$13,614.00$37,628.60
158TIF 2-2 Meat Market$0.00$0.00$0.00
200State Collected Sales Tax$0.00$60,242.19$247,268.54
205Park Dedication$0.00$204.07$30,973.70
210Recreation Center$0.00$92.97$951.96
215Charitable Gambling$0.00$14.38$101.81
250Revolving Loan Fund$8,380.00$732.33$8,419.83
3182009A CrossoverRefunding Bonds$308,525.00$85,993.98$305,187.59
3202007 Refunding (98/99 St Bond)$90,980.00$36,338.71$87,114.28
322City Hall Refunded, 2005$94,190.00$46,883.05$94,174.45
3312011A Refunding Fire Hall$67,390.00$15,884.56$70,061.64
3332005 Improve (Hill/Clover)$114,080.00$33,557.34$78,566.36
3382006 Interior St Improvements$180,425.00$52,089.31$156,967.34
3412007 St Imprv-E Side/Jade/8 Av$554,080.00$193,586.43$397,469.69
3422008 Equipment Certificates$67,165.00$33,399.35$67,196.80
3432009B GO CIP Bonds$66,800.00$33,272.49$66,849.26
3442010 Equipment Certificates$34,500.00$17,069.14$34,340.13
3452010B Street Impr (16th Ave)$59,005.00$18,139.20$53,125.12
3462011A Pumper Truck Certificate$32,455.00$7,323.03$46,667.43
3472011A GO CIP Bonds$60,350.00$12,821.58$34,123.83
390Debt Service Relief$0.00$1,677.08$14,732.44
4462011A Pumper Truck Certificate$0.00$0.00$0.00
4472011A GO CIP Bonds$0.00$0.00$0.00
490Capital Outlay$0.00$2,000.00$28,304.49
501Water Extension$567,535.00$92.63$68,248.39
502Sewer Extension$250,300.00$1,918.71$49,328.68
601Water Fund$1,023,760.00$96,677.23$5,572,271.14
602Sewer Fund$531,475.00$74,210.32$564,690.30
603Refuse Collection$303,150.00$33,606.14$246,002.13
651Storm Water Utility$109,875.00$14,338.02$87,736.95
652Street Light Utility$0.00$0.00$0.00
$7,025,890.00$1,933,774.53$11,254,402.12
01/09/13 12:12 PM
CITY OF ST JOSEPH
Page 1
Council Month End Revenue -General Fund
Current Period: December 2012
2012December2012
FUNDFUND DescrSOURCE DescrYTD Budget2012 AmtYTD Amt
FUND 101 General
101GeneralCurrent Ad Valorem Taxes$1,092,685.00$546,952.81$1,096,180.52
101GeneralSpecial Levy- City St. Joe$0.00$206.93$560.19
101GeneralState Sales Tax$0.00$14.73$10.96
101GeneralGas Franchise$32,500.00$0.00$19,664.94
101GeneralElectric Franchise$50,000.00$1,758.58$41,183.59
101GeneralBeer$450.00$150.00$150.00
101GeneralLiquor$19,760.00$480.00$15,314.99
101GeneralOutdoor Liquor Permit$2,500.00$0.00$1,500.00
101GeneralGambling Permits$100.00$0.00$170.00
101GeneralAmusement/Hunting Permit$840.00$810.00$810.00
101GeneralExcavation Permit$200.00$0.00$400.00
101GeneralCigarette License$525.00$525.00$525.00
101GeneralCable Franchise Fee$27,000.00$1,297.29$25,798.91
101GeneralBuilding Permits$40,000.00$4,937.61$75,008.64
101GeneralAnimal License$3,150.00$55.00$3,160.00
101GeneralRental Housing Registration$19,000.00$1,227.50$22,008.00
101GeneralFederal Grants - Other$5,000.00$2,061.46$6,995.28
101GeneralState Grants and Aids$965.00$1,109.59$2,024.59
101GeneralLocal Government Aid$645,150.00$322,575.50$645,151.00
101GeneralPERA Rate Increase Aid$1,540.00$770.50$1,541.00
101GeneralPolice Training Reim$3,500.00$0.00$2,656.72
101GeneralState Municipal Funds Aid$6,200.00$0.00$6,180.00
101GeneralState Police Aid$50,000.00$0.00$45,308.00
101GeneralOther Grants/Aids$0.00$0.00$249.90
101GeneralOther Governmental Unit$10,000.00$0.00$10,000.00
101GeneralCounty Grants - Road Maint.$7,750.00$0.00$0.00
101GeneralZoning and Subdivision Fee$1,000.00$0.00$400.00
101GeneralLand Use Deposit Fee$4,000.00$5,350.00$24,350.00
101GeneralSale of Maps and Publications$75.00$3.00$138.90
101GeneralAssessments Search$2,500.00$300.00$2,940.00
101GeneralSpecial Hearing$4,500.00$400.00$4,365.00
101GeneralAdministration Reimb$11,350.00$0.00$4,985.93
101GeneralWeed Cutting$1,000.00$0.00$450.00
101GeneralPark Fees$4,750.00$0.00$6,522.98
101GeneralBall Field Donation$0.00$0.00$13,630.34
101GeneralSchneider Field Rental$0.00$0.00$2,845.00
101GeneralKennel Fees$500.00$42.00$445.00
101GeneralCounty Fines$30,000.00$1,171.79$21,688.92
101GeneralPolicy Fines$35,000.00$2,335.00$35,120.00
101GeneralAccident Report Fee$1,000.00$90.25$939.50
101GeneralSeized Property$500.00$0.00$3,565.00
101GeneralSpecial Assessments$2,000.00$546.36$845.15
01/09/13 12:12 PM
CITY OF ST JOSEPH
Page 2
Council Month End Revenue -General Fund
Current Period: December 2012
2012December2012
FUNDFUND DescrSOURCE DescrYTD Budget2012 AmtYTD Amt
101GeneralInterest Earnings$13,000.00$2,144.94$18,555.87
101GeneralInterest Charges$100.00$0.00-$48.54
101GeneralCo-op Dividend - LMCIT$6,000.00$17,361.52$27,085.58
101GeneralWater Tower Antenna Lease$3,325.00$1,593.27$4,684.05
101GeneralLand Rental$0.00$0.00$0.00
101GeneralAdvertising$7,000.00$0.00$1,300.00
101GeneralContributions - General$1,500.00$0.00$870.09
101GeneralContribution - Health Ins Div$10,485.00$0.00$9,083.71
101GeneralContributions-Holiday Lights$1,000.00$0.00$1,000.00
101GeneralContributions - Parks$800.00$0.00$2,067.67
101GeneralSurplus Property$0.00$500.00$2,000.00
101GeneralReimbursement$23,100.00$27,018.65$54,260.90
101GeneralStreet Access Fee$0.00$0.00$0.00
101GeneralTransfers from Other Funds$0.00$0.00$0.00
FUND 101 General$2,183,300.00$943,789.28$2,266,643.28
FUND 108 Cable Access Fee
108Cable Access FeeCable Franchise Fee$0.00$411.00$7,426.58
108Cable Access FeeTransfers from Other Funds$0.00$0.00$898.55
FUND 108 Cable Access Fee$0.00$411.00$8,325.13
FUND 150 Economic Development
150Economic DevelopmentCurrent Ad Valorem Taxes$70,500.00$34,668.73$69,282.86
150Economic DevelopmentTIF/MIF Deposit$0.00$0.00$0.00
150Economic DevelopmentDEED Housing Reimbursement$0.00$0.00$0.00
150Economic DevelopmentInterest Earnings$225.00$191.86$1,040.51
150Economic DevelopmentTransfers from Other Funds$0.00$0.00$50,000.00
FUND 150 Economic Development$70,725.00$34,860.59$120,323.37
$2,254,025.00$979,060.87$2,395,291.78
01/09/13 12:14 PM
CITY OF ST JOSEPH
Page 1
Council Month End Revenue -Enterprise Funds
Current Period: December 2012
FUND2012December2012
FUNDDescrSOURCE DescrYTD Budget2012 AmtYTD Amt
FUND 601 Water Fund
601Water FundWater Meter$5,000.00$0.00$11,875.00
601Water FundState Sales Tax$300.00-$238.10-$486.10
601Water FundBond Premium Proceeds$0.00$0.00$53,112.65
601Water FundGeneral Oblig. Bond Proceeds$0.00$0.00$4,860,000.00
601Water FundTransfers from Other Funds$381,000.00$0.00$55,000.00
601Water FundContributed Revenue$0.00$0.00$0.00
601Water FundMDS Test Fee$11,000.00$1,225.26$8,869.53
601Water FundInspection Fees$0.00$0.00$0.00
601Water FundPenalties and Forfeited Disc$6,500.00$635.03$6,797.23
601Water FundConnection/Reconnection fees$300.00$0.00$60.00
601Water FundWater Tower Antenna Lease$30,310.00$1,216.57$29,034.03
601Water FundSpecial Assessments$1,100.00$0.00-$10,299.24
601Water FundWater Line Charge$151,000.00$17,600.21$124,351.94
601Water FundAmortization of Bond Premium$0.00$0.00$0.00
601Water FundUndesignated Funds$250.00$1,593.28$57.76
601Water FundSurplus Property$0.00$0.00$15.00
601Water FundReimbursement$0.00$0.00$0.00
601Water FundRate Class One$405,500.00$57,871.19$384,443.20
601Water FundBulk Water$1,500.00$0.00$1,214.59
601Water FundInterest Earnings$30,000.00$16,773.79$48,225.55
FUND 601 Water Fund$1,023,760.00$96,677.23$5,572,271.14
FUND 602 Sewer Fund
602Sewer FundContributed Revenue$0.00$0.00$0.00
602Sewer FundSanitary Sewer Service$342,600.00$50,731.55$289,972.74
602Sewer FundFederal Grants - Other$0.00$0.00$0.00
602Sewer FundSpecial Assessments$500.00$139.26-$21.99
602Sewer FundInterest Earnings$8,500.00$661.56$8,655.22
602Sewer FundAmortization of Bond Premium$0.00$0.00$0.00
602Sewer FundSurplus Property$0.00$0.00$0.00
602Sewer FundSt. Benedict Sewer Charges$0.00$0.00-$77,984.70
602Sewer FundSt. Benedict s SCAWAC fees$0.00$0.00$0.01
602Sewer FundPenalties and Forfeited Disc$4,740.00$382.49$4,543.03
602Sewer FundSewer Line Charge$171,135.00$22,295.46$137,845.99
602Sewer FundSewer Inspection Fee$0.00$0.00$0.00
602Sewer FundTransfers from Other Funds$0.00$0.00$196,900.00
602Sewer FundGeneral Oblig. Bond Proceeds$0.00$0.00$0.00
602Sewer FundBond Premium Proceeds$0.00$0.00$0.00
602Sewer FundReimbursement$4,000.00$0.00$4,780.00
FUND 602 Sewer Fund$531,475.00$74,210.32$564,690.30
FUND 603 Refuse Collection
603Refuse CollectPenalties and Forfeifted Disc$5,500.00$402.66$5,860.24
603Refuse CollectContributions - General$250.00$0.00$945.00
603Refuse CollectSpecial Assessments$500.00$426.84$142.13
603Refuse CollectRefuse Collection Charges$275,800.00$30,485.32$219,778.08
603Refuse CollectLicenses & Permits$17,600.00$0.00$15,080.00
603Refuse CollectState Sales Tax$0.00$1,563.78-$984.98
603Refuse CollectInterest Earnings$3,500.00$727.54$5,181.66
FUND 603 Refuse Collection$303,150.00$33,606.14$246,002.13
FUND 651 Storm Water Utility
651Storm Water Special Assessments$200.00$2,395.15$2,060.30
01/09/13 12:14 PM
CITY OF ST JOSEPH
Page 2
Council Month End Revenue -Enterprise Funds
Current Period: December 2012
FUND2012December2012
FUNDDescrSOURCE DescrYTD Budget2012 AmtYTD Amt
651Storm Water Interest Earnings$5,200.00$554.95$3,809.22
651Storm Water Reimbursement$0.00$0.00$0.00
651Storm Water Contributed Revenue$0.00$0.00$0.00
651Storm Water Development Fee$4,000.00$0.00$0.00
651Storm Water Rate Class One$98,750.00$11,278.08$80,270.09
651Storm Water Penalties and Forfeifted Disc$1,725.00$109.84$1,597.34
651Storm Water Transfers from Other Funds$0.00$0.00$0.00
FUND 651 Storm Water Utility$109,875.00$14,338.02$87,736.95
FUND 652 Street Light Utility
652Street Light UPenalties and Forfeited Disc$0.00$0.00$0.00
652Street Light UInterest Earnings$0.00$0.00$0.00
652Street Light URate Class One$0.00$0.00$0.00
FUND 652 Street Light Utility$0.00$0.00$0.00
$1,968,260.00$218,831.71$6,470,700.52
01/09/13 12:14 PM
CITY OF ST JOSEPH
Page 1
Council Month End Expenditure - Summary
Current Period: December 2012
2012December2012
DescriptionYTD Budget2012 Amt YTD Amt
General$2,160,730.00$200,869.71$2,215,094.29
Fire Fund$284,445.00$135,343.37$463,227.44
Cable Access Fee$0.00$0.00$0.00
Economic Development$70,725.00$53,859.10$90,313.00
TIF 1-4 St. Joe Development$0.00$31,430.34$59,262.06
TIF 2-1 Millstream$0.00$12,239.75$34,064.00
TIF 2-2 Meat Market$0.00$0.00$173.24
State Collected Sales Tax$0.00$127,880.85$329,758.54
Park Dedication$49,400.00$144.28$33,345.76
Recreation Center$0.00$0.00$25,588.72
Charitable Gambling$0.00$0.00$0.00
Revolving Loan Fund$0.00$0.00$0.00
2009A CrossoverRefunding Bon$363,790.00$0.00$363,787.50
2007 Refunding (98/99 St Bond$166,345.00$0.00$166,770.00
City Hall Refunded, 2005$98,645.00$0.00$99,067.50
2011A Refunding Fire Hall$79,885.00$0.00$77,883.33
2005 Improve (Hill/Clover)$150,195.00$0.00$1,157,042.50
2006 Interior St Improvements$216,770.00$0.00$236,596.26
2007 St Imprv-E Side/Jade/8 A$534,070.00$0.00$534,068.76
2008 Equipment Certificates$64,200.00$0.00$64,200.00
2009B GO CIP Bonds$66,185.00$0.00$66,610.00
2010 Equipment Certificates$33,300.00$0.00$33,300.00
2010B Street Impr (16th Ave)$63,455.00$0.00$53,096.21
2011A Pumper Truck Certificate$44,960.00$0.00$42,388.33
2011A GO CIP Bonds$18,685.00$0.00$18,685.00
Debt Service Relief$0.00$0.00$0.00
Northland Heights/Trans Corrid$0.00$32.75$23,171.51
2007 Street Impr (Jade Rd/E$0.00$0.00$1,156.54
2010A Equip Certificates$0.00$0.00$0.00
2011A Pumper Truck Certificate$0.00$0.00$383,405.58
2011A GO CIP Bonds$0.00$0.00$0.00
Capital Outlay$185,020.00$4,283.33$29,679.28
Water Extension$0.00$0.00$55,000.00
Sewer Extension$0.00$0.00$211,900.00
Water Fund$1,488,195.00$31,497.51$1,133,596.14
Sewer Fund$1,223,175.00$112,953.41$770,080.13
Refuse Collection$316,875.00$22,495.82$264,495.52
Storm Water Utility$239,175.00$3,501.64$81,815.41
Street Light Utility$0.00$0.00$0.00
$7,918,225.00$736,531.86$9,118,622.55
01/09/13 12:17 PM
CITY OF ST JOSEPH
Page 1
Council Month End Expense - Enterprise Funds
Current Period: December 2012
2012December2012
DescriptionDEPART DescrYTD Budget2012 Amt YTD Amt
FUND 601 Water Fund
Water FundBond Payment (P & I)$665,730.00$0.00$800,641.26
Water FundOther Financing Uses$50,000.00$0.00$48,000.00
Water FundPower and Pumping$35,400.00$465.74$4,712.39
Water FundPurification-Plant 1$29,310.00$3,231.35$22,422.99
Water FundPurification-Plant 2$80,155.00$5,740.77$69,330.05
Water FundDistribution$22,000.00$773.01$28,584.90
Water FundWellhead Protection$2,000.00$0.00$97.56
Water FundStorage-Tower 1$5,950.00$535.62$3,258.99
Water FundStorage-Tower 2$0.00$0.00$0.00
Water FundWater Maintenance$200,355.00$18,622.53$134,764.19
Water FundAdministration and General$37,295.00$2,128.49$21,783.81
Water FundDepreciation Expense$360,000.00$0.00$0.00
FUND 601 Water Fund$1,488,195.00$31,497.51$1,133,596.14
FUND 602 Sewer Fund
Sewer FundBond Payment (P & I)$71,695.00$0.00$25,568.50
Sewer FundOther Financing Uses$55,000.00$0.00$48,000.00
Sewer FundSanitary Sewer Maintenanc$203,515.00$11,597.53$99,026.11
Sewer FundLift Station-Baker Street$3,095.00$188.61$10,573.48
Sewer FundLift Station-DBL Labs Area$2,720.00$395.36$3,549.57
Sewer FundLift Station-Northland$2,575.00$117.06$3,977.90
Sewer FundLift Station-CR 121$2,725.00$428.12$2,987.99
Sewer FundLift Station-Main$623,050.00$96,876.14$549,947.36
Sewer FundAdministration and General$43,800.00$3,350.59$26,449.22
Sewer FundDepreciation Expense$215,000.00$0.00$0.00
FUND 602 Sewer Fund$1,223,175.00$112,953.41$770,080.13
FUND 603 Refuse Collection
Refuse CollectioWaste Collection$316,875.00$22,495.82$264,495.52
Refuse CollectioOther Financing Uses$0.00$0.00$0.00
FUND 603 Refuse Collection$316,875.00$22,495.82$264,495.52
FUND 651 Storm Water Utility
Storm Water UtiOther Financing Uses$57,325.00$0.00$21,250.00
Storm Water UtiAdministration and General$13,875.00$761.67$9,223.86
Storm Water UtiStorm Water Maintenance$72,975.00$2,739.97$51,341.55
Storm Water UtiDepreciation Expense$95,000.00$0.00$0.00
FUND 651 Storm Water Utility$239,175.00$3,501.64$81,815.41
FUND 652 Street Light Utility
Street Light UtiliStreet Lighting$0.00$0.00$0.00
FUND 652 Street Light Utility$0.00$0.00$0.00
$3,267,420.00$170,448.38$2,249,987.20
City of St. Joseph Park Board
Capital Improvement Budget Summary
2012 Approved Capital Budget
as of December 31, 2012
General Funds
Balance
Park Dedication Cash December 31, 201270,388$
(Unaudited)
Adjustments
Starting Balance70,388$
Potential Projects:
PotentialProposed
Army Reserve Center
Millstream Villages, phase 223,400$
Herges - 150 Acres348,750$
Feld Residential348,750$
St. Wendel Farm - 350 Acres813,750$
Ending Balance for 201270,388$
Projects - Budget
201120122013201420152016Total 12-16
PTR-01 (Millstream)5,000$ -$ -$ 25,000$ -$ -$ 25,000$
PTR-02 (Northland)-$ 25,000$ -$ -$ -$ -$ 25,000$
PTR-03 (Klinefelter)-$ -$ -$ -$ -$ -$ -$
PTR-04 (Wobegon)-$ -$ -$ -$ -$ -$ -$
PTR-05 (Memorial)-$ 7,500$ -$ -$ -$ -$ 7,500$
$ --$ -$ -$ -$ -$ -$
PTR-06 (Centennial)
$ 400300$ 400$ 400$ 400$ 400$ 2,000$
PTR-07 (Monument)
PTR-08 (Hollow)-$ -$ -$ -$ -$ -$ -$
$ 5005,000$ 25,000$ -$ -$ -$ 25,500$
PTR-09 (Cloverdale)
PTR-10 (East Park)-$ -$ -$ -$ -$ -$ -$
PTR-11 (West Park)-$ -$ -$ -$ -$ -$ -$
$ 10,000-$ 10,000$ 10,000$ 10,000$ 10,000$ 50,000$
PTR-12 (Trails)
Total10,300$ 43,400$ 35,400$ 35,400$ 10,400$ 10,400$ 135,000$
Projects - ActualSpent 20112012
PTR-01 (Millstream)-$
PTR-02 (Northland)-$ (24,003)$ Phase III equip
Other 12 Expenses:2011 Actual
PTR-03 (Klinefelter)-$ -$
PTR-04 (Wobegon)-$ -$ A-1 Toilets1,456$ 1,786$
PTR-05 (Memorial)-$ (7,500)$ scoreboard
2012 Revenue:2011 Actual
PTR-06 (Centennial)-$ -$
PTR-07 (Monument)(139)$ (87)$ flowersInterest1,555$ 749$
PTR-08 (Hollow)-$ -$ GF Transfer6,000$ -$
PTR-09 (Cloverdale)-$ (300)$ Master PlanRound Up113$ -$
PTR-10 (East Park)-$ -$ Park Dedic.23,400$ 39,046$
PTR-11 (West Park)-$ -$
PTR-12 (Trails)-$ -$
Total(139)$ (31,890)$
This page intentionally left blank