ejercicios ingeniería económica2

Período Deuda Interés Cuota Amortizar0.00 2000000.00 0.00 0.00 0.001.00 2105000.00 105000.00 0.00 -105000.002.00 2215512.50 110512.50 0.00 -110512.503.00 2215512.50 116314.41 116314.41 0.004.00 2215512.50 116314.41 116314.41 0.005.00 1739886.80 116314.41 591940.11 475625.706.00 1239290.75 91344.06 591940.11 500596.057.00 562413.40 65062.76 741940.11 676877.348.00 0.00 29526.70 591940.11 562413.40

Préstamo2000000.00

Tasa de Interés 0.05

R 591940.11Cuota extra 150000.00

Elaborar una tabla para amortizar 2 millones en las siguientes condiciones:a) Plazo de gracia muerto con cuota reducida 6 meses.

b) Plazo de gracia con cuota reducida de 6 mesesc) 4 cuotas trimestrales ordinarias uniformes.

d) Cuota extra pactada de $150.000 en el periodo 7.e) Tasa de interés del 21% capitalización trimestral.

Período Deuda Intereses Cuota Amortización0.00 400000.00 0.00 0.00 0.001.00 409737.49 36000.00 26262.51 -9737.492.00 420351.35 36876.37 26262.51 -10613.863.00 431920.46 37831.62 26262.51 -11569.114.00 444530.79 38872.84 26262.51 -12610.335.00 454336.67 40007.77 30201.89 -9805.886.00 465025.08 40890.30 30201.89 -10688.417.00 476675.45 41852.26 30201.89 -11650.378.00 489374.35 42900.79 30201.89 -12698.909.00 498685.87 44043.69 34732.17 -9311.52

10.00 508835.42 44881.73 34732.17 -10149.5611.00 519898.44 45795.19 34732.17 -11063.0212.00 531957.13 46790.86 34732.17 -12058.6913.00 539891.27 47876.14 39942.00 -7934.1414.00 548539.49 48590.21 39942.00 -8648.2215.00 557966.04 49368.55 39942.00 -9426.5616.00 568240.99 50216.94 39942.00 -10274.9517.00 573449.38 51141.69 45933.30 -5208.3918.00 579126.52 51610.44 45933.30 -5677.1519.00 585314.61 52121.39 45933.30 -6188.0920.00 592059.63 52678.32 45933.30 -6745.0221.00 592521.70 53285.37 52823.29 -462.0722.00 593025.36 53326.95 52823.29 -503.6623.00 593574.35 53372.28 52823.29 -548.9924.00 594172.75 53421.69 52823.29 -598.4025.00 586901.51 53475.55 60746.79 7271.2426.00 578975.86 52821.14 60746.79 7925.6527.00 570336.90 52107.83 60746.79 8638.9628.00 560920.44 51330.32 60746.79 9416.4729.00 541544.47 50482.84 69858.80 19375.9730.00 520424.67 48739.00 69858.80 21119.8031.00 497404.09 46838.22 69858.80 23020.5832.00 472311.65 44766.37 69858.80 25092.4433.00 434482.07 42508.05 80337.63 37829.5834.00 393247.83 39103.39 80337.63 41234.2435.00 348302.51 35392.30 80337.63 44945.3236.00 299312.11 31347.23 80337.63 48990.4037.00 233861.93 26938.09 92388.27 65450.18

Una persona se compromete a cancelar una deuda de $400.000 en intereses al 36% C.T mediante pagos trimestrales durante 10 años. Cada año el valor de las cuotas crece un 15%, pero dentro de cada año la cuota no varía. Elaborar la tabla de amortización

38.00 162521.24 21047.57 92388.27 71340.7039.00 84759.88 14626.91 92388.27 77761.3640.00 0.00 7628.39 92388.27 84759.88

Tasa de Interés trimestral 0.09 Tasa de Interés anual 0.41Préstamo 400000.00

Año R anual R trimestralG 0.15 1.00 120101.86 26262.51

2.00 138117.14 30201.893.00 158834.71 34732.174.00 182659.91 39942.005.00 210058.90 45933.306.00 241567.73 52823.297.00 277802.89 60746.798.00 319473.33 69858.809.00 367394.33 80337.63

10.00 422503.47 92388.27

