Business Plan - V0 - Mar 2014


1
2	Operational Parameters
3
4	ENGLISH							CAPEX estimates for different system sizes
5									Index	1	2	3	4	5	6	7	8	9	10
6			Select >>>	1	>>>	>>>	>>>		Multiplier	1	2	3	4	5	10	15	20	50	100
7	Fish tank volume		Lts	10,000					Fish tank volume	10,000	20,000	30,000	40,000	50,000	100,000	150,000	200,000	500,000	1,000,000
8	CAPEX		000 COP	$ 50,000				FX = COP/USD	000 COP	$ 50,000	$ 85,355	$ 118,301	$ 150,000	$ 180,902	$ 329,057	$ 471,825	$ 611,803	$ 1,426,777	$ 2,750,000
9			USD	$ 25,000				$ 2,000	USD	$ 25,000	$ 42,678	$ 59,151	$ 75,000	$ 90,451	$ 164,528	$ 235,912	$ 305,902	$ 713,388	$ 1,375,000
10								1	CAPEX Factor	1.00	1.71	2.37	3.00	3.62	6.58	9.44	12.24	28.54	55.00
11	Grow bed volume factor		Factor	1.0	3.0	4.0			Factor 1	1.00	1.71	2.37	3.00	3.62	6.58	9.44	12.24	28.54	55.00
12	Grow bed volme		Lts	10,000	30,000	40,000			Factor 2	1.00	1.41	1.73	2.00	2.24	3.16	3.87	4.47	7.07	10.00
13		3.785	Gal	2,642.01	7,926.02	10,568.03			Factor 3	1.00	1.69	2.10	2.39	2.61	3.30	3.71	4.00	4.91	5.61
14		1,000	M3	10.00	30.00	40.00
15	Grow bed depth		Mts	0.30	0.30	0.30
16	Gro bed area		M2	33.33	100.00	133.33
17
18						0.81		1.22
19	Grow bed width	Factor	Mts	0.25	0.50	0.75	1.00	1.25	1.50
20	Total grow bed length	1.0	Mts	133.33	66.67	44.44	33.33	26.67	22.22
21	(could be more than one)	3.0	Mts	400.00	200.00	133.33	100.00	80.00	66.67
22		4.0	Mts	533.33	266.67	177.78	133.33	106.67	88.89
23
24	Grow bed length according to	Factor	1.0	0.25	0.50	0.75	1.00	1.25	1.50
25	number of beds:	1	Mts	133.33	66.67	44.44	33.33	26.67	22.22
26		2	Mts	66.67	33.33	22.22	16.67	13.33	11.11
27		3	Mts	44.44	22.22	14.81	11.11	8.89	7.41
28		4	Mts	33.33	16.67	11.11	8.33	6.67	5.56
29		5	Mts	26.67	13.33	8.89	6.67	5.33	4.44
30		6	Mts	22.22	11.11	7.41	5.56	4.44	3.70
31		7	Mts	19.05	9.52	6.35	4.76	3.81	3.17
32		8	Mts	16.67	8.33	5.56	4.17	3.33	2.78
33		9	Mts	14.81	7.41	4.94	3.70	2.96	2.47
34		10	Mts	13.33	6.67	4.44	3.33	2.67	2.22
35		11	Mts	12.12	6.06	4.04	3.03	2.42	2.02
36		12	Mts	11.11	5.56	3.70	2.78	2.22	1.85
37		13	Mts	10.26	5.13	3.42	2.56	2.05	1.71
38		14	Mts	9.52	4.76	3.17	2.38	1.90	1.59
39		15	Mts	8.89	4.44	2.96	2.22	1.78	1.50
40		16	Mts	8.33	4.17	2.78	2.08	1.67	1.50
41		17	Mts	7.84	3.92	2.61	1.96	1.57	1.50
42		18	Mts	7.41	3.70	2.47	1.85	1.48	1.50
43		19	Mts	7.02	3.51	2.34	1.75	1.40	1.50
44		20	Mts	6.67	3.33	2.22	1.67	1.33	1.50
45
46	Grow bed length according to	Factor	3.0	0.25	0.50	0.75	1.00	1.25	1.50
47	number of beds:	1	Mts	400.00	200.00	133.33	100.00	80.00	66.67
48		2	Mts	200.00	100.00	66.67	50.00	40.00	33.33
49		3	Mts	133.33	66.67	44.44	33.33	26.67	22.22
50		4	Mts	100.00	50.00	33.33	25.00	20.00	16.67
51		5	Mts	80.00	40.00	26.67	20.00	16.00	13.33
52		6	Mts	66.67	33.33	22.22	16.67	13.33	11.11
53		7	Mts	57.14	28.57	19.05	14.29	11.43	9.52
54		8	Mts	50.00	25.00	16.67	12.50	10.00	8.33
55		9	Mts	44.44	22.22	14.81	11.11	8.89	7.41
56		10	Mts	40.00	20.00	13.33	10.00	8.00	6.67
57		11	Mts	36.36	18.18	12.12	9.09	7.27	6.06
58		12	Mts	33.33	16.67	11.11	8.33	6.67	5.56
59		13	Mts	30.77	15.38	10.26	7.69	6.15	5.13
60		14	Mts	28.57	14.29	9.52	7.14	5.71	4.76
61		15	Mts	26.67	13.33	8.89	6.67	5.33	4.44
62		16	Mts	25.00	12.50	8.33	6.25	5.00	4.17
63		17	Mts	23.53	11.76	7.84	5.88	4.71	3.92
64		18	Mts	22.22	11.11	7.41	5.56	4.44	3.70
65		19	Mts	21.05	10.53	7.02	5.26	4.21	3.51
66		20	Mts	20.00	10.00	6.67	5.00	4.00	3.33
67
68	Grow bed length according to	Factor	4.0	0.25	0.50	0.75	1.00	1.25	1.50
69	number of beds:	1	Mts	533.33	266.67	177.78	133.33	106.67	88.89
70		2	Mts	266.67	133.33	88.89	66.67	53.33	44.44
71		3	Mts	177.78	88.89	59.26	44.44	35.56	29.63
72		4	Mts	133.33	66.67	44.44	33.33	26.67	22.22
73		5	Mts	106.67	53.33	35.56	26.67	21.33	17.78
74		6	Mts	88.89	44.44	29.63	22.22	17.78	14.81
75		7	Mts	76.19	38.10	25.40	19.05	15.24	12.70
76		8	Mts	66.67	33.33	22.22	16.67	13.33	11.11
77		9	Mts	59.26	29.63	19.75	14.81	11.85	9.88
78		10	Mts	53.33	26.67	17.78	13.33	10.67	8.89
79		11	Mts	48.48	24.24	16.16	12.12	9.70	8.08
80		12	Mts	44.44	22.22	14.81	11.11	8.89	7.41
81		13	Mts	41.03	20.51	13.68	10.26	8.21	6.84
82		14	Mts	38.10	19.05	12.70	9.52	7.62	6.35
83		15	Mts	35.56	17.78	11.85	8.89	7.11	5.93
84		16	Mts	33.33	16.67	11.11	8.33	6.67	5.56
85		17	Mts	31.37	15.69	10.46	7.84	6.27	5.23
86		18	Mts	29.63	14.81	9.88	7.41	5.93	4.94
87		19	Mts	28.07	14.04	9.36	7.02	5.61	4.68
88		20	Mts	26.67	13.33	8.89	6.67	5.33	4.44
89
90
91				Separación entre plantas	Peso unitario promedio (gr/unid)	Precio Unitario				Periodo de producción y rotación de las camas de cultivo (Meses)
92				Space between plants	Plant unit weight (gr/unit)	Unit price	Used to "guesstimate" revenue potential. For complete financial projection see next page			Grow bed turnaround period (Months)
93				0.25	300					2	3	4	6
94	Vegetable production capacity	Factor		Unid	gr	COP$ / gr	COPMM $			COPMM $	COPMM $	COPMM $	COPMM $
95		1.0		533	160,000	15	2			14.4	9.6	7.2	4.8
96		3.0		1,600	480,000	15	7			43.2	28.8	21.6	14.4
97		4.0		2,133	640,000	15	10			57.6	38.4	28.8	19.2
98
99	Fish production capacity		Gal / lb		Lb
100	Fish tank "load"		5		528.40
101	(Gal of water / lb of fish)		15		176.13
102			20		132.10
103
104	Fish turnaround		Lts / Kg	Kg / M3	Kg	COP $ / Kg	MM $
105	12 months	2.204	8.59	116.46	239.75	3,500	0.8
106			25.76	38.82	79.92	3,500	0.3
107			34.35	29.11	59.94	3,500	0.2
108
109	Number of fish (adult weight)	Gr / Unid	Lts / Kg	Unid	Prom	Unid / Mes
110		500	25.76	159	139	12
111			34.35	119
112		750	25.76	106	93	8
113			34.35	79
114		700	25.76	114	100	8
115			34.35	85
116		500	25.76	159	139	12
117			34.35	119
118
119	Overall system water volume		Factor	1.0	3.0	4.0
120	Fish tanks		Lts	10,000	10,000	10,000
121	Grow beds		Lts	10,000	30,000	40,000
122	Sump	25%	Lts	2,500	7,500	10,000
123	Total		Lts	22,500	47,500	60,000
124		3.785	Gal	5,945	12,550	15,852
125
126	Nominal pumping capacity	60	Lts / min	375.0	791.7	1,000.0
127	(not adjusted for pressure head)		Lts / hr	6.3	13.2	16.7
128		3.785	Gal / min	99.1	209.2	264.2
129			Gal / hr	1.7	3.5	4.4
130
131					1	2	3	4	5	6	7	8	9	10	11	12	13
132	Number of fish tanks			1	2	4	6	8	10	12	14	16	18	20	22	24	26
133	Fish tank volume		Lts	10,000.00	5,000	2,500	1,667	1,250	1,000	833	714	625	556	500	455	417	385
134	Min water height		Mts	0.70	0.70	0.70	0.70	0.70	0.70	0.70	0.70	0.70	0.70	0.70	0.70	0.70	0.70
135	Floor contact area		M2	14.29	7.14	3.57	2.38	1.79	1.43	1.19	1.02	0.89	0.79	0.71	0.65	0.60	0.55
136	Side (if perfect sqaure)		Mts	3.78	2.67	1.89	1.54	1.34	1.20	1.09	1.01	0.94	0.89	0.85	0.81	0.77	0.74
137	Circle radius (if circular)		Mts	2.13	1.508	1.07	0.87	0.75	0.67	0.62	0.57	0.53	0.50	0.48	0.45	0.44	0.42
138	Cicle diameter		Mts	4.26	3.016	2.13	1.74	1.51	1.35	1.23	1.14	1.07	1.01	0.95	0.91	0.87	0.84
139
140	Overall system area		Factor	1.0	3.0	4.0
141	Fish tanks		M2	14	7	4
142	Grow beds		M2	33	100	133
143	Subtotal		M2	48	107	137
144	Factor (service, perimeter, etc)			2.00	2.0	2.0
145	Total system area		M2	95	214	274
146		10,000	Hectares	0.01	0.02	0.03
147		4,047	Acres	0.02	0.05	0.07
148	Side (if perfect sqaure)		Mts	9.76	14.64	16.55
149		3.28	Feet	32.02	48.03	54.29


