cuadro flujo fina lextendido

1
Cuadro Página 1 CUADRO DEL FLUJO DE FONDOS DEL PROYECTO Año 1 Año 1 Año 2 Año 3 Año 4 Año 5 Año 0.00 1.00 2.00 3.00 4.00 5.00 6.00 7.00 8.00 9.00 10.00 11.00 12.00 Ingresos Cursos 4,000.00 4,000.00 6,000.00 10,000.00 10,000.00 12,000.00 12,000.00 58,000.00 81,200.00 97,440.00 107,184.00 107,184.00 Contenido 2,000.00 2,000.00 4,000.00 4,000.00 5,000.00 5,000.00 5,000.00 27,000.00 37,800.00 45,360.00 49,896.00 49,896.00 Plataforma laboral 800.00 4,000.00 4,000.00 4,000.00 5,000.00 5,000.00 5,000.00 27,800.00 38,920.00 46,704.00 51,374.40 51,374.40 Publicidad 7,000.00 7,000.00 12,000.00 12,000.00 20,000.00 25,000.00 25,000.00 ### ### 181,440.00 199,584.00 199,584.00 Subtotal 0.00 0.00 0.00 0.00 0.00 13,800.00 17,000.00 26,000.00 30,000.00 40,000.00 47,000.00 47,000.00 ### ### 370,944.00 408,038.40 408,038.40 Egresos Personal 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 28,500.00 42,750.00 53,437.50 61,453.13 67,598.44 Director 6,000.00 6,000.00 6,000.00 6,000.00 6,000.00 6,000.00 6,000.00 6,000.00 6,000.00 6,000.00 6,000.00 6,000.00 72,000.00 72,000.00 90,000.00 112,500.00 140,625.00 Sistemas 90,000.00 Hosting 740.00 740.00 740.00 740.00 740.00 740.00 740.00 740.00 740.00 740.00 740.00 740.00 8,880.00 8,880.00 8,880.00 8,880.00 8,880.00 Programacion 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00 28,000.00 35,000.00 38,500.00 42,350.00 46,585.00 Diseño 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 24,000.00 27,600.00 30,360.00 33,396.00 36,735.60 Publicidad 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 18,000.00 19,800.00 21,780.00 23,958.00 26,353.80 Alquiler 6,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 30,000.00 33,000.00 36,300.00 39,930.00 43,923.00 Subtotal 96,000.00 13,740.00 13,740.00 13,740.00 13,740.00 13,740.00 19,240.00 19,240.00 19,240.00 19,240.00 19,240.00 19,240.00 19,240.00 ### ### 279,257.50 322,467.13 370,700.84 Total -96,000.00 -13,740.00 -13,740.00 -13,740.00 -13,740.00 -13,740.00 -5,440.00 -2,240.00 6,760.00 10,760.00 20,760.00 27,760.00 27,760.00 ### 70,090.00 91,686.50 85,571.28 37,337.56 1 2 3 4 5 Badlar 0.13 0.13 VAN 121,642.07 x fórmula ### 54,890.75 63,543.34 52,482.47 20,265.33 ### TIR 89%

Upload: my-own-sweet-home

Post on 16-Apr-2017

629 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Cuadro flujo fina lextendido

Cuadro

Página 1

CUADRO DEL FLUJO DE FONDOS DEL PROYECTO

Año 1 Año 1 Año 2 Año 3 Año 4 Año 5 Año 1/20.00 1.00 2.00 3.00 4.00 5.00 6.00 7.00 8.00 9.00 10.00 11.00 12.00 ###

IngresosCursos 4,000.00 4,000.00 6,000.00 10,000.00 10,000.00 12,000.00 12,000.00 58,000.00 81,200.00 97,440.00 107,184.00 107,184.00Contenido 2,000.00 2,000.00 4,000.00 4,000.00 5,000.00 5,000.00 5,000.00 27,000.00 37,800.00 45,360.00 49,896.00 49,896.00Plataforma laboral 800.00 4,000.00 4,000.00 4,000.00 5,000.00 5,000.00 5,000.00 27,800.00 38,920.00 46,704.00 51,374.40 51,374.40Publicidad 7,000.00 7,000.00 12,000.00 12,000.00 20,000.00 25,000.00 25,000.00 108,000.00 151,200.00 181,440.00 199,584.00 199,584.00Subtotal 0.00 0.00 0.00 0.00 0.00 13,800.00 17,000.00 26,000.00 30,000.00 40,000.00 47,000.00 47,000.00 220,800.00 309,120.00 370,944.00 408,038.40 408,038.40

EgresosPersonal 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 28,500.00 42,750.00 53,437.50 61,453.12 67,598.44Director 6,000.00 6,000.00 6,000.00 6,000.00 6,000.00 6,000.00 6,000.00 6,000.00 6,000.00 6,000.00 6,000.00 6,000.00 72,000.00 72,000.00 90,000.00 112,500.00 140,625.00Sistemas 90,000.00Hosting 740.00 740.00 740.00 740.00 740.00 740.00 740.00 740.00 740.00 740.00 740.00 740.00 8,880.00 8,880.00 8,880.00 8,880.00 8,880.00Programacion 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00 28,000.00 35,000.00 38,500.00 42,350.00 46,585.00Diseño 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 24,000.00 27,600.00 30,360.00 33,396.00 36,735.60

Publicidad 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 18,000.00 19,800.00 21,780.00 23,958.00 26,353.80Alquiler 6,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 30,000.00 33,000.00 36,300.00 39,930.00 43,923.00Subtotal 96,000.00 13,740.00 13,740.00 13,740.00 13,740.00 13,740.00 19,240.00 19,240.00 19,240.00 19,240.00 19,240.00 19,240.00 19,240.00 299,380.00 239,030.00 279,257.50 322,467.13 370,700.84Total -96,000.00 -13,740.00 -13,740.00 -13,740.00 -13,740.00 -13,740.00 -5,440.00 -2,240.00 6,760.00 10,760.00 20,760.00 27,760.00 27,760.00 -78,580.00 70,090.00 91,686.50 85,571.28 37,337.56 ###

1 2 3 4 5Badlar 0.13 0.13

VAN 121,642.07 x fórmula-69,539.82 54,890.75 63,543.34 52,482.47 20,265.33 121,642.07

TIR 89%