corrida ferreteria fappa promete 2014

50
SECRETARIA DE AGRICULTURA, GANADERÍA, DESARROLLO RURAL, PESCA Y ALIMENTACIÓ FORMATO: CORRIDA FINANCIERA PROGRAMAS FAPPA Y PROMETE NOMBRE DEL PROYECTO: FERRETERIA A B CALCULOS TECNICOS B.I. B. II. C PROYECCION FINANCIERA MINIMA A 5 AÑOS. C.I. C.II. C.III. C.IV D ANALISIS DE RENTABILIDAD D.I. D.II. PRESUPUESTO DE INVERSION MEMORIAS DE CALCULO PROYECCION DE COSTOS COSTOS TOTALES PROYECCION DE INGRESOS ESTADO DE RESULTADOS FLUJO DE EFECTIVO PUNTO DE EQUILIBRIO ANALISIS DE RENTABILIDAD (VAN, TIR, B/C)

Upload: benjamin-jimenez-solano

Post on 23-Nov-2015

71 views

Category:

Documents


17 download

TRANSCRIPT

INDICE

SECRETARIA DE AGRICULTURA, GANADERA, DESARROLLO RURAL, PESCA Y ALIMENTACINFORMATO: CORRIDA FINANCIERA PROGRAMAS FAPPA Y PROMETE

NOMBRE DEL PROYECTO: FERRETERIA

APRESUPUESTO DE INVERSION BCALCULOS TECNICOSB.I. MEMORIAS DE CALCULOB. II. PROYECCION DE COSTOSCPROYECCION FINANCIERA MINIMA A 5 AOS.C.I. COSTOS TOTALESC.II. PROYECCION DE INGRESOSC.III. ESTADO DE RESULTADOSC.IV FLUJO DE EFECTIVODANALISIS DE RENTABILIDADD.I. PUNTO DE EQUILIBRIOD.II. ANALISIS DE RENTABILIDAD (VAN, TIR, B/C)

INVERSIONESINDICEFERRETERIAPRESUPUESTO DE INVERSIONCONCEPTOS
SAUL BAUTISTA: ENLISTARAN TODOS LOS ARTICULOS A ADQUIRIR CON EL RECURSO DEL PROGRAMA.UNIDAD
SAUL BAUTISTA: MEDIDA DE COMPRA DE LOS ARTICULOSCANTIDAD
SAUL BAUTISTA: CANTIDAD DE ARTICULOS ADQUIRIR = A SOLICITADOS EN ANEXO ACOSTO UNITARIO
SAUL BAUTISTA: COSTO DE COMPRA DE LOS ARTICULOS A ADQUIRIRMONTOSPROGRAMASOCIOSTOTALACTIVO FIJO
SAUL BAUTISTA: BIENES DURADEROS PARA EL FUNCIONAMIENTO DEL PROYECTOJUEGOS DE ESTANTES CON SUS CHAROLASjuego331,160.00$38,280.00$38,280.00$38,280.00GONDOLA DE EXHIBICION 5 PELDAOS SIMPLEpieza62,291.00$13,746.00$13,746.00$13,746.00GONDOLA DE EXHIBICION DOBLEpieza64,582.00$27,492.00$27,492.00$27,492.00CAJA REGISTRADORA 500 FUNCIONES EN MEMORIA 12 DEPTpieza18,242.00$8,242.00$8,242.00$8,242.00VITRINAS 1.80 MTS CON 32 CAJONES CON VIDRIOSpieza411,492.00$45,968.00$45,968.00$45,968.00VITRINA 1.80 MTS DE ALTO X 2 MTSpieza213,920.00$27,840.00$27,840.00$27,840.00CAJA TORNILLERApieza25,220.00$10,440.00$10,440.00$10,440.00MOSTRADOR METALICOpieza17,992.00$7,992.00$7,992.00$7,992.000.00.00.00.00.00.00.00.00.00.00.00.0

ACTIVO DIFERIDO
SAUL BAUTISTA: SON GASTOS PAGADOS POR ANTICIPADO PERO NECESARIOS PARA LA APERTURA DEL PROYECTOASISTENCIA TECNICAPRESUPUESTO118,000.00$18,000.00$18,000.00$18,000.00

CAPITAL DE TRABAJO
SAUL BAUTISTA: INSUMOS DE PRONTA UTILIZACION INDISPENSABLES PARA LA OPERACIN DEL PROYECTOCapital de trabajo para el primer aopresupuesto1$179,930.80$179,930.80$179,930.80$179,930.80

TOTAL$377,930.80$198,000.00$179,930.80$377,930.80

