Difference between revisions of "Manuals/calci/YIELDMAT"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''YIELDMAT'''(SettlementDate, MaturityDate, IssueDate, Rate, Price, Basis) where, '''SettlementDate''' - rep...")
 
 
(10 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''YIELDMAT (Settlement,Maturity,Issue,Rate,Price,Basis)'''</div><br/>
  
−
'''YIELDMAT'''(SettlementDate, MaturityDate, IssueDate, Rate, Price, Basis)
+
*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>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>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.
  
−
where,
+
== Description ==
  
−
'''SettlementDate''' - represents the settlement date.
+
YIELDMAT (Settlement,Maturity,Issue,Rate,Price,Basis)
  
−
'''MaturityDate''' - represents the maturity date.
+
*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.
 +
*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>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:
  
−
'''IssueDate -''' represents the issue date.
+
{| class="wikitable"
 +
|-
 +
! Basis !! Description
 +
|-
 +
| 0 || US (NASD) 30/360
 +
|-
 +
| 1 || Actual/actual
 +
|-
 +
| 2 || Actual/360
 +
|-
 +
| 3 || Actual/365
 +
|-
 +
| 4 || European 30/360
 +
|}
  
−
'''Rate''' - represents the  rate.
+
*If <math>Basis</math> value is other than 0 to 4, Calci displays #N/A error message.
  
−
'''Price''' - represents the price per $100 face value.
+
== Examples ==
 +
YIELDMAT (Settlement,Maturity,Issue,Rate,Price,Basis) function with inputs in order is calculated as follows:
  
−
'''Basis''' - type of day count basis
+
<div id="2SpaceContent" class="zcontent" align="left">
  
−
'''Basis              Day count basis'''
+
{| id="TABLE3" class="SpreadSheet blue"
 +
|- class="even"
 +
| class="sshl_f" | 1/2/2010
 +
| class="sshl_f" |
  
−
0 or omitted    US 30/360
+
|- class="odd"
 +
| class="sshl_f" | 1/2/2012
 +
| class="sshl_f" |
  
−
1                     Actual/actual
+
|- class="even"
 +
| class="sshl_f" | 12/1/2009
 +
| class="sshl_f" |
  
−
2                     Actual/360
+
|- class="odd"
 +
| class="sshl_f" | 5.5%
 +
| class="sshl_f" |
  
−
3                     Actual/365
+
|- class="even"
 +
| class="sshl_f" | $100
 +
| class="sshl_f" |
  
−
4                     European 30/360
+
|- class="odd"
−
 
+
| class="sshl_f" | 0
−
</div>
+
| class="sshl_f" |
−
----
+
|}
−
<div id="1SpaceContent" class="zcontent" align="left">
 
−
 
 
−
It returns the annual yield that pays interest at maturity.
 
  
−
</div>
+
=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.
−
----
 
−
<div id="7SpaceContent" class="zcontent" align="left">
 
  
−
If Basis &lt; 0 or Basis &gt; 4 , YIELDMAT returns the #ERROR.
+
=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.
  
−
If  Rate &lt; 0 or Price &lt;= 0, it returns the #ERROR.
+
==Related Videos==
  
−
If SettlementDate &gt;= MaturityDate, YIELDMAT returns #ERROR.
+
{{#ev:youtube|v=bch4k9RznVk|280|center|YIELDMAT}}
  
−
</div>
+
== See Also ==
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
−
YIELDMAT
+
*[[Manuals/calci/YIELD| YIELD]]
 +
*[[Manuals/calci/YIELDDISC | YIELDDISC]]
  
−
</div></div>
+
== References ==
−
----
 
−
<div id="8SpaceContent" class="zcontent" align="left">
 
  
−
Lets see an example in (Column1, Row6)
+
*[http://en.wikipedia.org/wiki/Yield_(finance) Yield]
 +
*[http://en.wikipedia.org/wiki/Yield_to_maturity Yield to Maturity]
 +
*[http://en.wikipedia.org/wiki/Day_count_convention Basis Convention]
  
−
<nowiki>=YIELDMAT(R1C1, R2C1, R3C1, R4C1, R5C1)</nowiki>
 
  
−
YIELDMAT returns 1.651036.
 
  
−
Consider another example
 
  
−
<nowiki>=YIELDMATdate(2007,1,1), date(2008,2,20),DATE(2007,5,5),"6.34%" 85.12,5)</nowiki>
+
*[[Z_API_Functions | List of Main Z Functions]]
−
 
 
−
It returns #ERROR(Basis=5).
 
−
 
 
−
</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>
 
−
----
 
−
<div id="2SpaceContent" class="zcontent" align="left">
 
−
 
 
−
{| id="TABLE3" class="SpreadSheet blue"
 
−
|- class="even"
 
−
| class=" " |
 
−
| class="  " | Column1
 
−
| class=" SelectTD ChangeBGColor SelectTD" |
 
−
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]]  </div>Column2
 
−
| Column3
 
−
| Column4
 
−
|- class="odd"
 
−
| class=" " | Row1
 
−
| class=" " | 1/1/2008
 
−
|
 
−
|
 
−
|
 
−
|- class="even"
 
−
| class="  " | Row2
 
−
| class=" " | 2/20/2008
 
−
|
 
−
|
 
−
|
 
−
|- class="odd"
 
−
| Row3
 
−
| class=" " | 2/2/2007
 
−
|
 
−
|
 
−
|
 
−
|- class="even"
 
−
| Row4
 
−
| class=" " | 8.25%
 
−
|
 
−
|
 
−
|
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
| class=" " | 80.855
 
−
|
 
−
|
 
−
|
 
−
|- class="even"
 
−
| class="sshl_f" | Row6
 
−
| class="sshl_f " | 2
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|- class="odd"
 
−
| class="sshl_f" | Row7
 
−
| class="sshl_f" | 1.651036
 
−
|
 
−
|
 
−
|
 
−
|}
 
  
−
<div align="left">[[Image:calci1.gif]]</div></div>
+
*[[ Z3 |  Z3 home ]]
−
----
 

Latest revision as of 15:10, 16 November 2018

YIELDMAT (Settlement,Maturity,Issue,Rate,Price,Basis)


  • where Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Settlement} is security's settlement date (a date when coupon or a bond is purchased),
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Maturity} is security's maturity date (a date when coupon or a bond expires),
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Issue} is security's issue date (a date when coupon or a bond is issued),
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Rate} is security's annual coupon rate,
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Price} is the price per $100 face value,
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Basis} is the type of day count basis to use.
    • YIELDMAT(), returns the annual yield of a security that pays interest at maturity.

Description

YIELDMAT (Settlement,Maturity,Issue,Rate,Price,Basis)

  • YIELDMAT is the percentage annual yield on security that pays interest at maturity.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Settlement} , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Maturity} and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Issue} 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:- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Maturity} > Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Settlement} > Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Issue} , else Calci displays #N/A error message.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Rate} value must be greater than or equal to zero, else Calci displays #N/A error message.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Price} value must be greater than zero, else Calci displays #N/A error message.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Basis} value is optional. If omitted, Calci assumes it to be 0.

Below table shows the use of Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Basis} values:

Basis Description
0 US (NASD) 30/360
1 Actual/actual
2 Actual/360
3 Actual/365
4 European 30/360
  • If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Basis} 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:

1/2/2010
1/2/2012
12/1/2009
5.5%
$100
0 
=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.

Related Videos

YIELDMAT

See Also

References



Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/YIELDMAT&oldid=211355"