Financial Modeling & Auditing Archives

Macabacus Merger Model Template: Improve Your M&A Analysis

Download the template The Macabacus merger model implements advanced M&A, accounting, and tax concepts, and is intended for use in modeling...

Download the template The Macabacus short-form LBO model implements key concepts related to LBO modeling and is an excellent starting point for...

Download the template What is the Macabacus Long-Form LBO Model ? The Macabacus long-form LBO model is derived from actual LBO models...

Download the template The Macabacus capitalization ("cap") table and venture capital return analysis template identify how much venture capital a start-up...

Download the template The Macabacus IPO model implements all concepts related to IPO modeling, including IPO and fully distributed valuation, gross/net...

Synergies & EBITDA

LTM Income Statement

Now, let's calculate the target's last-twelve-month ("LTM") income statement. To do so, we simply take the last fiscal year results, add the most recent...

Stub Period

In many cases, there will be a period of time between the transaction closing date and the date of the next fiscal year-end. In our case, this is 2 months....

Balance Sheet Set-Up

Now that we've begun to build our income statement let's switch gears and set up our balance sheet. For now, we are going to simply plug in historical...

Fully-Diluted Shares Outstanding

Now, let's calculate the target's fully-diluted shares outstanding ("FDSO"), as we will need this figure to calculate enterprise value in the next step....

LBO Model Enterprise Value

What is Enterprise Value in LBO? Now that we have calculated the target's fully-diluted shares outstanding ("FDSO"), let's compute enterprise...

Financing Assumptions

Financial Modeling & Auditing

Product

Resources

Company

Legal

Socials