TIPS Interest and OID Calculator 5/30/2026

Calculates interest and Original Issue Discount (OID), the inflation adjustment, for one year for a portfolio of TIPS.

Change log:
01/22/12: Initially prepared
08/24/14: Added complete daily Ref CPI table so can display any year since 1997
04/20/16: Add Total OID column
11/18/17: Saved in more compact .XLSX format instead of .XLS
08/22/19: Add calc of principal value & accrued interest on a given date
08/27/23: Add WSJ sheet so can calc market value
08/27/23: Add Bid Price, Mkt Val, and Incl Int columns on main sheet
11/13/24: Add Oct 2024 CPI, update WSJ Quotes
03/13/25: Replace daily RefCPI sheet with monthly CPI sheet to save space
05/15/25: Add Weeds sheet to show how Ref CPI now calculated
11/27/25: Use original BLS CPI values Jan-Aug 2000, not the revised BLS values
05/30/26: Remove Weeds sheet, decided was confusing.
05/30/26: Update CPI thru April 2026, include 5/29/2026 WSJ Quotes

Click following link to download: TIPSInterestOID.XLSX