Difference between revisions of "Manuals/calci/DURATION"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<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></...")
 
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>
  

Revision as of 06:53, 25 November 2013

DURATION(settlement, maturity, coupon, yield, frequency, basis)

  • 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.

DURATION() gives the Macauley duration for an assumed par value of $100.

Description

DURATION(settlement, maturity, coupon, yield, frequency, basis)

  • 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.
  • The values for 'F' is 1,2 and 4.
  • Basis value should between 0 and 4.
 Lets see an example,

DURATION(settle, M, C, Yield, F, basis)

B

September 10, 2010

Septembet 10, 2016

6%

9.0%

2

1

=DURATION(B2,B3,B4,B5,B6,B7) is 5.0458




Syntax

Remarks

Examples

Description

Column1 Column2 Column3 Column4
Row1 September 10, 2010
Row2 September 10, 2016
Row3 6%
Row4 9.0%
Row5 2
Row6 1 5.0458