matematicas gradiantes

7
n= 60 meses v G= $ 5,000.00 creciente A= $ 500,000.00 i= 0.88% valor presente ### No cuota interes Abobo k 0 $ - $ - $ - 1 $ 500,000.00 $ 259,936.37 $ 240,063.63 2 $ 505,000.00 $ 257,817.71 $ 247,182.29 3 $ 510,000.00 $ 255,636.22 $ 254,363.78 4 $ 515,000.00 $ 253,391.35 $ 261,608.65 5 $ 520,000.00 $ 251,082.55 $ 268,917.45 6 $ 525,000.00 $ 248,709.24 $ 276,290.76 7 $ 530,000.00 $ 246,270.86 $ 283,729.14 8 $ 535,000.00 $ 243,766.83 $ 291,233.17 9 $ 540,000.00 $ 241,196.57 $ 298,803.43 10 $ 545,000.00 $ 238,559.51 $ 306,440.49 11 $ 550,000.00 $ 235,855.04 $ 314,144.96 12 $ 555,000.00 $ 233,082.58 $ 321,917.42 13 $ 560,000.00 $ 230,241.52 $ 329,758.48 14 $ 565,000.00 $ 227,331.27 $ 337,668.73 #VALUE! $ 570,000.00 $ 224,351.20 $ 345,648.80 15 $ 575,000.00 $ 221,300.70 $ 353,699.30 16 $ 580,000.00 $ 218,179.16 $ 361,820.84 17 $ 585,000.00 $ 214,985.94 $ 370,014.06 18 $ 590,000.00 $ 211,720.41 $ 378,279.59 19 $ 595,000.00 $ 208,381.93 $ 386,618.07 20 $ 600,000.00 $ 204,969.86 $ 395,030.14 21 $ 605,000.00 $ 201,483.56 $ 403,516.44 22 $ 610,000.00 $ 197,922.35 $ 412,077.65 23 $ 615,000.00 $ 194,285.60 $ 420,714.40 24 $ 620,000.00 $ 190,572.62 $ 429,427.38 25 $ 625,000.00 $ 186,782.74 $ 438,217.26 26 $ 630,000.00 $ 182,915.29 $ 447,084.71 27 $ 635,000.00 $ 178,969.58 $ 456,030.42 28 $ 640,000.00 $ 174,944.92 $ 465,055.08 #VALUE! $ 645,000.00 $ 170,840.61 $ 474,159.39 29 $ 650,000.00 $ 166,655.95 $ 483,344.05 30 $ 655,000.00 $ 162,390.24 $ 492,609.76 31 $ 660,000.00 $ 158,042.75 $ 501,957.25 32 $ 665,000.00 $ 153,612.77 $ 511,387.23 33 $ 670,000.00 $ 149,099.56 $ 520,900.44 34 $ 675,000.00 $ 144,502.40 $ 530,497.60

Transcript of matematicas gradiantes

Page 1: matematicas gradiantes

n= 60 meses vG= $ 5,000.00 crecienteA= $ 500,000.00 i= 0.88%

valor presente $ 29,453,144.62

No cuota interes Abobo k0 $ - $ - $ - 1 $ 500,000.00 $ 259,936.37 $ 240,063.63 2 $ 505,000.00 $ 257,817.71 $ 247,182.29 3 $ 510,000.00 $ 255,636.22 $ 254,363.78 4 $ 515,000.00 $ 253,391.35 $ 261,608.65 5 $ 520,000.00 $ 251,082.55 $ 268,917.45 6 $ 525,000.00 $ 248,709.24 $ 276,290.76 7 $ 530,000.00 $ 246,270.86 $ 283,729.14 8 $ 535,000.00 $ 243,766.83 $ 291,233.17 9 $ 540,000.00 $ 241,196.57 $ 298,803.43

10 $ 545,000.00 $ 238,559.51 $ 306,440.49 11 $ 550,000.00 $ 235,855.04 $ 314,144.96 12 $ 555,000.00 $ 233,082.58 $ 321,917.42 13 $ 560,000.00 $ 230,241.52 $ 329,758.48 14 $ 565,000.00 $ 227,331.27 $ 337,668.73

#VALUE! $ 570,000.00 $ 224,351.20 $ 345,648.80 15 $ 575,000.00 $ 221,300.70 $ 353,699.30 16 $ 580,000.00 $ 218,179.16 $ 361,820.84 17 $ 585,000.00 $ 214,985.94 $ 370,014.06 18 $ 590,000.00 $ 211,720.41 $ 378,279.59 19 $ 595,000.00 $ 208,381.93 $ 386,618.07 20 $ 600,000.00 $ 204,969.86 $ 395,030.14 21 $ 605,000.00 $ 201,483.56 $ 403,516.44 22 $ 610,000.00 $ 197,922.35 $ 412,077.65 23 $ 615,000.00 $ 194,285.60 $ 420,714.40 24 $ 620,000.00 $ 190,572.62 $ 429,427.38 25 $ 625,000.00 $ 186,782.74 $ 438,217.26 26 $ 630,000.00 $ 182,915.29 $ 447,084.71 27 $ 635,000.00 $ 178,969.58 $ 456,030.42 28 $ 640,000.00 $ 174,944.92 $ 465,055.08

#VALUE! $ 645,000.00 $ 170,840.61 $ 474,159.39 29 $ 650,000.00 $ 166,655.95 $ 483,344.05 30 $ 655,000.00 $ 162,390.24 $ 492,609.76 31 $ 660,000.00 $ 158,042.75 $ 501,957.25 32 $ 665,000.00 $ 153,612.77 $ 511,387.23 33 $ 670,000.00 $ 149,099.56 $ 520,900.44 34 $ 675,000.00 $ 144,502.40 $ 530,497.60 35 $ 680,000.00 $ 139,820.53 $ 540,179.47 36 $ 685,000.00 $ 135,053.22 $ 549,946.78 37 $ 690,000.00 $ 130,199.71 $ 559,800.29

Page 2: matematicas gradiantes

38 $ 695,000.00 $ 125,259.24 $ 569,740.76 39 $ 700,000.00 $ 120,231.04 $ 579,768.96 40 $ 705,000.00 $ 115,114.33 $ 589,885.67 41 $ 710,000.00 $ 109,908.34 $ 600,091.66 42 $ 715,000.00 $ 104,612.28 $ 610,387.72

#VALUE! $ 720,000.00 $ 99,225.35 $ 620,774.65 43 $ 725,000.00 $ 93,746.76 $ 631,253.24 44 $ 730,000.00 $ 88,175.68 $ 641,824.32 45 $ 735,000.00 $ 82,511.31 $ 652,488.69 46 $ 740,000.00 $ 76,752.83 $ 663,247.17 47 $ 745,000.00 $ 70,899.39 $ 674,100.61 48 $ 750,000.00 $ 64,950.17 $ 685,049.83 49 $ 755,000.00 $ 58,904.32 $ 696,095.68 50 $ 760,000.00 $ 52,760.98 $ 707,239.02 51 $ 765,000.00 $ 46,519.30 $ 718,480.70 52 $ 770,000.00 $ 40,178.41 $ 729,821.59 53 $ 775,000.00 $ 33,737.42 $ 741,262.58 54 $ 780,000.00 $ 27,195.47 $ 752,804.53 55 $ 785,000.00 $ 20,551.65 $ 764,448.35 56 $ 790,000.00 $ 13,805.08 $ 776,194.92

#VALUE! $ 795,000.00 $ 6,954.83 $ 788,045.17

Page 3: matematicas gradiantes

saldo $ 29,453,144.62 $ 29,213,080.99 $ 28,965,898.70 $ 28,711,534.92 $ 30,000,000.00 $ 28,449,926.28 $ 28,181,008.83 $ 27,904,718.06 $ 27,620,988.92 $ 27,329,755.75 $ 27,030,952.32 $ 26,724,511.83 $ 26,410,366.87 $ 26,088,449.45 $ 25,758,690.97 $ 25,421,022.24 $ 25,075,373.44 $ 24,721,674.14 $ 24,359,853.30 $ 23,989,839.24 $ 23,611,559.64 $ 23,224,941.57 $ 22,829,911.44 $ 22,426,394.99 $ 22,014,317.35 $ 21,593,602.95 $ 21,164,175.56 $ 20,725,958.30 $ 20,278,873.59 $ 19,822,843.16 $ 19,357,788.08 $ 18,883,628.69 $ 18,400,284.64 $ 17,907,674.88 $ 17,405,717.64 $ 16,894,330.40 $ 16,373,429.97 $ 15,842,932.36 $ 15,302,752.89 $ 14,752,806.11 $ 14,193,005.83

Page 4: matematicas gradiantes

$ 13,623,265.06 $ 13,043,496.10 $ 12,453,610.43 $ 11,853,518.77 $ 11,243,131.05 $ 10,622,356.41 $ 9,991,103.16 $ 9,349,278.85 $ 8,696,790.16 $ 8,033,542.98 $ 7,359,442.38 $ 6,674,392.55 $ 5,978,296.86 $ 5,271,057.84 $ 4,552,577.14 $ 3,822,755.55 $ 3,081,492.97 $ 2,328,688.44 $ 1,564,240.09 $ 788,045.17 $ -

Page 5: matematicas gradiantes

n= 24 cuotas mensualesci j= 5.00%i= 5%A= $ 1,500,000.00 vp=? $ 43,727,111.74 vpNo cuota interes Abobo k saldo

0 $5,000,000 $ - $ - $ 38,727,111.74 1 $ 1,500,000.00 $ 1,936,355.59 -$ 436,355.59 $ 39,163,467.33 2 $ 1,575,000.00 $ 1,958,173.37 -$ 383,173.37 $ 39,546,640.70 3 $ 1,653,750.00 $ 1,977,332.03 -$ 323,582.03 $ 39,870,222.73 4 $ 1,736,437.50 $ 1,993,511.14 -$ 257,073.64 $ 40,127,296.37 5 $ 1,823,259.38 $ 2,006,364.82 -$ 183,105.44 $ 40,310,401.81 6 $ 1,914,422.34 $ 2,015,520.09 -$ 101,097.75 $ 40,411,499.56 7 $ 2,010,143.46 $ 2,020,574.98 -$ 10,431.52 $ 40,421,931.07 8 $ 2,110,650.63 $ 2,021,096.55 $ 89,554.08 $ 40,332,376.99 9 $ 2,216,183.17 $ 2,016,618.85 $ 199,564.32 $ 40,132,812.68

10 $ 2,326,992.32 $ 2,006,640.63 $ 320,351.69 $ 39,812,460.99 11 $ 2,443,341.94 $ 1,990,623.05 $ 452,718.89 $ 39,359,742.10 12 $ 2,565,509.04 $ 1,967,987.10 $ 597,521.93 $ 38,762,220.16 13 $ 2,693,784.49 $ 1,938,111.01 $ 755,673.48 $ 38,006,546.68 14 $ 2,828,473.71 $ 1,900,327.33 $ 928,146.38 $ 37,078,400.30 15 $ 2,969,897.40 $ 1,853,920.02 $ 1,115,977.38 $ 35,962,422.92

1 $ 3,118,392.27 $ 1,798,121.15 $ 1,320,271.12 $ 34,642,151.80 17 $ 3,274,311.88 $ 1,732,107.59 $ 1,542,204.29 $ 33,099,947.51 18 $ 3,438,027.48 $ 1,654,997.38 $ 1,783,030.10 $ 31,316,917.40 19 $ 3,609,928.85 $ 1,565,845.87 $ 2,044,082.98 $ 29,272,834.42 20 $ 3,790,425.29 $ 1,463,641.72 $ 2,326,783.57 $ 26,946,050.85 21 $ 3,979,946.56 $ 1,347,302.54 $ 2,632,644.02 $ 24,313,406.84 22 $ 4,178,943.89 $ 1,215,670.34 $ 2,963,273.54 $ 21,350,133.29 23 $ 4,387,891.08 $ 1,067,506.66 $ 3,320,384.42 $ 18,029,748.88 24 $ 4,607,285.63 $ 901,487.44 $ 3,705,798.19 $ 14,323,950.69

Page 6: matematicas gradiantes

DECRECIENTE GRADIENTES

$ 18,641,953.60 No cuota interes Abobo k saldo

0 $5,000,000 $ - $ - $13,641,9541 $ 1,500,000.00 $ 682,097.68 $ 817,902.32 $ 12,824,051.28 2 $ 1,425,000.00 $ 641,202.56 $ 783,797.44 $ 12,040,253.85 3 $ 1,353,750.00 $ 602,012.69 $ 751,737.31 $ 11,288,516.54 4 $ 1,286,062.50 $ 564,425.83 $ 721,636.67 $ 10,566,879.86 5 $ 1,221,759.38 $ 528,343.99 $ 693,415.38 $ 9,873,464.48 6 $ 1,160,671.41 $ 493,673.22 $ 666,998.18 $ 9,206,466.30 7 $ 1,102,637.84 $ 460,323.32 $ 642,314.52 $ 8,564,151.78 8 $ 1,047,505.94 $ 428,207.59 $ 619,298.36 $ 7,944,853.42 9 $ 995,130.65 $ 397,242.67 $ 597,887.98 $ 7,346,965.45

10 $ 945,374.11 $ 367,348.27 $ 578,025.84 $ 6,768,939.61 11 $ 898,105.41 $ 338,446.98 $ 559,658.43 $ 6,209,281.18 12 $ 853,200.14 $ 310,464.06 $ 542,736.08 $ 5,666,545.10 13 $ 810,540.13 $ 283,327.25 $ 527,212.88 $ 5,139,332.22 14 $ 770,013.12 $ 256,966.61 $ 513,046.51 $ 4,626,285.71 15 $ 731,512.47 $ 231,314.29 $ 500,198.18 $ 4,126,087.52

1 $ 694,936.85 $ 206,304.38 $ 488,632.47 $ 3,637,455.06 17 $ 660,190.00 $ 181,872.75 $ 478,317.25 $ 3,159,137.81 18 $ 627,180.50 $ 157,956.89 $ 469,223.61 $ 2,689,914.19 19 $ 595,821.48 $ 134,495.71 $ 461,325.77 $ 2,228,588.42 20 $ 566,030.40 $ 111,429.42 $ 454,600.98 $ 1,773,987.44 21 $ 537,728.88 $ 88,699.37 $ 449,029.51 $ 1,324,957.93 22 $ 510,842.44 $ 66,247.90 $ 444,594.54 $ 880,363.39 23 $ 485,300.32 $ 44,018.17 $ 441,282.15 $ 439,081.24 24 $ 461,035.30 $ 21,954.06 $ 439,081.24 -$ 0.00