Question: Determine the systematic risk (Beta) for the three shares. Interpret your answers. The use of excel functions should be used to calculate Beta (slope function

Determine the systematic risk (Beta) for the three shares. Interpret your answers. The use of excel functions should be used to calculate Beta (slope function in excel). What are the implications around the impact of an asset's price given the beta of each share?

Reference some documented limitations of beta when assessing market risk.

Exhibit 1 - Monthly Values for the Market Index and the Three Traded Shares. Month 1 2 3 4 5 6 7 8 9 10 11 12 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 7455 7499 7555 7505 7435 7579 7628 7579 7699 50 51 52 53 54 55 56 57 58 59 60 61 8095 8177 8099 8164 8299 8256 8177 8112 8193 8237 8312 9443 10.28 10.50

Exhibit 1 - Monthly Values for the Market Index and the Three Traded Shares. Month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Share Market Index 6782 6823 6873 6958 7012 7059 7088 7146 7089 7157 7286 7135 7229 7489 7564 7493 7412 Den Ltd 2.69 2.85 3.03 3.27 3.51 3.85 4.29 4.43 4.71 5.02 5.41 5.26 5.52 5.96 5.42 5.78 5.31 Zen Ltd 4.06 4.22 4.51 4.66 4.77 4.39 4.64 4.99 5.33 5.56 6.07 6.39 6.75 7.08 7.27 7.51 7.29 Omega Ltd 8.03 8.28 8.52 8.67 8.88 9.17 9.44 9.90 9.32 9.59 9.73 9.31 9.74 9.09 9.26 9.56 9.23

Step by Step Solution

★★★★★

3.40 Rating (153 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

SOLUTION IN DETAILS To calculate the systematic risk Beta for the three shares we need to first calculate the excess returns of each share relative to ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

It is budget season and Patrocinio Amable, Inc is planning for next year and requires a breakdown of the factory overhead cost into the fixed and variable elements. The following data on the OH cost...

Determine the transfer function from U(s) to Y(s) for the following block diagram. Provided are some recommended steps to take: a. Label each signal (line with arrow) b. Write the equation for each...

(20 points)Write a program that prompts the user to input five decimal numbers. The program should then add the five decimal numbers, convert the sum to the nearest integer, and print the result....

Exhibit 1 is the excel spreadsheet linked belowUsing the information given in Exhibit 1, calculate the historical returns for each company and the share market index. With the use of the excel...

Graph/photo is exhibit 1 Using the information given in Exhibit 1, calculate the historical returns for each company and the share market index. With the use of the excel functions calculate the...

Month Market Index (points) Hydro Ltd ($) Luna Ltd ($) 1 5745 21.00 0.56 2 5976 23.55 0.66 3 6057 21.99 0.71 4 6167 23.70 0.90 5 6147 23.90 0.90 6 6117 24.65 0.95 7 5869 24.06 0.93 8 6072 26.82 1.00...

Beta Den 0.0165497813 Beta Zen 0.1158299147 Beta Omega 0.1014130762 Question (use and show step by step in Excel): - Determine the systematic risk (Beta) for the three shares. Interpret your answer...

About the data: Loggers gathered information about a particular species of tree. A random sample was taken and the trunk diameter at breast height (in inches), tree height (in feet), and volume of...

Please help me answer question 4, 5 & 6. Background Information This assessment task requires your team to develop a written presentation based on information that your lecturer has collected for...

Monthly Values for the Market Index and the Two Traded Shares. Month Market index (points)Volcanic Ltd ($) Etna Ltd ($) 1 5600 10.00 16.12 2 5520 9.60 15.87 3 5410 9.00 15.05 4 5340 8.70 14.75 5 5465...

Why is ABC usually considered more accurate than traditional costing methods?

A gas consists of 20.0 mole% CH4, 30.0% C2H6, and 50.0% C2H4. Ten kilograms of this gas is to be compressed to a pressure of 200bar at 90C. Using Kays rule, estimate the final volume of the gas.

Which homeowners policy form do most single family homeowners choose because it provides the best value

The following scenario is based on an actual attack deconstructed at a seminar. The names and locations have been removed to preserve the privacy of the organization in question. Background:...

Describe the main elements of the simple majority/first past the post and proportional representation election systems.

Let E and H be two vectors assumed to have continuous partial derivatives (of second order at least) with respect to position and time. Suppose further that E and H satisfy the equations 1 JE VxH= ...

Assume you are a global manager responsible for an international subsidiary that has employees from many parts of the worldChina. India, Morocco, Brazil, and Spain. How will you go about learning how...

Discuss the transition from analysis to design and how to develop?

Question 17(4 points)What is the minimum size for a building fire command center?1) Not less that 299 square feet.Not less than 301 square feet100 square feet plus an additonal 10 square feet for...

Once again, we can use the CAPM to estimate MMMs cost of equity. Thomson One provides various estimates of betaselect the measure that you believe is best and combine this with your estimates of the...

Assume that you recently graduated with a major in finance, and you just landed a job as a financial planner with Merrill Finch Inc., a large financial services corporation. Your first assignment is...

Click on the tab labeled PRICES. What is the companys current dividend yield? What has been its total return to investors over the past 6 months? Over the past year? Over the past 3 years? (Remember...

Ten labs should be assigned to the circular floor plan shown below. Recalling a similar layout's congestion in the halls, the new lab manager has requested an assignment that will minimize traffic...

Visit http://manufacturing.stanfoixt.edu, click on How' Everyday Things Are Made, 1 choose a product from the left column (e.g., airplane, motorcycle, cars, jelly beans, bottles, wool, denim), click...

Draw a process flow diagram for customer service/eating in a full-service restaurant. Start when a customer arrives at the restaurant.