Sample Book P-L.xlsx

	A	B	D	E	F	G	H	J	K
1					Space Hippos P&L
2
3					Income			Expenses
4
5				Est. Units to be Sold	Royalty Percentage	Per-Unit Income	Revenue	Developmental Costs
6	List Prices		Paperback	1,200	14.25%	2.13	2,556.00	Editorial	625.00
7	Paperback	14.95	eBook					Copyediting	250.00
8	eBook	2.99	Amazon	3,200	70%	2.09	6,688.00	Proofreading	100.00
9	Audiobook	14.95	B&N	1,400	65%	1.94	2,716.00	Photographs/Illustrations	0.00
10			Kobo	750	70%	2.09	1,567.50	Permissions Fees	0.00
11			Direct Market	210	100%	2.99	627.90	Total Developmental Costs	975.00
12			Audiobook
13			Audible	150	25%	3.75	562.50	Design Costs
14			Direct Market	95	100%	14.95	1,420.25	Typesetting and Layout	500.00
15							16,138.15	Interior Design (e.g. custom graphics for chapter headings)	30.00
16								eBook Formatting	125.00
17								Cover Design (print and digital)	410.00
18								Total Design Costs	1,065.00
19
20								Production Costs
21								ISBN	125.00
22					Bottom Line			Copyright Registration	35.00
23					Income - Costs = Revenue			Print Setup	49.00
24					10,944.15			Print Proof	40.00
25								Per-Book Cost*	12.82
26								Total Production Costs (excluding per-book cost)	249.00
27
28								Marketing Costs
29								Advance Reading Copies	200.00
30								Bookmarks	75.00
31								BookBub Promotion	630.00
32								Goodreads Ads	100.00
33								Facebook Ads	150.00
34								Google Adwords	250.00
35								Marketing Assistant	1,500.00
36								Total Marketing Costs	2,905.00
37
38								TOTAL BOOK COSTS	5,194.00
39
40								*Note: Most indie authors won't actually be paying the per-book cost out of pocket; it's deducted from the money the print-on-demand company sends to you. But it's good to list this in your budget so you can compare companies' costs if you want to shop around!
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