Simulador EHS
Transcript of Simulador EHS
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 1/40
Tabla de amortización
CAPITAL 600,000,000
TASA MENSUAL 0.99%
PERIOOS 36
PERIOO SALO INICIAL CUOTA INTERESES1 600,000,000.00 22,606,666.67 5,940,000.00
2 583,333,333.33 22,441,666.67 5,775,000.00
3 566,666,666.67 22,276,666.67 5,610,000.00
4 550,000,000.00 22,111,666.67 5,445,000.00
5 533,333,333.33 21,946,666.67 5,280,000.00
6 516,666,666.67 21,781,666.67 5,115,000.00
7 500,000,000.00 21,616,666.67 4,950,000.00
8 483,333,333.33 21,451,666.67 4,785,000.00
9 466,666,666.67 21,286,666.67 4,620,000.0010 450,000,000.00 21,121,666.67 4,455,000.00
11 433,333,333.33 20,956,666.67 4,290,000.00
12 416,666,666.67 20,791,666.67 4,125,000.00
13 400,000,000.00 20,626,666.67 3,960,000.00
14 383,333,333.33 20,461,666.67 3,795,000.00
15 366,666,666.67 20,296,666.67 3,630,000.00
16 350,000,000.00 20,131,666.67 3,465,000.00
17 333,333,333.33 19,966,666.67 3,300,000.00
18 316,666,666.67 19,801,666.67 3,135,000.00
19 300,000,000.00 19,636,666.67 2,970,000.0020 283,333,333.33 19,471,666.67 2,805,000.00
21 266,666,666.67 19,306,666.67 2,640,000.00
22 250,000,000.00 19,141,666.67 2,475,000.00
23 233,333,333.33 18,976,666.67 2,310,000.00
24 216,666,666.67 18,811,666.67 2,145,000.00
25 200,000,000.00 18,646,666.67 1,980,000.00
26 183,333,333.33 18,481,666.67 1,815,000.00
27 166,666,666.67 18,316,666.67 1,650,000.00
28 150,000,000.00 18,151,666.67 1,485,000.00
29 133,333,333.33 17,986,666.67 1,320,000.0030 116,666,666.67 17,821,666.67 1,155,000.00
31 100,000,000.00 17,656,666.67 990,000.00
32 83,333,333.33 17,491,666.67 825,000.00
33 66,666,666.67 17,326,666.67 660,000.00
34 50,000,000.00 17,161,666.67 495,000.00
35 33,333,333.33 16,996,666.67 330,000.00
36 16,666,666.67 16,831,666.67 165,000.00
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 2/40
60,390,000,00
109,890,00,00
SUMATORIA INTERESESPRIMER A!O
SUMATORIA INTERESESTOTALES
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 3/40
fija a capital
AMORTI"ACI#N SALO $INAL CUOTA ECRECIENTE 16,666,666.67 583,333,333.33 165,000.00
16,666,666.67 566,666,666.67 165,000.00
16,666,666.67 550,000,000.00 165,000.00
16,666,666.67 533,333,333.33 165,000.00
16,666,666.67 516,666,666.67 165,000.00
16,666,666.67 500,000,000.00 165,000.00
16,666,666.67 483,333,333.33 165,000.00
16,666,666.67 466,666,666.67 165,000.00
16,666,666.67 450,000,000.00 165,000.0016,666,666.67 433,333,333.33 165,000.00
16,666,666.67 416,666,666.67 165,000.00
16,666,666.67 400,000,000.00 165,000.00
16,666,666.67 383,333,333.33 165,000.00
16,666,666.67 366,666,666.67 165,000.00
16,666,666.67 350,000,000.00 165,000.00
16,666,666.67 333,333,333.33 165,000.00
16,666,666.67 316,666,666.67 165,000.00
16,666,666.67 300,000,000.00
16,666,666.67 283,333,333.3316,666,666.67 266,666,666.67
16,666,666.67 250,000,000.00
16,666,666.67 233,333,333.33
16,666,666.67 216,666,666.67
16,666,666.67 200,000,000.00
16,666,666.67 183,333,333.33
16,666,666.67 166,666,666.67
16,666,666.67 150,000,000.00
16,666,666.67 133,333,333.33
16,666,666.67 116,666,666.6716,666,666.67 100,000,000.00
16,666,666.67 83,333,333.33
16,666,666.67 66,666,666.67
16,666,666.67 50,000,000.00
16,666,666.67 33,333,333.33
16,666,666.67 16,666,666.67
16,666,666.67 - 0.00
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 4/40
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 5/40
Autora: Doris Amalia Alba Sán!"#
Dir"tora urso $at"mátia inani"ra
&ni'"rsi(a( )aional Abi"rta * a Distania &)AD
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 6/40
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 7/40
TABLA DE AMORTIZACIÓN PAGO A CUO
CAPITAL 600,000,000
TASA PERIODICA MENSUAL 1.20%
PERIODOS 18
PAGO
PERIODO SALDO INICIAL CUOTA INTERESES1 $ 600,000,000.00 $37,261,665.40 $ 7,200,000.00
2 $ 569,938,334.60 $ 37,261,665.40 $ 6,839,260.02
3 $ 539,515,929.21 $ 37,261,665.40 $ 6,474,191.15
4 $ 508,728,454.96 $ 37,261,665.40 $ 6,104,741.46
5 $ 477,571,531.02 $ 37,261,665.40 $ 5,730,858.37
6 $ 446,040,723.99 $ 37,261,665.40 $ 5,352,488.69
7 $ 414,131,547.28 $ 37,261,665.40 $ 4,969,578.57
8 $ 381,839,460.45 $ 37,261,665.40 $ 4,582,073.53
9 $ 349,159,868.57 $ 37,261,665.40 $ 4,189,918.42
10 $ 316,088,121.59 $ 37,261,665.40 $ 3,793,057.46
11 $ 282,619,513.65 $ 37,261,665.40 $ 3,391,434.16
12 $ 248,749,282.41 $ 37,261,665.40 $ 2,984,991.39
13 $ 214,472,608.40 $ 37,261,665.40 $ 2,573,671.30
14 $ 179,784,614.30 $ 37,261,665.40 $ 2,157,415.37
15 $ 144,680,364.27 $ 37,261,665.40 $ 1,736,164.37
16 $ 109,154,863.24 $ 37,261,665.40 $ 1,309,858.36
17 $ 73,203,056.20 $ 37,261,665.40 $ 878,436.67
18 $ 36,819,827.47 $ 37,261,665.40 $ 441,837.93
$ 61,612,593.21
$ 70,709,977.22
SUMATORIA INTERESESPRIMER AÑO
SUMATORIA INTERESESTOTALES
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 8/40
A FIJA Autora: Doris Amalia Alba Sán!"#
Dir"tora urso $at"mátia inani
&ni'"rsi(a( )aional Abi"rta * a D
AMORTIZACIÓN SALDO FINAL $ 30,061,665.40 $ 569,938,334.60
$ 30,422,405.39 $ 539,515,929.21
$ 30,787,474.25 $ 508,728,454.96
$ 31,156,923.94 $ 477,571,531.02
$ 31,530,807.03 $ 446,040,723.99
$ 31,909,176.71 $ 414,131,547.28
$ 32,292,086.83 $ 381,839,460.45
$ 32,679,591.88 $ 349,159,868.57
$ 33,071,746.98 $ 316,088,121.59
$ 33,468,607.94 $ 282,619,513.65
$ 33,870,231.24 $ 248,749,282.41
$ 34,276,674.01 $ 214,472,608.40
$ 34,687,994.10 $ 179,784,614.30
$ 35,104,250.03 $ 144,680,364.27
$ 35,525,501.03 $ 109,154,863.24
$ 35,951,807.04 $ 73,203,056.20
$ 36,383,228.73 $ 36,819,827.47
$ 36,819,827.47 $ -
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 9/40
"ra
stania &)AD
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 10/40
Tabla de amortización pa%o a c&ota a c&ota fija c
CAPITAL 600,000,000
TASA MENSUAL 1.28%
PERIOOS 12
PERIOO SALO INICIAL CUOTA INTERESES1 + 600,000,000.00 + - + -
2 + 600,000,000.00 + 54,256,963.94 + 7,680,000.00
3 + 553,423,036.06 + 54,256,963.94 + 7,083,814.86
4 + 506,249,886.99 + 54,256,963.94 + 6,479,998.55
5 + 458,472,921.60 + 54,256,963.94 + 5,868,453.40
6 + 410,084,411.06 + 54,256,963.94 + 5,249,080.46
7 + 361,076,527.59 + 54,256,963.94 + 4,621,779.55
8 + 311,441,343.20 + 54,256,963.94 + 3,986,449.19
9 + 261,170,828.46 + 54,256,963.94 + 3,342,986.6010 + 210,256,851.13 + 54,256,963.94 + 2,691,287.69
11 + 158,691,174.89 + 54,256,963.94 + 2,031,247.04
12 + 106,465,457.99 + 54,256,963.94 + 1,362,757.86
13 + 53,571,251.91 + 54,256,963.94 + 685,712.02
0 + - + - + -
0 + - + - + -
0 + - + - + -
0 + - + - + -
0 + - + - + -
0 + - + - + -0 + - + - + -
0 + - + - + -
0 + - + - + -
0 + - + - + -
0 + - + - + -
51083567.24
107984273.49
SUMATORIA INTERESES
PRIMER AÑO
SUMATORIA INTERESESTOTALES
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 11/40
n periodo de %racia Autora: Doris Amalia Alba Sán!"#
Dir"tora urso $at"mátia inani"ra
PERIOO E 'RACIA 1 &ni'"rsi(a( )aional Abi"rta * a Distania &)AD
PERIOOS TOTALES 0
AMORTI"ACI#N SALO $INAL + - + 600,000,000.00
+ 46,576,963.94 + 553,423,036.06
+ 47,173,149.08 + 506,249,886.99
+ 47,776,965.38 + 458,472,921.60
+ 48,388,510.54 + 410,084,411.06
+ 49,007,883.48 + 361,076,527.59
+ 49,635,184.38 + 311,441,343.20
+ 50,270,514.74 + 261,170,828.46
+ 50,913,977.33 + 210,256,851.13+ 51,565,676.24 + 158,691,174.89
+ 52,225,716.90 + 106,465,457.99
+ 52,894,206.07 + 53,571,251.91
+ 53,571,251.91 + -
+ - + -
+ - + -
+ - + -
+ - + -
+ - + -
+ - + -+ - + -
+ - + -
+ - + -
+ - + -
+ - + -
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 12/40
Tabla de amortización pa%o a c&ota fija c
CAPITAL -
TASA MENSUAL 0.00%
PERIOOS AMORTI"ACION 0
PERIOO SALO INICIAL CUOTA INTERESES1 + - + - + -
0 + - + - + -
0 + - + - + -
0 + - + - + -
0 + - + - + -
0 + - + - + -
0 + - + - + -
0 + - + - + -
0 + - + - + -0 + - + - + -
0 + - + - + -
0 + - + - + -
0 + - + - + -
0 + - + - + -
0 + - + - + -
0 + - + - + -
0 + - + - + -
0 + - + - + -
+ -
+ -
SUMATORIA INTERESESPRIMER A!O
SUMATORIA INTERESESTOTALES
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 13/40
n periodo m&erto
PERIOO MUERTO 1
PERIOOS TOTALES 1 Autora: Doris Amalia Alba Sán!"#
CAPITAL AMORTI"AR +0.00 Dir"tora urso $at"mátia inani
&ni'"rsi(a( )aional Abi"rta * a Di
AMORTI"ACI#N SALO $INAL + - + -
+ - + -
+ - + -
+ - + -
+ - + -
+ - + -
+ - + -
+ - + -
+ - + -+ - + -
+ - + -
+ - + -
+ - + -
+ - + -
+ - + -
+ - + -
+ - + -
+ - + -
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 14/40
"ra
stania &)AD
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 15/40
E(tado de re(<ado(
CUENTA )*+,INCREMENTO
nr"sos or /"ntas + - + -
osto (" '"ntas + - + -
&tili(a( bruta + -
astos o"raional"s + -&tili(a( o"raional + -
+ -
&tili(a( ant"s (" imu"stos + -
mu"stos + -
&tili(a( n"ta + -
astos inani"ros s" obti"n"n on la sumatoria (" los
int"r"s"s ("l rim"r ao (" la tabla (" amorti#ain
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 16/40
Autora: Doris Amalia Alba Sán!"#
ESTAO E RESULTAOS A-USTAO Dir"tora urso $at"mátia inani
+ - &ni'"rsi(a( )aional Abi"rta * a Di
+ -
+ -
+ -+ -
0
+ -
+ -
+ -
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 17/40
"ra
stania &)AD
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 18/40
TA.L
MONTO SOLICITAO
Nombre( / apellido( inte%rante del %r&po 0ili%encie en el c&adro(i%&iente el nombre completo de 1&ien comparte la tabla2
TASA INTERESE$ECTI3AMENSUAL
PERIOO E
'RACIA
PERIOO
MUERTO
AMORTI"ACION $I-A ACAPITAL
AMORTI"ACION PA'OCUOTA $I-A
CUOTA $I-A CONPERIOO E 'RACIA
CUOTA $I-A CONPERIOO MUERTO
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 19/40
RESUMEN E AMORTI"ACIONES
CUOTA MENSUAL INTERESES TOTALESTOTAL
PERIOOS
INTERESES PRIMER
A!O
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 20/40
IMPUESTOS UTILIA
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 21/40
ato( E(perado
3ol&men de 4enta( en &nidade( 5 67789:9;**Precio Unitario 5 +8*)+;**
Co(to Unitario 5 6,9;**
Co(to fijo 5 +:98<7*8,:*;**3alor re(id&al 5 +89**8***;**In4er(ión 5 +9*8***8***;**Ta(a de de(c&ento *;++
ubros0
nr"sos + -
/"ntas
/alor r"si(ual
r"sos 5 +9*8***8***;**
Co(to fijoosto 'ariabl"
n'"rsin 5 +9*8***8***;**
$l&jo Neto =5 +9*8***8***;**
Indicadore( de e4al&ación3AN 5 )*<8*+98<*);*+TIR 66>
R.?C@ 5 );:7
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 22/40
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 23/40
$LU-O E $ONOS
CASO 5 67789:9;**5 +8*)+;**
5 6,9;**
++ >
1 2 3
+ 702,994,235.00 + 702,994,235.00 + 702,994,235.00
+ 702,994,235.00 + 702,994,235.00 + 702,994,235.00
+ 579,885,505.00 + 593,463,548.00 + 608,399,395.30
5 +:98<7*8,:*;** 5 +,B8:978,<:;** 5 +6,8)B,8:)*;:*+ 444,105,075.00 + 444,105,075.00 + 444,105,075.00
5 +):8+*78<:*;** 5 +*B89:*867<;** 5 B,89B,87:B;<*
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 24/40
D/0; < D/0;
D/0;
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 25/40
Autora: Doris Amalia Alba Sán!"#
Dir"tora urso $at"mátia inani"ra
&ni'"rsi(a( )aional Abi"rta * a Distania &)AD
4 5
+ 702,994,235.00 + 704,494,235.00
+ 702,994,235.00 + 702,994,235.00
5 +89**8***;**
+ 624,828,827.33 + 642,901,202.56
5 +7*8<):8<9);:: 5 +B78<B68+)<;96+ 444,105,075.00 + 444,105,075.00
5 <78+698,*<;6< 5 6+89B:8*:);,,
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 26/40
< D/0;
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 27/40
Datos s"ra(o
3ol&men de 4enta( en &nidade( 5 69*8***;**
Precio Unitario 5 +8+**;**
Co(to Unitario 5 <7*;**Co(to fijo 5 +:98<7*8,:*;**
3alor re(id&al 5 +89**8***;**
In4er(ión 5 +9*8***8***;**
Ta(a de de(c&ento *;+:
ubros0
nr"sos + -
/"ntas
/alor r"si(ual
r"sos + 150,000,000.00
Co(to fijo
osto 'ariabl"
n'"rsin 5 +9*8***8***;**
$l&jo Neto =5 +9*8***8***;**
Indicadore( de e4al&ación3AN 5 76B89,,;76
TIR +:> R.?C@ 5 +
CON ECEL R.?C@ 5 +
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 28/40
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 29/40
$LU-O E $ONOS
CASO :5 69*8***;**
5 +8+**;**
5 <7*;**
5+9*;***;***8** tercer ao
13 %
1 2 3
+ 715,000,000.00 + 715,000,000.00 + 715,000,000.00
+ 715,000,000.00 + 715,000,000.00 + 715,000,000.00
+ 642,780,430.00 + 642,780,430.00 + 792,780,430.00
5 +:98<7*8,:*;** 5 +:98<7*8,:*;** 5 +:98<7*8,:*;**
+ 507,000,000.00 + 507,000,000.00 + 507,000,000.00
5 +9*8***8***;**
5 <)8)+B89<*;** 5 <)8)+B89<*;** =5 <<8<7*8,:*;**
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 30/40
D/0; < D/0;
D/0;
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 31/40
Autora: Doris Amalia Alba Sán!"#
Dir"tora urso $at"mátia inani"ra
&ni'"rsi(a( )aional Abi"rta * a Distania &)AD
4 5
+ 715,000,000.00 + 716,500,000.00
+ 715,000,000.00 + 715,000,000.00
+ 1,500,000.00
+ 642,780,430.00 + 642,780,430.00
5 +:98<7*8,:*;** 5 +:98<7*8,:*;**
+ 507,000,000.00 + 507,000,000.00
5 <)8)+B89<*;** 5 <:8<+B89<*;**
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 32/40
< D/0;
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 33/40
RELACI#N .ENE$ICIO COSTO
=os b"n"iios u"("n ("inirs" omo "l 'alor r"s"nt" (" los lu>os n"tos (" a>a uan(o son ositi'os
3P. @ + 72,219,570.00 D + 72,219,570.001< 0.13 1 1< 0.13 2
3P. @ + 72,219,570.00 D + 72,219,570.00
1.13 1 1.13 2
3P. @ + 72,219,570.00 D + 72,219,570.00
1.13 1.28
3P.@ + 63,911,123.89 D + 56,558,516.72
3P.@ 5 )*,8<<98)7,;9*
=os ostos u"("n ("inirs" omo "l 'alor r"s"nt" (" los lu>os n"tos (" a>a uan(o son n"ati'os
3PC@ 5 +9*8***8***;** D + 77,780,430.00
1< 0.13 3
3PC@ 5 +9*8***8***;** D + 77,780,430.00
1.13 3
3PC@ 5 +9*8***8***;** D + 77,780,430.00
1.44
3PC@ 5 +9*8***8***;** D + 53,905,739.63
3PC@ 5 )*:8B*98<:B;6:
=a r"lain ?"n"iio osto s" alula : ?
R.?C@ +
/@?
/1<in
/@/1<in
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 34/40
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 35/40
D + 72,219,570.00 D + 73,719,570.001< 0.13 4 1< 0.13 5
D + 72,219,570.00 D + 73,719,570.00
1.13 4 1.13 5
D + 72,219,570.00 D + 73,719,570.00
1.63 1.84
D + 44,293,614.79 D + 40,012,029.10
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 36/40
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 37/40
TABLA RESUMEN DE ESCENARIOS PROPUESTOS PARA ESTIMACION DE
Precio Unitario Costo Unitario AN
Caso !
Caso "
Caso #
Caso $
Caso %
No&'res ( a)e**i+os inte,rante +e* ,r-)o .Di*i,encie en e* c-a+rosi,-iente e* no&'re co&)*eto +e /-ien co&)arte *a ta'*a0
o*-&en +e 1entas en
-ni+a+es
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 38/40
Caso 2
Caso 3
Caso 4
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 39/40
INDICADORES
TIR RB5C TASA DESCUENTO
8/15/2019 Simulador EHS
http://slidepdf.com/reader/full/simulador-ehs 40/40