RECEIVED function calculates the amount of return at maturity of fully invested security.
=RECEIVED(settlement, maturity, investment, discount, [basis])
settlement means the settlement date of a security when it is traded to the buyer,
maturity means the maturity date of the security,
investment means the invested amount,
discount is the security’s discount rate, and
[base] is the optional argument which is used to specify the day’s types to be counted:
|Basis||Day count basis|
|0 or omitted||US (NASD) 30/360|
Suppose, you invest $100,000 in a security with the discount rate of 12% at the settlement date of Aug 09, 2017. The security will mature after three years on Aug 09, 2020.
#VALUE! appears if either the supplied argument is non-numeric or supplied settlement and maturity dates are not in Excel format.
#NUM! occures when maturity date is ≤ the settlement date, the basic argument; [base] is not equal to 0, 1, 2, 3 &4.