PROYECCION DE VENTAS EN UNIDADE PROYECCIN DE VENTAS EN UNIDADES POR AOS DE LAMPARAS DE PIAPRODUCTOMES 1MES 2MES 3MES 4MES 5MES 6MES 7MES 8MES 9MES 10MES 11MES 12TOTALLAMPARAS ECODEC303132333435363738394042427PRIMER AO2702792882973063153243333423513603783843PROYECCION DE VENTAS EN 5 AOSPRODUCTOAO 1AO 2AO 3AO 4AO 5TOTALLAMPARAS427474526589660267611%11%12%12%46.9752.1463.1273.625PROYECCION DE VENTAS EN SOLES EN 5 AOSPRODUCTOPRECIOAO 1AO 2AO 3AO 4AO 5TOTALLAMPARAS93,843.004,266.004,734.005,301.005,940.0024,084.00

PLAN DE INVERSION ORIGINAL PLAN DE INVERSIN ECODECRUBROVALOR UNITARIOUNIDADES REQUERIDAS COSTO TOTALFIJO S/.VARIABLE S/.1. ACTIVO FIJOINFRAESTRUCTURAINSTALACION DE UN BAO PARA EL PERSONAL3001300EQUIPOCOMPUTADORA LG + IMPRESORA160011600HERRAMIENTASTIJERAS6318PINCELES144PISTOLA 13339ALICATE STANLEY8216MUEBLES Y ENSERESMUEBLES PARA COMPUTADORAS1501150MESA603180SILLAS254100VITRINA (AMDAMIOS)3001300VITRINAS GIRATORIAS1502300TIJERAS6530TOTAL DE ACTIVOS FIJOS30372. GASTOS PRE OPERATIVOSLICENCIA DE FUNCIONAMIENTO2501250GASTOS DE CONSTITUCIN LEGAL 4201420LICENCIA DE AVISOS 2751275TOTAL DE GASTOS PRE OPERATIVOS9453. CAPITAL DE TRABAJOMATERIA PRIMA E INSUMOSLAMPARAS DE PIA produccion 30BOTELLAS DESCARTABLES0300.00CUCHARAS1003300.00PAPEL BOND VERDE717.00ESMALTE41248.00CABLE MELLIZO0.810080.00INTERRUPTOR13030.00ENCHUFE9.6328.80BASES DE MADERA24372.00SILICONA GRUESA9.619.60BOLSAS PLASTICAS PEQUEAS2.512.50BOLSAS PLASTICAS GRANDES10110.00JOYERO produccion 20FLORCITAS PEQUEAS2.525.00FLORCITAS GRANDES326.00ESMALTE4624.00LAMINAS DECORATIVAS GRANDES428.00PORTALAPICES produccion 15FLORCITAS PEQUEAS2.512.50FLORCITAS GRANDES313.00ESCARCHE DE VARIOS COLORES11212.00MANO DE OBRA TRABAJADORES DE PRODUCCION40031,200.00TOTAL DE CAPITAL DE TRABAJO1,848.404. COSTOS INDIRECTOSGASTOS ADMINISTRATIVOSSueldo del personalTRABAJADOR DE VENTA3001300ALMACENERO2001200AGUA30130luz 80180TELEFONO E INTERNET30130utiles de oficina20120GASTOS DE VENTASpublicidad ( volantes)20240TOTAL DE COSTOS INDIRECTOS700TOTAL4,682.001,848.4014046,530.40 9364

FLUJO DE CAJA

FLUJO DE CAJA DE JARRAS DE PIA ECODEC

