I have a fixed budget to buy a property.
That budget has to cover the purchase price, but also the costs of purchase such as finance and tax. What I want to know is how much do I have for the actual purchase price. The problem is the costs are not fixed, the costs are based on actual purchase price. Some of the costs are not even a fixed percentage, the percentage varies depending on the actual purchase price. The budget is fixed.
This is what it looks like:
| Available for site purchase | | | | | | | £865,368 |
| | | | | | | | |
| Interest (years) | | 1.50 | 10.00% | £108,000 | | | |
| Loan application fee | | | 1.00% | £7,200 | | | |
| Valuation fee | | | 0.10% | £720 | | | |
| Legal fees | | | 0.50% | £3,600 | | | |
| Land registry charge | | | | £135 | | | |
| SDLT | | | | £26,000 | | | |
| Property purchase | | | | £720,000 | | | |
| | | | | | | | |
| | | | | £865,655 | | | |
For SDLT there is a very complex calculation on another sheet. For now I am manually changing the property purchase price so that the total is similar to the available for site purchase price at the top, but how do I get excel to do this for me?
Thank you for you help everyone.
