Financial Model *Simple Version*

	A	B	C	D	E	F	G	H	I	J	K	L
1	NOTE: This model does not
2	consider overhead costs
3
4
5
6
7	SERVICE BASED:				Values To Enter:
8					* Individual Sale Price
9					* COGS (Costs of Goods Sold)
10					* CAC (Cost to Acquire a Customer)
11
12
13	Service	Quantity	Sale Price	Revenue	COGS	CAC	CC Fees	Total Costs	Profit	Margins
14	X	1	$750.00	$750.00	$500.00	$50.00	$22.50	$572.50	$177.50	23.67%
15	Y	1	$350.00	$350.00	$250.00	$30.00	$10.50	$290.50	$59.50	17.00%
16	Z	1	$400.00	$400.00	$300.00	$45.00	$12.00	$357.00	$43.00	10.75%
17
18
19
20
21
22
23
24
25	PRODUCT BASED:				Values To Enter:
26					* Sale Price	* Fulfillment Cost
27					* Product Cost	* CAC (Cost to Acquire a Customer)
28					* Freight Cost
29
30
31	Product	Quantity	Sale Price	Revenue	Product Cost	Freight Cost	Fulfillment Cost	CAC	CC Fees	Total COGS	Profit	Margins
32	X	1	$268.00	$268.00	$27.73	$15.00	$16.00	$120.00	$8.04	$186.77	$81.23	30.31%
33	Y	1	$233.00	$233.00	$50.00	$20.00	$10.00	$100.00	$6.99	$186.99	$46.01	19.75%
34	Z	1	$550.00	$550.00	$200.00	$100.00	$50.00	$200.00	$16.50	$566.50	-$16.50	-3.00%
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