Hello there! Want a discount? Grab 5% OFFon your first order!
originalresearchpapers.com logo
Hello there! Want a discount? Grab 5% OFF on your first order!
originalresearchpapers.com logo

Risk, Return, and the Historical RecordThroughout the semester, we are going to learn about the benefits of diversification, which is how we can

Risk, Return, and the Historical Record

Throughout the semester, we are going to learn about the benefits of diversification, which is how we can greatly reduce the uncertainty around our expected returns. To get started in the stock market game, make sure your portfolio contains
at least ten assets, either stocks or ETFs.

On the second page, you find the mutual sheet that we started to discuss in lecture. We are going to focus on the sections highlighted in blue . For this homework assignment, you are going to study the ten largest holdings of your portfolio.

To prepare, go to finance.yahoo.com and enter the tickers for the ten largest holdings in your portfolio. For each of them, click on “Historical Data”, indicated on the screenshot below.

Select the time period from June 30, 2021, to June 30, 2023. Download the data and open it in Excel. Using the column “Adj. Close”, compute the daily returns on day
t as

where is the stock price on that day and is the stock price on the day prior.

Problem 1.

From the daily data, compute the expected
annual return and
annualized standard deviation of each stock. Assume a risk-free rate of per year to find the Sharpe ratio.

Problem 2.

Identify the sector of each of your investments, report the YTD return (the return from Jan 1 until today) and the weight in your portfolio.

Problem 3.

Find the overall sector weightings of your portfolio using the info from Problem 2.

Submit your work as an Excel File –

Make sure it’s well organized and readable!

image1.png

image2.tiff

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Improving Business PerformanceWeek 2 DiscussionColleagues 1 Lyndsay

Improving Business Performance Week 2 Discussion Colleagues 1 Lyndsay Camaroto Hello, The organization I chose is the one I work at as well, Even though for me I have had great experiences as an employee and have really grown in my career. From a Moral standpoint, there are instances where

PIQ#3Discusion 3 Note: followed two responses  Your initial response must be a minimum of 300 words. Healthcare organizations use various Key

PIQ#3Discusion 3 Note: followed two responses  Your initial response must be a minimum of 300 words. Healthcare organizations use various Key Performance Indicators (KPIs) and Quality Metrics to measure performance. This activity allows you to practice researching and using data to inform quality improvement decisions. For this discussion board: 1. Select one

see attachedMBA 560 – FINANCIAL STATEMENT ANALYSIS RUBRICName:Date Completed:Students will complete the assignment with attention to the

see attached MBA 560 – FINANCIAL STATEMENT ANALYSIS RUBRIC Name: Date Completed: Students will complete the assignment with attention to the criteria below. GRADE: Exceptional Proficient Basic Insufficient /Missing/Late Company Selection Minus 10 points if late Financial Statements Minus 10 points if late Company/Industry Section Horizontal Analysis 3 accounts/line items

Create an 8–12-slide PowerPoint presentation that summarizes the AFI Framework and the results of the internal and external analyses. Your presentation

Create an 8–12-slide PowerPoint presentation that summarizes the AFI Framework and the results of the internal and external analyses. Your presentation must also include a SWOT matrix for the company and your recommendations for strategies to move the company forward that align with organizational structure and governance, and reflect ethical

You deserve a bonus!

Subscribe and get regular bonuses and discounts.