How is this done in excel and also on a financial calculator? Microsoft has an expected return
Fantastic news! We've Found the answer you've been seeking!
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%. 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?
Expert Answer:
Answer rating: 100% (QA)
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 the full answer
Posted Date:
Students also viewed these finance questions
-
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...
-
Coffin Corporation appropriately uses the installment-sales method of accounting to recognize income in its financial statements. The following information is available for 2014 and 2015....
-
On December 1, 2013, Mayberry Inc. purchased inventory on account from a U.S. supplier for U.S. $40,000 when the exchange rate was U.S. $1 = C$0.97. The inventory was still on hand at Mayberrys year...
-
Casio Company uses a predetermined rate for applying overhead costs to production. The rates for Year 0 follow: variable, $1 per unit; fixed, $2 per unit. Actual overhead costs incurred follow:...
-
Fine Product Company manufactures a product with a feature that has a target value of 18 grams. The company has set specification limits for the product equal to the target value plus or minus 0.5...
-
After several years of operations, the partnership of Nelson, Pope, and Williams is to be liquidated. After making closing entries on March 31, 20--, the following accounts remain open: The noncash...
-
What are some examples from society, and culture that illustrate embedded feminism? What are media examples that support the idea of enlightened sexism? Do expectations of gender norms or the "back
-
An ammonia refrigeration system has a liquid temp of 2 8 degree between the regualtor and condenser. Downstream of the regulator, through the evaporator and up to the compressor suction, the NH 3...
-
Mr. Jones's small consulting firm specializes in providing internal control advice to his clients. All of his staff are certified internal auditors (CIAs) and want to gain expertise in a variety of...
-
How can AI help tackle climate change? What are the 10 aspects of the environmental change process based on a series of 10 steps the organization pursues (From the reading above ), and their impacts...
-
Eco-friendly practices are becoming the norm as properties focus on renewable energy resources and water scarcity. Did you uncover a written environmental policy in place outlining their commitments...
-
1. Nail & Hammer Shack purchased 246 table fans of a particular make. The unit cost was $29.50 and the regular selling price was $60.00 each. The store sold 122 of them at the regular selling price....
-
A firm makes a product on a single machine. Leasing the machine costs $2,000, running the machine for an hour costs $60, the machine processes 8 units of the product in one hour, & the product can be...
-
3. Let the B frame be rotated by 79 degrees from the V frame. Find the coordinates in the V frame for a point [-1; 2] in the B frame and plot this point. Use Matlab to generate a plot for this case...
-
If 2 5 9 - k 5 8 = 2 5 8 , what is the value of k?
-
The market price of a stock may change daily as its shares are traded on a stock exchange. Research and write a brief report about one of the stock exchanges. Describe such things as how a company is...
-
The amount of net income belonging to a single share of stock is called earnings per share (EPS). EPS is shown on the income statement. In some cases, the company must calculate EPS. two different...
-
A corporation president suggests to the accounting department that the statement of stockholders' equity be dropped from the end-of-fiscal-period work. The president's reason is that the same...
Study smarter with the SolutionInn App