Monthly Financial and Operating Report October 2020
Table of Contents General Fund 1 Sales Tax Funds Street Improvements Sales Tax Fund 2 Park Improvements Sales Tax Fund 3 Storm Water Sales Tax Fund 4 Police Public Safety Sales Tax Fund 5 Fire Pubic safety Sales Tax Fund 6 Use Tax Funds Animal Shelter 7 Police 8 Property Tax Levy Funds Health Property Tax Levy 9 Parks and Recreation Property Tax Levy 10 Special Revenue Funds Tourism Fund 11 Independence Square Benefit District 12 Community Development Block Grant Fund 13 Rental Rehabilitation 14 License Surcharge 15 Grants 16 Enterprise Funds Power and Light 17 Water 18 Water Pollution Control 19 Events Center Debt Service 20 Internal Service Funds Central Garage 21 Staywell Health Care 22 Worker's Compensation 23 Risk Management 24 Enterprise Resource Planning 25 Debt Service Fund Debt Service - Neighborhood Improvement Districts 26 Capital Improvement Funds Street Improvements Capital Project Fund 27 Revolving Public Improvements Capital Project Fund 28 Building and Other Improvements Capital Project Fund 29 Storm Drainage Capital Project Fund 30 Park Improvements Capital Project Fund 31 Private Purpose Expendable Trust Fund - Vaile Mansion 32 Independence Events Center CID 33 Crackerneck Creek TDD 34 Tax Increment Financing Summary 35 Mid-Town Truman Rd TIF 36 RSO TIF 37 Santa Fe TIF 38 Hartman Heritage TIF 39 Drumm Farm TIF 40 Eastland TIF 41 North Independence TIF 42 Mt Washington TIF 43 Crackerneck Creek TIF 44 Old Landfill TIF 45 Trinity TIF 46 HCA TIF 47 Cinema East TIF 48 23rd & Noland Project 1 TIF 49 23rd & Noland Project 2 TIF 50 23rd & Noland Project 3 TIF 51 23th & Noland Project 4 TIF 52 Independence Square TIF 53 I-70 & Little Blue Parkway Project 1 TIF 54 I-70 & Little Blue Parkway Project 3 TIF 55 Marketplace Project 1 TIF 56 Marketplace Project 2 TIF 57 TIF Application Fees 58
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule General Fund
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 31,453,100 31,453,100 7,949,740 (23,503,360) 25.27% -8.06% Licenses and Permits 4,392,069 4,392,069 1,185,655 (3,206,414) 27.00% -6.33% Intergovernmental 5,262,150 5,262,150 1,869,569 (3,392,581) 35.53% 2.20% Charges for Current Services 2,058,050 2,118,686 402,408 (1,716,278) 18.99% -14.34% Interfund Charges for Support Services 5,035,500 5,035,500 1,678,500 (3,357,000) 33.33% 0.00% Fines and Forfeitures 3,771,000 3,771,000 738,780 (3,032,220) 19.59% -13.74% Investment Income (Loss) 175,000 175,000 58,712 (116,288) 33.55% 0.22% Other Revenue 2,493,532 2,504,622 338,123 (2,166,499) 13.50% -19.83% Total Revenues 54,640,401 54,712,127 14,221,487 (40,490,640) 25.99% -7.34% Other Financing Sources: Payments In Lieu of Taxes 19,796,612 19,796,612 7,296,727 (12,499,885) 36.86% 3.53% Operating Transfers In 0.00% -33.33% Total Other Financing Sources 19,796,612 19,796,612 7,296,727 (12,499,885) 36.86% 3.53% Total Revenues and Other Financing Sources 74,437,013 74,508,739 21,518,214 (52,990,525) 28.88% -4.45% Expenditures: City Council 680,553 680,553 207,090 473,463 30.43% -2.90% City Clerk 195,240 195,240 63,766 131,474 32.66% -0.67% City Manager 1,187,339 1,187,339 397,722 789,617 33.50% 0.17% Municipal Court 1,207,254 1,207,254 464,297 742,957 38.46% 5.13% Law 661,301 661,301 262,068 399,233 39.63% 6.30% Finance 5,295,645 5,295,645 3,512,431 1,783,214 66.33% 33.00% Community Development 5,653,911 5,653,911 1,826,741 3,827,170 32.31% -1.02% Police 31,553,037 31,580,724 11,055,371 20,525,353 35.01% 1.68% Fire 21,181,684 21,181,684 8,497,522 12,684,162 40.12% 6.79% Public Works 4,775,106 4,779,860 1,825,408 2,954,452 38.19% 4.86% COVID Reserve 1,468,971 1,468,971 1,468,971 0.00% -33.33% Debt service 566,972 566,972 566,972 0.00% -33.33% Total Expenditures 74,427,013 74,459,454 28,112,416 46,347,038 37.76% 4.43% Other Financing Uses: Transfers Out 10,000 10,000 35,300 (25,300) 353.00% 319.67% Total Expenditures and Other Financing Uses 74,437,013 74,469,454 28,147,716 46,321,738 37.80% 4.47% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 39,285 (6,629,502) (6,668,787) Unassigned Fund Balance at Beginning of Year 5,404,586 Cancellation of prior year encumbrances 10,572 Change in other fund balance components during the year (47,759) Year-end investment market value adjustment Ending Unassigned Fund Balance, 10/31/20 (1,262,103) Restricted 154,177 Committed 17,953 Assigned 3,810,022 Total Fund Balance $ 2,720,049
1
For the period ended October 31, 2020
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Street
For
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Sales Taxes $ 8,028,559 8,028,559 2,750,494 (5,278,065) 34.26% 0.93% Charges for Services 7,088 7,088 0.00% -33.33% Intergovernmental Revenue 0.00% -33.33% Investment Income (Loss) 10,000 10,000 15,047 5,047 150.47% 117.14% Other Revenue 0.00% -33.33% Total Revenues 8,038,559 8,038,559 2,772,629 (5,265,930) 34.49% 1.16% Other Financing sources: Transfers in 0.00% -33.33% Issuance of debt 0.00% -33.33% Total other financing sources 0.00% -33.33% Total revenues and other financing sources 8,038,559 8,038,559 2,772,629 (5,265,930) 34.49% 1.16% Expenditures: General Government 0.00% -33.33% Street Maintenance 929,575 994,575 497,170 497,405 49.99% 16.66% Capital Outlay 4,971,836 29,339,674 4,851,409 24,488,265 16.54% -16.79% Debt Service 555,951 555,951 338,877 217,074 0.00% -33.33% Total Expenditures 6,457,362 30,890,200 5,687,456 25,202,744 18.41% -14.92% Other Financing Uses: Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 6,457,362 30,890,200 5,687,456 25,202,744 18.41% -14.92% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 1,581,197 (22,851,641) (2,914,827) 19,936,814 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 (919) Year-end investment market value adjustment Ending Unassigned Fund Balance, 10/31/20 (4,255,857) Fund Balance Components: Restricted - Current Year Encumbrances 1,613,912 Restricted - Prior Year Encumbrances 1,947,615 Restricted - Debt Reserve Project Accounts - Capital Projects 17,864,035 Total Fund Balance $ 17,169,705
Improvements Sales Tax Fund
2
the period ended October 31, 2020
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Park Improvements Sales Tax Fund For the period ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Sales Taxes $ 4,014,300 4,014,300 1,375,246 (2,639,054) 34.26% 0.93% Charges for services 348,455 348,455 21,880 (326,575) 6.28% -27.05% Intergovernmental 0.00% -33.33% Investment Income (Loss) 3,000 3,000 5,996 2,996 199.87% 166.54% Other Revenue 2,500 2,500 6,176 3,676 247.04% 213.71% Total Revenues 4,368,255 4,368,255 1,409,298 (2,958,957) 32.26% -1.07% Other Financing Sources: Transfers In 25,300 25,300 100.00% 66.67% Proceeds from Bond Issuance/Capital Lease 0.00% -33.33% Total Other Financing Sources 25,300 25,300 0.00% -33.33% Total Revenues and Other Financing Sources 4,368,255 4,393,555 1,434,598 (2,958,957) 32.65% -0.68% Expenditures: Culture and Recreation 3,640,907 3,640,907 1,037,984 2,602,923 28.51% -4.82% Capital Outlay 280,625 1,092,997 30,862 1,062,135 2.82% -30.51% Debt Service 261,589 261,589 73,217 188,372 27.99% -5.34% Total Expenditures 4,183,121 4,995,493 1,142,063 3,853,430 22.86% -10.47% Other Financing Uses: Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 4,183,121 4,995,493 1,142,063 3,853,430 22.86% -10.47% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 185,134 (601,938) 292,535 894,473 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, 10/31/20 (365,503) Other Fund Balance Components: Restricted - Current Year Encumbrances 160,833 Restricted - Prior Year Encumbrances 15,553 Total Fund Balance $ (189,117)
3
CITY OF INDEPENDENCE, MISSOURI Budgetary
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Sales Taxes $ 4,014,317 4,014,317 1,375,246 (2,639,071) 34.26% 0.93% Investment income (loss) 24,500 24,500 48,703 24,203 198.79% 165.46% Other Revenue 31 31 0.00% -33.33% Total revenues 4,038,817 4,038,817 1,423,980 (2,614,837) 35.26% 1.93% Expenditures: Storm water Administration 342,871 342,871 117,790 225,081 34.35% 1.02% Maintenance 2,116,748 2,116,748 564,193 1,552,555 26.65% -6.68% Permit completion 318,000 318,000 2,800 315,200 0.88% -32.45% Capital outlay 1,300,000 3,867,673 87,562 3,780,111 2.26% -31.07% Total Expenditures 4,077,619 6,645,292 772,345 5,872,947 11.62% -21.71% Total Ependitures and Other Financing Uses 4,077,619 6,645,292 772,345 5,872,947 Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (38,802) (2,606,475) 651,635 3,258,110 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, 10/31/20 7,910,670 Other Fund Balance Components: Restricted - Current Year Encumbrances 257,184 Restricted - Prior Year Encumbrances 1,110,219 Restricted - Regional Detention Construction 540,563 Restricted - Regional Detention Maintenance 50,228 Restricted - Emergency Response Relief 500,000 Total Fund Balance $ 10,368,864
Comparison Schedule Storm Water Sales Tax Fund For the period ended October 31, 2020 4
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Police Public Safety Sales Tax Fund
For the period ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Sales Taxes $ 2,133,460 2,133,460 735,383 (1,398,077) 34.47% 1.14% Investment Income (Loss) 5,000 5,000 13,589 8,589 271.78% 238.45% Other Revenue 7,160 7,160 0.00% -33.33% Total Revenues 2,138,460 2,138,460 756,132 (1,382,328) 35.36% 2.03% Expenditures: Public Safety Communications 602,307 602,307 413,850 188,457 68.71% 35.38% Facilities 99,768 99,768 43,879 55,889 43.98% 10.65% Equipment 2,017,965 2,017,965 1,284,957 733,008 63.68% 30.35% Debt Service 0.00% -33.33% Total Expenditures 2,720,040 2,720,040 1,742,686 977,354 64.07% 30.74% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 2,720,040 2,720,040 1,742,686 977,354 64.07% 30.74% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (581,580) (581,580) (986,554) (404,974) Unassigned Fund Balance at Beginning of Year 2,534,213 Cancellation of Prior Year Encumbrances 13,312 Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 10/31/20 1,560,971 Other Fund Balance Components: Restricted - Current Year Encumbrances 856,683 Restricted - Prior Year Encumbrances 31,279 Total Fund Balance $ 2,448,933
5
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Fire Public Safety Sales Tax Fund For the period ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Sales Taxes $ 2,007,200 2,007,200 687,623 (1,319,577) 34.26% 0.93% Investment Income (Loss) 5,300 5,300 6,149 849 116.02% 82.69% Other Revenue 6,302 6,438 136 102.16% 68.83% Total Revenues 2,012,500 2,018,802 700,210 (1,318,592) 34.68% 1.35% Expenditures: Public Safety 2,183,900 2,183,900 1,577,698 606,202 72.24% 38.91% Debt Service 73,236 73,236 73,236 0.00% -33.33% Total Expenditures 2,257,136 2,257,136 1,577,698 679,438 69.90% 36.57% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 2,257,136 2,257,136 1,577,698 679,438 69.90% 36.57% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (244,636) (238,334) (877,488) (639,154) Unassigned Fund Balance at Beginning of Year 1,243,946 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 10/31/20 366,458 Other Fund Balance Components: Restricted - Current Year Encumbrances 1,376,196 Restricted - Prior Year Encumbrances 253,841 Total Fund Balance $ 1,996,495
6
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Animal Shelter Use Tax
For the period ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Use Tax $ 750,000 750,000 749,846 (154) 99.98% 66.65% Investment Income (Loss) 67 67 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 750,000 750,000 749,913 (87) 99.99% 66.66% Expenditures: General Government -33.33% Animal Services 744,152 744,152 247,416 496,736 33.25% -0.08% Capital Outlay 0.00% -33.33% Debt Service 0.00% -33.33% Total Expenditures 744,152 744,152 247,416 496,736 33.25% -0.08% Other Financing Uses: Transfers In 0.00% -33.33% Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 744,152 744,152 247,416 496,736 33.25% -0.08% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 5,848 5,848 502,497 496,649 Unassigned Fund Balance at Beginning of Year 306,747 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 10/31/20 809,244 Fund Balance Components: Restricted - Current Year Encumbrances 2,357 Restricted - Prior Year Encumbrances Total Fund Balance $ 811,601
7
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Police Use Tax
For the period ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Use Tax $ 750,000 750,000 749,846 (154) 99.98% 66.65% Investment Income (Loss) 2,614 2,614 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 750,000 750,000 752,460 2,460 100.33% 67.00% Expenditures: Public Safety 750,000 750,000 68,613 681,387 9.15% -24.18% Debt Service 0.00% -33.33% Total Expenditures 750,000 750,000 68,613 681,387 9.15% -24.18% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 750,000 750,000 68,613 681,387 9.15% -24.18% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 683,847 683,847 Unassigned Fund Balance at Beginning of Year 852,093 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 10/31/20 1,535,940 Other Fund Balance Components: Restricted - Current Year Encumbrances 29,333 Restricted - Prior Year Encumbrances Total Fund Balance $ 1,565,273
8
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule Health Property Tax Levy For the period ended October 31, 2020 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 832,000 832,000 (832,000) 0.00% -33.33% Charges for Services 154,000 154,000 33,983 (120,017) 22.07% -11.26% Investment Income (Loss) 0.00% -33.33% Other Revenue 101,572 101,572 0.00% -33.33% Total Revenues 986,000 986,000 135,555 (850,445) 13.75% -19.58% Expenditures: Animal Services 986,000 986,000 268,534 717,466 27.23% -6.10% Total Expenditures 986,000 986,000 268,534 717,466 27.23% -6.10% Other Financing Uses – Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Uses 986,000 986,000 268,534 717,466 27.23% -6.10% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (132,979) (132,979) 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, 10/31/20 (132,979) Other Fund Balance Components: Restricted - Current Year Encumbrances 1,542 Restricted - Prior Year Encumbrances Total Fund Balance $ (131,437)
9
CITY OF INDEPENDENCE, MISSOURI
Comparison Schedule Parks and Recreation Property Tax Levy For the period ended October 31, 2020 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 1,794,000 1,794,000 (1,794,000) 0.00% -33.33% Intergovernmental 30,000 30,000 10,000 (20,000) 33.33% 0.00% Charges for Services 184,813 184,813 61,525 (123,288) 33.29% -0.04% Investment Income (Loss) 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 2,008,813 2,008,813 71,525 (1,937,288) 3.56% -29.77% Expenditures: Parks and Recreation 1,899,830 1,899,830 618,643 1,281,187 32.56% -0.77% Total Expenditures 1,899,830 1,899,830 618,643 1,281,187 32.56% -0.77% Other Financing Uses – Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Uses 1,899,830 1,899,830 618,643 1,281,187 32.56% -0.77% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 108,983 108,983 (547,118) (656,101) 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, 10/31/20 (547,118) Other Fund Balance Components: Restricted - Current Year Encumbrances 14,389 Restricted - Prior Year Encumbrances Total Fund Balance $ (532,729) 10
Budgetary
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule Tourism Fund For the period ended October 31, 2020 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Transient Guest Taxes $ 1,860,354 1,860,354 426,613 (1,433,741) 22.93% -10.40% Charges for Services 23,944 23,944 1,447 (22,497) 6.04% -27.29% Investment Income (Loss) 3,300 3,300 7,202 3,902 218.24% 184.91% Other Revenue 15,600 15,600 (15,600) 0.00% -33.33% Total Revenues 1,903,198 1,903,198 435,262 (1,467,936) 22.87% -10.46% Expenditures: Tourism 1,997,806 2,174,064 629,842 1,544,222 28.97% -4.36% Total Expenditures 1,997,806 2,174,064 629,842 1,544,222 28.97% -4.36% Other Financing Uses – Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Uses 1,997,806 2,174,064 629,842 1,544,222 28.97% -4.36% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (94,608) (270,866) (194,580) 76,286 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, 10/31/20 715,522 Other Fund Balance Components: Restricted - Current Year Encumbrances 255,155 Restricted - Prior Year Encumbrances 87,289 Restricted - Operating Reserve 376,368 Total Fund Balance $ 1,434,334
11
Independence Square Benefit District For the period ended October 31, 2020 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 0.00% -33.33% Investment Income (Loss) 532 532 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 532 532 0.00% -33.33% Expenditures: Capital Outlay 0.00% -33.33% Total Expenditures 0.00% -33.33% Other Financing Uses – Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Uses 0.00% -33.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 532 532 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, 10/31/20 4,287 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 4,287 12
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Federal Grant - CDBG $ 814,159 814,159 71,188 (742,971) 8.74% -24.59% Other Revenue 11 11 -33.33% Total Revenues 814,159 814,159 71,199 (742,960) 8.75% -24.58% Expenditures: CDBG Administration 162,830 162,830 146,608 16,222 90.04% 56.71% CDBG Expenditures 663,994 663,994 170,745 493,249 25.71% -7.62% Total Expenditures 826,824 826,824 317,353 509,471 38.38% 5.05% Other Financing Uses: Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Uses 826,824 826,824 317,353 509,471 38.38% 5.05% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (12,665) (12,665) (246,154) (233,489) Unassigned Fund Balance at Beginning of Year (184,469) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 10/31/20 (430,623) Other Fund Balance Components: Restricted - Current Year Encumbrances 242,851 Restricted - Prior Year Encumbrances 180,986 Total Fund Balance $ (6,786)
Community Development Block Grant Fund For the period ended October 31, 2020 13
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Rental Rehabilitation For the period ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: HOME Program Grant $ 482,477 482,477 48,036 (434,441) 9.96% -23.37% Total Revenues 482,477 482,477 48,036 (434,441) 9.96% -23.37% Expenditures: HOME Administration 70,592 70,592 12,022 58,570 17.03% -16.30% Multi Family Housing 359,759 359,759 120,000 239,759 33.36% 0.03% Community Housing Development 102,788 102,788 102,788 0.00% -33.33% Total Expenditures 533,139 533,139 132,022 401,117 24.76% -8.57% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (50,662) (50,662) (83,986) (33,324) 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, 10/31/20 (269,563) Other Fund Balance Components: Restricted - Current Year Encumbrances 120,000 Restricted - Prior Year Encumbrances 149,458 Total Fund Balance $ (105)
14
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
License
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Licenses and Permits $ (2,640) (2,640) 0.00% -33.33% Investment Income (Loss) 4,000 4,000 6,423 2,423 160.58% 127.25% Other Revenue 0.00% -33.33% Total Revenues 4,000 4,000 3,783 (217) 94.58% 61.25% Expenditures: General Government 0.00% -33.33% Total expenditures 0.00% -33.33% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 0.00% -33.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 4,000 4,000 3,783 (217) 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, 10/31/20 1,286,661 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 1,286,661
Surcharge
period ended October 31, 2020 15
For the
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Grants
For the period ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Intergovernmental $ 585,503 3,484,095 1,336,967 (2,147,128) 38.37% 5.04% Charges for Services 41,212 41,212 0.00% -33.33% Other Revenue 27,938 342 (27,596) 1.22% -32.11% Total Revenues 585,503 3,512,033 1,378,521 (2,133,512) 39.25% 5.92% Expenditures: Public Safety 527,713 1,987,258 521,863 1,465,395 26.26% -7.07% General Government 33,550 169,678 14,802 154,876 8.72% -24.61% Culture and Recreation 300 56,519 15,356 41,163 27.17% -6.16% CARES Act Marketing 1,055,998 1,055,985 13 100.00% 66.67% Community Development 24,240 227,632 1,327,057 (1,099,425) 582.98% 549.65% Animal Services 15,247 15,247 0.00% -33.33% Total Expenditures 585,803 3,512,332 2,935,063 577,269 83.56% 50.23% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 585,803 3,512,332 2,935,063 577,269 83.56% 50.23% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (300) (299) (1,556,542) (1,556,243) 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, 10/31/20 (1,703,307) Other Fund Balance Components: Restricted - Current Year Encumbrances 1,840,213 Restricted - Prior Year Encumbrances 32,189 Total Fund Balance $ 169,095
16
CITY OF INDEPENDENCE, MISSOURI Budgetary
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Operating Revenues: Charges for Services $ 130,313,972 130,313,972 45,943,070 (84,370,902) 35.26% 1.93% Penalties 1,106,786 1,106,786 440,196 (666,590) 39.77% 6.44% Connection Charges 280,151 280,151 9,600 (270,551) 3.43% -29.90% Meter Reading 12,883 12,883 0.00% -33.33% Temporary Service 200 200 0.00% -33.33% Rental Income 340,239 340,239 13,398 (326,841) 3.94% -29.39% Transmission Wheeling 5,000,000 5,000,000 1,501,015 (3,498,985) 30.02% -3.31% Total Operating Revenues 137,041,148 137,041,148 47,920,362 (89,120,786) 34.97% 1.64% Operating Expenses: Personal Services 27,275,535 27,275,535 9,641,064 17,634,471 35.35% 2.02% Other Services 26,731,853 26,729,853 10,779,206 15,950,647 40.33% 7.00% Supplies 57,859,830 57,859,830 19,303,089 38,556,741 33.36% 0.03% Capital Projects 5,285,000 15,463,979 3,826,528 11,637,451 24.74% -8.59% Capital Operating 1,313,400 1,315,400 3,132 1,312,268 0.24% -33.09% Debt Service 10,547,050 10,547,050 3,513,544 7,033,506 33.31% -0.02% Other Expenses 275,000 275,000 275,000 0.00% -33.33% Total Operating Expenses 129,287,668 139,466,647 47,066,563 92,400,084 33.75% 0.42% Nonoperating Revenues (Expenses): Investment Income 200,000 200,000 197,630 (2,370) 98.82% 65.49% Interfund Charges for Support Services 1,828,147 1,828,147 583,847 (1,244,300) 31.94% -1.39% Miscellaneous Revenue (Expense) 886,189 886,189 (116,281) (1,002,470) -13.12% -46.45% Total Nonoperating Revenue (Expenses) 2,914,336 2,914,336 665,196 (2,249,140) 22.82% -10.51% 10,667,816 488,837 1,518,995 1,030,158 310.74% 277.41% Capital Contributions 0.00% -33.33% Transfers Out – Utility Payments In Lieu of Taxes (13,000,000) (13,000,000) (5,043,503) (7,956,497) 38.80% 5.47% Transfers In 0.00% -33.33% Transfers Out 0.00% -33.33% Total Transfers (13,000,000) (13,000,000) (5,043,503) (7,956,497) 38.80% 5.47% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (2,332,184) (12,511,163) (3,524,508) 8,986,655 Beginning Available Resources 75,879,069 Cancellation of Prior Year Encumbrances 31,615 Ending Available Resources 72,386,176 Current Debt Service Due 6,145,446 Operating Reserve (63 Days) 24,336,964 Mngt Recom Operating Reserve (27 Days) 10,430,100 Capital Projects in Process - Non Bond 11,637,451 Prior Year Open Encumbrances - Non Cap 2,045,841 Reserved Resources 54,595,802 Total Non-Restricted Resources Available $ 17,790,374 Income (Loss) Before Transfers
Schedule Power and Light For the period ended October 31, 2020 17
Comparison
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Water
For the period ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Operating Revenues: Charges for Services $ 31,850,000 31,850,000 11,965,285 (19,884,715) 37.57% 4.24% Penalties 170,000 170,000 68,209 (101,791) 40.12% 6.79% Connection/Disconnection Charges 83,750 83,750 2,627 (81,123) 3.14% -30.19% Meter Reading 1,000 1,000 2,854 1,854 285.40% 252.07% Returned Check Charges 10,000 10,000 6,905 (3,095) 69.05% 35.72% Rental Income 35,000 35,000 23,610 (11,390) 67.46% 34.13% Meter Repairs 250 250 (250) 0.00% -33.33% Merchandising Jobbing 3,852 3,852 0.00% -33.33% Total Operating Revenues 32,150,000 32,150,000 12,073,342 (20,076,658) 37.55% 4.22% Operating expenses: Personal Services 8,666,805 8,666,805 2,736,756 5,930,049 31.58% -1.75% Other Services 11,365,107 11,365,107 4,091,747 7,273,360 36.00% 2.67% Supplies 2,460,040 2,460,040 1,252,095 1,207,945 50.90% 17.57% Capital Projects 4,205,000 14,135,752 479,679 13,656,073 3.39% -29.94% Capital Operating 882,493 882,493 304,162 578,331 34.47% 1.14% Debt Service 2,533,338 2,533,338 1,939,313 594,025 76.55% 43.22% Other Expenses 125,000 125,000 125,000 0.00% -33.33% Total Operating Expenses 30,237,783 40,168,535 10,803,752 29,364,783 26.90% -6.43% Nonoperating Revenues (Expenses): Investment Income 75,000 75,000 186,708 111,708 248.94% 215.61% Interfund Charges for Support Services 1,392,092 1,392,092 464,031 (928,061) 33.33% 0.00% Miscellaneous Revenue (Expense) 5,390 5,390 0.00% -33.33% Total Nonoperating Revenue (Expenses) 1,467,092 1,467,092 656,129 (810,963) 44.72% 11.39% 3,379,309 (6,551,443) 1,925,719 8,477,162 -29.39% -62.72% Transfers Out – Utility Payments In Lieu of Taxes (3,200,000) (3,200,000) (1,151,563) (2,048,437) 35.99% 2.66% Transfers In 0.00% -33.33% Transfers Out 0.00% -33.33% Total Transfers (3,200,000) (3,200,000) (1,151,563) (2,048,437) 35.99% 2.66% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 179,309 (9,751,443) 774,156 10,525,599 Beginning Available Resources 32,358,367 Cancellation of Prior Year Encumbrances 11,238 Ending Available Resources 33,143,761 Current Debt Service Due 2,061,369 Operating Reserve (63 Days) 4,889,277 Mngt Recom Operating Reserve (27 Days) 2,095,389 Capital Projects in Process - Non Bond 13,656,073 Prior Year Open Encumbrances - Non Cap 746,959 Reserved Resources 23,449,067 Total Non-Restricted Resources Available $ 9,694,694 Income (Loss) Before Transfers
18
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Sanitary
For the period ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Operating revenues: Charges for Services $ 33,393,893 33,393,893 12,204,891 (21,189,002) 36.55% 3.22% Penalties 200,000 200,000 98,003 (101,997) 49.00% 15.67% Total operating revenues 33,593,893 33,593,893 12,302,894 (21,290,999) 36.62% 3.29% Operating expenses: Personal Services 5,868,295 5,868,295 1,969,547 3,898,748 33.56% 0.23% Other Services 13,075,398 13,075,398 3,186,776 9,888,622 24.37% -8.96% Supplies 661,840 661,840 224,348 437,492 33.90% 0.57% Capital Projects 5,330,000 12,887,707 66,890 12,820,817 0.52% -32.81% Capital Operating 926,000 926,000 752,862 173,138 81.30% 47.97% Debt Service 6,290,632 6,290,632 3,575,785 2,714,847 56.84% 23.51% Other Expenses 30,000 30,000 30,000 0.00% -33.33% Total Operating Expenses 32,182,165 39,739,872 9,776,208 29,963,664 24.60% -8.73% Nonoperating Revenues (Expenses): Investment Income 51,000 51,000 81,295 30,295 159.40% 126.07% Miscellaneous Revenue (Expense) (2,074) (2,074) 0.00% -33.33% Total Nonoperating Revenue (Expenses) 51,000 51,000 79,221 28,221 155.34% 122.01% 1,462,728 (6,094,979) 2,605,907 8,700,886 -42.75% -76.08% Transfers Out – Utility Payments In Lieu of Taxes (3,596,612) (3,596,612) (1,101,660) (2,494,952) 30.63% -2.70% Transfers In 10,000 10,000 10,000 100.00% 66.67% Transfers Out 0.00% -33.33% Total Transfers (3,586,612) (3,586,612) (1,091,660) (2,494,952) 30.44% -2.89% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (2,123,884) (9,681,591) 1,514,247 11,195,838 Beginning Available Resources 20,160,346 Cancellation of Prior Year Encumbrances 43,300 Ending Available Resources 21,717,893 Current Debt Service Due 4,221,328 Operating Reserve (63 Days) 5,164,395 Mngt Recom Operating Reserve (27 Days) 2,213,325 Capital Projects in Process - Non Bond 10,702,768 Prior Year Open Encumbrances - Non Cap 237,366 Reserved Resources 22,539,182 Total Non-Restricted Resources Available $ (821,289) Income (Loss) Before Transfers
Sewer
19
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Events Center Debt Service
For the period ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Operating revenues: Charges for Services $ 0.00% -33.33% Miscellaneous 0.00% -33.33% Total operating revenues 0.00% -33.33% Operating Expenses: Personal Services 0.00% -33.33% Other Services 316 (316) 0.00% -33.33% Supplies 0.00% -33.33% Capital Outlay 75,000 1,478,361 115,244 1,363,117 7.80% -25.53% Debt Service 5,173,844 5,173,844 1,230,865 3,942,979 23.79% -9.54% Other Expenses 0.00% -33.33% Total Operating Expenses 5,248,844 6,652,205 1,346,425 5,305,780 20.24% -13.09% Nonoperating Revenues (Expenses): Investment Income 0.00% -33.33% Miscellaneous Revenue (Expense) 0.00% -33.33% Sales Tax 5,173,844 5,173,844 1,100,062 (4,073,782) 21.26% -12.07% Total Nonoperating Revenue (Expenses) 5,173,844 5,173,844 1,100,062 (4,073,782) 0.00% -33.33% (75,000) (1,478,361) (246,363) 1,231,998 16.66% -16.67% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -33.33% Transfers In 75,000 75,000 75,000 0.00% -33.33% Transfers Out 0.00% -33.33% Total Transfers 75,000 75,000 75,000 0.00% -33.33% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (1,403,361) (246,363) 1,156,998 Unassigned Fund Balance at Beginning of Year (24,424,459) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year (418,802) Ending Unassigned Fund Balance, 10/31/20 (25,089,624) Restricted: Bond Reserve Project Accounts 6,792,678 Total restricted 6,792,678 Committed: Capital Projects In Process 1,363,117 Total Committed 1,363,117 Assigned: Prior Year Open Encumbrances - Excluding Capital Projects Current Year Open Encumbrances - Excluding Capital Projects Total Assigned Total Fund Balance $ (16,933,829) Income (Loss) Before Transfers
20
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Central Garage
For the period ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Operating revenues: Charges for Services $ 2,088,731 2,088,731 592,166 (1,496,565) 28.35% -4.98% Miscellaneous 918 918 0.00% -33.33% Total Operating Revenues 2,088,731 2,088,731 593,084 (1,495,647) 28.39% -4.94% Operating Expenses: Personal Services 754,502 754,502 244,563 509,939 32.41% -0.92% Other Services 550,811 547,411 399,075 148,336 72.90% 39.57% Supplies 768,986 772,386 281,363 491,023 36.43% 3.10% Capital Outlay 25,375 25,375 2,062 23,313 8.13% -25.20% Other Expenses 0.00% -33.33% Total Operating Expenses 2,099,674 2,099,674 927,063 1,172,611 44.15% 10.82% Nonoperating Revenues (Expenses): Investment Income 300 300 2,781 2,481 927.00% 893.67% Miscellaneous Revenue (Expense) 1,140 1,140 0.00% -33.33% Total Nonoperating Revenue (Expenses) 300 300 3,921 3,621 1307.00% 1273.67% (10,643) (10,643) (330,058) (319,415) 3101.17% 3067.84% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -33.33% Transfers In 0.00% -33.33% Transfers Out 0.00% -33.33% Total Transfers 0.00% -33.33% Change In Net Position (Budget Basis) $ (10,643) (10,643) (330,058) (319,415) Unassigned Fund Balance at Beginning of Year (1,201,790) Cancellation of Prior Year Encumbrances 13,000 Change in Other Fund Balance Components During the Year (40,157) Year-end investment market value adjustment Ending Unassigned Fund Balance GAAP Basis, 10/31/20 (1,559,005) Other Net Position Components: Assigned - Current Year Encumbrances 375,279 Assigned - Prior Year Encumbrances 20,096 Total Fund Balance $ (1,163,630) Income (Loss) Before Transfers
21
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Staywell Health Care
For the period ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Operating revenues: Charges for Services $ 14,532,190 14,532,190 5,922,936 (8,609,254) 40.76% 7.43% Miscellaneous 0.00% -33.33% Total Operating Revenues 14,532,190 14,532,190 5,922,936 (8,609,254) 40.76% 7.43% Operating Expenses: Personal Services 6,000 (6,000) 0.00% -33.33% Other Services 14,532,190 14,532,190 8,227,792 6,304,398 56.62% 23.29% Supplies 128 (128) 0.00% -33.33% Capital Outlay 0.00% -33.33% Other Expenses 0.00% -33.33% Total Operating Expenses 14,532,190 14,532,190 8,233,920 6,298,270 56.66% 23.33% Nonoperating Revenues (Expenses): Investment Income 2,219 2,219 0.00% -33.33% Miscellaneous Revenue (Expense) 366,047 366,047 0.00% -33.33% Total Nonoperating Revenue (Expenses) 368,266 368,266 0.00% -33.33% (1,942,718) (1,942,718) 0.00% -33.33% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -33.33% Transfers In 0.00% -33.33% Transfers Out 0.00% -33.33% Total Transfers 0.00% -33.33% Change In Net Position (Budget Basis) $ (1,942,718) (1,942,718) Unassigned Fund Balance at Beginning of Year 3,312,003 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance GAAP Basis, 10/31/20 1,369,285 Other Net Position Components: Assigned - Current Year Encumbrances Assigned - Prior Year Encumbrances Total Fund Balance $ 1,369,285 Income (Loss) Before Transfers
22
CITY OF INDEPENDENCE, MISSOURI Budgetary
Comparison Schedule
Workers' Compensation
For the period ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Operating revenues: Charges for Services $ 3,558,840 3,558,840 1,186,280 (2,372,560) 33.33% 0.00% Miscellaneous 875 875 0.00% -33.33% Total Operating Revenues 3,558,840 3,558,840 1,187,155 (2,371,685) 33.36% 0.03% Operating Expenses: Personal Services 21,000 21,000 21,000 0.00% -33.33% Other Services 4,500,000 4,500,000 1,184,828 3,315,172 26.33% -7.00% Supplies 4,000 4,000 4,000 0.00% -33.33% Capital Outlay 2,000 2,000 2,000 0.00% -33.33% Other Expenses 0.00% -33.33% Total Operating Expenses 4,527,000 4,527,000 1,184,828 3,342,172 26.17% -7.16% Nonoperating Revenues (Expenses): Investment Income 12,000 12,000 900 (11,100) 7.50% -25.83% Miscellaneous Revenue (Expense) 11,304 11,304 0.00% -33.33% Total Nonoperating Revenue (Expenses) 12,000 12,000 12,204 204 101.70% 68.37% (956,160) (956,160) 14,531 970,691 -1.52% -34.85% Transfers In 0.00% -33.33% Transfers Out 0.00% -33.33% Total Transfers 0.00% -33.33% Change In Net Position (Budget Basis) $ (956,160) (956,160) 14,531 970,691 Unassigned Fund Balance at Beginning of Year (8,708,468) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year (3,588) Year-end investment market value adjustment Ending Unassigned Fund Balance GAAP Basis, 10/31/20 (8,697,525) Other Net Position Components: Restricted - Work Comp Escrow Assigned - Current Year Encumbrances 49,500 Assigned - Prior Year Encumbrances 10,675 Total Fund Balance $ (8,637,350) Income (Loss) Before Transfers
23
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Risk Management
For the period ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Operating revenues: Charges for Services $ 2,991,000 2,991,000 747,750 (2,243,250) 25.00% -8.33% Miscellaneous 0.00% -33.33% Total Operating Revenues 2,991,000 2,991,000 747,750 (2,243,250) 25.00% -8.33% Operating Expenses: Personal Services 15,000 15,000 15,000 0.00% -33.33% Other Services 2,988,000 2,988,000 1,108,024 1,879,976 37.08% 3.75% Supplies 3,000 3,000 3,000 0.00% -33.33% Capital Outlay 0.00% -33.33% Other Expenses 0.00% -33.33% Total Operating Expenses 3,006,000 3,006,000 1,108,024 1,897,976 36.86% 3.53% Nonoperating Revenues (Expenses): Investment Income 3,557 3,557 0.00% -33.33% Miscellaneous Revenue (Expense) 0.00% -33.33% Total Nonoperating Revenue (Expenses) 3,557 3,557 0.00% -33.33% (15,000) (15,000) (356,717) (341,717) 2378.11% 2344.78% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -33.33% Transfers In 0.00% -33.33% Transfers Out 0.00% -33.33% Total Transfers 0.00% -33.33% Change In Net Position (Budget Basis) $ (15,000) (15,000) (356,717) (341,717) 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, 10/31/20 216,566 Other Net Position Components: Assigned - Current Year Encumbrances Assigned - Prior Year Encumbrances 732 Total Fund Balance $ 217,298 Income (Loss) Before Transfers
24
CITY OF INDEPENDENCE, MISSOURI
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Operating revenues: Charges for Services $ 1,430,000 1,430,000 357,500 (1,072,500) 25.00% -8.33% Miscellaneous 0.00% -33.33% Total Operating Revenues 1,430,000 1,430,000 357,500 (1,072,500) 25.00% -8.33% Operating Expenses: Personal Services 430,000 430,000 201,524 228,476 46.87% 13.54% Other Services 999,561 999,561 53,750 945,811 5.38% -27.95% Supplies 0.00% -33.33% Capital Outlay 2,559,491 (2,559,491) 0.00% -33.33% Other Expenses 0.00% -33.33% Total Operating Expenses 1,429,561 1,429,561 2,814,765 (1,385,204) 196.90% 163.57% Nonoperating Revenues (Expenses): Investment Income 200 200 (200) 0.00% -33.33% Miscellaneous Revenue (Expense) 0.00% -33.33% Total Nonoperating Revenue (Expenses) 200 200 (200) 0.00% -33.33% 639 639 (2,457,265) (2,457,904) -384548.51% -384581.84% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -33.33% Transfers In 0.00% -33.33% Transfers Out 0.00% -33.33% Total Transfers 0.00% -33.33% Change In Net Position (Budget Basis) $ 639 639 (2,457,265) (2,457,904) Unassigned Fund Balance at Beginning of Year (917,478) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance GAAP Basis, 10/31/20 (3,374,743) Other Net Position Components: Assigned - Current Year Encumbrances 1,723,672 Assigned - Prior Year Encumbrances 108,608 Total Fund Balance $ (1,542,463) Income (Loss) Before Transfers
Budgetary Comparison Schedule Enterprise Resource Planning For the period ended October 31, 2020 25
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Charges for Services $ 0.00% -33.33% Investment Income (Loss) 500 500 81 (419) 16.20% -17.13% Other Revenue 0.00% -33.33% Total Revenues 500 500 81 (419) 16.20% -17.13% Expenditures: General Government 0.00% -33.33% Debt Service 9,998 9,998 1,290 8,708 12.90% -20.43% Total Expenditures 9,998 9,998 1,290 8,708 12.90% -20.43% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total expenditures and other financing uses 9,998 9,998 1,290 8,708 12.90% -20.43% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (9,498) (9,498) (1,209) 8,289 Unassigned Fund Balance at Beginning of Year 103,246 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 10/31/20 102,037 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 102,037
Comparison Schedule Debt Service - Neighborhood Improvement Districts For the period ended October 31, 2020 26
CITY OF INDEPENDENCE, MISSOURI Budgetary
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Charges for Services $ 358 358 0.00% -33.33% Investment Income 657 657 0.00% -33.33% Intergovernmental 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 1,015 1,015 0.00% -33.33% Other Financing Sources: Transfers In 0.00% -33.33% Total Other Financing Sources 0.00% -33.33% Total Revenues and Other Financing Sources 1,015 1,015 0.00% -33.33% Expenditures: Public Works 0.00% -33.33% Culture and Recreation 0.00% -33.33% Capital Outlay 338,651 75,000 263,651 22.15% -11.18% Total Expenditures 338,651 75,000 263,651 22.15% -11.18% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 338,651 75,000 263,651 22.15% -11.18% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (338,651) (73,985) 264,666 Unassigned Fund Balance at Beginning of Year (51,591) Cancellation of Prior Year Encumbrances 7,507 Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 10/31/20 (118,069) Other Fund Balance Components: Committed - Current Year Encumbrances 75,000 Committed - Prior Year Encumbrances 72,244 Total Fund Balance $ 29,175 Budgetary Comparison Schedule
Street Improvements Capital Project Fund For the period ended October 31, 2020 27
CITY OF INDEPENDENCE, MISSOURI
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Revolving Public Improvements Capital Project Fund For the period ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Charges for Services $ 0.00% -33.33% Investment Income (Loss) 109 109 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 109 109 0.00% -33.33% Expenditures: Public Works 0.00% -33.33% Culture and Recreation 0.00% -33.33% Capital Outlay 0.00% -33.33% Total Expenditures 0.00% -33.33% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 0.00% -33.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 109 109 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, 10/31/20 21,686 Other Fund Balance Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances Total Fund Balance $ 21,686
28
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Charges for Services $ 0.00% -33.33% Investment Income 4 4 0.00% -33.33% Other Revenue 0.00% -33.33% Total revenues 4 4 0.00% -33.33% Other Financing Sources: Transfers In 0.00% -33.33% Total Other Financing Sources 0.00% -33.33% Total Revenues and Other Financing Sources 4 4 0.00% -33.33% Expenditures: Public Works 0.00% -33.33% Culture and Recreation 0.00% -33.33% Capital Outlay 1,167,821 1,167,821 0.00% -33.33% Total Expenditures 1,167,821 1,167,821 0.00% -33.33% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total expenditures and other financing uses 1,167,821 1,167,821 0.00% -33.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (1,167,821) 4 1,167,825 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, 10/31/20 (74,443) Other Fund Balance Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances 69,980 Total Fund Balance $ (4,463)
Schedule Buildings and Other Improvements Capital Project Fund For the period ended October 31, 2020 29
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Charges for Services $ 0.00% -33.33% Investment Income 0.00% -33.33% Other Revenue 0.00% -33.33% Total revenues 0.00% -33.33% Expenditures: Public Works 0.00% -33.33% Culture and Recreation 0.00% -33.33% Capital Outlay 0.00% -33.33% Total Expenditures 0.00% -33.33% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total expenditures and other financing uses 0.00% -33.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ Unassigned Fund Balance at Beginning of Year (16,155) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 10/31/20 (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 October 31, 2020 30
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Park Improvements Capital Project Fund For the period ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Charges for Services $ 0.00% -33.33% Investment Income (Loss) 163 163 0.00% -33.33% Other Revenue 0.00% -33.33% Total revenues 163 163 0.00% -33.33% Expenditures: Public Works 0.00% -33.33% Culture and Recreation 0.00% -33.33% Capital Outlay 0.00% -33.33% Total Expenditures 0.00% -33.33% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total expenditures and other financing uses 0.00% -33.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 163 163 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, 10/31/20 31,589 Fund Balance Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances Total Fund Balance $ 31,589
31
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Charges for Services $ 16,600 16,600 (16,600) 0.00% -33.33% Investment Income 68 68 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 16,600 16,600 68 (16,532) 0.41% -32.92% Expenditures: Public Works 0.00% -33.33% Culture and Recreation 18,209 18,209 2,411 15,798 13.24% -20.09% Capital Outlay 0.00% -33.33% Total Expenditures 18,209 18,209 2,411 15,798 13.24% -20.09% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 18,209 18,209 2,411 15,798 13.24% -20.09% Excess of revenues over (under) expenditures and Other Financing Uses, Budget Basis $ (1,609) (1,609) (2,343) (734) 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, 10/31/20 7,152 Other Net Position Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances Total Net Position $ 7,152
Private Purpose Expendable Trust Fund - Vaile Mansion For the period ended October 31, 2020 32
Schedule
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Independence Events Center CID For the period ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Sales Taxes $ 7,700,767 7,700,767 1,873,574 (5,827,193) 24.33% -9.00% Investment Income 128,715 128,715 5,793 (122,922) 4.50% -28.83% Total Revenues 7,829,482 7,829,482 1,879,367 (5,950,115) 24.00% -9.33% Expenditures: Administrative Fee 154,015 154,015 37,471 116,544 24.33% -9.00% Insurance 2,150 2,150 2,150 0.00% -33.33% Legal 44,850 44,850 44,850 0.00% -33.33% Audit 5,150 5,150 5,150 100.00% 66.67% Banking 5,916 5,916 2,048 3,868 34.62% 1.29% Contract Services 310,500 310,500 300,000 10,500 96.62% 63.29% Capital Outlay 0.00% -33.33% Other 0.00% -33.33% Total Expenditures 522,581 522,581 344,669 177,912 65.96% 32.63% Other Financing Uses: Transfers Out - EATS (75,000) (75,000) (75,000) 0.00% -33.33% Transfers Out - Debt Service (City) (5,173,844) (5,173,844) (1,100,062) (4,073,782) 21.26% -12.07% Total Other Financing Uses (5,248,844) (5,248,844) (1,100,062) (4,148,782) 20.96% -12.37% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 2,058,057 2,058,057 434,636 (1,623,421) Unassigned Fund Balance at Beginning of Year 7,010,144 Cancellation of Prior Year Encumbrances 23,225 Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 10/31/20 7,468,005 Other Fund Balance Components: Restricted - current year encumbrances 5,150 Restricted - prior year encumbrances 7,500 Total Fund Balance $ 7,480,655
33
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Sales taxes $ 103,323 103,323 0.00% -33.33% Investment income 74 74 0.00% -33.33% Total revenues 103,397 103,397 0.00% -33.33% Expenditures: Administrative fee 2,066 (2,066) 0.00% -33.33% Insurance 2,000 2,000 2,000 0.00% -33.33% Legal 1,250 (1,250) 0.00% -33.33% Audit 4,700 4,700 5,150 (450) 109.57% 76.24% Banking 116 (116) 0.00% -33.33% Contract services 0.00% -33.33% Capital outlay 0.00% -33.33% Other 0.00% -33.33% Total expenditures 6,700 6,700 8,582 (1,882) 128.09% 94.76% Other financing uses: Transfers out - EATS (248,491) (248,491) (51,662) (196,829) 20.79% -12.54% Transfers out - Debt Service (City) (215,000) (215,000) (86,000) (129,000) 40.00% 6.67% Total other financing uses (463,491) (463,491) (137,662) (325,829) 29.70% -3.63% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (470,191) (470,191) (42,847) 427,344 Unassigned Fund Balance at Beginning of Year 82,217 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year (128) Unassigned Ending Fund Balance, 10/31/20 39,242 Other Fund Balance Components: Restricted - Current Year Encumbrances 5,150 Restricted - Prior Year Encumbrances Restricted - City Transportation 5,916 Total Fund Balance $ 50,308
Crackerneck Creek TDD For the period ended October 31, 2020 34
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Tax Increment Financing Summary For the Period Ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 16,229,006 16,228,916 2,088,548 (14,140,368) 12.87% -20.46% Investment Income (Loss) 113,885 113,885 0.00% -33.33% Other revenue 1,310,958 1,310,958 335,002 (975,956) 25.55% -7.78% Total Revenues 17,539,964 17,539,874 2,537,435 (15,002,439) 14.47% -18.86% Other Financing Sources: Transfers In 1,327,471 1,327,471 (1,327,471) 0.00% -33.33% Total Other Financing Sources 1,327,471 1,327,471 (1,327,471) 0.00% -33.33% Total Revenues and Other Financing Sources 18,867,435 18,867,345 2,537,435 (16,329,910) 13.45% -19.88% Expenditures: Tax Increment Financing 1,792,897 1,792,897 16,692 1,776,205 0.93% -32.40% Debt Service Principal 9,594,866 10,081,215 95,000 9,986,215 0.94% -32.39% Interest and Fiscal Agent Fees 5,587,948 5,587,948 2,773,851 2,814,097 49.64% 16.31% Debt Issuance Costs 0.00% -33.33% Total Expenditures 16,975,711 17,462,060 2,885,543 14,576,517 16.52% -16.81% Other Financing Uses: Issuance of Debt 0.00% -33.33% Reoffering Premium/Original Issue Discount 0.00% -33.33% Payment to Refund Loans Escrow Agent 0.00% -33.33% Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 16,975,711 17,462,060 2,885,543 14,576,517 16.52% -16.81% Excess of Revenues Over (Under) Expenditures and other financing uses $ 1,891,724 1,405,285 (348,108) (1,753,393) Unassigned Fund Balance at Beginning of Year 18,749,315 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Unassigned Ending Fund Balance, 10/31/20 18,401,207 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances 15,226 Restricted - Trust Debt Service 12,333,319 Total Fund Balance $ 30,749,752
35
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 0.00% -33.33% Investment Income (Loss) 8 8 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 8 8 0.00% -33.33% Expenditures: Tax Increment Financing 0.00% -33.33% Debt Service Principal 0.00% -33.33% Interest and Fiscal Agent Fees 0.00% -33.33% Debt Issuance Costs 0.00% -33.33% Total Expenditures 0.00% -33.33% Other Financing Uses: Issuance of Debt 0.00% -33.33% Reoffering Premium/Original Issue Discount 0.00% -33.33% Payment to Refund Loans Escrow Agent 0.00% -33.33% Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 0.00% -33.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 8 8 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, 10/31/20 1,580 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 1,580
Truman Rd TIF
the Period Ended October 31, 2020 36
Schedule Mid-Town
For
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
For the Period Ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 257,999 257,999 3,238 (254,761) 1.26% -32.07% Investment Income (Loss) 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 257,999 257,999 3,238 (254,761) 1.26% -32.07% Expenditures: Tax Increment Financing 3,822 3,822 3,822 0.00% -33.33% Debt Service Principal 50,950 50,950 50,950 0.00% -33.33% Interest and Fiscal Agent Fees 203,227 203,227 203,227 0.00% -33.33% Debt Issuance Costs 0.00% -33.33% Total Expenditures 257,999 257,999 257,999 0.00% -33.33% Other Financing Uses: Issuance of Debt 0.00% -33.33% Reoffering Premium/Original Issue Discount 0.00% -33.33% Payment to Refund Loans Escrow Agent 0.00% -33.33% Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 257,999 257,999 257,999 0.00% -33.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 3,238 3,238 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, 10/31/20 18,960 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 18,960
RSO TIF
37
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 26,271 26,271 1,589 (24,682) 6.05% -27.28% Investment Income (Loss) (23) (23) 0.00% -33.33% Other Revenue 102,958 102,958 19,230 (83,728) 18.68% -14.65% Total Revenues 129,229 129,229 20,796 (108,433) 16.09% -17.24% Other Financing Sources: Transfers In 187,942 187,942 (187,942) 0.00% -33.33% Total Other Financing Sources 187,942 187,942 (187,942) 0.00% -33.33% Total Revenues and Other Financing Sources 317,171 317,171 20,796 (296,375) 6.56% -26.77% Expenditures: Tax Increment Financing 7,801 7,801 3,000 4,801 38.46% 5.13% Debt Service Principal 190,000 190,000 95,000 95,000 50.00% 16.67% Interest and Fiscal Agent Fees 339,938 339,938 167,831 172,107 49.37% 16.04% Debt Issuance Costs 0.00% -33.33% Total Expenditures 537,739 537,739 265,831 271,908 49.43% 16.10% Other Financing Uses: Issuance of Debt 0.00% -33.33% Reoffering Premium/Original Issue Discount 0.00% -33.33% Payment to Refund Loans Escrow Agent 0.00% -33.33% Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 537,739 537,739 265,831 271,908 49.43% 16.10% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (220,568) (220,568) (245,035) (24,467) 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, 10/31/20 (1,451,929) Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 557,834 Total Fund Balance $ (894,095)
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Santa Fe TIF For the Period Ended October 31, 2020 38
CITY
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 1,446,920 1,446,920 132,087 (1,314,833) 9.13% -24.20% Investment Income (Loss) 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 1,446,920 1,446,920 132,087 (1,314,833) 9.13% -24.20% Other Financing Sources: Transfers In 118,097 118,097 (118,097) 0.00% -33.33% Total Other Financing Sources 118,097 118,097 (118,097) 0.00% -33.33% Total Revenues and Other Financing Sources 1,565,017 1,565,017 132,087 (1,432,930) 8.44% -24.89% Expenditures: Tax Increment Financing 121,261 121,261 121,261 0.00% -33.33% Debt Service Principal 1,630,000 1,630,000 1,630,000 0.00% -33.33% Interest and Fiscal Agent Fees 140,068 140,068 37,434 102,634 26.73% -6.60% Debt Issuance Costs 0.00% -33.33% Total Expenditures 1,891,329 1,891,329 37,434 1,853,895 1.98% -31.35% Other Financing Uses: Issuance of Debt 0.00% -33.33% Reoffering Premium/Original Issue Discount 0.00% -33.33% Payment to Refund Loans Escrow Agent 0.00% -33.33% Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 1,891,329 1,891,329 37,434 1,853,895 1.98% -31.35% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (326,312) (326,312) 94,653 420,965 Unassigned Fund Balance at Beginning of Year (2,498,197) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 10/31/20 (2,403,544) Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ (2,403,544)
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Hartman Heritage TIF
the Period
39
CITY
For
Ended October 31, 2020
CITY
MISSOURI
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 568,730 568,730 14,673 (554,057) 2.58% -30.75% Investment Income (Loss) 9,276 9,276 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 568,730 568,730 23,949 (544,781) 4.21% -29.12% Expenditures: Tax Increment Financing 15,338 15,338 1,250 14,088 8.15% -25.18% Debt Service Principal 385,000 385,000 385,000 0.00% -33.33% Interest and Fiscal Agent Fees 36,150 36,150 12,300 23,850 34.02% 0.69% Debt Issuance Costs 0.00% -33.33% Total Expenditures 436,488 436,488 13,550 422,938 3.10% -30.23% Other Financing Uses: Issuance of Debt 0.00% -33.33% Reoffering Premium/Original Issue Discount 0.00% -33.33% Payment to Refund Loans Escrow Agent 0.00% -33.33% Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 436,488 436,488 13,550 422,938 3.10% -30.23% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 132,242 132,242 10,399 (121,843) 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, 10/31/20 1,852,061 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 1,852,061
OF INDEPENDENCE,
Budgetary Comparison Schedule Drumm Farm TIF For the Period Ended October 31, 2020 40
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Eastland TIF
For the Period Ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 5,053,492 5,053,492 929,158 (4,124,334) 18.39% -14.94% Investment Income (Loss) 60,996 60,996 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 5,053,492 5,053,492 990,154 (4,063,338) 19.59% -13.74% Other Financing Sources: Transfers In 664,783 664,783 (664,783) 0.00% -33.33% Total Other Financing Sources 664,783 664,783 (664,783) 0.00% -33.33% Total Revenues and Other Financing Sources 5,718,275 5,718,275 990,154 (4,728,121) 17.32% -16.01% Expenditures: Tax Increment Financing 457,612 457,612 1,250 456,362 0.27% -33.06% Debt Service Principal 2,870,000 2,870,000 2,870,000 0.00% -33.33% Interest and Fiscal Agent Fees 115 115 145,825 (145,710) 126804.35% 126771.02% Debt Issuance Costs 0.00% -33.33% Total Expenditures 3,327,727 3,327,727 147,075 3,180,652 4.42% -28.91% Other Financing Uses: Issuance of Debt 0.00% -33.33% Reoffering Premium/Original Issue Discount 0.00% -33.33% Payment to Refund Loans Escrow Agent 0.00% -33.33% Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 3,327,727 3,327,727 147,075 3,180,652 4.42% -28.91% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 2,390,548 2,390,548 843,079 (1,547,469) 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, 10/31/20 13,135,732 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 897,693 Total Fund Balance $ 14,033,425
41
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 57,965 57,965 6,938 (51,027) 11.97% -21.36% Investment Income (Loss) 12 12 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 57,965 57,965 6,950 (51,015) 11.99% -21.34% Expenditures: Tax Increment Financing 1,645 1,645 1,645 0.00% -33.33% Debt Service Principal 10,000 10,000 10,000 0.00% -33.33% Interest and Fiscal Agent Fees 45,530 45,530 45,530 0.00% -33.33% Debt Issuance Costs 0.00% -33.33% Total Expenditures 57,175 57,175 57,175 0.00% -33.33% Other Financing Uses: Issuance of Debt 0.00% -33.33% Reoffering Premium/Original Issue Discount 0.00% -33.33% Payment to Refund Loans Escrow Agent 0.00% -33.33% Transfers Out 0.00% -33.33% 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 57,175 57,175 57,175 0.00% -33.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 790 790 6,950 6,160 Unassigned Fund Balance at Beginning of Year 31,934 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 10/31/20 38,884 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 38,884
Independence TIF
the Period Ended October 31, 2020 42
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule North
For
CITY
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 2,179 2,179 235 (1,944) 10.78% -22.55% Investment Income (Loss) 239 239 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 2,179 2,179 474 (1,705) 21.75% -11.58% Other Financing Sources: Transfers In 0.00% -33.33% Capital lease proceeds 0.00% Total Other Financing Sources 0.00% -33.33% Total Revenues and Other Financing Sources 2,179 2,179 474 (1,705) 21.75% -11.58% Expenditures: Tax Increment Financing 63 63 63 0.00% -33.33% Debt Service Principal 0.00% -33.33% Interest and Fiscal Agent Fees 0.00% -33.33% Debt Issuance Costs 0.00% -33.33% Total Expenditures 63 63 63 0.00% -33.33% Other Financing Uses: Issuance of Debt 0.00% -33.33% Reoffering Premium/Original Issue Discount 0.00% -33.33% Payment to Refund Loans Escrow Agent 0.00% -33.33% Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 63 63 63 0.00% -33.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 2,116 2,116 474 (1,642) 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, 10/31/20 47,862 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 47,862
OF
Budgetary Comparison Schedule Mt Washington TIF For the Period Ended October 31, 2020 43
INDEPENDENCE, MISSOURI
For the Period Ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 1,589,201 1,589,201 245,405 (1,343,796) 15.44% -17.89% Investment Income (Loss) 28,653 28,653 0.00% -33.33% Other Revenue 1,208,000 1,208,000 315,772 (892,228) 26.14% -7.19% Total Revenues 2,797,201 2,797,201 589,830 (2,207,371) 21.09% -12.24% Other Financing Sources: Transfers In 315,000 315,000 (315,000) 0.00% -33.33% Total Other Financing Sources 315,000 315,000 (315,000) 0.00% -33.33% Total Revenues and Other Financing Sources 3,112,201 3,112,201 589,830 (2,522,371) 18.95% -14.38% Expenditures: Tax Increment Financing 48,817 48,817 9,272 39,545 18.99% -14.34% Debt Service Principal 50,000 50,000 50,000 0.00% -33.33% Interest and Fiscal Agent Fees 3,779,920 3,779,920 1,888,786 1,891,134 49.97% 16.64% Debt Issuance Costs 0.00% -33.33% Total Expenditures 3,878,737 3,878,737 1,898,058 1,980,679 48.93% 15.60% Other Financing Uses: Issuance of Debt 0.00% -33.33% Reoffering Premium/Original Issue Discount 0.00% -33.33% Payment to Refund Loans Escrow Agent 0.00% -33.33% Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 3,878,737 3,878,737 1,898,058 1,980,679 48.93% 15.60% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (766,536) (766,536) (1,308,228) (541,692) 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, 10/31/20 4,581,308 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,119,456
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Crackerneck Creek TIF
44
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 496,239 496,239 22,657 (473,582) 4.57% -28.76% Investment Income (Loss) 2,427 2,427 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 496,239 496,239 25,084 (471,155) 5.05% -28.28% Expenditures: Tax Increment Financing 9,590 9,590 9,590 0.00% -33.33% Debt Service 486,349 Principal 486,349 486,349 0.00% -33.33% Interest and Fiscal Agent Fees 0.00% -33.33% Debt Issuance Costs 0.00% -33.33% Total Expenditures 495,939 495,939 495,939 0.00% -33.33% Other Financing Uses: Issuance of Debt 0.00% -33.33% Reoffering Premium/Original Issue Discount 0.00% -33.33% Payment to Refund Loans Escrow Agent 0.00% -33.33% Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 495,939 495,939 495,939 0.00% -33.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 300 300 25,084 24,784 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, 10/31/20 29,026 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 29,026
Landfill
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Old
TIF
45
For the Period Ended October 31, 2020
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Trinity TIF
For the Period Ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 489,107 489,107 41,413 (447,694) 8.47% -24.86% Investment Income (Loss) 11 11 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 489,107 489,107 41,424 (447,683) 8.47% -24.86% Other Financing Sources: Transfers In 32,466 32,466 (32,466) 0.00% -33.33% Total Other Financing Sources 32,466 32,466 (32,466) 0.00% -33.33% Total Revenues and Other Financing Sources 521,573 521,573 41,424 (480,149) 7.94% -25.39% Expenditures: Tax Increment Financing 11,267 11,267 11,267 0.00% -33.33% Debt Service Principal 510,360 510,360 510,360 0.00% -33.33% Interest and Fiscal Agent Fees 0.00% -33.33% Debt Issuance Costs 0.00% -33.33% Total Expenditures 521,627 521,627 521,627 0.00% -33.33% Other Financing Uses: Issuance of Debt 0.00% -33.33% Reoffering Premium/Original Issue Discount 0.00% -33.33% Payment to Refund Loans Escrow Agent 0.00% -33.33% Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 521,627 521,627 521,627 0.00% -33.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (54) (54) 41,424 41,478 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, 10/31/20 (86,346) Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ (86,346)
46
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 3,589,345 3,589,345 12,529 (3,576,816) 0.35% -32.98% Investment Income (Loss) 6,265 6,265 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 3,589,345 3,589,345 18,794 (3,570,551) 0.52% -32.81% Other Financing Sources: Transfers In 9,183 9,183 (9,183) 0.00% -33.33% Total Other Financing Sources 9,183 9,183 (9,183) 0.00% -33.33% Total Revenues and Other Financing Sources 3,598,528 3,598,528 18,794 (3,579,734) 0.52% -32.81% Expenditures: Tax Increment Financing 550,170 550,170 1,250 548,920 0.23% -33.10% Debt Service Principal 1,950,000 1,950,000 1,950,000 0.00% -33.33% Interest and Fiscal Agent Fees 1,043,000 1,043,000 477,675 565,325 45.80% 12.47% Debt Issuance Costs 0.00% -33.33% Total Expenditures 3,543,170 3,543,170 478,925 3,064,245 13.52% -19.81% Other Financing Uses: Issuance of Debt 0.00% -33.33% Reoffering Premium/Original Issue Discount 0.00% -33.33% Payment to Refund Loans Escrow Agent 0.00% -33.33% Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 3,543,170 3,543,170 478,925 3,064,245 13.52% -19.81% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 55,358 55,358 (460,131) (515,489) 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, 10/31/20 792,690 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 3,354,870 Total Fund Balance $ 4,147,560
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule HCA TIF For the Period Ended October 31, 2020 47
CITY
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule
Cinema East TIF
For the Period Ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 257,861 257,861 35,006 (222,855) 13.58% -19.75% Investment Income (Loss) 6 6 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 257,861 257,861 35,012 (222,849) 13.58% -19.75% Expenditures: Tax Increment Financing 5,139 5,139 5,139 0.00% -33.33% Debt Service Principal 252,902 252,902 252,902 0.00% -33.33% Interest and Fiscal Agent Fees 44,000 (44,000) 0.00% -33.33% Debt Issuance Costs 0.00% -33.33% Total Expenditures 258,041 258,041 44,000 214,041 17.05% -16.28% Other Financing Uses: Issuance of Debt 0.00% -33.33% Reoffering Premium/Original Issue Discount 0.00% -33.33% Payment to Refund Loans Escrow Agent 0.00% -33.33% Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 258,041 258,041 44,000 214,041 17.05% -16.28% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (180) (180) (8,988) (8,808) 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, 10/31/20 27,124 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 27,124
48
CITY
OF
INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule
23rd & Noland Project 1 TIF
For the Period Ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 82,194 82,194 7,113 (75,081) 8.65% -24.68% Investment Income (Loss) 8 8 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 82,194 82,194 7,121 (75,073) 8.66% -24.67% Expenditures: Tax Increment Financing 2,063 2,063 2,063 0.00% -33.33% Debt Service Principal 80,131 80,131 80,131 0.00% -33.33% Interest and Fiscal Agent Fees 0.00% -33.33% Debt Issuance Costs 0.00% -33.33% Total Expenditures 82,194 82,194 82,194 0.00% -33.33% Other Financing Uses: Issuance of Debt 0.00% -33.33% Reoffering Premium/Original Issue Discount 0.00% -33.33% Payment to Refund Loans Escrow Agent 0.00% -33.33% Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 82,194 82,194 82,194 0.00% -33.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 7,121 7,121 Unassigned Fund Balance at Beginning of Year 26,963 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 10/31/20 34,084 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 34,084
49
CITY
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 11,729 11,729 105 (11,624) 0.90% -32.43% Investment Income (Loss) 6 6 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 11,729 11,729 111 (11,618) 0.95% -32.38% Expenditures: Tax Increment Financing 246 246 246 0.00% -33.33% Debt Service Principal 11,483 11,483 11,483 0.00% -33.33% Interest and Fiscal Agent Fees 0.00% -33.33% Debt Issuance Costs 0.00% -33.33% Total Expenditures 11,729 11,729 11,729 0.00% -33.33% Other Financing Uses: Issuance of Debt 0.00% -33.33% Reoffering Premium/Original Issue Discount 0.00% -33.33% Payment to Refund Loans Escrow Agent 0.00% -33.33% Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 11,729 11,729 11,729 0.00% -33.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 111 111 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, 10/31/20 2,452 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 2,452
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule 23rd & Noland Project 2 TIF For the Period Ended October 31, 2020 50
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
23rd & Noland Project 3 TIF
For the Period Ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 24,438 24,348 3,052 (21,296) 12.53% -20.80% Investment Income (Loss) 4 4 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 24,438 24,348 3,056 (21,292) 12.55% -20.78% Expenditures: Tax Increment Financing 24,438 24,438 24,438 0.00% -33.33% Debt Service Principal 0.00% -33.33% Interest and Fiscal Agent Fees 0.00% -33.33% Debt Issuance Costs 0.00% -33.33% Total Expenditures 24,438 24,438 24,438 0.00% -33.33% Other Financing Uses: Issuance of Debt 0.00% -33.33% Reoffering Premium/Original Issue Discount 0.00% -33.33% Payment to Refund Loans Escrow Agent 0.00% -33.33% Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 24,438 24,438 24,438 0.00% -33.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (90) 3,056 3,146 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, 10/31/20 10,444 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 10,444
51
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
23rd & Noland Project 4 TIF
For the Period Ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 462,503 462,503 118,123 (344,380) 25.54% -7.79% Investment Income (Loss) 41 41 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 462,503 462,503 118,164 (344,339) 25.55% -7.78% Expenditures: Tax Increment Financing 462,503 462,503 462,503 0.00% -33.33% Debt Service Principal 0.00% -33.33% Interest and Fiscal Agent Fees 0.00% -33.33% Debt Issuance Costs 0.00% -33.33% Total Expenditures 462,503 462,503 462,503 0.00% -33.33% Other Financing Uses: Issuance of Debt 0.00% -33.33% Reoffering Premium/Original Issue Discount 0.00% -33.33% Payment to Refund Loans Escrow Agent 0.00% -33.33% Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 462,503 462,503 462,503 0.00% -33.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 118,164 118,164 Unassigned Fund Balance at Beginning of Year 91,417 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Unassigned Ending Fund Balance, 10/31/20 209,581 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 209,581
52
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison
Schedule
Independence Square TIF
For the Period Ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 145,470 145,470 53,809 (91,661) 36.99% 3.66% Investment Income (Loss) 2,873 2,873 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 145,470 145,470 56,682 (88,788) 38.96% 5.63% Expenditures: Tax Increment Financing 7,799 7,799 7,799 0.00% -33.33% Debt Service Principal 0.00% -33.33% Interest and Fiscal Agent Fees 0.00% -33.33% Debt Issuance Costs 0.00% -33.33% Total Expenditures 7,799 7,799 7,799 0.00% -33.33% Other Financing Uses: Issuance of Debt 0.00% -33.33% Reoffering Premium/Original Issue Discount 0.00% -33.33% Payment to Refund Loans Escrow Agent 0.00% -33.33% Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 7,799 7,799 7,799 0.00% -33.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 137,671 137,671 56,682 (80,989) Unassigned Fund Balance at Beginning of Year 557,714 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Unassigned Ending Fund Balance, 10/31/20 614,396 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 614,396
53
CITY OF
INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule
I-70 & Little Blue Parkway Project 1 TIF
For the Period Ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 1,152,029 1,152,029 345,588 (806,441) 30.00% -3.33% Investment Income (Loss) 154 154 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 1,152,029 1,152,029 345,742 (806,287) 30.01% -3.32% Expenditures: Tax Increment Financing 23,927 23,927 23,927 0.00% -33.33% Debt Service Principal 1,128,102 1,128,102 1,128,102 0.00% -33.33% Interest and Fiscal Agent Fees 0.00% -33.33% Debt Issuance Costs 0.00% -33.33% Total Expenditures 1,152,029 1,152,029 1,152,029 0.00% -33.33% Other Financing Uses: Issuance of Debt 0.00% -33.33% Reoffering Premium/Original Issue Discount 0.00% -33.33% Payment to Refund Loans Escrow Agent 0.00% -33.33% Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 1,152,029 1,152,029 1,152,029 0.00% -33.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 345,742 345,742 Unassigned Fund Balance at Beginning of Year 368,732 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Unassigned Ending Fund Balance, 10/31/20 714,474 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 714,474
54
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
I-70 & Little Blue Parkway Project 3 TIF For the Period Ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 382,156 382,156 69,522 (312,634) 18.19% -15.14% Investment Income (Loss) 2,900 2,900 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 382,156 382,156 72,422 (309,734) 18.95% -14.38% Expenditures: Tax Increment Financing 0.00% -33.33% Debt Service Principal 382,156 382,156 382,156 0.00% -33.33% Interest and Fiscal Agent Fees 0.00% -33.33% Debt Issuance Costs 0.00% -33.33% Total Expenditures 382,156 382,156 382,156 0.00% -33.33% Other Financing Uses: Issuance of Debt 0.00% -33.33% Reoffering Premium/Original Issue Discount 0.00% -33.33% Payment to Refund Loans Escrow Agent 0.00% -33.33% Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 382,156 382,156 382,156 0.00% -33.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 72,422 72,422 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, 10/31/20 142,251 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 142,251
55
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Marketplace Project 1 TIF
For the Period Ended October 31, 2020
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 97,731 97,731 25,744 (71,987) 26.34% -6.99% Investment Income (Loss) 16 16 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 97,731 97,731 25,760 (71,971) 26.36% -6.97% Expenditures: Tax Increment Financing 3,949 3,949 3,949 0.00% -33.33% Debt Service Principal 93,782 93,782 93,782 0.00% -33.33% Interest and Fiscal Agent Fees 0.00% -33.33% Debt Issuance Costs 0.00% -33.33% Total Expenditures 97,731 97,731 97,731 0.00% -33.33% Other Financing Uses: Issuance of Debt 0.00% -33.33% Reoffering Premium/Original Issue Discount 0.00% -33.33% Payment to Refund Loans Escrow Agent 0.00% -33.33% Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 97,731 97,731 97,731 0.00% -33.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 25,760 25,760 Unassigned Fund Balance at Beginning of Year 30,595 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 10/31/20 56,355 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 56,355
56
CITY
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 35,447 35,447 20,564 (14,883) 58.01% 24.68% Investment Income (Loss) 13 13 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 35,447 35,447 20,577 (14,870) 58.05% 24.72% Expenditures: Tax Increment Financing 35,447 35,447 370 35,077 1.04% -32.29% Debt Service Principal 0.00% -33.33% Interest and Fiscal Agent Fees 0.00% -33.33% Debt Issuance Costs 0.00% -33.33% Total Expenditures 35,447 35,447 370 35,077 1.04% -32.29% Other Financing Uses: Issuance of Debt 0.00% -33.33% Reoffering Premium/Original Issue Discount 0.00% -33.33% Payment to Refund Loans Escrow Agent 0.00% -33.33% Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 35,447 35,447 370 35,077 1.04% -32.29% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 20,207 20,207 Unassigned Fund Balance at Beginning of Year 38,027 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 10/31/20 58,234 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 58,234
Schedule Marketplace Project 2 TIF For the Period Ended October 31, 2020 57
OF INDEPENDENCE, MISSOURI Budgetary Comparison
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 33.33% of Year Budget Revenues: Taxes $ 0.00% -33.33% Investment Income (Loss) 0.00% -33.33% Other Revenue 0.00% -33.33% Total Revenues 0.00% -33.33% Expenditures: Tax Increment Financing 300 (300) 0.00% -33.33% Debt Service Principal 0.00% -33.33% Interest and Fiscal Agent Fees 0.00% -33.33% Debt Issuance Costs 0.00% -33.33% Total Expenditures 300 (300) 0.00% -33.33% Other Financing Uses: Issuance of Debt 0.00% -33.33% Reoffering Premium/Original Issue Discount 0.00% -33.33% Payment to Refund Loans Escrow Agent 0.00% -33.33% Transfers Out 0.00% -33.33% Total Other Financing Uses 0.00% -33.33% Total Expenditures and Other Financing Uses 300 (300) 0.00% -33.33% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (300) (300) Unassigned Fund Balance at Beginning of Year (24,172) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 10/31/20 (24,472) Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ (24,472)
Comparison Schedule TIF Application Fees For the Period Ended October 31, 2020 58
CITY OF INDEPENDENCE, MISSOURI Budgetary