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

15
* 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 6 INGRESOS VTAS ( 61967. UNIDS A $ 125.00) ### OTROS INGRESOS: VALORES NEGOCIABLES 2,740 INGRESO TOTAL ### COSTO PROD VENDIDA; INVENTARIO INICIAL ( 51287. A $ 75.60) ### MAT.PRIMA 750,000 M.O. DIRECT ### TOTAL COSTOS DCTOS ### GASTOS ALMACEN 275,558 DEPRECIACION;MAQUI. Y EQUIP. 466,001 EDIF 667,500 OTROS GASTS INDIRECTOS 200,000 TOTAL COSTOS INDIRTS ### COSTOS PRODUCCION 50000. A $ 86.18 ### PRODS DISPON. PARA VENTAS (A $ 80.82 POR UNID) ### MENOS:INVENTARIO FINAL ( 39320. UNIDS) ### COSTO PRODUC.VEND. ### UTILIDAD BRUTA ### GASTOS DE ADMINISTRACION Y VENTAS ### GASTOS FINANCIEROS; INTERES PREST.CORTO PLAZ;BANCO 0 PRESTAMISTAS SA. 126,553 INTERES PRESTAMO MEDIANO PLAZO 29,156 INTERES BONOS 112,601 COSTO REDENCION BONOS 0 TOTAL CARGOS FINANCIERS 268,310 ### INGRSO OPERATIVO ANTES DE ITEMS EXTRAORDIN. ### ITEMS EXTTRAORDIN. 0 INGRESO ANTES IMPTS ### IMPUESTO ( .40 DEL INGRS) 433,915 INGRESO DESP.IMPTS 650,872 DIVIDENDOS ACCS.PREFEREN. 0 INGRESOS PARA ACCIONTS.COMUNES 650,872 DIVIDENDOS ACCNS.COMUN ( .00 POR ACCN.) 0 INGRESO NETO TRANSFERIDO A UTILS.RETENIDAS 650,872

Upload: jhon-saavedra-alcantara

Post on 15-Sep-2015

214 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 6INGRESOS VTAS ( 61967. UNIDS A $ 125.00)7,745,914OTROS INGRESOS: VALORES NEGOCIABLES2,740INGRESO TOTAL7,748,654COSTO PROD VENDIDA;INVENTARIO INICIAL ( 51287. A $ 75.60)3,877,059MAT.PRIMA750,000M.O. DIRECT1,950,000TOTAL COSTOS DCTOS2,700,000GASTOS ALMACEN275,558DEPRECIACION;MAQUI. Y EQUIP.466,001EDIF667,500OTROS GASTS INDIRECTOS200,000TOTAL COSTOS INDIRTS1,609,059COSTOS PRODUCCION 50000. A $ 86.184,309,059PRODS DISPON. PARA VENTAS (A $ 80.82 POR UNID)8,186,118MENOS:INVENTARIO FINAL ( 39320. UNIDS)3,177,857COSTO PRODUC.VEND.5,008,261UTILIDAD BRUTA2,740,393GASTOS DE ADMINISTRACION Y VENTAS1,387,296GASTOS FINANCIEROS;INTERES PREST.CORTO PLAZ;BANCO0PRESTAMISTAS SA.126,553INTERES PRESTAMO MEDIANO PLAZO29,156INTERES BONOS112,601COSTO REDENCION BONOS0TOTAL CARGOS FINANCIERS268,3101,655,606INGRSO OPERATIVO ANTES DE ITEMS EXTRAORDIN.1,084,787ITEMS EXTTRAORDIN.0INGRESO ANTES IMPTS1,084,787IMPUESTO ( .40 DEL INGRS)433,915INGRESO DESP.IMPTS650,872DIVIDENDOS ACCS.PREFEREN.0INGRESOS PARA ACCIONTS.COMUNES650,872DIVIDENDOS ACCNS.COMUN ( .00 POR ACCN.)0INGRESO NETO TRANSFERIDO A UTILS.RETENIDAS650,872

SintesisEjecutiva* S I M D E F *CIA. 10SINTESIS DATOS EJECUTIVOS TRIMESTRE 6INFORMACION HISTORICADATOS SOBRE ACCIONES COMUNES ;PRECIO AL FINAL TRIMEST81.39VALOR ACUM. SIMDEF81.49INGSOS. X ACCION0.72TASA DIVIDENDO0.000RAZON PRECIO INGSOS(BASADO EN INGRSOS TRIM ACTL)28.13PRECIO VENTA O PRECIO MERCDO CUANDO OFERTA0.00DATOS ADICIONALES;PRECIO LIBRE96.00DEMANDA LIBRE85928TASA RET.VAL.NEGS.CTO.PZO0.0137TASAS INT. SALDOS DEUDORESCORTO PZO.0.01732 ANOS PTMO0.03113 ANOS PTMO0.0250BONO0.0193PRESTAMISTA0.0500PRECIO ACCNS PREFERENCI.45.66TASA DIVNDS. PREFERENCIALES0.02190DIVIDENDS.POR ACCNS.PREFER. ACUM.E IMPAGAS AUN0.00RETORNO S. INVERSION0.123RETORNO S.CAPITL0.212PREMIO REDENCIO.ACCNS.PREF.0.08000BONO PREMIO REDEN0.08000DATOS PARA TRIMESTRES FUTUROSTRIMESTRE78910PRONOSTICOS;UNIDADES DEMANDADAS11626411428611011674471PRECIO UNIDADES $105.49105.41100.7792.99SEGUNDO PRONOSTICO. (UNIDADES)PRECIOTERCER PRONOSTICO. (UNIDADES)PRECIOACTUAL;CAPACID.PLANTA (UNIDS)80000550005500055000CAPACID.MAQUINAS (UNIDS)80000800007500075000OTROS GAS. INDTS (DOLAR)200000200000200000200000DEPRECIACION (DOLAR );MAQUINAR.489559489559467059467059PROYS.INV.CAPITAL0000PLANT1056583702833702833702833REPAGO PRINCIPAL DE DEUDAS :CORTO PLAZO00002 ANOS312500312500003 ANOS0000BONOS425250425250425250125250INTERESES VENCEN PXMO TRIMESTRE S.SALDO DEUDOR;CORTO PLZO0PMO.INTERMED19438BONOS104394COSTOS PRODUCCION UNITARIOS PXMO.TRIM.UNIDSHASTA 60000SGTS 40000SGTS 20000MAS 120000COST.M.OBR39.0029.0025.0033.00MATERIALES:TODOS NIVELES DE PRODUCCION15.00MAQUINAR.50.87PLANT345.79GASTOS ALMACENAJ;UNIDSHASTA 2000SGTS 5000MAS 7000COST/UNID1.003.008.00TASAS PARA FONDOS EN TRIMES 8;CORTO PLZO2 ANOS PTMO3 ANOS PTMOBONOACCNS PRF0.01980.01900.01820.01670.0222ALTERNATIVAS DE INVERSION DE CAPITAL SGTE TRIM.VIDACOSTOUNIDGTS INDIAHORR.UN.M.OB.CAMBIO TRIMES.INICCAPACID.AHORROTRIMTL. 7AHORRO M.OBRAA 2ANS680400100000110000.860.00B 3ANS658800120000-80001.10-0.02

Graf_Sint_Ejecut

Graf_Sint_Ejecut11626411428611011674471

TrimestrePRONSTICO DE UNIDADES DEMANDADAS

Balance105.4899978638105.4100036621100.769996643192.9899978638

TrimestrePRONSTICO DE PRECIO UNIDADES $

RazonesFinancieras80000550005500055000

TrimestreCAPACIDAD DE PLANTA (UNIDADES)

DatosPublicos80000800007500075000

TrimestreCAPACIDAD DE MAQUINAS (UNIDADES)

