Simulacion Flujo de Caja 1(1)
-
Upload
alexander-vincent -
Category
Documents
-
view
224 -
download
0
Transcript of Simulacion Flujo de Caja 1(1)
-
7/24/2019 Simulacion Flujo de Caja 1(1)
1/8
FLUJO DE CAJA - ECONOMICO - MAESTROPeriodo: 01 de Junio 2014 - 31 de M!o 201"En Nue#o$ So%e$
RU&ROS Jun-14 Ju%-14 Au'-14 Se(-14 O)*-14 No#-14 De)-14 Jn-1" Fe+-1" Mr-1" A(r-1" M!-1" ,rn To*%
IN,RESOSC Ini)i% 100.000 1.2"1./14 "4./" 1.04."4/ 2".4 4.00./4 4./".""0 4.330.2 "0.4"/./3 "0/.0".2 "0./"3.10 "0.2"/. 3."31.33.443 Ade%n*o$ ! #%ori)ione$ ".000.000 1."00.000 2.000.000 1.000.000 "00.000.000 1.000.000 00.000 12."00.000 3.03.2" 2.14.321 4./3./2/ ".31.10 "3.310.441O*ro$ in're$o$ 1"0.000 1"0.000To*% in're$o$ ".100.000 2./"1./14 2."4./" 2.04."4/ "00.41".4 4.00./4 4."".""0 "10.30.2 "12.44.0 "10.00.214 "11./2/.33/ "13."/4.04 4.0/1.03.4
E,RESOSCo5(r$ 0.000 0.000 /30.000 30.000 0.000 3".000 240.000 200.000 /20.000 30.000 1.10.000 1."30.000 ./".000 1,$*o$ de (er$on% 434.14 /4."4 434.14 434.14 "0.3/ 434.14 /4."4 434.14 434.14 434.14 434.14 "0.3/ .14/.442 1,$*o$ d5ini$*r*i#o$ 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 /2/.200 0
,$*o de #en*$ - - - - - - - - - - - - 0 0,$*o$ 8inn)iero$ 1/.303 1/.303 1/.303 1/.303 1/.303 1/.303 1/.303 "2.303 "2.303 "2.303 "2.303 "2.303 32.31 0To*% e're$o$ o(er*i#o$ 1.12.0/ 1."04.4/ 1.242.0/ 1.442.0/ 1.32.22 /.0/ 1.04.4/ /4/.0/ 1.2/.0/ 1.3//.0/ 1./2/.0/ 2.233.22 1.022.2/3 2
FLUJO DE CAJA OPERATI9O 3.0/.03 1.24/.24/ 1.322." 0.4"0 4.0/./ 4.003.// 4."31.04 "10.03." "11.22./1 "0./13.11/ "10.000.240 "11.340.12 4.0"".0/1.11
Ser#i)io de % deud 1"0.000 200.000 100.000 100.000 100.000 0.000 "0.000 "00.000 1.000.000 1."00.000 1."00.000 1.000.000 .20.000In#er$ione$ )orrien*e$ 2."00.000600 2."00.000I5(ue$*o$ .1 42.41 1/4.112 240."02 .3 12.32 1"0.401 12".03 2.321.0/ 4"."0/ 242.2"4 /32.0 ".1"0.12U*i%idd 0To*% e're$o$ no o(er*i#o$ 2.".164/ 2.41 2/4.112 340."02 1.3 20.32 200.401 2".03 3.321.0/ 1."."0/ 1./42.2"4 1./32.0 13.30.12
FLUJO DE CAJA ECONMICO NETO 1.2"1./14 "4./" 1.04."4/ 2".4 4.00./4 4./".""0 4.330.2 "0.4"/./3 "0/.0".2 "0./"3.10 "0.2"/. "0.0.00 4.041.141.44
ACUMULADO ;LI 1.2"1./14 1.1.4/0 2.".01/ 3.130." "02.031.3 1.000.2/.40 1.4.1".1/2 2.00.1"."" 2."1."21.4/ 3.023.2/".4"/ 3."31."33.443 4.041.141.44 -"00.000
IRO /61 361" 613 06" 62 4.0063 2.3163 4.006/ 1.3/62" 23.2630 10.2"36 .16/1 14./236
PUNTO DE E
-
7/24/2019 Simulacion Flujo de Caja 1(1)
2/8
PROECCIN DE IN,RESOSPeriodo: 01 de Junio 2014 - 31 de M!o 201"En Nue#o$ So%e$ 1 2 3 4 " / 10 11 12
Jun-14 Ju%-14 Au'-14 Se(-14 O)*-14 No#-14 De)-14 Jn-1" Fe+-1" Mr-1" A(r-1" M!-1"9%ori)ione$ 1."00.000 2.000.000 1.000.000 1.000.000 1.000.000 00.000 "00.000 3.03.2" 2.14.321 4./3./2/ ".31.10Ade%n*o$ ".000.000 12.000.000Pre)io de #en* 1"0600 - - - - - - - - - - - -In8%)in 0627To*% ".000.000 1."00.000 2.000.000 1.000.000 1.000.000 1.000.000 00.000 12."00.000 3.03.2" 2.14.321 4./3./2/ ".31.10
Co+rn$ Ne*$ 5,000,000 1,500,000 2,000,000 1,000,000 1,000,000 1,000,000 800,000 12,500,000 3,036,285 2,184,321 4,973,727 5,316,108
-
7/24/2019 Simulacion Flujo de Caja 1(1)
3/8
PROECCIN DE COMPRASPeriodo: 01 de Junio 2014 - 31 de M!o 201"En Nue#o$ So%e$ 1 2 3 4 " / 10 11 12
Jun-14 Ju%-14 Au'-14 Se(-14 O)*-14 No#-14 De)-14 Jn-1" Fe+-1" Mr-1" A(r-1" M!-1"Unid6 A 9ender - - - - - - - - - - - ###M$ In#6 Fin% 07 - - - - - - - - - - - ###
Agregados 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 ###
Acero Corrugado 500,000 500,000 500,000 100,000 80,000 40,000 20,000 500,000 500,000 500,000 500,000 ###
Cemento 100,000 100,000 100,000 100,000 40,000 40,000 40,000 100,000 100,000 100,000 100,000 ###
Concreto 30,000 30,000 30,000 30,000 15,000 10,000 10,000 50,000 100,000 200,000 200,000 ###
Acabados - 50,000 200,000 300,000 150,000 100,000 80,000 - - 250,000 500,000 1,000,000
Inst. Electricas 10,000 10,000 35,000 50,000 35,000 10,000 10,000 20,000 50,000 50,000 100,000 ###
Inst. anitarias 10,000 10,000 35,000 50,000 35,000 10,000 10,000 20,000 50,000 50,000 100,000 ###
Ne)e$idde$ de )o5(r - - - - - - - - - - - @@@
Meno$ In#6 Ini)i% - - - - - - - - - - - -Unid6 A Co5(rr - - - - - - - - - - - -
Pre)io de Co5(r /" !5.1" !5.3" !5.58 !5.!8 !5."! !.1! !.3! !.5 !.! !." !!.1 !!.3In8%)in 0.2$Co5(r$ F)*urd$ 0.000 /30.000 30.000 0.000 3".000 240.000 200.000 /20.000 30.000 1.10.000 1."30.000 2.030.000
P'o Pro#eedore$ 30 d$ 680,000 680,000 730,000 930,000 660,000 385,000 240,000 200,000 720,000 830,000 1,180,000 1,530,000
-
7/24/2019 Simulacion Flujo de Caja 1(1)
4/8
PROECCIN DE ,ASTOS DE PERSONAL
Periodo: 01 de Junio 2014 - 31 de M!o 201"En Nue#o$ So%e$ 1 2 3 4 " / 10 11 12Jun-14 Ju%-14 Au'-14 Se(-14 O)*-14 No#-14 De)-14 Jn-1" Fe+-1" Mr-1" A(r-1" M!-1"
Sue%do$ 312,3!0 312,3!0 312,3!0 312,3!0 312,3!0 312,3!0 312,3!0 312,3!0 312,3!0 312,3!0 312,3!0 312,3!0,r*i8i))ione$ 312,3!0 312,3!0CTS 15,185 15,185ESSALUD "$ 28,113 28,113 28,113 28,113 28,113 28,113 28,113 28,113 28,113 28,113 28,113 28,113or$ EG*r$ 307 "3,!11 "3,!11 "3,!11 "3,!11 "3,!11 "3,!11 "3,!11 "3,!11 "3,!11 "3,!11 "3,!11 "3,!11So+re*ie5(o9))ione$ - Ree5(%o$
To*% ,$*o$ de Per$on% 434,194 746,564 434,194 434,194 590,379 434,194 746,564 434,194 434,194 434,194 434,194 590,379
-
7/24/2019 Simulacion Flujo de Caja 1(1)
5/8
PROECCIN DE ,ASTOS ADMINISTRATI9OS
Periodo: 01 de Junio 2014 - 31 de M!o 201"En Nue#o$ So%e$ 1 2 3 4 " / 10 11 12
I*e5$ Mon*o$ Jun-14 Ju%-14 Au'-14 Se(-14 O)*-14 No#-14 De)-14 Jn-1" Fe+-1" Mr-1" A(r-1" M!-1"Lu 1.100 1,100 1,100 1,100 1,100 1,100 1,100 1,100 1,100 1,100 1,100 1,100 1,100A'u 1."00 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500Te%H8ono Fio .000 8,000 8,000 8,000 8,000 8,000 8,000 8,000 8,000 8,000 8,000 8,000 8,000Te%H8ono M#i% .200 ,200 ,200 ,200 ,200 ,200 ,200 ,200 ,200 ,200 ,200 ,200 ,200C Ci) 4.000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000Trn$(or*e ".000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000Reunione$ 3.300 3,300 3,300 3,300 3,300 3,300 3,300 3,300 3,300 3,300 3,300 3,300 3,300O*ro$ '$*o$ 1.000 18,000 18,000 18,000 18,000 18,000 18,000 18,000 18,000 18,000 18,000 18,000 18,000Pre5io$ .000 ,000 ,000 ,000 ,000 ,000 ,000 ,000 ,000 ,000 ,000 ,000 ,000Re8ri'erio$ /."00 !,500 !,500 !,500 !,500 !,500 !,500 !,500 !,500 !,500 !,500 !,500 !,500
To*% ,$*o$ Ad5ini$*r*i#o$ 60,600 60,600 60,600 60,600 60,600 60,600 60,600 60,600 60,600 60,600 60,600 60,600
-
7/24/2019 Simulacion Flujo de Caja 1(1)
6/8
PROECCIN DE ,ASTOS DE 9ENTASPeriodo: 01 de Junio 2014 - 31 de M!o 201"En Nue#o$ So%e$ 1 2 3 4 " / 10 11 12
Jun-14 Ju%-14 Au'-14 Se(-14 O)*-14 No#-14 De)-14 Jn-1" Fe+-1" Mr-1" A(r-1" M!-1"9en*$ F)*urd$ - - - - - - - - - - - -Co+rn$ Ne*$ - - - - - - - - - - - -
Co5i$ione$ de 9en*$ 107 - - - - - - - - - - - -Pu+%i)idd /7 - - - - - - - - - - - -Pro5o)in 7 - - - - - - - - - - - -F%e*e 7 - - - - - - - - - - - -
To*% ,$*o$ de 9en*$ - - - - - - - - - - - -
-
7/24/2019 Simulacion Flujo de Caja 1(1)
7/8
PROECCIN DE ,ASTOS FINANCIEROS SER9ICIO DE LA DEUDA
Periodo: 01 de Junio 2014 - 31 de M!o 201"En Nue#o$ So%e$ 1 2 3 4 " / 10 11 12
Jun-14 Ju%-14 Au'-14 Se(-14 O)*-14 No#-14 De)-14 Jn-1" Fe+-1" Mr-1" A(r-1" M!-1"In*ere$e$ ;'$*o$ 8inn)iero$>
Carta %ian&a Adelanto de 'ateriales 8,44 8,44 ### 8,44 ### 8,44 8,44 10,44 10,44 10,44 10,44 10,44
Carta %ian&a Adelanto (irecto 5,8"2 5,8"2 ### 5,8"2 ### 5,8"2 5,8"2 30,8"2 30,8"2 30,8"2 30,8"2 30,8"2
Carta %ian&a de %iel Cum)limiento 2,"4 2,"4 ### 2,"4 ### 2,"4 2,"4 10,"4 10,"4 10,"4 10,"4 10,"4
obregiro
Total Gastos Financieros 17,303 17,303 17,303 17,303 17,303 17,303 17,303 52,303 52,303 52,303 52,303 52,303
A5or*i)ione$ ;$er#i)io de % deud>Carta %ian&a 150,000 200,000 100,000 100,000 100,000 80,000 50,000 500,000 1,000,000 1,500,000 1,500,000 1,000,000
obregiro
Total Servicio de la Deuda 150,000 200,000 100,000 100,000 100,000 80,000 50,000 500,000 1,000,000 1,500,000 1,500,000 1,000,000
PrH$*5o /".000TNA 7 TEA $ *asa e+ectia mensual 0$P%o de P'o 5For5 de P'o mensualCon P%o de ,r)i 3 o se )aga inters, i amorti&a
225,!23
Periodo$ C(i*% A5or*i)in In*erH$ Cuo*
1 !5,000 ,0!"."8 0 8,"20.02 ,0!"."82 ",2"5 ,143.3 0 3,151.3" ,143.33 3,4"8 ,208.22 0 5!,28".4 ,208.224 5!,0! ,2!3.84 288.04 51,333.2" ,51.88
" 51,333 ,305.21 25.! 45,028.08 ,51.88 45,028 ,33.!4 225.14 38,"1.34 ,51.88/ 38,"1 ,38.42 1"3.4 32,322."2 ,51.88 32,323 ,400.2 11.1 25,"22. ,51.88 25,"23 ,432.2 12".1 1",4"0.40 ,51.88
10 1",4"0 ,44.42 "!.45 13,025."8 ,51.8811 13,02 ,4".!5 5.13 ,52".23 ,51.8812 ,52" ,52".23 32.5 /0.00 ,51.88
/.036 1.446/ //.46/2
S%do deDeud
-
7/24/2019 Simulacion Flujo de Caja 1(1)
8/8
PROECCIN DE IMPUESTOSPeriodo: 01 de Junio 2014 - 31 de M!o 201"En Nue#o$ So%e$ 1 2 3 4 " / 10 11 12
Jun-14 Ju%-14 Au'-14 Se(-14 O)*-14 No#-14 De)-14 Jn-1" Fe+-1" Mr-1" A(r-1" M!-1"9en*$ F)*urd$ 5,000,000 1,500,000 2,000,000 1,000,000 1,000,000 1,000,000 800,000 12,500,000 3,03,285 2,184,321 4,"!3,!2! 5,31,108
Co5(r$ F)*urd$ 3,240,00 !"0,00 ""0,00 !20,00 445,00 300,00 20,00 !80,00 8"0,00 1,240,00 1,5"0,00 2,0"0,00
P'o Pro#eedore$ 80,000 !30,000 "30,000 0,000 385,000 240,000 200,000 !20,000 830,000 1,180,000 1,530,000 2,030,000,$*o$ Ad5ini$*r*i#o$ 0,00 0,00 0,00 0,00 0,00 0,00 0,00 0,00 0,00 0,00 0,00 0,00,$*o$ de 9en*$ - - - - - - - - - - - -In#er$in Corrien*e 2,500,000.0 - - - - - - - - - - -
I
I - entas 18$ !2,!12 228,814 305,085 152,542 152,542 152,542 122,034 1,"0,!80 43,12 333,202 !58,!04 810,"32I - Com)ras 18$ 4"4,32" 120,00 151,108 10","22 !,"!3 45,854 3",!53 11",0!5 135,854 18",244 242,34 318,"05
*otal I 28,383 108,214 153,"! 42,20 84,5" 10,88 82,281 1,!8!,!05 32!,308 143,"5! 51,0!0 4"2,02!
A)licacin 0 28,383 108,214 153,"! 42,20 84,5" 10,88 82,281 1,!8!,!05 32!,308 143,"5! 51,0!0
I a )agar 0 28,383 108,214 153,"! 42,20 84,5" 10,88 82,281 1,!8!,!05 32!,308 143,"5! 51,0!0
enta 5$ 211,84 3,55" 84,!4 42,3!3 42,3!3 42,3!3 33,8"8 52",1 128,5 "2,55 210,!51 225,25"
A)licacin )ago 211,84 3,55" 84,!4 42,3!3 42,3!3 42,3!3 33,8"8 52",1 128,5 "2,55 210,!51
I*% 0.05$
Ingresos /Abonos 5,000,000 1,500,000 2,000,000 1,000,000 1,000,000 1,000,000 800,000 12,500,000 3,03,285 2,184,321 4,"!3,!2! 5,31,108
Egresos /Cargos
6ago a )roeedores 80,000 80,000 !30,000 "30,000 0,000 385,000 240,000 200,000 !20,000 830,000 1,180,000 1,530,000
astos )ersonal 434,1"4 !4,54 434,1"4 434,1"4 5"0,3!" 434,1"4 !4,54 434,1"4 434,1"4 434,1"4 434,1"4 5"0,3!"
astos administratios 0,00 0,00 0,00 0,00 0,00 0,00 0,00 0,00 0,00 0,00 0,00 0,00
astos entas - - - - - - - - - - - -
Inersiones corrientes 2,500,000 - - - - - - - - - - -
astos +inancieros 1!,303 21!,303 11!,303 11!,303 11!,303 "!,303 !,303 552,303 1,052,303 1,552,303 1,552,303 1,052,303
*otal egresos 3,842,0"! 1,!04,4! 1,342,0"! 1,542,0"! 1,428,282 "!!,0"! 1,114,4! 1,24!,0"! 2,2!,0"! 2,8!!,0"! 3,22!,0"! 3,233,282
Abonos 0.0!$ 3,500 1,050 1,400 !00 !00 !00 50 8,!50 2,125 1,52" 3,482 3,!21
Cargos 0.0!$ 2,8" 1,1"3 "3" 1,0!" 1,000 84 !80 8!3 1,58! 2,014 2,25" 2,23
*otal I*% ,18" 2,243 2,33" 1,!!" 1,!00 1,384 1,340 ",23 3,!12 3,543 5,!41 5,"85
*otal Im)uestos ,18" 482,4"1 1!4,112 240,502 8,"3 128,32 150,401 125,803 2,321,0!8 45",50! 242,254 !32,80