The free guide

RECEIVED function

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
1 Actual/actual
2 Actual/360
3 Actual/365
4 European 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.



Common Errors

#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.

Copyright © 2016 - 2017 | All Rights Reserved