GCGF_U3_A2_MAVG.xlsx

RESUMEN DEL FINANCIAMIENTO NOMBRE DE LA PYME

CREACIONES PAULETT, S.A.

PRODUCTO QUE VENDE

VESTIDOS PARA XV AÑOS

ESTADO

CIUDAD DE MEXICO

AÑO DE CONSTI

CUAUHTEMOC

No. AÑOS EXPE

MUNICIPIO/DELEGACION

NOMBRE DEL ALUMNO

MARIA ELENA VARELA GOMEZ

OBJETIVO DEL PLAN INCREMENTAR INCREMENTAR LA PRODUCCION

META 150 MODELOS DE CADA ESPECIALIDAD MONTO A FINANCIAR

mens!". RECURSOS PROPIOS RECURSOS EXTERNOS TOTAL

INDICADORES DE MEDICION

VAN TIR

NOMBRE DE LA INSTITUCI$N FINANCIERA A LA QUE SOLICITARAS SOLICITARAS RECURSOS% RECURSOS % Citibanamex

TASA DE INTER&S ANUAL QUE COBRA '()

*+. ,-

PLAO

Resmen e" Es0!o e F"1o e E2e3045o e" es3en!64o 3onse65!o6 7 8es4m4s0! Flujo de efectvo cifras en pesos Escenario

Acual

1

2

3

Conse65!o(

Sa)*+ ina) *e -aa

69,06

!",#$6

%,&&0

9,96#

Pes4m4s0!

Sa)*+ ina) *e -aa

69,06

!%,06

!9,"''

!6,&%&

ANALISIS DE RESULTADOS ● Es3en!64o 3onse65!o6%

