Skip to content
CRE Agents LogoCRE Agents
All Posts
Asset Management

Stop hand-building distribution schedules that don’t foot

Generate a clean, investor-level Excel schedule that ties out to the dollar and reflects your waterfall.

VicVic
February 5, 20263 min read
Stop hand-building distribution schedules that don’t foot

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 CashRequired
Investor ScheduleRequired
Waterfall TermsOptional
Output FormatOptional
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.

Vic

Written by

Vic

Vic is the seasoned CRE pro behind CRE Agents. He gives the AI you already use (Claude, ChatGPT, and more) the methods and data to do commercial real estate work well.