simdef-15_1_simco1-firma10-periodo-4.xls

15

Click here to load reader

Upload: jhon-saavedra-alcantara

Post on 15-Sep-2015

9 views

Category:

Documents


3 download

TRANSCRIPT

EstadoResultados* S I M D E F * CIA. 10E S T A D O D E R E S U L T A D O S T R I M E S T R A LN U M E R O 4INGRESOS VTAS ( 87415. UNIDS A $ 125.00)10,926,860OTROS INGRESOS: VALORES NEGOCIABLES2,650INGRESO TOTAL10,929,510COSTO PROD VENDIDA;INVENTARIO INICIAL ( 41488. A $ 72.43)3,004,964MAT.PRIMA1,500,000M.O. DIRECT3,500,000TOTAL COSTOS DCTOS5,000,000GASTOS ALMACEN393,585DEPRECIACION;MAQUI. Y EQUIP.539,126EDIF1,300,000OTROS GASTS INDIRECTOS200,000TOTAL COSTOS INDIRTS2,432,711COSTOS PRODUCCION 100000. A $ 74.337,432,711PRODS DISPON. PARA VENTAS (A $ 73.77 POR UNID)10,437,680MENOS:INVENTARIO FINAL ( 54073. UNIDS)3,989,017COSTO PRODUC.VEND.6,448,658UTILIDAD BRUTA4,480,847GASTOS DE ADMINISTRACION Y VENTAS1,546,343GASTOS FINANCIEROS;INTERES PREST.CORTO PLAZ;BANCO0PRESTAMISTAS SA.0INTERES PRESTAMO MEDIANO PLAZO48,593INTERES BONOS129,016COSTO REDENCION BONOS0TOTAL CARGOS FINANCIERS177,6091,723,952INGRSO OPERATIVO ANTES DE ITEMS EXTRAORDIN.2,756,896ITEMS EXTTRAORDIN.0INGRESO ANTES IMPTS2,756,896IMPUESTO ( .40 DEL INGRS)1,102,758INGRESO DESP.IMPTS1,654,138DIVIDENDOS ACCS.PREFEREN.0INGRESOS PARA ACCIONTS.COMUNES1,654,138DIVIDENDOS ACCNS.COMUN ( .00 POR ACCN.)0INGRESO NETO TRANSFERIDO A UTILS.RETENIDAS1,654,138

SintesisEjecutiva* S I M D E F *CIA. 10SINTESIS DATOS EJECUTIVOS TRIMESTRE 4INFORMACION HISTORICADATOS SOBRE ACCIONES COMUNES ;PRECIO AL FINAL TRIMEST167.21VALOR ACUM. SIMDEF167.31INGSOS. X ACCION1.84TASA DIVIDENDO0.000RAZON PRECIO INGSOS(BASADO EN INGRSOS TRIM ACTL)22.74PRECIO VENTA O PRECIO MERCDO CUANDO OFERTA0.00DATOS ADICIONALES;PRECIO LIBRE104.00DEMANDA LIBRE111891TASA RET.VAL.NEGS.CTO.PZO0.0132TASAS INT. SALDOS DEUDORESCORTO PZO.0.01912 ANOS PTMO0.03113 ANOS PTMO0.0250BONO0.0193PRESTAMISTA0.0500PRECIO ACCNS PREFERENCI.47.17TASA DIVNDS. PREFERENCIALES0.02120DIVIDENDS.POR ACCNS.PREFER. ACUM.E IMPAGAS AUN0.00RETORNO S. INVERSION0.363RETORNO S.CAPITL0.648PREMIO REDENCIO.ACCNS.PREF.0.08000BONO PREMIO REDEN0.08000DATOS PARA TRIMESTRES FUTUROSTRIMESTRE5678PRONOSTICOS;UNIDADES DEMANDADAS10923180886125311112807PRECIO UNIDADES $102.1794.54107.95100.22SEGUNDO PRONOSTICO. (UNIDADES)PRECIOTERCER PRONOSTICO. (UNIDADES)PRECIOACTUAL;CAPACID.PLANTA (UNIDS)80000500005000025000CAPACID.MAQUINAS (UNIDS)85000850003000030000OTROS GAS. INDTS (DOLAR)200000200000200000200000DEPRECIACION (DOLAR );MAQUINAR.466001466001177251177251PROYS.INV.CAPITAL0000PLANT989000667500667500313750REPAGO PRINCIPAL DE DEUDAS :CORTO PLAZO00002 ANOS3125003125003125003125003 ANOS0000BONOS425250425250425250425250INTERESES VENCEN PXMO TRIMESTRE S.SALDO DEUDOR;CORTO PLZO0PMO.INTERMED38875BONOS120808COSTOS PRODUCCION UNITARIOS PXMO.TRIM.UNIDSHASTA 60000SGTS 40000SGTS 20000MAS 120000COST.M.OBR39.0029.0025.0033.00MATERIALES:TODOS NIVELES DE PRODUCCION15.00MAQUINAR.37.52PLANT256.06GASTOS ALMACENAJ;UNIDSHASTA 2000SGTS 5000MAS 7000COST/UNID1.003.008.00TASAS PARA FONDOS EN TRIMES 8;CORTO PLZO2 ANOS PTMO3 ANOS PTMOBONOACCNS PRF0.01730.01660.01590.01460.0186ALTERNATIVAS DE INVERSION DE CAPITAL SGTE TRIM.VIDACOSTOUNIDGTS INDIAHORR.UN.M.OB.CAMBIO TRIMES.INICCAPACID.AHORROTRIMTL. 5AHORRO M.OBRAA 2ANS669600100000160000.850.05B 3ANS410400120000-80000.70-0.02

