,Received(Settlement, Maturity, Investment, Discount[, Basis])
Settlement. The security's settlement date. This date is later than the issue date (the date, when the securities were sold to the buyer).
Maturity. The security's maturity date. The maturity date is the date when the security expires.
Investment. The amount invested in securities. Parameter value must be greater than zero.
Discount. Discount for a security. Parameter value must be greater than zero.
Basis. The day calculation method used. Select a value from 0 to 4:
0. The day calculation method - American. 360 days (NSAD method). Default value.
1. Day calculation method - Actual/actual.
2. Day calculation method - Actual/360 days.
3. Day calculation method - Actual/365 days.
4. Day calculation method - European 30/360 days.
Optional parameter.
NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.
It returns the amount received at maturity for a fully invested security.
The Settlement parameter value should not be less than the Maturity parameter value.
The agreement date is the date when a coupon (for instance, a bond) was sold to a buyer. Term of payment is the coupon expiration date.
Received is calculated as follows:
,
where:
B. The number of days in a year, it depends on the selected Basis argument value.
DIM. The number of days between the Settlement and Maturity dates.
| Formula | Result | Description |
| =Received("01.01.2008", "01.06.2008", 1500.5, 0.15, 0) | 1600,53 | The amount, which must be received based on the following terms:
|
| =Received("01.01.2008", "01.06.2008", A0, B0) | 1339,53 | The amount, which must be received based on the following terms:
|
See also:
Function Wizard │ Financial Functions │ Intrate