Uses an Excel macro to calculate yield to maturity (YTM) and duration for a portfolio of bonds. Will work with any bonds, but is customized to use outstanding TIPS with latest prices pasted from Wall Street Journal web site. Includes Detail sheet that uses formulas to show how YTM and duration are calculated for one bond. Includes Weight sheet to compute weighted averages for five maturity groups of TIPS.
Change log:
06/25/11: Initial version
10/28/12: Add Weight sheet to compute weighted averages
11/02/12: Add three YTM Sensitivity columns to Weight sheet
04/25/14: Add maturity breakdown of 1+ index
10/24/14: Add 1-10 index
01/23/15: Mod lookup to handle two TIPS maturing on same date
05/01/21: Save as .XLSM instead of .XLS
11/29/24: Update prices and weighting as of 11/29/2024
12/31/24: REPLACED BY TIPS_Index_YTM_Duration.xlsx without macro
Click following link to download now OBSOLETE: YTM_Duration_Macro.XLSM