90.2K

Verified Solution

Link Copied!

QUESTION 2 [28 marks] Suppose that on January 14, 2018, you purchased shares in Narex Inc. (JSE: Narex). It is now five years later, and you decide to evaluate your holdings to see if you have done well with this investment. The table below shows the end of June market prices of Narex. Required: Perform the following tasks: - Enter the data into a worksheet and format the table as shown above. - Add a new column and use a formula to calculate your rate of return for each year. Format the data as percentages with two decimal places. (show normal and formula view) - Add another column and use a formula to calculate the cumulative total return from June 2018 to end of June of each year. - Calculate the total return for the five-year holding period. What is the compounded average annual growth rate (CAGR) of your investments? - Create a Line chart showing the stock price from June 2018 to June 2023. (title and label the axes) - Now, create a Scatter chart of the same data. - Conclude by starting the difference between the two charts if any and identify which chart if more appropriate for this data. QUESTION 2 [28 marks] Suppose that on January 14, 2018, you purchased shares in Narex Inc. (JSE: Narex). It is now five years later, and you decide to evaluate your holdings to see if you have done well with this investment. The table below shows the end of June market prices of Narex. Required: Perform the following tasks: - Enter the data into a worksheet and format the table as shown above. - Add a new column and use a formula to calculate your rate of return for each year. Format the data as percentages with two decimal places. (show normal and formula view) - Add another column and use a formula to calculate the cumulative total return from June 2018 to end of June of each year. - Calculate the total return for the five-year holding period. What is the compounded average annual growth rate (CAGR) of your investments? - Create a Line chart showing the stock price from June 2018 to June 2023. (title and label the axes) - Now, create a Scatter chart of the same data. - Conclude by starting the difference between the two charts if any and identify which chart if more appropriate for this data

Answer & Explanation Solved by verified expert

See Answer