Question: How is this done in excel and also on a financial calculator? Microsoft has an expected return of 12% and a standard deviation of 18%.

How is this done in excel and also on a financial calculator?

Microsoft has an expected return of 12% and a standard deviation of 18%. Apple has an expected return of 8% and a standard deviation of 15%. If your portfolio invests 40% in Microsoft and the rest in Apple, what is the expected return of the portfolio?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To calculate the expected return of a portfolio invested in Microsoft and Apple using Excel and a financial calculator follow these steps Excel Calcul... 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!

The cantilevered handle in the figure is made from mild steel that has been welded at the joints. For Fy = 200 lbf, Fx = Fz = 0, determine the vertical deflection (along the y axis) at the tip. Use...

How is this done in excel and also on a financial calculator? The price of Apple is $183 per share and that of Amazon is $728 per share. The price of Apple increases to $212 per share after one year...

13. What is a lower bound for the price of 3-month call option on a non- dividend-paying stock when the stock price is $50, the strike price is $45, and the 3-month risk-free interest rate is 8%?...

How is this done in excel and also on a financial calculator? Microsoft had stock prices of $47, $41, $28, $42, and $57 at the end of the last five quarters. If Microsoft pays a dividend of $1.50 at...

You have invested a portfolio comprised of Dell, Apple and Microsoft. Calculate the expected return and standard deviation of the portfolio given the information below. (SHOW IN EXCEL). Provide step...

1. You hold a 3-stock portfolio (APPLE, IBM, TESLA) from the S\&P500. The adjusted close price data for the 3 stocks and the S\&P500 index price data are available on Canvas (Click Here). You would...

1. Using the stock price of United Airlines (UAL), Apple (AAPL), and Microsoft (MSFT), download the last three years of monthly adjusted prices for these stocks and S&P 500 Index to Table 1 2....

Answer plz on this I will give you upvote Answer plz on this I will give you upvote Problem 8: Portfolio Choice Using Numerical Methods (6 points) For this problem, you will need data in Excel file...

I included the questions as well as the excel sheet provided for the question. Thank You! Excel Activity: Feasible Portfolios Question 1 0.63/10 Start with the partial model in the file Cho3 PO7...

Part I: Calculate for Wal-Mart, GE, Apple, the S&P500, and the Fidelity Corporate Bond ETF in Excel: a) Calculate Monthly returns b) Expected monthly return (E[RD) (Arithmetic Average) c) The...

I need help with part,can you help me finish it?thank u FINA 415-15S Exam PART 1 Excel # 1 2 3 4 5 6 Worksheet Name Solver Look Up Function Matrix Pivot table Data Table Offset Function Description...

The Brookstone Company produces 9 volt batteries and AAA batteries. The Brookstone Company uses a plantwide rate to apply overhead based on direct labor hours. The following data is given: Actual...

? Processing times and weights for five jobs are shown in the table below. Assume the jobs need to be processed on a single resource and are sequenced with the WSPT rule. Job Processing time (mins)...

Llyod inherited a home from donnell They will not be using an alternative date for the valution. Lloyds basis in the property is most likely what?

A company determines that sales will rise from $300,000 to $700,000 next year. Spontaneous assets are 70% of sales and spontaneous liabilities are 30% of sales. The company has a 10% profit margin...

A bond has a $1,000 par value, 7 years to maturity, a 9% annual coupon, and sells for $1,095. a). What is its yield to maturity (YTM)? Round your answer to two decimal places. b). Assume that the...

1. Using appropriate economic analysis, explain the process by which price levels are likely to become more harmonized throughout Europe as a result of the development of the Euro. 2. As a marketer...

Ignoring capital gains tax, discuss whether any part of the $4m constitutes ordinary income. Steve runs a business that manufactures a specialised type of extra strong glass. This business has a...

If a company has to pay a given amount of income taxes over the life of capital investment, managers of the company should seek to pay the taxes as early as possible in the investment's life. True or...

Design a minimum-mass symmetric three-bar truss (the area of member 1 and that of member 3 are the same) to support a load P, as was shown in Fig. 2.9. The following notation may be used: Pu = P cos...

The accompanying data on cortisol level was reported in the article Cortisol, Cortisone, and 11-Deoxycortisol Levels in Human Umbilical and Maternal Plasma in Relation to the Onset of Labor (J....

Compute a 99% CI for 1 2 using the data in Exercise 11.

The Chinese indicated that the poppies might remind the Chinese of the Opium Wars of the mid-1800s, in which British forces defeated the Chinese. In your opinion, should the British representatives...