Technocopia Pilot Financials (not current)

	A	B	C	D	E	F	G	H	I	J
1	Cost Parametrics						BlackTooth	ServoStock	Black Foot 4'x8'	Vitamin Box
2						Cost of machine	$2,100.00	$300.00	$3,344.00	$300.00
3	Hours/week (hours)	40				Hours/week (hours)	40	200	40
4	Software Engineer Rate	$75,000.00				Hours/month (hours)	160	800	160
5	Engineer Rate	$65,000.00
6	Marketing	$60,000.00
7	Maintenance	$40,000.00
8	BlackTooth (#)	1				Time to print (hours)	0.25	2.00
9	ServoStock (#)	5
10	Vitamin Box (#)	1
11	Black Foot 4'x8' (#)	1
12		year 1	year 2	year 3	year 4
13	Salary scale factor	66.00%	66.00%	75.00%	100.00%
14	Software Engineer #	1	2	3	3
15	Engineer #	2	2	2	3
16	Marketing #	1	1	1	1
17	Maintenance #	1	1	1	1
18	R&D Consumables/month	$500.00				Prints/month (#)	640	400
19	Physical space Max Users	300
20	Physical space adoption rate	22.00%
21	Virtual space adoption rate	23.00%
22	Initial Donation Amount	$665,000.00
23
24	Pricing
25	Intro Rate	$75.00
26	Standard Rate	$125.00
27	Virtual Rate	$20.00
28
29	Fixed One Time Costs		Monthly Costs
30	BlackTooth	$2,100.00	Labor	$16,775.00
31	ServoStock	$1,500.00	Rent	$2,660.00
32	Black Foot 4'x8'	$3,344.00	Utilities	$750.00
33	Vitamin Box	$300.00	Maintinence	$500.00
34	Legacy Costs	$75,000.00	R&D	$500.00
35	Referbishment Cost	$50,000.00	Monthly Total	$21,185.00
36	Total Upfront	$125,000.00
37	Single Pipeline Cost	$7,244.00
38
39		Max	Min
40	Year 1 Credit Line	$289,651.00	$511,571.00
41	Year 2 Credit Line	$86,047.00	$266,833.50
42	Year 3 Credit Line	$80,470.00	$272,684.83
43	Year 4 Credit Line	$309,509.50	$2,542,218.83
44	Loan Terms	2.00%
46	Total Credit Line Needed	$0.00
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
101