tabla amortizacion cuotas iguales

14
TABLA DE AMORTIZACION BENEFICIARIO INSTIT. FINANCIERA CFN MONTO EN USD 27,000.00 TASA DE INTERES 6.00% PLAZO 5 años GRACIA 0 años FECHA DE INICIO 3/14/2016 MONEDA DOLARES AMORTIZACION CADA 30 días Número de períodos 60 para amortizar capital No. VENCIMIENTO SALDO INTERES 0 27,000.00 1 13-Apr-2016 26,613.01 135.00 2 13-May-2016 26,224.09 133.07 3 12-Jun-2016 25,833.23 131.12 4 12-Jul-2016 25,440.41 129.17 5 11-Aug-2016 25,045.63 127.20 6 10-Sep-2016 24,648.87 125.23 7 10-Oct-2016 24,250.13 123.24 8 09-Nov-2016 23,849.39 121.25 9 09-Dec-2016 23,446.65 119.25 10 08-Jan-2017 23,041.90 117.23 11 07-Feb-2017 22,635.12 115.21 12 09-Mar-2017 22,226.31 113.18 13 08-Apr-2017 21,815.46 111.13 14 08-May-2017 21,402.55 109.08 15 07-Jun-2017 20,987.58 107.01 16 07-Jul-2017 20,570.53 104.94 17 06-Aug-2017 20,151.40 102.85 18 05-Sep-2017 19,730.17 100.76 19 05-Oct-2017 19,306.84 98.65 20 04-Nov-2017 18,881.38 96.53 21 04-Dec-2017 18,453.80 94.41 22 03-Jan-2018 18,024.09 92.27 23 02-Feb-2018 17,592.22 90.12 24 04-Mar-2018 17,158.20 87.96 25 03-Apr-2018 16,722.00 85.79 26 03-May-2018 16,283.63 83.61 27 02-Jun-2018 15,843.06 81.42 28 02-Jul-2018 15,400.29 79.22 29 01-Aug-2018 14,955.31 77.00 30 31-Aug-2018 14,508.10 74.78 31 30-Sep-2018 14,058.65 72.54 32 30-Oct-2018 13,606.96 70.29 33 29-Nov-2018 13,153.01 68.03 34 29-Dec-2018 12,696.79 65.77 35 28-Jan-2019 12,238.29 63.48

Upload: carolina-tixe

Post on 14-Jul-2016

215 views

Category:

Documents


3 download

DESCRIPTION

Permite calcular tabla de amortización para cuotas iguales

TRANSCRIPT

Page 1: Tabla Amortizacion Cuotas Iguales

TABLA DE AMORTIZACIONBENEFICIARIO

INSTIT. FINANCIERA CFN

MONTO EN USD 27,000.00

TASA DE INTERES 6.00%

PLAZO 5 años

GRACIA 0 años

FECHA DE INICIO 3/14/2016

MONEDA DOLARES

AMORTIZACION CADA 30 días

Número de períodos 60 para amortizar capital

No. VENCIMIENTO SALDO INTERES

0 27,000.00

1 13-Apr-2016 26,613.01 135.00

2 13-May-2016 26,224.09 133.07

3 12-Jun-2016 25,833.23 131.12

4 12-Jul-2016 25,440.41 129.17

5 11-Aug-2016 25,045.63 127.20

6 10-Sep-2016 24,648.87 125.23

7 10-Oct-2016 24,250.13 123.24

8 09-Nov-2016 23,849.39 121.25

9 09-Dec-2016 23,446.65 119.25

10 08-Jan-2017 23,041.90 117.23

11 07-Feb-2017 22,635.12 115.21

12 09-Mar-2017 22,226.31 113.18

13 08-Apr-2017 21,815.46 111.13

14 08-May-2017 21,402.55 109.08

15 07-Jun-2017 20,987.58 107.01

16 07-Jul-2017 20,570.53 104.94

17 06-Aug-2017 20,151.40 102.85

18 05-Sep-2017 19,730.17 100.76

19 05-Oct-2017 19,306.84 98.65

20 04-Nov-2017 18,881.38 96.53

21 04-Dec-2017 18,453.80 94.41

22 03-Jan-2018 18,024.09 92.27

23 02-Feb-2018 17,592.22 90.12

