- It has come to your attention that someone in the company hasnot been consistent in entering financial data – some years aremissing the relative percentage change or the net profit aspresented below in Table 1. You are required tocalculate the Relative Percentage Change in the company for theblanks below and the Net Profit for the other blanks.
Show all working outbelow including the formula used for each year and include thecompleted 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% |
|
Table1: Net Profit ($) per financial year
- Using Excel, create a column chartof the NetProfit calculated in part (a) for the years 2010-2019. For fullmarks, label the axis and provide an appropriate title.
(c) Using Excel, create aSparkling of the Relative Percentage Change calculated inpart (a) for the years 2011-2019. For full marks, use theSparkling options to mark if there are any negative valuesand include a horizontal axis to easily visualise changes. Thesparkline should be included here however you will also use it inthe report body text.
