Macabacus Simple LBO Mod
Ryan MacGregor
www.macabacus.com
feedback@macabacus.com
2014 Macabacus, LLC
Built with Macabacus Macros
DISCLAIMER
This model presents a hypothetical LBO of a hypothetical company. Any similarity between the financ
metrics of this company and actual companies is purely coincidental.
Macabacus does not prov
investment, accounting, or tax advice.
LIMITATION OF WARRANTIES OF MACABACUS
EXCEPT AS OTHERWISE EXPRESSLY STATED, INCLUDING BUT NOT LIMITED TO IN A LICENSE OR OTH
AGREEMENT GOVERNING THE USE OF SPECIFIC CONTENT, ALL CONTENT IN THIS MODEL IS PROVIDED "AS I
AND MACABACUS MAKES NO REPRESENTATIONS OR WARRANTIES, EXPRESS OR IMPLIED, INCLUDING BUT N
LIMITED TO WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE OR NO
INFRINGEMENT OF PROPRIETARY RIGHTS. WITHOUT LIMITING THE FOREGOING, MACABACUS MAKES
REPRESENTATION OR WARRANTY THAT CONTENT IN THIS MODEL IS FREE FROM ERROR OR SUITABLE FOR A
PURPOSE; NOR THAT THE USE OF SUCH CONTENT WILL NOT INFRINGE ANY THIRD PARTY COPYRIGH
TRADEMARKS OR OTHER INTELLECTUAL PROPERTY RIGHTS. YOU UNDERSTAND AND AGREE THAT Y
DOWNLOAD OR OTHERWISE OBTAIN CONTENT THROUGH MACABACUS' WEBSITES AT YOUR OWN DISCRETI
AND RISK, AND THAT MACABACUS WILL HAVE NO LIABILITY OR RESPONSIBILITY FOR ANY DAMAGE TO YO
COMPUTER SYSTEM OR DATA THAT RESULTS FROM THE DOWNLOAD OR USE OF SUCH CONTENT. SO
JURISDICTIONS MAY NOT ALLOW THE EXCLUSION OF IMPLIED WARRANTIES, SO SOME OF THE ABO
LIMITATIONS MAY NOT APPLY TO YOU.
LIMITATION OF LIABILITY OF MACABACUS
EXCEPT AS OTHERWISE EXPRESSLY STATED, INCLUDING BUT NOT LIMITED TO IN A LICENSE OR OTH
AGREEMENT GOVERNING THE USE OF SPECIFIC CONTENT, IN NO EVENT WILL MACABACUS BE LIABLE TO Y
OR ANY OTHER PARTY FOR ANY DIRECT, INDIRECT, SPECIAL, CONSEQUENTIAL OR EXEMPLARY DAMAG
REGARDLESS OF THE BASIS OR NATURE OF THE CLAIM, RESULTING FROM ANY USE OF THIS MODEL, OR T
CONTENTS THEREOF, INCLUDING WITHOUT LIMITATION ANY LOST PROFITS, BUSINESS INTERRUPTION, LO
OF DATA OR OTHERWISE, EVEN IF MACABACUS WAS EXPRESSLY ADVISED OF THE POSSIBILITY OF SU
DAMAGES. SOME JURISDICTIONS MAY NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CERTA
INCIDENTAL OR CONSEQUENTIAL DAMAGES, SO SOME OF THE ABOVE LIMITATIONS MAY NOT APPLY TO YOU.
odel
Macabacus Simple LBO Model
x
Dashboard
Summary Credit Statistics
Income Statement
Balance Sheet
Cash Flow Statement
Working Capital Assumptions
Equity Investments
Debt Schedule
Interest Rates & Summary
Amortization of Capitalized Financing Costs
Depreciation of Fixed Assets
Amortization of Intangible Assets
Tax Schedules
Shares Outstanding
Financing Scenarios & Drivers
Transaction Balance Sheet
Returns Analysis
The Macabacus Simple LBO Model excludes the several features present in the Macabacus Comp
No original issue discounts (OID)
No payment-in-kind (PIK)
Assumes no NOLs, either at LBO or going forward
No discounted cash flow (DCF) analysis
No weighted average cost of capital (WACC) calculation
Simplified timing; no ability to select the transaction close date
Transaction closes at calendar year-end, and fiscal years are aligned with calendar years
Assumes no existing purchase accounting-related intangibles to be written of
No cash earnings or accretion/dilution
No prepayment premiums/penalties
No cost savings
Single operating case
No sponsor management fee
nt in the Macabacus Complex LBO Model, and makes simplifying assumptions, as follows:
