Question

How to compare my Investopedia stock market returns with the s&p 500 returns at a $100...

How to compare my Investopedia stock market returns with the s&p 500 returns at a $100 level when my portfolio is changing as I buy different stocks through a period of time? So basically I want to create a chart with 2 lines for each.

So let's say I have $10,000 to invest when trading starts on Monday and I make the following trades through the week. I buy $4000 of apple stock on one Monday, then $4000 of Delta airlines stock some other Tuesday, and $1000 of Facebook also on a Friday  (so I have 1,000 to spare). When the trading "ends", how would you answer the above question?

I am not well versed in Excel so as much detail you could provide would be greatly appreciated. Thank you for taking the time.

Business   Accounting   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1
Portfolio Chart
Day Amount Invested SPDR S&P 500 ETF (SPY) IRR IRR Remarks
Monday Apple stock $ 4000 8.3 25.4 Stocks have good IRR prevailed in the market
Tuesday Delta Airlines Stock $ 4000 8.9 10.04 That is also good stock but less beneficial as compared with Apple Stock
Friday Face Book Stock $ 1000 17.5 2463.2 This is the best stock in the total portfolio we have as it has best IRR and Best S&P IRR
Bank Balance In hand $ 1000
Total Portfolio $ 10000
0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
1. Why do we use percentage returns rather than dollar returns when we compare returns? 2....
1. Why do we use percentage returns rather than dollar returns when we compare returns? 2. Last year your portfolio made 15%; the stock market made 10%, and the risk free rate was 2%. If the CAPM is correct, what must the beta of your portfolio be? 3. The world can change but basic financial math doesn’t. The obvious decreases in future cash flows from the virus is bringing stocks down. What is the other, probably more important factor driving...
Now consider the following argument: Historically the stock market goes up when there is bad news...
Now consider the following argument: Historically the stock market goes up when there is bad news on unemployment. The latest statistics show the unemployment rate is skyrocketing so this could be a good time to buy stocks. The arguments target is: Bad news on unemployment The stock market in the past when there is bad news on unemployment The stock market now Flag this Question Question 75 pts Consider the following argument: A 35 percent approval rating? Those polls are...
1. Stock XYZ is currently trading at $35.48. You want to enter the market at $33....
1. Stock XYZ is currently trading at $35.48. You want to enter the market at $33. All of the following orders can be used EXCEPT (1 point): Stop buy Stop sell Market Limit sell 2. Oak Street Health went public on August 6, 2020 with an IPO price of $21 per share. Go to Yahoo Finance, obtain the closing price on its first trading day and calculate the IPO underpricing (1 point): 149.5% 190.5% 90.5% 49.5% 3. You want to...
In 100 words state if you agree/disagree with the summary made about the adjustments needed for...
In 100 words state if you agree/disagree with the summary made about the adjustments needed for the plan of action. NOTE: Scenario Part 2 is also provided. Work place unrest Part two provides additional information based on talking with your people. Jill: You met Monday afternoon and had a positive and productive discussion. She reiterated what HR had said to me concerning email and talking to Jill. Jill felt she was not challenged job wise and that her and Jack...
The questions: 1. What type of technology Acme and Omega utilize to transform inputs into outputs?...
The questions: 1. What type of technology Acme and Omega utilize to transform inputs into outputs? 2. Which strategic choice (differentiation or cost leadership) suits best to Acme? Omega? Do these companies have clear strategic choices or do they stuck in the middle? 3. Based on all the contingencies which type of structure is more suitable for these companies; mechanistic or organic? please answer each question alone The Paradoxical Twins: Acme and Omega Electronics John F. Veiga Part! boom of...
Whatever It Takes: How the Fed Aims to Rescue the Economy The central bank is using...
Whatever It Takes: How the Fed Aims to Rescue the Economy The central bank is using tactics from the last financial crisis and deploying new ones to keep money flowing. Here are the basics. The Federal Reserve, under Jerome H. Powell, is moving to shore up the American economy during the coronavirus pandemic. Credit...Yuri Gripas/Reuters By Ben Casselman March 23, 2020 The Federal Reserve on Monday pledged to do, in essence, whatever it takes to keep the economy from collapsing...
Elon Musk wasn’t smiling, when he said, “Welcome to Model 3 handover.” Through a single silver...
Elon Musk wasn’t smiling, when he said, “Welcome to Model 3 handover.” Through a single silver door, a few moments before, he had entered the room, flanked by nearly two dozen employees including an engineer and designer who joined him on stage. Black floor, rich red curtains, and slate grey backdrop and a white Tesla logo. There were no introductions necessary. At first, Musk’s voice had a breathy quality. He seemed nervous. Nerves were understandable on the precipice of what...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary rivals? How will the acquisition of Reebok by Adidas impact the structure of the athletic shoe industry? Is this likely to be favorable or unfavorable for New Balance? 2- What issues does New Balance management need to address? 3-What recommendations would you make to New Balance Management? What does New Balance need to do to continue to be successful? Should management continue to invest...
Chick-fil-A is dominating the U.S. fast-food market. Whereas McDonald’s, Subway, Burger King, and Taco Bell trudge...
Chick-fil-A is dominating the U.S. fast-food market. Whereas McDonald’s, Subway, Burger King, and Taco Bell trudge along at the top of the heap, Chick-fil-A has quietly risen from a South- east regional favorite to become the largest chicken chain and the eighth-largest quick-service food purveyor in the country. The chain sells significantly more food per restaurant than any of its competitors—twice that of Taco Bell or Wendy’s and more than three times what the KFC Colonel fries up. And it...
Discuss how the respective organizations’ relations with stakeholders could have potentially been affected by the events...
Discuss how the respective organizations’ relations with stakeholders could have potentially been affected by the events that took place at Enron and how the situation could have been dealt with differently to prevent further damage? THE FALL OF ENRON: A STAKEHOLDER FAILURE Once upon a time, there was a gleaming headquarters office tower in Houston, with a giant tilted "£"' in front, slowly revolving in the Texas sun. The Enron Corporation, which once ranked among the top Fortune 500 companies,...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT