Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi, I would like help in the explanation of the image attached in regards to finance 4) 3) Calculate monthly return of Apple Inc. in

image text in transcribedimage text in transcribed

Hi, I would like help in the explanation of the image attached in regards to finance

image text in transcribedimage text in transcribed
4) 3) 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. (1) 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. Instruction for question 4 :` 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 . Explanations for Adjusted Close Price can be found here :" https : / / help . yahoo . com / Kb / SLN 28256 . html 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 +(1 )* ( 1 + [ 2 )* ( 1 + 1 3 )* ( 1 + [ 4 )* .. .* ( 1 + [ 30 ) = ( 1 + [ monthly ) 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 using this formula :" 8 - LA - 1 (`; - 1 ) 2) N - 1 For part D: Think ! or search it online @

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Reporting and Analysis

Authors: Flawrence Revsine, Daniel Collins, Bruce, Mittelstaedt, Leon

6th edition

9780077632182, 78025672, 77632184, 978-0078025679

Students also viewed these Finance questions

Question

Please make it fast 4 9 1 .

Answered: 1 week ago