Calculation guide
Finance the remainder with a fully amortizing monthly loan.
Inputs
Agreed practice equity value
Example entry 600000.0 (in the selected currency).
Ownership share purchased (%)
Example entry 25.0 %. Allowed range 0 to 100.
Transaction costs
Example entry 10000.0 (in the selected currency).
Cash contributed
Example entry 40000.0 (in the selected currency).
Nominal annual loan rate (%)
Example entry 0.0 %. Allowed range 0 to 100.
Loan term in months
Example entry 60.0. Minimum 1. Use whole numbers.
Worked example
| Input | Value |
|---|---|
| Agreed practice equity value | 600,000 |
| Ownership share purchased (%) | 25% |
| Transaction costs | 10,000 |
| Cash contributed | 40,000 |
| Nominal annual loan rate (%) | 0% |
| Loan term in months | 60 |
| Result | Value |
|---|---|
| Monthly debt service | 2,000 |
| Price of ownership share | 150,000 |
Calculation steps
Monthly debt service = payment(max(0, ((((Agreed practice equity value × Ownership share purchased (%)) ÷ 100) + Transaction costs) − Cash contributed)), Nominal annual loan rate (%), Loan term in months)
payment(max(0, ((((600,000 × 25) ÷ 100) + 10,000) − 40,000)), 0, 60) = 2,000
Price of ownership share = ((Agreed practice equity value × Ownership share purchased (%)) ÷ 100)
((600,000 × 25) ÷ 100) = 150,000
Interpreting the result
The monthly debt service shows the cash requirement for financing the buy-in after upfront equity.
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 |
|---|---|---|---|---|---|
| Agreed practice equity value | 600,000 | 660,000 | Monthly debt service | 2,000 | 2,250 |
| Ownership share purchased (%) | 25% | 28% | Monthly debt service | 2,000 | 2,300 |
| Transaction costs | 10,000 | 11,000 | Monthly debt service | 2,000 | 2,016.666667 |
| Cash contributed | 40,000 | 44,000 | Monthly debt service | 2,000 | 1,933.333333 |
| Nominal annual loan rate (%) | 0% | 1% | Monthly debt service | 2,000 | 2,051.249693 |
| Loan term in months | 60 | 66 | Monthly debt service | 2,000 | 1,818.181818 |
