3 Solucion Caso Keafer

A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41

B

A 42 43

B

A

B

44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81

Q1: Q2: Q3: Q4:

C 1 2

Capitulo 26 ADMINISTRACION DE CAPITAL DE TRABAJO KEAFER MANUFA

3 4

 Area de datos dados:

5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

Saldo de cuentas por cobrar  Porcentaje de cuentas incobrables Periodo de cuentas por cobrar  % De compras para el siguiente trimestre Días de pago a los proveedores % de ventas para gastos (salarios impuestos otros costos! "ntereses # dividendos Desembolso en el trimestre 3 Saldo e$ectivo inicial bjetivo de saldo de e$ectivo Porcentaje de interes prestamos a corto pla&o (trimestral! Porcentaje de interes inversiones a la vista (trimestral! Pr'stamo de corto pla&o inicial

20 21 22

entas brutas a)o anterior 

23 24

Porcentaje de crecimiento en ventas

25 26 27

Tabla de resultados:

28 29 30 31

entas del pr*+imo a)o entas del a)o posterior al pr*+imo a)o

32 33 34 35 36 37 38 39 40 41

,ecaudaciones correspondientes al trimestre anterior  ,ecaudaciones correspondientes al trimestre actual Pagos a proveedores trimestre anterior  Pagos a proveedores trimestre actual -+penses Dividends and interest utla#

C 42 43

.et cas/ $lo0

C 44 45 46 47 48 49 50

eginning cas/ balance .et cas/ in$lo0 -nding cas/ balance inimum cas/ balance umulative surplus (de$icit!

51

 Sh

52 53 54 55 56 57 58 59 60 61 62 63

arget cas/ balance .et cas/ in$lo0 .e0 s/ort5term investments "ncome on s/ort5term investments S/ort5term investments sold .e0 s/ort5term borro0ing "nterest on s/ort5term borro0ing S/ort5term borro0ing repaid -nding cas/ balance inimum cas/ balance umulative surplus (de$icit!

64 65 66 67 68

eginning s/ort5term investments -nding s/ort5term investments eginning s/ort5term debt -nding s/ort5term debt

69 70 71 72 73

-+cess $unds at start o$ 6uarter o$  -+cess $unds at start o$ 6uarter o$  -+cess $unds at start o$ 6uarter o$  -+cess $unds at start o$ 6uarter o$ 

74 75 76 77 78 79 80 81

.et cas/ cost Q1 Q2 Q3 Q4 as/ generated b# s/ort5term $inancing

D

E

F

Q2

Q3

1

 

2

TURING

3 4 5 6 7

7

883999 19% 8 89% 83 28% 14;999 2<9999 14=899 =9999 1>2% 9>8% 5

8 9 10 11 12 13 14 15 16

7 7 7 7

17 18 19

 7

20

Q1

21 22

7

38999 7

<1999 7

;1999

19<484>9 7

114<998>=9

Q2

Q3

<82=8<>;8 7 3=1499>9< (31439 (314 39<>1 <>11! 1! (2388<>;;! (2388< >;;! (2<<;<3><;! (2<<;< 3><;! (14;999>99! (14;99 9>99!  

<<984><4 429292>1< (3343 (33 438>9 8>9! ! (29442>=4! (29442 >=4! (2;<891>4;! (2;<89 1>4;! (14;999>99! (14;99 9>99! (2<9999>99!

23

49>2%

24 25 26 27 28 29 30 31

7 7

1939=;4>89 7 144<1<1>=<

32

Quarterly cash flo 

33

Q1

34 35 36 37 38 39 40 41

7

4=99>99 7 3;92><8 (3938< (393 8<>< ><24! (21=4 21>24! (284<>13! (28 4<>13! (14;999>99! (14;9 99>99!

D 42 43

7

E

(8399>3;! (8399 >3;! 7

F

=<1=>28 =<1= >28 7

(14919><;! (1491 9><;!

D

Cash Balance Q1

44 45 46

7

47 48

7

49 50

7

14=899>99 7 (8399>3;! (8399 >3;! =<4=2><2 7 =9999>99 <4=2><2 7

E

F

Q2

Q3

=<4=2><2 7 =<1=>28 =<1=> 28 1<11 1<1 11>; 7 =9999>99 ;<11 ;<1 11>; 7

1<111>; 1<11 (14919><;! (14919 ><;! 3<994>1= =9999>99 (83==8>;1!

=9999>99 7 (8399>3;! (8399 >3;! 5 2=>89 829=>;; 5 5 5 =9999>99 7 (=9999> (=9 999>99! 99! 5 7

=9999>99 7 =<1=>28 =<1=> 28 (== (= =1< 1<> >8! 8! 2=>89 5 5 5 5 =9999>99 7 (=9999 (=9 999>99 >99!! 5 7

=9999>99 (14919><;! (14919 ><;! 5 <=>9; 13=419>8= 5 5 5 =9999>99 (=9999> (=9 999>99! 99! 5

8=899>99 7 8=899>99 5 5 7

8=899>99 7 13=41<>8 5 5 7

13=41<>8 <>18 5 5

51 52 53

ort-term Financial Plan

7

54 55 56 57 58 59 60 61

7

62 63

7

64 65

7

66 67 68

7

69

78=899>99 78=899>99 713=41<>8 7<>18

70 71 72 73 74 75 76

7

77 78 79 80 81

$

2=>89 2=>89 <=>9; 9>93 12!2"11

earns earns earns earns

72=>89 72=>89 7<=>9; 79>93

G

H

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Q!

21 22

7

9=999

7

==4814>39

23 24 25 26 27 28 29 30 31 32 33

Q!

34

7

35 36 37 38 39 40 41

     

28;93>4 3<4<88>24 (2=2;2=>21! (2=2<<><2! (24;<2;>8;! (14;999>99!

G 42 43

7

19334>8

H

G 44

Q!

45 46

7

47 48

7

49 50

7

3<994>1= 19334>8 13=3;>< =9999>99 4=3;><

51 52 53

7

54 55 56

 

57 58 59 60 61

7

62 63

 7

=9999>99 19334>8 (19334><9! 9>93 5 5 5 5 =9999>99 (=9999>99! 5

64 65

7

66 67 68

7

69 70 71 72 73 74 75 76 77 78 79 80 81

in income> in income> in income> in income>

<>18 19349>8 5 5

H

A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41

B

A 42 43

B

A

B

44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81

Q1: Q2: Q3: Q4:

C 1 2

Capitulo 26 ADMINISTRACION DE CAPITAL DE TRABAJO KEAFER MANUFA

3 4

 Area de datos dados:

5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

Saldo de cuentas por cobrar  Porcentaje de cuentas incobrables Periodo de cuentas por cobrar  % De compras para el siguiente trimestre Días de pago a los proveedores % de ventas para gastos (salarios impuestos otros costos! "ntereses # dividendos Desembolso en el trimestre 3 Saldo e$ectivo inicial bjetivo de saldo de e$ectivo Porcentaje de interes prestamos a corto pla&o (trimestral! Porcentaje de interes inversiones a la vista (trimestral! Pr'stamo de corto pla&o inicial

20 21 22

entas brutas a)o anterior 

23 24

Porcentaje de crecimiento en ventas

25 26 27

Tabla de resultados:

28 29 30 31

entas del pr*+imo a)o entas del a)o posterior al pr*+imo a)o

32 33 34 35 36 37 38 39 40 41

,ecaudaciones correspondientes al trimestre anterior  ,ecaudaciones correspondientes al trimestre actual Pagos a proveedores trimestre anterior  Pagos a proveedores trimestre actual -+penses Dividends and interest utla#

C 42 43

.et cas/ $lo0

C 44 45 46 47 48 49 50

eginning cas/ balance .et cas/ in$lo0 -nding cas/ balance inimum cas/ balance umulative surplus (de$icit!

51

 Sh

52 53 54 55 56 57 58 59 60 61 62 63

arget cas/ balance .et cas/ in$lo0 .e0 s/ort5term investments "ncome on s/ort5term investments S/ort5term investments sold .e0 s/ort5term borro0ing "nterest on s/ort5term borro0ing S/ort5term borro0ing repaid -nding cas/ balance inimum cas/ balance umulative surplus (de$icit!

64 65 66 67 68

eginning s/ort5term investments -nding s/ort5term investments eginning s/ort5term debt -nding s/ort5term debt

69 70 71 72 73

-+cess $unds at start o$ 6uarter o$  -+cess $unds at start o$ 6uarter o$  -+cess $unds at start o$ 6uarter o$  S/ortage o$ $unds at start o$ 6uarter o$ 

74 75 76 77 78 79 80 81

.et cas/ cost Q1 Q2 Q3 Q4 as/ generated b# s/ort5term $inancing

D

E

F

Q2

Q3

1

 

2

TURING

3 4 5 6 7

7

883999 19% 8 89% 83 28% 14;999 2<9999 14=899 9999 1>2% 9>8% 5

8 9 10 11 12 13 14 15 16

7 7 7 7

17 18 19

 7

20

Q1

21 22

7

38999 7

<1999 7

;1999

;21;;9>99 7

;;23<9>99

23

;>99%

24 25 26 27 28 29 30 31

7 7

=3;99>99 7 ;8394>99

32

Quarterly cash flo 

33

Q1

34 35 36 37 38 39 40 41

7

4=99>99 7 2=19<9>99 (23339>99! (233 39>99! (1<;=42>99! (1<;= 42>99! (1=;489>99! (1=;4 89>99! (14;999>99! (14;9 99>99!

Q2

Q3

89249>99 7 39138<>99 (241==;>99! (241== ;>99! (1;134>99! (1;13 4>99! (29849>99! (2984 9>99! (14;999>99! (14;99 9>99!  

829824>99 323832>99 (28=;9<>99! (28=;9 <>99! (183=;>99! (183= ;>99! (2298=9>99! (2298= 9>99! (14;999>99! (14;99 9>99! (2<9999>99!

D 42 43

7

E

3=<3;>99 7

F

2284>99 7

(2913;>99!

D

Cash Balance Q1

44 45 46

7

47 48

7

49 50

7

14=899>99 7 3=<3;>99 1;=13;>99 7 9999>99 11=13;>99 7

E

F

Q2

Q3

1;=13;>99 7 2284>99 21<3=2>99 7 9999>99 14<3=2>99 7

21<3=2>99 (2913;>99! 14<84>99 9999>99 (8834<>99!

9999>99 7 3=<3;>99 (499 (49 938 38>8 >89! 9! 3=>89 5 5 5 5 9999>99 7 (9999> (9 999>99! 99! 5 7

9999>99 7 2284>99 (2; (2 ;81 81>< ><;! ;! 8=><; 5 5 5 5 9999>99 7 (9999 (9 999>99 >99!! 5 7

9999>99 (2913;>99! 5 3<>=4 143;>1; 83<13>;= 5 5 9999>99 (9999> (9 999>99! 99! 5

=899>99 7 11=838>89 5 5 7

11=838>89 7 143;>1; 5 5 7

143;>1; 5 5 83<13>;=

51 52 53

ort-term Financial Plan

7

54 55 56 57 58 59 60 61

7

62 63

7

64 65

7

66 67 68

7

69

7=899>99 711=838>89 7143;>1; 783<13>;=

70 71 72 73 74 75 76

7

77 78 79 80 81

$

3=>89 8=><; 3<>=4 (<43>3! 1#"%&

earns earns earns costs

73=>89 78=><; 73<>=4 7<43>3

G

H

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Q!

21 22

7

9=999

7

<829>99

23 24 25 26 27 28 29 30 31 32 33

Q!

34

7

35 36 37 38 39 40 41

     

88;;2;>99 2;9<4>99 (2284<2>99! (1<223><9! (1=1439>99! (14;999>99!

G 42 43

7

H

=;4<>49

G

H

44

Q!

45

7

46 47

7

48 49

7

50

14<84>99 =;4<>49 113139>49 9999>99 43139>49

51 52

7

53 54 55 56 57 58 59 60 61

  7

62 63

 7

9999>99 =;4<>49 (4421=>18! 5 5 5 (<43>3! (83<13>;=! 9999>99 (9999>99! 5

64 65

7

66 67 68

7

69 70 71 72 73 74 75 76 77 78 79 80 81

in income> in income> in income> in interest>

5 4421=>18 83<13>;= 5

A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41

B

A 42 43

B

A

B

44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81

Q1: Q2: Q3: Q4:

C 1 2

Capitulo 26 ADMINISTRACION DE CAPITAL DE TRABAJO KEAFER MANUFA

3 4

 Area de datos dados:

5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

Saldo de cuentas por cobrar  Porcentaje de cuentas incobrables Periodo de cuentas por cobrar  % De compras para el siguiente trimestre Días de pago a los proveedores % de ventas para gastos (salarios impuestos otros costos! "ntereses # dividendos Desembolso en el trimestre 3 Saldo e$ectivo inicial bjetivo de saldo de e$ectivo Porcentaje de interes prestamos a corto pla&o (trimestral! Porcentaje de interes inversiones a la vista (trimestral! Pr'stamo de corto pla&o inicial

20 21 22

entas brutas a)o anterior 

23 24

Porcentaje de crecimiento en ventas

25 26 27

Tabla de resultados:

28 29 30 31

entas del pr*+imo a)o entas del a)o posterior al pr*+imo a)o

32 33 34 35 36 37 38 39 40 41

,ecaudaciones correspondientes al trimestre anterior  ,ecaudaciones correspondientes al trimestre actual Pagos a proveedores trimestre anterior  Pagos a proveedores trimestre actual -+penses Dividends and interest utla#

C 42 43

.et cas/ $lo0

C 44 45 46 47 48 49 50

eginning cas/ balance .et cas/ in$lo0 -nding cas/ balance inimum cas/ balance umulative surplus (de$icit!

51

 Sh

52 53 54 55 56 57 58 59 60 61 62 63

arget cas/ balance .et cas/ in$lo0 .e0 s/ort5term investments "ncome on s/ort5term investments S/ort5term investments sold .e0 s/ort5term borro0ing "nterest on s/ort5term borro0ing S/ort5term borro0ing repaid -nding cas/ balance inimum cas/ balance umulative surplus (de$icit!

64 65 66 67 68

eginning s/ort5term investments -nding s/ort5term investments eginning s/ort5term debt -nding s/ort5term debt

69 70 71 72 73

-+cess $unds at start o$ 6uarter o$  -+cess $unds at start o$ 6uarter o$  -+cess $unds at start o$ 6uarter o$  S/ortage o$ $unds at start o$ 6uarter o$ 

74 75 76 77 78 79 80 81

.et cas/ cost Q1 Q2 Q3 Q4 as/ generated b# s/ort5term $inancing

D

E

F

Q2

Q3

1

 

2

TURING

3 4 5 6 7

7

883999 19% 8 89% 83 28% 14;999 2<9999 14=899 =9999 1>2% 9>8% 5

8 9 10 11 12 13 14 15 16

7 7 7 7

17 18 19

 7

20

Q1

21 22

7

38999 7

<1999 7

;1999

==989>99 7

;8;89>99

23

8>99%

24 25 26 27 28 29 30 31

7 7

189>99 7 ;1933>89

32

Quarterly cash flo 

33

Q1

34 35 36 37 38 39 40 41

7

4=99>99 7 2;2=8>99 (2223>89! (222 3>89! (1<424=>1! (1<42 4=>1! (1=2=3>89! (1=2= 3>89! (14;999>99! (14;9 99>99!

Q2

Q3

4;;8>99 7 2=2=;8>99 (23828>;3! (2382 8>;3! (1<338>;3! (1<33 8>;3! (1==<2>89! (1==< 2>89! (14;999>99! (14;99 9>99!  

89<9<8>99 314848>99 (2828;=>1! (2828; =>1! (183928>;3! (18392 8>;3! (2144<2>89! (2144< 2>89! (14;999>99! (14;99 9>99! (2<9999>99!

D 42 43

7

E

4;289>;3 7

F

223;8>;3 7

(294<>89!

D

Cash Balance Q1

44 45 46

7

47 48

7

49 50

7

14=899>99 7 4;289>;3 1=89>;3 7 =9999>99 1989>;3 7

E

F

Q2

Q3

1=89>;3 7 223;8>;3 22913<>< 7 =9999>99 13913<>< 7

22913<>< (294<>89! 12<<=>1 =9999>99 (339>;3!

=9999>99 7 4;289>;3 (4;8 (4; 84; 4;>3 >33! 3! 2=>89 5 5 5 5 =9999>99 7 (=9999> (=9 999>99! 99! 5 7

=9999>99 7 223;8>;3 (22= (22 =2< 2<>9 >9;! ;! 849>24 5 5 5 5 =9999>99 7 (=9999 (=9 999>99 >99!! 5 7

=9999>99 (294<>89! 5 <84>; 139=4>41 8;3;>22 5 5 =9999>99 (=9999> (=9 999>99! 99! 5

8=899>99 7 19;94;>33 5 5 7

19;94;>33 7 139=4>41 5 5 7

139=4>41 5 5 8;3;>22

51 52 53

ort-term Financial Plan

7

54 55 56 57 58 59 60 61

7

62 63

7

64 65

7

66 67 68

7

69

78=899>99 719;94;>33 7139=4>41 78;3;>22

70 71 72 73 74 75 76

7

77 78 79 80 81

$

2=>89 849>24 <84>; (=19>9
earns earns earns costs

72=>89 7849>24 7<84>; 7=19>9<

G

H

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Q!

21 22

7

9=999

7

44489>99

23 24 25 26 27 28 29 30 31 32 33

Q!

34

7

35 36 37 38 39 40 41

     

843398>99 22=<8>99 (21=1==>1! (1<<8<=>3;! (1;<112>89! (14;999>99!

G 42 43

7

H

=<3;;>=<

G

H

44

Q!

45

7

46 47

7

48 49

7

50

12<<=>1 =<3;;>=< 19=98;>13 =9999>99 1=98;>13

51 52

7

53 54 55 56 57 58 59 60 61

  7

62 63

 7

=9999>99 =<3;;>=< (1=<49><;! 5 5 5 (=19>922! =9999>99 (=9999>99! 5

64 65

7

66 67 68

7

69 70 71 72 73 74 75 76 77 78 79 80 81

in income> in income> in income> in interest>

5 1=<49><; 8;3;>22 5

A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41

B

A 42 43

B

A

B

44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81

Q1: Q2: Q3: Q4:

C 1 2

Capitulo 26 ADMINISTRACION DE CAPITAL DE TRABAJO KEAFER MANUFA

3 4

 Area de datos dados:

5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

Saldo de cuentas por cobrar  Porcentaje de cuentas incobrables Periodo de cuentas por cobrar  % De compras para el siguiente trimestre Días de pago a los proveedores % de ventas para gastos (salarios impuestos otros costos! "ntereses # dividendos Desembolso en el trimestre 3 Saldo e$ectivo inicial bjetivo de saldo de e$ectivo Porcentaje de interes prestamos a corto pla&o (trimestral! Porcentaje de interes inversiones a la vista (trimestral! Pr'stamo de corto pla&o inicial

20 21 22

entas brutas a)o anterior 

23 24

Porcentaje de crecimiento en ventas

25 26 27

Tabla de resultados:

28 29 30 31

entas del pr*+imo a)o entas del a)o posterior al pr*+imo a)o

32 33 34 35 36 37 38 39 40 41

,ecaudaciones correspondientes al trimestre anterior  ,ecaudaciones correspondientes al trimestre actual Pagos a proveedores trimestre anterior  Pagos a proveedores trimestre actual -+penses Dividends and interest utla#

C 42 43

.et cas/ $lo0

C 44 45 46 47 48 49 50

eginning cas/ balance .et cas/ in$lo0 -nding cas/ balance inimum cas/ balance umulative surplus (de$icit!

51

 Sh

52 53 54 55 56 57 58 59 60 61 62 63

arget cas/ balance .et cas/ in$lo0 .e0 s/ort5term investments "ncome on s/ort5term investments S/ort5term investments sold .e0 s/ort5term borro0ing "nterest on s/ort5term borro0ing S/ort5term borro0ing repaid -nding cas/ balance inimum cas/ balance umulative surplus (de$icit!

64 65 66 67 68

eginning s/ort5term investments -nding s/ort5term investments eginning s/ort5term debt -nding s/ort5term debt

69 70 71 72 73

-+cess $unds at start o$ 6uarter o$  -+cess $unds at start o$ 6uarter o$  -+cess $unds at start o$ 6uarter o$  S/ortage o$ $unds at start o$ 6uarter o$ 

74 75 76 77 78 79 80 81

.et cas/ cost Q1 Q2 Q3 Q4 as/ generated b# s/ort5term $inancing

D

E

F

Q2

Q3

1

 

2

TURING

3 4 5 6 7

7

883999 19% 8 89% 83 28% 14;999 2<9999 14=899 =9999 1>2% 9>8% 5

8 9 10 11 12 13 14 15 16

7 7 7 7

17 18 19

 7

20

Q1

21 22

7

38999 7

<1999 7

;1999

;4419>99 7

=9<;9>99

23

11>99%

24 25 26 27 28 29 30 31

7 7

;18;89>99 7 =988=3>89

32

Quarterly cash flo 

33

Q1

34 35 36 37 38 39 40 41

7

4=99>99 7 2==148>99 (249222>89! (2492 22>89! (13<34>;3! (13< 34>;3! (293=< (293 =<2>8 2>89! 9! (14;999>99! (14;9 99>99!

Q2

Q3

81<98>99 7 39=2>99 (24;29>1! (24;2 9>1! (1;<412>1! (1;<41 2>1! (2111 (21 11> >89! 89! (14;999>99! (14;99 9>99!  

834=;3>99 33281=>99 (2<922>;3! (2<92 2>;3! (1<19>1! (1<1 9>1! (22<1 (22< 1>8 >89! 9! (14;999>99! (14;99 9>99! (2<9999>99!

D 42 43

7

E

31928>1 7

F

32122>1 7

(1=<99;>89!

D

Cash Balance Q1

44 45 46

7

47 48

7

49 50

7

14=899>99 7 31928>1 1;9828>1 7 =9999>99 =9828>1 7

E

F

Q2

Q3

1;9828>1 7 32122>1 212<4>33 7 =9999>99 122<4>33 7

212<4>33 (1=<99;>89! 1<<3;>;3 =9999>99 (33<1>1!

=9999>99 7 31928>1 (313 (31 322 22>< ><! ! 2=>89 5 5 5 5 =9999>99 7 (=9999> (=9 999>99! 99! 5 7

=9999>99 7 32122>1 (328 (32 8< <>2 >2;! ;! 484>11 5 5 5 5 =9999>99 7 (=9999 (=9 999>99 >99!! 5 7

=9999>99 (1=<99;>89! 5 <1<>== 1233=;>=8 1==2>8< 5 5 =9999>99 (=9999> (=9 999>99! 99! 5

8=899>99 7 =9;22>< 5 5 7

=9;22>< 7 1233=;>=8 5 5 7

1233=;>=8 5 5 1==2>8<

51 52 53

ort-term Financial Plan

7

54 55 56 57 58 59 60 61

7

62 63

7

64 65

7

66 67 68

7

69

78=899>99 7=9;22>< 71233=;>=8 71==2>8<

70 71 72 73 74 75 76

7

77 78 79 80 81

$

2=>89 484>11 <1<>== (;<3>=1! &#'"%#

earns earns earns costs

72=>89 7484>11 7<1<>== 7;<3>=1

G

H

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Q!

21 22

7

9=999

7

;<==9>99

23 24 25 26 27 28 29 30 31 32 33

Q!

34

7

35 36 37 38 39 40 41

     

84381>99 2;;8<3>99 (23124>;3! (1;<14=>;! (1=<4>89! (14;999>99!

G 42 43

7

1992=1>;=

H

G

H

44

Q!

45

7

46 47

7

48 49

7

50

1<<3;>;3 1992=1>;= 11<=39>3 =9999>99 2<=39>2

51 52

7

53 54 55 56 57 58 59 60 61

  7

62 63

 7

=9999>99 1992=1>;= (2438>42! 5 5 5 (;<3>=1! (1==2>899 (=9999>99! 5

64 65

7

66 67 68

7

69 70 71 72 73 74 75 76 77 78 79 80 81

in income> in income> in income> in interest>

5 2438>42 1==2>8< 5

A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41

B

A 42 43

B

A

B

44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81

Q1: Q2: Q3: Q4:

C 1 2

Capitulo 26 ADMINISTRACION DE CAPITAL DE TRABAJO KEAFER MANUFA

3 4

 Area de datos dados:

5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

Saldo de cuentas por cobrar  Porcentaje de cuentas incobrables Periodo de cuentas por cobrar  % De compras para el siguiente trimestre Días de pago a los proveedores % de ventas para gastos (salarios impuestos otros costos! "ntereses # dividendos Desembolso en el trimestre 3 Saldo e$ectivo inicial bjetivo de saldo de e$ectivo Porcentaje de interes prestamos a corto pla&o (trimestral! Porcentaje de interes inversiones a la vista (trimestral! Pr'stamo de corto pla&o inicial

20 21 22

entas brutas a)o anterior 

23 24

Porcentaje de crecimiento en ventas

25 26 27

Tabla de resultados:

28 29 30 31

entas del pr*+imo a)o entas del a)o posterior al pr*+imo a)o

32 33 34 35 36 37 38 39 40 41

,ecaudaciones correspondientes al trimestre anterior  ,ecaudaciones correspondientes al trimestre actual Pagos a proveedores trimestre anterior  Pagos a proveedores trimestre actual -+penses Dividends and interest utla#

C 42 43

.et cas/ $lo0

C 44 45 46 47 48 49 50

eginning cas/ balance .et cas/ in$lo0 -nding cas/ balance inimum cas/ balance umulative surplus (de$icit!

51

 Sh

52 53 54 55 56 57 58 59 60 61 62 63

arget cas/ balance .et cas/ in$lo0 .e0 s/ort5term investments "ncome on s/ort5term investments S/ort5term investments sold .e0 s/ort5term borro0ing "nterest on s/ort5term borro0ing S/ort5term borro0ing repaid -nding cas/ balance inimum cas/ balance umulative surplus (de$icit!

64 65 66 67 68

eginning s/ort5term investments -nding s/ort5term investments eginning s/ort5term debt -nding s/ort5term debt

69 70 71 72 73

-+cess $unds at start o$ 6uarter o$  -+cess $unds at start o$ 6uarter o$  -+cess $unds at start o$ 6uarter o$  S/ortage o$ $unds at start o$ 6uarter o$ 

74 75 76 77 78 79 80 81

.et cas/ cost Q1 Q2 Q3 Q4 as/ generated b# s/ort5term $inancing

D

E

F

Q2

Q3

1

 

2

TURING

3 4 5 6 7

7

883999 19% 8 89% 83 28% 14;999 2<9999 14=899 =9999 1>2% 9>8% 5

8 9 10 11 12 13 14 15 16

7 7 7 7

17 18 19

 7

20

Q1

21 22

7

38999 7

<1999 7

;1999

;21;;9>99 7

;;23<9>99

23

;>99%

24 25 26 27 28 29 30 31

7 7

=3;99>99 7 ;8394>99

32

Quarterly cash flo 

33

Q1

34 35 36 37 38 39 40 41

7

4=99>99 7 2=19<9>99 (23339>99! (233 39>99! (1<;=42>99! (1<;= 42>99! (1=;489>99! (1=;4 89>99! (14;999>99! (14;9 99>99!

Q2

Q3

89249>99 7 39138<>99 (241==;>99! (241== ;>99! (1;134>99! (1;13 4>99! (29849>99! (2984 9>99! (14;999>99! (14;99 9>99!  

829824>99 323832>99 (28=;9<>99! (28=;9 <>99! (183=;>99! (183= ;>99! (2298=9>99! (2298= 9>99! (14;999>99! (14;99 9>99! (2<9999>99!

D 42 43

7

E

3=<3;>99 7

F

2284>99 7

(2913;>99!

D

Cash Balance Q1

44 45 46

7

47 48

7

49 50

7

14=899>99 7 3=<3;>99 1;=13;>99 7 =9999>99 ==13;>99 7

E

F

Q2

Q3

1;=13;>99 7 2284>99 21<3=2>99 7 =9999>99 12<3=2>99 7

21<3=2>99 (2913;>99! 14<84>99 =9999>99 (834<>99!

=9999>99 7 3=<3;>99 (3== (3= =38 38>8 >89! 9! 2=>89 5 5 5 5 =9999>99 7 (=9999> (=9 999>99! 99! 5 7

=9999>99 7 2284>99 (2 (2 81 81>1 >1;! ;! 4=>1; 5 5 5 5 =9999>99 7 (=9999 (=9 999>99 >99!! 5 7

=9999>99 (2913;>99! 5 <38>=3 121;<><; 3=18>3= 5 5 =9999>99 (=9999> (=9 999>99! 99! 5

8=899>99 7 ==438>89 5 5 7

==438>89 7 121;<><; 5 5 7

121;<><; 5 5 3=18>3=

51 52 53

ort-term Financial Plan

7

54 55 56 57 58 59 60 61

7

62 63

7

64 65

7

66 67 68

7

69

78=899>99 7==438>89 7121;<><; 73=18>3=

70 71 72 73 74 75 76

7

77 78 79 80 81

$

2=>89 4=>1; <38>=3 (;;<>=;! &'("6(

earns earns earns costs

72=>89 74=>1; 7<38>=3 7;;<>=;

G

H

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Q!

21 22

7

9=999

7

<829>99

23 24 25 26 27 28 29 30 31 32 33

Q!

34

7

35 36 37 38 39 40 41

     

88;;2;>99 2;9<4>99 (2284<2>99! (1<223><9! (1=1439>99! (14;999>99!

G 42 43

7

H

=;4<>49

G

H

44

Q!

45

7

46 47

7

48 49

7

50

14<84>99 =;4<>49 113139>49 =9999>99 23139>49

51 52

7

53 54 55 56 57 58 59 60 61

  7

62 63

 7

=9999>99 =;4<>49 (23<4>93! 5 5 5 (;;<>=;! (3=18>3=! =9999>99 (=9999>99! 5

64 65

7

66 67 68

7

69 70 71 72 73 74 75 76 77 78 79 80 81

in income> in income> in income> in interest>

5 23<4>93 3=18>3= 5