1 puntoDatosUnidades10,000Inventario PT556Costos Fijos (Mensual)$21,100,000Costos Variables$460,000,000Costo Variable Unitario$46,000Ventas$900,000,000MP20%MOD50%Insumos10%MOI20%Inventarios (das)20Venta (das)45Proveedores30

Ingresos$787,500,000Egresos$701,700,000Inventarios$32,603,778Cartera$787,500,000Costos Fijos$253,200,000PT$25,576,000Materia Prima e Insumos$126,500,000MP$7,027,778MOD y MOI$322,000,000

Capital de Trabajo Operacional$118,403,778

DatosItemCantidadValor unitarioValor totalInversinTerreno2,500$3,200,000$8,000,000,000$11,411,350,000Construccin Edificio2$1,500,000,000$3,000,000,000Construccin de Cancha1$90,000,000$90,000,000Construccin Piscina1$45,000,000$45,000,000Publicidad de lanzamiento1$20,000,000$20,000,000Equipos de Cmputo5$3,000,000$15,000,000Muebles y Enseres1$25,000,000$25,000,000Capital de trabajoSe requiere cubrir los costos fijos por un periodo de 4 meses$216,350,000CargoCantidadSalarios/MesSalario TotalParafiscalesGerente1$11,000,000$11,000,000$2,770,027Camareras2$680,000$1,360,000$347,890Jefe de recepcin1$900,000$900,000$432,271http://www.elempleo.com/colombia/Files/Companies/Calculadora/index.aspxBotones3$700,000$2,100,000$355,561Recepcionista2$700,000$1,400,000$355,561Auditor Nocturno1$950,000$950,000$451,499Chef1$2,000,000$2,000,000$767,107Ayudantes de Cocina3$860,000$2,580,000$416,929Mesero2$700,000$1,400,000$355,561Barman2$700,000$1,400,000$355,561Contador1$1,800,000$1,800,000$690,396Jefe almacn1$1,600,000$1,600,000$613,685Secretaria1$860,000$860,000$416,929Total Ao$352,200,000$99,947,724RubroValor AnualDotacin de Personal$2,500,000Utilidades y Papelera$1,000,000Materiales para Aseo$1,300,000Propaganda y Publicidad$5,000,000Servicios$120,000,000Alimentacion del Personal$6,000,000Mantenimiento$180,000,000Total$315,800,000Ciclo aoNmero de das% OcupacinIngresos TotalesEnero 1 - Febrero 124391%$2,934,750,000Febrero 13 - Febrero 281675%$900,000,000Marzo 1 - Abril 73840%$1,140,000,000Abril 8 - Abril 16987%$587,250,000Abril 17 - Mayo 264037%$1,110,000,000Mayo 27 - Julio 144985%$3,123,750,000Julio 15 - Noviembre 1011934%$3,034,500,000Noviembre 11 - Diciembre 315189%$3,404,250,000$16,234,500,000

