Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

not sure how to calculate returns on excel price column to your assigned company name. 4. Merge the company and SPY data. Keep the columns

not sure how to calculate returns on excel
image text in transcribed
price column to your assigned company name. 4. Merge the company and SPY data. Keep the columns for date, company close and SPY close and delete the rest. 5. Calculate returns [(P1PO)/PO]100 for your company and SPY. Select the date, company return and SPY return and insert a chart XY scatter with smooth lines and markers. 6. Calculate the mean and the standard deviation of your company returns and SPY returns using the excel functions AVERAGE and STDEV. 7. Calculate beta for your company. Use the Excel Slopeh function (company returns are Y s, SPY returns are X s). Compare the results to the posted beta for your company in Yahoo finance

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

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

Public Finance And Public Policy

Authors: Jonathan Gruber

7th Edition

1319281109, 9781319281106

More Books

Students also viewed these Finance questions

Question

1. How did Perth and Western go about restructuring?

Answered: 1 week ago

Question

| What is it that I am authentically interested in accomplishing?

Answered: 1 week ago