Calculation guide
Pool two property sales. Pay closing expenses and debt, return contributed capital, pay accrued preference, then split the residual profit. Any shortfall is reported separately.
Inputs
First property sale price
Example entry 600000 (in the selected currency).
Second property sale price
Example entry 400000 (in the selected currency).
Combined selling expenses
Example entry 50000 (in the selected currency).
Combined debt payoff
Example entry 500000 (in the selected currency).
Investor capital outstanding
Example entry 300000 (in the selected currency).
Accrued investor preference
Example entry 50000 (in the selected currency).
Investor share of residual profit
Example entry 80 %. Allowed range 0.0 to 100.0.
Worked example
| Input | Value |
|---|---|
| First property sale price | 600,000 |
| Second property sale price | 400,000 |
| Combined selling expenses | 50,000 |
| Combined debt payoff | 500,000 |
| Investor capital outstanding | 300,000 |
| Accrued investor preference | 50,000 |
| Investor share of residual profit | 80% |
| Result | Value |
|---|---|
| Cash available to distribute | 450,000 |
| Investor capital returned | 300,000 |
| Preference paid | 50,000 |
| Sponsor distribution | 20,000 |
| Total investor distribution | 430,000 |
| Additional cash required at sale | 0 |
Calculation steps
Cash available to distribute = max(0, (((First property sale price + Second property sale price) − Combined selling expenses) − Combined debt payoff))
max(0, (((600,000 + 400,000) − 50,000) − 500,000)) = 450,000
Investor capital returned = min(Cash available to distribute, Investor capital outstanding)
min(450,000, 300,000) = 300,000
Preference paid = min(Accrued investor preference, (Cash available to distribute − Investor capital returned))
min(50,000, (450,000 − 300,000)) = 50,000
Sponsor distribution = (((Cash available to distribute − Investor capital returned) − Preference paid) × (1 − (Investor share of residual profit ÷ 100)))
(((450,000 − 300,000) − 50,000) × (1 − (80 ÷ 100))) = 20,000
Total investor distribution = (Cash available to distribute − Sponsor distribution)
(450,000 − 20,000) = 430,000
Additional cash required at sale = max(0, (((Combined selling expenses + Combined debt payoff) − First property sale price) − Second property sale price))
max(0, (((50,000 + 500,000) − 600,000) − 400,000)) = 0
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| First property sale price | 600,000 | 660,000 | Cash available to distribute | 450,000 | 510,000 |
| Second property sale price | 400,000 | 440,000 | Cash available to distribute | 450,000 | 490,000 |
| Combined selling expenses | 50,000 | 55,000 | Cash available to distribute | 450,000 | 445,000 |
| Combined debt payoff | 500,000 | 550,000 | Cash available to distribute | 450,000 | 400,000 |
| Investor capital outstanding | 300,000 | 330,000 | Investor capital returned | 300,000 | 330,000 |
| Accrued investor preference | 50,000 | 55,000 | Preference paid | 50,000 | 55,000 |
| Investor share of residual profit | 80% | 88% | Sponsor distribution | 20,000 | 12,000 |