BG1Cuenta12345678910111213ActivosActivos CorrientesBancos$7,740,188,397$19,515,638,011$28,995,791,624$38,475,945,238$47,956,098,852$57,436,252,465$66,913,686,079$77,661,833,571$88,199,644,573$98,737,455,575$109,275,266,578$119,434,487,580$129,593,708,582Total Activos Corrientes$7,740,188,397$19,515,638,011$28,995,791,624$38,475,945,238$47,956,098,852$57,436,252,465$66,913,686,079$77,661,833,571$88,199,644,573$98,737,455,575$109,275,266,578$119,434,487,580$129,593,708,582Activos FijosEquipos de Computo$15,000,000$15,000,000$15,000,000$15,000,000$15,000,000$15,000,000$15,000,000$15,000,000$15,000,000$15,000,000$15,000,000$15,000,000$15,000,000Muebles y Enseres$25,000,000$25,000,000$25,000,000$25,000,000$25,000,000$25,000,000$25,000,000$25,000,000$25,000,000$25,000,000$25,000,000$25,000,000$25,000,000Depreciacin Acum 1-$8,000,000-$16,000,000-$24,000,000-$32,000,000-$40,000,000-$40,000,000-$40,000,000-$40,000,000-$40,000,000-$40,000,000-$40,000,000-$40,000,000-$40,000,000Terrenos$8,000,000,000$8,000,000,000$8,000,000,000$8,000,000,000$8,000,000,000$8,000,000,000$8,000,000,000$8,000,000,000$8,000,000,000$8,000,000,000$8,000,000,000$8,000,000,000$8,000,000,000Edificio$3,000,000,000$3,000,000,000$3,000,000,000$3,000,000,000$3,000,000,000$3,000,000,000$3,000,000,000$3,000,000,000$3,000,000,000$3,000,000,000$3,000,000,000$3,000,000,000$3,000,000,000Canchas$90,000,000$90,000,000$90,000,000$90,000,000$90,000,000$90,000,000$90,000,000$90,000,000$90,000,000$90,000,000$90,000,000$90,000,000$90,000,000Piscina$45,000,000$45,000,000$45,000,000$45,000,000$45,000,000$45,000,000$45,000,000$45,000,000$45,000,000$45,000,000$45,000,000$45,000,000$45,000,000Depreciacin 2-$1,113,500,000-$2,227,000,000-$3,340,500,000-$4,454,000,000-$5,567,500,000-$6,681,000,000-$7,794,500,000-$8,908,000,000-$10,021,500,000-$11,135,000,000-$11,135,000,000-$11,135,000,000-$11,135,000,000Total Activos Fijos$10,053,500,000$8,932,000,000$7,810,500,000$6,689,000,000$5,567,500,000$4,454,000,000$3,340,500,000$2,227,000,000$1,113,500,0000.00.00.00.0Total Activos$17,793,688,397$28,447,638,011$36,806,291,624$45,164,945,238$53,523,598,852$61,890,252,465$70,254,186,079$79,888,833,571$89,313,144,573$98,737,455,575$109,275,266,578$119,434,487,580$129,593,708,582

PasivosPasivos CorrientesImpuestos por Pagar$2,420,388,784$4,715,684,784$4,715,684,784$4,715,684,784$4,715,684,784$4,718,404,784$4,718,404,784$4,928,741,274$4,928,741,274$4,928,741,274$5,307,331,274$5,307,331,274$5,307,331,274Total Pasivos Corrientes$2,420,388,784$4,715,684,784$4,715,684,784$4,715,684,784$4,715,684,784$4,718,404,784$4,718,404,784$4,928,741,274$4,928,741,274$4,928,741,274$5,307,331,274$5,307,331,274$5,307,331,274Pasivos a largo PlazoObligaciones a Largo Plazo$3,912,462,857$3,260,385,714$2,608,308,571$1,956,231,429$1,304,154,286$652,077,1430.00.00.00.00.00.00.0Total Pasivo a largo Plazo$3,912,462,857$3,260,385,714$2,608,308,571$1,956,231,429$1,304,154,286$652,077,1430.00.00.00.00.00.00.0Total Pasivos$6,332,851,640.76$7,976,070,497.90$7,323,993,355.05$6,671,916,212.19$6,019,839,069.33$5,370,481,926.47$4,718,404,783.62$4,928,741,273.84$4,928,741,273.84$4,928,741,273.84$5,307,331,273.84$5,307,331,273.84$5,307,331,273.84PatrimonioUtilidad$4,614,026,756$9,010,730,756$9,010,730,756$9,010,730,756$9,010,730,756$9,016,010,756$9,016,010,756$9,424,311,002$9,424,311,002$9,424,311,002$10,159,221,002$10,159,221,002$10,159,221,002Utilidades Retenidas0.0$4,614,026,756$13,624,757,513$22,635,488,269$31,646,219,026$40,656,949,782$49,672,960,539$58,688,971,295$68,113,282,297$77,537,593,299$86,961,904,302$97,121,125,304$107,280,346,306Capital Social$6,846,810,000$6,846,810,000$6,846,810,000$6,846,810,000$6,846,810,000$6,846,810,000$6,846,810,000$6,846,810,000$6,846,810,000$6,846,810,000$6,846,810,000$6,846,810,000$6,846,810,000Total Patrimonio$11,460,836,756$20,471,567,513$29,482,298,269$38,493,029,026$47,503,759,782$56,519,770,539$65,535,781,295$74,960,092,297$84,384,403,299$93,808,714,302$103,967,935,304$114,127,156,306$124,286,377,308Pasivos+Patrimonio$17,793,688,397$28,447,638,011$36,806,291,624$45,164,945,238$53,523,598,852$61,890,252,465$70,254,186,079$79,888,833,571$89,313,144,573$98,737,455,575$109,275,266,578$119,434,487,580$129,593,708,582Diferencia0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0

