INTRATE(S, M, I, R [, B])

 

Description

This function returns the interest rate for a fully invested investment.

 

Parameters

 

S

Settlement date, date of purchase.

 

M

Maturity date.

 

I

Investment amount.

 

R

Redemption amount.

 

B

(Optional)  Day count basis as follows:

 

 

Examples

 

INTRATE(DATE(93, 1, 15), DATE(93, 6, 15), 10000, 10545) = 0.1317