2016 | 2015 | ||
Accounts Receivable turnover | Net Credit Sales/ Average Accounts Receivable | 12.46 | 11.29 |
Average Collection Period | (Average Accounts receivable/Net Credit Sales) * 365 | 29.3 | 0.3 |
Inventory turnover | Cost of goods sold/average inventory | 23.63 | 23.85 |
Days to Sell inventory | Ending Inventory/Cost of Goods Sold *365 | 16.1 | 15.3 |
Accounts Payable turnover | Total Credit Purchases/ Average Accounts Payable | 2.35 | 2.33 |
Accounts Payable Payment Period | Trade Payable/Credit Purchases * 365 | 153.3 | 156.4 |
Current ratio | Current Asset/ Current Liability | 0.45 | 0.44 |
Quick ratio | Quick Asset/ Current Liability | 0.40 | 0.39 |
Debt/equity ratio | Total Liabilities/Total Equity | 1.30 | 1.21 |
Interest Coverage ratio |
Income before Interest&Tax / Interest Expense |
6.8 | 8.6 |
Based on Debt to equity and interest coverage ratio the financial risk on the company has increased in 2016 |
Because Debt to equity ratio increased and interest coverage ratio decreased |
||
Profit Margin | Net Income/ Net Sales *100 | 42.8% | 71.9% |
Return on Equity | Net
Income/ Average Shareholders’ Equity *100 |
10.3% | 17.5% |
Return on Assets | Net Income/ Average Total Assets*100 | 4.5% | 7.9% |
Net Free Cash flow | (net cash provided by operating activities) | 166014 | 230594 |
(See Cash flow statement) | |||
Net free cash flow has decreased in 2016 |
2016 | 2015 | |
Net (Credit) Sales (total revenue) | 1478326 | 13,70,943 |
Average Accounts Receivable (opening+closing)/2 | 118650.5 | 1,21,398 |
Cost of goods sold (film cost+cost of food service)) | 485661 | 469633 |
Ending Inventory | 21412 | 19,691 |
Average inventory (opening+closing)/2 | 20551.5 | 19,691 |
Total Credit Purchases (see below) | 487382 | 489324 |
Trade Payable | 204725 | $ 2,09,657 |
Average Accounts Payable (opening+closing)/2 | 207191 | $ 2,09,657 |
Current Asset | 182187 | 186827 |
Current Liability | 402039 | 425777 |
Quick Asset (current asset-inventories) | 160775 | 1,67,136 |
Total Liabilities | 976291 | 9,29,420 |
Total Shareholders’ Equity | 7,49,095 | 7,67,473 |
Income
before Interest&Tax (109318+18816), (171168+22443) |
128134 | 193611 |
Interest Expense | 18816 | 22443 |
Net Income | 77991 | 1,34,249 |
Average Total Assets (opening+closing)/2 | 1715051.5 | $ 17,01,917 |
Average Shareholders’ Equity (opening+closing)/2 | 758284 | 7,67,473 |
Total (Credit) Purchases | ||
Opening Inventory | -19691 | (since not provided) |
Cost of goods sold during the year | 485661 | 469633 |
Closing inventory | 21412 | 19,691 |
Total (Credit) Purchases | 487382 | 489324 |
Hope you understood. Thank you.
Reading and Interpreting 12-4 a1, bi, ci, d Cineplex Inc. is the largest movie exhibition company...
Reading and Interpreting 5-1 a-f, g1 Exhibits 5.19A and 5.19B contain the consolidated statements of cash flows and related note disclosure for The Second Cup Ltd. EXHIBIT 5.19A The Second Cup Ltd.'s 2016 Statements of Cash Flows STATEMENTS OF CASH FLOWS For the periods ended December 31, 2016 and December 26, 2015 (Expressed in thousands of Canadian dollars) 2016 2015 CASH PROVIDED BY (USED IN) Operating activities $ (975) (1,153) Net loss for the period Items not involving cash Depreciation...
Use the NIKE's financial statements, Appendix D in the text book to answer the following questions. The ending balance of inventory 2014 was $4,025: a. Calculate the inventory turnover for 2016 and 2015. Round to 2 decimal places. b. Calculate the days' sales in inventory for 2016 and 2015 using 365 days. c. Is the change in the inventory turnover and the days' sales in inventory form 2015 to 2016 favorable or unfavorable? D-4 Appendix D Selected Excerpts from Nike...
Financial Statement Analysis The financial statements for Nike, Inc., are presented in Appendix D. Use the following additional information (in thousands): Accounts receivable at May 31, 2014: $3,117 Inventories at May 31, 2014: 3,947 Total assets at May 31, 2014: 18,594 Stockholders' equity at May 31, 2014: 12,000 1. Determine the following measures for the fiscal years ended May 31, 2016, and May 31, 2015. Do not round interim calculations. Round the working capital amount in part (a) to the...
Ratios 2016 2015 a. Gross profit margin (%) 39.4 39.1 b. Operating profit margin (%) 5.1 7.5 c. Net profit margin (%) 2.4 4.0 d. Return on shareholders' equity (%) 14.1 25.2 e. Return on assets (%) 3.1 5.2 f. Times interest earned coverage 3.6 5.6 g. Long-term debt-to-equity ratio 1.5 3.8 h. Days of inventory 126.2 121.8 i. Inventory turnover ratio 2.9 3.0 j. Average collection period 7.4 7.5 1-From 2015 to 2016, Macy’s, Inc., return on equity and...
D. Ford Motor Company CONSOLIDATED BALANCE SHEET- USD (SI S in Millions Dec. 31, 2017 Dec. 31, 2016 ASSETS Cash and cash equivalents Short term Marketable securities (Note 9) Accounts receivables, (less allowances of $392 for 2017 and $412 for $ 18,492 $ 15,905 Calculate Gross Recievables 20,435 22.922 171,201 153,558 2016) Inventories (Note 12) Other assets Total current assets olFinancial Services finance receivables, net (Note 10) Net investment in operating leases 2Net property (Note 14) BEquity in net assets...
included in Appetit LO13-1, LO13-2, LO13-4 EXERCISE 13.15 Home Depot, Inc. Using a Statement of Cash Flows Statements of cash flow for Home Depot, Inc., for 2013, 2014, and 2013 are include of this text. a. Focus on the information for 2015 (year ending January 31, 2010). How does compare with net cash provided by or used in operations, and what accounts for the difference between the two amounts? does not eating unts for the per the major uses of...
Expand Your Critical Thinking 12-03 a Amazon.com, Inc.’s financial statements are presented in Appendix D. Click here to view Appendix D. Financial statements of Wal-Mart Stores, Inc. are presented in Appendix E. Click here to view Appendix E. (a) Based on the information contained in these financial statements, compute free cash flow for Amazon at December 31, 2016 and Wal-Mart for January 31, 2017. (Show a negative free cash flow with either a - sign e.g. -15,000 or in parenthesis...
Expand Your Critical Thinking 12-02 a Columbia Sportswear Company’s financial statements are presented in Appendix B. Click here to view Appendix B. Financial statements of VF Corporation are presented in Appendix C. Click here to view Appendix C. (a) Based on the information contained in these financial statements, compute free cash flow for each company. (Show a negative free cash flow with either a - sign e.g. -15,000 or in parenthesis e.g. (15,000). Enter amounts in thousands.) .. . ......
ASSURANCE OF LEARNING EXERCISES 1. conn LO4-1 Using the financial ratios provided in the Appendix and the following financial statement information for Macy's, Inc., calculate the following ratios for Macy's for both 2015 and 2016. 1. Gross profit margin 2. Operating profit margin 3. Net profit margin 4. Times interest earned coverage 5. Return on shareholders' equity 6. Return on assets 7. Long-term debt-to-equity ratio 8. Days of inventory 9. Inventory turnover ratio 10. Average collection period Based on these...
I spoke with the teacher - they said the "see notes" isnt needed Columbia Sportswear Company is a leader in outdoor sportswear. The following are Columbia's financial statements as presented in its 2016 annual report. The complete annual report, including notes to the financial statements, is available at the company's website. COLUMBIA SPORTSWEAR COMPANY CONSOLIDATED STATEMENTS OF OPERATIONS (In thousands, except per share amounts) Year Ended December 31, 2016 2015 2014 Net sales .................. $ 2,377,045 $ 2,326,180 $ 2.100,590...