answer in excel

Use the following financial information to answer the questions that follow: Dow Chemical $57 Billion 5.5% 12% BASF $95 Billion 6.3% 19% Revenue Net Profit Margin ROE ROA Stock Price Dividend yield EPS 3.75% $40 3.3% $2.32 6.4% $104 0% $6.60 With an annual discount rate of 3%, $10 million at the beginning of each year for the next 20 years, is worth how much today? A year ago oil was selling for $60 a barrel and the JPY per USD exchange rate was 108.2. Today oil is selling for $40 a barrel and the exchange rate is 109.6 JPY per USD. A Japanese investor bought the oil a year ago and sold it today, how much would she have made in JPY? What has happened to the value of the USD relative to the JPY over the last year? Did the change in the exchange rate help the Japanese investor or hurt? Explain With an annual discount rate of 3%, $10 million at the beginning of each year for the next 20 years, is worth how much today