* S I M D E F * CIA. 10B A L A N C ETRIMESTRE N U M E R O 6ACTIVOACTIVOS CORRTSCAJA Y BANCOS50,621VALORES NEGOCIABLES0CTAS.POR COBRAR5,189,762INVENTARIOS ( 39320. UNIDS A $ 80.82/UNID)3,177,857TOTAL ACTIVOS CORRTS8,418,240ACTIVOS FIJOS(NETO DE DEPREC. )MAQUINARIA Y EQUIPO3,317,219EDIF.9,390,410TOTAL ACTIVO FIJO12,707,630TOT. ACTIVOS21,125,870PASIVOS Y CAPITAL ACCIONARIO ,PASIVOS CORRIENTESCTAS. POR PAGAR290,000PTMOS.CRTO.PLZO.P.PAGAR0PTMOS.CRTO.PZO. MULTA2,535,292PARTE CTE. DEUDA A MEDIANO PLZO625,000PARTE CTE. BONOS1,401,000TOTAL PASIVOS CORRIENTES4,851,292PASIVOS A LARGO PLAZOPTMOS MDNO PLAZO 2 ANOS03ANS0BONOS4,008,000TOTAL PASIVOS A LARGO PLAZO4,008,000TOTAL PASIVOS8,859,292CAPITAL ACCIN,ACCIONES PREFER( 0. ACCNS.)0ACCNS COMUNS ( 900000. ACCNS.)4,068,120UTILIS.RETENIDAS8,198,457TOTAL CAPITL12,266,580TOTAL PASIVO Y CAPITAL21,125,870

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.942. 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.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.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.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.235. 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.326. 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.877. 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.588. 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.289. 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.6810. 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.58

* S I M D E F * CIA.SINTESIS DATOS EJECUTIVOS TRIMESTRE 6INFORMACION HISTORICAFirma 1Firma 2Firma 3Firma 4Firma 5Firma 6Firma 7Firma 8Firma 9Firma 10Firma 11Firma 12Firma 13Firma 14Firma 15Firma 16DATOS SOBRE ACCIONES COMUNES ;PRECIO AL FINAL TRIMEST31.9066.7323.5915.7841.405.0039.5320.7837.6581.3926.5726.6110.0132.465.0059.46VALOR ACUM. SIMDEF32.0067.3823.7015.8941.945.1040.1721.3237.7681.4927.0227.0510.1133.015.1059.56INGRSOS. X ACCION-0.170.67-0.16-0.210.16-0.870.08-0.370.090.72-0.10-0.16-0.090.05-2.430.38TASA DIVIDENDO0.000.010.000.000.000.000.010.020.000.000.000.000.000.010.000.00RAZON PRECIO INGSOS(BASADO EN INGRSOS TRIM ACTL)0.0024.820.000.0063.900.00119.050.00100.1528.130.000.000.00162.210.0039.33PRECIO VENTA O PRECIO MERCDO CUANDO OFERTA0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00DATOS ADICIONALES;PRECIO LIBRE96.0096.0096.0096.0096.0096.0096.0096.0096.0096.0096.0096.0096.0096.0096.0096.00DEMANDA LIBRE85928.085928.085928.085928.085928.085928.085928.085928.085928.085928.085928.085928.085928.085928.085928.085928.0TASA RET.VAL.NEGS.CTO.PZO0.013700.013700.013700.013700.013700.013700.013700.013700.013700.013700.013700.013700.013700.013700.013700.01370TASAS INT. SALDOS DEUDORESCORTO PZO.0.025100.017300.024900.025100.017300.029900.017300.026200.017300.017300.017300.017300.029500.025100.037700.020302 ANOS PTMO0.031100.031100.026500.031100.031100.028500.031100.031100.031100.031100.031100.031100.030600.031100.030800.031103 ANOS PTMO0.038000.024500.025000.025000.019200.070700.022600.039500.025000.025000.025000.025000.017600.044200.101100.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.15.9545.6616.3715.9545.6610.1645.6614.0645.6645.6645.6645.6610.4815.952.8937.17TASA DIVNDS. PREFERENCIALES0.062700.021900.061100.062700.021900.098400.021900.071100.021900.021900.021900.021900.095400.062700.345900.02690DIVIDENDS.POR ACCNS.PREFERENCIALES ACUM.E IMPAGAS AUN0.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.00000RETORNO S. INVERSION-0.016000.09800-0.02200-0.055000.03300-0.079000.01700-0.061000.022000.12300-0.02600-0.04200-0.024000.00700-0.188000.06300RETORNO S.CAPITL-0.047000.16400-0.04600-0.063000.04300-0.296000.02300-0.112000.025000.21200-0.02900-0.04700-0.028000.01400-2.073000.08900PREMIO 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