RECEIVED(settlement, maturity, investment, discount, basis)

The RECEIVED function calculates the amount received at maturity for a fully invested security. The function arguments are:

settlement

is the settlement date of the security, expressed as a date code

maturity

is the maturity date of the security, expressed as a date code

investment

is the amount invested in the security

discount

is the discount rate of the security

basis

is the type of day count basis used, where basis is one of the following:

Basis

Day count basis

0

US 30/360

1

Actual/actual

2

Actual/360

3

Actual/365

4 or omitted

European 30/360

RECEIVED is calculated using the formula:

investment / [1 - (discount * DIM/B)]

Where B is the number of days in a year according to the basis used and DIM is the number of days from issue to maturity.

For example, you have been issued with a bond that comes to maturity on August 31st 1998, the settlement (issue) date is July 15th 1997, the amount invested in the security is $10,000, the discount rate is 4.2%, and the day count basis is actual/actual. Using the formula

RECEIVED(35625, 36037, 10000, 0.042, 1)

returns a total amount received at maturity of $10,497.68.

See also:

Other financial functions