Monthly Financial and Operating Report March 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
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Real Estate Tax $ 5,903,000 5,903,000 5,777,578 (125,422) 97.88% 22.88% Sales Tax 20,635,000 20,635,000 15,992,571 (4,642,429) 77.50% 2.50% Use Tax 535,000 535,000 230,978 (304,022) 43.17% -31.83% Cigarette Tax 380,000 380,000 219,539 (160,461) 57.77% -17.23% Franchise Tax 8,344,000 8,344,000 6,045,548 (2,298,452) 72.45% -2.55% Licenses and Permits 4,410,950 4,410,950 3,225,032 (1,185,918) 73.11% -1.89% Intergovernmental 5,810,000 5,810,000 5,076,343 (733,657) 87.37% 12.37% Charges for Current Services 1,955,400 2,017,832 1,632,621 (385,211) 80.91% 5.91% Interfund Charges for Support Services 2,354,600 2,354,600 1,765,950 (588,650) 75.00% 0.00% Fines and Forfeitures 2,156,000 2,156,000 1,481,774 (674,226) 68.73% -6.27% Investment Income (Loss) 220,000 220,000 143,929 (76,071) 65.42% -9.58% Other Revenue 750,400 750,400 155,892 (594,508) 20.77% -54.23% Total Revenues 53,454,350 53,516,782 41,747,755 (11,769,027) 78.01% 3.01% Other Financing Sources: Payments In Lieu of Taxes 20,848,787 20,848,787 16,729,764 (4,119,023) 80.24% 5.24% Transfers In 0.00% -75.00% Operating Transfers In - American Rescue Plan 0.00% -75.00% Total Other Financing Sources 20,848,787 20,848,787 16,729,764 (4,119,023) 80.24% 5.24% Total Revenues and Other Financing Sources 74,303,137 74,365,569 58,477,519 (15,888,050) 78.64% 3.64% Expenditures: City Council 686,729 790,619 557,981 232,638 70.58% -4.42% City Clerk 266,577 332,702 411,974 (79,272) 123.83% 48.83% City Manager 1,101,987 1,184,002 829,380 354,622 70.05% -4.95% Municipal Court 1,687,121 1,687,121 1,158,516 528,605 68.67% -6.33% Law 182,663 182,663 130,279 52,384 71.32% -3.68% Finance 626,644 627,644 561,270 66,374 89.42% 14.42% Community Development 5,387,456 5,387,456 3,751,169 1,636,287 69.63% -5.37% Police 34,273,528 34,334,960 25,380,814 8,954,146 73.92% -1.08% Fire 23,811,497 23,625,592 19,195,518 4,430,074 81.25% 6.25% Municipal Services (Public Works) 5,972,696 5,972,696 3,985,439 1,987,257 66.73% -8.27% Parks and Recreation 296,239 296,239 154,330 141,909 52.10% -22.90% Contingencies 0.00% -75.00% Debt service 0.00% -75.00% Total Expenditures 74,293,137 74,421,694 56,116,670 18,305,024 75.40% 0.40% Other Financing Uses: Transfers Out 10,000 10,000 161,638 (151,638) 1616.38% 1541.38% Total Expenditures and Other Financing Uses 74,303,137 74,431,694 56,278,308 18,153,386 75.61% 0.61% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (66,125) 2,199,211 2,265,336 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 (215,240) Year-end investment market value adjustment Ending Unassigned Fund Balance, 03/31/23 8,311,928 Restricted 369,364 Committed 3,000 Assigned 1,051,438 Total Fund Balance $ 9,735,730
the period ended March 31, 2023 1
For
CITY
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Sales Taxes $ 9,715,000 9,715,000 7,442,920 (2,272,080) 76.61% 1.61% Use Tax 268,000 268,000 115,489 (152,511) 43.09% -31.91% Charges for Services 0.00% -75.00% Intergovernmental Revenue 603,560 603,560 0.00% -75.00% Investment Income (Loss) 77,000 77,000 421,254 344,254 547.08% 472.08% Other Revenue 0.00% -75.00% Total Revenues 10,060,000 10,060,000 8,583,223 (1,476,777) 85.32% 10.32% Other Financing Sources: Transfers in 0.00% -75.00% Total other financing sources 0.00% -75.00% Total revenues and other financing sources 10,060,000 10,060,000 8,583,223 (1,476,777) 85.32% 10.32% Expenditures: General Government 0.00% -75.00% Street Maintenance 1,265,081 1,265,081 716,751 548,330 56.66% -18.34% Capital Outlay 6,556,836 15,996,210 3,369,917 12,626,293 21.07% -53.93% Debt Service 1,744,200 1,744,200 1,744,148 52 100.00% 25.00% Total Expenditures 9,566,117 19,005,491 5,830,816 13,174,675 30.68% -44.32% Other Financing Uses: Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 9,566,117 19,005,491 5,830,816 13,174,675 30.68% -44.32% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 493,883 (8,945,491) 2,752,407 11,697,898 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 47,798 Year-end investment market value adjustment Ending Unassigned Fund Balance, 03/31/23 2,731,518 Fund Balance Components: Restricted - Current Year Encumbrances 1,354,793 Restricted - Prior Year Encumbrances 6,029,614 Restricted - Debt Reserve Project Accounts - Capital Projects 11,372,521 Total Fund Balance $ 21,488,446
Improvements Sales Tax Fund
the period ended March 31, 2023 2
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Street
For
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Park Improvements Sales Tax Fund For
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Sales Taxes $ 4,858,000 4,858,000 3,721,720 (1,136,280) 76.61% 1.61% Use Tax 134,000 134,000 57,745 (76,255) 43.09% -31.91% Charges for services 474,540 474,540 407,730 (66,810) 85.92% 10.92% Intergovernmental 88,500 88,500 40,342 (48,158) 45.58% -29.42% Investment Income (Loss) 59,180 59,180 52,761 (6,419) 89.15% 14.15% Other Revenue 7,500 7,500 26,713 19,213 356.17% 281.17% Total Revenues 5,621,720 5,621,720 4,307,011 (1,314,709) 76.61% 1.61% Other Financing Sources: Transfers In 0.00% -75.00% Transfers In - American Rescue Plan 0.00% -75.00% Proceeds from Bond Issuance/Capital Lease 0.00% -75.00% Total Other Financing Sources 0.00% -75.00% Total Revenues and Other Financing Sources 5,621,720 5,621,720 4,307,011 (1,314,709) 76.61% 1.61% Expenditures: Culture and Recreation 5,103,261 5,103,261 3,799,266 1,303,995 74.45% -0.55% Capital Outlay 993,000 1,875,283 524,613 1,350,670 27.98% -47.02% Debt Service 0.00% -75.00% Total Expenditures 6,096,261 6,978,544 4,323,879 2,654,665 61.96% -13.04% Other Financing Uses: Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 6,096,261 6,978,544 4,323,879 2,654,665 61.96% -13.04% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (474,541) (1,356,824) (16,868) 1,339,956 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, 03/31/23 3,073,886 Other Fund Balance Components: Restricted - Current Year Encumbrances 650,231 Restricted - Prior Year Encumbrances 44,822 Total Fund Balance $ 3,768,939
the period
3
ended March 31, 2023
CITY OF INDEPENDENCE, MISSOURI Budgetary
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Sales Taxes $ 4,858,000 4,858,000 3,721,720 (1,136,280) 76.61% 1.61% Use Tax 134,000 134,000 57,745 (76,255) 43.09% -31.91% Intergovernmental 0.00% -75.00% Investment Income (loss) 164,000 164,000 209,754 45,754 127.90% 52.90% Other Revenue 7,900 16,685 16,472 (213) 98.72% 23.72% Total revenues 5,163,900 5,172,685 4,005,691 (1,166,994) 77.44% 2.44% Expenditures: Storm water Administration 233,009 233,009 183,234 49,775 78.64% 3.64% Maintenance 2,684,530 2,693,315 1,621,558 1,071,757 60.21% -14.79% Permit completion 318,000 318,000 305,200 12,800 95.97% 20.97% Capital outlay 1,500,000 4,590,291 968,111 3,622,180 21.09% -53.91% Total Expenditures 4,735,539 7,834,615 3,078,103 4,756,512 39.29% -35.71% Other financing uses: Transfers out 1,000 (1,000) 0.00% -75.00% Total other financing uses 1,000 (1,000) 0.00% -75.00% Total Ependitures and Other Financing Uses 4,735,539 7,834,615 3,079,103 4,755,512 39.30% -35.70% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 428,361 (2,661,930) 926,588 3,588,518 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, 03/31/23 10,189,284 Other Fund Balance Components: Restricted - Current Year Encumbrances 893,701 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 $ 11,973,819
Schedule
Water Sales Tax Fund
the period ended March 31, 2023 4
Comparison
Storm
For
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Police Public Safety Sales Tax Fund
For the period ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Sales Taxes $ 2,580,000 2,580,000 2,018,347 (561,653) 78.23% 3.23% Use Tax 67,000 67,000 28,872 (38,128) 43.09% -31.91% Investment Income (Loss) 35,000 35,000 43,756 8,756 125.02% 50.02% Other Revenue 7,600 7,600 98,804 91,204 1300.05% 1225.05% Total Revenues 2,689,600 2,689,600 2,189,779 (499,821) 81.42% 6.42% Expenditures: Public Safety Communications 522,200 522,200 454,552 67,648 87.05% 12.05% Facilities 105,200 105,200 85,570 19,630 81.34% 6.34% Equipment 1,743,700 1,743,700 1,556,768 186,932 89.28% 14.28% Debt Service 675 (675) 0.00% -75.00% Total Expenditures 2,371,100 2,371,100 2,097,565 273,535 88.46% 13.46% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 2,371,100 2,371,100 2,097,565 273,535 88.46% 13.46% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 318,500 318,500 92,214 (226,286) 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, 03/31/23 2,539,644 Other Fund Balance Components: Restricted - Current Year Encumbrances 349,820 Restricted - Prior Year Encumbrances 36,133 Total Fund Balance $ 2,925,597
5
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Sales Taxes $ 8,770,000 8,770,000 8,064,878 (705,122) 91.96% 16.96% Use Tax 268,000 268,000 115,489 (152,511) 43.09% -31.91% Investment Income (Loss) 29,000 29,000 80,325 51,325 276.98% 201.98% Other Revenue 6,000 6,000 3,223 (2,777) 53.72% -21.28% Total Revenues 9,073,000 9,073,000 8,263,915 (809,085) 91.08% 16.08% Expenditures: Public Safety 6,821,786 7,812,662 4,035,076 3,777,586 51.65% -23.35% Debt Service 73,300 73,300 73,235 65 99.91% 24.91% Total Expenditures 6,895,086 7,885,962 4,108,311 3,777,651 52.10% -22.90% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 6,895,086 7,885,962 4,108,311 3,777,651 52.10% -22.90% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 2,177,914 1,187,038 4,155,604 2,968,566 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, 03/31/23 6,010,576 Other Fund Balance Components: Restricted - Current Year Encumbrances 1,141,573 Restricted - Prior Year Encumbrances 131,446 Total Fund Balance $ 7,283,595
Protection Sales Tax Fund
the period ended March 31, 2023 6
Schedule Fire
For
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Use Tax $ 782,000 782,000 782,000 100.00% 25.00% Intergovernmental Revenue 0.00% -75.00% Investment Income (Loss) 3,000 3,000 11,399 8,399 379.97% 304.97% Other Revenue 0.00% -75.00% Total Revenues 785,000 785,000 793,399 8,399 101.07% 26.07% Expenditures: General Government 0.00% -75.00% Animal Services 769,213 769,213 509,436 259,777 66.23% -8.77% Capital Outlay 0.00% -75.00% Debt Service 0.00% -75.00% Total Expenditures 769,213 769,213 509,436 259,777 66.23% -8.77% Other Financing Uses: Transfers In 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 769,213 769,213 509,436 259,777 66.23% -8.77% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 15,787 15,787 283,963 268,176 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, 03/31/23 491,666 Fund Balance Components: Restricted - Current Year Encumbrances 960 Restricted - Prior Year Encumbrances Total Fund Balance $ 492,626
Animal Shelter Use Tax For the period ended March 31, 2023 7
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Police Use Tax For the period ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Use Tax $ 4,100,000 4,100,000 4,100,000 100.00% 25.00% Investment Income (Loss) 59,000 59,000 104,764 45,764 177.57% 102.57% Other Revenue 0.00% -75.00% Total Revenues 4,159,000 4,159,000 4,204,764 45,764 101.10% 26.10% Expenditures: Public Safety 4,029,166 4,175,616 3,069,628 1,105,988 73.51% -1.49% Debt Service 0.00% -75.00% Total Expenditures 4,029,166 4,175,616 3,069,628 1,105,988 73.51% -1.49% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 4,029,166 4,175,616 3,069,628 1,105,988 73.51% -1.49% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 129,834 (16,616) 1,135,136 1,151,752 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, 03/31/23 5,828,834 Other Fund Balance Components: Restricted - Current Year Encumbrances 348,840 Restricted - Prior Year Encumbrances Total Fund Balance $ 6,177,674
8
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule Health Property Tax Levy For the period ended March 31, 2023 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 881,500 881,500 861,110 (20,390) 97.69% 22.69% Charges for Services 154,500 154,500 124,231 (30,269) 80.41% 5.41% Licenses & Permits 392,238 392,238 393,388 1,150 100.29% 25.29% Investment Income (Loss) 3,731 3,731 13,377 9,646 358.54% 283.54% Other Revenue 14,000 14,000 9,010 (4,990) 64.36% -10.64% Total Revenues 1,445,969 1,445,969 1,401,116 (44,853) 96.90% 21.90% Other Financing Sources: Transfers In 0.00% -75.00% Transfers In - American Rescue Plan 300,000 300,000 300,000 100.00% 25.00% Total Other Financing Uses 300,000 300,000 300,000 100.00% 25.00% Total Revenues and Other Sources 1,745,969 1,745,969 1,701,116 (44,853) 97.43% 22.43% Expenditures: Animal Services 1,045,512 1,045,512 726,656 318,856 69.50% -5.50% Health Services 733,636 733,636 483,988 249,648 65.97% -9.03% Total Expenditures 1,779,148 1,779,148 1,210,644 568,504 68.05% -6.95% Other Financing Uses: Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Uses 1,779,148 1,779,148 1,210,644 568,504 68.05% -6.95% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (333,179) (333,179) 490,472 823,651 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, 03/31/23 656,194 Other Fund Balance Components: Restricted - Current Year Encumbrances 39,761 Restricted - Prior Year Encumbrances Total Fund Balance $ 695,955
9
CITY OF INDEPENDENCE, MISSOURI
Comparison Schedule Parks and Recreation Property Tax Levy For the period ended March 31, 2023 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 1,876,775 1,876,775 1,829,858 (46,917) 97.50% 22.50% Intergovernmental 0.00% -75.00% Charges for Services 120,650 120,650 81,513 (39,137) 67.56% -7.44% Investment Income (Loss) 19,165 19,165 18,811 (354) 98.15% 23.15% Other Revenue 6,330 6,330 0.00% -75.00% Total Revenues 2,016,590 2,016,590 1,936,512 (80,078) 96.03% 21.03% Expenditures: Parks and Recreation 2,554,180 2,554,180 1,926,883 627,297 75.44% 0.44% Total Expenditures 2,554,180 2,554,180 1,926,883 627,297 75.44% 0.44% Other Financing Uses – Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Uses 2,554,180 2,554,180 1,926,883 627,297 75.44% 0.44% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (537,590) (537,590) 9,629 547,219 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, 03/31/23 591,405 Other Fund Balance Components: Restricted - Current Year Encumbrances 83,723 Restricted - Prior Year Encumbrances Total Fund Balance $ 675,128 10
Budgetary
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule Tourism Fund For the period ended March 31, 2023 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Transient Guest Taxes $ 1,975,000 1,975,000 1,683,685 (291,315) 85.25% 10.25% Charges for Services 32,000 32,000 21,051 (10,949) 65.78% -9.22% Investment Income (Loss) 25,050 25,050 37,891 12,841 151.26% 76.26% Other Revenue 12,050 12,050 11,838 (212) 98.24% 23.24% Total Revenues 2,044,100 2,044,100 1,754,465 (289,635) 85.83% 10.83% Other Financing Sources: Transfers In - American Resuce Plan 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Revenues and Other Sources 2,044,100 2,044,100 1,754,465 (289,635) 85.83% 10.83% Expenditures: Tourism 2,709,247 3,339,449 1,370,555 1,968,894 41.04% -33.96% Total Expenditures 2,709,247 3,339,449 1,370,555 1,968,894 41.04% -33.96% Other Financing Uses – Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Uses 2,709,247 3,339,449 1,370,555 1,968,894 41.04% -33.96% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (665,147) (1,295,349) 383,910 1,679,259 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, 03/31/23 1,562,622 Other Fund Balance Components: Restricted - Current Year Encumbrances 237,211 Restricted - Prior Year Encumbrances 60,103 Restricted - Operating Reserve 376,368 Total Fund Balance $ 2,236,304
11
Independence Square Benefit District For the period ended March 31, 2023 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 26,384 26,384 0.00% -75.00% Investment Income (Loss) 1,403 1,403 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 27,787 27,787 0.00% -75.00% Expenditures: Capital Outlay 425 (425) 0.00% -75.00% Total Expenditures 425 (425) 0.00% -75.00% Other Financing Uses – Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Uses 425 (425) 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 27,362 27,362 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, 03/31/23 35,727 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 35,727 12
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Federal Grant - CDBG $ 800,000 800,000 571,068 (228,932) 71.38% -3.62% Other Revenue -75.00% Total Revenues 800,000 800,000 571,068 (228,932) 71.38% -3.62% Expenditures: CDBG Administration 160,000 160,000 127,260 32,740 79.54% 4.54% CDBG Expenditures 640,000 640,000 305,696 334,304 47.77% -27.24% Total Expenditures 800,000 800,000 432,956 367,044 54.12% -20.88% Other Financing Uses: Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Uses 800,000 800,000 432,956 367,044 54.12% -20.88% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 138,112 138,112 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, 03/31/23 (229,103) Other Fund Balance Components: Restricted - Current Year Encumbrances 66,386 Restricted - Prior Year Encumbrances 161,979 Total Fund Balance $ (738)
Community Development Block Grant Fund For the period ended March 31, 2023 13
Schedule
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Rental Rehabilitation For the period ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: HOME Program Grant $ 465,330 499,770 284,690 (215,080) 56.96% -18.04% Total Revenues 465,330 499,770 284,690 (215,080) 56.96% -18.04% Expenditures: HOME Administration 46,533 80,973 68,368 12,605 84.43% 9.43% Multi Family Housing 325,730 325,730 325,730 0.00% -75.00% Community Housing Development 93,067 93,067 93,067 0.00% -75.00% Total Expenditures 465,330 499,770 68,368 431,402 13.68% -61.32% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 216,322 216,322 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, 03/31/23 (53,813) Other Fund Balance Components: Restricted - Current Year Encumbrances 790 Restricted - Prior Year Encumbrances 53,030 Total Fund Balance $ 7
14
CITY OF INDEPENDENCE, MISSOURI
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Licenses and Permits $ 12,672 12,672 0.00% -75.00% Investment Income (Loss) 21,000 21,000 21,857 857 104.08% 29.08% Other Revenue 0.00% -75.00% Total Revenues 21,000 21,000 34,529 13,529 164.42% 89.42% Expenditures: General Government 339 (339) 0.00% -75.00% Total expenditures 339 (339) 0.00% -75.00% Other Financing Uses: Transfers Out/Capital Outlay 115 (115) 0.00% -75.00% Total Other Financing Uses 115 (115) 0.00% -75.00% Total Expenditures and Other Financing Uses 454 (454) 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 21,000 21,000 34,075 13,075 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, 03/31/23 1,204,222 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 1,204,222
Comparison Schedule License Surcharge For the period ended March 31, 2023 15
Budgetary
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Grants For the period ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Intergovernmental $ 2,311,280 7,429,054 2,202,724 (5,226,330) 29.65% -45.35% Charges for Services 109,023 109,023 159,422 50,399 146.23% 71.23% Other Revenue 290,361 285 (290,076) 0.10% -74.90% Total Revenues 2,420,303 7,828,438 2,362,431 (5,466,007) 30.18% -44.82% Other financing sources: Transfers In 0.00% -75.00% Total other financing sources 0.00% -75.00% Total revenues and other financing sources 2,420,303 7,828,438 2,362,431 (5,466,007) 30.18% -44.82% Expenditures: Public Safety 640,270 2,852,700 1,364,965 1,487,735 47.85% -27.15% General Government 27,892 108,713 21,300 87,413 19.59% -55.41% Culture and Recreation 83,434 32,266 51,168 38.67% -36.33% Community Development 940,000 1,995,670 1,232,107 763,563 61.74% -13.26% Animal Services 16,269 3,512 12,757 21.59% -53.41% Health Services 465,497 2,148,255 399,058 1,749,197 18.58% -56.42% Total Expenditures 2,073,659 7,205,041 3,053,208 4,151,833 42.38% -32.62% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 2,073,659 7,205,041 3,053,208 4,151,833 42.38% -32.62% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 346,644 623,397 (690,777) (1,314,174) 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, 03/31/23 (919,336) Other Fund Balance Components: Restricted - Current Year Encumbrances 545,522 Restricted - Prior Year Encumbrances 141,894 Total Fund Balance $ (231,920)
16
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule American Rescue Plan (ARP) For the period ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Intergovernmental $ 9,557,038 9,557,038 5,070,725 (4,486,313) 53.06% -21.94% Charges for Services 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 9,557,038 9,557,038 5,070,725 (4,486,313) 53.06% -21.94% Other financing sources: Transfers in 0.00% -75.00% Total other financing sources 0.00% -75.00% Total revenues and other financing sources 9,557,038 9,557,038 5,070,725 (4,486,313) 53.06% -21.94% Expenditures: Personnel Services 110,000 110,000 86,502 23,498 78.64% 3.64% Other Services 1,112,038 1,112,038 428,480 683,558 38.53% -36.47% Supplies 0.00% -75.00% Capital Outlay 4,135,000 4,135,000 417,368 3,717,632 10.09% -64.91% Total Expenditures 5,357,038 5,357,038 932,350 4,424,688 17.40% -57.60% Other Financing Uses: Transfers Out - American Rescue Plan 4,200,000 4,200,000 4,200,000 100.00% 25.00% Total Other Financing Uses 4,200,000 4,200,000 4,200,000 100.00% 25.00% Total Expenditures and Other Financing Uses 9,557,038 9,557,038 5,132,350 4,424,688 53.70% -21.30% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (61,625) (61,625) 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, 03/31/23 (272,138) Other Fund Balance Components: Restricted - Current Year Encumbrances 172,335 Restricted - Prior Year Encumbrances 99,803 Total Fund Balance $
17
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Power and Light For the period ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Operating Revenues: Charges for Services $ 131,606,000 131,606,000 109,927,561 (21,678,439) 83.53% 8.53% Penalties 1,000,000 1,000,000 1,165,731 165,731 116.57% 41.57% Connection Charges 33,000 33,000 5,023 (27,977) 15.22% -59.78% Miscellaneous 43,979 43,979 0.00% -75.00% Temporary Service 1,000 1,000 800 (200) 80.00% 5.00% Rental Income 276,000 276,000 292,358 16,358 105.93% 30.93% Transmission Wheeling 7,000,000 7,000,000 4,383,236 (2,616,764) 62.62% -12.38% Total Operating Revenues 139,916,000 139,916,000 115,818,688 (24,097,312) 82.78% 7.78% Operating Expenses: Personnel Services 28,729,037 28,729,037 20,489,829 8,239,208 71.32% -3.68% Retiree Benefits 1,460,000 1,460,000 1,054,016 405,984 72.19% -2.81% Other Services 26,956,585 26,911,285 25,855,139 1,056,146 96.08% 21.08% Supplies 55,603,355 55,603,905 48,417,937 7,185,968 87.08% 12.08% Capital Projects 5,305,000 14,289,794 5,032,998 9,256,796 35.22% -39.78% Capital Operating 1,400,225 1,444,975 538,520 906,455 37.27% -37.73% Debt Service 7,896,466 7,896,466 2,842,339 5,054,127 36.00% -39.00% Other Expenses 100,000 100,000 100,000 0.00% -75.00% Total Operating Expenses 127,450,668 136,435,462 104,230,778 32,204,684 76.40% 1.40% Nonoperating Revenues (Expenses): Investment Income 118,000 118,000 1,124,164 1,006,164 952.68% 877.68% Interfund Charges for Support Services 2,011,000 2,011,000 1,540,879 (470,121) 76.62% 1.62% Miscellaneous Revenue (Expense) 15,700 15,700 490,697 474,997 3125.46% 3050.46% Total Nonoperating Revenue (Expenses) 2,144,700 2,144,700 3,155,740 1,011,040 147.14% 72.14% 14,610,032 5,625,238 14,743,650 9,118,412 262.10% 187.10% Capital Contributions 0.00% -75.00% Transfers Out – Utility Payments In Lieu of Taxes (13,000,000) (13,000,000) (11,509,182) (1,490,818) 88.53% 13.53% Transfers In 0.00% -75.00% Transfers Out 0.00% -75.00% Total Transfers (13,000,000) (13,000,000) (11,509,182) (1,490,818) 88.53% 13.53% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 1,610,032 (7,374,762) 3,234,468 10,609,230 Beginning Available Resources 49,405,589 Prior Period Adjustment Year-End Investment Market Value Adjustment Ending Available Resources 52,640,057 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 $ 140,057 Income (Loss) Before Transfers
18
Power and Light - Open Capital Projects As of March 31, 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 530,802.36 63,315.00 239,822.12 200824 Prod Plt MISC PROJECTS - 68,257.76 68,257.76 - - 68,257.76 200828 FIBER OPTIC PROGRAM - 198,999.72 198,999.72 44,546.73 104,510.76 49,942.23 201106 69 KV SUBSTATION FACILITIES - 321,078.50 321,078.50 26,893.81 56,592.75 237,591.94 201405 SUBSTATION SECURITY PROJECT - 235,149.64 235,149.64 30,534.00 - 204,615.64 201509 NEW BILLING Sys - 22,047.36 22,047.36 - - 22,047.36 201510 Sys OpS / DISPATCH - 44,634.77 44,634.77 33,430.50 1,600.00 9,604.27 201603 69 KV Trans LINE REBUIL - 1,356,365.47 1,356,365.47 522,951.24 147,914.19 685,500.04 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 132,176.00 171,416.00 171,885.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,982,829.40 1,201,295.39 1,975,074.12 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 99,297.97 267,227.81 154,200.79 202111 Transmission Pole Replacement Prog - 888,487.14 888,487.14 63,908.62 321,858.64 502,719.88 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 7,174.50 - 512,909.67 $ 1,925,000.00 19,418,027.06 21,343,027.06 6,863,864.89 4,909,124.52 9,570,037.65 Current Year Prior Year Budget Budget (Enc Roll) Total Budget 14,289,793.73 $ 7,053,233.33 21,343,027.06 Less Expenditures 999,123.71 3,910,000.81 4,909,124.52 Less Encumbrances 4,033,873.62 2,829,991.27 6,863,864.89 Total Available 9,256,796.40 $ 313,241.25 9,570,037.65
19
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Water
For the period ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Operating Revenues: Charges for Services $ 32,165,000 32,165,000 25,507,966 (6,657,034) 79.30% 4.30% Penalties 100,000 100,000 343,298 243,298 343.30% 268.30% Connection/Disconnection Charges 12,000 12,000 15,999 3,999 133.33% 58.33% Miscellaneous 10,000 10,000 16,061 6,061 160.61% 85.61% Returned Check Charges 23,000 23,000 22,500 (500) 97.83% 22.83% Rental Income 85,000 85,000 105,636 20,636 124.28% 49.28% Meter Repairs 0.00% -75.00% Merchandising Jobbing 6,582 6,582 0.00% -75.00% Total Operating Revenues 32,395,000 32,395,000 26,018,042 (6,376,958) 80.31% 5.31% Operating expenses: Personnel Services 9,646,673 9,646,673 6,302,831 3,343,842 65.34% -9.66% Retiree Benefits 364,000 364,000 249,891 114,109 68.65% -6.35% Other Services 13,703,182 13,703,182 7,913,492 5,789,690 57.75% -17.25% Supplies 2,840,700 2,840,700 2,936,011 (95,311) 103.36% 28.36% Capital Projects 7,800,000 22,584,919 7,136,945 15,447,974 31.60% -43.40% Capital Operating 1,134,500 1,134,500 498,713 635,787 43.96% -31.04% Debt Service 2,526,400 2,526,400 2,240,826 285,574 88.70% 13.70% Other Expenses 50,000 50,000 50,000 0.00% -75.00% Total Operating Expenses 38,065,455 52,850,374 27,278,709 25,571,665 51.61% -23.39% Nonoperating Revenues (Expenses): Investment Income 657,138 657,138 998,026 340,888 151.87% 76.87% Interfund Charges for Support Services 3,300,500 3,300,500 2,519,414 (781,086) 76.33% 1.33% Miscellaneous Revenue (Expense) 16,700 16,700 33,373 16,673 199.84% 124.84% Total Nonoperating Revenue (Expenses) 3,974,338 3,974,338 3,550,813 (423,525) 89.34% 14.34% (1,696,117) (16,481,036) 2,290,146 18,771,182 -13.90% -88.90% Transfers Out – Utility Payments In Lieu of Taxes (2,941,000) (2,941,000) (2,517,180) (423,820) 85.59% 10.59% Transfers In 0.00% -75.00% Transfers Out 0.00% -75.00% Total Transfers (2,941,000) (2,941,000) (2,517,180) (423,820) 85.59% 10.59% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (4,637,117) (19,422,036) (227,034) 19,195,002 Beginning Available Resources 48,655,139 Year-End Investment Market Value Adjustment Ending Available Resources 48,428,105 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,028,105 Income (Loss) Before Transfers
20
Water - Open Capital Projects
As of March 31, 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 - 270.00 1,462,326.00 401301 23RD ST MAIN REPLACEMENT - 311,672.57 311,672.57 2,811.00 - 308,861.57 401402 LAGOON CLEANOUT - 24,559.00 24,559.00 15,000.00 34,059.00 (24,500.00) 401505 Dist Sys IMPROVE - 244,781.00 244,781.00 - - 244,781.00 401506 TRUMAN ROAD BOOSTER STATION - 106,569.52 106,569.52 - - 106,569.52 401601 FILTER BACKWASH OUTFALL - 190,325.00 190,325.00 - - 190,325.00 401602 Plt DISCHARGE OUTFALL - 459,824.48 459,824.48 - - 459,824.48 401605 COURTNEY BEND BASIN CATWALK - 10,020.00 10,020.00 - - 10,020.00 401608 LIME SILO - 4,249,256.24 4,249,256.24 3,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 1,523,732.30 669,534.90 (23,054.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 216,825.00 833,175.00 129,100.00 402012 College Avenue Improvements - 250,000.00 250,000.00 - - 250,000.00 402101 Main Replacement Ralston 31st/29th - 364,255.00 364,255.00 329,948.30 2,398.20 31,908.50 402102 Main Replacement 3rd St & Jennings - 440,798.00 440,798.00 1,196.25 3,588.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 88,725.00 11,275.00 1,650,000.00 402108 Basin Drive Improvements - 340,523.00 340,523.00 - - 340,523.00 402201 Roof Improvements - 250,000.00 250,000.00 - 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,132,412.20 275,128.20 2,386,613.27 9952 SECURITY UPGRADES - 517,590.82 517,590.82 6,202.03 45,084.43 466,304.36 $ 2,800,000.00 23,980,362.62 26,780,362.62 7,753,791.42 3,578,597.45 15,447,973.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 472,868.08 3,105,729.37 3,578,597.45 Less Encumbrances 6,664,077.02 1,089,714.40 7,753,791.42 Total Available 15,447,973.75 $ - 15,447,973.75
21
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Sanitary Sewer For the period ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Operating revenues: Charges for Services $ 35,821,585 35,821,585 26,743,759 (9,077,826) 74.66% -0.34% Penalties 200,000 200,000 133,172 (66,828) 66.59% -8.41% Total operating revenues 36,021,585 36,021,585 26,876,931 (9,144,654) 74.61% -0.39% Operating expenses: Personnel Services 6,796,986 6,796,986 4,276,197 2,520,789 62.91% -12.09% Retiree Benefits 348,000 348,000 252,781 95,219 72.64% -2.36% Other Services 15,594,591 15,594,591 10,767,521 4,827,070 69.05% -5.95% Supplies 1,285,100 1,279,600 720,269 559,331 56.29% -18.71% Capital Projects 1,750,000 14,137,113 745,517 13,391,596 5.27% -69.73% Capital Operating 593,000 598,500 489,755 108,745 81.83% 6.83% Debt Service 6,239,100 6,239,100 5,128,432 1,110,668 82.20% 7.20% Other Expenses 0.00% -75.00% Total Operating Expenses 32,606,777 44,993,890 22,380,472 22,613,418 49.74% -25.26% Nonoperating Revenues (Expenses): Investment Income 326,000 326,000 634,899 308,899 194.75% 119.75% Miscellaneous Revenue (Expense) 7,900 7,900 114,132 106,232 1444.71% 1369.71% Total Nonoperating Revenue (Expenses) 333,900 333,900 749,031 415,131 224.33% 149.33% 3,748,708 (8,638,405) 5,245,490 13,883,895 -60.72% -135.72% Transfers Out – Utility Payments In Lieu of Taxes (3,596,612) (3,596,612) (2,703,402) (893,210) 75.17% 0.17% Transfers In 10,000 10,000 10,000 100.00% 25.00% Transfers Out (1,000) 1,000 0.00% -75.00% Total Transfers (3,586,612) (3,586,612) (2,694,402) (892,210) 75.12% 0.12% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 162,096 (12,225,017) 2,551,088 14,776,105 Beginning Available Resources 31,326,433 Year-End Investment Market Value Adjustment Ending Available Resources 33,877,521 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 $ 21,177,521 Income (Loss) Before Transfers
22
Sanitary Sewer - Open Capital Projects
As of March 31, 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 301703 ARROWHEAD CENTER - - - - -301705 16TH/SCOTT - 357,362.29 357,362.29 - - 357,362.29 301706 TREATMENT FACILITY IMPROVEMENT - 369,539.84 369,539.84 4,682.20 60,171.64 304,686.00 301804 ROCK CREEK EFFLUENT STRUCTURE - 332,776.94 332,776.94 2,447.87 8,734.73 321,594.34 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 57,828.98 1,338,884.24 1,000,820.59 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 101,922.00 - 42,028.24 302009 Truman & Harris - 50,000.00 50,000.00 - - 50,000.00 302101 Sanitation Sewer Evaluation Survey - 106,982.83 106,982.83 21,301.63 - 85,681.20 302102 Raymond Harkless Mills San Imp - 200,000.00 200,000.00 - - 200,000.00 302103 Pump Station Imp & Maintenance - 568,240.98 568,240.98 - - 568,240.98 302104 Polymer System Relocation - 100,000.00 100,000.00 - - 100,000.00 302105 Piping Rehabilitation - 585,933.69 585,933.69 14,332.50 - 571,601.19 302201 Upper Adair Interceptor - 800,000.00 800,000.00 - - 800,000.00 302202 Crackerneck Creek Slope Rehab - 1,877,276.90 1,877,276.90 63,108.07 14,837.59 1,799,331.24 302203 Sanitary Sewer Main Reloc from Stre - 400,000.00 400,000.00 - - 400,000.00 302204 RCTP - Septic Pumper - 300,000.00 300,000.00 - - 300,000.00 302205 Clarifier Rehabilitation - 1,405,823.97 1,405,823.97 62,087.99 172,680.78 1,171,055.20 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 226,058.47 349,278.56 520,068.37 $ 500,000.00 16,256,832.04 16,756,832.04 865,718.01 2,345,213.96 13,545,900.07 Current Year Prior Year Budget Budget (Enc Roll) Total Budget 14,137,112.86 $ 2,619,719.18 16,756,832.04 Less Expenditures 170,624.89 2,174,589.07 2,345,213.96 Less Encumbrances 574,892.14 290,825.87 865,718.01 Total Available 13,391,595.83 $ 154,304.24 13,545,900.07
23
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Events Center Debt Service
For the period ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Operating revenues: Charges for Services $ 0.00% -75.00% Miscellaneous 0.00% -75.00% Total operating revenues 0.00% -75.00% Operating Expenses: Personnel Services 0.00% -75.00% Other Services 73,108 (73,108) 0.00% -75.00% Supplies 0.00% -75.00% Capital Outlay 2,309,104 2,652,853 6,105,443 (3,452,590) 230.15% 155.15% Debt Service 5,648,400 5,648,400 5,085,463 562,937 90.03% 15.03% Other Expenses 0.00% -75.00% Total Operating Expenses 7,957,504 8,301,253 11,264,014 (2,962,761) 135.69% 60.69% Nonoperating Revenues (Expenses): Investment Income 6,200 6,200 177,917 171,717 2869.63% 2794.63% Miscellaneous Revenue (Expense) 13 13 0.00% -75.00% Sales Tax 2,400,000 2,400,000 5,032,333 2,632,333 209.68% 134.68% Total Nonoperating Revenue (Expenses) 2,406,200 2,406,200 5,210,263 2,804,063 216.53% 141.53% (5,551,304) (5,895,053) (6,053,751) (158,698) 102.69% 27.69% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -75.00% Transfers In 2,226,583 (2,226,583) 0.00% -75.00% Transfers Out 0.00% -75.00% Total Transfers 2,226,583 (2,226,583) 0.00% -75.00% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (5,551 304) (5,895 053) (3,827 168) 2,067 885 Beginning Available Resources (1,228,630) Less Prior Year Expenses Year-End Investment Market Value Adjustment Ending Available Resources $ (5,055,798) Income (Loss) Before Transfers
24
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Central Garage
For the period ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Operating revenues: Charges for Services $ 2,693,100 2,693,100 2,263,764 (429,336) 84.06% 9.06% Miscellaneous 10,419 10,419 0.00% -75.00% Total Operating Revenues 2,693,100 2,693,100 2,274,183 (418,917) 84.44% 9.44% Operating Expenses: Personnel Services 853,367 853,367 533,945 319,422 62.57% -12.43% Retiree Benefits 52,000 52,000 31,077 20,923 59.76% -15.24% Other Services 996,700 996,700 1,022,929 (26,229) 102.63% 27.63% Supplies 998,500 998,500 1,034,274 (35,774) 103.58% 28.58% Capital Outlay 8,000 8,000 5,619 2,381 70.24% -4.76% Other Expenses 0.00% -75.00% Total Operating Expenses 2,908,567 2,908,567 2,627,844 280,723 90.35% 15.35% Nonoperating Revenues (Expenses): Investment Income 6,500 6,500 8,231 1,731 126.63% 51.63% Miscellaneous Revenue (Expense) 281,000 281,000 1,251 (279,749) 0.45% -74.55% Total Nonoperating Revenue (Expenses) 287,500 287,500 9,482 (278,018) 3.30% -71.70% 72,033 72,033 (344,179) (416,212) -477.81% -552.81% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -75.00% Transfers In 0.00% -75.00% Transfers Out 0.00% -75.00% Total Transfers 0.00% -75.00% Change In Net Position (Budget Basis) $ 72,033 72,033 (344,179) (416,212) 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 (8,772) GAAP Components - OPEB and LAGERS 2,263,980 Year-end investment market value adjustment Ending Unassigned Fund Balance Non-GAAP Basis, 03/31/23 32,958 Other Net Position Components: Assigned - Current Year Encumbrances 692,381 Assigned - Prior Year Encumbrances Total Fund Balance $ 725,339 Income (Loss) Before Transfers
25
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Staywell Health Care
For the period ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Operating revenues: Charges for Services $ 17,859,000 17,859,000 15,306,181 (2,552,819) 85.71% 10.71% Miscellaneous 0.00% -75.00% Total Operating Revenues 17,859,000 17,859,000 15,306,181 (2,552,819) 85.71% 10.71% Operating Expenses: Personnel Services 568,500 568,500 183,550 384,950 32.29% -42.71% Other Services 22,268,500 22,268,500 17,222,830 5,045,670 77.34% 2.34% Supplies 0.00% -75.00% Capital Outlay 0.00% -75.00% Other Expenses 0.00% -75.00% Total Operating Expenses 22,837,000 22,837,000 17,406,380 5,430,620 76.22% 1.22% Nonoperating Revenues (Expenses): Investment Income 1,000 1,000 135,139 134,139 13513.90% 13438.90% Miscellaneous Revenue (Expense) 1,077,000 1,077,000 1,193,274 116,274 110.80% 35.80% Total Nonoperating Revenue (Expenses) 1,078,000 1,078,000 1,328,413 250,413 123.23% 48.23% (3,900,000) (3,900,000) (771,786) 3,128,214 19.79% -55.21% Transfers In - American Rescue Plan 3,900,000 3,900,000 3,900,000 100.00% 25.00% Transfers Out 0.00% -75.00% Total Transfers 3,900,000 3,900,000 3,900,000 100.00% 25.00% Change In Net Position (Budget Basis) $ 3,128,214 3,128,214 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, 03/31/23 4,257,425 Other Net Position Components: Assigned - Current Year Encumbrances 40,373 Assigned - Prior Year Encumbrances Total Fund Balance $ 4,297,798 Income (Loss) Before Transfers
26
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Workers' Compensation
For the period ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Operating revenues: Charges for Services $ 4,450,900 4,450,900 3,338,176 (1,112,724) 75.00% 0.00% Miscellaneous 0.00% -75.00% Total Operating Revenues 4,450,900 4,450,900 3,338,176 (1,112,724) 75.00% 0.00% Operating Expenses: Personnel Services 5,761 (5,761) 0.00% -75.00% Other Services 4,558,654 4,558,654 2,537,992 2,020,662 55.67% -19.33% Supplies 20,681 (20,681) 0.00% -75.00% Capital Outlay 0.00% -75.00% Other Expenses 0.00% -75.00% Total Operating Expenses 4,558,654 4,558,654 2,564,434 1,994,220 56.25% -18.75% Nonoperating Revenues (Expenses): Investment Income 6,000 6,000 85,293 79,293 1421.55% 1346.55% Miscellaneous Revenue (Expense) 6,521 6,521 0.00% -75.00% Total Nonoperating Revenue (Expenses) 6,000 6,000 91,814 85,814 1530.23% 1455.23% (101,754) (101,754) 865,556 967,310 -850.64% -925.64% Transfers In 0.00% -75.00% Transfers Out 0.00% -75.00% Total Transfers 0.00% -75.00% Change In Net Position (Budget Basis) $ (101,754) (101,754) 865,556 967,310 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, 03/31/23 (5,530,651) Other Net Position Components: Restricted - Work Comp Escrow Assigned - Current Year Encumbrances 33,436 Assigned - Prior Year Encumbrances 12,500 Total Fund Balance $ (5,484,715) Income (Loss) Before Transfers
27
CITY OF
MISSOURI Budgetary Comparison Schedule Risk Management
INDEPENDENCE,
For the period ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Operating revenues: Charges for Services $ 3,196,000 3,196,000 2,208,225 (987,775) 69.09% -5.91% Miscellaneous 0.00% -75.00% Total Operating Revenues 3,196,000 3,196,000 2,208,225 (987,775) 69.09% -5.91% Operating Expenses: Personnel Services 5,761 (5,761) 0.00% -75.00% Other Services 2,936,292 2,936,292 1,435,091 1,501,201 48.87% -26.13% Supplies 2,000 2,000 2,000 0.00% -75.00% Capital Outlay 0.00% -75.00% Other Expenses 0.00% -75.00% Total Operating Expenses 2,938,292 2,938,292 1,440,852 1,497,440 49.04% -25.96% Nonoperating Revenues (Expenses): Investment Income 23,000 23,000 35,463 12,463 154.19% 79.19% Miscellaneous Revenue (Expense) 0.00% -75.00% Total Nonoperating Revenue (Expenses) 23,000 23,000 35,463 12,463 154.19% 79.19% 280,708 280,708 802,836 522,128 286.00% 211.00% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -75.00% Transfers In 0.00% -75.00% Transfers Out 0.00% -75.00% Total Transfers 0.00% -75.00% Change In Net Position (Budget Basis) $ 280,708 280,708 802,836 522,128 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, 03/31/23 2,555,578 Other Net Position Components: Assigned - Current Year Encumbrances 28,974 Assigned - Prior Year Encumbrances Total Fund Balance $ 2,584,552 Income (Loss) Before Transfers
28
CITY OF INDEPENDENCE, MISSOURI
Finance & Support Services
For the period ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Operating revenues: Charges for Services $ 10,506,740 10,506,740 7,880,055 (2,626,685) 75.00% 0.00% Miscellaneous 0.00% -75.00% Total Operating Revenues 10,506,740 10,506,740 7,880,055 (2,626,685) 75.00% 0.00% Operating Expenses: Personnel Services 5,575,572 5,479,572 3,672,416 1,807,156 67.02% -7.98% Retiree Benefits 268,000 268,000 158,725 109,275 59.23% -15.77% Other Services 4,446,414 4,477,414 3,983,042 494,372 88.96% 13.96% Supplies 29,900 29,900 20,802 9,098 69.57% -5.43% Capital Outlay 142,500 207,500 294,234 (86,734) 141.80% 66.80% Other Expenses 0.00% -75.00% Total Operating Expenses 10,462,386 10,462,386 8,129,219 2,333,167 77.70% 2.70% Nonoperating Revenues (Expenses): Investment Income 0.00% -75.00% Miscellaneous Revenue (Expense) 15,566 15,566 0.00% -75.00% Total Nonoperating Revenue (Expenses) 15,566 15,566 0.00% -75.00% 44,354 44,354 (233,598) (277,952) -526.67% -601.67% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -75.00% Transfers In – CARES Act 0.00% -75.00% Transfers Out 0.00% -75.00% Total Transfers 0.00% -75.00% Change In Net Position (Budget Basis) $ 44,354 44,354 (233,598) (277,952) 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, 03/31/23 1,339,731 Other Net Position Components: Assigned - Current Year Encumbrances 477,743 Assigned - Prior Year Encumbrances 2,921 Total Fund Balance $ 1,820,395 Income (Loss) Before Transfers
Budgetary Comparison Schedule
29
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Charges for Services $ 9,289 9,289 12,386 3,097 133.34% 58.34% Investment Income (Loss) 2,555 2,555 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 9,289 9,289 14,941 5,652 160.85% 85.85% Expenditures: General Government 160 (160) 0.00% -75.00% Debt Service 10,200 10,200 9,467 733 92.81% 17.81% Total Expenditures 10,200 10,200 9,627 573 94.38% 19.38% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total expenditures and other financing uses 10,200 10,200 9,627 573 94.38% 19.38% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (911) (911) 5,314 6,225 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, 03/31/23 109,549 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 109,549
Debt Service - Neighborhood Improvement Districts For the period ended March 31, 2023 30
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule
Street Improvements Capital Project Fund For the period ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Charges for Services $ 5,397 5,397 0.00% -75.00% Investment Income 3,500 3,500 0.00% -75.00% Intergovernmental 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 8,897 8,897 0.00% -75.00% Other Financing Sources: Transfers In 115 115 0.00% -75.00% Total Other Financing Sources 115 115 0.00% -75.00% Total Revenues and Other Financing Sources 9,012 9,012 0.00% -75.00% Expenditures: Public Works 22 (22) 0.00% -75.00% Culture and Recreation 0.00% -75.00% Capital Outlay 263,944 46,051 217,893 17.45% -57.55% Total Expenditures 263,944 46,073 217,871 17.46% -57.54% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses — 263,944 46,073 217,871 17.46% -57.54% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (263,944) (37,061) 226,883 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, 03/31/23 (56,858) Other Fund Balance Components: Committed - Current Year Encumbrances 36,901 Committed - Prior Year Encumbrances 95,506 Total Fund Balance $ 75,549
31
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Revolving Public Improvements Capital Project Fund For the period ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Charges for Services $ 0.00% -75.00% Investment Income (Loss) 404 404 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 404 404 0.00% -75.00% Expenditures: Public Works 6 (6) 0.00% -75.00% Culture and Recreation 0.00% -75.00% Capital Outlay 0.00% -75.00% Total Expenditures 6 (6) 0.00% -75.00% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 6 (6) 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 398 398 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, 03/31/23 21,611 Other Fund Balance Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances Total Fund Balance $ 21,611
32
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Charges for Services $ 0.00% -75.00% Intergovernmental 0.00% -75.00% Investment Income 374 374 0.00% -75.00% Other Revenue 3,125 3,125 0.00% -75.00% Total revenues 3,499 3,499 0.00% -75.00% Other Financing Sources: Transfers In 153,637 153,637 0.00% -75.00% Total Other Financing Sources 153,637 153,637 0.00% -75.00% Total Revenues and Other Financing Sources 157,136 157,136 0.00% -75.00% Expenditures: Public Works 9 (9) 0.00% -75.00% Culture and Recreation 0.00% -75.00% Capital Outlay 231,511 115,327 116,184 49.81% -25.19% Total Expenditures 231,511 115,336 116,175 49.82% -25.18% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total expenditures and other financing uses 231,511 115,336 116,175 49.82% -25.18% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (231,511) 41,800 273,311 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, 03/31/23 (123,086) Other Fund Balance Components: Committed - Current Year Encumbrances 45,811 Committed - Prior Year Encumbrances Total Fund Balance $ (77,275)
Buildings and Other Improvements Capital Project Fund For the period ended March 31, 2023 33
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Charges for Services $ 0.00% -75.00% Investment Income 0.00% -75.00% Other Revenue 0.00% -75.00% Total revenues 0.00% -75.00% Expenditures: Public Works 0.00% -75.00% Culture and Recreation 0.00% -75.00% Capital Outlay 0.00% -75.00% Total Expenditures 0.00% -75.00% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total expenditures and other financing uses 0.00% -75.00% 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, 03/31/23 (16,155) Fund Balance Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances Total Fund Balance $ (16,155) CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Storm Drainage Capital Project Fund For the period ended March 31, 2023 34
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Park Improvements Capital Project Fund For the period ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Charges for Services $ 0.00% -75.00% Investment Income (Loss) 604 604 0.00% -75.00% Other Revenue 0.00% -75.00% Total revenues 604 604 0.00% -75.00% Expenditures: Public Works 9 (9) 0.00% -75.00% Culture and Recreation 0.00% -75.00% Capital Outlay 0.00% -75.00% Total Expenditures 9 (9) 0.00% -75.00% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total expenditures and other financing uses 9 (9) 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 595 595 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, 03/31/23 31,476 Fund Balance Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances Total Fund Balance $ 31,476
35
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Charges for Services $ 0.00% -75.00% Investment Income 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 0.00% -75.00% Expenditures: Public Works 0.00% -75.00% Culture and Recreation 0.00% -75.00% Capital Outlay 0.00% -75.00% Total Expenditures 0.00% -75.00% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 0.00% -75.00% 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, 03/31/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 March 31, 2023 36
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Independence Events Center CID For the period ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Sales Taxes $ 8,470,843 8,470,843 5,965,468 (2,505,375) 70.42% -4.58% Investment Income 30,000 30,000 293,336 263,336 977.79% 902.79% Total Revenues 8,500,843 8,500,843 6,258,804 (2,242,039) 73.63% -1.37% Expenditures: Administrative Fee 169,417 169,417 119,309 50,108 70.42% -4.58% Insurance 4,750 4,750 4,750 0.00% -75.00% Legal 44,500 44,500 2,390 42,110 5.37% -69.63% Audit 5,500 5,500 5,500 100.00% 25.00% Banking 8,600 8,600 8,113 487 94.34% 19.34% Maintenance 100,000 100,000 100,000 0.00% -75.00% Capital Outlay 0.00% -75.00% Other 3,375 (3,375) 0.00% -75.00% Total Expenditures 332,767 332,767 138,687 194,080 41.68% -33.32% Other Financing Uses: Transfers Out - EATS 1,175,000 1,175,000 556,447 618,553 47.36% -27.64% Transfers Out - Debt Service (City) 4,202,213 4,202,213 4,475,886 (273,673) 106.51% 31.51% Transfers Out - Captial Projects 2,309,104 2,309,104 2,226,583 82,521 96.43% 21.43% Total Other Financing Uses 7,686,317 7,686,317 7,258,916 427,401 94.44% 19.44% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 481,759 481,759 (1,138,799) (1,620,558) 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, 03/31/23 9,300,650 Other Fund Balance Components: Restricted - current year encumbrances Restricted - prior year encumbrances 5,795 Total Fund Balance $ 9,306,445
37
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Crackerneck Creek TDD For the period ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Sales taxes $ 397,895 397,895 0.00% -75.00% Investment income 7,466 7,466 0.00% -75.00% Total revenues 405,361 405,361 0.00% -75.00% Expenditures: Administrative fee 7,958 (7,958) 0.00% -75.00% Insurance 2,354 (2,354) 0.00% -75.00% Legal 1,250 (1,250) 0.00% -75.00% Audit 5,500 (5,500) 0.00% -75.00% Banking 420 (420) 0.00% -75.00% Contract services 0.00% -75.00% Capital outlay 0.00% -75.00% Other 0.00% -75.00% Total expenditures 17,482 (17,482) 0.00% -75.00% Other financing uses: Transfers out - EATS 198,947 (198,947) 0.00% -75.00% Transfers out - Debt Service (City) 0.00% -75.00% Total other financing uses 198,947 (198,947) 0.00% -75.00% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 188,932 188,932 Unassigned Fund Balance at Beginning of Year 190,339 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year (499) Unassigned Ending Fund Balance, 03/31/23 378,772 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - City Transportation 7,674 Total Fund Balance $ 386,446
38
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 15,109,796 15,109,796 0.00% -75.00% Investment Income (Loss) 537,348 521,120 0.00% -75.00% Other revenue 856,120 856,120 0.00% -75.00% Total Revenues 16,503,264 16,487,036 0.00% -75.00% Other Financing Sources: Transfers In 556,447 556,447 0.00% -75.00% Total Other Financing Sources 556,447 556,447 0.00% -75.00% Total Revenues and Other Financing Sources 17,059,711 17,043,483 0.00% -75.00% Expenditures: Tax Increment Financing 1,242,197 (1,241,977) 0.00% -75.00% Debt Service Principal 4,775,000 4,775,000 6,167,862 (1,392,862) 129.17% 54.17% Interest and Fiscal Agent Fees 4,356,100 4,356,100 4,830,485 (474,385) 110.89% 35.89% Debt Issuance Costs 0.00% -75.00% Total Expenditures 9,131,100 9,131,100 12,240,544 (3,109,224) 134.05% 59.05% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 556,447 (556,447) 0.00% -75.00% Total Other Financing Uses 556,447 (556,447) 0.00% -75.00% Total Expenditures and Other Financing Uses 9,131,100 9,131,100 12,796,991 (3,665,671) 140.15% 65.15% Excess of Revenues Over (Under) Expenditures and other financing uses $ (9,131,100) (9,131,100) 4,262,720 13,393,820 Unassigned Fund Balance at Beginning of Year 21,016,591 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 03/31/23 25,279,311 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 10,524,834 Total Fund Balance $ 35,804,145
Comparison Schedule Tax Increment Financing Summary For the Period Ended March 31, 2023 39
CITY OF INDEPENDENCE, MISSOURI Budgetary
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 35,155 35,155 0.00% -75.00% Investment Income (Loss) 980 980 0.00% -75.00% Other Revenue 93,591 93,591 0.00% -75.00% Total Revenues 129,726 129,726 0.00% -75.00% Other Financing Sources: Transfers In 0.00% -75.00% Total Other Financing Sources 0.00% -75.00% Total Revenues and Other Financing Sources 129,726 129,726 0.00% -75.00% Expenditures: Tax Increment Financing 0.00% -75.00% Debt Service Principal 210,000 210,000 210,000 100.00% 25.00% Interest and Fiscal Agent Fees 321,000 321,000 320,938 62 99.98% 24.98% Debt Issuance Costs 0.00% -75.00% Total Expenditures 531,000 531,000 530,938 62 99.99% 24.99% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 531,000 531,000 530,938 62 99.99% 24.99% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (531,000) (531,000) (401,212) 129,788 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, 03/31/23 (1,327,197) Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 483,752 Total Fund Balance $ (843,445)
Budgetary Comparison Schedule Santa Fe TIF For the Period Ended
40
CITY OF INDEPENDENCE, MISSOURI
March 31, 2023
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Hartman Heritage TIF For the Period Ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 209,807 209,807 0.00% -75.00% Investment Income (Loss) 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 209,807 209,807 0.00% -75.00% Other Financing Sources: Transfers In 0.00% -75.00% Total Other Financing Sources 0.00% -75.00% Total Revenues and Other Financing Sources 209,807 209,807 0.00% -75.00% Expenditures: Tax Increment Financing 0.00% -75.00% Debt Service Principal 0.00% -75.00% Interest and Fiscal Agent Fees 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 0.00% -75.00% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 209,807 209,807 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, 03/31/23 (2,484,135) Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ (2,484,135)
41
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ (1,288) (1,288) 0.00% -75.00% Investment Income (Loss) 4 4 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues (1,284) (1,284) 0.00% -75.00% Expenditures: Tax Increment Financing (1,284) 1,284 0.00% -75.00% Debt Service Principal 0.00% -75.00% Interest and Fiscal Agent Fees 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures (1,284) 1,284 0.00% -75.00% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses (1,284) 1,284 0.00% -75.00% 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, 03/31/23 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $
Drumm Farm TIF
42
For the Period Ended March 31, 2023
CITY
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 4,767,378 4,767,378 0.00% -75.00% Investment Income (Loss) 371,161 371,161 0.00% -75.00% Other Revenue 1 1 0.00% -75.00% Total Revenues 5,138,540 5,138,540 0.00% -75.00% Other Financing Sources: Transfers In 522,981 522,981 0.00% -75.00% Total Other Financing Sources 522,981 522,981 0.00% -75.00% Total Revenues and Other Financing Sources 5,661,521 5,661,521 0.00% -75.00% Expenditures: Tax Increment Financing 270,706 (270,706) 0.00% -75.00% Debt Service Principal 0.00% -75.00% Interest and Fiscal Agent Fees 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 270,706 (270,706) 0.00% -75.00% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 522,981 (522,981) 0.00% -75.00% Total Other Financing Uses 522,981 (522,981) 0.00% -75.00% Total Expenditures and Other Financing Uses 793,687 (793,687) 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 4,867,834 4,867,834 Unassigned Fund Balance at Beginning of Year 17,258,732 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 03/31/23 22,126,566 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 392,126 Total Fund Balance $ 22,518,692
TIF
the Period Ended March 31, 2023 43
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Eastland
For
CITY
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 68,198 68,198 0.00% -75.00% Investment Income (Loss) 4,456 4,456 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 72,654 72,654 0.00% -75.00% Expenditures: Tax Increment Financing 3 (3) 0.00% -75.00% Debt Service Principal 0.00% -75.00% Interest and Fiscal Agent Fees 74,800 (74,800) 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 74,803 (74,803) 0.00% -75.00% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 74,803 (74,803) 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (2,149) (2,149) 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, 03/31/23 7,961 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 7,961
OF
Budgetary Comparison Schedule North Independence TIF For the Period Ended March 31, 2023 44
INDEPENDENCE, MISSOURI
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Crackerneck Creek TIF
For the Period Ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 1,334,245 1,334,245 0.00% -75.00% Investment Income (Loss) 55,742 55,742 0.00% -75.00% Other Revenue 762,528 762,528 0.00% -75.00% Total Revenues 2,152,515 2,152,515 0.00% -75.00% Other Financing Sources: Transfers In 0.00% -75.00% Total Other Financing Sources 0.00% -75.00% Total Revenues and Other Financing Sources 2,152,515 2,152,515 0.00% -75.00% Expenditures: Tax Increment Financing 5,168 (5,168) 0.00% -75.00% Debt Service Principal 2,260,000 2,260,000 2,260,000 100.00% 25.00% Interest and Fiscal Agent Fees 3,270,500 3,270,500 3,270,362 138 100.00% 25.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 5,530,500 5,530,500 5,535,530 (5,030) 100.09% 25.09% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 5,530,500 5,530,500 5,535,530 (5,030) 100.09% 25.09% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (5,530,500) (5,530,500) (3,383,015) 2,147,485 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, 03/31/23 1,114,290 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 6,300,062 Total Fund Balance $ 7,414,352
45
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 748,455 748,455 0.00% -75.00% Investment Income (Loss) 1,812 1,812 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 750,267 750,267 0.00% -75.00% Expenditures: Tax Increment Financing 23 (23) 0.00% -75.00% Debt Service Principal 715,476 (715,476) 0.00% -75.00% Interest and Fiscal Agent Fees 17,124 (17,124) 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 732,623 (732,623) 0.00% -75.00% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 732,623 (732,623) 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 17,644 17,644 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, 03/31/23 27,104 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 27,104
Budgetary Comparison Schedule Old Landfill TIF
the Period Ended March 31, 2023 46
CITY OF INDEPENDENCE, MISSOURI
For
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Trinity TIF
For the Period Ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 438,809 438,809 0.00% -75.00% Investment Income (Loss) 986 986 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 439,795 439,795 0.00% -75.00% Other Financing Sources: Transfers In 27,785 27,785 0.00% -75.00% Total Other Financing Sources 27,785 27,785 0.00% -75.00% Total Revenues and Other Financing Sources 467,580 467,580 0.00% -75.00% Expenditures: Tax Increment Financing 15 (15) 0.00% -75.00% Debt Service Principal 366,798 (366,798) 0.00% -75.00% Interest and Fiscal Agent Fees 53,002 (53,002) 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 419,815 (419,815) 0.00% -75.00% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 27,785 (27,785) 0.00% -75.00% Total Other Financing Uses 27,785 (27,785) 0.00% -75.00% Total Expenditures and Other Financing Uses 447,600 (447,600) 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 19,980 19,980 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, 03/31/23 74,596 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 74,596
47
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
HCA TIF
For the Period Ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 4,202,421 4,202,421 0.00% -75.00% Investment Income (Loss) 33,414 33,414 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 4,235,835 4,235,835 0.00% -75.00% Other Financing Sources: Transfers In 5,681 5,681 0.00% -75.00% Total Other Financing Sources 5,681 5,681 0.00% -75.00% Total Revenues and Other Financing Sources 4,241,516 4,241,516 0.00% -75.00% Expenditures: Tax Increment Financing 903,181 (903,181) 0.00% -75.00% Debt Service Principal 2,305,000 2,305,000 2,305,000 100.00% 25.00% Interest and Fiscal Agent Fees 764,600 764,600 764,600 100.00% 25.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 3,069,600 3,069,600 3,972,781 (903,181) 129.42% 54.42% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 5,681 (5,681) 0.00% -75.00% Total Other Financing Uses 5,681 (5,681) 0.00% -75.00% Total Expenditures and Other Financing Uses 3,069,600 3,069,600 3,978,462 (908,862) 129.61% 54.61% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (3,069,600) (3,069,600) 263,054 3,332,654 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, 03/31/23 1,203,432 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 3,348,894 Total Fund Balance $ 4,552,326
48
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Cinema East TIF
For the Period Ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 216,438 216,438 0.00% -75.00% Investment Income (Loss) 1,438 1,438 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 217,876 217,876 0.00% -75.00% Expenditures: Tax Increment Financing 18 (18) 0.00% -75.00% Debt Service Principal 0.00% -75.00% Interest and Fiscal Agent Fees 100,650 (100,650) 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 100,668 (100,668) 0.00% -75.00% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 100,668 (100,668) 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 117,208 117,208 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, 03/31/23 170,450 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 170,450
49
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule 23rd & Noland Project 1 TIF
For the Period Ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ (156,025) (156,025) 0.00% -75.00% Investment Income (Loss) 261 261 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues (155,764) (155,764) 0.00% -75.00% Expenditures: Tax Increment Financing 10 (10) 0.00% -75.00% Debt Service Principal 0.00% -75.00% Interest and Fiscal Agent Fees 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 10 (10) 0.00% -75.00% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 10 (10) 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (155,774) (155,774) Unassigned Fund Balance at Beginning of Year 157,362 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 03/31/23 1,588 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 1,588
50
CITY
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 12,980 12,980 0.00% -75.00% Investment Income (Loss) 75 75 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 13,055 13,055 0.00% -75.00% Expenditures: Tax Increment Financing 1 (1) 0.00% -75.00% Debt Service Principal 15,400 (15,400) 0.00% -75.00% Interest and Fiscal Agent Fees 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 15,401 (15,401) 0.00% -75.00% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 15,401 (15,401) 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (2,346) (2,346) 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, 03/31/23 5,697 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 5,697
Budgetary Comparison Schedule 23rd & Noland Project 2 TIF For the Period Ended March 31, 2023 51
OF INDEPENDENCE, MISSOURI
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule 23rd & Noland Project 3 TIF For the Period Ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 22,949 22,949 0.00% -75.00% Investment Income (Loss) 254 254 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 23,203 23,203 0.00% -75.00% Expenditures: Tax Increment Financing 3 (3) 0.00% -75.00% Debt Service Principal 0.00% -75.00% Interest and Fiscal Agent Fees 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 3 (3) 0.00% -75.00% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 3 (3) 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 23,200 23,200 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, 03/31/23 31,090 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 31,090
52
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
23rd & Noland Project 4 TIF
For the Period Ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 409,733 409,733 0.00% -75.00% Investment Income (Loss) 5,128 5,128 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 414,861 414,861 0.00% -75.00% Expenditures: Tax Increment Financing 67 (67) 0.00% -75.00% Debt Service Principal 0.00% -75.00% Interest and Fiscal Agent Fees 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 67 (67) 0.00% -75.00% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 67 (67) 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 414,794 414,794 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, 03/31/23 504,690 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 504,690
53
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 280,846 280,846 0.00% -75.00% Investment Income (Loss) 19,601 19,601 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 300,447 300,447 0.00% -75.00% Expenditures: Tax Increment Financing 63,103 (63,103) 0.00% -75.00% Debt Service Principal 0.00% -75.00% Interest and Fiscal Agent Fees 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 63,103 (63,103) 0.00% -75.00% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 63,103 (63,103) 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 237,344 237,344 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, 03/31/23 1,006,005 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 1,006,005
Square TIF
the Period Ended March 31, 2023 54
Independence
For
CITY
OF
INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule
I-70 & Little Blue Parkway Project 1 TIF For the Period Ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 2,008,520 2,008,520 0.00% -75.00% Investment Income (Loss) 21,127 21,127 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 2,029,647 2,029,647 0.00% -75.00% Expenditures: Tax Increment Financing 215 (215) 0.00% -75.00% Debt Service Principal 141,629 (141,629) 0.00% -75.00% Interest and Fiscal Agent Fees 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 141,844 (141,844) 0.00% -75.00% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 141,844 (141,844) 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 1,887,803 1,887,803 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, 03/31/23 2,083,784 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 2,083,784
55
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
I-70 & Little Blue Parkway Project 3 TIF For the Period Ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 306,427 306,427 0.00% -75.00% Investment Income (Loss) 3,731 3,731 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 310,158 310,158 0.00% -75.00% Expenditures: Tax Increment Financing 51 (51) 0.00% -75.00% Debt Service Principal 123,268 (123,268) 0.00% -75.00% Interest and Fiscal Agent Fees 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 123,319 (123,319) 0.00% -75.00% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 123,319 (123,319) 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 186,839 186,839 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, 03/31/23 312,250 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 312,250
56
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 72,986 72,986 0.00% -75.00% Investment Income (Loss) 448 448 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 73,434 73,434 0.00% -75.00% Expenditures: Tax Increment Financing 8 (8) 0.00% -75.00% Debt Service Principal 12,811 (12,811) 0.00% -75.00% Interest and Fiscal Agent Fees 124,289 (124,289) 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 137,108 (137,108) 0.00% -75.00% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 137,108 (137,108) 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (63,674) (63,674) 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, 03/31/23 28,448 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 28,448
Marketplace Project 1 TIF
57
For the Period Ended March 31, 2023
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule
Marketplace Project 2 TIF
For the Period Ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 131,762 131,762 0.00% -75.00% Investment Income (Loss) 502 502 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 132,264 132,264 0.00% -75.00% Expenditures: Tax Increment Financing 689 (689) 0.00% -75.00% Debt Service Principal 17,480 (17,480) 0.00% -75.00% Interest and Fiscal Agent Fees 104,720 (104,720) 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 122,889 (122,889) 0.00% -75.00% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 122,889 (122,889) 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 9,375 9,375 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, 03/31/23 42,048 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 42,048
58
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule
TIF Supplemental Appropriation Fund
For the Period Ended March 31, 2023
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ Property tax RSO - Cargo Largo 3,430 3,430 0.00% -75.00% Hartman Heritage 76,019 76,019 0.00% -75.00% Drumm Farm 195,573 195,573 0.00% -75.00% Mt Washington 2,603 2,603 0.00% -75.00% 23rd & Noland - Project 1 65,622 65,622 0.00% -75.00% Sales tax RSO - Cargo Largo 228,720 228,720 0.00% -75.00% Drumm Farm 15,139 15,139 0.00% -75.00% Eastland 421,113 421,113 0.00% -75.00% Mt Washington 567 567 0.00% -75.00% 23rd & Noland - Project 1 19,306 19,306 0.00% -75.00% Investment Income (Loss) 16,228 16,228 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 1,044,320 1,044,320 0.00% -75.00% Expenditures: Tax Increment Financing 220 (220) 0.00% -75.00% Debt Service Principal 0.00% -75.00% Interest and Fiscal Agent Fees 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 220 (220) 0.00% -75.00% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 220 (220) 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 1,044,100 1,044,100 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, 03/31/23 1,378,736 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 1,378,736
59