Page 23 - Libro clau
P. 23

Fecha de Pago                Anualidad             Interes        Amortizacion                  Saldo
                                                                                                         1           20/03/2018 $              3,434.48 $       1,425.00 $             2,009.48 $            92,990.52

                                                              DATOS:                                     2           20/04/2018 $              3,434.48 $       1,394.86 $             2,039.62 $            90,950.90

                                  C=                            95000                                    3           20/05/2018 $              3,434.48 $       1,364.26 $             2,070.21 $            88,880.69
                                  i=                              18% capitalizable                      4           20/06/2018 $              3,434.48 $       1,333.21 $             2,101.27 $            86,779.42
                                                                         Mensualmente                    5           20/07/2018 $              3,434.48 $       1,301.69 $             2,132.79 $            84,646.64

                                  T=                                  3 Años                             6           20/08/2018 $              3,434.48 $       1,269.70 $             2,164.78 $            82,481.86
                                  n=                                36                                   7           20/09/2018 $              3,434.48 $       1,237.23 $             2,197.25 $            80,284.61

                                  i=                            0.015                                    8           20/10/2018 $              3,434.48 $       1,204.27 $             2,230.21 $            78,054.40
                                  A=                ?                                                    9           20/11/2018 $              3,434.48 $       1,170.82 $             2,263.66 $            75,790.74

                                                                                                       10            20/12/2018 $              3,434.48 $       1,136.86 $             2,297.62 $            73,493.12
                                                                                                       11            20/01/2019 $              3,434.48 $       1,102.40 $             2,332.08 $            71,161.04

                                  A=                     95000*0.015/1-(1+0.015)^-36                   12            20/02/2019 $              3,434.48 $       1,067.42 $             2,367.06 $            68,793.98
                                  A=                             1425              0.414910265         13            20/03/2019 $              3,434.48 $       1,031.91 $             2,402.57 $            66,391.41

                                  A=                   3434.477576                                     14            20/04/2019 $              3,434.48 $         995.87 $             2,438.61 $            63,952.80
                                                                                                       15            20/05/2019 $              3,434.48 $         959.29 $             2,475.19 $            61,477.62

                                                                                                       16            20/06/2019 $              3,434.48 $         922.16 $             2,512.31 $            58,965.30
                                                                                                       17            20/07/2019 $              3,434.48 $         884.48 $             2,550.00 $            56,415.31

                                                                                                       18            20/08/2019 $              3,434.48 $         846.23 $             2,588.25 $            53,827.06
                                                                                                       19            20/09/2019 $              3,434.48 $         807.41 $             2,627.07 $            51,199.99

                                                                                                       20            20/10/2019 $              3,434.48 $         768.00 $             2,666.48 $            48,533.51
                                                                                                       21            20/11/2019 $              3,434.48 $         728.00 $             2,706.47 $            45,827.03

                                                                                                       22            20/12/2019 $              3,434.48 $         687.41 $             2,747.07 $            43,079.96
                                                                                                       23            20/01/2020 $              3,434.48 $         646.20 $             2,788.28 $            40,291.68

                                                                                                       24            20/02/2020 $              3,434.48 $         604.38 $             2,830.10 $            37,461.58
                                                                                                       25            20/03/2020 $              3,434.48 $         561.92 $             2,872.55 $            34,589.03

                                                                                                       26            20/04/2020 $              3,434.48 $         518.84 $             2,915.64 $            31,673.39
                                                                                                       27            20/05/2020 $              3,434.48 $         475.10 $             2,959.38 $            28,714.01

                                                                                                       28            20/06/2020 $              3,434.48 $         430.71 $             3,003.77 $            25,710.24
                                                                                                       29            20/07/2020 $              3,434.48 $         385.65 $             3,048.82 $            22,661.42

                                                                                                       30            20/08/2020 $              3,434.48 $         339.92 $             3,094.56 $            19,566.86
                                                                                                       31            20/09/2020 $              3,434.48 $         293.50 $             3,140.97 $            16,425.89

                                                                                                       32            20/10/2020 $              3,434.48 $         246.39 $             3,188.09 $            13,237.80
                                                                                                       33            20/11/2020 $              3,434.48 $         198.57 $             3,235.91 $            10,001.89
   18   19   20   21   22   23   24   25   26   27   28