A fully invested security does not pay periodic interest before maturity.
The interest income is the difference between the redemption value of the security and the original investment.
The settlement date is 6-Jul-2017 and the maturity date is 15-Jan-2020.
There are no periodic interest payments, and the day count basis is US (NASD) 30/360.
Entering dates
In Excel,dates are serial numbers.
To enter valid dates directly inside a function, you’ve got the option to use theDATE function.
The INTRATE function allows 5 options (0-4) and defaults to zero, which specifies US 30/360basis.
Thisarticle on wikipediaprovides a detailed explanation of available conventions.
