Question: How do we calculate portfolio returns with these portfolio weights on excel. How do we also calculate the average returns and standard deviation for each

How do we calculate portfolio returns with these portfolio weights on excel. How do we also calculate the average returns and standard deviation for each of the portfolio. (all in excel)

1: 100% in Stock 1, 0% in Stock 2

2: 80% in Stock 1, 20% in Stock 2

3: 60% in Stock 1, 40% in Stock 2

4: 40% in Stock 1, 60% in Stock 2

5: 20% in Stock 1, 80% in Stock 2

6: 0% in Stock 1, 100% in Stock 2

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 go ahead and rate Robyn just like i did. I want to know if i am right or far off from her rating. When completing the vignettes, there is a vignette assumption. That is, when reading assume...

FINA3310 HW2: Empirical analysis - Portfolio risk & return (Due on Mar 31st) Try your best: this is a real-life application. Download the historical stock price data of two firms (you can choose any...

Question 6 Hank Schrader, a DEA agent, has recently seized illegal weapons and drugs valued at USD 10 million. As a reward for his services his department has offered him a sizeable bonus. Hank is...

Please use solver add-in (excel)!! ii. XOM= DRIN RF= Average Return Standard Deviation 0.808 5.910 1.166 11.669 0.232 XOM weight=0.8 and DRI weight=0.2|| Correlation= 0.6 What combination of Exxon...

FINA 6 3 1 9 : Empirical analysis Portfolio risk & return and ORP ( Extra 1 point for overall grade ) Try your best; this is a real - life application for what we learned. Download the monthly...

1 . Using those data to estimate the stock s return and volatility, respectively. Hint: return of stock i on time t: rt = , where P is the stock price. 2 . And given the weight you want for each...

Please feel free to use any stocks amongst the following: Netflix, Amazon, Nvidia Try your best; this is a real - life application for what we learned. Download the monthly historical stock price...

Suppose you have $3,301 invested in a two share portfolio comprising of Stock A and Stock B. The following table holds Average Return Standard Deviation Weights Correlation (A,B) Share A 43.3 % 20.8...

Suppose you have $1,602 invested in a two share portfolio comprising of Stock A and Stock B. The following table holds Average Return Standard Deviation Weights Correlation (A,B) Share A 22.1 % 24.9...

please show formulas so i know how to calculate future problems thank you THE MINIMUM VARIANCE PORTFOLIO Using the information from Problem 1, help the investor determine the minimum variance...

Fill in the missing information in the following table. Assume that Portfolio AB is 40 percent invested in Stock A. (A negative value should be indicated by a minus sign. Do not round intermediate...

You have to use the numbers that is given to figure out what the question is asking. 1. You are the Nutrition and Food Services Director and your Chief Financial Officer (CFO) has requested that you...

Sumcilla Companys data regarding the cash in bank for the year 2021 are as follows: Jan. 31 Feb. 28 01 Cash per ledger 200,000 270,000 02 Cash receipts for February 150,000 03 Bank statement balance...

13. Diseases carried by recessive genes can be inherited by off spring of two carriers. Th us, since cystic fi brosis is a disease carried by recessive genes, it can be inherited by off spring of two...

Molton Company experienced the following during 2015: 1. Issued preferred stock for $125,000. 2. Repurchased $70,000 of its own common stock. 3. Borrowed $150,000 from a bank issuing a five-year...

During 2014, Damon Company had the following transactions: 1. Purchased $200,000 of 10-year bonds issued by Gallant, Inc. 2. Purchased common stock in Morceau Company, as a long-term investment, for...

Liu Inc. has sales of $48,500,000, and the break-even point in sales dollars is $31,040,000. Determine the company's margin of safety as a percent of current sales.

SungSam Enterprises reports the following data: Sales ............$ 340,000 Variable costs ......... 180,000 Contribution margin .......$ 160,000 Fixed costs ......... 80,000 Income from operations...

Define the SHGC (solar heat gain coefficient), and explain how it differs from the SC (shading coefficient). What are the values of the SHGC and SC of a single-pane clear-glass window?

Tori and some other childeen experimented with balls to see which ones rolled. First using a piece of cardboard to use as a ramp, they angled it on a block to the floor to test the balls. Then Tori...

The purpose of a flexible budget in cost center performance evaluation is to Allow management some latitude in meeting goals Eliminate cyclical fluctuations in production reports by ignoring variable...

Which one of the following statements best describes cost allocation? A company can maximize total company income by selecting different bases to allocate indirect costs. A company should select an...

Controllable costs for responsibility accounting purposes are those costs that are directly influenced by A given manager within a given period of time A change in activity Production volume Sales...