gradientes en excel ayuda

25
398,901.54 3% 5,000.00 100,000.00 NO CUOTA INTERES ABONO SALDO 0 398,901.54 1 ### 11,967.05 88,032.95 310,868.59 2 ### 9,326.06 95,673.94 215,194.65 3 ### 6,455.84 103,544.16 111,650.49 4 ### 3,349.51 111,650.49 - ### 0.03 10,000 2,500,000 NO CUOTA INTERES ABONO SALDO 0 ### 1 2,500,000 999709.3795 1,500,291 31,823,355 2 2,490,000 954700.6609 1,535,299 30,288,056 3 2,480,000 908641.6807 1,571,358 28,716,698 4 2,470,000 861500.9312 1,608,499 27,108,199 5 2,460,000 813245.9591 1,646,754 25,461,445 6 2,450,000 763843.3379 1,686,157 23,775,288 7 2,440,000 713258.638 1,726,741 22,048,547 8 2,430,000 661456.3972 1,768,544 20,280,003 9 2,420,000 608400.0891 1,811,600 18,468,403 10 2,410,000 554052.0917 1,855,948 16,612,455 11 2,400,000 498373.6545 1,901,626 14,710,829 12 2,390,000 441324.8641 1,948,675 12,762,154 13 2,380,000 382864.6101 1,997,135 10,765,018 14 2,370,000 322950.5484 2,047,049 8,717,969 15 2,360,000 261539.0648 2,098,461 6,619,508 16 2,350,000 198585.2368 2,151,415 4,468,093 17 2,340,000 134042.7939 2,205,957 2,262,136 18 2,330,000 67864.07767 2,262,136 - Una vivienda se esta cancelando con 18 cuotas mensuales que decrecen en $10.000 cada GRADIE Una de con 4 aumentan valor $100.000 que se Calcula

Upload: goldberg-jans-reiser

Post on 25-Sep-2015

158 views

Category:

Documents


7 download

DESCRIPTION

Gradientes

TRANSCRIPT

1L398,901.543%5,000.00100,000.00NOCUOTAINTERESABONOSALDO0398,901.541100,000.0011,967.0588,032.95310,868.592105,000.009,326.0695,673.94215,194.653110,000.006,455.84103,544.16111,650.494115,000.003,349.51111,650.490.033,323,645.980.0310,0002,500,000NOCUOTAINTERESABONOSALDO033,323,645.9812,500,000999709.3795356521,500,29131,823,35522,490,000954700.6609217211,535,29930,288,05632,480,000908641.6807493731,571,35828,716,69842,470,000861500.9311718541,608,49927,108,19952,460,000813245.959107011,646,75425,461,44562,450,000763843.337880221,686,15723,775,28872,440,000713258.6380166271,726,74122,048,54782,430,000661456.3971571261,768,54420,280,00392,420,000608400.0890718391,811,60018,468,403102,410,000554052.0917439951,855,94816,612,455112,400,000498373.6544963141,901,62614,710,829122,390,000441324.8641312041,948,67512,762,154132,380,000382864.610055141,997,13510,765,018142,370,000322950.5483567942,047,0498,717,969152,360,000261539.0648074982,098,4616,619,508162,350,000198585.2367517232,151,4154,468,093172,340,000134042.7938542752,205,9572,262,136182,330,00067864.07766990292,262,1360.0Una vivienda se esta cancelando con 18 cuotas mensuales que decrecen en $10.000 cada mes, siendo la primera cuota de $2.500.000. Si la tasa de financiacion que se esta cobrando es del 3% mensual. Cul es el valor de contado de la vivienda?

GRADIENTE LINEAL CRECIENTE (PRESENTE)Una deuda se esta cancelando con 4 cuotas mensuales que aumentan cada mes en $5.000. El valor de la primera cuota es $100.000. Si la tasa de interes que se cobra es 3% mensual. Calcular el valor de la deuda

2L3,900,0002.50%20,000.00122,553,5805,140,230.2020,0000.02550,000,000NOCUOTAINTERESABONOSALDONOCUOTAINTERESABONOSALDO0122,553,580013,900,0003,063,840836,160121,717,42015,360,230130,7375,229,4930.023,880,0003,042,935837,064120,880,35525,340,230257,7985,082,4325,229,49333,860,0003,022,009837,991120,042,36435,320,230381,2724,938,95810,311,92543,840,0003,001,059838,941119,203,42345,300,230501,2474,798,98415,250,88353,820,0002,980,086839,914118,363,50955,280,230617,8074,662,42320,049,86763,800,0002,959,088840,912117,522,59665,260,230731,0374,529,19324,712,29073,780,0002,938,065841,935116,680,66175,240,230841,0174,399,21329,241,48383,760,0002,917,017842,983115,837,67885,220,230947,8274,272,40333,640,69693,740,0002,895,942844,058114,993,62095,200,2301,051,5454,148,68637,913,098103,720,0002,874,840845,159114,148,460105,180,2301,152,2444,027,98642,061,784113,700,0002,853,712846,288113,302,172115,160,2301,250,0003,910,23046,089,770123,680,0002,832,554847,446112,454,726125140230.2050,000,000133,660,0002,811,368848,632111,606,094143,640,0002,790,152849,848110,756,247153,620,0002,768,906851,094109,905,153163,600,0002,747,629852,371109,052,782173,580,0002,726,320853,680108,199,101183,560,0002,704,978855,022107,344,079193,540,0002,683,602856,398106,487,681203,520,0002,662,192857,808105,629,873213,500,0002,640,747859,253104,770,620223,480,0002,619,265860,734103,909,885233,460,0002,597,747862,253103,047,633243,440,0002,576,191863,809102,183,823253,420,0002,554,596865,404101,318,419263,400,0002,532,960867,040100,451,379273,380,0002,511,284868,71599,582,664283,360,0002,489,567870,43398,712,231293,340,0002,467,806872,19497,840,036303,320,0002,446,001873,99996,966,037313,300,0002,424,151875,84996,090,188323,280,0002,402,255877,74595,212,443333,260,0002,380,311879,68994,332,754343,240,0002,358,319881,68193,451,073353,220,0002,336,277883,72392,567,350363,200,0002,314,184885,81691,681,534373,180,0002,292,038887,96290,793,572383,160,0002,269,839890,16189,903,411393,140,0002,247,585892,41589,010,996403,120,0002,225,275894,72588,116,271413,100,0002,202,907897,09387,219,178423,080,0002,180,479899,52186,319,658433,060,0002,157,991902,00985,417,649443,040,0002,135,441904,55984,513,090453,020,0002,112,827907,17383,605,918463,000,0002,090,148909,85282,696,066472,980,0002,067,402912,59881,783,467482,960,0002,044,587915,41380,868,054492,940,0002,021,701918,29979,949,755502,920,0001,998,744921,25679,028,499512,900,0001,975,712924,28778,104,212522,880,0001,952,605927,39577,176,817532,860,0001,929,420930,58076,246,238542,840,0001,906,156933,84475,312,393552,820,0001,882,810937,19074,375,203562,800,0001,859,380940,62073,434,583572,780,0001,835,865944,13572,490,448582,760,0001,812,261947,73971,542,709592,740,0001,788,568951,43270,591,277602,720,0001,764,782955,21869,636,059612,700,0001,740,901959,09968,676,960622,680,0001,716,924963,07667,713,884632,660,0001,692,847967,15366,746,732642,640,0001,668,668971,33265,775,400652,620,0001,644,385975,61564,799,785662,600,0001,619,995980,00563,819,780672,580,0001,595,494984,50562,835,274682,560,0001,570,882989,11861,846,156692,540,0001,546,154993,84660,852,310702,520,0001,521,308998,69259,853,618712,500,0001,496,3401,003,66058,849,958722,480,0001,471,2491,008,75157,841,207732,460,0001,446,0301,013,97056,827,237742,440,0001,420,6811,019,31955,807,918752,420,0001,395,1981,024,80254,783,116762,400,0001,369,5781,030,42253,752,694772,380,0001,343,8171,036,18352,716,511782,360,0001,317,9131,042,08751,674,424792,340,0001,291,8611,048,13950,626,285802,320,0001,265,6571,054,34349,571,942812,300,0001,239,2991,060,70148,511,241822,280,0001,212,7811,067,21947,444,022832,260,0001,186,1011,073,89946,370,122842,240,0001,159,2531,080,74745,289,375852,220,0001,132,2341,087,76644,201,610862,200,0001,105,0401,094,96043,106,650872,180,0001,077,6661,102,33442,004,316882,160,0001,050,1081,109,89240,894,424892,140,0001,022,3611,117,63939,776,785902,120,000994,4201,125,58038,651,204912,100,000966,2801,133,72037,517,485922,080,000937,9371,142,06336,375,422932,060,000909,3861,150,61435,224,807942,040,000880,6201,159,38034,065,427952,020,000851,6361,168,36432,897,063962,000,000822,4271,177,57331,719,490971,980,000792,9871,187,01330,532,477981,960,000763,3121,196,68829,335,789991,940,000733,3951,206,60528,129,1841001,920,000703,2301,216,77026,912,4131011,900,000672,8101,227,19025,685,2241021,880,000642,1311,237,86924,447,3541031,860,000611,1841,248,81623,198,5381041,840,000579,9631,260,03721,938,5021051,820,000548,4631,271,53720,666,9641061,800,000516,6741,283,32619,383,6381071,780,000484,5911,295,40918,088,2291081,760,000452,2061,307,79416,780,4351091,740,000419,5111,320,48915,459,9461101,720,000386,4991,333,50114,126,4451111,700,000353,1611,346,83912,779,6061121,680,000319,4901,360,51011,419,0961131,660,000285,4771,374,52310,044,5731141,640,000251,1141,388,8868,655,6881151,620,000216,3921,403,6087,252,0801161,600,000181,3021,418,6985,833,3821171,580,000145,8351,434,1654,399,2161181,560,000109,9801,450,0202,949,1971191,540,00073,7301,466,2701,482,9271201,520,00037,0731,482,927(0)

