Loading...
2020 Annual Financial Report - Carmel Civil CityAnnual Financial Report Indiana State Board of Accounts 2020 CARMEL CIVIL CITY Hamilton County Submitted on 3/1/2021 3:35:00 PM 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:55:12 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Annual Financial Report - 2020 Cash & Investments Combined Statement Local Fund Number Local Fund Name Beg Cash & Inv Bal Jan. 1, 2020 Receipts Disbursement End Cash & Inv Bal Dec. 31, 2020 Governmental Activities 0 Carmel City Court $121,446.41 $892,038.03 $910,506.42 $102,978.02 0 Payroll Fund $0.00 $66,612,649.46 $66,612,649.46 $0.00 0 Redev Commission Trust Accounts $1,761,692.60 $2,341,994.31 $2,330,303.66 $1,773,383.25 0 2016 GO Bonds Trustee Accounts $3,131,128.31 $38,808.00 $747,543.85 $2,422,392.46 1 General $10,894,469.39 $106,482,459.51 $106,283,988.36 $11,092,940.54 102 Ambulance Fund $1,694,237.54 $1,898,071.22 $1,734,569.90 $1,857,738.86 103 Parks Capital $102,756.85 $525,778.52 $147,099.48 $481,435.89 106 Park Impact Fee Fund $2,663,185.21 $980,387.66 $2,534,329.10 $1,109,243.77 107 Hazardous Material Response Fund $26,324.25 $3,455.92 $0.00 $29,780.17 108 Parks Program Fund $2,836,069.73 $2,600,394.49 $3,953,433.41 $1,483,030.81 109 Parks Monon Fund $4,180,047.53 $3,409,385.56 $4,951,272.61 $2,638,160.48 110 Parks Facilities Fund $137,348.75 $121,657.14 $107,221.50 $151,784.39 150 Covid Cares Act $0.00 $1,475,132.10 $1,475,132.10 $0.00 151 Covid Cares PSPC $0.00 $1,558,685.90 $1,558,685.90 $0.00 152 Covid Cares County $0.00 $277,088.66 $277,088.66 $0.00 201 Motor Vehicle Highway $817,845.22 $13,406,033.69 $14,217,238.56 $6,640.35 202 Local Road And Street $5,287,834.83 $3,595,262.02 $6,267,415.17 $2,615,681.68 203 Cumulative Capital Improvement $321,217.79 $198,715.55 $142,660.90 $377,272.44 204 Capital Lease Fund $812,054.74 $5,028,489.74 $5,373,426.42 $467,118.06 205 MVH-CRP $2,462,293.96 $1,739,467.37 $1,773,172.06 $2,428,589.27 206 Cumulative Capital Sewer $286,196.61 $0.00 $7,438.84 $278,757.77 209 Deferral Fund $298,195.67 $13,666.56 $81,415.80 $230,446.43 210 User Fee Fund $84,552.36 $99,879.79 $76,130.03 $108,302.12 211 Cumulative Captial Development $326,652.92 $4,341,281.29 $4,223,068.60 $444,865.61 212 Illinois St Construction Fund $80,602.96 $128,758.00 $5,301.60 $204,059.36 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 $11,058.55 $888.10 $2,525.32 $9,421.33 264 Cares Provider Relief $0.00 $47,084.64 $47,084.64 $0.00 301 Health Insurance Fund $2,848,150.52 $15,393,497.21 $15,135,427.91 $3,106,219.82 Page 2Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Local Fund Number Local Fund Name Beg Cash & Inv Bal Jan. 1, 2020 Receipts Disbursement End Cash & Inv Bal Dec. 31, 2020 Governmental Activities 302 Workers Comp Fund $750,939.02 $188,865.00 $212,525.59 $727,278.43 403 Lease Rental Fund $3,852.65 $0.00 $0.00 $3,852.65 405 2004 Road Bond Fund $1,529,153.11 $2,572,759.62 $2,843,500.00 $1,258,412.73 406 2016 G.O. Bonds Debt Service $60,449.60 $1,592,587.32 $1,484,345.00 $168,691.92 450 Old Town/126Th Street $459.75 $0.00 $0.00 $459.75 501 Dnr/Tree City $71,190.66 $0.00 $0.00 $71,190.66 502 Clerk's Record Perpetuation $274,191.06 $21,913.24 $5,106.48 $290,997.82 503 Court Interperter Fund $63.85 $0.39 $0.00 $64.24 504 Support For The Arts $19,133.77 $0.00 $0.00 $19,133.77 505 Public Defenders Fund $10,992.44 $830.49 $0.00 $11,822.93 506 JUDICIAL SALARY FEES $142,719.54 $20,492.52 $46,638.31 $116,573.75 507 Historic Preservation Fund $144,403.32 $54,109.81 $7,592.50 $190,920.63 801 Police Pension Fund $145,316.34 $609,235.28 $617,636.02 $136,915.60 802 Fire Pension Fund $36,219.55 $564,634.78 $586,499.91 $14,354.42 851 Fire Gift Fund $15,879.07 $15,628.13 $4,767.00 $26,740.20 852 Police Gift $64,670.05 $27,376.56 $30,485.76 $61,560.85 853 Parks Gift Fund $30,413.04 $14,345.58 $7,173.07 $37,585.55 854 Community Relations Gift Fund $98,515.95 $38,617.18 $10,219.40 $126,913.73 855 Carmel Redev Gift - Dinner Fund $4,021.92 $23.43 $974.91 $3,070.44 856 Carmel Redev Gift-Marketing $54,946.59 $0.00 $18,092.77 $36,853.82 900 Grant Fund $616,803.36 $4,336,144.28 $4,232,676.32 $720,271.32 902 Redevelopment Commission $9,723,207.29 $36,464,695.56 $35,488,530.50 $10,699,372.35 903 Economic Fund $78,565.17 $20,000.00 $75,000.00 $23,565.17 904 Housing Authority $58,865.18 $0.00 $0.00 $58,865.18 911 Drug Task Force $643,984.80 $83,432.59 $176,795.60 $550,621.79 912 Rainy Day $11,289,262.62 $0.00 $0.00 $11,289,262.62 919 Throughfare Fund $1,200,681.23 $194,186.95 $0.00 $1,394,868.18 920 Keystone Ave Fund $136,970.29 $874.98 $0.00 $137,845.27 921 Non-Reverting Bicycle Facility $22,113.52 $141.28 $0.00 $22,254.80 922 Non-Reverting Center Green Ice Rink $334,775.80 $508,937.34 $223,135.21 $620,577.93 923 Non-Reverting Events & Festivals $32,145.65 $32,707.62 $33,817.36 $31,035.91 924 Non-Reverting Code Enforcement $20,701.61 $10,182.02 $0.00 $30,883.63 925 Non-Revt Sidewalk Program $0.00 $50,000.00 $0.00 $50,000.00 Page 3Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Local Fund Number Local Fund Name Beg Cash & Inv Bal Jan. 1, 2020 Receipts Disbursement End Cash & Inv Bal Dec. 31, 2020 Governmental Activities 999 Levy Excess Fund $0.18 $0.00 $0.00 $0.18 SubTotal $68,967,344.92 $280,633,732.39 $287,081,641.97 $62,519,435.34 WASTEWATER 0 Wastewater Bond & Interest At Bony $2,876,641.01 $2,105,470.59 $2,002,436.87 $2,979,674.73 00 Wastewater Construction Fund (BAN)$0.00 $15,960,377.00 $9,335,981.00 $6,624,396.00 651 Sewer Operating $338,531.77 $12,056,456.17 $11,394,613.24 $1,000,374.70 652 Sewer Depreciating $1.38 $209,390.00 $209,391.31 $0.07 659 Sewer Connection Fund $167,638.96 $579,394.28 $497,507.61 $249,525.63 660 Sewer Availability Fund $21,731.78 $67,751.12 $74,660.24 $14,822.66 SubTotal $3,404,544.90 $30,978,839.16 $23,514,590.27 $10,868,793.79 WATER 601 Water Operating $1,104,192.19 $38,541,699.40 $37,585,395.48 $2,060,496.11 602 Hydrant Meter Deposit Fund $45,155.00 $0.00 $2,275.00 $42,880.00 604 Water Depreciation $16,801.01 $757,830.01 $774,630.10 $0.92 605 Water Bond & Interest $1,475,150.00 $0.00 $0.00 $1,475,150.00 606 Water Sinking Fund $1,003,866.37 $7,327,527.73 $7,330,565.06 $1,000,829.04 609 Water Connection $60,978.41 $2,199,399.28 $1,389,757.91 $870,619.78 610 Water Availability $252,003.40 $211,405.86 $192,457.63 $270,951.63 612 Water Construction Fund (BAN)$15,425,939.43 $112,016.25 $11,357,812.72 $4,180,142.96 SubTotal $19,384,085.81 $49,149,878.53 $58,632,893.90 $9,901,070.44 STORM WATER 0 Stormwater Bond Trustee Accounts $16,017,959.14 $6,759,687.67 $13,863,564.35 $8,914,082.46 250 Non Reverting Storm Water $1,602,977.67 $3,810,585.76 $3,998,164.99 $1,415,398.44 SubTotal $17,620,936.81 $10,570,273.43 $17,861,729.34 $10,329,480.90 GRAND TOTAL $109,376,912.44 $371,332,723.51 $387,090,855.48 $93,618,780.47 Page 4Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Detailed Receipts - 2020 Governmental Activities Carmel City Court Court Costs and Fees $892,038.03 Total Fines, Forfeitures, and Fees $892,038.03 Total Carmel City Court $892,038.03 Redev Commission Trust Accounts Earnings on Investments and Deposits $3,811.81 Other Receipts/360010 - Miscellaneous Revenue $2,338,182.50 Total Other Receipts $2,341,994.31 Total Redev Commission Trust Accounts $2,341,994.31 2016 GO Bonds Trustee Accounts Earnings on Investments and Deposits $32,295.04 Other Receipts/360010 - Miscellaneous Revenue $6,512.96 Total Other Receipts $38,808.00 Total 2016 GO Bonds Trustee Accounts $38,808.00 Payroll Fund Payroll Fund and Clearing Account Receipts $66,612,649.46 Total Other Receipts $66,612,649.46 Total Payroll Fund $66,612,649.46 Page 5Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General General Property Taxes $45,232,552.68 County Option Income Tax (COIT)$47,713,401.00 Food and Beverage Tax $2,153,220.48 Casino/Riverboat Distribution $469,121.20 Cigarette Tax Distribution $54,195.16 Financial Institution Tax distribution $20,572.21 Vehicle/Aircraft Excise Tax Distribution $1,942,436.11 Commercial Vehicle Excise Tax Distribution (CVET)$17,845.20 ABC Gallonage Tax Distribution $330,706.79 Federal and State Grants and Distributions - Other/333000 - Other Intergovernmental Revenue $17,928.57 Total Taxes and Intergovernmental $97,951,979.40 Planning, Zoning, and Building Permits and Fees $1,749,595.99 Other Licenses and Permits/321110 - Solicitor's License $213.00 Other Licenses and Permits/322000 - Alarm Permits $3,200.00 Other Licenses and Permits/322020 - Multi-Use Permits $466.00 Other Licenses and Permits/322023 - Small Cell Permits $700.00 Other Licenses and Permits/322030 - Traffic Location Permits $1,100.00 Total Licenses and Permits $1,755,274.99 Document and Copy Fees $256.65 Park and Recreation Receipts $1,031,198.27 Rental of Property $162,830.04 Other Charges for Services, Sales, and Fees/349000 - Cell Phone Tower Rental $143,276.88 Other Charges for Services, Sales, and Fees/360010 - Miscellaneous Revenues $967,684.11 Other Charges for Services, Sales, and Fees/360012 - Misc Revenue BWS $5,034.11 Other Charges for Services, Sales, and Fees/364000 - Cable TV Franchise Fees $1,348,272.94 Total Charges for Services $3,658,553.00 Court Costs and Fees $250,062.06 Total Fines, Forfeitures, and Fees $250,062.06 Earnings on Investments and Deposits $445,690.14 Refunds and Reimbursements $1,894,025.92 Transfers In - Transferred from Another Fund $526,874.00 Total Other Receipts $2,866,590.06 Total General $106,482,459.51 Page 6Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Ambulance Fund Emergency Medical Services Fees $1,656,827.31 Total Charges for Services $1,656,827.31 Earnings on Investments and Deposits $8,714.27 Refunds and Reimbursements $202,388.64 Other Receipts/360010 - Miscellaneous Revenues $30,141.00 Total Other Receipts $241,243.91 Total Ambulance Fund $1,898,071.22 Parks Capital Earnings on Investments and Deposits $778.52 Transfers In - Transferred from Another Fund $525,000.00 Total Other Receipts $525,778.52 Total Parks Capital $525,778.52 Park Impact Fee Fund Park and Recreation Receipts $964,584.00 Total Charges for Services $964,584.00 Earnings on Investments and Deposits $15,803.66 Total Other Receipts $15,803.66 Total Park Impact Fee Fund $980,387.66 Hazardous Material Response Fund Other Charges for Services, Sales, and Fees/342050 - Haz Mat Fees $3,274.00 Total Charges for Services $3,274.00 Earnings on Investments and Deposits $181.92 Total Other Receipts $181.92 Total Hazardous Material Response Fund $3,455.92 Parks Program Fund Park and Recreation Receipts $2,581,072.93 Total Charges for Services $2,581,072.93 Earnings on Investments and Deposits $16,923.56 Refunds and Reimbursements $2,398.00 Total Other Receipts $19,321.56 Total Parks Program Fund $2,600,394.49 Page 7Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Parks Monon Fund Food and Beverage Tax $8,247.29 Total Taxes and Intergovernmental $8,247.29 Park and Recreation Receipts $3,322,392.81 Rental of Property $21,600.00 Total Charges for Services $3,343,992.81 Earnings on Investments and Deposits $22,466.36 Refunds and Reimbursements $24,845.00 Donations, Gifts, and Bequests $708.00 Other Receipts/360010 - Miscellaneouse Revenue $9,126.10 Total Other Receipts $57,145.46 Total Parks Monon Fund $3,409,385.56 Parks Facilities Fund Park and Recreation Receipts $65,010.00 Rental of Property $54,075.00 Total Charges for Services $119,085.00 Earnings on Investments and Deposits $834.70 Refunds and Reimbursements $1,737.44 Total Other Receipts $2,572.14 Total Parks Facilities Fund $121,657.14 Covid Cares Act Federal and State Grants and Distributions - Public Safety $1,475,132.10 Total Taxes and Intergovernmental $1,475,132.10 Total Covid Cares Act $1,475,132.10 Covid Cares PSPC Federal and State Grants and Distributions - Public Safety $1,558,685.90 Total Taxes and Intergovernmental $1,558,685.90 Total Covid Cares PSPC $1,558,685.90 Covid Cares County Federal and State Grants and Distributions - Public Safety $277,088.66 Total Taxes and Intergovernmental $277,088.66 Total Covid Cares County $277,088.66 Page 8Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Motor Vehicle Highway General Property Taxes $10,188,438.35 Financial Institution Tax distribution $4,632.50 Vehicle/Aircraft Excise Tax Distribution $437,401.71 Motor Vehicle Highway Distribution $1,739,467.36 Commercial Vehicle Excise Tax Distribution (CVET)$4,018.42 Total Taxes and Intergovernmental $12,373,958.34 Refunds and Reimbursements $269,939.20 Transfers In - Transferred from Another Fund $762,117.15 Other Receipts/360010 - Miscellaneous Revenues $19.00 Total Other Receipts $1,032,075.35 Total Motor Vehicle Highway $13,406,033.69 Local Road And Street Local Road and Street Distribution $2,318,879.71 Total Taxes and Intergovernmental $2,318,879.71 Refunds and Reimbursements $276,382.31 Transfers In - Transferred from Another Fund $1,000,000.00 Total Other Receipts $1,276,382.31 Total Local Road And Street $3,595,262.02 Cumulative Capital Improvement Cigarette Tax Distribution $198,715.55 Total Taxes and Intergovernmental $198,715.55 Total Cumulative Capital Improvement $198,715.55 Capital Lease Fund Other Receipts/390000 - Other Financing Sources $5,028,489.74 Total Other Receipts $5,028,489.74 Total Capital Lease Fund $5,028,489.74 MVH-CRP Motor Vehicle Highway Distribution $1,739,467.37 Total Taxes and Intergovernmental $1,739,467.37 Total MVH-CRP $1,739,467.37 Deferral Fund Other Licenses and Permits/353080 - City Deferral Program $11,908.50 Total Licenses and Permits $11,908.50 Earnings on Investments and Deposits $1,758.06 Total Other Receipts $1,758.06 Total Deferral Fund $13,666.56 Page 9Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities User Fee Fund Gun Permits $56,618.50 Other Licenses and Permits/322022 - Golf Cart Permits $1,350.00 Total Licenses and Permits $57,968.50 Document and Copy Fees $18,929.00 Other Charges for Services, Sales, and Fees/343001 - Fingerprints $565.00 Total Charges for Services $19,494.00 Court Costs and Fees $21,091.28 Total Fines, Forfeitures, and Fees $21,091.28 Refunds and Reimbursements $368.01 Other Receipts/360010 - Miscellaneous Revenues $958.00 Total Other Receipts $1,326.01 Total User Fee Fund $99,879.79 Cumulative Captial Development General Property Taxes $4,018,940.10 Financial Institution Tax distribution $1,826.69 Vehicle/Aircraft Excise Tax Distribution $172,477.01 Commercial Vehicle Excise Tax Distribution (CVET)$1,584.55 Total Taxes and Intergovernmental $4,194,828.35 Refunds and Reimbursements $146,452.94 Total Other Receipts $146,452.94 Total Cumulative Captial Development $4,341,281.29 Illinois St Construction Fund Refunds and Reimbursements $128,758.00 Total Other Receipts $128,758.00 Total Illinois St Construction Fund $128,758.00 MIHP Fund Earnings on Investments and Deposits $69.10 Donations, Gifts, and Bequests $819.00 Total Other Receipts $888.10 Total MIHP Fund $888.10 Cares Provider Relief Federal and State Grants and Distributions - Public Safety $47,084.64 Total Taxes and Intergovernmental $47,084.64 Total Cares Provider Relief $47,084.64 Page 10Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Health Insurance Fund Refunds and Reimbursements $135.78 Transfers In - Transferred from Another Fund $868,895.00 Other Receipts/360010 - Miscellaneouse Revenue $9,130.49 Other Receipts/361010 - Medical FSA Contributions $75,843.38 Other Receipts/391000 - Health Insurance Premium $14,392,699.27 Other Receipts/391020 - DEP Care Contributions $46,793.29 Total Other Receipts $15,393,497.21 Total Health Insurance Fund $15,393,497.21 Workers Comp Fund Other Receipts/360010 - MIscellaneous Revenues $188,865.00 Total Other Receipts $188,865.00 Total Workers Comp Fund $188,865.00 2004 Road Bond Fund General Property Taxes $2,468,985.56 Financial Institution Tax distribution $1,077.74 Vehicle/Aircraft Excise Tax Distribution $101,761.44 Commercial Vehicle Excise Tax Distribution (CVET)$934.88 Total Taxes and Intergovernmental $2,572,759.62 Total 2004 Road Bond Fund $2,572,759.62 2016 G.O. Bonds Debt Service General Property Taxes $1,528,212.22 Financial Institution Tax distribution $668.57 Vehicle/Aircraft Excise Tax Distribution $63,126.58 Commercial Vehicle Excise Tax Distribution (CVET)$579.95 Total Taxes and Intergovernmental $1,592,587.32 Total 2016 G.O. Bonds Debt Service $1,592,587.32 Clerk's Record Perpetuation Document and Copy Fees $21,913.24 Total Charges for Services $21,913.24 Total Clerk's Record Perpetuation $21,913.24 Court Interperter Fund Earnings on Investments and Deposits $0.39 Total Other Receipts $0.39 Total Court Interperter Fund $0.39 Public Defenders Fund Other Charges for Services, Sales, and Fees/353095 - Public Defender Fees $830.49 Total Charges for Services $830.49 Total Public Defenders Fund $830.49 Page 11Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities JUDICIAL SALARY FEES Other Charges for Services, Sales, and Fees/353090 - Judicial Salaries Fees $20,492.52 Total Charges for Services $20,492.52 Total JUDICIAL SALARY FEES $20,492.52 Historic Preservation Fund Other Receipts/360010 - Miscellaneous Revenues $54,109.81 Total Other Receipts $54,109.81 Total Historic Preservation Fund $54,109.81 Police Pension Fund Federal and State Grants and Distributions - Other/335000 - State Shared Revenue $608,730.88 Total Taxes and Intergovernmental $608,730.88 Earnings on Investments and Deposits $504.40 Total Other Receipts $504.40 Total Police Pension Fund $609,235.28 Fire Pension Fund Federal and State Grants and Distributions - Other/335000 - State Shared Revenue $564,554.51 Total Taxes and Intergovernmental $564,554.51 Earnings on Investments and Deposits $80.27 Total Other Receipts $80.27 Total Fire Pension Fund $564,634.78 Fire Gift Fund Earnings on Investments and Deposits $166.49 Donations, Gifts, and Bequests $15,461.64 Total Other Receipts $15,628.13 Total Fire Gift Fund $15,628.13 Police Gift Earnings on Investments and Deposits $374.77 Donations, Gifts, and Bequests $27,001.79 Total Other Receipts $27,376.56 Total Police Gift $27,376.56 Parks Gift Fund Earnings on Investments and Deposits $180.22 Donations, Gifts, and Bequests $14,165.36 Total Other Receipts $14,345.58 Total Parks Gift Fund $14,345.58 Page 12Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Community Relations Gift Fund Earnings on Investments and Deposits $661.15 Donations, Gifts, and Bequests $36,806.03 Other Receipts/360010 - Miscellaneous Revenues $1,150.00 Total Other Receipts $38,617.18 Total Community Relations Gift Fund $38,617.18 Carmel Redev Gift - Dinner Fund Earnings on Investments and Deposits $23.43 Total Other Receipts $23.43 Total Carmel Redev Gift - Dinner Fund $23.43 Grant Fund Federal and State Grants and Distributions - Other/333001 - Other Intergov Rev - CPD $22,455.47 Federal and State Grants and Distributions - Other/333003 - Other Intergov Rev - ENG $4,308,688.81 Total Taxes and Intergovernmental $4,331,144.28 Donations, Gifts, and Bequests $5,000.00 Total Other Receipts $5,000.00 Total Grant Fund $4,336,144.28 Redevelopment Commission Other Taxes/312000 - Other Taxes - TIF $31,251,207.13 Total Taxes and Intergovernmental $31,251,207.13 Planning, Zoning, and Building Permits and Fees $92,132.00 Total Licenses and Permits $92,132.00 Rental of Property $478,296.54 Other Charges for Services, Sales, and Fees/353051 - Bond Admin Fees $2,435.70 Total Charges for Services $480,732.24 Refunds and Reimbursements $164,088.93 Other Receipts/360010 - Miscellaneous Revenue $1,227,480.74 Other Receipts/392050 - Pmt in Addn to Taxes $2,271,194.44 Other Receipts/393000 - Redev Project Sources $977,860.08 Total Other Receipts $4,640,624.19 Total Redevelopment Commission $36,464,695.56 Economic Fund Refunds and Reimbursements $20,000.00 Total Other Receipts $20,000.00 Total Economic Fund $20,000.00 Page 13Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Drug Task Force Other Taxes/333000 - Other Intergovmntal Rev $65,566.33 Total Taxes and Intergovernmental $65,566.33 Earnings on Investments and Deposits $3,840.11 Other Receipts/360010 - Miscellaneous Revenues $14,026.15 Total Other Receipts $17,866.26 Total Drug Task Force $83,432.59 Throughfare Fund Other Charges for Services, Sales, and Fees/368010 - NW Development Area $29,031.52 Other Charges for Services, Sales, and Fees/368020 - SW Development Area $44,000.00 Other Charges for Services, Sales, and Fees/368030 - NE Development Area $84,035.00 Other Charges for Services, Sales, and Fees/368040 - SE Development Area $26,728.80 Total Charges for Services $183,795.32 Earnings on Investments and Deposits $10,391.63 Total Other Receipts $10,391.63 Total Throughfare Fund $194,186.95 Keystone Ave Fund Earnings on Investments and Deposits $874.98 Total Other Receipts $874.98 Total Keystone Ave Fund $874.98 Non-Reverting Bicycle Facility Earnings on Investments and Deposits $141.28 Total Other Receipts $141.28 Total Non-Reverting Bicycle Facility $141.28 Non-Reverting Center Green Ice Rink Park and Recreation Receipts $294,870.54 Total Charges for Services $294,870.54 Earnings on Investments and Deposits $3,166.72 Refunds and Reimbursements $23,900.08 Transfers In - Transferred from Another Fund $187,000.00 Total Other Receipts $214,066.80 Total Non-Reverting Center Green Ice Rink $508,937.34 Page 14Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Non-Reverting Events & Festivals Earnings on Investments and Deposits $202.25 Refunds and Reimbursements $31,481.25 Donations, Gifts, and Bequests $224.12 Other Receipts/360010 - Miscellaneous Revenue $800.00 Total Other Receipts $32,707.62 Total Non-Reverting Events & Festivals $32,707.62 Non-Reverting Code Enforcement Earnings on Investments and Deposits $182.02 Other Receipts/360010 - Miscellaneous Revenues $10,000.00 Total Other Receipts $10,182.02 Total Non-Reverting Code Enforcement $10,182.02 Non-Revt Sidewalk Program Other Receipts/360010 - Miscellaneous Revenues $50,000.00 Total Other Receipts $50,000.00 Total Non-Revt Sidewalk Program $50,000.00 Total Governmental Activities $280,633,732.39 Page 15Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org WASTEWATER Wastewater Bond & Interest At Bony Earnings on Investments and Deposits $14,577.59 Other Receipts/396020 - Misc-For Bond Payments $2,090,893.00 Total Other Receipts $2,105,470.59 Total Wastewater Bond & Interest At Bony $2,105,470.59 Wastewater Construction Fund (BAN)Earnings on Investments and Deposits $6,377.00 Other Receipts/363030 - Bond Proceeds $15,954,000.00 Total Other Receipts $15,960,377.00 Total Wastewater Construction Fund (BAN) $15,960,377.00 Sewer Operating Sewage Fees $3,242,786.74 Total Charges for Services $3,242,786.74 Earnings on Investments and Deposits $2,330.51 Transfers In - Transferred from Another Fund $8,795,892.85 Other Receipts/360010 - Misc Revenue $15,446.07 Total Other Receipts $8,813,669.43 Total Sewer Operating $12,056,456.17 Sewer Depreciating Transfers In - Transferred from Another Fund $192,940.00 Other Receipts/360010 - Misc Revenue $16,450.00 Total Other Receipts $209,390.00 Total Sewer Depreciating $209,390.00 Sewer Connection Fund Earnings on Investments and Deposits $1,028.51 Transfers In - Transferred from Another Fund $83,452.95 Other Receipts/348230 - Connection Fees $494,912.82 Total Other Receipts $579,394.28 Total Sewer Connection Fund $579,394.28 Sewer Availability Fund Earnings on Investments and Deposits $116.45 Transfers In - Transferred from Another Fund $300.00 Other Receipts/348210 - Availability Fees $67,334.67 Total Other Receipts $67,751.12 Total Sewer Availability Fund $67,751.12 Total WASTEWATER $30,978,839.16 Page 16Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org WATER Water Operating Rental of Property $67,660.18 Metered or Measured Sales and Services $20,163,168.18 Total Charges for Services $20,230,828.36 Earnings on Investments and Deposits $9,676.39 Transfers In - Transferred from Another Fund $12,250.43 Other Receipts/348010 - User Fees - Sewer Collected $8,894,823.25 Other Receipts/348010 - User Fees - Stormwater Collected $3,832,392.72 Other Receipts/348010 - User Fees - Tax Collected $1,283,613.28 Other Receipts/348010 - User Fees - Trash Collected $4,231,263.92 Other Receipts/360010 - Misc Revenue $46,602.25 Other Receipts/396020 - Other Revenue $248.80 Total Other Receipts $18,310,871.04 Total Water Operating $38,541,699.40 Water Depreciation Transfers In - Transferred from Another Fund $701,588.41 Other Receipts/360010 - Misc Revenue $56,241.60 Total Other Receipts $757,830.01 Total Water Depreciation $757,830.01 Water Sinking Fund Earnings on Investments and Deposits $9,744.76 Transfers In - Transferred from Another Fund $7,296,724.04 Other Receipts/360010 - Misc Revenue $21,058.93 Total Other Receipts $7,327,527.73 Total Water Sinking Fund $7,327,527.73 Water Connection Earnings on Investments and Deposits $3,017.79 Transfers In - Transferred from Another Fund $11,471.53 Other Receipts/348230 - Connection Fees $2,184,909.96 Total Other Receipts $2,199,399.28 Total Water Connection $2,199,399.28 Water Availability Earnings on Investments and Deposits $1,549.05 Other Receipts/348240 - Availability Fees $209,856.81 Total Other Receipts $211,405.86 Total Water Availability $211,405.86 Water Construction Fund (BAN)Earnings on Investments and Deposits $112,016.25 Total Other Receipts $112,016.25 Total Water Construction Fund (BAN)$112,016.25 Total WATER $49,149,878.53 Page 17Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org STORM WATER Stormwater Bond Trustee Accounts Earnings on Investments and Deposits $59,687.67 Other Receipts/5023990 - Miscellaneous Revenue $6,700,000.00 Total Other Receipts $6,759,687.67 Total Stormwater Bond Trustee Accounts $6,759,687.67 Non Reverting Storm Water Storm Water Fees $3,810,585.76 Total Charges for Services $3,810,585.76 Total Non Reverting Storm Water $3,810,585.76 Total STORM WATER $10,570,273.43 Page 18Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Disbursements by Fund - 2020 Governmental Activities Carmel City Court Other Disbursements $910,506.42 Total Other Disbursements $910,506.42 Total Carmel City Court $910,506.42 Payroll Fund Payments To or On Behalf of Beneficiaries $66,612,649.46 Total Other Disbursements $66,612,649.46 Total Payroll Fund $66,612,649.46 Redev Commission Trust Accounts Other Services and Charges $1,599.96 Total Services and Charges $1,599.96 Payments on Bonds and Other Debt Principal $1,425,000.00 Payments on Bonds and Other Debt Interest $899,931.82 Total Debt service - principal and interest $2,324,931.82 Other Disbursements $3,771.88 Total Other Disbursements $3,771.88 Total Redev Commission Trust Accounts $2,330,303.66 2016 GO Bonds Trustee Accounts Professional Services $522.46 Total Services and Charges $522.46 Construction $746,240.02 Total Capital Outlays $746,240.02 Page 19Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities 2016 GO Bonds Trustee Accounts Other Disbursements $781.37 Total Other Disbursements $781.37 Total 2016 GO Bonds Trustee Accounts $747,543.85 General Salaries and Wages $41,552,211.21 Employee Benefits $19,981,347.74 Total Personal Services $61,533,558.95 Office Supplies $90,178.72 Operating Supplies $429,921.21 Repair and Maintenance Supplies $276,703.76 Other Supplies $216,124.08 Total Supplies $1,012,927.77 Professional Services $2,991,824.65 Communication and Transportation $405,278.02 Printing and Advertising $138,468.19 Insurance $1,562,334.48 Utility Services $1,438,233.60 Repairs and Maintenance $3,866,395.01 Rentals $263,926.20 Other Services and Charges $10,269,689.99 Total Services and Charges $20,936,150.14 Payments on Bonds and Other Debt Principal $7,670,995.05 Payments on Bonds and Other Debt Interest $9,709,390.45 Total Debt service - principal and interest $17,380,385.50 Improvements Other Than Buildings $268,523.09 Machinery, Equipment, and Vehicles $3,446,928.07 Total Capital Outlays $3,715,451.16 Transfer Out - Transferred To Another Fund $1,580,895.00 Page 20Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Other Disbursements $124,619.84 Total Other Disbursements $1,705,514.84 Total General $106,283,988.36 Ambulance Fund Other Supplies $115,704.18 Total Supplies $115,704.18 Machinery, Equipment, and Vehicles $1,600,863.79 Total Capital Outlays $1,600,863.79 Other Disbursements $18,001.93 Total Other Disbursements $18,001.93 Total Ambulance Fund $1,734,569.90 Parks Capital Land $147,099.48 Total Capital Outlays $147,099.48 Total Parks Capital $147,099.48 Park Impact Fee Fund Land $2,306,569.39 Improvements Other Than Buildings $209,228.61 Total Capital Outlays $2,515,798.00 Other Disbursements $18,531.10 Total Other Disbursements $18,531.10 Total Park Impact Fee Fund $2,534,329.10 Parks Program Fund Salaries and Wages $1,764,821.01 Employee Benefits $685,721.46 Total Personal Services $2,450,542.47 Office Supplies $7,401.40 Operating Supplies $129,246.23 Total Supplies $136,647.63 Page 21Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Parks Program Fund Professional Services $294,256.62 Communication and Transportation $38,922.63 Printing and Advertising $12,751.21 Repairs and Maintenance $4,342.91 Rentals $941.77 Other Services and Charges $736,058.52 Total Services and Charges $1,087,273.66 Improvements Other Than Buildings $206,041.75 Machinery, Equipment, and Vehicles $72,927.90 Total Capital Outlays $278,969.65 Total Parks Program Fund $3,953,433.41 Parks Monon Fund Salaries and Wages $1,985,564.38 Employee Benefits $583,809.73 Total Personal Services $2,569,374.11 Office Supplies $10,961.27 Operating Supplies $246,594.30 Total Supplies $257,555.57 Professional Services $455,813.51 Communication and Transportation $28,240.72 Printing and Advertising $54,482.72 Insurance $119,251.00 Utility Services $543,374.64 Repairs and Maintenance $558,863.29 Rentals $7,364.51 Other Services and Charges $206,743.26 Total Services and Charges $1,974,133.65 Machinery, Equipment, and Vehicles $133,897.28 Total Capital Outlays $133,897.28 Page 22Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Parks Monon Fund Other Disbursements $16,312.00 Total Other Disbursements $16,312.00 Total Parks Monon Fund $4,951,272.61 Parks Facilities Fund Repair and Maintenance Supplies $1,970.09 Other Supplies $10,318.20 Total Supplies $12,288.29 Professional Services $5,924.96 Communication and Transportation $3,139.50 Insurance $4,802.00 Utility Services $30,134.23 Repairs and Maintenance $50,912.52 Other Services and Charges $20.00 Total Services and Charges $94,933.21 Total Parks Facilities Fund $107,221.50 Covid Cares Act Other Services and Charges $1,475,132.10 Total Services and Charges $1,475,132.10 Total Covid Cares Act $1,475,132.10 Covid Cares PSPC Other Services and Charges $1,558,685.90 Total Services and Charges $1,558,685.90 Total Covid Cares PSPC $1,558,685.90 Covid Cares County Other Services and Charges $277,088.66 Total Services and Charges $277,088.66 Total Covid Cares County $277,088.66 Motor Vehicle Highway Salaries and Wages $5,336,754.80 Page 23Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Motor Vehicle Highway Employee Benefits $2,659,848.99 Total Personal Services $7,996,603.79 Office Supplies $3,538.77 Operating Supplies $170,813.42 Repair and Maintenance Supplies $987,933.39 Other Supplies $285,067.35 Total Supplies $1,447,352.93 Professional Services $550,859.56 Communication and Transportation $67,653.77 Printing and Advertising $91.61 Utility Services $381,162.10 Repairs and Maintenance $2,465,960.83 Rentals $75,660.58 Other Services and Charges $83,193.35 Total Services and Charges $3,624,581.80 Improvements Other Than Buildings $6,125.00 Machinery, Equipment, and Vehicles $1,142,575.04 Total Capital Outlays $1,148,700.04 Total Motor Vehicle Highway $14,217,238.56 Local Road And Street Professional Services $961,643.94 Repairs and Maintenance $4,797,263.23 Total Services and Charges $5,758,907.17 Payments on Bonds and Other Debt Principal $131,434.13 Payments on Bonds and Other Debt Interest $377,073.87 Total Debt service - principal and interest $508,508.00 Total Local Road And Street $6,267,415.17 Cumulative Capital Improvement Professional Services $71,610.90 Page 24Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Cumulative Capital Improvement Repairs and Maintenance $21,050.00 Total Services and Charges $92,660.90 Improvements Other Than Buildings $50,000.00 Total Capital Outlays $50,000.00 Total Cumulative Capital Improvement $142,660.90 Capital Lease Fund Other Disbursements $5,373,426.42 Total Other Disbursements $5,373,426.42 Total Capital Lease Fund $5,373,426.42 MVH-CRP Repairs and Maintenance $1,773,172.06 Total Services and Charges $1,773,172.06 Total MVH-CRP $1,773,172.06 Cumulative Capital Sewer Repairs and Maintenance $7,438.84 Total Services and Charges $7,438.84 Total Cumulative Capital Sewer $7,438.84 Deferral Fund Salaries and Wages $37,058.99 Employee Benefits $10,811.18 Total Personal Services $47,870.17 Office Supplies $1,875.48 Total Supplies $1,875.48 Communication and Transportation $9,237.20 Rentals $3,578.76 Total Services and Charges $12,815.96 Page 25Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Deferral Fund Machinery, Equipment, and Vehicles $18,854.19 Total Capital Outlays $18,854.19 Total Deferral Fund $81,415.80 User Fee Fund Other Services and Charges $22,888.03 Total Services and Charges $22,888.03 Other Disbursements $53,242.00 Total Other Disbursements $53,242.00 Total User Fee Fund $76,130.03 Cumulative Captial Development Professional Services $15,953.40 Repairs and Maintenance $154,050.20 Total Services and Charges $170,003.60 Payments on Bonds and Other Debt Principal $2,835,570.82 Payments on Bonds and Other Debt Interest $1,212,994.18 Total Debt service - principal and interest $4,048,565.00 Improvements Other Than Buildings $4,500.00 Total Capital Outlays $4,500.00 Total Cumulative Captial Development $4,223,068.60 Illinois St Construction Fund Improvements Other Than Buildings $5,301.60 Total Capital Outlays $5,301.60 Total Illinois St Construction Fund $5,301.60 MIHP Fund Salaries and Wages $598.00 Employee Benefits $294.27 Total Personal Services $892.27 Page 26Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities MIHP Fund Other Disbursements $1,633.05 Total Other Disbursements $1,633.05 Total MIHP Fund $2,525.32 Cares Provider Relief Other Supplies $29,182.10 Total Supplies $29,182.10 Other Services and Charges $17,087.54 Total Services and Charges $17,087.54 Machinery, Equipment, and Vehicles $815.00 Total Capital Outlays $815.00 Total Cares Provider Relief $47,084.64 Health Insurance Fund Other Services and Charges $832,140.00 Total Services and Charges $832,140.00 Other Disbursements $14,303,287.91 Total Other Disbursements $14,303,287.91 Total Health Insurance Fund $15,135,427.91 Workers Comp Fund Other Disbursements $212,525.59 Total Other Disbursements $212,525.59 Total Workers Comp Fund $212,525.59 2004 Road Bond Fund Payments on Bonds and Other Debt Principal $2,305,000.00 Payments on Bonds and Other Debt Interest $538,500.00 Total Debt service - principal and interest $2,843,500.00 Total 2004 Road Bond Fund $2,843,500.00 Page 27Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities 2016 G.O. Bonds Debt Service Payments on Bonds and Other Debt Principal $715,000.00 Payments on Bonds and Other Debt Interest $769,345.00 Total Debt service - principal and interest $1,484,345.00 Total 2016 G.O. Bonds Debt Service $1,484,345.00 Clerk's Record Perpetuation Professional Services $1,862.33 Total Services and Charges $1,862.33 Machinery, Equipment, and Vehicles $3,244.15 Total Capital Outlays $3,244.15 Total Clerk's Record Perpetuation $5,106.48 JUDICIAL SALARY FEES Office Supplies $8,774.64 Other Supplies $326.51 Total Supplies $9,101.15 Professional Services $27,594.26 Communication and Transportation $3,000.00 Insurance $75.00 Repairs and Maintenance $1,998.10 Rentals $1,851.80 Other Services and Charges $150.00 Total Services and Charges $34,669.16 Machinery, Equipment, and Vehicles $2,868.00 Total Capital Outlays $2,868.00 Total JUDICIAL SALARY FEES $46,638.31 Historic Preservation Fund Repairs and Maintenance $7,592.50 Total Services and Charges $7,592.50 Total Historic Preservation Fund $7,592.50 Police Pension Fund Salaries and Wages $1,765.26 Page 28Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Police Pension Fund Employee Benefits $615,770.76 Total Personal Services $617,536.02 Insurance $100.00 Total Services and Charges $100.00 Total Police Pension Fund $617,636.02 Fire Pension Fund Salaries and Wages $2,859.84 Employee Benefits $583,210.72 Total Personal Services $586,070.56 Professional Services $429.35 Total Services and Charges $429.35 Total Fire Pension Fund $586,499.91 Fire Gift Fund Other Disbursements $4,767.00 Total Other Disbursements $4,767.00 Total Fire Gift Fund $4,767.00 Police Gift Other Disbursements $30,485.76 Total Other Disbursements $30,485.76 Total Police Gift $30,485.76 Parks Gift Fund Other Disbursements $7,173.07 Total Other Disbursements $7,173.07 Total Parks Gift Fund $7,173.07 Community Relations Gift Fund Other Services and Charges $10,219.40 Total Services and Charges $10,219.40 Total Community Relations Gift Fund $10,219.40 Page 29Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Carmel Redev Gift - Dinner Fund Other Disbursements $974.91 Total Other Disbursements $974.91 Total Carmel Redev Gift - Dinner Fund $974.91 Carmel Redev Gift- Marketing Repairs and Maintenance $18,092.77 Total Services and Charges $18,092.77 Total Carmel Redev Gift-Marketing $18,092.77 Grant Fund Other Services and Charges $3,232,676.32 Total Services and Charges $3,232,676.32 Transfer Out - Transferred To Another Fund $1,000,000.00 Total Other Disbursements $1,000,000.00 Total Grant Fund $4,232,676.32 Redevelopment Commission Professional Services $1,628,106.49 Total Services and Charges $1,628,106.49 Payments on Bonds and Other Debt Principal $13,890,000.00 Payments on Bonds and Other Debt Interest $9,046,404.73 Total Debt service - principal and interest $22,936,404.73 Land $4,920,938.43 Improvements Other Than Buildings $1,808,618.88 Total Capital Outlays $6,729,557.31 Transfer Out - Transferred To Another Fund $526,874.00 Page 30Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Redevelopment Commission Other Disbursements $3,667,587.97 Total Other Disbursements $4,194,461.97 Total Redevelopment Commission $35,488,530.50 Economic Fund Professional Services $75,000.00 Total Services and Charges $75,000.00 Total Economic Fund $75,000.00 Drug Task Force Office Supplies $2,152.32 Operating Supplies $106.00 Other Supplies $1,630.92 Total Supplies $3,889.24 Communication and Transportation $4,980.71 Utility Services $17,999.30 Repairs and Maintenance $15,638.32 Rentals $113,668.75 Other Services and Charges $19,509.29 Total Services and Charges $171,796.37 Machinery, Equipment, and Vehicles $1,109.99 Total Capital Outlays $1,109.99 Total Drug Task Force $176,795.60 Non-Reverting Center Green Ice Rink Professional Services $52,577.41 Repairs and Maintenance $170,557.80 Total Services and Charges $223,135.21 Total Non-Reverting Center Green Ice Rink $223,135.21 Page 31Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Non-Reverting Events & Festivals Other Services and Charges $33,217.36 Total Services and Charges $33,217.36 Other Disbursements $600.00 Total Other Disbursements $600.00 Total Non-Reverting Events & Festivals $33,817.36 Total Governmental Activities $287,081,641.97 WASTEWATER Wastewater Bond & Interest At Bony Payments on Bonds and Other Debt Principal $1,359,058.00 Payments on Bonds and Other Debt Interest $643,378.87 Total Debt service - principal and interest $2,002,436.87 Total Wastewater Bond & Interest At Bony $2,002,436.87 Wastewater Construction Fund (BAN) Construction $9,335,981.00 Total Capital Outlays $9,335,981.00 Total Wastewater Construction Fund (BAN)$9,335,981.00 Sewer Operating Salaries and Wages $3,622,756.73 Total Personal Services $3,622,756.73 Insurance $115,110.50 Total Services and Charges $115,110.50 Transfer Out - Transferred To Another Fund $195,131.90 Other Disbursements $2,571,636.19 Total Other Disbursements $2,766,768.09 Chemicals $153,495.67 Contractual Services $1,095,274.38 Employee Pensions and Benefits $1,734,090.23 Materials and Supplies $389,371.07 Power Production\Purchased Power $385,074.17 Page 32Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org WASTEWATER Sewer Operating Sludge Removal $28,700.00 Transportation $109,476.48 Other Operating $994,495.92 Total Operations $4,889,977.92 Total Sewer Operating $11,394,613.24 Sewer Depreciating Construction $209,391.31 Total Capital Outlays $209,391.31 Total Sewer Depreciating $209,391.31 Sewer Connection Fund Construction $475,207.61 Total Capital Outlays $475,207.61 Transfer Out - Transferred To Another Fund $22,300.00 Total Other Disbursements $22,300.00 Total Sewer Connection Fund $497,507.61 Sewer Availability Fund Construction $74,660.24 Total Capital Outlays $74,660.24 Total Sewer Availability Fund $74,660.24 Total WASTEWATER $23,514,590.27 WATER Water Operating Salaries and Wages $4,401,013.18 Total Personal Services $4,401,013.18 Insurance $162,266.50 Total Services and Charges $162,266.50 Transfer Out - Transferred To Another Fund $15,839,982.72 Other Disbursements $10,447,329.40 Total Other Disbursements $26,287,312.12 Chemicals $830,022.07 Contractual Services $882,198.13 Employee Pensions and Benefits $2,121,981.73 Page 33Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org WATER Water Operating Materials and Supplies $518,693.27 Power Production\Purchased Power $1,160,626.64 Purchased Water $136,425.16 Transportation $116,162.79 Other Operating $968,693.89 Total Operations $6,734,803.68 Total Water Operating $37,585,395.48 Hydrant Meter Deposit Fund Transfer Out - Transferred To Another Fund $2,075.00 Total Other Disbursements $2,075.00 Other Operating $200.00 Total Operations $200.00 Total Hydrant Meter Deposit Fund $2,275.00 Water Depreciation Construction $774,630.10 Total Capital Outlays $774,630.10 Total Water Depreciation $774,630.10 Water Sinking Fund Payments on Bonds and Other Debt Principal $3,625,000.00 Payments on Bonds and Other Debt Interest $3,705,565.06 Total Debt service - principal and interest $7,330,565.06 Total Water Sinking Fund $7,330,565.06 Water Connection Construction $748,004.96 Total Capital Outlays $748,004.96 Transfer Out - Transferred To Another Fund $641,752.95 Total Other Disbursements $641,752.95 Total Water Connection $1,389,757.91 Water Availability Construction $155,872.79 Total Capital Outlays $155,872.79 Page 34Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org WATER Water Availability Transfer Out - Transferred To Another Fund $36,584.84 Total Other Disbursements $36,584.84 Total Water Availability $192,457.63 Water Construction Fund (BAN) Construction $11,001,019.92 Total Capital Outlays $11,001,019.92 Transfer Out - Transferred To Another Fund $356,792.80 Total Other Disbursements $356,792.80 Total Water Construction Fund (BAN)$11,357,812.72 Total WATER $58,632,893.90 STORM WATER Stormwater Bond Trustee Accounts Construction $12,579,896.64 Total Capital Outlays $12,579,896.64 Other Disbursements $1,283,667.71 Total Other Disbursements $1,283,667.71 Total Stormwater Bond Trustee Accounts $13,863,564.35 Non Reverting Storm Water Transfer Out - Transferred To Another Fund $762,117.15 Other Disbursements $2,820,413.78 Total Other Disbursements $3,582,530.93 Other Operating $415,634.06 Total Operations $415,634.06 Total Non Reverting Storm Water $3,998,164.99 Total STORM WATER $17,861,729.34 Page 35Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Disbursements by Fund with Departments - 2020 Governmental Activities General No Department Transfer Out - Transferred To Another Fund $525,000.00 Other Disbursements $105,139.67 Total Other Disbursements $630,139.67 Total No Department $630,139.67 Controller Salaries and Wages $592,634.58 Employee Benefits $241,194.14 Total Personal Services $833,828.72 Office Supplies $7,137.35 Operating Supplies $231.00 Total Supplies $7,368.35 Professional Services $103,453.78 Communication and Transportation $9,084.11 Repairs and Maintenance $41,551.13 Rentals $4,457.99 Other Services and Charges $21,574.24 Total Services and Charges $180,121.25 Machinery, Equipment, and Vehicles $4,542.28 Total Capital Outlays $4,542.28 Total Controller $1,025,860.60 Clerk (Clerk/Treasurer)Salaries and Wages $398,445.33 Page 36Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Clerk (Clerk/Treasurer)Employee Benefits $164,659.45 Total Personal Services $563,104.78 Office Supplies $4,018.97 Other Supplies $1,130.74 Total Supplies $5,149.71 Professional Services $12,394.02 Communication and Transportation $1,206.05 Printing and Advertising $918.63 Repairs and Maintenance $3,131.32 Other Services and Charges $2,275.64 Total Services and Charges $19,925.66 Machinery, Equipment, and Vehicles $16,445.99 Total Capital Outlays $16,445.99 Total Clerk (Clerk/Treasurer)$604,626.14 Mayor Salaries and Wages $336,454.29 Employee Benefits $132,848.13 Total Personal Services $469,302.42 Office Supplies $3,009.66 Operating Supplies $839.59 Total Supplies $3,849.25 Professional Services $667,134.27 Communication and Transportation $6,948.76 Page 37Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Mayor Repairs and Maintenance $570.00 Rentals $14,560.56 Other Services and Charges $3,640,302.48 Total Services and Charges $4,329,516.07 Machinery, Equipment, and Vehicles $9,824.91 Total Capital Outlays $9,824.91 Total Mayor $4,812,492.65 Board Of Public Works & Safety Salaries and Wages $14,542.20 Employee Benefits $1,112.40 Total Personal Services $15,654.60 Payments on Bonds and Other Debt Principal $7,670,995.05 Payments on Bonds and Other Debt Interest $9,709,390.45 Total Debt service - principal and interest $17,380,385.50 Total Board Of Public Works & Safety $17,396,040.10 Administration Salaries and Wages $331,956.99 Employee Benefits $116,118.61 Total Personal Services $448,075.60 Office Supplies $3,734.80 Operating Supplies $2,896.02 Repair and Maintenance Supplies $22,304.14 Other Supplies $1,387.56 Total Supplies $30,322.52 Professional Services $6,091.00 Communication and Transportation $3,129.74 Page 38Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Administration Insurance $1,395,840.67 Utility Services $76,592.72 Repairs and Maintenance $387,503.58 Rentals $9,752.99 Other Services and Charges $218,769.19 Total Services and Charges $2,097,679.89 Improvements Other Than Buildings $6,171.00 Machinery, Equipment, and Vehicles $678,250.23 Total Capital Outlays $684,421.23 Total Administration $3,260,499.24 Personnel Salaries and Wages $391,860.47 Employee Benefits $176,002.27 Total Personal Services $567,862.74 Other Supplies $478.64 Total Supplies $478.64 Professional Services $41,957.88 Communication and Transportation $1,957.72 Printing and Advertising $4,691.16 Repairs and Maintenance $21,306.01 Other Services and Charges $9,984.21 Total Services and Charges $79,896.98 Machinery, Equipment, and Vehicles $808.45 Total Capital Outlays $808.45 Total Personnel $649,046.81 Page 39Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General City/Town Court (City Judge/Judge)Salaries and Wages $383,449.81 Employee Benefits $127,577.20 Total Personal Services $511,027.01 Other Services and Charges $24,306.46 Total Services and Charges $24,306.46 Machinery, Equipment, and Vehicles $900.00 Total Capital Outlays $900.00 Total City/Town Court (City Judge/Judge)$536,233.47 Law Department Salaries and Wages $715,828.92 Employee Benefits $317,148.48 Total Personal Services $1,032,977.40 Office Supplies $2,903.24 Total Supplies $2,903.24 Professional Services $445,068.85 Communication and Transportation $4,510.93 Rentals $4,843.48 Other Services and Charges $7,407.16 Total Services and Charges $461,830.42 Machinery, Equipment, and Vehicles $15,137.22 Total Capital Outlays $15,137.22 Total Law Department $1,512,848.28 Community Services Salaries and Wages $1,888,561.70 Page 40Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Community Services Employee Benefits $883,339.72 Total Personal Services $2,771,901.42 Office Supplies $11,706.67 Operating Supplies $15,013.44 Repair and Maintenance Supplies $3,864.04 Other Supplies $8,765.72 Total Supplies $39,349.87 Professional Services $250,951.04 Communication and Transportation $62,034.64 Printing and Advertising $1,911.50 Repairs and Maintenance $454,750.85 Rentals $13,907.84 Other Services and Charges $128,326.03 Total Services and Charges $911,881.90 Improvements Other Than Buildings $250,147.55 Machinery, Equipment, and Vehicles $224,758.63 Total Capital Outlays $474,906.18 Other Disbursements $7,380.26 Total Other Disbursements $7,380.26 Total Community Services $4,205,419.63 Communications Department (Radio-Phones-Dispatch)Salaries and Wages $1,408,365.55 Page 41Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Communications Department (Radio-Phones-Dispatch)Employee Benefits $641,253.44 Total Personal Services $2,049,618.99 Office Supplies $3,965.89 Operating Supplies $6,376.61 Repair and Maintenance Supplies $27,515.78 Other Supplies $4,705.22 Total Supplies $42,563.50 Professional Services $62,014.10 Communication and Transportation $100,290.15 Utility Services $28,064.90 Repairs and Maintenance $420,881.01 Rentals $6,190.51 Other Services and Charges $301,134.65 Total Services and Charges $918,575.32 Improvements Other Than Buildings $12,204.54 Machinery, Equipment, and Vehicles $537,995.91 Total Capital Outlays $550,200.45 Total Communications Department (Radio-Phones-Dispatch)$3,560,958.26 Public Affairs Salaries and Wages $744,322.59 Employee Benefits $277,692.58 Total Personal Services $1,022,015.17 Page 42Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Public Affairs Office Supplies $3,265.23 Total Supplies $3,265.23 Professional Services $485,265.41 Communication and Transportation $30,263.26 Printing and Advertising $89,781.31 Repairs and Maintenance $37,110.76 Rentals $36,591.98 Other Services and Charges $1,724,325.53 Total Services and Charges $2,403,338.25 Machinery, Equipment, and Vehicles $31,567.73 Total Capital Outlays $31,567.73 Transfer Out - Transferred To Another Fund $187,000.00 Total Other Disbursements $187,000.00 Total Public Affairs $3,647,186.38 Fire Department Salaries and Wages $17,328,254.57 Employee Benefits $8,608,853.64 Total Personal Services $25,937,108.21 Office Supplies $10,182.19 Operating Supplies $100,511.05 Repair and Maintenance Supplies $123,674.62 Other Supplies $43,276.07 Total Supplies $277,643.93 Page 43Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Fire Department Professional Services $177,112.38 Communication and Transportation $85,178.71 Printing and Advertising $869.41 Insurance $107,721.81 Utility Services $298,883.41 Repairs and Maintenance $824,665.74 Rentals $12,711.28 Other Services and Charges $730,344.69 Total Services and Charges $2,237,487.43 Transfer Out - Transferred To Another Fund $868,895.00 Other Disbursements $10,687.31 Total Other Disbursements $879,582.31 Total Fire Department $29,331,821.88 Police Department (Town Marshall)Salaries and Wages $14,059,756.39 Employee Benefits $6,975,608.62 Total Personal Services $21,035,365.01 Office Supplies $18,201.98 Operating Supplies $240,119.96 Repair and Maintenance Supplies $25,509.55 Other Supplies $129,673.69 Total Supplies $413,505.18 Professional Services $189,144.52 Communication and Transportation $65,855.29 Printing and Advertising $6,653.51 Utility Services $245,135.74 Repairs and Maintenance $253,123.12 Rentals $106,653.16 Page 44Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Police Department (Town Marshall)Other Services and Charges $331,019.62 Total Services and Charges $1,197,584.96 Machinery, Equipment, and Vehicles $1,791,007.28 Total Capital Outlays $1,791,007.28 Total Police Department (Town Marshall)$24,437,462.43 Redevelopment Salaries and Wages $450,804.94 Employee Benefits $190,807.23 Total Personal Services $641,612.17 Office Supplies $7,843.63 Total Supplies $7,843.63 Professional Services $79,615.10 Communication and Transportation $5,027.44 Utility Services $10,485.77 Repairs and Maintenance $14,508.67 Rentals $10,374.06 Other Services and Charges $860.00 Total Services and Charges $120,871.04 Machinery, Equipment, and Vehicles $3,983.55 Total Capital Outlays $3,983.55 Total Redevelopment $774,310.39 Parks Salaries and Wages $1,747,535.41 Page 45Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Parks Employee Benefits $780,122.79 Total Personal Services $2,527,658.20 Office Supplies $10,351.77 Operating Supplies $18,644.62 Repair and Maintenance Supplies $61,587.37 Other Supplies $23,162.34 Total Supplies $113,746.10 Professional Services $137,233.35 Communication and Transportation $17,066.07 Printing and Advertising $9,010.47 Insurance $55,772.00 Utility Services $95,176.21 Repairs and Maintenance $560,686.46 Rentals $6,215.62 Other Services and Charges $195,155.99 Total Services and Charges $1,076,316.17 Machinery, Equipment, and Vehicles $11,062.93 Total Capital Outlays $11,062.93 Total Parks $3,728,783.40 Golf Salaries and Wages $558,351.89 Employee Benefits $175,877.53 Total Personal Services $734,229.42 Office Supplies $2,965.07 Operating Supplies $10,042.11 Page 46Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Golf Repair and Maintenance Supplies $12,248.26 Other Supplies $3,544.10 Total Supplies $28,799.54 Professional Services $3,003.91 Communication and Transportation $7,479.59 Printing and Advertising $16,207.20 Insurance $3,000.00 Utility Services $56,132.45 Repairs and Maintenance $215,990.93 Rentals $37,666.73 Other Services and Charges $89,486.21 Total Services and Charges $428,967.02 Machinery, Equipment, and Vehicles $118,748.58 Total Capital Outlays $118,748.58 Total Golf $1,310,744.56 Common Council Salaries and Wages $201,085.58 Employee Benefits $171,131.51 Total Personal Services $372,217.09 Office Supplies $892.27 Operating Supplies $613.89 Total Supplies $1,506.16 Professional Services $39,965.54 Communication and Transportation $5,245.56 Printing and Advertising $8,425.00 Page 47Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Common Council Other Services and Charges $103,714.62 Total Services and Charges $157,350.72 Machinery, Equipment, and Vehicles $1,894.38 Total Capital Outlays $1,894.38 Total Common Council $532,968.35 City Property Maintenance Operating Supplies $33,745.93 Total Supplies $33,745.93 Professional Services $37,358.90 Utility Services $124,953.28 Repairs and Maintenance $630,615.43 Other Services and Charges $11,951.04 Total Services and Charges $804,878.65 Total City Property Maintenance $838,624.58 Building Operations Operating Supplies $886.99 Total Supplies $886.99 Professional Services $254,060.60 Utility Services $502,809.12 Other Services and Charges $2,728,752.23 Total Services and Charges $3,485,621.95 Page 48Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities General Building Operations Other Disbursements $1,412.60 Total Other Disbursements $1,412.60 Total Building Operations $3,487,921.54 Total General $106,283,988.36 Total Governmental Activities Disbursements for Funds with Departments $106,283,988.36 Page 49Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Page 50Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Debt Class Description or Purpose Beginning Principal Balance as of Jan. 1, 2020 Additions Reductions Ending Principal Balance as of Dec. 31, 2020 Principal and Interest Due in 2021 Governmental Activities Revenue Bonds Redevelopment District Tax Increment Revenue Bonds, Series 2004 A (Clarian Hospital) Illinois Street Project $3,160,000.00 $0.00 $715,000.00 $2,445,000.00 $915,124.00 Revenue Bonds County Option Income Tax Revenue Refunding Bonds of 2011 (Street department) $2,230,000.00 $0.00 $715,000.00 $1,515,000.00 $775,856.00 Revenue Bonds 2013 Illinois St Project Bond $5,695,000.00 $0.00 $335,000.00 $5,360,000.00 $553,925.00 Notes and Loans Payable Replacement Installment Contract (Secondary Number One) (Replacement SIC) $2,333,293.05 $0.00 $0.00 $2,333,293.05 $0.00 General Obligation Bonds City of Carmel GO Bond Series 2016A $1,084,000.00 $0.00 $48,000.00 $1,036,000.00 $98,960.00 General Obligation Bonds City of Carmel GO Bond Series 2016B $971,000.00 $0.00 $43,000.00 $928,000.00 $87,880.00 General Obligation Bonds City of Carmel GO Bond Series 2016C $1,458,000.00 $0.00 $65,000.00 $1,393,000.00 $131,850.00 General Obligation Bonds City of Carmel GO Bond Series 2016D $1,225,000.00 $0.00 $54,000.00 $1,171,000.00 $111,350.00 General Obligation Bonds City of Carmel GO Bond Series 2016E $1,427,000.00 $0.00 $63,000.00 $1,364,000.00 $129,500.00 General Obligation Bonds City of Carmel GO Bond Series 2016F $1,408,000.00 $0.00 $61,000.00 $1,347,000.00 $127,670.00 General Obligation Bonds City of Carmel GO Bond Series 2016G $1,225,000.00 $0.00 $54,000.00 $1,171,000.00 $111,350.00 General Obligation Bonds City of Carmel GO Bond Series 2016H $1,408,000.00 $0.00 $61,000.00 $1,347,000.00 $127,670.00 General Obligation Bonds City of Carmel GO Bond Series 2016I $1,273,000.00 $0.00 $56,000.00 $1,217,000.00 $115,530.00 General Obligation Bonds City of Carmel GO Bond Series 2016J $1,350,000.00 $0.00 $59,000.00 $1,291,000.00 $122,050.00 General Obligation Bonds City of Carmel GO Bond Series 2016K $1,244,000.00 $0.00 $55,000.00 $1,189,000.00 $112,210.00 General Obligation Bonds City of Carmel GO Bond Series 2016L $1,235,000.00 $0.00 $54,000.00 $1,181,000.00 $111,830.00 General Obligation Bonds City of Carmel GO Bond Series 2016M $1,081,000.00 $0.00 $48,000.00 $1,033,000.00 $97,850.00 Revenue Bonds City of Carmel Redevelopment District Taxable Bonds of 2016 (City Center II Projects) $18,665,000.00 $0.00 $440,000.00 $18,225,000.00 $1,283,151.86 Carmel Civil City, Hamilton County, Indiana Debt Statement - 2020 Page 51Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities Notes and Loans Payable City of Carmel Monon and Main Installment Purchase Contract $3,891,985.26 $0.00 $74,217.42 $3,817,767.84 $321,498.44 Revenue Bonds City of Carmel Taxable Economic Development Lease Rental Revenue Bonds 2018A $12,645,000.00 $0.00 $90,000.00 $12,555,000.00 $873,371.30 SubTotal $65,009,278.31 $0.00 $3,090,217.42 $61,919,060.89 $6,208,626.60 Debt Class Description or Purpose Beginning Principal Balance as of Jan. 1, 2020 Additions Reductions Ending Principal Balance as of Dec. 31, 2020 Principal and Interest Due in 2021 WASTEWATER Revenue Bonds 2005 Wastewater Plant Expansion $4,521,000.00 $0.00 $563,000.00 $3,958,000.00 $755,513.60 Revenue Bonds 2009 Wastewater Expansion SRF $3,213,559.00 $0.00 $286,058.00 $2,927,501.00 $298,952.27 Revenue Bonds 2012 Wastewater Revenue $8,205,000.00 $0.00 $510,000.00 $7,695,000.00 $749,868.75 Revenue Bonds 2020 Wastewater Revenue Bonds $0.00 $15,954,000.00 $0.00 $15,954,000.00 $359,953.75 SubTotal $15,939,559.00 $15,954,000.00 $1,359,058.00 $30,534,501.00 $2,164,288.37 Debt Class Description or Purpose Beginning Principal Balance as of Jan. 1, 2020 Additions Reductions Ending Principal Balance as of Dec. 31, 2020 Principal and Interest Due in 2021 WATER Revenue Bonds 2012 Jr Waterworks Rev Bonds $16,380,000.00 $0.00 $800,000.00 $15,580,000.00 $1,457,500.00 Revenue Bonds 2016 Waterworks Special Program Bonds $49,700,000.00 $0.00 $2,295,000.00 $47,405,000.00 $4,638,331.26 Revenue Bonds 2008 Plant Expansion Cap Appreciation Bonds $20,644,479.30 $0.00 $0.00 $20,644,479.30 $0.00 Revenue Bonds 2017 Jr Waterworks Refunding Revenue Bonds $11,967,000.00 $0.00 $530,000.00 $11,437,000.00 $873,921.00 Revenue Bonds 2019 Waterworks Revenue Bond Anticipation Notes $17,745,000.00 $0.00 $0.00 $17,745,000.00 $411,684.00 SubTotal $116,436,479.30 $0.00 $3,625,000.00 $112,811,479.30 $7,381,436.26 Debt Class Description or Purpose Beginning Principal Balance as of Jan. 1, 2020 Additions Reductions Ending Principal Balance as of Dec. 31, 2020 Principal and Interest Due in 2021 STORM WATER Revenue Bonds City of Carmel Storm Water District Bonds, Series 2016 $26,180,000.00 $0.00 $1,153,000.00 $25,027,000.00 $2,369,090.00 Revenue Bonds City of Carmel Storm Water District Revenue Bonds, Series 2020 $0.00 $6,700,000.00 $390,000.00 $6,310,000.00 $570,820.00 SubTotal $26,180,000.00 $6,700,000.00 $1,543,000.00 $31,337,000.00 $2,939,910.00 GRAND TOTAL $223,565,316.61 $22,654,000.00 $9,617,275.42 $236,602,041.19 $18,694,261.23 Page 52Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Deficit Fund Balances - 2020 Enterprise Name Fund Name Ending Cash and Investment Balance Total deficit fund balances Page 53Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Lessor Description or Purpose Annual Lease Payment Due in 2021 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 2, Police Police Computer Equipment $58,772.94 06/16/2016 01/15/2021 N/A RG Schedule 2, Street Street Pick-Up Trucks and Snow Plows $38,855.89 06/16/2016 01/15/2021 N/A RG Schedule 2, Engineering Engineering Vehicle $2,601.28 06/16/2016 01/15/2021 N/A RG Schedule 3, Street Salt Trucks $191,978.22 11/14/2016 01/15/2022 N/A RG Schedule 3, Repurpose Flat Bed Truck Flatbed Truck $2,810.71 11/14/2016 01/15/2022 N/A RG Schedule 4, Fire Department Ambulance $48,620.66 02/16/2017 01/15/2022 N/A RG Schedule 4, Administration Ford F-250 $6,868.06 02/16/2017 01/15/2022 N/A RG Schedule 4, Information Systems IS Hardward and Security Camera DVRs (3) $24,906.01 02/16/2017 01/15/2022 N/A RG Schedule 4, Golf Course Telephone System, Mowers (4) and Lawn Equipment $61,610.78 02/16/2017 01/15/2022 N/A RG Schedule 4, City Council Audio Video Equipment $84,723.76 02/16/2017 01/15/2022 N/A RG Schedule 4, Police Vehicle Equipment $17,387.10 02/16/2017 01/15/2022 N/A RG Schedule 5, Police Ford Interceptors (21) Mobile Data Computers (33) and Emergency Equipment $177,691.14 02/16/2017 01/15/2022 N/A RG Schedule 5, Information Systems Ford Explorer $4,718.53 02/16/2017 01/15/2022 N/A RG Schedule 6, Police Police Computer Equipment $4,765.52 08/09/2017 07/15/2022 N/A RG Schedule 6, Street Ford Trucks and Street Sweeper $110,988.63 08/09/2017 07/15/2022 N/A RG Schedule 7, DOCS Vehicles Toyota and Honda Vehicles $25,953.55 10/13/2017 07/15/2022 N/A RG Schedule 7, DOCS BIke Locker, Post and Counter $4,269.02 10/13/2017 07/15/2022 N/A RG Schedule 7, Information Systems Conduit and Cabling for Christkindlmart $12,204.43 10/13/2017 07/15/2022 N/A RG Schedule 1, IT IT Assets $12,907.70 05/05/2016 01/15/2021 N/A RG Schedule 2, Police Police Vehicles $15,496.08 06/16/2016 01/15/2021 N/A RG Schedule 3, Police Police Mobile Data Computers $28,239.46 11/14/2016 01/15/2022 N/A Carmel Civil City, Hamilton County, Indiana Leases 2020 Page 54Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities (General) 2018 RG Schedule 9, Golf Cars Electric Golf Cars, Club Car and Range Picker $53,821.76 04/10/2018 01/15/2022 N/A 2019 RG Schedule 16, IT Department Network Video Recorder Upgrades $10,249.36 01/22/2019 01/15/2024 N/A 2018 RG Schedule 10, Police Vehicles Police Vehicles $155,947.74 05/08/2018 01/15/2022 N/A 2015 Fire Department (schedule 29) Pumper Trucks $129,150.00 08/15/2015 02/15/2026 N/A 2018 RG Schedule 10, Police Equipment Police Equipment $72,355.70 05/08/2018 01/15/2023 N/A RG Schedule 3, Air Cart Air Cart $17,531.31 11/14/2016 01/15/2022 N/A RG Schedule 3, Street Sign Truck $31,605.44 11/14/2016 01/15/2022 N/A 2018 RG Schedule 8, Council Chambers Carpeting, Dais and Remodel, Elevator and Roof Repair $45,397.43 01/10/2018 01/15/2021 N/A 2018 RG Schedule 10, IT Vehicles Vehicles and Plow Package $14,078.50 05/08/2018 01/15/2023 N/A 2018 RG Schedule 11, Street Bobcats and Attachments $65,328.34 05/18/2018 01/15/2023 N/A 2018 RG Schedule 13, Administration Dodge Ram 2500 Pickup Truck $2,884.92 08/13/2018 07/15/2023 N/A 2018 RG Schedule 14, Fire Department Tail Coats and Pants $87,443.12 09/12/2018 07/15/2023 N/A 2018 RG Schedule 15, Fire Department 2011 Pierce Model Arrow XT Aerial Ladder Truck $42,110.08 12/07/2018 07/15/2028 N/A 2018 RG Schedule 12, Information Systems HP Enterprise Model D3710 Disk Drive $8,917.72 07/24/2018 07/15/2023 N/A 2019 RG Schedule 21, Information Systems 2019 Chevy Tahoe and 2020 Ford Explorer $14,878.56 04/19/2019 01/15/2024 N/A 2019 RG Schedule 22, Information Systems Licenses, Drive Enclosures and Servers $49,129.52 04/19/2019 01/15/2024 N/A 2019 RG Schedule 26, Police Vehicles Police Vehicles, Various Per Schedule $109,088.88 09/13/2019 07/15/2024 N/A 2019 RG Schedule 27, Police Equipment Police Equipment, Various Per Schedule $47,064.54 09/13/2019 07/15/2023 N/A 2019 RG Schedule 17, Fire Department Braun Chief XLI Ambulance $27,488.46 02/22/2019 01/15/2029 N/A 2019 RG Schedule 19, Police Defibrillators, Radios and Computer Equipment $33,898.18 03/11/2019 01/15/2024 N/A 2019 RG Schedule 20, Information Systems HP Enterprise BTO HW $26,643.78 04/11/2019 01/15/2024 N/A 2019 RG Schedule 24, Police Vehicle RAM Pickup Truck Crew Cab 4x4 $5,787.82 07/15/2019 07/15/2024 N/A 2019 RG Schedule 25, Fire Department 2020 Pierce Pumper $71,295.72 08/02/2019 07/15/2024 N/A Page 55Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Governmental Activities (General) 2019 RG Schedule 23, Information Systems Cityworks $146,550.56 06/21/2019 01/15/2024 N/A 2018 RG Schedule 28, Street 2020 M3 Street Sweeper $48,269.72 12/06/2019 07/15/2024 N/A 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 N/A 2020 RG Schedule 31, Information Systems Network Video Recorder Upgrades $13,448.32 03/12/2020 01/15/2025 N/A 2020 RG Schedule 33, Police Vehicles 2021 Ford Police Vehicles $180,258.16 03/27/2020 01/15/2025 N/A 2020 RG Schedule 34, Information Systems Communications Software $11,865.28 04/20/2020 01/15/2025 N/A 2020 RG Schedule 35, Street Kubota Tractor $28,104.86 04/20/2020 01/15/2025 N/A 2020 RG Schedule 36, Fire 2020 Braun Chief Ambulance $26,557.12 05/01/2020 01/15/2030 N/A 2020 RG Schedule 37, Police Police Equipment, Various Per Schedule $46,729.56 05/01/2020 01/15/2025 N/A 2020 RG Schedule 38, Police Police Vehicle $11,413.62 05/01/2020 01/15/2025 N/A 2020 RG Schedule 39, Street 2020 CV350 Compact Sweeper $25,795.50 05/01/2020 01/15/2025 N/A 2020 RG Schedule 41, Street Cargo Camera Van $45,522.40 07/20/2020 07/15/2025 N/A 2020 RG Schedule 42, Street 2020 Ford F250s and F550s $169,101.36 08/10/2020 07/15/2025 N/A 2020 RG Schedule 43, Street 2020 Doosan Front-End Loaders $76,888.64 09/02/2020 07/15/2027 N/A 2020 RG Schedule 44, Street Freightliner Dump Truck $29,758.46 09/18/2020 07/15/2027 N/A 2020 RG Schedule 45, Information Systems Various Information Technology Equipment $25,253.56 11/10/2020 07/15/2025 N/A 2020 RG Schedule 30, Fire 2020 Pierce Pumper $70,869.00 01/28/2020 01/15/2030 N/A Total Governmental Activities (General) $3,168,589.53 WASTEWATER (Wastewater Utility) RG Schedule 2, Sewer Vehicles $23,239.97 06/16/2016 01/15/2021 N/A Total WASTEWATER (Wastewater Utility) $23,239.97 WATER (Water Utility)RG Schedule 2, Water Vehicles $27,757.60 06/16/2016 01/15/2021 N/A RG Schedule 6, Water Vehicles $71,875.18 08/09/2017 07/15/2022 N/A 2019 RG Schedule 18, Utilities Hydro Excavator and Freightliner $50,776.52 03/04/2019 01/15/2029 N/A 2020 RG Schedule 32, Utilities Vehicle Ford Truck $7,600.78 03/26/2020 01/15/2025 N/A Page 56Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org WATER (Water Utility)2020 RG Schedule 40, Utilities Freightliner Dump Truck $12,276.20 06/30/2020 01/15/2028 N/A Total WATER (Water Utility) $170,286.28 GRAND TOTAL $3,362,115.78 Page 57Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Other Post-Employment Benefits (OPEB) 2020 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-287-6578 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 48 Inactive employees entitled to but not yet receiving benefits 0 Active employees 605 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)$55,310,716.51 Cost Method for Funding Purposes Pay as you go Page 58Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Transfers - 2020 Fund Amount General $1,580,895.00 Non Reverting Storm Water $762,117.15 Water Construction Fund (BAN)$356,792.80 Grant Fund $1,000,000.00 Redevelopment Commission $526,874.00 Water Operating $15,839,982.72 Hydrant Meter Deposit Fund $2,075.00 Water Connection $641,752.95 Water Availability $36,584.84 Sewer Operating $195,131.90 Sewer Connection Fund $22,300.00 Total Transfers Out $20,964,506.36 Transfers In (Receipts) Transfers Out (Disbursements) Fund Amount General $526,874.00 Parks Capital $525,000.00 Motor Vehicle Highway $762,117.15 Local Road And Street $1,000,000.00 Health Insurance Fund $868,895.00 Water Operating $12,250.43 Water Depreciation $701,588.41 Water Sinking Fund $7,296,724.04 Water Connection $11,471.53 Sewer Operating $8,795,892.85 Sewer Depreciating $192,940.00 Sewer Connection Fund $83,452.95 Sewer Availability Fund $300.00 Non-Reverting Center Green Ice Rink $187,000.00 Total Transfers In $20,964,506.36 Page 59Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Transfer Schedule Report - 2020 Fund Transfer From 1 - General 103 - Parks Capital 201 - Motor Vehicle Highway 202 - Local Road And Street 1 - General -525,000 -- 250 - Non Reverting Storm Water --762,117 - 601 - Water Operating ---- 602 - Hydrant Meter Deposit Fund ---- 609 - Water Connection ---- 610 - Water Availability ---- 612 - Water Construction Fund (BAN)---- 651 - Sewer Operating ---- 659 - Sewer Connection Fund ---- 900 - Grant Fund ---1,000,000 902 - Redevelopment Commission 526,874 --- Total 526,874$525,000$762,117$1,000,000$ Fund Transfer To Page 60Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Fund Transfer From 301 - Health Insurance Fund 601 - Water Operating 604 - Water Depreciation 606 - Water Sinking Fund 609 - Water Connection 1 - General 868,895 ---- 250 - Non Reverting Storm Water ----- 601 - Water Operating --675,179 6,381,631 9,280 602 - Hydrant Meter Deposit Fund -2,075 --- 609 - Water Connection ---558,300 - 610 - Water Availability -10,175 26,409 -- 612 - Water Construction Fund (BAN)---356,793 - 651 - Sewer Operating ----2,192 659 - Sewer Connection Fund ----- 900 - Grant Fund ----- 902 - Redevelopment Commission ----- Total 868,895$12,250$701,588$7,296,724$11,472$ Page 61Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Fund Transfer From 651 - Sewer Operating 652 - Sewer Depreciating 659 - Sewer Connection Fund 660 - Sewer Availability Fund 922 - Non-Reverting Center Green Ice Rink 1 - General ----187,000 250 - Non Reverting Storm Water ----- 601 - Water Operating 8,773,893 ---- 602 - Hydrant Meter Deposit Fund ----- 609 - Water Connection --83,453 -- 610 - Water Availability ----- 612 - Water Construction Fund (BAN)----- 651 - Sewer Operating -192,940 --- 659 - Sewer Connection Fund 22,000 --300 - 900 - Grant Fund ----- 902 - Redevelopment Commission ----- Total 8,795,893$192,940$83,453$300$187,000$ Page 62Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Fund Transfer From Total 1 - General 1,580,895 250 - Non Reverting Storm Water 762,117 601 - Water Operating 15,839,983 602 - Hydrant Meter Deposit Fund 2,075 609 - Water Connection 641,753 610 - Water Availability 36,585 612 - Water Construction Fund (BAN)356,793 651 - Sewer Operating 195,132 659 - Sewer Connection Fund 22,300 900 - Grant Fund 1,000,000 902 - Redevelopment Commission 526,874 Total $20,964,506 Page 63Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org 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.) 902 to 1 - Transfer for bond payment $526,874.00 1 to 103 - Resolution CC 12-07-20-03 $525,000.00 250 to 201 - Year end transfer per resolution $762,117.15 900 to 202 - Resolution CC 05-18-20-06 $1,000,000.00 1 to 301 - Resolution CC 12-21-20-10-CARES ACT $868,895.00 602 to 601 - Transfer between utility funds $1,075.00 602 to 601 - Transfer between utility funds $1,000.00 610 to 601 - Transfer between utility funds $10,175.43 610 to 604 - Transfer between utility funds $26,409.41 601 to 604 - Transfer between utility funds $675,179.00 601 to 606 - Transfer between utility funds $3,500,000.00 601 to 606 - Transfer between utility funds $2,881,631.24 612 to 606 - Transfer between utility funds $356,792.80 609 to 606 - Transfer between utility funds $558,300.00 601 to 609 - Transfer between utility funds $9,279.63 651 to 609 - Transfer from Sewer to Water $2,191.90 601 to 651 - Transfer from Water to Sewer $2,881,413.47 659 to 651 - Transfer from Water to Sewer $22,000.00 601 to 651 - Transfer from Water to Sewer $5,892,479.38 651 to 652 - Transfer between utility funds $119,749.00 651 to 652 - Transfer between utility funds $73,191.38 609 to 659 - Transfer from Water to Sewer $83,452.95 659 to 660 - Transfer between utility funds $300.00 1 to 922 - Resolution CC 12-21-20-07 $187,000.00 Page 64Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Page 65Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Grants - 2020 Page 66Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Page 67Printed: 1/30/2023 10:55:12 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 Task Force Confidential Funds H/BCTDF Confidential Funds Department of Justice Indiana Criminal Justice Institute 16.738 H/BCTDF Confidential Funds JAG-2019- 00001 Reimbursemen t Grant 911 Drug Task Force $1,125.00 $0.00 $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 Grant Fund $265,229.91 $137,985.87 $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 Grant Fund $94,801.06 $136,905.96 $0.00 $0.00 $0.00 $0.00 116th Street and College Ave - Construction Highway Planning and Construction Cluster Department of Transportation INDOT 20.205 Federal-Aid Highway Program 1702128 Reimbursemen t Grant 900 Grant Fund $52,875.85 $52,875.85 $0.00 $0.00 $0.00 $0.00 116th Street and Guilford Rd - Construction Highway Planning and Construction Cluster Department of Transportation INDOT 20.205 Federal-Aid Highway Program 1702127 Reimbursemen t Grant 900 Grant Fund $45,781.99 $45,781.99 $0.00 $0.00 $0.00 $0.00 Click It To Live It Highway Safety Cluster Department of Transportation Hamilton County 20.600 CHIRP-2020- 006 69A375193 00004020I N0 Reimbursemen t Grant 900 Grant Fund $782.61 $6,482.26 $0.00 $0.00 $0.00 $0.00 COVID Cares Act Coronavirus Relief Department of the Treasury Indiana Finance Authority 21.019 Coronavirus Relief Fund No Award Number Reimbursemen t Grant 150 Covid Cares Act $1,475,132. 10 $1,475,132.10 $0.00 $0.00 $0.00 $0.00 COVID Cares PSPC Coronavirus Relief Department of the Treasury Indiana Finance Authority 21.019 Coronavirus Relief Fund No Award Number Reimbursemen t Grant 151 Covid Cares PSPC $1,558,685. 90 $1,558,685.90 $0.00 $0.00 $0.00 $0.00 COVID Cares County Coronavirus Relief Department of the Treasury Indiana Finance Authority 21.019 Coronavirus Relief Fund No Award Number Reimbursemen t Grant 152 Covid Cares County $277,088.66 $277,088.66 $0.00 $0.00 $0.00 $0.00 CARES Provider Relief Provider Relief Department of Health and Human Services Indiana Finance Authority 93.498 Provider Relief Fund No Award Number Advance Grant 264 Cares Provider Relief $47,084.64 $47,084.64 $0.00 $0.00 $0.00 $0.00 Blitz Highway Safety Cluster Department of Transportation Hamilton County 20.600 CHIRP-2020- 006 69A375193 00004020I N0 Reimbursemen t Grant 900 Grant Fund $3,818.34 $3,818.34 $0.00 $0.00 $0.00 $0.00 OPO/BCC Seatbelt Enforcement Highway Safety Cluster Department of Transportation Hamilton County 20.600 CHIRP-2020- 006 69A375193 00004020I N0 Reimbursemen t Grant 900 Grant Fund $4,945.75 $4,945.75 $0.00 $0.00 $0.00 $0.00 DUI Enforcement Highway Safety Cluster Department of Transportation Hamilton County 20.600 CHIRP-2020- 006 69A375193 00004020I N0 Reimbursemen t Grant 900 Grant Fund $791.51 $1,548.15 $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 2019BUBX 19098981 Reimbursemen t Grant 900 Grant Fund $6,675.00 $6,675.00 $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 1 General $0.00 $10,400.00 $0.00 $0.00 $0.00 $0.00 Page 68Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Capital Assets 2020 Asset Type Beginning Balance Additions Reductions Ending Balance Land $193,078,499.00 $4,430,606.78 -$197,509,105.78 Infrastructure $423,755,583.18 $26,031,859.08 $54,605.00 $449,732,837.26 Building $218,322,255.35 $15,990.00 -$218,338,245.35 Improvement $25,854,307.08 $1,978,696.57 -$27,833,003.65 Machinery $44,930,281.08 $6,106,985.91 $1,599,903.00 $49,437,363.99 Construction $222,646,407.06 $42,238,328.74 $52,784,255.85 $212,100,479.95 Books ---- Governmental Activities - Total $1,128,587,332.75 $80,802,467.08 $54,438,763.85 $1,154,951,035.98 Land $166,322.35 --$166,322.35 Infrastructure $52,029,773.38 $136,202.00 -$52,165,975.38 Building $44,030,955.00 $31,756.10 -$44,062,711.10 Improvement ---- Machinery $12,722,828.86 $203,502.13 $77,990.57 $12,848,340.42 Construction $6,275,959.54 $9,607,531.82 $280,642.36 $15,602,849.00 Books ---- WASTEWATER - Total $115,225,839.13 $9,978,992.05 $358,632.93 $124,846,198.25 Land $3,964,659.25 --$3,964,659.25 Infrastructure $142,610,841.51 $1,705,018.40 $91,641.64 $144,224,218.27 Building $60,783,642.68 $123,276.68 $56,241.60 $60,850,677.76 Improvement ---- Machinery $12,922,763.23 $653,722.42 $125,624.99 $13,450,860.66 Construction $8,889,841.27 $12,748,971.46 $1,251,760.84 $20,387,051.89 Books ---- WATER - Total $229,171,747.94 $15,230,988.96 $1,525,269.07 $242,877,467.83 Land ---- Infrastructure $21,617,266.89 $20,922,143.38 -$42,539,410.27 Building ---- Improvement ---- Machinery ---- Construction ---- Page 69Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Government or Enterprise Beginning Balance as of Additions Reductions Ending Balance as of Books ---- STORM WATER - Total $21,617,266.89 $20,922,143.38 -$42,539,410.27 Unit Total $1,494,602,186.71 $126,934,591.47 $56,322,665.85 $1,565,214,112.33 Page 70Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Accounts Payable/Receivable Statement - 2020 Government or Enterprise Accounts Payable Accounts Receivable Governmental Activities $0.00 $0.00 WASTEWATER $230,564.15 $1,699,503.27 WATER $689,398.60 $1,813,523.62 STORM WATER $0.00 $0.00 Page 71Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Financial Assistance to Non Governmental Entities - 2020 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 $4,250.00 HISTORICAL SOCIETY Carmel Community Players 35-1898503 1950 E Greyhound Pass Carmel IN Hamilton Larry Montag 317-815-9387 State or Local Grant $15,000.00 ART FOUNDATIONS/CENTE RS Carmel Fountain Square Committee 41-2277254 PO Box 4155 Carmel IN Hamilton Mark Stults 317-518-9787 State or Local Grant $12,000.00 ART FOUNDATIONS/CENTE RS Carmel High School Orchestra Parent 35-1964473 520 East Main St Carmel IN Hamilton Elisabeth Ohly-Davis 317-844-9717 State or Local Grant $3,500.00 ORCH./SYMPHONY/TH EATRE Carmel Klavier International 42-1626316 PO Box 322 Carmel IN Hamilton Irina Gorin 317-571-1902 State or Local Grant $26,000.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 Central Indiana Dance Ensemble 35-2119055 4993 Deer Ridge Drive North Carmel IN Hamilton Ana Quirk Hunter 317-844-7453 State or Local Grant $15,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 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 $42,000.00 ORCH./SYMPHONY/TH EATRE Page 72Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Name Federal Tax ID Street Address City/State County Operating Officer Name Phone Description Amount Type 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 Indianapolis Opera 35-1405179 4011 N. Pennsylvania Indianapolis IN Marion David Craig Starkey 317-283-3531 State or Local Grant $8,000.00 ORCH./SYMPHONY/TH EATRE 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 PrimeLife Enrichment 35-1411017 1078 Third Ave SW Carmel IN Hamilton Linda Handy 317-815-7000 State or Local Grant $10,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 $90,000.00 ORCH./SYMPHONY/TH EATRE Page 73Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org Carmel Civil City, Hamilton County, Indiana Pensions - 2020 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 Police Pension Fund - First Class Cities 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 74Printed: 1/30/2023 10:55:12 AMIndiana Gateway Report gateway.ifionline.org