Simulacion de Caja Huancayo

8/16/2019 Simulacion de Caja Huancayo

1/17

Prestamo $ 1,500,000.00Interés 13%

Tiempo 120 10Comisión 2%

Tiempo Capital Interés Pago

1 $ 1,500,000.00 $ 16,250.00 $ 22,396.612 $ 1,493,853.39 $ 16,183.41 $ 22,396.613 $ 1,487,640.19 $ 16,116.10 $ 22,396.614 $ 1,481,359.68 $ 16,048.06 $ 22,396.615 $ 1,475,011.13 $ 15,979.29 $ 22,396.616 $ 1,468,593.81 $ 15,909.77 $ 22,396.617 $ 1,462,106.96 $ 15,839.49 $ 22,396.618 $ 1,455,549.85 $ 15,768.46 $ 22,396.619 $ 1,448,921.69 $ 15,696.65 $ 22,396.61

10 $ 1,442,221.73 $ 15,624.07 $ 22,396.6111 $ 1,435,449.19 $ 15,550.70 $ 22,396.6112 $ 1,428,603.28 $ 15,476.54 $ 22,396.6113 $ 1,421,683.20 $ 15,401.57 $ 22,396.6114 $ 1,414,688.16 $ 15,325.79 $ 22,396.6115 $ 1,407,617.34 $ 15,249.19 $ 22,396.6116 $ 1,400,469.91 $ 15,171.76 $ 22,396.6117 $ 1,393,245.06 $ 15,093.49 $ 22,396.6118 $ 1,385,941.94 $ 15,014.37 $ 22,396.6119 $ 1,378,559.70 $ 14,934.40 $ 22,396.6120 $ 1,371,097.48 $ 14,853.56 $ 22,396.6121 $ 1,363,554.43 $ 14,771.84 $ 22,396.6122 $ 1,355,929.66 $ 14,689.24 $ 22,396.6123 $ 1,348,222.28 $ 14,605.74 $ 22,396.6124 $ 1,340,431.41 $ 14,521.34 $ 22,396.6125 $ 1,332,556.14 $ 14,436.02 $ 22,396.61

26 $ 1,324,595.56 $ 14,349.79 $ 22,396.6127 $ 1,316,548.73 $ 14,262.61 $ 22,396.6128 $ 1,308,414.73 $ 14,174.49 $ 22,396.6129 $ 1,300,192.61 $ 14,085.42 $ 22,396.6130 $ 1,291,881.42 $ 13,995.38 $ 22,396.6131 $ 1,283,480.19 $ 13,904.37 $ 22,396.6132 $ 1,274,987.95 $ 13,812.37 $ 22,396.6133 $ 1,266,403.71 $ 13,719.37 $ 22,396.6134 $ 1,257,726.47 $ 13,625.37 $ 22,396.6135 $ 1,248,955.23 $ 13,530.35 $ 22,396.61

36 $ 1,240,088.97 $ 13,434.30 $ 22,396.6137 $ 1,231,126.66 $ 13,337.21 $ 22,396.61


2/17

38 $ 1,222,067.25 $ 13,239.06 $ 22,396.6139 $ 1,212,909.70 $ 13,139.86 $ 22,396.6140 $ 1,203,652.95 $ 13,039.57 $ 22,396.6141 $ 1,194,295.91 $ 12,938.21 $ 22,396.6142 $ 1,184,837.50 $ 12,835.74 $ 22,396.61