CONCEPTOAO 0AO 1AO 2AO 3AO 4AO 5LIQUIDADCININGRESOS ( A )VENTAS0.003,843.004,266.004,734.005,301.005,940.00EGRESOS ( B )5,969.902,487.902,761.903,066.903,434.903,846.90ACTIVO FIJO3,037.00infraestructura300.00equipo1,600.00herramientas77.00muebles y enseres1,060.00GASTOS PRE OPERATIVOS945.00licencia de funcionamiento250.00gastos de constitucin legal420.00licencia de avisos275.00depreciacion de equipo1,600.001,280.00anual106.6666666667mensualCAMBIO EN CAPITAL DE TRABAJO1,787.901,787.901,984.902,203.902,467.902,763.9011,208.50insumos587.90587.90652.90724.90811.90908.90cambio en mano de obra1,200.001,200.001,332.001,479.001,656.001,855.00COSTOS INDIRECTOS200.00700.00777.00863.00967.001,083.004,390.00gastos administrativos160.00660.00733.00814.00912.001,021.00gastos de ventas40.0040.0044.0049.0055.0062.00saldo antes de impuesto ( A - B )5,969.901,355.101,504.101,667.101,866.102,093.108,485.50saldo economicoImpuesto a la renta: NUEVO RUS240.00240.00240.00600.00600.00SALDO ECONOMICOdespues de impuestos5,969.901,115.101,264.101,427.101,266.101,493.10SALDO ACUMULADO4,854.803,590.702,163.60897.50-595.6010,911.00

PLAN DE INVERSION (2) PLAN DE INVERSIN ECODECRUBROVALOR UNITARIOUNIDADES REQUERIDAS COSTO TOTALUnd. Med.FIJO S/.VARIABLE S/.1. ACTIVO FIJOINFRAESTRUCTURAINSTALACION DE UN BAO PARA EL PERSONAL3001300EQUIPOCOMPUTADORA LG + IMPRESORA16001equipo1600HERRAMIENTASTIJERAS63unidades18PINCELES14unidades4PISTOLA 133unidades39ALICATE STANLEY82unidades16MUEBLES Y ENSERESMUEBLES PARA COMPUTADORAS1501unidades150MESA603unidades180SILLAS254unidades100VITRINA (AMDAMIOS)3001unidades300VITRINAS GIRATORIAS1502unidades300TOTAL DE ACTIVOS FIJOS30072. GASTOS PRE OPERATIVOSLICENCIA DE FUNCIONAMIENTO2501250GASTOS DE CONSTITUCIN LEGAL 4201420LICENCIA DE AVISOS 2751275TOTAL DE GASTOS PRE OPERATIVOS9453. CAPITAL DE TRABAJOMATERIA PRIMA E INSUMOSLAMPARAS produccion 30BOTELLAS DESCARTABLES030Unidades0.0204306.7866666667CUCHARAS123millares36PAPEL BOND VERDE41ciento4ESMALTE181unidades18SOLVENTE (GASOLINA)121unidades6CABLE MELLIZO0.545.00mts.22INTERRUPTOR0.830unidades24ENCHUFE0.830docenas24BASES DE MADERA230unidades60SILICONA GRUESA0.812unidades10JOYERO produccion 20FLORCITAS PEQUEAS0.208320docenas438201.9083FLORCITAS GRANDES0.2520docenas5ESMALTE0.524unidades12SOLVENTE (GASOLINA)0.7512unidades9LAMINAS DECORATIVAS GRANDES42unidades8PORTALAPICES produccion 15FLORCITAS PEQUEAS0.208315docenas331152.0583FLORCITAS GRANDES0.2515docenas4ESMALTE0.2524unidades6SOLVENTE (GASOLINA)0.512unidades6ESCARCHE DE VARIOS COLORES112unidades12MANO DE OBRA TRABAJADORES DE PRODUCCION400331200TOTAL DE CAPITAL DE TRABAJO1,472.644. COSTOS INDIRECTOSGASTOS ADMINISTRATIVOSSueldo del personalSueldo del Aministrador (Titular Gerente)8001800Agua30130Luz80180Telfono e internet30130tiles de oficina20120Contador80180GASTOS DE VENTASTrabajador de venta (vendedor)3001300publicidad ( volantes)202cientos40TOTAL DE COSTOS INDIRECTOS1380TOTAL5,332.001,472.6414046,804.64 BOLSAS PLASTICAS PEQUEAS2.51ciento2BOLSAS PLASTICAS GRANDES101ciento10

InversinyPresupuesto

PLAN DE INVERSIONES> Flujo de Caja Econmico> Gastos Pre-Operativos> Activos Fijos

PLAN DE FINANCIAMIENTO

