12 Month or 3 Month SOFR on LBO model
When modeling bank debt in LBOs should we use the 12 Month or 3 Month SOFR rate for interest rate in projected years?
When modeling bank debt in LBOs should we use the 12 Month or 3 Month SOFR rate for interest rate in projected years?
| +79 | Those unemployed in PE 3+ months, how do you make progress every day? | 35 | 28m |
| +25 | Is it possible to get no comments as an analyst? | 10 | 15m |
| +18 | Friend considering moving from the US to Hong Kong for an IR Role – How difficult would it be to return? | 2 | 11m |
| +16 | London PE Secondaries / Co-Investment Comp | 5 | 5m |
| +14 | Why is BX trimming analyst/sa headcount? | 11 | 7m |
| +9 | Lending to PE/VC | 1 | 21h |
| +9 | Arcline thoughts? | 7 | 4d |
| +8 | PE to L/S Equities | 9 | 1d |
| +6 | PE Recruiting: M&A vs Rx | 3 | 2d |
| +6 | What kind of bear is best? | 2 | 22h |
Career Resources
I'd match it up to how your interest schedule is modeled (i.e., quarterly vs. annually). In practice the Borrower will typically have the option based on if they want to pay interest monthly or quarterly which would be off of 1-Month or 3-Month SOFR.
Thank you for your reply.
On a take home case study - what should I use? 3 month?
I assume you're projections are annual, not quarterly, so the 12-month would be the appropriate base. If you want to impress and have your model be similar to how it is on the job I would suggest quarterly.
Thank you for clarifying. I ask 3 vs. 12 month, because I'm yet to find a 12 month SOFR fwd rate. Any idea where to find it publicly / free?
I've never heard of someone using a 12-month SOFR so I'd advise you to use the 3-month. If you don't want to build a full quarterly model I'd just build a separate interest expense schedule that's quarterly and pull the annual sum into your annual model.
Here's where you can find a SOFR curve:
https://www.chathamfinancial.com/technology/us-forward-curves
Use Pensford
1-month or 3-month fwd curve only
FYI the time horizon is forecast blocks, not the actual denomination you get the forecast in - which will be monthly
If you're build a model and your numbers are annualized just take the average of your 12 3-mo LIBOR rates per year
Doesn't really matter... you won't get dinged / accepted for doing it one way vs the other
Pariatur sed iste voluptatem aut nam qui. Veritatis quasi eum officiis laudantium autem nihil dolores. Saepe consequatur repellat molestiae modi saepe tempore.
Omnis deleniti laborum alias vel. Est non quibusdam fugiat ut quas. Earum enim corrupti ut et sed nostrum ipsum. Fuga qui repudiandae et repellat. Expedita facere eligendi voluptas laudantium. Soluta dicta aliquam repellendus alias iure reprehenderit id. Dolor et consequatur sequi officiis.
Quia perspiciatis sed ratione voluptatem enim aut. Et consequatur ad quod.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...