Loading...
07 - Financial ReportItem No. 7 TO: City Council John Godwin, City Manager FROM: Gene Anderson, Finance Director SUBJECT: JANUARY 101.8 FINANCIAL REPORT DATE: February 8, 2018 BACKGROUND: Section 69 (3) of the Paris City Charter requires the Finance Director to subunit to the City Council through the City Manager a monthly statement of all receipts and disbursements. The attached report satisfies that requirement. STATUS, OF ISSUE: This report updates the City Council on the City's financial activities through the month stated in the subject line, BUDGET: Not affected by this report, RECOMMENDATION: Motion to receive the monthly financial report, City of Paris January 2018 Financial Report Comments Net to Date Comparison of Revenues: L The operations and maintenance property tax and related collections are 7,39% more than this time last year. Current tax coHections are 81.95% of the tax levy vs. 80,73% last year. 2. Sa6es taxes are up 1.25% from vast year. 1 Hotel occupancy taxes are down 1.28% from last year. Ail hotels are current on their taxes except for Baymont Inn which is delinquent for the quarter ending 12-31-2017, 4. Franchise fees are up 4.64% compared to last year. 5. Permit fees are up 90.84% from last year. This amounts $36,678. 6. Municipal Court fines and related fees are 3,43% below last year's coIllections. 7. Other revenue includes leases, interest, copy fees, birth & death certificates, library fees, mixed beverage tax, and other minor revenues. This revenue is down $320 compared to last year. 8. Sanitation fees are down I5.58%. This was expected with more of these fees going directly to the Sanitation Fund in this year's budget. ,9. EMS fees are up 6.13% compared to last year, 10. Total General Fund revenues, net of any transfers, are 5.23% above last year. General Fund revenues equal 47.7'3% of the budget with the City being 33,33% through the budget year. IL Total General Fund expenditures are down 0,95% compared to last year. General Fund expenditures to date equaV 30.64% of budget with the City being 33.33% through the budget year. 12. Sewer revenue is down 0.91% compared to last year. 13, Water revenue is down 3.25% compared to last year. 14. Total Water & Sewer revenues, ignoring transfers, are 1,85% below last year. 15. Total Water & Sewer expenses are 7.86% above last year at this point and represent 23,05% of the total budget (36.94% adjusted for debt payments) while the City is 33.33% through the budget year, Departmental Expenditure Summary: At this point the City is four months or 33.33% through the budget year. It is important to remember that expenditures do not occur equally throughout the year. For example, capital expenditures and association memberships are one time expenditures that if made early in the fiscal year can produce a distorted expenditure percentage. Within the General, Water & Sewer, and Sanitation Funds there are five departments whose expenditures are over 33.33%. L City Council -66.86%, The overage amounts to $27,343. This overage is due to the annual insurance payment, election related expenses, updating ordinance book, replacing restrooms' water heater, and building maintenance. 2. Cox Field Airport -36.5,2%,. The overage amounts to $3,761 and is due to the annual insurance payment. 3. General Expenses -36.75%. The overage amounts to $57,149 and is due to payments nnade to non -profits and the Health District, 4. Walter Treatment Plant -35.15%. The overage amounts to $57,215 and is due to work on water storage tanks, pumps, and the purchase of a vehicle. 5. Water Distribution -34.09%. The overage amounts to $ 11,362 and is due to the annual insurance payment and purchase of trailer and spreader, General comments to the City Councik over 99% of all of the City operational activity takes place in the General Fund, the Water & Sewer Fund, or the Sanitation Fund. The other funds are special purpose funds with limited activity and usually with legal restrictionsnn what their money can be spent on. For that reason' I normally only comment on the activity of the General Fund, Water & Sewer Fund, and the Sanitation Fund. How/ever, if circumstances merited it, p would make comment on activity in one ofthe other funds. | try to anticipate questions you might have about the report and comment on those points. After you receive your packet and review the monthly report, if you have questions about the repmrt,pJease|ettheManagerknovv(ormneifynucan'1reachiheK4onager)befonetheCound| meeting if possible in case | have to research the answer to your question, That does not prevent you from asking the question at the meeting if you wish to make a point, but it does help prevent questions coming up that | can't answer on the spot and possibly delaying the Council immaking adecision. The activity of the Paris Economic Development Corporation is reflected in the monthly report. This is a result of the City perform�ng the bookkeeping functions for this agency. PED[has its own managing board. LM---* • 'fill City of Paris Fund! Recan. f General Fund: Current Prior Net Report Sort Sequence Report Group Description Year Year To Date 70 Taxes Collected 6,045,96916 5,,629,814,58 416,154.58 71 Sales Tax 2,378,955,93 2,349,571.09 29,384.84 72 Hotel/Motel Tax 314,671,11 318,750.65 -4,079-54 73 Franchise Fees 989,324,20 945,445.96 43,878.24 74 Permits 77,05539 40,377.13 36,678.86 75 Court Fines 74,702,68 77,359-36 -2,656.68 77 Other Revenue 155,122.79 155,443.59 -320.80 78 Sanitation 116,441.81 13,7,937,56 -21,495.75 79 Ems Fees 902,440,06 850,282.64 52,157.42 Total Revenue: $ 11,054,683.73 $ 10,504,982.56 $ 549,701.17 Total Expenditures; $ 7,066,329.29 $ 7,133,749.33 $ (67,430.04) Net To Date: $ 3,988,364.44 $ 3,371,233.23 $ 617,131.21 Ems Fees Sanitation Other Revenue Court Fines Permits Franchise Fees Hartel/Motel Tax Sales Tax 'Faxes Collected 1,VVV,VUU,VLJ 1,uuUU(JU00 3,000,000.00 4,000,000,00 5,000,000.00 6,000,000,00 7,000,000.00 U Prior Year III Current Year ExpenditureS Nrd Number Department Number i General Fund Department Current Name Month Actual 0 Non -Departmental 000 11 City Council 5,314,50 12 City Manager 29,561.40 13 City Attorney 16,215.49 A Municipal Court 16,638 29 15 City Clerk 8,53093 21 Accounting & Auditing 35,379.46 31 Police 558,067.24 32 Fire 466,393-52 40 Community Developm 22,513.67 41 Engineering 26,971.00 42 Public Works 17,03432 43 Parks, Recreation,& RC 80,798.95 44 Sanitation 0,00 46 Streets & Highways 135,437,08 48 Traffic & Public Lighth 40,903.39 49 Garage 23,305.56 51 Paris -Lamar Co Health 1,878,00 54 Emergency medical Se 217,012,67 61 Cox Field Airport 8,150.76 62 Paris Band 0.00 64 Library 65,634,73 89 General Expenses 79,410.17 90 Debt 0.00 91 Contingency 000 General Fund' $1,855, 154.43 Prior Month Actual OM 4,819.67 27,943.46 24,901.84 16,739-69 10,099 79 39,36796 537,192.71 347,00,5.15 -34,187.10 29,12417 16,679,68 60,964.59 2,377.62 132,45418 46,713.58 24,287.04 0.00 204,348.55 6,411.63 Oko 64,11&16 53,882.53 0.00 0,00 $,1,615,2,45.60 Current Year To Date 0.00 54,517.85 113,855,14 75,411,80 72,427.76 42,528.53 136,61951 2,036,32.0.55 1,550,950.57 110,229.04 107,495.79 68,972.04 141,626,41 229.36 506,312.81 181,917.33 105,7S9.32 1,878,00 859,839.87 42,974.42 5036 242,437.55 613,965.28 0100 0.00 $7,066,319.29 Prior Year To Date 0.00 40,1,65.45 113,868,03 87,241-05 70,357J4 43,725,77 143,391,77 2,115,420.52 1,477,258M 73,604.92 96,826.45 66,86835 248,328 13 3,885M 599,967.43 172,129.73 101,207.47 80,00 813,227,09 41,524.97 53,23 240,78416 583,83179 0.00 0.00 $7,133,74933 Current Year Budget 0.00 81,530.00 392,116.00 347,968.00 244,555.00 149,045.00 442,839.00 6,396,659.00 4,916,871.00 333,388.00 505,066,00 231,598,Oo 1,2 34,015.00 0.00 1,579,58100 564,620,00 361,500oo 0.00 2,685,200.00 117,650.00 23,050.00 733,179.00 1,670,615,00 0,00 50,000.00 $23,061,047= Prior Year Budget 0.00 76,430.00 376,383,00 378,928.00 2:32,063.00 143,688.00 425,416.00 ,5,113,190.00 4,680,012.77 S41,768,00 492,522.00 21.6, 3.37.00 1,120, 3 24.00 0.00 1,569,116.00 583,250.00 342,686.00 0.00 2,693,797.00 106,950.00 23,050.00 694,85000 1,605,333.00 0.00 50,000.00 $22,466,093,.77 Other Sewer Water Water Sewer Fund: Current Prior Net Revenue Groups Year, Year T^ M + Water Sewer Other Total Revenue: Total Expenditures: Net To Date: 0100 500,000.00 11000,000.00 1,500,000.00 2,000,000,00 2,500,000.0 0 3,000,000.00 Imill Prior Year IIII Current Year a V 2,631,969.76 2,720,345.24 -88,375.48 1,908,439.98 1,925,999.99 -17,560.01 190,032,99 173,281.18 16,751.81 4,730,442.73 $ 4,819,626.41 (89,183.68) $ 3,378,419.65 $ �7$1,352,023.08_.L_ 3,132,130.02 $ 2461,289.63 _ 1,687,496.39 $ (335,473.31)- 0100 500,000.00 11000,000.00 1,500,000.00 2,000,000,00 2,500,000.0 0 3,000,000.00 Imill Prior Year IIII Current Year Expenditures Water / Sewer Fund Fund NxPbP.s 10 Water & Sewer Fund Department Department Current Year Prior Year Current Year INumbt er Name Month Month To Date 80 Warehouse 4,72931 8,1.92.29 35,120.03 81 W & S Billing and Collecting 186,67166 192,840.77 737,095.70 82 Water Production 259,936-63 253,804-14 1,103,380,01. 83 Water Distribution 119,594.97 117,705.1.7 503,981.22 85 Sewer Maintenance 56,842,99 41,092,74 203,100,73 86 Waste Water Treatment 197,262.78 163,381.88 695,774.87 87 Lift Stations 23,646.22 24,864-34 99,967,09 Total Water & Sewer Fund $848,686,96 $791,881,33 $3,378,419.65 Prior Year To Date 34,76,5.41 709,515.50 996,614.78 500,343.24 179,135,78 706,877,46 104,877.85 $3,132,130.02 Current Year Suidget 107,284rOO 2,187,749.00 2, 762, 802.00 1,367,033.00 600,11800 2,036,450M 332,142.00 $9,393,578.00 Prior Year Budget 101,355.00 2,096,039.00 2,433,377.00 1,354,006.00 811,268.00 1,981,465.00 323,520.00 $9,101,030.00 Fund Number 2 Economic Development Fut Current Year Prior Year Net To Date Revenue $ 476,905.16 $ 350,638.79 $ 126,266,37 Expenditure $ 132,083.90 $ 125,124.94 $ 6,958.96 Subtotal Net To Date: 344,821.26 $ 225,513.85 $ 119,307.41 Fund Number 11 Capital Projects Fund Current Year Prior Year Net To Date, Revenue 747,087.21 $ 2,353.11 $ 744,734.10 Expenditure 371460.93 441,423.03 $, (403,962,10) Subtotal Net To Date: $ 709,626.28 $ (439,069.92) $ 1,148,696.20 Fund Number 12 WW&SS Rev Bond 2000 Cc Current Year Prior Year Net To Date Revenue $ $$ Expenditure $ $ Subtotal Net To Date: Fund Number 13 Equipment Replacement Ft Current Year Prior Year Net To Date Revenue 5714 193.90 $ (136,76) Expenditure $ $ $ Subtotal Net To Date: $ 57.14 $ 193.90 $ (136.76) Fund Number 14 CO 2.010 Construction, Fun( Current Year, Prior Year Net To Date Revenue $ 196.08 $ 400.44 $ (204.36) Expenditure - $ 461.50 $ (461.50) Subtotall Net To Date: 196.08 $ (61M) 257.14 Fund Number 16 TWDB Loan Fund Current Year Prior Year Net To Date Revenue 198.65 2,346.52 $ (2,147.87) Expenditure $ Subtotal Net To Date- . ...... . . . . 198.65 2,346.52 (2,147,87) Fund Number 17 Library Construction Fund Current Year, Prior, Year Net To Date Revenue $ $ $ Expenditure $ $ Subtotal Net To Date,: $ $ Fund Number is, W&S Series'97 Const Fund Current Year Prior Year Net To Date Revenue $$1 Expenditure $ $ Subtotal Net To Date: $ $ $ Fund Number 19 Water Revenue Const Fund Current Year Prior Year Net To Date Revenue $ $$ Expenditure $ $ Subtotal Net To Date: Fund Number 20 Special Revenue Fund Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ Subtotal Net To Date: $ $ Fund Number 21 Child Safety Fund Current Year Prior Year Net'To Date Revenue $ 9.83 5.10 $ 4.73 Expenditure $ $ 60000 $ (600.00) Subtotal Net To Date: $ 9.83 $ (ST4. 0) $ 604.73 Fund Number 22 H:ealth Department Fund Current Year Prior Year Net To Date Revenue $ $ $ Expenditure —$ re $ Subtotal Net To Date: $ $ Fund Number 23 PEG Channel Fund Current Year Prior Year Net To Date Subtotal Fund Number Subtotal Fund Number Subtotal Fund Number Subtotal Fund Number Subtotal Fund Number Subtotal Fund Number Subtotal Revenue $ 30,401.09 ._$ 14,,423.27 $ 15,977.82 Expenditure $ - - $ - $ Net To Date: T$ 30,401..09 $ 14,423.27 15,977.82 24 Lake Crook Restoration Full Current Year Prior Year Net To Date Revenue $ 21.43 $ lzio $ 9.33 Expenditure $ - $ - $ Net To Date: $ 21.43 $ 12.10 $ 9.33 25 Grant Fund Current Year Prior Year Net To Date Revenue $ 173,480.50 $ 206,452.31 $ (32,971.81) Expenditure 1 345,202.71 $ 195,815.77 $ 149,386.94 Net To Date: $ (171,722.21) $ 10,636.54 $ (182,358.75) 26 Criminal Justice Div Grant l Current Year Prior, Year Net To Date Revenue $ Expenditure $ Net To Date: $ $ 27 Water Contract Fundl Current Year Prior Year Net To Date Revenue 6,321.11 5,163.39 1,157.72 Net To Date: $ 6,321.11 5,163.39 $ 1,157,72 30 Community DO Block Gran Current Year Prior Year Net To Date Revenue $ 110,777.34 $ 772.40 $ 110,004.94 Expenditure $ 30,455.05 $ (30,455.05) Net To Date: $ 110,777.34 $ (29,682. : 65) $ 140,459.99 31 Home Buyers Asst 2009 Current Year Prior Year Net To Date Revenue $ - $ $1 Expenditure $ $ Net To Date: $ Fund Number 32 Owner Occ Rehab #100lo! Current Year Prior Year Net'To Date Revenue $ $ $ Expenditure $ $ $ Subtotal Net To Date: $ $ Fund Number 33 Municipal Court Tech Fee Current Year Prior Year Net To Date Revenue $ 3,009.54 $ 3,060.79 $ (51,25) Expenditure $ 11,550.85 $ 1,313.81 10,237.0,4 Subtotal Net To Date: $ (8,541.31) 1,746.98 $ (10,288.29) Fund Number 34 Municipal Court Security Ft Current Year Prior Year Net To Date, Revenue $ 2,421.42 2,384.11 $ 37.31 Expenditure i $ 1,8,30.18 1,995.63 Subtotal Net To Date: $ 591.24 $ 388.48 $ 202.76 Fund Number 35 Municipal Court child Safe Current Year Prior Year Net To Date Revenue $ 290.28 $ 291.77 $ (1.49), Expenditure $ - $ 4,626.00 $ (4,626.00) Subtotal Net To Date: $ 290.28 (4,334M) 4,624.51 Fund Number 36 Municipal Court Time Pay F Current Year Prior Year Net To Date Revenue $ 650.51 $ 519,98 $ 130.53 Expenditure 1,652.20 $ (1,652.20) Subtotal Net To Date: $ 65a.sY $ (1,132.22) $ 1,782.73 Fund Number 37 Police Conf Fds-Gambling Current Year Prior Year Net To Date Revenue $ 28.40 $ 16.04 12.36 Expenditure - $ - Subtotal Net To Date: $ 23A0 $ 16.04 $ 12.36 Fund NurnDer 38 Police Judicial Forfeitures Current Year Prior Year Net To Date Revenue 3,621.88 $ 13,424.14 $ (9,802,.26) Expenditure $ 1,287.35 $ 16,195.77 $ (14,908.42), Subtotal Met To Date: $ 2,334.53 $ (2,771.63) _ $ 5,106.16 Fund Number 39 Equitable Sharing Forfeltur Current Year Prior Year Net To Date Revenue 392.75 $ 511.63 $ (118.88 Expenditure 4,385.02 $ 40,803=2=3 Subtotal Net To Date: . ... ... (3,992.27) $ (40 291.60) �(36,418.,21) $ 36,299.33 Fund Number 40 UtY of Paris CO'93 Const F Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ Subtotal Net To Date: $ $ $ Fund Number 41 Tax & Rev CO 2000 Const F Current Year Prior Year Net To Date Revenue $ $ $ Expenditure 5 $ $ Subtotal Net To Date: $ $ $ Fund Number 42 CO Series 2002 Constructi( Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ Subtotal Net To Date; $ Fund Number 43 GO Bonds 2013 Constructh Current Year Prior Year Net To Date Revenue 62,320.23 S 39,348.03 $ 22,972.20 Expenditure $ 3,583,647.63 $ 2,386,043.07 -1,197,604.56 Subtotal Net To Date- $ (3,521,327.40) - $ (2,346,695 04) $ (1,174,632.36) Fund Number Subtotal Fund Number Subtotal Fund Number Subtotal Fund Number Subtotal Fund Number Subtotal Fund Number Subtotal 45 Land Fill Current Year Prior Year Net To Date Revenue $ 3721,586.41 $ 350.,384.73 $ 22,201.68 Expenditure —$ 312,076.9 - 9 $ 355,328.95 $ (43,25I.,96) Net To Date: $ 60,509.42 $ (4,944.22) 65,453.64 so Revenue Bonds Sinking Ful Current, Year Prior Year Net To Date Revenue = $ 121,040.17 $ - 114,493.41 $ 6,546.76 Expenditure $ - 5 Net To Date; $ 121,040.17 $ 114,493.41 $ 6,546.76 51 Tx&RevCOS 2013 (TWDB) I Current Year Prior Year Net To Date Revenue $ 60,564.52 $ 64,383.16 $ (3,818.64) Expenditure $ 9,773.25 $ 9,773.25 $ Net To Date: $ 50,791.27 $ 54,609,91 $ ............ 52 2012 GO Refunding Bond I Current Year Prior Year Net To Date Revenue $ -- $ $ Expenditure $ $ Net To Date: $ $ $ 53 Tax & Rev CO 2010 I&S Ful Current Year Prior Year Net To Date Revenue 176,238.84 $ 255,129.24 (78,890.40) Expenditure $ 176,858.13 $ 174.295.63 —2,562,50 Net To Date: $ (619.29) 80,833.61 (81,452.90) 54 City of Paris CO'93 I&S Fug Current Year Prior Year Net To Date Revenue Expenditure Net To Date: $ $ Fund Number 55 Tax & Rev CO 2000 I&S Ful Current Year Prior Year Net To Date Revenue $ $ Expenditure $ $ Subtotal Net To Date: $ Fund Number 5,6 Tax & Rev CO 2.002 I&S Full Current Year Prior Year Net To Date Revenue $ $ Expenditure $ - $ Subtotal Net To Date: $ $ $ Fund Number 57 Contractual Oblig I&S Func Current Year Prior Year Net To Date Expenditure $ $ Subtotal Net To Date: Fund Number 58 2003 GO Refunding Bonds Current Year Prior Year Net To Date Revenue $ $ Expenditure $ Subtotal Net To Date: $ Fund Number 59 2010 GO/W&S Refunding I Current Year, Prior Year Net To Date Revenue $ 618,798-93 $ 759,497.37 (140,698.44) Expenditure 467,862-50 $ 468,,612.50 (750,00) Subtotal Net To Date: $ 150,936.43 $ 290,884.87 $ (139,948A4) Fund Number 60 Refunding Bonds 2012 Current Year Prior Year Net To Date Revenue $, 332,682.01 $ 3,29,925.72 $ 2,756.29 Expenditure $ 387,,825.00 $ 381,37500 $ 6,4,50.00 Subtolaf Net To Date: $ (51,449.28) $ (3,693.71) Fund Number Subtotatl Fund Number Subtotal Fund Number Subtotal Fund Number Subtotal Fund Number Subtotal Fund Number Subtotal 61 Interlocal Coop Agreement Current Year, Prior Year Net To Date Revenue $ 81,285.36 80,,462.17 $ 823.19 Expenditure $ - $ Net To Date: $ 81,285.36 $ 80,462.17 823.19 62 G 0 Bonds 2013 I&S Fund Current! Year Prior Year Net To Date Revenue $ 602,217.88 $ 741,785.20 $ (139,567,32) Expenditure 1,473,987.50 $ 1,489,487.50 $ (15,500.00) Net To Date: (871,769.62) $ (747,702,30) $ (124,067.32) 63 CO Bonds - 2016 Current Year Prior Year Net To Date Revenue 341,767.7'5 $ 22,301.03 319,466,72 Expenditure 514,317,50 $ 514,317.50 Net To Date: $ . (172,549.75) $ 22,301-03 $ (194,850.78) 70 Employees insurance Fund Current Year Prior Year Net To Date Revenue $ Expenditure Met To Date: $ $ 71 Insurance Claims Fund Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ Net To Date: 72 Library Memorial Fund Current Year Prior Year Net To Date Revenue $ 697.24 $ 558.15 $ 139.09 Expenditure 142.43 413.12 $ (270.69) Net To Date: $ 554,81 145,03 409.,7'8 Fund Number Subtotal Fund Number Subtotal Fund Number Subtotal Fund Number Subtotal Fund Number Subtotal Fund Number Subtotal 7'3 3 A Love Trust Fund Current Year Prior Year Net To Date Revenue Expenditure Net To Date: $ $ 74 3 P Poteet Trust Fund Current Year Prior Year Net To Date Revenue $ Expenditure $ Net To Date: $ $ $ 75 Wilbor Deshong Trust Func Current Year Prior Year Net To Date Revenue $ $1 $ Expenditure T $ $ Net To Date: $ $1 $ 76 Gibbs Library Fund Current Year Prior Year Net To Date Revenue $ Expenditure $ Net To Date: $ $ $ 77' W B & Kathryn Vaughan, Mo Current Year Prior Year Net To Date Revenue $ $ Expenditure $ $ Net To Date: $ $ 78 Malone'N Love Memorial Fr Current Year Prior Year Net To Date Revenue $ $ Expenditure $ Net To Date: Fund Number 79 Library Expendable Fund Current Year Prior Year Net To Date Revenue 458.07 $ 257.03 201,04 Expenditure Subtotal Net To Date: $ 458.07 257.03: $ 201.04 Fund Number so Library Permanent Fund' Current Year Prior Year Net To Date Revenue 3.27 1.85 $ 1.42 Expenditure $ !Subtotal Net To Date: 3.27 $ 1.85 1.42