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 ACCOUNT.(LL)-W/ACCESS>CUSTOM<
- In its segment information for 2021, how many reportable segments does Lulu Company have? A. 2 B. 3 C. 5 D. 6arrow_forwardThe 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_forward
- BOARD ACTIVITY Instructions: Horizontal Vertical Make a Horizontal Analysis and Vertical Analysis for 2014 2015 Analysis Analysis Revenue 1,939,500 1,674,675 1. the given SCI. Cost of Goods Sold 900,000 843,975 2. 8. Gross Profit 1,039,500 830,700 10. Selling and General Expenses 445,500 409,725 ur Other Expenses 37,575 30,825 giv 5. 11. Net Income 556,425 390,150 12.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_forwardRequired information Problem 13-2A (Algo) Ratios, common-size statements, and trend percents LO P1, P2, P3 (The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended December 31 2021 2020 2019 Sales $ 442,035 $ 338,635 212,324 126, 311 $ 235,000 Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes 266, 105 150,400 175,930 62,769 39,783 102,552 73,378 13,648 $ 59,730 84,600 31,020 46,732 29,800 76,532 49,779 19,505 50,525 34,075 Income tax expense 10, 205 6,917 Net income $ 39,574 $ 27,158 KORBIN COMPANY Comparative Balance Sheets December 31 2021 2020 2019 Assets Current assets $ 55,578 $ 37, 199 $ 49,726 Long-term investments Plant assets, net 900 4,570 56,095 104,820 $ 160,398 95,143 Total assets $ 133, 242 $ 110,391 Liabilities and Equity Current liabilities $ 19,853 $ 23,418 68,000 8,500…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_forwardUse the following data for Exercises E16-16, E16-17, and E16-18. Selected data for three companies are given below. All inventory amounts are ending balances and all amounts are in millions. Identifying differences between service, merchandising, and manufacturing companies Using the above data, determine the company type. Identify each company as a service company, merchandising company, or manufacturing company.arrow_forward
- The general merchandise retail industry has a number of segments represented by the following companies: Company Name Costco Wholesale Corporation Merchandise Concept 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: Wal-Mart Costco JCPenney $365,086 Cost of merchandise sold $101,065 $8,074 Merchandise inventory, beginning Merchandise inventory, ending 45,141 8,908 2,721 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 company's merchandise concept.arrow_forwardQUESTION 4 The following information was extracted from the accounting records of ABC Manufacturers for the year ended September 2020: UNITS Inventory at the beginning of the year Production for the year Sales for the year (at R75 per unit) Nil 20 000 18 250 Direct Materials cost per unit Direct Labour cost per unit Variable Manufacturing overheads per unit Variable selling and administrative cost per unit Fixed manufacturing overhead cost Fixed selling and administrative cost The company utilises the first-in-first-out method of inventory valuation. 21 7 8 182 000 77 000 REQUIRED: 4.1 Prepare the Income Statement using the Marginal Costing method. 4.2 Prepare the Income Statement using the Absorption Costing method.arrow_forwardDomesticarrow_forward
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher: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 Learning
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub