10
EJERCICIO No. 3 Inversion Socail Adicional a un Proyecto minero Flujo economico resumido Vida de mina 15 Caso inversion inicial Original ITEM CONCEPTO Unidad Val. UnitTOTAL -2 21 Ingreso por ventas 19462.38 22 Regalias /3%) (%Ing.Vtas) 3% -583.87 23 Gastos comerciales US$/TM-Conc 13 -271.72 28 Costos total de operación -6645.45 29 Deprec. Y amortización -5492.00 30 Utildad antes Part. Laboral 6741.06 31 Participacion laboral %UAPL 8% -539.28 32 Utilidad antes de Imp. Renta 6201.77 33 Impuesto a la renta (30%) %UAIR 30% -1860.53 34 Utilidad neta 4341.24 36 Deprec. Amort. Inversión Inicial 4350.00 37 Deprec. Amort. Reinversion 1142.00 38 Inversion Inicial (40% y 60%) -4350.00 -1740.00 39 Reinversión operativa -1142.00 40 Fondos netos disponibles 4341.24 -1740.00 41 Fondos netos acumulados -1740.00 42 VAN - 10% Mill.US$ S/. 458.95 43 TIRE (%) 12.49%

Administracion de costos

Embed Size (px)

DESCRIPTION

planeamiento de costos

Citation preview

EJERCICIO No. 3Inversion Socail Adicional a un Proyecto mineroFlujo economico resumido

Vida de mina 15Caso inversion inicial OriginalITEM CONCEPTO Unidad Val. UnitTOTAL -2

21 Ingreso por ventas 19462.3822 Regalias /3%) (%Ing.Vtas) 3% -583.8723 Gastos comerciales US$/TM-Conc 13 -271.7228 Costos total de operación -6645.4529 Deprec. Y amortización -5492.0030 Utildad antes Part. Laboral 6741.0631 Participacion laboral %UAPL 8% -539.2832 Utilidad antes de Imp. Renta 6201.7733 Impuesto a la renta (30%) %UAIR 30% -1860.5334 Utilidad neta 4341.2436 Deprec. Amort. Inversión Inicial 4350.0037 Deprec. Amort. Reinversion 1142.0038 Inversion Inicial (40% y 60%) -4350.00 -1740.0039 Reinversión operativa -1142.0040 Fondos netos disponibles 4341.24 -1740.0041 Fondos netos acumulados -1740.0042 VAN - 10% Mill.US$ S/. 458.9543 TIRE (%) 12.49%

-1 1 2 3 4 5 6 7 81621.90 1575.50 1529.20 1482.80 1436.50 1390.20 1343.80 1297.50

-48.66 -47.27 -45.88 -44.48 -43.10 -41.71 -40.31 -38.93-22.64 -22.00 -21.35 -20.70 -20.06 -19.41 -18.76 -18.11

-491.10 -484.24 -477.37 -470.50 -463.63 -456.77 -449.90 -443.03-870.00 -905.00 -905.00 -905.00 -905.00 -450.00 -30.00 -30.00212.14 139.00 100.95 62.82 24.78 441.72 823.59 785.55-16.97 -11.12 -8.08 -5.03 -1.98 -35.34 -65.89 -62.84

195.172 127.875 92.878 57.791 22.793 406.386 757.699 722.701-58.55 -38.36 -27.86 -17.34 -6.84 -121.92 -227.31 -216.81136.62 89.51 65.01 40.45 15.96 284.47 530.39 505.89870.00 870.00 870.00 870.00 870.00

35.00 35.00 35.00 35.00 450.00 30.00 30.00-2610.00

-35.00 -35.00 -35.00 -35.00 -450.00 -30.00 -30.00 -30.00-2610.00 971.62 959.51 935.01 910.45 470.96 704.47 530.39 505.89-4350.00 -3378.38 -2418.87 -1483.85 -573.40 -102.44 602.03 1132.42 1638.31

9 10 11 12 13 14 151251.20 1204.80 1158.50 1112.10 1065.80 1019.50 973.10

-37.54 -36.14 -34.76 -33.36 -31.97 -30.59 -29.19-17.47 -16.82 -16.17 -15.53 -14.88 -14.23 -13.59

-436.16 -429.29 -422.43 -415.56 -408.69 -401.82 -394.96-30.00 -30.00 -320.00 -28.00 -28.00 -28.00 -28.00747.50 709.37 381.32 635.18 597.14 559.10 520.95-59.80 -56.75 -30.51 -50.81 -47.77 -44.73 -41.68

687.704 652.617 350.810 584.363 549.365 514.367 479.271-206.31 -195.79 -105.24 -175.31 -164.81 -154.31 -143.78481.39 456.83 245.57 409.05 384.56 360.06 335.49

30.00 30.00 320.00 28.00 28.00 28.00 28.00

-30.00 -320.00 -28.00 -28.00 -28.00 -28.00 0.00481.39 166.83 537.57 409.05 384.56 360.06 363.49

2119.70 2286.53 2824.10 3233.15 3617.71 3977.76 4341.25

PROBLEMA N° 03INVERSION SOCIAL ADICIONAL A UN PROYECTO MINEROFLUJO ECONOMICO RESUMIDO

CASO DE INVERSION INICIAL ORIGINALITEM CONCEPTO Unidad Val. UTOTAL -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 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 (II + 350 M$) -4350.00 -100.00 -350.00 -1740.0 -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

40 Fondos netos disponibles 4341.24 -100.00 -350.00 -1740.0 -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 -100.00 -350.00 -1740.0 -4800.0 -3828.38 -2868.87 -1933.85 -1023.40 -552.44 152.03 682.42 1188.31 1669.70 1836.53 2374.10

42 VAN - 10% Mill.US$ S/. -0.87

43 TIRE (%) 9%

1621.90 1575.50 1529.20 1482.80 1436.50 1390.20 1343.80 1297.50 1251.20 1204.80 1158.50

CASO DE INVERSION SOCIAL ADICIONAL 150 1771.9 1725.5 1679.2 1632.8 1586.5 1540.2 1493.8 1447.5 1401.2 1354.8 1308.5

ITEM CONCEPTO Unidad Val. UnTOTAL -2 -1 1 2 3 4 5 6 7 8 9 10 11

21 Ingreso por ventas 21712.40 1771.90 1725.50 1679.20 1632.80 1586.50 1540.20 1493.80 1447.50 1401.20 1354.80 1308.50

22 Regalias /3%) (%Ing.Vtas) 3% -651.37 -53.16 -51.77 -50.38 -48.98 -47.60 -46.21 -44.81 -43.43 -42.04 -40.64 -39.26

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 8923.58 357.64 284.50 246.45 208.32 170.28 587.22 969.09 931.05 893.00 854.87 526.82

31 Participacion laboral %UAPL 8% -713.89 -28.61 -22.76 -19.72 -16.67 -13.62 -46.98 -77.53 -74.48 -71.44 -68.39 -42.15

32 Utilidad antes de Imp. Renta 8209.69 329.032 261.735 226.738 191.651 156.653 540.246 891.559 856.561 821.564 786.477 484.670

33 Impuesto a la renta (30%) %UAIR 30% -2462.91 -98.71 -78.52 -68.02 -57.50 -47.00 -162.07 -267.47 -256.97 -246.47 -235.94 -145.40

34 Utilidad neta 5746.78 230.32 183.21 158.72 134.16 109.66 378.17 624.09 599.59 575.09 550.53 339.27

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 (II + 350 M$) -4800.00 -100.00 -350.00 -1740.0 -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

40 Fondos netos disponibles 4341.24 -100.00 -350.00 -1740.0 -2610.00 1065.32 1053.21 1028.72 1004.16 564.66 798.17 624.09 599.59 575.09 260.53 631.27

41 Fondos netos acumulados -100.00 -350.00 -1740.0 -4800.0 -3734.68 -2681.46 -1652.75 -648.59 -83.93 714.24 1338.33 1937.92 2513.02 2773.55 3404.82

42 VAN - 10% Mill.US$ S/. 485.92

43 TIRE (%) 12.64%FLUJOS DE CADA AÑO

FNA 1065.32 1053.21 1028.72 1004.16 564.66 798.17 624.09 599.59 575.09 260.53 631.27 502.76

FND -3734.7 -2681 -1652.75 -648.59 -83.93 714.24 1338.33 1937.92 2513.02 2773.55 3404.82 3907.58

12 13 14 15

1112.10 1065.80 1019.50 973.10

-33.36 -31.97 -30.59 -29.19

-15.53 -14.88 -14.23 -13.59

-415.56 -408.69 -401.82 -394.96

-28.00 -28.00 -28.00 -28.00

635.18 597.14 559.10 520.95

-50.81 -47.77 -44.73 -41.68

584.363 549.365 514.367 479.271

-175.31 -164.81 -154.31 -143.78

409.05 384.56 360.06 335.49

28.00 28.00 28.00 28.00

-28.00 -28.00 -28.00 0.00

409.05 384.56 360.06 363.49

2783.15 3167.71 3527.76 3891.25

1112.10 1065.80 1019.50 973.10

1262.1 1215.8 1169.5 1123.1

12 13 14 15

1262.10 1215.80 1169.50 1123.10

-37.86 -36.47 -35.09 -33.69

