Investment Portfolio Analysis Hi. I need an investment portfolio analysis done on 20 stocks over a period of 25 days using Excel. Please see the attachment

Investment Portfolio Analysis Hi. I need an investment portfolio analysis done on 20 stocks over a period of 25 days using Excel. Please see the attachment

Click here to Order a Custom answer to this Question from our writers. It’s fast and plagiarism-free.

Hi. I need an investment portfolio analysis done on 20 stocks over a period of 25 days using Excel. Please see the attachment.


Term Paper and Excel Spreadsheet

Invest $100,000 of “funny” money in twenty different companies. In ten different industries:   

1. Technology and communications

2. Biomedical

3. Transportation

4. Entertainment

5. Consumer goods

6. Apparel

7. Soft drinks

8. Communications

9. Pharmaceuticals

10. Oil & gas

 

The minimum requirements for the Portfolio analysis:

 

1. Show your investments in twenty (20) well DIVERSIFIED investments.

2.Please indicate the industry or the specific section (i.e. gold, oil & gas, technology, entertainment, transportation, consumer goods, bio-technology, pharmaceuticals, etc.) that each investment represents.

3.The TOTAL Dollar amount of return (Profit/Loss) from 2/28/2022 until 3/25/2022.

4.The percentage return.

5.Specify the holding period or duration of the investments in the portfolio.

6.Show the percentage return calculated in the above item number 4 on an annualized basis.

***THE ABOVE CALCULATIONS MUST BE SHOWN IN EXCEL***

Please summarize your findings in a 4-6 page APA formatted paper and explain how this data analysis could benefit companies. Be sure to provide good examples using the textbook and the internet.

Stock Categories

Technology & Communications

Apple (APPL) – $5,000

Meta (FB) – $5,000

Biomedical

Novavax (NVAX) – $5,000

Vertex Pharmaceuticals (VRTX) – $5,000

Transportation

CSX Corporation (CSX) – $5,000

Norfolk Southern (NSC) – $5,000

Entertainment

Netflix (NFLX) – $5,000

Disney (DIS) – $5,000

Consumer Goods

Procter & Gamble (PG) – $5,000

Costco (COST) – $5,000

Apparel

Nike (NKE) – $5,000

Lululemon (LULU) – $5,000

Soft Drinks

The Coca-Cola Company (KO) – $5,000

PepsiCo, Inc (PEP) – $5,000

Communications

AT&T, Inc. (T) – $5,000

Verizon Communications, Inc. (VZ) – $5,000

Pharmaceutical

Pfizer, Inc. (PFE) – $5,000

Merck & Co. Inc (MRK) – $5,000

Oil and Gas

Chevron Corporation (CVX) – $5,000

Exxon Mobil Corporation (XOM) – $5,000

Place your order now for a similar assignment and have exceptional work written by one of our experts, guaranteeing you an A result.

Need an Essay Written?

This sample is available to anyone. If you want a unique paper order it from one of our professional writers.

Get help with your academic paper right away

Quality & Timely Delivery

Free Editing & Plagiarism Check

Security, Privacy & Confidentiality