ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
[Project Title]
2
Based on Jeff Tidball's Game Project Budget Template v1.1. Thanks to Paul Ference, Renee Knipe, and Ruth Tillman for reviewing drafts of this resource. Any green cell's contents can be changed, but unformatted cells auto-calculate; avoid changing them. Italics indicates notes; any can be changed. The sample entries in the green cells bear no particular relationship to what's advised or reasonable. They're just numbers taking up space until you spawn your own copy and start building your project. Please spread the word about this resource! The easiest URL to distribute is jefftidball.com/gamespreadsheet. Have a question or comment? Drop an email to jeff at jefftidball dot com.
3
4
Expenses (Not Including Royalties)
5
Wordcount Expenses
6
Word Count0
7
Words Per Page800
Assumes a page without any illustrations
8
Art Density (%)12.50%
Percentage of average page covered by illustrations (e.g., a quarter-page illo per spread is 12.5%)
9
Total Art Page Count0.00
10
Non-content Pages7
Title pages, credits, ToC, index pages, etc.
11
Total Page Count7
12
13
Writing Pay Per Word$0.05
14
Other Pay Per Word$0.02E.g., Editing
15
Other Pay Per Word$0.01E.g., Proofreading
16
Written Material Exp.$0.00
17
18
Illustration ExpensesCountCost EachExtentionPage % EachExtentionNotes
19
Cover1$1,250.00$1,250.000.00%0
20
Size / Type 140$150.00$6,000.0025.00%10
21
Size / Type 210$200.00$2,000.0050.00%5
22
Size / Type 30$250.00$0.0066.00%0
23
Size / Type 40$300.00$0.00100.00%0
24
$9,250.0015
This sum should match Total Art Page Count
25
26
Hourly and Flat Rate Expenses
27
Hours Low Est. Hours High Est.Hourly RateExtention LowExtention HighNotesFlat RateNotes
28
Administration310$0.00$0.00$0.00$0.00
29
Concept824$15.00$120.00$360.00$0.00
30
Design00$15.00$0.00$0.00$0.00
31
Writing00$15.00$0.00$0.00$0.00
32
Development10160$15.00$150.00$2,400.00$0.00
33
Art Direction40120$15.00$600.00$1,800.00$0.00
34
Producing2080$15.00$300.00$1,200.00$0.00
35
Editing00$15.00$0.00$0.00$0.00
36
Art00$15.00$0.00$0.00$0.00
37
Layout00$15.00$0.00$0.00$1,250.00
38
Proofreading00$15.00$0.00$0.00$0.00
39
Playtesting00$15.00$0.00$0.00$0.00
40
$1,170.00$5,760.00$1,250.00
41
42
Production Expenses
43
1,0002,0005,000Notes
44
Prepress$250.00$250.00$250.00
45
Printing$5,000.00$7,000.00$9,000.00
46
Shipping (Inbound)$500.00$750.00$1,000.00
47
$5,750.00$8,000.00$10,250.00
48
49
Other Expenses
50
ExpenseAmountNotes
51
Prototype Supplies$250.00
52
Expense 2$0.00
53
Expense 3$0.00
54
Expense 4$0.00
55
$250.00
56
57
Contingency5%
As a % of Total Expenses
58
59
Total Expenses Low$18,553.50$20,916.00$23,278.50
60
Total Expenses High$23,373.00$25,735.50$28,098.00
61
62
63
Crowdfunding Revenue (and Royalties)
64
Crowdfunding
65
TierBacker Est. LowBacker Est. HighBacker PaysShipping CostAdd'l Exp. PerRevenue LowRevenue HighStock Use PerStock Use LowStock Use High
66
Basic Domestic100200$10.00$0.00$0.00$1,000.00$2,000.00000
67
Basic Int'l3060$15.00$0.00$0.00$450.00$900.00000
68
Standard Domestic150400$25.00$5.00$0.00$3,000.00$8,000.001150400
69
Standard Int'l50100$35.00$20.00$0.00$750.00$1,500.00150100
70
Premium Domestic20100$50.00$5.00$15.00$600.00$3,000.00120100
71
Premium Int'l1035$60.00$20.00$15.00$250.00$875.0011035
72
360895$6,050.00$16,275.00230635
73
74
Royalties (of Crowdfund Campaign)
Royalty LowRoyalty High
75
Royalty % Revenue5.00%$302.50$813.75
E.g., Kickstarter Finance Fee
76
Royalty % Revenue3.00%$181.50$488.25
E.g., Stripe Card Processing Fee
77
Royalty % Revenue5.00%$302.50$813.75
E.g., Designer Royalty
78
Total Royalty13.00%$786.50$2,115.75
79
80
Crowdfunding Revenue Net of Royalties
81
Low Estimate$5,263.50
82
High Estimate$14,159.25
83
84
Post-Crowdfunding Revenue (and Royalties)
85
Retail Pricing by Sales Venue
86
MSRPDiscountRevenueStock Use Per% of Sales
87
Sales Venue 1$40.0055.00%$18.0015.00%
E.g., Amazon Advantage
88
Sales Venue 2$40.0059.00%$16.40115.00%
E.g., Traditional distribution
89
Sales Venue 3$12.0030.00%$8.40070.00%E.g., DriveThru
90
Sales Venue 4$40.000.00%$40.00110.00%E.g., Direct sales
91
Sales Venue 5$0.00100.00%$0.0000.00%
92
100.00%
This sum must be 100%
93
94
Unit Sales by Sales Venue
95
1,0002,0003,0004,0005,0006,0007,000
96
Sales Venue 150100150200250300350
97
Sales Venue 21503004506007509001,050
98
Sales Venue 37001,4002,1002,8003,5004,2004,900
99
Sales Venue 4100200300400500600700
100
Sales Venue 50000000