Looking for more answers?

Release Notes

New Features, Enhancements, Bug Fixes, and Known Issues

General Modeling Concepts

Calendar vs. Fiscal Years, Base Year, Frequency (Monthly, Quarterly, Annually), Annual Vs. Monthly

Sources and Uses

Enterprise Value, Debt Tranches, Equity Tranches

Income Statement

GAAP Net Income, Net Income Available to Common, Key Ratios

Balance Sheet

Assets, Liabilities, Shareholders Equity

Cash Flow Statement

Operating Activities, Investing Activities, Financing Activities

Debt Schedule

Scheduled Amortization, Cash Sweep, Original Issue Discount

Discounted Cash Flow Analysis

WACC Calculation, EBITDA Multiple Method, Perpetuity Growth Method

Returns Analysis

Internal Rate of Return (IRR), Multiple of Invested Capital (MOIC), Equity Allocations

Sensitivities

Entry vs. Exit Multiples, Total Leverage vs. Entry Multiple, Enforcing Leverage Constraints

Excel Exports

Formatting Conventions, Company Branding, Enabling Iterations