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

17
* S I M D E F * CIA. 10 E 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 L N U M E R O 7 INGRESOS VTAS ( 83098. UNIDS A $ 130.00) ### OTROS INGRESOS: VALORES NEGOCIABLES 0 INGRESO TOTAL ### COSTO PROD VENDIDA; INVENTARIO INICIAL ( 39320. A $ 80.82) 3,177,857 MAT.PRIMA ### M.O. DIRECT ### TOTAL COSTOS DCTOS ### GASTOS ALMACEN 250,775 DEPRECIACION;MAQUI. Y EQUIP. 489,559 EDIF ### OTROS GASTS INDIRECTOS 200,000 TOTAL COSTOS INDIRTS ### COSTOS PRODUCCION 80000. A $ 76.46 6,116,917 PRODS DISPON. PARA VENTAS (A $ 77.90 POR UNID) 9,294,774 MENOS:INVENTARIO FINAL ( 36222. UNIDS) 2,821,609 COSTO PRODUC.VEND. 6,473,165 UTILIDAD BRUTA 4,329,588 GASTOS DE ADMINISTRACION Y VENTAS 1,540,138 GASTOS FINANCIEROS; INTERES PREST.CORTO PLAZ;BANCO 0 PRESTAMISTAS SA. 81,337 INTERES PRESTAMO MEDIANO PLAZO 19,437 INTERES BONOS 104,394 COSTO REDENCION BONOS 0 TOTAL CARGOS FINANCIERS 205,168 1,745,306 INGRSO OPERATIVO ANTES DE ITEMS EXTRAORDIN. 2,584,283 ITEMS EXTTRAORDIN. 0 INGRESO ANTES IMPTS 2,584,283 IMPUESTO ( .40 DEL INGRS) 1,033,712 INGRESO DESP.IMPTS 1,550,570 DIVIDENDOS ACCS.PREFEREN. 0 INGRESOS PARA ACCIONTS.COMUNES 1,550,570 DIVIDENDOS ACCNS.COMUN ( .00 POR ACCN.) 0 INGRESO NETO TRANSFERIDO A UTILS.RETENIDAS 1,550,570

Upload: jhon-saavedra-alcantara

Post on 06-Nov-2015

3 views

Category:

Documents


0 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 7INGRESOS VTAS ( 83098. UNIDS A $ 130.00)10,802,750OTROS INGRESOS: VALORES NEGOCIABLES0INGRESO TOTAL10,802,750COSTO PROD VENDIDA;INVENTARIO INICIAL ( 39320. A $ 80.82)3,177,857MAT.PRIMA1,200,000M.O. DIRECT2,920,000TOTAL COSTOS DCTOS4,120,000GASTOS ALMACEN250,775DEPRECIACION;MAQUI. Y EQUIP.489,559EDIF1,056,583OTROS GASTS INDIRECTOS200,000TOTAL COSTOS INDIRTS1,996,917COSTOS PRODUCCION 80000. A $ 76.466,116,917PRODS DISPON. PARA VENTAS (A $ 77.90 POR UNID)9,294,774MENOS:INVENTARIO FINAL ( 36222. UNIDS)2,821,609COSTO PRODUC.VEND.6,473,165UTILIDAD BRUTA4,329,588GASTOS DE ADMINISTRACION Y VENTAS1,540,138GASTOS FINANCIEROS;INTERES PREST.CORTO PLAZ;BANCO0PRESTAMISTAS SA.81,337INTERES PRESTAMO MEDIANO PLAZO19,437INTERES BONOS104,394COSTO REDENCION BONOS0TOTAL CARGOS FINANCIERS205,1681,745,306INGRSO OPERATIVO ANTES DE ITEMS EXTRAORDIN.2,584,283ITEMS EXTTRAORDIN.0INGRESO ANTES IMPTS2,584,283IMPUESTO ( .40 DEL INGRS)1,033,712INGRESO DESP.IMPTS1,550,570DIVIDENDOS ACCS.PREFEREN.0INGRESOS PARA ACCIONTS.COMUNES1,550,570DIVIDENDOS ACCNS.COMUN ( .00 POR ACCN.)0INGRESO NETO TRANSFERIDO A UTILS.RETENIDAS1,550,570

