simdef-15_1_simco1-firma10-periodo-5.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 5 INGRESOS VTAS ( 82786. UNIDS A $ 125.00) ### OTROS INGRESOS: VALORES NEGOCIABLES 2,320 INGRESO TOTAL ### COSTO PROD VENDIDA; INVENTARIO INICIAL ( 54073. A $ 73.77) 3,989,017 MAT.PRIMA ### M.O. DIRECT ### TOTAL COSTOS DCTOS ### GASTOS ALMACEN 371,295 DEPRECIACION;MAQUI. Y EQUIP. 466,001 EDIF 989,000 OTROS GASTS INDIRECTOS 200,000 TOTAL COSTOS INDIRTS ### COSTOS PRODUCCION 80000. A $ 76.83 6,146,297 PRODS DISPON. PARA VENTAS (A $ 75.60 POR UNID) ### MENOS:INVENTARIO FINAL ( 51287. UNIDS) 3,877,059 COSTO PRODUC.VEND. 6,258,255 UTILIDAD BRUTA 4,009,540 GASTOS DE ADMINISTRACION Y VENTAS 1,513,274 GASTOS FINANCIEROS; INTERES PREST.CORTO PLAZ;BANCO 0 PRESTAMISTAS SA. 0 INTERES PRESTAMO MEDIANO PLAZO 38,875 INTERES BONOS 120,808 COSTO REDENCION BONOS 0 TOTAL CARGOS FINANCIERS 159,683 1,672,957 INGRSO OPERATIVO ANTES DE ITEMS EXTRAORDIN. 2,336,583 ITEMS EXTTRAORDIN. 0 INGRESO ANTES IMPTS 2,336,583 IMPUESTO ( .40 DEL INGRS) 934,633 INGRESO DESP.IMPTS 1,401,950 DIVIDENDOS ACCS.PREFEREN. 0 INGRESOS PARA ACCIONTS.COMUNES 1,401,950 DIVIDENDOS ACCNS.COMUN ( .00 POR ACCN.) 0 INGRESO NETO TRANSFERIDO A UTILS.RETENIDAS 1,401,950

Upload: jhon-saavedra-alcantara

Post on 15-Sep-2015

220 views

Category:

Documents


5 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 5INGRESOS VTAS ( 82786. UNIDS A $ 125.00)10,265,480OTROS INGRESOS: VALORES NEGOCIABLES2,320INGRESO TOTAL10,267,800COSTO PROD VENDIDA;INVENTARIO INICIAL ( 54073. A $ 73.77)3,989,017MAT.PRIMA1,200,000M.O. DIRECT2,920,000TOTAL COSTOS DCTOS4,120,000GASTOS ALMACEN371,295DEPRECIACION;MAQUI. Y EQUIP.466,001EDIF989,000OTROS GASTS INDIRECTOS200,000TOTAL COSTOS INDIRTS2,026,296COSTOS PRODUCCION 80000. A $ 76.836,146,297PRODS DISPON. PARA VENTAS (A $ 75.60 POR UNID)10,135,310MENOS:INVENTARIO FINAL ( 51287. UNIDS)3,877,059COSTO PRODUC.VEND.6,258,255UTILIDAD BRUTA4,009,540GASTOS DE ADMINISTRACION Y VENTAS1,513,274GASTOS FINANCIEROS;INTERES PREST.CORTO PLAZ;BANCO0PRESTAMISTAS SA.0INTERES PRESTAMO MEDIANO PLAZO38,875INTERES BONOS120,808COSTO REDENCION BONOS0TOTAL CARGOS FINANCIERS159,6831,672,957INGRSO OPERATIVO ANTES DE ITEMS EXTRAORDIN.2,336,583ITEMS EXTTRAORDIN.0INGRESO ANTES IMPTS2,336,583IMPUESTO ( .40 DEL INGRS)934,633INGRESO DESP.IMPTS1,401,950DIVIDENDOS ACCS.PREFEREN.0INGRESOS PARA ACCIONTS.COMUNES1,401,950DIVIDENDOS ACCNS.COMUN ( .00 POR ACCN.)0INGRESO NETO TRANSFERIDO A UTILS.RETENIDAS1,401,950

SintesisEjecutiva* S I M D E F *CIA. 10SINTESIS DATOS EJECUTIVOS TRIMESTRE 5INFORMACION HISTORICADATOS SOBRE ACCIONES COMUNES ;PRECIO AL FINAL TRIMEST141.81VALOR ACUM. SIMDEF141.91INGSOS. X ACCION1.56TASA DIVIDENDO0.000RAZON PRECIO INGSOS(BASADO EN INGRSOS TRIM ACTL)22.76PRECIO VENTA O PRECIO MERCDO CUANDO OFERTA0.00DATOS ADICIONALES;PRECIO LIBRE103.00DEMANDA LIBRE107070TASA RET.VAL.NEGS.CTO.PZO0.0116TASAS INT. SALDOS DEUDORESCORTO PZO.0.01732 ANOS PTMO0.03113 ANOS PTMO0.0250BONO0.0193PRESTAMISTA0.0500PRECIO ACCNS PREFERENCI.53.76TASA DIVNDS. PREFERENCIALES0.01860DIVIDENDS.POR ACCNS.PREFER. ACUM.E IMPAGAS AUN0.00RETORNO S. INVERSION0.298RETORNO S.CAPITL0.483PREMIO REDENCIO.ACCNS.PREF.0.08000BONO PREMIO REDEN0.08000DATOS PARA TRIMESTRES FUTUROSTRIMESTRE6789PRONOSTICOS;UNIDADES DEMANDADAS83133119416117653112185PRECIO UNIDADES $96.59105.24103.6198.60SEGUNDO PRONOSTICO. (UNIDADES)PRECIOTERCER PRONOSTICO. (UNIDADES)PRECIOACTUAL;CAPACID.PLANTA (UNIDS)50000800005500055000CAPACID.MAQUINAS (UNIDS)85000300003000025000OTROS GAS. INDTS (DOLAR)200000200000200000200000DEPRECIACION (DOLAR );MAQUINAR.466001177251177251154751PROYS.INV.CAPITAL0000PLANT6675001056583702833702833REPAGO PRINCIPAL DE DEUDAS :CORTO PLAZO00002 ANOS31250031250031250003 ANOS0000BONOS425250425250425250425250INTERESES VENCEN PXMO TRIMESTRE S.SALDO DEUDOR;CORTO PLZO0PMO.INTERMED29156BONOS112601COSTOS PRODUCCION UNITARIOS PXMO.TRIM.UNIDSHASTA 60000SGTS 40000SGTS 20000MAS 120000COST.M.OBR39.0029.0025.0033.00MATERIALES:TODOS NIVELES DE PRODUCCION15.00MAQUINAR.49.97PLANT339.77GASTOS 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.0219ALTERNATIVAS DE INVERSION DE CAPITAL SGTE TRIM.VIDACOSTOUNIDGTS INDIAHORR.UN.M.OB.CAMBIO TRIMES.INICCAPACID.AHORROTRIMTL. 6AHORRO M.OBRAA 2ANS507600100000120000.640.01B 3ANS680400120000-70001.140.00

Graf_Sint_Ejecut

Graf_Sint_Ejecut83133119416117653112185

TrimestrePRONSTICO DE UNIDADES DEMANDADAS

Balance96.5899963379105.2399978638103.610000610498.5999984741

TrimestrePRONSTICO DE PRECIO UNIDADES $

RazonesFinancieras50000800005500055000

TrimestreCAPACIDAD DE PLANTA (UNIDADES)

DatosPublicos85000300003000025000

TrimestreCAPACIDAD DE MAQUINAS (UNIDADES)

