ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Original (input version)
2
VERSIONING VALUE CALCULATOR
3
4
Make a copy of the template to change the blue cells and a custom cost is calculated on the fly
5
6
Summary
7
8
Volume Revenues Costs
9
Streamers/creators55Ad revenues€ 2.709.185Paid to streamers€ 3.597.796
10
Streams per month3.300Subscription revenues€ 5.775.000Opex€497.165
11
MAU3.300.000Additional revenues€1.278.750License fee€500.689
12
User hours generated25.034.460Churn reduction & upsell€462.000Content reuse costs€ 33.000
13
Other€0Other€0
14
per month€ 10.224.935-€ 4.628.650
15
16
Revenue per user€ 3,10per month€ 0,41per user hour
17
Rev share per streamer€ 65.414
18
19
Total revenue€ 10.224.935
20
Operational costs-€ 4.628.650(NB: CapEx not included)
21
Result€ 5.596.285
22
23
Content
24
25
Assumptions
26
Value calculator for broadcasting platform
27
Change the blue cells according to your situation. Any category not used can be turned off.
28
29
Volumes
30
Number of stream(er)s55
31
Streaming60sessions per month2
streams created per day per streamer
32
Lasting on average1hours each2hours per day
33
With on average20.000unique viewers per session
34
Who watch on average38%of the entire duration
35
And each user watches20streams per month
36
Creating a total reach of3.300.000unique users per month
37
Total content created3.300sessions
38
Which is3.300hours created
39
Resulting in66.000.000stream starts
40
And consumption of25.034.460user hours
41
42
REVENUES
43
44
Advertising (on non-subscribers)
Paid to streamer
45
Ads revenue of€12CPM (net) Per display:€0,012
46
Pre roll2ads per session
47
Plus6interstitial ads per hour
48
Pre roll value of€ 1.267.200per month25%€ 316.800
49
Interstitial ads value€1.441.985per month25%€360.496
50
Total revenue ads€2.709.185Paid to streamers: € 677.296
51
52
SubscriptionsPaid to streamer
53
On average,5% of users subcribe
54
To an average of1,50streamer channels
55
With a monthly price of€5,00per subscription40%€2,00
56
Resulting in a total of165.000active channel subscribers
57
Generating€825.000subscription revenue40%€330.000
58
59
On average, 15%
of users subscribe to the platform
60
With a monthly price of€ 10,0040%€ 4,00
61
Resulting in a total of495.000active platform subscribers
62
Generating€4.950.000subscription revenue40%€1.980.000
63
64
Total revenue subscriptions€5.775.000Paid to streamers: €2.310.000
65
66
Additional revenues: purchases, tipping, performance marketing
Paid to streamer
67
Sessions with products:35%of 3300 sessions
68
Viewers buying product:1%
of 20000 unique viewers per session
69
Average product price €15
70
Total purchases €3.465.000
71
72
Revenue model:
73
Fixed Fee of €0gives a revenue of € 0
74
Conversion fee of 25%gives a revenue of € 866.250
75
Turnover of € 0gives a revenue of € 0
76
Revenue from purchases:€ 866.25050%€ 433.125
77
78
% of viewers tipping: 1%
of 3300000 unique viewers per month
79
Average tip€5
80
Revenue from tipping:€165.00070%€115.500
81
82
Sessions with PM25%of 3300 sessions
83
Lead gen per session 0,1%
of 20000 unique viewers per session
84
CPA€15
85
Revenue from PM:€247.50025%€61.875
86
87
Additional revenue €1.278.750Paid to streamers: € 610.500
88
89
Churn reduction & upsell
90
Of all users,20%Pays for SVOD service€10per month and10%churn
91
Using this service gives20%churn reduction
92
Churn reduction€132.000value per month
93
And 80%is not (yet) SVOD subscriber0,50%
upsells to broadcast service
94
New subcriber€25marketing value13.200new broadcast subs
95
New subcriber value€330.000upsell value
96
97
Churn reduction & upsell€462.000
98
99
Other revenues €0
100