amortizacion nice.xlsx

Download AMORTIZACION nice.xlsx

Post on 06-Jul-2018

218 views

Category:

Documents

0 download

Embed Size (px)

TRANSCRIPT

  • 8/17/2019 AMORTIZACION nice.xlsx

    1/31

    capitulo 10

    pagos de una deuda con: cuotas iguales(anualidades simples ordinarias; con variacion g sistemas de amortizacion: gradual constante

    incrementado decreciente extraodinaria(abonos o cuotas bombas)

    ejercicio 10.3 DA !" # $.00 % &' e ectiva anual

    * $00+000.00 cuotas anuales

    , -1 $+ &. 3 renta anual uni orme %#/%"! A

    cuadro de amortizacion #/%!# A2! A2!%# A2! %# "A4D!-A,! %5A/%!

    6 %!D! 6# A %# 6 6"6" A,! %5A/%!# "A4D! %#"!4 ! 0 $00+000.00 1 -1 $+ &. 3 4. -70+000.00 4. -&$+ &. 3 717+881.88

    -1 $+ &. 3 4. -33+1&1.87 4. -9 +07 .79 3 +8 $. 9 3 -1 $+ &. 3 4. - $+&1&.0 4. -99+710. 0 3+31$.0& 7 -1 $+ &. 3 4. -18+& $. 1 4. -108+3 3.0 11$+9$ .0 $ -1 $+ &. 3 4. -9+ 8 .1 4. -11$+9$ .0 -

  • 8/17/2019 AMORTIZACION nice.xlsx

    2/31

    radiente aritmetico o geometrico)

  • 8/17/2019 AMORTIZACION nice.xlsx

    3/31

    DA !" # 30 1& % 6 A. ,6#". 0. 8' 7.0 8 3' 6 A. "6,. % /A . /!# . 17.8 $$&9 $' 8. 70 $' 6 *A. "6,

    *. 700+000+000.00

    6 %!D! 6# A %# 6 6"6" A,! %5A/%!#

    1 - 3+3 1+3 $.88 -1 + 9+07&.9 -8+0$ + 8 .&$ - 3+3 1+3 $.88 -1$+9& + 17.33 -8+339+111.77

    3 - 3+3 1+3 $.88 -1$+ &3+813.7 -8+ 38+ 1 .3$ 7 - 3+3 1+3 $.88 -1$+383+081.80 -8+97&+ $7.08 $ - 3+3 1+3 $.88 -1$+079+89$.3 -&+ 81+$30.70

    - 3+3 1+3 $.88 -17+813+380.$3 -&+ 08+9$$. 7 8 - 3+3 1+3 $.88 -17+3 3+ .7 -&+9$&+0 3.3$

    & - 3+3 1+3 $.88 -13+99&+917.79 -9+3 +711. &9 - 3+3 1+3 $.88 -13+ 19+878.$& -9+801+$8&.19 10 - 3+3 1+3 $.88 -13+ $+1$&.9$ -10+09 +1 .&1 11 - 3+3 1+3 $.88 -1 +&17+$ 1.38 -10+$0 +&07.39 1 - 3+3 1+3 $.88 -1 +3&8+1& .09 -10+937+173. & 13 -30+$$3+7$3.$ - +737+81$.8& -&+11&+838.87 17 -30+$$3+7$3.$ - 1+&17+393.78 -&+839+0 0.0$ 1$ -30+$$3+7$3.$ - 1+17 + 87. 8 -9+70 +88&.&$ 1 -30+$$3+7$3.$ - 0+7 8+938.98 -10+1 $+$1$.$$ 18 -30+$$3+7$3.$ -19+ $7+ &$.30 -10+&99+1 &. 1& -30+$$3+7$3.$ -1&+& 1+$ 0.8 -11+831+93 .&0 19 -30+$$3+7$3.$ -18+9 $+1 8.83 -1 + &+3 $.89

    0 -30+$$3+7$3.$ -1 +9 0+ 77.8 -13+$93+ 0&.&0 1 -30+$$3+7$3.$ -1$+9 1+ 3&. 1 -17+ 31+&17.91

    -30+$$3+7$3.$ -17+&03+ 8 .$0 -1$+879+888.0 3 -30+$$3+7$3.$ -13+ 00+ 9$.10 -1 +9$3+1$&.7 7 -30+$$3+7$3.$ -1 +307+9 8.&7 -1&+ 7&+7&$. & $ -30+$$3+7$3.$ -10+910+ 9.7& -19+ 7 +8&7.07

    -30+$$3+7$3.$ -9+709+&3&.01 - 1+173+ 1$.$1 8 -30+$$3+7$3.$ -8+897+333. 7 - +8$9+119.&& & -30+$$3+7$3.$ - +0$$+397. 3 - 7+79&+0$&.&9 9 -30+$$3+7$3.$ -7+1&3+$&9.& - +3 9+& 3.80

    30 -30+$$3+7$3.$ - +1 &+8 8.7 - &+3&7+ & .10

  • 8/17/2019 AMORTIZACION nice.xlsx

    4/31

    "A4D! %#"!4 ! 700+000+000.00 39 +978+8 3.1$ 3&$+ 0&+ 11.8 388+980+999.38 380+0 +87$.30 3 1+8$1+ 17.90 3$3+173+ $9. 377+1&$+19 .31

    337+& +8&$.073 $+1 1+ 0 .&$ 31$+0 $+070.07 307+$$&+ 3$. 7

    93+ 7+091.98 &$+$0$+3$7. 8 +8 + 97.1&

    8+3$9+$1$.3 $8+ 33+999.88 7 +337+&31.$$ 37+ 0 +&9&.8$

    1+987+$8 .98 0&+3&1+3 7.1

    193+879+$79. $ 188+999+88 . 3 1 1+07 + 13.&0 17 +89&+1 &.1 1 3+1$$+377.0& 10 +011+8 &.$8

    89+ $ + 0&. & $7+8$7+$79.&0

    &+3&7+ & .10 -

  • 8/17/2019 AMORTIZACION nice.xlsx

    5/31

    DA !" # 77 3 % 6 *! A# . ' .9$ 30171' % /A ./!# . &. 188 9 7' 7.7030 $09'

    * 700+000+000.00 < &

    6 %!D! 6# A %# 6 6"6" A,! % 5A/%!# "A4D! %#"!4 ! 700+000+000.00

    1 -11+& $+ 0$. 7 700+000+000.00 -11+& $+ 0$. 7 700+000+000.00

    3 -11+& $+ 0$. 7 700+000+000.00 7 -11+& $+ 0$. 7 700+000+000.00 $ -11+& $+ 0$. 7 700+000+000.00

    -11+& $+ 0$. 7 700+000+000.00 8 -11+& $+ 0$. 7 700+000+000.00

    & -11+& $+ 0$. 7 700+000+000.009 -1&+ 0 + $1.70 -11+& $+ 0$. 7 - +388+07$.8 393+ +9$7. 7 10 -1&+ 0 + $1.70 -11+ 3 + &0.9$ - +$ $+$80.7 3&8+0$8+3&3.8& 11 -1&+ 0 + $1.70 -11+77 +$& .&9 - +8$9+ &.$1 3&0+ 98+81$. 8 1 -1&+ 0 + $1.70 -11+ 7 +87 .8 - +9$9+$07. & 383+33&+ 10.$& 13 -1&+ 0 + $1.70 -11+038+00 .8& -8+1 $+ 7&. 3 +18 +9 1.9 17 -1&+ 0 + $1.70 -10+& $+18 .77 -8+388+087.98 3$&+89$+&&8.00 1$ -1&+ 0 + $1.70 -10+ 08+0&8.&8 -8+$9$+1 3.$7 3$1+ 00+8 3.7 1 -1&+ 0 + $1.70 -10+3& +$$1.97 -8+&19+ 99.7 373+3&1+0 7.00 18 -1&+ 0 + $1.70 -10+1$1+38&.0$ -&+0$0+&83.3$ 33$+330+1$0. $ 1& -1&+ 0 + $1.70 -9+913+3 9.98 -&+ &&+&&1.73 3 8+071+ 9. 19 -1&+ 0 + $1.70 -9+ &+3 $. $ -&+$33+9 $.8$ 31&+$08+373.78

    0 -1&+ 0 + $1.70 -9+71 +038.09 -&+8& + 17.3 309+8 1+1 9.1$ 1 -1&+ 0 + $1.70 -9+1$ + 90.11 -9+07$+9 1.30 300+ 8$+1 8.&$

    -1&+ 0 + $1.70 -&+&&&+& 7. 3 -9+313+3&8.1& 91+3 1+8&0. & 3 -1&+ 0 + $1.70 -&+ 13+$3 .73 -9+$&&+81&.98 &1+883+0 1.80 7 -1&+ 0 + $1.70 -&+330+0 1.00 -9+&8 +190.71 81+900+&81. 9 $ -1&+ 0 + $1.70 -&+03&+ 09. 9 -10+1 7+07 .11 1+83 +& 9.1&

    -1&+ 0 + $1.70 -8+838+8 9.$8 -10+7 7+$ 1.&3 $1+ 8 +308.3$ 8 -1&+ 0 + $1.70 -8+7 &+3 .8 -10+883+&&7. 7 70+79&+7 .81 & -1&+ 0 + $1.70 -8+109+&$&. -11+09 +393.17 9+70 +0 9.$8 9 -1&+ 0 + $1.70 - +8&1+933. 9 -11+7 0+318.8 18+9&$+811.&$

    30 -1&+ 0 + $1.70 - +777+317. 8 -11+8$8+93 .83 0 + 8+88$.1 31 -1&+ 0 + $1.70 - +09 +817. -1 +10$+$3 .8& 197+1 + 3&.37 3 -1&+ 0 + $1.70 -$+83&+&3&.78 -1 +7 3+71 .93 1&1+ $&+& $.71 33 -1&+ 0 + $1.70 -$+380+3& .7 -1 +&31+& &.99 1 &+& +9$ .7 37 -1&+ 0 + $1.70 -7+991+033. 9 -13+ 11+ 18.81 1$$+ 1$+83&.81 3$ -1&+ 0 + $1.70 -7+ 00+780. & -13+ 01+8&1.13 17 +013+9$8.$9 3 -1&+ 0 + $1.70 -7+19&+3 0. 3 -17+003+&90.88 1 &+010+0 .&

  • 8/17/2019 AMORTIZACION nice.xlsx

    6/31

    38 -1&+ 0 + $1.70 -3+8&7+3 3.71 -17+718+&&8.99 113+$9 +18&.& 3& -1&+ 0 + $1.70 -3+3$&+1 8.1& -17+&77+1 7. 9&+87&+0$7. 0 39 -1&+ 0 + $1.70 - +919+ 90.13 -1$+ & +9 1. 8 &3+7 $+093.33 70 -1&+ 0 + $1.70 - +7 8+789.83 -1$+837+881. 8 8+830+3 1. 71 -1&+ 0 + $1.70 - +00 +31 .7$ -1 +199+93&.9$ $1+$30+3& .81 7 -1&+ 0 + $1.70 -1+$ 3+393.73 -1 + 8&+&$8.98 37+&$1+$ 7.87

    73 -1&+ 0 + $1.70 -1+030+31 .1 -18+181+93$. 9 18+ 89+$&9.7$ 77 -1&+ 0 + $1.70 -$ + 1.9$ -18+ 89+$&9.7$ -0.00

  • 8/17/2019 AMORTIZACION nice.xlsx

    7/31

    DA !" # 70 % 6 *A.A#. 17.8$' 1.1$317$ '

    * &$7700

    A 79 6 %!D! 6# A %# 6 6"6" A,! %5A/%!# "A4D! %#"!4 !

    &$7700 1 -10+$ 7.10 -9+&$ .78 - 81. 3 &$3+8 &.38

    -10+$ 7.10 -9+&77.83 - 89.3& &$3+07&.99 3 -10+$ 7.10 -9+&3 .&9 - &8. 1 &$ +3 1.8& 7 -10+$ 7.10 -9+& &.98 - 9$.17 &$1+ . $ $ -10+$ 7.10 -9+& 0.9$ -803.1$ &$0+9 3.79

    -10+$ 7.10 -9+&1 .&7 -811. &$0+ $ . 3 8 -10+$ 7.10 -9+&07. 7 -819.7 &79+$3 .88

    & -10+$ 7.10 -9+89 .3$ -8 8.8 &7&+&0$.01 9 -10+$ 7.10 -9+8&8.9$ -83 .1$ &7&+0 &.& 10 -10+$ 7.10 -9+889.78 -877. 7 &78+3 7. 3 11 -10+$ 7.10 -9+880.&& -8$3. 3 &7 +$81.00 1 -10+$ 7.10 -9+8 .19 -8 1.91 &7$+&09.09 13 -10+$ 7.10 -9+8$3.71 -880.80 &7$+03&.39 17 -10+$ 7.10 -9+877.$ -889.$& &77+ $&.&1 1$ -10+$ 7.10 -9+83$.$3 -8&&.$8 &73+780. 3 1 -10+$ 7.10 -9+8 .77 -898. 8 &7 + 8 .$ 18 -10+$ 7.10 -9+818. 7 -&0 .&8 &71+& $.80 1& -10+$ 7.10 -9+808.93 -&1 .18 &71+079.$3 19 -10+$ 7.10 -9+ 9&.$ -& $.$& &70+ 3.97

    0 -10+$ 7.10 -9+ &9.00 -&3$.10 &39+3&&.&7 1 -10+$ 7.10 -9+ 89.38 -&77.83 &3&+$77.11

    -10+$ 7.10 -9+ 9. 3 -&$7.78 &38+ &9. 7 3 -10+$ 7.10 -9+ $9.8& -& 7.33 &3 +& $.31 7 -10+$ 7.10 -9+ 79.&1 -&87. 9 &3$+9$1.0 $ -10+$ 7.10 -9+ 39.83 -&&7.3& &3$+0 . 7

    -10+$ 7.10 -9+ 9.$3 -&97.$8 &37+18 .08 8 -10+$ 7.10 -9+ 19. -907.&9 &33+ 8.1& & -10+$ 7.10 -9+ 0&.8& -91$.3 &3 +3$1.&$ 9 -10+$ 7.10 -9+$9&. 3 -9 $.&& &31+7 $.98

    30 -10+$ 7.10 -9+$&8.$$ -93 .$ &30+7&9.7 31 -10+$ 7.10 -9+$8 .8$ -978.3 & 9+$7 .0 3 -10+$ 7.10 -9+$ $.& -9$&. & & &+$&3.8& 33 -10+$ 7.10 -9+$$7.88 -9 9.33 & 8+ 17.7$ 37 -10+$ 7.10 -9+$73. 0 -9&0.$1 & + 33.97 3$ -10+$ 7.10 -9+$3 . 9 -991.&1 & $+ 7 .13 3 -10+$ 7.10 -9+$ 0.&$ -1+003. $ & 7+ 3&.&&

  • 8/17/2019 AMORTIZACION nice.xlsx

    8/31

    38 -10+$ 7.10 -9+$09. & -1+017.& & 3+ 7.0 3& -10+$ 7.10 -9+798.$& -1+0 .$ & +$98.$3 39 -10+$ 7.10 -9+7&$.87 -1+03&.3 & 1+$$9.18 70 -10+$ 7.10 -9+783.88 -1+0$0.33 & 0+$0&.&7 71 -10+$ 7.10 -9+7 1. -1+0 .7$ &19+77 .39 7 -10+$ 7.10 -9+779.71 -1+087.80 &1&+381.80

    73 -10+$ 7.10 -9+738.0