Una persona se compromete a cancelar una deuda de $400.000 en intereses al 36% C.T mediante pagos trimestrales durante 10 años. Cada año el valor de las cuotas crece un 15%, pero dentro de cada año la cuota no varía. Elaborar la tabla de amortización

Halla la distribución del pago #58 en una amortización de $5000000 en pagos mensuales durante 10 años. Suponga que los pagos son crecientes en un 2% y que la tasa es del 3% e.m.

Periodo Deuda Interes Cuota0.00 5000000.00 0.00 0.001.00 5077521.84 150000.00 72478.162.00 5155919.76 152325.66 73927.733.00 5235191.08 154677.59 75406.284.00 5315332.40 157055.73 76914.415.00 5396339.68 159459.97 78452.706.00 5478208.12 161890.19 80021.757.00 5560932.18 164346.24 81622.188.00 5644505.52 166827.97 83254.639.00 5728920.96 169335.17 84919.72

10.00 5814170.48 171867.63 86618.1111.00 5900245.11 174425.11 88350.4812.00 5987134.98 177007.35 90117.4913.00 6074829.19 179614.05 91919.8414.00 6163315.84 182244.88 93758.2315.00 6252581.91 184899.48 95633.4016.00 6342613.31 187577.46 97546.0717.00 6433394.72 190278.40 99496.9918.00 6524909.63 193001.84 101486.9319.00 6617140.26 195747.29 103516.6720.00 6710067.47 198514.21 105587.0021.00 6803670.75 201302.02 107698.7422.00 6897928.16 204110.12 109852.7123.00 6992816.24 206937.84 112049.7724.00 7088309.96 209784.49 114290.7625.00 7184382.68 212649.30 116576.5826.00 7281006.05 215531.48 118908.1127.00 7378149.96 218430.18 121286.2728.00 7475782.46 221344.50 123712.0029.00 7573869.70 224273.47 126186.2430.00 7672375.83 227216.09 128709.9631.00 7771262.94 230171.27 131284.1632.00 7870490.99 233137.89 133909.8433.00 7970017.68 236114.73 136588.0434.00 8069798.40 239100.53 139319.8035.00 8169786.16 242093.95 142106.2036.00 8269931.42 245093.58 144948.3237.00 8370182.07 248097.94 147847.2938.00 8470483.30 251105.46 150804.2339.00 8570777.48 254114.50 153820.3240.00 8671004.08 257123.32 156896.73

41.00 8771099.54 260130.12 160034.6642.00 8870997.18 263132.99 163235.3543.00 8970627.03 266129.92 166500.0644.00 9069915.78 269118.81 169830.0645.00 9168786.59 272097.47 173226.6646.00 9267158.99 275063.60 176691.2047.00 9364948.74 278014.77 180225.0248.00 9462067.69 280948.46 183829.5249.00 9558423.61 283862.03 187506.1150.00 9653920.08 286752.71 191256.2351.00 9748456.33 289617.60 195081.3652.00 9841927.03 292453.69 198982.9853.00 9934222.20 295257.81 202962.6454.00 10025226.97 298026.67 207021.9055.00 10114821.44 300756.81 211162.3456.00 10202880.50 303444.64 215385.5857.00 10289273.62 306086.42 219693.2958.00 10373864.67 308678.21 224087.1659.00 10456511.71 311215.94 228568.9060.00 10537066.78 313695.35 233140.2861.00 10615375.70 316112.00 237803.0962.00 10691277.82 318461.27 242559.1563.00 10764605.83 320738.33 247410.3364.00 10835185.46 322938.17 252358.5465.00 10902835.32 325055.56 257405.7166.00 10967366.56 327085.06 262553.8267.00 11028582.65 329021.00 267804.9068.00 11086279.14 330857.48 273161.0069.00 11140243.29 332588.37 278624.2270.00 11190253.89 334207.30 284196.7071.00 11236080.87 335707.62 289880.6472.00 11277485.05 337082.43 295678.2573.00 11314217.79 338324.55 301591.8174.00 11346020.67 339426.53 307623.6575.00 11372625.17 340380.62 313776.1276.00 11393752.28 341178.76 320051.6477.00 11409112.17 341812.57 326452.6878.00 11418403.81 342273.37 332981.7379.00 11421314.56 342552.11 339641.3780.00 11417519.80 342639.44 346434.1981.00 11406682.52 342525.59 353362.8882.00 11388452.86 342200.48 360430.1383.00 11362467.71 341653.59 367638.7484.00 11328350.23 340874.03 374991.5185.00 11285709.39 339850.51 382491.3486.00 11234139.50 338571.28 390141.1787.00 11173219.70 337024.19 397943.9988.00 11102513.42 335196.59 405902.87

89.00 11021567.89 333075.40 414020.9390.00 10929913.58 330647.04 422301.3591.00 10827063.61 327897.41 430747.3892.00 10712513.20 324811.91 439362.3293.00 10585739.02 321375.40 448149.5794.00 10446198.63 317572.17 457112.5695.00 10293329.78 313385.96 466254.8196.00 10126549.77 308799.89 475579.9197.00 9945254.75 303796.49 485091.5198.00 9748819.06 298357.64 494793.3499.00 9536594.43 292464.57 504689.20

100.00 9307909.27 286097.83 514782.99101.00 9062067.91 279237.28 525078.65102.00 8798349.72 271862.04 535580.22103.00 8516008.39 263950.49 546291.82104.00 8214270.98 255480.25 557217.66105.00 7892337.10 246428.13 568362.01106.00 7549377.96 236770.11 579729.25107.00 7184535.46 226481.34 591323.84108.00 6796921.20 215536.06 603150.32109.00 6385615.52 203907.64 615213.32110.00 5949666.40 191568.47 627517.59111.00 5488088.45 178489.99 640067.94112.00 4999861.80 164642.65 652869.30113.00 4483930.97 149995.85 665926.69114.00 3939203.68 134517.93 679245.22115.00 3364549.67 118176.11 692830.12116.00 2758799.43 100936.49 706686.73117.00 2120742.96 82763.98 720820.46118.00 1449128.38 63622.29 735236.87119.00 742660.62 43473.85 749941.61120.00 0.00 22279.82 764940.44

Halla la distribución del pago #58 en una amortización de $5000000 en pagos mensuales durante 10 años. Suponga que los pagos son crecientes en un 2% y que la tasa es del 3% e.m.

Amortizar i 0.030.00 G 0.02

-77521.84 Saldo 5000000.00-78397.93-79271.31 R 72478.16-80141.33-81007.28-81868.44-82724.06-83573.34-84415.45-85249.51-86074.64-86889.87-87694.21-88486.64-89266.08-90031.39-90781.41-91514.91-92230.62-92927.21-93603.29-94257.41-94888.08-95493.72-96072.72-96623.37-97143.91-97632.50-98087.24-98506.13-98887.11-99228.04-99526.69-99780.73-99987.75

-100145.26-100250.65-100301.23-100294.18-100226.60

-100095.46-99897.63-99629.86-99288.75-98870.81-98372.40-97789.75-97118.94-96355.92-95496.48-94536.24-93470.71-92295.17-91004.77-89594.47-88059.06-86393.12-84591.05-82647.04-80555.07-78308.92-75902.12-73328.00-70579.64-67649.86-64531.24-61216.10-57696.48-53964.16-50010.60-45826.98-41404.18-36732.74-31802.88-26604.50-21127.11-15359.89-9291.63-2910.753794.76

10837.2818229.6625985.1534117.4842640.8451569.8960919.8170706.28

80945.5391654.31

102849.97114550.41126774.17139540.39152868.85166780.01181295.01196435.69212224.63228685.15245841.37263718.18282341.33301737.41321933.88342959.14364842.50387614.25411305.69435949.12461577.95488226.65515930.83544727.29574654.01605750.24638056.48671614.58706467.76742660.62

Tasa de Interés Mensual 0.025 Tasa de Interés Trimestral 0.077

Periodo Deuda Intereses Cuota Amortización0.00 100000.000 0.000 0.000 0.000

1.00 107689.062 7689.062 0.000 -7689.062

2.00 115969.342 8280.279 0.000 -8280.279

3.00 108929.763 8916.955 15956.534 7039.579

4.00 101348.907 8375.678 15956.534 7580.856

5.00 93185.154 7792.781 15956.534 8163.753

6.00 64393.684 7165.065 35956.534 28791.469

7.00 50037.549 4951.271 19307.406 14356.135

8.00 34577.562 3847.418 19307.406 15459.988

9.00 17928.846 2658.690 19307.406 16648.716

10.00 0.000 1378.560 19307.406 17928.846

n = 36.00i = 0.03

Periodo Costos fijos Costo Variable Producción Precio Ventas 0.00 0.00 0.00 0.00 3250314.871.00 600000.00 0.00 0.00 600000.002.00 600000.00 0.00 0.00 600000.003.00 600000.00 0.00 0.00 600000.004.00 600000.00 0.00 0.00 600000.005.00 600000.00 0.00 0.00 600000.006.00 600000.00 0.00 0.00 600000.00 7957778.017.00 600000.00 150.00 300.00 645000.008.00 600000.00 150.00 500.00 675000.009.00 600000.00 150.00 700.00 705000.00

10.00 600000.00 150.00 900.00 735000.0011.00 600000.00 150.00 1100.00 765000.0012.00 600000.00 150.00 1300.00 795000.0013.00 600000.00 150.00 1500.00 825000.0014.00 600000.00 150.00 1700.00 855000.0015.00 600000.00 150.00 1900.00 885000.0016.00 600000.00 150.00 2100.00 915000.0017.00 600000.00 150.00 2300.00 945000.0018.00 600000.00 150.00 2500.00 975000.00 13409675.2519.00 600000.00 150.00 2500.00 975000.0020.00 600000.00 150.00 2500.00 975000.0021.00 600000.00 150.00 2500.00 975000.0022.00 600000.00 150.00 2500.00 975000.0023.00 600000.00 150.00 2500.00 975000.0024.00 600000.00 150.00 2500.00 975000.0025.00 600000.00 150.00 2500.00 975000.0026.00 600000.00 150.00 2500.00 975000.0027.00 600000.00 150.00 2500.00 975000.0028.00 600000.00 150.00 2500.00 975000.0029.00 600000.00 150.00 2500.00 975000.0030.00 600000.00 150.00 2500.00 975000.0031.00 600000.00 150.00 2500.00 975000.0032.00 600000.00 150.00 2500.00 975000.0033.00 600000.00 150.00 2500.00 975000.0034.00 600000.00 150.00 2500.00 975000.0035.00 600000.00 150.00 2500.00 975000.0036.00 600000.00 150.00 2500.00 975000.00

Vpresente = 17791599.60

Tasa de Interés Trimestral 0.11Primera Alternativa

Periodo Deuda Intereses Cuota Amortización 0.00 1000000.00 0.00 0.00 0.001.00 914130.72 105000.00 190869.28 85869.282.00 819245.17 95983.73 190869.28 94885.553.00 414396.64 86020.74 490869.28 404848.534.00 267039.01 43511.65 190869.28 147357.635.00 104208.83 28039.10 190869.28 162830.186.00 0.00 10941.93 115150.76 104208.83 Extra7.008.00

Segunda Alternativa

Periodo Deuda Intereses Cuota Amortización 0.00 1000000.00 0.00 0.00 0.001.00 914130.72 105000.00 190869.28 85869.282.00 819245.17 95983.73 190869.28 94885.553.00 414396.64 86020.74 490869.28 404848.534.00 347191.66 43511.65 110716.63 67204.985.00 272930.16 36455.12 110716.63 74261.506.00 190871.20 28657.67 110716.63 82058.967.00 100196.04 20041.48 110716.63 90675.158.00 0.00 10520.58 110716.63 100196.04

Tasa de Interés Efectiva Mensual 0.03Periodo

Número de periodos 180.00 0.00Deuda 2000000.00 109.00

110.00

Cuota "R" 60294.84Deuda en el periodo 109 1763385.18

Interés hasta el més 110 6388423.79

Deuda Intereses Cuota Amortización2000000.001763385.181755991.90 52901.56 60294.84 7393.28

Tasa de Interés semestral 0.15

Periodo Capital Intereses Cuota Capitalización0.00 0.00 0.00 0.00 0.001.00 59593.33 0.00 59593.33 59593.332.00 128125.65 8939.00 59593.33 68532.333.00 276937.83 19218.85 129593.33 148812.184.00 378071.83 41540.67 59593.33 101134.005.00 434782.61 56710.78 0.00 56710.786.00 500000.00 65217.39 0.00 65217.39

