Plan Financiero

Cadence. $442,680. $929,152. $1,173,816. H+ Organic. $245,100. $541,500. $671,460. Costos de Venta. $3,047,690. $6,299,404. $8,456,642. Costo de Venta ...
385KB Größe 5 Downloads 2 vistas
Plan Financiero Proyeccion Financiera Supuestos de Ingreso Grafica de Ingresos por año proyecto

Supuesto de Gastos Grafica de Gastos por año proyecto

21

Grafica de Utilidad por año proyecto

Estado Financiero

22

Reporte de Estados de Resultados por año Proyecto Utilidad Neta Total de Ingresos

Año 1

Año 2

Año 3

$6,626,992

$13,741,252

$19,574,576

Vivace

$677,352

$1,034,280

$1,744,080

Sil Master 12x1 L

$303,600

$303,600

$676,200

$1,013,760

$1,531,200

$1,931,160

Secuence

$883,200

$1,410,360

$1,741,560

Lec 350

$238,500

$598,500

$652,500

Allegro

$898,560

$2,377,440

$2,765,880

ADW-79

$467,500

$1,020,000

$1,139,000

DBS

$140,400

$889,200

$1,773,200

Andante

$384,540

$1,272,960

$1,471,860

Rubato

$394,800

$710,640

$1,910,080

Óbelo

$409,320

$705,780

$1,204,740

Rinox

$127,680

$416,640

$719,040

Cadence

$442,680

$929,152

$1,173,816

H+ Organic

$245,100

$541,500

$671,460

Costos de Venta

$3,047,690

$6,299,404

$8,456,642

Costo de Venta Estandar

$3,047,690

$6,299,404

$8,456,642

$2,652

$2,652

$2,652

LEC350 Costos

$131,970

$331,170

$361,050

Secuence Costos

$560,640

$895,272

$1,105,512

Eco Wet costos

$718,848

$1,085,760

$1,369,368

Allegro Costos

$207,360

$548,640

$638,280

Sil Master costos

$67,980

$67,980

$151,410

ADW-79 Costos

$362,450

$790,800

$883,060

DBS Costos

$45,630

$288,990

$576,290

Andante Costos

$239,250

$792,000

$915,750

Rubato Costos

$119,280

$214,704

$577,088

Óbelo Costos

$181,920

$313,680

$535,440

Rinox Costos

$82,080

$267,840

$462,240

Cadence Costos

$216,690

$454,816

$574,578

H+ Organic

$110,940

$245,100

$303,924

$3,579,302

$7,441,848

$11,117,934

54%

54%

56%

$1,501,200

$2,588,950

$2,879,050

personal

$845,100

$1,615,950

$1,786,050

Sueldos y Salarios

$626,000

$1,197,000

$1,323,000

Administración

$192,000

$201,600

$211,680

Ayudante General 1

$80,000

$100,800

$105,840

Ayudante General 2

$32,000

$100,800

$105,840

Dirección

$230,000

$252,000

$264,600

Asistente administrativa

$32,000

$100,800

$105,840

Eco Wet

Vivace Costos

Margen Bruto Margen Bruto % Gastos Fijos

23

Utilidad Neta Vendedor Ensenada, BC

Año 1

Año 2

Año 3

$60,000

$252,000

$264,600

-

$189,000

$264,600

Gasto de personal

$219,100

$418,950

$463,050

Servicios

$21,000

$140,000

$168,000

Renta de vehículo utilitario Ensenada

$21,000

$84,000

$84,000

-

$56,000

$84,000

Relacionado a Oficinas

$166,500

$241,000

$253,000

Renta de bodega

$151,000

$223,000

$235,000

Papelería y gastos varios de oficina

$15,500

$18,000

$18,000

Tecnología

$24,000

$24,000

$24,000

Investigación y desarrollo

$24,000

$24,000

$24,000

Viajes y Viaticos

$104,000

$348,000

$396,000

Gasolina

$49,000

$188,000

$216,000

Viáticos de ventas

$55,000

$160,000

$180,000

Administración

$210,000

-

-

Certificados Orgánicos OMRI - Productos: Allegro

$30,000

-

-

Certificados Orgánicos OMRI - Productos: Vivace y H+Organic

$60,000

-

-

Certificados Orgánicos OMRI - Productos: öbelo, Cadence y Rinox

$90,000

-

-

Certificado Orgánico: ADW-79

$30,000

-

-

Otros

$130,600

$220,000

$252,000

Folletos

$9,600

$12,000

$12,000

Banners y Lonas

$9,000

$9,000

$15,000

Publicidad en revistas especializadas

$17,000

$16,000

$20,000

Stands en Expos Agrícolas

$75,000

$155,000

$170,000

Material publicitario (gorras, plumas, mochilas, sombreros, etc.)

$20,000

$28,000

$35,000

$2,078,102

$4,852,898

$8,238,884

31%

35%

42%

$15,233

$30,466

$28,800

Intereses

-

-

-

Impuestos

-

-

-

Depreciación

$15,233

$30,466

$28,800

Margen Neto

$2,062,868

$4,822,431

$8,210,084

31%

35%

41%

Vendedor Cd. Delicias, Chihuahua

Renta vehículo utilitario Cd. Delicias, Chihuahua

Margen Operativo Margen Operativo % Otros Gastos

Margen Neto %

24

Reporte de Flujos de Efectivo por año Proyecto Flujo de Efectivo Flujo de Efectivo en Operaciones

Año 1

Año 2

Año 3

$877,874

$3,863,412

$6,963,637

$2,062,869

$4,822,431

$8,210,084

$15,233

$30,467

$28,800

Cambios en Cuentas por Pagar

-

-

-

Cambios en Inventario

-

-

-

Impuestos de Inventario

-

-

-

($1,025,695)

($850,823)

($1,187,274)

($174,533)

($138,663)

($87,973)

Cambios en Impuestos sobre Ganancias

-

-

-

Cambio en Ingresos cobrados por Adelantado

-

-

-

Flujo de Efectivo en Inversiones

($109,040)

($58,000)

-

Compra/Venta de Activos

($94,000)

($50,000)

-

Impuestos de Activos

($15,040)

($8,000)

-

Flujo de Efectivo por Financiamiento

$680,400

-

-

