Creating an Excel spreadsheet

Assumptions

PROJECT NAME

Main Assumptions

PLEASE, USE THIS EXCEL FILE AS EXAMPLE TO PREPARE YOUR OWN

THE EXAMPLE IS ON A TOP-DOWN APPROACH. IN CASE YOUR BUSINESS IDEA IS BOTTOM-UP, PLEASE MAKE ADJUSTMENTS

Names of Team Members/Promoters

General Assumptions

Currency:

USD

Excel Model:

Inputs in blue

Calculations in black

Approach:

Bottom up approach

BP Period:

We used 5 years to ensure a sufficient forecast period with a second location in the third year

Revenue Assumptions

Year 3 - New Location in Boston Common

We plan to open a location in Boston Common in the third year. We assume that based on the characteristics of the new location we can achieve a similar cost structure as in our first shed.

Bottom up approach

We assume that our shop is open 9h a day/ 7 days per week. For serving one costumer we need 3 min and we have two people for selling and two people for preparing the orders. Each costumer buys based on a gaussian dirstribution a mix of 2 products (actually 2,5, but we assume a worse case scenario). This leads to a maximal possible amount of sold products. In reality 100% of workload during a day and selling the maximum possible amount are not possiple, therefore we assume that in the beginning we will sell low volumes that grow to 51% at the end of the first year. In the second year we assume our sold volume will sharply increase to 62%. Our products ice cream, Stroopwaffle, Tredelnik and coffee are sold during the whole year, apple cider and hot chocolate we only serve in the cold months lasting from october to march. As especially ice cream is affected by seasonal trends we add this effects to our calculation.

Product

Offer

Opening hours:

9h=

540

min

Ice cream

full year

2 sales people and 2 preparing people

Apple cider/ Hot chocolate

November-March

Time to serve 1 costumer:

3

min

Sweet food

full year

Potential costumers per day:

360

Coffee

full year

Potential costumers per month assuming full workload:

10800

Each costumer buys two products

2

Maximum possible amount of products sold per month

21600

Prices

We price the standard products coffee, ice cream, hot chocolate and apple cider in comparison to our local competitors. The pricing for our differentiated products Tredelnik and Stroopwaffle can't be only based on the competitors' prices, because they are operating in other countries with lower food costs. Therefore we asked ourselves what we were willing to pay for these products. Considering the direct costs as well, the price structure for all products is shown in the table. As the price for the tredelnik is higher than the stroopwaffles's price, we assume that we will sell more stroopwaffles.

Price

Competitor

Price value

Final price

Ice cream

3.50

-

3.50

Stroopwaffle

2.00

2.50

2.50

Tredelnik

3.50

4.00

4.00

Coffe

3.00

-

3.00

Hot chocolate

3.50

-

3.50

Apple cider

5.00

-

5.00

Growth rates:

Year 2 -> 3

Year 3 -> 4

Year 4 -> 5

We assume that for the 3.,4. and 5. year we will have a sharp growth in sold volumes, because the maximum scalability is reached very fast in a shed.

4%

3%

2%

Growth in sold volumes

Costs Assumptions

Direct cost

For calculating the direct costs of our products we assume the average supermarket prices in America. For easier calculation we don't have direct personal costs.

Utilities (yearly)

We assume that the utilities like electricity, water and heating are 2$/sqm a month. Our operating space is 256 sqm.

$ 480.00

Insurance

We assume that our insurance costs will be 600$ a year. We compared the prices with a food truck insurance https://www.shopkeep.com/blog/how-much-does-it-cost-to-start-a-food-truck#step-1

$ 600.00

1. year

2. year

3. year

4. year

5. year

Promotional and advertising costs per year

We plan to give our costumers a discount card. If they buy 10 times something in our shed the 11. food order will be for free. We plan also several promotions during the year for special occasions. We will spend 10% of our revenues for advertising and promotion in the first year. In the advertising expenses are website maintainance, google listing, facebook/Instagram advertising and public advertising included. In the following years we will reduce these expenses due to our gained popularity.

