Derivatives, Prime Brokerage Synthetic Financing & Total Return Swaps
Total Return Swap (TRS) Equity Leg & SOFR Settlement Formula
Calculate ISDA Total Return Swap (TRS) Quarterly Total-Return Leg (Price Return + Dividend Pass-Through), ACT/360 SOFR + Spread Financing Leg, Net Periodic Cash Settlement ($M), and Return on Initial Margin (Independent Amount).
Model two-way Total Return Swap cash settlements—when stocks drop, you pay BOTH legs!
Institutional funds gain synthetic leveraged exposure to equity baskets or leveraged loans via an ISDA Total Return Swap (TRS) without funding 100% cash purchase on balance sheet! On each reset date, the Total Return Receiver collects Total_Return_Leg = Notional * (Price_Return + Dividend_PassThrough) and pays the prime broker Financing_Leg = Notional * (SOFR + Spread) * (Actual_Days / 360)! Beginners forget the downside asymmetry: if the reference asset falls (-6%), Price_Return is negative so the Total Return Receiver PAYS the capital loss PLUS the SOFR financing leg simultaneously—amplified across Initial Margin (Independent Amount = Notional * Margin_Pct)!
Verify on a $40M Quarterly Equity Index TRS—Swap_Notional = $40.00M (B2), Quarterly_Price_Return = +0.045 (+4.50%, B3), Dividend_PassThrough = +0.005 (+0.50%, B4 -> Total Return Leg Received = 40 * 0.05 = +$2.0000M in E2), Annual_SOFR_Plus_Spread = 0.058 (5.80%, B5), Reset_Actual_Days = 90 days (B6 -> ACT/360 Funding Leg Paid = 40 * 0.058 * (90/360) = $0.5800M in E3), and Initial_Margin_Pct = 0.15 (15.0% = $6.00M cash posted, B7): Net Quarterly Settlement Received is +$1.4200M (E4), yielding +0.2367 (+23.67% quarterly ROE on posted margin in E5)!
| Quarterly TRS Metric ($40M Notional, +4.5% Px + 0.5% Div, 5.8% SOFR+Spd, 90d, 15% IM) | Formula | Verified Output |
|---|---|---|
| Total Return Leg ($M) | Notional * (Price_Return + Div_Yield) | +$2.0000M (-$2.2000M @ -6% Drop) |
| SOFR+Spread Funding Leg ($M) | Notional * Funding_Rate * (Days / 360) | $0.5800M |
| Net Cash Settlement ($M) | Total_Return_Leg - Funding_Leg | +$1.4200M (-$2.7800M @ -6% Drop) |
| Return on Initial Margin | Net_Settlement / (Notional * Margin_Pct) | +0.2367 (-0.4633 @ -6% Drop) |
Total Return Swap Net Cash Settlement Formula
Validate Notional > 0, Price_Return > -1, Dividend_Yield >= 0, Funding_Rate > -0.05, Actual_Days >= 1, and Initial_Margin in (0, 1]! In shared risk-committee sheets in Arte Sheets, test stress drawdowns before approving synthetic TRS notional increases.
=LET(nt_m, B2, pr_r, B3, dv_y, B4, fn_r, B5, dy_a, B6, im_p, B7, IF(OR(nt_m <= 0, pr_r <= -1, dv_y < 0, fn_r <= -0.05, dy_a < 1, im_p <= 0, im_p > 1), "Invalid TRS Swap Input", LET(tr_l, nt_m * (pr_r + dv_y), fd_l, nt_m * fn_r * (dy_a / 360), ROUND(tr_l - fd_l, 4))))-6.0% Equity Drawdown Double-Payment Stress Check
Flip Quarterly_Price_Return B3 from +4.5% to -6.0% (-0.06): Total Return Leg E2 turns negative (-$2.20M), combining with the $0.58M SOFR funding leg so Net Cash Owed to Prime Broker E4 hits -$2.78M—wiping out -46.33% (-0.4633 in E5) of the $6.00M initial margin in a single quarter!
=IF(ISTEXT(E4), E4, ROUND(E4 / (B2 * B7), 4))Try the example
Use the original values or change them to test your understanding.