Manuals/calci/INTRATE - Revision history

Devika at 22:18, 22 August 2018

2018-08-22T22:18:13Z

Devika at 22:17, 29 June 2018

2018-06-29T22:17:36Z

Jayaram at 10:51, 14 March 2017

2017-03-14T10:51:36Z

Swapna at 18:31, 28 April 2015

2015-04-28T18:31:22Z

Swapna at 12:56, 4 January 2014

2014-01-04T12:56:55Z

Swapna at 22:22, 3 January 2014

2014-01-03T22:22:01Z

Swapna at 22:20, 3 January 2014

2014-01-03T22:20:56Z

Swapna at 22:17, 3 January 2014

2014-01-03T22:17:52Z

Show changes

MassBot1: Created page with "
'''INTRATE'''(SettlementDate, MaturityDate, Investment,Redemption,Basis) where, '''SettlementDate''' - repres..."

2013-10-25T02:38:09Z

Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''INTRATE'''(SettlementDate, MaturityDate, Investment,Redemption,Basis) where, '''SettlementDate''' - repres..."

New page

<div id="6SpaceContent" class="zcontent" align="left">

'''INTRATE'''(SettlementDate, MaturityDate, Investment,Redemption,Basis)

where,

'''SettlementDate''' - represents the settlement date.

'''MaturityDate''' - represents the maturity date.

'''Investment''' - the amount to be invested.

'''Redemption''' - the amount to be received at maturity.

'''Basis''' - type of day count basis

'''Basis              Day count basis'''

0 or omitted    US 30/360

1                     Actual/actual

2                     Actual/360

3                     Actual/365

4                     European 30/360

</div>
----
<div id="1SpaceContent" class="zcontent" align="left">

It returns the interest rate for a invested.

'''Formula''':-

INTRATE =(Redemption-Investment)/Investment x( T/D)

where,

T - number of days in a year, according on the year basis.

D - number of days from settlement to maturity.

</div>
----
<div id="7SpaceContent" class="zcontent" align="left">

If Basis < 0 or Basis > 4 , INTRATE returns the #ERROR.

If Investment <= 0 or Redemption <= 0, it

returns the#ERROR.

If SettlementDate >= MaturityDate, INTRATE returns #ERRROR.

</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">

INTRATE

</div></div>
----
<div id="8SpaceContent" class="zcontent" align="left">

Lets see an example in (Column1, Row6)

<nowiki>=INTRATE(R1C1, R2C1, R3C1, R4C1, R5C1)</nowiki>

INTRATE returns 1.981651.

Consider another example

<nowiki>=INTRATE(date(1/1/2007),date(2/2/2008),5000,4000,5)</nowiki>

It returns #ERROR.

</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=" " | 11/1/2007
| 0
| 0
| 0
|- class="even"
| class=" " | Row2
| class=" " | 2/20/2008
| 0
| 0
| 0
|- class="odd"
| Row3
| class=" " | 500000
| 0
| 0
| 0
|- class="even"
| Row4
| class=" " | 800000
| 0
| 0
| 0
|- class="odd"
| class=" " | Row5
| class="sshl_f " | 4
| 0
| 0
| 0
|- class="even"
| Row6
| class="sshl_f" | 1.981651
| 0
| 0
| 0
|}

<div align="left">[[Image:calci1.gif]]</div></div>
----

@@ Line 5: / Line 5: @@
 *<math>RedemptionValue</math> is the amount to be received at maturity of a bond
 *<math>Basis</math> is the type of day count basis to use
+**INTRATE(), returns the interest rate for a fully invested security.
 == Description ==

@@ Line 1: / Line 1: @@
-=INTRATE(SettlementDate, MaturityDate, Investment, Redemption, Basis)=
+<div style="font-size:30px">'''INTRATE (SettlementDate,MaturityDate,Investment,RedemptionValue,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 the security or a bond
-*<math>Redemption</math> is the amount to be received at maturity of a bond
+*<math>RedemptionValue</math> is the amount to be received at maturity of a bond
 *<math>Basis</math> is the type of day count basis to use
-INTRATE() calculates the interest rate for a fully invested security.
+INTRATE(), returns the interest rate for a fully invested security.
 == Description ==
-INTRATE(SettlementDate, MaturityDate, Investment, Redemption, Basis)
+INTRATE(SettlementDate, MaturityDate, Investment,RedemptionValue, Basis)
 *<math>SettlementDate</math> and <math>MaturityDate</math> 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.
-*If <math>Investment</math> &lt;=0 or <math>Redemption</math> &lt;=0, Calci displays #N/A error message.
+*If <math>Investment</math> &lt;=0 or <math>RedemptionValue</math> &lt;=0, 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:

← Older revision		Revision as of 10:51, 14 March 2017
Line 95:		Line 95:
	*[http://en.wikipedia.org/wiki/Interest_rate_derivative Interest Rate Derivative]		*[http://en.wikipedia.org/wiki/Interest_rate_derivative Interest Rate Derivative]
	*[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 82: / Line 82: @@
   =INTRATE(A1,A2,A3,A4,A5) displays ''1.981651376146789'' as a result.
   =INTRATE(DATE(2013,1,1),B2,B3,B4,B5) displays ''0.2622154311211943'' as a result.
 == See Also ==

@@ Line 39: / Line 39: @@
 maturity', then INTRATE is calculated as -
-<math>INTRATE = \frac{(redemption-investment)}{investment} X \frac{B}{DIM}</math>
+<math>INTRATE = \frac{(redemption-investment)}{investment} X \frac{B}{D}</math>
 == Examples ==

@@ Line 39: / Line 39: @@
 maturity', then INTRATE is calculated as -
-INTRATE = <math>\frac{\(redemption-investment)}{investment} X \frac{\B}{DIM}</math>
+INTRATE = <math>\frac{(redemption-investment)}{investment} x \frac{B}{DIM}</math>
 == Examples ==
-Consider the following example that shows the use of DURATION function:
+Consider the following example that shows the use of INTRATE function:
 <div id="2SpaceContent" class="zcontent" align="left">