(a)
Financial ratios: Financial ratios are the metrics used to evaluate the liquidity, capabilities, profitability, and overall performance of a company.
Solvency ratio: Next, solvency ratios are those ratios used to measure the ability of the company towards survival for a longer period.
Profitability ratio: Profitability ratios are those ratios used to measure the extent of income for particular time period.
To compute: Liquidity ratios for C Company and P Company
(a)
Explanation of Solution
Given info: Data from consolidated financial statements.
(1)
Current ratio of C Company and P Company
C Company
P Company
Explanation:
Current ratio is used to determine the relationship between current assets and current liabilities. The ideal current ratio is 2:1
Formula:
Thus, current ratio for C Company and P Company is 1.28:1 and 1.44:1 respectively.
(2)
Accounts Receivable Turnover Ratio of C Company and P Company
C Company
P 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:
Thus, accounts receivable turnover ratio for C Company and P Company is 9.1 times and 9.3 times respectively.
(3)
Average collection period of C Company and P Company
C Company
P Company
Explanation:
Average collection period is used to determine the number of days a particular company takes to collect accounts receivables.
Formula:
Thus, average collection period for C Company and P Company is 40.1 days and 39.2 days respectively.
(4)
Inventory Turnover Ratio of C Company and P Company
C Company
P Company
Explanation:
Inventory turnover ratio is used to determine the number of times inventory used or sold during the particular accounting period.
Formula:
Thus, inventory turnover ratio for C Company and P Company is 4.9 times and 7.8 times respectively.
(5)
Days in inventory of C Company and P Company
C Company
P Company
Conclusion:
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:
Thus, inventory turnover ratio for C Company and P Company is 74.5 days and 46.8 days.
Comment on the liquidity ratios:
P Company has better current ratio than the CC Company. P Company’s accounts receivable turnover ratio and average collection period are better than the CC Company. P’s inventory turnover ratio and days in inventory ratio are better than the CC Company. Therefore, on the whole, P Company is better in liquidity.
(b)
To compute: Solvency ratios for C Company and P Company
(b)
Explanation of Solution
Given info: Data from consolidated financial statements.
(1)
Debt to assets ratio of C Company and P Company
C Company
P 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 CC Company and P Company are 49% and 58% respectively.
(2)
Times interest earned ratio of C Company and P Company
C Company
P 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 C Company and P Company are 26.0 times and 21.3 times.
3.
C Company
P 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 $2,393 and $1,936 respectively.
Comment on the solvency ratios:
C Company has better debt to assets ratio than the P Company. C Company has better times interest earned ratio than the P Company. C Company has better free cash flow than the P Company. Therefore, on the whole, C Company is better in solvency.
(c)
To compute: Profitability ratios for C Company and P Company
(c)
Explanation of Solution
Given info: Data from consolidated financial statements.
(1)
C Company
P 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 C Company and P Company is 22.0% and 13.8% respectively.
(2)
Asset turnover ratio for C Company and P Company
C Company
P Company
Explanation:
Asset turnover ratio is used to determine the asset’s efficiency towards sales.
Formula:
Hence, asset turnover ratio for C Company and P Company is 0.69 times and 1.14 times respectively.
(3)
Return on assets for C Company and P Company
C Company
P Company
Explanation
Return on assets determines the particular company’s overall earning power.
Formula:
Thus, the return on assets ratio for C Company and P Company is 15.3% and 15.7% respectively.
d)
Return on common stockholders’ equity ratio for C Company and P Company
d)
Explanation of Solution
C Company
P Company
Explanation:
Rate of return on stockholders’ equity is used to determine the relationship between the net income and the average common equity that are invested in the company.
Formula:
Hence, return on stockholders’ equity for C Company and P Company are 30.1% and 40.8% respectively.
Comment on the profitability ratios
C Company has better profit margin ratio when compared to P Company. P Company has better asset turnover ratio than the C Company. P Company has better return on asset ratio than the C Company. P Company has better return on stockholders’ equity ratio than the CC Company. Therefore, P Company is better than CC Company in terms of profitability.
Want to see more full solutions like this?
Chapter 13 Solutions
Financial Accounting: Tools for Business Decision Making, 8th Edition
- c. Compute the quick ratio for each company. Round your answers to one decimal place. Abercrombie: The Gap: Current assets: Analyze and compare Abercrombie & Fitch and The Gap Abercrombie & Fitch Co. (ANF) and The Gap, Inc. (GPS) are two U.S. apparel retailers. The current assets and current liabilities for each company from recent balance sheets are as follows (in thousands): Cash Accounts receivable Inventories X Other current assets Total current assets Current liabilities: Accounts payable Other current liabilities Total current liabilities X Abercrombie & Fitch The Gap $723,135 $1,364,000 73,112 290,000 437,879 2,156,000 101,824 706,000 $1,335,950 $4,516,000 $226,878 332,039 $558,917 $1,174,000 2,035,000 $3,209,000arrow_forwardAnalyze and compare Hilton and Marriott Hilton Worldwide Holdings, Inc. (HLT) and Marriott International, Inc. (MAR) are two of the largest hotel operators in the world. Selected financial information from recent income statements for both companies follows (in millions): a. Compute the times interest earned ratio for each company. Round to one decimal place. b. Which company appears to better protect creditor interest? Why?arrow_forwardAnalyze and compare Zynga, Electronic Arts, and Take-Two Data (in millions) from recent financial statements of Zynga Inc. (ZNGA), Electronic Arts Inc. (EA), and Take-Two Interactive Software, Inc. (TTWO) are as follows: a. Compute the working capital for Year 2 and Year 1 for each company. b. Which company has the largest working capital? c. Compute the current ratio for Year 2 and Year 1 for each company. Round to one decimal place. d. For Year 2, rank the companies from most liquid to least liquid based upon the current ratio.arrow_forward
- Review problem—understanding liquidity measures Assume that the currentratio for Arch Company is 2.0, its acid-test ratio is 1.5, and its working capital is$300,000. Answer each of the following questions independently, always referring tothe original information.a. How much does the firm have in current liabilities?b. If the only current assets shown on the balance sheet for Arch Company areCash, Accounts Receivable, and Merchandise Inventory, how much does thefirm have in Merchandise Inventory?c. If the firm collects an account receivable of $100,000, what will its new currentratio and working capital be?d. If the firm pays an account payable of $100,000, what will its new current ratioand working capital be?e. If the firm sells inventory that was purchased for $50,000 at a cash price of$60,000, what will its new acid-test ratio be?arrow_forward! Required information Benchmark Assignment - Coca-Cola Co. & Pepsico Inc. You will need to use the data below from the two companies to calculate problems and answer the following questions. Note: Round your answer to 2 decimal places. Coca-Cola Co. (in millions) $38,655 $9,771 $22,545 1 2 3 Net Revenue (Sales) Net Income Current Assets Current Liabilities Cash & Cash Equivalents Accounts (Trade) Receivables Total Assets (12/31/21) Total Assets (12/31/20) Total Liabilities (12/31/21) Stockholders Equity (12/31/21) Stockholders Equity (12/31/20) Calculate the debt ratio and debt/equity ratio for each company. A с Pepsico Inc. Debt Ratio Debt/Equity Ratio $19,950 $12,625 $3,512 $94,354 $87,296 $69,494 $23,000 $19,300 B Coca-Cola Co. Pepsico Inc. (in millions) $79,474 $7,618 $21,783 $26,220 $5,988 $8,680 $92,377 $92,918 $76,226 $16,043 $13,454arrow_forwardC. Comparative Financial data for the two companies are shown below: Cash Accounts Receivable Inventories Prepaid Expenses Other Assets (net) Current Liabilities Mortgage Payable Owner's Equity Sales (all on credit) Gross Profit rate on Sales Number of Business days, 360 TIKTAK CORP. P67,832 a. Inventory Turnover b. Average age of inventory c. Accounts receivable turnover 84,480 71,280 12,000 353,388 126,694 50,000 412,286 844,800 32.5% METATA CORP. P 17,100 27,600 26,496 3,000 173,124 48,392 100,000 98,928 165,600 20% Required: 1. Determine which of the two companies has the more liquid current assets by developing the following ratios: d. Average collection period 2. Determine which of the two companies has the more total liquid assets. 3. Determine which of the two companies is generally more stable.arrow_forward
- Benchmark Assignment - Coca-Cola Co. & Pepsico Inc. You will need to use the data below from the two companies to calculate problems and answer the following questions. Note: Round your answer to 2 decimal places. Coca-Cola Co. (in millions) $38,655 $9,771 $22,545 1 2 3 Net Revenue (Sales) Net Income Current Assets Current Liabilities Cash & Cash Equivalents Accounts (Trade) Receivables Total Assets (12/31/21) Total Assets (12/31/20) Total Liabilities (12/31/21) Stockholders Equity (12/31/21) Stockholders Equity (12/31/20) Calculate the debt ratio and debt/equity ratio for each company. B C Coca-Cola Co. Pepsico Inc. A $19,950 $12,625 $3,512 $94,354 $87,296 $69,494 $23,000 $19,300 Debt Ratio Debt/Equity Ratio Pepsico Inc. (in millions) $79,474 $7,618 $21,783 $26,220 $5,988 $8,680 $92,377 $92,918 $76,226 $16,043 $13,454 @arrow_forwardRequired Information [The following information applies to the questions displayed below.] Summary information from the financial statements of two companies competing in the same industry follows. Data from the current year- end balance sheets Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Current liabilities Long-term notes payable Common stock, $5 par value Retained earnings Total liabilities and equity Bar co Kyan Barco Company (a) Company $ 21,500 40,400 84,440 6,100 340,000 $492,440 $ 537,950 For both companies compute the profit margin ratio. Numerator. T T Kyan Company $36,000 57,400 $ 65,340 80,800 210,000 136,300 $492,440 $ 537,950 $ 92, 300 105, 000 206,000 134, 650 132, 500 7,650 304, 400 Complete this question by entering your answers in the tabs below. Profit Margin Ratio 2A Prof Mar Ratio ZA Prof Mar ZA Tot Asset ZA Ret on Tot ZA Ret On 2A Price Eam Ratio Tum Assets Equity Ratio Data from…arrow_forwardComparing Income Statements and Balance Sheets of CompetitorsFollowing are selected income statement and balance sheet data from two retailers: Abercrombie & Fitch (clothing retailer in the high-end market) and TJX Companies (clothing retailer in the value-priced market). (a) Express each income statement amount as a percentage of sales. Round your answers to one decimal place (ex: 0.2345 = 23.5%). Income Statement ($ millions) ANF TJX Sales $4,680 $21,058 Cost of goods sold 1,599 Answer 16,021 Answer Gross profit 3,081 Answer 5,037 Answer Total expenses 2,435 Answer 4,003 Answer Net income $ 646 Answer $ 1,034 Answer (b) Express each balance sheet amount as a percentage of total assets. Round your answers to one decimal place (ex: 0.2345 = 23.5%). Balance Sheet ($ millions) ANF TJX Current assets $1,010 Answer $3,929 Answer Long-term assets 1,627 Answer 2,608 Answer Total assets…arrow_forward
- Exercises 1. Selected data from the Tatum Company are presented below: Total assets Average assets Net income Net sales Average common stockholders' equity Net cash provided by operating activities P1,500,000 1,700,000 275,000 1,400,000 1,000,000 275,000 Instructions Calculate the profitability ratios that can be computed from the above information. a. Profit Margin? b. Assets Turnover C. ROA d. ROEarrow_forwardGrammatico Company has just completed its third year of operations. The income statement is as follows: Selected information from the balance sheet is as follows: Required: Note: Round answers to two decimal places. 1. Compute the times-interest-earned ratio. 2. Compute the debt ratio. 3. CONCEPTUAL CONNECTION Assume that the lower quartile, median, and upper quartile values for debt and times-interest-earned ratios in Grammaticos industry are as follows: How does Grammatico compare with the industrial norms? Does it have too much debt?arrow_forwardFIN ANCIAL RATIO S Based on the financial statements for Jackson Enterprises (income statement, statement of owner’s equity, and balance sheet) shown on pages 596–597, prepare the following financial ratios. All sales are credit sales. The Accounts Receivable balance on January 1, 20--, was $21,600.1. Working capital2. Current ratio3. Quick ratio4. Return on owner’s equity5. Accounts receivable turnover and average number of days required to collect receivables6. Inventory turnover and average number of days required to sell inventoryarrow_forward
- College 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 LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub