TIPS Interest and OID Calculator 11/10/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
03/13/25: Replace daily RefCPI sheet with monthly CPI sheet to save space
11/27/25: Use original BLS CPI values Jan-Aug 2000, not the revised BLS values
05/31/26: Add accrued interest for purchases and sales before maturity.
11/10/26: Update CPI thru Oct 2026 and WSJ quotes to 11/10/2026.

Click following link to download: TIPSInterestOID.XLSX