pauta_tarea_1.xls

8
Inversión Pesos UF Obras Civiles 1,265,796,900 68,871.88 2,295.73 50 Equipos 279,195,000 15,190.97 1,519.10 50 Terreno 1,395.61 100 3,171.66 158.58 50 Total 88,630.12 3,973.41 Total Ingresos 1 2 3 4 Dólares 804,152 892274.70 900,075.40 913,096.30 Pesos 434,242,080 481,828,338 486,040,716 493,072,002 UF 23,627.07 26,216.23 26,445.42 26,828.00 Costos Fijos Anual en UF Sueldos 13210560 8,625.42 Gastos 40310 1,184.36 Total 9,809.78 Costos Variables 1 2 3 4 Dólares 188,200 188,700 188,700 188,700 Pesos 101,628,000 101,898,000 101,898,000 101,898,000 UF 5,529.57 5,544.26 5,544.26 5,544.26 Dólares Pesos UF 78,600,000 4,276.62 Préstamo 912,600.00 492,804,000 26,813.41 Depreciación por año en UF % Depreciación ra Mensual en Pesos Anual en Dólares Capital de trabajo

Upload: christian-a-zurita-zumaran

Post on 23-Dec-2015

213 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: pauta_tarea_1.xls

Inversión Pesos UFObras Civiles 1,265,796,900 68,871.88 2,295.73 50 34,435.94

Equipos 279,195,000 15,190.97 1,519.10 50 7,595.49Terreno 1,395.61 100 1,395.61

Infraestructura 3,171.66 158.58 50 1,585.83Total 88,630.12 3,973.41 Total 45,012.86

Ingresos 1 2 3 4 5Dólares 804,152 892274.70 900,075.40 913,096.30 920,897.00Pesos 434,242,080 481,828,338 486,040,716 493,072,002 497,284,380

UF 23,627.07 26,216.23 26,445.42 26,828.00 27,057.19

Costos Fijos Anual en UFSueldos 13210560 8,625.42Gastos 40310 1,184.36

Total 9,809.78

1 2 3 4 5Dólares 188,200 188,700 188,700 188,700 188,700Pesos 101,628,000 101,898,000 101,898,000 101,898,000 101,898,000

UF 5,529.57 5,544.26 5,544.26 5,544.26 5,544.26

Dólares Pesos UF

78,600,000 4,276.62Préstamo 912,600.00 492,804,000 26,813.41

Depreciación por año en UF

% Depreciación

Valor de Desecho

Mensual en Pesos

Anual en Dólares

Costos Variables

Capital de trabajo

Page 2: pauta_tarea_1.xls

Valor Libro45,914.58 11,478.65

0 7,595.491,395.61 01,585.83 0

48,896.02 3,883.16

6 7 8 9 10928,697.70 939,078.90 949,519.30 957,320.00 967,701.20

501,496,758 507,102,606 512,740,422 516,952,800 522,558,64827,286.39 27,591.40 27,898.15 28,127.35 28,432.36

6 7 8 9 10188,700 188,700 188,700 188,700 188,700

101,898,000 101,898,000 101,898,000 101,898,000 101,898,0005,544.26 5,544.26 5,544.26 5,544.26 5,544.26

Puntajes

0,5 ptos Formato y Resumen Ejecutivo0,5 ptos Presentación del Problema3,0 ptos Resultados1,0 pto Análisis de Resultados

1 pto Conclusiones

Pérdida de Capital

Page 3: pauta_tarea_1.xls

0 1 2 3 4Ingresos x Ventas 23,627.07 26,216.23 26,445.42 26,828.00Gan./Pérd. CapitalCostos Fijos -9,809.78 -9,809.78 -9,809.78 -9,809.78Costos Variables -5,529.57 -5,544.26 -5,544.26 -5,544.26Depreciaciones Legales -3,973.41 -3,973.41 -3,973.41 -3,973.41Utilidad Antes de Impuesto 4,314.30 6,888.78 7,117.97 7,500.54

Impuestos -733.43 -1171.09 -1210.06 -1275.09Utilidad Después Impuesto 3,580.87 5,717.68 5,907.92 6,225.45Depreciaciones Legales 3,973.41 3,973.41 3,973.41 3,973.41

Gan./Pérd. Capital

Flujo Caja Operacional 7,554.28 9,691.09 9,881.33 10,198.86Inversión Fija -88,630.12Valor Residual de los ActivosCapital de Trabajo -4,276.62

