|
楼主 |
发表于 2007-5-29 01:12
|
显示全部楼层
<span lang="EN-US" style="FONT-SIZE: 24pt; COLOR: red; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt;">Excel</span><span style="FONT-SIZE: 24pt; COLOR: red; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt;">函数应用之财务函数(略)<br/><font color="#000000"><table cellspacing="1" cellpadding="1" width="653" bgcolor="#993300" border="0" style="FONT-SIZE: 10pt;"><tbody><tr bgcolor="#993333"><td align="center" width="102"><b><font face="宋体" color="#ffffff" size="2">函数名称</font></b></td><td align="center" width="381"><b><font face="宋体" color="#ffffff" size="2">函数说明</font></b></td><td align="center" width="202"><b><font face="宋体" color="#ffffff" size="2">语法形式</font></b></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b"><font face="宋体" size="2">ACCRINT</font></td><td width="381"><font face="宋体" size="2">返回定期付息有价证券的应计利息。</font></td><td width="202"><font face="宋体" size="2">ACCRINT(issue,first_interest,<span lang="en-us"> </span>settlement,rate,par,frequency,<span lang="en-us"> </span>basis)</font></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b"><font face="宋体" size="2">ACCRINTM</font></td><td width="381"><font face="宋体" size="2">返回到期一次性付息有价证券的应计利息。</font></td><td width="202"><font face="宋体">ACCRINTM(issue,maturity,rate,<span lang="en-us"> </span>par,basis)</font></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b"><font face="宋体">AMORDEGRC</font></td><td width="381"><font face="宋体">返回每个会计期间的折旧值。此函数是为法国会计系统提供的。</font></td><td width="202"><font face="宋体">AMORDEGRC(cost,date_purchased,<span lang="en-us"> </span>first_period,salvage,period,<span lang="en-us"> </span>rate,basis)</font></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b"><font face="宋体">AMORLINC</font></td><td width="381"><font face="宋体">返回每个会计期间的折旧值,该函数为法国会计系统提供。</font></td><td width="202"><font face="宋体">AMORLINC(cost,date_purchased,<span lang="en-us"> </span>first_period,salvage,period,<span lang="en-us"> </span>rate,basis)</font></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b"><font face="宋体">COUPDAYBS</font></td><td width="381"><font face="宋体">返回当前付息期内截止到成交日的天数。</font></td><td width="202"><font face="宋体">COUPDAYBS(settlement,maturity,<span lang="en-us"> </span>frequency, basis)</font></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b"><font face="宋体">COUPDAYS</font></td><td width="381"><font face="宋体">返回成交日所在的付息期的天数。</font></td><td width="202"><font face="宋体">COUPDAYS(settlement,maturity,<span lang="en-us"> </span>frequency, basis)</font></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b"><font face="宋体">COUPDAYSNC</font></td><td width="381"><font face="宋体">返回从成交日到下一付息日之间的天数。</font></td><td width="202"><font face="宋体">COUPDAYSNC(settlement,maturity,<span lang="en-us"> </span>frequency, basis)</font></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b"><font face="宋体">COUPNCD</font></td><td width="381"><font face="宋体">返回成交日过后的下一付息日的日期。</font></td><td width="202"><font face="宋体">COUPNCD(settlement,maturity,<span lang="en-us"> </span>frequency, basis)</font></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b"><font face="宋体">COUPNUM</font></td><td width="381"><font face="宋体">返回成交日和到期日之间的利息应付次数,向上取整到最近的整数。</font></td><td width="202"><font face="宋体">COUPNUM(settlement,maturity,<span lang="en-us"> </span>frequency, basis)</font></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b"><font face="宋体">COUPPCD</font></td><td width="381"><font face="宋体">返回成交日之前的上一付息日的日期。</font></td><td width="202"><font face="宋体">COUPPCD(settlement,maturity,<span lang="en-us"> </span>frequency, basis)</font></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b"><font face="宋体">CUMIPMT</font></td><td width="381"><font face="宋体">返回一笔贷款在给定的 start-period 到 end-period 期间累计偿还的利息数额。</font></td><td width="202"><font face="宋体">CUMIPMT(rate,nper,pv,start_period, end_period,type)</font></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b"><font face="宋体">CUMPRINC</font></td><td width="381"><font face="宋体">返回一笔贷款在给定的 start-period 到 end-period 期间累计偿还的本金数额。</font></td><td width="202"><font face="宋体">CUMPRINC(rate,nper,pv,start_period, end_period,type)</font></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b"><font face="宋体">DB</font></td><td width="381"><font face="宋体">使用固定余额递减法,计算一笔资产在给定期间内的折旧值。</font></td><td width="202"><font face="宋体">DB(cost,salvage,life,period,month)</font></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b"><font face="宋体">DDB</font></td><td width="381"><font face="宋体">使用双倍余额递减法或其他指定方法,计算一笔资产在给定期间内的折旧值。</font></td><td width="202"><font face="宋体">DDB(cost,salvage,life,period,factor)</font></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b"><font face="宋体">DISC</font></td><td width="381"><font face="宋体">返回有价证券的贴现率。</font></td><td width="202"><font face="宋体">DISC(settlement,maturity,pr,<span lang="en-us"> </span>redemption,basis)</font></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b"><font face="宋体">DOLLARDE</font></td><td width="381"><font face="宋体">将按分数表示的价格转换为按小数表示的价格,如证券价格,转换为小数表示的数字。</font></td><td width="202"><font face="宋体">DOLLARDE(fractional_dollar,<span lang="en-us"> </span>fraction)</font></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b"><font face="宋体">DOLLARFR</font></td><td width="381"><font face="宋体">将按小数表示的价格转换为按分数表示的价格。如证券价格,转换为分数型数字。</font></td><td width="202"><font face="宋体">DOLLARFR(decimal_dollar,<span lang="en-us"> </span>fraction)</font></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b"><font face="宋体">DURATION</font></td><td width="381"><font face="宋体">返回假设面值 $100 的定期付息有价证券的修正期限。期限定义为一系列现金流现值的加权平均值,用于计量债券价格对于收益率变化的敏感程度。</font></td><td width="202"><font face="宋体">DURATION(settlement,maturity,<span lang="en-us"> </span>coupon yld,frequency,basis)</font></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b"><font face="宋体">EFFECT</font></td><td width="381"><font face="宋体">利用给定的名义年利率和一年中的复利期次,计算实际年利率。</font></td><td width="202"><font face="宋体">EFFECT(nominal_rate,npery)</font></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b"><font face="宋体">FV</font></td><td width="381"><font face="宋体">基于固定利率及等额分期付款方式,返回某项投资的未来值。</font></td><td width="202"><font face="宋体">FV(rate,nper,pmt,pv,type)</font></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b"><font face="宋体">FVSCHEDULE</font></td><td width="381"><font face="宋体">基于一系列复利返回本金的未来值。函数 FVSCHDULE 用于计算某项投资在变动或可调利率下的未来值。</font></td><td width="202"><font face="宋体">FVSCHEDULE(principal,schedule)</font></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b"><font face="宋体">INTRATE</font></td><td width="381"><font face="宋体">返回一次性付息证券的利率。</font></td><td width="202"><font face="宋体">INTRATE(settlement,maturity,<span lang="en-us"> </span>investment,redemption,basis)</font></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b"><font face="宋体">IPMT</font></td><td width="381"><font face="宋体">基于固定利率及等额分期付款方式,返回投资或贷款在某一给定期次内的利息偿还额。</font></td><td width="202"><font face="宋体">IPMT(rate,per,nper,pv,fv,type)</font></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b"><font face="宋体">IRR</font></td><td width="381"><font face="宋体">返回由数值代表的一组现金流的内部收益率。</font></td><td width="202">IRR(values,guess)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">ISPMT</td><td width="381">计算特定投资期内要支付的利息。</td><td width="202">ISPMT(rate,per,nper,pv)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">MDURATION</td><td width="381">返回假设面值 $100 的有价证券的 Macauley 修正期限。</td><td width="202">MDURATION(settlement,maturity,<span lang="en-us"> </span>coupon,yld,frequency,basis)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">MIRR</td><td width="381">返回某一连续期间内现金流的修正内部收益率。</td><td width="202">MIRR(values,finance_rate,<span lang="en-us"> </span>reinvest_rate)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">NOMINAL</td><td width="381">基于给定的实际利率和年复利期数,返回名义年利率。</td><td width="202">NOMINAL(effect_rate,npery)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">NPER</td><td width="381">基于固定利率及等额分期付款方式,返回某项投资(或贷款)的总期数。</td><td width="202">NPER(rate, pmt, pv, fv, type)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">NPV</td><td width="381">通过使用贴现率以及一系列未来支出(负值)和收入(正值),返回一项投资的净现值。</td><td width="202"><p class="SYN">NPV(rate,value1,value2, ...)</p></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">ODDFPRICE</td><td width="381">返回首期付息日不固定的面值 $100 的有价证券的价格</td><td width="202"><p align="left">ODDFPRICE(settlement,maturity,<span lang="en-us"> </span>issue,first_coupon,rate,yld,<span lang="en-us"> </span>redemption,<span lang="en-us"> </span>frequency,basis)</p></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">ODDFYIELD</td><td width="381">返回首期付息日不固定的有价证券(长期或短期)的收益率。</td><td width="202">ODDFYIELD(settlement,maturity,<span lang="en-us"> </span>issue,first_coupon,rate,pr,<span lang="en-us"> </span>redemption,<span lang="en-us"> </span>frequency,basis)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">ODDLPRICE</td><td width="381">返回末期付息日不固定的面值 $100 的有价证券(长期或短期)的价格。</td><td width="202">ODDLPRICE(settlement,maturity,<span lang="en-us"> </span>last_interest,rate,yld,redemption,<span lang="en-us"> </span>frequency,basis)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">ODDLYIELD</td><td width="381">返回末期付息日不固定的有价证券(长期或短期)的收益率。</td><td width="202"><p class="SYN">ODDLYIELD(settlement,maturity,<span lang="en-us"> </span>last_interest,rate,pr,redemption,<span lang="en-us"> </span>frequency,basis)</p></td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">MT</td><td width="381">基于固定利率及等额分期付款方式,返回贷款的每期付款额。</td><td width="202">MT(rate,nper,pv,fv,type)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">PMT</td><td width="381">基于固定利率及等额分期付款方式,返回投资在某一给定期间内的本金偿还额。</td><td width="202">PMT(rate,per,nper,pv,fv,type)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">RICE</td><td width="381">返回定期付息的面值 $100 的有价证券的价格。</td><td width="202">RICE(settlement,maturity,<span lang="en-us"> </span>rate,yld,redemption,frequency,<span lang="en-us"> </span>basis)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">RICEDISC</td><td width="381">返回折价发行的面值 $100 的有价证券的价格。</td><td width="202">RICEDISC(settlement,maturity,<span lang="en-us"> </span>discount,redemption,basis)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">RICEMAT</td><td width="381">返回到期付息的面值 $100 的有价证券的价格。</td><td width="202">RICEMAT(settlement,maturity,<span lang="en-us"> </span>issue,rate,yld,basis)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">PV</td><td width="381">返回投资的现值。现值为一系列未来付款的当前值的累积和。例如,借入方的借入款即为贷出方贷款的现值。</td><td width="202">PV(rate,nper,pmt,fv,type)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">RATE</td><td width="381">返回年金的各期利率。函数 RATE 通过迭代法计算得出,并且可能无解或有多个解。</td><td width="202">RATE(nper,pmt,pv,fv,type,guess)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">RECEIVED</td><td width="381">返回一次性付息的有价证券到期收回的金额。</td><td width="202">RECEIVED(settlement,maturity,<span lang="en-us"> </span>investment,discount,basis)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">SLN</td><td width="381">返回某项资产在一个期间中的线性折旧值。</td><td width="202">SLN(cost,salvage,life)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">SYD</td><td width="381">返回某项资产按年限总和折旧法计算的指定期间的折旧值。</td><td width="202">SYD(cost,salvage,life,per)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">TBILLEQ</td><td width="381">返回国库券的等效收益率。</td><td width="202">TBILLEQ(settlement,maturity,<span lang="en-us"> </span>discount)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">TBILLPRICE</td><td width="381">返回面值 $100 的国库券的价格。</td><td width="202">TBILLPRICE(settlement,maturity,<span lang="en-us"> </span>discount)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">TBILLYIELD</td><td width="381">返回国库券的收益率。</td><td width="202">TBILLYIELD(settlement,maturity,pr)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">VDB</td><td width="381">使用双倍余额递减法或其他指定的方法,返回指定的任何期间内(包括部分期间)的资产折旧值。函数 VDB 代表可变余额递减法。</td><td width="202">VDB(cost,salvage,life,start_period,<span lang="en-us"> </span>end_period,factor,no_switch)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">XIRR</td><td width="381">返回一组现金流的内部收益率,这些现金流不一定定期发生。若要计算一组定期现金流的内部收益率,请使用函数 IRR。</td><td width="202">XIRR(values,dates,guess)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">XNPV</td><td width="381">返回一组现金流的净现值,这些现金流不一定定期发生。若要计算一组定期现金流的净现值,请使用函数 NPV。</td><td width="202">XNPV(rate,values,dates)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">YIELD</td><td width="381">返回定期付息有价证券的收益率,函数 YIELD 用于计算债券收益率。</td><td width="202">YIELD(settlement,maturity,rate,<span lang="en-us"> </span>pr,redemption,frequency,basis)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">YIELDDISC</td><td width="381">返回折价发行的有价证券的年收益率。</td><td width="202">YIELDDISC(settlement,maturity,<span lang="en-us"> </span>pr,redemption,basis)</td></tr><tr bgcolor="#dfbf9f"><td width="102" bgcolor="#b3b77b">YIELDMAT</td><td width="381">返回到期付息的有价证券的年收益率。</td><td width="202">YIELDMAT(settlement,maturity,<span lang="en-us"> </span>issue,rate,pr,basis)</td></tr></tbody></table></font></span>
[此贴子已经被作者于2007-5-29 1:13:57编辑过] |
|