MEMO
Date: October 2021
To: Audit Finance Committee
From: Finance
SEPTEMBE CITY‐WIDE TAX REVENUE
Real Estate Tax
The city collects property tax in the General Fund and the Health, Parks and Recreation Funds. The city receives property taxes in November and therefore the City has no property tax in September.
Sales Tax
As shown with the red dot on the Sales Tax revenue graph below, September sales tax collections are in line with last year’ collections.
SALES TAX REVENUE ‐ GENERAL FUND 002
500,000.00 1,000,000.00 1,500,000.00 2,000,000.00 2,500,000.00
2019-20 2020-21 2021-22 15,000,000 16,000,000 17,533,711 17,745,438 18,295,167 5,084,066 0 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 12,000,000 14,000,000 16,000,000 18,000,000 20,000,000 2016-17 2017-18 2018-19 2019-20 2020-21 2021-22 Annual Sales Tax Revenue General Fund 002 September 30, 2021
Use Tax
The cap for Animal Shelter (Fund 010) is $750,000 per year.
The cap for Police Use Tax (Fund 018) is $3 million.
The funds received after the caps have been met are then prorated based on the sales tax rate for each of the funds receiving sales tax. Distribution for the amount is as follows:
Use Tax Monthly for 2021‐2022
Use Tax Annual Comprison For Years Ending 2020-2022
Fund Sept 21 Collections Year to Date Collections Animal Services Use $ 263,056 $ 738,742 Police Use $ 263,056 $ 738,742 General $ - $Street Sales $ - $Parks Sales $ - $Stormwater Sales $ - $Police Sales $ - $Fire Sales $ - $$ 526,112 $ 1,477,484 217,198 258,488 263,056 - - - - - - -217,198 258,488 263,056 -100,000 200,000 300,000 400,000 500,000 600,000 Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
010 Animal 018 Police 0 100000 200000 300000 400000 500000 600000
2020 2021 2022
TRANSIENT GUEST TAX
The City receives taxes from the gross daily rent due from or paid by transient guests of all hotels and motels, bed and breakfast inns and campgrounds. Each operator will, on or before the twentieth day of the month following the close of each month, make a return of taxes collected for transient occupancy.
Use of funds are used for Historic site maintenance and Tourism sales and services.
The September collections are trending higher than collections for September in 2019 and 2020.
Guest Tax By Month
Fiscal Years 2019, 2020 2021 & YTD 2022
Gurest Tax Annual ReceiptsFiscal Years 2016- YTD2022
FUND BALANCE
The City’s policy for minimum fund balances are:
o General Fund – 16% of annual operating revenues.
o Special Revenue Funds designated for capital purposes – 5% of annual operating revenues
o Special Revenue Funds supporting personnel and ongoing operations – 16% of annual operating revenues
The following page show the fund balance calculation for September 30.
o The General Fund, Street Sales Tax ,Health Property Tax Fund, Parks and Rec Property Tax and Power and Light fund are below their targets.
o City Policy is that a plan needs to be developed to replenish the fund balance to target within five-years.
Some funds show surplus over the target. These surpluses need to be balanced with capital spending plans showing the use of those surpluses.
The page after includes the adopted six-year CIP showing capital expenditures for each fund
$0 $50,000 $100,000 $150,000 $200,000 $250,000
2019-2020 2020-2021 2021-2022 1,9 63,550 1,9 91,864 1,938,962 1,967,003 1,554,582 1,321,757 571,686 $0 $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 2016 2017 2018 2019 2020 2021 2022
CITY OF INDEPENDENCE, MISSOURI Reserve Balance per Policy
For the period ended September 30, 2021
Fund Sept 30, Balance Policy Basis of Calculation Actual % 5% Policy 16% Policy Over (Under) General 6,439,922 16% of operating expenditures 78,017,743 8% - 12,482,839 $ (6,042,917) Street Sales Tax (10,361) Between 5% and 16% of Revenues 9,035,391 0% - 1,445,663 (1,456,024) Park Improvement 2,606,680 Between 5% and 16% of Revenues 5,037,657 52% - 806,025 1,800,655 Storm Water 8,604,840 Between 5% and 16% of Revenues 4,637,032 186% - 741,925 7,862,915 Police Public Safety Sales Tax 1,637,697 5% of Annual Revenues 2,459,201 67% 122,960 - 1,514,737 Fire Protection Sales Tax 1,013,677 Between 5% and 16% of Revenues 2,271,486 45% - 363,438 650,239 Animal Shelter Use 748,568 Between 5% and 16% of Revenues 762,750 98% - 122,040 626,528 Police Use 4,056,214 Between 5% and 16% of Revenues 3,039,000 133% - 486,240.00 3,569,974 Health Property Tax 7,849 Between 5% and 16% of Revenues 1,386,432 1% - 221,829.12 (213,980) Parks and Rec Property Tax 20,403 Between 5% and 16% of Revenues 2,146,831 1% - 343,493 (323,090) Tourism 802,137 Between 5% and 16% of Revenues 1,683,926 48% - 269,428.16 532,709 Power and Light 51,645,834 Risk Based Calculation 67,000,000 - - - (15,354,166) Water 43,759,900 Risk Based Calculation 15,300,000 0% - - 28,459,900 Water Pollution Control 28,250,216 Risk Based Calculation 16,500,000 - - - 11,750,216
Capital Improvement Program 2022‐2027
Total 6‐year Fund 2022 2023 2024 2025 2026 2027 CIP General - - - - - -Street Sales 6,499,336 6,473,836 6,415,899 6,176,579 6,395,871 7,250,256 39,211,777 Park Improvement - - - - - -Storm Water 1,772,500 2,822,500 2,892,500 1,720,000 1,780,000 1,760,000 12,747,500 Police Public Safety Sales 2,573,508 1,834,663 1,898,917 550,000 - - 6,857,088 Fire Protection Sales Tax - - - - - -Animal Shelter Use - - - - - -Police Use Health Property Tax------Parks and Rec Property Tax - - - - - -Tourism 275,000 75,000 75,000 75,000 75,000 75,000 650,000 Power and Light 6,003,956 4,560,000 3,540,000 2,000,000 950,000 960,000 18,013,956 Water 6,420,000 7,200,000 3,025,000 9,600,000 9,325,000 1,275,000 36,845,000 Water Pollution Control 3,937,500 3,878,900 3,978,750 4,008,000 3,977,000 4,000,000 23,780,150 27,483,822 26,846,922 21,828,090 24,131,604 22,504,897 15,322,283 138,105,471
ITEMS OF NOTE for SEPTEMBER 2021
GENERAL FUND NOTES
The actual year-to-date General Fund revenues and other financing sources, through September 30th, compared to the amended budget are 27.04%, and actual expenditures and other financing uses are 24.97%. These percentages are in line with the cumulative total trend of 25.00% (September is month 3 and 3 divided by 12 = 25.00%). The attached summary reports reflect the September year-to-date actual revenues and expenditures compared to total budget.
There are a couple of revenue streams that are trending significantly below the 25.00%.
Franchise Taxes are at 18.49%.
Fines and Forfeitures are at 12.89%.
The American Rescue Plan (ARP) funds of $3,122,000 have been transferred to the General Fund for loss of revenue. Without the ARP funds the revenues and other financing sources would be at 22.87%.
There are a couple of departments where expenditures are trending slightly above the 25.00%.
Municipal Court is at 26.31% - this is due to encumbrances being entered at the start of the year that cover the entire fiscal year.
Fire is at 27.76% - this is mainly due to over-time and minimum staffing and encumbrances being entered at the start of the year that cover the entire fiscal year or multiple future months.
Law is at 31.34% - this is due to a purchase being entered in September that utilized 100% of its budget (land purchase).
UTILITY FUND NOTES Power and Light
The actual year-to-date Power and Light operating revenues, through September 30, 2021, compared to the amended budget are 31.14%. Operating expenditures are 26.77%. This percentage is compared to the cumulative total trend of 25.00% (September is month 3 and 3 divided by 12 = 25.00%). Total Transfers and Special Items are at 30.67% which includes Payments in Lieu of taxes for the month of September. The attached summary reports reflect the September 2021 year-to-date actual revenues and expenditures compared to total budget.
Water
The actual year-to-date Water operating revenues, through September 30, 2021, compared to the amended budget are 29.50%. Operating expenditures are 16.51%. This percentage is compared to the cumulative total trend of 25.00% (September is month 3 and 3 divided by 12 = 25.00%). Total Transfers are at 27.79% which includes Payments in Lieu of taxes for the month of September. The attached summary reports reflect the September 2021 year-to-date actual revenues and expenditures compared to total budget.
Sanitary Sewer
The actual year-to-date Sanitary Sewer operating revenues, through September 30, 2021, compared to the amended budget are 26.52%. Operating expenditures are 15.16%. This percentage is compared to the cumulative total trend of 25.00% (September is month 3 and 3 divided by 12 = 25.00%). Total Transfers are at 24.08% which includes Payments in Lieu of taxes for the month of September The attached summary reports reflect the September 2021 year-to-date actual revenues and expenditures compared to total budget.
Monthly Financial and Operating Report September 2021
Table of Contents General Fund 1 Sales Tax Funds Street Improvements Sales Tax Fund 2 Park Improvements Sales Tax Fund 3 Storm Water Sales Tax Fund 4 Police Public Safety Sales Tax Fund 5 Fire Protection Sales Tax Fund 6 Use Tax Funds Animal Shelter 7 Police 8 Property Tax Levy Funds Health Property Tax Levy 9 Parks and Recreation Property Tax Levy 10 Special Revenue Funds Tourism Fund 11 Independence Square Benefit District 12 Community Development Block Grant Fund 13 Rental Rehabilitation 14 License Surcharge 15 Grants 16 American Rescue Plan (ARP) 17 Enterprise Funds Power and Light 18 - 19 Water 20 - 21 Water Pollution Control 22 - 23 Events Center Debt Service 24 Internal Service Funds Central Garage 25 Staywell Health Care 26 Worker's Compensation 27 Risk Management 28 Enterprise Resource Planning 29 Debt Service Fund Debt Service - Neighborhood Improvement Districts 30 Capital Improvement Funds Street Improvements Capital Project Fund 31 Revolving Public Improvements Capital Project Fund 32 Building and Other Improvements Capital Project Fund 33 Storm Drainage Capital Project Fund 34 Park Improvements Capital Project Fund 35 Private Purpose Expendable Trust Fund - Vaile Mansion 36 Independence Events Center CID 37 Crackerneck Creek TDD 38 Tax Increment Financing Summary 39 Mid-Town Truman Rd TIF 40 Santa Fe TIF 41 Hartman Heritage TIF 42 Drumm Farm TIF 43 Eastland TIF 44 North Independence TIF 45 Mt Washington TIF 46 Crackerneck Creek TIF 47 Old Landfill TIF 48 Trinity TIF 49 HCA TIF 50 Cinema East TIF 51 23rd & Noland Project 1 TIF 52 23rd & Noland Project 2 TIF 53 23rd & Noland Project 3 TIF 54 23th & Noland Project 4 TIF 55 Independence Square TIF 56 I-70 & Little Blue Parkway Project 1 TIF 57 I-70 & Little Blue Parkway Project 3 TIF 58 Marketplace Project 1 TIF 59 Marketplace Project 2 TIF 60 TIF Application Fees 61 TIF Economic Development Sinking Fund 62
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule General Fund
For the period ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Real Estate Tax $ 5,732,000 5,732,000 (5,549) (5,737,549) -0.10% -25.10% Sales Tax 18,617,431 18,617,431 5,084,066 (13,533,365) 27.31% 2.31% Use Tax 448,000 448,000 (448,000) 0.00% -25.00% Cigarette Tax 420,000 420,000 101,338 (318,662) 24.13% -0.87% Franchise Tax 8,171,990 8,171,990 1,511,004 (6,660,986) 18.49% -6.51% Licenses and Permits 4,043,350 4,043,350 1,050,221 (2,993,129) 25.97% 0.97% Intergovernmental 5,330,000 5,330,000 1,271,778 (4,058,222) 23.86% -1.14% Charges for Current Services 1,915,000 1,915,000 461,461 (1,453,539) 24.10% -0.90% Interfund Charges for Support Services 5,035,500 5,035,500 1,258,875 (3,776,625) 25.00% 0.00% Fines and Forfeitures 3,710,000 3,710,000 478,120 (3,231,880) 12.89% -12.11% Investment Income (Loss) 194,000 194,000 49,690 (144,310) 25.61% 0.61% Other Revenue 541,894 541,894 110,844 (431,050) 20.45% -4.55% Total Revenues 54,159,165 54,159,165 11,371,848 (42,787,317) 21.00% -4.00% Other Financing Sources: Payments In Lieu of Taxes 20,696,578 20,696,578 5,750,441 (14,946,137) 27.78% 2.78% Operating Transfers In - American Rescue Plan 3,122,000 3,122,000 0.00% -25.00% Total Other Financing Sources 20,696,578 20,696,578 8,872,441 (11,824,137) 42.87% 17.87% Total Revenues and Other Financing Sources 74,855,743 74,855,743 20,244,289 (54,611,454) 27.04% 2.04% Expenditures: City Council 711,350 711,350 160,019 551,331 22.50% -2.50% City Clerk 325,744 325,744 46,080 279,664 14.15% -10.85% City Manager 1,185,232 1,185,232 221,608 963,624 18.70% -6.30% Municipal Court 1,264,139 1,264,139 332,647 931,492 26.31% 1.31% Law 611,371 771,371 241,725 529,646 31.34% 6.34% Finance 6,264,935 6,264,935 1,626,787 4,638,148 25.97% 0.97% Community Development 4,576,184 4,576,184 1,053,309 3,522,875 23.02% -1.98% Police 33,155,226 33,155,226 7,864,250 25,290,976 23.72% -1.28% Fire 23,852,022 23,852,022 6,620,248 17,231,774 27.76% 2.76% Health 2,972 (2,972) 0.00% -25.00% Municipal Services (Public Works) 5,995,281 5,829,918 1,330,710 4,499,208 22.83% -2.17% Parks and Recreation 165,363 13,795 151,568 8.34% -16.66% Contingencies 17,028 17,028 17,028 0.00% -25.00% Debt service 59,231 59,231 59,231 0.00% -25.00% Total Expenditures 78,017,743 78,177,743 19,514,150 58,663,593 24.96% -0.04% Other Financing Uses: Transfers Out 10,000 10,000 10,000 100.00% 75.00% Total Expenditures and Other Financing Uses 78,027,743 78,187,743 19,524,150 58,663,593 24.97% -0.03% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (3,172,000) (3,332,000) 720,139 4,052,139 Unassigned Fund Balance at Beginning of Year 5,708,549 Cancellation of prior year encumbrances 9,562 Change in other fund balance components during the year 1,672 Year-end investment market value adjustment Ending Unassigned Fund Balance, 09/30/21 6,439,922 Restricted 118,750 Committed 14,701 Assigned 1,820,687 Total Fund Balance $ 8,394,060
1
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Street
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Sales Taxes $ 8,770,391 8,770,391 2,413,497 (6,356,894) 27.52% 2.52% Use Tax 224,000 224,000 (224,000) 0.00% -25.00% Charges for Services 0.00% -25.00% Intergovernmental Revenue 0.00% -25.00% Investment Income (Loss) 41,000 41,000 28,946 (12,054) 70.60% 45.60% Other Revenue 0.00% -25.00% Total Revenues 9,035,391 9,035,391 2,442,443 (6,592,948) 27.03% 2.03% Other Financing Sources: Transfers in 0.00% -25.00% Total other financing sources 0.00% -25.00% Total revenues and other financing sources 9,035,391 9,035,391 2,442,443 (6,592,948) 27.03% 2.03% Expenditures: General Government 0.00% -25.00% Street Maintenance 1,166,177 1,166,177 576,532 589,645 49.44% 24.44% Capital Outlay 6,486,836 22,952,225 4,161,089 18,791,136 18.13% -6.87% Debt Service 474,576 474,576 474,576 0.00% -25.00% Total Expenditures 8,127,589 24,592,978 4,737,621 19,855,357 19.26% -5.74% Other Financing Uses: Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 8,127,589 24,592,978 4,737,621 19,855,357 19.26% -5.74% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 907,802 (15,557,587) (2,295,178) 13,262,409 Unassigned Fund Balance at Beginning of Year 1,876,392 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year 408,425 Year-end investment market value adjustment Ending Unassigned Fund Balance, 09/30/21 (10,361) Fund Balance Components: Restricted - Current Year Encumbrances 4,583,732 Restricted - Prior Year Encumbrances 2,853,171 Restricted - Debt Reserve Project Accounts - Capital Projects 13,431,167 Total Fund Balance $ 20,857,709
Improvements Sales Tax Fund
the period ended September 30, 2021 2
For
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Park Improvements Sales Tax Fund For the period ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Sales Taxes $ 4,385,212 4,385,212 1,206,750 (3,178,462) 27.52% 2.52% Use Tax 112,000 112,000 (112,000) 0.00% -25.00% Charges for services 519,752 519,752 158,306 (361,446) 30.46% 5.46% Intergovernmental 0.00% -25.00% Investment Income (Loss) 18,180 18,180 14,955 (3,225) 82.26% 57.26% Other Revenue 2,513 2,513 5,053 2,540 201.07% 176.07% Total Revenues 5,037,657 5,037,657 1,385,064 (3,652,593) 27.49% 2.49% Other Financing Sources: Transfers In 240,092 240,092 (240,092) 0.00% -25.00% Transfers In - American Rescue Plan 2,134,500 2,134,500 0.00% -25.00% Proceeds from Bond Issuance/Capital Lease 0.00% -25.00% Total Other Financing Sources 240,092 240,092 2,134,500 1,894,408 889.03% 864.03% Total Revenues and Other Financing Sources 5,277,749 5,277,749 3,519,564 (1,758,185) 66.69% 41.69% Expenditures: Culture and Recreation 4,373,935 4,373,935 1,478,326 2,895,609 33.80% 8.80% Capital Outlay 506,000 1,394,608 33,805 1,360,803 2.42% -22.58% Debt Service 207,215 207,215 207,215 0.00% -25.00% Total Expenditures 5,087,150 5,975,758 1,512,131 4,463,627 25.30% 0.30% Other Financing Uses: Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 5,087,150 5,975,758 1,512,131 4,463,627 25.30% 0.30% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 190,599 (698,009) 2,007,433 2,705,442 Unassigned Fund Balance at Beginning of Year 599,247 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 09/30/21 2,606,680 Other Fund Balance Components: Restricted - Current Year Encumbrances 424,880 Restricted - Prior Year Encumbrances 75,344 Total Fund Balance $ 3,106,904
3
CITY OF INDEPENDENCE, MISSOURI Budgetary
Storm
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Sales Taxes $ 4,385,212 4,385,212 1,206,750 (3,178,462) 27.52% 2.52% Use Tax 112,000 112,000 (112,000) -25.00% Investment Income (loss) 132,000 132,000 62,910 (69,090) 47.66% 22.66% Other Revenue 7,820 7,820 7,863 43 100.55% 75.55% Total revenues 4,637,032 4,637,032 1,277,523 (3,359,509) 27.55% 2.55% Expenditures: Storm water Administration 272,856 272,856 105,528 167,328 38.68% 13.68% Maintenance 2,381,657 2,381,657 1,084,793 1,296,864 45.55% 20.55% Permit completion 318,000 318,000 318,000 0.00% -25.00% Capital outlay 1,760,000 4,999,175 958,869 4,040,306 19.18% -5.82% Total Expenditures 4,732,513 7,971,688 2,149,190 5,822,498 26.96% 1.96% Total Ependitures and Other Financing Uses 4,732,513 7,971,688 2,149,190 5,822,498 Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (95,481) (3,334,656) (871,667) 2,462,989 Unassigned Fund Balance at Beginning of Year 9,476,507 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 09/30/21 8,604,840 Other Fund Balance Components: Restricted - Current Year Encumbrances 1,619,063 Restricted - Prior Year Encumbrances 623,270 Restricted - Regional Detention Construction 18,759 Restricted - Regional Detention Maintenance 40,311 Restricted - Emergency Response Relief 500,000 Total Fund Balance $ 11,406,243
Comparison Schedule
Water Sales Tax Fund
4
For the period ended September 30, 2021
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Police Public Safety Sales Tax Fund
For the period ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Sales Taxes $ 2,358,694 2,358,694 641,734 (1,716,960) 27.21% 2.21% Use Tax 56,000 56,000 (56,000) 0.00% -25.00% Investment Income (Loss) 37,000 37,000 13,442 (23,558) 36.33% 11.33% Other Revenue 7,507 7,507 9,848 2,341 131.18% 106.18% Total Revenues 2,459,201 2,459,201 665,024 (1,794,177) 27.04% 2.04% Expenditures: Public Safety Communications 675,922 675,922 438,977 236,945 64.94% 39.94% Facilities 104,500 104,500 50,042 54,458 47.89% 22.89% Equipment 1,924,697 1,924,697 815,781 1,108,916 42.38% 17.38% Debt Service 0.00% -25.00% Total Expenditures 2,705,119 2,705,119 1,304,800 1,400,319 48.23% 23.23% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 2,705,119 2,705,119 1,304,800 1,400,319 48.23% 23.23% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (245,918) (245,918) (639,776) (393,858) Unassigned Fund Balance at Beginning of Year 2,277,473 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 09/30/21 1,637,697 Other Fund Balance Components: Restricted - Current Year Encumbrances 966,500 Restricted - Prior Year Encumbrances 75,768 Total Fund Balance $ 2,679,965
5
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Fire Protection Sales Tax Fund For the period ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Sales Taxes $ 2,192,486 2,192,486 603,376 (1,589,110) 27.52% 2.52% Use Tax 56,000 56,000 (56,000) 0.00% -25.00% Investment Income (Loss) 17,000 17,000 10,867 (6,133) 63.92% 38.92% Other Revenue 6,000 6,000 (6,000) 0.00% -25.00% Total Revenues 2,271,486 2,271,486 614,243 (1,657,243) 27.04% 2.04% Expenditures: Public Safety 2,763,693 2,763,693 281,764 2,481,929 10.20% -14.80% Debt Service 73,236 73,236 73,236 0.00% -25.00% Total Expenditures 2,836,929 2,836,929 281,764 2,555,165 9.93% -15.07% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 2,836,929 2,836,929 281,764 2,555,165 9.93% -15.07% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (565,443) (565,443) 332,479 897,922 Unassigned Fund Balance at Beginning of Year 678,965 Cancellation of Prior Year Encumbrances 2,233 Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 09/30/21 1,013,677 Other Fund Balance Components: Restricted - Current Year Encumbrances 116,935 Restricted - Prior Year Encumbrances 1,429,761 Total Fund Balance $ 2,560,373
6
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Use Tax $ 762,750 762,750 738,742 (24,008) 96.85% 71.85% Intergovernmental Revenue 0.00% -25.00% Investment Income (Loss) 1,043 1,043 0.00% -25.00% Other Revenue 0.00% -25.00% Total Revenues 762,750 762,750 739,785 (22,965) 96.99% 71.99% Expenditures: General Government -25.00% Animal Services 728,545 728,545 144,340 584,205 19.81% -5.19% Capital Outlay 0.00% -25.00% Debt Service 0.00% -25.00% Total Expenditures 728,545 728,545 144,340 584,205 19.81% -5.19% Other Financing Uses: Transfers In 0.00% -25.00% Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 728,545 728,545 144,340 584,205 19.81% -5.19% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 34,205 34,205 595,445 561,240 Unassigned Fund Balance at Beginning of Year 153,123 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 09/30/21 748,568 Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances 1,437 Total Fund Balance $ 750,005
Schedule Animal Shelter Use Tax For the period ended September 30, 2021 7
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Police Use Tax
For the period ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Use Tax $ 3,032,000 3,032,000 738,742 (2,293,258) 24.36% -0.64% Investment Income (Loss) 7,000 7,000 22,550 15,550 322.14% 297.14% Other Revenue 0.00% -25.00% Total Revenues 3,039,000 3,039,000 761,292 (2,277,708) 25.05% 0.05% Expenditures: Public Safety 2,258,155 2,258,155 251,570 2,006,585 11.14% -13.86% Debt Service 0.00% -25.00% Total Expenditures 2,258,155 2,258,155 251,570 2,006,585 11.14% -13.86% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 2,258,155 2,258,155 251,570 2,006,585 11.14% -13.86% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 780,845 780,845 509,722 (271,123) Unassigned Fund Balance at Beginning of Year 3,546,492 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 09/30/21 4,056,214 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 4,056,214
8
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule Health Property Tax Levy For the period ended September 30, 2021 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 870,000 870,000 (424) (870,424) -0.05% -25.05% Charges for Services 150,000 150,000 24,669 (125,331) 16.45% -8.55% Licenses & Permits 366,432 366,432 (366,432) 0.00% -25.00% Investment Income (Loss) 1,141 1,141 0.00% -25.00% Other Revenue 1,262 1,262 0.00% -25.00% Total Revenues 1,386,432 1,386,432 26,648 (1,359,784) 1.92% -23.08% Other Financing Sources: Transfers In - American Rescue Plan 300,000 300,000 0.00% -25.00% Total Other Financing Uses 300,000 300,000 0.00% -25.00% Total Revenues and Other Sources 1,386,432 1,386,432 326,648 (1,059,784) 23.56% -1.44% Expenditures: Animal Services 884,518 884,518 214,144 670,374 24.21% -0.79% Health Services 778,674 778,674 157,496 621,178 20.23% -4.77% Total Expenditures 1,663,192 1,663,192 371,640 1,291,552 22.34% -2.66% Other Financing Uses: Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Uses 1,663,192 1,663,192 371,640 1,291,552 22.34% -2.66% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (276,760) (276,760) (44,992) 231,768 Unassigned Fund Balance at Beginning of Year 52,841 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 09/30/21 7,849 Other Fund Balance Components: Restricted - Current Year Encumbrances 25,735 Restricted - Prior Year Encumbrances 2,947 Total Fund Balance $ 36,531
9
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule Parks and Recreation Property Tax Levy For the period ended September 30, 2021 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 1,850,000 1,850,000 (901) (1,850,901) -0.05% -25.05% Intergovernmental 65,985 65,985 12,435 (53,550) 18.85% -6.15% Charges for Services 230,746 230,746 45,190 (185,556) 19.58% -5.42% Investment Income (Loss) 100 100 4,490 4,390 4490.00% 4465.00% Other Revenue 1,038 1,038 0.00% -25.00% Total Revenues 2,146,831 2,146,831 62,252 (2,084,579) 2.90% -22.10% Expenditures: Parks and Recreation 2,099,104 2,099,104 452,437 1,646,667 21.55% -3.45% Total Expenditures 2,099,104 2,099,104 452,437 1,646,667 21.55% -3.45% Other Financing Uses – Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Uses 2,099,104 2,099,104 452,437 1,646,667 21.55% -3.45% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 47,727 47,727 (390,185) (437,912) Unassigned Fund Balance at Beginning of Year 410,588 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 09/30/21 20,403 Other Fund Balance Components: Restricted - Current Year Encumbrances 21,126 Restricted - Prior Year Encumbrances 6,156 Total Fund Balance $ 47,685 10
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule Tourism Fund For the period ended September 30, 2021 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Transient Guest Taxes $ 1,652,283 1,652,283 571,686 (1,080,597) 34.60% 9.60% Charges for Services 2,148 2,148 0.00% -25.00% Investment Income (Loss) 26,593 26,593 8,174 (18,419) 30.74% 5.74% Other Revenue 5,050 5,050 2,463 (2,587) 48.77% 23.77% Total Revenues 1,683,926 1,683,926 584,471 (1,099,455) 34.71% 9.71% Other Financing Sources: Transfers In - American Resuce Plan 150,000 150,000 0.00% -25.00% Total Other Financing Uses 150,000 150,000 0.00% -25.00% Total Revenues and Other Sources 1,683,926 1,683,926 734,471 (949,455) 43.62% 18.62% Expenditures: Tourism 2,550,789 2,617,529 795,933 1,821,596 30.41% 5.41% Total Expenditures 2,550,789 2,617,529 795,933 1,821,596 30.41% 5.41% Other Financing Uses – Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Uses 2,550,789 2,617,529 795,933 1,821,596 30.41% 5.41% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (866,863) (933,603) (61,462) 872,141 Unassigned Fund Balance at Beginning of Year 863,599 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 09/30/21 802,137 Other Fund Balance Components: Restricted - Current Year Encumbrances 444,085 Restricted - Prior Year Encumbrances 35,258 Restricted - Operating Reserve 376,368 Total Fund Balance $ 1,657,848
11
Comparison Schedule Independence Square Benefit District For the period ended September 30, 2021 Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 0.00% -25.00% Investment Income (Loss) 0.00% -25.00% Other Revenue 0.00% -25.00% Total Revenues 0.00% -25.00% Expenditures: Capital Outlay 0.00% -25.00% Total Expenditures 0.00% -25.00% Other Financing Uses – Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Uses 0.00% -25.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ Unassigned Fund Balance at Beginning of Year 7,663 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 09/30/21 7,663 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 7,663 12
CITY OF INDEPENDENCE, MISSOURI Budgetary
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Federal Grant - CDBG $ 1,605,692 1,605,692 185,718 (1,419,974) 11.57% -13.43% Other Revenue -25.00% Total Revenues 1,605,692 1,605,692 185,718 (1,419,974) 11.57% -13.43% Expenditures: CDBG Administration 166,173 166,173 18,733 147,440 11.27% -13.73% CDBG Expenditures 1,455,527 1,455,527 765,539 689,988 52.60% 27.60% Total Expenditures 1,621,700 1,621,700 784,272 837,428 48.36% 23.36% Other Financing Uses: Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Uses 1,621,700 1,621,700 784,272 837,428 48.36% 23.36% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (16,008) (16,008) (598,554) (582,546) Unassigned Fund Balance at Beginning of Year (96,680) Cancellation of Prior Year Encumbrances 28,467 Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 09/30/21 (666,767) Other Fund Balance Components: Restricted - Current Year Encumbrances 616,378 Restricted - Prior Year Encumbrances 49,675 Total Fund Balance $ (714)
Development Block Grant Fund
the period ended September 30, 2021 13
Community
For
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Rental Rehabilitation
For the period ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: HOME Program Grant $ 482,477 482,477 28,964 (453,513) 6.00% -19.00% Total Revenues 482,477 482,477 28,964 (453,513) 6.00% -19.00% Expenditures: HOME Administration 63,607 63,607 15,644 47,963 24.59% -0.41% Multi Family Housing 359,759 359,759 359,759 0.00% -25.00% Community Housing Development 102,788 102,788 102,788 0.00% -25.00% Total Expenditures 526,154 526,154 15,644 510,510 2.97% -22.03% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (43,677) (43,677) 13,320 56,997 Unassigned Fund Balance at Beginning of Year (401,485) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 09/30/21 (388,165) Other Fund Balance Components: Restricted - Current Year Encumbrances 499 Restricted - Prior Year Encumbrances 387,671 Total Fund Balance $ 5
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 25.00% of Year Budget Revenues: Licenses and Permits $ (2,745) (2,745) 0.00% -25.00% Investment Income (Loss) 17,000 17,000 7,764 (9,236) 45.67% 20.67% Other Revenue 0.00% -25.00% Total Revenues 17,000 17,000 5,019 (11,981) 29.52% 4.52% Expenditures: General Government 0.00% -25.00% Total expenditures 0.00% -25.00% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 0.00% -25.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 17,000 17,000 5,019 (11,981) Unassigned Fund Balance at Beginning of Year 1,251,500 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-end investment market value adjustment Ending Unassigned Fund Balance, 09/30/21 1,256,519 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 1,256,519
Surcharge
period ended September 30, 2021 15
For the
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Grants
For the period ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Intergovernmental $ 1,343,409 3,819,593 260,769 (3,558,824) 6.83% -18.17% Charges for Services 105,103 105,103 57,098 (48,005) 54.33% 29.33% Other Revenue 63,885 77 (63,808) 0.12% -24.88% Total Revenues 1,448,512 3,988,581 317,944 (3,670,637) 7.97% -17.03% Other financing sources: Transfers In 0.00% -25.00% Total other financing sources 0.00% -25.00% Total revenues and other financing sources 1,448,512 3,988,581 317,944 (3,670,637) 7.97% -17.03% Expenditures: Public Safety 422,758 1,530,760 364,930 1,165,830 23.84% -1.16% General Government 138,063 247,282 5,663 241,619 2.29% -22.71% Culture and Recreation 18,750 33,990 (15,240) 181.28% 156.28% Community Development 500,000 1,356,103 2,299,078 (942,975) 169.54% 144.54% Animal Services 7,256 7,256 0.00% -25.00% Health Services 375,721 619,786 65,036 554,750 10.49% -14.51% Total Expenditures 1,436,542 3,779,937 2,768,697 1,011,240 73.25% 48.25% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 1,436,542 3,779,937 2,768,697 1,011,240 73.25% 48.25% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 11,970 208,644 (2,450,753) (2,659,397) Unassigned Fund Balance at Beginning of Year (338,049) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 09/30/21 (2,788,802) Other Fund Balance Components: Restricted - Current Year Encumbrances 2,167,769 Restricted - Prior Year Encumbrances 293,070 Total Fund Balance $ (327,963)
16
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule American Rescue Plan (ARP) For the period ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Intergovernmental $ 8,104,959 8,104,959 0.00% -25.00% Charges for Services 0.00% -25.00% Other Revenue 0.00% -25.00% Total Revenues 8,104,959 8,104,959 0.00% -25.00% Other financing sources: Transfers in 0.00% -25.00% Total other financing sources 0.00% -25.00% Total revenues and other financing sources 8,104,959 8,104,959 0.00% -25.00% Expenditures: CARES Act 234,649 (234,649) 0.00% -25.00% Total Expenditures 234,649 (234,649) 0.00% -25.00% Other Financing Uses: Transfers Out - American Rescue Plan 8,056,500 (8,056,500) 0.00% -25.00% Total Other Financing Uses 8,056,500 (8,056,500) 0.00% -25.00% Total Expenditures and Other Financing Uses 8,291,149 (8,291,149) 0.00% -25.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (186,190) (186,190) 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, 09/30/21 (186,190) Other Fund Balance Components: Restricted - Current Year Encumbrances 186,190 Restricted - Prior Year Encumbrances Total Fund Balance $
17
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Power and Light
For the period ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Operating Revenues: Charges for Services $ 130,609,070 130,609,070 42,765,178 (87,843,892) 32.74% 7.74% Penalties 1,106,786 1,106,786 350,233 (756,553) 31.64% 6.64% Connection Charges 280,151 280,151 7,200 (272,951) 2.57% -22.43% Miscellaneous 13,293 13,293 0.00% -25.00% Temporary Service 950 950 0.00% -25.00% Rental Income 340,239 340,239 10,237 (330,002) 3.01% -21.99% Transmission Wheeling 5,000,000 5,000,000 (377,000) (5,377,000) -7.54% -32.54% Total Operating Revenues 137,336,246 137,336,246 42,770,091 (94,566,155) 31.14% 6.14% Operating Expenses: Personnel Services 29,687,152 29,693,152 7,493,393 22,199,759 25.24% 0.24% Other Services 27,329,604 27,323,604 8,962,127 18,361,477 32.80% 7.80% Supplies 60,402,130 60,402,130 15,938,429 44,463,701 26.39% 1.39% Capital Projects 6,003,956 11,609,690 2,813,401 8,796,289 24.23% -0.77% Capital Operating 1,617,600 1,619,600 24,267 1,595,333 1.50% -23.50% Debt Service 9,992,712 9,992,712 2,497,390 7,495,322 24.99% -0.01% Other Expenses 275,000 275,000 275,000 0.00% -25.00% Total Operating Expenses 135,308,154 140,915,888 37,729,007 103,186,881 26.77% 1.77% Nonoperating Revenues (Expenses): Investment Income 202,902 202,902 43,359 (159,543) 21.37% -3.63% Interfund Charges for Support Services 1,828,147 1,828,147 439,231 (1,388,916) 24.03% -0.97% Miscellaneous Revenue (Expense) 715,639 715,639 260,150 (455,489) 36.35% 11.35% Total Nonoperating Revenue (Expenses) 2,746,688 2,746,688 742,740 (2,003,948) 27.04% 2.04% 4,774,780 (832,954) 5,783,824 6,616,778 -694.37% -719.37% Capital Contributions 0.00% -25.00% Transfers Out – Utility Payments In Lieu of Taxes (13,000,000) (13,000,000) (3,987,253) (9,012,747) 30.67% 5.67% Transfers In 0.00% -25.00% Transfers Out 0.00% -25.00% Total Transfers and Special Items (13,000,000) (13,000,000) (3,987,253) (9,012,747) 30.67% 5.67% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (8,225,220) (13,832,954) 1,796,571 15,629,525 Beginning Available Resources 49,849,263 Ending Available Resources 51,645,834 Revenue Risk 10,900,000 Capital Reserve 12,600,000 Expense Risk 12,900,000 Working Capital 30,600,000 Targeted Reserve Level 67,000,000 Total Non-Restricted Resources Available $ (15,354,166) Income (Loss) Before Transfers
18
Power and Light - Open Capital Projects
As of September 30, 2021
PROJECT PROJECT TITLE ORIGINAL BUDGET NET BUDGET AMENDMENTS REVISED BUDGET REQUISITIONS ENCUMBRANCES ACTUALS AVAILABLE BUDGET 200815 T&D Sys IMPROVEMENTS $ 250,000.00 641,486.08 891,486.08 - 308,364.46 - 583,121.62 200824 Prod Plt MISC PROJECTS - 68,257.76 68,257.76 - - - 68,257.76 200828 FIBER OPTIC PROGRAM 105,956.00 93,394.03 199,350.03 - 21,397.25 48,577.02 129,375.76 201106 69 KV SUBSTATION FACILITIES 300,000.00 138,222.55 438,222.55 - 1,435.00 - 436,787.55 201405 SUBSTATION SECURITY PROJECT - 259,644.39 259,644.39 - 7,692.00 16,802.75 235,149.64 201509 NEW BILLING Sys - 22,047.36 22,047.36 - - - 22,047.36 201510 Sys OpS / DISPATCH - 44,634.77 44,634.77 - 35,122.10 - 9,512.67 201603 69 KV Trans LINE REBUIL 800,000.00 1,348,663.48 2,148,663.48 - 2,086,198.13 5,777.80 56,687.55 201604 Sys OpS / UPS UPGRAD - 45,493.59 45,493.59 - - - 45,493.59 201605 Sys OpS WORK AREA - 619,842.18 619,842.18 - - - 619,842.18 201606 NEW FINANCIAL MANAGEMENT SYS - 200,000.00 200,000.00 - - - 200,000.00 201702 Prod FACILITIES IMPROVE - 586,830.00 586,830.00 500,000.00 - - 86,830.00 201703 BV GROUND WATER - 445,491.07 445,491.07 - 145,351.28 12,554.77 287,585.02 201706 SUBSTATION K SWITCHGEAR & - 4,006,011.31 4,006,011.31 - 3,897,176.45 16,920.35 91,914.51 201707 MASTER PLAN-FUTURE GENERATIO - 32,500.00 32,500.00 - - - 32,500.00 201710 Mo CITY DIVESTITURE - 530,640.70 530,640.70 - 516,102.12 14,538.08 0.50 201803 SERVICE CENTER TRUCK HOUSING - - - - 15,600.00 - (15,600.00) 201804 SUBSTATION E SWITCHGEAR REPLACEMENT 950,000.00 2,543,308.28 3,493,308.28 1,650,000.00 379,200.97 191,053.31 1,273,054.00 202004 Above Ground Fuel Storage Tanks - 41,800.00 41,800.00 - - - 41,800.00 202005 Blue Valley - Eckles Rd 161kV Trans - (41,604.90) (41,604.90) - - - (41,604.90) 202101 Substation Fiber Optic Network 750,000.00 125,000.00 875,000.00 - 35,221.33 - 839,778.67 202102 Traffic Controller Upgrades 60,000.00 (4,000.00) 56,000.00 - - - 56,000.00 202103 Traffic Camera System Upgrades 20,000.00 11,837.00 31,837.00 - - - 31,837.00 202107 Motorola APX Radio Purchase Phase 2 70,000.00 1,706.82 71,706.82 - - 3,989.93 67,716.89 202109 Substation Modeling 100,000.00 150,000.00 250,000.00 - - - 250,000.00 202110 20MVAR Capacitor Bank Sub A - 800,000.00 800,000.00 - 246,456.02 - 553,543.98 202111 Transmission Pole Replacement Prog 300,000.00 100,000.00 400,000.00 - 31,252.30 - 368,747.70 202201 Substation A Transformer T-9 Mtce 180,000.00 - 180,000.00 - - - 180,000.00 202204 Relay Test Set 80,000.00 - 80,000.00 - - - 80,000.00 202205 Desert Storm Switchgear Cabinets 250,000.00 - 250,000.00 - - - 250,000.00 202208 Traffic Signal Detection Systems 50,000.00 - 50,000.00 - - - 50,000.00 202210 IPL Service Center PBX Upgrade to I 70,000.00 - 70,000.00 - - - 70,000.00 202211 H-5 Hot Gas Path Inspection 1,518,000.00 - 1,518,000.00 - - - 1,518,000.00 9669 SERVICE CTR FACILITY IMPROVE. 150,000.00 220,084.17 370,084.17 - 7,174.50 - 362,909.67 $ 6,003,956.00 13,031,290.64 19,035,246.64 2,150,000.00 7,733,743.91 310,214.01 8,841,288.72 Current Year Prior Year Budget Budget (Enc Roll) Total Budget 11,609,689.70 $ 7,425,556.94 19,035,246.64 Less Expenditures 12,230.91 297,983.10 310,214.01 Less Encumbrances 2,801,170.07 7,082,573.84 9,883,743.91 Total Available 8,796,288.72 $ 45,000.00 8,841,288.72
19
CITY OF
INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule Water
For the period ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Operating Revenues: Charges for Services $ 32,720,000 32,720,000 9,620,883 (23,099,117) 29.40% 4.40% Penalties 120,000 120,000 58,446 (61,554) 48.71% 23.71% Connection/Disconnection Charges 12,000 12,000 6,830 (5,170) 56.92% 31.92% Miscellaneous 1,000 1,000 2,890 1,890 289.00% 264.00% Returned Check Charges 23,000 23,000 7,335 (15,665) 31.89% 6.89% Rental Income 85,000 85,000 21,623 (63,377) 25.44% 0.44% Meter Repairs 0.00% -25.00% Merchandising Jobbing 5,217 5,217 0.00% -25.00% Total Operating Revenues 32,961,000 32,961,000 9,723,224 (23,237,776) 29.50% 4.50% Operating expenses: Personnel Services 9,507,888 9,507,888 2,104,656 7,403,232 22.14% -2.86% Other Services 13,356,698 13,356,698 2,734,184 10,622,514 20.47% -4.53% Supplies 2,466,330 2,466,330 1,715,057 751,273 69.54% 44.54% Capital Projects 6,420,000 19,286,025 906,000 18,380,025 4.70% -20.30% Capital Operating 1,072,318 1,072,318 305,231 767,087 28.46% 3.46% Debt Service 2,523,363 2,523,363 215,684 2,307,679 8.55% -16.45% Other Expenses 125,000 125,000 125,000 0.00% -25.00% Total Operating Expenses 35,471,597 48,337,622 7,980,812 40,356,810 16.51% -8.49% Nonoperating Revenues (Expenses): Investment Income 539,138 539,138 230,924 (308,214) 42.83% 17.83% Interfund Charges for Support Services 1,392,092 1,392,092 348,023 (1,044,069) 25.00% 0.00% Miscellaneous Revenue (Expense) 1,000 1,000 14,387 13,387 1438.70% 1413.70% Total Nonoperating Revenue (Expenses) 1,932,230 1,932,230 593,334 (1,338,896) 30.71% 5.71% (578,367) (13,444,392) 2,335,746 15,780,138 -17.37% -42.37% Transfers Out – Utility Payments In Lieu of Taxes (3,200,000) (3,200,000) (889,358) (2,310,642) 27.79% 2.79% Transfers In 0.00% -25.00% Transfers Out 0.00% -25.00% Total Transfers (3,200,000) (3,200,000) (889,358) (2,310,642) 27.79% 2.79% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (3,778,367) (16,644,392) 1,446,388 18,090,780 Beginning Available Resources 42,313,512 Ending Available Resources 43,759,900 Revenue Risk 3,800,000 Capital Reserve 4,300,000 Expense Risk 400,000 Working Capital 6,800,000 Targeted Reserve Level 15,300,000 Total Non-Restricted Resources Available $ 28,459,900 Income (Loss) Before Transfers
20
Water - Open Capital Projects
As of September 30, 2021
PROJECT PROJECT TITLE ORIGINAL BUDGET NET BUDGET AMENDMENTS REVISED BUDGET REQUISITIONS ENCUMBRANCES ACTUALS AVAILABLE BUDGET 400708 TREATMENT Plt DISCHARGE $ - 300,000.00 300,000.00 - - - 300,000.00 400904 EAST INDEPENDENCE INDUST PARK - 674,000.00 674,000.00 - - - 674,000.00 401003 FUTURE Prod WELLS - 965,326.00 965,326.00 - - - 965,326.00 401301 23RD ST MAIN REPLACEMENT 150,000.00 177,230.57 327,230.57 - - - 327,230.57 401402 LAGOON CLEANOUT - 302,560.00 302,560.00 - 327,060.00 - (24,500.00) 401505 Dist Sys IMPROVE - 258,054.00 258,054.00 - 13,273.00 - 244,781.00 401506 TRUMAN ROAD BOOSTER STATION - 106,569.52 106,569.52 - 34,658.85 - 71,910.67 401601 FILTER BACKWASH OUTFALL - 190,325.00 190,325.00 - - - 190,325.00 401602 Plt DISCHARGE OUTFALL - 459,824.48 459,824.48 - - - 459,824.48 401605 COURTNEY BEND BASIN CATWALK - 10,020.00 10,020.00 - - - 10,020.00 401608 LIME SILO 1,300,000.00 291,070.12 1,591,070.12 - 258,790.59 205,357.13 1,126,922.40 401703 Maint BUILDING AT CBP - 200,000.00 200,000.00 - - - 200,000.00 401704 VAN HORN RESERVOIR IMPROVE - 500,204.23 500,204.23 - 373,569.00 119,819.23 6,816.00 401706 Main Replacement Ellison Way - 483,814.35 483,814.35 - - - 483,814.35 401802 6" Main Replacement James Downey Rd - 250,087.60 250,087.60 - - - 250,087.60 401804 Filter Valve House Roof Improvement 75,000.00 22,292.00 97,292.00 - - - 97,292.00 401808 VFD Drive Replacements HSP 2 & 4 - 227,728.00 227,728.00 - 12,060.00 (15,299.00) 230,967.00 401818 30" Steel Transmission Main Assess - 156,300.00 156,300.00 - - - 156,300.00 401821 Main Replacement-32nd/Hunter/Bird - 91,000.00 91,000.00 - - - 91,000.00 401822 Main Replacement-24Hwy/Northern/RR - 240,166.00 240,166.00 - - - 240,166.00 402002 39th Street Reservoir - 1,200,000.00 1,200,000.00 - 29,800.00 - 1,170,200.00 402004 Main Replace Walnut/Leslie/LeesSumm - 143,152.66 143,152.66 - 12,022.53 49,911.40 81,218.73 402007 Courtney Bend Emergency Generator 1,000,000.00 150,000.00 1,150,000.00 - - - 1,150,000.00 402008 Wellfield Overhead Electrical Imp 800,000.00 200,000.00 1,000,000.00 - - - 1,000,000.00 402009 Main Replace Sheley/Claremont/Norw - 191,032.00 191,032.00 - 2,242.00 - 188,790.00 402010 Main Replace Gudgell/Dodgion/KingsH - 1,008,365.00 1,008,365.00 - - - 1,008,365.00 402011 Main Replace Salisbury/Peck/Geospac - 551,900.00 551,900.00 551,900.00 - -402012 College Avenue Improvements - 250,000.00 250,000.00 - - - 250,000.00 402101 Main Replacement Ralston 31st/29th - 350,000.00 350,000.00 - - - 350,000.00 402102 Main Replacement 3rd St & Jennings - 460,000.00 460,000.00 - - - 460,000.00 402103 Main Replacement Truman Road 50,000.00 490,502.00 540,502.00 - 6,332.00 - 534,170.00 402104 Lime Slaker No 5 - 350,000.00 350,000.00 - - - 350,000.00 402105 Main Replacement Sheley - 100,000.00 100,000.00 - - - 100,000.00 402106 Main Replacement Sheley & Northern - 1,035,000.00 1,035,000.00 - - - 1,035,000.00 402107 Facility Improvements/Const/Maint - 250,000.00 250,000.00 - - - 250,000.00 402108 Basin Drive Improvements 250,000.00 250,000.00 500,000.00 - - - 500,000.00 402201 Roof Improvements 250,000.00 - 250,000.00 - - - 250,000.00 402203 Lime Slaker No 1 350,000.00 - 350,000.00 - - - 350,000.00 402207 CB Electrical Switchgear Improvemen 200,000.00 - 200,000.00 - - - 200,000.00 9749 MAIN REPLACEMENT PROGRAM 1,745,000.00 793,907.19 2,538,907.19 - - - 2,538,907.19 9952 SECURITY UPGRADES 250,000.00 267,590.82 517,590.82 - - - 517,590.82 $ 6,420,000.00 13,948,021.54 20,368,021.54 551,900.00 1,069,807.97 359,788.76 18,386,524.81 Current Year Prior Year Budget Budget (Enc Roll) Total Budget 19,286,024.81 $ 1,081,996.73 20,368,021.54 Less Expenditures - 359,788.76 359,788.76 Less Encumbrances 906,000.00 715,707.97 1,621,707.97 Total Available 18,380,024.81 $ 6,500.00 18,386,524.81
21
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Sanitary Sewer
For the period ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Operating revenues: Charges for Services $ 35,151,285 35,151,285 9,283,226 (25,868,059) 26.41% 1.41% Penalties 200,000 200,000 91,325 (108,675) 45.66% 20.66% Total operating revenues 35,351,285 35,351,285 9,374,551 (25,976,734) 26.52% 1.52% Operating expenses: Personnel Services 6,672,780 6,672,780 1,417,235 5,255,545 21.24% -3.76% Other Services 13,843,955 13,718,955 3,173,926 10,545,029 23.14% -1.86% Supplies 1,222,200 1,349,808 316,457 1,033,351 23.44% -1.56% Capital Projects 3,925,000 15,487,758 440,474 15,047,284 2.84% -22.16% Capital Operating 424,500 421,892 302,807 119,085 71.77% 46.77% Debt Service 6,288,332 6,288,332 1,009,414 5,278,918 16.05% -8.95% Other Expenses 0.00% -25.00% Total Operating Expenses 32,376,767 43,939,525 6,660,313 37,279,212 15.16% -9.84% Nonoperating Revenues (Expenses): Investment Income 104,000 104,000 125,972 21,972 121.13% 96.13% Miscellaneous Revenue (Expense) 7,820 7,820 8,196 376 104.81% 79.81% Total Nonoperating Revenue (Expenses) 111,820 111,820 134,168 22,348 119.99% 94.99% 3,086,338 (8,476,420) 2,848,406 11,324,826 -33.60% -58.60% Transfers Out – Utility Payments In Lieu of Taxes (3,596,612) (3,596,612) (873,829) (2,722,783) 24.30% -0.70% Transfers In 10,000 10,000 10,000 100.00% 75.00% Transfers Out 0.00% -25.00% Total Transfers (3,586,612) (3,586,612) (863,829) (2,722,783) 24.08% -0.92% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (500,274) (12,063,032) 1,984,577 14,047,609 Beginning Available Resources 26,265,639 Ending Available Resources 28,250,216 Revenue Risk 2,750,000 Capital Reserve 6,000,000 Expense Risk 400,000 Working Capital 7,400,000 Targeted Reserve Level 16,550,000 Total Non-Restricted Resources Available $ 11,700,216 Income (Loss) Before Transfers
22
Sanitary Sewer - Open Capital Projects
As of September 30, 2021
PROJECT PROJECT TITLE ORIGINAL BUDGET NET BUDGET AMENDMENTS REVISED BUDGET REQUISITIONS ENCUMBRANCES ACTUALS AVAILABLE BUDGET 300801 NEIGHBORHOOD PROJECTS $ - 574,405.94 574,405.94 - 452,267.71 86,755.18 35,383.05 301108 HOLDING BASINS AND PMP STATION - 694,045.55 694,045.55 - - - 694,045.55 301201 BURR OAK EAST - 1,035,327.15 1,035,327.15 - - - 1,035,327.15 301202 CRACKERNECK-VAN HOOK SEWER - 529,163.59 529,163.59 - - - 529,163.59 301505 SEWAGE SLUDGE INCINERATOR IMP - 605,823.97 605,823.97 - - - 605,823.97 301603 RCTP FACILITIES ROOF, CEILING - 170,925.00 170,925.00 - - - 170,925.00 301604 PRIMARY SLUDGE GRINDERS & - 6,989.69 6,989.69 - - - 6,989.69 301701 SCADA UPGRADE - 1,006,730.00 1,006,730.00 - 73,487.00 6,343.15 926,899.85 301703 ARROWHEAD CENTER - 551,675.62 551,675.62 - 133,249.60 287,864.10 130,561.92 301705 16TH/SCOTT - 357,780.55 357,780.55 - 5,390.10 - 352,390.45 301706 TREATMENT FACILITY IMPROVEMENT - 593,007.00 593,007.00 - 46,000.00 - 547,007.00 301707 NEIGHBORHOOD IMPROVE 17-18 - 82,650.24 82,650.24 - 7,606.50 - 75,043.74 301804 ROCK CREEK EFFLUENT STRUCTURE - 361,673.21 361,673.21 - 23,805.27 12,847.44 325,020.50 301806 Neighborhood Improvements 2018-19 - 442,262.68 442,262.68 - 4,381.81 - 437,880.87 302001 Fairmount Highlands - 170,000.00 170,000.00 - - - 170,000.00 302002 Arlington Improvements - 100,000.00 100,000.00 - - - 100,000.00 302003 Bison Park - 424,907.85 424,907.85 - 92.00 2,644.00 422,171.85 302004 Neighborhood Projects 2019-20 - 580,000.00 580,000.00 - - - 580,000.00 302005 Biosolids Handling - 2,919,676.59 2,919,676.59 - 1,795,694.59 232,225.00 891,757.00 302006 Raw Pumps & Screening - 900,000.00 900,000.00 - - - 900,000.00 302007 Electrical Substation Rehab - 158,690.00 158,690.00 - - - 158,690.00 302008 RCTP Fence - 450,000.00 450,000.00 - 377,798.00 - 72,202.00 302009 Truman & Harris - 50,000.00 50,000.00 - - - 50,000.00 302101 Sanitation Sewer Evaluation Survey - 199,303.60 199,303.60 - 70,230.50 4,628.25 124,444.85 302102 Raymond Harkless Mills San Imp - 200,000.00 200,000.00 - - - 200,000.00 302103 Pump Station Imp & Maintenance 100,000.00 200,000.00 300,000.00 - 67,148.00 - 232,852.00 302104 Polymer System Relocation - 100,000.00 100,000.00 - - - 100,000.00 302105 Piping Rehabilitation 200,000.00 200,000.00 400,000.00 - 19,947.50 - 380,052.50 302201 Upper Adair Interceptor 800,000.00 - 800,000.00 - - - 800,000.00 302202 Crackerneck Creek Slope Rehab 1,100,000.00 - 1,100,000.00 5,600.00 - - 1,094,400.00 302203 Sanitary Sewer Main Reloc from Stre 300,000.00 - 300,000.00 - - - 300,000.00 302204 RCTP - Septic Pumper 300,000.00 - 300,000.00 - - - 300,000.00 302205 Clarifier Rehabilitation 800,000.00 - 800,000.00 - - - 800,000.00 302206 Railing Safety RCPS & SCPS 325,000.00 - 325,000.00 - - - 325,000.00 9757 TRENCHLESS TECHNOLOGY - 1,555,740.96 1,555,740.96 - 275,409.60 107,080.00 1,173,251.36 $ 3,925,000.00 15,220,779.19 19,145,779.19 5,600.00 3,352,508.18 740,387.12 15,047,283.89 Current Year Prior Year Budget Budget (Enc Roll) Total Budget 15,487,758.04 $ 3,658,021.15 19,145,779.19 Less Expenditures 11,076.15 729,310.97 740,387.12 Less Encumbrances 429,398.00 2,928,710.18 3,358,108.18 Total Available 15,047,283.89 $ - 15,047,283.89
23
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Events Center Debt Service
For the period ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Operating revenues: Charges for Services $ 0.00% -25.00% Miscellaneous 0.00% -25.00% Total operating revenues 0.00% -25.00% Operating Expenses: Personnel Services 0.00% -25.00% Other Services 1,000 1,000 250 750 25.00% 0.00% Supplies 0.00% -25.00% Capital Outlay 3,120,150 4,525,245 1,030,423 3,494,822 22.77% -2.23% Debt Service 5,292,906 5,292,906 909,477 4,383,429 17.18% -7.82% Other Expenses 0.00% -25.00% Total Operating Expenses 8,414,056 9,819,151 1,940,150 7,879,001 19.76% -5.24% Nonoperating Revenues (Expenses): Investment Income 71,000 71,000 2,827 (68,173) 3.98% -21.02% Miscellaneous Revenue (Expense) 0.00% -25.00% Sales Tax 5,173,844 5,173,844 227,411 (4,946,433) 4.40% -20.60% Total Nonoperating Revenue (Expenses) 5,244,844 5,244,844 230,238 (5,014,606) 4.39% -20.61% (3,169,212) (4,574,307) (1,709,912) 2,864,395 37.38% 12.38% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -25.00% Transfers In 75,000 75,000 75,000 0.00% -25.00% Transfers Out 0.00% -25.00% Total Transfers 75,000 75,000 75,000 0.00% -25.00% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (3,094,212) (4,499,307) (1,709,912) 2,789,395 Unassigned Fund Balance at Beginning of Year (25,273,358) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year (1,767,353) Ending Unassigned Fund Balance, 09/30/21 (28,750,623) Restricted: Bond Reserve Project Accounts 6,841,006 Total restricted 6,841,006 Committed: Capital Projects In Process 3,494,822 Total Committed 3,494,822 Assigned: Prior Year Open Encumbrances - Excluding Capital Projects Current Year Open Encumbrances - Excluding Capital Projects Total Assigned Total Fund Balance $ (18,414,795) Income (Loss) Before Transfers
24
CITY
INDEPENDENCE, MISSOURI
For the period ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Operating revenues: Charges for Services $ 2,206,668 2,206,668 593,541 (1,613,127) 26.90% 1.90% Miscellaneous 1,658 1,658 0.00% -25.00% Total Operating Revenues 2,206,668 2,206,668 595,199 (1,611,469) 26.97% 1.97% Operating Expenses: Personnel Services 852,345 852,345 182,723 669,622 21.44% -3.56% Other Services 538,628 538,628 608,053 (69,425) 112.89% 87.89% Supplies 787,055 787,055 766,403 20,652 97.38% 72.38% Capital Outlay 39,000 39,000 26,950 12,050 69.10% 44.10% Other Expenses 0.00% -25.00% Total Operating Expenses 2,217,028 2,217,028 1,584,129 632,899 71.45% 46.45% Nonoperating Revenues (Expenses): Investment Income 8,000 8,000 2,482 (5,518) 31.03% 6.03% Miscellaneous Revenue (Expense) 761 761 0.00% -25.00% Total Nonoperating Revenue (Expenses) 8,000 8,000 3,243 (4,757) 40.54% 15.54% (2,360) (2,360) (985,687) (983,327) 41766.40% 41741.40% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -25.00% Transfers In 0.00% -25.00% Transfers Out 0.00% -25.00% Total Transfers 0.00% -25.00% Change In Net Position (Budget Basis) $ (2,360) (2,360) (985,687) (983,327) Unassigned Fund Balance at Beginning of Year (1,536,610) Cancellation of Prior Year Encumbrances 81,491 Change in Other Fund Balance Components During the Year (1,213) Year-end investment market value adjustment Ending Unassigned Fund Balance GAAP Basis, 09/30/21 (2,442,019) Other Net Position Components: Assigned - Current Year Encumbrances 1,075,764 Assigned - Prior Year Encumbrances 16,366 Total Fund Balance $ (1,349,889) Income (Loss) Before Transfers
OF
Budgetary Comparison Schedule Central Garage
25
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule
Staywell Health Care
For the period ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Operating revenues: Charges for Services $ 15,500,000 15,500,000 4,779,944 (10,720,056) 30.84% 5.84% Miscellaneous 0.00% -25.00% Total Operating Revenues 15,500,000 15,500,000 4,779,944 (10,720,056) 30.84% 5.84% Operating Expenses: Personnel Services 187,200 187,200 2,640 184,560 1.41% -23.59% Other Services 19,166,120 19,166,120 5,949,660 13,216,460 31.04% 6.04% Supplies 0.00% -25.00% Capital Outlay 0.00% -25.00% Other Expenses 0.00% -25.00% Total Operating Expenses 19,353,320 19,353,320 5,952,300 13,401,020 30.76% 5.76% Nonoperating Revenues (Expenses): Investment Income 4,000 4,000 1,209 (2,791) 30.23% 5.23% Miscellaneous Revenue (Expense) 654,068 654,068 0.00% -25.00% Total Nonoperating Revenue (Expenses) 4,000 4,000 655,277 651,277 16381.93% 16356.93% (3,849,320) (3,849,320) (517,079) 3,332,241 13.43% -11.57% Transfers In - American Rescue Plan 2,350,000 (2,350,000) 0.00% -25.00% Transfers Out 0.00% -25.00% Total Transfers 2,350,000 (2,350,000) 0.00% -25.00% Change In Net Position (Budget Basis) $ (3,849,320) (3,849,320) 1,832,921 5,682,241 Unassigned Fund Balance at Beginning of Year 289,505 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance GAAP Basis, 09/30/21 2,122,426 Other Net Position Components: Assigned - Current Year Encumbrances 90,000 Assigned - Prior Year Encumbrances Total Fund Balance $ 2,212,426 Income (Loss) Before Transfers
26
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Operating revenues: Charges for Services $ 4,625,000 4,625,000 1,156,247 (3,468,753) 25.00% 0.00% Miscellaneous 0.00% -25.00% Total Operating Revenues 4,625,000 4,625,000 1,156,247 (3,468,753) 25.00% 0.00% Operating Expenses: Personnel Services 13,778 13,778 3,270 10,508 23.73% -1.27% Other Services 4,599,000 4,599,000 1,581,955 3,017,045 34.40% 9.40% Supplies 3,000 3,000 3,000 0.00% -25.00% Capital Outlay 2,000 2,000 2,000 0.00% -25.00% Other Expenses 0.00% -25.00% Total Operating Expenses 4,617,778 4,617,778 1,585,225 3,032,553 34.33% 9.33% Nonoperating Revenues (Expenses): Investment Income 1,835 1,835 0.00% -25.00% Miscellaneous Revenue (Expense) 1,063 1,063 0.00% -25.00% Total Nonoperating Revenue (Expenses) 2,898 2,898 0.00% -25.00% 7,222 7,222 (426,080) (433,302) -5899.75% -5924.75% Transfers In 0.00% -25.00% Transfers Out 0.00% -25.00% Total Transfers 0.00% -25.00% Change In Net Position (Budget Basis) $ 7,222 7,222 (426,080) (433,302) Unassigned Fund Balance at Beginning of Year (8,482,526) 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, 09/30/21 (8,908,606) Other Net Position Components: Restricted - Work Comp Escrow Assigned - Current Year Encumbrances 137,784 Assigned - Prior Year Encumbrances 10,675 Total Fund Balance $ (8,760,147) Income (Loss) Before Transfers
Budgetary Comparison Schedule Workers' Compensation For the period ended September 30, 2021 27
CITY OF INDEPENDENCE, MISSOURI
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Risk Management
For the period ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Operating revenues: Charges for Services $ 2,995,000 2,995,000 743,775 (2,251,225) 24.83% -0.17% Miscellaneous 0.00% -25.00% Total Operating Revenues 2,995,000 2,995,000 743,775 (2,251,225) 24.83% -0.17% Operating Expenses: Personnel Services 13,778 13,778 3,270 10,508 23.73% -1.27% Other Services 2,977,000 2,977,000 1,088,131 1,888,869 36.55% 11.55% Supplies 3,000 3,000 3,000 0.00% -25.00% Capital Outlay 0.00% -25.00% Other Expenses 0.00% -25.00% Total Operating Expenses 2,993,778 2,993,778 1,091,401 1,902,377 36.46% 11.46% Nonoperating Revenues (Expenses): Investment Income 8,563 8,563 0.00% -25.00% Miscellaneous Revenue (Expense) 0.00% -25.00% Total Nonoperating Revenue (Expenses) 8,563 8,563 0.00% -25.00% 1,222 1,222 (339,063) (340,285) -27746.56% -27771.56% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -25.00% Transfers In 0.00% -25.00% Transfers Out 0.00% -25.00% Total Transfers 0.00% -25.00% Change In Net Position (Budget Basis) $ 1,222 1,222 (339,063) (340,285) Unassigned Fund Balance at Beginning of Year 1,345,764 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, 09/30/21 1,006,701 Other Net Position Components: Assigned - Current Year Encumbrances 62,366 Assigned - Prior Year Encumbrances 7,382 Total Fund Balance $ 1,076,449 Income (Loss) Before Transfers
28
Actual Variance Percent Percent Budgeted Amounts Amounts with Amended Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Operating revenues: Charges for Services $ 2,200,000 2,200,000 550,000 (1,650,000) 25.00% 0.00% Miscellaneous 0.00% -25.00% Total Operating Revenues 2,200,000 2,200,000 550,000 (1,650,000) 25.00% 0.00% Operating Expenses: Personnel Services 655,218 655,218 120,304 534,914 18.36% -6.64% Other Services 1,147,200 1,147,200 59,159 1,088,041 5.16% -19.84% Supplies 0.00% -25.00% Capital Outlay 50,000 50,000 50,000 0.00% -25.00% Other Expenses 0.00% -25.00% Total Operating Expenses 1,852,418 1,852,418 179,463 1,672,955 9.69% -15.31% Nonoperating Revenues (Expenses): Investment Income 0.00% -25.00% Miscellaneous Revenue (Expense) 0.00% -25.00% Total Nonoperating Revenue (Expenses) 0.00% -25.00% 347,582 347,582 370,537 22,955 106.60% 81.60% Transfers Out – Utility Payments In Lieu of Taxes 0.00% -25.00% Transfers In – CARES Act 0.00% -25.00% Transfers Out 0.00% -25.00% Total Transfers 0.00% -25.00% Change In Net Position (Budget Basis) $ 347,582 347,582 370,537 22,955 Unassigned Fund Balance at Beginning of Year 1,233,146 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance GAAP Basis, 09/30/21 1,603,683 Other Net Position Components: Assigned - Current Year Encumbrances 35,810 Assigned - Prior Year Encumbrances 112,894 Total Fund Balance $ 1,752,387 Income (Loss) Before Transfers
Budgetary Comparison Schedule Enterprise Resource Planning For the period ended September 30, 2021 29
CITY OF INDEPENDENCE, MISSOURI
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Charges for Services $ 9,289 9,289 (9,289) 0.00% -25.00% Investment Income (Loss) 200 200 91 (109) 45.50% 20.50% Other Revenue 0.00% -25.00% Total Revenues 9,489 9,489 91 (9,398) 0.96% -24.04% Expenditures: General Government 0.00% -25.00% Debt Service 9,586 9,586 793 8,793 8.27% -16.73% Total Expenditures 9,586 9,586 793 8,793 8.27% -16.73% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total expenditures and other financing uses 9,586 9,586 793 8,793 8.27% -16.73% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (97) (97) (702) (605) Unassigned Fund Balance at Beginning of Year 106,985 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Ending Unassigned Fund Balance, 09/30/21 106,283 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Total Fund Balance $ 106,283
Debt Service - Neighborhood Improvement Districts For the period ended September 30, 2021 30
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Charges for Services $ 1,153 1,153 0.00% -25.00% Investment Income 2,000 2,000 283 (1,717) 14.15% -10.85% Intergovernmental 0.00% -25.00% Other Revenue 0.00% -25.00% Total Revenues 2,000 2,000 1,436 (564) 71.80% 46.80% Other Financing Sources: Transfers In 0.00% -25.00% Total Other Financing Sources 0.00% -25.00% Total Revenues and Other Financing Sources 2,000 2,000 1,436 (564) 71.80% 46.80% Expenditures: Public Works 0.00% -25.00% Culture and Recreation 0.00% -25.00% Capital Outlay 124,236 124,236 0.00% -25.00% Total Expenditures 124,236 124,236 0.00% -25.00% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses — 124,236 — 124,236 0.00% -25.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 2,000 (122,236) 1,436 123,672 Unassigned Fund Balance at Beginning of Year (137,026) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Ending Unassigned Fund Balance, 09/30/21 (135,590) Other Fund Balance Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances 147,103 Total Fund Balance $ 11,513
Comparison Schedule
Budgetary
Street Improvements Capital Project Fund For the period ended September 30, 2021 31
CITY OF INDEPENDENCE, MISSOURI
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Revolving Public Improvements Capital Project Fund For the period ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Charges for Services $ 0.00% -25.00% Investment Income (Loss) 136 136 0.00% -25.00% Other Revenue 0.00% -25.00% Total Revenues 136 136 0.00% -25.00% Expenditures: Public Works 0.00% -25.00% Culture and Recreation 0.00% -25.00% Capital Outlay 0.00% -25.00% Total Expenditures 0.00% -25.00% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 0.00% -25.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 136 136 Unassigned Fund Balance at Beginning of Year 21,613 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Ending Unassigned Fund Balance, 09/30/21 21,749 Other Fund Balance Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances Total Fund Balance $ 21,749
32
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Charges for Services $ 0.00% -25.00% Investment Income 1,557 1,557 0.00% -25.00% Other Revenue 100,800 100,800 100,800 100.00% 75.00% Total revenues 100,800 100,800 102,357 1,557 101.54% 76.54% Other Financing Sources: Transfers In 0.00% -25.00% Total Other Financing Sources 0.00% -25.00% Total Revenues and Other Financing Sources 100,800 100,800 102,357 1,557 101.54% 76.54% Expenditures: Public Works 0.00% -25.00% Culture and Recreation 0.00% -25.00% Capital Outlay 506,900 783,998 783,998 0.00% -25.00% Total Expenditures 506,900 783,998 783,998 0.00% -25.00% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total expenditures and other financing uses 506,900 783,998 783,998 0.00% -25.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (406,100) (683,198) 102,357 785,555 Unassigned Fund Balance at Beginning of Year (701,084) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Ending Unassigned Fund Balance, 09/30/21 (598,727) Other Fund Balance Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances 572,663 Total Fund Balance $ (26,064)
Buildings and Other Improvements Capital Project Fund For the period ended September 30, 2021 33
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Charges for Services $ 0.00% -25.00% Investment Income 0.00% -25.00% Other Revenue 0.00% -25.00% Total revenues 0.00% -25.00% Expenditures: Public Works 0.00% -25.00% Culture and Recreation 0.00% -25.00% Capital Outlay 0.00% -25.00% Total Expenditures 0.00% -25.00% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total expenditures and other financing uses 0.00% -25.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ Unassigned Fund Balance at Beginning of Year (16,155) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Ending Unassigned Fund Balance, 09/30/21 (16,155) Fund Balance Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances Total Fund Balance $ (16,155) CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Storm Drainage Capital Project Fund For the period ended September 30, 2021 34
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Park Improvements Capital Project Fund For the period ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Charges for Services $ 0.00% -25.00% Investment Income (Loss) 203 203 0.00% -25.00% Other Revenue 0.00% -25.00% Total revenues 203 203 0.00% -25.00% Expenditures: Public Works 0.00% -25.00% Culture and Recreation 0.00% -25.00% Capital Outlay 0.00% -25.00% Total Expenditures 0.00% -25.00% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total expenditures and other financing uses 0.00% -25.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 203 203 Unassigned Fund Balance at Beginning of Year 31,479 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Ending Unassigned Fund Balance, 09/30/21 31,682 Fund Balance Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances Total Fund Balance $ 31,682
35
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Charges for Services $ 10,500 10,500 (10,500) 0.00% -25.00% Investment Income 30 30 0.00% -25.00% Other Revenue 0.00% -25.00% Total Revenues 10,500 10,500 30 (10,470) 0.29% -24.71% Expenditures: Public Works 0.00% -25.00% Culture and Recreation 10,310 10,310 2,080 8,230 20.17% -4.83% Capital Outlay 0.00% -25.00% Total Expenditures 10,310 10,310 2,080 8,230 20.17% -4.83% Other Financing Uses: Transfers Out/Capital Outlay 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 10,310 10,310 2,080 8,230 20.17% -4.83% Excess of revenues over (under) expenditures and Other Financing Uses, Budget Basis $ 190 190 (2,050) (2,240) Unassigned Net Position at Beginning of Year 903 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Net Position, 09/30/21 (1,147) Other Net Position Components: Committed - Current Year Encumbrances Committed - Prior Year Encumbrances Total Net Position $ (1,147)
Private Purpose Expendable Trust Fund - Vaile Mansion For the period ended September 30, 2021 36
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Independence Events Center CID For the period ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Sales Taxes $ 8,106,070 8,106,070 1,379,249 (6,726,821) 17.02% -7.98% Investment Income 75,000 75,000 4,651 (70,349) 6.20% -18.80% Total Revenues 8,181,070 8,181,070 1,383,900 (6,797,170) 16.92% -8.08% Expenditures: Administrative Fee 162,121 162,121 27,585 134,536 17.02% -7.98% Insurance 2,150 2,150 537 1,613 24.98% -0.02% Legal 55,300 55,300 55,300 0.00% -25.00% Audit 5,500 5,500 5,300 200 96.36% 71.36% Banking 6,500 6,500 2,265 4,235 34.85% 9.85% Contract Services 0.00% -25.00% Capital Outlay 0.00% -25.00% Other 0.00% -25.00% Total Expenditures 231,571 231,571 35,687 195,884 15.41% -9.59% Other Financing Uses: Transfers Out - EATS (1,175,000) (1,175,000) (227,411) (947,589) 19.35% -5.65% Transfers Out - Debt Service (City) (4,205,456) (4,205,456) (4,205,456) 0.00% -25.00% Transfers Out - Captial Projects (3,120,150) (3,120,150) (3,120,150) 0.00% -25.00% Total Other Financing Uses (8,500,606) (8,500,606) (227,411) (8,273,195) 2.68% -22.32% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ (551,107) (551,107) 1,120,802 1,671,909 Unassigned Fund Balance at Beginning of Year 9,171,998 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 09/30/21 10,292,800 Other Fund Balance Components: Restricted - current year encumbrances 5,300 Restricted - prior year encumbrances 300,000 Total Fund Balance $ 10,598,100
37
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Sales taxes $ 467,996 467,996 89,559 (378,437) 19.14% -5.86% Investment income 300 300 82 (218) 27.33% 2.33% Total revenues 468,296 468,296 89,641 (378,655) 19.14% -5.86% Expenditures: Administrative fee 9,360 9,360 1,791 7,569 19.13% -5.87% Insurance 2,150 2,150 537 1,613 24.98% -0.02% Legal 0.00% -25.00% Audit 5,500 5,500 5,300 200 96.36% 71.36% Banking 350 350 108 242 30.86% 5.86% Contract services 850 850 850 0.00% -25.00% Capital outlay 0.00% -25.00% Other 0.00% -25.00% Total expenditures 18,210 18,210 7,736 10,474 42.48% 17.48% Other financing uses: Transfers out - EATS (233,998) (233,998) (44,779) (189,219) 19.14% -5.86% Transfers out - Debt Service (City) (215,000) (215,000) (160,000) (55,000) 74.42% 49.42% Total other financing uses (448,998) (448,998) (204,779) (244,219) 45.61% 20.61% Excess of Revenue and Other Financing Sources Over (Under) Expenditures and Other Financing Uses, Budget Basis $ 1,088 1,088 (122,874) (123,962) Unassigned Fund Balance at Beginning of Year 137,827 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year (112) Unassigned Ending Fund Balance, 09/30/21 14,841 Other Fund Balance Components: Restricted - Current Year Encumbrances 5,300 Restricted - Prior Year Encumbrances Restricted - City Transportation 6,565 Total Fund Balance $ 26,706
Crackerneck Creek TDD For the period ended September 30, 2021 38
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Tax Increment Financing Summary For the Period Ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 15,970,917 15,970,917 1,769,301 (14,207,170) 11.08% -13.92% Investment Income (Loss) 294,000 294,000 142,256 (151,744) 48.39% 23.39% Other revenue 1,310,958 1,310,958 274,216 (1,036,742) 20.92% -4.08% Total Revenues 17,575,875 17,575,875 2,185,773 (15,395,656) 12.44% -12.56% Other Financing Sources: Transfers In 1,327,471 1,327,471 227,412 (1,100,059) 17.13% -7.87% Total Other Financing Sources 1,327,471 1,327,471 227,412 (1,100,059) 17.13% -7.87% Total Revenues and Other Financing Sources 18,903,346 18,903,346 2,413,185 (16,495,715) 12.77% -12.23% Expenditures: Tax Increment Financing 2,171,231 2,171,231 10,963 2,160,268 0.50% -24.50% Debt Service Principal 9,423,109 9,423,109 181,017 9,242,092 1.92% -23.08% Interest and Fiscal Agent Fees 5,082,094 5,082,094 2,134,064 2,948,030 41.99% 16.99% Debt Issuance Costs 0.00% -25.00% Total Expenditures 16,676,434 16,676,434 2,326,044 14,350,390 13.95% -11.05% Other Financing Uses: Issuance of Debt 0.00% -25.00% Reoffering Premium/Original Issue Discount 0.00% -25.00% Payment to Refund Loans Escrow Agent 0.00% -25.00% Transfers Out 227,412 (227,412) 0.00% -25.00% Total Other Financing Uses 227,412 (227,412) 0.00% -25.00% Total Expenditures and Other Financing Uses 16,676,434 16,676,434 2,553,456 14,122,978 15.31% -9.69% Excess of Revenues Over (Under) Expenditures and other financing uses $ 2,226,912 2,226,912 (140,271) (2,367,183) Unassigned Fund Balance at Beginning of Year 19,666,053 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 09/30/21 19,525,782 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances 15,226 Restricted - Trust Debt Service 26,834,074 Total Fund Balance $ 46,375,082
39
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 0.00% -25.00% Investment Income (Loss) 10 10 0.00% -25.00% Other Revenue 0.00% -25.00% Total Revenues 10 10 0.00% -25.00% Expenditures: Tax Increment Financing 0.00% -25.00% Debt Service Principal 0.00% -25.00% Interest and Fiscal Agent Fees 0.00% -25.00% Debt Issuance Costs 0.00% -25.00% Total Expenditures 0.00% -25.00% Other Financing Uses: Issuance of Debt 0.00% -25.00% Reoffering Premium/Original Issue Discount 0.00% -25.00% Payment to Refund Loans Escrow Agent 0.00% -25.00% Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 0.00% -25.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 10 10 Unassigned Fund Balance at Beginning of Year 1,574 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 09/30/21 1,584 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 1,584
Truman Rd TIF
Period Ended September 30, 2021 40
Schedule Mid-Town
For the
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison
Schedule
Santa Fe TIF
For the Period Ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 26,271 26,271 9,834 (16,437) 37.43% 12.43% Investment Income (Loss) 0.00% -25.00% Other Revenue 102,958 102,958 18,931 (84,027) 18.39% -6.61% Total Revenues 129,229 129,229 28,765 (100,464) 22.26% -2.74% Other Financing Sources: Transfers In 187,942 187,942 (187,942) 0.00% -25.00% Total Other Financing Sources 187,942 187,942 (187,942) 0.00% -25.00% Total Revenues and Other Financing Sources 317,171 317,171 28,765 (288,406) 9.07% -15.93% Expenditures: Tax Increment Financing 7,801 7,801 2,500 5,301 32.05% 7.05% Debt Service Principal 205,000 205,000 100,000 105,000 48.78% 23.78% Interest and Fiscal Agent Fees 327,938 327,938 164,806 163,132 50.26% 25.26% Debt Issuance Costs 0.00% -25.00% Total Expenditures 540,739 540,739 267,306 273,433 49.43% 24.43% Other Financing Uses: Issuance of Debt 0.00% -25.00% Reoffering Premium/Original Issue Discount 0.00% -25.00% Payment to Refund Loans Escrow Agent 0.00% -25.00% Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 540,739 540,739 267,306 273,433 49.43% 24.43% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (223,568) (223,568) (238,541) (14,973) Unassigned Fund Balance at Beginning of Year (1,115,449) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 09/30/21 (1,353,990) Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 557,832 Total Fund Balance $ (796,158)
41
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Hartman Heritage TIF
For the Period Ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 1,446,920 1,446,920 119,056 (1,327,864) 8.23% -16.77% Investment Income (Loss) 0.00% -25.00% Other Revenue 0.00% -25.00% Total Revenues 1,446,920 1,446,920 119,056 (1,327,864) 8.23% -16.77% Other Financing Sources: Transfers In 118,097 118,097 35,687 (82,410) 30.22% 5.22% Total Other Financing Sources 118,097 118,097 35,687 (82,410) 30.22% 5.22% Total Revenues and Other Financing Sources 1,565,017 1,565,017 154,743 (1,410,274) 9.89% -15.11% Expenditures: Tax Increment Financing 121,261 121,261 1,250 120,011 1.03% -23.97% Debt Service Principal 0.00% -25.00% Interest and Fiscal Agent Fees 0.00% -25.00% Debt Issuance Costs 0.00% -25.00% Total Expenditures 121,261 121,261 1,250 120,011 1.03% -23.97% Other Financing Uses: Issuance of Debt 0.00% -25.00% Reoffering Premium/Original Issue Discount 0.00% -25.00% Payment to Refund Loans Escrow Agent 0.00% -25.00% Transfers Out 35,687 (35,687) 0.00% -25.00% Total Other Financing Uses 35,687 (35,687) 0.00% -25.00% Total Expenditures and Other Financing Uses 121,261 121,261 36,937 84,324 30.46% 5.46% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 1,443,756 1,443,756 117,806 (1,325,950) Unassigned Fund Balance at Beginning of Year (2,999,627) Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 09/30/21 (2,881,821) Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ (2,881,821)
42
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 568,730 568,730 6,412 (562,318) 1.13% -23.87% Investment Income (Loss) 25,000 25,000 10,218 (14,782) 40.87% 15.87% Other Revenue 0.00% -25.00% Total Revenues 593,730 593,730 16,630 (577,100) 2.80% -22.20% Expenditures: Tax Increment Financing 15,338 15,338 2,000 13,338 13.04% -11.96% Debt Service Principal 415,000 415,000 415,000 0.00% -25.00% Interest and Fiscal Agent Fees 12,450 12,450 12,450 0.00% -25.00% Debt Issuance Costs 0.00% -25.00% Total Expenditures 442,788 442,788 2,000 440,788 0.45% -24.55% Other Financing Uses: Issuance of Debt 0.00% -25.00% Reoffering Premium/Original Issue Discount 0.00% -25.00% Payment to Refund Loans Escrow Agent 0.00% -25.00% Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 442,788 442,788 2,000 440,788 0.45% -24.55% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 150,942 150,942 14,630 (136,312) Unassigned Fund Balance at Beginning of Year 1,579,935 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 09/30/21 1,594,565 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 427,288 Total Fund Balance $ 2,021,853
Comparison Schedule Drumm Farm TIF
43
CITY OF INDEPENDENCE, MISSOURI Budgetary
For the Period Ended September 30, 2021
For the Period Ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 5,053,492 5,053,492 606,871 (4,446,621) 12.01% -12.99% Investment Income (Loss) 165,000 165,000 90,953 (74,047) 55.12% 30.12% Other Revenue 0.00% -25.00% Total Revenues 5,218,492 5,218,492 697,824 (4,520,668) 13.37% -11.63% Other Financing Sources: Transfers In 664,783 664,783 176,993 (487,790) 26.62% 1.62% Total Other Financing Sources 664,783 664,783 176,993 (487,790) 26.62% 1.62% Total Revenues and Other Financing Sources 5,883,275 5,883,275 874,817 (5,008,458) 14.87% -10.13% Expenditures: Tax Increment Financing 457,612 457,612 1,875 455,737 0.41% -24.59% Debt Service Principal 3,980,000 3,980,000 3,980,000 0.00% -25.00% Interest and Fiscal Agent Fees 57,000 57,000 80,500 (23,500) 141.23% 116.23% Debt Issuance Costs 0.00% -25.00% Total Expenditures 4,494,612 4,494,612 82,375 4,412,237 1.83% -23.17% Other Financing Uses: Issuance of Debt 0.00% -25.00% Reoffering Premium/Original Issue Discount 0.00% -25.00% Payment to Refund Loans Escrow Agent 0.00% -25.00% Transfers Out 176,993 (176,993) 0.00% -25.00% Total Other Financing Uses 176,993 (176,993) 0.00% -25.00% Total Expenditures and Other Financing Uses 4,494,612 4,494,612 259,368 4,235,244 5.77% -19.23% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 1,388,663 1,388,663 615,449 (773,214) Unassigned Fund Balance at Beginning of Year 15,004,007 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 09/30/21 15,619,456 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 897,682 Total Fund Balance $ 16,517,138
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Eastland TIF
44
CITY OF INDEPENDENCE, MISSOURI Budgetary
Comparison Schedule
North Independence TIF
For the Period Ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 57,965 57,965 8,451 (49,514) 14.58% -10.42% Investment Income (Loss) 0.00% -25.00% Other Revenue 0.00% -25.00% Total Revenues 57,965 57,965 8,451 (49,514) 14.58% -10.42% Expenditures: Tax Increment Financing 1,645 1,645 1,645 0.00% -25.00% Debt Service Principal 10,000 10,000 10,000 0.00% -25.00% Interest and Fiscal Agent Fees 45,530 45,530 7,700 37,830 16.91% -8.09% Debt Issuance Costs 0.00% -25.00% Total Expenditures 57,175 57,175 7,700 49,475 13.47% -11.53% Other Financing Uses: Issuance of Debt 0.00% -25.00% Reoffering Premium/Original Issue Discount 0.00% -25.00% Payment to Refund Loans Escrow Agent 0.00% -25.00% Transfers Out 0.00% -25.00% 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 57,175 57,175 7,700 49,475 13.47% -11.53% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 790 790 751 (39) Unassigned Fund Balance at Beginning of Year 11,934 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 09/30/21 12,685 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 12,685
45
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison
Schedule
Mt Washington TIF
For the Period Ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 2,179 2,179 232 (1,947) 10.65% -14.35% Investment Income (Loss) 1,000 1,000 311 (689) 31.10% 6.10% Other Revenue 0.00% -25.00% Total Revenues 3,179 3,179 543 (2,636) 17.08% -7.92% Other Financing Sources: Transfers In 0.00% -25.00% Capital lease proceeds 0.00% Total Other Financing Sources 0.00% -25.00% Total Revenues and Other Financing Sources 3,179 3,179 543 (2,636) 17.08% -7.92% Expenditures: Tax Increment Financing 63 63 63 0.00% -25.00% Debt Service Principal 0.00% -25.00% Interest and Fiscal Agent Fees 0.00% -25.00% Debt Issuance Costs 0.00% -25.00% Total Expenditures 63 63 63 0.00% -25.00% Other Financing Uses: Issuance of Debt 0.00% -25.00% Reoffering Premium/Original Issue Discount 0.00% -25.00% Payment to Refund Loans Escrow Agent 0.00% -25.00% Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 63 63 63 0.00% -25.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 3,116 3,116 543 (2,573) Unassigned Fund Balance at Beginning of Year 49,447 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 09/30/21 49,990 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 49,990
46
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Crackerneck Creek TIF
For the Period Ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 1,589,201 1,589,201 238,479 (1,350,722) 15.01% -9.99% Investment Income (Loss) 77,000 77,000 12,689 (64,311) 16.48% -8.52% Other Revenue 1,208,000 1,208,000 255,285 (952,715) 21.13% -3.87% Total Revenues 2,874,201 2,874,201 506,453 (2,367,748) 17.62% -7.38% Other Financing Sources: Transfers In 315,000 315,000 (315,000) 0.00% -25.00% Total Other Financing Sources 315,000 315,000 (315,000) 0.00% -25.00% Total Revenues and Other Financing Sources 3,189,201 3,189,201 506,453 (2,682,748) 15.88% -9.12% Expenditures: Tax Increment Financing 48,817 48,817 1,284 47,533 2.63% -22.37% Debt Service Principal 50,000 50,000 50,000 0.00% -25.00% Interest and Fiscal Agent Fees 3,775,226 3,775,226 1,261,244 2,513,982 33.41% 8.41% Debt Issuance Costs 0.00% -25.00% Total Expenditures 3,874,043 3,874,043 1,262,528 2,611,515 32.59% 7.59% Other Financing Uses: Issuance of Debt 0.00% -25.00% Reoffering Premium/Original Issue Discount 0.00% -25.00% Payment to Refund Loans Escrow Agent 0.00% -25.00% Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 3,874,043 3,874,043 1,262,528 2,611,515 32.59% 7.59% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (684,842) (684,842) (756,075) (71,233) Unassigned Fund Balance at Beginning of Year 4,520,449 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 09/30/21 3,764,374 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances 15,226 Restricted - Trust Debt Service 21,572,706 Total Fund Balance $ 25,352,306
47
CITY
For the Period Ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 496,239 496,239 7,370 (488,869) 1.49% -23.51% Investment Income (Loss) 1 1 0.00% -25.00% Other Revenue 0.00% -25.00% Total Revenues 496,239 496,239 7,371 (488,868) 1.49% -23.51% Expenditures: Tax Increment Financing 9,590 9,590 9,590 0.00% -25.00% Debt Service Principal 486,349 486,349 486,349 0.00% -25.00% Interest and Fiscal Agent Fees 7,300 (7,300) 0.00% -25.00% Debt Issuance Costs 0.00% -25.00% Total Expenditures 495,939 495,939 7,300 488,639 1.47% -23.53% Other Financing Uses: Issuance of Debt 0.00% -25.00% Reoffering Premium/Original Issue Discount 0.00% -25.00% Payment to Refund Loans Escrow Agent 0.00% -25.00% Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 495,939 495,939 7,300 488,639 1.47% -23.53% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 300 300 71 (229) Unassigned Fund Balance at Beginning of Year 9,853 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 09/30/21 9,924 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 9,924
OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule Old Landfill TIF
48
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Trinity TIF
For the Period Ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 489,107 489,107 40,002 (449,105) 8.18% -16.82% Investment Income (Loss) 3 3 0.00% -25.00% Other Revenue 0.00% -25.00% Total Revenues 489,107 489,107 40,005 (449,102) 8.18% -16.82% Other Financing Sources: Transfers In 32,466 32,466 12,232 (20,234) 37.68% 12.68% Total Other Financing Sources 32,466 32,466 12,232 (20,234) 37.68% 12.68% Total Revenues and Other Financing Sources 521,573 521,573 52,237 (469,336) 10.02% -14.98% Expenditures: Tax Increment Financing 11,267 11,267 11,267 0.00% -25.00% Debt Service Principal 510,360 510,360 510,360 0.00% -25.00% Interest and Fiscal Agent Fees 52,000 (52,000) 0.00% -25.00% Debt Issuance Costs 0.00% -25.00% Total Expenditures 521,627 521,627 52,000 469,627 9.97% -15.03% Other Financing Uses: Issuance of Debt 0.00% -25.00% Reoffering Premium/Original Issue Discount 0.00% -25.00% Payment to Refund Loans Escrow Agent 0.00% -25.00% Transfers Out 12,232 (12,232) 0.00% -25.00% Total Other Financing Uses 12,232 (12,232) 0.00% -25.00% Total Expenditures and Other Financing Uses 521,627 521,627 64,232 457,395 12.31% -12.69% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (54) (54) (11,995) (11,941) Unassigned Fund Balance at Beginning of Year 69,361 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 09/30/21 57,366 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 57,366
49
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule HCA
For the Period Ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 3,589,345 3,589,345 8,293 (3,581,052) 0.23% -24.77% Investment Income (Loss) 17,000 17,000 7,249 (9,751) 42.64% 17.64% Other Revenue 0.00% -25.00% Total Revenues 3,606,345 3,606,345 15,542 (3,590,803) 0.43% -24.57% Other Financing Sources: Transfers In 9,183 9,183 2,500 (6,683) 27.22% 2.22% Total Other Financing Sources 9,183 9,183 2,500 (6,683) 27.22% 2.22% Total Revenues and Other Financing Sources 3,615,528 3,615,528 18,042 (3,597,486) 0.50% -24.50% Expenditures: Tax Increment Financing 550,170 550,170 1,875 548,295 0.34% -24.66% Debt Service Principal 2,200,000 2,200,000 2,200,000 0.00% -25.00% Interest and Fiscal Agent Fees 863,950 863,950 431,975 431,975 50.00% 25.00% Debt Issuance Costs 0.00% -25.00% Total Expenditures 3,614,120 3,614,120 433,850 3,180,270 12.00% -13.00% Other Financing Uses: Issuance of Debt 0.00% -25.00% Reoffering Premium/Original Issue Discount 0.00% -25.00% Payment to Refund Loans Escrow Agent 0.00% -25.00% Transfers Out 2,500 (2,500) 0.00% -25.00% Total Other Financing Uses 2,500 (2,500) 0.00% -25.00% Total Expenditures and Other Financing Uses 3,614,120 3,614,120 436,350 3,177,770 12.07% -12.93% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 1,408 1,408 (418,308) (419,716) Unassigned Fund Balance at Beginning of Year 1,165,892 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 09/30/21 747,584 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service 3,378,566 Total Fund Balance $ 4,126,150
TIF
50
CITY OF
INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule
Cinema East TIF
For the Period Ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 257,861 257,861 38,581 (219,280) 14.96% -10.04% Investment Income (Loss) 4 4 0.00% -25.00% Other Revenue 0.00% -25.00% Total Revenues 257,861 257,861 38,585 (219,276) 14.96% -10.04% Expenditures: Tax Increment Financing 5,139 5,139 5,139 0.00% -25.00% Debt Service Principal 252,902 252,902 8,161 244,741 3.23% -21.77% Interest and Fiscal Agent Fees 51,839 (51,839) 0.00% -25.00% Debt Issuance Costs 0.00% -25.00% Total Expenditures 258,041 258,041 60,000 198,041 23.25% -1.75% Other Financing Uses: Issuance of Debt 0.00% -25.00% Reoffering Premium/Original Issue Discount 0.00% -25.00% Payment to Refund Loans Escrow Agent 0.00% -25.00% Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 258,041 258,041 60,000 198,041 23.25% -1.75% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (180) (180) (21,415) (21,235) Unassigned Fund Balance at Beginning of Year 80,315 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 09/30/21 58,900 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 58,900
51
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
For the Period Ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 82,194 82,194 4,598 (77,596) 5.59% -19.41% Investment Income (Loss) 6 6 0.00% -25.00% Other Revenue 0.00% -25.00% Total Revenues 82,194 82,194 4,604 (77,590) 5.60% -19.40% Expenditures: Tax Increment Financing 2,063 2,063 2,063 0.00% -25.00% Debt Service Principal 80,131 80,131 80,131 0.00% -25.00% Interest and Fiscal Agent Fees 0.00% -25.00% Debt Issuance Costs 0.00% -25.00% Total Expenditures 82,194 82,194 82,194 0.00% -25.00% Other Financing Uses: Issuance of Debt 0.00% -25.00% Reoffering Premium/Original Issue Discount 0.00% -25.00% Payment to Refund Loans Escrow Agent 0.00% -25.00% Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 82,194 82,194 82,194 0.00% -25.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 4,604 4,604 Unassigned Fund Balance at Beginning of Year 72,840 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 09/30/21 77,444 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 77,444
23rd & Noland Project 1 TIF
52
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule 23rd & Noland Project 2 TIF For the Period Ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 11,729 11,729 1,049 (10,680) 8.94% -16.06% Investment Income (Loss) 131 131 0.00% -25.00% Other Revenue 0.00% -25.00% Total Revenues 11,729 11,729 1,180 (10,549) 10.06% -14.94% Expenditures: Tax Increment Financing 246 246 246 0.00% -25.00% Debt Service Principal 11,483 11,483 21,000 (9,517) 182.88% 157.88% Interest and Fiscal Agent Fees 0.00% -25.00% Debt Issuance Costs 0.00% -25.00% Total Expenditures 11,729 11,729 21,000 (9,271) 179.04% 154.04% Other Financing Uses: Issuance of Debt 0.00% -25.00% Reoffering Premium/Original Issue Discount 0.00% -25.00% Payment to Refund Loans Escrow Agent 0.00% -25.00% Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 11,729 11,729 21,000 (9,271) 179.04% 154.04% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (19,820) (19,820) Unassigned Fund Balance at Beginning of Year 23,261 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 09/30/21 3,441 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 3,441
53
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison
Schedule
23rd & Noland Project 3 TIF
For the Period Ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 24,348 24,348 3,325 (21,023) 13.66% -11.34% Investment Income (Loss) 254 254 0.00% -25.00% Other Revenue 0.00% -25.00% Total Revenues 24,348 24,348 3,579 (20,769) 14.70% -10.30% Expenditures: Tax Increment Financing 24,438 24,438 24,438 0.00% -25.00% Debt Service Principal 0.00% -25.00% Interest and Fiscal Agent Fees 0.00% -25.00% Debt Issuance Costs 0.00% -25.00% Total Expenditures 24,438 24,438 24,438 0.00% -25.00% Other Financing Uses: Issuance of Debt 0.00% -25.00% Reoffering Premium/Original Issue Discount 0.00% -25.00% Payment to Refund Loans Escrow Agent 0.00% -25.00% Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 24,438 24,438 24,438 0.00% -25.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (90) (90) 3,579 3,669 Unassigned Fund Balance at Beginning of Year 6,738 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 09/30/21 10,317 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 10,317
54
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
23rd & Noland Project 4 TIF
For the Period Ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 462,503 462,503 181,813 (280,690) 39.31% 14.31% Investment Income (Loss) 2,595 2,595 0.00% -25.00% Other Revenue 0.00% -25.00% Total Revenues 462,503 462,503 184,408 (278,095) 39.87% 14.87% Expenditures: Tax Increment Financing 462,503 462,503 462,503 0.00% -25.00% Debt Service Principal 0.00% -25.00% Interest and Fiscal Agent Fees 0.00% -25.00% Debt Issuance Costs 0.00% -25.00% Total Expenditures 462,503 462,503 462,503 0.00% -25.00% Other Financing Uses: Issuance of Debt 0.00% -25.00% Reoffering Premium/Original Issue Discount 0.00% -25.00% Payment to Refund Loans Escrow Agent 0.00% -25.00% Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 462,503 462,503 462,503 0.00% -25.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 184,408 184,408 Unassigned Fund Balance at Beginning of Year 73,562 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 09/30/21 257,970 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 257,970
55
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Independence Square TIF
For the Period Ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 145,470 145,470 79,178 (66,292) 54.43% 29.43% Investment Income (Loss) 8,000 8,000 4,460 (3,540) 55.75% 30.75% Other Revenue 0.00% -25.00% Total Revenues 153,470 153,470 83,638 (69,832) 54.50% 29.50% Expenditures: Tax Increment Financing 7,799 7,799 7,799 0.00% -25.00% Debt Service Principal 0.00% -25.00% Interest and Fiscal Agent Fees 0.00% -25.00% Debt Issuance Costs 0.00% -25.00% Total Expenditures 7,799 7,799 7,799 0.00% -25.00% Other Financing Uses: Issuance of Debt 0.00% -25.00% Reoffering Premium/Original Issue Discount 0.00% -25.00% Payment to Refund Loans Escrow Agent 0.00% -25.00% Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 7,799 7,799 7,799 0.00% -25.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 145,671 145,671 83,638 (62,033) Unassigned Fund Balance at Beginning of Year 648,571 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 09/30/21 732,209 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 732,209
56
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
I-70 & Little Blue Parkway Project 1 TIF For the Period Ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 1,152,029 1,152,029 335,990 (816,039) 29.17% 4.17% Investment Income (Loss) 1,000 1,000 11,292 10,292 1129.20% 1104.20% Other Revenue 0.00% -25.00% Total Revenues 1,153,029 1,153,029 347,282 (805,747) 30.12% 5.12% Expenditures: Tax Increment Financing 23,927 23,927 23,927 0.00% -25.00% Debt Service Principal 1,128,102 1,128,102 51,856 1,076,246 4.60% -20.40% Interest and Fiscal Agent Fees 0.00% -25.00% Debt Issuance Costs 0.00% -25.00% Total Expenditures 1,152,029 1,152,029 51,856 1,100,173 4.50% -20.50% Other Financing Uses: Issuance of Debt 0.00% -25.00% Reoffering Premium/Original Issue Discount 0.00% -25.00% Payment to Refund Loans Escrow Agent 0.00% -25.00% Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 1,152,029 1,152,029 51,856 1,100,173 4.50% -20.50% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 1,000 1,000 295,426 294,426 Unassigned Fund Balance at Beginning of Year 258,617 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 09/30/21 554,043 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 554,043
57
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
I-70 & Little Blue Parkway Project 3 TIF For the Period Ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 382,156 382,156 33,498 (348,658) 8.77% -16.23% Investment Income (Loss) 2,078 2,078 0.00% -25.00% Other Revenue 0.00% -25.00% Total Revenues 382,156 382,156 35,576 (346,580) 9.31% -15.69% Expenditures: Tax Increment Financing 382,156 382,156 382,156 0.00% -25.00% Debt Service Principal 0.00% -25.00% Interest and Fiscal Agent Fees 0.00% -25.00% Debt Issuance Costs 0.00% -25.00% Total Expenditures 382,156 382,156 382,156 0.00% -25.00% Other Financing Uses: Issuance of Debt 0.00% -25.00% Reoffering Premium/Original Issue Discount 0.00% -25.00% Payment to Refund Loans Escrow Agent 0.00% -25.00% Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 382,156 382,156 382,156 0.00% -25.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 35,576 35,576 Unassigned Fund Balance at Beginning of Year 107,526 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Year-End Investment Market Value Adjustment Unassigned Ending Fund Balance, 09/30/21 143,102 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 143,102
58
CITY OF INDEPENDENCE, MISSOURI
Budgetary Comparison Schedule
Marketplace Project 1 TIF
For the Period Ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 97,731 97,731 27,761 (69,970) 28.41% 3.41% Investment Income (Loss) 1 1 0.00% -25.00% Other Revenue 0.00% -25.00% Total Revenues 97,731 97,731 27,762 (69,969) 28.41% 3.41% Expenditures: Tax Increment Financing 3,949 3,949 3,949 0.00% -25.00% Debt Service Principal 93,782 93,782 93,782 0.00% -25.00% Interest and Fiscal Agent Fees 54,000 (54,000) 0.00% -25.00% Debt Issuance Costs 0.00% -25.00% Total Expenditures 97,731 97,731 54,000 43,731 55.25% 30.25% Other Financing Uses: Issuance of Debt 0.00% -25.00% Reoffering Premium/Original Issue Discount 0.00% -25.00% Payment to Refund Loans Escrow Agent 0.00% -25.00% Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 97,731 97,731 54,000 43,731 55.25% 30.25% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (26,238) (26,238) Unassigned Fund Balance at Beginning of Year 62,802 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 09/30/21 36,564 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 36,564
59
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Marketplace Project 2 TIF
For the Period Ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 35,447 35,447 12,954 (22,493) 36.54% 11.54% Investment Income (Loss) 1 1 0.00% -25.00% Other Revenue 0.00% -25.00% Total Revenues 35,447 35,447 12,955 (22,492) 36.55% 11.55% Expenditures: Tax Increment Financing 35,447 35,447 179 35,268 0.50% -24.50% Debt Service Principal 0.00% -25.00% Interest and Fiscal Agent Fees 22,700 (22,700) 0.00% -25.00% Debt Issuance Costs 0.00% -25.00% Total Expenditures 35,447 35,447 22,879 12,568 64.54% 39.54% Other Financing Uses: Issuance of Debt 0.00% -25.00% Reoffering Premium/Original Issue Discount 0.00% -25.00% Payment to Refund Loans Escrow Agent 0.00% -25.00% Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 35,447 35,447 22,879 12,568 64.54% 39.54% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ (9,924) (9,924) Unassigned Fund Balance at Beginning of Year 34,445 Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 09/30/21 24,521 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 24,521
60
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 0.00% -25.00% Investment Income (Loss) 0.00% -25.00% Other Revenue 0.00% -25.00% Total Revenues 0.00% -25.00% Expenditures: Tax Increment Financing 0.00% -25.00% Debt Service Principal 0.00% -25.00% Interest and Fiscal Agent Fees 0.00% -25.00% Debt Issuance Costs 0.00% -25.00% Total Expenditures 0.00% -25.00% Other Financing Uses: Issuance of Debt 0.00% -25.00% Reoffering Premium/Original Issue Discount 0.00% -25.00% Payment to Refund Loans Escrow Agent 0.00% -25.00% Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 0.00% -25.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ Unassigned Fund Balance at Beginning of Year Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 09/30/21 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $
Budgetary Comparison Schedule TIF Application Fees For the Period Ended September 30, 2021 61
CITY OF INDEPENDENCE, MISSOURI
CITY OF INDEPENDENCE, MISSOURI Budgetary Comparison Schedule
Economic Development Sinking Fund
For the Period Ended September 30, 2021
Actual Variance Percent Percent Budgeted Amounts Amounts with Final Actual From Original Amended (Budget Basis) Budget 25.00% of Year Budget Revenues: Taxes $ 5,554 5,554 0.00% -25.00% Investment Income (Loss) 0.00% -25.00% Other Revenue 0.00% -25.00% Total Revenues 5,554 5,554 0.00% -25.00% Expenditures: Tax Increment Financing 0.00% -25.00% Debt Service Principal 0.00% -25.00% Interest and Fiscal Agent Fees 0.00% -25.00% Debt Issuance Costs 0.00% -25.00% Total Expenditures 0.00% -25.00% Other Financing Uses: Issuance of Debt 0.00% -25.00% Reoffering Premium/Original Issue Discount 0.00% -25.00% Payment to Refund Loans Escrow Agent 0.00% -25.00% Transfers Out 0.00% -25.00% Total Other Financing Uses 0.00% -25.00% Total Expenditures and Other Financing Uses 0.00% -25.00% Excess of Revenues Over (Under) Expenditures and Other Financing Uses $ 5,554 5,554 Unassigned Fund Balance at Beginning of Year Cancellation of Prior Year Encumbrances Change in Other Fund Balance Components During the Year Unassigned Ending Fund Balance, 09/30/21 5,554 Other Fund Balance Components: Restricted - Current Year Encumbrances Restricted - Prior Year Encumbrances Restricted - Trust Debt Service Total Fund Balance $ 5,554
62