Formula Para Tabla de Amortizacion

(1)

CUADRO DE AMORTIZACIÓN DE PRÉSTAMOS

iim

mp

por

ortte

e

1

19 9,,8

84

45 5,,2

24

49

9

PAGOS TOTALESPAGOS TOTALES

a

añ

ño

os

s

1

10

0 PRINCIPAL

PRINCIPAL

19,845,249.0019,845,249.00

c

co

om

miis

siió

ón

n d

de

e a

ap

pe

errttu

urra

a

3..0

3

00 0%

%

IIN

NT

TE

ER

RE

ES

SE

ES

S

99,,336633,,661133..6622

iin

ntte

erré

és

s n

no

om

miin

na

al

l

8 8..2

25 5%

%

COMISIÓN

595,357.47595,357.47

p

pe

erriio

od

do

o d

de

e p

pa

ag

go

o

1

12

2

TOTALTOTAL 29,804,220.0929,804,220.09

ttiip

po

o a

am

mo

orrttiiz

za

ac

ciió

ón

n

1

1 francés

francés

c

co

os

stte

e e

effe

ec

cttiiv

vo

o

9 9..3

33 3%

%

m

me

es

se

es

s

c

cu

uo

otta

a

iin

ntte

erre

es

se

es

s

a

am

mo

orrttiiz

za

ac

ciió

ón

n

a

am

mo

orrttiiz

za

ad

do

o

p

pe

en

nd

diie

en

ntte

e

0

19,845,249.0019,845,249.00

1

224433,,440077..119 9 113366,,443366..009 9 110066997711..110 0 110066,,997711..110 0 1199,,773388,,227777..9900

2

224433,,440077..119 9 113355,,770000..666 6 110077770066..553 3 221144,,667777..663 3 1199,,663300,,557711..3377

3

224433,,440077..119 9 113344,,996600..118 8 110088444477..001 1 332233,,112244..664 4 1199,,552222,,112244..3366

4

224433,,440077..119 9 113344,,221144..660 0 110099119922..558 8 443322,,331177..222 2 1199,,441122,,993311..7788

5

224433,,440077..119 9 113333,,446633..991 1 110099994433..228 8 554422,,226600..551 1 1199,,330022,,998888..4499

6

224433,,440077..119 9 113322,,770088..005 5 111100669999..114 4 665522,,995599..665 5 1199,,119922,,228899..3355

7

224433,,440077..119 9 113311,,994466..999 9 111111446600..220 0 776644,,441199..885 5 1199,,008800,,882299..1155

8

224433,,440077..119 9 113311,,118800..770 0 111122222266..449 9 887766,,664466..334 4 1188,,996688,,660022..6666

9

224433,,440077..119 9 113300,,440099..114 4 111122999988..005 5 998899,,664444..338 8 1188,,885555,,660044..6622

10

224433,,440077..119 9 112299,,663322..228 8 111133777744..991 1 11,,110033,,441199..229 9 1188,,774411,,882299..7711

11

224433,,440077..119 9 112288,,885500..008 8 111144555577..111 1 11,,221177,,997766..440 0 1188,,662277,,227722..6600

12

224433,,440077..119 9 112288,,006622..550 0 111155334444..669 9 11,,333333,,332211..009 9 1188,,551111,,992277..9911

13

224433,,440077..119 9 112277,,226699..550 0 111166113377..668 8 11,,444499,,445588..777 7 1188,,339955,,779900..2233

14

224433,,440077..119 9 112266,,447711..006 6 111166993366..113 3 11,,556666,,339944..990 0 1188,,227788,,885544..1100

15

224433,,440077..119 9 112255,,666677..112 2 111177774400..007 7 11,,668844,,113344..997 7 1188,,116611,,111144..0033

16

224433,,440077..119 9 112244,,885577..666 6 111188554499..553 3 11,,880022,,668844..550 0 1188,,004422,,556644..5500

17

224433,,440077..119 9 112244,,004422..663 3 111199336644..556 6 11,,992222,,004499..006 6 1177,,992233,,119999..9944

18

224433,,440077..119 9 112233,,222222..000 0 112200118855..119 9 22,,004422,,223344..224 4 1177,,880033,,001144..7766

19

224433,,440077..119 9 112222,,339955..773 3 112211001111..446 6 22,,116633,,224455..771 1 1177,,668822,,000033..2299

20

224433,,440077..119 9 112211,,556633..777 7 112211884433..442 2 22,,228855,,008899..112 2 1177,,556600,,115599..8888

21

224433,,440077..119 9 112200,,772266..110 0 112222668811..009 9 22,,440077,,777700..221 1 1177,,443377,,447788..7799

22

224433,,440077..119 9 111199,,888822..667 7 112233552244..552 2 22,,553311,,229944..773 3 1177,,331133,,995544..2277

23

224433,,440077..119 9 111199,,003333..444 4 112244337733..775 5 22,,665555,,666688..449 9 1177,,118899,,558800..5511

24

224433,,440077..119 9 111188,,117788..337 7 112255222288..882 2 22,,778800,,889977..331 1 1177,,006644,,335511..6699

