Items Proveedor Catidad Características

Diseño, desarrollo e
implementación solución sitio
web ($650.000), Configuración y
Hosting (2 años)($23.000). Correo
Página web Wiz Comunicaciones SpA 1 y bas de datos ($58.000).

Diptico 21,5 x 28 cm extendidos

21,5 x 14 cerrados. Papel couche
200 gr 4/4 colores, corte recto,
Folletería Procolor 1000 plizados, doblados.

Diptico 21,5 x 28 cm extendidos

21,5 x 14 cerrados. Papel couche
200 gr 4/4 colores, corte recto,
Folletería Procolor 600 plizados, doblados.
Tarjetas de presentación Harry Plotter 300 Kraft 300g
Packaging barra Marinetti 10000 x mes Material biodegradable
cartulina duplex 270 gr, Impresión
Packaging caja La cartonería 1000 x mes 4 colores

Bolsas publicitaris papel kraft, 25

x 11 x 30 (largo, fuelle, alto, cm),
impresión offset a 1 color,
Bolsas Macso 1000 manillas cordon

Primeros 3 meses ‘18: Blog +

Medios pagados digitales +
Gestión Analytics + Lead
Nurturing (25 UF). Siguientes 6
meses ‘18: Idem Anterior + 2
artículos adicionales blog + RRSS
Redes sociales Agencia Cebra 1 (40 UF)
 Valor Total (con IVA)

731000 + IVA $869,890

247 + IVA x unidad $293,930

310 + IVA x unidad $221,340

15990 con IVA x 100 un $47,970
$50 + IVA $500,000

X 1000 $574 + IVA $574,000

347 + IVA x unidad $412,930

65 UF $1,718,340
$4,638,400
$1,074,000
Items Proveedor Catidad

Almendras con piel Alimentos Don Fernando 10 kg

Chía Alimentos Don Fernando 10 kg
Maravilla Alimentos Don Fernando 10 kg
Canela en polvo Avellanuts 1 kg
Goji Avellanuts 1 kg
Maqui deshidratado Avellanuts 1 kg
ACEITE DE COCO Frutos Paz 1 kg
CACAO 100% Frutos Paz 1 kg
CASTAÑA DE CAJU SIN SAL Frutos Paz 1 kg
DATIL SIN CUESCO Frutos Paz 1 kg
JENGIBRE MOLIDO Frutos Paz 1 kg
MANZANA DESHIDRATADA CUBITO Frutos Paz 1 kg
MIEL Frutos Paz 1 kg
NUEZ BLANCA Frutos Paz 1 kg
PEPA DE ZAPALLO Frutos Paz 1 kg
QUINOA INFLADA NATURAL Frutos Paz 1 kg
TE VERDE Frutos Paz 1 kg
ARANDANO Huertos del Chef 1 kg
Spirulina Spirulinamater 1 kg
Limón Huerto Bio 1 kg
Tagatosa Biofoods 1 kg
Azúcar de caña Luki 1 kg
Frutila Huertos del Chef 1 kg
Frambuesa Huertos del Chef 1kg
Naranja Deshidratada 1kg
Vtamina C Casa Naturista 1kg
Chips chocolate Brunelli 1 kg
Características Valor (sin IVA) Total (con IVA) Valor con IVA por gramo
choco (gr) Costo
$ 6,800 $ 8,092 $ 8.1 0 $ -
$ 1,900 $ 2,261 $ 2.3 0 $ -
$ 1,370 $ 1,630 $ 1.6 5 $ 8.2
$ 9,000 $ 9.0 0 $ -
$ 8,000 $ 8.0 0 $ -
$ 16,000 $ 16.0 0 $ -
$ 13,000 $ 13.0 3 $ 39.0
$ 10,000 $ 10.0 2 $ 20.0
$ 14,800 $ 14.8 6 $ 88.8
$ 6,000 $ 6.0 0 $ -
$ 6,000 $ 6.0 0 $ -
$ 4,800 $ 4.8 0 $ -
$ 2,200 $ 2.2 0 $ -
$ 8,500 $ 8.5 0 $ -
$ 600 $ 0.6 0 $ -
$ 7,500 $ 7.5 10 $ 75.0
$ 4,200 $ 4.2 0 $ -
$ 3,460 $ 3.5 0 $ -
$ 46,980 $ 47.0 1 $ 47.0
$ 1,350 $ 1.4 0 $ -
$ 13,980 $ 14.0 0 $ -
$ 2,290 $ 2.3 1 $ 2.3
$ 2,650 $ 2.7 0 $ -
$ 3,800 $ 3.8 0 $ -
$ 10,000 $ 10.0 4 $ 40.0
$ 116,000 $ 116.0 0 $ -
$ 10,500 $ 10.5 3 $ 31.5
35 $ 352
Rojos Costo Manzana Costo Limón Costo
6 $ 48.6 0 $ - 0 $ -
0 $ - 0 $ - 6 $ 13.6
0 $ - 0 $ - 0 $ -
0 $ - 1 $ 9.0 0 $ -
3$ 24.0 0 $ - 0 $ -
0 $ - 6 $ 96.0 0 $ -
3 $ 39.0 3 $ 39.0 3 $ 39.0
0 $ - 0 $ - 0 $ -
0 $ - 0 $ - 0 $ -
3 $ 18.0 0 $ - 0 $ -
0 $ - 0 $ - 1 $ 6.0
0 $ - 7 $ 33.6 0 $ -
0 $ - 0 $ - 4 $ 8.8
0 $ - 6 $ 51.0 0 $ -
0 $ - 0 $ - 5 $ 3.0
10 $ 75.0 10 $ 75.0 10 $ 75.0
0 $ - 0 $ - 1 $ 4.2
3 $ 10.4 0 $ - 0 $ -
1 $ 47.0 1 $ 47.0 1 $ 47.0
0 $ - 0 $ - 3 $ 4.1
0 $ - 1 $ 14.0 0 $ -
0 $ - 0 $ - 0 $ -
3 $ 8.0 0 $ - 0 $ -
3 $ 11.4 0 $ - 0 $ -
0 $ - 0 $ - 0 $ -
0 $ - 0 $ - 1 $ 116.0
0 $ - 0 $ - 0 $ -
35 $ 281 35 $ 365 35 $ 317 $ 329
Ingresos Valor Nota
Precio de Venta P1 1,190 precio por unidad
Precio de Venta P2 6,090 precio por unidad
Precio de Venta P3 14,990 precio por unidad
Crecimiento primeros 24 meses 2.0% tasa mensual
Crecimiento posterior a los 24 meses 1.0% tasa mensual

