Open calculator ↗

Practice buy-in price and debt service · Calculation guide

Use agreed practice equity value after existing debt, the share purchased, transaction costs and upfront cash.

Calculation guide

Finance the remainder with a fully amortizing monthly loan.

payment = pmt(max(0,equity*share/100+fees-cash),rate,months) · buyin = equity*share/100

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

InputValue
Agreed practice equity value600,000
Ownership share purchased (%)25%
Transaction costs10,000
Cash contributed40,000
Nominal annual loan rate (%)0%
Loan term in months60
ResultValue
Monthly debt service2,000
Price of ownership share150,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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Agreed practice equity value600,000660,000Monthly debt service2,0002,250
Ownership share purchased (%)25%28%Monthly debt service2,0002,300
Transaction costs10,00011,000Monthly debt service2,0002,016.666667
Cash contributed40,00044,000Monthly debt service2,0001,933.333333
Nominal annual loan rate (%)0%1%Monthly debt service2,0002,051.249693
Loan term in months6066Monthly debt service2,0001,818.181818
Practice buy-in price and debt service →

Sources