Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Making Accountability Work Dilemmas For Evaluation And For Audit

Authors: Marie-Louise Bemelmans-Videc, Jeremy Lonsdale, Burt Perrin

1st Edition

1412865557, 978-1412865555

More Books

Students also viewed these Accounting questions

Question

Identify three ways to manage an intergenerational workforce.

Answered: 1 week ago

Question

Prepare a Porters Five Forces analysis.

Answered: 1 week ago

Question

Analyze the impact of mergers and acquisitions on employees.

Answered: 1 week ago