Loading...
HomeMy WebLinkAbout2nd Quarter Comcast Franchise Fee ReportComcast July 3U, 2007 SF.\T ~'I.a O~ Elt\IGIi'1' l'I'S Ms. Louie Rempher City of Auburl ~~ Nest Main St .<\uburn, ~V ~~ ~)~UU I RL: Franchise Fee Report -Second Quarter 2007 Dear Ms. Rentphcr: In accordance with uur franchise agreement ~~~ith the City of Auburn, please find enclosed the franchise tee report for Second Quarter 2007. The ti~ures reported herein Should be consistent with the franchise fee check you received ti-om our corporate office in Denver, Colorado). I1~you have any questions about your Cranchise fee check or the attached report, please feel Gee to contact me at (425) 741-5752. Sincerely, -, ~~;,~ 1-~ :~nll S~'eI1SSOn Cl)meit)t - ~`':'~ h~1cu'ket ~nC1S. cc: Janet L. Turj~en, Comcast Ken Rhoades, Comcast Terry Davis, Comcast L3radlev & (;uzzetta, LLC OPERATOR: City of Auburn Comcast Period From 4/1/07 - 6/30/07 19909 120th Ave NE, Suite 200 Bothell, WA 98011 FRANC HISE 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) 843 ;16.06 3 40,619.08 5 2,030.95 3,860.48 Rau Card Pnu s+~.~o Limited Cable Service' 14,925 510.95 3 490,318.43 5 24,515.92 49,070.83 fN.95 Expanded Cable Service* 12,210 $33.08 3 1,211,641.81 5 60,582.09 120,298.59 511.99 Special Interest (Digital)*• 7,841 $16.58 3 390,015.49 5 19,500.77 38,164.72 s+s.99 HBO Customers 2,421 s+s.99 Showtime Customers 730 s+s.99 Cinemax Customers 545 5+5.99 TMC Customers 482 (15.99 Starz! Customers 1,402 s+s.99 Encore Customers 620 Total Premium 6,198 ;8.79 3 163,462.35 5 8,173.12 16,384.37 sa.99•su.9s Pay-Per-View 1,034 ;53.81 3 166,930.44 5 8,346.52 16,008.75 s+.+o Standard Converters 5 sa.so Addressable Converters 140 sa.aomu.so Digital Converters 12,013 so+s Remote Units 11,989 Total Equipment 24,147 50.02 3 1,412.44 5 70.62 163.95 TOTAL SERVICE/INSTALL INCOME 2,464,400.04 5 123,220.00 243,951.68 Advertising Revenue 168,996.71 5 8,449.84 14,858.53 Shopping Services 23,475.85 5 1,173.79 1,817.37 s~.~s Guides 66 ;20.59 3 4,045.01 5 202.25 410.40 Late Fees 21,405.00 1,070.25 2,156.74 Miscellaneous 7,886.74 5 394.34 658.11 TOTAL NON-SUBSCRIBER INCOME 225,809.31 5 11,290.47 19,901.15 Less Refunds/Bad Debts (71,118.70) 5 (3,555.94) (6,694.92) Plus Bad Debt Recovery 0.00 5 0.00 O.OU NET BAD DEBTS (-) (71,118.70) 5 (3,555.94) (6,694.92) TOTAL REVENUES 2,619,090.65 5 130,954.53 257,157.92 Franchise Fee Revenue 146,673.86 5 7,333.69 14,568.c Adjustments' TOTAL DUE CITY 2,765,764.51 5 138,288.23 271,/20.x. EXPLANATORY NOTES: • All Limited and Expanded Basic Service revenues are recorded as Stardard Cable, Bulk/Camm'I revenue category. •• This includes revenue for Digital Additional Outlets as well as Bulk/Commerdal Additional Outlets Send to: Prepared by: Ann Svensson City of Auburn Authorized by: ; . ~ri/1-L,. u~ ~--/>'~ ~~ Title: Franchise Contracts Administrator Date: 3U-)u1-07 FRANCHISE FEE -REVENUE SECTION 1 • GENERAL INFORMATION ENTITY NAME AUBURN ENTITY NUMBER: 776 FRANCHISE NAME CITY OF AUBURN BILLING AREA NtN 3400 0210 YEAR/TERM 200710UARTERLY DAYS DUE ]0 DAYS FRANCHISE EXCLUSIONS Int4met, lease0 Access Descri lion JANUARY FEBRUARY MARCH OTR TOTAL APRIL MAY JUNE OTR TOTAL YTD TOTAL BADDEBTNVRITE-0FFS 84 (22.040.62) (18,852.461 178.991631 (59.884711 (19.559.791 (23.160.111 (24,7Fi6.57) (67.486.41) (127,37172 BASIC CABLE 151,985.75 150,357.46 152,891 43 x55.234 64 151,458.79 153,428.51 152,203.93 457,091 23 9t2."s25 87 BOTTOM OF THE BILL DISCOUNT - - - - - - DIGITAL CABLE 11 1,49872 t 14,638.55 117,533.04 343,670.31 119.098.96 120,263.42 121,251.56 360,613.94 704.284.25 EOUIPMENTREVENUE 658.68 547.26 574.77 1.780.71 474.28 579.37 363.99 1,357.64 3,138.35 EXPANDED BASIC 363A02.55 373.877.47 377,760.05 1.115.040.07 377,492.72 379.866.51 377,502.39 1,134,867.62 7,249,901 69 FCC FEE REVENUE 71 t 07 715.06 BOS-94 2.232.07 817.34 847.90 850.96 2.546,2(1 4,778.21 FRANCHISE FEE REVENUE 44,499 32 45.787.85 41.929.38 134,676.55 45.606.06 45.854.23 45.481 80 136,94209 271,558 64 GUIDE REVENUE 1,194.03 7,278 a2 1,289 76 3.767.67 7,231.59 1,220.83 1.796.W 3.651.16 7,x1307 INSTALLITIONREVENUE 10,43694 13.297 t4 10,861.55 31.595-63 73.286.81 12.308.74 13.243.01 38.83856 73.x3479 LATE FEE REVENUE 7,675.00 6.H9.70 6,295-00 20.119.70 6.280.00 6.455.00 7,375.00 20.110.00 40,529 70 INTERNET REVENUE EXCLUDED EXCLUDED EXClUOED EXCLUDED EXCLUDED EXCLUDED EXCLUDED EXCLUDED EXCLUDED OTHER REVENUE 527.26 723.39 7,386.61 2,637.26 1,943.40 1,144.50 1,758.34 4,84624 7,483.50 PAV REVENUE 49.709.87 50,741.20 50,572.81 151,023.88 50,654.86 50.194.98 49,825.77 150,675.61 307,699.49 PAY PER VIEW REVENUE 45.476 t7 57,720.61 46.359.21 143.555.99 52,151.52 53.30130 51.855.03 157.307.85 300,863.84 UTILITY TAX _ _ _ _ - - - SUBSCRIBER REVENUE TOTAL 765,734.74 790,181.65 792,217.32 2,3Y,68].71 000,96!.54 802,24518 798,U1.31 2,401,]56.0] 4,750,0]9.74 SECTION 3 -ALLOCATED REVENUE JANUARY FEBRUARY PARCH OTR T07AL APRIL 11/1Y JUlE OTR TOTAL YTD TOTAL SHOPPING COMMISSIONS 4,958.64 151.34 4,660.15 9,770.13 7,736.59 4,536.67 6.192.88 18.166.15 28,236,28 I.EASEO ACCESS EXCLUDED EXCLUDED EXCLUDED EXCLUDED EXCLUDED EXCLUDED EXCLUDED EXCLUDED 1tYALUE! OTHER COMMERCIALLEASEOACCESS EXCLUDED EXCLUDED EXClUDEO EXCLUDED EXCLLIOED EXCLUDED EXCLUDED EXCLUDED tlVALUEt OTHER REVENUE 33.04 (337.271 (78.041 (32217) (262.04) (59.23) (349.44) (670.71 (992.99 TOWER 6 RENTAL INCOME 374 OS 1,365 89 ML62 2.187.56 2.691.75 424.71 820.04 3.936 50 6.724.07 ALLOCATED REVENUE TOTAL k S,]BS7] 1,17!.!6 3,089.73 11,11142 10,160.30 4,902.11 1,661.48 21,7]1.91 33,367.36 LOCAL ADVERTISING 29,681.83 31,475.83 29,880.55 91,038.21 43,440.75 42.846.43 34.488.80 120,77597 211,814.19 NATIONAL ADVERTISING 10.649.12 8.053.00 10,003.13 28,705.26 14,824.39 9.921.09 12.79x.09 37.539.58 66,244.84 BAD DEBT ON ADVERTISING (15 43) 23.84 (77.04) (68.63) (0.73) (12.76) (0.09) (12.99 (81.62) ADVERTISING REVENUE TOTAL 84' 40,]1S.S2 39,552.68 ]9,80i.F4 119,674.&1 58,285.Q/ 52,754.75 47,282.!!0 158,102.57 2'77,977.10 SECT10N4•TOTALREVENUE 5811,41599 5831.41x29 5837,16369 u.179.993.47 5869.40085 SB59.90209 5852.pB7.59 52.581,390 5,061,]84.50 SECTION S -FRANCHISE TAX % 5.009: 5.00°-° 5-00 ~ 5.00 ! 5.009. 5.00°: Cable tranch¢e lee 38.555.02 39,593.08 39.867.85 118.015.96 40.556.79 40.357.37 40.240.24 121,754.40 239,17035 Ad sales hanchcse lee 2,015 78 7.977.fi3 1.990 33 5.983 74 2.913.25 2.637]4 2.364 to 7.915.13 13.898.87 SECTION 1-TOTAL FRANCHISE FEE DUE 841 f40.570 80 541.57(1 71 541,858.18 5123.999.70 543 alp Ox 542.995 t0 542.60x_38 f 129.069 52 069.2 Amount Paitl MB634000210 FFPMT ' ~ I :~;- '~: ., :.~~y '0 Over/Urxfer So Od t"~ ~ S'~.~5..;os 53 FRANCHISE FEE -REVENUE SECTION 1 • GENERAL INFORMATION ENTITY NAME: AUBURN ENTITY NUMBER: 776 FRANCHISE NAME: Cn-Y OF AUBURN BILLING AREA- M!b 3400 0010 YEARlTERM: 2007IOUARTERLY DAYS DUE: 30 GAYS FRANCHISE EXCLUSIONS: Internet Descri lion JANUARY FEBRUARY MARCH OTR TOTAL APRIL MAY JUNE OTR TOTAL YTD TOTAL BADOEBTANRITE-0FFS 8! (793.96) (1,057.82) (1,043.11) (T,894,89) (1,847.66) (570.94) (1,213.69) (3,632.29) (6,52718) BASIC CABLE 12,114.38 12,215.48 11,533.65 35,863.51 11,487.83 10.753.98 10,985.39 33,227.20 fi9,090.71 BOTTOM OF THE BILL DISCOUNT - - - - - - - - - DIGITAL CABLE 9,680.07 9.922.53 9,805.93 29,608.53 9,866.24 9,808.67 9,726.64 29,401.55 59.010.08 EQUIPMENT REVENUE 25.93 27.05 32.89 85.87 22.10 21.95 10.75 54.80 740.67 EXPANDED BASIC 26,354.88 26,568.tfi 26,366.83 79,289.87 26.107.05 25,594.43 25.07877 76.780.79 156,070.06 FCC FEE REVENUE 55.08 54.12 58.12 167.32 62.09 62.23 60.20 184.52 351.84 FRANCHISE FEE REVENUE 3,472.76 3,373.96 3,295.48 10,082.20 3.296.45 3,273.36 3.16t_96 9.731.77 19.813.97 GUIDE REVENUE 137.99 731.70 131.64 401.33 129.24 129.76 134.55 393.55 794.88 INSTALLATION REVENUE 743.33 725.71 525.90 1,994.94 517.42 784.68 478.42 1,780.52 3,775.46 LATE FEE REVENUE 490.00 410.00 410.00 1,310.00 470.00 385.00 440.00 1.295.00 2,605.00 INTERNET REVENUE EXCLUDED EXCLUDED EXCLUDED EXCLUDED EXCLUDED EXCLUDED EXCLUDED EXCLUDED EXCLUDED OTHER REVENUE 188.89 25.00 25.D0 238.89 25.00 - 284]8 309.78 548.67 PAY REVENUE 4,315.11 a,a34.16 4,451.85 13.201.12 4,217.76 4,237.18 4,331.60 12,786.74 25,987.86 PAY PER VIEW REVENUE 3,238.98 3,467.70 2,981.81 9.688.49 3,330.94 3.399.39 2,892.26 9.622.59 19,311.08 UTILITY TAX - - - - - - - - - SUBSCRIBER REVENUE TOTAL 60,163.44 60,297.75 58,575.99 179,037.18 57,681.16 57,879-69 56,371.77 171,935.92 350,973.10 SECTION ] • ALLOCATED REYENUE JANUARY FEBRUARY MARCH OTR TOTAL APRIL NAY JUNE QTR TOTAL YTD TOTAL SHOPPING COMMISSIONS 359.43 151.34 323.91 834.68 534.36 305.27 408.64 7,248.27 2,082.95 LEASED ACCESS 80.16 69.16 119.75 269.07 126.31 90.46 55.39 272.16 541.24 OTHER COMMERCIAL LEASED ACCESS - - - - - - - - - OTHER REVENUE 2.39 (23.96) (1.25) (22.82) (18.10) (3.99) (23.06) (45.74 (6296) TOWER d RENTAL INCOME 27.11 97.04 31.11 155.27 185.92 28.58 54.11 268 61 423.87 ALLOCATED REVENUE TOTAL 84 469.10 293.58 473.52 1,236.19 828.49 420.33 495.09 1,743.90 2,980.09 LOCAL ADVERTISING 2,151.48 2,236.22 2,076.88 6,464.58 3.00041 2,883.12 T.275.77 6.159.30 14,623.88 NATIONAL ADVERTISING 771.90 572.13 695.28 2,039.31 1,023.91 667.59 844.23 2.535.72 4,575.03 BAD DEBT ON ADVERTISING (1.12) 1,69 (5.35) (4.78) (0.01) (0.86) (0.01) (0.87) (5.65) ADVERTISING REVENUE TOTAL 84' 2,922.26 2,810.05 2,788.80 8,499.11 4,024.31 3,549.81 3,120.00 10,694.15 19,793.26 SECTION4-TOTAL REVENUE $63,554.79 $63,401.37 $61.816.31 $188.772.48 $62.537.26 $61,849,86 $59.986.85 $184,373.97 373,146.45 SECTION 5 -FRANCHISE TAX X 5,00 % 5.00 % 5.0090 5.00°: 5.00 % 5.00 Ca01e franchse tee 3,031.63 3,029.57 2.952.48 9.013.67 2,925.65 2,975.00 2,843.34 6,683.49 17,697.66 Ad sales franchise lee 146.1 t 14D.50 138.34 424.96 201.22 177 49 156.00 534.71 959.66 SECTION6-TOTAL FRANCHISE FEE DUE 84 $3,177.74 $3,170.07 $3.090.82 $9,438.62 $3.126.86 $3.092.49 $2,999.34 $9,218.70 f18657.32 Amount PaW !49834000010 FFPMT 59,438.62 ay.asn.o~ Over/Under $0.00 59,218.70 $9,218.70