Using Excel, design and create the visualization that best plots the stocks in your portfolio. Your visualization should include all three corporations’ activities; that way the reader can contrast and compare the fluctuations of stock values over time. Do not overburden the design with too many labels; if necessary, create an explanatory legend. Make sure the final product is readable and undistorted as well as properly sized for legibility. Place it into the report using appropriate APA format. [MO 6.1, MO 6.2, MO 6.3]

Within your report, ensure that you address the following points:

1. What was the total value of your original investment?

2. What dollar amount (of the original $50,000) remained in the investment account?

3. Assume that the account would receive an annual rate of interest of 1¾%. How much interest would you have earned during the term?

4. Calculate the gain/loss for each stock if the portfolio was sold today. Generate a summary table for comparison to assist the reader with a snapshot view of your portfolio’s performance.

5. Rank the investments from the highest yield to the lowest yield. Assume management fees are ½% of the total sale price. What was the total gain/loss of the portfolio?

6. What was the rate of return for this investment? How does the rate of return compare to your required rate of return? (See cell F2 of your spreadsheet

Answer rating: 100% (QA)

I can guide you on how to approach creating the visualization and addressing the points in your repo... View the full answer