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
Loan application fee
Land registry charge
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?