Page 23 - pachi
P. 23

datos
            c=          463200
            i           42%            0.105
            T           1 año
            n           20
            A           56275.68047    48636            0.86424544


                                                                                             463200
                         fecha de pago    anualidad       interes     amortizacion        saldo
                       1     26-may-18      $56,275.68   $48,636.00        $7,639.68     $455,560.32
                       2     26-ago-18      $56,275.68   $47,833.83        $8,441.85     $447,118.47
                       3     26-nov-18      $56,275.68   $46,947.44        $9,328.24     $437,790.23
                       4      26-feb-19     $56,275.68   $45,967.97       $10,307.71     $427,482.53
                       5     26-may-19      $56,275.68   $44,885.67       $11,390.02     $416,092.51
                       6     26-ago-19      $56,275.68   $43,689.71       $12,585.97     $403,506.54
                       7     26-nov-19      $56,275.68   $42,368.19       $13,907.49     $389,599.05
                       8      26-feb-20     $56,275.68   $40,907.90       $15,367.78     $374,231.27
                       9     26-may-20      $56,275.68   $39,294.28       $16,981.40     $357,249.87
                     10      26-ago-20      $56,275.68   $37,511.24       $18,764.44     $338,485.43
                     11      26-nov-20      $56,275.68   $35,540.97       $20,734.71     $317,750.72
                     12       26-feb-21     $56,275.68   $33,363.83       $22,911.86     $294,838.86
                     13      26-may-21      $56,275.68   $30,958.08       $25,317.60     $269,521.26
                     14      26-ago-21      $56,275.68   $28,299.73       $27,975.95     $241,545.32
                     15      26-nov-21      $56,275.68   $25,362.26       $30,913.42     $210,631.89
                     16       26-feb-22     $56,275.68   $22,116.35       $34,159.33     $176,472.56
                     17      26-may-22      $56,275.68   $18,529.62       $37,746.06     $138,726.50
                     18      26-ago-22      $56,275.68   $14,566.28       $41,709.40      $97,017.10
                     19      26-nov-22      $56,275.68   $10,186.80       $46,088.88      $50,928.22
                     20       26-feb-23     $56,275.68    $5,347.46       $50,928.22           $0.00
                                                        $662,313.61
   18   19   20   21   22   23   24   25   26   27   28