Loading...
HomeMy WebLinkAbout2021 Annual Financial Report - Carmel Civil CityAnnual Financial Report Indiana State Board of Accounts 2021 CARMEL CIVIL CITY Hamilton County Submitted on 3/30/2022 8:02:00 AM Per IC 5-11-1-4 every municipality and local government is required to provide electronically and in a manner prescribed by the state examiner, financial reports for the fiscal year not later than sixty days after the close of the fiscal year. Completion and submission of the Gateway Annual Financial Report (AFR) will fulfill this requirement. This document comprises all of the report outputs generated by Gateway, based on the information entered by the government unit and submitted by the government official as stipulated in state law. Page 1Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Annual Financial Report - 2021 Cash & Investments Combined Statement Local Fund Number Local Fund Name Beg Cash & Inv Bal Jan. 1, 2021 Receipts Disbursement End Cash & Inv Bal Dec. 31, 2021 Governmental Activities 0 Carmel City Court $102,978.02 $1,146,704.88 $1,171,997.99 $77,684.91 0 Payroll Fund $0.00 $71,567,188.67 $71,567,188.67 $0.00 0 Redev Commission Trust Accounts $1,773,383.25 $26,425,984.19 $2,602,620.24 $25,596,747.20 0 2016 GO Bonds Trustee Accounts $2,422,392.46 $1,605.28 $143,602.93 $2,280,394.81 00 2021 GO Bond Trustee Account $0.00 $9,700,069.50 $200,080.31 $9,499,989.19 1 General $11,092,940.54 $108,244,111.29 $106,711,887.42 $12,625,164.41 102 Ambulance Fund $1,857,738.86 $1,877,911.67 $1,363,030.63 $2,372,619.90 103 Parks Capital $481,435.89 $224,819.82 $152,935.11 $553,320.60 106 Park Impact Fee Fund $1,109,243.77 $1,358,513.44 $203,258.19 $2,264,499.02 107 Hazardous Material Response Fund $29,780.17 $3,388.88 $0.00 $33,169.05 108 Parks Program Fund $1,483,030.81 $2,979,177.45 $2,745,346.91 $1,716,861.35 109 Parks Monon Fund $2,638,160.48 $4,607,952.54 $4,386,254.38 $2,859,858.64 110 Parks Facilities Fund $151,784.39 $162,042.76 $120,748.49 $193,078.66 176 ARP COVID LOCAL FIS REC $0.00 $3,769,666.29 $1,175,273.13 $2,594,393.16 201 Motor Vehicle Highway $6,640.35 $19,893,858.06 $17,580,070.87 $2,320,427.54 202 Local Road And Street $2,615,681.68 $2,538,956.51 $2,961,339.76 $2,193,298.43 203 Cumulative Capital Improvement $377,272.44 $188,299.41 $393,368.87 $172,202.98 204 Capital Lease Fund $467,118.06 $4,459,951.89 $3,392,570.80 $1,534,499.15 205 MVH-CRP $2,428,589.27 $1,922,432.53 $1,922,432.53 $2,428,589.27 206 Cumulative Capital Sewer $278,757.77 $0.00 $269,107.16 $9,650.61 209 Deferral Fund $230,446.43 $3,253.10 $48,765.17 $184,934.36 210 User Fee Fund $108,302.12 $78,393.12 $68,097.47 $118,597.77 211 Cumulative Captial Development $444,865.61 $4,367,332.30 $4,366,740.80 $445,457.11 212 Illinois St Construction Fund $204,059.36 $0.00 $204,059.36 $0.00 220 Barrett Law Fund $5.67 $0.00 $0.00 $5.67 221 Barrett Law Surplus $166,368.57 $0.00 $0.00 $166,368.57 252 MIHP Fund $9,421.33 $853.92 $1,746.56 $8,528.69 301 Health Insurance Fund $3,106,219.82 $14,548,639.24 $15,886,720.28 $1,768,138.78 302 Workers Comp Fund $727,278.43 $0.00 $254,043.36 $473,235.07 403 Lease Rental Fund $3,852.65 $0.00 $0.00 $3,852.65 Page 2Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Local Fund Number Local Fund Name Beg Cash & Inv Bal Jan. 1, 2021 Receipts Disbursement End Cash & Inv Bal Dec. 31, 2021 Governmental Activities 405 2004 Road Bond Fund $1,258,412.73 $1,927,244.87 $2,824,500.00 $361,157.60 406 2016 G.O. Bonds Debt Service $168,691.92 $1,473,512.08 $1,485,700.00 $156,504.00 450 Old Town/126Th Street $459.75 $0.00 $0.00 $459.75 501 Dnr/Tree City $71,190.66 $3,568.00 $0.00 $74,758.66 502 Clerk's Record Perpetuation $290,997.82 $27,321.63 $17,114.36 $301,205.09 503 Court Interperter Fund $64.24 $15.32 $0.00 $79.56 504 Support For The Arts $19,133.77 $0.00 $0.00 $19,133.77 505 Public Defenders Fund $11,822.93 $2,215.73 $6,000.00 $8,038.66 506 JUDICIAL SALARY FEES $116,573.75 $25,944.31 $43,025.03 $99,493.03 507 Historic Preservation Fund $190,920.63 $76,953.27 $58,307.50 $209,566.40 801 Police Pension Fund $136,915.60 $579,749.03 $586,617.05 $130,047.58 802 Fire Pension Fund $14,354.42 $598,437.90 $592,584.97 $20,207.35 851 Fire Gift Fund $26,740.20 $8,839.75 $11,430.23 $24,149.72 852 Police Gift $61,560.85 $184,099.73 $65,316.78 $180,343.80 853 Parks Gift Fund $37,585.55 $118,748.70 $49,396.52 $106,937.73 854 Community Relations Gift Fund $126,913.73 $190,329.22 $147,861.70 $169,381.25 855 Carmel Redev Gift - Dinner Fund $3,070.44 $9.33 $1,431.72 $1,648.05 856 Carmel Redev Gift-Marketing $36,853.82 $20,000.00 $26,000.22 $30,853.60 900 Grant Fund $720,271.32 $2,155,149.51 $2,021,480.26 $853,940.57 902 Redevelopment Commission $10,699,372.35 $44,308,559.01 $40,158,351.57 $14,849,579.79 903 Economic Fund $23,565.17 $30,000.00 $0.00 $53,565.17 904 Housing Authority $58,865.18 $0.00 $0.00 $58,865.18 911 Drug Task Force $550,621.79 $58,409.78 $189,030.95 $420,000.62 912 Rainy Day $11,289,262.62 $0.00 $0.00 $11,289,262.62 919 Throughfare Fund $1,394,868.18 $299,330.66 $0.00 $1,694,198.84 920 Keystone Ave Fund $137,845.27 $529.94 $0.00 $138,375.21 921 Non-Reverting Bicycle Facility $22,254.80 $9,363.72 $0.00 $31,618.52 922 Non-Reverting Center Green Ice Rink $620,577.93 $55,513.43 $238,216.95 $437,874.41 923 Non-Reverting Events & Festivals $31,035.91 $20,529.88 $24,900.00 $26,665.79 924 Non-Reverting Code Enforcement $30,883.63 $10,138.50 $0.00 $41,022.13 925 Non-Revt Sidewalk Program $50,000.00 $63.56 $19,676.85 $30,386.71 999 Levy Excess Fund $0.18 $0.00 $0.00 $0.18 SubTotal $62,519,435.34 $332,255,683.60 $288,460,230.05 $106,314,888.89 Page 3Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Local Fund Number Local Fund Name Beg Cash & Inv Bal Jan. 1, 2021 Receipts Disbursement End Cash & Inv Bal Dec. 31, 2021 WASTEWATER 0 Wastewater Bond & Interest At Bony $2,979,674.73 $1,817,044.32 $2,099,669.61 $2,697,049.44 00 Wastewater Construction Fund (BAN)$6,624,396.00 $431.30 $4,507,023.00 $2,117,804.30 651 Sewer Operating $1,000,374.70 $11,366,907.97 $10,473,852.61 $1,893,430.06 652 Sewer Depreciating $0.07 $208,943.00 $208,942.86 $0.21 653 Sewer Bond Sinking $0.00 $570,374.20 $85,934.58 $484,439.62 654 Sewer Construction Fund $0.00 $3,032,477.42 $1,201,758.07 $1,830,719.35 659 Sewer Connection Fund $249,525.63 $1,404,848.05 $536,456.51 $1,117,917.17 660 Sewer Availability Fund $14,822.66 $461,079.34 $475,734.05 $167.95 SubTotal $10,868,793.79 $18,862,105.60 $19,589,371.29 $10,141,528.10 WATER 601 Water Operating $2,060,496.11 $39,585,987.87 $39,289,746.84 $2,356,737.14 602 Hydrant Meter Deposit Fund $42,880.00 $0.00 $575.00 $42,305.00 604 Water Depreciation $0.92 $769,190.00 $764,364.90 $4,826.02 605 Water Bond & Interest $1,475,150.00 $32,844.00 $0.00 $1,507,994.00 606 Water Sinking Fund $1,000,829.04 $7,728,982.76 $7,717,293.69 $1,012,518.11 609 Water Connection $870,619.78 $4,175,574.25 $3,739,154.40 $1,307,039.63 610 Water Availability $270,951.63 $560,173.70 $593,292.24 $237,833.09 612 Water Construction Fund (BAN)$4,180,142.96 $5,110,090.71 $6,481,090.61 $2,809,143.06 SubTotal $9,901,070.44 $57,962,843.29 $58,585,517.68 $9,278,396.05 STORM WATER 0 Stormwater Bond Trustee Accounts $8,914,082.46 $33,751.41 $3,173,009.17 $5,774,824.70 250 Non Reverting Storm Water $1,415,398.44 $4,922,634.00 $4,632,149.67 $1,705,882.77 SubTotal $10,329,480.90 $4,956,385.41 $7,805,158.84 $7,480,707.47 GRAND TOTAL $93,618,780.47 $414,037,017.90 $374,440,277.86 $133,215,520.51 Page 4Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Detailed Receipts - 2021 Governmental Activities Carmel City Court Court Costs and Fees $1,146,704.88 Total Fines, Forfeitures, and Fees $1,146,704.88 Total Carmel City Court $1,146,704.88 Redev Commission Trust Accounts Earnings on Investments and Deposits $401.88 Proceeds from Borrowings other than Tax Anticipation Warrants $22,585,000.00 Other Receipts/360010 - Misc Revenue $3,840,582.31 Total Other Receipts $26,425,984.19 Total Redev Commission Trust Accounts $26,425,984.19 2016 GO Bonds Trustee Accounts Earnings on Investments and Deposits $1,604.64 Other Receipts/360010 - Other Cash Receipts $0.64 Total Other Receipts $1,605.28 Total 2016 GO Bonds Trustee Accounts $1,605.28 Payroll Fund Payroll Fund and Clearing Account Receipts $71,567,188.67 Total Other Receipts $71,567,188.67 Total Payroll Fund $71,567,188.67 2021 GO Bond Trustee Account Earnings on Investments and Deposits $69.50 Proceeds from Borrowings other than Tax Anticipation Warrants $9,700,000.00 Total Other Receipts $9,700,069.50 Total 2021 GO Bond Trustee Account $9,700,069.50 Page 5Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General General Property Taxes $41,832,811.44 Food and Beverage Tax $2,712,114.46 Casino/Riverboat Distribution $468,568.23 Cigarette Tax Distribution $51,354.38 Financial Institution Tax distribution $23,568.18 Vehicle/Aircraft Excise Tax Distribution $3,672,926.10 Commercial Vehicle Excise Tax Distribution (CVET)$16,934.88 ABC Gallonage Tax Distribution $291,502.90 Local Income Tax (LIT) Certified Shares $44,619,726.00 Local Income Tax (LIT) Supplemental Distribution $5,715,711.00 Federal and State Grants and Distributions - Other/333000 - Other Intergovermental Rev $197,415.10 Total Taxes and Intergovernmental $99,602,632.67 Planning, Zoning, and Building Permits and Fees $2,263,349.46 Other Licenses and Permits/321110 - Solicitor's License $1,436.00 Other Licenses and Permits/322000 - Alarm Permits $2,260.00 Other Licenses and Permits/322020 - Multi-Use Permits $946.00 Other Licenses and Permits/322023 - Small Cell Permits $1,200.00 Other Licenses and Permits/322030 - Traffic Location Permits $500.00 Total Licenses and Permits $2,269,691.46 Document and Copy Fees $2,297.97 Park and Recreation Receipts $1,258,541.10 Other Charges for Services, Sales, and Fees/349000 - Cell Phone Tower Rental $129,290.14 Total Charges for Services $1,390,129.21 Court Costs and Fees $292,964.50 Other Fines and Forfeitures/364000 - Cable TV Franchise Fees $759,020.75 Total Fines, Forfeitures, and Fees $1,051,985.25 Earnings on Investments and Deposits $127,172.33 Refunds and Reimbursements $701,549.34 Transfers In - Transferred from Another Fund $899,989.13 Other Receipts/360010 - Miscellaneous Revenues $2,200,961.90 Total Other Receipts $3,929,672.70 Total General $108,244,111.29 Page 6Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Ambulance Fund Emergency Medical Services Fees $1,869,626.35 Total Charges for Services $1,869,626.35 Earnings on Investments and Deposits $7,735.61 Refunds and Reimbursements $549.71 Total Other Receipts $8,285.32 Total Ambulance Fund $1,877,911.67 Parks Capital Earnings on Investments and Deposits $2,319.82 Transfers In - Transferred from Another Fund $222,500.00 Total Other Receipts $224,819.82 Total Parks Capital $224,819.82 Park Impact Fee Fund Other Fines and Forfeitures/323000 - Park Impact Fees $1,351,368.00 Total Fines, Forfeitures, and Fees $1,351,368.00 Earnings on Investments and Deposits $7,145.44 Total Other Receipts $7,145.44 Total Park Impact Fee Fund $1,358,513.44 Hazardous Material Response Fund Other Charges for Services, Sales, and Fees/342050 - Haz Nat Fees $3,267.45 Total Charges for Services $3,267.45 Earnings on Investments and Deposits $121.43 Total Other Receipts $121.43 Total Hazardous Material Response Fund $3,388.88 Parks Program Fund Park and Recreation Receipts $2,931,178.83 Total Charges for Services $2,931,178.83 Earnings on Investments and Deposits $6,568.03 Refunds and Reimbursements $100.00 Other Receipts/360010 - Miscellaneous Revenues $41,330.59 Total Other Receipts $47,998.62 Total Parks Program Fund $2,979,177.45 Page 7Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Parks Monon Fund Park and Recreation Receipts $4,487,001.13 Total Charges for Services $4,487,001.13 Earnings on Investments and Deposits $10,328.43 Proceeds from Tax Anticipation Warrants $16,542.22 Refunds and Reimbursements $15,400.00 Donations, Gifts, and Bequests $26,107.19 Other Receipts/360010 - Miscellaneous Revenue $52,573.57 Total Other Receipts $120,951.41 Total Parks Monon Fund $4,607,952.54 Parks Facilities Fund Park and Recreation Receipts $161,006.03 Total Charges for Services $161,006.03 Earnings on Investments and Deposits $626.73 Other Receipts/360010 - Miscellaneous Revenues $410.00 Total Other Receipts $1,036.73 Total Parks Facilities Fund $162,042.76 ARP COVID LOCAL FIS REC Other Taxes/333005 - Other Govermental Revenue $3,761,460.00 Total Taxes and Intergovernmental $3,761,460.00 Earnings on Investments and Deposits $8,206.29 Total Other Receipts $8,206.29 Total ARP COVID LOCAL FIS REC $3,769,666.29 Motor Vehicle Highway General Property Taxes $14,302,567.49 Financial Institution Tax distribution $8,047.13 Vehicle/Aircraft Excise Tax Distribution $1,254,084.14 Commercial Vehicle Excise Tax Distribution (CVET)$5,782.24 Federal and State Grants and Distributions - Highways and Streets $1,922,432.49 Total Taxes and Intergovernmental $17,492,913.49 Refunds and Reimbursements $253,096.66 Transfers In - Transferred from Another Fund $2,110,770.07 Other Receipts/360010 - Miscellaneous Revenue $37,077.84 Total Other Receipts $2,400,944.57 Total Motor Vehicle Highway $19,893,858.06 Page 8Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Local Road And Street Federal and State Grants and Distributions - Highways and Streets $2,538,304.82 Total Taxes and Intergovernmental $2,538,304.82 Refunds and Reimbursements $651.69 Total Other Receipts $651.69 Total Local Road And Street $2,538,956.51 Cumulative Capital Improvement Cigarette Tax Distribution $188,299.41 Total Taxes and Intergovernmental $188,299.41 Total Cumulative Capital Improvement $188,299.41 Capital Lease Fund Other Receipts/390000 - Other Financing Sources $4,459,951.89 Total Other Receipts $4,459,951.89 Total Capital Lease Fund $4,459,951.89 MVH-CRP Motor Vehicle Highway Distribution $1,922,432.53 Total Taxes and Intergovernmental $1,922,432.53 Total MVH-CRP $1,922,432.53 Deferral Fund Other Fines and Forfeitures/353080 - City Deferral Program $2,464.00 Total Fines, Forfeitures, and Fees $2,464.00 Earnings on Investments and Deposits $789.10 Total Other Receipts $789.10 Total Deferral Fund $3,253.10 User Fee Fund Gun Permits $26,480.00 Other Licenses and Permits/322022 - Golg Cart Permits $3,250.00 Total Licenses and Permits $29,730.00 Document and Copy Fees $18,566.00 Other Charges for Services, Sales, and Fees/343001 - Fingerprints $460.00 Total Charges for Services $19,026.00 Other Fines and Forfeitures/354000 - Law Enf Cont Ed Fees $24,012.12 Total Fines, Forfeitures, and Fees $24,012.12 Other Receipts/360010 - Miscellaneous Revenues $5,625.00 Total Other Receipts $5,625.00 Total User Fee Fund $78,393.12 Page 9Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Cumulative Captial Development General Property Taxes $4,011,776.10 Financial Institution Tax distribution $2,256.63 Vehicle/Aircraft Excise Tax Distribution $351,678.08 Commercial Vehicle Excise Tax Distribution (CVET)$1,621.49 Total Taxes and Intergovernmental $4,367,332.30 Total Cumulative Captial Development $4,367,332.30 MIHP Fund Earnings on Investments and Deposits $34.92 Donations, Gifts, and Bequests $819.00 Total Other Receipts $853.92 Total MIHP Fund $853.92 Health Insurance Fund Other Receipts/360010 - Miscellaneous Revenues $7,322.59 Other Receipts/391000 - Health Insurance Premium $14,424,187.31 Other Receipts/391010 - Medical FSA Contributions $76,245.74 Other Receipts/391020 - Dep Care Contributions $40,883.60 Total Other Receipts $14,548,639.24 Total Health Insurance Fund $14,548,639.24 2004 Road Bond Fund General Property Taxes $1,777,200.14 Financial Institution Tax distribution $952.29 Vehicle/Aircraft Excise Tax Distribution $148,408.17 Commercial Vehicle Excise Tax Distribution (CVET)$684.27 Total Taxes and Intergovernmental $1,927,244.87 Total 2004 Road Bond Fund $1,927,244.87 2016 G.O. Bonds Debt Service General Property Taxes $1,359,023.00 Financial Institution Tax distribution $726.63 Vehicle/Aircraft Excise Tax Distribution $113,240.33 Commercial Vehicle Excise Tax Distribution (CVET)$522.12 Total Taxes and Intergovernmental $1,473,512.08 Total 2016 G.O. Bonds Debt Service $1,473,512.08 Dnr/Tree City Other Receipts/360010 - Miscellaneous Revenues $3,568.00 Total Other Receipts $3,568.00 Total Dnr/Tree City $3,568.00 Clerk's Record Perpetuation Document and Copy Fees $27,321.63 Total Charges for Services $27,321.63 Total Clerk's Record Perpetuation $27,321.63 Page 10Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Court Interperter Fund Other Fines and Forfeitures/344050 - Interpreter Fees $15.00 Total Fines, Forfeitures, and Fees $15.00 Earnings on Investments and Deposits $0.32 Total Other Receipts $0.32 Total Court Interperter Fund $15.32 Public Defenders Fund Other Fines and Forfeitures/353095 - Public Defender Fees $2,215.73 Total Fines, Forfeitures, and Fees $2,215.73 Total Public Defenders Fund $2,215.73 JUDICIAL SALARY FEES Other Fines and Forfeitures/353090 - Judicial Salaries Fees $25,944.31 Total Fines, Forfeitures, and Fees $25,944.31 Total JUDICIAL SALARY FEES $25,944.31 Historic Preservation Fund Other Receipts/360010 - Miscellaneous Revenues $76,953.27 Total Other Receipts $76,953.27 Total Historic Preservation Fund $76,953.27 Police Pension Fund Federal and State Grants and Distributions - Other/335000 - State Shared Revenue $579,302.76 Total Taxes and Intergovernmental $579,302.76 Earnings on Investments and Deposits $446.27 Total Other Receipts $446.27 Total Police Pension Fund $579,749.03 Fire Pension Fund Federal and State Grants and Distributions - Other/335000 - State Shared Revenue $598,314.75 Total Taxes and Intergovernmental $598,314.75 Earnings on Investments and Deposits $123.15 Total Other Receipts $123.15 Total Fire Pension Fund $598,437.90 Fire Gift Fund Earnings on Investments and Deposits $93.75 Donations, Gifts, and Bequests $8,746.00 Total Other Receipts $8,839.75 Total Fire Gift Fund $8,839.75 Police Gift Earnings on Investments and Deposits $330.32 Donations, Gifts, and Bequests $183,769.41 Total Other Receipts $184,099.73 Total Police Gift $184,099.73 Page 11Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Parks Gift Fund Earnings on Investments and Deposits $284.38 Donations, Gifts, and Bequests $118,464.32 Total Other Receipts $118,748.70 Total Parks Gift Fund $118,748.70 Community Relations Gift Fund Earnings on Investments and Deposits $831.69 Donations, Gifts, and Bequests $186,711.29 Other Receipts/360010 - Miscellaneous Revenues $2,786.24 Total Other Receipts $190,329.22 Total Community Relations Gift Fund $190,329.22 Carmel Redev Gift - Dinner Fund Earnings on Investments and Deposits $9.33 Total Other Receipts $9.33 Total Carmel Redev Gift - Dinner Fund $9.33 Carmel Redev Gift-Marketing Donations, Gifts, and Bequests $20,000.00 Total Other Receipts $20,000.00 Total Carmel Redev Gift-Marketing $20,000.00 Grant Fund Federal and State Grants and Distributions - Other/333000 - Intergov Grant Rev $2,154,149.51 Total Taxes and Intergovernmental $2,154,149.51 Donations, Gifts, and Bequests $1,000.00 Total Other Receipts $1,000.00 Total Grant Fund $2,155,149.51 Redevelopment Commission Other Taxes/3120000 - Other Taxes -TIF $36,979,700.84 Total Taxes and Intergovernmental $36,979,700.84 Other Licenses and Permits/323000 - Permits - PRIF $925,454.00 Total Licenses and Permits $925,454.00 Other Receipts/353051 - Bond Admin Fees $3,838.20 Other Receipts/360010 - Miscellaneous Revenues $1,250,000.00 Other Receipts/362000 - Rental Property Income $414,550.46 Other Receipts/392040 - Payment in Lieu of Taxes $294,000.00 Other Receipts/392050 - Pmt in Addition to Taxes $1,614,087.00 Other Receipts/393000 - Redev Project Sources $977,860.08 Other Receipts/396020 - Other Reimbursements $1,849,068.43 Total Other Receipts $6,403,404.17 Total Redevelopment Commission $44,308,559.01 Page 12Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Economic Fund Other Receipts/396020 - Other Reimbursements $30,000.00 Total Other Receipts $30,000.00 Total Economic Fund $30,000.00 Drug Task Force Other Taxes/333000 - Other Intergovernmental Rev $13,628.99 Total Taxes and Intergovernmental $13,628.99 Earnings on Investments and Deposits $1,791.97 Other Receipts/360010 - Miscellaneous Revenues $42,988.82 Total Other Receipts $44,780.79 Total Drug Task Force $58,409.78 Throughfare Fund Earnings on Investments and Deposits $5,821.38 Other Receipts/368010 - NW Development Area $74,085.00 Other Receipts/368020 - SW Development Area $80,000.00 Other Receipts/368030 - NE Development Area $82,887.00 Other Receipts/368040 - SE Development Area $56,537.28 Total Other Receipts $299,330.66 Total Throughfare Fund $299,330.66 Keystone Ave Fund Earnings on Investments and Deposits $529.94 Total Other Receipts $529.94 Total Keystone Ave Fund $529.94 Non-Reverting Bicycle Facility Earnings on Investments and Deposits $101.07 Other Receipts/360010 - Miscelleous Revenues $9,262.65 Total Other Receipts $9,363.72 Total Non-Reverting Bicycle Facility $9,363.72 Non-Reverting Center Green Ice Rink Earnings on Investments and Deposits $2,071.66 Other Receipts/360010 - Miscellaneous Revenue $53,441.77 Total Other Receipts $55,513.43 Total Non-Reverting Center Green Ice Rink $55,513.43 Page 13Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Non-Reverting Events & Festivals Earnings on Investments and Deposits $117.27 Refunds and Reimbursements $12,817.50 Donations, Gifts, and Bequests $5,788.90 Other Receipts/360010 - Miscellaneous Revenue $1,806.21 Total Other Receipts $20,529.88 Total Non-Reverting Events & Festivals $20,529.88 Non-Reverting Code Enforcement Earnings on Investments and Deposits $138.50 Other Receipts/360010 - Miscellaneous Revenue $10,000.00 Total Other Receipts $10,138.50 Total Non-Reverting Code Enforcement $10,138.50 Non-Revt Sidewalk Program Earnings on Investments and Deposits $63.56 Total Other Receipts $63.56 Total Non-Revt Sidewalk Program $63.56 Total Governmental Activities $332,255,683.60 WASTEWATER Wastewater Bond & Interest At Bony Earnings on Investments and Deposits $276.32 Other Receipts/396020 - Misc-Bond Payments $1,816,768.00 Total Other Receipts $1,817,044.32 Total Wastewater Bond & Interest At Bony $1,817,044.32 Wastewater Construction Fund (BAN)Earnings on Investments and Deposits $431.30 Total Other Receipts $431.30 Total Wastewater Construction Fund (BAN) $431.30 Sewer Operating Sewage Fees $2,021,512.74 Total Charges for Services $2,021,512.74 Earnings on Investments and Deposits $7,499.73 Transfers In - Transferred from Another Fund $9,288,305.61 Other Receipts/360010 - Misc Revenue $49,589.89 Total Other Receipts $9,345,395.23 Total Sewer Operating $11,366,907.97 Sewer Depreciating Transfers In - Transferred from Another Fund $192,342.00 Other Receipts/360010 - Misc Revenue $16,601.00 Total Other Receipts $208,943.00 Total Sewer Depreciating $208,943.00 Page 14Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org WASTEWATER Sewer Bond Sinking Earnings on Investments and Deposits $894.20 Transfers In - Transferred from Another Fund $569,480.00 Total Other Receipts $570,374.20 Total Sewer Bond Sinking $570,374.20 Sewer Construction Fund Earnings on Investments and Deposits $8,977.42 Other Receipts/360010 - Misc Revenue $3,023,500.00 Total Other Receipts $3,032,477.42 Total Sewer Construction Fund $3,032,477.42 Sewer Connection Fund Earnings on Investments and Deposits $2,360.62 Other Receipts/348230 - Connection Fees $1,402,487.43 Total Other Receipts $1,404,848.05 Total Sewer Connection Fund $1,404,848.05 Sewer Availability Fund Earnings on Investments and Deposits $15.16 Transfers In - Transferred from Another Fund $304,890.00 Other Receipts/348240 - Availablity Fees $156,174.18 Total Other Receipts $461,079.34 Total Sewer Availability Fund $461,079.34 Total WASTEWATER $18,862,105.60 WATER Water Operating Rental of Property $75,754.40 Metered or Measured Sales and Services $20,438,363.05 Total Charges for Services $20,514,117.45 Earnings on Investments and Deposits $5,866.42 Transfers In - Transferred from Another Fund $575.00 Other Receipts/360010 - Other Revenue $95,235.29 Other Receipts/360010 - User Fees - Sewer Collected $9,237,223.33 Other Receipts/360010 - User Fees - Stormwater Collected $3,993,084.50 Other Receipts/360010 - User Fees - Tax Collected $1,292,149.88 Other Receipts/360010 - User Fees - Trash Collected $4,419,609.99 Other Receipts/396020 - Other Revenue $28,126.01 Total Other Receipts $19,071,870.42 Total Water Operating $39,585,987.87 Water Depreciation Transfers In - Transferred from Another Fund $729,838.00 Other Receipts/360010 - Misc Revenue $39,352.00 Total Other Receipts $769,190.00 Total Water Depreciation $769,190.00 Page 15Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org WATER Water Bond & Interest Transfers In - Transferred from Another Fund $32,844.00 Total Other Receipts $32,844.00 Total Water Bond & Interest $32,844.00 Water Sinking Fund Earnings on Investments and Deposits $3,676.47 Transfers In - Transferred from Another Fund $7,712,510.00 Other Receipts/360010 - Misc Revenue $12,796.29 Total Other Receipts $7,728,982.76 Total Water Sinking Fund $7,728,982.76 Water Connection Earnings on Investments and Deposits $2,927.10 Transfers In - Transferred from Another Fund $3,425.61 Other Receipts/348230 - Connection Fees $4,169,221.54 Total Other Receipts $4,175,574.25 Total Water Connection $4,175,574.25 Water Availability Earnings on Investments and Deposits $549.25 Transfers In - Transferred from Another Fund $11,301.26 Other Receipts/348240 - Availability Fees $548,323.19 Total Other Receipts $560,173.70 Total Water Availability $560,173.70 Water Construction Fund (BAN)Earnings on Investments and Deposits $79,090.71 Other Receipts/360010 - Misc Revenue $5,031,000.00 Total Other Receipts $5,110,090.71 Total Water Construction Fund (BAN)$5,110,090.71 Total WATER $57,962,843.29 STORM WATER Stormwater Bond Trustee Accounts Earnings on Investments and Deposits $33,751.41 Total Other Receipts $33,751.41 Total Stormwater Bond Trustee Accounts $33,751.41 Non Reverting Storm Water Transfers In - Transferred from Another Fund $438,815.01 Other Receipts/360010 - Miscellaneous Revenues $4,483,818.99 Total Other Receipts $4,922,634.00 Total Non Reverting Storm Water $4,922,634.00 Total STORM WATER $4,956,385.41 Page 16Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Disbursements by Fund - 2021 Governmental Activities Carmel City Court Other Disbursements $1,171,997.99 Total Other Disbursements $1,171,997.99 Total Carmel City Court $1,171,997.99 Payroll Fund Other Disbursements $71,567,188.67 Total Other Disbursements $71,567,188.67 Total Payroll Fund $71,567,188.67 Redev Commission Trust Accounts Professional Services $7,271.84 Total Services and Charges $7,271.84 Payments on Bonds and Other Debt Principal $1,545,000.00 Payments on Bonds and Other Debt Interest $1,009,553.49 Total Debt service - principal and interest $2,554,553.49 Construction $40,091.90 Total Capital Outlays $40,091.90 Other Disbursements $703.01 Total Other Disbursements $703.01 Total Redev Commission Trust Accounts $2,602,620.24 2016 GO Bonds Trustee Accounts Professional Services $4,950.00 Total Services and Charges $4,950.00 Page 17Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities 2016 GO Bonds Trustee Accounts Construction $138,652.93 Total Capital Outlays $138,652.93 Total 2016 GO Bonds Trustee Accounts $143,602.93 2021 GO Bond Trustee Account Construction $200,080.31 Total Capital Outlays $200,080.31 Total 2021 GO Bond Trustee Account $200,080.31 General Salaries and Wages $43,432,044.67 Employee Benefits $20,513,376.85 Total Personal Services $63,945,421.52 Office Supplies $90,148.53 Operating Supplies $522,261.98 Repair and Maintenance Supplies $335,709.86 Other Supplies $426,653.27 Total Supplies $1,374,773.64 Professional Services $3,222,333.07 Communication and Transportation $499,250.46 Printing and Advertising $187,091.87 Insurance $1,610,908.38 Utility Services $1,441,293.28 Repairs and Maintenance $6,112,000.10 Rentals $404,933.24 Other Services and Charges $7,753,882.32 Total Services and Charges $21,231,692.72 Payments on Bonds and Other Debt Principal $7,748,458.00 Page 18Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Payments on Bonds and Other Debt Interest $8,457,649.18 Total Debt service - principal and interest $16,206,107.18 Infrastructure $154,565.80 Improvements Other Than Buildings $21,668.70 Machinery, Equipment, and Vehicles $3,361,148.19 Books and Other Media $8,095.36 Other Capital Outlays $55,676.71 Total Capital Outlays $3,601,154.76 Transfer Out - Transferred To Another Fund $222,500.00 Other Disbursements $130,237.60 Total Other Disbursements $352,737.60 Total General $106,711,887.42 Ambulance Fund Other Supplies $154,081.02 Total Supplies $154,081.02 Machinery, Equipment, and Vehicles $1,075,160.33 Other Capital Outlays $128,287.19 Total Capital Outlays $1,203,447.52 Other Disbursements $5,502.09 Total Other Disbursements $5,502.09 Total Ambulance Fund $1,363,030.63 Parks Capital Improvements Other Than Buildings $147,276.01 Other Capital Outlays $1,673.10 Total Capital Outlays $148,949.11 Other Disbursements $3,986.00 Total Other Disbursements $3,986.00 Total Parks Capital $152,935.11 Page 19Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Park Impact Fee Fund Professional Services $1,642.50 Total Services and Charges $1,642.50 Land $159,044.81 Improvements Other Than Buildings $42,570.88 Total Capital Outlays $201,615.69 Total Park Impact Fee Fund $203,258.19 Parks Program Fund Salaries and Wages $1,502,612.88 Employee Benefits $512,044.19 Total Personal Services $2,014,657.07 Office Supplies $5,461.29 Operating Supplies $91,037.10 Total Supplies $96,498.39 Professional Services $317,035.63 Communication and Transportation $153,110.02 Printing and Advertising $11,295.62 Repairs and Maintenance $13,570.15 Rentals $2,462.19 Other Services and Charges $134,079.16 Total Services and Charges $631,552.77 Other Capital Outlays $2,638.68 Total Capital Outlays $2,638.68 Total Parks Program Fund $2,745,346.91 Parks Monon Fund Salaries and Wages $1,588,508.40 Employee Benefits $430,599.43 Total Personal Services $2,019,107.83 Office Supplies $5,739.17 Operating Supplies $215,627.44 Page 20Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Parks Monon Fund Other Supplies $142,387.89 Total Supplies $363,754.50 Professional Services $455,010.86 Communication and Transportation $7,755.58 Printing and Advertising $8,463.62 Insurance $134,370.43 Utility Services $700,335.29 Repairs and Maintenance $547,220.67 Rentals $10,486.69 Other Services and Charges $104,215.17 Total Services and Charges $1,967,858.31 Machinery, Equipment, and Vehicles $20,133.74 Other Capital Outlays $15,400.00 Total Capital Outlays $35,533.74 Total Parks Monon Fund $4,386,254.38 Parks Facilities Fund Repair and Maintenance Supplies $10,306.15 Total Supplies $10,306.15 Professional Services $7,522.39 Communication and Transportation $3,184.64 Insurance $5,410.83 Utility Services $31,575.40 Repairs and Maintenance $62,749.08 Total Services and Charges $110,442.34 Total Parks Facilities Fund $120,748.49 ARP COVID LOCAL FIS REC Salaries and Wages $939,515.79 Employee Benefits $130,069.34 Total Personal Services $1,069,585.13 Page 21Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities ARP COVID LOCAL FIS REC Infrastructure $105,688.00 Total Capital Outlays $105,688.00 Total ARP COVID LOCAL FIS REC $1,175,273.13 Motor Vehicle Highway Salaries and Wages $5,196,493.95 Employee Benefits $2,616,267.57 Total Personal Services $7,812,761.52 Office Supplies $5,736.43 Operating Supplies $211,149.65 Repair and Maintenance Supplies $1,258,571.33 Other Supplies $199,703.81 Total Supplies $1,675,161.22 Professional Services $361,130.92 Communication and Transportation $48,224.93 Printing and Advertising $417.37 Utility Services $444,418.36 Repairs and Maintenance $5,763,240.24 Rentals $102,432.35 Other Services and Charges $75,563.71 Total Services and Charges $6,795,427.88 Machinery, Equipment, and Vehicles $1,296,720.25 Total Capital Outlays $1,296,720.25 Total Motor Vehicle Highway $17,580,070.87 Local Road And Street Professional Services $646,491.55 Repairs and Maintenance $770,397.21 Total Services and Charges $1,416,888.76 Payments on Bonds and Other Debt Principal $418,500.00 Page 22Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Local Road And Street Payments on Bonds and Other Debt Interest $1,125,951.00 Total Debt service - principal and interest $1,544,451.00 Total Local Road And Street $2,961,339.76 Cumulative Capital Improvement Professional Services $293,424.87 Total Services and Charges $293,424.87 Improvements Other Than Buildings $99,944.00 Total Capital Outlays $99,944.00 Total Cumulative Capital Improvement $393,368.87 Capital Lease Fund Other Disbursements $3,392,570.80 Total Other Disbursements $3,392,570.80 Total Capital Lease Fund $3,392,570.80 MVH-CRP Repairs and Maintenance $1,922,432.53 Total Services and Charges $1,922,432.53 Total MVH-CRP $1,922,432.53 Cumulative Capital Sewer Repairs and Maintenance $269,107.16 Total Services and Charges $269,107.16 Total Cumulative Capital Sewer $269,107.16 Deferral Fund Salaries and Wages $29,290.89 Employee Benefits $6,471.49 Total Personal Services $35,762.38 Office Supplies $38.87 Total Supplies $38.87 Page 23Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Deferral Fund Communication and Transportation $5,237.20 Rentals $2,218.72 Total Services and Charges $7,455.92 Books and Other Media $5,508.00 Total Capital Outlays $5,508.00 Total Deferral Fund $48,765.17 User Fee Fund Other Services and Charges $1,644.47 Total Services and Charges $1,644.47 Other Disbursements $66,453.00 Total Other Disbursements $66,453.00 Total User Fee Fund $68,097.47 Cumulative Captial Development Professional Services $182,747.80 Total Services and Charges $182,747.80 Payments on Bonds and Other Debt Principal $3,074,700.00 Payments on Bonds and Other Debt Interest $1,109,293.00 Total Debt service - principal and interest $4,183,993.00 Total Cumulative Captial Development $4,366,740.80 Illinois St Construction Fund Transfer Out - Transferred To Another Fund $204,059.36 Total Other Disbursements $204,059.36 Total Illinois St Construction Fund $204,059.36 MIHP Fund Other Disbursements $1,746.56 Total Other Disbursements $1,746.56 Total MIHP Fund $1,746.56 Page 24Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Health Insurance Fund Other Disbursements $15,886,720.28 Total Other Disbursements $15,886,720.28 Total Health Insurance Fund $15,886,720.28 Workers Comp Fund Other Disbursements $254,043.36 Total Other Disbursements $254,043.36 Total Workers Comp Fund $254,043.36 2004 Road Bond Fund Payments on Bonds and Other Debt Principal $2,404,750.00 Payments on Bonds and Other Debt Interest $419,750.00 Total Debt service - principal and interest $2,824,500.00 Total 2004 Road Bond Fund $2,824,500.00 2016 G.O. Bonds Debt Service Payments on Bonds and Other Debt Principal $744,000.00 Payments on Bonds and Other Debt Interest $741,700.00 Total Debt service - principal and interest $1,485,700.00 Total 2016 G.O. Bonds Debt Service $1,485,700.00 Clerk's Record Perpetuation Office Supplies $1,070.93 Total Supplies $1,070.93 Professional Services $2,660.51 Repairs and Maintenance $1,998.10 Total Services and Charges $4,658.61 Other Capital Outlays $11,384.82 Total Capital Outlays $11,384.82 Total Clerk's Record Perpetuation $17,114.36 Page 25Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Public Defenders Fund Professional Services $6,000.00 Total Services and Charges $6,000.00 Total Public Defenders Fund $6,000.00 JUDICIAL SALARY FEES Office Supplies $2,355.42 Other Supplies $287.87 Total Supplies $2,643.29 Professional Services $30,951.92 Communication and Transportation $1,865.97 Insurance $75.00 Repairs and Maintenance $826.84 Rentals $1,648.00 Total Services and Charges $35,367.73 Machinery, Equipment, and Vehicles $5,014.01 Total Capital Outlays $5,014.01 Total JUDICIAL SALARY FEES $43,025.03 Historic Preservation Fund Professional Services $41,607.50 Repairs and Maintenance $12,700.00 Other Services and Charges $4,000.00 Total Services and Charges $58,307.50 Total Historic Preservation Fund $58,307.50 Police Pension Fund Salaries and Wages $1,699.88 Other Personal Services $584,787.17 Employee Benefits $130.00 Total Personal Services $586,617.05 Total Police Pension Fund $586,617.05 Page 26Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Fire Pension Fund Salaries and Wages $2,753.92 Other Personal Services $589,620.19 Employee Benefits $210.86 Total Personal Services $592,584.97 Total Fire Pension Fund $592,584.97 Fire Gift Fund Other Disbursements $11,430.23 Total Other Disbursements $11,430.23 Total Fire Gift Fund $11,430.23 Police Gift Other Disbursements $65,316.78 Total Other Disbursements $65,316.78 Total Police Gift $65,316.78 Parks Gift Fund Other Disbursements $49,396.52 Total Other Disbursements $49,396.52 Total Parks Gift Fund $49,396.52 Community Relations Gift Fund Other Supplies $699.00 Total Supplies $699.00 Other Services and Charges $117,162.70 Total Services and Charges $117,162.70 Other Disbursements $30,000.00 Total Other Disbursements $30,000.00 Total Community Relations Gift Fund $147,861.70 Carmel Redev Gift - Dinner Fund Other Disbursements $1,431.72 Total Other Disbursements $1,431.72 Total Carmel Redev Gift - Dinner Fund $1,431.72 Page 27Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Carmel Redev Gift- Marketing Other Services and Charges $26,000.22 Total Services and Charges $26,000.22 Total Carmel Redev Gift-Marketing $26,000.22 Grant Fund Other Services and Charges $53,594.82 Total Services and Charges $53,594.82 Transfer Out - Transferred To Another Fund $1,820,957.05 Other Disbursements $146,928.39 Total Other Disbursements $1,967,885.44 Total Grant Fund $2,021,480.26 Redevelopment Commission Other Supplies $300,000.00 Total Supplies $300,000.00 Professional Services $1,704,272.21 Total Services and Charges $1,704,272.21 Payments on Bonds and Other Debt Principal $19,994,811.68 Payments on Bonds and Other Debt Interest $7,486,295.04 Total Debt service - principal and interest $27,481,106.72 Improvements Other Than Buildings $603,443.82 Total Capital Outlays $603,443.82 Transfer Out - Transferred To Another Fund $527,794.00 Other Disbursements $9,541,734.82 Total Other Disbursements $10,069,528.82 Total Redevelopment Commission $40,158,351.57 Drug Task Force Office Supplies $2,078.33 Page 28Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Drug Task Force Operating Supplies $187.41 Other Supplies $813.30 Total Supplies $3,079.04 Communication and Transportation $3,492.77 Utility Services $20,145.43 Repairs and Maintenance $5,343.34 Rentals $115,234.18 Other Services and Charges $40,714.72 Total Services and Charges $184,930.44 Other Capital Outlays $1,021.47 Total Capital Outlays $1,021.47 Total Drug Task Force $189,030.95 Non-Reverting Center Green Ice Rink Other Services and Charges $51,216.95 Total Services and Charges $51,216.95 Improvements Other Than Buildings $187,000.00 Total Capital Outlays $187,000.00 Total Non-Reverting Center Green Ice Rink $238,216.95 Non-Reverting Events & Festivals Other Capital Outlays $24,900.00 Total Capital Outlays $24,900.00 Total Non-Reverting Events & Festivals $24,900.00 Non-Revt Sidewalk Program Other Disbursements $19,676.85 Total Other Disbursements $19,676.85 Total Non-Revt Sidewalk Program $19,676.85 Total Governmental Activities $288,460,230.05 WASTEWATER Wastewater Bond & Interest At Bony Payments on Bonds and Other Debt Principal $1,401,260.00 Page 29Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org WASTEWATER Wastewater Bond & Interest At Bony Payments on Bonds and Other Debt Interest $698,409.61 Total Debt service - principal and interest $2,099,669.61 Total Wastewater Bond & Interest At Bony $2,099,669.61 Wastewater Construction Fund (BAN) Construction $4,507,023.00 Total Capital Outlays $4,507,023.00 Total Wastewater Construction Fund (BAN)$4,507,023.00 Sewer Operating Salaries and Wages $3,431,665.22 Employee Benefits $1,635,434.58 Total Personal Services $5,067,099.80 Insurance $96,019.00 Total Services and Charges $96,019.00 Transfer Out - Transferred To Another Fund $986,712.00 Other Disbursements $2,297,511.19 Total Other Disbursements $3,284,223.19 Chemicals $197,788.09 Contractual Services $525,923.16 Materials and Supplies $419,002.25 Power Production\Purchased Power $367,735.68 Sludge Removal $34,385.00 Transportation $71,211.07 Other Operating $410,465.37 Total Operations $2,026,510.62 Total Sewer Operating $10,473,852.61 Page 30Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org WASTEWATER Sewer Depreciating Construction $208,942.86 Total Capital Outlays $208,942.86 Total Sewer Depreciating $208,942.86 Sewer Bond Sinking Payments on Bonds and Other Debt Interest $85,934.58 Total Debt service - principal and interest $85,934.58 Total Sewer Bond Sinking $85,934.58 Sewer Construction Fund Construction $1,201,758.07 Total Capital Outlays $1,201,758.07 Total Sewer Construction Fund $1,201,758.07 Sewer Connection Fund Construction $456,456.51 Total Capital Outlays $456,456.51 Transfer Out - Transferred To Another Fund $80,000.00 Total Other Disbursements $80,000.00 Total Sewer Connection Fund $536,456.51 Sewer Availability Fund Construction $475,734.05 Total Capital Outlays $475,734.05 Total Sewer Availability Fund $475,734.05 Total WASTEWATER $19,589,371.29 WATER Water Operating Salaries and Wages $4,491,886.54 Employee Benefits $2,244,957.45 Total Personal Services $6,736,843.99 Insurance $137,746.00 Total Services and Charges $137,746.00 Page 31Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org WATER Water Operating Transfer Out - Transferred To Another Fund $17,038,224.48 Other Disbursements $10,897,558.96 Total Other Disbursements $27,935,783.44 Chemicals $847,471.29 Contractual Services $996,208.71 Materials and Supplies $694,976.02 Power Production\Purchased Power $1,334,531.16 Purchased Water $192,651.49 Transportation $149,598.26 Other Operating $263,936.48 Total Operations $4,479,373.41 Total Water Operating $39,289,746.84 Hydrant Meter Deposit Fund Transfer Out - Transferred To Another Fund $575.00 Total Other Disbursements $575.00 Total Hydrant Meter Deposit Fund $575.00 Water Depreciation Construction $764,364.90 Total Capital Outlays $764,364.90 Total Water Depreciation $764,364.90 Water Sinking Fund Payments on Bonds and Other Debt Principal $4,070,000.00 Payments on Bonds and Other Debt Interest $3,647,293.69 Total Debt service - principal and interest $7,717,293.69 Total Water Sinking Fund $7,717,293.69 Water Connection Construction $2,999,154.40 Total Capital Outlays $2,999,154.40 Transfer Out - Transferred To Another Fund $740,000.00 Total Other Disbursements $740,000.00 Total Water Connection $3,739,154.40 Page 32Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org WATER Water Availability Construction $593,292.24 Total Capital Outlays $593,292.24 Total Water Availability $593,292.24 Water Construction Fund (BAN) Construction $6,481,090.61 Total Capital Outlays $6,481,090.61 Total Water Construction Fund (BAN)$6,481,090.61 Total WATER $58,585,517.68 STORM WATER Stormwater Bond Trustee Accounts Construction $3,168,593.87 Total Capital Outlays $3,168,593.87 Other Disbursements $4,415.30 Total Other Disbursements $4,415.30 Total Stormwater Bond Trustee Accounts $3,173,009.17 Non Reverting Storm Water Transfer Out - Transferred To Another Fund $896,763.80 Other Disbursements $2,939,910.00 Total Other Disbursements $3,836,673.80 Other Operating $795,475.87 Total Operations $795,475.87 Total Non Reverting Storm Water $4,632,149.67 Total STORM WATER $7,805,158.84 Page 33Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Disbursements by Fund with Departments - 2021 Governmental Activities General No Department Other Disbursements $104,115.09 Total Other Disbursements $104,115.09 Total No Department $104,115.09 Controller Salaries and Wages $577,719.11 Employee Benefits $234,487.22 Total Personal Services $812,206.33 Office Supplies $4,039.31 Other Supplies $431.39 Total Supplies $4,470.70 Professional Services $93,757.08 Communication and Transportation $9,525.02 Insurance $600.00 Repairs and Maintenance $49,877.74 Rentals $6,281.61 Other Services and Charges $3,502.34 Total Services and Charges $163,543.79 Machinery, Equipment, and Vehicles $3,598.98 Total Capital Outlays $3,598.98 Total Controller $983,819.80 Page 34Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Clerk (Clerk/Treasurer)Salaries and Wages $410,843.51 Employee Benefits $174,479.88 Total Personal Services $585,323.39 Office Supplies $4,440.25 Operating Supplies $113.45 Total Supplies $4,553.70 Professional Services $8,119.54 Communication and Transportation $1,966.62 Printing and Advertising $2,098.83 Repairs and Maintenance $5,117.92 Other Services and Charges $9,866.38 Total Services and Charges $27,169.29 Machinery, Equipment, and Vehicles $9,265.30 Total Capital Outlays $9,265.30 Total Clerk (Clerk/Treasurer)$626,311.68 Mayor Salaries and Wages $304,287.49 Employee Benefits $131,098.29 Total Personal Services $435,385.78 Office Supplies $2,626.10 Other Supplies $2,042.52 Total Supplies $4,668.62 Professional Services $487,253.05 Communication and Transportation $2,455.15 Repairs and Maintenance $713.59 Rentals $13,642.69 Page 35Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Mayor Other Services and Charges $3,673,348.13 Total Services and Charges $4,177,412.61 Other Capital Outlays $28,463.97 Total Capital Outlays $28,463.97 Total Mayor $4,645,930.98 Board Of Public Works & Safety Salaries and Wages $14,003.60 Employee Benefits $1,071.20 Total Personal Services $15,074.80 Payments on Bonds and Other Debt Principal $7,748,458.00 Payments on Bonds and Other Debt Interest $8,457,649.18 Total Debt service - principal and interest $16,206,107.18 Total Board Of Public Works & Safety $16,221,181.98 Administration Salaries and Wages $321,253.74 Employee Benefits $123,160.85 Total Personal Services $444,414.59 Office Supplies $2,394.41 Operating Supplies $6,667.87 Repair and Maintenance Supplies $39,109.70 Other Supplies $1,732.41 Total Supplies $49,904.39 Communication and Transportation $3,737.08 Page 36Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Administration Insurance $1,564,503.46 Utility Services $77,737.43 Repairs and Maintenance $238,315.26 Rentals $6,498.96 Other Services and Charges $220,388.70 Total Services and Charges $2,111,180.89 Improvements Other Than Buildings $21,668.70 Machinery, Equipment, and Vehicles $670,055.53 Total Capital Outlays $691,724.23 Total Administration $3,297,224.10 Personnel Salaries and Wages $431,036.21 Employee Benefits $176,383.04 Total Personal Services $607,419.25 Office Supplies $27.87 Total Supplies $27.87 Professional Services $48,791.77 Communication and Transportation $4,280.80 Printing and Advertising $9,495.76 Repairs and Maintenance $3,338.64 Other Services and Charges $65,054.90 Total Services and Charges $130,961.87 Other Capital Outlays $1,514.00 Total Capital Outlays $1,514.00 Total Personnel $739,922.99 Page 37Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General City/Town Court (City Judge/Judge)Salaries and Wages $393,175.36 Employee Benefits $126,240.64 Total Personal Services $519,416.00 Communication and Transportation $1,000.00 Utility Services $19,973.02 Repairs and Maintenance $10,452.18 Rentals $58,360.52 Total Services and Charges $89,785.72 Other Capital Outlays $6,768.50 Total Capital Outlays $6,768.50 Total City/Town Court (City Judge/Judge)$615,970.22 Law Department Salaries and Wages $547,226.24 Employee Benefits $246,073.72 Total Personal Services $793,299.96 Office Supplies $6,565.08 Total Supplies $6,565.08 Professional Services $369,430.11 Communication and Transportation $12,223.52 Repairs and Maintenance $3,700.00 Rentals $6,925.88 Other Services and Charges $7,081.51 Total Services and Charges $399,361.02 Machinery, Equipment, and Vehicles $54,272.03 Page 38Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Law Department Books and Other Media $8,095.36 Total Capital Outlays $62,367.39 Total Law Department $1,261,593.45 Community Services Salaries and Wages $1,822,392.34 Employee Benefits $869,427.40 Total Personal Services $2,691,819.74 Office Supplies $9,283.53 Operating Supplies $14,225.44 Repair and Maintenance Supplies $4,847.42 Other Supplies $12,908.39 Total Supplies $41,264.78 Professional Services $279,509.29 Communication and Transportation $45,694.69 Printing and Advertising $6,232.60 Repairs and Maintenance $415,920.57 Rentals $16,231.36 Other Services and Charges $129,844.12 Total Services and Charges $893,432.63 Infrastructure $154,565.80 Machinery, Equipment, and Vehicles $268,958.65 Total Capital Outlays $423,524.45 Page 39Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Community Services Other Disbursements $19,202.01 Total Other Disbursements $19,202.01 Total Community Services $4,069,243.61 Communications Department (Radio-Phones-Dispatch)Salaries and Wages $1,377,140.31 Employee Benefits $640,389.38 Total Personal Services $2,017,529.69 Office Supplies $5,870.19 Operating Supplies $9,043.76 Repair and Maintenance Supplies $25,870.85 Other Supplies $4,122.07 Total Supplies $44,906.87 Professional Services $294,286.59 Communication and Transportation $87,690.98 Utility Services $25,293.25 Repairs and Maintenance $526,600.75 Other Services and Charges $613,486.03 Total Services and Charges $1,547,357.60 Machinery, Equipment, and Vehicles $490,426.94 Other Capital Outlays $12,204.54 Total Capital Outlays $502,631.48 Total Communications Department (Radio-Phones-Dispatch)$4,112,425.64 Page 40Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Public Affairs Salaries and Wages $727,719.45 Employee Benefits $273,415.22 Total Personal Services $1,001,134.67 Office Supplies $2,475.69 Other Supplies $35.90 Total Supplies $2,511.59 Professional Services $556,056.83 Communication and Transportation $54,568.41 Printing and Advertising $135,514.19 Repairs and Maintenance $60,717.33 Rentals $44,031.69 Other Services and Charges $1,959,116.52 Total Services and Charges $2,810,004.97 Machinery, Equipment, and Vehicles $22,072.62 Total Capital Outlays $22,072.62 Total Public Affairs $3,835,723.85 Fire Department Salaries and Wages $19,263,943.30 Employee Benefits $8,904,316.83 Total Personal Services $28,168,260.13 Office Supplies $14,855.75 Operating Supplies $143,929.48 Repair and Maintenance Supplies $114,059.43 Other Supplies $57,873.72 Total Supplies $330,718.38 Professional Services $222,055.47 Page 41Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Fire Department Communication and Transportation $35,043.47 Printing and Advertising $2,670.83 Insurance $11,351.18 Utility Services $312,593.33 Repairs and Maintenance $829,794.09 Rentals $102,347.14 Other Services and Charges $372,203.92 Total Services and Charges $1,888,059.43 Total Fire Department $30,387,037.94 Police Department (Town Marshall)Salaries and Wages $14,154,613.52 Employee Benefits $7,191,547.64 Total Personal Services $21,346,161.16 Office Supplies $17,673.68 Operating Supplies $308,085.81 Repair and Maintenance Supplies $43,384.72 Other Supplies $220,252.87 Total Supplies $589,397.08 Professional Services $275,653.47 Communication and Transportation $47,291.61 Printing and Advertising $7,682.84 Utility Services $246,838.58 Repairs and Maintenance $262,694.86 Rentals $100,095.49 Other Services and Charges $466,702.68 Total Services and Charges $1,406,959.53 Page 42Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Police Department (Town Marshall)Machinery, Equipment, and Vehicles $1,600,766.77 Total Capital Outlays $1,600,766.77 Total Police Department (Town Marshall)$24,943,284.54 Redevelopment Salaries and Wages $454,198.07 Employee Benefits $202,240.13 Total Personal Services $656,438.20 Office Supplies $5,031.06 Total Supplies $5,031.06 Professional Services $7,049.80 Communication and Transportation $20,079.91 Printing and Advertising $497.56 Insurance $400.00 Utility Services $10,242.10 Repairs and Maintenance $75,191.71 Rentals $4,744.74 Other Services and Charges $1,030.00 Total Services and Charges $119,235.82 Other Capital Outlays $3,333.82 Total Capital Outlays $3,333.82 Total Redevelopment $784,038.90 Parks Salaries and Wages $1,837,206.41 Page 43Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Parks Employee Benefits $850,737.85 Total Personal Services $2,687,944.26 Office Supplies $11,287.73 Operating Supplies $23,379.04 Repair and Maintenance Supplies $53,441.36 Other Supplies $19,930.71 Total Supplies $108,038.84 Professional Services $193,067.80 Communication and Transportation $17,212.55 Printing and Advertising $9,749.40 Insurance $34,053.74 Utility Services $121,154.09 Repairs and Maintenance $637,621.95 Rentals $11,501.16 Other Services and Charges $39,112.15 Total Services and Charges $1,063,472.84 Machinery, Equipment, and Vehicles $5,788.81 Total Capital Outlays $5,788.81 Transfer Out - Transferred To Another Fund $222,500.00 Total Other Disbursements $222,500.00 Total Parks $4,087,744.75 Golf Salaries and Wages $600,041.09 Page 44Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Golf Employee Benefits $191,328.93 Total Personal Services $791,370.02 Office Supplies $3,426.76 Operating Supplies $15,763.76 Repair and Maintenance Supplies $24,096.13 Other Supplies $4,663.34 Total Supplies $47,949.99 Professional Services $383.47 Communication and Transportation $5,358.30 Printing and Advertising $13,149.86 Utility Services $60,165.35 Repairs and Maintenance $165,682.20 Rentals $34,272.00 Other Services and Charges $128,465.72 Total Services and Charges $407,476.90 Machinery, Equipment, and Vehicles $235,942.56 Other Capital Outlays $1,498.88 Total Capital Outlays $237,441.44 Other Disbursements $6,920.50 Total Other Disbursements $6,920.50 Total Golf $1,491,158.85 Common Council Salaries and Wages $195,244.92 Page 45Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Common Council Employee Benefits $176,978.63 Total Personal Services $372,223.55 Office Supplies $151.12 Operating Supplies $1,053.37 Total Supplies $1,204.49 Professional Services $77,582.34 Communication and Transportation $5,506.13 Other Services and Charges $64,679.22 Total Services and Charges $147,767.69 Other Capital Outlays $1,893.00 Total Capital Outlays $1,893.00 Total Common Council $523,088.73 City Property Maintenance Repair and Maintenance Supplies $30,900.25 Other Supplies $102,659.95 Total Supplies $133,560.20 Professional Services $299,947.11 Communication and Transportation $145,616.22 Repairs and Maintenance $425,788.16 Total Services and Charges $871,351.49 Total City Property Maintenance $1,004,911.69 Page 46Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Building Operations Professional Services $9,389.35 Utility Services $567,296.13 Repairs and Maintenance $2,400,473.15 Total Services and Charges $2,977,158.63 Total Building Operations $2,977,158.63 Total General $106,711,887.42 Total Governmental Activities Disbursements for Funds with Departments $106,711,887.42 Page 47Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Fund Type Schedule 2021 Fund Type Local Fund Standard Fund Grant Related 1 - General Fund 1 - General General N 2 - Special Revenue 201 - Motor Vehicle Highway Motor Vehicle Highway N 2 - Special Revenue 202 - Local Road And Street Local Road And Street N 2 - Special Revenue 205 - MVH-CRP MVH Restricted N 2 - Special Revenue 919 - Throughfare Fund Thoroughfare N 2 - Special Revenue 903 - Economic Fund Economic Development Operating N 2 - Special Revenue 904 - Housing Authority Housing Authority N 2 - Special Revenue 210 - User Fee Fund Law Enforcement Continuing Ed N 2 - Special Revenue 502 - Clerk's Record Perpetuation Clerk's Records Perpetuation N 2 - Special Revenue 209 - Deferral Fund Deferral Program N 2 - Special Revenue 912 - Rainy Day Rainy Day N 2 - Special Revenue 107 - Hazardous Material Response Fund Hazardous Materials Response N 2 - Special Revenue 999 - Levy Excess Fund Levy Excess N 2 - Special Revenue 506 - JUDICIAL SALARY FEES JUDICIAL SALARY FEES N 2 - Special Revenue 252 - MIHP Fund MIHP Fund N 2 - Special Revenue 855 - Carmel Redev Gift - Dinner Fund Carmel Redevelopment Commission Gift Fund N 2 - Special Revenue 921 - Non-Reverting Bicycle Facility Non-Reverting Bicycle Facility N 2 - Special Revenue 922 - Non-Reverting Center Green Ice Rink Non-Reverting Center Green Ice Rink N 2 - Special Revenue 923 - Non-Reverting Events & Festivals Non-Reverting Events & Festivals N 2 - Special Revenue 924 - Non-Reverting Code Enforcement Non-Reverting Code Enforcement N 2 - Special Revenue 507 - Historic Preservation Fund Historic Preservation Fund N 2 - Special Revenue 856 - Carmel Redev Gift-Marketing Carmel Redev Gift-Marketing N 2 - Special Revenue 925 - Non-Revt Sidewalk Program Non-Revt Sidewalk Program N 2 - Special Revenue 176 - ARP COVID LOCAL FIS REC ARP COVID LOCAL FIS REC Y 2 - Special Revenue 911 - Drug Task Force Drug Task Force N 2 - Special Revenue 851 - Fire Gift Fund Fire Gift Fund N 2 - Special Revenue 853 - Parks Gift Fund Parks Gift Fund N 2 - Special Revenue 900 - Grant Fund Grant Fund N 2 - Special Revenue 852 - Police Gift Police Gift N 2 - Special Revenue 503 - Court Interperter Fund Court Interperter Fund N 2 - Special Revenue 854 - Community Relations Gift Fund Community Relations Gift Fund N 2 - Special Revenue 505 - Public Defenders Fund Public Defenders Fund N Page 48Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Fund Type Local Fund Standard Fund Grant Related 2 - Special Revenue 902 - Redevelopment Commission Redevelopment Commission N 2 - Special Revenue 108 - Parks Program Fund Parks Program Fund N 2 - Special Revenue 109 - Parks Monon Fund Parks Monon Fund N 2 - Special Revenue 106 - Park Impact Fee Fund Park Impact Fee Fund N 2 - Special Revenue 220 - Barrett Law Fund Barrett Law Fund N 2 - Special Revenue 920 - Keystone Ave Fund Keystone Ave Fund N 2 - Special Revenue 504 - Support For The Arts Support For The Arts N 2 - Special Revenue 221 - Barrett Law Surplus Barrett Law Surplus N 3 - Debt Service 405 - 2004 Road Bond Fund 2004 Road Bond Fund N 3 - Debt Service 406 - 2016 G.O. Bonds Debt Service 2016 G.O. Bonds Debt Service N 4 - Capital Projects 211 - Cumulative Captial Development Cumulative Capital Development N 4 - Capital Projects 103 - Parks Capital Park Nonreverting Capital N 4 - Capital Projects 203 - Cumulative Capital Improvement Cumulative Capital Improvement N 4 - Capital Projects 212 - Illinois St Construction Fund Illinois St Construction Fund N 4 - Capital Projects 110 - Parks Facilities Fund Parks Facilities Fund N 4 - Capital Projects 102 - Ambulance Fund Ambulance Fund N 4 - Capital Projects 501 - Dnr/Tree City Dnr/Tree City N 4 - Capital Projects 206 - Cumulative Capital Sewer Cumulative Capital Sewer N 4 - Capital Projects 450 - Old Town/126Th Street Old Town/126Th Street N 6 - Enterprises 250 - Non Reverting Storm Water Enterprise Operating N 6 - Enterprises 612 - Water Construction Fund (BAN)Enterprise Depreciation And Improvement N 6 - Enterprises 0 - Stormwater Bond Trustee Accounts Stormwater Bond Trustee Accounts N 6 - Enterprises 00 - Wastewater Construction Fund (BAN)Wastewater Construction Fund (BAN)N 6 - Enterprises 653 - Sewer Bond Sinking Sewer Bond Sinking N 6 - Enterprises 654 - Sewer Construction Fund Sewer Construction Fund N 6 - Enterprises 601 - Water Operating Water Operating N 6 - Enterprises 605 - Water Bond & Interest Water Bond & Interest N 6 - Enterprises 604 - Water Depreciation Water Depreciation N 6 - Enterprises 602 - Hydrant Meter Deposit Fund Hydrant Meter Deposit Fund N 6 - Enterprises 609 - Water Connection Water Connection N 6 - Enterprises 610 - Water Availability Water Availability N 6 - Enterprises 606 - Water Sinking Fund Water Sinking Fund N 6 - Enterprises 651 - Sewer Operating Sewer Operating N 6 - Enterprises 652 - Sewer Depreciating Sewer Depreciating N 6 - Enterprises 659 - Sewer Connection Fund Sewer Connection Fund N Page 49Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Fund Type Local Fund Standard Fund Grant Related 6 - Enterprises 660 - Sewer Availability Fund Sewer Availability Fund N 6 - Enterprises 0 - Wastewater Bond & Interest At Bony Wastewater Bond & Interest At Bony N 7 - Internal Service 301 - Health Insurance Fund Health Insurance Fund N 7 - Internal Service 302 - Workers Comp Fund Workers Comp Fund N 8 - Pension Trust 801 - Police Pension Fund Police Pension N 8 - Pension Trust 802 - Fire Pension Fund Fire Pension N 11 - Custodial 204 - Capital Lease Fund Capital Lease Fund N 11 - Custodial 0 - Redev Commission Trust Accounts Redevelopment Comm Trust Accts.N 11 - Custodial 0 - 2016 GO Bonds Trustee Accounts 2016 GO Bonds Trustee Acct.N 11 - Custodial 00 - 2021 GO Bond Trustee Account 2021 GO Bond Trustee Account N 11 - Custodial 0 - Carmel City Court Carmel City Court N 11 - Custodial 403 - Lease Rental Fund Lease Rental Fund N 12 - Other 0 - Payroll Fund Payroll Fund N Page 50Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Debt Statement - 2021 Beginning Principal Balance as of Jan. 1, 2021 Additions Reductions Ending Principal Balance as of Dec. 31, 2021 Principal Due in 2022 Governmental Activities Long Term Debt General Obligation Bonds City of Carmel GO Bond Series 2016A $1,036,000.00 $0.00 $50,000.00 $986,000.00 $97,835.00 General Obligation Bonds City of Carmel GO Bond Series 2016B $928,000.00 $0.00 $44,000.00 $884,000.00 $87,985.00 General Obligation Bonds City of Carmel GO Bond Series 2016C $1,393,000.00 $0.00 $66,000.00 $1,327,000.00 $132,020.00 General Obligation Bonds City of Carmel GO Bond Series 2016D $1,171,000.00 $0.00 $56,000.00 $1,115,000.00 $110,945.00 General Obligation Bonds City of Carmel GO Bond Series 2016E $1,364,000.00 $0.00 $65,000.00 $1,299,000.00 $128,705.00 General Obligation Bonds City of Carmel GO Bond Series 2016F $1,347,000.00 $0.00 $64,000.00 $1,283,000.00 $127,925.00 General Obligation Bonds City of Carmel GO Bond Series 2016M $1,033,000.00 $0.00 $49,000.00 $984,000.00 $97,735.00 General Obligation Bonds Taxable Local Income Tax General Obligation Bonds, Series 2021 (Taxable LIT/PT Bonds) $0.00 $10,550,000.00 $0.00 $10,550,000.00 $215,950.00 General Obligation Bonds City of Carmel GO Bond Series 2016G $1,171,000.00 $0.00 $56,000.00 $1,115,000.00 $110,945.00 General Obligation Bonds City of Carmel GO Bond Series 2016H $1,347,000.00 $0.00 $64,000.00 $1,283,000.00 $127,925.00 General Obligation Bonds City of Carmel GO Bond Series 2016I $1,217,000.00 $0.00 $58,000.00 $1,159,000.00 $115,040.00 General Obligation Bonds City of Carmel GO Bond Series 2016J $1,291,000.00 $0.00 $61,000.00 $1,230,000.00 $122,400.00 General Obligation Bonds City of Carmel GO Bond Series 2016K $1,189,000.00 $0.00 $56,000.00 $1,133,000.00 $112,805.00 General Obligation Bonds City of Carmel GO Bond Series 2016L $1,181,000.00 $0.00 $56,000.00 $1,125,000.00 $112,425.00 Revenue Bonds Redevelopment District Tax Increment Revenue Bonds, Series 2004 A (Clarian Hospital) Illinois Street Project $2,445,000.00 $0.00 $765,000.00 $1,680,000.00 $913,420.00 Revenue Bonds County Option Income Tax Revenue Refunding Bonds of 2011 (Street department) $1,875,000.00 $0.00 $730,000.00 $1,145,000.00 $783,456.00 Revenue Bonds Carmel Municipal Facilities Building Corporation Lease Rental Revenue Bonds, Series 2021 (LIT/PT Bonds) $0.00 $32,380,000.00 $0.00 $32,380,000.00 $1,208,350.00 Page 51Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Beginning Principal Balance as of Jan. 1, 2021 Additions Reductions Ending Principal Balance as of Dec. 31, 2021 Principal Due in 2022 Governmental Activities Long Term Debt Revenue Bonds 2013 Illinois St Project Bond $5,360,000.00 $0.00 $365,000.00 $4,995,000.00 $508,200.00 Revenue Bonds City of Carmel Redevelopment District Taxable Bonds of 2016 (City Center II Projects) $18,225,000.00 $0.00 $685,000.00 $17,540,000.00 $1,280,147.00 Revenue Bonds City of Carmel Taxable Redevelopment District Bonds, Series 2021 (TIF/SBT Bonds) $0.00 $24,215,000.00 $1,120,000.00 $23,095,000.00 $2,061,777.00 Revenue Bonds City of Carmel Taxable Economic Development Lease Rental Revenue Bonds 2018A $12,555,000.00 $0.00 $365,000.00 $12,190,000.00 $873,045.00 Notes and Loans Payable - Long Term 2011 Installment Purchase Agreement, Series B $2,333,293.05 $0.00 $0.00 $2,333,293.05 $0.00 Notes and Loans Payable - Long Term City of Carmel Monon & Main Installment Purchase Contract of 2017 $3,891,985.26 $0.00 $148,811.68 $3,743,173.58 $319,000.00 Governmental Activities Long Term Debt Total $62,353,278.31 $67,145,000.00 $4,923,811.68 $124,574,466.63 $9,648,035.00 STORM WATER - Long Term Debt Revenue Bonds City of Carmel Storm Water District Bonds, Series 2016 $25,027,000.00 $0.00 $1,186,000.00 $23,841,000.00 $2,372,195.00 Revenue Bonds City of Carmel Storm Water District Revenue Bonds, Series 2020 $6,310,000.00 $0.00 $440,000.00 $5,870,000.00 $571,483.00 STORM WATER - Long Term Debt Total $31,337,000.00 $0.00 $1,626,000.00 $29,711,000.00 $2,943,678.00 WASTEWATER - Long Term Debt Revenue Bonds 2021 Wastewater Revenue Bonds $0.00 $3,100,000.00 $0.00 $3,100,000.00 $45,000.00 Revenue Bonds 2009 Wastewater Expansion SRF $2,927,501.00 $0.00 $287,260.00 $2,640,241.00 $288,466.00 Revenue Bonds 2021 Wastewater Refunding Rev $0.00 $7,260,000.00 $0.00 $7,260,000.00 $610,000.00 Revenue Bonds 2020 Wastewater Revenue Bonds $15,954,000.00 $0.00 $1,000.00 $15,953,000.00 $1,000.00 Revenue Bonds 2012 Wastewater Revenue Bonds $7,695,000.00 $0.00 $7,695,000.00 $0.00 $0.00 Revenue Bonds 2005 Wastewater Plant Expansion $3,958,000.00 $0.00 $588,000.00 $3,370,000.00 $615,000.00 WASTEWATER - Long Term Debt Total $30,534,501.00 $10,360,000.00 $8,571,260.00 $32,323,241.00 $1,559,466.00 WATER - Long Term Debt Revenue Bonds 2021 Waterworks Revenue Bonds $0.00 $5,100,000.00 $0.00 $5,100,000.00 $255,000.00 Revenue Bonds 2017 Jr Waterworks Refunding Revenue Bonds $11,437,000.00 $0.00 $540,000.00 $10,897,000.00 $552,000.00 Revenue Bonds 2019 Waterworks Revenue Bond Anticipation Notes $17,745,000.00 $0.00 $0.00 $17,745,000.00 $0.00 Revenue Bonds 2012 Jr Waterworks Rev Bonds $15,580,000.00 $0.00 $820,000.00 $14,760,000.00 $845,000.00 Page 52Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Beginning Principal Balance as of Jan. 1, 2021 Additions Reductions Ending Principal Balance as of Dec. 31, 2021 Principal Due in 2022 WATER - Long Term Debt Revenue Bonds 2016 Waterworks Special Program Bonds $47,405,000.00 $0.00 $2,710,000.00 $44,695,000.00 $3,170,000.00 Revenue Bonds 2008 Plant Expansion Cap Appreciation Bonds $20,644,479.30 $0.00 $0.00 $20,644,479.30 $0.00 WATER - Long Term Debt Total $112,811,479.30 $5,100,000.00 $4,070,000.00 $113,841,479.30 $4,822,000.00 GRAND TOTAL $237,036,258.61 $82,605,000.00 $19,191,071.68 $300,450,186.93 Page 53Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Deficit Fund Balances - 2021 Enterprise Name Fund Name Ending Cash and Investment Balance Total deficit fund balances Page 54Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Lessor Description or Purpose Annual Lease Payment Due in 2022 Lease Begining Date Lease Ending Date Will you retain ownership of the property at the end of the lease term? Governmental Activities (General) RG Schedule 3, Street Salt Trucks $95,989.11 11/14/2016 01/15/2022 Y RG Schedule 3, Repurpose Flat Bed Truck Flatbed Truck $1,405.36 11/14/2016 01/15/2022 Y RG Schedule 4, Fire Department Ambulance $24,310.32 02/16/2017 01/15/2022 Y RG Schedule 4, Administration Ford F-250 $3,434.03 02/16/2017 01/15/2022 Y RG Schedule 4, Information Systems IS Hardward and Security Camera DVRs (3) $12,453.00 02/16/2017 01/15/2022 Y RG Schedule 4, Golf Course Telephone System, Mowers (4) and Lawn Equipment $30,805.39 02/16/2017 01/15/2022 Y RG Schedule 4, City Council Audio Video Equipment $42,361.88 02/16/2017 01/15/2022 Y RG Schedule 4, Police Vehicle Equipment $8,693.55 02/16/2017 01/15/2022 Y RG Schedule 5, Police Ford Interceptors (21) Mobile Data Computers (33) and Emergency Equipment $88,845.57 02/16/2017 01/15/2022 Y RG Schedule 5, Information Systems Ford Explorer $2,359.28 02/16/2017 01/15/2022 Y RG Schedule 6, Police Police Computer Equipment $4,765.52 08/09/2017 07/15/2022 Y RG Schedule 6, Street Ford Trucks and Street Sweeper $110,988.63 08/09/2017 07/15/2022 Y RG Schedule 7, DOCS Vehicles Toyota and Honda Vehicles $25,953.56 10/13/2017 07/15/2022 Y RG Schedule 7, DOCS BIke Locker, Post and Counter $4,269.02 10/13/2017 07/15/2022 Y RG Schedule 7, Information Systems Conduit and Cabling for Christkindlmart $12,204.54 10/13/2017 07/15/2022 Y 2018 RG Schedule 9, Golf Cars Electric Golf Cars, Club Car and Range Picker $26,910.88 04/10/2018 01/15/2022 Y 2019 RG Schedule 16, IT Department Network Video Recorder Upgrades $10,249.36 01/22/2019 01/15/2024 Y 2018 RG Schedule 10, Police Vehicles Police Vehicles $77,973.87 05/08/2018 01/15/2022 Y 2015 HUNT Fire Department (schedule 29) Pierce Enforcer Fire Trucks $129,150.00 08/15/2016 02/15/2026 Y Carmel Civil City, Hamilton County, Indiana Leases 2021 Page 55Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities (General) 2018 RG Schedule 10, Police Equipment Police Equipment $72,355.70 05/08/2018 01/15/2023 Y RG Schedule 3, Fire Air Cart $8,765.65 11/14/2016 01/15/2022 Y RG Schedule 3, Street Sign Truck $15,802.72 11/14/2016 01/15/2022 Y 2018 RG Schedule 10, IT Vehicles Vehicles and Plow Package $14,078.50 05/08/2018 01/15/2023 Y 2018 RG Schedule 11, Street Bobcats and Attachments $65,328.34 05/18/2018 01/15/2023 Y 2018 RG Schedule 13, Administration Dodge Ram 2500 Pickup Truck $2,884.92 08/13/2018 07/15/2023 Y 2018 RG Schedule 14, Fire Department Tail Coats and Pants $87,443.12 09/12/2018 07/15/2023 Y 2018 RG Schedule 15, Fire Department 2011 Pierce Model Arrow XT Aerial Ladder Truck $42,110.08 12/07/2018 07/15/2028 Y 2018 RG Schedule 12, Information Systems HP Enterprise Model D3710 Disk Drive $8,917.72 07/24/2018 07/15/2023 Y 2019 RG Schedule 21, Information Systems 2019 Chevy Tahoe and 2020 Ford Explorer $14,878.56 04/19/2019 01/15/2024 Y 2019 RG Schedule 22, Information Systems Licenses, Drive Enclosures and Servers $49,129.52 04/19/2019 01/15/2024 Y 2019 RG Schedule 26, Police Vehicles Police Vehicles, Various Per Schedule $109,088.88 09/13/2019 07/15/2024 Y 2019 RG Schedule 27, Police Equipment Police Equipment, Various Per Schedule $47,064.54 09/13/2019 07/15/2023 Y 2019 RG Schedule 17, Fire Department Braun Chief XLI Ambulance $27,488.46 02/22/2019 01/15/2029 Y 2019 RG Schedule 19, Police Defibrillators, Radios and Computer Equipment $33,898.18 03/11/2019 01/15/2024 Y 2019 RG Schedule 20, Information Systems HP Enterprise BTO HW $26,643.78 04/11/2019 01/15/2024 Y 2019 RG Schedule 24, Police Vehicle RAM Pickup Truck Crew Cab 4x4 $5,787.82 07/15/2019 07/15/2024 Y 2019 RG Schedule 25, Fire Department 2020 Pierce Pumper $71,295.72 08/02/2019 07/15/2024 Y 2019 RG Schedule 23, Information Systems Cityworks $146,550.56 06/21/2019 01/15/2024 Y 2018 RG Schedule 28, Street 2020 M3 Street Sweeper $48,269.72 12/06/2019 07/15/2024 Y 2020 RG Schedule 29, Street (6) Ford F250 & (6) Ford F550 Pick-Up Trucks with Plows $153,737.06 01/20/2020 01/15/2025 Y 2020 RG Schedule 34, Information Systems Communications Software $11,865.28 04/20/2020 01/15/2025 Y 2020 RG Schedule 35, Street Kubota Tractor $28,104.86 04/20/2020 01/15/2025 Y Page 56Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities (General) 2020 RG Schedule 45, Information Systems Various Information Technology Equipment $25,253.56 11/10/2020 07/15/2025 Y 2020 RG Schedule 30, Fire 2020 Pierce Pumper $70,869.01 01/28/2020 01/15/2030 Y 2020 RG Schedule 31, Information Systems Network Video Recorder Upgrades $13,448.32 03/12/2020 01/15/2025 Y 2020 RG Schedule 33, Police Vehicles 2021 Ford Police Vehicles $180,258.16 03/27/2020 01/15/2025 Y 2020 RG Schedule 36, Fire 2020 Braun Chief Ambulance $26,557.12 05/01/2020 01/15/2030 Y 2020 RG Schedule 37, Police Police Equipment, Various Per Schedule $46,729.56 05/01/2020 01/15/2025 Y 2020 RG Schedule 38, Police Police Vehicle $11,413.62 05/01/2020 01/15/2025 Y 2020 RG Schedule 39, Street 2020 CV350 Compact Sweeper $25,795.50 05/01/2020 01/15/2025 Y 2020 RG Schedule 41, Street Cargo Camera Van $45,522.40 07/20/2020 07/15/2025 Y 2020 RG Schedule 42, Street 2020 Ford F250s and F550s $169,101.36 08/10/2020 07/15/2025 Y 2020 RG Schedule 43, Street 2020 Doosan Front-End Loaders $76,888.64 09/02/2020 07/15/2027 Y 2020 RG Schedule 44, Street Freightliner Dump Truck $29,758.46 09/18/2020 07/15/2027 Y RG Schedule 3, Police Mobile Data Computers $14,119.73 11/14/2016 1/15/2022 Y 2021 RG Schedule 46, Information Systems Nelson Alarm DVR Systems $19,634.22 2/8/2021 1/15/2026 Y 2021 RG Schedule 47, Information Systems HPE Aruba Switches $14,852.90 03/19/2021 01/15/2024 Y 2021 RG Schedule 48, Information Systems Network Surveillance Cameras (30) $11,939.80 04/20/2021 01/15/2024 Y 2021 RG Schedule 49, Street 2021 VAC Truck $56,329.74 04/27/2021 01/15/2031 Y 2021 RG Schedule 50, Police Vehicles (24)$120,918.84 05/19/2021 01/15/2026 Y 2021 RG Schedule 51, Police Various Police Equipment $51,664.78 05/19/2021 01/15/2026 Y 2021 RG Schedule 52, Fire Stryker Powers PRO-XT System $8,776.62 06/03/2021 01/15/2026 Y 2021 RG Schedule 53, Golf Course Asphalt Paving and Bridge Replacement $200,478.34 06/22/2021 07/15/2028 Y 2021 RG Schedule 55. Administrration Chevy Silverado $3,749.22 08/16/2021 07/15/2026 Y Total Governmental Activities (General) $3,028,672.46 Page 57Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org WATER (Water Utility)RG Schedule 6, Water Vehicles $71,875.20 08/09/2017 07/15/2022 Y 2019 RG Schedule 18, Utilities Hydro Excavator and Freightliner $50,776.52 03/04/2019 01/15/2029 Y 2020 RG Schedule 32, Utilities Vehicle Ford Truck $7,600.78 03/26/2020 01/15/2025 Y 2021 RG Schedule 54, Utilities Freightliners (3)$71,841.82 08/16/2021 07/15/2026 Y 2021 RG Schedule 56, Utilities Oracle Billing System $140,372.98 12/22/2021 01/15/2027 Y Total WATER (Water Utility) $342,467.30 GRAND TOTAL $3,371,139.76 Page 58Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Other Post-Employment Benefits (OPEB) 2021 Name of the OPEB plan City of Carmel Health Benefits Type of OPEB plan Single Employer Defined Benefit Select the benefits provided under this OPEB plan:Medical,Dental,Vision If other was selected, please describe Plan Administrator Company Name Anthem Street Address 220 Virginia Avenue City Indianapolis State IN Zip 46204 Contact Person Megan Walker Phone 317-605-8139 E-mail megan.walker@anthem.com Employer sponsoring the plan City of Carmel Current Number of Participants Inactive employees or beneficiaries currently receiving benefit payments 52 Inactive employees entitled to but not yet receiving benefits 0 Active employees 646 Actuarial Information Has there been an actuarial valuation done for this plan within two and a half years from your most recent year end? Yes When are you planning to have an actuarial valuation done? Contribution Rates (as a % of payroll) Employer (e.g. 99.99)0.09% Plan Members (e.g. 99.99)0.04% Annual Covered Payroll (e.g. 9999.99)$56,346,141.96 Cost Method for Funding Purposes Pay as you go Page 59Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Transfers - 2021 Fund Amount General $222,500.00 Non Reverting Storm Water $896,763.80 Illinois St Construction Fund $204,059.36 Grant Fund $1,820,957.05 Redevelopment Commission $527,794.00 Water Operating $17,038,224.48 Hydrant Meter Deposit Fund $575.00 Water Connection $740,000.00 Sewer Operating $986,712.00 Sewer Connection Fund $80,000.00 Total Transfers Out $22,517,585.69 Transfers In (Receipts) Transfers Out (Disbursements) Fund Amount General $899,989.13 Parks Capital $222,500.00 Motor Vehicle Highway $2,110,770.07 Non Reverting Storm Water $438,815.01 Water Operating $575.00 Water Depreciation $729,838.00 Water Bond & Interest $32,844.00 Water Sinking Fund $7,712,510.00 Water Connection $3,425.61 Water Availability $11,301.26 Sewer Operating $9,288,305.61 Sewer Depreciating $192,342.00 Sewer Bond Sinking $569,480.00 Sewer Availability Fund $304,890.00 Total Transfers In $22,517,585.69 Page 60Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Transfer Schedule Report - 2021 Fund Transfer From 1 - General 103 - Parks Capital 201 - Motor Vehicle Highway 250 - Non Reverting Storm Water 1 - General -222,500 -- 212 - Illinois St Construction Fund --204,059 - 250 - Non Reverting Storm Water --896,764 - 601 - Water Operating ---- 602 - Hydrant Meter Deposit Fund ---- 609 - Water Connection ---- 651 - Sewer Operating ---- 659 - Sewer Connection Fund ---- 900 - Grant Fund 372,195 -1,009,947 438,815 902 - Redevelopment Commission 527,794 --- Total 899,989$222,500$2,110,770$438,815$ Fund Transfer To For each transfer that did not occur on a routine basis or was inconsistent with the activities of the fund making the transfer that is identified in the above schedule, provide a general description of the principal purpose of the interfund transfer. One general description can be provided even if multiple funds are impacted or more than one transfer occurred. (An example of a non-routine transfer: a transfer to a wastewater enterprise fund for the local match of a federal pollution control grant, an example of a transfer that is an inconsistent activity of the fund: a transfer from a capital projects fund to the general fund.) 900 to 250 $438,815.01 Resolution 12-06-21-06 900 to 1 $372,195.13 Resolution 03-15-21-01,12-06-21-04,12-06-21-02 250 to 201 $896,763.80 Resolution for yearly transfer 1 to 103 $222,500.00 Budgeted transfer 900 to 201 $1,000,000.00 Resolution 05-17-21-02 212 to 201 204,059.36 Resolution 12-06-21-07 900 to 201 9,946.91 Resolution 12-06-21-13 902 to 1 $527,794.00 Annual Resolution Page 61Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Fund Transfer From 601 - Water Operating 604 - Water Depreciation 605 - Water Bond & Interest 606 - Water Sinking Fund 609 - Water Connection 1 - General ----- 212 - Illinois St Construction Fund ----- 250 - Non Reverting Storm Water ----- 601 - Water Operating -729,838 32,844 6,972,510 3,426 602 - Hydrant Meter Deposit Fund 575 ---- 609 - Water Connection ---740,000 - 651 - Sewer Operating ----- 659 - Sewer Connection Fund ----- 900 - Grant Fund ----- 902 - Redevelopment Commission ----- Total 575$729,838$32,844$7,712,510$3,426$ Page 62Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Fund Transfer From 610 - Water Availability 651 - Sewer Operating 652 - Sewer Depreciating 653 - Sewer Bond Sinking 660 - Sewer Availability Fund 1 - General ----- 212 - Illinois St Construction Fund ----- 250 - Non Reverting Storm Water ----- 601 - Water Operating 11,301 9,288,306 --- 602 - Hydrant Meter Deposit Fund ----- 609 - Water Connection ----- 651 - Sewer Operating --192,342 569,480 224,890 659 - Sewer Connection Fund ----80,000 900 - Grant Fund ----- 902 - Redevelopment Commission ----- Total 11,301$9,288,306$192,342$569,480$304,890$ Page 63Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Fund Transfer From Total 1 - General 222,500 212 - Illinois St Construction Fund 204,059 250 - Non Reverting Storm Water 896,764 601 - Water Operating 17,038,224 602 - Hydrant Meter Deposit Fund 575 609 - Water Connection 740,000 651 - Sewer Operating 986,712 659 - Sewer Connection Fund 80,000 900 - Grant Fund 1,820,957 902 - Redevelopment Commission 527,794 Total $22,517,586 Page 64Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Tax Abatement - 2021 DIRECT Abatement Name Purpose of the Abatement The specific tax being abated Amount of tax revenues reduced as a result of Tax Abatements Amount receivable, if any, as a result of Tax Abatement Digital Mobile Innovations, LLC (fka Allegiant) Equipment/addl employees Business Personal Property $1,247.24 $0.00 The Braun Corporation Equipment/addl employees Business Personal Property $1,457.25 $0.00 Beldin Inc Improvements/addl employees Business Personal Property $124.29 $0.00 Capital Bank and Trust Company Improvements/addl employees Business Personal Property $9,269.42 $0.00 Capital Group Companies Inc Equipment/retained employees Business Personal Property $693.10 $0.00 Nextgear Capital, Inc New equipment/addl jobs Business Personal Property $1,732.70 $0.00 MISO Inc Epuipment/add'l employees Business Personal Property $44,128.92 $0.00 Schlage Lock Company LLC Equipment/add'l employees Equipment/add'l employees $2,398.15 $0.00 Meridian Medical Partners Two, LLC Operate Medical Facility/addtl employees Real Property $124.71 $0.00 Protective Insurance (Baldwin & Lyons) Bldg Improvements/addtl employees Real Property $13,834.51 $0.00 Midwest ISO # 2 Expand HQ & IT Operations Center/addtl employees Real Property $26.95 $0.00 Meridian Medical Partners Two, LLC - TIF Operate Medical Facility/addtl employees Real Property $18,320.97 $0.00 Protective Insurance (Baldwin & Lyons)- TIF Bldg Improvements/addtl employees Real Property $34,172.27 $0.00 Midwest ISO # 2 - TIF Midwest ISO # 2 - TIF Midwest ISO # 2 - TIF $6,063.92 $0.00 INDIRECT Government Name Abatement Name The specific tax being abated Amount of tax revenues reduced as a result of Tax Abatements Amount receivable, if any, as a result of Tax Abatement Hamilton County Aces Power (phase 2)Real Property $49.56 $0.00 Hamilton County Alliance For Cooperative Energy Services Business Personal Property $5,141.01 $0.00 Page 65Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Page 66Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Grants - 2021 Local Project Name/ Description Federal Program Title/Project Name Federal Agency Pass Through Agency Assistance Listing Award Name Award Number Grant Type Local Fund Receipts Disburse- ments Amount of Federal Awards Provided to Subrecipients During the Year Amount of Loans Outstandin g at Year End Amount of Federal Noncash Assistance for the Year Amount of Insurance in Effect During the Year 116th Street and Guilford Road Highway Planning and Construction Cluster Department of Transportation INDOT 20.205 Federal-Aid Highway Program 1702127 Reimbursemen t Grant 900 $85,869.47 $85,869.47 $0.00 $0.00 $0.00 $0.00 CPD Blitz Highway Safety Cluster Department of Transportation Hamilton County 20.600 2020 NHTSA 164AL 69A375193 00004020I N0 Reimbursemen t Grant 900 $3,145.31 $3,145.31 $0.00 $0.00 $0.00 $0.00 CPD Click It To Live It Highway Safety Cluster Department of Transportation Hamilton County 20.600 2020 NHTSA 164AL 69A375193 00004020I N0 Reimbursemen t Grant 900 $10,497.40 $4,797.75 $0.00 $0.00 $0.00 $0.00 BVP - Provides Up to 50% of Vest Cost Bulletproof Vest Partnership Program Department of Justice Direct Grant 16.607 Bulletproof Vest Partnership 2020- BUBX2002 0555 Reimbursemen t Grant 101 $10,942.50 $0.00 $0.00 $0.00 $0.00 $0.00 CPD DUI Enforcement Highway Safety Cluster Department of Transportation Hamilton County 20.600 2020 NHTSA 164AL 69A375193 00004020I N0 Reimbursemen t Grant 900 $1,617.25 $860.61 $0.00 $0.00 $0.00 $0.00 Guilford Road Construction Highway Planning and Construction Cluster Department of Transportation INDOT 20.205 Federal-Aid Highway Program 1383180 Reimbursemen t Grant 900 $23,221.71 $1,198.58 $0.00 $0.00 $0.00 $0.00 Pennsylvania Street and Carmel Drive Construction Highway Planning and Construction Cluster Department of Transportation INDOT 20.205 Federal-Aid Highway Program 1600885 Reimbursemen t Grant 900 $52,152.81 $8,748.34 $0.00 $0.00 $0.00 $0.00 116th Street and College Avenue Highway Planning and Construction Cluster Department of Transportation INDOT 20.205 Federal-Aid Highway Program 1702128 Reimbursemen t Grant 900 $111,199.69 $111,199.69 $0.00 $0.00 $0.00 $0.00 Auman Neighborhood Drainage Improvements Project Community Development Block Program/Entit lements Department of Housing and Urban Development Hamilton County 14.218 HCCDBG-20-8 Program Year 2020 B-20-UC- 18-0023 Reimbursemen t Grant 900 $438,815.01 $438,815.01 $0.00 $0.00 $0.00 $0.00 National Endowment for the Arts NEA Partnership Agreements Other Agency Indiana Arts Commission 45.025 Cultural District Community Engagement Grant CY21 1863296- 61-20 Advance Grant 900 $3,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 National Endowment for the Arts NEA Partnership Agreements Other Agency Indiana Arts Commission 45.025 Cultural District:ARP Marketing Support Funds 1863369- 61-20 Advance Grant 900 $3,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 CPD Opioid Response Team Highway Safety Cluster Department of Transportation Hamilton County 20.600 2020 NHTSA 164AL 69A375193 00004020I N0 Reimbursemen t Grant 900 $342.90 $342.90 $0.00 $0.00 $0.00 $0.00 FEMA - COVID (Fire Dept) Disaster Grants-Public Assistance US Dept of Homeland Security Indiana Department of Homeland Security 97.036 Federal Covid- 19 PA DR-4515- IN Reimbursemen t Grant 900 $414,648.46 $339,614.56 $0.00 $0.00 $0.00 $0.00 Page 67Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Page 68Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Local Project Name/ Description Federal Program Title/Project Name Federal Agency Pass Through Agency Assistance Listing Award Name Award Number Grant Type Local Fund Receipts Disburse- ments Amount of Federal Awards Provided to Subrecipients During the Year Amount of Loans Outstandin g at Year End Amount of Federal Noncash Assistance for the Year Amount of Insurance in Effect During the Year American Rescue Plan (ARP) Coronavirus State and Local Fiscal Recovery Department of the Treasury NA 21.027 ARPA CY2021 Advance Grant 176 $3,761,460. 00 $1,175,273.13 $0.00 $0.00 $0.00 $0.00 CPD Click It To Live It Highway Safety Cluster Department of Transportation Hamilton County 20.600 2020 NHTSA 164AL 69A375193 00004020I N0 Reimbursemen t Grant 900 $5,619.29 $5,619.29 $0.00 $0.00 $0.00 $0.00 CPD DUI Enforcement Highway Safety Cluster Department of Transportation Hamilton County 20.600 2020 NHTSA 164AL 69A375193 00004020I N0 Reimbursemen t Grant 900 $1,020.21 $1,020.21 $0.00 $0.00 $0.00 $0.00 Page 69Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Capital Assets 2021 Government or Enterprise Beginning Balance as of January 1, 2021 Additions Reductions Ending Balance as of December 31, 2021 Governmental Activities - Non- Depreciable Assets Land $136,161,681.71 --$136,161,681.71 Construction in Progress $48,605,212.26 $9,615,833.24 $17,822,014.63 $40,399,030.87 Other Non-Depreciable Assets $1,938,085.00 $107,465.70 -$2,045,550.70 Total $186,704,978.97 $9,723,298.94 $17,822,014.63 $178,606,263.28 Governmental Activities - Depreciable Assets Infrastructure $382,203,437.48 $13,988,771.73 -$396,192,209.21 Buildings $41,148,915.71 $5,141,117.62 -$46,290,033.33 Improvements Other Than Buildings $12,679,769.73 $1,708,061.46 -$14,387,831.19 Machinery, Equipment, and Vehicles $30,054,194.76 $2,491,625.92 $1,352,534.18 $31,193,286.50 Books and Other ---- Total $466,086,317.68 $23,329,576.73 $1,352,534.18 $488,063,360.23 Governmental Activities - Accumulated Depreciation Assets Infrastructure $132,133,263.98 $9,341,950.10 -$141,475,214.08 Buildings $12,247,652.09 $963,422.53 -$13,211,074.62 Improvements Other Than Buildings $3,921,707.35 $599,034.15 -$4,520,741.50 Machinery, Equipment, and Vehicles $17,354,123.78 $3,027,744.31 $1,252,895.74 $19,128,972.35 Books and Other ---- Total $165,656,747.20 $13,932,151.09 $1,252,895.74 $178,336,002.55 WASTEWATER - Non-Depreciable Assets Land $166,322.35 --$166,322.35 Construction in Progress $15,602,849.00 $7,727,347.88 $802,013.50 $22,528,183.38 Other Non-Depreciable Assets ---- Total $15,769,171.35 $7,727,347.88 $802,013.50 $22,694,505.73 WASTEWATER - Depreciable Assets Infrastructure $52,165,975.38 $399,571.97 -$52,565,547.35 Buildings $44,062,711.10 $45,069.00 -$44,107,780.10 Improvements Other Than Buildings ---- Machinery, Equipment, and Vehicles $12,848,340.42 $119,941.24 $35,001.22 $12,933,280.44 Page 70Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org WASTEWATER - Depreciable Assets Books and Other ---- Total $109,077,026.90 $564,582.21 $35,001.22 $109,606,607.89 WASTEWATER - Accumulated Depreciation Assets Infrastructure $17,713,170.32 $873,392.68 -$18,586,563.00 Buildings $18,632,549.61 $1,092,741.85 -$19,725,291.46 Improvements Other Than Buildings ---- Machinery, Equipment, and Vehicles $8,874,919.56 $571,112.74 $33,576.22 $9,412,456.08 Books and Other ---- Total $45,220,639.49 $2,537,247.27 $33,576.22 $47,724,310.54 WATER - Non-Depreciable Assets Land $3,964,659.25 $423,540.70 -$4,388,199.95 Construction in Progress $20,387,051.89 $11,405,984.25 $5,436,274.14 $26,356,762.00 Other Non-Depreciable Assets ---- Total $24,351,711.14 $11,829,524.95 $5,436,274.14 $30,744,961.95 WATER - Depreciable Assets Infrastructure $141,955,154.54 $4,508,599.08 $1,807,109.23 $144,656,644.39 Buildings $60,850,677.76 $151,174.00 -$61,001,851.76 Improvements Other Than Buildings ---- Machinery, Equipment, and Vehicles $15,719,924.42 $574,517.77 $285,686.02 $16,008,756.17 Books and Other ---- Total $218,525,756.72 $5,234,290.85 $2,092,795.25 $221,667,252.32 WATER - Accumulated Depreciation Assets Infrastructure $30,803,144.03 $2,304,084.80 $1,267,201.01 $31,840,027.82 Buildings $14,716,580.49 $1,267,552.48 -$15,984,132.97 Improvements Other Than Buildings ---- Machinery, Equipment, and Vehicles $9,028,847.93 $833,952.27 $253,131.41 $9,609,668.79 Books and Other ---- Total $54,548,572.45 $4,405,589.55 $1,520,332.42 $57,433,829.58 STORM WATER - Non-Depreciable Assets Land ---- Construction in Progress ---- Other Non-Depreciable Assets ---- Page 71Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org STORM WATER - Non-Depreciable Assets Total ---- STORM WATER - Depreciable Assets Infrastructure $42,539,410.27 --$42,539,410.27 Buildings ---- Improvements Other Than Buildings ---- Machinery, Equipment, and Vehicles ---- Books and Other ---- Total $42,539,410.27 --$42,539,410.27 STORM WATER - Accumulated Depreciation Assets Infrastructure $6,531,255.04 $850,788.21 -$7,382,043.25 Buildings ---- Improvements Other Than Buildings ---- Machinery, Equipment, and Vehicles ---- Books and Other ---- Total $6,531,255.04 $850,788.21 -$7,382,043.25 Page 72Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Accounts Payable/Receivable Statement - 2021 Government or Enterprise Accounts Payable Accounts Receivable Governmental Activities $0.00 $0.00 WASTEWATER $508,578.60 $1,704,805.20 WATER $1,161,174.76 $2,038,934.54 STORM WATER $0.00 $0.00 Page 73Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Financial Assistance to Non Governmental Entities - 2021 Name Federal Tax ID Street Address City/State County Operating Officer Name Phone Description Amount Type Actors Theatre of Indiana 20-2530124 510 3rd Avenue SW Carmel IN Hamilton James Reilly 317-669-7983 State or Local Grant $240,000.00 ORCH./SYMPHONY/TH EATRE Bigger Picture Film Group 27-4344743 125 W South Street Indianapolis IN Marion James Moriarty 317-674-5833 State or Local Grant $5,000.00 ART FOUNDATIONS/CENTE RS Booth Tarkington Civic Theatre 35-0230360 3 Center Green Carmel IN Hamilton Michael Lasley 317-853-6314 State or Local Grant $210,000.00 ORCH./SYMPHONY/TH EATRE Carmel Arts Council 35-1673574 PO Box 344 Carmel IN Hamilton Vivian Lawhead 317-443-7548 State or Local Grant $3,000.00 ART FOUNDATIONS/CENTE RS Carmel Clay Historical Society 31-0908428 211 1st Avenue SW Carmel IN Hamilton Debbie Gangstad 317-846-7117 State or Local Grant $3,000.00 HISTORICAL SOCIETY Carmel Community Players 35-1898503 1950 E Greyhound Pass Carmel IN Hamilton Larry Montag 317-815-9387 State or Local Grant $6,000.00 ART FOUNDATIONS/CENTE RS Carmel Education Foundation 35-6066912 515 E Main St #124 Carmel IN Hamilton Jennifer Penix 317-844-9961 State or Local Grant $4,916.00 ART FOUNDATIONS/CENTE RS Carmel Klavier International 42-1626316 PO Box 322 Carmel IN Hamilton Irina Gorin 317-571-1902 State or Local Grant $8,500.00 ORCH./SYMPHONY/TH EATRE Carmel Repertory Theatre Inc 26-4324639 10587 Breckenridge Dr Carmel IN Hamilton John Clair 317-582-1007 State or Local Grant $5,000.00 ORCH./SYMPHONY/TH EATRE Carmel Symphony Orchestra 31-0918565 760 3rd Avenue SW Carmel IN Hamilton Cara Pittenger 317-844-9717 State or Local Grant $275,000.00 ORCH./SYMPHONY/TH EATRE Christian Youth Theater of Indianap 27-0168087 1950 East Greyhound Pass Carmel IN Hamilton Laura Baltz 317-721-2497 State or Local Grant $2,500.00 ART FOUNDATIONS/CENTE RS Friends of Hamilton Co Parks 20-5360193 13295 Illinois Street Suite 138 Carmel IN Hamilton Thomas McLean 317-853-6831 State or Local Grant $12,000.00 ORCH./SYMPHONY/TH EATRE Great American Songbook Foundation 26-0620716 1 Center Green Carmel IN Hamilton Chris Lewis 317-844-2251 State or Local Grant $160,000.00 ORCH./SYMPHONY/TH EATRE Gregory Hancock Dance Theatre 35-1722088 329 Gradle Drive Carmel IN Hamilton Gregory Hancock 317-650-6249 State or Local Grant $80,000.00 ORCH./SYMPHONY/TH EATRE Indiana Artisan Inc 27-0813316 22 N Rangeline Rd Carmel IN Hamilton Rosalyn Demaree 317-964-9455 State or Local Grant $40,000.00 ART FOUNDATIONS/CENTE RS Indiana Association of Chinese-Amer 23-1156805 PO Box 3888 Carmel IN Hamilton Mary Lau 317-523-0324 State or Local Grant $3,500.00 OTHER NOT-FOR- PROFIT Indiana Ballet Conservatory 27-2928161 849 West Carmel Drive Carmel IN Hamilton Kara Casavan 317-202-1617 State or Local Grant $25,000.00 ORCH./SYMPHONY/TH EATRE Indiana Music Education Assoc Found 46-2272366 100 E Thompson Rd Indianapolis IN Marion Lane Velayo 317-342-4100 State or Local Grant $7,000.00 ART FOUNDATIONS/CENTE RS Indiana Wind Symphony 35-2029445 PO Box 78592 Indianapolis IN Marion Susan Ullom Hungerford 317-441-6121 State or Local Grant $40,000.00 ORCH./SYMPHONY/TH EATRE Indianapolis Children's Choir 35-1690755 4600 Sunset Avenue Indianapolis IN Marion Don Steffy 317-940-9640 State or Local Grant $6,500.00 ORCH./SYMPHONY/TH EATRE Page 74Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Name Federal Tax ID Street Address City/State County Operating Officer Name Phone Description Amount Type Indianapolis Symphonic Choir 35-6035494 4600 Sunset Avenue Indianapolis IN Marion Liam Bonner 317-940-4054 State or Local Grant $17,000.00 ORCH./SYMPHONY/TH EATRE International Talent Academy 20-4369460 11398 Regency Lane Carmel IN Hamilton Tatyana Komarova 317-815-9381 State or Local Grant $10,000.00 ART FOUNDATIONS/CENTE RS Janus Developmental Services, Inc. 31-0963175 1555 Westfield Road Noblesville IN Hamilton Joanne McDonough 317-773-8781 State or Local Grant $10,000.00 MENTALLY HANDICAPPED CITIZENS CENTERS M3 Theater Camp 81-4662315 845 West Carmel Drive Carmel IN Hamilton Hillary Blake 317-805-0933 State or Local Grant $2,000.00 ART FOUNDATIONS/CENTE RS Museum of Miniature Houses 35-1840276 111 East Main Street Carmel IN Hamilton Elaine Mancini 317-575-9466 State or Local Grant $5,000.00 ART FOUNDATIONS/CENTE RS The Carmel Apprentice Theatre 82-4715318 254 Veteran's Way Carmel IN Hamilton Will Wood 317-750-2484 State or Local Grant $84,000.00 ORCH./SYMPHONY/TH EATRE Youth Inspirations Theatre 85-0990199 308 Ironwood Drive Carmel IN Hamilton Jennifer Witherbee 317-503-3480 State or Local Grant $8,100.00 ORCH./SYMPHONY/TH EATRE Page 75Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Pensions - 2021 1. Please indicate if your unit offers any of these pension plans to your Employees. Check all that apply. YES NO Public Employees Retirement Fund X Teachers Retirement Fund X 1925 Police Pension Fund X 1937 Firefighter's Pension Fund X 1977 Police and Firefighter's Pension Fund X 2. Does your unit have any other pension plans where the employer makes contributions to the plan or funds any part of the benefits?X Page 76Printed: 1/30/2023 10:56:52 AMIndiana Gateway Report gateway.ifionline.org