tabla amortizacion cuotas iguales

Post on 14-Jul-2016

215 Views

Category:

Documents

3 Downloads

Preview:

Click to see full reader

DESCRIPTION

Permite calcular tabla de amortización para cuotas iguales

TRANSCRIPT

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

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

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

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

122710.67 73080.03

122739.42 59444.19

13635.84

top related