Page 3 - libro de pachi
P. 3

DATOS                                A= C*i/1-(1+i)
                     C=              $95,000
                     T=                  3 años
                     n=                 -12               A=                     $1,425
                     i=                18%                A=                 0.414910265
                     i=                0.015              A=                   $3,434.48
                     A=       ?
                       MECES    Fecha de Pago  Pago Anualidad  Interes    Amortizacion     Saldo
                         1         20-mar-18       $3,434.48      $1,425       $2,009.48    $92,990.52
                         2          20-abr-18      $3,434.48      $1,395       $2,039.62    $90,950.90
                         3         20-may-18       $3,434.48      $1,364       $2,070.21    $88,880.69
                         4          20-jun-18      $3,434.48      $1,333       $2,101.27    $86,779.42
                         5          20-jul-18      $3,434.48      $1,302       $2,132.79    $84,646.64
                         6          20-ago-18      $3,434.48      $1,270       $2,164.78    $82,481.86
                         7          20-sep-18      $3,434.48      $1,237       $2,197.25    $80,284.61
                         8          20-oct-18      $3,434.48      $1,204       $2,230.21    $78,054.40
                         9          20-nov-18      $3,434.48      $1,171       $2,263.66    $75,790.74
                        10          20-dic-18      $3,434.48      $1,137       $2,297.62    $73,493.12
                        11          20-ene-19      $3,434.48      $1,102       $2,332.08    $71,161.04
                        12          20-feb-19      $3,434.48      $1,067       $2,367.06    $68,793.98
                        13         20-mar-19       $3,434.48      $1,032       $2,402.57    $66,391.41
                        14          20-abr-19      $3,434.48       $996        $2,438.61    $63,952.80
                        15         20-may-19       $3,434.48       $959        $2,475.19    $61,477.62
                        16          20-jun-19      $3,434.48       $922        $2,512.31    $58,965.30
                        17          20-jul-19      $3,434.48       $884        $2,550.00    $56,415.31
                        18          20-ago-19      $3,434.48       $846        $2,588.25    $53,827.06
                        19          20-sep-19      $3,434.48       $807        $2,627.07    $51,199.99
                        20          20-oct-19      $3,434.48       $768        $2,666.48    $48,533.51
                        21          20-nov-19      $3,434.48       $728        $2,706.47    $45,827.03
                        22          20-dic-19      $3,434.48       $687        $2,747.07    $43,079.96
                        23          20-ene-20      $3,434.48       $646        $2,788.28    $40,291.68
                        24          20-feb-20      $3,434.48       $604        $2,830.10    $37,461.58
                        25         20-mar-20       $3,434.48       $562        $2,872.55    $34,589.03
                        26          20-abr-20      $3,434.48       $519        $2,915.64    $31,673.39
                        27         20-may-20       $3,434.48       $475        $2,959.38    $28,714.01
                        28          20-jun-20      $3,434.48       $431        $3,003.77    $25,710.24
                        29          20-jul-20      $3,434.48       $386        $3,048.82    $22,661.42
                        30          20-ago-20      $3,434.48       $340        $3,094.56    $19,566.86
                        31          20-sep-20      $3,434.48       $294        $3,140.97    $16,425.89
                        32          20-oct-20      $3,434.48       $246        $3,188.09    $13,237.80
                        33          20-nov-20      $3,434.48       $199        $3,235.91    $10,001.89
                        34          20-dic-20      $3,434.48       $150        $3,284.45     $6,717.44
                        35          20-ene-21      $3,434.48       $101        $3,333.72     $3,383.72
                        36          20-feb-21      $3,434.48        $51        $3,383.72        $0.00
   1   2   3   4   5   6   7   8