24 04-Mar-2018 17,158.20 87.96

25 03-Apr-2018 16,722.00 85.79

26 03-May-2018 16,283.63 83.61

27 02-Jun-2018 15,843.06 81.42

28 02-Jul-2018 15,400.29 79.22

29 01-Aug-2018 14,955.31 77.00

30 31-Aug-2018 14,508.10 74.78

31 30-Sep-2018 14,058.65 72.54

32 30-Oct-2018 13,606.96 70.29

33 29-Nov-2018 13,153.01 68.03

34 29-Dec-2018 12,696.79 65.77

35 28-Jan-2019 12,238.29 63.48

Page 2: Tabla Amortizacion Cuotas Iguales

36 27-Feb-2019 11,777.49 61.19

37 29-Mar-2019 11,314.39 58.89

38 28-Apr-2019 10,848.98 56.57

39 28-May-2019 10,381.24 54.24

40 27-Jun-2019 9,911.16 51.91

41 27-Jul-2019 9,438.73 49.56

42 26-Aug-2019 8,963.94 47.19

43 25-Sep-2019 8,486.77 44.82

44 25-Oct-2019 8,007.22 42.43

45 24-Nov-2019 7,525.27 40.04

46 24-Dec-2019 7,040.91 37.63

47 23-Jan-2020 6,554.13 35.20

48 22-Feb-2020 6,064.92 32.77

49 23-Mar-2020 5,573.25 30.32

50 22-Apr-2020 5,079.14 27.87

51 22-May-2020 4,582.55 25.40

52 21-Jun-2020 4,083.47 22.91

53 21-Jul-2020 3,581.90 20.42

54 20-Aug-2020 3,077.83 17.91

55 19-Sep-2020 2,571.23 15.39

56 19-Oct-2020 2,062.10 12.86

57 18-Nov-2020 1,550.43 10.31

58 18-Dec-2020 1,038.75 7.75

59 17-Jan-2021 524.52 5.19

60 16-Feb-2021 7.73 2.62

18-Mar-2021 (511.64) 0.04

Page 3: Tabla Amortizacion Cuotas Iguales
Page 4: Tabla Amortizacion Cuotas Iguales
Page 5: Tabla Amortizacion Cuotas Iguales
Page 6: Tabla Amortizacion Cuotas Iguales
Page 7: Tabla Amortizacion Cuotas Iguales
Page 8: Tabla Amortizacion Cuotas Iguales

TABLA DE AMORTIZACION 521.99

T. EFECTIVA 6.1678%

PRINCIPAL DIVIDENDO

386.99 521.99 582.01

388.92 521.99

390.87 521.99

392.82 521.99

394.78 521.99

396.76 521.99

398.74 521.99

400.74 521.99

402.74 521.99

404.75 521.99

406.78 521.99

408.81 521.99

410.85 521.99

412.91 521.99

414.97 521.99

417.05 521.99

419.13 521.99

421.23 521.99

423.33 521.99

425.45 521.99

427.58 521.99

429.72 521.99

431.87 521.99

434.02 521.99

436.19 521.99

438.38 521.99

440.57 521.99

442.77 521.99

444.98 521.99

447.21 521.99

449.45 521.99

451.69 521.99

453.95 521.99

456.22 521.99

458.50 521.99

Page 9: Tabla Amortizacion Cuotas Iguales

460.79 521.99

463.10 521.99

465.41 521.99

467.74 521.99

470.08 521.99

472.43 521.99

474.79 521.99

477.17 521.99

479.55 521.99

481.95 521.99

484.36 521.99

486.78 521.99

489.21 521.99

491.66 521.99

494.12 521.99

496.59 521.99

499.07 521.99

501.57 521.99

504.08 521.99

506.60 521.99

509.13 521.99

511.68 521.99

514.23 521.99

516.79 521.99

519.36 521.99

521.95 521.99

Page 10: Tabla Amortizacion Cuotas Iguales
Page 11: Tabla Amortizacion Cuotas Iguales
Page 12: Tabla Amortizacion Cuotas Iguales
Page 13: Tabla Amortizacion Cuotas Iguales
Page 14: Tabla Amortizacion Cuotas Iguales

122710.67 73080.03

122739.42 59444.19

13635.84