TIPS Portfolio Analysis · Alex & Tricia

Upload portfolio file Use the same column layout as tips.xlsx (Fidelity positions export).

Portfolio file (tips.xlsx)

Required columns: Symbol, Quantity, Last Price (real/unadjusted clean price, as quoted), Account Name, Description.

Valuation date

Defaults to the sheet date or today.

BLS API key (optional)

Overrides the built-in 500-calls/day key.

TIPS Positions

Owner / Bond

The account that holds the position and the bond's identity — its real coupon rate, maturity month and year, and 9-character CUSIP. A TIPS coupon is a real rate, paid on top of CPI inflation.

Infl.-Adj. Par

Original face value grown by the CPI index ratio since issuance — the inflation-adjusted principal the Treasury repays at maturity. The green percentage is the cumulative CPI accrual to date.

Mkt Value

Current market value of the position = inflation-adjusted par × clean price ÷ 100. What the holding is worth today at quoted prices.

Real YTM

Real yield to maturity — the annualized return above inflation earned if the bond is held to maturity, solved from its quoted clean price. TIPS pay this on top of CPI inflation.

Break-Even

The annual inflation rate at which this TIPS and a same-maturity nominal Treasury deliver identical total returns (nominal yield − real YTM). If inflation runs above it, the TIPS wins; below it, the nominal bond wins.

TIPS Analysis Dashboard