MEMORIA CALCULOSINDICEMemorias de calculoMemorias de calculoCLAVEDESCRIPCIONCANTIDAD COSTOTOTALPrecio de ventaIngresos por ventas mensualesIngresos por ventas Ao 1Barreta de punta 7/8x1m6$145.00$870.00$166.75$1,000.50$12,006.00Grifa con dos bocas de 3/8-1/23$95.00$285.00$109.25$327.75$3,933.00Bieldo de paja de 68$255.00$2,040.00$293.25$2,346.00$28,152.00Carretilla 55 llanta negra6$605.00$3,630.00$695.75$4,174.50$50,094.00Carretilla pasturera 100 ft36$865.00$5,190.00$994.75$5,968.50$71,622.00Llanta para carretilla reforzada completa12$210.00$2,520.00$241.50$2,898.00$34,776.00Cintal teflon de 1/2x7 m500$3.00$1,500.00$3.45$1,725.00$20,700.00Cuchara forjada de 6 truper24$95.00$2,280.00$109.25$2,622.00$31,464.00Desarmador plano de 1/4x636$24.00$864.00$27.60$993.60$11,923.20Desarmador plano de 5/16x636$32.00$1,152.00$36.80$1,324.80$15,897.60Juego de 5 desarmadores truper36$85.00$3,060.00$97.75$3,519.00$42,228.00Guante de algodn con puntos pvc48$16.00$768.00$18.40$883.20$10,598.40Guante de piel de borrego corto48$185.00$8,880.00$212.75$10,212.00$122,544.00Guante piel borrego48$129.00$6,192.00$148.35$7,120.80$85,449.60Escoba metalica reforzada 18d6$65.00$390.00$74.75$448.50$5,382.00Escoba metal/plastico 22 dientes6$67.50$405.00$77.63$465.75$5,589.00Flexometro contra impacto 3 m6$35.00$210.00$40.25$241.50$2,898.00Flexometro contra impacto 5 m6$55.00$330.00$63.25$379.50$4,554.00Flexometro contra impacto 8 m6$95.00$570.00$109.25$655.50$7,866.00Flexometro contra impacto 10 m6$145.00$870.00$166.75$1,000.50$12,006.00Flexometro con magneto en punta 3 m6$35.00$210.00$40.25$241.50$2,898.00Flexometro con magneto en punta 5 m6$55.00$330.00$63.25$379.50$4,554.00Flexometro con magneto en punta 8 m6$95.00$570.00$109.25$655.50$7,866.00Hacha media labor de 3lbs sin mango4$95.00$380.00$109.25$437.00$5,244.00Hacha media labor de 31/2 lbs4$105.00$420.00$120.75$483.00$5,796.00Hacha media labor de 4 lbs sin mango4$115.00$460.00$132.25$529.00$6,348.00Hacha labor entera de 2 1/2 kbs4$85.00$340.00$97.75$391.00$4,692.00Hacha labor entera de 3 lbs sin mango4$95.00$380.00$109.25$437.00$5,244.00Hacha labor entera de 3 1/2 lbs4$105.00$420.00$120.75$483.00$5,796.00Hacha labor entera de 4 lbs s/mango4$115.00$460.00$132.25$529.00$6,348.00Lona de 2x3 m truper6$90.00$540.00$103.50$621.00$7,452.00Lona de 3x3 m truper6$135.00$810.00$155.25$931.50$11,178.00Lona de 4x5 m truper6$295.00$1,770.00$339.25$2,035.50$24,426.00Lona de 4x6 m truper6$345.00$2,070.00$396.75$2,380.50$28,566.00Lona de 5x6 m truper6$435.00$2,610.00$500.25$3,001.50$36,018.00Lona de 6x12 m truper6$990.00$5,940.00$1,138.50$6,831.00$81,972.00Lona de 12x17 m truper6$2,850.00$17,100.00$3,277.50$19,665.00$235,980.00Lona de polietileno6$90.00$540.00$103.50$621.00$7,452.00Llave espaola de 7/1636$32.00$1,152.00$36.80$1,324.80$15,897.60Juego de 6 llaves comb milim12$215.00$2,580.00$247.25$2,967.00$35,604.00Juego de 6 llaves comb std12$215.00$2,580.00$247.25$2,967.00$35,604.00Juego de 11 llaves comb milim8$435.00$3,480.00$500.25$4,002.00$48,024.00Juego de 11 llaves comb std8$475.00$3,800.00$546.25$4,370.00$52,440.00Llave p/tubo de 8 stilson6105$630.00$120.75$724.50$8,694.00Llave p/tubo de 10 stilson6$135.00$810.00$155.25$931.50$11,178.00Llave p/tubo de 12 stilson6$175.00$1,050.00$201.25$1,207.50$14,490.00Llave p/tubo de 14 stilson6$225.00$1,350.00$258.75$1,552.50$18,630.00Llave para tubo stilson de aluminio 126$215.00$1,290.00$247.25$1,483.50$17,802.00Llave para tubo stilson de aluminio 146$265.00$1,590.00$304.75$1,828.50$21,942.00Llave para tubo stilson de aluminio 106$175.00$1,050.00$201.25$1,207.50$14,490.00Martillo curva pulido 724$65.00$1,560.00$74.75$1,794.00$21,528.00Martillo curva pulido 1624$89.00$2,136.00$102.35$2,456.40$29,476.80Martillo promo 16 curva24$59.00$1,416.00$67.85$1,628.40$19,540.80Martillo promo 16 recta24$59.00$1,416.00$67.85$1,628.40$19,540.80Martillo recta de 16 promo6$49.00$294.00$56.35$338.10$4,057.20Pala cuadrada mango y clasic3$110.00$330.00$126.50$379.50$4,554.00Pala cuadrada mango y promo3$95.00$285.00$109.25$327.75$3,933.00Pala cuadrada mango largo promo3$95.00$285.00$109.25$327.75$3,933.00Pinza electricista 73$62.00$186.00$71.30$213.90$2,566.80Pinza electricista 83$69.00$207.00$79.35$238.05$2,856.60Niple de laton para equipo de aire36$12.00$432.00$13.80$496.80$5,961.60Manguera para aire4$69.00$276.00$79.35$317.40$3,808.80Lima triangulo pesado 66$15.00$90.00$17.25$103.50$1,242.00Lima triangulo pesado 76$19.00$114.00$21.85$131.10$1,573.20Lima triangulo pesado 86$28.00$168.00$32.20$193.20$2,318.40Martillo de curva 16 oz24$75.00$1,800.00$86.25$2,070.00$24,840.00Grifa de dos curvas de 3/4 y 5/83$95.00$285.00$109.25$327.75$3,933.00Juego de 3 minipinzas12$79.00$948.00$90.85$1,090.20$13,082.40Juego de 4 desarmadores mango tra36$48.00$1,728.00$55.20$1,987.20$23,846.40Juego de 8 desarmadores mango tra24$99.00$2,376.00$113.85$2,732.40$32,788.80Juego de 6 desarmadores mango t24$75.00$1,800.00$86.25$2,070.00$24,840.00Juego de 8 desarmadores mango bic24$110.00$2,640.00$126.50$3,036.00$36,432.00Llave ajustable de 6 pretul6$38.00$228.00$43.70$262.20$3,146.40Llave ajustable de 8 pretul6$49.00$294.00$56.35$338.10$4,057.20Llave ajustable de 10 pretul6$69.00$414.00$79.35$476.10$5,713.20Llave ajustable de 12 pretul6$95.00$570.00$109.25$655.50$7,866.00Llave ajustable pavonada 66$38.00$228.00$43.70$262.20$3,146.40Llave ajustable pavonada 86$49.00$294.00$56.35$338.10$4,057.20Llave ajustable pavonada 10 p6$69.00$414.00$79.35$476.10$5,713.20Llave ajustable pavonada 12 p6$95.00$570.00$109.25$655.50$7,866.00Llave espaola de 1/4 x 5/1612$13.00$156.00$14.95$179.40$2,152.80Llave espaola de 5/6 x 3/812$14.00$168.00$16.10$193.20$2,318.40Llave espaola de 3/8 x 7/1612$16.00$192.00$18.40$220.80$2,649.60Llave espaola de 7/16 x 1/2 p12$17.00$204.00$19.55$234.60$2,815.20Juego de 9 llaves comb3$185.00$555.00$212.75$638.25$7,659.00Martillo curva 16 oz pretul6$45.00$270.00$51.75$310.50$3,726.00Juego de 3 pinzas12$87.00$1,044.00$100.05$1,200.60$14,407.20Cerrojo lb doble cilindro pretul12$105.00$1,260.00$120.75$1,449.00$17,388.00Martillo curva 7 oz pretul6$35.00$210.00$40.25$241.50$2,898.00Niple acero cuerda 1/4 npt pretul36$8.00$288.00$9.20$331.20$3,974.40Candado de laton 20 mm12$50.00$600.00$57.50$690.00$8,280.00Clavo fosfatado 3/41$27.00$27.00$31.05$31.05$372.60Clavo fosfatado 1n1$27.00$27.00$31.05$31.05$372.60Clavo fosfatado 1 1/2n1$27.00$27.00$31.05$31.05$372.60Clavo fosfatado 2n1$27.00$27.00$31.05$31.05$372.60Clavo fosfatado 3n1$27.00$27.00$31.05$31.05$372.60Clavo fosfatado 3 1/2n1$27.00$27.00$31.05$31.05$372.60Clavo con cabeza para madera de pu1$27.00$27.00$31.05$31.05$372.601/4 clavo con cabeza para madera1$27.00$27.00$31.05$31.05$372.601/2 clavo con cabeza para madera1$27.00$27.00$31.05$31.05$372.602 clavo con cabeza para madera1$16.00$16.00$18.40$18.40$220.802 1/2 clavo con cabeza para madera1$16.00$16.00$18.40$18.40$220.803 clavo con cabeza para madera1$16.00$16.00$18.40$18.40$220.803 1/2 clavo con cabeza para madera1$16.00$16.00$18.40$18.40$220.80Multicontacto de 8 entradas36$63.00$2,268.00$72.45$2,608.20$31,298.40Multicontacto de 6 entradas36$42.00$1,512.00$48.30$1,738.80$20,865.60Fusible economico con jaladera50$5.00$250.00$5.75$287.50$3,450.00Fusible reforzado con 30 A 100.000 $13.00$1,300.00$14.95$1,495.00$17,940.00Par de fusibles economicos 30b100.000 $15.00$1,500.00$17.25$1,725.00$20,700.00Par de fusibles economicos 30ab100.000 $15.00$1,500.00$17.25$1,725.00$20,700.00Extension electrica de uso rudo 6x164.000 $62.00$248.00$71.30$285.20$3,422.40Extension electrica de uso rudo 8x162.000 $87.00$174.00$100.05$200.10$2,401.20Extension electrica de uso rudo 10x162.000 $105.00$210.00$120.75$241.50$2,898.00Extension electrica de uso rudo 12x162.000 $122.00$244.00$140.30$280.60$3,367.20Foco ahorrador espiral 15e24.000 $37.80$907.20$43.47$1,043.28$12,519.36Foco ahorrador espiral 20e24.000 $40.50$972.00$46.58$1,117.80$13,413.60Foco ahorrador espiral 20efc24.000 $40.50$972.00$46.58$1,117.80$13,413.60Foco ahorrador espiral f24e24.000 $44.10$1,058.40$50.72$1,217.16$14,605.92Foco ahorrador cuadruple u20w80024.000 $52.20$1,252.80$60.03$1,440.72$17,288.64Foco ahorrador cuadruple u28w80024.000 $55.80$1,339.20$64.17$1,540.08$18,480.96Foco ahorrador cuadruple 28wcal24.000 $55.80$1,339.20$64.17$1,540.08$18,480.96Manguera revestida de acero inox36.000 $45.00$1,620.00$51.75$1,863.00$22,356.00Manguera de caucho 0636.000 $29.00$1,044.00$33.35$1,200.60$14,407.20Manguera de caucho 1036.000 $35.00$1,260.00$40.25$1,449.00$17,388.00Manguera de caucho 1536.000 $45.00$1,620.00$51.75$1,863.00$22,356.00Manguera de caucho 2036.000 $53.00$1,908.00$60.95$2,194.20$26,330.40Manguera de caucho 3036.000 $69.00$2,484.00$79.35$2,856.60$34,279.20Manguera de caucho 4036.000 $87.00$3,132.00$100.05$3,601.80$43,221.60Manguera de caucho 5036.000 $105.00$3,780.00$120.75$4,347.00$52,164.00Exhibidor giratorio para palas1.000 $750.00$750.00$862.50$862.50$10,350.00Exhibidor para herramientas mango largo1.000 $750.00$750.00$862.50$862.50$10,350.00Gancho recto de 9c360.000 $18.00$6,480.00$20.70$7,452.00$89,424.00Rack para 3 carretillas estibada2.000 $1,000.00$2,000.00$1,150.00$2,300.00$27,600.00Panel exhibidor truper 60x14014.000 $500.00$7,000.00$575.00$8,050.00$96,600.00Rach de alto impacto nacional1 $1,300.00$1,300.00$1,495.00$1,495.00$17,940.000.00.00.00.00.00.0TOTAL$179,930.80$206,920.42$2,483,045.04Pago de Servicios y Costos de Mantenimiento de equipo

ConceptoPago MensualLuz$300.00Telefono$1,500.00Agua$80.00Mantenimiento vehiculo$2,000.00Imprevistos$500.00Costos de Salarios y Mano de Obra

ConceptoSueldo diarioCantidadCosto SemanalCosto MensualMano de obra170.002.002,040.008,160.00Administrador 200.001.001,200.004,800.00Chofer170.001.001,020.004,080.00Costos de otros insumosConceptoCosto MensualPapel periodico para envolver$450.00Bolsas de plastico$500.00Papel de estrasa$600.00

COSTOSINDICEFERRETERIAProyeccion de Costos Mensuales

ConceptoEneFebMarAbrMayJunJulAgoSepOctNovDicTotalCostos VariablesCompra de productos*0.0$179,930.80$179,930.80$179,930.80$179,930.80$179,930.80$179,930.80$179,930.80$179,930.80$179,930.80$179,930.80$179,930.80$1,979,238.80Papel periodico para envolver$450.00$450.00$450.00$450.00$450.00$450.00$450.00$450.00$450.00$450.00$450.00$450.00$5,400.00Bolsas de plastico$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$6,000.00Papel de estrasa$600.00$600.00$600.00$600.00$600.00$600.00$600.00$600.00$600.00$600.00$600.00$600.00$7,200.000.00.0Total de costos variables$1,550.00$181,480.80$181,480.80$181,480.80$181,480.80$181,480.80$181,480.80$181,480.80$181,480.80$181,480.80$181,480.80$181,480.80$1,997,838.80* En el primer mes la compra de productos va como inversion en capital de trabajoCostos FijosMano de obra$8,160.00$8,160.00$8,160.00$8,160.00$8,160.00$8,160.00$8,160.00$8,160.00$8,160.00$8,160.00$8,160.00$8,160.00$97,920.00Administrador $4,800.00$4,800.00$4,800.00$4,800.00$4,800.00$4,800.00$4,800.00$4,800.00$4,800.00$4,800.00$4,800.00$4,800.00$57,600.00Chofer$4,080.00$4,080.00$4,080.00$4,080.00$4,080.00$4,080.00$4,080.00$4,080.00$4,080.00$4,080.00$4,080.00$4,080.00$48,960.00Luz$300.00$300.00$300.00$300.00$300.00$300.00$300.00$300.00$300.00$300.00$300.00$300.00$3,600.00Telefono$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$18,000.00Agua$80.00$80.00$80.00$80.00$80.00$80.00$80.00$80.00$80.00$80.00$80.00$80.00$960.00Mantenimiento vehiculo$2,000.00$2,000.00$2,000.00$2,000.00$2,000.00$2,000.00$2,000.00$2,000.00$2,000.00$2,000.00$2,000.00$2,000.00$24,000.00Imprevistos$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$6,000.00Total de Costos Fijos$21,420.00$21,420.00$21,420.00$21,420.00$21,420.00$21,420.00$21,420.00$21,420.00$21,420.00$21,420.00$21,420.00$21,420.00$257,040.00

Costos Totales$22,970.00$202,900.80$202,900.80$202,900.80$202,900.80$202,900.80$202,900.80$202,900.80$202,900.80$202,900.80$202,900.80$202,900.80$2,254,878.80Proyeccion de Costos Anuales

ConceptoAo 1Ao 2Ao 3Ao 4Ao 5Costos VariablesCompra de productos*$1,979,238.80$2,078,200.74$2,182,110.78$2,291,216.32$2,405,777.13Papel periodico para envolver$5,400.00$5,670.00$5,953.50$6,251.18$6,563.73Bolsas de plastico$6,000.00$6,300.00$6,615.00$6,945.75$7,293.04Papel de estrasa$7,200.00$7,560.00$7,938.00$8,334.90$8,751.65

Total de costos variables$1,997,838.80$2,097,730.74$2,202,617.28$2,312,748.14$2,428,385.55

Costos FijosMano de obra$97,920.00$102,816.00$107,956.80$113,354.64$119,022.37Administrador $57,600.00$60,480.00$63,504.00$66,679.20$70,013.16Chofer$48,960.00$51,408.00$53,978.40$56,677.32$59,511.19Luz$3,600.00$3,780.00$3,969.00$4,167.45$4,375.82Telefono$18,000.00$18,900.00$19,845.00$20,837.25$21,879.11Agua$960.00$1,008.00$1,058.40$1,111.32$1,166.89Mantenimiento vehiculo$24,000.00$25,200.00$26,460.00$27,783.00$29,172.15Imprevistos$6,000.00$6,300.00$6,615.00$6,945.75$7,293.04Total de Costos Fijos$257,040.00$269,892.00$283,386.60$297,555.93$312,433.73

Costos Totales$2,254,878.80$2,367,622.74$2,486,003.88$2,610,304.07$2,740,819.27

PROYECCION COSTOSINDICEFERRETERIAPROYECCION DE COSTOSCOSTOS DEL PROYECTOCOSTOSAOAOAOAOAOCONCEPTO /MES12345Compra de productos*$164,936.57$1,979,238.80$2,078,200.74$2,182,110.78$2,291,216.32$2,405,777.13Papel periodico para envolver$450.00$5,400.00$5,670.00$5,953.50$6,251.18$6,563.73Bolsas de plastico$500.00$6,000.00$6,300.00$6,615.00$6,945.75$7,293.04Papel de estrasa$600.00$7,200.00$7,560.00$7,938.00$8,334.90$8,751.65Mano de obra$8,160.00$97,920.00$102,816.00$107,956.80$113,354.64$119,022.37Administrador $4,800.00$57,600.00$60,480.00$63,504.00$66,679.20$70,013.16Chofer$4,080.00$48,960.00$51,408.00$53,978.40$56,677.32$59,511.19Luz$300.00$3,600.00$3,780.00$3,969.00$4,167.45$4,375.82Telefono$1,500.00$18,000.00$18,900.00$19,845.00$20,837.25$21,879.11Agua$80.00$960.00$1,008.00$1,058.40$1,111.32$1,166.89Mantenimiento vehiculo$2,000.00$24,000.00$25,200.00$26,460.00$27,783.00$29,172.15Imprevistos$500.00$6,000.00$6,300.00$6,615.00$6,945.75$7,293.04

TOTAL$2,254,878.80$2,367,622.74$2,486,003.88$2,610,304.07$2,740,819.27

COSTOS TOTALESINDICEFERRETERIACOSTOS TOTALESCOSTOS FIJOSAO 1AO 2AO 3AO 4AO 5Mano de obra$97,920.00$102,816.00$107,956.80$113,354.64$119,022.37Administrador $57,600.00$60,480.00$63,504.00$66,679.20$70,013.16Chofer$48,960.00$51,408.00$53,978.40$56,677.32$59,511.19Luz$3,600.00$3,780.00$3,969.00$4,167.45$4,375.82Telefono$18,000.00$18,900.00$19,845.00$20,837.25$21,879.11Agua$960.00$1,008.00$1,058.40$1,111.32$1,166.89Mantenimiento vehiculo$24,000.00$25,200.00$26,460.00$27,783.00$29,172.15Imprevistos$6,000.00$6,300.00$6,615.00$6,945.75$7,293.04

TOTAL$257,040.00$269,892.00$283,386.60$297,555.93$312,433.73COSTOS VARIABLESAO 1AO 2AO 3AO 4AO 5Compra de productos*$1,979,238.80$2,078,200.74$2,182,110.78$2,291,216.32$2,405,777.13Papel periodico para envolver$5,400.00$5,670.00$5,953.50$6,251.18$6,563.73Bolsas de plastico$6,000.00$6,300.00$6,615.00$6,945.75$7,293.04Papel de estrasa$7,200.00$7,560.00$7,938.00$8,334.90$8,751.65

TOTAL$1,997,838.80$2,097,730.74$2,202,617.28$2,312,748.14$2,428,385.55AO 1AO 2AO 3AO 4AO 5COSTOS FIJOS $257,040.00$269,892.00$283,386.60$297,555.93$312,433.73COSTOS VARIABLES$1,997,838.80$2,097,730.74$2,202,617.28$2,312,748.14$2,428,385.55COSTOS TOTALES$2,254,878.80$2,367,622.74$2,486,003.88$2,610,304.07$2,740,819.27

INGRESOSINDICEFERRETERIAProyeccion de IngresosProductosAo 1Ao 2Ao 3Ao 4Ao 5Barreta de punta 7/8x1m12,006.0012,606.3013,236.6213,898.4514,593.37Grifa con dos bocas de 3/8-1/23,933.004,129.654,336.134,552.944,780.59Bieldo de paja de 628,152.0029,559.6031,037.5832,589.4634,218.93Carretilla 55 llanta negra50,094.0052,598.7055,228.6457,990.0760,889.57Carretilla pasturera 100 ft371,622.0075,203.1078,963.2682,911.4287,056.99Llanta para carretilla reforzada completa34,776.0036,514.8038,340.5440,257.5742,270.45Cintal teflon de 1/2x7 m20,700.0021,735.0022,821.7523,962.8425,160.98Cuchara forjada de 6 truper31,464.0033,037.2034,689.0636,423.5138,244.69Desarmador plano de 1/4x611,923.2012,519.3613,145.3313,802.5914,492.72Desarmador plano de 5/16x615,897.6016,692.4817,527.1018,403.4619,323.63Juego de 5 desarmadores truper42,228.0044,339.4046,556.3748,884.1951,328.40Guante de algodn con puntos pvc10,598.4011,128.3211,684.7412,268.9712,882.42Guante de piel de borrego corto122,544.00128,671.20135,104.76141,860.00148,953.00Guante piel borrego85,449.6089,722.0894,208.1898,918.59103,864.52Escoba metalica reforzada 18d5,382.005,651.105,933.666,230.346,541.85Escoba metal/plastico 22 dientes5,589.005,868.456,161.876,469.976,793.46Flexometro contra impacto 3 m2,898.003,042.903,195.053,354.803,522.54Flexometro contra impacto 5 m4,554.004,781.705,020.795,271.825,535.42Flexometro contra impacto 8 m7,866.008,259.308,672.279,105.889,561.17Flexometro contra impacto 10 m12,006.0012,606.3013,236.6213,898.4514,593.37Flexometro con magneto en punta 3 m2,898.003,042.903,195.053,354.803,522.54Flexometro con magneto en punta 5 m4,554.004,781.705,020.795,271.825,535.42Flexometro con magneto en punta 8 m7,866.008,259.308,672.279,105.889,561.17Hacha media labor de 3lbs sin mango5,244.005,506.205,781.516,070.596,374.11Hacha media labor de 31/2 lbs5,796.006,085.806,390.096,709.597,045.07Hacha media labor de 4 lbs sin mango6,348.006,665.406,998.677,348.607,716.03Hacha labor entera de 2 1/2 kbs4,692.004,926.605,172.935,431.585,703.16Hacha labor entera de 3 lbs sin mango5,244.005,506.205,781.516,070.596,374.11Hacha labor entera de 3 1/2 lbs5,796.006,085.806,390.096,709.597,045.07Hacha labor entera de 4 lbs s/mango6,348.006,665.406,998.677,348.607,716.03Lona de 2x3 m truper7,452.007,824.608,215.838,626.629,057.95Lona de 3x3 m truper11,178.0011,736.9012,323.7512,939.9313,586.93Lona de 4x5 m truper24,426.0025,647.3026,929.6728,276.1529,689.96Lona de 4x6 m truper28,566.0029,994.3031,494.0233,068.7234,722.15Lona de 5x6 m truper36,018.0037,818.9039,709.8541,695.3443,780.10Lona de 6x12 m truper81,972.0086,070.6090,374.1394,892.8499,637.48Lona de 12x17 m truper235,980.00247,779.00260,167.95273,176.35286,835.16Lona de polietileno7,452.007,824.608,215.838,626.629,057.95Llave espaola de 7/1615,897.6016,692.4817,527.1018,403.4619,323.63Juego de 6 llaves comb milim35,604.0037,384.2039,253.4141,216.0843,276.88Juego de 6 llaves comb std35,604.0037,384.2039,253.4141,216.0843,276.88Juego de 11 llaves comb milim48,024.0050,425.2052,946.4655,593.7858,373.47Juego de 11 llaves comb std52,440.0055,062.0057,815.1060,705.8663,741.15Llave p/tubo de 8 stilson8,694.009,128.709,585.1410,064.3910,567.61Llave p/tubo de 10 stilson11,178.0011,736.9012,323.7512,939.9313,586.93Llave p/tubo de 12 stilson14,490.0015,214.5015,975.2316,773.9917,612.69Llave p/tubo de 14 stilson18,630.0019,561.5020,539.5821,566.5522,644.88Llave para tubo stilson de aluminio 1217,802.0018,692.1019,626.7120,608.0421,638.44Llave para tubo stilson de aluminio 1421,942.0023,039.1024,191.0625,400.6126,670.64Llave para tubo stilson de aluminio 1014,490.0015,214.5015,975.2316,773.9917,612.69Martillo curva pulido 721,528.0022,604.4023,734.6224,921.3526,167.42Martillo curva pulido 1629,476.8030,950.6432,498.1734,123.0835,829.23Martillo promo 16 curva19,540.8020,517.8421,543.7322,620.9223,751.96Martillo promo 16 recta19,540.8020,517.8421,543.7322,620.9223,751.96Martillo recta de 16 promo4,057.204,260.064,473.064,696.724,931.55Pala cuadrada mango y clasic4,554.004,781.705,020.795,271.825,535.42Pala cuadrada mango y promo3,933.004,129.654,336.134,552.944,780.59Pala cuadrada mango largo promo3,933.004,129.654,336.134,552.944,780.59Pinza electricista 72,566.802,695.142,829.902,971.393,119.96Pinza electricista 82,856.602,999.433,149.403,306.873,472.22Niple de laton para equipo de aire5,961.606,259.686,572.666,901.307,246.36Manguera para aire3,808.803,999.244,199.204,409.164,629.62Lima triangulo pesado 61,242.001,304.101,369.311,437.771,509.66Lima triangulo pesado 71,573.201,651.861,734.451,821.181,912.23Lima triangulo pesado 82,318.402,434.322,556.042,683.842,818.03Martillo de curva 16 oz24,840.0026,082.0027,386.1028,755.4130,193.18Grifa de dos curvas de 3/4 y 5/83,933.004,129.654,336.134,552.944,780.59Juego de 3 minipinzas13,082.4013,736.5214,423.3515,144.5115,901.74Juego de 4 desarmadores mango tra23,846.4025,038.7226,290.6627,605.1928,985.45Juego de 8 desarmadores mango tra32,788.8034,428.2436,149.6537,957.1339,854.99Juego de 6 desarmadores mango t24,840.0026,082.0027,386.1028,755.4130,193.18Juego de 8 desarmadores mango bic36,432.0038,253.6040,166.2842,174.5944,283.32Llave ajustable de 6 pretul3,146.403,303.723,468.913,642.353,824.47Llave ajustable de 8 pretul4,057.204,260.064,473.064,696.724,931.55Llave ajustable de 10 pretul5,713.205,998.866,298.806,613.746,944.43Llave ajustable de 12 pretul7,866.008,259.308,672.279,105.889,561.17Llave ajustable pavonada 63,146.403,303.723,468.913,642.353,824.47Llave ajustable pavonada 84,057.204,260.064,473.064,696.724,931.55Llave ajustable pavonada 10 p5,713.205,998.866,298.806,613.746,944.43Llave ajustable pavonada 12 p7,866.008,259.308,672.279,105.889,561.17Llave espaola de 1/4 x 5/162,152.802,260.442,373.462,492.142,616.74Llave espaola de 5/6 x 3/82,318.402,434.322,556.042,683.842,818.03Llave espaola de 3/8 x 7/162,649.602,782.082,921.183,067.243,220.61Llave espaola de 7/16 x 1/2 p2,815.202,955.963,103.763,258.953,421.89Juego de 9 llaves comb7,659.008,041.958,444.058,866.259,309.56Martillo curva 16 oz pretul3,726.003,912.304,107.924,313.314,528.98Juego de 3 pinzas14,407.2015,127.5615,883.9416,678.1317,512.04Cerrojo lb doble cilindro pretul17,388.0018,257.4019,170.2720,128.7821,135.22Martillo curva 7 oz pretul2,898.003,042.903,195.053,354.803,522.54Niple acero cuerda 1/4 npt pretul3,974.404,173.124,381.784,600.864,830.91Candado de laton 20 mm8,280.008,694.009,128.709,585.1410,064.39Clavo fosfatado 3/4372.60391.23410.79431.33452.90Clavo fosfatado 1n372.60391.23410.79431.33452.90Clavo fosfatado 1 1/2n372.60391.23410.79431.33452.90Clavo fosfatado 2n372.60391.23410.79431.33452.90Clavo fosfatado 3n372.60391.23410.79431.33452.90Clavo fosfatado 3 1/2n372.60391.23410.79431.33452.90Clavo con cabeza para madera de pu372.60391.23410.79431.33452.901/4 clavo con cabeza para madera372.60391.23410.79431.33452.901/2 clavo con cabeza para madera372.60391.23410.79431.33452.902 clavo con cabeza para madera220.80231.84243.43255.60268.382 1/2 clavo con cabeza para madera220.80231.84243.43255.60268.383 clavo con cabeza para madera220.80231.84243.43255.60268.383 1/2 clavo con cabeza para madera220.80231.84243.43255.60268.38Multicontacto de 8 entradas31,298.4032,863.3234,506.4936,231.8138,043.40Multicontacto de 6 entradas20,865.6021,908.8823,004.3224,154.5425,362.27Fusible economico con jaladera3,450.003,622.503,803.633,993.814,193.50Fusible reforzado con 30 A 17,940.0018,837.0019,778.8520,767.7921,806.18Par de fusibles economicos 30b20,700.0021,735.0022,821.7523,962.8425,160.98Par de fusibles economicos 30ab20,700.0021,735.0022,821.7523,962.8425,160.98Extension electrica de uso rudo 6x163,422.403,593.523,773.203,961.864,159.95Extension electrica de uso rudo 8x162,401.202,521.262,647.322,779.692,918.67Extension electrica de uso rudo 10x162,898.003,042.903,195.053,354.803,522.54Extension electrica de uso rudo 12x163,367.203,535.563,712.343,897.954,092.85Foco ahorrador espiral 15e12,519.3613,145.3313,802.5914,492.7215,217.36Foco ahorrador espiral 20e13,413.6014,084.2814,788.4915,527.9216,304.31Foco ahorrador espiral 20efc13,413.6014,084.2814,788.4915,527.9216,304.31Foco ahorrador espiral f24e14,605.9215,336.2216,103.0316,908.1817,753.59Foco ahorrador cuadruple u20w80017,288.6418,153.0719,060.7320,013.7621,014.45Foco ahorrador cuadruple u28w80018,480.9619,405.0120,375.2621,394.0222,463.72Foco ahorrador cuadruple 28wcal18,480.9619,405.0120,375.2621,394.0222,463.72Manguera revestida de acero inox22,356.0023,473.8024,647.4925,879.8627,173.86Manguera de caucho 0614,407.2015,127.5615,883.9416,678.1317,512.04Manguera de caucho 1017,388.0018,257.4019,170.2720,128.7821,135.22Manguera de caucho 1522,356.0023,473.8024,647.4925,879.8627,173.86Manguera de caucho 2026,330.4027,646.9229,029.2730,480.7332,004.77Manguera de caucho 3034,279.2035,993.1637,792.8239,682.4641,666.58Manguera de caucho 4043,221.6045,382.6847,651.8150,034.4052,536.12Manguera de caucho 5052,164.0054,772.2057,510.8160,386.3563,405.67Exhibidor giratorio para palas10,350.0010,867.5011,410.8811,981.4212,580.49Exhibidor para herramientas mango largo10,350.0010,867.5011,410.8811,981.4212,580.49Gancho recto de 9c89,424.0093,895.2098,589.96103,519.46108,695.43Rack para 3 carretillas estibada27,600.0028,980.0030,429.0031,950.4533,547.97Panel exhibidor truper 60x14096,600.00101,430.00106,501.50111,826.58117,417.90Rach de alto impacto nacional17,940.0018,837.0019,778.8520,767.7921,806.18000000000000TOTAL$2,483,045.04$2,607,197.29$2,737,557.16$2,874,435.01$3,018,156.77

