100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
LBO Modeling Review Questions and 100% Correct Answers £8.11   Add to cart

Exam (elaborations)

LBO Modeling Review Questions and 100% Correct Answers

 9 views  0 purchase
  • Module
  • LBO Modeling
  • Institution
  • LBO Modeling

Sections Transaction assumptions, income statement, working capital schedule, balance sheet, statement of cash flows, debt schedule, interest expense schedule, credit metrics, returns calculations Transaction assumptions: Sections Sources & uses, transaction assumptions, financing assumptions, pur...

[Show more]

Preview 2 out of 13  pages

  • August 15, 2024
  • 13
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • LBO Modeling
  • LBO Modeling
avatar-seller
LBO Modeling Review Questions and
100% Correct Answers
Sections ✅Transaction assumptions, income statement, working capital schedule,
balance sheet, statement of cash flows, debt schedule, interest expense schedule,
credit metrics, returns calculations

Transaction assumptions:
Sections ✅Sources & uses, transaction assumptions, financing assumptions, purchase
accounting, debt financing, other assumptions, checks

Transaction assumptions:
Sources & uses ✅Sources: cash on hand, revolver draw (which should be zero), term
loan, senior notes, subordinated notes, mgmt rollover, sponsor equity
Uses: purchase equity, refinance existing debt, refinancing expenses, fund cash
balance, transaction expenses, financing fees

Transaction assumptions:
Transactions assumptions ✅LTM adj. EBITDA X transaction multiple = transaction
value
Transaction value - debt + cash = equity value

Memo: Mgmt rollover in % and $

Transaction assumptions:
Purchase accounting ✅Total equity value - total assets (excl. goodwill) + total liabilities
= PF goodwill

Value paid for an asset must be capitalized on the B/S (in the case of an acquisition, the
asset being acquired is the company itself). When calculating goodwill, remember to
subtract out the existing goodwill (goodwill functions as the plug and we don't care
about the prior plug).

Transaction assumptions:
Financing assumptions ✅Rows: revolver, term loan, senior notes, subordinated notes
(type of debt)
Columns: leverage, term, interest type, interest rate, annual amort, years PIK, financing
fees

Memo:
Revolver commitment
Commitment fee

, Transaction assumptions:
Debt financing ✅Rows: revolver + term loan = senior secured debt
Senior secured debt + senior notes = senior debt
Senior debt + subordinated notes = total debt

Columns: $, leverage in x, fees in $

Formula to get nice, round debt balances for each tranche
=mround (leverage * EBITDA, minimum debt increment)

PF income statement:
Rows ✅Revenue
% growth

Adj EBITDA
% margin
% growth

(-) D&A
Adj EBIT
% margin
% growth

(-) Net interest expense (build in circuit breaker)
Adj EBT

(-) Tax expense
Adj net income
% margin
% growth

Memo:
Revenue growth (%)
COGS (% of sales)
EBITDA margin (%)
D&A (% of sales)
CapEx (% of sales)

PF income statement:
Steps ✅Grow Revenue by multiplying the prior year by (1 + growth rate)
Calculate projected EBITDA by multiplying margin by Revenue
Calculate D&A with the % of sales
Subtract D&A from EBITDA to arrive at EBIT
Leave Net Interest Expense blank for now, but calculate EBT as EBIT + blank Net
Interest Expense row
EBT equals EBIT for now, but we will add Net Interest Expense in the future

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

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

Quick and easy check-out

You can quickly pay through credit card for the summaries. There is no membership needed.

Focus on what matters

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 twishfrancis. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for £8.11. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

75323 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy revision notes and other study material for 14 years now

Start selling
£8.11
  • (0)
  Add to cart