TIPS Ladder Builder 1/24/2025

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

Change log:
04/02/11: First released
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
02/22/15: Lookup from WSJ sheet using maturity + coupon, not just maturity
07/29/16: Save as .XLSX instead of .XLS
09/02/18: Completely restructure calculations & include accrued interest
11/30/20: Add ToPaste sheet
11/18/22: Add Yearly sheet
07/05/23: Add XIRR sheet
02/02/24: Evenly apportion later bond interest when >= 2 TIPS chosen for same year
02/04/24: Expand XIRR & ToPaste sheets to handle up to 50 TIPS
10/07/24: Add option to display Buy or Sell or Already Held on XIRR, ToPaste, & Yearly sheets
10/14/24: Fix prorating of other interest when more than one TIPS selected in same year
11/09/24: Add option to Ignore Multiplier or Already Held without having to blank the columns
11/29/24: Add pseudo bond maturing year before gap as duplicate of 2/15/2040 maturity
12/06/24: Add hidden CPI sheet & calc two Ref CPIs so don't have to enter them
01/17/25: Remove 2025 maturities and add rows for assumed 5 new issues in 2025
01/24/25: Update with WSJ Friday 1/24/2025 quotes

Click following link to download: TIPSLadder.XLSX