Can you please help me calculate the "Days to Sell Inventory" and "Average Collection Period" of this company?
Also, please use ending balances for receivables and inventory balances instead of average balances.
Thank you.
BIG ROCK BREWERY INC. Consolidated Statements of Comprehensive Income (In thousands of Canadian dollars, except per share amounts) Year ended December 30 Note 2018 2017 Revenue Net revenue S 48,748 S 46,573 Cost of sales 27,936 27,676 Gross profit 20,812 18,897 Expenses Selling expenses 13,562 14,290 General and administrative 5,795 5,174 Depreciation and amortization 524 470 Operating expenses 19,881 19,934 Operating income (loss) 931 (1,037) Finance expenses 8 327 333 Other 18 2 Income (loss) before income taxes 622 (1,368) Income tax expense (recovery) 9 Current (71) (175) Deferred 333 (173) 262 (348) Net income (loss) and comprehensive income (loss) $ 360 (1,020) Per share amounts Basic and diluted 10 S 0.05 S (0.15) See accompanying notes to the consolidated financial statementsBIG ROCK BREWERY INC. Consolidated Statements of Changes in Shareholders' Equity (In thousands of Canadian dollars) Shareholders' Contributed Accumulated Note capital surplus deficit Total Balance as at December 30, 2016 21 $ 113, 121 $ 1,438 $ (76, 179) $ 38,380 Share-based payments 50 50 Stock options exercised 22 724 (141) 583 Total comprehensive loss (1,020) (1,020) Balance as at December 30, 2017 113,845 1,347 (77, 199) 37,993 Share-based payments 22 231 231 Total comprehensive income 360 360 Balance as at December 30, 2018 $ 113,845 $ 1,578 $ (76,839) $38,584 See accompanying notes to the consolidated financial statementsBIG ROCK BREWERY INC. Consolidated Statements of Financial Position (In thousands of Canadian dollars) As at December 30 Note 2018 2017 ASSETS Current Cash S 1,902 S 168 Accounts receivable 3,384 3,164 Inventories 5,404 4,986 Prepaid expenses and deposits 488 369 11,178 8,687 Non-current Property, plant and equipment 13 43,166 44,228 Intangible assets 14 & 29 2,396 566 45,562 44,794 Total assets $ 56,740 $ 53,481 LIABILITIES AND SHAREHOLDERS' EQUITY Current Bank indebtedness 16 S 163 S 84 Accounts payable and accrued liabilities 4.682 3,473 Current taxes payable 449 252 Long term debt - current 409 417 License obligation - current 17 & 29 138 Finance lease . current 347 329 Share-based payments 22 433 599 6,621 5,154 Non-current Long term debt 16 3,356 3,738 License obligation 17 6 29 1,582 Finance lease 18 1,500 1,848 Lease incentive liability 19 260 228 Share-based payments 22 45 61 Deferred income taxes 4,792 4,459 11,535 10,334 EQUITY Shareholders' capital 20 113,845 113,845 Contributed surplus 1,578 1,347 Accumulated deficit 21 (76,839) (77,199) 38,584 37,993 Total liabilities and shareholders' equity $ 56,740 53,481 Commitments and contractual obligations 27 See accompanying notes to the consolidated financial statements On behalf of the Board of Directors: Stephen Giblin Michael Kohut Director Director
