10
EJERCICIO No. 3 0.02 0.02 0.02 0.03 0.03 0.03 0.04 0.04 0.05 Inversion Socail Adicional a un Proyecto minero 1297.492 0.35 0.37 0.40 0.42 0.45 0.48 0.52 0.56 0.60 0.65 Flujo economico resumido 12.00 12.35 12.73 13.13 13.55 14.00 14.48 15.00 15.55 16.15 16.80 Vida de mina 15 40 60 17840.5 17886.9 17933.2 17979.6 18025.9 18072.2 18118.6 18164.9 18211.2 18257.6 18303.9 Caso inversion inicial Original ITEM CONCEPTO Unidad Val. Un TOTAL -2 -1 1 2 3 4 5 6 7 8 9 10 11 21 Ingreso por ventas 19462.38 1621.90 1575.50 1529.20 1482.80 1436.50 1390.20 1343.80 1297.50 1251.20 1204.80 1158.50 22 Regalias /3%) (%Ing.Vtas) 3% -583.87 -48.66 -47.27 -45.88 -44.48 -43.10 -41.71 -40.31 -38.93 -37.54 -36.14 -34.76 23 Gastos comerciales US$/TM-Conc 13 -271.72 -22.64 -22.00 -21.35 -20.70 -20.06 -19.41 -18.76 -18.11 -17.47 -16.82 -16.17 28 Costos total de operación -6645.45 -491.10 -484.24 -477.37 -470.50 -463.63 -456.77 -449.90 -443.03 -436.16 -429.29 -422.43 29 Deprec. Y amortización -5492.00 -870.00 -905.00 -905.00 -905.00 -905.00 -450.00 -30.00 -30.00 -30.00 -30.00 -320.00 30 Utildad antes Part. Laboral 6741.06 212.14 139.00 100.95 62.82 24.78 441.72 823.59 785.55 747.50 709.37 381.32 31 Participacion laboral %UAPL 8% -539.28 -16.97 -11.12 -8.08 -5.03 -1.98 -35.34 -65.89 -62.84 -59.80 -56.75 -30.51 32 Utilidad antes de Imp. Renta 6201.77 195.172 127.875 92.878 57.791 22.793 406.386 757.699 722.701 687.704 652.617 350.810 33 Impuesto a la renta (30%) %UAIR 30% -1860.53 -58.55 -38.36 -27.86 -17.34 -6.84 -121.92 -227.31 -216.81 -206.31 -195.79 -105.24 34 Utilidad neta 4341.24 -4350.00 136.62 89.51 65.01 40.45 15.96 284.47 530.39 505.89 481.39 456.83 245.57 36 Deprec. Amort. Inversión Inicial 4350.00 870.00 870.00 870.00 870.00 870.00 37 Deprec. Amort. Reinversion 1142.00 35.00 35.00 35.00 35.00 450.00 30.00 30.00 30.00 30.00 320.00 38 Inversion Inicial (40% y 60%) -4350.00 -1740.00 -2610.00 39 Reinversión operativa -1142.00 -35.00 -35.00 -35.00 -35.00 -450.00 -30.00 -30.00 -30.00 -30.00 -320.00 -28.00 40 Fondos netos disponibles 4341.24 -1740.00 -2610.00 971.62 959.51 935.01 910.45 470.96 704.47 530.39 505.89 481.39 166.83 537.57 41 Fondos netos acumulados -1740.00 -4350.00 -3378.38 -2418.87 -1483.85 -573.40 -102.44 602.03 1132.42 1638.31 2119.70 2286.53 2824.10 42 VAN - 10% Mill.US$ 0.1 S/. 663.03 43 TIRE (%) 13%

3333333 (1)

Embed Size (px)

DESCRIPTION

ejercicio

Citation preview

Page 1: 3333333 (1)

EJERCICIO No. 3 0.02 0.02 0.02 0.03 0.03 0.03 0.04 0.04 0.05 0.06 0.06 0.07 0.08Inversion Socail Adicional a un Proyecto minero 1297.492 0.35 0.37 0.40 0.42 0.45 0.48 0.52 0.56 0.60 0.65 0.70 0.76 0.83 0.91Flujo economico resumido 12.00 12.35 12.73 13.13 13.55 14.00 14.48 15.00 15.55 16.15 16.80 17.50 18.26 19.09 20.00

Vida de mina 15 40 60 17840.5 17886.9 17933.2 17979.6 18025.9 18072.2 18118.6 18164.9 18211.2 18257.6 18303.9 18350.3 18396.6 18442.9 18489.3Caso inversion inicial OriginalITEM CONCEPTO Unidad Val. UnitTOTAL -2 -1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

