I am trying to make a formula from known results that I have, but as I did basic maths at school I have no idea where to start. I had 2 tables, the first one was similar to:
The resulting formula here was easy, the percentage on the side divided by the 8%, which gave the results above, eg 5%/8% = 0.625. However, table 2 is far more complex, and way over my head:
I was asked to find out what would happen to our subsidiary company if the 8% fell to 7%.
Im good with excel, and want to make up a calc sheet to find out the answer, but previously I used our internal software to get info, and it only goes as low as 8%, and the company that made our company software went belly up, and no one here knows the formula that gave the original results.