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:
.............8%
5%.......0.625
7.5%....0.938
10%.....1.250
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:
.............8%
5%.......0.429
7.5%....0.890
10%.....1.494
12.5%...2.233
15%......3.100
17.5%...4.092
20%......5.203
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.
Any help appreciated.