Page 27 - Libro clau
P. 27

Datos:                                                 Fecha de pago         Anualidad        Intereses           Amortizacion        Saldo

                 C=                         463200                                  1       26/05/2018 $       56,275.68 $        48,636.00 $            7,639.68 $        455,560.32
                 i=                             42% Capitalizable                   2       26/08/2018 $       56,275.68 $        47,833.83 $            8,441.85 $        447,118.47

                 T=               5 Años                                            3       26/11/2018 $       56,275.68 $        46,947.44 $            9,328.24 $        437,790.23
                 n=                               20 Trimestres                     4       26/02/2019 $       56,275.68 $        45,967.97 $          10,307.71 $         427,482.53

                 i=                           0.105                                 5       26/05/2019 $       56,275.68 $        44,885.67 $          11,390.02 $         416,092.51
                 A=                                                                 6       26/08/2019 $       56,275.68 $        43,689.71 $          12,585.97 $         403,506.54

                                                                                    7       26/11/2019 $       56,275.68 $        42,368.19 $          13,907.49 $         389,599.05
                 A=               463200*0.105/ 1-(1+0.105)^-20                     8       26/02/2020 $       56,275.68 $        40,907.90 $          15,367.78 $         374,231.27

                 A=                          48636         0.864245436              9       26/05/2020 $       56,275.68 $        39,294.28 $          16,981.40 $         357,249.87
                 A=                  56275.68047                                  10        26/08/2020 $       56,275.68 $        37,511.24 $          18,764.44 $         338,485.43

                                                                                  11        26/11/2020 $       56,275.68 $        35,540.97 $          20,734.71 $         317,750.72
                                                                                  12        26/02/2021 $       56,275.68 $        33,363.83 $          22,911.86 $         294,838.86

                                                                                  13        26/05/2021 $       56,275.68 $        30,958.08 $          25,317.60 $         269,521.26
                                                                                  14        26/08/2021 $       56,275.68 $        28,299.73 $          27,975.95 $         241,545.32

                                                                                  15        26/11/2021 $       56,275.68 $        25,362.26 $          30,913.42 $         210,631.89
                                                                                  16        26/02/2022 $       56,275.68 $        22,116.35 $          34,159.33 $         176,472.56

                                                                                  17        26/05/2022 $       56,275.68 $        18,529.62 $          37,746.06 $         138,726.50
                                                                                  18        26/08/2022 $       56,275.68 $        14,566.28 $          41,709.40 $           97,017.10

                                                                                  19        26/11/2022 $       56,275.68 $        10,186.80 $          46,088.88 $           50,928.22
                                                                                  20        26/02/2023 $       56,275.68 $          5,347.46 $         50,928.22                   $0.00

                                                                                                                              $   662,313.61
   22   23   24   25   26   27   28   29   30   31   32