ESTADO RESULTADOSINDICEFERRETERIAESTADO DE RESULTADOS
usuario01: DOCUMENTO REFLEJADO A 5 AOS, CONSIDERANDO LA FORMULA ESTABLECIDA.CONCEPTOSAO 1AO 2AO 3AO 4AO 5( + ) VENTAS$2,483,045.04$2,607,197.29$2,737,557.16$2,874,435.01$3,018,156.77COSTOS FIJOS$257,040.00$269,892.00$283,386.60$297,555.93$312,433.73COSTOS VARIABLES$1,997,838.80$2,097,730.74$2,202,617.28$2,312,748.14$2,428,385.55( - ) COSTOS TOTALES$2,254,878.80$2,367,622.74$2,486,003.88$2,610,304.07$2,740,819.27( = ) UTILIDAD BRUTA$228,166.24$239,574.55$251,553.28$264,130.94$277,337.49( - ) DEPRECIACION$17,552.00$18,429.60$19,351.08$20,318.63$21,334.57( = ) UTILIDAD ANTES DE IMPUESTOS$210,614.24$221,144.95$232,202.20$243,812.31$256,002.93( - ) IMPUESTOS $21,061.42$22,114.50$23,220.22$24,381.23$25,600.29( = ) UTILIDAD DEL EJERCICIO$189,552.82$199,030.46$208,981.98$219,431.08$230,402.63COSTOS DE DEPRECIACIONESACTIVO FIJO
SAUL BAUTISTA: BIENES DURADEROS PARA EL FUNCIONAMIENTO DEL PROYECTOVALOR ORIGINALTASAAOSDEP ANUALVALOR RESCATEJUEGOS DE ESTANTES CON SUS CHAROLAS$38,280.0015%5.00 $7,656.00$30,624.00GONDOLA DE EXHIBICION 5 PELDAOS SIMPLE$13,746.0015%5.00 $2,749.20$10,996.80GONDOLA DE EXHIBICION DOBLE$27,492.0015%5.00 $5,498.40$21,993.60CAJA REGISTRADORA 500 FUNCIONES EN MEMORIA 12 DEPT$8,242.0015%5.00 $1,648.40$6,593.6015%5.00 0.00.015%5.00 0.00.015%5.00 0.00.015%5.00 0.00.015%5.00 0.00.015%5.00 0.00.0

