# Bond Trading Model Track bond trading positions with mark-to-market, spread changes, duration sensitivity, and P&L attribution across carry, roll-down, and curve reshaping. - Canonical: https://finamodel.com/templates/bond-trading-model - Excel download: https://finamodel.com/templates/bond-trading.xlsx - Category: Capital Markets - Model type: Portfolio - Difficulty: Advanced - Audiences: Investors & analysts, Credit & risk, Traders, Risk managers, Desk heads, Hedge fund managers - Tags: fixed income, trading, P&L, DV01, yield curve ## Overview 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. ## What's included - Position-level inventory: issuer, maturity, amount, cost basis - Mark-to-market pricing with yield curve and spread assumptions - Duration, convexity, DV01, and key rate durations (KRD) - P&L attribution: roll-down, carry, spread, and curve reshaping - Scenario analysis: parallel shift, steepening, flattening - Position-level inventory: issuer, maturity, amount, and cost basis - Greeks: duration, convexity, DV01, and key rate durations (KRD) - P&L attribution: roll-down, carry, spread widening/tightening, curve reshaping - Portfolio concentration and counterparty exposure - Scenario analysis: parallel shift, steepening, and flattening ## What a Bond Trading Model Captures for a Fixed-Income Desk This bond trading model template organises the economics of a fixed-income trading desk, from client flow and inventory carry through to mark-to-market risk and regulatory capital. It shows how four revenue streams, funding costs, compensation and capital requirements connect in one structure, so a reader can follow the drivers behind reported trading performance. ### Revenue Drivers and Trading Activities The template models four revenue streams. Bid-ask spread income equals client trading volume multiplied by an average spread, and it is sensitive to market volatility and franchise breadth. - Carry income is the average inventory position multiplied by the difference between bond yield and repo funding cost, so curve shape and inventory duration matter. Mark-to-market P&L is net position exposure multiplied by a change in spread or rate, a scenario-driven figure that can be negative. - New issue fees reflect primary market volume and syndication fee rates. ### Calculating Net Trading Revenue and Costs Net trading revenue is the sum of bid-ask income, carry income, mark-to-market P&L and new issue fees. - Average inventory, calculated as the simple average of opening and closing trading assets, drives both carry income and repo funding cost, which keeps the two calculations consistent. - Repo financing is treated as a trading liability that scales with inventory, not as corporate debt. - Compensation combines base salaries with a bonus pool constrained by a floor, and other operating costs cover technology, compliance, occupancy and operations. ### Outputs, Metrics and Control Checks The income statement flows into a balance sheet, a cash flow statement and a dedicated capital adequacy sheet that calculates risk-weighted assets from market, credit and operational risk components, then compares CET1 capital against a regulatory minimum. - A key metrics sheet produces return on tangible common equity, compensation and efficiency ratios, inventory turnover, value-at-risk utilisation and revenue per trader. - Built-in checks test that the balance sheet balances, CET1 and leverage ratios stay inside defined ranges, cash never turns negative, and dividends do not exceed available excess capital. ### Practical Use for Evaluating a Trading Operation The structure supports evaluating whether to invest in, expand or assess a fixed-income trading operation by linking projected trading profit and loss to risk-adjusted returns, capital efficiency and regulatory capital adequacy. - Because client volume growth and inventory growth are independent inputs, the model shows how inventory turnover changes over time. - Scenario levers for mark-to-market stress can trigger inventory restraint, and the funding and capital calculations demonstrate how position size, repo spreads and capital charges interact when sizing a desk. ## Built for daily P&L and risk Use this model when DV01, spread risk, and curve scenarios drive intraday trading decisions and end-of-day reporting. ## Position-level Greeks A useful bond trading model produces duration, convexity, and KRD per bond, then aggregates to desk-level risk. ## Curve scenario toolkit This applies parallel, twist, and butterfly shifts so traders can size hedges and stress the book under realistic rate moves. ## Built for daily P&L and risk Use this model when DV01, spread risk, and curve scenarios drive intraday trading decisions and end-of-day reporting. ## Position-level Greeks A useful bond trading model produces duration, convexity, and KRD per bond, then aggregates to desk-level risk. ## Curve scenario toolkit This applies parallel, twist, and butterfly shifts so traders can size hedges and stress the book under realistic rate moves. ## Features - **Position-level P&L and Greeks:** See DV01, curve positioning, and spread risk for each bond; aggregate to desk-level risk and P&L metrics. - **Curve scenario toolkit:** Model parallel, twist, and butterfly shifts; see instantly how spread widening or curve steepening affects portfolio P&L. - **Daily and intraday revaluation:** Update yields and spreads to mark positions and calculate P&L as markets move. ## Use cases - **Intraday risk management:** Monitor DV01 and spread risk limits; rebalance positions to stay within risk budgets as markets move. - **End-of-day P&L reporting:** Attribute daily P&L to carry, roll-down, spread widening, and curve reshaping to understand what drove desk performance. - **Trade decision analytics:** Evaluate new trade ideas by modeling their impact on portfolio duration, convexity, and spread distribution. ## Frequently asked questions ### What is a bond trading model? It is a model that tracks fixed income positions, calculates mark-to-market P&L, Greeks, and scenario analysis for trading desks. ### What is DV01 and how is it calculated? DV01 (Dollar Value of 1 basis point) measures the change in position value if yields rise 1 bp; it equals duration * position size / 10,000. ### What is a key rate duration (KRD)? KRD measures sensitivity to moves at specific points on the yield curve (2Y, 5Y, 10Y, 30Y) rather than parallel shifts. ### How do I model carry? Carry is the daily P&L from coupon accrual and roll-down as a bond ages closer to maturity. ### Can I run curve scenarios? Yes. The model supports parallel shifts, steepening, flattening, and custom twists with instant portfolio repricing. ## Related templates - [Fixed Income Portfolio Model](https://finamodel.com/templates/fixed-income-portfolio-model) - [Credit Rating Model](https://finamodel.com/templates/credit-rating-model) - [Convertible Bond Model](https://finamodel.com/templates/convertible-bond-model)