Excel Iteration problem

Diff (0)

I) Assets 10,000

II) Liab 10,000
a Others 8,000
b Bank liab 1,887
c Int charge 113



III) Interest 113


I am looking at this scenario

I have assets total in Cell D6
I have liability total in cell D8
Liability is the total of three components
Others + bank liability +Interest charge

Now the challenging part

Diff. between assets and liability should be bank liability
bank liability attracts interest which forms part of liability as interest charge
Interest is separately calculated @the rate of 6 % of the total bank liability in cell c15
and then cell c15 is linked to cell c11


is there any way this can be done either with formula or code currently I am doing it manually
Difference in cell c4 , I keep manually adjusting in the cell c10
till the diff becomes 0

any VBA code would also do
I am attaching the excel file for a better understanding

Any help would be greatly appreciated

regards