Monthly Financial and Operating Report January 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 Pubic 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 Enterprise Funds Power and Light 17 Water 18 Water Pollution Control 19 Events Center Debt Service 20 Internal Service Funds Central Garage 21 Staywell Health Care 22 Worker's Compensation 23 Risk Management 24 Enterprise Resource Planning 25 Debt Service Fund Debt Service - Neighborhood Improvement Districts 26 Capital Improvement Funds Street Improvements Capital Project Fund 27 Revolving Public Improvements Capital Project Fund 28 Building and Other Improvements Capital Project Fund 29 Storm Drainage Capital Project Fund 30 Park Improvements Capital Project Fund 31 Private Purpose Expendable Trust Fund - Vaile Mansion 32 Independence Events Center CID 33 Crackerneck Creek TDD 34 Tax Increment Financing Summary 35 Mid-Town Truman Rd TIF 36 RSO TIF 37 Santa Fe TIF 38 Hartman Heritage TIF 39 Drumm Farm TIF 40 Eastland TIF 41 North Independence TIF 42 Mt Washington TIF 43 Crackerneck Creek TIF 44 Old Landfill TIF 45 Trinity TIF 46 HCA TIF 47 Cinema East TIF 48 23rd & Noland Project 1 TIF 49 23rd & Noland Project 2 TIF 50 23rd & Noland Project 3 TIF 51 23th & Noland Project 4 TIF 52 Independence Square TIF 53 I-70 & Little Blue Parkway Project 1 TIF 54 I-70 & Little Blue Parkway Project 3 TIF 55 Marketplace Project 1 TIF 56 Marketplace Project 2 TIF 57 TIF Application Fees 58
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule General Fund
For the period ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 31,453,100 31,453,100 20,347,288 (11,105,812) 64.69% 6.36% Licenses and Permits 4,392,069 4,392,069 2,730,842 (1,661,227) 62.18% 3.85% Intergovernmental 5,262,150 5,262,150 3,142,037 (2,120,113) 59.71% 1.38% Charges for Current Services 2,058,050 2,130,529 738,576 (1,391,953) 34.67% -23.66% Interfund Charges for Support Services 5,035,500 5,035,500 2,937,375 (2,098,125) 58.33% 0.00% Fines and Forfeitures 3,771,000 3,771,000 1,164,284 (2,606,716) 30.87% -27.46% Investment Income (Loss) 175,000 175,000 105,543 (69,457) 60.31% 1.98% Other Revenue 2,493,532 2,504,622 448,484 (2,056,138) 17.91% -40.42% Total Revenues 54,640,401 54,723,970 31,614,429 (23,109,541) 57.77% -0.56% Other Financing Sources: Payments In Lieu of Taxes 19,796,612 19,796,612 11,838,645 (7,957,967) 59.80% 1.47% Operating Transfers In 0.00% -58.33% Total Other Financing Sources 19,796,612 19,796,612 11,838,645 (7,957,967) 59.80% 1.47% Total Revenues and Other Financing Sources 74,437,013 74,520,582 43,453,074 (31,067,508) 58.31% -0.02% Expenditures: City Council 680,553 680,553 361,817 318,736 53.17% -5.16% City Clerk 195,240 195,240 111,606 83,634 57.16% -1.17% City Manager 1,187,339 1,187,339 630,209 557,130 53.08% -5.25% Municipal Court 1,207,254 1,207,254 686,065 521,189 56.83% -1.50% Law 661,301 661,301 338,545 322,756 51.19% -7.14% Finance 5,295,645 5,295,645 2,713,321 2,582,324 51.24% -7.09% Community Development 5,653,911 5,653,911 2,666,719 2,987,192 47.17% -11.16% Police 31,553,037 31,580,724 18,327,033 13,253,691 58.03% -0.30% Fire 21,181,684 21,181,684 13,822,777 7,358,907 65.26% 6.93% Public Works 4,775,106 4,779,860 3,244,209 1,535,651 67.87% 9.54% COVID Reserve 1,468,971 1,468,971 1,468,971 0.00% -58.33% Debt service 566,972 566,972 4,392 562,580 0.77% -57.56% Total Expenditures 74,427,013 74,459,454 42,906,693 31,552,761 57.62% -0.71% Other Financing Uses: Transfers Out 10,000 10,000 35,300 (25,300) 353.00% 294.67% Total Expenditures and Other Financing Uses 74,437,013 74,469,454 42,941,993 31,527,461 57.66% -0.67% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 51,128 511,081 459,953 Unassigned Fund Balance at Beginning of Year 5,301,516 Cancellation of prior year encumbrances 19,823 Change in other fund balance components during the year (105,896) Year-end investment market value adjustment Ending Unassigned Fund Balance, 01/31/21 5,726,524 Restricted 223,597 Committed 17,629 Assigned 1,625,702 Total Fund Balance $ 7,593,452
1
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Street
For
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Sales Taxes $ 8,028,559 8,028,559 4,910,307 (3,118,252) 61.16% 2.83% Charges for Services 7,088 7,088 0.00% -58.33% Intergovernmental Revenue 30,493 30,493 0.00% -58.33% Investment Income (Loss) 10,000 10,000 23,277 13,277 232.77% 174.44% Other Revenue 0.00% -58.33% Total Revenues 8,038,559 8,038,559 4,971,165 (3,067,394) 61.84% 3.51% Other Financing sources: Transfers in 0.00% -58.33% Issuance of debt 0.00% -58.33% Total other financing sources 0.00% -58.33% Total revenues and other financing sources 8,038,559 8,038,559 4,971,165 (3,067,394) 61.84% 3.51% Expenditures: General Government 0.00% -58.33% Street Maintenance 929,575 929,575 497,926 431,649 53.56% -4.77% Capital Outlay 4,971,836 29,404,674 5,042,945 24,361,729 17.15% -41.18% Debt Service 555,951 555,951 338,877 217,074 60.95% 2.62% Total Expenditures 6,457,362 30,890,200 5,879,748 25,010,452 19.03% -39.30% Other Financing Uses: Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 6,457,362 30,890,200 5,879,748 25,010,452 19.03% -39.30% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 1,581,197 (22,851,641) (908,583) 21,943,058 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 (1,971) Year-end investment market value adjustment Ending Unassigned Fund Balance, 01/31/21 (2,250,665) Fund Balance Components: Restricted - Current Year Encumbrances 861,066 Restricted - Prior Year Encumbrances 1,126,305 Restricted - Debt Reserve Project Accounts - Capital Projects 17,865,087 Total Fund Balance $ 17,601,793
Improvements Sales Tax Fund
the period ended January 31, 2021 2
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Park
For
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Sales Taxes $ 4,014,300 4,014,300 2,455,154 (1,559,146) 61.16% 2.83% Charges for services 348,455 348,455 37,933 (310,522) 10.89% -47.44% Intergovernmental 0.00% -58.33% Investment Income (Loss) 3,000 3,000 9,166 6,166 305.53% 247.20% Other Revenue 2,500 2,500 17,410 14,910 696.40% 638.07% Total Revenues 4,368,255 4,368,255 2,519,663 (1,848,592) 57.68% -0.65% Other Financing Sources: Transfers In 25,300 25,300 100.00% 41.67% Proceeds from Bond Issuance/Capital Lease 0.00% -58.33% Total Other Financing Sources 25,300 25,300 0.00% -58.33% Total Revenues and Other Financing Sources 4,368,255 4,393,555 2,544,963 (1,848,592) 57.92% -0.41% Expenditures: Culture and Recreation 3,640,907 3,640,907 1,804,629 1,836,278 49.57% -8.76% Capital Outlay 280,625 1,092,997 114,388 978,609 10.47% -47.86% Debt Service 261,589 261,589 82,823 178,766 31.66% -26.67% Total Expenditures 4,183,121 4,995,493 2,001,840 2,993,653 40.07% -18.26% Other Financing Uses: Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 4,183,121 4,995,493 2,001,840 2,993,653 40.07% -18.26% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 185,134 (601,938) 543,123 1,145,061 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, 01/31/21 (114,915) Other Fund Balance Components: Restricted - Current Year Encumbrances 208,763 Restricted - Prior Year Encumbrances 15,553 Total Fund Balance $ 109,401
Improvements Sales Tax Fund
the period ended January 31, 2021 3
CITY OF INDEPENDENCE, MISSOURI Budgetary
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Sales Taxes $ 4,014,317 4,014,317 2,455,154 (1,559,163) 61.16% 2.83% Investment income (loss) 24,500 24,500 73,698 49,198 300.81% 242.48% Other Revenue 76 76 0.00% -58.33% Total revenues 4,038,817 4,038,817 2,528,928 (1,509,889) 62.62% 4.29% Expenditures: Storm water Administration 342,871 342,871 158,481 184,390 46.22% -12.11% Maintenance 2,116,748 2,116,748 830,727 1,286,021 39.25% -19.08% Permit completion 318,000 318,000 2,800 315,200 0.88% -57.45% Capital outlay 1,300,000 3,867,673 659,954 3,207,719 17.06% -41.27% Total Expenditures 4,077,619 6,645,292 1,651,962 4,993,330 24.86% -33.47% Total Ependitures and Other Financing Uses 4,077,619 6,645,292 1,651,962 4,993,330 Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (38,802) (2,606,475) 876,966 3,483,441 Unassigned Fund Balance at Beginning of Year 7,257,353 Cancellation of Prior Year Encumbrances 1,682 Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 01/31/21 8,136,001 Other Fund Balance Components: Restricted - Current Year Encumbrances 685,004 Restricted - Prior Year Encumbrances 460,284 Restricted - Regional Detention Construction 540,563 Restricted - Regional Detention Maintenance 50,228 Restricted - Emergency Response Relief 500,000 Total Fund Balance $ 10,372,080
Comparison Schedule Storm Water Sales Tax Fund For the period ended January 31, 2021 4
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Police Public Safety Sales Tax Fund
For the period ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Sales Taxes $ 2,133,460 2,133,460 1,300,170 (833,290) 60.94% 2.61% Investment Income (Loss) 5,000 5,000 20,509 15,509 410.18% 351.85% Other Revenue 14,939 14,939 0.00% -58.33% Total Revenues 2,138,460 2,138,460 1,335,618 (802,842) 62.46% 4.13% Expenditures: Public Safety Communications 602,307 602,307 440,681 161,626 73.17% 14.84% Facilities 99,768 99,768 69,380 30,388 69.54% 11.21% Equipment 2,017,965 2,017,965 1,547,416 470,549 76.68% 18.35% Debt Service 0.00% -58.33% Total Expenditures 2,720,040 2,720,040 2,057,477 662,563 75.64% 17.31% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 2,720,040 2,720,040 2,057,477 662,563 75.64% 17.31% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (581,580) (581,580) (721,859) (140,279) 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, 01/31/21 1,836,401 Other Fund Balance Components: Restricted - Current Year Encumbrances 636,980 Restricted - Prior Year Encumbrances 20,543 Total Fund Balance $ 2,493,924
5
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Fire Public Safety Sales Tax Fund For the period ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Sales Taxes $ 2,007,200 2,007,200 1,227,580 (779,620) 61.16% 2.83% Investment Income (Loss) 5,300 5,300 9,383 4,083 177.04% 118.71% Other Revenue 6,302 6,456 154 102.44% 44.11% Total Revenues 2,012,500 2,018,802 1,243,419 (775,383) 61.59% 3.26% Expenditures: Public Safety 2,183,900 2,743,985 1,758,510 985,475 64.09% 5.76% Debt Service 73,236 73,236 73,236 0.00% -58.33% Total Expenditures 2,257,136 2,817,221 1,758,510 1,058,711 62.42% 4.09% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 2,257,136 2,817,221 1,758,510 1,058,711 62.42% 4.09% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (244,636) (798,419) (515,091) 283,328 Unassigned Fund Balance at Beginning of Year 1,243,946 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 01/31/21 728,855 Other Fund Balance Components: Restricted - Current Year Encumbrances 1,384,464 Restricted - Prior Year Encumbrances 231,721 Total Fund Balance $ 2,345,040
6
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Animal Shelter Use Tax
For the period ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Use Tax $ 750,000 750,000 750,000 100.00% 41.67% Investment Income (Loss) 164 164 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 750,000 750,000 750,164 164 100.02% 41.69% Expenditures: General Government -58.33% Animal Services 744,152 744,152 428,635 315,517 57.60% -0.73% Capital Outlay 0.00% -58.33% Debt Service 0.00% -58.33% Total Expenditures 744,152 744,152 428,635 315,517 57.60% -0.73% Other Financing Uses: Transfers In 0.00% -58.33% Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 744,152 744,152 428,635 315,517 57.60% -0.73% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 5,848 5,848 321,529 315,681 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, 01/31/21 542,369 Fund Balance Components: Restricted - Current Year Encumbrances 1,437 Restricted - Prior Year Encumbrances Total Fund Balance $ 543,806
7
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Police Use Tax
For the period ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Use Tax $ 750,000 750,000 1,937,633 1,187,633 258.35% 200.02% Investment Income (Loss) 4,103 4,103 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 750,000 750,000 1,941,736 1,191,736 258.90% 200.57% Expenditures: Public Safety 750,000 750,000 109,996 640,004 14.67% -43.66% Debt Service 0.00% -58.33% Total Expenditures 750,000 750,000 109,996 640,004 14.67% -43.66% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 750,000 750,000 109,996 640,004 14.67% -43.66% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 1,831,740 1,831,740 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, 01/31/21 2,769,738 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 2,769,738
8
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule Health Property Tax Levy For the period ended January 31, 2021 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 832,000 832,000 870,638 38,638 104.64% 46.31% Charges for Services 154,000 154,000 67,550 (86,450) 43.86% -14.47% Investment Income (Loss) 102 102 0.00% -58.33% Other Revenue 103,677 103,677 0.00% -58.33% Total Revenues 986,000 986,000 1,041,967 55,967 105.68% 47.35% Expenditures: Animal Services 986,000 986,000 545,186 440,814 55.29% -3.04% Total Expenditures 986,000 986,000 545,186 440,814 55.29% -3.04% Other Financing Uses – Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Uses 986,000 986,000 545,186 440,814 55.29% -3.04% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 496,781 496,781 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, 01/31/21 496,781 Other Fund Balance Components: Restricted - Current Year Encumbrances 21,192 Restricted - Prior Year Encumbrances Total Fund Balance $ 517,973
9
CITY OF INDEPENDENCE, MISSOURI
Comparison Schedule Parks and Recreation Property Tax Levy For the period ended January 31, 2021 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 1,794,000 1,823,700 1,850,105 26,405 101.45% 43.12% Intergovernmental 30,000 30,000 43,660 13,660 145.53% 87.20% Charges for Services 184,813 184,813 92,791 (92,022) 50.21% -8.12% Investment Income (Loss) 221 221 0.00% -58.33% Other Revenue 13,156 13,156 0.00% -58.33% Total Revenues 2,008,813 2,038,513 1,999,933 (38,580) 98.11% 39.78% Expenditures: Parks and Recreation 1,899,830 1,899,830 1,019,492 880,338 53.66% -4.67% Total Expenditures 1,899,830 1,899,830 1,019,492 880,338 53.66% -4.67% Other Financing Uses – Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Uses 1,899,830 1,899,830 1,019,492 880,338 53.66% -4.67% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 108,983 138,683 980,441 841,758 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, 01/31/21 980,441 Other Fund Balance Components: Restricted - Current Year Encumbrances 11,357 Restricted - Prior Year Encumbrances Total Fund Balance $ 991,798 10
Budgetary
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule Tourism Fund For the period ended January 31, 2021 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Transient Guest Taxes $ 1,860,354 1,860,354 692,801 (1,167,553) 37.24% -21.09% Charges for Services 23,944 23,944 1,447 (22,497) 6.04% -52.29% Investment Income (Loss) 3,300 3,300 10,881 7,581 329.73% 271.40% Other Revenue 15,600 15,600 (15,600) 0.00% -58.33% Total Revenues 1,903,198 1,903,198 705,129 (1,198,069) 37.05% -21.28% Expenditures: Tourism 1,997,806 2,174,064 875,221 1,298,843 40.26% -18.07% Total Expenditures 1,997,806 2,174,064 875,221 1,298,843 40.26% -18.07% Other Financing Uses – Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Uses 1,997,806 2,174,064 875,221 1,298,843 40.26% -18.07% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (94,608) (270,866) (170,092) 100,774 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, 01/31/21 740,010 Other Fund Balance Components: Restricted - Current Year Encumbrances 178,840 Restricted - Prior Year Encumbrances 87,289 Restricted - Operating Reserve 376,368 Total Fund Balance $ 1,382,507
11
Independence Square Benefit District For the period ended January 31, 2021 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 26,283 26,283 0.00% -58.33% Investment Income (Loss) 668 668 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 26,951 26,951 0.00% -58.33% Expenditures: Capital Outlay 421 (421) 0.00% -58.33% Total Expenditures 421 (421) 0.00% -58.33% Other Financing Uses – Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Uses 421 (421) 0.00% -58.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 26,530 26,530 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, 01/31/21 30,285 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 30,285 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 58.33% of Year Budget Revenues: Federal Grant - CDBG $ 814,159 1,819,696 185,456 (1,634,240) 10.19% -48.14% Other Revenue 30 30 -58.33% Total Revenues 814,159 1,819,696 185,486 (1,634,210) 10.19% -48.14% Expenditures: CDBG Administration 162,830 162,831 191,114 (28,283) 117.37% 59.04% CDBG Expenditures 663,994 770,519 178,245 592,274 23.13% -35.20% Total Expenditures 826,824 933,350 369,359 563,991 39.57% -18.76% Other Financing Uses: Transfers Out 899,011 899,011 0.00% -58.33% Total Other Financing Uses 899,011 899,011 0.00% -58.33% Total Expenditures and Other Uses 826,824 1,832,361 369,359 1,463,002 20.16% -38.17% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (12,665) (12,665) (183,873) (171,208) Unassigned Fund Balance at Beginning of Year (184,469) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 01/31/21 (368,342) Other Fund Balance Components: Restricted - Current Year Encumbrances 219,553 Restricted - Prior Year Encumbrances 142,022 Total Fund Balance $ (6,767)
Budgetary Comparison Schedule Community Development Block Grant Fund For the period ended January 31, 2021 13
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: HOME Program Grant $ 482,477 1,465,629 277,662 (1,187,967) 18.94% -39.39% Total Revenues 482,477 1,465,629 277,662 (1,187,967) 18.94% -39.39% Expenditures: HOME Administration 70,592 184,543 13,176 171,367 7.14% -51.19% Multi Family Housing 359,759 645,213 92,434 552,779 14.33% -44.00% Community Housing Development 102,788 686,535 27,566 658,969 4.02% -54.31% Total Expenditures 533,139 1,516,291 133,176 1,383,115 8.78% -49.55% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (50,662) (50,662) 144,486 195,148 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, 01/31/21 (41,091) Other Fund Balance Components: Restricted - Current Year Encumbrances 16,944 Restricted - Prior Year Encumbrances 24,042 Total Fund Balance $ (105)
Rental Rehabilitation
14
For the period ended January 31, 2021
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
For
License
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Licenses and Permits $ 6,970 6,970 0.00% -58.33% Investment Income (Loss) 4,000 4,000 9,716 5,716 242.90% 184.57% Other Revenue 0.00% -58.33% Total Revenues 4,000 4,000 16,686 12,686 417.15% 358.82% Expenditures: General Government 0.00% -58.33% Total expenditures 0.00% -58.33% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 0.00% -58.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 4,000 4,000 16,686 12,686 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, 01/31/21 1,299,564 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 1,299,564
Surcharge
the period ended January 31, 2021 15
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Grants
For the period ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Intergovernmental $ 585,503 4,468,368 2,421,985 (2,046,383) 54.20% -4.13% Charges for Services 85,595 85,595 0.00% -58.33% Other Revenue 27,938 418 (27,520) 1.50% -56.83% Total Revenues 585,503 4,496,306 2,507,998 (1,988,308) 55.78% -2.55% Expenditures: Public Safety 527,713 2,349,207 1,040,488 1,308,719 44.29% -14.04% General Government 33,550 136,128 25,511 110,617 18.74% -39.59% Culture and Recreation 300 56,519 38,240 18,279 67.66% 9.33% CARES Act Marketing 1,055,998 1,055,985 13 100.00% 41.67% Community Development 24,240 803,506 1,178,866 (375,360) 146.72% 88.39% Animal Services 15,247 11,989 3,258 78.63% 20.30% Health Services 80,000 78,400 1,600 98.00% 39.67% Total Expenditures 585,803 4,496,605 3,429,479 1,067,126 76.27% 17.94% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 585,803 4,496,605 3,429,479 1,067,126 76.27% 17.94% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (300) (299) (921,481) (921,182) 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, 01/31/21 (1,068,246) Other Fund Balance Components: Restricted - Current Year Encumbrances 928,819 Restricted - Prior Year Encumbrances 32,189 Total Fund Balance $ (107,238)
16
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Power and Light
For the period ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Operating Revenues: Charges for Services $ 130,313,972 130,313,972 75,044,289 (55,269,683) 57.59% -0.74% Penalties 1,106,786 1,106,786 520,355 (586,431) 47.01% -11.32% Connection Charges 280,151 280,151 16,800 (263,351) 6.00% -52.33% Meter Reading 20,572 20,572 0.00% -58.33% Temporary Service 600 600 0.00% -58.33% Rental Income 340,239 340,239 23,511 (316,728) 6.91% -51.42% Transmission Wheeling 5,000,000 5,000,000 2,930,813 (2,069,187) 58.62% 0.29% Total Operating Revenues 137,041,148 137,041,148 78,556,940 (58,484,208) 57.32% -1.01% Operating Expenses: Personnel Services 27,275,535 27,275,535 16,128,483 11,147,052 59.13% 0.80% Other Services 26,731,853 26,729,853 16,540,752 10,189,101 61.88% 3.55% Supplies 57,859,830 57,859,830 32,186,348 25,673,482 55.63% -2.70% Capital Projects 5,285,000 15,463,979 5,622,916 9,841,063 36.36% -21.97% Capital Operating 1,313,400 1,315,400 46,003 1,269,397 3.50% -54.83% Debt Service 10,547,050 10,547,050 6,153,381 4,393,669 58.34% 0.01% Other Expenses 275,000 275,000 275,000 0.00% -58.33% Total Operating Expenses 129,287,668 139,466,647 76,677,883 62,788,764 54.98% -3.35% Nonoperating Revenues (Expenses): Investment Income 200,000 200,000 302,562 102,562 151.28% 92.95% Interfund Charges for Support Services 1,828,147 1,828,147 1,021,338 (806,809) 55.87% -2.46% Miscellaneous Revenue (Expense) 886,189 886,189 (408,445) (1,294,634) -46.09% -104.42% Total Nonoperating Revenue (Expenses) 2,914,336 2,914,336 915,455 (1,998,881) 31.41% -26.92% 10,667,816 488,837 2,794,512 2,305,675 571.67% 513.34% Capital Contributions 0.00% -58.33% Transfers Out – Utility Payments In Lieu of Taxes (13,000,000) (13,000,000) (8,046,605) (4,953,395) 61.90% 3.57% Transfers In 0.00% -58.33% Transfers Out 0.00% -58.33% Total Transfers (13,000,000) (13,000,000) (8,046,605) (4,953,395) 61.90% 3.57% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (2,332,184) (12,511,163) (5,252,093) 7,259,070 Beginning Available Resources 82,856,511 Ending Available Resources 77,604,418 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 $ 10,604,418
Income (Loss) Before Transfers 17
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Water
For the period ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Operating Revenues: Charges for Services $ 31,850,000 31,850,000 20,100,550 (11,749,450) 63.11% 4.78% Penalties 170,000 170,000 84,889 (85,111) 49.93% -8.40% Connection/Disconnection Charges 83,750 83,750 3,147 (80,603) 3.76% -54.57% Meter Reading 1,000 1,000 6,279 5,279 627.90% 569.57% Returned Check Charges 10,000 10,000 10,040 40 100.40% 42.07% Rental Income 35,000 35,000 43,059 8,059 123.03% 64.70% Meter Repairs 250 250 (250) 0.00% -58.33% Merchandising Jobbing 6,423 6,423 0.00% -58.33% Total Operating Revenues 32,150,000 32,150,000 20,254,387 (11,895,613) 63.00% 4.67% Operating expenses: Personnel Services 8,666,805 8,666,805 4,581,734 4,085,071 52.87% -5.46% Other Services 11,365,107 12,765,107 6,258,598 6,506,509 49.03% -9.30% Supplies 2,460,040 2,460,040 1,868,434 591,606 75.95% 17.62% Capital Projects 4,205,000 14,646,878 1,777,086 12,869,792 12.13% -46.20% Capital Operating 882,493 882,493 697,868 184,625 79.08% 20.75% Debt Service 2,533,338 2,533,338 2,154,997 378,341 85.07% 26.74% Other Expenses 125,000 125,000 125,000 0.00% -58.33% Total Operating Expenses 30,237,783 42,079,661 17,338,717 24,740,944 41.20% -17.13% Nonoperating Revenues (Expenses): Investment Income 75,000 75,000 295,672 220,672 394.23% 335.90% Interfund Charges for Support Services 1,392,092 1,392,092 812,054 (580,038) 58.33% 0.00% Miscellaneous Revenue (Expense) 128,793 128,793 0.00% -58.33% Total Nonoperating Revenue (Expenses) 1,467,092 1,467,092 1,236,519 (230,573) 84.28% 25.95% 3,379,309 (8,462,569) 4,152,189 12,614,758 -49.07% -107.40% Transfers Out – Utility Payments In Lieu of Taxes (3,200,000) (3,200,000) (1,906,033) (1,293,967) 59.56% 1.23% Transfers In 0.00% -58.33% Transfers Out 0.00% -58.33% Total Transfers (3,200,000) (3,200,000) (1,906,033) (1,293,967) 59.56% 1.23% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 179,309 (11,662,569) 2,246,156 13,908,725 Beginning Available Resources 32,358,367 Cancellation of Prior Year Encumbrances 28,282 Ending Available Resources 34,632,805 Current Debt Service Due 1,845,684 Operating Reserve (63 Days) 4,889,277 Mngt Recom Operating Reserve (27 Days) 2,095,389 Capital Projects in Process - Non Bond 12,869,792 Prior Year Open Encumbrances - Non Cap 329,516 Reserved Resources 22,029,658 Total Non-Restricted Resources Available $ 12,603,147 Income (Loss) Before Transfers
18
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Sanitary
For the period ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Operating revenues: Charges for Services $ 33,393,893 33,393,893 21,460,281 (11,933,612) 64.26% 5.93% Penalties 200,000 200,000 126,444 (73,556) 63.22% 4.89% Total operating revenues 33,593,893 33,593,893 21,586,725 (12,007,168) 64.26% 5.93% Operating expenses: Personnel Services 5,868,295 5,868,295 3,163,116 2,705,179 53.90% -4.43% Other Services 13,075,398 13,075,398 5,996,790 7,078,608 45.86% -12.47% Supplies 661,840 661,840 282,990 378,850 42.76% -15.57% Capital Projects 5,330,000 12,853,182 188,621 12,664,561 1.47% -56.86% Capital Operating 926,000 926,000 757,854 168,146 81.84% 23.51% Debt Service 6,290,632 6,290,632 4,583,950 1,706,682 72.87% 14.54% Other Expenses 30,000 30,000 30,000 0.00% -58.33% Total Operating Expenses 32,182,165 39,705,347 14,973,321 24,732,026 37.71% -20.62% Nonoperating Revenues (Expenses): Investment Income 51,000 51,000 123,103 72,103 241.38% 183.05% Miscellaneous Revenue (Expense) (56,508) (56,508) 0.00% -58.33% Total Nonoperating Revenue (Expenses) 51,000 51,000 66,595 15,595 130.58% 72.25% 1,462,728 (6,060,454) 6,679,999 12,740,453 -110.22% -168.55% Transfers Out – Utility Payments In Lieu of Taxes (3,596,612) (3,596,612) (1,886,007) (1,710,605) 52.44% -5.89% Transfers In 10,000 10,000 10,000 100.00% 41.67% Transfers Out 0.00% -58.33% Total Transfers (3,586,612) (3,586,612) (1,876,007) (1,710,605) 52.31% -6.02% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (2,123,884) (9,647,066) 4,803,992 14,451,058 Beginning Available Resources 20,160,346 Cancellation of Prior Year Encumbrances 92,765 Ending Available Resources 25,057,103 Current Debt Service Due 3,213,164 Operating Reserve (63 Days) 5,164,395 Mngt Recom Operating Reserve (27 Days) 2,213,325 Capital Projects in Process - Non Bond 12,230,531 Prior Year Open Encumbrances - Non Cap 226,780 Reserved Resources 23,048,195 Total Non-Restricted Resources Available $ 2,008,908 Income (Loss) Before Transfers
Sewer
19
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Events Center Debt Service For the period ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Operating revenues: Charges for Services $ 0.00% -58.33% Miscellaneous 0.00% -58.33% Total operating revenues 0.00% -58.33% Operating Expenses: Personnel Services 0.00% -58.33% Other Services 316 (316) 0.00% -58.33% Supplies 0.00% -58.33% Capital Outlay 75,000 1,478,361 115,244 1,363,117 7.80% -50.53% Debt Service 5,173,844 5,173,844 2,153,076 3,020,768 41.61% -16.72% Other Expenses 0.00% -58.33% Total Operating Expenses 5,248,844 6,652,205 2,268,636 4,383,569 34.10% -24.23% Nonoperating Revenues (Expenses): Investment Income 35,006 35,006 0.00% -58.33% Miscellaneous Revenue (Expense) 0.00% -58.33% Sales Tax 5,173,844 5,173,844 1,100,062 (4,073,782) 21.26% -37.07% Total Nonoperating Revenue (Expenses) 5,173,844 5,173,844 1,135,068 (4,038,776) 0.00% -58.33% (75,000) (1,478,361) (1,133,568) 344,793 76.68% 18.35% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -58.33% Transfers In 75,000 75,000 75,000 0.00% -58.33% Transfers Out 0.00% -58.33% Total Transfers 75,000 75,000 75,000 0.00% -58.33% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (1,403,361) (1,133,568) 269,793 Unassigned Fund Balance at Beginning of Year (24,424,459) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year (1,101,503) Ending Unassigned Fund Balance, 01/31/21 (26,659,530) Restricted: Bond Reserve Project Accounts 6,827,684 Total restricted 6,827,684 Committed: Capital Projects In Process 1,363,117 Total Committed 1,363,117 Assigned: Prior Year Open Encumbrances - Excluding Capital Projects Current Year Open Encumbrances - Excluding Capital Projects Total Assigned Total Fund Balance $ (18,468,729) Income (Loss) Before Transfers
20
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Central Garage
For the period ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Operating revenues: Charges for Services $ 2,088,731 2,088,731 933,129 (1,155,602) 44.67% -13.66% Miscellaneous 2,508 2,508 0.00% -58.33% Total Operating Revenues 2,088,731 2,088,731 935,637 (1,153,094) 44.79% -13.54% Operating Expenses: Personal Services 754,502 754,502 404,123 350,379 53.56% -4.77% Other Services 550,811 547,411 484,291 63,120 88.47% 30.14% Supplies 768,986 772,386 407,211 365,175 52.72% -5.61% Capital Outlay 25,375 25,375 2,061 23,314 8.12% -50.21% Other Expenses 0.00% -58.33% Total Operating Expenses 2,099,674 2,099,674 1,297,686 801,988 61.80% 3.47% Nonoperating Revenues (Expenses): Investment Income 300 300 4,205 3,905 1401.67% 1343.34% Miscellaneous Revenue (Expense) 1,865 1,865 0.00% -58.33% Total Nonoperating Revenue (Expenses) 300 300 6,070 5,770 2023.33% 1965.00% (10,643) (10,643) (355,979) (345,336) 3344.72% 3286.39% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -58.33% Transfers In 0.00% -58.33% Transfers Out 0.00% -58.33% Total Transfers 0.00% -58.33% Change In Net Position (Budget Basis) $ (10,643) (10,643) (355,979) (345,336) 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 (70,275) Year-end investment market value adjustment Ending Unassigned Fund Balance GAAP Basis, 01/31/21 (1,624,436) Other Net Position Components: Assigned - Current Year Encumbrances 358,329 Assigned - Prior Year Encumbrances 20,096 Total Fund Balance $ (1,246,011) Income (Loss) Before Transfers
21
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Staywell Health Care
For the period ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Operating revenues: Charges for Services $ 14,532,190 14,532,190 10,546,879 (3,985,311) 72.58% 14.25% Miscellaneous 0.00% -58.33% Total Operating Revenues 14,532,190 14,532,190 10,546,879 (3,985,311) 72.58% 14.25% Operating Expenses: Personal Services 156,000 (156,000) 0.00% -58.33% Other Services 14,532,190 14,532,190 13,161,674 1,370,516 90.57% 32.24% Supplies 128 (128) 0.00% -58.33% Capital Outlay 0.00% -58.33% Other Expenses 0.00% -58.33% Total Operating Expenses 14,532,190 14,532,190 13,317,802 1,214,388 91.64% 33.31% Nonoperating Revenues (Expenses): Investment Income 3,197 3,197 0.00% -58.33% Miscellaneous Revenue (Expense) 845,065 845,065 0.00% -58.33% Total Nonoperating Revenue (Expenses) 848,262 848,262 0.00% -58.33% (1,922,661) (1,922,661) 0.00% -58.33% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -58.33% Transfers In 0.00% -58.33% Transfers Out 0.00% -58.33% Total Transfers 0.00% -58.33% Change In Net Position (Budget Basis) $ (1,922,661) (1,922,661) Unassigned Fund Balance at Beginning of Year 3,312,003 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year 63,600 Ending Unassigned Fund Balance GAAP Basis, 01/31/21 1,452,942 Other Net Position Components: Assigned - Current Year Encumbrances Assigned - Prior Year Encumbrances Total Fund Balance $ 1,452,942 Income (Loss) Before Transfers
22
CITY OF
INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule Workers' Compensation
For the period ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Operating revenues: Charges for Services $ 3,558,840 3,558,840 2,075,990 (1,482,850) 58.33% 0.00% Miscellaneous 1,102 1,102 0.00% -58.33% Total Operating Revenues 3,558,840 3,558,840 2,077,092 (1,481,748) 58.36% 0.03% Operating Expenses: Personal Services 21,000 21,000 21,000 0.00% -58.33% Other Services 4,500,000 4,500,000 1,827,953 2,672,047 40.62% -17.71% Supplies 4,000 4,000 4,000 0.00% -58.33% Capital Outlay 2,000 2,000 2,000 0.00% -58.33% Other Expenses 0.00% -58.33% Total Operating Expenses 4,527,000 4,527,000 1,827,953 2,699,047 40.38% -17.95% Nonoperating Revenues (Expenses): Investment Income 12,000 12,000 1,171 (10,829) 9.76% -48.57% Miscellaneous Revenue (Expense) 38,571 38,571 0.00% -58.33% Total Nonoperating Revenue (Expenses) 12,000 12,000 39,742 27,742 331.18% 272.85% (956,160) (956,160) 288,881 1,245,041 -30.21% -88.54% Transfers In 0.00% -58.33% Transfers Out 0.00% -58.33% Total Transfers 0.00% -58.33% Change In Net Position (Budget Basis) $ (956,160) (956,160) 288,881 1,245,041 Unassigned Fund Balance at Beginning of Year (8,552,971) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year (586,586) Year-end investment market value adjustment Ending Unassigned Fund Balance GAAP Basis, 01/31/21 (8,850,676) Other Net Position Components: Restricted - Work Comp Escrow Assigned - Current Year Encumbrances 59,950 Assigned - Prior Year Encumbrances 10,675 Total Fund Balance $ (8,780,051) Income (Loss) Before Transfers
23
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Risk Management
For the period ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Operating revenues: Charges for Services $ 2,991,000 2,991,000 1,495,500 (1,495,500) 50.00% -8.33% Miscellaneous 0.00% -58.33% Total Operating Revenues 2,991,000 2,991,000 1,495,500 (1,495,500) 50.00% -8.33% Operating Expenses: Personal Services 15,000 15,000 15,000 0.00% -58.33% Other Services 2,988,000 2,988,000 1,202,317 1,785,683 40.24% -18.09% Supplies 3,000 3,000 3,000 0.00% -58.33% Capital Outlay 0.00% -58.33% Other Expenses 0.00% -58.33% Total Operating Expenses 3,006,000 3,006,000 1,202,317 1,803,683 40.00% -18.33% Nonoperating Revenues (Expenses): Investment Income 5,410 5,410 0.00% -58.33% Miscellaneous Revenue (Expense) 0.00% -58.33% Total Nonoperating Revenue (Expenses) 5,410 5,410 0.00% -58.33% (15,000) (15,000) 298,593 313,593 -1990.62% -2048.95% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -58.33% Transfers In 0.00% -58.33% Transfers Out 0.00% -58.33% Total Transfers 0.00% -58.33% Change In Net Position (Budget Basis) $ (15,000) (15,000) 298,593 313,593 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, 01/31/21 871,876 Other Net Position Components: Assigned - Current Year Encumbrances 36,540 Assigned - Prior Year Encumbrances 732 Total Fund Balance $ 909,148 Income (Loss) Before Transfers
24
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Operating revenues: Charges for Services $ 1,430,000 1,430,000 715,000 (715,000) 50.00% -8.33% Miscellaneous 0.00% -58.33% Total Operating Revenues 1,430,000 1,430,000 715,000 (715,000) 50.00% -8.33% Operating Expenses: Personal Services 430,000 430,000 316,753 113,247 73.66% 15.33% Other Services 999,561 999,561 874,629 124,932 87.50% 29.17% Supplies 0.00% -58.33% Capital Outlay 4,596,317 (4,596,317) 0.00% -58.33% Other Expenses 0.00% -58.33% Total Operating Expenses 1,429,561 1,429,561 5,787,699 (4,358,138) 404.86% 346.53% Nonoperating Revenues (Expenses): Investment Income 200 200 (200) 0.00% -58.33% Miscellaneous Revenue (Expense) 0.00% -58.33% Total Nonoperating Revenue (Expenses) 200 200 (200) 0.00% -58.33% 639 639 (5,072,699) (5,073,338) -793849.61% -793907.94% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -58.33% Transfers In 0.00% -58.33% Transfers Out 0.00% -58.33% Total Transfers 0.00% -58.33% Change In Net Position (Budget Basis) $ 639 639 (5,072,699) (5,073,338) 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, 01/31/21 (6,062,763) Other Net Position Components: Assigned - Current Year Encumbrances 74,752 Assigned - Prior Year Encumbrances 100,397 Total Fund Balance $ (5,887,614) Income (Loss) Before Transfers
Budgetary Comparison Schedule Enterprise Resource Planning For the period ended January 31, 2021 25
CITY OF INDEPENDENCE, MISSOURI
CITY OF INDEPENDENCE, MISSOURI Budgetary
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Charges for Services $ 9,289 9,289 0.00% -58.33% Investment Income (Loss) 500 500 123 (377) 24.60% -33.73% Other Revenue 0.00% -58.33% Total Revenues 500 500 9,412 8,912 1882.40% 1824.07% Expenditures: General Government 0.00% -58.33% Debt Service 9,998 9,998 1,383 8,615 13.83% -44.50% Total Expenditures 9,998 9,998 1,383 8,615 13.83% -44.50% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total expenditures and other financing uses 9,998 9,998 1,383 8,615 13.83% -44.50% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (9,498) (9,498) 8,029 17,527 Unassigned Fund Balance at Beginning of Year 103,246 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 01/31/21 111,275 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 111,275
Comparison Schedule Debt Service - Neighborhood Improvement Districts For the period ended January 31, 2021 26
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Charges for Services $ 8,135 8,135 0.00% -58.33% Investment Income 1,132 1,132 0.00% -58.33% Intergovernmental 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 9,267 9,267 0.00% -58.33% Other Financing Sources: Transfers In 0.00% -58.33% Total Other Financing Sources 0.00% -58.33% Total Revenues and Other Financing Sources 9,267 9,267 0.00% -58.33% Expenditures: Public Works 0.00% -58.33% Culture and Recreation 0.00% -58.33% Capital Outlay 338,651 117,951 220,700 34.83% -23.50% Total Expenditures 338,651 117,951 220,700 34.83% -23.50% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 338,651 117,951 220,700 34.83% -23.50% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (338,651) (108,684) 229,967 Unassigned Fund Balance at Beginning of Year (51,591) Cancellation of Prior Year Encumbrances 7,507 Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 01/31/21 (152,768) Other Fund Balance Components: Committed - Current Year Encumbrances 117,951 Committed - Prior Year Encumbrances 72,244 Total Fund Balance $ 37,427
Comparison Schedule
Street Improvements Capital Project Fund For the period ended January 31, 2021 27
Budgetary
CITY OF INDEPENDENCE, MISSOURI
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Revolving Public Improvements Capital Project Fund For the period ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Charges for Services $ 0.00% -58.33% Investment Income (Loss) 165 165 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 165 165 0.00% -58.33% Expenditures: Public Works 0.00% -58.33% Culture and Recreation 0.00% -58.33% Capital Outlay 0.00% -58.33% Total Expenditures 0.00% -58.33% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 0.00% -58.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 165 165 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, 01/31/21 21,742 Other Fund Balance Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances Total Fund Balance $ 21,742
28
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Buildings
For
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Charges for Services $ 0.00% -58.33% Investment Income 10 10 0.00% -58.33% Other Revenue 5,289 5,289 0.00% -58.33% Total revenues 5,299 5,299 0.00% -58.33% Other Financing Sources: Transfers In 0.00% -58.33% Total Other Financing Sources 0.00% -58.33% Total Revenues and Other Financing Sources 5,299 5,299 0.00% -58.33% Expenditures: Public Works 0.00% -58.33% Culture and Recreation 0.00% -58.33% Capital Outlay 1,443,621 763,323 680,298 52.88% -5.45% Total Expenditures 1,443,621 763,323 680,298 0.00% -58.33% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total expenditures and other financing uses 1,443,621 763,323 680,298 52.88% -5.45% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (1,443,621) (758,024) 685,597 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, 01/31/21 (832,471) Other Fund Balance Components: Committed - Current Year Encumbrances 739,797 Committed - Prior Year Encumbrances 69,980 Total Fund Balance $ (22,694)
and Other Improvements Capital Project Fund
29
the period ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Charges for Services $ 0.00% -58.33% Investment Income 0.00% -58.33% Other Revenue 0.00% -58.33% Total revenues 0.00% -58.33% Expenditures: Public Works 0.00% -58.33% Culture and Recreation 0.00% -58.33% Capital Outlay 0.00% -58.33% Total Expenditures 0.00% -58.33% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total expenditures and other financing uses 0.00% -58.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, 01/31/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 January 31, 2021 30
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Park Improvements Capital Project Fund For the period ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Charges for Services $ 0.00% -58.33% Investment Income (Loss) 246 246 0.00% -58.33% Other Revenue 0.00% -58.33% Total revenues 246 246 0.00% -58.33% Expenditures: Public Works 0.00% -58.33% Culture and Recreation 0.00% -58.33% Capital Outlay 0.00% -58.33% Total Expenditures 0.00% -58.33% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total expenditures and other financing uses 0.00% -58.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 246 246 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, 01/31/21 31,672 Fund Balance Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances Total Fund Balance $ 31,672
31
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Charges for Services $ 16,600 16,600 (16,600) 0.00% -58.33% Investment Income 103 103 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 16,600 16,600 103 (16,497) 0.62% -57.71% Expenditures: Public Works 0.00% -58.33% Culture and Recreation 18,209 18,209 4,600 13,609 25.26% -33.07% Capital Outlay 0.00% -58.33% Total Expenditures 18,209 18,209 4,600 13,609 25.26% -33.07% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 18,209 18,209 4,600 13,609 25.26% -33.07% Excess of revenues over (under) expenditures and Other Financing Uses, Budget Basis $ (1,609) (1,609) (4,497) (2,888) 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, 01/31/21 4,998 Other Net Position Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances Total Net Position $ 4,998
Private Purpose Expendable Trust Fund - Vaile Mansion For the period ended January 31, 2021 32
Schedule
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Independence Events Center CID For the period ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Sales Taxes $ 7,700,767 7,700,767 3,962,746 (3,738,021) 51.46% -6.87% Investment Income 128,715 128,715 9,817 (118,898) 7.63% -50.70% Total Revenues 7,829,482 7,829,482 3,972,563 (3,856,919) 50.74% -7.59% Expenditures: Administrative Fee 154,015 154,015 79,255 74,760 51.46% -6.87% Insurance 2,150 2,150 2,150 0.00% -58.33% Legal 44,850 44,850 44,850 0.00% -58.33% Audit 5,150 5,150 5,150 100.00% 41.67% Banking 5,916 5,916 3,779 2,137 63.88% 5.55% Contract Services 310,500 310,500 300,000 10,500 96.62% 38.29% Capital Outlay 0.00% -58.33% Other 0.00% -58.33% Total Expenditures 522,581 522,581 388,184 134,397 74.28% 15.95% Other Financing Uses: Transfers Out - EATS (75,000) (75,000) (75,000) 0.00% -58.33% Transfers Out - Debt Service (City) (5,173,844) (5,173,844) (1,100,062) (4,073,782) 21.26% -37.07% Total Other Financing Uses (5,248,844) (5,248,844) (1,100,062) (4,148,782) 20.96% -37.37% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 2,058,057 2,058,057 2,484,317 426,260 Unassigned Fund Balance at Beginning of Year 7,010,144 Cancellation of Prior Year Encumbrances 23,225 Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 01/31/21 9,517,686 Other Fund Balance Components: Restricted - current year encumbrances Restricted - prior year encumbrances 7,500 Total Fund Balance $ 9,525,186
33
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Sales taxes $ — — 234,209 234,209 0.00% -58.33% Investment income — — 121 121 0.00% -58.33% Total revenues — — 234,330 234,330 0.00% -58.33% Expenditures: Administrative fee — — 4,684 (4,684) 0.00% -58.33% Insurance 2,000 2,000 2,132 (132) 106.60% 48.27% Legal — — 1,250 (1,250) 0.00% -58.33% Audit 4,700 4,700 5,150 (450) 109.57% 51.24% Banking — — 203 (203) 0.00% -58.33% Contract services — — — — 0.00% -58.33% Capital outlay — — — — 0.00% -58.33% Other — — — — 0.00% -58.33% Total expenditures 6,700 6,700 13,419 (6,719) 200.28% 141.95% Other financing uses: Transfers out - EATS (248,491) (248,491) (117,104) (131,387) 47.13% -11.20% Transfers out - Debt Service (City) (215,000) (215,000) (86,000) (129,000) 40.00% -18.33% Total other financing uses (463,491) (463,491) (203,104) (260,387) 43.82% -14.51% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (470,191) (470,191) 17,807 487,998 Unassigned Fund Balance at Beginning of Year 82,217 Cancellation of Prior Year Encumbrances — Change in Other Fund Balance Components During the Year (293) Unassigned Ending Fund Balance, 01/31/21 99,731 Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Restricted - City Transportation 6,079 Total Fund Balance $ 105,810
Budgetary
Schedule Crackerneck Creek TDD For the period ended January 31, 2021 34
CITY OF INDEPENDENCE, MISSOURI
Comparison
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Tax
For
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 16,229,006 16,228,916 15,298,010 (930,906) 94.26% 35.93% Investment Income (Loss) 176,822 176,822 0.00% -58.33% Other revenue 1,310,958 1,310,958 858,818 (452,140) 65.51% 7.18% Total Revenues 17,539,964 17,539,874 16,333,650 (1,206,224) 93.12% 34.79% Other Financing Sources: Transfers In 1,327,471 1,327,471 (1,327,471) 0.00% -58.33% Total Other Financing Sources 1,327,471 1,327,471 (1,327,471) 0.00% -58.33% Total Revenues and Other Financing Sources 18,867,435 18,867,345 16,333,650 (2,533,695) 86.57% 28.24% Expenditures: Tax Increment Financing 1,792,897 1,792,897 19,609 1,773,288 1.09% -57.24% Debt Service Principal 9,594,866 10,081,215 158,147 9,923,068 1.57% -56.76% Interest and Fiscal Agent Fees 5,587,948 5,587,948 2,773,851 2,814,097 49.64% -8.69% Debt Issuance Costs 0.00% -58.33% Total Expenditures 16,975,711 17,462,060 2,951,607 14,510,453 16.90% -41.43% Other Financing Uses: Issuance of Debt 0.00% -58.33% Reoffering Premium/Original Issue Discount 0.00% -58.33% Payment to Refund Loans Escrow Agent 0.00% -58.33% Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 16,975,711 17,462,060 2,951,607 14,510,453 16.90% -41.43% Excess of Revenues Over (Under) Expenditures and other financing uses $ 1,891,724 1,405,285 13,382,043 11,976,758 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, 01/31/21 32,131,357 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances 15,226 Restricted - Trust Debt Service 12,333,319 Total Fund Balance $ 44,479,902
Increment Financing Summary
35
the Period Ended January 31, 2021
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 0.00% -58.33% Investment Income (Loss) 12 12 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 12 12 0.00% -58.33% Expenditures: Tax Increment Financing 0.00% -58.33% Debt Service Principal 0.00% -58.33% Interest and Fiscal Agent Fees 0.00% -58.33% Debt Issuance Costs 0.00% -58.33% Total Expenditures 0.00% -58.33% Other Financing Uses: Issuance of Debt 0.00% -58.33% Reoffering Premium/Original Issue Discount 0.00% -58.33% Payment to Refund Loans Escrow Agent 0.00% -58.33% Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 0.00% -58.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 12 12 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, 01/31/21 1,584 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 1,584
TIF
Mid-Town Truman Rd
36
For the Period Ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 257,999 257,999 (1,621) (259,620) -0.63% -58.96% Investment Income (Loss) 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 257,999 257,999 (1,621) (259,620) -0.63% -58.96% Expenditures: Tax Increment Financing 3,822 3,822 3,822 0.00% -58.33% Debt Service Principal 50,950 50,950 50,950 0.00% -58.33% Interest and Fiscal Agent Fees 203,227 203,227 203,227 0.00% -58.33% Debt Issuance Costs 0.00% -58.33% Total Expenditures 257,999 257,999 257,999 0.00% -58.33% Other Financing Uses: Issuance of Debt 0.00% -58.33% Reoffering Premium/Original Issue Discount 0.00% -58.33% Payment to Refund Loans Escrow Agent 0.00% -58.33% Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 257,999 257,999 257,999 0.00% -58.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (1,621) (1,621) 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, 01/31/21 14,101 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 14,101
Comparison Schedule RSO TIF For the Period Ended January 31, 2021 37
CITY OF INDEPENDENCE, MISSOURI Budgetary
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 26,271 26,271 27,260 989 103.76% 45.43% Investment Income (Loss) (23) (23) 0.00% -58.33% Other Revenue 102,958 102,958 44,214 (58,744) 42.94% -15.39% Total Revenues 129,229 129,229 71,451 (57,778) 55.29% -3.04% Other Financing Sources: Transfers In 187,942 187,942 (187,942) 0.00% -58.33% Total Other Financing Sources 187,942 187,942 (187,942) 0.00% -58.33% Total Revenues and Other Financing Sources 317,171 317,171 71,451 (245,720) 22.53% -35.80% Expenditures: Tax Increment Financing 7,801 7,801 3,000 4,801 38.46% -19.87% Debt Service Principal 190,000 190,000 95,000 95,000 50.00% -8.33% Interest and Fiscal Agent Fees 339,938 339,938 167,831 172,107 49.37% -8.96% Debt Issuance Costs 0.00% -58.33% Total Expenditures 537,739 537,739 265,831 271,908 49.43% -8.90% Other Financing Uses: Issuance of Debt 0.00% -58.33% Reoffering Premium/Original Issue Discount 0.00% -58.33% Payment to Refund Loans Escrow Agent 0.00% -58.33% Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 537,739 537,739 265,831 271,908 49.43% -8.90% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (220,568) (220,568) (194,380) 26,188 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, 01/31/21 (1,401,274) Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 557,834 Total Fund Balance $ (843,440)
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Santa Fe TIF For the Period Ended January 31, 2021 38
CITY
CITY
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 1,446,920 1,446,920 1,379,870 (67,050) 95.37% 37.04% Investment Income (Loss) 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 1,446,920 1,446,920 1,379,870 (67,050) 95.37% 37.04% Other Financing Sources: Transfers In 118,097 118,097 (118,097) 0.00% -58.33% Total Other Financing Sources 118,097 118,097 (118,097) 0.00% -58.33% Total Revenues and Other Financing Sources 1,565,017 1,565,017 1,379,870 (185,147) 88.17% 29.84% Expenditures: Tax Increment Financing 121,261 121,261 121,261 0.00% -58.33% Debt Service Principal 1,630,000 1,630,000 1,630,000 0.00% -58.33% Interest and Fiscal Agent Fees 140,068 140,068 37,434 102,634 26.73% -31.60% Debt Issuance Costs 0.00% -58.33% Total Expenditures 1,891,329 1,891,329 37,434 1,853,895 1.98% -56.35% Other Financing Uses: Issuance of Debt 0.00% -58.33% Reoffering Premium/Original Issue Discount 0.00% -58.33% Payment to Refund Loans Escrow Agent 0.00% -58.33% Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 1,891,329 1,891,329 37,434 1,853,895 1.98% -56.35% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (326,312) (326,312) 1,342,436 1,668,748 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, 01/31/21 (1,155,758) Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ (1,155,758)
Hartman Heritage TIF For the Period Ended January 31, 2021 39
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 568,730 568,730 525,657 (43,073) 92.43% 34.10% Investment Income (Loss) 14,152 14,152 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 568,730 568,730 539,809 (28,921) 94.91% 36.58% Expenditures: Tax Increment Financing 15,338 15,338 1,250 14,088 8.15% -50.18% Debt Service Principal 385,000 385,000 385,000 0.00% -58.33% Interest and Fiscal Agent Fees 36,150 36,150 12,300 23,850 34.02% -24.31% Debt Issuance Costs 0.00% -58.33% Total Expenditures 436,488 436,488 13,550 422,938 3.10% -55.23% Other Financing Uses: Issuance of Debt 0.00% -58.33% Reoffering Premium/Original Issue Discount 0.00% -58.33% Payment to Refund Loans Escrow Agent 0.00% -58.33% Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 436,488 436,488 13,550 422,938 3.10% -55.23% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 132,242 132,242 526,259 394,017 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, 01/31/21 2,367,921 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 2,367,921
OF INDEPENDENCE,
Budgetary Comparison Schedule Drumm Farm TIF For the Period Ended January 31, 2021 40
CITY
MISSOURI
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 5,053,492 5,053,492 4,207,462 (846,030) 83.26% 24.93% Investment Income (Loss) 95,866 95,866 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 5,053,492 5,053,492 4,303,328 (750,164) 85.16% 26.83% Other Financing Sources: Transfers In 664,783 664,783 (664,783) 0.00% -58.33% Total Other Financing Sources 664,783 664,783 (664,783) 0.00% -58.33% Total Revenues and Other Financing Sources 5,718,275 5,718,275 4,303,328 (1,414,947) 75.26% 16.93% Expenditures: Tax Increment Financing 457,612 457,612 1,250 456,362 0.27% -58.06% Debt Service Principal 2,870,000 2,870,000 2,870,000 0.00% -58.33% Interest and Fiscal Agent Fees 115 115 145,825 (145,710) 126804.35% 126746.02% Debt Issuance Costs 0.00% -58.33% Total Expenditures 3,327,727 3,327,727 147,075 3,180,652 4.42% -53.91% Other Financing Uses: Issuance of Debt 0.00% -58.33% Reoffering Premium/Original Issue Discount 0.00% -58.33% Payment to Refund Loans Escrow Agent 0.00% -58.33% Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 3,327,727 3,327,727 147,075 3,180,652 4.42% -53.91% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 2,390,548 2,390,548 4,156,253 1,765,705 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, 01/31/21 16,448,906 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 897,693 Total Fund Balance $ 17,346,599
Budgetary Comparison Schedule Eastland TIF For
41
CITY OF INDEPENDENCE, MISSOURI
the Period Ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 57,965 57,965 39,057 (18,908) 67.38% 9.05% Investment Income (Loss) 460 460 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 57,965 57,965 39,517 (18,448) 68.17% 9.84% Expenditures: Tax Increment Financing 1,645 1,645 1,645 0.00% -58.33% Debt Service Principal 10,000 10,000 10,000 0.00% -58.33% Interest and Fiscal Agent Fees 45,530 45,530 45,530 0.00% -58.33% Debt Issuance Costs 0.00% -58.33% Total Expenditures 57,175 57,175 57,175 0.00% -58.33% Other Financing Uses: Issuance of Debt 0.00% -58.33% Reoffering Premium/Original Issue Discount 0.00% -58.33% Payment to Refund Loans Escrow Agent 0.00% -58.33% Transfers Out 0.00% -58.33% 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 57,175 57,175 57,175 0.00% -58.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 790 790 39,517 38,727 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, 01/31/21 71,450 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 71,450
Schedule North Independence TIF For the Period Ended January 31, 2021 42
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Mt Washington TIF
For the Period Ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 2,179 2,179 1,992 (187) 91.42% 33.09% Investment Income (Loss) 361 361 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 2,179 2,179 2,353 174 107.99% 49.66% Other Financing Sources: Transfers In 0.00% -58.33% Capital lease proceeds 0.00% Total Other Financing Sources 0.00% -58.33% Total Revenues and Other Financing Sources 2,179 2,179 2,353 174 107.99% 49.66% Expenditures: Tax Increment Financing 63 63 63 0.00% -58.33% Debt Service Principal 0.00% -58.33% Interest and Fiscal Agent Fees 0.00% -58.33% Debt Issuance Costs 0.00% -58.33% Total Expenditures 63 63 63 0.00% -58.33% Other Financing Uses: Issuance of Debt 0.00% -58.33% Reoffering Premium/Original Issue Discount 0.00% -58.33% Payment to Refund Loans Escrow Agent 0.00% -58.33% Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 63 63 63 0.00% -58.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 2,116 2,116 2,353 237 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, 01/31/21 49,741 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 49,741
43
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
For the Period Ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 1,589,201 1,589,201 1,079,134 (510,067) 67.90% 9.57% Investment Income (Loss) 43,288 43,288 0.00% -58.33% Other Revenue 1,208,000 1,208,000 814,604 (393,396) 67.43% 9.10% Total Revenues 2,797,201 2,797,201 1,937,026 (860,175) 69.25% 10.92% Other Financing Sources: Transfers In 315,000 315,000 (315,000) 0.00% -58.33% Total Other Financing Sources 315,000 315,000 (315,000) 0.00% -58.33% Total Revenues and Other Financing Sources 3,112,201 3,112,201 1,937,026 (1,175,175) 62.24% 3.91% Expenditures: Tax Increment Financing 48,817 48,817 11,840 36,977 24.25% -34.08% Debt Service Principal 50,000 50,000 50,000 0.00% -58.33% Interest and Fiscal Agent Fees 3,779,920 3,779,920 1,888,786 1,891,134 49.97% -8.36% Debt Issuance Costs 0.00% -58.33% Total Expenditures 3,878,737 3,878,737 1,900,626 1,978,111 49.00% -9.33% Other Financing Uses: Issuance of Debt 0.00% -58.33% Reoffering Premium/Original Issue Discount 0.00% -58.33% Payment to Refund Loans Escrow Agent 0.00% -58.33% Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 3,878,737 3,878,737 1,900,626 1,978,111 49.00% -9.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (766,536) (766,536) 36,400 802,936 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, 01/31/21 5,925,936 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances 15,226 Restricted - Trust Debt Service 7,522,922 Total Fund Balance $ 13,464,084
Crackerneck Creek TIF
44
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule
Old Landfill TIF
For the Period Ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 496,239 496,239 637,343 141,104 128.43% 70.10% Investment Income (Loss) 3,750 3,750 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 496,239 496,239 641,093 144,854 129.19% 70.86% Expenditures: Tax Increment Financing 9,590 9,590 9,590 0.00% -58.33% Debt Service 486,349 Principal 486,349 486,349 0.00% -58.33% Interest and Fiscal Agent Fees 0.00% -58.33% Debt Issuance Costs 0.00% -58.33% Total Expenditures 495,939 495,939 495,939 0.00% -58.33% Other Financing Uses: Issuance of Debt 0.00% -58.33% Reoffering Premium/Original Issue Discount 0.00% -58.33% Payment to Refund Loans Escrow Agent 0.00% -58.33% Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 495,939 495,939 495,939 0.00% -58.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 300 300 641,093 640,793 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, 01/31/21 645,035 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 645,035
45
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Trinity TIF
For the Period Ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 489,107 489,107 381,782 (107,325) 78.06% 19.73% Investment Income (Loss) 22 22 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 489,107 489,107 381,804 (107,303) 78.06% 19.73% Other Financing Sources: Transfers In 32,466 32,466 (32,466) 0.00% -58.33% Total Other Financing Sources 32,466 32,466 (32,466) 0.00% -58.33% Total Revenues and Other Financing Sources 521,573 521,573 381,804 (139,769) 73.20% 14.87% Expenditures: Tax Increment Financing 11,267 11,267 11,267 0.00% -58.33% Debt Service Principal 510,360 510,360 510,360 0.00% -58.33% Interest and Fiscal Agent Fees 0.00% -58.33% Debt Issuance Costs 0.00% -58.33% Total Expenditures 521,627 521,627 521,627 0.00% -58.33% Other Financing Uses: Issuance of Debt 0.00% -58.33% Reoffering Premium/Original Issue Discount 0.00% -58.33% Payment to Refund Loans Escrow Agent 0.00% -58.33% Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 521,627 521,627 521,627 0.00% -58.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (54) (54) 381,804 381,858 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, 01/31/21 254,034 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 254,034
46
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 3,589,345 3,589,345 4,569,973 980,628 127.32% 68.99% Investment Income (Loss) 9,666 9,666 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 3,589,345 3,589,345 4,579,639 990,294 127.59% 69.26% Other Financing Sources: Transfers In 9,183 9,183 (9,183) 0.00% -58.33% Total Other Financing Sources 9,183 9,183 (9,183) 0.00% -58.33% Total Revenues and Other Financing Sources 3,598,528 3,598,528 4,579,639 981,111 127.26% 68.93% Expenditures: Tax Increment Financing 550,170 550,170 1,250 548,920 0.23% -58.10% Debt Service Principal 1,950,000 1,950,000 1,950,000 0.00% -58.33% Interest and Fiscal Agent Fees 1,043,000 1,043,000 477,675 565,325 45.80% -12.53% Debt Issuance Costs 0.00% -58.33% Total Expenditures 3,543,170 3,543,170 478,925 3,064,245 13.52% -44.81% Other Financing Uses: Issuance of Debt 0.00% -58.33% Reoffering Premium/Original Issue Discount 0.00% -58.33% Payment to Refund Loans Escrow Agent 0.00% -58.33% Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 3,543,170 3,543,170 478,925 3,064,245 13.52% -44.81% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 55,358 55,358 4,100,714 4,045,356 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, 01/31/21 5,353,535 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 3,354,870 Total Fund Balance $ 8,708,405
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule HCA TIF For the Period Ended January 31, 2021 47
CITY
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule
Cinema East TIF
For the Period Ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 257,861 257,861 169,470 (88,391) 65.72% 7.39% Investment Income (Loss) 14 14 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 257,861 257,861 169,484 (88,377) 65.73% 7.40% Expenditures: Tax Increment Financing 5,139 5,139 5,139 0.00% -58.33% Debt Service Principal 252,902 252,902 252,902 0.00% -58.33% Interest and Fiscal Agent Fees 44,000 (44,000) 0.00% -58.33% Debt Issuance Costs 0.00% -58.33% Total Expenditures 258,041 258,041 44,000 214,041 17.05% -41.28% Other Financing Uses: Issuance of Debt 0.00% -58.33% Reoffering Premium/Original Issue Discount 0.00% -58.33% Payment to Refund Loans Escrow Agent 0.00% -58.33% Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 258,041 258,041 44,000 214,041 17.05% -41.28% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (180) (180) 125,484 125,664 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, 01/31/21 161,596 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 161,596
48
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
23rd & Noland Project 1 TIF
For the Period Ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 82,194 82,194 54,094 (28,100) 65.81% 7.48% Investment Income (Loss) 16 16 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 82,194 82,194 54,110 (28,084) 65.83% 7.50% Expenditures: Tax Increment Financing 2,063 2,063 2,063 0.00% -58.33% Debt Service Principal 80,131 80,131 15,000 65,131 18.72% -39.61% Interest and Fiscal Agent Fees 0.00% -58.33% Debt Issuance Costs 0.00% -58.33% Total Expenditures 82,194 82,194 15,000 67,194 18.25% -40.08% Other Financing Uses: Issuance of Debt 0.00% -58.33% Reoffering Premium/Original Issue Discount 0.00% -58.33% Payment to Refund Loans Escrow Agent 0.00% -58.33% Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 82,194 82,194 15,000 67,194 18.25% -40.08% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 39,110 39,110 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, 01/31/21 66,074 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 66,074
49
CITY
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 11,729 11,729 12,091 362 103.09% 44.76% Investment Income (Loss) 9 9 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 11,729 11,729 12,100 371 103.16% 44.83% Expenditures: Tax Increment Financing 246 246 246 0.00% -58.33% Debt Service Principal 11,483 11,483 11,483 0.00% -58.33% Interest and Fiscal Agent Fees 0.00% -58.33% Debt Issuance Costs 0.00% -58.33% Total Expenditures 11,729 11,729 11,729 0.00% -58.33% Other Financing Uses: Issuance of Debt 0.00% -58.33% Reoffering Premium/Original Issue Discount 0.00% -58.33% Payment to Refund Loans Escrow Agent 0.00% -58.33% Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 11,729 11,729 11,729 0.00% -58.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 12,100 12,100 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, 01/31/21 14,441 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 14,441
Noland
Period
50
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule 23rd &
Project 2 TIF For the
Ended January 31, 2021
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
23rd & Noland Project 3 TIF
For the Period Ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 24,438 24,438 14,441 (9,997) 59.09% 0.76% Investment Income (Loss) — — 8 8 0.00% -58.33% Other Revenue — — — — 0.00% -58.33% Total Revenues 24,438 24,438 14,449 (9,989) 59.13% 0.80% Expenditures: Tax Increment Financing 24,438 24,438 — 24,438 0.00% -58.33% Debt Service Principal — — — — 0.00% -58.33% Interest and Fiscal Agent Fees — — — — 0.00% -58.33% Debt Issuance Costs — — — — 0.00% -58.33% Total Expenditures 24,438 24,438 — 24,438 0.00% -58.33% Other Financing Uses: Issuance of Debt — — — — 0.00% -58.33% Reoffering Premium/Original Issue Discount — — — — 0.00% -58.33% Payment to Refund Loans Escrow Agent — — — — 0.00% -58.33% Transfers Out — — — — 0.00% -58.33% Total Other Financing Uses — — — — 0.00% -58.33% Total Expenditures and Other Financing Uses 24,438 24,438 — 24,438 0.00% -58.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ — — 14,449 14,449 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, 01/31/21 21,837 Other Fund Balance Components: Restricted - Current Year Encumbrances — Restricted - Prior Year Encumbrances — Restricted - Trust Debt Service — Total Fund Balance $ 21,837
51
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
23rd & Noland Project 4 TIF
For the Period Ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 462,503 462,503 263,552 (198,951) 56.98% -1.35% Investment Income (Loss) 82 82 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 462,503 462,503 263,634 (198,869) 57.00% -1.33% Expenditures: Tax Increment Financing 462,503 462,503 462,503 0.00% -58.33% Debt Service Principal 0.00% -58.33% Interest and Fiscal Agent Fees 0.00% -58.33% Debt Issuance Costs 0.00% -58.33% Total Expenditures 462,503 462,503 462,503 0.00% -58.33% Other Financing Uses: Issuance of Debt 0.00% -58.33% Reoffering Premium/Original Issue Discount 0.00% -58.33% Payment to Refund Loans Escrow Agent 0.00% -58.33% Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 462,503 462,503 462,503 0.00% -58.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 263,634 263,634 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, 01/31/21 355,050 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 355,050
52
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Independence Square TIF
For the Period Ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 145,470 145,470 265,771 120,301 182.70% 124.37% Investment Income (Loss) 5,832 5,832 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 145,470 145,470 271,603 126,133 186.71% 128.38% Expenditures: Tax Increment Financing 7,799 7,799 7,799 0.00% -58.33% Debt Service Principal 0.00% -58.33% Interest and Fiscal Agent Fees 0.00% -58.33% Debt Issuance Costs 0.00% -58.33% Total Expenditures 7,799 7,799 7,799 0.00% -58.33% Other Financing Uses: Issuance of Debt 0.00% -58.33% Reoffering Premium/Original Issue Discount 0.00% -58.33% Payment to Refund Loans Escrow Agent 0.00% -58.33% Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 7,799 7,799 7,799 0.00% -58.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 137,671 137,671 271,603 133,932 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, 01/31/21 829,316 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 829,316
53
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule
I-70 & Little Blue Parkway Project 1 TIF
For the Period Ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 1,152,029 1,152,029 1,189,548 37,519 103.26% 44.93% Investment Income (Loss) 311 311 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 1,152,029 1,152,029 1,189,859 37,830 103.28% 44.95% Expenditures: Tax Increment Financing 23,927 23,927 23,927 0.00% -58.33% Debt Service Principal 1,128,102 1,128,102 48,147 1,079,955 4.27% -54.06% Interest and Fiscal Agent Fees 0.00% -58.33% Debt Issuance Costs 0.00% -58.33% Total Expenditures 1,152,029 1,152,029 48,147 1,103,882 4.18% -54.15% Other Financing Uses: Issuance of Debt 0.00% -58.33% Reoffering Premium/Original Issue Discount 0.00% -58.33% Payment to Refund Loans Escrow Agent 0.00% -58.33% Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 1,152,029 1,152,029 48,147 1,103,882 4.18% -54.15% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 1,141,712 1,141,712 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, 01/31/21 1,510,445 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 1,510,445
54
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
I-70 & Little Blue Parkway Project 3 TIF For the Period Ended January 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 382,156 382,156 317,442 (64,714) 83.07% 24.74% Investment Income (Loss) 2,941 2,941 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 382,156 382,156 320,383 (61,773) 83.84% 25.51% Expenditures: Tax Increment Financing 0.00% -58.33% Debt Service Principal 382,156 382,156 382,156 0.00% -58.33% Interest and Fiscal Agent Fees 0.00% -58.33% Debt Issuance Costs 0.00% -58.33% Total Expenditures 382,156 382,156 382,156 0.00% -58.33% Other Financing Uses: Issuance of Debt 0.00% -58.33% Reoffering Premium/Original Issue Discount 0.00% -58.33% Payment to Refund Loans Escrow Agent 0.00% -58.33% Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 382,156 382,156 382,156 0.00% -58.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 320,383 320,383 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, 01/31/21 390,212 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 390,212
55
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 97,731 97,731 61,480 (36,251) 62.91% 4.58% Investment Income (Loss) 28 28 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 97,731 97,731 61,508 (36,223) 62.94% 4.61% Expenditures: Tax Increment Financing 3,949 3,949 3,949 0.00% -58.33% Debt Service Principal 93,782 93,782 93,782 0.00% -58.33% Interest and Fiscal Agent Fees 0.00% -58.33% Debt Issuance Costs 0.00% -58.33% Total Expenditures 97,731 97,731 97,731 0.00% -58.33% Other Financing Uses: Issuance of Debt 0.00% -58.33% Reoffering Premium/Original Issue Discount 0.00% -58.33% Payment to Refund Loans Escrow Agent 0.00% -58.33% Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 97,731 97,731 97,731 0.00% -58.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 61,508 61,508 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, 01/31/21 92,101 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 92,101
Marketplace Project 1 TIF
56
For the Period Ended January 31, 2021
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 35,447 35,447 102,212 66,765 288.35% 230.02% Investment Income (Loss) 27 27 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 35,447 35,447 102,239 66,792 288.43% 230.10% Expenditures: Tax Increment Financing 35,447 35,447 719 34,728 2.03% -56.30% Debt Service Principal 0.00% -58.33% Interest and Fiscal Agent Fees 0.00% -58.33% Debt Issuance Costs 0.00% -58.33% Total Expenditures 35,447 35,447 719 34,728 2.03% -56.30% Other Financing Uses: Issuance of Debt 0.00% -58.33% Reoffering Premium/Original Issue Discount 0.00% -58.33% Payment to Refund Loans Escrow Agent 0.00% -58.33% Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 35,447 35,447 719 34,728 2.03% -56.30% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 101,520 101,520 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, 01/31/21 139,548 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 139,548
Period
57
Marketplace Project 2 TIF For the
Ended January 31, 2021
CITY
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 58.33% of Year Budget Revenues: Taxes $ 0.00% -58.33% Investment Income (Loss) 0.00% -58.33% Other Revenue 0.00% -58.33% Total Revenues 0.00% -58.33% Expenditures: Tax Increment Financing 300 (300) 0.00% -58.33% Debt Service Principal 0.00% -58.33% Interest and Fiscal Agent Fees 0.00% -58.33% Debt Issuance Costs 0.00% -58.33% Total Expenditures 300 (300) 0.00% -58.33% Other Financing Uses: Issuance of Debt 0.00% -58.33% Reoffering Premium/Original Issue Discount 0.00% -58.33% Payment to Refund Loans Escrow Agent 0.00% -58.33% Transfers Out 0.00% -58.33% Total Other Financing Uses 0.00% -58.33% Total Expenditures and Other Financing Uses 300 (300) 0.00% -58.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (300) (300) 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, 01/31/21 (24,474) Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ (24,474)
Application Fees
the Period Ended January 31, 2021 58
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule TIF
For