Manuals/calci/YIELDMAT - Revision history

Devika: /* Related Videos */

2018-11-16T21:10:24Z

Devika at 22:33, 22 August 2018

2018-08-22T22:33:20Z

Devika: /* Description */

2018-08-01T21:52:43Z

Description

Devika at 21:51, 1 August 2018

2018-08-01T21:51:39Z

Jayaram at 11:10, 14 March 2017

2017-03-14T11:10:25Z

Swapna at 19:07, 19 July 2015

2015-07-19T19:07:54Z

Swapna at 12:32, 4 February 2014

2014-02-04T12:32:49Z

Swapna at 12:31, 4 February 2014

2014-02-04T12:31:27Z

Swapna at 12:26, 4 February 2014

2014-02-04T12:26:14Z

Swapna at 22:11, 3 February 2014

2014-02-03T22:11:55Z

@@ Line 75: / Line 75: @@
 ==Related Videos==
-{{#ev:youtube|71rSmeDslAg|280|center|YIELDMAT}}
+{{#ev:youtube|v=bch4k9RznVk|280|center|YIELDMAT}}
 == See Also ==

@@ Line 7: / Line 7: @@
 *<math>Price</math> is the price per $100 face value,
 *<math>Basis</math> is the type of day count basis to use.
 **YIELDMAT(), returns the annual yield of a security that pays interest at maturity.

@@ Line 20: / Line 20: @@
 *<math>Price</math> value must be greater than zero, else Calci displays #N/A error message.
 *<math>Basis</math> value is optional. If omitted, Calci assumes it to be 0.
-Below table shows the use of <math>basis</math> values:
+Below table shows the use of <math>Basis</math> values:
 {| class="wikitable"

@@ Line 1: / Line 1: @@
-=YIELDMAT(settlement, maturity, issue, rate, price, basis)=
+<div style="font-size:30px">'''YIELDMAT (Settlement,Maturity,Issue,Rate,Price,Basis)'''</div><br/>
-*where <math>settlement</math> is security's settlement date (a date when coupon or a bond is purchased),
+*where <math>Settlement</math> is security's settlement date (a date when coupon or a bond is purchased),
-*<math>maturity</math> is security's maturity date (a date when coupon or a bond expires),
+*<math>Maturity</math> is security's maturity date (a date when coupon or a bond expires),
-*<math>issue</math> is security's issue date (a date when coupon or a bond is issued),
+*<math>Issue</math> is security's issue date (a date when coupon or a bond is issued),
-*<math>rate</math> is security's annual coupon rate,
+*<math>Rate</math> is security's annual coupon rate,
-*<math>price</math> is the price per $100 face value,
+*<math>Price</math> is the price per $100 face value,
-*<math>basis</math> is the type of day count basis to use.
+*<math>Basis</math> is the type of day count basis to use.
-YIELDMAT() calculates the annual yield on a security or a bond that pays interest at maturity.
+**YIELDMAT(), returns the annual yield of a security that pays interest at maturity.
 == Description ==
-YIELDMAT(settlement, maturity, issue, rate, price, basis)
+YIELDMAT (Settlement,Maturity,Issue,Rate,Price,Basis)
 *YIELDMAT is the percentage annual yield on security that pays interest at maturity.
-*<math>settlement</math>, <math>maturity</math> and <math>issue</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>, <math>Maturity</math> and <math>Issue</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.
-*Dates should satisfy the following condition:- <math>maturity</math> &gt; <math>settlement</math> &gt; <math>issue</math>, else Calci displays #N/A error message.
+*Dates should satisfy the following condition:- <math>Maturity</math> &gt; <math>Settlement</math> &gt; <math>Issue</math>, else Calci displays #N/A error message.
-*<math>rate</math> value must be greater than or equal to zero, else Calci displays #N/A error message.
+*<math>Rate</math> value must be greater than or equal to zero, else Calci displays #N/A error message.
-*<math>price</math> value must be greater than zero, else Calci displays #N/A error message.
+*<math>Price</math> value must be greater than zero, else Calci displays #N/A error message.
-*<math>basis</math> 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 <math>basis</math> values:
@@ Line 37: / Line 37: @@
 |}
-*If <math>basis</math> 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 ==
+YIELDMAT (Settlement,Maturity,Issue,Rate,Price,Basis) function with inputs in order is calculated as follows:
 <div id="2SpaceContent" class="zcontent" align="left">

← Older revision		Revision as of 11:10, 14 March 2017
Line 89:		Line 89:
	*[http://en.wikipedia.org/wiki/Yield_to_maturity Yield to Maturity]		*[http://en.wikipedia.org/wiki/Yield_to_maturity Yield to Maturity]
	*[http://en.wikipedia.org/wiki/Day_count_convention Basis Convention]		*[http://en.wikipedia.org/wiki/Day_count_convention Basis Convention]
		+
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

← Older revision		Revision as of 19:07, 19 July 2015
Line 74:		Line 74:

	=YIELDMAT(DATE(2007,1,1), DATE(2008,2,20), DATE(2006,10,15), "5%", 100) : Calculates the percentage annual yield with the inputs. <br />Returns '''4.95%''' as a result.		=YIELDMAT(DATE(2007,1,1), DATE(2008,2,20), DATE(2006,10,15), "5%", 100) : Calculates the percentage annual yield with the inputs. <br />Returns '''4.95%''' as a result.
		+
		+	==Related Videos==
		+
		+	{{#ev:youtube\|71rSmeDslAg\|280\|center\|YIELDMAT}}

	== See Also ==		== See Also ==

@@ Line 73: / Line 73: @@
   =YIELDMAT(A1,A2,A3,A4,A5,A6) : Calculates the percentage annual yield with the inputs in the range A1 to A6. Returns '''5.47%''' as a result.
-  =YIELDMAT(DATE(2007,1,1), DATE(2008,2,20), DATE(2006,10,15), "5%", 100) : Calculates the percentage annual yield with the inputs. Returns '''4.95%''' as a result.
+  =YIELDMAT(DATE(2007,1,1), DATE(2008,2,20), DATE(2006,10,15), "5%", 100) : Calculates the percentage annual yield with the inputs. <br />Returns '''4.95%''' as a result.
 == See Also ==

← Older revision		Revision as of 12:31, 4 February 2014
Line 72:		Line 72:

	=YIELDMAT(A1,A2,A3,A4,A5,A6) : Calculates the percentage annual yield with the inputs in the range A1 to A6. Returns '''5.47%''' as a result.		=YIELDMAT(A1,A2,A3,A4,A5,A6) : Calculates the percentage annual yield with the inputs in the range A1 to A6. Returns '''5.47%''' as a result.
		+
		+	=YIELDMAT(DATE(2007,1,1), DATE(2008,2,20), DATE(2006,10,15), "5%", 100) : Calculates the percentage annual yield with the inputs. Returns '''4.95%''' as a result.

	== See Also ==		== See Also ==