HomeMy WebLinkAboutOrdinance No. 98-16 � � _ ._ ,_ �-�.� � .
ORDINANCE NO. 9 8-16
AN ORDINANCE REJECTING THE SCHEDULE OF RATES FOR BASIC
SERVICE TIER CABLE PROPOSED BY TCI CENTRAL, INC., DB/A TCI
CABLEVISION OF HOUSTON, 1NC., AND FINDING SUCH PROPOSED
RATES UNREASONABLE; DE'I'ERMINING A REASONABLE MAXIMUM
PERMITTED RATE PER SUBSCRIBER PER MONTH FOR THE PERIOD
JUNE 1, 1997, TO MAY 31, 1998; REJECTING THE SCHEDULE OF RATES
FOR BASIC SERVICE TIER CABLE ON THE H1632A SYSTEM PROPOSED
BY TCI CENTRAL, INC., DB/A TCI CABLEVISION OF HOUSTON, INC.,
AND FINDING SUCH PROPOSED RATES UNREASONABLE;
ESTABLISHING THE MAXIMUM PERMITTED PER SUBSCRIBER PER
MONTH BASIC CABLE SERVICE RATES ON THE H1632A SYSTEM OF TCI
CENTRAL, INC., DB/A TCI CABLEVISION OF HOUSTON, INC.;
REJECTING THE SCHEDULE OF R.ATES FOR BASIC SERVICE TIER
CABLE ON THE H1632AR SYSTEM PROPOSED BY TCI CENTRAL, 1NC.,
DB/A TCI CABLEVISION OF HOUSTON, INC., AND FINDING SUCH
PROPOSED RATES UNREASONABLE; ESTABLISHING THE MAXIMUM
PERMITTED PER SUBSCRIBER PER MONTH BASIC CABLE SERVICE
RATES ON THE H1632AR SYSTEM OF TCI CENTRAL, INC., DB/A TCI
CABLEVISION OF HOUSTON, 1NC.; SETTING FORTH OTHER
PROVISIONS RELATED TO THE SUBJECT; PROVIDING A PENALTY OF
$500 PER DAY PER VIOLATION HEREOF; AND PROVIDING FOR
SEVERABILITY.
* * * * * * * * * *
WHEREAS,the City of Friendswood,Texas (the "City"), is certified to regulate basic cable
service rates pursuant to the 1992 Cable Act (the "Act") and Federal Communication Commission
("FCC")rules; and
WHEREAS, on or about March l, 1997, TCI Central, Inc., d/b/a TCI Cablevision of
Houston, Inc. ("TCI") submitted to the City an FCC Form 1240 with a schedule of rates for the
basic service tier and expanded basic service tier, and upon review of such proposed rates, the City
Council rejected such rates; and
WHEREAS, on or about March 1, 1998,TCI submitted to the City an FCC Form 1240 with
a schedule of rates for the basic service tier and expanded basic service tier for the H1632A system
and the H1632AR system(hereinafter"Form 1240s"); and
WHEREAS,the FCC rules allow the City ninety (90) days to review the proposed schedule
of rates after which time the operator may implement such rates, subject to a prospective rate
reduction and refund if the City subsequently issues a written decision disapproving any portion of
such rates; and
Friendswood\'98-1240.Ord.
' � _ , . ��...-.� � .
�
WHEREAS, at the City's request, C2 Consulting Services, Inc., reviewed TCI's proposed
schedule of rates for the basic service tier filing of March 1, 1997, and the March 1, 1998, filing for
the H 1632A system and the H 1632AR system; and
WHEREAS, C2 Consulting Services, Inc., completed its review of the March 1, 1997,
filing and issued its report on April 21, 1997, and has now completed its review of TCI's original
proposed schedule of basic service tier rates filed March 1, 1998, for the H1632A system and the
H1632AR system and submitted its report explaining its analysis, findings, and conclusions, which
report is attached hereto as Exhibit"A"and is incorporated herein for all purposes; and
WHEREAS, a public hearing was held to hear public comments on the proposed schedules
of basic service tier rates of TCI; and
WHEREAS,the City Council has now concluded its review of TCI's proposed schedules of
basic service tier rates and the report and recommendations of C2 Consulting Services, Inc., and
made certain determinations;NOW THEREFORE,
BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF FRIENDSWOOD,
STATE OF TEXAS:
Section 1. That the City Council hereby adopts and affirms the findings and recitals set
forth in the preamble to this Ordinance.
Section 2. That the City Council, having reviewed TCI's filing of March 1, 1997, and
the report submitted by C2 Consulting Services, Inc.,rejected TCI's proposed rates as unreasonable
and now hereby finds, determines, and establishes that the maximum permitted rate per subscriber
per month for the period June 1, 1997, to May 31, 1998, of$11.63 is a reasonable rate. This rate
was derived by using FCC rules, regulations, and instructions as further explained in the report
from C2 Consulting Services, Inc., dated April 21, 1997.
Section 3. That the City Council, having reviewed TCI's filing of March 1, 1998, of
proposed basic service tier rates for the H 1632A system and the H 1632AR system and the report
submitted by C2 Consulting Services, Inc., hereby finds and detertnines that TCI's proposed rates
for the basic service tier for said systems are unreasonable and are hereby rejected.
Section 4. That TCI is hereby ordered to change the current maximum permitted basic
service rate on Line A1 of its Form 1240 for the H1632A system from$11.8828 to $11.6335.
Section 5. That TCI is hereby ordered to change the estimated average basic service
subscribership for the projected period on Line B3 of its Form 1240 for the H1632A system from
8,974 to 10,235.
Section 6. That TCI is hereby ordered to reduce the rate per subscriber per month for
basic cable service on the H 1632A system to an amount not to exceed $11.81 (the "m�imum
-2 -
Fri endswoo d\'98-1240.Ord.
� � r. -�
, , � , , .
permitted rate")on the effective date of this Ordinance or June 1, 1998, whichever is later. This rate
was derived by using FCC rules, regulations and instructions as further explained in the report from
C2 Consulting Services, Inc., attached hereto as Exhibit "A" and which is incorporated herein by
reference. TCI is hereby further ordered to refund to subscribers, within forty-five (45) days of
the adoption of this Ordinance, the difference between the maximum permitted rate established
herein and the actual charges to the extent that actual charges have exceeded the maximum
permitted rate, plus interest on such amounts calculated in accordance with FCC rules.
Section 7. That TCI is hereby ordered to change the current maximum permitted basic
service rate on Line A1 of its Form 1240 for the H1632AR system from $11.8828 to $11.6335.
Section 8. That TCI is hereby ordered to change the estimated average basic service
subscribership for the projected period on Line B3 of its Form 1240 for the H1632AR system from
8,974 to 10,235.
Section 9. That TCI is hereby ordered to reduce the rate per subscriber per month for
basic cable service on the H1632AR system to an amount not to exceed $11.85 (the "maximum
permitted rate") on the effective date of this Ordinance or June 1, 1998, whichever is later. This
rate was derived by using FCC rules, regulations and instructions as further explained in the report
from C2 Consulting Services, Inc., attached hereto as Exhibit"A" and which is incorporated herein
by reference. TCI is hereby further ordered to refund to subscribers, within forty-five (45) days
of the adoption of this Ordinance, the difference between the maximum permitted rate
established herein and the actual charges to the extent that actual charges have exceeded the
maximum permitted rate, plus interes�on such amounts calculated in accordance with FCC rules.
Section 10. That the City Council hereby finds and determines that the rates established
hereby are reasonable.
Section 11. In adopting this Ordinance the City Council of the City is not approving or
acquiescing in any way whatsoever to cost data and/or methodologies not specifically addressed in
this Ordinance. Furthermore,the City Council is not waiving any rights to which it is entitled.
Section 12. Pursuant to the authority granted to the City under Title 47 C.F.R.
§ 76.943(a) and Tex. Loc. Gov't Code § 54.001, should TCI fail to comply with any provision
of this Ordinance, it shall be deemed guilty of a misdemeanor and, upon conviction, shall be
fined in an amount not to exceed $500.00. Each day of each violation shall constitute a separate
offense.
Section 13. All ordinances in force when this Ordinance becomes effective and which
are inconsistent or in conflict with this Ordinance are hereby repealed insofar as such ordinances
are inconsistent or in conflict with this Ordinance.
Section 14. The City Council of the City of Friendswood, Texas, does hereby declare
that if any section, subsection, paragraph, sentence, clause, phrase, word or portion of this
- 3 -
T'riendswood\'98-l 240.Ord.
� �-. .�
, ""."'.� � � . .
Ordinance is declared invalid or unconstitutional by a court of competent jurisdiction then, in such
event, it would have passed and ordained any and all remaining portions of this Ordinance without
the inclusion of that portion or portions which may be so found to be unconstitutional or invalid,
and declares that its intent is to make no portion of this Ordinance dependent upon the validity of
any other portion thereof, and all said remaining portions shall continue in full force and effect.
Section 15. That the City Secretary is hereby authorized and directed to mail a copy of this
Ordinance by first class mail to TCI.
PASSED AND APPROVED on first reading this lst day of �'une , 1998.
PASSED, APPROVED, and ADOPTED on second and final reading this 15th day of
,Tune , 1998.
CITY OF FRIENDSWOOD, TEXAS
Haxold L. Whitaker
Mayor
ATTEST
�
Deloris McKenzie, C
City Secretary
Motion: Kitten Hajecate
2nd: Tom Manison
Approved: Unanimously
-4 -
Friendswood\'98-1240.Ord.
� EXHIBIT "A" ' �
� �N�ULTIN�G �ERVI�E�, INC.
7801 Pencross (�72) �26-7�16
Dall�s� Texas 752�8 (972) 7�6-72'16 (fax) 26ZZ Z82g
��ti � ����
,,,
� AP� �9�� `�
�v KEGEtVED _�
�,anr of F�i�vosw000 ���
April 22, 1998 � C��M�aNAGER �7
\�llG!r`,; -'-�
Ms. Eugenia Cano Mr. Ron Cox �r� .
City Attorney City Manager
City of Alvin City of Friendswood
216 West Sealy Street 910 South Friendswood
Alvin, Texas 7751 l Friendswood, Texas 77546-4845
Ms. Cheryl Wilson
Olson& Olson
3485 Three Allen Center
333 Clay Street
Houston, Texas 77002
Dear City Representatives:
C2 Consulting Services, Inc. ("C2") has completed its review of the FCC Form 1240s
submitted to the Cities of Alvin and Friendswood, Texas (the"Cities")by TCI
Cablevision of Houston("TCI" or the "Company") on or about March l, 1998. Because
of TCI's "rebuilding" activities, the Cities received two Form 1240 filings: H1632A for
the current services being offered; and H1632AR for the services TCI proposes to offer
subscribers upon completion of the "rebuild.'" The following report provides a brief
discussion of the differences between the two filings, the issues that were noted during
the review, and C2's recommendations regarding potential City Council actions far both
of TCI's proposed basic service rates.
This study does not constitute an examination of the financial condition of TCI or its
parent company. Therefore, C2 cannot and does not express any position with regard to
the accuracy or validity of the financial information provided by TCI during the course of
the analyses.
� TCI indicates in the filings that the"rebuild"will be completed prior to the end of the projected period
(May 1999). As a result, TCI must receive approval from the City Councils for a"rebuild"rate in order to
be able to charge such rate prior to the ne�annual rate filing.
'"" f... , ,
City Representatives � '
April 22, 1998
Page 2
OVERVIEW OF THE FILINGS
According to the information provided by TCI, services received via the current system
configuration(H1632A)total twenty-one basic service channels and seventeen expanded
basic service channels.2 TCI currently charges $11.88 for basic service and $12.62 for
expanded basic service. TCI proposes increases for these services of$0.68 and $0.51,
respectively, resulting in proposed monthly rates of$12.56 and $13.13 for the period
June, 1998 through May, 1999.
Based on the filing, the services to be offered via the "rebuild" system will not begin until
after January, 1999. The basic service will increase to twenty-five channels and the
expanded basic service will increase to thirty-three channels. TCI proposes to charge
subscribers $12.60 and$l 3.74, respectively, once a subscriber begins receiving the
additional services. The $0.04 difference between the two filings in TCI's proposed
basic service rates is due almost exclusively to added programming costs for providing
the Prevue and Sneak services which are not currently being offered.
TCI's proposed"true-up"calculations are the same for both filings because the true-up
period is from December 1996 through November 1997; a period during which additional
services were not available to any subscribers. The"projected" period calculations differ
between the two filings to reflect the additional channels and associated costs that are
proposed for 1999.�
There are three major factors which explain the approximate six percent increase in the
basic service rates for both of the filings:
1. TCI proposes significant programming cost increases for WTBS.
2. TCI has included an approximate seventeen percent reduction in the number
of subscribers during the projected period(impacting the adjustment for the
per subscriber true-up to be added to the rates)
3. The true-up segment includes six months of the period in which TCI chose to
charge an"operator selected rate"that was $0.25 less than the maximum
permitted rates approved by the Cities.4 The difference between the
2 These counts are as of December, 1997 and do not include the unregulated premium services.
Additionally,the counts are for full time programming even though TCl of�'ers a"shared"basic channel
and two"shared"expanded basic channels.
3 C2 notes that TCI does not provide additional cost information with regard to the expanded basic services.
However, based on the proposed channel line-ups,it appears that all channel changes will occur before
May, 1999.
4 The maximum permitted rate established for the period June 1996 thraugh May 1997 was$10.14. TCI
selected to charge only$9.89 for this period. Because there is a six month gap between the true-up period
and the projected period proposed by TCI,the last six months of the projected period from the 1996 filing
and the first six months of the projected period from the 1997 filing are included as the true-up period in
this filing.
City Representatives � '
Apri122, 1998
Page 3
maximum permitted and the operator selected rates are now being considered
under-collections on which interest is being added for a total true-up period
adj ustment.
ANALYSES OF THE FII,INGS
Project Objectives and Activities
The project objectives are three fold:
1. Assessment of the completeness of the filings with regard to the information
and documentation that must be filed with the Cities.
2. Assessment of the reasonableness of the proposed computations in light of
Cities' prior rate decisions, FCC regulation and recent FCC rulings.
3. Assessment of the reasonableness of the proposed computations in light of the
system specific costs and subscriber data.
Given these objectives, C2 conducted the following project activities5:
• Review of the filings to assess the completeness based on the FCC Form
instructions
• Review of the filings to identify any issues with respect to the data and/or
methodologies employed by TCI
• Submission of follow-up data requests and subsequent review of TCI's
responses
• Review of recent FCC decisions that may have an impact on TCPs proposed
methodologies or the Cities alternative actions
• Development of potential alternatives available to the Cities in establishing
maximum permitted basic service rates
Summary of Findings
C2 identified two issues with respect to TCPs proposed computations of basic service
rates. Both of the Form 1240 filings are impacted, only with slightly different results.
The issues are:
5 The project activities were conducted in tandem for both the Form 1240s and the Form 1205. Findings
and recommendations regarding the Form 1205 will be discussed in a separate report.
City Representatives � '
Apri122, 1998
Page 4
1. TCI did not begin with the ma�mum permitted rate ordered by the Cities for
the rate period beginning June, 1997 through May, 1998.
2. TCI's projected reduction in the subscribership appears excessive given the
levels of subscribers over the last several years.
1. 1997 Start Rate
Pursuant to the Form 1240 computations, annual filings provide for a true-up of rates
that have been charged during the preceding rate year based on actual external costs,
inflation, channel lineup and movement, and number of subscribers. In order to perform
this computation,the Form 1240 begins with the maximum permitted rate established by
the regulator(the city) during the preceding rate analyses and"trues-up"these
identifiable components of the rate.
In its 1997 filing, TCI proposed a maximum permitted basic service rate of$1].88. The
City of Alvin found this rate to be unreasonable and order a maximum permitted rate of
$11.63.6 The City of Friendswood denied any increase over the l 996 rate of$10.l 4. TCI
appealed both of these City decisions to the FCC; the FCC has not ruled on either
appeal.'
Because C2 reviewed the computation of the $11.88 rate filed in l 997 and recommended
that the monthly basic service rate be $11.63, C2's recommended approach is to start
with the $11.63 monthly rate on each of the filings presented this yearg. The impacts of
adjusting the "start rate"to $11.63 are an approximate $0.67 reduction on TCI's proposed
rate for the current system and an approximate $0.67 reduction on TCI's proposed rate
for the "rebuild" system. The significant reductions are not only due to the $0.25 lower
start rate,but also due to less under-recovery(plus interest) during the true-up period in
which a comparison is made between actual rates charged and the true-up of last year's
maximum permitted rates.
2. Projected Period Subscribership
The Form 1240 formula provides for projected cost/channel changes to be stated based
on a per subscriber impact. In order to do so, the cable operators must also project the
E'The vast majority of the recommended reduction in TCPs proposed 1997 rate was due to its
miscalculation of the true-up of the 1996"Gap"adjustment. Recently,the FCC also has ruled in a number
of CPST complaint proceedings that TCI miscalculated the"Gap"true-up for the expanded basic service
tier. In C2's opinion, such FCC rulings provide further support of the position taken by the City of Alvin in
setting maximum permitted basic service rates for the period June, 1997 through May, 1998.
'In addition to the appeal of the Cities' decisions, TCI requested that the FCC"stay"the effectiveness of
the Cities' ordered rates until such time that the FCC could render a decision with regard to the appeals. As
of the writing of this report,the FCC has not ruled on the requested"stay"of the Cities' decisions.
x Although recognizing that the City of Friendswood did not adopt the$11.63 in 1997, C2 has not
performed an alternative computation for the City because the$11.63 was recommended to the City by C2.
' r �a�.. .�� . _r.� f C
City Representatives �
April 22, 1998
Page 5
average number of subscribers that will be receiving services during the time period in
question. TCI employs a standard methodology for projecting subscribers by using a
historical monthly growth rate applied to the last monthly subscriber level during the
true-up period(which is November, 1997 for the instant filings). This same rate is
applied to each month through the end of the projected period(which is May, 1999). An
average of the resulting monthly subscriber counts for the period June, 1998 through
May, 1999 is then used as the projected average subscribership.
The number of subscribers for the Cities of Friendswood and Alvin have been declining
since September 1996. However, for the period July, 1995 (the first month included in
any Form 1240)through September 1996,the monthly level of subscribers was steadily
increasing. At no time during a historical period of twenty-nine months (July, l 995
through November, 1997) has the monthly level of subscribers been less than 10,235 (See
Exhibit A). Therefore, TCI's standard methodology of continuing to trend downward
over an additional eighteen month period(December, 1997 through May,1999)to an
average level of 8,974 does not appear reasonable based on the known monthly number
of subscribers.
Given the historical �rowth and decline in the monthly subscriber counts, the lowest level
during the historical twenty-nine month period appears to be a reasonable average
monthly count for the projected period. By adjusting the average projected
subscribership from TCI's proposed 8,974 to 10,235, TCI's proposed rates for basic
service are reduced an additional $0.08 per subscriber per month.y
SUMMARY OF RECOMMENDATIONS
Based on the above findings, C2 recommends the following adjustrnents be considered
by the Cities in determining the ma�mum permitted monthly basic service rates:
A1632A—Non-Rebuild Rate
1. The current maximum permitted basic service rate on Line A1 should be
$11.6335 instead of the $11.8828 included by the Company.
2. The Company's proposed estimated average basic service subscribership for
the projected period does not appear reasonable given the historical monthly
number of basic service subscribers and should be adjusted from 8,974 to
10,235 on Line B3.
3. The Cities should order a maximum permitted basic service rate of$11.8058
as compared to TCPs proposed$12.5595.10
9 The$0.08 reduction is the same for both the current system and the"rebuild" system.
lo Although the City of Friendswood denied the rate computation presented by TCI in 1997,thereby
retaining the maximum permitted rate of$10.14 estab(ished in 1996, C2 is not recommending that the 1998
rate be computed based on this 1996 level. C2's recommendation is based on the computation of Form
City Representatives �
April 22, 1998
Page 6
H1632AR—Rebuild Rate
1. The current maximum permitted basic service rate on Line A 1 should be
$11.6335 instead of the $11.8828 included by the Company.
2. The Company's proposed estimated average basic service subscribership for
the projected period does not appear reasonable given the historical monthly
number of basic service system subscribers and should be adjusted from 8,974
to 10,235 on Line B3.
3. The Cities should order a maximum permitted basic service rate of$11.8451
as compared to TCI's proposed $12.598."
Additional Issues and Recommendations
C2 notes that TCPs filing reflects Tier 2 rates to be increasing under both filings. As you
recall, these rates are regulated by the FCC, but only in the event that a complaint is �led
by the Cities. Pursuant to FCC regulations, a complaint can be filed by the franchising
authority upon receipt of multiple (more than one) complaints by subscribers within
ninety(90) days of the date the rate increase becomes effective.
C2 strongly recommends that the Cities file the appropriate complaint upon receipt of the
required subscriber complaints. As regulation of the Tier 2 rates is scheduled to"sunset"
in March 1999, a final review by the FCC should he conducted.
C2 greatly appreciates having this opportunity to work with the Cities of Alvin and
Friendswood. If you have any questions regarding this report, the project activities, or
any of the recommendations, please contact Ms. Connie Cannady at (972) 726-7216.
Very truly yours,
Co�- ��`� �.c-�,,,�e
�
C2 Consulting Services, Inc.
1240 components in this filing and their impacts on C2's recommended maximum permitted rate of
$11.6335 in 1997(See C2 Report dated April 21, 1997). However, since the City of Friendswood has one
year from the date this Form 1240 filing was submitted(February 1999) to render its final decision,the
City may wish to wait for a decision from the FCC on TCI's appeal of the City's 1997 rate decision before
determining the maximum permitted rates for 1998.
t 1 Id.
EXHIBIT A
MONTHLY BASIC SERVICE SUBSCRIBERS
JULY 1995 THROUGH NOVEMBER 1997
Month Subscribers
July 1995 11,319
August 11,417
September 11,351
October 11,385
November 11,330
December 11,333
January 1996 11,336
February 11,335
March 11,388
April 11,434
May 11,457
June 11,437
July 11,520
August 11,702
September 11,704
October 11,636
November 11,607
December 11,713
January 1997 11,665
February 11,259
March 10,902
April 10,781
May 10,730
June 10,649
July 10,623
August 10,533
September 10,391
October 10,314
November 10,235
Federal Comm�mications Commisaion H 1632A Approved by OMB 3066-0685 �
Washington,DC 20554
8.Stada of Previous Filing of FCC For�1210(enter an'z'in the appropriate boz)
Yliti I�O
a Has an FCC Fortn 1210 been previously filed with the FCC?
If yes,enter the date of the most recent filing: (mmlddlyy)
YES NO
b.Has an FCC Fmm 1210 been proviously f�7ed with the Franchicing Authority?
If yes,enter the date of the most recent filing: (mm(dd/yy)
9.Stadu of FCC For�1200 F�7ing(enter an"z"in the appropriate boz)
YES NO
a Hae an FCC Form 1200 been previously filed with the FCC?
If yes,enterthe date filed:�� (mm/dd/yy}
l'GS NO
b.Has an FCC Fotm 1200 been previously f�7ed with the Franchising Authority?
If yes,enter the date filed�-� (mm/dd/yy)
10.Cable Prograa�ing Services Co�plaint Status(enter an'z"in t6e appropriate boz)
1'I'.S NO
a Is this form being ft7ed m respoise to an FCC Form 329 complaint?
If yes,enter the date of the complaint (mmJddJ}+y)
YES NO
11.Is FCC For�1205 Being lncluded With This Filing
12.Selection of'Going Forward'C6annel Addition Mettrodology (enter an"z"m the appropriate boz}
�Check here if you are using the original niles [MARKUP METHOD].
�Check here if you are�aing the new,alternative niles[CAPS METHOD].
If ucing�e CAPS METHOD,have you elected to revise recovery for 1'ES NO
charmels added during the period May 15,1994 to Dec.31,1994?
13.Headend Upgrade Methodology
'NOT�:-Oprn/orsmus/eerti�ylal�Comm�ssion/beireG'gibililylouse/6isupgrademetbodo/agyaadadxbaoequipmenlG'slanddepreciaG'nasrbedu/e.
�Check hero if you are a qualifyirig smaU system iaing the sheamlined headend upgrade methodology.
Part I: Preliminary Inf ormation
Module A: Maximum Permitted Rate From Previous Filing
� n � a �
Linc Line Deuri tion IIuic Tier 2 Tiet 3 Tier 4 Tier 5
A1 Curreni Maximum Permilled Rate f I 1.6335
Module B: Subscnbershi
a b c d e
I.ine Line Dexri tiou Basic '1'ier 2 '1'icr 3 'Cier 4 'I�ier 5
BI Average Subscribership For Trurllp Perial 1 IO.N16
B2 Average Subxcibership For True-Up Yeriai 2
B3 F.stimated Average Subscribership For Projected Period 10,235
Module C: Inflation Information
Line Line Dexri lion
Cl l'nclaimed Inflalion:Opera�or Switching From 12101'0 1240 ���
Q Cnclaimed Inilaiion:Unmgulated Operalor Responding lo Rale Complaint ���
C3 lullation f�actor Por l�ue-Up Pcriod 1�WAs 1� LOIN7
C4 Inllnlion I�actor l�or�IFurUP Pcriod 2�Wks I J
CS Current FCC Inllalion Paclor
I.11l�lt
Module D: Calculating the Base Rate
a b c d c
t.ine Line Dexri tion Basic '1'ier 2 '1'ier 3 "1'ier 4 Tiu 5
DI Currem Headend Upgracle Segmem jp_p�pp
D2 Cucmnt ruternal Costs Segmen� $0.5732
D3 Current Caps Method Segmem sp.pppp
D4 Cutreni Markup Melhod Segmenl f0.pq�x�
US Curren�Channel hfovement and Deletion Segment 51.4262
D6 Currem"frue-Up Segment �.5571
Pa e 2 FCC Form 1240
S Microsoft Excel 4.0 Version ]uly 1996
Federal Communications Commission H 1632A Approved by OMB 30600685 �
Washington,DC 20554
D7 Curreul Idlation Segmeal 50.2271
DS Bax Rale[AI-01-D2-D3-D4-DS-D6D7j 58.8099
Part II: True-Up Period
Module E:Timing Information
Line Line Descri liou
El Whal Type of"I�rue-Up Is Being Pedormed?(Answer"1","2",or"3". See Instruc�ioos for a descriplion of Ihex lypes.) 2
If'1',go lo Module I. If'2',auswer E2 and E3. If'3',answer F.2,E3,G4,and E5.
E2 Number of Months iu ihe True-iJp Period 1 12
E3 Number of Moalhs between the end oI Trve-Up Periocl 1 and the end of 16e most recenl Projected Yeriocl 6
E4 \umber of hfonths in True-tip Period 2 Eligible(or Interest 0
ES ,�'umber o(Momhs True-Up Period 2 Ine6gible for Inlerest 0
Module F: Maximum Permitted Rate For True-Up Period 1
a b c d e
Line Line Ueuri lion Basic "1'ier 2 '1'ier 3 '1'ier 4 '1'ier 5
Pl Caps Melhal Segment ForTrue-Up Period 1(Wls 2J
F2 Markup Method Segmenl For True-Up Periai I[Wks 3] f0.0483
F3 C6m Mvmnt Delem Segment ForTcue-Up Period 1(Wks'4/5] 51.3411
F4 True-Up Penod 1 Rate Eligible For Intlation(DB+FI+F2+F3] $10.1993
FS Intlauon Segment[or 7'rue-Up Period 1[(F4•C3)-F4j f0.1903
F6 fIendend Upgracle Segment For True-Up Period 1[Wks bJ
F� Eztemal Costs Segment ForTrue-Up Period 1[Wks 7] 50.3546
FB True-LJp Segment For True-Up Period I 50.6145
F9 Mau Perm Rate for True-Up Perial 1(F4+FS+F6+F7+F8] 511.3587
Module G: Maximum Permitted Rate For True-Up Period 2
a b c d e
I.ine Line Descri lion Basic '1'icr 2 '1'ier 3 'fier 4 "fier 5
Gl Caps Me�hocl Segment For True-Up Perial2[Wks 2�
G2 Markup hfei6oci Segmeut For True-Up Period 2[Wks 3]
G3 Chan hlvmnt Deletn Segmem�or True-Up Period 2�Wks'MS]
G4 TL'Periocl2 Rate EGgible For Intlation[DB+FS+G1+G2+G3]
GS Inflation Segmem for True-Up Period 2[(G4'C4)-G4)
G6 Headend Upgrade Segment For True-Up Period 2�Wks 6]
G7 Extemal Costs Segmenl For True-Up Yenod 2[Wks 7j
GA �I�rue-lJp Segmenl For 1'rue-Up Periai 2
G9 :11ax Perm Rate for Trve-Up Periai 2[G4+GS+G6+G7+G8]
FCC Form 1240
Page 3 Microsofl Exce14.0 Versioa )u1y 1996
Federel Communicuions Commission H 1632A Approved by OMB 3060-0685
Wachington,DC 20554
Module H:True-Up Adjustment Calculation
a b c d e
I.ine Line Deuri tion Basic Tier 2 Tier 3 Tier 4 Tier 5
Adjuslment For True-Up Period 1
H1 Revenue From Period 1 51.412.785.92
H2 Revenue From Max Permitted Rate for Period 1 SI,474,274.7478
H3 Tnu-0p Penod 1 Adjuslment[H2-H I] 561.4Rf1.A27A
H4 Iu�ereu on Period 1 Adjustment 57.112.0476
Adjustmeet Fw Ttve-Up Period 2
HS Revenue From Periai 2 Eligible for luterest
H6 Revenue From Max Perm Ra�e for Period 2 Eligible For Interest
EI7 Period 2 AdjustmeW Eligible For Inleresl[H6-HS]
H8 Iulerest ou Period 2 Adjuslmenl(See insWctions for formula)
H9 Revenue From PeriocJ 2 Ineligible for laleresi
H 10 Revenue From Mau Perm Rate for Period 21neGgible for lateresi
H1 t Periai 2 Adjus�ment loeligible For Interesi[H10-H9]
Total True-Up Adjualment
H12 Previous Remaining Truc-Up Adjustmeat
1i13 TotalTrve-UpAdjustment[H3+H4+H7+Hfi+Hl1+H12� SbH.600.8754
H 14 Amouat o(Ttue-Up Claimed For This Projected Periai 568,600.H754
H15 RemainiugTnce-UpAdjustmenl[HI�H14] $0.0000
Part III: Projected Period
Module I: New Maximum Permitted Rate
a b c d e
Liae Line Deuri tion Basic Tier 2 Tier 3 '1'ier 4 Tier 5
Il Caps Methai Segment For Projecled Periai[Wks 2]
12 Mukup MeWal Segment For Projecled Perioci[Wks 3] SO.W00
13 Chan Mvmn1 Deletn Segmeut For Projected Yeriod[Wks 4/5] 513411
14 Proj.Perial Rale Eligible For luflation[DA+FS+GS+I1+12+I3] S10.4013
IS Inllatiou Segment for Projecled Periai�(14'CS)-14] $0.14N7
16 Headend UpgraJe Segment For Yrojeded Penod[Wks 6]
I7 Eutemal Costs Segmeul For Projecled Periai[Wks 7j f0.6972
IS True-Up Segment For Projecled Periai $0.5585
I9 Ma�c Permiued Rale for Projeclecl Perial[I4+I5+16+17+18] SI I.ti05H
I10 Operalor Selected Rate For Rojecled Period 512.56
h'ae.•7Lemaximumpe�milledra/elBuaesdooa!lakeioloaccaualaoymluadGabi/ilyyouo�ayha�c. J/youharepre�ious/}'Creaoirlemdby/6eCnoimissino�rour/ara/haa�bisrogaulbanlr-/oma.fereluads.
,vou are aamG"e�edo!yav obGgaG'oa m maEe suebmluods e veo illbe prrmil/edrele is 6igber�baalbe roolesled�a/e o�rnureuimn�reie.
CCltIfICBIIOII$�fltC1EDt
WILLFUL FALSE S1'ATEMENTS MADE ON THIS FORM ARE PUNISHABLE BY FINE ANDIOR IMPRISONMENT
(U.S.CODE TITLE 18,SECTION 1001),AND/OR FORFEITURE(U.S.CODE,TITLE 41,SECT[ON 503).
1 cert' that tfie statementc made in thic form aze true and correct to the best of m knowle e and belief and are made in ood faith
SignaWre Date
Name and Title of Person Completing thi�Form:
Telephone number Fa�c Number
FCC Form 1240
Page 4 Microsofl Excel 4.0 Version Iuly 1996
Fedcral Cammvnica�tions Cammission Appraved By Olu[S 3060-0685
4�lashington,DC 24554
Worksheet 1 - True-Up Period Inflation
For instructions,see Appendix A of Instructions For FCC Form 1240
Line PcrioJ FCC Inflatiun FacWr
101 Month 1 1.83%
]02 Month 2 2.70°/a
103 Month 3 2.70%
lU4 Month 4 2.70%
105 Month 5 1.77%
106 Month 6 1.77%
107 Month 7 1.77%
108 Month 8 1.43%
109 Month 9 1.43'%
1 l0 Month 10 1.43%
111 Month 11 1.43%
112 Month 12 1.43%
]13 Average Intlation Factor for True-Up 1.0187
Period 1
114 Month 13
115 Month 14
I 16 Month I S
I 17 Month 16
118 Month 17
119 Month l8
120 Month 19
121 Month 20
122 Month 21
123 Month 22
124 Month 23
12S Month 24
126 Average Inflation Factor for True-Up
Period 2
FCC Porm i2d0
Pagc 1 ]u[icrosoh Extcl b.0�Tcrsion July 1946
Federal Communicatiors Commission Approved By OMB 3060-0685
Wastimgton,DC 20554
Worksheet 3 - Markup Method
True-Up Period, Basic Tier
For inswc[ions,see Appendix A of Instructioas For FCC Form 1240
True-Up Yeriod Projected Period
Question 1.Indica[e the period for which this worksheet is being used.(Put an"X"in[he appropriate box.) S
Question 2.Indicate the tier for which[his worksheet is being used.(Put an"X"in the appropriate box.)
Bacic Tier 2 Tier 3 Tier 4 7ier 5
X
Question 3.How long is the first period,in months,for which rates are being se[with this worksheet'? 12
Question 4.How long is Ihe second period,in months,for which rates are being set with this workshee[? 0
1 2 3 4 5 6 7
Line Period Saa of Pteviaas Sa�of Cwrent Averagc Per Chamel Chamels Total Cuadative
Regulffied C6annels Regulated Channel Channels Adjus�ent Added Adj�t�ent AdjusUaent
301 Previous Morth s0.04
302 Month 1 37 37 37.0 s0.02 0 50.00 =0.04
303 Month 2 37 31 37_0 �0.02 0 =0.00 �0.04
304 Mondi 3 37 37 37.0 =0_02 0 =0.00 =0.0�
305 Month 4 37 37 37.0 ;0.02 0 =0.00 =0.04
306 Month 5 37 37 37.0 =0.02 0 =0.00 =0.0�
307 Month 6 37 37 37.0 ;0.02 0 �0.00 =0.0�
308 Month 7 37 37 37_0 SO_02 0 =0_00 =0_04
309 Montlt8 37 38 37.5 50.02 1 50.02 s0.06
310 Montli 9 38 38 38.0 50.02 0 :0.00 s0.06
311 Month 10 38 38 38.0 �0.02 0 =0.00 =0.06
312 Month 11 38 38 38.0 50.02 0 =0.00 s0.06
313 Month 12 38 38 38.0 j0_02 0 50.00 =0_06
314 Average Period 1 Martup Method Adjustaent s0.0�83
315 Month 13
316 Month 14
317 Month 15
318 Month 16
319 Month 17
320 Montfi 18
321 Month 19
322 Mondt 20
323 Month 21
324 Month 22
325 Month 23
326 Month 24
327 Average Period Z Caps Mcthod Adjushent
FCC Foim 1240
Page 1 Microsoft Excel 4.0 Ve�sion July 1996
Fede�al Communicatim►s Comm'ssion Approved By OMB 3060-0685
Washmgton,DC 20554
Worksheet 3 - Markup Method
Projected Period, Basic Tier
For inswctions,see Appendix A of InsVUCtions For FCC Form 1240
Tme-Up Period Projected Period
Question L Indicate the period for which this worksheet is being used.(Pu[:m"X"in the appropnate box.) \
Question 2.lndica[e[he[ier for which this worksheet is being ust;d.(I'ut an"X"in th�nppropriat��ix.)
Batic Tier 2 Tier 3 Tier 4 Tia 5
X
Question 3.How long is ihe first period,in months,for which rates are being set with this worksheet? 12
Qaes[ion 4.How long is the second periocl,in months,for which ra[es are being set with this workshecP? 0
1 2 3 4 5 6 7
Line P�riod Sa�of Previoas Sua of Curreat Average Per Channel Chamels Total Cmiulative
Regulated Channels Regulatcd Chamel Channels Adjustaent Added Adjusbaent Adjiataent
301 Previous Month 50.06
302 Monfh 1 38 38 38.0 �0.02 0 50.00 t0.06
303 Month 2 38 38 38.0 50.02 0 s0.00 =0.06
304 Mondi 3 38 38 38_0 s0.02 0 =0.00 =0.06
305 Monih 4 38 38 38.0 50.02 0 =0.00 s0.06
306 Month 5 38 38 38.0 =0_02 0 j0.00 =0.06
307 Month 6 38 38 38.0 =0.02 0 =0.00 =0.06
308 Month T 38 38 38.0 50.02 0 s0.00 50.06
309 Mon�8 38 38 38.0 s0.02 0 =0.00 s0.06
310 Month 9 38 38 38.0 50.02 0 50.00 50.06
311 Month 10 38 38 38_0 s0.02 0 =0.00 s0.06
312 Morth 11 38 38 38.0 SO_02 0 =0.00 50.06
313 MoNh 12 38 38 38_0 ;0.02 0 =0.00 :0_06
314 Average Period 1 Markup Method Adjusdent s0.0600
FCC Fosm 1240
Page 1 Microsoft Excel 4.0 Ve�sion July 1996
Fedcral Communicatio�s Commasion Approved By OMB 3060-0685
Washington,DC 20554
Worksheet 4 - Residual
True-Up Period
For instructions,see Appendis A of Ins[ructions For FCC Fortn 1240
(?uestion l.Indicate the period for which this workshee[is being used.(Put an°X"in the appropriate box.) True-Up Period Projected Period
\
a b c d e
Line Line Descri tion Basic Tier 2 Tier 3 Ticr 4 Tier 5
Period One
401 Average Permitted Charge $10.8850 $13.1450
402 Average Extemal CosL� $0.3546 $4.8677
Average Total Per Chacmel Adj�entc aher 5J14/94 for
403 Chacmels Added Using Caps Method $�'�
404 Average Tier Residual[401-402-403] 510.530A 58.2773
405 Average Chazu�els per Regulated Tier 20.5000 17.0000
406 Average Caps Method Channels per Tier 0.0000 0.0000
407 Average Remaining Chazmels(405-406) 20.SU00 17.OIN10
408 Average Period 1 Per Charmel Residual[4041407] $0.5137 50.4869
Period Two
409 Average Petmitted Charge
410 Average Extemal Costs
411 A°erage Total Per Chatmel Adjustments aher 5(14�94 for
Channels Added Using Caps Method
412 Average Tier Residual[409-410-411]
413 Average Channels per Regulated Tier
414 Average Caps Metfiod Channels per Tier
415 Average Remaining Charmels @13-414]
416 Average Period 2 Per Chazmel Residual[412/415]
FCC Form 1240
Page 1 Microso$Excel 4.0 Version JWy 1996
Federal Communicatior�c Comm'ssion Approved By OMB 3060-0655
Washmgton,DC 20554
Worksheet 5 - Channel Movement and Deletion
True-Up Period, Basic Tier
For ins[ructions,see Appendi�c A of TnsWctions For FCC Fonn 1240
Question L[ndicate the period for which this worksheet is being used.(Put an"X"in the appropriate box.)
'frue-Up Yeriai Projected Penai
�
Question 2.Indica[e the tier for which this worksheet is being used.(Put an"X"in the appropria[e box.)
Basic Tier 2 Tier 3 Tier 4 Tier 5
X
(luesiion 3.How long is the firs[period,in months,lor which rates are bcing u:[with thix workshect? 12
Quesuon 4.f iow long is the second period,in months,f'or which rates are bcing se[with this workshecC> 0
1 2 3 4
Nct PerC6annel Cost
Residual of Channels De(eted Residual of CLannels Moved Cu�ulative Net PerC6aonel
Lme Period Fro�Tier (added)to Tier Adjustaent[Ciu�n 2-Colu�n Cost Adjust�ent
501 Prcvio�a Pcriod =0.�000
502 Month 1 50.0000 g0.9411 s0.9411 =1.3�11
503 Month2 50.0000 S0.0000 S0.0000 =1.3�11
504 Month3 S0.0000 S0.0000 50.0000 s13411
505 Month4 50.0000 50.0000 :0.0000 513�11
506 MonthS S0.0000 S0.0�00 ;0.0000 =13�11
507 MoNh6 S0.0000 $0.0000 =0.0000 s1.3�11
508 Month7 $0.0000 S0.0000 s0.0000 =1.3�11
509 Month 8 50.0000 $0.0000 =0.0000 =13411
510 Month 9 S0.0000 50.0000 s0.0000 =13411
511 Month 10 50.0000 50.0000 50.0000 Z1.3411
512 Month 11 S0.0000 50.0000 :0.0000 s1.3�11
513 Month 12 S0.0000 $0.0000 =0_0000 s1.3�11
514 Average Period 1 Channel Moverent and Delction Adjustaent s13111
515 Month 13
516 Month 14
517 Month 15
518 Month 16
519 Month 17
520 Month 18
521 Month 19
522 Month 20
523 Morrth 21
524 Month 22
525 Month 23
526 Month 24
527 Average Period 2 Cha�mel Moveeent and Deletion Adjustrent
FCC Foim 1240
Page 1 Microsoh Escel 4.0 Vecsion July 1996
Federal Communicationc Commiscion Approved By OMB 3060-0685
Wachington,DC 20554
Worksheet _5 - Channel Movement and Deletion
Projected Period, Basic Tier
For instructions,see Appendix A of Instructions For FCC Fortn 1240
Question 1.Indicate[he period for which this worksheet is being used.(Put an"X"in the appropriate box.)
Truc-Up Penal Projected Period
�
Question 2.[ndica[e the tier for which this worksheet is being used.(Put an"X"in[he appmpriate box.)
Baeic Tier 2 Tier 3 Tier 4 Tier 5
�
Question 3.How long is the first period,in months,for which rates are being set with Ihis worksheeP? 12
Question 4.How long is the second period,in months,for which rates aze being set with this worksheet? 0
1 2 3 4
Net PerCham�el Cost
Rrsidual of Chanaels Deleted Residual of Channels Moved Cu�ulativo Net PerC6ame1
I_ine Period Fro�Tier (added)to Tier Adjushent[Ciu�n 2-Colu�n Cost Adjas�ent
501 Previoiu Period �13411
502 Month 1 $0.0000 $0.0000 s0.0000 51.3411
503 Month2 50.0000 50.0000 50.0000 513411
504 Month 3 50.0000 $0.0000 �0.0000 513411
505 Month 4 50.0000 50.0000 Z0.0000 =1.3411
506 MonthS s0.0000 50.0000 s0.0000 51.3�11
507 Month6 50.0000 50.0000 ;0.0000 513�11
508 Month 7 $0.0000 50.0000 =0.0000 51.3411
509 Month8 $0.0000 50.0000 :0.0000 51.3�11
510 Month9 $0.0000 S0.0000 ;0.0000 s13411
511 Month 10 S0.0000 50.0000 ;0.0000 513�11
si2 n�tonm ii So.0000 So.0000 So.0000 =1.3411
513 Month 12 50.0000 50.0000 =0.0000 51.3411
514 Average Peciod 1 Channel Move�ent and Deletion Adjust�ent =1.3411
FCC Form 1240
Page 1 Microsoft Excel 4.0 Version July 1996
Federal Communications Commission Approved By OMB 306Q0G85
W ashiugton,DC 20554
Worksheet 7- External Costs
True-Up Period
For instructioos,eee Appendix A of InsVuctions For FCC Form 1240
'I'rue-Up Pnriod Prujix;ted Pnriod
Question l.For which time period arc you filling out thia worksheet? [Put en"X"in Ihe appropriate box.J S
Question 2.How long is the fvat period,in montha,for which rates are being set with Utis worksheet? 12
Qiestion 3.How long is ihe aecond period,in monthx,for which rates are being set with this worksheet'? 0
a c e
1a�e Line Deycri tion Ruxic 7'ier 2 '1'ier 3 Tier J Tier 5
PcriuJ 1
External Costs Eligible for Marku
Cost of Pro�amming For Charmels Added Privr to 5/15/94 or
��� After 5/I S/94I1xing Merkup Methal For Period 525,398.09 5552,176.9!!
702 Retransmission Con.rent Feea Por Period $0.00 �O.UO
703 Copyright Fees For Periai $12,006.04 $15,806.84
7U4 E:ctumal Cos�s Eligible For 7.5°/hterkup $37,404.13 �517,983.N2
705 hlarlcul Up E�tlernal Cosis $4Q209.d398 $610,582.6065
External Costs Not Eli ible for Marku
706 Cable Specific Taxes Por Prriod $0.00 $QOU
707 Franchise Related Cosls For Period $0.00 $0.00
708 Commission Regulntory Fees For Period $5,81925 $O.OU
709 7'otal F�ctemal Costs For Period $46,028.6898 $610,582.6065
710 n1onthly,Per-Subseriber E�c[emal Costs For Period 1 $03546 $4.it677
Period 2
Extcrnrl Custs Eli ible for Marku
�" Cost of Programloing For Chanc�els Addcd Prior to 5/I S/94 or
Afler 5/I S/94 Ueing Markup Method For Period
712 Ket.nn_ission Consent Fecs For Period
�13 Copyright Fees For Period
714 Exlemal Cos�e Eligible For 7.5%Msrkup
715 Ma�ed Up lxtcYnal CoaW
Eaternel Costs Not Eligible for Marku
716 Ceble Spec�c Taxes For Period
717 Frane:hise Related CosLs For Penod
718 Commission Regulatory Fees For Period
719 Total Extemsl CosLs For Period
720 Monlhly,Per-Subscriber EMernal('os�s For Perioei 2
FCC Form 1240
Page 1 Microso(1 Exce14.0 Version July 1996
Federal Communications Commission Approved By OAIB 306(106N5
Washiugtou,DC 20554
Worksheet 7- External Costs
Projected Period
For inswctions,see Appendix A of Inswctions For FCC Form 1240
True-Up Period Projccted Pmod
Question 1.For wtiich time period arc yw filling out fLis workaheet? [Put an"X"in Ihe appropriate box� \
Question 2.How long is the fust period,in monihs,for wltich rates are being set with Ihia workshect'? 12
Ques[ion 3.How long ia the second period,in months,for which rates are being set with lhis wor4:sheet? 0
a e e
Line line Descri tion Banic Tier 2 'Pier 3 Tier� Tier 5
Period 1
Eaternal Cogts Eli 'ble for Markup
Cost of Programming For Channels Added Prior to 5/15/94 or
70l �5/IS/94 Ueing Markup MetLod For Period �3,153.02 $531,474.12
702 Retranemiseion Consent Fees For Yeriod $0.00 50.00
703 Copyright Feee For Period $11,360.85 $12,919.17
7U4 EMernel('osts Eligible For 7.5%Markup $74,513.87 $SJ4,3Y3.49
705 Marked Up Exlemal Costa Sfi0.102.3103 $SR5,223.INq 8
Ezternal Costs Nut Eli 'ble fur Nlarku
706 Cable Specific Taxea For Period $0.00 50.00
707 Franchiae Relaled Costs For Period $0.00 $0.00
708 Commiasion Regulatory Fees For Period $5,526.90 $0.00
709 Total External Cos1s For Period $85,6293103 $585,223.0018
710 Monthly,Per-Subscriber E�¢emal Coats For Period 1 $0.6972 55.7079
FCC Form 1240
Page 2 Microsofl Exce14.0 Version Iuly 1996
Federal Communicatio�Comm'ssion Approved By OMB 3060-0685
Washington,DC 20554
Worksheet 8 - True-Up Rate Charged
For instructions,see Appendix A of Inswctions Por FCC Form 1240
Question 1.How long is the True-Up Period 1,in mon[hs? 12
Question 2.How long is the True-Up Period 2,in months? 0
a b c d e
L'me L'me Description Basic Tier 2 Tier 3 Tier� Tier 5
801 MoNh 1 S9.8900 513.6700
802 Month2 59.8900 513.6700
803 MoNh 3 59.8900 513.6700
804 Month4 59.8900 513.6700
805 Month 5 59.8900 513.6700
806 Month6 59.8900 513.6700
807 Month 1 511.8800 512.6200
808 MonthB 511.8800 S12.6200
809 Montfi9 511.8800 512.6200
810 Montft 10 S11.8800 S12.6200
sii Mo�ii Sll.ssoo Sla.b2oo
812 Month 12 511.8800 512.6200
813 Period 1 Average Rate 510.8850 s13.1450
814 Month 13
815 Month 14
816 Month 15
817 Month 16
818 Month 17
819 Month 18
820 Month 19
821 Mon�20
822 Month 21
823 Month 22
824 Month 23
825 Month 24
826 Period 2 Average Rate
FCC Form 1240
Page 1 Microsoh Excel 4.0 Version July 1996
Federal Communications Commission H 1632AR Approved by 06iB 306[FObHS
1Yachington,DC 20554
8.Stat�of Previoas F�7ing of FCC Fora 1210{enter an"z'in the appropriate boz)
YFS NO
a Has an FCC Form 1210 been previoiuly filed with the FCC?
If yes,enter the date of the most recent filing: (mm�dcUyy)
YES NO
b.Hffi an FCC Fo�m 1210 been previo�ly f�ed with the Franchising Authority?
If yes,enter the date of the most recent filing: (mm�dd/yy)
9.StaU�s of FCC For�1200 Filing(enter an'z'in tfie appropriate boz)
1'ES NO
a Hac an FCC Form 1200 been previoiuly filed with the FCC?
If yes,enter the date f�7ed: (mm/dd/yy)
t�rs No
b.Has an FCC Foim 1200 been pceviously fded wilfi the Franchising Autfiority?
(f yes,enter the date filed {mm/ddlyy)
10.Cable Progra�=ing Services Co�plaint Status(enter an"i in ffie appropriate boz)
YI?S NO
a Is this form being filed in response to an FCC Form 329 complamt?
Ifyes,enterthe date of the complaint (mmldd/yy)
YES NO
11.Is FCC Foa 1205 Being Included Wiffi This Filing
12.Seleetion of'Going Forward'Channel Addition Methodology (enter an'z`in the appropriate boz)
�Check here if you are using the original niles [MARKUP METHOD].
�Check hero if you are using the new,altemative niles[CAPS METHOD].
If iaing the CAPS METHOD,have you elected to revise recovery for 1'F.S No
chazmels added dwv�g the period May 15,1994 to Dec.31,1994?
13.Headend Upgrade Methodology
'NOT�:�Operelo�smus/cetily/ol6e CommissianldevelgibiJi/y/o use lhis upgiaae melbaln/ogy aod a/lacb aa eyuipmea/G's!aadr/epreciaGOa.u�edu/e.
�Check here if you are a quali(ying small system using the streamiined headend upgrade methodology.
Part I: Preliminary Inf ormation
Module A: Maximum Permitted Rate From Previous Filing
a b c d e
Line Liue Descri liou 13asic Tier 2 Tier 3 Tier 4 "Cier 5
A1 Currem Mnuimum Yermitted Rate SI 1.6335
Module B: Subscribershi
a b c d e
Line Line Deuri liou 13asic 'fier 2 "fier 3 "Cier 4 'Pier 5
D 1 Average Subxribership Por Trve-Up Perial t 10.816
R2 Average Subxribership Por True-Up Perial 2
H3 Esiunated Average Subscribership For Rojecled Perioci 10,235
Module C: Inflation Information
I.ine Line Deuri 'on
C 1 Unclaimed Inflalion:Opernlor tiwitching From 1210'I'o 1240 ���
C2 Cnclaimed Int7atioa Unregulaied Operalor Responding io Ra�c Compininl ���x�
C3 1nflaiiouFaclorFor"live-UpPeriod I(Wks 1� ���n�
C4 Intlation Fnc�or For7iue-Op Ycrial2�Wks lJ
CS Cuaenl FCC Id�lalion Paclor ����3
Module D: Calculating the Base Rate
. n � a �
Line Line Descri ion Basic "1'ier 2 Tier 3 'fier 4 Tier 5
D1 Currem Headend Upgrade Segment sp.pppp
D2 Cwmm Esternal Costs Segment $0.5732
D3 Cwmn�Caps Melhod Segmen� fp,pppp
D4 Curreni Markup Melhod Segmem f0.04W
DS Current Channel biovement and Deletion Segment $1.4262
D6 Curten�True-Up Segmem s0.5571
FCC Form 1240
Yage 2 Microsott Exce14.0 Versioa July 1996
Federal Communicatione Commission H 1632AR Approved by OMB 3060-062�5
Washinglon,DC 20554
D7 Currcul latlation Segmen� 50.2271
D8 Base Rate[AI-D1-D2-D3D4-DS-D(rD7] Sti•81M9
Part II: True-Up Period
Module E:Timing In[ormation
Line Line Descri lion
C1 Whai 7ype of True-L'p Is Being Performed?(Answer"1","2",or"3". See Insuvctions for a descriplion of these�ypes.) 2
If'1',go to Module I. If'2",auswer E2 aud E3. If'3',aaswer E2,E3,G4,and E5.
E2 'Vumber of MoNhs in the True-Up Period 1 12
E3 :�umber of Months belween Ihe eud of True-Up Period 1 and Ihe end of Ihe most recent Projected Period 6
G4 lumber of Mont6s in True-Up Penod 2 Gligible for Iateres� �
F.5 Number o(Monlhs Tme-Up Perial 2 IneGgible(or Inlerest �
Module F: Maximum Permitted Rate For True-Up Period 1
a b c d e
Line Line Deuri lion Basic Tier 2 Tier 3 Tier 4 Tier 5
Fl Caps btelh«1 Segmeu�For True-Up Period 1[Wks 2j
F2 Mazkup Diethod Segmeni For True-Up Period 1[Wks 3] 50.0483
F3 Chen Mvmnt Dele�n Segmenl For Tme-Up Period 1[Wks'4/5] 513411
F4 Ttve-Up Period 1 Rate EGgible For Intlatiou[D8+F1+F2+F3� 510.1993
F� Inilation Segment for True-Up Period 1[(F4`C3)-F4] $0.1903
F6 Ileaciend Upgrade Segmenl For"1'rue-Up Yeriai I�Wks 6�
F7 Exlernal Cosls Segmenl For True-Up Yeriod 1(Wks 7J 50.3546
F8 True-Up Segmenl For True-Up Penod 1 50.6145
F9 Max Perm Rate for True-Up Yeriod 1(F4+FS+F6rF7+FR] 511.3587
Module G: Maximum Permitted Rate For True-Up Period 2
a b c d e
I.ine Line Descri lion Basic Tier 2 'Tier 3 Tier 4 Tier 5
G� Caps lfelhal Segment For'I'rue-Up Perioci 2[Wks 2�
G2 Markup Melhod Segment ForTrue-Up Periai 2[Wks 3]
G3 Chan 1f��mnt Deleln Segmenl For True-Up Period 2[Wks'4/5]
G4 1U Peria12 Rate Eligible For ldla�ioa[DS+FS+G1+G2+G3)
GS Ivf7ation Segment tor I'rue-Up Period 2[(G4'C4)-G4J
G6 Heaciend L'pgracie Segmenl Por'I'rue-Up Period 2(Wks 6�
G7 External Cos�s Segment For"Crue-Up Period 2[Wks 7J
G8 True-Up Segment For True-Up Period 2
G9 Max Perm Rate for True-Up Period 2[G4+GS+G6+G7+G8]
FCC Form 1240
Page 3 Microsofl Exce14.0 Version July 1996
Federal Communications Commisaion H 1632AR Approved by OMB 306o-0685
Washington,DC 20554
Module H:True-Up Adjustment Calculation
a b c d e
Line Line Descri lion I3asic "fier 2 '1'ier 3 "I'ier 4 Tier 5
Adjustment For Tnu-Up Period 1
fll Revenue trom Petial 1 5�.412,785.92
H2 Revenue From Max YermiUecJ Rate tor Perial I 51.474,274J47H
H3 True-Up Period 1 Adjuslmen�[H2-Hl] 561.4t38.8278
H4 Interest on Period 1 Adjustwenl 57.112.0476
Adjuslmeut For True-Up Period 2
HS Revenue From Peri«12 Eligible(or Interest
H6 Revenue From Mau Perm Rate for Period 2 E6gible For Interest
H7 Period 2 Adjuslment Eligible For ln4rcsl[Fi6-HS]
HR I¢leresl on Period 2 Adjustmeul(See insWCUons for(ormula)
H9 Revenae From Period 2 Ineligibie for In�eresl
H10 Revenue From Max Perm Rate for Period 2 Ineligible for Inleresl
Hll Periocl 2 Adjux�meni Inefigible For luterest�H10-H9)
'Colal True-Up Adjustmeul
H 12 Previous Remaining True-Up Adjuslment
Hl3 'TolalTrue-LpAdjustmenl[H3+H4+H7+H8+Hll+H12� f68.600.fl754
H l4 Amount of"Crue-Up Cleimed For'Ihis I'rojected Yerial S6t3,600.8754
H15 RemainingTnu-UpAdjuslment[H13-H14) 50.0000
Part III: Proiected Period
Module I: New Maximum Permitted Rate
a b c d e
Line Line Deuri tion Basic Ticr 2 Tier 3 Tier 4 Tier 5
II Caps Method Segment For Rojected Veriod[Wks 2]
I2 Mazkup Met6od Segmeul For Projected Period(Wks 3J 50.0�67
13 C6au Mvmul Deleln Segmeul 1=or Projecled Perial[Wks 4/5] 513411
I4 f'roj.Period Rale EGgibk For Inilauon(DB+FS+GS+I1+I2+13] S10A18
IS Iu(lation Segmeul for Projected Period[(I4'CS)-14] f0.149
I6 HeazlenJ Upgruie Segmenl For ProjecleJ Penal[Wks 6)
17 Exlernal Costs Segment For Projecled Periocl(Wks 7] 50.7196
IS True-Up Segmeni Fot Projecled Period $O.SSHS
19 D1ax Permiued Ra�c for Projeclecl Period[1MI5+16+I7+18] Sl l.l3451
I10 Operator Selecled Ra1e For Projected Period 512.60
Note:7bemaximumprrmi!led�a/elguresdoadla(eio/oaccounlaayreluodG'abiG'lvyauaiay6arc. /lyou6a�epre�r'nus/vlreonniemdbvl6eCon�issino o��'niv/ora/lranrdisiop aulborin ioma.(emlundt
rou are nnlreGe i cd o!your ablBalina Iomafe sucb reluads e�za illbe permi/Iedrete is digbe�/baolbe roa�es/edre�e o�i nurcrumolre�e.
Certification State�ent
WILLFUL FALSE STATEMENTS MADE ON THIS FORM ARE PUNISHABLE BY FINE ANDI�R IMPRISONMENT
(U.S.CODE TITLE 18,SECTION 1001),AIYD/OR FORFEITURE(U.S.CODE,TITLE 47,SECTIOIY 503).
I cert that H�e statemenis made in this form are We and correct to the best of m knowle e and belief and are made in ood faith
Signature Date
Name and Title of Person Completing thic Form:
Telephone number Fax Number
FCC Frnm 1240
Yage 4 Microsofl lixcel 4.0 Version July�199b
Federal Communicatiors Commnsion Approved By OMB 3060-0685
Washington,DC 20554
Worksheet 1 - True-Up Period Intlation
For instructions,see Appendix A of Instructions For FCC Form 1240
Line Yeriod FCC lntlation b'actor
101 Month 1 1.83°'0
102 Month 2 2.70%
103 Month 3 2.70°i
l04 Month 4 2.70%
105 Mon[h 5 I.77 ro
106 Month 6 I 97°.o
107 Month 7 I.77%o
108 Month S 1.43%
l09 Mon[h 9 1.43%
110 Month 10 1.43°�0
L i 1 Month I I L43%
1l2 Month l2 1.43°-L
'�3 Average Inflation Factor for True-Up ���g�
Period 1
114 Month 13
115 Mcmth 14
11G Month 15
I17 Month 16
118 Month 17
119 Month 18
I20 Month 19
l21 Month 20
l22 Month 21
123 Mon[h 22
l24 Month 23
l25 Mon[h 24
�26 Average Inflation Factor for T�ue-Up
Period 2
FCC Form 1240
Page 1 Microsoft Exce14.O Version July 1996
Federal Communicatio�s Commission Approved By OMB 3060-0685
Wachington,DC 20554
Worksheet 3 - Markup Method
True-Up Period, Basic Tier
For ins[ruclions,see Appendix A of Instruclions For FCC Fortn 1240
True-Up Period Projected Period
Question 1.Indicate Ihe period for which[his worksheet is being used.(Yu[an"X"in the appropriate box.) X
Question 2.Indicate[he tier for which this worksheet is being used.(Put an"X"in[he appropriate box.)
Basic Tier 2 Tier 3 Tier 4 Tier 5
Y
Question 3.How long is[he first period,in mon[hs,for which rates are being set with this worksheet? 12
Question 4.How long is the second period,in months,lor which ra[es are being set wi[h this worksheel? �
1 2 3 � 5 6 7
Lme Period Sua of Previous Su�ot Cwrent Average Per Chamel Channels Total Cuiulative
Regulated Channels Regulated Channel Channels Adjustaent Added Adj��nt Adj�taent
301 Previo�u Month 50.04
i02 Month 1 37 37 37_0 50.02 0 50.00 50.0�
303 Month 2 37 37 31.0 s0.02 0 50.00 �0.04
304 Mondi3 37 37 37.0 ;0.02 0 =0.00 =0.04
305 Month 4 37 37 37.0 Z0.02 0 s0.00 =0.04
306 Month 5 37 37 37.0 =0.02 0 �0.00 =0.04
307 Month 6 37 37 37.0 �0.02 0 =0.00 Z0.04
308 Month T 37 37 37.0 :0.02 0 =0.00 =0_04
309 Month 8 37 38 37.5 s0.02 1 j0.02 =0.06
310 Month 9 38 38 38.0 =0.02 0 =0.00 =0.06
311 Monfh 10 38 38 38.0 =0.02 0 �0.00 =0.06
312 Month 11 38 38 38.0 =0.02 0 =0.00 =0.06
313 Montfi 12 38 38 38.0 50.02 0 =0.00 =0.06
314 Average Period 1 Markup Method Adjustaent t0.0483
315 Month 13
316 Month 14
317 Month 15
318 Month 16
319 Month 17
320 Month 18
321 Month 19
322 Month 20
323 Month 21
324 Mordh 22
325 Month 23
326 Month 24
327 Average Period 2 Caps Method Adjustaent
FCC Fotm 1240
Page 1 Microsoft Excel 4.0 Veision July 1996
Federal Communicatior►c Commicsion Approved By OMB 3060-0685
Wa�hington,DC 20554
Worksheet 3 - Markup Method
Projected Period, Basic Tier
For ins[mctions,see Appendix A of Insuuctions For FCC Form 1240
Tru�lJp Period Pmjected Period
Question 1.Indicate the period for which this worksheet is being used.(Put an"X"in the appropnate box.) �
Question 2.Indicate the[ier for which this worksheet is being used.(Put an"X"in the appropriate box.)
Basic Tier 2 Tier 3 Tier 4 Tier 5
}i
Quesiion 3.How long is ihe Lirst period,in months,Cor which rates ure being sct with thi�workshcet? 12
Question 4.How long is the second period,in mon[hs,for which rates are lx:ing xt wi[h this worksheet? 0
1 Z 3 4 5 6 7
Line Period Sa�of Previoos So�of Catreat Average Per C6mne1 Channols Total C�ulative
Regulated Channe� Regulated Channel Channels Adjuscaent Added Adjustiaent Adj�ataent
301 Previoia Month Z0.06
302 Month 1 38 38 38.0 SO_02 0 50.00 =0.06
303 Month 2 38 38 38.0 50.02 0 50.00 s0.06
304 Month 3 38 38 38.0 SO_02 0 =0_00 �0.06
305 Month 4 38 38 38.0 �0.02 0 50.00 50.06
306 Month 5 38 38 38_0 �0.02 0 =0.00 =0.06
307 Montli6 38 38 38.0 s0.02 0 50.00 s0.06
308 Month 7 38 38 38_0 50.02 0 s0_00 �0.06
309 Month 8 38 59 48.5 50.01 4 50.04 =0.10
310 Month 9 59 59 59.0 =0.01 0 =0_00 50.10
311 Month 10 59 59 59.0 50.01 0 50.00 Z0.10
312 Month 11 59 59 59.0 ;0.01 0 =0.00 50.10
313 Month 12 59 59 59.0 50.01 0 =0.00 50.10
314 Average Period 1 Markup Method Adjustsent 50.0767
FCC Fmm 1240
Page 1 Microsoft Excel 4.0 Vecsion July 1996
Federal Communicatio�s Commission Approved By OMB 3060-0685
Wa�hington,DC 20554
Worksheet 4 - Residuat
True-Up Period
For instructions,see Appendix A of InsWCtions For FCC F'ortn 1240
Question l.Indicate the period for which iltis worksheet is being used.(I'ut an"X"in the appropriate box.) Tru�Up Period Projec[ed Period
X
a b c d e
Line Line Descri tion Basic Tier 2 Tier 3 Tier 4 Tiv 5
Period One
401 Average Pe�mitfed Charge 510.8850 $13.1450
402 Average Extemal Cosls 50.3546 $4.8677
Average Total Per Chacmel Adj�ents after 5/14194 for
403 Channels Added Using Caps Method $�'�
404 Average Tiv Residual[401-402-403] S10.5304 $8.2973
405 Average Charmels per Regulated Tier 20.5000 17.0000
406 Average Caps Method Chazmels per Tier 0.0000 0.0000
407 Average Remaining Chazmels @OS-406] 20.SOIN1 17.0000
408 Average Period 1 Per Charmel Residual[404/407] 50.5137 50.4869
Period Two
409 Average Permitted Charge
410 Average External Costs
411 Average Total Per Charmel Adjustmentc aher 5114J94 for
Channels Added Using Caps Metfiod
412 Average Tier Residual[409-410-411)
413 Average Channels per Regulated Tier
414 Average Caps Method Charmels per Tier
415 Average Remaining Channels[413-414j
416 Average Period 2 Per Channel Residual[412/415]
FCC Fo�m 1240
Page 1 Microsoh Excel 4.0 Version July 1996
Federal Communicationc Commission Approved By OMB 3060-0685
Washington,DC 20554
Worksheet 5 - Channel Movemeot and Deletion
True-Up Period, Basic Tier
For inswclions,see Appendix A of lns[ructions For HCC Form 1240
Question 1.Indicate the period for which this worksheet is being used.(Put an"X"in the appropriate box.)
frue-Up Period Projected Period
X
Question 2.Indicate the[ier!or which[his workshee[is being used.(f'u[an"X"in the appropnate box.)
Basic Tier 2 Tiv 3 Tier 4 Tier 5
X
Ques[ion 3.How long is the first period,in months,for which rates are being set with this workshect? 12
Question 4.How long is the second period,in months,for which rates are being set with this worksheet? 0
1 2 3 4
Net PerChannel Cost
Residual of Channels Deleted Residual af Channels Moved Cu�ulative Net PerChamel
Lme Period Fro�Tier (added)to Tier Adjust�ent[C]u�n 2-Colu�n Cost Adjust�ent
501 Ptcvio�a Period 50.1000
502 Mon�1 f 0.0000 50.9411 50.9411 =13411
503 Month2 s0.0000 50.0000 �0.0000 �13411
504 Month 3 50.0000 s0.0000 �0.0000 =1.3411
505 Month4 50.0000 50.0000 =0.0000 51.3411
506 Month 5 50.0000 50.0000 50.0000 =13411
507 Month 6 s0.0000 50.0000 50.0000 =1.3411
508 Mon�7 50.0000 $0.0000 =0.0000 =1.3411
509 Month8 50.0000 50.0000 �0.0000 =1.3111
510 Month9 50.0000 50.0000 50.0000 =1.3411
511 Month 10 S0.0000 50.0000 �0.0000 s1.3411
512 Monfh 11 50.0000 50.0000 =0.0000 =1.3411
513 Month 12 50.0000 S0.0000 j0.0000 :1.3411
514 Average Period 1 Channel Move�ent and Deletion Adjustaent s1.3411
515 Month 13
516 Month 14
517 Mor�th 15
518 MoMh 16
519 Month 17
520 Month 18
521 Month 19
522 Montfi 20
523 Month 21
524 Montfi 22
525 Month 23
526 Month 24
527 Average Period 2 Cham�el Move�ent and Deletion Adjustvent
FCC Form 1240
Page 1 Microsoft Eacel 4.0 Version July 1996
Federel Communicatio�Comm'asion Approved By OMB 3060-0685
Wachington,DC 20554
Worksheet 5 - Channel Movement and Deletioo
Projected Period, Basic Tier
For inswctions,see Appendix A of Instnictions For FCC Form 1240
Question l.Indicate[he period for which[his worksheet is being used.(Put an"X"in[he appropriate box.)
Tcuc;-Up Pcriod Projected Period
X
Ques[ion 2.Indicate the tier for which this worksheet is being used.(Put an"X"in the appropriate box.)
Bacic Tier 2 Tier 3 Tier 4 Tier 5
X
Question 3.How long is[he first period,in months,for which rates are being x[with this workshee[? 12
Q�estion 4.How long is the second period,in months,for which rates are being xt with this workshceC? U
1 2 3 1
Net PerC6anael Coat
Residaal of Channelz Deleted Reaidual of Channels Moved Cu�olative Net PerChannel
Line Period Fro�Tier (added)to Tier Adjushent[Ciu�a 2-Colu�n Cost Adjm�aent
501 Previoia Period ;13411
502 Month 1 50.0000 $0.0000 �0.0000 =1.3�11
503 Month2 S0.0000 S0.0000 =0.0000 513411
504 Montfi3 50.0000 $0.0000 ;0_0000 t1.3�11
505 Morth 4 50.0000 50.0000 s0.0000 =1.3411
506 MordhS 50.0000 50.0000 s0.0000 �1.3�11
507 Montli6 50.0000 50.0000 50.0000 =1.3�11
508 Montli 7 50.0000 50.0000 50.0000 ;1.3411
509 MoidhB 50.0000 $0.0000 s0.0000 =1.3411
510 Mondi9 50.0000 50.0000 �0.0000 t1.3411
511 Month 10 50.0000 50.0000 50.0000 51.3411
512 Month 11 50.0000 50.0000 �0.0000 51.3411
513 MoNh 12 50.0000 50.0000 50.0000 =13411
514 Average Period 1 Channel Movesent and Deletion Adjusdent :13�11
FCC Foim 1240
Page 1 Microsoft Exce14.0 Version ]uly 1996
Federal Commuuicalious Commission Approved B}�O\tH 30blYUbtlS
Washington,DC 20554
Worksheet 7- External Costs
True-Up Period
For inst+uclions,eee Appendix A of Instructions For FCC Form 1240
True-Up Period Rojected Period
Question 1.For which time period are you filling oui Utia worksheet? �Rri an"X"in the appropria[e box� X
Question 2.How long is the First period,in months,for which rates sre being eet with this worksheet? 12
Queetion 3.How long ix[he xecond period,in mon[hx,for which ratex are being xe�with Ihis worksheel7 0
a c t
Line Line Dexcrf tion Basic Tier 2 Tier 3 Tier 4 Tier 5
PeriuJ 1
External Costs EGgible for Marku
��l Cost of Programming For Ohannels Added Prior to 5/15/94 or $z5,398.09 $552,176.98
After 5/15/94 Using Markup Method For Period
702 Retransmission Consent Fees For Period $0.00 $0.00
703 CopyrightFeesForPeriod $]2,006.04 $15,R06.84
704 Estemal Costs Eligible For 7.5%Ivfarkup $37,404.13 $567,983.82
705 bfarlced Up Extemal Costs $40,20).43J8 Y61Q582.6065
Ezternal Costs Not Eli ible for Marku
706 Cable Specific Taxes For Period $0.00 YOAO
707 Franchise Related CosLs Far Period $0.00 $OAO
7U8 Commission Regulatory Fees For Perial $5,819.25 �.00
709 To�al Ea[ernal Cosis For Period $�1(i,028.6898 �610,582.6065
710 Monthly,Per-Sub�crib�r EMemal Cosis For Perial 1 S0.3546 $4.8677
Period 2
Externul Costs Eli ible fur M:trku
71� Cosl of Programming For Channels Added Prior to 5/I S/94 or
Afier S/15/94 Uaing Markup Me�hod For Period
712 Retrenamiseioo Consent Fees For Period
713 Copyright Fees Fcx Period
714 F.xternel Cos�e F.ligible For 7.5°/Merkup
715 Murkuf Up E�Anrtwl Cos1u
Eaternal Costs Not Eli 'ble for Marku
716 Cable Specific Taxes For Period
717 Franchise Related Coats For Period
718 Commission Regulatory Fees For Period
719 Total Edemal Coste For Period
720 Monthly,Per-Subecriber EMemal Coxta For Period 2
FCC Form I240
Page 1 Microsoft F,xcel 4.0 Version July 1996
Federal Communications Commission Approved By OMB 3060-1k�F35
Wu6ington,DC 20554
Worksheet 7- External Costs
Projected Period
For instnictions,see Appeodix A of Inawctions For FCC Fom�1240
Tnie-Lrp Period Projected Period
Question I.For which time period are you Glling ou[ihis wo`ksheet? (Put an"X"in ihe appropnale box.] X
Question 2.How long is the fiist period,in months,for which rates are being set with tMis worksheet? 12
Qucation 3.How long is the second period,in monlhs,for which rates are being sel with fhis worksheet? 0
u c e
line Lice Dencri tion Baxie 7'ier 2 Tier 3 Tier 1 Tier 5
Period 1
External Costs Eligible for Marku
��� Cost of Programming For Channels Added Prior to 5/15/94 or gh5,711.77 SSR9,13N.02
Afler 5/15/94 Using Marlcup Method H'or Period
702 Retransmission Consent Fee.s For Period $0.00 $0.00
703 CoPynght Fees For Period Sl 1,360.85 $12,919.17
704 E.Ktcrnal Coets Eligible For 7.5%Merkup $77,072.62 $602,057.19
705 Marked Up Gxtemal('osts $82,8Si.0665 56/7,211.3793
Extemal Costs Not E' "ble for Murku
706 Cable SpeciFc Ta:ces For Period $(1.00 S0.W
707 I�ranchise Related('.os1s For Period $0.00 $(1.00
708 Commission Regulalnry Fees For Period $5,526.90 $0.00
709 Taal Enlemnl Costs F'or Period $88'i79.9665 $647,21L4793
710 Monthly,Per-Subse;riber F,xtemal Costs For Period 1 $U.7196 56.3125
FCC Form 1240
Page 2 Microsofl F.xcel 4.0 Version July 1996
Federal Comm�micffiim�s Comm'ssion Approved By OMB 3060-0685
Washmgton,DC 20554
Worksheet 8 - True-LJp Rate Charged
For instructions,see Appendix A of Instructions For FCC Form I240
Question 1.How long is[he Tiue-Up Period l,in months? 12
Question 2.How long is the Tnie-Up Period 2,in months? 0
a c d e
Lme Line Dcscription Basic Tier 2 Tier 3 Tier 4 Tier 5
801 Month 1 59.8900 513.6700
802 Month2 S9•$900 513.6700
803 Month 3 S9.8900 513.6700
804 Month 4 $9.8900 513.6700
805 MonthS 59.8900 513.6�00
806 Month6 59.8900 513.6700
807 Mo�Mh 7 511.8800 S12.6200
808 Month 8 $11.8800 $12.6200
809 Month9 511.8800 512.6200
810 Month 10 S11.8800 512.6200
sii mo�un ii Sii.ssoo Siz.6zao
812 Monih 12 511.8800 S12.6200
813 Period 1 Avernge Rate S10.8S50 $13.1450
814 Month 13
815 Month 14
816 Month 15
817 Month 16
818 Month 17
819 Month 18
820 Month 19
821 Month 20
822 Month 21
823 Month 22
824 Month 23
825 Month 24
826 Period 2 Average Rate
FCC Foim 1240
Page 1 Microsoft Exce14.O Version July 1996