tablas de amortizacion varias.xls

Click here to load reader

Post on 24-Sep-2015

252 views

Category:

Documents

3 download

Embed Size (px)

DESCRIPTION

tablas de amortización en excel

TRANSCRIPT

TACCTabla de Amortizacion Cuota Constanteprestamo2500000tasa2.20%plazo24tipo0periodocapitalinterescuotasaldo02,500,000.00180,191.3055,000.00135,191.302,419,808.70281,955.5053,235.79135,191.302,337,853.20383,758.5351,432.77135,191.302,254,094.67485,601.2149,590.08135,191.302,168,493.46587,484.4447,706.86135,191.302,081,009.02689,409.1045,782.20135,191.301,991,599.92791,376.1043,815.20135,191.301,900,223.83893,386.3741,804.92135,191.301,806,837.45995,440.8739,750.42135,191.301,711,396.581097,540.5737,650.72135,191.301,613,856.011199,686.4635,504.83135,191.301,514,169.5512101,879.5733,311.73135,191.301,412,289.9813104,120.9231,070.38135,191.301,308,169.0714106,411.5828,779.72135,191.301,201,757.4915108,752.6326,438.66135,191.301,093,004.8616111,145.1924,046.11135,191.30981,859.6717113,590.3821,600.91135,191.30868,269.2818116,089.3719,101.92135,191.30752,179.9119118,643.3416,547.96135,191.30633,536.5820121,253.4913,937.80135,191.30512,283.0821123,921.0711,270.23135,191.30388,362.0222126,647.338,543.96135,191.30261,714.6823129,433.575,757.72135,191.30132,281.1124132,281.112,910.18135,191.300.00250.00.00.00.00260.00.00.00.00270.00.00.00.00280.00.00.00.00290.00.00.00.00300.00.00.00.00310.00.00.00.00320.00.00.00.00330.00.00.00.00340.00.00.00.00350.00.00.00.00360.00.00.00.00370.00.00.00.00380.00.00.00.00390.00.00.00.00400.00.00.00.00410.00.00.00.00420.00.00.00.00430.00.00.00.00440.00.00.00.00450.00.00.00.00460.00.00.00.00470.00.00.00.00480.00.00.00.00490.00.00.00.00500.00.00.00.00510.00.00.00.00520.00.00.00.00530.00.00.00.00540.00.00.00.00550.00.00.00.00560.00.00.00.00570.00.00.00.00580.00.00.00.00590.00.00.00.00600.00.00.00.00

TCCCtabla de capitaliacion cuota constantemonto final60000000tasa1.50%plazo60tipo0periodocapitalinterescuotasaldo00.01623,605.650.0623,605.65623,605.652632,959.739,354.08623,605.651,256,565.383642,454.1318,848.48623,605.651,899,019.504652,090.9428,485.29623,605.652,551,110.445661,872.3038,266.66623,605.653,212,982.746671,800.3948,194.74623,605.653,884,783.137681,877.3958,271.75623,605.654,566,660.528692,105.5568,499.91623,605.655,258,766.089702,487.1478,881.49623,605.655,961,253.2110713,024.4489,418.80623,605.656,674,277.6611723,719.81100,114.16623,605.657,397,997.4712734,575.61110,969.96623,605.658,132,573.0713745,594.24121,988.60623,605.658,878,167.3214756,778.16133,172.51623,605.659,634,945.4715768,129.83144,524.18623,605.6510,403,075.3016779,651.78156,046.13623,605.6511,182,727.0717791,346.55167,740.91623,605.6511,974,073.6318803,216.75179,611.10623,605.6512,777,290.3819815,265.00191,659.36623,605.6513,592,555.3820827,493.98203,888.33623,605.6514,420,049.3521839,906.39216,300.74623,605.6515,259,955.7422852,504.98228,899.34623,605.6516,112,460.7223865,292.56241,686.91623,605.6516,977,753.2824878,271.94254,666.30623,605.6517,856,025.2225891,446.02267,840.38623,605.6518,747,471.2526904,817.71281,212.07623,605.6519,652,288.9627918,389.98294,784.33623,605.6520,570,678.9428932,165.83308,560.18623,605.6521,502,844.7729946,148.32322,542.67623,605.6522,448,993.0930960,340.54336,734.90623,605.6523,409,333.6331974,745.65351,140.00623,605.6524,384,079.2832989,366.83365,761.19623,605.6525,373,446.11331,004,207.34380,601.69623,605.6526,377,653.45341,019,270.45395,664.80623,605.6527,396,923.90351,034,559.50410,953.86623,605.6528,431,483.40361,050,077.90426,472.25623,605.6529,481,561.30371,065,829.07442,223.42623,605.6530,547,390.36381,081,816.50458,210.86623,605.6531,629,206.87391,098,043.75474,438.10623,605.6532,727,250.61401,114,514.40490,908.76623,605.6533,841,765.02411,131,232.12507,626.48623,605.6534,972,997.14421,148,200.60524,594.96623,605.6536,121,197.74431,165,423.61541,817.97623,605.6537,286,621.35441,182,904.97559,299.32623,605.6538,469,526.32451,200,648.54577,042.89623,605.6539,670,174.86461,218,658.27595,052.62623,605.6540,888,833.13471,236,938.14613,332.50623,605.6542,125,771.27481,255,492.21631,886.57623,605.6543,381,263.49491,274,324.60650,718.95623,605.6544,655,588.08501,293,439.47669,833.82623,605.6545,949,027.55511,312,841.06689,235.41623,605.6547,261,868.61521,332,533.67708,928.03623,605.6548,594,402.29531,352,521.68728,916.03623,605.6549,946,923.97541,372,809.51749,203.86623,605.6551,319,733.47551,393,401.65769,796.00623,605.6552,713,135.12561,414,302.67790,697.03623,605.6554,127,437.79571,435,517.21811,911.57623,605.6555,562,955.00581,457,049.97833,444.33623,605.6557,020,004.97591,478,905.72855,300.07623,605.6558,498,910.69601,501,089.31877,483.66623,605.6560,000,000.00

TAAEtabla de amortizacion con abonos extraordinariosClienteJAMES MEJIACedula16679078Valor Negociacin3,000,000.00Valor Cuota Inicial300,000.00Valor Refinanciado2,700,000.00Tasa EA22.97%Tasa NA20.86%tasa1.74%plazo12tipo0relacionabonosextraordinariosperiodoabonosVPAE03300,000.00$ 284,886.2309300,000.00$ 256,904.600total$ 541,790.83valor cuota$ 200,810.07periodocapitalinterescuotasaldo02,700,000.001153,883.6446,926.43200,810.072,546,116.362156,558.1644,251.91200,810.072,389,558.203459,279.1741,530.91500,810.071,930,279.034167,261.5133,548.56200,810.071,763,017.515170,168.5530,641.53200,810.071,592,848.976173,126.1027,683.97200,810.071,419,722.867176,135.0624,675.01200,810.071,243,587.808179,196.3221,613.76200,810.071,064,391.489482,310.7818,499.29500,810.07582,080.7010190,693.4210,116.66200,810.07391,387.2911194,007.706,802.37200,810.07197,379.5912197,379.593,430.49200,810.07(0.00)130.00.00.00.0140.00.00.00.0150.00.00.00.0160.00.00.00.0170.00.00.00.0180.00.00.00.0190.00.00.00.0200.00.00.00.0210.00.00.00.0220.00.00.00.0230.00.00.00.0240.00.00.00.0250.00.00.00.0260.00.00.00.0270.00.00.00.0280.00.00.00.0290.00.00.00.0300.00.00.00.0310.00.00.00.0320.00.00.00.0330.00.00.00.0340.00.00.00.0350.00.00.00.0360.00.00.00.0370.00.00.00.0380.00.00.00.0390.00.00.00.0400.00.00.00.0410.00.00.00.0420.00.00.00.0430.00.00.00.0440.00.00.00.0450.00.00.00.0460.00.00.00.0470.00.00.00.0480.00.00.00.0490.00.00.00.0500.00.00.00.0510.00.00.00.0520.00.00.00.0530.00.00.00.0540.00.00.00.0550.00.00.00.0560.00.00.00.0570.00.00.00.0580.00.00.00.0590.00.00.00.0600.00.00.00.0

TCAETabla de Capitalizacion con abonos extraordinariosmonto final60,000,000.00tasa1.50%plazo60tipo0Relacion Abonos ExtraordinariosperiodoabonosVFAE0124000000$ 8,173,913.160$ 8,173,913.16244000000$ 6,836,558.150$ 6,836,558.15364000000$ 5,718,011.250$ 5,718,011.25484000000$ 4,782,472.690$ 4,782,472.69604000000$ 4,000,000.000$ 4,000,000.00total$ 29,510,955.24$ 29,510,955.24valor cuota$ 316,885.67periodocapitalinterescuotasaldo00.01316,885.670.0316,885.67316,885.672321,638.964,753.29316,885.67638,524.633326,463.549,577.87316,885.67964,988.184331,360.5014,474.82316,885.671,296,348.675336,330.9019,445.23316,885.671,632,679.586341,375.8724,490.19316,885.671,974,055.457346,496.5129,610.83316,885.672,320,551.958351,693.9534,808.28316,885.672,672,245.909356,969.3640,083.69316,885.673,029,215.2710362,323.9045,438.23316,885.673,391,539.1711367,758.7650,873.09316,885.673,759,297.93124,373,275.1456,389.474,316,885.678,132,573.0713438,874.27121,988.60316,885.678,571,447.3414445,457.38128,571.71316,885.679,016,904.7315452,139.24135,253.57316,885.679,469,043.9716458,921.33142,035.66316,885.679,927,965.3117465,805.15148,919.48316,885.6710,393,770.4618472,792.23155,906.56316,885.6710,866,562.6919479,884.11162,998.44316,885.6711,346,446.8120487,082.38170,196.70316,885.6711,833,529.1821494,388.61177,502.94316,885.6712,327,917.7922501,804.44184,918.77316,885.6712,829,722.2323509,331.51192,445.83316,885.6713,339,053.74244,516,971.48200,085.814,316,885.6717,856,025.2225584,726.05267,840.38316,885.6718,440,751.2726593,496.94276,611.27316,885.6719,034,248.2227602,399.40285,513.72316,885.6719,636,647.6128611,435.39294,549.71316,885.6720,248,083.0029620,606.92303,721.25316,885.6720,868,689.9230629,916.02313,030.35316,885.6721,498,605.9431639,364.76322,479.09316,885.6722,137,970.7132648,955.23332,069.56316,885.6722,786,925.9433658,689.56341,803.89316,885.6723,445,615.5134668,569.91351,684.23316,885.6724,114,185.4135678,598.46361,712.78316,885.6724,792,783.87364,688,777.43371,891.764,316,885.6729,481,561.3037759,109.09442,223.42316,885.6730,240,670.3938770,495.73453,610.06316,885.6731,011,166.1239782,053.17465,167.49316,885.6731,793,219.2940793,783.96476,898.29316,885.6732,587,003.2541805,690.72488,805.05316,885.6733,392,693.9842817,776.08500,890.41316,885.6734,210,470.0643830,042.72513,157.05316,885.6735,040,512.7844842,493.37525,607.69316,885.6735,883,006.1545855,130.77538,245.09316,885.6736,738,136.9246867,957.73551,072.05316,885.6737,606,094.6447880,977.09564,091.42316,885.6738,487,071.74484,894,191.75577,306.084,316,885.6743,381,263.4949967,604.63650,718.95316,885.6744,348,868.1150982,118.70665,233.02316,885.6745,330,986.8151996,850.48679,964.80316,885.6746,327,837.29521,011,803.23694,917.56316,885.6747,339,640.52531,026,980.28710,094.61316,885.6748,366,620.80541,042,384.99725,499.31316,885.6749,409,005.79551,058,020.76741,135.09316,885.6750,467,026.55561,073,891.07757,005.40316,885.6751,540,917.62571,089,999.44773,113.76316,885.6752,630,917.06581,106,349.43789,463.76316,885.6753,737,266.49591,122,944.67806,059.00316,885.6754,860,211.16605,139,788.84822,903.174,316,885.6760,000,000.00

TACVTabla de Amortizacion Cuota VariableTabla de Amortizacion Cuota Variableprestamo60000000prestamo60000000tasa1.50%tasa1.50%plazo60plazo60tipo0tipo0periodocapitalinterescuotasaldoperiodocapitalinterescuotasaldo060,000,000.00060,000,000.0011,000,000.00900,000.001,900,000.0059,000,000.0011,000,000.00900,000.001,900,000.0059,000,000.0021,000,000.00890,645.921,890,645.9258,000,000.0021,000,000.00885,000.001,885,000.0058,000,000.0031,000,000.00881,151.521,881,151.5257,000,000.0031,000,000.00870,000.001,870,000.0057,000,000.0041,000,000.00871,514.711,871,514.7156,000,000.0041,000,000.00855,000.001,855,000.0056,000,000.0051,000,000.00861,733.341,861,733.3455,000,000.0051,000,000.00840,000.001,840,000.0055,000,000.0061,000,000.00851,805.261,851,805.2654,000,000.0061,000,000.00825,000.001,825,000.0054,000,000.0071,000,000.00841,728.251,841,728.2553,000,000.0071,000,000.00810,000.001,810,000.0053,000,000.0081,000,000.00831,500.091,831,500.0952,000,000.0081,000,000.00795,000.001,795,000.0052,000,000.0091,000,000.00821,118.511,821,118.5151,000,000.0091,000,000.00780,000.001,780,000.0051,000,000.00101,000,000.00810,581.201,810,581.2050,000,000.00101,000,000.00765,000.001,765,000.0050,000,000.00111,000,000.00799,885.841,799,885.8449,000,000.00111,000,000.00750,000.001,750,000.0049,000,000.00121,000,000.00789,030.041,789,030.0448,000,000.00121,000,000.00735,000.001,735,000.0048,000,000.00131,000,000.00778,011.401,778,011.4047,000,000.00131,000,000.00720,000.001,720,000.0047,000,000.00141,000,000.00766,827.491,766,827.4946,000,000.00141,000,000.00705,000.001,705,000.0046,000,000.00151,000,000.00755,475.821,755,475.8245,000,000.00151,000,000.00690,000.001,690,000.0045,000,000.00161,000,000.00743,953.871,743,953.8744,000,000.00161,000,000.00675,000.001,675,000.0044,000,000.00171,000,000.00732,259.091,732,259.0943,000,000.00171,000,000.00660,000.001,660,000.0043,000,000.00181,000,000.00720,388.901,720,388.9042,000,000.00181,000,000.00645,000.001,645,000.0042,000,000.00191,000,000.00708,340.641,708,340.6441,000,000.00191,000,000.00630,000.001,630,000.0041,000,000.00201,000,000.00696,111.671,696,111.6740,000,000.00201,000,000.00615,000.001,615,000.0040,000,000.00211,000,000.00683,699.261,683,699.2639,000,000.00211,000,000.00600,000.001,600,000.0039,000,000.00221,000,000.00671,100.661,671,100.6638,000,000.00221,000,000.00585,000.001,585,000.0038,000,000.00231,000,000.00658,313.091,658,313.0937,000,000.00231,000,000.00570,000.001,570,000.0037,000,000.00241,000,000.00645,333.701,645,333.7036,000,000.00241,000,000.00555,000.001,555,000.0036,000,000.00251,000,000.00632,159.621,632,159.6235,000,000.00251,000,000.00540,000.001,540,000.0035,000,000.00261,000,000.00618,787.931,618,787.9334,000,000.00261,000,000.00525,000.001,525,000.0034,000,000.00271,000,000.00605,215.671,605,215.6733,000,000.00271,000,000.00510,000.001,510,000.0033,000,000.00281,000,000.00591,439.821,591,439.8232,000,000.00281,000,000.00495,000.001,495,000.0032,000,000.00291,000,000.00577,457.331,577,457.3331,000,000.00291,000,000.00480,000.001,480,000.0031,000,000.00301,000,000.00563,265.101,563,265.1030,000,000.00301,000,000.00465,000.001,465,000.0030,000,000.00311,000,000.00548,860.001,548,860.0029,000,000.00311,000,000.00450,000.001,450,000.0029,000,000.00321,000,000.00534,238.811,534,238.8128,000,000.00321,000,000.00435,000.001,435,000.0028,000,000.00331,000,000.00519,398.311,519,398.3127,000,000.00331,000,000.00420,000.001,420,000.0027,000,000.00341,000,000.00504,335.201,504,335.2026,000,000.00341,000,000.00405,000.001,405,000.0026,000,000.00351,000,000.00489,046.141,489,046.1425,000,000.00351,000,000.00390,000.001,390,000.0025,000,000.00361,000,000.00473,527.751,473,527.7524,000,000.00361,000,000.00375,000.001,375,000.0024,000,000.00371,000,000.00457,776.581,457,776.5823,000,000.00371,000,000.00360,000.001,360,000.0023,000,000.00381,000,000.00441,789.141,441,789.1422,000,000.00381,000,000.00345,000.001,345,000.0022,000,000.00391,000,000.00425,561.901,425,561.9021,000,000.00391,000,000.00330,000.001,330,000.0021,000,000.00401,000,000.00409,091.241,409,091.2420,000,000.00401,000,000.00315,000.001,315,000.0020,000,000.00411,000,000.00392,373.521,392,373.5219,000,000.00411,000,000.00300,000.001,300,000.0019,000,000.00421,000,000.00375,405.041,375,405.0418,000,000.00421,000,000.00285,000.001,285,000.0018,000,000.00431,000,000.00358,182.031,358,182.0317,000,000.00431,000,000.00270,000.001,270,000.0017,000,000.00441,000,000.00340,700.681,340,700.6816,000,000.00441,000,000.00255,000.001,255,000.0016,000,000.00451,000,000.00322,957.111,322,957.1115,000,000.00451,000,000.00240,000.001,240,000.0015,000,000.00461,000,000.00304,947.381,304,947.3814,000,000.00461,000,000.00225,000.001,225,000.0014,000,000.00471,000,000.00286,667.501,286,667.5013,000,000.00471,000,000.00210,000.001,210,000.0013,000,000.00481,000,000.00268,113.431,268,113.4312,000,000.00481,000,000.00195,000.001,195,000.0012,000,000.00491,000,000.00249,281.051,249,281.0511,000,000.00491,000,000.00180,000.001,180,000.0011,000,000.00501,000,000.00230,166.181,230,166.1810,000,000.00501,000,000.00165,000.001,165,000.0010,000,000.00511,000,000.00210,764.591,210,764.599,000,000.00511,000,000.00150,000.001,150,000.009,000,000.00521,000,000.00191,071.971,191,071.978,000,000.00521,000,000.00135,000.001,135,000.008,000,000.00531,000,000.00171,083.971,171,083.977,000,000.00531,000,000.00120,000.001,120,000.007,000,000.00541,000,000.00150,796.141,150,796.146,000,000.00541,000,000.00105,000.001,105,000.006,000,000.00551,000,000.00130,204.001,130,204.005,000,000.00551,000,000.0090,000.001,090,000.005,000,000.00561,000,000.00109,302.971,109,302.974,000,000.00561,000,000.0075,000.001,075,000.004,000,000.00571,000,000.0088,088.431,088,088.433,000,000.00571,000,000.0060,000.001,060,000.003,000,000.00581,000,000.0066,555.671,066,555.672,000,000.00581,000,000.0045,000.001,045,000.002,000,000.00591,000,000.0044,699.931,044,699.931,000,000.00591,000,000.0030,000.001,030,000.001,000,000.00601,000,000.0022,516.341,022,516.340.0601,000,000.0015,000.001,015,000.000.0

TCCVTabla de Capitalizacion Cuota Variablemonto final60,000,000.00tasa1.50%plazo60periodocapitalinterescuotasaldo00.011,000,000.000.01,000,000.001,000,000.0021,000,000.0015,000.001,015,000.002,000,000.0031,000,000.0030,000.001,030,000.003,000,000.0041,000,000.0045,000.001,045,000.004,000,000.0051,000,000.0060,000.001,060,000.005,000,000.0061,000,000.0075,000.001,075,000.006,000,000.0071,000,000.0090,000.001,090,000.007,000,000.0081,000,000.00105,000.001,105,000.008,000,000.0091,000,000.00120,000.001,120,000.009,000,000.00101,000,000.00135,000.001,135,000.0010,000,000.00111,000,000.00150,000.001,150,000.0011,000,000.00121,000,000.00165,000.001,165,000.0012,000,000.00131,000,000.00180,000.001,180,000.0013,000,000.00141,000,000.00195,000.001,195,000.0014,000,000.00151,000,000.00210,000.001,210,000.0015,000,000.00161,000,000.00225,000.001,225,000.0016,000,000.00171,000,000.00240,000.001,240,000.0017,000,000.00181,000,000.00255,000.001,255,000.0018,000,000.00191,000,000.00270,000.001,270,000.0019,000,000.00201,000,000.00285,000.001,285,000.0020,000,000.00211,000,000.00300,000.001,300,000.0021,000,000.00221,000,000.00315,000.001,315,000.0022,000,000.00231,000,000.00330,000.001,330,000.0023,000,000.00241,000,000.00345,000.001,345,000.0024,000,000.00251,000,000.00360,000.001,360,000.0025,000,000.00261,000,000.00375,000.001,375,000.0026,000,000.00271,000,000.00390,000.001,390,000.0027,000,000.00281,000,000.00405,000.001,405,000.0028,000,000.00291,000,000.00420,000.001,420,000.0029,000,000.00301,000,000.00435,000.001,435,000.0030,000,000.00311,000,000.00450,000.001,450,000.0031,000,000.00321,000,000.00465,000.001,465,000.0032,000,000.00331,000,000.00480,000.001,480,000.0033,000,000.00341,000,000.00495,000.001,495,000.0034,000,000.00351,000,000.00510,000.001,510,000.0035,000,000.00361,000,000.00525,000.001,525,000.0036,000,000.00371,000,000.00540,000.001,540,000.0037,000,000.00381,000,000.00555,000.001,555,000.0038,000,000.00391,000,000.00570,000.001,570,000.0039,000,000.00401,000,000.00585,000.001,585,000.0040,000,000.00411,000,000.00600,000.001,600,000.0041,000,000.00421,000,000.00615,000.001,615,000.0042,000,000.00431,000,000.00630,000.001,630,000.0043,000,000.00441,000,000.00645,000.001,645,000.0044,000,000.00451,000,000.00660,000.001,660,000.0045,000,000.00461,000,000.00675,000.001,675,000.0046,000,000.00471,000,000.00690,000.001,690,000.0047,000,000.00481,000,000.00705,000.001,705,000.0048,000,000.00491,000,000.00720,000.001,720,000.0049,000,000.00501,000,000.00735,000.001,735,000.0050,000,000.00511,000,000.00750,000.001,750,000.0051,000,000.00521,000,000.00765,000.001,765,000.0052,000,000.00531,000,000.00780,000.001,780,000.0053,000,000.00541,000,000.00795,000.001,795,000.0054,000,000.00551,000,000.00810,000.001,810,000.0055,000,000.00561,000,000.00825,000.001,825,000.0056,000,000.00571,000,000.00840,000.001,840,000.0057,000,000.00581,000,000.00855,000.001,855,000.0058,000,000.00591,000,000.00870,000.001,870,000.0059,000,000.00601,000,000.00885,000.001,885,000.0060,000,000.00

