RECEIVED

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 = 30/360 (default)
1 = Actual/Actual
2 = Actual/360
3 = Actual/365
4 = 30E/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.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.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.

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