Inversiones

$680,400

-

-

Dividendos

-

-

-

Cambio en Deuda a Corto Plazo

-

-

-

Cambio en Deuda a Largo Plazo

-

-

-

Utilidad Neta Depreciaciones y Amortizaciones

Cambios en Cuentas por Cobrar Cambios en Impuestos sobre Ventas

Flujo al Inicio del Periodo

-

$1,449,234

$5,254,646

Flujo de Efectivo del Periodo

$1,449,234

$3,805,412

$6,963,637

Flujo de Efectivo Acumulado

$1,449,234

$5,254,646

$12,218,283

25

Métricas Reporte de Métricas Valor de la Empresa

Inversión WACC Salida Múltiple

Valores 676,000 % 10 % 3 veces

NPV

9,694,338

IRR

3

Valor Terminal Año Terminal EBITDA (2020)

8,238,884

Salida Múltiple

3

Valor Terminal

24,716,652x

Factor de Descuento Valor Presente Terminal % de Valor Compañía Valor de la Empresa

0.75 18,569,986 0.65701151981013 % 28,264,324

26

Financiamiento Fuentes de Financiamiento Uso de la Inversión Impactos esperados

Anexos Estado de Resultados Utilidad Neta Año 1

Mes 1

Mes 2

Mes 3

Mes 4

Mes 5

Mes 6

Mes 7

Mes 8

Mes 9

Mes 10

Mes 11

Mes 12

Total de Ingresos

$135,540

$269,920

$510,280

$501,192

$622,300

$607,840

$558,820

$351,160

$487,720

$837,780

$860,220

$884,220

Vivace

$40,560

$40,560

$20,280

$28,392

$40,560

$60,840

$81,120

$40,560

$141,960

$60,840

$60,840

$60,840

Sil Master 12x1 L

-

$13,800

$55,200

$13,800

$27,600

$41,400

$13,800

-

-

$41,400

$55,200

$41,400

Eco Wet

-

$59,400

$128,040

$128,040

$128,040

$39,600

$19,800

$126,720

-

$128,040

$128,040

$128,040 $124,200

Secuence

$41,400

$41,400

$82,800

$69,000

$69,000

$55,200

$41,400

$27,600

$82,800

$124,200

$124,200

Lec 350

-

$9,000

$18,000

$18,000

$9,000

$18,000

$9,000

-

$22,500

$45,000

$45,000

$45,000

Allegro

$28,080

$56,160

$70,200

$84,240

$70,200

$84,240

$70,200

-

$56,160

$126,360

$126,360

$126,360

ADW-79

$25,500

$34,000

$34,000

$51,000

$34,000

$34,000

$34,000

$34,000

$34,000

$51,000

$51,000

$51,000

DBS

-

$15,600

$15,600

-

$15,600

$15,600

$15,600

-

-

$31,200

$15,600

$15,600

Andante

-

-

-

-

$39,780

$26,520

$92,820

$53,040

$53,040

$39,780

$39,780

$39,780

Rubato

-

-

$33,840

$56,400

$56,400

$56,400

$56,400

$22,560

$45,120

$22,560

$22,560

$22,560

Óbelo

-

-

$38,880

$38,880

$55,080

$71,280

$38,880

$32,400

$6,480

$22,680

$33,480

$71,280

Rinox

-

-

$13,440

$13,440

-

$13,440

$20,160

-

-

$13,440

$26,880

$26,880

Cadence

-

-

-

-

$42,840

$57,120

$42,840

$14,280

$28,560

$85,680

$85,680

$85,680

H+ Organic

-

-

-

-

$34,200

$34,200

$22,800

-

$17,100

$45,600

$45,600

$45,600

Costos de Venta

$52,751

$121,081

$249,667

$249,803

$296,323

$250,741

$232,561

$195,163

$175,783

$395,729

$407,189

$420,899

Costo de Venta Estandar

$52,751

$121,081

$249,667

$249,803

$296,323

$250,741

$232,561

$195,163

$175,783

$395,729

$407,189

$420,899

$221

$221

$221

$221

$221

$221

$221

$221

$221

$221

$221

$221

-

$4,980

$9,960

$9,960

$4,980

$9,960

$4,980

-

$12,450

$24,900

$24,900

$24,900

$26,280

$26,280

$52,560

$43,800

$43,800

$35,040

$26,280

$17,520

$52,560

$78,840

$78,840

$78,840

Vivace Costos LEC350 Costos Secuence Costos

27

Utilidad Neta Año 1

Mes 1

Mes 2

Mes 3

Mes 4

Mes 5

Mes 6

Mes 7

Mes 8

Mes 9

Mes 10

Mes 11

Mes 12

Eco Wet costos

-

$42,120

$90,792

$90,792

$90,792

$28,080

$14,040

$89,856

-

$90,792

$90,792

$90,792

Allegro Costos

$6,480

$12,960

$16,200

$19,440

$16,200

$19,440

$16,200

-

$12,960

$29,160

$29,160

$29,160

Sil Master costos

-

$3,090

$12,360

$3,090

$6,180

$9,270

$3,090

-

-

$9,270

$12,360

$9,270

ADW-79 Costos

$19,770

$26,360

$26,360

$39,540

$26,360

$26,360

$26,360

$26,360

$26,360

$39,540

$39,540

$39,540

DBS Costos

-

$5,070

$5,070

-

$5,070

$5,070

$5,070

-

-

$10,140

$5,070

$5,070

Andante Costos

-

-

-

-

$24,750

$16,500

$57,750

$33,000

$33,000

$24,750

$24,750

$24,750

Rubato Costos

-

-

$10,224

$17,040

$17,040

$17,040

$17,040

$6,816

$13,632

$6,816

$6,816

$6,816

Óbelo Costos

-

-

$17,280

$17,280

$24,480

$31,680

$17,280

$14,400

$2,880

$10,080

$14,880

$31,680

Rinox Costos

-

-

$8,640

$8,640

-

$8,640

$12,960

-

-

$8,640

$17,280

$17,280

Cadence Costos

-

-

-

-

$20,970

$27,960

$20,970

$6,990

$13,980

$41,940

$41,940

$41,940

H+ Organic

-

-

-

-

$15,480

$15,480

$10,320

-

$7,740

$20,640