SintesisEjecutiva* S I M D E F *CIA. 10SINTESIS DATOS EJECUTIVOS TRIMESTRE 7INFORMACION HISTORICADATOS SOBRE ACCIONES COMUNES ;PRECIO AL FINAL TRIMEST104.26VALOR ACUM. SIMDEF104.36INGSOS. X ACCION1.72TASA DIVIDENDO0.000RAZON PRECIO INGSOS(BASADO EN INGRSOS TRIM ACTL)15.13PRECIO VENTA O PRECIO MERCDO CUANDO OFERTA0.00DATOS ADICIONALES;PRECIO LIBRE105.00DEMANDA LIBRE112776TASA RET.VAL.NEGS.CTO.PZO0.0138TASAS INT. SALDOS DEUDORESCORTO PZO.0.01982 ANOS PTMO0.03113 ANOS PTMO0.0250BONO0.0193PRESTAMISTA0.0500PRECIO ACCNS PREFERENCI.45.05TASA DIVNDS. PREFERENCIALES0.02220DIVIDENDS.POR ACCNS.PREFER. ACUM.E IMPAGAS AUN0.00RETORNO S. INVERSION0.292RETORNO S.CAPITL0.449PREMIO REDENCIO.ACCNS.PREF.0.08000BONO PREMIO REDEN0.08000DATOS PARA TRIMESTRES FUTUROSTRIMESTRE891011PRONOSTICOS;UNIDADES DEMANDADAS11362510996488139129087PRECIO UNIDADES $106.2899.9993.15106.84SEGUNDO PRONOSTICO. (UNIDADES)PRECIOTERCER PRONOSTICO. (UNIDADES)PRECIOACTUAL;CAPACID.PLANTA (UNIDS)55000550005500030000CAPACID.MAQUINAS (UNIDS)80000750007500075000OTROS GAS. INDTS (DOLAR)200000200000200000200000DEPRECIACION (DOLAR );MAQUINAR.489559467059467059467059PROYS.INV.CAPITAL0000PLANT702833702833702833389083REPAGO PRINCIPAL DE DEUDAS :CORTO PLAZO00002 ANOS3125000003 ANOS0000BONOS425250425250125250125250INTERESES VENCEN PXMO TRIMESTRE S.SALDO DEUDOR;CORTO PLZO0PMO.INTERMED9719BONOS96186COSTOS PRODUCCION UNITARIOS PXMO.TRIM.UNIDSHASTA 60000SGTS 40000SGTS 20000MAS 120000COST.M.OBR39.0029.0025.0033.00MATERIALES:TODOS NIVELES DE PRODUCCION15.00MAQUINAR.46.83PLANT318.74GASTOS ALMACENAJ;UNIDSHASTA 2000SGTS 5000MAS 7000COST/UNID1.003.008.00TASAS PARA FONDOS EN TRIMES 8;CORTO PLZO2 ANOS PTMO3 ANOS PTMOBONOACCNS PRF0.01910.01830.01760.01600.0211ALTERNATIVAS DE INVERSION DE CAPITAL SGTE TRIM.VIDACOSTOUNIDGTS INDIAHORR.UN.M.OB.CAMBIO TRIMES.INICCAPACID.AHORROTRIMTL. 8AHORRO M.OBRAA 2ANS518400100000150000.650.03B 3ANS442800120000-90000.74-0.03

Graf_Sint_Ejecut

Graf_Sint_Ejecut11362510996488139129087

TrimestrePRONSTICO DE UNIDADES DEMANDADAS

Balance106.279998779399.989997863893.1500015259106.8399963379

TrimestrePRONSTICO DE PRECIO UNIDADES $

RazonesFinancieras55000550005500030000

TrimestreCAPACIDAD DE PLANTA (UNIDADES)

DatosPublicos80000750007500075000

TrimestreCAPACIDAD DE MAQUINAS (UNIDADES)

