View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Yieldmat function

Based on MS Help, the rate and term are based on date of issue (not date of
settlement). So, if the security was issues on 1/1/08 on a 30 year bond, the
maturity date is 1/1/38, regardless of settlement date.

"BarryHWhite" wrote:

Why does Yieldmat include an issue date ?
The yield to maturity should be from the settlement date to the maturity
date, subject to the rate of interest and the price of the bond

It does not matter when in the past it was issued

However I see that changing the issue date changes the yield to maturity

Help please