1
Deuda $50.000.000 Monto $50.000.000 Plazo 5 # pagos año 12 Tasa efectiva anual 18% # períodos 60 Frecuencia pago 12 Tasa periódica 0,013888 Valor Cuota $1.233.670,08 # Cuota Valor Cuota Intereses Amortización Saldo 0 $0,00 $0,00 $0,00 $50.000.000,00 1 $1.233.670,08 $694.421,52 $539.248,56 $49.460.751,44 2 $1.233.670,08 $686.932,20 $546.737,88 $48.914.013,56 3 $1.233.670,08 $679.338,87 $554.331,21 $48.359.682,35 4 $1.233.670,08 $671.640,08 $562.030,00 $47.797.652,36 5 $1.233.670,08 $663.834,37 $569.835,71 $47.227.816,64 6 $1.233.670,08 $655.920,24 $577.749,84 $46.650.066,81 7 $1.233.670,08 $647.896,20 $585.773,87 $46.064.292,93 8 $1.233.670,08 $639.760,72 $593.909,35 $45.470.383,58 9 $1.233.670,08 $631.512,26 $602.157,82 $44.868.225,75 10 $1.233.670,08 $623.149,23 $610.520,85 $44.257.704,90 11 $1.233.670,08 $614.670,05 $619.000,03 $43.638.704,88 12 $1.233.670,08 $606.073,11 $627.596,97 $43.011.107,91 13 $1.233.670,08 $597.356,78 $636.313,30 $42.374.794,61 14 $1.233.670,08 $588.519,38 $645.150,70 $41.729.643,91 15 $1.233.670,08 $579.559,25 $654.110,83 $41.075.533,09 16 $1.233.670,08 $570.474,68 $663.195,40 $40.412.337,69 17 $1.233.670,08 $561.263,94 $672.406,14 $39.739.931,55 18 $1.233.670,08 $551.925,27 $681.744,81 $39.058.186,74 19 $1.233.670,08 $542.456,91 $691.213,17 $38.366.973,57 20 $1.233.670,08 $532.857,04 $700.813,04 $37.666.160,53 21 $1.233.670,08 $523.123,85 $710.546,23 $36.955.614,30 22 $1.233.670,08 $513.255,48 $720.414,60 $36.235.199,69 23 $1.233.670,08 $503.250,05 $730.420,03 $35.504.779,66 24 $1.233.670,08 $493.105,66 $740.564,42 $34.764.215,24 25 $1.233.670,08 $482.820,38 $750.849,70 $34.013.365,55 26 $1.233.670,08 $472.392,26 $761.277,82 $33.252.087,73 27 $1.233.670,08 $461.819,30 $771.850,77 $32.480.236,95 28 $1.233.670,08 $451.099,51 $782.570,57 $31.697.666,38 29 $1.233.670,08 $440.230,83 $793.439,25 $30.904.227,14 30 $1.233.670,08 $429.211,21 $804.458,87 $30.099.768,26 31 $1.233.670,08 $418.038,54 $815.631,54 $29.284.136,72 32 $1.233.670,08 $406.710,69 $826.959,39 $28.457.177,34 33 $1.233.670,08 $395.225,53 $838.444,55 $27.618.732,78 34 $1.233.670,08 $383.580,85 $850.089,23 $26.768.643,55 35 $1.233.670,08 $371.774,44 $861.895,64 $25.906.747,91 36 $1.233.670,08 $359.804,06 $873.866,01 $25.032.881,90 37 $1.233.670,08 $347.667,44 $886.002,64 $24.146.879,26 38 $1.233.670,08 $335.362,25 $898.307,83 $23.248.571,43 39 $1.233.670,08 $322.886,16 $910.783,91 $22.337.787,52 40 $1.233.670,08 $310.236,81 $923.433,27 $21.414.354,24 41 $1.233.670,08 $297.411,77 $936.258,31 $20.478.095,93 42 $1.233.670,08 $284.408,61 $949.261,47 $19.528.834,46 43 $1.233.670,08 $271.224,86 $962.445,22 $18.566.389,24 44 $1.233.670,08 $257.858,00 $975.812,07 $17.590.577,17 45 $1.233.670,08 $244.305,51 $989.364,57 $16.601.212,59 46 $1.233.670,08 $230.564,78 $1.003.105,29 $15.598.107,30 47 $1.233.670,08 $216.633,23 $1.017.036,85 $14.581.070,45 48 $1.233.670,08 $202.508,18 $1.031.161,90 $13.549.908,55 49 $1.233.670,08 $188.186,96 $1.045.483,12 $12.504.425,43 50 $1.233.670,08 $173.666,84 $1.060.003,24 $11.444.422,20 51 $1.233.670,08 $158.945,06 $1.074.725,02 $10.369.697,18 52 $1.233.670,08 $144.018,82 $1.089.651,26 $9.280.045,92 53 $1.233.670,08 $128.885,27 $1.104.784,81 $8.175.261,11 54 $1.233.670,08 $113.541,54 $1.120.128,53 $7.055.132,58 55 $1.233.670,08 $97.984,72 $1.135.685,36 $5.919.447,21 56 $1.233.670,08 $82.211,83 $1.151.458,25 $4.767.988,97 57 $1.233.670,08 $66.219,88 $1.167.450,20 $3.600.538,77 58 $1.233.670,08 $50.005,83 $1.183.664,25 $2.416.874,52 59 $1.233.670,08 $33.566,59 $1.200.103,49 $1.216.771,04 60 $1.233.670,08 $16.899,04 $1.216.771,04 $0,00 VARIABLES DATOS DEL PRÉSTAMO TABLA DE AMORTIZACIÓN

Tabla de Amortización de Préstamo

Embed Size (px)