$20,640

$20,640

$82,789

$148,839

$260,613

$251,389

$325,977

$357,099

$326,259

$155,997

$311,937

$442,051

$453,031

$463,321

61%

55%

51%

50%

52%

58%

58%

44%

64%

52%

52%

52%

Gastos Fijos

$54,850

$82,450

$131,000

$166,000

$131,000

$122,500

$89,500

$89,500

$119,100

$192,100

$155,100

$168,100

personal

$41,850

$41,850

$59,400

$59,400

$59,400

$59,400

$59,400

$59,400

$81,000

$108,000

$108,000

$108,000

Sueldos y Salarios

$31,000

$31,000

$44,000

$44,000

$44,000

$44,000

$44,000

$44,000

$60,000

$80,000

$80,000

$80,000

Administración

$16,000

$16,000

$16,000

$16,000

$16,000

$16,000

$16,000

$16,000

$16,000

$16,000

$16,000

$16,000

Ayudante General 1

-

-

$8,000

$8,000

$8,000

$8,000

$8,000

$8,000

$8,000

$8,000

$8,000

$8,000

Ayudante General 2

-

-

-

-

-

-

-

-

$8,000

$8,000

$8,000

$8,000

$15,000

$15,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

-

-

-

-

-

-

-

-

$8,000

$8,000

$8,000

$8,000

Margen Bruto Margen Bruto%

Dirección Asistente administrativa

28

Utilidad Neta Año 1

Mes 1

Mes 2

Mes 3

Mes 4

Mes 5

Mes 6

Mes 7

Mes 8

Mes 9

Mes 10

Mes 11

Mes 12

Vendedor Ensenada, BC

-

-

-

-

-

-

-

-

-

$20,000

$20,000

$20,000

Vendedor Cd. Delicias, Chihuahua

-

-

-

-

-

-

-

-

-

-

-

-

$10,850

$10,850

$15,400

$15,400

$15,400

$15,400

$15,400

$15,400

$21,000

$28,000

$28,000

$28,000

Servicios

-

-

-

-

-

-

-

-

-

$7,000

$7,000

$7,000

Renta de vehículo utilitario Ensenada

-

-

-

-

-

-

-

-

-

$7,000

$7,000

$7,000

Renta vehículo utilitario Cd. Delicias, Chihuahua

-

-

-

-

-

-

-

-

-

-

-

-

Relacionado a Oficinas

$6,000

$6,000

$6,000

$6,000

$6,000

$19,500

$19,500

$19,500

$19,500

$19,500

$19,500

$19,500

Renta de bodega

$5,000

$5,000

$5,000

$5,000

$5,000

$18,000

$18,000

$18,000

$18,000

$18,000

$18,000

$18,000

Papelería y gastos varios de oficina

$1,000

$1,000

$1,000

$1,000

$1,000

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

Tecnología

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

Investigación y desarrollo

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

Administración

-

$30,000

$60,000

$90,000

$30,000

-

-

-

-

-

-

-

Certificados Orgánicos OMRI - Productos: Allegro

-

$30,000

-

-

-

-

-

-

-

-

-

-

Certificados Orgánicos OMRI - Productos: Vivace y H+Organic

-

-

$60,000

-

-

-

-

-

-

-

-

-

Certificados Orgánicos OMRI - Productos: öbelo, Cadence y Rinox

-

-

-

$90,000

-

-

-

-

-

-

-

-

Certificado Orgánico: ADW-79

-

-

-

-

$30,000

-

-

-

-

-

-

-

Otros

$3,000

$600

$600

$5,600

$25,600

$33,600

$600

$600

$8,600

$37,600

$600

$13,600

Folletos

$3,000

$600

$600

$600

$600

$600

$600

$600

$600

$600

$600

$600

Banners y Lonas

-

-

-

-

-

$3,000

-

-

$3,000

-

-

$3,000

Publicidad en revistas especializadas

-

-

-

-

-

$5,000

-

-

-

$12,000

-

-

Stands en Expos Agrícolas

-

-

-

-

$25,000

$25,000

-

-

-

$25,000

-

-

Gasto de personal

29

Utilidad Neta Año 1 Material publicitario (gorras, plumas, mochilas, sombreros, etc.)

Mes 1

Mes 2

Mes 3

Mes 4

Mes 5

Mes 6

Mes 7

Mes 8

Mes 9

Mes 10

Mes 11

Mes 12

-

-

-

$5,000

-

-

-

-

$5,000

-

-

$10,000

$27,939

$66,389

$129,613

$85,389

$194,977

$234,599

$236,759

$66,497

$192,837

$249,951

$297,931

$295,221

20%

24%

25%

17%

31%

38%

42%

18%

39%

29%

34%

33%

Otros Gastos

-

$275

$1,025

$1,400

$1,566

$1,566

$1,566

$1,566

$1,566

$1,566

$1,566

$1,566

Intereses

-

-

-

-

-

-

-

-

-

-

-

-

Impuestos

-

-

-

-

-

-

-

-

-

-

-

-

Depreciación

-

$275

$1,025

$1,400

$1,566

$1,566

$1,566

$1,566

$1,566

$1,566

$1,566

$1,566

Margen Neto

$27,939

$66,114

$128,588

$83,989

$193,410

$233,032

$235,192

$64,930

$191,270

$248,384

$296,364

$293,654

20%

24%

25%

16%

31%

38%

42%

18%

39%

29%

34%

33%

Margen Operativo Margen Operativo %

Margen Neto %

30

Utilidad Neta Año 2

Mes 1

Mes 2

Mes 3

Mes 4

Mes 5

Mes 6

Mes 7

Mes 8

Mes 9

Mes 10

Mes 11

Mes 12

Total de Ingresos

$918,800

$910,740

$1,007,060

$1,020,420

$1,159,180

$1,202,720

$1,050,660

$861,760

$1,044,560

$1,371,160

$1,576,504

$1,617,688

Vivace

$60,840

$60,840

$81,120

$81,120

$101,400

$121,680

$101,400

$60,840

$60,840

$81,120

$101,400

$121,680

Sil Master 12x1 L

$13,800

$55,200

$55,200

$13,800

$13,800

$41,400

$13,800

-

-

$41,400

$27,600

$27,600

Eco Wet

