| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
1 | Cost and Benefit of Celtic "IPTV" Broadcasting of their live matches | |||||||
2 | ||||||||
3 | ||||||||
4 | ||||||||
5 | Team | Games | Price | Audience | total | Scottish Cup | League Cup | |
6 | Hearts | 4 | £10 | 30,000 | £1,200,000 | |||
7 | Dundee Utd | 4 | £10 | 30,000 | £1,200,000 | £300,000 | £300,000 | |
8 | Kille | 4 | £10 | 30,000 | £1,200,000 | |||
9 | ICT | 4 | £10 | 30,000 | £1,200,000 | |||
10 | M Well | 4 | £10 | 30,000 | £1,200,000 | £300,000 | £300,000 | |
11 | Hibs | 3 | £5 | 30,000 | £450,000 | |||
12 | Aberdeen | 3 | £5 | 30,000 | £450,000 | |||
13 | St Mrn | 3 | £5 | 30,000 | £450,000 | |||
14 | Ross County | 3 | £5 | 30,000 | £450,000 | |||
15 | St Johnstone | 3 | £5 | 30,000 | £450,000 | £150,000 | ||
16 | Promo Club | 3 | £5 | 30,000 | £450,000 | £150,000 | ||
17 | 38 | Totals | 920,000 | £8,700,000 | £750,000 | £750,000 | ||
18 | League & Cup Reciepts | £10,200,000 | ||||||
19 | Monthly Sub Equivalent to Earn Same as PPV | |||||||
20 | Months | Subscribers | MnThly Sub | |||||
21 | 12 | 100,000 | £13.00 | £15,600,000 | ||||
22 | ||||||||
23 | Deduct Production and delivery Costs | £2,000,000 | ||||||
24 | Profit for Celtic from their 36 games | £13,600,000 | ||||||
25 | ||||||||
26 | Total Profit | £13,600,000 | ||||||
27 | ||||||||
28 | Illustrative Celtic share | 15% | £2,040,000 | |||||
29 | £0 | |||||||
30 | Others share from Celtic | 85% | £11,560,000 | |||||
31 | ||||||||
32 | Total others | £11,560,000 | ||||||
33 | Each | £1,156,000 | ||||||
34 | ||||||||
35 | Current share from ESPN | £65M | ||||||
36 | per year | £13M | ||||||
37 | each get | £1,083,333 | ||||||
38 | ||||||||
39 | ||||||||
40 | ||||||||
41 | ||||||||
42 | ||||||||
43 | ||||||||
44 | ||||||||
45 | ||||||||
46 | ||||||||
47 | ||||||||
48 | ||||||||
49 | ||||||||
50 | ||||||||
51 | ||||||||
52 | ||||||||
53 | ||||||||
54 | ||||||||
55 | ||||||||
56 | ||||||||
57 | ||||||||