Evaluate your portfolio to analyze

Assignment Help Finance Basics

Reference no: EM133558096

Question: You are an investor who decided to purchase shares in Apple on May 6th, 2020. Six years later, you want to evaluate your portfolio to analyze whether or not your investment was "worthwhile." The table below shows the end of May market prices for AAPL:

Enter the data into a worksheet and format the table as shown.
Add a new column and use a formula to calculate your rate of return for each year.
Format the data as percentages with four decimal places.
Add another column and use a formula to calculate the cumulative total return from May 2020 to the end of May of each year. Keep consistent with the format above.
Calculate the total return for the five-year holding period. What is the compound average annual growth rate (CAGR) of your investment?
Show a line chart showing the stock price from May 2020 to May 2026. Be sure to title the chart and label the axes. Title the chart "Apple Stock Prices." The axes should be labeled with each year.
Show an XY Scatter chart of the same data.
At the end of your analysis, was your investment indeed "worthwhile." What did you find out? What were the positives if any? What were the negatives if any?

Reference no: EM133558096

Questions Cloud

Explain why you think you scored way you did in each of skil : Explain why you think you scored way you did in each of skills. How your strengths can promote a positive culture in a global environment, providing examples.

Comparing this empirically observed relationship : Comparing this empirically observed relationship with the predicted relationship from 1b, are they the same or different? What conclusion can you draw from

Types of consumer promotions : There are a number of types of consumer promotions: coupons, premiums, contests and sweepstakes, refunds and rebates, sampling, bonus packs.

Can you rank the projections simply by inspecting the cash : Can you rank the projections simply by inspecting the cash flow? 2. What criteria might you use to rank the projects?

Evaluate your portfolio to analyze : Evaluate your portfolio to analyze whether or not your investment was "worthwhile." The table below shows the end of May market prices for AAPL

Describe process of collecting data throughout intervention : Identify your research design. When and how will you collect your baseline data? Describe the process of collecting data throughout the intervention phase.

Why is it that in a real estate organization : Why is it that in a real estate organization, the focus and marketing platform will need to be flexible as the market is often unstable and unpredictable?

Identify an example of a corporate-level plan : Review the details in this case and identify an example of a corporate-level plan or strategy and a functional-level plan of strategy.

Pursue her interest in exploring how state funding : Dr. Jennings encouraged Ms. Thayer-Miller, a member of the financial operations department, to pursue her interest in exploring how state funding and local

User Account

All Pages