This is a comprehensive project which will be completed by individual students. PLAGARISM if found will be allocated 0 marks.

2. 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 should 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 along side industry analysis (250 words)

8. Students with highest risk and return ratio will be awarded an extra 2 marks as cherry on top for his stock selection.