Tasa por periodo 0.10 Periodo DeudaG 0.20 0.00 100000.00

1.00 110000.002.00 121000.003.00 100063.724.00 56522.285.00 32438.886.00 0.00

Intereses Cuota Amotización0.00 0.00 0.00

10000.00 0.00 -10000.0011000.00 0.00 -11000.0012100.00 33036.28 20936.2810006.37 53547.81 43541.445652.23 29735.64 24083.413243.89 35682.76 32438.88

Ejercicio 14 Periodo DeudaBacca Capítulo 4 0.00 2000000.00

Tasa de Interés 0.02 1.00 1961534.292.00 1922299.283.00 1882279.564.00 1841459.445.00 1799822.936.00 1757353.687.00 1714035.058.00 1669850.049.00 1624781.34

10.00 1578811.2611.00 1531921.7812.00 1484094.5113.00 1435310.7014.00 1385551.2015.00 1334796.5216.00 1283026.7517.00 1230221.5818.00 1176360.3019.00 1121421.8120.00 1065384.5421.00 1008226.5222.00 949925.3523.00 890458.1524.00 829801.6125.00 767931.9326.00 704824.8727.00 640455.6628.00 574799.0729.00 507829.3430.00 439520.2231.00 369844.9232.00 298776.1233.00 226285.9334.00 152345.9535.00 76927.1636.00 0.00

Intereses Cuota Amortización0.00 0.00 0.00

40000.00 78465.71 38465.7139230.69 78465.71 39235.0238445.99 78465.71 40019.7237645.59 78465.71 40820.1136829.19 78465.71 41636.5235996.46 78465.71 42469.2535147.07 78465.71 43318.6334280.70 78465.71 44185.0033397.00 78465.71 45068.7032495.63 78465.71 45970.0831576.23 78465.71 46889.4830638.44 78465.71 47827.2729681.89 78465.71 48783.8128706.21 78465.71 49759.4927711.02 78465.71 50754.6826695.93 78465.71 51769.7725660.53 78465.71 52805.1724604.43 78465.71 53861.2723527.21 78465.71 54938.5022428.44 78465.71 56037.2721307.69 78465.71 57158.0120164.53 78465.71 58301.1718998.51 78465.71 59467.2017809.16 78465.71 60656.5416596.03 78465.71 61869.6715358.64 78465.71 63107.0714096.50 78465.71 64369.2112809.11 78465.71 65656.5911495.98 78465.71 66969.7210156.59 78465.71 68309.128790.40 78465.71 69675.307396.90 78465.71 71068.815975.52 78465.71 72490.184525.72 78465.71 73939.993046.92 78465.71 75418.791538.54 78465.71 76927.16

Se desea cancelar una deuda de $900000 en pagos mensuales de $R durante 3 años,El primero al final de un mes, y además se efectuaran abonos semestrales extraordinarios de una y media veces la cuota ordinaria, el primero de estos al final de 6 meses. Suponiendo una tasa del 36% CM. ¿Cuál debe ser el valor de las cuotas ordinarias y el de las cuotas extraordinarias?.Respuestas: $33463.38 $50195.07

n semestral 6.00n mensual 36.00

Tasa efectiva mensual 0.03Tasa efectiva semestral 0.19

Periodo Deuda Intereses Cuota0.00 900000.00 0.00 0.001.00 893536.62 27000.00 33463.382.00 886879.33 26806.10 33463.383.00 880022.33 26606.38 33463.384.00 872959.62 26400.67 33463.385.00 865685.03 26188.79 33463.386.00 807997.12 25970.55 83658.457.00 798773.66 24239.91 33463.388.00 789273.48 23963.21 33463.389.00 779488.31 23678.20 33463.38

