ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
What this spreadsheet will do is calculate the break-even point of a KickStarter based on 100% of your pledges being for your item with the highest marginal cost. This assures that AT THE MOST EXPENSIVEOR COSTLY tier, you would not lose money. This also does not account for multiple tiers or multiple distinct products. And cannot serve as business advice. It merely calculates the data based on your inputs and should only be one piece of the information that influences a business decision like Kickstarter goal amounts. It also DOES NOT recalculate the needed pledge amount or minimum number of backers based on minimum orders. I'm sure the match can be done, but it's over my head.
2
Please edit the white background cells in the B column with the information specific to you and your Kickstarter. Please also copy this sheet to your Google account prior to editing as it will not allow you to edit the sheet until you do.
3
4
Cents Per Word
10Kickstarter Break Even Goal Amount
5
Number of Words7500$7,200.85
6
Cover Art Cost$250.00
7
Additional Art Cost$500.00
8
Editing Cost$100.00Kickstarter Break Even Number of Backers
9
Layout Cost$100.00246
10
Other Writing Costs (Sensitivy readers, etc.)$50.00
11
Miscellaneous Fixed Costs$0.00
12
Fixed Costs$1,750.00Additional Cost to Satisfy Minimum Order
13
$2,280.85
14
Printing Cost Per Item$2.75
15
Shipping Materials Per Item$1.15
16
Shipping Per Item$2.75
17
Miscellaneous Marginal Costs (royalty, license fee, etc.)$0.00
18
Marginal Costs$6.65
19
20
Kickstarter Fee %5.00%
21
Payment Processer Fee %5.00%
22
Platform Overhead %
10.00%
23
24
Printed Product Pledge $$20.00
25
Desired Profit Margin %20.00%
26
Desired "Safety" Margin %10.00%
27
Minimum Product Order (number of pieces)1000
28
29
30
Ver 1.1
Clarified relationship between Break even goal amount, # of backers, and additional for minimum order. Basically, this formula is too dumb to make the math work entirely correctly.
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