ER1Cuenta12345678910111213Ingresos$9,562,500,000$16,234,500,000$16,234,500,000$16,234,500,000$16,234,500,000$16,234,500,000$16,234,500,000$16,234,500,000$16,234,500,000$16,234,500,000$16,234,500,000$16,234,500,000$16,234,500,000Gastos Operacionales$1,573,647,724$1,573,647,724$1,573,647,724$1,573,647,724$1,573,647,724$1,565,647,724$1,565,647,724$1,565,647,724$1,565,647,724$1,565,647,724$452,147,724$452,147,724$452,147,724Gastos Administrativos$335,800,000$315,800,000$315,800,000$315,800,000$315,800,000$315,800,000$315,800,000$315,800,000$315,800,000$315,800,000$315,800,000$315,800,000$315,800,000Utilidad Operacional$7,653,052,276$14,345,052,276$14,345,052,276$14,345,052,276$14,345,052,276$14,353,052,276$14,353,052,276$14,353,052,276$14,353,052,276$14,353,052,276$15,466,552,276$15,466,552,276$15,466,552,276Intereses$618,636,736$618,636,736$618,636,736$618,636,736$618,636,736$618,636,736$618,636,7360.00.00.00.00.00.0Utilidad Antes de Impuestos$7,034,415,540$13,726,415,540$13,726,415,540$13,726,415,540$13,726,415,540$13,734,415,540$13,734,415,540$14,353,052,276$14,353,052,276$14,353,052,276$15,466,552,276$15,466,552,276$15,466,552,276Renta$1,758,603,885$3,431,603,885$3,431,603,885$3,431,603,885$3,431,603,885$3,433,603,885$3,433,603,885$3,588,263,069$3,588,263,069$3,588,263,069$3,866,638,069$3,866,638,069$3,866,638,069CREE$633,097,399$1,235,377,399$1,235,377,399$1,235,377,399$1,235,377,399$1,236,097,399$1,236,097,399$1,291,774,705$1,291,774,705$1,291,774,705$1,391,989,705$1,391,989,705$1,391,989,705ICA$28,687,500$48,703,500$48,703,500$48,703,500$48,703,500$48,703,500$48,703,500$48,703,500$48,703,500$48,703,500$48,703,500$48,703,500$48,703,500Utilidad Neta$4,614,026,756$9,010,730,756$9,010,730,756$9,010,730,756$9,010,730,756$9,016,010,756$9,016,010,756$9,424,311,002$9,424,311,002$9,424,311,002$10,159,221,002$10,159,221,002$10,159,221,002

Depreciacin$1,121,500,000$1,121,500,000$1,121,500,000$1,121,500,000$1,121,500,000$1,113,500,000$1,113,500,000$1,113,500,000$1,113,500,000$1,113,500,0000.00.00.0

FE1Cuentas12345678910111213Ingresos$7,034,415,540$14,847,915,540$14,847,915,540$14,847,915,540$14,847,915,540$14,847,915,540$14,847,915,540$15,466,552,276$15,466,552,276$15,466,552,276$15,466,552,276$15,466,552,276$15,466,552,276Inversion$11,411,350,0000.00.00.00.00.00.00.00.00.00.00.00.0Saldo Anterior0.0$7,740,188,397$19,515,638,011$28,995,791,624$38,475,945,238$47,956,098,852$57,436,252,465$66,913,686,079$77,661,833,571$88,199,644,573$98,737,455,575$109,275,266,578$119,434,487,580Total Ingresos$18,445,765,540$22,588,103,937$34,363,553,551$43,843,707,164$53,323,860,778$62,804,014,392$72,284,168,005$82,380,238,355$93,128,385,847$103,666,196,849$114,204,007,851$124,741,818,854$134,901,039,856EgresosImpuestos0.0$2,420,388,784$4,715,684,784$4,715,684,784$4,715,684,784$4,715,684,784$4,718,404,784$4,718,404,784$4,928,741,274$4,928,741,274$4,928,741,274$5,307,331,274$5,307,331,274Construccin$10,053,500,0000.00.00.00.00.00.00.00.00.00.00.00.0Obligaciones a Largo Plazo$652,077,143$652,077,143$652,077,143$652,077,143$652,077,143$652,077,143$652,077,1430.00.00.00.00.00.0Total Egreso$10,705,577,143$3,072,465,926$5,367,761,926$5,367,761,926$5,367,761,926$5,367,761,926$5,370,481,926$4,718,404,784$4,928,741,274$4,928,741,274$4,928,741,274$5,307,331,274$5,307,331,274Saldo$7,740,188,397$19,515,638,011$28,995,791,624$38,475,945,238$47,956,098,852$57,436,252,465$66,913,686,079$77,661,833,571$88,199,644,573$98,737,455,575$109,275,266,578$119,434,487,580$129,593,708,582

BG2Cuenta12345678910111213ActivosActivos CorrientesBancos$6,543,578,372$17,440,582,878$26,042,291,383$34,643,999,889$43,245,708,395$54,314,740,804$64,852,551,806$75,390,362,808$85,928,173,811$96,465,984,813$107,003,795,815$117,163,016,817$127,322,237,819Total Activos Corrientes$6,543,578,372$17,440,582,878$26,042,291,383$34,643,999,889$43,245,708,395$54,314,740,804$64,852,551,806$75,390,362,808$85,928,173,811$96,465,984,813$107,003,795,815$117,163,016,817$127,322,237,819Activos FijosEquipos de Computo$15,000,000$15,000,000$15,000,000$15,000,000$15,000,000$15,000,000$15,000,000$15,000,000$15,000,000$15,000,000$15,000,000$15,000,000$15,000,000Muebles y Enseres$25,000,000$25,000,000$25,000,000$25,000,000$25,000,000$25,000,000$25,000,000$25,000,000$25,000,000$25,000,000$25,000,000$25,000,000$25,000,000Depreciacin Acum 1-$8,000,000-$16,000,000-$24,000,000-$32,000,000-$40,000,000-$40,000,000-$40,000,000-$40,000,000-$40,000,000-$40,000,000-$40,000,000-$40,000,000-$40,000,000Terrenos$8,000,000,000$8,000,000,000$8,000,000,000$8,000,000,000$8,000,000,000$8,000,000,000$8,000,000,000$8,000,000,000$8,000,000,000$8,000,000,000$8,000,000,000$8,000,000,000$8,000,000,000Edificio$3,000,000,000$3,000,000,000$3,000,000,000$3,000,000,000$3,000,000,000$3,000,000,000$3,000,000,000$3,000,000,000$3,000,000,000$3,000,000,000$3,000,000,000$3,000,000,000$3,000,000,000Canchas$90,000,000$90,000,000$90,000,000$90,000,000$90,000,000$90,000,000$90,000,000$90,000,000$90,000,000$90,000,000$90,000,000$90,000,000$90,000,000Piscina$45,000,000$45,000,000$45,000,000$45,000,000$45,000,000$45,000,000$45,000,000$45,000,000$45,000,000$45,000,000$45,000,000$45,000,000$45,000,000Depreciacin 2-$1,113,500,000-$2,227,000,000-$3,340,500,000-$4,454,000,000-$5,567,500,000-$6,681,000,000-$7,794,500,000-$8,908,000,000-$10,021,500,000-$11,135,000,000-$11,135,000,000-$11,135,000,000-$11,135,000,000Total Activos Fijos$10,053,500,000$8,932,000,000$7,810,500,000$6,689,000,000$5,567,500,000$4,454,000,000$3,340,500,000$2,227,000,000$1,113,500,0000.00.00.00.0Total Activos$16,597,078,372$26,372,582,878$33,852,791,383$41,332,999,889$48,813,208,395$58,768,740,804$68,193,051,806$77,617,362,808$87,041,673,811$96,465,984,813$107,003,795,815$117,163,016,817$127,322,237,819

PasivosPasivos CorrientesImpuestos por Pagar$2,102,223,867$4,397,519,867$4,397,519,867$4,397,519,867$4,397,519,867$4,928,741,274$4,928,741,274$4,928,741,274$4,928,741,274$4,928,741,274$5,307,331,274$5,307,331,274$5,307,331,274Total Pasivos Corrientes$2,102,223,867$4,397,519,867$4,397,519,867$4,397,519,867$4,397,519,867$4,928,741,274$4,928,741,274$4,928,741,274$4,928,741,274$4,928,741,274$5,307,331,274$5,307,331,274$5,307,331,274Pasivos a largo PlazoObligaciones a Largo Plazo$3,651,632,000$2,738,724,000$1,825,816,000$912,908,0000.00.00.00.00.00.00.00.00.0Total Pasivo a largo Plazo$3,651,632,000$2,738,724,000$1,825,816,000$912,908,0000.00.00.00.00.00.00.00.00.0Total Pasivos$5,753,855,866.53$7,136,243,866.53$6,223,335,866.53$5,310,427,866.53$4,397,519,866.53$4,928,741,273.84$4,928,741,273.84$4,928,741,273.84$4,928,741,273.84$4,928,741,273.84$5,307,331,273.84$5,307,331,273.84$5,307,331,273.84PatrimonioUtilidad$3,996,412,506$8,393,116,506$8,393,116,506$8,393,116,506$8,393,116,506$9,424,311,002$9,424,311,002$9,424,311,002$9,424,311,002$9,424,311,002$10,159,221,002$10,159,221,002$10,159,221,002Utilidades Retenidas0.0$3,996,412,506$12,389,529,011$20,782,645,517$29,175,762,022$37,568,878,528$46,993,189,530$56,417,500,532$65,841,811,535$75,266,122,537$84,690,433,539$94,849,654,541$105,008,875,543Capital Social$6,846,810,000$6,846,810,000$6,846,810,000$6,846,810,000$6,846,810,000$6,846,810,000$6,846,810,000$6,846,810,000$6,846,810,000$6,846,810,000$6,846,810,000$6,846,810,000$6,846,810,000Total Patrimonio$10,843,222,506$19,236,339,011$27,629,455,517$36,022,572,022$44,415,688,528$53,839,999,530$63,264,310,532$72,688,621,535$82,112,932,537$91,537,243,539$101,696,464,541$111,855,685,543$122,014,906,545Pasivos+Patrimonio$16,597,078,372$26,372,582,878$33,852,791,383$41,332,999,889$48,813,208,395$58,768,740,804$68,193,051,806$77,617,362,808$87,041,673,811$96,465,984,813$107,003,795,815$117,163,016,817$127,322,237,819Diferencia0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0

ER2Cuenta12345678910111213Ingresos$9,562,500,000$16,234,500,000$16,234,500,000$16,234,500,000$16,234,500,000$16,234,500,000$16,234,500,000$16,234,500,000$16,234,500,000$16,234,500,000$16,234,500,000$16,234,500,000$16,234,500,000Gastos Operacionales$1,573,647,724$1,573,647,724$1,573,647,724$1,573,647,724$1,573,647,724$1,565,647,724$1,565,647,724$1,565,647,724$1,565,647,724$1,565,647,724$452,147,724$452,147,724$452,147,724Gastos Administrativos$335,800,000$315,800,000$315,800,000$315,800,000$315,800,000$315,800,000$315,800,000$315,800,000$315,800,000$315,800,000$315,800,000$315,800,000$315,800,000Utilidad Operacional$7,653,052,276$14,345,052,276$14,345,052,276$14,345,052,276$14,345,052,276$14,353,052,276$14,353,052,276$14,353,052,276$14,353,052,276$14,353,052,276$15,466,552,276$15,466,552,276$15,466,552,276Intereses$1,554,415,904$1,554,415,904$1,554,415,904$1,554,415,904$1,554,415,9040.00.00.00.00.00.00.00.0Utilidad Antes de Impuestos$6,098,636,372$12,790,636,372$12,790,636,372$12,790,636,372$12,790,636,372$14,353,052,276$14,353,052,276$14,353,052,276$14,353,052,276$14,353,052,276$15,466,552,276$15,466,552,276$15,466,552,276Renta$1,524,659,093$3,197,659,093$3,197,659,093$3,197,659,093$3,197,659,093$3,588,263,069$3,588,263,069$3,588,263,069$3,588,263,069$3,588,263,069$3,866,638,069$3,866,638,069$3,866,638,069CREE$548,877,273$1,151,157,273$1,151,157,273$1,151,157,273$1,151,157,273$1,291,774,705$1,291,774,705$1,291,774,705$1,291,774,705$1,291,774,705$1,391,989,705$1,391,989,705$1,391,989,705ICA$28,687,500$48,703,500$48,703,500$48,703,500$48,703,500$48,703,500$48,703,500$48,703,500$48,703,500$48,703,500$48,703,500$48,703,500$48,703,500Utilidad Neta$3,996,412,506$8,393,116,506$8,393,116,506$8,393,116,506$8,393,116,506$9,424,311,002$9,424,311,002$9,424,311,002$9,424,311,002$9,424,311,002$10,159,221,002$10,159,221,002$10,159,221,002

Depreciacin$1,121,500,000$1,121,500,000$1,121,500,000$1,121,500,000$1,121,500,000$1,113,500,000$1,113,500,000$1,113,500,000$1,113,500,000$1,113,500,0000.00.00.0

FE2Cuentas12345678910111213Ingresos$6,098,636,372$13,912,136,372$13,912,136,372$13,912,136,372$13,912,136,372$15,466,552,276$15,466,552,276$15,466,552,276$15,466,552,276$15,466,552,276$15,466,552,276$15,466,552,276$15,466,552,276Inversion$11,411,350,0000.00.00.00.00.00.00.00.00.00.00.00.0Saldo Anterior0.0$6,543,578,372$17,440,582,878$26,042,291,383$34,643,999,889$43,245,708,395$54,314,740,804$64,852,551,806$75,390,362,808$85,928,173,811$96,465,984,813$107,003,795,815$117,163,016,817Total Ingresos$17,509,986,372$20,455,714,744$31,352,719,250$39,954,427,756$48,556,136,261$58,712,260,671$69,781,293,080$80,319,104,082$90,856,915,084$101,394,726,087$111,932,537,089$122,470,348,091$132,629,569,093EgresosImpuestos0.0$2,102,223,867$4,397,519,867$4,397,519,867$4,397,519,867$4,397,519,867$4,928,741,274$4,928,741,274$4,928,741,274$4,928,741,274$4,928,741,274$5,307,331,274$5,307,331,274Construccin$10,053,500,0000.00.00.00.00.00.00.00.00.00.00.00.0Obligaciones a Largo Plazo$912,908,000$912,908,000$912,908,000$912,908,000$912,908,0000.00.00.00.00.00.00.00.0Total Egreso$10,966,408,000$3,015,131,867$5,310,427,867$5,310,427,867$5,310,427,867$4,397,519,867$4,928,741,274$4,928,741,274$4,928,741,274$4,928,741,274$4,928,741,274$5,307,331,274$5,307,331,274Saldo$6,543,578,372$17,440,582,878$26,042,291,383$34,643,999,889$43,245,708,395$54,314,740,804$64,852,551,806$75,390,362,808$85,928,173,811$96,465,984,813$107,003,795,815$117,163,016,817$127,322,237,819