10.00 769409.57 23384.65 33463.3811.00 759028.48 23082.29 33463.3812.00 698140.88 22770.85 83658.4513.00 685621.72 20944.23 33463.3814.00 672726.99 20568.65 33463.3815.00 659445.42 20181.81 33463.3816.00 645765.40 19783.36 33463.3817.00 631674.98 19372.96 33463.3818.00 566966.77 18950.25 83658.4519.00 550512.40 17009.00 33463.3820.00 533564.39 16515.37 33463.3821.00 516107.93 16006.93 33463.3822.00 498127.79 15483.24 33463.3823.00 479608.24 14943.83 33463.3824.00 410338.04 14388.25 83658.4525.00 389184.79 12310.14 33463.3826.00 367396.96 11675.54 33463.3827.00 344955.48 11021.91 33463.3828.00 321840.77 10348.66 33463.3829.00 298032.61 9655.22 33463.3830.00 223315.13 8940.98 83658.4531.00 196551.20 6699.45 33463.3832.00 168984.36 5896.54 33463.38

33.00 140590.50 5069.53 33463.3834.00 111344.84 4217.72 33463.3835.00 81221.80 3340.35 33463.3836.00 0.00 2436.65 83658.45

Amortización0.00

6463.386657.286857.007062.717274.59

57687.909223.479500.179785.18

10078.7310381.0960887.6012519.1612894.7313281.5713680.0214090.4264708.2116454.3816948.0117456.4517980.1418519.5569270.2121153.2421787.8422441.4723114.7223808.1674717.4826763.9327566.85

28393.8529245.6730123.0481221.80

Periodo 0 1 2

Ingresos 3000000.00 3900000.00

EgresosCostos Produccion 800000.00 1000000.00

Depreciación 2000000.00 2000000.00

Base de impuestos 200000.00 900000.00

Impuestos 76000.00 342000.00

Utilidad Neta 2124000.00 2558000.00

Inversiones 6000000.00

Flujo de caja neto -6000000.00 2124000.00 2558000.00

VPN Calculada -385288.05No se debe realizar

VNA Excel -385288.05

3 4 5

5070000.00 6591000.00 8568300.00 Tasa impositiva 0.38

1200000.00 1400000.00 1600000.00 TIO 0.4

2000000.00

1870000.00 5191000.00 6968300.00

710600.00 1972580.00 2647954.00

3159400.00 3218420.00 4320346.00

3159400.00 3218420.00 4320346.00

Con préstamoEstado de Resultados

Año 0.00 1.00 2.00 3.00

Ingresos 0.00 7000000.00 7000000.00 7000000.00

Egresos 0.00 1000000.00 1000000.00 1000000.00

Depreciación 0.00 2666666.67 2666666.67 2666666.67

Utilidad bruta 0.00 3333333.33 3333333.33 3333333.33

Gastos Operacionales 0.00 0.00 0.00 0.00

Utilidad Operacional 0 3333333.33 3333333.33 3333333.33

Gastos financieros 0.00 600000.00 435164.84 237362.64

Utilidad antes de impuestos 0.00 2733333.33 2898168.50 3095970.70

Impuestos 0.00 956666.67 1014358.97 1083589.74

Utilidad después de Impuestos 0.00 1776666.67 1883809.52 2012380.95

"Menos" Inversión 5000000.00"Menos" Amortización 0.00 824175.82 989010.99 1186813.19

"Mas" Depreciaciones 0.00 2666666.67 2666666.67 2666666.67

Flujo neto de caja -5000000.00 3619157.51 3561465.20 3492234.43

VNP 674866.78TIR 0.51

Tasa impositiva 0.35TIO 0.40

Tasa Interés prestamo 0.20

AmortizaciónPeriodo Deuda Interés

0.00 3000000.00 0.001.00 2175824.18 600000.002.00 1186813.19 435164.843.00 0.00 237362.64

Utilidad antes de impuestos 0.00 2733333.33

"Mas" Intereses 0.00 600000.00

Impuestos 0.00 1166666.67

Flujo de caja libre del proyecto"Mas" Utilidad antes de impuesto 0.00 2733333.33

"Mas" Intereses 0.00 600000.00"Menos" Impuestos 0.00 1166666.67

"Mas" Depreciaciones 0.00 2666666.67"Menos" Inversiones 8000000.00

Flujo de caja libre del proyecto -8000000.00 4833333.33

VNA -320213.80TIR 0.37

Cuota Amortización0.00 0.00

1424175.82 824175.821424175.82 989010.991424175.82 1186813.19

2898168.50 3095970.70

435164.84 237362.64

1166666.67 1166666.67

2898168.50 3095970.70