TAPGTabla de Amortizacion con Periodos de graciamonto inicial60,000,000.00tasa1.50%plazo60Gracia6tipo0periodocapitalinterescuotasaldo060,000,000.0010.0900,000.000.060,900,000.0020.0913,500.000.061,813,500.0030.0927,202.500.062,740,702.5040.0941,110.540.063,681,813.0450.0955,227.200.064,637,040.2360.0969,555.600.065,606,595.847797,210.76984,098.941,781,309.6964,809,385.088809,168.92972,140.781,781,309.6964,000,216.169821,306.45960,003.241,781,309.6963,178,909.7110833,626.05947,683.651,781,309.6962,345,283.6611846,130.44935,179.251,781,309.6961,499,153.2212858,822.40922,487.301,781,309.6960,640,330.8313871,704.73909,604.961,781,309.6959,768,626.0914884,780.30896,529.391,781,309.6958,883,845.7915898,052.01883,257.691,781,309.6957,985,793.7816911,522.79869,786.911,781,309.6957,074,271.0017925,195.63856,114.061,781,309.6956,149,075.3718939,073.56842,236.131,781,309.6955,210,001.8019953,159.67828,150.031,781,309.6954,256,842.1420967,457.06813,852.631,781,309.6953,289,385.0721981,968.92799,340.781,781,309.6952,307,416.1622996,698.45784,611.241,781,309.6951,310,717.70231,011,648.93769,660.771,781,309.6950,299,068.78241,026,823.66754,486.031,781,309.6949,272,245.11251,042,226.02739,083.681,781,309.6948,230,019.10261,057,859.41723,450.291,781,309.6947,172,159.69271,073,727.30707,582.401,781,309.6946,098,432.39281,089,833.21691,476.491,781,309.6945,008,599.18291,106,180.71675,128.991,781,309.6943,902,418.47301,122,773.42658,536.281,781,309.6942,779,645.06311,139,615.02641,694.681,781,309.6941,640,030.04321,156,709.24624,600.451,781,309.6940,483,320.79331,174,059.88607,249.811,781,309.6939,309,260.91341,191,670.78589,638.911,781,309.6938,117,590.13351,209,545.84571,763.851,781,309.6936,908,044.29361,227,689.03553,620.661,781,309.6935,680,355.26371,246,104.37535,205.331,781,309.6934,434,250.89381,264,795.93516,513.761,781,309.6933,169,454.96391,283,767.87497,541.821,781,309.6931,885,687.09401,303,024.39478,285.311,781,309.6930,582,662.71411,322,569.75458,739.941,781,309.6929,260,092.95421,342,408.30438,901.391,781,309.6927,917,684.65431,362,544.42418,765.271,781,309.6926,555,140.23441,382,982.59398,327.101,781,309.6925,172,157.64451,403,727.33377,582.361,781,309.6923,768,430.31461,424,783.24356,526.451,781,309.6922,343,647.07471,446,154.99335,154.711,781,309.6920,897,492.08481,467,847.31313,462.381,781,309.6919,429,644.77491,489,865.02291,444.671,781,309.6917,939,779.74501,512,213.00269,096.701,781,309.6916,427,566.74511,534,896.19246,413.501,781,309.6914,892,670.55521,557,919.64223,390.061,781,309.6913,334,750.92531,581,288.43200,021.261,781,309.6911,753,462.48541,605,007.76176,301.941,781,309.6910,148,454.73551,629,082.87152,226.821,781,309.698,519,371.85561,653,519.12127,790.581,781,309.696,865,852.74571,678,321.90102,987.791,781,309.695,187,530.83581,703,496.7377,812.961,781,309.693,484,034.10591,729,049.1852,260.511,781,309.691,754,984.92601,754,984.9226,324.771,781,309.69(0.00)

