Download - Plan Financiero Purificadora de Agua 1
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 1/49
María del Carmen López Ortiz
Planeación Financiera
Cesar Gamiño
Plan fnanciero Purifcadora de
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 2/49
gua
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 3/49
COSTO MPGARRAFON 30.00
TAPA 0.25SELLO 0.09AGUA 8,000 lts 600.00 421.05 1.43CARBON
OZONO 0.80 POR GARRAFONARENA
cto unitario !!!"#$S%MOSLUZ 1,000.00AGUA 60.00
TELEFONO 500.00RENTA 3,000.00LIC. UNICIPAL 33.33TTO 800.00
GTOS FA&'#CAC#O$UNIFORE 4,000.00 SEESTRALCOFIA 100 PZAS 30.00 BICUBREBOCAS 100 PZAS 40.00 ENSUALESGEL ANTIBACTERIAL 60.00 ENSUALESGASOLINA 800.00A!!"#$%&'"#t( $" (t(s 2,400.00
Gtos de (enta'&)!. $" )l%#'ll%s 1,000 200.00
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 4/49
200250
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 5/49
) *iaG%!!%*(#"s 100+ 500.00G%!!%*(#"s 90.0+ 450.00G%!!%*(#"s 5.0+ 35.00G%!!%*(#"s 50.0+ 250.00
Año +Mes ,nero Fe-rero
Cantidad 6,000.00 6,000.00
Año !Mes ,nero Fe-rero
Cantidad 10,800.00 10,800.00
Año .Mes ,nero Fe-rero
Cantidad 12,000.00 12,000.00
Año /Mes ,nero Fe-rero
Cantidad 12,000.00 ---
Año "Mes ,nero Fe-rero
Cantidad 12,000.00 ---
Concepto Año +
Meses1 2
"#t%s 1,500.00 8,000.00P!($. N/ %!!%*(#"s 6,000.00 6,000.00G%!!%*(#"s )!(&('(# 500.00TOTAL 01233333 1/233333
Materia prima directa 13,380.00 13,380.00l(!(, %!"#%, %!(# %t, ((#( 0.80 0.80
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 6/49
%% 1.43 ---total !!. !!.
MP *irec 4 garra5ornt%)% 3,000.00 1,500.00s"ll( $" %!%#t'% 1,080.00 540.00
TOTAL /231333 !23/333
#nsumosA% 60.00 60.00L 1,000.00 1,000.00
T"l"*(#( 500.00 500.00%#tt( 800.00 800.00R"#t% 3,000.00 3,000.00
TOTAL "2.6333 "2.6333
Gastos de Fa-ricacion
U#'*(!&" 666.6 666.6C(% 100 )%s 15.00 15.00C!"(%s 100 )%s 40.00 40.00G"l A#t'%t"!'%l 60.00 60.00G%s(l'#% 800.00 800.00A!!"#$%&'"#t( $" (t(s 2,400.00 2,400.00
TOTAL .271+60 .271+60
C(st(s +02/6333 +"2/!333G%st(s 72./+60 72./+60Total de costos !6213+60 !/206+60
C(st( P!(&"$'( U#'t%!'( //0 /+.
#nsumos Promedio 317 317Gastos de Fa- Promedio 366 366
#n8ersion de pu-licidad .) !2+/"33 !2./333
Pro9ección anual !3+" !3+6(entas 1,163,500.00 1,684,800.00Produccion $o *e Garra5ones 90,000.00 129,600.00
Materias primas *irectas
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 7/49
Cloro2 Arena2 Car-on Act 9 Ozono 200,00.00 289,008.00
Materias Primas *irectas 4 Garra5onTapa en : 24,000.00 32,400.00Sello de Garantia : 8,640.00 11,664.00
#nsumos indirectos en : 64,320.00 66,892.80Costos de Fa-ricacion en : 4,80.00 49,691.20
TOTAL *, COSTOS mat prima !..2./333 ...230!33
Costo Promedio mensual Mat prima +72//"33 !020"633
TOTAL *, COSTO FA&'#CAC#O$ ++!2+3333 ++62"1/33
costo Fa-ricacion promedio mensual 72./+60 720+"..
SUA TOTAL E COSTOS P 7 FAB 345,440.00 449,656.00
Promedio mensual de (entas 7627"1.. +/32/3333
PO'C,$TA;, S<(,$TAS = A>O .) .)P'OMOC#O$ ? P%&L#C#*A* ./273"33 "32"//33
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 8/49
Semana Mes Año Precio de 8enta al3,000.00 12,000.00 144,000.002,00.00 10,800.00 129,600.00 : +.332,250.00 9,000.00 108,000.00 A( 2 13.5
1,500.00 6,000.00 2,000.00
Marzo A-ril Ma9o ;unio ;ulio
6,000.00 6,000.00 --- 6,000.00 9,000.00
Marzo A-ril Ma9o ;unio ;ulio 10,800.00 10,800.00 --- 10,800.00 ---
Marzo A-ril Ma9o ;unio ;ulio
12,000.00 12,000.00 --- 12,000.00 ---
Marzo A-ril Ma9o ;unio ;ulio
12,000.00 12,000.00 --- 12,000.00 ---
Marzo A-ril Ma9o ;unio ;ulio
12,000.00 12,000.00 --- 12,000.00 ---
3 4 5 6 8,000.00 8,000.00 8,000.00 8,000.00 11,000.00
6,000.00 6,000.00 6,000.00 6,000.00 9,000.00
1/233333 1/233333 1/233333 1/233333 @@@
13,380.00 13,380.00 13,380.00 13,380.00 20,00.000.80 0.80 0.80 0.80 0.80
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 9/49
1.43 1.43 --- 1.43 --- !!. !!. !!. !!. !!.
1,500.00 1,500.00 1,500.00 1,500.00 2,250.00540.00 540.00 540.00 540.00 810.00
!23/333 !23/333 !23/333 !23/333 .236333
60.00 60.00 60.00 60.00 60.001,000.00 1,000.00 1,000.00 1,000.00 1,000.00
500.00 500.00 500.00 500.00 500.00800.00 800.00 800.00 800.00 800.00
3,000.00 3,000.00 3,000.00 3,000.00 3,000.00"2.6333 "2.6333 "2.6333 "2.6333 "2.6333
666.6 666.6 666.6 666.6 666.615.00 15.00 15.00 15.00 15.0040.00 40.00 40.00 40.00 40.0060.00 60.00 60.00 60.00 60.00
800.00 800.00 800.00 800.00 800.002,400.00 2,400.00 2,400.00 2,400.00 2,400.00
.271+60 .271+60 .271+60 .271+60 .271+60
+"2/!333 +"2/!333 +"2/!333 +"2/!333 !.2+.33372./+60 72./+60 72./+60 72./+60 72./+60
!/206+60 !/206+60 !/206+60 !/206+60 .!2/0+60
/+. /+. /+. /+. .6+
317 317 317 317 363366 366 366 366 3//
!2./333 !2./333 !2./333 !2./333 .2"+333
!3+0 !3+1 !3+7 TOTAL 1,82,000.00 1,82,000.00 1,82,000.00 8,464,300.00
144,000.00 144,000.00 144,000.00 651,600.00
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 10/49
321,120.00 321,120.00 321,120.00 1,453,068.00
36,000.00 36,000.00 36,000.00 162,900.0012,960.00 12,960.00 12,960.00 58,644.00
69,568.51 2,351.25 5,245.30 8,255.1151,68.85 53,46.00 55,895.84 58,131.68
.03231333 .03231333 .03231333 +260626"!33
.321/333 .321/333 .321/333 +.720!+33
+!+2!/0.6 +!62370!" +.+2+/++/ 6302+6706
+32+3.7" +32"31+3 +327!1/. "32"70/1
491,32.36 496,1.25 501,221.14 2,283,821.6
+"6233333 +"6233333 +"6233333 03"2."1..
.) .) .) "62+6333 "62+6333 "62+6333 !".27!733
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 11/49
u-lico
%st" )(! '#:%'(#
(entas al añoAgosto Septiem-re Octu-re $o8iem-re *iciem-re
9,000.00 9,000.00 9,000.00 9,000.00 9,000.00 73233333
(entas al añoAgosto Septiem-re Octu-re $o8iem-re *iciem-re
10,800.00 --- 10,800.00 10,800.00 10,800.00 +!7263333
(entas al añoAgosto Septiem-re Octu-re $o8iem-re *iciem-re
12,000.00 --- 12,000.00 12,000.00 12,000.00 +//233333
(entas al añoAgosto Septiem-re Octu-re $o8iem-re *iciem-re
12,000.00 --- 12,000.00 12,000.00 12,000.00 +//233333
(entas al añoAgosto Septiem-re Octu-re $o8iem-re *iciem-re
12,000.00 --- 12,000.00 12,000.00 12,000.00 +//233333
Total Anual8 9 10 11 12
11,000.00 11,000.00 11,000.00 11,000.00 11,000.00 @@@ 9,000.00 9,000.00 9,000.00 9,000.00 9,000.00 73233333
"3333@@@ @@@ @@@ @@@ @@@ @@@
20,00.00 20,00.00 20,00.00 20,00.00 20,00.00 !332033330.80 0.80 0.80 0.80 0.80 763
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 12/49
1.43 --- 1.43 1.43 1.43 +0+6!!. !!. !!. !!. !!. !606
2,250.00 2,250.00 2,250.00 2,250.00 2,250.00 !/233333810.00 810.00 810.00 810.00 810.00 126/333
.236333 .236333 .236333 .236333 .236333 .!26/333
60.00 60.00 60.00 60.00 60.00 0!3331,000.00 1,000.00 1,000.00 1,000.00 1,000.00 +!233333
500.00 500.00 500.00 500.00 500.00 6233333800.00 800.00 800.00 800.00 800.00 7263333
3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 .6233333"2.6333 "2.6333 "2.6333 "2.6333 "2.6333 6/2.!333
666.6 666.6 666.6 666.6 666.6 123333315.00 15.00 15.00 15.00 15.00 +133340.00 40.00 40.00 40.00 40.00 /133360.00 60.00 60.00 60.00 60.00 0!333
800.00 800.00 800.00 800.00 800.00 72633332,400.00 2,400.00 2,400.00 2,400.00 2,400.00 !1213333
.271+60 .271+60 .271+60 .271+60 .271+60 /0201333
!.2+.333 !.2+.333 !.2+.333 !.2+.333 !.2+.333 !..2./33372./+60 72./+60 72./+60 72./+60 72./+60 ++!2+3333
.!2/0+60 .!2/0+60 .!2/0+60 .!2/0+60 .!2/0+60 ./"2//333
.6+ .6+ .6+ .6+ .6+ .1/
363 363 363 363 363 30/3// 3// 3// 3// 3// 3""
.2"+333 .2"+333 .2"+333 .2"+333 .2"+333 ./273"33
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 13/49
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 14/49
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 15/49
C(st( t(t%l A#%l
C(st( P!(&"$'( U#'t%!'( %#%l
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 16/49
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 17/49
Concepto CO&,'T%'A #$#C#ALActi8o Circulante1; "#t%s )(! (!%! 02; #(&'#% $" 2 s"&%#%s < %st(s 15 13,118.03; '#="#t%!'(s%t"!'% )!'&% 30 10620
P!($t( "# )!("s( 3 0P!($t( t"!&'#%$( 3 2304
TOTAL "+ !63/!0
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 18/49
S,MA$A PO' M,S /#$C',M,$TO *, S%,L*O A$%AL /)
CONCEPTOS A( 2015
P"st( S%l%!'( '%!'( N(. E&)l"%$(
"#t%s 6.29 41.03 2(st!%$(! 120 840 2C(&'s'(#"s 1400 1E#%!%$( 300 2100 1
TOTAL /10!7 /21++3. 633
GASTOS *, OP,'AC#$
CONCEPTOS BASES A>O 2015 A>O 2016SUELOS 7 SALARIOS 314,848.80 40,356.13CUOTA ISS 3+ 9,445.46 12,220.68
SAR E INFONAIT + 22,039.42 28,514.93 TOTAL ./62...61 //1237+0/
GASTOS A*#M#$#ST'AT#(OSCONCEPTOS BASES A>O 2015 A>O 2016SUELOS 7 SALARIOS 108,000.00 112,320.00CUOTA ISS 3+ 3,240.00 3,369.60
SAR E INFONAIT + ,560.00 ,862.40 TOTAL 118,800.00 123,552.00
GASTOS *, (,$TASCONCEPTOS BASES A>O 2015 A>O 2016SUELOS 7 SALARIOS 120,448.80 205,180.13CUOTA ISS 3+ 3,613.46 6,155.40SAR E INFONAIT + 8,431.42 14,362.61TOTAL +.!2/7.61 !!"2671+/
MA$O *, O&'A BP'O*%CC#O$CONCEPTOS BASES A>O 2015 A>O 2016SUELOS 7 SALARIOS 86,400.00 89,856.00CUOTA ISS 3+ 2,592.00 2,695.68SAR E INFONAIT + 6,048.00 6,289.92TOTAL 7"23/333 7121/+63
S"l$( P!(&"$'()(! s"&%#%
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 19/49
un peso por garra5on 8endido
A( 2016 A( 201 A(
"#s%l N(. E&)l"%$( "#s%l "#s%l
? 4,03.40 3 6,298.34 3 6,550.28 3 ? ,200.00 2 ,488.00 3 11,681.28 3 ? 6,000.00 1 10,800.00 1 12,000.00 1 ? 9,000.00 1 9,360.00 1 9,34.40 1
!62!.0/3 033 ..27/6./ 133 .7276"76 133
A>O 201 A>O 2018 A>O 2019 49,591.49 498,5.15 518,26.16
14,38.4 14,963.25 15,561.8
33,51.40 34,914.26 36,310.83@@@ @@@ @@@
A>O 201 A>O 2018 A>O 2019 116,812.80 121,485.31 126,344.2
3,504.38 3,644.56 3,90.34
8,16.90 8,503.9 8,844.13128,494.08 133,633.84 138,99.20
A>O 201 A>O 2018 A>O 2019 222,603.33 231,50.4 240,6.
6,68.10 6,945.22 ,223.0315,582.23 16,205.52 16,853.4
@@@ @@@ @@@
A>O 201 A>O 2018 A>O 2019 140,15.36 145,82.3 151,613.6
4,205.26 4,33.4 4,548.419,812.28 10,204. 10,612.96
@@@ @@@ @@@
N(.E&)l"%$(
N(.E&)l"%$(
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 20/49
018 A( 2019
"#s%l "#s%l
6,812.29 3 ,084.812,148.53 3 12,634.412,480.00 1 12,99.2010,123.8 1 10,528.3
/+2"6/63 133 /.2!!0+1
N(.E&)l"%$(
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 21/49
CO$C,PTO MO$TOINERSION E CAPITAL E TRABA@OCAPITAL E TRABA@O 26,042.0INENTARIO E GARRAFON 2,000.00
INERSION E EUIPAIENTOAUINARIA 7 EUIPO E PLANTA 100,000.00INSTALACION 7 PUESTA EN ARCA EL EUIPO 10,000.00
INERSION E EUIPO E AIINISTRACIONEUIPO E OFICINA 3,300.00SILLAESCRITORIOARCIERO
COPUTAORA ,000.00
OTRAS INERSIONESLICENCIA UNICIPAL 400
TAR@ETAS 200
TOTAL *, #$(,'S#O$ @@@
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 22/49
400.001,00.001,200.00
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 23/49
TABLA E EPRECIACION8+ PROUCCION
25+ EICULOS 730+ EUIPO E C
10+ OILIARIO 720+ EN GASTOS 30+ INENTARIO
5+ CONSTRUCCI30+ OTROS ACTI
CO$C,PTO MO$TO :EIFICIO O CONSTRUCCION
EPRECIACION ACUULAA
AUINARIA 7 EUIPO 100,000.00EPRECIACION ACUULAA
TRANSPORTEEPRECIACION ACUULAA
OBILIARIO E OFICINA 3,300.00EPRECIACION ACUULAA
EUIPO E COPUTO ,000.00EPRECIACION ACUULAA
OTROS ACTIOS FI@OS 2,000.00EPRECIACION ACUULAA
GASTOS E INSTALACION 10,000.00EPRECIACION ACUULAA
TOTAL E EPRECIACIONES @@@ TOTAL E CAPITAL E TRABA@O !623/!03 TERRENO D
TOTAL E INERCION @@@
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 24/49
EUIPAIENTO RANSPORTE
PUTO
EUIPO E OFICINA INSTALACION 7 E ORGANIZACIN E GARRAFONES
NS
A>O + A>O ! A>O . A>O / A>O "
10,000.00 10,000.00 10,000.00 10,000.00 10,000.0010,000.00 20,000.00 30,000.00 40,000.00 50,000.00
330.00 330.00 330.00 330.00 330.00330.00 660.00 990.00 1,320.00 1,650.00
2,100.00 2,100.00 2,100.00 00.00 0 2,100.00 4,200.00 6,300.00 ,000.00 ,000.00
8,100.00 8,100.00 8,100.00 2,00.008,100.00 16,200.00 24,300.00 2,000.00 2,000.00
2,000.00 2,000.00 2,000.00 2,000.00 2,000.002,000.00 4,000.00 6,000.00 8,000.00 10,000.00
!!2".333 !!2".333 !!2".333 +"20.333 +!2..333
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 25/49
,ST'%CT%'A *, CAP#TALEst!t!% $" l% '#="!s'(#
SOCIOS 30+
0+
TOTAL
+ E LAINERSION
PROGRAAS E APO7OSNECONOICOS 7FINANCIEROS
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 26/49
52,182.81
121,59.89
+0.27/!03
ONTO E LAINERSION
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 27/49
FL%;O *, ,F,CT#(O
CONCEPTO Et%)% )!" ()"!%t'=% Año !3+" MeE#"!(
INGRESOS 1,500.00
ENTAS CONTAO
52,182.81
APO7O FINANCIERO 121,59.89
RECUERCION E ACTIO FI@OTOTAL *, #$G',SOS +0.27/!03 0+2"3333
,G',SOSINERSION E ACTIOS TOTALES 14,900.00COSTOS *, (,$TAS
ANO E OBRA ? ,920.00ATERIA PRIA IRECTA 1,460.00
COSTO E FABRICACION 3,981.6GASTOS *, (,$TASUELOS 11,041.14
PROOSION 7 PUBLICIA 2,908.5GASTOS *, A*M#$#ST'AC#O$SUELOS 9,900.00
5,360.00
#MP%,STOSISRPTUIP N(& 524.5
TOTAL *, ,G',SOS +/0273333 "72376.3
SAL*O $,TO ,F,CT#(O !623/!03 +!2/3.03
SAL*O AC%M%LA*O !623/!03 .12//6/3
APORTACION E LOS INERSIONISTAS D7AEFECTUAAS;
INERSION POR REALIZAR E LOSSOCIOS
GASTOS OPERATIOS EAINISTRACION
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 28/49
sesF"!"!( %!( A!'l %<( @#'( @l'( 8,000.00 8,000.00 8,000.00 8,000.00 8,000.00 11,000.00
01233333 01233333 01233333 01233333 01233333 @@@
? ,920.00 ? ,920.00 ? ,920.00 ? ,920.00 ? ,920.00 ? ,920.0015,420.00 15,420.00 15,420.00 15,420.00 15,420.00 23,130.003,981.6 3,981.6 3,981.6 3,981.6 3,981.6 3,981.6
11,041.14 11,041.14 11,041.14 11,041.14 11,041.14 11,041.142,908.5 2,908.5 2,908.5 2,908.5 2,908.5 2,908.5
9,900.00 9,900.00 9,900.00 9,900.00 9,900.00 9,900.00
5,360.00 5,360.00 5,360.00 5,360.00 5,360.00 5,360.00
524.5 524.5 524.5 524.5 524.5 524.5"023"6.3 "023"6.3 "023"6.3 "023"6.3 "023"6.3 6/2066.3
!327/.03 !327/.03 !327/.03 !327/.03 !327/.03 "!2!..03
"72.7337 132...07 @@@ @@@ @@@ @@@
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 29/49
A(st( S")t'"&!" Ot!" N(='"&!" ''"&!" 11,000.00 11,000.00 11,000.00 11,000.00 11,000.00
@@@ @@@ @@@ @@@ @@@
? ,920.00 ? ,920.00 ? ,920.00 ? ,920.00 ? ,920.0023,130.00 23,130.00 23,130.00 23,130.00 23,130.003,981.6 3,981.6 3,981.6 3,981.6 3,981.6
11,041.14 11,041.14 11,041.14 11,041.14 11,041.142,908.5 2,908.5 2,908.5 2,908.5 2,908.5
9,900.00 9,900.00 9,900.00 9,900.00 9,900.00
5,360.00 5,360.00 5,360.00 5,360.00 5,360.00
524.5 524.5 524.5 524.5 524.56/2066.3 6/2066.3 6/2066.3 6/2066.3 6/2066.3
"!2!..03 "!2!..03 "!2!..03 "!2!..03 "!2!..03
@@@ @@@ @@@ @@@ @@@
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 30/49
A( 2015 1,163,500.00
52,182.81
121,59.89
+2..02//!03
95,040.00233,340.004,80.00
132,493.6834,905.00
118,800.00
64,320.00
6,296.98113210"66
/"62"603/
!2"!6200../
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 31/49
P'O?,CTA*OS
CO$C,PTO A>O 2015 A>O 2016
INGRESOS 1,163,500.00 1,684,800.00
ENTAS NETASAPORTACION E LOS SOCIOS 52,182.81
APO7O FINANCIERO 121,59.89
OTROS INGRESOSTOTAL #$G',SO @@@ @@@ @@@
,G',SOSA>O 2015 A>O 2016
14,900.00COSTO *, (,$TASANO E OBRA 95,040.00 98,841.60
ATERIA PRIA IRECTA 233,340.00 333,02.00
GASTOS E FABRICACION 4,80.00 49,691.20GASTOS *, (,$TASUELOS 132,493.68 225,698.14
PROOSION 7 PUBLICIA 34,905.00 50,544.00
GASTOS *, A*MO$SUELOS 118,800.00 123,552.00
GASTOS E OPERACIN E AON 64,320.00 66,892.80
GASTOS FINANCIEROS#MP%,STOSISR 242,52.61
PTUIP NO 6,296.98 8,14.12
TOTAL,S ,G',SO @@@ 0.!270"66 @@@
SAL*O $,TO ,F,CT#(O !623/!03 /.32"!/./ /1"2631".
SAL*O AC%M%LA*O !623/!03 /"62"603/ 7/!2+0""0
13,942.0 430,524.34 485,608.53
ETAPA PREOPERATIA
INERSIONES POR REALIZAR E LOSSOCIOS
CONTRUCCION INTALACION 7EUIPAIENTO E PLANTAINUSTRIAL
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 32/49
20+
INERSION INICIAL D +0.27/!03
ALOR ACTUAL NETO AN @@@ TASA INTERNA E RETORN0 TIR !"6/.)
INICE E RENTABILIA IR 010
At!%t'=% )%! l%s '#="!s'(#'st%sDTREA;
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 33/49
A>O 201 A>O 2018 A>O 2019 1,82,000.00 1,82,000.00 1,82,000.00 8,464,300.00
52,182.81
121,59.89
@@@ @@@ @@@ 126.12!/!03
A>O 201 A>O 2018 A>O 2019
14,900.00
154,192.90 160,360.61 166,5.04 65,210.1430,080.00 30,080.00 30,080.00 1,66,652.0051,68.85 53,46.00 55,895.84 258,91.89
244,863.6 254,658.21 264,844.54 1,122,558.2456,160.00 56,160.00 56,160.00 253,929.00
128,494.08 133,633.84 138,99.20 643,459.12
69,568.51 2,351.25 5,245.30 348,3.8
263,306.88 256,95.23 248,4.63 1,011,629.34,443.20 5,528.01 152,91.21
9,591.83 9,95.50 10,34.52 44,385.95@@@ @@@ @@@ 62.."216/00
"!/236.!7 /!62076+" /372./!7! !2.3!2.007.
@@@ @@@ @@@ 023162/.0+!
524,063.29 426,96.15 409,342.92 2,302,3.93
TOTALESACUULAOS
TOTALESACUULAOS
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 34/49
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 35/49
,STA*O *, ',S%LTA*OS +er año
#ngresos A>O !3+"E#"!( F"!"!(
"#t%s 1,500.00 8,000.00"s"#t(s s(!" "#t%s
"=(l'(#"s s(!" "#t%s "#t%s N"t%s 1,500.00 8,000.00
Costo de 8entas%#( $" (!% ? ,920.00 ? ,920.00C(st( $" )!($'(# 1,460.00 15,420.00G%st(s $" *%!'%'# 3,981.6 3,981.6
T(t%l C(st( $" "#t%s ? 29,361.6 ? 2,321.6
%tilid o perdida -ruta /!2+.1.. "32601..
Gastos de operaciónG%st(s $" "#t% 13,949.89 13,949.89G%st(s $" A$&'#'st!%'(# 15,860.00 15,260.00
G%st(s $" ()"!%'# 29,809.89 29,209.89
%tilida o perdida de operación +!2.!1// !+2/61//
Gastos 9 prod fnancierosG%st(s #%#'"!(s
")!"'%'(#"s 1,8.50 1,8.50P!($t(s #%#'"!(sOt!(s '#!"s(s G%st(s < )!($ # D1,8.50; D1,8.50;
%tilidad o perdida antes de impuestos +32/"37/ +72"737/
#MP%,STOSISR 34+IP #(& 2+ 524.5 524.5
PTU 10+I&)t(s. P%%$(s 524.48 524.48
%tilidad o perdida neta 727!6!3 +72366!3
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 36/49
%!( A!'l %<( @#'( @l'( A(st( 8,000.00 8,000.00 8,000.00 8,000.00 11,000.00 11,000.00
8,000.00 8,000.00 8,000.00 8,000.00 11,000.00 11,000.00
? ,920.00 ? ,920.00 ? ,920.00 ? ,920.00 ? ,920.00 ? ,920.0015,420.00 15,420.00 15,420.00 15,420.00 23,130.00 23,130.003,981.6 3,981.6 3,981.6 3,981.6 3,981.6 3,981.6
? 2,321.6 ? 2,321.6 ? 2,321.6 ? 2,321.6 ? 35,031.6 ? 35,031.6
"32601.. "32601.. "32601.. "32601.. 1+2761.. 1+2761..
13,949.89 13,949.89 13,949.89 13,949.89 13,949.89 13,949.8915,260.00 15,260.00 15,260.00 15,260.00 15,260.00 15,260.0029,209.89 29,209.89 29,209.89 29,209.89 29,209.89 29,209.89
!+2/61// !+2/61// !+2/61// !+2/61// "!20"1// "!20"1//
1,8.50 1,8.50 1,8.50 1,8.50 1,8.50 1,8.50
D1,8.50; D1,8.50; D1,8.50; D1,8.50; D1,8.50; D1,8.50;
+72"737/ +72"737/ +72"737/ +72"737/ "321137/ "321137/
524.5 524.5 524.5 524.5 524.5 524.5
524.48 524.48 524.48 524.48 524.48 524.48
+72366!3 +72366!3 +72366!3 +72366!3 "32."6!3 "32."6!3
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 37/49
TOTALS")t'"&!" Ot!" N(='"&!" ''"&!" 11,000.00 11,000.00 11,000.00 11,000.00 1,163,500.00
11,000.00 11,000.00 11,000.00 11,000.00 1,163,500.00
? ,920.00 ? ,920.00 ? ,920.00 ? ,920.00 95,040.0023,130.00 23,130.00 23,130.00 23,130.00 233,340.003,981.6 3,981.6 3,981.6 3,981.6 4,80.00
? 35,031.6 ? 35,031.6 ? 35,031.6 ? 35,031.6 36,160.00
1+2761.. 1+2761.. 1+2761.. 1+2761.. 0102./333
13,949.89 13,949.89 13,949.89 13,949.89 16,398.6815,260.00 15,260.00 15,260.00 15,260.00 183,20.0029,209.89 29,209.89 29,209.89 29,209.89 351,118.68
"!20"1// "!20"1// "!20"1// "!20"1// /.62!!+.!
1,8.50 1,8.50 1,8.50 1,8.50 22,530.00
D1,8.50; D1,8.50; D1,8.50; D1,8.50; D22,530.00;
"321137/ "321137/ "321137/ "321137/ /+.267+.!
0.00524.5 524.5 524.5 524.5 6,296.98
0.00524.48 524.48 524.48 524.48 6,296.98
"32."6!3 "32."6!3 "32."6!3 "32."6!3 /302.7/./
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 38/49
#ngresos A( 2015 A( 2016- "s"s 12 12
I#!"s(s 1,163,500.00 1,684,800.00
"#t%s"s"#t(s s(!" "#t%s
"=(l'(#"s s(!" "#t%s E (entas $etas 1,163,500.00 1,684,800.00
C(st( $" ="#t%s%#( $" (!% 95,040.00 98,841.60C(st( $" )!($'(# 233,340.00 333,02.00G%st(s $" *%!'%'# 4,80.00 49,691.20
Total Costo de (entas 36,160.00 481,604.80
%tilid o perdida -ruta 0102./333 @@@
Gastos de operaciónG%st(s $" "#t% 16,398.68 26,242.14G%st(s $" A$&'#'st!%'(# 183,20.00 190,444.80
D Gastos de operación ."+2++161 /6626167/
%tilida o perdida de operación /.62!!+.! 0.62"31!6
Gastos 9 prod fnancierosGastos fnancieros
")!"'%'(#"s 22,530.00 22,530.00P!($t(s #%#'"!(sOt!(s '#!"s(s E D Gastos 9 prod fn D !!2".333 D !!2".333
%tilidad o perdida antes de impuestos /+.267+.! 0+.2701!6
#MP%,STOSISR 34+ 0 242,52.61IP #(& 2+ 6,296.98 8,14.12
PTU 10+#mptos Pagados 62!7671 !"321770.
%tilidad o perdida neta /302.7/./ /6.2301".
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 39/49
A( 201 A( 2018 A( 2019 TOTAL12 12 12
1,82,000.00 1,82,000.00 1,82,000.00 8,464,300.00
1,82,000.00 1,82,000.00 1,82,000.00 8,464,300.00
154,192.90 160,360.61 166,5.04 65,210.1430,080.00 30,080.00 30,080.00 1,66,652.0051,68.85 53,46.00 55,895.84 258,91.89
55,951.4 584,186.61 592,50.88 2,610,654.04
@@@ @@@ @@@ @@@
301,023.6 310,818.21 321,004.54 1,36,48.24198,062.59 205,985.10 214,224.50 992,436.99
/772316!6 "+6213..+ "."2!!73/ @@@
076276!33 00+23+331 0//23!331 @@@
22,530.00 15,30.00 12,330.00 95,650.00
D !!2".333 D +"20.333 D +!2..333 D 7"26"333
00/2/.!33 0""2!1331 0.+267331 @@@
263,306.88 256,95.23 248,4.63 1011629.34103 9,591.83 9,95.50 10,34.52 44,385.95
,443.20 5,528.01 3,169.01 226140.215561 ."32./+7+ ./!2!710/ ..!2.+1+6 @@@
/!/237337 /+!271+./ .772.0+7! @@@
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 40/49
Aci8o Circulante ES ES ES1 2 3
C%% 11,533.92 1,81.03 24,100.14B%#(s 26,912.48 41,53.06 56,233.65
Cl'"#t"s(&"#t(s )(! (!%!P%(s %#t'')%$(sI#="!s'(#"s "# =%l(!"sI=% A!"$'t%l"I&)t(s. P% H A#tI#="#t%!'(s"$(!"s $'="!s(sOt!(s %t'=(s C'!l%#t"sOt!(s At'=(s #( C'!l%#t"s
Total de Acti8o Circulante .12//6/3 "72.7337 132...07Acti8os Fios T"!!"#(sE$''(s
")!"'%'(# %&l%$%%' < "')( 100,000.00 100,000.00 100,000.00
")!"'%'(# %&l%$% 833.33 1,666.6 2,500.00E')( $" T!%#s)(!t"
")!"'%'(# %&l%$%('l'%!'(s $" ('#% 3,300.00 3,300.00 3,300.00
")!"'%'(# %&l%$% 2.50 55.00 82.50E')( $" C(&)t( ,000.00 ,000.00 ,000.00
")!"'%'(# %&l%$% 15.00 350.00 525.00Ot!(s 2,000.00 2,000.00 2,000.00
")!"'%'(# Ot!(s 65.00 1,350.00 2,025.00Total de Acti8o Fio @@@ @@@ @@@
Acti8o *i5eridoG%st(s $" I#st%l%'# 10,000.00 10,000.00 10,000.00A&(!t'%'# 166.6 333.33 500.00G%st(s $" O!%#'%'#
A&(!t'%'#Ot!(s At'=(s '*"!'$(sA&(!t'%'#
Total acti8o di5erido 721.... 7266660 72"3333
TOTAL ACT#(OS @@@ @@@ @@@
194189 213555 232621
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 41/49
PAS#(OS ES ES ES1 2 3
Pasi8os corto plazoP!(=""$(!"sB%#(s (!t( )l%(
A!""$(!"s $'="!s(sPTU )(! )%%!I#t.)(! )%%!IA %s%$(I&)"st(s )(! )%%!A#t. " l'"#t"s
Total pasi8o a corto plazo
Pasi8o a Largo plazo(&"#t(s )(! )%%!
B%#(s')(t"%Ot!(s )%s'=( % l%!( )l%(
Total pasi8os a largo plazo
TOTAL *, PAS#(OS
CAP#TALC%)'t%l S('%l A'(#'st%s 52,182.81 52,182.81 52,182.81A)(!t. P"#$. J C%)'t%l'%!
Ut'l'$%$ E"!. A#t. 9,926.20 28,992.39A)(<( F'#%#'"!( 121,59.89 121,59.89 121,59.89Est%$( $" E"!''( 9,926.20 19,066.20 19,066.20
Total capital @@@ @@@ @@@
TOTAL PAS#(O E CAP#TAL @@@ @@@ @@@
D D D
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 42/49
ES ES ES ES ES ES4 5 6 8 9
30,383.24 36,666.35 42,949.46 58,619.5 4,289.68 89,959.90,894.24 85,554.82 100,215.41 136,9.00 13,342.58 209,906.1
@@@ @@@ @@@ @@@ @@@ @@@
100,000.00 100,000.00 100,000.00 100,000.00 100,000.00 100,000.003,333.33 4,166.6 5,000.00 5,833.33 6,666.6 ,500.00
3,300.00 3,300.00 3,300.00 3,300.00 3,300.00 3,300.00110.00 13.50 165.00 192.50 220.00 24.50
,000.00 ,000.00 ,000.00 ,000.00 ,000.00 ,000.0000.00 85.00 1,050.00 1,225.00 1,400.00 1,55.00
2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.002,00.00 3,35.00 4,050.00 4,25.00 5,400.00 6,05.00
@@@ @@@ @@@ @@@ @@@ @@@
10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00666.6 833.33 1,000.00 1,166.6 1,333.33 1,500.00
72..... 72+6660 7233333 121.... 1266660 12"3333
@@@ @@@ @@@ @@@ @@@ @@@
25168 2054 289820 34016 390532 440888
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 43/49
ES ES ES ES ES ES4 5 6 8 9
52,182.81 52,182.81 52,182.81 52,182.81 52,182.81 52,182.81
48,058.59 6,124.8 86,190.98 105,25.1 155,613.3 205,969.56121,59.89 121,59.89 121,59.89 121,59.89 121,59.89 121,59.8919,066.20 19,066.20 19,066.20 50,356.20 50,356.20 50,356.20
@@@ @@@ @@@ @@@ @@@ @@@
@@@ @@@ @@@ @@@ @@@ @@@
D D D D D D
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 44/49
ES ES ES10 11 12
105,629.90 121,300.00 136,90.11246,469.6 283,033.34 319,596.93
@@@ @@@ @@@
100,000.00 100,000.00 100,000.008,333.33 9,166.6 10,000.00
3,300.00 3,300.00 3,300.0025.00 302.50 330.00
,000.00 ,000.00 ,000.001,50.00 1,925.00 2,100.00
2,000.00 2,000.00 2,000.006,50.00 ,425.00 8,100.00
@@@ @@@ @@@
10,000.00 10,000.00 10,000.001,666.6 1,833.33 2,000.00
12..... 12+6660 1233333
@@@ @@@ @@@
491245 541601 59195
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 45/49
ES ES ES10 11 12
52,182.81 52,182.81 52,182.81
256,325.6 306,681.95 35,038.15121,59.89 121,59.89 121,59.8950,356.20 50,356.20 50,356.20
@@@ @@@ @@@
@@@ @@@ @@@
D D D
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 46/49
A>O + !12 12
Aci8o Circulante
C%% 136,90.11 282,652.6B%#(s 319,596.93 659,522.90
Cl'"#t"s(&"#t(s )(! (!%!P%(s %#t'')%$(sI#="!s'(#"s "# =%l(!"sI=% A!"$'t%l"I&)t(s. P% H A#tI#="#t%!'(s"$(!"s $'="!s(sOt!(s %t'=(s C'!l%#t"sOt!(s At'=(s #( C'!l%#t"s
Total de Acti8o Circulante @@@ 7/!2+0""0Acti8os Fios T"!!"#(sE$''(s
")!"'%'(# %&l%$%%' < "')( 100,000.00 100,000.00
")!"'%'(# %&l%$% 10,000.00 20,000.00E')( $" T!%#s)(!t"
")!"'%'(# %&l%$%('l'%!'(s $" ('#% 3,300.00 3,300.00
")!"'%'(# %&l%$% 330.00 660.00E')( $" C(&)t( ,000.00 ,000.00
")!"'%'(# %&l%$% 2,100.00 4,200.00Ot!(s 2,000.00 2,000.00
")!"'%'(# Ot!(s 8,100.00 16,200.00Total de Acti8o Fio ++6200333 762!/333
Acti8o *i5eridoG%st(s $" I#st%l%'# 10,000.00 10,000.00A&(!t'%'# 2,000.00 4,000.00G%st(s $" O!%#'%'#
A&(!t'%'#Ot!(s At'=(s '*"!'$(sA&(!t'%'#
Total acti8o di5erido 1233333 6233333
TOTAL ACT#(OS @@@ @@@
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 47/49
PASIOS
Pasi8os corto plazoP!(=""$(!"sB%#(s (!t( )l%(
A!""$(!"s $'="!s(sPTU )(! )%%!I#t.)(! )%%!IA %s%$(I&)"st(s )(! )%%!A#t. " l'"#t"s
Total pasi8o a corto plazo D D
Pasi8o a Largo plazo(&"#t(s )(! )%%!
B%#(s')(t"%Ot!(s )%s'=( % l%!( )l%(
Total pasi8os a largo plazo
Total de Pasi8os D D
CAP#TALC%)'t%l S('%l A'(#'st%s 52,182.81 52,182.81A)(!t. P"#$. J C%)'t%l'%!Ut'l'$%$ E"!. A#t. 40,394.34A)(<( F'#%#'"!( 121,59.89 121,59.89Est%$( $" E"!''( 40,394.34 463,08.53
Total Capital @@@ @@@
TOTAL PAS#(O E CAP#TAL @@@ @@@
D D
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 48/49
. / "12 12 12
439,81.66 56,910.50 690,13.381,026,36.20 1,325,124.51 1,611,664.55
@@@ @@@ @@@
100,000.00 100,000.00 100,000.0030,000.00 40,000.00 50,000.00
3,300.00 3,300.00 3,300.00990.00 1,320.00 1,650.00
,000.00 ,000.00 ,000.006,300.00 ,000.00 ,000.00
2,000.00 2,000.00 2,000.0024,300.00 2,000.00 2,000.00
0"20+333 6+271333 "+26"333
10,000.00 10,000.00 10,000.006,000.00 8,000.00 10,000.00
/233333 !233333 333
@@@ @@@ @@@
7/18/2019 Plan Financiero Purificadora de Agua 1
http://slidepdf.com/reader/full/plan-financiero-purificadora-de-agua-1 49/49
,443.20 5,528.01 3,169.01
002//.!3 0"2"!13+ 0.2+673+
002//.!3 0"2"!13+ 0.2+673+
52,182.81 52,182.81 52,182.81
80,42.8 1,294,562.96 1,0,544.30121,59.89 121,59.89 121,59.89424,090.09 412,981.34 399,31.92
@@@ @@@ @@@
@@@ @@@ @@@
D D D