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
- 14 - ABC Co. is a manufacturing company and its selected financial statements items are given as following. Net Sales equals to 32000 for the year 2020 and 28000 for the year 2019. COGS equals to 24000 and 21000 respectively for the year 2020 and 2019. Accounts Receivable for the year 2020 equals to 8500 and 7800 for the year 2019. Inventory equals to 7500 and 6800 respectively for the year 2020 and 2019. Accounts Payable for the year 2020 equals to 11000 and 9000 for the year 2019. (All numbers are in dollars). What is days sales inventory for the year 2020? a) O 89 b) O 109 c) O 99 d) O 119arrow_forwardExplain comprehensively what happened with Dana Dairy Between 2016 and 2017 Explain Dana position comprehensively compared to the industryarrow_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_forwardShanika Company Income Statement For the Year Ended December 31, 20Y6 Cost of good sold: Operating expenses: Administrative expenses: Selling expenses: Total operating expensesarrow_forward
- Stage 2 ABC for a Wholesale CompanyInformation is presented for the activity costs of Brighton Wholesale Company: Activity Cost per Unit of Activity Driver Customer relations $82.00 per customer per month Selling 0.09 per sales dollar Accounting 7.00 per order Warehousing 0.60 per unit shipped Packing 0.35 per unit shipped Shipping 0.40 per pound shipped The following information pertains to Brighton Wholesale Company's activities in Colorado for the month of June 2017: Number of orders 320 Sales revenue $218,000 Cost of goods sold $98,100 Number of customers 40 Units shipped 5,400 Pounds shipped 81,000 RequiredDetermine the profitability of sales in Colorado for June 2017.Do not use a negative sign with your answers. Profitability of Sales in Colorado March 2017 Sales revenue Answer Less: Cost of goods sold Answer Customer relations Answer Selling expenses Answer Accounting Answer Warehousing Answer…arrow_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
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning