CITY OF CHARLOTTESVILLE, VIRGINIA CITY COUNCIL AGENDA Agenda Date: November 14, 2020 Action Required: Report to Council Presenter: John Blair, Acting City Manager Ryan Davidson, Senior Budget and Management Analyst Staff Contacts: Ryan Davidson, Senior Budget and Management Analyst Title: City Financial Snapshot Report for October 2020 Background: Through discussions with the City Council, the City Manager has arranged to provide periodic financial reports. These reports will be provided on a monthly basis, at the second regular Council meeting of each month. Discussion: The attached report provides a financial snapshot of the General Fund revenues and expenditures, as well as the revenues and expenditures for the Utility Funds (Gas, Water, Wastewater, and Stormwater). Alignment with City Council’s Vision and Strategic Plan: The project supports City Council’s “Smart, Citizen-Focused Government” vision. It contributes to Goal 5 of the Strategic Plan, be a Well-Managed and Responsive Organization, and objective 5.1, to integrate effective business practices and strong fiscal policies. Community Engagement: This report is to provide the City council and the community a report on the City General Fund finances through October 31, 2020 Budgetary Impact: This has no impact on the General Fund. This is only a report of what has been collected and spent through October 31, 2020. Recommendation: Review of Report Alternatives: N/A Attachments: Council Financial Snapshot Report for F.Y. 2021 through October 31, 2020 October General Fund Revenue Summary Fiscal Year 2021 Actuals from July 1, 2020 ‐ October 31, 2020 $ Change FY21 Revised Annual (Original Adopted to Original YTD Projected YTD Actual (through % of FY21 Budget Major Revenue Streams FY21 Original Budget Projections Revised) (through October 31) October 31) Collected Real Estate Tax $ 78,353,270 $ 78,175,000 $ (178,270) $ 1,591,569 $ 1,625,255 2.07% County Revenue Sharing $ 14,589,313 $ 14,589,313 $ ‐ $ ‐ $ ‐ 0.00% Meals Tax $ 14,295,064 $ 12,288,232 $ (2,006,832) $ 3,756,686 $ 3,342,702 23.38% Sales Tax $ 11,504,331 $ 11,800,000 $ 295,669 $ 3,193,748 $ 3,514,459 30.55% Personal Property Tax $ 9,800,000 $ 9,600,000 $ (200,000) $ 713,035 $ 325,275 3.32% Business License $ 6,225,000 $ 6,225,000 $ ‐ $ 266,001 $ 230,862 3.71% Lodging Tax $ 6,282,721 $ 4,420,000 $ (1,862,721) $ 1,923,273 $ 1,207,500 19.22% PILOT: Utilities $ 6,091,667 $ 6,091,667 $ ‐ $ ‐ $ ‐ 0.00% Utility Taxes $ 5,024,112 $ 5,024,112 $ ‐ $ 1,570,035 $ 1,456,601 28.99% Other Revenue $ 39,030,395 $ 38,051,963 $ (978,432) $ 15,068,184 $ 15,506,210 39.73% Total $ 191,195,873 $ 186,265,287 $ (4,930,586) $ 28,082,531.50 $ 27,208,864.55 14.23% "Big 9" Revenue (revenues exceeding $5 Million) comprise 80% of total City Revenue "Other Revenue" will be irregular due to one‐time and quarterly payments, as well as end‐of ‐year accruals All revenues are compared to a detailed year to date revenue projection October Revenue Summary ‐ FY21 $‐ $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 $14,000,000 $16,000,000 $18,000,000 Real Estate Tax County Revenue Sharing Meals Tax Sales Tax Personal Property Tax Business License Lodging Tax PILOT: Utilities Utility Taxes Other Revenue Original YTD Projected (through October 31) YTD Actual (through October 31) October General Fund Revenue Summary Narrative Real Estate Tax revenue was slightly reduced based upon revised collections rates experienced for the second half of FY20 and assuming collection rates for FY21 would mirror the FY20 collection rates. Meals Tax revenue projections for FY21 Meals Tax were based upon projected recovery rates that exceeded the current rate of recovery. Revised recovery rate projections do not anticipate returning to 100% of previous years collections until the beginning of FY22. A portion of this revenue, 1 cent or 1/6 of the total collected is dedicated to pay for debt service. The decrease in this designated portion will result in a corresponding expenditure decrease of the same amount in the Transfer to Debt Service. Sales Tax has preformed better than anticipated for the beginning of FY21. Revised revenue projections reflect the increased collections to date and a slightly more conservative recovery rate for the reminder of the fiscal year. Personal Property Tax based upon revised book values and collection history for FY20 this revenue projection was reduced by $200,000 for FY21. Lodging Tax revenue projections for FY21 Lodging Tax were based upon projected recovery rates that exceeded the current rate of recovery. Revised recovery rate projections do not anticipate returning to 100% of previous years collections until after the beginning of FY22. Other Revenue ‐ the decrease in the projections for Other Revenue can be explained by a decrease of $650,000 in Parks and Recreation Revenue due to continued closure of facilities; a loss of $205,223 in State Recordation Tax revenue due to the General Assembly reallocating those funds to the Hampton Roads area; a $550,000 decrease in the transfer from the Parking Fund; and an increase in Building an Other Permit revenue. October General Fund Expenditure Summary Fiscal Year 2020‐21 Actuals through October 31st ‐ Period 4 of 12 or 25% of fiscal year. FY21 YTD Actual and FY21 Remaining Available FY21 Original FY21 Current Encumbrances Annual Budget % of FY21 Major Expenditure Categories Budget Budget (through October 31st) (through October 31st) Budget Utilized Contribution to City Schools $ 58,709,623 $ 58,709,623 $ 19,278,208 $ 39,431,415 32.84% Police Department $ 18,017,555 $ 18,254,682 $ 5,840,903 $ 12,413,779 32.00% Outside and Nonprofit Agencies $ 16,798,273 $ 17,048,273 $ 6,712,459 $ 10,335,814 39.37% Fire Department $ 12,539,795 $ 12,724,350 $ 4,597,851 $ 8,126,499 36.13% Public Works $ 12,531,690 $ 12,711,882 $ 3,840,274 $ 8,871,608 30.21% Parks and Recreation $ 11,535,820 $ 11,728,004 $ 3,051,868 $ 8,676,136 26.02% Debt Service $ 11,013,359 $ 11,013,359 $ ‐ $ 11,013,359 0.00% Interfund Transfers $ 10,638,085 $ 10,642,622 $ ‐ $ 10,642,622 0.00% Citywide Reserve $ 250,000 $ 1,238,730 $ 176,184 $ 1,062,546 14.22% Citywide Reserve ‐ COVID Economic Downturn $ 6,674,971 $ 6,674,971 $ ‐ $ 6,674,971 0.00% Tax and Rent Relief Programs $ 1,895,000 $ 1,895,000 $ 839,881 $ 1,055,119 44.32% Internal and Financial Services $ 9,458,988 $ 9,495,351 $ 3,011,398 $ 6,483,954 31.71% School Contractual Services ‐ Pupil Transportation/Building Maintenance $ 6,788,910 $ 6,800,332 $ 2,115,565 $ 4,684,767 31.11% Management $ 5,493,231 $ 6,251,868 $ 2,077,966 $ 4,173,902 33.24% Public Safety and Justice $ 3,705,176 $ 3,978,942 $ 1,075,729 $ 2,903,213 27.04% Healthy Families and Community $ 2,650,095 $ 2,847,644 $ 892,919 $ 1,954,725 31.36% Non Departmental Activities $ 2,495,302 $ 2,673,058 $ 325,266 $ 2,347,791 12.17% Total $ 191,195,873.00 $ 194,688,690.66 $ 53,836,471.17 $ 140,852,219.49 27.65% Notes: Current Budget includes the Original FY21 Adopted Budget as well as FY20 preliminary carryovers. October Expenditure Summary ‐ FY21 Contribution to City Schools Police Department Outside and Nonprofit Agencies Fire Department Public Works Parks and Recreation Debt Service Interfund Transfers Citywide Reserve Citywide Reserve ‐ COVID Economic Downturn Tax and Rent Relief Programs Internal and Financial Services School Contractual Services ‐ Pupil Transportation/Building Maintenance Management Public Safety and Justice Healthy Families and Community Non Departmental Activities $‐ $10,000,000 $20,000,000 $30,000,000 $40,000,000 $50,000,000 $60,000,000 FY21 Current Budget FY21 YTD Actual and Encumbrances (through October 31st) October General Fund Expenditure Summary Narrative Outside and Nonprofit Agencies includes payments to all Vibrant Community fund Agencies, Arts and Culture Agencies, Contractual Agencies including JAUNT and JMRL, and all Organizational Memberships and Agency dues. Actuals to date are above 33.3% due to reflecting both the first and second quarter payments for serval outside human service agencies. Interfund Transfers contains all General Fund transfers to other funds including transfer to Transit, Transfer to Social Services and Human Services, Transfer to Capital Improvement Program, Transfer to Facilities Repair Fund, and Transfer to CSA. These transfers and payments are typically made as one time payments at either the end of the second quarter or beginning of the third quarter. Internal and Financial Services includes the General Fund portions of Finance and Information Technology, and the Office of the City Treasurer, Commissioner of Revenue's Office, and Human Resources. Citywide Reserve includes $250,000 for performance agreements, and $988,730 in other reserve funding some of which is previously appropriated and designated for specific purposes, such as the Citywide 800MHz radio replacements. Citywide Reserve ‐ COVID Economic Downturn includes $6.67M in COVID downturn reserve funding that was originally the cash transfer to the CIP from the General Fund. Rent and Tax Relief includes all rent and tax relief programs for the City including the Charlottesville Housing Affordability Tax Grant Program (CHAP). Actuals to date include approximately half of the CHAP program allocation for FY21. Management includes City Council, Council Strategic Initiatives, City Manager's Office, Redevelopment and Housing, Economic Development, Communications, City Attorney, and the Office of the General Registrar. Public Safety and Justice includes the operations for Circuit Court, General District Court, Juvenile and Domestic Relations Court, Commonwealth Attorney, and City Sheriff. Healthy Families and Community includes Neighborhood Development Services and Office of Human Rights. Non Departmental Activities include Citizen Engagement, Police Civilian Review Board, Participatory Budgeting, Strategic Planning, Employee Compensation and Training, and grant matches for the Food Equity Program and Virginia Juvenile Community Crime Control Act. Utility Fund Revenue and Expenditure Summary Fiscal Year 2020‐21 Actuals through October 31st ‐ Period 4 of 12 or 33.3% of fiscal year. FY21 YTD Actual and FY21 Remaining Available FY21 Original FY21 Current Encumbrances Annual Budget % of FY21 Gas Fund Budget Budget (through October 31st) (through October 31st) Budget Utilized Gas Fund Revenue $ 27,081,999 $ 27,081,999 $ 4,045,281 $ 23,036,718 14.94% Gas Fund Expenditures $ 27,873,698 $ 29,434,341 $ 6,835,679 $ 21,038,019 24.52% FY21 YTD Actual and FY21 Remaining Available FY21 Original FY21 Current Encumbrances Annual Budget % of FY21 Water Fund Budget Budget (through October 31st) (through October 31st) Budget Utilized Water Fund Revenue $ 18,279,490 $ 18,279,490 $ 5,194,227 $ 13,085,263 28.42% Water Fund Expenditures $ 17,272,327 $ 18,166,205 $ 5,532,966 $ 11,739,361 32.03% FY21 YTD Actual and FY21 Remaining Available FY21 Original FY21 Current Encumbrances Annual Budget % of FY21 Wastewater Fund Budget Budget (through October 31st) (through October 31st) Budget Utilized Wastewater Fund Revenue $ 17,451,758 $ 17,451,758 $ 8,677,632 $ 8,774,126 49.72% Wastewater Fund Expenditures $ 17,203,764 $ 17,880,005 $ 4,928,534 $ 12,275,230 28.65% FY21 YTD Actual and FY21 Remaining Available FY21 Original FY21 Current Encumbrances Annual Budget % of FY21 Stormwater Fund Budget Budget (through October 31st) (through October 31st) Budget Utilized Stormwater Fund Revenue $ 2,894,572 $ 2,894,572 $ 2,059,364 $ 835,208 71.15% Stormwater Fund Expenditures $ 2,794,572 $ 2,834,286 $ 1,498,648 $ 1,295,924 53.63% Notes: Current Budget includes the Original FY21 Adopted Budget as well as FY20 preliminary carryovers October Gas Utility Summary ‐ FY21 Gas Fund Revenue Gas Fund Expenditures $‐ $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 $30,000,000 $35,000,000 FY21 Current Budget FY21 YTD Actual and Encumbrances (through October 31st) October Water Utility Summary ‐ FY21 Water Fund Revenue Water Fund Expenditures $‐ $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 $14,000,000 $16,000,000 $18,000,000 $20,000,000 FY21 Current Budget FY21 YTD Actual and Encumbrances (through October 31st) October Wastewater Utility Summary ‐ FY21 Wastewater Fund Revenue Wastewater Fund Expenditures $‐ $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 $14,000,000 $16,000,000 $18,000,000 $20,000,000 FY21 Current Budget FY21 YTD Actual and Encumbrances (through October 31st) October Stormwater Utility Summary ‐ FY21 Stormwater Fund Revenue Stormwater Fund Expenditures $‐ $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 $3,500,000 FY21 Current Budget FY21 YTD Actual and Encumbrances (through October 31st)