Manuals/calci/INTRATE
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
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.
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.
INTRATE
Lets see an example in (Column1, Row6)
=INTRATE(R1C1, R2C1, R3C1, R4C1, R5C1)
INTRATE returns 1.981651.
Consider another example
=INTRATE(date(1/1/2007),date(2/2/2008),5000,4000,5)
It returns #ERROR.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 11/1/2007 | 0 | 0 | 0 |
| Row2 | 2/20/2008 | 0 | 0 | 0 |
| Row3 | 500000 | 0 | 0 | 0 |
| Row4 | 800000 | 0 | 0 | 0 |
| Row5 | 4 | 0 | 0 | 0 |
| Row6 | 1.981651 | 0 | 0 | 0 |
