LBO Model Question:
Can someone help with a template of some sort?
Here's the question:
The owners are interested in understanding how much their company is valued. The MD on the deal has skimmed the materials and has asked you to prepare transaction comps and a LBO analysis Requirements Transaction Comps LBO returns model that at a minimum includes: Sources and uses Revenue Bulld Forecast P&L Working capital schedule Debt paydown schedule Exit and returns schedule (including cash-on-cash and IRR) with appropriate senstivities One-page summary that at a minimum covers: Valuation range (LBO & transaction comps) Key drivers Key open due diligence topics and questions Historical Financials Units Income Statement Recurring Revenue Other Revenue % Growth COGS Gross Profit % Margin Sales & Marketing Mgmt. Salaries Other OpEx % Margin D&A % Margin Balance Sheet Cash Accounts receivable Current Assets PP&E Intangible Assets Total Assets Revenue EBITDA EBIT 1000 Accounts Payable Accrued Expenses Current Liabilities Long Term Debt 2015 1,882 137 2,019 400 1,619 80.2% 505 342 249 523 25.9% 47 476 23.6% 2016 1,942 144 2,086 3.3% 450 1,636 78.4% 513 350 257 516 24.8% 50 467 22.4% 2017 1,987 151 2,138 2.5% 470 1,668 78.0% 522 350 262 534 25.0% 52 482 22.6% 2018 2,032 159 2,191 2.5% 430 1,761 80.4% 527 350 265 618 28.2% 55 564 25.7% 2019 2,317 167 2,484 13.4% 450 2,034 81.9% 586 350 298 800 32.2% 57 742 29.9% 2015 2016 2017 2018 2019 18 19 19 20 23 336 376 396 401 409 354 395 415 421 432 950 970 990 1,070 1,090 500 500 500 500 500 1,804 1,865 1,905 1,991 2,022 157 187 183 208 350 78 79 82 86 96 235 266 265 294 446 1,500 1,250 1,000 750 500 Total Liabilities 1,735 1,516 1,265 1,044 946 Equity 69 349 640 947 1,076 Total Liabilities & Equity 1,804 1,865 1,905 1,991 2,022 Check Note: BS provided above will not match the P&L due to non-oprating income/expense redacted from the P&L The owners are interested in understanding how much their company is valued. The MD on the deal has skimmed the materials and has asked you to prepare transaction comps and a LBO analysis Requirements Transaction Comps LBO returns model that at a minimum includes: Sources and uses Revenue Bulld Forecast P&L Working capital schedule Debt paydown schedule Exit and returns schedule (including cash-on-cash and IRR) with appropriate senstivities One-page summary that at a minimum covers: Valuation range (LBO & transaction comps) Key drivers Key open due diligence topics and questions Historical Financials Units Income Statement Recurring Revenue Other Revenue % Growth COGS Gross Profit % Margin Sales & Marketing Mgmt. Salaries Other OpEx % Margin D&A % Margin Balance Sheet Cash Accounts receivable Current Assets PP&E Intangible Assets Total Assets Revenue EBITDA EBIT 1000 Accounts Payable Accrued Expenses Current Liabilities Long Term Debt 2015 1,882 137 2,019 400 1,619 80.2% 505 342 249 523 25.9% 47 476 23.6% 2016 1,942 144 2,086 3.3% 450 1,636 78.4% 513 350 257 516 24.8% 50 467 22.4% 2017 1,987 151 2,138 2.5% 470 1,668 78.0% 522 350 262 534 25.0% 52 482 22.6% 2018 2,032 159 2,191 2.5% 430 1,761 80.4% 527 350 265 618 28.2% 55 564 25.7% 2019 2,317 167 2,484 13.4% 450 2,034 81.9% 586 350 298 800 32.2% 57 742 29.9% 2015 2016 2017 2018 2019 18 19 19 20 23 336 376 396 401 409 354 395 415 421 432 950 970 990 1,070 1,090 500 500 500 500 500 1,804 1,865 1,905 1,991 2,022 157 187 183 208 350 78 79 82 86 96 235 266 265 294 446 1,500 1,250 1,000 750 500 Total Liabilities 1,735 1,516 1,265 1,044 946 Equity 69 349 640 947 1,076 Total Liabilities & Equity 1,804 1,865 1,905 1,991 2,022 Check Note: BS provided above will not match the P&L due to non-oprating income/expense redacted from the P&L
