Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Let's assume that you have $50,000 to invest in a two-stock portfolio. The selected stocks are AXP and FB. Using excel, show the optimal portfolio

image text in transcribed
Let's assume that you have $50,000 to invest in a two-stock portfolio. The selected stocks are AXP and FB. Using excel, show the optimal portfolio that will maximize the portfolio return and minimize the portfolio risk. Show all the calculations in excel. Use monthly stock price dat for the past three years. Your excel file should include the following: (1) calculation of risk, return, sharp ratio. (6 points) (2) Optimal portfolio weights. (3 points) (3) A chart showing the optimal portfolio. (4 points) (4) How much money in $) will you invest in AXP and FB? (2 points) N:B: Please upload the excel file. Check you have all the formulas before uploading. Make sure you save your file in xls, xlsx, or excel workbook format. Do not work on CSV format. Let's assume that you have $50,000 to invest in a two-stock portfolio. The selected stocks are AXP and FB. Using excel, show the optimal portfolio that will maximize the portfolio return and minimize the portfolio risk. Show all the calculations in excel. Use monthly stock price dat for the past three years. Your excel file should include the following: (1) calculation of risk, return, sharp ratio. (6 points) (2) Optimal portfolio weights. (3 points) (3) A chart showing the optimal portfolio. (4 points) (4) How much money in $) will you invest in AXP and FB? (2 points) N:B: Please upload the excel file. Check you have all the formulas before uploading. Make sure you save your file in xls, xlsx, or excel workbook format. Do not work on CSV format

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Contemporary Financial Management Fundamentals

Authors: R. Charles Moyer, James R. McGuigan, Ramesh P. Rao

1st Edition

0324015771, 9780324015775

More Books

Students also viewed these Finance questions

Question

3. What is the primary goal of a financial plan?

Answered: 1 week ago