Upload
diego-torres
View
217
Download
1
Embed Size (px)
DESCRIPTION
tabla analisis cuotas de credito bancario
Citation preview
Hoja1prestamo3000000cuotas36interes Einteres2.00%#cuotainteresesabono valor cuotasaldo final00.00.00.0$3,000,000.001$60,000.00$57,698.56$117,698.56$2,942,301.44$117,698.562$58,846.03$58,852.53$117,698.56$2,883,448.913$57,668.98$60,029.58$117,698.56$2,823,419.334$56,468.39$61,230.17$117,698.56$2,762,189.165$55,243.78$62,454.77$117,698.56$2,699,734.396$53,994.69$63,703.87$117,698.56$2,636,030.527$52,720.61$64,977.95$117,698.56$2,571,052.578$51,421.05$66,277.51$117,698.56$2,504,775.069$50,095.50$67,603.06$117,698.56$2,437,172.0110$48,743.44$68,955.12$117,698.56$2,368,216.8911$47,364.34$70,334.22$117,698.56$2,297,882.6712$45,957.65$71,740.90$117,698.56$2,226,141.7713$44,522.84$73,175.72$117,698.56$2,152,966.0414$43,059.32$74,639.24$117,698.56$2,078,326.8115$41,566.54$76,132.02$117,698.56$2,002,194.7816$40,043.90$77,654.66$117,698.56$1,924,540.1217$38,490.80$79,207.76$117,698.56$1,845,332.3718$36,906.65$80,791.91$117,698.56$1,764,540.4619$35,290.81$82,407.75$117,698.56$1,682,132.7120$33,642.65$84,055.90$117,698.56$1,598,076.8021$31,961.54$85,737.02$117,698.56$1,512,339.7822$30,246.80$87,451.76$117,698.56$1,424,888.0223$28,497.76$89,200.80$117,698.56$1,335,687.2224$26,713.74$90,984.81$117,698.56$1,244,702.4125$24,894.05$92,804.51$117,698.56$1,151,897.9026$23,037.96$94,660.60$117,698.56$1,057,237.3027$21,144.75$96,553.81$117,698.56$960,683.4928$19,213.67$98,484.89$117,698.56$862,198.6029$17,243.97$100,454.59$117,698.56$761,744.0130$15,234.88$102,463.68$117,698.56$659,280.3431$13,185.61$104,512.95$117,698.56$554,767.3932$11,095.35$106,603.21$117,698.56$448,164.1833$8,963.28$108,735.27$117,698.56$339,428.9034$6,788.58$110,909.98$117,698.56$228,518.9235$4,570.38$113,128.18$117,698.56$115,390.7436$2,307.81$115,390.74$117,698.56$0.00
HALLAR UNA EXPRESIN (FORMULA) QUE PERMITA HALLAR EL VALOR DE LA COLUMNA DE ABONOS PARA CUALQUIER #CUOTA, OTRA QUE PERMITA HALLAR LA COLUMNA SALDO FINAL PARA CUALQUIER #CUOTA, Y OTRA PARA LA COLUMNA INTERES, PARA CUALQUIER # DE CUOTA. ES DECIR UNA FORMULA CON LA QUE PODAMOS HALLAR LO ANTERIOR SIN NECESIDAD DE PONERSE A HACER TODA LA TABLA