Monthly Financial and Operating Report November 2022
Table of Contents General Fund 1 Sales Tax Funds Street Improvements Sales Tax Fund 2 Park Improvements Sales Tax Fund 3 Storm Water Sales Tax Fund 4 Police Public Safety Sales Tax Fund 5 Fire Protection Sales Tax Fund 6 Use Tax Funds Animal Shelter 7 Police 8 Property Tax Levy Funds Health Property Tax Levy 9 Parks and Recreation Property Tax Levy 10 Special Revenue Funds Tourism Fund 11 Independence Square Benefit District 12 Community Development Block Grant Fund 13 Rental Rehabilitation 14 License Surcharge 15 Grants 16 American Rescue Plan (ARP) 17 Enterprise Funds Power and Light 18 - 19 Water 20 - 21 Water Pollution Control 22 - 23 Events Center Debt Service 24 Internal Service Funds Central Garage 25 Staywell Health Care 26 Worker's Compensation 27 Risk Management 28 Finance & Support Services 29 Debt Service Fund Debt Service - Neighborhood Improvement Districts 30 Capital Improvement Funds Street Improvements Capital Project Fund 31 Revolving Public Improvements Capital Project Fund 32 Building and Other Improvements Capital Project Fund 33 Storm Drainage Capital Project Fund 34 Park Improvements Capital Project Fund 35 Private Purpose Expendable Trust Fund - Vaile Mansion 36 Independence Events Center CID 37 Crackerneck Creek TDD 38 Tax Increment Financing Summary 39 Santa Fe TIF 40 Hartman Heritage TIF 41 Drumm Farm TIF 42 Eastland TIF 43 North Independence TIF 44 Crackerneck Creek TIF 45 Old Landfill TIF 46 Trinity TIF 47 HCA TIF 48 Cinema East TIF 49 23rd & Noland Project 1 TIF 50 23rd & Noland Project 2 TIF 51 23rd & Noland Project 3 TIF 52 23th & Noland Project 4 TIF 53 Independence Square TIF 54 I-70 & Little Blue Parkway Project 1 TIF 55 I-70 & Little Blue Parkway Project 3 TIF 56 Marketplace Project 1 TIF 57 Marketplace Project 2 TIF 58 TIF Supplemental Appropriation Fund 59
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule General Fund
For the period ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Real Estate Tax $ 5,903,000 5,903,000 5,687,670 (215,330) 96.35% 54.68% Sales Tax 20,635,000 20,635,000 9,011,449 (11,623,551) 43.67% 2.00% Use Tax 535,000 535,000 (535,000) 0.00% -41.67% Cigarette Tax 380,000 380,000 134,352 (245,648) 35.36% -6.31% Franchise Tax 8,344,000 8,344,000 1,839,140 (6,504,860) 22.04% -19.63% Licenses and Permits 4,410,950 4,410,950 1,996,541 (2,414,409) 45.26% 3.59% Intergovernmental 5,810,000 5,810,000 2,646,062 (3,163,938) 45.54% 3.87% Charges for Current Services 1,955,400 1,956,400 747,381 (1,209,019) 38.20% -3.47% Interfund Charges for Support Services 2,354,600 2,354,600 981,083 (1,373,517) 41.67% 0.00% Fines and Forfeitures 2,156,000 2,156,000 924,432 (1,231,568) 42.88% 1.21% Investment Income (Loss) 220,000 220,000 46,645 (173,355) 21.20% -20.47% Other Revenue 750,400 750,400 130,631 (619,769) 17.41% -24.26% Total Revenues 53,454,350 53,455,350 24,145,386 (29,309,964) 45.17% 3.50% Other Financing Sources: Payments In Lieu of Taxes 20,848,787 20,848,787 9,772,364 (11,076,423) 46.87% 5.20% Transfers In 0.00% -41.67% Operating Transfers In - American Rescue Plan 0.00% -41.67% Total Other Financing Sources 20,848,787 20,848,787 9,772,364 (11,076,423) 46.87% 5.20% Total Revenues and Other Financing Sources 74,303,137 74,304,137 33,917,750 (40,386,387) 45.65% 3.98% Expenditures: City Council 686,729 686,729 295,096 391,633 42.97% 1.30% City Clerk 266,577 332,702 262,310 70,392 78.84% 37.17% City Manager 1,101,987 1,101,987 391,311 710,676 35.51% -6.16% Municipal Court 1,687,121 1,687,121 665,800 1,021,321 39.46% -2.21% Law 182,663 182,663 69,047 113,616 37.80% -3.87% Finance 626,644 627,644 576,925 50,719 91.92% 50.25% Community Development 5,387,456 5,387,456 2,471,218 2,916,238 45.87% 4.20% Police 34,273,528 34,273,528 14,343,488 19,930,040 41.85% 0.18% Fire 23,811,497 23,811,497 11,218,637 12,592,860 47.11% 5.44% Health 0.00% -41.67% Municipal Services (Public Works) 5,972,696 5,972,696 2,265,094 3,707,602 37.92% -3.75% Parks and Recreation 296,239 296,239 107,202 189,037 36.19% -5.48% Contingencies 0.00% -41.67% Debt service 0.00% -41.67% Total Expenditures 74,293,137 74,360,262 32,666,128 41,694,134 43.93% 2.26% Other Financing Uses: Transfers Out 10,000 10,000 158,412 (148,412) 1584.12% 1542.45% Total Expenditures and Other Financing Uses 74,303,137 74,370,262 32,824,540 41,545,722 44.14% 2.47% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (66,125) 1,093,210 1,159,335 Unassigned Fund Balance at Beginning of Year 6,281,728 Cancellation of prior year encumbrances 25,330 Change in other fund balance components during the year (224,948) Year-end investment market value adjustment Ending Unassigned Fund Balance, 11/30/22 7,175,320 Restricted 294,995 Committed 25,645 Assigned 2,037,630 Total Fund Balance $ 9,533,590
1
CITY
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Sales Taxes $ 9,715,000 9,715,000 4,224,644 (5,490,356) 43.49% 1.82% Use Tax 268,000 268,000 (268,000) 0.00% -41.67% Charges for Services 0.00% -41.67% Intergovernmental Revenue 220,213 220,213 0.00% -41.67% Investment Income (Loss) 77,000 77,000 174,444 97,444 226.55% 184.88% Other Revenue 0.00% -41.67% Total Revenues 10,060,000 10,060,000 4,619,301 (5,440,699) 45.92% 4.25% Other Financing Sources: Transfers in 0.00% -41.67% Total other financing sources 0.00% -41.67% Total revenues and other financing sources 10,060,000 10,060,000 4,619,301 (5,440,699) 45.92% 4.25% Expenditures: General Government 0.00% -41.67% Street Maintenance 1,265,081 1,265,081 535,246 729,835 42.31% 0.64% Capital Outlay 6,556,836 15,707,841 131,065 15,576,776 0.83% -40.84% Debt Service 1,744,200 1,744,200 217,074 1,527,126 12.45% -29.22% Total Expenditures 9,566,117 18,717,122 883,385 17,833,737 4.72% -36.95% Other Financing Uses: Transfers Out 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 9,566,117 18,717,122 883,385 17,833,737 4.72% -36.95% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 493,883 (8,657,122) 3,735,916 12,393,038 Unassigned Fund Balance at Beginning of Year (101,812) Cancellation of Prior Year Encumbrances 33,125 Change in Other Fund Balance Components During the Year 109,688 Year-end investment market value adjustment Ending Unassigned Fund Balance, 11/30/22 3,776,917 Fund Balance Components: Restricted - Current Year Encumbrances 367,065 Restricted - Prior Year Encumbrances 8,120,962 Restricted - Debt Reserve Project Accounts - Capital Projects 11,310,631 Total Fund Balance $ 23,575,575
Improvements Sales Tax Fund
the period ended November 30, 2022 2
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Street
For
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Park Improvements Sales Tax Fund For the period ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Sales Taxes $ 4,858,000 4,858,000 2,112,330 (2,745,670) 43.48% 1.81% Use Tax 134,000 134,000 (134,000) 0.00% -41.67% Charges for services 474,540 474,540 216,610 (257,930) 45.65% 3.98% Intergovernmental 88,500 88,500 22,132 (66,368) 25.01% -16.66% Investment Income (Loss) 59,180 59,180 22,627 (36,553) 38.23% -3.44% Other Revenue 7,500 7,500 23,172 15,672 308.96% 267.29% Total Revenues 5,621,720 5,621,720 2,396,871 (3,224,849) 42.64% 0.97% Other Financing Sources: Transfers In 0.00% -41.67% Transfers In - American Rescue Plan 0.00% -41.67% Proceeds from Bond Issuance/Capital Lease 0.00% -41.67% Total Other Financing Sources 0.00% -41.67% Total Revenues and Other Financing Sources 5,621,720 5,621,720 2,396,871 (3,224,849) 42.64% 0.97% Expenditures: Culture and Recreation 5,103,261 5,103,261 2,368,005 2,735,256 46.40% 4.73% Capital Outlay 993,000 1,875,283 488,519 1,386,764 26.05% -15.62% Debt Service 0.00% -41.67% Total Expenditures 6,096,261 6,978,544 2,856,524 4,122,020 40.93% -0.74% Other Financing Uses: Transfers Out 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 6,096,261 6,978,544 2,856,524 4,122,020 40.93% -0.74% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (474,541) (1,356,824) (459,653) 897,171 Unassigned Fund Balance at Beginning of Year 3,054,584 Cancellation of Prior Year Encumbrances 12,335 Change in Other Fund Balance Components During the Year 5,744 Year-end investment market value adjustment Ending Unassigned Fund Balance, 11/30/22 2,613,010 Other Fund Balance Components: Restricted - Current Year Encumbrances 799,663 Restricted - Prior Year Encumbrances 47,382 Total Fund Balance $ 3,460,055
3
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Storm
For the period ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Sales Taxes $ 4,858,000 4,858,000 2,112,330 (2,745,670) 43.48% 1.81% Use Tax 134,000 134,000 (134,000) 0.00% -41.67% Intergovernmental 0.00% -41.67% Investment Income (loss) 164,000 164,000 94,575 (69,425) 57.67% 16.00% Other Revenue 7,900 16,685 16,432 (253) 98.48% 56.81% Total revenues 5,163,900 5,172,685 2,223,337 (2,949,348) 42.98% 1.31% Expenditures: Storm water Administration 233,009 233,009 130,563 102,446 56.03% 14.36% Maintenance 2,684,530 2,693,315 934,673 1,758,642 34.70% -6.97% Permit completion 318,000 318,000 305,200 12,800 95.97% 54.30% Capital outlay 1,500,000 4,352,865 256,987 4,095,878 5.90% -35.77% Total Expenditures 4,735,539 7,597,189 1,627,423 5,969,766 21.42% -20.25% Other financing uses: Transfers out 0.00% -41.67% Total other financing uses 0.00% -41.67% Total Ependitures and Other Financing Uses 4,735,539 7,597,189 1,627,423 5,969,766 21.42% -20.25% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 428,361 (2,424,504) 595,914 3,020,418 Unassigned Fund Balance at Beginning of Year 9,615,450 Cancellation of Prior Year Encumbrances 723 Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 11/30/22 10,212,087 Other Fund Balance Components: Restricted - Current Year Encumbrances 539,663 Restricted - Prior Year Encumbrances 749,856 Restricted - Regional Detention Construction 120,524 Restricted - Regional Detention Maintenance 59,159 Restricted - Emergency Response Relief 500,000 Total Fund Balance $ 12,181,289
Water Sales Tax Fund
4
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Police Public Safety Sales Tax Fund
For the period ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Sales Taxes $ 2,580,000 2,580,000 1,137,767 (1,442,233) 44.10% 2.43% Use Tax 67,000 67,000 (67,000) 0.00% -41.67% Investment Income (Loss) 35,000 35,000 19,671 (15,329) 56.20% 14.53% Other Revenue 7,600 7,600 73,409 65,809 965.91% 924.24% Total Revenues 2,689,600 2,689,600 1,230,847 (1,458,753) 45.76% 4.09% Expenditures: Public Safety Communications 522,200 522,200 383,789 138,411 73.49% 31.82% Facilities 105,200 105,200 59,083 46,117 56.16% 14.49% Equipment 1,743,700 1,743,700 1,315,202 428,498 75.43% 33.76% Debt Service 393 (393) 0.00% -41.67% Total Expenditures 2,371,100 2,371,100 1,758,467 612,633 74.16% 32.49% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 2,371,100 2,371,100 1,758,467 612,633 74.16% 32.49% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 318,500 318,500 (527,620) (846,120) Unassigned Fund Balance at Beginning of Year 2,435,627 Cancellation of Prior Year Encumbrances 1,847 Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 11/30/22 1,909,854 Other Fund Balance Components: Restricted - Current Year Encumbrances 639,109 Restricted - Prior Year Encumbrances 171,484 Total Fund Balance $ 2,720,447
5
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Sales Taxes $ 8,770,000 8,770,000 4,521,383 (4,248,617) 51.56% 9.89% Use Tax 268,000 268,000 (268,000) 0.00% -41.67% Investment Income (Loss) 29,000 29,000 26,423 (2,577) 91.11% 49.44% Other Revenue 6,000 6,000 1,878 (4,122) 31.30% -10.37% Total Revenues 9,073,000 9,073,000 4,549,684 (4,523,316) 50.15% 8.48% Expenditures: Public Safety 6,821,786 7,812,662 3,062,815 4,749,847 39.20% -2.47% Debt Service 73,300 73,300 73,300 0.00% -41.67% Total Expenditures 6,895,086 7,885,962 3,062,815 4,823,147 38.84% -2.83% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 6,895,086 7,885,962 3,062,815 4,823,147 38.84% -2.83% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 2,177,914 1,187,038 1,486,869 299,831 Unassigned Fund Balance at Beginning of Year 1,854,972 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 11/30/22 3,341,841 Other Fund Balance Components: Restricted - Current Year Encumbrances 1,912,573 Restricted - Prior Year Encumbrances 215,612 Total Fund Balance $ 5,470,026
Comparison Schedule
Protection Sales Tax Fund For the period ended November 30, 2022 6
CITY OF INDEPENDENCE, MISSOURI Budgetary
Fire
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Animal Shelter Use Tax
For the period ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Use Tax $ 782,000 782,000 782,000 100.00% 58.33% Intergovernmental Revenue 0.00% -41.67% Investment Income (Loss) 3,000 3,000 5,328 2,328 177.60% 135.93% Other Revenue 0.00% -41.67% Total Revenues 785,000 785,000 787,328 2,328 100.30% 58.63% Expenditures: General Government 0.00% -41.67% Animal Services 769,213 769,213 292,216 476,997 37.99% -3.68% Capital Outlay 0.00% -41.67% Debt Service 0.00% -41.67% Total Expenditures 769,213 769,213 292,216 476,997 37.99% -3.68% Other Financing Uses: Transfers In 0.00% -41.67% Transfers Out 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 769,213 769,213 292,216 476,997 37.99% -3.68% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 15,787 15,787 495,112 479,325 Unassigned Fund Balance at Beginning of Year 207,703 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 11/30/22 702,815 Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 702,815
7
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Police Use Tax
For the period ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Use Tax $ 4,100,000 4,100,000 2,327,502 (1,772,498) 56.77% 15.10% Investment Income (Loss) 59,000 59,000 43,989 (15,011) 74.56% 32.89% Other Revenue 0.00% -41.67% Total Revenues 4,159,000 4,159,000 2,371,491 (1,787,509) 57.02% 15.35% Expenditures: Public Safety 4,029,166 4,095,616 1,533,660 2,561,956 37.45% -4.22% Debt Service 0.00% -41.67% Total Expenditures 4,029,166 4,095,616 1,533,660 2,561,956 37.45% -4.22% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 4,029,166 4,095,616 1,533,660 2,561,956 37.45% -4.22% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 129,834 63,384 837,831 774,447 Unassigned Fund Balance at Beginning of Year 4,586,138 Cancellation of Prior Year Encumbrances 88,102 Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 11/30/22 5,512,071 Other Fund Balance Components: Restricted - Current Year Encumbrances 151,437 Restricted - Prior Year Encumbrances 258,350 Total Fund Balance $ 5,921,858
8
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule Health Property Tax Levy For the period ended November 30, 2022 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Taxes $ 881,500 881,500 856,918 (24,582) 97.21% 55.54% Charges for Services 154,500 154,500 69,027 (85,473) 44.68% 3.01% Licenses & Permits 392,238 392,238 190,721 (201,517) 48.62% 6.95% Investment Income (Loss) 3,731 3,731 2,934 (797) 78.64% 36.97% Other Revenue 14,000 14,000 3,820 (10,180) 27.29% -14.38% Total Revenues 1,445,969 1,445,969 1,123,420 (322,549) 77.69% 36.02% Other Financing Sources: Transfers In 0.00% -41.67% Transfers In - American Rescue Plan 300,000 300,000 300,000 100.00% 58.33% Total Other Financing Uses 300,000 300,000 300,000 100.00% 58.33% Total Revenues and Other Sources 1,745,969 1,745,969 1,423,420 (322,549) 81.53% 39.86% Expenditures: Animal Services 1,045,512 1,045,512 391,492 654,020 37.45% -4.22% Health Services 733,636 733,636 289,337 444,299 39.44% -2.23% Total Expenditures 1,779,148 1,779,148 680,829 1,098,319 38.27% -3.40% Other Financing Uses: Transfers Out 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Uses 1,779,148 1,779,148 680,829 1,098,319 38.27% -3.40% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (333,179) (333,179) 742,591 1,075,770 Unassigned Fund Balance at Beginning of Year 164,970 Cancellation of Prior Year Encumbrances 752 Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 11/30/22 908,313 Other Fund Balance Components: Restricted - Current Year Encumbrances 12,817 Restricted - Prior Year Encumbrances 2 Total Fund Balance $ 921,132
9
CITY OF INDEPENDENCE, MISSOURI
Comparison Schedule Parks and Recreation Property Tax Levy For the period ended November 30, 2022 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Taxes $ 1,876,775 1,876,775 1,820,950 (55,825) 97.03% 55.36% Intergovernmental 0.00% -41.67% Charges for Services 120,650 120,650 35,777 (84,873) 29.65% -12.02% Investment Income (Loss) 19,165 19,165 5,195 (13,970) 27.11% -14.56% Other Revenue 5,287 5,287 0.00% -41.67% Total Revenues 2,016,590 2,016,590 1,867,209 (149,381) 92.59% 50.92% Expenditures: Parks and Recreation 2,554,180 2,554,180 1,130,117 1,424,063 44.25% 2.58% Total Expenditures 2,554,180 2,554,180 1,130,117 1,424,063 44.25% 2.58% Other Financing Uses – Transfers Out 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Uses 2,554,180 2,554,180 1,130,117 1,424,063 44.25% 2.58% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (537,590) (537,590) 737,092 1,274,682 Unassigned Fund Balance at Beginning of Year 581,332 Cancellation of Prior Year Encumbrances 444 Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 11/30/22 1,318,868 Other Fund Balance Components: Restricted - Current Year Encumbrances 81,865 Restricted - Prior Year Encumbrances Total Fund Balance $ 1,400,733 10
Budgetary
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule Tourism Fund For the period ended November 30, 2022 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Transient Guest Taxes $ 1,975,000 1,975,000 1,061,122 (913,878) 53.73% 12.06% Charges for Services 32,000 32,000 12,186 (19,814) 38.08% -3.59% Investment Income (Loss) 25,050 25,050 16,298 (8,752) 65.06% 23.39% Other Revenue 12,050 12,050 5,509 (6,541) 45.72% 4.05% Total Revenues 2,044,100 2,044,100 1,095,115 (948,985) 53.57% 11.90% Other Financing Sources: Transfers In - American Resuce Plan 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Revenues and Other Sources 2,044,100 2,044,100 1,095,115 (948,985) 53.57% 11.90% Expenditures: Tourism 2,709,247 3,339,449 654,094 2,685,355 19.59% -22.08% Total Expenditures 2,709,247 3,339,449 654,094 2,685,355 19.59% -22.08% Other Financing Uses – Transfers Out 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Uses 2,709,247 3,339,449 654,094 2,685,355 19.59% -22.08% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (665,147) (1,295,349) 441,021 1,736,370 Unassigned Fund Balance at Beginning of Year 1,178,234 Cancellation of Prior Year Encumbrances 444 Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 11/30/22 1,619,699 Other Fund Balance Components: Restricted - Current Year Encumbrances 126,552 Restricted - Prior Year Encumbrances 109,442 Restricted - Operating Reserve 376,368 Total Fund Balance $ 2,232,061
11
Independence Square Benefit District For the period ended November 30, 2022 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Taxes $ 26,384 26,384 0.00% -41.67% Investment Income (Loss) 194 194 0.00% -41.67% Other Revenue 0.00% -41.67% Total Revenues 26,578 26,578 0.00% -41.67% Expenditures: Capital Outlay 422 (422) 0.00% -41.67% Total Expenditures 422 (422) 0.00% -41.67% Other Financing Uses – Transfers Out 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Uses 422 (422) 0.00% -41.67% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 26,156 26,156 Unassigned Fund Balance at Beginning of Year 8,365 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 11/30/22 34,521 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 34,521 12
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
CITY OF INDEPENDENCE, MISSOURI Budgetary
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Federal Grant - CDBG $ 800,000 800,000 127,034 (672,966) 15.88% -25.79% Other Revenue -41.67% Total Revenues 800,000 800,000 127,034 (672,966) 15.88% -25.79% Expenditures: CDBG Administration 160,000 160,000 73,274 86,726 45.80% 4.13% CDBG Expenditures 640,000 640,000 640,000 0.00% -41.67% Total Expenditures 800,000 800,000 73,274 726,726 9.16% -32.51% Other Financing Uses: Transfers Out 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Uses 800,000 800,000 73,274 726,726 9.16% -32.51% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 53,760 53,760 Unassigned Fund Balance at Beginning of Year (367,215) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 11/30/22 (313,455) Other Fund Balance Components: Restricted - Current Year Encumbrances 7,302 Restricted - Prior Year Encumbrances 305,416 Total Fund Balance $ (737)
Schedule Community Development Block Grant Fund For the period ended November 30, 2022 13
Comparison
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Rental Rehabilitation
For the period ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: HOME Program Grant $ 465,330 499,770 212,476 (287,294) 42.51% 0.84% Total Revenues 465,330 499,770 212,476 (287,294) 42.51% 0.84% Expenditures: HOME Administration 46,533 80,973 53,425 27,548 65.98% 24.31% Multi Family Housing 325,730 325,730 325,730 0.00% -41.67% Community Housing Development 93,067 93,067 93,067 0.00% -41.67% Total Expenditures 465,330 499,770 53,425 446,345 10.69% -30.98% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 159,051 159,051 Unassigned Fund Balance at Beginning of Year (270,135) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 11/30/22 (111,084) Other Fund Balance Components: Restricted - Current Year Encumbrances 34,440 Restricted - Prior Year Encumbrances 76,651 Total Fund Balance $ 7
14
CITY OF INDEPENDENCE, MISSOURI
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Licenses and Permits $ (2,334) (2,334) 0.00% -41.67% Investment Income (Loss) 21,000 21,000 9,820 (11,180) 46.76% 5.09% Other Revenue 0.00% -41.67% Total Revenues 21,000 21,000 7,486 (13,514) 35.65% -6.02% Expenditures: General Government 197 (197) 0.00% -41.67% Total expenditures 197 (197) 0.00% -41.67% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 197 (197) 0.00% -41.67% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 21,000 21,000 7,289 (13,711) Unassigned Fund Balance at Beginning of Year 1,170,147 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 11/30/22 1,177,436 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 1,177,436
Comparison Schedule License Surcharge For the period ended November 30, 2022 15
Budgetary
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Grants For the period ended
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Intergovernmental $ 2,311,280 6,878,808 1,027,445 (5,851,363) 14.94% -26.73% Charges for Services 109,023 109,023 77,150 (31,873) 70.76% 29.09% Other Revenue 140,620 184 (140,436) 0.13% -41.54% Total Revenues 2,420,303 7,128,451 1,104,779 (6,023,672) 15.50% -26.17% Other financing sources: Transfers In 0.00% -41.67% Total other financing sources 0.00% -41.67% Total revenues and other financing sources 2,420,303 7,128,451 1,104,779 (6,023,672) 15.50% -26.17% Expenditures: Public Safety 640,270 2,751,513 792,204 1,959,309 28.79% -12.88% General Government 27,892 108,713 11,265 97,448 10.36% -31.31% Culture and Recreation 82,434 26,187 56,247 31.77% -9.90% Community Development 940,000 1,995,670 1,150,129 845,541 57.63% 15.96% Animal Services 9,769 9,769 0.00% -41.67% Health Services 465,497 1,614,144 181,672 1,432,472 11.26% -30.41% Total Expenditures 2,073,659 6,562,243 2,161,457 4,400,786 32.94% -8.73% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 2,073,659 6,562,243 2,161,457 4,400,786 32.94% -8.73% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 346,644 566,208 (1,056,678) (1,622,886) Unassigned Fund Balance at Beginning of Year (227,386) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year (5,744) Ending Unassigned Fund Balance, 11/30/22 (1,289,808) Other Fund Balance Components: Restricted - Current Year Encumbrances 849,768 Restricted - Prior Year Encumbrances 166,900 Total Fund Balance $ (273,140)
2022 16
November 30,
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule American Rescue Plan (ARP) For the period ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Intergovernmental $ 9,557,038 9,557,038 4,509,521 (5,047,517) 47.19% 5.52% Charges for Services 0.00% -41.67% Other Revenue 0.00% -41.67% Total Revenues 9,557,038 9,557,038 4,509,521 (5,047,517) 47.19% 5.52% Other financing sources: Transfers in 0.00% -41.67% Total other financing sources 0.00% -41.67% Total revenues and other financing sources 9,557,038 9,557,038 4,509,521 (5,047,517) 47.19% 5.52% Expenditures: Personnel Services 110,000 110,000 15,427 94,573 14.02% -27.65% Other Services 1,112,038 1,112,038 284,570 827,468 25.59% -16.08% Supplies 0.00% -41.67% Capital Outlay 4,135,000 4,135,000 416,970 3,718,030 10.08% -31.59% Total Expenditures 5,357,038 5,357,038 716,967 4,640,071 13.38% -28.29% Other Financing Uses: Transfers Out - American Rescue Plan 4,200,000 4,200,000 4,200,000 100.00% 58.33% Total Other Financing Uses 4,200,000 4,200,000 4,200,000 100.00% 58.33% Total Expenditures and Other Financing Uses 9,557,038 9,557,038 4,916,967 4,640,071 51.45% 9.78% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (407,446) (407,446) Unassigned Fund Balance at Beginning of Year (228,013) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 11/30/22 (635,459) Other Fund Balance Components: Restricted - Current Year Encumbrances 504,740 Restricted - Prior Year Encumbrances 130,719 Total Fund Balance $
17
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Power and Light
For the period ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Operating Revenues: Charges for Services $ 131,606,000 131,606,000 65,307,744 (66,298,256) 49.62% 7.95% Penalties 1,000,000 1,000,000 739,507 (260,493) 73.95% 32.28% Connection Charges 33,000 33,000 2,790 (30,210) 8.45% -33.22% Miscellaneous 24,818 24,818 0.00% -41.67% Temporary Service 1,000 1,000 450 (550) 45.00% 3.33% Rental Income 276,000 276,000 18,439 (257,561) 6.68% -34.99% Transmission Wheeling 7,000,000 7,000,000 2,075,674 (4,924,326) 29.65% -12.02% Total Operating Revenues 139,916,000 139,916,000 68,169,422 (71,746,578) 48.72% 7.05% Operating Expenses: Personnel Services 30,189,037 30,189,037 11,742,723 18,446,314 38.90% -2.77% Other Services 26,956,585 26,956,585 17,513,304 9,443,281 64.97% 23.30% Supplies 55,603,355 55,603,355 27,701,698 27,901,657 49.82% 8.15% Capital Projects 5,305,000 12,168,601 1,456,071 10,712,530 11.97% -29.70% Capital Operating 1,400,225 1,400,225 436,484 963,741 31.17% -10.50% Debt Service 7,896,466 7,896,466 2,361,968 5,534,498 29.91% -11.76% Other Expenses 100,000 100,000 100,000 0.00% -41.67% Total Operating Expenses 127,450,668 134,314,269 61,212,248 73,102,021 45.57% 3.90% Nonoperating Revenues (Expenses): Investment Income 118,000 118,000 480,723 362,723 407.39% 365.72% Interfund Charges for Support Services 2,011,000 2,011,000 873,921 (1,137,079) 43.46% 1.79% Miscellaneous Revenue (Expense) 15,700 15,700 226,313 210,613 1441.48% 1399.81% Total Nonoperating Revenue (Expenses) 2,144,700 2,144,700 1,580,957 (563,743) 73.71% 32.04% 14,610,032 7,746,431 8,538,131 791,700 110.22% 68.55% Capital Contributions 0.00% -41.67% Transfers Out – Utility Payments In Lieu of Taxes (13,000,000) (13,000,000) (6,762,849) (6,237,151) 52.02% 10.35% Transfers In 0.00% -41.67% Transfers Out 0.00% -41.67% Total Transfers (13,000,000) (13,000,000) (6,762,849) (6,237,151) 52.02% 10.35% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 1,610,032 (5,253,569) 1,775,282 7,028,851 Beginning Available Resources 49,405,589 Prior Period Adjustment Year-End Investment Market Value Adjustment Ending Available Resources 51,180,871 Revenue Risk 5,300,000 Capital Reserve 3,000,000 Expense Risk 18,700,000 Working Capital 25,500,000 Targeted Reserve Level 52,500,000 Total Non-Restricted Resources Available $ (1,319,129) Income (Loss) Before Transfers
18
Power and Light - Open Capital Projects
As of November 30, 2022
PROJECT PROJECT TITLE ORIGINAL BUDGET NET BUDGET AMENDMENTS REVISED BUDGET ENCUMBRANCES ACTUALS AVAILABLE BUDGET 200815 T&D Sys IMPROVEMENTS $ - 833,939.48 833,939.48 921.36 - 833,018.12 200824 Prod Plt MISC PROJECTS - 68,257.76 68,257.76 - - 68,257.76 200828 FIBER OPTIC PROGRAM - 198,999.72 198,999.72 44,483.75 98,950.76 55,565.21 201106 69 KV SUBSTATION FACILITIES - 321,078.50 321,078.50 26,893.81 56,592.75 237,591.94 201405 SUBSTATION SECURITY PROJECT - 235,149.64 235,149.64 30,534.00 - 204,615.64 201509 NEW BILLING Sys - 22,047.36 22,047.36 - - 22,047.36 201510 Sys OpS / DISPATCH - 44,634.77 44,634.77 35,030.50 - 9,604.27 201603 69 KV Trans LINE REBUIL - 1,356,365.47 1,356,365.47 659,291.75 7,757.00 689,316.72 201604 Sys OpS / UPS UPGRAD - 45,493.59 45,493.59 - - 45,493.59 201605 Sys OpS WORK AREA - 619,842.18 619,842.18 - - 619,842.18 201606 NEW FINANCIAL MANAGEMENT SYS - 200,000.00 200,000.00 - - 200,000.00 201702 Prod FACILITIES IMPROVE - 475,477.00 475,477.00 19,279.00 152,368.00 303,830.00 201703 BV GROUND WATER - 369,648.98 369,648.98 43,920.69 38,143.27 287,585.02 201706 SUBSTATION K SWITCHGEAR & - 963,211.67 963,211.67 205,962.46 750,333.75 6,915.46 201707 MASTER PLAN-FUTURE GENERATIO - 32,500.00 32,500.00 - - 32,500.00 201710 Mo CITY DIVESTITURE - 450,681.26 450,681.26 392,329.67 58,351.09 0.50 201804 SUBSTATION E SWITCHGEAR REPLACEMENT - 5,237,618.51 5,237,618.51 3,076,902.77 51,778.60 2,108,937.14 202004 Above Ground Fuel Storage Tanks - 41,800.00 41,800.00 - - 41,800.00 202101 Substation Fiber Optic Network - 913,263.62 913,263.62 17,925.00 75,078.73 820,259.89 202102 Traffic Controller Upgrades - 66,000.00 66,000.00 9,658.00 - 56,342.00 202103 Traffic Camera System Upgrades - 51,837.00 51,837.00 - - 51,837.00 202107 Motorola APX Radio Purchase Phase 2 - 67,716.89 67,716.89 - - 67,716.89 202108 Operations APC UPS Battery Replace - 110,000.00 110,000.00 - 10,300.00 99,700.00 202110 20MVAR Capacitor Bank Sub A - 520,726.57 520,726.57 163,065.05 203,460.73 154,200.79 202111 Transmission Pole Replacement Prog - 888,487.14 888,487.14 321,858.64 - 566,628.50 202201 Substation A Transformer T-9 Mtce - 180,000.00 180,000.00 - - 180,000.00 202204 Relay Test Set - 80,103.50 80,103.50 - 80,103.50202205 Desert Storm Switchgear Cabinets - 500,000.00 500,000.00 - - 500,000.00 202206 T & D Road Improvement Projects 500,000.00 - 500,000.00 - - 500,000.00 202208 Traffic Signal Detection Systems - 26,235.00 26,235.00 - - 26,235.00 202210 IPL Service Center PBX Upgrade to I - 85,000.00 85,000.00 - - 85,000.00 202211 H-5 Hot Gas Path Inspection - 1,170,634.91 1,170,634.91 327,461.00 917,017.91 (73,844.00) 202304 Controls Software Upgrade - 500,000.00 500,000.00 451,694.00 - 48,306.00 202305 PLSC Operations Area HVAC Upgrade - 100,000.00 100,000.00 - - 100,000.00 202306 Substation A Blockhouse Roof Repl 75,000.00 - 75,000.00 49,978.00 - 25,022.00 202307 Emergent Maintenance Production 500,000.00 - 500,000.00 - - 500,000.00 202308 Substn & Trans Upgrade &Replacement 400,000.00 - 400,000.00 4,603.29 - 395,396.71 202316 Construct 6 New Dist Feeders Sub S 450,000.00 - 450,000.00 120,101.00 - 329,899.00 9669 SERVICE CTR FACILITY IMPROVE. - 520,084.17 520,084.17 7,174.50 - 512,909.67 $ 1,925,000.00 17,296,834.69 19,221,834.69 6,009,068.24 2,500,236.09 10,712,530.36 Current Year Prior Year Budget Budget (Enc Roll) Total Budget 12,168,601.36 $ 7,053,233.33 19,221,834.69 Less Expenditures 148,148.63 2,352,087.46 2,500,236.09 Less Encumbrances 1,307,922.37 4,701,145.87 6,009,068.24 Total Available 10,712,530.36 $ - 10,712,530.36
19
CITY OF
INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule Water
For the period ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Operating Revenues: Charges for Services $ 32,165,000 32,165,000 15,386,711 (16,778,289) 47.84% 6.17% Penalties 100,000 100,000 134,822 34,822 134.82% 93.15% Connection/Disconnection Charges 12,000 12,000 9,937 (2,063) 82.81% 41.14% Miscellaneous 10,000 10,000 9,882 (118) 98.82% 57.15% Returned Check Charges 23,000 23,000 12,465 (10,535) 54.20% 12.53% Rental Income 85,000 85,000 77,870 (7,130) 91.61% 49.94% Meter Repairs 0.00% -41.67% Merchandising Jobbing 4,098 4,098 0.00% -41.67% Total Operating Revenues 32,395,000 32,395,000 15,635,785 (16,759,215) 48.27% 6.60% Operating expenses: Personnel Services 10,010,673 10,010,673 3,585,274 6,425,399 35.81% -5.86% Other Services 13,703,182 13,703,182 4,611,317 9,091,865 33.65% -8.02% Supplies 2,840,700 2,840,700 2,090,520 750,180 73.59% 31.92% Capital Projects 7,800,000 22,584,919 4,896,986 17,687,933 21.68% -19.99% Capital Operating 1,134,500 1,134,500 340,816 793,684 30.04% -11.63% Debt Service 2,526,400 2,526,400 2,109,161 417,239 83.48% 41.81% Other Expenses 50,000 50,000 50,000 0.00% -41.67% Total Operating Expenses 38,065,455 52,850,374 17,634,074 35,216,300 33.37% -8.30% Nonoperating Revenues (Expenses): Investment Income 657,138 657,138 440,130 (217,008) 66.98% 25.31% Interfund Charges for Support Services 3,300,500 3,300,500 1,399,674 (1,900,826) 42.41% 0.74% Miscellaneous Revenue (Expense) 16,700 16,700 28,509 11,809 170.71% 129.04% Total Nonoperating Revenue (Expenses) 3,974,338 3,974,338 1,868,313 (2,106,025) 47.01% 5.34% (1,696,117) (16,481,036) (129,976) 16,351,060 0.79% -40.88% Transfers Out – Utility Payments In Lieu of Taxes (2,941,000) (2,941,000) (1,495,251) (1,445,749) 50.84% 9.17% Transfers In 0.00% -41.67% Transfers Out 0.00% -41.67% Total Transfers (2,941,000) (2,941,000) (1,495,251) (1,445,749) 50.84% 9.17% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (4,637,117) (19,422,036) (1,625,227) 17,796,809 Beginning Available Resources 48,655,139 Year-End Investment Market Value Adjustment Ending Available Resources 47,029,912 Revenue Risk 2,000,000 Capital Reserve 6,100,000 Expense Risk 700,000 Working Capital 5,600,000 Targeted Reserve Level 14,400,000 Total Non-Restricted Resources Available $ 32,629,912 Income (Loss) Before Transfers
20
Water - Open Capital Projects
As of November 30, 2022
PROJECT PROJECT TITLE ORIGINAL BUDGET NET BUDGET AMENDMENTS REVISED BUDGET ENCUMBRANCES ACTUALS AVAILABLE BUDGET 400708 TREATMENT Plt DISCHARGE $ - 300,000.00 300,000.00 86,656.89 11,343.11 202,000.00 400904 EAST INDEPENDENCE INDUST PARK - 674,000.00 674,000.00 - - 674,000.00 401003 FUTURE Prod WELLS 500,000.00 962,596.00 1,462,596.00 25.00 245.00 1,462,326.00 401301 23RD ST MAIN REPLACEMENT - 311,672.57 311,672.57 2,811.00 - 308,861.57 401402 LAGOON CLEANOUT - 24,559.00 24,559.00 15,000.00 34,059.00 (24,500.00) 401505 Dist Sys IMPROVE - 244,781.00 244,781.00 - - 244,781.00 401506 TRUMAN ROAD BOOSTER STATION - 106,569.52 106,569.52 - - 106,569.52 401601 FILTER BACKWASH OUTFALL - 190,325.00 190,325.00 - - 190,325.00 401602 Plt DISCHARGE OUTFALL - 459,824.48 459,824.48 - - 459,824.48 401605 COURTNEY BEND BASIN CATWALK - 10,020.00 10,020.00 - - 10,020.00 401608 LIME SILO - 4,249,256.24 4,249,256.24 3,854,756.84 15,977.00 378,522.40 401703 Maint BUILDING AT CBP - 200,000.00 200,000.00 - - 200,000.00 401704 VAN HORN RESERVOIR IMPROVE - (49,699.58) (49,699.58) - - (49,699.58) 401802 6" Main Replacement James Downey Rd - 250,087.60 250,087.60 - - 250,087.60 401804 Filter Valve House Roof Improvement - 97,292.00 97,292.00 - - 97,292.00 401808 VFD Drive Replacements HSP 2 & 4 - 230,967.00 230,967.00 - - 230,967.00 401818 30" Steel Transmission Main Assess - 156,300.00 156,300.00 - - 156,300.00 401821 Main Replacement-32nd/Hunter/Bird - 91,000.00 91,000.00 - - 91,000.00 401822 Main Replacement-24Hwy/Northern/RR - 240,166.00 240,166.00 - - 240,166.00 402002 39th Street Reservoir - 2,170,212.30 2,170,212.30 1,098,004.30 1,100.90 1,071,107.10 402004 Main Replace Walnut/Leslie/LeesSumm - 81,218.73 81,218.73 - - 81,218.73 402007 Courtney Bend Emergency Generator - 1,150,000.00 1,150,000.00 - - 1,150,000.00 402008 Wellfield Overhead Electrical Imp - 1,000,000.00 1,000,000.00 - - 1,000,000.00 402009 Main Replace Sheley/Claremont/Norw - 188,790.00 188,790.00 - - 188,790.00 402010 Main Replace Gudgell/Dodgion/KingsH - 697,170.77 697,170.77 131,233.27 454,927.50 111,010.00 402011 Main Replace Salisbury/Peck/Geospac - 1,179,100.00 1,179,100.00 1,050,000.00 - 129,100.00 402012 College Avenue Improvements - 250,000.00 250,000.00 - - 250,000.00 402101 Main Replacement Ralston 31st/29th - 364,255.00 364,255.00 329,948.30 2,398.20 31,908.50 402102 Main Replacement 3rd St & Jennings - 440,798.00 440,798.00 2,392.50 2,392.50 436,013.00 402103 Main Replacement Truman Road - 540,502.00 540,502.00 492,008.00 6,332.00 42,162.00 402104 Lime Slaker No 5 - 350,000.00 350,000.00 - - 350,000.00 402105 Main Replacement Sheley - 98,565.00 98,565.00 2,334.68 7,000.82 89,229.50 402106 Main Replacement Sheley & Northern - 1,017,766.50 1,017,766.50 533,171.72 25,456.28 459,138.50 402107 Facility Improvements/Const/Maint 1,500,000.00 250,000.00 1,750,000.00 100,000.00 - 1,650,000.00 402108 Basin Drive Improvements - 340,523.00 340,523.00 - - 340,523.00 402201 Roof Improvements - 250,000.00 250,000.00 32,260.00 237,240.00 (19,500.00) 402203 Lime Slaker No 1 - 350,000.00 350,000.00 - - 350,000.00 402207 CB Electrical Switchgear Improvemen - 200,000.00 200,000.00 - - 200,000.00 402301 IT Infrastructure Upgrade 150,000.00 - 150,000.00 121,431.75 - 28,568.25 402302 HSPS HVAC Improvements 250,000.00 - 250,000.00 - - 250,000.00 402303 Lime Silo Recoating 400,000.00 - 400,000.00 - - 400,000.00 9749 MAIN REPLACEMENT PROGRAM - 3,794,153.67 3,794,153.67 170,210.70 220,425.70 3,403,517.27 9952 SECURITY UPGRADES - 517,590.82 517,590.82 14,953.82 36,332.64 466,304.36 $ 2,800,000.00 23,980,362.62 26,780,362.62 8,037,198.77 1,055,230.65 17,687,933.20 Current Year Prior Year Budget Budget (Enc Roll) Total Budget 22,584,918.85 $ 4,195,443.77 26,780,362.62 Less Expenditures 15,121.51 1,040,109.14 1,055,230.65 Less Encumbrances 4,881,864.14 3,155,334.63 8,037,198.77 Total Available 17,687,933.20 $ - 17,687,933.20
21
CITY OF INDEPENDENCE, MISSOURI Budgetary
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Operating revenues: Charges for Services $ 35,821,585 35,821,585 15,129,652 (20,691,933) 42.24% 0.57% Penalties 200,000 200,000 133,172 (66,828) 66.59% 24.92% Total operating revenues 36,021,585 36,021,585 15,262,824 (20,758,761) 42.37% 0.70% Operating expenses: Personnel Services 7,144,986 7,144,986 2,573,202 4,571,784 36.01% -5.66% Other Services 15,594,591 15,594,591 4,784,895 10,809,696 30.68% -10.99% Supplies 1,285,100 1,285,100 390,946 894,154 30.42% -11.25% Capital Projects 1,750,000 14,137,113 359,423 13,777,690 2.54% -39.13% Capital Operating 593,000 593,000 222,158 370,842 37.46% -4.21% Debt Service 6,239,100 6,239,100 4,671,201 1,567,899 74.87% 33.20% Other Expenses 0.00% -41.67% Total Operating Expenses 32,606,777 44,993,890 13,001,825 31,992,065 28.90% -12.77% Nonoperating Revenues (Expenses): Investment Income 326,000 326,000 287,193 (38,807) 88.10% 46.43% Miscellaneous Revenue (Expense) 7,900 7,900 40,645 32,745 514.49% 472.82% Total Nonoperating Revenue (Expenses) 333,900 333,900 327,838 (6,062) 98.18% 56.51% 3,748,708 (8,638,405) 2,588,837 11,227,242 -29.97% -71.64% Transfers Out – Utility Payments In Lieu of Taxes (3,596,612) (3,596,612) (1,514,264) (2,082,348) 42.10% 0.43% Transfers In 10,000 10,000 10,000 100.00% 58.33% Transfers Out 0.00% -41.67% Total Transfers (3,586,612) (3,586,612) (1,504,264) (2,082,348) 41.94% 0.27% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 162,096 (12,225,017) 1,084,573 13,309,590 Beginning Available Resources 31,326,433 Year-End Investment Market Value Adjustment Ending Available Resources 32,411,006 Revenue Risk 1,200,000 Capital Reserve 4,000,000 Expense Risk 700,000 Working Capital 6,800,000 Targeted Reserve Level 12,700,000 Total Non-Restricted Resources Available $ 19,711,006 Income (Loss) Before Transfers
Comparison Schedule Sanitary Sewer For the period ended November 30, 2022 22
Sanitary Sewer - Open Capital Projects
As of November 30, 2022
PROJECT PROJECT TITLE ORIGINAL BUDGET NET BUDGET AMENDMENTS REVISED BUDGET ENCUMBRANCES ACTUALS AVAILABLE BUDGET 300801 NEIGHBORHOOD PROJECTS $ - 476,466.48 476,466.48 - - 476,466.48 301201 BURR OAK EAST - 1,035,327.15 1,035,327.15 - - 1,035,327.15 301202 CRACKERNECK-VAN HOOK SEWER - 529,163.59 529,163.59 - - 529,163.59 301603 RCTP FACILITIES ROOF, CEILING - 170,925.00 170,925.00 - - 170,925.00 301701 SCADA UPGRADE - 139,743.08 139,743.08 60,549.33 - 79,193.75 301703 ARROWHEAD CENTER - 169,828.06 169,828.06 - - 169,828.06 301705 16TH/SCOTT - 357,362.29 357,362.29 5,390.10 - 351,972.19 301706 TREATMENT FACILITY IMPROVEMENT - 369,539.84 369,539.84 4,682.20 60,171.64 304,686.00 301804 ROCK CREEK EFFLUENT STRUCTURE - 332,776.94 332,776.94 2,447.87 8,734.73 321,594.34 301806 Neighborhood Improvements 2018-19 - 513,781.95 513,781.95 - - 513,781.95 302001 Fairmount Highlands - 170,000.00 170,000.00 - - 170,000.00 302002 Arlington Improvements - 100,000.00 100,000.00 - - 100,000.00 302003 Bison Park - 107,079.84 107,079.84 39,091.14 32,423.47 35,565.23 302004 Neighborhood Projects 2019-20 - 580,000.00 580,000.00 12,135.00 - 567,865.00 302005 Biosolids Handling - 2,397,533.81 2,397,533.81 737,193.57 582,327.46 1,078,012.78 302006 Raw Pumps & Screening - 900,000.00 900,000.00 15,723.30 304,997.29 579,279.41 302007 Electrical Substation Rehab - 158,690.00 158,690.00 29,351.00 - 129,339.00 302008 RCTP Fence - 33,950.24 33,950.24 - - 33,950.24 302009 Truman & Harris - 50,000.00 50,000.00 - - 50,000.00 302101 Sanitation Sewer Evaluation Survey - 106,982.83 106,982.83 21,301.63 - 85,681.20 302102 Raymond Harkless Mills San Imp - 200,000.00 200,000.00 - - 200,000.00 302103 Pump Station Imp & Maintenance - 568,240.98 568,240.98 - - 568,240.98 302104 Polymer System Relocation - 100,000.00 100,000.00 - - 100,000.00 302105 Piping Rehabilitation - 585,933.69 585,933.69 14,332.50 - 571,601.19 302201 Upper Adair Interceptor - 800,000.00 800,000.00 - - 800,000.00 302202 Crackerneck Creek Slope Rehab - 1,877,276.90 1,877,276.90 63,108.07 14,837.59 1,799,331.24 302203 Sanitary Sewer Main Reloc from Stre - 400,000.00 400,000.00 - - 400,000.00 302204 RCTP - Septic Pumper - 300,000.00 300,000.00 - - 300,000.00 302205 Clarifier Rehabilitation - 1,405,823.97 1,405,823.97 112,282.21 120,483.70 1,173,058.06 302206 Railing Safety RCPS & SCPS - 325,000.00 325,000.00 191,950.00 - 133,050.00 302301 Sludge Thickening Process Improve 400,000.00 - 400,000.00 - - 400,000.00 9757 TRENCHLESS TECHNOLOGY 100,000.00 995,405.40 1,095,405.40 381,570.90 15,143.01 698,691.49 $ 500,000.00 16,256,832.04 16,756,832.04 1,691,108.82 1,139,118.89 13,926,604.33 Current Year Prior Year Budget Budget (Enc Roll) Total Budget 14,137,112.86 $ 2,619,719.18 16,756,832.04 Less Expenditures 67,390.67 1,071,728.22 1,139,118.89 Less Encumbrances 292,032.00 1,399,076.82 1,691,108.82 Total Available 13,777,690.19 $ 148,914.14 13,926,604.33
23
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Events Center Debt Service
For the period ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Operating revenues: Charges for Services $ 0.00% -41.67% Miscellaneous 0.00% -41.67% Total operating revenues 0.00% -41.67% Operating Expenses: Personnel Services 0.00% -41.67% Other Services 0.00% -41.67% Supplies 0.00% -41.67% Capital Outlay 2,309,104 2,652,853 4,217,014 (1,564,161) 158.96% 117.29% Debt Service 5,648,400 5,648,400 965,841 4,682,559 17.10% -24.57% Other Expenses 0.00% -41.67% Total Operating Expenses 7,957,504 8,301,253 5,182,855 3,118,398 62.43% 20.76% Nonoperating Revenues (Expenses): Investment Income 6,200 6,200 62,037 55,837 1000.60% 958.93% Miscellaneous Revenue (Expense) 0.00% -41.67% Sales Tax 2,400,000 2,400,000 809,021 (1,590,979) 33.71% -7.96% Total Nonoperating Revenue (Expenses) 2,406,200 2,406,200 871,058 (1,535,142) 36.20% -5.47% (5,551,304) (5,895,053) (4,311,797) 1,583,256 73.14% 31.47% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -41.67% Transfers In 166,839 (166,839) 0.00% -41.67% Transfers Out 0.00% -41.67% Total Transfers 166,839 (166,839) 0.00% -41.67% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (5,551 304) (5,895 053) (4,144 958) 1,750 095 Beginning Available Resources (1,228,630) Less Prior Year Expenses Year-End Investment Market Value Adjustment Ending Available Resources $ (5,373,588) Income (Loss) Before Transfers
24
CITY
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Central Garage
For the period ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Operating revenues: Charges for Services $ 2,693,100 2,693,100 1,276,497 (1,416,603) 47.40% 5.73% Miscellaneous 6,122 6,122 0.00% -41.67% Total Operating Revenues 2,693,100 2,693,100 1,282,619 (1,410,481) 47.63% 5.96% Operating Expenses: Personnel Services 905,367 905,367 305,892 599,475 33.79% -7.88% Other Services 996,700 996,700 857,521 139,179 86.04% 44.37% Supplies 998,500 998,500 965,031 33,469 96.65% 54.98% Capital Outlay 8,000 8,000 5,619 2,381 70.24% 28.57% Other Expenses 0.00% -41.67% Total Operating Expenses 2,908,567 2,908,567 2,134,063 774,504 73.37% 31.70% Nonoperating Revenues (Expenses): Investment Income 6,500 6,500 2,948 (3,552) 45.35% 3.68% Miscellaneous Revenue (Expense) 281,000 281,000 917 (280,083) 0.33% -41.34% Total Nonoperating Revenue (Expenses) 287,500 287,500 3,865 (283,635) 1.34% -40.33% 72,033 72,033 (847,579) (919,612) -1176.65% -1218.32% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -41.67% Transfers In 0.00% -41.67% Transfers Out 0.00% -41.67% Total Transfers 0.00% -41.67% Change In Net Position (Budget Basis) $ 72,033 72,033 (847,579) (919,612) Unassigned Fund Balance at Beginning of Year (1,903,375) Cancellation of Prior Year Encumbrances 25,268 Change in Other Fund Balance Components During the Year (4,873) GAAP Components - OPEB and LAGERS 2,263,980 Year-end investment market value adjustment Ending Unassigned Fund Balance Non-GAAP Basis, 11/30/22 (466,579) Other Net Position Components: Assigned - Current Year Encumbrances 989,674 Assigned - Prior Year Encumbrances 34 Total Fund Balance $ 523,129 Income (Loss) Before Transfers
25
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Staywell Health Care
For the period ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Operating revenues: Charges for Services $ 17,859,000 17,859,000 8,668,637 (9,190,363) 48.54% 6.87% Miscellaneous 0.00% -41.67% Total Operating Revenues 17,859,000 17,859,000 8,668,637 (9,190,363) 48.54% 6.87% Operating Expenses: Personnel Services 568,500 568,500 30,400 538,100 5.35% -36.32% Other Services 22,268,500 22,268,500 9,748,443 12,520,057 43.78% 2.11% Supplies 0.00% -41.67% Capital Outlay 0.00% -41.67% Other Expenses 0.00% -41.67% Total Operating Expenses 22,837,000 22,837,000 9,778,843 13,058,157 42.82% 1.15% Nonoperating Revenues (Expenses): Investment Income 1,000 1,000 53,334 52,334 5333.40% 5291.73% Miscellaneous Revenue (Expense) 1,077,000 1,077,000 466,269 (610,731) 43.29% 1.62% Total Nonoperating Revenue (Expenses) 1,078,000 1,078,000 519,603 (558,397) 48.20% 6.53% (3,900,000) (3,900,000) (590,603) 3,309,397 15.14% -26.53% Transfers In - American Rescue Plan 3,900,000 3,900,000 3,900,000 100.00% 58.33% Transfers Out 0.00% -41.67% Total Transfers 3,900,000 3,900,000 3,900,000 100.00% 58.33% Change In Net Position (Budget Basis) $ 3,309,397 3,309,397 Unassigned Fund Balance at Beginning of Year 1,129,211 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance Non-GAAP Basis, 11/30/22 4,438,608 Other Net Position Components: Assigned - Current Year Encumbrances 65,440 Assigned - Prior Year Encumbrances Total Fund Balance $ 4,504,048 Income (Loss) Before Transfers
26
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Workers' Compensation
For the period ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Operating revenues: Charges for Services $ 4,450,900 4,450,900 1,854,544 (2,596,356) 41.67% 0.00% Miscellaneous 0.00% -41.67% Total Operating Revenues 4,450,900 4,450,900 1,854,544 (2,596,356) 41.67% 0.00% Operating Expenses: Personnel Services 2,607 (2,607) 0.00% -41.67% Other Services 4,558,654 4,558,654 1,617,292 2,941,362 35.48% -6.19% Supplies 0.00% -41.67% Capital Outlay 0.00% -41.67% Other Expenses 0.00% -41.67% Total Operating Expenses 4,558,654 4,558,654 1,619,899 2,938,755 35.53% -6.14% Nonoperating Revenues (Expenses): Investment Income 6,000 6,000 43,332 37,332 722.20% 680.53% Miscellaneous Revenue (Expense) 6,522 6,522 0.00% -41.67% Total Nonoperating Revenue (Expenses) 6,000 6,000 49,854 43,854 830.90% 789.23% (101,754) (101,754) 284,499 386,253 -279.59% -321.26% Transfers In 0.00% -41.67% Transfers Out 0.00% -41.67% Total Transfers 0.00% -41.67% Change In Net Position (Budget Basis) $ (101,754) (101,754) 284,499 386,253 Unassigned Fund Balance at Beginning of Year (6,396,207) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance Non-GAAP Basis, 11/30/22 (6,111,708) Other Net Position Components: Restricted - Work Comp Escrow Assigned - Current Year Encumbrances 109,872 Assigned - Prior Year Encumbrances 12,500 Total Fund Balance $ (5,989,336) Income (Loss) Before Transfers
27
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Risk Management
For the period ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Operating revenues: Charges for Services $ 3,196,000 3,196,000 1,226,792 (1,969,208) 38.39% -3.28% Miscellaneous 0.00% -41.67% Total Operating Revenues 3,196,000 3,196,000 1,226,792 (1,969,208) 38.39% -3.28% Operating Expenses: Personnel Services 2,607 (2,607) 0.00% -41.67% Other Services 2,936,292 2,936,292 1,272,660 1,663,632 43.34% 1.67% Supplies 2,000 2,000 2,000 0.00% -41.67% Capital Outlay 0.00% -41.67% Other Expenses 0.00% -41.67% Total Operating Expenses 2,938,292 2,938,292 1,275,267 1,663,025 43.40% 1.73% Nonoperating Revenues (Expenses): Investment Income 23,000 23,000 11,301 (11,699) 49.13% 7.46% Miscellaneous Revenue (Expense) 0.00% -41.67% Total Nonoperating Revenue (Expenses) 23,000 23,000 11,301 (11,699) 49.13% 7.46% 280,708 280,708 (37,174) (317,882) -13.24% -54.91% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -41.67% Transfers In 0.00% -41.67% Transfers Out 0.00% -41.67% Total Transfers 0.00% -41.67% Change In Net Position (Budget Basis) $ 280,708 280,708 (37,174) (317,882) Unassigned Fund Balance at Beginning of Year 1,752,742 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance Non-GAAP Basis, 11/30/22 1,715,568 Other Net Position Components: Assigned - Current Year Encumbrances 57,948 Assigned - Prior Year Encumbrances Total Fund Balance $ 1,773,516 Income (Loss) Before Transfers
28
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule
Finance & Support Services
For the period ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Operating revenues: Charges for Services $ 10,506,740 10,506,740 4,377,808 (6,128,932) 41.67% 0.00% Miscellaneous 0.00% -41.67% Total Operating Revenues 10,506,740 10,506,740 4,377,808 (6,128,932) 41.67% 0.00% Operating Expenses: Personnel Services 5,843,572 5,843,572 1,976,359 3,867,213 33.82% -7.85% Other Services 4,446,414 4,446,414 2,448,670 1,997,744 55.07% 13.40% Supplies 29,900 29,900 13,812 16,088 46.19% 4.52% Capital Outlay 142,500 142,500 11,495 131,005 8.07% -33.60% Other Expenses 0.00% -41.67% Total Operating Expenses 10,462,386 10,462,386 4,450,336 6,012,050 42.54% 0.87% Nonoperating Revenues (Expenses): Investment Income 0.00% -41.67% Miscellaneous Revenue (Expense) 8 8 0.00% -41.67% Total Nonoperating Revenue (Expenses) 8 8 0.00% -41.67% 44,354 44,354 (72,520) (116,874) -163.50% -205.17% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -41.67% Transfers In – CARES Act 0.00% -41.67% Transfers Out 0.00% -41.67% Total Transfers 0.00% -41.67% Change In Net Position (Budget Basis) $ 44,354 44,354 (72,520) (116,874) Unassigned Fund Balance at Beginning of Year 970,744 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year GAAP Components - OPEB and LAGERS 856,455 Ending Unassigned Fund Balance Non-GAAP Basis, 11/30/22 1,754,679 Other Net Position Components: Assigned - Current Year Encumbrances 332,366 Assigned - Prior Year Encumbrances 6,480 Total Fund Balance $ 2,093,525 Income (Loss) Before Transfers
29
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Charges for Services $ 9,289 9,289 (9,289) 0.00% -41.67% Investment Income (Loss) 889 889 0.00% -41.67% Other Revenue 0.00% -41.67% Total Revenues 9,289 9,289 889 (8,400) 9.57% -32.10% Expenditures: General Government 18 (18) 0.00% -41.67% Debt Service 10,200 10,200 587 9,613 5.75% -35.92% Total Expenditures 10,200 10,200 605 9,595 5.93% -35.74% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total expenditures and other financing uses 10,200 10,200 605 9,595 5.93% -35.74% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (911) (911) 284 1,195 Unassigned Fund Balance at Beginning of Year 104,235 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Ending Unassigned Fund Balance, 11/30/22 104,519 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 104,519
Improvement Districts
the period ended November 30, 2022 30
Debt Service - Neighborhood
For
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Charges for Services $ 139 139 0.00% -41.67% Investment Income 646 646 0.00% -41.67% Intergovernmental 0.00% -41.67% Other Revenue 0.00% -41.67% Total Revenues 785 785 0.00% -41.67% Other Financing Sources: Transfers In 0.00% -41.67% Total Other Financing Sources 0.00% -41.67% Total Revenues and Other Financing Sources 785 785 0.00% -41.67% Expenditures: Public Works 13 (13) 0.00% -41.67% Culture and Recreation 0.00% -41.67% Capital Outlay 184,552 9,150 175,402 4.96% -36.71% Total Expenditures 184,552 9,163 175,389 4.96% -36.71% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses — 184,552 9,163 175,389 4.96% -36.71% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (184,552) (8,378) 176,174 Unassigned Fund Balance at Beginning of Year (19,797) Cancellation of Prior Year Encumbrances Change to Prior Year Expenditure Year-End Investment Market Value Adjustment Ending Unassigned Fund Balance, 11/30/22 (28,175) Other Fund Balance Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances 97,116 Total Fund Balance $ 68,941 Budgetary Comparison Schedule
Street Improvements Capital Project Fund For the period ended November 30, 2022 31
CITY OF INDEPENDENCE, MISSOURI
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Revolving Public Improvements Capital Project Fund For the period ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Charges for Services $ 0.00% -41.67% Investment Income (Loss) 182 182 0.00% -41.67% Other Revenue 0.00% -41.67% Total Revenues 182 182 0.00% -41.67% Expenditures: Public Works 4 (4) 0.00% -41.67% Culture and Recreation 0.00% -41.67% Capital Outlay 0.00% -41.67% Total Expenditures 4 (4) 0.00% -41.67% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 4 (4) 0.00% -41.67% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 178 178 Unassigned Fund Balance at Beginning of Year 21,213 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Ending Unassigned Fund Balance, 11/30/22 21,391 Other Fund Balance Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances Total Fund Balance $ 21,391
32
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Buildings and Other Improvements Capital Project Fund For the period ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Charges for Services $ 0.00% -41.67% Intergovernmental 0.00% -41.67% Investment Income 323 323 0.00% -41.67% Other Revenue 0.00% -41.67% Total revenues 323 323 0.00% -41.67% Other Financing Sources: Transfers In 148,412 148,412 0.00% -41.67% Total Other Financing Sources 148,412 148,412 0.00% -41.67% Total Revenues and Other Financing Sources 148,735 148,735 0.00% -41.67% Expenditures: Public Works 9 (9) 0.00% -41.67% Culture and Recreation 0.00% -41.67% Capital Outlay 316,163 49,810 266,353 15.75% -25.92% Total Expenditures 316,163 49,819 266,344 15.76% -25.91% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total expenditures and other financing uses 316,163 49,819 266,344 15.76% -25.91% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (316,163) 98,916 415,079 Unassigned Fund Balance at Beginning of Year (164,886) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Ending Unassigned Fund Balance, 11/30/22 (65,970) Other Fund Balance Components: Committed - Current Year Encumbrances 49,810 Committed - Prior Year Encumbrances 13,230 Total Fund Balance $ (2,930)
33
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Charges for Services $ 0.00% -41.67% Investment Income 0.00% -41.67% Other Revenue 0.00% -41.67% Total revenues 0.00% -41.67% Expenditures: Public Works 0.00% -41.67% Culture and Recreation 0.00% -41.67% Capital Outlay 0.00% -41.67% Total Expenditures 0.00% -41.67% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total expenditures and other financing uses 0.00% -41.67% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ Unassigned Fund Balance at Beginning of Year (16,155) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 11/30/22 (16,155) Fund Balance Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances Total Fund Balance $ (16,155) CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Storm Drainage Capital Project Fund For the period ended November 30, 2022 34
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Park Improvements Capital Project Fund For the period ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Charges for Services $ 0.00% -41.67% Investment Income (Loss) 271 271 0.00% -41.67% Other Revenue 0.00% -41.67% Total revenues 271 271 0.00% -41.67% Expenditures: Public Works 6 (6) 0.00% -41.67% Culture and Recreation 0.00% -41.67% Capital Outlay 0.00% -41.67% Total Expenditures 6 (6) 0.00% -41.67% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total expenditures and other financing uses 6 (6) 0.00% -41.67% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 265 265 Unassigned Fund Balance at Beginning of Year 30,881 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Ending Unassigned Fund Balance, 11/30/22 31,146 Fund Balance Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances Total Fund Balance $ 31,146
35
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Charges for Services $ 0.00% -41.67% Investment Income 0.00% -41.67% Other Revenue 0.00% -41.67% Total Revenues 0.00% -41.67% Expenditures: Public Works 0.00% -41.67% Culture and Recreation 0.00% -41.67% Capital Outlay 0.00% -41.67% Total Expenditures 0.00% -41.67% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 0.00% -41.67% Excess of revenues over (under) expenditures and Other Financing Uses, Budget Basis $ Unassigned Net Position at Beginning of Year Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Net Position, 11/30/22 Other Net Position Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances Total Net Position $
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Private Purpose Expendable Trust Fund - Vaile Mansion For the period ended November 30, 2022 36
CITY
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Independence Events Center CID For the period ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Sales Taxes $ 8,470,843 8,470,843 2,851,239 (5,619,604) 33.66% -8.01% Investment Income 30,000 30,000 121,161 91,161 403.87% 362.20% Total Revenues 8,500,843 8,500,843 2,972,400 (5,528,443) 34.97% -6.70% Expenditures: Administrative Fee 169,417 169,417 57,025 112,392 33.66% -8.01% Insurance 4,750 4,750 4,750 0.00% -41.67% Legal 44,500 44,500 2,390 42,110 5.37% -36.30% Audit 5,500 5,500 5,500 100.00% 58.33% Banking 8,600 8,600 4,352 4,248 50.60% 8.93% Maintenance 100,000 100,000 100,000 0.00% -41.67% Capital Outlay 0.00% -41.67% Other 0.00% -41.67% Total Expenditures 332,767 332,767 69,267 263,500 20.82% -20.85% Other Financing Uses: Transfers Out - EATS 1,175,000 1,175,000 306,450 868,550 26.08% -15.59% Transfers Out - Debt Service (City) 4,202,213 4,202,213 502,571 3,699,642 11.96% -29.71% Transfers Out - Captial Projects 2,309,104 2,309,104 166,839 2,142,265 7.23% -34.44% Total Other Financing Uses 7,686,317 7,686,317 975,860 6,710,457 12.70% -28.97% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 481,759 481,759 1,927,273 1,445,514 Unassigned Fund Balance at Beginning of Year 10,439,449 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 11/30/22 12,366,722 Other Fund Balance Components: Restricted - current year encumbrances 5,500 Restricted - prior year encumbrances 5,795 Total Fund Balance $ 12,378,017
37
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Sales taxes $ 179,169 179,169 0.00% -41.67% Investment income 2,541 2,541 0.00% -41.67% Total revenues 181,710 181,710 0.00% -41.67% Expenditures: Administrative fee 3,583 (3,583) 0.00% -41.67% Insurance 0.00% -41.67% Legal 1,250 (1,250) 0.00% -41.67% Audit 5,500 (5,500) 0.00% -41.67% Banking 217 (217) 0.00% -41.67% Contract services 0.00% -41.67% Capital outlay 0.00% -41.67% Other 0.00% -41.67% Total expenditures 10,550 (10,550) 0.00% -41.67% Other financing uses: Transfers out - EATS 89,584 (89,584) 0.00% -41.67% Transfers out - Debt Service (City) 0.00% -41.67% Total other financing uses 89,584 (89,584) 0.00% -41.67% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 81,576 81,576 Unassigned Fund Balance at Beginning of Year 190,339 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year (225) Unassigned Ending Fund Balance, 11/30/22 271,690 Other Fund Balance Components: Restricted - Current Year Encumbrances 5,500 Restricted - Prior Year Encumbrances Restricted - City Transportation 7,401 Total Fund Balance $ 284,591
Creek TDD
the period ended November 30, 2022 38
Crackerneck
For
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Taxes $ 12,946,379 12,946,379 0.00% -41.67% Investment Income (Loss) 212,839 208,064 0.00% -41.67% Other revenue 193,194 193,194 0.00% -41.67% Total Revenues 13,352,412 13,347,637 0.00% -41.67% Other Financing Sources: Transfers In 306,451 306,451 0.00% -41.67% Total Other Financing Sources 306,451 306,451 0.00% -41.67% Total Revenues and Other Financing Sources 13,658,863 13,654,088 0.00% -41.67% Expenditures: Tax Increment Financing 18,714 (18,623) 0.00% -41.67% Debt Service Principal 4,775,000 4,775,000 379,748 4,395,252 7.95% -33.72% Interest and Fiscal Agent Fees 4,356,100 4,356,100 2,439,115 1,916,985 55.99% 14.32% Debt Issuance Costs 0.00% -41.67% Total Expenditures 9,131,100 9,131,100 2,837,577 6,293,614 31.08% -10.59% Other Financing Uses: Issuance of Debt 0.00% -41.67% Reoffering Premium/Original Issue Discount 0.00% -41.67% Payment to Refund Loans Escrow Agent 0.00% -41.67% Transfers Out 306,451 (306,451) 0.00% -41.67% Total Other Financing Uses 306,451 (306,451) 0.00% -41.67% Total Expenditures and Other Financing Uses 9,131,100 9,131,100 3,144,028 5,987,163 34.43% -7.24% Excess of Revenues Over (Under) Expenditures and other financing uses $ (9,131,100) (9,131,100) 10,514,835 19,645,935 Unassigned Fund Balance at Beginning of Year 21,016,591 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 11/30/22 31,531,426 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 10,524,834 Total Fund Balance $ 42,056,260
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Tax Increment Financing Summary For the Period Ended November 30, 2022 39
CITY
MISSOURI
For the Period Ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Taxes $ 34,164 34,164 0.00% -41.67% Investment Income (Loss) 228 228 0.00% -41.67% Other Revenue 48,006 48,006 0.00% -41.67% Total Revenues 82,398 82,398 0.00% -41.67% Other Financing Sources: Transfers In 0.00% -41.67% Total Other Financing Sources 0.00% -41.67% Total Revenues and Other Financing Sources 82,398 82,398 0.00% -41.67% Expenditures: Tax Increment Financing 0.00% -41.67% Debt Service Principal 210,000 210,000 105,000 105,000 50.00% 8.33% Interest and Fiscal Agent Fees 321,000 321,000 161,356 159,644 50.27% 8.60% Debt Issuance Costs 0.00% -41.67% Total Expenditures 531,000 531,000 266,356 264,644 50.16% 8.49% Other Financing Uses: Issuance of Debt 0.00% -41.67% Reoffering Premium/Original Issue Discount 0.00% -41.67% Payment to Refund Loans Escrow Agent 0.00% -41.67% Transfers Out 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 531,000 531,000 266,356 264,644 50.16% 8.49% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (531,000) (531,000) (183,958) 347,042 Unassigned Fund Balance at Beginning of Year (925,985) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 11/30/22 (1,109,943) Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 483,752 Total Fund Balance $ (626,191)
CITY OF INDEPENDENCE,
Budgetary Comparison Schedule Santa Fe TIF
40
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Hartman
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Taxes $ 121,233 121,233 0.00% -41.67% Investment Income (Loss) 0.00% -41.67% Other Revenue 0.00% -41.67% Total Revenues 121,233 121,233 0.00% -41.67% Other Financing Sources: Transfers In 0.00% -41.67% Total Other Financing Sources 0.00% -41.67% Total Revenues and Other Financing Sources 121,233 121,233 0.00% -41.67% Expenditures: Tax Increment Financing 0.00% -41.67% Debt Service Principal 0.00% -41.67% Interest and Fiscal Agent Fees 0.00% -41.67% Debt Issuance Costs 0.00% -41.67% Total Expenditures 0.00% -41.67% Other Financing Uses: Issuance of Debt 0.00% -41.67% Reoffering Premium/Original Issue Discount 0.00% -41.67% Payment to Refund Loans Escrow Agent 0.00% -41.67% Transfers Out 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 0.00% -41.67% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 121,233 121,233 Unassigned Fund Balance at Beginning of Year (2,693,942) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 11/30/22 (2,572,709) Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ (2,572,709)
Heritage TIF
41
For the Period Ended November 30, 2022
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Drumm Farm TIF
For the Period Ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Taxes $ (1,288) (1,288) 0.00% -41.67% Investment Income (Loss) 4 4 0.00% -41.67% Other Revenue 0.00% -41.67% Total Revenues (1,284) (1,284) 0.00% -41.67% Expenditures: Tax Increment Financing (1,284) 1,284 0.00% -41.67% Debt Service Principal 0.00% -41.67% Interest and Fiscal Agent Fees 0.00% -41.67% Debt Issuance Costs 0.00% -41.67% Total Expenditures (1,284) 1,284 0.00% -41.67% Other Financing Uses: Issuance of Debt 0.00% -41.67% Reoffering Premium/Original Issue Discount 0.00% -41.67% Payment to Refund Loans Escrow Agent 0.00% -41.67% Transfers Out 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses (1,284) 1,284 0.00% -41.67% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ Unassigned Fund Balance at Beginning of Year Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 11/30/22 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $
42
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Eastland TIF
For the Period Ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Taxes $ 3,927,415 3,927,415 0.00% -41.67% Investment Income (Loss) 151,545 151,545 0.00% -41.67% Other Revenue 0.00% -41.67% Total Revenues 4,078,960 4,078,960 0.00% -41.67% Other Financing Sources: Transfers In 286,134 286,134 0.00% -41.67% Total Other Financing Sources 286,134 286,134 0.00% -41.67% Total Revenues and Other Financing Sources 4,365,094 4,365,094 0.00% -41.67% Expenditures: Tax Increment Financing 3,528 (3,528) 0.00% -41.67% Debt Service Principal 0.00% -41.67% Interest and Fiscal Agent Fees 0.00% -41.67% Debt Issuance Costs 0.00% -41.67% Total Expenditures 3,528 (3,528) 0.00% -41.67% Other Financing Uses: Issuance of Debt 0.00% -41.67% Reoffering Premium/Original Issue Discount 0.00% -41.67% Payment to Refund Loans Escrow Agent 0.00% -41.67% Transfers Out 286,134 (286,134) 0.00% -41.67% Total Other Financing Uses 286,134 (286,134) 0.00% -41.67% Total Expenditures and Other Financing Uses 289,662 (289,662) 0.00% -41.67% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 4,075,432 4,075,432 Unassigned Fund Balance at Beginning of Year 17,258,732 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 11/30/22 21,334,164 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 392,126 Total Fund Balance $ 21,726,290
43
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
North Independence TIF
For the Period Ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Taxes $ 65,419 65,419 0.00% -41.67% Investment Income (Loss) 47 47 0.00% -41.67% Other Revenue 0.00% -41.67% Total Revenues 65,466 65,466 0.00% -41.67% Expenditures: Tax Increment Financing 1 (1) 0.00% -41.67% Debt Service Principal 0.00% -41.67% Interest and Fiscal Agent Fees 15,900 (15,900) 0.00% -41.67% Debt Issuance Costs 0.00% -41.67% Total Expenditures 15,901 (15,901) 0.00% -41.67% Other Financing Uses: Issuance of Debt 0.00% -41.67% Reoffering Premium/Original Issue Discount 0.00% -41.67% Payment to Refund Loans Escrow Agent 0.00% -41.67% Transfers Out 0.00% -41.67% 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 15,901 (15,901) 0.00% -41.67% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 49,565 49,565 Unassigned Fund Balance at Beginning of Year 10,110 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 11/30/22 59,675 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 59,675
44
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Crackerneck Creek TIF
For the Period Ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Taxes $ 924,035 924,035 0.00% -41.67% Investment Income (Loss) 31,490 31,490 0.00% -41.67% Other Revenue 145,188 145,188 0.00% -41.67% Total Revenues 1,100,713 1,100,713 0.00% -41.67% Other Financing Sources: Transfers In 0.00% -41.67% Total Other Financing Sources 0.00% -41.67% Total Revenues and Other Financing Sources 1,100,713 1,100,713 0.00% -41.67% Expenditures: Tax Increment Financing 859 (859) 0.00% -41.67% Debt Service Principal 2,260,000 2,260,000 2,260,000 0.00% -41.67% Interest and Fiscal Agent Fees 3,270,500 3,270,500 1,635,181 1,635,319 50.00% 8.33% Debt Issuance Costs 0.00% -41.67% Total Expenditures 5,530,500 5,530,500 1,636,040 3,894,460 29.58% -12.09% Other Financing Uses: Issuance of Debt 0.00% -41.67% Reoffering Premium/Original Issue Discount 0.00% -41.67% Payment to Refund Loans Escrow Agent 0.00% -41.67% Transfers Out 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 5,530,500 5,530,500 1,636,040 3,894,460 29.58% -12.09% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (5,530,500) (5,530,500) (535,327) 4,995,173 Unassigned Fund Balance at Beginning of Year 4,497,305 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 11/30/22 3,961,978 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 6,300,062 Total Fund Balance $ 10,262,040
45
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Old Landfill TIF
For the Period Ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Taxes $ 742,152 742,152 0.00% -41.67% Investment Income (Loss) 103 103 0.00% -41.67% Other Revenue 0.00% -41.67% Total Revenues 742,255 742,255 0.00% -41.67% Expenditures: Tax Increment Financing 2 (2) 0.00% -41.67% Debt Service Principal 3,452 (3,452) 0.00% -41.67% Interest and Fiscal Agent Fees 11,148 (11,148) 0.00% -41.67% Debt Issuance Costs 0.00% -41.67% Total Expenditures 14,602 (14,602) 0.00% -41.67% Other Financing Uses: Issuance of Debt 0.00% -41.67% Reoffering Premium/Original Issue Discount 0.00% -41.67% Payment to Refund Loans Escrow Agent 0.00% -41.67% Transfers Out 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 14,602 (14,602) 0.00% -41.67% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 727,653 727,653 Unassigned Fund Balance at Beginning of Year 9,460 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 11/30/22 737,113 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 737,113
46
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Trinity TIF
For the Period Ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Taxes $ 385,899 385,899 0.00% -41.67% Investment Income (Loss) 251 251 0.00% -41.67% Other Revenue 0.00% -41.67% Total Revenues 386,150 386,150 0.00% -41.67% Other Financing Sources: Transfers In 16,772 16,772 0.00% -41.67% Total Other Financing Sources 16,772 16,772 0.00% -41.67% Total Revenues and Other Financing Sources 402,922 402,922 0.00% -41.67% Expenditures: Tax Increment Financing 6 (6) 0.00% -41.67% Debt Service Principal 57,920 (57,920) 0.00% -41.67% Interest and Fiscal Agent Fees 35,880 (35,880) 0.00% -41.67% Debt Issuance Costs 0.00% -41.67% Total Expenditures 93,806 (93,806) 0.00% -41.67% Other Financing Uses: Issuance of Debt 0.00% -41.67% Reoffering Premium/Original Issue Discount 0.00% -41.67% Payment to Refund Loans Escrow Agent 0.00% -41.67% Transfers Out 16,772 (16,772) 0.00% -41.67% Total Other Financing Uses 16,772 (16,772) 0.00% -41.67% Total Expenditures and Other Financing Uses 110,578 (110,578) 0.00% -41.67% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 292,344 292,344 Unassigned Fund Balance at Beginning of Year 54,616 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 11/30/22 346,960 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 346,960
47
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
HCA TIF
For the Period Ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Taxes $ 4,189,611 4,189,611 0.00% -41.67% Investment Income (Loss) 6,047 6,047 0.00% -41.67% Other Revenue 0.00% -41.67% Total Revenues 4,195,658 4,195,658 0.00% -41.67% Other Financing Sources: Transfers In 3,545 3,545 0.00% -41.67% Total Other Financing Sources 3,545 3,545 0.00% -41.67% Total Revenues and Other Financing Sources 4,199,203 4,199,203 0.00% -41.67% Expenditures: Tax Increment Financing 326 (326) 0.00% -41.67% Debt Service Principal 2,305,000 2,305,000 2,305,000 0.00% -41.67% Interest and Fiscal Agent Fees 764,600 764,600 382,300 382,300 50.00% 8.33% Debt Issuance Costs 0.00% -41.67% Total Expenditures 3,069,600 3,069,600 382,626 2,686,974 12.47% -29.20% Other Financing Uses: Issuance of Debt 0.00% -41.67% Reoffering Premium/Original Issue Discount 0.00% -41.67% Payment to Refund Loans Escrow Agent 0.00% -41.67% Transfers Out 3,545 (3,545) 0.00% -41.67% Total Other Financing Uses 3,545 (3,545) 0.00% -41.67% Total Expenditures and Other Financing Uses 3,069,600 3,069,600 386,171 2,683,429 12.58% -29.09% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (3,069,600) (3,069,600) 3,813,032 6,882,632 Unassigned Fund Balance at Beginning of Year 940,378 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 11/30/22 4,753,410 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 3,348,894 Total Fund Balance $ 8,102,304
48
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Cinema East TIF
For the Period Ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Taxes $ 167,663 167,663 0.00% -41.67% Investment Income (Loss) 182 182 0.00% -41.67% Other Revenue 0.00% -41.67% Total Revenues 167,845 167,845 0.00% -41.67% Expenditures: Tax Increment Financing 4 (4) 0.00% -41.67% Debt Service Principal 0.00% -41.67% Interest and Fiscal Agent Fees 67,150 (67,150) 0.00% -41.67% Debt Issuance Costs 0.00% -41.67% Total Expenditures 67,154 (67,154) 0.00% -41.67% Other Financing Uses: Issuance of Debt 0.00% -41.67% Reoffering Premium/Original Issue Discount 0.00% -41.67% Payment to Refund Loans Escrow Agent 0.00% -41.67% Transfers Out 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 67,154 (67,154) 0.00% -41.67% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 100,691 100,691 Unassigned Fund Balance at Beginning of Year 53,242 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 11/30/22 153,933 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 153,933
49
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule 23rd & Noland Project 1 TIF
For the Period Ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Taxes $ (156,025) (156,025) 0.00% -41.67% Investment Income (Loss) 261 261 0.00% -41.67% Other Revenue 0.00% -41.67% Total Revenues (155,764) (155,764) 0.00% -41.67% Expenditures: Tax Increment Financing 10 (10) 0.00% -41.67% Debt Service Principal 0.00% -41.67% Interest and Fiscal Agent Fees 0.00% -41.67% Debt Issuance Costs 0.00% -41.67% Total Expenditures 10 (10) 0.00% -41.67% Other Financing Uses: Issuance of Debt 0.00% -41.67% Reoffering Premium/Original Issue Discount 0.00% -41.67% Payment to Refund Loans Escrow Agent 0.00% -41.67% Transfers Out 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 10 (10) 0.00% -41.67% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (155,774) (155,774) Unassigned Fund Balance at Beginning of Year 157,362 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 11/30/22 1,588 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 1,588
50
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule 23rd & Noland Project 2 TIF
For the Period Ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Taxes $ 7,994 7,994 0.00% -41.67% Investment Income (Loss) 18 18 0.00% -41.67% Other Revenue 0.00% -41.67% Total Revenues 8,012 8,012 0.00% -41.67% Expenditures: Tax Increment Financing 0.00% -41.67% Debt Service Principal 6,900 (6,900) 0.00% -41.67% Interest and Fiscal Agent Fees 0.00% -41.67% Debt Issuance Costs 0.00% -41.67% Total Expenditures 6,900 (6,900) 0.00% -41.67% Other Financing Uses: Issuance of Debt 0.00% -41.67% Reoffering Premium/Original Issue Discount 0.00% -41.67% Payment to Refund Loans Escrow Agent 0.00% -41.67% Transfers Out 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 6,900 (6,900) 0.00% -41.67% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 1,112 1,112 Unassigned Fund Balance at Beginning of Year 8,043 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 11/30/22 9,155 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 9,155
51
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule 23rd & Noland Project 3 TIF
For the Period Ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Taxes $ 11,862 11,862 0.00% -41.67% Investment Income (Loss) 43 43 0.00% -41.67% Other Revenue 0.00% -41.67% Total Revenues 11,905 11,905 0.00% -41.67% Expenditures: Tax Increment Financing 1 (1) 0.00% -41.67% Debt Service Principal 0.00% -41.67% Interest and Fiscal Agent Fees 0.00% -41.67% Debt Issuance Costs 0.00% -41.67% Total Expenditures 1 (1) 0.00% -41.67% Other Financing Uses: Issuance of Debt 0.00% -41.67% Reoffering Premium/Original Issue Discount 0.00% -41.67% Payment to Refund Loans Escrow Agent 0.00% -41.67% Transfers Out 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 1 (1) 0.00% -41.67% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 11,904 11,904 Unassigned Fund Balance at Beginning of Year 7,890 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 11/30/22 19,794 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 19,794
52
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule 23rd & Noland Project 4 TIF
For the Period Ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Taxes $ 246,160 246,160 0.00% -41.67% Investment Income (Loss) 1,203 1,203 0.00% -41.67% Other Revenue 0.00% -41.67% Total Revenues 247,363 247,363 0.00% -41.67% Expenditures: Tax Increment Financing 22 (22) 0.00% -41.67% Debt Service Principal 0.00% -41.67% Interest and Fiscal Agent Fees 0.00% -41.67% Debt Issuance Costs 0.00% -41.67% Total Expenditures 22 (22) 0.00% -41.67% Other Financing Uses: Issuance of Debt 0.00% -41.67% Reoffering Premium/Original Issue Discount 0.00% -41.67% Payment to Refund Loans Escrow Agent 0.00% -41.67% Transfers Out 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 22 (22) 0.00% -41.67% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 247,341 247,341 Unassigned Fund Balance at Beginning of Year 89,896 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 11/30/22 337,237 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 337,237
53
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Taxes $ 277,224 277,224 0.00% -41.67% Investment Income (Loss) 7,641 7,641 0.00% -41.67% Other Revenue 0.00% -41.67% Total Revenues 284,865 284,865 0.00% -41.67% Expenditures: Tax Increment Financing 14,716 (14,716) 0.00% -41.67% Debt Service Principal 0.00% -41.67% Interest and Fiscal Agent Fees 0.00% -41.67% Debt Issuance Costs 0.00% -41.67% Total Expenditures 14,716 (14,716) 0.00% -41.67% Other Financing Uses: Issuance of Debt 0.00% -41.67% Reoffering Premium/Original Issue Discount 0.00% -41.67% Payment to Refund Loans Escrow Agent 0.00% -41.67% Transfers Out 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 14,716 (14,716) 0.00% -41.67% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 270,149 270,149 Unassigned Fund Balance at Beginning of Year 768,661 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 11/30/22 1,038,810 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 1,038,810
54
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Independence Square TIF For the Period Ended November 30, 2022
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
I-70 & Little Blue Parkway Project 1 TIF
For the Period Ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Taxes $ 1,586,705 1,586,705 0.00% -41.67% Investment Income (Loss) 7,566 7,566 0.00% -41.67% Other Revenue 0.00% -41.67% Total Revenues 1,594,271 1,594,271 0.00% -41.67% Expenditures: Tax Increment Financing 61 (61) 0.00% -41.67% Debt Service Principal 87,137 (87,137) 0.00% -41.67% Interest and Fiscal Agent Fees 0.00% -41.67% Debt Issuance Costs 0.00% -41.67% Total Expenditures 87,198 (87,198) 0.00% -41.67% Other Financing Uses: Issuance of Debt 0.00% -41.67% Reoffering Premium/Original Issue Discount 0.00% -41.67% Payment to Refund Loans Escrow Agent 0.00% -41.67% Transfers Out 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 87,198 (87,198) 0.00% -41.67% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 1,507,073 1,507,073 Unassigned Fund Balance at Beginning of Year 195,981 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 11/30/22 1,703,054 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 1,703,054
55
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
I-70 & Little Blue Parkway Project 3 TIF For the Period Ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Taxes $ 257,063 257,063 0.00% -41.67% Investment Income (Loss) 1,028 1,028 0.00% -41.67% Other Revenue 0.00% -41.67% Total Revenues 258,091 258,091 0.00% -41.67% Expenditures: Tax Increment Financing 21 (21) 0.00% -41.67% Debt Service Principal 119,339 (119,339) 0.00% -41.67% Interest and Fiscal Agent Fees 0.00% -41.67% Debt Issuance Costs 0.00% -41.67% Total Expenditures 119,360 (119,360) 0.00% -41.67% Other Financing Uses: Issuance of Debt 0.00% -41.67% Reoffering Premium/Original Issue Discount 0.00% -41.67% Payment to Refund Loans Escrow Agent 0.00% -41.67% Transfers Out 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 119,360 (119,360) 0.00% -41.67% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 138,731 138,731 Unassigned Fund Balance at Beginning of Year 125,411 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 11/30/22 264,142 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 264,142
56
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule
Marketplace Project 1 TIF
For the Period Ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Taxes $ 54,491 54,491 0.00% -41.67% Investment Income (Loss) 276 276 0.00% -41.67% Other Revenue 0.00% -41.67% Total Revenues 54,767 54,767 0.00% -41.67% Expenditures: Tax Increment Financing 5 (5) 0.00% -41.67% Debt Service Principal 0.00% -41.67% Interest and Fiscal Agent Fees 82,500 (82,500) 0.00% -41.67% Debt Issuance Costs 0.00% -41.67% Total Expenditures 82,505 (82,505) 0.00% -41.67% Other Financing Uses: Issuance of Debt 0.00% -41.67% Reoffering Premium/Original Issue Discount 0.00% -41.67% Payment to Refund Loans Escrow Agent 0.00% -41.67% Transfers Out 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 82,505 (82,505) 0.00% -41.67% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (27,738) (27,738) Unassigned Fund Balance at Beginning of Year 92,122 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 11/30/22 64,384 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 64,384
57
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Marketplace Project 2 TIF
For the Period Ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Taxes $ 104,602 104,602 0.00% -41.67% Investment Income (Loss) 131 131 0.00% -41.67% Other Revenue 0.00% -41.67% Total Revenues 104,733 104,733 0.00% -41.67% Expenditures: Tax Increment Financing 345 (345) 0.00% -41.67% Debt Service Principal 0.00% -41.67% Interest and Fiscal Agent Fees 47,700 (47,700) 0.00% -41.67% Debt Issuance Costs 0.00% -41.67% Total Expenditures 48,045 (48,045) 0.00% -41.67% Other Financing Uses: Issuance of Debt 0.00% -41.67% Reoffering Premium/Original Issue Discount 0.00% -41.67% Payment to Refund Loans Escrow Agent 0.00% -41.67% Transfers Out 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 48,045 (48,045) 0.00% -41.67% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 56,688 56,688 Unassigned Fund Balance at Beginning of Year 32,673 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 11/30/22 89,361 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 89,361
58
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
TIF Supplemental Appropriation Fund For the Period Ended November 30, 2022
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 41.67% of Year Budget Revenues: Taxes $ Property tax RSO - Cargo Largo 3,430 3,430 0.00% -41.67% Hartman Heritage 76,019 76,019 0.00% -41.67% Drumm Farm 190,832 190,832 0.00% -41.67% Mt Washington 2,603 2,603 0.00% -41.67% 23rd & Noland - Project 1 65,622 65,622 0.00% -41.67% Sales tax RSO - Cargo Largo 91,124 91,124 0.00% -41.67% Drumm Farm 12,068 12,068 0.00% -41.67% Mt Washington 457 457 0.00% -41.67% 23rd & Noland - Project 1 1,668 1,668 0.00% -41.67% Investment Income (Loss) 4,775 4,775 0.00% -41.67% Other Revenue 0.00% -41.67% Total Revenues 448,598 448,598 0.00% -41.67% Expenditures: Tax Increment Financing 91 (91) 0.00% -41.67% Debt Service Principal 0.00% -41.67% Interest and Fiscal Agent Fees 0.00% -41.67% Debt Issuance Costs 0.00% -41.67% Total Expenditures 91 (91) 0.00% -41.67% Other Financing Uses: Issuance of Debt 0.00% -41.67% Reoffering Premium/Original Issue Discount 0.00% -41.67% Payment to Refund Loans Escrow Agent 0.00% -41.67% Transfers Out 0.00% -41.67% Total Other Financing Uses 0.00% -41.67% Total Expenditures and Other Financing Uses 91 (91) 0.00% -41.67% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 448,507 448,507 Unassigned Fund Balance at Beginning of Year 334,636 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 11/30/22 783,143 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 783,143
59