excel finan amortizar

Upload: katherine101718

Post on 07-Jan-2016

214 views

Category:

Documents


0 download

DESCRIPTION

Ejemplo para amortizar

TRANSCRIPT

AmortizacinPLAN DE AMORTIZACIN CON CUOTA FIJA

MONTO$ 3,000,000.00PERIODO6Tasa0.8%PAGO$ 513,206.72TIPO CREDITOCrediestudioPERIODOSALDO INICIALINTERESCUOTAABONO A KAPITALSALDO FINAL0$ 3,000,000.00$ 0.00$ 0.00$ 0.00$ 3,000,000.001$ 3,000,000.00$ 22,500.00$ 513,206.72$ 490,706.72$ 2,509,293.282$ 2,509,293.28$ 18,819.70$ 513,206.72$ 494,387.02$ 2,014,906.253$ 2,014,906.25$ 15,111.80$ 513,206.72$ 498,094.93$ 1,516,811.334$ 1,516,811.33$ 11,376.08$ 513,206.72$ 501,830.64$ 1,014,980.695$ 1,014,980.69$ 7,612.36$ 513,206.72$ 505,594.37$ 509,386.326$ 509,386.32$ 3,820.40$ 513,206.72$ 509,386.32$ 0.007$ 0.00$ 0.00$ 513,206.72$ 513,206.72($ 513,206.72)8($ 513,206.72)($ 3,849.05)$ 513,206.72$ 517,055.77($ 1,030,262.50)9($ 1,030,262.50)($ 7,726.97)$ 513,206.72$ 520,933.69($ 1,551,196.19)10($ 1,551,196.19)($ 11,633.97)$ 513,206.72$ 524,840.69($ 2,076,036.88)11($ 2,076,036.88)($ 15,570.28)$ 513,206.72$ 528,777.00($ 2,604,813.88)12($ 2,604,813.88)($ 19,536.10)$ 513,206.72$ 532,742.83($ 3,137,556.71)13($ 3,137,556.71)($ 23,531.68)$ 513,206.72$ 536,738.40($ 3,674,295.10)14($ 3,674,295.10)($ 27,557.21)$ 513,206.72$ 540,763.94($ 4,215,059.04)15($ 4,215,059.04)($ 31,612.94)$ 513,206.72$ 544,819.67($ 4,759,878.70)16($ 4,759,878.70)($ 35,699.09)$ 513,206.72$ 548,905.81($ 5,308,784.52)17($ 5,308,784.52)($ 39,815.88)$ 513,206.72$ 553,022.61($ 5,861,807.12)18($ 5,861,807.12)($ 43,963.55)$ 513,206.72$ 557,170.28($ 6,418,977.40)19($ 6,418,977.40)($ 48,142.33)$ 513,206.72$ 561,349.05($ 6,980,326.45)20($ 6,980,326.45)($ 52,352.45)$ 513,206.72$ 565,559.17($ 7,545,885.62)21($ 7,545,885.62)($ 56,594.14)$ 513,206.72$ 569,800.86($ 8,115,686.49)22($ 8,115,686.49)($ 60,867.65)$ 513,206.72$ 574,074.37($ 8,689,760.86)23($ 8,689,760.86)($ 65,173.21)$ 513,206.72$ 578,379.93($ 9,268,140.79)24($ 9,268,140.79)($ 69,511.06)$ 513,206.72$ 582,717.78($ 9,850,858.56)25($ 9,850,858.56)($ 73,881.44)$ 513,206.72$ 587,088.16($ 10,437,946.73)26($ 10,437,946.73)($ 78,284.60)$ 513,206.72$ 591,491.32($ 11,029,438.05)27($ 11,029,438.05)($ 82,720.79)$ 513,206.72$ 595,927.51($ 11,625,365.56)28($ 11,625,365.56)($ 87,190.24)$ 513,206.72$ 600,396.96($ 12,225,762.52)29($ 12,225,762.52)($ 91,693.22)$ 513,206.72$ 604,899.94($ 12,830,662.46)30($ 12,830,662.46)($ 96,229.97)$ 513,206.72$ 609,436.69($ 13,440,099.15)31($ 13,440,099.15)($ 100,800.74)$ 513,206.72$ 614,007.47($ 14,054,106.62)32($ 14,054,106.62)($ 105,405.80)$ 513,206.72$ 618,612.52($ 14,672,719.14)33($ 14,672,719.14)($ 110,045.39)$ 513,206.72$ 623,252.12($ 15,295,971.26)34($ 15,295,971.26)($ 114,719.78)$ 513,206.72$ 627,926.51($ 15,923,897.76)35($ 15,923,897.76)($ 119,429.23)$ 513,206.72$ 632,635.96($ 16,556,533.72)36($ 16,556,533.72)($ 124,174.00)$ 513,206.72$ 637,380.73($ 17,193,914.44)37($ 17,193,914.44)($ 128,954.36)$ 513,206.72$ 642,161.08($ 17,836,075.52)38($ 17,836,075.52)($ 133,770.57)$ 513,206.72$ 646,977.29($ 18,483,052.81)39($ 18,483,052.81)($ 138,622.90)$ 513,206.72$ 651,829.62($ 19,134,882.43)40($ 19,134,882.43)($ 143,511.62)$ 513,206.72$ 656,718.34($ 19,791,600.77)41($ 19,791,600.77)($ 148,437.01)$ 513,206.72$ 661,643.73($ 20,453,244.50)42($ 20,453,244.50)($ 153,399.33)$ 513,206.72$ 666,606.06($ 21,119,850.56)43($ 21,119,850.56)($ 158,398.88)$ 513,206.72$ 671,605.60($ 21,791,456.16)44($ 21,791,456.16)($ 163,435.92)$ 513,206.72$ 676,642.64($ 22,468,098.80)45($ 22,468,098.80)($ 168,510.74)$ 513,206.72$ 681,717.46($ 23,149,816.27)46($ 23,149,816.27)($ 173,623.62)$ 513,206.72$ 686,830.34($ 23,836,646.61)47($ 23,836,646.61)($ 178,774.85)$ 513,206.72$ 691,981.57($ 24,528,628.18)48($ 24,528,628.18)($ 183,964.71)$ 513,206.72$ 697,171.43($ 25,225,799.62)49($ 25,225,799.62)($ 189,193.50)$ 513,206.72$ 702,400.22($ 25,928,199.83)50($ 25,928,199.83)($ 194,461.50)$ 513,206.72$ 707,668.22($ 26,635,868.06)51($ 26,635,868.06)($ 199,769.01)$ 513,206.72$ 712,975.73($ 27,348,843.79)52($ 27,348,843.79)($ 205,116.33)$ 513,206.72$ 718,323.05($ 28,067,166.84)53($ 28,067,166.84)($ 210,503.75)$ 513,206.72$ 723,710.47($ 28,790,877.31)54($ 28,790,877.31)($ 215,931.58)$ 513,206.72$ 729,138.30($ 29,520,015.62)55($ 29,520,015.62)($ 221,400.12)$ 513,206.72$ 734,606.84($ 30,254,622.45)56($ 30,254,622.45)($ 226,909.67)$ 513,206.72$ 740,116.39($ 30,994,738.85)57($ 30,994,738.85)($ 232,460.54)$ 513,206.72$ 745,667.26($ 31,740,406.11)58($ 31,740,406.11)($ 238,053.05)$ 513,206.72$ 751,259.77($ 32,491,665.88)59($ 32,491,665.88)($ 243,687.49)$ 513,206.72$ 756,894.22($ 33,248,560.09)60($ 33,248,560.09)($ 249,364.20)$ 513,206.72$ 762,570.92($ 34,011,131.02)

DatosNperMonto IncialMonto FinalVerificacinTipo Prestador3Tipo de crditoNormalPensionado Estudiante3FALSELibre destino1.60%1.50%1.55%66Vehprestamo1.80%1.60%1.70%9Vivienda1.00%0.95%0.90%15Crediestudio0.80%0.70%0.75%2124304860