Assignment Task
Task
You are required to demonstrate your understanding of portfolio construction using real stock price data.
Question-1: Build a financial model in MS-Excel that uses the stock prices data (from yahoo finance) and builds an optimum portfolio. Ensure that the model computes the portfolio return, risk and Sharpe ratio for the optimum portfolio. THE PORTFOLIO SHOULD BE CONSTRUCTED USING FIVE STOCKS. Also make provision for customizing the portfolio for changing risk aversion of the investor
Question-2: Write a script in R-Studio that computes the portfolio return, portfolio standard deviation, CAPM Beta of the portfolio, Jensen’s Alpha of the portfolio and the Sharpe Ratio of the portfolio. The model should be customizable for any number of stocks user would like to input
Question-3: Write a script in R-Studio that constructs an optimum portfolio and also shows the rebalancing strategy and returns thereof. Generate charts wherever required. Make suitable assumptions.
Welcome to our Online Essay Writing Agency. Securing higher grades costing your pocket? Order your assignment online at the lowest price now! Our online essay writers are able to provide high-quality assignment help within your deadline. With our homework writing company, you can order essays, term papers, research papers, capstone projects, movie review, presentation, annotated bibliography, reaction paper, research proposal, discussion, or another assignment without having to worry about its originality – we offer 100% original content written completely from scratch
A-Plus Writing Help For University Students
Get expert assistance in any academic field. All courses and programs covered.
Get Help Now!We write papers within your selected deadline. Just share the instructions
