# Avance 2 excel a flujo de efectivo de 3 años b

• 9

This preview shows pages 4–9. Sign up to view the full content.

AVANCE 2 (EXCEL) a) Flujo de efectivo de 3 años b) Periodo de recuperación considerando 3 años c) Valor presente neto considerando 3 años d) Tasa interna de retorno considerando los 3 años e) Punto de equilibrio

This preview has intentionally blurred sections. Sign up to view the full version.

Reporte OPTIMISTA 2018 2019 2020 Inversión Inicial Ventas \$150,000.00 \$0.00 \$0.00 Total \$150,000.00 \$0.00 \$0.00 Ingresos Ventas \$1,680,000.00 \$3,360,000.00 \$5,040,000.00 Total \$1,680,000.00 \$3,360,000.00 \$5,040,000.00 Pagos Compras \$480,000.00 \$960,000.00 \$1,440,000.00 Sueldos y Salarios \$258,000.00 \$516,000.00 \$774,000.00 Otros gastos \$144,000.00 \$288,000.00 \$432,000.00 Renta \$108,000.00 \$132,000.00 \$156,000.00 Servicios \$30,000.00 \$60,000.00 \$90,000.00 Total \$1,020,000.00 \$1,956,000.00 \$2,892,000.00 Valor Neto \$660,000.00 \$1,404,000.00 \$2,148,000.00
Reporte PESIMISTA 2018 2019 2020 Inversion Inicial Ventas \$150,000.00 \$0.00 \$0.00 Total \$150,000.00 \$0.00 \$0.00 Ingresos Ventas \$840,000.00 \$1,008,000.00 \$1,008,000.00 Total \$840,000.00 \$1,008,000.00 \$1,008,000.00 Pagos Compras \$240,000.00 \$240,000.00 \$240,000.00 Sueldos y Salarios \$258,000.00 \$258,000.00 \$258,000.00 Otros gastos \$72,000.00 \$86,400.00 \$86,400.00 Renta \$108,000.00 \$132,000.00 \$156,000.00 Servicios \$30,000.00 \$30,000.00 \$30,000.00 Total \$708,000.00 \$746,400.00 \$770,400.00 Valor Neto \$132,000.00 \$261,600.00 \$237,600.00 REALISTA 2018 2019 2020 Inversion Inicial Ventas \$150,000.00 \$0.00 \$0.00 Total \$150,000.00 \$0.00 \$0.00 Ingresos Ventas \$840,000.00 \$1,260,000.00 \$1,344,000.00 Total \$840,000.00 \$1,260,000.00 \$1,344,000.00 Pagos Compras \$336,000.00 \$432,000.00 \$432,000.00 Sueldos y Salarios \$258,000.00 \$306,000.00 \$306,000.00 Otros gastos \$72,000.00 \$86,400.00 \$86,400.00 Renta \$108,000.00 \$120,000.00 \$132,000.00 Servicios \$30,000.00 \$30,000.00 \$30,000.00 Total \$804,000.00 \$974,400.00 \$986,400.00 Valor Neto \$36,000.00 \$285,600.00 \$357,600.00

This preview has intentionally blurred sections. Sign up to view the full version.

Reporte Posibles fuentes de financiamiento o apoyos a) Créditos de bancos. Requerimientos: CRÉDITO PERSONAL BANAMEX Desde 17%(a) tasa de interés anual fija Hasta \$750,000(b) de monto de crédito 24 a 60 meses diferentes plazos Sin penalización(c) en pagos anticipados Requisitos para tu crédito de personal Mexicano(a) o extranjero con tarjeta de residencia permanente. 21 a 79 años de edad. Ser cliente Citibanamex. \$5,000 de ingreso mensual mínimo. Contar con teléfonos en el domicilio Los créditos son de hasta \$750,000 así que lo mejor es tener un buen historial crediticio o liquidar deudas pendientes (si es que las hay) para poder acceder a algún crédito. Con Citibanamex no necesitas aval. Puedes solicitar tu crédito personal sin tener aval, ni garantías.
Reporte b) Venture capital. Fundada en 1995 para proporcionar servicios de asesoría de banca de inversión y para obtener capital para empresas medianas en México, Nexxus Capital es la firma de capital privado independiente más grande de México.

This preview has intentionally blurred sections. Sign up to view the full version.

This is the end of the preview. Sign up to access the rest of the document.
• Spring '18
• Estados Unidos, Ingreso, Restaurante, Crédito, Comida rápida

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern