As one of your first assignments as a new hire on the corporate treasurers staff of Global Enterprises, Ltd., you are asked to prepare an exchange rate forecast for the Zonolian ecru (ZOE). Specifically, you are expected to forecast what the spot rate for the ecru is likely to be at the end of 2011. Selected information on which to base your forecast follows. Be sure to identify any additional bases underlying your forecast and any assumptions.
The following chart is the answer that was posted, (columns 2011 and CAGR were the answers-the other information was given) my additional questions are:
How was this calculated in Excel?
Where are the steps to complete this task?
What are the logistics to finding 2011 and CAGR information?

Transcribed Image Text:

2006 2007 2008 2009 2010 2011 CAGR 0.6 Visible Trade Balance (ZOEbn) 6.5 7.1 27.7 25.4 34.9 37.53% Current account balance (ZOEbn) 21.6 21.9 27.3 215.8 213.8 379 77.37 5.12 Foreign direct investment (ZOEbn) 9.5 9.2 12.8 11.3 11.6 12.2 Portfolio flows (ZOEbn) 29.7 13.4 5.0 20.6 9.6 7.24 -24.60 Foreign exchange reserves (ZOEbn) 15.25 19.18 28.14 31.46 30.99 37 19.40 Real GDP growth (% change yoy) 2.27 26.20 5.09 6.80 4.80 3.70 -38.70 Consumer prices (% changes yoy) 51.97 27.70 15.72 18.60 12.32 8.6 -30.22 Nominal GDP (ZOEbn) 266.0 335.0 412.0 415.0 479.0 555 15.84 Nominal exchange rate to U.S.$ 6.42 9.55 7.60 7.92 9.15 10.5 10.44