RECEIVED

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

Returns the amount received at the end when a security is held to maturity.

settlement	The settlement date of the security.
maturity	The maturity date of the security.
investment	The amount invested in the security.
discount	The discount rate.
basis	(Optional) The type of [[day counting]] to use. 0 = 30/360 (default, US convention) 1 = Actual/Actual 2 = Actual/360 3 = Actual/365 4 = 30/360 (European convention)

REMARKS

* The settlement date is the date a buyer purchases a coupon, such as a bond.
* The "maturity" is the date when the security expires.
* When a security is held to maturity it is often referred to as being "fully invested".
* Dates must be entered as text strings within quotation marks or as serial numbers.
* If "settlement" is not an integer, it is truncated.
* If "settlement" is not a valid date, then #NUM! is returned.
* If "settlement" >= "maturity", then #NUM! is returned.
* If "maturity" is not an integer, it is truncated.
* If "maturity" is not a valid date, then #NUM! is returned.
* If "investment" <= 0, then #NUM! is returned.
* If "discount" <= 0, then #NUM! is returned.
* If "basis" is left blank, then 0 is used.
* If "basis" is not an integer, it is truncated.
* If "basis" < 0, then #NUM! is returned.
* If "basis" > 4, then #NUM! is returned.
* This function is closely related to the INTRATE function.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=RECEIVED("2/15/1999", "5/15/1999", 1000, 0.0575, 2) = #VALUE!

1 - What would the amount be that you receive at maturity if you made an investment of $1,000 with a settlement date of 31 Mar 2011, a maturity date of 30 Sept 2001 and an interest rate of XX (from intrate function). Assuming a day count of 30/360.