Plantillas De Visio

Administracion de capital de trabajo

Conservador Alternativo

Meses Requerimientos totales Requerimientos permanentes Requerimiento estacional Requerimientos permanentes Requerimiento estacional

Enero $959,300 $230,000 $729,300 $595,250 $364,050

Febrero $456,789 $230,000 $226,789 $595,250 0

Marzo $340,100 $230,000 $110,100 $595,250 0

Abril $901,654 $230,000 $671,654 $595,250 $306,404

Mayo $230,000 $230,000 0 $595,250 0

Junio $239,100 $230,000 $9,100 $595,250 0

Julio $398,000 $230,000 $168,000 $595,250 0

Agosto $330,000 $230,000 $100,000 $595,250 0

Septiembre $840,000 $230,000 $610,000 $595,250 $244,750

Octubre $310,590 $230,000 $80,590 $595,250 0

Noviembre $960,500 $230,000 $730,500 $595,250 $365,250

Diciembre $499,700 $230,000 $269,700 $595,250 0

Totales $6,465,733 $2,760,000 $3,705,733 $7,143,000 $1,280,454

Enfoque compensatorio Enfoque conservador Enfoque alternativo

CT=Req. Permanente - Req. Minimo CT=Req. Maximo - Req. Minimo CT=Req. permanente - Req. Minimo

0 = 230 000 - 230 000 730 500 = 960 500 - 230 000 365 250 = 595 250 - 230 000

Costo financiero Costo financiero Costo financiero

(3 705 733/12) Cp (33%) = 101 907.66 (Req. Maximo) (tasa) (1 280 454/12) Cp (33%) = 35 212.48

(960 500) (49%) = 470 645

(230 000) Lp (49%) = 112 700 (595 250) Lp (49%) = 291 672.50

214 607.66 214 607.66

Ejercicio 1

Conservador Alternativo

Meses Requerimientos totales Requerimientos permanentes Requerimiento estacional Requerimientos permanentes Requerimiento estacional

Enero $2,150,000 $1,346,000 $804,000 $2,245,500 0

Febrero $2,850,000 $1,346,000 $1,504,000 $2,245,500 $604,500

Marzo $1,590,000 $1,346,000 $244,000 $2,245,500 0

Abril $1,450,000 $1,346,000 $104,000 $2,245,500 0

Mayo $2,750,000 $1,346,000 $1,404,000 $2,245,500 $504,500

Junio $3,145,000 $1,346,000 $1,799,000 $2,245,500 $899,500

Julio $1,346,000 $1,346,000 0 $2,245,500 0

Agosto $1,379,000 $1,346,000 $33,000 $2,245,500 0

Septiembre $1,730,000 $1,346,000 $384,000 $2,245,500 0

Octubre $1,794,000 $1,346,000 $448,000 $2,245,500 0

Noviembre $1,375,000 $1,346,000 $29,000 $2,245,500 0

Diciembre $1,975,000 $1,346,000 $629,000 $2,245,500 0

Totales $23,534,000 $16,152,000 $7,382,000 $26,946,000 $2,008,500

Enfoque compensatorio Enfoque conservador Enfoque alternativo

CT=Req. Permanente - Req. Minimo CT = Req. Maximo - Req. Minimo CT=Req. permanente - Req. Minimo

0 = 1 346 000 - 1 346 000 1 789 000 = 3 145 000 - 1 346 000 899 500 = 2 245 500 - 1 346 000

Costo financiero Costo financiero Costo financiero

(7 382 000/12) Cp (14.75%) = 90 737.08 (Req. Maximo) (tasa) (2 008 500/12) Cp (14.75%) = 24 687.81

(3 145 000) (18.45%) = 581 825

(1 346 000) Lp (18.50%)= 249 010 (2 245 500) Lp (18.50%) =

...