Difference between revisions of "Manuals/calci/RECEIVED"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000">'''<font face="Arial, sans-serif"><font size="2">RECEIVED(settle, M, I, D, basis)</font></font>''...")
 
 
(5 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000">'''<font face="Arial, sans-serif"><font size="2">RECEIVED(settle, M, I, D, basis)</font></font>'''</font>
+
<div style="font-size:30px">'''RECEIVED (SettlementDate,MaturityDate,Investment,DiscountRate,Basis)'''</div><br/>
 +
*where, <math>SettlementDate</math> is the security's settlement date (a date when coupon or a bond is purchased)
 +
*<math>MaturityDate</math> is the security's maturity date (a date when coupon or a bond expires)
 +
*<math>Investment</math> is the amount invested in security
 +
*<math>DiscountRate</math> is the security's discount rate
 +
*<math>Basis</math> is the type of day count basis to use
 +
**RECEIVED(), returns the amount received at maturity for a fully invested security.
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''Where 'settle''''</font></font><font face="Arial, sans-serif"><font size="2"> is the security's settlement date, 'M' is the security's maturity date, 'I' is the amount invested in the security, 'D' is the security's discount rate and 'basis' is the type of day count basis to use.</font></font></font>
+
== Description ==
  
−
</div>
+
*<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 <math>SettlementDate</math> &gt;= <math>MaturityDate</math>, Calci displays #N/A error message.
−
<div id="1SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif"><font size="2">This function computes the amount received at maturity for a fully invested security.</font></font></font></div>
+
*If <math>Investment</math> &lt;=0 or <math>DiscountRate</math> &lt;=0, Calci displays #N/A error message.
−
----
+
*<math>Basis</math> value is optional. If omitted, Calci assumes it to be 0.
−
<div id="7SpaceContent" class="zcontent" align="left"> 
+
Below table shows the use of <math>Basis</math> values:
  
−
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">RECEIVED shows the error value, when 'settle', 'M' or 'I' is not a valid date or 'I' or 'D' &lt; 0.</font></font></font>
+
{| class="wikitable"
 +
|-
 +
! Basis !! Description
 +
|-
 +
| 0 || US (NASD) 30/360
 +
|-
 +
| 1 || Actual/actual
 +
|-
 +
| 2 || Actual/360
 +
|-
 +
| 3 || Actual/365
 +
|-
 +
| 4 || European 30/365
 +
|}
  
−
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">Basis must between 0 and 4. </font></font></font>
+
*If <math>Basis</math> value is other than 0 to 4, Calci displays #N/A error message.
 +
*Formula:
 +
If 'B' is number of days in a year, and 'D' is number of days from 'Settlement' to
 +
Maturity', the RECEIVED is calculated as -
  
−
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">RECEIVED computes the error value when settle ≥ M</font></font></font>
+
<math>RECEIVED = \frac{Investment}{1-(Discount  X  \frac{D}{B})}</math>
−
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">RECEIVED is calculated as follows: </font></font></font>
 
  
−
<font color="#000000"></font>
+
== Examples ==
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">where:</font></font></font>
+
Consider the following example that shows the use of RECEIVED function:
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">B = number of days in a year, depending on the year basis.</font></font></font>
+
<div id="2SpaceContent" class="zcontent" align="left">
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">DIM = number of days from issue to maturity.</font></font></font>
+
{| id="TABLE3" class="SpreadSheet blue"
 +
|- class="even"
 +
| class=" " | 4/24/2010
 +
| class=" " |
 +
| class=" " | 1/1/2013
  
−
<br /><br />
+
|- class="odd"
 +
| class="sshl_f" | 7/24/2010
 +
| class=" " |
 +
| class=" " | 1/1/2014
  
−
</div>
+
|- class="even"
−
----
+
| class=" " | 1550000
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
+
| class=" " |
 +
| class=" " | 50000
  
−
RECEIVED
+
|- class="odd"
 +
| class=" " | 4.65%
 +
| class=" " |
 +
| class=" " | 6%
  
−
</div></div>
+
|- class="even"
−
----
+
| class=" " | 2
−
<div id="8SpaceContent" class="zcontent" align="left"> 
+
| class=" " |
 +
| class=" " |
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">Lets see an example,</font></font></font>
+
|- class="odd"
 +
| class=" " |
 +
| class=" " |
 +
| class=" " |
 +
|}
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">RECEIVED(settle, M, I, D, basis)</font></font></font>
+
=RECEIVED(A1,A2,A3,A4,A5) displays ''1568435.6540840461'' as a result.
 +
=RECEIVED(C1,C2,C3,C4) displays ''53191.48936170212'' as a result.
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''B'''</font></font></font>
+
==Related Videos==
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">04-24-2010</font></font></font>
+
{{#ev:youtube|I7FDx4DPapw|280|center|BOND AND INTEREST RATE}}
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">07-24-2010</font></font></font>
+
== See Also ==
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">1550000</font></font></font>
+
*[[Manuals/calci/INTRATE | INTRATE]]
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">4.65%</font></font></font>
+
== References ==
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">2</font></font></font>
+
*[http://en.wikipedia.org/wiki/Bond_(finance)#Maturity Maturity]
 +
*[http://en.wikipedia.org/wiki/Day_count_convention Day Count Basis]
  
−
<font color="#000000"><font face="Tahoma, sans-serif"><font size="1"><nowiki>=RECEIVED(B2,B3,B4,B5,B6) is 1568230.6817</nowiki></font></font></font>
 
  
−
</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"
+
*[[Z_API_Functions | List of Main Z Functions]]
−
|- class="even"
 
−
| class=" " |
 
−
| Column1
 
−
| class="  " | Column2
 
−
| Column3
 
−
| Column4
 
−
|- class="odd"
 
−
| class=" " | Row1
 
−
| class="sshl_f" | 04-24-2010
 
−
| class="sshl_f" | 1568230.6817
 
−
| class="                                      " |
 
−
| class="                                      sshl_f  " |
 
−
|- class="even"
 
−
| class="  " | Row2
 
−
| class="sshl_f" | 07-24-2010
 
−
| class="                                                            sshl_f  " |
 
−
| class="  SelectTD  SelectTD" |
 
−
<div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
 
−
| class=" " |
 
−
|- class="odd"
 
−
| Row3
 
−
| class="sshl_f" | 1550000
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="even"
 
−
| Row4
 
−
| class="sshl_f" | 4.65%
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
| class="sshl_f" | 2
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="even"
 
−
| Row6
 
−
| class="                        sshl_f  " |
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
|}
 
  
−
<div align="left">[[Image:calci1.gif]]</div></div>
+
*[[ Z3 |  Z3 home ]]
−
----
 

Latest revision as of 16:24, 22 August 2018

RECEIVED (SettlementDate,MaturityDate,Investment,DiscountRate,Basis)


  • where, is the security's settlement date (a date when coupon or a bond is purchased)
  • is the security's maturity date (a date when coupon or a bond expires)
  • is the amount invested in security
  • is the security's discount rate
  • is the type of day count basis to use
    • RECEIVED(), returns the amount received at maturity for a fully invested security.

Description

  • 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 MaturityDate} 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 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 SettlementDate} >= 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 MaturityDate} , Calci displays #N/A error message.
  • 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 Investment} <=0 or 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 DiscountRate} <=0, 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/365
  • 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.
  • Formula:

If 'B' is number of days in a year, and 'D' is number of days from 'Settlement' to Maturity', the RECEIVED is calculated as -

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 RECEIVED = \frac{Investment}{1-(Discount X \frac{D}{B})}}

Examples

Consider the following example that shows the use of RECEIVED function:

4/24/2010 1/1/2013
7/24/2010 1/1/2014
1550000 50000
4.65% 6%
2 
=RECEIVED(A1,A2,A3,A4,A5) displays 1568435.6540840461 as a result.
=RECEIVED(C1,C2,C3,C4) displays 53191.48936170212 as a result.

Related Videos

BOND AND INTEREST RATE

See Also

References


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