writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + Line 14:
Line 14: − + − + − + − + + + + + + − <div id="8SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif"><font size="2">Lets see an example,</font></font></font>+ − <font color="#000000"><font face="Arial, sans-serif"><font size="2">DURATION(settle, M, C, Yield, F, basis)</font></font></font>+ − <font color="#000000"><font face="Arial, sans-serif"><font size="2">'''B'''</font></font></font> − − <font color="#000000"><font face="Arial, sans-serif"><font size="2">September 10, 2010</font></font></font> − − <font color="#000000"><font face="Arial, sans-serif"><font size="2">Septembet 10, 2016</font></font></font> − − <font color="#000000"><font face="Arial, sans-serif"><font size="2">6%</font></font></font> − − <font color="#000000"><font face="Arial, sans-serif"><font size="2">9.0%</font></font></font> − − <font color="#000000"><font face="Arial, sans-serif"><font size="2">2</font></font></font> − − <font color="#000000"><font face="Arial, sans-serif"><font size="2">1</font></font></font> − − <font color="#000000"><font face="Arial, sans-serif"><font size="2"><nowiki>=DURATION(B2,B3,B4,B5,B6,B7) is 5.0458</nowiki></font></font></font> − − <br /><br /> − − </div> − ---- − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div> − ---- − <div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div> − ---- − <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div> − ---- − <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div> − ---- Line 96:
Line 73: − <div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div> − − <div align="left">[[Image:calci1.gif]]</div></div> − ----
Manuals/calci/DURATION (view source)
Revision as of 13:00, 26 November 2013
, 13:00, 26 November 2013no edit summary
=DURATION(settlement, maturity, coupon, yield, frequency, basis)=
=DURATION(settlement, maturity, coupon, yield, frequency, basis)=
*Where 'settlement' is the security's settlement date (a date when coupon is purchased),
*Where 'settlement' is the security's settlement date (a date when coupon or a bond is purchased),
*'maturity' is the security's maturity date (a date when coupon expires),
*'maturity' is the security's maturity date (a date when coupon or a bond expires),
*'coupon' is the security's annual coupon rate,
*'coupon' is the security's annual coupon rate,
*'yield' is the security's annual yield,
*'yield' is the security's annual yield,
DURATION(settlement, maturity, coupon, yield, frequency, basis)
DURATION(settlement, maturity, coupon, yield, frequency, basis)
*DURATION calculates the error value when settlement or maturity is not a valid or settlement ≥ maturity.
*If settlement or maturity dates are not valid, Calci displays an error message.
*'C' and 'Yield' must be grater than or equal to zero.
*If settlement date ≥ maturity date, Calci displays an error message.
*The values for 'F' is 1,2 and 4.
*'coupon' and 'yield' values must be greater than or equal to zero.
*Basis value should between 0 and 4.
*The values for 'frequency' should be 1,2 or 4.
For Annual payment, frequency = 1,
For Semi-annual payment, frequency = 2,
For Quarterly payment, frequency = 4.
*'basis' value is optional. If omitted, Calci assumes to be 0.
Below table shows the use of 'basis' values:
*If 'basis' value other than 0 to 4, Calci displays an error message.
== Examples ==
<div id="2SpaceContent" class="zcontent" align="left">
<div id="2SpaceContent" class="zcontent" align="left">
| class=" sshl_f " |
| class=" sshl_f " |
| class=" SelectTD SelectTD" |
| class=" SelectTD SelectTD" |
|}
|}