Graf_Sint_Ejecut

Graf_Sint_Ejecut10923180886125311112807

TrimestrePRONSTICO DE UNIDADES DEMANDADAS

Balance102.169998168994.5400009155107.9499969482100.2200012207

TrimestrePRONSTICO DE PRECIO UNIDADES $

RazonesFinancieras80000500005000025000

TrimestreCAPACIDAD DE PLANTA (UNIDADES)

DatosPublicos85000850003000030000

TrimestreCAPACIDAD DE MAQUINAS (UNIDADES)

* S I M D E F * CIA. 10B A L A N C ETRIMESTRE N U M E R O 4ACTIVOACTIVOS CORRTSCAJA Y BANCOS1,717,238VALORES NEGOCIABLES200,000CTAS.POR COBRAR7,320,993INVENTARIOS ( 54073. UNIDS A $ 73.77/UNID)3,989,017TOTAL ACTIVOS CORRTS13,227,250ACTIVOS FIJOS(NETO DE DEPREC. )MAQUINARIA Y EQUIPO1,750,757EDIF.3,265,250TOTAL ACTIVO FIJO5,016,007TOT. ACTIVOS18,243,250PASIVOS Y CAPITAL ACCIONARIO ,PASIVOS CORRIENTESCTAS. POR PAGAR520,000PTMOS.CRTO.PLZO.P.PAGAR0PTMOS.CRTO.PZO. MULTA0PARTE CTE. DEUDA A MEDIANO PLZO1,250,000PARTE CTE. BONOS1,701,000TOTAL PASIVOS CORRIENTES3,471,000PASIVOS A LARGO PLAZOPTMOS MDNO PLAZO 2 ANOS03ANS0BONOS4,558,500TOTAL PASIVOS A LARGO PLAZO4,558,500TOTAL PASIVOS8,029,500CAPITAL ACCIN,ACCIONES PREFER( 0. ACCNS.)0ACCNS COMUNS ( 900000. ACCNS.)4,068,120UTILIS.RETENIDAS6,145,635TOTAL CAPITL10,213,750TOTAL PASIVO Y CAPITAL18,243,250

