Loading...
HomeMy WebLinkAboutComcast Franchise Fee Report - 2nd Quarter 2008Ccomcast. July 29, 2008 SENT VIA OVERNIGHT UPS Ms. Lorrie Rempher City of Auburn 25 West Main St Auburn, WA 98001 RE: Franchise Fee Report - Second Quarter 2008 Dear Ms. Rempher: Comcast Cable 15815 25th Ave. West Lynnwood, WA 98087 In accordance with our franchise agreement with the City of Auburn, please find enclosed the franchise fee report for Second Quarter 2008. The figures reported herein should be consistent with the franchise fee check you received from our corporate office in Denver, Colorado. If you have any questions about your franchise fee check or the attached report, please feel free to contact me at (425) 741-5752. Sincerely, Ann Svensson Comcast - WA Market Encls. cc: Danielle Daskam, City of Auburn Janet L. Turpen, Comcast Ken Rhoades, Comcast Terry Davis, Comcast Bradley & Guzzetta, LLC OPERATOR: City of Auburn Comcast 15815 - 25th Ave W Period From 4/1/08 - 6/30/08 Lynnwood, WA 98087 FRA NCHISE FEE PAYMENT WO RKSHEE UNITS UNIT PRICE MONTHS IN GROSS FEE % FRANCHISE YTD REVENUE SOURCE (AVE OF PER) (EACH MO) PERIOD REVENUE FEE Installation-(Including Digital) 781 $16.06 3 37,631.64 5 1 881 58 3 562 05 Rate Card Price , . , . $14.30 Limited Cable Service* $37 95 E d d C bl * 15,872 $10.84 3 515,984.25 5 25,799.21 49,828.92 . xpan e a e Service 13,175 $35.15 3 1,389,134.13 5 69,456.71 133 803 41 $14." Special Interest (Digital)** 10,042 $18.94 3 570,576.33 5 28,528.82 , . 53 092 10 $17." HBO Customers 2,920 , . $17.99 Showtime Customers 813 $17.99 Cinemax Customers 611 $17.99 TMC Customers 551 $17.99 Starz! Customers 1,662 $16.99 Encore Customers 248 $4.99644.95 Total Premium Pay-Per-View 6,806 49 893 $9.22 $1 21 3 3 188,216.07 5 9,410.80 17,985.55 $3.50 Standard Converters , 18 . 181,208.45 5 9,060.42 18,005.11 $3.50 Addressable Converters 42 $3.50to$8.00 Digital Converters 15,827 $0.15 Remote Units 15,664 Total Equipment 31,551 $0.00 3 393.65 5 19.68 66.09 TOTAL SERVICE/INSTALL INCOME 2,883,144.52 5 144,157.23 276,343.24 Advertising Revenue Shopping Services 192,870.89 5 9,643.54 17,511.66 $3.45 Guides 427 $3 55 3 27,041.65 5 1,352.08 2,187.05 Late Fees . 4,546.75 5 227.34 435.84 Miscellaneous 21,611.41 1,080.57 2,042.51 15,094.83 5 754.74 1,083.73 TOTAL NON-SUBSCRIBER INCOME 261,165.53 5 13,058.28 23,260.78 Less Refunds/Bad Debts (80,344.71) 5 (4,017.24) (6 264.28) Plus Bad Debt Recovery 0.00 5 0.00 , 0.00 NET BAD DEBTS (-) (80,344.71) 5 (4,017.24) (6,264.28) TOTAL REVENUES 3,063,965.34 5 153,198.27 293,339.74 Franchise Fee Revenue 160,215.38 5 8,010.77 15 138 76 Utility Tax Adjustments* 54.46 5 2.72 , . 2.72 TOTAL DUE CITY 3,224,235.18 5 161,211.76 308,481.22 EXPLANATORY NOTES: * All Limited and Expanded Basic Service revenues are recorded as Standard Cable, Bulk/Comm'I revenue category. ** This includes revenue for Digital Additional Outlets as well as Bulk/Commercial Additional Outlets Send to: Prepared by: An Svensson City of Auburn Title: Franchise Contracts Administrator Date: 30-Jul-07 FRANCHISE FEE - REVENUE Now- SECTION 1 - GENERAL INFORMATION ENTITY NAME. AUBURN ENTITY NUMBER. 776 FRANCHISE NAME: CITY OF AUBURN BILLING AREA 8498 3400 0010 YEAR/TERM: 2008/QUARTERLY DAYS DUE: 30 DAYS FRANCHISE EXCLUSIONS: Internet SECTION 2 - SUBSCRIBER REVENUE o uvrnii?-vrra BASIC CABLE (645.63) (1,101.16) --- (655.80 - ?^? ) (2.402.79 -mL ) (973.60) MAY (1 990 87) JUNE 1 67 pTRTOTAL BOTTOM OF THE BILL DISCOUNT 10,695.92 11,069.82 11,547.27 33,307.01 11,805.77 , . 12 254.92 ( , 4.18 47 529 46 ) (4,638.64 7 DIGITAL CABLE , , . 1,590.15 EQUIPMENT REVENUE 11,450.36 7 40 11,930.76 12,710.97 36,092.09 13,559.75 14,464.80 59 222.73 87 247 28 EXPANDED BASIC . 26,780.45 1.00 27 418.89 7.40 26 528 69 15.80 1.13 1.00 , 28. 0 , . 30.1 FCC FEE REVENUE 52.29 , 54.23 , . 58 05 82,728.03 29,481.50 30,720.35 119,833. 76 180,035.66 FRANCHISE FEE REVENUE 3,214.68 3 338 72 . 3 501 99 164.57 61.85 6525 246.74 373.84 GUIDE REVENUE 117.94 , . 126 98 , . 140 57 10,055.39 3,697.73 3,644.42 18,700.01 26,242.16 INSTALLATION REVENUE 1,279.81 . 1,385.47 . 1 520 51 385.49 141.79 149.01 443.89 734.69 LATE FEE REVENUE 343.56 323.46 , . 309 82 4,185.79 1,896.25 2,073.23 3,052.47 7,021.95 INTERNET REVENUE OTHER REVENUE EXCLUDED EXCLUDED . EXCLUDED 976.84 EXCLUDED 380.02 EXCLUDED 428.85 EXCLUDED 1,455.30 2,264.17 PAY REVENUE 51.68 4 0 447.41 917.30 1,416.39 895.49 860-44 EXCLUDED 2 655 34 EXCLUDED PAY PER VIEW REVENUE . 19.80 3 151.50 4,227.51 3 312 81 4,352.44 12,599.75 4,513.58 4.713.75 , . 18,312.76 4,411.26 27 540 06 UTILITY TAX , EXCLUDED , . EXCLUDED 2,934.85 EXCLUDED 9,399.16 EXCLUDED 3,942.54 3,152.31 15,366.05 , . 22,460.90 SUBSCRIBER REVENUE TOTAL 60,519.56 62,535.90 65 868 07 1 EXCLUDED EXCLUDED EXCLUDED EXCLUDED , . 88,923.53 69,403.79 70,737.46 285,172.35 425 313.61 SECTION 3 - ALLOCATED REVENUE JANUARY FEBRUARY MARCH QTR TOTAL , APRIL MAY JUNE pTR TOTAL SHOPPING COMMISSIONS LEASED ACCESS 311.38 45 64 385.73 41 46 496.84 1,193.95 472.39 523.85 2,283.49 3 279 72 OTHER COMMERCIAL LEASED ACCESS . . 25.36 717.41 12.96 14.53 57 16 , . OTHER REVENUE _ . 84.65 TOWER 8 RENTAL INCOME (16.02) 27 13 121.94 34.06 139.98 (34.32) 2.31 485.53 453 44 ALLOCATED REVENUE TOTAL 84! . 368 13 28.36 582 44 29.89 85.37 24.02 57.12 736.39 . 21754 . . 586.15 1,536.72 474.98 597.81 2,962.57 4 035.36 LOCAL ADVERTISING , NATIONAL ADVERTISING 2,108.69 2,433.29 3,049.53 7,591.51 2,724.06 3,416.50 14 311 80 BAD DEBT ON ADVERTISING 632.94 2 84 878.64 1,157.32 2,668.91 959.49 941.14 , . 4 886 62 20,452.35 6 7 ADVERTISING REVENUE TOTAL 84! . 2,744.47 (6.45) 3 305 48 (9.56) 4 1 (13.18) (52.74) 0.10 , . (30.16) , 87.44 (82 80) , . , 97.29 10,247.24 3,630.80 4,357.74 19 168.45 . 27 156 99 SECTION 4-TOTAL REVENUE S63 632 16 $66 423 81 70 , , . , . , . $ ,651.57 $200,707.49 $73 509 57 575 69101 , . , $307.303.37 5456,505.96 SECTION 5 - FRANCHISE TAX k 5.00% 5.00% 5.00% 5.0090 5.00% 5.0090 Cable franchise fee Ad sales franchise fee 3,044.38 137 22 3,155.92 1 3,322.71 9,523.01 3,493.94 3.566.76 14 406 75 21 467 45 . 65.27 209.86 512.36 181.54 217.89 , . 958.42 , . 1 357 85 SECTION 6 - TOTAL FRANCHISE FEE DUE 84! $3,181.61 $3 321.19 $3 532 58 , . Amour.; P;ic 849834000010 FFPMT , , . $10,035.37 $10 035 37 $3,675.48 $3,784.65 $15,365.17 $22,825.30 Over, Once, , . $0.00 $22,825.30 FRANCHISE FEE - REVENUE SECTION 1 -GENERAL INFORMATION ENTITY NAME: AUBURN ENTITY NUMBER: 776 FRANCHISE NAME: CITY OF AUBURN BILLING AREA 8496 3400 0210 YEAR/TERM: 2008/QUARTERLY DAYS DUE: 30 DAYS FRANCHISE EXCLUSIONS: Internet, Leased Access SECTION 2 - SUBSCRIBER REVENUE BASIC CABLE 84! (21.774.47) 148 (12,493.76) (8,324.33) (42,592.56) (24,363.76) (29,721.74) JUNE (21,620.56 QTR TOTAL ) (75 706 06 BOTTOM OF THE BILL DISCOUNT ,650.81 _ 148,905.97 149,730.41 447.287.19 146,922.59 147,186.35 150,285.16 , . ,394.10 444,394.10 DIGITAL CABLE EQUIPMENT REVENUE 149,639.39 151,906.46 153,627.78 455,173.63 156,679.25 160,006 47 166 643.33 483 329 05 EXPANDED BASIC 481.78 399,954.91 314.09 401 321 83 116.43 402 929 34 912.30 1 204 103.38 110.95 , 149.16 , 363.49 FCC FEE REVENUE 736 35 , . 740 75 , . 74 , ,206.08 401,030.26 400,306.84 407,761.42 1,209,098.52 FRANCHISE FEE REVENUE . 44,031.93 . 44 463 02 3.85 44 009 45 2,220.95 1 744.51 744.09 781.63 2,270.23 GUIDE REVENUE 1,244.05 , . 1 260 81 , . 1 279 69 32,504.40 44,311.06 44,020.22 45,641.94 133,973.22 INSTALLATION REVENUE 9,100.12 , . 10 056 46 , . 10 267 08 3,784.55 1,279.77 1,253.64 1,278.65 3,812.06 LATE FEE REVENUE 6,329.10 , . 5 904 05 , . 6 028 70 29,423.66 10,827.73 9.272.80 10,509.16 30,609.69 INTERNET REVENUE EXCLUDED , . EXCLUDED , . EXCLUDED 18,261.85 EXCLUDED 6,553.26 6,369.93 6,424.05 19,347.25 OTHER REVENUE 1,053.03 (143 43) 1 868 21 2 EXCLUDED EXCLUDED EXCLUDED EXCLUDED PAY REVENUE P 52,502.20 . 53,674.17 , . 52,718.90 ,777.81 158 895 27 1,953.68 53 256 33 2,432.63 3,652.98 8,039.46 AY PER VIEW REVENUE 58,834.99 61.619.04 49 040.47 , . 169 494 50 , . 54 30 53,086.51 54,333.14 160,675.96 UTILITY TAX _ , , . , 1.19 47,177.65 57,268.71 158,747.55 SUBSCRIBER REVENUE TOTAL 850,784.19 867,529.46 864 035.97 2 582 349 62 - 853 - 54.46 54.46 , , , . ,599.46 842,246.34 883,163.22 2,579,009.02 SECTION 3 -ALLOCATED REVENUE JANUARY FEBRUARY MARC H QTR TOTAL APRIL MAY JUNE OTR TOTAL SHOPPING COMMISSIONS LEASED ACCESS 4,689.78 385.73 6,862.97 11,936.48 6,189.06 6,472.74 7 659 83 20 321 63 OTHER COMMERCIAL LEASED ACCESS EXCLUDED EXCLUDED EXCLUDED EXCLUDED EXCLUDED EXCLUDED EXCLUDED , . EXCLUDED , . EXCLUDED OTHER REVENUE (241 22) EXCLUDED 1 763 46 EXCLUDED EXCLUDED EXCLUDED EXCLUDED EXCLUDED EXCLUDED TOWER & RENTAL INCOME . 408 54 , . 410 05 470.43 1,992.68 (450.63) 28.51 1,628.68 1,206.56 ALLOCATED REVENUE TOTAL 84! . 4,857.10 . 2 559 25 412.91 7 746 31 1,231.50 314.76 705.81 457.51 1,478.08 , . , . 15,162.66 6,053.20 7,207.06 9,746.03 23,006.28 LOCAL ADVERTISING NATIONAL ADVERTISING 31,759.05 35,188.70 42,124.31 109,072.06 35,689.80 42,214.67 48 008.07 125 912 54 BAD DEBT ON ADVERTISING 9,532.76 42 73 12,706.31 15,986.55 38,225.62 12,570.94 11,628.84 , 16,392.53 , . 40 592 31 ADVERTISING REVENUE TOTAL 84! . 41,334.54 (93.28) 47 801.73 (132.12) 57 978 74 (182.67) 147 1 (691.00) 1.22 101.18) ( , . 790 ) , , . , 15.01 47,569.75 53,844.73 64 299.42 165(713.90 SECTION 4-TOTAL REVENUE 5896 975 83 5917 890 43 5929 7 , . , . , 61.02 52,744,627.29 $907,222.40 S903,298.13 5957,208.68 52,767,729.20 SECTION 5 - FRANCHISE TAX % 5.00% 5.00% 5 00% . 5.00% 5.00! 5.00% Cable franchise fee 42,782.06 43,504.44 43,589.11 129,875.61 42 982 63 42 472 67 Ad sales franchise fee 2,066.73 2,390.09 2,698.94 7,355.75 , . 2 378.49 , . 2 692 24 44,645.46 130,100.77 SECTION 6-TOTAL FRANCHISE FEE DUE 84! $44,848.79 545,894.52 $46 488 05 $137 231 36 , 4 , . 3,214.97 8,285.70 Amount Paid 849834000210 FFPMT , . , . -.-_ -- . -- 5,361.12 5 545,164.91 547,860.43 $138,386.46