flujo de fondos

10
AÑO Demanda Hospedaje GUIAS 2013 5,755 132,077 244,588 24171 19771 9829 168,579 154,933 72480 20843 10273 176,291 162,444 76131 21974 10610 182,316 169,053 79568 23167 11318 194,334 179,549 84301 23667 11833 202,877 186,136 86975 0.1 28244 0.85 0.2 29776 0.7 31392 16 425.71232876712 155385 33095 33810 PROYECTO FINANCIADO 2012 2013 2014 2015 INGRESOS 395,992 414,866 IVA (13%) 51479 53933 IT (3%) 11880 12446 332,633 348,487 COSTOS 102077 102077 2500 2500 38,523 38,523 38,523 32,810 17,100 17,100 15,473 15,473 6000 6000 38523 38523 181673 175960 UTILIDAD -38523 -38523 150960 172527 IUE (25%) 0 0 37740 43132 Ingreso de bebidas Ingreso por Ventas INGRESO NETO Costos de Funcionami ento publicidad Financiero s Depreciaci ón de Activos Fijos ón de Activos Diferidos Otros costos COSTO TOTAL Utilidad Bruta

Upload: carlos-alejo

Post on 01-Oct-2015

216 views

Category:

Documents


1 download

DESCRIPTION

hoja de calculo flujo de fondos planilla parametrizada

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