Page 25 - libro Alan Piña
P. 25

BANORTE          Problema base
                                                       datos
                                                       c         $ 463,200.00               $ 90,324.00
                                                       T           5 años                    0.831608197
                                                       i                 0.195
                                                       n                    10
                                                       A         $ 108,613.65


                                                                     Tabla de amortizacion
                                                       n. pago     fecha de pago anualidad     interes     amortizacion   saldo
                                                                1  23/08/2018  $ 108,613.65 $ 90,324.00 $18,289.65    $ 444,910.35
                                                                2  23/02/2019  $ 108,613.65 $ 86,757.52 $21,856.13    $ 423,054.22
                                                                3  23/08/2019  $ 108,613.65 $ 82,495.57 $26,118.07    $ 396,936.15
                                                                4  23/02/2020  $ 108,613.65 $ 77,402.55 $31,211.10    $ 365,725.05
                                                                5  23/08/2020  $ 108,613.65 $ 71,316.38 $37,297.26    $ 328,427.79
                                                                6  23/02/2021  $ 108,613.65 $ 64,043.42 $44,570.23    $ 283,857.56
                                                                7  23/08/2021  $ 108,613.65 $ 55,352.22 $53,261.42    $ 230,596.13
                                                                8  23/02/2022  $ 108,613.65 $ 44,966.25 $63,647.40    $ 166,948.73
                                                                9  23/08/2022  $ 108,613.65 $ 32,555.00 $76,058.65    $ 90,890.08
                                                               10  23/02/2023  $ 108,613.65 $ 17,723.57 $90,890.08    $      0.00
                                                                                            $ 622,936.48
   20   21   22   23   24   25   26   27   28   29   30