Download - Flujo de Fondos

Transcript

Hoja1AO Demanda Hospedaje GUIASIngreso de bebidas AO Demanda Hospedaje Guias Ingreso de bebidas 20135,755132,077244,58824171400,8364317.2627820135,755342,423171,21124171537,8054317.2197719829168,579154,93372480395,992323,51220145,870349,265174,63324654548,5522084310273176,291162,44476131414,866338,7351809502533320155,987356,227178,11325145.4559,4851809502197410610182,316169,05379568430,936351,36920166,107363,367181,68325649.4570,6992316711318194,334179,54984301458,184373,88320176,229370,626185,31326161.8582,1002366711833202,877186,13686975475,988389,01320186,354378,063189,03226686.8593,7810.1282440.850.20.8297760.73139216425.7123287671155385108769.516394.178082191814387535968.753309533810PROYECTO FINANCIADOPROYECTO Puro

20122013201420152016201720182012201320142015201620172018INGRESOS INGRESOS Ingreso por Ventas 395,992414,866430,936458,184475,988Ingreso por Ventas 395,992414,866430,936458,184475,988IVA (13%)5147953933560225956461878IVA (13%)5147953933560225956461878IT (3%)1188012446129281374614280IT (3%)1188012446129281374614280INGRESO NETO 332,633348,487361,987384,875399,830INGRESO NETO 332,633348,487361,987384,875399,830COSTOS COSTOS Costos de Funcionamiento 102077102077102077102077102077Costos de Funcionamiento 102077102077102077102077102077publicidad 25002500250025002500publicidad 25002500250025002500Costos Financieros 38,52338,52338,52332,81026,23918,6839,993Costos Financieros 0000000Depreciacin de Activos Fijos 17,10017,10017,10017,10017,100Depreciacin de Activos Fijos 17,10017,10017,10017,10017,100Amortizacin de Activos Diferidos 15,47315,47315,47315,47315,473Amortizacin de Activos Diferidos 15,47315,47315,47315,47315,473Otros costos 60006000600060006000Otros costos 60006000600060006000COSTO TOTAL 3852338523181673175960169389161833153143COSTO TOTAL 00143150143150143150143150143150UTILIDAD UTILIDAD Utilidad Bruta -38523-38523150960172527192598223042246687Utilidad Bruta 00189483205337218837241725256680IUE (25%)003774043132481495576061672IUE (25%)004737151334547096043164170UTILIDAD NETA -38523-38523113220129396144448167281185015UTILIDAD NETA 00142112154003164127181294192510depreciacion17,10017,10017,10017,10017,100depreciacion17,10017,10017,10017,10017,100amortizacion15,47315,47315,47315,47315,473amortizacion15,47315,47315,47315,47315,473amortizacion P0038,09143,80450,37557,93166,621amortizacion P0000000Kw00000025844Kw00000025844VR000000206344VR000000206344prestamo256,822prestamo0inversion-276536-118515inversion-276536-118515395051-19,714-157,038107,702118,165126,646141,923383,155175,518395051-276,536-118,515174,685186,576196,700213,867457,271245,820138,229VAN TIR B/C2.2507682208395,051VAN TIR B/C1.607074970115%311,48564.28%ingresos 1,373,503.46 15%291,65633.93%ingrsos 1,373,503.46 10%406,218egresos 6397052.15 2.250768220827.009218650110%425,530egresos 7698551.78 19.284899640920%239,02620%187,930

0.73440969930.0612008083107,702225,867352,513494,436174,685361,262557,96293654.054565217489349.410775047383271.941152297281145.1411337152190495.822985195151900.358913043141078.333270321129333.747678146122278.927819726227344.4496043791234512345PRI93654.0545652174183003.465340265266275.406492562347420.547626277537916.370611472PRI151900.358913043292978.692183365422312.439861511544591.367681237771935.817285616

322,153273,00522421851900115235,959140,4531642275977553

ingresos netos 320420357111411824322346420210costos927615409337698041102694107704112234

1,212,655.28 456,818.76 2.6545654327

304599150349454948

-20328-15188911677138527173462174596405718-313835-151889182916206935244480248614483187

308,893.47 300,743.91 56%32%

Hoja22012201320142015201620172018INGRESOS Ingreso por Ventas 98,616100,582102,598104,647106,747IVA (13%)1282013076133381360413877IT (3%)29583017307831393202INGRESO NETO 82,83784,48986,18287,90389,667COSTOS Costos de Funcionamiento 13371113638513911314189513911325002625275628943039Costos Financieros 59,32159,32159,32150,52340,40528,76915,388Depreciacin de Activos Fijos 359,520359,520359,520359,520359,520Amortizacin de Activos Diferidos 23,79223,79223,79223,79223,792Otros costos 8396890094341000010600Costo Total 5932159321587240581744.98575019.92566870.015724551451.44658116IVA (13%)771277127634175627747537369371689COSTO TOTAL 5160951609510899506118500267493177479763UTILIDAD Utilidad Bruta -51609-51609-428061-421629-414085-405273-390095IUE (25%)0000000UTILIDAD NETA

Hoja3


Top Related