Please use excel to solve. The problem and the data provided must be clearly laid out in the spreadsheet and cell referencing must be used

4. Currently a stock index stands at 100 and the leveraged ETF is selling for $100. The ETF should generate a return that is twice the daily return on the index. Over the next 21 days the value of the index and its daily percentage change are as follows: Value of the Index Daily Percentage Change 100 10.0% - 9.1 Day -10.0 -11.1 - 12.5 28.6 22.2 18.2 130 100 105 -23.1 101 105 106 109 126 100 8.2 2.8 15.6 -20.6 What is the value of the ETF at the end of each day? Notice that at the end of 21 days, the index is back to its starting value of 100. What is the value of the ETF at the end of 21 days? Suppose that on day 22, the index rises 50 percent from 100 to 150; what is the percentage change in the ETF from day 1 through day 22? If you bought the ETF on day 1 and held it through day 22, did you earn the leveraged return that you expected