PLAN DE TESORERA

ESTADOS FINANCIEROS> Estado de Ganancias y PrdidasPLAN DE INVERSIN ECODEC15FLUJO DE CAJA ECONMICOJan-15Feb-15Mar-15Apr-15May-15Jun-15Jul-15Aug-15Sep-15Oct-15Nov-15Dec-15Jan-16Feb-16Mar-16Apr-16May-16Jun-16Jul-16Aug-16Sep-16Oct-16Nov-16Dec-16Jan-17Feb-17Mar-17Apr-17May-17Jun-17Jul-17Aug-17Sep-17Oct-17Nov-17Dec-17Jan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Jan-20Feb-20Mar-20En Nuevos Soles ( S/. )INGRESOSProducto 1: LAMPARAS054067590011251350157518002025225024752700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700000Producto 2: JOYERO 02002804005206407608801000112012401360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360000Producto 3: PORTALAPICES 0120153216279342405468531594657720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720000Otros Ingresos0860110815161924233227403148355639644372478047804780478047804780478047804780478047804780478047804780478047804780478047804780478047804780478047804780478047804780478047804780478047804780478047804780478047804780478047804780478047804780478000025EGRESOSIntangibles94500000000000000000000000000000000000000000000000000000000000000Activos300700000000000000000000000000000000000000000000000000000000000000Gastos Operativos0.01,7231,8752,0272,1792,3312,4832,6352,7872,9393,0913,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2430.00.00.0Gastos Administrativos0.01,0401,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9501,9500.00.00.0Gastos Comercial0.03406006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006006000.00.00.0Impuestos011141924303540455056616161-32400000000000-11802-976-976-976-976-976-976-976-976-976-976-976-3807-976-976-976-976-976-976-976-976-976-976-976-878-976-976-976-976-976-976-976-976-9760098TOTAL EGRESOS39523114443945964753491050685225538255395697585458545854546957935793579357935793579357935793579357935793-60094817481748174817481748174817481748174817481719864817481748174817481748174817481748174817481749154817481748174817481748174817481748170098FLUJO DE CAJA ECONOMICO-3952-2254-3331-3080-2829-2578-2328-2077-1826-1575-1325-1074-1074-1074-689-1013-1013-1013-1013-1013-1013-1013-1013-1013-1013-101310789-37-37-37-37-37-37-37-37-37-37-372794-37-37-37-37-37-37-37-37-37-37-37-135-37-37-37-37-37-37-37-37-3700-98

FLUJO DE CAJA ECONMICO ACUMULADO-3952-6206-9536-12616-15446-18024-20352-22428-24255-25830-27154-28228-29302-30376-31064-32077-33090-34103-35116-36129-37142-38155-39168-40181-41194-42207-31419-31455-31492-31528-31565-31601-31638-31674-31711-31747-31784-31821-29026-29063-29099-29136-29172-29209-29245-29282-29318-29355-29391-29428-29563-29599-29636-29672-29709-29745-29782-29818-29855-29891-29891-29891-2999026 mesmes 29AnualMensualCOK26.00%1.94%-194%-39%VAN$ -27,943.40Renta Anual-198.8%TIRERROR:#NUM!ERROR:#NUM!Inters2%

FLUJO DE CAJA FINANCIEROJan-15Feb-15Mar-15Apr-15May-15Jun-15Jul-15Aug-15Sep-15Oct-15Nov-15Dec-15Jan-16Feb-16Mar-16Apr-16May-16Jun-16Jul-16Aug-16Sep-16Oct-16Nov-16Dec-16Jan-17Feb-17Mar-17Apr-17May-17Jun-17Jul-17Aug-17Sep-17Oct-17Nov-17Dec-17Jan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19

Prestamo10000Amortizacin-500-500-500-500-500-500-500-500-500-500Inters

INGRESOS FINANCIEROS

EGRESOS FINANCIEROSFLUJO DE CAJA FINANCIERO

APORTES DE CAPITAL

DISTRIBUCIN DE UTILIDADES

FLUJO DE CAJA FINAL

