Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Return MSFT SPY Return MSFT SPY Obser. Date Adj Price Adj Price Obser. Return Return 0 6/1/2013 28.72191 132.3582 0 - - 1 7/1/2013 26.47672

Return MSFT SPY Return MSFT SPY
Obser. Date Adj Price Adj Price Obser. Return Return
0 6/1/2013 28.72191 132.3582 0 - -
1 7/1/2013 26.47672 139.9345 1
2 8/1/2013 27.77394 135.7376 2
3 9/1/2013 27.86916 139.354 3
4 10/1/2013 29.65286 146.5177 4
5 11/1/2013 31.93062 150.8601 5

Provide the excel formula used to get the answer. Using the prices provided, calculate the monthly returns for MSFT and SPY, where rt = (Pt/Pt-1) 1; which is the same as [(Pt-Pt-1)/ Pt-1]. For example, R1 = (P1/P0) - 1 Note that the monthly data is listed from June 2013 to June 2023So be careful with your return formula! There are 121 monthly prices given so you can calculate 120 monthly returns. You must post monthly returns as decimals to 6 places or as percentages to 4 places. For example, average return for MSFT may be written as either: .009999 or .9999%.

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

Students also viewed these Finance questions