$128,040

$128,040

$158,400

$158,400

$99,000

$99,000

$27,720

$99,000

$59,400

$158,400

$198,000

$217,800

Secuence

$138,000

$124,200

$124,200

$110,400

$110,400

$104,880

$104,880

$96,600

$110,400

$110,400

$138,000

$138,000

Lec 350

$49,500

$45,000

$45,000

$18,000

$49,500

$49,500

$49,500

$49,500

$54,000

$63,000

$63,000

$63,000

Allegro

$126,360

$126,360

$140,400

$168,480

$187,200

$280,800

$280,800

$140,400

$168,480

$196,560

$280,800

$280,800

ADW-79

$68,000

$51,000

$68,000

$102,000

$102,000

$68,000

$68,000

$51,000

$68,000

$102,000

$136,000

$136,000

DBS

$31,200

$15,600

$31,200

$62,400

$93,600

$93,600

$62,400

$46,800

$46,800

$93,600

$156,000

$156,000

Andante

$39,780

$39,780

$13,260

$13,260

$132,600

$132,600

$176,800

$176,800

$265,200

$176,800

$66,300

$39,780

Rubato

$33,840

$56,400

$56,400

$56,400

$56,400

$22,560

$22,560

$22,560

$45,120

$112,800

$112,800

$112,800

Óbelo

$71,280

$71,280

$71,280

$71,280

$38,880

$32,400

$6,480

$23,220

$71,280

$70,200

$81,000

$97,200

Rinox

$26,880

$26,880

$33,600

$33,600

$33,600

$33,600

$33,600

$13,440

$13,440

$33,600

$67,200

$67,200

Cadence

$85,680

$71,400

$85,680

$85,680

$95,200

$71,400

$57,120

$42,840

$42,840

$85,680

$97,104

$108,528

H+ Organic

$45,600

$38,760

$43,320

$45,600

$45,600

$51,300

$45,600

$38,760

$38,760

$45,600

$51,300

$51,300

Costos de Venta

$447,627

$424,127

$464,019

$475,061

$529,341

$505,083

$444,629

$420,571

$506,577

$641,071

$715,483

$725,815

Costo de Venta Estandar

$447,627

$424,127

$464,019

$475,061

$529,341

$505,083

$444,629

$420,571

$506,577

$641,071

$715,483

$725,815

$221

$221

$221

$221

$221

$221

$221

$221

$221

$221

$221

$221

LEC350 Costos

$27,390

$24,900

$24,900

$9,960

$27,390

$27,390

$27,390

$27,390

$29,880

$34,860

$34,860

$34,860

Secuence Costos

$87,600

$78,840

$78,840

$70,080

$70,080

$66,576

$66,576

$61,320

$70,080

$70,080

$87,600

$87,600

Eco Wet costos

$90,792

$90,792

$112,320

$112,320

$70,200

$70,200

$19,656

$70,200

$42,120

$112,320

$140,400

$154,440

Vivace Costos

31

Utilidad Neta Año 2

Mes 1

Mes 2

Mes 3

Mes 4

Mes 5

Mes 6

Mes 7

Mes 8

Mes 9

Mes 10

Mes 11

Mes 12

Allegro Costos

$29,160

$29,160

$32,400

$38,880

$43,200

$64,800

$64,800

$32,400

$38,880

$45,360

$64,800

$64,800

Sil Master costos

$3,090

$12,360

$12,360

$3,090

$3,090

$9,270

$3,090

-

-

$9,270

$6,180

$6,180

ADW-79 Costos

$52,720

$39,540

$52,720

$79,080

$79,080

$52,720

$52,720

$39,540

$52,720

$79,080

$105,440

$105,440

DBS Costos

$10,140

$5,070

$10,140

$20,280

$30,420

$30,420

$20,280

$15,210

$15,210

$30,420

$50,700

$50,700

Andante Costos

$24,750

$24,750

$8,250

$8,250

$82,500

$82,500

$110,000

$110,000

$165,000

$110,000

$41,250

$24,750

Rubato Costos

$10,224

$17,040

$17,040

$17,040

$17,040

$6,816

$6,816

$6,816

$13,632

$34,080

$34,080

$34,080

Óbelo Costos

$31,680

$31,680

$31,680

$31,680

$17,280

$14,400

$2,880

$10,320

$31,680

$31,200

$36,000

$43,200

Rinox Costos

$17,280

$17,280

$21,600

$21,600

$21,600

$21,600

$21,600

$8,640

$8,640

$21,600

$43,200

$43,200

Cadence Costos

$41,940

$34,950

$41,940

$41,940

$46,600

$34,950

$27,960

$20,970

$20,970

$41,940

$47,532

$53,124

H+ Organic

$20,640

$17,544

$19,608

$20,640

$20,640

$23,220

$20,640

$17,544

$17,544

$20,640

$23,220

$23,220

Margen Bruto

$471,173

$486,613

$543,041

$545,359

$629,839

$697,637

$606,031

$441,189

$537,983

$730,089

$861,021

$891,873

51%

53%

53%

53%

54%

58%

57%

51%

51%

53%

54%

55%

Gastos Fijos

$197,900

$162,900

$172,900

$201,250

$241,250

$275,250

$212,250

$212,250

$231,250

$242,250

$212,250

$227,250

personal

$113,400

$113,400

$113,400

$141,750

$141,750

$141,750

$141,750

$141,750

$141,750

$141,750

$141,750

$141,750

Sueldos y Salarios

$84,000

$84,000

$84,000

$105,000

$105,000

$105,000

$105,000

$105,000

$105,000

$105,000

$105,000

$105,000

Administración

$16,800

$16,800

$16,800

$16,800

$16,800

$16,800

$16,800

$16,800

$16,800

$16,800

$16,800

$16,800

Ayudante General 1

$8,400

$8,400

$8,400

$8,400

$8,400

$8,400

$8,400

$8,400

$8,400

$8,400

$8,400

$8,400

Ayudante General 2

$8,400

$8,400

$8,400

$8,400

$8,400

$8,400

$8,400

$8,400

$8,400

$8,400

$8,400

$8,400

Dirección

$21,000

$21,000

$21,000

$21,000

$21,000

$21,000

$21,000

$21,000

$21,000

$21,000

