RECEIVED(S, M, I, D [, B])

 

Description

This function returns the value at maturity of a fully invested security.  Dates must be entered as serial date values.

 

Parameters

 

S

Settlement date, date of purchase.

 

M

Maturity date.

 

I

Investment amount.

 

D

Discount rate.

 

B

Day count basis as follows:

 

 

Examples

 

RECEIVED(DATE(93, 1, 15), DATE(93, 6, 15), , 10000, 12.5%, 1) = 10545.323