You know the moment. The deal is moving, the partner asks for the promote, and your spreadsheet is still a pile of tabs with half built tiers and a pref that does not quite tie. You can finish it by hand, but every tweak risks breaking something you will have to explain later. This task cuts that friction. It builds a complete, readable waterfall from your cash flows and terms, lays out the math, and adds checks so you are not chasing rounding errors on a review call. Underwriting ~15 min to run Build Equity Waterfall Model Vic prompt Use Vic to build an equity waterfall model from these deal cash flows and terms. Purpose Accurate waterfalls prevent disputes over promote calculations and speed review of sponsor economics. The model completes in roughly 15 minutes instead of the 150 minutes a manual build typically requires. Inputs Cash Flows Or Model Required Waterfall Terms Required Equity Split Optional Hold Period Optional Output Format Optional Outputs An editable Excel file with an inputs block for equity splits and hurdles, tier-by-tier cash allocation, accrual schedule, LP and GP totals with returns, and reconciliation checks that confirm tiers sum correctly. Time saved Turns roughly 150 minutes of manual work into about 15 minutes. How it works Give Vic your deal cash flows or your current model, plus the waterfall terms. At a minimum include the preferred return, any catch up, the carry structure, and the LP and GP split. You can also pass an explicit hold period and a preferred output format. Run it with a simple command: Use Vic to build an equity waterfall model from these deal cash flows and terms. Vic returns an editable Excel file. At the front there is an inputs block for equity splits and hurdles so you can change terms without digging through formulas. The model allocates distributable cash period by period across the standard tiers: return of capital, preferred return, catch up where applicable, and carry. Each period shows how cash splits between LP and GP, and the file rolls those into totals for each party. The model tracks preferred return accrual, so you can see what is owed before distributions clear the pref. It outputs IRR and equity multiple for both LP and GP, using the same cash flow series that drives the allocations. That keeps the story consistent when someone asks why the GP IRR moved after a term change. There are built in reconciliation checks. Tiers sum to the total distributable cash each period, and LP plus GP equals the whole at both the period level and in aggregate. If something is off, it shows up right away instead of three tabs later when totals do not tie. The practical benefit is speed and auditability. A manual build takes about 150 minutes if you include setting up tiers, wiring accruals, and testing edge cases. This task produces a working file in about 15 minutes. The structure is consistent and readable, which shortens partner review and cuts down on back and forth over whether the promote is calculated correctly. For GPs and fund managers, this means faster iteration on terms during negotiations. For underwriters, you can swap scenarios without reworking the model. Change the hurdle or the split in the inputs block and the allocations, returns, and checks update together. If you have ever had a waterfall questioned because a tier did not reconcile or a pref was applied inconsistently, you know the cost of a brittle file. This gives you a clean baseline you can hand over with confidence, then adjust as the deal evolves without rebuilding from scratch.