we want to calculate a gross amount of money that after interest is added gives a gross amount of money, but then when we have the gross can remove the interest and get back to the net value.
i.e. we know
Net Amount = 100000
One-off charge = 2%
Interest = 1% over 3 months = 3%
can we find the gross figure (we think it is 105250) that when we back calculate to the net gives us the 100000 again.
Our problem is that if we take the calculated gross of 105250 and take 5% off we get 99987.5
no matter what we do we cannot work a formula out that would give us an accurate gross that when the 5% is removed off it gives us the 100000 again.
Is it the way the back calulation is done and you can never get back to the original, we are totally puzzled.
The best we can do is:
Gross = 100000 + (100000+((0.02+0.03) x 100000)) x (0.02+0.03)
but again this gives us 105250 that if you do:
5% of 105250 is 5262.50
105250 - 5262.50 = 99987.50
which is not 100000 :?:
Please help.