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

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

settlementThe settlement date of the security.
maturityThe maturity date of the security.
investmentThe amount invested in the security.
discountThe discount rate.
basis(Optional) The type of day counting to use:
0 = US 30/360 (default)
1 = Actual/Actual
2 = Actual/360
3 = Actual/365
4 = European 30/360

Remarks

* The settlement date is the date a buyer purchases a coupon, such as a bond.
* The maturity date is the date when the security expires.
* When a maturity 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.
* In Excel 2003 this function was only available when you had the Analysis ToolPak add-in loaded.
* For the Microsoft documentation refer to support.office.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.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top