{"id":921,"date":"2019-04-22T17:43:54","date_gmt":"2019-04-22T14:43:54","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=921"},"modified":"2019-04-22T17:43:58","modified_gmt":"2019-04-22T14:43:58","slug":"the-received-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-received-function\/","title":{"rendered":"The RECEIVED Function"},"content":{"rendered":"\n

It calculates the amount received at maturity for a fully invested security.<\/p>\n\n\n\n

The syntax of the function is the following: <\/p>\n\n\n\n

RECEIVED<\/strong>(settlement<\/strong>, maturity, investment, discount, [basis]<\/b><\/span><\/em>) <\/p>settlement<\/strong>: The settlement date of the security.
maturity<\/strong>: The maturity date of the security.
investment<\/strong>: The amount invested in the security
discount<\/strong>: The discount rate of the security.
[basis]<\/strong>: Optional. The type of day count basis (default is 0).
<\/cite><\/blockquote>\n\n\n\n

If the dates entered are not valid dates the function returns a #VALUE! error.<\/p>\n\n\n\n

If investment or discount are less than or equal to zero the #NUM! error is returned.<\/p>\n\n\n\n

If basis is not inside the valid values (between 0 and 4) the #NUM! error is returned.<\/p>\n\n\n\n

If the settlement date is after the maturity date the #NUM! error is returned<\/p>\n\n\n\n

<\/div>\n\n\n\n\n
<\/div>\n\n\n\n

Click on the button to practice using this function, with the help of our Online Assessment Tool<\/strong>:<\/p>\n\n\n

Practice<\/a><\/p>\n\n\n\n

<\/div>\n\n\n\n\n

Here is an example of how to use the RECEIVED function:<\/strong><\/p>\n\n\n\n

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.<\/p>\n\n\n\n

\n