Silent September Impact

Still loading...

	A	B	C	D	E	F	G	H	I
1	This Spreadsheet is designed to help you see how small numbers of people can have a huge impact on major label revenue.
2	All numbers are from Spotify Premium subscribers in USA, per Section 115 disclosures.						Source:	https://drive.google.com/file/d/0BwsIBPX1QCEWTTdqaDNPQnp3UDQ/view
3	To play with the numbers yourself, just click on File>Make A Copy
4
5	Step 1: The world as it is right now
6	# of subscribers	Avg # of streams per subscriber	# of streams	Royalties payable	Per-stream rate	Major label market share	Major label royalties	Indie share	Indie Royalties
7	4,700,000	723	3,400,027,000	26,000,000	0.0076470	64%	$16,640,000	36%	$9,360,000
8
9	Step 2: The protestors (the orange squares are what you can play with)
10	# of subscribers	Avg # of streams per subscriber	# of streams
11	17,050	10,500	179,025,000
12
13	Step 3: Add the protest streams to the overall streams and recalculate the new streaming rate
14			# of streams	Royalties payable	Per-stream rate
15			3,579,052,000	26,000,000	0.0072645
16
17	Step 4: What do protestors earn for the indies (dark green on far right)?
18	# of subscribers	Avg # of streams per subscriber	# of streams		Per-stream rate			Indie Share	Indie Royalties
19	17,050	10,500	179,025,000		0.0072645			100%	$1,300,526
20
21	Step 5: Substract Indie Royalties from the royalty pool
22	# of subscribers	Avg # of streams per subscriber	# of streams	Royalties payable	Per-stream rate	Major label market share	Major label royalties	Indie share	Indie Royalties
23	4,700,000	723	3,400,027,000	24,699,474	0.0072645	64%	$15,807,663	36%	$10,192,337
24
25	Step 6: Calculate Major Label Decrease
26				MAJOR LABEL DECREASE:			5.00%
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100