Costos variables Valor Nota

Insumos P1 329 costo por unidad
Insumos P2 1,974 costo por unidad
Insumos P3 5,922 costo por unidad
Costo Transporte 500 costo por caja
Sistema de pago 12,944 cargo fijo
Sistema de pago 2.14% tasa sobre venta P3
Maquilado y packing P1 100 costo por unidad
Maquilado y packing P2 750 costo por unidad
Maquilado y packing P3 2,250 costo por unidad
Sueldo Variable 0.40% porcentaje sobre la venta neta
Bolsas 60 pesos por bolsa
Otros 50 costo por caja

Costos Fijos Valor Nota

Gastos Generales 100,000 costo mensual
Arriendo 400,000 costo mensual
Asesorías 150,000 costo mensual
Sueldos 8,340,000 costo mensual
RRSS 700,000 costo mensual
Landing page y Adwords 595,000 costo mensual

Plan de Inversiones Valor Nota

Constitución de la empresa 500,000 1 única vez
Página Web 869,890 1 única vez
Acreditación sanitaria 500,000 1 única vez
Notebook 1,500,000 2 equipos
 7,212 5,800 24%
9,146 7,212 27%
10,306 9,146 13%
 Ítem Mes 1 Mes 2 Mes 3
Cantidad Vendida
Cantidad vendida Producto 1 4,000 4,080 4,162
Cantidad vendida Producto 2 1,600 1,632 1,665
Cantidad vendida Producto 3 200 204 208
Ingresos 17,502,000 17,852,040 18,209,081
Venta Producto 1 4,760,000 4,855,200 4,952,304
Venta Producto 2 9,744,000 9,938,880 10,137,658
Venta Producto 3 2,998,000 3,057,960 3,119,119

Costos variables 9,212,584 9,396,577 9,584,249

Insumos P1 1,316,000 1,342,320 1,369,166
Insumos P2 3,158,400 3,221,568 3,285,999
Insumos P3 1,184,400 1,208,088 1,232,250
Costo Transporte 1,233,333 1,258,000 1,283,160
Sistema de pago 77,101 78,384 79,693
Proveedores maquilado y packing P1 400,000 408,000 416,160
Proveedores maquilado y packing P2 1,200,000 1,224,000 1,248,480
Proveedores maquilado y packing P3 450,000 459,000 468,180
Sueldo Variable 58,016 59,176 60,360
Bolsas 12,000 12,240 12,485
Otros 123,333 125,800 128,316

Costos Fijos 10,285,000 10,285,000 10,285,000

Gastos Generales 100,000 100,000 100,000
Arriendo 400,000 400,000 400,000
Asesorías 150,000 150,000 150,000
Sueldos 8,340,000 8,340,000 8,340,000
RRSS 700,000 700,000 700,000
Landing page y Adwords 595,000 595,000 595,000

Ingreso Total 17,502,000 17,852,040 18,209,081

Costo Total 19,497,584 19,681,577 19,869,249
Beneficios Totales -1,995,584 -1,829,537 -1,660,169
Beneficios Totales acumulados -1,995,584 -3,825,121 -5,485,289

Capital de trabajo -12,248,326

Mes 4 Mes 5 Mes 6 Mes 7 Mes 8

4,245 4,330 4,416 4,505 4,595

1,698 1,732 1,767 1,802 1,838
212 216 221 225 230
18,573,262 18,944,728 19,323,622 19,710,095 20,104,297
5,051,350 5,152,377 5,255,425 5,360,533 5,467,744
10,340,411 10,547,219 10,758,163 10,973,327 11,192,793
3,181,502 3,245,132 3,310,034 3,376,235 3,443,760

9,775,675 9,970,930 10,170,090 10,373,233 10,580,438

1,396,550 1,424,481 1,452,970 1,482,030 1,511,670
3,351,719 3,418,754 3,487,129 3,556,871 3,628,009
1,256,895 1,282,033 1,307,673 1,333,827 1,360,503
1,308,823 1,335,000 1,361,700 1,388,934 1,416,712
81,028 82,390 83,779 85,195 86,640
424,483 432,973 441,632 450,465 459,474
1,273,450 1,298,919 1,324,897 1,351,395 1,378,423
477,544 487,094 496,836 506,773 516,909
61,567 62,798 64,054 65,335 66,642
12,734 12,989 13,249 13,514 13,784
130,882 133,500 136,170 138,893 141,671

10,285,000 10,285,000 10,285,000 10,285,000 10,285,000

100,000 100,000 100,000 100,000 100,000
400,000 400,000 400,000 400,000 400,000
150,000 150,000 150,000 150,000 150,000
8,340,000 8,340,000 8,340,000 8,340,000 8,340,000
700,000 700,000 700,000 700,000 700,000
595,000 595,000 595,000 595,000 595,000

18,573,262 18,944,728 19,323,622 19,710,095 20,104,297

20,060,675 20,255,930 20,455,090 20,658,233 20,865,438
-1,487,413 -1,311,202 -1,131,468 -948,138 -761,142
-6,972,702 -8,283,904 -9,415,372 -10,363,510 -11,124,652
Mes 9 Mes 10 Mes 11 Mes 12 Mes 13

4,687 4,780 4,876 4,973 5,073

