Hedging Assignment for Chapter 3 Download the daily prices of 4 stocks and a stock index which has a futures contract. Compute the daily returns, the individual beta and portfolio beta (i.e., the optimal hedge ratio) of the equally-weighted 4-stock portfolio using Excel. Suppose you have invested 1 million unit of local currency each in the 4 stocks, compute number of stock index futures contract of that market you need to use in order to hedge your stock portfolio. Due date: submit the Excel file to Ummoodle by 21 March 2022. You can also monitor the performance of the hedged stock portfolio on a weekly basis. If the hedge works, the portfolio value should be very stable. Losses (gains) in the stock portfolio will be offset by gains (losses) in the stock index futures.