HANDS Payment worksheet scenarios

	A	B	C	D	E	G
1	Direct Sales of Audiobooks
2		Scenario 1	Scenario 2	Scenario 3	Scenario 4
3	Inputs	Most risk for author	>>>	>>>	Most risk for narrator
4	Book words	90000	90000	90000	90000	the number of words in the book
5	Words/finished hour	9000	9000	9000	9000	the narrator's estimated words per finished hour
6	Pfh rate	225	250	275	300	the per finished hour rate the narrator charges
7	Num of distribution payments	2	6	10	10	how long to stretch out the payoff period
8	Narrator revenue payoff %	0	50	50	35	the revenue split until the narrator is paid off
9	Audiobook price	10.00	10.00	10.00	10.00	the anticipated selling price (to determine how quickly the narration is paid off)
10	Est sales/month	20	20	20	20	the anticipated sales per month (again, to determine how quick the payoff is)
11
12	Outputs
13	Total Est. audiobook cost	2,250.00	2,500.00	2,750.00	3,000.00	the total narrator billing - less for more risk to the author, more for more risk to the narrator
14	Distribution payment amt	1,125.00	416.67	275.00	300.00	how much each narrator distribution will be
15	Estimated Revenue/month	200.00	200.00	200.00	200.00
16	Author rev/month	200.00	100.00	100.00	130.00	how the revenue gets split between author and narrator during payoff period.
17	Narrator rev/month	0.00	100.00	100.00	70.00
18	Months between invoices	n/a	4.17	2.75	4.29	anticipated period between invoices using the estimated sales
19	Years to payoff	n/a	2.08	2.29	3.57	years to pay off the narrator
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