Rec. Capital de Trabajo

Flujo de Capitales -92,906.73 0 0 0 0

Flujo de Caja Privado -92,906.73 7,554.28 9,691.09 9,881.33 10,198.86

Tasa de Descuento 12%

VAN -20,426.79

Page 4: pauta_tarea_1.xls

5 6 7 8 9 1027,057.19 27,286.39 27,591.40 27,898.15 28,127.35 28,432.36

-3,883.16-9,809.78 -9,809.78 -9,809.78 -9,809.78 -9,809.78 -9,809.78-5,544.26 -5,544.26 -5,544.26 -5,544.26 -5,544.26 -5,544.26-3,973.41 -3,973.41 -3,973.41 -3,973.41 -3,973.41 -3,973.417,729.74 7,958.93 8,263.95 8,570.70 8,799.89 5,221.75-1314.06 -1353.02 -1404.87 -1457.02 -1495.98 -887.706,415.68 6,605.91 6,859.08 7,113.68 7,303.91 4,334.053,973.41 3,973.41 3,973.41 3,973.41 3,973.41 3,973.41

3,883.16

10,389.09 10,579.32 10,832.48 11,087.09 11,277.32 12,190.62

45,012.86

4,276.62

0 0 0 0 0 49,289.48

10,389.09 10,579.32 10,832.48 11,087.09 11,277.32 61,480.10

Page 5: pauta_tarea_1.xls

0 1 2 3Ingresos x Ventas 23,627.07 26,216.23 26,445.42Gan./Pérd. CapitalCostos Fijos -9,809.78 -9,809.78 -9,809.78Costos Variables -5,529.57 -5,544.26 -5,544.26Intereses x Créditos -2,600.90 -2,172.33 -1,702.18Depreciaciones Legales -3,973.41 -3,973.41 -3,973.41Utilidad Antes de Impuesto 1,713.40 4,716.45 5,415.79

Impuestos -291.28 -801.80 -920.68Utilidad Después Impuesto 1,422.12 3,914.65 4,495.10Depreciaciones Legales 3,973.41 3,973.41 3,973.41

Gan./Pérd. Capital

Flujo Caja Operacional 5,395.53 7,888.06 8,468.51Inversión Fija -88,630.12Valor Residual de los ActivosCapital de Trabajo -4,276.62Rec. Capital de TrabajoPréstamos 26,813.41

Amortizaciones -4,418.28 -4,846.85 -5,317.00

Flujo de Capitales -66,093.32 -4,418.28 -4,846.85 -5,317.00

Flujo de Caja Privado -66,093.32 977.25 3,041.21 3,151.52

Tasa de Descuento 14%

VAN -23,874.427874696

Page 6: pauta_tarea_1.xls

4 5 6 7 8 9 1026,828.00 27,057.19 27,286.39 27,591.40 27,898.15 28,127.35 28,432.36

-3,883.16-9,809.78 -9,809.78 -9,809.78 -9,809.78 -9,809.78 -9,809.78 -9,809.78-5,544.26 -5,544.26 -5,544.26 -5,544.26 -5,544.26 -5,544.26 -5,544.26-1,186.43 -620.66-3,973.41 -3,973.41 -3,973.41 -3,973.41 -3,973.41 -3,973.41 -3,973.416,314.11 7,109.08 7,958.93 8,263.95 8,570.70 8,799.89 5,221.75

-1,073.40 -1,208.54 -1,353.02 -1,404.87 -1,457.02 -1,495.98 -887.705,240.71 5,900.54 6,605.91 6,859.08 7,113.68 7,303.91 4,334.053,973.41 3,973.41 3,973.41 3,973.41 3,973.41 3,973.41 3,973.41

3,883.16

9,214.12 9,873.95 10,579.32 10,832.48 11,087.09 11,277.32 12,190.62

45,012.86

4,276.62

-5,832.75 -6,398.52

-5,832.75 -6,398.52 0 0 0 0 49,289.48

3,381.37 3,475.42 10,579.32 10,832.48 11,087.09 11,277.32 61,480.10

Page 7: pauta_tarea_1.xls

Período Deuda Cuota Interés Amortización0 26,813.411 26,813.41 7,019.18 -2600.90 -4,418.282 22,395.13 7,019.18 -2172.33 -4,846.853 17,548.28 7,019.18 -1702.18 -5,317.004 12,231.28 7,019.18 -1186.43 -5,832.755 6,398.54 7,019.18 -620.66 -6,398.52