HomeMy WebLinkAboutComcast 3rd Quarter 2009 - Franchise Fee Report
Ccomcast Comcast Cable
® 15815 25th Ave West
Lynnwood, WA 98087
October 27, 2009
SENT VIA OVERNIGHT MAIL
Ms. Lorrie Rempher
City of Auburn
25 West Main St
Auburn, WA 98001
RE: Franchise Fee Report - Third Quarter 2009
Dear Ms. Rempher:
In accordance with our franchise agreement with the City of Auburn, please find enclosed
the franchise fee report for Third 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,
(atc - 01-
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 7/l/09-9/30/09
15815 25th Ave W
Lynnwood, WA 98087 FRANCHISE FEE PAYMENT WORKSHEET
UNITS UNIT PRICE MONTHSIN GROSS FEE % FRANCHISE YTD
REVENUE E SOURCE (AVE OF PER) (EACH MO) PERIOD REVENUE FEE
Installation-(Including Digital) 982 $16.06 3 47,297.86 5 2,364.89 7,160.32
Rau card Price
IM2 Limited Cable Service* 17,450 $11.20 3 586,528.54 5 29,326.43 86,173.97
$41A3 Expanded Cable Service* 15,249 $34.74 3 1,589,269.63 5 79,463.48 241,436.92
$16A Special Interest (Digital)** 15,070 $16.40 3 741,456.68 5 37,072.83 111,359.10
$vel HBO Customers 2,985
s17.w Showtime Customers 1,143
$izes Cinemax Customers 756
$nw TMC Customers 520
frrAG Starzl Customers 2,078
fuw Encore Customers 143
Total Premium 7,627 $9.67 3 221,290.82 5 11,064.54 33,277.96
84.wauAS Pay-Per-View 10,981 $6.47 3 213,135.94 5 10,656.80 31,526.18
qno Standard Converters 0
am Addressable Converters 18
antoww Digital Converters 23,521
M15 Remote Units 22,963
Total Equipment 46,502 $0.07 3 9,189.73 5 459.49 546.52
TOTAL SERVICE/INSTALL INCOME 3,408,169.20 5 170,408.46 511,480.98
Advertising Revenue 181,535.81 5 9,076.79 23,510.78
Shopping Services 32,522.06 5 1,626.10 4,836.61
am Guides 346 $3.57 3 3,703.15 5 185.16 626.73
Late Fees 33,520.97 1,676.05 4,723.70
Miscellaneous 25,177.40 5 1,258.87 2,890.62
TOTAL NON-SUBSCRIBER INCOME 276,459.39 5 13,822.97 36,588.43
Less Refunds/Bad Debts (85,938.71) 5 (4,296.94) (11,337.22)
Plus Bad Debt Recovery 0.00 5 0.00 0.00
NET BAD DEBTS (85,938.71) 5 (4,296.94) (11,337.22)
TOTAL REVENUES 3,598,689.88 5 179,934.49 536,732.19
Franchise Fee Revenue 139,505.54 5 6,975.28 20,954.53
Adjustments* 5 0.00
TOTAL DUE CITY 39738,195.42 5 186,909.77 5579686.72
EXPLANATORY NOTES:
All LM # ad an0 Expeii W But Swvbe revenues are recddI AS Standard Dft 81NC Wm I My wM oihwy.
This Ytdudes m ww fe 0WW AditM Oufiets as wel as Bui CMWWdd AddVJ" OudW
Send to: Prepared by: Ann Svensson
City of Auburn
Title: Franchise Contracts Administrator
Date: 27-Oct-09
~ ~ it 1gg~ qNg O n f~ Cf N f 00 ~ N O I~ Ofi !1 ~ t~ P 1~ ~ m
41 gi'_ 8oiry~maNi_W mn ° ERr ME < om
f'N NO Of0°IAm~ f Il) n 16- N ~f a Ni ab
Q=~'.~8 N 1~ N f T f N H
C- ~ J p FN
f X U m
O C W ~ C
~Q 10 ' r fN~~'p' ~ r N CNv^ `Tj
N N
q W mm~ W ~ VV qq ~~yy mm ~p
- ~m r~ 000 NN f7 tN'1 N m 01 r tO0 ' ~O N~104 G ~ m IO N
fO ~ ~ CNl «
D p pp tv~ W
N~Cy~~yy1QgQQN~ y$B~ 8 ~m -.22 yyA~~'i5'o~a 4 ~ 8-
I'; N M16 < ui m g
~ ~ ~ NNV W'U~ ~ hIN ~3 p
O ppW W A
LL q ms mt'10 lof ~ t7~
F VOE 1~(1 O N~ NN+ O fG N ~vW p f'
O Cl ~j Cf U G N
Z p W
r. 4
a 0-1 Y08019,011 1 &49~
tp pp~~ ~0 pOq (y V
_ ~vf IO N N N~ ~ N = lV f1 W < r r N
Z ~~pOC_Q~BRgNR, ~1SD'.~ s <`a$ ~s~o m ~ :as
W PN ~ m °w ~ ~ 90 py N ~ N
Q }N10 m ' ' l7 ~~e-EO'~ ~ ~ N N OCI V^ p
w
Zug n~8~m88n n°ry~ :~~P ~~s~ 8q
n~ ~~p 8um'
Nm 1 ~m ^a, ~ "a~`uY ' oN'FS Ngci o~'d
O NO ~ N f~-~ OI 1fl~ N n f1 v0 O
p W W
~i,~~ m ~ m 1p
OmO1 ~ ~ f~Oi iD?C1~f~l~~! O N h O W vO ~ O~- µ
iV IV f M
ff77 l7 f b Ix
O w O
98 ^oa$8$3Sg8NQl~lp8$m $ FiVpB~,v
~`f'O b ' ' tV~ Ole ~ ~ ~ N OiOv^ Q r
~.Fn"',$ , S8$AfONN ~e'8 $ 85? , ~FJ~ ~B$r°, ~ o,$ n
m gm~N3~i6~g$ o$ nag 'N m
Amyy ~a m ' ' FI NX~ -O'xdi m N ION O N
LL W W LL
t~ ~~OO G ~~OO mm Cp [v a m p tV
} Io~O~~ ~♦rONlff'pn~Ol ~pNp~O mNO IpNO w^O ~~~p m{N~lp9 oO mN~a~ ~ ~ (NON ~pPp
p ¢Q1 D~O) 10 e g p ~INN V f~01~ W N N~O ~l~ ~NO n^~O a~ t(l N
Z LLLL ¢ l m N OI m g N N IA fV O p ' N
Q O~ Qp! ~Nfp ` X X ~ lM «
W W
~ z
W
1 O W V W O -V ul
7
P LL
z 1yi1W~1 2 QQ W x W
I ~ ~ r
m C W W ¢ ° Z Jj ` $
ZO (7 m S29 {y W
)w. ° Mn ILLL 7 > u W W W W Ol ? Z 2F 2_ J5 = J
,LL lii U ~((mUppp Q m >W> U W m W r O U W ` y Q P ` R
,'W W WQ ..W K = C SW WZW W51>y~ z¢ j Q~W W W WQ ~Q 0
C7 W 2Qt- W N Q WfJ2 W LL W '
WN p
-7 t '7
y >yyytq (~~+le r¢ W !A N~0R°2 W R,> u) OQ~~ } Q~ N p
FI_ Z¢ ~ V p°U ~ aLL DLL Q W 2m 4 aw xxw J~O` y. FQ
¢ W Qfa~O U~ X U ~ N Q f Q Q S W xw' w GOQ Q u W
'W NWLLm>}° LL H mmQl°WWLLLL(7=JOaa~ N 0 JOO1- 2m N W Ul
dm mnaang.SR. a. $ 8.s °a r4 E; Nv w2 $
09. P.
G n N" <V N m N W N 17 C) p$ O (0 N N g r l,] `Ntl l0 O uj f0 O
ir Ix
0
"N Nk S NNp 8~S~l ypm < ~~Npp ~pNp ~y~y~p ~1"O p~Cpgl W ~Op N~ qpN!
W O A' G 0 A ( ~ g O T W O' 0 7 ~ o® E 1 " N O Y
V N ' mQ N p " 0 h Q r^ A N
N W W N N
I ` (44111100 1O~m0 00 NO W O O fffyN///ylll' NN WAR S.IO iA (y ~ g OCl
.1 "ht
N
~fz W 1 N N a N O A p O a (~j1~ N 0 N 0 n
X
^ t'l X7 Q IN`
(Ny mm tV a mm G N10 oo
N1r0 xg Op s Op~~ ~p Ol pp
m N t~l"~ N O NfD C!~ ry , ^ HN1B
O ~ RN pi f~~ N~ Y~? ~ ~ " ^O N0 `W ^ Cl ^ N
lV W VW!
k.~ .4IISd&lgASg D&!g a m93 to FdB as 3
oil W9WR@F!V8R go Mi R
O fh NhN N F 0 ^ N 'N m
f X ^X N f ~j N M
Z ° w W ° N Os N N
cv
J 5n 0~ O~Oi yp4~n p mN ~sm tgrl FF m
g
Q tuVS7r d yyVS."o-gbSQi:Ryyy Am~~+'N O < OIal ns Fig uS gip " II
= N N O O N 0nt5jd n ~.1 b A N V l q ^ ^
W W
~^10 ~y tp ^ mm O p tV m 1p~p p~ ii s ~f p~
Z 9s vmv~88O 1tp l11py aaO~mm 2pnA1pr~~R r; g2 A QRQ Nimp iii q ~P m~
Q ION~t~f^V_N^~pG np ADO 010.00[
`~m ~ 101 ~'m~ Pf~ ~ ~ r N~vW N l7^
: y~ m tV ~p ~y ~ p ~ Y1 C p C to (p
O(O YN~O Ot0 l~fg0.. HN~ x Nn 1484 IO, mNcc v Nt7 N
^ W
R 00 i A Nw8 $ m" ass a{ W t0 t f f
dg_ ~p~y~~oOgpa~gm~ app4 x at
Q ~NmN I~NpAC1 l~gO G ~ N^0 "NvO ~ OO N N
^ X X N
rY 01117 t, P~"4 1s SF 1 N O t7f 0~ 17 b "O R
.N.•. !A ' v i m ^ OI 1C Ol ' ~ ~ ~ Yl N f~ ' v 1~ N ~ ^
F ~"$y ~ V; 100N V Oim mq<IILL OUNf MILL 1OmpO ((pV0~1p7~ OtOmrVl Opel mt0~t'l ~qNn pq^~, ~ r10
z
NNi1S S~~ 8nR oa O~ OO Cf m Cl f~ a 1~ 010 " O^Oi
mv0 l'l O N^~^ V ^Q0d.19 m 'O N 1G f0 19 (p ^
3 P W W 1~ LL N
Xi p1 q
> O1 R N CI ~(yO O N ~1YppO0~~. . 1lOppl p Ba (Ny 11Q0 p ry gpN O {Oy1 ~~Npp 1F^~~ 8m (qNp l'l ~pBp~ a 0
O ¢ m~ O N N b~ O C l^ Pu f t' 1 f O W p~p Q> ~ 0~ C f I~ N ~ 0 Y f ~ q Oq ~ " ~01pp
1~~N m n N ^ OOI~ NOQ~N ` N ^ f~ 0 r `N l7 ^ 1~
Z O JJbb 1N~ A N
PEI, = W
$ 2
a
z i w~LL
c w y y 1
LLI ZZ a W W p 1p < 1 c7 Z W w
w J w O m u w w z ¢ IW- O p t f¢ w R
4 p 11 LL J W W W W (p<,) YI m p W Z J LL
W ¢Lu L) U W w -w UZw W w6 ~+Z+ j 2¢ V J ~NfL W W Q F
'N' c7 WZ~t w a 2¢m ix 9966GE ~Gi~<(~ 4 r) f) m /)w~TJtzJ0 pi 0
' Z ¢ W N G R°
" W ¢ y w~ w i r m N Z< ¢ °E a Q a O • 2 2 21
m.o8o H< W W u V)
Y. 1 W LLmf'>1)O e8 ii Sm Om O~W4LLC=7?g oaa5 N w Cl)
.POOH m N N N
W
x °
0
gi N n N O n n m dq W 8 n °n N@ O m op
N O rrpp t70~0 N W bn i(1 W W O^ ~'!n ""P ~ 0
N t~ b (D ~~~Oi OiQO ~ r NN A f0 n M
f U J~ YY'11 y
f`l3W W W
V a p q p~ ya ~~pp
IG CI A t'i N Cf ty ^ U1 m
N S N t~ N r O q p
llpp~~~~Smome~$ BC~~~5~ S
J r?N+N Ntl N O W m q ~r O~ Ci m
~ C [V Oi m QYI 7 Nl~ A m n y
-N D X J
W
O O v N ' ^ m N N~ ~ N N ~ O N d ' ID A N N N
Q. tom` ~ r
Z Q ~ Q
~t'1 t~QOCi V v ~ N Nb.{~p ~G~ppp ~ Om+p {c~ 1D0 , NfD nO O~GO ~ OaN
a mm e O N~ O~i ~ W ON N W ~np W ~~O ~~`N~ t~Nu~ ~ nth mm
Fyn 'p~~ ~ .-~~m o~N = ~ ON ~p 10 n N
_ Z v c~ Ci x
~9J rrpp pp:: W ~~pp W p pq. p p A Q
Z O~ ON O m Q b O s C n, 0~~y0 N~OyNN 00
Q NO ~M;~mmm W O mmW'!N
lV N 6 Ml y` N iV 1~ ~p n y~
- Z ~ X~ Z N
Y y W p ~y p
Z ppOni ~C1 ~N~yy lpp~ O~ Ooop ~QO~ O IyND~ p0,1 C1 OQ~Iypy~ <fNm N8q( ~ ~ N~ r
O Nn ~NNN o' l~l ~ll~ V ~wIp_ y~ N~ ^Afim~f N nN
VrN X00 D 7U' W ~!7 IF C ~`N p
m X N GQ• a p m {y ~ p
JmOpN yry0~p 0a~(ppyy ~eii-seey~ YET 7 QT ~N~pp pNjj {~Oii~~ NOO~i, 10 ~n(1 {~y- 10
`i~O ^~~<Of d~j OOri_Cl W k OWN ON1~~~ b O~ (ONyi
~~r ' d CG d 17~~W N~ ~ O N Vl O N v' ^ N ~ Y!
c O W V w o YYYOfff
NtNm'l r0 Ln Z ~mC6 m WQ = AN °n°ng dN~fO N N »
Oi 1 J r
Z M
Z C~ vv rtpp a W W V p~ I. aV (V C N
2 m mN 9 A O1. C3
m eyO yd~0 r1~~, 19 tgp~t~aO pW fps ~ ~(?~N ~
Z g~gi m~ ON N~OiQ W l~l 0~ ~n~ t~Cl' V O ~(1 nN
W W~ W N
2g~ , G ~oOOO tnn'i lm~amm lO ~D N C] ONippNN~nnO W ChIO tONtv~id l~nq~p~ 1~Dy 9 m2 1~~~tNVV N
6 p~~~> ~ X X' ~ ~
Wa
a
Q {2y r yy~
W W LL
r yZW~ O = ~ I
W c j > w
QW y~ W X $
? O N QW (7 Ul S <W W> w
p 'o w ON -W
Q S j O ^ W^ O ~ W W W W= W m WQ_ J W Z Z~ pW JR = LL
QW W U F W WU WWZS~W7 3¢ I J, N2W`(O`J NWK Q
WwN W IA ? jm¢m~ W 9O6¢ Z xm `~~J ;p20 LL 0
N~j as Qlll fWp N 1m O io mmr W W><~9 O W.4 p r R N b
~~j` ZZZp Q U W W W W IrW 2r oZ ZHMO a~m z ~Z
Zr~I{- Z ZUQS U C, yyyQU ~ JZ~ aW Im6w W S}- C ON W W 3 HQ 8 4 U
w W W t >m LL y1 mmm0 W W UEO J OG 4~ k. 1 2zm w w w