Proyecto inversion- finanzas

CARPETA FINANZAS

TABLA DEL PUNTO DE EQUILIBRIO |
PRODUCTO O SERVICIO | | COSTO VARIABLE | PRECIO | PRODUCTOS A VENDER AL AÑO | PUNTO DE EQUILIBRIO | INGRESOS |
Página Web |   | $72,000.00 | $760.00 | 316 | 95 | $240,531.36 |
Volantes | 1000 Volantes ¼ carta 4 tintas por un lado | $260.00 | $520.00 | 305 | 2709 | $158,533.20 |
  | 1000 Volantes ½ carta 4 tintas de un lado y 1tinta del otro | $380.00 | $760.00 | 243 | 1854 | $184,955.40 |
  | 1000 Volantes ½ carta 4 tintas (todos los colores) por ambos lados | $750.00 | $1,500.00 | 123 | 939 | $184,955.40 |
Mantas Rotuladas | Manta Rotulada 1.20 x .50 m2 | $21.00 | $ 120.00 | 419 | 7115 | $50,292.91 |
  | Manta Rotulada 1.60 x .60 m2 | $33.60 | $ 140.00 | 718 | 6620 | $100,585.82 |
  | MantaRotulada 1.80 x .80 m2 | $50.40 | $ 151.20 | 998 | 6988 | $150,878.74 |
  | Manta Rotulada 2.00 x .90 m2 | $63.00 | $ 189.00 | 1064 | 5082 | $201,171.65 |
| | | | | | |
  | *$35 M2 (mantas rotuladas mediana calidad) |   |   |   |   |   |
Renovación | Consultora (una hora) | $250.00 | $500.00 | 875 | 2818 | $437,329.68 |
  |   |   |   |   |   |   |
Reinauguración |Sonido e Iluminación | $ 450.00 | $900.00 | 20 | 1565 | $18,222.07 |
  | Con Edecan | $ 350.00 | $750.00 | 175 | 1761 | $131,198.88 |
  | TOTAL |   |   | 5258 |   | $1,858,655.11 |
| | | | | | |

Presupuesto de ventas |
Producto | Precio | Unidades | Importe |
Página Web | $760.00 | 316.48 | #¡VALOR! |
Volantes |   |   |   |
1000 Volantes ¼ carta 4tintas por un lado | $520.00 | 451.65 | 234858 |
1000 Volantes ½ carta 4 tintas de un lado y 1 tinta del otro | $760.00 | 309.02 | 234855.2 |
1000 Volantes ½ carta 4 tintas (todos los colores) por ambos lados | $1,500.00 | 156.57 | 234855 |
Mantas Rotuladas |   |   |   |
Manta Rotulada 1.20 x .50 m2 | $21.00 | 1663.12 | 34925.52 |
Manta Rotulada 1.60 x .60 m2 | $33.60 | 1039.45 |34925.52 |
Manta Rotulada 1.80 x .80 m2 | $50.40 | 692.96 | 34925.184 |
Manta Rotulada 2.00 x .90 m2 | $63.00 | 554.37 | 34925.31 |
Renovación(Consultoría) | $250.00 | 1457.76 | 364440 |
Reinauguración (luces y sonidos) | $450.00 | 269.9 | 121455 |
Reinauguración (Con edecán) | $350.00 | 208.25 | 72887.5 |

FLUJO DE EFECTIVO |
CONCEPTO | ENERO | FEBRERO | MARZO | ABRIL | MAYO |
SALDOINICIAL | $1,000,000.00 | $1,048,788.34 | $1,076,285.53 | $1,110,782.00 | $1,146,279.19 |
(+) INGRESOS |   |   |   |   |   |
ventas | $171,591.49 | $156,800.00 | $156,800.00 | $156,800.00 | $156,800.00 |
(=) EFECTIVO DISPONIBLE | $1,171,591.49 | $1,205,588.34 | $1,233,085.53 | $1,267,582.00 | $1,303,079.19 |
(-) EGRESOS |   |   |   |   |   |
mantenimiento | $500.00 | $500.00 | $500.00 |$500.00 | $500.00 |
gastos operativos y administrativos | $86,906.81 | $94,906.81 | $86,906.81 | $86,906.81 | $94,906.81 |
Otros gastos | $1,000.00 |   | $1,000.00 |   | $1,000.00 |
saldo final | $1,085,184.68 | $1,110,181.53 | $1,146,678.72 | $1,180,175.19 | $1,208,672.38 |

FLUJO DE EFECTIVO |
JUNIO | JULIO | AGOSTO | SEPTIEMBRE | OCTUBRE | NOVIEMBRE | DICIEMBRE |
$1,172,776.38 |$1,207,273.57 | $1,242,270.76 | $1,269,267.95 | $1,303,265.14 | $1,338,262.33 | $1,364,259.52 |
  |   |   |   |   |   |   |
$156,800.00 | $156,800.00 | $156,800.00 | $156,800.00 | $156,800.00 | $156,800.00 | $156,800.00 |
$1,329,576.38 | $1,364,073.57 | $1,399,070.76 | $1,426,067.95 | $1,460,065.14 | $1,495,062.33 | $1,521,059.52 |
  |   |   |   |   |   |   |
$500.00 | $500.00 | $500.00 |$500.00 | $500.00 | $500.00 | $500.00 |
$86,906.81 | $86,906.81 | $94,906.81 | $86,906.81 | $86,906.81 | $94,906.81 | $86,906.81 |
$1,000.00 |   |   | $1,000.00 |   | $1,000.00 |   |
$1,243,169.57 | $1,276,666.76 | $1,303,663.95 | $1,339,661.14 | $1,372,658.33 | $1,400,655.52 | $1,433,652.71 |

VALOR DE MERCADO DE AGENCIAS DE VIAJE POR PRODUCTO
PRODUCTO |   | VENTAS |
a)    Páginas...