ladyM Valuation

	A	B	D	E	F	G
1	Y1
2	Sales	1,887,988	Rent	$310,600	Retail price per cake	80
3	COGS	943,994	Utility Cost	$38,644	Cakes sold per year	23,600
4	Gross Profit	943,994	Labor Cost	$594,750	Cakes sold per day	65
5	Net Income	0	Total cost	$943,994
6	Setup cost	-
7
8	Sales growth by 20%	1,887,988
9	Retail price per cake	80	80	80	80	80
10	Cakes sold per year	23,600	28,320	33,984	40,781	48,937
11	Cakes sold per day	65	78	93	112	134
12
13	20% Sales Growth	Y1	Y2	Y3	Y4	Y5
14	Sales	$1,887,988	$2,265,586	$2,718,703	$3,262,443	$3,914,932
15	COGS	$943,994	$1,132,793	$1,359,351	$1,631,222	$1,957,466
16	Gross Profit	$943,994	$1,132,793	$1,359,351	$1,631,222	$1,957,466
17
19	Rent	$310,600	$319,918	$329,516	$339,401	$349,583
20	Utility Cost	$38,644	$39,803	$40,997	$42,227	$43,494
21	Labor Cost	$594,750	$624,488	$655,712	$688,497	$722,922
22	Total cost	$943,994	$984,209	$1,026,225	$1,070,126	$1,116,000
23	Net Profit	$0	$148,584	$333,127	$561,096	$841,466
24	Initial investment for WTC	$1,000,000	$1,000,000	$851,416	$518,289	-$42,806
25	Initial investment uncovered	$1,000,000	$851,416	$518,289	-$42,806	-$884,273
26
32	5% Sales Growth	Y1	Y2	Y3	Y4	Y5
33	Sales	$1,887,988	$1,982,387	$2,081,507	$2,185,582	$2,294,861
34	COGS	$943,994	$991,194	$1,040,753	$1,092,791	$1,147,431
35	Gross Profit	$943,994	$991,194	$1,040,753	$1,092,791	$1,147,431
36
37	Setup cost	-
38	Rent	$310,600	$319,918	$329,516	$339,401	$349,583
39	Utility Cost	$38,644	$39,803	$40,997	$42,227	$43,494
40	Labor Cost	$594,750	$624,488	$655,712	$688,497	$722,922
41	Total cost	$943,994	$984,209	$1,026,225	$1,070,126	$1,116,000
42	Net Income	$0	$6,985	$14,529	$22,665	$31,431
43	Initial investment for WTC	$1,000,000	$1,000,000	$993,015	$978,487	$955,821
44	Initial investment uncovered	$1,000,000	$993,015	$978,487	$955,821	$924,390
45
46	13.1909% Sales Growth	Y1	Y2	Y3	Y4	Y5
47	Sales	$1,887,988	$2,137,031	$2,418,924	$2,738,002	$3,099,169
48	COGS	$943,994	$1,068,515	$1,209,462	$1,369,001	$1,549,585
49	Gross Profit	$943,994	$1,068,515	$1,209,462	$1,369,001	$1,549,585
50
51	Rent	$310,600	$319,918	$329,516	$339,401	$349,583
52	Utility Cost	$38,644	$39,803	$40,997	$42,227	$43,494
53	Labor Cost	$594,750	$624,488	$655,712	$688,497	$722,922
54	Total cost	$943,994	$984,209	$1,026,225	$1,070,126	$1,116,000
55	Net Income	$0	$84,306	$183,237	$298,875	$433,585
56	Setup cost covered	$1,000,000	$1,000,000	$915,694	$732,456	$433,581
57	Setup cost uncovered	$1,000,000	$915,694	$732,456	$433,581	-$4
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
102
103
104
105
106