### Expected return and standard deviation

Assignment Help Finance Basics
##### Reference no: EM131428927

Can someone show me how to solve this in Excel?

Stock A has an expected return of 12% and a standard deviation of 40%. Stock B has an expected return of 18% and a standard deviation of 60%. The correlation coefficient between Stock A and B is 0.2. What are the expected return and standard deviation of a portfolio invested 30% in Stock A and 70% in Stock B?

#### What is the npv of the project

The applicable corporate tax rate is 40%, and the firm's WACC is 14%. Should the old welder be replaced by the new one? What is the NPV of the project? Round your answer to th

#### What annual interest rate did she receive

To save for retirement Karla put \$425 each month into an ordinary annuity for 17 years. Interest was compounded monthly. At the end of the 17 years, the annuity was worth \$1

#### Project to generate cash flows

Turnbull Corp. is in the process of constructing a new plant at a cost of \$30 million. It expects the project to generate cash flows of \$13,000,000, \$23,000,000, and 29,000,

#### Machine on the initial outlay for the new machine

Blackjack can sell the machine to a foreign buyer for \$14,000. Blackjack's tax rate is 35%. The effect of the sale of the old machine on the initial outlay for the new machi

#### Stock price information of mydeco corp

Using the financial statements and stock price information of Mydeco Corp in the next page to answer following questions: a. How did Mydeco's accounts receivable days change o

#### Violate basic principle of stock valuation

Moonnalso noticed that Googlepays no dividends yet investors are willing to buy shares in this firm. How is this possible? Does this violate basic principle of stock valuati

#### Evaluate risk management techniques from experts in field

In this assignment, you will compare and evaluate risk management techniques from experts in the field. Go to the Ashford University Library and find one article by Dr. Jame

#### Personal or professional decision-making

If you take on a large risk, are you guaranteed a large return? Why or why not? What other factors play into risks that are not covered in the video? When have you had to cons