Question:
Year 1 sales = 110 million euros
Year 2 sales = 130 million euros
Year 3 sales = 150 million euros
Year 4 sales = 175 million euros
Year 5 sales = 190 million euros
The forecasted exchange rate for euros to U.S. dollars is between 0.40 to 1.20 (which is 0.40 euros/US$1 to 1.20 euros/US$1), and the current exchange rate is 1 euro for US$1. You decide to use these two extreme points to analyze how European revenue would translate to U.S. dollars over the 5-year time period.
Use Microsoft Excel to analyze the European net sales translated into U.S. dollars based on the two exchanges rates and how that would differ from the current exchange rate.