The URL can be used to link to this page

Home My WebLink AboutComcast 4/1/2011 FCC form 1240 and 1205 Comcast® Comcast Cable 183 Inverness Drive West Englewood, CO 80112 Via UPS Next Day Air April 1, 201 1 Lorrie Rempher Information Services Director 25 West Main Street Auburn, WA 98001 RE: WA0096 Dear Lorrie Rempher: 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 filing 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 I10, operator selected rate are exclusive of the FCC Regulatory fees. Equipment and installation prices can be found in a separate attachment entitled "2011 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, 2011 as its filing date and plans to implement the attached basic service, equipment and installation price adjustments on or about July 1, 2011. 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 filing. Respectfully, On Behalf of Comcast Cable Communications, LLC Robbin Pepper Sr. Director, Rates and Regulatory West Division cc: Janet Turpen Enc. H 1751 L, FCC Form 1240, FCC Form 1205 ~ t Attachment 1 FCC FORM 1240 - 2011 Summary of Maximum Permitted Rate Headend: H1751L Headend Name: KING COUNTY / SEATTLE FAMLI Basic A. Maximum Permitted Rate From Form 1240, Line 19. $ 16.69 B. Network Upgrade Add-on, Form 1235, Part III, Line 4 - C. Adjusted Maximum Permitted Rate $ 16.69 WA-H1751 2KIIRWB.xls Attachment I Attachment 2 FCC FORM 1240 - 2011 Proposed Rate Structure Headend: H1751L Headend Name: KING COUNTY / SEATTLE [AN Service Rates Basic Operator Selected Rate $ 16.69 Less FCC Regulatory Fee - Net Service Rate $ 16.69 Franchise Related Cost $ - On the 2011 Installation and Equipment Rates sheet attached to the FCC Form 1205 are the Operator Selected Rates for 2011. NOTE: Rates are exclusive of applicable franchise fees and FCC Regulatory fee. WA-H 1751 2K 11 RW B. xls Attachment 2 Federal Communications Commission Approved by OMB 3060-0685 Washington, DC 20554 FCC FORM 1240 UPDATING MAXIMUM PERMITTED RATES FOR REGULATED CABLE SERVICES Cable Operator: Name of Cable Operator COMCAST OF WASHINGTON IV INC Mailing Address of Cable Operator 2316 S. STATE ST City State ZIP Code TACOMA IWA 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 yes, enter the associated CUIDs below and complete the franchise authority information at the bottom of this page: 3. Does this filing involve multiple franchise authorities? If yes, attach a separate sheet for each franchise authority and include the following franchise authority information with its associated CUID(s): Franchise Authority Information: Name of Local Franchising Authority SEE ATTACHED Mailing Address of Local Franchising Authority City State ZIP Code Telephone number Fax Number 4. For what purpose is this Form 1240 being filed? Please put an "X" in the appropriate box. a. Original Form 1240 for Basic Tier X 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/2011 06/30/2012 (mm/yy) TO 6. Indicate the time period for which you are performing a true-up. 12/01/2009 11/30/2010 (mm/yy) 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 filed 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 (mm/dd/yy) YES NO c. Has an FCC Form 1240 been filed previously with the Franchising Authority? X If yes, enter the date of the most recent filing 04/01/2010 (mm/dd/yy) Page 1 FCC Form 1240 WA-H1751 2K11RWB.xls Microsoft Excel 5.0 Version July 1996 Multiple Franchise Authority Listing Headend H1751L Headend Name: AUBURN FCC ID Franchise Authority Information WA0096 LORRIE REMPHER B BRADLEY & GUZZETTA, LLC ST PAUL 25 W. MAIN STREET ST PAUL, MN 55101 WA0829 CITY ENGINEER AUBURN AUBURN, WA 98001 March/April 1, 2011 Page I of I Federal Communications Commission Approved by OMB 3060-0685 Washington, DC 20554 8. Status of Previous Filing of FCC Form 1210 (enter an "x" in the appropriate box) YES NO a. Has an FCC Form 1210 been previously filed with the FCC? X If yes, enter the date of the most recent filing (mm/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 filing 04/05/1995 (mm/dd/yy) 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 filed: (mm/dd/yy) YES NO b. Has an FCC Form 1200 been previously filed with the Franchising Authority? X If yes, 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/dd/yy) YES NO 11. Is FCC Form 1205 Being Included With This Filing ? 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 METHOD]. Check here if you are using the new, alternative rules [CAPS METHOD]. 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 'NOTE: Operators must certift to the Commission their eligibility to use this upgrade methodology and attach an equipment list and depreciation schedule. =Check here if you are a qualifying small system using the streamlined headend 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 Tier 3 Tier 4 Tier 5 Al Current Maximum Permitted Rate S 15.7521 Module B: Subscribershi a b c d c Line Line Description Basic Tier 2 Tier 3 Tier 4 Tier 5 B1 Average Subscribership For True-Up Period 1 16,855 B2 Average Subscribership For True-Up Period 2 B3 Estimated Average Subscribershi For Projected Period 16,167 Module C: Inflation Information Line Line Description C l Unclaimed Inflation: Operator Switching From 1210 To 1240 1.0000 C2 Unclaimed Inflation: Unregulated Operator Responding to Rate Complaint 1.0000 C3 Inflation Factor For True-Up Period 1 [Wks 1] 1.0166 C4 Inflation Factor For True-Up Period 2 [Wks 1] 1.0000 1.0209 C5 Current FCC Inflation Factor Page 2 FCC Form 1240 WA-1-1175121(1 1RWB.xls Microsoft Excel 5.0 Version July 1996 Federal Communications Commission Approved by OMB 3060-0685 Washington, DC 20554 Module D: Calculating the Base Rate a b c d e Line Line Description Basic Tier 2 Tier 3 Tier 4 Tier 5 Dl Current Headend Upgrade Segment - D2 Current External Costs Segment 1.7767 D3 Current Caps Method Segment - D4 Current Markup Method Segment 0.2100 D5 Current Channel Movement and Deletion Segment (1.1341) D6 Current True-Up Segment 1.1237 D7 Current Inflation Segment + GS 0.0525 D8 Base Rate [A1-DI-D2-D3-D4-D5-D6-D7] 13.7233 Part II: True-Up Period Module E: Timing Information Line Line Description El What Type of True-Up Is Being Performed? (Answer "1", "2", or 9". See Instructions for a description of these types.) 2 If "1", go to Module L If "2", answer E2 and E3. If "3", answer E2, E3, E4, and E5. E2 Number of Months in the True-Up Period 1 12 E3 Number of Months between the end of True-Up Period I and the end of the most recent Projected Period 7 E4 Number of Months in True-Up Period 2 Eligible for Interest 0 E5 Number of Months True-Up Period 2 Ineli *ible for Interest 0 Module F: Maximum Permitted Rate For True-Up Period 1 a b c d e Line Line Description Basic Tier 2 Tier 3 Tier 4 Tier 5 Fl Caps Method Segment For True-Up Period 1 [Wks 2] - F2 Markup Method Segment For True-Up Period I [Wks 3] 0.2117 F3 Chan Mvmnt Delem Segment For True-Up Period 1 [Wks' 4/5] (1.1341) F4 True-Up Period 1 Rate Eligible For Inflation [D8+FI+F2+F3] 12.8008 F5 Inflation Segment for True-Up Period 1 [(F4*C3)-F4] 0.2125 F6 Headend Upgrade Segment For True-Up Period I [Wks 6] - F7 External Casts Segment For True-Up Period 1 [Wks 7] 1.8010 F8 True-Up Segment For True-Up Period 1 1.1227 F9 Max Perm Rate for True-Up Period 1 [F4+F5+F6+F7+F8] 15.9370 Module G: Maximum Permitted Rate For True-Up Period 2 a b c d e Line Line Description Basic Tier 2 Tier 3 Tier 4 Tier 5 GI Caps Method Segment For True-Up Period 2 [Wks 2] G2 Markup Method Segment For True-Up Period 2 [Wks 3] G3 Chan Mvmnt Deletn Segment For True-Up Period 2 [Wks' 4/5] G4 TU Period 2 Rate Eligible For Inflation [D8+F5+GI+G2+G3] G5 Inflation Segment for True-Up Period 2 [(G4*C4)-G4] G6 Headend Upgrade Segment For True-Up Period 2 [Wks 6] G7 External Costs Segment For True-Up Period 2 [Wks 7] G8 True-Up Segment For True-Up Period 2 G9 Max Perm Rate for True-Up Period 2 [G4+G5+G6+G7+G8 Page 3 FCC Form 1240 WA-HI7512K I IRWB.xls Microsoft Excel 5.0 Version July 1996 Federal Communications Commission Approved by OMB 3060-0685 Washington, DC 20554 Module H: True-Up Adjustment Calculation a b c d e Line Line Description Basic Tier 2 Tier 3 Tier 4 Tier 5 Adjustment For True-Up Period 1 Hl Revenue From Period 1 21960,749.3000 H2 Revenue From Max Permitted Rate for Period 1 3,223,421.1472 H3 True-Up Period 1 Adjustment [H2-Hl] 262,671.8472 H4 Interest on Period 1 Adjustment 32,982.7599 Adjustment For True-Up Period 2 H5 Revenue From Period 2 Eligible for Interest - H6 Revenue From Max Perm Rate for Period 2 Eligible For Interest H7 Period 2 Adjustment Eligible For Interest [H6-H5] H8 Interest on Period 2 Adjustment (See instructions for formula) H9 Revenue From Period 2 Ineligible for Interest H10 Revenue From Max Perm Rate for Period 2 Ineligible for Interest HI I Period 2 Adjustment Ineligible For Interest [H10-H9] Total True-Up Adjustment H12 Previous Remaining True-Up Adjustment - H13 Total True-Up Adjustment [H3+H4+H7+H8+H1I+H12-G8] 295,654.6071 H14 Amount of True-Up Claimed For This Projected Period 295,654.6071 H15 Remaining True-Up Adjustment [H13-H141 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 2] - 12 Markup Method Segment For Projected Period [Wks 31 0.2200 13 Chan Mvmnt Delem Segment For Projected Period [Wks 4/51 (1.1341) 14 Proj. Period Rate Eligible For Inflation [D8+F5+G5+I1+I2+13] 13.0217 15 Inflation Segment for Projected Period [(I4"C5)-14] 02722 16 Headend Upgrade Segment For Projected Period [Wks 6] - 17 External Costs Segment For Projected Period [Wks 7] 1.8736 18 True-Up Segment For Projected Period 1.5240 19 Max Permitted Rate for Projected Period [I4+15+I6+17+I8] 16.6914 1110 Operator Selected Rate For Projected Period $16.69 Note: The maximum permitted rate figures do not take into account any refund liability you may have. If you have previously been ordered by the Commission or your local franchising authority to make refunds, you are not relieved of your obligation to make such refunds even if the permitted rate is higher than the contested rate or your current rate. Certification Statement WILLFUL FALSE STATEMENTS MADE ON THIS FORM ARE PUNISHABLE BY FINE AND/OR IMPRISONMENT (U.S. CODE TITLE 18, SECTION 1001), AND/OR FORFEITURE (U.S. CODE, TITLE 47, SECTION 503). I certify that the stateme is ade in t is form are true and correct to the best of my knowledge and belief, and are made in good faith. Si ~ Date 104/01/2011 N e and Title o erson Comp eting this orm: dim Waechter, Senior Regulatory Rate Analyst Telephone number Fax Number (720)267-2263 (720)267-2715 Page 4 FCC Form 1240 WA-H 17512K I IRWB.xls Microsoft Excel 5.0 Version July 1996 Federal Communications Commission Approved By OMB 3060-0685 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 101 Month 1 0.50% 102 Month 2 1.08% 103 Month 3 1.08% 104 Month 4 1.08% 105 Month 5 1.91% 106 Month 6 1.91% 107 Month 7 1.91% 108 Month 8 2.09% 109 Month 9 2.09% 110 Month 10 2.09% III Month 11 2.09% 112 Month 12 2.09% 113 Average Inflation Factor for 1.0166 True-Up Period 1 114 Month 13 115 Month 14 116 Month 15 117 Month 16 118 Month 17 119 Month 18 120 Month 19 121 Month 20 122 Month 21 123 Month 22 124 Month 23 125 Month 24 126 Average Inflation Factor for 1.0000 True-Up Period 2 Page 1 FCC Form 1240 WA-H1751 2K11RWB.xIs Microsoft Excel 5.0 Version July 1996 Federal Communications Commission Approved By OMB 3060-0685 Washington, DC 20554 Worksheet 3 - Markup Method True-Up Period, Basic Tier For instructions, see Appendix A of Instructions For FCC Form 1240 True-Up Period Projected Period Question 1. Indicate the period for which this worksheet is being used. (Put an "X" in the appropriate box.) X Question 2. Indicate the tier for which this worksheet is being used. (Put an "X" in the appropriate box.) Basic Tier 2 Tier 3 Tier 4 Tier 5 X Question 3. How long is the first period, in months, for which rates are being set with this worksheet? 12 Question 4. How long is the second period, in months, for which rates are being set with this worksheet? 0 1 2 3 4 5 6 7 Sum of Previous Sum of Current Average Per Channel Channels Total Cumulative Line Period Regulated Regulated Channels Adjustment Added Adjustment Adjustment Channels Channel 301 Previous 0.2100 Month 302 Month 1 35 35 94 0.0100 0.2100 303 Month 2 35 35 94 0.0100 0.2100 304 Month 3 35 35 94 0.0100 - 0.2100 305 Month 4 35 35 94 0.0100 0.2100 306 Month 5 35 35 94 0.0100 0.2100 307 Month 6 35 35 94 0.0100 0.2100 308 Month 7 35 35 95 0.0100 0.2100 309 Month 8 35 35 96 0.0100 0.2100 310 Month 9 35 35 96 0.0100 0.2100 311 Month 10 35 35 95 0.0100 0.2100 312 Month l 1 35 36 96 0.0100 1 0.0100 0.2200 313 Month 12 36 36 96 0.0100 0.2200 314 Average Period 1 Markup Method Adjustment 0.2117 315 Month 13 316 Month 14 317 Month 15 318 Month 16 319 Month 17 320 Month 18 321 Month 19 322 Month 20 323 Month 21 - 324 Month 22 325 Month 23 326 Month 24 ,327 Average Period 2 Caps Method Adjustment - Page 1 FCC Form 1240 WA-H1751 2KI IRWB.xls Microsoft Excel 5.0 Version July 1996 Federal Communications Commission Approved By OMB 3060-0685 Washington, DC 20554 Worksheet 3 - Markup Method Projected Period, Basic Tier For instructions, see Appendix A of Instructions For FCC Form 1240 True-Up Period Projected Period Question 1. Indicate the period for which this worksheet is being used. (Put an "X" in the appropriate box.) X Question 2. Indicate the tier for which this worksheet is being used. (Put an "X" in the appropriate box.) Basic Tier 2 Tier 3 Tier 4 Tier 5 X Question 3. How long is the first period, in months, for which rates are being set with this worksheet? 12 Question 4. How long is the second period, in months, for which rates are being set with this worksheet? N/A 1 2 3 4 5 6 7 Sum of Previous Sum of Current Average Per Channel Channels Total Cumulative Line Period Regulated Regulated Channels Adjustment Added Adjustment Adjustment Channels Channel 301 Previous 0.2200 Month 302 Month 1 36 36 96 0.0100 - 0.2200 303 Month 2 36 36 96 0.0100 - 0.2200 304 Month 3 36 36 96 0.0100 - 0.2200 305 Month 4 36 36 96 0.0100 - 0.2200 306 Month 5 36 36 96 0.0100 - 0.2200 307 Month 6 36 36 96 0.0100 - 0.2200 308 Month 7 36 36 96 0.0100 - 0.2200 309 Month 8 36 36 96 0.0100 - 0.2200 310 Month 9 36 36 96 0.0100 - 0.2200 311 Month 10 36 36 96 0.0100 - 0.2200 312 Month 11 36 36 96 0.0100 - 0.2200 313 Month 12 36 36 96 0.0100 - 0.2200 314 Average Period 1 Markup Method Adjustment 0.2200 Page I FCC Form 1240 WA-H1751 2K1 IRWB.xls Microsoft Excel 5.0 Version July 1996 Federal Communications Commission Approved By OMB 3060-0685 Washington, DC 20554 TABLE A. NON-EXTERNAL COST ADJUSTMENT FOR CHANGES IN CHANNELS Average Channels Adjustment From: To: per channel 7 7 $0.52 7.5 7.5 $0.45 8 8 $0.40 8.5 8.5 $0.36 9 9 $0.33 9.5 9.5 $0.29 10 10 $0.27 10.5 10.5 $0.24 11 11 $0.22 11.5 11.5 $0.20 12 12 $0.19 12.5 12.5 $0.17 13 13 $0.16 13.5 13.5 $0.15 14 14 $0.14 14.5 14.5 $0.13 15 15.5 $0.12 16 16 $0.11 16.5 17 $0.10 17.5 18 $0.09 18.5 19 $0.08 19.5 21.5 $0.07 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.5 99 $0.01 Page 2 FCC Form 1240 WA-H1751 2KI IRWB.xls Microsoft Excel 5.0 Version July 1996 Federal Communications Commission Approved By OMB 3060-0685 Washington, DC 20554 Worksheet 4 - Residual True-Up Period 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.) True-Up Period Projected Period X a b c d e Line Line Description Basic Tier 2 Tier 3 Tier 4 Tier 5 Period One 401 Average Permitted Charge 14.6383 402 Average External Costs 1.8010 403 Average Total Per Channel Adjustments after 5/14/94 for - Channels Added Using Caps Method 404 Average Tier Residual [401-402-403] 12.8373 405 Average Channels per Regulated Tier 35.5000 406 Average Caps Method Channels per Tier - 407 Average Remaining Channels [405-406] 35.5000 408 Average Period 1 Per Channel Residual [404/407] 0.3616 Period Two 409 Average Permitted Charge 410 Average External Costs 411 Average Total Per Channel Adjustments after 5/14/94 for Channels Added Using Caps Method 412 Average Tier Residual [409-410-411 ] - 413 Average Channels per Regulated Tier 414 Average Caps Method Channels per Tier ,415 Average Remaining Channels [413-414] 1416 Average Period 2 Per Channel Residual [412/415] Page 1 FCC Form 1240 WA-H1751 2K11RWB.xls Microsoft Excel 5.0 Version July 1996 Federal Communications Commission Approved By OMB 3060-0685 Washington, DC 20554 Worksheet 4 - Residual Projected Period Question 1. Indicate the period for which this worksheet is being used. (Put an "X" in the appropriate box.) True-Up 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 15.7521 402 Average External Costs 1.7767 403 Average Total Per Channel Adjustments after 5/14/94 for Channels Added Using Caps Method 404 Average Tier Residual [401-402-403] 13.9753 405 Average Channels per Regulated Tier 35.0000 406 Average Caps Method Channels per Tier - 407 Average Remaining Channels [405-406] 35.0000 1408 Average Period 1 Per Channel Residual [404/407] 0.3993 Page 2 FCC Form 1240 WA-H1751 2KI IRWB.xIs Microsoft Excel 5.0 Version July 1996 Federal Communications Commission Approved By OMB 3060-0685 Washington, DC 20554 Worksheet 5 - Channel Movement and Deletion 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. (Put an "X" in the appropriate box.) True-Up Period 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 Tier 3 Tier 4 Tier 5 X Question 3. How long is the first period, in months, for which rates are being set with this worksheet? 12 Question 4. How long is the second period, in months, for which rates are being set with this worksheet? 0 1 2 3 4 Net Per-Channel Cost Residual of Channels Deleted Residual of Channels Moved Ad j Column 2 - Cumulative Net Per- Line Period J Channel Cost Adjustment From Tier (added) to Tier Column 1 501 Previous Period (1.1341) 502 Month I (1.1341) 503 Month 2 - (1.1341) 504 Month 3 - (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 11 (1.1341) 513 Month 12 (1.1341) 514 Average Period I Channel Movement and Deletion Adjustment (1.1341) 515 Month 13 516 Month 14 517 Month 15 " 518 Month 16 519 Month 17 520 Month 18 521 Month 19 - 522 Month 20 523 Month 21 524 Month 22 525 Month 23 - 526 Month 24 527 Average Period 2 Channel Movement and Deletion Adjustment Page 1 FCC Form 1240 WA-H1751 2K11RWB.xls Microsoft Excel 5.0 Version July 1996 Federal Communications Commission Approved By OMB 3060-0685 Washington, DC 20554 Worksheet 5 - Channel Movement and Deletion Projected 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. (Put an "X" in the appropriate box.) True-Up Period 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 Tier 3 Tier 4 Tier 5 X Question 3. How long is the first period, in months, for which rates are being set with this worksheet? 12 Question 4. How long is the second period, in months, for which rates are being set with this worksheet? NSA 1 2 3 4 Residual of Channels Deleted Residual of Channels Moved Net Adjustment CChannel Column 2ost - Cumulative Net Per-Channel Line Period l Column Tier (added) to Tier Column 1 Cost Adjustment - 0 501 Previous Period (1.1341) 502 Month 1 (1.1341) 503 Month 2 (1.1341) 504 Month 3 - (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 11 (1.1341) 513 Month 12 (1.1341) 514 Average Period 1 Channel Movement and Deletion Adjustment (1.1341) Page 1 FCC Form 1240 WA-H1751 2K11 RWB.xls Microsoft Excel 5.0 Version July 1996 Federal Communications Commission Approved By OMB 3060-0685 Washington, DC 20554 Worksheet 7 - External Costs True-Up Period For instructions, see Appendix A of Instructions For FCC Form 1240 True-Up Period Projected Period Question t. For which time period are you filling out this worksheet? [Put an "X" in the appropriate box.) 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 which rates are being set with this worksheet? 0- a b c d c Line Line Description Basic Tier 2 Tier 3 Tier 4 Tier 5 Period 1 External Costs Eligible for Markup Cost of Programming For Channels Added Prior 701 to 5/15/94 or After 5/15/94 Using Markup 109,313.6889 Method For Period 702 Retransmission Consent Fees For Period 199,570.3574 703 Copyright Fees For Period 29,974.7838 704 External Costs Eligible For 7.5% Markup 338,858.8301 705 Marked Up External Costs 364,273.2424 External Costs Not Eligible for Markup 706 Cable Specific Taxes For Period - 707 Franchise Related Costs For Period 708 Commission Regulatory Fees For Period 709 Total External Costs For Period 364,273.2424 710 Monthly, Per-Subscriber External Costs For 1.8010 Period 1 Period 2 External Costs Eligible for Markup Cost of Programming For Channels Added Prior 711 to 5/15/94 or After 5/15/94 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 718 Commission Regulatory Fees For Period 719 Total External Costs For Period 720 Monthly, Per-Subscriber External Costs For Period 2 Page 1 FCC Form 1240 WA-H1751 2KI IRWB.xls Microsoft Excel 5.0 Version July 1996 Federal Communications Commission Approved By OMB 3060-0685 Washington, DC 20554 Worksheet 7 - External Costs Projected Period For instructions, see Appendix A of Instructions For FCC Form 1240 True-Up Period Projected Period Question 1. For which time period are you filling out this worksheet? [Put an "X" in the appropriate box.] 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 which rates are being set with this worksheet? a b c d e Line Line Description Basic Tier 2 Tier 3 Tier 4 Tier 5 Period 1 External Costs Eligible for Markup Cost of Programming For Channels Added Prior 701 to 5/15/94 or After 5/15/94 Using Markup 110,349.4752 Method For Period 702 Retransmission Consent Fees For Period 199,028.7036 703 Copyright Fees For Period 28,751.3928 704 External Costs Eligible For 7.5% Markup 338,129.5716 705 Marked Up External Costs 363,489.2895 External Costs Not Eligible for Markup 706 Cable Specific Taxes For Period 707 Franchise Related Costs For Period 708 Commission Regulatory Fees For Period 709 Total External Costs For Period 363,489.2895 710 Monthly, Per-Subscriber External Costs For 1.8736 Period 1 Page 2 FCC Form 1240 WA-H1751 2KI IRWB.xls Microsoft Excel 5.0 Version July 1996 Federal Communications Commission Approved By OMB 3060-0685 Washington, DC 20554 Worksheet 8 - True-Up Rate Charged For instructions, see Appendix A of Instructions For FCC Form 1240 Question 1. How long is the True-Up Period 1, in months? 12 Question 2. How long is the True-Up Period 2, in months? 0 a b c d e Line Line Description Basic Tier 2 Tier 3 Tier 4 Tier 5 801 Month 1 $ 14.5200 802 Month 2 $ 14.5200 803 Month 3 $ 14.5200 804 Month 4 $ 14.5200 805 Month 5 $ 14.5200 806 Month 6 $ 14.5200 807 Month 7 $ 14.5200 808 Month 8 $ 14.5200 809 Month 9 $ 14.5200 810 Month 10 $ 14.5200 811 Month 11 $ 15.2300 812 Month 12 $ 15.2300 813 Period I Average Rate $ 14.6383 814 Month 13 $ - 815 Month 14 $ 816 Month 15 $ 817 Month 16 $ 818 Month 17 $ 819 Month 18 $ 820 Month 19 $ 821 Month 20 $ 822 Month 21 $ 823 Month 22 $ 824 Month 23 $ 825 Month 24 $ 826 Period 2 Average Rate $ Page I FCC Form 1240 WA-H1751 21(IIRWB.xls Microsoft Excel 5.0 Version July 1996 m m m M m m m m rn m a m rn m rn rn m ~n g S m m m S g$$ g g S o g S g g g g g g c~, 9 8 m m m m m m m m rn a a m o pp p p ~1 N M~ ~ N~ M M ~ m~ ~ N N ~ N ~ N Vf O N S OD b N t00 ~ VOf M M O m~ OD Q~~ N O Ta ~ N N N N N H N N N N N N N N H H N N H N N H H N N N N H N N H N ~`p~ y e dzyk g JJJ~fff bbb y i 2p2pPpS000~~~ ~ d p N egg u X E` 8 g w N N a' _ _ 'z 2~ (:J d 6Ek p Z _^m i e in ° oo $ Vpp X rv 91.~§E G N Eat W •GN n :NN2MM .-.FOM MiO ~ =C~ U ~C ~y~ L N N O 2 T u1 n H T N N C' fX,) 2 O d N Air BE 1= O S O 6U. O O vI 0 0E r y.i n i 6 : 0 ` m S f 3 a iZgRgR R r, H R € ~l N d .4.. q N i6 a O N N U D 'O C a ki ~ y Q 9 V tit, > VVy^ 9 L- N F= : p G O O O O r v u U u u Q ` d m IZ. g2 d d Fa 0~~ Q f 3 :c n Nm' v ~ p! ?~~i ry O O G 20' A i N G .a .Z .Z C m a H o o a go v g c~ u Q ~ 5~S i 3 o z `o $ v!}; c'G E c 12 c s ° Fo Fo N N N N N a A a na n S 3 t L. g c~ ~ 3E Y d O ~N t'` ~a L~HHI-OlO- N NNNN Of7. ~.O: O:dUL ¢g` & f C., c) L - v r N N N N .~.r s a Ana o A ? s Q c 2" .2 g o A z N z N a B rn~ o c c 4._ s>>>>> 0 0 c3 ° o» o o c0 0 0 0 ooco0.2 &a a Je 00 0 v ffi'^ q~o,o,o,s~oonooooo0o c v" og a~ g' d ° ° 0 3 3 0_> d g m a o 0 0 o x x x x x ~n x x x x 0 3 v 2c z~.g S'll x°~~~ c a v cg4+ a o o v c c o v d u Bi _`s ¢ s -3 3" Z c N c c c N rn U .2 d ~ E t E ~E E E E E E g g s z n a ` m z L° c o m of v '3 a `r9 u o m a3, e us LLJ 51 ~ 8~ °o m rn 3 e e Z 2 e a t+ d d m v d d d d d e i c 0 0 nno o ~ o 4 n o c c `c `c c c c `c `c `c `c c `c `c c c `c `c `c e'~ Q; VQ 8`P~ $ x o a a ~ x > > 0 8 v z N ~ N z 3 a ~ a > > > > > > > > > ~ > > > > > > > > > ~ a a y~ mm ~ mrn ma+wmmrnm m o m N N o ~°o,Ng~°c, ~°n, m m m g' ° ~i gi m m .e m m rn rn m m rn rn m H e > a ~ri m.v-~' N as O n vp o ao vi ui OrHMM H N w n u~ OOi, O~i• O: N N N N ci, qq T a 66 CN.7 W > O N H H N i zo ` ` z d ~ 'z s" EE a w z € N u>i ~~~4j Fn- ¢ r ¢ O E ~ ~ : F E G Z ~ x~ FF W o ~ J A g~ yyam. g ~ O Z Z Y O m W O O c L E r O: w Z O ; O wz DM an d oo N N N C & S ~ : ~ O t ~ V E 0 o o; 8 8 p UmNm m r r. iN&' n ~u9i O s v~ E n. ¢ x1€ 19 owNH Y a a u i d w o V~q ! ~u v 4 ¢O~ D! Q N i N i °Ji E 2 Z 4e 0 5c M. 6` c ~ 9 9 g'cxi ouF, O (=7 a E EtY 3 :jo H N C0 5 Oa L'ol M' 8 CZ OZ N J U C 5 O O C C COY) v0-O I zJ m o o a m s g P $ F c[ E$ c e o o g :e v rn d q~ pp pp a ZW ° w z z p ao a v~ r- x E +di < 40 i u Ao'^c~ Fi E y" c4i~ g' N N O o 0.2 Ec cDDO o o'c^ '_n ymy o °o q3~ _rn _rn me a~ rn~ E3og~ vv 'rnvN°N c N Q o i o _ O-' J N 2 U n C N N 1-A ? V Q J 2 Q W c m m 4~ L S 1- w K D O 5 r m m N v N v iD Cf tOD en i Q7 cn 01 Of: Q1 Oi m e- ~ v o ~a N. ~o n i Nw B N a N ¢ N N N t ~g n w 3 ~ ~ eu .u a 5, ~w~ cv a f w`t Zu~~~oSg' ~ ~ ~ f_r ~ o c r° u Q~z,Zwgpzi-zy~n~~ E w 3335 gx m Ei, cs`LL.J`+? z-~ o`ff' axo~~c~ .s t E coo ox v y~ Y c3 vovo o'im ?5 f1 a~o 10g NNt2if NuJ. Fx-~ N d YS 4 MQ:O~-NMV~n tOn mQ:Or-NMVN Ol 'SO C .1 toNO Nw d M On. N C N N N N Vmi N m ~ c nn`n°n-hh-nn-n-------I o ~9 m E ; ]L g~' ~ A~ Tai 9.~ 8 ~ i CF! 1 ° v e o » a s o o i g i.u? e, N q a t 3 ¢ a .n ~ cR a~rg9 v' Be88 ~ n * ~wW+ c~gQO~ p _ U 1 d d v Y C 0 * 3wee $uyy~N~ jows WZ>w g Ea F a a ^>ar s~ Z° ~{n Z -C,2 Xx. x>!0 1' _-4JJ0 tU U 3 E O C u ~U.~ >U x e. ¢w c~Q¢0 4 J 1E po4W1 d Ona ~5a`W gwZg Z zZ a 3E V Nw nm ®W3 NwJUN NNZJ C'Z F- 0Q Z _ O~ 00000000 4c n. toPmoo&cmi5c~>cz.: °c_ c z x22xx2xx q cJU:. o oN S~ ° i i E C d y~ y .i d d o~ m e Nary 7 o~MVV nmmo~~MV n en~ndmo v v v 0 9 Fit E$ g pp~p F 's ~vf ~n ~n ~nN~N V vii Vhf :.>t..K ~rv nrvnn nrr nn-----nnn-~ - C' Y Z C ~'Q XmUY]C i[JSN p ~ L B Y a 4N~ a+8 ~ 8: a Ott ou ul z ® 8 ® a e _ zF We d Js B ® Z ~ g A ~ G ~ W ~O . x~ Vj w ? U Y OU +B 8®B~NH "a Z. Z E -a c W- Z= E _ rOr d C m N Z LcU G U Q Q maw 28~a g8 5zyv ~ ~~~CC E a y 8 AwE JU c wvunn »wnnnn»»A a c 2 y ~ ~ d W ~d ~oE 7J~ g u g g r 5ww zo o a 3 a `c $ 1. L s 4E' 41 -0 A Y wg as LL 3 -~~w a > a o & LW 4= L 0 3H x v o»dw ommow~s, o$~l o ~wado in d~= a o~ N.a j'~8 i~ y z gymm- s. y q: 15's a: i E E- Po~Po y~pi~ L "13 n c 11 g o o U o s rb m N H Z lc1JJ G V Q a °m°$SSS° 888888888888~88888888~~ 88~~~8 ~5 g _H O O N N O M N O J g jr 6 16 Q N a N n N N f~ t0 N 1~ N O G g O f» to e» e» 1! 'i en vi ai w fn rn Fn w f» of of us ai » an e» ui ei .n es en w w en rn en rn en of «n g e E u E w J ;FED ~ s~ - i.q t i €FgS mug s N E 4 5 i`ma E 9*g~ E Z ~~03 Es o .4 a d': i00' WSm9 E$QES 5 a s Q°20 3 v qqq `,I saag-iI'~ x ~ o ~ o `b ~ C$ s~ 3a] p° i u~ O1L c - rs 5d V w a Y. c o o « ,am~e o > °S'g' m 9 E as~ _ _ a 'E Cn 6, 3 m - 23 12 o °E s o ml CL, M11 -,a 0 a4~ ~ ~ ~ ~ Z a o orb ~n vi 6 aiM cd c6 o 1 e u3 wea F»uiw ui en ~n U a L - k v'5 Y EM 6 4 g EF°Z~A ac z.. N~ ~_t~3Am -Ej ; o o c° " N -1>m y c ccn 31 m cn .y$yG~ C ` C p ° W C 1 jy HW Q 00~~$ to z EC, 7 p 7 7 7 c IVO. y.a~~~~~~c?O~O Attachment 3A TI LM-TI PROJ LM-PROJ CLS:1751 - KING COUNTY [JERROLD] Dec-2009 Oct-2010 Nov-2010 Jul-2011 Jun-2012 Channel Information T CH T CH T CH T CH T CH N WCN B 2 B 2 B 2 B 2 B 2 KWPX B 3 B 3 B 3 B 3 B 3 KOMO 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 B 6 B 6 B 6 KIRO B 7 B 7 B 7 B 7 B 7 DSC B 8 B 8 B 8 B 8 B 8 KCTS B 9 B 9 B 9 B 9 B 9 KMYQ B 10 B 10 B 10 B 10 B 10 KSTW B 11 B 11 B 11 B 11 B 11 KBTC B 12 B 12 B 12 B 12 B 12 KCPQ B 13 B 13 B 13 B 13 B 13 KBCB B 14 B 14 B 14 B 14 B 14 KFFV B 15 B 15 B 15 B 15 B 15 QVC B 16 B 16 B 16 B 16 B 16 HSN B 17 B 17 B 17 B 17 B 17 KWDK B 18 B 18 B 18 B 18 B 18 HALLMARK B 19 B 19 B 19 B 19 B 19 KTB W B 20 B 20 B 20 B 20 B 20 GOVTACC B 21 B 21 B 21 B 21 B 21 GOVTACC B 22 B 22 rB 22 B 22 B 22 TVW B 23 B 23 23 B 23 B 23 CSPAN B 24 B 24 24 B 24 B 24 CSPAN2 B 25 B 25 25 B 25 B 25 EDACC B 26 B 26 26 B 26 B 26 UWTV B 27 B 27 B 27 B 27 B 27 EDACC B 28 B 28 B 28 B 28 B 28 KUNS B 29 B 29 B 29 B 29 B 29 INDEPENDENT - KVOS B 72 B 72 B 72 B 72 KCTS+ B r7'18 5 B 75 B 75 B 75 B 75 UWTV2 B 6 B 76 B 76 B 76 B 76 PUBACC B B 77 B 77 B 77 B 77 TWC B B 78 B 78 B 78 B 78 LEASEACC B 79 B h79dl3 IB 79 B 79 B 79 JEWELRYTV B 96 B 96 B 96 B 96 CBUT B 99 B B 99 B 99 B 99 WA-H 1751 2K11RWB.xls Attachment 3A Attachment 3B FCC FORM 1240 - 2011 Headend: H 1751 L Headend Name: KING COUNTY / SEATTLE [AML] Channel Line-Up Reconciliation Basle Number of Channels, Beginning of True-Up Period (From Attachment 3) 35 Changes During True-Up Period I Number of Channels, End of True-Up Period I 36 Number of Channels, Beginning of True-Up Period 2 (From Attachment 3) 36 Changes During True-Up Period 2 - Number of Channels, End of True-Up Period 2 36 Number of Channels, Beginning of Projected Period 36 Changes During Projected Period - Number of Channels, End of Projected Period 36 Summary of Channel Changes Channel Date Date Number Call Sign ! Channel Name Tier Added Deleted Period 72 INDEPENDENT - KVOS INDEPENDENT B 10/0 1/20 10 TU i i I i i I I i III W A-H 1751 2K 11 R W B.xls Attachment 3B 6 h ~v ~ a U w W n . . . . . . . . . . . . . v m a w O ~t N O ~o O N o0 N N o0 ~O N 00 V O ~c N 00 d' O W N 00 00 Z 00 DD O W) N O r h M O oo " M^ 00 ~O X10 M N ,r0 vl ~O f~ O'~ R O O a1 N M C1 V O ~O N l- M~ O 'C 00 M O M 00 ^ i 01 r^ N N 1- N M M R Vi O N Wl 00 O M .n 00 B M M V ^ cV l~ N ~n N N_ r M oo M oo Q1 G0. U N ^ O oo .n ~o ~o V1 N O O 01 O, oo o0 r ~ 10 r- w) vl V1 vl V1 Vl Vl .n V V R V M M M M M M M U C l V N N N N N N N N N N N N N N N N N N N N N N N N U N N TS fYl N N N N N N N N N N N N N N N N N N N N N N N N _ oo o0 oo oo oo o0 o0 oo oo o0 oo oo o0 oo o0 oo o0 oo oo o0 oo o0 00 oo .y L G n o 0 0 0 0 0 0 0 0 0 o 0 C O o 0 0 0 0 0 0 0 0 0 W V M~oor~^ M .n r 0'~ r- m r- m O N '0pCO O oooo(~ O ~O00 VIn~oaoNN~OCDV^ lM- 0' G r r- r M V1 ~O C O O r Vl 00 T o0 r M O oo v1 N a, ~c m O N M oo V N~ O M n d O .n r-: - 00 - M r Vl m N N ~q o0 D, .y u fl) N oo N .n N ~n Vl C, M G M O r ~t N ' M O l~ V1 N 0 00 r- rl N O oo O, 1- 00 N a, N o0 .n ~O M o ~1 M O ~O M O M O Q u w) O O oc 17 ~ oo rl l, .n V <t V r r b vi .n .n V V 'vt I E C14 - - - - - - - - - - - - - - - N N U R: h y N~ oIn1010~o~o~o~o~c~oorno,rno,ornrnrnrnorno,orn rn O O O O O O O O O O 0 .n kn .n V1 'n Vl " .n .n .n .n .n .y n Q~ 0, C~ 01 C~ 0, 0, C~ N N N N N N N N N N N N 0, 0~ 0, a1 0., O, a, 13, O, 0 0 0 0 0 0 0 0 0 0 0 0 000000000000^-- - - U ~ ~ c v cl O N ^ O M .n 0~ N ~o 0, ,T oo N 10 O 'IT oo N 10 Cl ~t oo C, C, cl N O l~ ~O C V O N O oo m V' oo ~O 'n m N O o0 1- w) It N O to oc w) Z' N O V1 M oo 00 01 M N M V1 rn a, ON C, 01 a, o0 00 oo 00 00 00 .n .n v1 00 ~O Vl ~D V1 O oo ~O N O oo ~o "t N O w V 00 V1 N M V1 .r O~ 00 h N V1 I' Q~ M V \O oo O N M Vl ..Ur Ems" in M •y ~O 0\ D, c= M oo .n r o0 N O oo a, l- Vi ~ N O o^ 0 ~O .n M O c~ cd ° M M n n o 00 ^ N M N^^ O a O O 0, fl N N N N N^^ ~0 DOU o0 0; o; o; 0; a, 0~ oo rn a, w a a, a o, a a, o~ 0 C 0~ 0 a O O O ¢ ^ ^ ^ ^ o0 w o0 00 00 00 00 00 00 00 . 00 00 N N N N N N N N N N N N o0 oo 00 00 00 oo 00 00 00 00 00 oo ~.L~ i' n N V V V V V V ~0 ~o ~c ~o \o 10 ~O ~o ~o F ° 4. v v ~n n n n nv viv r`^rrrr•nr.nr".n n y o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 H O N V1 ^ O M .n ^ N ~D Q1 M^ a, r V1 M^ r V1 M N N u L 1~ M V 00 00 ~O R ^ 1~ w Vl ^ oo In N O1 O U y 0~ C ^ O a^ 00 .n h M M N N N^ 0 0 0 0~ t Rr Q, x~ 3 HHa - - - - - - - - - - - - - - - - - - - - - o E U b o a a a a a a a a a a a a 'o o 'o •o 'o 'o •o o 'o o 'o o e x x c ? ° ? ? 7 °"°aaap aaaaa aaa E C° y E-t~F-t~F-H[-Ht~N[~t~ E z L xi D, p O O O O O O r„ ^ .r ^ ~N-' Z cO~ p O O N N O N N O O N p N O O N O N N N N C4 cq c, C', rA rq -1 N c', N G. cc 7 7 6ai u o 7 U O c~0 O. C x 3 COMCAST CABLE COMMUNICATIONS, LLC. FCC FORM 1240 PREPARATION DOCUMENTATION 2011 ANNUAL FILING This memo will serve to document, in general terms, the approach and assumptions used in preparing the 2011 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 B1B2 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 B2 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 3Q09 Jul-09 - Sep-09 0.41% (FCC DA 10-1) 4Q09 Oct-09 - Dec-09 0.50% (FCC DA 10-366) 1Q10 Jan-10 - Mar-10 1.08% (FCC DA 10-1231) 2Q10 Apr-10 - Jun-10 1.91% (FCC DA 10-1914) 3Q10 Jul-10 - Sep-10 2.09% (FCC DA 10-2434) ' For recently acquired systems, the subscriber growth percentage is calculated using historical subscriber growth for the most recent period of actual data available. 2011-1240 (4/1/2011) 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 Al will have a corresponding reduction in the applicable Module D segment(s). For franchises that have paid refunds pursuant to a rate order, Line Al 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. 2 2011-1240 (4/1/2011)