The model should contain the following:
The optimal portfolio for the selected stocks should be identified
This is the portfolio that maximises the Sharpe ratio
The minimum variance portfolio for the selected stocks should be identified
The model should be capable of allowing the user to prevent short-selling and also to set different levels at which short
selling may occur
Short-selling is the situation where a portfolio may contain a negative weight on a security (essentially you are selling a security you do not own) with the additional funds received from the sale being used to boost ownership in other assets. As a result the total portfolio should still come to a weight of 100%.
Where levels of short selling are allowed, this should limit the entire portfolio, not just individual stocks i.e. the portfolio may have a total of 10% short selling.
The model should have a graph that shows individual stocks, the minimum variance portfolio and the optimal portfolio.
All inputs (if any) and outputs should be shown on a summary page
The model should conform to the rules of good design.
The calculator will only be marked if it is built within the spreadsheet file [url removed, login to view] available from Blackboard. Students are expected to be able to explain or demonstrate any features or techniques in their assignments if requested.
9 pekerja bebas membida secara purata ₹11705 untuk pekerjaan ini
I am stock market analyst for past 10yrs & has advance ms office skills. Relevant Skills and Experience Advance ms excel knowledge with knowledge of financial markets.