1
2	Proyección Flujo de Caja (000 COP)
3			Unidad	Precio Unit
4	Capacidad tanque peces	10,000	Lts
5	Capacidad vegetales	2,133	Posiciones
6
7	Peces / año	174	Kg	$ 3,500
8	Vegetales / año	12,800	Unidades	$ 1,000
9	Vegetales / año	3,840	Kg
10
11		Año	0	1	2	3	4	5	6	7	8	9	10
12	Ingresos
13	Curva aprendizaje			25%	50%	75%	100%	100%	100%	100%	100%	100%	100%
14	Pesacado			152	304	456	608	608	608	608	608	608	608
15	Hortalizas			3,200	6,400	9,600	12,800	12,800	12,800	12,800	12,800	12,800	12,800
16	Otros Ingresos	$ 10,000		2,500	5,000	7,500	10,000	10,000	10,000	10,000	10,000	10,000	10,000
17	Total Ingresos			5,852	11,704	17,556	23,408	23,408	23,408	23,408	23,408	23,408	23,408
18
19	Costos
20	Costo de ventas - pescado	90%		137	274	410	547	547	547	547	547	547	547
21	Costo de ventas - hortalizas	30%		960	1,920	2,880	3,840	3,840	3,840	3,840	3,840	3,840	3,840
22	Utilidad Bruta			4,755	9,510	14,266	19,021	19,021	19,021	19,021	19,021	19,021	19,021
23
24	Administración y ventas	25%		1,463	2,926	4,389	5,852	5,852	5,852	5,852	5,852	5,852	5,852
25	Depreciación			5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000
26	Utilidad Operacional			(1,708)	1,584	4,877	8,169	8,169	8,169	8,169	8,169	8,169	8,169
27
28	Gastos financieros			1,875	1,641	1,172	703	234	0	0	0	0	0
29	Utilidad antes de Impuestos			(3,583)	(56)	3,705	7,466	7,934	8,169	8,169	8,169	8,169	8,169
30
31	Impuestos	25%		(896)	(14)	926	1,866	1,984	2,042	2,042	2,042	2,042	2,042
32
33	Utilidad Neta			(2,687)	(42)	2,779	5,599	5,951	6,127	6,127	6,127	6,127	6,127
34
35	Inversiones
36	Infraestructura	$ 50,000
37	Depreciación	10		5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000
38
39	Financiación	25%
40	Deuda	12,500
41
42	Amortización	5		1	2	3	4	5	6	7	8	9	10
43	Período de gracia capital	1
44	Capital
45	Saldo inicial		0	12,500	12,500	9,375	6,250	3,125	0	0	0	0	0
46	Aumento		12,500	0	0	0	0	0	0	0	0	0	0
47	Amortización		0	0	3,125	3,125	3,125	3,125	0	0	0	0	0
48	Saldo final		12,500	12,500	9,375	6,250	3,125	0	0	0	0	0	0
49
50	Interés	15%		1,875	1,641	1,172	703	234	0	0	0	0	0
51
52
53	Flujo de Caja Libre
54	Inversiones		(50,000)
55	Utilidad Operacional			(1,708)	1,584	4,877	8,169	8,169	8,169	8,169	8,169	8,169	8,169
56	Depreciación			5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000
57	Impuestos			896	14	(926)	(1,866)	(1,984)	(2,042)	(2,042)	(2,042)	(2,042)	(2,042)
58	Delta WC
59	Flujo de Caja Libre		(50,000)	4,188	6,598	8,950	11,302	11,185	11,127	11,127	11,127	11,127	11,127
60
61	VPN	12.5%	418
62	TIR		12.7%


