HomeMy WebLinkAboutComcast 2nd Quarter 2009 - Franchise Fee Report
Comcast Comcast Cable
15815 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,
()4tA,l
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
Lynwood, WA 98087 FRANCHISE FEE PAYMENT WORKSHEET
UNITS UNIT PRICE MONTHS IN 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.99 Limited Cable Service* 18,502 $10.35 3 574,396.07 5 28,719.80 56,847.54
$41.!$ Expanded Cable Service* 16,703 $32.20 3 1,613,647.10 5 80,682.36 161,973.44
$15.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.99 Showtime Customers 1,107
$17.99 Cinemax Customers 788
$17.99 TMC Customers 627
$17.99 Starz! Customers 2,124
$15.99 Encore Customers 157
Total Premium 7,576 $9.70 3 220,449.49 5 11,022.47 22,213.42
SON441.95 Pay-Per-View 9,930 $7.08 3 211,031.05 5 10,551.55 20,869.39
$1.01) Standard Converters 0
$320 Addressable Converters 19
$3.20 to $8.00 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
p.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,7359315.15 5 186,765.76 370,776.95
EXPLANATORY NOTES:
* All Limited and Expanded Bask 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
Send to: Prepared by: Ann Svensson
City of Auburn JVZ41
Title: Franchise Contracts Administrator
Date: 30-Jul-09
O
O
U
W/~
Li B 8aH7C8H II^ R
U ~aR "B ~~RQ 1MI a QPPPQP QQa€ P QQ P F
J W W
m
a a € a mill ;-it a as a~
~ w W
O
LL
P
Jh g aaaaa aQPP Q ° Qa i
0 W - I Mill lilt 6 II
Z
~ W w
H
Z
W 6P Oh 1 PQQQQP QQQgg Q PQ P
LL
p 1dl I a1 1.14,111 lilt t H a I
U W w
M ,
~a Qua ~ ~
Ia aaP aPQt I
flial lilt H I
W w y
i will lilt I it I
P P~Q 'P QQPPPP PPQP P " QQ Q
YHAavAIR Y°° ! 'Y _^8 ;v fm -R a
i9i s a
E w w b
C d=AB=Ya HAII 8 YH 07. ^788 - 8:
~1~ ova;
7A "788RHRR A88 7 83 778 ^S~e ~ ^8
V-1 A;RMvW H as -Si 9i5i 9L
44 q
C„ R718¢:BHR -•8 ¢ 'R ARA RII6" Y § 8° 8
BA Ya a Y8886 C38 ! 3: z7! 8As& 0 °i - '
5eN ~ ~ 8 sc5~27~~ ~ R° A 8 I- 1 3
RY 58888488 -68 'Y •Yx A^- @ HA
as -88:SY~.a i, BY RCx dl33 ^ :8 C
d di
w W
x
X37 CB:YSa^7 -08 9 a: 8R6~ A ~ 7
8 ~ 8 8 8 8 ~8 ~ 8
ffi X R 6~ k 7 ~~~a o 0
a i<~ 5 ~w W a e ~1h i s e
W:a~ a P6 H p a's ~s$ s
0
cr
O
U
w
::2"A8R RE 8
V ! ~ =~a^o~~ SAO u
P: "~Q'~PR ~ QQQPPF PQ¢f f PP i
16
m
Li SP pE PPPPPf PQPi a PP ¢
O w
U.
L ~4 P~a ~F ~ PQQaaf pQQF P " Pa Q
Z ~
J iP Pga g aPP¢PF aaQ a¢ a
W
O 6 ~a a &IIIIIIOHM
LL
YP. FQ..If QPQQPF P Qi Q4 a
o T-
N 2 I lul d
a
1Q151 ¢ Paie ¢aa " ¢a a
d oil IIIIII MI Qt 11 Y ~
ab 111 iI mill ml
a "asa9as: a¢R R -a RER,"a R sA
Y5~ x039°s:95 y %?i 8E4g' A 35 ~
9 a8=7c`.R 9ez r 9eo ^E a9
3z $mR~5?~"R~~°~E ?ii Wo A t~ p
d d d~ F d
SS ps z a a Iz OAR q Ra RiR RR.R R ^R 9
So 7F°:89RC 8R^ 9 •R 84 BRx~ a
99 Rp8S~oYR "S8 i 'a 99R d~:R 8a j
68a k a^c^R:i°Rnt
E C R
STPRZ33-8 993 7,--- TA-1 9 -OA
aR 'EPF~5ri3.d~ nA6g?x ~R
SR iRSR:8^9 9:8 R R; " C '°AAp Ra Y
aE i
Y W " C
it
ER Ran~p:99 aRa x a9 R:R "RYa a ~ R9 ~
Y Y Y 3~
D
O
U
W
e sASFaAa ac
YaR aka ^Ha~P}}~Q ; Q aaQ aQ Q € aP a e
J E~ ~ ~ R §w~ g~ ~ a aa~ aa~€ ~ ~ 3
m
d ;a a~'a gg o P PPQ Paai Q as a e
O
LL
w QaQQ a " aP P
O € G1 HIM IM o log
z
J s}z } ~ QQQQQi as a " aP a
P
z
I mull .1u.1 I
o w
LL
Z ~P_ PQ Q 5 P QP€ QP QP a Q
V 8~ € 11H I II I
z3i 3 ~ Q PQQi QQQ a " aQ Q
HIM HII
tl
r}a }a PaaaPi aQa a as Q
Y3fl ~i;gYpcQ IDI } Y 3 HP, Hal 5 sg R
fir s _ ~ ~RF i € - - ~ ~ a
5
a. assts .PS awz - d4 ase a7 -
C-
.2€2P 9r .s° dF■ Fa cps asz; s ~ a
.o °a a=e2z.' 2.2 S dA 44: 74: R ~ a=
6j
-FFa88° ao4 78 a^7,q^8Y B' -
h2P 9KS.F aY 7R F, icd! 78
T°sE 5§°^eY Vfao:~q ~ an'R^a ~~dF R "WA 8
=.9 ::Zpo'-'a: nea ° 77 tRF ^AaL 3 ~ 7~ ^
_ y' a °=s ~ aye i g' a - 1A } Pk 9
r W W ~
° is ::as..a ss H s7x aa:R a ~ nn a
Li C F3•
S Y i F
A o s ~
te
t~~~~y~
W ?m~ea a ~msd le 2