Apple Microsoft Date (End of month) Average monthly return Average monthly return December 2021 January 0,015746248 0,075360144 February 0,054036945 0,037196923 March 0,057427911 0,03185787 April 0,097111955 0,099875849 May 0,054479419 0,018075569 June 0,081474493 0,055298858 July 0,188701394 0,093086043 August 0,031230712 0,066652348 September 0,120986239 0,109265935 October 0,109589041 0,003315393 November 0,033052453 0,102211854 December 0,109234615 0,06431763 a) Calculate average monthly return and standard deviation for 11 different portfolios that combine stock 1 and stock 2 in different proportions 0 in stock 1 100 in stock 2 10 in stock 1 90 in stock 2 20 in stock 1 80 in stock 2 and so until the 11th portfolio includes 100 in stock 1 0 in stock 2

Question: Apple Microsoft Date (End of month) Average monthly return Average monthly return December 2021 - - January -0,015746248 -0,075360144 February -0,054036945 -0,037196923 March 0,057427911 0,03185787

	Apple	Microsoft
Date (End of month)	Average monthly return	Average monthly return
December 2021	-	-
January	-0,015746248	-0,075360144
February	-0,054036945	-0,037196923
March	0,057427911	0,03185787
April	-0,097111955	-0,099875849
May	-0,054479419	-0,018075569
June	-0,081474493	-0,055298858
July	0,188701394	0,093086043
August	-0,031230712	-0,066652348
September	-0,120986239	-0,109265935
October	0,109589041	-0,003315393
November	-0,033052453	0,102211854
December	-0,109234615	-0,06431763

a) Calculate average monthly return and standard deviation for 11 different portfolios that combine stock 1 and stock 2 in different proportions: 0% in stock 1 + 100 % in stock 2; 10% in stock 1 + 90% in stock 2; 20% in stock 1 + 80% in stock 2; and so until the 11th portfolio includes 100% in stock 1 + 0% in stock 2.

Step by Step Solution

★★★★★

3.44 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Answer Average monthly return has been calculated with the help of average function in excel Standar... 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!

Date of Dividend June 2010 September 2010 November 2010 March 2011 June 2011 September 2011 November 2011 March 2012 June 2012 September 2012 November 2012 March 2013 June 2013 September 2013...

Apple River Inc.'s inventory for the month of November was as follows: Instructions (a) Calculate the ending inventory and cost of goods sold using the average cost formula in (1) A perpetual...

Month Budgeted Sales in units April 150,000 May 225,000 June 270,000 July 240,000 Month end inventory is 30% of the next month sales volume The inventory at Mar31 was 15,000 When preparing the...

Hello, I need help with the highlighted questions(I, J, and K). Also, can you please explain how you completed the regression part. The assignment is Week 5 assignment. The other documents are from...

I have attached pictures of the project instructions in excel. Please help. Thank you so much DETAILED ASSIGNMENT REQUIREMENTS The the Chart of Accounts, below, shows the balances in GBI accounts as...

Use the case study as shown in the photo and your own research on Peloton to answer the following questions. (500 words each question, total of 2000 words) 1) Using the Business Model Canvas to...

"DISCUSS THE EFFECTS OF COVID 19 ON LABOR MARKETS AND THE ECONOMY" Provide an introduction and the background of your study, and clearly state what your research question or objective is. What real...

1. What are the basic benefits and purposes of developing pro forma statements and a cash budget? What are the pitfalls in the process? How do you think you could avoid these pitfalls? 2. What effect...

Case Eric is thinking about installing solar panels on his house to reduce his electricity usage and his carbon footprint Cost of Electricity Austin Energy uses the five-tier rale schedule shown...

Q1: Using the asset and liability information, in EXCEL develop a balance sheet. Assume there are no unpaid bills. ASSETS January 1, Current Year (all assets are community property) PERSONAL PROPERTY...

Track the flow of costs in a job costing system and ledger entries. Gordon Bros Ltd manufactures plastic products. The following details relate to Job #369: April 1, 2020: Direct materials of...

Bradley Company manufactures a single product that sells for $420 per unit and whose variable costs are $315 per unit. The companys annual fixed costs are $1,313,760. The break-even point in units...

Water enters an ice machine at 55F and leaves as ice at 25F. If the COP of the ice machine is 2.4 during this operation, determine the required power input for an ice production rate of 28 lbm/h....

An airplane in flight is subject to an air resistance force proportional to the square of its speed v. But there is an additional resistive force because the airplane has wings. Air flowing over the...

On a winter's day in Maine, a warehouse worker is shoving boxes up a rough plank inclined at an angle a above the horizontal. The plank is partially covered with ice, with more ice near the bottom of...

Suppose that we are interested in fitting a simple linear regression model Y = B0 + B1x + , where the intercept, B0, is known. (a) Find the least squares estimator of B1. (b) What is the variance of...

A little red wagon with mass 7.00 kg moves in a straight line on a frictionless horizontal surface. It has an initial speed of 4.00 m/s and then is pushed 3.0 m in the direction of the initial...

Use the equation for the question(s) below. Consider the following linear regression model:(Ri minus rf) = ai + bi(RMkt minus rf) + ei The bi in the regression: Question content area bottom Part 1 A....

Where are the cash flow effects of purchases and sales of equity securities reported?

Locate the 2007 financial statements for The Walt Disney Company on the Internet. Once you have located those financial statements, consider the following question. From Disneys foreign currency...

Refer to Practice 22-1. Now, instead of assuming that ForSub conducted no business operations during 2011, assume that ForSub conducted the following business operations during 2011: (a) Sales were...

Write a short essay on marketing communication as a conversation.

Determine which of the background characteristics explain which segments carry out the purchase activities in different ways.

Understand how consumers enact behavioural processes when they buy and use a product.