Learn Finance

Explore Macabacus' interactive self-study finance resources

Interactive Self-study

Build an operating model

In this tutorial, we will walk through how to build a general industry business operating model.

Build an M&A model

In this section, we demonstrate how to model a merger of two public companies in Excel.

Build an LBO model

In this tutorial, we will walk you through building an LBO model in Excel.

Popular Excel Templates

Discounted Cash Flow (DCF) Model

The Macabacus DCF template implements key concepts and best practices related to DCF modeling. It computes the perpetuity growth rate implied by the terminal...

Operating Model

The Macabacus operating model implements key accounting and tax concepts, and is a foundational building block for our merger and LBO models. Advanced...

Merger Model

The Macabacus merger model implements advanced M&A, accounting, and tax concepts, and is intended for use in modeling live transactions (with some...

LBO Model – Short Form

The Macabacus short form LBO model implements key concepts related to LBO modeling, and is an excellent starting point for understanding the basics of...

LBO Model – Long Form

The Macabacus long form LBO model is derived from actual LBO models used by four bulge bracket investment banks, incorporating the best practices and features...

Capitalization (Cap) Tables & VC Returns

The Macabacus capitalization ("cap") table and venture capital return analysis template identifies how much venture capital a start-up requires and when...

IPO Model

The Macabacus IPO model implements all concepts related to IPO modeling, including IPO and fully distributed valuation, gross/net proceeds, filing range,...

Topics

Deal Mechanics

Sale Processes, Purchase and Sale Agreements and Private vs. Public Deals

M&A Accounting

Asset and Stock Deals, Subsidiary Accounting, Equity Method Accounting, Important Accounting Changes, Purchase Price Allocation, Noncontrolling (Minority) Interest and Treatment of Options (FIN 44)

Taxes

Tax Considerations, Section 338 Elections, Tax-Free Acquisitions, Dividends Received Deduction (DRD), Tax Attributes of a Target

Corporate Restructuring

Spin-Offs and Split-Offs, Equity Carve-Outs and Morris Trust Transactions

Valuation

Valuation Multiples, Valuation Methods, Sum-of-the-Parts Analysis, Comparable Companies Analysis, Precedent Transactions Analysis, Discounted Cash Flow (DCF) Analysis, Unlevered Free Cash Flow, Weighted-Average Cost of Capital (WACC), Terminal Value, Enterprise and Equity Values, Adjusted Present Value and Leveraged Buyout (LBO) Analysis

Tax-Efficient Strategies

Tax-Efficient Sale Strategies, Leveraged Partnership, Like-Kind Exchange, Mixing Bowl, Monetizing Spin-Off, Sponsored Spin-Off, Morris Trust, Double Reverse Morris Trust, Supercharged IPO, JV IPO, Stock-for-Stock Monetization, Cash-Rich Split-Off and more

Venture Capital

Probability-Adjusted APV, Rounds of Financing and Returns Analysis (IRR & CoC)

Debt Instruments

Original Issue Discount (OID), Termination Fee, Cash Equivalents, EBITDA, Liquidation Value and Bullet Payment

Take Excel to the next level

Build better models with the most comprehensive productivity and brand compliance solutions available for Excel — the must-have tool for power finance and consulting users

Try Macabacus Now

Book a Demo

Schedule a live demo with a Macabacus expert to confirm it’s right for your organization.

Book a Demo

Download Brochure

If you want to kick it old-school with a PDF, we have one for you.

Download