Monthly Financial and Operating Report March 2021
Table of Contents General Fund 1 Sales Tax Funds Street Improvements Sales Tax Fund 2 Park Improvements Sales Tax Fund 3 Storm Water Sales Tax Fund 4 Police Public Safety Sales Tax Fund 5 Fire Public Safety Sales Tax Fund 6 Use Tax Funds Animal Shelter 7 Police 8 Property Tax Levy Funds Health Property Tax Levy 9 Parks and Recreation Property Tax Levy 10 Special Revenue Funds Tourism Fund 11 Independence Square Benefit District 12 Community Development Block Grant Fund 13 Rental Rehabilitation 14 License Surcharge 15 Grants 16 CARES Act 17 Enterprise Funds Power and Light 18 - 19 Water 20 - 21 Water Pollution Control 22 - 23 Events Center Debt Service 24 Internal Service Funds Central Garage 25 Staywell Health Care 26 Worker's Compensation 27 Risk Management 28 Enterprise Resource Planning 29 Debt Service Fund Debt Service - Neighborhood Improvement Districts 30 Capital Improvement Funds Street Improvements Capital Project Fund 31 Revolving Public Improvements Capital Project Fund 32 Building and Other Improvements Capital Project Fund 33 Storm Drainage Capital Project Fund 34 Park Improvements Capital Project Fund 35 Private Purpose Expendable Trust Fund - Vaile Mansion 36 Independence Events Center CID 37 Crackerneck Creek TDD 38 Tax Increment Financing Summary 39 Mid-Town Truman Rd TIF 40 RSO TIF 41 Santa Fe TIF 42 Hartman Heritage TIF 43 Drumm Farm TIF 44 Eastland TIF 45 North Independence TIF 46 Mt Washington TIF 47 Crackerneck Creek TIF 48 Old Landfill TIF 49 Trinity TIF 50 HCA TIF 51 Cinema East TIF 52 23rd & Noland Project 1 TIF 53 23rd & Noland Project 2 TIF 54 23rd & Noland Project 3 TIF 55 23th & Noland Project 4 TIF 56 Independence Square TIF 57 I-70 & Little Blue Parkway Project 1 TIF 58 I-70 & Little Blue Parkway Project 3 TIF 59 Marketplace Project 1 TIF 60 Marketplace Project 2 TIF 61 TIF Application Fees 62
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule General Fund
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 31,453,100 31,453,100 25,896,949 (5,556,151) 82.34% 7.34% Licenses and Permits 4,392,069 4,432,069 3,380,298 (1,051,771) 76.27% 1.27% Intergovernmental 5,262,150 5,262,150 4,008,511 (1,253,639) 76.18% 1.18% Charges for Current Services 2,058,050 2,150,529 1,054,205 (1,096,324) 49.02% -25.98% Interfund Charges for Support Services 5,035,500 5,035,500 3,776,625 (1,258,875) 75.00% 0.00% Fines and Forfeitures 3,771,000 3,771,000 1,600,647 (2,170,353) 42.45% -32.55% Investment Income (Loss) 175,000 175,000 135,375 (39,625) 77.36% 2.36% Other Revenue 2,493,532 890,090 927,011 36,921 104.15% 29.15% Total Revenues 54,640,401 53,169,438 40,779,621 (12,389,817) 76.70% 1.70% Other Financing Sources: Payments In Lieu of Taxes 19,796,612 19,796,612 14,494,742 (5,301,870) 73.22% -1.78% Operating Transfers In - CARES Act 808,036 808,036 0.00% -75.00% Total Other Financing Sources 19,796,612 19,796,612 15,302,778 (4,493,834) 77.30% 2.30% Total Revenues and Other Financing Sources 74,437,013 72,966,050 56,082,399 (16,883,651) 76.86% 1.86% Expenditures: City Council 680,553 680,553 471,276 209,277 69.25% -5.75% City Clerk 195,240 195,240 146,076 49,164 74.82% -0.18% City Manager 1,187,339 1,187,339 843,670 343,669 71.06% -3.94% Municipal Court 1,207,254 1,207,254 821,779 385,475 68.07% -6.93% Law 661,301 661,301 498,296 163,005 75.35% 0.35% Finance 5,295,645 5,295,645 3,738,647 1,556,998 70.60% -4.40% Community Development 5,653,911 4,079,379 3,428,536 650,843 84.05% 9.05% Police 31,553,037 31,651,852 23,137,108 8,514,744 73.10% -1.90% Fire 21,181,684 21,181,684 17,115,989 4,065,695 80.81% 5.81% Public Works 4,775,106 4,779,860 4,372,115 407,745 91.47% 16.47% COVID Reserve 1,468,971 1,468,971 1,468,971 0.00% -75.00% Debt service 566,972 566,972 4,392 562,580 0.77% -74.23% Total Expenditures 74,427,013 72,956,050 54,577,884 18,378,166 74.81% -0.19% Other Financing Uses: Transfers Out 10,000 10,000 35,300 (25,300) 353.00% 278.00% Total Expenditures and Other Financing Uses 74,437,013 72,966,050 54,613,184 18,352,866 74.85% -0.15% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 1,469,215 1,469,215 Unassigned Fund Balance at Beginning of Year 5,301,516 Cancellation of prior year encumbrances 19,876 Change in other fund balance components during the year (125,500) Year-end investment market value adjustment Ending Unassigned Fund Balance, 03/31/21 6,665,107 Restricted 217,953 Committed 28,342 Assigned 1,649,225 Total Fund Balance $ 8,560,627
1
For the period ended March 31, 2021
CITY OF INDEPENDENCE, MISSOURI Budgetary
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Sales Taxes $ 8,028,559 8,028,559 6,424,781 (1,603,778) 80.02% 5.02% Charges for Services 7,088 7,088 0.00% -75.00% Intergovernmental Revenue 30,493 30,493 0.00% -75.00% Investment Income (Loss) 10,000 10,000 30,558 20,558 305.58% 230.58% Other Revenue 7,051 7,051 0.00% -75.00% Total Revenues 8,038,559 8,045,647 6,499,971 (1,545,676) 80.79% 5.79% Other Financing Sources: Transfers in 0.00% -75.00% Issuance of debt 0.00% -75.00% Total other financing sources 0.00% -75.00% Total revenues and other financing sources 8,038,559 8,045,647 6,499,971 (1,545,676) 80.79% 5.79% Expenditures: General Government 0.00% -75.00% Street Maintenance 929,575 929,575 486,550 443,025 52.34% -22.66% Capital Outlay 4,971,836 25,411,762 6,093,046 19,318,716 23.98% -51.02% Debt Service 555,951 555,951 338,877 217,074 60.95% -14.05% Total Expenditures 6,457,362 26,897,288 6,918,473 19,978,815 25.72% -49.28% Other Financing Uses: Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 6,457,362 26,897,288 6,918,473 19,978,815 25.72% -49.28% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 1,581,197 (18,851,641) (418,502) 18,433,139 Unassigned Fund Balance at Beginning of Year (1,383,849) Cancellation of Prior Year Encumbrances 43,738 Change in Other Fund Balance Components During the Year 3,355,278 Year-end investment market value adjustment Ending Unassigned Fund Balance, 03/31/21 1,596,665 Fund Balance Components: Restricted - Current Year Encumbrances 1,663,682 Restricted - Prior Year Encumbrances 1,054,313 Restricted - Debt Reserve Project Accounts - Capital Projects 14,507,839 Total Fund Balance $ 18,822,499
Improvements Sales Tax Fund
the period ended March 31, 2021 2
Comparison Schedule Street
For
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Park Improvements Sales Tax Fund For the period ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Sales Taxes $ 4,014,300 4,014,300 3,212,396 (801,904) 80.02% 5.02% Charges for services 348,455 348,455 57,201 (291,254) 16.42% -58.58% Intergovernmental 0.00% -75.00% Investment Income (Loss) 3,000 3,000 11,942 8,942 398.07% 323.07% Other Revenue 2,500 2,500 22,750 20,250 910.00% 835.00% Total Revenues 4,368,255 4,368,255 3,304,289 (1,063,966) 75.64% 0.64% Other Financing Sources: Transfers In 25,300 25,300 100.00% 25.00% Transfers In - CARES Act 4,925 4,925 0.00% -75.00% Proceeds from Bond Issuance/Capital Lease 0.00% -75.00% Total Other Financing Sources 25,300 30,225 4,925 0.00% -75.00% Total Revenues and Other Financing Sources 4,368,255 4,393,555 3,334,514 (1,059,041) 75.90% 0.90% Expenditures: Culture and Recreation 3,640,907 3,640,907 2,257,376 1,383,531 62.00% -13.00% Capital Outlay 280,625 1,092,997 166,431 926,566 15.23% -59.77% Debt Service 261,589 261,589 111,271 150,318 42.54% -32.46% Total Expenditures 4,183,121 4,995,493 2,535,078 2,460,415 50.75% -24.25% Other Financing Uses: Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 4,183,121 4,995,493 2,535,078 2,460,415 50.75% -24.25% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 185,134 (601,938) 799,436 1,401,374 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, 03/31/21 141,398 Other Fund Balance Components: Restricted - Current Year Encumbrances 205,515 Restricted - Prior Year Encumbrances 12,553 Total Fund Balance $ 359,466
3
CITY OF INDEPENDENCE, MISSOURI Budgetary
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Sales Taxes $ 4,014,317 4,014,317 3,212,396 (801,921) 80.02% 5.02% Investment income (loss) 24,500 24,500 96,105 71,605 392.27% 317.27% Other Revenue 135 135 0.00% -75.00% Total revenues 4,038,817 4,038,817 3,308,636 (730,181) 81.92% 6.92% Expenditures: Storm water Administration 342,871 342,871 180,730 162,141 52.71% -22.29% Maintenance 2,116,748 2,116,748 1,027,959 1,088,789 48.56% -26.44% Permit completion 318,000 318,000 329,900 (11,900) 103.74% 28.74% Capital outlay 1,300,000 3,867,673 691,350 3,176,323 17.88% -57.12% Total Expenditures 4,077,619 6,645,292 2,229,939 4,415,353 33.56% -41.44% Total Ependitures and Other Financing Uses 4,077,619 6,645,292 2,229,939 4,415,353 Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (38,802) (2,606,475) 1,078,697 3,685,172 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, 03/31/21 8,337,732 Other Fund Balance Components: Restricted - Current Year Encumbrances 620,348 Restricted - Prior Year Encumbrances 420,228 Restricted - Regional Detention Construction 540,563 Restricted - Regional Detention Maintenance 50,228 Restricted - Emergency Response Relief 500,000 Total Fund Balance $ 10,469,099
Comparison Schedule Storm Water Sales Tax Fund For the period ended March 31, 2021 4
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Police Public Safety Sales Tax Fund
For the period ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Sales Taxes $ 2,133,460 2,133,460 1,718,084 (415,376) 80.53% 5.53% Investment Income (Loss) 5,000 5,000 26,735 21,735 534.70% 459.70% Other Revenue 27,055 27,055 0.00% -75.00% Total Revenues 2,138,460 2,138,460 1,771,874 (366,586) 82.86% 7.86% Expenditures: Public Safety Communications 602,307 602,307 558,321 43,986 92.70% 17.70% Facilities 99,768 99,768 73,372 26,396 73.54% -1.46% Equipment 2,017,965 2,017,965 1,651,221 366,744 81.83% 6.83% Debt Service 0.00% -75.00% Total Expenditures 2,720,040 2,720,040 2,282,914 437,126 83.93% 8.93% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 2,720,040 2,720,040 2,282,914 437,126 83.93% 8.93% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (581,580) (581,580) (511,040) 70,540 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, 03/31/21 2,047,220 Other Fund Balance Components: Restricted - Current Year Encumbrances 228,760 Restricted - Prior Year Encumbrances 20,543 Total Fund Balance $ 2,296,523
5
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Fire Public Safety Sales Tax Fund For the period ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Sales Taxes $ 2,007,200 2,007,200 1,606,212 (400,988) 80.02% 5.02% Investment Income (Loss) 5,300 5,300 12,218 6,918 230.53% 155.53% Other Revenue 6,302 6,420 118 101.87% 26.87% Total Revenues 2,012,500 2,018,802 1,624,850 (393,952) 80.49% 5.49% Expenditures: Public Safety 2,183,900 2,743,985 1,958,190 785,795 71.36% -3.64% Debt Service 73,236 73,236 73,236 0.00% -75.00% Total Expenditures 2,257,136 2,817,221 1,958,190 859,031 69.51% -5.49% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 2,257,136 2,817,221 1,958,190 859,031 69.51% -5.49% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (244,636) (798,419) (333,340) 465,079 Unassigned Fund Balance at Beginning of Year 1,243,946 Cancellation of Prior Year Encumbrances 21,960 Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 03/31/21 932,566 Other Fund Balance Components: Restricted - Current Year Encumbrances 1,259,485 Restricted - Prior Year Encumbrances 209,761 Total Fund Balance $ 2,401,812
6
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Use Tax $ 750,000 750,000 750,000 100.00% 25.00% Intergovernmental Revenue 0.00% -75.00% Investment Income (Loss) 181 181 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 750,000 750,000 750,181 181 100.02% 25.02% Expenditures: General Government -75.00% Animal Services 744,152 744,152 557,143 187,009 74.87% -0.13% Capital Outlay 0.00% -75.00% Debt Service 0.00% -75.00% Total Expenditures 744,152 744,152 557,143 187,009 74.87% -0.13% Other Financing Uses: Transfers In 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 744,152 744,152 557,143 187,009 74.87% -0.13% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 5,848 5,848 193,038 187,190 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, 03/31/21 413,878 Fund Balance Components: Restricted - Current Year Encumbrances 3,104 Restricted - Prior Year Encumbrances Total Fund Balance $ 416,982
Shelter Use Tax
the period ended March 31, 2021 7
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Animal
For
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Police Use Tax
For the period ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Use Tax $ 750,000 750,000 2,878,792 2,128,792 383.84% 308.84% Investment Income (Loss) 5,373 5,373 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 750,000 750,000 2,884,165 2,134,165 384.56% 309.56% Expenditures: Public Safety 750,000 750,000 192,112 557,888 25.61% -49.39% Debt Service 0.00% -75.00% Total Expenditures 750,000 750,000 192,112 557,888 25.61% -49.39% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 750,000 750,000 192,112 557,888 25.61% -49.39% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 2,692,053 2,692,053 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, 03/31/21 3,630,051 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 3,630,051
8
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule Health Property Tax Levy For the period ended March 31, 2021 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 832,000 846,000 870,837 24,837 102.94% 27.94% Charges for Services 154,000 154,000 78,647 (75,353) 51.07% -23.93% Investment Income (Loss) 444 444 0.00% -75.00% Other Revenue 104,864 104,864 0.00% -75.00% Total Revenues 986,000 1,000,000 1,054,792 54,792 105.48% 30.48% Other Financing Sources: Transfers In - CARES Act 993 (993) 0.00% -75.00% Total Other Financing Uses 993 (993) 0.00% -75.00% Total Revenues and Other Sources 986,000 1,000,000 1,055,785 53,799 105.58% 30.58% Expenditures: Animal Services 986,000 1,000,000 714,593 285,407 71.46% -3.54% Health Services 43,096 (43,096) 0.00% -75.00% Total Expenditures 986,000 1,000,000 757,689 242,311 75.77% 0.77% Other Financing Uses: Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Uses 986,000 1,000,000 757,689 242,311 75.77% 0.77% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 298,096 298,096 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, 03/31/21 298,096 Other Fund Balance Components: Restricted - Current Year Encumbrances 62,080 Restricted - Prior Year Encumbrances Total Fund Balance $ 360,176
9
CITY OF INDEPENDENCE, MISSOURI
Comparison Schedule Parks and Recreation Property Tax Levy For the period ended March 31, 2021 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 1,794,000 1,823,700 1,850,529 26,829 101.47% 26.47% Intergovernmental 30,000 30,000 60,603 30,603 202.01% 127.01% Charges for Services 184,813 184,813 133,780 (51,033) 72.39% -2.61% Investment Income (Loss) 957 957 0.00% -75.00% Other Revenue 24,882 24,882 0.00% -75.00% Total Revenues 2,008,813 2,038,513 2,070,751 32,238 101.58% 26.58% Expenditures: Parks and Recreation 1,899,830 1,899,830 1,237,431 662,399 65.13% -9.87% Total Expenditures 1,899,830 1,899,830 1,237,431 662,399 65.13% -9.87% Other Financing Uses – Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Uses 1,899,830 1,899,830 1,237,431 662,399 65.13% -9.87% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 108,983 138,683 833,320 694,637 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, 03/31/21 833,320 Other Fund Balance Components: Restricted - Current Year Encumbrances 10,669 Restricted - Prior Year Encumbrances Total Fund Balance $ 843,989 10
Budgetary
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule Tourism Fund For the period ended March 31, 2021 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Transient Guest Taxes $ 1,860,354 1,860,354 848,888 (1,011,466) 45.63% -29.37% Charges for Services 23,944 23,944 1,447 (22,497) 6.04% -68.96% Investment Income (Loss) 3,300 3,300 14,184 10,884 429.82% 354.82% Other Revenue 15,600 15,600 (15,600) 0.00% -75.00% Total Revenues 1,903,198 1,903,198 864,519 (1,038,679) 45.42% -29.58% Expenditures: Tourism 1,997,806 2,174,064 1,037,324 1,136,740 47.71% -27.29% Total Expenditures 1,997,806 2,174,064 1,037,324 1,136,740 47.71% -27.29% Other Financing Uses – Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Uses 1,997,806 2,174,064 1,037,324 1,136,740 47.71% -27.29% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (94,608) (270,866) (172,805) 98,061 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, 03/31/21 737,297 Other Fund Balance Components: Restricted - Current Year Encumbrances 116,855 Restricted - Prior Year Encumbrances 87,225 Restricted - Operating Reserve 376,368 Total Fund Balance $ 1,317,745
11
Independence Square Benefit District For the period ended March 31, 2021 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 26,283 26,283 0.00% -75.00% Investment Income (Loss) 699 699 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 26,982 26,982 0.00% -75.00% Expenditures: Capital Outlay 421 (421) 0.00% -75.00% Total Expenditures 421 (421) 0.00% -75.00% Other Financing Uses – Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Uses 421 (421) 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 26,561 26,561 Unassigned Fund Balance at Beginning of Year 3,755 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 03/31/21 30,316 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 30,316 12
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
CITY OF INDEPENDENCE, MISSOURI
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Federal Grant - CDBG $ 814,159 1,819,696 267,158 (1,552,538) 14.68% -60.32% Other Revenue 41 41 -75.00% Total Revenues 814,159 1,819,696 267,199 (1,552,497) 14.68% -60.32% Expenditures: CDBG Administration 162,830 162,831 222,638 (59,807) 136.73% 61.73% CDBG Expenditures 663,994 770,519 198,034 572,485 25.70% -49.30% Total Expenditures 826,824 933,350 420,672 512,678 45.07% -29.93% Other Financing Uses: Transfers Out 899,011 899,011 0.00% -75.00% Total Other Financing Uses 899,011 899,011 0.00% -75.00% Total Expenditures and Other Uses 826,824 1,832,361 420,672 1,411,689 22.96% -52.04% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (12,665) (12,665) (153,473) (140,808) Unassigned Fund Balance at Beginning of Year (184,469) Cancellation of Prior Year Encumbrances 1 Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 03/31/21 (337,941) Other Fund Balance Components: Restricted - Current Year Encumbrances 189,024 Restricted - Prior Year Encumbrances 142,022 Total Fund Balance $ (6,895)
Budgetary Comparison Schedule Community Development Block Grant Fund For the period ended March 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 75.00% of Year Budget Revenues: HOME Program Grant $ 482,477 1,465,629 363,973 (1,101,656) 24.83% -50.17% Total Revenues 482,477 1,465,629 363,973 (1,101,656) 24.83% -50.17% Expenditures: HOME Administration 70,592 184,543 30,899 153,644 16.74% -58.26% Multi Family Housing 359,759 645,213 146,119 499,094 22.65% -52.35% Community Housing Development 102,788 686,535 427,016 259,519 62.20% -12.80% Total Expenditures 533,139 1,516,291 604,034 912,257 39.84% -35.16% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (50,662) (50,662) (240,061) (189,399) 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, 03/31/21 (425,638) Other Fund Balance Components: Restricted - Current Year Encumbrances 401,490 Restricted - Prior Year Encumbrances 24,042 Total Fund Balance $ (106)
Rental Rehabilitation
the period ended March 31, 2021 14
For
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
License
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Licenses and Permits $ 6,637 6,637 0.00% -75.00% Investment Income (Loss) 4,000 4,000 12,669 8,669 316.73% 241.73% Other Revenue 0.00% -75.00% Total Revenues 4,000 4,000 19,306 15,306 482.65% 407.65% Expenditures: General Government 0.00% -75.00% Total expenditures 0.00% -75.00% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 4,000 4,000 19,306 15,306 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, 03/31/21 1,302,184 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 1,302,184
Surcharge
15
For the period ended March 31, 2021
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Grants For the period ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Intergovernmental $ 585,503 6,016,715 2,641,373 (3,375,342) 43.90% -31.10% Charges for Services 119,260 119,260 0.00% -75.00% Other Revenue 27,938 468 (27,470) 1.68% -73.32% Total Revenues 585,503 6,044,653 2,761,101 (3,283,552) 45.68% -29.32% Other financing sources: Transfers In - CARES Act 55 55 0.00% -75.00% Total other financing sources 55 55 0.00% -75.00% Total revenues and other financing sources 585,503 6,044,653 2,761,156 (3,283,497) 45.68% -29.32% Expenditures: Public Safety 527,713 2,283,022 1,668,406 614,616 73.08% -1.92% General Government 33,550 136,128 15,343 120,785 11.27% -63.73% Culture and Recreation 300 56,219 45,522 10,697 80.97% 5.97% CARES Act Marketing 1,055,998 1,055,985 13 100.00% 25.00% Community Development 24,240 2,418,038 1,195,569 1,222,469 49.44% -25.56% Animal Services 15,247 11,989 3,258 78.63% 3.63% Health Services 80,000 78,400 1,600 98.00% 23.00% Total Expenditures 585,803 6,044,652 4,071,214 1,973,438 67.35% -7.65% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 585,803 6,044,652 4,071,214 1,973,438 67.35% -7.65% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (300) 1 (1,310,058) (1,310,059) 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, 03/31/21 (1,456,823) Other Fund Balance Components: Restricted - Current Year Encumbrances 1,001,012 Restricted - Prior Year Encumbrances 32,189 Total Fund Balance $ (423,622)
16
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule CARES Act
For the period ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Intergovernmental $ 6,953,474 6,953,474 100.00% 25.00% Charges for Services 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 6,953,474 6,953,474 100.00% 25.00% Other financing sources: Transfers in 0.00% -75.00% Total other financing sources 0.00% -75.00% Total revenues and other financing sources 6,953,474 6,953,474 100.00% 25.00% Expenditures: CARES Act 4,500,699 3,397,465 1,103,234 75.49% 0.49% Total Expenditures 4,500,699 3,397,465 1,103,234 75.49% 0.49% Other Financing Uses: Transfers Out/Capital Outlay 2,452,775 3,589,622 (1,136,847) 146.35% 71.35% Total Other Financing Uses 2,452,775 3,589,622 (1,136,847) 146.35% 71.35% Total Expenditures and Other Financing Uses 6,953,474 6,987,087 (33,613) 100.48% 25.48% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (33,613) (33,613) 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, 03/31/21 (33,613) Other Fund Balance Components: Restricted - Current Year Encumbrances 18,025 Restricted - Prior Year Encumbrances Total Fund Balance $ (15,588)
17
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Operating Revenues: Charges for Services $ 130,313,972 130,313,972 92,016,386 (38,297,586) 70.61% -4.39% Penalties 1,106,786 1,106,786 520,337 (586,449) 47.01% -27.99% Connection Charges 280,151 280,151 21,600 (258,551) 7.71% -67.29% Meter Reading 24,758 24,758 0.00% -75.00% Temporary Service 1,000 1,000 0.00% -75.00% Rental Income 340,239 340,239 266,034 (74,205) 78.19% 3.19% Transmission Wheeling 5,000,000 5,000,000 3,648,674 (1,351,326) 72.97% -2.03% Total Operating Revenues 137,041,148 137,041,148 96,498,789 (40,542,359) 70.42% -4.58% Operating Expenses: Personnel Services 27,275,535 27,275,535 20,600,940 6,674,595 75.53% 0.53% Other Services 26,731,853 26,721,853 20,157,956 6,563,897 75.44% 0.44% Supplies 57,859,830 57,861,830 44,403,534 13,458,296 76.74% 1.74% Capital Projects 5,285,000 15,463,979 8,031,638 7,432,341 51.94% -23.06% Capital Operating 1,313,400 1,321,400 98,319 1,223,081 7.44% -67.56% Debt Service 10,547,050 10,547,050 7,884,969 2,662,081 74.76% -0.24% Other Expenses 275,000 275,000 275,000 0.00% -75.00% Total Operating Expenses 129,287,668 139,466,647 101,177,356 38,289,291 72.55% -2.45% Nonoperating Revenues (Expenses): Investment Income 200,000 200,000 388,488 188,488 194.24% 119.24% Interfund Charges for Support Services 1,828,147 1,828,147 1,312,696 (515,451) 71.80% -3.20% Miscellaneous Revenue (Expense) 886,189 886,189 (478,844) (1,365,033) -54.03% -129.03% Total Nonoperating Revenue (Expenses) 2,914,336 2,914,336 1,222,340 (1,691,996) 41.94% -33.06% 10,667,816 488,837 (3,456,227) (3,945,064) -707.03% -782.03% Capital Contributions 0.00% -75.00% Transfers Out – Utility Payments In Lieu of Taxes (13,000,000) (13,000,000) (9,480,902) (3,519,098) 72.93% -2.07% Transfers In 0.00% -75.00% Transfers Out 0.00% -75.00% Special Item - Electric Rebate (11,220,000) (11,198,532) (21,468) 99.81% 24.81% Bond Redemption - 2010 B (10,615,000) 10,615,000 0.00% -75.00% Total Transfers and Special Items (13,000,000) (24,220,000) (31,294,434) 7,074,434 129.21% 54.21% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (2,332,184) (23,731,163) (34,750,661) (11,019,498) Beginning Available Resources 82,856,511 Ending Available Resources 48,105,850 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 $ (18,894,150) Income (Loss) Before Transfers
Power and Light For the period ended March 31, 2021 18
As of March 31, 2021
PROJECT PROJECT TITLE ORIGINAL BUDGET NET BUDGET AMENDMENTS REVISED BUDGET REQUISITIONS ENCUMBRANCES ACTUALS AVAILABLE BUDGET 200815 T&D Sys IMPROVEMENTS $ - 759,504.86 759,504.86 180,000.00 921.36 118,013.78 460,569.72 200824 Prod Plt MISC PROJECTS - 68,257.76 68,257.76 - - - 68,257.76 200828 FIBER OPTIC PROGRAM - 107,894.93 107,894.93 - 22,544.75 14,500.90 70,849.28 201106 69 KV SUBSTATION FACILITIES 300,000.00 (79,638.13) 220,361.87 - 19,228.74 82,139.32 118,993.81 201405 SUBSTATION SECURITY PROJECT - 263,489.08 263,489.08 - - 3,844.69 259,644.39 201505 SUBSTATION L SWITCHGEAR REPLAC - (5.00) (5.00) - - - (5.00) 201509 NEW BILLING Sys - 22,047.36 22,047.36 - 22,475.34 - (427.98) 201510 Sys OpS / DISPATCH - 125,694.52 125,694.52 - 45,922.10 70,259.75 9,512.67 201512 ADVANCED METERING INFRASTRUCTU - 3,825.00 3,825.00 - - - 3,825.00 201513 BV ASH POND CLOSURE - 620,913.45 620,913.45 - - - 620,913.45 201603 69 KV Trans LINE REBUIL - 1,672,552.81 1,672,552.81 1,874,409.00 - 323,889.33 (525,745.52) 201604 Sys OpS / UPS UPGRAD - 96,538.87 96,538.87 - - 51,045.28 45,493.59 201605 Sys OpS WORK AREA - 682,232.86 682,232.86 - - 58,689.10 623,543.76 201606 NEW FINANCIAL MANAGEMENT SYS - 200,000.00 200,000.00 - - - 200,000.00 201702 Prod FACILITIES IMPROVE - 586,830.00 586,830.00 - - - 586,830.00 201703 BV GROUND WATER - 494,708.07 494,708.07 - 179,876.55 27,246.50 287,585.02 201706 SUBSTATION K SWITCHGEAR & 2,075,000.00 5,561,875.31 7,636,875.31 - 5,978,010.27 1,541,786.36 117,078.68 201707 MASTER PLAN-FUTURE GENERATIO - 32,500.00 32,500.00 - - - 32,500.00 201710 Mo CITY DIVESTITURE - 610,600.14 610,600.14 - 552,447.32 58,152.32 0.50 201711 SOLAR INSTALLATION-PHASE II - 420.87 420.87 - - - 420.87 201802 SUBSTATION H6 MAJOR INSPECTION AND - 494,700.94 494,700.94 - - - 494,700.94 201804 SUBSTATION E SWITCHGEAR REPLACEMENT 1,350,000.00 1,685,460.00 3,035,460.00 - - 459,440.00 2,576,020.00 202004 Above Ground Fuel Storage Tanks - 41,800.00 41,800.00 - - - 41,800.00 202005 Blue Valley - Eckles Rd 161kV Trans - 182,588.46 182,588.46 - 218,054.36 6,139.00 (41,604.90) 202101 Substation Fiber Optic Network 125,000.00 - 125,000.00 - - - 125,000.00 202102 Traffic Controller Upgrades 60,000.00 - 60,000.00 - - 64,000.00 (4,000.00) 202103 Traffic Camera System Upgrades 50,000.00 - 50,000.00 - - 38,163.00 11,837.00 202107 Motorola APX Radio Purchase Phase 2 75,000.00 - 75,000.00 - 75,326.96 - (326.96) 202109 Substation Modeling 150,000.00 - 150,000.00 - - - 150,000.00 202110 20MVAR Capacitor Bank Sub A 800,000.00 - 800,000.00 - - - 800,000.00 202111 Transmission Pole Replacement Prog 150,000.00 (50,000.00) 100,000.00 - - - 100,000.00 9669 SERVICE CTR FACILITY IMPROVE. 150,000.00 70,084.17 220,084.17 - 21,009.50 - 199,074.67 $ 5,285,000.00 14,254,876.33 19,539,876.33 2,054,409.00 7,135,817.25 2,917,309.33 7,432,340.75 Current Year Prior Year Budget Budget (Enc Roll) Total Budget 15,463,978.95 $ 4,075,897.38 19,539,876.33 Less Expenditures 1,600,181.34 1,317,127.99 2,917,309.33 Less Encumbrances 6,431,456.86 2,758,769.39 9,190,226.25 Total Available 7,432,340.75 $ - 7,432,340.75
Power and Light - Open Capital Projects
19
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Water
For the period ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Operating Revenues: Charges for Services $ 31,850,000 31,850,000 24,239,402 (7,610,598) 76.10% 1.10% Penalties 170,000 170,000 84,815 (85,185) 49.89% -25.11% Connection/Disconnection Charges 83,750 83,750 3,412 (80,338) 4.07% -70.93% Meter Reading 1,000 1,000 7,499 6,499 749.90% 674.90% Returned Check Charges 10,000 10,000 12,050 2,050 120.50% 45.50% Rental Income 35,000 35,000 55,165 20,165 157.61% 82.61% Meter Repairs 250 250 (250) 0.00% -75.00% Merchandising Jobbing 8,216 8,216 0.00% -75.00% Total Operating Revenues 32,150,000 32,150,000 24,410,559 (7,739,441) 75.93% 0.93% Operating expenses: Personnel Services 8,666,805 8,666,805 5,819,485 2,847,320 67.15% -7.85% Other Services 11,365,107 12,765,107 7,806,059 4,959,048 61.15% -13.85% Supplies 2,460,040 2,460,040 2,381,856 78,184 96.82% 21.82% Capital Projects 4,205,000 14,302,730 2,085,145 12,217,585 14.58% -60.42% Capital Operating 882,493 882,493 703,051 179,442 79.67% 4.67% Debt Service 2,533,338 2,533,338 2,300,786 232,552 90.82% 15.82% Other Expenses 125,000 125,000 125,000 0.00% -75.00% Total Operating Expenses 30,237,783 41,735,513 21,096,382 20,639,131 50.55% -24.45% Nonoperating Revenues (Expenses): Investment Income 75,000 75,000 395,589 320,589 527.45% 452.45% Interfund Charges for Support Services 1,392,092 1,392,092 1,044,069 (348,023) 75.00% 0.00% Miscellaneous Revenue (Expense) 140,417 140,417 0.00% -75.00% Total Nonoperating Revenue (Expenses) 1,467,092 1,467,092 1,580,075 112,983 107.70% 32.70% 3,379,309 (8,118,421) 4,894,252 13,012,673 -60.29% -135.29% Transfers Out – Utility Payments In Lieu of Taxes (3,200,000) (3,200,000) (2,374,081) (825,919) 74.19% -0.81% Transfers In 0.00% -75.00% Transfers Out 0.00% -75.00% Total Transfers (3,200,000) (3,200,000) (2,374,081) (825,919) 74.19% -0.81% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 179,309 (11,318,421) 2,520,171 13,838,592 Beginning Available Resources 32,358,367 Cancellation of Prior Year Encumbrances 33,456 Ending Available Resources 34,911,994 Current Debt Service Due 1,701,895 Operating Reserve (63 Days) 4,889,277 Mngt Recom Operating Reserve (27 Days) 2,095,389 Capital Projects in Process - Non Bond 12,217,585 Prior Year Open Encumbrances - Non Cap 284,181 Reserved Resources 21,188,327 Total Non-Restricted Resources Available $ 13,723,667 Income (Loss) Before Transfers
20
Water - Open Capital Projects As
PROJECT PROJECT TITLE ORIGINAL BUDGET NET BUDGET AMENDMENT REVISED BUDGET REQUISITIONS ENCUMBRANCES ACTUALS AVAILABLE BUDGET 400708 TREATMENT Plt DISCHARGE $ - 300,000.00 300,000.00 - - - 300,000.00 400904 EAST INDEPENDENCE INDUST PARK - 674,000.00 674,000.00 - - - 674,000.00 401003 FUTURE Prod WELLS - 965,326.00 965,326.00 - - - 965,326.00 401301 23RD ST MAIN REPLACEMENT - 177,230.57 177,230.57 - - - 177,230.57 401402 LAGOON CLEANOUT - 302,560.00 302,560.00 300,000.00 - - 2,560.00 401505 Dist Sys IMPROVE - 258,054.00 258,054.00 - 13,273.00 - 244,781.00 401506 TRUMAN ROAD BOOSTER STATION - 173,664.94 173,664.94 - 37,838.85 63,915.42 71,910.67 401601 FILTER BACKWASH OUTFALL - 190,325.00 190,325.00 - - - 190,325.00 401602 Plt DISCHARGE OUTFALL - 459,824.48 459,824.48 - - - 459,824.48 401605 COURTNEY BEND BASIN CATWALK - 17,892.02 17,892.02 - - 7,872.02 10,020.00 401608 LIME SILO - 500,000.00 500,000.00 - 425,409.07 136,053.93 (61,463.00) 401703 Maint BUILDING AT CBP - 200,000.00 200,000.00 - - - 200,000.00 401704 VAN HORN RESERVOIR IMPROVE - 294,271.33 294,271.33 - 278,672.85 (12,217.52) 27,816.00 401801 Water Main Replacement US 40 Hwy - 29,750.00 29,750.00 - - 29,750.00401802 6" Main Replacement James Downey Rd - 250,087.60 250,087.60 - - - 250,087.60 401804 Filter Valve House Roof Improvement - 55,418.00 55,418.00 - - 33,126.00 22,292.00 401805 Fuel Site Improvements - 51,504.67 51,504.67 - - 51,504.67401808 VFD Drive Replacements HSP 2 & 4 - 915,608.00 915,608.00 - 325,120.00 359,521.00 230,967.00 401814 Main Replacement - (3,755.00) (3,755.00) - - - (3,755.00) 401818 30" Steel Transmission Main Assess - 175,000.00 175,000.00 - - 18,700.00 156,300.00 401821 Main Replacement-32nd/Hunter/Bird - 91,000.00 91,000.00 - - - 91,000.00 401822 Main Replacement-24Hwy/Northern/RR - 240,166.00 240,166.00 - - - 240,166.00 402002 39th Street Reservoir - 1,200,000.00 1,200,000.00 - - - 1,200,000.00 402004 Main Replace Walnut/Leslie/LeesSumm - 1,080,159.00 1,080,159.00 - 200,337.22 798,603.05 81,218.73 402007 Courtney Bend Emergency Generator - 150,000.00 150,000.00 - - - 150,000.00 402008 Wellfield Overhead Electrical Imp - 200,000.00 200,000.00 - - - 200,000.00 402009 Main Replace Sheley/Claremont/Norw - 200,000.00 200,000.00 - 2,242.00 8,968.00 188,790.00 402010 Main Replace Gudgell/Dodgion/KingsH 135,000.00 900,000.00 1,035,000.00 - - 26,635.00 1,008,365.00 402011 Main Replace Salisbury/Peck/Geospac 75,000.00 500,000.00 575,000.00 - - 23,100.00 551,900.00 402012 College Avenue Improvements 250,000.00 - 250,000.00 - - - 250,000.00 402101 Main Replacement Ralston 31st/29th 350,000.00 - 350,000.00 - - - 350,000.00 402102 Main Replacement 3rd St & Jennings 460,000.00 - 460,000.00 - - - 460,000.00 402103 Main Replacement Truman Road 500,000.00 - 500,000.00 - 15,830.00 - 484,170.00 402104 Lime Slaker No 5 350,000.00 - 350,000.00 - - - 350,000.00 402105 Main Replacement Sheley 100,000.00 - 100,000.00 - - - 100,000.00 402106 Main Replacement Sheley & Northern 1,035,000.00 - 1,035,000.00 - - - 1,035,000.00 402107 Facility Improvements/Const/Maint 250,000.00 - 250,000.00 - - - 250,000.00 402108 Basin Drive Improvements 250,000.00 - 250,000.00 - - - 250,000.00 9749 MAIN REPLACEMENT PROGRAM 200,000.00 597,662.19 797,662.19 - - - 797,662.19 9952 SECURITY UPGRADES 250,000.00 61,305.72 311,305.72 - - 43,714.90 267,590.82 $ 4,205,000.00 11,207,054.52 15,412,054.52 300,000.00 1,298,722.99 1,589,246.47 12,224,085.06 Work Order Charged Against Capital Project Budget (6,500.00) Budgetary Reports 12,217,585.06 $ Current Year Prior Year Budget Budget (Enc Roll) Total Budget 14,302,730.26 $ 1,109,324.26 15,412,054.52 Less Expenditures 874,052.31 716,993.84 1,591,046.15 Less Encumbrances 1,211,092.89 392,330.42 1,603,423.31 Total Available 12,217,585.06 $ - 12,217,585.06
of March 31, 2021 21
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Operating revenues: Charges for Services $ 33,393,893 33,393,893 26,343,272 (7,050,621) 78.89% 3.89% Penalties 200,000 200,000 126,337 (73,663) 63.17% -11.83% Total operating revenues 33,593,893 33,593,893 26,469,609 (7,124,284) 78.79% 3.79% Operating expenses: Personnel Services 5,868,295 5,868,295 3,942,772 1,925,523 67.19% -7.81% Other Services 13,075,398 13,075,398 8,687,862 4,387,536 66.44% -8.56% Supplies 661,840 661,840 329,304 332,536 49.76% -25.24% Capital Projects 5,330,000 12,851,182 1,220,605 11,630,577 9.50% -65.50% Capital Operating 926,000 926,000 823,032 102,968 88.88% 13.88% Debt Service 6,290,632 6,290,632 5,259,809 1,030,823 83.61% 8.61% Other Expenses 30,000 30,000 30,000 0.00% -75.00% Total Operating Expenses 32,182,165 39,703,347 20,263,384 19,439,963 51.04% -23.96% Nonoperating Revenues (Expenses): Investment Income 51,000 51,000 159,523 108,523 312.79% 237.79% Miscellaneous Revenue (Expense) (45,166) (45,166) 0.00% -75.00% Total Nonoperating Revenue (Expenses) 51,000 51,000 114,357 63,357 224.23% 149.23% 1,462,728 (6,058,454) 6,320,582 12,379,036 -104.33% -179.33% Transfers Out – Utility Payments In Lieu of Taxes (3,596,612) (3,596,612) (2,639,758) (956,854) 73.40% -1.60% Transfers In 10,000 10,000 10,000 100.00% 25.00% Transfers Out 0.00% -75.00% Total Transfers (3,586,612) (3,586,612) (2,629,758) (956,854) 73.32% -1.68% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (2,123,884) (9,645,066) 3,690,824 13,335,890 Beginning Available Resources 20,160,346 Cancellation of Prior Year Encumbrances 92,765 Ending Available Resources 23,943,935 Current Debt Service Due 2,541,055 Operating Reserve (63 Days) 5,164,395 Mngt Recom Operating Reserve (27 Days) 2,213,325 Capital Projects in Process - Non Bond 11,630,577 Prior Year Open Encumbrances - Non Cap 185,817 Reserved Resources 21,735,169 Total Non-Restricted Resources Available $ 2,208,766 Income (Loss) Before Transfers
Sewer
22
Sanitary
For the period ended March 31, 2021
Sanitary Sewer - Open Capital Projects
As of March 31, 2021
PROJECT PROJECT TITLE ORIGINAL BUDGET NET BUDGET AMENDMENTS REVISED BUDGET REQUISITIONS ENCUMBRANCES ACTUALS AVAILABLE BUDGET 300801 NEIGHBORHOOD PROJECTS $ - 573,018.98 573,018.98 - 576,341.39 857.83 (4,180.24) 301108 HOLDING BASINS AND PMP STATION - 694,045.55 694,045.55 - - - 694,045.55 301201 BURR OAK EAST - 1,035,327.15 1,035,327.15 - - - 1,035,327.15 301202 CRACKERNECK-VAN HOOK SEWER - 529,163.59 529,163.59 - - - 529,163.59 301502 NEW Util BILLING Sys - 16,942.28 16,942.28 - 11,237.82 - 5,704.46 301504 SECURITY IMPROVEMENTS - 5.56 5.56 - - - 5.56 301505 SEWAGE SLUDGE INCINERATOR IMP - 641,818.97 641,818.97 - 1,288.97 35,995.00 604,535.00 301603 RCTP FACILITIES ROOF, CEILING - 170,925.00 170,925.00 - 3,361.00 - 167,564.00 301604 PRIMARY SLUDGE GRINDERS & - 6,989.69 6,989.69 - - - 6,989.69 301701 SCADA UPGRADE - 1,021,934.00 1,021,934.00 - 88,691.00 - 933,243.00 301702 SADDLE RIDGE VILLAS PUMP - 85,000.00 85,000.00 - - - 85,000.00 301703 ARROWHEAD CENTER - 826,630.11 826,630.11 - 683,945.22 3,377.32 139,307.57 301705 16TH/SCOTT - 359,023.24 359,023.24 - 5,390.10 - 353,633.14 301706 TREATMENT FACILITY IMPROVEMENT - 593,007.00 593,007.00 - - - 593,007.00 301707 NEIGHBORHOOD IMPROVE 17-18 - 289,132.61 289,132.61 - 14,865.35 206,482.37 67,784.89 301804 ROCK CREEK EFFLUENT STRUCTURE - 375,000.00 375,000.00 - 49,979.50 - 325,020.50 301806 Neighborhood Improvements 2018-19 - 470,248.18 470,248.18 - 14,398.81 6,491.50 449,357.87 302001 Fairmount Highlands - 170,000.00 170,000.00 - - - 170,000.00 302002 Arlington Improvements - 100,000.00 100,000.00 - - - 100,000.00 302003 Bison Park 200,000.00 233,963.86 433,963.86 - 13,218.36 5,923.50 414,822.00 302004 Neighborhood Projects 2019-20 430,000.00 150,000.00 580,000.00 - - - 580,000.00 302005 Biosolids Handling 3,000,000.00 2,000,000.00 5,000,000.00 - 2,857,215.88 1,251,027.12 891,757.00 302006 Raw Pumps & Screening - 900,000.00 900,000.00 - - - 900,000.00 302007 Electrical Substation Rehab - 186,259.00 186,259.00 - 20,000.00 7,569.00 158,690.00 302008 RCTP Fence 250,000.00 200,000.00 450,000.00 - - - 450,000.00 302009 Truman & Harris - 50,000.00 50,000.00 - - - 50,000.00 302101 Sanitation Sewer Evaluation Survey 250,000.00 - 250,000.00 - 114,155.15 11,400.00 124,444.85 302102 Raymond Harkless Mills San Imp 200,000.00 - 200,000.00 - - - 200,000.00 302103 Pump Station Imp & Maintenance 200,000.00 - 200,000.00 67,148.00 - - 132,852.00 302104 Polymer System Relocation 100,000.00 - 100,000.00 - - - 100,000.00 302105 Piping Rehabilitation 200,000.00 - 200,000.00 - 19,947.50 - 180,052.50 9757 TRENCHLESS TECHNOLOGY 500,000.00 1,321,680.92 1,821,680.92 0.00 548,287.10 80,942.49 1,192,451.33 $ 5,330,000.00 13,000,115.69 18,330,115.69 67,148.00 5,022,323.15 1,610,066.13 11,630,578.41 Current Year Prior Year Budget Budget (Enc Roll) Total Budget 12,851,182.45 $ 5,478,933.24 18,330,115.69 Less Expenditures 203,483.49 1,406,582.64 1,610,066.13 Less Encumbrances 1,017,120.55 4,072,350.60 5,089,471.15 Total Available 11,630,578.41 $ - 11,630,578.41
23
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Events Center Debt Service For the period ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Operating revenues: Charges for Services $ 0.00% -75.00% Miscellaneous 0.00% -75.00% Total operating revenues 0.00% -75.00% Operating Expenses: Personnel Services 0.00% -75.00% Other Services 55,529 (55,529) 0.00% -75.00% Supplies 0.00% -75.00% Capital Outlay 75,000 1,478,361 140,244 1,338,117 9.49% -65.51% Debt Service 5,173,844 5,173,844 4,256,633 917,211 82.27% 7.27% Other Expenses 0.00% -75.00% Total Operating Expenses 5,248,844 6,652,205 4,452,406 2,199,799 66.93% -8.07% Nonoperating Revenues (Expenses): Investment Income 35,092 35,092 0.00% -75.00% Miscellaneous Revenue (Expense) 0.00% -75.00% Sales Tax 5,173,844 5,173,844 4,416,102 (757,742) 85.35% 10.35% Total Nonoperating Revenue (Expenses) 5,173,844 5,173,844 4,451,194 (722,650) 0.00% -75.00% (75,000) (1,478,361) (1,212) 1,477,149 0.08% -74.92% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -75.00% Transfers In 75,000 75,000 75,000 0.00% -75.00% Transfers Out 0.00% -75.00% Total Transfers 75,000 75,000 75,000 0.00% -75.00% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (1,403,361) (1,212) 1,402,149 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,524,539) Ending Unassigned Fund Balance, 03/31/21 (25,950,210) Restricted: Bond Reserve Project Accounts 6,814,304 Total restricted 6,814,304 Committed: Capital Projects In Process 1,338,117 Total Committed 1,338,117 Assigned: Prior Year Open Encumbrances - Excluding Capital Projects Current Year Open Encumbrances - Excluding Capital Projects Total Assigned Total Fund Balance $ (17,797,789) Income (Loss) Before Transfers
24
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Central Garage
For the period ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Operating revenues: Charges for Services $ 2,088,731 2,088,731 1,195,901 (892,830) 57.25% -17.75% Miscellaneous 4,093 4,093 0.00% -75.00% Total Operating Revenues 2,088,731 2,088,731 1,199,994 (888,737) 57.45% -17.55% Operating Expenses: Personnel Services 754,502 754,502 508,565 245,937 67.40% -7.60% Other Services 550,811 547,411 539,303 8,108 98.52% 23.52% Supplies 768,986 772,386 499,960 272,426 64.73% -10.27% Capital Outlay 25,375 25,375 15,927 9,448 62.77% -12.23% Other Expenses 0.00% -75.00% Total Operating Expenses 2,099,674 2,099,674 1,563,755 535,919 74.48% -0.52% Nonoperating Revenues (Expenses): Investment Income 300 300 5,479 5,179 1826.33% 1751.33% Miscellaneous Revenue (Expense) 2,546 2,546 0.00% -75.00% Total Nonoperating Revenue (Expenses) 300 300 8,025 7,725 2675.00% 2600.00% (10,643) (10,643) (355,736) (345,093) 3342.44% 3267.44% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -75.00% Transfers In 0.00% -75.00% Transfers Out 0.00% -75.00% Total Transfers 0.00% -75.00% Change In Net Position (Budget Basis) $ (10,643) (10,643) (355,736) (345,093) 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 (90,354) Year-end investment market value adjustment Ending Unassigned Fund Balance GAAP Basis, 03/31/21 (1,644,272) Other Net Position Components: Assigned - Current Year Encumbrances 334,847 Assigned - Prior Year Encumbrances 20,096 Total Fund Balance $ (1,289,329) Income (Loss) Before Transfers
25
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Staywell Health Care
For the period ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Operating revenues: Charges for Services $ 14,532,190 14,532,190 13,467,186 (1,065,004) 92.67% 17.67% Miscellaneous 0.00% -75.00% Total Operating Revenues 14,532,190 14,532,190 13,467,186 (1,065,004) 92.67% 17.67% Operating Expenses: Personnel Services 163,200 (163,200) 0.00% -75.00% Other Services 14,532,190 14,532,190 16,592,571 (2,060,381) 114.18% 39.18% Supplies 128 (128) 0.00% -75.00% Capital Outlay 0.00% -75.00% Other Expenses 0.00% -75.00% Total Operating Expenses 14,532,190 14,532,190 16,755,899 (2,223,709) 115.30% 40.30% Nonoperating Revenues (Expenses): Investment Income 3,767 3,767 0.00% -75.00% Miscellaneous Revenue (Expense) 1,128,844 1,128,844 0.00% -75.00% Total Nonoperating Revenue (Expenses) 1,132,611 1,132,611 0.00% -75.00% (2,156,102) (2,156,102) 0.00% -75.00% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -75.00% Transfers In 0.00% -75.00% Transfers Out 0.00% -75.00% Total Transfers 0.00% -75.00% Change In Net Position (Budget Basis) $ (2,156,102) (2,156,102) Unassigned Fund Balance at Beginning of Year 3,312,003 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year 326,520 Ending Unassigned Fund Balance GAAP Basis, 03/31/21 1,482,421 Other Net Position Components: Assigned - Current Year Encumbrances 60,000 Assigned - Prior Year Encumbrances Total Fund Balance $ 1,542,421 Income (Loss) Before Transfers
26
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule
Workers' Compensation
For the period ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Operating revenues: Charges for Services $ 3,558,840 3,558,840 2,669,130 (889,710) 75.00% 0.00% Miscellaneous 1,102 1,102 0.00% -75.00% Total Operating Revenues 3,558,840 3,558,840 2,670,232 (888,608) 75.03% 0.03% Operating Expenses: Personnel Services 21,000 21,000 9,595 11,405 45.69% -29.31% Other Services 4,500,000 4,500,000 2,151,692 2,348,308 47.82% -27.18% Supplies 4,000 4,000 4,000 0.00% -75.00% Capital Outlay 2,000 2,000 2,000 0.00% -75.00% Other Expenses 0.00% -75.00% Total Operating Expenses 4,527,000 4,527,000 2,161,287 2,365,713 47.74% -27.26% Nonoperating Revenues (Expenses): Investment Income 12,000 12,000 1,223 (10,777) 10.19% -64.81% Miscellaneous Revenue (Expense) 38,386 38,386 0.00% -75.00% Total Nonoperating Revenue (Expenses) 12,000 12,000 39,609 27,609 330.08% 255.08% (956,160) (956,160) 548,554 1,504,714 -57.37% -132.37% Transfers In 0.00% -75.00% Transfers Out 0.00% -75.00% Total Transfers 0.00% -75.00% Change In Net Position (Budget Basis) $ (956,160) (956,160) 548,554 1,504,714 Unassigned Fund Balance at Beginning of Year (8,552,971) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year (588,380) Year-end investment market value adjustment Ending Unassigned Fund Balance GAAP Basis, 03/31/21 (8,592,797) Other Net Position Components: Restricted - Work Comp Escrow Assigned - Current Year Encumbrances 36,255 Assigned - Prior Year Encumbrances 10,675 Total Fund Balance $ (8,545,867) Income (Loss) Before Transfers
27
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Risk Management
For the period ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Operating revenues: Charges for Services $ 2,991,000 2,991,000 2,243,250 (747,750) 75.00% 0.00% Miscellaneous 0.00% -75.00% Total Operating Revenues 2,991,000 2,991,000 2,243,250 (747,750) 75.00% 0.00% Operating Expenses: Personnel Services 15,000 15,000 9,595 5,405 63.97% -11.03% Other Services 2,988,000 2,988,000 1,483,618 1,504,382 49.65% -25.35% Supplies 3,000 3,000 3,000 0.00% -75.00% Capital Outlay 0.00% -75.00% Other Expenses 0.00% -75.00% Total Operating Expenses 3,006,000 3,006,000 1,493,213 1,512,787 49.67% -25.33% Nonoperating Revenues (Expenses): Investment Income 7,084 7,084 0.00% -75.00% Miscellaneous Revenue (Expense) 0.00% -75.00% Total Nonoperating Revenue (Expenses) 7,084 7,084 0.00% -75.00% (15,000) (15,000) 757,121 772,121 -5047.47% -5122.47% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -75.00% Transfers In 0.00% -75.00% Transfers Out 0.00% -75.00% Total Transfers 0.00% -75.00% Change In Net Position (Budget Basis) $ (15,000) (15,000) 757,121 772,121 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, 03/31/21 1,330,404 Other Net Position Components: Assigned - Current Year Encumbrances 31,010 Assigned - Prior Year Encumbrances 732 Total Fund Balance $ 1,362,146 Income (Loss) Before Transfers
28
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Operating revenues: Charges for Services $ 1,430,000 1,430,000 1,072,500 (357,500) 75.00% 0.00% Miscellaneous 0.00% -75.00% Total Operating Revenues 1,430,000 1,430,000 1,072,500 (357,500) 75.00% 0.00% Operating Expenses: Personnel Services 430,000 430,000 394,282 35,718 91.69% 16.69% Other Services 999,561 999,561 942,997 56,564 94.34% 19.34% Supplies 0.00% -75.00% Capital Outlay 4,596,317 (4,596,317) 0.00% -75.00% Other Expenses 0.00% -75.00% Total Operating Expenses 1,429,561 1,429,561 5,933,596 (4,504,035) 415.06% 340.06% Nonoperating Revenues (Expenses): Investment Income 200 200 (200) 0.00% -75.00% Miscellaneous Revenue (Expense) 0.00% -75.00% Total Nonoperating Revenue (Expenses) 200 200 (200) 0.00% -75.00% 639 639 (4,861,096) (4,861,735) -760734.90% -760809.90% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -75.00% Transfers In – CARES Act 2,775,613 (2,775,613) 0.00% -75.00% Transfers Out 0.00% -75.00% Total Transfers 2,775,613 (2,775,613) 0.00% -75.00% Change In Net Position (Budget Basis) $ 639 639 (2,085,483) (2,086,122) 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, 03/31/21 (3,075,547) Other Net Position Components: Assigned - Current Year Encumbrances 56,802 Assigned - Prior Year Encumbrances 97,660 Total Fund Balance $ (2,921,085) Income (Loss) Before Transfers
Budgetary Comparison Schedule Enterprise Resource Planning For the period ended March 31, 2021 29
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 75.00% of Year Budget Revenues: Charges for Services $ 9,290 9,290 0.00% -75.00% Investment Income (Loss) 500 500 150 (350) 30.00% -45.00% Other Revenue 0.00% -75.00% Total Revenues 500 500 9,440 8,940 1888.00% 1813.00% Expenditures: General Government 93 (93) 0.00% -75.00% Debt Service 9,998 9,998 9,289 709 92.91% 17.91% Total Expenditures 9,998 9,998 9,382 616 93.84% 18.84% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total expenditures and other financing uses 9,998 9,998 9,382 616 93.84% 18.84% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (9,498) (9,498) 58 9,556 Unassigned Fund Balance at Beginning of Year 103,247 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 03/31/21 103,305 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 103,305
Comparison Schedule Debt Service - Neighborhood Improvement Districts For the period ended March 31, 2021 30
Budgetary
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Charges for Services $ 8,387 8,387 0.00% -75.00% Investment Income 1,446 1,446 0.00% -75.00% Intergovernmental 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 9,833 9,833 0.00% -75.00% Other Financing Sources: Transfers In 0.00% -75.00% Total Other Financing Sources 0.00% -75.00% Total Revenues and Other Financing Sources 9,833 9,833 0.00% -75.00% Expenditures: Public Works 0.00% -75.00% Culture and Recreation 0.00% -75.00% Capital Outlay 338,651 207,851 130,800 61.38% -13.62% Total Expenditures 338,651 207,851 130,800 61.38% -13.62% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 338,651 207,851 130,800 61.38% -13.62% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (338,651) (198,018) 140,633 Unassigned Fund Balance at Beginning of Year (51,591) Cancellation of Prior Year Encumbrances 24,286 Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 03/31/21 (225,323) Other Fund Balance Components: Committed - Current Year Encumbrances 199,252 Committed - Prior Year Encumbrances 14,615 Total Fund Balance $ (11,456)
Comparison Schedule
Street Improvements Capital Project Fund For the period ended March 31, 2021 31
CITY OF INDEPENDENCE, MISSOURI
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Revolving Public Improvements Capital Project Fund For the period ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Charges for Services $ 0.00% -75.00% Investment Income (Loss) 215 215 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 215 215 0.00% -75.00% Expenditures: Public Works 0.00% -75.00% Culture and Recreation 0.00% -75.00% Capital Outlay 0.00% -75.00% Total Expenditures 0.00% -75.00% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 215 215 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, 03/31/21 21,792 Other Fund Balance Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances Total Fund Balance $ 21,792
32
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Charges for Services $ 0.00% -75.00% Investment Income 16 16 0.00% -75.00% Other Revenue 5,289 5,289 0.00% -75.00% Total revenues 5,305 5,305 0.00% -75.00% Other Financing Sources: Transfers In 0.00% -75.00% Total Other Financing Sources 0.00% -75.00% Total Revenues and Other Financing Sources 5,305 5,305 0.00% -75.00% Expenditures: Public Works 0.00% -75.00% Culture and Recreation 0.00% -75.00% Capital Outlay 1,443,621 865,953 577,668 59.98% -15.02% Total Expenditures 1,443,621 865,953 577,668 0.00% -75.00% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total expenditures and other financing uses 1,443,621 865,953 577,668 59.98% -15.02% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (1,443,621) (860,648) 582,973 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, 03/31/21 (935,095) Other Fund Balance Components: Committed - Current Year Encumbrances 842,427 Committed - Prior Year Encumbrances 69,980 Total Fund Balance $ (22,688)
Buildings and Other Improvements Capital Project Fund For the period ended March 31, 2021 33
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Charges for Services $ 0.00% -75.00% Investment Income 0.00% -75.00% Other Revenue 0.00% -75.00% Total revenues 0.00% -75.00% Expenditures: Public Works 0.00% -75.00% Culture and Recreation 0.00% -75.00% Capital Outlay 0.00% -75.00% Total Expenditures 0.00% -75.00% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total expenditures and other financing uses 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ Unassigned Fund Balance at Beginning of Year (16,155) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 03/31/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 March 31, 2021 34
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Park Improvements Capital Project Fund For the period ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Charges for Services $ 0.00% -75.00% Investment Income (Loss) 321 321 0.00% -75.00% Other Revenue 0.00% -75.00% Total revenues 321 321 0.00% -75.00% Expenditures: Public Works 0.00% -75.00% Culture and Recreation 0.00% -75.00% Capital Outlay 0.00% -75.00% Total Expenditures 0.00% -75.00% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total expenditures and other financing uses 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 321 321 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, 03/31/21 31,747 Fund Balance Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances Total Fund Balance $ 31,747
35
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Charges for Services $ 16,600 16,600 (16,600) 0.00% -75.00% Investment Income 133 133 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 16,600 16,600 133 (16,467) 0.80% -74.20% Expenditures: Public Works 0.00% -75.00% Culture and Recreation 18,209 18,209 7,021 11,188 38.56% -36.44% Capital Outlay 0.00% -75.00% Total Expenditures 18,209 18,209 7,021 11,188 38.56% -36.44% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 18,209 18,209 7,021 11,188 38.56% -36.44% Excess of revenues over (under) expenditures and Other Financing Uses, Budget Basis $ (1,609) (1,609) (6,888) (5,279) 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, 03/31/21 2,607 Other Net Position Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances Total Net Position $ 2,607
Private Purpose Expendable Trust Fund - Vaile Mansion For the period ended March 31, 2021 36
Schedule
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Independence Events Center CID For the period ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Sales Taxes $ 7,700,767 7,700,767 5,289,091 (2,411,676) 68.68% -6.32% Investment Income 128,715 128,715 12,947 (115,768) 10.06% -64.94% Total Revenues 7,829,482 7,829,482 5,302,038 (2,527,444) 67.72% -7.28% Expenditures: Administrative Fee 154,015 154,015 105,782 48,233 68.68% -6.32% Insurance 2,150 2,150 2,150 0.00% -75.00% Legal 44,850 44,850 44,850 0.00% -75.00% Audit 5,150 5,150 5,150 100.00% 25.00% Banking 5,916 5,916 5,177 739 87.51% 12.51% Contract Services 310,500 310,500 300,000 10,500 96.62% 21.62% Capital Outlay 0.00% -75.00% Other 0.00% -75.00% Total Expenditures 522,581 522,581 416,109 106,472 79.63% 4.63% Other Financing Uses: Transfers Out - EATS (75,000) (75,000) (587,180) 512,180 782.91% 707.91% Transfers Out - Debt Service (City) (5,173,844) (5,173,844) (3,828,922) (1,344,922) 74.01% -0.99% Total Other Financing Uses (5,248,844) (5,248,844) (4,416,102) (832,742) 84.13% 9.13% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 2,058,057 2,058,057 469,827 (1,588,230) Unassigned Fund Balance at Beginning of Year 7,010,144 Cancellation of Prior Year Encumbrances 30,725 Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 03/31/21 7,510,696 Other Fund Balance Components: Restricted - current year encumbrances Restricted - prior year encumbrances Total Fund Balance $ 7,510,696
37
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
For the period ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Sales taxes $ 336,515 336,515 0.00% -75.00% Investment income 175 175 0.00% -75.00% Total revenues 336,690 336,690 0.00% -75.00% Expenditures: Administrative fee 6,730 (6,730) 0.00% -75.00% Insurance 2,000 2,000 2,132 (132) 106.60% 31.60% Legal 1,250 (1,250) 0.00% -75.00% Audit 4,700 4,700 5,150 (450) 109.57% 34.57% Banking 272 (272) 0.00% -75.00% Contract services 0.00% -75.00% Capital outlay 0.00% -75.00% Other 0.00% -75.00% Total expenditures 6,700 6,700 15,534 (8,834) 231.85% 156.85% Other financing uses: Transfers out - EATS (248,491) (248,491) (168,258) (80,233) 67.71% -7.29% Transfers out - Debt Service (City) (215,000) (215,000) (191,000) (24,000) 88.84% 13.84% Total other financing uses (463,491) (463,491) (359,258) (104,233) 77.51% 2.51% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (470,191) (470,191) (38,102) 432,089 Unassigned Fund Balance at Beginning of Year 82,217 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year (419) Unassigned Ending Fund Balance, 03/31/21 43,696 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - City Transportation 6,207 Total Fund Balance $ 49,903
Crackerneck Creek TDD
38
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Tax Increment Financing Summary For the Period Ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 16,228,916 16,228,916 16,835,462 606,546 103.74% 28.74% Investment Income (Loss) 227,281 227,281 0.00% -75.00% Other revenue 1,310,958 1,310,958 1,066,471 (244,487) 81.35% 6.35% Total Revenues 17,539,874 17,539,874 18,129,214 589,340 103.36% 28.36% Other Financing Sources: Transfers In 1,327,471 1,327,471 587,181 (740,290) 44.23% -30.77% Total Other Financing Sources 1,327,471 1,327,471 587,181 (740,290) 44.23% -30.77% Total Revenues and Other Financing Sources 18,867,345 18,867,345 18,716,395 (150,950) 99.20% 24.20% Expenditures: Tax Increment Financing 1,792,897 1,792,897 1,871,334 (78,437) 104.37% 29.37% Debt Service Principal 9,594,866 10,081,215 7,904,141 2,177,074 78.40% 3.40% Interest and Fiscal Agent Fees 5,587,948 5,587,948 6,526,130 (938,182) 116.79% 41.79% Debt Issuance Costs 0.00% -75.00% Total Expenditures 16,975,711 17,462,060 16,301,605 1,160,455 93.35% 18.35% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 587,181 (587,181) 0.00% -75.00% Total Other Financing Uses 587,181 (587,181) 0.00% -75.00% Total Expenditures and Other Financing Uses 16,975,711 17,462,060 16,888,786 573,274 96.72% 21.72% Excess of Revenues Over (Under) Expenditures and other financing uses $ 1,891,634 1,405,285 1,827,609 422,324 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, 03/31/21 20,576,923 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances 15,226 Restricted - Trust Debt Service 12,333,319 Total Fund Balance $ 32,925,468
39
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 0.00% -75.00% Investment Income (Loss) 16 16 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 16 16 0.00% -75.00% Expenditures: Tax Increment Financing 0.00% -75.00% Debt Service Principal 0.00% -75.00% Interest and Fiscal Agent Fees 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 0.00% -75.00% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 16 16 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, 03/31/21 1,588 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 1,588
Schedule Mid-Town Truman Rd TIF For the Period Ended March 31, 2021 40
For the Period Ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 257,999 257,999 (1,622) (259,621) -0.63% -75.63% Investment Income (Loss) 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 257,999 257,999 (1,622) (259,621) -0.63% -75.63% Expenditures: Tax Increment Financing 3,822 3,822 3,822 0.00% -75.00% Debt Service Principal 50,950 50,950 50,950 0.00% -75.00% Interest and Fiscal Agent Fees 203,227 203,227 14,100 189,127 6.94% -68.06% Debt Issuance Costs 0.00% -75.00% Total Expenditures 257,999 257,999 14,100 243,899 5.47% -69.53% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 257,999 257,999 14,100 243,899 5.47% -69.53% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (15,722) (15,722) Unassigned Fund Balance at Beginning of Year 15,722 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 03/31/21 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $
TIF
41
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule RSO
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 26,271 26,271 28,470 2,199 108.37% 33.37% Investment Income (Loss) (23) (23) 0.00% -75.00% Other Revenue 102,958 102,958 73,407 (29,551) 71.30% -3.70% Total Revenues 129,229 129,229 101,854 (27,375) 78.82% 3.82% Other Financing Sources: Transfers In 187,942 187,942 (187,942) 0.00% -75.00% Total Other Financing Sources 187,942 187,942 (187,942) 0.00% -75.00% Total Revenues and Other Financing Sources 317,171 317,171 101,854 (215,317) 32.11% -42.89% Expenditures: Tax Increment Financing 7,801 7,801 5,500 2,301 70.50% -4.50% Debt Service Principal 190,000 190,000 190,000 100.00% 25.00% Interest and Fiscal Agent Fees 339,938 339,938 334,237 5,701 98.32% 23.32% Debt Issuance Costs 0.00% -75.00% Total Expenditures 537,739 537,739 529,737 8,002 98.51% 23.51% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 537,739 537,739 529,737 8,002 98.51% 23.51% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (220,568) (220,568) (427,883) (207,315) 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, 03/31/21 (1,634,777) Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 557,834 Total Fund Balance $ (1,076,943)
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Santa Fe TIF For the Period Ended March 31, 2021 42
CITY
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 1,446,920 1,446,920 1,343,662 (103,258) 92.86% 17.86% Investment Income (Loss) 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 1,446,920 1,446,920 1,343,662 (103,258) 92.86% 17.86% Other Financing Sources: Transfers In 118,097 118,097 55,516 (62,581) 47.01% -27.99% Total Other Financing Sources 118,097 118,097 55,516 (62,581) 47.01% -27.99% Total Revenues and Other Financing Sources 1,565,017 1,565,017 1,399,178 (165,839) 89.40% 14.40% Expenditures: Tax Increment Financing 121,261 121,261 1,250 120,011 1.03% -73.97% Debt Service Principal 1,630,000 1,630,000 1,815,000 (185,000) 111.35% 36.35% Interest and Fiscal Agent Fees 140,068 140,068 74,869 65,199 53.45% -21.55% Debt Issuance Costs 0.00% -75.00% Total Expenditures 1,891,329 1,891,329 1,891,119 210 99.99% 24.99% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 55,516 (55,516) 0.00% -75.00% Total Other Financing Uses 55,516 (55,516) 0.00% -75.00% Total Expenditures and Other Financing Uses 1,891,329 1,891,329 1,946,635 (55,306) 102.92% 27.92% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (326,312) (326,312) (547,457) (221,145) 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, 03/31/21 (3,045,651) Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ (3,045,651)
Heritage TIF
43
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Hartman
For the Period Ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 568,730 568,730 616,508 47,778 108.40% 33.40% Investment Income (Loss) 18,446 18,446 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 568,730 568,730 634,954 66,224 111.64% 36.64% Expenditures: Tax Increment Financing 15,338 15,338 2,500 12,838 16.30% -58.70% Debt Service Principal 385,000 385,000 405,000 (20,000) 105.19% 30.19% Interest and Fiscal Agent Fees 36,150 36,150 24,600 11,550 68.05% -6.95% Debt Issuance Costs 0.00% -75.00% Total Expenditures 436,488 436,488 432,100 4,388 98.99% 23.99% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 436,488 436,488 432,100 4,388 98.99% 23.99% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 132,242 132,242 202,854 70,612 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, 03/31/21 2,044,516 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 2,044,516
OF INDEPENDENCE,
Budgetary Comparison Schedule Drumm Farm TIF For the Period Ended March 31, 2021 44
CITY
MISSOURI
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Eastland TIF
For the Period Ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 5,053,492 5,053,492 4,879,628 (173,864) 96.56% 21.56% Investment Income (Loss) 124,049 124,049 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 5,053,492 5,053,492 5,003,677 (49,815) 99.01% 24.01% Other Financing Sources: Transfers In 664,783 664,783 507,642 (157,141) 76.36% 1.36% Total Other Financing Sources 664,783 664,783 507,642 (157,141) 76.36% 1.36% Total Revenues and Other Financing Sources 5,718,275 5,718,275 5,511,319 (206,956) 96.38% 21.38% Expenditures: Tax Increment Financing 457,612 457,612 241,415 216,197 52.76% -22.24% Debt Service Principal 2,870,000 2,870,000 3,005,000 (135,000) 104.70% 29.70% Interest and Fiscal Agent Fees 115 115 291,650 (291,535) 253608.70% 253533.70% Debt Issuance Costs 0.00% -75.00% Total Expenditures 3,327,727 3,327,727 3,538,065 (210,338) 106.32% 31.32% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 507,642 (507,642) 0.00% -75.00% Total Other Financing Uses 507,642 (507,642) 0.00% -75.00% Total Expenditures and Other Financing Uses 3,327,727 3,327,727 4,045,707 (717,980) 121.58% 46.58% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 2,390,548 2,390,548 1,465,612 (924,936) 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, 03/31/21 13,758,265 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 897,693 Total Fund Balance $ 14,655,958
45
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 57,965 57,965 45,428 (12,537) 78.37% 3.37% Investment Income (Loss) 460 460 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 57,965 57,965 45,888 (12,077) 79.17% 4.17% Expenditures: Tax Increment Financing 1,645 1,645 1,645 0.00% -75.00% Debt Service Principal 10,000 10,000 2,815 7,185 28.15% -46.85% Interest and Fiscal Agent Fees 45,530 45,530 61,285 (15,755) 134.60% 59.60% Debt Issuance Costs 0.00% -75.00% Total Expenditures 57,175 57,175 64,100 (6,925) 112.11% 37.11% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 57,175 57,175 64,100 (6,925) 112.11% 37.11% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 790 790 (18,212) (19,002) 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, 03/31/21 13,721 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 13,721
North Independence TIF
46
For the Period Ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 2,179 2,179 2,070 (109) 95.00% 20.00% Investment Income (Loss) 471 471 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 2,179 2,179 2,541 362 116.61% 41.61% Other Financing Sources: Transfers In 0.00% -75.00% Capital lease proceeds 0.00% Total Other Financing Sources 0.00% -75.00% Total Revenues and Other Financing Sources 2,179 2,179 2,541 362 116.61% 41.61% Expenditures: Tax Increment Financing 63 63 63 0.00% -75.00% Debt Service Principal 0.00% -75.00% Interest and Fiscal Agent Fees 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 63 63 63 0.00% -75.00% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 63 63 63 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 2,116 2,116 2,541 425 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, 03/31/21 49,929 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 49,929
Budgetary Comparison Schedule Mt Washington TIF For the Period Ended March 31, 2021 47
CITY OF INDEPENDENCE, MISSOURI
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Crackerneck Creek TIF
For the Period Ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 1,589,201 1,589,201 1,438,143 (151,058) 90.49% 15.49% Investment Income (Loss) 56,451 56,451 0.00% -75.00% Other Revenue 1,208,000 1,208,000 993,064 (214,936) 82.21% 7.21% Total Revenues 2,797,201 2,797,201 2,487,658 (309,543) 88.93% 13.93% Other Financing Sources: Transfers In 315,000 315,000 (315,000) 0.00% -75.00% Total Other Financing Sources 315,000 315,000 (315,000) 0.00% -75.00% Total Revenues and Other Financing Sources 3,112,201 3,112,201 2,487,658 (624,543) 79.93% 4.93% Expenditures: Tax Increment Financing 48,817 48,817 15,340 33,477 31.42% -43.58% Debt Service Principal 50,000 50,000 50,000 100.00% 25.00% Interest and Fiscal Agent Fees 3,779,920 3,779,920 3,777,571 2,349 99.94% 24.94% Debt Issuance Costs 0.00% -75.00% Total Expenditures 3,878,737 3,878,737 3,842,911 35,826 99.08% 24.08% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 3,878,737 3,878,737 3,842,911 35,826 99.08% 24.08% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (766,536) (766,536) (1,355,253) (588,717) 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, 03/31/21 4,534,283 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances 15,226 Restricted - Trust Debt Service 7,522,922 Total Fund Balance $ 12,072,431
48
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule
For the Period Ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 496,239 496,239 642,116 145,877 129.40% 54.40% Investment Income (Loss) 3,871 3,871 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 496,239 496,239 645,987 149,748 130.18% 55.18% Expenditures: Tax Increment Financing 9,590 9,590 9,590 0.00% -75.00% Debt Service 486,349 Principal 486,349 95,618 390,731 19.66% -55.34% Interest and Fiscal Agent Fees 525,082 (525,082) 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 495,939 495,939 620,700 (124,761) 125.16% 50.16% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 495,939 495,939 620,700 (124,761) 125.16% 50.16% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 300 300 25,287 24,987 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, 03/31/21 29,229 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 29,229
Old Landfill TIF
49
CITY OF INDEPENDENCE,
MISSOURI
Budgetary Comparison Schedule Trinity TIF
For the Period Ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 489,107 489,107 405,061 (84,046) 82.82% 7.82% Investment Income (Loss) 23 23 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 489,107 489,107 405,084 (84,023) 82.82% 7.82% Other Financing Sources: Transfers In 32,466 32,466 19,872 (12,594) 61.21% -13.79% Total Other Financing Sources 32,466 32,466 19,872 (12,594) 61.21% -13.79% Total Revenues and Other Financing Sources 521,573 521,573 424,956 (96,617) 81.48% 6.48% Expenditures: Tax Increment Financing 11,267 11,267 11,267 0.00% -75.00% Debt Service Principal 510,360 510,360 115,166 395,194 22.57% -52.43% Interest and Fiscal Agent Fees 106,059 (106,059) 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 521,627 521,627 221,225 300,402 42.41% -32.59% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 19,872 (19,872) 0.00% -75.00% Total Other Financing Uses 19,872 (19,872) 0.00% -75.00% Total Expenditures and Other Financing Uses 521,627 521,627 241,097 280,530 46.22% -28.78% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (54) (54) 183,859 183,913 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, 03/31/21 56,089 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 56,089
50
For the Period Ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 3,589,345 3,589,345 4,575,051 985,706 127.46% 52.46% Investment Income (Loss) 12,703 12,703 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 3,589,345 3,589,345 4,587,754 998,409 127.82% 52.82% Other Financing Sources: Transfers In 9,183 9,183 4,151 (5,032) 45.20% -29.80% Total Other Financing Sources 9,183 9,183 4,151 (5,032) 45.20% -29.80% Total Revenues and Other Financing Sources 3,598,528 3,598,528 4,591,905 993,377 127.61% 52.61% Expenditures: Tax Increment Financing 550,170 550,170 1,604,125 (1,053,955) 291.57% 216.57% Debt Service Principal 1,950,000 1,950,000 2,030,000 (80,000) 104.10% 29.10% Interest and Fiscal Agent Fees 1,043,000 1,043,000 955,350 87,650 91.60% 16.60% Debt Issuance Costs 0.00% -75.00% Total Expenditures 3,543,170 3,543,170 4,589,475 (1,046,305) 129.53% 54.53% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 4,151 (4,151) 0.00% -75.00% Total Other Financing Uses 4,151 (4,151) 0.00% -75.00% Total Expenditures and Other Financing Uses 3,543,170 3,543,170 4,593,626 (1,050,456) 129.65% 54.65% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 55,358 55,358 (1,721) (57,079) 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, 03/31/21 1,251,100 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 3,354,870 Total Fund Balance $ 4,605,970
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule HCA TIF
51
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule
Cinema East TIF
For the Period Ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 257,861 257,861 209,598 (48,263) 81.28% 6.28% Investment Income (Loss) 16 16 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 257,861 257,861 209,614 (48,247) 81.29% 6.29% Expenditures: Tax Increment Financing 5,139 5,139 5,139 0.00% -75.00% Debt Service Principal 252,902 252,902 29,387 223,515 11.62% -63.38% Interest and Fiscal Agent Fees 157,327 (157,327) 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 258,041 258,041 186,714 71,327 72.36% -2.64% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 258,041 258,041 186,714 71,327 72.36% -2.64% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (180) (180) 22,900 23,080 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, 03/31/21 59,012 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 59,012
52
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule 23rd & Noland Project 1 TIF For the Period Ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 82,194 82,194 60,526 (21,668) 73.64% -1.36% Investment Income (Loss) 17 17 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 82,194 82,194 60,543 (21,651) 73.66% -1.34% Expenditures: Tax Increment Financing 2,063 2,063 2,063 0.00% -75.00% Debt Service Principal 80,131 80,131 44,000 36,131 54.91% -20.09% Interest and Fiscal Agent Fees 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 82,194 82,194 44,000 38,194 53.53% -21.47% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 82,194 82,194 44,000 38,194 53.53% -21.47% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 16,543 16,543 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, 03/31/21 43,507 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 43,507
53
CITY
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 11,729 11,729 11,776 47 100.40% 25.40% Investment Income (Loss) 12 12 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 11,729 11,729 11,788 59 100.50% 25.50% Expenditures: Tax Increment Financing 246 246 246 0.00% -75.00% Debt Service Principal 11,483 11,483 1,500 9,983 13.06% -61.94% Interest and Fiscal Agent Fees 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 11,729 11,729 1,500 10,229 12.79% -62.21% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 11,729 11,729 1,500 10,229 12.79% -62.21% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 10,288 10,288 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, 03/31/21 12,629 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 12,629
Noland
Period
54
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule 23rd &
Project 2 TIF For the
Ended March 31, 2021
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
23rd & Noland Project 3 TIF
For the Period Ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 24,348 24,348 17,598 (6,750) 72.28% -2.72% Investment Income (Loss) 9 9 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 24,348 24,348 17,607 (6,741) 72.31% -2.69% Expenditures: Tax Increment Financing 24,438 24,438 24,438 0.00% -75.00% Debt Service Principal 0.00% -75.00% Interest and Fiscal Agent Fees 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 24,438 24,438 24,438 0.00% -75.00% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 24,438 24,438 24,438 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (90) (90) 17,607 17,697 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, 03/31/21 24,995 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 24,995
55
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
23rd & Noland Project 4 TIF
For the Period Ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 462,503 462,503 328,728 (133,775) 71.08% -3.92% Investment Income (Loss) 100 100 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 462,503 462,503 328,828 (133,675) 71.10% -3.90% Expenditures: Tax Increment Financing 462,503 462,503 462,503 0.00% -75.00% Debt Service Principal 0.00% -75.00% Interest and Fiscal Agent Fees 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 462,503 462,503 462,503 0.00% -75.00% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 462,503 462,503 462,503 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 328,828 328,828 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, 03/31/21 420,244 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 420,244
56
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Independence Square TIF
For the Period Ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 145,470 145,470 280,452 134,982 192.79% 117.79% Investment Income (Loss) 7,247 7,247 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 145,470 145,470 287,699 142,229 197.77% 122.77% Expenditures: Tax Increment Financing 7,799 7,799 7,799 0.00% -75.00% Debt Service Principal 0.00% -75.00% Interest and Fiscal Agent Fees 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 7,799 7,799 7,799 0.00% -75.00% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 7,799 7,799 7,799 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 137,671 137,671 287,699 150,028 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, 03/31/21 845,412 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 845,412
57
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule
I-70 & Little Blue Parkway Project 1 TIF
For the Period Ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 1,152,029 1,152,029 1,425,241 273,212 123.72% 48.72% Investment Income (Loss) 391 391 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 1,152,029 1,152,029 1,425,632 273,603 123.75% 48.75% Expenditures: Tax Increment Financing 23,927 23,927 23,927 0.00% -75.00% Debt Service Principal 1,128,102 1,128,102 120,655 1,007,447 10.70% -64.30% Interest and Fiscal Agent Fees 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 1,152,029 1,152,029 120,655 1,031,374 10.47% -64.53% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 1,152,029 1,152,029 120,655 1,031,374 10.47% -64.53% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 1,304,977 1,304,977 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, 03/31/21 1,673,710 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 1,673,710
58
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
I-70 & Little Blue Parkway Project 3 TIF
For the Period Ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 382,156 382,156 333,908 (48,248) 87.37% 12.37% Investment Income (Loss) 2,965 2,965 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 382,156 382,156 336,873 (45,283) 88.15% 13.15% Expenditures: Tax Increment Financing 0.00% -75.00% Debt Service Principal 382,156 382,156 382,156 0.00% -75.00% Interest and Fiscal Agent Fees 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 382,156 382,156 382,156 0.00% -75.00% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 382,156 382,156 382,156 0.00% -75.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 336,873 336,873 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, 03/31/21 406,702 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 406,702
59
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule
Marketplace Project 1 TIF
For the Period Ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 97,731 97,731 88,100 (9,631) 90.15% 15.15% Investment Income (Loss) 29 29 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 97,731 97,731 88,129 (9,602) 90.18% 15.18% Expenditures: Tax Increment Financing 3,949 3,949 3,949 0.00% -75.00% Debt Service Principal 93,782 93,782 93,782 0.00% -75.00% Interest and Fiscal Agent Fees 90,000 (90,000) 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 97,731 97,731 90,000 7,731 92.09% 17.09% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 97,731 97,731 90,000 7,731 92.09% 17.09% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (1,871) (1,871) 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, 03/31/21 28,722 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 28,722
60
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Marketplace Project 2 TIF
For the Period Ended March 31, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 35,447 35,447 105,020 69,573 296.27% 221.27% Investment Income (Loss) 28 28 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 35,447 35,447 105,048 69,601 296.35% 221.35% Expenditures: Tax Increment Financing 35,447 35,447 904 34,543 2.55% -72.45% Debt Service Principal 0.00% -75.00% Interest and Fiscal Agent Fees 114,000 (114,000) 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 35,447 35,447 114,904 (79,457) 324.16% 249.16% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 35,447 35,447 114,904 (79,457) 324.16% 249.16% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (9,856) (9,856) 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, 03/31/21 28,172 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 28,172
61
CITY
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 75.00% of Year Budget Revenues: Taxes $ 0.00% -75.00% Investment Income (Loss) 0.00% -75.00% Other Revenue 0.00% -75.00% Total Revenues 0.00% -75.00% Expenditures: Tax Increment Financing 300 (300) 0.00% -75.00% Debt Service Principal 0.00% -75.00% Interest and Fiscal Agent Fees 0.00% -75.00% Debt Issuance Costs 0.00% -75.00% Total Expenditures 300 (300) 0.00% -75.00% Other Financing Uses: Issuance of Debt 0.00% -75.00% Reoffering Premium/Original Issue Discount 0.00% -75.00% Payment to Refund Loans Escrow Agent 0.00% -75.00% Transfers Out 0.00% -75.00% Total Other Financing Uses 0.00% -75.00% Total Expenditures and Other Financing Uses 300 (300) 0.00% -75.00% 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, 03/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 March 31, 2021 62
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule TIF
For
