Difference between revisions of "Manuals/calci/YIELDDISC"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''YIELDDISC'''(SettlementDate, MaturityDate, Price, Redemption, Basis) where, '''SettlementDate''' - represe...") |
|||
| Line 1: | Line 1: | ||
| − | + | =YIELDDISC(settlement, maturity, price, redemption, 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>price</math> is the price per $100 face value, | ||
| + | *<math>redemption</math> is security's redemption value per $100 face value, | ||
| + | *<math>basis</math> is the type of day count basis to use. | ||
| − | + | YIELDDISC() calculates the annual yield on discounted security or a bond. | |
| − | + | == Description == | |
| − | + | YIELDDISC(settlement, maturity, price, redemption, basis) | |
| − | ''' | + | *YIELDDISC referred to as 'Discount Yield' is the measure of security's percentage return. |
| − | + | Formula:- | |
| − | + | <math>Discount Yield = \frac{(par value - price)}{par value} * \frac{360}{days to maturity}</math> | |
| − | ''' | + | *<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>settlement</math> date = <math>maturity</math> date, Calci displays #N/A error message. | ||
| + | *<math>price</math> and <math>redemption</math> values 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: | ||
| − | 0 | + | {| class="wikitable" |
| + | |- | ||
| + | ! Basis !! Description | ||
| + | |- | ||
| + | | 0 || US (NASD) 30/360 | ||
| + | |- | ||
| + | | 1 || Actual/actual | ||
| + | |- | ||
| + | | 2 || Actual/360 | ||
| + | |- | ||
| + | | 3 || Actual/365 | ||
| + | |- | ||
| + | | 4 || European 30/360 | ||
| + | |} | ||
| − | + | *If <math>basis</math> value is other than 0 to 4, Calci displays #N/A error message. | |
| − | + | == Examples == | |
| − | + | YIELDDISC(settlement, maturity, price, redemption, basis) function with inputs in order is calculated as follows: | |
| − | + | <div id="2SpaceContent" class="zcontent" align="left"> | |
| − | + | {| id="TABLE3" class="SpreadSheet blue" | |
| − | - | + | |- class="even" |
| − | + | | class="sshl_f" | 1/1/2008 | |
| + | | class="sshl_f" | | ||
| − | + | |- class="odd" | |
| + | | class="sshl_f" | 20/2/2008 | ||
| + | | class="sshl_f" | | ||
| − | + | |- class="even" | |
| − | - | + | | class="sshl_f" | 95.58 |
| − | + | | class="sshl_f" | | |
| − | + | |- class="odd" | |
| + | | class="sshl_f" | $100 | ||
| + | | class="sshl_f" | | ||
| − | + | |- class="even" | |
| + | | class="sshl_f" | 2 | ||
| + | | class="sshl_f" | | ||
| − | + | |} | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | =YIELDDISC(A1,A2,A3,A4,A5) : Calculates the discount yield Value with the inputs in the range A1 to A5. Returns '''33.3%''' as a result. | |
| + | =YIELDDISC(DATE(2007,1,1), DATE(2008,2,20), 85.12, 100) : Calculates the discount yield Value with the inputs. Returns '''15.39%''' as a result. | ||
| − | + | == See Also == | |
| − | + | *[[Manuals/calci/YIELD | YIELD]] | |
| + | *[[Manuals/calci/YIELDMAT | YIELDMAT]] | ||
| − | + | == References == | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | *[http://en.wikipedia.org/wiki/Yield_(finance) Yield] | |
| − | + | *[http://en.wikipedia.org/wiki/Discounting Discount Yield] | |
| + | *[http://en.wikipedia.org/wiki/Day_count_convention Basis Convention] | ||
Revision as of 07:24, 4 February 2014
YIELDDISC(settlement, maturity, price, redemption, basis)
- where is security's settlement date (a date when coupon or a bond is purchased),
- is security's maturity date (a date when coupon or a bond expires),
- is the price per $100 face value,
- is security's redemption value per $100 face value,
- is the type of day count basis to use.
is security's settlement date (a date when coupon or a bond is purchased),
is security's maturity date (a date when coupon or a bond expires),
is the price per $100 face value,
is security's redemption value per $100 face value,
is the type of day count basis to use.YIELDDISC() calculates the annual yield on discounted security or a bond.
Description
YIELDDISC(settlement, maturity, price, redemption, basis)
- YIELDDISC referred to as 'Discount Yield' is the measure of security's percentage return.
Formula:-
- and 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 date = date, Calci displays #N/A error message.
- and values must be greater than zero, else Calci displays #N/A error message.
- value is optional. If omitted, Calci assumes it to be 0.
Below table shows the use of values:
| Basis | Description |
|---|---|
| 0 | US (NASD) 30/360 |
| 1 | Actual/actual |
| 2 | Actual/360 |
| 3 | Actual/365 |
| 4 | European 30/360 |
- If value is other than 0 to 4, Calci displays #N/A error message.
Examples
YIELDDISC(settlement, maturity, price, redemption, basis) function with inputs in order is calculated as follows:
| 1/1/2008 | |
| 20/2/2008 | |
| 95.58 | |
| $100 | |
| 2 |
=YIELDDISC(A1,A2,A3,A4,A5) : Calculates the discount yield Value with the inputs in the range A1 to A5. Returns 33.3% as a result. =YIELDDISC(DATE(2007,1,1), DATE(2008,2,20), 85.12, 100) : Calculates the discount yield Value with the inputs. Returns 15.39% as a result.