Kornilios Ampatzis/ April 22, 2019/ Functions

It calculates the amount received at maturity for a fully invested security.

The syntax of the function is the following:

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

settlement: The settlement date of the security.
maturity: The maturity date of the security.
investment: The amount invested in the security
discount: The discount rate of the security.
[basis]: Optional. The type of day count basis (default is 0).

If the dates entered are not valid dates the function returns a #VALUE! error.

If investment or discount are less than or equal to zero the #NUM! error is returned.

If basis is not inside the valid values (between 0 and 4) the #NUM! error is returned.

If the settlement date is after the maturity date the #NUM! error is returned

Click on the button to practice using this function, with the help of our Online Assessment Tool:

Practice

Here is an example of how to use the RECEIVED function:

Use the proper function in the cell C2, to calculate the amount received at maturity for a fully invested security. All the information you need is displayed in the current worksheet.

Share this Post