In your position as research assistant to a portfolio manager, you need to analyze the profitability...

Transcribed Image Text:

In your position as research assistant to a portfolio manager, you need to analyze the profitability of the companies in the portfolio. Using the data Oracle Corporation (NASDAQ: ORCL) below: Fiscal Year 2019 2018 2017 2016 2015 Total Revenue 39506 39831 37728 37047 38226 Net Income 11083 3825 9335 8901 9938 a) Calculate the net profit margin for each year. b) Calculate the compound average annual growth rates (CAGR) for revenue and net income using the GEOMEAN function. c) Calculate the average annual growth rate of total revenues using the AVERAGE function. d) Create a Column chart of total revenue and net income. Be sure to change the chart so that the x-axis labels contain the year numbers and format the axis so that 2019 is on the far right side of the axis. e) Answer the following: 1. Is net income growing more slowly or faster than total revenue? Is this a positive for your investment in the company? Refer to your answer in b). 2. Is this result more or less accurate than your result in the previous question? Why? Refer to your answer in c). A B C D E F G H 1 Complete the highlighted parts and show the formulas if the number or figures are not provided in the problem. Orange Corporation 2 3 4 Sales 2022 99,506 2021 89,831 2020 2019 77,728 67,047 2018 58,226 5 Net Income 61,083 43,825 12,335 28,901 39,938 6 Net Profit Margin 7 Sales Growth 8 Net Income Growth 9 Change in Sales 10 Sales Growth 11 Sales Growth (arithmetic) 12 13 Create your chart here: 14 15 16 17 In your position as research assistant to a portfolio manager, you need to analyze the profitability of the companies in the portfolio. Using the data Oracle Corporation (NASDAQ: ORCL) below: Fiscal Year 2019 2018 2017 2016 2015 Total Revenue 39506 39831 37728 37047 38226 Net Income 11083 3825 9335 8901 9938 a) Calculate the net profit margin for each year. b) Calculate the compound average annual growth rates (CAGR) for revenue and net income using the GEOMEAN function. c) Calculate the average annual growth rate of total revenues using the AVERAGE function. d) Create a Column chart of total revenue and net income. Be sure to change the chart so that the x-axis labels contain the year numbers and format the axis so that 2019 is on the far right side of the axis. e) Answer the following: 1. Is net income growing more slowly or faster than total revenue? Is this a positive for your investment in the company? Refer to your answer in b). 2. Is this result more or less accurate than your result in the previous question? Why? Refer to your answer in c). A B C D E F G H 1 Complete the highlighted parts and show the formulas if the number or figures are not provided in the problem. Orange Corporation 2 3 4 Sales 2022 99,506 2021 89,831 2020 2019 77,728 67,047 2018 58,226 5 Net Income 61,083 43,825 12,335 28,901 39,938 6 Net Profit Margin 7 Sales Growth 8 Net Income Growth 9 Change in Sales 10 Sales Growth 11 Sales Growth (arithmetic) 12 13 Create your chart here: 14 15 16 17