(this report was created 4/13/12 17:19)

Proposed Cable TV Venture

Input array: MV

MV[ 6] Rate/Year to Increase Sales Price or Revenues COSTMV[ 4]  
MV[ 7] Rate/Year to Increase Costs (& Revenues if 0=) COSTMV[ 5]  
MV[ 8] Months to Forego Cost Increase (effects MV[6],MV[7], COSTMV[ 6] 6
MV[ 9] Cash Advances End of Period (0) Midway (.5) Beginning (1) °  
MV[11] Interest Rate on Line of Credit Financing CSF[;2]  
MV[18] Periods/Year for Development (12=monthly projection,4 COSTMV[ 3] 4
MV[20] Periods Up Front to Insert Before Aggregating to Years 2
MV[21] Periods to Project (if not widest of PACE,COSTS,GANDA COSTMV[ 1] 16
MV[23] Level of Detail to Print (1000 = in 000's) PRINST[14] 1
MV[26] Residual(0=none)(ˆ.2=Cap.Cash Flow)(ˆ1=% of net cost)(>1=value)  
MV[28] PRICE Escalates Revenues,Not Sales(1);Calc.Sales Befo COSTMV[15] 1
MV[29] Date these inputs were saved (‘id[2]) (saveDate) 31881
MV[31] Starting Year (if MV[31]=1, then column headings are 1 2....) 1981
MV[39] Months for Fiscal Year Offset to Calendar Year(9=9/30 year end) 6
MV[41] File # for Chart of Accounts ° 981
MV[48] Template File # for COA, Methodology, & Report Structure 981
MV[57] Force basis codes -1 & -3 to include 5 or 6 selected COSTMV[ 8] 1

(this report was created 4/13/12 17:19)

Proposed Cable TV Venture

Input array: PACE

Periods are Quarterly Total Total JAS'81 OND'81 JFM'82 AMJ'82 JAS'82 OND'82
PACE[1;] 56250 28125     7031 7031 7031 7032

(this report was created 4/13/12 17:19)

Proposed Cable TV Venture

Input array: PRICE

Periods are Quarterly 1
PRICE[1;]  

(this report was created 4/13/12 17:19)

Proposed Cable TV Venture

Input array: COSTREF

  Total 1 2 3 4 5 6 7 8 9 10 11 12
1 329 1 12             304 12 1 -1
2 317 1               304 12 1 -1
3 317 1               304 12 1 -1
4 328 2 9 1           304 12 1 -1
5 326 2 8             304 12 1 -1
6 127 3 20             104   1 -1
7 322 3 15             304   1 -1
8 109 4   1           104   1 -1
9 108 4               104   1 -1
10 322 5               304 12 1  
11 326 5 3 1           304 12 1  
12 325 5 3             304 12 1  
13 316 6 1             304 4 1  
14 530 7 105     3       413 1 1  
15 647 8 223     3       411 1 1  
16 8 9                   -1  
17 9 10                   -1  
18 131 11 15             104   1  
19 132 11 15 1           104   1  
20 10 11                   -1  
21 324 14 4             304 1 1  
22 320 14               304 1 1  
23 320 14               304 1 1  
24 8832 101 8616   3         111   1  
25 23706 101 23489   3         112   1  
26 610 102       3       504   1  
27 208 103               104   1  
28 209 104               104   1  
29 276 105 66             104   1  
30 210 105               104   1  
31 210 105               104   1  
32 227 106 15             105   1  
33 213 107               105   1  
34 224 108 10             105   1  
35 340 212 11   3         113   1  
36 342 214 11   3         113   1  
37 410 216 77   3         113   1  
38 297 299               -1   -1  
39 299 300                   -1  
40 4286 4001 59             213 12 1  
41 108003 4003               104001   -1  
42 108007 4007               104001   -1  
43 108008 4008               104001   -1  
44 108011 4011               104001   -1  
45 4637 4403 8             213 12 1  
46 108511 4511               104001   -1  
47 108511 4511               104001   -1  
48 108511 4511               104001   -1  
49 108913 4511               104403   -1  
50 4799 4800                   -1  
51 4899 4900                   -1  

(this report was created 4/13/12 17:19)

Proposed Cable TV Venture

Input array: COSTS

Periods are Quarterly COA# Total Total JAS'81 OND'81
Head End Building 202 258000 129000 64500 64500
Earth Receivers 204 210000 105000 52500 52500
Tower 206 90000 45000 22500 22500
Head & Electronic Processors 208 400000 200000 100000 100000
Office Furniture,Equipment,Telephone 212 57668 28834 14417 14417
Tools & Test Equipment 214 100620 50310 25155 25155
2 Way Radios 216 9944 4972   4972
TOTAL   1126232 563116 279072 284044

(this report was created 4/13/12 17:19)

Proposed Cable TV Venture

Input array: GANDA

Periods are Quarterly COA# Total Total 1 2 3 4 5 6
Costs of Organizing 290 100000 50000 25000 25000        
Working Capital 995 400000 200000 100000 100000        
General Management 4000 300000 150000 25000 25000 25000 25000 25000 25000
Regular Earnings 4001 601803 300901 22876 43719 59669 62009 58213 54416
Vehicle Rent 4403 174162 87081 2600 9625 19511 18979 18448 17918
Professional Services 4550 30000 15000 2500 2500 2500 2500 2500 2500
TOTAL   1605964 802982 177976 205844 106679 108488 104161 99834

(this report was created 4/13/12 17:19)

Proposed Cable TV Venture

Input array: pRINST

1.Max.width row titles left side of page (to fit 1 page) 1
2.Min.width row titles left side of page (formats same)  
3.Minimal column width desired (to force = col widths)  

(this report was created 4/13/12 17:19)

Proposed Cable TV Venture

Input array: LAND

1.  

(this report was created 4/13/12 17:19)

Proposed Cable TV Venture

Input array: CONTRACTS

CONTRACTS[1;]  

(this report was created 4/13/12 17:19)

Proposed Cable TV Venture

Input array: COMPLETIONS

COMPLETIONS[1;]  

(this report was created 4/13/12 17:19)

Proposed Cable TV Venture

Input array: FACTORS

  Total 1 2 3 4
1 936 468 52 182 234

(this report was created 4/13/12 17:19)

Proposed Cable TV Venture

Input array: FACTORMAT

  Total 1 2 3 4 5 6 7 8 9 10 11
1                        
2                        
3                        
4                        
5 8     1 1 1 1 1 1 1 1 1
6 5     1 1 1 1 1 1 1 1 1