Question

AutoSave DH P rilidl Side rent - bruglord roods - Neu-UHY - ELEI Draw Page Layout Formulas Data Review View Help Search File m LL - Arial . General Neutr Home Insert X cut Copy Format Painter Clipboard - 10-AA BIU. 2. OA Wrap Text Merge & Center Normal Conditional Format as Check Cell Formatting Table Bad Good Explanatory... Input Linked Font Alignment Styles MS C D E 1 Consolidated Statements of Operations. USD ($) $ in Thousands VOL. 20, NUV.UZ INOV. , % Nov. 03, 2017 % % Average Percentage Nov. 02, 2020 $ 140,063 84,850 55,213 44,377 $ 167,223 105,637 61,586 48,816 4 Net sales 5 Cost of products sold 6 Gross margin 7 Selling, general and administrative expenses 8 Gain (loss) on sale of property, plant and equipment 9 Income before taxes 10 Provision for benefit on) income taxes 11 Net income $ 174,257 117,751 56,506 49,929 6,236 12,813 6,296 $6,517 $ 188,785 127,121 61,664 52,837 (290) 8,537 2,053 $ 6,484 10,836 3,066 $7,770 12,828 3,999 $ 8,829 15 Enter ratios in columns B,D, F, H, and L NA NA Profit Margin Ratio Gross Profit (margin) Ratio Return on Assets Return on Equity Inventory Turnover Days Sales in Inventory Receivables Turnover Days' Sales in receivables NA N/A NIA NA Income Staf ment Balance Sheet E O Type here to search

Answer 1

The Balance sheet figures are not shared. Hence, the calculations are done basis the available info.

		Oct-16	% of sales	Nov-17	% of sales	Nov-18	% of sales	Nov-19	% of sales	Avg %	Nov-20	Calculation
										Average of Columns D,F,H,J
(i)	Net sales	140063		167223		174257		188785			200112.1	188785*1.06
(ii)	COGS	84850	60.6%	105637	63.17%	117751	67.57%	127121	67.34%	64.7%	129402.9	200112.1*64.7%
(iii)	Gross margin	55213	39.4%	61586	36.83%	56506	32.43%	61664	32.66%	35.3%	70709.22	200112.1*35.3%
(iv)	Selling, general and admin expenses	44377	31.7%	48816	29.19%	49929	28.65%	52837	27.99%	29.4%	58791.03	200112.1*29.4%
(v)	Gain (loss) on sale of property, plant and equipment		0.0%	58	0.03%	6236	3.58%	-290	-0.15%	0.9%	1730.816	200112.1*0.9%
(vi)	Income before taxes	10836	7.7%	12828	7.67%	12813	7.35%	8537	4.52%	6.8%	13649.01	200112.1*6.8%
(vii)	Provision for (benefit on) income taxes	3066	2.2%	3999	2.39%	6296	3.61%	2053	1.09%	2.3%	4643.085	200112.1*2.3%
(viii)	Net income	7770	5.5%	8829	5.28%	6517	3.74%	6484	3.43%	4.5%	9005.922	200112.1*4.5%
	Profit margin ratio …………….[(viii)/(i)]	5.55%		5.28%		3.74%		3.43%
	Gross profit margin ratio…………[(iii)/(i)]	39.42%		36.83%		32.43%		32.66%
	Return on assets	Need B/S data
	Return on Equity	Need B/S data
	Inventory Turnover	Need B/S data
	Days' Sales in Inventory	Need B/S data
	Receivables Turnover	Need B/S data
	Days' Sales in Receivables	Need B/S data