TIPS Interest and OID Calculator 5/15/2025

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

Click following link to download: TIPSInterestOID.XLSX