* S I M D E F * CIA. 10B A L A N C ETRIMESTRE N U M E R O 7ACTIVOACTIVOS CORRTSCAJA Y BANCOS32,535VALORES NEGOCIABLES0CTAS.POR COBRAR7,237,845INVENTARIOS ( 36222. UNIDS A $ 77.90/UNID)2,821,609TOTAL ACTIVOS CORRTS10,091,990ACTIVOS FIJOS(NETO DE DEPREC. )MAQUINARIA Y EQUIPO2,827,660EDIF.8,333,827TOTAL ACTIVO FIJO11,161,490TOT. ACTIVOS21,253,480PASIVOS Y CAPITAL ACCIONARIO ,PASIVOS CORRIENTESCTAS. POR PAGAR432,000PTMOS.CRTO.PLZO.P.PAGAR0PTMOS.CRTO.PZO. MULTA1,708,078PARTE CTE. DEUDA A MEDIANO PLZO312,500PARTE CTE. BONOS1,101,000TOTAL PASIVOS CORRIENTES3,553,578PASIVOS A LARGO PLAZOPTMOS MDNO PLAZO 2 ANOS03ANS0BONOS3,882,750TOTAL PASIVOS A LARGO PLAZO3,882,750TOTAL PASIVOS7,436,328CAPITAL ACCIN,ACCIONES PREFER( 0. ACCNS.)0ACCNS COMUNS ( 900000. ACCNS.)4,068,120UTILIS.RETENIDAS9,749,027TOTAL CAPITL13,817,150TOTAL PASIVO Y CAPITAL21,253,480

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.46Per. 52.022.220.111.692.961.392.360.465.022.443.834.004.740.340.890.83Per. 60.331.130.080.721.741.181.791.195.301.745.675.845.110.870.731.94Per. 70.651.990.212.312.491.022.041.204.612.845.545.765.771.070.171.192. 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.94Per. 52.022.220.111.692.961.322.360.465.021.173.834.004.740.340.670.83Per. 60.301.130.080.721.740.921.791.195.301.085.675.845.110.870.261.94Per. 70.591.870.132.312.491.022.041.204.612.055.545.765.771.070.031.193. 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.20Per. 51.260.490.880.180.222.840.400.780.170.620.190.190.241.206.980.51Per. 61.900.681.130.140.282.760.330.840.120.720.140.140.211.1210.030.40Per. 71.801.050.900.370.222.640.280.750.070.540.090.090.210.9698.390.404. 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.18Per. 532.4937.1230.4722.7334.5830.5032.5427.6531.3839.0427.4928.880.0033.8130.8736.07Per. 628.0240.4523.3019.2828.3528.1727.3219.7526.7935.3419.9718.6522.6729.6826.5332.23Per. 743.1048.5934.7724.1927.4217.9536.2418.6025.3440.0825.0720.5818.6232.5124.6731.785. 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.99Per. 54.5616.245.220.5520.55-3.8914.361.1715.7429.8013.1115.12-34.674.23-13.9917.51Per. 6-1.629.81-2.16-5.543.33-7.881.71-6.072.2112.32-2.59-4.15-2.360.68-18.806.32Per. 710.0417.0416.011.894.94-9.9820.84-5.72-3.0029.182.23-4.76-9.918.88-13.887.846. 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.08Per. 510.3224.199.800.6524.98-14.9220.152.0818.4148.2815.5817.97-43.149.300.0026.42Per. 6-4.6916.44-4.60-6.294.26-29.642.27-11.162.4721.22-2.94-4.72-2.851.430.008.87Per. 728.1634.9830.342.586.03-36.3226.68-10.03-3.2244.892.43-5.18-11.9717.360.0011.007. 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.50Per. 51.144.061.300.145.14-0.973.590.293.937.453.283.78-8.671.06-3.504.38Per. 6-0.402.45-0.54-1.380.83-1.970.43-1.520.553.08-0.65-1.04-0.590.17-4.701.58Per. 72.514.264.000.471.24-2.495.21-1.43-0.757.300.56-1.19-2.482.22-3.471.968. 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.60Per. 50.260.370.310.380.490.230.420.290.470.550.530.530.050.260.190.41Per. 60.200.250.260.320.300.190.290.230.320.370.370.360.340.240.160.28Per. 70.250.260.410.370.340.300.460.280.250.510.380.320.230.340.110.319. 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.45Per. 54.4311.034.150.3610.54-4.308.631.018.2913.666.237.130.004.05-18.1510.70Per. 6-2.079.96-2.06-4.352.78-10.541.50-6.531.718.40-1.77-2.92-1.740.69-29.545.68Per. 710.2016.469.721.273.59-8.3611.30-5.06-3.0014.351.46-3.76-10.856.45-31.246.3710. 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.50Per. 51.144.061.300.145.14-0.973.590.293.937.453.283.78-8.671.06-3.504.38Per. 6-0.402.45-0.54-1.380.83-1.970.43-1.520.553.08-0.65-1.04-0.590.17-4.701.58Per. 72.514.264.000.471.24-2.495.21-1.43-0.757.300.56-1.19-2.482.22-3.471.96

