formula para tabla de amortizacion

Upload: paulo-pereira-monge

Post on 07-Jul-2015

10.161 views

Category:

Documents


0 download

TRANSCRIPT

### ###

CUADRO DE AMORTIZACIN DE PRSTAMOSimporte aos comisin de apertura inters nominal periodo de pago tipo amortizacin francs coste efectivo meses 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 cuota243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19

19,845,249 10 3.00% 8.25% 12 1

PAGOS TOTALESPRINCIPAL INTERESES COMISIN TOTAL 19,845,249.00 9,363,613.62 595,357.47 29,804,220.09

### ### ###

9.33% intereses136,436.09 135,700.66 134,960.18 134,214.60 133,463.91 132,708.05 131,946.99 131,180.70 130,409.14 129,632.28 128,850.08 128,062.50 127,269.50 126,471.06 125,667.12 124,857.66 124,042.63 123,222.00 122,395.73 121,563.77 120,726.10 119,882.67 119,033.44 118,178.37 117,317.42 116,450.55 115,577.72 114,698.90 113,814.03 112,923.07 112,026.00 111,122.75 110,213.29 109,297.59 108,375.58 107,447.24 106,512.52 105,571.36 104,623.74 103,669.61

www.economia-excel.com amortizacin106971.10 107706.53 108447.01 109192.58 109943.28 110699.14 111460.20 112226.49 112998.05 113774.91 114557.11 115344.69 116137.68 116936.13 117740.07 118549.53 119364.56 120185.19 121011.46 121843.42 122681.09 123524.52 124373.75 125228.82 126089.77 126956.64 127829.46 128708.29 129593.16 130484.11 131381.19 132284.44 133193.89 134109.60 135031.61 135959.95 136894.67 137835.82 138783.44 139737.58

amortizado106,971.10 214,677.63 323,124.64 432,317.22 542,260.51 652,959.65 764,419.85 876,646.34 989,644.38 1,103,419.29 1,217,976.40 1,333,321.09 1,449,458.77 1,566,394.90 1,684,134.97 1,802,684.50 1,922,049.06 2,042,234.24 2,163,245.71 2,285,089.12 2,407,770.21 2,531,294.73 2,655,668.49 2,780,897.31 2,906,987.08 3,033,943.72 3,161,773.18 3,290,481.47 3,420,074.64 3,550,558.75 3,681,939.94 3,814,224.38 3,947,418.28 4,081,527.88 4,216,559.49 4,352,519.43 4,489,414.11 4,627,249.93 4,766,033.37 4,905,770.96

pendiente19,845,249.00 19,738,277.90 19,630,571.37 19,522,124.36 19,412,931.78 19,302,988.49 19,192,289.35 19,080,829.15 18,968,602.66 18,855,604.62 18,741,829.71 18,627,272.60 18,511,927.91 18,395,790.23 18,278,854.10 18,161,114.03 18,042,564.50 17,923,199.94 17,803,014.76 17,682,003.29 17,560,159.88 17,437,478.79 17,313,954.27 17,189,580.51 17,064,351.69 16,938,261.92 16,811,305.28 16,683,475.82 16,554,767.53 16,425,174.36 16,294,690.25 16,163,309.06 16,031,024.62 15,897,830.72 15,763,721.12 15,628,689.51 15,492,729.57 15,355,834.89 15,217,999.07 15,079,215.63 14,939,478.04

### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###

41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99

243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19

102,708.91 101,741.61 100,767.66 99,787.01 98,799.62 97,805.45 96,804.44 95,796.54 94,781.72 93,759.92 92,731.09 91,695.20 90,652.18 89,601.98 88,544.57 87,479.89 86,407.89 85,328.52 84,241.73 83,147.47 82,045.68 80,936.32 79,819.34 78,694.67 77,562.27 76,422.09 75,274.07 74,118.15 72,954.29 71,782.42 70,602.50 69,414.47 68,218.27 67,013.85 65,801.14 64,580.10 63,350.67 62,112.78 60,866.38 59,611.41 58,347.81 57,075.53 55,794.50 54,504.66 53,205.96 51,898.33 50,581.70 49,256.03 47,921.24 46,577.27 45,224.07 43,861.56 42,489.68 41,108.37 39,717.57 38,317.20 36,907.21 35,487.52 34,058.07

140698.28 141665.58 142639.53 143620.18 144607.56 145601.74 146602.75 147610.65 148625.47 149647.27 150676.10 151711.99 152755.01 153805.20 154862.61 155927.30 156999.30 158078.67 159165.46 160259.72 161361.50 162470.86 163587.85 164712.52 165844.92 166985.10 168133.12 169289.04 170452.90 171624.76 172804.68 173992.72 175188.92 176393.34 177606.04 178827.09 180056.52 181294.41 182540.81 183795.78 185059.37 186331.66 187612.69 188902.52 190201.23 191508.86 192825.49 194151.16 195485.95 196829.92 198183.12 199545.63 200917.51 202298.82 203689.62 205089.99 206499.98 207919.67 209349.11

