Book Read Through Calculator - MASTER

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1		KENPC	Price	Royalty %	Delivery Fee	Net Sales $	Net Reads $	Books 2-+ Month's Sales	Books 2+ Month's Reads	Reads Conv	BoB sales RT	Cum sales RT	BoB Reads RT	Cum Reads RT
2	Book 1	300	0.99	35.00%	0	$0.35	$1.26	100	63000	210.00
3	Book 2	300	3.99	70.00%	0.11	$2.68	$1.26	65	61000	203.33	65.00%	65.00%	96.83%	96.83%
4	Book 3	300	3.99	70.00%	0.12	$2.67	$1.26	50	60500	201.67	76.92%	50.00%	99.18%	96.03%
5	Book 4	300	3.99	70.00%	0.1	$2.69	$1.26	48	58700	195.67	96.00%	48.00%	97.02%	93.17%
6	Book 5	300	3.99	70.00%	0.09	$2.70	$1.26	45	58200	194.00	93.75%	45.00%	99.15%	92.38%
7	Book 6	300	3.99	70.00%	0.11	$2.68	$1.26	43	57000	190.00	95.56%	43.00%	97.94%	90.48%
8	Book 7	300	3.99	70.00%	0.1	$2.69	$1.26	39	34000	113.33	90.70%	39.00%	59.65%	53.97%
9	Book 8	300	3.99	70.00%	0.12	$2.67	$1.26	36	32000	106.67	92.31%	36.00%	94.12%	50.79%
10	Book 9	300	3.99	70.00%	0.1	$2.69	$1.26	33	30000	100.00	91.67%	33.00%	93.75%	47.62%
11	Book 10	300	3.99	70.00%	0.13	$2.66	$1.26	30	28000	93.33	90.91%	30.00%	93.33%	44.44%
12	Book 11	300	4.99	70.00%	0.13	$3.36	$1.26	25	26000	86.67	83.33%	25.00%	92.86%	41.27%
13	Book 12	300	4.99	70.00%	0.13	$3.36	$1.26	25	24000	80.00	100.00%	25.00%	92.31%	38.10%
14
15	Page Rate	0.0042
16	Reads to Sales Ratio	2.10
17
18	Fill in the green cells with your numbers for a given month.
19	If you have book 1 as permafree, set its royalty rate to 0. If you do not have 10 books in your series, simply enter the sales and reads as 0 after your last book.
20
21		Sales Value	Reads Value	Adjusted Reads Value
22	Book 1	$0.35	$1.26
23	Book 2	$1.74	$1.22
24	Book 3	$1.34	$1.21
25	Book 4	$1.29	$1.17
26	Book 5	$1.22	$1.16
27	Book 6	$1.15	$1.14
28	Book 7	$1.05	$0.68
29	Book 8	$0.96	$0.64
30	Book 9	$0.89	$0.60
31	Book 10	$0.80	$0.56
32	Book 11	$0.84	$0.52
33	Book 12	$0.84	$0.48
34		$12.47	$10.65	$22.36	(This value shows how much reads revenue there is when book 1 makes a sale)
35
36	AMS	Cost of Sale	Sales Profit (no KU)		Sales + Reads Profit
37	500% ACoS	$ 4.95	$ 7.52		$ 18.17
38	400% ACoS	$ 3.96	$ 8.51		$ 19.16
39	300% ACoS	$ 2.97	$ 9.50		$ 20.15
40	200% ACoS	$ 1.98	$ 10.49		$ 21.14
41	100% ACoS	$ 0.99	$ 11.48		$ 22.13
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