FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

To calculate the expected return of a portfolio invested in Microsoft and Apple using Excel and a financial calculator follow these steps Excel Calcul... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Managerial Finance

Principles Of Managerial Finance

Authors: Lawrence J. Gitman, Chad J. Zutter

13th Edition

9780132738729, 136119468, 132738724, 978-0136119463

More Books

Students also viewed these Finance questions

Question

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...

Answered: 1 week ago

Question

★★★★★
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%?...

Answered: 1 week ago

Question

★★★★★
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...

Answered: 1 week ago

Question

★★★★★
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....

Answered: 1 week ago

Question

★★★★★
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...

Answered: 1 week ago

Question

★★★★★
An aircraft, starting from rest accelerates uniformly along a straight runway. It reaches a speed of 200 km h 1 and travels a distance of 1.4 km. What is the acceleration of the aircraft along the...

Answered: 1 week ago

Question

★★★★★
=+a) What kind of design or study is this?

Answered: 1 week ago

Question

★★★★★
Refer to the original data in P22-30B and the revisions presented in P22-34B. Requirements 1. Prepare the schedule of budgeted cash collections from customers for April and May. 2. Prepare the...

Answered: 1 week ago

Question

★★★★★
The Jergin & Macey partnership has the following balano on December 31, 2016 Click the icon to view the balances) Jergin and Macwy share profits 13, respectively Jergin and Macey decide to get the...

Answered: 1 week ago

Question

★★★★★
i know the answers i just dont know the excel formula for example, "=B5 is 200,000" or =B5*B7*60/B8 would be the interest expense in 2023 & instead of 60 you put 30 in the same formula for the...

Answered: 1 week ago

Question

★★★★★
Prepare a schedule of cost of goods sold for October. Note: Use negative signs with answers, when appropriate.

Answered: 1 week ago

Question

★★★★★
Peer Reviewed resources on Employee Selection and Training in Capacity Development

Answered: 1 week ago

Question

★★★★★
2. Recent research suggests 21% of Americans are in favor of outlawing fast food. You decide to test this claim and ask a random sample of 200 Americans whether they are in favor of outlawing fast...

Answered: 1 week ago

Question

★★★★★
Continuous improvement is the definition of kaizen. A little modification in any area of an organisation is part of this idea of continual development. Depending on the requirements of a company, a...

Answered: 1 week ago

Question

★★★★★
Write a 4-5 page plan with outline of a first-level manager leadership program based on the leading others stage from the leadership pipeline: Read chapters 2 and 3 from The Leadership Pipeline ....

Answered: 1 week ago

Question

★★★★★
To make a cake, one pound of dry cake mix is needed. However, when pouring cake mix into the mixing bowl, 10% spills onto the floor and is unusable. What is the standard amount of cake mix necessary...

Answered: 1 week ago

Question

★★★★★
If 2 5 9 - k 5 8 = 2 5 8 , what is the value of k?

Answered: 1 week ago

Question

★★★★★
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....

Answered: 1 week ago

Question

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

Answered: 1 week ago

Question

★★★★★
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...

Answered: 1 week ago

Previous Question Next Question