| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | FLUJO DE CAJA PURO | Parámetros | Dólar | $450 | sueldo actores | 750,000 | 6 | |||||||||||||||||||
2 | (sin financiamiento) | Costo unitario de Producción 1 | 2,500,000 | Pesos | sueldos actores secundarios | 300,000 | 6 | |||||||||||||||||||
3 | julio 2012 | agosto 2012 | septiembre 2012 | octubre 2012 | noviembre 2012 | diciembre 2012 | enero 2013 | febrero 2013 | marzo 2013 | abril 2013 | mayo 2013 | junio 2013 | julio 2013 | agosto 2013 | septiembre 2013 | octubre 2013 | noviembre 2013 | diciembre 2013 | 1er semestre 2014 | 2do semestre 2014 | 1er semestre 2015 | 2do semestre 2015 | 1er semestre 2016 | TOTALES EN 4 AÑOS | ||
4 | pesos | pesos | pesos | pesos | pesos | pesos | pesos | pesos | pesos | pesos | pesos | pesos | pesos | pesos | pesos | pesos | pesos | pesos | pesos | pesos | pesos | pesos | pesos | |||
5 | VENTAS BRUTAS TOTALES | 0 | 0 | 26,180,000 | 28,560,000 | 44,030,000 | 47,600,000 | 40,460,000 | 0 | 30,940,000 | 57,120,000 | 83,300,000 | 83,300,000 | 88,060,000 | 80,920,000 | 52,360,000 | 78,540,000 | 73,780,000 | 36,890,000 | 295,120,000 | 410,550,000 | 295,120,000 | 410,550,000 | 295,120,000 | ||
6 | Ventas Netas Totales | 0 | 0 | 22,000,000 | 24,000,000 | 37,000,000 | 40,000,000 | 34,000,000 | 0 | 26,000,000 | 48,000,000 | 70,000,000 | 70,000,000 | 74,000,000 | 68,000,000 | 44,000,000 | 66,000,000 | 62,000,000 | 31,000,000 | 248,000,000 | 345,000,000 | 248,000,000 | 345,000,000 | 248,000,000 | 2,150,000,000 | |
7 | Iva débito | 0 | 0 | 4,180,000 | 4,560,000 | 7,030,000 | 7,600,000 | 6,460,000 | 0 | 4,940,000 | 9,120,000 | 13,300,000 | 13,300,000 | 14,060,000 | 12,920,000 | 8,360,000 | 12,540,000 | 11,780,000 | 5,890,000 | 47,120,000 | 65,550,000 | 47,120,000 | 65,550,000 | 47,120,000 | ||
8 | Intervención cambio conductual empresas | 0 | 0 | 18,000,000 | 18,000,000 | 27,000,000 | 36,000,000 | 18,000,000 | 0 | 18,000,000 | 36,000,000 | 54,000,000 | 54,000,000 | 54,000,000 | 54,000,000 | 36,000,000 | 54,000,000 | 54,000,000 | 27,000,000 | 180,000,000 | 279,000,000 | 180,000,000 | 279,000,000 | 180,000,000 | 1,656,000,000 | |
9 | Precio 1 | 9,000,000 | 9,000,000 | 9,000,000 | 9,000,000 | 9,000,000 | 9,000,000 | 9,000,000 | 9,000,000 | 9,000,000 | 9,000,000 | 9,000,000 | 9,000,000 | 9,000,000 | 9,000,000 | 9,000,000 | 9,000,000 | 9,000,000 | 9,000,000 | 9,000,000 | 9,000,000 | 9,000,000 | 9,000,000 | 9,000,000 | ||
10 | Número de programas vendidos 1 | 0 | 0 | 2 | 2 | 3 | 4 | 2 | 0 | 2 | 4 | 6 | 6 | 6 | 6 | 4 | 6 | 6 | 3 | 20 | 31 | 20 | 31 | 20 | 184 | |
11 | Intervención cambio conductual educación | 0 | 0 | 4,000,000 | 6,000,000 | 10,000,000 | 4,000,000 | 16,000,000 | 0 | 8,000,000 | 12,000,000 | 16,000,000 | 16,000,000 | 20,000,000 | 14,000,000 | 8,000,000 | 12,000,000 | 8,000,000 | 4,000,000 | 68,000,000 | 66,000,000 | 68,000,000 | 66,000,000 | 68,000,000 | 494,000,000 | |
12 | Precio 2 | 0 | 0 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | ||
13 | Número de programas vendidos 2 | 10 | 15 | 25 | 10 | 40 | 20 | 30 | 40 | 40 | 50 | 35 | 20 | 30 | 20 | 10 | 170 | 165 | 170 | 165 | 170 | 1,235 | ||||
14 | COSTO DE PRODUCCIÓN BRUTO | 0 | 0 | 17,850,000 | 5,950,000 | 8,925,000 | 11,900,000 | 5,950,000 | 0 | 17,850,000 | 11,900,000 | 17,850,000 | 17,850,000 | 29,750,000 | 17,850,000 | 11,900,000 | 17,850,000 | 17,850,000 | 8,925,000 | 71,400,000 | 104,125,000 | 71,400,000 | 104,125,000 | 71,400,000 | ||
15 | Costo neto de producción 1 | 0 | 0 | 5,000,000 | 5,000,000 | 7,500,000 | 10,000,000 | 5,000,000 | 0 | 5,000,000 | 10,000,000 | 15,000,000 | 15,000,000 | 15,000,000 | 15,000,000 | 10,000,000 | 15,000,000 | 15,000,000 | 7,500,000 | 50,000,000 | 77,500,000 | 50,000,000 | 77,500,000 | 50,000,000 | 460,000,000 | |
16 | Costo inicial programa educacional | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | |||||||||||||||||
17 | IVA Crédito | 12,850,000 | 950,000 | 1,425,000 | 1,900,000 | 950,000 | 0 | 12,850,000 | 1,900,000 | 2,850,000 | 2,850,000 | 14,750,000 | 2,850,000 | 1,900,000 | 2,850,000 | 2,850,000 | 1,425,000 | 21,400,000 | 26,625,000 | 21,400,000 | 26,625,000 | 21,400,000 | ||||
18 | 0 | 0 | 8,330,000 | 22,610,000 | 35,105,000 | 35,700,000 | 34,510,000 | 0 | 13,090,000 | 45,220,000 | 65,450,000 | 65,450,000 | 58,310,000 | 63,070,000 | 40,460,000 | 60,690,000 | 55,930,000 | 27,965,000 | 223,720,000 | 306,425,000 | 223,720,000 | 306,425,000 | 223,720,000 | |||
19 | Margen de Explotación NETO (sin IVA) | 0 | 0 | 7,000,000 | 19,000,000 | 29,500,000 | 30,000,000 | 29,000,000 | 0 | 11,000,000 | 38,000,000 | 55,000,000 | 55,000,000 | 49,000,000 | 53,000,000 | 34,000,000 | 51,000,000 | 47,000,000 | 23,500,000 | 188,000,000 | 257,500,000 | 188,000,000 | 257,500,000 | 188,000,000 | 1,610,000,000 | |
20 | 31.82% | 79.17% | 79.73% | 75.00% | 85.29% | 42.31% | 79.17% | 78.57% | 78.57% | 66.22% | 77.94% | 77.27% | 77.27% | 75.81% | 75.81% | 75.81% | 74.64% | 75.81% | 74.64% | 75.81% | 74.88% | |||||
21 | Gastos de Explotación | |||||||||||||||||||||||||
22 | Sueldos y Leyes Sociales | 8,050,000 | 8,050,000 | 17,650,000 | 17,750,000 | 18,400,000 | 18,550,000 | 18,250,000 | 15,800,000 | 17,850,000 | 18,950,000 | 20,650,000 | 20,650,000 | 20,850,000 | 20,550,000 | 19,350,000 | 20,450,000 | 20,250,000 | 18,700,000 | 60,700,000 | 60,700,000 | 60,700,000 | 60,700,000 | 60,700,000 | 624,250,000 | |
23 | Gerente General | 3,600,000 | 3,600,000 | 3,600,000 | 3,600,000 | 3,600,000 | 3,600,000 | 3,600,000 | 3,600,000 | 3,600,000 | 3,600,000 | 3,600,000 | 3,600,000 | 3,600,000 | 3,600,000 | 3,600,000 | 3,600,000 | 3,600,000 | 3,600,000 | 21,600,000 | 21,600,000 | 21,600,000 | 21,600,000 | 21,600,000 | ||
24 | Gerente de Administración, Personal y Finanzas | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 9,000,000 | 9,000,000 | 9,000,000 | 9,000,000 | 9,000,000 | ||
25 | Gerente Comercial y Marketing | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 12,000,000 | 12,000,000 | 12,000,000 | 12,000,000 | 12,000,000 | ||
26 | Comisones Gerencia comercial | 0 | 0 | 1,100,000 | 1,200,000 | 1,850,000 | 2,000,000 | 1,700,000 | 0 | 1,300,000 | 2,400,000 | 3,500,000 | 3,500,000 | 3,700,000 | 3,400,000 | 2,200,000 | 3,300,000 | 3,100,000 | 1,550,000 | 12,400,000 | 17,250,000 | 12,400,000 | 17,250,000 | 12,400,000 | ||
27 | Secretaria-recepcionista | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 3,600,000 | 3,600,000 | 3,600,000 | 3,600,000 | 3,600,000 | ||
28 | Estafeta (junior) | 350,000 | 350,000 | 350,000 | 350,000 | 350,000 | 350,000 | 350,000 | 350,000 | 350,000 | 350,000 | 350,000 | 350,000 | 350,000 | 350,000 | 350,000 | 350,000 | 350,000 | 350,000 | 2,100,000 | 2,100,000 | 2,100,000 | 2,100,000 | 2,100,000 | ||
29 | Sicólogos (2) | 0 | 0 | 1,200,000 | 1,200,000 | 1,200,000 | 1,200,000 | 1,200,000 | 1,200,000 | 1,200,000 | 1,200,000 | 1,200,000 | 1,200,000 | 1,200,000 | 1,200,000 | 1,200,000 | 1,200,000 | 1,200,000 | 1,200,000 | 7,200,000 | 7,200,000 | 7,200,000 | 7,200,000 | 7,200,000 | ||
30 | Actores principales (6) | 0 | 0 | 4,500,000 | 4,500,000 | 4,500,000 | 4,500,000 | 4,500,000 | 4,500,000 | 4,500,000 | 4,500,000 | 4,500,000 | 4,500,000 | 4,500,000 | 4,500,000 | 4,500,000 | 4,500,000 | 4,500,000 | 4,500,000 | 27,000,000 | 27,000,000 | 27,000,000 | 27,000,000 | 27,000,000 | ||
31 | Actores secundarios | 0 | 0 | 1,800,000 | 1,800,000 | 1,800,000 | 1,800,000 | 1,800,000 | 1,800,000 | 1,800,000 | 1,800,000 | 1,800,000 | 1,800,000 | 1,800,000 | 1,800,000 | 1,800,000 | 1,800,000 | 1,800,000 | 1,800,000 | 10,800,000 | 10,800,000 | 10,800,000 | 10,800,000 | 10,800,000 | ||
32 | Guionista (2) | 0 | 0 | 1,000,000 | 1,000,000 | 1,000,000 | 1,000,000 | 1,000,000 | 250,000 | 1,000,000 | 1,000,000 | 1,600,000 | 1,600,000 | 1,600,000 | 1,600,000 | 1,600,000 | 1,600,000 | 1,600,000 | 1,600,000 | 9,600,000 | 9,600,000 | 9,600,000 | 9,600,000 | 9,600,000 | ||
33 | Arriendo de oficina | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 4,800,000 | 4,800,000 | 4,800,000 | 4,800,000 | 4,800,000 | ||
34 | Publicidad y Marketing | 0 | 0 | 440,000 | 480,000 | 740,000 | 800,000 | 680,000 | 0 | 520,000 | 960,000 | 1,400,000 | 1,400,000 | 1,480,000 | 1,360,000 | 880,000 | 1,320,000 | 1,240,000 | 620,000 | 4,960,000 | 6,900,000 | 4,960,000 | 6,900,000 | 4,960,000 | 43,000,000 | |
35 | Contabilidad | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | ||
36 | Gastos de representación | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 300,000 | 300,000 | 300,000 | 300,000 | 300,000 | ||
37 | Pasajes aereos | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 1,200,000 | 1,200,000 | 1,200,000 | 1,200,000 | 1,200,000 | ||
38 | serv.comunicación | 100,000 | 100,000 | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 | 900,000 | 900,000 | 900,000 | 900,000 | 900,000 | ||
39 | artículos de escritorio | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 120,000 | 120,000 | 120,000 | 120,000 | 120,000 | ||
40 | Hosting | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 200,000 | 1,200,000 | 1,200,000 | 1,200,000 | 1,200,000 | 1,200,000 | ||
41 | Mantenimiento plataforma | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 4,800,000 | 4,800,000 | 4,800,000 | 4,800,000 | 4,800,000 | ||
42 | Diseño de Web y otros | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 3,600,000 | 3,600,000 | 3,600,000 | 3,600,000 | 3,600,000 | ||
43 | luz y electricidad | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | ||
44 | facturas papelerías y otros | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 120,000 | 120,000 | 120,000 | 120,000 | 120,000 | ||
45 | gastos generales | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | ||
46 | patentes municipales | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 300,000 | 300,000 | 300,000 | 300,000 | 300,000 | ||
47 | Total Gastos Brutos de Explotación | 11,190,000 | 11,190,000 | 21,280,000 | 21,420,000 | 22,330,000 | 22,540,000 | 22,120,000 | 18,990,000 | 21,560,000 | 23,100,000 | 25,240,000 | 25,240,000 | 25,520,000 | 25,100,000 | 23,420,000 | 24,960,000 | 24,680,000 | 22,510,000 | 139,400,000 | 146,190,000 | 139,400,000 | 146,190,000 | 139,400,000 | 1,102,970,000 | |
48 | Inversiones | 11,500,000 | 2,500,000 | 2,500,000 | 2,000,000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18,500,000 | |
49 | Diseño de plataforma Play training | 1,500,000 | ||||||||||||||||||||||||
50 | Desarrollo de Plataforma Play training | 2,000,000 | 2,500,000 | 2,500,000 | 2,000,000 | |||||||||||||||||||||
51 | Muebles y habilitación de oficina | 5,000,000 | ||||||||||||||||||||||||
52 | Computadores y otros equipos | 3,000,000 | ||||||||||||||||||||||||
53 | IVA débito del período | 0 | 0 | 4,180,000 | 4,560,000 | 7,030,000 | 7,600,000 | 6,460,000 | 0 | 4,940,000 | 9,120,000 | 13,300,000 | 13,300,000 | 14,060,000 | 12,920,000 | 8,360,000 | 12,540,000 | 11,780,000 | 5,890,000 | 47,120,000 | 65,550,000 | 47,120,000 | 65,550,000 | 47,120,000 | ||
54 | IVA crédito del período | 12,850,000 | 950,000 | 1,425,000 | 1,900,000 | 950,000 | 0 | 12,850,000 | 1,900,000 | 2,850,000 | 2,850,000 | 14,750,000 | 2,850,000 | 1,900,000 | 2,850,000 | 2,850,000 | 1,425,000 | 21,400,000 | 26,625,000 | 21,400,000 | 26,625,000 | 21,400,000 | ||||
55 | IVA neto del período (si es < 0 se acumula para | 0 | 0 | (8,670,000) | (5,060,000) | 545,000 | 5,700,000 | 5,510,000 | 0 | (7,910,000) | (690,000) | 9,760,000 | 10,450,000 | (690,000) | 9,380,000 | 6,460,000 | 9,690,000 | 8,930,000 | 4,465,000 | 25,720,000 | 38,925,000 | 25,720,000 | 38,925,000 | 25,720,000 | ||
56 | ser utilizado en el próximo período) | |||||||||||||||||||||||||
57 | Pago de IVA | 0 | 0 | 0 | 0 | 545,000 | 5,700,000 | 5,510,000 | 0 | 0 | 0 | 9,760,000 | 10,450,000 | 0 | 9,380,000 | 6,460,000 | 9,690,000 | 8,930,000 | 4,465,000 | 25,720,000 | 38,925,000 | 25,720,000 | 38,925,000 | 25,720,000 | ||
58 | Flujo Neto de Explotación del período | -22,690,000 | -13,690,000 | -15,450,000 | -810,000 | 12,230,000 | 7,460,000 | 6,880,000 | -18,990,000 | -8,470,000 | 22,120,000 | 30,450,000 | 29,760,000 | 32,790,000 | 28,590,000 | 10,580,000 | 26,040,000 | 22,320,000 | 990,000 | 58,600,000 | 121,310,000 | 58,600,000 | 121,310,000 | 58,600,000 | ||
59 | ||||||||||||||||||||||||||
60 | depreciación acelerada en dos años | 4,625,000 | 9,250,000 | 4,500,000 | ||||||||||||||||||||||
61 | Saldo a depreciar | 13,875,000 | 4,625,000 | 125,000 | ||||||||||||||||||||||
62 | Utilidad Bruta (o pérdida) (considera depreciación) del período | -11,190,000 | -11,190,000 | -4,280,000 | -2,420,000 | 7,170,000 | 2,835,000 | 6,880,000 | -18,990,000 | -560,000 | 14,900,000 | 29,760,000 | 29,760,000 | 33,480,000 | 27,900,000 | 10,580,000 | 26,040,000 | 22,320,000 | -8,260,000 | 58,600,000 | 116,810,000 | 58,600,000 | 121,310,000 | 58,600,000 | ||
63 | Utilidad Bruta(o pérdida) acumulada | -11,190,000 | -22,380,000 | -26,660,000 | -29,080,000 | -21,910,000 | -19,075,000 | -12,195,000 | -31,185,000 | -31,745,000 | -16,845,000 | 12,915,000 | 42,675,000 | 76,155,000 | 104,055,000 | 114,635,000 | 140,675,000 | 162,995,000 | 154,735,000 | 213,335,000 | 330,145,000 | 388,745,000 | 510,055,000 | 568,655,000 | ||
64 | Base impositiva = Utilidad Bruta del año menos pérdidas acumuladas de años anteriores | -19,075,000 | 154,735,000 | 175,410,000 | 179,910,000 | 58,600,000 | ||||||||||||||||||||
65 | IMPUESTO A LA RENTA (20%) | 0 | 0 | 0 | 30,947,000 | 35,082,000 | 35,982,000 | 11,720,000 | ||||||||||||||||||
66 | Utilidad Neta acumulada | -11,190,000 | -22,380,000 | -26,660,000 | -29,080,000 | -21,910,000 | -19,075,000 | -12,195,000 | -31,185,000 | -31,745,000 | -16,845,000 | 12,915,000 | 42,675,000 | 76,155,000 | 104,055,000 | 114,635,000 | 140,675,000 | 162,995,000 | 123,788,000 | 182,388,000 | 264,116,000 | 322,716,000 | 408,044,000 | 454,924,000 | 454,924,000 | |
67 | Flujo de Caja del período (depreciación no es egreso) | -22,690,000 | -13,690,000 | -15,450,000 | -810,000 | 12,230,000 | 7,460,000 | 6,880,000 | -18,990,000 | -8,470,000 | 22,120,000 | 30,450,000 | 29,760,000 | 32,790,000 | 28,590,000 | 10,580,000 | 26,040,000 | 22,320,000 | -29,957,000 | 58,600,000 | 86,228,000 | 58,600,000 | 85,328,000 | 46,880,000 | ||
68 | Flujo acumulado | -22,690,000 | -36,380,000 | -51,830,000 | -52,640,000 | -40,410,000 | -32,950,000 | -26,070,000 | -45,060,000 | -53,530,000 | -31,410,000 | -960,000 | 28,800,000 | 0 | 28,590,000 | 39,170,000 | 65,210,000 | 87,530,000 | 57,573,000 | 116,173,000 | 202,401,000 | 261,001,000 | 346,329,000 | 393,209,000 | ||
69 | ||||||||||||||||||||||||||
70 | ||||||||||||||||||||||||||
71 | Año 0 | Año 1 | Año 2 | Año 3 | Año 4 | |||||||||||||||||||||
72 | (96,000,000,000) | 28,800,000 | 116,173,000 | 261,001,000 | 393,209,000 | |||||||||||||||||||||
73 | ||||||||||||||||||||||||||
74 | VPN | |||||||||||||||||||||||||
75 | Tasa de actualizaciòn | 0,20 | ||||||||||||||||||||||||
76 | ||||||||||||||||||||||||||
77 | ||||||||||||||||||||||||||
78 | ||||||||||||||||||||||||||
79 | ||||||||||||||||||||||||||
80 | ||||||||||||||||||||||||||
81 | ||||||||||||||||||||||||||
82 | ||||||||||||||||||||||||||
83 | ||||||||||||||||||||||||||
84 | ||||||||||||||||||||||||||
85 | ||||||||||||||||||||||||||
86 | ||||||||||||||||||||||||||
87 | ||||||||||||||||||||||||||
88 | ||||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||
100 |