TAPGYAEUNIVERSIDAD PILOTO DE COLOMBIATABLA DE AMORTIZACION CON PERIODO DE GRACIA Y ABONOS EXTRAORDINARIOSPRESTAMO60,000,000.00TASA1.5%PLAZO60PER. GRACIA1INCREMENTORELACION DE ABONOS EXTRAORDINARIOSPERIODOVALORVPAE012500,000.00$ 418,193.71241,000,000.00$ 699,543.92361,500,000.00$ 877,634.60482,000,000.00$ 978,723.39602,500,000.00$ 1,023,239.92TOTAL$ 3,997,335.54VALOR CUOTA$ 1,458,590.85PERIODOCAPITALINTERESESCUOTASALDO060,000,000.0010.0900,000.000.060,900,000.002545,090.85913,500.001,458,590.8560,354,909.153553,267.21905,323.641,458,590.8559,801,641.944561,566.22897,024.631,458,590.8559,240,075.725569,989.71888,601.141,458,590.8558,670,086.016578,539.56880,051.291,458,590.8558,091,546.457587,217.65871,373.201,458,590.8557,504,328.808596,025.92862,564.931,458,590.8556,908,302.899604,966.30853,624.541,458,590.8556,303,336.5810614,040.80844,550.051,458,590.8555,689,295.7811623,251.41835,339.441,458,590.8555,066,044.37121,132,600.18825,990.671,958,590.8553,933,444.1913649,589.18809,001.661,458,590.8553,283,855.0114659,333.02799,257.831,458,590.8552,624,521.9815669,223.02789,367.831,458,590.8551,955,298.9716679,261.36779,329.481,458,590.8551,276,037.6017689,450.28769,140.561,458,590.8550,586,587.3218699,792.04758,798.811,458,590.8549,886,795.2819710,288.92748,301.931,458,590.8549,176,506.3620720,943.25737,647.601,458,590.8548,455,563.1121731,757.40726,833.451,458,590.8547,723,805.7122742,733.76715,857.091,458,590.8546,981,071.9523753,874.77704,716.081,458,590.8546,227,197.18241,765,182.89693,407.962,458,590.8544,462,014.2925791,660.63666,930.211,458,590.8543,670,353.6526803,535.54655,055.301,458,590.8542,866,818.1127815,588.58643,002.271,458,590.8542,051,229.5428827,822.40630,768.441,458,590.8541,223,407.1329840,239.74618,351.111,458,590.8540,383,167.3930852,843.34605,747.511,458,590.8539,530,324.0531865,635.99592,954.861,458,590.8538,664,688.0732878,620.53579,970.321,458,590.8537,786,067.5433891,799.83566,791.011,458,590.8536,894,267.7034905,176.83553,414.021,458,590.8535,989,090.8735918,754.48539,836.361,458,590.8535,070,336.39362,432,535.80526,055.052,958,590.8532,637,800.5937969,023.84489,567.011,458,590.8531,668,776.7538983,559.20475,031.651,458,590.8530,685,217.5539998,312.58460,278.261,458,590.8529,686,904.97401,013,287.27445,303.571,458,590.8528,673,617.69411,028,486.58430,104.271,458,590.8527,645,131.11421,043,913.88414,676.971,458,590.8526,601,217.23431,059,572.59399,018.261,458,590.8525,541,644.64441,075,466.18383,124.671,458,590.8524,466,178.46451,091,598.17366,992.681,458,590.8523,374,580.29461,107,972.14350,618.701,458,590.8522,266,608.15471,124,591.73333,999.121,458,590.8521,142,016.42483,141,460.60317,130.253,458,590.8518,000,555.82491,188,582.51270,008.341,458,590.8516,811,973.31501,206,411.25252,179.601,458,590.8515,605,562.06511,224,507.42234,083.431,458,590.8514,381,054.65521,242,875.03215,715.821,458,590.8513,138,179.62531,261,518.15197,072.691,458,590.8511,876,661.46541,280,440.93178,149.921,458,590.8510,596,220.54551,299,647.54158,943.311,458,590.859,296,573.00561,319,142.25139,448.591,458,590.857,977,430.75571,338,929.39119,661.461,458,590.856,638,501.36581,359,013.3399,577.521,458,590.855,279,488.03591,379,398.5379,192.321,458,590.853,900,089.51603,900,089.5158,501.343,958,590.85(0.00)

