How to Model Syndication Returns in a Spreadsheet: An XIRR Walkthrough for LPs
A step-by-step guide to building your own syndication return model in Excel or Google Sheets using XIRR. Build the cash flow ladder, compute IRR and equity multiple from scratch, and stress-test sponsor pro formas before you wire.
9 min read