21 Ingreso por ventas 19462.38 1621.90 1575.50 1529.20 1482.80 1436.50 1390.20 1343.80 1297.50 1251.20 1204.80 1158.50 1112.10 1065.80 1019.50 973.1022 Regalias /3%) (%Ing.Vtas) 3% -583.87 -48.66 -47.27 -45.88 -44.48 -43.10 -41.71 -40.31 -38.93 -37.54 -36.14 -34.75 -33.36 -31.97 -30.58 -29.1923 Gastos comerciales US$/TM-Conc 13 -271.72 -22.64 -22.00 -21.35 -20.70 -20.06 -19.41 -18.76 -18.11 -17.47 -16.82 -16.17 -15.53 -14.88 -14.23 -13.5928 Costos total de operación -6645.45 -491.10 -484.24 -477.37 -470.50 -463.63 -456.77 -449.90 -443.03 -436.16 -429.29 -422.43 -415.56 -408.69 -401.82 -394.9629 Deprec. Y amortización -5492.00 -870.00 -905.00 -905.00 -905.00 -905.00 -450.00 -30.00 -30.00 -30.00 -30.00 -320.00 -28.00 -28.00 -28.00 -28.0030 Utildad antes Part. Laboral 6741.06 212.14 138.99 100.95 62.82 24.77 441.72 823.59 785.55 747.50 709.37 381.31 635.18 597.14 559.10 520.9531 Participacion laboral %UAPL 8% -539.28 -16.97 -11.12 -8.08 -5.03 -1.98 -35.34 -65.89 -62.84 -59.80 -56.75 -30.51 -50.81 -47.77 -44.73 -41.6832 Utilidad antes de Imp. Renta 6201.77 195.172 127.875 92.878 57.791 22.793 406.386 757.699 722.701 687.704 652.617 350.810 584.363 549.365 514.367 479.27133 Impuesto a la renta (30%) %UAIR 30% -1860.53 -58.55 -38.36 -27.86 -17.34 -6.84 -121.92 -227.31 -216.81 -206.31 -195.79 -105.24 -175.31 -164.81 -154.31 -143.7834 Utilidad neta 4341.24 -4350.00 136.62 89.51 65.01 40.45 15.96 284.47 530.39 505.89 481.39 456.83 245.57 409.05 384.56 360.06 335.4936 Deprec. Amort. Inversión Inicial 4350.00 870.00 870.00 870.00 870.00 870.0037 Deprec. Amort. Reinversion 1142.00 35.00 35.00 35.00 35.00 450.00 30.00 30.00 30.00 30.00 320.00 28.00 28.00 28.00 28.0038 Inversion Inicial (40% y 60%) -4350.00 -1740.00 -2610.0039 Reinversión operativa -1142.00 -35.00 -35.00 -35.00 -35.00 -450.00 -30.00 -30.00 -30.00 -30.00 -320.00 -28.00 -28.00 -28.00 -28.00 0.0040 Fondos netos disponibles 4341.24 -1740.00 -2610.00 971.62 959.51 935.01 910.45 470.96 704.47 530.39 505.89 481.39 166.83 537.57 409.05 384.56 360.06 363.4941 Fondos netos acumulados -1740.00 -4350.00 -3378.38 -2418.87 -1483.85 -573.40 -102.44 602.03 1132.42 1638.31 2119.70 2286.53 2824.10 3233.15 3617.71 3977.76 4341.2542 VAN - 10% Mill.US$ 0.1 S/. 663.0343 TIRE (%) 13%

Page 2: 3333333 (1)

19462.4-583.872

-271.72-6645.45

-54926741.08 VAR-539.29 max 1621.90 324.416201.79 Promedio 1297.49

-1860.54 min 973.10 324.394341.25 VAR4350.001142.00

0.00 1390.17-1142.008691.25

17816.01

Page 3: 3333333 (1)

EJERCICIO No. 3 0.02 0.02 0.02 0.03 0.03 0.03 0.04 0.04 0.05 0.06 0.06 0.07Inversion Socail Adicional a un Proyecto minero 1297.492 0.35 0.37 0.40 0.42 0.45 0.48 0.52 0.56 0.60 0.65 0.70 0.76 0.83Flujo economico resumido 12.00 12.35 12.73 13.13 13.55 14.00 14.48 15.00 15.55 16.15 16.80 17.50 18.26 19.09

Vida de mina 15 40 60 17840.5 17886.9 17933.2 17979.6 18025.9 18072.2 18118.6 18164.9 18211.2 18257.6 18303.9 18350.3 18396.6 18442.9Caso inversion inicial Original 2010ITEM CONCEPTO Unidad Val. Unit TOTAL -4 -3 -2 -1 1 2 3 4 5 6 7 8 9 10 11 12 13 14

21 Ingreso por ventas 19462.38 1621.90 1575.50 1529.20 1482.80 1436.50 1390.20 1343.80 1297.50 1251.20 1204.80 1158.50 1112.10 1065.80 1019.5022 Regalias /3%) (%Ing.Vtas) 3% -583.87 -48.66 -47.27 -45.88 -44.48 -43.10 -41.71 -40.31 -38.93 -37.54 -36.14 -34.75 -33.36 -31.97 -30.5823 Gastos comerciales US$/TM-Conc 13 -271.72 -22.64 -22.00 -21.35 -20.70 -20.06 -19.41 -18.76 -18.11 -17.47 -16.82 -16.17 -15.53 -14.88 -14.2328 Costos total de operación -6645.45 -491.10 -484.24 -477.37 -470.50 -463.63 -456.77 -449.90 -443.03 -436.16 -429.29 -422.43 -415.56 -408.69 -401.8229 Deprec. Y amortización -5492.00 -870.00 -905.00 -905.00 -905.00 -905.00 -450.00 -30.00 -30.00 -30.00 -30.00 -320.00 -28.00 -28.00 -28.0030 Utildad antes Part. Laboral 6741.06 212.14 138.99 100.95 62.82 24.77 441.72 823.59 785.55 747.50 709.37 381.31 635.18 597.14 559.1031 Participacion laboral %UAPL 8% -539.28 -16.97 -11.12 -8.08 -5.03 -1.98 -35.34 -65.89 -62.84 -59.80 -56.75 -30.51 -50.81 -47.77 -44.7332 Utilidad antes de Imp. Renta 6201.77 195.172 127.875 92.878 57.791 22.793 406.386 757.699 722.701 687.704 652.617 350.810 584.363 549.365 514.36733 Impuesto a la renta (30%) %UAIR 30% -1860.53 -58.55 -38.36 -27.86 -17.34 -6.84 -121.92 -227.31 -216.81 -206.31 -195.79 -105.24 -175.31 -164.81 -154.3134 Utilidad neta 4341.24 136.62 89.51 65.01 40.45 15.96 284.47 530.39 505.89 481.39 456.83 245.57 409.05 384.56 360.0636 Deprec. Amort. Inversión Inicial 4350.00 870.00 870.00 870.00 870.00 870.0037 Deprec. Amort. Reinversion 1142.00 35.00 35.00 35.00 35.00 450.00 30.00 30.00 30.00 30.00 320.00 28.00 28.00 28.0038 Inversion Inicial (40% y 60%) -450.00 -4350.00 -100.00 -350.00 -1740.00 -2610.0039 Reinversión operativa -1142.00 -35.00 -35.00 -35.00 -35.00 -450.00 -30.00 -30.00 -30.00 -30.00 -320.00 -28.00 -28.00 -28.00 -28.0040 Fondos netos disponibles 4341.24 -100.00 -350.00 -1740.00 -2610.00 971.62 959.51 935.01 910.45 470.96 704.47 530.39 505.89 481.39 166.83 537.57 409.05 384.56 360.0641 Fondos netos acumulados -1740.00 -4800.00 -3828.38 -2868.87 -1933.85 -1023.40 -552.44 152.03 682.42 1188.31 1669.70 1836.53 2374.10 2783.15 3167.71 3527.7642 VAN - 10% Mill.US$ S/. 458.9543 TIRE (%) 8%

1 2 3 4 5 6 7 8 9 10 11 12 13 140.00

50.00

100.00

150.00

200.00

250.00

300.00

350.00

400.00

450.00

500.00Chart Title

Page 4: 3333333 (1)

0.080.91

20.0018489.3

15973.10-29.19-13.59

-394.96-28.00520.95-41.68

479.271-143.78335.49

28.00

0.00363.49

3891.25

Page 5: 3333333 (1)

19462.4-583.872

-271.72-6645.45

-54926741.08 VAR-539.29 max 1621.90 324.416201.79 Promedio 1297.49

-1860.54 min 973.10 324.394341.25 VAR4350.001142.00

0.00 1390.17-1142.008691.25

11066.01

Page 6: 3333333 (1)

TOTAL -2 -1

66006481.8

1166.40.84%

93%25%

20.255.2395%

5%0.32196

Page 7: 3333333 (1)

1 2 3 4 5 6 7 8

6600 6600 6600 6600 6600 6600 6600 660010.1851852

Page 8: 3333333 (1)

9 10 11 12 13 14 15

6600 6600 6600 6600 6600 6600 6600