Impuestos011141924303540455056616161-32400000000000-11802-976-976-976-976-976-976-976-976-976-976-976-3807-976-976-976-976-976-976-976-976-976-976-976-878-976-976-976-976-976-976-976-976-9760098FLUJO DE CAJA FINAL ACUMULADO

PRODUCTO 1: LAMPARASPrecio con IGV1815151515151515151515151515151515151515151515151515151515151515151515151515151515151515151515151515151515151515151515Cantidad1803045607590105120135150165180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180Cantidad al contado3045607590105120135150165180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180Cantidad al crdito00000000000000000000000000000000000000000000000000000000000Tiempo de crdito (meses)00000000000000000000000000000000000000000000000000000000000Ingresos al contado54067590011251350157518002025225024752700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700Ingresos al crdito0000000000000000000000000000000000000000000000000000000000INGRESOS PRODUCTO 1: LAMPARAS54067590011251350157518002025225024752700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700INGRESOS PRODUCTO 1: LAMPARAS (Sin IGV)4585727639531144133515251716190720972288228822882288228822882288228822882288228822882288228822882288228822882288228822882288228822882288228822882288228822882288228822882288228822882288228822882288228822882288228822882288228822882288PRODUCTO 2: JOYERO Precio con IGV108888888888888888888888888888888888888888888888888888888888Cantidad170203550658095110125140155170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170Cantidad al contado203550658095110125140155170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170170Cantidad al crdito00000000000000000000000000000000000000000000000000000000000Tiempo de crdito (meses)00000000000000000000000000000000000000000000000000000000000Ingresos al contado2002804005206407608801000112012401360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360Ingresos al crdito0000000000000000000000000000000000000000000000000000000000INGRESOS PRODUCTO 2: JOYEROS2002804005206407608801000112012401360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360136013601360INGRESOS PRODUCTO 2: JOYEROS (Sin IGV)16923733944154264474684794910511153115311531153115311531153115311531153115311531153115311531153115311531153115311531153115311531153115311531153115311531153115311531153115311531153115311531153115311531153115311531153115311531153PRODUCTO 3: PORTALAPICES Precio con IGV86666666666666666666666666666666666666666666666666666666666Cantidad1201525.53646.55767.57888.599109.5120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120Cantidad al contado1525.53646.55767.57888.599109.5120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120120Cantidad al crdito00000000000000000000000000000000000000000000000000000000000Tiempo de crdito (meses)00000000000000000000000000000000000000000000000000000000000Ingresos al contado120153216279342405468531594657720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720Ingresos al crdito0000000000000000000000000000000000000000000000000000000000INGRESOS PRODUCTO 3: PORTALAPICES120153216279342405468531594657720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720720INGRESOS PRODUCTO3: PORTALAPICES (Sin IGV)102130183236290343397450503557610610610610610610610610610610610610610610610610610610610610610610610610610610610610610610610610610610610610610610610610610610610610610610610610610INTANGIBLESJan-15Feb-15Mar-15Apr-15May-15Jun-15Jul-15Aug-15Sep-15Oct-15Nov-15Dec-15Jan-16Feb-16Mar-16Apr-16May-16Jun-16Jul-16Aug-16Sep-16Oct-16Nov-16Dec-16Jan-17Feb-17Mar-17Apr-17May-17Jun-17Jul-17Aug-17Sep-17Oct-17Nov-17Dec-17Jan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Jan-20Feb-20Mar-20Constitucin de la empresa420Licencia de Funcionamiento250Trmites Especial0Pagina Web0Logotipo0Licencia de Avisos275TOTAL INTANGIBLES94500000000000000000000000000000000000000000000000000000000000GASTOS PRE-OPERATIVOS (Sin IGV)88100000000000000000000000000000000000000000000000000000000000