TAGATABLA DE AMORTIZACION - GRADIENTE LINEAL O ARITMETICOPrstamo60,000,000Tasa2.0%Plazo60Incremento Aritmtico20,000PERIODOCAPITALINTERESESCUOTASALDO060,000,000.00152,155.901,200,000.001,252,155.9059,947,844.10273,199.021,198,956.881,272,155.9059,874,645.08394,663.001,197,492.901,292,155.9059,779,982.094116,556.261,195,599.641,312,155.9059,663,425.835138,887.381,193,268.521,332,155.9059,524,538.456161,665.131,190,490.771,352,155.9059,362,873.327184,898.431,187,257.471,372,155.9059,177,974.888208,596.401,183,559.501,392,155.9058,969,378.489232,768.331,179,387.571,412,155.9058,736,610.1510257,423.701,174,732.201,432,155.9058,479,186.4611282,572.171,169,583.731,452,155.9058,196,614.2912308,223.611,163,932.291,472,155.9057,888,390.6713334,388.091,157,767.811,492,155.9057,554,002.5914361,075.851,151,080.051,512,155.9057,192,926.7415388,297.361,143,858.531,532,155.9056,804,629.3816416,063.311,136,092.591,552,155.9056,388,566.0617444,384.581,127,771.321,572,155.9055,944,181.4918473,272.271,118,883.631,592,155.9055,470,909.2219502,737.711,109,418.181,612,155.9054,968,171.5020532,792.471,099,363.431,632,155.9054,435,379.0321563,448.321,088,707.581,652,155.9053,871,930.7222594,717.281,077,438.611,672,155.9053,277,213.4323626,611.631,065,544.271,692,155.9052,650,601.8024659,143.861,053,012.041,712,155.9051,991,457.9425692,326.741,039,829.161,732,155.9051,299,131.2026726,173.281,025,982.621,752,155.9050,572,957.9227760,696.741,011,459.161,772,155.9049,812,261.1828795,910.68996,245.221,792,155.9049,016,350.5129831,828.89980,327.011,812,155.9048,184,521.6230868,465.47963,690.431,832,155.9047,316,056.1531905,834.78946,321.121,852,155.9046,410,221.3732943,951.47928,204.431,872,155.9045,466,269.9033982,830.50909,325.401,892,155.9044,483,439.40341,022,487.11889,668.791,912,155.9043,460,952.29351,062,936.85869,219.051,932,155.9042,398,015.44361,104,195.59847,960.311,952,155.9041,293,819.85371,146,279.50825,876.401,972,155.9040,147,540.34381,189,205.09802,950.811,992,155.9038,958,335.25391,232,989.19779,166.712,012,155.9037,725,346.06401,277,648.98754,506.922,032,155.9036,447,697.08411,323,201.96728,953.942,052,155.9035,124,495.12421,369,666.00702,489.902,072,155.9033,754,829.13431,417,059.32675,096.582,092,155.9032,337,769.81441,465,400.50646,755.402,112,155.9030,872,369.31451,514,708.51617,447.392,132,155.9029,357,660.79461,565,002.68587,153.222,152,155.9027,792,658.11471,616,302.74555,853.162,172,155.9026,176,355.37481,668,628.79523,527.112,192,155.9024,507,726.58491,722,001.37490,154.532,212,155.9022,785,725.21501,776,441.39455,714.502,232,155.9021,009,283.82511,831,970.22420,185.682,252,155.9019,177,313.60521,888,609.63383,546.272,272,155.9017,288,703.97531,946,381.82345,774.082,292,155.9015,342,322.15542,005,309.46306,846.442,312,155.9013,337,012.69552,065,415.65266,740.252,332,155.9011,271,597.05562,126,723.96225,431.942,352,155.909,144,873.09572,189,258.44182,897.462,372,155.906,955,614.65582,253,043.61139,112.292,392,155.904,702,571.05592,318,104.4894,051.422,412,155.902,384,466.57602,384,466.5747,689.332,432,155.90(0.00)

Hoja5VPGL