|
Cash Benchmarking Report 4/4/2014 21
<br />Carmel Civil City, Hamilton County, Indiana
<br />Cash & Investments Combined Statement - 2013
<br />Beg Cash
<br />End Cash
<br />& Inv Bal
<br />& Inv Bal
<br />Local Fund
<br />Local Fund Name
<br />Jan 1, 2013
<br />Receipts
<br />Disbursement
<br />Dec 31, 2013
<br />Number
<br />Governmental Activities 0
<br />Crc Regions Account
<br />$3,954,179.93
<br />$1,416.11
<br />$3,955,596.04
<br />$0.00
<br />0
<br />Carmel City Court
<br />$628,505.00
<br />$1,922,390.71
<br />$2,384,735.48
<br />$166,160.23
<br />0
<br />Payroll Fund
<br />$ 277, 146.38
<br />$44,637,420.98
<br />$44,709,101.31
<br />$205,466.05
<br />1
<br />General
<br />$2,454,931.88
<br />$73,229,636.52
<br />$71,979,960.75
<br />$3,704,607.65
<br />102
<br />Ambulance Fund
<br />$700,563.07
<br />$1,122,658.50
<br />$1,034,206.29
<br />$789,015.28
<br />103
<br />Parks Capital
<br />$689,265.08
<br />$731.49
<br />$230,147.53
<br />$459,849.04
<br />106
<br />Park Impact Fee Fund
<br />$1,905,206.45
<br />$816,715.64
<br />$843,897.32
<br />$1,878,024.77
<br />107
<br />Hazardous Material Response Fund
<br />$7,536.05
<br />$761.75
<br />$0.00
<br />$8,297.80
<br />108
<br />Parks Program Fund
<br />$1,173,985.54
<br />$3,607,772.87
<br />$3,028,294.40
<br />$1,753,464.01
<br />109
<br />Parks Monon Fund
<br />$1, 509, 330.94
<br />$4,852,955.92
<br />$4,537,948.46
<br />$1,824,338.40
<br />201
<br />Motor Vehicle Highway
<br />$2,705,139.74
<br />$10,149,079.75
<br />$9,920,583.42
<br />$2,933,636.07
<br />202
<br />Local Road And Street
<br />$2,057,349.59
<br />$1,132,695.20
<br />$2,527,735.00
<br />$662,309.79
<br />203
<br />Cumulative Capital Improvement
<br />$727,093.29
<br />$213,279.35
<br />$553,971.15
<br />$386,401.49
<br />206
<br />Cumulative Capital Sewer
<br />$912,348.84
<br />$720.13
<br />$385,310.61
<br />$527,758.36
<br />209
<br />Deferral Fund
<br />$559,717.63
<br />$76,690.38
<br />$60,222.29
<br />$576,185.72
<br />210
<br />User Fee Fund
<br />$125,905.23
<br />$117,621.31
<br />$110,841.86
<br />$132,684.68
<br />211
<br />Cumulative Captial Development
<br />$3,015,643.56
<br />$1,725,408.72
<br />$3,765,896.18
<br />$975,156.10
<br />212
<br />Illinois St Construction Fund
<br />$700,177.79
<br />$3,183,695.81
<br />$61,400.68
<br />$3,822,472.92
<br />220
<br />Barrett Law Fund
<br />$5.67
<br />$0.00
<br />$0.00
<br />$5.67
<br />221
<br />Barrett Law Surplus
<br />$165,445.05
<br />$250.30
<br />$0.00
<br />$165,695.35
<br />301
<br />Health Insurance Fund
<br />$3,377,674.77
<br />$11,985,566.67
<br />$12,091,018.42
<br />$3,272,223.02
<br />302
<br />Workers Comp Fund
<br />$36,169.57
<br />$270,969.85
<br />$307,139.42
<br />$0.00
<br />402
<br />Civic Square Construction Fund
<br />$595.41
<br />$0.22
<br />$0.00
<br />$595.63
<br />403
<br />Lease Rental Fund
<br />$3,833.98
<br />$5.79
<br />$0.00
<br />$3,839.77
<br />450
<br />Old Town /126Th Street
<br />$457.61
<br />$0.68
<br />$0.00
<br />$458.29
<br />501
<br />Dnr/Tree City
<br />$50,223.19
<br />$306.50
<br />$26.46
<br />$50,503.23
<br />502
<br />Clerk's Record Perpetuation
<br />$95,213.22
<br />$19,510.06
<br />$9,570.46
<br />$105,152.82
<br />503
<br />Court Interperter Fund
<br />$3,429.14
<br />$0.76
<br />$3,400.00
<br />$29.90
<br />504
<br />Support For The Arts
<br />$119,855.62
<br />$740,036.62
<br />$842,756.00
<br />$17,136.24
<br />505
<br />Public Defenders Fund
<br />$1,028.60
<br />$452.10
<br />$0.00
<br />$1,480.70
<br />506
<br />JUDICIAL SALARY FEES
<br />$90,394.78
<br />$44,065.09
<br />$14,278.84
<br />$120,181.03
<br />801
<br />Police Pension Fund
<br />$2,384,605.10
<br />$514,967.62
<br />$2,089,493.42
<br />$810,079.30
<br />802
<br />Fire Pension Fund
<br />$2,728,575.86
<br />$574,793.65
<br />$2,734,727.83
<br />$568,641.68
<br />851
<br />Fire Gift Fund
<br />$5,726.48
<br />$19,097.52
<br />$16,680.84
<br />$8,143.16
<br />852
<br />Police Gift
<br />$38,799.66
<br />$12,171.23
<br />$20,491.30
<br />$30,479.59
<br />853
<br />Parks Gift Fund
<br />$49,714.66
<br />$3,259.77
<br />$4,930.95
<br />$48,043.48
<br />854
<br />Community Relations Gift Fund
<br />$19,346.92
<br />$84,061.80
<br />$41,127.76
<br />$62,280.96
<br />900
<br />Grant Fund
<br />$574,496.24
<br />$50,521.67
<br />$153,014.55
<br />$472,003.36
<br />902
<br />Redevelopment Commission
<br />$14,353.15
<br />$26,948,107.17
<br />$19,002,871.99
<br />$7,959,588.33
<br />903
<br />Economic Fund
<br />$38,351.26
<br />$10,059.82
<br />$0.00
<br />$48,411.08
<br />904
<br />Housing Authority
<br />$58,589.79
<br />$88.65
<br />$0.00
<br />$58,678.44
<br />911
<br />Drug Task Force
<br />$588,416.31
<br />$143,520.14
<br />$169,643.49
<br />$562,292.96
<br />912
<br />Rainy Day
<br />$8,963,321.12
<br />$13,561.12
<br />$0.00
<br />$8,976,882.24
<br />919
<br />Throughfare Fund
<br />$483,775.81
<br />$417,005.67
<br />$639,463.28
<br />$261,318.20
<br />920
<br />Keystone Ave Fund
<br />$2,903,739.27
<br />$3,294.43
<br />$2,665,092.46
<br />$241,941.24
<br />SubTotal
<br />$46,900,164.23
<br />$188,647,326.04
<br />$190,895,576.24
<br />$44,651,914.03
<br />WASTEWATER 0
<br />Wastewater Bond & Interest At Bony
<br />$2,450,635.52
<br />$1,763,976.85
<br />$1,414,238.18
<br />$2,800,374.19
<br />2012
<br />Sewage Works Revenue Bonds
<br />$8,103,357.35
<br />$51,081.81
<br />$4,339,128.60
<br />$3,815,310.56
<br />651
<br />Sewer Operating
<br />$65,158.54
<br />$9,242,083.42
<br />$9,286,853.98
<br />$20,387.98
<br />652
<br />Sewer Depreciating
<br />$1.91
<br />$229,454.48
<br />$229,456.36
<br />$0.03
<br />659
<br />Sewer Connection Fund
<br />$5,734.98
<br />$410,849.10
<br />$234,393.00
<br />$182,191.08
<br />660
<br />Sewer Availability Fund
<br />$5,364.85
<br />$118,682.03
<br />$3,156.36
<br />$120,890.52
<br />SubTotal
<br />$10,630,253.15
<br />$11,616,127.69
<br />$15,507,226.48
<br />$6,939,154.36
<br />WATER 601
<br />Water Operating
<br />$222,297.95
<br />$25,138,840.00
<br />$25,341,880.11
<br />$19,257.84
<br />602
<br />Hydrant Meter Deposit Fund
<br />$36,965.00
<br />$2,725.00
<br />$500.00
<br />$39,190.00
<br />604
<br />Water Depreciation
<br />$1.92
<br />$225,994.26
<br />$225,996.02
<br />$0.16
<br />605
<br />Water Bond & Interest
<br />$1,146,139.50
<br />$80,574.00
<br />$0.00
<br />$1,226,713.50
<br />606
<br />Water Sinking Fund
<br />$ 922, 465.56
<br />$4,265,709.20
<br />$4,860,418.96
<br />$327,755.80
<br />609
<br />Water Connection
<br />$16,608.98
<br />$2,111,162.37
<br />$2,127,681.38
<br />$89.97
<br />610
<br />Water Availability
<br />$0.00
<br />$3,027,193.77
<br />$3,027,181.04
<br />$12.73
<br />SubTotal
<br />$2,344,478.91
<br />$34,652,198.60
<br />$35,583,657.51
<br />$1,613,020.00
<br />GRAND TOTAL
<br />$59,874,896.29
<br />$235,315,652.33
<br />$241,986,460.23
<br />$53,204,088.39
<br />Cash Benchmarking Report 4/4/2014 21
<br />
|