RECEIVED Function Explained
The RECEIVED function in Microsoft Excel returns the amount received after a present value discount is applied. It takes three arguments: present_value, discount_rate, and discount_period. The present_value is the amount of money to be discounted, the discount_rate is the rate of discount over a period of time, and the discount_period is the length of time over which the discount is applied.
RECEIVED Function Syntax
RECEIVED(settlement, maturity, investment, discount, [basis])
- settlement: The security’s settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.
- maturity: The security’s maturity date. The maturity date is the date when the security expires.
- investment: The amount invested in the security.
- discount: The security’s discount rate.
- [basis]: Optional. The type of day count basis to use. If omitted, it defaults to 0.