43 $ 1,175,276.63 $ 12,732.16 $ 22,396.6144 $ 1,165,612.18 $ 12,627.47 $ 22,396.6145 $ 1,155,843.04 $ 12,521.63 $ 22,396.6146 $ 1,145,968.06 $ 12,414.65 $ 22,396.6147 $ 1,135,986.10 $ 12,306.52 $ 22,396.6148 $ 1,125,896.01 $ 12,197.21 $ 22,396.6149 $ 1,115,696.60 $ 12,086.71 $ 22,396.6150 $ 1,105,386.71 $ 11,975.02 $ 22,396.6151 $ 1,094,965.12 $ 11,862.12 $ 22,396.6152 $ 1,084,430.63 $ 11,748.00 $ 22,396.6153 $ 1,073,782.02 $ 11,632.64 $ 22,396.6154 $ 1,063,018.04 $ 11,516.03 $ 22,396.6155 $ 1,052,137.46 $ 11,398.16 $ 22,396.6156 $ 1,041,139.01 $ 11,279.01 $ 22,396.6157 $ 1,030,021.40 $ 11,158.57 $ 22,396.6158 $ 1,018,783.36 $ 11,036.82 $ 22,396.6159 $ 1,007,423.56 $ 10,913.76 $ 22,396.6160 $ 995,940.71 $ 10,789.36 $ 22,396.6161 $ 984,333.45 $ 10,663.61 $ 22,396.6162 $ 972,600.46 $ 10,536.50 $ 22,396.6163 $ 960,740.35 $ 10,408.02 $ 22,396.6164 $ 948,751.76 $ 10,278.14 $ 22,396.6165 $ 936,633.29 $ 10,146.86 $ 22,396.6166 $ 924,383.54 $ 10,014.16 $ 22,396.6167 $ 912,001.09 $ 9,880.01 $ 22,396.6168 $ 899,484.49 $ 9,744.42 $ 22,396.6169 $ 886,832.29 $ 9,607.35 $ 22,396.6170 $ 874,043.03 $ 9,468.80 $ 22,396.6171 $ 861,115.22 $ 9,328.75 $ 22,396.61

72 $ 848,047.36 $ 9,187.18 $ 22,396.6173 $ 834,837.92 $ 9,044.08 $ 22,396.6174 $ 821,485.39 $ 8,899.43 $ 22,396.6175 $ 807,988.21 $ 8,753.21 $ 22,396.6176 $ 794,344.80 $ 8,605.40 $ 22,396.6177 $ 780,553.59 $ 8,456.00 $ 22,396.6178 $ 766,612.98 $ 8,304.97 $ 22,396.6179 $ 752,521.34 $ 8,152.31 $ 22,396.6180 $ 738,277.04 $ 7,998.00 $ 22,396.6181 $ 723,878.43 $ 7,842.02 $ 22,396.61

82 $ 709,323.84 $ 7,684.34 $ 22,396.6183 $ 694,611.57 $ 7,524.96 $ 22,396.61


3/17

84 $ 679,739.92 $ 7,363.85 $ 22,396.6185 $ 664,707.16 $ 7,200.99 $ 22,396.6186 $ 649,511.54 $ 7,036.38 $ 22,396.6187 $ 634,151.30 $ 6,869.97 $ 22,396.6188 $ 618,624.66 $ 6,701.77 $ 22,396.61

89 $ 602,929.82 $ 6,531.74 $ 22,396.6190 $ 587,064.95 $ 6,359.87 $ 22,396.6191 $ 571,028.21 $ 6,186.14 $ 22,396.6192 $ 554,817.74 $ 6,010.53 $ 22,396.6193 $ 538,431.65 $ 5,833.01 $ 22,396.6194 $ 521,868.05 $ 5,653.57 $ 22,396.6195 $ 505,125.01 $ 5,472.19 $ 22,396.6196 $ 488,200.59 $ 5,288.84 $ 22,396.6197 $ 471,092.81 $ 5,103.51 $ 22,396.6198 $ 453,799.71 $ 4,916.16 $ 22,396.6199 $ 436,319.26 $ 4,726.79 $ 22,396.61

100 $ 418,649.44 $ 4,535.37 $ 22,396.61101 $ 400,788.20 $ 4,341.87 $ 22,396.61102 $ 382,733.46 $ 4,146.28 $ 22,396.61103 $ 364,483.13 $ 3,948.57 $ 22,396.61104 $ 346,035.09 $ 3,748.71 $ 22,396.61105 $ 327,387.19 $ 3,546.69 $ 22,396.61106 $ 308,537.27 $ 3,342.49 $ 22,396.61107 $ 289,483.15 $ 3,136.07 $ 22,396.61108 $ 270,222.60 $ 2,927.41 $ 22,396.61109 $ 250,753.40 $ 2,716.50 $ 22,396.61110 $ 231,073.29 $ 2,503.29 $ 22,396.61111 $ 211,179.97 $ 2,287.78 $ 22,396.61112 $ 191,071.14 $ 2,069.94 $ 22,396.61113 $ 170,744.47 $ 1,849.73 $ 22,396.61114 $ 150,197.59 $ 1,627.14 $ 22,396.61115 $ 129,428.12 $ 1,402.14 $ 22,396.61116 $ 108,433.65 $ 1,174.70 $ 22,396.61117 $ 87,211.73 $ 944.79 $ 22,396.61

118 $ 65,759.92 $ 712.40 $ 22,396.61119 $ 44,075.71 $ 477.49 $ 22,396.61120 $ 22,156.58 $ 240.03 $ 22,396.61


4/17

Saldo Amort $ 1,500,000.00 e!"a $ 1,493,853.39 $ 6,146.61 Pa#o tota $ 1,487,640.19 $ 6,213.20 Interés $ 1,481,359.68 $ 6,280.51 Interés rea $ 1,475,011.13 $ 6,348.55 Interés an!a $ 1,468,593.81 $ 6,417.32 Interés mens!a $ 1,462,106.96 $ 6,486.84$ 1,455,549.85 $ 6,557.12$ 1,448,921.69 $ 6,628.15 Capita en prestamo

$ 1,442,221.73 $ 6,699.96 Tasa "e Imp. a a renta $ 1,435,449.19 $ 6,772.54 Imp!esto $ 1,428,603.28 $ 6,845.91 Cap. isponie $ 1,421,683.20 $ 6,920.08$ 1,414,688.16 $ 6,995.04$ 1,407,617.34 $ 7,070.82$ 1,400,469.91 $ 7,147.42 Interés a&o 1

$ 1,393,245.06 $ 7,224.85 Interés a&o 2 $ 1,385,941.94 $ 7,303.12 Interés a&o 3 $ 1,378,559.70 $ 7,382.24 Interés a&o 4 $ 1,371,097.48 $ 7,462.21 Interés a&o 5 $ 1,363,554.43 $ 7,543.05 Interés a&o 6 $ 1,355,929.66 $ 7,624.77 Interés a&o 7 $ 1,348,222.28 $ 7,707.37 Interés a&o 8 $ 1,340,431.41 $ 7,790.87 Interés a&o 9 $ 1,332,556.14 $ 7,875.27 Interés a&o 10 $ 1,324,595.56 $ 7,960.59

$ 1,316,548.73 $ 8,046.83$ 1,308,414.73 $ 8,134.00$ 1,300,192.61 $ 8,222.12$ 1,291,881.42 $ 8,311.19$ 1,283,480.19 $ 8,401.23$ 1,274,987.95 $ 8,492.24$ 1,266,403.71 $ 8,584.24$ 1,257,726.47 $ 8,677.24$ 1,248,955.23 $ 8,771.24$ 1,240,088.97 $ 8,866.26

$ 1,231,126.66 $ 8,962.31$ 1,222,067.25 $ 9,059.41


5/17

$ 1,212,909.70 $ 9,157.55$ 1,203,652.95 $ 9,256.76$ 1,194,295.91 $ 9,357.04$ 1,184,837.50 $ 9,458.41$ 1,175,276.63 $ 9,560.87

