Sheet1AO020162017201820192020202120222023Prestaciones20002400280040004000400040004000Valor unitario de la prestacin$ 10,000$ 10,000$ 10,000$ 11,000$ 11,000$ 11,000$ 11,000$ 11,000Total de ingresos$ 20,000,000$ 24,000,000$ 28,000,000$ 44,000,000$ 44,000,000$ 44,000,000$ 44,000,000$ 44,000,000

Costo directo unitario$ 3,000$ 3,000$ 3,000$ 2,700$ 2,700$ 2,700$ 2,700$ 2,700Total costo directo (variable)$ 6,000,000$ 7,200,000$ 8,400,000$ 10,800,000$ 10,800,000$ 10,800,000$ 10,800,000$ 10,800,000Costos fijos.$ 3,000,000$ 3,000,000$ 3,000,000$ 3,000,000$ 3,000,000$ 3,000,000$ 3,000,000$ 3,000,000

DepreciacinVer en hoja 2$ 2,760,000$ 2,760,000$ 2,760,000$ 2,760,000$ 2,760,000$ 1,700,000$ 1,700,000$ 1,700,000Utilidad antes de impuesto$ 8,240,000$ 11,040,000$ 13,840,000$ 27,440,000$ 27,440,000$ 28,500,000$ 28,500,000$ 28,500,000Impuesto 20%$ 1,648,000$ 2,208,000$ 2,768,000$ 5,488,000$ 5,488,000$ 5,700,000$ 5,700,000$ 5,700,000Utilidad depues de impuesto$ 6,592,000$ 8,832,000$ 11,072,000$ 21,952,000$ 21,952,000$ 22,800,000$ 22,800,000$ 22,800,000Depreciacin$ 2,760,000$ 2,760,000$ 2,760,000$ 2,760,000$ 2,760,000$ 1,700,000$ 1,700,000$ 1,700,000Flujo Neto$ 9,352,000$ 11,592,000$ 13,832,000$ 24,712,000$ 24,712,000$ 24,500,000$ 24,500,000$ 24,500,000INVERSIONES-69000000K de t(capital de trab)-3000000

Sheet2Valor del bienVida utilDepreciacion anualTERRRENOS32000000no se deprecia!!!Equipos14000000101400000Construcciones1800000050360000Mobiliarios500000051000000Total inversion690000002760000

Sheet3