a. (1)
Compute the
a. (1)
Explanation of Solution
Current ratio: Current ratio is one of the
Compute current ratio for Company K and Incorporation WF.
Ratios and Formula | Company K | Incorporation WF |
(1) Current ratio: |
Table (1)
a. (2)
Compute the average days to sell inventory ratio for Company K and Incorporation WF for the fiscal year 2014.
a. (2)
Explanation of Solution
Average days to sell inventory: This ratio is determined as the number of days a particular company takes to make sales of the inventory available with them. It is calculated by using the formula:
Compute average days to sell inventory for Company K and Incorporation WF:
Ratios and Formula | Company K | Incorporation WF |
Average days to sell inventory: |
Table (2)
Working Note:
Determine the average inventory for both the companies.
Ratios and Formula | Company K | Incorporation WF |
Inventory turnover: Average inventory: |
|
|
Table (3)
a. (3)
Compute the debt to assets ratio for Company K and Incorporation WF for the fiscal year 2014.
a. (3)
Explanation of Solution
Debt to assets ratio: The debt to asset ratio shows the relationship between total asset and the total liability of the company. Debt ratio reflects the financial strategy of the company. It is used to measure the percentage of company’s assets that are financed by long term debts. Debt to assets ratio is calculated by using the formula:
Compute debt to assets ratio for Company K and Incorporation WF:
Ratios and Formula | Company K | Incorporation WF |
Debt to assets ratio: |
Table (4)
a. (4)
Compute the
a. (4)
Explanation of Solution
Return on investment (assets): Return on investments (assets) is the financial ratio which determines the amount of net income earned by the business with the use of total assets owned by it. It indicates the magnitude of the company’s earnings with relative to its total assets. Return on investment is calculated as follows:
Compute return on investment for Company K and Incorporation WF:
Ratios and Formula | Company K | Incorporation WF |
Return on investment: |
Table (4)
Working note:
Determine the average total assets for both the companies.
Ratios and Formula | Company K | Incorporation WF |
Average total assets: |
Table (5)
a. (5)
Compute the gross margin percentage for Company K and Incorporation WF for the fiscal year 2014.
a. (5)
Explanation of Solution
Gross margin percentage: It is one of the profitability ratios. Gross margin ratio is used to measure the percentage of gross profit that is being generated per dollar of revenue or sales. It is calculated by using the formula:
Compute gross margin percentage for Company K and Incorporation WF:
Ratios and Formula | Company K | Incorporation WF |
Gross margin percentage: |
Table (6)
a. (6)
Compute the asset turnover for Company K and Incorporation WF for the fiscal year 2014.
a. (6)
Explanation of Solution
Asset turnover: Turnover of assets is a ratio that measures the productive capacity of the total assets to generate the sales revenue for the company. Thus, it shows the relationship between the net sales and the average total assets. Turnover of assets is calculated as follows:
Compute asset turnover for Company K and Incorporation WF:
Ratios and Formula | Company K | Incorporation WF |
Asset turnover: |
|
Table (7)
Working note:
Determine the average total assets for both the companies.
Ratios and Formula | Company K | Incorporation WF |
Average total assets: |
Table (8)
a. (7)
Compute the net margin for Company K and Incorporation WF for the fiscal year 2014.
a. (7)
Explanation of Solution
Net margin: It is one of the profitability ratios. Net margin ratio is used to measure the percentage of net income that is being generated per dollar of revenue or sales. It is calculated by using the formula:
Compute net margin for Company K and Incorporation WF:
Ratios and Formula | Company K | Incorporation WF |
Net margin: |
Table (9)
a. (7)
Compute plant to long term debt ratio for Company K and Incorporation WF for the fiscal year 2014.
a. (7)
Explanation of Solution
Plant assets to long term debt: Plant assets to long term debt ratio measure the value of assets per each dollar of long term liabilities. It is calculated by using the formula:
Compute plant to long term debt ratio for Company K and Incorporation WF:
Ratios and Formula | Company K | Incorporation WF |
Plant assets to long-term debt: |
Table (10)
b.
Identify the company that appears to be more profitable. Identify the ratio that reveals the profitability using requirement a. and justify the conclusion.
b.
Explanation of Solution
The ratios that are most relevant for determining profitability are as follows:
- 1) Return on investment: Return on investments (assets) is the financial ratio which determines the amount of net income earned by the business with the use of total assets owned by it. It indicates the magnitude of the company’s earnings with relative to its total assets.
- 2) Net margin: It is one of the profitability ratios. Profit margin ratio is used to measure the percentage of net income that is being generated per dollar of revenue or sales.
As per Table (1), the return on investment and net margin of Incorporation WF is 16.8% and 6.67% respectively, which is substantially higher than the profitability ratios of Company K.
c.
Identify the company that has higher level of financial risk. Identify the ratio that reveals the financial risk using requirement a. and justify the conclusion.
c.
Explanation of Solution
The ratios that are most relevant for determining profitability are as follows:
- 1) Current ratio: Current ratio is one of the liquidity ratios, which measures the capacity of the company to meet its short-term obligations using its current assets.
- 2) Debt to assets ratio: The debt to asset ratio shows the relationship between total asset and the total liability of the company. Debt ratio reflects the financial strategy of the company. It is used to measure the percentage of company’s assets that are financed by long term debts.
- 3) Plant assets to long term debt: Plant assets to long term debt ratio measure the value of assets per each dollar of long term liabilities.
As per Table (1), the current ratio, Debt to assets ratio and plant assets to long term debt of Incorporation WF is 1.40:1, 33.6% and 4.3:1 respectively, which indicates that Incorporation WF is having higher level of financial risk .
d.
Identify the company that charges higher prices for the goods. Identify the ratio that reveals the information using requirement a. and justify the conclusion.
d.
Explanation of Solution
The ratios that are most relevant for determining the cost of goods of both the companies is the gross margin percentage. The gross margin ratio is used to measure the percentage of gross profit that is being generated per dollar of revenue or sales. The gross margin of Incorporation WF is 35.5% which is significantly higher than Company K. The higher gross margin indicates that Incorporation WF is charging the most of its goods with respect to what it pays for the items it sells.
e.
Identify the company that is efficiently using its assets. Identify the ratio that reveals the profitability using requirement a. and justify the conclusion.
e.
Explanation of Solution
The ratios that are most relevant for determining the efficient utilization of assets are as follows:
- 1) Average days to sell inventory: This ratio is determined as the number of days a particular company takes to make sales of the inventory available with them.
- 2) Asset turnover: Turnover of assets is a ratio that measures the productive capacity of the total assets to generate the sales revenue for the company. Thus, it shows the relationship between the net sales and the average total assets
As per Table (1), the average days to sell inventory of Incorporation WF is 17 days which indicates that Incorporation WF is utilizing the inventory efficiently than Company K. However, the asset turnover of Company K is 3.62 times, whereas of Incorporation WF the asset turnover ratio is 2.5 times, that indicates the efficiency of Company K to earn higher turnover using its total assets.
Want to see more full solutions like this?
Chapter 9 Solutions
Survey Of Accounting
- The following revenue data were taken from the December 31, 2017, General Electric annual report (10-K): For each segment and each year, calculate intersegment sales (another name for transfer sales) as a percentage of total sales. Using Microsoft Excel or another spreadsheet application, create a clustered column graph to show the 2016 and 2017 percentages for each division. Comment on your observations of this data. How might a division sales manager use this data?arrow_forwardDivisional income statements The following data were summarized from the accounting records for Vintage Construction Company for the year ended October 31, 20Y3. Prepare divisional income statements for Vintage Construction Company.arrow_forwardThe following revenue data were taken from the December 31, 2017, Coca-Cola annual report (10-K): For each segment and each year, calculate intersegment sales (another name for transfer sales) as a percentage of total sales, Using Microsoft Excel or another spreadsheet application, create a clustered column graph to show the 2016 and 2017 percentages for each division. Comment on your observations of this data. How might a division sales manager use this data?arrow_forward
- Comparative Analysis: Under Armour, Inc., vs. Columbia Sportswear Refer to the 10-K reports of Under Armour, Inc., and Columbia Sportswear that are available for download from the companion website at CengageBrain.com. Required: Do Under Armour and Columbia use the lower of cost or market method to account for their inventories? By what amount have they written inventories down in the fiscal year ending December 2016?arrow_forwardSales transactions Using transactions listed in P4-2, indicate the effects of each transaction on the liquidity metric working capital and profitability metric gross profit percent. Indicate the gross profit percent for each sale (rounding to one decimal place) in parentheses next to the effect of the sale on the company’s ability to attain an overall gross profit percent of 30%.arrow_forwardDomesticarrow_forward
- Chapter 13, Question 3arrow_forward#becausesneaker.... HW CH 17 Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous Year Sales Cost of merchandise sold Selling expenses Administrative expenses Income tax expense Custom Order Sales Cost of merchandise sold Selling expenses a. Prepare an income statement in comparative form, statin each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive numbers. Administrative expenses Income tax expense $483,000 280,140 82,110 86,940 14,490 Innovation Quarter Inc. Comparative Income Statement For the Years Ended December 31 Current year Amount $483,000 280,140 82,110 86,940 14,490 percentage points, and administrative expenses net income as a percent of sales Current year Percent % % % % % % $420,000 218,400 79,800 71,400 21,000 % % % Previous year Amount $420,000 218,400 79,800 71,400 21,000 Previous year Percent b.…arrow_forwardInferring Transactions from Financial StatementsCostco Wholesale Corporation operates membership warehouses selling food, appliances, consumer electronics, apparel and other household goods at 721locations across the U.S. as well as in Canada, the United Kingdom, Japan, Australia, South Korea, Taiwan, Mexico and Puerto Rico. As of its fiscal year-end 2016, Costco had approximately 86.7 million members. Selected fiscal-year information from the company's balance sheets follows. Selected Balance Sheet Data ($ millions) 2016 2015 Merchandise inventories $8,969 $8,908 Deferred membership income (liability) 1,362 1,269 (a) During fiscal 2016, Costco collected $2,739 million cash for membership fees. Use the financial statement effects template to record the cash collected for membership fees.(b) Costco recorded merchandise costs (that is, cost of goods sold) of $102,901 million in 2016. Record this transaction in the financial statement effects template.(c) Determine the…arrow_forward
- Comparing inventory ratios for three companies The general merchandise retail industry has a number of segments represented by the following companies: Company Name Merchandise Concept Costco Wholesale Corporation Membership warehouse Wal-Mart Discount general merchandise JCPenney Company Department store For a recent year, the following cost of merchandise sold and beginning and ending inventories have been provided from corporate annual reports (in millions) for these three companies: Costco Wal-Mart JCPenny Cost of merchandise sold 101,065 365,086 8,074 Merchandise inventory, beginning 8,908 45,141 2,721 Merchandise inventory, ending 8,456 44,858 2,652 a. Determine the inventory turnover ratio for all three companies. Round to two decimal places. b. Determine the days sales in inventory for all three companies. Use 365 days and round to one decimal place. c. Interpret these results based on each companys merchandise conceptarrow_forwardInventory Analysis The following account balances are taken from the records of Lewis Inc., a wholesaler of fresh fruits and vegetables: Required Compute Lewiss inventory turnover ratio for 2016 and 2015. Compute the number of days sales in inventory for 2016 and 2015. Assume 360 days in a year. Comment on your answers in parts (1) and (2) relative to the companys management of inventory over the two years. What problems do you see in its inventory management?arrow_forwardINCOME STATEMENT WITH DEPART MENTAL GROSS PROFIT AND OPERATING INCOME Bacon and Hand Distributors has divided its business into two departments: retail sales and wholesale sales. The following information is provided for the year ended December 31, 20--: REQUIRED 1. Prepare an income statement showing departmental gross profit and total operating income. 2. Calculate departmental gross profit percentages.arrow_forward
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningAccounting (Text Only)AccountingISBN:9781285743615Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning