Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Prepare a portfolio of 15 Assets (12 Stocks exchange listed companies preferably from US Stock exchange as data is readily available, 3 commodities oil, gold

image text in transcribed
Prepare a portfolio of 15 Assets (12 Stocks exchange listed companies preferably from US Stock exchange as data is readily available, 3 commodities oil, gold or crypto) 3. Set up an objective of your portfolio (high risk, low risk, target audience, benchmark) objective shondd not exceed 250 words 4. Prepare returns for assets, compute beta, alpha of individual stock and protfolio as whole 5. Use solver function in excel to maximise returns and minimise risks. 6. Draw efficient market frontier of your data 7. Assuming you have held this portfolio for an year now. Comment on last years performance of your protfolio against benchmark (500 words maximum, write economic analysis (in this case USA if yu have selected companies from US Stock exchange) 250 words maximum alone side industry analysis (250 words) Prepare a portfolio of 15 Assets (12 Stocks exchange listed companies preferably from US Stock exchange as data is readily available, 3 commodities oil, gold or crypto) 3. Set up an objective of your portfolio (high risk, low risk, target audience, benchmark) objective shondd not exceed 250 words 4. Prepare returns for assets, compute beta, alpha of individual stock and protfolio as whole 5. Use solver function in excel to maximise returns and minimise risks. 6. Draw efficient market frontier of your data 7. Assuming you have held this portfolio for an year now. Comment on last years performance of your protfolio against benchmark (500 words maximum, write economic analysis (in this case USA if yu have selected companies from US Stock exchange) 250 words maximum alone side industry analysis (250 words)

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

Finance For Beginners

Authors: Shlomo Simanovsky

1st Edition

1936703009

More Books

Students also viewed these Finance questions