$ 1,165,612.18 $ 9,664.45$ 1,155,843.04 $ 9,769.15$ 1,145,968.06 $ 9,874.98$ 1,135,986.10 $ 9,981.96$ 1,125,896.01 $ 10,090.09$ 1,115,696.60 $ 10,199.40$ 1,105,386.71 $ 10,309.90$ 1,094,965.12 $ 10,421.59$ 1,084,430.63 $ 10,534.49$ 1,073,782.02 $ 10,648.61$ 1,063,018.04 $ 10,763.97$ 1,052,137.46 $ 10,880.58$ 1,041,139.01 $ 10,998.46$ 1,030,021.40 $ 11,117.61$ 1,018,783.36 $ 11,238.05$ 1,007,423.56 $ 11,359.79$ 995,940.71 $ 11,482.86$ 984,333.45 $ 11,607.25$ 972,600.46 $ 11,733.00$ 960,740.35 $ 11,860.11$ 948,751.76 $ 11,988.59$ 936,633.29 $ 12,118.47$ 924,383.54 $ 12,249.75$ 912,001.09 $ 12,382.46$ 899,484.49 $ 12,516.60$ 886,832.29 $ 12,652.20$ 874,043.03 $ 12,789.26$ 861,115.22 $ 12,927.81$ 848,047.36 $ 13,067.86

$ 834,837.92 $ 13,209.43$ 821,485.39 $ 13,352.53$ 807,988.21 $ 13,497.19$ 794,344.80 $ 13,643.41$ 780,553.59 $ 13,791.21$ 766,612.98 $ 13,940.61$ 752,521.34 $ 14,091.64$ 738,277.04 $ 14,244.30$ 723,878.43 $ 14,398.61$ 709,323.84 $ 14,554.59

$ 694,611.57 $ 14,712.27$ 679,739.92 $ 14,871.65


6/17

$ 664,707.16 $ 15,032.76$ 649,511.54 $ 15,195.62$ 634,151.30 $ 15,360.24$ 618,624.66 $ 15,526.64$ 602,929.82 $ 15,694.84

$ 587,064.95 $ 15,864.87$ 571,028.21 $ 16,036.74$ 554,817.74 $ 16,210.47$ 538,431.65 $ 16,386.09$ 521,868.05 $ 16,563.60$ 505,125.01 $ 16,743.04$ 488,200.59 $ 16,924.42$ 471,092.81 $ 17,107.77$ 453,799.71 $ 17,293.11$ 436,319.26 $ 17,480.45$ 418,649.44 $ 17,669.82$ 400,788.20 $ 17,861.24$ 382,733.46 $ 18,054.74$ 364,483.13 $ 18,250.33$ 346,035.09 $ 18,448.04$ 327,387.19 $ 18,647.90$ 308,537.27 $ 18,849.92$ 289,483.15 $ 19,054.12$ 270,222.60 $ 19,260.54$ 250,753.40 $ 19,469.20$ 231,073.29 $ 19,680.12$ 211,179.97 $ 19,893.32$ 191,071.14 $ 20,108.83$ 170,744.47 $ 20,326.67$ 150,197.59 $ 20,546.88$ 129,428.12 $ 20,769.47$ 108,433.65 $ 20,994.47$ 87,211.73 $ 21,221.91$ 65,759.92 $ 21,451.82

$ 44,075.71 $ 21,684.21$ 22,156.58 $ 21,919.12$ 0.00 $ 22,156.58


7/17

$ 1,500,000.00$ 2,687,593.32$ 1,187,593.32

79.17%6.01%0.49%

$ 1,500,000.0030%

$ 450,000.00$ 1,050,000.00

$ 190,442.53 12.70% $ 179,632.27 11.98% $ 167,329.84 11.16% $ 153,329.28 10.22% $ 137,396.18 9.16% $ 119,263.80 7.95% $ 98,628.56 6.58% $ 75,144.99 5.01% $ 48,419.92 3.23% $ 18,005.93 1.20%

###


8/17


9/17


10/17

'onto TasaCen(os!" )*. 700,000.00 7.05%+aaea )*. 6.24%Comer(io )*. 2,615,000.00 7.14%'i -an(o )*. 150,000.00 6.16%

+inan(iero )*. 5.73% $ 3,465,000.00 7.08%

