producer_points_calculator.xlsx

	A	B	C	D	F	G	H
1	Producer Points Calculator
2	Use the editable inputs to compare producer royalty outcomes across artist royalty, net receipts, and gross master revenue structures.
3
4	Inputs
5	Field	Value	Notes		Scenario Summary	Value
6	Calculation Structure	Artist royalty-based	Choose one: Artist royalty-based, Net receipts-based, Gross master revenue share		Gross master receipts	$12,000.00
7	Producer Points / Rate	3.00%	Enter as percentage		Net receipts after deductions	$9,500.00
8	Gross Master Receipts	$12,000.00	Total master income before listed deductions		Artist royalty amount	$2,400.00
9	Artist Royalty Rate	20.00%	Used for artist royalty-based points		Producer royalty earned	$72.00
10	Distributor / Collection Fees	$1,800.00	Fees taken before net receipts		Recoupment applied	$72.00
11	Approved Deductions	$700.00	Other costs allowed under the agreement		Amount payable now	$0.00
12	Opening Unrecouped Balance	$1,000.00	Advance or prior recoupable balance
13
14	Calculation Step	Formula / Result	What It Means	Review Note	Structure	Royalty Base	Producer Royalty Earned
15	Gross master receipts	$12,000.00	Total master income entered for the period.	Confirm this matches the payer's reporting.	Artist royalty-based	$2,400.00	$72.00
16	Less distributor / collection fees	$1,800.00	Fees removed before net receipts, if allowed.	Check whether the agreement allows this deduction.	Net receipts-based	$9,500.00	$285.00
17	Less approved deductions	$700.00	Other permitted deductions entered by the user.	Avoid broad or unsupported deduction language.	Gross master revenue share	$12,000.00	$360.00
18	Net receipts	$9,500.00	Receipts left after listed deductions.	Used for net receipts-based structures.
19	Artist royalty amount	$2,400.00	Artist-side royalty pool before producer share, based on entered artist royalty rate.	Used for artist royalty-based points.
20	Royalty base used	$2,400.00	The base selected by the calculation structure.	Compare this against the contract definition.	Review Notes
21	Producer royalty earned	$72.00	Producer share before recoupment.	This may not be payable yet.	Question	Your Notes
22	Recoupment applied	$72.00	Royalty amount used to reduce the opening unrecouped balance.	Shows earned royalties withheld for recoupment.	What royalty base does the contract use?
23	Ending unrecouped balance	$928.00	Remaining balance after recoupment is applied.	Future royalties may continue reducing this balance.	Are producer points all-in or paid on top?
24	Amount payable now	$0.00	Royalty payable after current recoupment.	May be zero even when royalties were earned.	Which deductions are allowed before the royalty is calculated?
25					Is the advance recoupable?
26					Who issues statements and payments?
27					How often are statements due?
28					Are audit rights included?
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