(a)
Financial Ratios: Financial ratios are the metrics used to evaluate the liquidity, capabilities, profitability, and overall performance of a company.
To compute: Financial ratios for T and W company.
(a)
Explanation of Solution
Given info: Income statement and Balance sheet
1.
T Company
W Company
Explanation:
Current ratio is used to determine the relationship between current assets and current liabilities. The ideal current ratio is 2:1.
Formula:
Hence, current ratio for T Company and W Company are 1.63:1 and 0.87:1 respectively.
2.
T Company
W Company
Explanation:
Accounts receivable turnover ratio is mainly used to evaluate the collection process efficiency. It helps the company to know the number of times the accounts receivable is collected in a particular time period. Main purpose of accounts receivable turnover ratio is to manage the
Formula:
Hence, accounts receivables turnover ratio for T Company and W Company are 8.7 times and 101.4 times respectively.
3.
Average collection period for T Company and W Company
T Company
W company
Explanation:
Average collection period is used to determine the number of days a particular company takes to collect accounts receivables.
Formula:
Hence, average collection period for T Company and W Company are 42.0 days and 3.6 days respectively.
4.
Inventory turnover ratio for T Company and W Company
T Company
W Company
Explanation:
Inventory turnover ratio is used to determine the number of times inventory used or sold during the particular accounting period.
Formula:
Hence, inventory turnover ratio for T Company and W Company are 6.6 times and 9 times respectively.
5.
Days in inventory ratio for T Company and W Company
T Company
W Company
Explanation:
Days’ sales in inventory are used to determine number of days a particular company takes to make sales of the inventory available with them.
Formula:
Hence, days’ sales in inventory for T Company and W Company are 55.55 days and 40.55 days respectively.
6.
Profit margin ratio for T Company and W Company
T Company
W Company
Explanation:
Profit margin ratio is used to determine the percentage of net income that is being generated per dollar of revenue or sales.
Formula:
Hence, profit margin ratio for T Company and W Company is 3.8% and 3.5% respectively.
7.
Asset turnover ratio for T Company and W company
T Company
W Company
Explanation:
Asset turnover ratio is used to determine the asset’s efficiency towards sales.
Formula:
Average total assets are determined as follows:
Average total assets for T Company
Average total assets for W Company
Hence, asset turnover ratio for T Company and W Company is 1.5 times and 2.4 times respectively.
8.
Return on assets ratio for T Company and W Company
T Company
W Company
Explanation
Return on assets determines the particular company’s overall earning power.
Formula:
Average total assets are calculated above.
Hence, return on assets for T Company and W Company are 5.6% and 8.6% respectively.
9.
Return on
T Company
W Company
Explanation:
Formula:
Hence, return on stockholders’ equity for T Company and W Company are 17.1% and 21.0% respectively.
10.
Debt to assets ratio for T company and W Company
T Company
W Company
Explanation:
Debt to asset ratio is used to determine the relationship between total liabilities and total assets. This ratio help the company in determining the debt used for asset financing. When the determined ratio is more than 50%, company faces higher risk.
Formula:
Hence, debt to assets ratio for T Company and W Company are 66% and 58% respectively.
11.
Times interest earned ratio for T Company and W Company
T Company
W Company
Explanation:
Times interest earned ratio quantifies the number of times the earnings before interest and taxes can pay the interest expense. Use the following formula to calculate times-interest-earned ratio:
Hence, times interest earned ratio for T Company and W Company are 6.5 times and 11.4 times respectively.
12.
T Company
W Company
Explanation:
Free cash flow determines to know the extent of how company survives in a longer time period. Free cash flow is determined by deducting net cash provided by operating activities and capital expenditures and cash dividends.
Formula:
Hence, free cash flow for T Company and W Company are $3,656 and $9,848 respectively.
(b)
To compare: The liquidity, solvency, and profitability ratios of the two companies.
(b)
Explanation of Solution
Given info: Income statement and Balance sheet
Comment on the
When current ratio is compared, T Company has better current ratio than the W Company. When accounts receivable turnover ratio and average collection period are compared, W Company’s ratios are better than the T Company. When inventory turnover ratio and days in inventory ratio are compared, W Company’s ratios are better than the T Company. Therefore, on the whole, W Company is better in liquidity.
Comment on the profitability ratios
When profit margin ratios of both the companies are compared, T Company has better ratio than the W Company. When asset turnover ratio of both the companies is compared, W Company has better ratio than the T Company. When returns on assets ratio of both the companies are compared, W Company has better ratio than the T Company. When returns on common stockholders’ equity ratio of both the companies are compared, T Company has better ratio than the W Company.
Comment on the solvency ratios.
When debt to assets ratio of both the companies is compared, W Company has better debt to assets ratio than the T Company. When the times interest earned ratio of both the companies are compared, W Company has better ratio than the T Company. When times free cash flow of both the companies are compared, W Company has better ratio than the T Company. Therefore, on the whole, T Company is better in solvency.
Want to see more full solutions like this?
Chapter 13 Solutions
FINANCIAL ACCT.:TOOLS...(LL)-W/ACCESS
- Financial statement analysis The financial statements for Nike, Inc., are presented in Appendix D at the end of the text. Use the following additional information (in thousands): Instructions 1. Determine the following measures for the fiscal years ended May 31, 2016, and May 31, 2015. Round ratios and percentages to one decimal place. a. Working capital b. Current ratio c. Quick ratio d. Accounts receivable turnover e. Number of days sales in receivables f. Inventory turnover g. Number of days sales in inventory h. Ratio of liabilities to stockholders equity i. Asset turnover j. Return on total assets. k. Return on common stockholders equity l. Price-earnings ratio, assuming that the market price was 54.90 per share on May 29, 2016, and 52.81 per share on May 30, 2015 m. Percentage relationship of net income to sales 2. What conclusions can be drawn from these analyses?arrow_forwardReal-world annual report The financial statements for Nike, Inc. (NKE), are presented in Appendix E at the end of the text. The following additional information is available (in thousands): Instructions 1. Determine the following measures for the fiscal years ended May 31, 2017, and May 31, 2016. Round ratios and percentages to one decimal place. a. Working capital b. Current ratio c. Quick ratio d. Accounts receivable turnover e. Number of days sales in receivables f. Inventory turnover g. Number of days sales in inventory' h. Ratio of liabilities to stockholders equity i. Asset turnover j. Return on total assets, assuming interest expense is 82 million for the year ending May 31. 2017, and 33 million for the year ending May 31, 2016. k. k. Return on common stockholders equity l. Price-eamings ratio, assuming that the market price was 52.81 per share on May 31, 2017, and 54.35 per share on May 31, 2016. m. m. Percentage relationship of net income to sales 2. What conclusions can be drawn from these analyses?arrow_forwardFinancial Statement Analysis The financial statements for Nike, Inc., are presented in Appendix C at the end of the text. The following additional information (in thousands) is available: Instructions 1. Determine the following measures for the fiscal years ended May 31, 2013 (fiscal 2012), and May 31, 2012 (fiscal 2011), rounding to one decimal place. a. Working capital b. Current ratio c. Quick ratio d. Accounts receivable turnover e. Number of days sales in receivables f. Inventory turnover g. Number of days sales in inventory h. Ratio of liabilities to stockholders equity i. Ratio of sales to assets j. Rate earned on total assets, assuming interest expense is 23 million for the year ending May 31, 2013, and 31 million for the year ending May 31, 2012 k. Rate earned on common stockholders equity l. Price-earnings ratio, assuming that the market price was 61.66 per share on May 31, 2013, and 53.10 per share on May 31, 2012 m. Percentage relationship of net income to sales 2. What conclusions can be drawn from these analyses?arrow_forward
- Financial statement data for years ending December 31 for Latchkey Company follows: a. Determine the ratio of sales to assets for 2016 and 2015. b. Does the change in the ratio of sales to assets from 2015 to 2016 indicate a favorable or an unfavorable trend?arrow_forwardThe following selected information is taken from the financial statements of Arnn Company for its most recent year of operations: During the year, Arnn had net sales of 2.45 million. The cost of goods sold was 1.3 million. Required: Note: Round all answers to two decimal places. 1. Compute the current ratio. 2. Compute the quick or acid-test ratio. 3. Compute the accounts receivable turnover ratio. 4. Compute the accounts receivable turnover in days. 5. Compute the inventory turnover ratio. 6. Compute the inventory turnover in days.arrow_forwardMeasures of liquidity, solvency, and profitability The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common stock was 82.60 on December 31, 20Y2. Instructions Determine the following measures for 20Y2, rounding to one decimal place, including percentages, except for per-share amounts: 1. Working capital 2. Current ratio 3. Quick ratio 4. Accounts receivable turnover 5. Number of days sales in receivables 6. Inventory turnover 7. Number of days sales in inventory 8. Ratio of fixed assets to long-term liabilities 9. Ratio of liabilities to stockholders equity 10. Times interest earned 11. Asset turnover 12. Return on total assets 13. Return on stockholders equity 14. Return on common stockholders equity 15. Earnings per share on common stock 16. Price-earnings ratio 17. Dividends per share of common stock 18. Dividend yieldarrow_forward
- Using the following select financial statement information from Black Water Industries, compute the accounts receivable turnover ratios for 2018 and 2019 (round answers to two decimal places). What do the outcomes tell a potential investor about Black Water Industries?arrow_forwardMeasures of liquidity, solvency, and profitability The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common stock was 82.60 on December 31, 20Y2. Instructions Determine the following measures for 20Y2 (round to one decimal place, including percentages, except for per-share amounts): 1. Working capital 2. Current ratio 3. Quick ratio 4. Accounts receivable turnover 5. Number of days sales in receivables 6. Inventory turnover 7. Number of days sales in inventory 8. Ratio of fixed assets to long-term liabilities 9. Ratio of liabilities to stockholders equity 10. Times interest earned 11. Asset turnover 12. Return on total assets 13. Return on stockholders equity 14. Return on common stockholders equity 15. Earnings per share on common stock 16. Price-earnings ratio 17. Dividends per share of common stock 18. Dividend yieldarrow_forwardJuroe Company provided the following income statement for last year: Juroes balance sheet as of December 31 last year showed total liabilities of 10,250,000, total equity of 6,150,000, and total assets of 16,400,000. Required: 1. Calculate the return on sales. (Note: Round the percent to two decimal places.) 2. CONCEPTUAL CONNECTION Briefly explain the meaning of the return on sales ratio, and comment on whether Juroes return on sales ratio appears appropriate.arrow_forward
- Using the following select financial statement information from Mover Supply Depot, compute the accounts receivable turnover ratios for 2018 and 2019 (round answers to two decimal places). What do the outcomes tell a potential investor about Mover Supply Depot if the industry average is 4 times?arrow_forwardLast year, Nikkola Company had net sales of 2,299,500,000 and cost of goods sold of 1,755,000,000. Nikkola had the following balances: Refer to the information for Nikkola Company above. Required: Note: Round answers to one decimal place. 1. Calculate the average inventory. 2. Calculate the inventory turnover ratio. 3. Calculate the inventory turnover in days. 4. CONCEPTUAL CONNECTION Based on these ratios, does Nikkola appear to be performing well or poorly?arrow_forwardJuroe Company provided the following income statement for last year: Juroes balance sheet as of December 31 last year showed total liabilities of 10,250,000, total equity of 6,150,000, and total assets of 16,400,000. Required: Note: Round answers to two decimal places. 1. Calculate the times-interest-earned ratio. 2. Calculate the debt ratio. 3. Calculate the debt-to-equity ratio.arrow_forward
- Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeFinancial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning