8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 1/81
MUEBLES Y ENSERESElemento Precio Unitario Cantidad
Mesa cuadrada para dos personas COP 140,000 15Mesa redonda para 6 personas COP 280,000 5Mesa redonda para 4 personas COP 210,000 3
Mesa redonda recepción COP 250,000 1Sillas restaurante COP 160,000 74Silla recepcionista COP 210,000 1Tauretes para el ar COP 80,000 5Con!unto de estanter"as para el ar COP 350,000 1Tapetes asore l"#uidos para el ar COP $0,000 2%arra del ar COP 450,000 1
Con!unto estanter"as cocina COP 3,000,000 1&na#ueles COP 600,000 4Mesones lar'os cocina COP 250,000 2(a)a*anos COP 2$0,000 5Controlador de te*peratura + u*edad COP 260,000 1
Sillas poltronas para la recepción COP 150,000 4So-. 'rande recepción COP 300,000 1Mostrador recepción COP 420,000 1Cuadros decorati)os recepción COP 200,000 2Casilleros COP $00,000 1Central tele-ónica COP 264,000 1
/spe!o aos COP 500,000 2
COP 4,0$$,000 1
pad COP $00,000 2
isor nocturno COP 1,100,000 1
So-tare + ardare de se'uridad COP 2,600,000 1
/#uipo de sonido con 5 parlantes COP 760,000 1Ter*ó*etro de sonda COP 4$,$00 3
Ter*ó*etro di'ital para carne COP 67,$00 2
COP 250,000 1
Tele)isor ar + recepción COP 1,200,000 2
INVERSIÓN TOTAL MUEBLES Y ENSERES
MAQUINARIAElemento Precio Unitario Cantidad
COP 3,500,0001
/stu-a COP 800,000 2reidora elctrica 8 litros COP 2,000,000 1Con'eladora oriontal COP 2,100,000 1e)era de dos puertas COP 1,100,000 2Calentador de platos COP 1,200,000 1(icuadora COP 230,000 2(a)a )asos auto*.tico COP 1,200,000 1(a)a platos auto*.tico COP 1,500,000 1
Co*putador touc 9 So-tare Cone:ión POS 9Ca!ón *onedero 9 *presora tr*ica
arios ;productos de li*piea, -ocos derepuesto, cuetas, etc<
Cocina industrial a 'as ;8 ocas de -ue'o + 2ornos<
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 2/81
C.*ara -ri'or"-ica COP 17,500,000 1Microondas COP 270,000 2
Ca*pana e:tractora COP 1,400,000 1
INVERSIÓN TOTAL MAQUINARIA
UTENSILIOS DE COCINAElemento Precio Unitario Cantidad
=ue'o co*pleto de ollas de acero ino:idale COP 320,000 3
=ue'o co*pleto de ollas de alu*inio a presiónCOP 220,000
3=ue'o de satrtn COP 220,000 3=ue'o de cucillos de cocina COP $0,000 4Platos llanos COP 12,000 120Platos soperos COP 12,000 80Platos para postres COP 8,000 80asos COP 3,500 80asos para cer)ea COP 5,000 60Copa para )ino tinto sin tallo COP 5,000 60Copa para )ino lanco sin tallo COP 5,000 60Cocteleras COP 35,000 2=ue'o de cuiertos COP 25,000 84Cucaritas COP 6,000 60
COP 210,0003
Ser)illetas COP 6,500 120%ande!a para carne COP 4$,000 20=arra COP 18,000 25&relatas COP 44,000 3/ncendedor COP 32,000 3/:pri*idor COP $2,000 2>allador COP 87,$00 2Salero COP 55,000 5Pi*entero COP 55,000 5Salsera COP 45,000 5
Tala para cortar COP $$,000 5
Mesa rodante especial para ser)icio COP 200,000 4
INVERSIÓN TOTAL UTENCILIOS DE COCINA
PERSONAL PRIMER A!O"
Em#leado Co$to real em#leado
&n-itrión COP 2,000,000 COP 2,514,200Ca*arero COP 1,200,000 COP 1,714,200
Personal de aseo COP 1,200,000 COP 1,714,200
=e-e de cocina COP 3,000,000 COP 3,514,200
&sistente de cocina COP 1,200,000 COP 1,714,200
%ar*an COP 1,200,000 COP 1,714,200
>ecepcionista COP 1,200,000 COP 1,714,200
&+udante de li*piea COP 1,200,000 COP 1,857,504
Con!unto de accesorios de cocina ;colador,cucarón, esp.tulas, etc<
Salario %&$ico me$"
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 3/81
INVERSIÓN TOTAL PERSONAL Men$'al"
SERVICIOS PUBLICOS Y OTROS (ASTOS MENSUALESCo$to men$'al
Tel-ono COP 150,000
(u COP $00,000
&'ua COP 550,000
Pulicidad COP 10,478,320?as COP 1,200,000Contratación -ur'oneta COP 4,800,000&rriendo (ocal COP 22,300,000
COP )*+,-.+,/*
INVERSIÓN INICIAL
COP 5,000,000
Mueles + enseres COP 42,5$8,500Ma#uinaria COP 35,200,000
@tensilios de cocina COP 14,887,800
&decuación local COP 64,400,000
Pre)isión ali*entos COP 15,000,000
Pre)isión personal ;6 *eses< COP 150,167,424
COP 242,26$,$20
TOTAL COP 01)+0/,+1))
INVERSIÓN SERVICIOS PUBLICOS YOTROS (ASTOS Men$'al"
Tr.*ites ad*inistrati)os, re'istro C.*ara de
Co*ercio, ad#uisición de certi-icadosA
Pre)isión ser)icios pBlicos + otros 'astos*ensuales ;6 *eses<
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 4/81
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 5/81
TotalCOP 2,100,000
COP 1,400,000COP 630,000
COP 250,000COP 11,840,000COP 210,000COP 400,000COP 350,000COP 180,000COP 450,000
COP 3,000,000COP 2,400,000COP 500,000
COP 1,450,000 ttpDDAcoronaAcoDtuEsolucionDproductosDcocinasDla)aplatosEaceroEin
COP 260,000
COP 600,000COP 300,000COP 420,000COP 400,000COP $00,000 ttpsDDAlinioAco*AcoDDcru
COP 264,000
COP 1,000,000
COP 4,0$$,000
COP 1,800,000
COP 1,100,000
COP 2,600,000
COP 760,000 COP 14$,700
COP 135,800
COP 250,000
COP 2,400,000
COP )/+02.+0**
Total
COP 3,500,000
COP 1,600,000COP 2,000,000COP 2,100,000COP 2,200,000COP 1,200,000COP 460,000
COP 1,200,000COP 1,500,000 ttpDDAalFostoAco*DelectroDpreparacionEdeEali*entosDla)aplatos
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 6/81
COP 17,500,000 Cotiación SBpernodicoCOP 540,000
COP 1,400,000 ttpDDAo*ecenterAco*AcoDo*ecenterEcoDcate'or+Dcat10027DCa*
COP ,0+/**+***
TotalCOP $60,000
COP 660,000COP 660,000COP 360,000
COP 1,440,000COP $60,000 ttpDDA)e'aEesAco*DporcelanaDplatosEnoEdecoradosAt*lCOP 640,000 ttpDDA)e'aEesAco*DporcelanaDplatosEnoEdecoradosAt*lCOP 280,000 ttpDDA)e'aEesAco*D-act-inderDG#H)asosCOP 300,000 ttpDDA)e'aEesAco*D-act-inderDG#H)asosCOP 300,000 ttpDDA)e'aEesAco*D-act-inderDG#Hcopa9)no9sin9talloCOP 300,000 ttpDDA)e'aEesAco*D-act-inderDG#Hcopa9)no9sin9talloCOP 70,000 ttpDDA)e'aEesAco*D-act-inderDG#Hoccteleras
COP 2,100,000 ttpDDA)e'aEesAco*D-act-inderDG#HcucaritaCOP 360,000 ttpDDA)e'aEesAco*D-act-inderDG#Hcucarita
COP 630,000COP 780,000COP $80,000COP 450,000COP 132,000COP $6,000COP 184,000COP 175,800COP 275,000COP 275,000COP 225,000
COP 4$5,000
COP 800,000
COP 3)+..-+.**
Cantidad Total
1 COP 2,514,200A00 CAMA4 COP 6,856,800A00 Conce#to1 COP 1,714,200A00 Salario .sico
1 COP 3,514,200A00 Susidio de transporte
3 COP 5,142,600A00 Cesant"as
1 COP 1,714,200A00 ntereses sore cesant"as
1 COP 1,714,200A00 Pri*a
1 COP 1,857,504A00 acaciones
ttpDDA)e'aEesAco*DporcelanaDplatosEnoEdecoradosAt*l
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 7/81
COP /0+*/-+2*)4*** Para-iscalesI
&>P
Pensión
Salud
Total
AN5IConce#to
Salario .sicoSusidio de transporte
Cesant"as
ntereses sore cesant"as
Pri*a
acaciones
Para-iscales
&>P
Pensión
Salud
Total
PERSONA
Conce#to
Salario .sico
Susidio de transporteCesant"as
ntereses sore cesant"asPri*aacacionesPara-iscales&>PPensión
Salud
Total
AYUDANTEConce#to
Salario .sicoSusidio de transporteCesant"asntereses sore cesant"asPri*aacacionesPara-iscales&>PPensión
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 8/81
Salud
Total
(EREConce#to
Salario .sicoSusidio de transporteCesant"asntereses sore cesant"asPri*aacacionesPara-iscales&>PPensión
Salud
Total
Primera $entada cliente$Se9'nda $entada cliente$7orario tra%a:o em#leado$
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 9/81
:idale
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 10/81
anas
CALCULO COSTO REAL EMPLEADOS
EROS 8E5E DE COCINA< Monto Conce#to <100A00J COP 1,200,000 Salario .sico 100A00J
11A$4J COP 0 Susidio de transporte 11A$4J
8A33J COP $$,$60 Cesant"as 8A33J
1A00J COP 12,000 ntereses sore cesant"as 1A00J
8A33J COP $$,$60 Pri*a 8A33J
4A17J COP 50,040 acaciones 4A17J
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 11/81
0A00J COP 0 Para-iscales 0A00J
0A52J COP 6,240 &>P 0A52J
12A00J COP 144,000 Pensión 12A00J
8A50J COP 102,000 Salud 8A50J
30)4-2< COP 3+-3)+/** Total 30)4-2<
RION ASISTENTE DE COCIN< Monto Conce#to <
100A00J COP 2,000,000 Salario .sico 100A00J11A$4J COP 0 Susidio de transporte 11A$4J
8A33J COP $$,$60 Cesant"as 8A33J
1A00J COP 12,000 ntereses sore cesant"as 1A00J
8A33J COP $$,$60 Pri*a 8A33J
4A17J COP 50,040 acaciones 4A17J
0A00J COP 0 Para-iscales 0A00J
0A52J COP 6,240 &>P 0A52J
12A00J COP 144,000 Pensión 12A00J
8A50J COP 102,000 Salud 8A50J
30)4-2< COP /+03)+/** Total 30)4-2<
DE ASEO BARMAN
< Monto Conce#to <
100A00J COP 1,200,000 Salario .sico 100A00J
11A$4J COP 0 Susidio de transporte 11A$4J8A33J COP $$,$60 Cesant"as 8A33J
1A00J COP 12,000 ntereses sore cesant"as 1A00J8A33J COP $$,$60 Pri*a 8A33J4A17J COP 50,040 acaciones 4A17J0A00J COP 0 Para-iscales 0A00J0A52J COP 6,240 &>P 0A52J12A00J COP 144,000 Pensión 12A00J
8A50J COP 102,000 Salud 8A50J
30)4-2< COP 3+-3)+/** Total 30)4-2<
E LIMPIE6A RECEPCIONISTA< Monto Conce#to <
100A00J COP 1,200,000 Salario .sico 100A00J11A$4J COP 143,304 Susidio de transporte 11A$4J8A33J COP $$,$60 Cesant"as 8A33J1A00J COP 12,000 ntereses sore cesant"as 1A00J8A33J COP $$,$60 Pri*a 8A33J4A17J COP 50,040 acaciones 4A17J0A00J COP 0 Para-iscales 0A00J0A52J COP 6,240 &>P 0A52J12A00J COP 144,000 Pensión 12A00J
IttpDDAu'ppA'o)AcoDpara-iscales
Dpre'untasE-recuentesAt*l
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 12/81
8A50J COP 102,000 Salud 8A50J
30)4-2< COP 3+.0-+0*) Total 30)4-2<
NCIA< Monto
100A00J COP 3,500,00011A$4J COP 08A33J COP $$,$601A00J COP 12,0008A33J COP $$,$604A17J COP 50,0400A00J COP 00A52J COP 6,24012A00J COP 144,000
8A50J COP 102,000
30)4-2< COP )+*3)+/**
7ORAS DE TRABA8OL'ne$ Marte$ Mi=rcole$ 8'e>e$ Vierne$
Ke 645 p* a 730 p*
O &P/>T@>& Ke $15 a 1015
Ke 530 p* a $30 p* Ke 600 p* a 1200 a
TOTAL DE 7ORAS TRABA8ADAS Semana"; ,1
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 13/81
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 14/81
MontoCOP 3,000,000
COP 0
COP $$,$60
COP 12,000
COP $$,$60
COP 50,040
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 15/81
COP 0
COP 6,240
COP 144,000
COP 102,000
COP ,+03)+/**
AMonto
COP 1,200,000COP 0
COP $$,$60
COP 12,000
COP $$,$60
COP 50,040
COP 0
COP 6,240
COP 144,000
COP 102,000
COP 3+-3)+/**
Monto
COP 1,200,000
COP 0COP $$,$60
COP 12,000COP $$,$60COP 50,040
COP 0COP 6,240
COP 144,000
COP 102,000
COP 3+-3)+/**
MontoCOP 1,200,000
COP 0COP $$,$60COP 12,000COP $$,$60COP 50,040
COP 0COP 6,240
COP 144,000
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 16/81
COP 102,000
COP 3+-3)+/**
S&%ado Domin9oKe 630 p* a $15 p*
O &P/>T@>&
Ke 530 p* a 1130 p*
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 17/81
6ONA ?REA M/" PRECIO MILLONES" PRECIO POR M/ LIN@ PUBLILona ? 340A00 COP 17A00 COP 50,000A00 ttpDDcasasALona ? 327A00 COP 20A00 COP 61,162A08 ttpDDALona ? 200A00 COP 14A00 COP 70,000A00 ttpDDAl@sa#uen 240A00 COP 18A$0 COP 78,750A00 ttpDDcasasA@sa#uen 322A00 COP 25A00 COP 77,63$A75@sa#uen 354A00 COP 23A30 COP 65,81$A21@sa#uen 358A00 COP 25A00 COP 6$,832A40 ttpDDA@sa#uen 240A00 COP 18A$0 COP 78,750A00@sa#uen 350A00 COP 24A00 COP 68,571A43 ttpDDA@sa#uen 400A00 COP 22A00 COP 55,000A00
@sa#uen 400A00 COP 20A00 COP 50,000A00
Pecio #romedio #or m/ COP 68,045A35
Co$to arriendamiento local ,/. m/ COP //+,3.+.-)4)0
ttpDDAttpDDA
ttpDDAl
ttpDDA
ttpDDcasasA
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 18/81
CACIÓN ARRIENDOro)itAco*AcoDinde:AppDcodAadDidA@1L1*5+pDatNdAlocalJ20onaJ20'Dt+peA2DoetrocuadradoAco*DarriendoDlocalco*ercialEenEo'otaEcicoEsanEpatricioEconEestratoE*udiAco*AcoDlocalEenEarriendoEenEcicoEo'otaE$17$1E$At*lGut*NsourceH*itulau
*itulaAco*AcoDo--erEdetalle1D6$402D2680121448832604807D1D2DarriendoElocalEusa#u
etrocuadradoAco*DarriendoDlocalco*ercialEenEo'otaEsantaEiianaEsantaEiianaEco
etrocuadradoAco*DarriendoDlocalco*ercialEenEo'otaEsantaEararaEsanEpatricioEcon
etrocuadradoAco*DarriendoDlocalco*ercialEenEo'otaEsantaEararaEsantaEararaEoetrocuadradoAco*DarriendoDlocalco*ercialEenEo'otaEpepeEsierraEsantaEararaEocci
*udiAco*AcoDlocalEco*ercialEenEarriendoEenEpepeEsierraEs46$E2410E18$543E$At*lGl
etrocuadradoAco*DarriendoDlocalco*ercialEenEo'otaEusa#uenEconEestratoE6EareaE40
*itulaAco*AcoDdetalleD15$$02D5600130460666815827D$D1DlocalesEco*ercialesErestau
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 19/81
i'inA2DsectionA1DsectionNt+peA1DpopA0DposA4Dpa'eA1DEareaE327E*tsE20A000A000EidE4686E1330244t*N*ediu*Ha''re'atorsut*Nca*pai'nH*itulaEpre*iu*enD(a*udi
nEestratoE6EareaE358E*tsE25A000A000EidE72E1373444
EestratoE6EareaE350E*tsE24A000A000EidE3$4E1354673
ccidentalEconEestratoE6EareaE322E*tsE25A000A000EidE$73E12$8687entalEconEestratoE4EareaE354E*tsE23A35$A050EidE$21E1376102
ocationNre'ionH22locationNcit+H16$locationNareaH3$3cate'or+H2attriuteNoptionHo--
0E*tsE22A000A000EidE526E30601
ranteEusa#uen
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 20/81
rNt+peJ3&rentdirHdesc
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 21/81
/*3-Enero
K ( M = 12 20 20 20 45 5016 20 20 20 45 5016 20 20 20 45 5016 16 16 18 40 45
14 16 16Di$min'cin 0<
5e%reroK ( M =
1$ 43 4815 1$ 1$ 1$ 43 4815 1$ 45 1$ 43 4815 15 15 17 38 43
13 15 15Di$min'cin 30<
MaroK ( M =
15 34 3812 15 15 40 34 3812 15 15 15 34 3812 12 12 14 30 3410 12 12 14 30 34
A'mento 3*<
A%rilK ( M =
13 17 17 17 37 4213 17 17 17 37 4213 13 13 15 33 37
11 13 13 15 33 37A'mento 3*< 11Mao
K ( M = 1$ 1$ 1$ 41 46
14 40 1$ 1$ 41 4614 14 14 17 36 4112 14 14 17 36 4112 14 14 17
A'mento 3*<
8'nioK ( M =
45 5115 21 21 21 45 5115 15 15 1$ 40 4513 42 15 1$ 40 4513 15 15 1$ 40 45
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 22/81
A'mento 3*<
8'lioS K ( M5050 17 17 2350 17 17 1745 14 17 17
14 17 17A'mento 0< 14 17A9o$to
S K ( M48 2448 18 18 1848 15 18 1843 15 18 18
15 18 18A'mento 0<
Se#tiem%reS K ( M
3838 1$ 1$ 1$38 16 1$ 1$34 16 1$ 1$
16 1$ 1$A'mento 0<
Oct'%reS K ( M42 20 20 2042 17 20 2042 17 20 2037 17 20 20
37 17 20 48A'mento 0<
No>iem%reS K ( M4646 18 21 2141 18 21 2141 18 21 21
18 21 21A'mento 0<
Diciem%reS K ( M
5151 0 22 2245 1$ 22 2245 1$ 22 22
60 22 2260
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 23/81
= S56
23 50 56 5621 44 56 5621 44 50 50
21 44 50 50
= S24 53 5$ 5$22 46 5$ 5$22 46 53 5322 46 53 53
22 46
= S
62 6223 48 62 6223 48 62 6223 48 56 5623 48 56 56
= S24 50 65 6524 50 65 6524 50 5$ 5$24 50 5$ 5$
= S25 53 68 6825 53 68 6825 53 62 6225 53 62 6225 53
= S
71 7126 56 71 7126 56 65 6526 56 65 6526 56 65 65
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 24/81
Enero 5e%rero Maroentas por ali*entos COP 0 COP 0 COP 0entas por eidas COP 0 COP 0 COP 0
Total Venta$ COP * COP * COP *Costo de )entas
Costo )entas ali*entos COP 0 COP 0 COP 0Costo )entas eidas COP 0 COP 0 COP 0Total co$to de >enta$ COP * COP * COP *Utilidad Br'ta COP * COP * COP *?astos de operación
ó*ina COP 25,027,$04 COP 25,027,$04 COP 25,027,$04Ser)icios pBlicos COP 2,800,000 COP 2,800,000 COP 2,800,000&rriendo COP 22,300,000 COP 22,300,000 COP 22,300,000MarFetin' COP 10,478,320 COP 10,478,320 COP 10,478,320Contratación -ur'oneta COP 4,800,000 COP 4,800,000 COP 4,800,000?astos operacionales de )entas COP 0 COP 0 COP 0
Total 9a$to$ de o#eracin COP 10+)*1+//) COP 10+)*1+//) COP 10+)*1+//)
?astos de &d*inistraciónSalario &d*inistradores COP 0 COP 0 COP 0EBITDA COP 10+)*1+//) COP 10+)*1+//) COP 10+)*1+//)Kepreciación COP 1,246,601 COP 1,246,601 COP 1,246,601
&*ortiaciones COP 0 COP 0 COP 0EBIT COP 11+10/+./0 COP 11+10/+./0 COP 11+10/+./0n'resos no operacionales COP 1,876,688 COP 1,883,745 COP 1,8$0,82$?astos no operacionales COP 3,471,285 COP 3,388,0$8 COP 3,304,$16
Konación a undación C>&C COP 0 COP 0 COP 0EBT COP 1.+/)-+)// COP 1.+30-+3-. COP 1.+*11+23,*puestos COP 0 COP 0 COP 0%ene-icio triutario COP 0
Utilidad Neta COP 1.+/)-+)// COP 1.+30-+3-. COP 1.+*11+23,>eser)a le'al ;10J< COP 0
Ki)idendos COP 0
Utildiad Retenida COP 1.+/)-+)// COP 1.+30-+3-. COP 1.+*11+23,
ESTADO DE/*3- /*3. /*32
entas por ali*entosentas por eidasTotal Venta$Costo de )entas
Costo )entas ali*entosCosto )entas eidas
Total co$to de >enta$Utilidad Br'ta?astos de operaciónó*inaSer)icios pBlicos&rriendoMarFetin'Contratación -ur'oneta
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 25/81
Total 9a$to$ de o#eracin?astos de &d*inistraciónSalario &d*inistradoresTotal 9a$to$ Admini$tracinEBITDAKepreciación&*ortiaciones
EBITn'resos no operacionales?astos no operacionales
EBT*puestosUtilidad NetaKi)idendos
Utildiad Retenida
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 26/81
ESTADO DE PERDIDAS Y (ANANCIAS BRAILLE S4A4S /*3-A%ril Mao 8'nio 8'lioCOP 0 COP 0 COP 0 COP 0COP 0 COP 0 COP 0 COP 0
COP * COP * COP * COP *
COP 0 COP 0 COP 0 COP 0COP 0 COP 0 COP 0 COP 0COP * COP * COP * COP *COP * COP * COP * COP *
COP 25,027,$04 COP 25,027,$04 COP 25,027,$04 COP 25,027,$04COP 2,800,000 COP 2,800,000 COP 2,800,000 COP 2,800,000COP 22,300,000 COP 22,300,000 COP 22,300,000 COP 22,300,000COP 10,478,320 COP 10,478,320 COP 10,478,320 COP 8,$78,320COP 4,800,000 COP 4,800,000 COP 4,800,000 COP 4,800,000
COP 0 COP 0 COP 0 COP 0
COP 10+)*1+//) COP 10+)*1+//) COP 10+)*1+//) COP 1,+2*1+//)
COP 0 COP 0 COP 0 COP 8,028,400COP 10+)*1+//) COP 10+)*1+//) COP 10+)*1+//) COP -3+2,)+1/)
COP 1,246,601 COP 1,246,601 COP 1,246,601 COP 1,246,601
COP 0 COP 0 COP 0 COP 0COP 11+10/+./0 COP 11+10/+./0 COP 11+10/+./0 COP -,+3.3+//0
COP 1,8$7,$3$ COP 1,$05,076 COP 1,$12,240 COP 1,$1$,431COP 3,221,741 COP 3,138,572 COP 3,055,408 COP 2,$72,251
COP 0 COP 0 COP 0 COP 0COP 1-+2-1+1/- COP 1-+..1+,/* COP 1-+-20+22, COP -)+/,)+*)0
COP 0 COP 0 COP 0 COP 0
COP 1-+2-1+1/- COP 1-+..1+,/* COP 1-+-20+22, COP -)+/,)+*)0
COP 1-+2-1+1/- COP 1-+..1+,/* COP 1-+-20+22, COP -)+/,)+*)0
PERDIDAS Y (ANANCIAS BRAILLE S4A4S /*3- /*/1/*/* /*/3 /*// /*/,
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 27/81
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 28/81
A9o$to Se#tiem%re Oct'%re No>iem%reCOP 0 COP 0 COP 0 COP 0COP 0 COP 0 COP 0 COP 0
COP * COP * COP * COP *
COP 0 COP 0 COP 0 COP 0COP 0 COP 0 COP 0 COP 0COP * COP * COP * COP *COP * COP * COP * COP *
COP 25,027,$04 COP 25,027,$04 COP 25,027,$04 COP 25,027,$04COP 2,800,000 COP 2,800,000 COP 2,800,000 COP 2,800,000COP 22,300,000 COP 22,300,000 COP 22,300,000 COP 22,300,000COP 8,$78,320 COP 8,$78,320 COP 8,$78,320 COP 8,$78,320COP 4,800,000 COP 4,800,000 COP 4,800,000 COP 4,800,000
COP 0 COP 0 COP 0 COP 0
COP 1,+2*1+//) COP 1,+2*1+//) COP 1,+2*1+//) COP 1,+2*1+//)
COP 8,028,400 COP 8,028,400 COP 8,028,400 COP 8,028,400COP -3+2,)+1/) COP -3+2,)+1/) COP -3+2,)+1/) COP -3+2,)+1/)
COP 1,246,601 COP 1,246,601 COP 1,246,601 COP 1,246,601
COP 0 COP 0 COP 0 COP 0COP -,+3.3+//0 COP -,+3.3+//0 COP -,+3.3+//0 COP -,+3.3+//0
COP 1,$26,650 COP 1,$33,8$5 COP 1,$41,167 COP 1,$48,467COP 2,88$,100 COP 2,805,$55 COP 2,722,816 COP 2,63$,683
COP 0 COP 0 COP 0 COP 0COP -)+3),+1-0 COP -)+*0,+/.0 COP -,+21/+.-, COP -,+.-/+))3
COP 0 COP 0 COP 0 COP 0
COP -)+3),+1-0 COP -)+*0,+/.0 COP -,+21/+.-, COP -,+.-/+))3
COP -)+3),+1-0 COP -)+*0,+/.0 COP -,+21/+.-, COP -,+.-/+))3
/*/) /*/0 /*/1
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 29/81
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 30/81
Enero 5e%reroDiciem%re D+ L+ M+ I4 COP 0 COP 0
COP 0A00 COP 0 QKD0R 8+ V+ S COP 0 COP 0
COP 0 COP 0 QKD0R Ta$a cam%io E5J E15J
COP * COP * 0A00 0A00
Comi$in >enta tar:eta$ Cr
COP 0 < '$o MinCOP 0 S& 46A4J 1A60JCOP * FDIVG*H Master Card 40A0J 2A06J
COP * &*erican /:press 7A7J 3A50J
Kinners 5A$J 2A07J
COP 25,027,$04COP 2,800,000COP 22,300,000COP 8,$78,320COP 4,800,000
COP 0
COP 1,+2*1+//) FDIVG*H
COP 8,028,400COP -3+2,)+1/)
COP 1,246,601
COP 0COP -,+3.3+//0 0 0
COP 1,$55,7$4 0 0COP 2,556,556
COP 0 0 0COP -,+-.3+2.1 0 0
COP 0
COP -,+-.3+2.1
COP -,+-.3+2.1
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 31/81
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 32/81
Nmero de Comen$ale$ /*3-Maro A%ril Mao 8'nio 8'lio A9o$to Se#tiem%re Oct'%re No>iem%reCOP 0 COP 0 COP 0 COP 0 COP 0 COP 0 COP 0 COP 0 COP 0COP 0 COP 0 COP 0 COP 0 COP 0 COP 0 COP 0 COP 0 COP 0
$J $J $J $J $J $J $J $J $J
0A00 0A00 0A00 0A00 0A00 0A00 0A00 0A00 0A00
dito D=%ito
Med Ma S'#'e$to2A05J 2A50J 0A00J2A28J 2A50J 0A00J4A50J 5A50J 0A00J
2A2$J 2A50J 0A00J
0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 33/81
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 34/81
Diciem%reCOP 0COP 0
0A00
00
0 0A000 0A00
COP 0A00 COP 0A00COP 0A00 COP 0A00
COP 0A00 COP 0A00COP 0A00 COP 0A00
COP 0A00 COP 0A00
COP 0A00 COP 0A00COP 0A00 COP 0A00
COP 0A00 COP 0A00COP 0A00 COP 0A00COP 0A00 COP 0A00
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 35/81
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 36/81
MES * MES 3ACTIVOSActi>o$ Corriente$/-ecti)o COP 5,000,000 ECOP 74,138,$$7%ancos COP 387,437,344 COP 388,8$4,308n)entarios de *ateria pri*as COP 15,000,000 COP 15,000,000
n)entarios de (icores en consi'nación COP 5,000,000 COP 5,000,000Total Acti>o$ Corriente$ COP )3/+),-+,)) COP ,,)+-00+,3*
Acti>o$ 5i:o$Mueles + /nseres COP 42,5$8,500 COP 42,5$8,500 Kepreciación acu*ulada COP 0 COP 507,125M.#uinaria COP 35,200,000 COP 35,200,000 Kepreciación acu*ulada COP 0 COP 325,$26@tencilios de cocina COP 14,887,800 COP 14,887,800 Kepreciación acu*ulada COP 0 COP 413,550Total Acti>o$ 5i:o$ COP 2/+1.1+,** COP 23+),2+122
Otro$ Acti>o$&decuación (ocal COP 64,400,000 COP 64,400,000
Total Otro$ Acti>o$ COP 1)+)**+*** COP 1)+)**+***
TOTAL ACTIVOS COP 012+0/,+1)) COP )2*+020+**2
PASIVOSPa$i>o$ Corriente$*puestos por pa'ar COP 0A00 COP 0
Cuentas por pa'ar (icores COP 5,000,000 COP 5,000,000
Total Pa$i>o$ corriente$ COP 0+***+*** COP 0+***+***
Pa$i>o$ no Corriente$Presta*o %ancario ;3 aos< COP 384,523,644 COP 373,842,432
Total Pa$i>o$ no Corriente$ COP ,.)+0/,+1)) COP ,-,+.)/+),/
TOTAL PASIVOS COP ,.2+0/,+1)) COP ,-.+.)/+),/
PATRIMONIO&portes de socios COP 180,000,000 COP 180,000,000@tildiades de /!ercicio COP 0 ECOP 68,247,422@tildiades &cu*uladas COP 0
TOTAL PATRIMONIO COP 3.*+***+*** COP 333+-0/+0-.
TOTAL PASIVOS J PATRIMONIO COP 012+0/,+1)) COP )2*+020+**2
/*3- /*3.ACTIVOSActi>o$ Corriente$
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 37/81
/-ecti)o%ancosn)entarios de *ateria pri*asn)entarios de (icores en consi'naciónTotal Acti>o$ Corriente$
Acti>o$ 5i:o$
Mueles + /nseres Kepreciación acu*uladaM.#uinaria Kepreciación acu*ulada@tencilios de cocina Kepreciación acu*uladaTotal Acti>o$ 5i:o$
Otro$ Acti>o$
Total Otro$ Acti>o$
TOTAL ACTIVOS
PASIVOSPa$i>o$ Corriente$Cuentas por pa'ar (icores
Total Pa$i>o$ corriente$
Pa$i>o$ no Corriente$Presta*o %ancario ;3 aos<
Total Pa$i>o$ no Corriente$
TOTAL PASIVOS
PATRIMONIO&portes de socios>esultados de /!ercicio
TOTAL PATRIMONIO
TOTAL PASIVOS J PATRIMONIO
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 38/81
BALANCE (ENERAL BRAILMES / MES , MES ) MES 0
ECOP 153,1$3,22$ ECOP 232,162,6$5 ECOP 311,047,3$6 ECOP 38$,847,331COP 3$0,356,750 COP 3$1,824,6$3 COP 3$3,2$8,155 COP 3$4,777,158COP 15,000,000 COP 15,000,000 COP 15,000,000 COP 15,000,000
COP 5,000,000 COP 5,000,000 COP 5,000,000 COP 5,000,000COP /0-+31,+0/3 COP 3-2+113+22- COP 3*/+/0*+-02 COP /)+2/2+./-
COP 42,5$8,500 COP 42,5$8,500 COP 42,5$8,500 COP 42,5$8,500COP 1,014,250 COP 1,521,375 COP 2,028,500 COP 2,535,625
COP 35,200,000 COP 35,200,000 COP 35,200,000 COP 35,200,000COP 651,852 COP $77,778 COP 1,303,704 COP 1,62$,630
COP 14,887,800 COP 14,887,800 COP 14,887,800 COP 14,887,800COP 827,100 COP 1,240,650 COP 1,654,200 COP 2,067,750
COP 2*+32,+*2. COP ..+2)1+)2- COP .-+122+.21 COP .1+)0,+/20
COP 64,400,000 COP 64,400,000 COP 64,400,000 COP 64,400,000
COP 1)+)**+*** COP 1)+)**+*** COP 1)+)**+*** COP 1)+)**+***
COP )33+-01+132 COP ,,,+**.+)2) COP /0)+,0*+100 COP 3-0+-.,+3/,
COP 0 COP 0 COP 0 COP 0
COP 5,000,000 COP 5,000,000 COP 5,000,000 COP 5,000,000
COP 0+***+*** COP 0+***+*** COP 0+***+*** COP 0+***+***
COP 363,161,21$ COP 352,480,007 COP 341,7$8,7$5 COP 331,117,582
COP ,1,+313+/32 COP ,0/+).*+**- COP ,)3+-2.+-20 COP ,,3+33-+0./
COP ,1.+313+/32 COP ,0-+).*+**- COP ,)1+-2.+-20 COP ,,1+33-+0./
COP 180,000,000 COP 180,000,000 COP 180,000,000 COP 180,000,000ECOP 68,157,178 ECOP 68,066,$13 ECOP 67,$76,627 ECOP 67,886,320ECOP 68,247,422 ECOP 136,404,600 ECOP 204,471,513 ECOP 272,448,13$
COP ),+020+)** COP /)+)-3+03, COP 2/+)).+3,2 COP 31*+,,)+)1*
COP )33+-01+132 COP ,,,+**.+)2) COP /0)+,0*+100 COP 3-0+-.,+3/,
BALANCE (ENERAL BRAILLE S4A4S4 /*3-/*/1/*32 /*/* /*/3 /*//
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 39/81
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 40/81
E S4A4S4 /*3-MES 1 MES - MES . MES 2
ECOP 468,562,500 ECOP 553,721,304 ECOP 638,7$5,343 ECOP 723,784,615COP 3$6,261,724 COP 3$7,751,872 COP 3$$,247,623 COP 400,74$,000COP 15,000,000 COP 15,000,000 COP 15,000,000 COP 15,000,000
COP 5,000,000 COP 5,000,000 COP 5,000,000 COP 5,000,000COP 0/+,**+--- COP 3,0+212+),, COP /32+0)-+-32 COP ,*,+*,0+131
COP 42,5$8,500 COP 42,5$8,500 COP 42,5$8,500 COP 42,5$8,500COP 3,042,750 COP 3,54$,875 COP 4,057,000 COP 4,564,125
COP 35,200,000 COP 35,200,000 COP 35,200,000 COP 35,200,000COP 1,$55,556 COP 2,281,481 COP 2,607,407 COP 2,$33,333
COP 14,887,800 COP 14,887,800 COP 14,887,800 COP 14,887,800COP 2,481,300 COP 2,8$4,850 COP 3,308,400 COP 3,721,$50
COP .0+/*1+12) COP .,+21*+*2) COP ./+-3,+)2, COP .3+)11+.2/
COP 64,400,000 COP 64,400,000 COP 64,400,000 COP 64,400,000
COP 1)+)**+*** COP 1)+)**+*** COP 1)+)**+*** COP 1)+)**+***
COP 2-+,*0+23. COP 3/+,2*+113 COP -/+),)+//- COP 30-+31.+-/)
COP 0 COP 0 COP 0 COP 0
COP 5,000,000 COP 5,000,000 COP 5,000,000 COP 5,000,000
COP 0+***+*** COP 0+***+*** COP 0+***+*** COP 0+***+***
COP 320,436,370 COP 30$,755,158 COP 2$$,073,$45 COP 288,3$2,733
COP ,/*+),1+,-* COP ,*2+-00+30. COP /22+*-,+2)0 COP /..+,2/+-,,
COP ,/0+),1+,-* COP ,3)+-00+30. COP ,*)+*-,+2)0 COP /2,+,2/+-,,
COP 180,000,000 COP 180,000,000 COP 180,000,000 COP 180,000,000ECOP 67,7$5,$$3 ECOP 74,234,045 ECOP 74,143,675 ECOP 74,053,285
ECOP 340,334,460 ECOP 408,130,452 ECOP 482,364,4$7 ECOP 556,508,172
COP //.+3,*+)0/ COP ,*/+,1)+)2- COP ,-1+0*.+3-/ COP )0*+013+)0-
COP 2-+,*0+23. COP 3/+,2*+113 COP -/+),)+//- COP 30-+31.+-/)
/*/, /*/) /*/0 /*/1
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 41/81
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 42/81
MES 3* MES 33 MES 3/
ECOP 808,68$,122 ECOP 8$3,508,864 ECOP $78,243,840COP 402,256,022 COP 403,768,712 COP 405,287,0$0COP 15,000,000 COP 15,000,000 COP 15,000,000
COP 5,000,000 COP 5,000,000 COP 5,000,000COP ,.1+),,+3** COP )12+-)*+30/ COP 00/+201+-0*
COP 42,5$8,500 COP 42,5$8,500 COP 42,5$8,500COP 5,071,250 COP 5,578,375 COP 6,085,500
COP 35,200,000 COP 35,200,000 COP 35,200,000COP 3,25$,25$ COP 3,585,185 COP 3,$11,111
COP 14,887,800 COP 14,887,800 COP 14,887,800COP 4,135,500 COP 4,54$,050 COP 4,$62,600
COP .*+//*+/23 COP -.+2-,+12* COP --+-/-+*.2
COP 64,400,000 COP 64,400,000 COP 64,400,000
COP 1)+)**+*** COP 1)+)**+*** COP 1)+)**+***
COP /)3+.3/+.3* COP ,/1+,11+)1/ COP )3*+./2+113
COP 0 COP 0 COP 0
COP 5,000,000 COP 5,000,000 COP 5,000,000
COP 0+***+*** COP 0+***+*** COP 0+***+***
COP 277,711,521 COP 267,030,308 COP 256,34$,0$6
COP /--+-33+0/3 COP /1-+*,*+,*. COP /01+,)2+*21
COP /./+-33+0/3 COP /-/+*,*+,*. COP /13+,)2+*21
COP 180,000,000 COP 180,000,000 COP 180,000,000ECOP 73,$62,873 ECOP 73,872,441 ECOP 73,781,$86
ECOP 630,561,457 ECOP 704,524,330 ECOP 778,3$6,771
COP 0/)+0/)+,,* COP 02.+,21+--3 COP 1-/+3-.+-0-
COP /)3+.3/+.3* COP ,/1+,11+)1/ COP )3*+./2+113
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 43/81
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 44/81
COP 387,437,344A00
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 45/81
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 46/81
n)ersión nicial COP 564,523,644A00
Entidad Monto a in>ertir Porcenta:e c'%iertoO*ar /scorcia COP 80,000,000 14A17J
(eonardo /scorcia COP 30,000,000 5A31J
elipe %ellón COP 30,000,000 5A31J
Maria Paula Puerto COP 20,000,000 3A54JManuel >o*ero COP 20,000,000 3A54J
Presta*o ancario COP 384,523,644 68A11J
5ORMATO DEUDA CAVIPETROL
C'ota F A%ono a intere$e$ A%ono a ca#ital C'ota men$'al
0A00 0A00 0A00 0A001A00 3,051,561A04 10,681,212A33 13,732,773A37
2A00 2,$66,7$5A46 10,681,212A33 13,648,007A7$
3A00 2,882,02$A87 10,681,212A33 13,563,242A214A00 2,7$7,264A2$ 10,681,212A33 13,478,476A62
5A00 2,712,4$8A70 10,681,212A33 13,3$3,711A046A00 2,627,733A12 10,681,212A33 13,308,$45A457A00 2,542,$67A53 10,681,212A33 13,224,17$A878A00 2,458,201A$5 10,681,212A33 13,13$,414A28$A00 2,373,436A37 10,681,212A33 13,054,648A7010A00 2,288,670A78 10,681,212A33 12,$6$,883A1111A00 2,203,$05A20 10,681,212A33 12,885,117A5312A00 2,11$,13$A61 10,681,212A33 12,800,351A$4
13A00 2,034,374A03 10,681,212A33 12,715,586A36
14A00 1,$4$,608A44 10,681,212A33 12,630,820A7815A00 1,864,842A86 10,681,212A33 12,546,055A1$16A00 1,780,077A27 10,681,212A33 12,461,28$A6117A00 1,6$5,311A6$ 10,681,212A33 12,376,524A0218A00 1,610,546A10 10,681,212A33 12,2$1,758A441$A00 1,525,780A52 10,681,212A33 12,206,$$2A8520A00 1,441,014A$4 10,681,212A33 12,122,227A2721A00 1,356,24$A35 10,681,212A33 12,037,461A6822A00 1,271,483A77 10,681,212A33 11,$52,6$6A1023A00 1,186,718A18 10,681,212A33 11,867,$30A5224A00 1,101,$52A60 10,681,212A33 11,783,164A$3
25A00 1,017,187A01 10,681,212A33 11,6$8,3$$A35
26A00 $32,421A43 10,681,212A33 11,613,633A7627A00 847,655A84 10,681,212A33 11,528,868A1828A00 762,8$0A26 10,681,212A33 11,444,102A5$2$A00 678,124A68 10,681,212A33 11,35$,337A0130A00 5$3,35$A0$ 10,681,212A33 11,274,571A4231A00 508,5$3A51 10,681,212A33 11,18$,805A8432A00 423,827A$2 10,681,212A33 11,105,040A2633A00 33$,062A34 10,681,212A33 11,020,274A6734A00 254,2$6A75 10,681,212A33 10,$35,50$A0$35A00 16$,531A17 10,681,212A33 10,850,743A5036A00 84,765A58 10,681,212A33 10,765,$77A$2
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 47/81
&ono a intereses 0A00 COP 3,051,561A04 COP 2,$66,7$5A46Cuota *ensual 0A00 COP 13,732,773A37 COP 13,648,007A7$Saldo COP 384,523,644A00 COP 373,842,431A67 COP 363,161,21$A33
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 48/81
Características:
- Plazo: máximo siete (7) años
- Interés: 9.50% NQV 9.95% !.". $A$5J
- #asa e$eti&a mens'al: 0.79% 0A7$J
- *arant+a: *arant+a real (,itea) /o a1aré
ttpsDDAca)ipetrolAco*Dinde:AppDproductosE+Eser)iciosDproductosEdeEcredito
Saldo Me$
384,523,644A00 0A00
373,842,431A67 1A00
363,161,21$A332A00
352,480,007A00 3A00 341,7$8,7$4A67 4A00
331,117,582A33 5A00
320,436,370A00 6A00
30$,755,157A67 7A00
2$$,073,$45A33 8A00
288,3$2,733A00 $A00
277,711,520A67 10A00
267,030,308A33 11A00
256,34$,0$6A00 12A00
245,667,883A67 13A00
234,$86,671A33 14A00 224,305,45$A00 15A00
213,624,246A67 16A00
202,$43,034A33 17A00
1$2,261,822A00 18A00
181,580,60$A67 1$A00
170,8$$,3$7A33 20A00
160,218,185A00 21A00
14$,536,$72A67 22A00
138,855,760A33 23A00
128,174,548A00 24A00
117,4$3,335A67 25A00
106,812,123A33 26A00 $6,130,$11A00 27A00
85,44$,6$8A67 28A00
74,768,486A33 2$A00
64,087,274A00 30A00
53,406,061A67 31A00
42,724,84$A33 32A00
32,043,637A00 33A00
21,362,424A67 34A00
10,681,212A33 35A00
0A00 36A00
- 2orma 3e a1o: or &entanilla mens'almente
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 49/81
COP 2,882,02$A87 COP 2,7$7,264A2$ COP 2,712,4$8A70 COP 2,627,733A12COP 13,563,242A21 COP 13,478,476A62 COP 13,3$3,711A04 COP 13,308,$45A45
COP 352,480,007A00 COP 341,7$8,7$4A67 COP 331,117,582A33 COP 320,436,370A00
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 50/81
ondo 5ONDO 5ONVALTasa /& 5A$7J
Tasa /M 0A48J
Tasa co*isión ;&< 1A30J
Tasa co*isión /M 0A11J
5ORMATO INVERSIÓN 5ONDO CREDICORPCAPITAL
Comi$in *+33<" A%ono a ca#ital Retiro Saldo
0A00 COP 0A00 COP 0A00 COP 387,437,344A0041$723A7$ COP 1,876,687A52 COP 0A00 COP 388,8$4,307A73
421302A17 COP 1,883,744A83 COP 0A00 COP 3$0,356,750A3$
422886A48 COP 1,8$0,828A68 COP 0A00 COP 3$1,824,6$2A60424476A75 COP 1,8$7,$3$A17 COP 0A00 COP 3$3,2$8,155A01
426073A00 COP 1,$05,076A40 COP 0A00 COP 3$4,777,158A41427675A25 COP 1,$12,240A46 COP 0A00 COP 3$6,261,723A6242$283A53 COP 1,$1$,431A47 COP 0A00 COP 3$7,751,871A564308$7A86 COP 1,$26,64$A52 COP 0A00 COP 3$$,247,623A22432518A26 COP 1,$33,8$4A72 COP 0A00 COP 400,748,$$$A67434144A75 COP 1,$41,167A15 COP 0A00 COP 402,256,022A08435777A36 COP 1,$48,466A$4 COP 0A00 COP 403,768,711A66
437416A10 COP 1,$55,7$4A18 COP 0A00 COP 405,287,08$A74COP 1,$63,148A$7 COP 407,250,238A71
COP 1,$72,658A17 COP 40$,222,8$6A88COP 1,$82,213A42 COP 411,205,110A30COP 1,$$1,814A$6 COP 413,1$6,$25A26COP 2,001,463A01 COP 415,1$8,388A27COP 2,011,157A7$ COP 417,20$,546A06COP 2,020,8$$A54 COP 41$,230,445A60COP 2,030,688A46 COP 421,261,134A06COP 2,040,524A81 COP 423,301,658A88COP 2,050,408A80 COP 425,352,067A68COP 2,060,340A67 COP 427,412,408A35COP 2,070,320A65 COP 42$,482,72$A00COP 2,080,348A$7 COP 431,563,077A$6
COP 2,0$0,425A86 COP 433,653,503A82COP 2,100,551A56 COP 435,754,055A38COP 2,110,726A32 COP 437,864,781A70COP 2,120,$50A35 COP 43$,$85,732A05COP 2,131,223A$1 COP 442,116,$55A$6COP 2,141,547A24 COP 444,258,503A20COP 2,151,$20A57 COP 446,410,423A77COP 2,162,344A14 COP 448,572,767A$1COP 2,172,818A21 COP 450,745,586A12COP 2,183,343A01 COP 452,$28,$2$A13COP 2,1$3,$18A7$ COP 455,122,847A$2
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 51/81
COP 2,542,$67A53 COP 2,458,201A$5 COP 2,373,436A37 COP 2,288,670A78COP 13,224,17$A87 COP 13,13$,414A28 COP 13,054,648A70 COP 12,$6$,883A11
COP 30$,755,157A67 COP 2$$,073,$45A33 COP 288,3$2,733A00 COP 277,711,520A67
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 52/81
MES 0A00 1A00Comi$in *+33<" COP 0A00 COP 41$,723A7$
COP 0A00 COP 1,876,687A52
Retiro COP 0A00 COP 0A00Saldo COP 387,437,344 COP 388,8$4,307A73
In9re$o #or inter=$*+)."
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 53/81
COP 2,203,$05A20 COP 2,11$,13$A61 COP 2,034,374A03 COP 1,$4$,608A44COP 12,885,117A53 COP 12,800,351A$4 COP 12,715,586A36 COP 12,630,820A78
COP 267,030,308A33 COP 256,34$,0$6A00 COP 245,667,883A67 COP 234,$86,671A33
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 54/81
2A00 3A00 4A00 5A00COP 421,302A17 COP 422,886A48 COP 424,476A75 COP 426,073A00
COP 1,883,744A83 COP 1,8$0,828A68 COP 1,8$7,$3$A17 COP 1,$05,076A40
COP 0A00 COP 0A00 COP 0A00 COP 0A00COP 3$0,356,750A3$ COP 3$1,824,6$2A60 COP 3$3,2$8,155A01 COP 3$4,777,158A41
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 55/81
COP 1,864,842A86 COP 1,780,077A27 COP 1,6$5,311A6$ COP 1,610,546A10COP 12,546,055A1$ COP 12,461,28$A61 COP 12,376,524A02 COP 12,2$1,758A44
COP 224,305,45$A00 COP 213,624,246A67 COP 202,$43,034A33 COP 1$2,261,822A00
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 56/81
6A00 7A00 8A00 $A00COP 427,675A25 COP 42$,283A53 COP 430,8$7A86 COP 432,518A26
COP 1,$12,240A46 COP 1,$1$,431A47 COP 1,$26,64$A52 COP 1,$33,8$4A72
COP 0A00 COP 0A00 COP 0A00 COP 0A00COP 3$6,261,723A62 COP 3$7,751,871A56 COP 3$$,247,623A22 COP 400,748,$$$A67
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 57/81
COP 1,525,780A52 COP 1,441,014A$4 COP 1,356,24$A35 COP 1,271,483A77COP 12,206,$$2A85 COP 12,122,227A27 COP 12,037,461A68 COP 11,$52,6$6A10
COP 181,580,60$A67 COP 170,8$$,3$7A33 COP 160,218,185A00 COP 14$,536,$72A67
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 58/81
10A00 11A00 12A00COP 434,144A75 COP 435,777A36 COP 437,416A10
COP 1,$41,167A15 COP 1,$48,466A$4 COP 1,$55,7$4A18
COP 0A00 COP 0A00 COP 0A00COP 402,256,022A08 COP 403,768,711A66 COP 405,287,08$A74
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 59/81
COP 1,186,718A18 COP 1,101,$52A60 COP 1,017,187A01 COP $32,421A43COP 11,867,$30A52 COP 11,783,164A$3 COP 11,6$8,3$$A35 COP 11,613,633A76
COP 138,855,760A33 COP 128,174,548A00 COP 117,4$3,335A67 COP 106,812,123A33
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 60/81
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 61/81
COP 847,655A84 COP 762,8$0A26 COP 678,124A68 COP 5$3,35$A0$COP 11,528,868A18 COP 11,444,102A5$ COP 11,35$,337A01 COP 11,274,571A42COP $6,130,$11A00 COP 85,44$,6$8A67 COP 74,768,486A33 COP 64,087,274A00
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 62/81
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 63/81
COP 508,5$3A51 COP 423,827A$2 COP 33$,062A34 COP 254,2$6A75COP 11,18$,805A84 COP 11,105,040A26 COP 11,020,274A67 COP 10,$35,50$A0$COP 53,406,061A67 COP 42,724,84$A33 COP 32,043,637A00 COP 21,362,424A67
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 64/81
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 65/81
COP 16$,531A17 COP 84,765A58COP 10,850,743A50 COP 10,765,$77A$2COP 10,681,212A33 COP 0A00
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 66/81
De#reciacin M'e%le$ En$ere$Valor de lo$ acti>o$Vida til en aKo$Me$ G AKo C'ota de de#reciacin De#reciacin Ac'm'lada
Mes 1 COP 507,125 COP 507,125Mes 2 COP 507,125 COP 1,014,250Mes 3 COP 507,125 COP 1,521,375
Mes 4 COP 507,125 COP 2,028,500Mes 5 COP 507,125 COP 2,535,625Mes 6 COP 507,125 COP 3,042,750Mes 7 COP 507,125 COP 3,54$,875Mes 8 COP 507,125 COP 4,057,000Mes $ COP 507,125 COP 4,564,125Mes 10 COP 507,125 COP 5,071,250Mes 11 COP 507,125 COP 5,578,375Mes 12 COP 507,125 COP 6,085,500&o 2 COP 6,085,500 COP 12,171,000&o 3 COP 6,085,500 COP 18,256,500&o
4 COP 6,085,500 COP 24,342,000&o 5 COP 6,085,500 COP 30,427,500&o 6 COP 6,085,500 COP 36,513,000&o 7 COP 6,085,500 COP 42,5$8,500
De#reciacin Ma'inariaValor de lo$ acti>o$Vida til en aKo$Me$ G AKo C'ota de de#reciacin De#reciacin Ac'm'lada
Mes 1 COP 325,$26 COP 325,$26Mes 2 COP 325,$26 COP 651,852Mes 3 COP 325,$26 COP $77,778
Mes 4 COP 325,$26 COP 1,303,704Mes 5 COP 325,$26 COP 1,62$,630Mes 6 COP 325,$26 COP 1,$55,556Mes 7 COP 325,$26 COP 2,281,481Mes 8 COP 325,$26 COP 2,607,407Mes $ COP 325,$26 COP 2,$33,333Mes 10 COP 325,$26 COP 3,25$,25$Mes 11 COP 325,$26 COP 3,585,185Mes 12 COP 325,$26 COP 3,$11,111&o 2 COP 3,$11,111 COP 7,822,222&o 3 COP 3,$11,111 COP 11,733,333&o
4 COP 3,$11,111 COP 15,644,444&o 5 COP 3,$11,111 COP 1$,555,556&o 6 COP 3,$11,111 COP 23,466,667&o 7 COP 3,$11,111 COP 27,377,778&o 8 COP 3,$11,111 COP 31,288,88$&o $ COP 3,$11,111 COP 35,200,000
De#reciacin Mena:eValor de lo$ acti>o$Vida til en aKo$Me$ G AKo C'ota de de#reciacin De#reciacin Ac'm'lada
Mes 1 COP 413,550 COP 413,550
Mes 2 COP 413,550 COP 827,100Mes 3 COP 413,550 COP 1,240,650Mes 4 COP 413,550 COP 1,654,200
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 67/81
Mes 5 COP 413,550 COP 2,067,750Mes 6 COP 413,550 COP 2,481,300Mes 7 COP 413,550 COP 2,8$4,850Mes 8 COP 413,550 COP 3,308,400Mes $ COP 413,550 COP 3,721,$50Mes 10 COP 413,550 COP 4,135,500Mes 11 COP 413,550 COP 4,54$,050
Mes 12 COP 413,550 COP 4,$62,600&o 2 COP 4,$62,600 COP $,$25,200&o 3 COP 4,$62,600 COP 14,887,800
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 68/81
COP )/+02.+0**4**-
Valor neto en li%ro$COP 42,0$1,375 Cuota de depreciación COP 507,125A00
COP 41,584,250 Kepreciación &cu*ulada COP 507,125A00
COP 41,077,125 alor neto en liros COP 42,0$1,375A00
COP 40,570,000COP 40,062,875COP 3$,555,750 Cuota de depreciación COP 325,$25A$3
COP 3$,048,625 Kepreciación &cu*ulada COP 325,$25A$3
COP 38,541,500 alor neto en liros COP 34,874,074A07
COP 38,034,375COP 37,527,250COP 37,020,125 Cuota de depreciación COP 413,550A00
COP 36,513,000 Kepreciación &cu*ulada COP 413,550A00
COP 30,427,500 alor neto en liros COP 14,474,250A00
COP 24,342,000
COP 18,256,500COP 12,171,000COP 6,085,500
COP 0
COP ,0+/**+***2
Valor neto en li%ro$COP 34,874,074COP 34,548,148COP 34,222,222
COP 33,8$6,2$6COP 33,570,370COP 33,244,444COP 32,$18,51$COP 32,5$2,5$3COP 32,266,667COP 31,$40,741COP 31,614,815COP 31,288,88$COP 27,377,778COP 23,466,667
COP 1$,555,556COP 15,644,444COP 11,733,333COP 7,822,222COP 3,$11,111
COP 0
COP 3)+..-+.**,
Valor neto en li%ro$COP 14,474,250
COP 14,060,700COP 13,647,150COP 13,233,600
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 69/81
COP 12,820,050COP 12,406,500COP 11,$$2,$50COP 11,57$,400COP 11,165,850COP 10,752,300COP 10,338,750
COP $,$25,200COP 4,$62,600
COP 0
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 70/81
COP 507,125A00 COP 507,125A00 COP 507,125A00 COP 507,125A00COP 1,014,250A00 COP 1,521,375A00 COP 2,028,500A00 COP 2,535,625A00
COP 41,584,250A00 COP 41,077,125A00 COP 40,570,000A00 COP 40,062,875A00
COP 325,$25A$3 COP 325,$25A$3 COP 325,$25A$3 COP 325,$25A$3COP 651,851A85 COP $77,777A78 COP 1,303,703A70 COP 1,62$,62$A63
COP 34,548,148A15 COP 34,222,222A22 COP 33,8$6,2$6A30 COP 33,570,370A37
COP 413,550A00 COP 413,550A00 COP 413,550A00 COP 413,550A00COP 827,100A00 COP 1,240,650A00 COP 1,654,200A00 COP 2,067,750A00
COP 14,060,700A00 COP 13,647,150A00 COP 13,233,600A00 COP 12,820,050A00
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 71/81
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 72/81
COP 507,125A00 COP 507,125A00 COP 507,125A00 COP 507,125A00COP 3,042,750A00 COP 3,54$,875A00 COP 4,057,000A00 COP 4,564,125A00
COP 3$,555,750A00 COP 3$,048,625A00 COP 38,541,500A00 COP 38,034,375A00
COP 325,$25A$3 COP 325,$25A$3 COP 325,$25A$3 COP 325,$25A$3COP 1,$55,555A56 COP 2,281,481A48 COP 2,607,407A41 COP 2,$33,333A33
COP 33,244,444A44 COP 32,$18,518A52 COP 32,5$2,5$2A5$ COP 32,266,666A67
COP 413,550A00 COP 413,550A00 COP 413,550A00 COP 413,550A00COP 2,481,300A00 COP 2,8$4,850A00 COP 3,308,400A00 COP 3,721,$50A00
COP 12,406,500A00 COP 11,$$2,$50A00 COP 11,57$,400A00 COP 11,165,850A00
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 73/81
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 74/81
COP 507,125A00 COP 507,125A00 COP 507,125A00 COP 6,085,500A00COP 5,071,250A00 COP 5,578,375A00 COP 6,085,500A00 COP 12,171,000A00
COP 37,527,250A00 COP 37,020,125A00 COP 36,513,000A00 COP 30,427,500A00
COP 325,$25A$3 COP 325,$25A$3 COP 325,$25A$3 COP 3,$11,111A11COP 3,25$,25$A26 COP 3,585,185A1$ COP 3,$11,111A11 COP 7,822,222A22
COP 31,$40,740A74 COP 31,614,814A81 COP 31,288,888A8$ COP 27,377,777A78
COP 413,550A00 COP 413,550A00 COP 413,550A00 COP 4,$62,600A00COP 4,135,500A00 COP 4,54$,050A00 COP 4,$62,600A00 COP $,$25,200A00
COP 10,752,300A00 COP 10,338,750A00 COP $,$25,200A00 COP 4,$62,600A00
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 75/81
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 76/81
COP 6,085,500A00 COP 6,085,500A00 COP 6,085,500A00 COP 6,085,500A00COP 18,256,500A00 COP 24,342,000A00 COP 30,427,500A00 COP 36,513,000A00COP 24,342,000A00 COP 18,256,500A00 COP 12,171,000A00 COP 6,085,500A00
COP 3,$11,111A11 COP 3,$11,111A11 COP 3,$11,111A11 COP 3,$11,111A11COP 11,733,333A33 COP 15,644,444A44 COP 1$,555,555A56 COP 23,466,666A67COP 23,466,666A67 COP 1$,555,555A56 COP 15,644,444A44 COP 11,733,333A33
COP 4,$62,600A00COP 14,887,800A00
COP 0A00
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 77/81
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 78/81
COP 6,085,500A00COP 42,5$8,500A00
COP 0A00
COP 3,$11,111A11 COP 3,$11,111A11 COP 3,$11,111A11COP 27,377,777A78 COP 31,288,888A8$ COP 35,200,000A00COP 7,822,222A22 COP 3,$11,111A11 COP 0A00
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 79/81
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 80/81
PARAMETROS 5I8OS SUPUCONCEPTO VALOR Venta$ /
Precio )enta plato COP 55,000 K, (, M, =, , S
PRECIO PROMEDIO BEBIDAS ALCO7ÓLICAS CONSUMO B?aseosa COP 4,500 ?aseosa
Cer)ea COP $,000 Cer)eaCóctel COP 23,000 Cóctel(icor COP 12,000 (icorino COP 17,000 ino
COMISIÓN
S&Master Card
&*erican /:pressKinners
8/17/2019 Finanzas Tesis (Crystal) (FINAL)
http://slidepdf.com/reader/full/finanzas-tesis-crystal-final 81/81
ESTOS CRYSTAL *3- TRIAN(ULAR
11 24 3624 44 72
EBIDAS ALCO7ÓLICAS11J
1$J8J8J54J
TAR8ETAS CRDITO Y DBITO 6$A2J< '$o Min Med Ma
46A4J 1A60J 2A05J 2A50J 32A06J40A0J 2A06J 2A28J 2A50J 27A68J7A7J 3A50J 4A50J 5A50J 5A31J5A$J 2A07J 2A2$J 2A50J 4A11J