435164.84 237362.641166666.67 1166666.672666666.67 2666666.67

4833333.33 4833333.33

0.00 1.00 2.00 3.00 4.00 5.00

Ingresos0.00 500000.00 2000000.00 3000000.00 5000000.00 6000000.00

EgresosInversión

Costos 3000000.00 1000000.00 700000.00 500000.00 500000.00 500000.00

Utilidad Neta -500000.00 1300000.00 2500000.00 4500000.00 5500000.00

Flujo neto de caja -3000000.00 -500000.00 1300000.00 2500000.00 4500000.00 5500000.00

TIO 0.30VNA 1579415.72TIR 0.4463

Egresos periodo 0 3384615.38Ingresos periodo 5 18431100.00

TIRM Calculada 0.4035TIRM Excel 0.4035

Amortización Deuda

Periodo 0.00 1.00Deuda 3000000.00 2515112.33

Intereses 0.00 900000.00Cuota 0.00 1384887.67

Amortización 0.00 484887.67Tasa préstamo 0.30

Tasa impositiva 0.35

Año 0.00 1.00

Ingresos 0.00 15000000.00

Egresos Materia Prima 0.00 6000000.00

Depreciaciones y salvamentosMáquina 1080000.00

Salvamento Máquina

Equipos de oficina 352000.00Salvamento Equipos

Depreciación total 1432000.00

Utilidad bruta 0.00 7568000.00

Gastos Operacionales 0.00 2800000.00Utilidad Operacional 0.00 4768000.00

Gastos financieros 0.00 900000.00Utilidad antes de impuestos 0.00 3868000.00

Impuestos 0.00 1353800.00

Utilidad después de Impuestos 0.00 2514200.00

"Menos" Inversión 5000000.00"Menos" Amortización 0.00 484887.67"Mas" Depreciaciones 0.00 1432000.00

Flujo neto de caja -5000000.00 3461312.33

VNP 0.03TIR 0.30000000

2.00 3.00 4.001884758.36 1065298.21 0.00754533.70 565427.51 319589.46

1384887.67 1384887.67 1384887.67630353.97 819460.16 1065298.21

2.00 3.00 4.00 5.00

13689446.66 12493396.66 11401845.81 10405664.01

5994000.00 5988006.00 5982017.99 5976035.98

1080000.00 1080000.00 1080000.00 1080000.00600000.00

352000.00 352000.00 352000.00 352000.00240000.00

1432000.00 1432000.00 1432000.00 1432000.00

6263446.66 5073390.66 3987827.82 2997628.03

3128000.00 3494480.00 3903960.80 4361495.053135446.66 1578910.66 83867.02 -523867.02

754533.70 565427.51 319589.46 0.002380912.96 1013483.15 -235722.44 -523867.02

833319.54 354719.10 -82502.86 -183353.46

1547593.42 658764.05 -153219.59 -340513.56

630353.97 819460.16 1065298.21 0.001432000.00 1432000.00 1432000.00 1432000.00

2349239.46 1271303.89 213482.21 1091486.44

Ingresos...Egresos

Periodo 0 1 2Producción 0.00 20000.00 18000.00

Precio Unidad 0.00 750.00 760.52Costos Unitario M.P. 0.00 300.00 333.00Nómina Producción 0.00 2000000.00 2240000.00

Nómina Administrativo 0.00 800000.00 888000.00Ingresos 0.00 15000000.00 13689446.66

Esgresos Materia Prima 0.00 6000000.00 5994000.00

Tasa venta 0.01403

VPN 0.03TIR 0.300000005

3 4 516200.00 14580.00 13122.00

771.20 782.02 792.99369.63 410.29 455.42

2508800.00 2809856.00 3147038.72985680.00 1094104.80 1214456.33

12493396.66 11401845.81 10405664.015988006.00 5982017.99 5976035.98

Año 0 1

Ingresos 0.00 20000000.00

Egresos Materia Prima 0.00 9000000.00

Depreciaciones y salvamentosAutomotores 0.00 7000000.00

Valor de recuperación

Utilidad bruta 0.00 4000000.00

Gastos Operacionales 0.00 0.00Utilidad Operacional 0.00 4000000.00

Gastos financieros 0.00 2747074.15Utilidad antes de impuestos 0.00 1252925.85

