Formato Financiero-1 (con tabla de amortizacion corregida)

Embed Size (px)

Text of Formato Financiero-1 (con tabla de amortizacion corregida)

PRESUPUESTO DE VENTASPor los periodos que comprenden desde el Ao 1 al Ao 5

PRESUPUESTO DE VENTAS EN UNIDADES PRODUCTO PRINCE OF DARKNESS ROSTRATA CARIBEA VULCANO SPLASH SHE KONG SEXY PINK PANDANUS CORDELINE MIX IRACA PALM ARECA PALM FISH TAIL AO 1 3,500 2,700 2,600 2,800 2,000 1,300 3,000 1,100 2,300 2,100 2,80026,200

AO 2 5,250 4,050 3,900 4,200 3,000 1,950 4,500 1,650 3,450 3,150 4,200

AO 3 7,875 6,075 5,850 6,300 4,500 2,925 6,750 2,475 5,175 4,725 6,300

AO 4 11,813 9,113 8,775 9,450 6,750 4,388 10,125 3,713 7,763 7,088 9,450

AO 5 17,719 13,669 13,163 14,175 10,125 6,581 15,188 5,569 11,644 10,631 14,175

TOTAL 46,156 35,606 34,288 36,925 26,375 17,144 39,563 14,506 30,331 27,694 36,925

PRECIOS DE VENTAPRODUCTO

PRINCE OF DARKNESS ROSTRATA CARIBEA VULCANO SPLASH SHE KONG SEXY PINK PANDANUS CORDELINE MIX IRACA PALM ARECA PALM FISH TAIL

AO 1 4.88 2.50 1.25 4.75 4.75 2.50 0.10 0.25 0.25 0.25 0.25

AO 2 4.98 2.55 1.28 4.85 4.85 2.55 0.10 0.26 0.26 0.26 0.26

AO 3 5.08 2.60 1.30 4.94 4.94 2.60 0.10 0.26 0.26 0.26 0.26

AO 4 5.18 2.65 1.33 5.04 5.04 2.65 0.11 0.27 0.27 0.27 0.27

AO 5 5.28 2.71 1.35 5.14 5.14 2.71 0.11 0.27 0.27 0.27 0.27

TOTAL

25.40 13.01 6.51 24.72 24.72 13.01 0.52 1.30 1.30 1.30 1.30

PRODUCTO

PRINCE OF DARKNESS ROSTRATA CARIBEA VULCANO SPLASH SHE KONG SEXY PINK PANDANUS CORDELINE MIX IRACA PALM ARECA PALM FISH TAILTOTAL

PRESUPUESTO DE VENTAS EN DLARES AO 1 AO 2 AO 3 AO 4 17,080.00 26,132.40 39,982.57 61,173.34 6,750.00 10,327.50 15,801.08 24,175.64 3,250.00 4,972.50 7,607.93 11,640.13 13,300.00 20,349.00 31,133.97 47,634.97 9,500.00 14,535.00 22,238.55 34,024.98 3,250.00 4,972.50 7,607.93 11,640.13 300.00 275.00 575.00 525.00 700.0055,505.00

AO 5 93,595.20 36,988.74 17,809.39 72,881.51 52,058.22 17,809.39 1,643.94 1,506.95 3,150.89 2,876.90 3,835.87304,157.01

TOTAL

237,963.51 94,042.96 45,279.94 185,299.45 132,356.75 45,279.94 4,179.69 3,831.38 8,011.07 7,314.45 9,752.60773,311.75

459.00 420.75 879.75 803.25 1,071.0084,922.65

702.27 643.75 1,346.02 1,228.97 1,638.63129,931.65

1,074.47 984.93 2,059.41 1,880.33 2,507.10198,795.43

COSTO DE MERCADERIAPor los periodos que comprenden desde el AO 1 al AO 5 Expresado en dlares COSTO UNITARIO PRODUCTOSPRESENT.

AO 1

AO 2

AO 3

AO 4

AO 5