1,875 1,912 1,950 1,989 2,029
234 239 244 249 254
20,506,382 20,916,510 21,334,840 21,761,537 22,196,768
5,577,099 5,688,641 5,802,413 5,918,462 6,036,831
11,416,649 11,644,982 11,877,882 12,115,439 12,357,748
3,512,635 3,582,888 3,654,545 3,727,636 3,802,189

10,791,788 11,007,365 11,227,254 11,451,540 11,680,312

1,541,904 1,572,742 1,604,197 1,636,281 1,669,006
3,700,569 3,774,580 3,850,072 3,927,073 4,005,615
1,387,713 1,415,468 1,443,777 1,472,653 1,502,106
1,445,047 1,473,948 1,503,426 1,533,495 1,564,165
88,114 89,618 91,151 92,715 94,311
468,664 478,037 487,598 497,350 507,297
1,405,991 1,434,111 1,462,793 1,492,049 1,521,890
527,247 537,792 548,547 559,518 570,709
67,975 69,334 70,721 72,136 73,578
14,060 14,341 14,628 14,920 15,219
144,505 147,395 150,343 153,349 156,416

10,285,000 10,285,000 10,285,000 10,285,000 10,285,000

100,000 100,000 100,000 100,000 100,000
400,000 400,000 400,000 400,000 400,000
150,000 150,000 150,000 150,000 150,000
8,340,000 8,340,000 8,340,000 8,340,000 8,340,000
700,000 700,000 700,000 700,000 700,000
595,000 595,000 595,000 595,000 595,000

20,506,382 20,916,510 21,334,840 21,761,537 22,196,768

21,076,788 21,292,365 21,512,254 21,736,540 21,965,312
-570,406 -375,855 -177,413 24,997 231,456
-11,695,058 -12,070,913 -12,248,326 -12,223,329 -11,991,873
Mes 14 Mes 15 Mes 16 Mes 17 Mes 18

5,174 5,278 5,383 5,491 5,601

2,070 2,111 2,153 2,196 2,240
259 264 269 275 280
22,640,703 23,093,517 23,555,388 24,026,495 24,507,025
6,157,568 6,280,719 6,406,333 6,534,460 6,665,149
12,604,903 12,857,001 13,114,141 13,376,424 13,643,952
3,878,233 3,955,797 4,034,913 4,115,612 4,197,924

11,913,659 12,151,673 12,394,448 12,642,078 12,894,661

1,702,386 1,736,434 1,771,163 1,806,586 1,842,718
4,085,727 4,167,442 4,250,791 4,335,806 4,422,522
1,532,148 1,562,791 1,594,046 1,625,927 1,658,446
1,595,448 1,627,357 1,659,904 1,693,102 1,726,964
95,938 97,598 99,291 101,018 102,780
517,443 527,792 538,347 549,114 560,097
1,552,328 1,583,375 1,615,042 1,647,343 1,680,290
582,123 593,765 605,641 617,754 630,109
75,050 76,551 78,082 79,644 81,236
15,523 15,834 16,150 16,473 16,803
159,545 162,736 165,990 169,310 172,696

10,285,000 10,285,000 10,285,000 10,285,000 10,285,000

100,000 100,000 100,000 100,000 100,000
400,000 400,000 400,000 400,000 400,000
150,000 150,000 150,000 150,000 150,000
8,340,000 8,340,000 8,340,000 8,340,000 8,340,000
700,000 700,000 700,000 700,000 700,000
595,000 595,000 595,000 595,000 595,000

22,640,703 23,093,517 23,555,388 24,026,495 24,507,025

22,198,659 22,436,673 22,679,448 22,927,078 23,179,661
442,044 656,844 875,940 1,099,417 1,327,365
-11,549,829 -10,892,985 -10,017,045 -8,917,628 -7,590,263
Mes 19 Mes 20 Mes 21 Mes 22 Mes 23

5,713 5,827 5,944 6,063 6,184

2,285 2,331 2,378 2,425 2,474
286 291 297 303 309
24,997,166 25,497,109 26,007,051 26,527,192 27,057,736
6,798,452 6,934,421 7,073,110 7,214,572 7,358,863
13,916,831 14,195,168 14,479,071 14,768,653 15,064,026
4,281,882 4,367,520 4,454,870 4,543,968 4,634,847

13,152,295 13,415,082 13,683,125 13,956,529 14,235,400

1,879,572 1,917,164 1,955,507 1,994,617 2,034,509
4,510,973 4,601,192 4,693,216 4,787,081 4,882,822
1,691,615 1,725,447 1,759,956 1,795,155 1,831,058
1,761,504 1,796,734 1,832,668 1,869,322 1,906,708
104,576 106,409 108,278 110,185 112,130
571,298 582,724 594,379 606,267 618,392
1,713,895 1,748,173 1,783,137 1,818,800 1,855,176
642,711 655,565 668,676 682,050 695,691
82,861 84,518 86,209 87,933 89,692
17,139 17,482 17,831 18,188 18,552
176,150 179,673 183,267 186,932 190,671

10,285,000 10,285,000 10,285,000 10,285,000 10,285,000

100,000 100,000 100,000 100,000 100,000
400,000 400,000 400,000 400,000 400,000
150,000 150,000 150,000 150,000 150,000
8,340,000 8,340,000 8,340,000 8,340,000 8,340,000
700,000 700,000 700,000 700,000 700,000
595,000 595,000 595,000 595,000 595,000

24,997,166 25,497,109 26,007,051 26,527,192 27,057,736

23,437,295 23,700,082 23,968,125 24,241,529 24,520,400
1,559,871 1,797,027 2,038,926 2,285,664 2,537,336
-6,030,393 -4,233,366 -2,194,439 91,225 2,628,561
Mes 24 Mes 25 Mes 26 Mes 27 Mes 28

6,308 6,371 6,434 6,499 6,564

2,523 2,548 2,574 2,599 2,625
315 319 322 325 328
27,598,891 27,874,880 28,153,629 28,435,165 28,719,517
7,506,040 7,581,101 7,656,912 7,733,481 7,810,816
15,365,306 15,518,959 15,674,149 15,830,891 15,989,199
4,727,544 4,774,819 4,822,568 4,870,793 4,919,501

14,519,849 14,664,918 14,811,438 14,959,423 15,108,888

2,075,199 2,095,951 2,116,911 2,138,080 2,159,461
4,980,479 5,030,283 5,080,586 5,131,392 5,182,706
1,867,679 1,886,356 1,905,220 1,924,272 1,943,515
1,944,842 1,964,291 1,983,934 2,003,773 2,023,811
114,113 115,125 116,147 117,179 118,221
630,760 637,067 643,438 649,872 656,371
1,892,279 1,911,202 1,930,314 1,949,617 1,969,113
709,605 716,701 723,868 731,106 738,417
91,485 92,400 93,324 94,257 95,200
18,923 19,112 19,303 19,496 19,691
194,484 196,429 198,393 200,377 202,381

10,285,000 10,285,000 10,285,000 10,285,000 10,285,000

100,000 100,000 100,000 100,000 100,000
400,000 400,000 400,000 400,000 400,000
150,000 150,000 150,000 150,000 150,000
8,340,000 8,340,000 8,340,000 8,340,000 8,340,000
700,000 700,000 700,000 700,000 700,000
595,000 595,000 595,000 595,000 595,000

27,598,891 27,874,880 28,153,629 28,435,165 28,719,517

24,804,849 24,949,918 25,096,438 25,244,423 25,393,888
2,794,042 2,924,961 3,057,190 3,190,742 3,325,629
5,422,602 8,347,564 11,404,754 14,595,496 17,921,125
Mes 29 Mes 30 Mes 31 Mes 32 Mes 33

6,629 6,696 6,763 6,830 6,899

2,652 2,678 2,705 2,732 2,759
331 335 338 342 345
29,006,712 29,296,779 29,589,747 29,885,644 30,184,501
7,888,924 7,967,813 8,047,491 8,127,966 8,209,246
16,149,091 16,310,582 16,473,688 16,638,425 16,804,809
4,968,696 5,018,383 5,068,567 5,119,253 5,170,445

15,259,847 15,412,316 15,566,310 15,721,844 15,878,933

2,181,055 2,202,866 2,224,895 2,247,144 2,269,615
5,234,533 5,286,878 5,339,747 5,393,145 5,447,076
1,962,950 1,982,579 2,002,405 2,022,429 2,042,654
2,044,049 2,064,489 2,085,134 2,105,986 2,127,046
119,274 120,337 121,411 122,496 123,592
662,935 669,564 676,260 683,022 689,853
1,988,804 2,008,692 2,028,779 2,049,067 2,069,558
745,802 753,260 760,792 768,400 776,084
96,152 97,114 98,085 99,066 100,056
19,888 20,087 20,288 20,491 20,696
204,405 206,449 208,513 210,599 212,705

10,285,000 10,285,000 10,285,000 10,285,000 10,285,000

100,000 100,000 100,000 100,000 100,000
400,000 400,000 400,000 400,000 400,000
150,000 150,000 150,000 150,000 150,000
8,340,000 8,340,000 8,340,000 8,340,000 8,340,000
700,000 700,000 700,000 700,000 700,000
595,000 595,000 595,000 595,000 595,000

29,006,712 29,296,779 29,589,747 29,885,644 30,184,501

25,544,847 25,697,316 25,851,310 26,006,844 26,163,933
3,461,864 3,599,463 3,738,437 3,878,800 4,020,568
21,382,989 24,982,452 28,720,888 32,599,689 36,620,256
Mes 34 Mes 35 Mes 36 Mes 37 Mes 38

6,968 7,037 7,108 7,179 7,250

2,787 2,815 2,843 2,871 2,900
348 352 355 359 363
30,486,346 30,791,209 31,099,121 31,410,112 31,724,213
8,291,338 8,374,252 8,457,994 8,542,574 8,628,000
16,972,857 17,142,586 17,314,012 17,487,152 17,662,024
5,222,150 5,274,371 5,327,115 5,380,386 5,434,190

16,037,593 16,197,839 16,359,688 16,523,155 16,688,258

2,292,311 2,315,234 2,338,387 2,361,771 2,385,388
5,501,547 5,556,562 5,612,128 5,668,249 5,724,932
2,063,080 2,083,711 2,104,548 2,125,593 2,146,849
2,148,316 2,169,799 2,191,497 2,213,412 2,235,546
124,698 125,816 126,944 128,084 129,236
696,751 703,719 710,756 717,863 725,042
2,090,253 2,111,156 2,132,267 2,153,590 2,175,126
783,845 791,683 799,600 807,596 815,672
101,057 102,067 103,088 104,119 105,160
20,903 21,112 21,323 21,536 21,751
214,832 216,980 219,150 221,341 223,555

10,285,000 10,285,000 10,285,000 10,285,000 10,285,000

100,000 100,000 100,000 100,000 100,000
400,000 400,000 400,000 400,000 400,000
150,000 150,000 150,000 150,000 150,000
8,340,000 8,340,000 8,340,000 8,340,000 8,340,000
700,000 700,000 700,000 700,000 700,000
595,000 595,000 595,000 595,000 595,000

30,486,346 30,791,209 31,099,121 31,410,112 31,724,213

26,322,593 26,482,839 26,644,688 26,808,155 26,973,258
4,163,753 4,308,370 4,454,433 4,601,957 4,750,956
40,784,009 45,092,379 49,546,812 54,148,769 58,899,725
Mes 39 Mes 40 Mes 41 Mes 42 Mes 43

7,323 7,396 7,470 7,545 7,620