Cen(os!"Tiempo Capital Interés

1 )*. 700,000.00 )*. 49,350.002 )*. 700,000.00 )*. 49,350.003 )*. 700,000.00 )*. 49,350.004 )*. 700,000.00 )*. 49,350.005 )*. 700,000.00 )*. 49,350.006 )*. 700,000.00 )*. 49,350.007 )*. 700,000.00 )*. 49,350.008 )*. 700,000.00 )*. 49,350.009 )*. 700,000.00 )*. 49,350.00

10 )*. 700,000.00 )*. 49,350.00+aaea

Tiempo Capital Interés

1 )*. )*. 2 )*. )*. 3 )*. )*. 4 )*. )*. 5 )*. )*. 6 )*. )*. 7 )*. )*. 8 )*. )*. 9 )*. )*.

10 )*. )*.

Comer(ioTiempo Capital Interés

1 )*. 2,615,000.00 )*. 186,711.002 )*. 2,615,000.00 )*. 186,711.003 )*. 2,615,000.00 )*. 186,711.004 )*. 2,615,000.00 )*. 186,711.005 )*. 2,615,000.00 )*. 186,711.006 )*. 2,615,000.00 )*. 186,711.007 )*. 2,615,000.00 )*. 186,711.00

8 )*. 2,615,000.00 )*. 186,711.009 )*. 2,615,000.00 )*. 186,711.00


11/17

10 )*. 2,615,000.00 )*. 186,711.00


12/17

anan(ia "e Cen(os!"anan(ia "e +aaeaanan(ia "e Comer(ioanan(ia "e 'i -an(o

anan(ia "e +inan(iero

Pago Saldo Amort )*. 700,000.00

)*. 49,350.00 )*. 700,000.00 )*. )*. 49,350.00 )*. 700,000.00 )*. )*. 49,350.00 )*. 700,000.00 )*. )*. 49,350.00 )*. 700,000.00 )*. )*. 49,350.00 )*. 700,000.00 )*. )*. 49,350.00 )*. 700,000.00 )*. )*. 49,350.00 )*. 700,000.00 )*. )*. 49,350.00 )*. 700,000.00 )*. )*. 49,350.00 )*. 700,000.00 )*. )*. 49,350.00 )*. 700,000.00 )*.

Pago Saldo Amort )*.

)*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*.

Pago Saldo Amort )*. 2,615,000.00

)*. 186,711.00 )*. 2,615,000.00 )*. )*. 186,711.00 )*. 2,615,000.00 )*. )*. 186,711.00 )*. 2,615,000.00 )*. )*. 186,711.00 )*. 2,615,000.00 )*. )*. 186,711.00 )*. 2,615,000.00 )*. )*. 186,711.00 )*. 2,615,000.00 )*. )*. 186,711.00 )*. 2,615,000.00 )*.

)*. 186,711.00 )*. 2,615,000.00 )*. )*. 186,711.00 )*. 2,615,000.00 )*.


13/17

)*. 186,711.00 )*. 2,615,000.00 )*.


14/17


15/17

)*. 84,000.00


16/17

Pago Saldo Amort )*. 150,000.00

)*. 9,240.00 )*. 150,000.00 )*. )*. 9,240.00 )*. 150,000.00 )*. )*. 9,240.00 )*. 150,000.00 )*. )*. 9,240.00 )*. 150,000.00 )*. )*. 9,240.00 )*. 150,000.00 )*. )*. 9,240.00 )*. 150,000.00 )*. )*. 9,240.00 )*. 150,000.00 )*. )*. 9,240.00 )*. 150,000.00 )*. )*. 9,240.00 )*. 150,000.00 )*. )*. 9,240.00 )*. 150,000.00 )*.

Pago Saldo Amort )*.

)*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*. )*.

)*. 3,465,000.00)*. 700,000.00)*. 900,000.00)*. 150,000.00)*. 300,000.00


17/17

Documents

Simulacion de Caja Huancayo