You know the moment. The model says the deal works, and the first investor question is “what did each party actually earn?” Then you are tracing promotes, fees, and pref accrual across tabs to reconcile LP and GP outcomes.
It is slow, easy to get wrong, and tough to present cleanly. Most of the time goes to stitching together a gross to net story people will believe.
How it works
Give Vic your cash flows by party or your model output. Add waterfall terms if you have them, and current NAV if you want an as of view. If format matters, say so. Then run: Use Vic to calculate partnership returns by party for a real estate investment using provided cash flows and waterfall terms.
Vic returns an Excel file you can use right away. It includes a by party returns table for LPs and GPs with gross and net IRR, equity multiples, DPI, RVPI, TVPI, and MOIC. It tracks preferred return accrual and shows where you stand against the hurdle. You also get the supporting cash flow streams so you can audit where every dollar came from.
The file includes a gross to net bridge that makes the economics easy to read. Fees and promote show how value moves from gross to net so you can explain results without walking through formulas. There is also a short written summary that states what each party earned in plain language, ready to drop into a memo or email.
This works well for joint ventures and fund level deals where attribution matters. GPs can see how promote and fees translate into net results. LPs can see distributions versus remaining value through DPI and RVPI, along with TVPI. Asset managers can check pref accrual and whether the deal has cleared the hurdle.
The payoff is clarity and speed. Instead of maintaining a fragile set of tabs, you get a consistent output that follows common formatting and number conventions. It is easier to review internally and easier to send out. And because the supporting streams are there, questions do not send you back to rebuild the bridge.
Teams that move quickly feel the difference. Work that used to take close to two hours of modeling and reconciliation comes back in about ten minutes, with a cleaner answer.


