a) Calculate monthly return of Apple Inc. in Dec. 2018.
b) Considering daily risk free rate as 0.01% per day (0.01% = 0.0001), calculate monthly excess return of Apple Inc. in Dec. 2018.
c) Assume Apple Inc. performance in April 2019 will be very similar to its performance in Dec. 2018. Calculate Sharpe Ratio of Apple Inc. using Dec. 2018 data.
d) Consider monthly risk free rate as 0.3%. Calculate annual risk free rate. While you should follow the formula mentioned in instruction below, you cannot use multiplication in your calculations needed in this part.

Go to Yahoo Finance. Enter Ticker symbol of Apple Inc (which is AAPL) into the search field. Click Historical Data. Select Time Period of first and last day of Dec. 2018. Set Show: Historical Prices. Set Frequency as Daily. Then click Apply. Then click Download Data (see it just below Apply tab). The file will be downloaded automatically in CSV format. Open the file and save it as Excel format first. You can see date, Open (daily open price), Close (daily close price), High and low (daily maximum and minimum prices), Volume (number of shares traded), and Adjusted Close price.

We need Date, Open, and Adjusted Close. Using Open and Adj. Close you can calculate daily holding period return: [(Adj. Close) â€“ (Open)]/(Open).

Now using the logic of compounding we calculate monthly return (Assuming the month has 30 days) by daily return:
(1+r1)*(1+r2)*(1+r3)*(1+r4)*â€¦*(1+r30) = (1+rmonthly)
For part B: The same as what you did above, just first calculate daily excess return by excluding daily risk free rate of 0.01% from daily return. Then using daily excess returns we can calculate monthly excess return using the above formula.

For the last part (part C). Just calculate the Standard Deviation.

a) Calculate monthly return of Apple Inc. in Dec. 2018. b) Conside...