FLUJO DE CAJA-ING ECONOMICA.xlsx

Embed Size (px)

DESCRIPTION

FLUJO DE CAJA-ING ECONOMICA.xlsx

Citation preview

Hoja1ESTADO DE PERDIDA Y GANACIASITEMCONCEPTOAOS12345678910AINGRESOSVENTA UNITARIAS300000315000330750347287.5364651.875382884.46875402028.6921875422130.126796875443236.633136719465398.464793555VALOR RESIDUAL DE ACTIVOSOTROS INGRESOSTOTAL DE INGRESOS300000315000330750347287.5364651.875382884.46875402028.6921875422130.126796875443236.633136719465398.464793555BCOSTOSCOSTOS FIJOSCOSTOS DE FABRICACION1. COSTOS DIRECTOSMANO DE OBRA232680232680232680232680232680232680232680232680232680232680INSUMOS750007875082687.586821.87591162.9687595721.1171875100507.173046875105532.531699219110809.15828418116349.6161983892. COSTOS INDIRECTOSCOSTOS OPERATIVOS1. GASTOS ADMINISTRATIVOS2. GASTOS DE VENTASCOSTOS CONTABLES NO DESEMBOLSABLES1. DEPRECIACION05006050060500605006050060500605006050060500602. AMORTIZACION DE INTANGIBLESGASTOS FINANCIEROS1. INTERESESTOTAL DE COSTOS307680361490365427.5369561.875373902.96875378461.1171875383247.173046875388272.531699219393549.15828418399089.616198389CUTILIDAD ANTES DE IMPUESTOS (A-B)-7680-46490-34677.5-22274.375-9251.093754423.351562518781.51914062533857.595097656249687.474852539166308.848595166DIMPUESTO A LA RENTA (30%*C)-2304-13947-10403.25-6682.3125-2775.3281251327.005468755634.455742187510157.278529296914906.242455761719892.6545785498EUTILIDAD NETA PARA DISTRIBUIR (C-D)-5376-32543-24274.25-15592.0625-6475.7656253096.3460937513147.063398437523700.316568359434781.232396777446416.1940166162

Hoja2FLUJO DE CAJA ECONOMICO232680ITEMCONCEPTOAOS01234567891075000AINGRESOSVENTAS300000315000330750347287.5364651.875382884.46875402028.6921875422130.126796875443236.633136719465398.464793555VALOR DE SALVAMENTOFINANCIAMIENTO O PRESTAMO25000025000250002500025000250002500025000250002500025000OTROS INGRESOSTOTAL INGRESOS325000340000355750372287.5389651.875407884.46875427028.6921875447130.126796875468236.633136719490398.464793555BEGRESOSEGRESOS COSTOS FIJOSCOSTOS DE PRODUCCIONEGRESOS COSTOS DE FABRICACIONINSUMOS750007875082687.586821.87591162.9687595721.1171875100507.173046875105532.531699219110809.15828418116349.616198389MANO DE OBRA23268232682326823268232682326823268232682326823268EGRESOS COSTOS OPERRATIVOSOTROS EGRESOSINVERSIONESINVERSIONES FIJAS500600INVERSIONES DE CAPITAL DE TRABAJO100000TOTAL DE EGRESOS60060098268102018105955.5110089.875114430.96875118989.1171875123775.173046875128800.531699219134077.15828418139617.616198389FLUJO DE CAJA ECONOMICO-600600226732237982249794.5262197.625275220.90625288895.3515625303253.519140625318329.595097656334159.474852539350780.848595166TOTALDE GASTOS FINANCIEROSFLUJO DE CAJA FINANCIERO-600600226732237982249794.5262197.625275220.90625288895.3515625303253.519140625318329.595097656334159.474852539350780.848595166

Hoja3