Author name: IB Analysts Official

One-Tab CIM Model: Fast, Disciplined Deal Screening A Confidential Information Memorandum is the seller’s marketing deck for a business: the

Earnings Bridge: From GAAP to Pro Forma and Covenants An earnings bridge is a simple tool with a serious job:

An earnings bridge is a reconciliation that moves from a seller’s reported results to the buyer’s view of pro forma

An LBO sources and uses schedule is the one-page map of cash at closing that shows where money comes from

A sources and uses table is the transaction balance sheet for a leveraged buyout. Uses show the cash required at

A debt schedule is the spreadsheet engine that tracks every dollar you borrow, what it costs, when you pay it

A debt schedule is the part of a financial model that projects every debt instrument’s balance, interest, fees, and cash

Working Capital Modeling: Drivers, CCC, and Liquidity Working capital is the set of operating assets and liabilities that connects accrual

Three-Statement Models: 7 Common Errors and Fixes A three-statement model is a linked forecast of the income statement, balance sheet,

A three-statement model is an Excel workbook that links the income statement, balance sheet, and cash flow statement so all