5,046,469.23 5,188,134.81 5,330,774.34 5,474,394.51 5,619,002.08 5,764,603.82 5,911,206.57 6,058,817.22 6,207,442.69 6,357,089.96 6,507,766.05 6,659,478.05 6,812,233.06 6,966,038.26 7,120,900.88 7,276,828.17 7,433,827.47 7,591,906.14 7,751,071.59 7,911,331.31 8,072,692.82 8,235,163.68 8,398,751.53 8,563,464.05 8,729,308.97 8,896,294.07 9,064,427.19 9,233,716.23 9,404,169.13 9,575,793.90 9,748,598.58 9,922,591.30 10,097,780.21 10,274,173.55 10,451,779.60 10,630,606.69 10,810,663.21 10,991,957.62 11,174,498.43 11,358,294.21 11,543,353.58 11,729,685.24 11,917,297.93 12,106,200.45 12,296,401.68 12,487,910.55 12,680,736.03 12,874,887.19 13,070,373.15 13,267,203.06 13,465,386.19 13,664,931.82 13,865,849.32 14,068,148.14 14,271,837.76 14,476,927.75 14,683,427.73 14,891,347.39 15,100,696.51

14,798,779.77 14,657,114.19 14,514,474.66 14,370,854.49 14,226,246.92 14,080,645.18 13,934,042.43 13,786,431.78 13,637,806.31 13,488,159.04 13,337,482.95 13,185,770.95 13,033,015.94 12,879,210.74 12,724,348.12 12,568,420.83 12,411,421.53 12,253,342.86 12,094,177.41 11,933,917.69 11,772,556.18 11,610,085.32 11,446,497.47 11,281,784.95 11,115,940.03 10,948,954.93 10,780,821.81 10,611,532.77 10,441,079.87 10,269,455.10 10,096,650.42 9,922,657.70 9,747,468.79 9,571,075.45 9,393,469.40 9,214,642.31 9,034,585.79 8,853,291.38 8,670,750.57 8,486,954.79 8,301,895.42 8,115,563.76 7,927,951.07 7,739,048.55 7,548,847.32 7,357,338.45 7,164,512.97 6,970,361.81 6,774,875.85 6,578,045.94 6,379,862.81 6,180,317.18 5,979,399.68 5,777,100.86 5,573,411.24 5,368,321.25 5,161,821.27 4,953,901.61 4,744,552.49

### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###

100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120

243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19 243,407.19

32,618.80 31,169.63 29,710.49 28,241.33 26,762.06 25,272.63 23,772.95 22,262.97 20,742.60 19,211.78 17,670.44 16,118.50 14,555.89 12,982.54 11,398.37 9,803.31 8,197.28 6,580.21 4,952.03 3,312.65 1,662.00

210788.39 212237.56 213696.69 215165.86 216645.12 218134.56 219634.23 221144.22 222664.59 224195.40 225736.75 227288.69 228851.30 230424.65 232008.82 233603.88 235209.91 236826.98 238455.16 240094.54 241745.19

15,311,484.90 15,523,722.46 15,737,419.15 15,952,585.01 16,169,230.14 16,387,364.69 16,606,998.93 16,828,143.15 17,050,807.73 17,275,003.14 17,500,739.89 17,728,028.57 17,956,879.87 18,187,304.52 18,419,313.34 18,652,917.22 18,888,127.13 19,124,954.11 19,363,409.27 19,603,503.81 19,845,249.00

4,533,764.10 4,321,526.54 4,107,829.85 3,892,663.99 3,676,018.86 3,457,884.31 3,238,250.07 3,017,105.85 2,794,441.27 2,570,245.86 2,344,509.11 2,117,220.43 1,888,369.13 1,657,944.48 1,425,935.66 1,192,331.78 957,121.87 720,294.89 481,839.73 241,745.19 0.00

### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###

www.economia-excel.com y economia-excel.blogspot.com La citada Web tiene como objetivo la publicacin y distribucin de herramientas Excel, aplicadas a la Economa, la Formacin y la Gestin de Empresas

Se autoriza la distribucin del presente Libro Excel, a travs de correo electrnico, redes sociales, etc. siempre que no se altere su estructura ni contenido. No se responsabiliza de los resultados obtenidos por la utilizacin de la presente aplicacin en cualquier mbito que se utilice (acadmicos, profesionales, empresarial, personal, etc.) La presente publicacin no contiene datos de carcter personal. Microsoft y Microsoft Excel son marcas registradas por Microsoft Corporation. El seguimiento y suscripciones a la Web se pueden realizar a travs de: Lector de noticias: http://economia-excel.blogspot.com/feeds/posts/default Correo electrnico: http://feedburner.google.com/fb/a/mailverify?uri=economia-excel&loc=es_ES Facebook: http://www.facebook.com/economia.excel Twitter: http://twitter.com/economiaexcel