Monthly Financial and Operating Report April 2021
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 Public Safety 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 CARES Act 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 Enterprise Resource Planning 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 Mid-Town Truman Rd TIF 40 RSO TIF 41 Santa Fe TIF 42 Hartman Heritage TIF 43 Drumm Farm TIF 44 Eastland TIF 45 North Independence TIF 46 Mt Washington TIF 47 Crackerneck Creek TIF 48 Old Landfill TIF 49 Trinity TIF 50 HCA TIF 51 Cinema East TIF 52 23rd & Noland Project 1 TIF 53 23rd & Noland Project 2 TIF 54 23rd & Noland Project 3 TIF 55 23th & Noland Project 4 TIF 56 Independence Square TIF 57 I-70 & Little Blue Parkway Project 1 TIF 58 I-70 & Little Blue Parkway Project 3 TIF 59 Marketplace Project 1 TIF 60 Marketplace Project 2 TIF 61 TIF Application Fees 62
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule General Fund
For the period ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 31,453,100 31,453,100 28,302,426 (3,150,674) 89.98% 6.65% Licenses and Permits 4,392,069 4,432,069 3,922,362 (509,707) 88.50% 5.17% Intergovernmental 5,262,150 5,262,150 4,394,452 (867,698) 83.51% 0.18% Charges for Current Services 2,058,050 2,150,529 1,565,128 (585,401) 72.78% -10.55% Interfund Charges for Support Services 5,035,500 5,035,500 4,196,250 (839,250) 83.33% 0.00% Fines and Forfeitures 3,771,000 3,771,000 1,822,164 (1,948,836) 48.32% -35.01% Investment Income (Loss) 175,000 175,000 179,891 4,891 102.79% 19.46% Other Revenue 2,493,532 890,562 993,120 102,558 111.52% 28.19% Total Revenues 54,640,401 53,169,910 45,375,793 (7,794,117) 85.34% 2.01% Other Financing Sources: Payments In Lieu of Taxes 19,796,612 19,796,612 15,909,601 (3,887,011) 80.37% -2.96% Operating Transfers In - CARES Act 808,036 808,036 0.00% -83.33% Total Other Financing Sources 19,796,612 19,796,612 16,717,637 (3,078,975) 84.45% 1.12% Total Revenues and Other Financing Sources 74,437,013 72,966,522 62,093,430 (10,873,092) 85.10% 1.77% Expenditures: City Council 680,553 680,553 542,874 137,679 79.77% -3.56% City Clerk 195,240 195,240 168,982 26,258 86.55% 3.22% City Manager 1,187,339 1,187,339 959,325 228,014 80.80% -2.53% Municipal Court 1,207,254 1,207,254 929,903 277,351 77.03% -6.30% Law 661,301 661,301 540,647 120,654 81.76% -1.57% Finance 5,295,645 5,315,645 4,200,713 1,114,932 79.03% -4.30% Community Development 5,653,911 3,984,917 3,792,196 192,721 95.16% 11.83% Police 31,553,037 31,651,852 26,225,898 5,425,954 82.86% -0.47% Fire 21,181,684 21,182,156 19,652,931 1,529,225 92.78% 9.45% Health 94,462 9,960 84,502 10.54% -72.79% Public Works 4,775,106 4,779,860 4,620,867 158,993 96.67% 13.34% COVID Reserve 1,468,971 1,468,971 1,468,971 0.00% -83.33% Debt service 566,972 566,972 4,392 562,580 0.77% -82.56% Total Expenditures 74,427,013 72,976,522 61,648,688 11,327,834 84.48% 1.15% Other Financing Uses: Transfers Out 10,000 10,000 35,300 (25,300) 353.00% 269.67% Total Expenditures and Other Financing Uses 74,437,013 72,986,522 61,683,988 11,302,534 84.51% 1.18% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (20,000) 409,442 429,442 Unassigned Fund Balance at Beginning of Year 5,301,516 Cancellation of prior year encumbrances 20,223 Change in other fund balance components during the year (115,636) Year-end investment market value adjustment Ending Unassigned Fund Balance, 04/30/21 5,615,545 Restricted 226,823 Committed 18,478 Assigned 1,561,238 Total Fund Balance $ 7,422,084
1
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Sales Taxes $ 8,028,559 8,028,559 7,144,078 (884,481) 88.98% 5.65% Charges for Services 7,088 7,088 100.00% 16.67% Intergovernmental Revenue 30,493 30,493 0.00% -83.33% Investment Income (Loss) 10,000 10,000 43,528 33,528 435.28% 351.95% Other Revenue 7,395 7,395 0.00% -83.33% Total Revenues 8,038,559 8,045,647 7,232,582 (813,065) 89.89% 6.56% Other Financing Sources: Transfers in 0.00% -83.33% Issuance of debt 0.00% -83.33% Total other financing sources 0.00% -83.33% Total revenues and other financing sources 8,038,559 8,045,647 7,232,582 (813,065) 89.89% 6.56% Expenditures: General Government 0.00% -83.33% Street Maintenance 929,575 929,575 534,714 394,861 57.52% -25.81% Capital Outlay 4,971,836 25,237,880 6,330,135 18,907,745 25.08% -58.25% Debt Service 555,951 555,951 555,951 100.00% 16.67% Total Expenditures 6,457,362 26,723,406 7,420,800 19,302,606 27.77% -55.56% Other Financing Uses: Transfers Out 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 6,457,362 26,723,406 7,420,800 19,302,606 27.77% -55.56% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 1,581,197 (18,677,759) (188,218) 18,489,541 Unassigned Fund Balance at Beginning of Year (1,383,849) Cancellation of Prior Year Encumbrances 43,738 Change in Other Fund Balance Components During the Year 3,682,208 Year-end investment market value adjustment Ending Unassigned Fund Balance, 04/30/21 2,153,879 Fund Balance Components: Restricted - Current Year Encumbrances 1,713,928 Restricted - Prior Year Encumbrances 1,032,503 Restricted - Debt Reserve Project Accounts - Capital Projects 14,180,908 Total Fund Balance $ 19,081,218
Improvements Sales Tax Fund For the period ended April 30, 2021 2
Schedule Street
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Park Improvements Sales Tax Fund For the period ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Sales Taxes $ 4,014,300 4,014,300 3,572,044 (442,256) 88.98% 5.65% Charges for services 348,455 387,201 111,310 (275,891) 28.75% -54.58% Intergovernmental 0.00% -83.33% Investment Income (Loss) 3,000 3,000 17,291 14,291 576.37% 493.04% Other Revenue 2,500 2,500 27,563 25,063 1102.52% 1019.19% Total Revenues 4,368,255 4,407,001 3,728,208 (678,793) 84.60% 1.27% Other Financing Sources: Transfers In 25,300 25,300 100.00% 16.67% Transfers In - CARES Act 4,925 4,925 0.00% -83.33% Proceeds from Bond Issuance/Capital Lease 0.00% -83.33% Total Other Financing Sources 25,300 30,225 4,925 0.00% -83.33% Total Revenues and Other Financing Sources 4,368,255 4,432,301 3,758,433 (673,868) 84.80% 1.47% Expenditures: Culture and Recreation 3,640,907 3,640,907 2,520,756 1,120,151 69.23% -14.10% Capital Outlay 280,625 1,131,743 172,047 959,696 15.20% -68.13% Debt Service 261,589 261,589 111,271 150,318 42.54% -40.79% Total Expenditures 4,183,121 5,034,239 2,804,074 2,230,165 55.70% -27.63% Other Financing Uses: Transfers Out 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 4,183,121 5,034,239 2,804,074 2,230,165 55.70% -27.63% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 185,134 (601,938) 954,359 1,556,297 Unassigned Fund Balance at Beginning of Year (658,038) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 04/30/21 296,321 Other Fund Balance Components: Restricted - Current Year Encumbrances 191,566 Restricted - Prior Year Encumbrances 12,553 Total Fund Balance $ 500,440
3
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Storm Water Sales Tax Fund
For the period ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Sales Taxes $ 4,014,317 4,014,317 3,572,044 (442,273) 88.98% 5.65% Investment income (loss) 24,500 24,500 139,734 115,234 570.34% 487.01% Other Revenue 14,312 14,312 0.00% -83.33% Total revenues 4,038,817 4,038,817 3,726,090 (312,727) 92.26% 8.93% Expenditures: Storm water Administration 342,871 342,871 196,818 146,053 57.40% -25.93% Maintenance 2,116,748 2,116,748 1,155,688 961,060 54.60% -28.73% Permit completion 318,000 318,000 329,100 (11,100) 103.49% 20.16% Capital outlay 1,300,000 3,867,673 733,935 3,133,738 18.98% -64.35% Total Expenditures 4,077,619 6,645,292 2,415,541 4,229,751 36.35% -46.98% Total Ependitures and Other Financing Uses 4,077,619 6,645,292 2,415,541 4,229,751 Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (38,802) (2,606,475) 1,310,549 3,917,024 Unassigned Fund Balance at Beginning of Year 7,257,353 Cancellation of Prior Year Encumbrances 54,669 Change in Other Fund Balance Components During the Year 11,713 Year-end investment market value adjustment Ending Unassigned Fund Balance, 04/30/21 8,634,284 Other Fund Balance Components: Restricted - Current Year Encumbrances 388,482 Restricted - Prior Year Encumbrances 339,967 Restricted - Regional Detention Construction 549,347 Restricted - Regional Detention Maintenance 53,156 Restricted - Emergency Response Relief 500,000 Total Fund Balance $ 10,465,236
4
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Police Public Safety Sales Tax Fund For the period ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Sales Taxes $ 2,133,460 2,133,460 1,898,832 (234,628) 89.00% 5.67% Investment Income (Loss) 5,000 5,000 38,902 33,902 778.04% 694.71% Other Revenue 54,782 54,782 0.00% -83.33% Total Revenues 2,138,460 2,138,460 1,992,516 (145,944) 93.18% 9.85% Expenditures: Public Safety Communications 602,307 602,307 566,172 36,135 94.00% 10.67% Facilities 99,768 99,768 75,046 24,722 75.22% -8.11% Equipment 2,017,965 2,017,965 1,735,200 282,765 85.99% 2.66% Debt Service 0.00% -83.33% Total Expenditures 2,720,040 2,720,040 2,376,418 343,622 87.37% 4.04% Other Financing Uses: Transfers Out/Capital Outlay 90,063 (90,063) 0.00% -83.33% Total Other Financing Uses 90,063 (90,063) 0.00% -83.33% Total Expenditures and Other Financing Uses 2,720,040 2,720,040 2,466,481 253,559 90.68% 7.35% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (581,580) (581,580) (473,965) 107,615 Unassigned Fund Balance at Beginning of Year 2,534,213 Cancellation of Prior Year Encumbrances 24,047 Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 04/30/21 2,084,295 Other Fund Balance Components: Restricted - Current Year Encumbrances 243,762 Restricted - Prior Year Encumbrances 20,543 Total Fund Balance $ 2,348,600
5
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Fire Public Safety Sales Tax Fund For the period ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Sales Taxes $ 2,007,200 2,007,200 1,786,152 (221,048) 88.99% 5.66% Investment Income (Loss) 5,300 5,300 17,661 12,361 333.23% 249.90% Other Revenue 6,302 8,369 2,067 132.80% 49.47% Total Revenues 2,012,500 2,018,802 1,812,182 (206,620) 89.77% 6.44% Expenditures: Public Safety 2,183,900 2,743,985 2,484,977 259,008 90.56% 7.23% Debt Service 73,236 73,236 73,236 0.00% -83.33% Total Expenditures 2,257,136 2,817,221 2,484,977 332,244 88.21% 4.88% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 2,257,136 2,817,221 2,484,977 332,244 88.21% 4.88% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (244,636) (798,419) (672,795) 125,624 Unassigned Fund Balance at Beginning of Year 1,243,946 Cancellation of Prior Year Encumbrances 21,960 Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 04/30/21 593,111 Other Fund Balance Components: Restricted - Current Year Encumbrances 1,222,557 Restricted - Prior Year Encumbrances 209,761 Total Fund Balance $ 2,025,429
6
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Animal Shelter Use Tax
For the period ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Use Tax $ 750,000 750,000 750,000 100.00% 16.67% Intergovernmental Revenue 0.00% -83.33% Investment Income (Loss) 186 186 0.00% -83.33% Other Revenue 1 1 0.00% -83.33% Total Revenues 750,000 750,000 750,187 187 100.02% 16.69% Expenditures: General Government -83.33% Animal Services 744,152 744,152 642,326 101,826 86.32% 2.99% Capital Outlay 0.00% -83.33% Debt Service 0.00% -83.33% Total Expenditures 744,152 744,152 642,326 101,826 86.32% 2.99% Other Financing Uses: Transfers In 0.00% -83.33% Transfers Out 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 744,152 744,152 642,326 101,826 86.32% 2.99% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 5,848 5,848 107,861 102,013 Unassigned Fund Balance at Beginning of Year 220,840 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 04/30/21 328,701 Fund Balance Components: Restricted - Current Year Encumbrances 2,894 Restricted - Prior Year Encumbrances Total Fund Balance $ 331,595
7
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Police Use Tax
For the period ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Use Tax $ 750,000 750,000 3,000,000 2,250,000 400.00% 316.67% Investment Income (Loss) 7,662 7,662 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 750,000 750,000 3,007,662 2,257,662 401.02% 317.69% Expenditures: Public Safety 750,000 750,000 275,126 474,874 36.68% -46.65% Debt Service 0.00% -83.33% Total Expenditures 750,000 750,000 275,126 474,874 36.68% -46.65% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 750,000 750,000 275,126 474,874 36.68% -46.65% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 2,732,536 2,732,536 Unassigned Fund Balance at Beginning of Year 937,998 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 04/30/21 3,670,534 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 3,670,534
8
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule Health Property Tax Levy For the period ended April 30, 2021 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 832,000 846,000 870,837 24,837 102.94% 19.61% Charges for Services 154,000 154,000 103,939 (50,061) 67.49% -15.84% Investment Income (Loss) 761 761 0.00% -83.33% Other Revenue 109,144 109,144 0.00% -83.33% Total Revenues 986,000 1,000,000 1,084,681 84,681 108.47% 25.14% Other Financing Sources: Transfers In - CARES Act 993 993 0.00% -83.33% Total Other Financing Uses 993 993 0.00% -83.33% Total Revenues and Other Sources 986,000 1,000,000 1,085,674 85,674 108.57% 25.24% Expenditures: Animal Services 986,000 1,000,000 798,557 201,443 79.86% -3.47% Health Services 55,831 (55,831) 0.00% -83.33% Total Expenditures 986,000 1,000,000 854,388 145,612 85.44% 2.11% Other Financing Uses: Transfers Out 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Uses 986,000 1,000,000 854,388 145,612 85.44% 2.11% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 231,286 231,286 Unassigned Fund Balance at Beginning of Year Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 04/30/21 231,286 Other Fund Balance Components: Restricted - Current Year Encumbrances 42,310 Restricted - Prior Year Encumbrances Total Fund Balance $ 273,596
9
CITY OF INDEPENDENCE, MISSOURI
Comparison Schedule Parks and Recreation Property Tax Levy For the period ended April 30, 2021 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 1,794,000 1,823,700 1,850,529 26,829 101.47% 18.14% Intergovernmental 30,000 30,000 69,373 39,373 231.24% 147.91% Charges for Services 184,813 184,813 145,783 (39,030) 78.88% -4.45% Investment Income (Loss) 1,635 1,635 0.00% -83.33% Other Revenue 26,069 26,069 0.00% -83.33% Total Revenues 2,008,813 2,038,513 2,093,389 54,876 102.69% 19.36% Expenditures: Parks and Recreation 1,899,830 1,929,530 1,420,568 508,962 73.62% -9.71% Total Expenditures 1,899,830 1,929,530 1,420,568 508,962 73.62% -9.71% Other Financing Uses – Transfers Out 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Uses 1,899,830 1,929,530 1,420,568 508,962 73.62% -9.71% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 108,983 108,983 672,821 563,838 Unassigned Fund Balance at Beginning of Year Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 04/30/21 672,821 Other Fund Balance Components: Restricted - Current Year Encumbrances 11,030 Restricted - Prior Year Encumbrances Total Fund Balance $ 683,851 10
Budgetary
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule Tourism Fund For the period ended April 30, 2021 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Transient Guest Taxes $ 1,860,354 1,860,354 981,000 (879,354) 52.73% -30.60% Charges for Services 23,944 23,944 1,448 (22,496) 6.05% -77.28% Investment Income (Loss) 3,300 3,300 20,627 17,327 625.06% 541.73% Other Revenue 15,600 15,600 1,444 (14,156) 9.26% -74.07% Total Revenues 1,903,198 1,903,198 1,004,519 (898,679) 52.78% -30.55% Expenditures: Tourism 1,997,806 2,174,064 1,173,956 1,000,108 54.00% -29.33% Total Expenditures 1,997,806 2,174,064 1,173,956 1,000,108 54.00% -29.33% Other Financing Uses – Transfers Out 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Uses 1,997,806 2,174,064 1,173,956 1,000,108 54.00% -29.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (94,608) (270,866) (169,437) 101,429 Unassigned Fund Balance at Beginning of Year 907,332 Cancellation of Prior Year Encumbrances 2,770 Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 04/30/21 740,665 Other Fund Balance Components: Restricted - Current Year Encumbrances 141,933 Restricted - Prior Year Encumbrances 75,874 Restricted - Operating Reserve 376,368 Total Fund Balance $ 1,334,840
11
Independence Square Benefit District For the period ended April 30, 2021 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 26,283 26,283 0.00% -83.33% Investment Income (Loss) 699 699 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 26,982 26,982 0.00% -83.33% Expenditures: Capital Outlay 421 (421) 0.00% -83.33% Total Expenditures 421 (421) 0.00% -83.33% Other Financing Uses – Transfers Out 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Uses 421 (421) 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 26,561 26,561 Unassigned Fund Balance at Beginning of Year 3,755 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 04/30/21 30,316 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 30,316 12
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
CITY OF INDEPENDENCE, MISSOURI
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Federal Grant - CDBG $ 814,159 1,819,696 375,954 (1,443,742) 20.66% -62.67% Other Revenue 47 47 -83.33% Total Revenues 814,159 1,819,696 376,001 (1,443,695) 20.66% -62.67% Expenditures: CDBG Administration 162,830 162,831 250,000 (87,169) 153.53% 70.20% CDBG Expenditures 663,994 770,519 246,784 523,735 32.03% -51.30% Total Expenditures 826,824 933,350 496,784 436,566 53.23% -30.10% Other Financing Uses: Transfers Out 899,011 899,011 0.00% -83.33% Total Other Financing Uses 899,011 899,011 0.00% -83.33% Total Expenditures and Other Uses 826,824 1,832,361 496,784 1,335,577 27.11% -56.22% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (12,665) (12,665) (120,783) (108,118) Unassigned Fund Balance at Beginning of Year (184,469) Cancellation of Prior Year Encumbrances 1 Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 04/30/21 (305,251) Other Fund Balance Components: Restricted - Current Year Encumbrances 156,340 Restricted - Prior Year Encumbrances 142,022 Total Fund Balance $ (6,889)
Budgetary Comparison Schedule Community Development Block Grant Fund For the period ended April 30, 2021 13
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Rental Rehabilitation For the period ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: HOME Program Grant $ 482,477 1,465,629 377,344 (1,088,285) 25.75% -57.58% Total Revenues 482,477 1,465,629 377,344 (1,088,285) 25.75% -57.58% Expenditures: HOME Administration 70,592 184,543 44,493 140,050 24.11% -59.22% Multi Family Housing 359,759 645,213 146,119 499,094 22.65% -60.68% Community Housing Development 102,788 686,535 427,016 259,519 62.20% -21.13% Total Expenditures 533,139 1,516,291 617,628 898,663 40.73% -42.60% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (50,662) (50,662) (240,284) (189,622) Unassigned Fund Balance at Beginning of Year (185,577) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 04/30/21 (425,861) Other Fund Balance Components: Restricted - Current Year Encumbrances 401,714 Restricted - Prior Year Encumbrances 24,042 Total Fund Balance $ (105)
14
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
License Surcharge For the period ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Licenses and Permits $ 6,357 6,357 0.00% -83.33% Investment Income (Loss) 4,000 4,000 18,420 14,420 460.50% 377.17% Other Revenue 0.00% -83.33% Total Revenues 4,000 4,000 24,777 20,777 619.43% 536.10% Expenditures: General Government 0.00% -83.33% Total expenditures 0.00% -83.33% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 4,000 4,000 24,777 20,777 Unassigned Fund Balance at Beginning of Year 1,282,878 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 04/30/21 1,307,655 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 1,307,655
15
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Grants
For the period ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Intergovernmental $ 585,503 6,326,407 3,051,428 (3,274,979) 48.23% -35.10% Charges for Services 109,023 128,424 19,401 117.80% 34.47% Other Revenue 31,936 1,494 (30,442) 4.68% -78.65% Total Revenues 585,503 6,467,366 3,181,346 (3,286,020) 49.19% -34.14% Other financing sources: Transfers In - CARES Act 55 55 0.00% -83.33% Total other financing sources 55 55 0.00% -83.33% Total revenues and other financing sources 585,503 6,467,366 3,181,401 (3,285,965) 49.19% -34.14% Expenditures: Public Safety 527,713 2,626,738 1,981,300 645,438 75.43% -7.90% General Government 33,550 136,128 14,629 121,499 10.75% -72.58% Culture and Recreation 300 131,219 123,849 7,370 94.38% 11.05% CARES Act Marketing 1,055,998 1,055,985 13 100.00% 16.67% Community Development 24,240 2,418,038 1,371,774 1,046,264 56.73% -26.60% Animal Services 19,245 11,989 7,256 62.30% -21.03% Health Services 80,000 78,400 1,600 98.00% 14.67% Total Expenditures 585,803 6,467,366 4,637,926 1,829,440 71.71% -11.62% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 585,803 6,467,366 4,637,926 1,829,440 71.71% -11.62% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (300) (1,456,525) (1,456,525) Unassigned Fund Balance at Beginning of Year (150,445) Cancellation of Prior Year Encumbrances 3,680 Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 04/30/21 (1,603,290) Other Fund Balance Components: Restricted - Current Year Encumbrances 1,153,546 Restricted - Prior Year Encumbrances 32,189 Total Fund Balance $ (417,555)
16
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule CARES Act
For the period ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Intergovernmental $ 6,953,474 6,953,474 100.00% 16.67% Charges for Services 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 6,953,474 6,953,474 100.00% 16.67% Other financing sources: Transfers in 0.00% -83.33% Total other financing sources 0.00% -83.33% Total revenues and other financing sources 6,953,474 6,953,474 100.00% 16.67% Expenditures: CARES Act 4,500,699 3,398,443 1,102,256 75.51% -7.82% Total Expenditures 4,500,699 3,398,443 1,102,256 75.51% -7.82% Other Financing Uses: Transfers Out/Capital Outlay 2,452,775 3,589,622 (1,136,847) 146.35% 63.02% Total Other Financing Uses 2,452,775 3,589,622 (1,136,847) 146.35% 63.02% Total Expenditures and Other Financing Uses 6,953,474 6,988,065 (34,591) 100.50% 17.17% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (34,591) (34,591) Unassigned Fund Balance at Beginning of Year Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 04/30/21 (34,591) Other Fund Balance Components: Restricted - Current Year Encumbrances 18,025 Restricted - Prior Year Encumbrances Total Fund Balance $ (16,566)
17
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Operating Revenues: Charges for Services $ 130,313,972 130,313,972 101,145,673 (29,168,299) 77.62% -5.71% Penalties 1,106,786 1,106,786 520,363 (586,423) 47.02% -36.31% Connection Charges 280,151 280,151 24,000 (256,151) 8.57% -74.76% Miscellaneous 27,053 27,053 0.00% -83.33% Temporary Service 1,050 1,050 0.00% -83.33% Rental Income 340,239 340,239 269,349 (70,890) 79.16% -4.17% Transmission Wheeling 5,000,000 5,000,000 4,086,457 (913,543) 81.73% -1.60% Total Operating Revenues 137,041,148 137,041,148 106,073,945 (30,967,203) 77.40% -5.93% Operating Expenses: Personnel Services 27,275,535 27,275,535 23,472,131 3,803,404 86.06% 2.73% Other Services 26,731,853 26,721,853 21,709,402 5,012,451 81.24% -2.09% Supplies 57,859,830 57,861,430 41,948,584 15,912,846 72.50% -10.83% Capital Projects 5,285,000 14,344,119 7,934,385 6,409,734 55.31% -28.02% Capital Operating 1,313,400 1,321,800 702,748 619,052 53.17% -30.16% Debt Service 10,547,050 6,891,214 8,737,720 (1,846,506) 126.80% 43.47% Other Expenses 275,000 275,000 275,000 0.00% -83.33% Total Operating Expenses 129,287,668 134,690,951 104,504,970 30,185,981 77.59% -5.74% Nonoperating Revenues (Expenses): Investment Income 200,000 200,000 552,850 352,850 276.43% 193.10% Interfund Charges for Support Services 1,828,147 1,828,147 1,531,733 (296,414) 83.79% 0.46% Miscellaneous Revenue (Expense) 886,189 886,189 (675,513) (1,561,702) -76.23% -159.56% Total Nonoperating Revenue (Expenses) 2,914,336 2,914,336 1,409,070 (1,505,266) 48.35% -34.98% 10,667,816 5,264,533 2,978,045 (2,286,488) 56.57% -26.76% Capital Contributions 0.00% -83.33% Transfers Out – Utility Payments In Lieu of Taxes (13,000,000) (13,000,000) (10,356,091) (2,643,909) 79.66% -3.67% Transfers In 0.00% -83.33% Transfers Out 0.00% -83.33% Special Item - Electric Rebate (11,220,000) (11,196,981) (23,019) 99.79% 16.46% Bond Redemption - 2010 B (10,615,000) (10,615,000) 100.00% 16.67% Total Transfers and Special Items (13,000,000) (34,835,000) (32,168,072) (2,666,928) 92.34% 9.01% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (2,332,184) (29,570,467) (29,190,027) 380,440 Beginning Available Resources 82,856,511 Ending Available Resources 53,666,484 Revenue Risk 10,900,000 Capital Reserve 12,600,000 Expense Risk 12,900,000 Working Capital 30,600,000 Targeted Reserve Level 67,000,000 Total Non-Restricted Resources Available $ (13,333,516) Income (Loss) Before Transfers
Power and Light For the period ended April 30, 2021 18
Power and Light - Open Capital Projects
As
PROJECT PROJECT TITLE ORIGINAL BUDGET NET BUDGET AMENDMENTS REVISED BUDGET REQUISITIONS ENCUMBRANCES ACTUALS AVAILABLE BUDGET 200815 T&D Sys IMPROVEMENTS $ - 759,499.86 759,499.86 - 921.36 118,013.78 640,564.72 200824 Prod Plt MISC PROJECTS - 68,257.76 68,257.76 - - - 68,257.76 200828 FIBER OPTIC PROGRAM - 107,894.93 107,894.93 - 22,544.75 14,500.90 70,849.28 201106 69 KV SUBSTATION FACILITIES 300,000.00 (79,638.13) 220,361.87 - 19,228.74 82,139.32 118,993.81 201405 SUBSTATION SECURITY PROJECT - 263,489.08 263,489.08 - - 3,844.69 259,644.39 201509 NEW BILLING Sys - 22,047.36 22,047.36 - 22,475.34 - (427.98) 201510 Sys OpS / DISPATCH - 125,694.52 125,694.52 - 35,122.10 81,059.75 9,512.67 201603 69 KV Trans LINE REBUIL - 1,672,552.81 1,672,552.81 1,874,409.00 - 323,889.33 (525,745.52) 201604 Sys OpS / UPS UPGRAD - 96,538.87 96,538.87 - - 51,045.28 45,493.59 201605 Sys OpS WORK AREA - 682,232.86 682,232.86 - - 62,390.68 619,842.18 201606 NEW FINANCIAL MANAGEMENT SYS - 200,000.00 200,000.00 - - - 200,000.00 201702 Prod FACILITIES IMPROVE - 586,830.00 586,830.00 - - - 586,830.00 201703 BV GROUND WATER - 494,708.07 494,708.07 - 166,669.05 40,454.00 287,585.02 201706 SUBSTATION K SWITCHGEAR & 2,075,000.00 5,561,875.31 7,636,875.31 - 5,862,598.42 1,550,512.16 223,764.73 201707 MASTER PLAN-FUTURE GENERATIO - 32,500.00 32,500.00 - - - 32,500.00 201710 Mo CITY DIVESTITURE - 610,600.14 610,600.14 - 552,447.32 58,152.32 0.50 201804 SUBSTATION E SWITCHGEAR REPLACEMENT 1,350,000.00 1,685,460.00 3,035,460.00 - - 459,440.00 2,576,020.00 202004 Above Ground Fuel Storage Tanks - 41,800.00 41,800.00 - - - 41,800.00 202005 Blue Valley - Eckles Rd 161kV Trans - 182,588.46 182,588.46 - 218,054.36 6,139.00 (41,604.90) 202101 Substation Fiber Optic Network 125,000.00 - 125,000.00 - - - 125,000.00 202102 Traffic Controller Upgrades 60,000.00 - 60,000.00 - - 64,000.00 (4,000.00) 202103 Traffic Camera System Upgrades 50,000.00 - 50,000.00 - - 38,163.00 11,837.00 202107 Motorola APX Radio Purchase Phase 2 75,000.00 - 75,000.00 - 75,326.96 - (326.96) 202109 Substation Modeling 150,000.00 - 150,000.00 - - - 150,000.00 202110 20MVAR Capacitor Bank Sub A 800,000.00 - 800,000.00 - 135,731.65 - 664,268.35 202111 Transmission Pole Replacement Prog 150,000.00 (50,000.00) 100,000.00 50,000.00 - - 50,000.00 9669 SERVICE CTR FACILITY IMPROVE. 150,000.00 70,084.17 220,084.17 - 21,009.50 - 199,074.67 $ 5,285,000.00 13,135,016.07 18,420,016.07 1,924,409.00 7,132,129.55 2,953,744.21 6,409,733.31 Current Year Prior Year Budget Budget (Enc Roll) Total Budget 14,344,118.69 $ 4,075,897.38 18,420,016.07 Less Expenditures 1,612,608.72 1,341,135.49 2,953,744.21 Less Encumbrances 6,321,776.66 2,734,761.89 9,056,538.55 Total Available 6,409,733.31 $ - 6,409,733.31
of April 30, 2021 19
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Water
For the period ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Operating Revenues: Charges for Services $ 31,850,000 31,850,000 26,818,448 (5,031,552) 84.20% 0.87% Penalties 170,000 170,000 84,814 (85,186) 49.89% -33.44% Connection/Disconnection Charges 83,750 83,750 3,597 (80,153) 4.29% -79.04% Miscellaneous 1,000 1,000 9,214 8,214 921.40% 838.07% Returned Check Charges 10,000 10,000 12,870 2,870 128.70% 45.37% Rental Income 35,000 35,000 60,744 25,744 173.55% 90.22% Meter Repairs 250 250 (250) 0.00% -83.33% Merchandising Jobbing 8,547 8,547 0.00% -83.33% Total Operating Revenues 32,150,000 32,150,000 26,998,234 (5,151,766) 83.98% 0.65% Operating expenses: Personnel Services 8,666,805 8,666,805 6,655,392 2,011,413 76.79% -6.54% Other Services 11,365,107 12,752,157 8,683,414 4,068,743 68.09% -15.24% Supplies 2,460,040 2,460,040 2,474,706 (14,666) 100.60% 17.27% Capital Projects 4,205,000 14,302,730 2,085,146 12,217,584 14.58% -68.75% Capital Operating 882,493 895,443 704,768 190,675 78.71% -4.62% Debt Service 2,533,338 2,533,338 2,372,681 160,657 93.66% 10.33% Other Expenses 125,000 125,000 125,000 0.00% -83.33% Total Operating Expenses 30,237,783 41,735,513 22,976,107 18,759,406 55.05% -28.28% Nonoperating Revenues (Expenses): Investment Income 75,000 75,000 534,442 459,442 712.59% 629.26% Interfund Charges for Support Services 1,392,092 1,392,092 1,160,077 (232,015) 83.33% 0.00% Miscellaneous Revenue (Expense) 157,712 157,712 0.00% -83.33% Total Nonoperating Revenue (Expenses) 1,467,092 1,467,092 1,852,231 385,139 126.25% 42.92% 3,379,309 (8,118,421) 5,874,358 13,992,779 -72.36% -155.69% Transfers Out – Utility Payments In Lieu of Taxes (3,200,000) (3,200,000) (2,614,744) (585,256) 81.71% -1.62% Transfers In 0.00% -83.33% Transfers Out 0.00% -83.33% Total Transfers (3,200,000) (3,200,000) (2,614,744) (585,256) 81.71% -1.62% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 179,309 (11,318,421) 3,259,614 14,578,035 Beginning Available Resources 37,501,011 Ending Available Resources 40,760,625 Revenue Risk 3,800,000 Capital Reserve 4,300,000 Expense Risk 400,000 Working Capital 6,800,000 Targeted Reserve Level 15,300,000 Total Non-Restricted Resources Available $ 25,460,625 Income (Loss) Before Transfers
20
Water - Open Capital Projects
PROJECT PROJECT TITLE ORIGINAL BUDGET NET BUDGET AMENDMENTS REVISED BUDGET REQUISITIONS ENCUMBRANCES ACTUALS AVAILABLE BUDGET 400708 TREATMENT Plt DISCHARGE $ - 300,000.00 300,000.00 - - - 300,000.00 400904 EAST INDEPENDENCE INDUST PARK - 674,000.00 674,000.00 - - - 674,000.00 401003 FUTURE Prod WELLS - 965,326.00 965,326.00 - - - 965,326.00 401301 23RD ST MAIN REPLACEMENT - 177,230.57 177,230.57 - - - 177,230.57 401402 LAGOON CLEANOUT - 302,560.00 302,560.00 300,000.00 - - 2,560.00 401505 Dist Sys IMPROVE - 258,054.00 258,054.00 - 13,273.00 - 244,781.00 401506 TRUMAN ROAD BOOSTER STATION - 173,664.94 173,664.94 - 35,418.85 66,335.42 71,910.67 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 - 17,892.02 17,892.02 - - 7,872.02 10,020.00 401608 LIME SILO - 500,000.00 500,000.00 - 401,430.94 160,032.06 (61,463.00) 401703 Maint BUILDING AT CBP - 200,000.00 200,000.00 - - - 200,000.00 401704 VAN HORN RESERVOIR IMPROVE - 294,271.33 294,271.33 - 278,672.85 (12,217.52) 27,816.00 401801 Water Main Replacement US 40 Hwy - 29,750.00 29,750.00 - - 29,750.00401802 6" Main Replacement James Downey Rd - 250,087.60 250,087.60 - - - 250,087.60 401804 Filter Valve House Roof Improvement - 55,418.00 55,418.00 - - 33,126.00 22,292.00 401805 Fuel Site Improvements - 51,504.67 51,504.67 - - 51,504.67401808 VFD Drive Replacements HSP 2 & 4 - 915,608.00 915,608.00 - 325,120.00 359,521.00 230,967.00 401814 Main Replacement - (3,755.00) (3,755.00) - - (3,755.00)401818 30" Steel Transmission Main Assess - 175,000.00 175,000.00 - - 18,700.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 - 1,200,000.00 1,200,000.00 - - - 1,200,000.00 402004 Main Replace Walnut/Leslie/LeesSumm - 1,080,159.00 1,080,159.00 - 200,337.22 798,603.05 81,218.73 402007 Courtney Bend Emergency Generator - 150,000.00 150,000.00 - - - 150,000.00 402008 Wellfield Overhead Electrical Imp - 200,000.00 200,000.00 - - - 200,000.00 402009 Main Replace Sheley/Claremont/Norw - 200,000.00 200,000.00 - 2,242.00 8,968.00 188,790.00 402010 Main Replace Gudgell/Dodgion/KingsH 135,000.00 900,000.00 1,035,000.00 - - 26,635.00 1,008,365.00 402011 Main Replace Salisbury/Peck/Geospac 75,000.00 500,000.00 575,000.00 - - 23,100.00 551,900.00 402012 College Avenue Improvements 250,000.00 - 250,000.00 - - - 250,000.00 402101 Main Replacement Ralston 31st/29th 350,000.00 - 350,000.00 - - - 350,000.00 402102 Main Replacement 3rd St & Jennings 460,000.00 - 460,000.00 - - - 460,000.00 402103 Main Replacement Truman Road 500,000.00 - 500,000.00 - 15,830.00 - 484,170.00 402104 Lime Slaker No 5 350,000.00 - 350,000.00 - - - 350,000.00 402105 Main Replacement Sheley 100,000.00 - 100,000.00 - - - 100,000.00 402106 Main Replacement Sheley & Northern 1,035,000.00 - 1,035,000.00 - - - 1,035,000.00 402107 Facility Improvements/Const/Maint 250,000.00 - 250,000.00 - - - 250,000.00 402108 Basin Drive Improvements 250,000.00 - 250,000.00 - - - 250,000.00 9749 MAIN REPLACEMENT PROGRAM 200,000.00 597,662.19 797,662.19 - - 3,755.00 793,907.19 9952 SECURITY UPGRADES 250,000.00 61,305.72 311,305.72 - - 43,714.90 267,590.82 $ 4,205,000.00 11,207,054.52 15,412,054.52 300,000.00 1,272,324.86 1,615,644.60 12,224,085.06 Work Order Charged Against Capital Project Budget (6,500.00) Budgetary Reports 12,217,585.06 $ Current Year Prior Year Budget Budget (Enc Roll) Total Budget 14,302,730.26 $ 1,109,324.26 15,412,054.52 Less Expenditures 898,030.44 719,413.84 1,617,444.28 Less Encumbrances 1,187,114.76 389,910.42 1,577,025.18 Total Available 12,217,585.06 $ - 12,217,585.06
21
As of April 30, 2021
CITY OF INDEPENDENCE, MISSOURI
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Operating revenues: Charges for Services $ 33,393,893 33,393,893 29,509,801 (3,884,092) 88.37% 5.04% Penalties 200,000 200,000 126,334 (73,666) 63.17% -20.16% Total operating revenues 33,593,893 33,593,893 29,636,135 (3,957,758) 88.22% 4.89% Operating expenses: Personnel Services 5,868,295 5,878,295 4,526,303 1,351,992 77.00% -6.33% Other Services 13,075,398 13,065,398 9,096,779 3,968,619 69.62% -13.71% Supplies 661,840 661,840 358,413 303,427 54.15% -29.18% Capital Projects 5,330,000 12,787,378 1,207,363 11,580,015 9.44% -73.89% Capital Operating 926,000 926,000 792,269 133,731 85.56% 2.23% Debt Service 6,290,632 6,290,632 5,597,114 693,518 88.98% 5.65% Other Expenses 30,000 30,000 30,000 0.00% -83.33% Total Operating Expenses 32,182,165 39,639,543 21,578,241 18,061,302 54.44% -28.89% Nonoperating Revenues (Expenses): Investment Income 51,000 51,000 229,191 178,191 449.39% 366.06% Miscellaneous Revenue (Expense) (34,876) (34,876) 0.00% -83.33% Total Nonoperating Revenue (Expenses) 51,000 51,000 194,315 143,315 381.01% 297.68% 1,462,728 (5,994,650) 8,252,209 14,246,859 -137.66% -220.99% Transfers Out – Utility Payments In Lieu of Taxes (3,596,612) (3,596,612) (2,938,767) (657,845) 81.71% -1.62% Transfers In 10,000 10,000 10,000 100.00% 16.67% Transfers Out 0.00% -83.33% Total Transfers (3,586,612) (3,586,612) (2,928,767) (657,845) 81.66% -1.67% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (2,123,884) (9,581,262) 5,323,442 14,904,704 Beginning Available Resources 22,638,784 Ending Available Resources 27,962,226 Revenue Risk 2,750,000 Capital Reserve 6,000,000 Expense Risk 400,000 Working Capital 7,400,000 Targeted Reserve Level 16,550,000 Total Non-Restricted Resources Available $ 11,412,226 Income (Loss) Before Transfers
Budgetary Comparison Schedule Sanitary Sewer For the period ended April 30, 2021 22
As of April 30, 2021
PROJECT PROJECT TITLE ORIGINAL BUDGET NET BUDGET AMENDMENTS REVISED BUDGET REQUISITIONS ENCUMBRANCES ACTUALS AVAILABLE BUDGET 300801 NEIGHBORHOOD PROJECTS $ - 594,219.81 594,219.81 - 576,341.39 17,878.42301108 HOLDING BASINS AND PMP STATION - 694,045.55 694,045.55 - - - 694,045.55 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 301502 NEW Util BILLING Sys - 16,942.28 16,942.28 - 11,237.82 - 5,704.46 301505 SEWAGE SLUDGE INCINERATOR IMP - 641,818.97 641,818.97 - 1,288.97 35,995.00 604,535.00 301603 RCTP FACILITIES ROOF, CEILING - 170,925.00 170,925.00 - 3,361.00 - 167,564.00 301604 PRIMARY SLUDGE GRINDERS & - 6,989.69 6,989.69 - - - 6,989.69 301701 SCADA UPGRADE - 1,021,934.00 1,021,934.00 - 88,691.00 - 933,243.00 301703 ARROWHEAD CENTER - 826,630.11 826,630.11 - 680,964.93 11,526.91 134,138.27 301705 16TH/SCOTT - 359,023.24 359,023.24 - 5,390.10 415.78 353,217.36 301706 TREATMENT FACILITY IMPROVEMENT - 593,007.00 593,007.00 - - - 593,007.00 301707 NEIGHBORHOOD IMPROVE 17-18 - 289,132.61 289,132.61 - 14,865.35 206,482.37 67,784.89 301804 ROCK CREEK EFFLUENT STRUCTURE - 375,000.00 375,000.00 - 49,979.50 - 325,020.50 301806 Neighborhood Improvements 2018-19 - 470,248.18 470,248.18 - 14,398.81 20,620.50 435,228.87 302001 Fairmount Highlands - 170,000.00 170,000.00 - - - 170,000.00 302002 Arlington Improvements - 100,000.00 100,000.00 - - - 100,000.00 302003 Bison Park 200,000.00 233,963.86 433,963.86 - 13,218.36 8,628.28 412,117.22 302004 Neighborhood Projects 2019-20 430,000.00 150,000.00 580,000.00 - - - 580,000.00 302005 Biosolids Handling 3,000,000.00 2,000,000.00 5,000,000.00 - 2,541,006.58 1,567,236.42 891,757.00 302006 Raw Pumps & Screening - 900,000.00 900,000.00 - - - 900,000.00 302007 Electrical Substation Rehab - 186,259.00 186,259.00 - - 27,569.00 158,690.00 302008 RCTP Fence 250,000.00 200,000.00 450,000.00 - - - 450,000.00 302009 Truman & Harris - 50,000.00 50,000.00 - - - 50,000.00 302101 Sanitation Sewer Evaluation Survey 250,000.00 - 250,000.00 - 114,155.15 11,400.00 124,444.85 302102 Raymond Harkless Mills San Imp 200,000.00 - 200,000.00 - - - 200,000.00 302103 Pump Station Imp & Maintenance 200,000.00 - 200,000.00 - - - 200,000.00 302104 Polymer System Relocation 100,000.00 - 100,000.00 - - - 100,000.00 302105 Piping Rehabilitation 200,000.00 - 200,000.00 - 19,947.50 - 180,052.50 9757 TRENCHLESS TECHNOLOGY 500,000.00 1,321,680.92 1,821,680.92 - 558,251.85 85,444.71 1,177,984.36 $ 5,330,000.00 12,936,310.96 18,266,310.96 - 4,693,098.31 1,993,197.39 11,580,015.26 Current Year Prior Year Budget Budget (Enc Roll) Total Budget 12,787,377.72 $ 5,478,933.24 18,266,310.96 Less Expenditures 250,405.45 1,742,791.94 1,993,197.39 Less Encumbrances 956,957.01 3,736,141.30 4,693,098.31 Total Available 11,580,015.26 $ - 11,580,015.26
Sanitary Sewer - Open Capital Projects
23
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Events Center Debt Service For the period ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Operating revenues: Charges for Services $ 0.00% -83.33% Miscellaneous 0.00% -83.33% Total operating revenues 0.00% -83.33% Operating Expenses: Personnel Services 0.00% -83.33% Other Services 55,529 (55,529) 0.00% -83.33% Supplies 0.00% -83.33% Capital Outlay 75,000 1,478,361 140,244 1,338,117 9.49% -73.84% Debt Service 5,173,844 5,173,844 4,559,375 614,469 88.12% 4.79% Other Expenses 0.00% -83.33% Total Operating Expenses 5,248,844 6,652,205 4,755,148 1,897,057 71.48% -11.85% Nonoperating Revenues (Expenses): Investment Income 35,093 35,093 0.00% -83.33% Miscellaneous Revenue (Expense) 0.00% -83.33% Sales Tax 5,173,844 5,173,844 4,416,102 (757,742) 85.35% 2.02% Total Nonoperating Revenue (Expenses) 5,173,844 5,173,844 4,451,195 (722,649) 0.00% -83.33% (75,000) (1,478,361) (303,953) 1,174,408 20.56% -62.77% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -83.33% Transfers In 75,000 75,000 75,000 0.00% -83.33% Transfers Out 0.00% -83.33% Total Transfers 75,000 75,000 75,000 0.00% -83.33% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (1,403,361) (303,953) 1,099,408 Unassigned Fund Balance at Beginning of Year (24,424,459) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year (245,245) Ending Unassigned Fund Balance, 04/30/21 (24,973,657) Restricted: Bond Reserve Project Accounts 6,814,304 Total restricted 6,814,304 Committed: Capital Projects In Process 1,338,117 Total Committed 1,338,117 Assigned: Prior Year Open Encumbrances - Excluding Capital Projects Current Year Open Encumbrances - Excluding Capital Projects Total Assigned Total Fund Balance $ (16,821,236) Income (Loss) Before Transfers
24
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
For the period ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Operating revenues: Charges for Services $ 2,088,731 2,088,731 1,347,031 (741,700) 64.49% -18.84% Miscellaneous 4,750 4,750 0.00% -83.33% Total Operating Revenues 2,088,731 2,088,731 1,351,781 (736,950) 64.72% -18.61% Operating Expenses: Personnel Services 754,502 754,502 585,816 168,686 77.64% -5.69% Other Services 550,811 547,411 478,545 68,866 87.42% 4.09% Supplies 768,986 772,386 521,883 250,503 67.57% -15.76% Capital Outlay 25,375 25,375 16,972 8,403 66.88% -16.45% Other Expenses 0.00% -83.33% Total Operating Expenses 2,099,674 2,099,674 1,603,216 496,458 76.36% -6.97% Nonoperating Revenues (Expenses): Investment Income 300 300 7,963 7,663 2654.33% 2571.00% Miscellaneous Revenue (Expense) 5,166 5,166 0.00% -83.33% Total Nonoperating Revenue (Expenses) 300 300 13,129 12,829 4376.33% 4293.00% (10,643) (10,643) (238,306) (227,663) 2239.09% 2155.76% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -83.33% Transfers In 0.00% -83.33% Transfers Out 0.00% -83.33% Total Transfers 0.00% -83.33% Change In Net Position (Budget Basis) $ (10,643) (10,643) (238,306) (227,663) Unassigned Fund Balance at Beginning of Year (1,211,182) Cancellation of Prior Year Encumbrances 13,000 Change in Other Fund Balance Components During the Year (100,393) Year-end investment market value adjustment Ending Unassigned Fund Balance GAAP Basis, 04/30/21 (1,536,881) Other Net Position Components: Assigned - Current Year Encumbrances 207,714 Assigned - Prior Year Encumbrances 20,096 Total Fund Balance $ (1,309,071) Income (Loss) Before Transfers
Central Garage
25
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Staywell Health Care
For the period ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Operating revenues: Charges for Services $ 14,532,190 14,532,190 14,941,314 409,124 102.82% 19.49% Miscellaneous 0.00% -83.33% Total Operating Revenues 14,532,190 14,532,190 14,941,314 409,124 102.82% 19.49% Operating Expenses: Personnel Services 165,840 (165,840) 0.00% -83.33% Other Services 14,532,190 14,532,190 18,658,680 (4,126,490) 128.40% 45.07% Supplies 128 (128) 0.00% -83.33% Capital Outlay 0.00% -83.33% Other Expenses 0.00% -83.33% Total Operating Expenses 14,532,190 14,532,190 18,824,648 (4,292,458) 129.54% 46.21% Nonoperating Revenues (Expenses): Investment Income 4,274 4,274 0.00% -83.33% Miscellaneous Revenue (Expense) 1,145,659 1,145,659 0.00% -83.33% Total Nonoperating Revenue (Expenses) 1,149,933 1,149,933 0.00% -83.33% (2,733,401) (2,733,401) 0.00% -83.33% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -83.33% Transfers In 0.00% -83.33% Transfers Out 0.00% -83.33% Total Transfers 0.00% -83.33% Change In Net Position (Budget Basis) $ (2,733,401) (2,733,401) Unassigned Fund Balance at Beginning of Year 3,312,003 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year 384,120 Ending Unassigned Fund Balance GAAP Basis, 04/30/21 962,722 Other Net Position Components: Assigned - Current Year Encumbrances 20,000 Assigned - Prior Year Encumbrances Total Fund Balance $ 982,722 Income (Loss) Before Transfers
26
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Workers' Compensation
For the period ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Operating revenues: Charges for Services $ 3,558,840 3,558,840 2,965,700 (593,140) 83.33% 0.00% Miscellaneous 1,102 1,102 0.00% -83.33% Total Operating Revenues 3,558,840 3,558,840 2,966,802 (592,038) 83.36% 0.03% Operating Expenses: Personnel Services 21,000 21,000 11,111 9,889 52.91% -30.42% Other Services 4,500,000 4,500,000 2,325,100 2,174,900 51.67% -31.66% Supplies 4,000 4,000 4,000 0.00% -83.33% Capital Outlay 2,000 2,000 2,000 0.00% -83.33% Other Expenses 0.00% -83.33% Total Operating Expenses 4,527,000 4,527,000 2,336,211 2,190,789 51.61% -31.72% Nonoperating Revenues (Expenses): Investment Income 12,000 12,000 1,236 (10,764) 10.30% -73.03% Miscellaneous Revenue (Expense) 38,524 38,524 0.00% -83.33% Total Nonoperating Revenue (Expenses) 12,000 12,000 39,760 27,760 331.33% 248.00% (956,160) (956,160) 670,351 1,626,511 -70.11% -153.44% Transfers In 0.00% -83.33% Transfers Out 0.00% -83.33% Total Transfers 0.00% -83.33% Change In Net Position (Budget Basis) $ (956,160) (956,160) 670,351 1,626,511 Unassigned Fund Balance at Beginning of Year (8,552,971) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year (589,277) Year-end investment market value adjustment Ending Unassigned Fund Balance GAAP Basis, 04/30/21 (8,471,897) Other Net Position Components: Restricted - Work Comp Escrow Assigned - Current Year Encumbrances 24,225 Assigned - Prior Year Encumbrances 10,675 Total Fund Balance $ (8,436,997) Income (Loss) Before Transfers
27
CITY OF
MISSOURI Budgetary Comparison Schedule Risk Management
INDEPENDENCE,
For the period ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Operating revenues: Charges for Services $ 2,991,000 2,991,000 2,492,500 (498,500) 83.33% 0.00% Miscellaneous 0.00% -83.33% Total Operating Revenues 2,991,000 2,991,000 2,492,500 (498,500) 83.33% 0.00% Operating Expenses: Personnel Services 15,000 15,000 11,111 3,889 74.07% -9.26% Other Services 2,988,000 2,988,000 2,140,387 847,613 71.63% -11.70% Supplies 3,000 3,000 328 2,672 10.93% -72.40% Capital Outlay 0.00% -83.33% Other Expenses 0.00% -83.33% Total Operating Expenses 3,006,000 3,006,000 2,151,826 854,174 71.58% -11.75% Nonoperating Revenues (Expenses): Investment Income 10,288 10,288 0.00% -83.33% Miscellaneous Revenue (Expense) 13 13 0.00% -83.33% Total Nonoperating Revenue (Expenses) 10,301 10,301 0.00% -83.33% (15,000) (15,000) 350,975 365,975 -2339.83% -2423.16% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -83.33% Transfers In 0.00% -83.33% Transfers Out 0.00% -83.33% Total Transfers 0.00% -83.33% Change In Net Position (Budget Basis) $ (15,000) (15,000) 350,975 365,975 Unassigned Fund Balance at Beginning of Year 573,283 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance GAAP Basis, 04/30/21 924,258 Other Net Position Components: Assigned - Current Year Encumbrances 24,920 Assigned - Prior Year Encumbrances 732 Total Fund Balance $ 949,910 Income (Loss) Before Transfers
28
CITY OF
INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Operating revenues: Charges for Services $ 1,430,000 1,430,000 1,191,667 (238,333) 83.33% 0.00% Miscellaneous 0.00% -83.33% Total Operating Revenues 1,430,000 1,430,000 1,191,667 (238,333) 83.33% 0.00% Operating Expenses: Personnel Services 430,000 430,000 454,828 (24,828) 105.77% 22.44% Other Services 999,561 999,561 942,996 56,565 94.34% 11.01% Supplies 0.00% -83.33% Capital Outlay 4,596,317 (4,596,317) 0.00% -83.33% Other Expenses 0.00% -83.33% Total Operating Expenses 1,429,561 1,429,561 5,994,141 (4,564,580) 419.30% 335.97% Nonoperating Revenues (Expenses): Investment Income 200 200 (200) 0.00% -83.33% Miscellaneous Revenue (Expense) 0.00% -83.33% Total Nonoperating Revenue (Expenses) 200 200 (200) 0.00% -83.33% 639 639 (4,802,474) (4,803,113) -751560.88% -751644.21% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -83.33% Transfers In – CARES Act 2,775,613 (2,775,613) 0.00% -83.33% Transfers Out 0.00% -83.33% Total Transfers 2,775,613 (2,775,613) 0.00% -83.33% Change In Net Position (Budget Basis) $ 639 639 (2,026,861) (2,027,500) Unassigned Fund Balance at Beginning of Year (990,064) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance GAAP Basis, 04/30/21 (3,016,925) Other Net Position Components: Assigned - Current Year Encumbrances 39,607 Assigned - Prior Year Encumbrances 97,660 Total Fund Balance $ (2,879,658) Income (Loss) Before Transfers
Planning
Enterprise Resource
29
For the period ended April 30, 2021
CITY OF INDEPENDENCE, MISSOURI Budgetary
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Charges for Services $ 9,289 9,289 0.00% -83.33% Investment Income (Loss) 500 500 194 (306) 38.80% -44.53% Other Revenue 0.00% -83.33% Total Revenues 500 500 9,483 8,983 1896.60% 1813.27% Expenditures: General Government 93 (93) 0.00% -83.33% Debt Service 9,998 9,998 9,289 709 92.91% 9.58% Total Expenditures 9,998 9,998 9,382 616 93.84% 10.51% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total expenditures and other financing uses 9,998 9,998 9,382 616 93.84% 10.51% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (9,498) (9,498) 101 9,599 Unassigned Fund Balance at Beginning of Year 103,247 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 04/30/21 103,348 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 103,348
Comparison Schedule Debt Service - Neighborhood Improvement Districts For the period ended April 30, 2021 30
CITY
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Charges for Services $ 9,645 9,645 0.00% -83.33% Investment Income 2,014 2,014 0.00% -83.33% Intergovernmental 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 11,659 11,659 0.00% -83.33% Other Financing Sources: Transfers In 0.00% -83.33% Total Other Financing Sources 0.00% -83.33% Total Revenues and Other Financing Sources 11,659 11,659 0.00% -83.33% Expenditures: Public Works 0.00% -83.33% Culture and Recreation 0.00% -83.33% Capital Outlay 338,651 225,864 112,787 66.70% -16.63% Total Expenditures 338,651 225,864 112,787 66.70% -16.63% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 338,651 225,864 112,787 66.70% -16.63% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (338,651) (214,205) 124,446 Unassigned Fund Balance at Beginning of Year (51,591) Cancellation of Prior Year Encumbrances 24,286 Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 04/30/21 (241,510) Other Fund Balance Components: Committed - Current Year Encumbrances 199,252 Committed - Prior Year Encumbrances 14,615 Total Fund Balance $ (27,643)
Budgetary Comparison Schedule
the
31
OF INDEPENDENCE, MISSOURI Street Improvements Capital Project Fund For
period ended April 30, 2021
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Revolving Public Improvements Capital Project Fund For the period ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Charges for Services $ 0.00% -83.33% Investment Income (Loss) 312 312 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 312 312 0.00% -83.33% Expenditures: Public Works 0.00% -83.33% Culture and Recreation 0.00% -83.33% Capital Outlay 0.00% -83.33% Total Expenditures 0.00% -83.33% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 312 312 Unassigned Fund Balance at Beginning of Year 21,577 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 04/30/21 21,889 Other Fund Balance Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances Total Fund Balance $ 21,889
32
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
and
For
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Charges for Services $ 0.00% -83.33% Investment Income 21 21 0.00% -83.33% Other Revenue 5,289 5,289 0.00% -83.33% Total revenues 5,310 5,310 0.00% -83.33% Other Financing Sources: Transfers In 418,452 418,452 0.00% -83.33% Total Other Financing Sources 418,452 418,452 0.00% -83.33% Total Revenues and Other Financing Sources 423,762 423,762 0.00% -83.33% Expenditures: Public Works 0.00% -83.33% Culture and Recreation 0.00% -83.33% Capital Outlay 1,443,621 869,870 573,751 60.26% -23.07% Total Expenditures 1,443,621 869,870 573,751 0.00% -83.33% Other Financing Uses: Transfers Out/Capital Outlay 420,024 (420,024) 0.00% -83.33% Total Other Financing Uses 420,024 (420,024) 0.00% -83.33% Total expenditures and other financing uses 1,443,621 1,289,894 153,727 89.35% 6.02% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (1,443,621) (866,132) 577,489 Unassigned Fund Balance at Beginning of Year (83,551) Cancellation of Prior Year Encumbrances 9,104 Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 04/30/21 (940,579) Other Fund Balance Components: Committed - Current Year Encumbrances 842,427 Committed - Prior Year Encumbrances 69,980 Total Fund Balance $ (28,172)
Buildings
Other Improvements Capital Project Fund
the period ended April 30, 2021 33
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Charges for Services $ 0.00% -83.33% Investment Income 0.00% -83.33% Other Revenue 0.00% -83.33% Total revenues 0.00% -83.33% Expenditures: Public Works 0.00% -83.33% Culture and Recreation 0.00% -83.33% Capital Outlay 0.00% -83.33% Total Expenditures 0.00% -83.33% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total expenditures and other financing uses 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ Unassigned Fund Balance at Beginning of Year (16,155) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 04/30/21 (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 April 30, 2021 34
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Park Improvements Capital Project Fund For the period ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Charges for Services $ 0.00% -83.33% Investment Income (Loss) 467 467 0.00% -83.33% Other Revenue 0.00% -83.33% Total revenues 467 467 0.00% -83.33% Expenditures: Public Works 0.00% -83.33% Culture and Recreation 0.00% -83.33% Capital Outlay 0.00% -83.33% Total Expenditures 0.00% -83.33% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total expenditures and other financing uses 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 467 467 Unassigned Fund Balance at Beginning of Year 31,426 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 04/30/21 31,893 Fund Balance Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances Total Fund Balance $ 31,893
35
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Charges for Services $ 16,600 16,600 (16,600) 0.00% -83.33% Investment Income 193 193 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 16,600 16,600 193 (16,407) 1.16% -82.17% Expenditures: Public Works 0.00% -83.33% Culture and Recreation 18,209 18,209 7,594 10,615 41.70% -41.63% Capital Outlay 0.00% -83.33% Total Expenditures 18,209 18,209 7,594 10,615 41.70% -41.63% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 18,209 18,209 7,594 10,615 41.70% -41.63% Excess of revenues over (under) expenditures and Other Financing Uses, Budget Basis $ (1,609) (1,609) (7,401) (5,792) Unassigned Net Position at Beginning of Year 9,495 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Unassigned Net Position, 04/30/21 2,094 Other Net Position Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances Total Net Position $ 2,094
Comparison Schedule Private Purpose Expendable Trust Fund - Vaile Mansion For the period ended April 30, 2021 36
CITY OF INDEPENDENCE, MISSOURI Budgetary
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Independence Events Center CID For the period ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Sales Taxes $ 7,700,767 7,700,767 5,874,293 (1,826,474) 76.28% -7.05% Investment Income 128,715 128,715 14,656 (114,059) 11.39% -71.94% Total Revenues 7,829,482 7,829,482 5,888,949 (1,940,533) 75.22% -8.11% Expenditures: Administrative Fee 154,015 154,015 117,486 36,529 76.28% -7.05% Insurance 2,150 2,150 2,150 0.00% -83.33% Legal 44,850 44,850 44,850 0.00% -83.33% Audit 5,150 5,150 5,150 100.00% 16.67% Banking 5,916 5,916 6,010 (94) 101.59% 18.26% Contract Services 310,500 310,500 300,000 10,500 96.62% 13.29% Capital Outlay 0.00% -83.33% Other 0.00% -83.33% Total Expenditures 522,581 522,581 428,646 93,935 82.02% -1.31% Other Financing Uses: Transfers Out - EATS (75,000) (75,000) (587,180) 512,180 782.91% 699.58% Transfers Out - Debt Service (City) (5,173,844) (5,173,844) (3,828,922) (1,344,922) 74.01% -9.32% Total Other Financing Uses (5,248,844) (5,248,844) (4,416,102) (832,742) 84.13% 0.80% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 2,058,057 2,058,057 1,044,201 (1,013,856) Unassigned Fund Balance at Beginning of Year 7,010,144 Cancellation of Prior Year Encumbrances 30,725 Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 04/30/21 8,085,070 Other Fund Balance Components: Restricted - current year encumbrances Restricted - prior year encumbrances Total Fund Balance $ 8,085,070
37
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Sales taxes $ 377,711 377,711 0.00% -83.33% Investment income 205 205 0.00% -83.33% Total revenues 377,916 377,916 0.00% -83.33% Expenditures: Administrative fee 7,554 (7,554) 0.00% -83.33% Insurance 2,000 2,000 2,132 (132) 106.60% 23.27% Legal 1,250 (1,250) 0.00% -83.33% Audit 4,700 4,700 5,150 (450) 109.57% 26.24% Banking 311 (311) 0.00% -83.33% Contract services 0.00% -83.33% Capital outlay 0.00% -83.33% Other 0.00% -83.33% Total expenditures 6,700 6,700 16,397 (9,697) 244.73% 161.40% Other financing uses: Transfers out - EATS (248,491) (248,491) (188,855) (59,636) 76.00% -7.33% Transfers out - Debt Service (City) (215,000) (215,000) (191,000) (24,000) 88.84% 5.51% Total other financing uses (463,491) (463,491) (379,855) (83,636) 81.96% -1.37% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (470,191) (470,191) (18,336) 451,855 Unassigned Fund Balance at Beginning of Year 82,217 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year (471) Unassigned Ending Fund Balance, 04/30/21 63,410 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - City Transportation 6,259 Total Fund Balance $ 69,669
Crackerneck Creek TDD For the period ended April 30, 2021 38
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Tax Increment Financing Summary For the Period Ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 16,228,916 16,228,916 17,443,315 1,214,399 107.48% 24.15% Investment Income (Loss) 325,244 325,244 0.00% -83.33% Other revenue 1,310,958 1,310,958 1,163,976 (146,982) 88.79% 5.46% Total Revenues 17,539,874 17,539,874 18,932,535 1,392,661 107.94% 24.61% Other Financing Sources: Transfers In 1,327,471 1,327,471 1,007,205 (320,266) 75.87% -7.46% Total Other Financing Sources 1,327,471 1,327,471 1,007,205 (320,266) 75.87% -7.46% Total Revenues and Other Financing Sources 18,867,345 18,867,345 19,939,740 1,072,395 105.68% 22.35% Expenditures: Tax Increment Financing 1,792,897 1,792,897 2,307,250 (514,353) 128.69% 45.36% Debt Service Principal 9,594,866 10,081,215 7,940,808 2,140,407 78.77% -4.56% Interest and Fiscal Agent Fees 5,587,948 5,587,948 6,610,600 (1,022,652) 118.30% 34.97% Debt Issuance Costs 0.00% -83.33% Total Expenditures 16,975,711 17,462,060 16,858,658 603,402 96.54% 13.21% Other Financing Uses: Issuance of Debt 0.00% -83.33% Reoffering Premium/Original Issue Discount 0.00% -83.33% Payment to Refund Loans Escrow Agent 0.00% -83.33% Transfers Out 587,181 (587,181) 0.00% -83.33% Total Other Financing Uses 587,181 (587,181) 0.00% -83.33% Total Expenditures and Other Financing Uses 16,975,711 17,462,060 17,445,839 16,221 99.91% 16.58% Excess of Revenues Over (Under) Expenditures and other financing uses $ 1,891,634 1,405,285 2,493,901 1,088,616 Unassigned Fund Balance at Beginning of Year 18,749,314 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Unassigned Ending Fund Balance, 04/30/21 21,243,215 Other Fund Balance Components: Restricted - Current Year Encumbrances 2,500 Restricted - Prior Year Encumbrances 15,226 Restricted - Trust Debt Service 12,333,319 Total Fund Balance $ 33,594,260
39
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 0.00% -83.33% Investment Income (Loss) 23 23 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 23 23 0.00% -83.33% Expenditures: Tax Increment Financing 0.00% -83.33% Debt Service Principal 0.00% -83.33% Interest and Fiscal Agent Fees 0.00% -83.33% Debt Issuance Costs 0.00% -83.33% Total Expenditures 0.00% -83.33% Other Financing Uses: Issuance of Debt 0.00% -83.33% Reoffering Premium/Original Issue Discount 0.00% -83.33% Payment to Refund Loans Escrow Agent 0.00% -83.33% Transfers Out 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 23 23 Unassigned Fund Balance at Beginning of Year 1,572 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Unassigned Ending Fund Balance, 04/30/21 1,595 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 1,595
Truman Rd TIF
the Period Ended April 30, 2021 40
Schedule Mid-Town
For
the Period Ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 257,999 257,999 (1,622) (259,621) -0.63% -83.96% Investment Income (Loss) 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 257,999 257,999 (1,622) (259,621) -0.63% -83.96% Expenditures: Tax Increment Financing 3,822 3,822 3,822 0.00% -83.33% Debt Service Principal 50,950 50,950 50,950 0.00% -83.33% Interest and Fiscal Agent Fees 203,227 203,227 14,100 189,127 6.94% -76.39% Debt Issuance Costs 0.00% -83.33% Total Expenditures 257,999 257,999 14,100 243,899 5.47% -77.86% Other Financing Uses: Issuance of Debt 0.00% -83.33% Reoffering Premium/Original Issue Discount 0.00% -83.33% Payment to Refund Loans Escrow Agent 0.00% -83.33% Transfers Out 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 257,999 257,999 14,100 243,899 5.47% -77.86% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (15,722) (15,722) Unassigned Fund Balance at Beginning of Year 15,722 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 04/30/21 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $
41
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule RSO TIF For
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 26,271 26,271 29,428 3,157 112.02% 28.69% Investment Income (Loss) (23) (23) 0.00% -83.33% Other Revenue 102,958 102,958 71,966 (30,992) 69.90% -13.43% Total Revenues 129,229 129,229 101,371 (27,858) 78.44% -4.89% Other Financing Sources: Transfers In 187,942 187,942 (187,942) 0.00% -83.33% Total Other Financing Sources 187,942 187,942 (187,942) 0.00% -83.33% Total Revenues and Other Financing Sources 317,171 317,171 101,371 (215,800) 31.96% -51.37% Expenditures: Tax Increment Financing 7,801 7,801 7,898 (97) 101.24% 17.91% Debt Service Principal 190,000 190,000 190,000 100.00% 16.67% Interest and Fiscal Agent Fees 339,938 339,938 334,237 5,701 98.32% 14.99% Debt Issuance Costs 0.00% -83.33% Total Expenditures 537,739 537,739 532,135 5,604 98.96% 15.63% Other Financing Uses: Issuance of Debt 0.00% -83.33% Reoffering Premium/Original Issue Discount 0.00% -83.33% Payment to Refund Loans Escrow Agent 0.00% -83.33% Transfers Out 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 537,739 537,739 532,135 5,604 98.96% 15.63% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (220,568) (220,568) (430,764) (210,196) Unassigned Fund Balance at Beginning of Year (1,206,894) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 04/30/21 (1,637,658) Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 557,834 Total Fund Balance $ (1,079,824)
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Santa Fe TIF For the Period Ended April 30, 2021 42
CITY
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Hartman Heritage TIF
For the Period Ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 1,446,920 1,446,920 1,361,091 (85,829) 94.07% 10.74% Investment Income (Loss) 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 1,446,920 1,446,920 1,361,091 (85,829) 94.07% 10.74% Other Financing Sources: Transfers In 118,097 118,097 55,516 (62,581) 47.01% -36.32% Total Other Financing Sources 118,097 118,097 55,516 (62,581) 47.01% -36.32% Total Revenues and Other Financing Sources 1,565,017 1,565,017 1,416,607 (148,410) 90.52% 7.19% Expenditures: Tax Increment Financing 121,261 121,261 29,330 91,931 24.19% -59.14% Debt Service Principal 1,630,000 1,630,000 1,815,000 (185,000) 111.35% 28.02% Interest and Fiscal Agent Fees 140,068 140,068 74,869 65,199 53.45% -29.88% Debt Issuance Costs 0.00% -83.33% Total Expenditures 1,891,329 1,891,329 1,919,199 (27,870) 101.47% 18.14% Other Financing Uses: Issuance of Debt 0.00% -83.33% Reoffering Premium/Original Issue Discount 0.00% -83.33% Payment to Refund Loans Escrow Agent 0.00% -83.33% Transfers Out 55,516 (55,516) 0.00% -83.33% Total Other Financing Uses 55,516 (55,516) 0.00% -83.33% Total Expenditures and Other Financing Uses 1,891,329 1,891,329 1,974,715 (83,386) 104.41% 21.08% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (326,312) (326,312) (558,108) (231,796) Unassigned Fund Balance at Beginning of Year (2,498,194) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 04/30/21 (3,056,302) Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ (3,056,302)
43
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 568,730 568,730 614,891 46,161 108.12% 24.79% Investment Income (Loss) 26,758 26,758 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 568,730 568,730 641,649 72,919 112.82% 29.49% Expenditures: Tax Increment Financing 15,338 15,338 15,463 (125) 100.81% 17.48% Debt Service Principal 385,000 385,000 405,000 (20,000) 105.19% 21.86% Interest and Fiscal Agent Fees 36,150 36,150 24,600 11,550 68.05% -15.28% Debt Issuance Costs 0.00% -83.33% Total Expenditures 436,488 436,488 445,063 (8,575) 101.96% 18.63% Other Financing Uses: Issuance of Debt 0.00% -83.33% Reoffering Premium/Original Issue Discount 0.00% -83.33% Payment to Refund Loans Escrow Agent 0.00% -83.33% Transfers Out 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 436,488 436,488 445,063 (8,575) 101.96% 18.63% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 132,242 132,242 196,586 64,344 Unassigned Fund Balance at Beginning of Year 1,841,662 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Unassigned Ending Fund Balance, 04/30/21 2,038,248 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 2,038,248
OF INDEPENDENCE,
Budgetary Comparison Schedule Drumm Farm TIF For the Period Ended April 30, 2021 44
CITY
MISSOURI
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Eastland TIF
For the Period Ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 5,053,492 5,053,492 5,181,178 127,686 102.53% 19.20% Investment Income (Loss) 178,582 178,582 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 5,053,492 5,053,492 5,359,760 306,268 106.06% 22.73% Other Financing Sources: Transfers In 664,783 664,783 927,666 262,883 139.54% 56.21% Total Other Financing Sources 664,783 664,783 927,666 262,883 139.54% 56.21% Total Revenues and Other Financing Sources 5,718,275 5,718,275 6,287,426 569,151 109.95% 26.62% Expenditures: Tax Increment Financing 457,612 457,612 367,230 90,382 80.25% -3.08% Debt Service Principal 2,870,000 2,870,000 3,005,000 (135,000) 104.70% 21.37% Interest and Fiscal Agent Fees 115 115 291,650 (291,535) 253608.70% 253525.37% Debt Issuance Costs 0.00% -83.33% Total Expenditures 3,327,727 3,327,727 3,663,880 (336,153) 110.10% 26.77% Other Financing Uses: Issuance of Debt 0.00% -83.33% Reoffering Premium/Original Issue Discount 0.00% -83.33% Payment to Refund Loans Escrow Agent 0.00% -83.33% Transfers Out 507,642 (507,642) 0.00% -83.33% Total Other Financing Uses 507,642 (507,642) 0.00% -83.33% Total Expenditures and Other Financing Uses 3,327,727 3,327,727 4,171,522 (843,795) 125.36% 42.03% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 2,390,548 2,390,548 2,115,904 (274,644) Unassigned Fund Balance at Beginning of Year 12,292,653 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Unassigned Ending Fund Balance, 04/30/21 14,408,557 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 897,693 Total Fund Balance $ 15,306,250
45
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
North Independence TIF
For the Period Ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 57,965 57,965 43,788 (14,177) 75.54% -7.79% Investment Income (Loss) 460 460 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 57,965 57,965 44,248 (13,717) 76.34% -6.99% Expenditures: Tax Increment Financing 1,645 1,645 1,431 214 86.99% 3.66% Debt Service Principal 10,000 10,000 2,815 7,185 28.15% -55.18% Interest and Fiscal Agent Fees 45,530 45,530 64,985 (19,455) 142.73% 59.40% Debt Issuance Costs 0.00% -83.33% Total Expenditures 57,175 57,175 69,231 (12,056) 121.09% 37.76% Other Financing Uses: Issuance of Debt 0.00% -83.33% Reoffering Premium/Original Issue Discount 0.00% -83.33% Payment to Refund Loans Escrow Agent 0.00% -83.33% Transfers Out 0.00% -83.33% 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 57,175 57,175 69,231 (12,056) 121.09% 37.76% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 790 790 (24,983) (25,773) Unassigned Fund Balance at Beginning of Year 31,933 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 04/30/21 6,950 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 6,950
46
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Mt Washington TIF
For the Period Ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 2,179 2,179 1,982 (197) 90.96% 7.63% Investment Income (Loss) 685 685 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 2,179 2,179 2,667 488 122.40% 39.07% Other Financing Sources: Transfers In 0.00% -83.33% Capital lease proceeds 0.00% Total Other Financing Sources 0.00% -83.33% Total Revenues and Other Financing Sources 2,179 2,179 2,667 488 122.40% 39.07% Expenditures: Tax Increment Financing 63 63 60 3 95.24% 11.91% Debt Service Principal 0.00% -83.33% Interest and Fiscal Agent Fees 0.00% -83.33% Debt Issuance Costs 0.00% -83.33% Total Expenditures 63 63 60 3 95.24% 11.91% Other Financing Uses: Issuance of Debt 0.00% -83.33% Reoffering Premium/Original Issue Discount 0.00% -83.33% Payment to Refund Loans Escrow Agent 0.00% -83.33% Transfers Out 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 63 63 60 3 95.24% 11.91% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 2,116 2,116 2,607 491 Unassigned Fund Balance at Beginning of Year 47,388 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Unassigned Ending Fund Balance, 04/30/21 49,995 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 49,995
47
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 1,589,201 1,589,201 1,516,982 (72,219) 95.46% 12.13% Investment Income (Loss) 82,125 82,125 0.00% -83.33% Other Revenue 1,208,000 1,208,000 1,067,536 (140,464) 88.37% 5.04% Total Revenues 2,797,201 2,797,201 2,666,643 (130,558) 95.33% 12.00% Other Financing Sources: Transfers In 315,000 315,000 (315,000) 0.00% -83.33% Total Other Financing Sources 315,000 315,000 (315,000) 0.00% -83.33% Total Revenues and Other Financing Sources 3,112,201 3,112,201 2,666,643 (445,558) 85.68% 2.35% Expenditures: Tax Increment Financing 48,817 48,817 58,218 (9,401) 119.26% 35.93% Debt Service Principal 50,000 50,000 50,000 100.00% 16.67% Interest and Fiscal Agent Fees 3,779,920 3,779,920 3,777,571 2,349 99.94% 16.61% Debt Issuance Costs 0.00% -83.33% Total Expenditures 3,878,737 3,878,737 3,885,789 (7,052) 100.18% 16.85% Other Financing Uses: Issuance of Debt 0.00% -83.33% Reoffering Premium/Original Issue Discount 0.00% -83.33% Payment to Refund Loans Escrow Agent 0.00% -83.33% Transfers Out 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 3,878,737 3,878,737 3,885,789 (7,052) 100.18% 16.85% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (766,536) (766,536) (1,219,146) (452,610) Unassigned Fund Balance at Beginning of Year 5,889,536 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Unassigned Ending Fund Balance, 04/30/21 4,670,390 Other Fund Balance Components: Restricted - Current Year Encumbrances 2,500 Restricted - Prior Year Encumbrances 15,226 Restricted - Trust Debt Service 7,522,922 Total Fund Balance $ 12,211,038
48
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Crackerneck Creek TIF For the Period Ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 496,239 496,239 641,206 144,967 129.21% 45.88% Investment Income (Loss) 3,871 3,871 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 496,239 496,239 645,077 148,838 129.99% 46.66% Expenditures: Tax Increment Financing 9,590 9,590 12,974 (3,384) 135.29% 51.96% Debt Service 486,349 Principal 486,349 98,447 387,902 20.24% -63.09% Interest and Fiscal Agent Fees 529,353 (529,353) 0.00% -83.33% Debt Issuance Costs 0.00% -83.33% Total Expenditures 495,939 495,939 640,774 (144,835) 129.20% 45.87% Other Financing Uses: Issuance of Debt 0.00% -83.33% Reoffering Premium/Original Issue Discount 0.00% -83.33% Payment to Refund Loans Escrow Agent 0.00% -83.33% Transfers Out 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 495,939 495,939 640,774 (144,835) 129.20% 45.87% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 300 300 4,303 4,003 Unassigned Fund Balance at Beginning of Year 3,942 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 04/30/21 8,245 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 8,245
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Old Landfill TIF For the Period Ended April 30, 2021 49
CITY
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Trinity TIF
For the Period Ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 489,107 489,107 412,460 (76,647) 84.33% 1.00% Investment Income (Loss) 23 23 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 489,107 489,107 412,483 (76,624) 84.33% 1.00% Other Financing Sources: Transfers In 32,466 32,466 19,872 (12,594) 61.21% -22.12% Total Other Financing Sources 32,466 32,466 19,872 (12,594) 61.21% -22.12% Total Revenues and Other Financing Sources 521,573 521,573 432,355 (89,218) 82.89% -0.44% Expenditures: Tax Increment Financing 11,267 11,267 12,362 (1,095) 109.72% 26.39% Debt Service Principal 510,360 510,360 115,166 395,194 22.57% -60.76% Interest and Fiscal Agent Fees 117,858 (117,858) 0.00% -83.33% Debt Issuance Costs 0.00% -83.33% Total Expenditures 521,627 521,627 245,386 276,241 47.04% -36.29% Other Financing Uses: Issuance of Debt 0.00% -83.33% Reoffering Premium/Original Issue Discount 0.00% -83.33% Payment to Refund Loans Escrow Agent 0.00% -83.33% Transfers Out 19,872 (19,872) 0.00% -83.33% Total Other Financing Uses 19,872 (19,872) 0.00% -83.33% Total Expenditures and Other Financing Uses 521,627 521,627 265,258 256,369 50.85% -32.48% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (54) (54) 167,097 167,151 Unassigned Fund Balance at Beginning of Year (127,770) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 04/30/21 39,327 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 39,327
50
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule HCA TIF
For the Period Ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 3,589,345 3,589,345 4,576,940 987,595 127.51% 44.18% Investment Income (Loss) 18,328 18,328 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 3,589,345 3,589,345 4,595,268 1,005,923 128.03% 44.70% Other Financing Sources: Transfers In 9,183 9,183 4,151 (5,032) 45.20% -38.13% Total Other Financing Sources 9,183 9,183 4,151 (5,032) 45.20% -38.13% Total Revenues and Other Financing Sources 3,598,528 3,598,528 4,599,419 1,000,891 127.81% 44.48% Expenditures: Tax Increment Financing 550,170 550,170 1,696,465 (1,146,295) 308.35% 225.02% Debt Service Principal 1,950,000 1,950,000 2,030,000 (80,000) 104.10% 20.77% Interest and Fiscal Agent Fees 1,043,000 1,043,000 955,350 87,650 91.60% 8.27% Debt Issuance Costs 0.00% -83.33% Total Expenditures 3,543,170 3,543,170 4,681,815 (1,138,645) 132.14% 48.81% Other Financing Uses: Issuance of Debt 0.00% -83.33% Reoffering Premium/Original Issue Discount 0.00% -83.33% Payment to Refund Loans Escrow Agent 0.00% -83.33% Transfers Out 4,151 (4,151) 0.00% -83.33% Total Other Financing Uses 4,151 (4,151) 0.00% -83.33% Total Expenditures and Other Financing Uses 3,543,170 3,543,170 4,685,966 (1,142,796) 132.25% 48.92% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 55,358 55,358 (86,547) (141,905) Unassigned Fund Balance at Beginning of Year 1,252,821 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Unassigned Ending Fund Balance, 04/30/21 1,166,274 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 3,354,870 Total Fund Balance $ 4,521,144
51
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Cinema East TIF
For the Period Ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 257,861 257,861 227,525 (30,336) 88.24% 4.91% Investment Income (Loss) 16 16 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 257,861 257,861 227,541 (30,320) 88.24% 4.91% Expenditures: Tax Increment Financing 5,139 5,139 4,684 455 91.15% 7.82% Debt Service Principal 252,902 252,902 29,387 223,515 11.62% -71.71% Interest and Fiscal Agent Fees 185,027 (185,027) 0.00% -83.33% Debt Issuance Costs 0.00% -83.33% Total Expenditures 258,041 258,041 219,098 38,943 84.91% 1.58% Other Financing Uses: Issuance of Debt 0.00% -83.33% Reoffering Premium/Original Issue Discount 0.00% -83.33% Payment to Refund Loans Escrow Agent 0.00% -83.33% Transfers Out 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 258,041 258,041 219,098 38,943 84.91% 1.58% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (180) (180) 8,443 8,623 Unassigned Fund Balance at Beginning of Year 36,112 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 04/30/21 44,555 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 44,555
52
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
23rd & Noland Project 1 TIF
For the Period Ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 82,194 82,194 73,459 (8,735) 89.37% 6.04% Investment Income (Loss) 18 18 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 82,194 82,194 73,477 (8,717) 89.39% 6.06% Expenditures: Tax Increment Financing 2,063 2,063 1,758 305 85.22% 1.89% Debt Service Principal 80,131 80,131 44,000 36,131 54.91% -28.42% Interest and Fiscal Agent Fees 0.00% -83.33% Debt Issuance Costs 0.00% -83.33% Total Expenditures 82,194 82,194 45,758 36,436 55.67% -27.66% Other Financing Uses: Issuance of Debt 0.00% -83.33% Reoffering Premium/Original Issue Discount 0.00% -83.33% Payment to Refund Loans Escrow Agent 0.00% -83.33% Transfers Out 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 82,194 82,194 45,758 36,436 55.67% -27.66% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 27,719 27,719 Unassigned Fund Balance at Beginning of Year 26,964 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 04/30/21 54,683 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 54,683
53
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule 23rd & Noland Project 2 TIF For the Period Ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 11,729 11,729 19,908 8,179 169.73% 86.40% Investment Income (Loss) 17 17 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 11,729 11,729 19,925 8,196 169.88% 86.55% Expenditures: Tax Increment Financing 246 246 287 (41) 116.67% 33.34% Debt Service Principal 11,483 11,483 1,500 9,983 13.06% -70.27% Interest and Fiscal Agent Fees 0.00% -83.33% Debt Issuance Costs 0.00% -83.33% Total Expenditures 11,729 11,729 1,787 9,942 15.24% -68.09% Other Financing Uses: Issuance of Debt 0.00% -83.33% Reoffering Premium/Original Issue Discount 0.00% -83.33% Payment to Refund Loans Escrow Agent 0.00% -83.33% Transfers Out 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 11,729 11,729 1,787 9,942 15.24% -68.09% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 18,138 18,138 Unassigned Fund Balance at Beginning of Year 2,341 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Unassigned Ending Fund Balance, 04/30/21 20,479 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 20,479
54
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison
Schedule
23rd & Noland Project 3 TIF
For the Period Ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 24,348 24,348 28,719 4,371 117.95% 34.62% Investment Income (Loss) 13 13 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 24,348 24,348 28,732 4,384 118.01% 34.68% Expenditures: Tax Increment Financing 24,438 24,438 768 23,670 3.14% -80.19% Debt Service Principal 0.00% -83.33% Interest and Fiscal Agent Fees 0.00% -83.33% Debt Issuance Costs 0.00% -83.33% Total Expenditures 24,438 24,438 768 23,670 3.14% -80.19% Other Financing Uses: Issuance of Debt 0.00% -83.33% Reoffering Premium/Original Issue Discount 0.00% -83.33% Payment to Refund Loans Escrow Agent 0.00% -83.33% Transfers Out 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 24,438 24,438 768 23,670 3.14% -80.19% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (90) (90) 27,964 28,054 Unassigned Fund Balance at Beginning of Year 7,388 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Unassigned Ending Fund Balance, 04/30/21 35,352 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 35,352
55
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule 23rd & Noland Project 4 TIF For the Period Ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 462,503 462,503 381,225 (81,278) 82.43% -0.90% Investment Income (Loss) 117 117 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 462,503 462,503 381,342 (81,161) 82.45% -0.88% Expenditures: Tax Increment Financing 462,503 462,503 7,846 454,657 1.70% -81.63% Debt Service Principal 0.00% -83.33% Interest and Fiscal Agent Fees 0.00% -83.33% Debt Issuance Costs 0.00% -83.33% Total Expenditures 462,503 462,503 7,846 454,657 1.70% -81.63% Other Financing Uses: Issuance of Debt 0.00% -83.33% Reoffering Premium/Original Issue Discount 0.00% -83.33% Payment to Refund Loans Escrow Agent 0.00% -83.33% Transfers Out 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 462,503 462,503 7,846 454,657 1.70% -81.63% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 373,496 373,496 Unassigned Fund Balance at Beginning of Year 91,416 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Unassigned Ending Fund Balance, 04/30/21 464,912 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 464,912
56
MISSOURI
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 145,470 145,470 269,164 123,694 185.03% 101.70% Investment Income (Loss) 10,271 10,271 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 145,470 145,470 279,435 133,965 192.09% 108.76% Expenditures: Tax Increment Financing 7,799 7,799 43,320 (35,521) 555.46% 472.13% Debt Service Principal 0.00% -83.33% Interest and Fiscal Agent Fees 0.00% -83.33% Debt Issuance Costs 0.00% -83.33% Total Expenditures 7,799 7,799 43,320 (35,521) 555.46% 472.13% Other Financing Uses: Issuance of Debt 0.00% -83.33% Reoffering Premium/Original Issue Discount 0.00% -83.33% Payment to Refund Loans Escrow Agent 0.00% -83.33% Transfers Out 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 7,799 7,799 43,320 (35,521) 555.46% 472.13% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 137,671 137,671 236,115 98,444 Unassigned Fund Balance at Beginning of Year 557,713 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Unassigned Ending Fund Balance, 04/30/21 793,828 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 793,828
TIF
57
CITY OF INDEPENDENCE,
Budgetary Comparison Schedule Independence Square
For the Period Ended April 30, 2021
CITY OF INDEPENDENCE,
MISSOURI
Budgetary Comparison Schedule
I-70 & Little Blue Parkway Project 1 TIF
For the Period Ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 1,152,029 1,152,029 1,500,522 348,493 130.25% 46.92% Investment Income (Loss) 440 440 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 1,152,029 1,152,029 1,500,962 348,933 130.29% 46.96% Expenditures: Tax Increment Financing 23,927 23,927 34,206 (10,279) 142.96% 59.63% Debt Service Principal 1,128,102 1,128,102 154,493 973,609 13.69% -69.64% Interest and Fiscal Agent Fees 0.00% -83.33% Debt Issuance Costs 0.00% -83.33% Total Expenditures 1,152,029 1,152,029 188,699 963,330 16.38% -66.95% Other Financing Uses: Issuance of Debt 0.00% -83.33% Reoffering Premium/Original Issue Discount 0.00% -83.33% Payment to Refund Loans Escrow Agent 0.00% -83.33% Transfers Out 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 1,152,029 1,152,029 188,699 963,330 16.38% -66.95% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 1,312,263 1,312,263 Unassigned Fund Balance at Beginning of Year 368,733 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Unassigned Ending Fund Balance, 04/30/21 1,680,996 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 1,680,996
58
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule
I-70 & Little Blue Parkway Project 3 TIF
For the Period Ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 382,156 382,156 344,880 (37,276) 90.25% 6.92% Investment Income (Loss) 3,463 3,463 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 382,156 382,156 348,343 (33,813) 91.15% 7.82% Expenditures: Tax Increment Financing 6,200 (6,200) 0.00% -83.33% Debt Service Principal 382,156 382,156 382,156 0.00% -83.33% Interest and Fiscal Agent Fees 0.00% -83.33% Debt Issuance Costs 0.00% -83.33% Total Expenditures 382,156 382,156 6,200 375,956 1.62% -81.71% Other Financing Uses: Issuance of Debt 0.00% -83.33% Reoffering Premium/Original Issue Discount 0.00% -83.33% Payment to Refund Loans Escrow Agent 0.00% -83.33% Transfers Out 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 382,156 382,156 6,200 375,956 1.62% -81.71% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 342,143 342,143 Unassigned Fund Balance at Beginning of Year 69,829 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Unassigned Ending Fund Balance, 04/30/21 411,972 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 411,972
59
CITY
MISSOURI
Marketplace Project 1 TIF
For the Period Ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 97,731 97,731 112,340 14,609 114.95% 31.62% Investment Income (Loss) 29 29 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 97,731 97,731 112,369 14,638 114.98% 31.65% Expenditures: Tax Increment Financing 3,949 3,949 2,875 1,074 72.80% -10.53% Debt Service Principal 93,782 93,782 93,782 0.00% -83.33% Interest and Fiscal Agent Fees 115,800 (115,800) 0.00% -83.33% Debt Issuance Costs 0.00% -83.33% Total Expenditures 97,731 97,731 118,675 (20,944) 121.43% 38.10% Other Financing Uses: Issuance of Debt 0.00% -83.33% Reoffering Premium/Original Issue Discount 0.00% -83.33% Payment to Refund Loans Escrow Agent 0.00% -83.33% Transfers Out 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 97,731 97,731 118,675 (20,944) 121.43% 38.10% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (6,306) (6,306) Unassigned Fund Balance at Beginning of Year 30,593 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 04/30/21 24,287 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 24,287
OF INDEPENDENCE,
Budgetary Comparison Schedule
60
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Marketplace Project 2 TIF
For the Period Ended April 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 35,447 35,447 107,249 71,802 302.56% 219.23% Investment Income (Loss) 28 28 0.00% -83.33% Other Revenue 0.00% -83.33% Total Revenues 35,447 35,447 107,277 71,830 302.64% 219.31% Expenditures: Tax Increment Financing 35,447 35,447 3,575 31,872 10.09% -73.24% Debt Service Principal 0.00% -83.33% Interest and Fiscal Agent Fees 125,200 (125,200) 0.00% -83.33% Debt Issuance Costs 0.00% -83.33% Total Expenditures 35,447 35,447 128,775 (93,328) 363.29% 279.96% Other Financing Uses: Issuance of Debt 0.00% -83.33% Reoffering Premium/Original Issue Discount 0.00% -83.33% Payment to Refund Loans Escrow Agent 0.00% -83.33% Transfers Out 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 35,447 35,447 128,775 (93,328) 363.29% 279.96% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (21,498) (21,498) Unassigned Fund Balance at Beginning of Year 38,028 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 04/30/21 16,530 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 16,530
61
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule TIF
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 83.33% of Year Budget Revenues: Taxes $ 0.00% -83.33% Investment Income (Loss) 0.00% -83.33% Other Revenue 24,474 24,474 0.00% -83.33% Total Revenues 24,474 24,474 0.00% -83.33% Expenditures: Tax Increment Financing 300 (300) 0.00% -83.33% Debt Service Principal 0.00% -83.33% Interest and Fiscal Agent Fees 0.00% -83.33% Debt Issuance Costs 0.00% -83.33% Total Expenditures 300 (300) 0.00% -83.33% Other Financing Uses: Issuance of Debt 0.00% -83.33% Reoffering Premium/Original Issue Discount 0.00% -83.33% Payment to Refund Loans Escrow Agent 0.00% -83.33% Transfers Out 0.00% -83.33% Total Other Financing Uses 0.00% -83.33% Total Expenditures and Other Financing Uses 300 (300) 0.00% -83.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 24,174 24,174 Unassigned Fund Balance at Beginning of Year (24,174) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 04/30/21 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $
Application Fees
62
For the Period Ended April 30, 2021