Here is an interesting one. I have inherited a work sheet that works out effective rate changes over two static periods (i.e. 2004/2005)but it has been an issue for me due to exchange rate changes each year.
The worksheet is supposed to be completed in USD but Iam finding that the exchange rates are making the effective rate changes way too high i.e. -48%.
Knowing this is incorrect I created the sheet in the original currency and when you compare the years, the change is only -16.2%, which is correct.
To get the correct answer(-16.2%) using the correct worksheet(usd) Im having to trial an error a figure into the Subjective section which comes to 749 in my example attached.
My question (after all the above :)) is how can I understand what this figure is or means (749). It simple to say to my boss oh it works but Im having to do two worksheets rather than the USD one! If anyone knows what this 749 is based on or how I can understand this I will be enternally grateful
depressed but hopeful steve