论坛 › LINDO\LINGO论坛 › 新人求助，如何用lingo解决投资决策问题？

lizzieliu 发表于 2008-8-4 18:39

新人求助，如何用lingo解决投资决策问题？

我实在是不会做这道题，所以来求救了<br/>题目是这样：

<p class="MsoNormal" style="text-indent: 24pt; line-height: 150%;"><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">假设市场上有</span><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">m</span><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">种资产（如股票、证券等），某资产投资公司计划用一笔数额为</span><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">N</span><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">的资金进行一个时期的投资。</span><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">公司财务分析人员对这</span><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">m</span><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">种资产进行了评估和分析，可供投资的资产以及其信用等级、到期年限、收益如下表所示。按照规定，甲类资产的收益按<span lang="EN-US">20%</span>的税率纳税，其它资产的收益按<span lang="EN-US">50%</span>的税率纳税，此外还要求：<span lang="EN-US"><o:p></o:p></span></span></p>

<p class="MsoNormal" style="margin-left: 36pt; text-indent: -36pt; line-height: 150%;"><!----><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;" lang="EN-US"><span style="">（1）<span style="" new="" roman&quot;;="" font-style:="" font-variant:="" font-weight:="" font-size:="" 7pt;="" line-height:="" font-size-adjust:="" none;="" font-stretch:="" normal;="">&nbsp;&nbsp;&nbsp; </span></span></span><!----><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">种类为乙、丙和丁的资产总共至少要投资<span lang="EN-US">450</span>万元；<span lang="EN-US"><o:p></o:p></span></span></p>

<p class="MsoNormal" style="margin-left: 36pt; text-indent: -36pt; line-height: 150%;"><!----><span style="font-size: 12pt; line-height: 150%;" lang="EN-US"><span style="">（2）<span style="" new="" roman&quot;;="" font-style:="" font-variant:="" font-weight:="" font-size:="" 7pt;="" line-height:="" font-size-adjust:="" none;="" font-stretch:="" normal;="">&nbsp;&nbsp;&nbsp;
</span></span></span><!----><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">所投资的资产的平均信用等级不超过<span lang="EN-US">1.5</span>（信用等级数值越少，信用程度越高）；</span><span style="font-size: 12pt; line-height: 150%;" lang="EN-US"><o:p></o:p></span></p>

<p class="MsoNormal" style="margin-left: 36pt; text-indent: -36pt; line-height: 150%;"><!----><span style="font-size: 12pt; line-height: 150%;" lang="EN-US"><span style="">（3）<span style="" new="" roman&quot;;="" font-style:="" font-variant:="" font-weight:="" font-size:="" 7pt;="" line-height:="" font-size-adjust:="" none;="" font-stretch:="" normal;="">&nbsp;&nbsp;&nbsp;
</span></span></span><!----><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">所投资资产的平均到期年限不超过<span lang="EN-US">5</span>年；</span><span style="font-size: 12pt; line-height: 150%;" lang="EN-US"><o:p></o:p></span></p>

<p class="MsoNormal" style="margin-left: 36pt; text-indent: -36pt; line-height: 150%;"><!----><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;" lang="EN-US"><span style="">（4）<span style="" new="" roman&quot;;="" font-style:="" font-variant:="" font-weight:="" font-size:="" 7pt;="" line-height:="" font-size-adjust:="" none;="" font-stretch:="" normal;="">&nbsp;&nbsp;&nbsp; </span></span></span><!----><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">假定同期银行存款利率是<span lang="EN-US"><span style="position: relative; top: 6pt;"><!--><v:shapetype id="_x0000_t75"
coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe"
filled="f" stroked="f">
<v:stroke joinstyle="miter"/>
<v:formulas>
  <v:f eqn="if linedrawn="lineDrawn"  pixellinewidth="pixelLineWidth"  0"/>
  <v:f eqn="sum @0 1="1"  0"/>
  <v:f eqn="sum 0="0"  0="0"  @1"/>
  <v:f eqn="prod @2 1="1"  2"/>
  <v:f eqn="prod @3 21600="21600"  pixelWidth"/>
  <v:f eqn="prod @3 21600="21600"  pixelHeight"/>
  <v:f eqn="sum @0 0="0"  1"/>
  <v:f eqn="prod @6 1="1"  2"/>
  <v:f eqn="prod @7 21600="21600"  pixelWidth"/>
  <v:f eqn="sum @8 21600="21600"  0"/>
  <v:f eqn="prod @7 21600="21600"  pixelHeight"/>
  <v:f eqn="sum @10 21600="21600"  0"/>
</v:formulas>
<v:path o:extrusi gradientshapeok="t" o:c/>
<o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="_x0000_i1025" type="#_x0000_t75" style="'width:11.25pt;
" height:18pt' o:ole="">
<v:imagedata src="file:///C:\Users\lxcl\AppData\Local\Temp\msohtml1\01\clip_image001.wmz"
  o:title=""/>
</v:shape><!--><!----><img src="file:///C:%5CUsers%5Clxcl%5CAppData%5CLocal%5CTemp%5Cmsohtml1%5C01%5Cclip_image002.gif" v:shapes="_x0000_i1025" height="24" width="15"/><!----></span><!--><xml>
<o:OLEObject type="Embed" progid="Equation.3" shapeid="_x0000_i1025"
  drawaspect="Content" objectid="_1279379376">
</o:OLEObject>
</xml><!-->, </span>且既无交易费又无风险。（<span lang="EN-US"><span style="position: relative; top: 6pt;"><!--><v:shape id="_x0000_i1026"
type="#_x0000_t75" style="width:11.25pt;height:18pt" o:ole="">
<v:imagedata src="file:///C:\Users\lxcl\AppData\Local\Temp\msohtml1\01\clip_image003.wmz"
  o:title=""/>
</v:shape><!--><!----><img src="file:///C:%5CUsers%5Clxcl%5CAppData%5CLocal%5CTemp%5Cmsohtml1%5C01%5Cclip_image002.gif" v:shapes="_x0000_i1026" height="24" width="15"/><!----></span><!--><xml>
<o:OLEObject type="Embed" progid="Equation.3" shapeid="_x0000_i1026"
  drawaspect="Content" objectid="_1279379377">
</o:OLEObject>
</xml><!-->=5%</span>）<span lang="EN-US">.<o:p></o:p></span></span></p>

<div align="center">

<table class="MsoTableGrid" style="" medium="" n="n"  ;="" border-collapse:="" collapse;="" border="1" cellpadding="0" cellspacing="0">
<tbody><tr style="">
  <td style="" 1pt="" solid="solid" windowtext;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 77.4pt;="" width="103">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">资产名称</span><span style="font-size: 12pt; line-height: 150%;" lang="EN-US"><o:p></o:p></span></p>
  </td>
  <td style="" solid="" none;="" border-color:="" windowtext="windowtext" border-width:="" 1pt="1pt" medium;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 72pt;="" width="96">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">资产种类</span><span style="font-size: 12pt; line-height: 150%;" lang="EN-US"><o:p></o:p></span></p>
  </td>
  <td style="" solid="" none;="" border-color:="" windowtext="windowtext" border-width:="" 1pt="1pt" medium;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 81pt;="" width="108">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">信用等级</span><span style="font-size: 12pt; line-height: 150%;" lang="EN-US"><o:p></o:p></span></p>
  </td>
  <td style="" solid="" none;="" border-color:="" windowtext="windowtext" border-width:="" 1pt="1pt" medium;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 72pt;="" width="96">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">到期年限</span><span style="font-size: 12pt; line-height: 150%;" lang="EN-US"><o:p></o:p></span></p>
  </td>
  <td style="" solid="" none;="" border-color:="" windowtext="windowtext" border-width:="" 1pt="1pt" medium;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 123.7pt;="" width="165">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">到期税前收益（</span><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">%</span><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">）</span><span style="font-size: 12pt; line-height: 150%;" lang="EN-US"><o:p></o:p></span></p>
  </td>
</tr>
<tr style="">
  <td style="" nsolid" solid;="" border-color:="" windowtext="windowtext" windowtext;="" border-width:="" medium="medium" 1pt="1pt" 1pt;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 77.4pt;="" width="103">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">A<o:p></o:p></span></p>
  </td>
  <td style="" nsolid" none;="" border-color:="" windowtext="windowtext" border-width:="" medium="medium" 1pt="1pt" medium;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 72pt;="" width="96">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">甲</span><span style="font-size: 12pt; line-height: 150%;" lang="EN-US"><o:p></o:p></span></p>
  </td>
  <td style="" nsolid" none;="" border-color:="" windowtext="windowtext" border-width:="" medium="medium" 1pt="1pt" medium;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 81pt;="" width="108">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">2<o:p></o:p></span></p>
  </td>
  <td style="" nsolid" none;="" border-color:="" windowtext="windowtext" border-width:="" medium="medium" 1pt="1pt" medium;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 72pt;="" width="96">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">9<o:p></o:p></span></p>
  </td>
  <td style="" nsolid" none;="" border-color:="" windowtext="windowtext" border-width:="" medium="medium" 1pt="1pt" medium;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 123.7pt;="" width="165">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">4.3<o:p></o:p></span></p>
  </td>
</tr>
<tr style="">
  <td style="" nsolid" solid;="" border-color:="" windowtext="windowtext" windowtext;="" border-width:="" medium="medium" 1pt="1pt" 1pt;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 77.4pt;="" width="103">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">B<o:p></o:p></span></p>
  </td>
  <td style="" nsolid" none;="" border-color:="" windowtext="windowtext" border-width:="" medium="medium" 1pt="1pt" medium;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 72pt;="" width="96">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">乙</span><span style="font-size: 12pt; line-height: 150%;" lang="EN-US"><o:p></o:p></span></p>
  </td>
  <td style="" nsolid" none;="" border-color:="" windowtext="windowtext" border-width:="" medium="medium" 1pt="1pt" medium;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 81pt;="" width="108">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">2<o:p></o:p></span></p>
  </td>
  <td style="" nsolid" none;="" border-color:="" windowtext="windowtext" border-width:="" medium="medium" 1pt="1pt" medium;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 72pt;="" width="96">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">14<o:p></o:p></span></p>
  </td>
  <td style="" nsolid" none;="" border-color:="" windowtext="windowtext" border-width:="" medium="medium" 1pt="1pt" medium;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 123.7pt;="" width="165">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">5.5<o:p></o:p></span></p>
  </td>
</tr>
<tr style="">
  <td style="" nsolid" solid;="" border-color:="" windowtext="windowtext" windowtext;="" border-width:="" medium="medium" 1pt="1pt" 1pt;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 77.4pt;="" width="103">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">C<o:p></o:p></span></p>
  </td>
  <td style="" nsolid" none;="" border-color:="" windowtext="windowtext" border-width:="" medium="medium" 1pt="1pt" medium;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 72pt;="" width="96">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">丙</span><span style="font-size: 12pt; line-height: 150%;" lang="EN-US"><o:p></o:p></span></p>
  </td>
  <td style="" nsolid" none;="" border-color:="" windowtext="windowtext" border-width:="" medium="medium" 1pt="1pt" medium;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 81pt;="" width="108">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">1<o:p></o:p></span></p>
  </td>
  <td style="" nsolid" none;="" border-color:="" windowtext="windowtext" border-width:="" medium="medium" 1pt="1pt" medium;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 72pt;="" width="96">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">4<o:p></o:p></span></p>
  </td>
  <td style="" nsolid" none;="" border-color:="" windowtext="windowtext" border-width:="" medium="medium" 1pt="1pt" medium;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 123.7pt;="" width="165">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">5.0<o:p></o:p></span></p>
  </td>
</tr>
<tr style="">
  <td style="" nsolid" solid;="" border-color:="" windowtext="windowtext" windowtext;="" border-width:="" medium="medium" 1pt="1pt" 1pt;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 77.4pt;="" width="103">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">D<o:p></o:p></span></p>
  </td>
  <td style="" nsolid" none;="" border-color:="" windowtext="windowtext" border-width:="" medium="medium" 1pt="1pt" medium;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 72pt;="" width="96">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">甲</span><span style="font-size: 12pt; line-height: 150%;" lang="EN-US"><o:p></o:p></span></p>
  </td>
  <td style="" nsolid" none;="" border-color:="" windowtext="windowtext" border-width:="" medium="medium" 1pt="1pt" medium;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 81pt;="" width="108">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">5<o:p></o:p></span></p>
  </td>
  <td style="" nsolid" none;="" border-color:="" windowtext="windowtext" border-width:="" medium="medium" 1pt="1pt" medium;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 72pt;="" width="96">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">2<o:p></o:p></span></p>
  </td>
  <td style="" nsolid" none;="" border-color:="" windowtext="windowtext" border-width:="" medium="medium" 1pt="1pt" medium;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 123.7pt;="" width="165">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">4.5<o:p></o:p></span></p>
  </td>
</tr>
<tr style="">
  <td style="" nsolid" solid;="" border-color:="" windowtext="windowtext" windowtext;="" border-width:="" medium="medium" 1pt="1pt" 1pt;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 77.4pt;="" width="103">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">E<o:p></o:p></span></p>
  </td>
  <td style="" nsolid" none;="" border-color:="" windowtext="windowtext" border-width:="" medium="medium" 1pt="1pt" medium;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 72pt;="" width="96">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">丁</span><span style="font-size: 12pt; line-height: 150%;" lang="EN-US"><o:p></o:p></span></p>
  </td>
  <td style="" nsolid" none;="" border-color:="" windowtext="windowtext" border-width:="" medium="medium" 1pt="1pt" medium;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 81pt;="" width="108">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">4<o:p></o:p></span></p>
  </td>
  <td style="" nsolid" none;="" border-color:="" windowtext="windowtext" border-width:="" medium="medium" 1pt="1pt" medium;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 72pt;="" width="96">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">3<o:p></o:p></span></p>
  </td>
  <td style="" nsolid" none;="" border-color:="" windowtext="windowtext" border-width:="" medium="medium" 1pt="1pt" medium;="" padding:="" 0cm="0cm" 5.4pt;="" width:="" 123.7pt;="" width="165">
  <p class="MsoNormal" style="text-align: center; line-height: 150%;" align="center"><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">5.6<o:p></o:p></span></p>
  </td>
</tr>
</tbody></table>

</div>

<p class="MsoNormal" style="line-height: 150%;"><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">现在需讨论以下问题：</span><span style="font-size: 12pt; line-height: 150%;" lang="EN-US"><o:p></o:p></span></p>

<p class="MsoNormal" style="margin-left: 36pt; text-indent: -36pt; line-height: 150%;"><!----><span style="font-size: 12pt; line-height: 150%;" lang="EN-US"><span style="">（1）<span style="" new="" roman&quot;;="" font-style:="" font-variant:="" font-weight:="" font-size:="" 7pt;="" line-height:="" font-size-adjust:="" none;="" font-stretch:="" normal;="">&nbsp;&nbsp;&nbsp;
</span></span></span><!----><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">若该公司有</span><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">2000</span><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">万元现金，应如何投资？</span><span style="font-size: 12pt; line-height: 150%;" lang="EN-US"><o:p></o:p></span></p>

<p class="MsoNormal" style="margin-left: 36pt; text-indent: -36pt; line-height: 150%;"><!----><span style="font-size: 12pt; line-height: 150%;" lang="EN-US"><span style="">（2）<span style="" new="" roman&quot;;="" font-style:="" font-variant:="" font-weight:="" font-size:="" 7pt;="" line-height:="" font-size-adjust:="" none;="" font-stretch:="" normal;="">&nbsp;&nbsp;&nbsp;
</span></span></span><!----><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">如果该公式能够以</span><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">2.7%</span><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">的利率借到不超过</span><span style="font-size: 12pt; line-height: 150%;" lang="EN-US">150</span><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;">万元资金，该公司是否借贷。</span></p><p class="MsoNormal" style="margin-left: 36pt; text-indent: -36pt; line-height: 150%;"><br/></p><p class="MsoNormal" style="margin-left: 36pt; text-indent: -36pt; line-height: 150%;">

</p><br/><p class="MsoNormal" style="margin-left: 36pt; text-indent: -36pt; line-height: 150%;"><br/><span style="font-size: 12pt; line-height: 150%; font-family: 宋体;"></span><span style="font-size: 12pt; line-height: 150%;" lang="EN-US"><o:p></o:p></span></p>

查看完整版本: 新人求助，如何用lingo解决投资决策问题？