HomeMy WebLinkAbout2019 Annual Financial Report - CityAnnual Financial Report
Indiana State Board of Accounts
2019
CARMEL CIVIL CITY
Hamilton County
Submitted on 9/9/2020 4:00: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: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Carmel Civil City, Hamilton County, Indiana
Annual Financial Report - 2019
Cash & Investments Combined Statement
Local Fund
Number
Local Fund Name
Beg Cash
& Inv Bal
Jan 1, 2019Receipts Disbursement
End Cash
& Inv Bal
Dec 31, 2019
Governmental Activities 0 Carmel City Court $154,978.61 $1,547,184.72 $1,580,716.92 $121,446.41
0 Payroll Fund $0.00 $69,937,055.12 $69,937,055.12 $0.00
0 Redev Commission Trust Accounts $1,765,972.65 $2,297,600.41 $2,301,880.46 $1,761,692.60
0 2016 GO Bonds Trustee Accounts $5,396,652.92 $101,896.86 $2,367,421.47 $3,131,128.31
1 General $14,549,781.95 $99,381,627.14 $103,036,959.42 $10,894,449.67
102 Ambulance Fund $1,216,952.65 $1,762,770.44 $1,285,485.55 $1,694,237.54
103 Parks Capital $143,346.43 $5,383.08 $45,972.66 $102,756.85
106 Park Impact Fee Fund $2,444,299.85 $1,175,386.67 $956,501.31 $2,663,185.21
107 Hazardous Material Response Fund $30,304.81 $5,214.78 $9,195.34 $26,324.25
108 Parks Program Fund $3,841,546.54 $4,554,745.72 $5,560,222.53 $2,836,069.73
109 Parks Monon Fund $3,485,723.95 $6,676,104.02 $5,981,780.44 $4,180,047.53
110 Parks Facilities Fund $131,446.43 $161,390.61 $155,488.29 $137,348.75
201 Motor Vehicle Highway $3,220,291.85 $15,365,565.59 $17,768,012.22 $817,845.22
202 Local Road And Street $10,670,708.96 $2,555,460.62 $7,938,334.75 $5,287,834.83
203 Cumulative Capital Improvement $340,321.97 $209,385.97 $228,490.15 $321,217.79
204 Capital Lease Fund $16,238.54 $3,530,368.84 $2,734,552.64 $812,054.74
205 MVH-CRP $0.00 $2,555,281.41 $92,987.45 $2,462,293.96
206 Cumulative Capital Sewer $286,196.61 $0.00 $0.00 $286,196.61
209 Deferral Fund $322,811.26 $36,318.09 $60,933.68 $298,195.67
210 User Fee Fund $160,539.09 $97,166.88 $173,153.61 $84,552.36
211 Cumulative Captial Development $365,033.20 $3,938,341.58 $3,976,721.86 $326,652.92
212 Illinois St Construction Fund $87,020.37 $0.00 $6,417.41 $80,602.96
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,022.82 $5,284.24 $5,248.51 $11,058.55
301 Health Insurance Fund $3,711,874.72 $12,587,874.49 $13,451,598.69 $2,848,150.52
302 Workers Comp Fund $660,225.82 $468,783.00 $378,069.80 $750,939.02
403 Lease Rental Fund $3,852.65 $0.00 $0.00 $3,852.65
405 2004 Road Bond Fund $720,601.34 $3,671,551.77 $2,863,000.00 $1,529,153.11
406 2016 G.O. Bonds Debt Service $21,434.27 $1,522,110.33 $1,483,095.00 $60,449.60
450 Old Town/126Th Street $459.75 $0.00 $0.00 $459.75
Page 2Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Local Fund
Number
Local Fund Name
Beg Cash
& Inv Bal
Jan 1, 2019Receipts Disbursement
End Cash
& Inv Bal
Dec 31, 2019
Governmental Activities 501 Dnr/Tree City $71,190.66 $0.00 $0.00 $71,190.66
502 Clerk's Record Perpetuation $243,411.71 $37,626.44 $6,847.09 $274,191.06
503 Court Interperter Fund $61.27 $2.58 $0.00 $63.85
504 Support For The Arts $19,133.77 $0.00 $0.00 $19,133.77
505 Public Defenders Fund $7,720.53 $3,271.91 $0.00 $10,992.44
506 JUDICIAL SALARY FEES $157,630.35 $34,658.21 $49,569.02 $142,719.54
507 Historic Preservation Fund $65,000.00 $79,403.32 $0.00 $144,403.32
801 Police Pension Fund $131,361.39 $611,325.21 $597,370.26 $145,316.34
802 Fire Pension Fund $5,405.07 $633,176.77 $602,362.29 $36,219.55
851 Fire Gift Fund $10,191.32 $33,104.33 $27,416.58 $15,879.07
852 Police Gift $30,490.30 $65,934.80 $31,755.05 $64,670.05
853 Parks Gift Fund $38,050.21 $5,665.34 $13,302.51 $30,413.04
854 Community Relations Gift Fund $80,772.72 $59,381.79 $41,638.56 $98,515.95
855 Carmel Redev Gift - Dinner Fund $34,431.81 $861.30 $31,271.19 $4,021.92
856 Carmel Redev Gift-Marketing $0.00 $55,000.00 $53.41 $54,946.59
900 Grant Fund $711,692.65 $3,070,276.28 $3,165,165.57 $616,803.36
902 Redevelopment Commission $7,471,337.41 $34,859,556.20 $32,607,686.32 $9,723,207.29
903 Economic Fund $78,565.17 $0.00 $0.00 $78,565.17
904 Housing Authority $58,865.18 $0.00 $0.00 $58,865.18
911 Drug Task Force $741,461.00 $154,319.96 $251,796.16 $643,984.80
912 Rainy Day $8,425,030.62 $2,864,232.00 $0.00 $11,289,262.62
919 Throughfare Fund $986,151.73 $214,529.50 $0.00 $1,200,681.23
920 Keystone Ave Fund $131,438.24 $5,532.05 $0.00 $136,970.29
921 Non-Reverting Bicycle Facility $12,438.96 $9,674.56 $0.00 $22,113.52
922 Non-Reverting Center Green Ice Rink $358,976.01 $245,926.38 $270,126.59 $334,775.80
923 Non-Reverting Events & Festivals $40,425.55 $12,452.36 $20,732.26 $32,145.65
924 Non-Reverting Code Enforcement $10,088.35 $10,613.26 $0.00 $20,701.61
999 Levy Excess Fund $0.18 $0.00 $0.00 $0.18
SubTotal $73,847,336.41 $277,216,376.93 $282,096,388.14 $68,967,325.20
WASTEWATER 0 Wastewater Bond & Interest At Bony $2,844,904.50 $1,833,051.26 $1,801,314.75 $2,876,641.01
651 Sewer Operating $566,958.97 $10,372,799.04 $10,601,226.24 $338,531.77
652 Sewer Depreciating $0.57 $221,081.25 $221,080.44 $1.38
659 Sewer Connection Fund $161,601.00 $536,150.41 $530,112.45 $167,638.96
Page 3Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Local Fund
Number
Local Fund Name
Beg Cash
& Inv Bal
Jan 1, 2019Receipts Disbursement
End Cash
& Inv Bal
Dec 31, 2019
WASTEWATER 660 Sewer Availability Fund $1.83 $21,729.95 $0.00 $21,731.78
SubTotal $3,573,466.87 $12,984,811.91 $13,153,733.88 $3,404,544.90
WATER 601 Water Operating $104,069.72 $38,776,441.63 $37,776,319.16 $1,104,192.19
602 Hydrant Meter Deposit Fund $44,355.00 $800.00 $0.00 $45,155.00
604 Water Depreciation $0.58 $542,819.23 $526,018.80 $16,801.01
605 Water Bond & Interest $1,475,150.00 $0.00 $0.00 $1,475,150.00
606 Water Sinking Fund $460.56 $7,679,052.55 $6,675,646.74 $1,003,866.37
609 Water Connection $10,539.87 $2,834,338.24 $2,783,899.70 $60,978.41
610 Water Availability $1.92 $279,938.48 $27,937.00 $252,003.40
612 Water Construction Fund (BAN)$0.00 $16,162,859.33 $736,919.90 $15,425,939.43
SubTotal $1,634,577.65 $66,276,249.46 $48,526,741.30 $19,384,085.81
STORM WATER 0 Stormwater Bond Trustee Accounts $19,710,882.80 $495,030.59 $4,187,954.25 $16,017,959.14
250 Non Reverting Storm Water $1,202,690.32 $3,670,255.06 $3,269,967.71 $1,602,977.67
SubTotal $20,913,573.12 $4,165,285.65 $7,457,921.96 $17,620,936.81
GRAND TOTAL $99,968,954.05 $360,642,723.95 $351,234,785.28 $109,376,892.72
Page 4Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Carmel Civil City, Hamilton County, Indiana
Detailed Receipts - 2019
Governmental Activities Carmel City Court Court Costs and Fees $1,547,184.72
Total Fines, Forfeitures, and Fees $1,547,184.72
Total Carmel City Court $1,547,184.72
Redev Commission Trust Accounts Earnings on Investments and Deposits $14,703.41
Other Receipts/360010 - Misc Revenue $2,282,897.00
Total Other Receipts $2,297,600.41
Total Redev Commission Trust
Accounts
$2,297,600.41
2016 GO Bonds Trustee Accounts Earnings on Investments and Deposits $101,563.86
Other Receipts/360010 - Misc Revenue $333.00
Total Other Receipts $101,896.86
Total 2016 GO Bonds Trustee
Accounts
$101,896.86
Payroll Fund Payroll Fund and Clearing Account Receipts $69,937,055.12
Total Other Receipts $69,937,055.12
Total Payroll Fund $69,937,055.12
Page 5Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities General General Property Taxes $39,858,702.82
County Option Income Tax (COIT)$44,531,670.00
Food and Beverage Tax $2,278,055.81
Casino/Riverboat Distribution $469,121.20
Cigarette Tax Distribution $57,105.26
Financial Institution Tax distribution $18,725.96
Vehicle/Aircraft Excise Tax Distribution $4,241,300.16
Commercial Vehicle Excise Tax Distribution (CVET)$18,546.02
ABC Gallonage Tax Distribution $233,527.67
Federal and State Grants and Distributions -
Other/333000 - Other Intergovermental Rev
$79,048.07
Federal and State Grants and Distributions -
Other/336000 - Joinder Budget Payments
$932,743.46
Total Taxes and Intergovernmental $92,718,546.43
Planning, Zoning, and Building Permits and Fees $1,784,653.21
Other Licenses and Permits/321110 - Solicitor's License $2,195.00
Other Licenses and Permits/322000 - Alarm Permits $4,796.00
Other Licenses and Permits/322020 - Multi-Use Permits $2,516.00
Total Licenses and Permits $1,794,160.21
Park and Recreation Receipts $856,182.74
Other Charges for Services, Sales, and Fees/349000 -
Cell Phone Tower Rental
$146,497.46
Total Charges for Services $1,002,680.20
Court Costs and Fees $439,109.74
Total Fines, Forfeitures, and Fees $439,109.74
Earnings on Investments and Deposits $367,690.29
Refunds and Reimbursements $426,286.53
Transfers In - Transferred from Another Fund $1,455,506.46
Other Receipts/360010 - Misc Revenue $417,925.09
Other Receipts/360011 - Misc Rev- CPD/CID $47,975.76
Other Receipts/364000 - Cable TV Franchise Fees $711,746.43
Total Other Receipts $3,427,130.56
Total General $99,381,627.14
Page 6Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities Ambulance Fund Emergency Medical Services Fees $1,685,376.93
Total Charges for Services $1,685,376.93
Earnings on Investments and Deposits $76,813.52
Other Receipts/360010 - Misc. Revenue $579.99
Total Other Receipts $77,393.51
Total Ambulance Fund $1,762,770.44
Parks Capital Earnings on Investments and Deposits $5,383.08
Total Other Receipts $5,383.08
Total Parks Capital $5,383.08
Park Impact Fee Fund Other Licenses and Permits/323000 - Park Impact Fees $1,078,878.00
Total Licenses and Permits $1,078,878.00
Earnings on Investments and Deposits $96,508.67
Total Other Receipts $96,508.67
Total Park Impact Fee Fund $1,175,386.67
Hazardous Material Response Fund Other Charges for Services, Sales, and Fees/342050 -
Haz Mat Fees
$3,930.96
Total Charges for Services $3,930.96
Earnings on Investments and Deposits $1,283.82
Total Other Receipts $1,283.82
Total Hazardous Material Response
Fund
$5,214.78
Parks Program Fund Park and Recreation Receipts $4,395,639.62
Total Charges for Services $4,395,639.62
Earnings on Investments and Deposits $158,401.90
Donations, Gifts, and Bequests $259.20
Other Receipts/360010 - Misc Revenue $445.00
Total Other Receipts $159,106.10
Total Parks Program Fund $4,554,745.72
Page 7Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities Parks Monon Fund Other Taxes/313000 - Sales Tax Collected $17,907.05
Total Taxes and Intergovernmental $17,907.05
Park and Recreation Receipts $6,298,839.94
Rental of Property $136,594.66
Total Charges for Services $6,435,434.60
Earnings on Investments and Deposits $156,156.62
Refunds and Reimbursements $17,995.00
Donations, Gifts, and Bequests $26,563.27
Other Receipts/360010 - Misc Revenues $22,047.48
Total Other Receipts $222,762.37
Total Parks Monon Fund $6,676,104.02
Parks Facilities Fund Park and Recreation Receipts $75,810.00
Rental of Property $78,765.44
Total Charges for Services $154,575.44
Earnings on Investments and Deposits $5,452.23
Other Receipts/360010 - Misc Revenue $1,362.94
Total Other Receipts $6,815.17
Total Parks Facilities Fund $161,390.61
Motor Vehicle Highway General Property Taxes $8,507,353.47
Financial Institution Tax distribution $3,992.54
Vehicle/Aircraft Excise Tax Distribution $904,282.95
Commercial Vehicle Excise Tax Distribution (CVET)$3,954.18
Federal and State Grants and Distributions - Highways
and Streets
$3,874,392.81
Total Taxes and Intergovernmental $13,293,975.95
Refunds and Reimbursements $337,466.14
Transfers In - Transferred from Another Fund $1,734,051.00
Other Receipts/360010 - Misc Revenue $72.50
Total Other Receipts $2,071,589.64
Total Motor Vehicle Highway $15,365,565.59
Page 8Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities Local Road And Street Federal and State Grants and Distributions - Highways
and Streets
$2,307,786.42
Total Taxes and Intergovernmental $2,307,786.42
Refunds and Reimbursements $247,674.20
Total Other Receipts $247,674.20
Total Local Road And Street $2,555,460.62
Cumulative Capital Improvement Cigarette Tax Distribution $209,385.97
Total Taxes and Intergovernmental $209,385.97
Total Cumulative Capital Improvement $209,385.97
Capital Lease Fund Earnings on Investments and Deposits $0.98
Other Receipts/390000 - Other Financing Sources $3,530,367.86
Total Other Receipts $3,530,368.84
Total Capital Lease Fund $3,530,368.84
MVH-CRP Transfers In - Transferred from Another Fund $2,555,281.41
Total Other Receipts $2,555,281.41
Total MVH-CRP $2,555,281.41
Deferral Fund Other Charges for Services, Sales, and Fees/353080 -
City Deferral Program
$23,238.00
Total Charges for Services $23,238.00
Earnings on Investments and Deposits $13,080.09
Total Other Receipts $13,080.09
Total Deferral Fund $36,318.09
User Fee Fund Document and Copy Fees $30,272.93
Total Charges for Services $30,272.93
Court Costs and Fees $66,394.74
Total Fines, Forfeitures, and Fees $66,394.74
Refunds and Reimbursements $471.21
Other Receipts/360010 - Misc Revenue $28.00
Total Other Receipts $499.21
Total User Fee Fund $97,166.88
Page 9Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities Cumulative Captial Development General Property Taxes $3,556,710.15
Financial Institution Tax distribution $1,670.28
Vehicle/Aircraft Excise Tax Distribution $378,306.93
Commercial Vehicle Excise Tax Distribution (CVET)$1,654.22
Total Taxes and Intergovernmental $3,938,341.58
Total Cumulative Captial Development $3,938,341.58
MIHP Fund Earnings on Investments and Deposits $412.24
Donations, Gifts, and Bequests $4,872.00
Total Other Receipts $5,284.24
Total MIHP Fund $5,284.24
Health Insurance Fund Refunds and Reimbursements $160,925.25
Benefit Plan Contributions $12,414,587.25
Other Receipts/360010 - Miscellaneouse Revenues $12,361.99
Total Other Receipts $12,587,874.49
Total Health Insurance Fund $12,587,874.49
Workers Comp Fund Other Receipts/360010 - Miscellaneous Revenues $468,783.00
Total Other Receipts $468,783.00
Total Workers Comp Fund $468,783.00
2004 Road Bond Fund General Property Taxes $3,329,849.61
Financial Institution Tax distribution $1,495.52
Vehicle/Aircraft Excise Tax Distribution $338,725.50
Commercial Vehicle Excise Tax Distribution (CVET)$1,481.14
Total Taxes and Intergovernmental $3,671,551.77
Total 2004 Road Bond Fund $3,671,551.77
2016 G.O. Bonds Debt Service General Property Taxes $1,380,822.19
Financial Institution Tax distribution $618.38
Vehicle/Aircraft Excise Tax Distribution $140,057.32
Commercial Vehicle Excise Tax Distribution (CVET)$612.44
Total Taxes and Intergovernmental $1,522,110.33
Total 2016 G.O. Bonds Debt Service $1,522,110.33
Clerk's Record Perpetuation Document and Copy Fees $37,626.44
Total Charges for Services $37,626.44
Total Clerk's Record Perpetuation $37,626.44
Page 10Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities Court Interperter Fund Earnings on Investments and Deposits $2.58
Total Other Receipts $2.58
Total Court Interperter Fund $2.58
Public Defenders Fund Other Charges for Services, Sales, and Fees/353095 -
Public Defender Fees
$3,271.91
Total Charges for Services $3,271.91
Total Public Defenders Fund $3,271.91
JUDICIAL SALARY FEES Other Charges for Services, Sales, and Fees/353090 -
Judicial Salaries Fees
$34,658.21
Total Charges for Services $34,658.21
Total JUDICIAL SALARY FEES $34,658.21
Historic Preservation Fund Transfers In - Transferred from Another Fund $79,403.32
Total Other Receipts $79,403.32
Total Historic Preservation Fund $79,403.32
Police Pension Fund Federal and State Grants and Distributions -
Other/3335000 - State Shared Revenue
$607,204.46
Total Taxes and Intergovernmental $607,204.46
Earnings on Investments and Deposits $4,120.75
Total Other Receipts $4,120.75
Total Police Pension Fund $611,325.21
Fire Pension Fund Federal and State Grants and Distributions -
Other/335000 - State Shared Revenue
$632,330.26
Total Taxes and Intergovernmental $632,330.26
Earnings on Investments and Deposits $846.51
Total Other Receipts $846.51
Total Fire Pension Fund $633,176.77
Fire Gift Fund Earnings on Investments and Deposits $1,044.28
Donations, Gifts, and Bequests $32,060.05
Total Other Receipts $33,104.33
Total Fire Gift Fund $33,104.33
Police Gift Earnings on Investments and Deposits $610.02
Donations, Gifts, and Bequests $65,324.78
Total Other Receipts $65,934.80
Total Police Gift $65,934.80
Page 11Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities Parks Gift Fund Earnings on Investments and Deposits $1,373.44
Donations, Gifts, and Bequests $4,291.90
Total Other Receipts $5,665.34
Total Parks Gift Fund $5,665.34
Community Relations Gift Fund Earnings on Investments and Deposits $3,469.76
Donations, Gifts, and Bequests $48,412.03
Other Receipts/360010 - Miscellaneous Revenue $7,500.00
Total Other Receipts $59,381.79
Total Community Relations Gift Fund $59,381.79
Carmel Redev Gift - Dinner Fund Earnings on Investments and Deposits $861.30
Total Other Receipts $861.30
Total Carmel Redev Gift - Dinner Fund $861.30
Carmel Redev Gift-Marketing Donations, Gifts, and Bequests $55,000.00
Total Other Receipts $55,000.00
Total Carmel Redev Gift-Marketing $55,000.00
Grant Fund Federal and State Grants and Distributions - Highways
and Streets
$3,034,604.01
Federal and State Grants and Distributions - Public
Safety
$35,672.27
Total Taxes and Intergovernmental $3,070,276.28
Total Grant Fund $3,070,276.28
Redevelopment Commission Other Taxes/312000 - TIF Revenue $30,102,294.56
Total Taxes and Intergovernmental $30,102,294.56
Rental of Property $886,696.23
Other Charges for Services, Sales, and Fees/360010 -
Miscellaneous Revenue
$1,402,925.30
Total Charges for Services $2,289,621.53
Refunds and Reimbursements $1,096,835.95
Other Receipts/392050 - Pmt in Addn to Taxes $242,944.08
Other Receipts/393000 - Redev Project Sources $977,860.08
Other Receipts/393010 - 4CDC Grant $150,000.00
Total Other Receipts $2,467,640.11
Total Redevelopment Commission $34,859,556.20
Page 12Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities Drug Task Force Federal and State Grants and Distributions - Public
Safety
$96,485.32
Total Taxes and Intergovernmental $96,485.32
Earnings on Investments and Deposits $28,472.64
Other Receipts/360010 - Miscellaneous Revenues $29,362.00
Total Other Receipts $57,834.64
Total Drug Task Force $154,319.96
Rainy Day Transfers In - Transferred from Another Fund $2,864,232.00
Total Other Receipts $2,864,232.00
Total Rainy Day $2,864,232.00
Throughfare Fund Earnings on Investments and Deposits $44,016.20
Grants and Distributions from Non-Governmental
Entities
$170,513.30
Total Other Receipts $214,529.50
Total Throughfare Fund $214,529.50
Keystone Ave Fund Earnings on Investments and Deposits $5,532.05
Total Other Receipts $5,532.05
Total Keystone Ave Fund $5,532.05
Non-Reverting Bicycle Facility Earnings on Investments and Deposits $674.56
Donations, Gifts, and Bequests $9,000.00
Total Other Receipts $9,674.56
Total Non-Reverting Bicycle Facility $9,674.56
Non-Reverting Center Green Ice Rink Other Charges for Services, Sales, and Fees/360010 -
Miscellaneous Revenues
$231,330.11
Total Charges for Services $231,330.11
Earnings on Investments and Deposits $14,596.27
Total Other Receipts $14,596.27
Total Non-Reverting Center Green Ice
Rink
$245,926.38
Page 13Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities Non-Reverting Events & Festivals Rental of Property $4,750.00
Total Charges for Services $4,750.00
Earnings on Investments and Deposits $1,587.09
Donations, Gifts, and Bequests $3,518.78
Other Receipts/360010 - Miscellaneous Receipts $2,596.49
Total Other Receipts $7,702.36
Total Non-Reverting Events &
Festivals
$12,452.36
Non-Reverting Code Enforcement Other Charges for Services, Sales, and Fees/360010 -
Miscellaneous Revenue
$10,000.00
Total Charges for Services $10,000.00
Earnings on Investments and Deposits $613.26
Total Other Receipts $613.26
Total Non-Reverting Code
Enforcement
$10,613.26
Total Governmental Activities $277,216,376.93
Page 14Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
WASTEWATER Wastewater Bond & Interest At Bony Earnings on Investments and Deposits $55,051.26
Other Receipts/396020 - Misc-for bond payments $1,778,000.00
Total Other Receipts $1,833,051.26
Total Wastewater Bond & Interest At
Bony
$1,833,051.26
Sewer Operating Sewage Fees $2,017,255.48
Total Charges for Services $2,017,255.48
Earnings on Investments and Deposits $24,485.69
Transfers In - Transferred from Another Fund $8,327,381.03
Other Receipts/360010 - Misc Rev $3,676.84
Total Other Receipts $8,355,543.56
Total Sewer Operating $10,372,799.04
Sewer Depreciating Transfers In - Transferred from Another Fund $210,088.00
Other Receipts/360010 - Misc Rev $10,993.25
Total Other Receipts $221,081.25
Total Sewer Depreciating $221,081.25
Sewer Connection Fund Earnings on Investments and Deposits $3,029.86
Transfers In - Transferred from Another Fund $3,394.00
Other Receipts/348230 - Connection Fees $529,726.55
Total Other Receipts $536,150.41
Total Sewer Connection Fund $536,150.41
Sewer Availability Fund Earnings on Investments and Deposits $325.42
Other Receipts/348210 - Availability Fees $21,404.53
Total Other Receipts $21,729.95
Total Sewer Availability Fund $21,729.95
Total WASTEWATER $12,984,811.91
Page 15Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
WATER Water Operating Rental of Property $69,232.68
Metered or Measured Sales and Services $18,949,869.63
Total Charges for Services $19,019,102.31
Earnings on Investments and Deposits $63,097.28
Transfers In - Transferred from Another Fund $1,601,357.46
Other Receipts/348010 - User Fees - Sewer Collected $8,376,647.02
Other Receipts/348010 - User Fees - Stormwater
Collected
$3,719,006.16
Other Receipts/348010 - User Fees - Tax Collected $1,184,108.05
Other Receipts/348010 - User Fees - Trash Collected $4,033,636.15
Other Receipts/360010 - Misc Rev $41,423.00
Other Receipts/360010 - Misc Rev - BANS $736,919.90
Other Receipts/396020 - Other Rev $1,144.30
Total Other Receipts $19,757,339.32
Total Water Operating $38,776,441.63
Hydrant Meter Deposit Fund Other Receipts/348250 - Hyd Meter Deposits $800.00
Total Other Receipts $800.00
Total Hydrant Meter Deposit Fund $800.00
Water Depreciation Transfers In - Transferred from Another Fund $462,039.00
Other Receipts/360010 - Misc Rev $80,780.23
Total Other Receipts $542,819.23
Total Water Depreciation $542,819.23
Water Sinking Fund Earnings on Investments and Deposits $34,052.55
Transfers In - Transferred from Another Fund $7,645,000.00
Total Other Receipts $7,679,052.55
Total Water Sinking Fund $7,679,052.55
Water Connection Earnings on Investments and Deposits $25,097.04
Transfers In - Transferred from Another Fund $3,886.00
Other Receipts/348230 - Connection Fees $2,805,355.20
Total Other Receipts $2,834,338.24
Total Water Connection $2,834,338.24
Water Availability Earnings on Investments and Deposits $2,752.10
Other Receipts/348240 - Availability Fees $277,186.38
Total Other Receipts $279,938.48
Total Water Availability $279,938.48
Page 16Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
WATER Water Construction Fund (BAN)Other Receipts/363030 - Bond Proceeds $16,162,859.33
Total Other Receipts $16,162,859.33
Total Water Construction Fund (BAN)$16,162,859.33
Total WATER $66,276,249.46
STORM WATER Stormwater Bond Trustee Accounts Earnings on Investments and Deposits $404,281.74
Other Receipts/360010 - Misc Revenue $90,748.85
Total Other Receipts $495,030.59
Total Stormwater Bond Trustee
Accounts
$495,030.59
Non Reverting Storm Water Transfers In - Transferred from Another Fund $3,670,255.06
Total Other Receipts $3,670,255.06
Total Non Reverting Storm Water $3,670,255.06
Total STORM WATER $4,165,285.65
Page 17Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Carmel Civil City, Hamilton County, Indiana
Disbursements by Fund - 2019
Governmental Activities Carmel City Court Other Disbursements $1,580,716.92
Total Other Disbursements $1,580,716.92
Total Carmel City Court $1,580,716.92
Payroll Fund Payments To or On Behalf of Beneficiaries $69,937,055.12
Total Other Disbursements $69,937,055.12
Total Payroll Fund $69,937,055.12
Redev Commission Trust
Accounts
Professional Services $1,299.96
Total Services and Charges $1,299.96
Payments on Bonds and Other Debt Interest $2,282,205.20
Total Debt service - principal and interest $2,282,205.20
Infrastructure $12,660.21
Total Capital Outlays $12,660.21
Other Disbursements $5,715.09
Total Other Disbursements $5,715.09
Total Redev Commission Trust Accounts $2,301,880.46
2016 GO Bonds Trustee
Accounts
Infrastructure $2,330,751.08
Total Capital Outlays $2,330,751.08
Other Disbursements $36,670.39
Total Other Disbursements $36,670.39
Total 2016 GO Bonds Trustee Accounts $2,367,421.47
Page 18Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities General Salaries and Wages $38,172,132.47
Employee Benefits $17,432,421.55
Total Personal Services $55,604,554.02
Office Supplies $98,236.88
Operating Supplies $526,134.77
Repair and Maintenance Supplies $311,704.34
Other Supplies $330,493.20
Total Supplies $1,266,569.19
Professional Services $2,644,361.06
Communication and Transportation $621,562.98
Printing and Advertising $176,834.49
Insurance $1,513,853.74
Utility Services $1,996,140.70
Repairs and Maintenance $5,578,246.99
Rentals $221,101.45
Other Services and Charges $9,093,428.28
Total Services and Charges $21,845,529.69
Payments on Bonds and Other Debt Principal $8,598,000.00
Payments on Bonds and Other Debt Interest $9,240,020.42
Total Debt service - principal and interest $17,838,020.42
Improvements Other Than Buildings $199,249.45
Machinery, Equipment, and Vehicles $1,367,368.75
Other Capital Outlays $798,384.39
Total Capital Outlays $2,365,002.59
Transfer Out - Transferred To Another Fund $3,943,635.32
Other Disbursements $173,648.19
Total Other Disbursements $4,117,283.51
Total General $103,036,959.42
Ambulance Fund Other Supplies $94,584.41
Total Supplies $94,584.41
Page 19Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities Ambulance Fund Machinery, Equipment, and Vehicles $869,544.40
Other Capital Outlays $307,443.89
Total Capital Outlays $1,176,988.29
Other Disbursements $13,912.85
Total Other Disbursements $13,912.85
Total Ambulance Fund $1,285,485.55
Parks Capital Improvements Other Than Buildings $39,346.86
Total Capital Outlays $39,346.86
Other Disbursements $6,625.80
Total Other Disbursements $6,625.80
Total Parks Capital $45,972.66
Park Impact Fee Fund Other Disbursements $956,501.31
Total Other Disbursements $956,501.31
Total Park Impact Fee Fund $956,501.31
Hazardous Material
Response Fund
Other Disbursements $9,195.34
Total Other Disbursements $9,195.34
Total Hazardous Material Response Fund $9,195.34
Parks Program Fund Salaries and Wages $2,174,983.81
Employee Benefits $675,219.07
Total Personal Services $2,850,202.88
Office Supplies $6,404.46
Operating Supplies $297,730.61
Total Supplies $304,135.07
Professional Services $342,709.15
Communication and Transportation $321,027.00
Printing and Advertising $21,284.09
Repairs and Maintenance $93,894.29
Page 20Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities Parks Program Fund Rentals $1,591.42
Other Services and Charges $81,370.16
Total Services and Charges $861,876.11
Improvements Other Than Buildings $1,537,522.37
Other Capital Outlays $6,486.10
Total Capital Outlays $1,544,008.47
Total Parks Program Fund $5,560,222.53
Parks Monon Fund Salaries and Wages $2,415,348.43
Employee Benefits $579,901.26
Total Personal Services $2,995,249.69
Office Supplies $13,426.15
Operating Supplies $468,312.62
Total Supplies $481,738.77
Professional Services $694,902.04
Communication and Transportation $63,414.33
Printing and Advertising $74,485.74
Insurance $66,089.00
Utility Services $668,708.72
Repairs and Maintenance $675,209.50
Rentals $11,227.16
Other Services and Charges $170,094.18
Total Services and Charges $2,424,130.67
Other Capital Outlays $54,409.86
Total Capital Outlays $54,409.86
Other Disbursements $26,251.45
Total Other Disbursements $26,251.45
Total Parks Monon Fund $5,981,780.44
Parks Facilities Fund Repair and Maintenance Supplies $2,871.14
Page 21Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities Parks Facilities Fund Other Supplies $19,882.60
Total Supplies $22,753.74
Professional Services $7,133.89
Communication and Transportation $2,267.43
Utility Services $22,582.67
Repairs and Maintenance $61,720.95
Other Services and Charges $1,280.00
Total Services and Charges $94,984.94
Improvements Other Than Buildings $25,026.61
Other Capital Outlays $12,723.00
Total Capital Outlays $37,749.61
Total Parks Facilities Fund $155,488.29
Motor Vehicle Highway Salaries and Wages $5,253,123.16
Employee Benefits $2,450,876.32
Total Personal Services $7,703,999.48
Office Supplies $3,838.33
Operating Supplies $245,097.77
Repair and Maintenance Supplies $1,316,635.06
Other Supplies $322,979.27
Total Supplies $1,888,550.43
Professional Services $271,857.73
Communication and Transportation $78,895.35
Utility Services $386,339.45
Repairs and Maintenance $3,376,295.62
Rentals $96,600.64
Other Services and Charges $81,362.27
Total Services and Charges $4,291,351.06
Improvements Other Than Buildings $40,875.00
Machinery, Equipment, and Vehicles $1,038,663.77
Page 22Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities Motor Vehicle Highway Other Capital Outlays $113,058.07
Total Capital Outlays $1,192,596.84
Transfer Out - Transferred To Another Fund $2,690,281.41
Other Disbursements $1,233.00
Total Other Disbursements $2,691,514.41
Total Motor Vehicle Highway $17,768,012.22
Local Road And Street Professional Services $446,169.39
Repairs and Maintenance $6,998,565.86
Total Services and Charges $7,444,735.25
Payments on Bonds and Other Debt Interest $492,264.00
Total Debt service - principal and interest $492,264.00
Land $1,335.50
Total Capital Outlays $1,335.50
Total Local Road And Street $7,938,334.75
Cumulative Capital
Improvement
Professional Services $96,820.15
Repairs and Maintenance $131,670.00
Total Services and Charges $228,490.15
Total Cumulative Capital Improvement $228,490.15
Capital Lease Fund Other Disbursements $2,734,552.64
Total Other Disbursements $2,734,552.64
Total Capital Lease Fund $2,734,552.64
MVH-CRP Repair and Maintenance Supplies $2,302.85
Other Supplies $22,541.97
Total Supplies $24,844.82
Page 23Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities MVH-CRP Repairs and Maintenance $68,142.63
Total Services and Charges $68,142.63
Total MVH-CRP $92,987.45
Deferral Fund Salaries and Wages $35,011.88
Employee Benefits $10,138.58
Total Personal Services $45,150.46
Office Supplies $1,414.57
Total Supplies $1,414.57
Communication and Transportation $5,737.20
Rentals $2,593.20
Total Services and Charges $8,330.40
Other Capital Outlays $6,038.25
Total Capital Outlays $6,038.25
Total Deferral Fund $60,933.68
User Fee Fund Other Services and Charges $102,036.61
Total Services and Charges $102,036.61
Other Disbursements $71,117.00
Total Other Disbursements $71,117.00
Total User Fee Fund $173,153.61
Cumulative Captial
Development
Professional Services $87,904.25
Repairs and Maintenance $282,920.61
Total Services and Charges $370,824.86
Payments on Bonds and Other Debt Principal $1,860,000.00
Page 24Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities Cumulative Captial
Development
Payments on Bonds and Other Debt Interest $1,741,397.00
Total Debt service - principal and interest $3,601,397.00
Other Capital Outlays $4,500.00
Total Capital Outlays $4,500.00
Total Cumulative Captial Development $3,976,721.86
Illinois St Construction
Fund
Improvements Other Than Buildings $6,417.41
Total Capital Outlays $6,417.41
Total Illinois St Construction Fund $6,417.41
MIHP Fund Salaries and Wages $2,095.50
Employee Benefits $902.48
Total Personal Services $2,997.98
Other Disbursements $2,250.53
Total Other Disbursements $2,250.53
Total MIHP Fund $5,248.51
Health Insurance Fund Other Disbursements $13,451,598.69
Total Other Disbursements $13,451,598.69
Total Health Insurance Fund $13,451,598.69
Workers Comp Fund Other Disbursements $378,069.80
Total Other Disbursements $378,069.80
Total Workers Comp Fund $378,069.80
2004 Road Bond Fund Payments on Bonds and Other Debt Principal $2,215,000.00
Page 25Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities 2004 Road Bond Fund Payments on Bonds and Other Debt Interest $648,000.00
Total Debt service - principal and interest $2,863,000.00
Total 2004 Road Bond Fund $2,863,000.00
2016 G.O. Bonds Debt
Service
Payments on Bonds and Other Debt Principal $688,000.00
Payments on Bonds and Other Debt Interest $795,095.00
Total Debt service - principal and interest $1,483,095.00
Total 2016 G.O. Bonds Debt Service $1,483,095.00
Clerk's Record
Perpetuation
Professional Services $2,213.59
Total Services and Charges $2,213.59
Other Capital Outlays $4,633.50
Total Capital Outlays $4,633.50
Total Clerk's Record Perpetuation $6,847.09
JUDICIAL SALARY FEES Office Supplies $4,331.71
Other Supplies $256.32
Total Supplies $4,588.03
Professional Services $38,063.76
Repairs and Maintenance $1,399.10
Rentals $1,872.60
Other Services and Charges $2,045.53
Total Services and Charges $43,380.99
Books and Other Media $1,600.00
Total Capital Outlays $1,600.00
Total JUDICIAL SALARY FEES $49,569.02
Page 26Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities Police Pension Fund Salaries and Wages $1,699.88
Employee Benefits $594,808.88
Total Personal Services $596,508.76
Professional Services $761.50
Insurance $100.00
Total Services and Charges $861.50
Total Police Pension Fund $597,370.26
Fire Pension Fund Salaries and Wages $2,753.92
Employee Benefits $599,608.37
Total Personal Services $602,362.29
Total Fire Pension Fund $602,362.29
Fire Gift Fund Other Disbursements $27,416.58
Total Other Disbursements $27,416.58
Total Fire Gift Fund $27,416.58
Police Gift Other Disbursements $31,755.05
Total Other Disbursements $31,755.05
Total Police Gift $31,755.05
Parks Gift Fund Other Disbursements $13,302.51
Total Other Disbursements $13,302.51
Total Parks Gift Fund $13,302.51
Community Relations Gift
Fund
Other Disbursements $41,638.56
Total Other Disbursements $41,638.56
Total Community Relations Gift Fund $41,638.56
Page 27Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities Carmel Redev Gift -
Dinner Fund
Other Disbursements $31,271.19
Total Other Disbursements $31,271.19
Total Carmel Redev Gift - Dinner Fund $31,271.19
Carmel Redev Gift-
Marketing
Other Disbursements $53.41
Total Other Disbursements $53.41
Total Carmel Redev Gift-Marketing $53.41
Grant Fund Other Services and Charges $3,165,165.57
Total Services and Charges $3,165,165.57
Total Grant Fund $3,165,165.57
Redevelopment
Commission
Professional Services $2,520,655.82
Other Services and Charges $3,144,082.07
Total Services and Charges $5,664,737.89
Payments on Bonds and Other Debt Principal $10,039,491.00
Payments on Bonds and Other Debt Interest $13,443,063.92
Total Debt service - principal and interest $23,482,554.92
Other Capital Outlays $3,460,393.51
Total Capital Outlays $3,460,393.51
Total Redevelopment Commission $32,607,686.32
Drug Task Force Office Supplies $1,874.54
Operating Supplies $60.59
Other Supplies $209.85
Total Supplies $2,144.98
Communication and Transportation $23,170.24
Page 28Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities Drug Task Force Utility Services $17,381.93
Repairs and Maintenance $7,476.25
Rentals $119,508.05
Other Services and Charges $69,665.11
Total Services and Charges $237,201.58
Machinery, Equipment, and Vehicles $12,449.60
Total Capital Outlays $12,449.60
Total Drug Task Force $251,796.16
Non-Reverting Center
Green Ice Rink
Other Services and Charges $270,126.59
Total Services and Charges $270,126.59
Total Non-Reverting Center Green Ice Rink $270,126.59
Non-Reverting Events &
Festivals
Other Services and Charges $20,732.26
Total Services and Charges $20,732.26
Total Non-Reverting Events & Festivals $20,732.26
Total Governmental Activities $282,096,388.14
WASTEWATER Wastewater Bond &
Interest At Bony
Payments on Bonds and Other Debt Principal $1,323,861.00
Payments on Bonds and Other Debt Interest $477,453.75
Total Debt service - principal and interest $1,801,314.75
Total Wastewater Bond & Interest At Bony $1,801,314.75
Sewer Operating Salaries and Wages $3,461,600.65
Total Personal Services $3,461,600.65
Insurance $113,029.50
Total Services and Charges $113,029.50
Payments on Bonds and Other Debt Interest $1,778,000.00
Total Debt service - principal and interest $1,778,000.00
Page 29Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
WASTEWATER Sewer Operating Transfer Out - Transferred To Another Fund $695,300.19
Total Other Disbursements $695,300.19
Chemicals $159,183.90
Contractual Services $695,055.20
Employee Pensions and Benefits $1,698,986.81
Materials and Supplies $534,249.76
Power Production\Purchased Power $397,322.50
Sludge Removal $25,920.00
Transportation $108,962.18
Other Operating $933,615.55
Total Operations $4,553,295.90
Total Sewer Operating $10,601,226.24
Sewer Depreciating Construction $221,080.44
Total Capital Outlays $221,080.44
Total Sewer Depreciating $221,080.44
Sewer Connection Fund Construction $524,868.99
Total Capital Outlays $524,868.99
Transfer Out - Transferred To Another Fund $5,243.46
Total Other Disbursements $5,243.46
Total Sewer Connection Fund $530,112.45
Total WASTEWATER $13,153,733.88
WATER Water Operating Salaries and Wages $4,061,261.21
Total Personal Services $4,061,261.21
Insurance $157,411.50
Total Services and Charges $157,411.50
Transfer Out - Transferred To Another Fund $19,943,363.36
Page 30Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
WATER Water Operating Other Disbursements $5,582,214.25
Total Other Disbursements $25,525,577.61
Chemicals $816,027.29
Contractual Services $1,051,978.71
Employee Pensions and Benefits $1,907,804.65
Materials and Supplies $670,656.36
Power Production\Purchased Power $1,210,630.89
Purchased Water $263,277.95
Transportation $162,156.37
Other Operating $1,949,536.62
Total Operations $8,032,068.84
Total Water Operating $37,776,319.16
Water Depreciation Construction $526,018.80
Total Capital Outlays $526,018.80
Total Water Depreciation $526,018.80
Water Sinking Fund Payments on Bonds and Other Debt Principal $3,191,000.00
Payments on Bonds and Other Debt Interest $3,484,646.74
Total Debt service - principal and interest $6,675,646.74
Total Water Sinking Fund $6,675,646.74
Water Connection Construction $183,899.70
Total Capital Outlays $183,899.70
Transfer Out - Transferred To Another Fund $2,600,000.00
Total Other Disbursements $2,600,000.00
Total Water Connection $2,783,899.70
Page 31Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
WATER Water Availability Construction $27,937.00
Total Capital Outlays $27,937.00
Total Water Availability $27,937.00
Water Construction Fund
(BAN)
Other Disbursements $736,919.90
Total Other Disbursements $736,919.90
Total Water Construction Fund (BAN)$736,919.90
Total WATER $48,526,741.30
STORM WATER Stormwater Bond Trustee
Accounts
Infrastructure $4,175,340.96
Total Capital Outlays $4,175,340.96
Other Disbursements $12,613.29
Total Other Disbursements $12,613.29
Total Stormwater Bond Trustee Accounts $4,187,954.25
Non Reverting Storm
Water
Transfer Out - Transferred To Another Fund $734,051.00
Other Disbursements $2,370,770.00
Total Other Disbursements $3,104,821.00
Contractual Services $165,146.71
Total Operations $165,146.71
Total Non Reverting Storm Water $3,269,967.71
Total STORM WATER $7,457,921.96
Page 32Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Carmel Civil City, Hamilton County, Indiana
Disbursements by Fund with Departments - 2019
Governmental Activities General No Department Transfer Out - Transferred To Another
Fund
$3,943,635.32
Other Disbursements $164,396.46
Total Other Disbursements $4,108,031.78
Total No Department $4,108,031.78
Clerk-Treasurer (City/Town Units Only)Salaries and Wages $695,462.52
Employee Benefits $296,424.86
Total Personal Services $991,887.38
Office Supplies $8,125.97
Operating Supplies $805.88
Total Supplies $8,931.85
Professional Services $72,953.43
Communication and Transportation $11,024.13
Printing and Advertising $1,675.88
Repairs and Maintenance $34,289.03
Rentals $6,552.85
Other Services and Charges $3,843.60
Total Services and Charges $130,338.92
Other Capital Outlays $1,882.86
Total Capital Outlays $1,882.86
Total Clerk-Treasurer (City/Town Units Only)$1,133,041.01
Mayor Salaries and Wages $314,360.54
Page 33Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities General Mayor Employee Benefits $122,416.37
Total Personal Services $436,776.91
Office Supplies $2,887.19
Other Supplies $1,158.34
Total Supplies $4,045.53
Professional Services $425,613.90
Communication and Transportation $20,206.16
Repairs and Maintenance $607.98
Rentals $13,309.76
Other Services and Charges $3,613,027.09
Total Services and Charges $4,072,764.89
Other Capital Outlays $8,775.68
Total Capital Outlays $8,775.68
Total Mayor $4,522,363.01
Board Of Public Works & Safety Salaries and Wages $13,199.68
Employee Benefits $1,009.81
Total Personal Services $14,209.49
Payments on Bonds and Other Debt
Principal
$8,598,000.00
Page 34Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities General Board Of Public Works & Safety Payments on Bonds and Other Debt
Interest
$9,240,020.42
Total Debt service - principal and interest $17,838,020.42
Total Board Of Public Works & Safety $17,852,229.91
Administration Salaries and Wages $291,275.09
Employee Benefits $98,553.07
Total Personal Services $389,828.16
Office Supplies $2,328.16
Operating Supplies $4,543.57
Repair and Maintenance Supplies $23,522.47
Other Supplies $470.83
Total Supplies $30,865.03
Professional Services $2,711.00
Communication and Transportation $3,280.43
Printing and Advertising $160.83
Insurance $1,374,434.74
Utility Services $512,351.78
Repairs and Maintenance $156,477.01
Rentals $6,318.96
Other Services and Charges $226,016.63
Total Services and Charges $2,281,751.38
Machinery, Equipment, and Vehicles $167,589.68
Page 35Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities General Administration Other Capital Outlays $50,839.02
Total Capital Outlays $218,428.70
Total Administration $2,920,873.27
Personnel Salaries and Wages $351,415.18
Employee Benefits $145,650.29
Total Personal Services $497,065.47
Other Supplies $707.06
Total Supplies $707.06
Professional Services $39,994.91
Communication and Transportation $2,297.38
Printing and Advertising $12,281.48
Repairs and Maintenance $4,030.12
Other Services and Charges $9,990.07
Total Services and Charges $68,593.96
Other Capital Outlays $2,498.18
Total Capital Outlays $2,498.18
Total Personnel $568,864.67
City/Town Court (City Judge/Judge)Salaries and Wages $508,942.57
Employee Benefits $177,057.25
Total Personal Services $685,999.82
Total City/Town Court (City Judge/Judge)$685,999.82
Page 36Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities General Law Department Salaries and Wages $609,383.87
Employee Benefits $275,325.93
Total Personal Services $884,709.80
Office Supplies $3,117.17
Total Supplies $3,117.17
Professional Services $561,391.95
Communication and Transportation $19,898.17
Rentals $5,712.54
Other Services and Charges $13,974.02
Total Services and Charges $600,976.68
Other Capital Outlays $13,756.79
Total Capital Outlays $13,756.79
Total Law Department $1,502,560.44
Community Services Salaries and Wages $1,702,827.37
Employee Benefits $814,041.43
Total Personal Services $2,516,868.80
Office Supplies $10,736.90
Operating Supplies $16,469.26
Repair and Maintenance Supplies $4,028.11
Other Supplies $1,086.10
Total Supplies $32,320.37
Professional Services $269,881.01
Communication and Transportation $68,628.56
Printing and Advertising $1,561.33
Repairs and Maintenance $440,502.37
Page 37Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities General Community Services Rentals $16,011.82
Other Services and Charges $61,213.11
Total Services and Charges $857,798.20
Improvements Other Than Buildings $199,249.45
Machinery, Equipment, and Vehicles $25,953.56
Other Capital Outlays $176,206.96
Total Capital Outlays $401,409.97
Other Disbursements $7,626.73
Total Other Disbursements $7,626.73
Total Community Services $3,816,024.07
Communications Department (Radio-Phones-Dispatch)Salaries and Wages $1,312,241.62
Employee Benefits $601,443.77
Total Personal Services $1,913,685.39
Office Supplies $4,814.18
Operating Supplies $5,951.39
Repair and Maintenance Supplies $25,724.91
Other Supplies $6,285.03
Total Supplies $42,775.51
Professional Services $128,692.64
Communication and Transportation $110,676.64
Utility Services $30,054.34
Repairs and Maintenance $2,296,790.42
Rentals $15,689.12
Other Services and Charges $13,550.05
Total Services and Charges $2,595,453.21
Page 38Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities General Communications Department (Radio-Phones-Dispatch)Machinery, Equipment, and Vehicles $33,430.91
Other Capital Outlays $459,891.39
Total Capital Outlays $493,322.30
Total Communications Department (Radio-Phones-Dispatch)$5,045,236.41
Public Affairs Salaries and Wages $620,263.05
Employee Benefits $242,681.91
Total Personal Services $862,944.96
Office Supplies $2,582.92
Other Supplies $2,093.99
Total Supplies $4,676.91
Professional Services $539,416.24
Communication and Transportation $55,288.39
Printing and Advertising $121,381.67
Repairs and Maintenance $37,038.10
Rentals $3,773.15
Other Services and Charges $1,754,485.20
Total Services and Charges $2,511,382.75
Other Capital Outlays $24,663.71
Total Capital Outlays $24,663.71
Total Public Affairs $3,403,668.33
Fire Department Salaries and Wages $16,687,339.91
Employee Benefits $7,421,928.15
Total Personal Services $24,109,268.06
Office Supplies $17,877.17
Page 39Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities General Fire Department Operating Supplies $133,824.25
Repair and Maintenance Supplies $108,344.41
Other Supplies $29,817.05
Total Supplies $289,862.88
Professional Services $124,404.84
Communication and Transportation $144,978.78
Printing and Advertising $4,734.61
Insurance $96,415.00
Utility Services $303,133.93
Repairs and Maintenance $708,337.96
Rentals $15,718.28
Other Services and Charges $325,223.10
Total Services and Charges $1,722,946.50
Total Fire Department $26,122,077.44
Police Department (Town Marshall)Salaries and Wages $12,445,486.05
Employee Benefits $6,145,904.96
Total Personal Services $18,591,391.01
Office Supplies $20,470.76
Operating Supplies $331,275.38
Repair and Maintenance Supplies $40,466.29
Other Supplies $164,626.92
Total Supplies $556,839.35
Professional Services $197,729.54
Communication and Transportation $125,783.02
Printing and Advertising $9,435.14
Insurance $50.00
Utility Services $248,544.40
Repairs and Maintenance $299,046.20
Page 40Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities General Police Department (Town Marshall)Rentals $97,763.37
Other Services and Charges $269,012.49
Total Services and Charges $1,247,364.16
Machinery, Equipment, and Vehicles $969,168.93
Other Capital Outlays $19,234.94
Total Capital Outlays $988,403.87
Other Disbursements $200.00
Total Other Disbursements $200.00
Total Police Department (Town Marshall)$21,384,198.39
Redevelopment Salaries and Wages $390,176.81
Employee Benefits $136,209.68
Total Personal Services $526,386.49
Office Supplies $5,985.76
Total Supplies $5,985.76
Professional Services $15,864.75
Communication and Transportation $17,538.89
Printing and Advertising $4,734.62
Insurance $1,000.00
Utility Services $7,738.21
Repairs and Maintenance $13,918.03
Rentals $8,019.20
Other Services and Charges $175.00
Total Services and Charges $68,988.70
Page 41Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities General Redevelopment Other Capital Outlays $3,636.05
Total Capital Outlays $3,636.05
Total Redevelopment $604,997.00
Parks Salaries and Wages $1,558,587.40
Employee Benefits $695,271.11
Total Personal Services $2,253,858.51
Office Supplies $15,454.71
Operating Supplies $21,878.63
Repair and Maintenance Supplies $60,187.28
Other Supplies $21,713.81
Total Supplies $119,234.43
Professional Services $159,281.38
Communication and Transportation $23,456.75
Printing and Advertising $5,444.44
Insurance $39,756.00
Utility Services $138,967.34
Repairs and Maintenance $612,826.55
Rentals $9,504.94
Other Services and Charges $42,310.37
Total Services and Charges $1,031,547.77
Machinery, Equipment, and Vehicles $26,371.62
Page 42Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities General Parks Other Capital Outlays $28,404.55
Total Capital Outlays $54,776.17
Total Parks $3,459,416.88
Golf Salaries and Wages $523,736.25
Employee Benefits $138,048.31
Total Personal Services $661,784.56
Office Supplies $3,591.05
Operating Supplies $9,503.74
Repair and Maintenance Supplies $29,795.87
Other Supplies $39,388.55
Total Supplies $82,279.21
Professional Services $39,562.99
Communication and Transportation $9,595.97
Printing and Advertising $15,424.49
Insurance $2,198.00
Utility Services $49,283.36
Repairs and Maintenance $173,866.10
Rentals $22,727.46
Other Services and Charges $96,427.67
Total Services and Charges $409,086.04
Machinery, Equipment, and Vehicles $144,854.05
Page 43Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities General Golf Other Capital Outlays $6,165.27
Total Capital Outlays $151,019.32
Other Disbursements $1,425.00
Total Other Disbursements $1,425.00
Total Golf $1,305,594.13
Information Technology Professional Services $5,206.43
Repairs and Maintenance $327.00
Other Services and Charges $2,944.30
Total Services and Charges $8,477.73
Other Capital Outlays $66.00
Total Capital Outlays $66.00
Total Information Technology $8,543.73
Common Council Salaries and Wages $147,434.56
Employee Benefits $120,454.65
Total Personal Services $267,889.21
Office Supplies $264.94
Other Supplies $698.70
Total Supplies $963.64
Professional Services $31,257.02
Communication and Transportation $8,909.71
Page 44Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities General Common Council Other Services and Charges $87,489.77
Total Services and Charges $127,656.50
Other Capital Outlays $2,362.99
Total Capital Outlays $2,362.99
Total Common Council $398,872.34
City Property Maintenance Repair and Maintenance Supplies $19,635.00
Other Supplies $62,446.82
Total Supplies $82,081.82
Professional Services $28,431.42
Utility Services $130,704.90
Repairs and Maintenance $800,190.12
Total Services and Charges $959,326.44
Total City Property Maintenance $1,041,408.26
Building Operations Operating Supplies $1,882.67
Total Supplies $1,882.67
Professional Services $1,967.61
Utility Services $575,362.44
Other Services and Charges $2,573,745.81
Total Services and Charges $3,151,075.86
Total Building Operations $3,152,958.53
Page 45Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Total General $103,036,959.42
Total Governmental Activities Disbursements for Funds with Departments $103,036,959.42
Page 46Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Debt Class Description or Purpose
Beginning
Principal Balance
as of
Jan. 1, 2019
Additions Reductions Ending Principal
Balance as of
Dec. 31, 2019
Principal and
Interest
Due in 2020
Governmental Activities Revenue Bonds Redevelopment District Tax
Increment Revenue Bonds,
Series 2004 A (Clarian
Hospital) Illinois Street Project
$3,830,000.00 $0.00 $670,000.00 $3,160,000.00 $913,503.00
Revenue Bonds County Option Income Tax
Revenue Refunding Bonds of
2011 (Street department)
$2,925,000.00 $0.00 $695,000.00 $2,230,000.00 $762,618.00
Revenue Bonds 2013 Illinois St Project Bond $6,000,000.00 $0.00 $305,000.00 $5,695,000.00 $534,200.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,129,000.00 $0.00 $45,000.00 $1,084,000.00 $98,470.00
General Obligation Bonds City of Carmel GO Bond
Series 2016B
$1,012,000.00 $0.00 $41,000.00 $971,000.00 $88,230.00
General Obligation Bonds City of Carmel GO Bond
Series 2016C
$1,519,000.00 $0.00 $61,000.00 $1,458,000.00 $132,887.50
General Obligation Bonds City of Carmel GO Bond
Series 2016D
$1,276,000.00 $0.00 $51,000.00 $1,225,000.00 $111,047.50
General Obligation Bonds City of Carmel GO Bond
Series 2016E
$1,487,000.00 $0.00 $60,000.00 $1,427,000.00 $129,475.00
General Obligation Bonds City of Carmel GO Bond
Series 2016F
$1,467,000.00 $0.00 $59,000.00 $1,408,000.00 $126,592.50
General Obligation Bonds City of Carmel GO Bond
Series 2016G
$1,276,000.00 $0.00 $51,000.00 $1,225,000.00 $111,047.50
General Obligation Bonds City of Carmel GO Bond
Series 2016H
$1,467,000.00 $0.00 $59,000.00 $1,408,000.00 $126,592.50
General Obligation Bonds City of Carmel GO Bond
Series 2016I
$1,326,000.00 $0.00 $53,000.00 $1,273,000.00 $115,290.00
General Obligation Bonds City of Carmel GO Bond
Series 2016J
$1,407,000.00 $0.00 $57,000.00 $1,350,000.00 $121,900.00
General Obligation Bonds City of Carmel GO Bond
Series 2016K
$1,296,000.00 $0.00 $52,000.00 $1,244,000.00 $112,935.00
General Obligation Bonds City of Carmel GO Bond
Series 2016L
$1,286,000.00 $0.00 $51,000.00 $1,235,000.00 $111,527.50
General Obligation Bonds City of Carmel GO Bond
Series 2016M
$1,126,000.00 $0.00 $45,000.00 $1,081,000.00 $98,350.00
Revenue Bonds City of Carmel Redevelopment
District Taxable Bonds of 2016
(City Center II Projects)
$18,830,000.00 $0.00 $165,000.00 $18,665,000.00 $1,046,756.86
Notes and Loans Payable City of Carmel Monon and
Main Installment Purchase
Contract
$3,797,033.00 $166,967.00 $0.00 $3,964,000.00 $319,000.00
Carmel Civil City, Hamilton County, Indiana
Debt Statement - 2019
Page 47Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities Revenue Bonds City of Carmel Taxable
Economic Development Lease
Rental Revenue Bonds 2018A
$12,645,000.00 $0.00 $0.00 $12,645,000.00 $0.00
SubTotal $67,434,326.05 $166,967.00 $2,520,000.00 $65,081,293.05 $5,060,422.86
Debt Class Description or Purpose
Beginning
Principal Balance
as of
Jan. 1, 2019
Additions Reductions Ending Principal
Balance as of
Dec. 31, 2019
Principal and
Interest
Due in 2020
WASTEWATER Revenue Bonds 2005 Wastewater Plant
Expansion
$5,065,000.00 $0.00 $544,000.00 $4,521,000.00 $756,188.40
Revenue Bonds 2009 Wastewater Expansion
SRF
$3,498,420.00 $0.00 $284,861.00 $3,213,559.00 $298,954.22
Revenue Bonds 2012 Wastewater Revenue $8,700,000.00 $0.00 $495,000.00 $8,205,000.00 $745,875.00
SubTotal $17,263,420.00 $0.00 $1,323,861.00 $15,939,559.00 $1,801,017.62
Debt Class Description or Purpose
Beginning
Principal Balance
as of
Jan. 1, 2019
Additions Reductions Ending Principal
Balance as of
Dec. 31, 2019
Principal and
Interest
Due in 2020
WATER Revenue Bonds 2012 Jr Waterworks Rev
Bonds
$17,155,000.00 $0.00 $775,000.00 $16,380,000.00 $1,459,800.00
Revenue Bonds 2016 Waterworks Special
Program Bonds
$51,595,000.00 $0.00 $1,895,000.00 $49,700,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
$12,488,000.00 $0.00 $521,000.00 $11,967,000.00 $874,891.00
Revenue Bonds 2019 Waterworks Revenue
Bond Anticipation Notes
$0.00 $17,745,000.00 $0.00 $17,745,000.00 $356,792.80
SubTotal $101,882,479.30 $17,745,000.00 $3,191,000.00 $116,436,479.30 $7,329,815.06
Debt Class Description or Purpose
Beginning
Principal Balance
as of
Jan. 1, 2019
Additions Reductions Ending Principal
Balance as of
Dec. 31, 2019
Principal and
Interest
Due in 2020
STORM WATER Revenue Bonds City of Carmel Storm Water
District Bonds, Series 2016
$27,276,000.00 $0.00 $1,096,000.00 $26,180,000.00 $2,372,295.00
SubTotal $27,276,000.00 $0.00 $1,096,000.00 $26,180,000.00 $2,372,295.00
GRAND TOTAL $213,856,225.35 $17,911,967.00 $8,130,861.00 $223,637,331.35 $16,563,550.54
Page 48Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Carmel Civil City, Hamilton County, Indiana
Deficit Fund Balance Report - 2019
Enterprise
Name Fund Name
Ending Cash and
Investment
Balance
Total deficit fund balances
Page 49Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Lessor Description or Purpose
Annual Lease
Payment Due
in 2020
Lease
Begining
Date
Lease
Ending
Date
Governmental Activities (General)RG Schedule 2, Police Police Computer Equipment $30,992.16 06/16/2016 01/15/2021
RG Schedule 2, Street Street Pick-Up Trucks and Snow Plows $77,711.78 06/16/2016 01/15/2021
RG Schedule 2, Engineering Engineering Vehicle $5,202.56 06/16/2016 01/15/2021
RG Schedule 3, Street Salt Trucks $191,978.22 11/14/2016 01/15/2022
RG Schedule 3, Repurpose Flat Bed
Truck
Flatbed Truck $2,810.70 11/14/2016 01/15/2022
RG Schedule 4, Fire Department Ambulance $48,620.66 02/16/2017 01/15/2022
RG Schedule 4, Administration Ford F-250 $6,868.06 02/16/2017 01/15/2022
RG Schedule 4, Information Systems IS Hardward and Security Camera DVRs (3)$24,906.02 02/16/2017 01/15/2022
RG Schedule 4, Golf Course Telephone System, Mowers (4) and Lawn
Equipment
$61,610.77 02/16/2017 01/15/2022
RG Schedule 4, City Council Audio Video Equipment $84,723.76 02/16/2017 01/15/2022
RG Schedule 4, Police Vehicle Equipment $17,387.11 02/16/2017 01/15/2022
RG Schedule 5, Police Ford Interceptors (21) Mobile Data
Computers (33) and Emergency Equipment
$177,691.14 02/16/2017 01/15/2022
RG Schedule 5, Information Systems Ford Explorer $4,718.52 02/16/2017 01/15/2022
RG Schedule 6, Police Police Computer Equipment $4,765.52 08/09/2017 07/15/2022
RG Schedule 6, Street Ford Trucks and Street Sweeper $110,988.64 08/09/2017 07/15/2022
RG Schedule 7, DOCS Vehicles Toyota and Honda Vehicles $25,953.56 10/13/2017 07/15/2022
RG Schedule 7, DOCS BIke Locker, Post and Counter $4,269.04 10/13/2017 07/15/2022
RG Schedule 7, Information Systems Conduit and Cabling for Christkindlmart $12,204.55 10/13/2017 07/15/2022
RG Schedule 1, IT IT Assets $25,815.40 05/05/2016 01/15/2021
2010 Fire department (schedule 7)Purchase Fire Trucks $143,047.94 02/15/2011 08/15/2020
RG Schedule 2, Police Police Vehicles $117,545.88 06/16/2016 01/15/2021
RG Schedule 3, Police Police Mobile Data Computers $28,239.46 11/14/2016 01/15/2022
2018 RG Schedule 9, Golf Cars Electric Golf Cars, Club Car and Range
Picker
$53,821.76 04/10/2018 01/15/2022
2018 RG Schedule 10, Police Vehicles Police Vehicles $155,947.74 05/08/2018 01/15/2022
2015 Street Department (schedule 26)Street Department Vehicles $211,800.00 10/15/2015 10/15/2020
2015 Fire Department (schedule 29)Pumper Trucks $129,150.00 08/15/2015 02/15/2026
2018 RG Schedule 10, Police
Equipment
Police Equipment $72,355.70 05/08/2018 01/15/2023
RG Schedule 3, Air Cart Air Cart $17,531.30 11/14/2016 01/15/2022
Carmel Civil City, Hamilton County, Indiana
Leases 2019
Page 50Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Governmental Activities (General)RG Schedule 3, Street Sign Truck $31,605.44 11/14/2016 01/15/2022
2018 RG Schedule 8, Council Chambers Carpeting, Dais and Remodel, Elevator and
Roof Repair
$90,794.89 01/10/2018 01/15/2021
2018 RG Schedule 10, IT Vehicles Vehicles and Plow Package $14,078.50 05/08/2018 01/15/2023
2018 RG Schedule 11, Street Bobcats and Attachments $65,328.34 05/18/2018 01/15/2023
2018 RG Schedule 13, Administration Dodge Ram 2500 Pickup Truck $2,884.92 08/13/2018 07/15/2023
2018 RG Schedule 14, Fire Department Tail Coats and Pants $87,443.12 09/12/2018 07/15/2023
2018 RG Schedule 15, Fire Department 2011 Pierce Model Arrow XT Aerial Ladder
Truck
$42,110.08 12/07/2018 07/15/2028
2018 RG Schedule 12, Information
Systems
HP Enterprise Model D3710 Disk Drive $8,917.72 07/24/2018 07/15/2023
2019 RG Schedule 16, IT Department Network Video Recorder Upgrades $10,249.36 01/22/2019 01/15/2024
2019 RG Schedule 17, Fire Department Braun Chief XLI Ambulance $27,488.46 02/22/2019 01/15/2029
2019 RG Schedule 19, Police Defibrillators, Radios and Computer
Equipment
$33,898.18 03/11/2019 01/15/2024
2019 RG Schedule 20, Information
Systems
HP Enterprise BTO HW $26,643.78 04/11/2019 01/15/2024
2019 RG Schedule 21, Information
Systems
2019 Chevy Tahoe and 2020 Ford Explorer $14,878.56 04/19/2019 01/15/2024
2019 RG Schedule 22, Information
Systems
Licenses, Drive Enclosures and Servers $49,129.52 04/19/2019 01/15/2024
2019 RG Schedule 23, Information
Systems
Cityworks $146,550.56 06/21/2019 01/15/2024
2019 RG Schedule 24, Police Vehicle RAM Pickup Truck Crew Cab 4x4 $5,787.82 07/15/2019 07/15/2024
2019 RG Schedule 25, Fire Department 2020 Pierce Pumper $71,295.72 08/02/2019 07/15/2024
2019 RG Schedule 26, Police Vehicles Police Vehicles, Various Per Schedule $109,088.88 09/13/2019 07/15/2024
2019 RG Schedule 27, Police
Equipment
Police Equipment, Various Per Schedule $47,064.54 09/13/2019 07/15/2023
2018 RG Schedule 28, Street 2020 M3 Street Sweeper $45,351.48 12/06/2019 07/15/2024
Total Governmental Activities (General) $2,779,247.82
WASTEWATER (Wastewater Utility)RG Schedule 2, Sewer Vehicles $46,479.95 06/16/2016 01/15/2021
Total WASTEWATER (Wastewater Utility) $46,479.95
WATER (Water Utility)RG Schedule 2, Water Vehicles $55,515.20 06/16/2016 01/15/2021
RG Schedule 6, Water Vehicles $71,875.19 08/09/2017 07/15/2022
2019 RG Schedule 18, Utilities Hydro Excavator and Freightliner $50,776.52 03/04/2019 01/15/2029
Total WATER (Water Utility) $178,166.91
GRAND TOTAL $3,003,894.68
Page 51Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Carmel Civil City, Hamilton County, Indiana
Other Post-Employment Benefits (OPEB) 2019
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 0.08
Current Number of Participants
Inactive employees or beneficiaries currently receiving benefit payments 45
Inactive employees entitled to but not yet receiving benefits 0
Active employees 620
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.08%
Plan Members (e.g. 99.99)0.04%
Annual Covered Payroll (e.g. 9999.99)$50,056,360.99
Cost Method for Funding Purposes Pay as you go
Page 52Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Carmel Civil City, Hamilton County, Indiana
Transfers - 2019
Fund Amount
General $3,943,635.32
Motor Vehicle Highway $2,690,281.41
Non Reverting Storm Water $734,051.00
Water Operating $19,943,363.3
6
Water Connection $2,600,000.00
Sewer Operating $695,300.19
Sewer Connection Fund $5,243.46
Total Transfers Out $30,611,874.7
4
Transfers In
(Receipts)
Transfers Out
(Disbursements)
Fund Amount
Wastewater Bond & Interest At Bony $0.00
General $1,455,506.46
Motor Vehicle Highway $1,734,051.00
MVH-CRP $2,555,281.41
Non Reverting Storm Water $3,670,255.06
Historic Preservation Fund $79,403.32
Water Operating $1,601,357.46
Water Depreciation $462,039.00
Water Sinking Fund $7,645,000.00
Water Connection $3,886.00
Sewer Operating $8,327,381.03
Sewer Depreciating $210,088.00
Sewer Connection Fund $3,394.00
Rainy Day $2,864,232.00
Total Transfers In $30,611,874.74
Page 53Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Carmel Civil City, Hamilton County, Indiana
Transfer Schedule Report - 2019
Fund Transfer From
- Total
-
30,611,87
5
30,611,875
Total
30,611,87
5$$30,611,875
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.)
From Fund 101 to Fund 201 $1,000,000 Resolution 04-15-19-04
From Fund 101 to Fund 912 $2,864,232 Resolution 10-21-19-01
From Fund 101 to Fund 507 $79,403.32 Resolution 12-16-19-06
From Fund 201 to Fund 201 $135,000 Resolution 11-18-19-01
From Fund 201 to Fund 205 $2,555,281.41 to establish and true-up new state required fund (transfer only).
Page 54Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Carmel Civil City, Hamilton County, Indiana
Grants - 2019
Local Project Name/
Description
Federal
Program
Title/Project
Name
Federal Agency
Pass
Through
Agency
CFDA
Number 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
DUI Enforcement Highway
Safety
Cluster
Department of
Transportation
Hamilton
County
20.616 ICJI Fiscal
Year 2019 DUI
Task Force
69A375183
0000405DI
N0
Reimbursemen
t Grant
$4,012.79 $4,012.79 $0.00 $0.00 $0.00 $0.00
116th Street & Hazel
Dell Parkway
Highway
Planning and
Construction
Cluster
Department of
Transportation
INDOT 20.205 Federal-Aid
Highway
Program
1297561 Reimbursemen
t Grant
$4,093.55 $4,093.55 $0.00 $0.00 $0.00 $0.00
OPO/BCC Seatbelt
Enforcement
Highway
Safety Cluster
Department of
Transportation
Hamilton
County
20.600 ICJI Fiscal
Year 2019
Operation Pull
Over
69A375193
00004020I
N0
Reimbursemen
t Grant
$5,523.78 $5,523.78 $0.00 $0.00 $0.00 $0.00
DUI OPO Seatbelt
Enforcement Blitz 97
Highway
Safety
Cluster
Department of
Transportation
Hamilton
County
20.600 OPP/Aggressi
ve Driving
69A375193
00004020I
N0
Reimbursemen
t Grant
$2,479.60 $2,479.60 $0.00 $0.00 $0.00 $0.00
DUI OPO Seatbelt
Enforcement Blitz 98
HIghway
Safety
Cluster
Department of
Transportation
Hamilton
County
20.600 OPO/Aggressi
ve Driving
69A375193
00004020I
N0
Reimbursemen
t Grant
$2,573.31 $2,573.31 $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
$77,660.10 $77,660.10 $0.00 $0.00 $0.00 $0.00
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
$13,875.00 $13,875.00 $0.00 $0.00 $0.00 $0.00
Page 55Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Carmel Civil City, Hamilton County, Indiana
Capital Assets 2019
Government/
Enterprise
Asset Type Beginning
Balance
Additions Reductions Ending Balance
Governmental Activities Land $191,867,046.00 $1,282,666.00 $71,213.00 $193,078,499.00
Infrastructure $394,512,288.11 $32,488,814.57 $3,245,519.50 $423,755,583.18
Building $217,669,654.22 $652,601.13 -$218,322,255.35
Improvement $24,749,016.78 $1,105,290.30 -$25,854,307.08
Machinery $47,658,606.00 $2,608,947.19 $5,337,272.11 $44,930,281.08
Construction $195,380,922.00 $27,265,485.06 -$222,646,407.06
Books ----
WASTEWATER Land $166,322.35 --$166,322.35
Infrastructure $51,908,323.38 $121,450.00 -$52,029,773.38
Building $43,228,063.57 $802,891.43 -$44,030,955.00
Improvement ----
Machinery $12,387,010.29 $368,644.61 $32,826.04 $12,722,828.86
Construction $4,910,659.68 $1,318,566.68 -$6,229,226.36
Books ----
WATER Land $3,964,659.25 --$3,964,659.25
Infrastructure $141,613,474.48 $1,066,574.36 $69,207.33 $142,610,841.51
Building $59,866,447.31 $917,195.37 -$60,783,642.68
Improvement ----
Machinery $12,106,354.45 $1,023,870.45 $207,461.67 $12,922,763.23
Construction $7,534,795.14 $1,355,046.13 -$8,889,841.27
Books ----
STORM WATER Land ----
Infrastructure $21,617,266.89 --$21,617,266.89
Building ----
Improvement ----
Machinery ----
Construction ----
Page 56Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
STORM WATER Books ----
Page 57Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Carmel Civil City, Hamilton County, Indiana
Accounts Payable/Receivable Statement - 2019
Government or Enterprise
Accounts
Payable
Accounts
Receivable
Governmental Activities $0.00 $0.00
WASTEWATER $670,686.64 $1,741,754.63
WATER $491,385.80 $1,490,692.56
STORM WATER $0.00 $0.00
Page 58Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Carmel Civil City, Hamilton County, Indiana
Financial Assistance to Non Governmental Entities - 2019
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
#1930
Indianapolis IN Marion Craig Mince 812-236-9260 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 Clay Historical
Society
31-0908428 211 1st Avenue SW Carmel IN Hamilton Emily Ehrgott 317-441-6553 State or Local Grant $6,560.00 HISTORICAL SOCIETY
Carmel Community Players 35-1898503 14299 Clay Terrace Blvd 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 John Eaton 317-694-1310 State or Local Grant $12,000.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 $25,500.00 ORCH./SYMPHONY/TH
EATRE
Carmel Symphony Orchestra 31-0918565 760 3rd Avenue SW Carmel IN Hamilton Alan Davis 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-660-3379 State or Local Grant $230,000.00 ART
FOUNDATIONS/CENTE
RS
Gregory Hancock Dance
Theatre
35-1722088 329 Gradle Drive Carmel IN Hamilton Gregory Hancock 317-650-6249 State or Local Grant $59,500.00 ORCH./SYMPHONY/TH
EATRE
Indiana Association of
Chinese-Amer
23-1156805 PO Box 3888 Carmel IN Hamilton May 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 Camille Nicodemus 317-985-2868 State or Local Grant $20,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 $41,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
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 Michael Pettry 317-940-9057 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
Page 59Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Name Federal
Tax ID
Street Address City/State County Operating
Officer Name
Phone Description Amount Type
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 $80,000.00 ORCH./SYMPHONY/TH
EATRE
Page 60Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Carmel Civil City, Hamilton County, Indiana
Pensions - 2019
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 61Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org
Carmel Civil City, Hamilton County, Indiana
Form 9 Fund Names 2019
Fund #Fund Name
Page 62Printed: 9/22/2020 8:34:43 AMIndiana Gateway Report
gateway.ifionline.org