Module VI· Debt Schedule MechanicsIntermediate
Question

How do you model a floating-rate tranche such as SOFR, SONIA or EURIBOR plus margin?

Answer

Interest rate equals base rate plus margin, usually with a floor. The base rate depends on the currency: SOFR (USD), SONIA (GBP) or EURIBOR (EUR). SOFR and SONIA are overnight risk-free rates, used as Term SOFR or compounded in arrears, while EURIBOR is a forward-looking term rate (e.g. 3M/6M). Forecast the base rate from the forward curve, add the margin, apply the floor if needed, and multiply by the average or beginning debt balance. If hedged, split the floating exposure into hedged and unhedged portions. Sensitize base rates, because floating-rate debt affects cash interest and debt capacity.