ACTIVOS FIJOSJan-15Feb-15Mar-15Apr-15May-15Jun-15Jul-15Aug-15Sep-15Oct-15Nov-15Dec-15Jan-16Feb-16Mar-16Apr-16May-16Jun-16Jul-16Aug-16Sep-16Oct-16Nov-16Dec-16Jan-17Feb-17Mar-17Apr-17May-17Jun-17Jul-17Aug-17Sep-17Oct-17Nov-17Dec-17Jan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Jan-20Feb-20Mar-20Inmuebles e Infraestructura300Instalacin de SS.HH300Muebles y Enseres1030muebles para computadora150mesa180sillas100Vitrina (andamios)300Vitrinas gioratorias300Maquinaria y Equipo1600Equipo de computadora1600Herramientas77tijeras18pinceles4pistola39alicate16TOTAL INVERSIN300700000000000000000000000000000000000000000000000000000000000TOTAL INVERSIN (Sin IGV)254800000000000000000000000000000000000000000000000000000000000 TOTAL INVERSIN ACUMULADA (Sin IGV)254825482548254825482548254825482548254825482548254825482548254825482548254825482548254825482548254825482548254825482548254825482548254825482548254825482548254825482548254825482548254825482548254825482548254825482548254825482548254825482548GASTOS OPERATIVOSJan-15Feb-15Mar-15Apr-15May-15Jun-15Jul-15Aug-15Sep-15Oct-15Nov-15Dec-15Jan-16Feb-16Mar-16Apr-16May-16Jun-16Jul-16Aug-16Sep-16Oct-16Nov-16Dec-16Jan-17Feb-17Mar-17Apr-17May-17Jun-17Jul-17Aug-17Sep-17Oct-17Nov-17Dec-17Jan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Jan-20Feb-20Mar-20Materia Prima e Insumos2734255777298811,0331,1851,3371,4891,6411,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,7931,793 Insumos por lamparas6.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.796.79 N de lamparas3045607590105120135150165180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180180

Insumos por joyeros1.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.911.91 N de joyeros200000000000000000000000000000000000000000000000000000000000

Insumos por portalapiceros2.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.062.06 N de portalapiceros1567590011251350157518002025225024752700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700270027002700

Mano de Obra (Asistente)1,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,200

Otros gastos250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250

TOTAL GASTOS OPERATIVOS01,7231,8752,0272,1792,3312,4832,6352,7872,9393,0913,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,2433,243TOTAL GASTOS OPERATIVOS (Sin IGV)016831835198721392291244325952747289930513203320332033203320332033203320332033203320332033203320332033203320332033203320332033203320332033203320332033203320332033203320332033203320332033203320332033203320332033203320332033203320332033203GASTOS ADMINISTRATIVOSJan-15Feb-15Mar-15Apr-15May-15Jun-15Jul-15Aug-15Sep-15Oct-15Nov-15Dec-15Jan-16Feb-16Mar-16Apr-16May-16Jun-16Jul-16Aug-16Sep-16Oct-16Nov-16Dec-16Jan-17Feb-17Mar-17Apr-17May-17Jun-17Jul-17Aug-17Sep-17Oct-17Nov-17Dec-17Jan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Jan-20Feb-20Mar-20Sueldo del Aministrador (Titular Gerente)8001200120012001200120012001200120012001200120012001200120012001200120012001200120012001200120012001200120012001200120012001200120012001200120012001200120012001200120012001200120012001200120012001200120012001200120012001200120012001200Luz30250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250Agua80250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250250Telfono3050505050505050505050505050505050505050505050505050505050505050505050505050505050505050505050505050505050505050505050tiles de Oficina2050505050505050505050505050505050505050505050505050505050505050505050505050505050505050505050505050505050505050505050Contabilidad80150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150150TOTAL GASTOS ADMINISTRATIVOS010401950195019501950195019501950195019501950195019501950195019501950195019501950195019501950195019501950195019501950195019501950195019501950195019501950195019501950195019501950195019501950195019501950195019501950195019501950195019501950TOTAL GASTOS ADMINISTRATIVOS (Sin IGV)010281624162416241624162416241624162416241624162416241624162416241624162416241624162416241624162416241624162416241624162416241624162416241624162416241624162416241624162416241624162416241624162416241624162416241624162416241624162416241624GASTOS COMERCIALESJan-15Feb-15Mar-15Apr-15May-15Jun-15Jul-15Aug-15Sep-15Oct-15Nov-15Dec-15Jan-16Feb-16Mar-16Apr-16May-16Jun-16Jul-16Aug-16Sep-16Oct-16Nov-16Dec-16Jan-17Feb-17Mar-17Apr-17May-17Jun-17Jul-17Aug-17Sep-17Oct-17Nov-17Dec-17Jan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Jan-20Feb-20Mar-20Trabajador de venta (vendedor)300500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500Publicidad (Publicidad, Radio e internet)40100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100TOTAL GASTOS COMERCIALES0340600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600600TOTAL GASTOS COMERCIALES (Sin IGV)0334585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585IMPUESTOSJan-15Feb-15Mar-15Apr-15May-15Jun-15Jul-15Aug-15Sep-15Oct-15Nov-15Dec-15Jan-16Feb-16Mar-16Apr-16May-16Jun-16Jul-16Aug-16Sep-16Oct-16Nov-16Dec-16Jan-17Feb-17Mar-17Apr-17May-17Jun-17Jul-17Aug-17Sep-17Oct-17Nov-17Dec-17Jan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Jan-20Feb-20Mar-20Impuesto General a las Ventas (IGV)Tasa de IGV18%IGV - Ventas082103137172206240275309343378412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412 Producto 1: Tortas082103137172206240275309343378412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412412