Impuestos 0.00 438524.05

Utilidad después de Impuestos 0.00 814401.80

"Menos" Inversión 40000000.00Capital de trabajo 20000000.00

"Menos" Amortización 0.00 0.00"Mas" Depreciaciones 0.00 7000000.00

"Más" recuperación capital TraFlujo neto de caja -40000000.00 -12185598.20

VNP -7734650.72TIR 0.08

Año 0 1

Ingresos 0.00 20000000.00

Egresos Materia Prima 0.00 9000000.00

Depreciaciones y salvamentosAutomotores 0.00 7000000.00

Valor de recuperación

Utilidad bruta 0.00 4000000.00

Gastos Operacionales 0.00 0.00Utilidad Operacional 0.00 4000000.00

Gastos financieros 0.00 0.00Utilidad antes de impuestos 0.00 4000000.00

Impuestos 0.00 1400000.00

Utilidad después de Impuestos 0.00 2600000.00

"Menos" Inversión 50000000.00"Menos" Capital de trabajo 20000000.00

"Menos" Amortización 0.00 0.00"Mas" Depreciaciones 0.00 7000000.00

"Más" recuperación capital TraFlujo neto de caja -50000000.00 -10400000.00

VNP -3281042.32TIR 0.10

Tasa impositiva 0.35TIO 0.12

2 3 4

21600000.00 34992000.00 37791360.00

9630000.00 13805100.00 14810283.00

7000000.00 7000000.00 7000000.00

4970000.00 14186900.00 15981077.00

0.00 0.00 0.004970000.00 14186900.00 15981077.00

3501715.79 2915245.43 2167667.321468284.21 11271654.57 13813409.68

513899.48 3945079.10 4834693.39

954384.74 7326575.47 8978716.29

5000000.00 5000000.00 5000000.002134890.88 2721361.23 3468939.347000000.00 7000000.00 7000000.00

819493.86 6605214.24 7509776.95

Tasa impositiva 0.35TIO 0.12

2 3 4

21600000.00 34992000.00 37791360.00

9630000.00 13805100.00 14810283.00

7000000.00 7000000.00 7000000.00

4970000.00 14186900.00 15981077.00

0.00 0.00 0.004970000.00 14186900.00 15981077.00

0.00 0.00 0.004970000.00 14186900.00 15981077.00

1739500.00 4965415.00 5593376.95

3230500.00 9221485.00 10387700.05

5000000.00 5000000.00 5000000.000.00 0.00 0.00

7000000.00 7000000.00 7000000.00

5230500.00 11221485.00 12387700.05

5

40814668.80

15890919.39

7000000.0015000000.00

17923749.41

0.0032923749.41

1214723.9631709025.45

11098158.91

20610866.54

5000000.004421882.707000000.00

40000000.0058188983.84

5

40814668.80

15890919.39

7000000.0015000000.00

17923749.41

0.0032923749.41

0.0032923749.41

11523312.29

21400437.12

5000000.000.00

7000000.0040000000.0063400437.12

Periodo 0Deuda 10000000.00

Intereses 0.00Cuota 0.00

Amortización 0.00Tasa N.T.A préstamo 0.20Tasa E.T.A préstamo 0.05Tasa E.A.A préstamo 0.21550625

Tasa E.A préstamo i=ia/(1-ia) 0.274707414813694

Amortización Deuda

Periodo de Gracia1 2 3 4

12747074.15 10612183.27 7890822.04 4421882.702747074.15 3501715.79 2915245.43 2167667.32

0.00 5636606.66 5636606.66 5636606.660.00 2134890.88 2721361.23 3468939.34

5 Periodo 00.00 Cantidad 0.00

1214723.96 Precio por unidad 0.005636606.66 Costo unitario 0.004421882.70 Ingresos por Producción 0.00

Costo fijo 0.00Egresos por producción 0.00

Ingresos- Egresos

1 2 320000.00 20000.00 30000.001000.00 1080.00 1166.40300.00 324.00 349.92

20000000.00 21600000.00 34992000.003000000.00 3150000.00 3307500.009000000.00 9630000.00 13805100.00

4 530000.00 30000.001259.71 1360.49377.91 408.15

37791360.00 40814668.803472875.00 3646518.75

14810283.00 15890919.39