Flujo de Efectivo

Gastos de Ventas y Marketing. -$15,646.0. -$36,262.0. -$72,454.0. -$80,944.0 ... Inversión de accionistas (Play Business). $110,333.3. $110,333.3. $110,333.3.
123KB Größe 5 Downloads 8 vistas
Flujo de Efectivo El material adjunto que puede incluir proyecciones financieras ha sido preparado únicamente por el proyecto y puede contener declaraciones de escenarios futuros que involucran riesgos e incertidumbres. Cualquiera de estas declaraciones de proyecciones no representan garantías de resultados, desempeños o logros.

Periodo Dinero Disponible [1]

1

2

3

4

5

6

7

8

9

10

11

12

$0

$372.5

$2,786.9

$199,328.2

$196,833.2

$451,037.3

$560,284.4

$1,121,548.6

$1,833,303.6

$2,763,187.0

$3,899,258.9

$5,309,160.0

Actividades relacionadas con la operación Utilidad (pérdida) Bruta Producto 1

$0.0

$45,000.0

$378,000.0

$453,600.0

$544,312.5

$653,175.0

$783,787.5

$940,575.0

$1,128,675.0

$1,354,425.0

$1,625,325.0

$1,950,375.0

$9,857,250.0

Utilidad (pérdida) Bruta Producto 2

$3,540.0

$8,850.0

$25,488.0

$30,585.6

$36,702.7

$44,042.9

$52,850.4

$63,420.9

$76,106.5

$91,326.7

$109,593.1

$131,511.0

$674,017.8

Utilidad (pérdida) Bruta Producto 3

$2,924.0

$8,772.0

$21,052.8

$25,263.4

$30,321.9

$36,389.2

$43,655.3

$52,398.1

$62,866.0

$75,439.2

$90,527.0

$108,626.6

$558,235.5

Utilidad (pérdida) Bruta Producto 4

$0.0

$0.0

$0.0

$0.0

$0.0

$0.0

$80,000.0

$80,000.0

$80,000.0

$80,000.0

$80,000.0

$80,000.0

$480,000.0

Utilidad (pérdida) Bruta Producto 5

$0.0

$0.0

$0.0

$0.0

$0.0

$0.0

$80,000.0

$80,000.0

$80,000.0

$80,000.0

$80,000.0

$80,000.0

$480,000.0

-$15,646.0

-$36,262.0

-$72,454.0

-$80,944.0

-$91,133.0

-$103,360.0

-$154,029.0

-$171,639.0

-$192,764.0

-$218,119.0

-$248,544.0

-$285,051.0

-$1,669,945.0 -$302,000.0

Gastos de Ventas y Marketing Gastos de Investigación y Desarrollo (R&D)

$0.0

$0.0

-$30,000.0

-$30,000.0

-$30,000.0

-$30,000.0

-$30,000.0

-$30,000.0

-$30,000.0

-$30,000.0

-$30,000.0

-$32,000.0

Gastos Administrativos y Generales

-$35,400.0

-$20,400.0

-$40,400.0

-$51,400.0

-$51,400.0

-$51,400.0

-$62,400.0

-$62,400.0

-$62,400.0

-$84,400.0

-$84,400.0

-$84,400.0

-$690,800.0

Sueldos - RH

-$38,000.0

-$88,000.0

-$134,000.0

-$147,000.0

-$157,000.0

-$172,000.0

-$185,000.0

-$185,000.0

-$185,000.0

-$185,000.0

-$185,000.0

-$185,000.0

-$1,846,000.0

Flujo de efectivo de actividades operativas

-$82,582.0

-$82,040.0

$147,686.8

$200,105.0

$281,804.1

$376,847.1

$608,864.3

$767,355.0

$957,483.5

$1,163,671.9

$1,437,501.1

$1,764,061.6

$7,540,758.2

-$16,500.0

-$15,000.0

-$50,600.0

-$202,600.0

-$27,600.0

-$267,600.0

-$47,600.0

-$55,600.0

-$27,600.0

-$27,600.0

-$27,600.0

$0.0

-$765,900.0

$0.0

$0.0

$0.0

$0.0

$0.0

$0.0

$0.0

$0.0

$0.0

$0.0

$0.0

$0.0

$0.0

-$16,500.0

-$15,000.0

-$50,600.0

-$202,600.0

-$27,600.0

-$267,600.0

-$47,600.0

-$55,600.0

-$27,600.0

-$27,600.0

-$27,600.0

$0.0

-$765,900.0

Inversión de accionistas (Play Business)

$110,333.3

$110,333.3

$110,333.3

Comisiones e IVA

-$10,878.9

-$10,878.9

-$10,878.9

$0.0

$0.0

$0.0

$0.0

$0.0

$0.0

$0.0

$0.0

$0.0

-$32,636.6

$99,454.5

$99,454.5

$99,454.5

$0.0

$0.0

$0.0

$0.0

$0.0

$0.0

$0.0

$0.0

$0.0

$298,363.4

$372.5

$2,786.9

$199,328.2

$196,833.2

$451,037.3

$560,284.4

$1,121,548.6

$1,833,303.6

$2,763,187.0

$3,899,258.9

$5,309,160.0

$7,073,221.6

$14,146,443.3

Actividades relacionadas con la inversión Inversión en activos (CapEx) [2] Venta de activos Flujo de efectivo de actividades de inversión

Actividades Relacionadas con financiamiento

Flujo de efectivo de actividades de financiamiento

Flujo de efectivo final [3]

$331,000.0

8. Resumen

CONCEPTO

CON INVERSIÓN

SIN INVERSIÓN

Ingresos Mensuales Promedio

$1,124,078

$50,000

Burn Rate Promedio

$534,643

$20,000

Meses antes de la 1ra venta [1]

2

$5

Punto de Equilibrio

1

$6

CAPEX

$765,900

$0

Fuente de Ingreso

Cantidad Mensual a Establecer en las gráficas del Snapshot

Distribución de Costos

Cantidad Mensual a Establecer en las gráficas del Snapshot

Cargos por servicio Boletos duros

$876,200

Ventas y Marketing

$139,162.1

$63,467

Investigación y Desarrollo (R&D)

$25,166.7

Tarjetas de pvc

$79,548

Administrativos y Generales

$57,566.7

Publicidad en web

$40,000

Sueldos - RH

$153,833.3

Publicidad en boletos

$40,000