| 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...
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...
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.)
.. . ......
The comparative statements of Sheridan Company are presented here. SHERIDAN COMPANY Income Statements For the Years Ended December 31 2017 2016 Net sales $1,899,640 $1,759,600 Cost of goods sold 1,067,640 1,015,100 Gross profit 832,000 744,500 Selling and administrative expenses 509,100 488,100 Income from operations 322,900 256,400 Other expenses and losses Interest expense 24,100 22,100 Income before income taxes 298,800 234,300 Income tax expense 94,100 75,100 Net income $ 204,700 $ 159,200 SHERIDAN COMPANY Balance Sheets December 31 Assets 2017 2016...