Reconcile a Bond Quote with the Cash Needed at Settlement

Start with the amount that leaves the account

A bond screen can show an attractive price while the settlement debit is larger. FINRA explains that bond quotes use a percentage of face value and that accrued interest can be added when ownership changes between coupon dates. In the following model, the quoted amount excluding that interest is the clean price; the amount including it is the dirty price. Separately billed transaction charges are then added to find the complete cash requirement.

The practical problem is a reconciliation problem. An investor with exactly USD 20,000 available cannot infer that a quote below 100 will fit the account. Face amount, accrued interest and any separately charged fee must all be translated into dollars. A purchase can be below par on the screen and still require more cash than face value. That observation does not make the quote deceptive; it means two displayed numbers measure different things.

Supporting references: 1. FINRA: Bonds

Build the invoice before judging the investment

Assume a hypothetical USD 20,000 face holding with a 6 percent annual coupon paid in equal half-year installments. Each installment is USD 600. The agreed clean quote is 99.20, giving USD 19,840 of clean value. For this case only, settlement occurs exactly one quarter of the way through a regular coupon period. Purchased accrued interest is USD 150, and dirty value is USD 19,990. A separately billed USD 20 fee produces a USD 20,010 debit.

The table varies only the settlement accrual fraction, keeping the clean price and fee fixed. At the start of a coupon period the debit is USD 19,860; halfway through it the debit becomes USD 20,160. The extra debit buys a larger claim to the approaching coupon. It is not evidence that the underlying clean market price has risen. An executable trade ticket should make the face amount and the dollar invoice reconcile before the order is funded.

Separate the next coupon from new profit

Suppose the base purchase later receives the USD 600 coupon and sells immediately afterward at the unchanged USD 19,840 clean value. With no sale fee or ending accrual, total receipts are USD 20,440. Subtracting the USD 20,010 purchase debit leaves USD 430. The same answer comes from USD 600 received, less USD 150 purchased interest, less USD 20 cost. Counting the entire coupon as net profit would overstate the economic gain by USD 170: USD 150 of purchased interest plus the USD 20 entry fee.

This is a holding-period cash reconciliation, not a tax characterization or a quoted annual yield. The buyer received cash originally accumulated partly while someone else held the bond. A spreadsheet that records clean purchase cost but includes the full coupon in income silently omits part of the acquisition debit. Conversely, subtracting purchased accrual from both the invoice and the coupon would charge the same amount twice.

Use a loss case to test the ledger

Now let the sale value after the coupon be USD 19,200. Receipts become USD 19,800 and the result is a USD 210 loss. Receiving the scheduled coupon did not prevent a loss because the USD 640 clean-price decline exceeded the USD 430 net coupon contribution after purchased accrual and the entry fee. The base case therefore establishes no floor on a future return.

The decision boundary can be stated directly. With the stated coupon and no sale charge, the exit value must be at least USD 19,410 for cash receipts to recover the initial USD 20,010. If an exit charge is introduced, the required gross sale proceeds increase dollar for dollar. This boundary is useful when comparing a planned sale date with the dates of household spending; it is not an estimate of where a dealer will bid.

Keep prices on the same basis across statements

A holding displayed at dirty value shortly before a coupon can appear to drop when the coupon becomes account cash. Compare the bond and cash together. If clean value is unchanged, a transfer from accrued interest into received cash is not by itself an investment loss. A report using clean prices needs a separate accrual field; a report using dirty prices must avoid adding that same accrual again.

For a position still held at the measurement date, use ending dirty value plus coupons actually retained, less the original invoice and costs. This captures the unreceived coupon portion belonging to the current holder. Keep external deposits outside the investment profit calculation. Choose one valuation convention for both endpoints rather than switching conventions to match whatever number is easiest to retrieve.

Resolve convention questions before placing the trade

Our quarter-period fraction is deliberately supplied rather than inferred from dates. Real securities can use different day counts, rounding and interest-entitlement provisions. Ask which accrual period and settlement date the invoice uses. If an unexplained amount remains, reconcile it with the confirmation instead of treating every difference from the screen as a fee. Some trading arrangements require special treatment beyond this regular paying-bond example.

TreasuryDirect notes that a reopened Treasury keeps its original coupon and maturity while its issue date and price can differ. That is another reason to inspect the actual security schedule. For a purchase decision, retain the clean quote for market comparison, dirty value for the bond claim, and full debit for funding. These three fields answer distinct questions while still belonging to one transaction.

Supporting references: 2. TreasuryDirect: Treasury Reopenings

Limits of this analysis

• Regular paying fixed-rate bond only; flat trading and unusual entitlement terms excluded.
• Settlement accrual fraction must be verified for the actual instrument.
• Unchanged clean exit value is a scenario, not a forecast.