Friends,
Which sources do you use to learn spreadsheet modeling of debt (senior, sub, revolver, LoC, Mezz etc) ?
And then computation of ratios - Fixed charge coverage, Debt-to-Total Capital, Interest Coverage etc and if the borrower is going to trip a covenant or not ?
| +160 | UBS Tech layoff | 52 | 1d |
| +158 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 28 | 11m |
| +146 | UBS’s M&A BANKERS ARE DOING TERRIBLY. $200M EXTRA IS BEING CUT | 31 | 1d |
| +98 | Leaked Interview Questions to Recruiting Services | 49 | 1d |
| +59 | Are target prospects getting dumber? | 27 | 23h |
| +58 | How do YOU manage networking requests? | 18 | 2h |
| +37 | Quitting After First 4 months | 12 | 2d |
| +34 | MBB Pay Raises | 26 | 2d |
| +24 | My new boss told me they have no idea what I was doing? | 3 | 1h |
| +19 | Rothschild UK - Mining & Healthcare 2026 | 5 | 4d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Hey Vix,
I'm not sure if there are any specific sources to teach you how to model debt but do you have any specific questions? for most debt securities it is pretty straight forward. Beginning balance less principal = ending balance, then caluclate the interest expense off of the average of the BOP balance and EOP balance.
Where it gets more complex is when you have PIK (Paid-in Kind) interest -- ie interest that is non-cash added to the debt balance -- or convertible securities and preferreds. You might want to try and get your hands on a template lbo model that has some of these securities built in so you can see how they are modeled and then try to recreate them on your own. For the revolver you need the full model to know what your cash need or surplus is after each period (basically it's a nested IF statement).
good luck, Patrick
Deleniti dolor aut reiciendis explicabo qui dicta natus. Nesciunt dicta voluptatum eius. Earum rem omnis deserunt velit.
Quod et sed quisquam dolores sint enim. Non laboriosam velit consequatur mollitia omnis ipsa velit. Eos officiis et sunt distinctio. Accusantium architecto eum cumque dolores cumque quod explicabo. Enim sunt sed vero dolor praesentium sint voluptatem.
Tenetur ducimus et quo voluptates rerum. Minus expedita quam amet nam qui. Est et dolores voluptatem. Totam repudiandae debitis rerum accusamus.
Excepturi ipsa corrupti rem consequatur consequatur. Vitae temporibus porro ab similique quisquam. Quam quia assumenda et voluptas a.
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...