You know the moment. The cash number is set, investors want a timeline, and you are staring at a spreadsheet that grew one tab at a time across deals. You need to split dollars across return of capital, pref, and promote, and make sure every line ties. This is where small mistakes turn into long email threads. One wrong percentage or a missed tier creates noise with LPs and slows the close of a distribution. Asset Management ~10 min to run Build a Distribution Schedule Vic prompt Use Vic to build a distribution schedule for a specified cash distribution using the investor schedule and waterfall terms. Purpose Accurate distribution schedules reduce errors and disputes with investors. The task completes in roughly 10 minutes instead of 90. Inputs Distributable Cash Required Investor Schedule Required Waterfall Terms Optional Output Format Optional Outputs An .xlsx file with per-investor rows, component columns, totals, per-investor percentages, cumulative distributions, DPI where paid-in capital is supplied, and an explicit reconciliation check. A short summary and flagged assumptions are included. Time saved Turns roughly 90 minutes of manual work into about 10 minutes. How it works Run the task with a simple instruction: "Use Vic to build a distribution schedule for a specified cash distribution using the investor schedule and waterfall terms." Provide the distributable cash and an investor schedule. If you have waterfall terms, include them. If not, the task calls out assumptions so you can confirm before sending anything out. The output is an .xlsx file built for review and distribution. There is an editable inputs block at the top, then one row per investor. Each row shows the split of cash into return of capital, preferred return, and profit or promote. Those components add up to the investor’s total distribution, so you can see where every dollar goes. The file includes a GP row and overall totals. It also includes a clear PASS or FAIL reconciliation that checks whether the sum of all components matches the stated distribution amount. That check is what keeps you from a late-night audit before wires go out. You also get per-investor percentages and cumulative distributions. If you supply paid-in capital, the schedule calculates DPI at the investor level. The file stays useful after this run. It becomes a record you can carry forward. Formatting is consistent. Numbers are easy to read, columns use plain labels, and the layout is ready to share with LPs or your team without a redesign. There is a short written summary, and any assumptions are stated plainly instead of buried in formulas. What matters here is control. You set the inputs and the terms. The task handles the mechanics that take most of the time and are easy to get wrong under pressure. Instead of rebuilding a model or copying from the last deal, you get a fresh schedule that ties on the first pass. For GPs and asset managers who run frequent distributions, the time savings are real. About ten minutes to produce a file that might otherwise take ninety. It also cuts the back and forth with investors because the math is transparent and reconciled. If your process depends on a legacy workbook that only one person fully understands, this is a cleaner option. The schedule is easy to audit, simple to update, and clear about how each component is calculated. That tends to reduce friction with LPs and your accounting team. Use it when you have a distribution to run and a list of investors. Provide the cash number, confirm the terms, and send a file that ties to the dollar.