SIMDEF. REPORTE DE RAZONES FINANCIERAS1. LIQUIDEZPerodoFirma 1Firma 2Firma 3Firma 4Firma 5Firma 6Firma 7Firma 8Firma 9Firma 10Firma 11Firma 12Firma 13Firma 14Firma 15Firma 16Per. 12.162.162.162.162.162.162.162.162.162.162.162.162.162.162.162.16Per. 22.862.972.762.912.902.652.862.892.621.342.892.882.892.901.993.07Per. 33.433.453.543.853.570.303.383.223.613.023.183.173.853.260.184.18Per. 40.803.850.824.413.810.323.713.754.353.812.893.044.282.910.194.462. PRUEBA ACIDAPerodoFirma 1Firma 2Firma 3Firma 4Firma 5Firma 6Firma 7Firma 8Firma 9Firma 10Firma 11Firma 12Firma 13Firma 14Firma 15Firma 16Per. 11.921.921.921.921.921.921.921.921.921.921.921.921.921.921.921.92Per. 22.642.552.552.662.632.452.672.652.370.812.652.662.652.641.992.42Per. 33.313.083.453.733.310.293.353.113.442.153.153.163.743.100.183.21Per. 40.803.710.824.413.810.323.713.754.352.662.893.044.282.910.193.943. ENDEUDAMIENTOPerodoFirma 1Firma 2Firma 3Firma 4Firma 5Firma 6Firma 7Firma 8Firma 9Firma 10Firma 11Firma 12Firma 13Firma 14Firma 15Firma 16Per. 10.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.51Per. 20.400.390.460.400.470.400.400.400.400.690.400.400.400.400.450.38Per. 30.290.760.350.290.352.230.300.300.291.020.300.300.300.294.590.27Per. 40.680.600.270.230.281.940.490.230.220.790.240.240.300.234.530.204. RENTABILIDAD VTAS.PerodoFirma 1Firma 2Firma 3Firma 4Firma 5Firma 6Firma 7Firma 8Firma 9Firma 10Firma 11Firma 12Firma 13Firma 14Firma 15Firma 16Per. 129.2229.2229.2229.2229.2229.2229.2229.2229.2229.2229.2229.2229.2229.2229.2229.22Per. 230.4435.5330.5031.1032.8130.8129.8231.0531.1037.5231.0530.4430.5031.650.0040.29Per. 333.4138.9132.2230.9834.8232.0032.2132.7632.3342.0630.8430.8632.7633.3432.3439.18Per. 432.9536.7126.3724.9931.7831.6132.9727.6532.7640.9825.2625.1626.9628.4927.3935.185. RETORNO SOBRE LA INVERSIONPerodoFirma 1Firma 2Firma 3Firma 4Firma 5Firma 6Firma 7Firma 8Firma 9Firma 10Firma 11Firma 12Firma 13Firma 14Firma 15Firma 16Per. 117.5417.5417.5417.5417.5417.5417.5417.5417.5417.5417.5417.5417.5417.5417.5417.54Per. 221.5928.4020.1922.2523.4421.9020.9422.6522.1843.8222.6521.8221.2923.45-47.2733.01Per. 328.4723.8425.3524.3928.844.4027.3027.0126.9036.4524.2524.3327.7728.74-0.7334.00Per. 416.9623.419.698.2021.265.0721.0012.9526.2436.277.957.5410.4314.32-2.6229.996. RETORNO SOBRE EL CAPITALPerodoFirma 1Firma 2Firma 3Firma 4Firma 5Firma 6Firma 7Firma 8Firma 9Firma 10Firma 11Firma 12Firma 13Firma 14Firma 15Firma 16Per. 126.4926.4926.4926.4926.4926.4926.4926.4926.4926.4926.4926.4926.4926.4926.4926.49Per. 230.1539.4629.5631.0534.4630.6329.3331.6630.9573.9231.6730.5429.8932.76-68.6345.54Per. 336.7641.8534.1431.5839.0314.2235.4435.0234.7673.7831.5131.6436.0437.19-4.0943.32Per. 428.4337.5112.3510.1127.1414.8831.3915.9832.1464.789.859.3513.5317.62-14.5236.087. RETORNO SOBRE ACTIVOSPerodoFirma 1Firma 2Firma 3Firma 4Firma 5Firma 6Firma 7Firma 8Firma 9Firma 10Firma 11Firma 12Firma 13Firma 14Firma 15Firma 16Per. 14.394.394.394.394.394.394.394.394.394.394.394.394.394.394.394.39Per. 25.407.105.055.565.865.485.235.665.5510.965.665.465.325.86-11.828.25Per. 37.125.966.346.107.211.106.836.756.729.116.066.086.947.18-0.188.50Per. 44.245.852.422.055.321.275.253.246.569.071.991.882.613.58-0.667.508. ROTACION ACTIVOSPerodoFirma 1Firma 2Firma 3Firma 4Firma 5Firma 6Firma 7Firma 8Firma 9Firma 10Firma 11Firma 12Firma 13Firma 14Firma 15Firma 16Per. 10.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.58Per. 20.610.600.580.610.580.610.620.610.610.850.610.620.600.610.110.57Per. 30.640.450.620.640.610.270.650.650.640.600.660.660.640.650.190.59Per. 40.460.470.480.490.550.290.510.510.610.600.480.480.470.520.210.609. MARGEN NETOPerodoFirma 1Firma 2Firma 3Firma 4Firma 5Firma 6Firma 7Firma 8Firma 9Firma 10Firma 11Firma 12Firma 13Firma 14Firma 15Firma 16Per. 17.617.617.617.617.617.617.617.617.617.617.617.617.617.617.617.61Per. 28.8111.848.709.1810.128.978.489.219.1512.859.228.868.809.570.0014.47Per. 311.1013.2810.299.5811.844.0410.4410.3810.4615.239.249.2510.8511.13-0.9414.39Per. 49.2412.515.074.189.594.4410.316.3910.7215.144.123.955.556.89-3.1812.4510. PODER PARA GENERAR GANANCIASPerodoFirma 1Firma 2Firma 3Firma 4Firma 5Firma 6Firma 7Firma 8Firma 9Firma 10Firma 11Firma 12Firma 13Firma 14Firma 15Firma 16Per. 14.394.394.394.394.394.394.394.394.394.394.394.394.394.394.394.39Per. 25.407.105.055.565.865.485.235.665.5510.965.665.465.325.86-11.828.25Per. 37.125.966.346.107.211.106.836.756.729.116.066.086.947.18-0.188.50Per. 44.245.852.422.055.321.275.253.246.569.071.991.882.613.58-0.667.50

