ejercicio excel 1
DESCRIPTION
Resolución de ejercicios excel 1TRANSCRIPT
Trimestre 1 Trimestre 2 Trimestre 3 trimestre 4 Totales
FACTURACIÓN
Ventas 190.000,00$ 210.000,00$ 234.987,00$ 260.654,00$ 895.641,00$
Servicios 34.567,00$ 37.890,00$ 40.987,00$ 41.090,00$ 154.534,00$
Total 224.567,00$ 247.890,00$ 275.974,00$ 301.744,00$ 1.050.175,00$
Interés demora 450,00$ 456,00$ 452,00$ 457,00$ 1.815,00$
Total facturación 225.017,00$ 248.346,00$ 276.426,00$ 302.201,00$ 1.051.990,00$
GASTOS
Costo Ventas 80.967,00$ 100.987,00$ 123.856,00$ 130.563,00$ 436.373,00$
Alquileres 23.000,00$ 23.000,00$ 23.000,00$ 23.000,00$ 92.000,00$
Sueldos 34.567,00$ 34.567,00$ 34.567,00$ 34.567,00$ 138.268,00$
Impuestos 2.312,00$ 2.312,00$ 2.312,00$ 2.312,00$ 9.248,00$
Seguros 789,00$ 789,00$ 789,00$ 789,00$ 3.156,00$
Beneficios 38.000,00$ 42.000,00$ 46.997,40$ 52.130,80$ 179.128,20$
Varios 300,00$ 300,00$ 300,00$ 300,00$ 1.200,00$
Total gastos 179.935,00$ 203.955,00$ 231.821,40$ 243.661,80$ 859.373,20$
Beneficio neto 45.082,00$ 44.391,00$ 44.604,60$ 58.539,20$ 192.616,80$
Cash -Flow 23.471,00$ 67.862,00$ 112.466,60$ 171.005,80$
Disponible 68.553,00$ 23.471,00$ 67.862,00$ 112.466,60$
Costo Ventas/Ventas 48,72186512
ANÁLISIS DE FLUJO DE CAJA