The URL can be used to link to this page

Home My WebLink AboutPACKET Light and Power Committee 2002-12-12'4 TOWN OF ESTES PARK Light and Power Committee AGENDA December 12,2002 7:30 a.m., Board Room 1. 2003/2004 Electric Rate Increase Â° Max Kiburz 2. Reports , A. Platte River Power Authority B. Financial Report C. Project Updates NOTE: The Light and Power Committee reserves the right to consider other appropriate items not available at the time the agenda was prepared. - REM Prepared 12/5/2002 TOWN OF ESTES PARK Office Memorandum To: -- The Honorable Mayor Baudek and Board ofTrustees From: Richard E. Matzkâ‚¬72 'ZLe- I)ate: December 11,2002 Re: 2003/2004 Electric Rate Increase BACKGROUND: Attached is a summary ofthe rate changes proposed by the electric rate study completed by our consultant M.E. Kiburz and Associates. The study recommends changes affecting all rate classes and recommends eliminating one rate and establishing two new rates. The overall impact ofthese changes result in a 6.25% revenue increase in 2003 and an additional 6.26% revenue intrease in 2004. BUDGET/COST: The 2003 Budget includes a $425,000 revenue increase (5.61%) and the 2004 Budget includes another $425,000 revenue increase (5.14%) The revenue increase indicated by the rate study is $906,000 compared to the two-year total in the Budget of $850,000. RECOMMENDATION: The changes proposed by the electric rate study are necessary to maintain an adequate fund balance and provide funding for responsive system operation. The Light and Power Department requests that the rate changes be recommended to the Town Board for consideration at the rate hearing to be held during the regular meeting on January 14, 2003. REM 1-1 December 13, 2002 VOTICE OF PROPOSED RATE MODIFICATIONS TO THE ELECTRIC RATES )F THE TOWN OF ESTES PARK, COLORADO A proposed modification of the Town of Estes Park' s ("the Town") rate schedules, resulting in an increase affecting all electric rates, will be considered by the Town's Board of Trustees at a public hearing on January 14, 2003 at 7 p.m., in the Board Room located in the Municipal Building, 170 MacGregor Avenue, Estes Park Colorado. At this public hearing an extension of the winter season to include the months of September through April for rate classes with seasonal charges will be proposed. A recommendation will be made to revert the Residential Demand and all Residential Time-of-Day rates to the standard Residential rate during the non-winter months. A recommendation will be made to revert the Small Commercial Energy Time-of-Day rate to the Small Commercial rate during the non-winter months. The Residential Time-of-Day rate, which includes a demand charge is proposed to be eliminated. Also, the list of holidays considered as off-peak for Time-of-Day rates is proposed to be expanded to include Christmas Eve. The off-peak kWh charge for Time-of-Day rates will be increased to accurately reflect the Town's costs. The combined billing option for Large Commercial and RMNP Large Administrative rates is proposed to be eliminated. A new Residential Energy Basic Time of Day rate and an optional Wind Power Surcharge rate will be recommended. Any electric customer of the Town may appear, either personally or through counsel, at the public hearing to provide testimony or comment regarding the proposed modifications. The rate increase is proposed to be implemented in two phases with a 6.25% increase effective February 1, 2003 and a 6.25% increase effective January 1, 2004 and will affect the electric rates of all customers of the Town of Estes Park. All rate classifications shall be subject to a Purchase Power Rider which will pass on any increase resulting from changes in the Platte River Power Authority base electric rates to the Town. The purpose of the modifications is to implement the results of the recently completed rate study performed by M.E. Kiburz and Associates, the rate consultant to the Town. The modifications would adjust base rates to account for changes in the Town's cost of serving each rate class, the current cost of wholesale power, and the adjustment of demand rates to reflect the current electric usage in the system. The cost to each individual customer will depend upon the type of service received and monthly consumption. The proposed changes will apply to all customers of the Town, whether they are located inside or outside the municipal boundaries of the Town. Further, the modifications will apply equally to customers within each affected rate category. You are hereby also advised that the entire proposed modified rate schedules, existing rate schedules, and the rate study are available for public inspection at the offices of the Light and Power Department, Estes Park Municipal Building, 170 MacGregor Avenue, Estes Park, .Colorado, between the hours of 8 a.m. and 5 p.m,, Monday through Friday. Enclosed is a summary of the proposed rate modifications. If you have any questions or need any further information, please contact the Light and Power Department at the Estes Park Municipal Building or call (970) 577-3588 from 8 a.m. to 5 p.m., Monday through Friday. TOWN OF ESTES PARK By: Richard E. Matzke Light and Power Director ca) 0 -C M 000 CD 2 ~B R gs 8 0 M 0 2Â£ m H o Cl cO E r g & &= 0 CD 8 8 8 00 g 00 do te 66 64 66 OLLIOU} 03(9(9 M O 0 10 CO N CON % A 52 O 0 0 M O N 00 05 (D 0 0 0 1 0 0) 9- 1-- &.C Â© O - g g E 00 00 00 N 00 CD AN 0 0 N 0 0 00 -UD kiD 000 0 000 0 0 0 00 0 0 LU /3 3* fi &4 Li 2 M 0 0 0 0 0 0 00 0 0 0 2 000 0 0 64 68 64 e 66 0 a) E g 0 0 0 0 0 0 0 0 0 10 10 0 1.0 10 10 g Â¤) C 0 0 0 0 000 0 0 (N C\! N N N C\! M 2 e 4 4 Â·co Lo CO LO LO LO LO h. AN 00 00 0 99 69 ee 2 0ete e te 64 64 64 69 64 09 O 0 66 E J CD 2 2 W 9 5 0 CD CD R C C .C 2 1 1 .C =r 0 m 0 0 17; B BE .2 -8 0 0% C C A C A ~ C O) CO 1- U) ecu 2 0 Â® 0 0 O 0 2 2 2 O 0 a. (1) 2 (D E c- Cmc 111 E Â® 0 CO Ug Lri 0 (D (D at) .Â¤ Â¤) 0 2 2 . 1- a 09 0 Z.E -C -a >.%* Â® 16 P -M Ccc > CD C>4Ch > 0 2 0 -05 0 -03 m co 2 10 3 -- m 15 (0 18 0=02 J=J 0- 0 2127 2020 ERE .1 9 33 0 Â® k a) E a) E Â® E 0 E > 0 -9 (D 95 E '65 E & E M EVEg mEo E 0 E o 0 -2-0 020_ 999.2 E 2 Th .E ~ -2 --C U) b co> -35 0) U Q) ....mu) Eg 1- D co J J>J> J= J= >2 E O-M 01 0=0= . 0 N O 2 0 - TB E 19 0 a' E 0760 -2 3-a 3 EFIZE *~ 6 221 1 0=g .- = -0 - CO-CU : .Â®= 01 0 * Ld v 0 -2 0 2 .- B E 63 E w EN E NE N C POE I ~,NgNg >P .' U) 16 E m E.;6 Â®929 E 2 -a 2 -a a) (D (D (D (D 0 E 71 0 1 al a C==-= C- CO ~82 8 :m Â® .* a, - L /- E =16 3 ILI E E m E -2 8 - ST U 16 0 16 0 16 16_COC E.2 E 2 co -2 2 0-= m- -2 1 0 - co 0 0 0 Â® 2 92 -= 22 = c .92 >, -2 A 0- 0 0 -0 0 (D -0 W (O -C (O -C CD , (0 co (U co _ 0 (0 -c (0 -C (D = 1 8 Â®Â® 0- =E=a,Â® = 1=3=-re 0 0 13Â¥32% C (0 c -C C 3MiNS 3 g K S 2-32&% 2.39.Es 0 >C>C O-co 05< :<-5 0 Of<(0< Co< 0 Of<-al <-Â¥ 0 05<<0 co< bcoco .<-500 CO -2 00911 3 83 C O 2 Boo R b b 22 b RE 0 0 0 Summer Current $7.15 $3.93 $7.15 NA 2004 $7.89 NA ustomer nergy Demand 09910'09 00 09810'0$ â‚¬001 09910'0 22190'0 Estes Park Electric Rate Summary 2003 tl eside Current 2004 *001 â‚¬001 *001 Notice of Proposed Electric Rate Modifications Town of Estes Park Customer Energy Charge Charge $/Month $/kWh Municipal Rate Current Available for municipal street, park lighting, and buildings $0.06216 2003 $0.06602 2004 $0.07012 Outdoor Area Lighting Current Available for lighting outdoor private areas $5.25 2003 $6.32 2004 $7.61 Wind Enerqv Surcharne (NEW) 2003 Available to all residential and commercial customers (PRPA $0.02500 wind surcharge plus $0.001/kWh) 2004 Same $0.02500 Notes 1) Residential Time-of-Day rate (with demand charge) will be eliminated 2) The winter season for the Residential Energy Basic Time-of-Day, and Residential Demand will be extended to include April and September. The energy charge for these rates during summer season will revert to standard Residential rate. 3) Holidays considered as off-peak for Time-of-Day rates will include Christmas Eve 4) Combined billing option for Large Commercial, Large Commercial Time-of-Day, and RMNP Large Administrative rates will be eliminated. 5) On-peak hours for Residential Energy Basic Time-of-Day rate will be 4 p.m. to 7 p.m. Monday through Friday. All other hours shall be considered off-peak. NOTICE OF PROPOSED RATE MODIFICATIONS TO THE ELECTRIC RATES OF THE TOWN OF ESTES PARK 0 3 81 C) 10 C a) (N u-2 01 1- 1.0 co CD Â· E &3~ 0 0 0 911 4 64 66 64 â‚¬14 64 0 -C 00* 0 10 2 0 R Sg ._ Ul (0Â¤) EME C) a. w r- 91- 91- r r 69 66 69 66 64 68 60 64 CD -C 00&4 1 LO O 4- LO 10 CD E & & N N N O 00 0 00 64 64 64 0 - 00 r- 00 2 e e 10 0 - 00) 10 g LCD 00 0 Lo 00 0 00 r N 0 0 N O N 1 10 00 Â»00 $ CON tg N Cr) CO WN 1.- rrE g 0 00 00 2 00 00 0 00 0 00 00 00 do 0 00 6> 64 64 . 4,89 2 6,>ee 89 ee â‚¬8 64 64 LU O g g 0 0 0 00 8 00 lf) tOlD '. 00 E Â® S < go 00 0 0 N W M < 9 9 2 r g z 9-9 NN cri 44 A h N Z 00 L- /=5 09 69 64 69 â‚¬e â‚¬4 64 , 64 e . r- 09 .9 0064 2 ~2 L.C 1; il 8 CD co C m E (D e (D E 29 2 8 1 iEi=E (D E 18â‚¬eR 2 ~ .5 2 2 - Elti E=-= CO 5 N 82 04-J== E Â®CE 2 % Li E.2 2 0 8 O 0 -1 12 m 0 ME . a -2 0 00 5 0-R 2 Â® f 0 2 m m >.m E :8 (0.10 > co U) co J CO <.cLU CO < cou U) 05< u) (OUU) E E E % 88 2 co =1- 2 00 00 2 00 00 b Ag 0 0 1- 00 3 N N / N (\1 2 N N 0 0 0 0 k Winter Summer Avai able commercial customers with deman NA $0.029 9 0.70 $10.70 0.70 $10.70 $11.17 El. *$ EL'17$ GA!*319!ull.Upe MJed leuO!1eN u!e Estes Park Electric Rate Summary in alternate source of power available for deliv eA!1eils!uil.Upe Mied leuo!leN u!ejuno Jeaod Jo eoinos ejeuielle ue e 41!M Ulels*s 0!4080 >I.led sels3 e 1 AleA!lep Joi 0'q ble to Rocky Mountain National Park residence ~~ell]~eu- 40~!4 e 00!AJeS eA! le.Ils! u v IleLUS dNI/\12 Large Commercial Current Available to comme RMNP Administrative Housing Ule}SXS 0!40ele Mied SSel JO AA>19â‚¬Jospu ands exceeding Same Same el.Ues VOOZ Â£001 , estcos2001.xisestcos2001.xls 12A11/2002 TOWN OF ESTES PARK Revenue Requirement Test Year ended December 31, 2001 Adjusted 2003 2004 Per Revenues and Rate Revenues/ Rate Revenuesl B~Es Afudmmna Em/nag loc[ease Exneoses kinara Eminses Revenues: Residential 2,813,677 0 2,813,677 201,914 3015591 218270 3233861 Residential Demand 692,847 0 692,847 72,329 765176 68865 834041 Residential TOD 3,910 0 3,910 -3,910 0 Residential TOD 152,537 0 152,537 15,724 168261 13741 182002 General Service Small 1,711,436 0 1,711,436 70,834 1782270 73517 1855787 Small Comm. TOD 7,290 0 7,290 459 7749 488 8237 General Service Large 1,619,934 0 1,619,934 86,671 1706605 70396 1777001 Large Comm. TOD 6,825 0 6,825 270 7095 293 7388 Municipal 171,778 0 171,778 10,663 182441 11324 193765 Outdoor Lighting 1,019 0 1,019 208 1226 251 1477 Wind Power (1) 7,055 -7,055 0 0 0 0 0 RMNP hZ.924 Q 1%924 2.2&Q 50264 1151 53415 Subtotal Rev. from Sales 7,236,231 -7,055 7,229,176 457,502 7,686,678 460,296 8,146,974 Revenue Credits: Rent 15,000 0 15,000 15,000 15,000 Misc. Revenue 200,887 0 200,887 200,887 200,887 Misc. Sevices 90,551 0 90,551 90,551 90,551 Interest Income (2) 199.843 :13Q.QQQ 69&A3 89.643 69.343 Subtotal a.181 =130,100 371Qal 318.Qal 376,081 Total Revenues 7,742,312 -137,055 7,605,257 8,062,759 8,523,055 Expense ~ Purchased Power Demand 2,068,586 0 2,068,586 2,068,586 2,068,586 Energy (1) 1.ZIL21 =11.112 1,ZAS.&25 1.ZAB.Â£125 122/6/125 Subtotal 3,826,183 -11,172 3,815,011 3,815,011 3,815,011 ~Distribution O&M Salaries 728,897 0 728,897 728,897 728,897 Payroll Taxes 54,566 0 54,566 54,566 54,566 Employee pensions and benefits 133,616 0 133,616 133,616 133,616 Maintenance and repair 196,190 0 196,190 196,190 196,190 ~surance 29,909 0 29,909 29,909 29,909 26,990 0 26,990 26,990 26,990 Rent 2,200 0 2,200 2,200 2,200 Other 8.341 Q 8.341 8.111 8,341 Subtotal 1,180,709 0 1,180,709 1,180,709 1,180,709 Customer Accounting Salaries (3) 294,944 115,000 409,944 409,944 409,944 Payroll taxes (3) 24,061 9,200 33,261 33,261 33,261 Employee pension and benefits (3) 64,954 25,300 90,254 90,254 90,254 Maintenance and supplies 86,269 0 86,269 86,269 86,269 Uncollectible accounts 5,217 0 5,217 5,217 5,217 Insurance 6,952 0 6,952 6,952 6,952 Other 1239 0 1239 1229 i239 Subtotal 486,636 149,500 636,136 636,136 636,136 Total Distribution & Customer(TD&C) 1,667,345 149,500 1,816,845 1,816,845 1,816,845 Amin. & Gen. Salaries 241,048 0 241,048 241,048 241,048 Payroll and Other Taxes 17,942 0 17,942 17,942 17,942 Maintenance and Supplies (4) 299,939 -90,000 209,939 209,939 209,939 Professional fees 32,357 0 32,357 32,357 32,357 Insurance 12,775 0 12,775 12,775 12,775 Employee Benefits & Pensions 44,395 0 44,395 44,395 44,395 Other 1Z1.Z54 AZ.SBQ 219.334 219.334 212.334 Subtotal 820,210 -42,420 777,790 777,790 777,790 Total Operating Expenses 6,313,738 95,908 6,409,646 6,409,646 6,409,646 Capital Improvements From Current Revenues 550,292 220,000 770,292 770,292 770,292 Transfer to Gen. Fund (5) 744,983 -58,211 686,772 43,463 730,234 43,728 773,963 Franchise Fee & In Lieu of Tax (5) 217,250 1,433 218,683 13,839 232,522 13,924 246,446 Interest on Customer Deposit 8.862 Q 8,862 8,862 8,862 44% Subtotal 1,521,387 163,221 1,684,608 57,302 1,741,910 57,652 1,799,562 Debt Service 303,400 0 303,400 303,400 303,400 Total Cost of Service 8,138,525 259,129 8,397,654 8,454,956 8,512,608 9 Surplus(+)/Deficit(-) -396,213 -396,184 -792,397 -~592,197~37 10,447 Percent of Sales 5.48% 10.96% ~ - - 5.10% -0.13% Notes: 1. Remove Wind Power. 2. Reduced interest earnings to reflect 2003 budget. 3. Increased to reflect 2003 budget. 4. Hydro museum grant eliminated. 5. Factors used to calculate: Transfers to Gen. Fund 9.50% 9.50% 9.50% Inside energy 55.00% 55.00% 55.00% Franchise and In lieu of tax 5.50% 5.50% 5.50% Page 1 of 1 I 50* 00 38 == 2% 0880*2 25@al am 0-f Cl 0 0 - 00.24188 32 08802- 332 52 CO_<1 0-~ E 9 -1= , 06 N m - to If) 1 0 0092 @M u. 05&50*g 3, Wal W 3.2 3. 0% gm m# 4% 822%21 8 -0.00. p 321 --cv ; CS 5 4 - 0 *Â§*.2 EM 21:822Eg 2-tz-CD-%18 RIN lo-CD- ~-QI- 4 C\1 th N C\1 *0 4*98 20 2*2225!* CO. cy cole- 9 99 -con=- M N - "IN 00 cd Q W -- %5% 88512 /41"1; eg mEE@ENE 22* 512*e 4 M 9-2-geigi- 2- 0 9 Z = 3*253&12 r LO CD CO (DI C\1 al Cy C ES e5 MIN-N- rid R 5/ ME-jR R A - co ulu-100-00- 0 82*ENN 1 m h O LO O - 405**00. 2 YN CO. M MWE co CO m CD O E 23*gm@ gy 32@828@123 A-*Crth.Lfloc- 0.2 00 0 0 0 cy co O 633 El mencymm ~16 ci-N.~2-22-w-8 COCONÂ© 0310 w M dd $ m % NOCD A 10 Lf)' CD :3 32 &19 8 58 8 2 0 3 6Â©Nui :4 22 88 2 2 2 9310 1%2 Â®QhhÂ°0Â°0 coco *98W. y r -4141 CO 99 O h =11 N O * M O N 4- 00 22 ~08*085 m. 04.-1 h C! Ul (C! 41 CN- <C! m Amils :321 EeeMmm 01 1 00 e W b- W I. = 0- CO M' cr E # f *E~ 2 @ p.38 .50-0 1 .N 19 lo Ir CO 0 li .- U) 5 2 :*.g 2 2 1 =20 -2 2 i 1 Â£ E E 2 2 4 E 8 Â·E g S S 21 & 01- aa-0-OU-101- liaj= 5,OZb,XRZE Electric Sales 7,229,1~6 2,813,6 6~'* 15~4: 1,711,4~ 7,290 1, 6,825 22 E; 1 r Income 47,~ 257 2,966,7~ 735,742 165,539 1,790,563 23,415 25 12,72 rchased Demand 2, 68,586 65,067 440,486 1,731 49,663 tial Gen. Service Small Comm. Gen. Service Large Comm. urchased Energy 1,746,425 33,755 ~2 3~1 *N 1,885 estcos2001.xls Allocation dNWEI 1 of 9 8Ze'064' L tter 31,2001 0.~% 1~1.~0% ~~' 9 1 ~~';90'ez TOWN OF ES E P EXPENSES ALLOCAT sll!8 Jo jequlnNcill 12/11/2002 Revenues: 8'z90'88 g Demand KW estcos2001.xls ClassExp 12/11/2002 TOWN OF ESTES PARK Classification of Operating Expenses Test Year ended December 31, 2001 Adjusted Classification Expeoses Earameler Demand E~gy Cusigme[ ~ind.Evwer Expense Purchased Power (3) Demand 2,068,586 Direct 2,068,586 0 0 0 ~nd Power 1,746,425 Direct Q 1,746,425 0 0 11.1.Z2 Q Q Q 11,172 Subtotal 3,826,183 2,068,586 1,746,425 0 11,172 Distribution O&M Salaries 728,897 DP 472,735 0 256,162 Payroll taxes 54,566 DP 35,389 0 19,177 Employee pensions and benefits 133,616 DP 86,658 0 46,958 Maintenance and repair 196,190 DP 127,241 0 68,949 Supplies 29,909 DP 19,398 0 10,511 Insurance 26,990 DP 17,505 0 9,485 Rent 2,200 DP 1,427 0 773 Other - DP 212 Q 2.211 Subtotal 1,180,709 765,763 0 414,946 Customer Accounting Salaries 409,944 Cust. 0 0 409,944 Payroll taxes 33,261 Cust. 0 0 33,261 Employee pensions and benefits 90,254 Cust. 0 0 90,254 Maintenance and supplies 86,269 Cust. 0 0 86,269 Uncollectibel accounts 5,217 Cum. 0 0 5,217 Insurance 6,952 Cust. 0 0 6,952 Other 4.239 Cust. Q Q 1232 Subtotal 636.2 Q Q 636.1-aa Total Distribution & Customer 1,816,845 765,763 0 1,051,082 Percent Distribution & Customer(TD&C) 100.00% 42.15% 0.00% 57.85% Amin. & Gen. Salaries 241,048 TD&C 101,597 0 139,451 Payroll and Other Taxes 17,942 TD&C 7,562 0 10,380 Office Supplies 209,939 TD&C 88,485 0 121,454 Outside Services 32,357 TD&C 13,638 0 18,719 Insurance 12,775 TP 8,341 0 4,434 Employee Benefits & Pensions 44,395 TD&C 18,712 0 25,683 Other 212.33& TP 1&3.212 Q ZL121 Subtotal 777,790 381,548 0 396,242 Total Operating Expenses 6,420,818 3,215,897 1,746,425 1,447,324 11,172 Percent Operating Expenses(TOE) 100.00% 50.17% 27.25% 22.58% Capital Improvements From Current Revenues 770,292 TP 502,957 0 267,335 Transfer to Gen. Fund 773,305 TOE 387,989 210,701 174,615 Franchise Fee & In Lieu of Tax 246,237 TOE 123,544 67,092 55,601 Interest on Customer Deposit 8.862 TOE 14&6 2.tla 221 Subtotal 1,798,696 1,018,936 280,207 499,553 Debt Service 303,400 Total Plant 198,103 0 105,297 Total Cost of Service 8,522,914 4,432,936 2,026,632 2,052,174 11,172 Allocation Factors Distribution Plant (DP) 64.86% 0.00% 35.14% Total Plant (TP) 65.29% 0.00% 34.71% 2 of 9 es:cos2001.xls Plant 12/11/2002 TOWN OF ESTES PARK CLASSIFICATION OF ELECTRIC PLANT IN SERVICE AT ORIGINAL COST YEAR ENDED DECEMBER 31, 2001 Separation Balance as of 12/31/01 Parameter Per Adjusted Backs &*siments Elaoi Demand Customer Hydraulic Production Land and Land Rights 2,036 0 2,036 2,036 0 Demand Structure and Improvements 16014 Q IEQll& 1.6Q.3/A Q Demand Subtotal 162,350 0 162,350 162,350 0 Transmission Poles and Fixtures 0 0 0 0 0 Demand Overhead Conductors/Devices 0 0 0 0 0 Demand Underground Conductors Q Q Q Q Q Demand Subtotal 0 0 0 0 0 Distribution Plant Land and Land Rights 225,452 0 225,452 225,452 0 Demand Structures and Improvements 805,171 0 805,171 805,171 0 Demand Station Equipment 3,093,944 0 3,093,944 3,093,944 0 Demand Poles, Towers, Fixtures 1,468,348 0 1,468,348 881,009 587,339 60%D/40%C Overhead Conductors/Devices 1,271,183 0 1,271,183 762,710 508,473 60%D/40%C Underground Conduit 2,167 0 2,167 1,300 867 60%D/40%C Underground Conductors 2,202,780 0 2,202,780 1,321,668 881,112 60%D/40%C Line Transformers 1,469,272 0 1,469,272 881,563 587,709 60%D/40%C Services 469,103 0 469,103 0 469,103 Customer Meters 1,116,988 0 1,116,988 0 1,116,988 Customer Installation Cust. Premises 1,365 0 1,365 683 683 50D/50C Street Lights 13&916 Q Z3~Â£~8 362-158 367.458 50D/50C Subtotal 12,860,689 0 12,860,689 8,340,958 4,519,732 Distribution Plant Allocator %(DP) 100.00% 64.86% 35.14% Dist. Plant Delivery %(DPD) 100.00% Total Above Plant $ 13,023,039 0 13,023,039 8,503,308 4,519,732 Above Plant Allocator % (PA) 100.00% 65.29% 34.71% General Plant Structure and Improvements 108,248 0 108,248 70,680 37,568 PA Office Furniture 207,285 0 207,285 135,345 71,940 PA Computer 586,551 0 586,551 382,985 203,566 PA Transportation Equipment 845,763 0 845,763 552,235 293,528 PA Stores Equipment 18,021 0 18,021 11,767 6,254 PA Tools and Shop Equipment 146,614 0 146,614 95,731 50,883 PA Laboratory Equipment 140,907 0 140,907 92,004 48,903 PA Power Operated Equipment 5,639 0 5,639 3,682 1,957 PA Communication Equipment 1HZ.Zal Q 19Z.Z61 129.12Z &8.63& PA Subtotal 2,25iZ89 O 2258189 1,413.556 ZB1233 Total Electric Plant 15,279,828 0 15,279,828 9,976,863 5,302,965 Total Electric Plant Alloc. %(TP) 100.00% 65.29% 34.71% 3 of 9 001 01 (DOO,-00010(00) CO col O) O 22,~ r-Â©CONOLDIOLD (9 (\1 LO -1 4- co â€¢-ACO"Nâ€¢-1. 9(9-11(D-CN- mgo (9-4 E- 4- r.-Ncor 0 03 r- â€¢r- * o cD Er 0 0 h 00 CD - 00 O O N T- W O e 9 9 th r *CRC\!00 ,- Â·r- 7-coÂ®r-CVTLC~A~Cooo,-uid 00 - - IL *&8 1%5939 (\1 o CO N 00 00 000091-OCU Â§ N co Qui 00 LA- d v. 00 Al 1- 1.-Cor 0 J 0 11 co CO o co al 00 0 Lo al 4- 4- o co cni c\1 h 9- C) O w CO 9- h C) O) 00 2 e W 0 C) 00 0 CD Â·r- 10 E.2 1:LO -2 J z2 00 (D - h 1- C\1 10 (DO O Â·r- 0 1 00 10 CO 00 N 09 00 C\1 mENEGE Cqqc\Ir CDC)CDC)r- OLD Â£ E &1 00 . Ci W N 2 CS E 2 a 2 8 * 8 = 11 00(DEJE 5 5< '-tzEE#BE -c=vE ES.@S-mfi~~33 2 2 d i} Â·3 8 CL [1- 0- CL ~ - -a E m E PE E Ezzz x 0 (DEN * 11Â·-666-9 or(SU)(9-16036(rorcr CO Weighting Factors Non Coin. Number Demand/ We~~ing Weighted Assigned estcos2001.xls WBills Residentia 20.92 6 Jo * Test Year E Dec ber 1,2001 TOWN OF ESTES PARK ~'ZE mol Weighted 90,342 Residential-Demand sll!8 dNIAIH ssel lejol 12/11/2002 Residential dentia F~9MeNApdrnin 82 ~9282*98212*0 e. 0 w oo w ;11@39 2 In 4 6 8&-29Â°Â°2 -22RME N{900 Cv d 001 -4 -8~Â°Â°R-ESResNNEB - ci- Ci - h 9- 00 10 00 h 1- 10 C) CD CO O N (01 N 9- O) co O - h 10 - 0 - N 1- 0 2 -1 --1 -1 9 O . e 68-88002-ES@M CINW&118 3 9 4- r 0 0 e e 8%-E Â°Â°R-ES?COCENWEE 11* r 00 CD C; af 63%- 884%~ "CkS Scot: NÂ¤ 4 NY ge-E 002- &18:$ et:NWWN 4 1- r 00 CD 06 Of 3% 3!2-81Â°Â°12-Et[3*CO~NMEE f 2 N 0 4 - CO 01 01 I m J (6 4 00 co < 11 0 0-0* 10 1 " 91- - 0000 9- 10 1.0 roe h NNCU LO twLLI Â£ O 0 0 0 h 1.0 - 0 - â„¢3-g. m(00 0 9 0.4- - r ILL149 - 0 - 00 00 M253-y z 5 -0 02-0202-EXi>JetzNNgs *Im â‚¬ 0 * r 01 01 0 t - 031 00 00 1-8Â® 2 $ *3.--E ~R-:83205:NMEA 1- N e e w 0 0 g 22-E %~p&Z~MCENÂ¤~% <04- - 01 00. cd co 00 D 58:8 0 @fil 0 0 g Il = 4 -0 0 J 00.9 .*t b &3<<a- @E@33Â§0Â§1EE#&3 E Â·uj Â·u, :~~~~~~-~ %&&& (1)(DC)(DEC)@31Â·66=J 02Drormecoc5~sz*croncr -(4(9004-031ONÂ© 63;gl 6,:2 6, 1,389 1,391 1,3 1,401 1,3 1,404 1,4 .Total less RMNP Bills %86 9,12 10 estcos2001.xls #Bills 6J09 86Je leMOd pile 146!1 >Ped selsEI Xq pap!Aold meg) Builliq Wold (I) ident Demand Customer Class ident Sutotal RMN B101 12/11/2002 9310N1003 2,0Â£ o 3200 O 91- UD go 8%32 gr323 - N Ei e 2 8 2:ggy 08032 3 32AE *220 M E *82 022 Â¢9Â»7- 8-- $ R Fgat Â£:21?E 9 8 2 *492 O m 28 nhA 2*32 M 6 1 g 09*6 0 8 0 2 ca 3* 0 8%232 2*832 LL~v 10<DAD! 00.- $/ IM %6 6 *LnÂ£6 &2 e 0*0% 9 CO N = 001 0 a: ~ $902 *Ego 032.01010* 28 2222% *EME%v 01 U) O 0 e %-2 2 8 S e.'E M I 0242 2, v oÂ·; w 2%8-0 O CO {10 - Â®%543 @ N 0 S g LL < Â·- Â£01&4/2/ H.. f#<Ja-OLLI<O Z - C\1 CÂ¥) 112,7 37,634 40,408,7 1 23,067,321 150,157 30,36 120,180 2,76 43,860 1,38 ,1 t ind Allocator % 1 41.~2 h 11.~% 2.38 0.10% 0.08% 2.4 0.03% 0.00% tial Gen. Service Small Comm. Gen. Service Large Comm. Outdoor COINCIDENT DE A A OCATOR BY RATE CLASS KW-Months (1) 428,500 181,0 381 34.98% 53.96~ 52.01 5 .00% 55.00% 2001 Exhibit 2 Coin KW TOWN O ESTE 6 Jog 24,480 21 From an approximation of a Bary type coincidence factor curve. estcos2001.xls 12/11/2002 Rate Class Z 85ed ul 't eBed u.103 3 usted Est. Lf)00OOKA O 0 h Coolcole- r 2 3533 Wwn BEE MleÂ°EBME "2 * # E M M 0 R Â§ . aw Wri V-1 Cul r -- . m#822*822% A-EMNRE &48:38*-- 03 C) O C~1 CN 0 - CD 10 N. - 9 .9 .9 4-2- -29*&@ 2=0Â§ NE 829& *g# C\'91*&14% 0 CD UD 0 CD g 63 a) â€¢- 1% CO N -1 h U. O e e Cul 00 * CD O 1 0 0 0 00 01001<0 00 *R &203 422 *20131:8~R REW ZE:19=&1200)62%'EM K M 0.0 -W 4- CO rt - CO 0-31 LOI CD O A2 3 N g m - 1 '0101.- - Or =3 ke N -1 CM. n Z C) C) g %5 2 9 - c, oo o Sm_mass-559Â°35"'52 4208*am**205*M@*N 2=gem 99- d Â© 6 6 %M%%*M%iiRÂ°W%EM%i .%32**WR.,70,09% 22% m 00 to - h CO N O CD C) 91Â· cul Lf) 01 col CY) C) 1/ / a> h hal CD--r-O . " N.Lo -t q ov 141('IR,2. co CO 01 CO O C> 3 * 2 o E M 8*BBEAS#*4Â°EE@MES 193*28*BER5!0000Â§1*~~ 22= 2 : M. 01 e 09. o (D - CÂ°Â°'&83@. -23@2% I CU' f co h 09 CO CU co co < -a"*MORM.EMME $*RmÂ®R O--O .- =203*ZE::5900 60 919 2=~~a 3 Â§15-/ge ~00 Cy**MNE -AWN- 00 A 9% 0. 00 00 Ki E:89280:88@2$9 E%9Ei3mEE*2o2*M3@5 le& 3992*= 4 2 - ER; - cooothcv : U, M Co (D :8 8 0 1. Cl h N N. h -I N N C> C) r-*04Â·â„¢004Â·OCD.004Â· el my=%-22=E00=52332 32*%9 CocyCVNM-*00-35 =t Lo ./1- Cy co n-<DIN ~rt ~ - 33"055 9*N &5&03 niwo,CO R ~ 05 W <D h h N * Cy 9 4 M< a 4 4 h h ~M@*RE 859Â°ECWINgs] 52012@00Â®058~lUn@Â§ 00=m@69 04 4.41001Ncy. Ul 4 0 co org " N Cul N N 00 0 CO 91 0 - Cul 01001* - OR#**32 8.9.4 9-4 =mwi: 0 8-0 RE@Nogg /43* 9% Enm iw-g-*ge-&08, wramigig - Ul n W M.09 - 3 2.- v . - C- 0, Ci ER-6 3%00 2%3191% R 93-262-*a %.=*NogmMN 2-39*&1~ .2-6151(58 .5.0 -N (0 4 It O! N .1 =O 2 - Cd 00 RE.Amgogge;1851! *92&*mt:NE"Â°Â°fiemats 82*88 428 M w. 0 41 m oo n q 41 (01 01 u. CQC,- C~Cq lf- m CyNLOIQIC- 3-NNNSA M 4 do--(0004 'ON C. to -co CD .- 4 W Estâ„¢88. R WAERR 4 23Â¤333 al N CO C\1 -- u) U A>> Ill A 2EE 2-1-= 565 E25 2.~ O EC-#EP O 0 b 8%222'Jf ge:*121% ~ &.5 m 0 0) mEÂ®EEE gg&Â£Mg.J*NE @m 22*i%2~3#2~1*2% E f; N0 2 53%22Â·88Â£ZZ/l -EÂ·@ Eg E.E. E___~ 202%6:0 0 crcr@ Inecoe 75 0% m[[[Ecol-,E < fmmm(. co ejao*Bmmcot-,- Li- LU U. 111 U.1 LU LU -CNIC')00=1-C,LONCDO c> 1 E - C\1 03 CO ry C> LO h CD .- 91Â· LO r N CD rt to O h C> e w Or- 00 4- - J T- / cn O " H 32 _ N N W O. N OC> - D co 4- CO Cul Al Lo Cul N 0 CO 01 . d 0 0 4 2 -O 0- S S 0 @E~98-38 0 811- l E Z Exhibit 2 kWh&KW ,794 2,2 15 6161 1 3 181,043 980'29 2~'6Z 860'09 ,~9 8 k0'9 6t6'9 009'88* 90 Lot'68 t ?%,7: Total Demand NES= 1 11,880 260 410,3 468,78 2,07 2,853,12 2,8 2,020, 26 2,556,59 2, 00 '92 ~7â‚¬Z 0~0â‚¬ Â°/092~9t Â°/~t6 Z I ~â‚¬ 1!99 J:l?82 r %916Â£ Joted Peol puellieO lenuepiseh' 601 :51% 't ' 9Â£8'88 ESTIMATED~- LY ENERGY D DEMAND 1,425 454,216 39 44,210 ESTES PA Test Year En d December esidential ,507 3,893,009 3 394 00 3 sidential emand ,386,896 1,159,340 1 rk Light and Power Department Â·Xmeue Need uo 6umn J 010 peol xlqluow %O, e Buiwnssse pel 31 0, X.1 19!4 pUBLUep Ul SU/Aol- dle Kwh (i ) ential ( 6u! nSSE pelelll mated assu in mated assu in dep Me@AA JO JeqUinN estcos2001.xls 12/11/2002 1 1 SinoH Mead to Str,OH RS!2!52EWÂ£ 0 C).LO. n LO-(D. 3 * =2 81== r- g OLD h 00. 00. 0 r- CO (9 $8%25 ~ Ng h 00 1.00 1 10 0 66 2 08- -- ti 26- 24 0 r m m 0-0 C) STDims*3 41(0.1~N (CL.Ita) gl Eeg Z cD - O (IIi 22* N 00 0 N xiÂ· 0 Rm* 4 00 03 0 N r- r- fl- N CNI 3,58% A- gg292Â»0 < 1.0 CO N Lt) N xi- 00 00 0) - O 5 232 0. r O 00- CO- J I- I- 1.0 32 2 2 ON C) r ID ~~28- E GIg A: 41 20. 9 0 m o Â© 00 Lo LO O m CD h Ul c Â£,Af % 0 cogo EN -7 1 10-0 21% 9 8 E E N - Â° CN 0 00 u. (D C) N h O) 4- 4 Ct 2 N 10 05 Lo- N- m CON(9(0 & r- CNI %%%5 8 5 ~~9 3% 6 (98&322081 832 2 h N. -coe-Â©CON 122~ 4- d m 03 r- cÂ¥) an 3 kEW!*gic~E:2 01 "- CV r--r- CO cON CD %*03 - ggE 2 ct,- co CO 0-0 4 e (D 0 0 O)03100000â€¢-c)(NCO N > 1 10 4 Rkn (9 0 N O r -00 4- CDC) O 2 600 CD 00 - N N O 4- r- DI O C CDr-N El w w Â«c) U) 10- cd 4 05 00- g e 0 1--00 col " " R#%Wk k*d E- & r- V- C\1 " I- r. .. -0 (D CD - m - yE Cl ul <W 0 -c-~005@Oe ** QSQ 222Â®ES@-C-82 ~ 2 i R- ti .. 22@16020% J < E &3 c I- r- (10 r 0 0 O 1- C E gl.=E PE= -92 -* dJE~~J* -2 ~ -* .* 33 0_ 4, c 1- 2 e O LU S J 0- red KW 19,876 1~,9~ 1~ ~ 1*263 269 16,935 16,785 19,665 20,990 215,025 19,819 662 15,532 12*: 19,665 19,558 194,416 205 07 210,874 189 22 167 03 131,521 156,004 165,260 1 1 209,236 208,097 2,068,586 58 10,016,1 45 10,3 ,72 8,839,590 8,81 8,758,210 9,651,80 9,353 8,6 1,076 9,220,513 9,827,033 11,917,736 116,928,374 34,420 24,11 16 58,885 31,770 59,487 465,500 *89'Â£88'â‚¬- 8,777,933 8, 8,723,790 9,627,688 9,337,26 8,648,999 9,161,628 9,795,263 11,858,249 116,462,874 9,5402~~~~ 7,~~~~ 9 ,616 8,832,677 8,529,3 9,639,494 6,888, 28 111,353,4 001/EWEIÂ· 1001/2/14 ZOOZ/Z/0 X ZOOZ/W6 ZOOZ/9/8 OOZ/oEM 100082/9 Z 01/* t/9 ZOOZ/010/* ZOOZ/*Idâ‚¬ ZOOZ/8/Z 131,373 14 77 130,066 138,308 147 287,377 31 270,982 264,966 356 530 1,413 358 799 00 81. 00:91. 00:61. 0061Â· 00:6 300,111 264,28 271,154 265,5 March A q t Sept. erage /kW 0.02813 0.03 Test Year Fnde .2001 Exhibit 2 PRPA TOWN OF ESTES PARK 8 of 9 PRPA PURCHASED Dollars estcos2001.xls 12/11/2002 'EE KNER 2%5**EFEERR @~FEA@B@ i.@@@**** Ed-3- *-3. (\1 e M W - Â°'-31*9 9-**2Â¥Â§~ %93 9-Muing# Lo * IfD Lo 0 4 Bi FNR- 2@Digl:8*381%WS 00 4- N N 0 m 0 0 00 m CNI O r- 0 0 0 --0). q N- ct. cl (D h Â¤) 41 0Q cl. n 'h 289*kNQNQN"M"%*R #6 Ce//UDENRI . 285&~N 4 4 6; 00 â€¢- 00 NN cv Â®â€¢- NG)NN N N / r . 0 - 1 N Â· CN to Al h CNI Al 03 to O C> C. .-CONCIAO 2%4 - - 1 4 - N 632&3%~@220**Ei,Â§00Â° 0%&9%200*FE*RE*Q 9-Â§081#A-2<Â°-5--~---id***g 38##Med*444*49388 co.. <D -h O - (m - - 00 0) M O CD_ 9- 0 . â€ž - h H.. N N NE **s@ 0Â§2* NEE*%95Â°Â°Â° *02%*SNERNREE@ 339 Â®~-40*09-*U,~ M *~iNRE ME*50%@02&1"ggs-#19 e. N W 00 r =t J m m 344@REREE&%2BSEM*Â°Â°Â°0M0TAL.qrgh)Â®retâ„¢ Eâ„¢PjÂ©D!*882Rk*5~92 ~0 5â„¢~E AE-* M 5-5:q-Ng Ng*Egg*3*2- 5%3 82 59 Â«N .5 / 0 N ..1 <q m + 29 -- 2* 32***88?233 8:*g O tr) LD. 1 LO LON N r N Clncl. 41 n 5%5*Egm#EARRRE-*-5 tri CO N N O Chi UD M OD - CN h f (9 Al .â„¢.33 r Â·. 0, -- O 2 8 3 90 3.MÂ© N AE&0202*38*EXES!2% %**~EM@*9*0~ Â£963%Â§ 03.40-0.(DC,MN-A (0-00000 - r-- c4 ~â‚¬ co- tri 92-*REM--Cd-m Â¢4,0-Nco-cy-N C) 0 > 10 LCD - (4 > 0 Z 2 %R% loh'0 4.-(D 33222 *mgogmang#gg EN#Emil@393*Â§*03 0 h 5 9 1 10 - W O CON-KIC) m 09 4- r o CD m 5 9- 0 05*%5*-% RE EAWN 29% 5~9EgEE**50-%Â§%Â§* 11*.N.gh CO Â© CNI 9- r- M M C) 4- CD h./00 - 1242*6Â§ 44 2 co - 3; 06!*Â§155*ESE.*13%0% - (9 1 00. h V - 1 - 4 - m (9 - 1. n at- 00)0(900-00-eou)(90000 0 10 - 0 - 00 4- CD 4- O ID Y - N N CO ,-6 4-5 44(,TER 804825% 91. 44 IONO -- LO to 2 (910-CD- 2~~228â„¢m-~28 3 - % 0 00 00 0 0 00 03 - - m * 0 0 NO) r- - 0 10 10.M-h |O hÂ©REet Eg:82*8*22Â®88622& - A X --â€ž- --REE _ co- 4- M Mit- 4 câ‚¬ 4 tri o N' ev 91 0 - 1- e -- R O% 45-59 tr)-cinnh'Â£1 h 0 - - CNI 1- O 01 N - m Lo co . 0 - 228*02*9 00 10 1 . cO CD 00 co M Â© 01 to Lo 0 00 0 00 ALOACOLO 00000(44Â·Â©00 -2 02 -(44-Noo -0 0%22-R-976-Â¢44 *10-4-AN-Cd CD >4 CD CD 5 - *RM 0-5-5 3-14 51 *2 616; 50 ri m m 25 EFER&**MEARRRE*F NO "-00 0 N ......Igig :505*mEW.N M*NICâ€¢-~M r-CD r- - - 1 91 0 - c) CO LO C) ,- 10 m c> to Lo O moo Lo A 32.WERE E-~SA~35?91912Â©! 9965ME@@EE56-31@5 coo 00 0- M-N-40-0- -fi~-gg-0,*MA-M- elf)*Or-N Egh r-ce 01 - r - CD CD . ' 01 Cl 2 < *Re"REEN@ir E# FRAE (D. h.:00.10 M C~ a) w N a) 10 0 10.4-a. 2291 932288*82&892 52 3 5 C.cy.Ng .=3@*92}gitb=W- N-,0-040â€žâ€ž 7 - p 10 '0 0 '. 01 56 5 5 C} MM N C) r~*~2:ENEZR4W .Nul 1 -â‚¬4.1.oc!.Qâ‚¬N rEE Ta Mi @ E EE Â§*EME*E@* â„¢nt/AN- .cit- Midedâ„¢aiN- cdo-4.-N- 33 . P e - If) = " r- -0 01 .1- ./ 04 (D U. 2 *%Â§@MES*Emwg*053% b ~~-Ice..qa,catooq-_co.*.1. q <ecy * 49282&08&68@ - NAÂ«g# 2 +M-44*QB,04- 1 O r LO CNI " (NI c>_CN-(90,Â·Ar .- - - ca - 00 N C C .'â€ž 1 W -9 1 gt ali : 8 3 2 -.9.9 Q 2*22 23 Ek oo28,8 3@4 2 & 0001-81- 2 (<<a- Z c 2222 22 22 "/1/11/1112{ 1 i %_ 3~Jjaijam' @3~EBi -#2 EN***m~~ i ~21:Z@EE333333 *-R w Winter/Summer Residential (2) 34,169 203,355 196,048 228,736 175,565 231,54 D~60,618 Wi~1 , 7 ~umT,er Total Total Residential Demand (3) 31,18 35 38,01 163,7 15 17 122,703 1 Revenues Rate Class May june July Augu t Sept Oct 6J06 (3) 144,0 12 142,98 15 93 1 1 Calendar year 2001 01 col 00 0 Al UDI 3 00 3 Ce U.21 = / 0 NI O 4 Rn N 01 - % 7 8 E Lo 0 01 N <- N R 0- 0 10 col 00 N 52 LUS A- 2 A Zd - 5= i= - r-hoo e m 0 0 1 - 10 $ -do 09 ~ @Ml deSS E 00 13 R@% WEES 3 6 6.33 - 3 0 %@ 2 3 Mt- 23 ./ 92M 446 6256% e 1- 4 0 2*28 9 5 ~ in W 00 N 9000 A %35 1.511. ~ R- 4- u O p e O d 0 09 CO LO CD o 2561<02 9 2 9! 9! m e.(9.M-2 &~] 2 2 /8 3 â‚¬ a 8 2 . 8288 6 32 dd ,- 9- CO Z R G 00 2@671* gm 0 M EME w 99%9 (0 4. a| rui n 0 0 91- n o a) 00 n! d CD Q , C) O CO Lri H 0 C) Of 40 00 4-25)1* 4.9 â„¢ 0 8== n Er x11 4-00 1 300 .r- p 08108 O h h ACONT 4~* 5 O 0 0 3 00 1- 1.0 0) r* to 3288 0-9.2 C\1 0 0 N - CD 6529 9 W 05 N- 09- h N. cd Z GIAN 0 8 1.0 r O 4 0 co 0 0 &(DCOZ Z 0 N Z 0 Oq 00- AC\110 00 41 c\1 US Cd -- 0 1.0 â€¢-1 CD c49 N COO 0 00 .l R tb 1 1-86 W g 05 06' 4 i :di 3 65 ro h 4. -O FE 4 6 M 0 C) C> CO toi W h to 4-CNI N CN 1 W A 0 i f 96 9% EE 6 6 0-0- 2 - vE 0-0-c= 20.0 2 5 E- A **NE 6,02(=00 c * O - 25 62 A 2 0 M ...E E .5- M .f 0 02 0 0 $ 5 0 033 1 gE~=-*E 33_02*2 *2_ 20~*-s E v ~ 35 E 3~2Â·QggE'n*%=anEQ-dit*NEE@ 0-&ig#*33 gee)=EEE@@EE ~~022**RE:~zco~~~2~8:z:*~s*GS*~So~oj~:*:~12 521%%*c:gk**21 28,690,198 8,318,941 15,033,878 1,967,~75 34,850 546,520 986' L 98 L'BE LEO'E Z60'09 L6t, L0'0 899800 92*ZO'O 9LE90'0 69620'0 36890'0 980â‚¬00 69â‚¬90 0 EL-t, 92'6 9 LZ 0724 0.111 0621 ~~177 156,447 1,619,934 22,301 24,378 osed Percent 0.21099 0.0842 0.0842 8,033,443 11,107 93.9 HZ 00Â£ 00'E 00 8 em sidential Residential Gen. Service Small Comm. Gen. Service Large Comm. Outdoor 112,737,634 765 10,743,628 23,067,321 120,180 43,860 45,957 69680'0 ***800 9910 930 0 696800 0.0900 0.0412 ,987,383 1,9 1,060,217 m e o Bills 80,820 8 16,809 Not Metered Not Metered Not M tered Metered Not 1,016,357 9920 0 8,318,941 424,687 7 5 86 E 296'ZE BLE'Lt, 6Z8'8L 905,510 422,051 146,184 Z60'09 905851 3,842,687 Calculation of Proposed 2003 and 2004 Rates Total Book Revenues: >lead IJO Jaulu.Ins TowA of Estes Park ummer 1001/k L/Z tsewileOSIX' kleoejeilse m W o 0 p h 4 (9 M A cd y cO R y .IN CO. N N - m 6 3 e 2 2 M N bu. h N e 0 N -80 2 d K CD 0 32 . N :g 01 - Lri r E C. IrS O 5 10 (Nli 8 2% <R. 6 0 0 LO 0 M 9 dll a a) (5 1000000)032 . 10 '-00 O)00000Â»0 00 0 0 1 - E M. Rgg H r O 0 co * 4. 0 6 2 0 1 E M g g 8 hui d d (N-ui CD 000 000 E CO 22~ 8 E 10 00 22 N to h N.- 2- KE 3 N 00 4 013 0 0 8 N Ul 0 5 - CD Â»2608086*E - 0 NOO 28Â°808â„¢55 4 0 ocyt- _ (N.,4 do 4 2 @88 : 6 g 0 9 C! 000 4- Â»CONy 8 h N CO LO T-,-10 0 3 2 2 :4 ID h r.-01<r< 0 0 000 0 0# y CD AN N. 00 0 iD -25 a 33 ..44 m 1 == 33 *- 26 fZSZ E 2 0 22 2 Z 2 2 & m U) CD 0, 0 Oil (10 U) 52 C* 00 0*00 @c~=~c 0-UONâ€¢- O-c~-cE-(,- 0200-@33 Ook EE@SEE Â®*g (32% 2,>,@ SEEEPAN,g ;%%%2% &~2%%% @5% m= 2 ~60&13&*20.ER@20 Â§ 5~ :2 5 â‚¬2ZZEE.~NEâ‚¬E =393*2 02**cou) ag~ za,a> me o DE C\10 0 OCI h. lo co 0 to 0, co r- 0) CD - 7 13 4 0 E m C 0 9.52 10.71 4.19 7,241,214 2,812,053 688,727 155,55 1,711,665 7,290 1,638,998 6,814 171,778 1,019 1,245 22,356 23,713 5.67 2.32 2.71 3.81 3.16 099'91 8ZZ'Â£1 9Â£Â£' L 911' L Lk"ZAL 909'9024 ' 991. 921/992 869'9L0'Â£ 229'989'Z 9DNLOO 98ZeÂ£00 9 LLOZO'O RZOZZOO Stz'LE 8â‚¬EkE ZE*' L Zzt'' ~ 992'â‚¬6K 89Â£'Z Loo'ZZL' L ZBZ'998' L 00'Zej 98'192 L98'EEZ'â‚¬ 681'920'8 :sawl=1 pesodcud SenueAe Proposed Rates: 7,686,677 3,015,5 1 765,17 1,782,2 1,706,60 7,095 182,44 1,226 1 23,278 3.96 Residential Resi RMNP t6 Z EL-* EL-E 91/9 9 4MM/sweo Percent Increase 6.15% 20.42% 7. 4% L-80180-0 199Â£0 86*920 0 ZE99Â£ LL.LL /66 593,871 mer Season 171,304 0*' *8 L 96'229 Proposed Schedule: (Rates shown in bold) Meed 9 Jel,Ul,Un Summer Cents/kW Â£3* ..K cd LO O 1 \2 CD (9 o c, ro w. ~I ~ ~ 38 E $ CO <D LD CD 00 0 LO 2 Ui 4; e g CO #0 4- CO l.0 91Â· CO t e w H 08600 CO Â°Â° 4- G (R co *8~RÂ£22 6 8 *9 9 do*K doco cRl g m - h d 99 42 r- ~%*E 5% cd CU to Ogtheng cO O 0 o e CM (\1 CO 10 C\| N f -0 Noc,34,3,< N 4 g as 1.0 Wd M g CO d O 00 0 9 (9 EFF 091-0 5 49Â£$% 862 e E N K log h * u) co 05 d cv g cy LO" 1 00) LO 7- i C\' CD LO (9 0) 32 (D tO 00000(\IT- COOLDEf - O~ H a Lr) r . O CU (D H LO N Ngnir** 91-1.0)0)1~ 26Â£0 3*g 00 K 224 8 8Â£38 too 911 0 10 0 ID (9 3200 N O 1 0 0 09 0 ->2 r If) 10 9- -10000)-00) O X 2 dd SWdeNd ow 92@2% 10 06 0)0(009 'Â·00Â®003200- ~Ki~~~ O32# 9 1 9 <22:285 CD CDC\1 -too e 9- w 2 cri cs W d d 3Â§Â§0*N Sdc\'Ac'i@84 -0000 1- 911 4- 6 Â·r- LO 0 0 CD y 1 0 LO LO 00 2 32 51 2 U) 10 â€¢r- 0 91- 0 0 10 00 0 00 0 000(0 C\! 0 - C) O-00<R<Â£too.. 00 03 -â€ž w<C>-N*K C> co N d LowNÂ©0*~OCOCi COO LO O ID 0 0 m CO - h LO C) C) 0000 N co O 5 N 9 5 LO 0 0 (U ... - LO 000 m le d 20 333 e v fe .c v -2 t o- 0- 66 "Hit 2%& 22Â£ c=*15@3 0: E-act- 0 0 . (D 2 & 0 642 C el[3 8 -3 & 1-G005 estcomp2603 kWh Minimum 150 500 2000 Current $ 12.54 22.08 34.80 41.15 66.59 98.39 130.18 137.25 2745 4380 3850 6405 10220 55.72 161.15 568.54 02201 098Â£ 088* 9*ZE 1 099 48.994 ZE 698 Z0Z6 L 899t k 8809 89'68 86'989 19.L92 88'963 681.8 1 96'99 '91 Lt $ pesodold 600Â£2 93. Lt 609 1 Â£0 8 59.23 167.69 598.67 000* 000* 009 009L 0*L 8'36 L D099 L 9 Z6 88/EE 930 L 88'L EL 9 69'9 90'4 ZLE e6ue40 Julio(J 4*.8 *99 ge.9 906 99.9 88.Z MM/slueo pesodoid 12.60 EVZZ L EZ'80 L 99.91 $ pesodoid %980 96* LGE L %99'62 %EL.9 e6ue40 lu 003, 098 %82.9 % L61 5629â‚¬ L e6ue40 lueoied Typical Bills Current and Proposed 2003 Rates 4.06% TOWN OF ESTES PARK Percent Change 33.33% 15.37 11.619 Proposed Cents/kW 10.77 Â· 1 LZ'9 , 9 15' L MM/slue 82.0 Proposed Cents/kWh Residential Demand Winter JeUJUIns puewea ie!luepisau estcompl.xls Residential Proposed $ Dollar Change aol le!luepise j m m CO LO N 0 038 3 E ~.Â®w *4 5FIESE3E LO W C\1 0 h H E 4 1- 00 Â· r (D e%5S 91-00 0 ,<00 WIN 85 - ~ Lfi 0> tri CU 0 *2#g*gg O C) g gcoK 0 LO 3 3 Â§ 1 UD *EMER* 100 0 2 09 00 &00 W..CD r rr (N q F24-00 00(90 W Lri O 00 4- be N v- 00000 0 0 00 1 0 0 O N 00 N 9#6 00Â§%300 26 (\1 A W. 00 h CO O LO â‚¬ - LO 01 0 0 REE 9 1 6 m r 1 10 N 1-N - (9 <0 CO O - 0 0 4--01 LOWC\Ice 00 91- co y r- CD E K 3 .2 0 2 .2 -0 -9 2 91 2 2 i li ~ 41 1i li 78 1 11 12 v, 71 (, J; = m ~6988% EO r t * 2 4 g. a -C 0- -c .c 2 2 2 28228Â£ ~%0228~28 estcomp2003 Minimum 1400 2000 5000 7.25 14.14 76.17 103.74 1 .09 351.85 7.25 79.23 367.16 500 1000 2000 2000 4000 4000 1600 28.57 32.24 49.89 57.23 107.21 207.17 ropose $ 30.80 53.35 112.67 1 217.09 /8.9 9*- L L 998 AAM/sjueo pesodold Typical Bills Current and Proposed 2003 Rates TOWN OF ESTES PARK 0.00 0.28 EZE 0.00% estcompl.xls Small Commercial 0 - 0 0 0 oQ g Ui 05 CD â€ž 00 0 m 0 00 h LO CD O 0 0 (0 32 - CD tO O 29 2222 ~2 0 9 8 Cl 2 O- 12 2-CD g 0 0 4 CD CO RSER *85 W 042 LO CON 1000 0 R g & 92 1% O .. hco 00 1< 4 32 (\I c\1 2 0 ID CO O O 5822 Â»64 Â¢9 LO O CD O 1 0 0 LO 0 5Rk 9%18 4. CO g~EN: O 4 0 NRC) O E Â¢9 0> O 0 CO @ 0 3 d - d <D cy O d (Ci - 0 p Â® 0 0 0%832 0 = & 15 - .= c 16-Â¤O-c M U.1 LU E 1 E 20 --@2&3 9 -M & 0 h CO LO C) CD N O CD LO 0 0 â€ž co (D E el mi~~ aililiki i ELWn-28 - J C J (D J - = 3 0 92 2. 22 6;E m - R Â® E 8-SE %22 9 EC - a O L.1.1 U) O 06002 C m estcomp2003 pesodoJd luellno pesodoid lue].Ins luellno dold luenno pesodold lualin0 309900 9 LE90'0 L L80â‚¬0.0 69680'0 L86 LZO 0 26890'0 09Â£80-0 980â‚¬0'0 ZE99900 9890-0 led!0!unIN 'wwoo efle-1 'Ull.110011EWS pUBWea le!1Uepisel 10220 12775 15330 21900 27375 32850 730 87600 626.51 702.11 77.71 1,342.52 1, 1,666.53 3,580.0 4,012.07 4,444.08 736.81 5.53 1,398.76 1, 7.45 1,736.14 3,71 4,163.20 4,613.04 3.77% 62.92 151.13 1000 2000 5000 15.54 62.16 124.32 310.80 ropose 16.50 66.02 132.04 330.09 6.21% 6.21~ 6.21% 6.21% 19.29 09.9 MM/slues pesodoid Typical Bills Current and Proposed 2003 Rates 89990'0 EZZLBOO Â£980'0 990800 80.0 98100 99800 98800 99200 TOWN OF ESTES PARK 35 aol 18!wel.Ul.LIOO IleLUS aol le!luepiset:I pesodold lueijno pesodoid lue.uno 98'Z .lell.1019 Large Commercial estcompl.xls JeLUOW 6.8 1 ell.Illl g *Ek . e LO lo CO 91Â· 00 09 h CÂ¥) 1- I N ~ 1 0 10 100 0 10 LO O 4- O 0 cu co ~2 h O-0 0 %f .* OdE EN '180 CodD~~ 0 ' 0 u; grÂ· 1 06 CDC)005 * * &0)2(\! CON EX 5,5%5! - & 3 RETS .6Â£88 0000 Cul-00 06 N 00 N K d m g g! cri 10 - 06 N i (D h 22&3122 1 - O 0 M Â§ & 0 OR 00 SEE 10 CD h CD h 992* d d w cy 2 W = CD 1 0 0 9- C\1 0 tO Â© ID 0 00 00 000 0000 - 26 - O m e CO 10 46 m 00 00 d r- 0 CD Er 22 52322 3 PE:EEgE 091-00(9911\0 O - O 0 ,-4 0 0- S 16 %3*15 EN cri gor. 9 W Y O A : m p CU LO d 04-032 to O C) 00 8 CO 9- 10 00)0321~10 0 0 583202 10 LO oR (Dhah"h 206,-004<6 Sdavhwg~dN . 1 O tO tO 0 tO 10 ID O 1 0 0 4Â£ (D W. O co e . CD O 0 LO CO co cu cu 00 00 10 22 Â· U) LO 06 0 h 1.0 - â„¢ CO - r (98328 Lo o 1.0 0 N O CU 1 0 1 4. C) E ~ - in 4 u-506 10 5 - 00 m 00 h CD r= 1 N N 2.2 90 Â£ 2. M.F 2 0 0 0 0 evo.gv fe-For-Â¤ E 0-20= E 0- 0- fa-90 C) 0000 0. W co N h -1- CD 00 h O...00 C) 0 9- 0000000(\1 0 h LO CD 09- (D E E 3 -2 0 C 02 28 0 2 5 8 0 fe-= C a) a) fe .c m m m (D-na) O c=-w~ E 0 5 Z 0 E co c 0 0 E # Â®00 58@ /3 yig i -= 2 5 8 3 & -CO--C= 2 0-0 ** J 2 E-5 2 259*=2Â®E@ *END = 2 00 2100.0.00. a)66-6,00-0-00- 1 U 2 2 0 0- 0- O estcomp26O4 8.09 22.08 41.15 50.69 98.39 130.18 9.76 25.61 47.22 58.02 112.04 148.06 1.68 2.27 3.53 7.33 17.88 12.20 9.87 8.54 7.74 7.40 Minimum 300 75 1000 1500 33.33 20.71% 18.07 16.00% 15.00% 14 14.46% 14. 1 0 13.73% 2745 3850 6405 10220 55.72 66.98 194.93 372.02 450.84 568.54 77.96 655.48 8.88 10.99 28.96 38.40 86.94 08801 90*9 0988 088* 9*ZE 48994 *18 2 92 ZOZG L E99*L 8809 39 68 EL Lt,L 82 8*08Â£ EZ-201 t6 OZ SG69Z9 /092.88 %986â‚¬ %29.E L 68'983 08 Â£0 02 92.Z M>l/slue3 98'LE 98.92 89'* L LL'*L *8'8 LL'S +09 e6ue40 le SK'6 89.9 98.9 ZZ 6 L9'OL MM/slues pesodoid 000* 0002 0002 8231 1 69'86 56Â£8'9 L 56*09 L %2~9 1 L 6L 96Â£942 17. 29.,9 99.92 0,+ L TOWN OF ESTES PARK Typical Bills Current and Proposed 2004 Rates 15.93% 16.40% 1 1 15.29% Residential Demand Winter nts/kW SIX' Lduloolse Residential aol le!;uep!seu 0!WEI Me 1. 8. Â£ CO 00 89 06 091'001~ O-00 O -cD 91- 6 H 1- Al O 00 0 0 0 (9 NO O N C\1 00 N 91- 6 0 - r 00 1< 4 CD -c\19 010)â‚¬10(0 091Â·00.-h *31&JE Â§62@2* '0.- p u oci al -010911 00 0 0 C\1 91- 0 ~ %32 OLDEN.:81 K N CD 91- 10 00 06 ' 0 0 05 ~K9022!67 0 1 0 O M (0 32 M CD O-00 CUC) ACD LOW*?crioci 9 - 1 CD h: 0,5 do * 91' K 10 (D - 8-8 20%8 O.CO O O W ID â‚¬ O -1.0 0 N 00 Bl 00 ID Z. CD CO ce h CSK - c) 2 d ov h#*~d K N 01 d OR' A 091-0091'oycoco & 9 h O-OO NT- 09 0 C) 4- O 4 Lo w cvcD N cow ce (\1 co (9 4 - 00000hoy O (\1 1 CD LD d 9- cD (D 9-MX CW 2 5, O -C 61059 EO C**J 0 0 0-0-000-0.00. estcomp2004 kWh Minimum 100 1000 2000 2500 5000 Current $ 7.25 14.14 76.17 145.09 179.55 351.85 Dollar Change 0.00 12.50 15.62 31.24 Proposed Cents/kWh 7.88 7.81 7.66 Proposed $ 7.25 14.77 82.42 157.59 195.17 Percent Change 0.00% 8.61% 8.70% 28.5 207.1 ro osed $ 32.4 231.08 Cyâ€ž %39. L L 9Â£ LL L LVE L *9.83 91,-EL ZE'E L 88'E 66'9 Â£66 00'6 M>l/Glues pesodoi Skm~~ ~~1 e 2000 TOWN OF ESTES PARK Typical Bills Current and Proposed 2004 Rates Small Commercial m rcial TOD estcompl.xls 0 m age ~ - g O 0 3: 3 E LO 0) 4.- 004 W 1 1 EO 0 10 ccS g ykg! ~ Â° ~ 8 N CD K 22 2 18 0 0 00 $ A CO 0) * 0000000 000 .oN 1.6 co co Â©! too 32 LO LO 0 lo O)00 0 Ng 2 .v'~ 0 00 CJ ID O 0 tO CO O lo 0 29Eeg LO (9 00 E 3 8 210*5 - C) cv k KA h crs K CÂ» R O - 1 0 0 LO 0 ct 0 0- O C\IT- O T- -3 CDC> 0 0 1- 0 00 dER O N O 3 mocid - d K SK c o C a) 10 2 2 0 05 0 U 0 C OC J 5 00 00 O d 0 0 & 9 0 2 1 - 3 2 a) CD (D m 3 0 Â®0 LO CO 00 0 0 evo-g favor C CC LU LU E$EU -1 E Eo M 2 -% S E >%1~ 2 & E 2Â§-22 .= CD M Â® E E = 2 8 E & jf 85@255~ g ad E - 2%8&28 22000-~-~~ = JC 30>KE E 236OW~ J (0 0 LU U) D m m I estcomp20b4 pasodold luallno pesoded lueklro pesodoJd lue.uno esodold lue.un0 pesodold ELOZO'O 9 LE90'0 L808Â£0.0 69680'0 89 LSZ00 868900 29980'0 980800 82082.00 9890'0 ied!0!unIN lu 00 emel WWOO IIBLUS puewea le!;uepisell 10220 12775 153 27375 58400 73000 87600 64.92 71.29 11 127.6 141.33 28 323.84 360.21 626.51 702.11 777.71 1,342.52 1,504.53 1,666.53 3,580.06 4,01 07 685.07 767.03 849.00 1,456.57 1,632.22 1,807.86 3,867.53 4,33 8.49% 8.48% 8 d Cents/kW 7 01 7.01 Typical Bills Current and Proposed 2004 Rates ropose 17.53 1~0.2332 12.80% 12.80% 12.80 12.80% 15.91 820EZ00 LZZE60'0 29900 2692800 0 X6keue LEO.0 9920'0 LEO.0 9980'0 aol le!01el.Ul.U00 Ileltls pesodold luel;Ino pesodoi lue,unj TOWN OF ESTES PARK 15.54 62.16 Large Commercial Proposed Cents/kW estcompl.xls Jell.1019 M O 001 A e =11 M 91 %1 - 43 011 go h 0 51'Q 0 0 =m- lt- % 0-r-~~ % :0 *i 0 IN M c 0 U A f T 00 cr)Â© % 0 09 U 0 rol =t 3 = U) h 0 0 9 0 0 Â§ R 0/ 00 g 58.33 Â© U M . I 1/ ENS 00 &0 4 N ec el Â® M 0 01 h U 01 -- â‚¬9- 01 00 C. 6 h rn - ~03* Â¢91 0Â© . . 041 U . 6 0 c< 8 = 9% t ge =13 as k r u 71 5 8 2 2 Ou :=r > b..8 E G â€¢â€¢ 0 0 ~ ~a * Eze -1 - 04 h r-~/-*h U Es co-0 Stg m~ 0000 E Le RO< w -2 :2 -s -E ~ IM E *-a-9 902 1, 12 4~ 1sr ~ 1 22 u E %2 ~ 18* ~2 , 5 M .0 0 0 O4Z E- <U 13 om Z U â‚¬4 4 4 â€¢r; W r< 06 Residential 3,740,019 4,102,201 4,500,192 4,668,863 4,753,199 4,837,535 4,921,871 5 06,207 5,090,543 mall, Large & RMNP 3,535,668 3,811,168 4,078,947 Un= 4,298,592 4,408,433 4,518,288 4,628,156 4, 38,038 4,847,933 183,09 199,663 217,787 223,507 229,227 234,947 240 246,387 257,828 urchased Power Rider 166,357 170,191 174,025 177,86 181 185 53 193,20 4,063,088 4,325,279 4,424,958 4,524,648 4,624,351 4,724,065 4,823,791 4,923,530 5,023,281 ,342,181 1,388,710 1,436,958 1,486,992 1,538,880 1,592,694 1,648,507 1,706,397 1,766,442 1,828,728 617,155 638,986 661,634 685,129 709,505 734,795 761,034 788,261 816,512 845,828 General (3) 1.248.827 1.143.437 1.188.209 1.218.170 1.248.882 1.2 0.372 1.312.667 1.345.795 1.379.786 1.414.669 7,175,428 7,234,221 7,612,080 7,815,249 8,021,915 8,446,273 8,664,244 8,886,270 9,112,505 513,350 1,111,111 1,585,825 1,588,708 1,588,130 1,5~3,960 1,576,062 1,564,293 1,548,507 1,528,550 298,010 301,130 298,650 300,688 297,085 298,060 298,360 298,070 297,070 300,455 SEL'005 666'LI 5 258'6ES 688'995 L99'6Â£5 OZL'RES 6Â§L'*Â£5 9LE'ES 59L'9Â£5 Â£8L'Z99 121~22 2~1~ZIX 111~XU~ 2 32 13 E80~896 E~8~9Â£6 L66'SL5 Â£Â£6'98 I 095'056 99Z'806 Zt,9'L98 SEZ'638 ZSE'Z6L 5 I I'L 9L OLÂ¢ I EL 90Z' 1+'9 861'85L GO'187'Z (BLE'061) (407'88) (Lzt'Z) 689'EL 0*5'0*I 996'86I Â£ 19'9*Z LE9'gÂ£Â£ (IOZ'ERI) (OZI'+60'Z) 08*'8 IE'L 95Z'ZIL'L 986'666'L LZ5'L61'8 18471Â£'8 60 I'i 9Â£'8 82Â£'5*Â£'8 f IE'6LZ'* Â£Â£6'21'8 LLÂ¢ZIE'R 9,403,957 9,610 9,816,172 10,022,335 1 10,434 7 10,641,0 Twelve Months Ended 12/31 2003 2005 2Â®.8 2009 232.300 234.623 236.969 239 241.732 244.liQ spuoq tiUM slooftud [mideo ain 19 Suiputu 1qop uum 8 mui pue iudioupdjo uonoo Capital Proiects Town of Estes Park Current Revenue Funded Light And Power Department Ten Year Financial Forecast pe pue Slunoooe loluolsno 'UO!1nq!.Ils!P JO JUOUIdopA Â·osuodxo joiHod poseqaindjo juouidopAop 104 LJO g sanuokol luauno 41!M nJ 22 s loofold [mide) souin *EL'OLL 06I'I69 Â·sonuoul Jo lumudoloAop Joi L Jo f 108pnq na,odO-uoNJO luouido Rate Changes Operating Revenue: (1) sfers Out G do unÂ·,SZO:sue,Ols@lso ZO/11/El Town of Estes Park Light and Power Department Ten Year Financial Forecast Detailed Budget 2Â®2 29Qa 2QM 2QQi 26 2021 2QQ& 2002 2QLQ 211 Operating RevenuesÂ· Residential 3,740,019 4,102,201 4,500,192 4,584,528 4,668,863 4,753,199 4,837,535 4,921,871 5,006,207 5,090,543 Commercial 3,535,668 3,811,168 4,078,947 4,188,763 4298,592 4,408,433 4,518,288 4,628,156 4,738,038 4,847,933 Municipal 1 83,092 199,663 217,787 223,507 229,227 234,947 240,667 246,387 252,108 257,828 Proposed Rate Change 0 0 0 0 0 0 0 0 0 0 Miscellaneous 2QI ULJW J#232.*222 ALZE NUiv 246.21 249.Qil SLJ# Total 7,688,778 8,345,332 9,031,548 9,233,766 9,436,021 9,638,3 12 9,840,640 10,043,006 10,245,410 10,447,852 Operating Expenses Purchased Power 3,967,265 4,063,088 4,325,279 4,424,958 4,524,648 4,624,351 4,724,065 4,823,791 4,923,530 5,023,281 Distribution Salaries 785,639 817,065 849,747 883,737 919,087 955,850 994,084 1,033,847 1,075,201 1,118,209 Payroll Taxes 59,627 62,012 64,493 67,072 69,755 72,545 75,447 78,465 81,604 84,868 Employee Benefits 141,182 146,829 152,702 158,811 165,163 171,769 178,640 185,786 193,217 200,946 Maintenance 266,750 272,085 277,527 283,077 288,739 294,514 300,404 306,412 312,540 318,791 S upplies 40,200 41,004 41,824 42,661 43,514 44,384 45,272 46,177 47,]01 48,043 Insurance 27,219 27,763 28,319 28,885 29,463 30,052 30,653 31,266 31,891 32,529 Rent 2,200 2,200 2,200 2,200 2,200 2,200 2,200 2,200 2,200 2,200 Other m.~ 12.111 2Ud# 2Qi&2 20.2#Q 21.312 ~ 22.213218 1119 Subtotal 1,342,181 1,388,710 1,436,958 1,486,992 1,538,880 1,592,694 1,648,507 1,706,397 1,766,442 1,828,728 Customer Accoluits Salaries 373,736 388,685 404,233 420,402 437,218 454,707 472,895 491,811 511,484 531,943 Payrol 1 Taxes 29,091 30,255 31,465 32,723 34,032 35,394 36,809 38,282 39,813 41,406 Employee Benefits 71,586 74,449 77,427 80,525 83,745 87,095 90,579 94,202 97,970 101,889 Maintenance 114,675 116,969 119,308 121,694 124,128 126,610 129,143 131,726 134,360 137,047 Uncollectable Acct 11,000 11,220 1 1,444 11,673 11,907 12,145 12,388 12,636 12,888 13,146 Other E.Â£%2 11.2 iziji LLU2 ladid 1Â£&41 19228 11Â®i 12Â£77 2QJQZ Subtotal 617,155 638,986 661,634 685,129 709,505 734,795 761,034 788,261 816,512 845,828 Admin. & Gen. Salaries 258,805 269,157 279,923 291,120 302,765 314,876 327,471 340,570 354,193 368,360 Payroll Taxes 15,975 16,614 17,279 17,970 18,688 19,436 20,213 21,022 21,863 22,737 Employee Benefits 49,002 50,962 53,001 55,121 57,325 59,618 62,003 64,483 67,063 69,745 Office Supplies 37,405 38,153 38,916 39,694 40,488 41,298 42,124 42,967 43,826 44,702 Professional Fees 78,150 79,713 81,307 82,933 84,592 86,284 88,010 89,770 91,565 93,396 Exhibits and Display 67,500 68,850 70,227 71,632 73,064 74,525 76,016 77,536 79,087 80,669 Utilities 75,230 76,735 78,269 79,835 81,431 83,060 84,721 86,416 88,!44 89,907 In Lieu of Fanchise 228,016 243,391 263,908 269,904 275,900 281,897 287,895 293,892 299,891 305,889 Rent 78,785 78,785 78,785 78,785 78,785 78,785 78,785 78,785 78,785 78,785 Vehicle Maint 120,000 122,400 124,848 127,345 129,892 132,490 135,139 137,842 140,599 143,41! Equlpment Maint. 182,469 23,000 23,460 23,929 24,408 24,896 25,394 25,902 26,420 26,948 Interest on Cust. Dep, 0 17,037 18,474 18,893 19,313 19,733 20,153 20,572 20,992 21,412 Education & Training 17,500 17,850 18,207 18,571 18,943 19,321 19,708 20,102 20,504 20,914 Dues & Subscription 7,790 7,946 8,105 8,267 8,432 8,601 8,773 8,948 9,127 9,310 Other 32.2QQ 120 1121 31111 11.89 lijil 31262 JuM 11.121 18682 Subtotal 1,248,827 1,143,437 1,188,209 1,218,170 1,248,882 1,280,372 1,312,667 1,345,795 1,379,786 1,414,669 Total Expenses 7,175,428 7,234,22 1 7,612,080 7,815,249 8,021,915 8,232,211 8,446,273 8,664,244 8,886,270 9,112,505 Operating Income 513,350 1,111,111 1,419,468 1,418,518 1,414,105 1,406,101 1,394,367 1,378,762 1,359,140 1,335,347 Principal & Interest LTD 298,010 301,130 298,650 300,688 297,085 298,060 298,360 298,070 297,070 300,455 Non-Operating Revenue Leased Property 29,000 29,000 29,000 29,000 29,000 29,000 29,000 29,000 29,000 29,000 interest Income 624,783 499,136 488,226 498,128 502,656 504,220 502,134 495,848 484,810 468,429 Sale of Fixed Assets 9.~ 2.QQQ 2.~ 2/EQ 24<Q 9.~ 2.~ 2.QEQ PEQQ 2,2 Subtotal 662,783 537,136 526,226 536,128 540,656 542,220 540,134 533,848 522,810 506,429 Transfers Out 691,190 770,738 835,708 854,696 873,685 892,675 911,667 930,659 949,653 968,649 Available Capital Improv. 186,933 576,379 811,337 799,262 783,991 757,585 724,474 683,881 635,227 572,672 Capital Improv Cur. Rev, 2,281,053 758,198 641,206 721,470 757,115 792,352 829,235 867,842 908,256 950,560 Surplus / (Deficit) (2,094,120) (181,819) 170,130 77,792 26,877 (34,767) (104,761) (183,961) (273,029) (377,888) Notes: 1 See notes on page 1 of 7 2. See page 6 of 7 for assumed escalation rates for expenses. estÂ¢sfortcast02[)et Op St 1 Dll,02 2 of 7 -1//6/EME - ~ 1 6% %1 1EiÂ°Â°EE.*51Â§ 8%3R*%22 61 **g **** AR en_~ -- 01 â‚¬1 R 9 E * Rl i 82:isi $*6 ***Â§ Mer)__ N n M -1 00 crl- -- â‚¬9(9 rn . N rn %1 61Â¢1~D-'.1 -1 28gg 5*6 M **Â§ 9 21 NE 9.Em-00 1 -1 'I -- ---r 821- fl rn %1 E m -1 g - ..91â‚¬ R~.Â§9%Â® 5%% R *Â§% M -1 eN 4 4 \0 r. â‚¬01 r. 5 *5 **** fN m -1 - - - 04 * ma E Afig E-3 93:00 5 *5 **** 1-4 N cr, 45 -- --- Â£ E 9162 RER 5*E ***Â§ Â¢91 ,4 4 4 -1. Cl 31 - 5 r.1 r, SRERSE 5Â§6 ***Â§ 2 0 2.Â¥1 en -1 (Naz- /9 a*~5 52= S<= M 9. fraw.B B *Em 3 36/ 9 Â¢Ng= 81 2,30 01 -05 R E / ME 2*95&2=* 25*5 **** 041 * [2 4 2 - -2 -, n g '6 4 8 C - -- -- -" R' 23-23; *Emeja 8Â¤Â§58* *BRE 49*go 4- 61 0 4 - 00 â‚¬- - - - 04 .1 -Â®00- %1 2%%3 2-9.131920 93%3*-0 rn I -- - h 00 - -- - *1 -1 2*~IM BEÂ¥-EE-m ~2 m - 00.01.W nO. 01 0.00Â©t-Â·r--0/0 .8 1.3 04*0010,04 00 0 -00-. -- -A # 1 1 0= col ON f vs /1 - rn C eN M W 38580$40 E M 2 2 ~- 2 'mwf - -m V %1 01 0 9 5. 0. g i 51 Z :9Â£5%1* MEES*82 ENA 2032Â°20 eli (9 0 W mao - . Â°clole noo. 3: g gs==== 04 -9 0 4 42. f & 4 --6 1 :2: -- -- rn - 5 Â·32 9 E -- rl 31 2-D 0 a E m a 2 1:3 ~83= 3 -i e y i i :*83. = 1 M 83 9 rroz 1 i i i. E , 1 8 1 9 81 0 1 3 2 8 E Â£ j E @32% 3 -IME E i ~ Mi 2% 3 11 1 21 g de it , 2 -E E 5/<0'-DOON. A = 2 imIN,2.*822:22 - 2E 4 1 Z - N cri 4 -:I 0 3.54% 2514 28 3~ 21Â·I47 22Â·15~ 2287~ 313,~7 24,754 ~''~~~ ~,~8232~ 7,55~203 ~~139 61'904 603'~8i Â¢322084~ 65,477 661 1 12098 12~8 M ~6 4 '40 4 91 130 4 mn U~ Ciz: 7~â‚¬~ 7 ~ 85,184 86,835 88,485 90,136 91,786 93,437 95,087 6,365 6,379 6,394 6,409 6,424 439 6,453 6,468 7 2,889 3,101 3,313 3,737 i 3,949 8 100 3 102 9 5 105,113 107,546 110,219 1]2,816 115,413 1 18,010 120,607 123,204 125,801 128,398 130,995 133,59 27,56 ~ ~2 33',6~ 34.263 34, 24~5 2703 3076 4,471 4,825 5, 7 5,533 5, wau.w.dia JA.Od PUM 1431 1 ,872 101 1 27 5, 9 i, 1 22 18 8~8 85 Town of Estes Park Sales Projection LJo Â£ 121,49 2 ,2 221Â°0 Historical Data Projected Emp IOOT }g pU# =Ull B uo p i ooz-53 50803 50653 5280 5~22~ ~ ~96 E t Â£ 91'ZE 0'17 Â£18'Â£ 3, i :51 Elo't Town of Estes Park Light and Power Department Revenues 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 MWh(1) Residential 40,123 40,931 41,740 42,549 43,358 44,166 44,975 45,784 46,593 47,401 Res. Demand 12,065 12,093 12,121 12,149 12,177 12,205 12,233 12,261 12,290 12,318 Res. TOD 3,763 4,117 4,471 4,825 5,179 5,533 5,887 6,241 6,595 6,949 Subtotal 55,950 57,141 58,332 59,523 60,713 61,904 63,095 64,286 65,477 66,668 GS Small 24,754 25,689 26,625 27,560 28,496 29,431 30,367 31,302 32,238 33,173 GS Large 30,842 31,412 31,982 32,552 33,122 33,692 34,263 34,833 35,403 35,973 GSTOD 121 126 131 136 141 146 151 156 161 166 Municipal 2,944 3,025 3,107 3,188 3,270 3,352 3,433 3,515 3,596 3,678 RMNP 1.405 1.426 1.447 1.469 1,491 1.513 1.536 1.559 1.582 1.606 Total 116,015 118,819 121,623 124,428 127,233 130,039 132,845 135,651 138,457 141,264 Unit Revenue $/kWh (2) Residential 0.0696 0.0746 0.08 0.08 0.08 0.08 0.08 0.08 0.08 0.08 Res. Demand 0.0645 0.0712 0.0776 0.0776 0.0776 0.0776 0.0776 0.0776 0.0776 0.0776 Res. TOD 0.045 0.0456 0.0493 0.0493 0.0493 0.0493 0.0493 0.0493 0.0493 0.0493 Subtotal GS Small 0.0742 0.0773 0.0805 0.0805 0.0805 0.0805 0.0805 0.0805 0.0805 0.0805 GS Large 0.0534 0.0562 0.0585 0.0585 0.0585 0.0585 0.0585 0.0585 0.0585 0.0585 GSTOD 0.0524 0.059 0.0615 0.0615 0.0615 0.0615 0.0615 0.0615 0.0615 0.0615 Municipal 0.0622 0.066 0.0701 0.0701 0.0701 0.0701 0.0701 0.0701 0.0701 0.0701 RMNP 0.0325 0.0369 0.03915 0.03915 0.03915 0.03915 0.03915 0.03915 0.03915 0.03915 Revenue: ($) (3) Residential 2,792,538 3,053,484 3,339,213 3,403,912 3,468,612 3,533,312 3,598,011 3,662,711 3,727,410 3,792,110 Res. Demand 778,168 861,003 940,579 942,761 944,943 947,125 949,307 951,489 953,671 955,854 Res. TOD 169.313 187.715 220.400 237.854 255.308 272.763 290.217 307,671 325,125 342,579 Subtotal 3,740,019 4,102,201 4,500,192 4,584,528 4,668,863 4,753,199 4,837,535 4,921,871 5,006,207 5,090,543 GS Small 1,836,718 1,985,769 2,143,282 2,218,589 2,293,897 2,369,205 2,444,513 2,519,821 2,595,129 2,670,437 GS Large 1,646,944 1,765,343 1,870,944 1,904,298 1,937,652 1,971,005 2,004,359 2,037,713 2,071,067 2,104,421 GSTOD 6,351 7,443 8,063 8,367 8,672 8,976 9,280 9,585 9,889 10,194 Municipal 183,092 199,663 217,787 223,507 229,227 234,947 240,667 246,387 252,108 257,828 RMNP 45.655 52.613 56,659 57.508 58,371 59.247 60,135 61.037 61.953 62.882 Total 7,458,778 8,113,032 8,796,925 8,996,797 9,196,682 9,396,580 9,596,491 9,796,415 9,996,353 10,196,304 Miscell. Revenue 230,000 232,300 234,623 236,969 239,339 241,732 244,150 246,591 249,057 251,548 Escalation 1.01 Proposed Rate Changes: (Across the Board) Annual Change % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Accum. Change % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Revenue 0 0 0 0 0 0 0 0 0 0 Notes: 1. Sales projection from page 3 of 7. 2. Unit revenue based on data for twelve months ended 12/3 1/2001. 3. Revenue equals MWh sales times unit revenues. estesforecastO2Re;enue 4 of 7 12/11/02 -1 00 'n -la' 0 215 . 't 01 \0 An -1 0, O 0~ 01 d 81 3 01 0 0 0 E OM E â‚¬t cul en l.r, Go - 0 00 01 0 0 0 4 &3 0 0 0 g â‚¬ b EM g 62 2 5 04 .0 * 4 -0 CS .C b 2 1 i i z is: 29 VE O Eg 4 0- = E u ie M M â‚¬4 -0 3,218 e lcd i Karil a- & 3 1 2 5 .4 g E â‚¬ EFO =U= = ..2.5 SE#UEbsb2 atE),3-=ada{42mult<A o t-W.uc,U=O>0 ME.9.3=*gzz#E N 2 N < a. 2 m O U. >Â· U U Z.*5<(2-3 121,68 124,627 127,567 130,507 133,447 136,387 139,328 142,270 145,211 148,153 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 22,773 23,323 23,873 24,423 24,973 25,524 26,074 26,624 27,175 27,725 8.84 8.84 8.84 8.84 8.84 8.84 8.84 8.84 8.84 8.84 8.84 201,310 206,173 211,036 215,899 220,763 225,628 230,493 235,359 240,225 245,092 10.64 10.64 10.64 11.0656 11.0656 11.0656 11.0656 11.0656 11.0656 11.0656 11.0656 0.015 0.015 0.015 0.0156 0.0156 0.0156 0.0156 0.0156 0.0156 0.0156 0.0156 2,141,944 2,193,679 2,335,237 2,389,054 2,442,877 2,496,707 2,550,543 2,604,386 2,658,235 2,712,091 1,825,321 1,869,409 1.990,042 2,035.904 2.081,771 2,127,644 2,173,522 2,219,405 2,265,295 2,311.190 3,967,265 4,063,088 4,325,279 4,424,958 4,524,648 4,624,351 4,724,065 4,823,791 4,923,530 5,023,281 32.60 32.60 33.91 33.91 33.91 33.91 33.91 33.91 33.91 33.91 10.64 0 166,357 170,191 174,025 177,860 181,695 185,530 189,367 193,203 2003 2004 2005 2006 2007 2 2009 2 118,693 121,492 124,292 127,092 129,893 132, 135,495 138, 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 1 8.0 *ES- 0 698'0 *28Â·0 808,0 kITO LKO 416'0 6L80 t98O L96'0 946'0 *8.8 .8 816-L SOL'6 L80'8 1Â£96 0!le-H )[Ead 01 41 asft OSE[@Av 866I L66I 5661 9661 L09'0 *55.0 *L9'0 St,g o 4590 1010Ed peoi U!00 [En Town of Estes Pa PRPA Purchased Power Cost 1.04 EIS'ZE 051'81 I9L'IE 9ZS'L 1 95Z'8LI I Â§ I'9LI LL6'Â§LI 108'89 I *LW'ZOZ gLy'EOZ 086'18 1 *6*'SL I (uop,i-/AN) pueluoa [1!9 u!00 5Â£0'L91'60I 889'06I'LOI 90E'9Â£8'Â£01 936'95Â£'001 Light and Power D 655 9Â·t 8*.g Vdkid 041 01 sluounsnfpe Kuv Â·potiod ise)0101 31[1 119nolqi luelsuoo uleut@.1 03 polunsse Ole Sole, Vdkid 041 13 LJO 9 zon !/El Flo'o :kioloq Umoqs eleCI [Ropols!H UO pOSEq 1SE 90121 0!Â·noop s,U/401 o41 u! Pologual Oq P[nOM 0181 Note: 1. See page 3 of 7. Jobiod ZOisBOOJOJSolso Town of Estes Park Light and Power Department Operating Expenses Actual Actual Budget 2000 2001 2002 ER 2003 2004 2005 2006 2007 2008 2009 2010 2011 Distribution Salaries 551,550 728,897 785,639 L 817,065 849,747 883,737 919,087 955,850 994,084 1,033,847 1,075,201 1,118,209 Payroll Taxes 41,783 54,566 59,627 L 62,0[2 64,493 67,072 69,755 72,545 75,447 78,465 81,604 84,868 Employee Benefits 97,130 133,616 141,182 L 146,829 152,702 158,811 165,163 171,769 178,640 185,786 193,217 200,946 Maintenance 51,466 196,190 266,750 D 272,085 277,527 283,077 288,739 294,514 300,404 306,412 312,540 318,791 Supplies 23,854 29,909 40,200 D 41,004 41,824 42,661 43,514 44,384 45,272 46,177 47,101 48,043 Insurance 6,980 26,990 27,219 D 27,763 28,319 28,885 29,463 30,052 30,653 31,266 31,89I 32,529 Rent 35,200 2,200 2,200 S 2,200 2,200 2,200 2,200 2,200 2,200 2,200 2,200 2,200 Other 2,482 8,34 1 19.364 2 19,751 20-146 20.549 20,960 21,379 21,807 22143 22,688 21142 Subtotal 810,445 1,180,709 1,342,181 1,388,710 1,436,958 1,486,992 1,538,880 1,592,694 1,648,507 1,706,397 !,766,442 1,828,728 Customer Accoun tj Salaries 253,106 294,944 373,736 L 388,685 404,233 420,402 437,218 454,707 472,895 491,811 511,484 531,943 Payroll Taxes 21,628 24,061 29,091 L 30,255 31,465 32,723 34,032 35,394 36,809 38,282 39,813 41,406 Employee Benefits 56,988 64,954 71,586 L 74,449 77,427 80,525 83,745 87,095 90,579 94,202 97,970 101,889 M aintenance 50,329 86,269 114,675 CA 116,969 119,308 121,694 124,128 126,610 129,143 131,726 134,360 137,047 Uncoliectable Acct 4,048 5,217 1 1,000 Below 11,220 11,444 i],673 11,907 12,]45 12,388 12,636 12,888 13,!46 Other 4 948 11.191 17,067 CA 17.408 17,757 18,112 18,474 18,843 19,220 19.605 19,997 29.222 Subtotal 391,047 486,636 617,155 638,986 661,634 685,129 709,505 734,795 761,034 788,261 816,5 I 2 845,828 Admin. & Gen. Salanes 193,835 241,048 258,805 L 269,157 279,923 291,120 302,765 314,876 327,471 340,570 354,193 368,360 Payroll Taxes 14,071 17,942 15,975 L 16,614 17,279 17,970 18,688 19,436 20,213 21,022 21.863 22,737 Employee Benefits 34,821 44,395 49,002 L 50,962 53,001 55,121 57,325 59,618 62,003 64,483 67,063 69,745 Office Supplies 26,258 299,939 37,405 AG 38,153 38,916 39,694 40,488 41,298 42,124 42,967 43,826 44,702 Professional Fees 40,198 32,357 78,150 AG 79,713 81,307 82,933 84,592 86,284 88,010 89,770 91,565 93,396 Exhibits and Display 52,153 0 67,500 AG 68,850 70,227 71,632 73,064 74,525 76,016 77,536 79,087 80,669 Utilities 37,860 41,910 73,230 AG 76,735 78,269 79,835 81,431 83,060 84,72t 86,416 88,144 89,907 In Lieu of Franchise 184,345 191,085 228,016 Below 243,391 263,908 269,904 275,900 281,897 287,895 293,892 299,891 305,889 Rent 77,250 77,250 78,785 S 78,785 78,785 78,785 78,785 78,785 78,783 78,785 78,785 78,785 Vehicle Maint. 97,986 87,000 120,000 AG 122,400 124,848 127,345 129,892 132,490 135,139 137,842 140,599 143,411 Equipment Maint. (2) 13,321 20,150 182,469 AG 23,000 23,460 23,929 24,408 24,896 25,394 25,902 26,420 26,948 Interest on Oust. Dep. 12,929 12,000 0 Below 17,037 18,474 18,893 19,313 19,733 20,153 20,572 20,992 21,412 Education & Training 10,411 10,000 17,500 AG 17,850 18,207 18,571 18,943 19,321 19,708 20,102 20,504 20,914 Dues & Subscription 7,825 7,915 7,790 AG 7,946 8,105 8,267 8,432 8,601 8,773 8,948 9,127 9,310 Other 13,463 13282 32.200 Ag 32,844 33,50[ 34,171 34,854 35,551 36,262 1288 31223 38.482 Subtotal 8]6,726 I,I !6,280 1,248,827 1,143,437 1,188,209 1,218,170 1,248,882 1,280,372 1,312,667 1,345,795 1,379,786 I,414,669 Total Expenses 2,018,218 2,783,625 3,208,163 3,171,133 3,286,801 3,390,291 3,497,267 3,607,861 3,722,209 3,840,453 3,962,740 4,089,224 Escalation Rates: (ER) Labor (L) 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04 Distribution (D) 0.02 0.02 0.02 0.02 0,02 0.02 0.02 0.02 0.02 Customer Accounts (CA) 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 Admin & Gen. (AG) 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 Special (S) O.00 O.00 O.00 O.00 O.00 O.00 O.00 O.00 O.00 Other Basic Data: Revenue Sales 6173261 7,275,686 8,!13,032 8,796,925 8,996,797 9,196,682 9,396,580 9,596,491 9,796,415 9,996,353 10,196,304 Cal Franchise Fee %( 1) 0.0298619 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 Int. Cust. Deposit % C 1) 0.0020944 0.0021 0.0021 00021 0.0021 0.0021 0.0021 0.0021 0.0021 0.0021 0002 1 0002 i Transfers Out Percent of Revenue/Sales % ( 1) 0.095 0.095 0095 0.095 0.095 0.095 0.095 0.095 0.095 0.095 0.095 0.095 Transfers Out 691,190 770,738 835,708 854,696 873,685 892,675 911,667 930,659 949,653 968,649 Note 1. Percent is taken times the revenue from sales excluding municipal. ege,forecass)2Det Op Exp 1 2. Ilite 6 of 7 Town of Estes Park Ught and Power Department Capital Improvements and Interest Income 2QQQ 2[El 2Â®2 2QQ3 2QQd 2QQ5 2QQO 2QQZ 28 2Â®9 2Qi.9 22.11 Capital Requirements: ( 1) Substations 14757 266,000 25,000 10,000 10,000 10,500 1 1,025 11,576 12,155 12,763 13,401 14,071 Meters 105265 100,000 224,284 155,220 165,896 150,000 156,750 163,804 171,175 178,878 186,927 195.339 Transformers 58707 180,000 120,000 1 15,000 120,000 125,400 131,043 ]36,NO 143,102 149,542 156,271 163,303 Sueet Lights 22383 82,500 75,000 62,500 62,500 50,000 52,000 54,080 56,243 58,493 60,833 63,266 Overhead 509725 59,000 1,104,442 111,000 111,000 120,400 126,420 132,742 139,378 146,347 153,665 161,348 UnderwÂ·ound 140649 195,000 525,000 114,000 50,000 95,000 101,750 106,513 111,499 116,719 122,184 127,905 Long Range 0 Q Q Q Q Q Q Q Q Q Q Q Subtotal 851486 882,500 2,073,726 567,720 519,396 551,300 578,988 605,655 633,552 662,742 693,281 725,232 Office, Shop, Stores 6188 17,000 12,500 5,000 00000000 Computer 62996 142,400 140,000 67,500 82,500 80,000 83,600 87,362 91,293 95,401 99,695 104,181 Vehicles 56235 172,000 197,000 139,000 67,500 125,000 131,250 137,813 144,703 151,938 159,535 167,512 Buildings 0 12,500 10,000 1 2,500 5,000 5,250 5,513 5,788 6,078 6,381 6,700 7,036 Tools, Lab, Comm 14370 .1Â£2QQ 45.200 16.000 11.500 9.000 9.360 9334 10.124 1222 10.950 11.388 Subtotal 139789 36Q.8QQ 404.700 240.000 166,500 219.250 229.723 240.697 252,198 264249 2188Q 290.!17 Total 991275 1,2443,300 2,478,426 807,nO 685,896 770,550 808,711 846,352 885,750 926,991 970,16! 1,015,349 Customer Contributions Irrvestment 534,000 1,973,726 495â€ž220 446,896 490,800 515,963 539,999 565,154 591,486 619,047 647,895 Peroentage (2) 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 Crist. Contri. Capital 53,400 197,373 49,522 44,690 49,080 51,596 54,000 56,515 59,149 61,905 64,790 Capital from L&PD 1,189,900 2,281,053 758,198 641,206 721,470 757,115 792,352 829,235 867,842 908,256 950,560 Bondfunckd 0 0 0 0 0 0 0 0 0 0 0 CunÂ·ent Rev. Funded 1,189,900 2,281,053 758,198 641,206 721,470 757,115 792,352 829,235 867,842 908,256 950,560 Bond Financing (3) Years 10 10 10 10 10 10 10 10 10 10 10 Interest Rate 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 Level Debt Factor 7.0235815 7.0235815 7.0235815 7.0235815 7.0235815 7.0235815 7.0235815 7.0235815 7.0235815 7.0235815 7.0235815 Prine. & Interest 298,052 299,443 298,010 301,]30 298,650 300,688 297,085 298,060 298,360 298,070 297,070 300,455 2002 0 0 0 0 0 0 0 0 0 0 2003 0 0 0 0 0 0 0 0 0 2004 0 0 0 0 0 0 0 0 2005 0 0 0 0 0 0 0 2006 0 0 0 0 0 0 2007 0 0 0 0 0 2008 0 0 0 0 2009 0 0 0 2010 0 0 2011 0 Subtotal 298,052 299,443 298,010 301,130 298,650 300,688 297,085 298,060 298,360 298,070 297,070 300,455 Previous Years Balance 3,718,565 2,990,716 10,413,048 8,312,577 8,122,933 8,279,314 8,345,328 8,361,109 8,314,813 8,197,527 7,999,985 7,712.255 Years Surplus/Deficit 0 -2,100,471 -189,643 161,217 68,056 16,269 -46,296 -117,286 -197,543 -287,730 -393,775 % Avail. For Cap. Imp. (4) 0.97 0.97 0.97 0.97 0.97 0.97 0.97 0.97 0.97 0.97 0.97 0.97 Surplus / Deficit 0 0 -2,100,471 -189,643 156,381 66,014 15,781 -46,296 -117,286 -197,543 -287,730 -393,775 Ending Years Balance 3,718,565 10,413,048 8,312,577 8,122,933 8,279,314 8,345,328 8,361,109 8,3 14,813 8,197,527 7,999,985 7,712,255 7,318,480 Interest Rate 0.06 0.06 0.06 0.06 0.06 0.06 0.06 0.06 0.06 0.06 0.06 0.06 Interest income 223,114 624,783 498,755 487,376 496,759 500,720 501,667 498,889 491,852 479,999 462,735 Notes 1. Provided by Light and Power. 2 Based on review of historical data 3 Assumes bond funds would le 10 year term and 7% interest rate. 4 Assumes 3% of surplus revenues would not be available for capital projects. Used for such expenditures as supplies and inventory. Â¢stesforecam}]Cap imp 1 Dll.'02 7 of 7 Light Power Year To Date Operating Income $800,000 $600,000 - - $400,000 - - m- e. - I 2001 12002 $0 1 1 -lin 1 1 -1 -1 1 --- 2002 Budget ($200,000) C -0 m Â¤- CO J .7 1 0 *, O (1) 1- 1- ACEOng>0 ($400,000) ~ 1~ 6 < 2 -1 <Ujuza ($600,000) Capital $2,500,000 ------------ $2,000,000 $1,500,000 ELIZ- 12001 12002 $1,000,000 - - - 2002 Budget $500,000 - .1 4 -* 0 11 $0 rfM rm ER ~ 1-~ ~ ~ ~ ~ rl r# 1 0 Ret I j 1 1 i 1 -- C Il M & A g â‚¬ 1 0,52 0 0 on->O CO Â«covzo 2B-2 Year To Date Purchased Power $5,000,000 $4,000,000 $3,000,000 - -7- -- - 02001 $2,000,000 -7 -*FT ~- 1--- 8 2002 $1,000,000 m F " 2- 4- 3- 2- - - $0 n @~mul--1Mi ~ ; Â§,- f 1.2 & 5- *4 -00-U> -Du-a<S-:3Â£420:2 Customer Accounts $600,000 $500,000 $400,000 -2-F -- 02001 $300,000 r; 4_ I 4 K 92002 $200,000 1 -8 $100,000 7 rE [14[1-- E 1- 1- r M , 4 22- $0 c 2 b b > c E p 9. U k 4 2 E Â¥ 2 â‚¬ -2 <2 05 0 i Administrative & General $1,200,000 $1,000,000 - $800,000 - W = 3 _3* 02001 $600,000 _i 11. 4 1- r 1- - - 72002 $400,000 4 9- 4 4- d $200,000 $O EM |Mi|~ U 4' j dÂ·,-2 4, ~ C -0 4 k > CEO) â‚¬2~<2â‚¬-112&-33Â£* 2B-3 030 1 ~' 030 i#Fl Light Power Year To Date Distribution Maintenance $1,400,000 - $1,200,000 2-1-- $1,000,000 --- ---- - -9 1 1 $800,000 - -7--- E- - 4- 1- r 02001 - 8 $600,000 - - -- 1 - 2- 1- - '- 192002 $400,000 $200,000 m i-[1--I~.*J *c k r K 3 2 & 32 Ar le IE fr &1 34 8 2 <COUZO 2B-3a 11 1 1 1 I 1 1 1 4 1 ! 1 4 1- 1 1 . i ' 1 t: Â·% 1: ./ ~ 1 I ..4 . 1 1. 1 O r â‚¬ '~ Ofr 00 1. 4 1 1 Â· 00 I N . 1- 4 Iii . . ' 1 - 1 : I .Â·. r < i 1 . *64, . :....: . 1 - t....;,1 i 1 1 1 . 6. I ; ; Â·. ...r i . ! I A . I 1 . . . . .. .. 1 .A i /1. 3 f - . - I 11' 1 1 1 1 - 1 1 1 MM INEUSAS Loadh99.xls 12/10/2002 080 AON . .100 des . 60Â¥ irtr le. unr ' . Â· Ae'Al . Jdv cle:1 uer 5. 2002-â€¢- - PURCHASE POWER-DEMAND f-Wt 39Â¥d 22000 - 21000 ------ -- - -------- - - ---------- 20000 --- ------- - - -- - - - - --- ------- -- -- - --- ----- - - - -- - ------ - ~------- 0002 L 0009L - -- 4 000910 TOWN OF ESTES PARK 19000 - Â·Â·Â·Â·Â·Â·Â·Â·Â·---Â· Â·Â·Â·---- Â·- 1 Â· 000+,L Â· Â·Â· - 0008 L 0 10 1 IO -IN I 10 1 3 14*6*%8*34**8***~s*$$***$8%8*8*%**4*~s@RE****Â§*%8%6%6 -i<~ i 1 = 1 -1 1 1 I ......... -' 1/*%...45...7....:55.:.' I 561*%4146*E//AK<*&f<k#eaft/#Fie*#asaudxf Li 1 i 19*14%4*914*148Â§8Â§&4$&asss*$$%8*&*$%******66- - 4 ll , 1 1 - : E**3*9*****%83/004%*$#ti/#4###0/#04'#00$4#.f#*0##i##i#~~040##f~/I##0#*I#00/~#44.ii#AA - 1 1 1 1 I l.. I I ., lik/'BEEkiyb..8(93%826'4%:i):-434.Â·>4>./2.4.2/Nigafsset<Â«S~:. 31%1/Rwi -ti,0- 6 1 If3*8*$*S**S%**Â§$66*$98%8****8Â§$*%8%**8*32 --14.:idi 111 1 -21--1= - 1 i ,~444444444444444Â»14Â«t-75- + 1 - ~ 9***48: :.**:M:*~ # .Y.:'f.Â£~F,%6-~ ~|~ -4%76Â«4~::::~~:~.%44%~:2 b-'~~~-~- - - \- e 1 1 1 - * Nt:Utt=th Le*****Â§$*$Â§8%:*Â§8Â§**Â§$**B***SN***= ~ *4.- 0 1 1 ....: I. li. .... + 42*3**Â§69%8%%*kÂ»Â§*%8*%8**$*********-~ I<-~~~ - 1 1-1,-,1 -~ ! 1 -- I t**%3*%*SMR***34$*kiS*%**Â§82*3****** 1%6~ 1 1 1 1 -- /V'/Â»/V<Â· . ,/Illj/\AÂ·Â»Â»liÂ·'A~ v'0/h Â»7Â· v, . AÂ« , Â· ,, . ,~ : ,Â»1Â· 6A /rllllz4/ll4llijl --. 1*~89*6666$9*8%*3%%*6****%%%***%3%8**$$*$966*9%*%8%* 3-- i 1 $ * '-3 - - i 4 Loadh99.xls 12/10/2004 LOOE0 1003 0 9-83 39Â¥d ''A . C\11 Â· 1-21 :: 19 X I ...2 .. 1. 1 IrMÂ»SeÂ«Â»NekÂ»%2Â§4**4**9Â§6 . 7.' ~~ir**%**4%92GGL.' FFCF~TCF~~~%%%2**%-W-<~6 1 . 3. . Dll i ~"+ -L 4-.14 i'r-"-""m""r,MM=bMmt- . ..1........... ..... ... '.t i:~s~~~<~<FT<~<~-<464Â«62<~~~.i-- -----F--F---<,i~#â€ž~##19â€žâ€žp- ~ "'li~%**Â§Â§Â§$$$*s***Â§*sh*Â§*Â§***94R*Â§*Â§4*4 i . .. 1 1 0 1 1, 4.44 . .. 91 P . 1 -- . 1 I. d t 4 , I. 1 4 V-'Â·%90%'47/.4747.wimmm.w.w/im.Â¥........mm.,i......v.w.i. i. min. via ':.Â·tÂ· L *Â§~*MiS*%**8*Â§9%$*i86$$$*S*%83% * 1.1.1 b 1 1. . .A -~Pg/&*J8AW&44#Aff*WAAYS*ASSA~ M-6444-6444444â€¢AWâ€¢444/404Â·4Â¥/ I.'â€¢44â€¢/r'r-,/, 1..... - ./. 1 1,:. 1**SM*$*9*8Â§8**%88*8Â§ 6 â€¢ .: 4 1 1 1 1 1 i ' 4. 1 6 - 1 : 91 1 1 1 1" 00.%0 3 0 M . 0 0 ; O 0 0 0 . 0 . 0 0 O 00 O Â·:,r - Â·Â· N . I .. pase40.Ind HAAIN alA I12000 - 02001 9/V, . - --/- 3.59% 42 I '. W.W.W. W.WAW./W.V.V.-.:~T.1.1~r*.~1/I.I~.1~./'.r~f~- :232:3333:333333:332333:233522:3~33~3~333:23:23.23235:253~ , 4.. *2. 1% 12 2 2~ , .....1, i '14 .... 400 01 A 1 1 ...L i 1. ..% r.. 1 -' 1 1 , ..f : 1, S ' 044: , / 4 1 I ! - Â·.â€¢ K Â· 1 1 P. Â· ~ . 1.-,2- 1 1 fill . 0. I i i 1,9--/ . I ,% 1.4 1 h I.:.. 1 - . e I . : . 1 2. 1 1 1 I ..1 tâ€¢ l. 9 - j #1 I : Â· ! AN:*:*am:N:*Par<*:AL//4%4WWa0lkY/144%%3?* r . I - .9.1 B It... . . 1 a m Â·Â· '4 . I . .m.. .1 ~i. t~ ~ Â·Â·Â· ~ ~fikT#:3::MiM*N:ffi::8:1%r, 11.m.Â·:4.Ir#9~~~& ~ '' ''Z..1.1.11'.1.11.1...1.'.11.-L--.lili.11 -lili.1,1 -1.1.1 - 111. 6*n*9 Â·T - 1 1 )- P*Â§@%529Â¥832*Â§*=%*07-4#2%avid.gam.- . 1 ": 1 11 LU 48*N@*m*mE~-0&1-1888*88 ' 1 1 .1 1 . . 1 . - I -- -,LUe*Â»4-+4*riee ;31 1 -3 tja % . 1 I .1 % I. N 4\&118#81*#119!18*4#11#119##**m*Wj#N#!t#li~11#11#11.8118!18#8#8#8#8#8######1#1#8#tii,. t4 i i L 1 1 ($) 931VS A-'H-1-NOMI SALEHIST.XLS 12/10/2002 .+1$...~41 080 ~ 1 .. AON des r. ~-:- .unr A., le'N Z idv , Jen uer 0,11' ... :1442., ,ff)$ ESTES PARK LIGHT AND POWER DEPARTMENT ECTRIC SALES BY MONTH 2-83 39Â¥d . 900,000 - Â· 000:009 Â·- 0007017 700,000 - - - 000'009 000'00Â£ .. 4 ' . -r ...7.4 h. V i Â¥ 11 16 ?0 r C\1 . 10 0 0 D 10 0 0 0 J 6 4 i : c.' cv cv m [Â£ co < 1 11 i '. | 1 1/ 1 - -1 1 1 1 g 1 --- -I--I-- i- :1 1 1 ill 1 ' 0 5 1 1 1___ .1 1. -4 1 - . e .CD A 1 1 1 ;../ S..1 1 4 / : *m {t : .~ 4 <><5 49.Â·-,r\6>639~<~11. ... I ': .. i L . Uk CE . 9 1- r. 1.1 & 1 00 , - -- :"- *,2 .â€ž w.2 4 ..... . ..44 - co -I ./ Ul 3 -1.: * LU 00 I 4 -- 1 1 1 -U. . . .4 1 1 , O 1 1 ' 8 CE : It 1, ...~ 3 I - - ' U.1. If 14. 1 . '11 . 1 1, 1 1 .. 2... . 1 1 11 - i i :* 1 , I '* '' i 1 7 0 1 1. :1'.. . 1 1 Â«AA.k Â·i. 1.1.1' 1 0. CL LU l 11 -1 1 4 ($) Sa-IVS 3140 01 8Â¥3* e q SALEHIST.XLS 12/10/2002 ESTES PARK LIGHT AND ARTMENT e. 7 4,f IC SALES 9,000,000 -- -* 8-81 39Â¥d 7,000,000 - ------------ Â·Â· Â·Â·---- .....---:,7,356,6-1.3~-- ~- --- 6,000,000 5,000,000 -- ----- -- --------- - 000'000'E -- -~ rt---- -- 000'000'Z -- - - ----- - 000'000' L *j -1 090 . ' ARN . 3 100 -Bnv 2 - - Inr *f unr XeIN i . idÂ¥ IBIN - cle3 uer 3 - ~ 3.11=YTD