Question: The homework must be done with MS Excel ( IF YOU PREFER TO WRITE IN A WORD FILE, YOU MUST ATTACH YOUR EXCEL WORKSHEET )

The homework must be done with MS Excel(IF YOU PREFER TO WRITE IN A WORD FILE, YOU MUST ATTACH YOUR EXCEL WORKSHEET) 2. You need to write down all necessary steps/formulas leading to your results.Providing me with only the final answer will not receive any credit 3. Assignmentmust be submitted in MS Excel format. Do not paste in TXT format in the area below the Title.

Assignment Five

YearECBWCB

200440.00%40.00%

2005-10.00%15.00%

200635.00%-5.00%

2007-5.00%-10.00%

2008 15.00% 35.00%

a. What is the expected return and risk of each stock?

b. Measured by the standard deviation of returns, by how much would your uncle's risk have been reduced if he had held a portfolio consisting of 60% in ECB and the remainder in WCB?In other words, what is the difference between portfolio's standard deviation and weighted average of components' standard deviations? (Hint: check the example on page 11-12 on my note).

Economic

ConditionsProb.Return

Strong30%32.0%

Normal40%10.0%

Weak 30% -16.0%

StockInvestmentBeta

A$150,0001.40

B50,000 0.80

C100,0001.00

D75,000 1.20

What is the portfolio's beta?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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!

Assignment 2 Questions must be done with MS Excel ( IF YOU PREFER TO WRITE IN A WORD FILE, YOU MUST ATTACH THE EXCEL WORKSHEET) . 1. Bill and Bob are both 35 years old today. Each wants to begin...

You answer question 3? Given the nature of this homework assignment, it can be done completely in Excel. If you prefer to handwrite the non-regression parts, you can submit them separately or attach...

Can you answer question 1 and 2? Given the nature of this homework assignment, it can be done completely in Excel. If you prefer to handwrite the non-regression parts, you can submit them separately...

PROJECT Home Complut Specifications Objective To investigate the specifications associated with purchasing a home computer. PROJECT DESCRIPTION What are the specititaons behind puchasing typical ho...

ACCT 5131 Spreadsheet Project Summer 2019 Guidelines Please read the guidelines in the Identifying Elements of a Financial Model section in Chapter 12 of the Hilton (2008) textbook (now...

City of Somerville, MA: Data Analysis Data Project Instructions You are required to analyze the City of Somervilles dataset, and interpret result and report results. A tutorial dataset and the data...

Initial height of the sample (mm) 20.20 last two digits of st. no. We (first digit- last digit) Gs 2.6796566 56 26 Load 16kg 32kg 64kg 1kg 2kg 4kg 8kg 16kg 32kg 64kg Moment of the oedometer...

accounting general ledger ...attached is the information The goal of this graded project is to create the following financial statements for J & L Accounting, Inc.: Balance sheet Income statement...

Good Morning, This is the 3rd homework assignment I am requesting of you as you have did excellent on the two prior which I greatly appreciate. This is a new course that is starting today and I am...

Needing ANSWERS ASAP! Starting at pg 34 - Labeled Graded Project 06155200: Graded Project Instructions & Worksheets 1 Lesson 1: Business, Accounting, and You PROJECT GOAL The goal of this graded...

Deshaun and Marsha are considering a $175,000 mortgage for 15 years at a 4.4% interest rate. With this information, their monthly payment would be $1329.81. If they only make the minimum payment each...

The Trial Balance TBA Limited contained the following accounts (alphabetically) at December 31, 2020, the end of company's fiscal year. Accounts Accumulated Depreciation-Building.... Accumulated...

materials price variance for last month was: Multiple Choice \ $ 1 0 0 unfavorable. \ $ 2 0 0 unfavorable. \ $ 2 0 0 favorable. \ $ 3 , 8 0 0 favorable.

Barnes Company reports the following operating results for the month of August: Sales $325,000 (units 5,000); variable costs $210,000; and fixed costs $75,000. Management is considering the following...

Draw a local area network or some other configuration of distributed processing using the client/server approach to solve some of the data sharing problems that Bakerloo Brothers is having. It wants...

After meeting with Cher Ware and Hy Perteks to discuss reporting needs, Anna has identified the fields for the partially completed NEW SOFTWARE INSTALLED REPORT. Design (or modify) the report to...

The Soma Inn is trying to determine its break - even point, The inn has 75 rooms that are rented at $60 a night. Operating costs are as follows. Salaries..............................$10,600 per...

Bell expects to produce 1,800 units in January and 2,155 units in February. The company budgets 3 pounds per unit of direct materials at a cost of $10 per pound. Indirect materials are insignificant...

Create a 200 word summary on the Juvenile Justice System than and today. Describe The Juvenile system and provide a generalizable definition. Highlight the issues in the Juvenile system and why this...

Intermediate: Computation of NPV and tax payable Sound Equipment Ltd was formed five years ago to manufacture parts for hi-fi equipment. Most of its customers were individuals wanting to assemble...

Advanced In the context of capital budgeting, you are required to explain: (a) the meaning of beta; (4 marks) (b) the function of beta in the capital asset pricing model; (4 marks) (c) what one might...

Advanced: Calculation of IRR and incremental yield involving identification of relevant cash flows LF Ltd wishes to manufacture a new product. The company is evaluating two mutually exclusive...