TIPS Ladder Builder 2/19/2017

Helps build a ladder of TIPS taking into account interest received each year on TIPS maturing in the future.

TIPS Ladder

Change log:
04/06/12: Add Already Held, Buy, & Sell columns for # of Bonds and Bond Value
08/03/14: Replace Years to Cover with Multiplier for added flexibility & remove Already Held
08/04/14: Add wtd avg maturity & add back Already Held column
02/22/15: Lookup from WSJ sheet using maturity + coupon, not just maturity
07/29/16: Add IRR sheet to show Internal Rate of Return
07/29/16: Save as .XLSX instead of .XLS
02/19/17: Add 2 TIPS issued Jan & Feb 2017 & update for prices 2/17/2017


Click following link to download: TIPSLadder.XLSX