$21,000

$21,000

Asistente administrativa

$8,400

$8,400

$8,400

$8,400

$8,400

$8,400

$8,400

$8,400

$8,400

$8,400

$8,400

$8,400

Vendedor Ensenada, BC

$21,000

$21,000

$21,000

$21,000

$21,000

$21,000

$21,000

$21,000

$21,000

$21,000

$21,000

$21,000

Margen Bruto%

32

Utilidad Neta Año 2 Vendedor Cd. Delicias, Chihuahua

Mes 1

Mes 2

Mes 3

Mes 4

Mes 5

Mes 6

Mes 7

Mes 8

Mes 9

Mes 10

Mes 11

Mes 12

-

-

-

$21,000

$21,000

$21,000

$21,000

$21,000

$21,000

$21,000

$21,000

$21,000

Gasto de personal

$29,400

$29,400

$29,400

$36,750

$36,750

$36,750

$36,750

$36,750

$36,750

$36,750

$36,750

$36,750

Servicios

$7,000

$7,000

$7,000

$7,000

$14,000

$14,000

$14,000

$14,000

$14,000

$14,000

$14,000

$14,000

Renta de vehículo utilitario Ensenada

$7,000

$7,000

$7,000

$7,000

$7,000

$7,000

$7,000

$7,000

$7,000

$7,000

$7,000

$7,000

-

-

-

-

$7,000

$7,000

$7,000

$7,000

$7,000

$7,000

$7,000

$7,000

Relacionado a Oficinas

$19,500

$19,500

$19,500

$19,500

$19,500

$20,500

$20,500

$20,500

$20,500

$20,500

$20,500

$20,500

Renta de bodega

$18,000

$18,000

$18,000

$18,000

$18,000

$19,000

$19,000

$19,000

$19,000

$19,000

$19,000

$19,000

Papelería y gastos varios de oficina

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

Tecnología

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

Investigación y desarrollo

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

Administración

-

-

-

-

-

-

-

-

-

-

-

-

Certificados Orgánicos OMRI - Productos: Allegro

-

-

-

-

-

-

-

-

-

-

-

-

Certificados Orgánicos OMRI - Productos: Vivace y H+Organic

-

-

-

-

-

-

-

-

-

-

-

-

Certificados Orgánicos OMRI - Productos: öbelo, Cadence y Rinox

-

-

-

-

-

-

-

-

-

-

-

-

Certificado Orgánico: ADW-79

-

-

-

-

-

-

-

-

-

-

-

-

Otros

$36,000

$1,000

$9,000

$9,000

$31,000

$64,000

$1,000

$1,000

$20,000

$31,000

$1,000

$16,000

Folletos

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

Banners y Lonas

-

-

-

-

-

$3,000

-

-

$3,000

-

-

$3,000

Publicidad en revistas especializadas

-

-

$8,000

-

-

-

-

-

$8,000

-

-

-

$35,000

-

-

-

$30,000

$60,000

-

-

-

$30,000

-

-

-

-

-

$8,000

-

-

-

-

$8,000

-

-

$12,000

Renta vehículo utilitario Cd. Delicias, Chihuahua

Stands en Expos Agrícolas Material publicitario (gorras, plumas, mochilas, sombreros, etc.)

33

Utilidad Neta Año 2 Margen Operativo

Mes 1

Mes 2

Mes 3

Mes 4

Mes 5

Mes 6

Mes 7

Mes 8

Mes 9

Mes 10

Mes 11

Mes 12

$273,273

$323,713

$370,141

$344,109

$388,589

$422,387

$393,781

$228,939

$306,733

$487,839

$648,771

$664,623

29%

35%

36%

33%

33%

35%

37%

26%

29%

35%

41%

41%

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$3,233

$3,233

Intereses

-

-

-

-

-

-

-

-

-

-

-

-

Impuestos

-

-

-

-

-

-

-

-

-

-

-

-

Depreciación

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$3,233

$3,233

Margen Neto

$270,873

$321,313

$367,741

$341,709

$386,189

$419,987

$391,381

$226,539

$304,333

$485,439

$645,537

$661,389

29%

35%

36%

33%

33%

34%

37%

26%

29%

35%

40%

40%

Margen Operativo % Otros Gastos

Margen Neto %

34

Utilidad Neta Año 3 Total de Ingresos

Mes 1

Mes 2

Mes 3

Mes 4

Mes 5

Mes 6

Mes 7

Mes 8

Mes 9

Mes 10

Mes 11

Mes 12

$1,624,820

$1,567,564

$1,543,620

$1,360,520

$1,411,720

$1,500,040

$1,332,560

$1,119,540

$1,355,840

$1,861,004

$2,256,148

$2,641,200

Vivace

$121,680

$121,680

$81,120

$81,120

$101,400

$121,680

$101,400

$60,840

$60,840

$202,800

$283,920

$405,600

Sil Master 12x1 L

$13,800

$13,800

$41,400

$13,800

$13,800

$41,400

$13,800

-

-

$138,000

$193,200

$193,200

Eco Wet

$217,800

$217,800

$217,800

$158,400

$99,000

$99,000

$59,400

$128,040

$128,040

$190,080

$198,000

$217,800

Secuence

$138,000

$138,000

$151,800

$151,800

$138,000

$104,880

$104,880

$96,600

$110,400

$138,000

$193,200

$276,000

Lec 350

$49,500

$63,000

$45,000

$40,500

$54,000

$90,000

$60,000

$60,000

$60,000

$40,500

$45,000

$45,000

Allegro

$280,800

$238,680

$187,200

$168,480

$187,200

$280,800

$280,800

$187,200

$196,560

$196,560

$280,800

$280,800

ADW-79

$85,000

$102,000

$102,000

$102,000

$102,000

$102,000

$102,000

$68,000

$68,000

$102,000

$102,000

$102,000

DBS

$171,600

$156,000

$124,800

$140,400

$156,000

$156,000

$78,000

$78,000

$140,400

$156,000

$208,000

$208,000

Andante

$66,300

$66,300

$66,300

$66,300

$132,600

$132,600

$176,800

$176,800

$265,200

$176,800

$66,300

$79,560

Rubato

$150,400

$150,400

$225,600

$150,400

$150,400

$150,400

$150,400

$90,240

