Linea Cocepto Valor compra Valor amortizar Valor residual Ao 1 Ao 2 Ao 3 Ao 4 Ao ! Ao 6 Ao " Ao # Ao $ Ao 10 %endiente
Alfa Camión 1 Camión 2 40,000.00 € 40,000.00 € Amortización anual total 36,000.00 € 36,000.00 € 4,000.00 € 4,000.00 € 3,600.00 € 0.00 € 3,600.00 € 3,600.00 € 0.00 € 3,600.00 € 3,600.00 € 0.00 € 3,600.00 € 3,600.00 € 0.00 € 3,600.00 € 3,600.00 € 0.00 € 3,600.00 € 3,600.00 € 0.00 € 3,600.00 € 0.00 € 3,600.00 € 3,600.00 € 0.00 € 3,600.00 € 3,600.00 € 0.00 € 3,600.00 € 3,600.00 € 0.00 € 3,600.00 € 3,600.00 € 0.00 € 21,600.00 € 0.00 €
Cuadro de amortización &eta Camión 1 Camión 2 Camión 3 '. (o)ótica '. *. reno+a)les 40,000.00 € 40,000.00 € 40,000.00 € !00,000.00 € 600,000.00 € 36,000.00 € 36,000.00 € 36,000.00 € 4!0,000.00 € 600,000.00 € 4,000.00 € 4,000.00 € 4,000.00 € !0,000.00 € 0.00 € 3,600.00 € 0.00 € 3,600.00 € 4!,000.00 € 60,000.00 € 3,600.00 € 0.00 € 3,600.00 € 4!,000.00 € 60,000.00 € 3,600.00 € 0.00 € 3,600.00 € 4!,000.00 € 60,000.00 € 3,600.00 € 0.00 € 3,600.00 € 4!,000.00 € 60,000.00 € 3,600.00 € 0.00 € 3,600.00 € 4!,000.00 € 60,000.00 € 3,600.00 € 0.00 € 3,600.00 € 4!,000.00 € 60,000.00 € 0.00 € 3,600.00 € 3,600.00 € 4!,000.00 € 60,000.00 € 0.00 € 3,600.00 € 3,600.00 € 4!,000.00 € 60,000.00 € 0.00 € 3,600.00 € 3,600.00 € 4!,000.00 € 60,000.00 € 0.00 € 3,600.00 € 3,600.00 € 4!,000.00 € 60,000.00 € 0.00 € 21,600.00 € 0.00 € 0.00 € 0.00 €
Amortización anual total 112,200.00 € 112,200.00 € 112,200.00 € 112,200.00 € 112,200.00 € 112,200.00 € 112,200.00 € 112,200.00 € 112,200.00 € 112,200.00 € 0.00 €
Al *&'-A Ao Ao Ao Ao Ao Ao Ao Ao Ao Ao
1 2 3 4 ! 6 " # $ 10
400,000.00 400,000.00 400,000.00 400,000.00 400,000.00 400,000.00 400,000.00 400,000.00 400,000.00 400,000.00
astos /n. € € € € € € € € € €
0.00 € 0.00 € 0.00 € 0.00 € 0.00 € 0.00 € 0.00 € 0.00 € 0.00 € 0.00 €
Amortizaciónn 3,600.00 3,600.00 3,600.00 3,600.00 3,600.00 3,600.00 3,600.00 3,600.00 3,600.00 3,600.00
€ € € € € € € € € € V
fa 'mpuestos $$,100.00 $$,100.00 $$,100.00 $$,100.00 $$,100.00 $$,100.00 $$,100.00 $$,100.00 $$,100.00 $$,100.00 Alfa
*ntradas € € € € € € € € € €
0.00 € 0.00 € 0.00 € 0.00 € 0.00 € 4,000.00 € 0.00 € 0.00 € 0.00 € 0.00 €
alidas 0.00 € 0.00 € 0.00 € 0.00 € 0.00 € 40,000.00 € 0.00 € 0.00 € 0.00 € 0.00 €
luo Caa 300,$00.00 € 300,$00.00 € 300,$00.00 € 300,$00.00 € 300,$00.00 € 264,$00.00 € 300,$00.00 € 300,$00.00 € 300,$00.00 € 300,$00.00 €
Cculos VA
L A 5 0 A 0 A V
2"3,!4!.4! € 24#,6"".6$ € 226,0"0.62 € 20!,!1#."! € 1#6,#3!.23 € 14$,!2$.14 € 1!4,40$.2# € 140,3"2.0" € 12",610.$" € 116,00$.$# € 1,#2#,!"$.1# €
*&'-A Ao Ao Ao Ao Ao Ao Ao Ao Ao Ao
1 2 3 4 ! 6 " # $ 10
600,000.00 "00,000.00 #00,000.00 #00,000.00 #00,000.00 #00,000.00 #00,000.00 #00,000.00 #00,000.00 #00,000.00
astos /nancieros € € € € € € € € € €
10,000.00 €
32,2!#.21 € 26,001.!# € 1$,2$2.6! € 12,0$#."4 € 4,3#4."# € 0.00 € 0.00 € 0.00 € 0.00 € 0.00 €
&eta Amortización 112,200.00 112,200.00 112,200.00 112,200.00 112,200.00 112,200.00 112,200.00 112,200.00 112,200.00 112,200.00 VA &eta -'( &eta
'mpuestos € € € € € € € € € €
111,3#!.4! 140,44$.61 16",126.#4 16#,$2!.32 1"0,#!3.#1 1"1,$!0.00 1"1,$!0.00 1"1,$!0.00 1"1,$!0.00 1"1,$!0.00
*ntradas € € € € € € € € € €
!00,000.00 € 0.00 € 0.00 € 0.00 € 0.00 € 4,000.00 € 0.00 € 0.00 € 0.00 € 0.00 €
alidas 1,140,000.00 € 0.00 € 0.00 € 0.00 € 0.00 € 40,000.00 € 0.00 € 0.00 € 0.00 € 0.00 €
luo Caa 2#0,1$2.64 € 440,"43.20 € !14,06!.$" € !12,26".4$ € !10,33$.00 € !$2,0!0.00 € 62#,0!0.00 € 62#,0!0.00 € 62#,0!0.00 € 62#,0!0.00 €
C
L A 5 0 A 0 A V
lculos VA 7 -'( 1,140,000.00 € 2!4,"20.!# € 364,2!0.!# € 3#6,22!.3" € 34$,##!.!$ € 316,##0.3" € 334,1$6."$ € 322,2##.$6 € 2$2,$#$.$6 € 266,3!4.!1 € 242,140.46 € 1,4#0,4$2.01 € 1!.418
Capital Comisión de apertura 28 recuencia de pa9o Cuota anual -ipo de interes nominal -ipo de interes efecti+o uración en aos ;mero total de pa9os %eriódo
!00,000 € 10,000 € :ensual 11#,#0".1$ € "8 0.00!#333333 ! 60 :ensualidad 0 1 2 3 4 ! 6 " # $ 10 11 12 13 14 1! 16 1" 1# 1$ 20 21 22 23 24 2! 26 2" 2# 2$ 30 31 32 33 34 3! 36 3" 3# 3$ 40 41 42 43 44 4! 46
$,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 €
4" 4# 4$ !0 !1 !2 !3 !4 !! !6 !" !# !$ 60
$,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 € $,$00.60 €
*studio del pr
'ntereses
Amortización 2,$16.6" € 2,#"!.$3 € 2,#34.$! € 2,"$3."3 € 2,"!2.2# € 2,"10.!# € 2,66#.64 € 2,626.4! € 2,!#4.02 € 2,!41.34 € 2,4$#.41 € 2,4!!.23 € 2,411.#0 € 2,36#.11 € 2,324.1" € 2,2"$.$# € 2,23!.!2 € 2,1$0.#1 € 2,14!.#4 € 2,100.60 € 2,0!!.10 € 2,00$.34 € 1,$63.30 € 1,$1".00 € 1,#"0.43 € 1,#23.!$ € 1,""6.4" € 1,"2$.0# € 1,6#1.42 € 1,633.4" € 1,!#!.24 € 1,!36."4 € 1,4#".$! € 1,43#.## € 1,3#$.!2 € 1,33$.#" € 1,2#$.$3 € 1,23$."0 € 1,1#$.1# € 1,13#.36 € 1,0#".2! € 1,03!.#4 € $#4.13 € $32.11 € #"$.#0 € #2".1# €
Capital +i+o 6,$#3.$3 ",024.6" ",06!.6! ",106.#" ",14#.32 ",1$0.02 ",231.$6 ",2"4.1! ",316.!# ",3!$.26 ",402.1$ ",44!.3" ",4##.#0 ",!32.4$ ",!"6.43 ",620.62 ",66!.0# ","0$."$ ","!4."6 ",#00.00 ",#4!.!0 ",#$1.26 ",$3".30 ",$#3.60 #,030.1" #,0"".01 #,124.13 #,1"1.!2 #,21$.1# #,26".13 #,31!.3! #,363.#6 #,412.6! #,461."2 #,!11.0# #,!60."3 #,610.6" #,660.$0 #,"11.42 #,"62.24 #,#13.3! #,#64."6 #,$16.4" #,$6#.4# $,020.#0 $,0"3.42
€ € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €
!00000 4$3016 4#!$$1 4"#$26 4"1#1$ 4646"1 4!"4#1 4!024$ 442$"4 43!6!# 42#2$$ 420#$6 4134!1 40!$62 3$#430 3$0#!3 3#3233 3"!!6# 36"#!# 360103 3!2303 3444!# 336!66 32#62$ 32064! 31261! 304!3# 2$6414 2##243 2#0023 2"1"!6 263441 2!!0"" 246664 23#203 22$6$2 221131 212!20 203#!$ 1$!14# 1#63#6 1""!"2 16#"0# 1!$"$1 1!0#23 141#02 132"2#
""4.2! € "21.01 € 66".46 € 613.60 € !!$.43 € !04.$4 € 4!0.13 € 3$!.00 € 33$.!! € 2#3."# € 22".6# € 1"1.26 € 114.!0 € !".42 €
$,126.3! $,1"$.!$ $,233.14 $,2#".00 $,341.1" $,3$!.66 $,4!0.4" $,!0!.60 $,!61.04 $,616.#2 $,6"2.$2 $,"2$.34 $,"#6.10 $,#43.1#
€ € € € € € € € € € € € € €
123602 114422 10!1#$ $!$02 #6!61 ""16! 6""1! !#20$ 4#64# 3$032 2$3!$ 1$62$ $#43 0
Capital amortizado 6,$#3.$3 € 14,00#.60 € 21,0"4.2! € 2#,1#1.12 € 3!,32$.44 € 42,!1$.46 € 4$,"!1.43 € !",02!.!# € 64,342.16 € "1,"01.42 € "$,103.61 € #6,!4#.$# € $4,03"."# € 101,!"0.2" € 10$,146.6$ € 116,"6".32 € 124,432.3$ € 132,142.1# € 13$,#$6.$4 € 14",6$6.$4 € 1!!,!42.44 € 163,433."0 € 1"1,3"1.00 € 1"$,3!4.!$ € 1#",3#4."6 € 1$!,461."" € 203,!#!.$0 € 211,"!".42 € 21$,$"6.60 € 22#,243."3 € 236,!!$.0# € 244,$22.$4 € 2!3,33!.!$ € 261,"$".32 € 2"0,30#.40 € 2"#,#6$.13 € 2#",4"$.#0 € 2$6,140."0 € 304,#!2.12 € 313,614.36 € 322,42"."1 € 331,2$2.4" € 340,20#.$4 € 34$,1"".42 € 3!#,1$#.22 € 36",2"1.6! €
3"6,3$#.00 € 3#!,!"".!# € 3$4,#10."2 € 404,0$"."2 € 413,43#.## € 422,#34.!4 € 432,2#!.01 € 441,"$0.61 € 4!1,3!1.6! € 460,$6#.4" € 4"0,641.3# € 4#0,3"0."2 € 4$0,1!6.#2 € !00,000.00 €
