fcl-iiia

13
Datos Iniciale Valor Inversión ### Pesos i 1.5% EM n 60 meses 5 años Periodo Inversón Cuota Interes Capital 0 ### 1 $197,921,314.51 ### $3,000,000.00 $2,078,685.49 2 $195,811,448.75 ### $2,968,819.72 $2,109,865.77 3 $193,669,934.99 ### $2,937,171.73 $2,141,513.75 4 $191,496,298.53 ### $2,905,049.02 $2,173,636.46 5 $189,290,057.52 ### $2,872,444.48 $2,206,241.01 6 $187,050,722.90 ### $2,839,350.86 $2,239,334.62 7 $184,777,798.26 ### $2,805,760.84 $2,272,924.64 8 $182,470,779.75 ### $2,771,666.97 $2,307,018.51 9 $180,129,155.96 ### $2,737,061.70 $2,341,623.79 10 $177,752,407.81 ### $2,701,937.34 $2,376,748.15 11 $175,340,008.45 ### $2,666,286.12 $2,412,399.37 12 $172,891,423.09 ### $2,630,100.13 $2,448,585.36 13 $170,406,108.95 ### $2,593,371.35 $2,485,314.14 14 $167,883,515.10 ### $2,556,091.63 $2,522,593.85 15 $165,323,082.34 ### $2,518,252.73 $2,560,432.76 16 $162,724,243.09 ### $2,479,846.24 $2,598,839.25 17 $160,086,421.25 ### $2,440,863.65 $2,637,821.84 18 $157,409,032.08 ### $2,401,296.32 $2,677,389.17 19 $154,691,482.08 ### $2,361,135.48 $2,717,550.00 20 $151,933,168.82 ### $2,320,372.23 $2,758,313.25 21 $149,133,480.87 ### $2,278,997.53 $2,799,687.95 22 $146,291,797.60 ### $2,237,002.21 $2,841,683.27 23 $143,407,489.08 ### $2,194,376.96 $2,884,308.52 24 $140,479,915.93 ### $2,151,112.34 $2,927,573.15 25 $137,508,429.18 ### $2,107,198.74 $2,971,486.75 26 $134,492,370.13 ### $2,062,626.44 $3,016,059.05 27 $131,431,070.20 ### $2,017,385.55 $3,061,299.93 28 $128,323,850.77 ### $1,971,466.05 $3,107,219.43 29 $125,170,023.04 ### $1,924,857.76 $3,153,827.72 30 $121,968,887.90 ### $1,877,550.35 $3,201,135.14 31 $118,719,735.74 ### $1,829,533.32 $3,249,152.17 32 $115,421,846.29 ### $1,780,796.04 $3,297,889.45 33 $112,074,488.50 ### $1,731,327.69 $3,347,357.79 34 $108,676,920.34 ### $1,681,117.33 $3,397,568.16 35 $105,228,388.66 ### $1,630,153.81 $3,448,531.68 36 $101,728,129.00 ### $1,578,425.83 $3,500,259.66

Upload: marcela-martinez-diaz

Post on 16-Aug-2015

212 views

Category:

Documents


0 download

TRANSCRIPT

Datos Iniciales ValorInversin$ 200,000,000.00Pesosi 1.5%EMn 60 meses 5Periodo Inversn Cota Interes0$ 200,000,000.00 1 $1!",!21,#1$.51 $5,0"%,6%5.$! $ #,000,000.00 2 $1!5,%11,$$%."5 $5,0"%,6%5.$! $ 2,!6%,%1!."2 # $1!#,66!,!#$.!! $5,0"%,6%5.$! $ 2,!#",1"1."# $ $1!1,$!6,2!%.5# $5,0"%,6%5.$! $ 2,!05,0$!.02 5 $1%!,2!0,05".52 $5,0"%,6%5.$! $ 2,%"2,$$$.$% 6 $1%",050,"22.!0 $5,0"%,6%5.$! $ 2,%#!,#50.%6 " $1%$,""","!%.26 $5,0"%,6%5.$! $ 2,%05,"60.%$ % $1%2,$"0,""!."5 $5,0"%,6%5.$! $ 2,""1,666.!" ! $1%0,12!,155.!6 $5,0"%,6%5.$! $ 2,"#",061."0 10 $1"","52,$0".%1 $5,0"%,6%5.$! $ 2,"01,!#".#$ 11 $1"5,#$0,00%.$5 $5,0"%,6%5.$! $ 2,666,2%6.12 12 $1"2,%!1,$2#.0! $5,0"%,6%5.$! $ 2,6#0,100.1# 1# $1"0,$06,10%.!5 $5,0"%,6%5.$! $ 2,5!#,#"1.#5 1$ $16",%%#,515.10 $5,0"%,6%5.$! $ 2,556,0!1.6# 15 $165,#2#,0%2.#$ $5,0"%,6%5.$! $ 2,51%,252."# 16 $162,"2$,2$#.0! $5,0"%,6%5.$! $ 2,$"!,%$6.2$ 1" $160,0%6,$21.25 $5,0"%,6%5.$! $ 2,$$0,%6#.65 1% $15",$0!,0#2.0% $5,0"%,6%5.$! $ 2,$01,2!6.#2 1! $15$,6!1,$%2.0% $5,0"%,6%5.$! $ 2,#61,1#5.$% 20 $151,!##,16%.%2 $5,0"%,6%5.$! $ 2,#20,#"2.2# 21 $1$!,1##,$%0.%" $5,0"%,6%5.$! $ 2,2"%,!!".5# 22 $1$6,2!1,"!".60 $5,0"%,6%5.$! $ 2,2#",002.21 2# $1$#,$0",$%!.0% $5,0"%,6%5.$! $ 2,1!$,#"6.!6 2$ $1$0,$"!,!15.!# $5,0"%,6%5.$! $ 2,151,112.#$ 25 $1#",50%,$2!.1% $5,0"%,6%5.$! $ 2,10",1!%."$ 26 $1#$,$!2,#"0.1# $5,0"%,6%5.$! $ 2,062,626.$$ 2" $1#1,$#1,0"0.20 $5,0"%,6%5.$! $ 2,01",#%5.55 2% $12%,#2#,%50."" $5,0"%,6%5.$! $ 1,!"1,$66.05 2! $125,1"0,02#.0$ $5,0"%,6%5.$! $ 1,!2$,%5"."6 #0 $121,!6%,%%".!0 $5,0"%,6%5.$! $ 1,%"",550.#5 #1 $11%,"1!,"#5."$ $5,0"%,6%5.$! $ 1,%2!,5##.#2 #2 $115,$21,%$6.2! $5,0"%,6%5.$! $ 1,"%0,"!6.0$ ## $112,0"$,$%%.50 $5,0"%,6%5.$! $ 1,"#1,#2".6! #$ $10%,6"6,!20.#$ $5,0"%,6%5.$! $ 1,6%1,11".## #5 $105,22%,#%%.66 $5,0"%,6%5.$! $ 1,6#0,15#.%1 #6 $101,"2%,12!.00 $5,0"%,6%5.$! $ 1,5"%,$25.%# #" $!%,1"5,#65.$5 $5,0"%,6%5.$! $ 1,525,!21.!$ #% $!$,56!,#10.$5 $5,0"%,6%5.$! $ 1,$"2,6#0.$% #! $!0,!0!,16$.62 $5,0"%,6%5.$! $ 1,$1%,5#!.66 $0 $%",1!$,116.60 $5,0"%,6%5.$! $ 1,#6#,6#".$" $1 $%#,$2#,#$2.%" $5,0"%,6%5.$! $ 1,#0",!11."5 $2 $"!,5!6,00".52 $5,0"%,6%5.$! $ 1,251,#50.1$ $# $"5,"11,262.15 $5,0"%,6%5.$! $ 1,1!#,!$0.11 $$ $"1,"6%,2$5.60 $5,0"%,6%5.$! $ 1,1#5,66%.!# $5 $6","66,0%#.%0 $5,0"%,6%5.$! $ 1,0"6,52#.6% $6 $6#,"0#,%%!.5" $5,0"%,6%5.$! $ 1,016,$!1.26 $" $5!,5%0,"62.$# $5,0"%,6%5.$! $!55,55%.#$ $% $55,#!5,"%%.#% $5,0"%,6%5.$! $%!#,"11.$$ $! $51,1$%,0#!."2 $5,0"%,6%5.$! $%#0,!#6.%# 50 $$6,%#6,5"$.%# $5,0"%,6%5.$! $"6",220.60 51 $$2,$60,$#".!6 $5,0"%,6%5.$! $"02,5$%.62 52 $#%,01%,65!.05 $5,0"%,6%5.$! $6#6,!06.5" 5# $##,510,25#.$5 $5,0"%,6%5.$! $5"0,2"!.%! 5$ $2%,!#$,221."" $5,0"%,6%5.$! $502,65#.%0 55 $2$,2%!,5$!.61 $5,0"%,6%5.$! $$#$,01#.## 56 $1!,5"5,20".#6 $5,0"%,6%5.$! $#6$,#$#.2$ 5" $1$,"!0,1$!.!! $5,0"%,6%5.$! $2!#,62%.11 5% $!,!##,#16."5 $5,0"%,6%5.$! $221,%52.25 5! $5,00#,6#1.02 $5,0"%,6%5.$! $1$%,!!!."5 60 $0.00 $5,0"%,6%5.$! $"5,05$.$" $ 10$,"21,12!.1# Datos InicialeValorInversin$ 1$",%!1,$2#.0! i 1.5%a&os n $%Ca'ital (aldo Periodo Inversn0$ 1$",%!1,$2#.0! $2,0"%,6%5.$! $1!",!21,#1$.51$##,%#5,6$%.!11 $1$5,"65,$%#.!$$2,10!,%65."" $1!5,%11,$$%."5 2 $1$#,60",655."0$2,1$1,51#."5 $1!#,66!,!#$.!! # $1$1,$1",$60.0$$2,1"#,6#6.$6 $1!1,$!6,2!%.5# $ $1#!,1!$,$11.$5$2,206,2$1.01 $1%!,2!0,05".52 5 $1#6,!#%,01".12$2,2#!,##$.62 $1%",050,"22.!0 6 $1#$,6$",""6.%!$2,2"2,!2$.6$ $1%$,""","!%.26 " $1#2,#2#,1%#.0$$2,#0",01%.51 $1%2,$"0,""!."5 % $12!,!6#,"20.2!$2,#$1,62#."! $1%0,12!,155.!6 ! $12",56%,%65.60$2,#"6,"$%.15 $1"","52,$0".%1 10 $125,1#%,0%%.0!$2,$12,#!!.#" $1"5,#$0,00%.$5 11 $122,6"0,%$%.!2$2,$$%,5%5.#6 $1"2,%!1,$2#.0!$25,000,000.0012 $120,166,601.16$2,$%5,#1$.1$ $1"0,$06,10%.!5 1# $11",62$,"%!.6%$2,522,5!#.%5 $16",%%#,515.10 1$ $115,0$$,%51.0#$2,560,$#2."6 $165,#2#,0%2.#$ 15 $112,$26,21#.#0$2,5!%,%#!.25 $162,"2$,2$#.0! 16 $10!,"6%,2!6.00$2,6#",%21.%$ $160,0%6,$21.25 1" $10",0"0,50!.!5$2,6"",#%!.1" $15",$0!,0#2.0% 1% $10$,##2,25".10$2,"1",550.00 $15$,6!1,$%2.0% 1! $101,552,!#0.$6$2,"5%,#1#.25 $151,!##,16%.%2 20 $!%,"#1,!1#.!2$2,"!!,6%".!5 $1$!,1##,$%0.%" 21 $!5,%6%,5%2.1$$2,%$1,6%#.2" $1$6,2!1,"!".60 22 $!2,!62,#00.#%$2,%%$,#0%.52 $1$#,$0",$%!.0% 2# $!0,012,$2$.#!$2,!2",5"#.15 $1$0,$"!,!15.!# 2$ $%",01%,#00.26$2,!"1,$%6."5 $1#",50%,$2!.1% 25 $%#,!"!,26$.2"$#,016,05!.05 $1#$,$!2,#"0.1# 26 $%0,%!$,6$2."#$#,061,2!!.!# $1#1,$#1,0"0.20 2" $"","6#,"51.%%$#,10",21!.$# $12%,#2#,%50."" 2% $"$,5%5,%!".66$#,15#,%2"."2 $125,1"0,02#.0$ 2! $"1,#60,#"5.6#$#,201,1#5.1$ $121,!6%,%%".!0 #0 $6%,0%6,$"0.""$#,2$!,152.1" $11%,"1!,"#5."$ #1 $6$,"6#,$5".#$$#,2!",%%!.$5 $115,$21,%$6.2! #2 $61,#!0,5!%."0$#,#$",#5"."! $112,0"$,$%%.50 ## $5",!6",1$".1!$#,#!",56%.16 $10%,6"6,!20.#$ #$ $5$,$!2,#$#.!0$#,$$%,5#1.6% $105,22%,#%%.66 #5 $50,!65,$1%.56$#,500,25!.66 $101,"2%,12!.00 #6 $$",#%5,5%!.#5$#,552,"6#.55 $!%,1"5,#65.$5 #" $$#,"52,062.6!$#,606,055.00 $!$,56!,#10.$5 #% $$0,06$,0##.1$$#,660,1$5.%# $!0,!0!,16$.62 #! $#6,#20,6%#.1$$#,"15,0$%.02 $%",1!$,116.60 $0 $#2,521,1%2.%!$#,""0,""#."$ $%#,$2#,#$2.%" $1 $2%,66$,6!0.1$$#,%2",##5.#$ $"!,5!6,00".52 $2 $2$,"50,#50.00$#,%%$,"$5.#" $"5,"11,262.15 $# $20,""",2!$."5$#,!$#,016.55 $"1,"6%,2$5.60 $$ $16,"$$,6$#.6%$$,002,161.%0 $6","66,0%#.%0 $5 $12,651,502.%$$$,062,1!$.2# $6#,"0#,%%!.5" $6 $%,$!6,!6$.%%$$,12#,12".1$ $5!,5%0,"62.$# $" $$,2%0,10%.%6$$,1%$,!"$.05 $55,#!5,"%%.#% $% )$0.00$$,2$","$%.66 $51,1$%,0#!."2$$,#11,$6$.%! $$6,%#6,5"$.%#$$,#"6,1#6.%6 $$2,$60,$#".!6$$,$$1,""%.!2 $#%,01%,65!.05$$,50%,$05.60 $##,510,25#.$5$$,5"6,0#1.6% $2%,!#$,221.""$$,6$$,6"2.16 $2$,2%!,5$!.61$$,"1$,#$2.2$ $1!,5"5,20".#6$$,"%5,05".#" $1$,"!0,1$!.!!$$,%56,%##.2$ $!,!##,#16."5$$,!2!,6%5."# $5,00#,6#1.02$5,00#,6#1.02 $0.00$200,000,000.00PesosEMmeses 5 a&osCota Interes Ca'ital (aldo$$,#$$,#10.50$2,21%,#"1.#5$2,125,!#!.15 $1$5,"65,$%#.!$$$,#$$,#10.50$2,1%6,$%2.26$2,15",%2%.2$ $1$#,60",655."0$$,#$$,#10.50$2,15$,11$.%$$2,1!0,1!5.66 $1$1,$1",$60.0$$$,#$$,#10.50$2,121,261.!0$2,22#,0$%.5! $1#!,1!$,$11.$5$$,#$$,#10.50$2,0%",!16.1"$2,256,#!$.#2 $1#6,!#%,01".12$$,#$$,#10.50$2,05$,0"0.26$2,2!0,2$0.2$ $1#$,6$",""6.%!$$,#$$,#10.50$2,01!,"16.65$2,#2$,5!#.%$ $1#2,#2#,1%#.0$$$,#$$,#10.50$1,!%$,%$"."5$2,#5!,$62."5 $12!,!6#,"20.2!$$,#$$,#10.50$1,!$!,$55.%0$2,#!$,%5$.6! $12",56%,%65.60$$,#$$,#10.50$1,!1#,5#2.!%$2,$#0,""".51 $125,1#%,0%%.0!$$,#$$,#10.50$1,%"",0"1.#2$2,$6",2#!.1" $122,6"0,%$%.!2$$,#$$,#10.50$1,%$0,062."#$2,50$,2$"."6 $120,166,601.16$$,#$$,#10.50$1,%02,$!!.02$2,5$1,%11.$% $11",62$,"%!.6%$$,#$$,#10.50$1,"6$,#"1.%5$2,5"!,!#%.65 $115,0$$,%51.0#$$,#$$,#10.50$1,"25,6"2.""$2,61%,6#"."# $112,$26,21#.#0$$,#$$,#10.50$1,6%6,#!#.20$2,65",!1".#0 $10!,"6%,2!6.00$$,#$$,#10.50$1,6$6,52$.$$$2,6!","%6.06 $10",0"0,50!.!5$$,#$$,#10.50$1,606,05".65$2,"#%,252.%5 $10$,##2,25".10$$,#$$,#10.50$1,56$,!%#.%6$2,""!,#26.6$ $101,552,!#0.$6$$,#$$,#10.50$1,52#,2!#.!6$2,%21,016.5$ $!%,"#1,!1#.!2$$,#$$,#10.50$1,$%0,!"%."1$2,%6#,##1."! $!5,%6%,5%2.1$$$,#$$,#10.50$1,$#%,02%."#$2,!06,2%1."6 $!2,!62,#00.#%$$,#$$,#10.50$1,#!$,$#$.51$2,!$!,%"5.!! $!0,012,$2$.#!$$,#$$,#10.50$1,#50,1%6.#"$2,!!$,12$.1# $%",01%,#00.26$$,#$$,#10.50$1,#05,2"$.50$#,0#!,0#5.!! $%#,!"!,26$.2"$$,#$$,#10.50$1,25!,6%%.!6$#,0%$,621.5# $%0,%!$,6$2."#$$,#$$,#10.50$1,21#,$1!.6$$#,1#0,%!0.%5 $"","6#,"51.%%$$,#$$,#10.50$1,166,$56.2%$#,1"",%5$.22 $"$,5%5,%!".66$$,#$$,#10.50$1,11%,"%%.$6$#,225,522.0# $"1,#60,#"5.6#$$,#$$,#10.50$1,0"0,$05.6#$#,2"#,!0$.%6 $6%,0%6,$"0.""$$,#$$,#10.50$1,021,2!".06$#,#2#,01#.$# $6$,"6#,$5".#$$$,#$$,#10.50$ !"1,$51.%6$#,#"2,%5%.6$ $61,#!0,5!%."0$$,#$$,#10.50$ !20,%5%.!%$#,$2#,$51.51 $5",!6",1$".1!$$,#$$,#10.50$ %6!,50".21$#,$"$,%0#.2! $5$,$!2,#$#.!0$$,#$$,#10.50$ %1",#%5.16$#,526,!25.#$ $50,!65,$1%.56$$,#$$,#10.50$ "6$,$%1.2%$#,5"!,%2!.22 $$",#%5,5%!.#5$$,#$$,#10.50$ "10,"%#.%$$#,6##,526.66 $$#,"52,062.6!$$,#$$,#10.50$ 656,2%0.!$$#,6%%,02!.55 $$0,06$,0##.1$$$,#$$,#10.50$ 600,!60.50$#,"$#,#50.00 $#6,#20,6%#.1$$$,#$$,#10.50$ 5$$,%10.25$#,"!!,500.25 $#2,521,1%2.%!$$,#$$,#10.50$ $%",%1"."$$#,%56,$!2."5 $2%,66$,6!0.1$$$,#$$,#10.50$ $2!,!"0.#5$#,!1$,#$0.1$ $2$,"50,#50.00$$,#$$,#10.50$ #"1,255.25$#,!"#,055.25 $20,""",2!$."5$$,#$$,#10.50$ #11,65!.$2$$,0#2,651.0" $16,"$$,6$#.6%$$,#$$,#10.50$ 251,16!.66$$,0!#,1$0.%$ $12,651,502.%$$$,#$$,#10.50$ 1%!,""2.5$$$,15$,5#".!5 $%,$!6,!6$.%%$$,#$$,#10.50$ 12",$5$.$"$$,216,%56.02 $$,2%0,10%.%6$$,#$$,#10.50$ 6$,201.6#$$,2%0,10%.%6 )$0.00 $60,6#5,$%0.6% $!$,$"1,12!.60 $10,2$!,!!!.5# 201# 6!5%01%$0 201$ !.10"55051201$ "5!1"2#$$!.10"55051200% *+E,-200!201020116,!21,666,11# 2012",552,060,#50 201# ) 201$ ) 2015 ) 2016 ))) 201" ) 201% ) 201! ) 2020 ) Incremento . a&o #% ProdccnIn/reso$ 20,000.000Incremento IPC #% 201$ #"!5!Costo "#% 2015 #!0!"Im'esto #$% 2016 $02"0Inv. Inicial0activo 12o3$12#,26!,%0!.00201" $1$"%4asa de de'reciacion 1%% 201% $2"2#De're$6,16#,$!0.$5201!tasa deindice de o'ortnidad 04I53 15% 2020$1"5$.$"1 ##000$#00".1051 ##!!0$$2!".#1%# #500!."$5626.2#"% #605!.!!1$6!!5.025 #"1$1."!0"16"2%In/resos Costos 6astos $ "5!,1"2,200.00 $ 550,#!!,%$5.00 $) $1#","%!,"5$.#0 $ %05,$05,"%6.!% $ 5%#,!1!,1!5.56 $) $1$6,1%1,150.#$ $ %2!,56",!60.5! $ 601,$#6,""1.$# $) $150,566,5%$.%5 $ %5$,$5$,!!!.$1 $ 61!,$"!,%"$.5" $) $155,0%#,5%2.#! $ %%0,0%%,6$!.#! $ 6#%,06$,2"0.%1 $) $15!,"#6,0%!.%6 7tilidad 5'erativa des'8s de im'estosDe'resci,l2o de ca2a 9rto 0,C:3 Inv ;ct ,i2o)5$5$166$ $ 1#","%!,"5$.#0)"2"#15"."%%2"2 $ 1$6,1%1,150.#$)"2"#15"."%%2"2 $ 150,566,5%$.%5)"2"#15"."%%2"2 $ 155,0%#,5%2.#!)"2"#15"."%%2"2 $ 15!,"#6,0%!.%6)"2"#15"."%%2"22$$%