The URL can be used to link to this page

Home My WebLink AboutPreliminary (Binder Notes) Operating Budget FY03-04C1ty COunCll StrateglC D1reCt1On Work Session Saturday, May 9, 2003 Meeting Notes Beliefs * Recognize current excellence, but don't rest on our laurels - always strive for improvement * Equal access to opportunity * Effective planning * Visionary leadership * Open &honest communications with citizens and staff * All people are equal -citizens and staff * People are good -will do the right thing * Fiscally responsible * internally/staff * externally/citizens * Integrity * Ethical Standards * Honesty * Take care of basics: streets, water/sewer, public safety * Doing the right thing * legal � ethical * moral �k Provide clean, safe and aesthetically -pleasing work environment for employees Strengths * Low crime rate * Two school districts * HEB * GCISD * Stable work force * dedicated staff * police & fire �k Balanced budget �k- Park system * Parks at Texas Star * Golf course * Stable leadership in Council �k Arbor Daze �k Location �k Special Events * parade concerts * sports k Communication * internal * external �k Volunteer base * Euless * other cities * youth �k Code upgrades * Willingness to cooperate with other entities �k Transportation access * Image �k Citizen support Citizens Fire Academy Citizens Police Academy * Citizens on Patrol Neighborhood Watch Opportunities * Location * Lack of cooperation from other entities * Transportation � crowded freeway system ,t lack of public transportation * Drainage issues * Economic development Strategic Directions * Improving Transportation address improved traffic flow • Main St. •FM157 • Piine/Rai pelder • Hwy. 10 • SH 183 * mass transit • Trinity Railway Express • DFW Airport * Improving Drainage * Hurricane Creek * Little Bear * Boyd Branch * Tributary WFA * Economic Development * incentives to offset land costs � Continue building positive image of Euless * Arbor Daze * Texas Star Sports Centre * special events * road improvements •FM157 • Hwy. 10 • Harwood Rd. • Main St. • Mid -Cities Blvd. more stringent building codes * Improve marketing between Euless & HEB ISD * facts to promote ISD programs • international baccalaureate program • Spanish immersion program • Suzuki music program * improve perception * Increase training opportunities for employees * continuing education * certifications �k Increase opportunities for youth activities • neighborhood parks • afterschool programs with school districts • improve relationship with school districts * Continue to improve citizen communications * increase direct communications * increase cable programming * launch new web site * calendar of events in water bills � Maintain stable tax rate while maintaining services * .emphasize sales tax revenue instead of ad valorem while increasing surplus ratios � Promote employee incentive program * cost -savings incentives OBJECTIVES FY 2003 = 2004 CITYMANAGER'S OFFICE 1. COMMUNICATION: ♦ Stress open communications with the City Council, Citizens and Staff to maximize results. ♦ Continue Status Reports, voice mail updates, financial updates, code updates, pre -council discussions. ♦ Improve Staff reports in pre -council to provide concise and timely information. ♦ Provide City Council with briefing material prior to update to allow their review prior to a decision. 2. ECONOMIC DEVELOPMENT: ♦ Provide monthly report on activities and development opportunities. ♦ Complete Buxton Report follow up by making personal contact with all prospects provided. ♦ Achieve tax base and sales tax increase due to growth and expansion. ♦ Develop an incentive plan that will encourage occupancy of the vacant K- Mart, Sutherland, Food Lion, and Furrs buildings. ♦ Complete the franchise negotiations with TXU to provide a dependable electric provider for Euless, while finalizing a ROW agreement that holds the provider responsible for construction costs and completion schedules. 3. CONSTRUCTIONPROGRAM: ♦ Complete the Main Street project on budget and on schedule in FY 2004. ♦ Complete Glade Road ROW acquisition and utility relocation to allow for FY 2005 construction to begin. Objectives FY 2003 - 2004 City Manager's Office Page 2 CONSTRUCTIONPROGRAM- continued: ♦ Complete ROW acquisition, utility relocations and a Bedford participation agreement to allow for 4th Quarter 2005 construction to begin on Pipeline Road. ♦ Finalize a contract with Fort Worth on effluent service to the Parks at Texas Star/Golf Course/Softball World to accomplish a FY 2005 construction project. ♦ Design and begin construction on the Preserve at McCormick Park. ♦ Complete property acquisition and begin construction of Station 3. ♦ Construct Phase III at the Parks at Texas Star to allow for a spring 2005 opening. 4. TEXAS STAR SPORTS CENTRE: ♦ Achieve revenue growth while managing expenses to allow for a net profit during 2004 on the golf course operation. ♦ Begin capital improvement program on the golf course club house to address carpet change out and general furniture and kitchen improvements. ♦ Continue capital improvements at Softball World that address lighting and parking improvements. ♦ Implement out -sourcing of the Softball World pro shop to allow for improved profitability and managerial control. 5. GENERAL: ♦ Realize revenue growth to avoid a Tax Rate increase for the 2005 Budget. ♦ Implement medical and Rx plan changes to minimize cost increases for 2005 ♦ Improve citizen communication with Neighborhood Associations by completing one meeting with each association during 2004. Objectives FY 2003 - 2004 City Manager's Office Page 3 GENERAL - continued: ♦ Investigate the use of Public Improvement Districts (PID) for new/existing developments to assure improved maintenance of common areas and infrastructure. ♦ Fulfill the amortization project by realizing the demolition of the Dickey Apartments. Short - Term Motor Vehicle Tax Fund Five Year Financial Plan Base Year Year 2 Year 3 Year 4 Year 5 Budget Projected Projected Projected Projected 2003=04 2004=05 2005=06 2006=07 2007=08 BEGINNING BALANCE 31707,939 3139%357 11926,617 3,325,071 41400,525 REVENUES Motor Vehicle Tax 91400,000 91400,000 101000,000 10,000,000 10,000,000 Interest Income 200,000 200,000 225,000 250,000 250,000 Transfer from Half -Cent 30,573 30,573 30,573 30,573 30,573 Transfer from Golf Course 30,689 211,547 211,547 211,547 211,547 Total Revenues 91661,262 91842,120 10,467,120 10,492,120 10,492,120 EXPENDITURES DFW Rebate Transfer to Equip Replacement (61266,666) (327,700) (6,266,666) (237,500):2) (61666,666) (3021000)A (61666,666) 0 (61666,666) (105,000) 1 Transfer to Debt Service 4 (204,958) 0 0 0 0 Transfer to General Fund (730,020) (11400,000) 11400,000 11400,000) (11400,000) Total Expenditures (71529,344) (79904,166) 81368,666 8,066,666) (81171,666) Recommended Reserves per Policy (21000,000) (21000,000) (21000,000) (21000,000) (21000,000) Available for Supplemental 21131,918 11937,954 21098,454 21425,454 21320,454 Additional Available for Capital 1,707,939 11399,357 73,383 11325,071 21400,525 Total Available for Capital 31839,857 31337,311 21025,071 31750,525 41720,979 Proposed Capital, Parks @ Texas Star III (200,000) Golf Course Loan (250,000) Parking - Midway (11,000) Parking - South Euless (55,000) Parking - Simmons Center (49,500) Harwood Road/FM 157 to N. Main (129,000) Drainage CIP (625,000) (200,000) (850,000) (800,000) Parking - Villages Bear Creek (150;000) Preserve at McCormick Park (125,000) Fire. Station #3 Reconstruction (11600,000) I Building B Renovation (943,d94) Parks @ Texas Star IV (1,500,000) Public Works Facility (11713,000) Pool Renovations 500,000 500,000 11000,000 Proposed Capital 21440,500 31410,694 700,000) 1,350,000 3130%000 Remaining Funds Available 11399,357 (73,383) 11325,071 21400,525 11420,979 ENDING FUND BALANCE 3139%357 1,926,617 31325,071 41400,525 31420,979 0 �I.Se �.00dea. �' 10 2e�a � �utihPeK Tu�u � �3'l,soo N , N1 / i)011 i i) ij(� ?ummulctcd lit �t-umfrlv - 6/'- l,la�,9�o b(D/, Af/S �87$1 g5t; / �$ al 5(03 <;2b,o� 1�a,5�3 GJ/S 57 / a /a 40oi JCo �, G v� _ �rw NQg C s� �73,9�0 000> 1 , &73 o - - ----- ------ ---- - - ----- - - -- ---- c,ii2GvN,N 47 �►�� lSe lc7. 1. �tJCfQctSe nR_rej)OU -+i0n5_ - - - --- — -- - 3 !arc - - Capital Requests-FY2004 (By Fund) Department Fund Division Program Description Prog. Prog. CMO Type Cost Rank Non -Departmental Car Rental Non -Departmental Transfer to CIP - Parking Improvements, Midway Capital N/A 240-9060-590-9330 $11,000 1 Non -Departmental Car Rental Non -Departmental Transfer to CIP - Parking Improvements, S. Euless Park Capital N/A 240-9060-590-9330 $555000 1- Non-Departmental Car Rental Non -Departmental Transfer to CIP - Parking Improvements, Simmons Cntr Capital N/A 240-9060-590-9330 $499500 1 Non -Departmental Car Rental Non -Departmental Transfer to CIP - Parking Improvements, Bear Creek Capital N/A 240-9060-590-9330 $150,000 1 Non -Departmental Car Rental Non -Departmental Transfer to CIP - Preserve at McCormick Park Capital N/A 240-9060-590-9330 $125,000 1 Non -Departmental Car Rental Non -Departmental Transfer to CIP - Fire Station #3 Construction Capital N/A 240-9060-590-9330 $1,6009000 1 Non -Departmental Car Rental Non -Departmental Transfer to Golf for Cart Fleet Replacement (Loan) Capital N/A 240-9060-590-9540 $2219200 1 Non -Departmental Car Rental Non -Departmental Transfer to Golf Carpet Replacement (Loan) Capital N/A 240-9060-590-9540 $289800 1 Police CCPD Patrol Ballistic Vest Capital PD0401 220-3045-521-7499 $10,400 1 Police CCPD Service Radio Console Upgrade Capital PD0402 220-3045-521-7499 $129232 1 Police CCPD Patrol GPRS Wireless Modems Capital PD0403 220-3045-521-7499 $229780 1 Police CCPD CID Crime Scene Vehicle Capital PD0404 220-3045-521-7499 $47,796 1 Police CCPD Detention Part-time PSO Officers Capital N/A 220-3045-521 -1 102 $50,000 1 Police DEA Admin. Two CID Vehicles Capital PD0405 230-3045-521-7420 $42,900 1 Non -Departmental Drainage Non -Departmental Transfer to CIP -Channel Stabilization Capital N/A 510-8029-531-9511 $399,000 1 Non -Departmental Drainage Non -Departmental ITransfer to CIP - Drainage Project Study Capital N/A 510-8029-531-9511 1 $609000 1 Community Serv. General Fund Parks Irrigation Program ($30,000) Capital PR0401 101-9060-590-7499 $25,000 1 Facility Maint. General Fund Facility Maint. Energy Conservation Measures -2nd year Capital FM0401 101-9060-590-7309 $12,500 1 Facility Maint, General Fund Facility Maint, HVAC Partial Replacement #3 - City wide Capital FM0402 101-9060-590-7309 $209000 1 Facility Maint, General Fund Facility Maint, Window Replacement Program Capital FM0403 101-9060-590-7309 $10,000 1 Facility Maint, General Fund Facility Maint. Campus Lighting Upgrade Capital FM0404 101-9060-590-7309 $12,000 1 Facility Maint. General Fund Facility Maint, Fire Station #1 Interior/Exterior Painting Capital FM0405 101-9060-590-7309 $129500 1 Facility Maint, General Fund Facility Maint. Building C-Telephone System Capital FM0406 101-9060-590-7309 1 $1294501 1 Facility Maint, General Fund Facility Maint, Simmons Center - Repaint and Carpet Capital FM0407 101-9060-590-7309 $109000 1 Facility Maint. General Fund Facility Maint. lAnimal Shelter Renovations Capital FM0408 101-9060-590-7309 $20,0001 1 Finance/Admin General Fund Finance Copier Capital FI0401 101-9060-590-7499 $129000 1 Fire General Fund Emer Mgmt Emergency Mgmt Intern Program Capital N/A 1014024-522-1102 $2,000 1 Fire General Fund EMS/Suppression Lifepak 12 Defibrillator/Monitor Capital FD0401 101-9060-590-7499 $23,350 1 Fire General Fund EMS/Suppression Automatic External Defibrillators (5) Capital FD0402 101-9060-590-7499 $117000 1 Fire General Fund EMS/Suppression AudioNisual Equipment for Training Room Capital FD0403 101-9060-590-7499 $5,800 1 Fire General Fund Fire Marshall 2003 International Building Code Books Capital FD0404 101-9060-590-7499 $1,842 1 Capital Requests-FY2004 (By Fund) Department Fund Division Program Description Prog. Prog. CMO Type Cost Rank Information Serv. General Fund Finance On -Line Bill pay for Water and Courts Capital ISO401 101-9060-5904404 $19,000 1 Information Serv, General Fund Fire Sierra Wireless Modems for Fire Department (9) Capital ISO402 101-9060-590-7404 $3,591 1 Information Serv, General Fund Information Serv, Software Assurance for Microsoft Server Software Capital ISO402 101-9060-590-7404 $32,000 1 Information Serv, General Fund Information Serv. Council Laptops Capital ISO402 101-9060-590-7404 $26,100 1 Information Serv, General Fund Information Serv, Miscellaneous Software Capital ISO402 101-9060-590-7404 $13,000 1 Information Serv. General Fund Information Serv. Replacement of (5) Servers Capital ISO402 101-9060-590-7404 $335500 1 Information Serv. General Fund Information Serv. Replace (6) Network Printers Capital ISO402 101-9060-590-7404 $12,000 1 Information Serv. General Fund Information Serv. Replacement Laptops Capital ISO402 101-9060-590-7404 $36,300 1 Information Serv. General Fund Information Serv, Replacement Desktop Printers Capital ISO402 101-9060-590-7404 $3,150 1 Information Serv, General Fund Police HP Switch for Police/Courts Building Capital ISO402 101-9060-590-7404 $47500 1 Non -Departmental General Fund Non -Departmental Street Overlay Capital PW0401 101-9060-590-7499 $300,000 1 Non -Departmental General Fund Non -Departmental Annual Sidewalk Program Capital PW0402 101-9060-590-7499 $100,000 1 Non -Departmental General Fund Non -Departmental Retiree Adjustment Capital N/A 101-9060-590-2998 $20,000 1 Non -Departmental General Fund Non -Departmental Consulting -Information Services Capital ISO403 101-9060-590-7499 $25,000 1 Non -Departmental General Fund Non -Departmental Transfer to Insurance Capital N/A 101-9060-590-9610 $1509000 1 Non -Departmental General Fund Non -Departmental JTransfer to Risk Management Capital N/A I 101-9060-590-9615 1 $5030001 1 Planning/Dev General Fund Inspections 2003 International Building Code Books Capital DV0401 101-9060-590-7499 $2,500 1 Police General Fund Detention Floor Cleaning Machine Capital PD0406 101-9060-590-7499 $4,800 1 Police General Fund Patrol Refurbish Armory Equipment Capital PD0407 101-9060-590-7499 1 $15,9941 1 Police General Fund Patrol (10) Additional Autocites for Patrol Officers Capital PD0408 101-9060-590-7499 $56s9751 1 Golf Course Golf Course Golf Course Golf Course Cart/Driving Range Maintenance Golf Cart Fleet Replacement (Loan from Car Rental) 1#16 Water Feature Restoration Capital Capital GC0401 GC0402 540-7060-550-7499 540-7060-550-7499 $221,2001 $112000 1 1 I_T�I Library Half Cent Library Copier for Public Use ($8,100) (GF) Capital LB0401 210-1054- - 499 $5,600 1 Library Half Cent Library Library Materials Capital I LB0402 210-1054-5 -7499 $75,000 1 n c �n Facility Maint. Facility Maint, Half Cent Half Cent Facility Maint. Facility Maint, Library Ceiling Treatments and Diffuser Upgrades (GF) ILibrary Enhanced Drainage Projects (GF) Capital Capital FM0409 I FM0410 210-1054-5A0=7499 210-1054-540-7499 $32,500 $24,000 1 1 Community Serv. Half Cent Parks Irrigation Program Capital PR0402 21 0-1 052-550-7499 $509000 1 Community Serv, Half Cent Parks Wood Light Pole Replacement (GF) Capital PR0403 210-1052-550-7499 $64,528 1 Community Serv, Half Cent Parks Field Lighting Replacement (Athletic Complex) Capital PR0404 210-1052-550-7499 $6,500 1 Community Serv, Half Cent Parks Transfer to Half Cent CIP for Splash Pool Capital N/A 210-1031-513-9310 $1259000 1 Community Serv, Hotel/Motel Admin Historical Preservation Capital N/A 201-7080-550-5012 $109000 1 Community Serv. Hotel/Motel Admin Arbor Daze Sponsorship Capital N/A 201-7080-550-5002 $30,000 1 Community Serv. Hotel/Motel Admin JGames of Texas of Sponsorship Capital N/A 201-7080-550-5002 $5,000 1 Capital Requests-FY2004 (By Fund) Department Fund Division Program Description Prog. Prog. CMO Type Cost Rank Community Serv. Recreation Fund Recreation jPartJime Rec Center Staff (GF) Capital I N/A I 520-7055-550-1102 1$24,0001 1 Community Serv, Recreation Fund Recreation lWebmTrac Internet Software Capital 1 PR0405 I 520-7055-550-7499 1 $2791801 1 Community Serv, I Softball World I Parks I Update/Replacement of Light Pole -Phase I Capital PR0406 530-7050-550-7499 $150,000 1 Public Works Water & Sewer 1 Wastewater lSewerCoameraand Transporter Capital PW0403 501-9060-590-7499 $48,500 1 Information Serv. Water & Sewer 1 Information Serv, Replacement PC (45) Capital ISO404 501-9060-590-7404 $66,900 1 Information Serv. Water & Sewer I Information Serv. Update Planametric Data Software ($92,000) 1 Capital ISO404 501-9060-590-7404 1 $50,0001 1 Non -Departmental Water & Sewer Non -Departmental Well Repair Capital N/A 501-9060-590-9502 $50,000 1 Non -Departmental Water & Sewer Non -Departmental CDBG Program Capital N/A 501-9060-590-9502 $217,000 1 Non -Departmental Water & Sewer Non -Departmental CIP - Sewer Line Replacement, Carr Park/SH10 Capital N/A 501-9060-590-9502 $330,000 1 Non -Departmental Water & Sewer Non -Departmental CIP - Sewer Line Replacement, Midway Park North Capital N/A 501-9060-590-9502 $3639000 1 Non -Departmental Water & Sewer Non -Departmental CIP - Water Line Replacement, West Ash Lane Capital N/A 501-9060-590-9502 $30,000 1 Non -Departmental Water & Sewer Non -Departmental I CIP - Water Line Replacement, Wesport/Newport/Asbury I Capital N/A 501-9060-590-9502 1 $67,000 1 To: Mayor Saleh City Council From: Joe C. Date: July 2�, T H E fib; C I T Y O F Manager Re: August, 2003 Budget Work Session Well, it is that time of year again. If it's HOT, it must mean that the Budget Season is here. We hope that you have enjoyed the July break from Council meetings and are looking forward to a productive Work Session next week. We have worked hard to prepare you a 2004 Budget Plan that will serve our City well. We continue to remain relatively flat with revenue projections for the year. The July Sales Tax receipts concern us (40%). We will watch the August receipts closely. Maybe it was an aberration and will correct itself in August. If it does not, we will implement planned measures (hiring freezes on existing vacancies) to stabilize us through 2003. All in all, we are in good condition. Many cities continue to face difficult financial conditions that have disrupted employee moral and services provided. Our staff has been remarkable during this prolonged period, and we fully expect they will continue to excel in the new fiscal year. I have attached an agenda for the Budget Work Session. As you know, this is a guide, and we can vary as necessary. If you have questions on the material you receive or we can assist in any way, please call. We look forward to a Work Session of open communication and exchange as we prepare together for the new fiscal year. Attachment CC: Gary McKamie Susan Crim Voretta Getchell JCH/Ikt 201 N. Ector Drive, Euless, Texas 76039-3595 8171685-1400 •Metro 817/267-4403 •Fax 817/685-1416 www.ci.euless.tx.us B UD UET WORK SESSION August 1- 3, 2003 Star Brand Ranch Friday -August 19 2003 10:00 Mayor/Council Work Session 12:00 Break -Lunch 1:00 Budget Work Session ♦ Budget Over -Hennig 5:00 Break -Dinner (�;/� ♦ (after dinner activities planned by Carl Tyson) 1 m Saturday -August 2, 2003 '1%30, ��kr 8930 Budget Work Session ♦ Budget Discussion continued ♦ Capital/Supplemental Discussion - McKamie ♦ CIP Discussion - McKamie ♦ 5 Year Plan - Getchell 12:00 Break -Lunch 1:00 Budget Work Session ♦ Budget Discussion continued ♦ Various Discussion Items -Hennig 5:00 Break -Dinner �/1U�,� ♦ (after dinner activities planned by Carl Tyson) Sunday, August 3, 2003 a - 8*30 2004 Pl nning/Calendaring Discussion - Mayor 11:30 Break - (Home) WORK SESSION DISCUSSION TOPICS 1) Bennett Development Update 2) Highway 183 Funding/TxDOT Court Arraignment Discussion/(Judge Memo) 4) Wine Referendum 5) Texas Star Update 6) Pipeline Road Update 7) Volunteer of the Year REPORT TO THE CITY COUNCIL CITY OF EULESS AUGUST 2003 OVERVIEW 2003 has been a good year in most respects, but the stagnant economy continues to cast a veil over both private and municipal operations. We have enjoyed some economic improvement in 2003, but the future remains questionable in many areas. Our financial position remains in good condition. This is primarily due to the conservative approach during 2001, 2002, and 2003. We will continue this course during 2004 as the world economy stabilizes, and we can become more confident with the future. We have made good progress on our 2003 objectives, and we expect 2004 to be productive as well. The areas where we are behind are primarily due to circumstances outside our control, and the areas where we have excelled are due to excellent management by our Directors and outstanding performance from our loyal, dedicated employees. I have enclosed the Strategic Direction Work Session notes from our May 9, 2003 City Council Work Session. We have used these thoughts to develop our future work plans. RESPONSE TO 2003 OBJECTIVES: COUNCIL COMMUNICATIONS: We continue to stress communication during 2003. Our communication with you and with the staff has allowed for improved decision -making and improved results. We will continue to stress open communication during 2004. ECONOMIC DEVELOPMENT: The economy continues to impact development decisions, but we have worked hard to maintain relationships so that we are prepared when opportunities are present. The interest in the vacant buildings has been virtually non-existent; however, the Bennett group is moving forward with vigor and excitement that has not been present in the past Report to City Council City of Euless August 2003 Page 2 of 3 ECONOMIC DEVELOPMENT - continued: years. Time will tell if their dreams can actually come to reality. The Target Center continues to fill space, and the MAHR property on S.H. 121 is showing some prospects for the coming year. Our future is still bright due to the vacant property that exists in Euless. It is up to us tc develop the relationships that will maximize the development opportunity when it occurs. TEXAS STAR SPORTS CENTRE: The golf course has improved its numbers during 2003 due to a slight improvement in rounds of play and due to close expense management. I am pleased with our 2003 results, considering the economy and the difficulty that the entire golf industry is experiencing. The Parks at Texas Star and Softball World continue to provide Euless citizens with excellent facilities and a very positive image for our City. The Star Center is also a very positive asset for Euless. We are proud of these accomplishments. CONSTR UCTION PROGRAM: Main Street is finally underway, and the Building A remodel is progressing well. We look forward to the completion of both of these projects. Glade Road ROW acquisition has been delayed due to lack of design by Grapevine. The delay will push this project back a year, and actual construction is now expected to begin in early 2005. Pipeline Road progress has been slowed due to Bedford's consideration of involvement. We are hopeful that all preliminary work can be completed to allow construction to begin by fall of 2004. GENERAL: We are recommending a 2004 Budget that does not require a tax rate increase, and we are not reducing services to citizens. This is far and away superior to any other city in the area. Our fiscal management continues to make Euless the preferred choice for growth opportunity. We continue to monitor our medical and Rx expenses, and we will make new changes again for 2004 that will address the ever-present pressure on these areas. Our employee plans Report to City Council City of Euless August 2003 Page 3 of 3 GENERAL - continued: remain competitive, and the costs related to our coverage have increased far below the norm due to our careful management of this area of concern. The 50-Year Celebration has been a positive effort thus far. We will end this 50th year with additional events that actually will occur in the 2004 fiscal year, but overall the celebration has been a positive, enhancing program during 2003. CONCLUSION: In general, Euless remains a great place to live and to work! We provide excellent services at a bargain price. There remains much to do, but much has been accomplished. To eg ther we can move forward to build a better tomorrow. Thank you for your continued support. Enclosure JCH/Ikt T H E 1 IC 1 T Y G F �k MEMORANDUM TO: Mayor Saleh and City Council Members FROM: Susan Crim DATE: July 25, 2003 SUBJECT: Budget Worksession Enclosed is a map with directions to Star Brand Ranch where we will hold our budget worksession next week. Your room number determines the telephone number at which you can be reached while we are there. The main number has a recording on it after hours that will allow the person calling to dial directly to your room by dialing a "4" and your room number. The telephone number is 1=972=932=2714. Even though it is a 972 prefix, you must dial a "1" from an 817 number because it is outside the metroplex. Mayor Saleh Mayor Pro Tem Tyson Council Member Hogg Council Member Edwards Council Member Miller Council Member Porterfield Council Member Massey Joe Hennig Gary McKamie Loretta Getchell Susan Crim cc: Joe Hennig Gary McKamie Loretta Getchell Room No. Telephone Extension 20 420 18 418 02 402 17 417 16 416 15 415 19 419 26 426 23 423 24 424 25 425 LOCATION From DFW Airport Take the South exit to 183 South which feeds into 35E and proceed south. Follow 45 South (Houston) signs; just south of downtown Dallas, take Highway 175 Kaufman for approximately 25 miles, exit at FM 2578 - STAY ON THE SERVICE ROAD (see insert below). Turn right at Star Brand Drive. Follow the logo signs, veering right around our — office/windmill to CHECK -IN located in the Mimi Room. From Love Field Airport approximately 16 miles, exit at FM 2578 -STAY ON THE SERVICE ROAD (see insert below). Turn right at Star Brand Drive. Follow the logo signs, veering right around our office/windmill to CHECK -IN located in the Mimi Room. Star Brand Ranch EXECUTIVE R E T R E A T Take Mockingbird Lane right (west) to 35E and proceed south. Follow 45 South (Houston) signs; lust south of downtown Dallas, take Highway 175 Kaufman for approximately 25 miles, exit at FM 2578 -STAY ON THE SERVICE ROAD (see insert below). Turn right at Star Brand Drive. Follow the logo signs, veering right around our office/windmill to CHECK -IN located 1n the Mimi Room. From North Dallas, Plano, or Richardson Take LBJ 635 East to Highway 175 Kaufman For From Dallas North Tollway Take Tollway south to 35E and proceed south. Follow 45 South — (Houston) signs; just south of downtown Dallas, take Highway 175 Kaufman for approximately 25 miles, exit at FM 2578 -STAY ON THE SERVICE ROAD (see insert below). Turn right at Star Brand Drive. Follow the logo signs, veering right around our office/windmill to CHECK -IN located in the Mimi Room. From Fort Worth Take 20 East to Highway 175 Kaufman for approximately 16 miles, exit at FM 2578 -STAY ON THE SERVICE ROAD (see insert below). Turn . right at Star Brand Drive. Follow the logo signs, veering right around our office/windmill to CHECK -IN located in the Mimi Room. P. 0. Box 1077 Kaufman, Texas 75142 972.932.2714 Fax 972.932.7606 info@starbrandranch.com www.starbrandranch.com �_ Loretta Getchell - Page 1� From: "Jason Hughes" <JHughes@firstsw.com> To: "'LGetchell@ci.euless.tx.us"' <LGetchell@ci.euless.tx.us> Date: 3/20/03 5:03PM Loretta, Attached is debt service on the GO Refunding Bonds, Series 2003 and the remaining debt service on the Series 1995 C/O's that were refunded. Please let me know if you have any questions. Thanks, Jason Jason L. Hughes Assistant Vice President First Southwest Company 325 N. St. Paul, Suite 800 Dallas, Texas 75201 P:214-953-8707 F:214-953-4050 E: <mailto:jhughes@firstsw.com> jhughes@firstsw.com Neither First Southwest Company nor any of its affiliates (collectively, "First Southwest") is responsible forany recommendation, solicitation, offer or agreement or any information about any transactions, customer account or account activity in this communication. Confidential or time -sensitive security -related communications should not be transmitted to First Southwest via the Internet as there can be no assurance of actual or timely delivery, receipt and/or confidentiality. Neither can there be any assurance that messages transmitted by electronic mail will not be corrupted, lost, deleted or modified. First Southwest reserves the right to refrain from processing or executing electronic mail until verification of the information is obtained in another format acceptable to First Southwest. City of Euless, Texas Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of Obligation, Series 1995 DEBT SERVICE SCHEDULE Date Principal Coupon Interest Total P+I FISCAL TOTAL 8/15/2002 - - - - 2115/2003 210,000900 59200//6 119,265,00 329,265.00 ' �— 8/15/2003 11,700.00 11,700.00 - 9/30/2003 - - 3405965.00 2/15/2004 220,000,00 5.200% 11,700.00 231,700.00 - 8/15/2004 - - 5,980.00 5,980.00 - 9/30/2004 - - - 237,680.00 2/15/2005 230,000.00 5.200% 5,980.00 235,980.00 - 9/30/2005 - - 235,980.00 Total 6609000,00 - 154,625.00 8149625100 asYIELD STATISTICS BondYear Dollars.......................................................................................................................... $1,010.00 AverageLife................................................................................................................................... 1.530 Years Average Coupon............... 5.2000000% Net Interest Cost(NIC)................................................................................................................... 5.2000000% TrueInterest Cost (TIC).................................................................................................................. 5.2000000% Bond Yield for Arbitrage Purposes.,......,... 592000000% All Inclusive Cost(AIC)................................................................................................................. 5.2000000% IRS FORM 8038 NetInterest Cost............................................................................................................................. 5,2000000% Weighted Average Maturity........................................................................................................... 1.530 Years First Southwest Company File = EULESS GO Pricing.SF-CO 95 -debt service after refunding- SINGLE PURPOSE Public Finance 3/20/2003 4:48 PM Payment made before refunding occurred. City of Euless, Texas General Obligation Refunding Bonds Series 2003 DEBT SERVICE SCHEDULE Date Principal Coupon Interest Total P+I FISCAL TOTAL 3/04/2003 - - - - - 8/ 15/2003 106,414.58 1065414.58 9/30/2003 - 106,414.58 2/15/2004 615,000.00 3.000% 91,212.50 706,212.50 8/15/2004 81,987.50 81,987.50 9/30/2004 - - 7883200.00 2/15/2005 335,000.00 3.000% 812987,50 416,987.50 8/15/2005 76,962.50 76,962.50 9/30/2005 4939950400 2/15/2006 585,000M 3.000% 76,962.50 661,962.50 8/15/2006 68,187,50 68;187,50 9/30/2006 7309150400 2/15/2007 610,000.00 3.000% 68,187.50 678,187.50 8/15/2007 5%037.50 5%037.50 9/30/2007 - 7375225,00 2/15/2008 465,000.00 3.000% 595037,50 524,037.50 8/15/2008 52,062.50 52,062.50 9/30/2008 5763100,00 2/15/2009 3209000.00 3.000% 525062,50 372,062.50 8/15/2009 47,262.50 47,262.50 9/30/2009 4195325,00 2/15/2010 325,000.00 3.150% 47,262.50 372,262.50 8/15/2010 42,143.75 42,143.75 9/30/2010 414,406.25 2/15/2011 335,000.00 3.500% 42,143,75 3775143,75 8/15/2011 36,281,25 362281,25 9/30/2011 413,425.00 2/15/2012 350,000.00 3.600% 369281.25 386,281.25 8/15/2012 293981,25 29,981,25 9/30/2012 - 416,262.50 2/15/2013 365,000.00 3.650% 29,981.25 394,981.25 8/15/2013 23,320.00 23,320.00 9/30/2013 418,301.25 2/15/2014 380,000,00 3.800% 23,320.00 403,320.00 8/ 15/2014 16,100.00 16,100,00 9/30/2014 - - 41 %420.00 2/15/2015 3952000,00 4.000% 16,100.00 411,100.00 8/15/2015 83200,00 85200,00 9/30/2015 4199300.00 2/15/2016 410,000.00 4.000% 8,200.00 418,200.00 9/30/2016 - - 4185200,00 Total First Soutbwesl Compnny Public Finnnce 52490,000.00 - 1,280,679.58 6,770,679.58 File = EULESS GO Pricing.SF-Pricing -revised - ds jurtd- SINGLE PURPOSE 3/20/2003 3:15 PM City of Euless, Texas General Obligation Refunding Bonds Series 2003 DEBT SERVICE SCHEDULE YIELD STATISTICS Accrued interest from O1/15/2003 to 03/04/2003........................................................................... Bond Year Dollars........,. lo"Ismalasom M1049190611 oll Do old mdodold moldelole'd AverageLife.....................................................................................................hold........................... Average Coupon.., .. 101910100914 Boosted domemosedomed mompotoplo ISBN 16141111191 10,9011 polemol NetInterest Cost(NIC).................................................................................................................... TrueInterest Cost (TIC).................................................................................................................. Bond Yield for Arbitrage Purposes, . . . . . . m 0 1 1 1 * 1 6 1 1 0 1 1 9 1 0 1 0 4 9 1 0 1 AllInclusive Cost(AIC).................................................................................................................. IRS FORM 8038 NetInterest Cost. . I I 1 0 1 9 1 1 1 1 1 1 1 9 1 0 1 m I 1 0 1 0 4 0 4 0 0 m 4 , I a , , m , 9 . 9 . 0 V , 0 , 4 0 1 0 0 1 1 0 0 0 m a m & m & a * a m V m m I , 9 . 1 0 , 0 , 0 0 0 0 1 1 4 a m 0 P 0 m I m m I m a V . 0 , , V 1 9 , , 4 0 0 m 0 m 0 m 0 Weighted Average Maturity.............. B401 10101011 I'll, 144mommomp'l Ed PEON 'Plov'9191 0010,4 he 24,830.07 $36,187,50 6.592 Years 3.5390109% 3.5157362% 3.4895811% 3.4238213% 3.6578356% 3.4152750% 6.404 Years First Sadhwesl Company File = EULESS GO Prlcing.SF-Pricing -revised -its fiord- SINGLE PURPOSE Public Finance 312012003 3:25 PM CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: TAX AND WATERWORKS AND SEWER SYSTEM (SURPLUS) REVENUE CERTIFICATES OF OBLIGATION, SERIES 2001 - GLADE RD DATED: April 1, 2001 ORIGINAL AMOUNT: $5,455,000 INTEREST RATES: BOND YEAR 2002 - 2007 @ 6.500%, 2008-2011 @ 4.500%, 2012 - 2013 @ 4.625%, 2014 @4.750%, 2015 @ 4.875%7 2016-2017@ 5.000%, 2018-2021 @ 5.125% PAYING AGENT: OPTION DATE: August 1, 2011 YEAI :...:...:.:.:.:............................:.....:......:.:.............I..:.:.....:...........::........ (1U1 4N ::.::.. IN7 r:::::::::::::::::::::::::::::: RE......................................::::::::::.::::::.:::.:::::::::TAL,;.:. 1. PR O A A.:.:.:.:...:...:.:.:...:.:.:.:.... I : E IV1` ,...:.:......00......�ll>r...::...:.:: € F9Bt AaY A..........., .,.:.:......:... 2002 6.500% $0 $203,234 $37,852 $2419086 2003 6.500% $0 $149,965 $91,926 $241,891 2004 6.500% $0 $1439990 $97,334 $241,324 2005 6.500% $0 $137,663 $100,038 $237,701 2006 6.500% $0 $131,161 $1089149 $2397309 2007 6.500% $0 $124,131 $113,556 $2379687 2008 4.500% $0 $116,750 $118,964 $235,713 2009 4.500% $0 $111,397 $129,778 $241,175 2010 4.500% $0 $105,557 $132,482 $238,039 2011 4.500% $0 $99,595 $143,297 $242,892 2012 4.625% $0 $93,146 $146,001 $239,147 2013 4.625% $0 $86,394 $156,816 $243,210 2014 4.750% $0 $799141 $162,223 $241,364 2015 4.875% $0 $71,436 $173,038 $244,474 2016 5.000% $0 $63,000 $178,445 $241,445 2017 5.000% $0 $54,078 $191,964 $246,042 2018 5.125% $0 $44,480 $202,779 $247,258 2019 5.125% $0 $34,087 $208,186 $242,273 2020 5.125% $0 $23,418 $221,705 $245,122 2021 5.125% $0 $12,055 $235,223 $247,279 TOTAL $0 ::L:$11884,676 $2,949,756 $4,8341432 CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: TAX AND WATERWORKS AND SEWER SYSTEM (SURPLUS) REVENUE CERTIFICATES OF OBLIGATION, SERIES 2001 - PARK BUILDING DATED: April 1, 2001 ORIGINAL AMOUNT: $5,455,000 INTEREST RATES: BOND YEAR 2002 - 2007 @ 6.500%, 2008-2011 @ 4.500%9 2012 - 2013 @ 4.625%, 2014 @4.750%, 2015 @ 4.875%, 2016-2017@ 5.000%, 2018-2021 @ 5.125% PAYING AGENT: OPTION DATE: August 1, 2011 ldO['1.....,...... O ........1........FECU .TOTAL.....:. ..: Ail' .....! .......... Ifli.. BAR ............. AU±IS.............0 2002 6.500% $0 $102,816 $197149 $121,966 2003 6.500% $0 $759867 $46,506 $122,373 2004 6.500% $0 $72,845 $49,241 $122,086 2005 6.500% $0 $69,644 $50,609 $120,253 2006 6.500% $0 $667354 $54,713 $121,067 2007 6.500% $0 $629798 $57,448 $120,246 2008 4.500% $0 $59,064 $60,184 $119,248 2009 4.500% $0 $56,356 $65,655 $122,011 2010 4.500% $0 $53,401 $67,023 $120,424 2011 4.500% $0 $50,385 $72,494 $122,879 2012 4.625% $0 $477123 $73,862 $120,985 2013 4.625% $0 $43,707 $79,333 $123,040 2014 4.750% $0 $40,038 $829069 $122,106 2015 4.875% $0 $36,139 $87,540 $123,679 2016 5.000% $0 $319872 $90,276 $122,147 2017 5.000% $0 $277358 $97,115 $1247473 2018 5.125% $0 $22,502 $102,586 $1259088 2019 5.125% $0 $17,245 $105,322 $122,566 2020 5.125% $0 $11,847 $1129161 $124,008 2021 5.125% $0 $6,099 $119,000 $125,098 TOTAL $0 $953,459 $11492,283 $2,445,742 CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: TAX AND WATERWORKS AND SEWER SYSTEM (SURPLUS) REVENUE CERTIFICATES OF OBLIGATION, SERIES 2001 - NORTH MAIN DATED: April 1, 2001 ORIGINAL AMOUNT: $5,455,000 INTEREST RATES: BOND YEAR 2002 - 2007 @ 6.500%, 2008-2011 @ 4.500%12012 - 2013 @ 4.625%, 2014 @4.750%, 2015 @ 4.875%, 2016-2017@ 5.000%9 2018-2021 @ 5.125% PAYING AGENT: OPTION DATE: August 1, 2011 : YFE O...:::::::::::::::::::::::::::::::::::::::::::: ..........TOTAL........ . iR' IAI Y 1 I'll, ........................................................ 2002 6.500% $0 $69,792 $12,999 $82,790 2003 6.500% $0 $519499 $31,568 $83,067 2004 6.500% $0 $49,447 $33,425 $82,872 2005 6.500% $0 $47,274 $34,353 $81,628 2006 6.500% $0 $45,041 $37,139 $82,180 2007 6.500% $0 $42,627 $38,996 $81,623 2008 4.500% $0 $40,093 $40,853 $80,945 2009 4.500% $0 $38,254 $44,567 $82,821 2010 4.500% $0 $367249 $45,495 $81,744 2011 4.500% $0 $34,201 $49,209 $83,410 2012 4.625% $0 $319987 $50,137 $82,124 2013 4.625% $0 $29,668 $53,851 $83,519 2014 4.750% $0 $27,177 $55,708 $82,886 2015 4.875% $0 $24,531 $59,422 $83,953 2016 5.000% $0 $21,635 $61,279 $82,914 2017 5.000% $0 $18,571 $65,921 $84,492 2018 5.125% $0 $15,274 $69,635 $849910 2019 5.125% $0 $11,706 $71,492 $83,198 2020 5.125% $0 $8,042 $76,135 $84,176 2021 5.125% $0 $4,140 $80,777 $84,917 TOTAL 1 $0 $647,207 $17012,961 $1,660,168 Water & Sewer DEBT SERVICE AMORTIZATION SCHEDULE = F'Yog Parameters Beg Prin APR Term (In Years) 242, 064.50 2.00 10 Source Maturity Water/Sewer 9/2012 MM/YY Payment Interest Principal Balance Oct-01 2,227.32 403.44 1,823.88 240,240.62 Nov-01 2,227.32 400.40 1,826.92 238,413970 Dec-01 2,227.32 397.36 11829696 236,583674 Jan-02 21227432 394.31 11833601 234,750072 Feb-02 21227032 391.25 11836007 232,914.65 Mar-02 21227632 388.19 11839/13 231,075.53 Apr-02 21227932 385.13 11842819 229,233833 May-02 21227532 382.06 11845026 227,388007 Jun-02 21227532 378.98 11848034 225,539073 Jul-02 21227632 375.90 11851042 223,688031 Aug-02 21227032 372.81 17854251 221,833280 Sep-02 21227032 369.72 11857660 219,976020 26,727.84 4,639.54 22,088.30 Monthly Amort 2227.32 386.63 1,840.69 FYo3 Variable Debt Service FY03 FY03 FY03 Original Original Remaining Variable Original Beg Balance @ FY03 Monthly Annualized Term Rate Term Rate Principal Maturity Allocation 10/02 Payment Payment Operating Loan (W/S) 15 5,50% 10 2.00% 320,000 9/2012 ,Golf Course - 2421064,50 2,227.32 269727.84 Slope Protection (Car Rental) 20 5.00 % 19 2.00 % 1,250,000 92021 Golf Course 1,212,658.56 67397.45 76,769.40 Golf Maintence Equipment (Car Rental) 4 4.00 % 3.25 290 % 333,112 122005 65 GC/ 35 12 Penny 2747637.83 71279,20 87,350.40 1/2 Penny Allocation (21547.72) (30,572.64) 13,356.25 160,275.00 Original FY03 Month/y Allopfion 540.7060-550-9541 2,656.66 WatenSewerLoan 540-7060550-9240 8,249.42 Slope Protection 540-7060-550.9240 7,521,37 GCMEquipment 540-0000-491-1210 (21632.50) GCM 12 Penny Allocation 15, 794.95 Oct -February A//ocafion Total (5 Months) 540.7060-550.9541 13,283.30 WateNSewerLoan 540-7060550-9240 41,247.10 Slope Protection 540-7060550-9240 37,606.65 GCM Equipment 540-0000-4914210 (13,162.50) GCM 12 Penny Allocation 78,974.75 _Oct -February Allocation Total Adjusted As Should Be 540-7060-550.9541 11,136.60 WatedSewerLoan 540-7060-550-9240 31,987.25 Slope Protection 540-7060550-9240 36,396.00 GCMEquipment 540-0000491-1210 (12,738.60) GCM 12Penny Allocation 66, 781.25 Oct -February A//option Adiusimerrf Required 540-7060-550-9541 (2,146.70) Water/Sewer Loan 540-7060-550-9240 (9,259.85) Slope Protection 540-7060.550.9240 (1,210.85) GCM Equipment 540-0000-491-1210 423.90 GCM 12 Penny Allocation (12,193.50) CITY OF EULESS ADJUSTING JOURNAL ENTRY Group # Description: Adj FY03 Debt Allocation (Oct - Feb) Document # Date 2/28/03 Page 1 of 1 Account Name Account No. Debit Credit Nor Golf Course Cash 540-0000-101-0000 Nor 21146970 Golf Course Cash 540-0000-101-0000 L0000m 9,259.85 Golf Course Cash 540-0000-101-0000 1,210.85 Golf Course Cash 540-0000-101-0000 423.90 Golf Course CIP Transfer 540-7060-550-9541 2,146.70 Golf Course Car Rental Transfer 540-7060-550-9240 92259.85 Golf Course Car Rental Transfer 540-7060-550-9240 11210085 Golf Course-1/2 Cent Operating 540-0000-491-1210 423.90 Nor Low 13,041.30 INS 139041.30 Comments: Refinance Debt Agreement with 2% for FY03 on Slope Protection, GCM Equipment, and W/S Loan, This entry to adjust recurring entries from Oct -February 03. New recurring entry fo be posted effective with 3/03 Finance period. PLEASE ATTACH ANY SUPPORTING DOCUMENTATION Signature DepartmentL�.,L Iry S S Entered By Date Group # CITY OF EULESS ADJUSTING JOURNAL ENTRY Document # Description: Adj FY03 Debt Allocation (Oct -Feb) Date 2/28/03 Page � of � Account Name Account No. Debit Credit 1/2 Cent Op Cash 210-0000-101-0000 423.90 Enterprise Transfer To Golf 210-1052-550-9540 423.90 423.90 Comments: Refinance Debt Agreement with 2% for FY03 on GCM Equipment. This entry to adjust recurring entries from Oct -February 03. New recurring entry to be posted effective with 3/03 Finance period. PLEASE ATTACH ANY SUPPORTING DOCUMENTATION Signature Entered By Department Date Group # CITY OF EULESS ADJUSTING JOURNAL ENTRY Document # Description: Adj FY03 Debt Allocation (Oct -Feb) Date 2/28/03 Page 1 of 1 Account Name Account No. Debit Credit Car Rental Cash 240-0000-101-0000 91259585 Car Rental Transfer 240-0000491-1540 91259985 Car Rental Cash 240-0000-101-0000 11210585 Car Rental Transfer 240-0000-491-1540 1,210,85 109470,70 10,470 70 Comments: Refinance Debt Agreement with 2% for FY03 on Slope Proecfion & GCM Equipment, This entry to adjust recurring entries from Ocf -February 03, New recurring entry to be posted effective with 3/03 Finance period, PLEASE ATTACH ANY SUPPORTING DOCUMENTATION Signature Department Entered By Date, Group # CITY OF inULESS ADJUSTING JOURNAL ENTRY Document # Description: Adj FY03 Debt Allocation (Oct -Feb) Date 2/28/03 Page � of � Account Name Account No. Debit Credit Water/Sewer Cash 501-0000-101-0000 2,146.70 Water/Sewer Transfers 501-0000491-1541 21146570 12,14610 2,146.70 Comments: Refinance Debt Agreement with 2% for FY03 on W&S Note. This entry fo adjust recurring entries from Oct -February 03. New recurring entry to be posted effective with 3/03 Finance period. PLEASE ATTACH ANY SUPPORTING DOCUMENTATION Signature Department Entered By Date Group # CITY OF EULESS ADJUSTING JOURNAL ENTRY Document # Description: Adj FY03 Debt Allocation (Oct -Feb) Date 2/28/03 Page � of � Account Name Account No. Debit Credit GC CIP Principal 541-9060-590-8701 12515,55 GC CIP Interest 541-9060-590-8702 31662525 CIP Transfers 541-0000491-1540 2114610 3,662.25 3,662,25 Comments: Refinance Debt Agreement with 2% for FY03 on W&S Note. This entry to adjust recurring entries from Oct -February 03, New recurring entry to be posted effective with 3/03 Finance period. PLEASE ATTACH ANY SUPPORTING DOCUMENTATION Signature Department Entered By Date, CITY OF EULESS ADJUSTING JOURNAL ENTRY Group # Description: FY03 Debt Recurring Entry - W/S Note Document # Date FY03 Page 1 of 1 Account Name Account No. Debit Credit GC CIP 540J060=550-9541 21227532 GC Cash 540-0000-101-0000 2,227132 GC CIP Principal 541-906M9M701 11840469 GC CIP Interest 541-906M9M702 386163 GC CIP Transfer 541-0000491-1 540 21227032 W/S Transfer 501-0000491-1 541 2,227132 W/S Cash 501-0000-101-0000 2,227.32 6,681.96 6,681.96 Comments: PLEASE ATTACH ANY SUPPORTING DOCUMENTATION Signature Department Entered By Date CITY OF EULESS ADJUSTING JOURNAL ENTRY Group # Document # Description: FY03 Debt Recurring Entry - GCM Equipment Date FY03 Page of Account Name Account No. Debit Credit 1/2 CIP 210-1052-550-9540 21547072 1/2 Cash 210-0000-101-0000 2,547.72 GC Car Rental CIP 540-7060-550-9240 71279920 GC Cash 540-0000-101-0000 7,279020 GC Cash 540-0000-101-0000 21547,72 GC CIP Transfer In 540-0000-491-1210 21547,72 Car Rental Cash 240-0000-101-0000 7,279.20 Car Rental CIP Transfer 240-0000-491-1540 7,279.20 J19165184 19,65184 Comments: PLEASE ATTACH ANY SUPPORTING DOCUMENTATION Signature Department Entered By. Date Group # CITY OF EULESS ADJUSTING JOURNAL ENTRY Document # Description: FY03 Debt Recurring Entry -Slope Date FY03 Page � of � Account Name Account No. Debit Credit GC Car Rental CIP 540-7060-550-9240 61397,45 GC Cash 540-0000-101-0000 69397045 Car Rental Cash 240-0000-101-0000 61397645 Car Rental CIP Transfer 240-0000491-1540 61397,45 12,794.90 12,794,90 Comments: PLEASE ATTACH ANY SUPPORTING DOCUMENTATION Signature Department Entered By Date �Z.l le S S Slope Protection DEBT SERVICE AMORTIZATION SCHEDULE - FY03 1,212,658.56 2.00% 19 Source Maturity Car Renfa/ 9/2021 MM/I'Y Payment Interest Principal Balance Oct-01 6,397.45 27021.10 4,376.36 1,208,282.20 Nov-01 69397945 2101180 4138165 1,203,898.55 Dec-01 61397045 21006050 47390095 11199,507060 Jan-02 67397045 17999018 41398027 111951109a33 Feb-02 6,397.45 1,991585 4,405.60 11190,703073 Mar-02 61397,45 1 F984951 4,412.94 11186,290079 Apr-02 61397045 11977015 41420030 11181,870049 May-02 6,397.45 11969078 4,427.67 11177,442082 Jun-02 61397045 11962840 4,435.05 1,173,007.78 Jul-02 6,397.45 11955001 41442444 11168,565634 Aug-02 61397245 1,947.61 47449.84 1,164,115.50 Sep-02 67397045 1,940.19 4,457.26 11159,658024 Golf Course Maint Equipment DEBT SERVICE AMORTIZATION SCHEDULE - FY03 Parameters Beg Prin APR Term (In Years) 274, 637.83 2.00% 3.25 Source Maturity Car Rental 12/2005 MM/YY Payment Interest Principal Balance Oct-01 7,279.20 457.73 61821647 267,816.36 Nov-01 7,279.20 446.36 6,832.84 260,983.52 Dec-01 7,279.20 434697 61844023 254,139029 Janw02 71279020 42157 67855663 247,283066 Feb-02 71279420 412514 61867906 240,416460 Marm02 71279020 400069 6,878.51 233,538.09 Aprm02 7,279.20 389823 61889097 226,648012 May-02 77279820 377075 61901045 219,746467 Junm02 7,279.20 366624 6,912.96 212,833371 Juk02 71279620 354.72 67924048 205,909024 Augm02 71279520 343018 61936402 198,973022 Sep-02 71279620 331.62 6,947.58 192,025064