SPREADSHEET PROJECT GUIDELINES This project MUST be done on an ex

Home / Questions / SPREADSHEET PROJECT GUIDELINES This project MUST be done on an excel spreadsheet and be su

SPREADSHEET PROJECT GUIDELINES This project MUST be done on an excel spreadsheet and be su

This project MUST be done on an excel spreadsheet and be submitted to me AS ONE SPREADSHEET.

You will need to collect the stock price data for any 2 companies of your choice and the S&P 400 index. Choose companies that are in different industries. Collect the end-of-month prices for the last 21 months of your chosen stocks and the S&P 400 and set them on the spreadsheet. Taking this raw data, compute the monthly returns for all (there should be 20 returns). Make sure that I am able to see the cell formulas for each computation.

Next, compute the mean rate of return and the standard deviation of returns for both your stocks and the stock market. Compute the beta value for each stock and plot the characteristic lines on 2 graphs. Compute the correlation coefficient for the 2 stocks. Plot the returns of your stocks against each other on a graph within the spreadsheet.

Next, assume that you construct a portfolio where you put equal money in each of your 2 stocks. Compute the 20 monthly rates of return for the portfolio and the standard deviation of returns of the portfolio. Finally, within the spreadsheet discuss in DETAIL your findings regarding risk/return of your portfolio as compared to the risk/return characteristics of the 2 individual stocks. These comments must be detailed with a complete analysis.

Rosa Parks 07-Nov-2017

Answer (UnSolved)

question Get solution

Qantas Airways is the flag carrier airline of Australia Qantas Airways is the flag carrier airline of Australia. Qantas' headquarter is located at the Qantas Centre in the Mascot suburb of Sydney, New South Wales. The Qantas G...
Each service and the in charge engineer Each service and the in charge engineer, the parts used, the problem fixed and service log for an aircraft will be recorded in the database. The management must make sure...
Each flight maintains an inventory table for consumable products Each flight maintains an inventory table for consumable products. The inventory will be refilled at end of each trip. The management wants to analyze the high costs of pr...
Customers can pay their purchased tickets by cash Customers can pay their purchased tickets by cash, cheque, bank card, visa card, master cards and frequent flyer point. The payment by American express card will be charg...
Qantas management is to ensure the successful completion Qantas management is to ensure the successful completion of around 300,000 flights every year to 57 airports around Australia and to 86 destinations in 36 countries that ...
In the initial lectures on the economic way of thinking In the initial lectures on the economic way of thinking we considered the description of cost-benefit analysis in macroeconomics offered by Henry Hazlitt. Some years bac...
Students will select and critique a media article Students will select and critique a media article on a crime topic using the Toulmin framework. See the “Assessment 4 Article Options” document for the articles that you...
The class of Qantas frequent flyer membership The class of Qantas frequent flyer membership is based on flying more for higher-level class. The types of memberships are based on distance flown, with bonuses that vary...
All Qantas Line Maintenance Stations can communicate with inbound aircraft provides All Qantas Line Maintenance Stations can communicate with inbound aircraft provides 24 hours per day for advice on incoming defects, facilitating the preparation of appro...
To promote the better services to VIP members and award customers To promote the better services to VIP members and award customers’ loyalty, Qantas provide the airline lounge with airport locations around Australia and the world. Those...

Service

SPREADSHEET PROJECT GUIDELINES This project MUST be done on an excel spreadsheet and be su

SPREADSHEET PROJECT GUIDELINES This project MUST be done on an excel spreadsheet and be su

Answer (UnSolved)

Ask Homework Question

Writing Help

Have a language expert improve your writing

Instant response from experts on your writing help queries

Find your question's answer instantly in our Q&A bank