Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I want to know how to get the Internal Rate of Return (IRR) for this LBO. Please show your steps so that I can better
I want to know how to get the Internal Rate of Return (IRR) for this LBO. Please show your steps so that I can better understand the process.
BALANCE SHEET (2017A) Cash Accounts Receivables Inventories Property, Plant & Equipment Total Assets 24,950,000 6,000,000 25,000,000 60,000,000 115,950,000 Accounts Payables Term Loan A Term Loan B Subordinated Notes Total Liabilities 5,000,000 11,000,000 10,000,000 7,500,000 33,500,000 Retained Earnings Shareholder's Equity Total Shareholder's Equity 53,680,000 28,770,000 82,450,000 Total Liabilities + Shareholder's Equity 115,950,000 INCOME STATEMENT (2017A) Revenue COGS Gross Profit Salaries & Wages Rent Expense Utilities Other SG&A Depreciation & Amortization Operating Profit Income Taxes Net Income 50,000,000 30,000,000 20,000,000 3,500,000 7,000,000 2,500,000 1,000,000 1,000,000 5,000,000 5,000,000 CASH FLOW STATEMENT (2017A) CFO Net Income Depreciation & Amortization Increase in Accounts Receivable Increase in Inventories Increase in Accounts Payable Total Cash Flow from Operating Activities 5,000,000 1,200,000 (1,200,000) (2,500,000) 950,000 3,450,000 CFI Capital Expenditures Total Cash Flow from Investing Activities (500,000) (500,000) CFF Issuance of Subordinated Notes Total Cash Flow from Financing Activities 7,500,000 7,500,000 Excess Cash for the Period Beginning Cash Balance Ending Cash Balance 10,450,000 14,500,000 24,950,000 According to the MD&A, Balaban's Burgers had 1,674,388 shares outstanding as of December 31st, 2017. The January 3rd, 2018 closing price of Balaban's Burgers was $20.86. Your firm is looking to pay an offer premium of 30%. To finance the buyout, you believe your firm can obtain a term loan at a debt/EBITDA multiple of 5.5x and an annual interest rate of 5%. All outstanding debt must be repaid prior to completion of the transaction, although your firm wishes to maintain a minimum cash balance of $5 million for Balaban's Burgers in case of emergencies. You assume that you will sell Balaban's Burgers in 5 years at the same multiple at which it is acquired, EBITDA will grow 6% each year, and FCF will grow 5% each year. All FCF generated will be used to pay down existing debt. There will be no dividend recapitalizations. For the purpose of this example, assume no taxes or transaction costs
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started