Hi!

I have trouble finding a solution to a problem regarding a budget. I have to list a 10% guarantee as a cost when calculating earnings. But my problem is that the guarantee is dependent on earnings and should be 10%. I can solve the problem below to get X=X by many trials and errors, but would have been even better to get excel to output this straight away. But I havent gotten around the problem with circle references. Anyone have any suggestions? Any help is much appreciated!

+ Income 1000
- Costs 500
- Guarantee (10% of Earnings) X
= Earnings 500
10% of Earnings X