Monthly Financial and Operating Report April 2023
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 April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Real Estate Tax $ 5,903,000 5,903,000 5,773,974 (129,026) 97.81% 14.48% Sales Tax 20,635,000 20,635,000 17,432,319 (3,202,681) 84.48% 1.15% Use Tax 535,000 535,000 416,890 (118,110) 77.92% -5.41% Cigarette Tax 380,000 380,000 247,102 (132,898) 65.03% -18.30% Franchise Tax 8,344,000 8,344,000 7,179,932 (1,164,068) 86.05% 2.72% Licenses and Permits 4,410,950 4,410,950 3,842,036 (568,914) 87.10% 3.77% Intergovernmental 5,810,000 5,810,000 5,736,509 (73,491) 98.74% 15.41% Charges for Current Services 1,955,400 2,033,302 2,077,294 43,992 102.16% 18.83% Interfund Charges for Support Services 2,354,600 2,354,600 1,962,167 (392,433) 83.33% 0.00% Fines and Forfeitures 2,156,000 2,156,000 1,632,967 (523,033) 75.74% -7.59% Investment Income (Loss) 220,000 220,000 176,323 (43,677) 80.15% -3.18% Other Revenue 750,400 750,400 166,645 (583,755) 22.21% -61.12% Total Revenues 53,454,350 53,532,252 46,644,158 (6,888,094) 87.13% 3.80% Other Financing Sources: Payments In Lieu of Taxes 20,848,787 20,848,787 18,366,984 (2,481,803) 88.10% 4.77% Transfers In — — — — 0.00% -83.33% Operating Transfers In - American Rescue Plan — — — — 0.00% -83.33% Total Other Financing Sources 20,848,787 20,848,787 18,366,984 (2,481,803) 88.10% 4.77% Total Revenues and Other Financing Sources 74,303,137 74,381,039 65,011,142 (9,369,897) 87.40% 4.07% Expenditures: City Council 686,729 896,038 610,282 285,756 68.11% -15.22% City Clerk 266,577 332,702 421,744 (89,042) 126.76% 43.43% City Manager 1,101,987 1,157,647 934,666 222,981 80.74% -2.59% Municipal Court 1,687,121 1,687,121 1,281,647 405,474 75.97% -7.36% Law 182,663 182,663 143,893 38,770 78.78% -4.55% Finance 626,644 627,644 606,497 21,147 96.63% 13.30% Community Development 5,387,456 5,308,392 4,023,482 1,284,910 75.79% -7.54% Police 34,273,528 34,350,430 27,870,370 6,480,060 81.14% -2.19% Fire 23,811,497 23,625,592 21,037,261 2,588,331 89.04% 5.71% Municipal Services (Public Works) 5,972,696 5,972,696 4,409,343 1,563,353 73.83% -9.50% Parks and Recreation 296,239 296,239 172,428 123,811 58.21% -25.12% Contingencies — — — — 0.00% -83.33% Debt service — — — — 0.00% -83.33% Total Expenditures 74,293,137 74,437,164 61,511,613 12,925,551 82.64% -0.69% Other Financing Uses: Transfers Out 10,000 10,000 163,085 (153,085) 1630.85% 1547.52% Total Expenditures and Other Financing Uses 74,303,137 74,447,164 61,674,698 12,772,466 82.84% -0.49% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ — (66,125) 3,336,444 3,402,569 Unassigned Fund Balance at Beginning of Year 6,281,728 Cancellation of prior year encumbrances 46,229 Change in other fund balance components during the year (219,484) Year-end investment market value adjustment — Ending Unassigned Fund Balance, 04/30/23 9,444,917 Restricted 311,132 Committed 7,244 Assigned 950,914 Total Fund Balance $ 10,714,207
1
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Street Improvements Sales Tax Fund For the period ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Sales Taxes $ 9,715,000 9,715,000 8,128,248 (1,586,752) 83.67% 0.34% Use Tax 268,000 268,000 208,445 (59,555) 77.78% -5.55% Charges for Services — — — — 0.00% -83.33% Intergovernmental Revenue — — 709,776 709,776 0.00% -83.33% Investment Income (Loss) 77,000 77,000 486,499 409,499 631.82% 548.49% Other Revenue — — — — 0.00% -83.33% Total Revenues 10,060,000 10,060,000 9,532,968 (527,032) 94.76% 11.43% Other Financing Sources: Transfers in — — 153,283 153,283 0.00% -83.33% Total other financing sources — — 153,283 153,283 0.00% -83.33% Total revenues and other financing sources 10,060,000 10,060,000 9,686,251 (373,749) 96.28% 12.95% Expenditures: General Government — — — — 0.00% -83.33% Street Maintenance 1,265,081 1,265,081 859,394 405,687 67.93% -15.40% Capital Outlay 6,556,836 15,996,210 5,238,550 10,757,660 32.75% -50.58% Debt Service 1,744,200 1,744,200 1,744,148 52 100.00% 16.67% Total Expenditures 9,566,117 19,005,491 7,842,092 11,163,399 41.26% -42.07% Other Financing Uses: Transfers Out — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Financing Uses 9,566,117 19,005,491 7,842,092 11,163,399 41.26% -42.07% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 493,883 (8,945,491) 1,844,159 10,789,650 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 18,377 Year-end investment market value adjustment — Ending Unassigned Fund Balance, 04/30/23 1,793,849 Fund Balance Components: Restricted - Current Year Encumbrances 3,308,051 Restricted - Prior Year Encumbrances 5,979,255 Restricted - Debt Reserve Project Accounts - Capital Projects 11,401,942 Total Fund Balance $ 22,483,097
2
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Park Improvements Sales Tax Fund For the period ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Sales Taxes $ 4,858,000 4,858,000 4,064,397 (793,603) 83.66% 0.33% Use Tax 134,000 134,000 104,223 (29,777) 77.78% -5.55% Charges for services 474,540 474,540 436,606 (37,934) 92.01% 8.68% Intergovernmental 88,500 88,500 44,693 (43,807) 50.50% -32.83% Investment Income (Loss) 59,180 59,180 60,434 1,254 102.12% 18.79% Other Revenue 7,500 7,500 33,010 25,510 440.13% 356.80% Total Revenues 5,621,720 5,621,720 4,743,363 (878,357) 84.38% 1.05% Other Financing Sources: Transfers In — — — — 0.00% -83.33% Transfers In - American Rescue Plan — — — — 0.00% -83.33% Proceeds from Bond Issuance/Capital Lease — — — — 0.00% -83.33% Total Other Financing Sources — — — — 0.00% -83.33% Total Revenues and Other Financing Sources 5,621,720 5,621,720 4,743,363 (878,357) 84.38% 1.05% Expenditures: Culture and Recreation 5,103,261 5,332,997 4,108,450 1,224,547 77.04% -6.29% Capital Outlay 993,000 1,645,547 538,113 1,107,434 32.70% -50.63% Debt Service — — — — 0.00% -83.33% Total Expenditures 6,096,261 6,978,544 4,646,563 2,331,981 66.58% -16.75% Other Financing Uses: Transfers Out — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Financing Uses 6,096,261 6,978,544 4,646,563 2,331,981 66.58% -16.75% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (474,541) (1,356,824) 96,800 1,453,624 Unassigned Fund Balance at Beginning of Year 3,054,584 Cancellation of Prior Year Encumbrances 14,895 Change in Other Fund Balance Components During the Year 21,275 Year-end investment market value adjustment — Ending Unassigned Fund Balance, 04/30/23 3,187,554 Other Fund Balance Components: Restricted - Current Year Encumbrances 640,234 Restricted - Prior Year Encumbrances 40,922 Total Fund Balance $ 3,868,710
3
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Storm
For the period ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Sales Taxes $ 4,858,000 4,858,000 4,064,397 (793,603) 83.66% 0.33% Use Tax 134,000 134,000 104,223 (29,777) 77.78% -5.55% Charges for Services — — 723 723 0.00% -83.33% Intergovernmental — — — — 0.00% -83.33% Investment Income (loss) 164,000 164,000 237,816 73,816 145.01% 61.68% Other Revenue 7,900 16,685 16,481 (204) 98.78% 15.45% Total revenues 5,163,900 5,172,685 4,423,640 (749,045) 85.52% 2.19% Expenditures: Storm water Administration 233,009 233,009 194,253 38,756 83.37% 0.04% Maintenance 2,684,530 2,693,315 1,769,918 923,397 65.72% -17.61% Permit completion 318,000 318,000 305,200 12,800 95.97% 12.64% Capital outlay 1,500,000 4,590,291 1,025,821 3,564,470 22.35% -60.98% — Total Expenditures 4,735,539 7,834,615 3,295,192 4,539,423 42.06% -41.27% Other financing uses: Transfers out — — 1,724 (1,724) 0.00% -83.33% Total other financing uses — — 1,724 (1,724) 0.00% -83.33% Total Ependitures and Other Financing Uses 4,735,539 7,834,615 3,296,916 4,537,699 42.08% -41.25% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 428,361 (2,661,930) 1,126,724 3,788,654 Unassigned Fund Balance at Beginning of Year 9,093,308 Cancellation of Prior Year Encumbrances 169,388 Change in Other Fund Balance Components During the Year — Year-end investment market value adjustment — Ending Unassigned Fund Balance, 04/30/23 10,389,420 Other Fund Balance Components: Restricted - Current Year Encumbrances 851,695 Restricted - Prior Year Encumbrances 211,151 Restricted - Regional Detention Construction 120,524 Restricted - Regional Detention Maintenance 59,159 Restricted - Emergency Response Relief 500,000 Total Fund Balance $ 12,131,949
Water Sales Tax Fund
4
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Police
For the period ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Sales Taxes $ 2,580,000 2,580,000 2,200,157 (379,843) 85.28% 1.95% Use Tax 67,000 67,000 52,111 (14,889) 77.78% -5.55% Investment Income (Loss) 35,000 35,000 49,945 14,945 142.70% 59.37% Other Revenue 7,600 7,600 115,329 107,729 1517.49% 1434.16% Total Revenues 2,689,600 2,689,600 2,417,542 (272,058) 89.88% 6.55% Expenditures: Public Safety Communications 522,200 515,060 455,186 59,874 88.38% 5.05% Facilities 105,200 112,340 95,724 16,616 85.21% 1.88% Equipment 1,743,700 1,743,700 1,588,496 155,204 91.10% 7.77% Debt Service — — 751 (751) 0.00% -83.33% Total Expenditures 2,371,100 2,371,100 2,140,157 230,943 90.26% 6.93% Other Financing Uses: Transfers Out/Capital Outlay — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Financing Uses 2,371,100 2,371,100 2,140,157 230,943 90.26% 6.93% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 318,500 318,500 277,385 (41,115) Unassigned Fund Balance at Beginning of Year 2,435,627 Cancellation of Prior Year Encumbrances 11,803 Change in Other Fund Balance Components During the Year — Year-end investment market value adjustment — Ending Unassigned Fund Balance, 04/30/23 2,724,815 Other Fund Balance Components: Restricted - Current Year Encumbrances 161,586 Restricted - Prior Year Encumbrances 36,133 Total Fund Balance $ 2,922,534
Public Safety Sales Tax Fund
5
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Fire Protection Sales Tax Fund For the period ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Sales Taxes $ 8,770,000 8,770,000 8,822,033 52,033 100.59% 17.26% Use Tax 268,000 268,000 208,445 (59,555) 77.78% -5.55% Investment Income (Loss) 29,000 29,000 97,181 68,181 335.11% 251.78% Other Revenue 6,000 6,000 38,723 32,723 645.38% 562.05% Total Revenues 9,073,000 9,073,000 9,166,382 93,382 101.03% 17.70% Expenditures: Public Safety 6,821,786 7,812,662 4,334,753 3,477,909 55.48% -27.85% Debt Service 73,300 73,300 73,235 65 99.91% 16.58% Total Expenditures 6,895,086 7,885,962 4,407,988 3,477,974 55.90% -27.43% Other Financing Uses: Transfers Out/Capital Outlay — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Financing Uses 6,895,086 7,885,962 4,407,988 3,477,974 55.90% -27.43% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 2,177,914 1,187,038 4,758,394 3,571,356 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, 04/30/23 6,613,366 Other Fund Balance Components: Restricted - Current Year Encumbrances 1,180,646 Restricted - Prior Year Encumbrances 129,724 Total Fund Balance $ 7,923,736
6
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Use Tax $ 782,000 782,000 782,000 — 100.00% 16.67% Intergovernmental Revenue — — — — 0.00% -83.33% Investment Income (Loss) 3,000 3,000 12,518 9,518 417.27% 333.94% Other Revenue — — — — 0.00% -83.33% Total Revenues 785,000 785,000 794,518 9,518 101.21% 17.88% Expenditures: General Government — — — — 0.00% -83.33% Animal Services 769,213 769,213 560,359 208,854 72.85% -10.48% Capital Outlay — — — — 0.00% -83.33% Debt Service — — — — 0.00% -83.33% Total Expenditures 769,213 769,213 560,359 208,854 72.85% -10.48% Other Financing Uses: Transfers In — — — — 0.00% -83.33% Transfers Out — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Financing Uses 769,213 769,213 560,359 208,854 72.85% -10.48% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 15,787 15,787 234,159 218,372 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, 04/30/23 441,862 Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Total Fund Balance $ 441,862
Budgetary Comparison Schedule Animal Shelter Use Tax For the period ended April 30, 2023 7
CITY OF INDEPENDENCE, MISSOURI
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Police Use Tax For the period ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Use Tax $ 4,100,000 4,100,000 4,100,000 — 100.00% 16.67% Investment Income (Loss) 59,000 59,000 119,294 60,294 202.19% 118.86% Other Revenue — — — — 0.00% -83.33% Total Revenues 4,159,000 4,159,000 4,219,294 60,294 101.45% 18.12% Expenditures: Public Safety 4,029,166 4,175,616 3,332,334 843,282 79.80% -3.53% Debt Service — — — — 0.00% -83.33% Total Expenditures 4,029,166 4,175,616 3,332,334 843,282 79.80% -3.53% Other Financing Uses: Transfers Out/Capital Outlay — — — — 0.00% -83.33% — Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Financing Uses 4,029,166 4,175,616 3,332,334 843,282 79.80% -3.53% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 129,834 (16,616) 886,960 903,576 Unassigned Fund Balance at Beginning of Year 4,586,138 Cancellation of Prior Year Encumbrances 107,560 Change in Other Fund Balance Components During the Year — Year-end investment market value adjustment — Ending Unassigned Fund Balance, 04/30/23 5,580,658 Other Fund Balance Components: Restricted - Current Year Encumbrances 264,065 Restricted - Prior Year Encumbrances — Total Fund Balance $ 5,844,723
8
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule Health Property Tax Levy For the period ended April 30, 2023 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 881,500 881,500 860,972 (20,528) 97.67% 14.34% Charges for Services 154,500 154,500 129,702 (24,798) 83.95% 0.62% Licenses & Permits 392,238 392,238 411,243 19,005 104.85% 21.52% Investment Income (Loss) 3,731 3,731 16,131 12,400 432.35% 349.02% Other Revenue 14,000 14,000 9,425 (4,575) 67.32% -16.01% Total Revenues 1,445,969 1,445,969 1,427,473 (18,496) 98.72% 15.39% Other Financing Sources: Transfers In — — — — 0.00% -83.33% Transfers In - American Rescue Plan 300,000 300,000 300,000 — 100.00% 16.67% Total Other Financing Uses 300,000 300,000 300,000 — 100.00% 16.67% Total Revenues and Other Sources 1,745,969 1,745,969 1,727,473 (18,496) 98.94% 15.61% Expenditures: Animal Services 1,045,512 1,045,512 816,662 228,850 78.11% -5.22% Health Services 733,636 733,636 523,714 209,922 71.39% -11.94% Total Expenditures 1,779,148 1,779,148 1,340,376 438,772 75.34% -7.99% Other Financing Uses: Transfers Out — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Uses 1,779,148 1,779,148 1,340,376 438,772 75.34% -7.99% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (333,179) (333,179) 387,097 720,276 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, 04/30/23 552,819 Other Fund Balance Components: Restricted - Current Year Encumbrances 27,462 Restricted - Prior Year Encumbrances — Total Fund Balance $ 580,281
9
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule Parks and Recreation Property Tax Levy For the period ended April 30, 2023 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 1,876,775 1,876,775 1,829,366 (47,409) 97.47% 14.14% Intergovernmental — — — — 0.00% -83.33% Charges for Services 120,650 120,650 82,954 (37,696) 68.76% -14.57% Investment Income (Loss) 19,165 19,165 22,797 3,632 118.95% 35.62% Other Revenue — — 27,903 27,903 0.00% -83.33% Total Revenues 2,016,590 2,016,590 1,963,020 (53,570) 97.34% 14.01% Expenditures: Parks and Recreation 2,554,180 2,554,180 2,109,913 444,267 82.61% -0.72% Total Expenditures 2,554,180 2,554,180 2,109,913 444,267 82.61% -0.72% Other Financing Uses – Transfers Out — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Uses 2,554,180 2,554,180 2,109,913 444,267 82.61% -0.72% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (537,590) (537,590) (146,893) 390,697 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, 04/30/23 434,883 Other Fund Balance Components: Restricted - Current Year Encumbrances 78,917 Restricted - Prior Year Encumbrances — Total Fund Balance $ 513,800 10
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule Tourism Fund For the period ended April 30, 2023 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Transient Guest Taxes $ 1,975,000 1,975,000 1,884,999 (90,001) 95.44% 12.11% Charges for Services 32,000 32,000 23,130 (8,870) 72.28% -11.05% Investment Income (Loss) 25,050 25,050 43,091 18,041 172.02% 88.69% Other Revenue 12,050 12,050 8,725 (3,325) 72.41% -10.92% Total Revenues 2,044,100 2,044,100 1,959,945 (84,155) 95.88% 12.55% Other Financing Sources: Transfers In - American Resuce Plan — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Revenues and Other Sources 2,044,100 2,044,100 1,959,945 (84,155) 95.88% 12.55% Expenditures: Tourism 2,709,247 3,339,449 1,458,036 1,881,413 43.66% -39.67% Total Expenditures 2,709,247 3,339,449 1,458,036 1,881,413 43.66% -39.67% Other Financing Uses – Transfers Out — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Uses 2,709,247 3,339,449 1,458,036 1,881,413 43.66% -39.67% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (665,147) (1,295,349) 501,909 1,797,258 Unassigned Fund Balance at Beginning of Year 1,178,234 Cancellation of Prior Year Encumbrances 478 Change in Other Fund Balance Components During the Year — Year-end investment market value adjustment — Ending Unassigned Fund Balance, 04/30/23 1,680,621 Other Fund Balance Components: Restricted - Current Year Encumbrances 175,965 Restricted - Prior Year Encumbrances 50,845 Restricted - Operating Reserve 376,368 Total Fund Balance $ 2,283,799
11
Independence Square Benefit District For the period ended April 30, 2023 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ — — 26,384 26,384 0.00% -83.33% Investment Income (Loss) — — 1,507 1,507 0.00% -83.33% Other Revenue — — — — 0.00% -83.33% Total Revenues — — 27,891 27,891 0.00% -83.33% Expenditures: Capital Outlay — — 426 (426) 0.00% -83.33% Total Expenditures — — 426 (426) 0.00% -83.33% Other Financing Uses – Transfers Out — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Uses — — 426 (426) 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ — — 27,465 27,465 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, 04/30/23 35,830 Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Total Fund Balance $ 35,830 12
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Community Development Block Grant Fund For the period ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Federal Grant - CDBG $ 800,000 800,000 818,615 18,615 102.33% 19.00% Other Revenue — — — — — -83.33% Total Revenues 800,000 800,000 818,615 18,615 102.33% 19.00% Expenditures: CDBG Administration 160,000 160,000 141,176 18,824 88.24% 4.90% CDBG Expenditures 640,000 640,000 325,196 314,804 50.81% -32.52% Total Expenditures 800,000 800,000 466,372 333,628 58.30% -25.03% Other Financing Uses: Transfers Out — — 153,283 (153,283) 0.00% -83.33% Total Other Financing Uses — — 153,283 (153,283) 0.00% -83.33% Total Expenditures and Other Uses 800,000 800,000 619,655 180,345 77.46% -5.87% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ — — 198,960 198,960 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, 04/30/23 (168,255) Other Fund Balance Components: Restricted - Current Year Encumbrances 41,830 Restricted - Prior Year Encumbrances 125,687 Total Fund Balance $ (738)
13
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Rental Rehabilitation For the period ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: HOME Program Grant $ 465,330 499,770 290,442 (209,328) 58.12% -25.21% Total Revenues 465,330 499,770 290,442 (209,328) 58.12% -25.21% Expenditures: HOME Administration 46,533 80,973 73,370 7,603 90.61% 7.28% Multi Family Housing 325,730 325,730 — 325,730 0.00% -83.33% Community Housing Development 93,067 93,067 — 93,067 0.00% -83.33% Total Expenditures 465,330 499,770 73,370 426,400 14.68% -68.65% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ — — 217,072 217,072 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, 04/30/23 (53,063) Other Fund Balance Components: Restricted - Current Year Encumbrances 40 Restricted - Prior Year Encumbrances 53,030 Total Fund Balance $ 7
14
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Licenses and Permits $ — — 100,224 100,224 0.00% -83.33% Investment Income (Loss) 21,000 21,000 24,967 3,967 118.89% 35.56% Other Revenue — — — — 0.00% -83.33% Total Revenues 21,000 21,000 125,191 104,191 596.15% 512.82% Expenditures: General Government — — 377 (377) 0.00% -83.33% Total expenditures — — 377 (377) 0.00% -83.33% Other Financing Uses: Transfers Out/Capital Outlay — — 115 (115) 0.00% -83.33% Total Other Financing Uses — — 115 (115) 0.00% -83.33% Total Expenditures and Other Financing Uses — — 492 (492) 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 21,000 21,000 124,699 103,699 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, 04/30/23 1,294,846 Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Total Fund Balance $ 1,294,846
Schedule License Surcharge For the period ended April 30, 2023 15
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Grants
For the period ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Intergovernmental $ 2,311,280 7,429,054 2,589,815 (4,839,239) 34.86% -48.47% Charges for Services 109,023 109,023 172,750 63,727 158.45% 75.12% Other Revenue — 290,361 311 (290,050) 0.11% -83.22% Total Revenues 2,420,303 7,828,438 2,762,876 (5,065,562) 35.29% -48.04% Other financing sources: Transfers In — — — — 0.00% -83.33% Total other financing sources — — — — 0.00% -83.33% Total revenues and other financing sources 2,420,303 7,828,438 2,762,876 (5,065,562) 35.29% -48.04% Expenditures: Public Safety 640,270 2,852,700 1,516,788 1,335,912 53.17% -30.16% General Government 27,892 108,713 23,530 85,183 21.64% -61.69% Culture and Recreation — 83,434 33,217 50,217 39.81% -43.52% Community Development 940,000 1,995,670 1,232,133 763,537 61.74% -21.59% Animal Services — 16,269 3,512 12,757 21.59% -61.74% Health Services 465,497 2,148,255 465,859 1,682,396 21.69% -61.64% Total Expenditures 2,073,659 7,205,041 3,275,039 3,930,002 45.45% -37.88% Other Financing Uses: Transfers Out/Capital Outlay — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Financing Uses 2,073,659 7,205,041 3,275,039 3,930,002 45.45% -37.88% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 346,644 623,397 (512,163) (1,135,560) Unassigned Fund Balance at Beginning of Year (227,386) Cancellation of Prior Year Encumbrances 4,571 Change in Other Fund Balance Components During the Year (5,744) Ending Unassigned Fund Balance, 04/30/23 (740,722) Other Fund Balance Components: Restricted - Current Year Encumbrances 450,389 Restricted - Prior Year Encumbrances 139,811 Total Fund Balance $ (150,522)
16
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule American Rescue Plan (ARP) For the period ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Intergovernmental $ 9,557,038 9,557,038 5,104,411 (4,452,627) 53.41% -29.92% Charges for Services — — — — 0.00% -83.33% Other Revenue — — — — 0.00% -83.33% Total Revenues 9,557,038 9,557,038 5,104,411 (4,452,627) 53.41% -29.92% Other financing sources: Transfers in — — — — 0.00% -83.33% Total other financing sources — — — — 0.00% -83.33% Total revenues and other financing sources 9,557,038 9,557,038 5,104,411 (4,452,627) 53.41% -29.92% Expenditures: Personnel Services 110,000 110,000 95,082 14,918 86.44% 3.11% Other Services 1,112,038 1,112,038 434,980 677,058 39.12% -44.21% Supplies — — — — 0.00% -83.33% Capital Outlay 4,135,000 4,135,000 417,368 3,717,632 10.09% -73.24% Total Expenditures 5,357,038 5,357,038 947,430 4,409,608 17.69% -65.64% Other Financing Uses: Transfers Out - American Rescue Plan 4,200,000 4,200,000 4,200,000 — 100.00% 16.67% — Total Other Financing Uses 4,200,000 4,200,000 4,200,000 — 100.00% 16.67% Total Expenditures and Other Financing Uses 9,557,038 9,557,038 5,147,430 4,409,608 53.86% -29.47% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ — — (43,019) (43,019) Unassigned Fund Balance at Beginning of Year (228,013) Cancellation of Prior Year Encumbrances — Change in Other Fund Balance Components During the Year 17,500 Ending Unassigned Fund Balance, 04/30/23 (253,532) Other Fund Balance Components: Restricted - Current Year Encumbrances 154,994 Restricted - Prior Year Encumbrances 98,538 Total Fund Balance $ —
17
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Operating Revenues: Charges for Services $ 131,606,000 131,606,000 119,108,157 (12,497,843) 90.50% 7.17% Penalties 1,000,000 1,000,000 1,276,263 276,263 127.63% 44.30% Connection Charges 33,000 33,000 5,581 (27,419) 16.91% -66.42% Miscellaneous — — 47,874 47,874 0.00% -83.33% Temporary Service 1,000 1,000 950 (50) 95.00% 11.67% Rental Income 276,000 276,000 296,142 20,142 107.30% 23.97% Transmission Wheeling 7,000,000 7,000,000 6,138,756 (861,244) 87.70% 4.37% Total Operating Revenues 139,916,000 139,916,000 126,873,723 (13,042,277) 90.68% 7.35% Operating Expenses: Personnel Services 28,729,037 28,729,037 22,607,235 6,121,802 78.69% -4.64% Retiree Benefits 1,460,000 1,460,000 1,236,681 223,319 84.70% 1.37% Other Services 26,956,585 26,911,285 26,408,161 503,124 98.13% 14.80% Supplies 55,603,355 55,603,905 52,516,230 3,087,675 94.45% 11.12% Capital Projects 5,305,000 14,289,794 5,162,381 9,127,413 36.13% -47.20% Capital Operating 1,400,225 1,444,975 541,309 903,666 37.46% -45.87% Debt Service 7,896,466 7,896,466 2,842,595 5,053,871 36.00% -47.33% Other Expenses 100,000 100,000 — 100,000 0.00% -83.33% Total Operating Expenses 127,450,668 136,435,462 111,314,592 25,120,870 81.59% -1.74% Nonoperating Revenues (Expenses): Investment Income 118,000 118,000 1,282,888 1,164,888 1087.19% 1003.86% Interfund Charges for Support Services 2,011,000 2,011,000 1,711,090 (299,910) 85.09% 1.76% Miscellaneous Revenue (Expense) 15,700 15,700 687,787 672,087 4380.81% 4297.48% Total Nonoperating Revenue (Expenses) 2,144,700 2,144,700 3,681,765 1,537,065 171.67% 88.34% 14,610,032 5,625,238 19,240,896 13,615,658 342.05% 258.72% Capital Contributions — — — — 0.00% -83.33% Transfers Out – Utility Payments In Lieu of Taxes (13,000,000) (13,000,000) (12,607,261) (392,739) 96.98% 13.65% Transfers In — — — — 0.00% -83.33% Transfers Out — — — — 0.00% -83.33% Total Transfers (13,000,000) (13,000,000) (12,607,261) (392,739) 96.98% 13.65% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 1,610,032 (7,374,762) 6,633,635 14,008,397 Beginning Available Resources 49,405,589 Prior Period Adjustment — Year-End Investment Market Value Adjustment — Ending Available Resources 56,039,224 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 $ 3,539,224 Income (Loss) Before Transfers
Power and Light For the period ended April 30, 2023 18
Power and Light - Open Capital Projects
As of April 30, 2023
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 549,755.34 63,315.00 220,869.14 200824 Prod Plt MISC PROJECTS - 68,257.76 68,257.76 - - 68,257.76 200828 FIBER OPTIC PROGRAM - 198,999.72 198,999.72 108,689.23 114,949.12 (24,638.63) 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 68,141.72 - 167,007.92 201509 NEW BILLING Sys - 22,047.36 22,047.36 - - 22,047.36 201510 Sys OpS / DISPATCH - 44,634.77 44,634.77 33,430.50 1,600.00 9,604.27 201603 69 KV Trans LINE REBUIL - 1,356,365.47 1,356,365.47 513,273.37 147,914.19 695,177.91 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 131,945.00 171,416.00 172,116.00 201703 BV GROUND WATER - 369,648.98 369,648.98 22,523.78 59,540.18 287,585.02 201706 SUBSTATION K SWITCHGEAR & - 963,211.67 963,211.67 202,802.46 760,218.75 190.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 364,306.11 86,374.65 0.50 201804 SUBSTATION E SWITCHGEAR REPLACEMENT - 5,159,198.91 5,159,198.91 1,738,296.21 1,436,349.20 1,984,553.50 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 80,344.39 814,994.23 202102 Traffic Controller Upgrades - 66,000.00 66,000.00 19,686.00 9,658.00 36,656.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 36,488.32 330,037.46 154,200.79 202111 Transmission Pole Replacement Prog - 888,487.14 888,487.14 71,367.65 322,319.96 494,799.53 202201 Substation A Transformer T-9 Mtce - 180,000.00 180,000.00 70,425.00 - 109,575.00 202204 Relay Test Set - 80,103.50 80,103.50 - 80,103.50202205 Desert Storm Switchgear Cabinets - 500,000.00 500,000.00 249,977.25 - 250,022.75 202206 T & D Road Improvement Projects 500,000.00 - 500,000.00 159,745.00 - 340,255.00 202208 Traffic Signal Detection Systems - 26,235.00 26,235.00 4,600.00 - 21,635.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 - 931,237.66 239,397.25 202304 Controls Software Upgrade - 500,000.00 500,000.00 316,185.80 135,508.20 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 1,402.58 10,158.29 388,439.13 202316 Construct 6 New Dist Feeders Sub S 450,000.00 - 450,000.00 114,227.79 5,873.21 329,899.00 202317 H5 Combustion Turbine Repair - 2,199,611.97 2,199,611.97 1,795,534.99 404,077.15 (0.17) 9669 SERVICE CTR FACILITY IMPROVE. - 520,084.17 520,084.17 4,060.50 - 516,023.67 $ 1,925,000.00 19,418,027.06 21,343,027.06 6,671,661.41 5,217,887.66 9,453,477.99 Current Year Prior Year Budget Budget (Enc Roll) Total Budget 14,289,793.73 $ 7,053,233.33 21,343,027.06 Less Expenditures 1,010,023.39 4,207,864.27 5,217,887.66 Less Encumbrances 4,152,357.98 2,519,303.43 6,671,661.41 Total Available 9,127,412.36 $ 326,065.63 9,453,477.99
19
CITY OF INDEPENDENCE, MISSOURI
For the period ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Operating Revenues: Charges for Services $ 32,165,000 32,165,000 28,417,734 (3,747,266) 88.35% 5.02% Penalties 100,000 100,000 392,776 292,776 392.78% 309.45% Connection/Disconnection Charges 12,000 12,000 17,929 5,929 149.41% 66.08% Miscellaneous 10,000 10,000 17,706 7,706 177.06% 93.73% Returned Check Charges 23,000 23,000 24,885 1,885 108.20% 24.87% Rental Income 85,000 85,000 112,391 27,391 132.22% 48.89% Meter Repairs — — — — 0.00% -83.33% Merchandising Jobbing — — 7,746 7,746 0.00% -83.33% Total Operating Revenues 32,395,000 32,395,000 28,991,167 (3,403,833) 89.49% 6.16% Operating expenses: Personnel Services 9,646,673 9,646,673 6,931,416 2,715,257 71.85% -11.48% Retiree Benefits 364,000 364,000 295,073 68,927 81.06% -2.27% Other Services 13,703,182 13,703,182 8,700,615 5,002,567 63.49% -19.84% Supplies 2,840,700 2,840,700 3,206,834 (366,134) 112.89% 29.56% Capital Projects 7,800,000 22,584,919 8,474,946 14,109,973 37.52% -45.81% Capital Operating 1,134,500 1,134,500 598,939 535,561 52.79% -30.54% Debt Service 2,526,400 2,526,400 2,240,826 285,574 88.70% 5.37% Other Expenses 50,000 50,000 — 50,000 0.00% -83.33% Total Operating Expenses 38,065,455 52,850,374 30,448,649 22,401,725 57.61% -25.72% Nonoperating Revenues (Expenses): Investment Income 657,138 657,138 1,131,032 473,894 172.11% 88.78% Interfund Charges for Support Services 3,300,500 3,300,500 2,799,349 (501,151) 84.82% 1.49% Miscellaneous Revenue (Expense) 16,700 16,700 38,257 21,557 229.08% 145.75% Total Nonoperating Revenue (Expenses) 3,974,338 3,974,338 3,968,638 (5,700) 99.86% 16.53% (1,696,117) (16,481,036) 2,511,156 18,992,192 -15.24% -98.57% Transfers Out – Utility Payments In Lieu of Taxes (2,941,000) (2,941,000) (2,761,064) (179,936) 93.88% 10.55% Transfers In — — — — 0.00% -83.33% Transfers Out — — — — 0.00% -83.33% Total Transfers (2,941,000) (2,941,000) (2,761,064) (179,936) 93.88% 10.55% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (4,637,117) (19,422,036) (249,908) 19,172,128 Beginning Available Resources 48,655,139 Year-End Investment Market Value Adjustment — Ending Available Resources 48,405,231 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 $ 34,005,231 Income (Loss) Before Transfers
Budgetary Comparison Schedule Water
20
Water - Open Capital Projects
As of April 30, 2023
PROJECT PROJECT TITLE ORIGINAL BUDGET NET BUDGET AMENDMENTS REVISED BUDGET ENCUMBRANCES ACTUALS AVAILABLE BUDGET 400708 TREATMENT Plt DISCHARGE $ - 300,000.00 300,000.00 82,458.39 15,541.61 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 1,231,908.00 270.00 230,418.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 - 49,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,550,349.72 320,384.12 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 815,358.30 1,396,304.90 (41,450.90) 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 58,945.88 535,092.39 103,132.50 402011 Main Replace Salisbury/Peck/Geospac - 1,179,100.00 1,179,100.00 223,075.00 833,175.00 122,850.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 771.25 4,013.75 436,013.00 402103 Main Replacement Truman Road - 540,502.00 540,502.00 112,497.65 385,842.35 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 - 9,335.50 89,229.50 402106 Main Replacement Sheley & Northern - 1,017,766.50 1,017,766.50 526,167.70 32,460.30 459,138.50 402107 Facility Improvements/Const/Maint 1,500,000.00 250,000.00 1,750,000.00 85,122.50 14,877.50 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 - 269,500.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 - 135,927.70 14,072.30 402302 HSPS HVAC Improvements 250,000.00 - 250,000.00 106,520.00 - 143,480.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 1,126,854.70 344,320.70 2,322,978.27 9952 SECURITY UPGRADES - 517,590.82 517,590.82 6,202.03 62,884.43 448,504.36 $ 2,800,000.00 23,980,362.62 26,780,362.62 8,258,990.42 4,411,387.45 14,109,984.75 Current Year Prior Year Budget Budget (Enc Roll) Total Budget 22,584,918.85 $ 4,195,443.77 26,780,362.62 Less Expenditures 1,252,553.08 3,158,834.37 4,411,387.45 Less Encumbrances 7,222,393.32 1,036,597.10 8,258,990.42 Total Available 14,109,972.45 $ 12.30 14,109,984.75
21
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Sanitary Sewer For the period ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Operating revenues: Charges for Services $ 35,821,585 35,821,585 29,798,820 (6,022,765) 83.19% -0.14% Penalties 200,000 200,000 133,172 (66,828) 66.59% -16.74% Total operating revenues 36,021,585 36,021,585 29,931,992 (6,089,593) 83.09% -0.24% Operating expenses: Personnel Services 6,796,986 6,796,986 4,682,880 2,114,106 68.90% -14.43% Retiree Benefits 348,000 348,000 300,635 47,365 86.39% 3.06% Other Services 15,594,591 15,594,591 11,206,440 4,388,151 71.86% -11.47% Supplies 1,285,100 1,279,600 763,326 516,274 59.65% -23.68% Capital Projects 1,750,000 14,137,113 1,128,330 13,008,783 7.98% -75.35% Capital Operating 593,000 598,500 523,057 75,443 87.39% 4.06% Debt Service 6,239,100 6,239,100 5,134,792 1,104,308 82.30% -1.03% Other Expenses — — — — 0.00% -83.33% Total Operating Expenses 32,606,777 44,993,890 23,739,460 21,254,430 52.76% -30.57% Nonoperating Revenues (Expenses): Investment Income 326,000 326,000 723,075 397,075 221.80% 138.47% Miscellaneous Revenue (Expense) 7,900 7,900 134,085 126,185 1697.28% 1613.95% Total Nonoperating Revenue (Expenses) 333,900 333,900 857,160 523,260 256.71% 173.38% 3,748,708 (8,638,405) 7,049,692 15,688,097 -81.61% -164.94% Transfers Out – Utility Payments In Lieu of Taxes (3,596,612) (3,596,612) (2,998,659) (597,953) 83.37% 0.04% Transfers In 10,000 10,000 10,000 — 100.00% 16.67% Transfers Out — — (1,724) 1,724 0.00% -83.33% Total Transfers (3,586,612) (3,586,612) (2,990,383) (596,229) 83.38% 0.05% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 162,096 (12,225,017) 4,059,309 16,284,326 Beginning Available Resources 31,326,433 Year-End Investment Market Value Adjustment — Ending Available Resources 35,385,742 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 $ 22,685,742 Income (Loss) Before Transfers
22
Sanitary Sewer - Open Capital Projects
As of April 30, 2023
PROJECT PROJECT TITLE ORIGINAL BUDGET NET BUDGET AMENDMENTS REVISED BUDGET ENCUMBRANCES ACTUALS AVAILABLE BUDGET 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 7,330.16 54,856.46 77,556.46 301705 16TH/SCOTT - 357,362.29 357,362.29 - 1,622.92 355,739.37 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 - 11,327.01 321,449.93 302002 Arlington Improvements - 100,000.00 100,000.00 - - 100,000.00 302003 Bison Park - 107,079.84 107,079.84 37,201.34 34,400.41 35,478.09 302004 Neighborhood Projects 2019-20 - 1,910,076.49 1,910,076.49 30,392.50 6,372.26 1,873,311.73 302005 Biosolids Handling - 2,397,533.81 2,397,533.81 15,301.02 1,390,546.14 991,686.65 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 - 143,950.24 143,950.24 - 107,934.68 36,015.56 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 293,200.00 - 506,800.00 302202 Crackerneck Creek Slope Rehab - 1,877,276.90 1,877,276.90 60,574.07 17,521.08 1,799,181.75 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 46,265.45 189,436.74 1,170,121.78 302206 Railing Safety RCPS & SCPS - 215,000.00 215,000.00 191,950.00 - 23,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 297,674.47 349,278.56 448,452.37 $ 500,000.00 16,256,832.04 16,756,832.04 1,065,279.64 2,528,465.19 13,163,087.21 Current Year Prior Year Budget Budget (Enc Roll) Total Budget 14,137,112.86 $ 2,619,719.18 16,756,832.04 Less Expenditures 333,071.71 2,195,393.48 2,528,465.19 Less Encumbrances 795,258.18 270,021.46 1,065,279.64 Total Available 13,008,782.97 $ 154,304.24 13,163,087.21
23
CITY
MISSOURI
For the period ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Operating revenues: Charges for Services $ — — — — 0.00% -83.33% Miscellaneous — — — — 0.00% -83.33% Total operating revenues — — — — 0.00% -83.33% Operating Expenses: Personnel Services — — — — 0.00% -83.33% Other Services — — 73,108 (73,108) 0.00% -83.33% Supplies — — — — 0.00% -83.33% Capital Outlay 2,309,104 2,652,853 6,344,190 (3,691,337) 239.15% 155.82% Debt Service 5,648,400 5,648,400 5,283,720 364,680 93.54% 10.21% Other Expenses — — — — 0.00% -83.33% Total Operating Expenses 7,957,504 8,301,253 11,701,018 (3,399,765) 140.95% 57.62% Nonoperating Revenues (Expenses): Investment Income 6,200 6,200 214,083 207,883 3452.95% 3369.62% Miscellaneous Revenue (Expense) — — 13 13 0.00% -83.33% Sales Tax 2,400,000 2,400,000 5,202,517 2,802,517 216.77% 133.44% Total Nonoperating Revenue (Expenses) 2,406,200 2,406,200 5,416,613 3,010,413 225.11% 141.78% (5,551,304) (5,895,053) (6,284,405) (389,352) 106.60% 23.27% Transfers Out – Utility Payments In Lieu of Taxes — — — — 0.00% -83.33% Transfers In — — 2,477,500 (2,477,500) 0.00% -83.33% Transfers Out — — — — 0.00% -83.33% Total Transfers — — 2,477,500 (2,477,500) 0.00% -83.33% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (5,551,304) (5,895,053) (3,806,905) 2,088,148 Beginning Available Resources (1,228,630) Less Prior Year Expenses — Year-End Investment Market Value Adjustment — Ending Available Resources $ (5,035,535) Income (Loss) Before Transfers
OF INDEPENDENCE,
Budgetary Comparison Schedule Events Center Debt Service
24
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Central Garage
For the period ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Operating revenues: Charges for Services $ 2,693,100 2,693,100 2,509,901 (183,199) 93.20% 9.87% Miscellaneous — — 11,285 11,285 0.00% -83.33% Total Operating Revenues 2,693,100 2,693,100 2,521,186 (171,914) 93.62% 10.29% Operating Expenses: Personnel Services 853,367 853,367 591,456 261,911 69.31% -14.02% Retiree Benefits 52,000 52,000 36,817 15,183 70.80% -12.53% Other Services 996,700 996,700 1,055,616 (58,916) 105.91% 22.58% Supplies 998,500 998,500 1,043,578 (45,078) 104.51% 21.18% Capital Outlay 8,000 8,000 5,619 2,381 70.24% -13.09% Other Expenses — — — — 0.00% -83.33% Total Operating Expenses 2,908,567 2,908,567 2,733,086 175,481 93.97% 10.64% Nonoperating Revenues (Expenses): Investment Income 6,500 6,500 9,727 3,227 149.65% 66.32% Miscellaneous Revenue (Expense) 281,000 281,000 1,374 (279,626) 0.49% -82.84% Total Nonoperating Revenue (Expenses) 287,500 287,500 11,101 (276,399) 3.86% -79.47% 72,033 72,033 (200,799) (272,832) -278.76% -362.09% Transfers Out – Utility Payments In Lieu of Taxes — — — — 0.00% -83.33% Transfers In — — — — 0.00% -83.33% Transfers Out — — — — 0.00% -83.33% Total Transfers — — — — 0.00% -83.33% Change In Net Position (Budget Basis) $ 72,033 72,033 (200,799) (272,832) Unassigned Fund Balance at Beginning of Year (1,903,375) Cancellation of Prior Year Encumbrances 25,304 Change in Other Fund Balance Components During the Year (9,747) GAAP Components - OPEB and LAGERS 2,263,980 Year-end investment market value adjustment — Ending Unassigned Fund Balance Non-GAAP Basis, 04/30/23 175,363 Other Net Position Components: Assigned - Current Year Encumbrances 609,359 Assigned - Prior Year Encumbrances — Total Fund Balance $ 784,722 Income (Loss) Before Transfers
25
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison
Schedule
Staywell Health Care
For the period ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Operating revenues: Charges for Services $ 17,859,000 17,859,000 16,911,095 (947,905) 94.69% 11.36% Miscellaneous — — — — 0.00% -83.33% Total Operating Revenues 17,859,000 17,859,000 16,911,095 (947,905) 94.69% 11.36% Operating Expenses: Personnel Services 568,500 568,500 317,225 251,275 55.80% -27.53% Other Services 22,268,500 22,268,500 19,262,569 3,005,931 86.50% 3.17% Supplies — — — — 0.00% -83.33% Capital Outlay — — — — 0.00% -83.33% Other Expenses — — — — 0.00% -83.33% Total Operating Expenses 22,837,000 22,837,000 19,579,794 3,257,206 85.74% 2.41% Nonoperating Revenues (Expenses): Investment Income 1,000 1,000 157,238 156,238 15723.80% 15640.47% Miscellaneous Revenue (Expense) 1,077,000 1,077,000 1,283,955 206,955 119.22% 35.89% Total Nonoperating Revenue (Expenses) 1,078,000 1,078,000 1,441,193 363,193 133.69% 50.36% (3,900,000) (3,900,000) (1,227,506) 2,672,494 31.47% -51.86% Transfers In - American Rescue Plan 3,900,000 3,900,000 3,900,000 — 100.00% 16.67% Transfers Out — — — — 0.00% -83.33% Total Transfers 3,900,000 3,900,000 3,900,000 — 100.00% 16.67% Change In Net Position (Budget Basis) $ — — 2,672,494 2,672,494 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, 04/30/23 3,801,705 Other Net Position Components: Assigned - Current Year Encumbrances 37,934 Assigned - Prior Year Encumbrances — Total Fund Balance $ 3,839,639 Income (Loss) Before Transfers
26
CITY OF INDEPENDENCE, MISSOURI
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Operating revenues: Charges for Services $ 4,450,900 4,450,900 3,338,176 (1,112,724) 75.00% -8.33% Miscellaneous — — — — 0.00% -83.33% Total Operating Revenues 4,450,900 4,450,900 3,338,176 (1,112,724) 75.00% -8.33% Operating Expenses: Personnel Services — — 6,458 (6,458) 0.00% -83.33% Other Services 4,558,654 4,558,654 2,536,519 2,022,135 55.64% -27.69% Supplies — — 21,290 (21,290) 0.00% -83.33% Capital Outlay — — — — 0.00% -83.33% Other Expenses — — — — 0.00% -83.33% Total Operating Expenses 4,558,654 4,558,654 2,564,267 1,994,387 56.25% -27.08% Nonoperating Revenues (Expenses): Investment Income 6,000 6,000 94,522 88,522 1575.37% 1492.04% Miscellaneous Revenue (Expense) — — 6,521 6,521 0.00% -83.33% Total Nonoperating Revenue (Expenses) 6,000 6,000 101,043 95,043 1684.05% 1600.72% (101,754) (101,754) 874,952 976,706 -859.87% -943.20% Transfers In — — — — 0.00% -83.33% Transfers Out — — — — 0.00% -83.33% Total Transfers — — — — 0.00% -83.33% Change In Net Position (Budget Basis) $ (101,754) (101,754) 874,952 976,706 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, 04/30/23 (5,521,255) Other Net Position Components: Restricted - Work Comp Escrow Assigned - Current Year Encumbrances 25,077 Assigned - Prior Year Encumbrances 12,500 Total Fund Balance $ (5,483,678) Income (Loss) Before Transfers
Comparison Schedule
Compensation
27
Budgetary
Workers'
For the period ended April 30, 2023
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Risk
Management
For the period ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Operating revenues: Charges for Services $ 3,196,000 3,196,000 2,453,583 (742,417) 76.77% -6.56% Miscellaneous — — — — 0.00% -83.33% Total Operating Revenues 3,196,000 3,196,000 2,453,583 (742,417) 76.77% -6.56% Operating Expenses: Personnel Services — — 6,458 (6,458) 0.00% -83.33% Other Services 2,936,292 2,936,292 1,546,206 1,390,086 52.66% -30.67% Supplies 2,000 2,000 — 2,000 0.00% -83.33% Capital Outlay — — — — 0.00% -83.33% Other Expenses — — — — 0.00% -83.33% Total Operating Expenses 2,938,292 2,938,292 1,552,664 1,385,628 52.84% -30.49% Nonoperating Revenues (Expenses): Investment Income 23,000 23,000 42,157 19,157 183.29% 99.96% Miscellaneous Revenue (Expense) — — — — 0.00% -83.33% Total Nonoperating Revenue (Expenses) 23,000 23,000 42,157 19,157 183.29% 99.96% 280,708 280,708 943,076 662,368 335.96% 252.63% Transfers Out – Utility Payments In Lieu of Taxes — — — — 0.00% -83.33% Transfers In — — — — 0.00% -83.33% Transfers Out — — — — 0.00% -83.33% Total Transfers — — — — 0.00% -83.33% Change In Net Position (Budget Basis) $ 280,708 280,708 943,076 662,368 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, 04/30/23 2,695,818 Other Net Position Components: Assigned - Current Year Encumbrances 18,918 Assigned - Prior Year Encumbrances — Total Fund Balance $ 2,714,736 Income (Loss) Before Transfers
28
CITY OF INDEPENDENCE, MISSOURI
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Operating revenues: Charges for Services $ 10,506,740 10,506,740 8,755,617 (1,751,123) 83.33% 0.00% Miscellaneous — — — — 0.00% -83.33% Total Operating Revenues 10,506,740 10,506,740 8,755,617 (1,751,123) 83.33% 0.00% Operating Expenses: Personnel Services 5,575,572 5,479,572 4,029,307 1,450,265 73.53% -9.80% Retiree Benefits 268,000 268,000 197,234 70,766 73.59% -9.74% Other Services 4,446,414 4,477,414 4,117,264 360,150 91.96% 8.63% Supplies 29,900 29,900 23,382 6,518 78.20% -5.13% Capital Outlay 142,500 207,500 299,965 (92,465) 144.56% 61.23% Other Expenses — — — — 0.00% -83.33% Total Operating Expenses 10,462,386 10,462,386 8,667,152 1,795,234 82.84% -0.49% Nonoperating Revenues (Expenses): Investment Income — — — — 0.00% -83.33% Miscellaneous Revenue (Expense) — — 15,568 15,568 0.00% -83.33% Total Nonoperating Revenue (Expenses) — — 15,568 15,568 0.00% -83.33% 44,354 44,354 104,033 59,679 234.55% 151.22% Transfers Out – Utility Payments In Lieu of Taxes — — — — 0.00% -83.33% Transfers In – CARES Act — — — — 0.00% -83.33% Transfers Out — — — — 0.00% -83.33% Total Transfers — — — — 0.00% -83.33% Change In Net Position (Budget Basis) $ 44,354 44,354 104,033 59,679 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 602,585 Ending Unassigned Fund Balance Non-GAAP Basis, 04/30/23 1,677,362 Other Net Position Components: Assigned - Current Year Encumbrances 281,165 Assigned - Prior Year Encumbrances 2,921 Total Fund Balance $ 1,961,448 Income (Loss) Before Transfers
Budgetary Comparison Schedule Finance & Support Services
the period ended April 30, 2023 29
For
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Charges for Services $ 9,289 9,289 12,386 3,097 133.34% 50.01% Investment Income (Loss) — — 2,826 2,826 0.00% -83.33% Other Revenue — — — — 0.00% -83.33% Total Revenues 9,289 9,289 15,212 5,923 163.76% 80.43% Expenditures: General Government — — 164 (164) 0.00% -83.33% Debt Service 10,200 10,200 9,467 733 92.81% 9.48% Total Expenditures 10,200 10,200 9,631 569 94.42% 11.09% Other Financing Uses: Transfers Out/Capital Outlay — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total expenditures and other financing uses 10,200 10,200 9,631 569 94.42% 11.09% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (911) (911) 5,581 6,492 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, 04/30/23 109,816 Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Total Fund Balance $ 109,816 CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Debt Service - Neighborhood Improvement Districts For the period ended April 30, 2023 30
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Charges for Services $ — — 5,506 5,506 0.00% -83.33% Investment Income — — 3,790 3,790 0.00% -83.33% Intergovernmental — — — — 0.00% -83.33% Other Revenue — — — — 0.00% -83.33% Total Revenues — — 9,296 9,296 0.00% -83.33% Other Financing Sources: Transfers In — — 115 115 0.00% -83.33% Proceeds From Bond Issuance — — — — — Total Other Financing Sources — — 115 115 0.00% -83.33% Total Revenues and Other Financing Sources — — 9,411 9,411 0.00% -83.33% Expenditures: Public Works — — 24 (24) 0.00% -83.33% Culture and Recreation — — — — 0.00% -83.33% Capital Outlay — 263,944 869,051 (605,107) 329.26% 245.93% Total Expenditures — 263,944 869,075 (605,131) 329.26% 245.93% Other Financing Uses: Transfers Out/Capital Outlay — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Financing Uses — 263,944 869,075 (605,131) 329.26% 245.93% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ — (263,944) (859,664) (595,720) 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, 04/30/23 (879,461) Other Fund Balance Components: Committed - Current Year Encumbrances 859,901 Committed - Prior Year Encumbrances 95,506 Total Fund Balance $ 75,946 Budgetary Comparison Schedule
Street Improvements Capital Project Fund For the period ended April 30, 2023 31
CITY OF INDEPENDENCE, MISSOURI
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Charges for Services $ — — — — 0.00% -83.33% Investment Income (Loss) — — 457 457 0.00% -83.33% Other Revenue — — — — 0.00% -83.33% Total Revenues — — 457 457 0.00% -83.33% Expenditures: Public Works — — 7 (7) 0.00% -83.33% Culture and Recreation — — — — 0.00% -83.33% Capital Outlay — — — — 0.00% -83.33% Total Expenditures — — 7 (7) 0.00% -83.33% Other Financing Uses: Transfers Out/Capital Outlay — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Financing Uses — — 7 (7) 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ — — 450 450 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, 04/30/23 21,663 Other Fund Balance Components: Committed - Current Year Encumbrances — Committed - Prior Year Encumbrances — Total Fund Balance $ 21,663
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Revolving Public Improvements Capital Project Fund For the period ended April 30, 2023 32
CITY
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Charges for Services $ — — — — 0.00% -83.33% Intergovernmental — — — — 0.00% -83.33% Investment Income — — 374 374 0.00% -83.33% Other Revenue — — 3,125 3,125 0.00% -83.33% Total revenues — — 3,499 3,499 0.00% -83.33% Other Financing Sources: Transfers In — — 156,532 156,532 0.00% -83.33% Proceeds from bond issuance — — — — Total Other Financing Sources — — 156,532 156,532 0.00% -83.33% Total Revenues and Other Financing Sources — — 160,031 160,031 0.00% -83.33% Expenditures: Public Works — — 9 (9) 0.00% -83.33% Culture and Recreation — — — — 0.00% -83.33% Capital Outlay — 231,511 115,327 116,184 49.81% -33.52% Total Expenditures — 231,511 115,336 116,175 49.82% -33.51% Other Financing Uses: Transfers Out/Capital Outlay — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total expenditures and other financing uses — 231,511 115,336 116,175 49.82% -33.51% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ — (231,511) 44,695 276,206 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, 04/30/23 (120,191) Other Fund Balance Components: Committed - Current Year Encumbrances 42,916 Committed - Prior Year Encumbrances — Total Fund Balance $ (77,275)
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Buildings and Other Improvements Capital Project Fund For the period ended April 30, 2023 33
CITY
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Charges for Services $ — — — — 0.00% -83.33% Investment Income — — — — 0.00% -83.33% Other Revenue — — — — 0.00% -83.33% Total revenues — — — — 0.00% -83.33% Expenditures: Public Works — — — — 0.00% -83.33% Culture and Recreation — — — — 0.00% -83.33% Capital Outlay — — — — 0.00% -83.33% Total Expenditures — — — — 0.00% -83.33% Other Financing Uses: Transfers Out/Capital Outlay — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total expenditures and other financing uses — — — — 0.00% -83.33% 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, 04/30/23 (16,155) Fund Balance Components: Committed - Current Year Encumbrances — Committed - Prior Year Encumbrances — Total Fund Balance $ (16,155)
Budgetary Comparison Schedule Storm Drainage Capital Project Fund For the period ended April 30, 2023 34
CITY OF INDEPENDENCE, MISSOURI
CITY
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Charges for Services $ — — — — 0.00% -83.33% Investment Income (Loss) — — 684 684 0.00% -83.33% Other Revenue — — — — 0.00% -83.33% Total revenues — — 684 684 0.00% -83.33% Expenditures: Public Works — — 10 (10) 0.00% -83.33% Culture and Recreation — — — — 0.00% -83.33% Capital Outlay — — — — 0.00% -83.33% Total Expenditures — — 10 (10) 0.00% -83.33% Other Financing Uses: Transfers Out/Capital Outlay — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total expenditures and other financing uses — — 10 (10) 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ — — 674 674 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, 04/30/23 31,555 Fund Balance Components: Committed - Current Year Encumbrances — Committed - Prior Year Encumbrances — Total Fund Balance $ 31,555
Improvements Capital Project Fund
the period ended April 30, 2023 35
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Park
For
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Charges for Services $ — — — — 0.00% -83.33% Investment Income — — — — 0.00% -83.33% Other Revenue — — — — 0.00% -83.33% Total Revenues — — — — 0.00% -83.33% Expenditures: Public Works — — — — 0.00% -83.33% Culture and Recreation — — — — 0.00% -83.33% Capital Outlay — — — — 0.00% -83.33% Total Expenditures — — — — 0.00% -83.33% Other Financing Uses: Transfers Out/Capital Outlay — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Financing Uses — — — — 0.00% -83.33% 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, 04/30/23 — Other Net Position Components: Committed - Current Year Encumbrances — Committed - Prior Year Encumbrances — Total Net Position $ — CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Private Purpose Expendable Trust Fund - Vaile Mansion For the period ended April 30, 2023 36
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Independence
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Sales Taxes $ 8,470,843 8,470,843 6,637,953 (1,832,890) 78.36% -4.97% Investment Income 30,000 30,000 344,955 314,955 1149.85% 1066.52% Total Revenues 8,500,843 8,500,843 6,982,908 (1,517,935) 82.14% -1.19% Expenditures: Administrative Fee 169,417 169,417 132,759 36,658 78.36% -4.97% Insurance 4,750 4,750 — 4,750 0.00% -83.33% Legal 44,500 44,500 2,390 42,110 5.37% -77.96% Audit 5,500 5,500 5,500 — 100.00% 16.67% Banking 8,600 8,600 9,199 (599) 106.97% 23.64% Maintenance 100,000 100,000 — 100,000 0.00% -83.33% Capital Outlay — — — — 0.00% -83.33% Other — — 3,375 (3,375) 0.00% -83.33% Total Expenditures 332,767 332,767 153,223 179,544 46.05% -37.28% Other Financing Uses: Transfers Out - EATS 1,175,000 1,175,000 726,631 448,369 61.84% -21.49% Transfers Out - Debt Service (City) 4,202,213 4,202,213 4,475,886 (273,673) 106.51% 23.18% Transfers Out - Captial Projects 2,309,104 2,309,104 2,404,392 (95,288) 104.13% 20.80% Transfers Out - Other Items — — 73,108 (73,108) 0.00% -83.33% Total Other Financing Uses 7,686,317 7,686,317 7,680,017 6,300 99.92% 16.59% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 481,759 481,759 (850,332) (1,332,091) 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, 04/30/23 9,589,117 Other Fund Balance Components: Restricted - current year encumbrances — Restricted - prior year encumbrances 5,795 Total Fund Balance $ 9,594,912
Events Center CID
the period ended April 30, 2023 37
For
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
For the period ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Sales taxes $ — — 442,071 442,071 0.00% -83.33% Investment income — — 8,976 8,976 0.00% -83.33% Total revenues — — 451,047 451,047 0.00% -83.33% Expenditures: Administrative fee — — 8,841 (8,841) 0.00% -83.33% Insurance — — 2,354 (2,354) 0.00% -83.33% Legal — — 1,250 (1,250) 0.00% -83.33% Audit — — 5,500 (5,500) 0.00% -83.33% Banking — — 493 (493) 0.00% -83.33% Contract services — — — — 0.00% -83.33% Capital outlay — — — — 0.00% -83.33% Other — — — — 0.00% -83.33% Total expenditures — — 18,438 (18,438) 0.00% -83.33% Other financing uses: Transfers out - EATS — — 221,036 (221,036) 0.00% -83.33% Transfers out - Debt Service (City) — — 315,000 (315,000) 0.00% -83.33% Total other financing uses — — 536,036 (536,036) 0.00% -83.33% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ — — (103,427) (103,427) Unassigned Fund Balance at Beginning of Year 190,339 Cancellation of Prior Year Encumbrances — Change in Other Fund Balance Components During the Year (554) Unassigned Ending Fund Balance, 04/30/23 86,358 Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Restricted - City Transportation 7,729 Total Fund Balance $ 94,087
Crackerneck Creek TDD
38
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ — — 15,235,356 15,235,356 0.00% -83.33% Investment Income (Loss) — — 771,549 751,272 0.00% -83.33% Other revenue — — 931,347 931,347 0.00% -83.33% Total Revenues — — 16,938,252 16,917,975 0.00% -83.33% Other Financing Sources: Transfers In — — 1,041,630 1,041,630 0.00% -83.33% Proceeds from bond issuance — — — — Total Other Financing Sources — — 1,041,630 1,041,630 0.00% -83.33% Total Revenues and Other Financing Sources — — 17,979,882 17,959,605 0.00% -83.33% Expenditures: Tax Increment Financing — — 1,579,267 (1,578,997) 0.00% -83.33% Debt Service Principal 4,775,000 4,775,000 6,363,768 (1,588,768) 133.27% 49.94% Interest and Fiscal Agent Fees 4,356,100 4,356,100 4,977,775 (621,675) 114.27% 30.94% Debt Issuance Costs — — — — 0.00% -83.33% Total Expenditures 9,131,100 9,131,100 12,920,810 (3,789,440) 141.50% 58.17% Other Financing Uses: Issuance of Debt — — — — 0.00% -83.33% Reoffering Premium/Original Issue Discount — — — — 0.00% -83.33% Payment to Refund Loans Escrow Agent — — — — 0.00% -83.33% Transfers Out — — 726,631 (726,631) 0.00% -83.33% Total Other Financing Uses — — 726,631 (726,631) 0.00% -83.33% Total Expenditures and Other Financing Uses 9,131,100 9,131,100 13,647,441 (4,516,071) 149.46% 66.13% Excess of Revenues Over (Under) Expenditures and other financing uses $ (9,131,100) (9,131,100) 4,332,441 13,463,541 Unassigned Fund Balance at Beginning of Year 21,016,591 Cancellation of Prior Year Encumbrances — Change in Other Fund Balance Components During the Year 392,126 Year-End Investment Market Value Adjustment — Unassigned Ending Fund Balance, 04/30/23 25,741,158 Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Restricted - Trust Debt Service 10,132,708 Total Fund Balance $ 35,873,866 CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Tax Increment Financing Summary For the Period Ended April 30, 2023 39
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ — — 35,937 35,937 0.00% -83.33% Investment Income (Loss) — — 979 979 0.00% -83.33% Other Revenue — — 104,401 104,401 0.00% -83.33% Total Revenues — — 141,317 141,317 0.00% -83.33% Other Financing Sources: Transfers In — — — — 0.00% -83.33% Proceeds from bond issuance — — — — Total Other Financing Sources — — — — 0.00% -83.33% Total Revenues and Other Financing Sources — — 141,317 141,317 0.00% -83.33% Expenditures: Tax Increment Financing — — 3,058 (3,058) 0.00% -83.33% Debt Service Principal 210,000 210,000 210,000 — 100.00% 16.67% Interest and Fiscal Agent Fees 321,000 321,000 320,938 62 99.98% 16.65% Debt Issuance Costs — — — — 0.00% -83.33% Total Expenditures 531,000 531,000 533,996 (2,996) 100.56% 17.23% Other Financing Uses: Issuance of Debt — — — — 0.00% -83.33% Reoffering Premium/Original Issue Discount — — — — 0.00% -83.33% Payment to Refund Loans Escrow Agent — — — — 0.00% -83.33% Transfers Out — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Financing Uses 531,000 531,000 533,996 (2,996) 100.56% 17.23% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (531,000) (531,000) (392,679) 138,321 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, 04/30/23 (1,318,664) Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Restricted - Trust Debt Service 483,752 Total Fund Balance $ (834,912)
TIF
40
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Santa Fe
For the Period Ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ — — 228,859 228,859 0.00% -83.33% Investment Income (Loss) — — — — 0.00% -83.33% Other Revenue — — — — 0.00% -83.33% Total Revenues — — 228,859 228,859 0.00% -83.33% Other Financing Sources: Transfers In — — — — 0.00% -83.33% Proceeds from bond issuance — — — — Total Other Financing Sources — — — — 0.00% -83.33% Total Revenues and Other Financing Sources — — 228,859 228,859 0.00% -83.33% Expenditures: Tax Increment Financing — — — — 0.00% -83.33% Debt Service Principal — — — — 0.00% -83.33% Interest and Fiscal Agent Fees — — — — 0.00% -83.33% Debt Issuance Costs — — — — 0.00% -83.33% Total Expenditures — — — — 0.00% -83.33% Other Financing Uses: Issuance of Debt — — — — 0.00% -83.33% Reoffering Premium/Original Issue Discount — — — — 0.00% -83.33% Payment to Refund Loans Escrow Agent — — — — 0.00% -83.33% Transfers Out — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Financing Uses — — — — 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ — — 228,859 228,859 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, 04/30/23 (2,465,083) Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Restricted - Trust Debt Service — Total Fund Balance $ (2,465,083)
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Hartman Heritage TIF For the Period Ended April 30, 2023 41
CITY
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ — — (1,288) (1,288) 0.00% -83.33% Investment Income (Loss) — — 4 4 0.00% -83.33% Other Revenue — — — — 0.00% -83.33% Total Revenues — — (1,284) (1,284) 0.00% -83.33% Expenditures: Tax Increment Financing — — (1,284) 1,284 0.00% -83.33% Debt Service Principal — — — — 0.00% -83.33% Interest and Fiscal Agent Fees — — — — 0.00% -83.33% Debt Issuance Costs — — — — 0.00% -83.33% Total Expenditures — — (1,284) 1,284 0.00% -83.33% Other Financing Uses: Issuance of Debt — — — — 0.00% -83.33% Reoffering Premium/Original Issue Discount — — — — 0.00% -83.33% Payment to Refund Loans Escrow Agent — — — — 0.00% -83.33% Transfers Out — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Financing Uses — — (1,284) 1,284 0.00% -83.33% 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, 04/30/23 — Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Restricted - Trust Debt Service — Total Fund Balance $ —
Farm TIF
42
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Drumm
For the Period Ended April 30, 2023
CITY
MISSOURI
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ — — 4,514,056 4,514,056 0.00% -83.33% Investment Income (Loss) — — 586,520 586,520 0.00% -83.33% Other Revenue — — 1 1 0.00% -83.33% Total Revenues — — 5,100,577 5,100,577 0.00% -83.33% Other Financing Sources: Transfers In — — 677,468 677,468 0.00% -83.33% Proceeds from bond issuance — — — — Total Other Financing Sources — — 677,468 677,468 0.00% -83.33% Total Revenues and Other Financing Sources — — 5,778,045 5,778,045 0.00% -83.33% Expenditures: Tax Increment Financing — — 385,880 (385,880) 0.00% -83.33% Debt Service Principal — — — — 0.00% -83.33% Interest and Fiscal Agent Fees — — — — 0.00% -83.33% Debt Issuance Costs — — — — 0.00% -83.33% Total Expenditures — — 385,880 (385,880) 0.00% -83.33% Other Financing Uses: Issuance of Debt — — — — 0.00% -83.33% Reoffering Premium/Original Issue Discount — — — — 0.00% -83.33% Payment to Refund Loans Escrow Agent — — — — 0.00% -83.33% Transfers Out — — 677,468 (677,468) 0.00% -83.33% Total Other Financing Uses — — 677,468 (677,468) 0.00% -83.33% Total Expenditures and Other Financing Uses — — 1,063,348 (1,063,348) 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ — — 4,714,697 4,714,697 Unassigned Fund Balance at Beginning of Year 17,258,732 Cancellation of Prior Year Encumbrances — Change in Other Fund Balance Components During the Year 392,126 Year-End Investment Market Value Adjustment — Unassigned Ending Fund Balance, 04/30/23 22,365,555 Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Restricted - Trust Debt Service — Total Fund Balance $ 22,365,555
43
OF INDEPENDENCE,
Budgetary Comparison Schedule Eastland TIF For the Period Ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ — — 70,396 70,396 0.00% -83.33% Investment Income (Loss) — — 4,458 4,458 0.00% -83.33% Other Revenue — — — — 0.00% -83.33% Total Revenues — — 74,854 74,854 0.00% -83.33% Expenditures: Tax Increment Financing — — 1,564 (1,564) 0.00% -83.33% Debt Service Principal — — — — 0.00% -83.33% Interest and Fiscal Agent Fees — — 79,700 (79,700) 0.00% -83.33% Debt Issuance Costs — — — — 0.00% -83.33% Total Expenditures — — 81,264 (81,264) 0.00% -83.33% Other Financing Uses: Issuance of Debt — — — — 0.00% -83.33% Reoffering Premium/Original Issue Discount — — — — 0.00% -83.33% Payment to Refund Loans Escrow Agent — — — — 0.00% -83.33% Transfers Out — — — — 0.00% -83.33% — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% -83.33% Total Expenditures and Other Financing Uses — — 81,264 (81,264) 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ — — (6,410) (6,410) 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, 04/30/23 3,700 Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Restricted - Trust Debt Service — Total Fund Balance $ 3,700
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule North Independence TIF For the Period Ended April 30, 2023 44
CITY
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Crackerneck
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ — — 1,433,917 1,433,917 0.00% -83.33% Investment Income (Loss) — — 59,437 59,437 0.00% -83.33% Other Revenue — — 826,945 826,945 0.00% -83.33% Total Revenues — — 2,320,299 2,320,299 0.00% -83.33% Other Financing Sources: Transfers In — — 315,000 315,000 0.00% -83.33% Proceeds from bond issuance — — — — Total Other Financing Sources — — 315,000 315,000 0.00% -83.33% Total Revenues and Other Financing Sources — — 2,635,299 2,635,299 0.00% -83.33% Expenditures: Tax Increment Financing — — 38,303 (38,303) 0.00% -83.33% Debt Service Principal 2,260,000 2,260,000 2,260,000 — 100.00% 16.67% Interest and Fiscal Agent Fees 3,270,500 3,270,500 3,270,363 137 100.00% 16.67% Debt Issuance Costs — — — — 0.00% -83.33% Total Expenditures 5,530,500 5,530,500 5,568,666 (38,166) 100.69% 17.36% Other Financing Uses: Issuance of Debt — — — — 0.00% -83.33% Reoffering Premium/Original Issue Discount — — — — 0.00% -83.33% Payment to Refund Loans Escrow Agent — — — — 0.00% -83.33% Transfers Out — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Financing Uses 5,530,500 5,530,500 5,568,666 (38,166) 100.69% 17.36% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (5,530,500) (5,530,500) (2,933,367) 2,597,133 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, 04/30/23 1,563,938 Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Restricted - Trust Debt Service 6,300,062 Total Fund Balance $ 7,864,000
Creek TIF
the Period
45
For
Ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ — — 749,344 749,344 0.00% -83.33% Investment Income (Loss) — — 1,812 1,812 0.00% -83.33% Other Revenue — — — — 0.00% -83.33% Total Revenues — — 751,156 751,156 0.00% -83.33% Expenditures: Tax Increment Financing — — 15,053 (15,053) 0.00% -83.33% Debt Service Principal — — 728,633 (728,633) 0.00% -83.33% Interest and Fiscal Agent Fees — — 24,967 (24,967) 0.00% -83.33% Debt Issuance Costs — — — — 0.00% -83.33% Total Expenditures — — 768,653 (768,653) 0.00% -83.33% Other Financing Uses: Issuance of Debt — — — — 0.00% -83.33% Reoffering Premium/Original Issue Discount — — — — 0.00% -83.33% Payment to Refund Loans Escrow Agent — — — — 0.00% -83.33% Transfers Out — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Financing Uses — — 768,653 (768,653) 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ — — (17,497) (17,497) 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, 04/30/23 (8,037) Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Restricted - Trust Debt Service — Total Fund Balance $ (8,037)
Comparison Schedule Old Landfill TIF For the Period Ended April 30, 2023 46
CITY OF INDEPENDENCE, MISSOURI Budgetary
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ — — 445,690 445,690 0.00% -83.33% Investment Income (Loss) — — 989 989 0.00% -83.33% Other Revenue — — — — 0.00% -83.33% Total Revenues — — 446,679 446,679 0.00% -83.33% Other Financing Sources: Transfers In — — 39,832 39,832 0.00% -83.33% Proceeds from bond issuance — — — — Total Other Financing Sources — — 39,832 39,832 0.00% -83.33% Total Revenues and Other Financing Sources — — 486,511 486,511 0.00% -83.33% Expenditures: Tax Increment Financing — — 9,412 (9,412) 0.00% -83.33% Debt Service Principal — — 417,626 (417,626) 0.00% -83.33% Interest and Fiscal Agent Fees — — 62,174 (62,174) 0.00% -83.33% Debt Issuance Costs — — — — 0.00% -83.33% Total Expenditures — — 489,212 (489,212) 0.00% -83.33% Other Financing Uses: Issuance of Debt — — — — 0.00% -83.33% Reoffering Premium/Original Issue Discount — — — — 0.00% -83.33% Payment to Refund Loans Escrow Agent — — — — 0.00% -83.33% Transfers Out — — 39,832 (39,832) 0.00% -83.33% Total Other Financing Uses — — 39,832 (39,832) 0.00% -83.33% Total Expenditures and Other Financing Uses — — 529,044 (529,044) 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ — — (42,533) (42,533) 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, 04/30/23 12,083 Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Restricted - Trust Debt Service — Total Fund Balance $ 12,083
Budgetary Comparison Schedule Trinity TIF For the Period Ended April 30, 2023 47
CITY OF INDEPENDENCE, MISSOURI
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
HCA
For the Period Ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ — — 4,203,329 4,203,329 0.00% -83.33% Investment Income (Loss) — — 36,208 36,208 0.00% -83.33% Other Revenue — — — — 0.00% -83.33% Total Revenues — — 4,239,537 4,239,537 0.00% -83.33% Other Financing Sources: Transfers In — — 9,330 9,330 0.00% -83.33% Proceeds from bond issuance — — — — Total Other Financing Sources — — 9,330 9,330 0.00% -83.33% Total Revenues and Other Financing Sources — — 4,248,867 4,248,867 0.00% -83.33% Expenditures: Tax Increment Financing — — 988,337 (988,337) 0.00% -83.33% Debt Service Principal 2,305,000 2,305,000 2,305,000 — 100.00% 16.67% Interest and Fiscal Agent Fees 764,600 764,600 764,600 — 100.00% 16.67% Debt Issuance Costs — — — — 0.00% -83.33% Total Expenditures 3,069,600 3,069,600 4,057,937 (988,337) 132.20% 48.87% Other Financing Uses: Issuance of Debt — — — — 0.00% -83.33% Reoffering Premium/Original Issue Discount — — — — 0.00% -83.33% Payment to Refund Loans Escrow Agent — — — — 0.00% -83.33% Transfers Out — — 9,331 (9,331) 0.00% -83.33% Total Other Financing Uses — — 9,331 (9,331) 0.00% -83.33% Total Expenditures and Other Financing Uses 3,069,600 3,069,600 4,067,268 (997,668) 132.50% 49.17% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (3,069,600) (3,069,600) 181,599 3,251,199 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, 04/30/23 1,121,977 Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Restricted - Trust Debt Service 3,348,894 Total Fund Balance $ 4,470,871
TIF
48
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Cinema East TIF
For the Period Ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ — — 229,552 229,552 0.00% -83.33% Investment Income (Loss) — — 1,460 1,460 0.00% -83.33% Other Revenue — — — — 0.00% -83.33% Total Revenues — — 231,012 231,012 0.00% -83.33% Expenditures: Tax Increment Financing — — 5,058 (5,058) 0.00% -83.33% Debt Service Principal — — 78,126 (78,126) 0.00% -83.33% Interest and Fiscal Agent Fees — — 174,524 (174,524) 0.00% -83.33% Debt Issuance Costs — — — — 0.00% -83.33% Total Expenditures — — 257,708 (257,708) 0.00% -83.33% Other Financing Uses: Issuance of Debt — — — — 0.00% -83.33% Reoffering Premium/Original Issue Discount — — — — 0.00% -83.33% Payment to Refund Loans Escrow Agent — — — — 0.00% -83.33% Transfers Out — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Financing Uses — — 257,708 (257,708) 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ — — (26,696) (26,696) 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, 04/30/23 26,546 Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Restricted - Trust Debt Service — Total Fund Balance $ 26,546
49
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
23rd & Noland Project 1 TIF
For the Period Ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ — — (151,142) (151,142) 0.00% -83.33% Investment Income (Loss) — — — — 0.00% -83.33% Other Revenue — — — — 0.00% -83.33% Total Revenues — — (151,142) (151,142) 0.00% -83.33% Expenditures: Tax Increment Financing — — 10 (10) 0.00% -83.33% Debt Service Principal — — — — 0.00% -83.33% Interest and Fiscal Agent Fees — — — — 0.00% -83.33% Debt Issuance Costs — — — — 0.00% -83.33% Total Expenditures — — 10 (10) 0.00% -83.33% Other Financing Uses: Issuance of Debt — — — — 0.00% -83.33% Reoffering Premium/Original Issue Discount — — — — 0.00% -83.33% Payment to Refund Loans Escrow Agent — — — — 0.00% -83.33% Transfers Out — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Financing Uses — — 10 (10) 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ — — (151,152) (151,152) 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, 04/30/23 6,210 Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Restricted - Trust Debt Service — Total Fund Balance $ 6,210
50
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
23rd & Noland Project 2 TIF
For the Period Ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ — — 15,082 15,082 0.00% -83.33% Investment Income (Loss) — — 78 78 0.00% -83.33% Other Revenue — — — — 0.00% -83.33% Total Revenues — — 15,160 15,160 0.00% -83.33% Expenditures: Tax Increment Financing — — 369 (369) 0.00% -83.33% Debt Service Principal — — 22,400 (22,400) 0.00% -83.33% Interest and Fiscal Agent Fees — — — — 0.00% -83.33% Debt Issuance Costs — — — — 0.00% -83.33% Total Expenditures — — 22,769 (22,769) 0.00% -83.33% Other Financing Uses: Issuance of Debt — — — — 0.00% -83.33% Reoffering Premium/Original Issue Discount — — — — 0.00% -83.33% Payment to Refund Loans Escrow Agent — — — — 0.00% -83.33% Transfers Out — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Financing Uses — — 22,769 (22,769) 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ — — (7,609) (7,609) 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, 04/30/23 434 Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Restricted - Trust Debt Service — Total Fund Balance $ 434
51
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
23rd & Noland Project 3 TIF
For the Period Ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ — — 29,148 29,148 0.00% -83.33% Investment Income (Loss) — — 322 322 0.00% -83.33% Other Revenue — — — — 0.00% -83.33% Total Revenues — — 29,470 29,470 0.00% -83.33% Expenditures: Tax Increment Financing — — 722 (722) 0.00% -83.33% Debt Service Principal — — — — 0.00% -83.33% Interest and Fiscal Agent Fees — — — — 0.00% -83.33% Debt Issuance Costs — — — — 0.00% -83.33% Total Expenditures — — 722 (722) 0.00% -83.33% Other Financing Uses: Issuance of Debt — — — — 0.00% -83.33% Reoffering Premium/Original Issue Discount — — — — 0.00% -83.33% Payment to Refund Loans Escrow Agent — — — — 0.00% -83.33% Transfers Out — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Financing Uses — — 722 (722) 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ — — 28,748 28,748 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, 04/30/23 36,638 Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Restricted - Trust Debt Service — Total Fund Balance $ 36,638
52
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
23rd & Noland Project 4 TIF
For the Period Ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ — — 470,822 470,822 0.00% -83.33% Investment Income (Loss) — — 6,321 6,321 0.00% -83.33% Other Revenue — — — — 0.00% -83.33% Total Revenues — — 477,143 477,143 0.00% -83.33% Expenditures: Tax Increment Financing — — 11,131 (11,131) 0.00% -83.33% Debt Service Principal — — — — 0.00% -83.33% Interest and Fiscal Agent Fees — — — — 0.00% -83.33% Debt Issuance Costs — — — — 0.00% -83.33% Total Expenditures — — 11,131 (11,131) 0.00% -83.33% Other Financing Uses: Issuance of Debt — — — — 0.00% -83.33% Reoffering Premium/Original Issue Discount — — — — 0.00% -83.33% Payment to Refund Loans Escrow Agent — — — — 0.00% -83.33% Transfers Out — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Financing Uses — — 11,131 (11,131) 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ — — 466,012 466,012 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, 04/30/23 555,908 Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Restricted - Trust Debt Service — Total Fund Balance $ 555,908
53
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Independence Square TIF
For the Period Ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ — — 285,535 285,535 0.00% -83.33% Investment Income (Loss) — — 22,230 22,230 0.00% -83.33% Other Revenue — — — — 0.00% -83.33% Total Revenues — — 307,765 307,765 0.00% -83.33% Expenditures: Tax Increment Financing — — 67,420 (67,420) 0.00% -83.33% Debt Service Principal — — — — 0.00% -83.33% Interest and Fiscal Agent Fees — — — — 0.00% -83.33% Debt Issuance Costs — — — — 0.00% -83.33% Total Expenditures — — 67,420 (67,420) 0.00% -83.33% Other Financing Uses: Issuance of Debt — — — — 0.00% -83.33% Reoffering Premium/Original Issue Discount — — — — 0.00% -83.33% Payment to Refund Loans Escrow Agent — — — — 0.00% -83.33% Transfers Out — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Financing Uses — — 67,420 (67,420) 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ — — 240,345 240,345 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, 04/30/23 1,009,006 Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Restricted - Trust Debt Service — Total Fund Balance $ 1,009,006
54
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
I-70 & Little Blue Parkway Project 1 TIF For the Period Ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ — — 2,111,211 2,111,211 0.00% -83.33% Investment Income (Loss) — — 24,957 24,957 0.00% -83.33% Other Revenue — — — — 0.00% -83.33% Total Revenues — — 2,136,168 2,136,168 0.00% -83.33% Expenditures: Tax Increment Financing — — 40,411 (40,411) 0.00% -83.33% Debt Service Principal — — 182,815 (182,815) 0.00% -83.33% Interest and Fiscal Agent Fees — — — — 0.00% -83.33% Debt Issuance Costs — — — — 0.00% -83.33% Total Expenditures — — 223,226 (223,226) 0.00% -83.33% Other Financing Uses: Issuance of Debt — — — — 0.00% -83.33% Reoffering Premium/Original Issue Discount — — — — 0.00% -83.33% Payment to Refund Loans Escrow Agent — — — — 0.00% -83.33% Transfers Out — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Financing Uses — — 223,226 (223,226) 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ — — 1,912,942 1,912,942 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, 04/30/23 2,108,923 Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Restricted - Trust Debt Service — Total Fund Balance $ 2,108,923
55
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
I-70 & Little Blue Parkway Project 3 TIF
For the Period Ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ — — 323,147 323,147 0.00% -83.33% Investment Income (Loss) — — 4,536 4,536 0.00% -83.33% Other Revenue — — — — 0.00% -83.33% Total Revenues — — 327,683 327,683 0.00% -83.33% Expenditures: Tax Increment Financing — — 7,053 (7,053) 0.00% -83.33% Debt Service Principal — — 128,877 (128,877) 0.00% -83.33% Interest and Fiscal Agent Fees — — — — 0.00% -83.33% Debt Issuance Costs — — — — 0.00% -83.33% Total Expenditures — — 135,930 (135,930) 0.00% -83.33% Other Financing Uses: Issuance of Debt — — — — 0.00% -83.33% Reoffering Premium/Original Issue Discount — — — — 0.00% -83.33% Payment to Refund Loans Escrow Agent — — — — 0.00% -83.33% Transfers Out — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Financing Uses — — 135,930 (135,930) 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ — — 191,753 191,753 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, 04/30/23 317,164 Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Restricted - Trust Debt Service — Total Fund Balance $ 317,164
56
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Marketplace Project 1 TIF
For the Period Ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ — — 101,502 101,502 0.00% -83.33% Investment Income (Loss) — — 447 447 0.00% -83.33% Other Revenue — — — — 0.00% -83.33% Total Revenues — — 101,949 101,949 0.00% -83.33% Expenditures: Tax Increment Financing — — 3,047 (3,047) 0.00% -83.33% Debt Service Principal — — 12,811 (12,811) 0.00% -83.33% Interest and Fiscal Agent Fees — — 142,789 (142,789) 0.00% -83.33% Debt Issuance Costs — — — — 0.00% -83.33% Total Expenditures — — 158,647 (158,647) 0.00% -83.33% Other Financing Uses: Issuance of Debt — — — — 0.00% -83.33% Reoffering Premium/Original Issue Discount — — — — 0.00% -83.33% Payment to Refund Loans Escrow Agent — — — — 0.00% -83.33% Transfers Out — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Financing Uses — — 158,647 (158,647) 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ — — (56,698) (56,698) 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, 04/30/23 35,424 Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Restricted - Trust Debt Service — Total Fund Balance $ 35,424
57
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
For the Period Ended April 30, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ — — 140,259 140,259 0.00% -83.33% Investment Income (Loss) — — 514 514 0.00% -83.33% Other Revenue — — — — 0.00% -83.33% Total Revenues — — 140,773 140,773 0.00% -83.33% Expenditures: Tax Increment Financing — — 3,453 (3,453) 0.00% -83.33% Debt Service Principal — — 17,480 (17,480) 0.00% -83.33% Interest and Fiscal Agent Fees — — 137,720 (137,720) 0.00% -83.33% Debt Issuance Costs — — — — 0.00% -83.33% Total Expenditures — — 158,653 (158,653) 0.00% -83.33% Other Financing Uses: Issuance of Debt — — — — 0.00% -83.33% Reoffering Premium/Original Issue Discount — — — — 0.00% -83.33% Payment to Refund Loans Escrow Agent — — — — 0.00% -83.33% Transfers Out — — — — 0.00% -83.33% Total Other Financing Uses — — — — 0.00% -83.33% Total Expenditures and Other Financing Uses — — 158,653 (158,653) 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ — — (17,880) (17,880) 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, 04/30/23 14,793 Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Restricted - Trust Debt Service — Total Fund Balance $ 14,793
Marketplace Project 2 TIF
58
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ Property tax RSO - Cargo Largo — — 3,430 3,430 0.00% -83.33% Hartman Heritage — — 76,018 76,018 0.00% -83.33% Drumm Farm — — 195,573 195,573 0.00% -83.33% Mt Washington — — 2,603 2,603 0.00% -83.33% 23rd & Noland - Project 1 — — 65,622 65,622 0.00% -83.33% Sales tax RSO - Cargo Largo — — 264,299 264,299 0.00% -83.33% Drumm Farm — — 16,116 16,116 0.00% -83.33% Eastland — — 649,448 649,448 0.00% -83.33% Mt Washington — — 567 567 0.00% -83.33% 23rd & Noland - Project 1 — — 23,748 23,748 0.00% -83.33% Investment Income (Loss) — — 20,277 20,277 0.00% -83.33% Other Revenue — — — — 0.00% -83.33% Total Revenues — — 1,317,701 1,317,701 0.00% -83.33% Expenditures: Tax Increment Financing — — 270 (270) 0.00% -83.33% Debt Service Principal — — — — 0.00% -83.33% Interest and Fiscal Agent Fees — — — — 0.00% -83.33% Debt Issuance Costs — — — — 0.00% -83.33% Total Expenditures — — 270 (270) 0.00% -83.33% Other Financing Uses: Issuance of Debt — — — — 0.00% -83.33% Reoffering Premium/Original Issue Discount — — — — 0.00% -83.33% Payment to Refund Loans Escrow Agent — — — — 0.00% -83.33% Transfers Out — — — — 0.00% -83.33% — — — — Total Other Financing Uses — — — — 0.00% -83.33% — — — — Total Expenditures and Other Financing Uses — — 270 (270) 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ — — 1,317,431 1,317,431 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, 04/30/23 1,652,067 Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Restricted - Trust Debt Service — Total Fund Balance $ 1,652,067 CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule TIF Supplemental Appropriation Fund For the Period Ended April 30, 2023 59