ADMS 1500 Lecture Notes - Lecture 4: Cash Flow Statement, Cash Flow, Net Income
Document Summary
Get access
Related Documents
Related Questions
Industry Average | |||||||||||||||
Financial Ratios | ã | 2015 | ã | 2016 | ã | 2017 | ã | ||||||||
Liquidity | ã | ã | ã | ||||||||||||
Accounts receivables turnover(times) | 8.08 | ã | 6.34 | ã | 5.11 | ã | 9.4 | ||||||||
Average Collection Period (days) | 45.17 | ã | 57.59 | ã | 71.46 | ã | 38.8 | ||||||||
Inventory turnover (times) | 7.81 | ã | 5.85 | ã | 4.54 | ã | 3.8 | ||||||||
Average days in inventory (days) | 46.73 | ã | 62.37 | ã | 80.35 | ã | 96.1 | ||||||||
Current ratio (times) | 2.04 | ã | 1.70 | ã | 1.53 | ã | 1.6 | ||||||||
Quick or Acid-test ratio (times) | 0.99 | ã | 0.80 | ã | 0.71 | ã | 0.8 | ||||||||
Solvency | ã | ã | ã | ||||||||||||
Debt to Equity Ratio | 94.7% | ã | 164.1% | ã | 229.8% | ã | 0.667 | ||||||||
Times interest earned (times) | 5.99 | ã | 4.26 | ã | 4.19 | ã | 3.4 | ||||||||
Profitability | ã | ã | ã | ||||||||||||
Gross profit ratio (%) | 29.7% | ã | 29.5% | ã | 29.8% | ã | 5.4% | ||||||||
Profit margin (%) [before tax] | 2.2% | ã | 2.5% | ã | 3.5% | ã | 4.4% | ||||||||
Asset Turnover | 2.26975906 | ã | 1.977221 | ã | 1.705226 | ã | 1.8 | ||||||||
Return on assets (%) [before tax] | 7.5% | ã | 7.5% | ã | 9.0% | ã | 8.0% | ||||||||
Return on equity (%) [before tax] | 14.7% | ã | 19.8% | ã | 29.6% | ã | 17.10% | ||||||||
Price to earnings ratio | $ 24.46 | ã | $18.62 | ã | $10.37 | ã | |||||||||
Cash Flow Statement | ã | ã | ã | 2016 | ã | ã | 2017 | ã | ã | ||||||
Cash, beginning of year | ã | $ 1,512.00 | ã | $ 1,176.00 | ã | ||||||||||
Operating Activities | |||||||||||||||
Net Income | ã | $ 1,627.00 | ã | $ 2,827.00 | ã | ||||||||||
Plus Depreciation | ã | $ 908.00 | ã | $ 1,292.00 | ã | ||||||||||
Minus increase in accounts receivable | ã | $ (4,034.00) | ã | $ (5,648.00) | ã | ||||||||||
Minus increase in inventory | ã | $ (3,302.00) | ã | $ (4,732.00) | ã | ||||||||||
Minus increase in prepaid expenses | ã | $ (1,360.00) | ã | $ (1,700.00) | ã | ||||||||||
Plus increase in accounts payable | ã | $ 2,388.00 | ã | $ 3,997.00 | ã | ||||||||||
Plus increase in income taxes payable | ã | $ 252.00 | ã | $ - | ã | ||||||||||
Plus increase in accruals & other cur.Liab. | ã | $ 1,365.00 | ã | $ 1,656.00 | ã | ||||||||||
Net Cash from operating activities | ã | $ (2,156.00) | ã | ã | $ (2,308.00) | ã | ã | ||||||||
Investment Activities | |||||||||||||||
Fixed asset acquisitions | ã | $ (2,780.00) | ã | $ (3,838.00) | ã | ||||||||||
Change in intangible assets | ã | $ (21.00) | ã | $ (17.00) | ã | ||||||||||
Change in all other noncurrent activities | ã | $ (467.00) | ã | $ (195.00) | ã | ||||||||||
Net Cash from investing activities | ã | $ (3,268.00) | ã | ã | $ (4,050.00) | ã | ã | ||||||||
Financing Activities | |||||||||||||||
Change in notes payable | ã | $ 2,038.00 | ã | $ 3,080.00 | ã | ||||||||||
Change current maturities--L.T.D. | ã | $ 452.00 | ã | $ 786.00 | ã | ||||||||||
Change in long-term debt | ã | $ 3,160.00 | ã | $ 3,250.00 | ã | ||||||||||
Change in Com Stock & paid-in cap | ã | $ - | ã | $ - | ã | ||||||||||
Dividends paid | ã | $ (562.00) | ã | $ (837.00) | ã | ||||||||||
Net Cash from financing Activities | ã | $ 5,088.00 | ã | $ 6,279.00 | ã | ||||||||||
Net Change in Cash | ã | $ (336.00) | ã | $ (79.00) | ã | ||||||||||
Cash, end of year | ã | $ 1,176.00 | ã | $ 1,097.00 | ã |
4. What is your assessment of the manner in which HTCM ismanaging its assets? Pay attention to both trends and industryaverages.
SOLVENCY (Financing of Assets)
5. What is your assessment of the manner in which HTCM isfinancing its assets? Pay attention to both trends and industryaverages. What is the relationship between the debt to equity ratioand times interest earned as these relate to HTCM? And is there anyother possible explanation (outside of the firmâs financialstatements) for the observed trend in times interest earned?
PROFITABILITY
6. What can you say about HTCMâs gross profit ratio and netprofit ratio? Explain any patterns observed.
7. How are HTCMâs net profit ratio, and asset turnover ratioaffecting the firmâs pre-tax return on assets (ROA) and return onequity (ROE)? What is your overall assessment of the firmâsprofitability, including its earnings per share (EPS)?
CASH FLOW
8. Referring to HTCMâs statement of cash flow for 2016 and 2017,assess HTCMâs cash flow situation noting both inflows andoutflows?
OVERALL EVALUATION
9. Based on your answers to the questions above, what is youroverall evaluation of HTCMâs financial condition? (Pull all youranalysis together in answering this question.)
10. What is the marketâs assessment of HTCMâs financialcondition? Explain. Does the marketâs assessment confirm or refuteyour analysis?
11. Based on your evaluation of HTCM and the marketâs assessmentof the firm, would you accept employment with the company?Explain.