TOTAL$87,760.00$17,552.00$70,208.00

FLUJO EFECTIVOINDICEFERRETERIA

FLUJO DE EFECTIVO
usuario01: DOCUMENTO QUE MUESTRA ENTRADAS Y SALIDAS DE EFECTIVO EN UN PERIODO DETERMINADO.CONCEPTOS / AOAO 0AO 1AO 2AO 3AO 4AO 5( + ) VENTAS0.0$2,483,045.04$2,607,197.29$2,737,557.16$2,874,435.01$3,018,156.77( + ) VALOR DE RESCATE0.00.00.00.00.0$70,208.00( = ) INGRESOS TOTALES0.0$2,483,045.04$2,607,197.29$2,737,557.16$2,874,435.01$3,088,364.77COSTOS FIJOS0.0$257,040.00$269,892.00$283,386.60$297,555.93$312,433.73COSTOS VARIABLES0.0$1,997,838.80$2,097,730.74$2,202,617.28$2,312,748.14$2,428,385.55( = ) COSTOS TOTALES0.0$2,254,878.80$2,367,622.74$2,486,003.88$2,610,304.07$2,740,819.27COMPRA ACTIVO FIJO$180,000.000.00.00.00.00.0COMPRA ACTIVO DIFERIDO$18,000.000.00.00.00.00.0COMPRA CAPITAL DE TRABAJO$179,930.800.00.00.00.00.0( = ) SALDO FINAL-$377,930.80$228,166.24$239,574.55$251,553.28$264,130.94$347,545.49

PUNTO EQUILIBRIOINDICEFERRETERIA

PUNTO DE EQUILIBRIO
usuario01: CALCULAR EL PUNTO DE EQUILIBRIO EN PORCENTAJE DE VENTAS CON LA FORMULA ESTUDIADA.CONCEPTOS / AOAO 1AO 2AO 3AO 4AO 5VENTAS$2,483,045.04$2,607,197.29$2,737,557.16$2,874,435.01$3,018,156.77COSTOS FIJOS$257,040.00$269,892.00$283,386.60$297,555.93$312,433.73COSTOS VARIABLES$1,997,838.80$2,097,730.74$2,202,617.28$2,312,748.14$2,428,385.55COSTOS TOTALES$2,254,878.80$2,367,622.74$2,486,003.88$2,610,304.07$2,740,819.27PUNTO DE EQUILIBRIO $ $1,315,403.32$1,381,173.48$1,450,232.16$1,522,743.76$1,598,880.95PUNTO DE EQUILIBRIO %53%53%53%53%53%INTERPRETACION SIGNIFCA EL PORCENTAJE DE VENTAS QUE SE TIENE QUE REALIZAR POR AO PARA NO TENER PERDIDAS, ES DECIRES EL VALOR MINIMO EN VENTAS QUE SE TIENE QUE REALIZAR PARA NO PERDER, ENCIMA DE ESOS VALOR SIGNIFICARIA BUENAS GANANCIAS

