Exam (elaborations)
LBO Modeling 2023/2024 already graded A+
- Course
- Institution
LBO Modeling 2023/2024 already graded A+
[Show more]
Content preview
LBO Modelingnet working capital = - ANSreceivables + inventory - payables
receivables days = - ANSreceivables/sales x 365
inventory days = - ANSinventory/cogs x 365
payables days = - ANSpayables/cogs x 365
capex is estimated as a - ANS% of sales, unless there is a more reasonable method
depreciation is estimated from a - ANScapex/depreciation multiple
sources of funds - ANScash, revolver, debt (including revolver), equity
uses of funds - ANSequity acquired, existing debt refinanced, debt issuance fees, advisory fees,
minimum cash
Equity value = - ANSacquisition EV - net debt
Acquisition EV = - ANSentry LTM ebitda x entry EV/EBITDA multiple
main items to show in IS - ANSnet sales, cogs, EBITDA, depreciation, EBIT, interest expense,
EBT, tax expense, net income (where interest expense links to the debt schedule)
main line items to show in BS (assets) - ANScash, receivables, inventory, pp&e, investments,
goodwill, intangibles
main line items to show in BS (liabilities) - ANSrevolver, debt, payables
main line items to show in BS (equity) - ANSNCI, retained earnings, equity
cash flow statement flow down - ANSebitda - cash interest expense - tax expense - changes in
net working capital - capex = cash flow available for debt repayment - mandated repayments =
cash flow available after mandated payments + revolver issuance (repayments) - accelerated
repayments = cash flow for the year
cash flow from operations includes - ANSebitda, cash interest expense, tax expense, changes
in net working capital
cash flow from investing includes - ANScapex
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Ashley96. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
77983 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now