Leveraged Loan Yield Calculation

I was hoping someone could help me figure out how to calculate the yield of a loan with a less than 4 year average life.

I'm trying to build out a formula in excel that will calcualte the yield from a database. It's basically back of the envelope, but what I have so far is the spread + LIBOR floor and every point of OID off par equaling roughly 25 bps. So a loan at L+300, with a 1.00% floor at 99 would yield 4.25%.

The problem with the above is that it doesn't take into account OID for a loan with 2or 3 years. Does anyone have any input into how I could do this better?

Thank you for your time and consideration.

Private Equity Interview Course

  • 2,447 questions - 203 PE funds. Crowdsourced from 750k+ members
  • 9 Detailed LBO Modeling Tests and 15+ hours of video solutions.
  • Trusted by over 1,000 aspiring private equity professionals just like you.

Comments (4)

Mar 5, 2013 - 9:42am

Let me ask you this: Do you understand WHY each point of OID=25 bps of yield for a 4 year loan?
If the answer that question is yes, you should be able to figure this out pretty easily.

There have been many great comebacks throughout history. Jesus was dead but then came back as an all-powerful God-Zombie.
Mar 5, 2013 - 11:42am

An OID is an original issuers discount which essentially means that the bond is issued at a price of some % (in this case 99) of par. The difference between the issue price and the par value is then amortized over the life of the bond. If the life is 4 years, it would be (100-99)/4 = 25 bps per year of yield. If it were 2 years it would be (100-99)/2 = 50 bps per year of yield.

Start Discussion

Total Avg Compensation

May 2021 Private Equity

  • Principal (7) $694
  • Director/MD (17) $582
  • Vice President (64) $370
  • 3rd+ Year Associate (66) $267
  • 2nd Year Associate (129) $251
  • 1st Year Associate (272) $223
  • 3rd+ Year Analyst (24) $164
  • 2nd Year Analyst (60) $136
  • 1st Year Analyst (173) $119
  • Intern/Summer Associate (19) $70
  • Intern/Summer Analyst (196) $60