Loading...
07 - SEPTEMBER 2015 FINANCIAL REPORTItem No. 7 memorandum TO: City Council John Godwin, City Manager FROM: Gene Anderson, Finance Director SUBJECT: SEPTEMBER 2015 FINANCIAL REPORT DATE: November 2, 2015 BACKGROUND: Section 69 (3) of the Paris City Charter requires the Finance Director to submit 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 September 2015 Financial Report Comments Net to Date Comparison of Revenues: 1. The operations and maintenance property tax and related collections are 3.65% more than this time last year. The current tax roll is 96.35% collected vs. 97.47% last year. 2. Sales taxes are up 18.83% over last year due to a one time state audit adjustment. The adjustment added an extra $872,390 to the General Fund and $174,478 to PEDC. Without the audit adjustment, sales taxes for the year would be up compared to last year by 5.16 %. 3. Hotel occupancy taxes are up 8.07% from last year. All hotels are up to date on their current period taxes. However, the audit conducted by MuniServices disclosed $22,567.56 in additional tax liability for three hotels. $9,089.13 of that liability has been paid and $13,478.43 remains due. A demand letter for payment has been sent to the relevant hotels. The hotel that owes the bulk of the tax liability found by the auditors has requested the auditors review additional data that they will provide. That review will be done in January 2016. 4. Franchise fees are down 1.34% with Oncor being lower than the previous year. 5. Permit fees are up 102.57% compared to last year with the issuance of permits for Paris Lakes. 6. Municipal Court fines are 14.13% below last year's collections. 7. Leases & Interest cash flows vary from year to year primarily due to investment maturity dates making it difficult to compare the current and previous year. 8. The Streets & Highways increase was a bookkeeping entry to add some old street assessments to the general ledger. 9. EMS fees are up 11.91 %. 10. General Fund miscellaneous fees /revenues are unpredictable in nature and amount but do occur each year. Variances from one year to the next are not unusual. The bulk of this year's increase comes from reimbursement of ice storm expenses. 11. Water & Sewer Transfers are not down but in the current year they have been netted against a transfer to another fund. 12. Recreation fees are down 7.18 %. 13. Total General Fund revenues are 9.45% above last year. This increase is primarily due to increases in sales tax (including the state audit adjustment discussed above), current taxes, ice storm reimbursements, and EMS fees. Year to date receipts are 107.52% of the budget with the City being 100.00% through the budget year. 14. Total General Fund expenditures are down 2.05% compared to last year. General Fund expenditures to date equal 97.50% of budget with the City being 100.00% through the budget year. 15. Sewer revenue is up 3.30% compared to last year. 16. Water revenue is up 1.45% compared to last year. 17. Total Water & Sewer revenues are 2.40% above last year and equal s 100.35% of budget which is above the 100.00% budget to date percentage. 18. Total Water & Sewer expenses are 0.67% below last year at year end and represent 95.91% of the total budget while the City is 100.00% through the budget year. Departmental Expenditure Summary: At this point the City is twelve months or 100.00% through the budget year. Within the General and Water & Sewer Funds there are four departments whose expenditures are over 100.00% for the year. 1. City Attorney - 100.26%. This overage was due to reducing the City Attorney's budget at year end to help cover expenditures in other departments. This was not the fault of the City Attorney. 2. Parks /Rec /ROW - 100.23%. This overage was due to reducing the Parks' budget at year end to help cover expenditures in other departments. This was not the fault of the Parks Department. 3. Water Production - 101.09%. This overage amounted to $28,705 and was due to work on the filter beds. 4. Lift Stations - 102.14 %. This overage amounts to $8,986 and is due to electrical and maintenance costs. Year to Date Comparison Sept. 2015 Current Year Previous Year Net to Date General Fund Taxes Collected 6,132,317.67 5,916,157.42 216,160.25 Sales Tax 7,584,997.11 6,382,749.03 1,202,248.08 Hotel -Motel Tax 591,571.07 547,354.07 44,217.00 Franchise Fees 3,291,571.00 3,336,520.33 (44,949.33) Permits 220,695.77 108,943.05 111,752.72 Court Fines 312,263.95 363,660.06 (51,396.11) Leases & Interest 130,832.41 208,992.21 (78,159.80) Fees & Copies 9,942.60 9,414.44 528.16 Streets & Highways 26,472.83 0.00 26,472.83 Sanitation Fees 1,463,140.30 1,462,584.42 555.88 EMS Fees 2,391,816.17 2,137,188.19 254,627.98 Mixed Beverage Tax 54,323.14 53,828.98 494.16 Miscellaneous Fees 621,602.54 202,477.59 419,124.95 Water & Sewer Transfer 844,722.78 874,999.92 (30,277.14) Recreation Programs 156,747.27 168,873.85 (12,126.58) General Fund Total Revenues 23,833,016.61 21,773,743.56 2,059,273.05 General Fund Total Expenditures 21,610,476.97 22,063,807.29 (453,330.32) Net to Date 2,222,539.64 (290,063.73) 2,512,603.37 Water & Sewer Fund Sewer 5,608,129.82 5,428,782.95 179,346.87 Water 8,146,928.15 8,030,430.93 116,497.22 Interest Earned 39,237.49 23,685.91 15,551.58 Miscellaneous 441,377.82 418,099.97 23,277.85 W &S Fund Total Revenues 14,235,673.28 13,900,999.76 334,673.52 W &S Fund Total Expenditures 13,595,905.93 13,864,134.85 (93,989.46) Net to Date 639,767.35 36,864.91 602,902.44 Comparison Report Page 1 11/9/2015 E E CL 7 lA N 3 Y_ d x x W Ln r-I O N 0J 00 d H 7 Cl- x lD m V LD Ln O M m m Ln C M Ln N m N �' m n M r rl Ct n .-i rl O to N lD n r2 ri to 'V' 00 M ci m t\ -i lD m N Ln lD m n 00 M N O M ri V W m rI:t m M r-, OO r LD l0 O (V M W V V CM m C N ri Ol u o0 a ri o0 Ln DO m-zT M N M O M m n O m I'D 'T O N O r, O 1-1 u C m N m to N Ln r" m m o0 V oO M rti Ili O Ln o0 u1 ri LD `l C M O y; M N N r, V ri o0 m O0 O m <o lD m Ln ri M m ri ri o0 r, .1 Ln V lD rti W O f0 r'I ri o0 rl -1 ri C LD — r-1 Ln M N r-i ri N O Ln m m Ln ri N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O O o O O O O O O o 0 0 0 0 0 0 0 0 0 0 0 0 0 o p O o 0 0 O M m ul a at Ln N m T r-L V Ln n o N m O O-q lD r\ O LD m W C w M 00 Ln N�r m O .-1 o Ln m t m-zt O O M V1 Ln M n m to LD m r 4/ rp DD o0 r-I N Ln m m lD n N o0 lD m ul M O V Ili r o M m O m Vi n N lD O V m 00 00 M m m N lD Ln Ln W m r� c-I Ln m M O m O ri LD Ln 7 Y 7 m LD lD O Ln N .-i m 00 ri m c-I m c-1 N o N m o0 r\ O O-;T O u m M M N j, m N r C .-i ri m LD Ln m M c-1 LD Ln In r-1 N 00 N a+ r, W Ln N V1 r, '7 N ri c-I m m lD a-I m ul 00 m 00 m m n 'T ry C O m lD Ln O lD M M N LD lD m m m N Ln lz� ri 00 oO m n C m r, oo V m uD o0 0o Ln oo co of r Ln O o r- O Lri oo n d' �Y of V } aj Q o m m m m m m m m m m m m m o m m rl m m m m m m m m a x W lD r, lD a m o r� -+ n m lD r, o oo m oo lD Ln m r, m m LD m m m lO rl M N N m ct Ln c-1 LD W o N W lD V r,� C M O Ln N Ln ri lD n O m n O Ln V n n m O M Ln r O W ri o LD ri m ci r\ O ri O LO C i m N m't 00 � O <o LD M Ln M V ri m M M N co 00 � O Ln m Ln lO v ro 3 00 m M W LD m W n N O N M r- O .-i d' m N ci n o0 00 LD 00 N r" m N m rti O Ln V co m <D O Ln Ln m O M N'T ri -zzr m M r� O 3 Y u m V1 Vl O c-1 m LD Ln m CO n ri Ct Ln W o lD r, N LD l0 LD m n V o u Q M M N r-I M N r-I M j N ri m V1 V1 M N lD Ln O O -IT rl LIl C ri N N rH N N N N N M Ln 00 N -1 O N w n o n M n m m N V C O m n O o O m 00 00 O ri m n LD M n LD O t m O 4: LD u7 LD O o0 Ln D1 N n M W a+ co m Ln Ln ri c-I W Ln O M n m Ln LD In r� N O m V LD m n rl n C L m m LD co N o0 LD N n o0 m m M c-I m m o co .-i o o Ln �-Z4" tv Ln v m LD CD M N N ll Ln 00 n N l ll m n O m LD o0 ci r� ll C Lr N N ri o0 Ln <0 co n lD V C Ln N ri N r♦ N O o oo -q m n Ln n N lD O CO a ri N M 1-1 N r-I m n M "7 TT LD Ln Ln N m Zzr o0 O rl O u G � m ri c-I lD ri N r-1 ri Ln 14 00 m LD n r-1 rl r-I CF M N N LD ri ul m Ln O LD m co �t m ri o0 00 N O o lO h r1 C LD ri LD rl ri '7 00 V Ln Ln ri W M O 'C N p O o0 n ul N y m LD rO m N In ri Ct o0 N TT m Ln N O In O V m Ln Ct M ' W W M h LD W M m m Ct ID LD W ID r N n ri M ri m M Ln 00 rn r-i O Lr� O ll r pQ C lD C' 00 t` n M O O lD N O � Ln Ln ul N m V 00 N M N N p to r t` N fl- m ' t v Ln N m LD M m a--1 m N ri .--1 O rl M o0 r% Ln M N oo Ln R lD N M Ln ri N Ln o N Ln Ln m m c ri O O o o 0 o o 0 o 0 0 0 0 0 0 o 0 0 0 o 0 0 0 0 0 0 0 o o 0 0 0 0 o o o. 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 a+ O m 00 '7 C 11 m c-1 Ln O Ct ri N Ln lD LD o o O m r, 11 ri n m LD C y m M m O V O W Ln � N n 'ct u1 M N LD � O Ln m m W O V ri n a! N w W V LD V W m C Ln Vi m m n ri n N N N Lr1 Olzl 00 V m ri Ol 41 M co .4 O 00 Ln N m oo co N o0 00 Ln r, N N O LD ri Ln LD LD oo LD Y n LD N ri M ri m ri r, N m co LO ri � ri Ln ri N n m LD O ri N V u m m M N a-1 V r� Ln M L.n ri O m -;j Ln m a' H LD LD ri r-i N <D r Ln TT r-1 r♦ N r♦ N N N c-I N Ln r� LD o c-1 r M M ri o0 lD M to n n Lr1 oo O n LD O O LD m H a 'cu ri n N M m r ri W Ct m N f� M W n O Ln lD t\ V1 Li r0 v C m o0 O n r, r r LD n Ln Ln O LD ID m LD n LD 00 00 m N l0 N ri .--1 } m m O m m m m m m m m O m m m m m m m m m 01 m m O m Q IH ri a x W N N l0 M m M m lD r� 00 W LD m ul N Ln O Tt c-I N lD f\ m N W lb m N V W Ln M 00 M N o0 Ln OR Ln V C W N lD m Ln r O1 m r-1 n C O N N LD m H LO m m W m m m o N O Ln r m M ID LD H ri m N C �p m LD LD O O Ln o 00 N n-zt H m m m o zt to Ln 00 N n O N m v rp N m ul LD ri Ln C `3 00 lD m N LO c-I V m t\ lc c-I l0 V M [t Ln N N y V 00 m 00 00 m m m m r, m Ln LD n V LD m W m CO V O m m r, ri Y Q U n Ln M N M o N N H o V N LD <D M LD m O Ln co c--1 co O m m LD M V Ln 0 M r, M o H ri LD LO N lD N LD O Ln O Ln LO m Lr Vl Tt r-1 ri N N ri N N N N m m N n N N m lD n r LD H m-q n 00 O LD m m ri m co m O m Lb r1 V C ri o N rV 0 ul Ln ri m a V Ct O c-I lD M o0 ri LD V7 n ul to � o LD m 00 N ri M m M -1 00 M M ri O m H ri O m m M m 1-1 cc c-1 N M M co N co r, co o ri 1-1 m lD Ln Ln LD LD C O M o0 C Y V Vl m M o0 ri Vi rl, ll r-1 Ln V1 00 W O m m Lr1 O ri N m .-1 W W 0 u LD LO Co H n r Ln 00 M M O M al r, Ln lD O Ln r m 01 M m m ri Q N N .--1 N LD N lD N r-I m ';T LD V c-I N Ln O1 LD Ln o0 u m N N N r M N N N D u C C C i 7 u N OO LL E cL O 'O O C,6 Ln T L b0 u C u C C •U Q Q N 0 O �O L .0 ccN O C N U @ 7 T O 0� Ln 0O L G A 0O 7 "- O - O H C r0 - (V Y C C v C O co u W 7 - 3 cccCO O O- N C N O1 .�, N o2S O v ra m O m a` U G Q V U 7 N C3C C •00 .V Vi y v •U v LL i QJ uu ._ d L C v i 4 06 r0 ro U U U U Q a W U w a a Ln Ln H to 0 W U a -I N ID Ln r-I O N 0J 00 d H 7 Cl- x 1 m cE C 3 N N L 3 Y 'v c v x W `~ Ln oo m Ln O ci lD M Ol N c N O N t\ In M 19 ri ri O m N v 3 m Ln -+ m i 'i Ln co ED N N N 0 0 0 0 0 O O O O O a+ y c fL Ln It m lD O m O fl- In N pp 2 N N c r- t\ , '6 in M co co Ql 3cl } 3 V N c-I m N u m N V Co O r rIj m v .-f v m c Ln -zt N Ln co } N CL M x w N -1 lD In OR m lD rn W Y lD w m o v c m m w m + m v 3 0 oo L' N t N N N U O O m 0 W N O lD ul 0 m N In N O r1 Y _ O m N o V c L ra m oo m N i Y N cl t` z r- V � Q rn-i ON � OVi M N O o O N y O C O O M w U In 00 O N }.i C w C 'O N O lD W cl o0 L!7 rl 01 cu n � co co N M 0 0 0 0 0 0 0 0 0 0 a.+ y. O 00 tD N 01 c m y m lD r� N N ry Ilc a' N 1-i N r O OJ "O } 3 N lD Ol W ll1 7 U m r- O O --I N W r\ 'i N m V rf y. N oo 1-1 c 01 n .-i Dl 01 fc 41 c oo lD N m In N i v ? W M r� Ql O r M M a x w Ln O 1 O M In C c-I t!1 01 .. of m r.i .--I ui C is r- N O n O N 3 M l.rl N N cl r, c0 c0 In 3 } u C M N n c1 U o0 O :t oo to Ni m m 'i o O L H N m O O L1 Y M Ol O N O u V ^� Q N w M w m T co N c-I rl ri +� c C c 3 fU v u 'LL�yt W !Z C c v 3 O c v o Fu O o ~ ai m � 3 � > w v N > J Lr, 0 N c) ri N N cA ri v N CL w