Bond Trading ModelFree Financial Model Download

A bond trading desk model tracks fixed income positions, calculates mark-to-market P&L, Greeks (duration, convexity, DV01, key rate durations), and scenario analysis to support daily P&L reporting, risk monitoring, and inventory management. The model answers what the current unrealised loss is on the portfolio, how much P&L would swing if the yield curve shifts, and where the concentration risk sits across issuer and sector.

Positions are tracked with issuer name, maturity, coupon, amount, and cost basis. Valuation uses a bond pricing formula (present value of future coupons plus final principal, discounted at current market yield) which updates daily as spreads and base rates move. P&L is decomposed into carry (coupon accrual), roll-down (capital appreciation as bonds age and yields converge to maturity), spread widening/tightening, and curve reshaping (steepening or flattening). Greeks are calculated analytically: duration tells the percentage price move per 1% yield change (DV01 in dollars), convexity accounts for the acceleration of price changes at extreme yields, and key rate durations isolate sensitivity to specific maturity buckets (2Y, 5Y, 10Y, 30Y). Scenario analysis applies parallel shifts (all yields up/down 100bps), steepening (short-end up, long-end down), or flattening to show portfolio sensitivity.

Fixed income traders, portfolio managers, and risk managers use bond models to size trading positions, monitor daily P&L attribution (which curve factors drove profits/losses), and stress test the book for adverse rate or credit scenarios.