EVIDENCIA ADMINISTRACION FINANCIERA.doc

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

Info icon 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
Image of page 4

Info icon 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
Image of page 5
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
Image of page 6

Info icon 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.
Image of page 7
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.
Image of page 8

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

Image of page 9
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

  • Left Quote Icon

    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.

    Student Picture

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

  • Left Quote Icon

    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.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern