Page 21 - Juan Adriano
P. 21

Tabla de Amortizaciones



                     Datos
                     C=                    95000
                     i=                     0.18 Anual Capilazable mensual        0.015
                     T=                       3 añoa
                     n=                      36 meses


                     Formula          A=C*i/1-(1+i)^n

                     A=                3434.47758


                       Fecha de Entrega  Anualidad  Ineteres  Amortizacion   Saldo
                         20/03/2018    $     3,434.48 $         1,425.00  $                 2,009.48  $             92,990.52
                         20/04/2018    $     3,434.48 $         1,394.86  $                 2,039.62  $             90,950.90
                         20/05/2018    $     3,434.48 $         1,364.26  $                 2,070.21  $             88,880.69
                         20/06/2018    $     3,434.48 $         1,333.21  $                 2,101.27  $             86,779.42
                         20/07/2018    $     3,434.48 $         1,301.69  $                 2,132.79  $             84,646.64
                         20/08/2018    $     3,434.48 $         1,269.70  $                 2,164.78  $             82,481.86
                         20/09/2018    $     3,434.48 $         1,237.23  $                 2,197.25  $             80,284.61
                         20/10/2018    $     3,434.48 $         1,204.27  $                 2,230.21  $             78,054.40
                         20/11/2018    $     3,434.48 $         1,170.82  $                 2,263.66  $             75,790.74
                         20/12/2018    $     3,434.48 $         1,136.86  $                 2,297.62  $             73,493.12
                         20/01/2019    $     3,434.48 $         1,102.40  $                 2,332.08  $             71,161.04
                         20/02/2019    $     3,434.48 $         1,067.42  $                 2,367.06  $             68,793.98
                         20/03/2019    $     3,434.48 $         1,031.91  $                 2,402.57  $             66,391.41
                         20/04/2019    $     3,434.48  $            995.87  $                 2,438.61  $             63,952.80
                         20/05/2019    $     3,434.48  $            959.29  $                 2,475.19  $             61,477.62
                         20/06/2019    $     3,434.48  $            922.16  $                 2,512.31  $             58,965.30
                         20/07/2019    $     3,434.48  $            884.48  $                 2,550.00  $             56,415.31
                         20/08/2019    $     3,434.48  $            846.23  $                 2,588.25  $             53,827.06
                         20/09/2019    $     3,434.48  $            807.41  $                 2,627.07  $             51,199.99
                         20/10/2019    $     3,434.48  $            768.00  $                 2,666.48  $             48,533.51
                         20/11/2019    $     3,434.48  $            728.00  $                 2,706.47  $             45,827.03
                         20/12/2019    $     3,434.48  $            687.41  $                 2,747.07  $             43,079.96
                         20/01/2020    $     3,434.48  $            646.20  $                 2,788.28  $             40,291.68
                         20/02/2020    $     3,434.48  $            604.38  $                 2,830.10  $             37,461.58
                         20/03/2020    $     3,434.48  $            561.92  $                 2,872.55  $             34,589.03
                         20/04/2020    $     3,434.48  $            518.84  $                 2,915.64  $             31,673.39
                         20/05/2020    $     3,434.48  $            475.10  $                 2,959.38  $             28,714.01
                         20/06/2020    $     3,434.48  $            430.71  $                 3,003.77  $             25,710.24
                         20/07/2020    $     3,434.48  $            385.65  $                 3,048.82  $             22,661.42
                         20/08/2020    $     3,434.48  $            339.92  $                 3,094.56  $             19,566.86
                         20/09/2020    $     3,434.48  $            293.50  $                 3,140.97  $             16,425.89
                         20/10/2020    $     3,434.48  $            246.39  $                 3,188.09  $             13,237.80
                         20/11/2020    $     3,434.48  $            198.57  $                 3,235.91  $             10,001.89
                         20/12/2020    $     3,434.48  $            150.03  $                 3,284.45  $               6,717.44
                         20/01/2021    $     3,434.48  $            100.76  $                 3,333.72  $               3,383.72
                         20/02/2021    $     3,434.48  $              50.76  $                 3,383.72  $0.00
   16   17   18   19   20   21   22   23   24   25   26