$90,240

$150,400

$225,600

$225,600

Óbelo

$97,200

$81,000

$71,280

$71,280

$38,880

$32,400

$16,200

$23,220

$71,280

$162,000

$216,000

$324,000

Rinox

$67,200

$73,920

$67,200

$44,800

$67,200

$60,480

$60,480

$33,600

$33,600

$53,760

$67,200

$89,600

Cadence

$114,240

$97,104

$114,240

$114,240

$114,240

$71,400

$71,400

$71,400

$85,680

$97,104

$108,528

$114,240

H+ Organic

$51,300

$47,880

$47,880

$57,000

$57,000

$57,000

$57,000

$45,600

$45,600

$57,000

$68,400

$79,800

Costos de Venta

$711,441

$704,485

$709,913

$626,881

$634,111

$632,617

$576,707

$531,577

$646,127

$786,387

$875,595

$1,020,801

Costo de Venta Estandar

$711,441

$704,485

$709,913

$626,881

$634,111

$632,617

$576,707

$531,577

$646,127

$786,387

$875,595

$1,020,801

$221

$221

$221

$221

$221

$221

$221

$221

$221

$221

$221

$221

LEC350 Costos

$27,390

$34,860

$24,900

$22,410

$29,880

$49,800

$33,200

$33,200

$33,200

$22,410

$24,900

$24,900

Secuence Costos

$87,600

$87,600

$96,360

$96,360

$87,600

$66,576

$66,576

$61,320

$70,080

$87,600

$122,640

$175,200

Eco Wet costos

$154,440

$154,440

$154,440

$112,320

$70,200

$70,200

$42,120

$90,792

$90,792

$134,784

$140,400

$154,440

Vivace Costos

35

Utilidad Neta Año 3

Mes 1

Mes 2

Mes 3

Mes 4

Mes 5

Mes 6

Mes 7

Mes 8

Mes 9

Mes 10

Mes 11

Mes 12

Allegro Costos

$64,800

$55,080

$43,200

$38,880

$43,200

$64,800

$64,800

$43,200

$45,360

$45,360

$64,800

$64,800

Sil Master costos

$3,090

$3,090

$9,270

$3,090

$3,090

$9,270

$3,090

-

-

$30,900

$43,260

$43,260

ADW-79 Costos

$65,900

$79,080

$79,080

$79,080

$79,080

$79,080

$79,080

$52,720

$52,720

$79,080

$79,080

$79,080

DBS Costos

$55,770

$50,700

$40,560

$45,630

$50,700

$50,700

$25,350

$25,350

$45,630

$50,700

$67,600

$67,600

Andante Costos

$41,250

$41,250

$41,250

$41,250

$82,500

$82,500

$110,000

$110,000

$165,000

$110,000

$41,250

$49,500

Rubato Costos

$45,440

$45,440

$68,160

$45,440

$45,440

$45,440

$45,440

$27,264

$27,264

$45,440

$68,160

$68,160

Óbelo Costos

$43,200

$36,000

$31,680

$31,680

$17,280

$14,400

$7,200

$10,320

$31,680

$72,000

$96,000

$144,000

Rinox Costos

$43,200

$47,520

$43,200

$28,800

$43,200

$38,880

$38,880

$21,600

$21,600

$34,560

$43,200

$57,600

Cadence Costos

$55,920

$47,532

$55,920

$55,920

$55,920

$34,950

$34,950

$34,950

$41,940

$47,532

$53,124

$55,920

H+ Organic

$23,220

$21,672

$21,672

$25,800

$25,800

$25,800

$25,800

$20,640

$20,640

$25,800

$30,960

$36,120

Margen Bruto

$913,379

$863,079

$833,707

$733,639

$777,609

$867,423

$755,853

$587,963

$709,713

$1,074,617

$1,380,553

$1,620,399

56%

55%

54%

53%

55%

57%

56%

52%

52%

57%

61%

61%

Gastos Fijos

$269,337

$219,337

$229,337

$229,337

$249,337

$285,337

$220,337

$220,337

$245,337

$250,337

$220,337

$240,337

personal

$148,837

$148,837

$148,837

$148,837

$148,837

$148,837

$148,837

$148,837

$148,837

$148,837

$148,837

$148,837

Sueldos y Salarios

$110,250

$110,250

$110,250

$110,250

$110,250

$110,250

$110,250

$110,250

$110,250

$110,250

$110,250

$110,250

Administración

$17,640

$17,640

$17,640

$17,640

$17,640

$17,640

$17,640

$17,640

$17,640

$17,640

$17,640

$17,640

Ayudante General 1

$8,820

$8,820

$8,820

$8,820

$8,820

$8,820

$8,820

$8,820

$8,820

$8,820

$8,820

$8,820

Ayudante General 2

$8,820

$8,820

$8,820

$8,820

$8,820

$8,820

$8,820

$8,820

$8,820

$8,820

$8,820

$8,820

Dirección

$22,050

$22,050

$22,050

$22,050

$22,050

$22,050

$22,050

$22,050

$22,050

$22,050

$22,050

$22,050

Asistente administrativa

$8,820

$8,820

$8,820

$8,820

$8,820

$8,820

$8,820

$8,820

$8,820

$8,820

$8,820

$8,820

Vendedor Ensenada, BC

$22,050

$22,050

$22,050

$22,050

$22,050

$22,050

$22,050

$22,050

$22,050

$22,050

$22,050

$22,050

Margen Bruto%

36

Utilidad Neta Año 3

Mes 1

Mes 2

Mes 3

Mes 4

Mes 5

Mes 6

Mes 7

Mes 8

Mes 9

Mes 10

Mes 11

Mes 12

Vendedor Cd. Delicias, Chihuahua

$22,050

$22,050

$22,050

$22,050

$22,050

$22,050

$22,050

$22,050

$22,050

$22,050

$22,050

$22,050

Gasto de personal

$38,587

$38,587

$38,587

$38,587

$38,587

$38,587

$38,587

$38,587

$38,587

$38,587

$38,587

$38,587

Servicios

$14,000

$14,000

$14,000

$14,000

$14,000

$14,000

$14,000

$14,000

$14,000

$14,000

$14,000

$14,000

Renta de vehículo utilitario Ensenada

$7,000

