Question: Task 4: Now using a matrix multiplication (i.e. MMULT in Excel.), compute two portfolio returns and portfolio variances. Use the formula: portfolio return: E(R P

Task 4:

Now using a matrix multiplication (i.e. MMULT in Excel.), compute two portfolio returns and portfolio variances.

Use the formula: portfolio return: E(R_P) = w _* r^T

portfolio variance: P2 =ww_T

PLEASE SHOW WORK. Thank you!

Task 4: Now using a matrix multiplication (i.e. MMULT in Excel.), compute

Stock 1 Stock 2 Apple Inc. (AAPL) PepsiCo, Inc. (PEP) Date Adj Close Monthly Return (%) Adj Close Monthly Return (%) 01-05-2019 172.341583 124.479256 01-06-2019 195.58577 13.49% 127.523163 2.45% 01-07-2019) 210.527466 7.64% 125.204521 -1.82% 01-08-2019 206.278168 -2.02% 133.942688 6.98% 01-09-2019 222.169479 7.70% 134.305145 0.27% 01-10-2019 246.760193 11.07% 135.302307 0.74% 01-11-2019 265.101563 7.43% 133.98056 -0.98% 01-12-2019 292.163818 10.21% 134.809113 0.62% 01-01-20201 307.943604 5.40% 141.06749 4.64% 01-02-2020 271.976532 -11.68% 131.144485 -7.03% 01-03-2020) 253.6035 -6.76% 119.294495 -9.04% 01-04-20201 293.006836 15.54% 132.289993 10.89% 01-05-2020 309.292755 5.56% 134.229996 1.47% Average Return =Average(Returns) =Average(Returns) 5.30% 0.77% Standard Deviation ESTDEV.P(Returns) ESTDEV.P(Returns) 7.81% 5.22% Stock 1 Stock 2 Apple Inc. (AAPL) PepsiCo, Inc. (PEP) Date Adj Close Monthly Return (%) Adj Close Monthly Return (%) 01-05-2019 172.341583 124.479256 01-06-2019 195.58577 13.49% 127.523163 2.45% 01-07-2019) 210.527466 7.64% 125.204521 -1.82% 01-08-2019 206.278168 -2.02% 133.942688 6.98% 01-09-2019 222.169479 7.70% 134.305145 0.27% 01-10-2019 246.760193 11.07% 135.302307 0.74% 01-11-2019 265.101563 7.43% 133.98056 -0.98% 01-12-2019 292.163818 10.21% 134.809113 0.62% 01-01-20201 307.943604 5.40% 141.06749 4.64% 01-02-2020 271.976532 -11.68% 131.144485 -7.03% 01-03-2020) 253.6035 -6.76% 119.294495 -9.04% 01-04-20201 293.006836 15.54% 132.289993 10.89% 01-05-2020 309.292755 5.56% 134.229996 1.47% Average Return =Average(Returns) =Average(Returns) 5.30% 0.77% Standard Deviation ESTDEV.P(Returns) ESTDEV.P(Returns) 7.81% 5.22%

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!

Consider your tastes for five dollar bills and ten dollar bills (and suppose that you could have partial $10 and $5 bills). A: Suppose that all you care about is how much money you have, but you dont...

You have $20,000. After the "success" of the sequel of the "Hunger Games", you want to know if Lions Gate Entertainment Corp. (NYSE:LGE) is a good buy. The firm's total risk is 19%, its systematic...

Note: For this problem, you will compute an efficient portfolio in Excel using matrix algebra. To receive credit for this problem you must attach a printout of your calculations in Excel. You have $1...

You have $1 million in cash and you would like to allocate it between the common stock of the following three firms: firm A, firm B, and firm C. You know the risk free rate is 0% and you have the...

3) Note: For this problem, you will compute an efficient portfolio in Excel using matrix algebra. To receive credit for this problem you must attach a printout of your calculations in Excel. You have...

You must write a report including your findings, all relevant information and computations, and provide evidence. For this project, you must download monthly historical data from Jan. 2001 to Dec....

1. Suppose you want to construct a portfolio of five stocks: BAC, RIG, HPQ, IBM, and AAPL and hold it for one month. Suppose you use the data during 20162020 to estimate the parameters, and apply...

Part 1 Portfolio Return and Risk Instruction: You are a portfolio investment analyst at Goldman Sachs. Your investment unit manages two equity portfolios - one portfolio, named P1, consists of two...

2. Suppose you want to construct a portfolio of five stocks: BAC, MKR, HPQ, IBM, and AAPL and hold it for one month. Suppose you apply Markowitz portfolio selection theory (without risk-free asset)...

Briefly describe ASCII and Unicode and draw attention to any relationship between them. [3 marks] (b) Briefly explain what a Reader is in the context of reading characters from data. [3 marks] A...

Part 1: You are a portfolio investment analyst at Goldman Sachs. Your investment unit manages two equity portfolios - one portfolio, named P1, consists of two stock assets Apple (AAPL) and Microsoft...

More and more young generation and enthusiast participates in off-road racing. In off-road racing, races often take place in the desert, where various classes of specially modified vehicles,...

Astpac Bank has just purchased 858 European call options, on stock with a current share price $40, with a strike price of $42 and a term to expiration of 3 years. You know from past experience that...

Which one of the following statements is correct? Multiple Choice Pretax income is equal to net income minus taxes. The addition to retained earnings is equal to net income plus dividends. Operating...

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...