Citation preview

Page 1: Tabla de Amortización de Préstamo

Deuda $50.000.000 Monto $50.000.000

Plazo 5 # pagos año 12

Tasa efectiva anual 18% # períodos 60

Frecuencia pago 12 Tasa periódica 0,013888

Valor Cuota $1.233.670,08

# Cuota Valor Cuota Intereses Amortización Saldo

0 $0,00 $0,00 $0,00 $50.000.000,00

1 $1.233.670,08 $694.421,52 $539.248,56 $49.460.751,44

2 $1.233.670,08 $686.932,20 $546.737,88 $48.914.013,56

3 $1.233.670,08 $679.338,87 $554.331,21 $48.359.682,35

4 $1.233.670,08 $671.640,08 $562.030,00 $47.797.652,36

5 $1.233.670,08 $663.834,37 $569.835,71 $47.227.816,64

6 $1.233.670,08 $655.920,24 $577.749,84 $46.650.066,81

7 $1.233.670,08 $647.896,20 $585.773,87 $46.064.292,93

8 $1.233.670,08 $639.760,72 $593.909,35 $45.470.383,58

9 $1.233.670,08 $631.512,26 $602.157,82 $44.868.225,75

10 $1.233.670,08 $623.149,23 $610.520,85 $44.257.704,90

11 $1.233.670,08 $614.670,05 $619.000,03 $43.638.704,88

12 $1.233.670,08 $606.073,11 $627.596,97 $43.011.107,91

13 $1.233.670,08 $597.356,78 $636.313,30 $42.374.794,61

14 $1.233.670,08 $588.519,38 $645.150,70 $41.729.643,91

15 $1.233.670,08 $579.559,25 $654.110,83 $41.075.533,09

16 $1.233.670,08 $570.474,68 $663.195,40 $40.412.337,69

17 $1.233.670,08 $561.263,94 $672.406,14 $39.739.931,55

18 $1.233.670,08 $551.925,27 $681.744,81 $39.058.186,74

19 $1.233.670,08 $542.456,91 $691.213,17 $38.366.973,57

20 $1.233.670,08 $532.857,04 $700.813,04 $37.666.160,53

21 $1.233.670,08 $523.123,85 $710.546,23 $36.955.614,30

22 $1.233.670,08 $513.255,48 $720.414,60 $36.235.199,69

23 $1.233.670,08 $503.250,05 $730.420,03 $35.504.779,66

24 $1.233.670,08 $493.105,66 $740.564,42 $34.764.215,24

25 $1.233.670,08 $482.820,38 $750.849,70 $34.013.365,55

26 $1.233.670,08 $472.392,26 $761.277,82 $33.252.087,73

27 $1.233.670,08 $461.819,30 $771.850,77 $32.480.236,95

28 $1.233.670,08 $451.099,51 $782.570,57 $31.697.666,38

29 $1.233.670,08 $440.230,83 $793.439,25 $30.904.227,14

30 $1.233.670,08 $429.211,21 $804.458,87 $30.099.768,26

31 $1.233.670,08 $418.038,54 $815.631,54 $29.284.136,72

32 $1.233.670,08 $406.710,69 $826.959,39 $28.457.177,34

33 $1.233.670,08 $395.225,53 $838.444,55 $27.618.732,78

34 $1.233.670,08 $383.580,85 $850.089,23 $26.768.643,55

35 $1.233.670,08 $371.774,44 $861.895,64 $25.906.747,91

36 $1.233.670,08 $359.804,06 $873.866,01 $25.032.881,90

37 $1.233.670,08 $347.667,44 $886.002,64 $24.146.879,26

38 $1.233.670,08 $335.362,25 $898.307,83 $23.248.571,43

39 $1.233.670,08 $322.886,16 $910.783,91 $22.337.787,52

40 $1.233.670,08 $310.236,81 $923.433,27 $21.414.354,24

41 $1.233.670,08 $297.411,77 $936.258,31 $20.478.095,93

42 $1.233.670,08 $284.408,61 $949.261,47 $19.528.834,46

43 $1.233.670,08 $271.224,86 $962.445,22 $18.566.389,24

44 $1.233.670,08 $257.858,00 $975.812,07 $17.590.577,17

45 $1.233.670,08 $244.305,51 $989.364,57 $16.601.212,59

46 $1.233.670,08 $230.564,78 $1.003.105,29 $15.598.107,30

47 $1.233.670,08 $216.633,23 $1.017.036,85 $14.581.070,45

48 $1.233.670,08 $202.508,18 $1.031.161,90 $13.549.908,55

49 $1.233.670,08 $188.186,96 $1.045.483,12 $12.504.425,43

50 $1.233.670,08 $173.666,84 $1.060.003,24 $11.444.422,20

51 $1.233.670,08 $158.945,06 $1.074.725,02 $10.369.697,18

52 $1.233.670,08 $144.018,82 $1.089.651,26 $9.280.045,92

53 $1.233.670,08 $128.885,27 $1.104.784,81 $8.175.261,11

54 $1.233.670,08 $113.541,54 $1.120.128,53 $7.055.132,58

55 $1.233.670,08 $97.984,72 $1.135.685,36 $5.919.447,21

56 $1.233.670,08 $82.211,83 $1.151.458,25 $4.767.988,97

57 $1.233.670,08 $66.219,88 $1.167.450,20 $3.600.538,77

58 $1.233.670,08 $50.005,83 $1.183.664,25 $2.416.874,52

59 $1.233.670,08 $33.566,59 $1.200.103,49 $1.216.771,04

60 $1.233.670,08 $16.899,04 $1.216.771,04 $0,00

VARIABLESDATOS DEL PRÉSTAMO

TABLA DE AMORTIZACIÓN