ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1
This is my messy Kickstarter budget. Good luck.*
2
Learn whatever is worth learning and use what is useful to you! Duplicate the document to play with it.
3
Numbers in red are variables, change them to see what happens.
4
5
base fundinghopeful fundingsuper fundingludicrous funding
6
Kickstarter Total$30,000.00$40,000.00$50,000.00$67,035.00
7
Kickstarter Fees0.082$2,460.00$3,280.00$4,100.00$5,496.87
8
Taxes0.14$3,855.60$5,140.80$6,426.00$8,615.34Taxes: if you can write off most of your project as a business expense, your tax rate might be lower. But run different tax rates as part of your scenario.
9
Reward Fullfilment Cost Ratio (see sheet 2)
0.12$3,600.00$4,800.00$6,000.00$8,044.20
10
Project Budget (see sheet 3)$30,918.00$35,000.00$42,000.00$53,000.00
11
Other funding / my investment-$9,089.25-$9,089.25-$9,089.25-$9,089.25
12
Takehome after fees/fulfillment$20,084.40$26,779.20$33,474.00$44,878.59
13
14
Balance-$1,744.35$868.45$563.25$967.84
15
If we get a positive balance here, ^^^ we build a cushion for mistakes and do-overs, then we can add stretch goals that cost things. Before this point, all stretch goals should be ***free to fulfill*** & add nothing to shipping.
16
17
Other funding sources, for row 11 above:
18
My Investment -- costs I'll personally absorb
$3,589.25
I'll also absorb whatever is not covered by the balance above in line 14, or any final cost overruns.
19
Earnings and donations outside Kickstarter
$5,500.00
20
21
22
23
24
*This spreadsheet is probably not perfect but at the moment I don't care, make your own better one and share with the world! :)
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