PRINCE OF DARKNESS ROSTRATA CARIBEA VULCANO SPLASH SHE KONG SEXY PINK PANDANUS CORDELINE MIX IRACA PALM ARECA PALM FISH TAIL

Unidad Unidad Unidad Unidad Unidad Unidad Unidad Unidad Unidad Unidad Unidad

1.95 1.00 1.10 1.90 1.90 0.90 0.04 0.10 0.10 0.10 0.10

1.97 1.01 1.11 1.92 1.92 0.91 0.04 0.10 0.10 0.10 0.10

1.99 1.02 1.12 1.94 1.94 0.92 0.04 0.10 0.10 0.10 0.10

2.01 1.03 1.13 1.96 1.96 0.93 0.04 0.10 0.10 0.10 0.10

2.03 1.04 1.14 1.98 1.98 0.94 0.04 0.10 0.10 0.10 0.10

CONCEPTO PRINCE OF DARKNESS ROSTRATA CARIBEA VULCANO SPLASH SHE KONG SEXY PINK PANDANUS CORDELINE MIX IRACA PALM ARECA PALM FISH TAIL

RESUMEN DE UNIDADES AO 1 AO 2 3,000 3,900 2,500 3,250 2,600 3,380 1,000 1,300 2,000 2,600 1,300 1,690 3,000 3,900 1,100 1,430 1,300 1,690 1,900 2,470 2,000 2,600

AO 3 5,070 4,225 4,394 1,690 3,380 2,197 5,070 1,859 2,197 3,211 3,380

AO 4 6,591 5,493 5,712 2,197 4,394 2,856 6,591 2,417 2,856 4,174 4,394

AO 5 8,568 7,140 7,426 2,856 5,712 3,713 8,568 3,142 3,713 5,427 5,712

TOTAL COSTOS DE VENTAS CONCEPTO PRINCE OF DARKNESS ROSTRATA CARIBEA VULCANO SPLASH SHE KONG SEXY PINK PANDANUS CORDELINE MIX IRACA PALM ARECA PALM FISH TAIL TOTAL COSTOS DE VENTAS AO 1 5,850 2,500 2,860 1,900 3,800 1,170 120 110 130 190 200 18,830 AO 2 7,681 3,283 3,755 2,495 4,989 1,536 158 144 171 249 263 24,724 AO 3 10,085 4,310 4,931 3,276 6,551 2,017 207 190 224 328 345 32,462 AO 4 13,242 5,659 6,474 4,301 8,602 2,648 272 249 294 430 453 42,623 AO 5 17,387 7,430 8,500 5,647 11,294 3,477 357 327 386 565 594 55,964 TOTAL 54,244.77 23,181.52 26,519.66 17,617.96 35,235.92 10,848.95 1,112.71 1,019.99 1,205.44 1,761.80 1,854.52 174,603

Por los periodo que comprenden desde el Ao 1 al Ao 5 Expresado en dlaresCENTRO DE COSTO: PERSONAL SUELDOS BENEFICIOS SOCIAL CAPACITACION Y ENTRENAMIENTO TOTAL SERVICIOS BASICOS ENERGIA ELECTRICA AGUA POTABLE TELEFONO INTERNET TELEFONIA CELULAR TOTAL GASTOS LEGALES Y TASAS NOTARIALES REGISTRO PROPIEDAD INTELECTUAL (IEPI) PERMISOS MUNICIPALES VALLA PUBLICITARIA TOTAL MANTENIMIENTO Y REPARACIONES EQUIPOS DE OFICINA EQUIPO DE COMPUTO Y COMUNICACIONES TOTAL DEPRECIACIONES Y AMORTIZACIONES DEPRECIACIONES TOTAL OTROS ALQUILER MATERIALES DE ASEO SUMINISTROS DE OFICINA TOTAL TOTAL CENTRO DE COSTO Y/O GESTION AO 1 8,640.00 3,963.84 200.00 12,803.84 180.00 88.00 48.00 24.00 0.00 340.00 30.00 400.00 0.00 430.00 30.00 50.00 80.00 2,529.33 2,529.33 7,200.00 100.00 450.00 7,750.00 23,933.17 AO 2 8,812.80 4,043.12 204.00 13,059.92 189.00 92.40 50.40 25.20 0.00 357.00 AO 3 8,989.06 4,123.98 208.08 13,321.12 198.45 97.02 52.92 26.46 0.00 374.85 AO 4 9,168.84 4,206.46 212.24 13,587.54 208.37 101.87 55.57 27.78 0.00 393.59 AO 5 9,352.21 4,290.59 216.49 13,859.29 218.79 106.96 58.34 29.17 0.00 413.27 TOTAL 44,962.91 20,627.98 1,040.81 66,631.70 994.61 486.26 265.23 132.62 0.00 1,878.71 30.00 400.00 0.00 430.00 156.12 260.20 416.32 11,880.00 11,880.00 7,949.38 520.40 2,341.82 10,811.60 92,048.34

GASTOS DE ADMINISTRACION

0.00 0.00 30.60 51.00 81.60 2,529.33 2,529.33 7,344.00 102.00 459.00 7,905.00 23,932.85

0.00 0.00 31.21 52.02 83.23 2,529.33 2,529.33 7,490.88 104.04 468.18 8,063.10 24,371.63

0.00 0.00 31.84 53.06 84.90 2,146.00 2,146.00 7,640.70 106.12 477.54 8,224.36 24,436.39

0.00 0.00 32.47 54.12 86.59 2,146.00 2,146.00 7,793.51 108.24 487.09 8,388.85 24,894.00

Por el periodo que comprenden desde el Ao 1 al Ao 5 Expresado en dlaresCENTRO DE COSTO: PERSONAL SUELDOS BENEFICIOS SOCIALES UNIFORMES PROMOTOR CAPACITACION Y ENTRENAMIENTO TOTAL SERVICIOS BASICOS ENERGIA ELECTRICA AGUA POTABLE TELEFONO INTERNET TELEFONIA CELULAR RADIO FRECUENCIA TOTAL REPRESENTACION Y REL. PUBLICAS VIATICOS GASTOS DE GESTION TOTAL MANTENIMIENTO Y REPARACIONES EQUIPOS DE OFICINA EQUIPO DE COMPUTO Y COMUNICACIONES COMBUSTIBLE MANTENIMIENTO DE VEHICULO TOTAL DEPRECIACIONES DEPRECIACION TOTAL OTROS MATERIALES DE ASEO SUMINISTROS DE OFICINA TOTAL TOTAL CENTRO DE COSTO Y/O GESTION AO 1 5,760.00 2,379.84 0.00 200.00 8,339.84 420.00 132.00 192.00 216.00 200.00 0.00 1,160.00 1,000.00 500.00 1,500.00 50.00 50.00 1,000.00 50.00 1,150.00 2,529.33 2,529.33 50.00 50.00 100.00 AO2 5,875.20 2,427.44 0.00 204.00 8,506.64 441.00 138.60 201.60 226.80 210.00 630.00 1,848.00 1,020.00 510.00 1,530.00 51.00 51.00 1,020.00 51.00 1,173.00 2,529.33 2,529.33 51.00 51.00 102.00 AO 3 5,992.70 2,475.99 0.00 208.08 8,676.77 463.05 145.53 211.68 238.14 220.50 661.50 1,940.40 1,040.40 520.20 1,560.60 52.02 52.02 1,040.40 52.02 1,196.46 2,529.33 2,529.33 52.02 52.02 104.04 16,007.60 AO 4 6,112.56 2,525.51 0.00 212.24 8,850.30 486.20 152.81 222.26 250.05 231.53 694.58 2,037.42 1,061.21 530.60 1,591.81 53.06 53.06 1,061.21 53.06 1,220.39 2,146.00 2,146.00 53.06 53.06 106.12 15,952.05 AO 5 6,234.81 2,576.02 0.00 216.49 9,027.31 510.51 160.45 233.38 262.55 243.10 729.30 2,139.29 1,082.43 541.22 1,623.65 54.12 54.12 1,082.43 54.12 1,244.80 2,146.00 2,146.00 54.12 54.12 108.24 16,289.29 TOTAL 29,975.27 12,384.78 0.00 1,040.81 43,400.86 2,320.77 729.38 1,060.92 1,193.54 1,105.13 2,715.38 9,125.11 5,204.04 2,602.02 7,806.06 260.20 260.20 5,204.04 260.20 5,984.65 11,880.00 11,880.00 260.20 260.20 520.40 78,717.08