* S I M D E F * CIA.SINTESIS DATOS EJECUTIVOS TRIMESTRE 4INFORMACION HISTORICAFirma 1Firma 2Firma 3Firma 4Firma 5Firma 6Firma 7Firma 8Firma 9Firma 10Firma 11Firma 12Firma 13Firma 14Firma 15Firma 16DATOS SOBRE ACCIONES COMUNES ;PRECIO AL FINAL TRIMEST103.78133.8457.5053.01103.7244.80106.2270.79110.76167.2156.6955.4566.3776.885.00138.80VALOR ACUM. SIMDEF103.88134.2557.6053.12104.1444.90106.6471.21110.86167.3157.1155.8766.4777.305.10138.90INGRSOS. X ACCION1.021.400.420.340.960.491.100.541.161.840.320.310.470.60-0.331.40TASA DIVIDENDO0.000.000.000.000.000.000.000.010.000.000.010.010.000.000.000.00RAZON PRECIO INGSOS(BASADO EN INGRSOS TRIM ACTL)25.4423.9034.1438.8026.9223.0724.1332.7523.8622.7443.6345.1435.6731.830.0024.71PRECIO VENTA O PRECIO MERCDO CUANDO OFERTA0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00DATOS ADICIONALES;PRECIO LIBRE104.00104.00104.00104.00104.00104.00104.00104.00104.00104.00104.00104.00104.00104.00104.00104.00DEMANDA LIBRE111891.0111891.0111891.0111891.0111891.0111891.0111891.0111891.0111891.0111891.0111891.0111891.0111891.0111891.0111891.0111891.0TASA RET.VAL.NEGS.CTO.PZO0.013250.013250.013250.013250.013250.013250.013250.013250.013250.013250.013250.013250.013250.013250.013250.01325TASAS INT. SALDOS DEUDORESCORTO PZO.0.019100.019100.019100.019100.019100.024600.019100.019100.019100.019100.019100.019100.019100.019100.027500.019102 ANOS PTMO0.031100.031100.027500.031100.031100.028500.031100.031100.031100.031100.031100.031100.030600.031100.030800.031103 ANOS PTMO0.025000.026700.025000.025000.021800.025000.022600.025000.025000.025000.025000.025000.017600.025000.025000.02500BONO0.014000.014000.014000.014000.014000.014500.014000.014000.014000.019300.014000.014000.014000.014000.018600.01400PRESTAMISTA0.050000.050000.050000.050000.050000.050000.050000.050000.050000.050000.050000.050000.050000.050000.050000.05000PRECIO ACCNS PREFERENCI.47.1747.1747.1747.1747.1716.1347.1747.1747.1747.1747.1747.1747.1747.1711.9547.17TASA DIVNDS. PREFERENCIALES0.021200.021200.021200.021200.021200.062000.021200.021200.021200.021200.021200.021200.021200.021200.083700.02120DIVIDENDS.POR ACCNS.PREFERENCIALES ACUM.E IMPAGAS AUN0.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.00000RETORNO S. INVERSION0.170000.234000.097000.082000.213000.051000.210000.130000.262000.363000.079000.075000.104000.14300-0.026000.30000RETORNO S.CAPITL0.284000.375000.124000.101000.271000.149000.314000.160000.321000.648000.099000.094000.135000.17600-0.145000.36100PREMIO REDENCIO.ACCNS.PREF.0.080000.080000.080000.080000.080000.080000.080000.080000.080000.080000.080000.080000.080000.080000.080000.08000BONO PREMIO REDEN0.080000.080000.080000.080000.080000.080000.080000.080000.080000.080000.080000.080000.080000.080000.080000.08000