* S I M D E F * CIA.SINTESIS DATOS EJECUTIVOS TRIMESTRE 7INFORMACION HISTORICAFirma 1Firma 2Firma 3Firma 4Firma 5Firma 6Firma 7Firma 8Firma 9Firma 10Firma 11Firma 12Firma 13Firma 14Firma 15Firma 16DATOS SOBRE ACCIONES COMUNES ;PRECIO AL FINAL TRIMEST38.2784.5633.4312.5546.895.0057.319.6128.44104.2618.2518.645.0042.665.0063.76VALOR ACUM. SIMDEF38.3785.3333.5312.6547.465.1058.0810.2728.55104.3618.8019.195.1043.315.1063.86INGRSOS. X ACCION1.101.561.130.090.23-0.981.04-0.32-0.121.720.08-0.17-0.360.63-3.640.48TASA DIVIDENDO0.000.000.000.000.000.000.010.040.000.000.020.020.000.010.000.00RAZON PRECIO INGSOS(BASADO EN INGRSOS TRIM ACTL)8.6813.577.3736.2150.360.0013.790.000.0015.1355.260.000.0016.920.0033.08PRECIO VENTA O PRECIO MERCDO CUANDO OFERTA0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00DATOS ADICIONALES;PRECIO LIBRE105.00105.00105.00105.00105.00105.00105.00105.00105.00105.00105.00105.00105.00105.00105.00105.00DEMANDA LIBRE112776.0112776.0112776.0112776.0112776.0112776.0112776.0112776.0112776.0112776.0112776.0112776.0112776.0112776.0112776.0112776.0TASA RET.VAL.NEGS.CTO.PZO0.013850.013850.013850.013850.013850.013850.013850.013850.013850.013850.013850.013850.013850.013850.013850.01385TASAS INT. SALDOS DEUDORESCORTO PZO.0.026500.019800.026500.029600.019800.029600.019800.029400.019800.019800.029700.030200.028200.026500.039200.019802 ANOS PTMO0.031100.031100.026500.031100.031100.028500.031100.031100.031100.031100.031100.031100.030600.031100.030800.031103 ANOS PTMO0.042100.027700.025000.036600.019200.070700.022600.039500.025000.025000.025000.025000.023900.044200.100400.02530BONO0.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.13.7745.0513.7710.4545.0510.4545.0510.6245.0545.0510.3710.0311.8113.772.7045.05TASA DIVNDS. PREFERENCIALES0.072600.022200.072600.095700.022200.095700.022200.094200.022200.022200.096400.099700.084700.072600.370200.02220DIVIDENDS.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.100000.170000.160000.019000.04900-0.100000.20800-0.05700-0.030000.292000.02200-0.04800-0.099000.08900-0.139000.07800RETORNO S.CAPITL0.282000.350000.303000.026000.06000-0.363000.26700-0.10000-0.032000.449000.02400-0.05200-0.120000.17400-13.799000.11000PREMIO 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