-15.53 -14.88 -14.23 -13.59

-415.56 -408.69 -401.82 -394.96

-28.00 -28.00 -28.00 -28.00

780.68 742.64 704.60 666.45

-62.45 -59.41 -56.37 -53.32

718.223 683.225 648.227 613.131

-215.47 -204.97 -194.47 -183.94

502.76 478.26 453.76 429.19

28.00 28.00 28.00 28.00

-28.00 -28.00 -28.00 0.00

502.76 478.26 453.76 457.19

3907.58 4385.83 4839.59 5296.78

478.26 453.76 457.19

4385.83 4839.59 5296.78

Caso inversion Social Adicional

ITEM CONCEPTO Unidad Val. UnitTOTAL21 Ingreso por ventas 21712.4022 Regalias /3%) (%Ing.Vtas) 3% -651.3723 Gastos comerciales US$/TM-Conc 13 -271.7228 Costos total de operación -6645.4529 Deprec. Y amortización -5492.0030 Utildad antes Part. Laboral 8923.5831 Participacion laboral %UAPL 8% -713.8932 Utilidad antes de Imp. Renta 8209.6933 Impuesto a la renta (30%) %UAIR 30% -2462.9134 Utilidad neta 5746.7836 Deprec. Amort. Inversión Inicial 4350.0037 Deprec. Amort. Reinversion 1142.0038 Inversion Inicial (II + 350 M$) -4800.00 -100.0039 Reinversión operativa -1142.0040 Fondos netos disponibles 4341.24 -100.0041 Fondos netos acumulados -100.0042 VAN - 10% Mill.US$ S/. 485.9243 TIRE (%) 12.64%

1621.90 1575.50 1529.20 1482.80 1436.50 1390.20

150 1771.9 1725.5 1679.2 1632.8 1586.5 1540.2

-2 -1 1 2 3 4 5 61771.90 1725.50 1679.20 1632.80 1586.50 1540.20

-53.16 -51.77 -50.38 -48.98 -47.60 -46.21-22.64 -22.00 -21.35 -20.70 -20.06 -19.41

-491.10 -484.24 -477.37 -470.50 -463.63 -456.77-870.00 -905.00 -905.00 -905.00 -905.00 -450.00357.64 284.50 246.45 208.32 170.28 587.22-28.61 -22.76 -19.72 -16.67 -13.62 -46.98

329.032 261.735 226.738 191.651 156.653 540.246-98.71 -78.52 -68.02 -57.50 -47.00 -162.07230.32 183.21 158.72 134.16 109.66 378.17870.00 870.00 870.00 870.00 870.00

35.00 35.00 35.00 35.00 450.00-350.00 -1740.00 -2610.00

-35.00 -35.00 -35.00 -35.00 -450.00 -30.00-350.00 -1740.00 -2610.00 1065.32 1053.21 1028.72 1004.16 564.66 798.17-350.00 -1740.00 -4800.00 -3734.68 -2681.46 -1652.75 -648.59 -83.93 714.24

1343.80 1297.50 1251.20 1204.80 1158.50 1112.10 1065.80 1019.50 973.10

1493.8 1447.5 1401.2 1354.8 1308.5 1262.1 1215.8 1169.5 1123.1

7 8 9 10 11 12 13 14 151493.80 1447.50 1401.20 1354.80 1308.50 1262.10 1215.80 1169.50 1123.10

-44.81 -43.43 -42.04 -40.64 -39.26 -37.86 -36.47 -35.09 -33.69-18.76 -18.11 -17.47 -16.82 -16.17 -15.53 -14.88 -14.23 -13.59

-449.90 -443.03 -436.16 -429.29 -422.43 -415.56 -408.69 -401.82 -394.96-30.00 -30.00 -30.00 -30.00 -320.00 -28.00 -28.00 -28.00 -28.00969.09 931.05 893.00 854.87 526.82 780.68 742.64 704.60 666.45-77.53 -74.48 -71.44 -68.39 -42.15 -62.45 -59.41 -56.37 -53.32

891.559 856.561 821.564 786.477 484.670 718.223 683.225 648.227 613.131-267.47 -256.97 -246.47 -235.94 -145.40 -215.47 -204.97 -194.47 -183.94624.09 599.59 575.09 550.53 339.27 502.76 478.26 453.76 429.19

30.00 30.00 30.00 30.00 320.00 28.00 28.00 28.00 28.00

-30.00 -30.00 -30.00 -320.00 -28.00 -28.00 -28.00 -28.00 0.00624.09 599.59 575.09 260.53 631.27 502.76 478.26 453.76 457.19

1338.33 1937.92 2513.02 2773.55 3404.82 3907.58 4385.83 4839.59 5296.78