Monthly Returns for Microsoft Corporation - Accounting and Finance Assignment Help

Assignment Task:

Task:

General Instructions:
1. You need to collect input data for this task. Obtain the monthly returns for Microsoft Corporation (symbol: MSFT), Walmart (symbol: WMT), and S&P500 index (symbol: ^GSPC) from January 1, 1990 through December 31, 2019. Put these into a spreadsheet.

You can easily obtain monthly prices (split- and dividend-adjusted) from Yahoo Finance by choosing to view a table of monthly prices from January 1, 1990 through December 31, 2019 (see Historical Data tab). Then choose to 'Download Spreadsheet Format'. Convert the prices to returns, then use a spreadsheet to do the tasks and answer the questions bellow. Make sure to use the Adjusted Close Prices in all of your calculations. Also, pay attention to how the data are sorted. I recommend sorting the data from oldest to newest to make sure that the calculated returns are lined up with the correct date (month).

2. You will also need risk free interest data for this . Go to Canvas course website, click on the Tasks folder and then click on “Rf monthly” file. The risk free rate is already converted to decimals, so you should not need to convert them in any way. Use the column that provides the risk free rate based on the monthly return because you are dealing with monthly returns for the stock and for the S&P 500.

This Accounting and Finance Assignment has been solved by our Accounting and Finance Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics.Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.