Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
2014 Annual Financial Report
2014 City of Carmel Annual Financial Report March 2, 2015 Schedule of Officials, 2014 Carmel Civil City, Hamilton County, Indiana !Legal Name of City CARMEL CIVIL CITY Primary Contact Person Cindy Sheeks 'County City Resides In Hamilton ;Office Address 11 Civic Square Carmel, IN 46032 ;Office Phone 317-571-2428 Fax 317-571-2410 Email Address csheeks @carmel.in.gov OFFICIALS: Please complete the following with names, dates and addresses of officials. Make sure to include the entire term for elected officials. Others will be on an annual basis. 1Controller/Clerk Treasurer (Name) !Diana L. Cordray Current Term Begin Date 01/01/2012 !Current Term End Date 12/31/2015 'Beginning Date of Initial Term 01/01/1996 Current Home Address 11843 Stoney Bay Circle Carmel, IN 46033 Email dcordray @carmel.in.gov �P/ease list prior Controller, if person held position since prior audit. Name Term !Current Home Address !Email 1 ,Clerk(Name) !Current Term Begin Date Current Term End Date !Current Home Address !Email Please list prior Clerk, if person held position since prior audit. Current Home Address 12662 Royce Court Carmel IN 46033 Email i]brainard@carmel.in.gov 1 Please list prior Mayor, if person held position since prior audit. Name Term Current Home Address Email Superintendent of Utilities (Name) John Duffy Enterprise Name Carmel Utilities (water and sewer) 'Current Term Begin Date Current Term End Date Current Home Address 11507 Rolling Court Carmel IN 46033 !Email jduffy@carmel.in.gov Please list prior Superintendent, if person held position since prior audit. Name Term Current Home Address EmaU T4 L 1President of Common (City) Council (Name) RICHARD SHARP Current Term Begin Date 01/01/2012 :Current Term End Date 12/31/2015 Current Home Address 1481 STORMY RIDGE COURT CARMEL IN 46032 !Email rsharp©carmeldnogov Please list-prior President of Common (City) Council, if person held position since prior audit. Name ERIC SEIDENSTICKER Term 01/01/2012 Current Home Address 316 CONCORD LANE CARMEL IN 46032 eseidensticker@carmel.in.gov 1 Current Home Address Email 1President of Utility Service Board (Name) :Current Term Begin Date Current Term End Date ICurrent Home Address I Email ;Please list prior person, if person held position since prior audi. ITerm Current Home Address ,The Data Universal Numbering System (DUNS) number ts a unique nine-digit identification number provided by Dun ;8( Bradstreet (D&B). Please make sure to include all DUNS numbers assigned to the unit. The Federal government requrres that all applicants for Federal grants and cooperative agreements have a DUNS number.To verity that you have a DUNS number or to take the steps necessary to obtain one call D&B using the toll-free number, 1-866-705-5711. | --- --' | |DUNSNumber 087033320 / DUNS Number DUNS Number Federal Employer Identification Number (EIN) is a unique nine-digit number assigned by the Internal Revenue Service (IRS) to business entities operating in the United States for the purposes of identification. Please make sure to include all ID numbers assigned to the unit. 1Federal EIN Number 356000972 ;Federal EIN Number 'Federal EIN Number Carmel Civil City, Hamilton County, Indiana Unit Questions 2014 Please answer all of the questions below by clicking Yes or No as appropriate. Please make sure you answer the questions correctly as they will determine the information required for you to complete your annual report. 1. Has your unit received or disbursed any Federal money from grants? The amount of Federal funding that is received or disbursed during the year affects the type of engagement that you are required to have performed by the State Board of Accounts as well as the Yes format and content of the Financial Statements. Click below for more information on grants. 2. Did your unit disburse money for financial assistance to non-governmental entities? Examples include Volunteer Fire Departments, 4H, YMCA, Youth Leagues, Senior Citizen Centers, etc. Yes Do not consider amounts you paid for goods or services in answering this question. 3. Does your unit have any Utilities or other Enterprises? Governmental units often provide services that are operated like a business and charge fees to external users for goods or services rather than receiving tax dollars. These activities are called Enterprises. The Yes most common Enterprises are utilities such as Water and Wastewater. Other types of Enterprises could include Public Transportation, Convention Centers, Parking Garages, Airports, Internet Services, etc. 4. Does your unit departmentalize? Departments are areas of responsibility within a unit that do not act like enterprises. Examples of Yes departments include: Auditor, Sheriff, Mayor. 5. Does your unit have any outstanding debt? Debt can be in the form of bonds, notes, loans, or judgments payable over more than one year. Leases Yes are considered separately (see question 6 below). 6. Does your unit have any outstanding leases? A contract by which one party conveys land, property, services, etc., to another for a specified time, Yes usually in return for a periodic payment. 7. Do you maintain records listing the types and values of assets owned by the unit? Assets include land, buildings, infrastructure, vehicles, equipment, etc. Yes 8. Do you have data files from your accounting system to upload your beginning fund balances, receipts and disbursements? You must get these files from your vendor's accounting system. If you have questions on how to get No these files, please contact your vendor. 9. Does your unit have any contracts that you would like to upload for the public to view? No Pension Report, 2014 Carmel Civil City, Hamilton County, Indiana 1. Please indicate if your unit offers any of these pension plans to your YES NO Employees. Check all that apply. 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 Carmel Civil City, Hamilton County, Indiana Capital Assets 2014 Improvements Machinery, Other Than Equipment, Construction Books Government or Enterprise Land Infrastructure Building Buildings and Vehicles in Progress and Other Total Governmental Activities(General) $21,048,951.00° $496,426,603.00 $216,827,218.00 $13,172,501.00 $28,828,095 00 $0.00 $1,755,049.00' $778,058,417.00 STORM WATER(Storm Water Utility) $0.00 S0.00 $0.00 $0.00 $0 00. $0.00 $0 00 $0.00 WASTEWATER(Wastewater Utility) ! $117,690.68. $47,343,280.97 $37,513,873.58 $0.00: $11,159,94138.1 $12,472,755.95 $0.00,, $108,607,542.56 WATER(Water Utility) $2,981,507 98 $133,714,181.83 $58,663,806.09 $0.00: $9,770,526.08'; $9,688,865.11 $0 00+ $214,818,887.09 TOTAL $24,148,149.661 $677,484,065.80 $313,004,897.67 $13,172,501.00 $49,758,562.46 $22,161,621.06 $1,755,049.00= $1,101,484,846.65 312/2015 8:59:12 AM Page 1 Carmel Civil City, Hamilton County, Indiana Cash Fund Statement-2014 Local Fund Local Fund Name Beg Cash Bal Receipts Disbo sements End Cash Bal Number Jan 1,2014 Dec 31,2014 Governmental\ ctivities 0 Carmel City Court $166,160.23 $1,995,101.24 $1,971,032.18 $190,229.29 0 Payroll Fund $205,466.05 $47,916,187.13 $48,011,749.69 $109,903.49 1 General $3,704,739.68 $72,310,654.95 $71,466,359.49 $4,549,035.14 102 Ambulance Fund $789,015.28 $1,047,093.39 $1,009,302.43 $826,806.24 103 Parks Capital $459,849.04 $477.93 $921.60 $459,405.37 106 Park Impact Fee Fund $1,878,024.77 $1,146,089.32 $1,283,676.08 $1,740,438.01 107 Hazardous Material Response Fund $8,297.80 $4,896.51 $0.00 $13,194.31 108 Parks Program Fund $1,753,464.01 $3,651,159.59 $3,319,765.40 $2,084,858.20 109 Parks Monon Fund $1,844,468.15 $4,805,282.12 $4,752,401.36 $1,897,348.91 201 Motor Vehicle Highway $2,933,641.73 $12,332,848.73 $12,574,140.84 $2,692,349.62 202 Local Road And Street $662,309.79 $1,171,939.83 $1,406,630.74 $427,618.88 203 Cumulative Capital Improvement $386,401.49 $209,759.68 $576,550.54 $19,610.63 206 Cumulative Capital Sewer $527,758.36 $532.92 $242,734.34 $285,556.94 209 Deferral Fund $576,185.72 $105,896.17 $94,929.33 $587,152.56 210 User Fee Fund $132,684.68 $107,626.36 $102,265.15 $138,045.89 211 Cumulative Captial Development $975,156.10 $1,779,367.17 $2,592,000.27 $162,523.00 212 Illinois St Construction Fund $3,822,472.92 $275,358.50 $1,896,103.20 $2,201,728.22 220 Barrett Law Fund $5.67 $0.00 $0.00 $5.67 221 Barrett Law Surplus $165,695.35 $172.28 $0.00 $165,867.63 301 Health Insurance Fund $3,272,223.02 $11,487,618.10 $13,209,723.23 $1,550,117.89 302 Workers Comp Fund $0.00 $438,528.83 $301,470.78 $137,058.05 403 Lease Rental Fund $3,839.77 $3.98 $0.00 $3,843.75 405 2004 Road Bond Fund $0.00 $663,758.96 $659,390.00 $4,368.96 450 Old Town/126Th Street $458.29 $0.46 $0.00 $458.75 501 Dnr/Tree City $50,503.23 $613.09 $0.00 $51,116.32 502 Clerk's Record Perpetuation $105,152.82 $20,327.93 $1,761.02 $123,719.73 503 Court Interperter Fund $29.90 $15.01 $0.00 $44.91 504 Support For The Arts $17,136.24 $632,352.82 $632,335.00 $17,154.06 505 Public Defenders Fund $1,480.70 $126.64 $0.00 $1,607.34 3/2/2015 9.30:34 AM Page 1 Carmel Civil City, Hamilton County, Indiana Cash Fund Statement-2014 Local Fund Local Fund Name Beg Cash Bal Receipts Disba sements End Cash Bal Number Jan 1,2014 Dec 31, 2014 Governmental ctivities 506 JUDICIAL SALARY FEES $120,181.03 $44,736.39 $0.00 $164,917.42 507 Historic Preservation Fund $2,792.84 $0.85 $2,793.69 $0.00 801 Police Pension Fund $810,079.30 $513,489.94 $1,174,898.08 $148,671.16 802 Fire Pension Fund $568,641.68 $555,382.35 $1,092,923.73 $31,100.30 851 Fire Gift Fund $8,143.16 $24,685.10 $23,271.31 $9,556.95 852 Police Gift $30,479.59 $2,019.98 $11,775.11 $20,724.46 853 Parks Gift Fund $48,043.48 $5,475.98 $6,213.83 $47,305.63 854 Community Relations Gift Fund $62,280.96 $135,806.59 $77,098.50 $120,989.05 900 Grant Fund $472,003.36 $114,047,56 $374,567.39 $211,483.53 902 Redevelopment Commission $7,959,589.31 $29,648,667.28 $28,747,725.85 $8,860,530.74 903 Economic Fund $48,411.08 $50.35 $0.00 $48,461.43 904 Housing Authority $58,678.44 $61.01 $0.00 $58,739.45 911 Drug Task Force $562,295.65 $227,861.61 $230,036.71 $560,120.55 912 Rainy Day $8,976,882.24 $228,980.16 $730,487.70 $8,475,374.70 919 Throughfare Fund $261,318.20 $192,656.24 $9,020.73 $444,953.71 920 Keystone Ave Fund $241,941.24 $159,784.48 $235,170.00 $166,555.72 999 Levy Excess Fund $0.00 $567.31 $0.00 $567.31 SubTotal $44,674,382.35 $193,958,062.82 $198,821,225.30 $39,811,219.87 WASTEWATER 0 Wastewater Bond&Interest At Bony $2,800,374.19 $1,750,792.38 $1,866,811.52 $2,684,355.05 2012 Sewage Works Revenue Bonds $3,815,310.56 $8,655.09 $3,597,504.09 $226,461.56 651 Sewer Operating $20,387.98 $9,204,446.65 $9,222,151.17 $2,683.46 652 Sewer Depreciating $0.03 $245,613.79 $245,613.24 $0.58 659 Sewer Connection Fund $182,191.08 $688,446.61 $868,873.50 $1,764.19 660 Sewer Availability Fund $120,890.52 $88,925.57 $208,861.60 $954.49 SubTotal $6,939,154.36 $11,986,880.09 $16,009,815.12 $2,916,219.33 WATER 601 Water Operating $19,257.84 $24,351,318.84 $25,736,561.30 -$1,365,984.62 602 Hydrant Meter Deposit Fund $39,190.00 $1,735.00 $275.00 $40,650.00 604 Water Depreciation $0.16 $327,435.00 $327,435.13 $0.03 605 Water Bond&Interest $1,226,713.50 $73,859.50 $0.00 $1,300,573.00 606 Water Sinking Fund $327,755.80 $4,768,086.99 $5,095,423 74 $419.05 3/2/2015 9:30:34 AM Page 2 Carmel Civil City, Hamilton County, Indiana Cash Fund Statement-2014 Local Fund Local Fund Name Beg Cash Bal Receipts Disbn sements End Cash Bal Number Jan 1,2014 Dec 31,2014 WATER 609 Water Connection $89.97 $3,065,259.16 $2,106,539.59 $958,809.54 610 Water Availability $12.73 $848,989.83 $2,196,945.20 -$1,347,942.64 SubTotal $1,613,020.00 $33,436,684.32 $35,463,179.96 -$413,475.64 STORM WATER 250 Non Reverting Storm Water $0.00 $88,512.34 $0.00 $88,512.34 SubTotal $0.00 $88,512.34 $0.00 $88,512.34 GRAND TOTAL $53,226,556.71 $239,470,139.57 $250,294,220.38 $42,402,475.90 3/212015 9:30.34 AM Page 3 Carmel Civil City, Hamilton County, Indiana Debt Statement-2014 Ending Principal Balance Principal and Interest Debt Class Description or Purpose as of Due in 2015 Dec. 31,2014 Governmental Activities Revenue Bonds Redevelopment District Tax Increment Revenue Bonds,Series $6,115,000.00 $458,324.00 2004 A(Clarian Hospital)Illinois Street Project Revenue Bonds Carmel Redevelopment District Taxable County Option Income $3,420,000.00 $959,243.00 Tax Revenue Refunding Bonds,Series 2006(1998 City Center, refunded in 2006) Revenue Bonds 2005 Performing Arts Center $37,749,294.00 $3,323,000.00 Revenue Bonds Carmel Redevelopment District Certificates of Participation,Series $15,400,000.00 $682,113.00 2010C Revenue Bonds City of Carmel Redevelopment Authority County Option Income $6,725,000.00 $3,563,000.00 Tax Lease Rental Revenue Bonds,Series 2006-Road Bonds' Revenue Bonds City of Carmel(IN)Redevelopment Authority County Option $25,475,000.00 $1,721,000.00 Income Tax Lease Rental Revenue Bonds of 2010-Keystone Revenue Bonds City of Carmel(Indiana)Redevelopment Authority Lease Rental $21,435,000.00 $2,948,000.00 Revenue Refunding Bonds of 2011 -Refi 2004 Road Bond Clay West Revenue Bonds County Option Income Tax Revenue Refunding Bonds of 2011 $5,535,000.00 $759,758.00 (Street department) Revenue Bonds 2012A Lease Rental Multipurpose $115,900,000.00 $2,199,000.00 Revenue Bonds 2012B Lease Rental Multipurpose $64,765,000.00 $2,781,000.00 Revenue Bonds 2013 Illinois St Project Bond $6,535,000.00 $110,012.50 Revenue Bonds 2014 City of Carmel(IN)Redevelopment Authority COIT Lease $9,380,000.00 $5,027,000.00 Rental Revenue Bonds Series 2014A Revenue Bonds 2014 City of Carmel(IN)Redevelopment Authority COIT Lease $45,885,000.00 $2,243,400.00 Rental Revenue Bonds Series 2014B Revenue Bonds 2014 Carmel Redevelopment Authority Performing Arts Center $55,685,000.00 $1,831,500.00 refund CIB's Notes and Loans Payable 2011 Installment Purchase Agreement,Series C $1,000,000.00 $35,000.00 Notes and Loans Payable 2011 Installment Purchase Agreement,Series B $4,500,000.00 $157,500.00 Su bTotal $425,504,294.00 $28,798,850.50 Ending Principal Balance Principal and Interest Debt Class Description or Purpose as of Due in 2015 Dec.31,2014 WASTEWATER Revenue Bonds 2005 Wastewater Plant Expansion $7,670,000.00 $820,582.00 Revenue Bonds 2009 Wastewater Expansion $4,626,003.00 $298,966.95 Revenue Bonds 2012 Wastewater Revenue $10,585,000.00 $743,975.00 SubTotal $22,881,003.00 $1,863,523.95 3/2/2015 9:32:46 AM Page 1 Ending Principal 8alance Principal and Interest Debt Class Description or Purpose as of Due in 2015 Dec.31,2014 WATER Revenue Bonds 2012 Jr Waterworks Rev Bonds $61,795,000.00 $3,853,100.00 Revenue Bonds 2008 Plant Expansion Coupon Bonds $29,409,010 25 $0.00 Revenue Bonds 2008 Plant Expansion Cap Appreciation Bonds $20,105,000.00 $1,462,250.00 Notes and Loans Payable IWC Lines $15,035,152.50 $1,800,000.00 SubTotal $126,344,162.75 $7,115,350.00 GRAND TOTAL ;$574,729;458.75 $37,777,724.45 3/2/2015 9:32:46 AM Page 2 Carmel Civil City,Hamilton County,Indiana Leases 2014 Annual Lease Lease Lease Payment Due Begining Ending Lessor Description or Purpose in 2015 Date Date Governmental Activities(General) 2013 Street Dept(schedule 14) street sweeper $48,410.08; 06/15/2013! 12/15/2015 2005 Carmel Police and Fire Mobile Command Vehicle $44,211.93: 05/24/2005: 08/01/2015 Department 2010 Fire department(schedule 7) Purchase Fire Trucks $143,047 94• 02/15/2011', 08/15/2020 2013 Police Dept(schedule 5) police vehicles $197,770 001 05/15/2013. 11/15/2016 2012 Police department(schedule 9) purchase police cars $198,496.30 05/12/2012 11/15/2015 2012 Fire (schedule 11 Life Pacs) 15 Monitor/De ie._. 1.. ( ) fib, CPR, and accessories $88,410.00 09/15/2012 03/15/2017 2012 Fire Equipment(schedule 12) Radios, chargers, batteries $47,070.00 09/15/2012 03/15/2017 2012 Fire(schedule 10) 2 Ambulances $80,040.001 11/01/2012 05/01/2017 2009 Golf Course(schedule 2) PNC Golf equipment-mowers $39,439.701 09/01/20091 03/01/2015 2010 Fire department(schedule 5) Purchase Ambulance $18,525.00; 10/01/2010 04/01/2015 2010 Golf Course(schedule 4) Irrigation system $139,150 00 10/01/2010 10/01/2017 2013 Fire Department(schedule 16) turn out gear $72,620 001 03/15/2014, 09/15/2018 2014 Street Department(schedule 22) 5 trucks with plows $211,060 001 11/10/2014 10/15/2019 2014 Community Service(schedule 21) 5 Subaru Foresters and 4 Ford F-150's $31,900.00' 10/1/2014 9/18/2015 2014 Information Technology(schedule ',Nutanix High capacity Virutal Computing $11,860.00: 7/14/2014; 4/15/2018 19) System 2014 Fire(schedule 20) Seagrave Marauder II Pumper Truck $70,200.00' 07/14/2014 01/15/2025 2014 Brookshire Golf Course(schedule 68 golf carts and 2 utility vehicles $52,800 00 04/02/2014 12/15/2017 18) 2014 Police(schedule 17) 18 Ford Utility Interceptors and 1 Ford F-150 $197,770 00' 02/18/2014 11/15/2017 Total Governmental Activities(General)$1,692,780.95 WASTEWATER(Wastewater Utility) 2012 Vactor Plus Sewer Cleaner sewer vac $83,103.10' 7/19/2013 2/19/2018 Total WASTEWATER(Wastewater Utility)$83,103.10 GRAND TOTAL$1,775,884.05 3/2/2015 9:35:31 AM Page 1 Carmel Civil City, Hamilton County, Indiana Transfer Report 2014 Transfers Out Transfers In (Disbursements) (Receipts) Fund Amount Fund Amount General $1,350,399.28 Wastewater Bond & Interest At Bony $1,750,791.86 Cumulative Capital Sewer $220,000.00 General $1,172,816.00 Water Operating $5,230,005.28 Motor Vehicle Highway $1,035,035.00 Water Connection $1,950.00 Non Reverting Storm Water $0.00 Water Availability $2,717.00 Health Insurance Fund $0.00 Sewer Operating $2,060,326.90 Workers Comp Fund $425,520.00 Sewer Depreciating $41,551.55 Support For The Arts $632,335.00 Sewer Connection Fund $862,879.50 Water Operating $4,019.64 Sewer Availability Fund $166,880.60 Water Depreciation $327,435.00 Police Pension Fund $648,182.00 Water Bond & Interest $73,859.50 Fire Pension Fund $524,634.00 Water Sinking Fund $4,766,925.00 Rainy Day $700,000.00 Water Connection $519,303.23 Total Transfers Out $11,809,526.1 Water Availability $87,011.05 1 Sewer Operating $537,603.55 Sewer Depreciating $240,384.00 Sewer Connection Fund $3,978.00 Drug Task Force $12,509.28 Rainy Day $220,000.00 Total Transfers In $11,809,526.11 Carmel Civil City, Hamilton County, Indiana Financial Assistance to Non Governmental Entities - 2014 Name Federal Street Address City/State County Operating Phone Description Amount Type Tax ID Officer Name Actors Theater of Indiana 160 W Carmel Drive Carmel IN Hamilton James A.Reilly Donation for operating $102,080.00 ORCH.ISYMPHONY/TH costs EATRE Booth Tarkington Civic 3 Center Green Carmel IN Hamilton Cheri Dick 317-923-4597 Donation for operating $185,600.00 ORCH./SYMPHONYITH Theater costs EATRE Carmel Arts Council 776 Hawthorne Dr Carmel IN Hamilton Doreen Squire 317-844-4989 Donation for operating $13,825.00 ART Ficara costs FOUNDATIONS/CENTE RS Carmel Community Players 14299 Clay Terrace Blvd Carmel IN Hamilton Rich Phipps Donation for operating $13,920.00 OTHER NOT-FOR- #140 costs PROFIT Carmel Symphony Orchestra PO Box 761 Carmel IN Hamilton `Alan Davis 317-844-9717 donation for operating $190,240.00 ORCH.ISYMPHONYITH costs EATRE Center for the Performing 355 W.City Center Drive Carmel IN Hamilton Tania Castroverde Donation for operating $3,392,105.47 ORCH_/SYMPHONYITH Arts Moskalek o costs EATRE Central Indiana Dance 1142 Linden Lane Carmel IN Hamilton Jeffrey Sankey Donation for operating $11,135.00 ORCH./SYMPHONYITH Ensemble costs EATRE Gregory Hancock Dance 329 Gradle Dr Carmel IN Hamilton Kirsten Ferger Donation for operating $41,760.00 ORCH.ISYMPHONYITH Theater costs EATRE Indiana Wind Symphony PO Box 78592 Indianapolis IN Marion Janice Schreibman Donation for operating $11,135.00 OTHER NOT-FOR- costs PROFIT Indiana Ballet Conservatory 849 West Carmel Drive Carmel IN Hamilton Camille Nicodemus Donation for operating $18,560.00 OTHER NOT-FOR- costs PROFIT Indianapolis Childrens Choir 368216 Indianapolis IN Marion Don Steffy Donation for operating $3,710.00 ORCH./SYMPHONY/TH costs EATRE Indianapolis Symphonic 4600 Sunset Ave Indianapolis IN Marion Michael Pettry Donation for operating $11,135.00 ORCH./SYMPHONYITH Choir Inc costs EATRE International Talent Academy 1153 Aqueduct Way Indianapolis IN Marion Tatyana Komarova 317-815-9381 Donation for operating $13,920.00 ORCH./SYMPHONYITH costs EATRE Museum of Miniature 111 E Main St Carmel IN Hamilton Thomas Landshof Donation for operating $12,530.00 OTHER NOT-FOR- Housing costs PROFIT Young Voices Inspire Corp 408 W Main St Carmel IN Hamilton Alyssa Rudnir Donation for operating $2,785.00 OTHER NOT-FOR- costs PROFIT 312/2015 9:34:55 AM Page 1 Carmel Civil City, Hamilton County, Indiana Grants 2014 Amount of Federal Amount of Amount of Amount of Local Project Name/ Federal Awards Loans Federal insurance in Description Program Pass CFDA Award Grant Disburse Provided to Outstandin Noncash Effect During TitlelProject Federal Agency Through Numb Award Name Number Type Local Fund Receipts -ments Subrecipients g at Year Assistance the Year Name Agency er During the End for the Year Year Seatbelt Enforcemen State and DOT Hamilton 20 600 OPO Seatbelt 2344 Reimbo cement Grab Fund $10,809.04 $10,809.0 $0.00 $0.00 $0.00 $0 00 Community County Grant 4 Highway Safety DUI Enforcement Alcohol DOT Hamilton 20.601 OPO DUI 2345 Reimbursement Grant Fund $10,702.43 $10,702.4 $0.00 $0.00 $0.00 $0.00 Impaired County Grant 3 Driving Countermeas , urers Incentive Gran s Blitz 78 State and DOT Hamilton 20.600 OPO Seatbelt 2344 Reimbo Bement Grab Fund $3,279.70 $3,279.70 $0.00 $0.00 $0.00 $0.00 Community County Grant Highway Safety Blitz 78 Alcob I DOT Hamilton 20.601 DUI 2345 Reimbo cement Grab Fund $647.37 $647.37 $0.00 $0 00 $0.00 $0.00 Imapired county Checkpoint Grant Driving Countermeas urers Incentive Grab s OPO DUI Alcob I DOT Hamilton 20.601 OPO DUI 2345 Reimbo Bement Grab Fund $5,569.39 $5,569.39 $0.00 $0.00 $0.00 $0.00 Impaired County Grant Driving Cou ntermeas uters Incentive Grab s Blitz 80 Alcob I DOT Hamilton 20.601 OPO DUI 2345 Reimbo cement Grab Fund $3,856.07 $0.00 $0.00 $0.00 $0.00 $0.00 Impaired County Grant Driving Countermeas urers Incentive Grab s OPO DUI Checkpoint Alcohol DOT Hamilton 20.601 OPO DUI 2345 Reimbursement Grant Fund $629.60 $629.60 $0.00 $0.00 $0.00 $0.00 Impaired County Grant Driving Countermeas urers Incentive Grab s Blitz 77 State and DOT Hamilton 20.600 OPO Seatbelt 2344 and Reimbo cement Grab Fund $4,431_96 $4,431.96 $0.00 $0 00 $0 00 $0.00 Community County 2345 Grant Highway Safety Vibrant Respoe e 14 Nation I Departmeto f Johnson 97.025 Reimbo cement Gee rat $7,642.68 $7,642.68 $0.00 $0.00 $0.00 $0.00 MOBEX Exercise Urban Search Homeland County Grant and Rescue Security Response System 3/2/2015 9:35:06 AM Page 1 Carmel Civil City, Hamilton County, Indiana Grants 2014 Amount of Federal Amount of Amount of Amount of Local Project Name/ Federal Awards Loans Federal Insurance in Description Program Pass CFDA Award Grant Disburse Provided to Outstandin Noncash Effect During Title/Project Federal Agency Through Numb Award Name Number Type Local Fund Receipts -ments Subrecipients 9 at Year Assistance the Year Name Agency er During the End for the Year Year Hamilton County Full Non Profit Deptmeh of Hamilton 97.008 C44P-3-375B Reimbo sement Gee ral $1,433.52 $0.00 $0.00 $0.00 $0.00 $0.00 Scale Exercise Security Homeland County Grant Program Security DOJ Reimbo cement OCEDTF Drug Hamilton 16.111 GL-INS-0211 Reimbn Bement Gee ral $1,351.69 $1,351.69 $0.00 $0.00 $0.00 $0.00 Enforcement county Grant Agency DOJ Reimbo cement OCEDTF Drug Hamilton 16.111 GL-INS-0211 Reimbo sement Gee ral $4,241.51 $4,241.51 $0.00 $0.00 $0.00 $0.00 Enforcement County Grant Agency Bulletproof Vest Bulletproof Dept of Justice 16.607 Reimbo sement Gee ral $2,375 00 $2,375.00 $0.00 $0.00 $0.00 $0.00 Vest Grab DOJ Reimbursement OCEDTF Drug 16.111 Reimbursement General $3,099 57 $3,099.57 $0.00 $0.00 $0.00 $0.00 Enforcement Grant Agency Bulletproof Vest Bulletproof Dept of Justice 16.607 GL-INS-0211 Reimbo sement Gee ral $3,107.50 $3.107.50 $0.00 50.00 $0.00 $0.00 Vest Grab DOJ Reimbo sement OCEDTF Drug 16.111 GL-INS-0211 Reimbo sement Gee rat $605.93 $605.93 $0.00 S0.00 $0.00 $0.00 Enforcement Grant Agency DOJ Reimbo sement OCEDTF Drug 16.111 GL-INS-0211 Reimbo cement Gee ral $745.76 $745.76 $0.00 $0.00 $0.00 $0.00 Enforcement Grant Agency DOJ Reimbo cement OCEDTF Drug Hamilton 16.111 GL-INS-0211 Reimbo sement Gee ral $605.93 $605.93 $0.00 $0.00 $0.00 $0.00 Enforcement County Grant Agency DOJ Reimbo sement OCEDTF Drug 16.111 GL-INS-0211 Reimbo sement Gee ral $745.76 $745.76 $0.00 $0.00 $0.00 $0.00 Enforcement Grant Agency _ DOJ Reimbo sement OCEDTF Drug 16.111 GL-1NS-0211 Reimbo sement Gee ral $116.52 $116.52 $0.00 $0.00 $0.00 $0.00 Enforcement Grant Agency DOJ Reimbo sement OCEDTF Drug 16.111 GL-INS-0211 Reimbo sement Gee ral $300.84 $300.84 $0.00 $0.00 $0.00 $0.00 Enforcement Grant Agency DOJ Reimbo sement OCEDTF Drug 16.111 GL-INS-0211 Reimbo sement Gee ral $1,253.50 $1,253.50 $0.00 $0.00 $0 00 $0.00 Enforcement Grant Agency 111th&Penn Highway Fed ral INDOT 20.205 1297165 Reimbo sement Grab Fund $695.70 6695.70 $0.00 $0.00 $0.00 $0.00 Intersection Planning and Highway Grant Coe truction 111th&Penn Highway Fed ral INDOT 20.205 1297165 Reimbo sement Cumulative $623.26 $623.26 $0.00 $0.00 $0.00 $0.00 Intersection Planning and Highway Grant Captial Coe truction Developmeb Cool Creek Trail& Highway Fed ral INDOT 20.205 0600390 Reimbo sement Grab Fund $11,639.59 $11,639.5 $0.00 $0.00 $0,00 50.00 Randolph Co Bridge Planning and Highway Grant 9 8117 Coe truction Cool Creek Trail& Highway Fed ral INDOT 20.205 0600390 Reimbo sement Grab Fund $21,520.55 $21,520.5 $0.00 $0.00 $0.00 $0.00 Randolph Co Bndge Planning and Highway Grant 5 #117 Coe traction 3/2/2015 9:35:06 AM Page 2 Carmel Civil City, Hamilton County, Indiana Grants 2014 Amount of Federal Amount of Amount of Amount of Local Project Name/ Federal Awards Loans Federal Insurance in Description Program Pass CFDA Award Grant Disburse Provided to Outstandin Noncash Effect During TitlelProject Federal Agency Through Numb Award Name Number Type Local Fund Receipts -ments Subrecipients g at Year Assistance the Year Name Agency er During the End for the Year Year Unsure Highway Fed ml INDOT 20.205 Reimbo sement Gratz Fund $33,160.14 $33,160.1 $0.00 $0.00 $0.00 $0.00 Planning and Highway Grant 4 Coe truction Cool Creek Trail& Highway Fed ral INGOT 20.205 0600390 Reimbo sement Grab Fund $31.84 $31.84 $0.00 $0.00 $0.00 $0.00 Randolph Co Bridge Planning and Highway Grant #117 Coe traction - Cool Creek Trail& Highway Fed ral INDOT 20.205 0600390 Reimba sement Grab Fund $2,521.41 $2,521.41 $0.00 $0.00 $0.00 50.00 Randolph Co Bridge Planning and Highway Grant #117 Coe traction Cool Creek Trail& Highway Fed ral INGOT 20.205 0600390 Rambo sement Grab Fund $3,501.44 $3,501.44 $0.00 $0.00 $0.00 $0.00 Randolph Co Bridge Planning and Highway Grant #117 Coe truction Cool Creek Trail& Highway Fed ral INGOT 20.205 0600390 Reimba Bement Gran Fund $3,797.78 $3,797,78 $0.00 $0.00 $0.00 S0.00 Randolph Co Bridge Planning and Highway Grant #117 Coe truction Cool Creek Trail& Highway Fed ml INGOT 20.205 0600390 Reimba sement Gran Fund 36,975.21 $6,975.21 $0.00 $0.00 $0.00 $0.00 Randolph Co Bridge Planning and Highway Grant #117 Coe truction Cool Creek Trail& Highway Fed ral INGOT 20.205 0600390 Reimba sement Gran Fund $8,388.76 $8,388.76 50.00 $0.00 $0.00 $0.00 Randolph Co Bridge Planning and Highway Grant #117 Coe traction Unsure Highway Fed ral INGOT 20.205 Reimbu sement Grah Fund $25,216.44 $25,216.4 $0.00 $0.00 $0.00 $0.00 Planning and Highway Grant 4 Coe traction 111th&Penn Highway Fed ral INGOT 20.205 1297165 Reimba sement Grab Fund $529.63 $529.63 $0.00 $0.00 $0.00 $0.00 Intersection Planning and Highway Grant Improvemeh Coe traction 111th&Penn Highway Fed ral INGOT 20.205 1297165 Reimbo sement Grab Fund $430.23 $430.23 $0.00 $0.00 $0.00 $0.00 Intersection Planning and Highway Grant Improvemeh s Coe truction 111th&Penn Highway Fed ral INGOT 20.205 1297165 Reimba sement Grab Fund $889.12 $889.12 $0.00 $0.00 $0.00 $0.00 Intersection Planning and Highway Grant Improvemeh s Coe traction 106th St Lift Station Congressiona EPA 66.202 Reimba sement Sewer $13,201.98 $13,201.9 $0.00 $0.00 $0.00 $0.00 Ily Mandated Grant Operating 8 Projects OPO Seatbelt Occupat GOT Hamilton 20.602 1498 Reimbu cement Gran Fund $2,227.21 $2,227.21 $0.00 $0.00 $0.00 $0.00 Protection County Grant Incentive Gratis - DUI Enforcemeti Alcob I DOT Hamilton 20.601 1520 Reimba sement Grab Fund $3,241.94 $3,241.94 $0.00 $0.00 $0.00 $0 00 Impaired County Grant Driving Countermeas urers Incentive Grab s I 3/2/2015 9:35:06 AM Page 3 Carmel Civil City, Hamilton County, Indiana Grants 2014 Amount of Federal Amount of Amount of Amount of Local Project Name/ Federal Awards Loans Federal Insurance in Description Program Pass CFDA Award Grant Disburse Provided to Outstandin Noncash Effect During TitlelProject Federal Agency Through Numb Award Name Number Type Local Fund Receipts -ments Subrecipients g at Year Assistance the Year Name Agency er During the End for the Year Year W DUI Enforcemeti Alcob I DOT Hamilton 20.601 1520 Rambo sement Grab Fund $3,887.93 $3,887.93 $0.00 $0.00 $0.00 $0.90 Driving County Grant Countermeas u re rs Incentive Gratis l 3/2/2015 9.35:06 AM Page 4 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for all Funds 2014 Governmental Activities Carmel City Court Other Disbursements $1,971,032.18 Tb al Other Disbursements $1,971,032.18 Tb al Carmel City Court $1,971,032.18 Payroll Fund Payments To or On Behalf of Beneficiaries $48,011,749.69 Tb al Other Disbursements $48,011,749.69 Tb al Payroll Fund $48,011,749.69 General Salaries and Wages $29,774,698.96 Employee Benefits $14,411,858.60 Tb al Personal Services $44,186,557.56 Office Supplies $91,569.24 Operating Supplies $699,596.28 Repair and Maintenance Supplies $231403.36 Other Supplies $224,358.04 Tb al Supplies $1,246,926.92 Professional Services $1,456,672.68 Communication and Transportation $514,799.38 Printing and Advertising $107,961.67 Insurance $958,686.96 Utility Services $1,422,277.22 Repairs and Maintenance $5,119,262.91 Rentals $1,357,644.63 Other Services and Charges $4,048,027.66 Tb al Services and Charges $14,985,333.11 312/2015 9:33:01 AM Page 1 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for all Funds 2014 Governmental Activities General Payments on Bonds and Other Debt Principal $8,580,041.36 Tb al Debt service-principal and interest $8,580,041.36 Infrastructure $70,000 00 Improvements Other Than Buildings $40,617.65 Machinery, Equipment, and Vehicles $362,014.34 Tb al Capital Outlays $472,631.99 Transfer Out-Transferred To Another Fund $1,350,399.28 Other Disbursements $644,469.27 Tb al Other Disbursements $1,994,868.55 Tb al General $71,466,359.49 pp Ambulance Fund Other Supplies $52,007.86 Tb al Supplies $52,007.86 Repairs and Maintenance $19,440.00 Other Services and Charges $3,099.15 Tb al Services and Charges $22,539.15 Machinery, Equipment, and Vehicles $931,540.18 Tb al Capital Outlays $931,540.18 Other Disbursements $3,215.24 Tb al Other Disbursements $3,215.24 Tb al Ambulance Fund $1,009,302.43 Parks Capital Land $921.60 Tb al Capital Outlays $921.60 Tb al Parks Capital $921.60 3/2/2015 9:33:01 AM Page 2 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for all Funds 2014 Governmental Activities Park impact Fee Fund Other Capital Outlays $1,283,676.08 Tb al Capital Outlays $1,283,676.08 Tb al Park Impact Fee Fund $1,283,676.08 Parks Program Fund Salaries and Wages $2,058,200.53 Employee Benefits $550,169.67 Tb al Personal Services $2,608,370.20 Office Supplies $9,611.24 Other Supplies $255,100.22 Tb al Supplies $264,711.46 Professional Services $156,891.56 Communication and Transportation $188,460.84 Printing and Advertising $13,961.98 Repairs and Maintenance $36,495.12 Other Services and Charges $50,874.24 Tb al Services and Charges $446,683.74 Tb al Parks Program Fund $3,319,765.40 Parks Monon Fund Salaries and Wages $1,900,533.40 Employee Benefits $449,907.12 Tb al Personal Services $2,350,440.52 Office Supplies $13,140.65 Repair and Maintenance Supplies $186,367.34 Other Supplies $169,760.24 Tb al Supplies $369,268.23 Professional Services $580,311.31 Communication and Transportation $43,492 40 3/2/2015 9:33.01 AM Page 3 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for all Funds 2014 Governmental Activities Parks Monon Fund Printing and Advertising $55,154.28 Insurance $55,648.00 Utility Services $641,540.19 Repairs and Maintenance $523,047.51 Rentals $20,059.98 Other Services and Charges $72,799.20 Tb al Services and Charges $1,992,052.87 Machinery, Equipment, and Vehicles $24,639.74 Tb al Capital Outlays $24,639.74 Other Disbursements $16,000.00 Tb al Other Disbursements $16,000.00 Tb al Parks Monon Fund $4,752,401.36 Motor Vehicle Highway Salaries and Wages $3,962,347.18 Employee Benefits $1,928,730.84 Tb al Personal Services $5,891,078.02 Office Supplies $8,205.22 Operating Supplies $320,899.84 Repair and Maintenance Supplies $1,497,670.19 Other Supplies $146,390.71 Tb al Supplies $1,973,165.96 Professional Services $550,995.21 Communication and Transportation $34,915.81 Printing and Advertising $438.41 Utility Services $371,518.13 Repairs and Maintenance $3,440,401.74 Rentals $65,735.76 Other Services and Charges $54,438.18 Tb al Services and Charges $4,518,443.24 Land $50,000.00 3/2/2015 9:33:01 AM Page 4 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for all Funds 2014 Governmental Activities Motor Vehicle Highway Improvements Other Than Buildings $89,191.69 Machinery, Equipment, and Vehicles $30,861.93 Tb al Capital Outlays $170,053.62 Other Disbursements $21,400.00 Tb al Other Disbursements $21,400.00 Tb al Motor Vehicle Highway $12,574,140.84 Local Road And Street Professional Services $246,822.89 Repairs and Maintenance $735,708.27 Tb al Services and Charges $982,531.16 Land $420,735.42 Improvements Other Than Buildings $3,364.16 Tb al Capital Outlays $411 ,099.58 Tb al Local Road And Street $1,406,630.74 Cumulative Capital Professional Services $136,379.74 Improvement Repairs and Maintenance $239,419.00 Tb al Services and Charges $375,798.74 Improvements Other Than Buildings $200,751.80 Tb al Capital Outlays $200,751.80 Tb al Cumulative Capital Improvement $576,550.54 Cumulative Capital Sewer Improvements Other Than Buildings $22,734.34 Tb al Capital Outlays $22,734.34 Transfer Out-Transferred To Another Fund $220,000.00 Tb al Other Disbursements $220,000.00 Tb al Cumulative Capital Sewer $242,734.34 Deferral Fund Salaries and Wages $35,030.41 3/212015 9:33:01 AM Page 5 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for all Funds 2014 Governmental Activities Deferral Fund Employee Benefits $14,870.57 Tb al Personal Services $49,900.98 Office Supplies $7,081.65 Tb al Supplies $7,081.65 Communication and Transportation $16,261.61 Rentals $2,513.80 Other Services and Charges $59.00 Tb al Services and Charges $18,834.41 Machinery, Equipment, and Vehicles $19,112.29 Tb al Capital Outlays $19,112.29 Tb al Deferral Fund $94,929.33 User Fee Fund Other Services and Charges $93,898.15 Tb al Services and Charges $93,898.15 Other Disbursements $8,367.00 Tb al Other Disbursements $8,367.00 Tb al User Fee Fund $102,265.15 Cumulative Captial Repair and Maintenance Supplies $6,391.61 Development Tb al Supplies $6,391.61 Professional Services $384,999.19 Repairs and Maintenance $324,377.00 Tb al Services and Charges $709,376.19 Payments on Bonds and Other Debt Principal $1,751,342.00 Tb al Debt service -principal and interest $1,751,342.00 3/2/2015 9:33:01 AM Page 6 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for all Funds 2014 Governmental Activities Cumulative Captial Improvements Other Than Buildings $124,890.47 Development Tb al Capital Outlays $124,890.47 Tb al Cumulative Captial Development $2,592,000.27 Illinois St Construction Land $24,000.00 Fund Improvements Other Than Buildings $1,872,103.20 Tb al Capital Outlays $1,896,103.20 Tb al Illinois St Construction Fund $1,896,103.20 Health Insurance Fund Payments To or On Behalf of Beneficiaries $13,209,723.23 Tb al Other Disbursements $13,209,723.23 Tb al Health Insurance Fund $13,209,723.23 Workers Comp Fund Payments To or On Behalf of Beneficiaries $301,470.78 Tb al Other Disbursements $301,470.78 Tb al Worke s Comp Fund $301,470.78 2004 Road Bond Fund Payments on Bonds and Other Debt Principal $659,390.00 Tb al Debt service-principal and interest $659,390.00 Tb al 2004 Road Bond Fund $659,390.00 Clerk's Record Professional Services $1,761.02 Perpetuation Tb al Services and Charges $1,761.02 Tb al Clerk's Record Perpetuation $1,761.02 3/2/2015 9:33:01 AM Page 7 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for all Funds 2014 Governmental Activities Support For The Arts Other Services and Charges $632,335.00 Tb al Services and Charges $632,335.00 Tb al Support For The Arts $632,335.00 Historic Preservation Fund Other Disbursements $2;793.69 Tb al Other Disbursements $2,793.69 Tb al Historic Preservation Fund $2,793.69 Police Pension Fund Salaries and Wages $1,699.88 Tb al Personal Services $1,699.88 Insurance $100.00 Tb al Services and Charges $100.00 Payments To or On Behalf of Beneficiaries $524,916.20 Transfer Out-Transferred To Another Fund $648,182.00 Tb al Other Disbursements $1,173,098.20 Tb al Police Pension Fund $1,174,898.08 Fire Pension Fund Salaries and Wages $2,703.74 Tb al Personal Services $2,703.74 Professional Services $100.00 Tb al Services and Charges $100.00 Payments To or On Behalf of Beneficiaries $565,485.99 Transfer Out-Transferred To Another Fund $524,634.00 Tb al Other Disbursements $1,090,119.99 Tb al Fire Pension Fund $1,092,923.73 3/2/2015 9:33:01 AM Page 8 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for all Funds 2014 Governmental Activities Fire Gift Fund Other Disbursements $23,271.31 Tb al Other Disbursements $23,271.31 Tb al Fire Gift Fund $23,271.31 Police Gift Other Disbursements $11775.11 Tb al Other Disbursements $11,775.11 Tb at Police Gift $11,775.11 Parks Gift Fund Other Disbursements $6,213.83 Tb al Other Disbursements $6,213.83 Tb at Parks Gift Fund $6,213.83 Community Relations Gift Other Services and Charges $24,282.10 Fund Tb at Services and Charges $24,282.10 Other Disbursements $52,816.40 Tb al Other Disbursements $52,816.40 Tb at Community Relations Gift Fund $77,098.50 Grant Fund Other Services and Charges $6,931.80 TO al Services and Charges $6,931.80 Improvements Other Than Buildings $309,259.01 Other Capital Outlays $58,376.58 Tb at Capital Outlays $367,635.59 Tb at Grant Fund $374,567.39 Redevelopment Professional Services $330,718.01 Commission 3/2/2015 9:33:01 AM Page 9 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for all Funds 2014 Governmental Activities Redevelopment Repairs and Maintenance $588.00 Commission Other Services and Charges $30,098.44 Tb al Services and Charges $361,4@ .45 Payments on Bonds and Other Debt Principal $22,406,455.97 Tb al Debt service -principal and interest $22,406,455.97 Land $2,744,145 90 Buildings $200,499.64 Tb al Capital Outlays $2,944,645.54 Payments To or On Behalf of Beneficiaries $2,710,219.89 Other Disbursements $325,000.00 Tb al Other Disbursements $3,035,219.89 Tb al Redevelopment Commission $28,747,725.85 Drug Task Force Office Supplies $2,241.57 Repair and Maintenance Supplies $4.49 Other Supplies $231.88 Tb al Supplies $2,477.94 Communication and Transportation $6,791.55 Utility Services $6,900.00 Repairs and Maintenance $25,789.16 Rentals $92,552.08 Other Services and Charges $63,332.90 Tb al Services and Charges $195,365.69 Machinery, Equipment, and Vehicles $32,193.08 Tb al Capital Outlays $32,193.08 Tb al Drug Task Force $230,036.71 3/2/2015 9:33:01 AM Page 10 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for all Funds 2014 Governmental Activities Rainy Day Improvements Other Than Buildings $30,487.70 Tb al Capital Outlays $30,487.70 Transfer Out-Transferred To Another Fund $700,000.00 Tb al Other Disbursements $700,000.00 Tb al Rainy Day $730,487.70 Throughfare Fund Other Disbursements $9,020.73 Tb al Other Disbursements $9,020.73 Tb al Th oughfare Fund $9,020.73 Keystone Ave Fund Professional Services $19,190.00 Tb al Services and Charges $19,190.00 Infrastructure $215,980.00 Tb al Capital Outlays $215,980.00 Tb al Keystone Ave Fund $235,170.00 Total Governmental Activities $198,821,225.30 WASTEWATER Wastewater Bond& Payments on Bonds and Other Debt Principal $636,685.52 Interest At Bony Payments on Bonds and Other Debt Interest $1,230,126.00 Tb al Debt service -principal and interest $1,866,811.52 Tb al Wastewater Bond &Interest At Bony $1,866,811.52 Sewage Works Revenue Improvements Other Than Buildings $3,597,504.09 Bonds Tb al Capital Outlays $3,597,504.09 Tb al Sewage Works Revenue Bonds $3,597,504.09 3/2/2015 9:33:01 AM Page 11 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for all Funds 2014 WASTEWATER Sewer Operating Salaries and Wages $2,879,956.73 Tb al Personal Services $2,879,956.73 Insurance $104,623.00 Tb al Services and Charges $104,623.00 Transfer Out-Transferred To Another Fund $2,060,326.90 Other Disbursements $724,258.26 Tb al Other Disbursements $2,784,585.16 Chemicals $152,961.10 Contractual Services $443,169.87 Employee Pensions and Benefits $1,445,197.77 Materials and Supplies $392,928.44 Power Production\Purchased Power $455,365.99 Sludge Removal $12,818.00 Transportation $149,270.33 Other Operating $401,274.78 Tb al Operations $3,452,986.28 Tb al Sewer Operating $9,222,151.17 Sewer Depreciating Construction $204,061.69 Tb al Capital Outlays $204,061.69 Transfer Out-Transferred To Another Fund $41,551.55 Tb al Other Disbursements $41,551.55 Tb al Sewer Depreciating $245,613.24 Sewer Connection Fund Construction $5,994.00 Tb al Capital Outlays $5,994.00 3/2/2015 9:33:01 AM Page 12 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for all Funds 2014 WASTEWATER Sewer Connection Fund Transfer Out-Transferred To Another Fund $862,879.50 Tb al Other Disbursements $862,879.50 Tb al Sewer Connection Fund $868,873.50 Sewer Availability Fund Construction $41,981.00 Tb al Capital Outlays $41,981.00 Transfer Out-Transferred To Another Fund $166,880.60 Tb al Other Disbursements $166,880.60 Tb al Sewer Availability Fund $208,861.60 Total WASTEWATER $16,009,815.12 WATER Water Operating Salaries and Wages $3,225,650.36 Tb al Personal Services $3,225,650.36 Insurance $132,580.00 Tb al Services and Charges $132,580.00 Payments on Bonds and Other Debt Principal $921,441.00 Payments on Bonds and Other Debt Interest $878,559.00 Tb al Debt service-principal and interest $1,800,000.00 Transfer Out-Transferred To Another Fund $5,230,005.28 Other Disbursements $10,290,367.95 Tb al Other Disbursements $15,520,373.23 Chemicals $679,852 13 Contractual Services $604,926.88 Employee Pensions and Benefits $1,543,190.93 Materials and Supplies $288,775.11 Power Production\Purchased Power $997,732.63 3/2/2015 9:33:01 AM Page 13 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for all Funds 2014 WATER Water Operating Purchased Water $301,409 66 Transportation $177,070.39 Other Operating $464,999.98 Tb al Operations $5,057,957.71 Tb al Water Operating $25,736,561.30 Hydrant Meter Deposit Other Disbursements $275.00 Fund Tb al Other Disbursements $275.00 Tb al Hydrant Meter Deposit Fund $275.00 Water Depreciation Construction $327,435.13 Tb al Capital Outlays $327,435.13 Tb al Water Depreciation $327,435.13 Water Sinking Fund Payments on Bonds and Other Debt Principal $1,585,000.00 Payments on Bonds and Other Debt Interest $3,510,423.74 Tb al Debt service -principal and interest $5,095,423.74 Tb al Water Sinking Fund $5,095,423.74 Water Connection Construction $2,104,589.59 Tb al Capital Outlays $2,104,589.59 Transfer Out-Transferred To Another Fund $1,950.00 Tb al Other Disbursements $1,950.00 Tb al Water Connection $2,106,539.59 Water Availability Construction $2,194,228.20 Tb al Capital Outlays $2,194,228.20 3/2/2015 9:33:01 AM Page 14 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for all Funds 2014 WATER Water Availability Transfer Out-Transferred To Another Fund $2,717.00 Tb al Other Disbursements $2,717.00 Tb al Water Availability $2,196,945.20 Total WATER $35,463,179.96 312/2015 9:33:01 AM Page 15 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for Funds With Departments 2014 Governmental Activities General No Department Transfer Out-Transferred To Another $347,544.28 Fund Other Disbursements $644,469.27 Tb al Other Disbursements $992,013.55 Tb al No Department $992,013.55 Clerk-Treasurer(City/Town Units Only) Salaries and Wages $472,646.22 Employee Benefits $201,963.08 Tb al Personal Services $674,609.30 Office Supplies $6,968.14 Other Supplies $439.18 Tb al Supplies $7,407.32 Professional Services $143,716.59 Communication and Transportation $8,542.80 Printing and Advertising $472.30 Insurance $975.00 Repairs and Maintenance $23,816.58 Rentals $13,352.65 Other Services and Charges $10,494.01 Tb al Services and Charges $201,369.93 Machinery, Equipment, and Vehicles $38,160.10 Tb al Capital Outlays $38,160.10 Tb al Clerk-Treasurer(CitylTw n Units Only) $921,546.65 Mayor Salaries and Wages $246,360.94 3/2/2015 9:33:45 AM Page 1 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for Funds With Departments 2014 Governmental Activities General Mayor Employee Benefits $114,653.10 Tb al Personal Services $361,014.04 Office Supplies $1,964.77 Other Supplies $149.78 Tb al Supplies $2,114.55 Professional Services $209,564.34 Communication and Transportation $20,164.09 Repairs and Maintenance $1,099.48 Rentals $14,892.82 Other Services and Charges $17,868.35 Tb al Services and Charges $263,589.08 Tb al Mayor $626,717.67 Board Of Public Works&Safety Salaries and Wages $11,955.84 Employee Benefits $914.68 Tb al Personal Services $12,870.52 Repairs and Maintenance $324,600.00 Tb al Services and Charges $324,600.00 3/2/2015 9:33:45 AM Page 2 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for Funds With Departments 2014 Governmental Activities General Board Of Public Works&Safety Payments on Bonds and Other Debt $8,580,041.36 Principal Tb al Debt service -principal and interest $8,580,041.36 Tb al Board Of Public Works&Safety $8,917,511.88 Administration Salaries and Wages $230,238.74 Employee Benefits $90,786.80 Tb al Personal Services $321,025.54 Office Supplies $3,869.01 Operating Supplies $7,379.74 Repair and Maintenance Supplies $31,916.64 Other Supplies $2,776.75 Tb al Supplies $45,942.14 Communication and Transportation $3,154.95 Insurance $795,693.84 Utility Services $159,030.30 Repairs and Maintenance $166,282.03 Rentals $6,450.92 Other Services and Charges $147,233.08 Tb al Services and Charges $1,277,845.12 Infrastructure $70,000.00 Improvements Other Than Buildings $9,795.58 3/2/2015 9:33:45 AM Page 3 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for Funds With Departments 2014 Governmental Activities General Administration Machinery, Equipment, and Vehicles $10,518.03 Tb al Capital Outlays $90,313.61 Transfer Out-Transferred To Another $260,000.00 Fund Tb al Other Disbursements $260,000.00 Tb al Administration $1,995,126.41 Personnel Salaries and Wages $227,047.84 Employee Benefits $102,485.81 Tb al Personal Services $329,533.65 Office Supplies $777.11 Tb al Supplies $777.11 Professional Services $6,300.00 Communication and Transportation $3,466.74 Printing and Advertising $2,233.52 Repairs and Maintenance $778.78 Other Services and Charges $12,555.77 Tb al Services and Charges $25,334.81 3/2/2015 9:33:45 AM Page 4 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for Funds With Departments 2014 Governmental Activities General Personnel Machinery, Equipment, and Vehicles $2,378.85 Tb al Capital Outlays $2,378.85 Tb al Personnel $358,024.42 City/Town Court(City Judge/Judge) Salaries and Wages $448,092.15 Employee Benefits $163,590.19 Tb al Personal Services $611,682.34 Office Supplies $14,244.91 Other Supplies $584.02 Tb al Supplies $14,828.93 Professional Services $37,334.42 Communication and Transportation $3,015.00 Repairs and Maintenance $1,399.10 Rentals $3,048.88 Other Services and Charges $130.00 Tb al Services and Charges $44,927.40 Machinery, Equipment, and Vehicles $2,225.06 Tb al Capital Outlays $2,225.06 Tb al City/Town Court(City Judge/Judge) $673,663.73 3/2/2015 9:33:45 AM Page 5 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for Funds With Departments 2014 Governmental Activities General Law Department Salaries and Wages $347,815.72 Employee Benefits $144,348.67 Tb al Personal Services $492,164.39 Office Supplies $1,122.48 Tb al Supplies $1,122.48 Professional Services $131,234.71 Communication and Transportation $19,248.71 Printing and Advertising $83.25 Insurance $200.00 Rentals $4,206.82 Other Services and Charges $13,222.60 Tb at Services and Charges $168,196.09 Machinery, Equipment, and Vehicles $17,435.58 Tb at Capital Outlays $17,435.58 Tb al Law Department $678,918.54 Community Services Salaries and Wages $1,310,171.96 Employee Benefits $548,575.18 Tb al Personal Services $1,858,747.14 Office Supplies $8,574.62 Operating Supplies $9,944.43 Repair and Maintenance Supplies $1,548.05 3/2/2015 9:33:45 AM Page 6 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for Funds With Departments 2014 Governmental Activities General Community Services Other Supplies $3,810.86 TO al Supplies $23,877.96 Professional Services $158,409.25 Communication and Transportation $52,301.20 Printing and Advertising $4,870.73 Insurance $8,500.00 Repairs and Maintenance $278,318.56 Rentals $22,225.15 Other Services and Charges $23,469.97 TO al Services and Charges $548,094.86 Improvements Other Than Buildings $30,822.07 Machinery, Equipment, and Vehicles $17,829.95 TO al Capital Outlays $48,652.02 TO al Community Services $2,479,371.98 Communications Department(Radio-Phones-Dispatch) Salaries and Wages $328,613.68 Employee Benefits $141,273.64 TO al Personal Services $469,887.32 Office Supplies $1,476.42 Operating Supplies $4,053.07 Repair and Maintenance Supplies $12,517.81 3/2/2015 9:33:45 AM Page 7 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for Funds With Departments 2014 Governmental Activities General Communications Department(Radio-Phones-Dispatch) Other Supplies $3,048.62 Tb al Supplies $21,095.92 Professional Services $3,398.80 Communication and Transportation $101,103.94 Repairs and Maintenance $1,199,185.96 Rentals $4,857.60 Other Services and Charges $1,042.89 Tb al Services and Charges $1,309,589.19 Machinery, Equipment, and Vehicles $70,089.69 Tb al Capital Outlays $70,089.69 Tb al Communications Department(Radio-Phones-Dispatch) $1,870,662.12 Public Affairs Salaries and Wages $282,048.26 Employee Benefits $109,083.67 Tb al Personal Services $391,131.93 Office Supplies $2,647.99 Other Supplies $227.88 Tb al Supplies $2,875.87 Professional Services $257,161.42 Communication and Transportation $14,322.88 Printing and Advertising $74,574.06 312/2015 9:33,45 AM Page 8 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for Funds With Departments 2014 Governmental Activities General Public Affairs Repairs and Maintenance $28,777.98 Rentals $1,548.20 Other Services and Charges $682,182.37 Tb at Services and Charges $1,058,566.91 Machinery, Equipment, and Vehicles $1,688.73 Tb al Capital Outlays $1,688.73 Tb at Public Affairs $1,44 ,263.44 Fire Department Salaries and Wages $13,283,087.20 Employee Benefits $6,372,929.74 Tb at Personal Services $19,656,016.94 Office Supplies $11,441.63 Operating Supplies $151,894.56 Repair and Maintenance Supplies $86,904.19 Other Supplies $28,836.19 Tb al Supplies $279,076.57 Professional Services $38,708.62 Communication and Transportation $151,765.48 Printing and Advertising $4,380.88 Insurance $124,204.12 Utility Services $146,587.36 Repairs and Maintenance $579,822.98 Rentals $2,110.87 3/2/2015 9:33:45 AM Page 9 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for Funds With Departments 2014 Governmental Activities General Fire Department Other Services and Charges $314,750.40 Tb al Services and Charges $1,362,330.71 Transfer Out-Transferred To Another $86,520.00 Fund Tb al Other Disbursements $86,520.00 Tb al Fire Department $21,383,944.22 Police Department(Town Marshall) Salaries and Wages $10,139,824.34 Employee Benefits $5,296,680.87 Tb al Personal Services $15,436,505.21 Office Supplies $23,799.75 Operating Supplies $480,364.05 Repair and Maintenance Supplies $29,739.35 Other Supplies $108,049.47 Tb al Supplies $641,952.62 Professional Services $37,073.71 Communication and Transportation $85,297.20 Printing and Advertising $7,359.85 Utility Services $88,891.05 Repairs and Maintenance $210,128.04 Rentals $945,047.72 3/212015 9:33:45 AM Page 10 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for Funds With Departments 2014 Governmental Activities General Police Department(Town Marshall) Other Services and Charges $175,017.96 Tb al Services and Charges $1,548,815.53 Machinery, Equipment, and Vehicles $74,268.44 Tb al Capital Outlays $74,268.44 Tb al Police Department(Tra n Marshall) $17,701,541.80 Redevelopment Salaries and Wages $3,030.00 Employee Benefits $112.45 Tb al Personal Services $3,142.45 Office Supplies $745.99 Tb al Supplies $745.99 Professional Services $169,231.91 Printing and Advertising $1,497.21 Insurance $200.00 Utility Services $7,533.10 Repairs and Maintenance $13,456.22 Rentals $41,764.06 Tb al Services and Charges $233,682.50 Tb ai Redevelopment $237,570.94 Parks Salaries and Wages $1,243,755.50 3/2/2015 9:33:45 AM Page 11 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for Funds With Departments 2014 Governmental Activities General Parks Employee Benefits $553,759.95 Tb al Personal Services $1,797,515.45 Office Supplies $9,762.50 Operating Supplies $26,194.08 Repair and Maintenance Supplies $48,028.62 Other Supplies $14,172.44 Tb al Supplies $98,157.64 Professional Services $169,389.30 Communication and Transportation $20,346.45 Printing and Advertising $6,044.93 Insurance $16,562.00 Utility Services $74,443.14 Repairs and Maintenance $406,504.28 Rentals $9,515.58 Other Services and Charges $34,212.39 Tb al Services and Charges $737,018.07 Machinery, Equipment, and Vehicles $18,825.46 Tb al Capital Outlays $18,825.46 Transfer Out-Transferred To Another $22,000.00 Fund Tb al Other Disbursements $22,000.00 3/2/2015 9.33:45 AM Page 12 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for Funds With Departments 2014 Tb at Parks $2,673,516.62 Governmental Activities General Golf Salaries and Wages $432,311.66 Employee Benefits $115,739.22 Tb al Personal Services $548,050.88 Office Supplies $1,448.40 Operating Supplies $18,013.75 Repair and Maintenance Supplies $16,104.72 Other Supplies $62,175.40 Tb al Supplies $97,742.27 Communication and Transportation $10,694.69 Printing and Advertising $6,444.94 Insurance $10,000.00 Utility Services $32,133.58 Repairs and Maintenance $101,845.69 Rentals $273,081.61 Other Services and Charges $70,512.12 Tb al Services and Charges $504,712.63 Machinery, Equipment, and Vehicles $854.10 Tb at Capital Outlays $854.10 • Transfer Out-Transferred To Another $2,000.00 Fund Tb at Other Disbursements $2,000.00 • Tb at Golf $1,153,359.88 • 3/2/2015 9:33:45 AM Page 13 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for Funds With Departments 2014 Governmental Activities General Information Technology Salaries and Wages $652,856.91 Employee Benefits $326,393.41 Tb al Personal Services $979,250.32 Office Supplies $2,526.16 Operating Supplies $369.15 Repair and Maintenance Supplies $3,862.49 Tb al Supplies $6,757.80 Professional Services $59,083.41 Communication and Transportation $11,083.45 Repairs and Maintenance $160,585.20 Rentals $15,541.75 Other Services and Charges $3,115.00 Tb al Services and Charges $249,408.81 Machinery, Equipment: and Vehicles $107,199.38 Tb al Capital Outlays $107,199.38 Tb al information Technology $1,342,616.31 Common Council Salaries and Wages $114,842.00 Employee Benefits $128,568.14 Tb al Personal Services $243,410.14 Office Supplies $199 36 3/212015 9:33:45 AM Page 14 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for Funds With Departments 2014 Governmental Activities General Common Council Other Supplies $87.45 Tb al Supplies $286.81 Professional Services $36,066.20 Communication and Transportation $6,047.60 Other Services and Charges $2,542,220.75 Tb al Services and Charges $2,584,334.55 Machinery, Equipment, and Vehicles $540.97 Tb al Capital Outlays $540.97 Transfer Out-Transferred To Another $632,335.00 Fund Tb al Other Disbursements $632,335.00 Tb al Common Council $3,460,907.47 Building Operations Operating Supplies $1,383.45 Repair and Maintenance Supplies $781.49 Tb al Supplies $2,164.94 Communication and Transportation $4,244.20 Insurance $2,352.00 Utility Services $913,658.69 3/2/2015 9:33:45 AM Page 15 Carmel Civil City, Hamilton County, Indiana Detailed Disbursements for Funds With Departments 2014 Governmental Activities General Building Operations Repairs and Maintenance $1,622,662.03 Tb al Services and Charges $2,542,916.92 Tb al Building Operations $2,545,081.86 Tb al General $71,466,359.49 Total Governmental Activities Disbursements for Funds with Departments $71,466,359.49 3/2/2015 5:33:45 AM Page 16 Carmel Civil City, Hamilton County, Indiana Detailed Receipts 2014 Governmental Activities Carmel City Court Court Costs and Fees $1,995,101.24 Total Fines,Forfeitures,and Fees $1,995,101.24 Total Carmel City Court $1,995,101.24 Payroll Fund Payroll Fund and Clearing Account Receipts $47,916,187.13 Total Other Receipts $47,916,187.13 Total Payroll Fund $47,916,187.13 General General Property Taxes $31,130,987.48 County Option Income Tax(COIT) $26,991,842.88 Food and Beverage Tax • $1,702,627.87 • ABC Excise Tax Distribution $36,729.00 Casino/Riverboat Distribution $469,121.20 Cigarette Tax Distribution $57,128.51 Financial Institution Tax distribution $16,034.77 Vehicle/Aircraft Excise Tax Distribution $3,493,703.04 Commercial Vehicle Excise Tax Distribution(CVET) $17,599.03 ABC Gallonage Tax Distribution $156,712.59 Federal and State Grants and Distributions-Public Safety $26,712.09 Total Taxes and Intergovernmental $64,099,198.46 Planning,Zoning,and Building Permits and Fees $2,011,270.34 Cable TV Licenses $662,330.66 Other Licenses and Permits/322000-Alarm Permits $4,290.00 Other Licenses and Permits/324000-Private Traffic Permits $3,119.00 Total Licenses and Permits $2,681,010.00 Document and Copy Fees $1,014.10 Park and Recreation Receipts $850,450.55 Federal,State,and Local Reimbursement for Services $383,164.07 Police Protection Contracts and Service Fees $1,282,455.37 Other Charges for Services,Sales,and Fees/349000-Cell Tower $55,465.80 Rental Total Charges for Services $2,572,549.89 3/2/2015 9:34:27 AM Page 1 Carmel Civil City, Hamilton County, Indiana Detailed Receipts 2014 Governmental Activities General Court Costs and Fees $603,487.05 Total Fines,Forfeitures,and Fees $603,487.05 Earnings on Investments and Deposits $882.10 Sale of Capital Assets $39.15 Refunds and Reimbursements $51,814.64 Payroll Fund and Clearing Account Receipts $1,096.00 Transfers In-Transferred from Another Fund $1,172,816-00 Other Receipts/360010-Other Miscellaneous $38,842.15 Other Receipts/362000-Rental Property Income $1,700.00 Other Receipts/392010-Mgt Fees from Utilities $1,042,999-90 Other Receipts/394000-Prior Year Cancelled Checks $243.48 Other Receipts/396010-Insurance Reimbursements $43,976.13 Total Other Receipts $2,354,409.55 Total General $72,310,654.95 Ambulance Fund Emergency Medical Services Fees $1,044,696-18 Total Charges for Services $1,044,696.18 Earnings on Investments and Deposits $773.06 Refunds and Reimbursements $1,624.15 Total Other Receipts $2,397.21 Total Ambulance Fund $1,047,093.39 Parks Capital Earnings on Investments and Deposits $477.93 Total Other Receipts $477.93 Total Parks Capital $477.93 Park Impact Fee Fund Park and Recreation Receipts $1,144,648.40 Total Charges for Services $1,144,648.40 Earnings on Investments and Deposits $1,440.92 Total Other Receipts $1,440.92 Total Park Impact Fee Fund $1,146,089.32 3/2/2015 9.34:27 AM Page 2 Carmel Civil City, Hamilton County, Indiana Detailed Receipts 2014 Governmental Activities Hazardous Material Response Fund Other Charges for Services,Sales,and Fees/342050-Haz Mat Fees $4,886.00 Total Charges for Services $4,886.00 Earnings on Investments and Deposits $10.51 Total Other Receipts $10.51 Total Hazardous Material Response Fund $4,896.51 Parks Program Fund Park and Recreation Receipts $3,636,401.13 Total Charges for Services $3,636,401.13 Earnings on Investments and Deposits $2,317.10 Refunds and Reimbursements $249.00 Donations,Gifts,and Bequests $3,866.50 Other Receipts/360010-Other Misc $3,606.00 Other Receipts/394000-Prior Year Cancelled Checks $4,719.86 Total Other Receipts $14,758.46 Total Parks Program Fund $3,651,159.59 _ Parks Monon Fund Park and Recreation Receipts $4,726,876.60 Other Charges for Services, Sales,and Fees/313000-Sales Tax $15,070.48 Collected Total Charges for Services $4,741,947.08 Earnings on Investments and Deposits $1,966.11 Refunds and Reimbursements $20,923.07 Donations,Gifts,and Bequests $20,426.90 Other Receipts/360010-Other Misc $19,888.96 Other Receipts/394000-Prior Year Cancelled Checks $130.00 Total Other Receipts $63,335.04 Total Parks Moo n Fund $4,805,282.12 Motor Vehicle Highway General Property Taxes $7,228,881.96 Financial Institution Tax distribution $3,721.88 Vehicle/Aircraft Excise Tax Distribution $810,945.94 Motor Vehicle Highway Distribution $2,959,407.96 Commercial Vehicle Excise Tax Distribution(CVET) $4,084.96 Total Taxes and Intergovernmental $11,007,042.70 Federal,State,and Local Reimbursement for Services $166,064.11 Total Charges for Services $166,064.11 312/2015 9:34:27 AM Page 3 Carmel Civil City, Hamilton County, Indiana Detailed Receipts 2014 Governmental Activities Motor Vehicle Highway Earnings on Investments and Deposits $1,736.14 Refunds and Reimbursements $4,186.00 Transfers In-Transferred from Another Fund $1,035,035.00 Other Receipts/360010-Other Misc $29,729.57 Other Receipts/360010-Stormwater management fee $22,127.56 Other Receipts/394000-Prior Year Cancelled Checks $50.00 Other Receipts/396010-Insurance Reimbursements $66,877.65 Total Other Receipts $1,159,741.92 Total Motor Vehicle Highway $12,332,848.73 Local Road And Street Local Road and Street Distribution $1,171,061.17 Total Taxes and Intergovernmental $1,171,061.17 Earnings on Investments and Deposits $878.66 Total Other Receipts $878.66 Total Local Road And Street $1,171,939.83 Cumulative Capital Improvement Cigarette Tax Distribution $209,471.19 Total Taxes and Intergovernmental $209,471.19 Earnings on Investments and Deposits $288.49 Total Other Receipts $288.49 Total Cumulative Capital Improvement $209,759.68 Cumulative Capital Sewer Earnings on Investments and Deposits $532.92 Total Other Receipts $532.92 Total Cumulative Capital Sewer $532.92 Deferral Fund Court Costs and Fees $105,285.00 Total Fines, Forfeitures,and Fees $105,285.00 Earnings on Investments and Deposits $611.17 Total Other Receipts $611.17 Total Deferral Fund $105,896.17 User Fee Fund Gun Permits $34,470.00 Total Licenses and Permits $34,470.00 Document and Copy Fees $34,170.00 Total Charges for Services $34,170.00 Court Costs and Fees $38,802.00 Total Fines,Forfeitures,and Fees $38,802.00 3/2/2015 9:34:27 AM Page 4 Carmel Civil City,Hamilton County, Indiana Detailed Receipts 2014 Governmental Activities User Fee Fund Earnings on Investments and Deposits $137.20 Refunds and Reimbursements $44.16 Other Receipts/360010-Other Misc $3.00 Total Other Receipts $184.36 Total User Fee Fund $107,626.36 Cumulative Captial Development General Property Taxes $1,597,369.51 Financial Institution Tax distribution $822.45 Vehicle/Aircraft Excise Tax Distribution $179,196.75 Commercial Vehicle Excise Tax Distribution(CVET) $902.68 Federal and State Grants and Distributions-Highways and Streets $623.26 Total Taxes and Intergovernmental $1,778,914.65 Earnings on Investments and Deposits $452.52 Total Other Receipts $452.52 Total Cumulative Captial Development $1,779,367.17 Illinois St Construction Fund Earnings on Investments and Deposits $3,260.34 Sale of Capital Assets $272,098.16 Total Other Receipts $275,358.50 Total Illinois St Construction Fund $275,358.50 Barrett Law Surplus Earnings on Investments and Deposits $172.28 Total Other Receipts $172.28 Total Barrett Law Surplus $172.28 Health Insurance Fund Earnings on Investments and Deposits $2,841.82 Refunds and Reimbursements $50,975.80 Benefit Plan Contributions $11,396,520.41 Other Receipts/360010-Flex savings $17,897.54 Other Receipts/360010-Other Misc $19,382.53 Total Other Receipts $11,487,618.10 Total Health Insurance Fund $11,487,618.10 Workers Comp Fund Earnings on Investments and Deposits $208 83 Refunds and Reimbursements $12,800.00 Transfers In-Transferred from Another Fund $425,520.00 Total Other Receipts $438,528.83 Total Workers Comp Fund $438,528.83 3/2/2015 9:3427 AM Page 5 Carmel Civil City, Hamilton County, Indiana Detailed Receipts 2014 Governmental Activities Lease Rental Fund Earnings on Investments and Deposits $3.98 Total Other Receipts $3.98 Total Lease Rental Fund $3.98 2004 Road Bond Fund General Property Taxes $597,517.81 Financial Institution Tax distribution $300.97 Vehicle/Aircraft Excise Tax Distribution $65,591.34 Commercial Vehicle Excise Tax Distribution(CVET) $330.33 Total Taxes and Intergovernmental $663,740.45 Earnings on Investments and Deposits $18.51 Total Other Receipts $18.51 Total 2004 Road Bond Fund $663,758.96 Old Town/126Th Street Earnings on Investments and Deposits $0.46 Total Other Receipts $0.46 • Total Old Town/126Th Street $0.46 Dnr/Tree City Earnings on Investments and Deposits $53.09 Donations,Gifts,and Bequests $560.00 Total Other Receipts $613.09 Total Dnr/Tree City $613.09 Clerk's Record Perpetuation Document and Copy Fees $20,209.45 Total Charges for Services $20,209.45 Earnings on Investments and Deposits $118.48 Total Other Receipts $118.48 Total Clerk's Record Perpetuation $20,327.93 Court Interperter Fund Court Costs and Fees $15.00 Total Fines,Forfeitures,and Fees $15.00 Earnings on Investments and Deposits $0.01 Total Other Receipts $0.01 Total Court Interperter Fund $15.01 3/2/2015 9:34:27 AM Page 6 Carmel Civil City, Hamilton County, Indiana Detailed Receipts 2014 Governmental Activities Support For The Arts Earnings on Investments and Deposits $17.82 Transfers In-Transferred from Another Fund $632,335.00 Total Other Receipts $632,352.82 Total Support For The Arts $632,352.82 : : : : " •- '''"- '' ' 7 7 . _ . Public Defenders Fund Court Costs and Fees $125.00 Total Fines, Forfeitures,and Fees $125.00 Earnings on Investments and Deposits $1.64 Total Other Receipts $1.64 Total Public Defenders Fund $126.64 JUDICIAL SALARY FEES Court Costs and Fees $44,589.45 Total Fines,Forfeitures,and Fees $44,589.45 ._ Earnings on Investments and Deposits $146.94 Total Other Receipts $146.94 Total JUDICIAL SALARY FEES $44,736.39 '7' — - — ---- - - Historic Preservation Fund Earnings on Investments and Deposits $0.85 Total Other Receipts $0.85 -- Total Historic Preservation Fund $0.85 Police Pension Fund Federal,State,and Local Reimbursement for Services $513,234.57 Total Charges for Services $513,234.57 -- Earnings on Investments and Deposits $255.37 Total Other Receipts $255.37 . _ Total Police Pension Fund $513,489.94 Fire Pension Fund Federal,State,and Local Reimbursement for Services $555,229.77 Total Charges for Services $555,229.77 . . Earnings on Investments and Deposits $152.58 Total Other Receipts $152.58 Total Fire Pension Fund $555,382.35 _ . ___ _ _..... _ ....... _ . . ................... _ ........ „ Fire Gift Fund Earnings on Investments and Deposits $7.96 Donations,Gifts,and Bequests $24,677.14 Total Other Receipts -. . _ Total Fire Gift Fund $24,685.10 .. .. . . . . . . . 3/2/2015 9:34:27 AM Page 7 Cannel Civil City, Hamilton County, Indiana Detailed Receipts 2014 Governmental Activities Police Gift Earnings on Investments and Deposits $25.38 Donations,Gifts,and Bequests $1,994.60 Total Other Receipts $2,019.98 Total Police Gift $2,019.98 Parks Gift Fund Earnings on Investments and Deposits $50.27 Donations,Gifts,and Bequests $5,217.00 Other Receipts/394000-Prior Year Cancelled Checks $208.71 Total Other Receipts $5,475.98 Total Parks Gift Fund $5,475.98 Community Relations Gift Fund Earnings on Investments and Deposits $105.00 Refunds and Reimbursements $129.45 Donations,Gifts,and Bequests $19,181.39 Other Receipts/367008-Festival Proceeds $116,390.75 Total Other Receipts $135,806.59 Total Community Relations Gift Fund $135,806.59 Grant Fund Federal and State Grants and Distributions-Public Safety $104,243.26 Total Taxes and Intergovernmental $104,243.26 Earnings on Investments and Deposits $446.82 Donations,Gifts,and Bequests $9,357.48 Total Other Receipts $9,804.30 Total Grant Fund $114,047.56 Redevelopment Commission General Property Taxes $22,118,693.35 Total Taxes and Intergovernmental $22,118,693.35 g Deposits . . _ . Earnings on Investments and De $3,320.83 Sale of Capital Assets $1,019,884.50 Refunds and Reimbursements $180,090.88 Grants and Distributions from Non-Governmental Entities $231,782.00 Other Receipts/392050-PILT $47,136-32 Other Receipts/393000-Redevelopment Commission Project $1,561,518.40 Revenues Other Receipts/393020-Settlement Fees $4,350,000.00 Other Receipts/396010-Insurance Reimbursement $136,241.00 Total Other Receipts $7,529,973.93 Total Redevelopment Commission $29,648,667.28 312/2015 9:34:27 AM Page 8 Carmel Civil City, Hamilton County, Indiana Detailed Receipts 2014 Governmental Activities Economic Fund Earnings on Investments and Deposits $50.35 Total Other Receipts $50.35 Total Ecoo mic Fund $50.35 Housing Authority Earnings on Investments and Deposits $61.01 Total Other Receipts $61.01 Total Housing Authority $61.01 Drug Task Force Federal and State Grants and Distnbutions-Other/333000-Other $27,057.74 Intergovernmental Total Taxes and Intergovernmental $27,057.74 Earnings on Investments and Deposits $531.19 Transfers In-Transferred from Another Fund $12,509.28 Other Receipts/360010-Other Misc $187,763.40 Total Other Receipts $200,803.87 Total Drug Task Force $227,861.61 Rainy Day Earnings on Investments and Deposits $8,980.16 Transfers In-Transferred from Another Fund $220,000.00 Total Other Receipts $228,980.16 Total Rainy Day $228,980.16 Throughfare Fund Planning,Zoning,and Building Permits and Fees S192,280.00 Total Licenses and Permits 5192,280.00 Earnings on Investments and Deposits $376.24 Total Other Receipts $376.24 Total Throughtare Fund $192,656.24 Keystone Ave Fund Earnings on Investments and Deposits $122.13 Sale of Capital Assets $159,662.35 Total Other Receipts $159,784.48 Total Keystoo Ave Fund $159,784.48 Levy Excess Fund General Property Taxes $56731 Total Taxes and Intergovernmental $567.31 Total Levy Excess Fund $567.31 Total Governmental Activities $193,958,062.82 3/2/2015 9 34.27 AM Page 9 Carmel Civil City, Hamilton County, Indiana Detailed Receipts 2014 WASTEWATER Wastewater Bond&Interest At Bony Earnings on Investments and Deposits $0 52 Transfers In-Transferred from Another Fund $1,750,79186 Total Other Receipts $1,750,792.38 Total Was ewater Bond&Interest At Bop $1,750,792.38 Sewage Works Revenue Bonds Earnings on Investments and Deposits $8,655.09 Total Other Receipts $8,655.09 Total Sewage Works Revenue Bonds $8,655.09 _ Sewer Operating Sewage Fees $1,854,744.59 Other Charges for Services, Sales,and Fees/333000-Other $13,201.98 Other Charges for Services, Sales,and Fees/360010-Misc. $15,545.12 Total Charges for Services $1,883,491.69 Earnings on Investments and Deposits $95 82 Transfers In-Transferred from Another Fund $537,603.55 Other Receipts/392000-Interfund Trans-Sewer Sales $6,783,255.59 Total Other Receipts $7,320,954.96 Total Sewer Operating $9,204,446.65 Sewer Depreciating Transfers In-Transferred from Another Fund $240,384.00 Other Receipts/360010-Misc Revenue $5,229.79 Total Other Receipts $245,613.79 Total Sewer Depreciating $245,613.79 Sewer Connection Fund Earnings on investments and Deposits $451.65 Transfers In-Transferred from Another Fund $3,978.00 Other Receipts/348230-Connection Fees $684,016.96 Total Other Receipts $688,446.61 Total Sewer Connection Fund $688,446.61 Sewer Availability Fund Earnings on Investments and Deposits $154.65 Other Receipts/348240-Availabilty Fees $88,770.92 Total Other Receipts $88,925.57 Total Sewer Availability Fund $88,925.57 Total WASTEWATER $11,986,880.09 312/2015 9:34:27 AM Page 10 Carmel Civil City, Hamilton County, Indiana Detailed Receipts 2014 WATER Water Operating Rental of Property $79,265.01 Metered or Measured Sales and Services $12,986,055.14 Other Charges for Services,Sales,and Fees/360010-Misc $270,764.33 Total Charges for Services $13,336,084.48 Earnings on Investments and Deposits $1,356.87 Transfers In-Transferred from Another Fund $4,019.64 Other Receipts/333000-State $48,370.00 Other Receipts/348010-User Fees-Sewer Collected $7,295,455.49 Other Receipts/348010-User Fees-Stormwater Collected $409,432.73 Other Receipts/348010-User Fees-Tax $837,288.54 Other Receipts/348010-User Fees-Trash Collected $2,418,970.04 Other Receipts/394000-Prior Yr Cancelled CKs $341.05 Total Other Receipts $11,015,234.36 Total Water Operating $24,351,318.84 Hydrant Meter Deposit Fund Other Receipts/348250-Hyd Meter Dep $1,735.00 Total Other Receipts $1,735.00 Total Hydrant Meter Deposit Fund $1,735.00 Water Depreciation Transfers In-Transferred from Another Fund S327,435 00 Total Other Receipts $327,435.00 Total Water Depreciation $327,435.00 Water Bond&Interest Transfers In-Transferred from Another Fund $73,859.50 Total Other Receipts $73,859.50 Total Water Bond&Interest $73,859.50 Water Sinking Fund Earnings on Investments and Deposits $1,161.99 Transfers In-Transferred from Another Fund $4,766,925.00 Total Other Receipts $4,768,086.99 Total Water Sinking Fund $4,768,086.99 Water Connection Earnings on Investments and Deposits $217.72 Transfers In-Transferred from Another Fund $519,303.23 Other Receipts/348230-Connection Fees $2,545,738.21 Total Other Receipts $3,065,259.16 Total Water Connection $3,065,259.16 3/2/2015 9:34:27 AM Page 11 Carmel Civil City, Hamilton County, Indiana Detailed Receipts 2014 WATER Water Availability Transfers In-Transferred from Another Fund $87,011.05 Other Receipts/348240-Availability Fees $761,978.78 Total Other Receipts $848,989.83 Total Water Availability $848,989.83 Total WATER $33,436,684.32 STORM WATER Non Reverting Storm Water Storm Water Fees $88,510.28 Total Charges for Services $88,510.28 Earnings on Investments and Deposits $2.06 Total Other Receipts $2.06 Total Non Reverting Storm Water $88,512.34 Total STORM WATER $88,512.34 3/2/2015 9:3427 AM Page 12 Carmel Civil City, Hamilton County, Indiana Beginning & Ending Cash Balance Comparison 2014 2014 2013 Fund Beginning Ending Code Fund Name Cash Cash Difference 101001 General $3,704,739.68 $3,704,607.65 $132.03 102001 Motor Vehicle Highway $2,933,641.73 $2,933,636.07 $5.66 900004 Historic Preservation Fund $2,792.84 $0.00 $2,792.84 902047 Drug Task Force $562,295.65 $562,292.96 $2.69 902905 Redevelopment Commission $7,959,589.31 $7,959,588.33 $0.98 902908 Carmel City Court $166,160.23 $0.00 $166,160.23 902908 Carmel City Court $166,160.23 $205,466.05 $-39,305.82 902910 Parks Monon Fund $1,844,468.15 $1,824,338.40 $20,129.75 910037 Payroll Fund $205,466.05 $0.00 $205,466.05 910037 Payroll Fund $205,466.05 $166,160.23 $39,305.82