Freceived()

Description:

The function equals the Excel RECEIVED function.

Syntax:

Freceived(settlement,maturity;inverstment,discount)

Note:

The function returns the amount received at maturity for a security.

Parameters:

settlement

The security's settlement date

maturity

The security's maturity date

investment

The initial amount invested into the security

discount

The security's discount rate

Options

@1

Specify the day count basis method Actual/Actual. It corresponds to the Excel basis parameter.

@0

Specify the day count basis method Actual/360. It corresponds to the Excel basis parameter.

@5

Specify the day count basis method Actual/365. It corresponds to the Excel basis parameter.

@e

Specify the day count basis method European 30/360. It corresponds to the Excel basis parameter.

Example:

Freceived@0(date("2001-2-15"),date("2001-5-15"),1000000,0.0575)

1014420.2658626447

Freceived@5(date("2001-2-15"),date("2001-5-15"),1000000,0.0575)

1014219.9190013407