IGV - Compras (Crdito Fiscal)45983381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381381 Gastos Pre-Operativos000000000000000000000000000000000000000000000000000000000000 Activos Fijos45900000000000000000000000000000000000000000000000000000000000 Gastos Operativos06340404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040404040 Gastos Administrativos013326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326326 Gastos Comerciales0615151515151515151515151515151515151515151515151515151515151515151515151515151515151515151515151515151515151515151515

Saldo Neto-459-0-278-244-210-176-141-107-73-38-430303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030Saldo Acumulado (Crdito Fiscal)-459-459-737-982-1191-1367-1508-1615-1688-1726-1730-1699-1669-1638-1608-1578-1547-1517-1486-1456-1425-1395-1365-1334-1304-1273-1243-1212-1182-1152-1121-1091-1060-1030-1000-969-939-908-878-847-817-787-756-726-695-665-634-604-574-543-513-482-452-421-391-361-330-300-269-239

EGRESOS IMPUESTO GENERAL A LAS VENTAS (IGV)000000000000000000000000000000000000000000000000000000000000000Jan-15Feb-15Mar-15Apr-15May-15Jun-15Jul-15Aug-15Sep-15Oct-15Nov-15Dec-15Jan-16Feb-16Mar-16Apr-16May-16Jun-16Jul-16Aug-16Sep-16Oct-16Nov-16Dec-16Jan-17Feb-17Mar-17Apr-17May-17Jun-17Jul-17Aug-17Sep-17Oct-17Nov-17Dec-17Jan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Jan-20Feb-20Mar-20Impuesto a la Renta (IR)

Metodo del Porcentaje del 1.5 %
Promidel: Invesca.com:Se determina aplicando el 2% sobre los ingresos netos obtenidos durante el mes.Slo pueden acogerse a este mtodo aquellos contribuyentes que inician sus actividades durante el ejercicio o que no hubieran obtenido renta imponible en el ejercicio anterior. El impuesto se calcula aplicando la tasa del 30% a la utilidad generada al cierre del ao01114192430354045505661616161

Metodo del Coeficiente
Promidel: Invesca.com:Slo pueden acogerse a este mtodo quienes hayan obtenido impuesto calculado en el ejercicio anterior. El coeficiente se obtiene de la siguiente forma: Dividiendo el impuesto calculado entre los ingresos netos del ejercicio anterior (ingresos gravables luego de deducir las devoluciones, bonificaciones, descuentos, etc.), redondeando el resultado a cuatro decimales.000000000000-976-976-976-976-976-976-976-976-976-976-976-976-976-976-976-976-976-976-976-976-976-976-976-976-976-976-976-976-976-976-976-976-976Coeficiente0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%-42.68%

Pago Anual de Impuesto a la Renta-385-11802-28319898

