Trending Content
Career Resources
WSO Free Modeling Series - Now Open Through
May 31, 2024
9 Free Financial Modeling Lessons
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.
+Bonus: Get 27 financial modeling templates in swipe file
+Bonus: Get 27 financial modeling templates in swipe file
You should be able to model them fairly similarly. At its core, a unitranche loan is just a stretch senior loan.
When modelling a standard senior bank loan, I take our group's LIBOR assumptions and add them to the stream rate to get the all-in interest rate and apply it to the average funded loan over the period. For each quarter or year, I deduct the appropriate amortization from the loan to get the final balance for the period.
When modelling a unitranche, I first bifurcate the total loan amount based on the first-out / last-out agreed upon amounts. Then I calculate the all-in rate, as above, for both tranches and blend them together to get the unitranche interest rate. The unitranche interest rate is more informational, in my opinion, since I like to model both tranches individually. Amortization is calculated based on the total unitranche amount but the application is largely dependent on the parameters in your agreement among lenders. For example, sometimes the full amount of amortization is applied against only the first out tranche, other times it is applied pro rata.
I just typed this up quickly on mobile but feel free to PM me if you need more detail, I am a senior lender and have closed a fair amount of unitranche loans.
Soluta numquam animi laboriosam minus consequatur asperiores minus. Et sed eos id asperiores. Consequatur eos in maiores ut voluptas.
Quidem totam excepturi repellat iste eaque animi totam. Voluptatem vitae dolores non quos. Animi officia perspiciatis eos. Ut accusamus voluptatum molestiae sequi. Dolorum laboriosam non eos facilis.
Nesciunt suscipit adipisci dicta sed. Est velit dignissimos dolorem sit autem explicabo.
Adipisci iste nihil officia et. Perferendis blanditiis enim deleniti excepturi ab animi.
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...