Manuals/calci/DURATION - Revision history

Devika at 22:11, 22 August 2018

2018-08-22T22:11:54Z

Devika at 21:52, 29 June 2018

2018-06-29T21:52:50Z

Jayaram at 10:49, 14 March 2017

2017-03-14T10:49:36Z

Swapna: /* Examples */

2015-10-12T18:58:15Z

Examples

Swapna: /* Examples */

2015-10-12T18:54:55Z

Examples

Swapna: /* Examples */

2015-10-12T18:54:29Z

Examples

Swapna at 20:59, 20 April 2015

2015-04-20T20:59:45Z

Swapna at 23:13, 18 January 2014

2014-01-18T23:13:31Z

Swapna: /* Description */

2013-11-27T03:17:25Z

Description

Swapna at 03:11, 27 November 2013

2013-11-27T03:11:44Z

@@ Line 6: / Line 6: @@
 *<math>Frequency</math> is the number of coupon payments per year, and
 *<math>Basis</math> is the type of day count basis to use.
+**DURATION(), returns the annual duration of a security with periodic interest payments.
 == Description ==

@@ Line 1: / Line 1: @@
-=DURATION(SettlementDate, MaturityDate, Coupon, Yield, Frequency, Basis)=
+<div style="font-size:30px">'''DURATION (Settlement,Maturity,Coupon,Yield,Frequency,Basis)'''</div><br/>
+*Where <math>Settlement</math> is the security's settlement date (a date when coupon or a bond is purchased),
-*Where <math>SettlementDate</math> is the security's settlement date (a date when coupon or a bond is purchased),
+*<math>Maturity</math> is the security's maturity date (a date when coupon or a bond expires),
 *<math>Coupon</math> is the security's annual coupon rate,
 *<math>Yield</math> is the security's annual yield,
@@ Line 8: / Line 7: @@
 *<math>Basis</math> is the type of day count basis to use.
-DURATION() gives the Macauley duration of a security for an assumed par value of $100.
+DURATION(), returns the annual duration of a security with periodic interest payments.
 == Description ==
-DURATION(SettlementDate, MaturityDate, Coupon, Yield, Frequency, Basis)
+DURATION(Settlement, Maturity, Coupon, Yield, Frequency, Basis)
 DURATION() calculates the rate of change of price with respect to yields. It is the weighted average time until cash flows are received.
-*<math>SettlementDate</math> and <math>MaturityDate</math> dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
+*<math>Settlement</math> and <math>Maturity</math> dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
-*If <math>SettlementDate</math> date ≥ <math>MaturityDate</math> date, Calci displays #N/A error message.
+*If <math>Settlement</math> date ≥ <math>Maturity</math> date, Calci displays #N/A error message.
 *<math>Coupon</math> and <math>Yield</math> values must be greater than or equal to zero.
 *The values for <math>Frequency</math> should be 1,2 or 4.

