InversionCUADRO DE INVERSIONESRUBROMONTO(AO 0)ACTIVO FIJO330000.00Terrenos80000.00Local para Ensamblaje200000.00Mobiliario y Equipo50000.00Gastos Preoperativos50000.00TOTAL380000.00

DepreDEPRECIACINRUBROTIEMPO (AOS)VALOR RESIDUALTerrenos10100.00%Local para Ensamblaje1030.00%Mobiliario y Equipo50.00%DEPRECIACIONAOVALOR12345678910VALOR RESIDUALINICIALDEPRECIACINTerrenos80000.000.000.000.000.000.000.000.000.000.000.0080000.00Local para Ensamblaje200000.0014000.0014000.0014000.0014000.0014000.0014000.0014000.0014000.0014000.0014000.0060000.00Mobiliario y Equipo50000.0010000.0010000.0010000.0010000.0010000.000.000.000.000.000.000.00TOTAL DEPRECIACIN24000.0024000.0024000.0024000.0024000.0014000.0014000.0014000.0014000.0014000.00140000.00

ServDeudaDATOS PRESTAMORUBROMONTO(AO 0)Fondos Propios60%Prstamo (%)40%Monto del Prstamo152000.00Modalidad de pagoAnualidadesTasa de inters anual8.5%Plazo, en aos2Pagos por ao12CUADRO DE SERVICIO A LA DEUDA EMPRESAMonto del Prstamo152000.00Tasa de inters anual8.50%Tasa de Interes Mensual0.68%Plazo, en aos5Pagos por ao12PerodoSaldoIntersCapitalPagoinicial(Amortizac.)(Anualidad)0152000.001149941.321036.872058.683095.552147868.601022.822072.723095.553145781.741008.682086.863095.554143680.64994.452101.103095.555141565.22980.122115.433095.556139435.36965.692129.863095.557137290.97951.162144.393095.558135131.95936.532159.023095.559132958.21921.802173.743095.5510130769.64906.972188.573095.5511128566.14892.042203.503095.5512126347.61877.012218.533095.5513124113.94861.882233.673095.5514121865.04846.642248.903095.5515119600.79831.302264.243095.5516117321.10815.862279.693095.5517115025.86800.312295.243095.5518112714.97784.652310.903095.5519110388.31768.882326.663095.5520108045.78753.012342.533095.5521105687.26737.032358.513095.5522103312.66720.942374.603095.5523100921.87704.752390.803095.552498514.76688.442407.113095.552596091.23672.022423.533095.552693651.17655.492440.063095.552791194.47638.842456.703095.552888721.00622.082473.463095.552986230.67605.212490.343095.553083723.35588.222507.323095.553181198.92571.122524.433095.553278657.27553.902541.653095.553376098.29536.562558.993095.553473521.85519.102576.443095.553570927.83501.532594.023095.553668316.12483.832611.713095.553765686.59466.022629.533095.553863039.13448.082647.463095.553960373.60430.022665.523095.554057689.90411.842683.713095.554154987.88393.532702.013095.554252267.44375.102720.453095.554349528.43356.542739.003095.554446770.75337.862757.693095.554543994.25319.052776.503095.554641198.81300.112795.443095.554738384.30281.042814.513095.554835550.59261.842833.713095.554932697.56242.512853.043095.555029825.06223.052872.503095.555126932.96203.452892.093095.555224021.14183.722911.823095.555321089.46163.862931.693095.555418137.77143.862951.683095.555515165.96123.732971.823095.555612173.86103.452992.093095.55579161.3683.043012.503095.55586128.3162.493033.053095.55593074.5741.803053.743095.5560(0.0020.973074.573095.55TOTALES33732.70152000.00185732.70

IngresosAnual Unidades2,600.002,700.002,863.003,044.003,116.00TrimestresT1T2T3T4T1T2T3T4T1T2T3T4T1T2T3T4T1T2T3T4Unidades650650650650660.00670.00680.00690.00700.00710.00721.00732.00743.00755.00767.00779.00779.00779.00779.00779.00Precio800800800800800800800800800800800800800800800800800800800800Ingresos520000520000520000520000528000536000544000552000560000568000576800585600594400604000613600623200623200623200623200623200Contado 50%260000260000260000260000264000268000272000276000280000284000288400292800297200302000306800311600311600311600311600311600Saldo 50%260000260000260000260000264000268000272000276000280000284000288400292800297200302000306800311600311600311600Total Ingresos260,000260,000520,000520,000524,000528,000536,000544,000552,000560,000568,400576,800585,600594,800604,000613,600618,400623,200623,200623,200

EGyPESTADO DE RESULTADOS PROYECTADOAO12345678910RUBROINGRESOSIngresos y Ventas1560000.001824000.002092000.002108000.002132000.002160000.002192000.002224400.002257200.002290800.00EGRESOSCostos de Venta1300000.001350000.001431500.001522000.001558000.001558000.001558000.001558000.001558000.001558000.00Costos Variables78000.0091200.00104600.00105400.00106600.00108000.00109600.00111220.00112860.00114540.00Personal20000.0020000.0020000.0020000.0020000.0020000.0020000.0020000.0020000.0020000.00Suministros75000.0075000.0075000.0075000.0075000.0075000.0075000.0075000.0075000.0075000.00Servicios30000.0030000.0030000.0030000.0030000.0030000.0030000.0030000.0030000.0030000.00Publicidad78000.0091200.00104600.00105400.00106600.00108000.00109600.00111220.00112860.00114540.000.000.000.000.000.000.000.000.000.000.00UTILIDAD DE OPERACION(21000.00166600.00326300.00250200.00235800.00261000.00289800.00318960.00348480.00378720.00Gastos Financieros11494.159313.696947.904381.021595.950.000.000.000.000.00Depreciacion24000.0024000.0024000.0024000.0024000.0014000.0014000.0014000.0014000.0014000.00UTILIDAD NETA(56494.15133286.31295352.10221818.98210204.05247000.00275800.00304960.00334480.00364720.00Impuestos0.0039985.8988605.6366545.6963061.2274100.0082740.0091488.00100344.00109416.00UTILIDAD DESPUS DE IMPUESTOS(56494.1593300.41206746.47155273.29147142.84172900.00193060.00213472.00234136.00255304.00Impuesto a la renta30%

FlujoCajaTASA A UTILIZAR PARA LA EVALUACIN DEL PROYECTODATOCC Propio = CC PrestadoCC Propio < CC PrestadoCC Propio > CC PrestadoTASA A UTILIZARCK Propio25.00%0.00%0.00%25.00%25.00%CK Prestado8.50%0.00%0.00%8.50%25.00%FLUJO DE CAJA PROYECTADOAO012345678910RUBROBENEFICIOSUtilidad de Operacin -Deprec(19700.00167900.00327600.00251500.00237100.00262300.00291100.00320260.00349780.00380020.00COSTOSActivo Fijo(330000.000.000.000.000.000.000.000.000.00140000.00Capital de Trabajo(50000.000.000.000.000.000.000.000.000.0050000.00Impuestos0.00(39985.89(88605.63(66545.69(63061.22(74100.00(82740.00(91488.00(100344.00(109416.00TOTAL FLUJO DE CAJA ECONOMICO(380000.00(19700.00127914.11238994.37184954.31174038.78188200.00208360.00228772.00249436.00460604.00152000.00Amortizacin Deuda25652.3927832.8530198.6432765.5235550.590.000.000.000.000.00Intereses11494.159313.696947.904381.021595.950.000.000.000.000.00TOTAL FLUJO DE CAJA FINANCIERO(228000.00(56846.5490767.57201847.83147807.76136892.24188200.00208360.00228772.00249436.00460604.00CALCULO DEL PERIODO DE RECUPERO ECONOMICO012345678910V.A.(380000.00-15,760.0081,865.03122,365.1275,757.2857,029.0349,335.5043,696.2638,381.5733,478.7349,456.98V.A. ACUMULADO(380000.00(395760.00(313894.97(191529.85(115772.57(58743.54(9408.0434288.2272669.79106148.52155605.50PRI ECONOMICO0.000.000.000.000.000.000.006.220.000.000.00CALCULO DEL PERIODO DE RECUPERO FINANCIERO012345678910V.A.(228000.00-45,477.2358,091.24103,346.0960,542.0644,856.8549,335.5043,696.2638,381.5733,478.7349,456.98V.A. ACUMULADO(228000.00(273477.23(215385.99(112039.90(51497.84(6640.9942694.5186390.77124772.34158251.07207708.05PRI FINANCIERO0.000.000.000.000.000.005.130.000.000.000.00CUADRO 6CUADRO 7EVALUACION ECONOMICAEVALUACION FINANCIERAVANE155605.50VANF207708.05TIRE33.81%TIRF40.40%CONVIENE PRESTAMO