Question: Please show formulas in excel: What is the expected return on a portfolio of stocks that is 12 percent invested in Stock X, 43 percent

Please show formulas in excel:

Please show formulas in excel: What is the expected return on a portfolio of stocks that is 12 percent invested in Stock X, 43

What is the expected return on a portfolio of stocks that is 12 percent invested in Stock X, 43 percent in Stock Y, and 45 percent in Stock Z? The expected returns on these three stocks are 8 percent, 14 percent, and 16 percent, respectively. Input area: Weight of X Weight of Y Weight of Z Stock X E(R) Stock Y E(R) Stock Z E(R) 12.00% 43.00% 45.00% 8.00% 14.00% 16.00% Output area: Portfolio E(R)

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 show work! What is the expected return on a portfolio of stocks that is 12 percent invested in Stock X, 43 percent in Stock Y,and 45 percent in Stock Z? The expected returns on these three...

Problem 13-8 Calculating Expected Returns (L01) A portfolio is invested 12 percent in Stock G, 52 percent in Stock J, and 36 percent in Stock K. The expected returns on these stocks are 10 percent,...

please assist Florida Company (FC) and Minnesota Company (MC) are both service companies. Their stock returns for the past three years were as follows: FC: 5 percent, 15 percent, 20 percent, MC: 8...

Please, don't use AI, I've already tried, that's why I'm here. If possible use Excel formulas, cell references, & horizontal timelines to show all work. The stock of Jones Trucking is expected to...

Question 71 pts What is the expected return for a portfolio that has $800 invested in Stock A and $1,200 invested in Stock B, if the expected returns on Stock A and Stock B are 10% and 18%,...

What is the expected return on a portfolio of stocks that is 12 percent invested in Stock X, 43 percent in Stock Y, and 45 percent in Stock Z? The expected returns on these three stocks are 8...

please show excel formulas Asset W has an expected return of 11.8 percent and a beta of 1.15. If the risk-free rate is 3.7 percent, complete the following table for portfolios of Asset W and a...

Consider the following information: State Probability Stock A Stock B Stock C Boom 0.32 -0.01 0.23 0.2 Bust 0.68 0.21 -0.06 -0.06 What is the expected return of a portfolio that has invested $6,052...

1) Hammett, Inc. has sales of $19,570, costs of $9,460, depreciation expense of $2,130, and interest expense of $1,620. If the tax rate is 35 percent, what is the operating cash flow, or OCF? 2) App...

Ward, a former employee of ISD, a computer company, was employed by UCC, a competing computer service company. Ward was charged with obtaining trade secrets illegally through the use of a computer...

A planet with mass 7 x 1024 kg orbits a sun with a period of 1 Earth's years. The speed of the planet around that sun is constant and |v|=49600 m/s. What is the mass of that sun?

Homework Assignment # 3 Bond Pricing Both Bond Sam and Bond Dave have 6 . 5 percent coupons, make semiannual payments, and are priced at par value. Bond Sam has 3 years to matarity, whereas Bond Dave...

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".