Ad
related to: bond duration spreadsheet excelxero.com has been visited by 100K+ users in the past month
Search results
Results From The WOW.Com Content Network
For a standard bond, the Macaulay duration will be between 0 and the maturity of the bond. It is equal to the maturity if and only if the bond is a zero-coupon bond. Modified duration, on the other hand, is a mathematical derivative (rate of change) of price and measures the percentage rate of change of price with respect to yield.
Date through which interest is being accrued. You could word this as the "to" date, with Date1 as the "from" date. For a bond trade, it is the settlement date of the trade. Date3 (Y3.M3.D3) Is the next coupon payment date, usually it is close to Date2. This would be the maturity date if there are no more interim payments to be made.
There is a time dimension to the analysis of bond values. A 10-year bond at purchase becomes a 9-year bond a year later, and the year after it becomes an 8-year bond, etc. Each year the bond moves incrementally closer to maturity, resulting in lower volatility and shorter duration and demanding a lower interest rate when the yield curve is rising.
WAL should not be confused with the following distinct concepts: Bond duration Bond duration is the weighted-average time to receive the discounted present values of all the cash flows (including both principal and interest), while WAL is the weighted-average time to receive simply the principal payments (not including interest, and not discounting).
The HJM framework originates from the work of David Heath, Robert A. Jarrow, and Andrew Morton in the late 1980s, especially Bond pricing and the term structure of interest rates: a new methodology (1987) – working paper, Cornell University, and Bond pricing and the term structure of interest rates: a new methodology (1989) – working paper ...
Main page; Contents; Current events; Random article; About Wikipedia; Contact us
Formally, the duration gap is the difference between the duration - i.e. the average maturity - of assets and liabilities held by a financial entity. [3] A related approach is to see the "duration gap" as the difference in the price sensitivity of interest-yielding assets and the price sensitivity of liabilities (of the organization) to a change in market interest rates (yields).
Microsoft Excel now has by far the dominant position, having overtaken Lotus 1-2-3 in the 1990s. Spreadsheet-based modelling can have its own problems, [10] and several standardizations and "best practices" have been proposed. [11] "Spreadsheet risk" is increasingly studied and managed; [11] see model audit.