Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started