ࡱ> |{ \palo Ba=  =X/#8X@"1.Times New Roman1.Times New Roman1.Times New Roman1.Times New Roman1.Times New Roman1Arial1Arial1Arial1.Times New Roman1.Times New Roman1QTahoma1QTahoma1QTahoma1.Times New Roman1+Arial1.+Times New Roman1.Times New Roman1Calibri1 Calibri14Calibri14Calibri1 Calibri1>Calibri1<Calibri1?Calibri1 Calibri1Calibri1h8Cambria1,8Calibri18Calibri18Calibri1Calibri1Calibri1Calibri1. Times New Roman1. Times New Roman1. Times New Roman1.$Times New Roman"L."\ #,##0;\-"L."\ #,##0#"L."\ #,##0;[Red]\-"L."\ #,##0$"L."\ #,##0.00;\-"L."\ #,##0.00)$"L."\ #,##0.00;[Red]\-"L."\ #,##0.00>*9_-"L."\ * #,##0_-;\-"L."\ * #,##0_-;_-"L."\ * "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-F,A_-"L."\ * #,##0.00_-;\-"L."\ * #,##0.00_-;_-"L."\ * "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-3" "\ #,##0;\-" "\ #,##0=" "\ #,##0;[Red]\-" "\ #,##0?" "\ #,##0.00;\-" "\ #,##0.00I"" "\ #,##0.00;[Red]\-" "\ #,##0.00q6_-" "\ * #,##0_-;\-" "\ * #,##0_-;_-" "\ * "-"_-;_-@_->_-" "\ * #,##0.00_-;\-" "\ * #,##0.00_-;_-" "\ * "-"??_-;_-@_-"L. "#,##0;\-"L. "#,##0!"L. "#,##0;[Red]\-"L. "#,##0""L. "#,##0.00;\-"L. "#,##0.00'""L. "#,##0.00;[Red]\-"L. "#,##0.00;6_-"L. "* #,##0_-;\-"L. "* #,##0_-;_-"L. "* "-"_-;_-@_-C>_-"L. "* #,##0.00_-;\-"L. "* #,##0.00_-;_-"L. "* "-"??_-;_-@_- [$$-409]#,##00.0&![$$-409]#,##0_ ;\-[$$-409]#,##0\  0.0% 0.000 0.0000 0.000% 0.0000000 0.000000 0.00000 0.0000% 0.00000% " "\ #,##0                                                        `  ff % &                + )              P  P     a> !  "     $  t #t      &|@ &| "|@  |   |  |  |@  |@  |   |  |   |@   |        L  D  @  H   H    |    &| &4 *|   |  |  1 |  1 |  1 |   |  1 L  |+   |+  H+   |+  H+   |+  H+  | "|@@ "|@ "|  @  |@  |  | @  1 | &|@@ &|  @ &|@ &| "|@@ "|  @  |   L "|  @   |@@  1 |  |  1 | " |@ |@  |   |  H  @  H+  |+ 20% - Colore 120% - Colore 220% - Colore 320% - Colore 420% - Colore 520% - Colore 640% - Colore 140% - Colore 240% - Colore 340% - Colore 440% - Colore 540% - Colore 660% - Colore 160% - Colore 260% - Colore 360% - Colore 4 60% - Colore 5!60% - Colore 6 "Calcolo#Cella collegata$Cella da controllare%&  'Colore 1 (Colore 2 )Colore 3 *Colore 4 +Colore 5 ,Colore 6 -Input./ 0Neutrale 1Nota 2Output34 Testo avviso5Testo descrittivo 6Titolo 7Titolo 1 8Titolo 2 9Titolo 3 :Titolo 4 ;Totale<Valore non valido= Valore valido>?`ALibro1SLibro2dfunzioni logiche{minimo + cerca.vert!Tasso + Ricerca Obiettivoj Tabelle Dati''      "P$ & 3 A@@ D' Tabella 1 K%Offerta e domanda aggregata di fondi Fondi r di offerta r di domanda r Rendimento r Equilibrio Tabella 2$Livello di investimento dell'impresa Distanza differenza rr di EQUILIBRIO DURATA INVESTIMENTO = 5 ANNIRENDIMENTO MENSILE = 183.66 r MENSILEBCercare il tasso d'equilibrio nel mercato dei capitali finanziari.BIn assenza di un valore che eguagli domanda ed offerta, si prenda GDeterminare il livelllo massimo d'investimento sostenibile dall'impresaRENDIMENTO MENSILE = 183,66 TABELLA DATICella di input per riga:Cella di input per colonna:A4RICERCA OBIETTIVO=In assenza di un valore che eguagli domanda ed offerta, si haFl'equilibrio se, in corrispondenza di un determinato livello di fondi,2i due tassi hanno una distanza inferiore allo 0,1%'R di equilibrio la media dei 2 tassi.Fla media dei tassi corrispondenti al livello di fondi che renda minimala distanza tra i due valori.H2G22PS NON E' UNA DEFINIZIONE ECONOMICA DI EQUILIBRIO!PS E' SOLO UN ESEMPIO/PS E' UN'APPROSSIMAZIONE (DA USARE NEL COMPITO)r Annuor Equilibrio di mercato* _ L!"cc||V}A} ,##0\ 0.ef??_-;_-@}A} ,##0\ 0.ef??_-;_-@}A} ,##0\ 0.ef??_-;_-@}A} ,##0\ 0.ef??_-;_-@}A} ,##0\ 0.ef??_-;_-@}A} ,##0\ 0.ef ??_-;_-@}A} ,##0\ 0.L??_-;_-@}A} ,##0\ 0.L??_-;_-@}A} ,##0\ 0.L??_-;_-@}A} ,##0\ 0.L??_-;_-@}A} ,##0\ 0.L??_-;_-@}A} ,##0\ 0.L ??_-;_-@}A} ,##0\ 0.23??_-;_-@}A} ,##0\ 0.23??_-;_-@}A} ,##0\ 0.23??_-;_-@}A} ,##0\ 0.23??_-;_-@}A}  ,##0\ 0.23??_-;_-@}A}! ,##0\ 0.23 ??_-;_-@}}" },##0\ 0.??_-;_-@0_-; * " ;_-@ }A}# },##0\ 0.??_-;_-@}}$ ,##0\ 0.??_-;_-@???0_-;??? * " ???;_-@ ???}A}% ,##0\ 0.??_-;_-@}A}& ,##0\ 0.??_-;_-@}A}' ,##0\ 0.??_-;_-@}A}( ,##0\ 0.??_-;_-@}A}) ,##0\ 0.??_-;_-@}A}* ,##0\ 0. ??_-;_-@}}+ ??v,##0\ 0.̙??_-;_-@0_-; * " ;_-@ }A}. e,##0\ 0.??_-;_-@}x}/,##0\ 0.??_0_  * ;_}}0 ???,##0\ 0.??_???0_ ??? *  ???;_-@ ???}-}2 ,##0\ 0.}-}3 ,##0\ 0.}-}4 ,##0\ 0.}A}5 ,##0\ 0.??_}A}6 ,##0\ 0.???_}A}7 ,##0\ 0.23??_}-}8 ,##0\ 0.}U}9 ,##0\ 0.??_0_ }A}: ,##0\ 0.??_}A}; a,##0\ 0.??_}(},##0\ 0.}(},##0\ 0.= @ !%=  !%= @ !%=  !%= @ !%=  !%= @ !%=  !%O20% - Colore 1 ef %O"20% - Colore 2 ef %O&20% - Colore 3 ef %O*20% - Colore 4 ef %O.20% - Colore 5 ef %O220% - Colore 6  ef %O40% - Colore 1 L %O#40% - Colore 2 L湸 %O'40% - Colore 3 L %O+40% - Colore 4 L %O/40% - Colore 5 L %O340% - Colore 6  Lմ %O 60% - Colore 1 23 %O$60% - Colore 2 23ٗ %O(60% - Colore 3 23֚ %O,60% - Colore 4 23 %O060% - Colore 5 23 %O460% - Colore 6  23 %yCalcolo  }% SCella collegata }%Cella da controllare  %????????? ???CColore 1 O %C!Colore 2 PM %C%Colore 3 Y %C)Colore 4 d %C-Colore 5 K %C1Colore 6  F %uInput ̙ ??v% &Migliaia. Migliaia [0]CNeutrale  e%$Normaleb Nota  wOutput  ???%????????? ???, Percentuale? Testo avviso %I5Testo descrittivo %3Titolo I}%ETitolo 1 I}%OETitolo 2 I}%?ETitolo 3 I}%237Titolo 4 I}%OTotale %OOUValore non valido  %M Valore valido  a%"Valuta* Valuta [0]XTableStyleMedium9PivotStyleLight16B  7BaJcN  h㈵>_*+%w&?'?(?)?"w@??U} C}  C}  C}  C}  C} C}  C}  C}  C}  C7 wDD wDwwwwww w w w w wwwwww wwwwww w FFx y GGz p q q r~ s IIt~ swAc9v?cQ?t~ sׇAcX9v?c鷯?t~ sc~jt?ct$~?t~ sחAcZd;O?cHPs?t~ sקAc F%u?c䃞ͪϵ?t~ sG cPkw? ca2U0*? t~ s׷A cX5;N? cvq -? t~ s5w cUN@? c:H? t sA c@c@ t sA c58EGr? cq? tstAcN@?cݵ|г?ts*dAcY8m?c:pΈ?ts@_Ac+eX?c@Lj?ts ZAcV-?c_vO?ts@TAc1%?c+eXw?tuOAdz6>W?~ dv]@@@@@^^^^^^____@`````@AAAAA@88<<<<<<<<2@@@@@@<  w!w"w#w$w%w&w'w(w)w*w+w,w-w.w/w0w1w2w3w4w5w6w AAAAA@!AAAAA@"AAAAA@#AAAAA@$AAAAA@%AAAAA@&AAAAA@'AAAAA@(AAAAA@)AAAAA@*AAAAA@+AAAAA@,AAAAA@-AAAAA@.AAAAA@/@@AAA@0@@AAA@1@@AAA@2@@AAA@3@@AAA@4@@BBB@5@@@@@@6@@@@@@2T<(  ~  <  XPP? U]4@  +;LpZD9Y <=SE(B5=C5; VERO;FALSO)< @~~  <  XPP? ]4@  E]&BFEi <=SE(B4=C4; VERO;FALSO)< @Alessandro Tosoni]Alessandro Tosoni]>@ 74/14?/14&BFEiPP0000?0014&BFEiPPggD&rs{+{4{+{00  7sT\`  h㈵>_*+%w&?'?(?)?"w??U} C}  C}  C}  C}  C} C}  C}  C}  C}  C7 wDwDwDwwwwww w w w w wwwwww wwwwww w FFx y GGz { H H |sIIt~ swAJ9v?JQ?t~ sׇAJX9v?J鷯?t~ sJ~jt?Jt$~?t~ sחAJZd;O?JHPs?t~ sקAJ F%u?J䃞ͪϵ?t~ sG JPkw? Ja2U0*? t~ s׷A JX5;N? Jvq -? t~ s5w JUN@? J:H? t sA J@J@ t sA J58EGr? Jq? tstAJN@?Jݵ|г?ts*dAJY8m?J:pΈ?ts@_AJ+eX?J@Lj?ts ZAJV-?J_vO?ts@TAJ1%?J+eXw?tuOAaz6>W?~ a}]@@@@@^^^^^^____@`````@AAAAA@88&<<<<<<<<2@@@@@@<  w!w"w#w$w%w&w'w(w)w*w+w,w-w.w/w0w1w2w3w4w5w6w AAAAA@!AAAAA@"AAAAA@#AAAAA@$AAAAA@%AAAAA@&AAAAA@'AAAAA@(AAAAA@)AAAAA@*AAAAA@+AAAAA@,AAAAA@-AAAAA@.AAAAA@/@@AAA@0@@AAA@1@@AAA@2@@AAA@3@@AAA@4@@BBB@5@@@@@@6@@@@@@2 (  ~  <Ի  XPP? y]4@Ի ( P&%DtE` < =SE(E(B4=C4;B4<>0); VERO;FALSO)< >@Alessandro TosoniL>@   74/14?/14O)DtE` 0000?0014O)DtE` ggD&rs{+{4{+{00  7dfqu  h㈵>_*+%w&?'?(?)?"w??U} C}  C}  C} C}  C} C}  C}  C}  C} U C}  C7  wD wD wD w w w w w w w w w w w w wwwwwwwwwwwwwwwww FFFFG VVVVVV GGGGG VVVVVV H H H H H VVVVVV LחAQQE߲? cP VWWWWW ~ IקAJzj#&t?JEuͩ? cP VWWWWW ~ IGJ ֐χ?J0 7? cP ~"WWWWW ~ I׷AJ?JbS? cP ~#WWWWW ~ I5wJ?JM,? cPIAJo ċ?J UM ? cP IA J:?? JOY۬? cP~ IA JW""; MEDIA(B18;C18);"")< #   Centro Maree;>@d $$$ 74/14?/14")\OЎ#*=nPP0000?0014")\OЎ#*=nPPggD&rr{+{4{+{00  7X~̋@  h㈵>_*+%w&?'?(?)?MTEPSON Stylus C82 Seriespv 4dhh4 *** qhhDLLName32=E_DU16HE.DLL L dL 2EPSON Stylus C82 Series" d??U} C}  C}  C}  C}  C}  C}  C}  C7  wD wD wD w w w w w w w w w w w w w w w w w w w w w w w w w w w w w wFFFx VVVVVV yGGGz VVVVVV { H H H  g VVVVVV חAMME߲? L VWWWWW ~ sקAKzj#&t?KEuͩ? I ~"WWWWW ~ sGK ֐χ?K0 7? I ~$WWWWW ~ s׷AK?KbS? I KK~ s5wK?KM,? I KKsAKo ċ?K UM ? I KK sA K:?? KOY۬? I KK~ sA KW@d  74/14?/14H9K]D  XPP0000?0014H9K]D  XPPggD& {+{4{+{00  lr  h㈵>_*+%w&?'?(?)?MEPSON Stylus D78 Series 4dhhEPSON Stylus D78 SeriesP@Open cfg file 4  hhL hh q**** q****d2 " d??U} }  }  }  }   Colonna D  w w V@ w w w w w w w w w w w w w w w w w w w w w w w w w w w FFFFF ZYYYXX G GGGG S TS S  TT   % &  EEEE~ IJJJJEEEE~ I@@JJJJEEEE~ I@@JJJJE E ~ Ip@JJJJEoJbJ ~ I@@JJJJEEEE~ I@JJJJEEEE~ Ip@ JJJJEEEE~ IX@ JJJJEEEE~ I@@ JJJJEEEE~ I@ JJJJEEEE~ I@ JJJJEEEE~ I|@JJJJEEEE~ Ip@JJJJEEEE~ Id@JJJJEEEE~ IX@JJJJEEEE~ IL@JJJJEEUE~ I@@JJJJEEEE~ I@JJJJEEEE~ I@JJJJEEEE~ I@JJJJEEEE~ @~ I@JJJJEEEE~ I|@JJJJEEEE~ Iv@JJJJEEEE~ Ip@JJJJEEEE   IJJJJEEEE EEE@DBXX((D*((((((((((((((((((((6` %(     f,: }?Text Box 14"PK!Zf[Content_Types].xmlMO &2WR=cJ`F0iK`#̼vLw 9uSq:w`G ^i ½KI)c/ $oVjTMRc|}042ҥCƔM̏P~*ka/8^DkHbL8e i"K\XN\6rco4y@_;oPK!1_a _rels/.relsj0 ѽqCNo^K [ILcX&m߾0XFo;>0xM e`|X}đ I`߽N4aG2$RKIZ)4(M9`ctB{m:f@`3n|O,ܗr޾jxR0T ,0@}WBLǬ5vPK!7PR!drs/shapexml.xmlV_O0`Y IHuBb}7qZ lӴ|iltH rǔpUJeN<̏&XTŤV<[niɦ23ʕ6\(;ENWε(7+XiYFa8od4Qd[YeWB uKyCUmtRb|!n꺘G8ޯ/I(hL8ۯ=KDQ^[I:^z0 E ^ٖ44:8qRGooMz}kzXz-ސ$w=X/6.mI>6L(WL-lVXC{~;zw]hGMs($N5Ti|$ 46"X4%%Xd8 !lu߸>AG95t>S·EKQͅ ,Ґ59 tcJuh0tAѝ҈ߗ"ES>B&_UM2P z ;y.8n>wC-5.h) ksj>1) H<e0+ i}SGSkr=dw[E+G%rq@pT% IHKl% wtڦP)Y{/y>+J"#7)ɜPm[^o5pKyGtTQin9+.VãIa>|P> 'ѧ7j쟁ݑ \ ^sq+~PK!2O'drs/downrev.xmlTO0M3Mֱ A1$ \--i =7oY0Ԋߡ@JuV )bW xt7Lj!K!h3( <ϦvN(rm$wX^.=ORᄂK!r/.߶4g+]aC3yDn_V wߏkSf n0 0EF&*-i߹ђ]Iu 1s+ڏtm%q/wBb?{? Q {7v PK-!Zf[Content_Types].xmlPK-!1_a /_rels/.relsPK-!7PR!*drs/shapexml.xmlPK-!2O'ydrs/downrev.xmlPK E=] `,: >   <!Imposta la cella Al valore 3,96%<##x 2 ! R-: o?Oval 16l R =]!`-: F  B " Xo?Line 17Y=Y ]"`p> 2 # R-: o?Oval 18= ]#`-: I  hh $ f-: }?Text Box 19"PK!Zf[Content_Types].xmlMO &2WR=cJ`F0iK`#̼vLw 9uSq:w`G ^i ½KI)c/ $oVjTMRc|}042ҥCƔM̏P~*ka/8^DkHbL8e i"K\XN\6rco4y@_;oPK!1_a _rels/.relsj0 ѽqCNo^K [ILcX&m߾0XFo;>0xM e`|X}đ I`߽N4aG2$RKIZ)4(M9`ctB{m:f@`3n|O,ܗr޾jxR0T ,0@}WBLǬ5vPK!)MLedrs/shapexml.xmlUn0 }ƎPu(еE}bˉPY$6}H)I/,DR!yD[͖yeM3i*[+3/ˣ1gF|#=?-?:Yn*L ((zZVcIƺVnݼW;Bd󝓢 )"jx|ʞKB(jm㪲-\6Mu$ jgW$i>$yWK<h{/#|7Mipc-8g נyuaݝbY9j`283^=ŮY:ώ!bF9Z/1ݵ]l2՞/3^P[)F=!Agպq(;4 Sh<9,&T &Y6ȑ &y$2윇o ;YAHT,=P^BXK(wٹvl)t/o߅y?KC[1ڂK:P:liC%9L;+=O-8[9|Nr r8!5̽bΩn&6Z:;K3P9 fH8jܣBUDNj5+8z7lV6+8~Uzp /aXqc{c(`FT4T+=+vo[a"*o tbPvYt B̐pG0@  7ggD&Z  <  h㈵>_*+%w&?'?(?)?MTEPSON Stylus C82 Seriespv 4dhh4 *** qhhDLLName32=E_DU16HE.DLL L dL 2EPSON Stylus C82 Series" d??U} }  }  }  }    w w w w w w w w w w w w w w w w w w w w w w w w w FFFFF S TS S TT G GGGG[@@ H H H H H Em$e@f@@g@`h@ ~ h@@iiiiE~ @@ lllnn ~ h@ jiiiE~ @ ll  l  nn ~ hp@ ji k iE~ p@ ll  l!  nn ~ hX@iiiiE~ X@lllnn ~ h@@iiiiE~ @@nnnnn ~ h@iiiiE~ @nnnnn ~ h@ iiiiE~ @ nnnnn ~ h|@ iiiiE~ |@ nnnnn ~ hp@ iiiiE~ p@ nnnnn ~ hd@ iiiiE~ d@ nnnnn ~ hX@ iiiiE~ X@ nnnnn ~ hL@iiiiE~ L@nnnnn ~ h@@iiiiE~ @@nnnnn ~ h@iiiiE~ @nnnnn ~ h@iiiiE~ @nnnnn ~ h@iiiiE~ @nnnnn ~ h@iiiiE~ @nnnnn ~ h@iiiiE~ @nnnnn ~ h|@iiiiE~ |@nnnnn ~ hv@iiiiE~ v@nnnnn ~ hp@iiiiE~ p@nnnnn IEEEE6& X6|PpDDDDDDDDDDDDDDDDDDp (     B4E:  XPP?\]4@4E: d^  l\DBJŔX <=TASSO(60;-183,66;A4)<   BE:  XPP?3]4@E: ^ xGqGAh<  < =(1+B4)^12-1< y   BE:  XPP?]4@E: _ ^C+RAdq <=Foglio2!($F$3)<   B`F:  XPP?Y]4@`F: a  BDiP < =C4-D4< DR[  BF:  XPP? ]4@F: da )EӥE o6( <=(1+TASSO(60;-H2;G2))^12-1<           >@ 7ggD& Oh+'0HPlx Claudio & GiampaoloaloMicrosoft Excel@{6Z@sw@?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijlmnopqrtuvwxyzRoot Entry FWorkbookSummaryInformation(kDocumentSummaryInformation8s