Debt schedule modeling (simplified)

Hi guys.

Having seen various ways of structuring a debt schedule I am still trying to find a simpler and more user friendly way of doing it without super long Min/Max formulas linking to all over the sheet (even for complicated cap structures w. PIK, dividend recaps, etc.).

I would very much appreciate suggestions!

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 (2)

Start Discussion

Total Avg Compensation

August 2021 Private Equity

  • Principal (7) $694
  • Director/MD (18) $575
  • Vice President (66) $368
  • 3rd+ Year Associate (68) $270
  • 2nd Year Associate (137) $254
  • 1st Year Associate (276) $224
  • 3rd+ Year Analyst (25) $160
  • 2nd Year Analyst (61) $135
  • 1st Year Analyst (177) $118
  • Intern/Summer Associate (19) $70
  • Intern/Summer Analyst (210) $59