Manuals/calci/RECEIVED
RECEIVED(settle, M, I, D, basis)
Where 'settle' is the security's settlement date, 'M' is the security's maturity date, 'I' is the amount invested in the security, 'D' is the security's discount rate and 'basis' is the type of day count basis to use.
This function computes the amount received at maturity for a fully invested security.
- RECEIVED shows the error value, when 'settle', 'M' or 'I' is not a valid date or 'I' or 'D' < 0.
- Basis must between 0 and 4.
- RECEIVED computes the error value when settle ≥ M
- RECEIVED is calculated as follows:
where:
B = number of days in a year, depending on the year basis.
DIM = number of days from issue to maturity.
RECEIVED
Lets see an example,
RECEIVED(settle, M, I, D, basis)
B
04-24-2010
07-24-2010
1550000
4.65%
2
=RECEIVED(B2,B3,B4,B5,B6) is 1568230.6817
Syntax
Remarks
Examples
Description
Column1 | Column2 | Column3 | Column4 | |
Row1 | 04-24-2010 | 1568230.6817 | ||
Row2 | 07-24-2010 | |||
Row3 | 1550000 | |||
Row4 | 4.65% | |||
Row5 | 2 | |||
Row6 |