The URL can be used to link to this page

Home My WebLink AboutComcast FCC Forms 1240 & 1205Ccomcast Via UPS Next Day Air April I, 2008 Lorrie Rempher Information Services Director 25 West Main Street Auburn, WA 98001 RE: W A0096 Dear Lorrie Rempher Comcast Cable 183 Inverness Drive West Englewood., CO 80112 On behalf of your local Comcast Cable Communications, LLC-affiliated operator, enclosed are FCC Forms 1240 and 1205. The forms represent Comcast Cable Communications, LLC's annual tiling for adjustments to basic service, equipment and installation prices. Specific assumptions and details regarding the filings are in the enclosed Documentation Memos. The selected basic service price is in Attachment 2 of the Form 1240 entitled "Proposed Rate Structure". The calculated FCC Form 1240, line 19, maximum permitted rate and Line 110, operator selected rate are exclusive of the FCC Regulatory fees. Equipment and installation prices can be found in a separate attachment entitled "2008 Installation & Equipment Rates". We will implement equipment and installation prices that are lower than the maximum permitted rates calculated on FCC Form 1205. Comcast Cable Communications, LLC has chosen April 1, 2008 as its tiling date and plans to implement the attached basic service, equipment and installation price adjustments on or about July 1, 2008. Appropriate notice will be sent to you and cable subscribers prior to any adjustment in the basic service tier, equipment and installation prices. Please call me at (720) 267-2238 or your local Comcast Cable Communications, LLC-affiliated cable System Government Affairs contact, Janet Turpen at (425) 741-5750, if you have questions about the tiling. Respectfully, On Behalf of Comcast Cable Communications, LLC Robbin Pepper Director. Rates and Regulatory West Division cc: Janet Turpen hic. 114863D, FCC. Form 1240, FCC Form 1205 r? Attachment 1 FCC FORM 1240 - 2008 Summary of Maximum Permitted Rate Ileadend: H48631) Headend Name: KING COUNTY ! SFATTLF. [AMLI Basic A. Maxinllml Permitted Rate From Form 1240, Line 19. $ 13.24 B. Network Upgrade Add-on, Form 1235, Part 111, Line 4 1.16 C. Adjusted Maximum Permitted Rate S 14.40 WA-H4863_2K8RWB.xls \ Attachment 1 Attachment 2 FCC FORM 1240 - 2008 Proposed Rate Structure Headend: H4863D Headend Name: KING COUN'T'Y / SEATTLE. [Ah Service Rates Basic Operator Selected Rate S 14.40 Less FCC Regulatory Fee - Net Service Rate $ 14.40 Franchise Related Cost $ - On the 2008 Installation and Equipment Rates sheet attached to the FCC Form 1205 are the Operator Selected Rates for 2008. NOTE. Rates are exclusive of applicable franchise fees and FCC Regulatory fee. WA-114863_2K8RW13.xis Attachment 2 Federal Communications Commission Washington. DC 20554 FCC FORA 1240 UPDATING NIAXIN11'NI PERNII U YED RATES FOR REGULATED CABLE SERVICES Cable Operator: Approved by OMB 3060-0685 Name of Cable Operator CONICAST OF WASHINGTON IN' INC Mailing Address of Cable Operator 2316 S. S'L'ATE ST Cit State 71P Code TACOMA "'A 198405 YES NO 1. Does this filing involve a single franchise authority and a single community unit? X If yes, complete the franchise authority information below and enter the associated CUID number here'. YES NO 2. Does this filing involve a single franchise authority but multiple community units? X If acs. enter the associated Ct lDs below and complete the franchise authorih information at the bottom of this page 3. Does this filing invohr multiple franchise authorities? if yes. attach it separate sheet for each franchise authot-mr and include the following tranchuc authorm inliirmation with its associated CCID(s). Franchise Authority Information: Name of Local Franchising Authority SEE ATTACHED Mailing Address of Local Franchising Authority Cite State 71P Code Telephone number Fax Number 4. For what purpose is this Form 1240 being filed.? Please put an "\" in the appropriate box. a. Original Form 1240 for Basic Tier b. Amended Form 1240 for Basic Tier c. Original Form 1240 for CPS Tier d. Amended Form 1240 for CPS Tier TO 5. Indicate the one year time period for which you are setting rates (the Projected Period). 07/01/2008 06/30/2009 TO 6. Indicate the time period for which you are performing a true-up. 12/01/2006 11/30/2007 7. Status of Previous Filing_ of FCC Form 1240 (enter an "x" in the appropriate box) YES NO a. Is this the first FCC Form 1240 tiled in any jurisdiction" X b. Has an FCC Form 1240 been filed previously with the FCC? X If yes, enter the date of the most recent filing: 0 (mm?dd)y}°) YES NO c. Has an FCC Form 1240 been filed previously with the Franchising Authority'? If yes, enter the date of the most recent filing: 0451/2007 (mm/ddJ'yy) (nuniyy l (nun?yy ) Pagel FCC Form 1240 WA414863 2K8RWB.xls Microsoft Excel 5.0 Version July 1996 Multiple Franchise Authority Listing Headend #. H4863D Headend Name: AUBURN FCC ID Franchise Authority Information WA0096 LORRIE REMPHER B INFORMATION SERVICES DIRECTOR AUBURN 25 W. MAIN STREET AUBURN, WA 98001 WA0829 CITY ENGINEER AUBURN AUBURN, WA 98001 March/April 1, 2008 Page 1 of I i Federal Communications Commission Washington. DC 20554 8. Status of Previous Filing of FCC Form 1210 (enter an "x" in the appropriate box) Approved by OMB 3060-0685 YI S NO a. Has an FCC Form 1210 been previously filed with the FCC? X If yes, enter the date of the most recent filing: ttnm;'dd'yy) YES NO b. Has an FCC Form 1210 been previously filed with the Franchising Authority" X If yes, enter the date of the most recent tiling: 04/05/1995 (mm/dd'yyl 9. Status of FCC Form 1200 Filing (enter an "x" in the appropriate box) YES NO a. Has an FCC Form 1200 been previously filed with the FCC') x If yes. enter the date tiled (mm/ddtyy) 1'6S NO b. Has an FCC Form 1200 been previously filed with the Franchising Authority? X If y,es, enter the date filed: 08/15/1994 (mm/dd/yy) 10. Cable Programming Services Complaint Status (enter an "x" in the appropriate box) YES NO a. Is this form being filed in response to an FCC Form 329 complaint? X If yes, enter the date of the complaint: (mm ddyy) IL Is FCC Form 1205 Being Included %Nilh This Filing? 1'ES NO X 12. Selection of "Going Forward" Channel Addition Methodology (enter an "x" in the appropriate box) =Check here if you are using the original rules [MARKUP MFTHODI. =Check here if you are using the new. alternative rules [CAPS MFTI IODI. If using the CAPS METHOD. . have you elected to revise recovery for YES NO channels added during the period May 15, 1994 to Dec. 31, 1994? x 13. Headend Upgrade Methodology Operurur.% must certrJt to the, C bn mission their eltgthUtrp to tow this iggra,lr mrthodulu`r and mta,h an rympmrnt list antl deprrcwriun vOwduk, =Check here if you are a qualifying small system using the streamlined hcadend upgrade methodology Part I: Preliminary Information Module A: Maximum Permitted Rate From Previous Filing a b c d e Line Line Description Basic Tier 2 'Pier 3 pier 4 Tier 5 AI Current 61asimum Permitted Rate S 135264 Module B: a u c d e Line Line Description Basic Fier 2 Tier 3 1 ier 4 Tier 5 B I Average Subscribership For Truc-Up Period 1 13,503 B2 A%eraee Subscribership For True-Up Period 2 B3 Estimated A%era e Subscribershi For Projected Period 13.760 Module C: Inflation Information Line Line Description C l Unclaimed Inflation Operator SmtchtnL From 1210 To 1240 1 0000 C2 Unclaimed Inflation l!nrcenlatcd Operator Responding to Rate Complaint I Ol 'l to C3 Inflation Factor For True-Up Period I [Wks I] I !i_" C4 Inflation Factor For True-Up Period 2 (Wks I) I (,ooll C5 Current FCC Inflation Factor I uIo Page2 FCC Form 1240 WA-H4863_2K8RWB.xIs Microsoft Excel 5.0 Version Jul), 1996 Federal Communications Commission Washington. DC 211554 Module D: Calculating the Base Rate Approved by OMB 3060-0685 a b c d e Line Line Description Basic Tier 2 Tier 3 Tier 4 Wier 5 Dl Current Headend Upgrade Segment D' Current External Costs Segment 0 8772 D3, Current Caps Method Segment D4 Current Markup Method Scgmtent 0 1900 I ) Current Channel Movement and Deletion Segment (1 1262) D6 Current I rue-t I Segment 0 3672 D7 Current Inflation Segment - G5 01178 D8 Base Rate [AI-DI-D2-D3-D4-D5-D6-D7 12.9904 Part H: True-Up Period Module F.: Timing Information Line Line Description I I What I' pe of Prue-Lip Is Being Performed" (Answer "1" "'" or '3" See Instructions for a description of these types i 2 If "1", go to Module 1. If "2", answer E2 and E3. If "3", answer E2, E3, E4, and E5. 1 ' Number of Months in the 'Prue-Up Period I 12 I Number of Months between the end of True-l; p Period I and the end of the most recent projected Period 7 1 3 Number of Months in True-Up Period 1 Eligible for Interest 0 If 5 Number of Months'I'rue-U Period 2 Ineligible for Interest 0 Module F: Maximum Permitted Rate For True-Up Period 1 a b c it e Line Line Description Basic Tier 2 Tier 3 Tier 4 Tier 5 Fl Caps Method Segment For Irue-Up Period I ] Wks 11 - F2 Markup Method Segment For True-Up Period I [Wks 31 0 19011 F3 Chan Mvmnt Deletn Segment For True-Up Period I [Wks' 4.5] 1 1018) F4 7 rue-Up Period I Rate Eligible For Inflation [D8-Fl -F2-F3] 12 0786 F5 Inflation Segment for True-Up Period I [(F4'C3)-F4] 02746 F6 Headend Upgrade Segment For True-Up Period I [Wks 61 - F7 External Costs Segment For "[ruc-Up Period I [Wks 71 0.985.1 F8 True-Up Segment For'[rue-Up Period 1 0 3787 F9 Max Perm Rate for Prue-U Period I [F4-FS-F6 F7-1-8] 13 7174 Module G: Maximum Permitted Rate For True-Up Period 2 a b c d e Line Line Description Basic Tier 2 Wier 3 'Fier 4 Tier 5 G I Caps Method Segment For True-1 Ip Pciiod '_ [\\ k. 21 G2 Markup Method Segment For 1'ruc-Up P,:rlod 2 [Wks 31 G3 Chan Mvmnt Deletn Segment For I ruc-Up Period 2 [ Wks 4;5] G4 TLJ Period 2 Rate Eligible For Inflation [D8}F5-G1-G2+G3] (i5 Inflation Segment for [rue-Up Period 2 [(G4'C41-G4] (i6 Headend Upgrade Segment For'I'rue-Up Period 2 [Wks 6] G7 External Costs Segment For [rue-Up Period 2 [Wks 71 G8 True-Up Segment For I rue-Up Period _' (9 Max Perm Rate for lYuc-U Period ? G4-G5-G6-G7-G8 Page3 FCC Form 1240 WA-H4863 2K8RWB.xIs Microsoft Excel 5.0 Version July 1996 Federal Communications Commission Washington, DC 30554 Module H: True-Ur) Adiustment Calculation Approved by OMB 3060-0685 Line Line Description a Basic b c d e Tier 2 Tier 3 Tier 4 Tier 5 Adjustment For True-0 Period 1 III Revenue From Period 1 1,265 , 1 29 'S00 11' Revenue From Max Permitted Rate for Period 1 222 ,707. 8983 113 True-1 Jp Period I Adjustment [H2-H I] 14' .4'_0.35171 H4 Interest on Period I Adjustment 15 326 5711 1 Adjustment For True-U Period 2 li5 Revenue From Period 2 Eligible for Interest H6 Revenue From Max Perm Rate for Period 2 Ehetble For Interest 117 Period _' Adjustment Eligible For Interest [116-115] 118 Interest on Period'_ Adjustment )See instructions for formula) 119 Revenue From Period 2 Ineligible for Interest 1110 Revenue Front Max Perm Rate for Period 2 Ineligible for Interest H H Period 2 Adjustment IncliLiblc For Interest [H 10-1191 Total True-Up Adjustment 1112 Previous Remaining True-[ Adjustment H13 Total True-Up Adjustment 1113,114 A 117, F18-HI I-H12-G91 142 746 92281 FIN Amount of True-lJp Claimed For phis Projected Period 142 746 9128 i HIS Remaining frue-LpAdjustment[HI3-H 14 Part III: Projected Period Module I: New Maximum Permitted Rate a b c d e Line Line Description Basic Tier 2 Tier 3 'Tier 4 Tier 5 11 Caps Method Segment For Projected Period [Wks 21 - 12 Markup Method Segment For Projected Period [Wks 3] U IWO G Chan My mnt Dcletn Segment For Projected Pe nod ['Arks 4 51 (1 13411 14 Proj. Period Rate Eligible For Inflation [D8, F5, G5 I1 -12: 13] 12.3209 15 Inflation Segment for Projected Period [(14*C5)-I41 0.1269 16 Headend Upgrade Segment For Projected Period I Wks 61 - 17 External Costs Segment For Projected Period ['A'ks 71 1.0800 18 True-Up Segment For Protected Period (0,2892) 19 Max Permitted Rate for Protected Period [14-15-16-17-181 132386 110 Operator Selected Rate For Projected Period 5 14 40 Nuie: The murimumu permitted rare figures do mu take iitto account anv refund babidty you may lime. l/ you have previoush been ordered by the Comm osion or your load /rancht.smg authortty ro make refunds, you are not relieved of your obligation to make such refunds even t/ the permitted rate is higher than the conle.sted rate or your current rate. Certification Statement WILLFUL FALSE STATEMENTS MADE ON THIS FORM ARE PUNISHABLE. BY FINE AND/OR IMPRISONMENT (U.S, CODE I TILE 18. ICTION 1001), AND/OR FORFEITURE (U.S. CODE, TITLE 47, SECTION 503). I cerrilirrieat 4he dater it made in,ahis form are tnte and correct to the hest of my knowledee and belief. and are trade in eood faith. w aechter, Senior Page4 FCC Form 1240 WA-H4863 2K8RWB.xls Microsoft Excel 5 0 Version July 1996 Federal Communications Commission Washington, DC 20554 Worksheet 1 - True-Up Period Inflation For instructions, see Appendix A of Instructions For FCC Form 1240 Line Period FCC Inflation Factor lot Month 1 1 6740 l 02 Month 2 4 1740 103 Month 3 4 171b 1o4 Month4 41710 105 Month 5 2 6510 10o Month 6 2 6514, I i_17 Month 7 265% 10 Month S 1 031"-o 109 Month 9 1.0340 110 Month 1(_i 1.03% 111 Month 11 1.03°. 112 Month 12 1.03% 113 Average Inflation Factor for True-I!p Period I 1 0227 114 Month 13 115 Month 14 116 Month I 1 17 Month 16 1 18 Month 17 119 Month 18 1220 Month 19 121 Month 20 122 Month 21 123 Month 22 124 Month 23 125 Month 24 126 Average Intlation Factor for I rue-I:p Period 2 1 ii0(IU Approved By OMB 3060-0685 Page I FCC Form 1240 WA-H4863 2K8RWB xls Microsoft Excel 5.0 Version July 1996 Federal Communications Commission Washington, DC: 20554 Worksheet 3 - Markup Method True-Up Period, Basic Tier for instructions, see Appendix A of Instructions For FCC form 1240 Question 1 Indicate the period for which this worksheet is being used (Pill an " X' in the appropriate box ) Question 2 Indicate the tier for which this worksheet is being used (Put an " X' in the appropriate box ) Approved Bs OMB 3060-0685 True-Up Period Projected Period X Basic Tier 2 "Pier 3 'tier 4 Tier 5 X Question 3 How long is the first period, in months, for which rates are being set %? ith this %?orksheel' 12 Question 4 How lone is the second period. in months, for which rates are being set with this worksheet ine Period 301 Previous Month ,02 Month 1 1 2 3 4 5 6 7 Sum of Previous Sum of Current Average Per Channel Channels Total Cumulative Regulated Regulated Channels Adjustment Added Adjustment Adjustment Channels Channel 0.1900 34 34 76 0.0100 - - 0.1900 303 Month 2 33 33 76 0.0100 0.1900 104 Month 3 33 33 75 0.0100 0.1900 105 Month 4 33 33 75 0.0100 0.1900 3i16 Month 5 33 33 74 0.0100 0.1900 3(17 Month6 33 33 74 0.0100 0,19011 308 Month 7 33 33 74 0.0100 0.191111 301) Month 8 33 33 74 0.0100 0.1900 11 a Month 9 33 33 74 0.0100 - 0.1900 31 1 Month 10 33 33 74 0.0100 0.1900 1I_' Month 1I 33 33 74 0.0100 0.1900 313 Month 12 33 3 3 114 Average Period 1 Markup Method adjustment 74 0.0100 11.19(1[1 0.19110 315 Month 13 316 Month 14 ,17 Month I5 ! 8 Month 16 t!y Month 17 t i. Month 18 I Month 19 3?2 Month 20 t_3 Month 21 .4 Month 22 Month 23 3.6 Month 24 327 Average Period 2 Caps Method Adjustment Page I FCC Form 1240 WA-114863 2KBRWB xis Microsoft Excel 5.0 Version July 1996 Federal Communications Commission Washington, DC 20554 Worksheet 3 - Markup Method Projected Period, Basic Tier Far instructions, see Appendix A of Instructions For FCC Form 1240 Question I Indicate the period for which this worksheet is being used (Put an "X' in the appropriate box.) Question 2 Indicate the tier for which this worksheet is being used. (Put an "X" in the appropriate box) Approved By OMB 3060-0685 True-(lp Period Projected Period X Basic 1'ier 2 Tier 3 Tier 4 Tier 5 X 12 Question 3 How long is the first period, in months, for which rates are being set with this worksheet" Question 4 11o\v long is the second period. in months, for which rates are being set with this worksheet? X!:? 1 2 3 4 5 6 Sum of Previous Sum of Current Average Per Channel Channels 7btal Cumulative Line Period Regulated Regulated Channels Adjustment Added Adjustment Adjustment Channels Channel Prc?iaus 301 f1.I900 Month 302 Month 1 33 33 74 0.0100 11.19011 303 Month 2 33 33 74 0.011111 11.1900 304 Month 3 33 33 74 0.1111111 0.1900 305 Month 4 33 33 74 0.0100 0.1900 306 Month 5 33 33 74 0.0100 0.191111 307 Month 6 33 33 74 0.0100 11.19011 308 Month 7 33 33 74 0.0100 11.1900 309 Month 8 33 33 74 0.0100 11.1900 3 I r i Month 9 33 33 74 0.0100 11.19110 I Month 10 33 33 74 11.0100 0.19110 312 Month I l 33 33 74 0.0100 0.191111 31 Month 12 33 33 74 11.11100 11.191111 314 Average Period 1 Markup Method Adjustment 11.191111 Page 1 FCC Form 1240 WA-H4863 2K8RWB xls Microsoft Excel 5.0 Version July 1996 Washington. DC 20554 TABLE. A. NON-EXTERNAL COST ADJUSTMENT FOR CI I:ANGHS IN CIIANNHLS Average Channels From 10 Adjustment per channel 7 7 $052 7.5 7.5 $0.45 8 8 $0.40 8 5 8.5 $0.36 9 $0.33 9 5 9.5 $0,29 Ili 10 $0,27 10.5 105 $024 11 11 S022 115 11 5 5020 12 12 S0 19 125 12.5 SO 17 13 13 $0 16 13 5 13.5 so IS 14 14 $0.14 145 145 $0.13 15 15 5 $0.12 16 16 $0 11 16.5 17 SO.10 175 18 $009 185 19 $008 19 5 21.5 $007 22 23.5 $0.06 24 26 $0.05 26 5 29 5 $0.04 30 35 5 $0.03 36 46 $0.02 46 ; 99 $0.01 Approved By OMB 3060-0685 Page 2 FCC Form 1240 WA-114863 2K8RWB.xls Microsoft Excel 5.0 Version July 1996 Federal Communications Commission Washington, DC 20554 Worksheet 4 - Residual True-Up Period For ulsuucuons, sec Appendix A oflnstructions For FCC Form 1241; Question I Indicate the period for which this worksheet is being used (Put an ' V in the appropriate box ) Approved By OMB 3060-0685 True-Lp Period Proiccted Period a b c d e Line Line Description Basic Tier 2 Tier 3 Tier 4 Fier 5 Period One 401 Average Permitted Charge 13.9792 4i12 Average External Costs 0.9854 iii, Average Total Per Channel Adjustments after 5(14/94 for Channels Added Using Caps Method 4U4 Average Tier Residual [401-402403] 12.9938 40 Average Channels per Regulated Tier 33.5000 406 Average Caps Method Channels per Tier 407 Average Remaining Channels [405-406] 33.5000 -tub Average Period I Per Channel Residual [40414071 0.3879 Kn 409 Average Permitted Charge 410 Average External Costs 411 Average Total Per Channel Adjustments after 5+14x'94 I-or Channels Added Using Caps Method 412 Average Tier Residual [409-410-4111 413 Average Channels per Regulated Tier 414 Average Caps Method Channels per Tier 415 Average Remaining Channels [413-314] 416 Average Period 2 Per Channel Residual [412,4151 Page I FCC Form 1240 WA-H4863 2K8RWB.xls Microsoft Excel 5.0 Version July 1996 Federal Communications Commission Washington. DC 20554 Worksheet 4 - Residual Projected Period Approved B% OMB 3060-0685 (?hlestion I Indicate the period for %chiCh tins ??or?sheet IS hcing used (Put :ut "X" in the appropriate boy l True-lip Period Projected Period X a b c d e Line Line Description Basic Tier 2 Tier 3 Tier 4 Tier 5 401 Average Permitted Charge 13.5264 402 Average External Costs 0.8772 401 Average Total Per Channel Adjustments after 5,14 for Channels Added Using Caps Method 404 Average Tier Residual [401-402-403] 12.6492 405 Average Channels per Regulated Tier 34.0000 406 Average Caps Method Channels per Tier 407 Average Remaining Channels ]405406] 34.0000 1408 Average Period I Per Channel Residual [404?407] 0.3720 Page 2 FCC Form 1240 WA-H4863 2K8RWB.xls Microsoft Excel 5,0 Version Jule 1996 Federal Communications Commission Washington, DC 20554 Worksheet 5 - Channel Movement and Deletion True-Up Period, Basic Tier Approved By OMB 3060-0685 For instructions, see Appendix A of Instructions For FCC Form 1240 Question 1. Indicate the period for which this worksheet is being used (Put an "X' in the appropriate box ) Trttc-Up Penod Projected Period X Question 2 Indicate the tier for which this worksheet is being used. (Put an "X' in the appropriate box ) Basic Tier 2 Mier 3 Tier 4 Tier 5 Question 3. How lung is the first period, in months, for which rates are being set with this worksheet` 12 Question 4 Ilow long is the second period. in months, for which rates are heow set wilt this worksheet` 0 ine Period 501 Previous Period 5022 Month 1 1 2 3 4 Net Per-Channel Cost Residual of Channels Deleted Residual of( hannels Moved Adjustment Cumulative Net Per- From Tier (added) to Tier Column Column 2 Channel Cost Adjustment mn I (0.7462) (0.7462) 503 Month 2 0.3879 (0.3879) (1.1341) 504 Month 3 - (1.1341) 505 Month 4 - - - (1.1341) 506 Months (1.1341) 507 Month 6 (1.1341) 508 Month 7 (1.1341) 509 Month 8 (1.1341) 510 Month 9 (1.1341) 511 Month I 0 (1.1341) 51' Month I 1 (1.1341) 513 Month 12 511 arerage Period 1 Channel Movement and Deletion :%djustment (1.1341) (1.11118) 515 Month 13 516 Month 14 517 Month 15 518 Month 16 519 Month 17 520 Month 19 521 Month 19 522 Month 20 523 Month 21 524 Month 22 525 Month 23 576 Month 24 527 Average Period 2 Channel Movement and Deletion Adjustment Page I FCC Form 1240 WA-H4863 2K8RWB xIs Microsoft Excel 5.0 Version July 1996 Federal Communications Commission Washington. DC 20554 Worksheet 5 - Channel Movement and Deletion Projected Period, Basic Tier Approved By OMB 3060-0685 For instructions, see Appendix A of Instructions For [-( C harm 1 _240 Question I Indicate the period for which this worksheet is being used (Put an "X" nt the appropriate box.) True-Up Period Projected Period for sshich this worksheet is beint used (Put an "X" in the Question 3 Ho%N long is the first period- in months, for which rates are heing set with this worksheet 12 Question 4 HOv1 long is the second period. in months. for which rates are being set will this worksheet' NIX I 2 3 4 Net Per-('hannel Cost Residual of Channels Deleted Residual of Channels Moved Cumulative Net Per-( hannel I.ine Period Adjustment 1Colunin 2 " Cost Adjustment From Tier (added) to Tier Column I SW Previous Period (1.1341) 502 Month 1 (1.1341) 503 Month 2 (1.1341) 504 Month3 (1.1341) 505 Month 4 (1.1341) 506 Month 5 (1.1341) 507 Month 6 (1.1341) 508 Month 7 (1.1341) 509 Month 8 (1.1341) 510 Month 9 (1.1341) 511 Month 10 (1.1341) 512 Month I 1 (1.1341) 513 Month 12 (1.1341) 514 Average Period I Channel Movement and Deletion Adjustment (1.1341) Page I FCC Form 1240 WA-114863 2h8RWB.xIs Microsoft Excel 5.0 Version July 1996 Federal Communications Commission Washington. DC 20554 Worksheet 7 - External Costs True-Up Period For instructions, see Appendix A of Instructions For FCC Form 1240 Question 1. For which time period are you filling out this worksheet? (Put an "X" in the appropriate hog Question 2. How long is the first period, in months, for which rates are being set with this worksheet? Question 3. How lone is the second period, in months. for which rates are being set with this %sorksheet° Approved By OMB 3060-0685 True-(1p Period Projected Period 12 0 a b c d e Line Line Description Basic 'Tier 2 'Fier 3 Tier 4 Tier 5 Period I External Costs Eligible for Markup Cost of Programming For Channels Added Prior 7111 to 5r1 1194 or After 5;15194 Laing Markup Method For Period 1 11.995 7324 7!12 Retransmission Consent Fees For Period - 703 Copyright Fees For Period 20,757 3240 704 External Costs Eligible For 7 54% Markup 132,653 064 705 Marked lip Extcinal Costs 142.602 0356 External Costs Not Eligible for Markup 706 Cable Specific Taxes For Period - 707 Franchise Related Costs For Period 708 Commission Regulatory Fees For Period 17.061) 5300 709 Total External Costs For Period 159.671-5656 Monthly. Per-Subscriber External Costs For 710 Period I 0 9854 Period 2 External Costs Eligible for Markup Cost of Programming For Channels Added Prior 71 I to i I' 93 or After 5+' I x94 Using Markup Method For Period 712 Retransmission Consent Fees For Period 713 Copyright Fees For Period 714 External Costs Eligible For 7 5% Markup 715 Marked Up External Costs External Costs Not Eligible for Markup 716 Cable Specific Taxes For Period 717 Franchise Related Costs For Period -is Commission Regulatory Fees For Period 719 Total External Costs For Period 720 ylonthh, Per-SuhscriIM I slern;rl Costs For Period 2 - Page I FCC Form 1240 WA-H4863 2K8RWB xls Microsoft Excel 5.0 Version July 1996 Federal Communications Commission Washington, DC 20554 Worksheet 7 - External Costs Projected Period For instructions, see Appendix A of Instructions For FCC Form 1240 Approved By OMB 3060-0685 Taste-Up Period Projected Period Question I For which time period are you filling out this worksheet" [Put an "X" in the appropriate box l X Question 2. How long is the first period, in months, for which rates are being set with this worksheet' 12 Question 3. How long is the second period. in months. for %Oich rates are being set ssith this worksheet' External Costs Eligible for Markup Cost of Programming For Channels Added Prior 701 to 515+94 or After i I S;'94 Using Markup Method For Period 129135 L59.1 7(t2 Retransmission Consent Fees For Period 71!3 Copyright Fees For Period 21,151 1034 7u4 External Costs Eligible For 7 V. Markup 150,286.762 705 Marked Up External Costs 161,558.2700 External Costs Not Eligible for Markup 706 Cablc Specific Taxes For Period - 707 Franchise Related Costs For Period - 708 Commission Reeulatorv Fees For Period 16,768 5000 709 Total External Costs For Period 178,326.7700 71 ti Monthh. Per-Subscnher External Costs For Period I 1,0800 Page 2 FCC Form 1240 WA-114863 2K8RWB xls Microsoft Excel 5 0 Version July 1996 Federal Communications Commission Washington, DC 20554 Worksheet 8 - True-Up Rate Charged For instructions, see Appendix A of Instructions For FCC Form 1240 Question I Hoer lone is the True-Up Period 1, in months" Question 2 I lo%% Ion, i, the Prue-1!p Period 2, in months" Approved By 0N413 3060-0685 12 0 a b c d e Line Line Description Basic Fier 2 Tier 3 Tier 4 'I ier 5 801 Month 1 S 14 3000 802 Month _ S 14 3000 803 Month 3 14 30011 804 Month 1 $ 14.30(x, 801 Month 14.3000 806 Month t, S 14 3000 807 Month 7 $ 14, 3000 808 Month 8 $ 135300 809 Month 9 S 1353OO 810 Month 10 $ 13 5301) 811 Month 11 $ 13 5300 812 Month 12 $ 13 5300 813 Period I Avcraee Rate $ 13 9792 814 Month 13 S' - 813 Month 14 816 Month 15 S 817 Month 16 $ 818 Month 17 $ 81 1; Month 18 $ 82o Month 19 $ 821 Month 20 $ 822 Month 21 $ 823 Month 22 S 824 Month 23 S 825 Month 24 826 Period 2 A\erage Rate $ Pagel FCC Form 1240 WA-H4863 2K8RWB.xls Microsoft Excel 5.0 Version July 1996 a N a pR -Z.?;? O?ppI /1pp???pp ?ptl ?p O?pp ???pp ???pp ?p?p ?J?pp ?110pp {?1Jpp?{?Ipp? ?{1Ipp? t?1lpp1 {?1Npp 13 3 10 10 101D 10101p?10101ptl?10 101010 tD 101D A ? LLNLNLliw iw;.+ N ?Dp?+1pp y4y???1pp }aaV (yyN?{yyV {Q?V?1?y?1? yy tD 10 L110 OD0100J? O I 0 0 0 z N t t ....._.T._.. _..... Q ADDITIONAL SER VICES Auburn, South King County, Federal Way, Covington, Maple Valley ..............1 ? a v Sea Tac, Black Diamond, Enumclaw, Normandy Park, Algona, Pacific 14.80 Boleti 14.01 Carnation, Fall city 15.27 Des Moines _ ._ _ _ _ _. »------.-_• .i 12.60 tssaquab. FTghlands _ .» _. »_ .» .r i tit 70 Kent. Tutwh 14.64 Renton 12.48 Renton (Sammamish)_. 13.1s Snoquabb, North Bend_ M49 Unincorporated Kira Coady • Lee Fells .. »» . ». . ----•--? 14.05 Newcastle, King Count (Issaquah) 12.60 long County, South Cove 13.15 Equipment Opti E9?h^1O^r P?? Pa+ monah. ons Remote Control (al types) 0.15 LWW CAN Customer Equipmerd' _ i 1.00- Standard Diglal Set Top Receive 3.50 Advanced FD Digital Set Top Receiver' » i d.0o 20 CAKARO for Mu4b CableCARO Device i 1.79 Charred Guide Magazine i 3.45 TUSUMS rdro sub9uDe b U*Ad able orly. 1 In coon cue; ft doge rrtr W w be disooAW at waived. Horne indal lion (Wvvd)_». __i 23.99 Home bstaltation (Unwired) ._._ i 33.93 Digital Self-Instaltatioo Kit (With Shipping) i 9.95 Digital Self4tstalation rA (Wiif?ad 94 4) » FREE Addui%W Connecdan at Time of Initial Fstal 12.99 Additional Connecion Requiring Separate Trip ?i 20.99 Move an Outlet 16.99 Hourly Service a" 30.99 Upgrade or DorWxk of Optional Savim (Ad m abls) i 1.99 Upgrade of optional Services Requiring SeparaU 14.99 Downgrade of Optional Services Requiring Separate TOp» .._._.»..-----i 1299 Conned VCR at Time of initial instal S 5.99 Corned VCR Requ "Separate Trip ._ . i 13.99 RecorWroclon of Service ... _ i 27.99 Service Call 19.99 Reactivate Video Sere/Equipment..___....... _..._ .............. ............ ....... .......i 119 Non-Sullkicnt Funds Ciwye ....................... Field Service Charge 15.00 Late Payment Charge 5.00 Purdiase AM Switch. .... 10.00 Unreturned Standard Sdt Top Recelm ...5 54.00 Unretumed Digital Set-Top Receiver (Model 700) _ _...... »»_ 5 96.00 Unreturned Digital Set-Top Receiver (Model 2000) 167.00 Um brined Digital Set-Top Receiver (Model 2500) 167.00 Unretumed HO Digital Set-Top Rec" (Model 5100) 336.00 Urnturned HO Digital Set-Top Receiver (Model 620O) 320.00 l nWrned HDYDVR Digital Set-Tap Recetm (Mott 3412) . 410.00 Urreturned W/DVR Digital Set-Top Recdver (Model 3416) 410.00 Unrdturned WAM Digital Set-Top Recdver (Model 6412) ._.»...» 465.00 Unn:Wrned Universal 6.40 Unreturned Digital Video Recorder Remote 6.65 Unreturned DCT Power Cord 1.15 Unteturned Wireless Phone Jack (Per Piece) 2100 Unretumed CableCARO...._.__..._. 90.00 B,qj G 30 FO-A,,,( 1a3j f !q, 30 1q, 3C) 13, 53 ATTACHMENT 2B Attachment 3A LM-T1 PR0.1 LNl-PRO.) CLS:4863 - ZZ FEDFRAL WAY Channel Information Dec-2006 I CII Ian-2007 T C11 Noe-2007 I CH .lu1-2008 I CH Jun-2009 I CII NWCN B 2 B 2 B 2 B 2 B -' KWPX B 3 B 3 B 3 B 3 B KONIO B 4 B 4 B 4 B 4 B 4 KING B 5 B 5 B 5 B 5 B 5 KONG B 6 B 6 13 6 B 6 B 6 KIRO B 7 B 7 B 7 B 72 , B 7 DSC-\A' B 8 B 8 B 8 B 8 B 8 KCIS B 9 B 9 B 9 B 9 B 9 K FW11 B 10 13 10 B 10 B 10 B 10 KSTW B II B 11 B I1 B II B II KBTC B 12 B 12 B 12 B 12 B 12 KCPQ B 13 B 13 B 13 B 13 B 13 KBC13 B 14 B 14 B 14 B 14 13 14 KHCV B 15 13 15 B 15 B 15 B 15 (PVC B 16 B 16 B 16 B 16 B 16 LEASEACC BS 17 BS 17 BS 17 BS 17 BS 17 HSN BS 17 13S 17 BS 17 BS 17 BS 17 KWDK B 18 B 18 13 18 B 18 B 18 HALLMARK-W B 19 13 19 B 19 B 19 B 19 KTBW B 20 B 20 B 20 B 20 B 20 GOV FACC B 21 B 21 B 21 B 21 B 21 GOV FACC B 22 B 22 13 22 13 22 B 22 FVW B 23 B 23 B 23 B 23 B 23 CSPAN B 24 B 24 B 24 B 24 B 24 CSPAN2 B 25 13 25 B 25 B 25 B 25 EDACC B 26 B 26 B 26 B 26 B 26 1,W1V B 27 B 27 B 27 B 27 B 27 FDAC'C B 28 B 28 B 28 B 28 B 28 Kt INS 13 29 B 29 B 29 B 29 B 29 KCTS+ B I- B I- B 75 B 75 B 75 U"'TV2 B 76 B 76 13 76 B 76 B PUBACC B 77 B 77 13 77 13 77 B TWC, B 78 B 78 B 78 B 78 13 E I NIVIS-W B 98 Cm 1 13 99 B 99 B 99 B 99 B 99 WA-H4863 2K8RWB.xls Attachment 3A Attachment 3B FCC FORM 1240 - 2008 Fieadcnd 1148(3D licadendNamc DING CA)UNTY_' SI ATTI.F. Ahtl_ Channel Line-Up Reconciliation Basic Number of Channels, Beginning of True-Up Period (Front Attachment 3) 34 Changes During True-Up Period (1) Number of Channels, find of True-Up Period 1 33 Number of Channels. Beginning of True-Up Period 2 (From Attachment 3) 33 Changes During True-Up Period 2 - Number of Channels, F.nd of True-Up Period 2 33 Number of Channels, Beginning of Projected Period 33 Changes During Projected Period Number of Channels. End of Projected Period 33 Summarv of Channel Changes Channel Date .Vomber Call Sign Channe! Name Tier Date Added Deleted Period 98 UNIVIS-W UNIVIS-W B 01;0112007 Tl' WA-114863 2K8RWB.xis Attachment 3B Attachment 4 FCC FORM 1240 - 2008 Headend: 114863D Headend Name: KING COUNT Y / SEATTLE [AM L] Basic Basic Basic Programming Programming Month Period Customers Effective Rate Cost Dec-2006 T-up 1 13,399 0.6755 9,051.0245 Jan-2007 T-up 1 13,346 0.6919 91234.0974 Feb-2007 T-up 1 13,387 0.6919 9,262.4653 Mar-2007 T-up 1 13,510 0.6919 9,347.5690 Apr-2007 T-up 1 13,528 0.6919 9,360.0232 May-2007 T-up 1 13,593 0.6919 9,404.9967 Jun-2007 T-up 1 13,570 0.6919 9,389.0830 Jul-2007 T-up 1 13,483 0.6919 9,328.8877 Aug-2007 T-up 1 13,472 0.6919 9,321.2768 Sep-2007 T-up 1 13,602 0.6919 9,411.2238 Oct-2007 T-up 1 13,578 0.6919 9,394.6182 Nov-2007 T-up 1 13,572 0.6919 9,390.4668 Jul-2008 Proj 13,677 0.7821 10,696.7817 Aug-2008 Proj 13,692 0.7821 10,708.5132 Sep-2008 Proj 13,707 0.7821 10,720.2447 Oct-2008 Proj 13,722 0.7821 10,731.9762 Nov-2008 Proj 13,737 0.7821 10,743.7077 Dec-2008 Proj 13,752 0.7821 10,755.4392 Jan-2009 Proj 13,767 0.7821 10,767.1707 Feb-2009 Proj 13,782 0.7821 10,778.9022 Mar-2009 Proj 13,797 0.7821 10,790.6337 Apr-2009 Proj 13,812 0.7821 10,802.3652 May-2009 Proj 13,827 0.7821 10,814.0967 Jun-2009 Proj 13,842 0.7821 10,825.8282 Basic Copyright Effective Basic Copyright FC'C' User Fee FCC User Fee Rate Cost Effective Rate Cost 0.1281 1,716.4119 - 0.1281 1,709.6226 - 0.1281 1,714.8747 - 0.1281 1,730.6310 - 0.1281 1,732.9368 - 0.1281 1,741.2633 - 0.1281 1,738.3170 - 0.1281 1,727.1723 - 0.1281 1,725.7632 - 0.1281 1,742.4162 - 0.1281 1,739.3418 - 0.1281 1,738.5732 - 0.1281 1,752.0237 - 0.1281 1,753.9452 - 0.1281 1,755.8667 - 0.1281 1,757.7882 - 0.1281 1,759.7097 - 0.1281 1,761.6312 - 0.1281 1,763.5527 - 0.1281 1,765.4742 - 0.1281 1,767.3957 - 0.1281 1,769.3172 - 0.1281 1,771.2387 - 0.1281 1,773.1602 - Total Programming Costs (Worksheet 7, Line 701) Basic Programming Cost True Up Period 1: 111,895.7324 True Up Period 2: - Projected Period: 129.135.6594 Basic Copyright 20,757.3240 User Fees WA414863 2K8RW'13.xis 21.151.1034 Attachment 4 J 7 Y COMCAST CABLE COMMUNICATIONS, LLC. FCC FORM 1240 PREPARATION DOCUMENTATION 2008 ANNUAL FILING This memo will serve to document, in general terms, the approach and assumptions used in preparing the 2008 annual filing of FCC Form 1240 for systems owned and/or managed by Comcast Cable Communications, LLC. Where an FCC Order or Public Notice applies, it is referenced by number. Questions about the mathematical calculations and formulas used in the Form 1240 and the Worksheets can be referenced in the "Instructions for FCC Form 1240." MODULE A - MAXIMUM PERMITTED RATE FROM PREVIOUS FILING Line Al The current maximum permitted rate equals the maximum permitted rate from the prior Form 1240, Line 19. MODULE B: SUBSCRIBERSHIP Line 1311132 The average subscribership for True-Up Period 1 is calculated by taking the average of the actual subscribers for each month of the True-Up Period indicated in Question 6 of FCC Form 1240. For systems with greater than 12 months of actual subscribers, Line 132 will also be completed using the same approach. Line 133 The estimated average subscribership for the Projected Period is calculated using historical subscriber growth for the most recent 12 months ending as of the last month of the True-Up Period. The historical growth percentage is then applied to the last month of actual subscribers to project subscribers through the end of the Projected Period indicated in Question 5 of FCC Form 1240. The Projected Period subscriber calculation may be adjusted in areas where seasonal fluctuations in subscribers are prevalent. MODULE C: INFLATION INFORMATION Line C3/C4 The inflation factor for the True-Up Period is calculated using the Gross National Product Price Index. The individual factors used for each month of the True-Up Period reflect the quarterly factors released by the FCC summarized as follows: uarter Months Covered Inflation 3Q06 Jul-06 - Sep-06 1.89% (FCC DA 06-2449) 4Q06 Oct-06 - Dec-06 1.67% (FCC DA 07-1570) 1Q07 Jan-07 - Mar-07 4.17% (FCC DA 07-3250) 2Q07 Apr-07 - Jun-07 2.65% (FCC DA 07-4153) 3Q07 Jul-07 - Sep-07 1.03% (FCC DA 08-65) 1 For recently acquired systems, the subscriber growth percentage is calculated using historical subscriber growth for the most recent period of actual data available. 2008-1240 (4/1/2008) MODULE C: INFLATION INFORMATION (continued) The appropriate inflation factor is entered on Worksheet 1 for each month of the True- Up Period and divided by twelve. The number 1.0 is then added to the result and entered on Line 113 of Worksheet 1. For systems with a True-Up Period 2 (greater than 12 months of actual data), Line C4 will also be completed using the same approach. MODULE G: MPR FOR TRUE-UP PERIOD 2 Module G is used to calculate the Maximum Permitted Rate (MPR) for True-Up Period 2. True-Up Period 2 will be completed when there are more than 12 months of actual data to be trued-up. Worksheets used to calculate the numbers used in Module G are attached to the Form 1240 as applicable. WORKSHEET 7 - EXTERNAL COSTS Line 707 Franchise related costs included on Line 707 are taken from Attachment 5, "Franchise Related Costs." The attachment provides information on how the franchise-related costs are calculated for each period, e.g., the type of cost being passed through and the number of months of recovery. WORKSHEET 8 - TRUE-UP RATE CHARGED Line 813 The True-Up Rate Charged reflects the actual rate charged included in the FCC Form 1240 calculation of the maximum permitted rate. Franchises with rate ordered rates on Line A I will have a corresponding reduction in the applicable Module D segment(s). For franchises that have paid refunds pursuant to a rate order, Line A I and Module D will match the rate ordered rates and the Worksheet 8 rate will match the rate ordered rate for the applicable months. Additionally, for franchises with FCC Form 1235, rates on Worksheet 8 will match Line Al per FCC Order DA 99-1779. 2008-1240 (4/l/2008)