Investment Banking

Credit Ratios and Covenant Modeling: A Practical Playbook Credit ratios are the yardsticks lenders and sponsors use to judge how […]

Sum-of-the-Parts (SOTP) Valuation: A Practical Guide Sum-of-the-parts valuation, often shortened to SOTP, values a conglomerate by estimating each segment’s standalone

Trading Comps: Build Audit-Ready Comparable Company Pages A trading comps model for investment banking is a simple tool with a

Accretion Dilution Analysis: Build, Test, and Present EPS Accretion dilution analysis estimates how a deal changes a buyer’s diluted earnings

Build a Public-to-Public Merger Model: Practical Guide A public-to-public merger model is a linked Excel build that forecasts combined financials,

Merger Model Essentials: Structure, Accounting, EPS Impact A merger model is a pro forma consolidation that translates a term sheet

DCF Modeling Checklist: Cash Flows, WACC, and Discipline A discounted cash flow model values a business by estimating the cash

Build an Audit-Ready DCF Model in Excel A discounted cash flow values a business by projecting future cash flows and

Cash Sweeps vs Revolvers: Modeling Without Loops A revolver is a committed credit line you can draw, repay, and draw

A cash flow statement explains where cash came from and where it went during a period. The indirect method starts