Q1) You are required to calculate the Relative Percentage Change in the company for the blanks below and the Net Profit for the other blanks. Show all working out below including the formula used for each year and include the completed table here. Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Net Profit ($ 000’) 50 200 150 225 250 200 250 260 Relative Percentage Change N/A -50% 300% 50% 11% -30% 14% 25% Table 1: Net Profit ($) per financial year Q1 a) Using Excel, create a column chart of the Net Profit calculated in part (a) for the years 2010-2019. label the axis and provide an appropriate title. Q1 b) Using Excel, create a Sparkline of the Relative Percentage Change calculated in part (a) for the years 2011-2019. use the Sparkline options to mark if there are any negative values and include a horizontal axis to easily visualise changes. The sparkline should be included here however you will also use it in the report body text.
Q1) You are required to calculate the Relative Percentage Change in the company for the blanks below and the Net Profit for the other blanks.
Show all working out below including the formula used for each year and include the completed table here.
|
Year |
2010 |
2011 |
2012 |
2013 |
2014 |
2015 |
2016 |
2017 |
2018 |
2019 |
|
Net Profit ($ 000’) |
<blank> |
50 |
200 |
150 |
225 |
250 |
<blank> |
200 |
250 |
260 |
|
Relative Percentage Change |
N/A |
-50% |
300% |
<blank> |
50% |
11% |
-30% |
14% |
25% |
<blank> |
Table 1: Net Profit ($) per financial year
Q1 a) Using Excel, create a column chart of the Net Profit calculated in part (a) for the years 2010-2019. label the axis and provide an appropriate title.
Q1 b) Using Excel, create a Sparkline of the Relative Percentage Change calculated in part (a) for the years 2011-2019. use the Sparkline options to mark if there are any negative values and include a horizontal axis to easily visualise changes. The sparkline should be included here however you will also use it in the report body text.
Step by step
Solved in 2 steps