2,929 2,958 2,988 3,018 3,048
366 370 374 377 381
32,041,456 32,361,870 32,685,489 33,012,344 33,342,467
8,714,280 8,801,423 8,889,437 8,978,331 9,068,115
17,838,644 18,017,030 18,197,200 18,379,172 18,562,964
5,488,532 5,543,417 5,598,851 5,654,840 5,711,388

16,855,011 17,023,431 17,193,536 17,365,342 17,538,866

2,409,242 2,433,335 2,457,668 2,482,245 2,507,067
5,782,181 5,840,003 5,898,403 5,957,387 6,016,961
2,168,318 2,190,001 2,211,901 2,234,020 2,256,360
2,257,902 2,280,481 2,303,286 2,326,318 2,349,582
130,399 131,573 132,759 133,958 135,168
732,292 739,615 747,012 754,482 762,026
2,196,877 2,218,846 2,241,035 2,263,445 2,286,079
823,829 832,067 840,388 848,792 857,280
106,212 107,274 108,347 109,430 110,524
21,969 22,188 22,410 22,634 22,861
225,790 228,048 230,329 232,632 234,958

10,285,000 10,285,000 10,285,000 10,285,000 10,285,000

100,000 100,000 100,000 100,000 100,000
400,000 400,000 400,000 400,000 400,000
150,000 150,000 150,000 150,000 150,000
8,340,000 8,340,000 8,340,000 8,340,000 8,340,000
700,000 700,000 700,000 700,000 700,000
595,000 595,000 595,000 595,000 595,000

32,041,456 32,361,870 32,685,489 33,012,344 33,342,467

27,140,011 27,308,431 27,478,536 27,650,342 27,823,866
4,901,445 5,053,439 5,206,953 5,362,002 5,518,601
63,801,170 68,854,608 74,061,561 79,423,563 84,942,164
Mes 44 Mes 45 Mes 46 Mes 47 Mes 48

7,696 7,773 7,851 7,930 8,009

3,079 3,109 3,140 3,172 3,204
385 389 393 396 400
33,675,892 34,012,651 34,352,777 34,696,305 35,043,268
9,158,796 9,250,384 9,342,888 9,436,317 9,530,680
18,748,594 18,936,080 19,125,441 19,316,695 19,509,862
5,768,502 5,826,187 5,884,449 5,943,293 6,002,726

17,714,125 17,891,137 18,069,919 18,250,489 18,432,864

2,532,138 2,557,459 2,583,034 2,608,864 2,634,953
6,077,130 6,137,902 6,199,281 6,261,274 6,323,886
2,278,924 2,301,713 2,324,730 2,347,978 2,371,457
2,373,077 2,396,808 2,420,776 2,444,984 2,469,434
136,390 137,624 138,871 140,130 141,402
769,647 777,343 785,117 792,968 800,897
2,308,940 2,332,030 2,355,350 2,378,903 2,402,692
865,853 874,511 883,256 892,089 901,010
111,630 112,746 113,873 115,012 116,162
23,089 23,320 23,553 23,789 24,027
237,308 239,681 242,078 244,498 246,943

10,285,000 10,285,000 10,285,000 10,285,000 10,285,000

100,000 100,000 100,000 100,000 100,000
400,000 400,000 400,000 400,000 400,000
150,000 150,000 150,000 150,000 150,000
8,340,000 8,340,000 8,340,000 8,340,000 8,340,000
700,000 700,000 700,000 700,000 700,000
595,000 595,000 595,000 595,000 595,000

33,675,892 34,012,651 34,352,777 34,696,305 35,043,268

27,999,125 28,176,137 28,354,919 28,535,489 28,717,864
5,676,766 5,836,514 5,997,858 6,160,816 6,325,404
90,618,930 96,455,443 102,453,302 108,614,118 114,939,521
Mes 49 Mes 50 Mes 51 Mes 52 Mes 53

8,089 8,170 8,252 8,334 8,418

3,236 3,268 3,301 3,334 3,367
404 408 413 417 421
35,393,701 35,747,638 36,105,114 36,466,165 36,830,827
9,625,986 9,722,246 9,819,469 9,917,664 10,016,840
19,704,961 19,902,010 20,101,030 20,302,041 20,505,061
6,062,754 6,123,381 6,184,615 6,246,461 6,308,926

18,617,064 18,803,105 18,991,006 19,180,787 19,372,465

2,661,302 2,687,915 2,714,794 2,741,942 2,769,362
6,387,125 6,450,996 6,515,506 6,580,661 6,646,468
2,395,172 2,419,124 2,443,315 2,467,748 2,492,426
2,494,128 2,519,069 2,544,260 2,569,703 2,595,400
142,687 143,984 145,295 146,618 147,955
808,906 816,995 825,165 833,417 841,751
2,426,719 2,450,986 2,475,496 2,500,251 2,525,254
910,020 919,120 928,311 937,594 946,970
117,324 118,497 119,682 120,879 122,088
24,267 24,510 24,755 25,003 25,253
249,413 251,907 254,426 256,970 259,540

10,285,000 10,285,000 10,285,000 10,285,000 10,285,000

100,000 100,000 100,000 100,000 100,000
400,000 400,000 400,000 400,000 400,000
150,000 150,000 150,000 150,000 150,000
8,340,000 8,340,000 8,340,000 8,340,000 8,340,000
700,000 700,000 700,000 700,000 700,000
595,000 595,000 595,000 595,000 595,000

35,393,701 35,747,638 36,105,114 36,466,165 36,830,827

28,902,064 29,088,105 29,276,006 29,465,787 29,657,465
6,491,637 6,659,533 6,829,108 7,000,378 7,173,362
121,431,159 128,090,692 134,919,799 141,920,178 149,093,539
Mes 54 Mes 55 Mes 56 Mes 57 Mes 58

8,502 8,587 8,673 8,759 8,847

3,401 3,435 3,469 3,504 3,539
425 429 434 438 442
37,199,135 37,571,127 37,946,838 38,326,306 38,709,569
10,117,009 10,218,179 10,320,360 10,423,564 10,527,800
20,710,112 20,917,213 21,126,385 21,337,649 21,551,025
6,372,015 6,435,735 6,500,093 6,565,093 6,630,744

19,566,061 19,761,592 19,959,078 20,158,540 20,359,996

2,797,055 2,825,026 2,853,276 2,881,809 2,910,627
6,712,933 6,780,062 6,847,863 6,916,341 6,985,505
2,517,350 2,542,523 2,567,949 2,593,628 2,619,564
2,621,354 2,647,567 2,674,043 2,700,783 2,727,791
149,305 150,669 152,046 153,437 154,842
850,169 858,670 867,257 875,930 884,689
2,550,506 2,576,011 2,601,772 2,627,789 2,654,067
956,440 966,004 975,664 985,421 995,275
123,308 124,542 125,787 127,045 128,315
25,505 25,760 26,018 26,278 26,541
262,135 264,757 267,404 270,078 272,779

10,285,000 10,285,000 10,285,000 10,285,000 10,285,000

100,000 100,000 100,000 100,000 100,000
400,000 400,000 400,000 400,000 400,000
150,000 150,000 150,000 150,000 150,000
8,340,000 8,340,000 8,340,000 8,340,000 8,340,000
700,000 700,000 700,000 700,000 700,000
595,000 595,000 595,000 595,000 595,000

37,199,135 37,571,127 37,946,838 38,326,306 38,709,569

29,851,061 30,046,592 30,244,078 30,443,540 30,644,996
7,348,075 7,524,535 7,702,760 7,882,767 8,064,574
156,441,614 163,966,148 171,668,908 179,551,675 187,616,248
Mes 59 Mes 60

8,935 9,025
3,574 3,610
447 451
39,096,665 39,487,632
10,633,078 10,739,408
21,766,535 21,984,201
6,697,052 6,764,022

20,563,466 20,768,971
2,939,733 2,969,131
7,055,360 7,125,913
2,645,760 2,672,218
2,755,069 2,782,620
156,261 157,694
893,536 902,471
2,680,608 2,707,414
1,005,228 1,015,280
129,598 130,894
26,806 27,074
275,507 278,262

10,285,000 10,285,000
100,000 100,000
400,000 400,000
150,000 150,000
8,340,000 8,340,000
700,000 700,000
595,000 595,000

39,096,665 39,487,632
30,848,466 31,053,971
8,248,199 8,433,660
195,864,447 204,298,107
 Año 0 Año 1 Año 2
Ingresos - 234,738,394 297,705,043
Venta Producto 1 63,841,547 80,966,518
Venta Producto 2 130,687,402 165,743,226
Venta Producto 3 40,209,445 50,995,299
Financiamiento 15,618,216

Costos variables 123,541,723 156,639,111

Insumos P1 17,650,310 22,384,861
Insumos P2 42,360,744 53,723,666
Insumos P3 15,885,279 20,146,375
Costo Transporte 16,541,577 20,978,720
Sistema de pago 1,015,810 1,246,627
Proveedores maquilado y packing P1 5,364,836 6,803,909
Proveedores maquilado y packing P2 16,094,508 20,411,727
Proveedores maquilado y packing P3 6,035,440 7,654,398
Sueldo Variable 778,116 986,839
Bolsas 160,945 204,117
Otros 1,654,158 2,097,872

Costos Fijos 123,420,000 123,420,000

Gastos Generales 1,200,000 1,200,000
Arriendo 4,800,000 4,800,000
Asesorías 1,800,000 1,800,000
Sueldos 100,080,000 100,080,000
RRSS 8,400,000 8,400,000
Landing page y Adwords 7,140,000 7,140,000

Intereses Financiamiento - 1,346,323

Utilidad antes de Impuestos -12,223,329 16,299,608

Impuesto (25%) - 4,074,902
Utilidad despues de Impuestos -12,223,329 12,224,706

Inversiones 15,618,216 - -
Constitución de la empresa 500,000
Página Web 869,890
Acreditación sanitaria 500,000
Notebook 1,500,000
Capital de trabajo 12,248,326
Amortizacion Crédito 3,435,350

Recuperación del Capital de Trabajo

Valor residual

Flujo anual -15,618,216 -12,223,329 8,789,357

Flujo acumulado -15,618,216 -27,841,545 -19,052,188

Tasa de Dcto 10.00%

VAN 78,667,475
TIR 62%
 Año 3 Año 4 Año 5
353,523,247 398,358,844 448,880,716
96,147,335 108,341,224 122,081,603
196,819,251 221,780,858 249,908,222
60,556,662 68,236,762 76,890,892

185,979,037 209,546,135 236,102,130

26,581,910 29,953,162 33,751,973
63,796,585 71,887,588 81,004,734
23,923,719 26,957,846 30,376,775
24,912,125 28,071,606 31,631,788
1,451,241 1,615,595 1,800,793
8,079,608 9,104,305 10,258,958
24,238,824 27,312,914 30,776,875
9,089,559 10,242,343 11,541,328
1,171,866 1,320,488 1,487,959
242,388 273,129 307,769
2,491,212 2,807,161 3,163,179

123,420,000 123,420,000 123,420,000

1,200,000 1,200,000 1,200,000
4,800,000 4,800,000 4,800,000
1,800,000 1,800,000 1,800,000
100,080,000 100,080,000 100,080,000
8,400,000 8,400,000 8,400,000
7,140,000 7,140,000 7,140,000

1,050,829 729,918 381,403

43,073,381 64,662,791 88,977,183

10,768,345 16,165,698 22,244,296
32,305,036 48,497,093 66,732,887

- - -

3,730,843 4,051,754 4,400,269

12,248,326
 -

28,574,193 44,445,339 74,580,944

9,522,004 53,967,343 128,548,288
CLASIFICACIÓN REUTERS BUSINESS