0

0

0

0

0

Permit from Boston

For the permission to operate in the central area we have costs of 500$ per year.

$ 500.00

Wages (yearly)

We assumed that we would have in total 7 part time workers. Each of them will be trained in sale and product preparation. We will pay them 13$/h. As we open a second shop we will have the same personal structure over there.

$ 163,800.00

Our Salary

We assumed that we pay ourself no salary, because it is our dream and our idea which should not affected our project in the first 5 years.

Rent (yearly)

We will own the shed but rent a central spot from a company, therefore we assume 2000$ monthly rent fees, also for the second location. Local rent prices are around 2500$. As we rent only a spot, we subtracted 500$.

$ 24,000.00

1.-2. year

3.-5. year

Logistic

We will work with retailers to get the ingredients for our products delivered. Therefore we assume yearly delivery costs of 400$. As our second shop is in a different location the delivery costs increase to 600$ in the third year.

$ 400.00

$ 600.00

Further assumptions

Break even

We assumed that we have to pay some marketing costs, the rent and the permission from Boston upfront before starting to operate. For the SGA we calvulated an average rate excluding the costs mentioned before.

Marketing costs 1. month

$ 15,000.00

Permission

$ 500.00

Rent

$ 2,000.00

P&L

		PROJECT NAME
		Profit and Loss
			Year 1		Year 2		Year 3		Year 4		Year 5
		Total Revenue	$ 373,559		$ 505,185		$ 898,952		$ 1,046,339		$ 1,077,370
		COGS	$ 82,131	22.0%	$ 111,289	22.0%	$ 197,872	22.0%	$ 230,502	22.0%	$ 237,338	22.0%
		SGA
		Rent	$ 24,000		$ 24,000		$ 48,000		$ 48,000		$ 48,000
		Marketing	$ 37,356		$ 25,259		$ 35,958		$ 41,854		$ 32,321
		Wages	$ 163,800		$ 163,800		$ 327,600		$ 327,600		$ 327,600
		Utilities	$ 480		$ 480		$ 960		$ 960		$ 960
		Other costs	$ 1,500		$ 1,500		$ 2,800		$ 2,800		$ 2,800
		Total SGA	$ 227,136	60.8%	$ 215,039	42.6%	$ 415,318	46.2%	$ 421,214	40.3%	$ 411,681	38.2%
		Total Expenses	-309,267		-326,328		-613,190		-651,715		-649,019
		EBITDA	$ 64,292	17.2%	$ 178,857	35.4%	$ 285,762	31.8%	$ 394,624	37.7%	$ 428,351	39.8%

add_calculations_revenue

	Sales stream
	Product		Offer
	Ice cream		full year
	Apple cider/ Hot chocolate		November-March
	Sweet food		full year
	Coffee		full year
	Calculation for sold volume
	Opening hours:	11 a.m. - 8 p.m.		9h=	540	min
	2 sales people and 2 preparing people
	Time to serve 1 costumer:				3	min
	Potential costumers per day:				360
	Potential costumers per month assuming full workload:				10,800
	Each costumer buys two products				2
	Maximum possible amount of products sold per month				21,600
	Sold volume 1. year
		January	February	March	April	Mai	June	July	August	September	Oktober	November	December	Total
	Maximum amount	21,600	21,600	21,600	21,600	21,600	21,600	21,600	21,600	21,600	21,600	21,600	21,600	259,200
	Percentage sold	30%	30%	35%	40%	40%	45%	45%	50%	50%	51%	52%	52%
	Volume 1. year	6,480	6,480	7,560	8,640	8,640	9,720	9,720	10,800	10,800	11,016	11,232	11,232	112,320
	Sold volume 2. year
	Maximum amount	21,600	21,600	21,600	21,600	21,600	21,600	21,600	21,600	21,600	21,600	21,600	21,600	259,200
	Percentage sold	52%	55%	57%	58%	59%	60%	60%	60%	60%	60%	61%	61%
		11,232	11,880	12,312	12,528	12,744	12,960	12,960	12,960	12,960	12,960	13,176	13,176	151,848
	Sales structure in % of volume (every year):
		January	February	March	April	Mai	June	July	August	September	Oktober	November	December
	Ice cream	5%	5%	10%	20%	25%	35%	40%	45%	38%	20%	5%	5%
	Stroopwaffle	32%	32%	30%	35%	32%	27%	25%	22%	26%	25%	30%	30%
	Tredelnik	28%	28%	25%	30%	28%	23%	20%	18%	21%	19%	25%	25%
	Coffe	15%	15%	15%	15%	15%	15%	15%	15%	15%	16%	20%	20%
	Hot chocolate	10%	10%	10%	-	-	-	-	-	-	10%	10%	10%
	Apple Cider	10%	10%	10%	-	-	-	-	-	-	10%	10%	10%
	Total	100%	100%	100%	100%	100%	100%	100%	100%	100%	100%	100%	100%
	Sold volumes for each product (1. year)
		January	February	March	April	Mai	June	July	August	September	Oktober	November	December	Total
	Ice cream	324	324	756	1,728	2,160	3,402	3,888	4,860	4,104	2,203	562	562	24,872
	Stroopwaffle	2,074	2,074	2,268	3,024	2,765	2,624	2,430	2,376	2,808	2,754	3,370	3,370	31,936
	Tredelnik	1,814	1,814	1,890	2,592	2,419	2,236	1,944	1,944	2,268	2,093	2,808	2,808	26,631
	Coffe	972	972	1,134	1,296	1,296	1,458	1,458	1,620	1,620	1,763	2,246	2,246	18,081
	Hot chocolate	648	648	756							1,102	1,123	1,123	5,400
	Apple Cider	648	648	756							1,102	1,123	1,123	5,400
	Total	6,480	6,480	7,560	8,640	8,640	9,720	9,720	10,800	10,800	11,016	11,232	11,232	112,320
	Sold volumes for each product (2. year)
	Ice cream	562	594	1,231	2,506	3,186	4,536	5,184	5,832	4,925	2,592	659	659	32,465
	Stroopwaffle	3,594	3,802	3,694	4,385	4,078	3,499	3,240	2,851	3,370	3,240	3,953	3,953	43,658
	Tredelnik	3,145	3,326	3,078	3,758	3,568	2,981	2,592	2,333	2,722	2,462	3,294	3,294	36,554
	Coffe	1,685	1,782	1,847	1,879	1,912	1,944	1,944	1,944	1,944	2,074	2,635	2,635	24,224
	Hot chocolate	1,123	1,188	1,231							1,296	1,318	1,318	7,474
	Apple Cider	1,123	1,188	1,231							1,296	1,318	1,318	7,474
	Total	11,232	11,880	12,312	12,528	12,744	12,960	12,960	12,960	12,960	12,960	13,176	13,176	151,848

Seasonal Product Sales in % volume

Ice cream January February March April Mai June July August September Oktober November December 0.05 0.05 0.1 0.2 0.25 0.35 0.4 0.45 0.38 0.2 0.05 0.05 Stroopwaffle January February March April Mai June July August September Oktober November December 0.32 0.32 0.3 0.35 0.32 0.27 0.25 0.22 0.26 0.25 0.3 0.3 Tredelnik January February March April Mai June July August September Oktober November December 0.28000000000000003 0.28000000000000003 0.25 0.3 0.28000000000000003 0.23 0.2 0.18 0.21 0.19 0.25 0.25 Coffe January February March April Mai June July August September Oktober November December 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.16 0.2 0.2 Hot chocolate January February March April Mai June July August September Oktober November December 0.1 0.1 0.1 0 0 0 0 0 0 0.1 0.1 0.1 Apple Cider January February March April Mai June July August September Oktober November December 0.1 0.1 0.1 0 0 0 0 0 0 0.1 0.1 0.1

