RECEIVED(settlement,maturity,investment,rate[,basis])
RECEIVED calculates and returns the amount to be received at maturity date for a security bond.
settlement is the settlement date of the security. maturity is the maturity date of the security. The amount of investment is specified in investment. rate is the security's discount rate.
basis is the type of day counting system you want to use:
0 US 30/360
1 actual days/actual days
2 actual days/360
3 actual days/365
4 European 30/360