Loading...
HomeMy WebLinkAbout1st Quarter Comcast Franchise Fee Rpt.Comcast~ Apri127, 2007 SENT VIA OVERNIGHT UPS Ms. Louie Rempher City of Auburn 25 West Main St Auburn, WA 98001 RE: Franchise Fee Report -First Quarter 2007 Dear Ms. Rempher: Comcast Cable P.O. Box 3042 Bothell, WA 98011 In accordance with our franchise agreement with the City of Auburn, please find enclosed the franchise fee report for First Quarter 2007. 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, .~ (,: G~~ ~. Ann Svensson Comcast - WA Market Encls. cc: Janet L. Tureen, Comcast Ken Rhoades, Comcast Terry Davis, Comcast Bradley & Guzzetta, LLC OPERATOR: City of Auburn Comcast Period from 1/1/07 - 3/ 31/07 19909 120th Ave NE, Suite 200 Bothell, WA 98011 FRA NCHISE FEE PAYMENT W ORKSHEET UNITS UNIT PRICE MONTHS IN GROSS FEE % FRANCHISE YTD REVENUE SOURCE (AVE OF PER) (EACH MO) PERIOD REVENUE FEE Installation-(Including Digital) 759 $16.06 3 36,590.57 5 1,829.53 1,829.53 Rate Card Pdce st4.oo Limited Cable Service* 14,416 $11.36 3 491,098.15 5 24,554.91 24,554.91 134.95 Expanded Cable Service* 11,955 $33.30 3 1,194,329.99 5 59,716.50 59,716.50 s+t.9a Special Interest (Digital)** 6,878 $18.09 3 373,278.84 5 18,663.94 18,663.94 sts.99 HBO Customers 2,391 tts.ee Showtime Customers 780 s~s.e9 Cinemax Customers 584 515.99 TMC Customers 513 x15.99 Starz! Customers 1,397 115.99 Encore Customers 713 Total Premium 6,377 $8.58 3 164,225.00 5 8,211.25 8,211.25 fJ.99•{44.95 Pay-Per-View 6,639 $7.69 3 153,244.48 5 7,662.22 7,662.22 st.to Standard Converters 30 sa.so Addressable Converters 177 sa.eo w se.so Digital Converters 10,071 sots Remote Units 10,045 Total Equipment 20,323 $0.03 3 1,866.58 5 93.33 93.33 TOTAL SERVICE/INSTALL INCOME 2,414,633.57 5 120,731.68 120,731.68 Advertising Revenue 128,173.95 5 6,408.70 6,408.70 Shopping Services 12,871.62 5 643.58 643.58 sJ.4s Guides 409 $3.39 3 4,162.94 5 208.15 208.15 Late Fees 21,729.70 1,086.49 1,086.49 Miscellaneous 5,275.54 5 263.78 263.78 TOTAL NON-SUBSCRIBER INCOME 172,213.75 5 8,610.69 8,610.69 Less Refunds/Bad Debts (62,779.60) 5 (3,138.98) (3,138.98) Plus Bad Debt Recovery 0.00 5 0.00 0.00 NET BAD DEBTS (-) (62,779.60) 5 (3,138.98) (3,138.98) TOTAL REVENUES 2,524,067.72 5 126,203.39 126,203.39 Franchise Fee Revenue 144,698.75 5 7,234.94 7,234.94 Adjustments* TOTAL DUE CITY 2,668,766.47 5 133,438.32 133,438.32 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 *** correction from 1st Qtr 2004 Send to: Prepared by: Ann Svensson ~ .,~" City of Auburn Authorized by: (, /7i ~£(i Title: Franchise Contrails Administrator Date: 28-Apr-07 FRANCHISE FEE -REVENUE .~ ` '.f. SECTION 1 -GENERAL INFORMATION ENTITY NAME: ENTITY NUMBER: FRANCHISE NAME: BILLING AREA: YEAR/TERM: DAYS DUE: FRANCHISE EXCLUSIONS: AUBURN P27 CITY OF AUBURN 8498 3400 0210 2007lQUARTERLY 30 DAYS Internet, Leased Access SECTION 2 -SUBSCRIBER REVENUE Descri lion JANUARY FEBRUARY MARCH QTR TOTAL BADDEBT/YVRITE-0FFS (22,040.62) (18,852.46) (18,991.63) (59,884.71) BASIC CABLE 151,985.75 150,357.46 152.891.43 455,234.64 BOTTOM OF THE BILL DISCOUNT - - - - DIGITAL CABLE 111.498.72 114,638.55 117,533.04 343,670.31 EQUIPMENT REVENUE 658.68 547.26 574.77 1,780.71 EXPANDED BASIC 363,402.55 373,877.47 377,760.05 1,115,040.07 FCC FEE REVENUE 711.07 715.06 805.94 2,232.07 FRANCHISE FEE REVENUE 44,499.32 45,187.85 44,929.38 134,616.55 GUIDE REVENUE 1,194.03 1,278.42 1,289.16 3,761.61 INSTALLATION REVENUE 10,436.94 13,297.14 10,861.55 34,595.63 LATE FEE REVENUE 7,675.00 6,449.70 6,295.00 20,419.70 INTERNET REVENUE EXCLUDED EXCLUDED EXCLUDED EXCLUDED OTHER REVENUE 527.26 723.39 1,386.61 2,637.26 PAY REVENUE 49,709.87 50,741.20 50,572.81 151,023.88 PAY PER VIEW REVENUE 45,476.17 51,720.61 46,359.21 143,555.99 UTILITY TAX - - - - SUBSCRIBER REVENUE TOTAL 765,734.74 790,681.65 792,267.32 2,348,683.71 SECTION 3 -ALLOCATED REVENUE JANUARY FEBRUARY MARCH QTR TOTAL SHOPPING COMMISSIONS 4,958.64 151.34 4,660.15 9,770.13 LEASED ACCESS EXCLUDED EXCLUDED EXCLUDED EXCLUDED OTHER COMMERCIAL LEASED ACCESS EXCLUDED EXCLUDED EXCLUDED EXCLUDED OTHER REVENUE 33.04 (337.27) (18.04) (322.27) TOWER & RENTAL INCOME 374.05 1,365.89 447.62 2,187.56 ALLOCATED REVENUE TOTAL 5,365.73 1,179.96 5,089.73 11,635.42 LOCAL ADVERTISING 29,681.83 31,475.83 29,880.55 91,038.21 NATIONAL ADVERTISING 10,649.12 8,053.00 10,003.13 28,705.26 BAD DEBT ON ADVERTISING (15.43) 23.84 (77.04) (68.63) ADVERTISING REVENUE TOTAL 40,315.52 39,552.68 39,806.64 119,674.84 SECTION 4 -TOTAL REVENUE $811,415.99 $831 414.29 $837,163.69 $2,479,993.97 SECTION 5 -FRANCHISE TAX % 5.00 % 5.00 % 5.00 Cable franchise fee 38,555.02 39,593.08 39,867.85 118,015.96 Ad sales franchise fee 2,01578 1,977.63 1,990.33 5,983.74 SECTION 6 -TOTAL FRANCHISE FEE DUE 5-10,570.80 $41,570.71 $41,858.18 $123,999.70 Amount Paid Over/U nder $123,999.70 .~ - - -.:...,.c ,.: '~~.. .i FRANCHISE FEE -REVENUE ;~ „~ SECTION 1 -GENERAL INFORMATION ENTITY NAME: ENTITY NUMBER: FRANCHISE NAME: BILLING AREA: YEAR/TERM: DAYS DUE: FRANCHISE EXCLUSIONS: AUBURN P27 CITY OF AUBURN 8498 3400 0010 2007/QUARTERLY 30 DAYS Internet SECTION 2 -SUBSCRIBER REVENUE Descri ion JANUARY FEBRUARY MARCH QTR TOTAL BADDEBT/WRITE-0FFS (793.96) (1,057.82) (1,043.11) (2,894.89) BASIC CABLE 12,114.38 12,215.48 11,533.65 35,863.51 BOTTOM OF THE BILL DISCOUNT - - - - DIGITAL CABLE 9,880.07 9,922.53 9,805.93 29,608.53 EQUIPMENT REVENUE 25.93 27.05 32.89 85.87 EXPANDED BASIC 26,354.86 26,568.16 26,366.83 79,289.87 FCC FEE REVENUE 55.08 54.12 58.12 167.32 FRANCHISE FEE REVENUE 3,412.76 3,373.96 3,295.46 10,082.20 GUIDE REVENUE 137.99 131.70 131.64 401.33 INSTALLATION REVENUE 743.33 725.71 525.90 1,994.94 LATE FEE REVENUE 490.00 410.00 410.00 1,310.00 INTERNET REVENUE EXCLUDED EXCLUDED EXCLUDED EXCLUDED OTHER REVENUE 188.89 25.00 25.00 238.89 PAY REVENUE 4,315.11 4,434.16 4,451.85 13,201.12 PAY PER VIEW REVENUE 3,238.98 3,467.70 2,981.81 9,688.49 UTILITY TAX - - - - SUBSCRIBER REVENUE TOTAL 60,163.44 60,297.75 58,575.99 179,037.18 SECTION 3 -ALLOCATED REVENUE JANUARY FEBRUARY MARCH QTR TOTAL SHOPPING COMMISSIONS 359.43 151.34 323.91 834.68 LEASED ACCESS 80.16 69.16 119.75 269.07 OTHER COMMERCIAL LEASED ACCESS - - - - OTHER REVENUE 2.39 (23.96) (1.25) (22.82) TOWER & RENTAL INCOME 27.11 97.04 31.11 155.27 ALLOCATED REVENUE TOTAL 469.10 293.58 473.52 1,236.19 LOCAL ADVERTISING 2,151.48 2,236.22 2,076.88 6,464.58 NATIONAL ADVERTISING 771.90 572.13 695.28 2,039.31 BAD DEBT ON ADVERTISING (1.12) 1.69 (5.35) (4.78) ADVERTISING REVENUE TOTAL 2,922.26 2,810.05 2,766.80 8,499.11 SECTION4-TOTAL REVENUE $63,554.79 $63,401.37 $61,816.31 $188,772.48 SECTION 5 -FRANCHISE TAX % 5.00 % 5.00 % 5 00 Cable franchise fee 3,031.63 3,029.57 2.952.48 9,013.67 Ad sales franchise fee 146.11 140.50 138.34 424.96 SECTION 6 -TOTAL FRANCHISE FEE DUE $3,177.74 $3,170.07 $3,090.82 $9,438.62 Amount Paid Over/Under $9,438.62