Question

1. It has come to your attention that someone in the company has not been consistent in entering financial data – some years are missing the relative percentage change or the net profit as presented below in Table 1.  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

2. Using Excel, create a column chartof the Net Profit calculated in part (a) for the years 2010-2019. For full marks, label the axis and provide an appropriate title.

(c) Using Excel, create a Sparkling of the Relative Percentage Change calculated in part (a) for the years 2011-2019. For full marks, use the Sparkling 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.

Answer 1

Ans-(a)

Completed Profit Table and workings in arriving thereof.Yellow Marked cells were missing which have been filled

Ans-(b)

Column Chart:

Ans-(c )

Sparkleline