Revenue

				Revenue calculation
		Volume
				Year 1	Year 2	Year 3	Year 4	Year 5
		Growth				4%	3%	2%
		Sold volumes in the first shop:
		Ice cream		24,872	32,465	33,763	34,776	35,472
		Stroopwaffle		31,936	43,658	45,404	46,766	47,702
		Tredelnik		26,631	36,554	38,016	39,156	39,939
		Coffe		18,081	24,224	25,193	25,949	26,468
		Hot chocolate		5,400	7,474	7,773	8,006	8,166
		Apple cider		5,400	7,474	7,773	8,006	8,166
		Sold volumes in the second shop:						4%
		Ice cream				24,872	32,465	33,763
		Stroopwaffle				31,936	43,658	45,404
		Tredelnik				26,631	36,554	38,016
		Coffe				18,081	24,224	25,193
		Hot chocolate				5,400	7,474	7,773
		Apple cider				5,400	7,474	7,773
		Price
			Competitor (average)		Price value	final price
		Ice cream	$ 3.50		-	$ 3.50
		Stroopwaffle	$ 2.00		$ 2.50	$ 2.50
		Tredelnik	$ 3.50		$ 4.00	$ 4.00
		Coffe	$ 3.00		-	$ 3.00
		Hot chocolate	$ 3.50		-	$ 3.50
		Apple cider	$ 5.00		-	$ 5.00
		Revenue
				Year 1	Year 2	Year 3	Year 4	Year 5
		Ice cream		$ 87,053	$ 113,627	$ 205,225	$ 235,344	$ 242,323
		Stroopwaffle		$ 79,839	$ 109,145	$ 193,350	$ 226,061	$ 232,765
		Tredelnik		$ 106,523	$ 146,215	$ 258,586	$ 302,840	$ 311,821
		Coffe		$ 54,244	$ 72,673	$ 129,824	$ 150,521	$ 154,985
		Hot chocolate		$ 18,900	$ 26,158	$ 46,104	$ 54,178	$ 55,784
		Apple cider		$ 27,000	$ 37,368	$ 65,863	$ 77,397	$ 79,692
		Total revenue		$ 373,559	$ 505,185	$ 898,952	$ 1,046,339	$ 1,077,370

Revenue

Ice cream Stroopwaffle Tredelnik Coffee Hot chocolate Apple cider 0.5703076923076924 0.43550000000000005 1.2 0.83000000000000007 0.6100000000000001 0.7 GOGS

Ice cream Stroopwaffle Tredelnik Coffee Hot chocolate Apple cider 3.5 2.5 4 3 3.5 5

Direct costs calculation

	Summary
		Direct costs per unit
	Ice cream	$0.57
	Stroopwaffle	$0.44
	Tredelnik	$1.20
	Coffee	$0.83
	Hot chocolate	$0.61
	Apple cider	$0.70
	Direct costs calculation Ice cream
		quantity for 1 basin	costs per unit	total
	eggs	10	$0.46	$4.60
	sugar	2	$0.23	$0.46
	corn starch	2	$0.14	$0.28
	vanilla extract	1	$1.42	$1.42
	milk	1	$11.39	$11.39
	heavy cream	0.5	$14.24	$7.12
	ice	0.5	$1.50	$0.75
	one basin (65 scoops)			$26.02
	costs per unit			$0.40
	additional costs:		costs per unit
	cone/cup		$0.10
	nap kin		$0.02
	waffle		$0.05
	Final direct costs for ice cream Julia Pfaller: Julia Pfaller: Based on a survey for personal preferences			costs per unit
	Ice cream			0.57
	Direct costs Stroopwaffle
		quantity for 20		total
	fresh yeast cake	1 oz		$2.50
	tablespoon milk	1 tablespoon		$0.05
	butter	8 oz		$1.20
	caster sugar	7 oz		$0.07
	egg	1		$0.46
	cake flour	8,8 oz		$2.30
	Dutch molasses syrup	4,6 oz		$1.68
	cinnamon	teaspoon		$0.05
	nap kin	20		$0.40
	20 Stroopwaffles			$8.71
	costs per unit			$0.44
	Direct costs Tredelnik
		quantity for 8		total
	flour	4,25 oz		$0.14
	margarine	2,6 oz		$0.33
	cream	8 ounces		$1.30
	yeast	1,5 oz		$3.75
	powder sugar	taplespoon		$0.05
	eggs	3		$1.38
	shaved almonds for dusting	1 package		$2.00
	package	8		$0.65
	8 Tredelnik			$9.60
	costs per unit			$1.20
	Direct costs coffee
				total
	milk			$0.21
	beans			$0.22
	cups			$0.20
	syrup			$0.20
	costs per unit			$0.83
	Direct costs hot chocolate
				total
	milk			$0.21
	chocolate			$0.20
	cup			$0.20
	costs per unit			$0.61
	Direct costs apple cider
		quantity	costs per unit	total
	apple cider	1 gallon		$8.00
	cups	16	$0.20	$3.20
	1 gallon apple cider (16 cups)			$11.20
	costs per unit			0.70

