Excel - avoiding a circular calculation

Occasional Visitor

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.5010.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.

1 Reply
Hello @ Funkgroover
I guess I can offer you these resources because I am not sure exactly how your worksheet is laid out:
https://support.microsoft.com/en-us/office/remove-or-allow-a-circular-reference-8540bd0f-6e97-4483-b...
https://spreadsheeto.com/circular-reference/

If you could show us the formula that would be a good starting point.