With the above data of a portfolio, please compute the following:

1. Daily log returns

2. The average daily log return

3. The volatility (standard deviation) on daily log returns

4. Convert daily log returns AND volatility to annualized

5. Find the TBill rate (use 3%)

6. Compute the sharpe ratio

Please show the formulas used in excel, thank you!

Date Liquidating Value Log Return 10/1/18 $102,000.00 10/2/18 99,000.00 10/3/18 101,000.00 10/4/18 $ 98,000.00 10/5/18 97,500.00 10/8/18 97,000.00 10/9/18 s 98.500.00