tablas de amortizacion varias.xls

Download tablas de amortizacion VARIAS.xls

Post on 24-Sep-2015

225 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,