COGS and SGA

		Costs
		Costs
				Year 1	Year 2	Year 3	Year 4	Year 5
		Total sold volumes
		Ice cream		24,872	32,465	58,636	67,241	69,235
		Stroopwaffle		31,936	43,658	77,340	90,424	93,106
		Tredelnik		26,631	36,554	64,646	75,710	77,955
		Coffe		18,081	24,224	43,275	50,174	51,662
		Hot chocolate		5,400	7,474	13,173	15,479	15,938
		Apple cider		5,400	7,474	13,173	15,479	15,938
		Direct costs of product
		Ice cream		0.57
		Stroopwaffle		0.44
		Tredelnik		1.20
		Coffee		0.83
		Hot chocolate		0.61
		Apple cider		0.70
				Year 1	Year 2	Year 3	Year 4	Year 5
		COGS
		Ice cream		$ 14,185	$ 18,515	$ 33,440	$ 38,348	$ 39,485
		Stroopwaffle		$ 13,908	$ 19,013	$ 33,681	$ 39,380	$ 40,548
		Tredelnik		$ 31,957	$ 43,864	$ 77,576	$ 90,852	$ 93,546
		Coffee		$ 15,008	$ 20,106	$ 35,918	$ 41,644	$ 42,879
		Hot chocolate		$ 3,294	$ 4,559	$ 8,035	$ 9,442	$ 9,722
		Apple cider		$ 3,780	$ 5,232	$ 9,221	$ 10,836	$ 11,157
		Total GOGS		$ 82,131	$ 111,289	$ 197,872	$ 230,502	$ 237,338
		Selling, General and Administative expenses
						(new shed doubles expenses)
		Rent		$ 24,000	$ 24,000	$ 48,000	$ 48,000	$ 48,000
		Permission		$ 500	$ 500	$ 1,000	$ 1,000	$ 1,000
		Insurance		$ 600	$ 600	$ 1,200	$ 1,200	$ 1,200
		Utilities		$ 480	$ 480	$ 960	$ 960	$ 960
		Logistics		$ 400	$ 400	$ 600	$ 600	$ 600
		Wages		$ 163,800	$ 163,800	$ 327,600	$ 327,600	$ 327,600
		% advertising on revenue		10%	5%	4%	4%	3%
		Advertising and Promotion		$ 37,356	$ 25,259	$ 35,958	$ 41,854	$ 32,321
		Total SGA		$ 227,136	$ 215,039	$ 415,318	$ 421,214	$ 411,681
		Rent		$ 24,000
		Utilities		$ 480
		Salary for 1 shed:
		13$/h with 9h operating hours, 350 opening days and 4 workes per shift		$ 163,800	per year

