1 answer

QUESTION 17 You have are looking at an investment portfolio that will yield the following Stock...

Question:

QUESTION 17 You have are looking at an investment portfolio that will yield the following Stock Probability Beta Expected Ret
QUESTION 17 You have are looking at an investment portfolio that will yield the following Stock Probability Beta Expected Return 0.25 1.2023 13% 0.37 0.75 18% 0.17 1.60 24% If you, as the investor, have a required rate of return of 15%, would this portfolio be a good investment? No, because the portfolio return is lower than my required rate of return No, because the portfolio return and my required rate of return are equal Yes, because the portfolio return is higher than my required rate of return There is not enough information to answer the question

Answers

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

C D Stock Expected return 13% Probability 0.25 0.37 0.17 18% 24% Portfolio return 13.99% Required return 15.00% No, because t

Cell reference -

А в C D Stock Probability Expected return 2 3 0.13 1 2 3 0.25 0.37 0.17 0.18 0.24 Portfolio return =SUMPRODUCT(C3:C5,D3:05) R

Hope this will help, please do comment if you need any further explanation. Your feedback would be highly appreciated.

.

Similar Solved Questions

1 answer
What is the inductance of a coil if the coil produces an emf of 2.40 V...
What is the inductance of a coil if the coil produces an emf of 2.40 V when the current in it changes from -29.0 mA to +31.0 mA in 16.0 ms ?...
1 answer
Question 8 4 pts Most commercially available microarrays use short-to medium-length oligos as the molecules of...
Question 8 4 pts Most commercially available microarrays use short-to medium-length oligos as the molecules of choice. True O False 4 pts Question 9 Drug metabolizing enzymes catalyze the Phase I and Phase Il metabolic reactions. True False...
1 answer
Number 8 8) water at 15.6°C is delivered between two reservoirs through a 900 m long,...
number 8 8) water at 15.6°C is delivered between two reservoirs through a 900 m long, smooth concrete culvert. The culvert has a width of 0.8 m and height of 0.5 m. Assume entrance and exit losses of KL # 0.5 and 1, respectively. What is the flow rate in m3/s Az...
1 answer
Calulcate idemnity with coinsurance penalty. 10/22/18, 6:47 PM Calculate the Indemnity with a Coinsurance Penalty Complete...
Calulcate idemnity with coinsurance penalty. 10/22/18, 6:47 PM Calculate the Indemnity with a Coinsurance Penalty Complete the equation by moving each box to the correct location. Penalty Shoul Have Had Indemnity Had Partial Loss ck Aad Shoold how Had Incorrect...
1 answer
Condensed financial data of Pharoah Company follow. Pharoah Company Comparative Balance Sheets December 31 Assets 2020...
Condensed financial data of Pharoah Company follow. Pharoah Company Comparative Balance Sheets December 31 Assets 2020 Cash $109,700 Accounts receivable 92,200 Inventory 113,000 Prepaid expenses 29.900 Investments 139,800 Equipment 265,400 Accumulated depreciation equipment (47,200) Total $702,800 2...
1 answer
The choice of significance level can not influence the decision whether to reject or fail to...
The choice of significance level can not influence the decision whether to reject or fail to reject the null hypothesis. True False...
1 answer
Exercise 3-2 (Algo) Prepare T-Accounts (LO3-2, LO3-4] Jurvin Enterprises is a manufacturing company that had no...
Exercise 3-2 (Algo) Prepare T-Accounts (LO3-2, LO3-4] Jurvin Enterprises is a manufacturing company that had no beginning inventories. A subset of the transactions that it recorded during a recent month is shown below. a. $76,800 in raw materials were purchased for cash b. $71,600 in raw materials w...
1 answer
Which one of these five solutions would be expected in theory to have the highest buffering...
Which one of these five solutions would be expected in theory to have the highest buffering capacity with respect to strong acid? 1) 3 mL of 0.50M Na2CO3 & 27mL of 0.50M NaHCO3 2) 9mL of 0.50M Na2CO3 & 21mL of of 0.50M NaHCO3 3) 15 mL of 0.50M Na2CO3 & 15mL of 0.50M NaHCO3 4) 21 mL of 0....
1 answer
Vargas Corporation is working on its direct labor budget for the next two months. Each unit...
Vargas Corporation is working on its direct labor budget for the next two months. Each unit of output requires 0.95 direct labor-hours. The direct labor rate is $13.00 per direct labor-hour. The production budget calls for producing 8,900 units in October and 8,700 units in November. The company gua...
1 answer
Draw Lewis structures to determine which of the following compounds exhibit resonance. Enter the letters corresponding...
Draw Lewis structures to determine which of the following compounds exhibit resonance. Enter the letters corresponding to all those compounds which exhibit resonance. (If you find that choices A, C, and F all have resonance and the others do not, for example, you would enter ACF as your answer. Make...
1 answer
Write down the AR(2) model and prove whether it is stationary or not.
Write down the AR(2) model and prove whether it is stationary or not....
1 answer
QUESTION 4 Which of the following is a pitfall/con of IRR? There is only one solution...
QUESTION 4 Which of the following is a pitfall/con of IRR? There is only one solution for non-normal cash flows. It has the least conservative reinvestment assumption. Both of the above are correct. None of the above are correct. QUESTION 15 When an asset is sold, there are four possible tax situati...
1 answer
Hypothesis Testing Worksheet 1. The cold medicine Dozenol list 600 milligrams of acetaminophen per fluid Ounce...
Hypothesis Testing Worksheet 1. The cold medicine Dozenol list 600 milligrams of acetaminophen per fluid Ounce as an active ingredient. The Food and Drug Administration tests 65 one-ounce samples of the medicine and finds that the mean amount of acetaminophen for the sample is 589 milligrams with a ...
1 answer
Questions 2-5 pls Experiment 6. Equilibrium Pre-lab questions Answer these questions and hand them to the TF before...
questions 2-5 pls Experiment 6. Equilibrium Pre-lab questions Answer these questions and hand them to the TF before beginning work. (1) What is the purpose of this experiment? (2) You will measure the absorbance of a solution at 447 nm. What is the formula of the compound that is absorbing light ...
1 answer
Which of the following is not included in the acquisition costs when considering total cost of...
Which of the following is not included in the acquisition costs when considering total cost of ownership ? A. Supplier terms B. Delivery costs C. Taxes and duties D. Warehousing costs E. supplier price...
1 answer
Refer to the accompanying technology display The probabilities were obtained by entering the values of n = 5 and p = 0.751. In a clinical test of a drug, 75.1% of the subjects treated with 10 mg of t...
Refer to the accompanying technology display The probabilities were obtained by entering the values of n = 5 and p = 0.751. In a clinical test of a drug, 75.1% of the subjects treated with 10 mg of the drug experienced headaches. In each case, assume that 5 subjects are randomly selected and treated...
1 answer
Q-1. You are testing a circular beam of two metals, 1045 steel and 2014-T6 aluminum, in...
Q-1. You are testing a circular beam of two metals, 1045 steel and 2014-T6 aluminum, in a rotating-cantilever beam fatigue test. If you need to choose one of these metals so that you can essentially design a part made of that metal, and subject the part to a repetitive stress-amplitude without ever ...
1 answer
The phylogenetic tree shown was constructed using a nucleotide distance matrix of Ebola virus isolates from...
The phylogenetic tree shown was constructed using a nucleotide distance matrix of Ebola virus isolates from Guinea in March 2014 (“G”), Sierra Leone (“S”), and Mali (“M”) in October/November 2014. Describe what the phylogeny revealed regarding the three Ebola outb...
1 answer
Dickinson Company has $12,140,000 million in assets. Currently half of these assets are financed with long-term debt at...
Dickinson Company has $12,140,000 million in assets. Currently half of these assets are financed with long-term debt at 10.7 percent and half with common stock having a par value of $8. Ms. Smith, Vice President of Finance, wishes to analyze two refinancing plans one with more debt (D) and one with ...