The RECEIVED function calculates the amount received at maturity for a fully invested security. The function arguments are:
settlement |
is the settlement date of the security, expressed as a date code |
maturity |
is the maturity date of the security, expressed as a date code |
investment |
is the amount invested in the security |
discount |
is the discount rate of the security |
basis |
is the type of day count basis used, where basis is one of the following: |
Basis |
Day count basis |
0 |
US 30/360 |
1 |
Actual/actual |
2 |
Actual/360 |
3 |
Actual/365 |
4 or omitted |
European 30/360 |
RECEIVED is calculated using the formula:
investment / [1 - (discount * DIM/B)]
Where B is the number of days in a year according to the basis used and DIM is the number of days from issue to maturity.
For example, you have been issued with a bond that comes to maturity on August 31st 1998, the settlement (issue) date is July 15th 1997, the amount invested in the security is $10,000, the discount rate is 4.2%, and the day count basis is actual/actual. Using the formula
RECEIVED(35625, 36037, 10000, 0.042, 1)
returns a total amount received at maturity of $10,497.68.
See also: