Copy of Master - Pro Forma 1

	A	B	C	D	E	F	G	I	J	K	L	M	N	O	P	Q	R	S	T	AB
1
2
3		KEY						Please create a copy of this document before making changes.
4		Editable
5		Locked Cell						Explainer Video Link : https://proximity.wistia.com/medias/0a2ex2asyv
6
7								Expected Units Sold / Month (Year 1)												Furniture / Equipment
8	Products for Sale	Price/Unit	Avail. Units	Potential Rev.			Products for Sale	Jan	Feb	Mar	Apr	May	June	July	Aug	Sep	Oct	Nov	Dec	TVs
9	Flex Seating	$200.00	45	$9,000.00			Flex Seating	1	2	3	4	6	8	10	12	14	16	18	30	Projector
10	Dedicated Desk	$350.00	5	$1,750.00			Dedicated Desk	1	1	1	1	1	1	1	1	1	1	1	1	Tables
11	Small Office 1	$500.00	1	$500.00			Small Office 1	1	1	1	1	1	1	1	1	1	1	1	1	Chairs
12	Small office 2	$99.00	5	$495.00			Small office 2	0	0	0	0	0	0	0	0	0	0	0	0	A/V Equipment
13	Small office 3	$99.00	5	$495.00			Small office 3	0	0	0	0	0	3	3	3	3	3	3	3	Kitchen Equipment
14	Daily Drop-Ins	$30.00	20	$600.00			Daily Drop-Ins	1	1	1	1	1	1	1	1	1	1	1	1	Cords & Cables
15	Mail/Virtual			$0.00			Mail/Virtual	0	0	0	0	0	0	0	0	0	0	0	0	Etc.
16	Conference Rooms		0	$0.00			Conference Rooms	0	0	0	0	0	0	0	0	0	0	0	0
17	Total Capacity			$12,840.00				$1,080.00	$1,280.00	$1,480.00	$1,680.00	$2,080.00	$2,777.00	$3,177.00	$3,577.00	$3,977.00	$4,377.00	$4,777.00	$7,177.00
18
19			Year 1	Year 2	Year 3	Year 4		Expected Units Sold / Month (Year 2)
20	Costs / sqft		$10.00	$8.00	$10.00	$10.00		Jan	Feb	Mar	Apr	May	June	July	Aug	Sep	Oct	Nov	Dec
21	Costs/Month in $		$4,810.00	$3,848.00	$4,810.00	$4,810.00		20	20	22	22	22	23	23	24	24	24	24	40
22								1	1	1	1	1	1	1	1	1	1	1	1
23	Expenses		Year 1	Year 2	Year 3	Year 4		1	1	1	1	1	1	1	1	1	1	1	1
24	Total number of Sqft	5,772	$ (57,720.00)	$ (46,176.00)	$ (57,720.00)	$ (57,720.00)		0	0	0	0	0	0	0	0	0	0	0	0
25	Buildout	30,000	$ (30,000.00)	$ -	$ -	$ -		0	0	0	0	0	3	3	3	3	3	3	3
26	Furniture / Equipment*	25000	$ (25,000.00)	$ -	$ -	$ -		1	1	1	1	1	1	1	1	1	1	1	1
27	Copier	0	$ -	$ -	$ -	$ -		0	0	0	0	0	0	0	0	0	0	0	0
28	Signage	0	$ -	$ -	$ -	$ -		0	0	0	0	0	0	0	0	0	0	0	0
29	Marketing	1200	$ (1,200.00)	$ (1,200.00)	$ (1,200.00)	$ (1,200.00)		$4,880.00	$4,880.00	$5,280.00	$5,280.00	$5,280.00	$5,777.00	$5,777.00	$5,977.00	$5,977.00	$5,977.00	$5,977.00	$9,177.00
30		0	$ -	$ -	$ -	$ -
31		0	$ -	$ -	$ -	$ -		Expected Units Sold / Month (Year 3)
32	Expense	1000	$ (1,000.00)	$ (1,000.00)	$ (1,000.00)	$ (1,000.00)		Jan	Feb	Mar	Apr	May	June	July	Aug	Sep	Oct	Nov	Dec
33	Expense	0	$ -	$ -	$ -	$ -		Jan	Feb	Mar	Apr	May	June	July	Aug	Sep	Oct	Nov	Dec
34	Expense	0	$ -	$ -	$ -	$ -		20	20	22	22	22	23	23	24	24	24	24	26
35	Proximity Fee	5%	$ (1,871.95)	$ (3,511.95)	#VALUE!	$ -		1	1	1	1	1	1	1	1	1	1	1	1
36	Total Expenses		$ (116,791.95)	$ (51,887.95)	#VALUE!	$ (59,920.00)		1	1	1	1	1	1	1	1	1	1	1	1
37								0	0	0	0	0	0	0	0	0	0	0	0
38	Revenues		Year 1	Year 2	Year 3	Year 4		0	0	0	0	0	3	3	3	3	3	3	3
39	Total Revenues		$37,439.00	$70,239.00	#VALUE!	$0.00		1	1	1	1	1	1	1	1	1	1	1	1
40								0	0	0	0	0	0	0	0	0	0	0	0
41	Total Profit		-$79,352.95	$18,351.05	#VALUE!	-$59,920.00		#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!
42
43								Expected Units Sold / Month (Year 4)
44								Jan	Feb	Mar	Apr	May	June	July	Aug	Sep	Oct	Nov	Dec
45								0	0	0	0	0	0	0	0	0	0	0	0
46								0	0	0	0	0	0	0	0	0	0	0	0
47								0	0	0	0	0	0	0	0	0	0	0	0
48								0	0	0	0	0	0	0	0	0	0	0	0
49								0	0	0	0	0	0	0	0	0	0	0	0
50								0	0	0	0	0	0	0	0	0	0	0	0
51								0	0	0	0	0	0	0	0	0	0	0	0
52								0	0	0	0	0	0	0	0	0	0	0	0
53								$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
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