Break even

	Volumes		January	February	March	April	Mai	June	July	August	September	Oktober	November	December
	Ice cream		324	324	756	1,728	2,160	3,402	3,888	4,860	4,104	2,203	562	562
	Stroopwaffle		2,074	2,074	2,268	3,024	2,765	2,624	2,430	2,376	2,808	2,754	3,370	3,370
	Tredelnik		1,814	1,814	1,890	2,592	2,419	2,236	1,944	1,944	2,268	2,093	2,808	2,808
	Coffe		972	972	1,134	1,296	1,296	1,458	1,458	1,620	1,620	1,763	2,246	2,246
	Hot chocolate		648	648	756							1,102	1,123	1,123
	Apple Cider		648	648	756							1,102	1,123	1,123
	Price				Direct costs of product
	Ice cream		$ 3.50		Ice cream		0.57
	Stroopwaffle		$ 2.50		Stroopwaffle		0.44
	Tredelnik		$ 4.00		Tredelnik		1.20
	Coffe		$ 3.00		Coffee		0.83
	Hot chocolate		$ 3.50		Hot chocolate		0.61
	Apple cider		$ 5.00		Apple cider		0.70
		Year beginning (0)	January	February	March	April	May	June	July	August	September	October	November	December
	Ice cream		$ 1,134	$ 1,134	$ 2,646	$ 6,048	$ 7,560	$ 11,907	$ 13,608	$ 17,010	$ 14,364	$ 7,711	$ 1,966	$ 1,966
	Stroopwaffle		$ 5,184	$ 5,184	$ 5,670	$ 7,560	$ 6,912	$ 6,561	$ 6,075	$ 5,940	$ 7,020	$ 6,885	$ 8,424	$ 8,424
	Tredelnik		$ 7,258	$ 7,258	$ 7,560	$ 10,368	$ 9,677	$ 8,942	$ 7,776	$ 7,776	$ 9,072	$ 8,372	$ 11,232	$ 11,232
	Coffe		$ 2,916	$ 2,916	$ 3,402	$ 3,888	$ 3,888	$ 4,374	$ 4,374	$ 4,860	$ 4,860	$ 5,288	$ 6,739	$ 6,739
	Hot chocolate		$ 2,268	$ 2,268	$ 2,646	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ 3,856	$ 3,931	$ 3,931
	Apple Cider		$ 3,240	$ 3,240	$ 3,780	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ 5,508	$ 5,616	$ 5,616
	Total	$ - 0	$ 22,000	$ 22,000	$ 25,704	$ 27,864	$ 28,037	$ 31,784	$ 31,833	$ 35,586	$ 35,316	$ 37,620	$ 37,908	$ 37,908
	COGS		January	February	March	April	Mai	June	July	August	September	Oktober	November	December
	Ice cream		$ 185	$ 185	$ 431	$ 985	$ 1,232	$ 1,940	$ 2,217	$ 2,772	$ 2,341	$ 1,257	$ 320	$ 320
	Stroopwaffle		$ 903	$ 903	$ 988	$ 1,317	$ 1,204	$ 1,143	$ 1,058	$ 1,035	$ 1,223	$ 1,199	$ 1,467	$ 1,467
	Tredelnik		$ 2,177	$ 2,177	$ 2,268	$ 3,110	$ 2,903	$ 2,683	$ 2,333	$ 2,333	$ 2,722	$ 2,512	$ 3,370	$ 3,370
	Coffe		$ 807	$ 807	$ 941	$ 1,076	$ 1,076	$ 1,210	$ 1,210	$ 1,345	$ 1,345	$ 1,463	$ 1,865	$ 1,865
	Hot chocolate		$ 395	$ 395	$ 461	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ 672	$ 685	$ 685
	Apple Cider		$ 454	$ 454	$ 529	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ 771	$ 786	$ 786
	Total		$ 4,921	$ 4,921	$ 5,618	$ 6,489	$ 6,415	$ 6,976	$ 6,819	$ 7,484	$ 7,630	$ 7,874	$ 8,493	$ 8,493
	Delivery 4 times per month		$ 1,230	$ 1,230	$ 1,405	$ 1,622	$ 1,604	$ 1,744	$ 1,705	$ 1,871	$ 1,907	$ 1,968	$ 2,123	$ 2,123
	15 days to pay invoice
	Money to pay first month		$ 2,460	$ 4,921	$ 5,270	$ 6,053	$ 6,452	$ 6,695	$ 6,897	$ 7,151	$ 7,557	$ 7,752	$ 8,183	$ 8,493
	Costs to pay upfront in the first month
	Marketing costs 1. month		$ 15,000
	Permission		$ 500
	Rent		$ 2,000
	Average SGA for feb-dec		$ 17,470
			0	January	February	March	April	May	June	July	August	September	October	November	December
	Total costs		$ 17,500	$ 19,930	$ 22,390	$ 22,739	$ 23,523	$ 23,921	$ 24,165	$ 24,367	$ 24,621	$ 25,026	$ 25,221	$ 25,653	$ 25,963
	Difference (Break even)		$ 17,500	$ 2,070	$ 391	$ 2,965	$ 4,341	$ 4,116	$ 7,619	$ 7,466	$ 10,965	$ 10,290	$ 12,398	$ 12,255	$ 11,945
	Money needed to cover the negative period		$ 17,891

