Star Citizen Development Costs

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Star Citizen Development Costs (High Costs)
2
3	September 24th	Income	Expense	Comments
4	Crowdfunding	$235,261,196		https://robertsspaceindustries.com/funding-goals			Kickstarter:		$2,134,374	Post-Kickstarter:		$233,126,822
5	Kickstarter Fees		$177,629	5 percent (kickstarter) + 3 percent + $0.20 per pledge (transaction)				https://www.kickstarter.com/projects/cig/star-citizen
6	Processing Fees		$6,760,678	Post-Kickstarter transaction processing fees (2.9%)
7	Illfonic Incentive	$763,953		http://www.denverpost.com/business/ci_26119442/economic-development-commission-approves-9-6-million-incentives
8	Illfonic Contract		$3,800,000	From link directly above
9	Other Incentives	$6,387,049		Using ratio for Illfonic as guess for other contractors and multiplier for internal studios
10	Turbulent Contract		$5,810,000	14 developers since November 2012
11	BHVR Contract		$9,200,000	40 developers since February 2012 (assuming 50% of their time is spent on Star Citizen work)
12	Moon Collider Contract		$1,560,000	4 developers since Spring 2013
13	Other Contractors		$1,500,000	Contracted artists, musicians, writers, etc
14	Acting Talent		$5,000,000	Payments to actors, voice actors, motion capture performers, etc
15	Studio Rental (Sq42)		$1,000,000	2 months studio rental in England for Squadron 42 recording
16	Other Equipment		$2,500,000	Equipment such as motion capture cameras, VR test hardware, controllers, furniture, office supplies, etc
17	Additional Expenses		$22,832,289	Bucket for miscellaneous "cost of doing business" expenses, such as taxes (assuming 10%)
18	Regular Expenses		$242,795,000	From table below
19	Totals	$242,412,198	$302,935,596
20
21	Funds Remaining	-$60,523,398	-24.97%
22
23	Regular Expenses	Amount	Comments
24	Salary and Benefits/yr	$100,000	Average annual salary and benefits for the typical employee
25	Employee Setup/ea	$10,000	One-time expenditure per employee for desks, chairs, hardware, software licenses, etc
26	Facility/mo	$30,000	Average lease and utilities per month per office
27	Servers/mo	$50,000	Monthly cost for servers (cloud and physical)
28	Bandwidth/mo	$100,000	Monthly cost for bandwidth
29	Travel/pp	$10,000	Assuming 10% of the staff incur travel expenses per year
30
31	Year	Months	Staff	Salary and Benefits	Employee Setup Expenses	Offices	Facility Costs	Server Costs	Bandwidth Costs	Merchandise / Marketing	Travel Expenses	Annual Expenses	Monthly Average
32	2012	3	5	$125,000	$50,000	1	$90,000	$150,000	$300,000	$0	$5,000	$720,000	$240,000
33	2013	12	59	$3,200,000	$540,000	2	$720,000	$600,000	$1,200,000	$500,000	$59,000	$6,819,000	$568,250
34	2014	12	183	$12,100,000	$1,240,000	4	$1,440,000	$600,000	$1,200,000	$1,000,000	$183,000	$17,763,000	$1,480,250
35	2015	12	280	$23,150,000	$970,000	4	$1,440,000	$600,000	$1,200,000	$1,500,000	$280,000	$29,140,000	$2,428,333
36	2016	12	363	$32,150,000	$830,000	4	$1,440,000	$600,000	$1,200,000	$2,000,000	$363,000	$38,583,000	$3,215,250
37	2017	12	475	$41,900,000	$1,120,000	5	$1,800,000	$600,000	$1,200,000	$2,500,000	$475,000	$49,595,000	$4,132,917
38	2018	12	500	$48,750,000	$250,000	5	$1,800,000	$600,000	$1,200,000	$3,000,000	$500,000	$56,100,000	$4,675,000
39	2019	9	500	$37,500,000	$0	5	$1,350,000	$450,000	$900,000	$3,500,000	$375,000	$44,075,000	$4,897,222
40	2020			$0	$0	5	$0	$0	$0	$0	$0	$0
41	Totals	84		$198,875,000	$5,000,000		$10,080,000	$4,200,000	$8,400,000	$14,000,000	$2,240,000	$242,795,000

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Star Citizen Development Costs (Probable)
2
3	September 24th	Income	Expense	Comments
4	Crowdfunding	$235,261,196		https://robertsspaceindustries.com/funding-goals			Kickstarter:		$2,134,374	Post-Kickstarter:		$233,126,822
5	Kickstarter Fees		$177,629	5 percent (kickstarter) + 3 percent + $0.20 per pledge (transaction)				https://www.kickstarter.com/projects/cig/star-citizen
6	Processing Fees		$6,760,678	Post-Kickstarter transaction processing fees (2.45%)
7	Illfonic Incentive	$763,953		http://www.denverpost.com/business/ci_26119442/economic-development-commission-approves-9-6-million-incentives
8	Illfonic Contract		$3,800,000	From link directly above
9	Other Incentives	$6,215,160		Using ratio for Illfonic as guess for other contractors and multiplier for internal studios
10	Turbulent Contract		$5,495,000	14 developers since November 2012
11	BHVR Contract		$8,750,000	40 developers since February 2012 (assuming 50% of their time is spent on Star Citizen work)
12	Moon Collider Contract		$1,470,000	4 developers since Spring 2013
13	Other Contractors		$1,125,000	Contracted artists, musicians, writers, etc
14	Acting Talent		$3,000,000	Payments to actors, voice actors, motion capture performers, etc
15	Studio Rental (Sq42)		$750,000	2 months studio rental in England for Squadron 42 recording
16	Other Equipment		$2,000,000	Equipment such as motion capture cameras, VR test hardware, controllers, furniture, office supplies, etc
17	Additional Expenses		$17,124,217	Bucket for miscellaneous "cost of doing business" expenses, such as taxes (assuming 5%)
18	Regular Expenses		$157,648,750	From table below
19	Totals	$242,240,309	$208,101,274
20
21	Funds Remaining	$34,139,035	14.09%
22
23	Regular Expenses	Amount	Comments
24	Salary and Benefits/yr	$80,000	Average annual salary and benefits for the typical employee
25	Employee Setup/ea	$7,500	One-time expenditure per employee for desks, chairs, hardware, software licenses, etc
26	Facility/mo	$25,000	Average lease and utilities per month per office
27	Servers/mo	$40,000	Monthly cost for servers (cloud and physical)
28	Bandwidth/mo	$75,000	Monthly cost for bandwidth
29	Travel/pp	$7,500	Assuming 10% of the staff incur travel expenses per year
30
31	Year	Months	Staff	Salary and Benefits	Employee Setup Expenses	Offices	Facility Costs	Server Costs	Bandwidth Costs	Merchandise / Marketing	Travel Expenses	Annual Expenses	Monthly Average
32	2012	3	5	$100,000	$37,500	1	$75,000	$120,000	$225,000	$0	$3,750	$561,250	$187,083
33	2013	12	59	$2,560,000	$405,000	2	$600,000	$480,000	$900,000	$300,000	$44,250	$5,289,250	$440,771
34	2014	12	183	$9,680,000	$930,000	4	$1,200,000	$480,000	$900,000	$600,000	$137,250	$13,927,250	$1,160,604
35	2015	12	280	$18,520,000	$727,500	4	$1,200,000	$480,000	$900,000	$900,000	$210,000	$22,937,500	$1,911,458
36	2016	12	363	$25,720,000	$622,500	4	$1,200,000	$480,000	$900,000	$1,400,000	$272,250	$30,594,750	$2,549,563
37	2017	12	475	$33,520,000	$840,000	5	$1,500,000	$480,000	$900,000	$1,900,000	$356,250	$39,496,250	$3,291,354
38	2018	12	500	$39,000,000	$187,500	5	$1,500,000	$480,000	$900,000	$2,400,000	$375,000	$44,842,500	$3,736,875
39	2019			$0	$0	5	$0	$0	$0	$0	$0	$0
40	Totals	75		$129,100,000	$3,750,000		$7,275,000	$3,000,000	$5,625,000	$7,500,000	$1,398,750	$157,648,750

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Star Citizen Development Costs (Low Costs)
2
3	September 24th	Income	Expense	Comments
4	Crowdfunding	$235,261,196		https://robertsspaceindustries.com/funding-goals			Kickstarter:		$2,134,374	Post-Kickstarter:		$233,126,822
5	Kickstarter Fees		$177,629	5 percent (kickstarter) + 3 percent + $0.20 per pledge (transaction)				https://www.kickstarter.com/projects/cig/star-citizen
6	Processing Fees		$6,760,678	Post-Kickstarter transaction processing fees (2.0%)
7	Illfonic Incentive	$763,953		http://www.denverpost.com/business/ci_26119442/economic-development-commission-approves-9-6-million-incentives
8	Illfonic Contract		$3,800,000	From link directly above
9	Other Incentives	$6,043,270		Using ratio for Illfonic as guess for other contractors and multiplier for internal studios
10	Turbulent Contract		$5,180,000	14 developers since November 2012
11	BHVR Contract		$8,300,000	40 developers since February 2012 (assuming 50% of their time is spent on Star Citizen work)
12	Moon Collider Contract		$1,380,000	4 developers since Spring 2013
13	Other Contractors		$750,000	Contracted artists, musicians, writers, etc
14	Acting Talent		$1,000,000	Payments to actors, voice actors, motion capture performers, etc
15	Studio Rental (Sq42)		$500,000	2 months studio rental in England for Squadron 42 recording
16	Other Equipment		$1,500,000	Equipment such as motion capture cameras, VR test hardware, controllers, furniture, office supplies, etc
17	Additional Expenses		$11,416,144	Bucket for miscellaneous "cost of doing business" expenses, such as taxes (assuming 5%)
18	Regular Expenses		$116,577,500	From table below
19	Totals	$242,068,419	$157,341,952
20
21	Funds Remaining	$84,726,468	35.00%
22
23	Regular Expenses	Amount	Comments
24	Salary and Benefits/yr	$60,000	Average annual salary and benefits for the typical employee
25	Employee Setup/ea	$5,000	One-time expenditure per employee for desks, chairs, hardware, software licenses, etc
26	Facility/mo	$20,000	Average lease and utilities per month per office
27	Servers/mo	$30,000	Monthly cost for servers (cloud and physical)
28	Bandwidth/mo	$50,000	Monthly cost for bandwidth
29	Travel/pp	$5,000	Assuming 10% of the staff incur travel expenses per year
30
31	Year	Months	Staff	Salary and Benefits	Employee Setup Expenses	Offices	Facility Costs	Server Costs	Bandwidth Costs	Merchandise / Marketing	Travel Expenses	Annual Expenses	Monthly Average
32	2012	3	5	$75,000	$25,000	1	$60,000	$90,000	$150,000	$0	$2,500	$402,500	$134,167
33	2013	12	59	$1,920,000	$270,000	2	$480,000	$360,000	$600,000	$100,000	$29,500	$3,759,500	$313,292
34	2014	12	183	$7,260,000	$620,000	4	$960,000	$360,000	$600,000	$200,000	$91,500	$10,091,500	$840,958
35	2015	12	280	$13,890,000	$485,000	4	$960,000	$360,000	$600,000	$300,000	$140,000	$16,735,000	$1,394,583
36	2016	12	363	$19,290,000	$415,000	4	$960,000	$360,000	$600,000	$800,000	$181,500	$22,606,500	$1,883,875
37	2017	12	475	$25,140,000	$560,000	5	$1,200,000	$360,000	$600,000	$1,300,000	$237,500	$29,397,500	$2,449,792
38	2018	12	500	$29,250,000	$125,000	5	$1,200,000	$360,000	$600,000	$1,800,000	$250,000	$33,585,000	$2,798,750
39	2019			$0	$0	5	$0	$0	$0	$0	$0	$0
40	Totals	75		$96,825,000	$2,500,000		$5,820,000	$2,250,000	$3,750,000	$4,500,000	$932,500	$116,577,500