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 (what formula)

Whare are the steps to complete this task?

What are the logistics to finding 2011 and CAGR information?

	2006	2007	2008	2009	2010	2011	CAGR
Visible Trade Balance (ZOEbn)	7.1	6.5	0.6	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
Foreign direct investment (ZOEbn)	9.5	9.2	12.8	11.3	11.6	12.2	5.12
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)	26.20	5.09	6.80	4.80	3.70	2.27	-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	7.60	7.92	9.15	9.55	10.5	10.44