Reference no: EM133067944

Skills Test

Scenario:

Assume you are the financial analyst of a Quark Ltd. The organisation wants you to conduct a trend analysis on the comparative statement of financial performance and position for the year 2012-2017. 

The comparative statements of financial performance and statements of financial position of Quark Ltd are shown below:

QUARK LTD Comparative Statements of Financial Performance for the years ended 30 June 2012-2017 (000 omitted)
		2012	2013	2014	2015	2016		2017
Sales revenue		$250	$263	$262	$270	$325		$348
Less: Cost of goods sold		$152	$156	$153	$157	$180		$215
GROSS PROFIT		$98	$107	$109	$113	$145		$133
Operating expenses		$68	$71	$69	$84	$94		$95
OPERATING PROFIT		$30	$36	$40	$29	$51		$38
QUARK LTD Comparative Statements of Financial Position for the years ended 30 June 2012-2017 (000 omitted)
		2012	2013	2014	2015	2016		2017
ASSETS
Cash at bank		$15	$16	$15	$22	$21		$12
Trade debtors		$21	$25	$23	$36	$43		$62
Inventory		$62	$70	$74	$98	$125		$133
Plant and equipment		$150	$162	$173	$290	$286		$283
		$248	$273	$285	$446	$475		$490
LIABILITIES AND SHAREHOLDERS' EQUITY
Trade creditors		$53	$65	$70	$96	$116		$126
Non-current liabilities		$60	$58	$55	$125	$121		$119
Paid-up capital		$100	$100	$100	$150	$150		$150
Retained profits		$35	$50	$60	$75	$88		$95
		$248	$273	$285	$446	$475		$490

Task: 

Required: 

1. Prep are in MS Excel, a trend analysis of the data. (Give the printouts of the MS Excel sheet to the trainer/assessor along with the screenshot of each step performed)
2. Ident ify the key significant trends identified during the analysis and wr ite an email to the CEO of the organisation (your trainer/assessor) explaining the situation during different years.
3. Assuming that the sales revenue is 15% more than the given figures, perform step a and b again.

Note:

The organisation requirements for the preparation of a business document is the same as that of assessment task 2. (Please refer to assessment task 2).