WorksheetFunction.IntRate (Excel)

Returns the interest rate for a fully invested security.

The following table describes the values that can be used for Arg5.

IntRate (Arg1, Arg2, ..., Arg5)

Dim dblIntRate As Double
dblIntRate = WorksheetFunction.IntRate(Arg1:=, Arg2:=, Arg3:=, Arg4:=)


Arg1, Arg2, ..., Arg5

Arg1 - Settlement - the security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer

Arg2 - Maturity - the security's maturity date. The maturity date is the date when the security expires

Arg3 - Investment - the amount invested in the security

Arg4 - Redemption - the amount to be received at maturity

Arg5 - Basis - the type of day count basis to use