City of Charlottesville Revenue Scenarios for FY 2021 Budget (Revised January 2021) Adopted Current $ Change Year to Date Year to Date Further Dow nturn $ Change 2020-2021 Forecast (from Adopted FY Actuals (as of Proj ections per 2020-2021 (from Adopted 21 to Current 1-31-2021) Current FY 21 to Forecast) Forecast Dow nturn FY21) Real Estate Taxes $ 78,353,270 $ 78,075,000 ($278,270) $ 39,025,404 $ 37,233,317 $ 77,853,270 ($500,000) City/County Revenue Sharing $ 14,589,313 $ 14,589,313 $0 $ 14,589,313 $ 14,589,313 $ 14,589,313 $0 Meals Tax $ 14,295,064 $ 10,144,598 ($4,150,466) $ 5,941,082 $ 5,729,376 $ 9,490,753 ($4,804,311) Sales & Use Tax $ 11,504,331 $ 11,395,481 ($108,850) $ 6,564,666 $ 6,568,663 $ 10,806,075 ($698,256) Personal Property Tax $ 9,800,000 $ 9,550,000 ($250,000) $ 4,713,113 $ 4,763,540 $ 9,400,000 ($400,000) Transient Room Tax $ 6,282,721 $ 3,298,223 ($2,984,498) $ 2,092,105 $ 1,976,763 $ 3,206,189 ($3,076,532) Business & Professional Licenses $ 6,225,000 $ 6,225,000 $0 $ 530,533 $ 751,295 $ 6,000,000 ($225,000) Payment in Lieu of Taxes: Utilities $ 6,091,667 $ 6,091,667 $0 $ - $ - $ 6,091,667 $0 Utility Taxes $ 5,024,112 $ 4,300,000 ($724,112) $ 2,518,304 $ 2,508,333 $ 4,100,000 ($924,112) Recreation Income $ 1,335,824 $ 635,060 ($700,764) $ 225,854 $ 370,452 $ 355,060 ($980,764) Transfer from Parking Enterprise Fund $ 1,200,000 $ 400,000 ($800,000) $ - $ - $ 100,000 ($1,100,000) Other Local Taxes Subtotal $ 7,241,431 $ 7,210,249 ($31,182) $ 4,065,747 $ 4,080,261 $ 7,067,249 ($174,182) Other Licenses and Permits Subtotal $ 1,975,500 $ 2,420,500 $445,000 $ 1,122,150 $ 1,139,664 $ 2,275,000 $299,500 Other Intergovernmental Revenue Subtotal $ 12,984,420 $ 13,158,609 $174,189 $ 8,305,453 $ 8,338,979 $ 13,143,609 $159,189 Other Charges for Service Subtotal $ 5,596,604 $ 5,196,604 ($400,000) $ 2,422,705 $ 2,518,185 $ 4,950,754 ($645,850) Other Miscellaneous Revenue Subtotal $ 1,563,956 $ 1,612,956 $49,000 $ 1,141,146 $ 1,068,503 $ 1,612,956 $49,000 Transfers from Other Funds Subtotal $ 250,000 $ 250,000 $0 $ - $ - $ 250,000 $0 Other Designated Revenue $ 6,882,660 $ 6,685,079 ($197,581) $ 6,645,139 $ 6,658,829 $ 6,685,079 ($197,581) GENERAL FUND BUDGET TOTAL $ 191,195,873 $ 181,238,338 ($9,957,535) $ 99,902,711 $ 98,295,473 $ 177,976,973 ($13,218,900) Forecast Date Total Amount Change from Original Adopted September 2020 $186,265,287 ($4,930,586) January 2021 $181,238,338 ($9,957,535) Further Downturn $177,976,973 ($13,218,900) 1 2/15/2021 General Fund Revenue Summary Narrative for Current Forecast (January 2021) column Real Estate Tax revenue was slightly reduced from the original projection and September Forecast based upon the collection rate experienced for the December 2020 deadline, which was off by about 1.2%. This reduction isn’t lost revenue, but the expectation is that all revenue may not materialize in the current fiscal due to slower payment rates. Meals Tax revenue projections for FY21 Meals Tax were based upon projected recovery rates that exceeded the current rate of recovery. The Meals Tax revenue was continuing to improve through the beginning of FY21, but saw a sharp decline in revenue for the December payments. While Meals Tax saw an increase revenue for the January payments, this revenue is still not increasing at the projected rate in the original revenue projections or the revised September Forecast. Revised recovery rate projections project a slower recovery and do not anticipate returning to 100% of previous years collections until the after 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 (estimated at approximately $761,805) will result in a corresponding expenditure decrease of the same amount in the Transfer to Debt Service. Sales Tax initially performed better than anticipated for the beginning of FY21. However recent trends show a decrease in collections which has resulted in a recovery rate for the reminder of the fiscal year that is approximately 6% per month lower than was projected as part of the revised September Forecast. Personal Property Tax based upon revised book values and the collection rate from the December 2020 deadline, this revenue projection has been reduced by $250,000 from the original Adopted FY21 budget. Lodging Tax revenue projections for FY21 were based upon projected recovery rates that exceeded the current rate of recovery. The occupancy rate and overall Lodging Tax revenue was continuing to improve through the beginning of FY21, but saw a sharp decline in revenue for the December payments, While Lodging Tax saw an increase revenue for the January payments, this revenue is still not increasing at the projected rate in the original revenue projections or the revised September Forecast. Revised recovery rate projections anticipate an even slower recovery rate and do not anticipate returning to even 60% of previous years collections until after the beginning of FY22. Utility Tax revenue has continued to lag behind initial revenue projections that we are continuing to monitor. The impacts of COVID, UVA’s modified school year and mild weather conditions continue to still be a factor in the performance of this revenue and the current forecast does not anticipate revenue amounts to reach the original projections for FY21. Parks and Recreation Revenue is projected to see a decrease of approximately $700,000 due to continued closure of facilities, as well as not offering the usual recreation class and instructional opportunities. 1 General Fund Revenue Summary Narrative for January 2021 Forecast column Parking Revenue is now projecting an $800,000 decrease in the transfer from the Parking Fund, due to decreased revenue generation in the City owned parking facilities based upon decreased usage. Other Licenses and Permits ‐ the increase in projected revenue is due to continued strong performance in Building an Other Permit revenue. Other Intergovernmental Revenue ‐ the increase is due to slight increases in a some of the revenue sources that are received from the State. Other Charges for Services ‐ the decrease in the projections for Other Charges for Services Revenue can be explained by a decrease in the amount of Court Revenue projected as well as a decrease in the projected revenue from Reimbursable Public Safety Overtime, which should also show a corresponding decrease in expenditures. Other Designated Revenue ‐ the decrease in the projections for Other Designated Revenue can be explained by a decrease in the transfer to the CIP for Mall Vendor Fees, which will have a corresponding expenditure decrease for that project; and due to a decrease in the Pupil Transportation revenue that was to come from bus rentals and field trip revenue. 2 January General Fund Expenditure Summary Fiscal Year 2020‐21 Actuals through January 31st ‐ Period 7 of 12 or 58.3% 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 January 31st) (through January 31st) Budget Utilized Contribution to City Schools $ 58,709,623 $ 58,709,623 $ 33,736,864 $ 24,972,759 57.46% Police Department $ 18,017,555 $ 18,254,682 $ 9,868,647 $ 8,386,035 54.06% Outside and Nonprofit Agencies $ 16,798,273 $ 17,040,773 $ 12,502,424 $ 4,538,349 73.37% Fire Department $ 12,539,795 $ 12,658,000 $ 7,745,663 $ 4,912,337 61.19% Public Works $ 12,531,690 $ 12,817,180 $ 6,544,353 $ 6,272,827 51.06% Parks and Recreation $ 11,535,820 $ 11,728,454 $ 4,834,793 $ 6,893,661 41.22% Debt Service $ 11,013,359 $ 11,013,359 $ 10,251,554 $ 761,805 93.08% Interfund Transfers $ 10,638,085 $ 14,648,995 $ 14,157,090 $ 491,905 96.64% Citywide Reserve $ 250,000 $ 1,238,730 $ 226,175 $ 1,012,555 18.26% 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 $ 1,358,406 $ 536,594 71.68% Internal and Financial Services $ 9,458,988 $ 9,495,351 $ 5,390,042 $ 4,105,310 56.77% School Contractual Services ‐ Pupil Transportation/Building Maintenance $ 6,788,910 $ 6,800,332 $ 3,347,115 $ 3,453,217 49.22% Management $ 5,493,231 $ 6,277,993 $ 3,384,111 $ 2,893,881 53.90% Public Safety and Justice $ 3,705,176 $ 3,978,943 $ 1,909,908 $ 2,069,034 48.00% Healthy Families and Community $ 2,650,095 $ 2,847,118 $ 1,426,348 $ 1,420,770 50.10% Non Departmental Activities $ 2,495,302 $ 2,841,872 $ 460,993 $ 2,380,879 16.22% Total $ 191,195,873.00 $ 198,921,376.09 $ 117,144,486.10 $ 81,776,889.99 58.89% Notes: Current Budget includes the Original FY21 Adopted Budget as well as FY20 carryovers. January 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 January 31st) January General Fund Expenditure Summary Narrative (Actuals through January 31, 2021) 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 58% due to reflecting a third quarterly payments for several outside human service agencies. Debt Service represents the General Fund transfer to the Debt Service Fund. The actuals contain the General Fund contribution to the City's annual debt service of $8,560,788, and the portion of the Meals Tax revenue, 1 cent or 1/6 of the total collected, that is dedicated to pay for debt service. This portion of the transfer is now showing a reduction of $761,805, due to the decrease in Meals Tax revenue projections. The designated Meals Tax portion of this revenue will be adjusted at the end of the fiscal year based upon the actual revenue that is collected. 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, and many are made at either the end of the second quarter or beginning of the third quarter and are adjusted at the end of the fiscal year. 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. 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 Real Estate Tax Relief program allocations for FY21, and all of the CHAP program and Rent Relief program allocations 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. 1 January General Fund Expenditure Summary Narrative (Actuals through January 31, 2021) 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. 2 Utility Fund Revenue and Expenditure Summary Fiscal Year 2020‐21 Actuals through January 31st ‐ Period 7 of 12 or 58.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 January 31st) (through January 31st) Budget Utilized Gas Fund Revenue $ 27,081,999 $ 27,081,999 $ 11,561,944 $ 15,520,055 42.69% Gas Fund Expenditures $ 27,873,698 $ 29,434,341 $ 12,130,847 $ 15,742,851 43.52% FY21 YTD Actual and FY21 Remaining Available FY21 Original FY21 Current Encumbrances Annual Budget % of FY21 Water Fund Budget Budget (through January 31st) (through January 31st) Budget Utilized Water Fund Revenue $ 18,279,490 $ 18,279,490 $ 8,031,142 $ 10,248,348 43.94% Water Fund Expenditures $ 17,272,327 $ 18,166,205 $ 8,270,247 $ 9,002,080 47.88% FY21 YTD Actual and FY21 Remaining Available FY21 Original FY21 Current Encumbrances Annual Budget % of FY21 Wastewater Fund Budget Budget (through January 31st) (through January 31st) Budget Utilized Wastewater Fund Revenue $ 17,451,758 $ 17,451,758 $ 12,354,354 $ 5,097,404 70.79% Wastewater Fund Expenditures $ 17,203,764 $ 17,880,005 $ 11,237,708 $ 5,966,056 65.32% FY21 YTD Actual and FY21 Remaining Available FY21 Original FY21 Current Encumbrances Annual Budget % of FY21 Stormwater Fund Budget Budget (through January 31st) (through January 31st) Budget Utilized Stormwater Fund Revenue $ 2,894,572 $ 2,894,572 $ 3,065,802 $ (171,230) 105.92% Stormwater Fund Expenditures $ 2,794,572 $ 2,834,286 $ 2,734,645 $ 59,927 97.86% Notes: Current Budget includes the Original FY21 Adopted Budget as well as all non‐capital FY20 carryovers. January 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 January 31st) January 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 January 31st) January 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 January 31st) January 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 January 31st)