25

224433,,440077..119 9 111177,,331177..442 2 112266008899..777 7 22,,990066,,998877..008 8 1166,,993388,,226611..9922

26

224433,,440077..119 9 111166,,445500..555 5 112266995566..664 4 33,,003333,,994433..772 2 1166,,881111,,330055..2288

27

224433,,440077..119 9 111155,,557777..772 2 112277882299..446 6 33,,116611,,777733..118 8 1166,,668833,,447755..8822

28

224433,,440077..119 9 111144,,669988..990 0 112288770088..229 9 33,,229900,,448811..447 7 1166,,555544,,776677..5533

29

224433,,440077..119 9 111133,,881144..003 3 112299559933..116 6 33,,442200,,007744..664 4 1166,,442255,,117744..3366

30

224433,,440077..119 9 111122,,992233..007 7 113300448844..111 1 33,,555500,,555588..775 5 1166,,229944,,669900..2255

31

224433,,440077..119 9 111122,,002266..000 0 113311338811..119 9 33,,668811,,993399..994 4 1166,,116633,,330099..0066

32

224433,,440077..119 9 111111,,112222..775 5 113322228844..444 4 33,,881144,,222244..338 8 1166,,003311,,002244..6622

33

224433,,440077..119 9 111100,,221133..229 9 113333119933..889 9 33,,994477,,441188..228 8 1155,,889977,,883300..7722

34

224433,,440077..119 9 110099,,229977..559 9 113344110099..660 0 44,,008811,,552277..888 8 1155,,776633,,772211..1122

35

224433,,440077..119 9 110088,,337755..558 8 113355003311..661 1 44,,221166,,555599..449 9 1155,,662288,,668899..5511

36

224433,,440077..119 9 110077,,444477..224 4 113355995599..995 5 44,,335522,,551199..443 3 1155,,449922,,772299..5577

37

224433,,440077..119 9 110066,,551122..552 2 113366889944..667 7 44,,448899,,441144..111 1 1155,,335555,,883344..8899

38

224433,,440077..119 9 110055,,557711..336 6 113377883355..882 2 44,,662277,,224499..993 3 1155,,221177,,999999..0077

www.economia-excel.com

(2)

41

243,407.19 102,708.91 140698.28 5,046,469.23 14,798,779.77

42

243,407.19 101,741.61 141665.58 5,188,134.81 14,657,114.19

43

243,407.19 100,767.66 142639.53 5,330,774.34 14,514,474.66

44

243,407.19 99,787.01 143620.18 5,474,394.51 14,370,854.49

45

243,407.19 98,799.62 144607.56 5,619,002.08 14,226,246.92

46

243,407.19 97,805.45 145601.74 5,764,603.82 14,080,645.18

47

243,407.19 96,804.44 146602.75 5,911,206.57 13,934,042.43

48

243,407.19 95,796.54 147610.65 6,058,817.22 13,786,431.78

49

243,407.19 94,781.72 148625.47 6,207,442.69 13,637,806.31

50

243,407.19 93,759.92 149647.27 6,357,089.96 13,488,159.04

51

243,407.19 92,731.09 150676.10 6,507,766.05 13,337,482.95

52

243,407.19 91,695.20 151711.99 6,659,478.05 13,185,770.95

53

243,407.19 90,652.18 152755.01 6,812,233.06 13,033,015.94

54

243,407.19 89,601.98 153805.20 6,966,038.26 12,879,210.74

55

243,407.19 88,544.57 154862.61 7,120,900.88 12,724,348.12

56

243,407.19 87,479.89 155927.30 7,276,828.17 12,568,420.83

57

243,407.19 86,407.89 156999.30 7,433,827.47 12,411,421.53

58

243,407.19 85,328.52 158078.67 7,591,906.14 12,253,342.86

59

243,407.19 84,241.73 159165.46 7,751,071.59 12,094,177.41

60

243,407.19 83,147.47 160259.72 7,911,331.31 11,933,917.69

61

243,407.19 82,045.68 161361.50 8,072,692.82 11,772,556.18

62

243,407.19 80,936.32 162470.86 8,235,163.68 11,610,085.32

63

243,407.19 79,819.34 163587.85 8,398,751.53 11,446,497.47

64

243,407.19 78,694.67 164712.52 8,563,464.05 11,281,784.95

65

243,407.19 77,562.27 165844.92 8,729,308.97 11,115,940.03

66

243,407.19 76,422.09 166985.10 8,896,294.07 10,948,954.93

67

243,407.19 75,274.07 168133.12 9,064,427.19 10,780,821.81

68

243,407.19 74,118.15 169289.04 9,233,716.23 10,611,532.77

69

243,407.19 72,954.29 170452.90 9,404,169.13 10,441,079.87

70

243,407.19 71,782.42 171624.76 9,575,793.90 10,269,455.10

71

243,407.19 70,602.50 172804.68 9,748,598.58 10,096,650.42

72

243,407.19 69,414.47 173992.72 9,922,591.30 9,922,657.70

73

243,407.19 68,218.27 175188.92 10,097,780.21 9,747,468.79

74

243,407.19 67,013.85 176393.34 10,274,173.55 9,571,075.45

75

243,407.19 65,801.14 177606.04 10,451,779.60 9,393,469.40

76

243,407.19 64,580.10 178827.09 10,630,606.69 9,214,642.31

77

243,407.19 63,350.67 180056.52 10,810,663.21 9,034,585.79

78

243,407.19 62,112.78 181294.41 10,991,957.62 8,853,291.38

79

243,407.19 60,866.38 182540.81 11,174,498.43 8,670,750.57

80

243,407.19 59,611.41 183795.78 11,358,294.21 8,486,954.79

81

243,407.19 58,347.81 185059.37 11,543,353.58 8,301,895.42

82

243,407.19 57,075.53 186331.66 11,729,685.24 8,115,563.76

83

243,407.19 55,794.50 187612.69 11,917,297.93 7,927,951.07

84

243,407.19 54,504.66 188902.52 12,106,200.45 7,739,048.55

85

243,407.19 53,205.96 190201.23 12,296,401.68 7,548,847.32

86

243,407.19 51,898.33 191508.86 12,487,910.55 7,357,338.45

87

243,407.19 50,581.70 192825.49 12,680,736.03 7,164,512.97

88

243,407.19 49,256.03 194151.16 12,874,887.19 6,970,361.81

89

243,407.19 47,921.24 195485.95 13,070,373.15 6,774,875.85

90

243,407.19 46,577.27 196829.92 13,267,203.06 6,578,045.94

91

243,407.19 45,224.07 198183.12 13,465,386.19 6,379,862.81

92

243,407.19 43,861.56 199545.63 13,664,931.82 6,180,317.18

93

243,407.19 42,489.68 200917.51 13,865,849.32 5,979,399.68

94

243,407.19 41,108.37 202298.82 14,068,148.14 5,777,100.86

95

243,407.19 39,717.57 203689.62 14,271,837.76 5,573,411.24

96

243,407.19 38,317.20 205089.99 14,476,927.75 5,368,321.25

97

243 407 19 36 907 21 206499 98 14 683 427 73 5 161 821 27

(3)

100

243,407.19 32,618.80 210788.39 15,311,484.90 4,533,764.10

101

243,407.19 31,169.63 212237.56 15,523,722.46 4,321,526.54

102

243,407.19 29,710.49 213696.69 15,737,419.15 4,107,829.85

103

243,407.19 28,241.33 215165.86 15,952,585.01 3,892,663.99

104

243,407.19 26,762.06 216645.12 16,169,230.14 3,676,018.86

105

243,407.19 25,272.63 218134.56 16,387,364.69 3,457,884.31

106

243,407.19 23,772.95 219634.23 16,606,998.93 3,238,250.07

107

243,407.19 22,262.97 221144.22 16,828,143.15 3,017,105.85

108

243,407.19 20,742.60 222664.59 17,050,807.73 2,794,441.27

109

243,407.19 19,211.78 224195.40 17,275,003.14 2,570,245.86

110

243,407.19 17,670.44 225736.75 17,500,739.89 2,344,509.11

111

243,407.19 16,118.50 227288.69 17,728,028.57 2,117,220.43

112

243,407.19 14,555.89 228851.30 17,956,879.87 1,888,369.13

113

243,407.19 12,982.54 230424.65 18,187,304.52 1,657,944.48

114

243,407.19 11,398.37 232008.82 18,419,313.34 1,425,935.66

115

243,407.19 9,803.31 233603.88 18,652,917.22 1,192,331.78

116

243,407.19 8,197.28 235209.91 18,888,127.13 957,121.87

117

243,407.19 6,580.21 236826.98 19,124,954.11 720,294.89

118

243,407.19 4,952.03 238455.16 19,363,409.27 481,839.73

119

243,407.19 3,312.65 240094.54 19,603,503.81 241,745.19

120

243,407.19 1,662.00 241745.19 19,845,249.00 0.00

(4)

(5)

(6)

(7)

(8)

(9)

(10)

La presente publicación no contiene datos de carácter personal.

Microsoft y Microsoft Excel son marcas registradas por Microsoft Corporation.

Lector de noticias:

Correo electrónico:

Facebook:

Twitter:

La citada Web tiene como objetivo la publicación y distribución de herramientas

Excel, aplicadas a la Economía, la Formación y la Gestión de Empresas

Se autoriza la distribución del presente Libro Excel, a través de correo electrónico,

redes sociales, etc. siempre que no se altere su estructura ni contenido.

No se responsabiliza de los resultados obtenidos por la utilización de la presente

aplicación en cualquier ámbito que se utilice (académicos, profesionales,

empresarial, personal, etc.)

El

seguimiento y suscripciones

a la Web se pueden realizar a través de:

http://economia-excel.blogspot.com/feeds/posts/default

http://feedburner.google.com/fb/a/mailverify?uri=economia-excel&loc=es_ES

http://www.facebook.com/economia.excel

(11)