Question: PLEASE USE EXCEL FUNCTIONS ONLY, AND HIGHLIGHT the steps! thanks! PLEASE USE EXCEL FUNCTIONS ONLY, AND HIGHLIGHT the steps! thanks! PLEASE USE EXCEL FUNCTIONS ONLY,

PLEASE USE EXCEL FUNCTIONS ONLY, AND HIGHLIGHT the steps! thanks!

PLEASE USE EXCEL FUNCTIONS ONLY, AND HIGHLIGHT the steps! thanks! PLEASE USE

PLEASE USE EXCEL FUNCTIONS ONLY, AND HIGHLIGHT the steps! thanks!

6. Refer to the table containing the share price of company T and W below: Date 31-Dec-18 31-Jan-19 28-Feb-19 31-Mar-19 30-Apr-19 31-May-19 30-Jun-19 31-Jul-19 31-Aug-19 30-Sep-19 31-Oct-19 30-Nov-19 31-Dec-19 Share T price 4.09 4.15 4.56 4.43 4.80 4.81 5.11 4.62 4.25 4.23 4.00 4.21 5.04 Share W price 79.37 81.19 80.24 83.06 82.7 82.97 85.75 87.82 81.85 83.88 80.45 89.06 85.87 (a) Compute the returns for both companies. Please use the return definition used in the labs. (1 mark) (b) Compute the average return and standard deviation for each of the returns. (2 marks) (c) Compute the Covariance between the returns. Provide a brief interpretation of what the Covariance measures. (2 marks) (d) Assume that you construct a portfolio where you invest 40% in company T and 60% in company W. What is the average return and standard deviation of this portfolio? (2 marks) (e) Assume that you construct a portfolio where you invest 60% in company T and 40% in company W. What is the average return and standard deviation of this portfolio? (2 marks) (f) Based on the calculation in parts (d) and (e) above, which portfolio weighting you would like to choose, i.e., 40% in company T and 60% in company W or 60% in company T and 40% in company W? Please provide your reasoning. (1 mark)

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!

PLEASE USE EXCEL FUNCTIONS ONLY, AND HIGHLIGHT the steps! thanks! PLEASE USE EXCEL FUNCTIONS ONLY, AND HIGHLIGHT the steps! thanks! PLEASE USE EXCEL FUNCTIONS ONLY, AND HIGHLIGHT the steps! thanks!...

MGMT 426-5ervice Operations Management Assignment 1 - Forecasting Purpose of Assignment In this assignment, you will develop forecasting skills which are widely used in industry and highly valuable...

this is for the question calcualte average monthly return. this the additional information for the other question when it requires to work out average monthly return and standard deviation. i think...

This is a question from MSC142 (Visual Programming for Business) course. This is a course on Microsoft excel. Kindly read the question carefully and please use these functions of excel while doing...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) Instructor: to your instructor. The tabs (bottom of each...

1 Open the ClothingTech Pre-Project Analysis - Start workbook. 2 Cutt-Off Test: In steps 3 6 below, you are going to determine if there were any 2016 sales that were not shipped until 2017. While...

To be ready to optimise the company's data using Microsoft Excel, you need to perform the following tasks by applying the functions that have been practised in the workshops. You are expected to...

I have this Accounts assignment that needs to be done. Need help on that Statement of individual work Individual work required This project is designed to assure that all students, individually, have...

Hello I am doing a Excel assignment for my class, and wanted to see if i could get some help with the assignment as soon as possible. I am wishing to hear back from someone by 4pm today if possible,...

please please please help Your company will be a small manufacturing/wholesale business that rents a Business Unit that has both a production and an administration area. The company will make the...

Listed below are 10 causes of temporary differences. For each temporary difference, indicate (by letter) whether it will create future deductible amounts (D) or future taxable amounts (T). Temporary...

A clean-earth wide-channel flow is flowing up an adverse slope with so = 0.002. If the flow rate is q = 4.5 m3/sm, use gradually-varied theory to compute the distance for the depth to drop from 3.0...

PROBLEM 1 7 . 8 B ABC versus Use of a Single Activity Base LO 1 7 - 6 , LO 1 7 - 7 Happy Cat, Inc., makes two lines of cat food: ( 1 ) Tabby Treat and ( 2 ) Fresh n Fishy. The Tabby Treat line is a...

Your next door neighbour, Scott Jansen, has a 12-year-old daughter, and he intends to pay the tuition for her rst year of university six years from now. The tuition for the rst year will be $18,500....

What is the content-level meaning?

2. Interview a professional in your fi eld of choice. Identify the communication skills that he or she thinks are most important for success. Which of those skills do you already have? Which skills...

To what extent are liking, responsiveness, and power expressed on the relationship level of meaning?