VAN, TIR Y BCINDICEFERRETERIAANALISIS DE RENTABILIDAD (VAN, TIR, B/C)

TASA DE ACTUALIZACION10%AOINGRESOSCOSTOS FLUJO DE TASAINGRESOSEGRESOSEFECTIVO (1+t)-nACTUALIZADOSACTUALIZADOSAO 0 0.0$377,930.80-$377,930.801.000000.0$377,930.80AO 1$2,483,045.04$2,254,878.80$228,166.240.90909$2,257,313.67$2,049,889.82AO 2$2,607,197.29$2,367,622.74$239,574.550.82645$2,154,708.51$1,956,713.01AO 3$2,737,557.16$2,486,003.88$251,553.280.75131$2,056,767.21$1,867,771.51AO 4$2,874,435.01$2,610,304.07$264,130.940.68301$1,963,277.79$1,782,872.80AO 5$3,088,364.77$2,740,819.27$347,545.490.62092$1,917,631.54$1,701,833.13TOTAL$13,790,599.27$12,837,559.56$953,039.71$10,349,698.72$9,737,011.07VAN
usuario01: VALOR ACTUAL NETO$612,687.65TIR
usuario01: TASA INTERNA DE RETORNO58.71%B/C
usuario01: RELACION BENEFICIO-COSTO1.06CRITERIO DE DECISIN ________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

TIR =TIR =

MAS CORRIDAS...A g r o p r o y e c t o s S. C.

Catalogo de Corridas Financieras:Necesitas ms corridas? Promociones:Produccion de maiz5 corridas financieras: $1,000.00Jitomate a campo abierto10 corridas financieras:$2,000.00Jitomate en invernadero o casa sombra20 corridas financieras: $3,000.00Melon en invernaderoMas de 20 corridas? cotizar al correo: [email protected] de becerrosConsultorio medico Bovinos de doble propositoVacas lecherasChile piquinCria de venado cola blanca Elaboracion de productos lacteosProduccion y engorda de borregosProduccion y engorda de cabras (chivos)Cabras lecherasRefaccionaria de motocicletasElaboracion de dulces de tamarindoCentro de fotocopiadoGuarderia o estancia infantil Produccion de mojarra tilapiaMiel apicolaProduccion y engorda de cerdosEngorda de pollosSiloMaiz para siloAdquisicion de tracto para cultivo de frijolTienda de abarrotesChile jalapeo a cielo abiertoCafeteria Industrializacion de mangoIndustrializacion de tamarindoCocina economicaRestaurant de truchas Comercializacion de articulos para el hogar Lechuga en invernaderoRenta de inflablesProduccion de plantulas de hortalizas en almacigo Clinica de depilacion EcoturismoCultivo yproduccinde vainilla Cultivo de pepinoContruccion de cabaas y albercaVenta de materiales de plomeria Produccion de blocksFarmaciaCultivo y produccion de caa de azucar PanaderiaComercializadora de materias primasCarniceriaZapateriaPurificadora de aguaPolleriaLombricompostaAcopio y reciclado de Pet y carton Tortilleria de harina de trigoTortilleria de maizCibercafe internetCiber y papeleriaIncubadora de pollitos EsteticaElaboracion de quesos y venta de leche FerreteriaMadereria Vivero de huleVivero de plantas frutalesVivero de plantas de cafeVivero forestalAguacate hassTienda de ropa Tienda de ropa para bebeCultivo y produccion de nopal QueseriaTaller de herreria Acopio y beneficio de cafeAcopio y empaque de frutas y verduras Cultivo de mango haden AgroforrajeraTruchaTemazcalNopal en salmuera Cultivo y produccion de papayaCultivo y beneficio de cafPapeleriaVenta de productos FoamyMerceriaMinisuper PasteleriaImprenta digital Birria de chivo PinoleVenta de hamburguesasVeterinaria Cultivo y produccion de litchiTaller mecanicoTaller de costuraDulceriaEmpaque de zarzamoraAutolavado, lavado de autos Renta de mobiliarioProduccion y venta de eloteProduccion y acopio de miel apicolaIndustrializacion de chile habaneroChile habanero en invernaderoCultivo y produccion de chile serrano Transformacion de pasta de pescadoProduccion y venta de CabritosJatropha curcasCultivo de alfalfa forrajero Produccion y comercializacion de velasProduccion y comercializacion de veladorasPaleteria: venta de aguas, paletas y nieves.CarpinteriaProduccion de hongos frescosCultivo y produccion de hongo setaRastro TIFEstablecimiento y mantenimiento de cultivo de huleIncubadora de pollitos Cultivo, produccion y acopio de pimienta negraIndustrializacion de tomate a pure de tomateElaboracion de peluches Cultivo y produccion de pia Caf morteado (beneficio de cafe)Banda de musica de vientoTrapiche Espinaca en invernaderoVenta de estambres Vulcanizadora Venta de equipo de computoProduccion y venta de lechonesRestaurant de truchas Acopio y comercializacion de hoja de maizLavanderiaFrijoles preparadosSalon de belleza Cultivo de sabilaEngorda de cerdosTaller de calzado TaqueriaSecadora de cafePizzeriaPuesto de tacosVenta de tamales Pollos rostizados (azado, enchilados, rancheros)Pollos estilo kentukyRenta de mobiliario e inflables Venta de fertilizantes y agroinsumosCria de tepezcuintle Tractor agricola e implementosProduccion de forraje verde hidroponicoComercializadora de productos de limpieza Produccion de cebolla criollaCria de iguanasMarisqueria Reproduccion de perros de raza Taller de costura de pantalones de mezclilla Cultivo y produccion de limon persaCultivo y produccion de naranjaCultivo y produccion de mandarinaCultivo y produccion de toronja Cria y engorda de conejosTaller de serigrafia Produccion de plantulas de lechuga RefaccionariaTienda de fantasiaEquipo de sonido Cultivo y produccion de papaMiscelanea Empaque de jitomate Zarzamora en invernadero Canola forrajeroCultivo y produccion de sandia Produccion de nopal en invernaderoAcopio de granos Engorda de camaronCultivo de frijoletc, etc.