| Line 1: |
Line 1: |
| − | <div id="6SpaceContent" class="zcontent" align="left"> '''<font color="#484848"><font face="Arial, sans-serif"><font size="2">DURATION(settle, M, C, Yield, F, basis)</font></font></font>'''
| + | =DURATION(settlement, maturity, coupon, yield, frequency, basis)= |
| | | | |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''Where 'settle''''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2"> is the security's settlement date, 'M' is the security's maturity date, 'C' is the security's annual coupon rate, 'Yield' is the security's annual yield, 'F' is the number of coupon payments per year, and 'basis' is the type of day count basis to use.</font></font></font>
| + | *Where 'settlement' is the security's settlement date, |
| | + | *'maturity' is the security's maturity date, |
| | + | *'coupon' is the security's annual coupon rate, |
| | + | *'yield' is the security's annual yield, |
| | + | *'frequency' is the number of coupon payments per year, and |
| | + | *'basis' is the type of day count basis to use. |
| | | | |
| − | </div>
| + | DURATION() gives the Macauley duration for an assumed par value of $100. |
| − | ----
| |
| − | <div id="1SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">This function gives the Macauley duration for an assumed par value of $100. </font></font></font></div>
| |
| − | ----
| |
| − | <div id="7SpaceContent" class="zcontent" align="left">
| |
| | | | |
| − | * <font color="#000000"><font face="Arial, sans-serif"><font size="2">DURATION calculates the error value when settlement or maturity is not a valid or settlement ≥ maturity.</font></font></font>
| + | == Description == |
| | | | |
| − | * <font color="#000000"><font face="Arial, sans-serif"><font size="2">'C' and 'Yield' must be grater than or equal to zero.</font></font></font>
| + | DURATION(settlement, maturity, coupon, yield, frequency, basis) |
| − | * <font color="#000000"><font face="Arial, sans-serif"><font size="2">The values for 'F' is 1,2 and 4</font></font></font>
| |
| − | * <font color="#000000"><font face="Arial, sans-serif"><font size="2">Basis value should between 0 and 4.</font></font></font>
| |
| | | | |
| − | </div>
| + | *DURATION calculates the error value when settlement or maturity is not a valid or settlement ≥ maturity. |
| − | ----
| + | *'C' and 'Yield' must be grater than or equal to zero. |
| − | <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
| + | *The values for 'F' is 1,2 and 4. |
| | + | *Basis value should between 0 and 4. |
| | | | |
| − | DURATION
| |
| − |
| |
| − | </div></div>
| |
| − | ----
| |
| | <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> | | <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> |
| | | | |