GASTOS DE VENTAS

14,779.17 15,688.97

GASTOS DE PUBLICIDADPor el periodo que comprenden desde el Ao 1 al Ao 5 Expresado en dlares

PRODUCTOHORARIOS IMPRESOS FULL COLOR GUINDOLAS AFICHES HOJAS DE INDUCCION PUBLICIDAD RADIO EVENTOS Y FERIAS DE INDUCCION ANUNCIOS DE REVISTA LONA PUBLICITARIA TOTAL

AO 1100.00 0.00 50.00 80.00 0.00 230.00 150.00 100.00 710.00

AO 2102.00 0.00 51.00 81.60 0.00 234.60 153.00 102.00 724.20

AO 3104.04 0.00 52.02 83.23 0.00 239.29 156.06 104.04 738.68

AO 4106.12 0.00 53.06 84.90 0.00 244.08 159.18 106.12 753.46

AO 5108.24 0.00 54.12 86.59 0.00 248.96 162.36 108.24 768.53

TOTAL520.40 0.00 260.20 416.32 0.00 1,196.93 780.61 520.40 3,694.87

FLUJO DE EFECTIVOPor el periodo que comprenden desde el Ao 1 al Ao 5 Expresado en dlaresAO 0 INGRESOS Ventas Aporte de accionistas Prstamos bancarios Total Ingresos EGRESOS Gastos de Administracin Gastos de Ventas (-) Depreciaciones Gastos de Publicidad Compra de Activos Fijos Prestamo Bancario Inters Participacin de Trabaj. Impuestos (-) Depreciaciones Total Egresos Flujo Neto Anual Flujo Acumulado 12,610.00 9,855.59 9,855.59 2,529.33 39,833.52 15,671.48 25,527.07 12,610.00 21,403.84 14,779.17 -2,529.33 710.00 21,403.52 15,688.97 -2,529.33 724.20 0.00 0.00 0.00 0.00 2,529.33 37,816.69 47,105.96 72,633.03 21,842.30 16,007.60 -2,529.33 738.68 0.00 0.00 2,841.42 4,025.34 2,529.33 45,455.35 84,476.31 157,109.34 0.00 8,345.75 11,823.14 2,146.00 59,164.78 139,630.65 296,739.98 0.00 17,180.02 24,338.36 2,146.00 81,324.20 222,832.81 519,572.79 22,290.39 15,952.05 -2,146.00 753.46 22,748.00 16,289.29 -2,146.00 768.53 11,232.79 11,232.79 22,465.59 55,505.00 84,922.65 129,931.65 198,795.43 304,157.01 55,505.00 84,922.65 129,931.65 198,795.43 304,157.01 773,311.75 11,232.79 11,232.79 773,311.75 0.00 109,688.05 78,717.08 -11,880.00 3,694.87 12,610.00 1,850.93 1,089.58 28,367.19 40,186.85 11,880.00 276,204.54 497,107.21 AO 1 AO 2 AO 3 AO 4 AO 5 TOTALES

0.001,850.93 1,089.58

TABLA DE AMORTIZACION PRESTAMOPRINCIPAL INTERES DIVIDENDO Ao 1 Ao 2 Ao 3 Ao 4 Ao 5 11,232.79 9,381.87 7,351.40 5,123.98 2,680.50 1,089.58 910.04 713.09 497.03 260.01 2,940.51 2,940.51 2,940.51 2,94