the other screeshots are the data needed

3. You are considering investing in the S\&P500 index (as a New Zealander), and whether to hedge against exchange rate risk or not. If you hedge, you will rebalance your hedge on a monthly basis. The attached spreadsheet contains data on the S\&P500 index's value (as a total return index, so you do not have to worry about dividends), along with the US dollar/NZ dollar exchange rate, and 1 month interest rates for the two countries. (a) Calculate the value of the S\&P500 total return index in NZ dollars using the exchange rate. (b) Now calculate returns from this unhedged value. (c) What is the Sharpe ratio of the unhedged investment? (d) Use the one month interest rates, along with the exchange rates to calculate one-month forward exchange rates for each date. (e) Suppose that you hedge your position in the S\&P500 index each month, what would be your return (in $NZ )? (f) What is the Sharpe ratio of the hedged investment? 3. You are considering investing in the S\&P500 index (as a New Zealander), and whether to hedge against exchange rate risk or not. If you hedge, you will rebalance your hedge on a monthly basis. The attached spreadsheet contains data on the S\&P500 index's value (as a total return index, so you do not have to worry about dividends), along with the US dollar/NZ dollar exchange rate, and 1 month interest rates for the two countries. (a) Calculate the value of the S\&P500 total return index in NZ dollars using the exchange rate. (b) Now calculate returns from this unhedged value. (c) What is the Sharpe ratio of the unhedged investment? (d) Use the one month interest rates, along with the exchange rates to calculate one-month forward exchange rates for each date. (e) Suppose that you hedge your position in the S\&P500 index each month, what would be your return (in $NZ )? (f) What is the Sharpe ratio of the hedged investment