International Financial Management

profileAmazingExpert
spreadsheet.xlsx

Sheet1

Country Currency White sugar 1kg Price in local currency Actuall Dollar exchange rate on 09/2/2014 White sugar 1kg price in dollars implied PPP of the dollar Under/over valuation against dollar
United States US Dollar 2 - 2 - -
New zeland New zeland Dollar 2.5 1.20685 2.0715084725 1.25 -0.5
Norway Krone 16 6.1783 2.5897091433 7.72384 -0.51726
Singapore Singapore Dollar 1.9 1.26681 1.4998302824 0.733673125 -0.61385625
South africa Rand 10 11.0537 0.9046744529 6.6674210526 -0.3332578947
Swizerland Swish frank 1.5 0.898958 1.668598533 1.658055 0.10537
Italy Euro 1.2 0.910078 1.3185682985 0.7191664 -0.4006946667
England Pound 0.94 0.60944 1.5423995799 0.7128944333 -0.2416016667
Australia Australia Dollar 1.54 1.11626 1.3796069016 0.9984442553 -0.3516595745
Canada Canadian Dollar 1.58 1.10401 1.431146457 1.1452537662 -0.2751558442

Sheet2

Sheet3