1
2	Cash Flow Projection (USD)
3			Unit	Unit Price
4	Fish tank volume	10,000	Lts
5	Vegetabe capacity	2,133	Positions
6
7	Fish / year	174	Kg	$2.50
8	Vegetable / year	12,800	Unidades	$1.25
9	Vegetable / year	3,840	Kg
10
11		Año	0	1	2	3	4	5	6	7	8	9	10
12	Revenue
13	Learning curve			25%	50%	75%	100%	100%	100%	100%	100%	100%	100%
14	Fish			109	217	326	434	434	434	434	434	434	434
15	Vegetables			4,000	8,000	12,000	16,000	16,000	16,000	16,000	16,000	16,000	16,000
16	Other Income	$ 10,000		2,500	5,000	7,500	10,000	10,000	10,000	10,000	10,000	10,000	10,000
17	Total Revenues			6,609	13,217	19,826	26,434	26,434	26,434	26,434	26,434	26,434	26,434
18
19	Costos
20	COGS - fish	90%		98	195	293	391	391	391	391	391	391	391
21	COGS - vegetables	30%		1,200	2,400	3,600	4,800	4,800	4,800	4,800	4,800	4,800	4,800
22	Gross Profit			5,311	10,622	15,933	21,243	21,243	21,243	21,243	21,243	21,243	21,243
23
24	SG&A	25%		1,652	3,304	4,956	6,609	6,609	6,609	6,609	6,609	6,609	6,609
25	Depreciation			2,500	2,500	2,500	2,500	2,500	2,500	2,500	2,500	2,500	2,500
26	Operational Profit			1,159	4,817	8,476	12,135	12,135	12,135	12,135	12,135	12,135	12,135
27
28	Interest expense			938	820	586	352	117	0	0	0	0	0
29	EBT			221	3,997	7,890	11,783	12,018	12,135	12,135	12,135	12,135	12,135
30
31	Tax	25%		55	999	1,973	2,946	3,004	3,034	3,034	3,034	3,034	3,034
32
33	Net Profit			166	2,998	5,918	8,837	9,013	9,101	9,101	9,101	9,101	9,101
34
35	CAPEX
36	Infrastructure	$ 25,000
37	Depreciation	10		2,500	2,500	2,500	2,500	2,500	2,500	2,500	2,500	2,500	2,500
38
39	Financing	25%
40	Debt	6,250
41
42	Amortization	5		1	2	3	4	5	6	7	8	9	10
43	Capital grace period	1
44	Capital
45	Beginning Balance		0	6,250	6,250	4,688	3,125	1,563	0	0	0	0	0
46	Increase		6,250	0	0	0	0	0	0	0	0	0	0
47	Amortization		0	0	1,563	1,563	1,563	1,563	0	0	0	0	0
48	Ending Balance		6,250	6,250	4,688	3,125	1,563	0	0	0	0	0	0
49
50	Interest expense	15%		938	820	586	352	117	0	0	0	0	0
51
52
53	Free Cash Flow
54	CAPEX		(25,000)
55	Operational Profit			1,159	4,817	8,476	12,135	12,135	12,135	12,135	12,135	12,135	12,135
56	Depreciation			2,500	2,500	2,500	2,500	2,500	2,500	2,500	2,500	2,500	2,500
57	Tax			(55)	(999)	(1,973)	(2,946)	(3,004)	(3,034)	(3,034)	(3,034)	(3,034)	(3,034)
58	Delta WC
59	Flujo de Caja Libre		(25,000)	3,603	6,318	9,004	11,689	11,630	11,601	11,601	11,601	11,601	11,601
60
61	Net Present Value - NPV	12.5%	23,282
62	Internal Rate of Return - IRR		30.5%