$7,000

$7,000

$7,000

$7,000

$7,000

$7,000

$7,000

$7,000

$7,000

$7,000

$7,000

Renta vehículo utilitario Cd. Delicias, Chihuahua

$7,000

$7,000

$7,000

$7,000

$7,000

$7,000

$7,000

$7,000

$7,000

$7,000

$7,000

$7,000

Relacionado a Oficinas

$20,500

$20,500

$20,500

$20,500

$20,500

$21,500

$21,500

$21,500

$21,500

$21,500

$21,500

$21,500

Renta de bodega

$19,000

$19,000

$19,000

$19,000

$19,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

Papelería y gastos varios de oficina

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

$1,500

Tecnología

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

Investigación y desarrollo

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

Administración

-

-

-

-

-

-

-

-

-

-

-

-

Certificados Orgánicos OMRI - Productos: Allegro

-

-

-

-

-

-

-

-

-

-

-

-

Certificados Orgánicos OMRI - Productos: Vivace y H+Organic

-

-

-

-

-

-

-

-

-

-

-

-

Certificados Orgánicos OMRI - Productos: öbelo, Cadence y Rinox

-

-

-

-

-

-

-

-

-

-

-

-

Certificado Orgánico: ADW-79

-

-

-

-

-

-

-

-

-

-

-

-

Otros

$51,000

$1,000

$11,000

$11,000

$31,000

$66,000

$1,000

$1,000

$26,000

$31,000

$1,000

$21,000

Folletos

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

$1,000

Banners y Lonas

-

-

-

-

-

$5,000

-

-

$5,000

-

-

$5,000

Publicidad en revistas especializadas

-

-

$10,000

-

-

-

-

-

$10,000

-

-

-

$50,000

-

-

-

$30,000

$60,000

-

-

-

$30,000

-

-

-

-

-

$10,000

-

-

-

-

$10,000

-

-

$15,000

Stands en Expos Agrícolas Material publicitario (gorras, plumas, mochilas, sombreros, etc.)

37

Utilidad Neta Año 3 Margen Operativo

Mes 1

Mes 2

Mes 3

Mes 4

Mes 5

Mes 6

Mes 7

Mes 8

Mes 9

Mes 10

Mes 11

Mes 12

$644,041

$643,741

$604,369

$504,301

$528,271

$582,085

$535,515

$367,625

$464,375

$824,279

$1,160,215

$1,380,061

39%

41%

39%

37%

37%

38%

40%

32%

34%

44%

51%

52%

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

Intereses

-

-

-

-

-

-

-

-

-

-

-

-

Impuestos

-

-

-

-

-

-

-

-

-

-

-

-

Depreciación

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

Margen Neto

$641,641

$641,341

$601,969

$501,901

$525,871

$579,685

$533,115

$365,225

$461,975

$821,879

$1,157,815

$1,377,661

39%

40%

39%

36%

37%

38%

40%

32%

34%

44%

51%

52%

Margen Operativo % Otros Gastos

Margen Neto %

38

Flujo de Efectivo Flujo de Efectivo Año 1 Flujo de Efectivo en Operaciones

Mes 1

Mes 2

Mes 3

Mes 4

Mes 5

Mes 6

Mes 7

Mes 8

Mes 9

Mes 10

Mes 11

Mes 12

($129,287)

($95,932)

($167,138)

$66,250

$23,022

$236,969

$292,777

$297,648

$23,390

($160,852)

$245,038

$245,988

$27,939

$66,114

$128,588

$83,989

$193,410

$233,032

$235,192

$64,930

$191,270

$248,384

$296,364

$293,654

Depreciaciones y Amortizaciones

-

$275

$1,025

$1,400

$1,567

$1,567

$1,567

$1,567

$1,567

$1,567

$1,567

$1,567

Cambios en Cuentas por Pagar

-

-

-

-

-

-

-

-

-

-

-

-

Cambios en Inventario

-

-

-

-

-

-

-

-

-

-

-

-

Impuestos de Inventario

-

-

-

-

-

-

-

-

-

-

-

-

($157,226)

($155,881)

($278,818)

$10,542

($140,485)

$16,774

$56,863

$240,886

($158,410)

($406,070)

($26,030)

($27,840)

Cambios en Impuestos sobre Ventas

-

($6,440)

($17,933)

($29,681)

($31,469)

($14,404)

($845)

($9,734)

($11,037)

($4,733)

($26,862)

($21,393)

Cambios en Impuestos sobre Ganancias

-

-

-

-

-

-

-

-

-

-

-

-

Cambio en Ingresos cobrados por Adelantado

-

-

-

-

-

-

-

-

-

-

-

-

Flujo de Efectivo en Inversiones

($19,140)

($52,200)

($26,100)

($11,600)

-

-

-

-

-

-

-

-

Compra/Venta de Activos

($16,500)

($45,000)

($22,500)

($10,000)

-

-

-

-

-

-

-

-

Impuestos de Activos

($2,640)

($7,200)

($3,600)

($1,600)

-

-

-

-

-

-

-

-

Flujo de Efectivo por Financiamiento

$170,100

$170,100

$170,100

$170,100

-

-

-

-

-

-

-

-

Inversiones

$170,100

$170,100

$170,100

$170,100

-

-

-

-

-

-

-

-

Dividendos

-

-

-

-

-

-

-

-

-

-

-

-

Cambio en Deuda a Corto Plazo

-

-

-

-

-

-

-

-

-

-

-

-

Cambio en Deuda a Largo Plazo

-

-

-

-

-

-

-

-

-

-

-

-

Utilidad Neta

Cambios en Cuentas por Cobrar

Flujo al Inicio del Periodo

-

$21,673

$43,641

$20,503

$245,253

$268,275

$505,244

$798,022

$1,095,670

$1,119,060

$958,208

$1,203,247

Flujo de Efectivo del Periodo

$21,673

$21,968

($23,138)

$224,750

$23,022

$236,969

$292,777

$297,648

$23,390

($160,852)

$245,038

$245,988

Flujo de Efectivo Acumulado

$21,673

$43,641

$20,503

$245,253

$268,275

$505,244

$798,022

$1,095,670

$1,119,060

$958,208

$1,203,247

$1,449,234

39

Flujo de Efectivo Año 2

Mes 1

Mes 2

Mes 3

Mes 4

Mes 5

Mes 6

Mes 7

Mes 8

Mes 9

Mes 10

Mes 11

Mes 12

Flujo de Efectivo en Operaciones

$213,541

$312,284

$242,005

$309,287

$217,333

$366,927

$548,871

$441,252

$82,581

$108,241

$407,165

$613,925

Utilidad Neta

$270,873

$321,313

$367,741

$341,709

$386,189

$419,987

$391,381

$226,539

$304,333

$485,439

$645,538

$661,390

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$3,233

$3,233

Cambios en Cuentas por Pagar

-

-

-

-

-

-

-

-

-

-

-

-

Cambios en Inventario

-

-

-

-

-

-

-

-

-

-

-

-

Impuestos de Inventario

-

-

-

-

-

-

-

-

-

-

-

-

Cambios en Cuentas por Cobrar

($40,113)

$9,350

($111,731)

($15,498)

($160,962)

($50,506)

$176,390

$219,124

($212,048)

($378,856)

($238,199)

($47,773)

Cambios en Impuestos sobre Ventas

($19,619)

($20,779)

($16,404)

($19,325)

($10,295)

($4,954)

($21,300)

($6,811)

($12,104)

($742)

($3,407)

($2,925)

Cambios en Impuestos sobre Ganancias

-

-

-

-

-

-

-

-

-

-

-

-

Cambio en Ingresos cobrados por Adelantado

-

-

-

-

-

-

-

-

-

-

-

-

Flujo de Efectivo en Inversiones

-

-

-

-

-

-

-

-

-

($58,000)

-

-

Compra/Venta de Activos

-

-

-

-

-

-

-

-

-

($50,000)

-

-

Impuestos de Activos

-

-

-

-

-

-

-

-

-

($8,000)

-

-

Flujo de Efectivo por Financiamiento

-

-

-

-

-

-

-

-

-

-

-

-

Inversiones

-

-

-

-

-

-

-

-

-

-

-

-

Dividendos

-

-

-

-

-

-

-

-

-

-

-

-

Cambio en Deuda a Corto Plazo

-

-

-

-

-

-

-

-

-

-

-

-

Cambio en Deuda a Largo Plazo

-

-

-

-

-

-

-

-

-

-

-

-

$1,449,234

$1,662,775

$1,975,059

$2,217,065

$2,526,351

$2,743,684

$3,110,611

$3,659,482

$4,100,734

$4,183,315

$4,233,556

$4,640,721

Flujo de Efectivo del Periodo

$213,541

$312,284

$242,005

$309,287

$217,333

$366,927

$548,871

$441,252

$82,581

$50,241

$407,165

$613,925

Flujo de Efectivo Acumulado

$1,662,775

$1,975,059

$2,217,065

$2,526,351

$2,743,684

$3,110,611

$3,659,482

$4,100,734

$4,183,315

$4,233,556

$4,640,721

$5,254,646

Depreciaciones y Amortizaciones

Flujo al Inicio del Periodo

40

Flujo de Efectivo Año 3

Mes 1

Mes 2

Mes 3

Mes 4

Mes 5

Mes 6

Mes 7

Mes 8

Mes 9

Mes 10

Mes 11

Mes 12

Flujo de Efectivo en Operaciones

$628,967

$705,566

$632,084

$712,076

$462,633

$466,241

$728,698

$604,477

$187,673

$229,110

$691,100

$915,012

Utilidad Neta

$641,642

$641,342

$601,970

$501,902

$525,872

$579,686

$533,116

$365,226

$461,976

$821,880

$1,157,816

$1,377,662

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

$2,400

Cambios en Cuentas por Pagar

-

-

-

-

-

-

-

-

-

-

-

-

Cambios en Inventario

-

-

-

-

-

-

-

-

-

-

-

-

Impuestos de Inventario

-

-

-

-

-

-

-

-

-

-

-

-

Cambios en Cuentas por Cobrar

($8,273)

$66,417

$27,775

$212,396

($59,392)

($102,451)

$194,277

$247,103

($274,108)

($585,990)

($458,367)

($446,660)

Cambios en Impuestos sobre Ventas

($6,801)

($4,592)

($61)

($4,622)

($6,246)

($13,393)

($1,094)

($10,252)

($2,595)

($9,180)

($10,748)

($18,389)

Cambios en Impuestos sobre Ganancias

-

-

-

-

-

-

-

-

-

-

-

-

Cambio en Ingresos cobrados por Adelantado

-

-

-

-

-

-

-

-

-

-

-

-

Flujo de Efectivo en Inversiones

-

-

-

-

-

-

-

-

-

-

-

-

Compra/Venta de Activos

-

-

-

-

-

-

-

-

-

-

-

-

Impuestos de Activos

-

-

-

-

-

-

-

-

-

-

-

-

Flujo de Efectivo por Financiamiento

-

-

-

-

-

-

-

-

-

-

-

-

Inversiones

-

-

-

-

-

-

-

-

-

-

-

-

Dividendos

-

-

-

-

-

-

-

-

-

-

-

-

Cambio en Deuda a Corto Plazo

-

-

-

-

-

-

-

-

-

-

-

-

Cambio en Deuda a Largo Plazo

-

-

-

-

-

-

-

-

-

-

-

-

$5,254,646

$5,883,614

$6,589,180

$7,221,263

$7,933,339

$8,395,972

$8,862,213

$9,590,911

$10,195,388

$10,383,061

$10,612,171

$11,303,271

$628,967

$705,566

$632,084

$712,076

$462,633

$466,241

$728,698

$604,477

$187,673

$229,110

$691,100

$915,012

Depreciaciones y Amortizaciones

Flujo al Inicio del Periodo Flujo de Efectivo del Periodo

41

Flujo de Efectivo Año 3 Flujo de Efectivo Acumulado

Mes 1 $5,883,614

Mes 2 $6,589,180

Mes 3 $7,221,263

Mes 4 $7,933,339

Mes 5 $8,395,972

Mes 6 $8,862,213

Mes 7 $9,590,911

Mes 8 $10,195,388

Mes 9 $10,383,061

Mes 10 $10,612,171

Mes 11 $11,303,271

Mes 12 $12,218,283

42