Break even analysis 1. year

Revenue 0 January February March April May June July August September October November December 0 21999.599999999999 21999.599999999999 25704 27864 28036.800000000003 31784.400000000001 31833 35586 35316 37619.64 37908 37908 Costs 0 January February March April May June July August September October November December 17500 19930.034912820513 22390.411158974359 22739.25822051282 23523.143820512822 23921.248020512823 24164.972658974359 24366.925805128205 24620.861012820511 25026.393743589746 25221.240905128205 25653.052320512819 25962.908266666665 Difference

(17.500)

2.070

(391)

0 January February March April May June July August September October November December 17500 2069.565087179486 390.8111589743603 2964.7417794871 799 4340.8561794871785 4115.5519794871798 7619.4273410256428 7466.074194871795 10965.138987179489 10289.606256410254 12398.399094871795 12254.947679487181 11945.091733333335

CAPEX

	Investment			Price
	Shed (adjusted to our needs)			$ 15,000.00
	Ice cream 3 in one machine			$ 20,000.00
	Show desk			$ 8,000.00
	Stroopwaffle maker		2=150$	$ 300.00
	Tredelnik oven		2.000$	$ 4,000.00
	Kitchen equipment			$ 2,000.00
	Coffe maschines		2x2.000$	$ 4,000.00
	Total			$ 53,300.00
	NWC to cover			$ 17,891
	Investment and NWC			$ 71,191	=	$ 71,000
	Our Investment
	Robert			$ 7,000
	Julia			$ 4,000
	Courtney			$ 4,000
	Luke			$ 4,000
	Total			$ 19,000
	Our ask			$ 52,000

Robert Julia Courtney Luke

Robert Julia Courtney Luke Our ask 7000 4000 4000 4000 52000

Sources

Sources:

https://eatyourworld.com/destinations/europe/the_netherlands/amsterdam/what_to_eat/stroopwafel

http://norfolkdailynews.com/lite_rock/programs/dave_williams/most-popular-ice-cream-flavors/article_8e46a544-6a88-11e8-a65b-2bb11e94b092.html

https://www.dairyscience.info/index.php/ice-cream/218-ice-cream-startup.html

https://www.boston.gov/departments/small-business-development/how-get-food-truck-permit

https://thinkmobiles.com/blog/how-much-does-website-cost/

https://www.fundera.com/blog/business-startup-costs

https://www.numbeo.com/cost-of-living/in/Boston

http://norfolkdailynews.com/lite_rock/programs/dave_williams/most-popular-ice-cream-flavors/article_8e46a544-6a88-11e8-a65b-2bb11e94b092.html https://www.dairyscience.info/index.php/ice-cream/218-ice-cream-startup.html