As a financial manager for a large multinational corporation (MNC), you have been asked to assess the firm's economic exposure. The two major currencies, other than the U.S. dollar, that affect the company are the Mexican peso (MP) and the British Pound (£). You have been given the projected future cash flows for the next year:

The current expected exchange rate in U.S. dollars with respect to the two currencies is as follows:

Create an excel spreadsheet to do the following:
a. Determine the net cash flows for both the Mexican peso and the British pound.
b. Determine the net cash flows as measured in U.S. dollars. It will represent the value of the economic exposure.
c. If the movements in Mexican Peso and the British Pound are highly correlated, how will this affect the company's degree of economic exposure?

Currency British Pounds Total Inflow Total Outflow 11,000,000 17,000,000 MP 100,000 MP 25,000,000 Mexican Pesos Currency Exchange Rate British Pounds $1.66 per pound Mexican Pesos $0.10 per peso