← Older revision		Revision as of 10:49, 14 March 2017
Line 112:		Line 112:
	*[http://en.wikipedia.org/wiki/Bond_duration#Macaulay_duration Macaulay Duration]		*[http://en.wikipedia.org/wiki/Bond_duration#Macaulay_duration Macaulay Duration]
	*[http://en.wikipedia.org/wiki/Day_count_convention Day Count Basis]		*[http://en.wikipedia.org/wiki/Day_count_convention Day Count Basis]
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 98: / Line 98: @@
   =DURATION(A1,A2,A3,A4,A5,A6) displays '''5.045790027952841''' as a result.
-  =DURATION(DATE(2013,6,1),DATE(2013,12,31),"6%","8%",1,1) displays '''1.9423897589712318''' as a result.
+  =DURATION(DATE(2013,6,1),DATE(2013,12,31),"6%","8%",1,1) displays '''1''' as a result.
 ==Related Videos==

@@ Line 98: / Line 98: @@
   =DURATION(A1,A2,A3,A4,A5,A6) displays '''5.045790027952841''' as a result.
-  =DURATION(DATE(2013,6,1),DATE(2013,12,31),"6%","8%",1,1) displays '''1.9423897589712318'' as a result.
+  =DURATION(DATE(2013,6,1),DATE(2013,12,31),"6%","8%",1,1) displays '''1.9423897589712318''' as a result.
 ==Related Videos==

@@ Line 54: / Line 54: @@
 {| id="TABLE3" class="SpreadSheet blue"
 |- class="even"
 | class=" " | September 10, 2010
 | class=" " |
 | class=" " |
-|- class="odd"
+|- class="even"
 | class="sshl_f" | September 10, 2016
 | class=" " |
 | class=" " |
-|- class="even"
+|- class="odd"
 | class=" " | 6%
 | class=" " |
 | class=" " |
-|- class="odd"
+|- class="even"
 | class=" " | 9.0%
 | class=" " |
 | class=" " |
-|- class="even"
+|- class="odd"
 | class=" " | 2
 | class=" " |
 | class=" " |
-|- class="odd"
+|- class="even"
 | class=" " | 1
 | class=" " |
@@ Line 85: / Line 97: @@
 |}
-  =DURATION(A1,A2,A3,A4,A5,A6) ''displays 5.045790027952841'' as a result.
+  =DURATION(A1,A2,A3,A4,A5,A6) displays '''5.045790027952841''' as a result.
-  =DURATION(DATE(2013,6,1),DATE(2013,12,31),"6%","8%",1,1) ''displays 1.9423897589712318'' as a result.
+  =DURATION(DATE(2013,6,1),DATE(2013,12,31),"6%","8%",1,1) displays '''1.9423897589712318'' as a result.
 ==Related Videos==

@@ Line 1: / Line 1: @@
-=DURATION(settlement, maturity, coupon, yield, frequency, basis)=
+=DURATION(SettlementDate, MaturityDate, Coupon, Yield, Frequency, Basis)=
-*Where 'settlement' is the security's settlement date (a date when coupon or a bond is purchased),
+*Where <math>SettlementDate</math> 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 or a bond expires),
+*<math>MaturityDate</math> is the security's maturity date (a date when coupon or a bond expires),
-*'coupon' is the security's annual coupon rate,
+*<math>Coupon</math> is the security's annual coupon rate,
-*'yield' is the security's annual yield,
+*<math>Yield</math> is the security's annual yield,
-*'frequency' is the number of coupon payments per year, and
+*<math>Frequency</math> is the number of coupon payments per year, and
-*'basis' is the type of day count basis to use.
+*<math>Basis</math> is the type of day count basis to use.
 DURATION() gives the Macauley duration of a security for an assumed par value of $100.
@@ Line 12: / Line 12: @@
 == Description ==
-DURATION(settlement, maturity, coupon, yield, frequency, basis)
+DURATION(SettlementDate, MaturityDate, Coupon, Yield, Frequency, Basis)
 DURATION() calculates the rate of change of price with respect to yields. It is the weighted average time until cash flows are received.
-*Settlement and maturity dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
+*<math>SettlementDate</math> and <math>MaturityDate</math> dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
-*If settlement date ≥ maturity date, Calci displays #N/A error message.
+*If <math>SettlementDate</math> date ≥ <math>MaturityDate</math> date, Calci displays #N/A error message.
-*'coupon' and 'yield' values must be greater than or equal to zero.
+*<math>Coupon</math> and <math>Yield</math> values must be greater than or equal to zero.
-*The values for 'frequency' should be 1,2 or 4.
+*The values for <math>Frequency</math> should be 1,2 or 4.
 For Annual payment, frequency = 1,
@@ Line 26: / Line 26: @@
 For Quarterly payment, frequency = 4.
-*'basis' value is optional. If omitted, Calci assumes it to be 0.
+*<math>Basis</math> value is optional. If omitted, Calci assumes it to be 0.
-Below table shows the use of 'basis' values:
+Below table shows the use of <math>Basis</math> values:
 {| class="wikitable"
@@ Line 44: / Line 44: @@
 |}
-*If 'basis' value is other than 0 to 4, Calci displays #N/A error message.
+*If <math>Basis</math> value is other than 0 to 4, Calci displays #N/A error message.
 == Examples ==
@@ Line 85: / Line 85: @@
 |}
-=DURATION(A1,A2,A3,A4,A5,A6) ''displays 5.045790027952841'' as a result.
+ =DURATION(A1,A2,A3,A4,A5,A6) ''displays 5.045790027952841'' as a result.
 == See Also ==

@@ Line 14: / Line 14: @@
 DURATION(settlement, maturity, coupon, yield, frequency, basis)
-DURATION() calculates the rate of change of price with respect to yields. It is the weighted average time of until cash flows are received.
+DURATION() calculates the rate of change of price with respect to yields. It is the weighted average time until cash flows are received.
 *Settlement and maturity dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays an error message.
@@ Line 88: / Line 88: @@
 == See Also ==
 == References ==