En e/te e/-ena(i+ /e a(e-ia 12e a2n12e en e) (ime( a3+ (e/ente n2me(+ n2me(+ ne4ati5+, e/ +/ib)e (+-e*e( -+n e) )an * inan-iamient+ a 12e en )+/ a3+/ *e)  a) " (e/ente n2me(+/ +/iti5+/  en a2ment+.

● Es3en!64o 8es4m4s0!%

Trusted by over 1 million members

Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.







C+m+ /e a(e-ia, a(e-ia, e/te e/-ena(i+ e/-ena(i+ a a(ti( *e) *e) a3+ 2n+ /e (e/ente 2n /a)*+ /a)*+ ina) *e -aa ne4ati5+, ne4ati5+, +( )+ 12e n+ e/ +/ib inan-iemient+ a 12e (e/enta(a (+b)ema/ a(a )i12i*a( )a *e2*a -+n Citibanamex.







UCION

%99&

IENCIA

0

11,656 261,300

#

9 :9; <-,

,=

7

9;=+>;>+,

8

>>9.<

MESES

4

5

%%,%#0

%9,69

!$,9#'

!%,00'







)e ))e5a( a -a5+ e) )an *e







CALCL! "EL #A$! AL F%&A&C%A'%E&(! 'es

)aldo inicio de *es

iner+s *ensual

pao de iner+s

#ao a -nancia*ieno

.

/

.

.

a



c a 

d

1

261,300

1.55%

4,050

8,557

2

256,793

1.55%

3,980

8,487

3

252,287

1.55%

3,910

8,417

4

247,780

1.55%

3,841

8,347

5

243,274

1.55%

3,771

8,277

6

238,767

1.55%

3,701

8,207

7

234,260

1.55%

3,631

8,138

8

229,754

1.55%

3,561

8,068

9

225,247

1.55%

3,491

7,998

10

220,741

1.55%

3,421

7,928

11

216,234

1.55%

3,352

7,858

12

211,727

1.55%

3,282

7,788

13

207,221

1.55%

3,212

7,719

14

202,714

1.55%

3,142

7,649

15

198,208

1.55%

3,072

7,579

16

193,701

1.55%

3,002

7,509

17

189,194

1.55%

2,933

7,439

18

184,688

1.55%

2,863

7,369

19

180,181

1.55%

2,793

7,299

20

175,675

1.55%

2,723

7,230

21

171,168

1.55%

2,653

7,160

22

166,661

1.55%

2,583

7,090

23

162,155

1.55%

2,513

7,020

24

157,648

1.55%

2,444

6,950

25

153,142

1.55%

2,374

6,880

26

148,635

1.55%

2,304

6,810

27

144,128

1.55%

2,234

6,741

28

139,622

1.55%

2,164

6,671

29

135,115

1.55%

2,094

6,601

30

130,609

1.55%

2,024

6,531

31

126,102

1.55%

1,955

6,461

32

121,595

1.55%

1,885

6,391

33

117,089

1.55%

1,815

6,321

34

112,582

1.55%

1,745

6,252

35

108,076

1.55%

1,675

6,182

36

103,569

1.55%

1,605

6,112

37

44,983

1.55%

697

5,204







43

17,944

1.55%

278

4,785

44

13,437

1.55%

208

4,715

45

8,930

1.55%

138

4,645

46

4,424

1.55%

69

4,575

47 48 49 50 51 52 53 54 55 56 57 58 59 60 (oal

331,31









)aldo -n de *es .  e acd

256,793 252,287 247,780 243,274 238,767 234,260 229,754 225,247 220,741 216,234 211,727 207,221 202,714 198,208 193,701 189,194 184,688 180,181 175,675 171,168 166,661 162,155 157,648 153,142 148,635 144,128 139,622 135,115 130,609







13,437 8,930 4,424 83







Escenario Conservador S8es0os% a.

75

E) nme(+ *e 2ni*a*e/ 5en*i*a/ /e in-(ementa a a(ti( *e) (ime( a3+ en:

b.

E) nme(+ *e 2ni*a*e/ 5en*i*a/ /e in-(ementa en %8 an2a) a a(ti( *e) /e42n*+ a3+.

-.

In)a-in *e $.#8 an2a) ima-tan*+ e) (e-i+ *e) (+*2-t+ + /e(5i-i+  )+/ -+/t+/.

&o*re de la e*presa8

E)(A"! "E 7E)L(A"!) C7EAC%!&E) #ALE((, )9A9 "E C9:9 Cifra en pesos

CONCEPTO

*. Ven0!s 0o0!"es '! ? @) a; Nme(+ *e 2ni*a*e/ 5en*i*a/

AÑO A30!"

*

9

>

, , = ;= = =

* ;* - * ;= : =

*;9=-;-<,

* ;9 , 9 ;: = -

%%0

%&"

%&#

%&9

b; P(e-i+ 2nita(i+

6,000

6,

6,'"

6,69%

9. Cos0o e Ven0!s

0#,&"

%","'$

$,"%&

$%,#&&

>. U04"4! @60! '*9)

 - 9 ;*  +

<>-;-9:

<+9;=:<

* ; = > = ;< * +

',000

',&&&

",&09

6,#6'

L2<

$,000

$,%%%

$,6

$,$'"

Te)=+n+

',&00

',9#&

",%6

",$"$

A42a

,000

,0#'

,%"%

,$0

P>4ina ?eb

6,000

6,

6,'"

6,69%

%&$,000

%&9,##%

%96,#9$

0',0#'

",000

",%&"

",$##

","#6

%,000

%,'''

%,90'

%$,$&

. G!s0os e o8e6!34n

9 > < ;+ = =

9>*;=

9><;-<9

9  + ; - :

-. U04"4! e e o8e6!34n '>)

9 * 9 ;>  +

:=;+

:9;+,

: + 9 ; , =

",000

&,00

&,"00

&,"00

9 = : ;>  +

,<,;9+

:>>;<+,

: : > ;< , =

,""9

#",#"6

#9,&"&

&',0#

F"1o e e2e3045o ne0o ',:)

* +  ;: + <

,9=;-9+

,-;*9<

, + < ;: - 

R!n e 6en0!@4"4!

2;900/

5391/

54926/

54963/

Renta *e) )+-a)

Sa)a(i+/ P2b)i-i*a* IMSS

a; Men+/@ De(e-ia-i+ne/

,. U04"4! !n0es e 4m8es0os '-!) #. Im2e/t+ a )a 2ti)i*a* %0,&&8

P6ome4o !n!"







+!*!-*$!)& -&! #$-/#& $)$#!&

270,396

+!*!-*$!)& -&! #$-/#& '#&'&

36,242

a (oal de enradas de efectvo

660,000

1,45=,=0;

1,205,56

1,262,=05

Costo de ventas

207,852

215,543

223,518

231,788

*)& $ &'$#*-!

239,800

231,044

239,592

248,457

P*"& * !*!-*$!)& $)$#!&

83,547

83,547

&$,"'#

P*"& * !*!-*$!)& !)$#!&

604

604

604

Salidas de efecvo efecvo

I!($#! $ -*')* I'/$)& &#$ * #$!)*

306,638 22,559

75,756

79,858

84,207

4=0,211

13,131

62=,11

64;,603

0

189,789

544,577

578,478

E!)#** $ $$-(&

660,000

1,457,708

1,205,596

1,262,705

S** $ $$-(&

470,211

913,131

627,119

648,603

c )aldo -nal de caja a

1;,=;

544,5==

5=;,4=;

614,102

 (oal de salidas de efectvo Saldo inicial de caja







, $ *-/$#& * &$(& &$(& : $)* $ * $'#$*. $'#$*.



-

*;>99;-9=

*;>+-;*,:

%9%

%9$

6,9$9

#,%9"

'0,$6'

'9,"#

*;=+9;*-,

*;*>-;<*=

#,#"'

&,#&%

$,'69

$,"9&

",""%

",#"6

,$%$

,$9&

6,9$9

#,%9"

%%,6"

%9,'""

",#&

",996

%$,&##

%',$90

9-:;,-=

9,:;*+>

+9;-=,

+,+;:9:

&,6"0

9,000

+*-;+-,

+-<;:9:

%'6,0%

%"',06$

,,<;,-

:=-;,,

50963/

5094/ 4;9=3/









1,322,520

1,3;5,16=

240,364

249,257

257,650

267,183

&$,"'#

&$"'#

60'

60'.0'

146,201

154,063

=2;,366

=54,655

614,102

594,153

1,322,520

1,385,167

728,366

754,655

54,153

630,513







Escenario #esi*isa S8es0os% a.

*;&

E) nme(+ *e 2ni*a*e/ 5en*i*a/ /e *i/min2e %0 ie
b.

E) nme(+ nme(+ *e 2ni*a 2ni*a*e *e/ / 5en*i 5en*i*a/ *a/ e(ma e(manene-e e -+n/ -+n/tan tante te *2(ant *2(ante e )+/ )+/ -in-in-+ + a3+/ a3+/,, e/ *e-i( *e-i(,, n+ Ba Ba -(e-i -(e-i

-.

In)a-in *e $.#8 an2a) ima-tan*+ e) (e-i+ *e) (+*2-t+ + /e(5i-i+  )+/ -+/t+/.

&o*re de la e*presa8

E)(A"! "E 7E)L(A"!) C7EAC%!&E) #ALE((, )9A9 "E C9:9 Cifra en pesos

CONCEPTO

*. Ven0!s 0o0!"es '! ? @) a; Nme(+ *e 2ni*a*e/ 5en*i*a/

AÑO A30!"

*

9

>

, , = ;= = =

, - * ;= = =

,>=; ===

,=+; ===

%%0

%0"

%00

9"

b; P(e-i+ 2nita(i+

6,000

6,00

6,$00

6,'00

9. Cos0o e Ven0!s

%%'

%%&

%$

%#

, - < ;+ + ,

,-=;++9

,9<;+::

, = : ;+ : >

Renta *e) )+-a)

%&,000

%&,666

%9,$"#

0,0#$

L2<

"',000

"",99&

"&,0#0

60,%9

Te)=+n+

0

0

0

0

Sa)a(i+/

%',000

%&,"&&

%$$,$'6

%$&,&0

0

0

0

0

',"$

','%0

',"#'

',#'$

+ , = ;* > <

+-+;-

+-;99>

+ > * ;* + ,

 9 = = ;9 - >

9=:;,,9

9*-;>,

99>;>*

",000

&,00

&,"00

&,"00

>. U04"4! @60! '*9)

P2b)i-i*a* Im//

. G!s0os e o8e6!34n -. U04"4! e e o8e6!34n '>) a; Men+/@ De(e-ia-i+ne/







a (oal de enradas de efectvo

660,000

5=,63;

630,000

60;,000

114

118

123

127

860,139

858,544

845,223

831,186

P*"& * !*!-*$!)& $)$#!&

83,547

83,547

&$,"'#

P*"& * !*!-*$!)& !)$#!&

604

604

604

Salidas de efecvo efecvo Costo de ventas

*)& $ &'$#*-!

I!($#! $ -*')*

306,638

I'/$)& &#$ * #$!)*

22,332

23,486

24,354

25,221

 (oal de salidas de efectvo

;3=,21

1,225,66

05,142

;0,243

0

177,921

268,328

275,142

E!)#** $ $$-(&

660,000

957,638

630,000

608,000

S** $ $$-(&

837,921

1,225,966

905,142

890,243

1==,21

26;,32;

2=5,142

2;2,243

Saldo inicial de caja

c )aldo -nal de caja a







, $ $-#, $-#, $!& $ *


-

-+ - ;= = =

-,*; === 90

&"

6,"00

6,600

%$

%$#

-+;+,+

-,=;+,>

0,&%6

%,"&6

6,''#

6',#"#

0

0

%'$,$96

%'&,#0

0

0

',9%&

",%00

+*,;

+=*;==+

9>*;-:,

9=;*-

&,6"0

9,000







5;5,000

561,000

132

137

816,444

801,008

&$,"'#

&$"'#

60'

60'.0'

26,137

27,107

;=4,51

;5;,1;

282,243

289,591

585,000

561,000

874,591

858,189

2;,51

2=,1;

GCGF_U3_A2_MAVG.xlsx

Recommend Documents