ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Streaming Royalty Estimate Calculator
2
Use this workbook to model simple streaming royalty scenarios. It is an estimate tool only. Actual royalties can change based on platform reporting, territory mix, service tier, royalty category, currency conversion, tax withholding, contract language, payment thresholds, and statement timing.
3
4
5
StepWhat to do
6
1Start with either the Master Estimate or Composition Estimate sheet.
7
2Enter the editable inputs in the pale green cells.
8
3Review the formula-driven output cells to see the estimated allocation and payable amount.
9
4Use Scenario Comparison to test paid vs. ad-supported, territory mix, ownership shares, or different fee structures.
10
5Treat the result as a planning estimate, not a guaranteed DSP payout.
11
6Compare any estimate against actual royalty statements, agreements, and account setup before making decisions.
12
7Use Assumptions to document the source of inputs used for each estimate.
13
14
15
16
17
18
19
20
21
22
23
24
25
26
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