Question

Selected comparative statement data for SuperAmart Pty Ltd is presented as below:

	2016	2017 ($)	2018 ($)
Net sales		$500 000	$620 000
Cost of goods sold		280 000	360 000
Gross profit
Selling and administration expense		5 000	6 000
Finance cost		6000	6000
Profit
Cash at Bank		60 000	80 000
Inventory (30 June)		55 000	65 000
Total assets (30 June)	600 000	640 000	700 000
Total liabilities (30 June)		200 000	180 000

Required:

1. Calculate profit and gross profit for both 2017 and 2018
2. Compute and comment on the following (for both years)
   1. Profit margin ratio
   2. Gross profit ratio
   3. Asset turnover ratio
   4. Return on assets
   5. Debt ratio

Answer 1

SuperAmart Pty Ltd
Comparitive Statement Data
			(Amt in $)
		2017($)	2018($)
Net Sales		500000	620000
Less: Cost Of Goods Sold		280000	360000
Gross Profit		220000	260000
Seling & Admin Exp		5000	6000
Finance Cost		6000	6000
Net Profit		209000	248000
i) Profit margin Ratio
(Net Income/ Net Sales)		41.80%	40.00%
ii) Gross Profit ratio		44.00%	41.94%
Gross Profit/ Net Sales)
iii) Asset Turnover Ratio		0.81	0.93
(Net Sales/Average Total Asset)
Avergae Total asset		620000	670000
(Op Asset + Closing Asset)/2
iv) Return On Asset		0.34	0.37
(Net Income/Average Total Asset)
v) Debt Ratio		0.31	0.26
(Total Debt/ Total Asset)