ࡱ> rq \pBernardo Ba==!x<8X@"1Arial1Arial1Arial1Arial1Arial1 Arial1Arial1Arial1Arial1 Arial1$Arial1Arial1Arial1 Arial1 Arial1 Arial3#,##0\ " ";\-#,##0\ " "=#,##0\ " ";[Red]\-#,##0\ " "?#,##0.00\ " ";\-#,##0.00\ " "I"#,##0.00\ " ";[Red]\-#,##0.00\ " "q*6_-* #,##0\ " "_-;\-* #,##0\ " "_-;_-* "-"\ " "_-;_-@_-k)3_-* #,##0\ _ _-;\-* #,##0\ _ _-;_-* "-"\ _ _-;_-@_-,>_-* #,##0.00\ " "_-;\-* #,##0.00\ " "_-;_-* "-"??\ " "_-;_-@_-{+;_-* #,##0.00\ _ _-;\-* #,##0.00\ _ _-;_-* "-"??\ _ _-;_-@_- #,##0\ "pta";\-#,##0\ "pta"% #,##0\ "pta";[Red]\-#,##0\ "pta"&!#,##0.00\ "pta";\-#,##0.00\ "pta"+&#,##0.00\ "pta";[Red]\-#,##0.00\ "pta"A<_-* #,##0\ "pta"_-;\-* #,##0\ "pta"_-;_-* "-"\ "pta"_-;_-@_-D?_-* #,##0\ _p_t_a_-;\-* #,##0\ _p_t_a_-;_-* "-"\ _p_t_a_-;_-@_-ID_-* #,##0.00\ "pta"_-;\-* #,##0.00\ "pta"_-;_-* "-"??\ "pta"_-;_-@_-LG_-* #,##0.00\ _p_t_a_-;\-* #,##0.00\ _p_t_a_-;_-* "-"??\ _p_t_a_-;_-@_- 0.0% #,##0.0 #,##0.000 #,##0.0000                  + ) , *      $  L  L       $  $  $ (                    l    ,  ,   , a     $  a    a #\ a L  D  ` Proyeccioneventasn Valoracin"""MCuenta de resultados Ventas netasCoste de las ventas Mano de obra Amortizacin Otros gastos Intereses ImpuestosBeneficio netoBalance Caja y BancosCuentas a cobrarStocksAmtz acumuladaActivo fijo neto Total ActivoImpuestos a pagar ProveedoresFondos propios Total PasivoNOF Activo brutoFlujos de Caja+ amortizacin- compra de activosFree Cash Flow - aumento NOF+ aumento deuda a corto- disminucin de deuda a largo Deuda a largoFCacEBITDAEBIT Dividendos A reservas Deuda a medio+ intereses (1- 35%)- intereses (1- 35%)Flujo de caja neto Margen BrutoRdo AI%VentasTamao del mercadoCuota de mercadoUnidades vendidas Precio mediogRatiosTipo medio pagado deuda Das de cobroDas inventario Das pagoImp a pag sobre ventas tipo imp realROE Margen netoRotacin activoApalancamientoROA Payout ratioFactor descuentoVPNValor terminalWACC+Valor del ahorro de impuestos por interesesValor Total ImpuestosValor Total FCFValor Total empresa+ intereses (1- t%)Hacienda pblica acreedora'Hacienda pblica acreedora sobre ventas- intereses (1- t%)KeValor Total DIVValor de la deudaTotalR8 3>&zcc  N~R:We  dMbP?_*+%MDetectando automticamente hp <4 X PDSDDMhp LaserJet 1015 -dd" dXU } I } m }  m} m N   Z@    %   %           $    x@        *@@D@H@L@P@-T@ X@ D  \@ D  `@ D   d@  D  @@AAxA  AZ PAZ  3A Z  HzA Z  jMZA Z  i@n@n@A" A DD"ffff6AA DD" QAA D D " X[tAA D D " |!sAA D D  '"`@ DD"R@ DD"R@ DD"@ DD"@ DD"33333@ DD" (\@ D D " qΈ^@ D D " Os7@ D D  %)"&AC;?' DD"&]~@? DD"&2@? DD"&h!? DD~ )@@){Gz?D ){Gz? D ){Gz? D  ){Gz? D  @c@c@@"@  DD"43333@  DD" (\@ D D " tΈ^@ D D " Os7@ D D  "@  DD"@  DD" @  DD"%@  DD"@  DD "L@  DD " p= ׃@ D D " Ԛ-@ D D " {5B@  D D  %)" &qU? DD" &u=p#?  DD" &`#?  DD" &D<3?  DD~ )8@ )Q? D  )Q? D  )Q? D  )Q? D   -@@@~@( +˲@D DD( +*Sg@D DD( .ќ:@ D DD( .ќ:@ D DD( K^c@ D DD  $ @غ@غ@@,@ ,@ D  ,@ D  ,@ D  ,@ D   ( i@DD D  @   LLL @  @2@  h.;@  \X@  <@   Ϛ:@   Iz@   %) &іB?   LL &5|?   &g?   &.C?   &B 7o?  &~s?   &+~?   &i7}?   &~#p?#  @h@h@h@.8@?%$%D?. @4%$%(D?. |@4 %$% (D? . @4 %$% (D? . @4 %$% (D?  ("@ D D@  LL@@@h.Gy@\X@ <)@  Ϛw@  IzL@ ! !!!T@!@!@!:@"2y,t0@ DD"'E@ DD" 0@ D D " E^=@ D D " i@ D D  06 ".KÜ{?  DD".? DD".t[﮾?&5L*Ѿ? &c? &tp?  &URL?  $!$$@$4@$8@"$4ܸ@9 DDD"$ϛՊo@9 DDD" $6fE@9 D DD " $[`@9 D DD " $m̒@9 D DD  "@& LL@&&X@&HwN+U@&n Ƨ@& ˘>!@&  m7|@&  {IZ@&  ""  *@@D@H@L@P@-T@ X@ D  \@ D  `@ D   d@ D   ~ @@@@ LL"@@ @ @Z @ p9:5@  N *8@(  s@(   $X@@@@@1bĈ?@ LL&m?~@ $[Q@  TX@  @   $@@@@@5iҤI[@" ߊe@B _aQ@B  }1@B  F%|}@B  $@@@`@@" @  DD."@ DD." @ DD. " 0@ D D. " @ D D.   $-@@3@@@"K..1@ DD "+@ DD " mŽVj@ DD " D(zQ@ D D " Ab@ D D  "@ DD"@ DD"@t@ DD@t@@"h.>@ DD"j@ DD" =qɅ@ D D " >u@ D D " Zui@ D D  @@" LLLLH@I {@I {@Ip@I~;~@I*%P@I ԣl5R@I  e;;@(I  7OUF@(I B|!Xd4d4 R?*FBF??M^" # $ % & ' * , - . / 0 1 2 4 5 6 7 9 ; > ? @  "$"@@@@&"5iҤI[@#DDBm&" ߊe@CDDBm&" _aQ@C D DB m&" }1@C D DB m&" F%|}@C D DB m #F$#p@:@:@@"#Ű@/ DDC"#GzƱ@/ DDC"# Cl@/ D DC "# 2 {;i@/ D DC "# -sO@/ D DC  $#*$i@i@i@,$,$ D$$ ,$ $ $% L$ ,$ $ $ ,% $ %<%@@@@@@@@@@,L@,R@,d@,p@ % ,p@ $ &&~ &@@& u@F&&& LL&@F&&@F&&*@F&&t2@F&&Uމu @F&& ke@F && Gz|F@(F && r!@(F & ''@@''' -'H@J'' {@J'' {@J''p@J''~;~@J''*%P@J'' ԣl5R@J '' f;;@(J '' 7OUF@(J ' ****@@D@H@L@P@-T@ *X@* D* * \@* D* * `@* D*  * d@, D*  ,,,,,, L,@,,,@4@,,,4@,,,@@,,,"v@,,, C@, ,, ~i@, ,, @, ,, um@-, ------ L--@---@---@---~@---+˲@---+*Sg@- -- .ќ:@- -- .ќ:@- -- K^c@.- .".@. DD".. DD".p@. DD".@. DD".@/ DD$.,@,X@,@,@,p@ / //@0/&// --/@0//@@0//@@0//J@0//1bH@0//͆_WB@0// TWuR@0 // 6>e 7@0 // S@0 / 00@/D/0@/000 LL0p/00/00Ƣ@00;w@00I@@@ 00  @@ 00 @@ 00 @PI@20 1E11 111 LL'1tSf@?DD1lI@111!@111ԥ@111|@111@111 @111 d@1 11 `@1 1 2222(22 LLLLL2^k222$h@222k"@2221H]k@222O@222oZ@2 22 @2 22 eJ@2 22 ~(C@52 4 H41444 LL4tSf@444lI@444!@444ԥ@444|@444@444 @44 d@ 44 `@ 4 5 55556 LL5i@555555555i5555556 LL55 55 5 55 5 55 65 666@@656656656656656@656@6 56 p6 56 @6 56 75 77F77"77 LLLL7Z@777@7774@777@777O!@777oZ @7 77 X@7 77 ʔ+ 0@7 77 ~(U@97 9!99999 L999999949998994ܸD99ϛՊoD 99 6fED 99 [`D 99 m̒;9 ;&;F;;;; LL;Z@;;;@;;;;;;`k@;;;@;;;@} ,; ;; v]R@; ;; P:@; ;; PL)@?; >0 ?1*?@D%$%a/?'Pϕ?$D%$%/?@ ??D%$%/?@ ??D%$%/?;)+??D%$%~ ?*@?*?? ??D L? *?? ?? *?? ?? *?1 ? @2@VefaO@@@@AmLL@`1G@@@@yXG@@@@?>F@A@~ @,C@@,C@?@ ,C@ ?@ ,C@ ?@ ,C@ ?2!mW_XXx_ypcxNjX^A B C D F H I J K M  A3AEl9Q@A@AbG@A@AbG@A@A١E@B@~ A,D@A,D@?A ,D@ ?A ,D@ ?A ,D@ ? B4&BB|3@F@BmDD"&Bq5u@@BmDD"&Bq5u@@BmDD"&B)k6@@CmDD"~ B,D@B,D@"?B ,D@" ?B ,D@" ?B ,D@" ? CG"C&a«o?C D#D"CAh?C D#D"CdSwh?C D#D"CsTb?D D#DC*;On?C*;On?#?C *;On?# ?C *;On?# ?C *;On?# ? D<"D1D DD"D1F >?D DD"D1?D DD"D1Cv&V? DD~ D*V@D*??D *? ?D *? ?D *? ? F7F1 KƠ?FFF LLF1}i?FF1c#a?FF1b}b?FF1Ox?FF1eiwc? FF 1& ? FF 1A h?( FF 1=o?(HF H8"H1p*?H DDH1~qկ?HHHH  LLH1Ε?HHH1t[﮾?HHH15L*Ѿ?H HH 1c?H HH 1tp?H HH 1URL?H I9I2D/=?III LLI2Bp9@WWW7   Ofm  dMbP?_*+%" IU }     '     *$@@D@H@L@P@~ T@  X@ D  \@ D   `@ D   d@$[ D  +X@ @@@'J@ DD' @@ DD ' 4333C@ D D '  +@ D D ' e#@ D D  '/(&#H$I$?DD&#;;?DD&#$I$I?DD$)@)@)@)@)@ ,"=V-*? DD"$y? DD"w ? DD";f? DD~ *? *? D *? D  *? D  *? D  -"ףp= ;@ D D "ى؉@ D D "! YB@ D D ".(@ D D "J@  DD" @@ D D " 4333C@ D D "  +@ D D " e#@ D D  . 9@:@7@6@$ +4@+4@+4@+4@+4@ * @@AAxA"   A D D" PA D D " 3A D D " HzA D D " jMZA D D  x4dXH +   +    +  T@0  p   >@  7  Yr]M  dMbP?_*+%Mhp LaserJet 1010 Series Driver<4 X@@rint_changeSDDMhp LaserJet 1015 -dd" dXU } I } m }  m} m Y  Z@    %   %          $    x@        *@@D@H@L@P@-T@ X@ D  \@ D  `@ D   d@ D  @@AAxA  AZ PAZ  3A Z  HzA Z  jMZA Z  i@n@n@A" A DD"ffff6A DD" QA D D " X[tA D D " |!sA D D  '"`@ DD"R@ DD"R@ DD"@ DD"@ DD"33333@ DD" (\@ D D " qΈ^@ D D " Os7@ D D  %)"&AC;? DD"&]~@? DD"&2@? DD"&h!? DD~ )@@){Gz? D ){Gz? D ){Gz? D  ){Gz?UD  @c@c@@"@ DD"43333@ DD" (\@ D D " tΈ^@ D D " Os7@ D D  "@ DD"@ DD" @ DD"%@  DD"@  DD "L@  DD " p= ׃@ D D " Ԛ-@ D D " {5B@ D D  %)" &qU?  DD" &u=p#?  DD" &`#?  DD" &D<3?  DD~ )8@ )Q? D  )Q? D  )Q? D  )Q? D   -@@@~@( +˲@D DD( +*Sg@-D DD( ՝@- D DD( ՝@+ D DD( * m@ D DD  $ @غ@غ@@,@ ,@ D  ,@ D  ,@ D  ,@D    i@    LLL @   @   @2@   h.;@  \X@  @   #2@   AU6@   %) &іB?    LL &5|?   &g?   &.C?   &B 7o?   &~s?   &FHm?   &Y?   &rn?  @h@h@h@.@%#$(DS.@9%#$(DS. @9 %#$ (DS . @9 %#$ (DS . @9 %#$ (DS  (@ LL@@@@h.'@\X" @ 2@  #rq@  AUv@  ! !!!T@!@!@!:@"2y,t9@ DD"M Hc@ DD" ;=@ D D " YKL6@ D D " {@ D D  06 ".KÜ{? DD".? DD".@ DD"js@ DD" P`@ D D " ]D@ D D " Mga@ D D  @@" LLLLH@ {@ {@p@~Ag@*%hq@  v{@  p H@  uvzsBA%@ Dd4d4 E?*?B??M^! " # $ % & ) + , - . / 01345679:;=@ !$!@@@@&!5iҤI[@"DDVm&! ߊe@"DDVm&! _aQ@" D DV m&! }1@" D DV m&! F%|}@" D DV m "$"p@:@:@@""Ű@. DDW""GzƱ@. DDW"" Cl@. D DW "" 2 {;i@. D DW "" -sO@. D DW  ##*#i@i@i@,@#,@# ##$ L# ,@# ## ,@# ## ,@$# $*$@@@@@@@@@@,@@$,@@$ #$ ,@@$ #$ ,@@$ #$ ,@@S# %%~ %@@% u@%%%% LL%@%%%@%%%*@%%%t>@%%%Uމu @% %% R&w@% %% r @% %% p]E@&% &&@@&&&& -&H@&&& {@&&& {@&&&p@&&&~Ag@&&&*%hq@& && u{@& && p H@& && tvzsBA)& ))*)D@H@L@P@T@-T@ )X@) D) ) \@) D) ) `@) D)  ) d@+ D)  ++,+++ L+@,++@4@,++4@,++@@,++"f#@,++ @,++ ҟ(@, ++ g@, ++ jN@ + ,,-,,, L,-@-,,@-,,@-,,~@-,,+˲@,,+*Sg@,, ՝@ ,, ՝@/ ,, * m@T, -"-@/ DD"-. DD"-p@. DD"-@. DD"-@/ DD~ -,@-,@D-- ,@ D-- ,@,p@ . ..@/.&.. --.@...@@/..@@/..J@/..1bH@...͆_WB@/.. TWuR@/ .. 6>e 7@/ .. S@ . //@0D./@0/// LL/p0//0//Ƣ@0//;w0//I@@0//  @0 // @0 // @PI@1 / 0$0+01D333333?0@1000 Lffffff?0@100@100@100/@100@100 @1 00 @1 00 @0 11@1(11 LLLLL1!@11 @@11Y@@11k@@11O@411oZ @411  U@4 11 ۨY@4 11 j%k2[@6 1 3@~ 37?$3?@@@@ 4=,46qq?5D3D3,46H?5D3D3,4 6y?5 D3D3 ,4 6yT9?5 D3D3 ,4 6g_?:D3D3 4 6 5>"5 xȩ@+ D1D4"5+y@+ D1D4"5 !=A2@ D1 D4 "5 X7p@5 D1 D4 "5 d:QC@7 D1 D4  5 8/~ 5 9@ 6?"63@A# D6 D4 46 _4<A6D1 D5 D3D5  7C*7iA=D6%55 a 9A'9Y@K Dffffff?'9:@ Dffffff?'9 :@ D ffffff?'9 :@;D ffffff?'9 :@9 D ffffff?49 @@4 D9 D5 D3D8  :?":=1՘@  D9 D4  ;B*; O@+D:%99 a =:D=:::::"=:ݒ`zxA D;D7 @ %@A@@@ Lffffff?@@A@@@A@@@A@@@A@@/@A@@@A@@ @A @@ @A @@ @A @4W_XX0x_pDl<4<HABCEGJKLMNOP R S T U V W X  A ABAAA LLAi@BAABAABAAiBAA@BAABAA B AA B AA B A BBB@@CBBB LLBCBBCBBCBBCBBCBBCBB C BB C BB C B CCFEC"CC LLLLCZ@ECC@ECC4@ECC@ECC(À @GCCoZ @GCC -U@G CC Q8@G CC j%kB[@G C E!EGEEE LEGEEGEE4GEE8GEE4ܸlEEЛՊw EE A$ EE A/6+ EE %NHZE G&GFSGGG LLGZ@GG@GGGG@`k@GG8WJ@GGH/GG g;p GG t@ GG x<@ G JI~ J1.@J1 K=,K6Moz?LDJD3,K6 C4T2?LDJD3,K 6N\{_ ?L DJD3 ,K 6fvK?L DJD3 ,K 6 ^?L DJD3 ~ K 9@ L>"L1G=@K DEDK"Li@K DEDK"L H/X@K DE DK "L fi0Y@N DE DK "L S0S/@M DE DK  L 8/ M?"Mnwg@K DM DK 4M .@MDL DK DJDK  NJ*NVP<ݠAPDM%LL  OKO@@ D$ PL"PVP<݈AO DNDO R0 S1*SSD%#$a/S?SD%#$@/S@ ?SD%#$@/S;)+?SD%#$@/S擐 M?TD%#$@~ S*@S*333333?S SSX LS *333333?S SS *333333?S SS *333333? S T2TVefaO@TTTUmLLT`1G@TTTyXG@TTT?>F@UT~ T,C@T,C@T ST ,C@T ST ,C@T ST ,C@S U3UEl9Q@UTUbG@UTUbG@UTU١E@VT~ U,D@U,D@U SU ,D@U SU ,D@U SU ,D@VS V4&VB|3@F@VmDD!&Vq5u@@VmDD!&Vq5u@@VmDD!&V)k6@@WmDD!~ V,D@V,D@V SV ,D@V SV ,D@V SV ,D@WS W5"W&a«o?W D"D"WAh?W D"D"WdSwh?W D"D"WsTb?X D"DW*;On?W*;On?W SW *;On?W SW *;On?W SW *;On?0 S X<"X5X DD"X5F >?X DD"X5?X DD"X5Cv&V?h DD~ X*V@X*?X SX *?X SX *?X SX *?S*h^hjX^& l<.42@4`5 5 $6 K9 : e; W X >@A (<<<7 Oh+'0@HXl bernie BernardoMicrosoft Excel@e <#@U6U՜.+,0 PXd lt|   Proyeccionventas Valoracin Hojas de clculo  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`bcdefghjklmnopRoot Entry FWorkbookSummaryInformation(aDocumentSummaryInformation8i