EGRESOS POR IMPUESTO A LA RENTA (IR)011141924303540455056616161-32400000000000-11802-976-976-976-976-976-976-976-976-976-976-976-3807-976-976-976-976-976-976-976-976-976-976-976-878-976-976-976-976-976-976-976-976-9760098EGRESOS POR IMPUESTOS011141924303540455056616161-32400000000000-11802-976-976-976-976-976-976-976-976-976-976-976-3807-976-976-976-976-976-976-976-976-976-976-976-878-976-976-976-976-976-976-976-976-9760098ESTADOS FINANCIEROSESTADO DE GANANCIAS Y PRDIDASJan-15Feb-15Mar-15Apr-15May-15Jun-15Jul-15Aug-15Sep-15Oct-15Nov-15Dec-15Jan-16Feb-16Mar-16Apr-16May-16Jun-16Jul-16Aug-16Sep-16Oct-16Nov-16Dec-16Jan-17Feb-17Mar-17Apr-17May-17Jun-17Jul-17Aug-17Sep-17Oct-17Nov-17Dec-17Jan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Jan-20Feb-20Mar-20Ingresos por ventas04545677569451134132415131702189120802269226922692269226922692269226922692269226922692269226922692269226922692269226922692269226922692269226922692269226922692269226922692269226922692269226922692269226922692269226922692269226922692269-Costo de Ventas (Gastos Operativos)016831835198721392291244325952747289930513203320332033203320332033203320332033203320332033203320332033203320332033203320332033203320332033203320332033203320332033203320332033203320332033203320332033203320332033203320332033203320332033203=Utilidad Bruta0-1229-1268-1230-1193-1156-1119-1082-1045-1008-971-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-934-Gastos Administrativos4210701666166616661666166616661666166616661666166616661666166616661666166616661666166616661666166616661666166616661666166616661666166616661666166616661666166616661666166616661666166616661666166616661666166616661666166616661666166616661666 - Depreciacin (5 aos)424242424242424242424242424242424242424242424242424242424242424242424242424242424242424242424242424242424242424242424242-Gastos de Ventas0334585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585585-Otros Gastos88100000000000000000000000000000000000000000000000000000000000=Utilidad Operativa-966-2676-3561-3524-3487-3450-3413-3376-3339-3302-3265-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-Gastos Financieros000000000000000000000000000000000000000000000000000000000000+Ingresos Financieros000000000000000000000000000000000000000000000000000000000000=Utilidad antes de Impuestos-966-2676-3561-3524-3487-3450-3413-3376-3339-3302-3265-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-Impuesto a la Renta (30%)000000000000000000000000000000000000000000000000000000000000Utilidad Neta-966-2676-3561-3524-3487-3450-3413-3376-3339-3302-3265-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228-3228

ESTADO DE GANANCIAS Y PRDIDAS ANUAL

Jan-15Feb-15Mar-15Apr-15May-15Jun-15Jul-15Aug-15Sep-15Oct-15Nov-15Dec-15Jan-16Feb-16Mar-16Apr-16May-16Jun-16Jul-16Aug-16Sep-16Oct-16Nov-16Dec-16Jan-17Feb-17Mar-17Apr-17May-17Jun-17Jul-17Aug-17Sep-17Oct-17Nov-17Dec-17Jan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Jan-20Feb-20Mar-20Ingresos por ventas1463427227272272722727227Costo de Ventas (Gastos Operativos)2687238437384373843738437Utilidad Bruta-12238-11210-11210-11210-11210Gastos Administrativos1777519994199941999419994Depreciacin (5 aos)510510510510510Gastos de Ventas61817017701770177017Otros Gastos8810000Utilidad Operativa-37584-38731-38731-38731-38731Gastos Financieros00000Ingresos Financieros00000Utilidad antes de Impuestos-375847000-38731-38731-38731-38731Impuesto a la Renta (30%)210014.35%-11619-11619-11619-11619Utilidad Neta-375841142-27112-27112-27112-27112

FinanciamientoTEA:17.09%TEM:1.32%CUOTAS:36PASTELERA

