Question: DO IT USING EXCEL, AND POST THE EXCEL SCREENSHOT AND FORMULA IN EXCEL SCREENSHOT. THANK YOU Question 23 5 pts You want to create a

DO IT USING EXCEL, AND POST THE EXCEL SCREENSHOT AND FORMULA IN EXCEL SCREENSHOT. THANK YOUDO IT USING EXCEL, AND POST THE EXCEL SCREENSHOT AND FORMULA IN

Question 23 5 pts You want to create a $72,000 portfolio comprised of two stocks plus a risk-free security. Stock A has an expected return of 13.6 percent and Stock B has an expected return of 14.7 percent. You want to own $25,000 of Stock B. The risk-free rate is 3.6 percent and the expected return on the market is 12.1 percent. If you want the portfolio to have an expected return equal to that of the market, how much should you invest in the risk-free security? $12,987 $12,921 $13,315 $12,775 $13,550

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
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!