Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
Five_Year_Model-FY2021_thru_FY25
Five year general fund model-FY2021 thru FY25 general fund 4% unexpend 7/22/2020 7/22/2020 GENERAL FUND FIVE YEAR FORECASTING MODEL - 4% PROJECTED UNEXPENDED 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 Actual Actual Actual Actual Actual Adopted Proposed Projected Projected Projected Projected Revenue: R10 Sales & Use Taxes 10,856,301.56$ 11,002,277.22$ 11,304,677.76$ 11,470,052.28$ 11,511,614.42$ 11,874,085.20$ 12,052,196.48$ 12,205,259.38$ 12,360,266.17$ 12,517,241.55$ 12,676,210.52$ Percent Increase R16 Intergovernmental Taxes 2,239,453.34$ 2,256,567.12$ 2,351,639.50$ 2,310,027.36$ 2,364,389.06$ 2,322,500.00$ 2,356,000.00$ 2,385,921.20$ 2,416,222.40$ 2,446,908.42$ 2,477,984.16$ Revenue Increase 1.27% R20 Other Taxes 120,658.44$ 119,147.32$ 114,223.08$ 107,460.36$ 98,618.24$ 106,000.00$ 100,000.00$ 100,000.00$ 106,000.00$ 106,000.00$ 106,000.00$ Personnel Services 2% Salary; 4% Insurance R30 Franchise & Utility Tax 7,295,903.68$ 7,258,960.13$ 7,060,236.66$ 7,687,403.80$ 6,695,255.29$ 7,205,000.00$ 6,825,000.00$ 6,911,677.50$ 6,999,455.80$ 7,088,348.89$ 7,178,370.92$ Materials & Supplies 2% R40 Property Taxes 5,261,507.72$ 5,267,656.59$ 5,419,823.93$ 5,484,475.06$ 5,447,765.87$ 5,466,399.00$ 5,561,399.28$ 5,632,029.05$ 5,703,555.82$ 5,775,990.98$ 5,849,346.06$ Contractual Services 2% R50 Intergovernmental 1,271,801.28$ 1,175,227.57$ 1,511,370.02$ 1,165,834.15$ 1,307,771.62$ 729,650.80$ 875,270.38$ 875,270.38$ 875,270.38$ 875,270.38$ 875,270.38$ Utilities 2% R60 Charges for Services 2,579,221.34$ 2,727,265.73$ 2,767,263.32$ 2,850,119.68$ 2,800,278.24$ 2,875,130.04$ 2,852,676.10$ 2,888,905.09$ 2,925,594.18$ 2,962,749.23$ 3,000,376.14$ Repairs & Maintenance 2% R65 Fees Licenses & Permits 760,615.19$ 818,419.51$ 897,212.52$ 911,495.15$ 999,287.97$ 902,520.00$ 937,650.00$ 949,558.16$ 961,617.54$ 973,830.09$ 986,197.73$ Other Operating Expense 0% R70 Fines & Forfeitures 1,011,319.02$ 939,843.01$ 808,999.18$ 780,531.38$ 670,631.94$ 766,600.00$ 607,900.00$ 615,620.33$ 623,438.71$ 631,356.38$ 639,374.61$ Capital Purchases see CRP vehicle & building pla R72 Contributions/Donations 175,644.15$ 315,830.53$ 333,634.08$ 333,486.60$ 359,132.99$ 331,594.00$ 356,542.00$ 356,542.00$ 356,542.00$ 356,542.00$ 356,542.00$ Capital Projects 0% R75 Other Operating Revenues 255,988.33$ 226,093.63$ 194,656.47$ 110,995.37$ 266,117.45$ 89,000.00$ 119,027.45$ 119,027.45$ 119,027.45$ 119,027.45$ 119,027.45$ Transfers Out 0% R80 Interest Income 127,987.76$ 161,299.58$ 188,032.30$ 166,740.34$ 152,936.14$ 160,002.04$ 120,000.00$ 121,524.00$ 123,067.35$ 124,630.31$ 126,213.12$ Airport Subsidy see airport tab R85 Other Non-Operating Revenue 47,724.76$ 310,059.27$ 123,215.48$ 102,087.75$ 374,007.32$ 55,000.00$ 55,000.00$ 55,000.00$ 55,000.00$ 55,000.00$ 55,000.00$ Transit Subsidy see transit tab R90 Transfers In 32,943.83$ 71,795.86$ 24,870.56$ 24,101.83$ 26,850.27$ 26,000.00$ 26,400.00$ 26,735.28$ 27,074.82$ 27,418.67$ 27,766.89$ Debt Service 0% R99 Carry Over Surplus -$ -$ -$ -$ -$ 21,000.00$ -$ -$ -$ -$ -$ Total Revenues 32,037,070.40$ 32,650,443.07$ 33,099,854.86$ 33,504,811.11$ 33,074,656.82$ 32,930,481.08$ 32,845,061.69$ 33,243,069.81$ 33,652,132.63$ 34,060,314.35$ 34,473,679.97$ Adjustments 32,037,070.40$ 32,650,443.07$ 33,099,854.86$ 33,504,811.11$ 33,074,656.82$ 32,930,481.08$ 32,845,061.69$ 33,243,069.81$ 33,652,132.63$ 34,060,314.35$ 34,473,679.97$ -2.26%1.91%1.38%1.22%-1.28%-0.44%-0.26%1.21%1.23%1.21%1.21%% growth Expenditures: E05 Personnel Services 21,993,539.25$ 22,200,279.00$ 23,248,114.58$ 24,524,383.40$ 24,815,334.51$ 25,600,434.65$ 26,003,452.75$ 26,577,461.59$ 27,165,478.02$ 27,767,883.95$ 28,385,073.02$ E10 Materials & Supplies 1,078,206.14$ 1,084,766.27$ 1,131,117.57$ 1,267,755.43$ 1,829,872.16$ 1,361,130.65$ 1,362,102.46$ 1,389,344.51$ 1,417,131.40$ 1,445,474.03$ 1,474,383.51$ E15 Contractual Services 1,952,503.99$ 1,842,309.63$ 1,949,104.32$ 1,916,508.58$ 1,994,645.99$ 1,778,935.84$ 1,875,082.99$ 1,912,584.65$ 1,950,836.34$ 1,989,853.07$ 2,029,650.13$ E20 Utilities 1,004,630.21$ 979,968.33$ 998,458.46$ 1,035,123.67$ 977,067.79$ 986,654.96$ 1,009,797.40$ 1,029,993.35$ 1,050,593.21$ 1,071,605.08$ 1,093,037.18$ E25 Repairs & Maintenance 1,350,065.51$ 1,550,645.08$ 1,654,732.60$ 1,700,110.86$ 1,761,020.51$ 1,697,749.36$ 1,785,424.98$ 1,821,133.48$ 1,857,556.15$ 1,894,707.27$ 1,932,601.42$ E30 Other Operating Expenses 123,335.41$ 286,303.84$ 175,755.65$ 138,764.72$ 173,843.58$ 86,750.00$ 99,750.00$ 99,750.00$ 99,750.00$ 99,750.00$ 99,750.00$ E70 Capital Purchases 582,477.11$ 930,248.35$ 2,353,379.20$ 909,863.90$ 635,042.24$ Vehicle/Equip Purchases -$ 35,630.10$ 1,076,895.90$ 1,109,380.74$ 1,121,583.93$ 1,144,420.35$ Ongoing Infrastructure 5,583.73$ 300,000.00$ 300,000.00$ 300,000.00$ 300,000.00$ E75 Capital Projects 373,153.41$ 633,648.99$ 1,064,143.41$ 1,111,237.65$ 1,383,403.91$ -$ -$ -$ -$ -$ -$ E80 Transfers Out 590050 Transfer to TIF-Capital Mall 934.09$ 11,358.96$ 706.97$ -$ 333.13$ 4,250.00$ 4,250.00$ 4,250.00$ 4,303.98$ 4,358.64$ 4,413.99$ 590050 Transfer to TIF-Southside 21,915.17$ 8,368.70$ 8,212.42$ 4,485.33$ 4,542.48$ 9,000.00$ 9,000.00$ 9,000.00$ 9,114.30$ 9,230.05$ 9,347.27$ 590050 Transfer to TIF-O'Donoghues 1,583.12$ 1,678.73$ 1,660.28$ 1,885.36$ 1,768.00$ 1,750.00$ 1,750.00$ 1,750.00$ 1,772.23$ 1,794.73$ 1,817.53$ 590050 Transfer to TIF-St. Mary's -$ -$ -$ -$ 4,112.57$ -$ -$ -$ -$ -$ -$ 590065 Transfer to Self-Funded Health In -$ 54,000.00$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 590070 Airport Subsidy 196,059.23$ 189,381.74$ 258,459.28$ 225,547.12$ 241,769.63$ 250,488.56$ 79,111.25$ 266,797.08$ 275,228.07$ 283,866.30$ 292,716.96$ 590075 Transit Subsidy 1,055,200.21$ 1,211,548.73$ 1,007,265.64$ 1,023,442.24$ 1,111,635.79$ 1,147,753.33$ 579,709.76$ 705,365.35$ 761,746.23$ 1,469,443.19$ 1,528,490.02$ E90 Debt Service -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 29,733,602.85$ 30,984,506.35$ 33,851,110.38$ 33,859,108.26$ 34,934,392.29$ 32,930,481.08$ 32,845,061.69$ 35,194,325.91$ 36,002,890.67$ 37,459,550.24$ 38,295,701.37$ Adjustments Reapproprations/Supps 1,569,681.25$ Adjustments Projected Budget Variances - 4% Projected Unexpended (1,317,219.24)$ (1,313,802.47)$ (1,407,773.04)$ (1,440,115.63)$ (1,498,382.01)$ (1,531,828.05)$ 29,733,602.85$ 30,984,506.35$ 33,851,110.38$ 33,859,108.26$ 34,934,392.29$ 33,182,943.09$ 31,531,259.23$ 33,786,552.87$ 34,562,775.04$ 35,961,168.23$ 36,763,873.32$ 2,303,467.55$ 1,665,936.72$ (751,255.52)$ (354,297.15)$ (1,859,735.47)$ (252,462.01)$ 1,313,802.46$ (543,483.07)$ (910,642.41)$ (1,900,853.88)$ (2,290,193.34)$ Fund Balance: 7,092,287.85$ 9,395,754.40$ 11,061,692.12$ 10,310,435.72$ 9,956,138.57$ 8,096,404.10$ 7,843,942.09$ 9,157,744.55$ 8,614,261.49$ 7,703,619.08$ 5,802,765.19$ (1.00)$ 1.00$ (0.88)$ 1.00$ 9,395,754.40$ 11,061,692.12$ 10,310,435.72$ 9,956,138.57$ 8,096,404.10$ 7,843,942.09$ 9,157,744.55$ 8,614,261.49$ 7,703,619.08$ 5,802,765.19$ 3,512,571.85$ (184,250.00)$ (173,944.89)$ (185,853.15)$ (195,506.00)$ (204,900.84)$ (204,900.84)$ (204,900.84)$ (204,900.84)$ (204,900.84)$ (204,900.84)$ (204,900.84)$ (56,991.60)$ (203,989.14)$ (217,858.28)$ (271,194.00)$ (255,995.27)$ (255,995.27)$ (255,995.27)$ (255,995.27)$ (255,995.27)$ (255,995.27)$ (255,995.27)$ (1,831,544.54)$ (1,540,784.74)$ (433,562.17)$ (949,331.00)$ (115,000.00)$ (115,000.00)$ (50,000.00)$ (50,000.00)$ (50,000.00)$ (50,000.00)$ (50,000.00)$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ (312,638.76)$ (298,001.79)$ (241,659.00)$ (251,090.00)$ (338,644.86)$ (338,644.86)$ (338,644.86)$ (338,644.86)$ (338,644.86)$ (338,644.86)$ (338,644.86)$ 7,010,329.50$ 8,844,971.56$ 9,231,503.12$ 8,289,017.57$ 7,181,863.13$ 6,929,401.12$ 8,308,203.58$ 7,764,720.52$ 6,854,078.11$ 4,953,224.22$ 2,663,030.88$ 23.78%28.77%28.65%25.55%21.89%21.04%25.30%22.06%19.04%13.22%6.95% Unrestricted Fund Balance as a Percentage of Originally Adopted Expenditures Less: Reserve for Inventory Less: Reserve for Prepaids Less: Encumbrances/Committed Less: Reserve for Capital/Vehicle/Equipment Less: Reserve for Restricted Funds Unrestricted Fund Balance Fund Balance Assumptions Total Expenditures Net Increase (Decrease) in Fund Balance Add: Beginning Fund Balance Prior Period Adjustment Five year general fund model-FY2021 thru FY25 general fund no unexpended 7/22/2020 7/22/2020 GENERAL FUND FIVE YEAR FORECASTING MODEL - NO UNEXPENDED PROJECTED 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 Actual Actual Actual Actual Actual Adopted Proposed Projected Projected Projected Projected Revenue: R10 Sales & Use Taxes 10,856,301.56$ 11,002,277.22$ 11,304,677.76$ 11,470,052.28$ 11,511,614.42$ 11,874,085.20$ 12,052,196.48$ 12,205,259.38$ 12,360,266.17$ 12,517,241.55$ 12,676,210.52$ Percent Increase R16 Intergovernmental Taxes 2,239,453.34$ 2,256,567.12$ 2,351,639.50$ 2,310,027.36$ 2,364,389.06$ 2,322,500.00$ 2,356,000.00$ 2,385,921.20$ 2,416,222.40$ 2,446,908.42$ 2,477,984.16$ Revenue Increase 1.27% R20 Other Taxes 120,658.44$ 119,147.32$ 114,223.08$ 107,460.36$ 98,618.24$ 106,000.00$ 100,000.00$ 100,000.00$ 100,000.00$ 106,000.00$ 106,000.00$ Personnel Services 2% Salary; 4% Insurance R30 Franchise & Utility Tax 7,295,903.68$ 7,258,960.13$ 7,060,236.66$ 7,687,403.80$ 6,695,255.29$ 7,205,000.00$ 6,825,000.00$ 6,911,677.50$ 6,999,455.80$ 7,088,348.89$ 7,178,370.92$ Materials & Supplies 2% R40 Property Taxes 5,261,507.72$ 5,267,656.59$ 5,419,823.93$ 5,484,475.06$ 5,447,765.87$ 5,466,399.00$ 5,561,399.28$ 5,632,029.05$ 5,703,555.82$ 5,775,990.98$ 5,849,346.06$ Contractual Services 2% R50 Intergovernmental 1,271,801.28$ 1,175,227.57$ 1,511,370.02$ 1,165,834.15$ 1,307,771.62$ 729,650.80$ 875,270.38$ 875,270.38$ 875,270.38$ 875,270.38$ 875,270.38$ Utilities 2% R60 Charges for Services 2,579,221.34$ 2,727,265.73$ 2,767,263.32$ 2,850,119.68$ 2,800,278.24$ 2,875,130.04$ 2,852,676.10$ 2,888,905.09$ 2,925,594.18$ 2,962,749.23$ 3,000,376.14$ Repairs & Maintenance 2% R65 Fees Licenses & Permits 760,615.19$ 818,419.51$ 897,212.52$ 911,495.15$ 999,287.97$ 902,520.00$ 937,650.00$ 949,558.16$ 961,617.54$ 973,830.09$ 986,197.73$ Other Operating Expense 0% R70 Fines & Forfeitures 1,011,319.02$ 939,843.01$ 808,999.18$ 780,531.38$ 670,631.94$ 766,600.00$ 607,900.00$ 615,620.33$ 623,438.71$ 631,356.38$ 639,374.61$ Capital Purchases see CRP vehicle & building pla R72 Contributions/Donations 175,644.15$ 315,830.53$ 333,634.08$ 333,486.60$ 359,132.99$ 331,594.00$ 356,542.00$ 356,542.00$ 356,542.00$ 356,542.00$ 356,542.00$ Capital Projects 0% R75 Other Operating Revenues 255,988.33$ 226,093.63$ 194,656.47$ 110,995.37$ 266,117.45$ 89,000.00$ 119,027.45$ 119,027.45$ 119,027.45$ 119,027.45$ 119,027.45$ Transfers Out 0% R80 Interest Income 127,987.76$ 161,299.58$ 188,032.30$ 166,740.34$ 152,936.14$ 160,002.04$ 120,000.00$ 121,524.00$ 123,067.35$ 124,630.31$ 126,213.12$ Airport Subsidy see airport tab R85 Other Non-Operating Revenue 47,724.76$ 310,059.27$ 123,215.48$ 102,087.75$ 374,007.32$ 55,000.00$ 55,000.00$ 55,000.00$ 55,000.00$ 55,000.00$ 55,000.00$ Transit Subsidy see transit tab R90 Transfers In 32,943.83$ 71,795.86$ 24,870.56$ 24,101.83$ 26,850.27$ 26,000.00$ 26,400.00$ 26,735.28$ 27,074.82$ 27,418.67$ 27,766.89$ Debt Service 0% R99 Carry Over Surplus -$ -$ -$ -$ -$ 21,000.00$ -$ -$ -$ -$ -$ Total Revenues 32,037,070.40$ 32,650,443.07$ 33,099,854.86$ 33,504,811.11$ 33,074,656.82$ 32,930,481.08$ 32,845,061.69$ 33,243,069.81$ 33,646,132.63$ 34,060,314.35$ 34,473,679.97$ Adjustments 32,037,070.40$ 32,650,443.07$ 33,099,854.86$ 33,504,811.11$ 33,074,656.82$ 32,930,481.08$ 32,845,061.69$ 33,243,069.81$ 33,646,132.63$ 34,060,314.35$ 34,473,679.97$ 1.38%1.22%-1.28%-0.44%-0.26%1.21%1.21%1.23%1.21%% growth Expenditures: E05 Personnel Services 21,993,539.25$ 22,200,279.00$ 23,248,114.58$ 24,524,383.40$ 24,815,334.51$ 25,600,434.65$ 26,003,452.75$ 26,577,461.59$ 27,165,478.02$ 27,767,883.95$ 28,385,073.02$ E10 Materials & Supplies 1,078,206.14$ 1,084,766.27$ 1,131,117.57$ 1,267,755.43$ 1,829,872.16$ 1,361,130.65$ 1,362,102.46$ 1,389,344.51$ 1,417,131.40$ 1,445,474.03$ 1,474,383.51$ E15 Contractual Services 1,952,503.99$ 1,842,309.63$ 1,949,104.32$ 1,916,508.58$ 1,994,645.99$ 1,778,935.84$ 1,875,082.99$ 1,912,584.65$ 1,950,836.34$ 1,989,853.07$ 2,029,650.13$ E20 Utilities 1,004,630.21$ 979,968.33$ 998,458.46$ 1,035,123.67$ 977,067.79$ 986,654.96$ 1,009,797.40$ 1,029,993.35$ 1,050,593.21$ 1,071,605.08$ 1,093,037.18$ E25 Repairs & Maintenance 1,350,065.51$ 1,550,645.08$ 1,654,732.60$ 1,700,110.86$ 1,761,020.51$ 1,697,749.36$ 1,785,424.98$ 1,821,133.48$ 1,857,556.15$ 1,894,707.27$ 1,932,601.42$ E30 Other Operating Expenses 123,335.41$ 286,303.84$ 175,755.65$ 138,764.72$ 173,843.58$ 86,750.00$ 99,750.00$ 99,750.00$ 99,750.00$ 99,750.00$ 99,750.00$ E70 Capital Purchases 582,477.11$ 930,248.35$ 2,353,379.20$ 909,863.90$ 635,042.24$ 572010 Vehicle/Equip Purchases -$ 35,630.10$ 1,076,895.90$ 1,109,380.74$ 1,121,583.93$ 1,144,420.35$ 572020 Ongoing Infrastructure 5,583.73$ 300,000.00$ 300,000.00$ 300,000.00$ 300,000.00$ E75 Capital Projects 373,153.41$ 633,648.99$ 1,064,143.41$ 1,111,237.65$ 1,383,403.91$ -$ -$ -$ -$ -$ -$ E80 Transfers Out 590050 Transfer to TIF-Capital Mall 934.09$ 11,358.96$ 706.97$ -$ 333.13$ 4,250.00$ 4,250.00$ 4,250.00$ 4,303.98$ 4,358.64$ 4,413.99$ 590050 Transfer to TIF-Southside 21,915.17$ 8,368.70$ 8,212.42$ 4,485.33$ 4,542.48$ 9,000.00$ 9,000.00$ 9,000.00$ 9,114.30$ 9,230.05$ 9,347.27$ 590050 Transfer to TIF-O'Donoghues 1,583.12$ 1,678.73$ 1,660.28$ 1,885.36$ 1,768.00$ 1,750.00$ 1,750.00$ 1,750.00$ 1,772.23$ 1,794.73$ 1,817.53$ 590050 Transfer to TIF-St. Mary's -$ -$ -$ -$ 4,112.57$ -$ -$ -$ -$ -$ -$ 590065 Transfer to Self-Funded Health In -$ 54,000.00$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 590070 Airport Subsidy 196,059.23$ 189,381.74$ 258,459.28$ 225,547.12$ 241,769.63$ 250,488.56$ 79,111.25$ 266,797.08$ 275,228.07$ 283,866.30$ 292,716.96$ 590075 Transit Subsidy 1,055,200.21$ 1,211,548.73$ 1,007,265.64$ 1,023,442.24$ 1,111,635.79$ 1,147,753.33$ 579,709.76$ 705,365.35$ 761,746.23$ 1,469,443.19$ 1,528,490.02$ E90 Debt Service -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 29,733,602.85$ 30,984,506.35$ 33,851,110.38$ 33,859,108.26$ 34,934,392.29$ 32,930,481.08$ 32,845,061.69$ 35,194,325.91$ 36,002,890.67$ 37,459,550.24$ 38,295,701.37$ Adjustments Reapproprations/Supps 1,428,681.75$ 29,733,602.85$ 30,984,506.35$ 33,851,110.38$ 33,859,108.26$ 34,934,392.29$ 34,359,162.83$ 32,845,061.69$ 35,194,325.91$ 36,002,890.67$ 37,459,550.24$ 38,295,701.37$ 2,303,467.55$ 1,665,936.72$ (751,255.52)$ (354,297.15)$ (1,859,735.47)$ (1,428,681.75)$ (0.00)$ (1,951,256.10)$ (2,356,758.04)$ (3,399,235.89)$ (3,822,021.40)$ Fund Balance: 7,092,287.85$ 9,395,754.40$ 11,061,692.12$ 10,310,435.72$ 9,956,138.57$ 8,096,404.10$ 6,667,722.35$ 6,667,722.34$ 4,716,466.24$ 2,359,708.20$ (1,039,527.69)$ (1.00)$ 1.00$ (0.88)$ 1.00$ 9,395,754.40$ 11,061,692.12$ 10,310,435.72$ 9,956,138.57$ 8,096,404.10$ 6,667,722.35$ 6,667,722.34$ 4,716,466.24$ 2,359,708.20$ (1,039,527.69)$ (4,861,549.09)$ (184,250.00)$ (173,944.89)$ (185,853.15)$ (195,506.00)$ (204,900.84)$ (204,900.84)$ (204,900.84)$ (204,900.84)$ (204,900.84)$ (204,900.84)$ (204,900.84)$ (56,991.60)$ (203,989.14)$ (217,858.28)$ (271,194.00)$ (255,995.27)$ (255,995.27)$ (255,995.27)$ (255,995.27)$ (255,995.27)$ (255,995.27)$ (255,995.27)$ (1,831,544.54)$ (1,540,784.74)$ (433,562.17)$ (949,331.00)$ (115,000.00)$ (115,000.00)$ (50,000.00)$ (50,000.00)$ (50,000.00)$ (50,000.00)$ (50,000.00)$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ (312,638.76)$ (298,001.79)$ (241,659.00)$ (251,090.00)$ (338,644.86)$ (338,644.86)$ (338,644.86)$ (338,644.86)$ (338,644.86)$ (338,644.86)$ (338,644.86)$ 7,010,329.50$ 8,844,971.56$ 9,231,503.12$ 8,289,017.57$ 7,181,863.13$ 5,753,181.38$ 5,818,181.37$ 3,866,925.27$ 1,510,167.23$ (1,889,068.66)$ (5,711,090.06)$ 23.78%28.77%28.65%25.55%21.89%17.47%17.71%10.99%4.19%-5.04%-14.91% Fund Balance Assumptions Total Expenditures Net Increase (Decrease) in Fund Balance Add: Beginning Fund Balance Prior Period Adjustment Unrestricted Fund Balance as a Percentage of Originally Adopted Expenditures Less: Reserve for Inventory Less: Reserve for Prepaids Less: Encumbrances/Committed Less: Reserve for Capital/Vehicle/Equipment Less: Reserve for Restricted Funds Unrestricted Fund Balance AIRPORT FUND LONG-RANGE FINANCIAL PLANNING City of Jefferson, Missouri 5 Year Forecast Model FY 2021- 2025 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 Actual Actual Actual Actual Actual Adopted Proposed Projected Projected Projected Projected Revenue: R50 Intergovernmental 5,166,054.56$ 1,344,897.00$ 137,440.59$ 176,842.79$ 159,886.61$ 46,000.00$ 46,000.00$ 46,000.00$ 46,000.00$ 46,000.00$ 46,000.00$ Percent Increase R60 Charges for Services 181,726.48$ 189,041.52$ 172,504.46$ 160,185.52$ 184,542.63$ 156,000.00$ 161,000.00$ 162,610.00$ 164,236.10$ 165,878.46$ 167,537.25$ Revenue Increase 1.00% R75 Other Operating Revenues -$ 259.03$ -$ -$ 258,294.44$ -$ -$ -$ -$ -$ -$ Expenditures R80 Interest Income (310.89)$ (3,598.31)$ (192.02)$ 2,876.00$ 3,275.61$ -$ -$ -$ -$ -$ -$ R85 Other Non-Operating Revenue -$ 170.00$ 11,834.01$ 16.62$ 9,100.00$ -$ -$ -$ -$ -$ -$ R90 Transfers In 465,620.52$ 334,849.45$ 272,484.62$ 263,131.14$ 316,745.77$ 250,488.56$ 79,111.25$ 266,797.08$ 275,228.07$ 283,866.30$ 292,716.96$ R99 Carry Over Surplus -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Total Revenues 5,813,090.67$ 1,865,618.69$ 594,071.66$ 603,052.07$ 931,845.06$ 452,488.56$ 286,111.25$ 475,407.08$ 485,464.17$ 495,744.76$ 506,254.20$ charge for services growth 4.03%-8.75%-7.14%15.21% Expenditures: E05 Personnel Services 171,477.35$ 176,056.44$ 208,504.00$ 201,753.74$ 222,339.17$ 234,113.69$ 214,682.45$ 219,503.56$ 224,442.59$ 229,502.74$ 234,687.34$ E10 Materials & Supplies 13,959.59$ 20,500.23$ 21,276.43$ 34,847.62$ 83,507.54$ 25,650.00$ 25,650.00$ 26,163.00$ 26,686.26$ 27,219.99$ 27,764.38$ E15 Contractual Services 153,104.92$ 153,036.68$ 160,214.18$ 168,731.89$ 171,070.33$ 176,676.87$ 178,060.80$ 181,622.02$ 185,254.46$ 188,959.55$ 192,738.74$ E20 Utilities 35,101.01$ 30,461.29$ 30,856.19$ 31,992.97$ 21,855.15$ 32,300.00$ 22,800.00$ 23,256.00$ 23,721.12$ 24,195.54$ 24,679.45$ E25 Repairs & Maintenance 28,463.31$ 63,685.91$ 44,633.24$ 47,814.31$ 27,944.65$ 24,375.00$ 24,375.00$ 24,862.50$ 25,359.75$ 25,866.95$ 26,384.28$ E65 Other Non-Operating Expenses -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ E70 Capital Purchases -$ -$ 16,925.10$ -$ 21,790.00$ -$ -$ -$ -$ -$ -$ E75 Capital Projects -$ -$ -$ 147,508.69$ 127,246.39$ -$ -$ -$ -$ -$ -$ E79 Depreciation 233,610.29$ 193,288.31$ 238,638.49$ 935,224.54$ 930,230.38$ -$ -$ -$ -$ -$ -$ E80 Transfers Out -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 635,716.47$ 637,028.86$ 721,047.63$ 1,567,873.76$ 1,605,983.61$ 493,115.56$ 465,568.25$ 475,407.08$ 485,464.17$ 495,744.76$ 506,254.20$ Adjustments Reapproprations/Supps 30,000.00$ 50,000.00$ 523,115.56$ 515,568.25$ 5,177,374.20$ 1,228,589.83$ (126,975.97)$ (964,821.69)$ (674,138.55)$ (70,627.00)$ (229,457.00)$ -$ -$ -$ -$ Fund Balance: 5,316,525.77$ 10,561,814.23$ 11,790,406.06$ 11,663,427.09$ 10,688,737.40$ 10,014,598.85$ 9,943,971.85$ 9,714,514.85$ 9,714,514.85$ 9,714,514.85$ 9,714,514.85$ 67,914.26$ 2.00$ (3.00)$ (9,868.00)$ 10,561,814.23$ 11,790,406.06$ 11,663,427.09$ 10,688,737.40$ 10,014,598.85$ 9,943,971.85$ 9,714,514.85$ 9,714,514.85$ 9,714,514.85$ 9,714,514.85$ 9,714,514.85$ (10,376,484.61)$ (11,595,029.02)$ (11,475,364.54)$ (10,540,140.00)$ (9,668,273.70)$ (9,668,273.70)$ (9,668,273.70)$ (9,668,273.70)$ (9,668,273.70)$ (9,668,273.70)$ (9,668,273.70)$ (62,119.11)$ (55,574.23)$ (51,953.09)$ (38,453.00)$ (46,240.30)$ (46,240.30)$ (46,240.30)$ (46,240.30)$ (46,240.30)$ (46,240.30)$ (46,240.30)$ 123,210.51$ 139,802.81$ 136,109.46$ 110,144.40$ 300,084.85$ 229,457.85$ 0.85$ 0.85$ 0.85$ 0.85$ 0.85$ 29.33%32.87%25.79%22.29%18.69%46.53%0.00%0.00%0.00%0.00%0.00% Assumptions Unrestricted Fund Balance Unrestricted Fund Balance as a Percentage of Originally Adopted Expenditures Total Expenditures Net Increase (Decrease) in Fund Balance Add: Beginning Fund Balance Fund Balance Less: Capital Contributions Add: Prior Period Adjustments Less: Restricted for Pensions All expenditures are based on general fund tab assumptions PARKING FUND LONG-RANGE FINANCIAL PLANNING City of Jefferson, Missouri 5 Year Forecast Model FY 2021 - 2025 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 Actual Actual Actual Actual Actual Adopted Projected Projected Projected Projected Projected Revenue: R50 Intergovernmental -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Percent Increase R60 Charges for Services 989,946.04$ 1,001,667.92$ 972,593.56$ 986,058.65$ 997,348.09$ 969,600.00$ 969,600.00$ 988,992.00$ 1,008,771.84$ 1,028,947.28$ 1,049,526.22$ Revenues 2.00% R70 Fines & Forfeitures 119,850.50$ 132,992.50$ 109,222.00$ 135,980.00$ 123,063.50$ 120,000.00$ 120,000.00$ 122,400.00$ 124,848.00$ 127,344.96$ 129,891.86$ Expenditures R75 Other Operating Revenues 27,393.72$ 24,622.48$ 26,504.66$ 31,216.66$ 34,168.66$ 27,692.00$ 32,500.00$ 33,150.00$ 33,813.00$ 34,489.26$ 35,179.05$ R80 Interest Income 64,322.37$ 66,559.46$ 81,176.88$ 77,544.82$ 85,100.23$ 50,000.00$ 50,000.00$ 51,000.00$ 52,020.00$ 53,060.40$ 54,121.61$ R85 Other Non-Operating Revenue 4,482.66$ 136,289.10$ 267.40$ -$ 6,049.12$ -$ -$ -$ -$ -$ -$ R99 Carry Over Surplus -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Total Revenues 1,205,995.29$ 1,362,131.46$ 1,189,764.50$ 1,230,800.13$ 1,245,729.60$ 1,167,292.00$ 1,172,100.00$ 1,195,542.00$ 1,219,452.84$ 1,243,841.90$ 1,268,718.73$ 3.07%1.65%-12.67%3.45%0.72% Expenditures: E05 Personnel Services 459,105.26$ 428,999.38$ 446,276.21$ 458,173.14$ 417,571.99$ 453,132.16$ 450,031.49$ 460,114.97$ 470,444.35$ 481,026.32$ 491,867.78$ E10 Materials & Supplies 15,939.17$ 15,917.42$ 22,673.88$ 20,512.55$ 30,805.09$ 36,020.00$ 39,520.00$ 40,310.40$ 41,116.61$ 41,938.94$ 42,777.72$ E15 Contractual Services 189,671.80$ 185,469.24$ 201,447.31$ 208,153.51$ 195,638.49$ 195,347.55$ 197,030.51$ 200,971.12$ 204,990.54$ 209,090.35$ 213,272.16$ E20 Utilities 35,702.04$ 34,604.32$ 29,425.59$ 21,449.99$ 18,914.21$ 35,543.00$ 36,307.00$ 37,033.14$ 37,773.80$ 38,529.28$ 39,299.86$ E25 Repairs & Maintenance 85,841.18$ 119,189.39$ 89,264.40$ 117,930.98$ 83,938.18$ 185,265.45$ 181,101.00$ 184,723.02$ 188,417.48$ 192,185.83$ 196,029.55$ E30 Other Operating Expenses 198.75$ 375.00$ -$ -$ -$ -$ -$ -$ -$ -$ -$ E65 Other Non-Operating Expense 4,096.00$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ E70 Capital Purchases 11.00$ 13,511.00$ 106,322.00$ -$ 2,411.48$ -$ -$ 49,297.00$ 50,776.37$ 52,299.66$ 53,868.65$ E79 Depreciation 64,366.82$ 64,826.99$ 68,139.74$ 77,223.53$ 75,988.34$ -$ -$ -$ -$ -$ -$ E80 Transfers Out 10,000.00$ 130,850.91$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 864,932.02$ 993,743.65$ 963,549.13$ 903,443.70$ 825,267.78$ 905,308.16$ 903,990.00$ 972,449.65$ 993,519.16$ 1,015,070.39$ 1,037,115.72$ 341,063.27$ 368,387.81$ 226,215.37$ 327,356.43$ 420,461.82$ 261,983.84$ 268,110.00$ 223,092.35$ 225,933.68$ 228,771.51$ 231,603.02$ Fund Balance: 5,451,400.06$ 6,003,480.33$ 6,371,868.56$ 6,598,082.93$ 6,900,759.36$ 7,321,221.18$ 7,583,205.02$ 7,851,315.02$ 8,074,407.37$ 8,300,341.05$ 8,529,112.56$ 211,017.00$ 0.42$ (1.00)$ (24,680.00)$ 6,003,480.33$ 6,371,868.56$ 6,598,082.93$ 6,900,759.36$ 7,321,221.18$ 7,583,205.02$ 7,851,315.02$ 8,074,407.37$ 8,300,341.05$ 8,529,112.56$ 8,760,715.58$ (2,280,471.00)$ (2,243,873.27)$ (2,223,385.71)$ (2,207,127.00)$ (2,187,252.13)$ (2,187,252.13)$ (2,187,252.13)$ (2,187,252.13)$ (2,187,252.13)$ (2,187,252.13)$ (2,187,252.13)$ (193,011.00)$ (180,594.58)$ (172,375.89)$ (139,020.00)$ (153,812.89)$ (153,812.89)$ (153,812.89)$ (153,812.89)$ (153,812.89)$ (153,812.89)$ (153,812.89)$ 3,529,998.33$ 3,947,400.71$ 4,202,321.33$ 4,554,612.36$ 4,980,156.16$ 5,242,140.00$ 5,510,250.00$ 5,733,342.35$ 5,959,276.03$ 6,188,047.54$ 6,419,650.56$ 366.00%407.91%448.68%490.30%603.46%579.04%609.55%589.58%599.81%609.62%618.99% Assumptions Unrestricted Fund Balance Unrestricted Fund Balance as a Percentage of Originally Adopted Expenditures Total Expenditures Net Increase (Decrease) in Fund Balance Add: Beginning Fund Balance Fund Balance Less: Capital Contributions Add: Prior Period Adjustments Less: Restricted for Pensions All expenditures are based on general fund tab assumptions TRANSIT FUND LONG-RANGE FINANCIAL PLANNING City of Jefferson, Missouri 5 Year Forecast Model FY 2021 - 2025 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 Actual Actual Actual Actual Actual Adopted Projected Projected Projected Projected Projected Percent Increase Revenue:Intergovernmenta 0% R50 Intergovernmental 1,101,129.91$ 1,211,809.57$ 1,219,902.78$ 1,346,303.78$ 1,152,994.26$ 1,077,500.00$ 1,685,000.00$ 1,685,000.00$ 1,685,000.00$ 1,035,000.00$ 1,035,000.00$ Charges for serv.0% R60 Charges for Services 214,149.59$ 204,257.08$ 191,717.05$ 186,787.32$ 232,461.75$ 193,692.00$ 182,692.00$ 182,692.00$ 182,692.00$ 182,692.00$ 182,692.00$ Other op. revenue 1% R75 Other Operating Revenues 41,295.09$ 54,101.29$ 36,497.04$ 50,961.71$ 44,230.51$ 43,500.00$ 37,000.00$ 37,370.00$ 37,743.70$ 38,121.14$ 38,502.35$ Interest income 0% R80 Interest Income 5,622.42$ 12,285.80$ 10,592.83$ 7,860.45$ 8,442.22$ -$ -$ -$ -$ -$ -$ non op. revenues 0% R85 Other Non-Operating Revenue 45,983.34$ 21,734.00$ 62.23$ 496.03$ 4,535.86$ -$ -$ -$ -$ -$ -$ Expenditures R90 Transfer In 1,059,653.65$ 1,276,236.26$ 1,094,377.85$ 1,240,829.23$ 1,193,326.17$ 1,147,753.33$ 579,709.76$ 705,365.35$ 761,746.23$ 1,469,443.19$ 1,528,490.02$ R99 Carry Over Surplus -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Total Revenues 2,467,834.00$ 2,780,424.00$ 2,553,149.78$ 2,833,238.52$ 2,635,990.77$ 2,462,445.33$ 2,484,401.76$ 2,610,427.35$ 2,667,181.93$ 2,725,256.33$ 2,784,684.36$ Expenditures: E05 Personnel Services 1,450,359.48$ 1,483,475.42$ 1,523,318.50$ 1,534,162.52$ 1,530,135.64$ 1,540,730.87$ 1,585,776.20$ 1,621,860.12$ 1,658,843.35$ 1,696,750.98$ 1,735,608.91$ E10 Materials & Supplies 239,746.86$ 187,677.87$ 206,583.65$ 262,081.08$ 266,692.96$ 231,380.00$ 215,247.00$ 219,551.94$ 223,942.98$ 228,421.84$ 232,990.28$ E15 Contractual Services 289,432.68$ 311,282.03$ 329,731.80$ 328,448.05$ 304,224.32$ 321,811.35$ 315,094.56$ 321,396.45$ 327,824.38$ 334,380.87$ 341,068.49$ E20 Utilities 28,839.60$ 24,690.04$ 23,360.76$ 28,459.17$ 29,013.85$ 29,800.00$ 29,800.00$ 30,396.00$ 31,003.92$ 31,624.00$ 32,256.48$ E25 Repairs & Maintenance 358,929.31$ 397,573.86$ 427,367.30$ 445,345.24$ 394,830.85$ 398,962.11$ 409,042.00$ 417,222.84$ 425,567.30$ 434,078.64$ 442,760.22$ E30 Other Operating Expenses -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ E65 Other Non-Operating Expenses 131,690.22$ 56,442.48$ -$ -$ -$ -$ -$ -$ -$ -$ -$ E70 Capital Purchases 8,116.10$ 33.00$ 19,024.80$ 53,041.29$ 75,413.42$ -$ -$ -$ -$ -$ -$ E79 Depreciation 465,885.75$ 458,143.56$ 396,925.79$ 297,357.41$ 155,413.85$ -$ -$ -$ -$ -$ -$ E80 Transfers Out -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 2,973,000.00$ 2,919,318.26$ 2,926,312.60$ 2,948,894.76$ 2,755,724.89$ 2,522,684.33$ 2,554,959.76$ 2,610,427.35$ 2,667,181.93$ 2,725,256.33$ 2,784,684.36$ (505,166.00)$ (138,894.26)$ (373,162.82)$ (115,656.24)$ (119,734.12)$ (60,239.00)$ (70,558.00)$ -$ -$ -$ -$ Fund Balance: 2,211,394.69$ 2,210,521.39$ 2,071,627.13$ 1,698,465.31$ 1,497,248.07$ 1,377,513.95$ 1,317,274.95$ 1,246,716.95$ 1,246,716.95$ 1,246,716.95$ 1,246,716.95$ 504,292.70$ 1.00$ (85,561.00)$ 2,210,521.39$ 2,071,627.13$ 1,698,465.31$ 1,497,248.07$ 1,377,513.95$ 1,317,274.95$ 1,246,716.95$ 1,246,716.95$ 1,246,716.95$ 1,246,716.95$ 1,246,716.95$ (1,554,915.41)$ (1,229,494.37)$ (943,954.62)$ (1,026,149.00)$ (918,201.76)$ (918,201.76)$ (918,201.76)$ (918,201.76)$ (918,201.76)$ (918,201.76)$ (918,201.76)$ (461,261.26)$ (419,282.51)$ (396,383.92)$ (281,238.00)$ (328,513.53)$ (328,513.53)$ (328,513.53)$ (328,513.53)$ (328,513.53)$ (328,513.53)$ (328,513.53)$ 194,344.72$ 422,850.25$ 358,126.77$ 189,861.07$ 130,798.66$ 70,559.66$ 1.66$ 1.66$ 1.66$ 1.66$ 1.66$ 7.99%16.85%14.26%7.49%4.75%2.80%0.00%0.00%0.00%0.00%0.00% Assumptions Unrestricted Fund Balance as a Percentage of Originally Adopted Expenditures Total Expenditures Net Increase (Decrease) in Fund Balance Add: Beginning Fund Balance Fund Balance Less: Capital Contributions Unrestricted Fund Balance Add: Prior Period Adjustments Less: Restricted for Pensions All expenditures are based on general fund tab assumptions WASTEWATER FUND LONG-RANGE FINANCIAL PLANNING City of Jefferson, Missouri 5 Year Forecast Model FY 2021 - 2025 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 Actual Actual Actual Actual Actual Adopted Projected Projected Projected Projected Projected Revenue: R50 Intergovernmental -$ -$ 22,463.32$ 52,475.64$ 39,753.22$ -$ -$ -$ -$ -$ -$ Percent Increase R60 Charges for Services 10,123,193.16$ 10,765,246.57$ 11,130,758.28$ 11,518,611.37$ 11,511,813.92$ 11,517,212.88$ 11,282,356.28$ 11,538,465.77$ 11,800,388.94$ 12,068,257.77$ 12,342,207.22$ Revenues 2.27% R65 Fees Licenses & Permits 31,985.00$ 36,096.00$ 40,608.00$ 44,251.00$ 50,531.40$ 37,748.16$ 33,228.00$ 33,982.28$ 34,753.67$ 35,542.58$ 36,349.40$ Expenditure R75 Other Operating Revenues (307.17)$ 55,066.84$ 741.48$ 1,627.87$ 26,510.61$ -$ -$ -$ -$ -$ -$ R80 Interest Income 1,212,307.95$ 1,108,334.32$ 1,095,193.15$ 969,270.59$ 869,553.20$ 745,000.00$ 598,652.32$ 598,652.32$ 598,652.32$ 598,652.32$ 598,652.32$ R85 Other Non-Operating Revenue 843,881.98$ 524,450.42$ 503,386.24$ 321,583.82$ 1,337,477.66$ 258,800.00$ -$ -$ -$ -$ -$ R90 Transfer In -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ R99 Carry Over Surplus -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Bond Proceeds Transfer From(to) Surplus Total Revenues 12,211,060.92$ 12,489,194.15$ 12,793,150.47$ 12,907,820.29$ 13,835,640.01$ 12,558,761.04$ 11,914,236.60$ 12,171,100.36$ 12,433,794.93$ 12,702,452.67$ 12,977,208.94$ 6.56%2.28%2.43%0.90%7.19% charges for services inc 6.19%6.34%3.40%3.48%-0.06% Expenditures: E05 Personnel Services 2,410,587.10$ 2,351,430.42$ 2,501,889.03$ 2,510,545.43$ 2,467,716.32$ 2,616,995.41$ 2,657,090.85$ 2,717,427.89$ 2,779,263.55$ 2,842,639.49$ 2,907,598.67$ E10 Materials & Supplies 414,960.26$ 456,514.93$ 396,224.45$ 578,932.37$ 751,102.23$ 647,605.23$ 451,127.02$ 460,149.56$ 469,352.55$ 478,739.60$ 488,314.39$ E15 Contractual Services 1,260,850.99$ 1,411,255.40$ 1,316,094.24$ 1,303,658.66$ 1,330,030.55$ 1,422,567.41$ 1,346,759.38$ 1,373,694.57$ 1,401,168.46$ 1,429,191.83$ 1,457,775.66$ E20 Utilities 577,353.15$ 550,147.59$ 550,665.34$ 533,000.52$ 568,030.06$ 607,067.50$ 436,665.40$ 445,398.71$ 454,306.68$ 463,392.82$ 472,660.67$ E25 Repairs & Maintenance 503,034.98$ 430,715.54$ 525,878.98$ 521,213.74$ 531,141.25$ 601,859.26$ 626,194.62$ 638,718.51$ 651,492.88$ 664,522.74$ 677,813.20$ E30 Other Operating Expenses -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ E65 Other Non-Operating Expense 75,000.00$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ E70 Capital Purchases 99,296.31$ 3,029.49$ 38,934.51$ 54,848.02$ 80,301.48$ 668,000.00$ 250,000.00$ 381,201.00$ 153,990.00$ 277,080.00$ 245,000.00$ E75 Capital Projects 139,717.89$ 495,215.77$ 504,961.22$ 34,649.05$ 1,084,224.62$ 676,000.00$ 260,000.00$ -$ -$ -$ -$ E79 Depreciation 2,876,257.21$ 3,012,854.56$ 3,478,919.94$ 3,565,989.49$ 3,734,348.74$ -$ -$ -$ -$ -$ -$ E90 Debt Service 2,062,291.02$ 2,095,877.05$ 1,915,808.94$ 2,101,422.31$ 1,923,454.35$ 6,033,223.99$ 6,060,185.32$ 6,060,185.32$ 6,060,185.32$ 6,060,185.32$ 6,060,185.32$ 10,419,348.91$ 10,807,040.75$ 11,229,376.65$ 11,204,259.59$ 12,470,349.60$ 13,273,318.80$ 12,088,022.59$ 12,076,775.56$ 11,969,759.44$ 12,215,751.79$ 12,309,347.92$ 1,791,712.01$ 1,682,153.40$ 1,563,773.82$ 1,703,560.70$ 1,365,290.41$ (714,557.76)$ (173,785.99)$ 94,324.81$ 464,035.49$ 486,700.88$ 667,861.02$ Fund Balance: 48,822,312.85$ 51,575,179.49$ 53,257,333.27$ 54,821,102.09$ 56,402,905.79$ 57,768,196.20$ 57,053,638.44$ 56,879,852.45$ 56,974,177.26$ 57,438,212.75$ 57,924,913.62$ 961,154.63$ 0.38$ (5.00)$ (121,757.00)$ 51,575,179.49$ 53,257,333.27$ 54,821,102.09$ 56,402,905.79$ 57,768,196.20$ 57,053,638.44$ 56,879,852.45$ 56,974,177.26$ 57,438,212.75$ 57,924,913.62$ 58,592,774.65$ (43,266,332.07)$ (45,367,530.10)$ (46,712,592.97)$ (48,516,586.00)$ (48,856,342.40)$ (48,856,342.40)$ (48,856,342.40)$ (48,856,342.40)$ (48,856,342.40)$ (48,856,342.40)$ (48,856,342.40)$ (2,835,383.42)$ (1,282,392.41)$ (1,342,722.27)$ (2,576,982.00)$ (2,520,933.36)$ (2,520,933.36)$ (2,520,933.36)$ (2,520,933.36)$ (2,520,933.36)$ (2,520,933.36)$ (2,520,933.36)$ (879,139.00)$ (807,541.45)$ (767,395.03)$ (598,011.00)$ (690,137.81)$ (690,137.81)$ (690,137.81)$ (690,137.81)$ (690,137.81)$ (690,137.81)$ (690,137.81)$ (3,086,056.10)$ (1,481,933.93)$ (2,110,562.64)$ (2,324,443.00)$ (2,221,290.47)$ (2,221,290.47)$ (2,221,290.47)$ (2,221,290.47)$ (2,221,290.47)$ (2,221,290.47)$ (2,221,290.47)$ 1,508,268.90$ 4,317,935.38$ 3,887,829.18$ 2,386,883.79$ 3,479,492.16$ 2,764,934.40$ 2,591,148.41$ 2,685,473.22$ 3,149,508.71$ 3,636,209.58$ 4,304,070.61$ 11.33%20.60%29.31%18.40%27.90%20.83%21.44%22.24%26.31%29.77%34.97% Assumptions Unrestricted Fund Balance as a Percentage of Originally Adopted Expenditures Less: Restricted Bond Funds Total Expenditures Net Increase (Decrease) in Fund Balance Add: Beginning Fund Balance Fund Balance Less: Capital Contributions Unrestricted Fund Balance Add/Less: Prior Period Adjustments Less: Restricted for Pensions Less: Restricted for Capital Projects All expenditures are based on general fund tab assumptions CITY OF JEFFERSON - GENERAL FUND ANALYSIS OF UNEXPENDED BUDGETED EXPENDITURES Over (Under)% Final Budget *Actual Expenditures Budget variance 2013 Totals 32,545,228.82$ 30,550,216.77$ (1,995,012.05)$ -6.13% 2014 Totals 32,462,618.93$ 31,220,020.89$ (1,242,598.04)$ -3.83% 2015 Totals 31,726,151.12$ 29,733,602.85$ (1,992,548.27)$ -6.28% 2016 Totals 32,841,290.51$ 30,984,506.35$ (1,856,784.16)$ -5.65% 2017 Totals 35,622,981.75$ 33,851,110.38$ (1,771,871.37)$ -4.97% 2018 Totals 35,992,521.73$ 33,859,108.26$ (2,133,413.47)$ -5.93% 2019 Totals 35,855,040.39$ 34,934,392.29$ (920,648.10)$ -2.57% Smallest Variance - 2019 35,855,040.39$ 34,934,392.29$ (920,648.10)$ -2.57% Largest Variance - 2015 31,726,151.12$ 29,733,602.85$ (1,992,548.27)$ -6.28% Median Variance 32,841,290.51$ 31,220,020.89$ (1,621,269.62)$ -5.65% 7 Year Average Variance 237,045,833.25$ 225,132,957.79$ (11,912,875.46)$ -5.03% 6 Year Average Variance 204,500,604.43$ 194,582,741.02$ (9,917,863.41)$ -4.85% 5 Year Average Variance 172,037,985.50$ 163,362,720.13$ (8,675,265.37)$ -5.04% 4 Year Average Variance 140,311,834.38$ 133,629,117.28$ (6,682,717.10)$ -4.76% 3 Year Average Variance 107,470,543.87$ 102,644,610.93$ (4,825,932.94)$ -4.49% 2 Year Average Variance 71,847,562.12$ 68,793,500.55$ (3,054,061.57)$ -4.25% NOTE: 2019 has an unusually small variance because of over $709,000 spending on tornado & flood * Final budget amounts were reduced by large projects or grants that increased the budget, but were not expended