Jan-15Feb-15Mar-15Apr-15May-15Jun-15Jul-15Aug-15Sep-15Oct-15Nov-15Dec-15Jan-16Feb-16Mar-16Apr-16May-16Jun-16Jul-16Aug-16Sep-16Oct-16Nov-16Dec-16Jan-17Feb-17Mar-17Apr-17May-17Jun-17Jul-17Aug-17Sep-17Oct-17Nov-17Dec-17Jan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Jan-20Feb-20Mar-20En Nuevos Soles ( S/. )FLUJO DE CAJA ECONMICO(10,970.00)(2,879.95)(1,144.98)(648.15)(151.32)345.51325.68719.761,130.461,541.161,951.862,362.561,771.382,611.713,884.412,811.902,811.902,811.902,811.902,811.902,811.902,811.902,811.902,811.901,971.562,811.90(6,120.10)2,011.332,011.332,011.332,011.332,011.332,011.332,011.332,011.332,011.331,171.002,011.33(215.30)2,019.812,019.812,019.812,019.812,019.812,019.812,019.812,019.812,019.811,179.472,019.812,219.432,028.282,028.282,028.282,028.282,028.282,028.282,028.282,028.285,058.600.00.0(450.12) PRESTAMO (PRINCIPAL)10,000.00123456789101112131415161718192021222324252627282930313233343536 CUOTA MENSUAL(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99)(350.99) INTERESES132.35129.45126.52123.55120.54117.49114.40111.27108.10104.88101.6298.3294.9891.5988.1684.6881.1677.5873.9770.3066.5962.8259.0155.1451.2347.2643.2439.1735.0430.8626.6222.3317.9813.579.114.58 PAGO PRINCIPAL218.64221.53224.47227.44230.45233.50236.59239.72242.89246.10249.36252.66256.01259.39262.83266.30269.83273.40277.02280.68284.40288.16291.98295.84299.76303.72307.74311.82315.94320.12324.36328.65333.00337.41341.88346.40 SALDO PRINCIPAL9,781.369,559.839,335.369,107.928,877.488,643.988,407.408,167.687,924.797,678.697,429.327,176.666,920.666,661.266,398.446,132.135,862.305,588.905,311.885,031.204,746.804,458.634,166.663,870.823,571.063,267.332,959.592,647.772,331.832,011.711,687.351,358.691,025.69688.28346.400.00 ESCUDO TRIBUTARIO39.7038.8437.9637.0636.1635.2534.3233.3832.4331.4630.4929.5028.4927.4826.4525.4024.3523.2822.1921.0919.9818.8517.7016.5415.3714.1812.9711.7510.519.267.996.705.394.072.731.38FLUJO DE CAJA FINANCIERO-970.00-3,190.23-1,455.13-958.18-461.2435.6815.94410.10820.861,231.611,642.342,053.061,461.892,302.223,574.902,502.362,502.322,502.262,502.192,502.102,502.002,501.892,501.762,501.611,661.122,501.28-6,430.901,700.321,700.101,699.861,699.611,699.341,699.051,698.741,698.421,698.08857.392,011.33-215.302,019.812,019.812,019.812,019.812,019.812,019.812,019.812,019.812,019.811,179.472,019.812,219.432,028.282,028.282,028.282,028.282,028.282,028.282,028.282,028.285,058.600.00.0-450.12TIR FINANCIERO MENSUAL13.40%TIR FINANCIERO ANUAL352.43%INGRESOS TOTALES89,142.46INVERSIN INICIAL-7,034.79RATIO INGRESO TOTAL/INVERSION TOTAL1267.17%5 aos68.72%anual

PROYECCION EN SOLES POR AO PROYECCIN DE VENTAS EN SOLES POR 5 AOS DE LAMPARASNPRODUCTOP.UAO 1AO 2AO 3AO 4AO 51LAMPARAS16

PROYECCION DE VENTA EN SOLES PROYECCIN DE VENTAS ANUALES EN SOLESNPRODUCTOMES 1MES 2MES 3MES 4MES 5MES 6MES 7MES 8MES 9MES 10MES 11MES 12TOTAL1LAMPARAS ECODEC320.00352.00384.00416.00464.00512.00560.00624.00688.00752.00832.00928.006,832.00202224262932353943475258ANUALPRECIO DE VENTA = S/.16.0016