Loading...
HomeMy WebLinkAboutComcast 3rd Quarter Franchise Fee Report " . . @omcast~ Corneas! Cable PO, Box 3042 Bothell, WA 98041 sU'\\) - i 'I fil Cl r; ." ':.! " I" ".. li 0 October 28, 2006 SENT VIA UPS DanieIle Daskam City of Auburn 25 West Main St Auburn, W A 98001 RE: Franchise Fee Report - Third Quarter 2006 Dear Ms. Daskam: In accordance with our franchise agreement with the City of Auburn, please find enclosed the franchise fee report for Third Quarter 2006. 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) 398-6051. Sincerely, tlruejU!4v.M1J'L_ Ann Svensson Franchising Contracts Administrator Comcast - W A Market Encls. cc: Janet L. Turpen, Comcast Ken Rhoades, Comcast Terry Davis, Comcast (}e- ~tL/~ ))w ~,~ ;JW J{u~l;"- "; ~ OPERATOR: City of Auburn Comcast Period From 7/1/06 - 9/30/06 19909 120th Ave NE, Suite 200 BothelliWA!;!801,! FRANCHISE FEE PAYMENT WORKSHEET UNITS UNIT PRICE MONTHS IN GROSS FEE % FRANCHISE YTD REVENUE SOURCE (AVE OF PER) (EACH MO) PERIOD REVENUE FEE Installation-(Including Digital) 641 ..~$16.q~ 3 30,866.58 5 1,543.33 4,486.44 Rate Card Price '''1<'., Limited Cable Service* 13,240 $11.97 3 475,290.17 5 23,764.51 72,106.44 114.30 111.69 Expanded Cable Service* 11,835 $30.06 3 1,067,164.93 5 53,358.25 160,744.55 ~lt9~ Special Interest (Digital)** 6,176 $16.80 3 311,339.09 5 15,566.95 44,360.35 115.99 . HBO Customers 2,421 115.99 Showtime Customers 769 Cinemax Customers 598 TMC Customers 525 115.99" Starz! Customers 1,358 115.99 Encore Customers 776 Total Premium 6,447 $7.52 3 145,398.80 5 7,269.94 22,217.37 13.99.144.95 Pay-Per-View 5,797 $6.72 3 116,793.67 5 5,839.68 16,796.27 $1.10 Standard Converters 29 13.10 Addressable Converters 170 3.1010 6.50 Digital Converters 9,088 $0.15 Remote Units 8,980 Total Equipment 18,267 $0.03 3 1,721.67 5 86.08 408.27 TOTAL SERVICE/INSTALL INCOME 2,148,574.91 5 107,428.75 321,119.68 Advertising Revenue 145,925.87 5 7,296.29 22,209.06 Shopping Services 24,402.39 S 1,220.12 3,398.70 13.30' Guides 430 $3.31 3 4,264.31 5 213.22 626.09 Late Fees 11,908.70 595.44 1,715.92 Miscellaneous 3,938.42 5 196.92 678.70 TOTAL NON-SUBSCRIBER INCOME 190,439.69 5 9,521.98 28,628.48 Less Refunds/Bad Debts (52,690.00) 5 (2,634.50) (7,663.93) Plus Bad Debt Recovery 0.00 5 0.00 0.00 NET BAD DEBTS (-) (52,690.00) 5 (2,634.50) (7,663.93) TOTAL REVENUES 2,286,324.60 5 114,316.23 342,084.23 Franchise Fee Revenue 128,573.78 5 6,428.69 19,241.88 Adjustments* TOTAL DUE CITY 2,414,898.38 5 120,744.92 361,326.11 EXPLANATORY NOTES: i"An C(mite<iand~iJea.BaSIC ,Service revemJes arerecoraea"a'Sstiii'ijariJ'Cabie, 'auikiSOriiiTI t* This !pcludes rev~~ue for Digit~1 Additional Outlets as well as Bulk/CommerciaIAd~!tional Outle.\S L+lU L__ _ __ ~. d= ~'b ,- Send to: Prepared by: Ann s~nssoJn (~- 'lI'~/1 " City of Auburn Authorized by: Title: Franchise Contracts Administrator Date: 27-0ct-06 FRANCHISE FEE. REVENUE ~ ..' ~~-:;';i.-'t1:~~474~-h~~~"'~~~m~~~;_'-:t1i""~~:r~:;;?~~~~~~-f::;:r;i:'~~,;,~>,\:,~~~::.i::;'_';;.{fi':"".t-rZff0'i"~~~~.'':'-~~f,:~~~\~:t::1':tt;:~lF~r~/~:1i-~,'~i-~~;!2~W~~}~~~~~~<~,-t.~~~~1~~.~~~~1".:.';.o'\g SECTION 1 - GENERAL INFORMATlot ENTITY NAME: ENTITY NUMBER: FRANCHISE NAME: BilliNG AREA: YEARlTERM: DAYS DUE: FRANCHISE EXCLUSIONS: AUBURN P27 CITY OF AUBURfI 849834000010 2006JQUARTERL Y 30 DAYS SECTION 2. SUBSCRIBER REVENUE Internet Descriotion JANUARY FEBRUARY MARCH QrR TOT At APRil MAY JUNE arR TOT At JULY AUGUST SEPTEMBER QrR TOT At BAD DEBTlWRlTE-0FFS 84 (1.194.10) (231.37) (650.76) (2,07623) (591.39) (1,170.65) (829,18) (2,59123) (1,194.43) (1,766.22) (676.74) (3,637.39) BASIC CABLE 12,567.90 12,061.89 12,610.23 37,240.02 12,045.45 12,820.23 12.519.64 37,385.32 12,396.25 12,022.59 11,710.02 36,128.86 BOTTOM OF THE BILL DISCOUNT DIGIT At CABLE 7,526.03 7,687.24 8,043.41 23,256.68 8,038.34 8,217.82 8,347.02 24,603.18 8,470.36 6,562.74 8,641.22 25,674.34- BLANK FOR FORMATTING PURPOSES EQUIPMENT REVENUE 55.46 56.56 71.06 183.10 140.67 196.49 51.61 390.77 37.52 36.16 40.39 116.07 EXPANDED BASIC 23,956.99 24,539.10 24,918.21 13,414.90 24,608.43 24,696.16 24,766.35 74,072.96 24,441.19 24,116.43 24,29682 72,856.44 FCC FEE REVENUE 55.17 56.28 56.40 167.85 55.66 55.20 55.62 166.68 56.64 56.51 56.08 169.23 FRANCHISE FEE REVENUE 3,066.21 3,148.52 3,134.06 9,348.79 3,142.19 3,142.53 3,176.63 9,461.35 3,139.21 3,063.39 3,135.62 9,358.46 GUIDE REVENUE 140.12 137.00 135.82 412.94 135.30 137.40 140.49 413.19 136.45 130.91 131.52 400.68 INSTALLATION REVENUE 491.65 960.43 790.46 2.242.54 579.50 254.74 650.56 1,484.80 778.63 606.82 636.02 2,021.67 LATE FEE REVENUE 270.00 228.00 204.00 702.00 186.00 288.00 285.00 759.00 243.00 291.00 222.00 756.00 OTHER REVENUE 124.91 37.11 200.84 362.86 25.00 (4.00) 21.00 130.37 25.00 155.37 PAY REVENUE 3,716.52 3,754.01 3,953.93 11,424.46 3,910.42 3,894.16 3,634.25 11,638.63 3,626.39 3,740.69 3,633.74 11,402.82 PAY PER VIEW REVENUE 2,769.57 2,698.30 2,062.60 7,730.67 3,118.85 2,960.54 3,233.66 9,313.05 2,944.50 2,817.02 3,194.20 8,955.72 UTILITY TAX SUBSCRIBER REVENUE TOTAl 53,546.43 55,333.67 55,530.48 164,410.58 55,369.62 55,519.64 56,229.65 167,118.90 55.410.36 53,702.04 55,446.09 164,558.49 SECTION 3 - ALLOCATED REVENUE JANUAR'r FEBRUARY MARCH QTR TOTAL APRIL MAY JUNE eTR TOTAL JULY AUGUST SEPTEMBER eTR TOTAL SHOPPING COMMISSIONS 458.79 355.24 373.24 1,187.28 417.49 463.54 436.69 1,317.72 416.08 565.89 444.19 1,426.75 LEASED ACCESS 35.12 31.02 40.13 106.26 52.37 32.18 34.90 119.45 77.33 73.87 74.79 225.99 OTHER COMMERCIAL lEASED ACCESS OTHER REVENUE 128.69 31.79 10.53 171.01 7.15 38.17 40.67 85.99 106.23 (2.49) 48.46 152.20 TOWER & RENTAL INCOME 110.33 29.09 29.17 168.59 28.96 28.87 29.05 86.88 29.19 25.67 32.47 87.34 ALLOCATED REVENUE TOTAl 732.93 447.14 453.08 1,633.16 505.98 562.76 541.31 1,610.05 628.83 662.95 600.52 1,892.29 LOCAL ADVERTISING 2,514.44 2,205.79 2,454.07 7,174.30 3,284.85 3,399.59 2,564.93 9,269.36 2,740.89 2,078.32 2,344.49 7,163.71 NATIONAL ADVERTISING 936.33 496.78 686.78 2,119.90 716.09 839.56 925.80 2,483.45 1,121.75 744.25 1,184.49 3,050.49 BAD DEBT ON ADVERTISING (60.48) 137.11) 46.64 (50.95) (7.36) 4.53 (11.20) (14.04) 14.33 4.48 (10.31) 8.50 ADVERTISING REVENUE TOTAl 3,390.29 2,665.46 3,187.49 9,243.25 3,995.58 4,243.67 3,499.53 11,738.78 3,876,97 2,827.05 3,518.68 10,222.70 SECTION 4. TOTAL REVENUE $57.669.66 558,446.28 $59.171.05 $175.286.99 $59.871.17 560,32607 $60.270.49 $180,467.73 $59.916.16 $57.192.03 $59,565.28 $176.673.47 SECTION 5. FRANCHISE TAX ~ 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% Cable franchise fee 2,713.97 2,789.04 2,799.18 8,302.19 2,793.78 2,804.12 2,838.55 8,436.45 2,801.96 2,718.25 2,602.33 8,322.54 Ad sales franchise fee 159.51 133.27 159.37 462.16 199.78 212.18 174.98 566.94 193.85 141.35 175.93 511.13 SECTION 6. TOTAL FRANCHISE FEE OUI 84 $2,883.48 $2,922.31 $2.958.55 $8.764.35 $2.99356 $3.016.30 $3,013.52 $9.023.39 $2,995.81 $2,859.60 $2.978.26 $8,833.67 $8,764.35 $Q 073 ::IQ Amount Paid 849834000010 FFPMT OverlUnder *" ., FRANCHISE FEE - REVENUE It''~",'III~~~'''~.4'1\;;-'''i:i'~ik:,g;j!!''''''j~,,,,~,~,,,,,,~,~,,';;1C~,,,'ili:..~i;tt!I;"ai..u.<.'1.",.z<"'~,",.....i"ii<'fi".';;;:';'~J,.d;~;ill'::"';;,;&;~~~~'~~;.~~~~~"",'()'~~~~~~ SECTION 1 - GENERAL INFORMA. TIOP ENTITY NAME: ENTITY NUMBER: FRANCHISE NAME: BILLING AREA: YEARlTERM, DAYS DUE, AUBURN P27 CITY OF AUBURt. 8498 3400 0210 20061QUARTERl Y 30 DAYS FRANCHISE EXCLUSIONS: Internet. leased Access SECTION 2 - SUBSCRIBER REVENUE Desc.ription JANUARY FEBRUARY MARCH QTR TOTAL APRIL MAY JUNE QTR TOTAL JULY AUGUST SEPTEMBER QTR TOTAL BAD DEBTf\NRITE..QFFS 84 (15,638.08) (9,935.50) (8,396.67) (33,970.25) (16,540.38) (21,714.55) (23,696.01 ) (61,950.93) (20,733.13) (17,732.02) (10,587.46) (49,052.62) BASIC CABLE 146,264.93 148,531.01 149,336.98 444,132.92 150,109.63 146,300.56 149,669.96 448,080.37 145,691.49 146,011.97 147,451.65 439,161.31 BOTTOM OF THE BILL DISCOUNT DIGITAL CABLE 82.448.35 65,419.20 88,058.31 255,925.86 89,340.16 91,115.89 91,626.12 272,082.17 93,254.54 94,762.29 97,447.92 285,464.75 BLANK FOR FORMATTING PURPOSES EQUIPMENT REVENUE 979.90 687.65 2,058.97 3,726.52 759.23 685.06 698.95 2,143.24 554.24 515.19 536.17 1,605.60 EXPANDED BASIC 316,970.97 331,146.76 337,064.95 987,782.66 336,834.43 339,163.11 336,457.92 1,012,455.46 330,281.64 329,146.05 334,860.80 994,308.49 FCC FEE REVENUE 672.30 688.74 692.70 2,053.74 693.95 692.43 693.65 2,080.03 702.19 704.10 709.51 2,116.40 FRANCHISE FEE REVENUE 38,587.74 39,657.75 39,612.B5 117,858.34 40,075.11 39,925.77 39,594.54 119,595.42 39,547.87 39,334.02 40,333.41 119,215.30 GUIDE REVENUE 1,258.30 1,219.56 1,168.99 3,666.85 1,214.05 1,263.18 1,287.33 3,764.56 1,297.97 1,292.60 1,272.66 3,663.43 INSTALlATION REVENUE 8,374.86 9,287.28 10,149.37 27,811.51 9,129.65 9,377.51 8,816.21 27,323.37 7,674.54 11,210.54 9,959.83 28,844.91 LATE FEE REVENUE 3,560.64 3,315.00 3.294.00 10,169.64 3,495.00 3,561.00 3,723.00 10,779.00 3,744.00 3,624.70 3,764.00 11,152.70 OTHER REVENUE 245.71 532.36 2,558.53 3,336.60 566.02 260.49 620.38 1,446.89 264.01 612.03 601.38 1,497.42 PAY REVENUE 44,061.08 46,204.93 47,170.73 137,436.74 46,781.08 46,477.20 45,190.38 138,448,66 44,431.55 44,483.94 45,100.49 133,995.98 PAY PER VIEW REVENUE 30,640.24 35,209.98 28,749.75 94.599.97 38,958.11 31,789.27 36,740.56 107,487.94 36,660.09 30,572.23 40,405.63 107,837.95 UTILITY TAX SUBSCRIBER REVENUE TOTAl 660,426.94 692,564.72 701,539.48 2,054,531.12 701,416.24 690,896.94 691,422.99 2,083,736.18 683,597.60 684,517.84 711,896.19 2,080,011.62 SECTION 3. AUOCA TED REVENUI JANUAR't' FEBRUAR't' MARCH aTR TOTAL APRIL MAY JUNE aTR TOTAL JULY AUGUST SEPTEMBER aTR TOTAL SHOPPING COMMISSIONS 6,073.27 4,707.95 4,987.82 15,769.04 5,616.95 6,244.81 5,870.01 17,731.76 5,568.99 7,655.33 6,057.34 19,281.66 OTHER REVENUE 1,703.53 421.26 140.78 2,265.57 96.21 514.21 546.74 1,157.16 1,421.81 (33.64) 659.95 2,048.12 TOWER & RENTAL INCOME 1,460.53 385.54 389.76 2,235.84 389.65 388.99 390.48 1,169.12 390.75 347.33 442.23 1,180.31 ALLOCATED REVENUE TOTAl 9,237.33 5,514.75 5,518,36 20,270.44 6,102.81 7,148.01 6,807.23 20,058,05 7,381.55 7,969.02 7,159.52 22,510.09 LOCAL ADVERTISING 33,284.96 26,889.23 32.130.66 94,304.84 43,312.17 44,960.60 33,960.59 122,253.57 35,851.53 27,410.16 31,116.30 94,37799 NATIONAL ADVERTISING 12,394.70 6,583.70 9,177.79 28,156,19 9,661.22 11,310.50 12,444.79 33,416.51 15,014.16 10,068.17 16,130.86 41,213.19 BAD DEBT ON ADVERTISING (800.59) (491.78) 623.26 (669.11) (99.01) 60.97 (150.59) (188.63) 191.76 60.59 (140.37) 112.00 ADVERTISING REVENUE TOTAl 44,879.07 34,981.16 41,931.70 121,791.93 52,874.39 56,332.27 46,274.79 155,481.45 51,057.47 37,538.92 47,106.78 135,703.17 SECTION 4 - TOTAL REVENUE 5714.543.33 $733,06063 $746.989.53 $2196.593.50 $760,39345 $754.37722 $744.505.01 $2.259.275.67 $742.036.63 $730.025.77 $76616249 $2.238,22469 SECTION 5 . FRANCHISE T AX ~ 5.00% 5.00% 5.00% 5.00% 500% 5.00% 5.00% 5.00% 5.00% Cable franchise fee 33,483.21 34,9OJ.97 35,352.89 103,740.08 35,375.95 34,902.25 34,911.51 105,189.71 34,548.96 34,624.34 35,952.79 105,126.09 Ad sales franchise fee 2,243.95 1,749.06 2,096.59 6,069.60 2,643.72 2,616.61 2,313.74 7,774.07 2,552.67 1,876.95 2,355.34 6,785.16 SECTION 6. TOTAL FRANCHISE FEE DUl 84 $35.727.17 536,653.03 $37,449.48 $109,829.67 536,019.67 $37.718.86 $37225.25 $112.963.78 $37,101.83 $36,50129 $38.30812 $111.911.24 Amount Paid 849834000210 FFPMT $109,829.67 $112,963.76 O...erlUnder $0.00 ...~ --