City of Lawrence, Kansas
Second Quarter Report – 2005
Purpose of Report
The following information summarizes the financial activities of the City of Lawrence for the first six months of 2005 and advises the City Commission as to current budgetary issues that may become a concern. In the first section, the budgetary highlights from the major funds of the City are itemized, including the General, Recreation, and Transportation Funds, which are partially funded by property taxes, and the Water & Sewer, Sanitation, Storm Water and Public Golf Course Funds, which are enterprise funds supported by user fees. The second section provides tables that compare year to date financial activities to the budget and prior year results for the same period. Included in the third section is a summary of the investment activities for the period. The fourth section summarizes the amount of outstanding debt. The final section provides information on capital project financing.
I. BUDGETARY HIGHLIGHTS
General Fund
● General Fund revenues are over 50% of budget and increased by $1.8 million or 7.1% compared to the same period last year.
● The $1.8 million increase in revenue was partially the result of a $735,000 rise in property taxes. The property tax increase was the result of a 6.5% growth in assessed valuation and a 1.0% decrease in the levy.
● Another component of the increase in General Fund revenue was a $330,000 rise in sales tax distributions. Year to date city and county sales tax distributions are $47,000 over projections.
● An additional significant increase in General Fund revenue was a $260,000 or 24.2% increase in court fines. Court costs were increased in September 2004.
● General Fund expenditures were less than 50% of budget but increased by 13.9% over the same period last year. As a reminder, over $600,000 of budgeted capital outlay expenditures were moved from the General Fund to the Equipment Reserve Fund in 2004. No department receiving funding from the General Fund has expended over 50% of their budget.
Special Revenue Funds
● Recreation Fund service charges were $13,000 more than the previous year. The increase is primarily the result of a $14,000 increase in indoor pool revenue compared to the previous year.
● Recreation Fund expenditures will increase during the summer recreation season. Annual Recreation Fund expenditures are typically less than 95% of budget.
● Public Transportation Fund expenditures were only 22.6% of budget. It is anticipated that fund’s expenditures will finish the year significantly below budget because the MV Transportation contract will be less than budgeted. The mill levy in the Transportation Fund was reduced by 0.4 mills, resulting in lower property taxes in 2005.
Enterprise Funds
● Water and Sewer Fund revenue increased 5.9% over the same period last year despite the wet spring. The increase was primarily the result of the 4% water rate increase and 9% sewer rate increase.
● Water and Sewer Fund expenses were up significantly from the prior year due to an increase in the transfer to cash finance capital projects. Operating expenses were less than 50% despite large encumbrances for chemicals and maintenance items.
● Golf Course Fund revenue was only 42% of budget due lower revenue from greens fees in June. As a result, revenue for the first half of 2005 was less than the same period in 2004.
● Golf Course Fund expenses were only 31% of budget. The decrease in expenditures compared to 2004 was due to the delay in 2005 interest expense until September and not filling a vacant position.
● The Golf Course Fund is projected to experience a loss in 2005 of approximately $130-140,000. Since the fund started the year with only $15,000 in cash some type of interfund transfer will be required prior to year end.
II. REVENUE – EXPENDITURE TABLES
Second Quarter Fund Analysis
|
|
|
20042nd Qtr. |
% of budget |
20052nd Qtr. |
% of budget |
|
General Fund |
|
|
|
|
|
|
|
Revenue Source |
|
|
|
|
|
|
Taxes |
$11,558,627 |
78.5 |
$12,293,425 |
76.8 |
|
|
Sales Tax |
9,944,139 |
55.6 |
10,274,188 |
51.4 |
|
|
Licenses & Permits |
503,024 |
78.6 |
448,386 |
58.2 |
|
|
Intergovernmental |
336,459 |
52.4 |
371,215 |
57.8 |
|
|
Service Charges |
168,082 |
45.3 |
291,710 |
75.9 |
|
|
Fines |
1,073,521 |
71.6 |
1,333,946 |
66.0 |
|
|
Interest |
147,376 |
29.5 |
275,889 |
69.0 |
|
|
Miscellaneous |
1,760,759 |
55.7 |
1,853,969 |
56.3 |
|
|
Transfers |
624,750 |
49.6 |
826,137 |
52.0 |
|
|
Total Revenue |
26,116,737 |
63.2 |
27,968,866 |
62.0 |
|
|
|
|
|
|
|
|
|
Expenditures |
|
|
|
|
|
|
General Government |
6,615,076 |
46.1 |
7,815,404 |
47.8 |
|
|
Public Safety |
9,283,654 |
42.4 |
9,963,529 |
42.9 |
|
|
Public Works |
2,223,483 |
51.2 |
2,913,431 |
45.1 |
|
|
Parks & Recreation |
1,151,784 |
43.3 |
1,267,115 |
43.4 |
|
|
Total Expenditures |
19,273,997 |
44.6 |
21,959,479 |
45.5 |
|
|
|
|
|
|
|
|
|
Revenues over Expenditures |
6,342,740 |
|
6,009,387 |
|
|
|
|
20042nd Qtr. |
% of budget |
20052ndQtr. |
% of budget |
Recreation Fund |
|
|
|
|
|
|
|
Revenue Source |
|
|
|
|
|
|
Taxes |
$290,906 |
78.5 |
$269,991 |
86.2 |
|
|
Service Charges |
712,575 |
52.8 |
793,927 |
58.4 |
|
|
Miscellaneous |
4,673 |
|
2,017 |
|
|
|
Transfers |
600,000 |
50.0 |
652,000 |
50.0 |
|
|
Total Revenue |
1,608,154 |
51.0 |
1,717,935 |
57.6 |
|
|
|
|
|
|
|
|
|
Expenditures |
|
|
|
|
|
|
Parks & Recreation |
1,168,580 |
37.7 |
1,263,893 |
39.1 |
|
|
|
|
|
|
|
|
|
Total Expenditures |
1,168,580 |
37.7 |
1,263,893 |
39.1 |
|
|
|
|
|
|
|
|
|
Revenues over Expenditures |
439,574 |
|
454,042 |
|
|
|
|
20042nd Qtr. |
% of budget |
20052nd Qtr. |
% of budget |
|
Transportation Fund |
|
|
|
|
|
|
|
Revenue Source |
|
|
|
|
|
|
Taxes |
$1,051,376 |
84.2 |
$900,515 |
82.9 |
|
|
Service Charges |
72,536 |
67.6 |
76,651 |
57.2 |
|
|
Miscellaneous |
2,080 |
0.0 |
0 |
0.0 |
|
|
Total Revenue |
1,125,992 |
83.8 |
977,166 |
80.1 |
|
|
|
|
|
|
|
|
|
Expenditures |
|
|
|
|
|
|
Public Transportation |
440,617 |
22.6 |
457,527
|
22.6 |
|
|
Total Expenditures |
440,617 |
22.6 |
457,527 |
22.6 |
|
|
|
|
|
|
|
|
|
Revenues over (under) Expenditures |
685,375 |
|
519,9639 |
|
|
2004 Enterprise Funds |
Water & Sewer |
|
Sanitation |
|
Storm |
|
Golf |
|
|
|
|
% |
|
% |
|
% |
|
% |
Revenue Sources |
|
|
|
|
|
|
|
|
|
Service Charges |
$10,497,862 |
52.4 |
$3,970,093 |
52.8 |
$1,305,776 |
54.4 |
473,220 |
39.9 |
|
Interest |
252,871 |
64.4 |
31,820 |
53.0 |
16,498 |
165.1 |
53 |
1.8 |
|
Intergovernmental |
0 |
|
0 |
|
0 |
|
0 |
|
|
Miscellaneous |
64,023 |
|
70,099 |
164.0 |
0 |
|
3,812 |
|
|
Total Revenues |
10,814,756 |
53.5 |
4,075,792 |
53.5 |
1,322,274 |
54.9 |
477,085 |
40.1 |
|
|
|
|
|
|
|
|
|
|
|
Expenses |
|
|
|
|
|
|
|
|
|
Operations |
11,148,395 |
34.9 |
3,833,241 |
42.4 |
750,039 |
29.6 |
467,708 |
39.3 |
|
|
|
|
|
|
|
|
|
|
|
Net Income |
(333,639) |
|
242,551 |
|
572,235 |
|
9,377 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2005 Enterprise Funds |
Water &Sewer |
|
Sanitation |
|
Storm |
|
Golf |
|
Revenue Sources |
|
|
|
|
|
|
|
|
|
Service Charges |
$11,116,897 |
52.3 |
$4,118,411 |
51.6 |
$1,324,173 |
51.9 |
$454,853 |
41.8 |
|
Interest |
177,340 |
59.1 |
18,739 |
31.2 |
18,659 |
90.0 |
0 |
|
|
Intergovernmental |
0 |
|
0 |
|
0 |
|
0 |
|
|
Miscellaneous |
86,627 |
173.3 |
80623 |
78.0 |
7,129 |
|
3,277 |
|
|
Total Revenues |
11,380,864 |
52.6 |
4,217,773 |
52.1 |
1,349,961 |
52.6 |
458,130 |
42.1 |
|
|
|
|
|
|
|
|
|
|
|
Expenses |
|
|
|
|
|
|
|
|
|
Operations |
15,132,632 |
43.9 |
4,339,807 |
43.8 |
1,214,967 |
31.9 |
359,433 |
30.7 |
|
|
|
|
|
|
|
|
|
|
|
Net Income |
(3,751,768) |
|
(122,034) |
|
134,994 |
|
98,697 |
|
|
|
|
|
|
|
|
|
|
|
III. INVESTMENTS
Short term investment rates have increased significantly in the last year. As a result, our interest earnings are greater than the first half of 2004. Interest revenue should meet or exceed the budget in 2005 for most funds.
As of June 30, 2005, the City of Lawrence had over $100 million in cash and investments. Approximately $86.5 million was invested in securities. Approximately 24% of our investments were in certificates of deposits, 54% in government agencies and 14% was in cash. The City’s investment policy limits the portfolio to a maximum of 30% in any one financial institution’s certificates of deposit. The City’s certificates of deposit are with Commerce Bank and Corner Bank. The average rate of return on our investments during the second quarter was 2.45%.
Over 90% of the City’s portfolio has an original maturity of less than twelve months. Only 3% of our securities had a maturity longer than twenty four months. The City plans on holding its investments to maturity and has sufficient cash and short-term investments to avoid a liquidity crisis that would force the sale of the longer-term investments.
IV. DEBT ISSUANCE
For the period of time covered in this report (first six months of 2005), the City had not yet issued new debt. The City closed on its most recent general obligation debt issuance on September 27, 2004. The issues included a $15,745,000 temporary note that matures on October 1, 2005. In addition, two general obligations bonds were sold, one totaling $10,600,000 for storm and street improvements (including W. 6th), and another for $1,600,000 for airport improvements. The City is planning the sale of $26.4 million in revenue bonds on July 26, 2005.
The following table shows the current total outstanding debt for the City and the different funding sources. A preliminary analysis has shown that the City can issue approximately $4.0 – 5.0 million in at-large general obligation annually without having an adverse impact on the debt levy.
|
City of Lawrence Estimated Debt 6/30/05 |
||||
|
|
GO Debt |
Enterprise |
Less Enterprise Portion of GO Debt |
Total |
|
Long term debt, 1/1/04 |
$ 74,885,000 |
$ 64,853,123 |
$(6,745,305) |
$ 132,992,818 |
|
|
|
|
|
|
|
Debt, added Summer 2005 |
0 |
- |
- |
0 |
|
|
|
|
|
|
|
Debt, added Fall 2005 |
0 |
0 |
(0) |
0 |
|
|
|
|
|
|
|
Debt, added, Kansas Water Supply Loan |
- |
0 |
- |
0 |
|
|
|
|
|
|
|
Less: Principal paid in 2005 |
(0) |
(1,189,704) |
0 |
(1,189,704) |
|
|
|
|
|
|
|
Total long term debt, 6/30/05 |
$ 74,885,000 |
$ 63,663,419 |
$ (6,744,083) |
$ 131,803,114 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Total long term debt is composed of: |
|
|
|
|
|
Enterprise fund portion |
$ 6,745,305 |
$ 56,918,114 |
$ - |
$ 63,663,419 |
|
Sales tax portion |
11,391,210 |
- |
- |
11,391,210 |
|
Benefit District Debt (estimated) |
11,430,297 |
- |
- |
11,430,297 |
|
Net long term debt, city at large, 6/30/05 |
45,318,188 |
6,745,305 |
(6,745,305) |
45,318,188 |
|
Total long term debt, 6/30/05 |
74,885,000 |
63,663,419 |
(6,745,305) |
131,803,114 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Future long term debt will result from: |
|
|
|
|
|
Notes currently outstanding which will be bonded (includes fall note issue) |
$15,745,000 |
$ - |
$ - |
$ 15,745,000 |
V. CAPITAL BUDGET
As of June 30, 2005 expenditures in the capital project fund totaled $25.7 million. Funding sources for these projects consisted of $15.7 million temporary notes, $900,000 in cash, and $9.1 million in general obligation bonds. The list does not include projects funded by the Water and Sewer Fund. The table indicates the need for an additional $4.8 million in financing.
Detailed information on the status of the projects is shown in the following table.
|
|
|
|
|
|
|
|
|
|
PROJECT NAME |
AMOUNT |
FINANCED |
OTHER |
TOTAL RECEIPTS |
EXPENDITURE |
ENCUMB |
AVAILABLE BALANCE |
|
2004 KLINK 6th st, Az to Ak |
350,000 |
325,134 |
199,500 |
524,634 |
524,214 |
278,122 |
-277,703 |
|
2005 KLINK 6th St. MO to Mass |
|
|
|
|
155,356 |
|
-155,356 |
|
W. 6th St., Wakarusa to SLT |
3,295,000 |
5,132,602 |
209,927 |
5,342,530 |
5,714,930 |
|
-372,400 |
|
Carnegie Library Renovation |
400,000 |
313,951 |
71,069 |
385,020 |
423,975 |
3,812 |
-42,766 |
|
KU Fire Station, 23rd & Iowa, STA 5 |
5,000,000 |
331,320 |
1,360 |
321,680 |
855,606 |
3,947,742 |
-4,461,642 |
|
Harvard Traffic Calming |
|
|
|
|
150,382 |
|
-150,382 |
|
Monterey Way, Stetson Dr |
4,850,000 |
2,120,375 |
|
2,120,375 |
527,632 |
250,151 |
1,342,587 |
|
2004 Fire Truck Purchase |
|
|
|
0 |
|
299,993 |
-299,993 |
|
2005 Overlay |
|
|
|
|
|
376,145 |
-346,175 |
|
O’Connell Road, 23rd - 31st |
2,300,000 |
628,067 |
117,267 |
745,354 |
579,887 |
50,837 |
114,629 |
|
Airport Runway Reconstruction |
|
|
1,305,792 |
1,305,792 |
1,237,155 |
55,754 |
12,89 |
|
Kasold, 15th to Clinton Parkway |
6,750,000 |
|
|
0 |
116,491 |
121,963 |
-238,454 |
|
3rd, Alabama to Illinois |
|
|
|
|
|
11,647 |
-11,647 |
|
2004 Overlay, Phase II |
473,781 |
696,078 |
|
696,078 |
347,867 |
|
348,211 |
|
2002 Traffic Signals |
200,000 |
202,734 |
|
202,734 |
140,455 |
33,408 |
26,870 |
|
Overland, Congressional to Queens |
1,500,000 |
995,000 |
|
995,000 |
995,589 |
|
-589 |
|
Congressional, North of 6th |
700,000 |
423,500 |
|
423,500 |
423,836 |
|
-336 |
|
6th & Lawrence Traffic Signal |
|
268,296 |
|
268,296 |
263,909 |
|
4,387 |
|
Lake Pointe, Clinton Parkway to 22nd |
1,166,250 |
|
147,664 |
147,664 |
453,886 |
436,131 |
-742352 |
|
Orchard’s Conservatory Easement |
280,000 |
281,000 |
151 |
281,151 |
281,654 |
|
-503 |
|
Monterey Way, Peter to GV |
2,620,000 |
169,000 |
|
169,000 |
244,313 |
|
-75,313 |
|
Wakarusa Service Center |
|
|
|
|
|
78,260 |
-78,260 |
|
23rd St Access Management |
550,000 |
|
|
0 |
20,999 |
128,599 |
-149,598 |
|
Peterson, Kasold to Monterey Way |
3,420,000 |
212,000 |
|
212,000 |
212,243 |
|
-243 |
|
Riverside Business Park Sewer |
900,000 |
374,651 |
|
374,651 |
292,994 |
|
81,657 |
|
Kasold & Peterson Rd Intersection |
300,000 |
24,000 |
|
24,000 |
17,608 |
6,450 |
-66 |
|
O’Connell Rd left turn lane |
|
|
|
|
|
20,745 |
-20,745 |
|
Kasold, Peterson to KTA |
770,000 |
|
|
0 |
108,783 |
97,677 |
-206,460 |
|
7th & Kentucky |
50,000 |
27,108 |
|
27,108 |
100,792 |
|
-73,684 |
|
Harvard Rd, East of GWW |
550,000 |
46,250 |
7,172 |
53,422 |
226,229 |
196,617 |
-374,425 |
|
Barker, 16th to 22nd |
550,000 |
557,678 |
|
557,678 |
499,479 |
|
58,198 |
|
George Williams Way, 6th to Harvard |
2,500,000 |
2,508,000 |
|
2,508,000 |
1,501,100 |
123,792 |
883,108 |
|
19th & Louisiana Traffic Signal |
315,000 |
67,822 |
|
67,822 |
|
37,108 |
30,714 |
|
Bob Billings & Wakarusa |
200,000 |
|
|
0 |
5,306 |
70,928 |
-76,234 |
|
Public Works Facility - Development |
300,000 |
302,416 |
|
302,416 |
131,562 |
|
170,854 |
|
Folks Rd, 6th to Harvard |
1,820,000 |
67,300 |
|
67,300 |
599,342 |
454,013 |
-986,055 |
|
Art Center Expansion |
|
|
53,650 |
53,650 |
|
6,850 |
46,800 |
|
Investments |
|
|
1,811,770 |
1,811,770 |
|
|
1,811,770 |
|
Misc. private projects |
|
|
133,698 |
133,698 |
119,929 |
|
13,768 |
|
900 New Hampshire TIF District |
8,650,000 |
8,747,408 |
5,251 |
8,752,659 |
8,258,889 |
621,218 |
-127,447 |
|
Fire Station #4 2121 Wakarusa |
150,000 |
|
15,000 |
15,000 |
67,258 |
50,647 |
-102,906 |
|
|
|
|
|
|
|
|
|
|
|
|
24,833,191 |
4,079,292 |
28,912,482 |
25,717,824 |
7,989,797 |
-4,795,139 |