TRBC classifies the primary business activity of over 72,000 listed companies from 130 countries into a five level hierarchy.
Dedicated, local language speaking analysts utilize company filings, Reuters news and Thomson Reuters corporate actions
http://thomsonreuters.com/business-classification/

Beta Sectorial
Promedio Beta apalancado
COMPONENTES
#N/A
DESCARTADO (DISCARTED)
ACTIVO (ACTIVE)
ENTRADA VACÍA (EMPTY INPUT)

Fuentes de datos primarios:

ÍNDICE

FILTRO (COPIA)

TRBC Economic Sector

Basic Materials
Basic Materials
Basic Materials
Basic Materials
Basic Materials
Basic Materials
Total Basic Materials
Cyclical Consumer Goods & Services
Cyclical Consumer Goods & Services
Cyclical Consumer Goods & Services
Total Cyclical Consumer Goods & Services
Energy
Energy
Total Energy
Financials
Financials
Financials
Financials
Financials
Financials
Total Financials
 Industrials
Industrials
Industrials
Industrials
Industrials
Industrials
Total Industrials
Non-Cyclical Consumer Goods & Services
Non-Cyclical Consumer Goods & Services
Total Non-Cyclical Consumer Goods & Services
Utilities
Utilities
Utilities
Total Utilities
Telecommunications Services
Telecommunications Services
Total Telecommunications Services
Healthcare
Healthcare
Total Healthcare
Technology
Technology
Total Technology
ctivity of over 72,000 listed companies from 130 countries into a five level hierarchy.
nalysts utilize company filings, Reuters news and Thomson Reuters corporate actions services in order to assign and maintain a company
-classification/

Promedio simple de las Betas desapalancadas

Promedio simple de las Betas apalancadas
Número de empresas que se utilizan para el cáculo
Acciones que no fueron cáculadas por falta de datos
Los Betas menores a 0,05 y mayores a 5 no se consideran para el cálculo de promedio de los Betas para los sectores
Empresas consideradas para cálcular el Beta por sector
Entrada vacía

Thomson Reuters

.IPSA IPSA Index

ACTIVO (ACTIVE)

TRBC Business Sector Code TRBC Industry Group Code

Mineral Resources Metals & Mining

Total Mineral Resources
Chemicals Chemicals
Total Chemicals
Applied Resources Paper & Forest Products
Total Applied Resources

Retailers Diversified Retail

Retailers Specialty Retailers
Total Retailers

Energy Oil & Gas

Total Energy

Banking & Investment Services Banking Services

Total Banking & Investment Services
Real Estate Real Estate Operations
Total Real Estate
Investment Trusts Investment Trusts
Total Investment Trusts
 Transportation Marine Services
Total Transportation
Industrial Conglomerates Industrial Conglomerates
Total Industrial Conglomerates
Industrial Services Construction & Engineering
Total Industrial Services

Food & Beverages Beverages

Total Food & Beverages

Utilities Electric Utilities

Utilities Water & Other Utilities
Total Utilities

Telecommunications Services Telecommunications Services

Total Telecommunications Services

Pharmaceuticals & Medical Research Pharmaceuticals

Total Pharmaceuticals & Medical Research

Software & IT Services Software & IT Services

Total Software & IT Services
assign and maintain a company's activity.

Betas para los sectores

b bo
Promedio de BETA
apalancado BETA SECTORIAL ACTUALIZACIÓN COMPONENTES

1.47 1.46 2/6/2015 1

1.47 1.46 2/6/2015 1
1.08 1.08 2/6/2015 1
1.08 1.08 2/6/2015 1
1.21 1.20 2/6/2015 1
1.21 1.20 2/6/2015 1
1.25 1.25 2/6/2015 3
1.14 0.55 2/6/2015 4
0.67 0.65 2/6/2015 1
1.04 0.57 2/6/2015 5
1.04 0.57 2/6/2015 5
1.05 1.05 2/6/2015 2
1.05 1.05 2/6/2015 2
1.05 1.05 2/6/2015 2
0.92 0.15 2/6/2015 5
0.92 0.15 2/6/2015 5
1.01 0.51 2/6/2015 2
1.01 0.51 2/6/2015 2
0.42 0.06 2/6/2015 1
0.42 0.06 2/6/2015 1
0.88 0.23 2/6/2015 8
0.43 0.43 2/6/2015 1
0.43 0.43 2/6/2015 1
0.82 0.81 2/6/2015 1
0.82 0.81 2/6/2015 1
1.13 0.31 2/6/2015 2
1.13 0.31 2/6/2015 2
0.88 0.46 2/6/2015 4
0.59 0.37 2/6/2015 4
0.59 0.37 2/6/2015 4
0.59 0.37 2/6/2015 4
0.84 0.72 2/6/2015 5
0.46 0.28 2/6/2015 2
0.73 0.59 2/6/2015 7
0.73 0.59 2/6/2015 7
0.68 0.31 2/6/2015 1
0.68 0.31 2/6/2015 1
0.68 0.31 2/6/2015 1
0.51 0.51 2/6/2015 1
0.51 0.51 2/6/2015 1
0.51 0.51 2/6/2015 1
0.88 0.77 2/6/2015 1
0.88 0.77 2/6/2015 1
0.88 0.77 2/6/2015 1
Instrucciones
Unicamente se deben sumistrar los datos de las celdas resaltadas en color amarillo. Todo lo demás se obtiene

Valor del consumo (o del prestamo) $ 15,618,216

Cuotas mensuales de plazo concedidas: 48
Diferido 12
Tasa de interés mensual: 0.69%
Valor cuota mensual (s/dif) $ 383,342
Valor cuota mensual (c/dif) $ 398,473

Valor cuota
Cuota No mensual
Normal