GRADIENTE LINEAL DECRECIENTE (CUOTA)Una vivienda con valor de $122.553.580,07 se esta cancelando con 120 cuotas mensuales que decrecen en $20.000 cada mes, si la tasa es del 2,5% mensual calcular el valor de la primera cuota?

3L5,800,0003%40,000.00550,000.00NOCUOTAINTERESABONOSALDO05,800,000.001550,000.00174,000.00376,000.005,424,000.002590,000.00162,720.00427,280.004,996,720.003630,000.00149,901.60480,098.404,516,621.604670,000.00135,498.65534,501.353,982,120.255710,000.00119,463.61590,536.393,391,583.866750,000.00101,747.52648,252.482,743,331.377790,000.0082,299.94707,700.062,035,631.318830,000.0061,068.94768,931.061,266,700.259870,000.0038,001.01831,998.99434,701.2610910,000.0013,041.04896,958.96(462,257.70)

GRADIENTE LINEAL CRECIENTE (TIEMPO)Con cuantos pagos mensuales, que aumenten en $40.000 cada mes, se cancela una obligacion de $5.800.000, si se cobra una tasa de interes del 3% mensual y la primera cuota es de $550.000 Cal es el valor de la ultima cuota?

4L3,000,0004.51%10,000.00500,000.00300,000NOCUOTAINTERESABONOSALDONOCUOTAINTERESABONOSALDO0300,0002,700,00001500,000121,887378,1132,321,88712510,000104,818405,1821,916,70523520,00086,526433,4741,483,23134530,00066,958463,0421,020,18945540,00046,055493,945526,24456550,00023,756526,24406

Una propiedad por valor de $22.000.000 se financia a una tasa de interes del 2,5% mensual, por medio de una cuota inciial y 12 cuotas mensuales crecientes cada mes en un 1%. Si la primera cuota es de $2.000.000 Cul es el valor de la cuota inicial?

22,000,0000.010.0252,000,000380,984.34NOCUOTAINTERESABONOSALDO0380,984.3421,619,01612,000,000540475.3914300581,459,52520,159,49122020000503987.276215811,516,01318,643,47832040200466086.9581212051,574,11317,069,36542060602426734.1320742351,633,86815,435,49752081208.02385887.4353760911,695,32113,740,17762102020.1002343504.4207604931,758,51611,981,66172123040.301202299541.5287745061,823,49910,158,16282144270.70421402253954.0594638181,890,3178,267,84692165713.41125616206696.1433450631,959,0176,308,828102187370.54536872157720.7116472862,029,6504,279,179112209244.25082241106979.465804252,102,2652,176,914122231336.6933306354422.84617879592,176,9140.0

GRADIENTE LINEAL CRECIENTE (TASA DE INTERES)Que tasa de interes le reconocen por financiar un electrodomestico que tiene un valor de contado de $3.000.000, por medio de una cuota inicial del 10% y 6 cuotas mensuales crecientes en $10.000, si el valor de la primera cuota es $500.000

5L800,0000.90%62,250.5916,000,000200,0000.01426,415.665,000,000NODEPOSITOINTERESDEP+INTSALDONODEPOSITOINTERESDEP+INTSALDO0800,000800,0000200,000200,0001862,2517,200869,4511,669,4511226,4162,800229,216429,2162924,50115,025939,5262,608,9772252,8316,009258,840688,0563986,75223,4811,010,2333,619,2093279,2479,633288,880976,93641,049,00232,5731,081,5754,700,7854305,66313,677319,3401,296,27551,111,25342,3071,153,5605,854,3455332,07818,148350,2261,646,50261,173,50452,6891,226,1937,080,5376358,49423,051381,5452,028,04771,235,75463,7251,299,4798,380,0167384,91028,393413,3022,441,34981,298,00575,4201,373,4259,753,4418411,32534,179445,5042,886,85391,360,25587,7811,448,03611,201,4779437,74140,416478,1573,365,010101,422,506100,8131,523,31912,724,79710464,15747,110511,2673,876,276111,484,756114,5231,599,28014,324,07611490,57254,268544,8404,421,117121,547,007128,9171,675,92416,000,00012516,98861,896578,8835,000,000

