Calculation guide
Selling costs are a percentage of resale value, buying costs a percentage of the offer. Enter all fixed renovation, holding and finance costs once. A negative ceiling signals an infeasible target.
Inputs
Expected resale price
Example entry 350000 (in the selected currency).
Selling costs as share of sale
Example entry 6 %. Allowed range 0.0 to 100.0.
Renovation, holding and finance costs
Example entry 76900 (in the selected currency).
Target profit before tax
Example entry 40000 (in the selected currency).
Purchase costs as share of offer
Example entry 1 %. Allowed range 0.0 to 100.0.
Worked example
| Input | Value |
|---|---|
| Expected resale price | 350,000 |
| Selling costs as share of sale | 6% |
| Renovation, holding and finance costs | 76,900 |
| Target profit before tax | 40,000 |
| Purchase costs as share of offer | 1% |
| Result | Value |
|---|---|
| Maximum purchase offer | 210,000 |
| Net sale proceeds before project costs | 329,000 |
Calculation steps
Maximum purchase offer = ((((Expected resale price × (1 − (Selling costs as share of sale ÷ 100))) − Renovation, holding and finance costs) − Target profit before tax) ÷ (1 + (Purchase costs as share of offer ÷ 100)))
((((350,000 × (1 − (6 ÷ 100))) − 76,900) − 40,000) ÷ (1 + (1 ÷ 100))) = 210,000
Net sale proceeds before project costs = (Expected resale price × (1 − (Selling costs as share of sale ÷ 100)))
(350,000 × (1 − (6 ÷ 100))) = 329,000
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 |
|---|---|---|---|---|---|
| Expected resale price | 350,000 | 385,000 | Maximum purchase offer | 210,000 | 242,574.257426 |
| Selling costs as share of sale | 6% | 7% | Maximum purchase offer | 210,000 | 206,534.653465 |
| Renovation, holding and finance costs | 76,900 | 84,590 | Maximum purchase offer | 210,000 | 202,386.138614 |
| Target profit before tax | 40,000 | 44,000 | Maximum purchase offer | 210,000 | 206,039.60396 |
| Purchase costs as share of offer | 1% | 2% | Maximum purchase offer | 210,000 | 207,941.176471 |
