HomeMy WebLinkAboutComcast Franchise Fee Report - Fourth Quarter 2009
Comcasta Comcast Cable
15815 25th Ave West
Lynnwood, WA 98087
January 28, 2010
SENT VIA OVERNIGHT MAIL
Ms. Lorrie Rempher
City of Auburn
25 West Main St
Auburn, WA 98001
RE: Franchise Fee Report - Fourth Quarter 2009
Dear Ms. Rempher:
In accordance with our franchise agreement with the City of Auburn, please find enclosed
the franchise fee report for Fourth Quarter 2009. 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,
( ~iz4t~~
Ann Svensson
Franchise Contracts Administrator
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 Period From 10/1/09 - 12/31/09
15815 - 25th Ave W
Lynnwood, WA 98087 FRANCHISE FEE PAYMENT WORKSHEET
UNITS UNIT PRICE MONTHSIN GROSS FEE % FRANCHISE YTD
REVENUE SOURCE (AVE OF PER) (EACH MO) PERIOD REVENUE FEE
Installation-(Including Digital) 900 $16.06 3 43,365.93 5 2,168.30 9,328.62
Rate Card Price
$14.52 Limited Cable Service* 17,041 $11.66 3 596,352.47 5 29,817.62 115,991.59
1142." Expanded Cable Service* 14,778 $36.00 3 1,595,866.53 S 79,793.33 321,230.25
$1111.99 Special Interest (Digital)** 14,878 $17.23 3 768,833.71 5 38,441.69 149,800.79
$17.99 HBO Customers 2,904
$17.99 Showtime Customers 1,433
SIT." Cinemax Customers 734
$17.99 TMC Customers 424
$17.99 Starz! Customers 1,971
$16.99 Encore Customers 128
Total Premium 7,594 $9.82 3 223,700.51 5 11,185.03 44,462.99
84.WW.e5 Pay-Per-View 9,958 $6.38 3 190,554.88 5 9,527.74 41,053.93
$1.00 Standard Converters 0
$320 Addressable Converters 18
$320to$0.00 Digital Converters 23,408
80.15 Remote Units 22,977
Total Equipment 46,403 $0.07 3 9,882.78 5 494.14 1,040.66
TOTAL SERVICE/INSTALL INCOME 3,428,556.81 5 171,427.84 682,908.82
Advertising Revenue 216,363.58 5 10,818.18 34,328.96
Shopping Services 40,737.68 5 2,036.88 6,873.50
$3.50 Guides 310 $3.53 3 3,289.46 5 164.47 791.20
Late Fees 37,361.25 1,868.06 6,591.76
Miscellaneous 32,628.93. 5 1,631.45 4,522.07
TOTAL NON-SUBSCRIBER INCOME 330,380.90 5 16,519.05 53,107.47
Less Refunds/Bad Debts (85,432.54) 5 (4,271.63) (15,608.85)
Plus Bad Debt Recovery 0.00 5 0.00 0.00
NET BAD DEBTS (85,432.54) 5 (4,271.63) (15,608.85)
TOTAL REVENUES 3,673,505.17 5 183,675.26 720,407.45
Franchise Fee Revenue 186,574.82 5 9,328.74 30,283.27
Adjustments*
TOTAL DUE CITY 3,860079.99 5 193,004.00 750,690.72
~o
EXPLANATORY NOTES:
"All Urnited and Expanded Bask 5W►vke rawkwss are MOrdsd as Stmdmd OBMte Bu1c/Conxn'I reveraia cebegory•
This !ndudes mvenue for Dlgkal Addltla * OutlM ss we!1 as 9ust/Qonr WCW At$dltl x99 Outlets
Send to: Prepared by: Ann §vensson
City of Auburn ~LZL C' ~u l L~ 1}ti
Title: Franchise Contracts Administrator
Date: 28-Jan-10
O ^ a 3&
'89.~9~7'S~an ~a aR a~q ~aRR R
a. 65 A
0 1 " g
LL 'e SHVsa=" aax a= ^°a Ra 9
O ~
54% 31
and.<a°i~ till iR
J o=R i" a as a
z -x "9RS°R_a ;aa : 9S -4 a.x ^ 3R
W =''s a z = = i -
LL 3a "R~9Ra~a raa » x: -es a=~- ~ as _
V
a AYI
"A.6Bd AMA
8^a .38tiR-m9Agwg°O R T3 ..a~ '^39 _ `A ~
~C Y=xS=3=§ 8RS aS 3== ^798 7 9=
iR ":38~'&8R lY 39 S 33 '3.+p a u "x
He,
°W aa~aa^0,^,'1'9 'R q~R ~R°R R a= S
42
3,3aa3gRA^o P33 9 a ~''+R 9g3R a= -
44,
a3.339a:3aR ":'9 RR dU~ E3i? 'R
U
'7yR 93°?
w °
LL wr...3wr~ ~ ~LS~ ~y UL~L7 ~ Tw00~ ~ yI i'A
arsaEE:a s3a $ 3s "E a. 3q${ a
03
mi3
R:E yyttLA r'* `o C 'x 3J x
W a
A =$agis:~ 3Y^=n a3 -"ry :3~. E ~ 7e r
Si
yy~4 e9 3 " $ Yj" R
IM RAS
Q a~ 5"F-
a
s a
Z a3 ^A"o -'A-3 R$E "x.xA~ x$^$ "yY, p$
gay _ ~ x
z 31 ug 11
O ~ R°t•"'
U^
93,$p{SEA{~d°xa$°w SRS '9A ~ g^ A
Ra xaga.!;A Pia' $ -a z{,-xa$ xs 3
W w s
MM! MA
x "sa x•3{a 3Z ^ za, sa Argo A
i ae x R x
xx~a c _ p -
c W W o
F1 9! 1 z 3;:S
"
R =jam
3
R r
ia.xaE~gaix 3$: ~ q$ 9~p aiAq
'All 11
$
O O ~
Z3
-37787$3
W a ~
~ s
2 ° 3d 7 S: dA7 33s{ ^ ^A A
W
Z 27 C{8S:'="+ 72 ,7 ~."57,A3=5t = RS A85
7-2
Z x3R 3i { A" "{3 82{^ pn
Z S 0 3- 3WR Aniq 3 5
V w y
33 ^853=:'~= { 5.'=88 3a7-o 3g
S
a w `o
=1 ?i 34 823 x 83 r28 q-3^ 7.n
~ a a
<3A2522 e6A =8 ?83 75rA " 38
o W L o
a a~ -3= ^R • a ^
w w
i4 3 isa 3 8: ~dd 33:7 3 ;.si R
c -
'7 't