Tie to source documents
The model should cite the operating agreement, LPA, side letters, contribution ledger, and distribution approval memo.
Quick Answer
Use this as the first review pass for sponsor economics. The output should be reconciled to the governing agreement, investor side letters, tax allocations, and the final distribution approval file.2,3
Inputs
Output
LP proceeds
$2,200,000
GP promote
$300,000
LP MOIC
2.20x
GP share of profit
20%
| Tier | LP | GP | Control note |
|---|---|---|---|
| Return of capital | $1,000,000 | $0 | LP capital is returned before profit participation. |
| Preferred return | $320,000 | $0 | 8% simple annual preferred return over 4.0 years. |
| GP catch-up | $0 | $80,000 | GP catch-up brings the promote closer to the negotiated carry share. |
| Residual split | $880,000 | $220,000 | Remaining proceeds split 80% to LP / 20% to GP. |
This calculator is a planning tool. Final waterfall mechanics should tie back to the governing agreement, side letters, tax allocations, and the distribution approval record.
The model should cite the operating agreement, LPA, side letters, contribution ledger, and distribution approval memo.
If a side letter, tax allocation, escrow, clawback, or fee offset changes the output, save the exception record with the calculation.
Related definitions should remain one click away so reviewers can validate preferred return, catch-up, promote, and waterfall mechanics.
Treat the output as a review packet, not just a math answer. The LP proceeds, GP promote, preferred return, catch-up, and residual split should be exported into the distribution memo, checked against the capital account ledger, and reviewed against the exact waterfall language in the governing agreement. If the deal has escrows, holdbacks, fee offsets, tax distributions, clawback support, or side-letter economics, those items should be documented as separate adjustments before the final notice goes to investors.1,3
Related operating graph
Powered by Archstone
Operational infrastructure for sponsors, operators, SPVs, LP reporting, and capital calls.