* S I M D E F * CIA. 10B A L A N C ETRIMESTRE N U M E R O 5ACTIVOACTIVOS CORRTSCAJA Y BANCOS2,023,411VALORES NEGOCIABLES200,000CTAS.POR COBRAR1,376,319INVENTARIOS ( 51287. UNIDS A $ 75.60/UNID)3,877,059TOTAL ACTIVOS CORRTS7,476,789ACTIVOS FIJOS(NETO DE DEPREC. )MAQUINARIA Y EQUIPO1,284,756EDIF.10,057,910TOTAL ACTIVO FIJO11,342,670TOT. ACTIVOS18,819,460PASIVOS Y CAPITAL ACCIONARIO ,PASIVOS CORRIENTESCTAS. POR PAGAR432,000PTMOS.CRTO.PLZO.P.PAGAR0PTMOS.CRTO.PZO. MULTA0PARTE CTE. DEUDA A MEDIANO PLZO937,500PARTE CTE. BONOS1,701,000TOTAL PASIVOS CORRIENTES3,070,500PASIVOS A LARGO PLAZOPTMOS MDNO PLAZO 2 ANOS03ANS0BONOS4,133,250TOTAL PASIVOS A LARGO PLAZO4,133,250TOTAL PASIVOS7,203,750CAPITAL ACCIN,ACCIONES PREFER( 0. ACCNS.)0ACCNS COMUNS ( 900000. ACCNS.)4,068,120UTILIS.RETENIDAS7,547,585TOTAL CAPITL11,615,710TOTAL PASIVO Y CAPITAL18,819,460

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.832. 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.833. 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.514. 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.075. 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.516. 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.427. 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.388. 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.419. 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.7010. 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.38

* S I M D E F * CIA.SINTESIS DATOS EJECUTIVOS TRIMESTRE 5INFORMACION HISTORICAFirma 1Firma 2Firma 3Firma 4Firma 5Firma 6Firma 7Firma 8Firma 9Firma 10Firma 11Firma 12Firma 13Firma 14Firma 15Firma 16DATOS SOBRE ACCIONES COMUNES ;PRECIO AL FINAL TRIMEST50.4594.4340.5233.2180.1023.5871.6439.9971.04141.8145.0345.6822.2444.205.00103.44VALOR ACUM. SIMDEF50.5594.9640.6233.3180.6323.6872.1740.4271.14141.9145.4646.1122.3444.635.10103.55INGRSOS. X ACCION0.380.950.340.020.94-0.470.740.070.701.560.530.62-1.340.33-1.991.10TASA DIVIDENDO0.000.000.000.000.000.000.010.000.000.000.000.000.000.000.000.00RAZON PRECIO INGSOS(BASADO EN INGRSOS TRIM ACTL)33.1824.7429.59375.3621.330.0024.26141.4525.4922.7621.0518.480.0033.860.0023.49PRECIO VENTA O PRECIO MERCDO CUANDO OFERTA0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00DATOS ADICIONALES;PRECIO LIBRE103.00103.00103.00103.00103.00103.00103.00103.00103.00103.00103.00103.00103.00103.00103.00103.00DEMANDA LIBRE107070.0107070.0107070.0107070.0107070.0107070.0107070.0107070.0107070.0107070.0107070.0107070.0107070.0107070.0107070.0107070.0TASA RET.VAL.NEGS.CTO.PZO0.011600.011600.011600.011600.011600.011600.011600.011600.011600.011600.011600.011600.011600.011600.011600.01160TASAS INT. SALDOS DEUDORESCORTO PZO.0.017900.017300.017300.017300.017300.025700.017300.017300.017300.017300.017300.017300.017300.017300.033900.017302 ANOS PTMO0.031100.031100.027500.031100.031100.028500.031100.031100.031100.031100.031100.031100.030600.031100.030800.031103 ANOS PTMO0.038000.026700.025000.025000.021800.071100.022600.025000.025000.025000.025000.025000.017600.025000.101200.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.42.3753.7653.7653.7653.7612.2553.7653.7653.7653.7653.7653.7653.7653.763.1453.76TASA DIVNDS. PREFERENCIALES0.023600.018600.018600.018600.018600.081600.018600.018600.018600.018600.018600.018600.018600.018600.318600.01860DIVIDENDS.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.046000.162000.052000.006000.20600-0.039000.144000.012000.157000.298000.131000.15100-0.347000.04200-0.140000.17500RETORNO S.CAPITL0.103000.242000.098000.007000.25000-0.149000.201000.021000.184000.483000.156000.18000-0.431000.09300-1.117000.26400PREMIO 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