GRADIENTE LINEAL CRECIENTE (FUTURO - GRADIENTE)Si se realizan depositos mensuales comenzando hoy por valor de $800.000 Cual debe ser el incremento constante si la entidad financiera reconoce una tasa del 0,9% mensual para tener acumulados en un ao $16.000.000?

1G5,000,0003.00%563,921.302.70%NOCUOTAINTERESABONOSALDO05,000,0001563,921135,000428,9214,571,0792580,839123,419457,4204,113,6593598,264111,069487,1953,626,4644616,21297,915518,2983,108,1665634,69883,920550,7782,557,3886653,73969,049584,6901,972,6987673,35253,263620,0891,352,6108693,55236,520657,032695,5789714,35918,781695,578(0)Una deuda por valor de $10.000.000 a una tasa del 2,5% mensual, se va a cancelar con 6 cuotas mensuales que crecen $10.000 cada mes. Cul es el valor de la primera cuota?

10,000,0000.0251,791,219.6410,000NOCUOTAINTERESABONOSALDO010,000,00011,791,220250,0001,541,2208,458,78021,801,220211,4701,589,7506,869,03031,811,220171,7261,639,4945,229,53641,821,220130,7381,690,4813,539,05551,831,22088,4761,742,7431,796,31261,841,22044,9081,796,3120.0

GRADIENTE GEOMETRICO CRECIENTE (CUOTA)Se desea financiar una deuda de $5.000.000 con 9 pagos mensuales que aumentan en un 3% cada mes, suponiendo una tasa de interes del 2,7% mensual. Halle el valor del primer pago

2G7,500,00013.87%300,0001.00%NOCUOTAINTERESABONOSALDO07,500,0001300,00075,000225,0007,275,0002341,61072,750268,8607,006,1403388,99170,061318,9306,687,2104442,94466,872376,0726,311,1385504,38163,111441,2695,869,8696574,33858,699515,6395,354,2307653,99953,542600,4564,753,7738744,70847,538697,1704,056,6039847,99940,566807,4333,249,17010965,61632,492933,1252,316,045111,099,54723,1601,076,3871,239,658121,252,05412,3971,239,6580

GRADIENTE GEOMETRICO CRECIENTE (GRADIENTE)Una entidad presta a un cliente $7.500.000 con una tasa de interes del 1% mensual. El deudor tiene un plazo de 12 meses para cancelar la deuda. Si la primera cuota es de $300.000 y vence al final del primer mes. Cal debe ser el porcentaje de reajuste mensual de la cuota para terminar de cancelar la deuda?

3G17,200,0002.50%2,500,0003.00%NODEPOSITOINTERESDEP+INTSALDO017,200,00017,200,0001(2,500,000)516,000(1,984,000)15,216,0002(2,437,500)456,480(1,981,020)13,234,9803(2,376,563)397,049(1,979,513)11,255,4674(2,317,148)337,664(1,979,484)9,275,9825(2,259,220)278,279(1,980,940)7,295,0426(2,202,739)218,851(1,983,888)5,311,1547(2,147,671)159,335(1,988,336)3,322,8188(2,093,979)99,685(1,994,294)1,328,5249(2,041,630)39,856(2,001,774)(673,250)

GRADIENTE GEOMETRICO DECRECIENTE (TIEMPO)Durante cuantos meses podre hacer retiros de fin de mes de tal manera que cada retiro sea el 2,5% menor que el retiro anterior. Si se sabe que el valor del primer retiro es de $2.500.000 y el valor del deposito inicial fue de $17.200.000 y la entidad financiera reconoce el 3% mensual

4G24,174,2642.50%2,000,0002.00%NOCUOTAINTERESABONOSALDO024,174,26412,000,000483,4851,516,51522,657,74922,050,000453,1551,596,84521,060,90432,101,250421,2181,680,03219,380,87242,153,781387,6171,766,16417,614,70852,207,626352,2941,855,33215,759,37762,262,816315,1881,947,62913,811,74872,319,387276,2352,043,15211,768,59682,377,372235,3722,142,0009,626,59792,436,806192,5322,244,2747,382,323102,497,726147,6462,350,0795,032,243112,560,169100,6452,459,5242,572,719122,624,17351,4542,572,7190.0

GRADIENTE GEOMETRICO CRECIENTE (PRESENTE)Hallar el valor de contado de una deuda, que se cancela con un primer pago de $2.000.000 durante el primer mes y 12 cuotas que crecen mensualmente en un 2,5%, la tasa que esta cobrando la entidad financiera es del 2% mensual.