1 383,342
2 383,342
3 383,342
4 383,342
5 383,342
6 383,342
7 383,342
8 383,342
9 383,342
10 383,342
11 383,342
12 383,342
13 383,342
14 383,342
15 383,342
16 383,342
17 383,342
18 383,342
19 383,342
20 383,342
21 383,342
22 383,342
23 383,342
24 383,342
25 383,342
26 383,342
27 383,342
28 383,342
29 383,342
30 383,342
31 383,342
32 383,342
33 383,342
 34 383,342
35 383,342
36 383,342
37 383,342
38 383,342
39 383,342
40 383,342
41 383,342
42 383,342
43 383,342
44 383,342
45 383,342
46 383,342
47 383,342
48 383,342
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0
crédito cancelado 0

Totales pagados 18,400,434

das en color amarillo. Todo lo demás se obtiene en forma automática

$ 15,618,216
60

0.7%
18,400,434 $ 318,778 19,126,689

Parte de la Parte de la Saldo del crédito

cuota que se cuota que se (capital) Valor interes
convierte en convierte en después Diferido
abono a abono a del pago (lineal)
capital intereses
15,618,216
275,577 107,766 15,342,639 15,130
277,478 105,864 15,065,161 15,130
279,393 103,950 14,785,768 15,130
281,321 102,022 14,504,448 15,130
283,262 100,081 14,221,186 15,130
285,216 98,126 13,935,970 15,130
287,184 96,158 13,648,786 15,130
289,166 94,177 13,359,620 15,130
291,161 92,181 13,068,459 15,130
293,170 90,172 12,775,289 15,130
295,193 88,149 12,480,096 15,130
297,230 86,113 12,182,866 15,130
299,281 84,062 11,883,586 15,130
301,346 81,997 11,582,240 15,130
303,425 79,917 11,278,815 15,130
305,519 77,824 10,973,297 15,130
307,627 75,716 10,665,670 15,130
309,749 73,593 10,355,921 15,130
311,887 71,456 10,044,034 15,130
314,039 69,304 9,729,996 15,130
316,205 67,137 9,413,791 15,130
318,387 64,955 9,095,403 15,130
320,584 62,758 8,774,819 15,130
322,796 60,546 8,452,023 15,130
325,023 58,319 8,127,000 15,130
327,266 56,076 7,799,734 15,130
329,524 53,818 7,470,209 15,130
331,798 51,544 7,138,411 15,130
334,087 49,255 6,804,324 15,130
336,393 46,950 6,467,932 15,130
338,714 44,629 6,129,218 15,130
341,051 42,292 5,788,167 15,130
343,404 39,938 5,444,763 15,130
 345,774 37,569 5,098,990 15,130
348,159 35,183 4,750,830 15,130
350,562 32,781 4,400,269 15,130
352,981 30,362 4,047,288 15,130
355,416 27,926 3,691,872 15,130
357,868 25,474 3,334,004 15,130
360,338 23,005 2,973,666 15,130
362,824 20,518 2,610,842 15,130
365,328 18,015 2,245,514 15,130
367,848 15,494 1,877,666 15,130
370,386 12,956 1,507,280 15,130
372,942 10,400 1,134,337 15,130
375,515 7,827 758,822 15,130
378,106 5,236 380,715 15,130
380,715 2,627 0 15,130
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
(0) 0 0
Actualicese
En esta hoja de trabajo hemos hecho la copia de las
15,618,216 2,782,218 formulas solo hasta la fila donde se calculaía una
posible cuota 80. Sin embargo, si el credito está
pactado a mayores plazos, solamente tienes que
insertar las filas que necesites y copiar la formula
completa (desde la columna A hasta la E) en esas
nuevas filas
Actualicese
En esta hoja de trabajo hemos hecho la copia de las
formulas solo hasta la fila donde se calculaía una
posible cuota 80. Sin embargo, si el credito está
pactado a mayores plazos, solamente tienes que
insertar las filas que necesites y copiar la formula
completa (desde la columna A hasta la E) en esas
nuevas filas
Valor cuota
mensual
Total

398,473 122,896 275,577

398,473 120,995 277,478
398,473 119,080 279,393
398,473 117,152 281,321
398,473 115,211 283,262
398,473 113,256 285,216
398,473 111,289 287,184
398,473 109,307 289,166
398,473 107,312 291,161
398,473 105,303 293,170
398,473 103,280 295,193
398,473 101,243 297,230
398,473 99,192 299,281
398,473 97,127 301,346
398,473 95,048 303,425
398,473 92,954 305,519
398,473 90,846 307,627
398,473 88,723 309,749
398,473 86,586 311,887
398,473 84,434 314,039
398,473 82,267 316,205
398,473 80,085 318,387
398,473 77,889 320,584
398,473 75,677 322,796
398,473 73,449 325,023
398,473 71,207 327,266
398,473 68,948 329,524
398,473 66,675 331,798
398,473 64,385 334,087
398,473 62,080 336,393
398,473 59,759 338,714
398,473 57,422 341,051
398,473 55,069 343,404
 398,473 52,699 345,774
398,473 50,313 348,159
398,473 47,911 350,562
398,473 45,492 352,981
398,473 43,057 355,416
398,473 40,604 357,868
398,473 38,135 360,338
398,473 35,649 362,824
398,473 33,145 365,328
398,473 30,624 367,848
398,473 28,086 370,386
398,473 25,531 372,942
398,473 22,957 375,515
398,473 20,366 378,106
398,473 17,757 380,715

cese
a hoja de trabajo hemos hecho la copia de las
19,126,689
as solo hasta la fila donde se calculaía una
cuota 80. Sin embargo, si el credito está
o a mayores plazos, solamente tienes que
r las filas que necesites y copiar la formula
ta (desde la columna A hasta la E) en esas
filas
cese
a hoja de trabajo hemos hecho la copia de las
as solo hasta la fila donde se calculaía una
cuota 80. Sin embargo, si el credito está
o a mayores plazos, solamente tienes que
r las filas que necesites y copiar la formula
ta (desde la columna A hasta la E) en esas
filas