Question: PLEASE SHOW WORK IN EXCEL!!!!! PLEASE SHOW WORK IN EXCEL!!!!! you have $250,000 to invest in a stock portfolio. Your choices are Stock H, with

PLEASE SHOW WORK IN EXCEL!!!!!

you have $250,000 to invest in a stock portfolio. Your choices are Stock H, with an expected return of 14 percent, and Stock L, with an expected return of 10.1 percent. If your goal is to create a portfolio with an expected return of 12 percent, how much money will you invest in Stock H and in Stock L?

Note: Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.

investment in stock H:

investment in stock L:

PLEASE SHOW WORK IN EXCEL!!!!!

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!

please show work in excel 4. The Excel file Stock Data contains monthly return data for seven (7) stocks. a. Use these returns and the Matrix of Excess Returns to compute the Variance-Covariance...

PLEASE SHOW WORK IN EXCEL!!!!! You have $19,000 to invest in a stock portfolio. Your choices are Stock X with an expected return of 15 percent and Stock Y with an expected return of 12 percent....

Please show work in excel with correct cell formulas. Thank you Managerial Finance 1. You bought a stock one year ago for $51.53 per share and sold it today for $58.26 per share. It paid a $1.59 per...

Please show the complete excel formula and steps to solve problem You have $10,000 to invest in a stock portfolio. Your choices are Stock X and Stock Y with their expected returns in the table below....

please show work in excel 5. The Excel file Correlation Matrix Data contains monthly return data for eight (8) stocks. a. Compute the Correlation Matrix for the eight (8) stocks. b. Using EXCEL's...

Please show work on excel, need help understanding! Starbies Corporation Financial Information The company had total sales of $329 million with net income of $14 million in 2002. The Company posted a...

Question: *****Risk and Return, PLEASE SHOW WORK IN EXCEL SO THAT I CAN LEARN**** I need all answers done..... *****Risk and Return, PLEASE SHOW WORK IN EXCEL SO THAT I CAN LEARN**** I need all...

for any calculation please use an excel formula and for questions 8 and 9 only calculate the expected returns. please show work as well Portfolio Returns Exercise Stock A Weight - 0.50 1. The return...

Please show work in EXCEL and use individual cell work. a. Use the data given to calculate annual returns for Goodman, Landry, and the Market Index, and then calculate average returns over the...

*****Risk and Return, PLEASE SHOW WORK IN EXCEL SO THAT I CAN LEARN**** I need all answers done... Please number 1, 2, 3, 4, 5 Note on reading Ch. 11: you will not calculate standard...

Which financial statement shows that a company's resources equal claims to those resources? Statement of Stockholders Equity. O Income Statement. Balance Sheet. Statement of Assets, Liabilities and...

A pion is created in the higher reaches of Earth's atmosphere when an incoming high-energy cosmic ray particle collides with an atomic nucleus. A pion so formed descends toward Earth with a speed of,...

2. Use Worksheet 1.1. Describe your current status based on the personal financial planning life cycle shown in Exhibit 1.7. Fill out Worksheet 1.1, Summary of Personal Financial Goals, with goals...

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

evaluate and draft recruitment and selection policies and procedures

understand the role of human resource managers and line managers in the recruitment and selection process

2. Why are there so few female engineers compared to male engineers and what can the engineering sector do to encourage females to take up a career in engineering?