HomeMy WebLinkAbout[04c] Financial Report
Council Agenda Item 4c
MEETING DATE: April 20, 2020
AGENDA ITEM: Financial Report – 1st Quarter & March 2020 Financial Reports
SUBMITTED BY: Finance
BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N/A
PREVIOUS COUNCIL ACTION: Council adopted the 2020 budget on December 16, 2019.
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
March 31, 2020. The 2019 audit activity has been reversed. BerganKDV plans to present the 2020
audited financial statements in May.
CASH POSITION:
- The market rate of return (ROR) is approximately 2.27% with an average maturity of 32 months.
The City tiers the maturity dates within the boundaries of the Investment Policy. The tiered
maturity dates have 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 and the State money market fund (PMA 4M).
- In the first quarter, the Federal Open Market Committee \[FOMC\] has reduced the targeted federal
fund rate from 1.75% to 0-0.25% due to global markets and the economic impacts of COVID-19.
- Interest earnings for 2020 amounts to a $61,418; 45% of the budgeted amount. 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.
Staff budgets conservatively. The investment holdings will produce earnings; however, it is
unknown what the market valuation impact will be on the City’s portfolio.
- Overall, the cash and investments balance increased $1,266,407 from the beginning of the year.
There remains bond proceeds from the 2019 projects that will complete in 2020. In addition,
MSAS and BDPI reimbursements were received in early 2020. Spending has been slowed down
as we analyze the impact of the emergency shut down.
FUNDS REPORT:
- The General fund spent 8% of the 2020 expenditure budget and received 5% of the revenue
budget. Expenditures and revenues are mainly operational in nature. The largest expenditures
were incurred in ice & snow removal. The bulk of these expenditures are typically incurred in the
first quarter. Engineering costs are near budgeted amounts. The largest cost was incurred for the
th
20 Ave feasibility study. The transfer out of the General fund was made to the Retirement
Reserve Fund 103 as budgeted. The revenues overall are on target through March. The first half
MSAS aid was received. Building permit fees are a bit lower as is typical for the first quarter
(winter months). Staff will monitor revenue collections. It is not known what the impact of the
pandemic will be. Staff anticipates some revenue collections will be lower.
- The Enterprise Funds represent two months utility billing revenue collected while expenses
represent three months. Overall, 10% of expenses have been incurred (less depreciation); 5% of
the revenue budget has been received. Revenues and expenses are general in nature.
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 City collected $10,725
WAC/Trunk fees in 2020; a payment from Bayou Blues per their development agreement. Water
revenues represent 7%, expenses 9% of the budget at the end of March. Other revenues and expenses are
operational in nature.
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). As with water, a SAC payment
from Bayou Blues per their development agreement was received. Sewer expenses are at 7% of the
budget, while revenues are at 5% of the budget. The revenues/expenses are operational in nature.
st
½ ¢ Sales Tax (fund 200): The sales tax fund has a cash balance of $831,225 on March 31. The City
anticipates collecting $457,500 in sales tax revenue in 2020; $41,000 less than what was received in 2019.
Staff budgets conservatively for the revenue collections. With the current pandemic shutting down the
economy, collections will likely decrease. The area Finance Directors will meet soon to review the
formula allocation. St. Joseph should get a larger portion with the addition of the annexed population.
Current projects using local option sales tax funding are the completion of the CR2 trail project and bond
payments towards Field Street and the Colts Academy purchase. Other potential projects are completing
phase I of the East Park development and the Jacob Wetterling Rec Center. State bonding requests remain
in discussions at the State.
The Sales Tax Summary report shows all revenues recorded and projects expensed from Fund 200. The
projects are split to show the projects completed, the projects in progress, and the projects reviewed, but
not moved forward at this time. After the anticipated revenue collections through 2038, $4.6M remains
uncommitted. The available annual sales tax revenue after bonded commitments is $272,335. The East
Park and CSAH 2 Trail projects will be paid for with cash out of the fund. The CSAH 2 Trail project
received $650,594 in federal grant proceeds in 2019. The trail project will finish in 2020.
The sales tax revenue represents sales taxes collected through 2019. There is a 2-3 months lag for the
State to collect and remit to the communities. The first portion of 2020 collections goes to the regional
agreed upon projects.
Visitor’s Bureau: I included the fund summary for the lodging tax/CVB that the EDA reviews. The
CVB is very active and successfully marketing the City and providing opportunities for people to visit St.
Joseph. The City collects roughly $15,000 in lodging taxes annually. The CVB submits budget requests
to the EDA. The current budget is just over $14,000. The CVB/EDA will monitor collections as they are
expected to drop with the Emergency declaration.
CIP REPORTS:
- General capital equipment purchases include laptops for working remotely, street sweeper, lawn
mowers and rifles. Computer upgrades were completed in January. Many systems were
Windows 7 or less. The cost to upgrade Windows on the older machines was higher than
replacing the machines. A couple systems had Windows 8; one was moved to the water plant, the
other will be used as a spare.
th
- Engineering expenses incurred relating to the 20 Ave street improvement feasibility study,
Minnesota Steetscape feasibility study and review of the Sand Properties plat.
BUDGET/FISCAL IMPACT: Information Only
ATTACHMENTS: Request for Council Action – Quarterly and March Financial Reports
1st Quarter Reports:
Cash Position as of 3/31/20
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
CVB Summary
March 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
Enterprise Capital Improvement Plan – Public Works
Capital Improvement Budget Summary – Park Board
REQUESTED COUNCIL ACTION: Consider accepting the 1st quarter and March 2020 financial
reports.