Question

calculate the following ratios for the years ended December 31, 2017 and December 31, 2016. At December 31, 2015, Spin Master had an accounts receivable balance of $134,618,000 and net sales of $879,406,000. Comment on the change.

a. Accounts receivable turnover ratio (round to two decimal places)

b. Days’ sales in inventory (round to the nearest day)

for the year ended December 31. 2017 2016

-------------------------------------------------------------------------------------------------------------------------

revenue 1,551,324 1,154,454

cost of sales 750,868    557,712

--------------------------------------------------------------------------------------------------------------------------

gross of profit 800,456. 596,742

=====================================================================

expenses

selling, marketing,distribytion and product development 312,186. 243,689

administrative expenses 262,066. 201,008  

other expenses 6,700 35

foreign exchange (gain) loss 11,370 5,530

--------------------------------------------------------------------------------------------------------------------------

income before income tax expenses 220,429 137,879

income tax expenses 59,363 38,364

--------------------------------------------------------------------------------------------------------------------------

net income 161,066 99,515

items that may be subsequently rec;assofied to net income or loss

currency translation adjustment     3,255 863

other comprehensive income (loss) 3,255 863

earnings per share

basic and diluted 1.58 0.99

weighted average number of common shares outstading

basic        101,846,680. 100,702,757

dilute            101,846,680      100,702,757

=====================================================================

consulted statement of financial position as at December 31,2017 and December 31,2016

assets

current assets

cash 117,262, 99,416

trade and other receivables 389,719. 295,068

inventories 120,329 79,924

prepared expenses 20,500. 21,398

--------------------------------------------------------------------------------------------------------------------------

627,810 495,806

non-current assets   

advances on royalties 5,000 11,695

property, plant and equipment 32,978. 26,996

intangible assets     145,165 130,390

goodwill 105,487. 91,707

deferred tax assets 21,945 19,002

--------------------------------------------------------------------------------------------------------------------------

total assets    938,385 775,596

=====================================================================li

liabilities

current liabilities

trade payables and other liabilities 350,754. 228,935

loans and borrowings    531. 158,107   

deferred revenues 10,472 5.500

provisions 25,398 26.454

interest payable 45 6

income tax payable 37,290 12,331

--------------------------------------------------------------------------------------------------------------------------

424,493. 431,333

( I hope this time I can get anwer to my question )

Answer 1

For Days’ sales in inventory Of 2016 & 2017, we require COGS, Inventory , Total Days per year.

Inventory		COGS
FY 2017	FY 2016		FY 2017	FY 2016
$120,329.00	$79,924.00		$750,868.00	$557,712.00

Days’ sales in inventory = Inventory / COGS * Days in a year

2016 Days’ sales in inventory = 79924 / 557712 * 366 = 52 Days

2017 Days’ sales in inventory = 120329 / 750868 *365 = 58 Days

For Accounts receivable turnover ratio we requires Credit Sales, Account receivable at start at year & end ,means Average Accounts Receivable for the year

SALES		Accounts Receivable
FY 2017	FY 2016		FY 2017	FY 2016
			$295,068	$134,618,000	Beginning at the year
$1,551,324	$1,154,454		$389,719	$295,068	Ending At the Year
			$342,394	$67,456,534	Average for Year

Accounts receivable turnover ratio = Net Credit Sales / Average Accounts receivable for the Year

2016 Accounts receivable turnover ratio = 1154454 / 67456534 = 0.02

2017 Accounts receivable turnover ratio = 1551324 / 342394 = 4.53