You have the following dates with corresponding liquidating values of your portfolio on that day. Please compute the following (while showing your excel formula):

1. The daily log return

2. The average daily log return

3. The volatility (standard deviation) of the daily log returns

4. The daily log return converted to annual

5. The daily volatility converted to annual

6. The risk free rate (use 3%)

7. The Sharpe Ratio

Please show your excel formulas, thank you!

Liquidating Value 1000 950 800 890 980 Date Daily Log Return 9/16/18 9/18/18 9/19/18 9/20/18