HomeMy WebLinkAboutComcast 2nd Quarter 2009 - Franchise Fee Report (2)
Comcast® 1Comcast Cable
5815 25th Ave West
Lynnwood, WA 98087
July 29, 2009
SENT VIA OVERNIGHT MAIL
Ms. Lorrie Rempher
City of Auburn
25 West Main St
Auburn, WA 98001
RE: Franchise Fee Report - Second Quarter 2009
Dear Ms. Rempher:
In accordance with our franchise agreement with the City of Auburn, please find enclosed
the franchise fee report for Second 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,
Ann Svensson
Franchise Contracts Administrator
Comcast - WA Market
Encls.
cc: Janet L. Turpen, Comcast
Ken Rhoades, Comcast
Terry Davis, Comcast
Bradley & Guzzetta, LLC
OPERATOR: City of Auburn
Comcast Period From 4/1/09 - 6/30/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) 1,061 $16.06 3 51,132.85 5 2,556.64 4,795.43
Rate Card Price
$13.92 Limited Cable Service* 18,502 $10.35 3 574,396.07 5 28,719.80 56,847.54
11141.e3 Expanded Cable Service* 16,703 $32.20 3 1,613,647.10 5 80,682.36 161,973.44
$16.99 Special Interest (Digital)** 14,546 $17.15 3 748,603.12 5 37,430.16 74,286.27
$17.99 HBO Customers 2,773
$17.90 Showtime Customers 1,107
$17.9 Cinemax Customers 788
$1699 TMC Customers 627
$17A9 Starz! Customers 2,124
$111.99 Encore Customers 157
Total Premium 7,576 $9.70 3 220,449.49 5 11,022.47 22,213.42
$/.9114".95 Pay-Per-View 9,930 $7.08 3 211,031.05 5 10,551.55 20,869.39
$1.00 Standard Converters 0
83.20 Addressable Converters 19
$320to $9A0 Digital Converters 22,150
$0.15 Remote Units 22,351
Total Equipment 44,519 $0.01 3 941.16 5 47.06 87.03
TOTAL SERVICE/INSTALL INCOME 3,420,200.84 5 171,010.04 341,072.52
Advertising Revenue 160,948.66 5 8,047.43 14,433.99
Shopping Services 34,265.23 5 1,713.26 3,210.51
83,50 Guides 391 $3.54 3 4,148.72 5 207.44 441.57
Late Fees 29,372.43 1,468.62 3,047.65
Miscellaneous 19,619.03 5 980.95 1,631.75
TOTAL NON-SUBSCRIBER INCOME 248,354.07 5 12,417.70 22,765.46
Less Refunds/Bad Debts (73,526.60) 5 (3,676.33) (7,040.28)
Plus Bad Debt Recovery 0.00 5 0.00 0.00
NET BAD DEBTS (73,526.60) 5 (3,676.33) (7,040.28)
TOTAL REVENUES 3,595,028.31 5 179,751.42 356,797.69
Franchise Fee Revenue 140,286.84 5 7,014.34 13,979.25
Utility Tax 0.00 5 0.00 0.00
Adjustments*
TOTAL DUE CITY 3,735,315.15 5 186,765.76 370,776.95
EXPLANATORY NOTES:
* All Limited and Expanded Bask Service revenues are recorded as Standard Cable, Bulk/Comrn'I revenue category.
This includes revenue for Digital Additional Outlets as well as Bulk/Commercial Additional Outlets
Send to: Prepared by: Ann Svensson
City of Auburn 01W4_
Title: Franchise Contracts Administrator
Date: 30-]ul-09
O
O
U
W
8 RHH7CR6 W H? 8
U Yak iR8~8~RQ5QgY3a p QQQQagg QPa a aQ Q a
m
^OQ. ..Q~P..~a u PPPQPa QPQ P PP Q 8
a a~a ; 4 aas~ ..1 a as a
cc
O
LL
QaQQQa aQPQ Q ~ QQ Q
Z
a gi g g null 11 -1 111
~ W
Pa Q
LJJ bP. Pia -min ml i u ~
I
u.
¢ZZ......... c~g y tP iQa 2Q Lag aQ is@tg 2a QP ZQZ e
U 5y ~tly df f $~d$Q ~$~9 $ Y
PQ Q PQQ a ~ Qa ¢a
A: 8pA0 ~:,1R ER° A ^1 _^3 '7Y1 'R A
y? SY_i~w.i9l~"scS~i y :7 !5i i65~ 3: c ^
E W W
C E=E87/:R BAR i YB H~: ^:!8 Y:
l~RS ~e!R!li8.~ail~~ ~ ~A :AF d~l~R_ ~d io
7R °:18RRRR RHR 7 Y. 17C. ^Y~II ^E
w
k6 RYt1 H:Y1R :•6 Q 'R ARA RtlsyG 1 1R A
aY Y G ~
IIR 88/9YYRo RYB 7 SR E77 YRiG °E
yp! !:!!g?a6~lIioE y „9 ilk Digs i Fi. a
6 W W
~B ^^YBBYEHE -891 7 "1 °°-HA A= 7 8II
Y Riilaia~ EYY
96 '616YYFA '":Y Y HA RRA EBSY :1 G
i®sR3lr$~ici~= ~ RA =s .II"?^p ! _x
3 G W W
Y
CYE19A='7 :SY 7 0„ II~ 8R6S A ~
891 „"i::l~R e39 $R m E[ti 75
~~€f~~R I 3 d3 3 s s
` o ~ o d
J YG y y
u
4; 7
WW~7s~a a3s8 HM P
C
cc
O
C)
w
:Y49HYY Ra
V YQ $=~Oa~Q P~%`t a 4PQPPt a4at PP g
JM r _ °a R~ E a!!!!! ull at H 8
W
cr W
O
LL.
H Igh h mull 1111 1 ° 1
Z
!Q aQ~ QQPQ4t PPP ° P a
WQ
6! ! 4g4 tlgl mill t 4aa 1!!E E 1 4 11 Q a
O Wa
LL
Q 111 161 4a4QQ a Q Q P4 Q €
!Q Q~P ~ ~ aaQ4Q Q Q ° Q4 Q
W W
Q 4~4 ~ 4QaPP QQa a tl a P
o p ~
Y 'OYHCBddG H
HHVHR R ^Y °c9H R 8
Y5~ ~mx?s:QS Oi t @# ^?8 Bfi ~ !5 ~
E C E ° H
8 YBEi-`iR H.E G HBR HY
5ffi CSA."HBa: BRR C Rp RSS RGai A ~ .G H
0 3@%~$hEB9pF R B aoi E RE
Stl 7fi°:8ffiAR 8R. 9 •R :8S it ffi
R 6 $'•VIP i iICt p wH ASE $8f! 0 $R $
RfiBSReEY ^S8 i "H eHR d::R ffiM ]
~ w w
.•7 Y RRCaiY aFi 'S :Y^ ER '
gH S88R7YS7 Y:Y H 'Ja "OA ~ ~ Rffi S
e W w G
G
$R RYH:fi:HB eRY R R8 HfiR °R RY S ~ H8 C
~e0l~H
Y t 3 i
y a ~ 6
! Mill, 9 29-
0
m
0
LU
e BAAA99a A~
U Qk s~'SE~GiQy Pit~~'~ S P zQ ZQF zQz QQZF sF PP pF ffzz
m Y
1.~ ep P~'P Q s Q QQF QeQF p Pp Q Q
0
LL.
11 mill lin I l6 ~
0
z
z
o € oil 111118 1111 1 H i
LL
Z ~Q Q Q Q Y Q PQ pQQ Q QQ Q~
~ z~ ~ ~ QpPPP Ppp a Qa a
w "
PPQQPF P pF Q " QP Q
t~t ~F QpQQp PpPg p QQ Q ~
A ^-n8?:"r -YY,F s ^fie afi - ea
~=c RA W"A54 tb5 * ~y 3.,AN ilo ~ R1 a
C 'R8 R
E
g a-
~FY
8 td H
~6 °axeo2.. .2:2 8 8A SSh PY: R ~ a= -
Ale
R •'88988° ~ 7'a A"t,^^°? 8^ -
~x°.a as;_f r. s'.~ ~ 9Y 9Aq A~eq 9a -
R 5.8^eY 2°^ g s~ R.•Y :M1dl-' S 2 g
P, sx e 74 4°8R, ^AC{ ? ~ 9S ^
5 Wa ~ - - A
x
94L 8a: ® as
lk -9F"a ..57 ~SR.~ gEe~ g 8F
bti ~$g]P !li
3 8 1 8